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