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_MESSAGE

Line 242: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NO_SUMM_WORK');

238:
239:
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 ||

Line 246: FND_MESSAGE.GET ||

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:
249: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
250:

Line 249: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');

245: l_newline ||
246: FND_MESSAGE.GET ||
247: l_newline);
248:
249: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
250:
251: l_no_selection := FND_MESSAGE.GET;
252:
253:

Line 251: l_no_selection := FND_MESSAGE.GET;

247: l_newline);
248:
249: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
250:
251: l_no_selection := FND_MESSAGE.GET;
252:
253:
254: if (nvl(p_operating_unit, -1) = -1) then
255: l_project_operating_unit_name := l_no_selection;

Line 263: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');

259: from HR_OPERATING_UNITS
260: where ORGANIZATION_ID = p_operating_unit;
261: end if;
262:
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 ||

Line 265: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);

261: end if;
262:
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: ' ') ||

Line 282: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');

278: else
279: l_project_type := p_project_type;
280: end if;
281:
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 ||

Line 284: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);

280: end if;
281:
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: ': ' ||

Line 299: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_STATUS');

295: else
296: l_project_status := p_project_status;
297: end if;
298:
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 ||

Line 301: l_project_status_tg := substr(FND_MESSAGE.GET, 1, 30);

297: end if;
298:
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: ':' ||

Line 324: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');

320: where ORGANIZATION_ID = p_project_organization_id;
321:
322: end if;
323:
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 ||

Line 326: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);

322: end if;
323:
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: ' ') ||

Line 343: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');

339: else
340: l_from_project := p_from_project;
341: end if;
342:
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 ||

Line 345: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);

341: end if;
342:
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: ': ' ||

Line 361: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');

357: else
358: l_to_project := p_to_project;
359: end if;
360:
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 ||

Line 363: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);

359: end if;
360:
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: ': ' ||

Line 432: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');

428:
429:
430: begin
431:
432: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
433:
434: l_no_selection := FND_MESSAGE.GET;
435:
436: l_header_flag := 'Y';

Line 434: l_no_selection := FND_MESSAGE.GET;

430: begin
431:
432: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
433:
434: l_no_selection := FND_MESSAGE.GET;
435:
436: l_header_flag := 'Y';
437:
438: for x in 1 .. PJI_PJP_SUM_MAIN.g_parallel_processes loop

Line 452: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_HEADER');

448: if (l_header_flag = 'Y') then
449:
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 ||

Line 456: FND_MESSAGE.GET ||

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:
459: end if;
460:

Line 461: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_LINE');

457: l_newline);
458:
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 ||

Line 464: FND_MESSAGE.GET ||

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:
468: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE');

Line 468: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE');

464: FND_MESSAGE.GET ||
465: l_newline ||
466: l_newline);
467:
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 ||

Line 470: l_extraction_type_tg := substr(FND_MESSAGE.GET, 1, 30);

466: l_newline);
467:
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: ': ');

Line 478: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_FULL');

474: ': ');
475:
476: if (l_extraction_type = 'FULL') then
477:
478: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_FULL');
479:
480: elsif (l_extraction_type = 'INCREMENTAL') then
481:
482: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');

Line 482: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');

478: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_FULL');
479:
480: elsif (l_extraction_type = 'INCREMENTAL') then
481:
482: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');
483:
484: elsif (l_extraction_type = 'PARTIAL') then
485:
486: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');

Line 486: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');

482: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');
483:
484: elsif (l_extraction_type = 'PARTIAL') then
485:
486: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');
487:
488: elsif (l_extraction_type = 'RBS') then
489:
490: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');

Line 490: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');

486: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');
487:
488: elsif (l_extraction_type = 'RBS') then
489:
490: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');
491:
492: end if;
493:
494: PJI_UTILS.WRITE2OUT(FND_MESSAGE.GET ||

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 502: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_REQ_ID');

498:
499: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
500: (l_process, l_process);
501:
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 ||

Line 504: l_request_id_tg := substr(FND_MESSAGE.GET, 1, 30);

500: (l_process, l_process);
501:
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: ' ') ||

Line 534: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');

530: where ORGANIZATION_ID = l_project_operating_unit;
531:
532: end if;
533:
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 ||

Line 536: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);

532: end if;
533:
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: ' ') ||

Line 558: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_TYPE');

554: l_project_type := l_no_selection;
555:
556: end if;
557:
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 ||

Line 560: l_project_type_tg := substr(FND_MESSAGE.GET, 1, 30);

