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.WMS_MDC_PVT dependencies on FND_API

Line 400: -- RAISE fnd_api.g_exc_error;

396: END IF;
397: fnd_message.set_name('WMS', 'WMS_FROM_LPN_NO_DELIVERY');
398: fnd_msg_pub.ADD;
399: -- Check the to_lpn before raising it
400: -- RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: IF l_from_delivery_id IS NOT NULL THEN
404: l_from_delivery_type := get_delivery_type (p_delivery_id => l_from_delivery_id);

Line 425: --RAISE fnd_api.g_exc_error; No need to raise it ..check other conditions first

421: 'wms_mdc_pvt.validate_to_lpns');
422: END IF;
423: fnd_message.set_name('WMS', 'WMS_FROM_LPN_CONSOL');
424: fnd_msg_pub.ADD;
425: --RAISE fnd_api.g_exc_error; No need to raise it ..check other conditions first
426: ELSE
427: IF g_debug = 1 THEN
428: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : From LPNs is ' ||
429: 'a Consol LPN, No further nesting is allowed ' ,

Line 436: RAISE fnd_api.g_exc_error;

432: END IF;
433: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
434: fnd_msg_pub.ADD;
435: x_allow_packing := 'N' ;
436: RAISE fnd_api.g_exc_error;
437: END IF;
438: END IF;
439: END IF;
440:

Line 498: RAISE fnd_api.g_exc_error;

494: --{{ in staging locator only }}
495: END IF;
496: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');
497: fnd_msg_pub.ADD;
498: RAISE fnd_api.g_exc_error;
499: ELSE -- not a consol delivery of from LPN
500: x_allow_packing := 'Y' ;
501: Return;
502: END IF;

Line 548: RAISE fnd_api.g_exc_error;

544: 'wms_mdc_pvt.validate_to_lpn');
545: END IF;
546: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
547: fnd_msg_pub.ADD;
548: RAISE fnd_api.g_exc_error;
549: ELSE -- TODEL is not null and FROMDEL is null
550: RAISE fnd_api.g_exc_error;
551: END IF;
552: END IF;

Line 550: RAISE fnd_api.g_exc_error;

546: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
547: fnd_msg_pub.ADD;
548: RAISE fnd_api.g_exc_error;
549: ELSE -- TODEL is not null and FROMDEL is null
550: RAISE fnd_api.g_exc_error;
551: END IF;
552: END IF;
553:
554: IF l_to_delivery_id = l_from_delivery_id THEN

Line 584: RAISE fnd_api.g_exc_error;

580: --{{Cannot comingle AD/WD material in TO LPN }}
581: END IF;
582: fnd_message.set_name('WMS', 'WMS_CANNOT_CONSOL_INNERLPN');
583: fnd_msg_pub.ADD;
584: RAISE fnd_api.g_exc_error;
585: END IF;
586: BEGIN
587: SELECT 'Y'
588: INTO l_in_staging

Line 699: RAISE fnd_api.g_exc_error;

695: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
696: END IF;
697:
698: IF x_return_status = 'E' THEN
699: RAISE fnd_api.g_exc_error;
700: ELSE
701: RAISE fnd_api.g_exc_unexpected_error;
702: END IF;
703: ELSE

Line 701: RAISE fnd_api.g_exc_unexpected_error;

697:
698: IF x_return_status = 'E' THEN
699: RAISE fnd_api.g_exc_error;
700: ELSE
701: RAISE fnd_api.g_exc_unexpected_error;
702: END IF;
703: ELSE
704: IF l_deconsolidation_location IS NOT NULL THEN
705: l_allow_packing := 'Y';

Line 719: RAISE fnd_api.g_exc_error;

715: --{{Cannot comingle AD/WD material in TO LPN }}
716: END IF;
717: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
718: fnd_msg_pub.ADD;
719: RAISE fnd_api.g_exc_error;
720: END IF;
721: ELSE
722: l_allow_packing := 'V';
723: END IF ; --p_local_caller = 'N' THEN

Line 732: RAISE fnd_api.g_exc_error;

728: --{{Cannot Pack into TO LPN that has loose material }}
729: END IF;
730: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
731: fnd_msg_pub.ADD;
732: RAISE fnd_api.g_exc_error;
733: END IF ;
734: ELSE -- l_in_staging = 'N' THEN
735: x_allow_packing := 'N' ;
736: IF g_debug = 1 THEN

Line 744: RAISE fnd_api.g_exc_error;

740: --in staging locator only }}
741: END IF;
742: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');
743: fnd_msg_pub.ADD;
744: RAISE fnd_api.g_exc_error;
745: END IF;
746: END IF; -- l_to_lpn_context = 5 AND p_local_caller = 'N' THEN
747:
748: END IF; -- to_lpn_id is not null

Line 757: WHEN fnd_api.g_exc_error THEN

753: x_allow_packing := l_allow_packing;
754: x_return_status := 'S';
755:
756: EXCEPTION
757: WHEN fnd_api.g_exc_error THEN
758: x_return_status := 'E';
759: IF g_debug = 1 THEN
760: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
761: END IF;

Line 763: WHEN fnd_api.g_exc_unexpected_error THEN

759: IF g_debug = 1 THEN
760: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
761: END IF;
762:
763: WHEN fnd_api.g_exc_unexpected_error THEN
764: x_return_status := 'U';
765: IF g_debug = 1 THEN
766: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
767: END IF;

