APPS.PA_FP_GEN_FCST_AMT_PUB1 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_PUB1 as
2: /* $Header: PAFPFG2B.pls 120.12.12020000.2 2013/05/17 09:39:40 bpottipa ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /**
7: * This procedure updates planning txn level override rates
8: * for NON-RATE-BASED txns in the following ways:

Line 130: IF p_pa_debug_mode = 'Y' THEN

126:
127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128: x_msg_count := 0;
129:
130: IF p_pa_debug_mode = 'Y' THEN
131: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
132: p_debug_mode => p_pa_debug_mode );
133: END IF;
134:

Line 131: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,

127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128: x_msg_count := 0;
129:
130: IF p_pa_debug_mode = 'Y' THEN
131: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
132: p_debug_mode => p_pa_debug_mode );
133: END IF;
134:
135: -- Print values of Input Parameters to debug log

Line 132: p_debug_mode => p_pa_debug_mode );

128: x_msg_count := 0;
129:
130: IF p_pa_debug_mode = 'Y' THEN
131: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
132: p_debug_mode => p_pa_debug_mode );
133: END IF;
134:
135: -- Print values of Input Parameters to debug log
136: IF p_pa_debug_mode = 'Y' THEN

Line 136: IF p_pa_debug_mode = 'Y' THEN

132: p_debug_mode => p_pa_debug_mode );
133: END IF;
134:
135: -- Print values of Input Parameters to debug log
136: IF p_pa_debug_mode = 'Y' THEN
137: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
138: ( p_msg => 'Input Parameters for '
139: || l_module_name || '():',
140: --p_called_mode => p_called_mode,

Line 170: END IF; -- IF p_pa_debug_mode = 'Y' THEN

166: ( p_msg => 'P_ETC_START_DATE:['||p_etc_start_date||']',
167: --p_called_mode => p_called_mode,
168: p_module_name => l_module_name,
169: p_log_level => l_log_level );
170: END IF; -- IF p_pa_debug_mode = 'Y' THEN
171:
172: -- Validate input parameters
173: IF p_project_id is NULL OR
174: p_budget_version_id is NULL OR

Line 177: IF p_pa_debug_mode = 'Y' THEN

173: IF p_project_id is NULL OR
174: p_budget_version_id is NULL OR
175: ( p_etc_start_date is NULL AND
176: p_fp_cols_rec.x_plan_class_code = 'FORECAST' ) THEN
177: IF p_pa_debug_mode = 'Y' THEN
178: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
179: ( p_msg => 'Input Parameter Validation FAILED',
180: --p_called_mode => p_called_mode,
181: p_module_name => l_module_name,

Line 183: PA_DEBUG.RESET_CURR_FUNCTION;

179: ( p_msg => 'Input Parameter Validation FAILED',
180: --p_called_mode => p_called_mode,
181: p_module_name => l_module_name,
182: p_log_level => l_log_level );
183: PA_DEBUG.RESET_CURR_FUNCTION;
184: END IF;
185: RETURN;
186: END IF;
187:

Line 212: IF p_pa_debug_mode = 'Y' THEN

208: -- txns that need to be updated so that maintain_data
209: -- can be called just once.
210: l_maint_data_ins_req_flag := 'N';
211:
212: IF p_pa_debug_mode = 'Y' THEN
213: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
214: ( p_msg => 'Beginning Update Case 1',
215: --p_called_mode => p_called_mode,
216: p_module_name => l_module_name,

Line 258: IF p_pa_debug_mode = 'Y' THEN

254: IF l_rbc_tmp_tbl_deleted_flag = 'N' THEN
255: DELETE pa_resource_asgn_curr_tmp;
256: l_rbc_tmp_tbl_deleted_flag := 'Y';
257:
258: IF p_pa_debug_mode = 'Y' THEN
259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
260: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',
261: --p_called_mode => p_called_mode,
262: p_module_name => l_module_name,

Line 281: IF p_pa_debug_mode = 'Y' THEN

277: 0, -- txn_raw_cost_rate_override
278: 0, -- txn_burden_cost_rate_override
279: 1 ); -- txn_bill_rate_override
280:
281: IF p_pa_debug_mode = 'Y' THEN
282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
283: ( p_msg => 'Number of records Inserted into ' ||
284: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',
285: --p_called_mode => p_called_mode,

Line 294: IF p_pa_debug_mode = 'Y' THEN

290:
291: END IF; -- IF p_fp_cols_rec.x_version_type = 'ALL' THEN
292: /* End Update Case 1 */
293:
294: IF p_pa_debug_mode = 'Y' THEN
295: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
296: ( p_msg => 'Beginning Update Case 2',
297: --p_called_mode => p_called_mode,
298: p_module_name => l_module_name,

Line 345: IF p_pa_debug_mode = 'Y' THEN

341: IF l_rbc_tmp_tbl_deleted_flag = 'N' THEN
342: DELETE pa_resource_asgn_curr_tmp;
343: l_rbc_tmp_tbl_deleted_flag := 'Y';
344:
345: IF p_pa_debug_mode = 'Y' THEN
346: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
347: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',
348: --p_called_mode => p_called_mode,
349: p_module_name => l_module_name,

Line 373: IF p_pa_debug_mode = 'Y' THEN

369: VALUES
370: ( l_res_asg_id_tab(i),
371: l_txn_currency_code_tab(i) );
372:
373: IF p_pa_debug_mode = 'Y' THEN
374: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
375: ( p_msg => 'Number of records Inserted into ' ||
376: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',
377: --p_called_mode => p_called_mode,

Line 393: IF p_pa_debug_mode = 'Y' THEN

389:
390: IF l_maint_data_ins_req_flag = 'Y' THEN
391:
392: -- Call the maintenance api in INSERT mode
393: IF p_pa_debug_mode = 'Y' THEN
394: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
395: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
396: 'MAINTAIN_DATA',
397: --P_CALLED_MODE => p_called_mode,

Line 409: IF p_pa_debug_mode = 'Y' THEN

405: --P_CALLED_MODE => p_called_mode,
406: X_RETURN_STATUS => x_return_status,
407: X_MSG_COUNT => x_msg_count,
408: X_MSG_DATA => x_msg_data );
409: IF p_pa_debug_mode = 'Y' THEN
410: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
411: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
412: 'MAINTAIN_DATA: '||x_return_status,
413: --P_CALLED_MODE => p_called_mode,

Line 422: IF p_pa_debug_mode = 'Y' THEN

418: END IF;
419:
420: END IF; -- IF l_maint_data_ins_req_flag = 'Y' THEN
421:
422: IF p_pa_debug_mode = 'Y' THEN
423: PA_DEBUG.RESET_CURR_FUNCTION;
424: END IF;
425: EXCEPTION
426: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 423: PA_DEBUG.RESET_CURR_FUNCTION;

419:
420: END IF; -- IF l_maint_data_ins_req_flag = 'Y' THEN
421:
422: IF p_pa_debug_mode = 'Y' THEN
423: PA_DEBUG.RESET_CURR_FUNCTION;
424: END IF;
425: EXCEPTION
426: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
427: l_msg_count := FND_MSG_PUB.count_msg;

Line 445: IF p_pa_debug_mode = 'Y' THEN

441:
442: ROLLBACK;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: IF p_pa_debug_mode = 'Y' THEN
446: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
447: (p_msg => 'Invalid Arguments Passed',
448: p_module_name => l_module_name,
449: p_log_level => 5);

Line 450: PA_DEBUG.RESET_CURR_FUNCTION;

446: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
447: (p_msg => 'Invalid Arguments Passed',
448: p_module_name => l_module_name,
449: p_log_level => 5);
450: PA_DEBUG.RESET_CURR_FUNCTION;
451: END IF;
452: RAISE;
453: WHEN OTHERS THEN
454: ROLLBACK;

Line 463: IF p_pa_debug_mode = 'Y' THEN

459: ( p_pkg_name => l_package_name,
460: p_procedure_name => l_procedure_name,
461: p_error_text => substr(sqlerrm,1,240));
462:
463: IF p_pa_debug_mode = 'Y' THEN
464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
465: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
466: p_module_name => l_module_name,
467: p_log_level => 5);

Line 468: PA_DEBUG.RESET_CURR_FUNCTION;

464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
465: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
466: p_module_name => l_module_name,
467: p_log_level => 5);
468: PA_DEBUG.RESET_CURR_FUNCTION;
469: END IF;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471:
472: END UPD_NRB_TXN_OVR_RATES;

Line 518: IF p_pa_debug_mode = 'Y' THEN

514:
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516: x_msg_count := 0;
517:
518: IF p_pa_debug_mode = 'Y' THEN
519: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
520: p_debug_mode => p_pa_debug_mode );
521: END IF;
522:

Line 519: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,

515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516: x_msg_count := 0;
517:
518: IF p_pa_debug_mode = 'Y' THEN
519: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
520: p_debug_mode => p_pa_debug_mode );
521: END IF;
522:
523: IF p_source_res_asg_id IS NULL OR p_txn_currency_code is NULL THEN

Line 520: p_debug_mode => p_pa_debug_mode );

516: x_msg_count := 0;
517:
518: IF p_pa_debug_mode = 'Y' THEN
519: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
520: p_debug_mode => p_pa_debug_mode );
521: END IF;
522:
523: IF p_source_res_asg_id IS NULL OR p_txn_currency_code is NULL THEN
524: IF p_pa_debug_mode = 'Y' THEN

Line 524: IF p_pa_debug_mode = 'Y' THEN

520: p_debug_mode => p_pa_debug_mode );
521: END IF;
522:
523: IF p_source_res_asg_id IS NULL OR p_txn_currency_code is NULL THEN
524: IF p_pa_debug_mode = 'Y' THEN
525: PA_DEBUG.RESET_CURR_FUNCTION;
526: END IF;
527: RETURN;
528: END IF;

Line 525: PA_DEBUG.RESET_CURR_FUNCTION;

521: END IF;
522:
523: IF p_source_res_asg_id IS NULL OR p_txn_currency_code is NULL THEN
524: IF p_pa_debug_mode = 'Y' THEN
525: PA_DEBUG.RESET_CURR_FUNCTION;
526: END IF;
527: RETURN;
528: END IF;
529:

Line 560: IF p_pa_debug_mode = 'Y' THEN

556: l_burdened_cost_rate_tab(i),
557: l_revenue_bill_rate_tab(i),
558: p_target_res_asg_id );
559:
560: IF p_pa_debug_mode = 'Y' THEN
561: PA_DEBUG.RESET_CURR_FUNCTION;
562: END IF;
563: EXCEPTION
564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 561: PA_DEBUG.RESET_CURR_FUNCTION;

557: l_revenue_bill_rate_tab(i),
558: p_target_res_asg_id );
559:
560: IF p_pa_debug_mode = 'Y' THEN
561: PA_DEBUG.RESET_CURR_FUNCTION;
562: END IF;
563: EXCEPTION
564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
565: l_msg_count := FND_MSG_PUB.count_msg;

Line 583: IF p_pa_debug_mode = 'Y' THEN

579:
580: ROLLBACK;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582:
583: IF p_pa_debug_mode = 'Y' THEN
584: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
585: (p_msg => 'Invalid Arguments Passed',
586: p_module_name => l_module_name,
587: p_log_level => 5);

Line 588: PA_DEBUG.RESET_CURR_FUNCTION;

584: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
585: (p_msg => 'Invalid Arguments Passed',
586: p_module_name => l_module_name,
587: p_log_level => 5);
588: PA_DEBUG.RESET_CURR_FUNCTION;
589: END IF;
590: RAISE;
591: WHEN OTHERS THEN
592: ROLLBACK;

Line 601: IF p_pa_debug_mode = 'Y' THEN

597: ( p_pkg_name => l_package_name,
598: p_procedure_name => l_procedure_name,
599: p_error_text => substr(sqlerrm,1,240));
600:
601: IF p_pa_debug_mode = 'Y' THEN
602: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
603: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
604: p_module_name => l_module_name,
605: p_log_level => 5);

