[Home] [Help]
327:
328: BEGIN
329: x_msg_count := 0;
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
332:
333: IF l_debug_mode = 'Y' THEN
334: pa_debug.set_curr_function( p_function => 'DELETE_XFACE'
335: ,p_debug_mode => l_debug_mode );
511:
512:
513: BEGIN
514:
515: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
516: x_msg_count := 0;
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518: IF l_debug_mode = 'Y' THEN
519: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1034: l_data VARCHAR2(2000);
1035: l_periodic_flag VARCHAR2(1);
1036:
1037: BEGIN
1038: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1039: x_msg_count := 0;
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: IF l_debug_mode = 'Y' THEN
1042: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1288: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1289: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1290:
1291: BEGIN
1292: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1293: x_msg_count := 0;
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: IF l_debug_mode = 'Y' THEN
1296: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1438: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1439: l_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1440:
1441: BEGIN
1442: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1443: x_msg_count := 0;
1444: x_return_status := FND_API.G_RET_STS_SUCCESS;
1445: IF l_debug_mode = 'Y' THEN
1446: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1556:
1557:
1558: BEGIN
1559: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1560:
1561: IF l_debug_mode = 'Y' THEN
1562: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1563: p_debug_mode => l_debug_mode );
1998: l_period_plan_start_date_tbl date_tbl_type;
1999: l_period_plan_end_date_tbl date_tbl_type;
2000: BEGIN
2001:
2002: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2003: x_msg_count := 0;
2004: x_return_status := FND_API.G_RET_STS_SUCCESS;
2005:
2006: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
5987: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_amount_in_prd_x';
5988: l_debug_mode VARCHAR2(1) := 'N';
5989: l_amount NUMBER;
5990: BEGIN
5991: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
5992:
5993:
5994: IF l_debug_mode = 'Y' THEN
5995: pa_debug.g_err_stage := 'Entering into get_amount_in_prd_x';
6231: BEGIN
6232: x_msg_count := 0;
6233: x_return_status := FND_API.G_RET_STS_SUCCESS;
6234:
6235: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6236: l_debug_mode := NVL(l_debug_mode, 'Y');
6237:
6238: --DEBUG_NS('p_project_id :: '|| p_project_id);
6239:
6918:
6919: tt NUMBER;
6920:
6921: BEGIN
6922: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
6923:
6924: x_return_status := FND_API.G_RET_STS_SUCCESS;
6925: x_msg_count := 0;
6926:
8423: l_extra_bls_exists VARCHAR2(1);
8424: j INTEGER;
8425: BEGIN
8426: --log1('PBL Begin '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
8427: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
8428:
8429: x_return_status := FND_API.G_RET_STS_SUCCESS;
8430: x_msg_count := 0;
8431: --log1('----- STAGE PBL1.0-------');
10508: 7. As a result if we dont commit in the beginning when SWITCHER API is called, then when
10509: Stamp_Client_Extn_Errors APi is invoked there will be no records in PA_FP_WEBADI_UPLOAD_INF.
10510: */
10511:
10512: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
10513:
10514:
10515: x_return_status := FND_API.G_RET_STS_SUCCESS;
10516: x_msg_count := 0;
11037: --a concurrent request has to be submitted
11038: IF p_calling_mode = 'STANDARD' THEN
11039: --log1('----- STAGE 10.1-------');
11040: -- For values other than site level
11041: l_profile_val := fnd_profile.value_specific
11042: (name => 'PA_FP_WEBADI_DATA_PRC_MODE',
11043: user_id => fnd_global.user_id,
11044: responsibility_id => fnd_global.resp_id,
11045: application_id => 275);
11046: --log1('----- STAGE 10.2-------');
11047: IF l_profile_val IS NULL THEN
11048: -- For values at site level
11049: --log1('----- STAGE 10.3-------');
11050: l_profile_val := fnd_profile.value
11051: (name => 'PA_FP_WEBADI_DATA_PRC_MODE');
11052: --log1('----- STAGE 10.4-------');
11053: END IF;
11054:
11055: --DEBUG_NS('l_profile_val :: '|| l_profile_val);
11056:
11057: IF l_profile_val = 'STANDARD' THEN
11058: --log1('----- STAGE 10.5-------');
11059: l_profile_thsld_val := fnd_profile.value_specific
11060: (name => 'PA_FP_WEBADI_DATA_PRC_THSLD',
11061: user_id => fnd_global.user_id,
11062: responsibility_id => fnd_global.resp_id,
11063: application_id => 275);
11063: application_id => 275);
11064: --log1('----- STAGE 10.6-------');
11065: IF l_profile_thsld_val IS NULL THEN
11066: --log1('----- STAGE 10.7-------');
11067: l_profile_thsld_val := fnd_profile.value
11068: (name => 'PA_FP_WEBADI_DATA_PRC_THSLD');
11069: --log1('----- STAGE 10.8-------');
11070: END IF;
11071:
11586:
11587: BEGIN
11588: -- SAVEPOINT process_MSExcel_data;
11589: retcode:='0';
11590: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
11591: l_debug_mode := NVL(l_debug_mode, 'Y');
11592: --log1('----- STAGE CR1-------');
11593: -- Set curr function
11594: IF l_debug_mode='Y' THEN
11876: x NUMBER := 1;
11877: BEGIN
11878: x_msg_count := 0;
11879: x_return_status := FND_API.G_RET_STS_SUCCESS;
11880: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'Y');
11881:
11882: IF l_debug_mode = 'Y' THEN
11883: pa_debug.set_curr_function(p_function => 'GET_PERIOD_INFORMATION',
11884: p_debug_mode => l_debug_mode);
12312:
12313: BEGIN
12314: x_msg_count := 0;
12315: x_return_status := FND_API.G_RET_STS_SUCCESS;
12316: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
12317:
12318:
12319: IF l_debug_mode = 'Y' THEN
12320: pa_debug.set_curr_function( p_function => 'INSERT_PERIODIC_TMP_TABLE'