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.

[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on FND_PROFILE

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

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

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

3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3508:
3509: END IF;
3510:
3511: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3512:
3513:
3514: pa_debug.set_curr_function( p_function => 'baseline_budget',
3515: p_debug_mode => l_debug_mode );

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

5245: SAVEPOINT add_budget_line_pub;
5246:
5247: p_msg_count := 0;
5248: p_return_status := FND_API.G_RET_STS_SUCCESS;
5249: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5250: l_module_name := g_module_name || ':Add_Budget_Line';
5251:
5252: IF ( l_debug_mode = 'Y' )
5253: THEN

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

6262: END IF;
6263:
6264: p_msg_count := 0;
6265: p_return_status := FND_API.G_RET_STS_SUCCESS;
6266: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6267:
6268: IF ( l_debug_mode = 'Y' )
6269: THEN
6270: pa_debug.set_curr_function( p_function => 'delete_draft_budget',

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

6943: UPDATE pa_proj_fp_options
6944: SET gen_src_cost_plan_version_id = NULL,
6945: record_version_number = record_version_number + 1,
6946: last_update_date = SYSDATE,
6947: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6948: last_update_login = FND_GLOBAL.LOGIN_ID
6949: WHERE project_id = l_project_id
6950: AND gen_src_cost_plan_version_id = l_budget_version_id;
6951: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

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

6953: UPDATE pa_proj_fp_options
6954: SET gen_src_rev_plan_version_id = NULL,
6955: record_version_number = record_version_number + 1,
6956: last_update_date = SYSDATE,
6957: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6958: last_update_login = FND_GLOBAL.LOGIN_ID
6959: WHERE project_id = l_project_id
6960: AND gen_src_rev_plan_version_id = l_budget_version_id;
6961: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

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

6963: UPDATE pa_proj_fp_options
6964: SET gen_src_all_plan_version_id = NULL,
6965: record_version_number = record_version_number + 1,
6966: last_update_date = SYSDATE,
6967: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6968: last_update_login = FND_GLOBAL.LOGIN_ID
6969: WHERE project_id = l_project_id
6970: AND gen_src_all_plan_version_id = l_budget_version_id;
6971: END IF;

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

6976: IF SQL%ROWCOUNT > 0 THEN
6977: UPDATE pa_budget_versions
6978: SET record_version_number = record_version_number + 1,
6979: last_update_date = SYSDATE,
6980: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6981: last_update_login = FND_GLOBAL.LOGIN_ID
6982: WHERE project_id = l_project_id
6983: AND budget_version_id = l_budget_version_id;
6984: END IF;

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

7258: SAVEPOINT delete_baseline_budget_pub;
7259:
7260: p_msg_count := 0;
7261: p_return_status := FND_API.G_RET_STS_SUCCESS;
7262: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
7263:
7264: IF ( l_debug_mode = 'Y' )
7265: THEN
7266: pa_debug.set_curr_function( p_function => 'delete_baseline_budget',

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

7856: UPDATE pa_proj_fp_options
7857: SET gen_src_cost_plan_version_id = NULL,
7858: record_version_number = record_version_number + 1,
7859: last_update_date = SYSDATE,
7860: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7861: last_update_login = FND_GLOBAL.LOGIN_ID
7862: WHERE project_id = l_project_id
7863: AND gen_src_cost_plan_version_id = l_budget_version_id;
7864: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

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

7866: UPDATE pa_proj_fp_options
7867: SET gen_src_rev_plan_version_id = NULL,
7868: record_version_number = record_version_number + 1,
7869: last_update_date = SYSDATE,
7870: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7871: last_update_login = FND_GLOBAL.LOGIN_ID
7872: WHERE project_id = l_project_id
7873: AND gen_src_rev_plan_version_id = l_budget_version_id;
7874: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

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

7876: UPDATE pa_proj_fp_options
7877: SET gen_src_all_plan_version_id = NULL,
7878: record_version_number = record_version_number + 1,
7879: last_update_date = SYSDATE,
7880: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7881: last_update_login = FND_GLOBAL.LOGIN_ID
7882: WHERE project_id = l_project_id
7883: AND gen_src_all_plan_version_id = l_budget_version_id;
7884: END IF;

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

7889: IF SQL%ROWCOUNT > 0 THEN
7890: UPDATE pa_budget_versions
7891: SET record_version_number = record_version_number + 1,
7892: last_update_date = SYSDATE,
7893: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7894: last_update_login = FND_GLOBAL.LOGIN_ID
7895: WHERE project_id = l_project_id
7896: AND budget_version_id = l_budget_version_id;
7897: END IF;

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

8262: SAVEPOINT delete_budget_line_pub;
8263:
8264: p_msg_count := 0;
8265: p_return_status := FND_API.G_RET_STS_SUCCESS;
8266: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8267: l_module_name := g_module_name || ':Delete_Budget_Line ';
8268:
8269: IF ( l_debug_mode = 'Y' )
8270: THEN

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

13320: SAVEPOINT update_budget_line_pub;
13321:
13322: p_msg_count := 0;
13323: p_return_status := FND_API.G_RET_STS_SUCCESS;
13324: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
13325: l_module_name := g_module_name || ':Update_Budget_Line ';
13326:
13327: IF ( l_debug_mode = 'Y' )
13328: THEN

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

14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14485: l_ci_id pa_budget_versions.ci_id%TYPE;
14486:
14487: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14488: l_debug_level3 CONSTANT NUMBER := 3;
14489: l_debug_level5 CONSTANT NUMBER := 5;
14490:
14491: l_plsql_max_array_size NUMBER := 200;

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

17610:
17611: x_msg_count := 0;
17612: x_return_status := FND_API.G_RET_STS_SUCCESS;
17613: pa_debug.set_err_stack('PA_BUDGET_PUB.CREATE_DRAFT_FINPLAN');
17614: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
17615: l_debug_mode := NVL(l_debug_mode, 'Y');
17616:
17617: IF ( l_debug_mode = 'Y' )
17618: THEN

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

17621: pa_debug.write('CREATE_DRAFT_FINPLAN: ' || g_module_name,pa_debug.g_err_stage,2);
17622: END IF;
17623:
17624: l_msg_count := 0;
17625: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
17626: l_module_name := 'create_draft_finplan' || g_module_name;
17627:
17628: IF ( l_debug_mode = 'Y' )
17629: THEN

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

19479: -- Set the error stack.
19480: pa_debug.set_err_stack('PA_BUDGET_PUB.update_plannning_element_attr');
19481:
19482: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
19483: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
19484: l_debug_mode := NVL(l_debug_mode, 'Y');
19485:
19486: -- Initialize the return status to success
19487: x_return_status := FND_API.G_RET_STS_SUCCESS;