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_EPC_PVT dependencies on FND_API

Line 406: x_return_status := fnd_api.g_ret_sts_success;

402: l_rev_id NUMBER;
403: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
404: BEGIN
405:
406: x_return_status := fnd_api.g_ret_sts_success;
407:
408: IF l_debug = 1 THEN
409: trace(' Inside get_gtin_and_gserial');
410: trace('p_org_id :'||p_org_id ||','||'p_item_id :'||p_item_id);

Line 452: RAISE fnd_api.g_exc_unexpected_error;

448: --Do not raise exception here
449:
450: WHEN OTHERS THEN
451: l_found_gtin := 0;
452: RAISE fnd_api.g_exc_unexpected_error;
453: END;
454:
455: IF l_found_gtin = 1 THEN --FOUND GTIN
456: --overwrite the value l_uom_code for GTIN setup

Line 495: RAISE fnd_api.g_exc_unexpected_error;

491: --Do not raise exception here
492:
493: WHEN OTHERS THEN
494: l_found_gtin := 0;
495: RAISE fnd_api.g_exc_unexpected_error;
496:
497: END;
498:
499: IF l_debug = 1 then

Line 532: RAISE fnd_api.g_exc_error;

528: END IF ;
529:
530: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN');
531: fnd_msg_pub.ADD;
532: RAISE fnd_api.g_exc_error;
533: END IF;
534:
535: ELSIF l_found_gtin = 0 THEN
536:

Line 539: RAISE fnd_api.g_exc_error;

535: ELSIF l_found_gtin = 0 THEN
536:
537: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN');
538: fnd_msg_pub.ADD;
539: RAISE fnd_api.g_exc_error;
540:
541: END IF;
542:
543:

Line 565: RAISE fnd_api.g_exc_error;

561:
562: IF x_gtin_serial IS NULL THEN
563: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN_GSERIAL');
564: fnd_msg_pub.ADD;
565: RAISE fnd_api.g_exc_error;
566:
567: END IF;
568:
569: ELSE

Line 572: RAISE fnd_api.g_exc_error;

568:
569: ELSE
570: fnd_message.set_name('WMS', 'WMS_NO_GTIN_FOUND');
571: fnd_msg_pub.ADD;
572: RAISE fnd_api.g_exc_error;
573: END IF;
574:
575:
576: EXCEPTION

Line 578: WHEN fnd_api.g_exc_error THEN

574:
575:
576: EXCEPTION
577:
578: WHEN fnd_api.g_exc_error THEN
579: x_return_status := fnd_api.g_ret_sts_error;
580: x_gtin := NULL;
581: x_gtin_serial := NULL;
582: RAISE; -- to raised to the outer call

Line 579: x_return_status := fnd_api.g_ret_sts_error;

575:
576: EXCEPTION
577:
578: WHEN fnd_api.g_exc_error THEN
579: x_return_status := fnd_api.g_ret_sts_error;
580: x_gtin := NULL;
581: x_gtin_serial := NULL;
582: RAISE; -- to raised to the outer call
583:

Line 584: WHEN fnd_api.g_exc_unexpected_error THEN

580: x_gtin := NULL;
581: x_gtin_serial := NULL;
582: RAISE; -- to raised to the outer call
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: x_gtin := NULL;
587: x_gtin_serial := NULL;
588: RAISE; -- to raised to the outer call

Line 585: x_return_status := fnd_api.g_ret_sts_unexp_error;

581: x_gtin_serial := NULL;
582: RAISE; -- to raised to the outer call
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: x_gtin := NULL;
587: x_gtin_serial := NULL;
588: RAISE; -- to raised to the outer call
589:

Line 596: x_return_status := fnd_api.g_ret_sts_unexp_error;

592: trace('Unexpected error inside get_gtin_and_gserial()');
593: trace('ERROR CODE = ' || SQLCODE);
594: trace('ERROR MESSAGE = ' || SQLERRM);
595: END IF;
596: x_return_status := fnd_api.g_ret_sts_unexp_error;
597: x_gtin := NULL;
598: x_gtin_serial := NULL;
599: RAISE;
600:

Line 630: x_return_status := fnd_api.g_ret_sts_success;

626: l_total_mmtt_qty1 NUMBER;
627: l_total_mmtt_qty2 NUMBER;
628: l_rev_id NUMBER;
629: BEGIN
630: x_return_status := fnd_api.g_ret_sts_success;
631:
632: IF l_debug = 1 then
633: trace('Inside get_lpn_gtin_serial p_business_flow_code :'|| p_business_flow_code);
634: END IF;

Line 690: RAISE fnd_api.g_exc_unexpected_error;

686: WHEN OTHERS THEN
687: IF l_debug = 1 THEN
688: trace('unexpected error for wms_bf_pick_load');
689: END IF;
690: RAISE fnd_api.g_exc_unexpected_error;
691:
692: END;
693:
694: IF l_debug = 1 then

Line 740: RAISE fnd_api.g_exc_unexpected_error;

736: WHEN OTHERS THEN
737: IF l_debug = 1 THEN
738: trace('unexpected error for Pick Release cartonization');
739: END IF;
740: RAISE fnd_api.g_exc_unexpected_error;
741:
742: END;
743:
744: IF l_debug = 1 then

Line 786: RAISE fnd_api.g_exc_unexpected_error;

782: WHEN OTHERS THEN
783: IF l_debug = 1 THEN
784: trace('Pallet unexpected error for Pick Release cartonization');
785: END IF;
786: RAISE fnd_api.g_exc_unexpected_error;
787:
788: END;
789:
790:

Line 833: RAISE fnd_api.g_exc_unexpected_error;

829: WHEN OTHERS THEN
830: IF l_debug = 1 THEN
831: trace('Case unexpected error for Pick Release cartonization');
832: END IF;
833: RAISE fnd_api.g_exc_unexpected_error;
834:
835: END;
836:
837: END IF;

Line 897: RAISE fnd_api.g_exc_unexpected_error;

893: WHEN OTHERS THEN
894: IF l_debug = 1 THEN
895: trace('WIP unexpected error for Pick Release cartonization');
896: END IF;
897: RAISE fnd_api.g_exc_unexpected_error;
898:
899: END;
900:
901: IF l_debug = 1 then

Line 941: RAISE fnd_api.g_exc_unexpected_error;

937: WHEN no_data_found THEN
938: l_is_gtin_valid := FALSE;
939:
940: WHEN OTHERS THEN
941: RAISE fnd_api.g_exc_unexpected_error;
942: END;
943:
944:
945: ELSIF p_filter_value = WMS_EPC_CASE_OBJ_TYPE THEN --case

Line 983: RAISE fnd_api.g_exc_unexpected_error;

979: WHEN no_data_found THEN
980: l_is_gtin_valid := FALSE;
981:
982: WHEN OTHERS THEN
983: RAISE fnd_api.g_exc_unexpected_error;
984:
985: END;
986:
987: END IF;

Line 1026: RAISE fnd_api.g_exc_error;

1022: ELSE
1023:
1024: fnd_message.set_name('WMS', 'WMS_NO_GTIN_FOUND');
1025: fnd_msg_pub.ADD;
1026: RAISE fnd_api.g_exc_error;
1027:
1028: END IF;--if l_is_gtin_valid
1029:
1030:

Line 1033: WHEN fnd_api.g_exc_error THEN

1029:
1030:
1031:
1032: EXCEPTION
1033: WHEN fnd_api.g_exc_error THEN
1034: x_return_status := fnd_api.g_ret_sts_error;
1035: x_gtin_serial := NULL;
1036: x_gtin := NULL;
1037: RAISE;

Line 1034: x_return_status := fnd_api.g_ret_sts_error;

1030:
1031:
1032: EXCEPTION
1033: WHEN fnd_api.g_exc_error THEN
1034: x_return_status := fnd_api.g_ret_sts_error;
1035: x_gtin_serial := NULL;
1036: x_gtin := NULL;
1037: RAISE;
1038: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1038: WHEN fnd_api.g_exc_unexpected_error THEN

1034: x_return_status := fnd_api.g_ret_sts_error;
1035: x_gtin_serial := NULL;
1036: x_gtin := NULL;
1037: RAISE;
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: x_return_status := fnd_api.g_ret_sts_unexp_error;
1040: x_gtin := NULL;
1041: x_gtin_serial := NULL;
1042: RAISE;

Line 1039: x_return_status := fnd_api.g_ret_sts_unexp_error;

1035: x_gtin_serial := NULL;
1036: x_gtin := NULL;
1037: RAISE;
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: x_return_status := fnd_api.g_ret_sts_unexp_error;
1040: x_gtin := NULL;
1041: x_gtin_serial := NULL;
1042: RAISE;
1043: WHEN OTHERS THEN

Line 1049: x_return_status := fnd_api.g_ret_sts_unexp_error;

1045: trace('Unexpected error inside get_LPN_gtin_serial()');
1046: trace('ERROR CODE = ' || SQLCODE);
1047: trace('ERROR MESSAGE = ' || SQLERRM);
1048: END IF;
1049: x_return_status := fnd_api.g_ret_sts_unexp_error;
1050: x_gtin := NULL;
1051: x_gtin_serial := NULL;
1052: RAISE;
1053:

Line 1075: x_return_status := fnd_api.g_ret_sts_success;

1071: l_uom_code VARCHAR2(3);
1072: l_primary_uom_code VARCHAR2(3);
1073: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1074: BEGIN
1075: x_return_status := fnd_api.g_ret_sts_success;
1076: -- if p_uom_code is NOT primary UOM, get primary qty in primary UOM
1077: -- For the primary qty, get the corresponding UOM conversion
1078:
1079: IF l_debug = 1 then

Line 1111: RAISE fnd_api.g_exc_error;

1107: END IF;
1108: ELSE
1109: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
1110: fnd_msg_pub.ADD;
1111: RAISE fnd_api.g_exc_error;
1112: END IF;
1113:
1114:
1115: IF (p_uom_code <> inv_cache.item_rec.primary_uom_code) THEN

Line 1160: WHEN fnd_api.g_exc_error THEN

1156: trace('x_gtin_serial :'|| x_gtin_serial);
1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN fnd_api.g_exc_error THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: x_gtin_serial := NULL;
1163: x_gtin := NULL;
1164: RAISE;

Line 1161: x_return_status := fnd_api.g_ret_sts_error;

1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN fnd_api.g_exc_error THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: x_gtin_serial := NULL;
1163: x_gtin := NULL;
1164: RAISE;
1165: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1165: WHEN fnd_api.g_exc_unexpected_error THEN

