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.

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.7 2007/02/06 09:51:34 dthakker 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 2507: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 2509: p_debug_mode => p_pa_debug_mode);

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

Line 2694: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 2719: IF P_PA_DEBUG_MODE = 'Y' THEN

2715: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
2716: X_RETURN_STATUS => x_return_status,
2717: X_MSG_COUNT => x_msg_count,
2718: X_MSG_DATA => x_msg_data );
2719: IF P_PA_DEBUG_MODE = 'Y' THEN
2720: pa_fp_gen_amount_utils.fp_debug(
2721: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2722: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
2723: p_module_name => l_module_name,

Line 2983: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 3008: IF P_PA_DEBUG_MODE = 'Y' THEN

3004: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
3005: X_RETURN_STATUS => x_return_status,
3006: X_MSG_COUNT => x_msg_count,
3007: X_MSG_DATA => x_msg_data );
3008: IF P_PA_DEBUG_MODE = 'Y' THEN
3009: pa_fp_gen_amount_utils.fp_debug(
3010: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3011: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3012: p_module_name => l_module_name,

Line 3349: IF P_PA_DEBUG_MODE = 'Y' THEN

3345: /*Workplan side only stores amounts in one currency for each planning
3346: resource, so still rely on pa_progress_utils.get_actuals_for_task to
3347: get actuals data. This part needs to be revisted when workplan side is
3348: changed to support multi currencies.*/
3349: IF P_PA_DEBUG_MODE = 'Y' THEN
3350: pa_fp_gen_amount_utils.fp_debug(
3351: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
3352: 'GET_WP_ACTUALS_FOR_RA',
3353: p_module_name => l_module_name,

Line 3374: IF P_PA_DEBUG_MODE = 'Y' THEN

3370: X_ACT_PFC_BRDN_COST => lx_act_pfc_brdn_cost,
3371: X_RETURN_STATUS => x_return_status,
3372: X_MSG_COUNT => x_msg_count,
3373: X_MSG_DATA => x_msg_data );
3374: IF P_PA_DEBUG_MODE = 'Y' THEN
3375: pa_fp_gen_amount_utils.fp_debug(
3376: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3377: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3378: p_module_name => l_module_name,

Line 3442: IF P_PA_DEBUG_MODE = 'Y' THEN

3438: WHEN NO_DATA_FOUND THEN
3439: l_task_id := NULL;
3440: l_planning_start_date := NULL;
3441: END;
3442: IF P_PA_DEBUG_MODE = 'Y' THEN
3443: pa_fp_gen_amount_utils.fp_debug(
3444: p_msg => 'Before calling pa_multi_currency_txn.'||
3445: 'get_currency_amounts in remain_bdgt',
3446: p_module_name => l_module_name,

Line 3503: IF P_PA_DEBUG_MODE = 'Y' THEN

3499: ,p_token3 => 'TOCURRENCY'
3500: ,p_value3 => l_tot_currency_code_tab(i) );
3501: x_msg_data := 'PA_FP_PROJ_NO_TXNCONVRATE';
3502: END IF;
3503: IF P_PA_DEBUG_MODE = 'Y' THEN
3504: pa_fp_gen_amount_utils.fp_debug(
3505: p_msg => 'After calling pa_multi_currency_txn.'||
3506: 'get_currency_amounts in remain_bdgt:'||x_return_status,
3507: p_module_name => l_module_name,

Line 3673: IF P_PA_DEBUG_MODE = 'Y' THEN

3669: l_ins_pfc_revenue_tab(i),
3670: l_transaction_source_code,
3671: l_ins_other_rej_code_tab(i) ); -- Added for Bug 5203622
3672:
3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: PA_DEBUG.RESET_CURR_FUNCTION;
3675: END IF;
3676: EXCEPTION
3677: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3674: PA_DEBUG.RESET_CURR_FUNCTION;

3670: l_transaction_source_code,
3671: l_ins_other_rej_code_tab(i) ); -- Added for Bug 5203622
3672:
3673: IF P_PA_DEBUG_MODE = 'Y' THEN
3674: PA_DEBUG.RESET_CURR_FUNCTION;
3675: END IF;
3676: EXCEPTION
3677: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3678: l_msg_count := FND_MSG_PUB.count_msg;

Line 3696: IF P_PA_DEBUG_MODE = 'Y' THEN

3692:
3693: ROLLBACK;
3694: x_return_status := FND_API.G_RET_STS_ERROR;
3695:
3696: IF P_PA_DEBUG_MODE = 'Y' THEN
3697: pa_fp_gen_amount_utils.fp_debug
3698: (p_msg => 'Invalid Arguments Passed',
3699: p_module_name => l_module_name,
3700: p_log_level => 5);

Line 3701: PA_DEBUG.RESET_CURR_FUNCTION;

3697: pa_fp_gen_amount_utils.fp_debug
3698: (p_msg => 'Invalid Arguments Passed',
3699: p_module_name => l_module_name,
3700: p_log_level => 5);
3701: PA_DEBUG.RESET_CURR_FUNCTION;
3702: END IF;
3703: RAISE;
3704: WHEN OTHERS THEN
3705: rollback;

Line 3715: IF P_PA_DEBUG_MODE = 'Y' THEN

3711: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
3712: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
3713: p_error_text => substr(sqlerrm,1,240));
3714:
3715: IF P_PA_DEBUG_MODE = 'Y' THEN
3716: pa_fp_gen_amount_utils.fp_debug
3717: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3718: p_module_name => l_module_name,
3719: p_log_level => 5);

Line 3720: PA_DEBUG.RESET_CURR_FUNCTION;

3716: pa_fp_gen_amount_utils.fp_debug
3717: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3718: p_module_name => l_module_name,
3719: p_log_level => 5);
3720: PA_DEBUG.RESET_CURR_FUNCTION;
3721: END IF;
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: END GET_ETC_REMAIN_BDGT_AMTS_BLK;
3724: