[Home] [Help]
326:
327: BEGIN
328: x_msg_count := 0;
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
331:
332: IF l_debug_mode = 'Y' THEN
333: pa_debug.set_curr_function( p_function => 'DELETE_XFACE'
334: ,p_debug_mode => l_debug_mode );
510:
511:
512: BEGIN
513:
514: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
515: x_msg_count := 0;
516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517: IF l_debug_mode = 'Y' THEN
518: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1033: l_data VARCHAR2(2000);
1034: l_periodic_flag VARCHAR2(1);
1035:
1036: BEGIN
1037: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1038: x_msg_count := 0;
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040: IF l_debug_mode = 'Y' THEN
1041: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1287: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1288: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1289:
1290: BEGIN
1291: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1292: x_msg_count := 0;
1293: x_return_status := FND_API.G_RET_STS_SUCCESS;
1294: IF l_debug_mode = 'Y' THEN
1295: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1437: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1438: l_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1439:
1440: BEGIN
1441: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1442: x_msg_count := 0;
1443: x_return_status := FND_API.G_RET_STS_SUCCESS;
1444: IF l_debug_mode = 'Y' THEN
1445: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1554: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1555:
1556:
1557: BEGIN
1558: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1559:
1560: IF l_debug_mode = 'Y' THEN
1561: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1562: p_debug_mode => l_debug_mode );
1989: l_period_plan_start_date_tbl date_tbl_type;
1990: l_period_plan_end_date_tbl date_tbl_type;
1991: BEGIN
1992:
1993: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1994: x_msg_count := 0;
1995: x_return_status := FND_API.G_RET_STS_SUCCESS;
1996:
1997: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
5894: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_amount_in_prd_x';
5895: l_debug_mode VARCHAR2(1) := 'N';
5896: l_amount NUMBER;
5897: BEGIN
5898: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
5899:
5900:
5901: IF l_debug_mode = 'Y' THEN
5902: pa_debug.g_err_stage := 'Entering into get_amount_in_prd_x';
6136: BEGIN
6137: x_msg_count := 0;
6138: x_return_status := FND_API.G_RET_STS_SUCCESS;
6139:
6140: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6141: l_debug_mode := NVL(l_debug_mode, 'Y');
6142:
6143: -- Set curr function
6144: IF l_debug_mode='Y' THEN
6805:
6806: tt NUMBER;
6807:
6808: BEGIN
6809: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
6810:
6811: x_return_status := FND_API.G_RET_STS_SUCCESS;
6812: x_msg_count := 0;
6813:
8270: l_extra_bls_exists VARCHAR2(1);
8271: j INTEGER;
8272: BEGIN
8273: --log1('PBL Begin '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
8274: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
8275:
8276: x_return_status := FND_API.G_RET_STS_SUCCESS;
8277: x_msg_count := 0;
8278: --log1('----- STAGE PBL1.0-------');
10327: 7. As a result if we dont commit in the beginning when SWITCHER API is called, then when
10328: Stamp_Client_Extn_Errors APi is invoked there will be no records in PA_FP_WEBADI_UPLOAD_INF.
10329: */
10330:
10331: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
10332:
10333: x_return_status := FND_API.G_RET_STS_SUCCESS;
10334: x_msg_count := 0;
10335:
10818: --a concurrent request has to be submitted
10819: IF p_calling_mode = 'STANDARD' THEN
10820: --log1('----- STAGE 10.1-------');
10821: -- For values other than site level
10822: l_profile_val := fnd_profile.value_specific
10823: (name => 'PA_FP_WEBADI_DATA_PRC_MODE',
10824: user_id => fnd_global.user_id,
10825: responsibility_id => fnd_global.resp_id,
10826: application_id => 275);
10827: --log1('----- STAGE 10.2-------');
10828: IF l_profile_val IS NULL THEN
10829: -- For values at site level
10830: --log1('----- STAGE 10.3-------');
10831: l_profile_val := fnd_profile.value
10832: (name => 'PA_FP_WEBADI_DATA_PRC_MODE');
10833: --log1('----- STAGE 10.4-------');
10834: END IF;
10835:
10834: END IF;
10835:
10836: IF l_profile_val = 'STANDARD' THEN
10837: --log1('----- STAGE 10.5-------');
10838: l_profile_thsld_val := fnd_profile.value_specific
10839: (name => 'PA_FP_WEBADI_DATA_PRC_THSLD',
10840: user_id => fnd_global.user_id,
10841: responsibility_id => fnd_global.resp_id,
10842: application_id => 275);
10842: application_id => 275);
10843: --log1('----- STAGE 10.6-------');
10844: IF l_profile_thsld_val IS NULL THEN
10845: --log1('----- STAGE 10.7-------');
10846: l_profile_thsld_val := fnd_profile.value
10847: (name => 'PA_FP_WEBADI_DATA_PRC_THSLD');
10848: --log1('----- STAGE 10.8-------');
10849: END IF;
10850:
11356:
11357: BEGIN
11358: -- SAVEPOINT process_MSExcel_data;
11359: retcode:='0';
11360: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
11361: l_debug_mode := NVL(l_debug_mode, 'Y');
11362: --log1('----- STAGE CR1-------');
11363: -- Set curr function
11364: IF l_debug_mode='Y' THEN
11645: x NUMBER := 1;
11646: BEGIN
11647: x_msg_count := 0;
11648: x_return_status := FND_API.G_RET_STS_SUCCESS;
11649: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'Y');
11650:
11651: IF l_debug_mode = 'Y' THEN
11652: pa_debug.set_curr_function(p_function => 'GET_PERIOD_INFORMATION',
11653: p_debug_mode => l_debug_mode);
12077:
12078: BEGIN
12079: x_msg_count := 0;
12080: x_return_status := FND_API.G_RET_STS_SUCCESS;
12081: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
12082:
12083:
12084: IF l_debug_mode = 'Y' THEN
12085: pa_debug.set_curr_function( p_function => 'INSERT_PERIODIC_TMP_TABLE'