APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_DEBUG

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

1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB3 as
2: /* $Header: PAFPFG3B.pls 120.8.12020000.3 2013/05/17 09:43:33 bpottipa ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /* Assumption:
7: *1.Before getting into this procedure, we have all total plan amounts and commitment
8: amounts populated in temporary table PA_FP_CALC_AMT_TMP2 table with transaction

Line 161: IF p_pa_debug_mode = 'Y' THEN

157: l_msg_data VARCHAR2(2000);
158: l_data VARCHAR2(2000);
159: l_msg_index_out NUMBER:=0;
160: BEGIN
161: IF p_pa_debug_mode = 'Y' THEN
162: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
163: p_debug_mode => p_pa_debug_mode);
164: END IF;
165:

Line 162: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',

158: l_data VARCHAR2(2000);
159: l_msg_index_out NUMBER:=0;
160: BEGIN
161: IF p_pa_debug_mode = 'Y' THEN
162: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
163: p_debug_mode => p_pa_debug_mode);
164: END IF;
165:
166: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 163: p_debug_mode => p_pa_debug_mode);

159: l_msg_index_out NUMBER:=0;
160: BEGIN
161: IF p_pa_debug_mode = 'Y' THEN
162: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
163: p_debug_mode => p_pa_debug_mode);
164: END IF;
165:
166: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
167: X_MSG_COUNT := 0;

Line 274: IF P_PA_DEBUG_MODE = 'Y' THEN

270: Workplan side only stores amounts in one currency for each planning
271: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
272: to get actuals data, we query directly to pa_budget_lines to get actual
273: data from source workplan budget version */
274: IF P_PA_DEBUG_MODE = 'Y' THEN
275: pa_fp_gen_amount_utils.fp_debug(
276: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
277: 'GET_WP_ACTUALS_FOR_RA',
278: p_module_name => l_module_name,

Line 299: IF P_PA_DEBUG_MODE = 'Y' THEN

295: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
296: X_RETURN_STATUS => x_return_status,
297: X_MSG_COUNT => x_msg_count,
298: X_MSG_DATA => x_msg_data );
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_fp_gen_amount_utils.fp_debug(
301: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
302: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
303: p_module_name => l_module_name,

Line 326: IF P_PA_DEBUG_MODE = 'Y' THEN

322: l_etc_quantity_pc_pfc := l_tot_quantity_pc_pfc - l_act_quantity_pc_pfc;
323: IF l_etc_quantity_pc_pfc <= 0 THEN
324: /* actual quantity > total ETC quantity, only need to spread
325: commitment and actual data*/
326: IF P_PA_DEBUG_MODE = 'Y' THEN
327: PA_DEBUG.RESET_CURR_FUNCTION;
328: END IF;
329: RETURN;
330: END IF;

Line 327: PA_DEBUG.RESET_CURR_FUNCTION;

323: IF l_etc_quantity_pc_pfc <= 0 THEN
324: /* actual quantity > total ETC quantity, only need to spread
325: commitment and actual data*/
326: IF P_PA_DEBUG_MODE = 'Y' THEN
327: PA_DEBUG.RESET_CURR_FUNCTION;
328: END IF;
329: RETURN;
330: END IF;
331:

Line 449: IF P_PA_DEBUG_MODE = 'Y' THEN

445: AND transaction_source_code = p_etc_source_code
446: GROUP BY txn_currency_code;
447:
448: IF l_tot_currency_code_tab.count = 0 THEN
449: IF P_PA_DEBUG_MODE = 'Y' THEN
450: PA_DEBUG.RESET_CURR_FUNCTION;
451: END IF;
452: RETURN;
453: END IF;

Line 450: PA_DEBUG.RESET_CURR_FUNCTION;

446: GROUP BY txn_currency_code;
447:
448: IF l_tot_currency_code_tab.count = 0 THEN
449: IF P_PA_DEBUG_MODE = 'Y' THEN
450: PA_DEBUG.RESET_CURR_FUNCTION;
451: END IF;
452: RETURN;
453: END IF;
454: IF l_rate_based_flag = 'N' THEN

Line 509: IF P_PA_DEBUG_MODE = 'Y' THEN

505: Workplan side only stores amounts in one currency for each planning
506: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
507: to get actuals data, we query directly to pa_budget_lines to get actual
508: data from source workplan budget version */
509: IF P_PA_DEBUG_MODE = 'Y' THEN
510: pa_fp_gen_amount_utils.fp_debug(
511: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
512: 'GET_WP_ACTUALS_FOR_RA',
513: p_module_name => l_module_name,

Line 534: IF P_PA_DEBUG_MODE = 'Y' THEN

530: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
531: X_RETURN_STATUS => x_return_status,
532: X_MSG_COUNT => x_msg_count,
533: X_MSG_DATA => x_msg_data );
534: IF P_PA_DEBUG_MODE = 'Y' THEN
535: pa_fp_gen_amount_utils.fp_debug(
536: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
537: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
538: p_module_name => l_module_name,

Line 597: IF P_PA_DEBUG_MODE = 'Y' THEN

593: calculated as less or equal to zero, then don't generate the ETC.*/
594: IF l_act_currency_code_tab.count = 1 AND l_tot_currency_code_tab.count = 1 THEN
595: l_etc_quantity_sum := l_tot_quantity_sum - l_act_quantity_sum;
596: IF l_etc_quantity_sum <= 0 THEN
597: IF P_PA_DEBUG_MODE = 'Y' THEN
598: PA_DEBUG.RESET_CURR_FUNCTION;
599: END IF;
600: RETURN;
601: ELSE

Line 598: PA_DEBUG.RESET_CURR_FUNCTION;

594: IF l_act_currency_code_tab.count = 1 AND l_tot_currency_code_tab.count = 1 THEN
595: l_etc_quantity_sum := l_tot_quantity_sum - l_act_quantity_sum;
596: IF l_etc_quantity_sum <= 0 THEN
597: IF P_PA_DEBUG_MODE = 'Y' THEN
598: PA_DEBUG.RESET_CURR_FUNCTION;
599: END IF;
600: RETURN;
601: ELSE
602: l_etc_quantity_tab(1) := l_etc_quantity_sum;

Line 634: IF P_PA_DEBUG_MODE = 'Y' THEN

630: l_etc_quantity_sum := l_tot_quantity_sum - l_act_quantity_sum;
631: IF l_etc_quantity_sum <= 0 THEN
632: /* If actual quantity >= total planned quantity, no non-commitment ETC
633: available, only actual and commitment amounts need to be spreaded */
634: IF P_PA_DEBUG_MODE = 'Y' THEN
635: PA_DEBUG.RESET_CURR_FUNCTION;
636: END IF;
637: RETURN;
638: END IF;

Line 635: PA_DEBUG.RESET_CURR_FUNCTION;

631: IF l_etc_quantity_sum <= 0 THEN
632: /* If actual quantity >= total planned quantity, no non-commitment ETC
633: available, only actual and commitment amounts need to be spreaded */
634: IF P_PA_DEBUG_MODE = 'Y' THEN
635: PA_DEBUG.RESET_CURR_FUNCTION;
636: END IF;
637: RETURN;
638: END IF;
639:

Line 803: IF P_PA_DEBUG_MODE = 'Y' THEN

799: /*Workplan side only stores amounts in one currency for each planning
800: resource, so still rely on pa_progress_utils.get_actuals_for_task to
801: get actuals data. This part needs to be revisted when workplan side is
802: changed to support multi currencies.*/
803: IF P_PA_DEBUG_MODE = 'Y' THEN
804: pa_fp_gen_amount_utils.fp_debug(
805: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
806: 'GET_WP_ACTUALS_FOR_RA',
807: p_module_name => l_module_name,

Line 828: IF P_PA_DEBUG_MODE = 'Y' THEN

824: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
825: X_RETURN_STATUS => x_return_status,
826: X_MSG_COUNT => x_msg_count,
827: X_MSG_DATA => x_msg_data );
828: IF P_PA_DEBUG_MODE = 'Y' THEN
829: pa_fp_gen_amount_utils.fp_debug(
830: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
831: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
832: p_module_name => l_module_name,

Line 850: IF P_PA_DEBUG_MODE = 'Y' THEN

846: l_etc_quantity_pc_sum := l_tot_quantity_pc_sum - l_act_quantity_pc_sum;
847: IF l_etc_quantity_pc_sum <= 0 THEN
848: /* actual quantity > total ETC quantity,only need to spread
849: commitment data and actual data*/
850: IF P_PA_DEBUG_MODE = 'Y' THEN
851: PA_DEBUG.RESET_CURR_FUNCTION;
852: END IF;
853: RETURN;
854: END IF;

Line 851: PA_DEBUG.RESET_CURR_FUNCTION;

847: IF l_etc_quantity_pc_sum <= 0 THEN
848: /* actual quantity > total ETC quantity,only need to spread
849: commitment data and actual data*/
850: IF P_PA_DEBUG_MODE = 'Y' THEN
851: PA_DEBUG.RESET_CURR_FUNCTION;
852: END IF;
853: RETURN;
854: END IF;
855: FOR i IN 1..l_tot_currency_code_tab.count LOOP

Line 883: IF P_PA_DEBUG_MODE = 'Y' THEN

879: WHEN NO_DATA_FOUND THEN
880: l_task_id := NULL;
881: l_planning_start_date := NULL;
882: END;
883: IF P_PA_DEBUG_MODE = 'Y' THEN
884: pa_fp_gen_amount_utils.fp_debug(
885: p_msg => 'Before calling pa_multi_currency_txn.'||
886: 'get_currency_amounts in remain_bdgt',
887: p_module_name => l_module_name,

Line 944: IF P_PA_DEBUG_MODE = 'Y' THEN

940: ,p_token3 => 'TOCURRENCY'
941: ,p_value3 => l_tot_currency_code_tab(i) );
942: x_msg_data := 'PA_FP_PROJ_NO_TXNCONVRATE';
943: END IF;
944: IF P_PA_DEBUG_MODE = 'Y' THEN
945: pa_fp_gen_amount_utils.fp_debug(
946: p_msg => 'After calling pa_multi_currency_txn.'||
947: 'get_currency_amounts in remain_bdgt:'||x_return_status,
948: p_module_name => l_module_name,

Line 1047: IF P_PA_DEBUG_MODE = 'Y' THEN

1043:
1044: END IF;
1045: /* End the check for 'PC', 'TC' and 'PC_TC'*/
1046:
1047: IF P_PA_DEBUG_MODE = 'Y' THEN
1048: PA_DEBUG.RESET_CURR_FUNCTION;
1049: END IF;
1050: EXCEPTION
1051: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1048: PA_DEBUG.RESET_CURR_FUNCTION;

1044: END IF;
1045: /* End the check for 'PC', 'TC' and 'PC_TC'*/
1046:
1047: IF P_PA_DEBUG_MODE = 'Y' THEN
1048: PA_DEBUG.RESET_CURR_FUNCTION;
1049: END IF;
1050: EXCEPTION
1051: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1052: l_msg_count := FND_MSG_PUB.count_msg;

Line 1070: IF P_PA_DEBUG_MODE = 'Y' THEN

1066:
1067: ROLLBACK;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069:
1070: IF P_PA_DEBUG_MODE = 'Y' THEN
1071: pa_fp_gen_amount_utils.fp_debug
1072: (p_msg => 'Invalid Arguments Passed',
1073: p_module_name => l_module_name,
1074: p_log_level => 5);

Line 1075: PA_DEBUG.RESET_CURR_FUNCTION;

1071: pa_fp_gen_amount_utils.fp_debug
1072: (p_msg => 'Invalid Arguments Passed',
1073: p_module_name => l_module_name,
1074: p_log_level => 5);
1075: PA_DEBUG.RESET_CURR_FUNCTION;
1076: END IF;
1077: RAISE;
1078: WHEN OTHERS THEN
1079: rollback;

Line 1089: IF P_PA_DEBUG_MODE = 'Y' THEN

1085: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
1086: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS',
1087: p_error_text => substr(sqlerrm,1,240));
1088:
1089: IF P_PA_DEBUG_MODE = 'Y' THEN
1090: pa_fp_gen_amount_utils.fp_debug
1091: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1092: p_module_name => l_module_name,
1093: p_log_level => 5);

Line 1094: PA_DEBUG.RESET_CURR_FUNCTION;

1090: pa_fp_gen_amount_utils.fp_debug
1091: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1092: p_module_name => l_module_name,
1093: p_log_level => 5);
1094: PA_DEBUG.RESET_CURR_FUNCTION;
1095: END IF;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END GET_ETC_REMAIN_BDGT_AMTS;
1098:

Line 1116: IF p_pa_debug_mode = 'Y' THEN

1112: l_data VARCHAR2(2000);
1113: l_msg_index_out NUMBER:=0;
1114: BEGIN
1115:
1116: IF p_pa_debug_mode = 'Y' THEN
1117: pa_debug.set_curr_function( p_function => 'CHECK_SINGLE_CURRENCY',
1118: p_debug_mode => p_pa_debug_mode);
1119: END IF;
1120:

Line 1117: pa_debug.set_curr_function( p_function => 'CHECK_SINGLE_CURRENCY',

1113: l_msg_index_out NUMBER:=0;
1114: BEGIN
1115:
1116: IF p_pa_debug_mode = 'Y' THEN
1117: pa_debug.set_curr_function( p_function => 'CHECK_SINGLE_CURRENCY',
1118: p_debug_mode => p_pa_debug_mode);
1119: END IF;
1120:
1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1118: p_debug_mode => p_pa_debug_mode);

1114: BEGIN
1115:
1116: IF p_pa_debug_mode = 'Y' THEN
1117: pa_debug.set_curr_function( p_function => 'CHECK_SINGLE_CURRENCY',
1118: p_debug_mode => p_pa_debug_mode);
1119: END IF;
1120:
1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1122: X_MSG_COUNT := 0;

Line 1124: IF P_PA_DEBUG_MODE = 'Y' THEN

1120:
1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1122: X_MSG_COUNT := 0;
1123:
1124: IF P_PA_DEBUG_MODE = 'Y' THEN
1125: PA_DEBUG.RESET_CURR_FUNCTION;
1126: END IF;
1127:
1128: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (

Line 1125: PA_DEBUG.RESET_CURR_FUNCTION;

1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1122: X_MSG_COUNT := 0;
1123:
1124: IF P_PA_DEBUG_MODE = 'Y' THEN
1125: PA_DEBUG.RESET_CURR_FUNCTION;
1126: END IF;
1127:
1128: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
1129: SELECT /*+ INDEX(tot_tmp,PA_FP_CALC_AMT_TMP2_N1)*/

Line 1151: IF P_PA_DEBUG_MODE = 'Y' THEN

1147: ELSE
1148: X_SINGLE_CURRENCY_FLAG := 'N';
1149: END IF;
1150:
1151: IF P_PA_DEBUG_MODE = 'Y' THEN
1152: PA_DEBUG.RESET_CURR_FUNCTION;
1153: END IF;
1154: EXCEPTION
1155: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1152: PA_DEBUG.RESET_CURR_FUNCTION;

1148: X_SINGLE_CURRENCY_FLAG := 'N';
1149: END IF;
1150:
1151: IF P_PA_DEBUG_MODE = 'Y' THEN
1152: PA_DEBUG.RESET_CURR_FUNCTION;
1153: END IF;
1154: EXCEPTION
1155: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1156: l_msg_count := FND_MSG_PUB.count_msg;

Line 1174: IF P_PA_DEBUG_MODE = 'Y' THEN

1170:
1171: ROLLBACK;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173:
1174: IF P_PA_DEBUG_MODE = 'Y' THEN
1175: pa_fp_gen_amount_utils.fp_debug
1176: (p_msg => 'Invalid Arguments Passed',
1177: p_module_name => l_module_name,
1178: p_log_level => 5);

Line 1179: PA_DEBUG.RESET_CURR_FUNCTION;

1175: pa_fp_gen_amount_utils.fp_debug
1176: (p_msg => 'Invalid Arguments Passed',
1177: p_module_name => l_module_name,
1178: p_log_level => 5);
1179: PA_DEBUG.RESET_CURR_FUNCTION;
1180: END IF;
1181: RAISE;
1182: WHEN OTHERS THEN
1183: rollback;

Line 1193: IF P_PA_DEBUG_MODE = 'Y' THEN

1189: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
1190: p_procedure_name => 'CHECK_SINGLE_CURRENCY',
1191: p_error_text => substr(sqlerrm,1,240));
1192:
1193: IF P_PA_DEBUG_MODE = 'Y' THEN
1194: pa_fp_gen_amount_utils.fp_debug
1195: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1196: p_module_name => l_module_name,
1197: p_log_level => 5);

