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 239: PJI_UTILS.WRITE2OUT(l_newline ||

235: begin
236:
237: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NO_SUMM_WORK');
238:
239: PJI_UTILS.WRITE2OUT(l_newline ||
240: l_newline ||
241: FND_MESSAGE.GET ||
242: l_newline);
243:

Line 262: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

258: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');
259:
260: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
261:
262: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
263: my_pad(30 - length(l_project_operating_unit_tg),
264: ' ') ||
265: ': ' ||
266: l_project_operating_unit_name ||

Line 281: PJI_UTILS.WRITE2OUT(l_project_type_tg ||

277: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');
278:
279: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);
280:
281: PJI_UTILS.WRITE2OUT(l_project_type_tg ||
282: my_pad(30 - length(l_project_type_tg), ' ') ||
283: ': ' ||
284: l_project_type ||
285: l_newline);

Line 305: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||

301: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');
302:
303: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);
304:
305: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||
306: my_pad(30 - length(l_project_organization_tg),
307: ' ') ||
308: ': ' ||
309: l_project_organization ||

Line 324: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

320: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');
321:
322: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
323:
324: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
325: my_pad(30 - length(l_from_project_tg), ' ') ||
326: ': ' ||
327: l_from_project ||
328: l_newline);

Line 342: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

338: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');
339:
340: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);
341:
342: PJI_UTILS.WRITE2OUT(l_to_project_tg ||
343: my_pad(30 - length(l_to_project_tg), ' ') ||
344: ': ' ||
345: l_to_project ||
346: l_newline);

