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_GLOBAL

Line 9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

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:
12: ----------------------------------------------------------------------------------------
13:

Line 10: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;

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:
12: ----------------------------------------------------------------------------------------
13:
14: function G_PA_MISS_NUM return number

Line 807: x_created_by := FND_GLOBAL.USER_ID;

803: x_err_code := 0;
804: l_old_stack := x_err_stack;
805: x_err_stack := x_err_stack || '->summerize_project_totals';
806:
807: x_created_by := FND_GLOBAL.USER_ID;
808: x_last_update_login := FND_GLOBAL.LOGIN_ID;
809:
810: -- Get the project_totals
811: x_err_stage := 'get project totals <' || to_char(x_budget_version_id)

Line 808: x_last_update_login := FND_GLOBAL.LOGIN_ID;

804: l_old_stack := x_err_stack;
805: x_err_stack := x_err_stack || '->summerize_project_totals';
806:
807: x_created_by := FND_GLOBAL.USER_ID;
808: x_last_update_login := FND_GLOBAL.LOGIN_ID;
809:
810: -- Get the project_totals
811: x_err_stage := 'get project totals <' || to_char(x_budget_version_id)
812: || '>';

Line 1800: l_resp_id := FND_GLOBAL.Resp_id;

1796:
1797: END IF;
1798: --------------------------------------------------------------------------------
1799:
1800: l_resp_id := FND_GLOBAL.Resp_id;
1801: l_user_id := FND_GLOBAL.User_id;
1802: l_login_id := FND_GLOBAL.Login_id;
1803:
1804: l_module_name := 'GMS_PM_CREATE_DRAFT_BUDGET';

Line 1801: l_user_id := FND_GLOBAL.User_id;

1797: END IF;
1798: --------------------------------------------------------------------------------
1799:
1800: l_resp_id := FND_GLOBAL.Resp_id;
1801: l_user_id := FND_GLOBAL.User_id;
1802: l_login_id := FND_GLOBAL.Login_id;
1803:
1804: l_module_name := 'GMS_PM_CREATE_DRAFT_BUDGET';
1805:

Line 1802: l_login_id := FND_GLOBAL.Login_id;

1798: --------------------------------------------------------------------------------
1799:
1800: l_resp_id := FND_GLOBAL.Resp_id;
1801: l_user_id := FND_GLOBAL.User_id;
1802: l_login_id := FND_GLOBAL.Login_id;
1803:
1804: l_module_name := 'GMS_PM_CREATE_DRAFT_BUDGET';
1805:
1806: -- As part of enforcing award security, which would determine

Line 2776: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

2772: l_app_short_name VARCHAR2(30); -- used for summarizing project budgets
2773: l_return_status VARCHAR2(30); -- used for summarizing project budgets and gms_sweeping
2774: l_dummy_num NUMBER;
2775: l_dummy_char VARCHAR2(255);
2776: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
2777: l_packet_id NUMBER;
2778: v_project_start_date DATE;
2779: v_project_completion_date DATE;
2780: l_user_profile_value1 VARCHAR2(30);

Line 2888: l_resp_id := FND_GLOBAL.Resp_id;

2884: open l_award_csr(l_award_id);
2885: fetch l_award_csr into l_award_number;
2886: close l_award_csr;
2887:
2888: l_resp_id := FND_GLOBAL.Resp_id;
2889: l_user_id := FND_GLOBAL.User_id;
2890: l_login_id := FND_GLOBAL.Login_id;
2891:
2892: l_module_name := 'GMS_PM_BASELINE_BUDGET';

Line 2889: l_user_id := FND_GLOBAL.User_id;

2885: fetch l_award_csr into l_award_number;
2886: close l_award_csr;
2887:
2888: l_resp_id := FND_GLOBAL.Resp_id;
2889: l_user_id := FND_GLOBAL.User_id;
2890: l_login_id := FND_GLOBAL.Login_id;
2891:
2892: l_module_name := 'GMS_PM_BASELINE_BUDGET';
2893:

Line 2890: l_login_id := FND_GLOBAL.Login_id;

