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 PJI_UTILS

Line 177: application => PJI_UTILS.GET_PJI_SCHEMA_NAME , -- Application Name

173:
174:
175: IF l_e_program is not null then
176: p_request_id := FND_REQUEST.SUBMIT_REQUEST(
177: application => PJI_UTILS.GET_PJI_SCHEMA_NAME , -- Application Name
178: program => l_e_program, -- Program Name
179: sub_request => FALSE, -- Sub Request
180: argument1 => l_e_run_mode, -- p_run_mode
181: argument2 => NVL(to_char(l_e_project_operating_unit),''), -- p_operating_unit

Line 244: PJI_UTILS.WRITE2OUT(l_newline ||

240: begin
241:
242: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NO_SUMM_WORK');
243:
244: PJI_UTILS.WRITE2OUT(l_newline ||
245: l_newline ||
246: FND_MESSAGE.GET ||
247: l_newline);
248:

Line 267: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

263: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');
264:
265: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
266:
267: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
268: my_pad(30 - length(l_project_operating_unit_tg),
269: ' ') ||
270: ': ' ||
271: l_project_operating_unit_name ||

Line 286: PJI_UTILS.WRITE2OUT(l_project_type_tg ||

282: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');
283:
284: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);
285:
286: PJI_UTILS.WRITE2OUT(l_project_type_tg ||
287: my_pad(30 - length(l_project_type_tg), ' ') ||
288: ': ' ||
289: l_project_type ||
290: l_newline);

Line 303: PJI_UTILS.WRITE2OUT(l_project_status_tg ||

299: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_STATUS');
300:
301: l_project_status_tg := substr(FND_MESSAGE.GET, 1, 30);
302:
303: PJI_UTILS.WRITE2OUT(l_project_status_tg ||
304: my_pad(30 - length(l_project_status_tg), ' ') ||
305: ':' ||
306: l_project_status ||
307: l_newline);

Line 328: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||

324: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');
325:
326: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);
327:
328: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||
329: my_pad(30 - length(l_project_organization_tg),
330: ' ') ||
331: ': ' ||
332: l_project_organization ||

Line 347: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

343: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');
344:
345: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
346:
347: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
348: my_pad(30 - length(l_from_project_tg), ' ') ||
349: ': ' ||
350: l_from_project ||
351: l_newline);

Line 365: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

361: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');
362:
363: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);
364:
365: PJI_UTILS.WRITE2OUT(l_to_project_tg ||
366: my_pad(30 - length(l_to_project_tg), ' ') ||
367: ': ' ||
368: l_to_project ||
369: l_newline);