Line 1006: RAISE fnd_api.g_exc_error;

1002:
1003: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to
1004: -- suggest, therefore there is no need to raise an error.
1005: IF x_return_status = 'E' THEN
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF; */
1010: x_return_status := 'S';

Line 1008: RAISE fnd_api.g_exc_unexpected_error;

1004: -- suggest, therefore there is no need to raise an error.
1005: IF x_return_status = 'E' THEN
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF; */
1010: x_return_status := 'S';
1011: l_allow_packing := 'N';
1012: x_to_lpn_id := NULL;

Line 1032: WHEN fnd_api.g_exc_error THEN

1028: END IF;
1029: END IF;
1030: END IF; -- P_lpn_id is a consol LPN
1031: EXCEPTION
1032: WHEN fnd_api.g_exc_error THEN
1033: x_return_status := 'E';
1034: IF g_debug = 1 THEN
1035: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1036: END IF;

Line 1038: WHEN fnd_api.g_exc_unexpected_error THEN

1034: IF g_debug = 1 THEN
1035: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1036: END IF;
1037:
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: x_return_status := 'U';
1040: IF g_debug = 1 THEN
1041: debug('Unexpected Error', 'wms_mdc_pvt.suggest_to_lpn');
1042: END IF;

Line 1176: RAISE fnd_api.g_exc_error;

1172: END IF;
1173: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
1174: fnd_msg_pub.ADD;
1175: x_allow_packing := 'N' ;
1176: RAISE fnd_api.g_exc_error;
1177: --EXIT; -- No need to check the delivery ids of the remaining
1178: END IF;
1179: END IF;
1180:

Line 1191: --RAISE fnd_api.g_exc_error;

1187: END IF;
1188: fnd_message.set_name('WMS', 'WMS_ONE_FROM_LPN_NO_DEL');
1189: fnd_msg_pub.ADD;
1190: -- Check the to_lpn before raising it
1191: --RAISE fnd_api.g_exc_error;
1192: END IF;
1193: END IF;
1194:
1195:

Line 1239: RAISE fnd_api.g_exc_error;

1235: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1236: END IF;
1237: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
1238: fnd_msg_pub.ADD;
1239: RAISE fnd_api.g_exc_error;
1240: ELSE -- TODEL is not null and FROMDEL is null
1241: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1242: RAISE fnd_api.g_exc_error;
1243: END IF;

Line 1242: RAISE fnd_api.g_exc_error;

1238: fnd_msg_pub.ADD;
1239: RAISE fnd_api.g_exc_error;
1240: ELSE -- TODEL is not null and FROMDEL is null
1241: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1242: RAISE fnd_api.g_exc_error;
1243: END IF;
1244: END IF;
1245: IF (l_to_delivery_id <> 0 ) THEN
1246: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');

Line 1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;
1300:
1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1302: RAISE fnd_api.g_exc_error;
1303: END IF;
1304: IF l_allow_packing = 'N' THEN
1305: RAISE fnd_api.g_exc_error;

Line 1302: RAISE fnd_api.g_exc_error;

1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;
1300:
1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1302: RAISE fnd_api.g_exc_error;
1303: END IF;
1304: IF l_allow_packing = 'N' THEN
1305: RAISE fnd_api.g_exc_error;
1306: END IF;

Line 1305: RAISE fnd_api.g_exc_error;

1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1302: RAISE fnd_api.g_exc_error;
1303: END IF;
1304: IF l_allow_packing = 'N' THEN
1305: RAISE fnd_api.g_exc_error;
1306: END IF;
1307:
1308: IF l_allow_packing = 'V' THEN -- further validation needed for non-consol from LPNs
1309: -- Loop through all the LPNs to make sure that all the from LPNs are AD

Line 1380: RAISE fnd_api.g_exc_error;

1376: || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1377: END IF;
1378:
1379: IF x_return_status = 'E' THEN
1380: RAISE fnd_api.g_exc_error;
1381: ELSE
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: ELSE

Line 1382: RAISE fnd_api.g_exc_unexpected_error;

1378:
1379: IF x_return_status = 'E' THEN
1380: RAISE fnd_api.g_exc_error;
1381: ELSE
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: ELSE
1385: IF l_deconsolidation_location IS NOT NULL THEN
1386: l_allow_packing := 'Y';

Line 1407: RAISE fnd_api.g_exc_error;

1403: --{{Cannot comingle AD/WD material in TO LPN }}
1404: END IF;
1405: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
1406: fnd_msg_pub.ADD;
1407: RAISE fnd_api.g_exc_error;
1408: END IF; -- Are all from LPNS AD?
1409: END IF; -- allow packing = 'V' , futher validations
1410: END IF; -- Allow packing is Y and deliveries and not same
1411: END IF; -- to_lpn_id is null or 0

Line 1416: WHEN fnd_api.g_exc_error THEN

1412:
1413: x_allow_packing := l_allow_packing;
1414: x_return_status := 'S';
1415: EXCEPTION
1416: WHEN fnd_api.g_exc_error THEN
1417: x_return_status := 'E';
1418: IF g_debug = 1 THEN
1419: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1420: END IF;

Line 1422: WHEN fnd_api.g_exc_unexpected_error THEN

1418: IF g_debug = 1 THEN
1419: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1420: END IF;
1421:
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := 'U';
1424: IF g_debug = 1 THEN
1425: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
1426: END IF;