DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 50: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

46: l_act_thru_date date;
47:
48: l_versioning_enabled varchar2(10);
49:
50: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
51: l_gen_src_wp_ver_code varchar2(50);
52: l_gen_src_plan_ver_code varchar2(50);
53: l_etc_wp_struct_ver_id number;
54: l_etc_wp_fin_ver_id number;

Line 277: pa_fp_gen_amount_utils.fp_debug

273: -- hr_utility.trace('After execute, l_rows is: '||l_rows);
274:
275: IF (l_rows < 0) THEN
276: IF p_pa_debug_mode = 'Y' THEN
277: pa_fp_gen_amount_utils.fp_debug
278: (p_called_mode => l_called_mode,
279: p_msg =>'After dbms parse '||to_char(l_rows),
280: p_module_name => l_module_name,
281: p_log_level => 5);

Line 404: pa_fp_gen_amount_utils.fp_debug

400: l_generation_flag := 'Y';
401: l_gen_api_call_flag := 'Y';
402:
403: IF p_pa_debug_mode = 'Y' THEN
404: pa_fp_gen_amount_utils.fp_debug
405: (p_called_mode => l_called_mode,
406: p_msg =>'Before calling
407: pa_fin_plan_pub.Create_Version',
408: p_module_name => l_module_name,

Line 410: pa_fp_gen_amount_utils.fp_debug

406: p_msg =>'Before calling
407: pa_fin_plan_pub.Create_Version',
408: p_module_name => l_module_name,
409: p_log_level => 5);
410: pa_fp_gen_amount_utils.fp_debug
411: (p_called_mode => l_called_mode,
412: p_msg =>'Value of Project_id: '||l_proj_id,
413: p_module_name => l_module_name,
414: p_log_level => 5);

Line 415: pa_fp_gen_amount_utils.fp_debug

411: (p_called_mode => l_called_mode,
412: p_msg =>'Value of Project_id: '||l_proj_id,
413: p_module_name => l_module_name,
414: p_log_level => 5);
415: pa_fp_gen_amount_utils.fp_debug
416: (p_called_mode => l_called_mode,
417: p_msg =>'Value of fin_plan_type_id : '||l_plan_type_id,
418: p_module_name => l_module_name,
419: p_log_level => 5);

Line 420: pa_fp_gen_amount_utils.fp_debug

416: (p_called_mode => l_called_mode,
417: p_msg =>'Value of fin_plan_type_id : '||l_plan_type_id,
418: p_module_name => l_module_name,
419: p_log_level => 5);
420: pa_fp_gen_amount_utils.fp_debug
421: (p_called_mode => l_called_mode,
422: p_msg =>'Element Type : '|| l_element_type_tab(i),
423: p_module_name => l_module_name,
424: p_log_level => 5);

Line 472: pa_fp_gen_amount_utils.fp_debug

