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

233:
234:
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 ||

Line 241: FND_MESSAGE.GET ||

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

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

240: l_newline ||
241: FND_MESSAGE.GET ||
242: l_newline);
243:
244: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
245:
246: l_no_selection := FND_MESSAGE.GET;
247:
248:

Line 246: l_no_selection := FND_MESSAGE.GET;

242: l_newline);
243:
244: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
245:
246: l_no_selection := FND_MESSAGE.GET;
247:
248:
249: if (nvl(p_operating_unit, -1) = -1) then
250: l_project_operating_unit_name := l_no_selection;

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

254: from HR_OPERATING_UNITS
255: where ORGANIZATION_ID = p_operating_unit;
256: end if;
257:
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 ||

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

256: end if;
257:
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: ' ') ||

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

273: else
274: l_project_type := p_project_type;
275: end if;
276:
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 ||

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

275: end if;
276:
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: ': ' ||

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

297: where ORGANIZATION_ID = p_project_organization_id;
298:
299: end if;
300:
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 ||

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

299: end if;
300:
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: ' ') ||

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

316: else
317: l_from_project := p_from_project;
318: end if;
319:
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 ||

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

318: end if;
319:
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: ': ' ||

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

334: else
335: l_to_project := p_to_project;
336: end if;
337:
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 ||

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

336: end if;
337:
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: ': ' ||

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

405:
406:
407: begin
408:
409: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
410:
411: l_no_selection := FND_MESSAGE.GET;
412:
413: l_header_flag := 'Y';

Line 411: l_no_selection := FND_MESSAGE.GET;

407: begin
408:
409: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
410:
411: l_no_selection := FND_MESSAGE.GET;
412:
413: l_header_flag := 'Y';
414:
415: for x in 1 .. PJI_PJP_SUM_MAIN.g_parallel_processes loop

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

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

Line 433: FND_MESSAGE.GET ||

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:
436: end if;
437:

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

434: l_newline);
435:
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 ||

Line 441: FND_MESSAGE.GET ||

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

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

441: FND_MESSAGE.GET ||
442: l_newline ||
443: l_newline);
444:
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 ||

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

443: l_newline);
444:
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: ': ');

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

451: ': ');
452:
453: if (l_extraction_type = 'FULL') then
454:
455: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_FULL');
456:
457: elsif (l_extraction_type = 'INCREMENTAL') then
458:
459: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');

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

455: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_FULL');
456:
457: elsif (l_extraction_type = 'INCREMENTAL') then
458:
459: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');
460:
461: elsif (l_extraction_type = 'PARTIAL') then
462:
463: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');

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

459: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_INCR');
460:
461: elsif (l_extraction_type = 'PARTIAL') then
462:
463: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');
464:
465: elsif (l_extraction_type = 'RBS') then
466:
467: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');

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

463: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_PRTL');
464:
465: elsif (l_extraction_type = 'RBS') then
466:
467: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_EXTR_TYPE_RBS');
468:
469: end if;
470:
471: PJI_UTILS.WRITE2OUT(FND_MESSAGE.GET ||

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

475:
476: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
477: (l_process, l_process);
478:
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 ||

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

477: (l_process, l_process);
478:
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: ' ') ||

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

507: where ORGANIZATION_ID = l_project_operating_unit;
508:
509: end if;
510:
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 ||

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

509: end if;
510:
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: ' ') ||

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

531: l_project_type := l_no_selection;
532:
533: end if;
534:
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 ||

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

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

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

561: where ORGANIZATION_ID = l_project_organization_id;
562:
563: end if;
564:
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 ||

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

563: end if;
564:
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: ' ') ||

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

585: l_from_project := l_no_selection;
586:
587: end if;
588:
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 ||

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

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

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

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

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

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

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

638: where FIN_PLAN_TYPE_ID = l_plan_type_id;
639:
640: end if;
641:
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 ||

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

640: end if;
641:
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: ': ' ||

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

668: where RBS_HEADER_ID = l_rbs_header_id;
669:
670: end if;
671:
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 ||

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

670: end if;
671:
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: ': ' ||

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

700: from fnd_lookup_values_vl
701: where LOOKUP_TYPE = 'PJI_REF_TXN_TYPE' and
702: LOOKUP_CODE =l_transaction_type_id;
703:
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 ||

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

702: LOOKUP_CODE =l_transaction_type_id;
703:
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: ': ' ||

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

725: from fnd_lookup_values_vl
726: where LOOKUP_TYPE = 'PJI_REF_PLAN_VERSION' and
727: LOOKUP_CODE =l_plan_versions_id;
728:
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 ||

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

727: LOOKUP_CODE =l_plan_versions_id;
728:
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: ': ' ||

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

759: LOOKUP_CODE = l_only_pt_projects;
760:
761: end if;
762:
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 ||

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

761: end if;
762:
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: ' ') ||

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

814: g_retcode := 1;
815: END IF;
816: close c_err_report;
817: IF l_report_exists ='Y' THEN
818: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');

Line 819: l_rpt_header := FND_MESSAGE.GET;

815: END IF;
816: close c_err_report;
817: IF l_report_exists ='Y' THEN
818: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;

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

816: close c_err_report;
817: IF l_report_exists ='Y' THEN
818: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');

Line 821: l_rpt_info := FND_MESSAGE.GET;

817: IF l_report_exists ='Y' THEN
818: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
825: l_rpt_excep_reason := FND_MESSAGE.GET;

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

