DBA Data[Home] [Help]

APPS.MRP_RELEASE_PK dependencies on FND_MESSAGE

Line 214: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');

210: arg_plan_name, arg_org_id, 'Y', 'Y', 'Y', 'N');
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
215: var_buf := fnd_message.get;
216: fnd_file.put_line(FND_FILE.LOG, var_buf);
217:
218: retcode := 2;

Line 215: var_buf := fnd_message.get;

211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
215: var_buf := fnd_message.get;
216: fnd_file.put_line(FND_FILE.LOG, var_buf);
217:
218: retcode := 2;
219: errbuf := var_buf;

Line 526: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');

522:
523: var_buf := '................. ';
524: fnd_file.put_line(FND_FILE.LOG, var_buf);
525:
526: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
527: var_buf := fnd_message.get;
528: fnd_file.put_line(FND_FILE.LOG, var_buf);
529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');

Line 527: var_buf := fnd_message.get;

523: var_buf := '................. ';
524: fnd_file.put_line(FND_FILE.LOG, var_buf);
525:
526: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
527: var_buf := fnd_message.get;
528: fnd_file.put_line(FND_FILE.LOG, var_buf);
529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);

Line 530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');

526: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
527: var_buf := fnd_message.get;
528: fnd_file.put_line(FND_FILE.LOG, var_buf);
529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));

Line 531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);

527: var_buf := fnd_message.get;
528: fnd_file.put_line(FND_FILE.LOG, var_buf);
529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));

Line 532: fnd_message.set_token('ORG_VALUE', var_org_code);

528: fnd_file.put_line(FND_FILE.LOG, var_buf);
529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
536: var_buf := fnd_message.get;

Line 533: fnd_message.set_token('ITEM_VALUE', var_item);

529:
530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
536: var_buf := fnd_message.get;
537: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));

530: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
536: var_buf := fnd_message.get;
537: fnd_file.put_line(FND_FILE.LOG, var_buf);
538:

Line 535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));

531: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
536: var_buf := fnd_message.get;
537: fnd_file.put_line(FND_FILE.LOG, var_buf);
538:
539: ELSE

Line 536: var_buf := fnd_message.get;

532: fnd_message.set_token('ORG_VALUE', var_org_code);
533: fnd_message.set_token('ITEM_VALUE', var_item);
534: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
535: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
536: var_buf := fnd_message.get;
537: fnd_file.put_line(FND_FILE.LOG, var_buf);
538:
539: ELSE
540:

Line 595: fnd_message.set_name('MRP', 'LOADED_WIP');

591:
592: var_buf := '+++++++++++++++++ ';
593: fnd_file.put_line(FND_FILE.LOG, var_buf);
594:
595: fnd_message.set_name('MRP', 'LOADED_WIP');
596: fnd_message.set_token('VALUE', to_char(var_loaded_jobs));
597: var_buf := fnd_message.get;
598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:

Line 596: fnd_message.set_token('VALUE', to_char(var_loaded_jobs));

592: var_buf := '+++++++++++++++++ ';
593: fnd_file.put_line(FND_FILE.LOG, var_buf);
594:
595: fnd_message.set_name('MRP', 'LOADED_WIP');
596: fnd_message.set_token('VALUE', to_char(var_loaded_jobs));
597: var_buf := fnd_message.get;
598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:
600: fnd_message.set_name('MRP', 'LOADED_PO');

Line 597: var_buf := fnd_message.get;

593: fnd_file.put_line(FND_FILE.LOG, var_buf);
594:
595: fnd_message.set_name('MRP', 'LOADED_WIP');
596: fnd_message.set_token('VALUE', to_char(var_loaded_jobs));
597: var_buf := fnd_message.get;
598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:
600: fnd_message.set_name('MRP', 'LOADED_PO');
601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));

Line 600: fnd_message.set_name('MRP', 'LOADED_PO');

596: fnd_message.set_token('VALUE', to_char(var_loaded_jobs));
597: var_buf := fnd_message.get;
598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:
600: fnd_message.set_name('MRP', 'LOADED_PO');
601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));
602: var_buf := fnd_message.get;
603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:

Line 601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));

597: var_buf := fnd_message.get;
598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:
600: fnd_message.set_name('MRP', 'LOADED_PO');
601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));
602: var_buf := fnd_message.get;
603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:
605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');

Line 602: var_buf := fnd_message.get;

598: fnd_file.put_line(FND_FILE.LOG, var_buf);
599:
600: fnd_message.set_name('MRP', 'LOADED_PO');
601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));
602: var_buf := fnd_message.get;
603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:
605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));

Line 605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');

601: fnd_message.set_token('VALUE', to_char(var_loaded_reqs));
602: var_buf := fnd_message.get;
603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:
605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));
607: var_buf := fnd_message.get;
608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:

Line 606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));

602: var_buf := fnd_message.get;
603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:
605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));
607: var_buf := fnd_message.get;
608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:
610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');

Line 607: var_buf := fnd_message.get;

603: fnd_file.put_line(FND_FILE.LOG, var_buf);
604:
605: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));
607: var_buf := fnd_message.get;
608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:
610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
611: fnd_message.set_token('VALUE', to_char(var_req_load_id));

Line 610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');

606: fnd_message.set_token('VALUE', to_char(var_wip_req_id));
607: var_buf := fnd_message.get;
608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:
610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
611: fnd_message.set_token('VALUE', to_char(var_req_load_id));
612: var_buf := fnd_message.get;
613: fnd_file.put_line(FND_FILE.LOG, var_buf);
614:

Line 611: fnd_message.set_token('VALUE', to_char(var_req_load_id));

607: var_buf := fnd_message.get;
608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:
610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
611: fnd_message.set_token('VALUE', to_char(var_req_load_id));
612: var_buf := fnd_message.get;
613: fnd_file.put_line(FND_FILE.LOG, var_buf);
614:
615: IF ((var_loaded_jobs > 0) AND (var_wip_req_id = 0)) THEN

Line 612: var_buf := fnd_message.get;

608: fnd_file.put_line(FND_FILE.LOG, var_buf);
609:
610: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
611: fnd_message.set_token('VALUE', to_char(var_req_load_id));
612: var_buf := fnd_message.get;
613: fnd_file.put_line(FND_FILE.LOG, var_buf);
614:
615: IF ((var_loaded_jobs > 0) AND (var_wip_req_id = 0)) THEN
616: fnd_file.new_line(FND_FILE.LOG, 1);

Line 617: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');

613: fnd_file.put_line(FND_FILE.LOG, var_buf);
614:
615: IF ((var_loaded_jobs > 0) AND (var_wip_req_id = 0)) THEN
616: fnd_file.new_line(FND_FILE.LOG, 1);
617: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
618: var_buf := fnd_message.get;
619: fnd_file.put_line(FND_FILE.LOG, var_buf);
620:
621: retcode := 2;

Line 618: var_buf := fnd_message.get;

614:
615: IF ((var_loaded_jobs > 0) AND (var_wip_req_id = 0)) THEN
616: fnd_file.new_line(FND_FILE.LOG, 1);
617: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
618: var_buf := fnd_message.get;
619: fnd_file.put_line(FND_FILE.LOG, var_buf);
620:
621: retcode := 2;
622: errbuf := var_buf;

Line 627: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');

623: END IF;
624:
625: IF ((var_loaded_reqs > 0) AND (var_req_load_id = 0)) THEN
626: fnd_file.new_line(FND_FILE.LOG, 1);
627: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
628: var_buf := fnd_message.get;
629: fnd_file.put_line(FND_FILE.LOG, var_buf);
630:
631: retcode := 2;

Line 628: var_buf := fnd_message.get;

624:
625: IF ((var_loaded_reqs > 0) AND (var_req_load_id = 0)) THEN
626: fnd_file.new_line(FND_FILE.LOG, 1);
627: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
628: var_buf := fnd_message.get;
629: fnd_file.put_line(FND_FILE.LOG, var_buf);
630:
631: retcode := 2;
632: errbuf := var_buf;