659: ||' WHERE mar.ALLOW_RELEASE_FLAG = 1 ';
660:
661: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
662:
663: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
664: fnd_message.set_token('A2M_DBLINK',v_dblink);
665: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
666: var_buf:= fnd_message.get;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
660:
661: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
662:
663: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
664: fnd_message.set_token('A2M_DBLINK',v_dblink);
665: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
666: var_buf:= fnd_message.get;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668:
661: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
662:
663: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
664: fnd_message.set_token('A2M_DBLINK',v_dblink);
665: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
666: var_buf:= fnd_message.get;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668:
669:
662:
663: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
664: fnd_message.set_token('A2M_DBLINK',v_dblink);
665: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
666: var_buf:= fnd_message.get;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668:
669:
670: retcode := 1;
706:
707: EXCEPTION
708: WHEN OTHERS THEN
709:
710: var_buf:= fnd_message.get;
711: --var_buf:= sqlerrm(sqlcode);
712: fnd_file.put_line(FND_FILE.LOG, var_buf);
713:
714: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
710: var_buf:= fnd_message.get;
711: --var_buf:= sqlerrm(sqlcode);
712: fnd_file.put_line(FND_FILE.LOG, var_buf);
713:
714: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
715: var_buf:= fnd_message.get;
716: fnd_file.put_line(FND_FILE.LOG, var_buf);
717:
718: retcode := 2;
711: --var_buf:= sqlerrm(sqlcode);
712: fnd_file.put_line(FND_FILE.LOG, var_buf);
713:
714: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
715: var_buf:= fnd_message.get;
716: fnd_file.put_line(FND_FILE.LOG, var_buf);
717:
718: retcode := 2;
719: errbuf := var_buf;
1301:
1302: var_buf := '................. ';
1303: fnd_file.put_line(FND_FILE.LOG, var_buf);
1304:
1305: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1302: var_buf := '................. ';
1303: fnd_file.put_line(FND_FILE.LOG, var_buf);
1304:
1305: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1304:
1305: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1305: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1307:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1315:
1308: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1315:
1316: ELSE
1309: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1315:
1316: ELSE
1317:
1310: fnd_message.set_token('ORG_VALUE', var_org_code);
1311: fnd_message.set_token('ITEM_VALUE', var_item);
1312: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1313: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1315:
1316: ELSE
1317:
1318: -- ------------------------------------------------------------------
1532: into lv_instance_code
1533: from msc_apps_instances
1534: where instance_id= var_released_instance_id(i);
1535:
1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1533: from msc_apps_instances
1534: where instance_id= var_released_instance_id(i);
1535:
1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1534: where instance_id= var_released_instance_id(i);
1535:
1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1539:
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1540: fnd_message.set_name('MRP', 'LOADED_WIP');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1543:
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1544: fnd_message.set_name('MRP', 'LOADED_WIP');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1547:
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1548: fnd_message.set_name('MRP', 'LOADED_PO');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1549: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1551:
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1552: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1553: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1555:
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1556: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1559:
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1560: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1561: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1563:
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1570: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1570: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1571:
1572: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1570: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1571:
1572: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1573: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1567:
1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1570: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1571:
1572: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1573: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1574:
1581:
1582: /* Bug 2595278 - added Null condition */
1583: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1584: fnd_file.new_line(FND_FILE.LOG, 1);
1585: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1586: var_buf := fnd_message.get;
1587: fnd_file.put_line(FND_FILE.LOG, var_buf);
1588:
1589: retcode := 2;
1582: /* Bug 2595278 - added Null condition */
1583: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1584: fnd_file.new_line(FND_FILE.LOG, 1);
1585: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1586: var_buf := fnd_message.get;
1587: fnd_file.put_line(FND_FILE.LOG, var_buf);
1588:
1589: retcode := 2;
1590: errbuf := var_buf;
1592:
1593:
1594: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1595: fnd_file.new_line(FND_FILE.LOG, 1);
1596: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1597: var_buf := fnd_message.get;
1598: fnd_file.put_line(FND_FILE.LOG, var_buf);
1599:
1600: retcode := 2;
1593:
1594: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1595: fnd_file.new_line(FND_FILE.LOG, 1);
1596: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1597: var_buf := fnd_message.get;
1598: fnd_file.put_line(FND_FILE.LOG, var_buf);
1599:
1600: retcode := 2;
1601: errbuf := var_buf;
1602: END IF;
1603:
1604: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1605: fnd_file.new_line(FND_FILE.LOG, 1);
1606: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1607: var_buf := fnd_message.get;
1608: fnd_file.put_line(FND_FILE.LOG, var_buf);
1609:
1610: retcode := 2;
1603:
1604: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1605: fnd_file.new_line(FND_FILE.LOG, 1);
1606: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1607: var_buf := fnd_message.get;
1608: fnd_file.put_line(FND_FILE.LOG, var_buf);
1609:
1610: retcode := 2;
1611: errbuf := var_buf;
1629:
1630:
1631: IF ((var_loaded_eam_jobs(i) > 0) AND ((var_loaded_eam_req_id(i) = 0) OR (var_loaded_eam_req_id(i) IS NULL))) THEN
1632: fnd_file.new_line(FND_FILE.LOG, 1);
1633: fnd_message.set_name('MRP', 'CANNOT SUBMIT EAM_JOBS INTERFACE');
1634: var_buf := fnd_message.get;
1635: fnd_file.put_line(FND_FILE.LOG, var_buf);
1636:
1637: retcode := 2;
1630:
1631: IF ((var_loaded_eam_jobs(i) > 0) AND ((var_loaded_eam_req_id(i) = 0) OR (var_loaded_eam_req_id(i) IS NULL))) THEN
1632: fnd_file.new_line(FND_FILE.LOG, 1);
1633: fnd_message.set_name('MRP', 'CANNOT SUBMIT EAM_JOBS INTERFACE');
1634: var_buf := fnd_message.get;
1635: fnd_file.put_line(FND_FILE.LOG, var_buf);
1636:
1637: retcode := 2;
1638: errbuf := var_buf;
1640:
1641:
1642: IF ((var_resched_eam_jobs(i) > 0) AND (var_eam_req_id(i) = 0)) THEN
1643: fnd_file.new_line(FND_FILE.LOG, 1);
1644: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_EAM INTERFACE');
1645: var_buf := fnd_message.get;
1646: fnd_file.put_line(FND_FILE.LOG, var_buf);
1647:
1648: retcode := 2;
1641:
1642: IF ((var_resched_eam_jobs(i) > 0) AND (var_eam_req_id(i) = 0)) THEN
1643: fnd_file.new_line(FND_FILE.LOG, 1);
1644: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_EAM INTERFACE');
1645: var_buf := fnd_message.get;
1646: fnd_file.put_line(FND_FILE.LOG, var_buf);
1647:
1648: retcode := 2;
1649: errbuf := var_buf;
1650: END IF;
1651:
1652: IF ((var_loaded_cmro_jobs(i) > 0) AND ((var_loaded_cmro_req_id(i) = 0) OR (var_loaded_cmro_req_id(i) IS NULL))) THEN
1653: fnd_file.new_line(FND_FILE.LOG, 1);
1654: fnd_message.set_name('MRP', 'CANNOT SUBMIT CMRO_JOBS INTERFACE');
1655: var_buf := fnd_message.get;
1656: fnd_file.put_line(FND_FILE.LOG, var_buf);
1657:
1658: retcode := 2;
1651:
1652: IF ((var_loaded_cmro_jobs(i) > 0) AND ((var_loaded_cmro_req_id(i) = 0) OR (var_loaded_cmro_req_id(i) IS NULL))) THEN
1653: fnd_file.new_line(FND_FILE.LOG, 1);
1654: fnd_message.set_name('MRP', 'CANNOT SUBMIT CMRO_JOBS INTERFACE');
1655: var_buf := fnd_message.get;
1656: fnd_file.put_line(FND_FILE.LOG, var_buf);
1657:
1658: retcode := 2;
1659: errbuf := var_buf;
1661:
1662:
1663: IF ((var_resched_cmro_jobs(i) > 0) AND (var_resched_cmro_req_id(i) = 0)) THEN
1664: fnd_file.new_line(FND_FILE.LOG, 1);
1665: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_CMRO INTERFACE');
1666: var_buf := fnd_message.get;
1667: fnd_file.put_line(FND_FILE.LOG, var_buf);
1668:
1669: retcode := 2;
1662:
1663: IF ((var_resched_cmro_jobs(i) > 0) AND (var_resched_cmro_req_id(i) = 0)) THEN
1664: fnd_file.new_line(FND_FILE.LOG, 1);
1665: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_CMRO INTERFACE');
1666: var_buf := fnd_message.get;
1667: fnd_file.put_line(FND_FILE.LOG, var_buf);
1668:
1669: retcode := 2;
1670: errbuf := var_buf;
1682: into lv_instance_code
1683: from msc_apps_instances
1684: where instance_id= var_released_instance(i);
1685:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1683: from msc_apps_instances
1684: where instance_id= var_released_instance(i);
1685:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1684: where instance_id= var_released_instance(i);
1685:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1692: END LOOP;
1685:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1692: END LOOP;
1693:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1692: END LOOP;
1693:
1694: END;
1687: fnd_message.set_token('INSTANCE', lv_instance_code);
1688: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1692: END LOOP;
1693:
1694: END;
1695: RETURN;
1823:
1824: /* Bug 2595278 - added Null condition */
1825: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1826: fnd_file.new_line(FND_FILE.LOG, 1);
1827: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1828: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1829: RETCODE := MSC_UTIL.G_ERROR;
1830: END IF;
1831:
1824: /* Bug 2595278 - added Null condition */
1825: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1826: fnd_file.new_line(FND_FILE.LOG, 1);
1827: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1828: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1829: RETCODE := MSC_UTIL.G_ERROR;
1830: END IF;
1831:
1832:
1831:
1832:
1833: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1834: fnd_file.new_line(FND_FILE.LOG, 1);
1835: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1836: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1837: RETCODE := MSC_UTIL.G_ERROR;
1838: END IF;
1839:
1832:
1833: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1834: fnd_file.new_line(FND_FILE.LOG, 1);
1835: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1836: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1837: RETCODE := MSC_UTIL.G_ERROR;
1838: END IF;
1839:
1840: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1838: END IF;
1839:
1840: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1841: fnd_file.new_line(FND_FILE.LOG, 1);
1842: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1843: ERRMSG := ERRMSG || ' ' ||fnd_message.get;
1844: RETCODE := MSC_UTIL.G_ERROR;
1845: END IF;
1846:
1839:
1840: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1841: fnd_file.new_line(FND_FILE.LOG, 1);
1842: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1843: ERRMSG := ERRMSG || ' ' ||fnd_message.get;
1844: RETCODE := MSC_UTIL.G_ERROR;
1845: END IF;
1846:
1847: IF ((var_loaded_int_repair_orders(i) > 0) AND (var_int_repair_orders_id(i) = 0)) THEN