Line 1198: PA_DEBUG.RESET_CURR_FUNCTION;

1194: pa_fp_gen_amount_utils.fp_debug
1195: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1196: p_module_name => l_module_name,
1197: p_log_level => 5);
1198: PA_DEBUG.RESET_CURR_FUNCTION;
1199: END IF;
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: END CHECK_SINGLE_CURRENCY;
1202:

Line 1416: IF p_pa_debug_mode = 'Y' THEN

1412: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
1413: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1414:
1415: BEGIN
1416: IF p_pa_debug_mode = 'Y' THEN
1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',
1418: p_debug_mode => p_pa_debug_mode);
1419: END IF;
1420:

Line 1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',

1413: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1414:
1415: BEGIN
1416: IF p_pa_debug_mode = 'Y' THEN
1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',
1418: p_debug_mode => p_pa_debug_mode);
1419: END IF;
1420:
1421: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1418: p_debug_mode => p_pa_debug_mode);

1414:
1415: BEGIN
1416: IF p_pa_debug_mode = 'Y' THEN
1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',
1418: p_debug_mode => p_pa_debug_mode);
1419: END IF;
1420:
1421: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1422: X_MSG_COUNT := 0;

Line 2115: IF P_PA_DEBUG_MODE = 'Y' THEN

2111: WHEN NO_DATA_FOUND THEN
2112: l_task_id := NULL;
2113: l_planning_start_date := NULL;
2114: END;
2115: IF P_PA_DEBUG_MODE = 'Y' THEN
2116: pa_fp_gen_amount_utils.fp_debug(
2117: p_msg => 'Before calling pa_multi_currency_txn.'||
2118: 'get_currency_amounts in remain_bdgt',
2119: p_module_name => l_module_name,

Line 2153: IF P_PA_DEBUG_MODE = 'Y' THEN

2149:
2150: P_system_linkage => 'NER',
2151: P_status => x_return_status,
2152: P_stage => x_msg_count) ;
2153: IF P_PA_DEBUG_MODE = 'Y' THEN
2154: pa_fp_gen_amount_utils.fp_debug(
2155: p_msg => 'After calling pa_multi_currency_txn.'||
2156: 'get_currency_amounts in remain_bdgt:'||x_return_status,
2157: p_module_name => l_module_name,

Line 2257: IF P_PA_DEBUG_MODE = 'Y' THEN

2253: END IF;
2254: END LOOP; --wrapper loop for Bug 4110695
2255: END LOOP;
2256:
2257: IF P_PA_DEBUG_MODE = 'Y' THEN
2258: PA_DEBUG.RESET_CURR_FUNCTION;
2259: END IF;
2260: EXCEPTION
2261: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2258: PA_DEBUG.RESET_CURR_FUNCTION;

2254: END LOOP; --wrapper loop for Bug 4110695
2255: END LOOP;
2256:
2257: IF P_PA_DEBUG_MODE = 'Y' THEN
2258: PA_DEBUG.RESET_CURR_FUNCTION;
2259: END IF;
2260: EXCEPTION
2261: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2262: l_msg_count := FND_MSG_PUB.count_msg;

Line 2280: IF P_PA_DEBUG_MODE = 'Y' THEN

2276:
2277: ROLLBACK;
2278: x_return_status := FND_API.G_RET_STS_ERROR;
2279:
2280: IF P_PA_DEBUG_MODE = 'Y' THEN
2281: pa_fp_gen_amount_utils.fp_debug
2282: (p_msg => 'Invalid Arguments Passed',
2283: p_module_name => l_module_name,
2284: p_log_level => 5);

Line 2285: PA_DEBUG.RESET_CURR_FUNCTION;

2281: pa_fp_gen_amount_utils.fp_debug
2282: (p_msg => 'Invalid Arguments Passed',
2283: p_module_name => l_module_name,
2284: p_log_level => 5);
2285: PA_DEBUG.RESET_CURR_FUNCTION;
2286: END IF;
2287: RAISE;
2288: WHEN OTHERS THEN
2289: rollback;

Line 2299: IF P_PA_DEBUG_MODE = 'Y' THEN

2295: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
2296: p_procedure_name => 'GEN_ETC_COMMITMENT_AMTS',
2297: p_error_text => substr(sqlerrm,1,240));
2298:
2299: IF P_PA_DEBUG_MODE = 'Y' THEN
2300: pa_fp_gen_amount_utils.fp_debug
2301: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2302: p_module_name => l_module_name,
2303: p_log_level => 5);