1161: x_return_status := fnd_api.g_ret_sts_error;
1162: x_gtin_serial := NULL;
1163: x_gtin := NULL;
1164: RAISE;
1165: WHEN fnd_api.g_exc_unexpected_error THEN
1166: x_return_status := fnd_api.g_ret_sts_unexp_error;
1167: x_gtin := NULL;
1168: x_gtin_serial := NULL;
1169: RAISE;

Line 1166: x_return_status := fnd_api.g_ret_sts_unexp_error;

1162: x_gtin_serial := NULL;
1163: x_gtin := NULL;
1164: RAISE;
1165: WHEN fnd_api.g_exc_unexpected_error THEN
1166: x_return_status := fnd_api.g_ret_sts_unexp_error;
1167: x_gtin := NULL;
1168: x_gtin_serial := NULL;
1169: RAISE;
1170: WHEN OTHERS THEN

Line 1176: x_return_status := fnd_api.g_ret_sts_unexp_error;

1172: trace('Unexpected error inside get_item_gtin_serial()');
1173: trace('ERROR CODE = ' || SQLCODE);
1174: trace('ERROR MESSAGE = ' || SQLERRM);
1175: END IF;
1176: x_return_status := fnd_api.g_ret_sts_unexp_error;
1177: x_gtin := NULL;
1178: x_gtin_serial := NULL;
1179: RAISE;
1180:

Line 1199: x_return_status := fnd_api.g_ret_sts_success;

1195: l_rev_id NUMBER;
1196: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1197: BEGIN
1198:
1199: x_return_status := fnd_api.g_ret_sts_success;
1200:
1201:
1202: --GET THE PRIMARY UOM code FOR SERIAL ITEM
1203: IF ( inv_cache.set_item_rec(

Line 1213: RAISE fnd_api.g_exc_error;

1209: END IF;
1210: ELSE
1211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
1212: fnd_msg_pub.ADD;
1213: RAISE fnd_api.g_exc_error;
1214: END IF;
1215:
1216:
1217: -- See if the PRIMARY UOM obtained above is defined in the cross-reference table

Line 1241: WHEN fnd_api.g_exc_error THEN

1237:
1238:
1239: EXCEPTION
1240:
1241: WHEN fnd_api.g_exc_error THEN
1242: x_return_status := fnd_api.g_ret_sts_error;
1243: x_gtin_serial := NULL;
1244: x_gtin := NULL;
1245: RAISE;

Line 1242: x_return_status := fnd_api.g_ret_sts_error;

1238:
1239: EXCEPTION
1240:
1241: WHEN fnd_api.g_exc_error THEN
1242: x_return_status := fnd_api.g_ret_sts_error;
1243: x_gtin_serial := NULL;
1244: x_gtin := NULL;
1245: RAISE;
1246: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1246: WHEN fnd_api.g_exc_unexpected_error THEN

1242: x_return_status := fnd_api.g_ret_sts_error;
1243: x_gtin_serial := NULL;
1244: x_gtin := NULL;
1245: RAISE;
1246: WHEN fnd_api.g_exc_unexpected_error THEN
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248: x_gtin := NULL;
1249: x_gtin_serial := NULL;
1250: RAISE;

Line 1247: x_return_status := fnd_api.g_ret_sts_unexp_error;

1243: x_gtin_serial := NULL;
1244: x_gtin := NULL;
1245: RAISE;
1246: WHEN fnd_api.g_exc_unexpected_error THEN
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248: x_gtin := NULL;
1249: x_gtin_serial := NULL;
1250: RAISE;
1251: WHEN OTHERS THEN

Line 1257: x_return_status := fnd_api.g_ret_sts_unexp_error;

1253: trace('Unexpected error inside get_serialnum_gtin_seria()');
1254: trace('ERROR CODE = ' || SQLCODE);
1255: trace('ERROR MESSAGE = ' || SQLERRM);
1256: END IF;
1257: x_return_status := fnd_api.g_ret_sts_unexp_error;
1258: x_gtin := NULL;
1259: x_gtin_serial := NULL;
1260: RAISE;
1261:

Line 1298: RAISE fnd_api.g_exc_error;

1294: ELSE
1295: l_lpn_num_format := NULL;
1296: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SSCC');
1297: FND_MSG_PUB.ADD;
1298: RAISE fnd_api.g_exc_error;
1299: END IF;
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN --catch the exception for alphanumeric case

Line 1307: RAISE fnd_api.g_exc_error;

1303: l_lpn_num_format := NULL;
1304: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SSCC');
1305: FND_MSG_PUB.ADD;
1306: trace('Other Exception in get_sscc()');
1307: RAISE fnd_api.g_exc_error;
1308: END;
1309:
1310: RETURN l_lpn_num_format;
1311:

Line 1313: WHEN fnd_api.g_exc_error THEN

1309:
1310: RETURN l_lpn_num_format;
1311:
1312: EXCEPTION
1313: WHEN fnd_api.g_exc_error THEN
1314: RAISE;
1315:
1316: WHEN OTHERS THEN
1317: IF l_debug = 1 THEN

Line 1348: x_return_status := fnd_api.g_ret_sts_success;

1344:
1345: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1346:
1347: BEGIN
1348: x_return_status := fnd_api.g_ret_sts_success;
1349:
1350: IF l_debug = 1 THEN
1351: trace('p_group_id :'||p_group_id ||' ,'||'p_cross_ref_type :'||p_cross_ref_type);
1352: trace('p_Lpn_id :'||p_lpn_id);

Line 1358: x_return_status := fnd_api.g_ret_sts_error;

1354: trace('p_EPC :'||p_epc);
1355: END IF;
1356:
1357: IF p_group_id IS NULL OR p_cross_ref_type IS NULL OR p_epc IS NULL THEN
1358: x_return_status := fnd_api.g_ret_sts_error;
1359: x_return_mesg := fnd_message.get_string('WMS','WMS_EPC_MISSING_VALUES');
1360: RETURN;
1361:
1362: ELSIF p_lpn_id IS NULL AND

Line 1366: x_return_status := fnd_api.g_ret_sts_error;

1362: ELSIF p_lpn_id IS NULL AND
1363: (p_item_id IS NULL OR p_serial_number IS NULL ) AND
1364: (p_gtin IS NULL OR p_gtin_serial IS NULL) THEN
1365:
1366: x_return_status := fnd_api.g_ret_sts_error;
1367: x_return_mesg := fnd_message.get_string('WMS','WMS_EPC_MISSING_VALUES');
1368: RETURN;
1369: END IF;
1370:

Line 1415: x_return_status := fnd_api.g_ret_sts_error;

1411: --DO NOT COMMIT
1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: x_return_status := fnd_api.g_ret_sts_error;
1416: x_return_mesg := Sqlerrm;
1417:
1418: IF l_debug = 1 THEN
1419: trace('Exception in populate_outside_epc');

Line 1454: x_return_status := fnd_api.g_ret_sts_success;

1450: l_epc_id NUMBER;
1451: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1452: BEGIN
1453:
1454: x_return_status := fnd_api.g_ret_sts_success;
1455:
1456: IF l_debug = 1 THEN
1457: trace('************UPtoDATE WMS_EPC with new RFID model***');
1458: trace('p_action :'|| p_action );

Line 1705: x_return_status := fnd_api.g_ret_sts_error;

1701: COMMIT;
1702:
1703: EXCEPTION
1704: WHEN OTHERS THEN
1705: x_return_status := fnd_api.g_ret_sts_error;
1706: IF l_debug = 1 THEN
1707: TRACE('UPTODATE WMS_EPC: inside exception');
1708: TRACE('ERROR CODE = ' || SQLCODE);
1709: TRACE('ERROR MESSAGE = ' || SQLERRM);

Line 1784: x_return_status := fnd_api.g_ret_sts_success;

1780:
1781:
1782: BEGIN
1783:
1784: x_return_status := fnd_api.g_ret_sts_success;
1785:
1786: IF p_label_type_id IN (3,4,5) THEN --LPN, LPN Content, LPN Summary
1787:
1788: l_comp_prefix_dig_len:= Length(p_company_prefix);

Line 1804: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

1800:
1801: --{{ get the item reference from GTIN for LPN now }}
1802: --{{ l_gtin obtained IS NOT NULL }}
1803:
1804: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
1805:
1806: l_item_reference := To_number(Substr(To_char(l_gtin),1,1)||Substr(To_char(l_gtin),l_comp_prefix_dig_len+2,12-l_comp_prefix_dig_len));
1807:
1808: IF l_debug = 1 THEN

Line 1915: RAISE fnd_api.g_exc_error;

1911: IF l_debug = 1 THEN
1912: trace('Error : Incorrect SSCC value set up for the LPN');
1913: END IF;
1914:
1915: RAISE fnd_api.g_exc_error;
1916: END IF;
1917:
1918:
1919: ELSIF p_epc_rule_type IN ('USDOD-96','USDOD-64') THEN

Line 1928: RAISE fnd_api.g_exc_error;

1924: trace('Error:For LPN label, No EPC can be generated using EPC_DOD_96/64, incorrect SET up');
1925: END IF;
1926: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
1927: FND_MSG_PUB.ADD;
1928: RAISE fnd_api.g_exc_error;
1929: END IF;
1930:
1931: ELSIF p_label_type_id =1 THEN /*Material Label*/
1932:

Line 1954: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

1950: x_return_status => l_return_status);
1951:
1952:
1953:
1954: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
1955:
1956:
1957:
1958: --{{ get the item reference from GTIN for the Item now }}

Line 2011: RAISE fnd_api.g_exc_error;

2007: END IF;
2008:
2009: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
2010: FND_MSG_PUB.ADD;
2011: RAISE fnd_api.g_exc_error;
2012:
2013:
2014: ELSIF p_epc_rule_type IN ('USDOD-96','USDOD-64') THEN
2015:

Line 2021: RAISE fnd_api.g_exc_error;

2017: trace('Error:For Material, No EPC can be generated using EPC_DOD, incorrect SET up');
2018: END IF;
2019: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
2020: FND_MSG_PUB.ADD;
2021: RAISE fnd_api.g_exc_error;
2022:
2023:
2024: END IF;
2025:

Line 2064: IF l_return_status= fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

2060: trace('l_gtin_serial :'||l_gtin_serial);
2061: END IF;
2062:
2063:
2064: IF l_return_status= fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
2065:
2066: l_item_reference :=
2067: To_number(Substr(To_char(l_gtin),1,1)||Substr(To_char(l_gtin),l_comp_prefix_dig_len+2,12-l_comp_prefix_dig_len));
2068:

Line 2109: RAISE fnd_api.g_exc_error;

2105: trace('Error:For Serial, No EPC can be generated using SSCC, incorrect SET up');
2106: END IF;
2107: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
2108: FND_MSG_PUB.ADD;
2109: RAISE fnd_api.g_exc_error;
2110:
2111: ELSIF p_epc_rule_type IN ('USDOD-96','USDOD-64') THEN
2112: --{{Note: We MUST have Serial uniqueness across items for EPC generation EPC_DOD_96/EPC_DOD_64}}
2113:

Line 2147: WHEN fnd_api.g_exc_error THEN

2143: x_components := l_components;
2144:
2145:
2146: EXCEPTION
2147: WHEN fnd_api.g_exc_error THEN
2148: x_return_status := fnd_api.g_ret_sts_error;
2149: x_gtin_serial := NULL;
2150: x_gtin :=NULL;
2151: x_sscc := NULL;

Line 2148: x_return_status := fnd_api.g_ret_sts_error;

2144:
2145:
2146: EXCEPTION
2147: WHEN fnd_api.g_exc_error THEN
2148: x_return_status := fnd_api.g_ret_sts_error;
2149: x_gtin_serial := NULL;
2150: x_gtin :=NULL;
2151: x_sscc := NULL;
2152: x_components := NULL;

Line 2155: WHEN fnd_api.g_exc_unexpected_error THEN

2151: x_sscc := NULL;
2152: x_components := NULL;
2153: --RAISE; -- Do not raise here
2154:
2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156: x_return_status := fnd_api.g_ret_sts_unexp_error;
2157: x_gtin_serial := NULL;
2158: x_gtin :=NULL;
2159: x_sscc := NULL;

Line 2156: x_return_status := fnd_api.g_ret_sts_unexp_error;

2152: x_components := NULL;
2153: --RAISE; -- Do not raise here
2154:
2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156: x_return_status := fnd_api.g_ret_sts_unexp_error;
2157: x_gtin_serial := NULL;
2158: x_gtin :=NULL;
2159: x_sscc := NULL;
2160: x_components := NULL;

Line 2170: x_return_status := fnd_api.g_ret_sts_unexp_error;

2166: trace('Unexpected error inside get_epc_gen_info()');
2167: trace('ERROR CODE = ' || SQLCODE);
2168: trace('ERROR MESSAGE = ' || SQLERRM);
2169: END IF;
2170: x_return_status := fnd_api.g_ret_sts_unexp_error;
2171: x_gtin_serial := NULL;
2172: x_gtin := NULL;
2173: x_sscc := NULL;
2174: x_components := NULL;

Line 2268: x_return_status := fnd_api.g_ret_sts_success;

2264:
2265: BEGIN
2266:
2267: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');
2268: x_return_status := fnd_api.g_ret_sts_success;
2269:
2270:
2271: IF l_debug = 1 THEN
2272: trace('************ inside generate_epc ***********');

Line 2302: RAISE fnd_api.g_exc_error;

2298: trace(p_org_id || 'is an invalid organization id');
2299: END IF;
2300: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
2301: fnd_msg_pub.ADD;
2302: RAISE fnd_api.g_exc_error;
2303: END IF;
2304:
2305: l_company_prefix := inv_cache.org_rec.company_prefix;
2306: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;

Line 2374: RAISE fnd_api.g_exc_unexpected_error;

2370: END IF;
2371:
2372: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2373: fnd_msg_pub.ADD;
2374: RAISE fnd_api.g_exc_unexpected_error;
2375: END;
2376:
2377: --Neither pallet or case, then NO support FOR EPC of further
2378: -- nested lpn, error out

Line 2384: RAISE fnd_api.g_exc_error;

2380: OR (l_parent_lpn_id = l_outermost_lpn_id AND l_parent_lpn_id IS NOT null)) THEN
2381:
2382: fnd_message.set_name('WMS', 'WMS_NO_MULTI_NESTING_SUPPORT');
2383: fnd_msg_pub.ADD;
2384: RAISE fnd_api.g_exc_error;
2385:
2386: END IF;
2387:
2388: --For Serial

