132: If l_period_type is null THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
136: FROM fnd_profile_options_tl
137: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
138: AND language=userenv('LANG');
139:
140: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
208: select count(*) into org_count from pa_implementations;
209:
210: IF l_default_calendar is null THEN
211: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
212: FROM fnd_profile_options_tl
213: WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
214: AND language=userenv('LANG');
215:
216: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
373: If l_period_type is null THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375:
376: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
377: FROM fnd_profile_options_tl
378: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
379: AND language=userenv('LANG');
380:
381: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
439: select count(*) into org_count from pa_implementations;
440:
441: IF l_default_calendar is null THEN
442: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
443: FROM fnd_profile_options_tl
444: WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
445: AND language=userenv('LANG');
446:
447: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',