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 257: pa_fp_gen_amount_utils.fp_debug

253: -- hr_utility.trace('After execute, l_rows is: '||l_rows);
254:
255: IF (l_rows < 0) THEN
256: IF p_pa_debug_mode = 'Y' THEN
257: pa_fp_gen_amount_utils.fp_debug
258: (p_called_mode => l_called_mode,
259: p_msg =>'After dbms parse '||to_char(l_rows),
260: p_module_name => l_module_name,
261: p_log_level => 5);

Line 324: pa_fp_gen_amount_utils.fp_debug

320: l_generation_flag := 'Y';
321: l_gen_api_call_flag := 'Y';
322:
323: IF p_pa_debug_mode = 'Y' THEN
324: pa_fp_gen_amount_utils.fp_debug
325: (p_called_mode => l_called_mode,
326: p_msg =>'Before calling
327: pa_fin_plan_pub.Create_Version',
328: p_module_name => l_module_name,

Line 330: pa_fp_gen_amount_utils.fp_debug

326: p_msg =>'Before calling
327: pa_fin_plan_pub.Create_Version',
328: p_module_name => l_module_name,
329: p_log_level => 5);
330: pa_fp_gen_amount_utils.fp_debug
331: (p_called_mode => l_called_mode,
332: p_msg =>'Value of Project_id: '||l_proj_id,
333: p_module_name => l_module_name,
334: p_log_level => 5);

Line 335: pa_fp_gen_amount_utils.fp_debug

331: (p_called_mode => l_called_mode,
332: p_msg =>'Value of Project_id: '||l_proj_id,
333: p_module_name => l_module_name,
334: p_log_level => 5);
335: pa_fp_gen_amount_utils.fp_debug
336: (p_called_mode => l_called_mode,
337: p_msg =>'Value of fin_plan_type_id : '||l_plan_type_id,
338: p_module_name => l_module_name,
339: p_log_level => 5);

Line 340: pa_fp_gen_amount_utils.fp_debug

336: (p_called_mode => l_called_mode,
337: p_msg =>'Value of fin_plan_type_id : '||l_plan_type_id,
338: p_module_name => l_module_name,
339: p_log_level => 5);
340: pa_fp_gen_amount_utils.fp_debug
341: (p_called_mode => l_called_mode,
342: p_msg =>'Element Type : '|| l_element_type_tab(i),
343: p_module_name => l_module_name,
344: p_log_level => 5);

Line 406: pa_fp_gen_amount_utils.fp_debug

402: l_generation_flag := 'N';
403: END;
404:
405: IF p_pa_debug_mode = 'Y' THEN
406: pa_fp_gen_amount_utils.fp_debug
407: (p_called_mode => l_called_mode,
408: p_msg =>'Status aft calling pa_fin_plan_pub.Create_Version:'
409: ||l_return_status,
410: p_module_name => l_module_name,

Line 416: pa_fp_gen_amount_utils.fp_debug

412: END IF;
413:
414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
415: IF p_pa_debug_mode = 'Y' THEN
416: pa_fp_gen_amount_utils.fp_debug
417: (p_called_mode => l_called_mode,
418: p_msg =>'Raising invalid arg exc after create version api call',
419: p_module_name => l_module_name,
420: p_log_level => 5);

Line 429: pa_fp_gen_amount_utils.fp_debug

425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: l_generation_flag := 'N';
427: l_msg_count := FND_MSG_PUB.Count_Msg;
428: IF p_pa_debug_mode = 'Y' THEN
429: pa_fp_gen_amount_utils.fp_debug
430: (p_called_mode => l_called_mode,
431: p_msg =>
432: 'Value of l_msg_count after calling create_version api: '||l_msg_count ,
433: p_module_name => l_module_name,

Line 489: pa_fp_gen_amount_utils.fp_debug

485: IF l_plan_class_code = 'FORECAST' AND
486: l_generation_flag = 'Y' THEN
487:
488: IF p_pa_debug_mode = 'Y' THEN
489: pa_fp_gen_amount_utils.fp_debug
490: (p_called_mode => l_called_mode,
491: p_msg => 'Before calling
492: pa_fp_gen_amount_utils.get_plan_version_dtls',
493: p_module_name => l_module_name,

Line 492: pa_fp_gen_amount_utils.get_plan_version_dtls',

488: IF p_pa_debug_mode = 'Y' THEN
489: pa_fp_gen_amount_utils.fp_debug
490: (p_called_mode => l_called_mode,
491: p_msg => 'Before calling
492: pa_fp_gen_amount_utils.get_plan_version_dtls',
493: p_module_name => l_module_name,
494: p_log_level => 5);
495: END IF;
496: --dbms_output.put_line('b4 calling get_plan_version_dtls api');

Line 498: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

494: p_log_level => 5);
495: END IF;
496: --dbms_output.put_line('b4 calling get_plan_version_dtls api');
497: BEGIN
498: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
499: (P_BUDGET_VERSION_ID => lx_budget_version_id,
500: X_FP_COLS_REC => l_fp_cols_rec,
501: X_RETURN_STATUS => l_return_status,
502: X_MSG_COUNT => l_msg_count,

Line 511: pa_fp_gen_amount_utils.fp_debug

507: END;
508: -- dbms_output.put_line('Status after calling get_plan_version_dtls api: '||l_return_status);
509: -- hr_utility.trace('L_RETURN_Status after calling get_plan_version_dtls api: '||l_return_status);
510: IF p_pa_debug_mode = 'Y' THEN
511: pa_fp_gen_amount_utils.fp_debug
512: (p_called_mode => l_called_mode,
513: p_msg => 'Status after calling
514: pa_fp_gen_amount_utils.get_plan_version_dtls'
515: ||l_return_status,

Line 514: pa_fp_gen_amount_utils.get_plan_version_dtls'

510: IF p_pa_debug_mode = 'Y' THEN
511: pa_fp_gen_amount_utils.fp_debug
512: (p_called_mode => l_called_mode,
513: p_msg => 'Status after calling
514: pa_fp_gen_amount_utils.get_plan_version_dtls'
515: ||l_return_status,
516: p_module_name => l_module_name,
517: p_log_level => 5);
518: END IF;

Line 522: pa_fp_gen_amount_utils.fp_debug

518: END IF;
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: IF p_pa_debug_mode = 'Y' THEN
522: pa_fp_gen_amount_utils.fp_debug
523: (p_called_mode => l_called_mode,
524: p_msg =>'Raising invalid arg exc after Get Plan ver dtls api call',
525: p_module_name => l_module_name,
526: p_log_level => 5);

Line 683: pa_fp_gen_amount_utils.fp_debug

679: OR l_gen_src_plan_ver_code = 'CURRENT_APPROVED'
680: OR l_gen_src_plan_ver_code = 'ORIGINAL_APPROVED' THEN
681: /*Get the current baselined or original baselined version*/
682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_fp_gen_amount_utils.fp_debug
684: (p_called_mode => l_called_mode,
685: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
686: p_module_name => l_module_name,
687: p_log_level => 5);

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

681: /*Get the current baselined or original baselined version*/
682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_fp_gen_amount_utils.fp_debug
684: (p_called_mode => l_called_mode,
685: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
686: p_module_name => l_module_name,
687: p_log_level => 5);
688: END IF;
689: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');

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

685: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
686: p_module_name => l_module_name,
687: p_log_level => 5);
688: END IF;
689: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');
690: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
691: p_project_id => l_proj_id,
692: p_fin_plan_type_id => l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
693: p_version_type => NULL, -- bug 7032123 skkoppul : changed COST to NULL

Line 690: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

686: p_module_name => l_module_name,
687: p_log_level => 5);
688: END IF;
689: --hr_utility.trace('pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info');
690: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
691: p_project_id => l_proj_id,
692: p_fin_plan_type_id => l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
693: p_version_type => NULL, -- bug 7032123 skkoppul : changed COST to NULL
694: p_status_code => l_gen_src_plan_ver_code,

Line 701: pa_fp_gen_amount_utils.fp_debug

697: x_return_status => l_return_status,
698: x_msg_count => l_msg_count,
699: x_msg_data => l_msg_data);
700: IF P_PA_DEBUG_MODE = 'Y' THEN
701: pa_fp_gen_amount_utils.fp_debug
702: (p_called_mode => l_called_mode,
703: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '
704: ||l_return_status,
705: p_module_name => l_module_name,

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

699: x_msg_data => l_msg_data);
700: IF P_PA_DEBUG_MODE = 'Y' THEN
701: pa_fp_gen_amount_utils.fp_debug
702: (p_called_mode => l_called_mode,
703: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '
704: ||l_return_status,
705: p_module_name => l_module_name,
706: p_log_level => 5);
707: END IF;

Line 712: pa_fp_gen_amount_utils.fp_debug

708:
709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: IF p_pa_debug_mode = 'Y' THEN
712: pa_fp_gen_amount_utils.fp_debug
713: (p_called_mode => l_called_mode,
714: p_msg=>'Raising invalid arg exc aft Get Curr Original ver api call',
715: p_module_name => l_module_name,
716: p_log_level => 5);

Line 728: pa_fp_gen_amount_utils.fp_debug

724:
725: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
726: /*Get the current working version*/
727: IF P_PA_DEBUG_MODE = 'Y' THEN
728: pa_fp_gen_amount_utils.fp_debug
729: (p_called_mode => l_called_mode,
730: p_msg => 'Before calling pa_fin_plan_utils.Get_Curr_Working_Version_Info',
731: p_module_name => l_module_name,
732: p_log_level => 5);

Line 744: pa_fp_gen_amount_utils.fp_debug

740: x_return_status => l_return_status,
741: x_msg_count => l_msg_count,
742: x_msg_data => l_msg_data);
743: IF P_PA_DEBUG_MODE = 'Y' THEN
744: pa_fp_gen_amount_utils.fp_debug
745: (p_called_mode => l_called_mode,
746: p_msg =>
747: 'Aft calling pa_fin_plan_utils.Get_Curr_Working_Version_Info ret sta:'
748: ||l_return_status,

Line 755: pa_fp_gen_amount_utils.fp_debug

751: END IF;
752:
753: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: IF p_pa_debug_mode = 'Y' THEN
755: pa_fp_gen_amount_utils.fp_debug
756: (p_called_mode => l_called_mode,
757: p_msg=>'Raising invalid arg exc aft Get Curr Wkg ver api call',
758: p_module_name => l_module_name,
759: p_log_level => 5);

Line 810: pa_fp_gen_amount_utils.fp_debug

806: get_structure_sharing_code(p_project_id=>l_proj_id);
807:
808: --hr_utility.trace('l_etc_fp_type_id : '||l_etc_fp_type_id);
809: IF P_PA_DEBUG_MODE = 'Y' THEN
810: pa_fp_gen_amount_utils.fp_debug
811: (p_called_mode => l_called_mode,
812: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||
813: 'l_proj_id = '||l_proj_id,
814: p_module_name => l_module_name,

Line 817: pa_fp_gen_amount_utils.fp_debug

813: 'l_proj_id = '||l_proj_id,
814: p_module_name => l_module_name,
815: p_log_level => 5);
816:
817: pa_fp_gen_amount_utils.fp_debug
818: (p_called_mode => l_called_mode,
819: p_msg => 'Budget version id :'||lx_budget_version_id,
820: p_module_name => l_module_name,
821: p_log_level => 5);

Line 822: pa_fp_gen_amount_utils.fp_debug

818: (p_called_mode => l_called_mode,
819: p_msg => 'Budget version id :'||lx_budget_version_id,
820: p_module_name => l_module_name,
821: p_log_level => 5);
822: pa_fp_gen_amount_utils.fp_debug
823: (p_called_mode => l_called_mode,
824: p_msg => 'ver type : Unspent amt flag '||
825: l_element_type_tab(i)|| ' : '||
826: l_fp_cols_rec.x_gen_incl_unspent_amt_flag,

Line 829: pa_fp_gen_amount_utils.fp_debug

825: l_element_type_tab(i)|| ' : '||
826: l_fp_cols_rec.x_gen_incl_unspent_amt_flag,
827: p_module_name => l_module_name,
828: p_log_level => 5);
829: pa_fp_gen_amount_utils.fp_debug
830: (p_called_mode => l_called_mode,
831: p_msg => 'unspent amt pd : Incu chg doc flag '||
832: l_unspent_amt_period|| ' : ' ||
833: l_fp_cols_rec.x_gen_incl_change_doc_flag,

Line 836: pa_fp_gen_amount_utils.fp_debug

832: l_unspent_amt_period|| ' : ' ||
833: l_fp_cols_rec.x_gen_incl_change_doc_flag,
834: p_module_name => l_module_name,
835: p_log_level => 5);
836: pa_fp_gen_amount_utils.fp_debug
837: (p_called_mode => l_called_mode,
838: p_msg => 'Incl Open cmt : Incu bill events ' ||
839: l_fp_cols_rec.x_gen_incl_open_comm_flag|| ' : ' ||
840: l_fp_cols_rec.x_gen_incl_bill_event_flag,

Line 843: pa_fp_gen_amount_utils.fp_debug

839: l_fp_cols_rec.x_gen_incl_open_comm_flag|| ' : ' ||
840: l_fp_cols_rec.x_gen_incl_bill_event_flag,
841: p_module_name => l_module_name,
842: p_log_level => 5);
843: pa_fp_gen_amount_utils.fp_debug
844: (p_called_mode => l_called_mode,
845: p_msg => 'Ret manual lines : ETC plan type id ' ||
846: l_fp_cols_rec.x_gen_ret_manual_line_flag || ' : ' ||
847: l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,

Line 850: pa_fp_gen_amount_utils.fp_debug

846: l_fp_cols_rec.x_gen_ret_manual_line_flag || ' : ' ||
847: l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID,
848: p_module_name => l_module_name,
849: p_log_level => 5);
850: pa_fp_gen_amount_utils.fp_debug
851: (p_called_mode => l_called_mode,
852: p_msg => 'ver name : etc fp ver id ' ||
853: l_etc_fp_ver_name || ' : ' ||
854: l_etc_fp_ver_id,

Line 857: pa_fp_gen_amount_utils.fp_debug

853: l_etc_fp_ver_name || ' : ' ||
854: l_etc_fp_ver_id,
855: p_module_name => l_module_name,
856: p_log_level => 5);
857: pa_fp_gen_amount_utils.fp_debug
858: (p_called_mode => l_called_mode,
859: p_msg => 'Act fr pd : Act to Pd ' ||
860: l_act_from_period || ' : ' ||
861: l_act_to_period,

Line 864: pa_fp_gen_amount_utils.fp_debug

860: l_act_from_period || ' : ' ||
861: l_act_to_period,
862: p_module_name => l_module_name,
863: p_log_level => 5);
864: pa_fp_gen_amount_utils.fp_debug
865: (p_called_mode => l_called_mode,
866: p_msg => 'ETC fr pd : ETC to Pd ' ||
867: l_etc_from_period || ' : ' ||
868: l_etc_to_period,

Line 873: pa_fp_gen_amount_utils.fp_debug

869: p_module_name => l_module_name,
870: p_log_level => 5);
871: /* sysdate is used just for log message. The date should not be
872: modified. */
873: pa_fp_gen_amount_utils.fp_debug
874: (p_called_mode => l_called_mode,
875: p_msg => 'Actu thru pd : Actu thru Dt '||
876: l_act_thru_period || ' : ' ||
877: to_char(nvl(l_act_thru_date,trunc(sysdate)),'mm/dd/yyyy'),

Line 880: pa_fp_gen_amount_utils.fp_debug

876: l_act_thru_period || ' : ' ||
877: to_char(nvl(l_act_thru_date,trunc(sysdate)),'mm/dd/yyyy'),
878: p_module_name => l_module_name,
879: p_log_level => 5);
880: pa_fp_gen_amount_utils.fp_debug
881: (p_called_mode => l_called_mode,
882: p_msg => 'ETC WP Str Ver id :' ||
883: l_etc_wp_struct_ver_id,
884: p_module_name => l_module_name,

Line 914: pa_fp_gen_amount_utils.fp_debug

910:
911: IF l_gen_api_call_flag = 'Y' THEN
912: BEGIN
913: IF p_pa_debug_mode = 'Y' THEN
914: pa_fp_gen_amount_utils.fp_debug
915: ( p_called_mode => l_called_mode,
916: p_msg => 'Before calling
917: pa_fp_gen_amount_utils.validate_support_cases',
918: p_module_name => l_module_name,

Line 917: pa_fp_gen_amount_utils.validate_support_cases',

913: IF p_pa_debug_mode = 'Y' THEN
914: pa_fp_gen_amount_utils.fp_debug
915: ( p_called_mode => l_called_mode,
916: p_msg => 'Before calling
917: pa_fp_gen_amount_utils.validate_support_cases',
918: p_module_name => l_module_name,
919: p_log_level => 5 );
920: END IF;
921: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

Line 921: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

917: pa_fp_gen_amount_utils.validate_support_cases',
918: p_module_name => l_module_name,
919: p_log_level => 5 );
920: END IF;
921: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
922: P_FP_COLS_REC_TGT => l_fp_cols_rec,
923: P_CALLING_CONTEXT => 'CONCURRENT',
924: X_WARNING_MESSAGE => l_warning_message, /* Added for ER 4391321 */
925: X_RETURN_STATUS => l_return_status,

Line 929: pa_fp_gen_amount_utils.fp_debug

925: X_RETURN_STATUS => l_return_status,
926: X_MSG_COUNT => l_msg_count,
927: X_MSG_DATA => l_msg_data );
928: IF p_pa_debug_mode = 'Y' THEN
929: pa_fp_gen_amount_utils.fp_debug
930: ( p_called_mode => l_called_mode,
931: p_msg => 'Status after calling
932: pa_fp_gen_amount_utils.validate_support_cases: '
933: ||l_return_status,

Line 932: pa_fp_gen_amount_utils.validate_support_cases: '

928: IF p_pa_debug_mode = 'Y' THEN
929: pa_fp_gen_amount_utils.fp_debug
930: ( p_called_mode => l_called_mode,
931: p_msg => 'Status after calling
932: pa_fp_gen_amount_utils.validate_support_cases: '
933: ||l_return_status,
934: p_module_name => l_module_name,
935: p_log_level => 5 );
936: END IF;

Line 939: pa_fp_gen_amount_utils.fp_debug

935: p_log_level => 5 );
936: END IF;
937: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: IF p_pa_debug_mode = 'Y' THEN
939: pa_fp_gen_amount_utils.fp_debug
940: (p_called_mode => l_called_mode,
941: p_msg=>'Raising invalid arg exc aft validation api call',
942: p_module_name => l_module_name,
943: p_log_level => 5);

Line 981: pa_fp_gen_amount_utils.fp_debug

977: X_RETURN_STATUS => l_return_status,
978: X_MSG_COUNT => l_msg_count,
979: X_MSG_DATA => l_msg_data );
980: IF P_PA_DEBUG_MODE = 'Y' THEN
981: pa_fp_gen_amount_utils.fp_debug
982: (p_called_mode => l_called_mode,
983: p_msg =>
984: 'After calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||
985: ' ret status is:'||l_return_status,

Line 994: pa_fp_gen_amount_utils.fp_debug

990: -- hr_utility.trace('l_version_generation GENERATE_FCST_AMT_WRP '||l_generation_flag);
991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: IF p_pa_debug_mode = 'Y' THEN
994: pa_fp_gen_amount_utils.fp_debug
995: (p_called_mode => l_called_mode,
996: p_msg=>'Raising invalid arg exc aft Fcst Gen api call',
997: p_module_name => l_module_name,
998: p_log_level => 5);

Line 1016: pa_fp_gen_amount_utils.fp_debug

1012: l_msg_count := 1;
1013: l_msg_data := substr(sqlerrm,1,240);
1014: --dbms_output.put_line('error msg :'||x_msg_data);
1015: IF P_PA_DEBUG_MODE = 'Y' THEN
1016: pa_fp_gen_amount_utils.fp_debug
1017: (p_called_mode => l_called_mode,
1018: p_msg => 'Forecast Gen Error'||l_msg_data,
1019: p_module_name => l_module_name,
1020: p_log_level => 5);

Line 1032: pa_fp_gen_amount_utils.fp_debug

1028: ELSIF l_plan_class_code = 'BUDGET' AND
1029: l_generation_flag = 'Y' AND
1030: l_gen_api_call_flag = 'Y' THEN
1031: IF p_pa_debug_mode = 'Y' THEN
1032: pa_fp_gen_amount_utils.fp_debug
1033: (p_called_mode => l_called_mode,
1034: p_msg =>
1035: 'Before calling PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT'||
1036: 'Proj Id : '||to_char(l_proj_id) ||

Line 1070: pa_fp_gen_amount_utils.fp_debug

1066: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1067: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1068: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1069: IF p_pa_debug_mode = 'Y' THEN
1070: pa_fp_gen_amount_utils.fp_debug
1071: (p_called_mode => l_called_mode,
1072: p_msg => 'Status after calling
1073: PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT:'
1074: ||l_return_status,

Line 1080: pa_fp_gen_amount_utils.fp_debug

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

Line 1102: pa_fp_gen_amount_utils.fp_debug

1098: l_msg_count := 1;
1099: l_msg_data := substr(sqlerrm,1,240);
1100: --dbms_output.put_line('error msg :'||x_msg_data);
1101: IF P_PA_DEBUG_MODE = 'Y' THEN
1102: pa_fp_gen_amount_utils.fp_debug
1103: (p_called_mode => l_called_mode,
1104: p_msg => 'Budget Gen Error'||l_msg_data,
1105: p_module_name => l_module_name,
1106: p_log_level => 5);

Line 1117: pa_fp_gen_amount_utils.fp_debug

1113:
1114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: -- hr_utility.trace('INVALID EXCEPTION!!!');
1116: IF p_pa_debug_mode = 'Y' THEN
1117: pa_fp_gen_amount_utils.fp_debug
1118: (p_called_mode => l_called_mode,
1119: p_msg=>'Raising invalid arg exc aft Fcst / Bdgt Gen api call',
1120: p_module_name => l_module_name,
1121: p_log_level => 5);

Line 1132: pa_fp_gen_amount_utils.fp_debug

1128:
1129: IF l_gen_api_call_flag = 'N' THEN
1130: l_msg_count := FND_MSG_PUB.Count_Msg;
1131: IF p_pa_debug_mode = 'Y' THEN
1132: pa_fp_gen_amount_utils.fp_debug
1133: (p_called_mode => l_called_mode,
1134: p_msg =>
1135: 'Value of l_msg_count after calling Budget / Forecast Gen API'
1136: ||l_msg_count,

Line 1217: pa_fp_gen_amount_utils.fp_debug

1213: l_return_status := FND_API.G_RET_STS_ERROR;
1214: -- hr_utility.trace('Outside Error-l_return_status'||l_return_status);
1215:
1216: IF P_PA_DEBUG_MODE = 'Y' THEN
1217: pa_fp_gen_amount_utils.fp_debug
1218: (p_called_mode => l_called_mode,
1219: p_msg => 'Invalid Arg Exc Error'||substr(sqlerrm, 1, 240),
1220: p_module_name => l_module_name,
1221: p_log_level => 5);

Line 1248: pa_fp_gen_amount_utils.fp_debug

1244: ( p_pkg_name => ' PA_FP_GEN_AMT_WRP_PKG',
1245: p_procedure_name => 'GEN_AMT_WRP',
1246: p_error_text => substr(sqlerrm,1,240));
1247: IF P_PA_DEBUG_MODE = 'Y' THEN
1248: pa_fp_gen_amount_utils.fp_debug
1249: (p_called_mode => l_called_mode,
1250: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1251: p_module_name => l_module_name,
1252: p_log_level => 5);