Line 2404: RAISE fnd_api.g_exc_unexpected_error;

2400: EXCEPTION
2401: WHEN no_data_found THEN
2402: NULL;
2403: WHEN OTHERS THEN
2404: RAISE fnd_api.g_exc_unexpected_error;
2405: END;
2406:
2407: --For item_id/GTIN
2408: ELSIF l_item_id IS NOT NULL AND p_label_type_id = 1 THEN --/*Material Label*/

Line 2517: IF l_return_status = fnd_api.g_ret_sts_success AND l_components IS NOT NULL THEN

2513:
2514:
2515: --{{ genereate EPC using the components }}
2516:
2517: IF l_return_status = fnd_api.g_ret_sts_success AND l_components IS NOT NULL THEN
2518: IF l_debug = 1 THEN
2519: trace('Before calling DB EPC category_name :'||DBMS_MGD_ID_UTL.get_category_id('EPC',NULL));
2520: END IF;
2521:

Line 2586: RAISE fnd_api.g_exc_error;

2582: END IF;
2583:
2584: fnd_message.set_name('WMS', 'WMS_EPC_DISABLED');
2585: fnd_msg_pub.ADD;
2586: RAISE fnd_api.g_exc_error;
2587:
2588: END IF;
2589:
2590:

Line 2672: RAISE fnd_api.g_exc_error;--COULD NOT OVERIDE THE EPC