Line 2304: PA_DEBUG.RESET_CURR_FUNCTION;

2300: pa_fp_gen_amount_utils.fp_debug
2301: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2302: p_module_name => l_module_name,
2303: p_log_level => 5);
2304: PA_DEBUG.RESET_CURR_FUNCTION;
2305: END IF;
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2307: END GET_ETC_COMMITMENT_AMTS;
2308:

Line 2509: IF p_pa_debug_mode = 'Y' THEN

2505: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2506: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2507:
2508: BEGIN
2509: IF p_pa_debug_mode = 'Y' THEN
2510: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
2511: p_debug_mode => p_pa_debug_mode);
2512: END IF;
2513:

Line 2510: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',

2506: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2507:
2508: BEGIN
2509: IF p_pa_debug_mode = 'Y' THEN
2510: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
2511: p_debug_mode => p_pa_debug_mode);
2512: END IF;
2513:
2514: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2511: p_debug_mode => p_pa_debug_mode);

2507:
2508: BEGIN
2509: IF p_pa_debug_mode = 'Y' THEN
2510: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
2511: p_debug_mode => p_pa_debug_mode);
2512: END IF;
2513:
2514: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2515: X_MSG_COUNT := 0;

Line 2699: IF P_PA_DEBUG_MODE = 'Y' THEN

2695: Workplan side only stores amounts in one currency for each planning
2696: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2697: to get actuals data, we query directly to pa_budget_lines to get actual
2698: data from source workplan budget version */
2699: IF P_PA_DEBUG_MODE = 'Y' THEN
2700: pa_fp_gen_amount_utils.fp_debug(
2701: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2702: 'GET_WP_ACTUALS_FOR_RA',
2703: p_module_name => l_module_name,

Line 2724: IF P_PA_DEBUG_MODE = 'Y' THEN

2720: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
2721: X_RETURN_STATUS => x_return_status,
2722: X_MSG_COUNT => x_msg_count,
2723: X_MSG_DATA => x_msg_data );
2724: IF P_PA_DEBUG_MODE = 'Y' THEN
2725: pa_fp_gen_amount_utils.fp_debug(
2726: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2727: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
2728: p_module_name => l_module_name,

Line 2989: IF P_PA_DEBUG_MODE = 'Y' THEN

2985: Workplan side only stores amounts in one currency for each planning
2986: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2987: to get actuals data, we query directly to pa_budget_lines to get actual
2988: data from source workplan budget version */
2989: IF P_PA_DEBUG_MODE = 'Y' THEN
2990: pa_fp_gen_amount_utils.fp_debug(
2991: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2992: 'GET_WP_ACTUALS_FOR_RA',
2993: p_module_name => l_module_name,

Line 3014: IF P_PA_DEBUG_MODE = 'Y' THEN

3010: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
3011: X_RETURN_STATUS => x_return_status,
3012: X_MSG_COUNT => x_msg_count,
3013: X_MSG_DATA => x_msg_data );
3014: IF P_PA_DEBUG_MODE = 'Y' THEN
3015: pa_fp_gen_amount_utils.fp_debug(
3016: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3017: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3018: p_module_name => l_module_name,

Line 3363: IF P_PA_DEBUG_MODE = 'Y' THEN

3359: /*Workplan side only stores amounts in one currency for each planning
3360: resource, so still rely on pa_progress_utils.get_actuals_for_task to
3361: get actuals data. This part needs to be revisted when workplan side is
3362: changed to support multi currencies.*/
3363: IF P_PA_DEBUG_MODE = 'Y' THEN
3364: pa_fp_gen_amount_utils.fp_debug(
3365: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
3366: 'GET_WP_ACTUALS_FOR_RA',
3367: p_module_name => l_module_name,

Line 3388: IF P_PA_DEBUG_MODE = 'Y' THEN

3384: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
3385: X_RETURN_STATUS => x_return_status,
3386: X_MSG_COUNT => x_msg_count,
3387: X_MSG_DATA => x_msg_data );
3388: IF P_PA_DEBUG_MODE = 'Y' THEN
3389: pa_fp_gen_amount_utils.fp_debug(
3390: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3391: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3392: p_module_name => l_module_name,

Line 3456: IF P_PA_DEBUG_MODE = 'Y' THEN

3452: WHEN NO_DATA_FOUND THEN
3453: l_task_id := NULL;
3454: l_planning_start_date := NULL;
3455: END;
3456: IF P_PA_DEBUG_MODE = 'Y' THEN
3457: pa_fp_gen_amount_utils.fp_debug(
3458: p_msg => 'Before calling pa_multi_currency_txn.'||
3459: 'get_currency_amounts in remain_bdgt',
3460: p_module_name => l_module_name,

Line 3517: IF P_PA_DEBUG_MODE = 'Y' THEN

3513: ,p_token3 => 'TOCURRENCY'
3514: ,p_value3 => l_tot_currency_code_tab(i) );
3515: x_msg_data := 'PA_FP_PROJ_NO_TXNCONVRATE';
3516: END IF;
3517: IF P_PA_DEBUG_MODE = 'Y' THEN
3518: pa_fp_gen_amount_utils.fp_debug(
3519: p_msg => 'After calling pa_multi_currency_txn.'||
3520: 'get_currency_amounts in remain_bdgt:'||x_return_status,
3521: p_module_name => l_module_name,

Line 3687: IF P_PA_DEBUG_MODE = 'Y' THEN

3683: l_ins_pfc_revenue_tab(i),
3684: l_transaction_source_code,
3685: l_ins_other_rej_code_tab(i) ); -- Added for Bug 5203622
3686:
3687: IF P_PA_DEBUG_MODE = 'Y' THEN
3688: PA_DEBUG.RESET_CURR_FUNCTION;
3689: END IF;
3690: EXCEPTION
3691: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3688: PA_DEBUG.RESET_CURR_FUNCTION;

3684: l_transaction_source_code,
3685: l_ins_other_rej_code_tab(i) ); -- Added for Bug 5203622
3686:
3687: IF P_PA_DEBUG_MODE = 'Y' THEN
3688: PA_DEBUG.RESET_CURR_FUNCTION;
3689: END IF;
3690: EXCEPTION
3691: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3692: l_msg_count := FND_MSG_PUB.count_msg;

Line 3710: IF P_PA_DEBUG_MODE = 'Y' THEN

3706:
3707: ROLLBACK;
3708: x_return_status := FND_API.G_RET_STS_ERROR;
3709:
3710: IF P_PA_DEBUG_MODE = 'Y' THEN
3711: pa_fp_gen_amount_utils.fp_debug
3712: (p_msg => 'Invalid Arguments Passed',
3713: p_module_name => l_module_name,
3714: p_log_level => 5);

Line 3715: PA_DEBUG.RESET_CURR_FUNCTION;

3711: pa_fp_gen_amount_utils.fp_debug
3712: (p_msg => 'Invalid Arguments Passed',
3713: p_module_name => l_module_name,
3714: p_log_level => 5);
3715: PA_DEBUG.RESET_CURR_FUNCTION;
3716: END IF;
3717: RAISE;
3718: WHEN OTHERS THEN
3719: rollback;

Line 3729: IF P_PA_DEBUG_MODE = 'Y' THEN

3725: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
3726: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
3727: p_error_text => substr(sqlerrm,1,240));
3728:
3729: IF P_PA_DEBUG_MODE = 'Y' THEN
3730: pa_fp_gen_amount_utils.fp_debug
3731: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3732: p_module_name => l_module_name,
3733: p_log_level => 5);

Line 3734: PA_DEBUG.RESET_CURR_FUNCTION;

3730: pa_fp_gen_amount_utils.fp_debug
3731: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3732: p_module_name => l_module_name,
3733: p_log_level => 5);
3734: PA_DEBUG.RESET_CURR_FUNCTION;
3735: END IF;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END GET_ETC_REMAIN_BDGT_AMTS_BLK;
3738:

Line 4243: IF p_pa_debug_mode = 'Y' THEN

4239: l_msg_index_out NUMBER;
4240:
4241: BEGIN
4242:
4243: IF p_pa_debug_mode = 'Y' THEN
4244: pa_debug.set_curr_function( p_function => 'GET_ETC_FROM_SRC_BDGT',
4245: p_debug_mode => p_pa_debug_mode);
4246: END IF;
4247:

Line 4244: pa_debug.set_curr_function( p_function => 'GET_ETC_FROM_SRC_BDGT',

4240:
4241: BEGIN
4242:
4243: IF p_pa_debug_mode = 'Y' THEN
4244: pa_debug.set_curr_function( p_function => 'GET_ETC_FROM_SRC_BDGT',
4245: p_debug_mode => p_pa_debug_mode);
4246: END IF;
4247:
4248: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4245: p_debug_mode => p_pa_debug_mode);