2886: close l_award_csr;
2887:
2888: l_resp_id := FND_GLOBAL.Resp_id;
2889: l_user_id := FND_GLOBAL.User_id;
2890: l_login_id := FND_GLOBAL.Login_id;
2891:
2892: l_module_name := 'GMS_PM_BASELINE_BUDGET';
2893:
2894: -- As part of enforcing award security, which would determine

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

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

Line 3797: AND v.level_value = fnd_global.user_id;

3793: fnd_profile_option_values v
3794: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
3795: AND v.profile_option_id = p.profile_option_id
3796: AND v.level_id = 10004
3797: AND v.level_value = fnd_global.user_id;
3798:
3799: EXCEPTION
3800:
3801: WHEN no_data_found THEN

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

3805: l_user_profile_value1 := null;
3806:
3807: END;
3808:
3809: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
3810: end if;
3811:
3812: 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);
3813: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then

Line 3812: 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);

3808:
3809: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', 'Y', 'USER', fnd_global.user_id);
3810: end if;
3811:
3812: 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);
3813: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then
3814:
3815: BEGIN
3816:

Line 3824: AND v.level_value = fnd_global.user_id;

3820: fnd_profile_option_values v
3821: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
3822: AND v.profile_option_id = p.profile_option_id
3823: AND v.level_id = 10004
3824: AND v.level_value = fnd_global.user_id;
3825:
3826: EXCEPTION
3827:
3828: WHEN no_data_found THEN

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

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

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

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

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

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

Line 4281: l_resp_id := FND_GLOBAL.Resp_id;

4277: APP_EXCEPTION.RAISE_EXCEPTION;
4278:
4279: END IF;
4280:
4281: l_resp_id := FND_GLOBAL.Resp_id;
4282: l_user_id := FND_GLOBAL.User_id;
4283: l_login_id := FND_GLOBAL.Login_id;
4284: l_module_name := 'GMS_PM_ADD_BUDGET_LINE';
4285:

Line 4282: l_user_id := FND_GLOBAL.User_id;

4278:
4279: END IF;
4280:
4281: l_resp_id := FND_GLOBAL.Resp_id;
4282: l_user_id := FND_GLOBAL.User_id;
4283: l_login_id := FND_GLOBAL.Login_id;
4284: l_module_name := 'GMS_PM_ADD_BUDGET_LINE';
4285:
4286: -- As part of enforcing award security, which would determine

Line 4283: l_login_id := FND_GLOBAL.Login_id;

4279: END IF;
4280:
4281: l_resp_id := FND_GLOBAL.Resp_id;
4282: l_user_id := FND_GLOBAL.User_id;
4283: l_login_id := FND_GLOBAL.Login_id;
4284: l_module_name := 'GMS_PM_ADD_BUDGET_LINE';
4285:
4286: -- As part of enforcing award security, which would determine
4287: -- whether the user has the necessary privileges to update the award

Line 5262: l_resp_id := FND_GLOBAL.Resp_id;

5258: APP_EXCEPTION.RAISE_EXCEPTION;
5259: END IF;
5260: --------------------------------------------------------------------------------
5261:
5262: l_resp_id := FND_GLOBAL.Resp_id;
5263: l_user_id := FND_GLOBAL.User_id;
5264: l_module_name := 'GMS_PM_DELETE_DRAFT_BUDGET';
5265:
5266: -- As part of enforcing award security, which would determine

Line 5263: l_user_id := FND_GLOBAL.User_id;

5259: END IF;
5260: --------------------------------------------------------------------------------
5261:
5262: l_resp_id := FND_GLOBAL.Resp_id;
5263: l_user_id := FND_GLOBAL.User_id;
5264: l_module_name := 'GMS_PM_DELETE_DRAFT_BUDGET';
5265:
5266: -- As part of enforcing award security, which would determine
5267: -- whether the user has the necessary privileges to update the award

Line 5720: l_resp_id := FND_GLOBAL.Resp_id;

5716: APP_EXCEPTION.RAISE_EXCEPTION;
5717: END IF;
5718: --------------------------------------------------------------------------------
5719:
5720: l_resp_id := FND_GLOBAL.Resp_id;
5721: l_user_id := FND_GLOBAL.User_id;
5722: l_login_id := FND_GLOBAL.Login_id;
5723: l_module_name := 'GMS_PM_DELETE_BUDGET_LINE';
5724:

Line 5721: l_user_id := FND_GLOBAL.User_id;