2668: IF l_debug =1 then
2669: trace(' uptodate_wms_epc DELETE: L_RETURN_STATUS:'||l_return_status);
2670: END IF;
2671:
2672: RAISE fnd_api.g_exc_error;--COULD NOT OVERIDE THE EPC
2673:
2674:
2675: ELSIF l_epc IS NULL AND l_gen_epc IS NOT NULL THEN
2676:

Line 2708: RAISE fnd_api.g_exc_error;

2704:
2705:
2706: ELSIF l_epc IS NULL AND l_gen_epc IS NULL THEN
2707:
2708: RAISE fnd_api.g_exc_error;
2709:
2710: END IF;
2711:
2712: ELSIF Nvl(l_regenerate_flag,'N') = 'N' THEN

Line 2736: WHEN fnd_api.g_exc_error THEN

2732: DBMS_MGD_ID_UTL.REMOVE_PROXY;
2733:
2734: EXCEPTION
2735:
2736: WHEN fnd_api.g_exc_error THEN
2737: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
2738: fnd_msg_pub.ADD;
2739: x_return_status := fnd_api.g_ret_sts_error;
2740: x_epc := NULL;

Line 2739: x_return_status := fnd_api.g_ret_sts_error;

2735:
2736: WHEN fnd_api.g_exc_error THEN
2737: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
2738: fnd_msg_pub.ADD;
2739: x_return_status := fnd_api.g_ret_sts_error;
2740: x_epc := NULL;
2741: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);
2742:
2743: FOR i IN 1..l_msg_count LOOP

Line 2755: WHEN fnd_api.g_exc_unexpected_error THEN

2751:
2752: -- FND_MSG_PUB.initialize; --bug 5178424
2753:
2754:
2755: WHEN fnd_api.g_exc_unexpected_error THEN
2756: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2757: fnd_msg_pub.ADD;
2758: x_return_status := fnd_api.g_ret_sts_unexp_error;
2759: x_epc := NULL;

Line 2758: x_return_status := fnd_api.g_ret_sts_unexp_error;

2754:
2755: WHEN fnd_api.g_exc_unexpected_error THEN
2756: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2757: fnd_msg_pub.ADD;
2758: x_return_status := fnd_api.g_ret_sts_unexp_error;
2759: x_epc := NULL;
2760: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2761:
2762: FOR i IN 1..l_msg_count LOOP

Line 2775: x_return_status := fnd_api.g_ret_sts_unexp_error;

2771: -- FND_MSG_PUB.initialize; --bug 5178424
2772:
2773: WHEN OTHERS THEN
2774: --ROLLBACK; blocked in R12
2775: x_return_status := fnd_api.g_ret_sts_unexp_error;
2776: x_epc := NULL;
2777: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2778:
2779: FOR i IN 1..l_msg_count LOOP

Line 2826: x_return_status := fnd_api.g_ret_sts_success;

2822: l_epc_id NUMBER;
2823: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2824: BEGIN
2825:
2826: x_return_status := fnd_api.g_ret_sts_success;
2827:
2828: IF l_debug = 1 THEN
2829: trace('************UPtoDATE WMS_EPC with old RFID model***');
2830: trace('p_action :'|| p_action );

Line 3077: x_return_status := fnd_api.g_ret_sts_error;

3073: COMMIT;
3074:
3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: x_return_status := fnd_api.g_ret_sts_error;
3078: IF l_debug = 1 THEN
3079: TRACE('UPTODATE WMS_EPC: inside exception');
3080: TRACE('ERROR CODE = ' || SQLCODE);
3081: TRACE('ERROR MESSAGE = ' || SQLERRM);

Line 3207: x_return_status := fnd_api.g_ret_sts_success;

3203:
3204:
3205: BEGIN
3206:
3207: x_return_status := fnd_api.g_ret_sts_success;
3208:
3209: IF p_label_type_id IN (3,4,5) THEN --LPN, LPN Content, LPN Summary
3210:
3211: l_comp_prefix_dig_len:= Length(p_company_prefix);

Line 3227: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

3223:
3224: --{{ get the item reference from GTIN for LPN now }}
3225: --{{ l_gtin obtained IS NOT NULL }}
3226:
3227: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
3228:
3229: l_item_reference := To_number(Substr(To_char(l_gtin),1,1)||Substr(To_char(l_gtin),l_comp_prefix_dig_len+2,12-l_comp_prefix_dig_len));
3230:
3231: IF l_debug = 1 THEN

Line 3327: RAISE fnd_api.g_exc_error;

3323: IF l_debug = 1 THEN
3324: trace('Error : Incorrect SSCC value set up for the LPN');
3325: END IF;
3326:
3327: RAISE fnd_api.g_exc_error;
3328: END IF;
3329:
3330:
3331: ELSIF p_epc_rule_type IN ('EPC_DOD_96','EPC_DOD_64') THEN

Line 3340: RAISE fnd_api.g_exc_error;

3336: trace('Error:For LPN label, No EPC can be generated using EPC_DOD_96/64, incorrect SET up');
3337: END IF;
3338: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
3339: FND_MSG_PUB.ADD;
3340: RAISE fnd_api.g_exc_error;
3341: END IF;
3342:
3343: ELSIF p_label_type_id =1 THEN /*Material Label*/
3344:

Line 3366: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

3362: x_return_status => l_return_status);
3363:
3364:
3365:
3366: IF l_return_status = fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
3367:
3368:
3369: --{{ get the item reference from GTIN for the Item now }}
3370:

Line 3419: RAISE fnd_api.g_exc_error;

3415: END IF;
3416:
3417: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
3418: FND_MSG_PUB.ADD;
3419: RAISE fnd_api.g_exc_error;
3420:
3421:
3422: ELSIF p_epc_rule_type IN ('EPC_DOD_96','EPC_DOD_64') THEN
3423:

Line 3429: RAISE fnd_api.g_exc_error;

3425: trace('Error:For Material, No EPC can be generated using EPC_DOD, incorrect SET up');
3426: END IF;
3427: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
3428: FND_MSG_PUB.ADD;
3429: RAISE fnd_api.g_exc_error;
3430:
3431:
3432: END IF;
3433:

Line 3472: IF l_return_status= fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN

3468: trace('l_gtin_serial :'||l_gtin_serial);
3469: END IF;
3470:
3471:
3472: IF l_return_status= fnd_api.g_ret_sts_success AND l_gtin IS NOT NULL THEN
3473:
3474: l_item_reference :=
3475: To_number(Substr(To_char(l_gtin),1,1)||Substr(To_char(l_gtin),l_comp_prefix_dig_len+2,12-l_comp_prefix_dig_len));
3476:

Line 3515: RAISE fnd_api.g_exc_error;

3511: trace('Error:For Serial, No EPC can be generated using SSCC, incorrect SET up');
3512: END IF;
3513: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
3514: FND_MSG_PUB.ADD;
3515: RAISE fnd_api.g_exc_error;
3516:
3517: ELSIF p_epc_rule_type IN ('EPC_DOD_96','EPC_DOD_64') THEN
3518: --{{Note: We MUST have Serial uniqueness across items for EPC generation EPC_DOD_96/EPC_DOD_64}}
3519:

Line 3556: WHEN fnd_api.g_exc_error THEN

3552: x_components := l_components;
3553:
3554:
3555: EXCEPTION
3556: WHEN fnd_api.g_exc_error THEN
3557: x_return_status := fnd_api.g_ret_sts_error;
3558: x_gtin_serial := NULL;
3559: x_gtin :=NULL;
3560: x_sscc := NULL;

Line 3557: x_return_status := fnd_api.g_ret_sts_error;

3553:
3554:
3555: EXCEPTION
3556: WHEN fnd_api.g_exc_error THEN
3557: x_return_status := fnd_api.g_ret_sts_error;
3558: x_gtin_serial := NULL;
3559: x_gtin :=NULL;
3560: x_sscc := NULL;
3561: x_components := NULL;

Line 3564: WHEN fnd_api.g_exc_unexpected_error THEN

3560: x_sscc := NULL;
3561: x_components := NULL;
3562: --RAISE; -- Do not raise here
3563:
3564: WHEN fnd_api.g_exc_unexpected_error THEN
3565: x_return_status := fnd_api.g_ret_sts_unexp_error;
3566: x_gtin_serial := NULL;
3567: x_gtin :=NULL;
3568: x_sscc := NULL;

Line 3565: x_return_status := fnd_api.g_ret_sts_unexp_error;

3561: x_components := NULL;
3562: --RAISE; -- Do not raise here
3563:
3564: WHEN fnd_api.g_exc_unexpected_error THEN
3565: x_return_status := fnd_api.g_ret_sts_unexp_error;
3566: x_gtin_serial := NULL;
3567: x_gtin :=NULL;
3568: x_sscc := NULL;
3569: x_components := NULL;

Line 3579: x_return_status := fnd_api.g_ret_sts_unexp_error;

3575: trace('Unexpected error inside get_epc_gen_info()');
3576: trace('ERROR CODE = ' || SQLCODE);
3577: trace('ERROR MESSAGE = ' || SQLERRM);
3578: END IF;
3579: x_return_status := fnd_api.g_ret_sts_unexp_error;
3580: x_gtin_serial := NULL;
3581: x_gtin := NULL;
3582: x_sscc := NULL;
3583: x_components := NULL;

Line 3783: x_return_status := fnd_api.g_ret_sts_success;

3779:
3780: BEGIN
3781:
3782: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');
3783: x_return_status := fnd_api.g_ret_sts_success;
3784:
3785: IF l_debug = 1 THEN
3786: trace('************ inside generate_epc ***********');
3787: trace('p_org_id :'||p_org_id);

Line 3807: RAISE fnd_api.g_exc_error;

3803: trace(p_org_id || 'is an invalid organization id');
3804: END IF;
3805: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
3806: fnd_msg_pub.ADD;
3807: RAISE fnd_api.g_exc_error;
3808: END IF;
3809:
3810: l_company_prefix := inv_cache.org_rec.company_prefix;
3811: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;

Line 3879: RAISE fnd_api.g_exc_unexpected_error;

3875: END IF;
3876:
3877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
3878: fnd_msg_pub.ADD;
3879: RAISE fnd_api.g_exc_unexpected_error;
3880: END;
3881:
3882: --Neither pallet or case, then NO support FOR EPC of further
3883: -- nested lpn, error out

Line 3889: RAISE fnd_api.g_exc_error;