468: l_generation_flag := 'N';
469: END;
470:
471: IF p_pa_debug_mode = 'Y' THEN
472: pa_fp_gen_amount_utils.fp_debug
473: (p_called_mode => l_called_mode,
474: p_msg =>'Status aft calling pa_fin_plan_pub.Create_Version:'
475: ||l_return_status,
476: p_module_name => l_module_name,

Line 482: pa_fp_gen_amount_utils.fp_debug

478: END IF;
479:
480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
481: IF p_pa_debug_mode = 'Y' THEN
482: pa_fp_gen_amount_utils.fp_debug
483: (p_called_mode => l_called_mode,
484: p_msg =>'Raising invalid arg exc after create version api call',
485: p_module_name => l_module_name,
486: p_log_level => 5);

Line 495: pa_fp_gen_amount_utils.fp_debug

491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: l_generation_flag := 'N';
493: l_msg_count := FND_MSG_PUB.Count_Msg;
494: IF p_pa_debug_mode = 'Y' THEN
495: pa_fp_gen_amount_utils.fp_debug
496: (p_called_mode => l_called_mode,
497: p_msg =>
498: 'Value of l_msg_count after calling create_version api: '||l_msg_count ,
499: p_module_name => l_module_name,

Line 555: pa_fp_gen_amount_utils.fp_debug

551: IF l_plan_class_code = 'FORECAST' AND
552: l_generation_flag = 'Y' THEN
553:
554: IF p_pa_debug_mode = 'Y' THEN
555: pa_fp_gen_amount_utils.fp_debug
556: (p_called_mode => l_called_mode,
557: p_msg => 'Before calling
558: pa_fp_gen_amount_utils.get_plan_version_dtls',
559: p_module_name => l_module_name,

Line 558: pa_fp_gen_amount_utils.get_plan_version_dtls',

554: IF p_pa_debug_mode = 'Y' THEN
555: pa_fp_gen_amount_utils.fp_debug
556: (p_called_mode => l_called_mode,
557: p_msg => 'Before calling
558: pa_fp_gen_amount_utils.get_plan_version_dtls',
559: p_module_name => l_module_name,
560: p_log_level => 5);
561: END IF;
562: --dbms_output.put_line('b4 calling get_plan_version_dtls api');

Line 564: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

560: p_log_level => 5);
561: END IF;
562: --dbms_output.put_line('b4 calling get_plan_version_dtls api');
563: BEGIN
564: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
565: (P_BUDGET_VERSION_ID => lx_budget_version_id,
566: X_FP_COLS_REC => l_fp_cols_rec,
567: X_RETURN_STATUS => l_return_status,
568: X_MSG_COUNT => l_msg_count,

Line 577: pa_fp_gen_amount_utils.fp_debug

573: END;
574: -- dbms_output.put_line('Status after calling get_plan_version_dtls api: '||l_return_status);
575: -- hr_utility.trace('L_RETURN_Status after calling get_plan_version_dtls api: '||l_return_status);
576: IF p_pa_debug_mode = 'Y' THEN
577: pa_fp_gen_amount_utils.fp_debug
578: (p_called_mode => l_called_mode,
579: p_msg => 'Status after calling
580: pa_fp_gen_amount_utils.get_plan_version_dtls'
581: ||l_return_status,

Line 580: pa_fp_gen_amount_utils.get_plan_version_dtls'

576: IF p_pa_debug_mode = 'Y' THEN
577: pa_fp_gen_amount_utils.fp_debug
578: (p_called_mode => l_called_mode,
579: p_msg => 'Status after calling
580: pa_fp_gen_amount_utils.get_plan_version_dtls'
581: ||l_return_status,
582: p_module_name => l_module_name,
583: p_log_level => 5);
584: END IF;

Line 588: pa_fp_gen_amount_utils.fp_debug

584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: IF p_pa_debug_mode = 'Y' THEN
588: pa_fp_gen_amount_utils.fp_debug
589: (p_called_mode => l_called_mode,
590: p_msg =>'Raising invalid arg exc after Get Plan ver dtls api call',
591: p_module_name => l_module_name,
592: p_log_level => 5);

Line 773: pa_fp_gen_amount_utils.fp_debug

769: OR l_gen_src_plan_ver_code = 'CURRENT_APPROVED'
770: OR l_gen_src_plan_ver_code = 'ORIGINAL_APPROVED' THEN
771: /*Get the current baselined or original baselined version*/
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_fp_gen_amount_utils.fp_debug
774: (p_called_mode => l_called_mode,
775: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
776: p_module_name => l_module_name,
777: p_log_level => 5);

Line 775: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',

771: /*Get the current baselined or original baselined version*/
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_fp_gen_amount_utils.fp_debug
774: (p_called_mode => l_called_mode,
775: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
776: p_module_name => l_module_name,
777: p_log_level => 5);
778: END IF;
779: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');

Line 779: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');

775: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
776: p_module_name => l_module_name,
777: p_log_level => 5);
778: END IF;
779: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');
780: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
781: p_project_id => l_proj_id,
782: p_fin_plan_type_id => l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
783: p_version_type => l_version_type, --Bug 16181483 -- bug 7032123 skkoppul : changed COST to NULL

Line 780: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

776: p_module_name => l_module_name,
777: p_log_level => 5);
778: END IF;
779: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');
780: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
781: p_project_id => l_proj_id,
782: p_fin_plan_type_id => l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
783: p_version_type => l_version_type, --Bug 16181483 -- bug 7032123 skkoppul : changed COST to NULL
784: p_status_code => l_gen_src_plan_ver_code,

Line 791: pa_fp_gen_amount_utils.fp_debug

787: x_return_status => l_return_status,
788: x_msg_count => l_msg_count,
789: x_msg_data => l_msg_data);
790: IF P_PA_DEBUG_MODE = 'Y' THEN
791: pa_fp_gen_amount_utils.fp_debug
792: (p_called_mode => l_called_mode,
793: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '
794: ||l_return_status,
795: p_module_name => l_module_name,

Line 793: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '

789: x_msg_data => l_msg_data);
790: IF P_PA_DEBUG_MODE = 'Y' THEN
791: pa_fp_gen_amount_utils.fp_debug
792: (p_called_mode => l_called_mode,
793: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '
794: ||l_return_status,
795: p_module_name => l_module_name,
796: p_log_level => 5);
797: END IF;

Line 802: pa_fp_gen_amount_utils.fp_debug

798:
799:
800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
801: IF p_pa_debug_mode = 'Y' THEN
802: pa_fp_gen_amount_utils.fp_debug
803: (p_called_mode => l_called_mode,
804: p_msg=>'Raising invalid arg exc aft Get Curr Original ver api call',
805: p_module_name => l_module_name,
806: p_log_level => 5);

Line 818: pa_fp_gen_amount_utils.fp_debug

814:
815: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
816: /*Get the current working version*/
817: IF P_PA_DEBUG_MODE = 'Y' THEN
818: pa_fp_gen_amount_utils.fp_debug
819: (p_called_mode => l_called_mode,
820: p_msg => 'Before calling pa_fin_plan_utils.Get_Curr_Working_Version_Info',
821: p_module_name => l_module_name,
822: p_log_level => 5);

Line 834: pa_fp_gen_amount_utils.fp_debug

830: x_return_status => l_return_status,
831: x_msg_count => l_msg_count,
832: x_msg_data => l_msg_data);
833: IF P_PA_DEBUG_MODE = 'Y' THEN
834: pa_fp_gen_amount_utils.fp_debug
835: (p_called_mode => l_called_mode,
836: p_msg =>
837: 'Aft calling pa_fin_plan_utils.Get_Curr_Working_Version_Info ret sta:'
838: ||l_return_status,

Line 845: pa_fp_gen_amount_utils.fp_debug

841: END IF;
842:
843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: IF p_pa_debug_mode = 'Y' THEN
845: pa_fp_gen_amount_utils.fp_debug
846: (p_called_mode => l_called_mode,
847: p_msg=>'Raising invalid arg exc aft Get Curr Wkg ver api call',
848: p_module_name => l_module_name,
849: p_log_level => 5);

Line 880: pa_fp_gen_amount_utils.fp_debug

876: -- Source Work plan is either 'Workplan Resources' or 'Financial Plan'
877: IF l_copy_etc_from_plan_flag = 'Y' THEN
878: BEGIN --Begining of the block for validation_for_copy_etc_flag
879: IF p_pa_debug_mode = 'Y' THEN
880: pa_fp_gen_amount_utils.fp_debug
881: (p_msg => 'Before calling
882: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
883: p_module_name => l_module_name,
884: p_log_level => 5);

Line 896: pa_fp_gen_amount_utils.fp_debug

892: x_return_status => l_return_status,
893: x_msg_count => l_msg_count,
894: x_msg_data => l_msg_data);
895: IF p_pa_debug_mode = 'Y' THEN
896: pa_fp_gen_amount_utils.fp_debug
897: (p_msg => 'Status after calling
898: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
899: ||l_return_status,
900: p_module_name => l_module_name,

Line 911: pa_fp_gen_amount_utils.fp_debug

907: l_return_status := FND_API.G_RET_STS_ERROR;
908: l_msg_count := 1;
909: l_msg_data := substr(sqlerrm,1,240);
910: IF P_PA_DEBUG_MODE = 'Y' THEN
911: pa_fp_gen_amount_utils.fp_debug
912: (p_called_mode => l_called_mode,
913: p_msg => 'Error: Validate Copy ETC from Plan'||l_msg_data,
914: p_module_name => l_module_name,
915: p_log_level => 5);

Line 954: pa_fp_gen_amount_utils.fp_debug

950: WHERE BUDGET_VERSION_ID = lx_budget_version_id;
951:
952: --hr_utility.trace('l_etc_fp_type_id : '||l_etc_fp_type_id);
953: IF P_PA_DEBUG_MODE = 'Y' THEN
954: pa_fp_gen_amount_utils.fp_debug
955: (p_called_mode => l_called_mode,
956: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||
957: 'l_proj_id = '||l_proj_id,
958: p_module_name => l_module_name,

Line 961: pa_fp_gen_amount_utils.fp_debug

957: 'l_proj_id = '||l_proj_id,
958: p_module_name => l_module_name,
959: p_log_level => 5);
960:
961: pa_fp_gen_amount_utils.fp_debug
962: (p_called_mode => l_called_mode,
963: p_msg => 'Budget version id :'||lx_budget_version_id,
964: p_module_name => l_module_name,
965: p_log_level => 5);

Line 966: pa_fp_gen_amount_utils.fp_debug

962: (p_called_mode => l_called_mode,
963: p_msg => 'Budget version id :'||lx_budget_version_id,
964: p_module_name => l_module_name,
965: p_log_level => 5);
966: pa_fp_gen_amount_utils.fp_debug
967: (p_called_mode => l_called_mode,
968: p_msg => 'ver type : Unspent amt flag '||
969: l_element_type_tab(i)|| ' : '||
970: l_fp_cols_rec.x_gen_incl_unspent_amt_flag,

Line 973: pa_fp_gen_amount_utils.fp_debug

969: l_element_type_tab(i)|| ' : '||
970: l_fp_cols_rec.x_gen_incl_unspent_amt_flag,
971: p_module_name => l_module_name,
972: p_log_level => 5);
973: pa_fp_gen_amount_utils.fp_debug
974: (p_called_mode => l_called_mode,
975: p_msg => 'unspent amt pd : Incu chg doc flag '||
976: l_unspent_amt_period|| ' : ' ||
977: l_fp_cols_rec.x_gen_incl_change_doc_flag,

Line 980: pa_fp_gen_amount_utils.fp_debug

976: l_unspent_amt_period|| ' : ' ||
977: l_fp_cols_rec.x_gen_incl_change_doc_flag,
978: p_module_name => l_module_name,
979: p_log_level => 5);
980: pa_fp_gen_amount_utils.fp_debug
981: (p_called_mode => l_called_mode,
982: p_msg => 'Incl Open cmt : Incu bill events ' ||
983: l_fp_cols_rec.x_gen_incl_open_comm_flag|| ' : ' ||
984: l_fp_cols_rec.x_gen_incl_bill_event_flag,

Line 987: pa_fp_gen_amount_utils.fp_debug

983: l_fp_cols_rec.x_gen_incl_open_comm_flag|| ' : ' ||
984: l_fp_cols_rec.x_gen_incl_bill_event_flag,
985: p_module_name => l_module_name,
986: p_log_level => 5);
987: pa_fp_gen_amount_utils.fp_debug
988: (p_called_mode => l_called_mode,
989: p_msg => 'Ret manual lines : ETC plan type id ' ||
990: l_fp_cols_rec.x_gen_ret_manual_line_flag || ' : ' ||
991: l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,

Line 994: pa_fp_gen_amount_utils.fp_debug

990: l_fp_cols_rec.x_gen_ret_manual_line_flag || ' : ' ||
991: l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
992: p_module_name => l_module_name,
993: p_log_level => 5);
994: pa_fp_gen_amount_utils.fp_debug
995: (p_called_mode => l_called_mode,
996: p_msg => 'ver name : etc fp ver id ' ||
997: l_etc_fp_ver_name || ' : ' ||
998: l_etc_fp_ver_id,

Line 1001: pa_fp_gen_amount_utils.fp_debug

997: l_etc_fp_ver_name || ' : ' ||
998: l_etc_fp_ver_id,
999: p_module_name => l_module_name,
1000: p_log_level => 5);
1001: pa_fp_gen_amount_utils.fp_debug
1002: (p_called_mode => l_called_mode,
1003: p_msg => 'Act fr pd : Act to Pd ' ||
1004: l_act_from_period || ' : ' ||
1005: l_act_to_period,

Line 1008: pa_fp_gen_amount_utils.fp_debug

1004: l_act_from_period || ' : ' ||
1005: l_act_to_period,
1006: p_module_name => l_module_name,
1007: p_log_level => 5);
1008: pa_fp_gen_amount_utils.fp_debug
1009: (p_called_mode => l_called_mode,
1010: p_msg => 'ETC fr pd : ETC to Pd ' ||
1011: l_etc_from_period || ' : ' ||
1012: l_etc_to_period,

Line 1017: pa_fp_gen_amount_utils.fp_debug

1013: p_module_name => l_module_name,
1014: p_log_level => 5);
1015: /* sysdate is used just for log message. The date should not be
1016: modified. */
1017: pa_fp_gen_amount_utils.fp_debug
1018: (p_called_mode => l_called_mode,
1019: p_msg => 'Actu thru pd : Actu thru Dt '||
1020: l_act_thru_period || ' : ' ||
1021: to_char(nvl(l_act_thru_date,trunc(sysdate)),'mm/dd/yyyy'),

Line 1024: pa_fp_gen_amount_utils.fp_debug

1020: l_act_thru_period || ' : ' ||
1021: to_char(nvl(l_act_thru_date,trunc(sysdate)),'mm/dd/yyyy'),
1022: p_module_name => l_module_name,
1023: p_log_level => 5);
1024: pa_fp_gen_amount_utils.fp_debug
1025: (p_called_mode => l_called_mode,
1026: p_msg => 'ETC WP Str Ver id :' ||
1027: l_etc_wp_struct_ver_id,
1028: p_module_name => l_module_name,

Line 1058: pa_fp_gen_amount_utils.fp_debug

1054:
1055: IF l_gen_api_call_flag = 'Y' THEN
1056: BEGIN
1057: IF p_pa_debug_mode = 'Y' THEN
1058: pa_fp_gen_amount_utils.fp_debug
1059: ( p_called_mode => l_called_mode,
1060: p_msg => 'Before calling
1061: pa_fp_gen_amount_utils.validate_support_cases',
1062: p_module_name => l_module_name,

Line 1061: pa_fp_gen_amount_utils.validate_support_cases',

1057: IF p_pa_debug_mode = 'Y' THEN
1058: pa_fp_gen_amount_utils.fp_debug
1059: ( p_called_mode => l_called_mode,
1060: p_msg => 'Before calling
1061: pa_fp_gen_amount_utils.validate_support_cases',
1062: p_module_name => l_module_name,
1063: p_log_level => 5 );
1064: END IF;
1065: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

Line 1065: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

1061: pa_fp_gen_amount_utils.validate_support_cases',
1062: p_module_name => l_module_name,
1063: p_log_level => 5 );
1064: END IF;
1065: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
1066: P_FP_COLS_REC_TGT => l_fp_cols_rec,
1067: P_CALLING_CONTEXT => 'CONCURRENT',
1068: X_WARNING_MESSAGE => l_warning_message, /* Added for ER 4391321 */
1069: X_RETURN_STATUS => l_return_status,

Line 1073: pa_fp_gen_amount_utils.fp_debug

1069: X_RETURN_STATUS => l_return_status,
1070: X_MSG_COUNT => l_msg_count,
1071: X_MSG_DATA => l_msg_data );
1072: IF p_pa_debug_mode = 'Y' THEN
1073: pa_fp_gen_amount_utils.fp_debug
1074: ( p_called_mode => l_called_mode,
1075: p_msg => 'Status after calling
1076: pa_fp_gen_amount_utils.validate_support_cases: '
1077: ||l_return_status,

Line 1076: pa_fp_gen_amount_utils.validate_support_cases: '

1072: IF p_pa_debug_mode = 'Y' THEN
1073: pa_fp_gen_amount_utils.fp_debug
1074: ( p_called_mode => l_called_mode,
1075: p_msg => 'Status after calling
1076: pa_fp_gen_amount_utils.validate_support_cases: '
1077: ||l_return_status,
1078: p_module_name => l_module_name,
1079: p_log_level => 5 );
1080: END IF;

Line 1083: pa_fp_gen_amount_utils.fp_debug

1079: p_log_level => 5 );
1080: END IF;
1081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: IF p_pa_debug_mode = 'Y' THEN
1083: pa_fp_gen_amount_utils.fp_debug
1084: (p_called_mode => l_called_mode,
1085: p_msg=>'Raising invalid arg exc aft validation api call',
1086: p_module_name => l_module_name,
1087: p_log_level => 5);

Line 1125: pa_fp_gen_amount_utils.fp_debug

1121: X_RETURN_STATUS => l_return_status,
1122: X_MSG_COUNT => l_msg_count,
1123: X_MSG_DATA => l_msg_data );
1124: IF P_PA_DEBUG_MODE = 'Y' THEN
1125: pa_fp_gen_amount_utils.fp_debug
1126: (p_called_mode => l_called_mode,
1127: p_msg =>
1128: 'After calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||
1129: ' ret status is:'||l_return_status,

Line 1138: pa_fp_gen_amount_utils.fp_debug

1134: -- hr_utility.trace('l_version_generation GENERATE_FCST_AMT_WRP '||l_generation_flag);
1135:
1136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: IF p_pa_debug_mode = 'Y' THEN
1138: pa_fp_gen_amount_utils.fp_debug
1139: (p_called_mode => l_called_mode,
1140: p_msg=>'Raising invalid arg exc aft Fcst Gen api call',
1141: p_module_name => l_module_name,
1142: p_log_level => 5);

Line 1160: pa_fp_gen_amount_utils.fp_debug

1156: l_msg_count := 1;
1157: l_msg_data := substr(sqlerrm,1,240);
1158: --dbms_output.put_line('error msg :'||x_msg_data);
1159: IF P_PA_DEBUG_MODE = 'Y' THEN
1160: pa_fp_gen_amount_utils.fp_debug
1161: (p_called_mode => l_called_mode,
1162: p_msg => 'Forecast Gen Error'||l_msg_data,
1163: p_module_name => l_module_name,
1164: p_log_level => 5);

Line 1176: pa_fp_gen_amount_utils.fp_debug

1172: ELSIF l_plan_class_code = 'BUDGET' AND
1173: l_generation_flag = 'Y' AND
1174: l_gen_api_call_flag = 'Y' THEN
1175: IF p_pa_debug_mode = 'Y' THEN
1176: pa_fp_gen_amount_utils.fp_debug
1177: (p_called_mode => l_called_mode,
1178: p_msg =>
1179: 'Before calling PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT'||
1180: 'Proj Id : '||to_char(l_proj_id) ||

Line 1214: pa_fp_gen_amount_utils.fp_debug

1210: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1211: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1212: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1213: IF p_pa_debug_mode = 'Y' THEN
1214: pa_fp_gen_amount_utils.fp_debug
1215: (p_called_mode => l_called_mode,
1216: p_msg => 'Status after calling
1217: PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT:'
1218: ||l_return_status,

Line 1224: pa_fp_gen_amount_utils.fp_debug

1220: p_log_level => 5);
1221: END IF;
1222: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: IF p_pa_debug_mode = 'Y' THEN
1224: pa_fp_gen_amount_utils.fp_debug
1225: (p_called_mode => l_called_mode,
1226: p_msg=>'Raising invalid arg exc aft Bdgt Gen api call',
1227: p_module_name => l_module_name,
1228: p_log_level => 5);

Line 1246: pa_fp_gen_amount_utils.fp_debug

1242: l_msg_count := 1;
1243: l_msg_data := substr(sqlerrm,1,240);
1244: --dbms_output.put_line('error msg :'||x_msg_data);
1245: IF P_PA_DEBUG_MODE = 'Y' THEN
1246: pa_fp_gen_amount_utils.fp_debug
1247: (p_called_mode => l_called_mode,
1248: p_msg => 'Budget Gen Error'||l_msg_data,
1249: p_module_name => l_module_name,
1250: p_log_level => 5);

Line 1261: pa_fp_gen_amount_utils.fp_debug

1257:
1258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: -- hr_utility.trace('INVALID EXCEPTION!!!');
1260: IF p_pa_debug_mode = 'Y' THEN
1261: pa_fp_gen_amount_utils.fp_debug
1262: (p_called_mode => l_called_mode,
1263: p_msg=>'Raising invalid arg exc aft Fcst / Bdgt Gen api call',
1264: p_module_name => l_module_name,
1265: p_log_level => 5);

Line 1276: pa_fp_gen_amount_utils.fp_debug

1272:
1273: IF l_gen_api_call_flag = 'N' THEN
1274: l_msg_count := FND_MSG_PUB.Count_Msg;
1275: IF p_pa_debug_mode = 'Y' THEN
1276: pa_fp_gen_amount_utils.fp_debug
1277: (p_called_mode => l_called_mode,
1278: p_msg =>
1279: 'Value of l_msg_count after calling Budget / Forecast Gen API'
1280: ||l_msg_count,

Line 1337: pa_fp_gen_amount_utils.fp_debug

1333: END IF;
1334: IF l_plan_type_validated = 'N' THEN
1335: l_msg_count := FND_MSG_PUB.Count_Msg;
1336: IF p_pa_debug_mode = 'Y' THEN
1337: pa_fp_gen_amount_utils.fp_debug
1338: (p_called_mode => l_called_mode,
1339: p_msg =>
1340: 'Value of l_msg_count after processing Plan Type :'||l_plan_type_name
1341: ||l_msg_count,

Line 1413: pa_fp_gen_amount_utils.fp_debug

1409: l_return_status := FND_API.G_RET_STS_ERROR;
1410: -- hr_utility.trace('Outside Error-l_return_status'||l_return_status);
1411:
1412: IF P_PA_DEBUG_MODE = 'Y' THEN
1413: pa_fp_gen_amount_utils.fp_debug
1414: (p_called_mode => l_called_mode,
1415: p_msg => 'Invalid Arg Exc Error'||substr(sqlerrm, 1, 240),
1416: p_module_name => l_module_name,
1417: p_log_level => 5);

Line 1444: pa_fp_gen_amount_utils.fp_debug

1440: ( p_pkg_name => ' PA_FP_GEN_AMT_WRP_PKG',
1441: p_procedure_name => 'GEN_AMT_WRP',
1442: p_error_text => substr(sqlerrm,1,240));
1443: IF P_PA_DEBUG_MODE = 'Y' THEN
1444: pa_fp_gen_amount_utils.fp_debug
1445: (p_called_mode => l_called_mode,
1446: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1447: p_module_name => l_module_name,
1448: p_log_level => 5);