Line 606: PA_DEBUG.RESET_CURR_FUNCTION;

602: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
603: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
604: p_module_name => l_module_name,
605: p_log_level => 5);
606: PA_DEBUG.RESET_CURR_FUNCTION;
607: END IF;
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609:
610: END POPULATE_GEN_RATE;

Line 657: IF p_pa_debug_mode = 'Y' THEN

653: BEGIN
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655: x_msg_count := 0;
656:
657: IF p_pa_debug_mode = 'Y' THEN
658: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'CHK_UPD_RATE_BASED_FLAG',
659: p_debug_mode => p_pa_debug_mode );
660: END IF;
661:

Line 658: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'CHK_UPD_RATE_BASED_FLAG',

654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655: x_msg_count := 0;
656:
657: IF p_pa_debug_mode = 'Y' THEN
658: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'CHK_UPD_RATE_BASED_FLAG',
659: p_debug_mode => p_pa_debug_mode );
660: END IF;
661:
662: OPEN get_res_asg_cur;

Line 659: p_debug_mode => p_pa_debug_mode );

655: x_msg_count := 0;
656:
657: IF p_pa_debug_mode = 'Y' THEN
658: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'CHK_UPD_RATE_BASED_FLAG',
659: p_debug_mode => p_pa_debug_mode );
660: END IF;
661:
662: OPEN get_res_asg_cur;
663: FETCH get_res_asg_cur

Line 669: IF p_pa_debug_mode = 'Y' THEN

665: INTO l_res_asg_id_tab;
666: CLOSE get_res_asg_cur;
667:
668: IF l_res_asg_id_tab.count = 0 THEN
669: IF p_pa_debug_mode = 'Y' THEN
670: PA_DEBUG.RESET_CURR_FUNCTION;
671: END IF;
672: RETURN;
673: END IF;

Line 670: PA_DEBUG.RESET_CURR_FUNCTION;

666: CLOSE get_res_asg_cur;
667:
668: IF l_res_asg_id_tab.count = 0 THEN
669: IF p_pa_debug_mode = 'Y' THEN
670: PA_DEBUG.RESET_CURR_FUNCTION;
671: END IF;
672: RETURN;
673: END IF;
674:

Line 684: IF p_pa_debug_mode = 'Y' THEN

680: last_updated_by = l_last_updated_by,
681: last_update_login = l_last_update_login
682: WHERE resource_assignment_id = l_res_asg_id_tab(i);
683:
684: IF p_pa_debug_mode = 'Y' THEN
685: PA_DEBUG.RESET_CURR_FUNCTION;
686: END IF;
687: EXCEPTION
688: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 685: PA_DEBUG.RESET_CURR_FUNCTION;

681: last_update_login = l_last_update_login
682: WHERE resource_assignment_id = l_res_asg_id_tab(i);
683:
684: IF p_pa_debug_mode = 'Y' THEN
685: PA_DEBUG.RESET_CURR_FUNCTION;
686: END IF;
687: EXCEPTION
688: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
689: l_msg_count := FND_MSG_PUB.count_msg;

Line 707: IF p_pa_debug_mode = 'Y' THEN

703:
704: ROLLBACK;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706:
707: IF p_pa_debug_mode = 'Y' THEN
708: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
709: (p_msg => 'Invalid Arguments Passed',
710: p_module_name => l_module_name,
711: p_log_level => 5);

Line 712: PA_DEBUG.RESET_CURR_FUNCTION;

708: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
709: (p_msg => 'Invalid Arguments Passed',
710: p_module_name => l_module_name,
711: p_log_level => 5);
712: PA_DEBUG.RESET_CURR_FUNCTION;
713: END IF;
714: RAISE;
715: WHEN OTHERS THEN
716: ROLLBACK;

Line 725: IF p_pa_debug_mode = 'Y' THEN

721: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
722: p_procedure_name => 'CHK_UPD_RATE_BASED_FLAG',
723: p_error_text => substr(sqlerrm,1,240));
724:
725: IF p_pa_debug_mode = 'Y' THEN
726: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
727: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
728: p_module_name => l_module_name,
729: p_log_level => 5);

Line 730: PA_DEBUG.RESET_CURR_FUNCTION;

726: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
727: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
728: p_module_name => l_module_name,
729: p_log_level => 5);
730: PA_DEBUG.RESET_CURR_FUNCTION;
731: END IF;
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733:
734: END CHK_UPD_RATE_BASED_FLAG;

Line 770: IF p_pa_debug_mode = 'Y' THEN

766: l_count NUMBER;
767: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
768: l_uncategorized_flag VARCHAR2(1);
769: BEGIN
770: IF p_pa_debug_mode = 'Y' THEN
771: pa_debug.set_curr_function( p_function => 'CALL_SUMM_POP_TMPS',
772: p_debug_mode => p_pa_debug_mode);
773: END IF;
774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 771: pa_debug.set_curr_function( p_function => 'CALL_SUMM_POP_TMPS',

767: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
768: l_uncategorized_flag VARCHAR2(1);
769: BEGIN
770: IF p_pa_debug_mode = 'Y' THEN
771: pa_debug.set_curr_function( p_function => 'CALL_SUMM_POP_TMPS',
772: p_debug_mode => p_pa_debug_mode);
773: END IF;
774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
775: X_MSG_COUNT := 0;

Line 772: p_debug_mode => p_pa_debug_mode);

768: l_uncategorized_flag VARCHAR2(1);
769: BEGIN
770: IF p_pa_debug_mode = 'Y' THEN
771: pa_debug.set_curr_function( p_function => 'CALL_SUMM_POP_TMPS',
772: p_debug_mode => p_pa_debug_mode);
773: END IF;
774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
775: X_MSG_COUNT := 0;
776:

Line 788: IF P_PA_DEBUG_MODE = 'Y' THEN

784: l_struct_ver_id_tab(1) := P_STRUCT_VER_ID;
785: l_calendar_type_tab(1) := P_CALENDAR_TYPE;
786: l_end_date_tab(1) := P_ACTUALS_THRU_DATE;
787:
788: IF P_PA_DEBUG_MODE = 'Y' THEN
789: pa_fp_gen_amount_utils.fp_debug
790: (p_msg => 'Before calling PJI_FM_XBS_ACCUM_UTILS.get_summarized_data;'
791: ||'project id passed to get_summarized:'||l_project_id_tab(1)
792: ||'; resource_list_id:'||l_resource_list_id_tab(1)

Line 817: IF P_PA_DEBUG_MODE = 'Y' THEN

813: p_record_type => p_record_type,
814: p_currency_type => 6,
815: x_return_status => x_return_status,
816: x_msg_code => x_msg_data);
817: IF P_PA_DEBUG_MODE = 'Y' THEN
818: pa_fp_gen_amount_utils.fp_debug
819: (p_msg => 'After calling PJI_FM_XBS_ACCUM_UTILS.get_summarized_data,
820: return status is:'||x_return_status,
821: p_module_name => l_module_name,

Line 957: IF p_pa_debug_mode = 'Y' THEN

953: EQUIPMENT_HOURS,
954: SOURCE_ID,
955: P_DATA_TYPE_CODE
956: FROM PJI_FM_XBS_ACCUM_TMP1 );
957: IF p_pa_debug_mode = 'Y' THEN
958: PA_DEBUG.Reset_Curr_Function;
959: END IF;
960: EXCEPTION
961: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 958: PA_DEBUG.Reset_Curr_Function;

954: SOURCE_ID,
955: P_DATA_TYPE_CODE
956: FROM PJI_FM_XBS_ACCUM_TMP1 );
957: IF p_pa_debug_mode = 'Y' THEN
958: PA_DEBUG.Reset_Curr_Function;
959: END IF;
960: EXCEPTION
961: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
962: l_msg_count := FND_MSG_PUB.count_msg;

Line 979: IF P_PA_DEBUG_MODE = 'Y' THEN

975: END IF;
976: ROLLBACK;
977:
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: IF P_PA_DEBUG_MODE = 'Y' THEN
980: pa_fp_gen_amount_utils.fp_debug
981: (p_msg => 'Invalid Arguments Passed',
982: p_module_name => l_module_name,
983: p_log_level => 5);

Line 984: PA_DEBUG.Reset_Curr_Function;

980: pa_fp_gen_amount_utils.fp_debug
981: (p_msg => 'Invalid Arguments Passed',
982: p_module_name => l_module_name,
983: p_log_level => 5);
984: PA_DEBUG.Reset_Curr_Function;
985: END IF;
986: RAISE;
987:
988: WHEN OTHERS THEN

Line 994: IF P_PA_DEBUG_MODE = 'Y' THEN

990: x_msg_data := SUBSTR(SQLERRM,1,240);
991: FND_MSG_PUB.add_exc_msg
992: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1'
993: ,p_procedure_name => 'CALL_SUMM_POP_TMPS');
994: IF P_PA_DEBUG_MODE = 'Y' THEN
995: pa_fp_gen_amount_utils.fp_debug
996: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
997: p_module_name => l_module_name,
998: p_log_level => 5);

Line 999: PA_DEBUG.Reset_Curr_Function;

995: pa_fp_gen_amount_utils.fp_debug
996: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
997: p_module_name => l_module_name,
998: p_log_level => 5);
999: PA_DEBUG.Reset_Curr_Function;
1000: END IF;
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END CALL_SUMM_POP_TMPS;
1003:

Line 1221: IF p_pa_debug_mode = 'Y' THEN

1217: l_msg_data VARCHAR2(2000);
1218: l_data VARCHAR2(2000);
1219: l_msg_index_out NUMBER:=0;
1220: BEGIN
1221: IF p_pa_debug_mode = 'Y' THEN
1222: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS_WRP',
1223: p_debug_mode => p_pa_debug_mode);
1224: END IF;
1225: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1222: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS_WRP',

1218: l_data VARCHAR2(2000);
1219: l_msg_index_out NUMBER:=0;
1220: BEGIN
1221: IF p_pa_debug_mode = 'Y' THEN
1222: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS_WRP',
1223: p_debug_mode => p_pa_debug_mode);
1224: END IF;
1225: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1226: X_MSG_COUNT := 0;

Line 1223: p_debug_mode => p_pa_debug_mode);

1219: l_msg_index_out NUMBER:=0;
1220: BEGIN
1221: IF p_pa_debug_mode = 'Y' THEN
1222: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS_WRP',
1223: p_debug_mode => p_pa_debug_mode);
1224: END IF;
1225: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1226: X_MSG_COUNT := 0;
1227:

Line 1350: IF P_PA_DEBUG_MODE = 'Y' THEN

1346: END IF;
1347: END IF;
1348:
1349: IF l_res_asg_id_tab.count = 0 THEN
1350: IF P_PA_DEBUG_MODE = 'Y' THEN
1351: pa_fp_gen_amount_utils.fp_debug
1352: (p_msg => 'inside GEN_AVERAGE_OF_ACTUALS_WRP,no res asg, return...',
1353: p_module_name => l_module_name,
1354: p_log_level => 5);

Line 1355: PA_DEBUG.RESET_CURR_FUNCTION;

1351: pa_fp_gen_amount_utils.fp_debug
1352: (p_msg => 'inside GEN_AVERAGE_OF_ACTUALS_WRP,no res asg, return...',
1353: p_module_name => l_module_name,
1354: p_log_level => 5);
1355: PA_DEBUG.RESET_CURR_FUNCTION;
1356: END IF;
1357: RETURN;
1358: END IF;
1359: FOR i IN 1..l_res_asg_id_tab.count LOOP

Line 1382: IF P_PA_DEBUG_MODE = 'Y' THEN