4241: BEGIN
4242:
4243: IF p_pa_debug_mode = 'Y' THEN
4244: pa_debug.set_curr_function( p_function => 'GET_ETC_FROM_SRC_BDGT',
4245: p_debug_mode => p_pa_debug_mode);
4246: END IF;
4247:
4248: x_return_status := FND_API.G_RET_STS_SUCCESS;
4249: x_msg_count := 0;

Line 5054: IF p_pa_debug_mode = 'Y' THEN

5050: AND bl.txn_currency_code = rbc.txn_currency_code (+);
5051:
5052:
5053: -- Call the maintenance api in ROLLUP mode
5054: IF p_pa_debug_mode = 'Y' THEN
5055: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5056: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
5057: 'MAINTAIN_DATA',
5058: P_MODULE_NAME => l_module_name);

Line 5068: IF p_pa_debug_mode = 'Y' THEN

5064: P_ROLLUP_FLAG => 'Y',
5065: X_RETURN_STATUS => x_return_status,
5066: X_MSG_COUNT => x_msg_count,
5067: X_MSG_DATA => x_msg_data );
5068: IF p_pa_debug_mode = 'Y' THEN
5069: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5070: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
5071: 'MAINTAIN_DATA: '||x_return_status,
5072: P_MODULE_NAME => l_module_name);

