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.MSC_RELEASE_PK dependencies on FND_MESSAGE

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

539: ||' WHERE mar.ALLOW_RELEASE_FLAG = 1 ';
540:
541: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
542:
543: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
544: fnd_message.set_token('A2M_DBLINK',v_dblink);
545: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
546: var_buf:= fnd_message.get;
547: fnd_file.put_line(FND_FILE.LOG, var_buf);

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

540:
541: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
542:
543: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
544: fnd_message.set_token('A2M_DBLINK',v_dblink);
545: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
546: var_buf:= fnd_message.get;
547: fnd_file.put_line(FND_FILE.LOG, var_buf);
548:

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

541: EXECUTE IMMEDIATE var_sql_stmt INTO v_dblink ;
542:
543: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
544: fnd_message.set_token('A2M_DBLINK',v_dblink);
545: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
546: var_buf:= fnd_message.get;
547: fnd_file.put_line(FND_FILE.LOG, var_buf);
548:
549:

Line 546: var_buf:= fnd_message.get;

542:
543: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
544: fnd_message.set_token('A2M_DBLINK',v_dblink);
545: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
546: var_buf:= fnd_message.get;
547: fnd_file.put_line(FND_FILE.LOG, var_buf);
548:
549:
550: retcode := 1;

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

563: msc_valid_plan_pkg.msc_valid_plan(arg_plan_id, 'Y', 'Y', 'Y', 'N');
564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
568: var_buf:= fnd_message.get;
569: fnd_file.put_line(FND_FILE.LOG, var_buf);
570:
571: retcode := 2;

Line 568: var_buf:= fnd_message.get;

564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
568: var_buf:= fnd_message.get;
569: fnd_file.put_line(FND_FILE.LOG, var_buf);
570:
571: retcode := 2;
572: errbuf := var_buf;

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

1039:
1040: var_buf := '................. ';
1041: fnd_file.put_line(FND_FILE.LOG, var_buf);
1042:
1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);

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

1040: var_buf := '................. ';
1041: fnd_file.put_line(FND_FILE.LOG, var_buf);
1042:
1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);

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

1042:
1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));

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

1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));

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

1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1053:

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

1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1053:
1054: ELSE

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

1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1053:
1054: ELSE
1055:

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

1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1053:
1054: ELSE
1055:
1056: -- ------------------------------------------------------------------

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

1226: into lv_instance_code
1227: from msc_apps_instances
1228: where instance_id= var_released_instance_id(i);
1229:
1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');

Line 1231: fnd_message.set_token('INSTANCE', lv_instance_code);

1227: from msc_apps_instances
1228: where instance_id= var_released_instance_id(i);
1229:
1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));

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

1228: where instance_id= var_released_instance_id(i);
1229:
1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');

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

1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');

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

1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');

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

1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));

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

1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');

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

1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));

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

1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');

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

1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');

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

1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');

Line 1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');

1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));

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

1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');

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

1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));

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

1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');

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

1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));

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

1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));

Line 1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));

1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));

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

1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1268:

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

1268:
1269: /* Bug 2595278 - added Null condition */
1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1271: fnd_file.new_line(FND_FILE.LOG, 1);
1272: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1273: var_buf := fnd_message.get;
1274: fnd_file.put_line(FND_FILE.LOG, var_buf);
1275:
1276: retcode := 2;

Line 1273: var_buf := fnd_message.get;

1269: /* Bug 2595278 - added Null condition */
1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1271: fnd_file.new_line(FND_FILE.LOG, 1);
1272: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1273: var_buf := fnd_message.get;
1274: fnd_file.put_line(FND_FILE.LOG, var_buf);
1275:
1276: retcode := 2;
1277: errbuf := var_buf;

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

1279:
1280:
1281: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1282: fnd_file.new_line(FND_FILE.LOG, 1);
1283: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1284: var_buf := fnd_message.get;
1285: fnd_file.put_line(FND_FILE.LOG, var_buf);
1286:
1287: retcode := 2;

Line 1284: var_buf := fnd_message.get;

1280:
1281: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1282: fnd_file.new_line(FND_FILE.LOG, 1);
1283: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1284: var_buf := fnd_message.get;
1285: fnd_file.put_line(FND_FILE.LOG, var_buf);
1286:
1287: retcode := 2;
1288: errbuf := var_buf;

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

1289: END IF;
1290:
1291: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1292: fnd_file.new_line(FND_FILE.LOG, 1);
1293: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1294: var_buf := fnd_message.get;
1295: fnd_file.put_line(FND_FILE.LOG, var_buf);
1296:
1297: retcode := 2;

Line 1294: var_buf := fnd_message.get;

1290:
1291: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1292: fnd_file.new_line(FND_FILE.LOG, 1);
1293: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1294: var_buf := fnd_message.get;
1295: fnd_file.put_line(FND_FILE.LOG, var_buf);
1296:
1297: retcode := 2;
1298: errbuf := var_buf;

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

1326: into lv_instance_code
1327: from msc_apps_instances
1328: where instance_id= var_released_instance(i);
1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));

Line 1331: fnd_message.set_token('INSTANCE', lv_instance_code);

1327: from msc_apps_instances
1328: where instance_id= var_released_instance(i);
1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

1328: where instance_id= var_released_instance(i);
1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;

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

1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;
1337:

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

1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;
1337:
1338: END;

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

1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;
1337:
1338: END;
1339: RETURN;

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

1452:
1453: /* Bug 2595278 - added Null condition */
1454: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1455: fnd_file.new_line(FND_FILE.LOG, 1);
1456: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1457: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1458: RETCODE := MSC_UTIL.G_ERROR;
1459: END IF;
1460:

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

1453: /* Bug 2595278 - added Null condition */
1454: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1455: fnd_file.new_line(FND_FILE.LOG, 1);
1456: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1457: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1458: RETCODE := MSC_UTIL.G_ERROR;
1459: END IF;
1460:
1461:

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

1460:
1461:
1462: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1463: fnd_file.new_line(FND_FILE.LOG, 1);
1464: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1465: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1466: RETCODE := MSC_UTIL.G_ERROR;
1467: END IF;
1468:

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

1461:
1462: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1463: fnd_file.new_line(FND_FILE.LOG, 1);
1464: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1465: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1466: RETCODE := MSC_UTIL.G_ERROR;
1467: END IF;
1468:
1469: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN

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

1467: END IF;
1468:
1469: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1470: fnd_file.new_line(FND_FILE.LOG, 1);
1471: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1472: ERRMSG := ERRMSG || ' ' ||fnd_message.get;
1473: RETCODE := MSC_UTIL.G_ERROR;
1474: END IF;
1475:

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

1468:
1469: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1470: fnd_file.new_line(FND_FILE.LOG, 1);
1471: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1472: ERRMSG := ERRMSG || ' ' ||fnd_message.get;
1473: RETCODE := MSC_UTIL.G_ERROR;
1474: END IF;
1475:
1476: IF ((var_loaded_int_repair_orders(i) > 0) AND (var_int_repair_orders_id(i) = 0)) THEN