DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on FND_PROFILE

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

11:
12:
13: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FP_WEBADI_UTILS';
14:
15: l_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
16:
17: PROCEDURE get_metadata_info(
18: p_budget_version_id IN NUMBER,
19: x_content_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 808: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');

804:
805: BEGIN
806: x_msg_count := 0;
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
809:
810: IF l_debug_mode = 'Y' THEN
811: pa_debug.set_curr_function( p_function => 'GET_RES_ASSIGNMENT_INFO'
812: ,p_debug_mode => l_debug_mode );

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

963:
964: BEGIN
965: x_msg_count := 0;
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
968:
969: IF l_debug_mode = 'Y' THEN
970: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_CHANGE_REASON_CODE');
971: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

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

1081: BEGIN
1082:
1083: x_msg_count := 0;
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1086:
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_TXN_CURRENCY_CODE');
1089: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 1415: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');

1411:
1412: BEGIN
1413: x_msg_count := 0;
1414: x_return_status := FND_API.G_RET_STS_SUCCESS;
1415: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1416:
1417: IF l_debug_mode = 'Y' THEN
1418: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO');
1419: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 1725: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');

1721:
1722: BEGIN
1723: x_msg_count := 0;
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1726:
1727: IF l_debug_mode = 'Y' THEN
1728: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES');
1729: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

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

1860: BEGIN
1861:
1862: x_msg_count := 0;
1863: x_return_status := FND_API.G_RET_STS_SUCCESS;
1864: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1865:
1866: IF l_debug_mode = 'Y' THEN
1867: pa_debug.g_err_stage:= 'Entering GET_ERROR_LOOKUP_CODE';
1868: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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

2104: BEGIN
2105:
2106: x_msg_count := 0;
2107: x_return_status := FND_API.G_RET_STS_SUCCESS;
2108: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2109:
2110: IF l_debug_mode = 'Y' THEN
2111: pa_debug.set_curr_function( p_function => 'CONV_MC_ATTR_MEANING_TO_CODE',
2112: p_debug_mode => l_debug_mode );

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

2300: BEGIN
2301: x_msg_count := 0;
2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303:
2304: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2305: l_debug_mode := NVL(l_debug_mode, 'Y');
2306:
2307: -- Set curr function
2308: pa_debug.set_curr_function(

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

2427: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2428: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2429:
2430: BEGIN
2431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2432:
2433: x_msg_count := 0;
2434: x_return_status := FND_API.G_RET_STS_SUCCESS;
2435:

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

2573: l_new_request_id pa_budget_versions.request_id%TYPE;
2574: -- MOAC changes.
2575: l_org_id pa_projects_all.org_id%TYPE;
2576: BEGIN
2577: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2578:
2579: x_msg_count := 0;
2580: x_return_status := FND_API.G_RET_STS_SUCCESS;
2581: