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.PA_BUDGET_PUB dependencies on FND_PROFILE

Line 286: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

282: --Standard begin of API savepoint
283: SAVEPOINT create_draft_budget_pub;
284: p_msg_count := 0;
285: p_return_status := FND_API.G_RET_STS_SUCCESS;
286: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
287: l_module_name := 'create_draft_budget' || g_module_name;
288:
289: -- Changes for bug 3182963
290: IF l_debug_mode = 'Y' THEN

Line 3439: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

3435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3436:
3437: END IF;
3438:
3439: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3440:
3441:
3442: pa_debug.set_curr_function( p_function => 'baseline_budget',
3443: p_debug_mode => l_debug_mode );

Line 5135: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5131: SAVEPOINT add_budget_line_pub;
5132:
5133: p_msg_count := 0;
5134: p_return_status := FND_API.G_RET_STS_SUCCESS;
5135: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5136: l_module_name := g_module_name || ':Add_Budget_Line';
5137:
5138: IF ( l_debug_mode = 'Y' )
5139: THEN

Line 6114: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

6110: END IF;
6111:
6112: p_msg_count := 0;
6113: p_return_status := FND_API.G_RET_STS_SUCCESS;
6114: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6115:
6116: IF ( l_debug_mode = 'Y' )
6117: THEN
6118: pa_debug.set_curr_function( p_function => 'delete_draft_budget',

Line 6795: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6791: UPDATE pa_proj_fp_options
6792: SET gen_src_cost_plan_version_id = NULL,
6793: record_version_number = record_version_number + 1,
6794: last_update_date = SYSDATE,
6795: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6796: last_update_login = FND_GLOBAL.LOGIN_ID
6797: WHERE project_id = l_project_id
6798: AND gen_src_cost_plan_version_id = l_budget_version_id;
6799: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

Line 6805: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6801: UPDATE pa_proj_fp_options
6802: SET gen_src_rev_plan_version_id = NULL,
6803: record_version_number = record_version_number + 1,
6804: last_update_date = SYSDATE,
6805: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6806: last_update_login = FND_GLOBAL.LOGIN_ID
6807: WHERE project_id = l_project_id
6808: AND gen_src_rev_plan_version_id = l_budget_version_id;
6809: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

Line 6815: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6811: UPDATE pa_proj_fp_options
6812: SET gen_src_all_plan_version_id = NULL,
6813: record_version_number = record_version_number + 1,
6814: last_update_date = SYSDATE,
6815: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6816: last_update_login = FND_GLOBAL.LOGIN_ID
6817: WHERE project_id = l_project_id
6818: AND gen_src_all_plan_version_id = l_budget_version_id;
6819: END IF;

Line 6828: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6824: IF SQL%ROWCOUNT > 0 THEN
6825: UPDATE pa_budget_versions
6826: SET record_version_number = record_version_number + 1,
6827: last_update_date = SYSDATE,
6828: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6829: last_update_login = FND_GLOBAL.LOGIN_ID
6830: WHERE project_id = l_project_id
6831: AND budget_version_id = l_budget_version_id;
6832: END IF;

Line 7108: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

7104: SAVEPOINT delete_baseline_budget_pub;
7105:
7106: p_msg_count := 0;
7107: p_return_status := FND_API.G_RET_STS_SUCCESS;
7108: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
7109:
7110: IF ( l_debug_mode = 'Y' )
7111: THEN
7112: pa_debug.set_curr_function( p_function => 'delete_baseline_budget',

Line 7706: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7702: UPDATE pa_proj_fp_options
7703: SET gen_src_cost_plan_version_id = NULL,
7704: record_version_number = record_version_number + 1,
7705: last_update_date = SYSDATE,
7706: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7707: last_update_login = FND_GLOBAL.LOGIN_ID
7708: WHERE project_id = l_project_id
7709: AND gen_src_cost_plan_version_id = l_budget_version_id;
7710: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

Line 7716: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7712: UPDATE pa_proj_fp_options
7713: SET gen_src_rev_plan_version_id = NULL,
7714: record_version_number = record_version_number + 1,
7715: last_update_date = SYSDATE,
7716: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7717: last_update_login = FND_GLOBAL.LOGIN_ID
7718: WHERE project_id = l_project_id
7719: AND gen_src_rev_plan_version_id = l_budget_version_id;
7720: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

Line 7726: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7722: UPDATE pa_proj_fp_options
7723: SET gen_src_all_plan_version_id = NULL,
7724: record_version_number = record_version_number + 1,
7725: last_update_date = SYSDATE,
7726: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7727: last_update_login = FND_GLOBAL.LOGIN_ID
7728: WHERE project_id = l_project_id
7729: AND gen_src_all_plan_version_id = l_budget_version_id;
7730: END IF;

Line 7739: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7735: IF SQL%ROWCOUNT > 0 THEN
7736: UPDATE pa_budget_versions
7737: SET record_version_number = record_version_number + 1,
7738: last_update_date = SYSDATE,
7739: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7740: last_update_login = FND_GLOBAL.LOGIN_ID
7741: WHERE project_id = l_project_id
7742: AND budget_version_id = l_budget_version_id;
7743: END IF;

Line 8102: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

8098: SAVEPOINT delete_budget_line_pub;
8099:
8100: p_msg_count := 0;
8101: p_return_status := FND_API.G_RET_STS_SUCCESS;
8102: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8103: l_module_name := g_module_name || ':Delete_Budget_Line ';
8104:
8105: IF ( l_debug_mode = 'Y' )
8106: THEN

Line 13098: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

13094: SAVEPOINT update_budget_line_pub;
13095:
13096: p_msg_count := 0;
13097: p_return_status := FND_API.G_RET_STS_SUCCESS;
13098: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
13099: l_module_name := g_module_name || ':Update_Budget_Line ';
13100:
13101: IF ( l_debug_mode = 'Y' )
13102: THEN

Line 14241: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14239: l_ci_id pa_budget_versions.ci_id%TYPE;
14240:
14241: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14242: l_debug_level3 CONSTANT NUMBER := 3;
14243: l_debug_level5 CONSTANT NUMBER := 5;
14244:
14245: l_plsql_max_array_size NUMBER := 200;

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

17350:
17351: x_msg_count := 0;
17352: x_return_status := FND_API.G_RET_STS_SUCCESS;
17353: pa_debug.set_err_stack('PA_BUDGET_PUB.CREATE_DRAFT_FINPLAN');
17354: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
17355: l_debug_mode := NVL(l_debug_mode, 'Y');
17356:
17357: IF ( l_debug_mode = 'Y' )
17358: THEN

Line 17365: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

17361: pa_debug.write('CREATE_DRAFT_FINPLAN: ' || g_module_name,pa_debug.g_err_stage,2);
17362: END IF;
17363:
17364: l_msg_count := 0;
17365: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
17366: l_module_name := 'create_draft_finplan' || g_module_name;
17367:
17368: IF ( l_debug_mode = 'Y' )
17369: THEN

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

19181: -- Set the error stack.
19182: pa_debug.set_err_stack('PA_BUDGET_PUB.update_plannning_element_attr');
19183:
19184: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
19185: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
19186: l_debug_mode := NVL(l_debug_mode, 'Y');
19187:
19188: -- Initialize the return status to success
19189: x_return_status := FND_API.G_RET_STS_SUCCESS;