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 854: fnd_global.local_chr(10));

850:
851: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');
852: l_rpt_footer := FND_MESSAGE.GET;
853: PJI_UTILS.WRITE2OUT('-----------------------------------------------------------------------------------------------------------------------------------------' ||
854: fnd_global.local_chr(10));
855:
856:
857: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
858: ' '||l_rpt_header);

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

853: PJI_UTILS.WRITE2OUT('-----------------------------------------------------------------------------------------------------------------------------------------' ||
854: fnd_global.local_chr(10));
855:
856:
857: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
858: ' '||l_rpt_header);
859: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
860: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
861: fnd_global.local_chr(10));

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

855:
856:
857: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
858: ' '||l_rpt_header);
859: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
860: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
861: fnd_global.local_chr(10));
862:
863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||

Line 861: fnd_global.local_chr(10));

857: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
858: ' '||l_rpt_header);
859: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
860: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
861: fnd_global.local_chr(10));
862:
863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
864: fnd_global.local_chr(10));
865:

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

859: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
860: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
861: fnd_global.local_chr(10));
862:
863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
864: fnd_global.local_chr(10));
865:
866: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
867: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

Line 864: fnd_global.local_chr(10));

860: '-----------------------------------------------------------------------------------------------------------------------------------------' ||
861: fnd_global.local_chr(10));
862:
863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
864: fnd_global.local_chr(10));
865:
866: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
867: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
868: '===================== =================' );

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

862:
863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
864: fnd_global.local_chr(10));
865:
866: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
867: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
868: '===================== =================' );
869: for i in c_err_report LOOP
870:

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

863: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) || l_rpt_info ||
864: fnd_global.local_chr(10));
865:
866: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||l_proj_number||' '||l_rpt_excep_reason );
867: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
868: '===================== =================' );
869: for i in c_err_report LOOP
870:
871: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);

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

867: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
868: '===================== =================' );
869: for i in c_err_report LOOP
870:
871: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);
872:
873: END LOOp;
874:
875: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

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

871: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.act_err_msg);
872:
873: END LOOp;
874:
875: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
876: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
877: END IF;
878: end OUTPUT_ACT_FAILED_RUNS;
879:

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

919: l_proj_name := FND_MESSAGE.GET;
920: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');
921: l_rpt_footer := FND_MESSAGE.GET;
922:
923: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
924: '-----------------------------------------------------------------------------------------------------------------------------------------' );
925:
926: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
927: ' '||l_rpt_header);

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

922:
923: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
924: '-----------------------------------------------------------------------------------------------------------------------------------------' );
925:
926: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
927: ' '||l_rpt_header);
928: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
929: '-----------------------------------------------------------------------------------------------------------------------------------------' );
930:

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

924: '-----------------------------------------------------------------------------------------------------------------------------------------' );
925:
926: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
927: ' '||l_rpt_header);
928: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
929: '-----------------------------------------------------------------------------------------------------------------------------------------' );
930:
931: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
932: l_Proj_Number||' '||l_Proj_Name );

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

927: ' '||l_rpt_header);
928: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
929: '-----------------------------------------------------------------------------------------------------------------------------------------' );
930:
931: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
932: l_Proj_Number||' '||l_Proj_Name );
933: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
934: '====================== =================' );
935:

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

929: '-----------------------------------------------------------------------------------------------------------------------------------------' );
930:
931: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
932: l_Proj_Number||' '||l_Proj_Name );
933: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
934: '====================== =================' );
935:
936: for i in c_err_report LOOP
937:

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

934: '====================== =================' );
935:
936: for i in c_err_report LOOP
937:
938: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.name);
939:
940: END LOOp;
941:
942: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||

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

938: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||rpad(i.segment1,27,' ')||i.name);
939:
940: END LOOp;
941:
942: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
943: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
944: END IF;
945: end OUTPUT_ACT_PASSED_RUNS;
946:

Line 961: l_created_by number := FND_GLOBAL.USER_ID;

957: Procedure PLAN_TYPE_CODE_CHANGES(p_worker_id in number) is
958: l_count number(10) := 0;
959: l_level number(10);
960: l_creation_date date := sysdate;
961: l_created_by number := FND_GLOBAL.USER_ID;
962: l_last_update_date date := SYSDATE;
963: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
964: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
965:

Line 963: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

959: l_level number(10);
960: l_creation_date date := sysdate;
961: l_created_by number := FND_GLOBAL.USER_ID;
962: l_last_update_date date := SYSDATE;
963: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
964: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
965:
966: cursor C_BOTTOM_UP is
967: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */

Line 964: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

960: l_creation_date date := sysdate;
961: l_created_by number := FND_GLOBAL.USER_ID;
962: l_last_update_date date := SYSDATE;
963: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
964: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
965:
966: cursor C_BOTTOM_UP is
967: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
968: SUP_LEVEL

Line 3038: FND_GLOBAL.CONC_REQUEST_ID);

3034:
3035: l_process := g_process || p_worker_id;
3036:
3037: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
3038: FND_GLOBAL.CONC_REQUEST_ID);
3039:
3040: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
3041:
3042: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');

Line 3060: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

3056: END_DATE,
3057: COMPLETION_TEXT
3058: )
3059: select
3060: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
3061: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
3062: l_process PROCESS_NAME,
3063: l_extraction_type RUN_TYPE,
3064: substr(p_run_mode || ', ' ||

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

3057: COMPLETION_TEXT
3058: )
3059: select
3060: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
3061: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
3062: l_process PROCESS_NAME,
3063: l_extraction_type RUN_TYPE,
3064: substr(p_run_mode || ', ' ||
3065: to_char(p_operating_unit) || ', ' ||