eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_MAIN dependencies on FND_GLOBAL

Line 831: fnd_global.local_chr(10));

827:
828: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');
829: l_rpt_footer := FND_MESSAGE.GET;
830: PJI_UTILS.WRITE2OUT('-----------------------------------------------------------------------------------------------------------------------------------------' ||
831: fnd_global.local_chr(10));
832:
833:
834: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
835: ' '||l_rpt_header);

Line 834: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

830: PJI_UTILS.WRITE2OUT('-----------------------------------------------------------------------------------------------------------------------------------------' ||
831: fnd_global.local_chr(10));
832:
833:
834: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
835: ' '||l_rpt_header);
836: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
837: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
838: fnd_global.local_chr(10));

Line 836: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

832:
833:
834: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
835: ' '||l_rpt_header);
836: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
837: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
838: fnd_global.local_chr(10));
839:
840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||

Line 838: fnd_global.local_chr(10));

834: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
835: ' '||l_rpt_header);
836: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
837: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
838: fnd_global.local_chr(10));
839:
840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
841: fnd_global.local_chr(10));
842:

Line 840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||

836: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
837: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
838: fnd_global.local_chr(10));
839:
840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
841: fnd_global.local_chr(10));
842:
843: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

Line 841: fnd_global.local_chr(10));

837: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
838: fnd_global.local_chr(10));
839:
840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
841: fnd_global.local_chr(10));
842:
843: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
845: '===================== =================' );

Line 843: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );

839:
840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
841: fnd_global.local_chr(10));
842:
843: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
845: '===================== =================' );
846: for i in c_err_report LOOP
847:

Line 844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

840: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
841: fnd_global.local_chr(10));
842:
843: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
845: '===================== =================' );
846: for i in c_err_report LOOP
847:
848: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);

Line 848: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);

844: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
845: '===================== =================' );
846: for i in c_err_report LOOP
847:
848: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);
849:
850: END LOOp;
851:
852: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

Line 852: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

848: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);
849:
850: END LOOp;
851:
852: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
853: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
854: END IF;
855: end OUTPUT_ACT_FAILED_RUNS;
856:

Line 900: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

896: l_proj_name := FND_MESSAGE.GET;
897: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');
898: l_rpt_footer := FND_MESSAGE.GET;
899:
900: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
901: '-----------------------------------------------------------------------------------------------------------------------------------------' );
902:
903: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
904: ' '||l_rpt_header);

Line 903: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

899:
900: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
901: '-----------------------------------------------------------------------------------------------------------------------------------------' );
902:
903: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
904: ' '||l_rpt_header);
905: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
906: '-----------------------------------------------------------------------------------------------------------------------------------------' );
907:

Line 905: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

901: '-----------------------------------------------------------------------------------------------------------------------------------------' );
902:
903: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
904: ' '||l_rpt_header);
905: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
906: '-----------------------------------------------------------------------------------------------------------------------------------------' );
907:
908: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
909: l_Proj_Number||' '||l_Proj_Name );

Line 908: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

904: ' '||l_rpt_header);
905: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
906: '-----------------------------------------------------------------------------------------------------------------------------------------' );
907:
908: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
909: l_Proj_Number||' '||l_Proj_Name );
910: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
911: '====================== =================' );
912:

Line 910: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

906: '-----------------------------------------------------------------------------------------------------------------------------------------' );
907:
908: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
909: l_Proj_Number||' '||l_Proj_Name );
910: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
911: '====================== =================' );
912:
913: for i in c_err_report LOOP
914:

Line 915: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.name);

911: '====================== =================' );
912:
913: for i in c_err_report LOOP
914:
915: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.name);
916:
917: END LOOp;
918:
919: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

Line 919: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

915: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.name);
916:
917: END LOOp;
918:
919: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
920: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
921: END IF;
922: end OUTPUT_ACT_PASSED_RUNS;
923:

Line 938: l_created_by number := FND_GLOBAL.USER_ID;

934: Procedure PLAN_TYPE_CODE_CHANGES(p_worker_id in number) is
935: l_count number(10) := 0;
936: l_level number(10);
937: l_creation_date date := sysdate;
938: l_created_by number := FND_GLOBAL.USER_ID;
939: l_last_update_date date := SYSDATE;
940: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
941: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
942:

Line 940: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

936: l_level number(10);
937: l_creation_date date := sysdate;
938: l_created_by number := FND_GLOBAL.USER_ID;
939: l_last_update_date date := SYSDATE;
940: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
941: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
942:
943: cursor C_BOTTOM_UP is
944: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */

Line 941: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

937: l_creation_date date := sysdate;
938: l_created_by number := FND_GLOBAL.USER_ID;
939: l_last_update_date date := SYSDATE;
940: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
941: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
942:
943: cursor C_BOTTOM_UP is
944: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
945: SUP_LEVEL

Line 2963: FND_GLOBAL.CONC_REQUEST_ID);

2959:
2960: l_process := g_process || p_worker_id;
2961:
2962: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
2963: FND_GLOBAL.CONC_REQUEST_ID);
2964:
2965: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
2966:
2967: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');

Line 2985: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

2981: END_DATE,
2982: COMPLETION_TEXT
2983: )
2984: select
2985: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
2986: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
2987: l_process PROCESS_NAME,
2988: l_extraction_type RUN_TYPE,
2989: substr(p_run_mode || ', ' ||

Line 2986: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,

2982: COMPLETION_TEXT
2983: )
2984: select
2985: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
2986: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
2987: l_process PROCESS_NAME,
2988: l_extraction_type RUN_TYPE,
2989: substr(p_run_mode || ', ' ||
2990: to_char(p_operating_unit) || ', ' ||