DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on FND_MESSAGE

Line 663: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');

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

Line 664: fnd_message.set_token('A2M_DBLINK',v_dblink);

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:

Line 665: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);

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:

Line 666: var_buf:= fnd_message.get;

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;

Line 710: var_buf:= fnd_message.get;

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

Line 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;

Line 715: 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;
719: errbuf := var_buf;

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

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

Line 1306: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

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

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

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

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

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

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:

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

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

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

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:

Line 1314: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

Line 1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');

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

Line 1537: fnd_message.set_token('INSTANCE', 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');
1541: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));

Line 1538: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

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

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

Line 1542: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

Line 1545: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');

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

Line 1546: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

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

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

Line 1550: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

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

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

Line 1554: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

Line 1557: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM 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)));

Line 1558: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

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

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

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

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

Line 1562: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

Line 1564: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');

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

Line 1565: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));

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

Line 1566: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

Line 1568: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');

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

Line 1569: fnd_message.set_token('VALUE', to_char(var_resched_reqs(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));

Line 1570: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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:

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

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;

Line 1586: var_buf := fnd_message.get;

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;

Line 1596: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');

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;

Line 1597: var_buf := fnd_message.get;

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;

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

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;

Line 1607: var_buf := fnd_message.get;

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;

Line 1633: fnd_message.set_name('MRP', 'CANNOT SUBMIT EAM_JOBS INTERFACE');

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;

Line 1634: var_buf := fnd_message.get;

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;

Line 1644: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_EAM INTERFACE');

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;

Line 1645: var_buf := fnd_message.get;

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;

Line 1654: fnd_message.set_name('MRP', 'CANNOT SUBMIT CMRO_JOBS INTERFACE');

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;

Line 1655: var_buf := fnd_message.get;

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;

Line 1665: fnd_message.set_name('MRP', 'CANNOT SUBMIT RESCHED_CMRO INTERFACE');

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;

Line 1666: var_buf := fnd_message.get;

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;

Line 1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');

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

Line 1687: fnd_message.set_token('INSTANCE', 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)));
1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1688: 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;

Line 1689: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');

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:

Line 1690: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));

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;

Line 1691: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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;

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

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:

Line 1828: ERRMSG := ERRMSG || ' ' || fnd_message.get;

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:

Line 1835: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');

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:

Line 1836: ERRMSG := ERRMSG || ' ' || fnd_message.get;

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

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

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:

Line 1843: ERRMSG := ERRMSG || ' ' ||fnd_message.get;

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