5717: END IF;
5718: --------------------------------------------------------------------------------
5719:
5720: l_resp_id := FND_GLOBAL.Resp_id;
5721: l_user_id := FND_GLOBAL.User_id;
5722: l_login_id := FND_GLOBAL.Login_id;
5723: l_module_name := 'GMS_PM_DELETE_BUDGET_LINE';
5724:
5725: -- As part of enforcing award security, which would determine

Line 5722: l_login_id := FND_GLOBAL.Login_id;

5718: --------------------------------------------------------------------------------
5719:
5720: l_resp_id := FND_GLOBAL.Resp_id;
5721: l_user_id := FND_GLOBAL.User_id;
5722: l_login_id := FND_GLOBAL.Login_id;
5723: l_module_name := 'GMS_PM_DELETE_BUDGET_LINE';
5724:
5725: -- As part of enforcing award security, which would determine
5726: -- whether the user has the necessary privileges to update the award

Line 6043: l_last_updated_by := fnd_global.user_id;

6039:
6040: delete from gms_budget_lines
6041: where rowid = l_budget_line_rowid;
6042:
6043: l_last_updated_by := fnd_global.user_id;
6044: l_last_update_login := fnd_global.login_id;
6045:
6046: select budget_version_id
6047: into l_budget_version_id

Line 6044: l_last_update_login := fnd_global.login_id;

6040: delete from gms_budget_lines
6041: where rowid = l_budget_line_rowid;
6042:
6043: l_last_updated_by := fnd_global.user_id;
6044: l_last_update_login := fnd_global.login_id;
6045:
6046: select budget_version_id
6047: into l_budget_version_id
6048: from gms_resource_assignments

Line 6497: l_resp_id := FND_GLOBAL.Resp_id;

6493: END IF;
6494: --------------------------------------------------------------------------------
6495: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6496:
6497: l_resp_id := FND_GLOBAL.Resp_id;
6498: l_user_id := FND_GLOBAL.User_id;
6499: l_login_id := FND_GLOBAL.Login_id;
6500:
6501: l_module_name := 'GMS_PM_UPDATE_BUDGET';

Line 6498: l_user_id := FND_GLOBAL.User_id;

6494: --------------------------------------------------------------------------------
6495: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6496:
6497: l_resp_id := FND_GLOBAL.Resp_id;
6498: l_user_id := FND_GLOBAL.User_id;
6499: l_login_id := FND_GLOBAL.Login_id;
6500:
6501: l_module_name := 'GMS_PM_UPDATE_BUDGET';
6502:

Line 6499: l_login_id := FND_GLOBAL.Login_id;

6495: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6496:
6497: l_resp_id := FND_GLOBAL.Resp_id;
6498: l_user_id := FND_GLOBAL.User_id;
6499: l_login_id := FND_GLOBAL.Login_id;
6500:
6501: l_module_name := 'GMS_PM_UPDATE_BUDGET';
6502:
6503: -- As part of enforcing award security, which would determine

Line 7184: l_resp_id := FND_GLOBAL.Resp_id;

7180: --------------------------------------------------------------------------------
7181:
7182: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7183:
7184: l_resp_id := FND_GLOBAL.Resp_id;
7185: l_user_id := FND_GLOBAL.User_id;
7186: l_login_id := FND_GLOBAL.login_id;
7187:
7188: l_module_name := 'GMS_PM_UPDATE_BUDGET_LINE';

Line 7185: l_user_id := FND_GLOBAL.User_id;

7181:
7182: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7183:
7184: l_resp_id := FND_GLOBAL.Resp_id;
7185: l_user_id := FND_GLOBAL.User_id;
7186: l_login_id := FND_GLOBAL.login_id;
7187:
7188: l_module_name := 'GMS_PM_UPDATE_BUDGET_LINE';
7189:

Line 7186: l_login_id := FND_GLOBAL.login_id;

7182: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7183:
7184: l_resp_id := FND_GLOBAL.Resp_id;
7185: l_user_id := FND_GLOBAL.User_id;
7186: l_login_id := FND_GLOBAL.login_id;
7187:
7188: l_module_name := 'GMS_PM_UPDATE_BUDGET_LINE';
7189:
7190: -- As part of enforcing award security, which would determine