DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on FND_PROFILE

Line 5: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY pa_fp_upgrade_pkg AS
2: /* $Header: PAFPUPGB.pls 120.7.12010000.4 2009/02/09 12:09:03 spasala ship $*/
3:
4: l_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_upgrade_pkg';
5: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6: l_migration_code varchar2(1) := null;
7:
8: TYPE res_list_tbl IS TABLE OF
9: pa_resource_lists_all_bg.resource_list_id%TYPE INDEX BY BINARY_INTEGER;

Line 248: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

244: x_msg_count := 0;
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.Populate_Local_Variables');
248: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
249: l_debug_mode := NVL(l_debug_mode, 'Y');
250: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
251:
252: IF p_pa_debug_mode = 'Y' THEN

Line 973: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970: savepoint pa_fp_upgrade_pkg;
971:
972: pa_debug.init_err_stack('PA_FP_UPGRADE_PKG.Upgrade_Budget_Types');
973: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
974: l_debug_mode := NVL(l_debug_mode, 'Y');
975: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
976: IF p_pa_debug_mode = 'Y' THEN
977: pa_debug.g_err_stage := 'Entered Upgrade_Budget_Types';

Line 1391: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1387: x_msg_count := 0;
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389:
1390: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.Upgrade_Budget_Types');
1391: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1392: l_debug_mode := NVL(l_debug_mode, 'Y');
1393: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1394: IF p_pa_debug_mode = 'Y' THEN
1395: pa_debug.g_err_stage := 'Entered Upgrade_Budget_Types';

Line 1609: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1605: x_msg_count := 0;
1606: x_return_status := FND_API.G_RET_STS_SUCCESS;
1607:
1608: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.Create_fp_options');
1609: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1610: l_debug_mode := NVL(l_debug_mode, 'Y');
1611: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1612:
1613: IF p_pa_debug_mode = 'Y' THEN

Line 1854: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1850: x_msg_count := 0;
1851: x_return_status := FND_API.G_RET_STS_SUCCESS;
1852:
1853: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.Add_Plan_Types');
1854: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1855: l_debug_mode := NVL(l_debug_mode, 'Y');
1856: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1857: IF p_pa_debug_mode = 'Y' THEN
1858: pa_debug.g_err_stage := 'Entered Add_Plan_Types';

Line 2123: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2119: x_msg_data := NULL;
2120: x_return_status := FND_API.G_RET_STS_SUCCESS;
2121:
2122: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.Upgrade_Budget_Versions');
2123: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2124: l_debug_mode := NVL(l_debug_mode, 'Y');
2125: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2126: IF p_pa_debug_mode = 'Y' THEN
2127: pa_debug.g_err_stage := 'Entered Upgrade_Budget_Versions';

Line 2948: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2944:
2945: x_msg_count := 0;
2946: x_return_status := FND_API.G_RET_STS_SUCCESS;
2947: pa_debug.init_err_stack('PA_FP_UPGRADE_PKG.validate_budgets');
2948: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2949: l_debug_mode := NVL(l_debug_mode, 'Y');
2950: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2951:
2952: -- Check for business rules violations

Line 3261: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3257:
3258: x_msg_count := 0;
3259: x_return_status := FND_API.G_RET_STS_SUCCESS;
3260: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.VALIDATE_PROJECT');
3261: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3262: l_debug_mode := NVL(l_debug_mode, 'Y');
3263: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3264:
3265: -- Check for business rules violations

Line 3440: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3436:
3437: x_msg_count := 0;
3438: x_return_status := FND_API.G_RET_STS_SUCCESS;
3439: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.VALIDATE_PROJECT_PLAN_TYPE');
3440: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3441: l_debug_mode := NVL(l_debug_mode, 'Y');
3442: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3443:
3444: -- Check for business rules violations

Line 3688: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3684:
3685: x_msg_count := 0;
3686: x_return_status := FND_API.G_RET_STS_SUCCESS;
3687: pa_debug.set_err_stack('PA_FP_UPGRADE_PKG.validate_budget_version');
3688: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3689: l_debug_mode := NVL(l_debug_mode, 'Y');
3690: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3691:
3692: -- Check for business rules violations

Line 3825: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3821: BEGIN
3822:
3823: x_msg_count := 0;
3824: x_return_status := FND_API.G_RET_STS_SUCCESS;
3825: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3826: l_debug_mode := NVL(l_debug_mode, 'Y');
3827:
3828: -- Set curr function
3829: pa_debug.set_curr_function(

Line 4431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4427: savepoint rollup_rejected_bl_amounts;
4428:
4429: pa_debug.init_err_stack('PA_FP_UPGRADE_PKG.rollup_rejected_bl_amounts');
4430:
4431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4432: l_debug_mode := NVL(l_debug_mode, 'Y');
4433: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4434:
4435: IF p_pa_debug_mode = 'Y' THEN