1378: l_currency_flag := 'PC';
1379: l_currency_code := P_FP_COLS_REC.x_project_currency_code;
1380: END IF;
1381:
1382: IF P_PA_DEBUG_MODE = 'Y' THEN
1383: pa_fp_gen_amount_utils.fp_debug
1384: (p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PVT.GEN_AVERAGE_OF_ACTUALS',
1385: p_module_name => l_module_name,
1386: p_log_level => 5);

Line 1407: IF P_PA_DEBUG_MODE = 'Y' THEN

1403: P_RESOURCE_ASSIGNMENT_ID => l_res_asg_id_tab(i),
1404: X_RETURN_STATUS => X_RETURN_STATUS,
1405: X_MSG_COUNT => X_MSG_COUNT,
1406: X_MSG_DATA => X_MSG_DATA );
1407: IF P_PA_DEBUG_MODE = 'Y' THEN
1408: pa_fp_gen_amount_utils.fp_debug
1409: (p_msg => 'After calling PA_FP_GEN_FCST_AMT_PVT.GEN_AVERAGE_OF_ACTUALS,
1410: return status is: '||x_return_status,
1411: p_module_name => l_module_name,

Line 1430: IF P_PA_DEBUG_MODE = 'Y' THEN

1426: sp_fixed_date = NULL,
1427: transaction_source_code = 'AVERAGE_ACTUALS' -- bug 4232619
1428: WHERE resource_assignment_id = l_res_asg_id_tab(i);
1429:
1430: IF P_PA_DEBUG_MODE = 'Y' THEN
1431: PA_DEBUG.RESET_CURR_FUNCTION;
1432: END IF;
1433: EXCEPTION
1434: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1431: PA_DEBUG.RESET_CURR_FUNCTION;

1427: transaction_source_code = 'AVERAGE_ACTUALS' -- bug 4232619
1428: WHERE resource_assignment_id = l_res_asg_id_tab(i);
1429:
1430: IF P_PA_DEBUG_MODE = 'Y' THEN
1431: PA_DEBUG.RESET_CURR_FUNCTION;
1432: END IF;
1433: EXCEPTION
1434: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1435: l_msg_count := FND_MSG_PUB.count_msg;

Line 1453: IF P_PA_DEBUG_MODE = 'Y' THEN

1449:
1450: ROLLBACK;
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452:
1453: IF P_PA_DEBUG_MODE = 'Y' THEN
1454: pa_fp_gen_amount_utils.fp_debug
1455: (p_msg => 'Invalid Arguments Passed',
1456: p_module_name => l_module_name,
1457: p_log_level => 5);

Line 1458: PA_DEBUG.RESET_CURR_FUNCTION;

1454: pa_fp_gen_amount_utils.fp_debug
1455: (p_msg => 'Invalid Arguments Passed',
1456: p_module_name => l_module_name,
1457: p_log_level => 5);
1458: PA_DEBUG.RESET_CURR_FUNCTION;
1459: END IF;
1460: RAISE;
1461: WHEN OTHERS THEN
1462: rollback;

Line 1471: IF P_PA_DEBUG_MODE = 'Y' THEN

1467: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
1468: p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS_WRP',
1469: p_error_text => substr(sqlerrm,1,240));
1470:
1471: IF P_PA_DEBUG_MODE = 'Y' THEN
1472: pa_fp_gen_amount_utils.fp_debug
1473: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1474: p_module_name => l_module_name,
1475: p_log_level => 5);

Line 1476: PA_DEBUG.RESET_CURR_FUNCTION;

1472: pa_fp_gen_amount_utils.fp_debug
1473: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1474: p_module_name => l_module_name,
1475: p_log_level => 5);
1476: PA_DEBUG.RESET_CURR_FUNCTION;
1477: END IF;
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END GEN_AVERAGE_OF_ACTUALS_WRP;
1480:

Line 1551: IF p_pa_debug_mode = 'Y' THEN

1547: l_msg_data VARCHAR2(2000);
1548: l_data VARCHAR2(2000);
1549: l_msg_index_out NUMBER:=0;
1550: BEGIN
1551: IF p_pa_debug_mode = 'Y' THEN
1552: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
1553: p_debug_mode => p_pa_debug_mode);
1554: END IF;
1555: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

1548: l_data VARCHAR2(2000);
1549: l_msg_index_out NUMBER:=0;
1550: BEGIN
1551: IF p_pa_debug_mode = 'Y' THEN
1552: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
1553: p_debug_mode => p_pa_debug_mode);
1554: END IF;
1555: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1556: X_MSG_COUNT := 0;

Line 1553: p_debug_mode => p_pa_debug_mode);

1549: l_msg_index_out NUMBER:=0;
1550: BEGIN
1551: IF p_pa_debug_mode = 'Y' THEN
1552: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
1553: p_debug_mode => p_pa_debug_mode);
1554: END IF;
1555: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1556: X_MSG_COUNT := 0;
1557:

Line 1588: IF P_PA_DEBUG_MODE = 'Y' THEN

1584: AND data_type_code = P_ETC_SOURCE_CODE;
1585: /* hr_utility.trace('currency count tot :'||l_currency_count_tot );
1586: hr_utility.trace('currency count act :'||l_currency_count_act ); */
1587: IF l_currency_count_tot = 0 and l_currency_count_act = 0 THEN
1588: IF P_PA_DEBUG_MODE = 'Y' THEN
1589: PA_DEBUG.RESET_CURR_FUNCTION;
1590: END IF;
1591: RETURN;
1592: END IF;

Line 1589: PA_DEBUG.RESET_CURR_FUNCTION;

1585: /* hr_utility.trace('currency count tot :'||l_currency_count_tot );
1586: hr_utility.trace('currency count act :'||l_currency_count_act ); */
1587: IF l_currency_count_tot = 0 and l_currency_count_act = 0 THEN
1588: IF P_PA_DEBUG_MODE = 'Y' THEN
1589: PA_DEBUG.RESET_CURR_FUNCTION;
1590: END IF;
1591: RETURN;
1592: END IF;
1593:

Line 1712: IF P_PA_DEBUG_MODE = 'Y' THEN

1708: /*getting actuals*/
1709: l_currency_flag := 'PC';
1710: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
1711:
1712: IF P_PA_DEBUG_MODE = 'Y' THEN
1713: pa_fp_gen_amount_utils.fp_debug
1714: (p_msg => 'Before calling PA_PROGRESS_UTILS.'||
1715: 'get_actuals_for_task in remain_bdgt',
1716: p_module_name => l_module_name,

Line 1753: IF P_PA_DEBUG_MODE = 'Y' THEN

1749: X_OTH_QUANTITY => l_oth_quantity,
1750: x_return_status => x_return_status,
1751: x_msg_count => x_msg_count,
1752: x_msg_data => x_msg_data );
1753: IF P_PA_DEBUG_MODE = 'Y' THEN
1754: pa_fp_gen_amount_utils.fp_debug
1755: (p_msg => 'After calling PA_PROGRESS_UTILS.'||
1756: 'get_actuals_for_task in remain_bdgt'||x_return_status,
1757: p_module_name => l_module_name,

Line 1856: IF P_PA_DEBUG_MODE = 'Y' THEN

1852: l_etc_txn_raw_cost,
1853: l_etc_txn_brdn_cost);
1854: END IF;
1855:
1856: IF P_PA_DEBUG_MODE = 'Y' THEN
1857: PA_DEBUG.RESET_CURR_FUNCTION;
1858: END IF;
1859: EXCEPTION
1860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1857: PA_DEBUG.RESET_CURR_FUNCTION;

1853: l_etc_txn_brdn_cost);
1854: END IF;
1855:
1856: IF P_PA_DEBUG_MODE = 'Y' THEN
1857: PA_DEBUG.RESET_CURR_FUNCTION;
1858: END IF;
1859: EXCEPTION
1860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1861: l_msg_count := FND_MSG_PUB.count_msg;

Line 1879: IF P_PA_DEBUG_MODE = 'Y' THEN

1875:
1876: ROLLBACK;
1877: x_return_status := FND_API.G_RET_STS_ERROR;
1878:
1879: IF P_PA_DEBUG_MODE = 'Y' THEN
1880: pa_fp_gen_amount_utils.fp_debug
1881: (p_msg => 'Invalid Arguments Passed',
1882: p_module_name => l_module_name,
1883: p_log_level => 5);

Line 1884: PA_DEBUG.RESET_CURR_FUNCTION;

1880: pa_fp_gen_amount_utils.fp_debug
1881: (p_msg => 'Invalid Arguments Passed',
1882: p_module_name => l_module_name,
1883: p_log_level => 5);
1884: PA_DEBUG.RESET_CURR_FUNCTION;
1885: END IF;
1886: RAISE;
1887: WHEN OTHERS THEN
1888: rollback;

Line 1898: IF P_PA_DEBUG_MODE = 'Y' THEN

1894: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
1895: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS',
1896: p_error_text => substr(sqlerrm,1,240));
1897:
1898: IF P_PA_DEBUG_MODE = 'Y' THEN
1899: pa_fp_gen_amount_utils.fp_debug
1900: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1901: p_module_name => l_module_name,
1902: p_log_level => 5);

Line 1903: PA_DEBUG.RESET_CURR_FUNCTION;

1899: pa_fp_gen_amount_utils.fp_debug
1900: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1901: p_module_name => l_module_name,
1902: p_log_level => 5);
1903: PA_DEBUG.RESET_CURR_FUNCTION;
1904: END IF;
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END GET_ETC_REMAIN_BDGT_AMTS;
1907:

Line 1956: IF p_pa_debug_mode = 'Y' THEN

1952: l_data VARCHAR2(2000);
1953: l_msg_index_out NUMBER:=0;
1954: l_WP_STRUCTURE_VERSION_ID number;
1955: BEGIN
1956: IF p_pa_debug_mode = 'Y' THEN
1957: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
1958: p_debug_mode => p_pa_debug_mode);
1959: END IF;
1960: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1957: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',

1953: l_msg_index_out NUMBER:=0;
1954: l_WP_STRUCTURE_VERSION_ID number;
1955: BEGIN
1956: IF p_pa_debug_mode = 'Y' THEN
1957: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
1958: p_debug_mode => p_pa_debug_mode);
1959: END IF;
1960: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1961: X_MSG_COUNT := 0;

Line 1958: p_debug_mode => p_pa_debug_mode);

1954: l_WP_STRUCTURE_VERSION_ID number;
1955: BEGIN
1956: IF p_pa_debug_mode = 'Y' THEN
1957: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
1958: p_debug_mode => p_pa_debug_mode);
1959: END IF;
1960: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1961: X_MSG_COUNT := 0;
1962:

Line 1989: IF P_PA_DEBUG_MODE = 'Y' THEN

1985: END IF;
1986: END IF;
1987:
1988:
1989: IF P_PA_DEBUG_MODE = 'Y' THEN
1990: pa_fp_gen_amount_utils.fp_debug
1991: (p_msg => 'Before calling PA_PROGRESS_UTILS.REDEFAULT_BASE_PC',
1992: p_module_name => l_module_name,
1993: p_log_level => 5);

Line 2015: IF P_PA_DEBUG_MODE = 'Y' THEN