Line 454: PJI_UTILS.WRITE2OUT(l_newline ||

450: l_header_flag := 'N';
451:
452: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_HEADER');
453:
454: PJI_UTILS.WRITE2OUT(l_newline ||
455: l_newline ||
456: FND_MESSAGE.GET ||
457: l_newline);
458:

Line 463: PJI_UTILS.WRITE2OUT(l_newline ||

459: end if;
460:
461: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_LINE');
462:
463: PJI_UTILS.WRITE2OUT(l_newline ||
464: FND_MESSAGE.GET ||
465: l_newline ||
466: l_newline);
467:

Line 472: PJI_UTILS.WRITE2OUT(l_extraction_type_tg ||

468: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE');
469:
470: l_extraction_type_tg := substr(FND_MESSAGE.GET, 1, 30);
471:
472: PJI_UTILS.WRITE2OUT(l_extraction_type_tg ||
473: my_pad(30 - length(l_extraction_type_tg), ' ') ||
474: ': ');
475:
476: if (l_extraction_type = 'FULL') then

Line 494: PJI_UTILS.WRITE2OUT(FND_MESSAGE.GET ||

490: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');
491:
492: end if;
493:
494: PJI_UTILS.WRITE2OUT(FND_MESSAGE.GET ||
495: l_newline);
496:
497: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
498:

Line 506: PJI_UTILS.WRITE2OUT(l_request_id_tg ||

502: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_REQ_ID');
503:
504: l_request_id_tg := substr(FND_MESSAGE.GET, 1, 30);
505:
506: PJI_UTILS.WRITE2OUT(l_request_id_tg ||
507: my_pad(30 - length(l_request_id_tg),
508: ' ') ||
509: ': ' ||
510: l_request_id ||

Line 538: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

534: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');
535:
536: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
537:
538: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
539: my_pad(30 - length(l_project_operating_unit_tg),
540: ' ') ||
541: ': ' ||
542: l_project_operating_unit_name ||

Line 562: PJI_UTILS.WRITE2OUT(l_project_type_tg ||

558: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');
559:
560: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);
561:
562: PJI_UTILS.WRITE2OUT(l_project_type_tg ||
563: my_pad(30 - length(l_project_type_tg), ' ') ||
564: ': ' ||
565: l_project_type ||
566: l_newline);

Line 592: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||

588: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');
589:
590: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);
591:
592: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||
593: my_pad(30 - length(l_project_organization_tg),
594: ' ') ||
595: ': ' ||
596: l_project_organization ||

Line 616: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

612: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');
613:
614: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
615:
616: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
617: my_pad(30 - length(l_from_project_tg), ' ') ||
618: ': ' ||
619: l_from_project ||
620: l_newline);

Line 639: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

635: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');
636:
637: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);
638:
639: PJI_UTILS.WRITE2OUT(l_to_project_tg ||
640: my_pad(30 - length(l_to_project_tg), ' ') ||
641: ': ' ||
642: l_to_project ||
643: l_newline);

Line 669: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||

665: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_TYPE');
666:
667: l_plan_type_tg := substr(FND_MESSAGE.GET, 1, 30);
668:
669: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||
670: my_pad(30 - length(l_plan_type_tg), ' ') ||
671: ': ' ||
672: l_plan_type ||
673: l_newline);

Line 699: PJI_UTILS.WRITE2OUT(l_rbs_header_tg ||

695: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_RBS_HDR');
696:
697: l_rbs_header_tg := substr(FND_MESSAGE.GET, 1, 30);
698:
699: PJI_UTILS.WRITE2OUT(l_rbs_header_tg ||
700: my_pad(30 - length(l_rbs_header_tg), ' ') ||
701: ': ' ||
702: l_rbs_header ||
703: l_newline);

Line 731: PJI_UTILS.WRITE2OUT(l_transaction_type_tg ||

727: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TXN_TYPE');
728:
729: l_transaction_type_tg := substr(FND_MESSAGE.GET, 1, 30);
730:
731: PJI_UTILS.WRITE2OUT(l_transaction_type_tg ||
732: my_pad(30 - length(l_transaction_type_tg), ' ') ||
733: ': ' ||
734: l_transaction_type ||
735: l_newline);

Line 756: PJI_UTILS.WRITE2OUT(l_plan_versions_tg ||

752: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_VER');
753:
754: l_plan_versions_tg := substr(FND_MESSAGE.GET, 1, 30);
755:
756: PJI_UTILS.WRITE2OUT(l_plan_versions_tg ||
757: my_pad(30 - length(l_plan_versions_tg), ' ') ||
758: ': ' ||
759: l_plan_versions ||
760: l_newline);

Line 790: PJI_UTILS.WRITE2OUT(l_only_pt_projects_tg ||

786: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_ONLY_PT_PRJ');
787:
788: l_only_pt_projects_tg := substr(FND_MESSAGE.GET, 1, 30);
789:
790: PJI_UTILS.WRITE2OUT(l_only_pt_projects_tg ||
791: my_pad(30 - length(l_only_pt_projects_tg),
792: ' ') ||
793: ': ' ||
794: l_only_pt_projects ||

Line 853: PJI_UTILS.WRITE2OUT('-----------------------------------------------------------------------------------------------------------------------------------------' ||

849: /* The following projects may have incorrect actuals on workplan pages, please run summarization after rectifying the mentioned exception reason:*/
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) ||

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 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 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 982: -- pji_utils.write2log('In Procedure plan type code changes');

978: order by
979: SUP_LEVEL desc;
980:
981: BEGIN
982: -- pji_utils.write2log('In Procedure plan type code changes');
983:
984: select count(bmap.project_id) into l_count
985: from PA_PJI_PROJ_EVENTS_LOG elog,
986: PJI_PJP_PROJ_BATCH_MAP bmap

Line 991: -- pji_utils.write2log('plan_type_code changes exist count'||l_count);

987: where elog.event_object = to_char(bmap.project_id)
988: and elog.event_type = 'PLANTYPE_UPG'
989: and bmap.worker_id = p_worker_id;
990:
991: -- pji_utils.write2log('plan_type_code changes exist count'||l_count);
992:
993: if l_count > 0 then
994:
995: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;

Line 1092: -- pji_utils.write2log('Inserted +ve records into ver4'||sql%rowcount);

1088: OR (bv.current_flag||DECODE(bv.baselined_date, NULL, 'N', 'Y')) = 'YY')
1089: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
1090: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE'));
1091:
1092: -- pji_utils.write2log('Inserted +ve records into ver4'||sql%rowcount);
1093: -- This sql will insert all the -3,-4 plan versions for Cost and Rev seperate plan_type_id
1094:
1095: INSERT INTO PJI_FM_EXTR_PLNVER4
1096: (

Line 1148: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);

1144: AND den.struct_type = 'PRG'
1145: AND den.sub_id = bv.wbs_struct_version_id
1146: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1147:
1148: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1149: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1150: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1151:
1152: DELETE pji_rollup_level_status hdr

Line 1175: -- pji_utils.write2log('Inserting all the positive plan version data into the PJP1 table for futher ');

1171: -- Inserting all the positive plan version data into the PJP1 table for futher
1172: -- creation of wbs_rollup_flag = 'Y' lines and
1173: -- prg_rollup_flag = 'Y' lines if required
1174: -- Commit;
1175: -- pji_utils.write2log('Inserting all the positive plan version data into the PJP1 table for futher ');
1176:
1177: INSERT INTO PJI_FP_AGGR_PJP1
1178: (
1179: WORKER_ID

Line 1348: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);

1344: AND f.wbs_rollup_flag = 'N'
1345: AND f.prg_rollup_flag = 'N'
1346: AND ver.worker_id = p_worker_id;
1347:
1348: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1349: -- for -3,-4 lines having prg_rollup_flag = 'N'
1350: -- pji_utils.write2log('Before rollup_fpr_wbs');
1351:
1352: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);

Line 1350: -- pji_utils.write2log('Before rollup_fpr_wbs');

1346: AND ver.worker_id = p_worker_id;
1347:
1348: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1349: -- for -3,-4 lines having prg_rollup_flag = 'N'
1350: -- pji_utils.write2log('Before rollup_fpr_wbs');
1351:
1352: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);
1353: for c in C_BOTTOM_UP loop
1354:

Line 1357: -- pji_utils.write2log('In loop of rollup_fpr_wbs'||l_level);

1353: for c in C_BOTTOM_UP loop
1354:
1355: l_level := c.SUP_LEVEL;
1356:
1357: -- pji_utils.write2log('In loop of rollup_fpr_wbs'||l_level);
1358: -- rollup project hiearchy
1359:
1360: insert into PJI_FP_AGGR_PJP1
1361: (

Line 2436: -- pji_utils.write2log('After Rollup_fpr_wbs');

2432:
2433: end loop;
2434:
2435:
2436: -- pji_utils.write2log('After Rollup_fpr_wbs');
2437:
2438: --below call is required for updating
2439: --the date columns on the wbs header
2440:

Line 2469: -- pji_utils.write2log('Updated records in wbs_header'||sql%rowcount);

2465: and ver.project_id = whdr.project_id
2466: and ver.plan_version_id = whdr.plan_version_id
2467: and ver.plan_type_id = whdr.plan_type_id);
2468:
2469: -- pji_utils.write2log('Updated records in wbs_header'||sql%rowcount);
2470:
2471:
2472: INSERT INTO pji_fp_xbs_accum_f fact
2473: (

Line 2704: -- pji_utils.write2log('Inserted records into fact'||sql%rowcount);

2700: AND tmp.plan_version_id in (-3, -4)
2701: AND tmp.worker_id = p_worker_id
2702: );
2703:
2704: -- pji_utils.write2log('Inserted records into fact'||sql%rowcount);
2705:
2706: DELETE pa_pji_proj_events_log log
2707: where log.event_type = 'PLANTYPE_UPG'
2708: and exists (select 1 from pji_fm_extr_plnver4 ver

Line 2713: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);

2709: where ver.worker_id = p_worker_id and
2710: to_char(ver.project_id) = log.event_object);
2711:
2712:
2713: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2714:
2715: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2716:
2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);

Line 2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);

2713: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2714:
2715: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2716:
2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2718:
2719: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2720:
2721: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);

