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 437: -- RAISE fnd_api.g_exc_error;

433: END IF;
434: fnd_message.set_name('WMS', 'WMS_FROM_LPN_NO_DELIVERY');
435: fnd_msg_pub.ADD;
436: -- Check the to_lpn before raising it
437: -- RAISE fnd_api.g_exc_error;
438: END IF;
439:
440: IF l_from_delivery_id IS NOT NULL THEN
441: l_from_delivery_type := get_delivery_type (p_delivery_id => l_from_delivery_id);

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

458: 'wms_mdc_pvt.validate_to_lpns');
459: END IF;
460: fnd_message.set_name('WMS', 'WMS_FROM_LPN_CONSOL');
461: fnd_msg_pub.ADD;
462: --RAISE fnd_api.g_exc_error; No need to raise it ..check other conditions first
463: ELSE
464: IF g_debug = 1 THEN
465: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : From LPNs is ' ||
466: 'a Consol LPN, No further nesting is allowed ' ,

Line 473: RAISE fnd_api.g_exc_error;

469: END IF;
470: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
471: fnd_msg_pub.ADD;
472: x_allow_packing := 'N' ;
473: RAISE fnd_api.g_exc_error;
474: END IF;
475: END IF;
476: END IF;
477:

Line 535: RAISE fnd_api.g_exc_error;

531: --{{ in staging locator only }}
532: END IF;
533: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');
534: fnd_msg_pub.ADD;
535: RAISE fnd_api.g_exc_error;
536: ELSE -- not a consol delivery of from LPN
537: x_allow_packing := 'Y' ;
538: Return;
539: END IF;

Line 585: RAISE fnd_api.g_exc_error;

581: 'wms_mdc_pvt.validate_to_lpn');
582: END IF;
583: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
584: fnd_msg_pub.ADD;
585: RAISE fnd_api.g_exc_error;
586: ELSE -- TODEL is not null and FROMDEL is null
587: RAISE fnd_api.g_exc_error;
588: END IF;
589: END IF;

Line 587: RAISE fnd_api.g_exc_error;

583: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
584: fnd_msg_pub.ADD;
585: RAISE fnd_api.g_exc_error;
586: ELSE -- TODEL is not null and FROMDEL is null
587: RAISE fnd_api.g_exc_error;
588: END IF;
589: END IF;
590:
591: IF l_to_delivery_id = l_from_delivery_id THEN

Line 621: RAISE fnd_api.g_exc_error;

617: --{{Cannot comingle AD/WD material in TO LPN }}
618: END IF;
619: fnd_message.set_name('WMS', 'WMS_CANNOT_CONSOL_INNERLPN');
620: fnd_msg_pub.ADD;
621: RAISE fnd_api.g_exc_error;
622: END IF;
623: BEGIN
624: SELECT 'Y'
625: INTO l_in_staging

Line 736: RAISE fnd_api.g_exc_error;

732: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
733: END IF;
734:
735: IF x_return_status = 'E' THEN
736: RAISE fnd_api.g_exc_error;
737: ELSE
738: RAISE fnd_api.g_exc_unexpected_error;
739: END IF;
740: ELSE

Line 738: RAISE fnd_api.g_exc_unexpected_error;

734:
735: IF x_return_status = 'E' THEN
736: RAISE fnd_api.g_exc_error;
737: ELSE
738: RAISE fnd_api.g_exc_unexpected_error;
739: END IF;
740: ELSE
741: IF l_deconsolidation_location IS NOT NULL THEN
742: l_allow_packing := 'Y';

Line 756: RAISE fnd_api.g_exc_error;

752: --{{Cannot comingle AD/WD material in TO LPN }}
753: END IF;
754: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
755: fnd_msg_pub.ADD;
756: RAISE fnd_api.g_exc_error;
757: END IF;
758: ELSE
759: l_allow_packing := 'V';
760: END IF ; --p_local_caller = 'N' THEN

Line 769: RAISE fnd_api.g_exc_error;

765: --{{Cannot Pack into TO LPN that has loose material }}
766: END IF;
767: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
768: fnd_msg_pub.ADD;
769: RAISE fnd_api.g_exc_error;
770: END IF ;
771: ELSE -- l_in_staging = 'N' THEN
772: x_allow_packing := 'N' ;
773: IF g_debug = 1 THEN

Line 781: RAISE fnd_api.g_exc_error;

777: --in staging locator only }}
778: END IF;
779: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');
780: fnd_msg_pub.ADD;
781: RAISE fnd_api.g_exc_error;
782: END IF;
783: END IF; -- l_to_lpn_context = 5 AND p_local_caller = 'N' THEN
784:
785: END IF; -- to_lpn_id is not null

Line 794: WHEN fnd_api.g_exc_error THEN

790: x_allow_packing := l_allow_packing;
791: x_return_status := 'S';
792:
793: EXCEPTION
794: WHEN fnd_api.g_exc_error THEN
795: x_return_status := 'E';
796: IF g_debug = 1 THEN
797: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
798: END IF;

Line 800: WHEN fnd_api.g_exc_unexpected_error THEN

796: IF g_debug = 1 THEN
797: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
798: END IF;
799:
800: WHEN fnd_api.g_exc_unexpected_error THEN
801: x_return_status := 'U';
802: IF g_debug = 1 THEN
803: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
804: END IF;

Line 1043: RAISE fnd_api.g_exc_error;

1039:
1040: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to
1041: -- suggest, therefore there is no need to raise an error.
1042: IF x_return_status = 'E' THEN
1043: RAISE fnd_api.g_exc_error;
1044: ELSE
1045: RAISE fnd_api.g_exc_unexpected_error;
1046: END IF; */
1047: x_return_status := 'S';

Line 1045: RAISE fnd_api.g_exc_unexpected_error;

1041: -- suggest, therefore there is no need to raise an error.
1042: IF x_return_status = 'E' THEN
1043: RAISE fnd_api.g_exc_error;
1044: ELSE
1045: RAISE fnd_api.g_exc_unexpected_error;
1046: END IF; */
1047: x_return_status := 'S';
1048: l_allow_packing := 'N';
1049: x_to_lpn_id := NULL;

Line 1069: WHEN fnd_api.g_exc_error THEN

1065: END IF;
1066: END IF;
1067: END IF; -- P_lpn_id is a consol LPN
1068: EXCEPTION
1069: WHEN fnd_api.g_exc_error THEN
1070: x_return_status := 'E';
1071: IF g_debug = 1 THEN
1072: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1073: END IF;

Line 1075: WHEN fnd_api.g_exc_unexpected_error THEN

1071: IF g_debug = 1 THEN
1072: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1073: END IF;
1074:
1075: WHEN fnd_api.g_exc_unexpected_error THEN
1076: x_return_status := 'U';
1077: IF g_debug = 1 THEN
1078: debug('Unexpected Error', 'wms_mdc_pvt.suggest_to_lpn');
1079: END IF;

Line 1213: RAISE fnd_api.g_exc_error;

1209: END IF;
1210: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
1211: fnd_msg_pub.ADD;
1212: x_allow_packing := 'N' ;
1213: RAISE fnd_api.g_exc_error;
1214: --EXIT; -- No need to check the delivery ids of the remaining
1215: END IF;
1216: END IF;
1217:

Line 1228: --RAISE fnd_api.g_exc_error;

1224: END IF;
1225: fnd_message.set_name('WMS', 'WMS_ONE_FROM_LPN_NO_DEL');
1226: fnd_msg_pub.ADD;
1227: -- Check the to_lpn before raising it
1228: --RAISE fnd_api.g_exc_error;
1229: END IF;
1230: END IF;
1231:
1232:

Line 1276: RAISE fnd_api.g_exc_error;

1272: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1273: END IF;
1274: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
1275: fnd_msg_pub.ADD;
1276: RAISE fnd_api.g_exc_error;
1277: ELSE -- TODEL is not null and FROMDEL is null
1278: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1279: RAISE fnd_api.g_exc_error;
1280: END IF;

Line 1279: RAISE fnd_api.g_exc_error;

1275: fnd_msg_pub.ADD;
1276: RAISE fnd_api.g_exc_error;
1277: ELSE -- TODEL is not null and FROMDEL is null
1278: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1279: RAISE fnd_api.g_exc_error;
1280: END IF;
1281: END IF;
1282: IF (l_to_delivery_id <> 0 ) THEN
1283: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');

Line 1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1334: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341: IF l_allow_packing = 'N' THEN
1342: RAISE fnd_api.g_exc_error;

Line 1339: RAISE fnd_api.g_exc_error;

1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341: IF l_allow_packing = 'N' THEN
1342: RAISE fnd_api.g_exc_error;
1343: END IF;

Line 1342: RAISE fnd_api.g_exc_error;

1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341: IF l_allow_packing = 'N' THEN
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344:
1345: IF l_allow_packing = 'V' THEN -- further validation needed for non-consol from LPNs
1346: -- Loop through all the LPNs to make sure that all the from LPNs are AD

Line 1417: RAISE fnd_api.g_exc_error;

1413: || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1414: END IF;
1415:
1416: IF x_return_status = 'E' THEN
1417: RAISE fnd_api.g_exc_error;
1418: ELSE
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: END IF;
1421: ELSE

Line 1419: RAISE fnd_api.g_exc_unexpected_error;

1415:
1416: IF x_return_status = 'E' THEN
1417: RAISE fnd_api.g_exc_error;
1418: ELSE
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: END IF;
1421: ELSE
1422: IF l_deconsolidation_location IS NOT NULL THEN
1423: l_allow_packing := 'Y';

Line 1444: RAISE fnd_api.g_exc_error;

1440: --{{Cannot comingle AD/WD material in TO LPN }}
1441: END IF;
1442: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
1443: fnd_msg_pub.ADD;
1444: RAISE fnd_api.g_exc_error;
1445: END IF; -- Are all from LPNS AD?
1446: END IF; -- allow packing = 'V' , futher validations
1447: END IF; -- Allow packing is Y and deliveries and not same
1448: END IF; -- to_lpn_id is null or 0

Line 1453: WHEN fnd_api.g_exc_error THEN

1449:
1450: x_allow_packing := l_allow_packing;
1451: x_return_status := 'S';
1452: EXCEPTION
1453: WHEN fnd_api.g_exc_error THEN
1454: x_return_status := 'E';
1455: IF g_debug = 1 THEN
1456: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1457: END IF;

Line 1459: WHEN fnd_api.g_exc_unexpected_error THEN

1455: IF g_debug = 1 THEN
1456: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1457: END IF;
1458:
1459: WHEN fnd_api.g_exc_unexpected_error THEN
1460: x_return_status := 'U';
1461: IF g_debug = 1 THEN
1462: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
1463: END IF;