2011: X_base_percent_complete => lx_percent_complete,
2012: x_return_status => x_return_status,
2013: x_msg_count => x_msg_count,
2014: x_msg_data => x_msg_data );
2015: IF P_PA_DEBUG_MODE = 'Y' THEN
2016: pa_fp_gen_amount_utils.fp_debug
2017: (p_msg => 'After calling PA_PROGRESS_UTILS.REDEFAULT_BASE_PC,
2018: return status is:'||x_return_status,
2019: p_module_name => l_module_name,

Line 2058: IF P_PA_DEBUG_MODE = 'Y' THEN

2054: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2055: AND res_asg_id = P_RESOURCE_ASSIGNMENT_ID;*/
2056:
2057: IF l_currency_count_tot = 0 THEN
2058: IF P_PA_DEBUG_MODE = 'Y' THEN
2059: PA_DEBUG.RESET_CURR_FUNCTION;
2060: END IF;
2061: RETURN;
2062: END IF;

Line 2059: PA_DEBUG.RESET_CURR_FUNCTION;

2055: AND res_asg_id = P_RESOURCE_ASSIGNMENT_ID;*/
2056:
2057: IF l_currency_count_tot = 0 THEN
2058: IF P_PA_DEBUG_MODE = 'Y' THEN
2059: PA_DEBUG.RESET_CURR_FUNCTION;
2060: END IF;
2061: RETURN;
2062: END IF;
2063:

Line 2126: IF P_PA_DEBUG_MODE = 'Y' THEN

2122: l_etc_txn_raw_cost,
2123: l_etc_txn_brdn_cost);
2124: END IF;
2125:
2126: IF P_PA_DEBUG_MODE = 'Y' THEN
2127: PA_DEBUG.RESET_CURR_FUNCTION;
2128: END IF;
2129: EXCEPTION
2130: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2127: PA_DEBUG.RESET_CURR_FUNCTION;

2123: l_etc_txn_brdn_cost);
2124: END IF;
2125:
2126: IF P_PA_DEBUG_MODE = 'Y' THEN
2127: PA_DEBUG.RESET_CURR_FUNCTION;
2128: END IF;
2129: EXCEPTION
2130: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2131: l_msg_count := FND_MSG_PUB.count_msg;

Line 2149: IF P_PA_DEBUG_MODE = 'Y' THEN

2145:
2146: ROLLBACK;
2147: x_return_status := FND_API.G_RET_STS_ERROR;
2148:
2149: IF P_PA_DEBUG_MODE = 'Y' THEN
2150: pa_fp_gen_amount_utils.fp_debug
2151: (p_msg => 'Invalid Arguments Passed',
2152: p_module_name => l_module_name,
2153: p_log_level => 5);

Line 2154: PA_DEBUG.RESET_CURR_FUNCTION;

2150: pa_fp_gen_amount_utils.fp_debug
2151: (p_msg => 'Invalid Arguments Passed',
2152: p_module_name => l_module_name,
2153: p_log_level => 5);
2154: PA_DEBUG.RESET_CURR_FUNCTION;
2155: END IF;
2156: RAISE;
2157: WHEN OTHERS THEN
2158: rollback;

Line 2168: IF P_PA_DEBUG_MODE = 'Y' THEN

2164: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
2165: p_procedure_name => 'GEN_ETC_BDGT_COMPLETE_AMTS',
2166: p_error_text => substr(sqlerrm,1,240));
2167:
2168: IF P_PA_DEBUG_MODE = 'Y' THEN
2169: pa_fp_gen_amount_utils.fp_debug
2170: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2171: p_module_name => l_module_name,
2172: p_log_level => 5);

Line 2173: PA_DEBUG.RESET_CURR_FUNCTION;

2169: pa_fp_gen_amount_utils.fp_debug
2170: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2171: p_module_name => l_module_name,
2172: p_log_level => 5);
2173: PA_DEBUG.RESET_CURR_FUNCTION;
2174: END IF;
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: END GET_ETC_BDGT_COMPLETE_AMTS;
2177:

Line 2257: IF p_pa_debug_mode = 'Y' THEN

2253: l_act_exist_flag VARCHAR2(1):= 'N';
2254: l_act_txn_pc_flag VARCHAR2(10):= 'PC';
2255: l_tot_txn_pc_flag VARCHAR2(10):= 'PC';
2256: BEGIN
2257: IF p_pa_debug_mode = 'Y' THEN
2258: pa_debug.set_curr_function( p_function => 'GEN_ETC_EARNED_VALUE_AMTS',
2259: p_debug_mode => p_pa_debug_mode);
2260: END IF;
2261: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2258: pa_debug.set_curr_function( p_function => 'GEN_ETC_EARNED_VALUE_AMTS',

2254: l_act_txn_pc_flag VARCHAR2(10):= 'PC';
2255: l_tot_txn_pc_flag VARCHAR2(10):= 'PC';
2256: BEGIN
2257: IF p_pa_debug_mode = 'Y' THEN
2258: pa_debug.set_curr_function( p_function => 'GEN_ETC_EARNED_VALUE_AMTS',
2259: p_debug_mode => p_pa_debug_mode);
2260: END IF;
2261: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2262: X_MSG_COUNT := 0;

Line 2259: p_debug_mode => p_pa_debug_mode);

2255: l_tot_txn_pc_flag VARCHAR2(10):= 'PC';
2256: BEGIN
2257: IF p_pa_debug_mode = 'Y' THEN
2258: pa_debug.set_curr_function( p_function => 'GEN_ETC_EARNED_VALUE_AMTS',
2259: p_debug_mode => p_pa_debug_mode);
2260: END IF;
2261: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2262: X_MSG_COUNT := 0;
2263:

Line 2288: IF P_PA_DEBUG_MODE = 'Y' THEN

2284: END IF;
2285: END IF;
2286:
2287:
2288: IF P_PA_DEBUG_MODE = 'Y' THEN
2289: pa_fp_gen_amount_utils.fp_debug
2290: (p_msg => 'Before calling PA_PROGRESS_UTILS.REDEFAULT_BASE_PC',
2291: p_module_name => l_module_name,
2292: p_log_level => 5);

Line 2307: IF P_PA_DEBUG_MODE = 'Y' THEN

2303: X_base_percent_complete => lx_percent_complete,
2304: x_return_status => x_return_status,
2305: x_msg_count => x_msg_count,
2306: x_msg_data => x_msg_data );
2307: IF P_PA_DEBUG_MODE = 'Y' THEN
2308: pa_fp_gen_amount_utils.fp_debug
2309: (p_msg => 'After calling PA_PROGRESS_UTILS.REDEFAULT_BASE_PC,
2310: return status is:'||x_return_status,
2311: p_module_name => l_module_name,

Line 2320: IF P_PA_DEBUG_MODE = 'Y' THEN

2316: END IF;
2317:
2318: l_percent_complete := NVL(lx_percent_complete,0)/100;
2319: IF l_percent_complete = 1 THEN
2320: IF P_PA_DEBUG_MODE = 'Y' THEN
2321: PA_DEBUG.RESET_CURR_FUNCTION;
2322: END IF;
2323: RETURN;
2324: END IF;

Line 2321: PA_DEBUG.RESET_CURR_FUNCTION;

2317:
2318: l_percent_complete := NVL(lx_percent_complete,0)/100;
2319: IF l_percent_complete = 1 THEN
2320: IF P_PA_DEBUG_MODE = 'Y' THEN
2321: PA_DEBUG.RESET_CURR_FUNCTION;
2322: END IF;
2323: RETURN;
2324: END IF;
2325:

Line 2400: IF P_PA_DEBUG_MODE = 'Y' THEN

2396: l_act_pc_brdn_cost := 0;
2397: END;
2398: END IF;
2399: ELSIF P_ETC_SOURCE_CODE = 'WORKPLAN_RESOURCES' THEN
2400: IF P_PA_DEBUG_MODE = 'Y' THEN
2401: pa_fp_gen_amount_utils.fp_debug
2402: (p_msg => 'Before calling PA_PROGRESS_UTILS.'||
2403: 'get_actuals_for_task in earned_value',
2404: p_module_name => l_module_name,

Line 2440: IF P_PA_DEBUG_MODE = 'Y' THEN

2436: X_OTH_QUANTITY => l_oth_quantity,
2437: x_return_status => x_return_status,
2438: x_msg_count => x_msg_count,
2439: x_msg_data => x_msg_data );
2440: IF P_PA_DEBUG_MODE = 'Y' THEN
2441: pa_fp_gen_amount_utils.fp_debug
2442: (p_msg => 'After calling PA_PROGRESS_UTILS.'||
2443: 'get_actuals_for_task in earned_value'||x_return_status,
2444: p_module_name => l_module_name,

Line 2595: IF P_PA_DEBUG_MODE = 'Y' THEN

2591: l_etc_raw_cost,
2592: l_etc_brdn_cost);
2593: END IF;
2594:
2595: IF P_PA_DEBUG_MODE = 'Y' THEN
2596: PA_DEBUG.RESET_CURR_FUNCTION;
2597: END IF;
2598:
2599: EXCEPTION

Line 2596: PA_DEBUG.RESET_CURR_FUNCTION;

2592: l_etc_brdn_cost);
2593: END IF;
2594:
2595: IF P_PA_DEBUG_MODE = 'Y' THEN
2596: PA_DEBUG.RESET_CURR_FUNCTION;
2597: END IF;
2598:
2599: EXCEPTION
2600: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2619: IF P_PA_DEBUG_MODE = 'Y' THEN

2615:
2616: ROLLBACK;
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618:
2619: IF P_PA_DEBUG_MODE = 'Y' THEN
2620: pa_fp_gen_amount_utils.fp_debug
2621: (p_msg => 'Invalid Arguments Passed',
2622: p_module_name => l_module_name,
2623: p_log_level => 5);

Line 2624: PA_DEBUG.RESET_CURR_FUNCTION;

2620: pa_fp_gen_amount_utils.fp_debug
2621: (p_msg => 'Invalid Arguments Passed',
2622: p_module_name => l_module_name,
2623: p_log_level => 5);
2624: PA_DEBUG.RESET_CURR_FUNCTION;
2625: END IF;
2626: RAISE;
2627: WHEN OTHERS THEN
2628: rollback;

Line 2638: IF P_PA_DEBUG_MODE = 'Y' THEN

2634: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
2635: p_procedure_name => 'GEN_ETC_EARNED_VALUE_AMTS',
2636: p_error_text => substr(sqlerrm,1,240));
2637:
2638: IF P_PA_DEBUG_MODE = 'Y' THEN
2639: pa_fp_gen_amount_utils.fp_debug
2640: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2641: p_module_name => l_module_name,
2642: p_log_level => 5);

Line 2643: PA_DEBUG.RESET_CURR_FUNCTION;

2639: pa_fp_gen_amount_utils.fp_debug
2640: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2641: p_module_name => l_module_name,
2642: p_log_level => 5);
2643: PA_DEBUG.RESET_CURR_FUNCTION;
2644: END IF;
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END GET_ETC_EARNED_VALUE_AMTS;
2647:

Line 2754: IF p_pa_debug_mode = 'Y' THEN

2750: BEGIN
2751: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2752: X_MSG_COUNT := 0;
2753: l_sysdate := trunc(sysdate);
2754: IF p_pa_debug_mode = 'Y' THEN
2755: pa_debug.set_curr_function( p_function => 'GEN_ETC_WORK_QTY_AMTS',
2756: p_debug_mode => p_pa_debug_mode);
2757: END IF;
2758:

Line 2755: pa_debug.set_curr_function( p_function => 'GEN_ETC_WORK_QTY_AMTS',

2751: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2752: X_MSG_COUNT := 0;
2753: l_sysdate := trunc(sysdate);
2754: IF p_pa_debug_mode = 'Y' THEN
2755: pa_debug.set_curr_function( p_function => 'GEN_ETC_WORK_QTY_AMTS',
2756: p_debug_mode => p_pa_debug_mode);
2757: END IF;
2758:
2759: l_stru_sharing_code :=

Line 2756: p_debug_mode => p_pa_debug_mode);

2752: X_MSG_COUNT := 0;
2753: l_sysdate := trunc(sysdate);
2754: IF p_pa_debug_mode = 'Y' THEN
2755: pa_debug.set_curr_function( p_function => 'GEN_ETC_WORK_QTY_AMTS',
2756: p_debug_mode => p_pa_debug_mode);
2757: END IF;
2758:
2759: l_stru_sharing_code :=
2760: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(P_PROJECT_ID=> P_PROJECT_ID);

Line 2762: IF P_PA_DEBUG_MODE = 'Y' THEN

