eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_BUDGET_PUB dependencies on FND_PROFILE

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

3:
4: /* package global to be used during updates */
5:
6: -- To check on, whether to print debug messages in log file or not
7: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
8:
9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
10: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
11:

Line 2785: l_funds_check_at_submit VARCHAR2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_FUNDS_CHECK_AT_SUBMIT'),'Y'); -- Bug 2290959

2781: l_user_profile_value1 VARCHAR2(30);
2782: l_set_profile_success1 BOOLEAN := FALSE;
2783: l_user_profile_value2 VARCHAR2(30);
2784: l_set_profile_success2 BOOLEAN := FALSE;
2785: l_funds_check_at_submit VARCHAR2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_FUNDS_CHECK_AT_SUBMIT'),'Y'); -- Bug 2290959
2786: l_wf_enabled_flag VARCHAR2(1);--Added for bug 5620089
2787: BEGIN
2788:
2789: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

Line 3786: l_user_profile_value1 := fnd_profile.value_specific('PA_SUPER_PROJECT', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);

3782: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Project Budget Summarization ', 'C');
3783: END IF;
3784:
3785: -- Bug 2386041
3786: l_user_profile_value1 := fnd_profile.value_specific('PA_SUPER_PROJECT', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
3787: if ((l_user_profile_value1 = 'N') OR (l_user_profile_value1 is null)) then
3788:
3789: BEGIN
3790:

Line 3793: FROM fnd_profile_options p,

3789: BEGIN
3790:
3791: SELECT profile_option_value
3792: INTO l_user_profile_value1
3793: FROM fnd_profile_options p,
3794: fnd_profile_option_values v
3795: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
3796: AND v.profile_option_id = p.profile_option_id
3797: AND v.level_id = 10004

Line 3794: fnd_profile_option_values v

3790:
3791: SELECT profile_option_value
3792: INTO l_user_profile_value1
3793: FROM fnd_profile_options p,
3794: fnd_profile_option_values v
3795: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
3796: AND v.profile_option_id = p.profile_option_id
3797: AND v.level_id = 10004
3798: AND v.level_value = fnd_global.user_id;

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

3806: l_user_profile_value1 := null;
3807:
3808: END;
3809:
3810: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
3811: end if;
3812:
3813: l_user_profile_value2 := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
3814: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then

Line 3813: l_user_profile_value2 := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);

3809:
3810: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
3811: end if;
3812:
3813: l_user_profile_value2 := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
3814: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then
3815:
3816: BEGIN
3817:

Line 3820: FROM fnd_profile_options p,

3816: BEGIN
3817:
3818: SELECT profile_option_value
3819: INTO l_user_profile_value2
3820: FROM fnd_profile_options p,
3821: fnd_profile_option_values v
3822: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
3823: AND v.profile_option_id = p.profile_option_id
3824: AND v.level_id = 10004

Line 3821: fnd_profile_option_values v

3817:
3818: SELECT profile_option_value
3819: INTO l_user_profile_value2
3820: FROM fnd_profile_options p,
3821: fnd_profile_option_values v
3822: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
3823: AND v.profile_option_id = p.profile_option_id
3824: AND v.level_id = 10004
3825: AND v.level_value = fnd_global.user_id;

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

3833: l_user_profile_value2 := null;
3834:
3835: END;
3836:
3837: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', 'Y', 'USER', fnd_global.user_id);
3838:
3839: end if;
3840:
3841:

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

3851: , ERRBUF => x_err_stage);
3852:
3853: -- Bug 2386041
3854: if (l_set_profile_success1 = TRUE) then
3855: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
3856: end if;
3857: if (l_set_profile_success2 = TRUE) then
3858: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
3859: end if;

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

3854: if (l_set_profile_success1 = TRUE) then
3855: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
3856: end if;
3857: if (l_set_profile_success2 = TRUE) then
3858: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
3859: end if;
3860: -- Bug 2386041
3861:
3862: -- Fix for bug : 5511910. We retrun stasus values as 'P' if summarization does not happen.