Line 5115: IF P_PA_DEBUG_MODE = 'Y' THEN

5111: ra.resource_assignment_id,
5112: sbl.txn_currency_code,
5113: 'ETC';
5114:
5115: IF P_PA_DEBUG_MODE = 'Y' THEN
5116: PA_DEBUG.RESET_CURR_FUNCTION;
5117: END IF;
5118: EXCEPTION
5119: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 5116: PA_DEBUG.RESET_CURR_FUNCTION;

5112: sbl.txn_currency_code,
5113: 'ETC';
5114:
5115: IF P_PA_DEBUG_MODE = 'Y' THEN
5116: PA_DEBUG.RESET_CURR_FUNCTION;
5117: END IF;
5118: EXCEPTION
5119: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5120: l_msg_count := FND_MSG_PUB.count_msg;

Line 5138: IF P_PA_DEBUG_MODE = 'Y' THEN

5134:
5135: ROLLBACK;
5136:
5137: x_return_status := FND_API.G_RET_STS_ERROR;
5138: IF P_PA_DEBUG_MODE = 'Y' THEN
5139: pa_fp_gen_amount_utils.fp_debug
5140: ( p_msg => 'Invalid Arguments Passed',
5141: p_module_name => l_module_name,
5142: p_log_level => 5);

Line 5143: PA_DEBUG.RESET_CURR_FUNCTION;

5139: pa_fp_gen_amount_utils.fp_debug
5140: ( p_msg => 'Invalid Arguments Passed',
5141: p_module_name => l_module_name,
5142: p_log_level => 5);
5143: PA_DEBUG.RESET_CURR_FUNCTION;
5144: END IF;
5145: RAISE;
5146:
5147: WHEN OTHERS then

Line 5157: IF P_PA_DEBUG_MODE = 'Y' THEN

5153: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
5154: p_procedure_name => 'GEN_ETC_FROM_SRC_BDGT',
5155: p_error_text => substr(sqlerrm,1,240));
5156:
5157: IF P_PA_DEBUG_MODE = 'Y' THEN
5158: pa_fp_gen_amount_utils.fp_debug
5159: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5160: p_module_name => l_module_name,
5161: p_log_level => 5);

Line 5162: PA_DEBUG.RESET_CURR_FUNCTION;

5158: pa_fp_gen_amount_utils.fp_debug
5159: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5160: p_module_name => l_module_name,
5161: p_log_level => 5);
5162: PA_DEBUG.RESET_CURR_FUNCTION;
5163: END IF;
5164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5165: END GET_ETC_FROM_SRC_BDGT;
5166:

Line 5266: IF P_PA_DEBUG_MODE = 'Y' THEN

5262: GROUP BY PA_PERIOD_NAME
5263: );
5264: END IF;
5265:
5266: IF P_PA_DEBUG_MODE = 'Y' THEN
5267: PA_DEBUG.RESET_CURR_FUNCTION;
5268: END IF;
5269:
5270: EXCEPTION

Line 5267: PA_DEBUG.RESET_CURR_FUNCTION;

5263: );
5264: END IF;
5265:
5266: IF P_PA_DEBUG_MODE = 'Y' THEN
5267: PA_DEBUG.RESET_CURR_FUNCTION;
5268: END IF;
5269:
5270: EXCEPTION
5271: WHEN OTHERS THEN

Line 5278: IF P_PA_DEBUG_MODE = 'Y' THEN

5274: x_msg_data := SUBSTR(SQLERRM,1,240);
5275: FND_MSG_PUB.add_exc_msg
5276: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3'
5277: ,p_procedure_name => 'PROCESS_PA_GL_DATES');
5278: IF P_PA_DEBUG_MODE = 'Y' THEN
5279: pa_fp_gen_amount_utils.fp_debug
5280: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5281: p_module_name => l_module_name,
5282: p_log_level => 5);

Line 5283: PA_DEBUG.Reset_Curr_Function;

5279: pa_fp_gen_amount_utils.fp_debug
5280: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5281: p_module_name => l_module_name,
5282: p_log_level => 5);
5283: PA_DEBUG.Reset_Curr_Function;
5284: END IF;
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: END PROCESS_PA_GL_DATES;
5287: -- gboomina added for AAI Requirement bug 8318932 - end