2758:
2759: l_stru_sharing_code :=
2760: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(P_PROJECT_ID=> P_PROJECT_ID);
2761: IF l_stru_sharing_code = 'SHARE_FULL' THEN
2762: IF P_PA_DEBUG_MODE = 'Y' THEN
2763: pa_fp_gen_amount_utils.fp_debug
2764: (p_msg => 'Before calling PA_PROGRESS_UTILS.'||
2765: 'get_actuals_for_task when SHARE_FULL',
2766: p_module_name => l_module_name,

Line 2802: IF P_PA_DEBUG_MODE = 'Y' THEN

2798: X_OTH_QUANTITY => l_oth_quantity,
2799: x_return_status => x_return_status,
2800: x_msg_count => x_msg_count,
2801: x_msg_data => x_msg_data );
2802: IF P_PA_DEBUG_MODE = 'Y' THEN
2803: pa_fp_gen_amount_utils.fp_debug
2804: (p_msg => 'After calling PA_PROGRESS_UTILS.'||
2805: 'get_actuals_for_task when SHARE_FULL'||x_return_status,
2806: p_module_name => l_module_name,

Line 2833: IF P_PA_DEBUG_MODE = 'Y' THEN

2829: WHERE PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VERSION_ID
2830: AND MAPPED_FIN_TASK_ID = P_TASK_ID;
2831:
2832: FOR i IN 1..l_wp_task_tab.count LOOP
2833: IF P_PA_DEBUG_MODE = 'Y' THEN
2834: pa_fp_gen_amount_utils.fp_debug
2835: (p_msg => 'Before calling PA_PROGRESS_UTILS.'||
2836: 'get_actuals_for_task when MAPPING',
2837: p_module_name => l_module_name,

Line 2873: IF P_PA_DEBUG_MODE = 'Y' THEN

2869: X_OTH_QUANTITY => l_oth_quantity_ind,
2870: x_return_status => x_return_status,
2871: x_msg_count => x_msg_count,
2872: x_msg_data => x_msg_data );
2873: IF P_PA_DEBUG_MODE = 'Y' THEN
2874: pa_fp_gen_amount_utils.fp_debug
2875: (p_msg => 'After calling PA_PROGRESS_UTILS.'||
2876: 'get_actuals_for_task when MAPPING'||x_return_status,
2877: p_module_name => l_module_name,

Line 2908: IF P_PA_DEBUG_MODE = 'Y' THEN

2904: WHERE PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VERSION_ID
2905: AND OBJECT_TYPE = 'PA_TASKS';
2906:
2907: FOR i IN 1..l_wp_task_tab.count LOOP
2908: IF P_PA_DEBUG_MODE = 'Y' THEN
2909: pa_fp_gen_amount_utils.fp_debug
2910: (p_msg => 'Before calling PA_PROGRESS_UTILS.'||
2911: 'get_actuals_for_task when NO_MAPPINGL',
2912: p_module_name => l_module_name,

Line 2948: IF P_PA_DEBUG_MODE = 'Y' THEN

2944: X_OTH_QUANTITY => l_oth_quantity_ind,
2945: x_return_status => x_return_status,
2946: x_msg_count => x_msg_count,
2947: x_msg_data => x_msg_data );
2948: IF P_PA_DEBUG_MODE = 'Y' THEN
2949: pa_fp_gen_amount_utils.fp_debug
2950: (p_msg => 'After calling PA_PROGRESS_UTILS.'||
2951: 'get_actuals_for_task when NO_MAPPING'||x_return_status,
2952: p_module_name => l_module_name,

Line 3063: IF P_PA_DEBUG_MODE = 'Y' THEN

3059: l_completion_date,
3060: 'WORK_QUANTITY',
3061: P_TASK_ID );
3062:
3063: IF P_PA_DEBUG_MODE = 'Y' THEN
3064: PA_DEBUG.RESET_CURR_FUNCTION;
3065: END IF;
3066: EXCEPTION
3067: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3064: PA_DEBUG.RESET_CURR_FUNCTION;

3060: 'WORK_QUANTITY',
3061: P_TASK_ID );
3062:
3063: IF P_PA_DEBUG_MODE = 'Y' THEN
3064: PA_DEBUG.RESET_CURR_FUNCTION;
3065: END IF;
3066: EXCEPTION
3067: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3068: l_msg_count := FND_MSG_PUB.count_msg;

Line 3086: IF P_PA_DEBUG_MODE = 'Y' THEN

3082:
3083: ROLLBACK;
3084: x_return_status := FND_API.G_RET_STS_ERROR;
3085:
3086: IF P_PA_DEBUG_MODE = 'Y' THEN
3087: pa_fp_gen_amount_utils.fp_debug
3088: (p_msg => 'Invalid Arguments Passed',
3089: p_module_name => l_module_name,
3090: p_log_level => 5);

Line 3091: PA_DEBUG.RESET_CURR_FUNCTION;

3087: pa_fp_gen_amount_utils.fp_debug
3088: (p_msg => 'Invalid Arguments Passed',
3089: p_module_name => l_module_name,
3090: p_log_level => 5);
3091: PA_DEBUG.RESET_CURR_FUNCTION;
3092: END IF;
3093: RAISE;
3094: WHEN OTHERS THEN
3095: rollback;

Line 3105: IF P_PA_DEBUG_MODE = 'Y' THEN

3101: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
3102: p_procedure_name => 'GEN_ETC_WORK_QTY_AMTS',
3103: p_error_text => substr(sqlerrm,1,240));
3104:
3105: IF P_PA_DEBUG_MODE = 'Y' THEN
3106: pa_fp_gen_amount_utils.fp_debug
3107: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3108: p_module_name => l_module_name,
3109: p_log_level => 5);

Line 3110: PA_DEBUG.RESET_CURR_FUNCTION;

3106: pa_fp_gen_amount_utils.fp_debug
3107: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3108: p_module_name => l_module_name,
3109: p_log_level => 5);
3110: PA_DEBUG.RESET_CURR_FUNCTION;
3111: END IF;
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END GET_ETC_WORK_QTY_AMTS;
3114:

Line 3137: IF p_pa_debug_mode = 'Y' THEN

3133: l_sysdate date;
3134: BEGIN
3135: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3136: X_MSG_COUNT := 0;
3137: IF p_pa_debug_mode = 'Y' THEN
3138: pa_debug.set_curr_function( p_function => 'NONE_ETC_SRC',
3139: p_debug_mode => p_pa_debug_mode);
3140: END IF;
3141:

Line 3138: pa_debug.set_curr_function( p_function => 'NONE_ETC_SRC',

3134: BEGIN
3135: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3136: X_MSG_COUNT := 0;
3137: IF p_pa_debug_mode = 'Y' THEN
3138: pa_debug.set_curr_function( p_function => 'NONE_ETC_SRC',
3139: p_debug_mode => p_pa_debug_mode);
3140: END IF;
3141:
3142: l_sysdate := trunc(SYSDATE);

Line 3139: p_debug_mode => p_pa_debug_mode);

3135: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3136: X_MSG_COUNT := 0;
3137: IF p_pa_debug_mode = 'Y' THEN
3138: pa_debug.set_curr_function( p_function => 'NONE_ETC_SRC',
3139: p_debug_mode => p_pa_debug_mode);
3140: END IF;
3141:
3142: l_sysdate := trunc(SYSDATE);
3143:

Line 3190: IF P_PA_DEBUG_MODE = 'Y' THEN

3186: l_task_start_date,
3187: l_task_completion_date,
3188: P_TASK_ID );
3189:
3190: IF P_PA_DEBUG_MODE = 'Y' THEN
3191: PA_DEBUG.RESET_CURR_FUNCTION;
3192: END IF;
3193:
3194: EXCEPTION

Line 3191: PA_DEBUG.RESET_CURR_FUNCTION;

3187: l_task_completion_date,
3188: P_TASK_ID );
3189:
3190: IF P_PA_DEBUG_MODE = 'Y' THEN
3191: PA_DEBUG.RESET_CURR_FUNCTION;
3192: END IF;
3193:
3194: EXCEPTION
3195: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3214: IF P_PA_DEBUG_MODE = 'Y' THEN

3210:
3211: ROLLBACK;
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213:
3214: IF P_PA_DEBUG_MODE = 'Y' THEN
3215: pa_fp_gen_amount_utils.fp_debug
3216: (p_msg => 'Invalid Arguments Passed',
3217: p_module_name => l_module_name,
3218: p_log_level => 5);

Line 3219: PA_DEBUG.RESET_CURR_FUNCTION;

3215: pa_fp_gen_amount_utils.fp_debug
3216: (p_msg => 'Invalid Arguments Passed',
3217: p_module_name => l_module_name,
3218: p_log_level => 5);
3219: PA_DEBUG.RESET_CURR_FUNCTION;
3220: END IF;
3221: RAISE;
3222: WHEN OTHERS THEN
3223: rollback;

Line 3232: IF P_PA_DEBUG_MODE = 'Y' THEN

3228: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
3229: p_procedure_name => 'NONE_ETC_SOURCE',
3230: p_error_text => substr(sqlerrm,1,240));
3231:
3232: IF P_PA_DEBUG_MODE = 'Y' THEN
3233: pa_fp_gen_amount_utils.fp_debug
3234: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3235: p_module_name => l_module_name,
3236: p_log_level => 5);

Line 3237: PA_DEBUG.RESET_CURR_FUNCTION;

3233: pa_fp_gen_amount_utils.fp_debug
3234: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3235: p_module_name => l_module_name,
3236: p_log_level => 5);
3237: PA_DEBUG.RESET_CURR_FUNCTION;
3238: END IF;
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240: END NONE_ETC_SRC;
3241:

Line 3272: IF p_pa_debug_mode = 'Y' THEN

3268:
3269: BEGIN
3270: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3271: X_MSG_COUNT := 0;
3272: IF p_pa_debug_mode = 'Y' THEN
3273: pa_debug.set_curr_function( p_function => 'MAINTAIN_BUDGET_VERSION',
3274: p_debug_mode => p_pa_debug_mode);
3275: END IF;
3276:

Line 3273: pa_debug.set_curr_function( p_function => 'MAINTAIN_BUDGET_VERSION',

3269: BEGIN
3270: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3271: X_MSG_COUNT := 0;
3272: IF p_pa_debug_mode = 'Y' THEN
3273: pa_debug.set_curr_function( p_function => 'MAINTAIN_BUDGET_VERSION',
3274: p_debug_mode => p_pa_debug_mode);
3275: END IF;
3276:
3277: /* Calling the get_plan_version_dtls api */

Line 3274: p_debug_mode => p_pa_debug_mode);

3270: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3271: X_MSG_COUNT := 0;
3272: IF p_pa_debug_mode = 'Y' THEN
3273: pa_debug.set_curr_function( p_function => 'MAINTAIN_BUDGET_VERSION',
3274: p_debug_mode => p_pa_debug_mode);
3275: END IF;
3276:
3277: /* Calling the get_plan_version_dtls api */
3278: IF p_pa_debug_mode = 'Y' THEN

Line 3278: IF p_pa_debug_mode = 'Y' THEN