Line 2721: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);

2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2718:
2719: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2720:
2721: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2722:
2723: end if;
2724:
2725: Begin

Line 2731: PJI_UTILS.SET_PARAMETER ('PJI_PTC_UPGRADE', 'C');

2727: where exists ( select event_type
2728: from PA_PJI_PROJ_EVENTS_LOG elog
2729: where elog.event_type = 'PLANTYPE_UPG');
2730: exception when NO_DATA_FOUND then
2731: PJI_UTILS.SET_PARAMETER ('PJI_PTC_UPGRADE', 'C');
2732: end;
2733:
2734: --dbms_output.put_line('Script end time..'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
2735: /* End of processing for all -3,-4 plans with plan_type=COST_AND_REV_SEP */

Line 2812: if (PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') = 'P') then

2808:
2809: begin
2810:
2811:
2812: if (PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') = 'P') then
2813: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FPM_UPG_RUN');
2814: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2815: end if;
2816: /*Check for from project and to project based on the run , idea is to recreate the same check which was done thru mandatory parameter*/

Line 2869: if nvl(PJI_UTILS.GET_PARAMETER('PJI_STAGE3_REQ_LUPPD'),'Y') = 'N' then

2865:
2866: if p_from_project like 'UPP-BATCH-%' then -- Bug 14138486 Added if condition
2867: null;
2868: else
2869: if nvl(PJI_UTILS.GET_PARAMETER('PJI_STAGE3_REQ_LUPPD'),'Y') = 'N' then
2870: Select Max(Request_ID)
2871: Into l_req_id1
2872: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c
2873: Where a.Program_Application_ID = P.Application_ID

Line 3833: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then

3829: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3830: (l_process, 'PROJECT_STATUS',NVL(p_project_status,'PJI$NULL'));
3831:
3832:
3833: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
3834: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3835: 'PA_CALENDAR_FLAG',
3836: 'N');
3837: else

Line 3843: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then

3839: 'PA_CALENDAR_FLAG',
3840: 'Y');
3841: end if;
3842:
3843: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
3844: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3845: 'GL_CALENDAR_FLAG',
3846: 'N');
3847: else