556: end if;
557:
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: ': ' ||

Line 588: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_ORG');

584: where ORGANIZATION_ID = l_project_organization_id;
585:
586: end if;
587:
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 ||

Line 590: l_project_organization_tg := substr(FND_MESSAGE.GET, 1, 30);

586: end if;
587:
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: ' ') ||

Line 612: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');

608: l_from_project := l_no_selection;
609:
610: end if;
611:
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 ||

Line 614: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);

610: end if;
611:
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: ': ' ||

Line 635: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');

631: l_to_project := l_no_selection;
632:
633: end if;
634:
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 ||

Line 637: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);

633: end if;
634:
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: ': ' ||

Line 665: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_TYPE');

661: where FIN_PLAN_TYPE_ID = l_plan_type_id;
662:
663: end if;
664:
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 ||

Line 667: l_plan_type_tg := substr(FND_MESSAGE.GET, 1, 30);

663: end if;
664:
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: ': ' ||

Line 695: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_RBS_HDR');

691: where RBS_HEADER_ID = l_rbs_header_id;
692:
693: end if;
694:
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 ||

Line 697: l_rbs_header_tg := substr(FND_MESSAGE.GET, 1, 30);

693: end if;
694:
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: ': ' ||

Line 727: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TXN_TYPE');

723: from fnd_lookup_values_vl
724: where LOOKUP_TYPE = 'PJI_REF_TXN_TYPE' and
725: LOOKUP_CODE =l_transaction_type_id;
726:
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 ||

Line 729: l_transaction_type_tg := substr(FND_MESSAGE.GET, 1, 30);

725: LOOKUP_CODE =l_transaction_type_id;
726:
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: ': ' ||

Line 752: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_VER');

748: from fnd_lookup_values_vl
749: where LOOKUP_TYPE = 'PJI_REF_PLAN_VERSION' and
750: LOOKUP_CODE =l_plan_versions_id;
751:
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 ||

Line 754: l_plan_versions_tg := substr(FND_MESSAGE.GET, 1, 30);

750: LOOKUP_CODE =l_plan_versions_id;
751:
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: ': ' ||

Line 786: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_ONLY_PT_PRJ');

782: LOOKUP_CODE = l_only_pt_projects;
783:
784: end if;
785:
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 ||

Line 788: l_only_pt_projects_tg := substr(FND_MESSAGE.GET, 1, 30);

784: end if;
785:
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: ' ') ||

Line 841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');

837: g_retcode := 1;
838: END IF;
839: close c_err_report;
840: IF l_report_exists ='Y' THEN
841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');

Line 842: l_rpt_header := FND_MESSAGE.GET;

838: END IF;
839: close c_err_report;
840: IF l_report_exists ='Y' THEN
841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;

Line 843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');

839: close c_err_report;
840: IF l_report_exists ='Y' THEN
841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');

Line 844: l_rpt_info := FND_MESSAGE.GET;

840: IF l_report_exists ='Y' THEN
841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;

Line 845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');

841: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;
849: /* The following projects may have incorrect actuals on workplan pages, please run summarization after rectifying the mentioned exception reason:*/

Line 846: l_proj_number := FND_MESSAGE.GET;

842: l_rpt_header := FND_MESSAGE.GET;
843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;
849: /* The following projects may have incorrect actuals on workplan pages, please run summarization after rectifying the mentioned exception reason:*/
850:

Line 847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');

843: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;
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');

Line 848: l_rpt_excep_reason := FND_MESSAGE.GET;

844: l_rpt_info := FND_MESSAGE.GET;
845: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
846: l_proj_number := FND_MESSAGE.GET;
847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;
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;

Line 851: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');

847: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
848: l_rpt_excep_reason := FND_MESSAGE.GET;
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:

Line 852: l_rpt_footer := FND_MESSAGE.GET;

848: l_rpt_excep_reason := FND_MESSAGE.GET;
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:

Line 913: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');

909: END IF;
910: close c_err_report;
911:
912: IF l_report_exists ='Y' THEN
913: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
914: l_rpt_header := FND_MESSAGE.GET;
915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:

Line 914: l_rpt_header := FND_MESSAGE.GET;

910: close c_err_report;
911:
912: IF l_report_exists ='Y' THEN
913: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
914: l_rpt_header := FND_MESSAGE.GET;
915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');

Line 915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');

911:
912: IF l_report_exists ='Y' THEN
913: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
914: l_rpt_header := FND_MESSAGE.GET;
915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
919: l_proj_name := FND_MESSAGE.GET;

