DBA Data[Home] [Help]

APPS.PA_BUDGET_UTILS dependencies on FND_PROFILE

Line 10: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

6: -- Bug Fix: 4569365. Removed MRC code.
7: -- g_mrc_exception EXCEPTION;
8: Invalid_Arg_Exc EXCEPTION; -- Added for FPM, Tracking Bug No - 3354518.
9:
10: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
11: g_module_name VARCHAR2(100) := 'pa.plsql.PA_BUDGET_UTILS';
12:
13: procedure get_draft_version_id (x_project_id in number,
14: x_budget_type_code in varchar2,

Line 1770: x_created_by := to_number(fnd_profile.value('USER_ID'));

1766: pa_debug.set_err_stack('PA_BUDGET_UTILS.CREATE_DRAFT');
1767: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
1768: END IF;
1769:
1770: x_created_by := to_number(fnd_profile.value('USER_ID'));
1771: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1772:
1773: -- Get the baselined version
1774: x_err_stage := 'get baselined budget id <' || to_char(x_project_id)

Line 2170: x_created_by := to_number(fnd_profile.value('USER_ID'));

2166: open get_budget_type_code;
2167: fetch get_budget_type_code into v_budget_type_code;
2168: close get_budget_type_code;
2169:
2170: x_created_by := to_number(fnd_profile.value('USER_ID'));
2171: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2172:
2173: -- Get the project_totals
2174: x_err_stage := 'verify if resource assignment exists <'

Line 2546: x_created_by := to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id));

2542: pa_debug.set_err_stack('PA_BUDGET_UTILS.SUMMERIZE_PROJECT_TOTALS');
2543: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
2544: END IF;
2545:
2546: x_created_by := to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id));
2547: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2548:
2549: -- Get the project_totals
2550: x_err_stage := 'get project totals <' || to_char(x_budget_version_id)

Line 3293: l_federal_enabled := NVL(FND_PROFILE.value('FV_ENABLED'), 'N');

3289: END IF;
3290:
3291: /*Start - Changes for Federal Uptake - I */ -- Bug 5522880
3292:
3293: l_federal_enabled := NVL(FND_PROFILE.value('FV_ENABLED'), 'N');
3294:
3295: If(l_federal_enabled = 'Y' AND l_budget_type_code is NOT NULL) then
3296:
3297: Begin

Line 3383: l_federal_enabled := NVL(FND_PROFILE.value('FV_ENABLED'), 'N');

3379: END IF; --(l_err_code <> 0)
3380:
3381: /*Start - Changes for Federal Uptake - II */
3382:
3383: l_federal_enabled := NVL(FND_PROFILE.value('FV_ENABLED'), 'N');
3384:
3385: Select budget_type_code
3386: into l_budget_type_code
3387: from pa_budget_versions