Line 3910: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

3906:
3907: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3908:
3909: -- implicit commit
3910: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3911: tabname => 'PJI_ORG_EXTR_INFO',
3912: percent => 10,
3913: degree => PJI_UTILS.
3914: GET_DEGREE_OF_PARALLELISM);

Line 3913: degree => PJI_UTILS.

3909: -- implicit commit
3910: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3911: tabname => 'PJI_ORG_EXTR_INFO',
3912: percent => 10,
3913: degree => PJI_UTILS.
3914: GET_DEGREE_OF_PARALLELISM);
3915: -- implicit commit
3916: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3917: indname => 'PJI_ORG_EXTR_INFO_N1',

Line 3916: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

3912: percent => 10,
3913: degree => PJI_UTILS.
3914: GET_DEGREE_OF_PARALLELISM);
3915: -- implicit commit
3916: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3917: indname => 'PJI_ORG_EXTR_INFO_N1',
3918: percent => 10);
3919:
3920: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,

Line 3928: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') and l_extraction_type <> 'PARTIAL' then

3924:
3925: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3926:
3927: /* plan type code changes (4882640) This API call will be shifted to step entry */
3928: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') and l_extraction_type <> 'PARTIAL' then
3929: PLAN_TYPE_CODE_CHANGES (p_worker_id);
3930: end if;
3931: /*---------- plan type code changes (4882640) ------------*/
3932:

Line 3960: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

3956: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3957: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3958:
3959: /* Added for bug 8353629 */
3960: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3961: tabname => 'PJI_FP_AGGR_PJP0',
3962: percent => 10,
3963: degree => PJI_UTILS.
3964: GET_DEGREE_OF_PARALLELISM);

Line 3963: degree => PJI_UTILS.

3959: /* Added for bug 8353629 */
3960: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3961: tabname => 'PJI_FP_AGGR_PJP0',
3962: percent => 10,
3963: degree => PJI_UTILS.
3964: GET_DEGREE_OF_PARALLELISM);
3965:
3966: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3967: tabname => 'PJI_PJP_PROJ_BATCH_MAP',

Line 3966: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

3962: percent => 10,
3963: degree => PJI_UTILS.
3964: GET_DEGREE_OF_PARALLELISM);
3965:
3966: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3967: tabname => 'PJI_PJP_PROJ_BATCH_MAP',
3968: percent => 10,
3969: degree => PJI_UTILS.
3970: GET_DEGREE_OF_PARALLELISM);

Line 3969: degree => PJI_UTILS.

3965:
3966: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3967: tabname => 'PJI_PJP_PROJ_BATCH_MAP',
3968: percent => 10,
3969: degree => PJI_UTILS.
3970: GET_DEGREE_OF_PARALLELISM);
3971: /* Added for bug 8353629 */
3972:
3973:

Line 4209: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

4205:
4206:
4207: -- clean up worker tables
4208:
4209: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4210:
4211: if (NVL(l_preload,'N') <> 'Y') then
4212: OUTPUT_ACT_FAILED_RUNS(p_worker_id);
4213: OUTPUT_ACT_PASSED_RUNS(p_worker_id);

Line 4236: PJI_UTILS.SET_PARAMETER('LAST_PJP_EXTR_DATE_' || l_process,

4232: END_DATE is null;
4233:
4234: -- update default report as-of date
4235:
4236: PJI_UTILS.SET_PARAMETER('LAST_PJP_EXTR_DATE_' || l_process,
4237: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
4238:
4239: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);');
4240:

Line 4308: pji_utils.write2log(sqlerrm, true, 0);

4304: END_DATE is null;
4305:
4306: commit;
4307:
4308: pji_utils.write2log(sqlerrm, true, 0);
4309:
4310: commit;
4311:
4312: end WRAPUP_FAILURE;

Line 4355: -- pji_utils.write2log('Error: PJI is not licensed.');

4351:
4352: begin
4353:
4354: -- if (PA_INSTALL.is_pji_licensed = 'N') then
4355: -- pji_utils.write2log('Error: PJI is not licensed.');
4356: -- commit;
4357: -- raise l_pji_not_licensed;
4358: -- end if;
4359: commit;