3274: p_debug_mode => p_pa_debug_mode);
3275: END IF;
3276:
3277: /* Calling the get_plan_version_dtls api */
3278: IF p_pa_debug_mode = 'Y' THEN
3279: pa_fp_gen_amount_utils.fp_debug
3280: (p_msg => 'Before calling
3281: pa_fp_gen_amount_utils.get_plan_version_dtls',
3282: p_module_name => l_module_name,

Line 3292: IF p_pa_debug_mode = 'Y' THEN

3288: X_FP_COLS_REC => l_fp_cols_rec,
3289: X_RETURN_STATUS => X_RETURN_STATUS,
3290: X_MSG_COUNT => X_MSG_COUNT,
3291: X_MSG_DATA => X_MSG_DATA);
3292: IF p_pa_debug_mode = 'Y' THEN
3293: pa_fp_gen_amount_utils.fp_debug
3294: (p_msg => 'Status after calling
3295: pa_fp_gen_amount_utils.get_plan_version_dtls'
3296: ||x_return_status,

Line 3327: IF p_pa_debug_mode = 'Y' THEN

3323: the same resource assignments should be updated to the same start and end
3324: dates, which honor the max and min of the individual budget lines. This
3325: should also be updated back to resource assignments. **/
3326: IF l_fp_cols_rec.x_time_phased_code = 'N' THEN
3327: IF p_pa_debug_mode = 'Y' THEN
3328: pa_fp_gen_amount_utils.fp_debug
3329: (p_msg => 'Before calling pa_fp_maintain_actual_pub.'||
3330: 'SYNC_UP_PLANNING_DATES_NONE_TP',
3331: p_module_name => l_module_name,

Line 3340: IF p_pa_debug_mode = 'Y' THEN

3336: P_FP_COLS_REC => l_fp_cols_rec,
3337: X_RETURN_STATUS => X_RETURN_STATUS,
3338: X_MSG_COUNT => X_MSG_COUNT,
3339: X_MSG_DATA => X_MSG_DATA);
3340: IF p_pa_debug_mode = 'Y' THEN
3341: pa_fp_gen_amount_utils.fp_debug
3342: (p_msg => 'Status after calling pa_fp_maintain_actual_pub.'||
3343: 'SYNC_UP_PLANNING_DATES_NONE_TP:'||x_return_status,
3344: p_module_name => l_module_name,

Line 3352: IF p_pa_debug_mode = 'Y' THEN

3348: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3349: END IF;
3350: END IF;
3351:
3352: IF p_pa_debug_mode = 'Y' THEN
3353: pa_fp_gen_amount_utils.fp_debug
3354: (p_msg => 'Before calling
3355: PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP',
3356: p_module_name => l_module_name,

Line 3365: IF p_pa_debug_mode = 'Y' THEN

3361: P_FP_COLS_REC => l_fp_cols_rec,
3362: X_RETURN_STATUS => x_return_status,
3363: X_MSG_COUNT => x_msg_count,
3364: X_MSG_DATA => x_msg_data);
3365: IF p_pa_debug_mode = 'Y' THEN
3366: pa_fp_gen_amount_utils.fp_debug
3367: (p_msg => 'Status after calling
3368: PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP:'||x_return_status,
3369: p_module_name => l_module_name,

Line 3376: IF P_PA_DEBUG_MODE = 'Y' THEN

3372: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3373: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3374: END IF;
3375:
3376: IF P_PA_DEBUG_MODE = 'Y' THEN
3377: pa_fp_gen_amount_utils.fp_debug
3378: (p_msg => 'Before calling PA_FP_MULTI_CURRENCY_PKG.CONVERT_TXN_CURRENCY',
3379: p_module_name => l_module_name,
3380: p_log_level => 5);

Line 3389: IF P_PA_DEBUG_MODE = 'Y' THEN

3385: p_calling_module => 'BUDGET_GENERATION', -- Added for Bug#5395732
3386: X_RETURN_STATUS => X_RETURN_STATUS,
3387: X_MSG_COUNT => X_MSG_COUNT,
3388: X_MSG_DATA => X_MSG_DATA);
3389: IF P_PA_DEBUG_MODE = 'Y' THEN
3390: pa_fp_gen_amount_utils.fp_debug
3391: (p_msg => 'After calling PA_FP_MULTI_CURRENCY_PKG.CONVERT_TXN_CURRENCY,
3392: ret status: '||x_return_status,
3393: p_module_name => l_module_name,

Line 3401: IF P_PA_DEBUG_MODE = 'Y' THEN

3397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3398: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3399: END IF;
3400:
3401: IF P_PA_DEBUG_MODE = 'Y' THEN
3402: pa_fp_gen_amount_utils.fp_debug
3403: (p_msg => 'Before calling PA_FP_ROLLUP_PKG.ROLLUP_BUDGET_VERSION',
3404: p_module_name => l_module_name,
3405: p_log_level => 5);

Line 3413: IF P_PA_DEBUG_MODE = 'Y' THEN

3409: p_entire_version => 'Y',
3410: X_RETURN_STATUS => X_RETURN_STATUS,
3411: X_MSG_COUNT => X_MSG_COUNT,
3412: X_MSG_DATA => X_MSG_DATA);
3413: IF P_PA_DEBUG_MODE = 'Y' THEN
3414: pa_fp_gen_amount_utils.fp_debug
3415: (p_msg => 'After calling PA_FP_ROLLUP_PKG.ROLLUP_BUDGET_VERSION,
3416: ret status: '||x_return_status,
3417: p_module_name => l_module_name,

Line 3432: IF p_pa_debug_mode = 'Y' THEN

3428:
3429: IF l_wp_version_flag = 'Y' THEN
3430: IF l_fp_cols_rec.x_fin_plan_level_code <> 'P' THEN
3431: /* Calling the UPD_WBS_ELEMENT_VERSION_ID api */
3432: IF p_pa_debug_mode = 'Y' THEN
3433: pa_fp_gen_amount_utils.fp_debug
3434: (p_msg => 'Before calling
3435: PA_FP_GEN_PUB.UPD_WBS_ELEMENT_VERSION_ID',
3436: p_module_name => l_module_name,

Line 3448: IF p_pa_debug_mode = 'Y' THEN

3444: X_MSG_DATA => X_MSG_DATA);
3445: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3446: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3447: END IF;
3448: IF p_pa_debug_mode = 'Y' THEN
3449: pa_fp_gen_amount_utils.fp_debug
3450: (p_msg => 'Status after calling
3451: PA_FP_GEN_PUB.UPD_WBS_ELEMENT_VERSION_ID'
3452: ||x_return_status,

Line 3463: IF p_pa_debug_mode = 'Y' THEN

3459:
3460:
3461: IF l_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
3462: /* Calling insert_txn_currency api */
3463: IF p_pa_debug_mode = 'Y' THEN
3464: pa_fp_gen_amount_utils.fp_debug
3465: (p_msg => 'Before calling
3466: pa_fp_gen_budget_amt_pub.insert_txn_currency',
3467: p_module_name => l_module_name,

Line 3480: IF p_pa_debug_mode = 'Y' THEN

3476: X_MSG_DATA => X_MSG_DATA);
3477: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3478: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3479: END IF;
3480: IF p_pa_debug_mode = 'Y' THEN
3481: pa_fp_gen_amount_utils.fp_debug
3482: (p_msg => 'Status after calling
3483: pa_fp_gen_budget_amt_pub.insert_txn_currency'
3484: ||x_return_status,

Line 3496: IF P_PA_DEBUG_MODE = 'Y' THEN

3492: -- Bug 4187704: Uncommented the MRC code. Also, set added logic to set
3493: -- PA_MRC_FINPLAN.G_CALLING_MODULE based on Target Plan Class Code.
3494: IF PA_MRC_FINPLAN.G_MRC_ENABLED_FOR_BUDGETS IS NULL THEN
3495:
3496: IF P_PA_DEBUG_MODE = 'Y' THEN
3497: pa_fp_gen_amount_utils.fp_debug
3498: (p_msg => 'Before calling PA_MRC_FINPLAN.CHECK_MRC_INSTALL',
3499: p_module_name => l_module_name,
3500: p_log_level => 5);

Line 3506: IF P_PA_DEBUG_MODE = 'Y' THEN

3502: PA_MRC_FINPLAN.CHECK_MRC_INSTALL
3503: (x_return_status => x_return_status,
3504: x_msg_count => x_msg_count,
3505: x_msg_data => x_msg_data);
3506: IF P_PA_DEBUG_MODE = 'Y' THEN
3507: pa_fp_gen_amount_utils.fp_debug
3508: (p_msg => 'After calling PA_MRC_FINPLAN.CHECK_MRC_INSTALL,
3509: ret status: '||x_return_status,
3510: p_module_name => l_module_name,

Line 3527: IF P_PA_DEBUG_MODE = 'Y' THEN

3523: ELSIF l_fp_cols_rec.x_plan_class_code = 'BUDGET' THEN
3524: PA_MRC_FINPLAN.G_CALLING_MODULE := PA_MRC_FINPLAN.G_GENERATE_BUDGET;
3525: END IF;
3526:
3527: IF P_PA_DEBUG_MODE = 'Y' THEN
3528: pa_fp_gen_amount_utils.fp_debug
3529: (p_msg => 'Before calling PA_MRC_FINPLAN.MAINTAIN_ALL_MC_BUDGET_LINES',
3530: p_module_name => l_module_name,
3531: p_log_level => 5);

Line 3539: IF P_PA_DEBUG_MODE = 'Y' THEN

3535: p_entire_version => 'Y',
3536: x_return_status => x_return_status,
3537: x_msg_count => x_msg_count,
3538: x_msg_data => x_msg_data);
3539: IF P_PA_DEBUG_MODE = 'Y' THEN
3540: pa_fp_gen_amount_utils.fp_debug
3541: (p_msg => 'After calling PA_MRC_FINPLAN.MAINTAIN_ALL_MC_BUDGET_LINES,
3542: ret status: '||x_return_status,
3543: p_module_name => l_module_name,

Line 3557: IF P_PA_DEBUG_MODE = 'Y' THEN

3553:
3554: l_fp_version_ids_tab.extend;
3555: l_fp_version_ids_tab(1) := P_BUDGET_VERSION_ID;
3556:
3557: IF P_PA_DEBUG_MODE = 'Y' THEN
3558: pa_fp_gen_amount_utils.fp_debug
3559: (p_msg => 'Before calling PJI_FM_XBS_ACCUM_MAINT.PLAN_DELETE',
3560: p_module_name => l_module_name,
3561: p_log_level => 5);

Line 3567: IF P_PA_DEBUG_MODE = 'Y' THEN

3563: PJI_FM_XBS_ACCUM_MAINT.PLAN_DELETE (
3564: p_fp_version_ids => l_fp_version_ids_tab,
3565: x_return_status => x_return_status,
3566: x_msg_code => x_msg_data );
3567: IF P_PA_DEBUG_MODE = 'Y' THEN
3568: pa_fp_gen_amount_utils.fp_debug
3569: (p_msg => 'After calling PJI_FM_XBS_ACCUM_MAINT.PLAN_DELETE,
3570: ret status: '||x_return_status,
3571: p_module_name => l_module_name,

Line 3580: IF P_PA_DEBUG_MODE = 'Y' THEN

3576: END IF;
3577:
3578: IF l_fp_cols_rec.X_RBS_VERSION_ID IS NOT NULL THEN
3579:
3580: IF P_PA_DEBUG_MODE = 'Y' THEN
3581: pa_fp_gen_amount_utils.fp_debug
3582: (p_msg => 'Before calling
3583: pa_fp_map_bv_pub.maintain_rbs_dtls',
3584: p_module_name => l_module_name,

Line 3597: IF P_PA_DEBUG_MODE = 'Y' THEN

3593: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3594: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3595: END IF;
3596:
3597: IF P_PA_DEBUG_MODE = 'Y' THEN
3598: pa_fp_gen_amount_utils.fp_debug
3599: (p_msg => 'After calling pa_fp_map_bv_pub.maintain_rbs_dtls,
3600: ret status: '||x_return_status,
3601: p_module_name => l_module_name,

Line 3605: IF P_PA_DEBUG_MODE = 'Y' THEN

3601: p_module_name => l_module_name,
3602: p_log_level => 5);
3603: END IF;
3604: END IF;
3605: IF P_PA_DEBUG_MODE = 'Y' THEN
3606: pa_fp_gen_amount_utils.fp_debug
3607: (p_msg => 'Before calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE',
3608: p_module_name => l_module_name,
3609: p_log_level => 5);

Line 3615: IF P_PA_DEBUG_MODE = 'Y' THEN

3611: PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE (
3612: p_fp_version_ids => l_fp_version_ids_tab,
3613: x_return_status => x_return_status,
3614: x_msg_code => x_msg_data );
3615: IF P_PA_DEBUG_MODE = 'Y' THEN
3616: pa_fp_gen_amount_utils.fp_debug
3617: (p_msg => 'After calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE,
3618: ret status: '||x_return_status,
3619: p_module_name => l_module_name,

Line 3626: IF P_PA_DEBUG_MODE = 'Y' THEN

3622: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3623: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3624: END IF;
3625:
3626: IF P_PA_DEBUG_MODE = 'Y' THEN
3627: pa_fp_gen_amount_utils.fp_debug
3628: (p_msg => 'Before calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE',
3629: p_module_name => l_module_name,
3630: p_log_level => 5);

Line 3639: IF P_PA_DEBUG_MODE = 'Y' THEN

3635: P_ETC_START_DATE => P_ETC_START_DATE,
3636: X_RETURN_STATUS => X_RETURN_STATUS,
3637: X_MSG_COUNT => X_MSG_COUNT,
3638: X_MSG_DATA => X_MSG_DATA);
3639: IF P_PA_DEBUG_MODE = 'Y' THEN
3640: pa_fp_gen_amount_utils.fp_debug
3641: (p_msg => 'After calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE,
3642: ret status: '||x_return_status,
3643: p_module_name => l_module_name,

Line 3658: IF p_pa_debug_mode = 'Y' THEN

3654: -- the beginning of the API for details.
3655:
3656: IF P_CALL_MAINTAIN_DATA_API = 'Y' THEN
3657: -- Call the maintenance api in ROLLUP mode
3658: IF p_pa_debug_mode = 'Y' THEN
3659: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3660: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.' ||
3661: 'UPD_NRB_TXN_OVR_RATES',
3662: --P_CALLED_MODE => p_called_mode,

Line 3673: IF p_pa_debug_mode = 'Y' THEN

3669: P_ETC_START_DATE => P_ETC_START_DATE,
3670: X_RETURN_STATUS => X_RETURN_STATUS,
3671: X_MSG_COUNT => X_MSG_COUNT,
3672: X_MSG_DATA => X_MSG_DATA);
3673: IF p_pa_debug_mode = 'Y' THEN
3674: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3675: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.' ||
3676: 'UPD_NRB_TXN_OVR_RATES: '||x_return_status,
3677: --P_CALLED_MODE => p_called_mode,

Line 3712: IF p_pa_debug_mode = 'Y' THEN

3708: FROM pa_resource_assignments ra
3709: WHERE ra.budget_version_id = p_budget_version_id
3710: AND ra.transaction_source_code IS NOT NULL;
3711:
3712: IF p_pa_debug_mode = 'Y' THEN
3713: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3714: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||
3715: 'POPULATE_DISPLAY_QTY',
3716: --P_CALLED_MODE => p_called_mode,

Line 3724: IF p_pa_debug_mode = 'Y' THEN

3720: ( P_BUDGET_VERSION_ID => p_budget_version_id,
3721: P_CONTEXT => 'FINANCIAL',
3722: P_USE_TEMP_TABLE_FLAG => 'Y',
3723: X_RETURN_STATUS => x_return_status );
3724: IF p_pa_debug_mode = 'Y' THEN
3725: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3726: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||
3727: 'POPULATE_DISPLAY_QTY: '||x_return_status,
3728: --P_CALLED_MODE => p_called_mode,

Line 3762: IF p_pa_debug_mode = 'Y' THEN

3758: AND bl.resource_assignment_id = ra.resource_assignment_id
3759: AND bl.resource_assignment_id = rbc.resource_assignment_id (+)
3760: AND bl.txn_currency_code = rbc.txn_currency_code (+);
3761:
3762: IF p_pa_debug_mode = 'Y' THEN
3763: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3764: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3765: 'MAINTAIN_DATA',
3766: --P_CALLED_MODE => p_called_mode,

Line 3778: IF p_pa_debug_mode = 'Y' THEN

3774: --P_CALLED_MODE => p_called_mode,
3775: X_RETURN_STATUS => x_return_status,
3776: X_MSG_COUNT => x_msg_count,
3777: X_MSG_DATA => x_msg_data );
3778: IF p_pa_debug_mode = 'Y' THEN
3779: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3780: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3781: 'MAINTAIN_DATA: '||x_return_status,
3782: --P_CALLED_MODE => p_called_mode,

Line 3801: IF p_pa_debug_mode = 'Y' THEN

3797: -- the populate_display_qty() and maintain_data() API calls.
3798:
3799: -- Populate the display quantity for all resources in the version.
3800:
3801: IF p_pa_debug_mode = 'Y' THEN
3802: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3803: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||
3804: 'POPULATE_DISPLAY_QTY',
3805: --P_CALLED_MODE => p_called_mode,

Line 3813: IF p_pa_debug_mode = 'Y' THEN

3809: ( P_BUDGET_VERSION_ID => p_budget_version_id,
3810: P_CONTEXT => 'FINANCIAL',
3811: P_USE_TEMP_TABLE_FLAG => 'N',
3812: X_RETURN_STATUS => x_return_status );
3813: IF p_pa_debug_mode = 'Y' THEN
3814: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3815: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||
3816: 'POPULATE_DISPLAY_QTY: '||x_return_status,
3817: --P_CALLED_MODE => p_called_mode,

Line 3832: IF p_pa_debug_mode = 'Y' THEN

3828: ELSIF l_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
3829: l_calling_module := 'FORECAST_GENERATION';
3830: END IF;
3831:
3832: IF p_pa_debug_mode = 'Y' THEN
3833: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3834: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3835: 'MAINTAIN_DATA',
3836: --P_CALLED_MODE => p_called_mode,

Line 3848: IF p_pa_debug_mode = 'Y' THEN

3844: --P_CALLED_MODE => p_called_mode,
3845: X_RETURN_STATUS => x_return_status,
3846: X_MSG_COUNT => x_msg_count,
3847: X_MSG_DATA => x_msg_data );
3848: IF p_pa_debug_mode = 'Y' THEN
3849: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3850: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3851: 'MAINTAIN_DATA: '||x_return_status,
3852: --P_CALLED_MODE => p_called_mode,

Line 3883: IF P_PA_DEBUG_MODE = 'Y' THEN

3879:
3880: -- END OF IPM: New Entity and Display Quantity ERs --------------------
3881:
3882:
3883: IF P_PA_DEBUG_MODE = 'Y' THEN
3884: PA_DEBUG.RESET_CURR_FUNCTION;
3885: END IF;
3886: EXCEPTION
3887: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3884: PA_DEBUG.RESET_CURR_FUNCTION;

3880: -- END OF IPM: New Entity and Display Quantity ERs --------------------
3881:
3882:
3883: IF P_PA_DEBUG_MODE = 'Y' THEN
3884: PA_DEBUG.RESET_CURR_FUNCTION;
3885: END IF;
3886: EXCEPTION
3887: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3888: l_msg_count := FND_MSG_PUB.count_msg;

Line 3906: IF P_PA_DEBUG_MODE = 'Y' THEN

3902:
3903: ROLLBACK;
3904: x_return_status := FND_API.G_RET_STS_ERROR;
3905:
3906: IF P_PA_DEBUG_MODE = 'Y' THEN
3907: pa_fp_gen_amount_utils.fp_debug
3908: (p_msg => 'Invalid Arguments Passed',
3909: p_module_name => l_module_name,
3910: p_log_level => 5);

Line 3911: PA_DEBUG.RESET_CURR_FUNCTION;

3907: pa_fp_gen_amount_utils.fp_debug
3908: (p_msg => 'Invalid Arguments Passed',
3909: p_module_name => l_module_name,
3910: p_log_level => 5);
3911: PA_DEBUG.RESET_CURR_FUNCTION;
3912: END IF;
3913: RAISE;
3914: WHEN OTHERS THEN
3915: rollback;

Line 3925: IF P_PA_DEBUG_MODE = 'Y' THEN

3921: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
3922: p_procedure_name => 'MAINTAIN_BUDGET_VERSION',
3923: p_error_text => substr(sqlerrm,1,240));
3924:
3925: IF P_PA_DEBUG_MODE = 'Y' THEN
3926: pa_fp_gen_amount_utils.fp_debug
3927: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3928: p_module_name => l_module_name,
3929: p_log_level => 5);

Line 3930: PA_DEBUG.RESET_CURR_FUNCTION;

3926: pa_fp_gen_amount_utils.fp_debug
3927: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3928: p_module_name => l_module_name,
3929: p_log_level => 5);
3930: PA_DEBUG.RESET_CURR_FUNCTION;
3931: END IF;
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END MAINTAIN_BUDGET_VERSION;
3934:

Line 4223: IF p_pa_debug_mode = 'Y' THEN

4219: l_msg_data VARCHAR2(2000);
4220: l_data VARCHAR2(2000);
4221: l_msg_index_out NUMBER:=0;
4222: BEGIN
4223: IF p_pa_debug_mode = 'Y' THEN
4224: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
4225: p_debug_mode => p_pa_debug_mode);
4226: END IF;
4227: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 4224: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',

4220: l_data VARCHAR2(2000);
4221: l_msg_index_out NUMBER:=0;
4222: BEGIN
4223: IF p_pa_debug_mode = 'Y' THEN
4224: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
4225: p_debug_mode => p_pa_debug_mode);
4226: END IF;
4227: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4228: X_MSG_COUNT := 0;

Line 4225: p_debug_mode => p_pa_debug_mode);