3885: OR (l_parent_lpn_id = l_outermost_lpn_id AND l_parent_lpn_id IS NOT null)) THEN
3886:
3887: fnd_message.set_name('WMS', 'WMS_NO_MULTI_NESTING_SUPPORT');
3888: fnd_msg_pub.ADD;
3889: RAISE fnd_api.g_exc_error;
3890:
3891: END IF;
3892:
3893: --For Serial

Line 3909: RAISE fnd_api.g_exc_unexpected_error;

3905: EXCEPTION
3906: WHEN no_data_found THEN
3907: NULL;
3908: WHEN OTHERS THEN
3909: RAISE fnd_api.g_exc_unexpected_error;
3910: END;
3911:
3912: --For item_id/GTIN
3913: ELSIF l_item_id IS NOT NULL AND p_label_type_id = 1 THEN --/*Material Label*/

Line 3970: RAISE fnd_api.g_exc_error;

3966:
3967: IF l_partition_value = -1 THEN --prefix length is INCORRECT
3968: fnd_message.set_name('WMS','WMS_INCORRECT_PREFIX_LEN');
3969: fnd_msg_pub.ADD;
3970: RAISE fnd_api.g_exc_error;
3971:
3972: ELSE
3973: --To avoid DB table call for each read:
3974: --Cache Entire rule in the memory if first time call

Line 3992: RAISE fnd_api.g_exc_error;

3988: IF l_epc_rule_type_id IS NULL THEN
3989: x_epc := NULL;
3990: fnd_message.set_name('WMS','WMS_NO_EPC_RULE_FOUND');--No rule found
3991: fnd_msg_pub.ADD;
3992: RAISE fnd_api.g_exc_error;
3993: END IF;
3994:
3995:
3996: IF l_debug = 1 THEN

Line 4063: IF l_return_status = fnd_api.g_ret_sts_success AND l_components IS NOT NULL THEN

4059:
4060:
4061: --{{ genereate EPC using the components }}
4062:
4063: IF l_return_status = fnd_api.g_ret_sts_success AND l_components IS NOT NULL THEN
4064:
4065:
4066: -- This is needed to pass correct value (NULL Vs 0)in the DB API
4067: --In some case NULL and anohter 0 is needed

Line 4143: RAISE fnd_api.g_exc_error;

4139: END IF;
4140:
4141: fnd_message.set_name('WMS', 'WMS_EPC_DISABLED');
4142: fnd_msg_pub.ADD;
4143: RAISE fnd_api.g_exc_error;
4144:
4145: END IF;
4146:
4147:

Line 4227: RAISE fnd_api.g_exc_error;--COULD NOT OVERIDE THE EPC

4223: IF l_debug =1 then
4224: trace(' uptodate_wms_epc DELETE: L_RETURN_STATUS:'||l_return_status);
4225: END IF;
4226:
4227: RAISE fnd_api.g_exc_error;--COULD NOT OVERIDE THE EPC
4228:
4229:
4230: ELSIF l_epc IS NULL AND l_gen_epc IS NOT NULL THEN
4231:

Line 4263: RAISE fnd_api.g_exc_error;

4259:
4260:
4261: ELSIF l_epc IS NULL AND l_gen_epc IS NULL THEN
4262:
4263: RAISE fnd_api.g_exc_error;
4264:
4265: END IF;
4266:
4267: ELSIF Nvl(l_regenerate_flag,'N') = 'N' THEN

Line 4291: WHEN fnd_api.g_exc_error THEN

4287:
4288:
4289: EXCEPTION
4290:
4291: WHEN fnd_api.g_exc_error THEN
4292: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
4293: fnd_msg_pub.ADD;
4294: x_return_status := fnd_api.g_ret_sts_error;
4295: x_epc := NULL;

Line 4294: x_return_status := fnd_api.g_ret_sts_error;

4290:
4291: WHEN fnd_api.g_exc_error THEN
4292: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
4293: fnd_msg_pub.ADD;
4294: x_return_status := fnd_api.g_ret_sts_error;
4295: x_epc := NULL;
4296: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);
4297:
4298: FOR i IN 1..l_msg_count LOOP

Line 4310: WHEN fnd_api.g_exc_unexpected_error THEN

4306:
4307: -- FND_MSG_PUB.initialize; --bug 5178424
4308:
4309:
4310: WHEN fnd_api.g_exc_unexpected_error THEN
4311: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
4312: fnd_msg_pub.ADD;
4313: x_return_status := fnd_api.g_ret_sts_unexp_error;
4314: x_epc := NULL;

Line 4313: x_return_status := fnd_api.g_ret_sts_unexp_error;

4309:
4310: WHEN fnd_api.g_exc_unexpected_error THEN
4311: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
4312: fnd_msg_pub.ADD;
4313: x_return_status := fnd_api.g_ret_sts_unexp_error;
4314: x_epc := NULL;
4315: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
4316:
4317: FOR i IN 1..l_msg_count LOOP

Line 4330: x_return_status := fnd_api.g_ret_sts_unexp_error;

4326: -- FND_MSG_PUB.initialize; --bug 5178424
4327:
4328: WHEN OTHERS THEN
4329: --ROLLBACK; blocked in R12
4330: x_return_status := fnd_api.g_ret_sts_unexp_error;
4331: x_epc := NULL;
4332: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
4333:
4334: FOR i IN 1..l_msg_count LOOP