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_MSG_PUB

Line 531: fnd_msg_pub.ADD;

527: trace('Error gtin not 14 digit ');
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

Line 538: fnd_msg_pub.ADD;

534:
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:

Line 564: fnd_msg_pub.ADD;

560:
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:

Line 571: fnd_msg_pub.ADD;

567: END IF;
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:

Line 1025: fnd_msg_pub.ADD;

1021:
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:

Line 1110: fnd_msg_pub.ADD;

1106:
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:

Line 1212: fnd_msg_pub.ADD;

1208: trace('Got Item info puom='||inv_cache.item_rec.primary_uom_code);
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:

Line 1297: FND_MSG_PUB.ADD;

1293:
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

Line 1305: FND_MSG_PUB.ADD;

1301: EXCEPTION
1302: WHEN OTHERS THEN --catch the exception for alphanumeric case
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:

Line 1864: FND_MSG_PUB.ADD;

1860: IF l_debug = 1 THEN
1861: trace('Error:For LPN label, No EPC can be generated using EPC_DOD_96/64, incorrect SET up');
1862: END IF;
1863: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
1864: FND_MSG_PUB.ADD;
1865: RAISE fnd_api.g_exc_error;
1866: END IF;
1867:
1868: ELSIF p_label_type_id =1 THEN /*Material Label*/

Line 1943: FND_MSG_PUB.ADD;

1939: trace('Error:For Material, No EPC can be generated using SSCC, incorrect SET up');
1940: END IF;
1941:
1942: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
1943: FND_MSG_PUB.ADD;
1944: RAISE fnd_api.g_exc_error;
1945:
1946:
1947: ELSIF p_epc_rule_type IN ('EPC_DOD_96','EPC_DOD_64') THEN

Line 1953: FND_MSG_PUB.ADD;

1949: IF l_debug = 1 THEN
1950: trace('Error:For Material, No EPC can be generated using EPC_DOD, incorrect SET up');
1951: END IF;
1952: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
1953: FND_MSG_PUB.ADD;
1954: RAISE fnd_api.g_exc_error;
1955:
1956:
1957: END IF;

Line 2039: FND_MSG_PUB.ADD;

2035: IF l_debug = 1 THEN
2036: trace('Error:For Serial, No EPC can be generated using SSCC, incorrect SET up');
2037: END IF;
2038: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');
2039: FND_MSG_PUB.ADD;
2040: RAISE fnd_api.g_exc_error;
2041:
2042: ELSIF p_epc_rule_type IN ('EPC_DOD_96','EPC_DOD_64') THEN
2043: --{{Note: We MUST have Serial uniqueness across items for EPC generation EPC_DOD_96/EPC_DOD_64}}

Line 2331: fnd_msg_pub.ADD;

2327: IF (l_debug = 1) THEN
2328: trace(p_org_id || 'is an invalid organization id');
2329: END IF;
2330: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
2331: fnd_msg_pub.ADD;
2332: RAISE fnd_api.g_exc_error;
2333: END IF;
2334:
2335: l_company_prefix := inv_cache.org_rec.company_prefix;

Line 2403: fnd_msg_pub.ADD;

2399: trace('NO DATA found for the LPN');
2400: END IF;
2401:
2402: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2403: fnd_msg_pub.ADD;
2404: RAISE fnd_api.g_exc_unexpected_error;
2405: END;
2406:
2407: --Neither pallet or case, then NO support FOR EPC of further

Line 2413: fnd_msg_pub.ADD;

2409: IF NOT ((l_outermost_lpn_id = l_lpn_id AND l_parent_lpn_id IS null )
2410: OR (l_parent_lpn_id = l_outermost_lpn_id AND l_parent_lpn_id IS NOT null)) THEN
2411:
2412: fnd_message.set_name('WMS', 'WMS_NO_MULTI_NESTING_SUPPORT');
2413: fnd_msg_pub.ADD;
2414: RAISE fnd_api.g_exc_error;
2415:
2416: END IF;
2417:

Line 2494: fnd_msg_pub.ADD;

2490: --{{ see if partition value returned is correct and get the l_epc_rule_type_id now}}
2491:
2492: IF l_partition_value = -1 THEN --prefix length is INCORRECT
2493: fnd_message.set_name('WMS','WMS_INCORRECT_PREFIX_LEN');
2494: fnd_msg_pub.ADD;
2495: RAISE fnd_api.g_exc_error;
2496:
2497: ELSE
2498: --To avoid DB table call for each read:

Line 2516: fnd_msg_pub.ADD;

2512:
2513: IF l_epc_rule_type_id IS NULL THEN
2514: x_epc := NULL;
2515: fnd_message.set_name('WMS','WMS_NO_EPC_RULE_FOUND');--No rule found
2516: fnd_msg_pub.ADD;
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520:

Line 2631: fnd_msg_pub.ADD;

2627: END IF;
2628:
2629: --EPC generation failed at DB feature level
2630: fnd_message.set_name('WMS', 'WMS_DB_EPC_GEN_FAIL');
2631: fnd_msg_pub.ADD;
2632:
2633: --Do not raise exception here as we want to delete
2634: --old cross-reference RECORD FROM wms_epc for some
2635: --CASES BELOW

Line 2648: fnd_msg_pub.ADD;

2644: END IF;
2645:
2646:
2647: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2648: fnd_msg_pub.ADD;
2649:
2650: --Do not raise exception here as we want to delete
2651: --old cross-reference RECORD FROM wms_epc for some
2652: --CASES BELOW

Line 2667: fnd_msg_pub.ADD;

2663: trace('EPC generation is NOT enabled at Orgnization level');
2664: END IF;
2665:
2666: fnd_message.set_name('WMS', 'WMS_EPC_DISABLED');
2667: fnd_msg_pub.ADD;
2668: RAISE fnd_api.g_exc_error;
2669:
2670: END IF;
2671:

Line 2818: fnd_msg_pub.ADD;

2814: EXCEPTION
2815:
2816: WHEN fnd_api.g_exc_error THEN
2817: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
2818: fnd_msg_pub.ADD;
2819: x_return_status := fnd_api.g_ret_sts_error;
2820: x_epc := NULL;
2821: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);
2822:

Line 2821: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);

2817: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');
2818: fnd_msg_pub.ADD;
2819: x_return_status := fnd_api.g_ret_sts_error;
2820: x_epc := NULL;
2821: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);
2822:
2823: FOR i IN 1..l_msg_count LOOP
2824: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2825: END LOOP;

Line 2824: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');

2820: x_epc := NULL;
2821: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);
2822:
2823: FOR i IN 1..l_msg_count LOOP
2824: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2825: END LOOP;
2826:
2827: IF l_debug = 1 THEN
2828: TRACE('Inside g_exc_error l_msg_count :'||l_msg_count);

Line 2832: -- FND_MSG_PUB.initialize; --bug 5178424

2828: TRACE('Inside g_exc_error l_msg_count :'||l_msg_count);
2829: TRACE('x_return_mesg :'||x_return_mesg);
2830: END IF;
2831:
2832: -- FND_MSG_PUB.initialize; --bug 5178424
2833:
2834:
2835: WHEN fnd_api.g_exc_unexpected_error THEN
2836: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');

Line 2837: fnd_msg_pub.ADD;

2833:
2834:
2835: WHEN fnd_api.g_exc_unexpected_error THEN
2836: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2837: fnd_msg_pub.ADD;
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: x_epc := NULL;
2840: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2841:

Line 2840: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);

2836: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2837: fnd_msg_pub.ADD;
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: x_epc := NULL;
2840: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2841:
2842: FOR i IN 1..l_msg_count LOOP
2843: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2844: END LOOP;

Line 2843: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');

2839: x_epc := NULL;
2840: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2841:
2842: FOR i IN 1..l_msg_count LOOP
2843: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2844: END LOOP;
2845:
2846: IF l_debug = 1 THEN
2847: TRACE('Inside g_exc_unexpected_error l_msg_count :'||l_msg_count);

Line 2851: -- FND_MSG_PUB.initialize; --bug 5178424

2847: TRACE('Inside g_exc_unexpected_error l_msg_count :'||l_msg_count);
2848: TRACE('x_return_mesg :'||x_return_mesg);
2849: END IF;
2850:
2851: -- FND_MSG_PUB.initialize; --bug 5178424
2852:
2853: WHEN OTHERS THEN
2854: --ROLLBACK; blocked in R12
2855: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2857: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);

2853: WHEN OTHERS THEN
2854: --ROLLBACK; blocked in R12
2855: x_return_status := fnd_api.g_ret_sts_unexp_error;
2856: x_epc := NULL;
2857: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2858:
2859: FOR i IN 1..l_msg_count LOOP
2860: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2861: END LOOP;

Line 2860: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');

2856: x_epc := NULL;
2857: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);
2858:
2859: FOR i IN 1..l_msg_count LOOP
2860: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2861: END LOOP;
2862:
2863: -- FND_MSG_PUB.initialize; --bug 5178424
2864:

Line 2863: -- FND_MSG_PUB.initialize; --bug 5178424

2859: FOR i IN 1..l_msg_count LOOP
2860: x_return_mesg := x_return_mesg || fnd_msg_pub.get(I,'F');
2861: END LOOP;
2862:
2863: -- FND_MSG_PUB.initialize; --bug 5178424
2864:
2865: IF l_debug = 1 THEN
2866: TRACE('generate EPC: Inside exception');
2867: TRACE('ERROR CODE = ' || SQLCODE);