App not showing in launcher

Your Intent-Filter seems to be wrong. Change to:

<activity
       android:name="com.pumpkin.activities.SplashScreenActivity"
       android:label="@string/app_name"
       android:screenOrientation="portrait" >
        <intent-filter>
            <action android:name="android.intent.action.MAIN" />
            <category android:name="android.intent.category.LAUNCHER" />
        </intent-filter>
        <intent-filter>
            <data android:scheme="pumpkin.com" android:host="open" />
            <action android:name="android.intent.action.VIEW" />
            <category android:name="android.intent.category.DEFAULT" />
            <category android:name="android.intent.category.BROWSABLE" />
        </intent-filter>
    </activity>