APPS.GMS_SUMMARIZE_BUDGETS dependencies on FND_PROFILE

Line 5: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');

1: PACKAGE BODY GMS_SUMMARIZE_BUDGETS AS
2: -- $Header: gmsbusub.pls 120.2 2007/02/06 09:49:00 rshaik ship $
3:
4: -- To check on, whether to print debug messages in log file or not
5: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
6: x_mixed_budgeting varchar2(1);
7:
8: -- Bug 2587078 : Modified parameter name from x_err_code to x_return_status
9: -- to bring the code in consistency with existing grants code

Line 142: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');

138: l_validate_profile := 'N' ;
139: L_res_categorized := 'N' ;
140:
141: IF l_bem_count >= 1 and l_res_list_count > 1 then
142: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');
143: if G_project_bem IS NOT NULL then
144: l_res_categorized := 'N' ;
145: l_validate_profile := 'Y' ;
146: else

Line 176: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');

172:
173: end if;
174:
175: IF l_bem_count > 1 and l_res_list_count = 1 and l_res_list_name = 'None' then
176: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');
177: l_res_categorized := 'N' ;
178: l_validate_profile := 'Y' ;
179: END IF ;
180:

Line 182: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_CATEGORIZED');

178: l_validate_profile := 'Y' ;
179: END IF ;
180:
181: IF l_bem_count > 1 and l_res_list_count = 1 and l_res_list_name <> 'None' then
182: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_CATEGORIZED');
183: L_res_categorized := 'Y' ;
184: l_validate_profile := 'Y' ;
185: END IF ;
186:

Line 202: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');

198: where bv.budget_entry_method_code = bem.budget_entry_method_code
199: and bv.project_id = x_project_id ;
200:
201: IF l_time_phased_type_code = 'R' and l_res_list_name = 'None' then
202: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_UNCATEGORIZED');
203: l_res_categorized := 'N' ;
204: l_validate_profile := 'Y' ;
205: END IF ;
206:

Line 212: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_CATEGORIZED');

208:
209: IF L_DEBUG = 'Y' THEN
210: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Setting CAT profile : ','C');
211: end if ;
212: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_CATEGORIZED');
213: l_res_categorized := 'Y' ;
214: l_validate_profile := 'Y' ;
215:
216: END IF ;

Line 844: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);

840: -- Bug 3770971..need to set the profile values for "PA: Cross Project User - Update" and
841: -- "PA: Cross Project User - View". These values are lost after calling set_global_info
842: -- which calls fnd_global.apps_initialize.
843:
844: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
845: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', 'Y', 'USER', fnd_global.user_id);
846:
847: -- Bug 3770971 end. Values will be set back in gms_budget_pub after summarize_budgets is done.
848:

Line 845: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', 'Y', 'USER', fnd_global.user_id);

841: -- "PA: Cross Project User - View". These values are lost after calling set_global_info
842: -- which calls fnd_global.apps_initialize.
843:
844: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
845: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', 'Y', 'USER', fnd_global.user_id);
846:
847: -- Bug 3770971 end. Values will be set back in gms_budget_pub after summarize_budgets is done.
848:
849: -- Added for GMS enhancement 5583170