4221: l_msg_index_out NUMBER:=0;
4222: BEGIN
4223: IF p_pa_debug_mode = 'Y' THEN
4224: pa_debug.set_curr_function( p_function => 'GEN_ETC_BDGT_COMPLETE_AMTS',
4225: p_debug_mode => p_pa_debug_mode);
4226: END IF;
4227: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4228: X_MSG_COUNT := 0;
4229:

Line 4307: IF P_PA_DEBUG_MODE = 'Y' THEN

4303: X_ACT_PFC_RAW_COST := 0;
4304: X_ACT_PFC_BRDN_COST := 0;
4305: END IF;
4306:
4307: IF P_PA_DEBUG_MODE = 'Y' THEN
4308: PA_DEBUG.RESET_CURR_FUNCTION;
4309: END IF;
4310:
4311: EXCEPTION

Line 4308: PA_DEBUG.RESET_CURR_FUNCTION;

4304: X_ACT_PFC_BRDN_COST := 0;
4305: END IF;
4306:
4307: IF P_PA_DEBUG_MODE = 'Y' THEN
4308: PA_DEBUG.RESET_CURR_FUNCTION;
4309: END IF;
4310:
4311: EXCEPTION
4312: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 4331: IF P_PA_DEBUG_MODE = 'Y' THEN

4327:
4328: ROLLBACK;
4329: x_return_status := FND_API.G_RET_STS_ERROR;
4330:
4331: IF P_PA_DEBUG_MODE = 'Y' THEN
4332: pa_fp_gen_amount_utils.fp_debug
4333: (p_msg => 'Invalid Arguments Passed',
4334: p_module_name => l_module_name,
4335: p_log_level => 5);

Line 4336: PA_DEBUG.RESET_CURR_FUNCTION;

4332: pa_fp_gen_amount_utils.fp_debug
4333: (p_msg => 'Invalid Arguments Passed',
4334: p_module_name => l_module_name,
4335: p_log_level => 5);
4336: PA_DEBUG.RESET_CURR_FUNCTION;
4337: END IF;
4338: RAISE;
4339: WHEN OTHERS THEN
4340: rollback;

Line 4350: IF P_PA_DEBUG_MODE = 'Y' THEN

4346: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
4347: p_procedure_name => 'GET_WP_ACTUALS_FOR_RA',
4348: p_error_text => substr(sqlerrm,1,240));
4349:
4350: IF P_PA_DEBUG_MODE = 'Y' THEN
4351: pa_fp_gen_amount_utils.fp_debug
4352: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4353: p_module_name => l_module_name,
4354: p_log_level => 5);