Line 431: PJI_UTILS.WRITE2OUT(l_newline ||

427: l_header_flag := 'N';
428:
429: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_HEADER');
430:
431: PJI_UTILS.WRITE2OUT(l_newline ||
432: l_newline ||
433: FND_MESSAGE.GET ||
434: l_newline);
435:

Line 440: PJI_UTILS.WRITE2OUT(l_newline ||

436: end if;
437:
438: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_LINE');
439:
440: PJI_UTILS.WRITE2OUT(l_newline ||
441: FND_MESSAGE.GET ||
442: l_newline ||
443: l_newline);
444:

Line 449: PJI_UTILS.WRITE2OUT(l_extraction_type_tg ||

445: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE');
446:
447: l_extraction_type_tg := substr(FND_MESSAGE.GET, 1, 30);
448:
449: PJI_UTILS.WRITE2OUT(l_extraction_type_tg ||
450: my_pad(30 - length(l_extraction_type_tg), ' ') ||
451: ': ');
452:
453: if (l_extraction_type = 'FULL') then

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

467: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');
468:
469: end if;
470:
471: PJI_UTILS.WRITE2OUT(FND_MESSAGE.GET ||
472: l_newline);
473:
474: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
475:

Line 483: PJI_UTILS.WRITE2OUT(l_request_id_tg ||

479: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_REQ_ID');
480:
481: l_request_id_tg := substr(FND_MESSAGE.GET, 1, 30);
482:
483: PJI_UTILS.WRITE2OUT(l_request_id_tg ||
484: my_pad(30 - length(l_request_id_tg),
485: ' ') ||
486: ': ' ||
487: l_request_id ||

Line 515: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

511: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');
512:
513: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
514:
515: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
516: my_pad(30 - length(l_project_operating_unit_tg),
517: ' ') ||
518: ': ' ||
519: l_project_operating_unit_name ||

Line 539: PJI_UTILS.WRITE2OUT(l_project_type_tg ||

535: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');
536:
537: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);
538:
539: PJI_UTILS.WRITE2OUT(l_project_type_tg ||
540: my_pad(30 - length(l_project_type_tg), ' ') ||
541: ': ' ||
542: l_project_type ||
543: l_newline);

Line 569: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||

565: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');
566:
567: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);
568:
569: PJI_UTILS.WRITE2OUT(l_project_organization_tg ||
570: my_pad(30 - length(l_project_organization_tg),
571: ' ') ||
572: ': ' ||
573: l_project_organization ||

Line 593: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

589: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');
590:
591: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
592:
593: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
594: my_pad(30 - length(l_from_project_tg), ' ') ||
595: ': ' ||
596: l_from_project ||
597: l_newline);

Line 616: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

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

Line 646: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||

642: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_TYPE');
643:
644: l_plan_type_tg := substr(FND_MESSAGE.GET, 1, 30);
645:
646: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||
647: my_pad(30 - length(l_plan_type_tg), ' ') ||
648: ': ' ||
649: l_plan_type ||
650: l_newline);

Line 676: PJI_UTILS.WRITE2OUT(l_rbs_header_tg ||

672: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_RBS_HDR');
673:
674: l_rbs_header_tg := substr(FND_MESSAGE.GET, 1, 30);
675:
676: PJI_UTILS.WRITE2OUT(l_rbs_header_tg ||
677: my_pad(30 - length(l_rbs_header_tg), ' ') ||
678: ': ' ||
679: l_rbs_header ||
680: l_newline);

Line 708: PJI_UTILS.WRITE2OUT(l_transaction_type_tg ||

704: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TXN_TYPE');
705:
706: l_transaction_type_tg := substr(FND_MESSAGE.GET, 1, 30);
707:
708: PJI_UTILS.WRITE2OUT(l_transaction_type_tg ||
709: my_pad(30 - length(l_transaction_type_tg), ' ') ||
710: ': ' ||
711: l_transaction_type ||
712: l_newline);

Line 733: PJI_UTILS.WRITE2OUT(l_plan_versions_tg ||

729: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_VER');
730:
731: l_plan_versions_tg := substr(FND_MESSAGE.GET, 1, 30);
732:
733: PJI_UTILS.WRITE2OUT(l_plan_versions_tg ||
734: my_pad(30 - length(l_plan_versions_tg), ' ') ||
735: ': ' ||
736: l_plan_versions ||
737: l_newline);

Line 767: PJI_UTILS.WRITE2OUT(l_only_pt_projects_tg ||

763: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_ONLY_PT_PRJ');
764:
765: l_only_pt_projects_tg := substr(FND_MESSAGE.GET, 1, 30);
766:
767: PJI_UTILS.WRITE2OUT(l_only_pt_projects_tg ||
768: my_pad(30 - length(l_only_pt_projects_tg),
769: ' ') ||
770: ': ' ||
771: l_only_pt_projects ||

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

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

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

955: order by
956: SUP_LEVEL desc;
957:
958: BEGIN
959: -- pji_utils.write2log('In Procedure plan type code changes');
960:
961: select count(bmap.project_id) into l_count
962: from PA_PJI_PROJ_EVENTS_LOG elog,
963: PJI_PJP_PROJ_BATCH_MAP bmap

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

964: where elog.event_object = to_char(bmap.project_id)
965: and elog.event_type = 'PLANTYPE_UPG'
966: and bmap.worker_id = p_worker_id;
967:
968: -- pji_utils.write2log('plan_type_code changes exist count'||l_count);
969:
970: if l_count > 0 then
971:
972: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;

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

1065: OR (bv.current_flag||DECODE(bv.baselined_date, NULL, 'N', 'Y')) = 'YY')
1066: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
1067: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE'));
1068:
1069: -- pji_utils.write2log('Inserted +ve records into ver4'||sql%rowcount);
1070: -- This sql will insert all the -3,-4 plan versions for Cost and Rev seperate plan_type_id
1071:
1072: INSERT INTO PJI_FM_EXTR_PLNVER4
1073: (

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

1121: AND den.struct_type = 'PRG'
1122: AND den.sub_id = bv.wbs_struct_version_id
1123: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1124:
1125: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1126: -- 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
1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1128:
1129: DELETE pji_rollup_level_status hdr

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

1148: -- Inserting all the positive plan version data into the PJP1 table for futher
1149: -- creation of wbs_rollup_flag = 'Y' lines and
1150: -- prg_rollup_flag = 'Y' lines if required
1151: -- Commit;
1152: -- pji_utils.write2log('Inserting all the positive plan version data into the PJP1 table for futher ');
1153:
1154: INSERT INTO PJI_FP_AGGR_PJP1
1155: (
1156: WORKER_ID

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

1321: AND f.wbs_rollup_flag = 'N'
1322: AND f.prg_rollup_flag = 'N'
1323: AND ver.worker_id = p_worker_id;
1324:
1325: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1326: -- for -3,-4 lines having prg_rollup_flag = 'N'
1327: -- pji_utils.write2log('Before rollup_fpr_wbs');
1328:
1329: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);

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

1323: AND ver.worker_id = p_worker_id;
1324:
1325: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1326: -- for -3,-4 lines having prg_rollup_flag = 'N'
1327: -- pji_utils.write2log('Before rollup_fpr_wbs');
1328:
1329: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);
1330: for c in C_BOTTOM_UP loop
1331:

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

1330: for c in C_BOTTOM_UP loop
1331:
1332: l_level := c.SUP_LEVEL;
1333:
1334: -- pji_utils.write2log('In loop of rollup_fpr_wbs'||l_level);
1335: -- rollup project hiearchy
1336:
1337: insert into PJI_FP_AGGR_PJP1
1338: (

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

2409:
2410: end loop;
2411:
2412:
2413: -- pji_utils.write2log('After Rollup_fpr_wbs');
2414:
2415: --below call is required for updating
2416: --the date columns on the wbs header
2417:

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

2442: and ver.project_id = whdr.project_id
2443: and ver.plan_version_id = whdr.plan_version_id
2444: and ver.plan_type_id = whdr.plan_type_id);
2445:
2446: -- pji_utils.write2log('Updated records in wbs_header'||sql%rowcount);
2447:
2448:
2449: INSERT INTO pji_fp_xbs_accum_f fact
2450: (

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

2677: AND tmp.plan_version_id in (-3, -4)
2678: AND tmp.worker_id = p_worker_id
2679: );
2680:
2681: -- pji_utils.write2log('Inserted records into fact'||sql%rowcount);
2682:
2683: DELETE pa_pji_proj_events_log log
2684: where log.event_type = 'PLANTYPE_UPG'
2685: and exists (select 1 from pji_fm_extr_plnver4 ver

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

2686: where ver.worker_id = p_worker_id and
2687: to_char(ver.project_id) = log.event_object);
2688:
2689:
2690: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2691:
2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2693:
2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);

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

2690: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2691:
2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2693:
2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2697:
2698: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);

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

2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2697:
2698: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2699:
2700: end if;
2701:
2702: Begin

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

2704: where exists ( select event_type
2705: from PA_PJI_PROJ_EVENTS_LOG elog
2706: where elog.event_type = 'PLANTYPE_UPG');
2707: exception when NO_DATA_FOUND then
2708: PJI_UTILS.SET_PARAMETER ('PJI_PTC_UPGRADE', 'C');
2709: end;
2710:
2711: --dbms_output.put_line('Script end time..'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
2712: /* End of processing for all -3,-4 plans with plan_type=COST_AND_REV_SEP */

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

2778: prog_name_table SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2779: begin
2780:
2781:
2782: if (PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') = 'P') then
2783: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FPM_UPG_RUN');
2784: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2785: end if;
2786: /*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 3631: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then

3627: (l_process,
3628: 'PLAN_VERSION', nvl(p_plan_versions, 'PJI$NULL'));
3629:
3630:
3631: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
3632: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3633: 'PA_CALENDAR_FLAG',
3634: 'N');
3635: else

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

3637: 'PA_CALENDAR_FLAG',
3638: 'Y');
3639: end if;
3640:
3641: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
3642: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3643: 'GL_CALENDAR_FLAG',
3644: 'N');
3645: else

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

3700:
3701: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3702:
3703: -- implicit commit
3704: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3705: tabname => 'PJI_ORG_EXTR_INFO',
3706: percent => 10,
3707: degree => PJI_UTILS.
3708: GET_DEGREE_OF_PARALLELISM);

Line 3707: degree => PJI_UTILS.

3703: -- implicit commit
3704: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3705: tabname => 'PJI_ORG_EXTR_INFO',
3706: percent => 10,
3707: degree => PJI_UTILS.
3708: GET_DEGREE_OF_PARALLELISM);
3709: -- implicit commit
3710: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3711: indname => 'PJI_ORG_EXTR_INFO_N1',

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

3706: percent => 10,
3707: degree => PJI_UTILS.
3708: GET_DEGREE_OF_PARALLELISM);
3709: -- implicit commit
3710: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3711: indname => 'PJI_ORG_EXTR_INFO_N1',
3712: percent => 10);
3713:
3714: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,

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

3718:
3719: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3720:
3721: /* plan type code changes (4882640) This API call will be shifted to step entry */
3722: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') and l_extraction_type <> 'PARTIAL' then
3723: PLAN_TYPE_CODE_CHANGES (p_worker_id);
3724: end if;
3725: /*---------- plan type code changes (4882640) ------------*/
3726:

Line 3971: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

3967: end if;
3968:
3969: -- clean up worker tables
3970:
3971: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3972:
3973: if (NVL(l_preload,'N') <> 'Y') then
3974: OUTPUT_ACT_FAILED_RUNS(p_worker_id);
3975: OUTPUT_ACT_PASSED_RUNS(p_worker_id);

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

3994: END_DATE is null;
3995:
3996: -- update default report as-of date
3997:
3998: PJI_UTILS.SET_PARAMETER('LAST_PJP_EXTR_DATE_' || l_process,
3999: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
4000:
4001: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);');
4002:

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

4063: END_DATE is null;
4064:
4065: commit;
4066:
4067: pji_utils.write2log(sqlerrm, true, 0);
4068:
4069: commit;
4070:
4071: end WRAPUP_FAILURE;

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

4109:
4110: begin
4111:
4112: -- if (PA_INSTALL.is_pji_licensed = 'N') then
4113: -- pji_utils.write2log('Error: PJI is not licensed.');
4114: -- commit;
4115: -- raise l_pji_not_licensed;
4116: -- end if;
4117: