APPS.MSC_RELEASE_PK dependencies on MSC_UTIL

Line 724: (MSC_UTIL.get_vmi_flag(var_plan_id,

720:
721: /*VMI Check -- fwd port 3181822 */
722:
723: IF (not (((var_order_type = 5) AND (var_make_buy_code = BUY and
724: (MSC_UTIL.get_vmi_flag(var_plan_id,
725: var_sr_instance_id,
726: var_org_id,
727: var_inventory_item_id,
728: var_source_supplier_id,

Line 730: OR (var_order_type in (1,2) AND (MSC_UTIL.get_vmi_flag(var_plan_id,

726: var_org_id,
727: var_inventory_item_id,
728: var_source_supplier_id,
729: var_source_supplier_site_id)= 1)))
730: OR (var_order_type in (1,2) AND (MSC_UTIL.get_vmi_flag(var_plan_id,
731: var_sr_instance_id,
732: var_org_id,
733: var_inventory_item_id,
734: var_supplier_id,

Line 1381: RETCODE := MSC_UTIL.G_ERROR;

1377: WHERE mp.plan_id = pPlan_id;
1378: EXCEPTION
1379: WHEN NO_DATA_FOUND THEN
1380: ERRMSG := 'Not a Valid plan ID';
1381: RETCODE := MSC_UTIL.G_ERROR;
1382: RETURN;
1383: WHEN OTHERS THEN
1384: ERRMSG := SQLERRM;
1385: RETCODE := MSC_UTIL.G_ERROR;

Line 1385: RETCODE := MSC_UTIL.G_ERROR;

1381: RETCODE := MSC_UTIL.G_ERROR;
1382: RETURN;
1383: WHEN OTHERS THEN
1384: ERRMSG := SQLERRM;
1385: RETCODE := MSC_UTIL.G_ERROR;
1386: RETURN;
1387: END;
1388:
1389: BEGIN

Line 1458: RETCODE := MSC_UTIL.G_ERROR;

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:
1462: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN

Line 1466: RETCODE := MSC_UTIL.G_ERROR;

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
1470: fnd_file.new_line(FND_FILE.LOG, 1);

Line 1473: RETCODE := MSC_UTIL.G_ERROR;

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
1477: ERRMSG := ERRMSG || ' ' ||' cannot submit the internal repair order request';

Line 1478: 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
1477: ERRMSG := ERRMSG || ' ' ||' cannot submit the internal repair order request';
1478: RETCODE := MSC_UTIL.G_ERROR;
1479: END IF;
1480:
1481: IF ((var_loaded_ext_repair_orders(i) > 0) AND (var_ext_repair_orders_id(i) = 0)) THEN
1482: ERRMSG := ERRMSG || ' ' || 'cannot submit the external repair order request';

Line 1483: RETCODE := MSC_UTIL.G_ERROR;

1479: END IF;
1480:
1481: IF ((var_loaded_ext_repair_orders(i) > 0) AND (var_ext_repair_orders_id(i) = 0)) THEN
1482: ERRMSG := ERRMSG || ' ' || 'cannot submit the external repair order request';
1483: RETCODE := MSC_UTIL.G_ERROR;
1484: END IF;
1485: END LOOP;
1486:
1487:

Line 1503: RETCODE := MSC_UTIL.G_ERROR;

1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: ERRMSG := SQLERRM;
1503: RETCODE := MSC_UTIL.G_ERROR;
1504: END;
1505:
1506: RETCODE := MSC_UTIL.G_SUCCESS;
1507: EXCEPTION

Line 1506: RETCODE := MSC_UTIL.G_SUCCESS;

1502: ERRMSG := SQLERRM;
1503: RETCODE := MSC_UTIL.G_ERROR;
1504: END;
1505:
1506: RETCODE := MSC_UTIL.G_SUCCESS;
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: ERRMSG := SQLERRM;
1510: RETCODE := MSC_UTIL.G_ERROR;

Line 1510: RETCODE := MSC_UTIL.G_ERROR;

1506: RETCODE := MSC_UTIL.G_SUCCESS;
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: ERRMSG := SQLERRM;
1510: RETCODE := MSC_UTIL.G_ERROR;
1511: END msc_web_service_release;
1512:
1513: END msc_release_pk;