818: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_HEADER');
819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
825: l_rpt_excep_reason := FND_MESSAGE.GET;
826: /* The following projects may have incorrect actuals on workplan pages, please run summarization after rectifying the mentioned exception reason:*/

Line 823: l_proj_number := FND_MESSAGE.GET;

819: l_rpt_header := FND_MESSAGE.GET;
820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
825: l_rpt_excep_reason := FND_MESSAGE.GET;
826: /* The following projects may have incorrect actuals on workplan pages, please run summarization after rectifying the mentioned exception reason:*/
827:

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

820: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FAILED_RPT_INFO');
821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
825: l_rpt_excep_reason := FND_MESSAGE.GET;
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');

Line 825: l_rpt_excep_reason := FND_MESSAGE.GET;

821: l_rpt_info := FND_MESSAGE.GET;
822: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
823: l_proj_number := FND_MESSAGE.GET;
824: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_EXCEPTION_REASON');
825: l_rpt_excep_reason := FND_MESSAGE.GET;
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;

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

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

Line 829: l_rpt_footer := FND_MESSAGE.GET;

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

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

886: END IF;
887: close c_err_report;
888:
889: IF l_report_exists ='Y' THEN
890: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
891: l_rpt_header := FND_MESSAGE.GET;
892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:

Line 891: l_rpt_header := FND_MESSAGE.GET;

887: close c_err_report;
888:
889: IF l_report_exists ='Y' THEN
890: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
891: l_rpt_header := FND_MESSAGE.GET;
892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');

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

888:
889: IF l_report_exists ='Y' THEN
890: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
891: l_rpt_header := FND_MESSAGE.GET;
892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
896: l_proj_name := FND_MESSAGE.GET;

Line 893: l_proj_number := FND_MESSAGE.GET;

889: IF l_report_exists ='Y' THEN
890: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_PASSED_RPT_HEADER');
891: l_rpt_header := FND_MESSAGE.GET;
892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
896: l_proj_name := FND_MESSAGE.GET;
897: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_RPT_FOOTER');

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

891: l_rpt_header := FND_MESSAGE.GET;
892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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:

Line 896: l_proj_name := FND_MESSAGE.GET;

892: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NUMBER');
893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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) ||

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

893: l_proj_number := FND_MESSAGE.GET;
894:
895: FND_MESSAGE.SET_NAME('PA', 'PA_XC_PROJECT_NAME');
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: '-----------------------------------------------------------------------------------------------------------------------------------------' );

Line 898: l_rpt_footer := FND_MESSAGE.GET;

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

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

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

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

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

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

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*/
2787: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2788: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then
2789: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
2790: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2791: end if;
2792:
2793: if p_from_project > p_to_project then

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

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*/
2787: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2788: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then
2789: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
2790: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2791: end if;
2792:
2793: if p_from_project > p_to_project then
2794: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');

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

2790: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2791: end if;
2792:
2793: if p_from_project > p_to_project then
2794: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
2795: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
2796: end if;
2797:
2798: IF p_from_project is not null

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

2791: end if;
2792:
2793: if p_from_project > p_to_project then
2794: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
2795: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
2796: end if;
2797:
2798: IF p_from_project is not null
2799: or p_to_project is not null then

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

2827: from
2828: PJI_SYSTEM_SETTINGS;
2829:
2830: if (l_settings_proj_perf_flag = 'N') then
2831: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2832: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2833: end if;
2834:
2835: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

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

2828: PJI_SYSTEM_SETTINGS;
2829:
2830: if (l_settings_proj_perf_flag = 'N') then
2831: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2832: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2833: end if;
2834:
2835: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
2836:

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

2952: -- elsif (p_worker_id = 0) then
2953: if (p_worker_id = 0) then
2954: rollback;
2955: OUTPUT_FAILED_RUNS;
2956: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2957: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);
2958: end if;
2959:
2960: l_process := g_process || p_worker_id;

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

2953: if (p_worker_id = 0) then
2954: rollback;
2955: OUTPUT_FAILED_RUNS;
2956: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2957: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);
2958: end if;
2959:
2960: l_process := g_process || p_worker_id;
2961:

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

3288: p_project_type,
3289: p_from_project,
3290: p_to_project,
3291: l_extraction_type);
3292: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');
3293: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);
3294:
3295: end if;
3296:

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

3289: p_from_project,
3290: p_to_project,
3291: l_extraction_type);
3292: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');
3293: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);
3294:
3295: end if;
3296:
3297: elsif (l_extraction_type = 'RBS') then

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

3461:
3462: -- We may want to add, to the error message, the request
3463: -- ID that is causing the program to fail
3464: OUTPUT_FAILED_RUNS;
3465: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3466: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3467:
3468: end if;
3469: end if;

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

3462: -- We may want to add, to the error message, the request
3463: -- ID that is causing the program to fail
3464: OUTPUT_FAILED_RUNS;
3465: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3466: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3467:
3468: end if;
3469: end if;
3470: end loop;

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

3468: end if;
3469: end if;
3470: end loop;
3471: -- IF l_rbs_exists ='Y' THEN
3472: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3473: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3474: -- END IF;
3475: INIT_PROCESS(p_worker_id,
3476: p_run_mode,

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

3469: end if;
3470: end loop;
3471: -- IF l_rbs_exists ='Y' THEN
3472: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3473: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3474: -- END IF;
3475: INIT_PROCESS(p_worker_id,
3476: p_run_mode,
3477: p_operating_unit,