Line 916: l_proj_number := FND_MESSAGE.GET;

912: IF l_report_exists ='Y' THEN
913: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
914: l_rpt_header := FND_MESSAGE.GET;
915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
919: l_proj_name := FND_MESSAGE.GET;
920: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');

Line 918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');

914: l_rpt_header := FND_MESSAGE.GET;
915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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:

Line 919: l_proj_name := FND_MESSAGE.GET;

915: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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) ||

Line 920: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');

916: l_proj_number := FND_MESSAGE.GET;
917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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: '-----------------------------------------------------------------------------------------------------------------------------------------' );

Line 921: l_rpt_footer := FND_MESSAGE.GET;

917:
918: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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:

Line 2813: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FPM_UPG_RUN');

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*/
2817: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and

Line 2814: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);

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*/
2817: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2818: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then

Line 2819: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');

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*/
2817: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2818: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then
2819: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
2820: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2821: end if;
2822:
2823:

Line 2820: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);

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*/
2817: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2818: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then
2819: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
2820: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2821: end if;
2822:
2823:
2824: if p_from_project > p_to_project then

Line 2825: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');

2821: end if;
2822:
2823:
2824: if p_from_project > p_to_project then
2825: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
2826: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
2827: end if;
2828:
2829: IF p_from_project is not null

Line 2826: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);

2822:
2823:
2824: if p_from_project > p_to_project then
2825: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
2826: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
2827: end if;
2828:
2829: IF p_from_project is not null
2830: or p_to_project is not null then

Line 2862: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');

2858: from
2859: PJI_SYSTEM_SETTINGS;
2860:
2861: if (l_settings_proj_perf_flag = 'N') then
2862: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2863: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2864: end if;
2865:
2866: if p_from_project like 'UPP-BATCH-%' then -- Bug 14138486 Added if condition

Line 2863: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);

2859: PJI_SYSTEM_SETTINGS;
2860:
2861: if (l_settings_proj_perf_flag = 'N') then
2862: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2863: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2864: end if;
2865:
2866: if p_from_project like 'UPP-BATCH-%' then -- Bug 14138486 Added if condition
2867: null;

Line 2899: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');

2895: 'PJI_PJP_LAUNCH_RPP_PRG') )
2896:
2897:
2898: THEN
2899: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2900: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2901: end if;
2902: end if;
2903: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

Line 2900: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);

2896:
2897:
2898: THEN
2899: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2900: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2901: end if;
2902: end if;
2903: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
2904: end if;

Line 3031: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');

3027: -- elsif (p_worker_id = 0) then
3028: if (p_worker_id = 0) then
3029: rollback;
3030: OUTPUT_FAILED_RUNS;
3031: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
3032: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);
3033: end if;
3034:
3035: l_process := g_process || p_worker_id;

Line 3032: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);

3028: if (p_worker_id = 0) then
3029: rollback;
3030: OUTPUT_FAILED_RUNS;
3031: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
3032: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);
3033: end if;
3034:
3035: l_process := g_process || p_worker_id;
3036:

Line 3436: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');

3432: p_from_project,
3433: p_to_project,
3434: l_extraction_type,
3435: p_project_status);
3436: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');
3437: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);
3438:
3439: end if;
3440:

Line 3437: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);

3433: p_to_project,
3434: l_extraction_type,
3435: p_project_status);
3436: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');
3437: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);
3438:
3439: end if;
3440:
3441: elsif (l_extraction_type = 'RBS') then

Line 3661: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');

3657:
3658: -- We may want to add, to the error message, the request
3659: -- ID that is causing the program to fail
3660: OUTPUT_FAILED_RUNS;
3661: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3662: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3663:
3664: end if;
3665: end if;

Line 3662: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);

3658: -- We may want to add, to the error message, the request
3659: -- ID that is causing the program to fail
3660: OUTPUT_FAILED_RUNS;
3661: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3662: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3663:
3664: end if;
3665: end if;
3666: end loop;

Line 3668: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');

3664: end if;
3665: end if;
3666: end loop;
3667: -- IF l_rbs_exists ='Y' THEN
3668: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3669: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3670: -- END IF;
3671: INIT_PROCESS(p_worker_id,
3672: p_run_mode,

Line 3669: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);

3665: end if;
3666: end loop;
3667: -- IF l_rbs_exists ='Y' THEN
3668: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3669: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3670: -- END IF;
3671: INIT_PROCESS(p_worker_id,
3672: p_run_mode,
3673: p_operating_unit,