Line 4355: PA_DEBUG.RESET_CURR_FUNCTION;

4351: pa_fp_gen_amount_utils.fp_debug
4352: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4353: p_module_name => l_module_name,
4354: p_log_level => 5);
4355: PA_DEBUG.RESET_CURR_FUNCTION;
4356: END IF;
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: END GET_WP_ACTUALS_FOR_RA;
4359:

Line 4558: IF p_pa_debug_mode = 'Y' THEN

4554:
4555: BEGIN
4556:
4557: x_call_maintain_data_api := 'Y';
4558: IF p_pa_debug_mode = 'Y' THEN
4559: pa_debug.set_curr_function( p_function => 'call_clnt_extn_and_update_bl',
4560: p_debug_mode => p_pa_debug_mode);
4561: END IF;
4562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 4559: pa_debug.set_curr_function( p_function => 'call_clnt_extn_and_update_bl',

4555: BEGIN
4556:
4557: x_call_maintain_data_api := 'Y';
4558: IF p_pa_debug_mode = 'Y' THEN
4559: pa_debug.set_curr_function( p_function => 'call_clnt_extn_and_update_bl',
4560: p_debug_mode => p_pa_debug_mode);
4561: END IF;
4562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4563: X_MSG_COUNT := 0;

Line 4560: p_debug_mode => p_pa_debug_mode);

4556:
4557: x_call_maintain_data_api := 'Y';
4558: IF p_pa_debug_mode = 'Y' THEN
4559: pa_debug.set_curr_function( p_function => 'call_clnt_extn_and_update_bl',
4560: p_debug_mode => p_pa_debug_mode);
4561: END IF;
4562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4563: X_MSG_COUNT := 0;
4564:

Line 4568: IF p_pa_debug_mode = 'Y' THEN

4564:
4565:
4566:
4567: IF p_project_id IS NULL OR p_budget_version_id IS NULL THEN
4568: IF p_pa_debug_mode = 'Y' THEN
4569: pa_fp_gen_amount_utils.fp_debug
4570: (p_msg => 'PA_FP_INV_PARAM_PASSED',
4571: p_module_name => l_module_name,
4572: p_log_level => 5);

Line 4573: PA_DEBUG.RESET_CURR_FUNCTION;

4569: pa_fp_gen_amount_utils.fp_debug
4570: (p_msg => 'PA_FP_INV_PARAM_PASSED',
4571: p_module_name => l_module_name,
4572: p_log_level => 5);
4573: PA_DEBUG.RESET_CURR_FUNCTION;
4574: END IF;
4575: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4576: END IF;
4577:

Line 4578: IF p_pa_debug_mode = 'Y' THEN

4574: END IF;
4575: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4576: END IF;
4577:
4578: IF p_pa_debug_mode = 'Y' THEN
4579: pa_fp_gen_amount_utils.fp_debug
4580: (p_msg => 'Before calling pa_fp_gen_amount_utils.get_plan_version_dtls',
4581: p_module_name => l_module_name,
4582: p_log_level => 5);

Line 4592: IF p_pa_debug_mode = 'Y' THEN

4588: X_FP_COLS_REC => l_fp_cols_rec,
4589: X_RETURN_STATUS => X_RETURN_STATUS,
4590: X_MSG_COUNT => X_MSG_COUNT,
4591: X_MSG_DATA => X_MSG_DATA);
4592: IF p_pa_debug_mode = 'Y' THEN
4593: pa_fp_gen_amount_utils.fp_debug
4594: (p_msg => 'Status after calling pa_fp_gen_amount_utils.get_plan_version_dtls'||x_return_status,
4595: p_module_name => l_module_name,
4596: p_log_level => 5);

Line 4620: IF p_pa_debug_mode = 'Y' THEN

4616:
4617:
4618: -- Getting the project percent complete.
4619:
4620: IF p_pa_debug_mode = 'Y' THEN
4621: pa_fp_gen_amount_utils.fp_debug
4622: (p_msg => 'Getting the project percent complete',
4623: p_module_name => l_module_name,
4624: p_log_level => 5);

Line 4641: IF P_PA_DEBUG_MODE = 'Y' THEN

4637: x_return_status => x_return_status,
4638: x_msg_count => x_msg_count,
4639: x_msg_data => x_msg_data );
4640:
4641: IF P_PA_DEBUG_MODE = 'Y' THEN
4642: pa_fp_gen_amount_utils.fp_debug
4643: (p_msg => 'After calling PA_PROGRESS_UTILS.REDEFAULT_BASE_PC,
4644: return status is:'||x_return_status,
4645: p_module_name => l_module_name,

Line 4657: IF p_pa_debug_mode = 'Y' THEN

4653:
4654:
4655:
4656:
4657: IF p_pa_debug_mode = 'Y' THEN
4658: pa_fp_gen_amount_utils.fp_debug
4659: (p_msg => 'Start of bulk collecting budget lines',
4660: p_module_name => l_module_name,
4661: p_log_level => 5);

Line 4671: IF P_PA_debug_mode = 'Y' THEN

4667: p_context => 'FINANCIAL',
4668: x_return_status => X_RETURN_STATUS);
4669:
4670: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4671: IF P_PA_debug_mode = 'Y' THEN
4672: pa_fp_gen_amount_utils.fp_debug
4673: (p_msg => 'Status after calling PA_BUDGET_LINES_UTILS.populate_display_qty'||X_RETURN_STATUS,
4674: p_module_name => l_module_name,
4675: p_log_level => 5);

Line 4685: IF p_pa_debug_mode = 'Y' THEN

4681: -- further down in this API and in Calculate API when it is called in RESOURCE_ASSIGNMENT mode.
4682: -- Call MAINTAIN_DATA to roll up amounts to pa_resource_asgn_curr
4683:
4684:
4685: IF p_pa_debug_mode = 'Y' THEN
4686: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4687: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.' ||
4688: 'UPD_NRB_TXN_OVR_RATES',
4689: --P_CALLED_MODE => p_called_mode,

Line 4700: IF p_pa_debug_mode = 'Y' THEN

4696: P_ETC_START_DATE => l_etc_start_date,
4697: X_RETURN_STATUS => X_RETURN_STATUS,
4698: X_MSG_COUNT => X_MSG_COUNT,
4699: X_MSG_DATA => X_MSG_DATA);
4700: IF p_pa_debug_mode = 'Y' THEN
4701: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4702: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.' ||
4703: 'UPD_NRB_TXN_OVR_RATES: '||x_return_status,
4704: --P_CALLED_MODE => p_called_mode,

Line 4725: IF P_PA_debug_mode = 'Y' THEN

4721: x_msg_data => X_MSG_DATA,
4722: x_msg_count => X_MSG_COUNT);
4723:
4724: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4725: IF P_PA_debug_mode = 'Y' THEN
4726: pa_fp_gen_amount_utils.fp_debug
4727: (p_msg => 'Status after calling PA_RES_ASG_CURRENCY_PUB.maintain_data'||X_RETURN_STATUS,
4728: p_module_name => l_module_name,
4729: p_log_level => 5);

Line 4746: IF P_PA_debug_mode = 'Y' THEN

4742: X_MSG_COUNT => X_MSG_COUNT,
4743: X_MSG_DATA => X_MSG_DATA);
4744:
4745: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4746: IF P_PA_debug_mode = 'Y' THEN
4747: pa_fp_gen_amount_utils.fp_debug
4748: (p_msg => 'PA_FP_MAINTAIN_ACTUAL_PUB.SYNC_UP_PLANNING_DATES_NONE_TP'||X_RETURN_STATUS,
4749: p_module_name => l_module_name,
4750: p_log_level => 5);

Line 4822: IF p_pa_debug_mode = 'Y' THEN

4818: WHERE prac.budget_version_id = p_budget_version_id
4819: AND pra.budget_version_id = p_budget_version_id
4820: AND prac.resource_assignment_id = pra.resource_assignment_id;
4821:
4822: IF p_pa_debug_mode = 'Y' THEN
4823: pa_fp_gen_amount_utils.fp_debug
4824: (p_msg => 'End of bulk collecting budget lines',
4825: p_module_name => l_module_name,
4826: p_log_level => 5);

Line 4859: IF p_pa_debug_mode = 'Y' THEN

4855: l_actual_raw_cost := l_init_raw_cost_tbl_1(kk);
4856: l_actual_burdened_cost := l_init_burd_cost_tbl_1(kk);
4857: l_actual_revenue := l_init_revenue_tbl_1(kk);
4858: l_total_quantity := l_etc_qty_tbl_1(kk) + l_init_quantity_tbl_1(kk);
4859: IF p_pa_debug_mode = 'Y' THEN
4860: pa_fp_gen_amount_utils.fp_debug
4861: (p_msg => 'Before collecting budget lines for a ra id',
4862: p_module_name => l_module_name,
4863: p_log_level => 5);

Line 4903: IF p_pa_debug_mode = 'Y' THEN

4899: WHERE resource_assignment_id = l_ra_id_tbl_1(kk)
4900: AND txn_currency_code = l_txn_currency_code_tbl_1(kk)
4901: ORDER BY pbl.start_date; -- Added for Bug 8718969
4902:
4903: IF p_pa_debug_mode = 'Y' THEN
4904: pa_fp_gen_amount_utils.fp_debug
4905: (p_msg => 'After collecting budget lines for a ra id',
4906: p_module_name => l_module_name,
4907: p_log_level => 5);

Line 4958: IF P_PA_DEBUG_MODE = 'Y' THEN

4954: END LOOP;
4955:
4956:
4957: -- Call the client extension for each planning transaction
4958: IF P_PA_DEBUG_MODE = 'Y' THEN
4959: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4960: P_MSG =>
4961: 'Before calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn',
4962: P_MODULE_NAME => l_module_name);

Line 5077: IF P_PA_DEBUG_MODE = 'Y' THEN

5073:
5074:
5075:
5076:
5077: IF P_PA_DEBUG_MODE = 'Y' THEN
5078: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5079: P_MSG => 'After calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn: '||x_return_status,
5080: P_MODULE_NAME => l_module_name);
5081: END IF;

Line 5733: IF P_PA_DEBUG_MODE = 'Y' THEN

5729:
5730: --For Bug 6722414
5731: pa_fp_calc_plan_pkg.g_from_etc_client_extn_flag := 'N';
5732:
5733: IF P_PA_DEBUG_MODE = 'Y' THEN
5734: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5735: P_MSG =>
5736: 'After calling PA_FP_CALC_PLAN_PKG.calculate '
5737: ||x_return_status,

Line 5773: IF P_PA_DEBUG_MODE = 'Y' THEN

5769: */
5770: IF l_call_calculate_flag = 'N' and l_upd_count = 0 and l_del_count = 0 THEN
5771: x_call_maintain_data_api := 'N';
5772: END IF;
5773: IF P_PA_DEBUG_MODE = 'Y' THEN
5774: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5775: P_MSG =>
5776: 'After calling PA_FP_CALC_PLAN_PKG.CheckZeroQTyNegETC '
5777: ||x_return_status,

Line 5813: IF p_pa_debug_mode = 'Y' THEN

5809: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB1',
5810: p_procedure_name => 'call_clnt_extn_and_update_bl',
5811: p_error_text => substr(sqlerrm,1,240));
5812:
5813: IF p_pa_debug_mode = 'Y' THEN
5814: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5815: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5816: p_module_name => l_module_name,
5817: p_log_level => 5);

Line 5818: PA_DEBUG.RESET_CURR_FUNCTION;

5814: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5815: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5816: p_module_name => l_module_name,
5817: p_log_level => 5);
5818: PA_DEBUG.RESET_CURR_FUNCTION;
5819: END IF;
5820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5821:
5822: END call_clnt_extn_and_update_bl;