DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on FND_MESSAGE

Line 530: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN');

526: IF l_debug = 1 then
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:

Line 537: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN');

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

Line 563: fnd_message.set_name('WMS', 'WMS_INVALID_GTIN_GSERIAL');

559: x_gtin_serial := get_serial_for_gtin(l_gtin, p_org_id, p_item_id, l_uom_code,l_rev_id);
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;

Line 570: fnd_message.set_name('WMS', 'WMS_NO_GTIN_FOUND');

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

Line 1024: fnd_message.set_name('WMS', 'WMS_NO_GTIN_FOUND');

1020: x_return_status => x_return_status);
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

Line 1109: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');

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

Line 1211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');

1207: IF (l_debug = 1) THEN
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:

Line 1296: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SSCC');

1292: l_lpn_num_format := To_number(l_sscc);--ensure Numeric Only
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:

Line 1304: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SSCC');

1300:
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;

Line 1359: x_return_mesg := fnd_message.get_string('WMS','WMS_EPC_MISSING_VALUES');

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
1363: (p_item_id IS NULL OR p_serial_number IS NULL ) AND

Line 1367: x_return_mesg := fnd_message.get_string('WMS','WMS_EPC_MISSING_VALUES');

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:
1371: INSERT INTO wms_epc( group_id,

Line 1926: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

1922: --This is INVALID option for EPC generation FOR LPN label
1923: IF l_debug = 1 THEN
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:

Line 2009: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

2005: IF l_debug = 1 THEN
2006: trace('Error:For Material, No EPC can be generated using SSCC, incorrect SET up');
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:

Line 2019: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

2015:
2016: IF l_debug = 1 THEN
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:

Line 2107: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

2103: --This is INVALID option for EPC generation of Serial NUMBER
2104: IF l_debug = 1 THEN
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

Line 2300: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');

2296: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
2297: IF (l_debug = 1) THEN
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:

Line 2372: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

2368: IF l_debug = 1 THEN
2369: trace('NO DATA found for the LPN');
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:

Line 2382: fnd_message.set_name('WMS', 'WMS_NO_MULTI_NESTING_SUPPORT');

2378: -- nested lpn, error out
2379: IF NOT ((l_outermost_lpn_id = l_lpn_id AND l_parent_lpn_id IS null )
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;

Line 2548: fnd_message.set_name('WMS', 'WMS_DB_EPC_GEN_FAIL');

2544: TRACE('ERROR MESSAGE = ' || SQLERRM);
2545: END IF;
2546:
2547: --EPC generation failed at DB feature level
2548: fnd_message.set_name('WMS', 'WMS_DB_EPC_GEN_FAIL');
2549: fnd_msg_pub.ADD;
2550:
2551: --Do not raise exception here as we want to delete
2552: --old cross-reference RECORD FROM wms_epc for some

Line 2565: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');

2561: trace('Error: Components could not be obtained for EPC generation ');
2562: END IF;
2563:
2564:
2565: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
2566: fnd_msg_pub.ADD;
2567:
2568: --Do not raise exception here as we want to delete
2569: --old cross-reference RECORD FROM wms_epc for some

Line 2584: fnd_message.set_name('WMS', 'WMS_EPC_DISABLED');

2580: IF l_debug = 1 THEN
2581: trace('EPC generation is NOT enabled at Orgnization level');
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;

Line 2737: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');

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;
2741: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);

Line 2756: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');

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;
2760: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);

Line 3338: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

3334: --This is INVALID option for EPC generation FOR LPN label
3335: IF l_debug = 1 THEN
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:

Line 3417: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

3413: IF l_debug = 1 THEN
3414: trace('Error:For Material, No EPC can be generated using SSCC, incorrect SET up');
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:

Line 3427: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

3423:
3424: IF l_debug = 1 THEN
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:

Line 3513: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_SETUP');

3509: --This is INVALID option for EPC generation of Serial NUMBER
3510: IF l_debug = 1 THEN
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

Line 3805: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');

3801: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
3802: IF (l_debug = 1) THEN
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:

Line 3877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

3873: IF l_debug = 1 THEN
3874: trace('NO DATA found for the LPN');
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:

Line 3887: fnd_message.set_name('WMS', 'WMS_NO_MULTI_NESTING_SUPPORT');

3883: -- nested lpn, error out
3884: IF NOT ((l_outermost_lpn_id = l_lpn_id AND l_parent_lpn_id IS null )
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;

Line 3968: fnd_message.set_name('WMS','WMS_INCORRECT_PREFIX_LEN');

3964:
3965: --{{ see if partition value returned is correct and get the l_epc_rule_type_id now}}
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

Line 3990: fnd_message.set_name('WMS','WMS_NO_EPC_RULE_FOUND');--No rule found

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

Line 4105: fnd_message.set_name('WMS', 'WMS_DB_EPC_GEN_FAIL');

4101: TRACE('ERROR MESSAGE = ' || SQLERRM);
4102: END IF;
4103:
4104: --EPC generation failed at DB feature level
4105: fnd_message.set_name('WMS', 'WMS_DB_EPC_GEN_FAIL');
4106: fnd_msg_pub.ADD;
4107:
4108: --Do not raise exception here as we want to delete
4109: --old cross-reference RECORD FROM wms_epc for some

Line 4122: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');

4118: trace('Error: Components could not be obtained for EPC generation ');
4119: END IF;
4120:
4121:
4122: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');
4123: fnd_msg_pub.ADD;
4124:
4125: --Do not raise exception here as we want to delete
4126: --old cross-reference RECORD FROM wms_epc for some

Line 4141: fnd_message.set_name('WMS', 'WMS_EPC_DISABLED');

4137: IF l_debug = 1 THEN
4138: trace('EPC generation is NOT enabled at Orgnization level');
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;

Line 4292: fnd_message.set_name('WMS','WMS_EPC_GEN_FAIL');

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;
4296: fnd_msg_pub.count_and_get(p_encoded => 'F',p_count => l_msg_count, p_data => x_return_mesg);

Line 4311: fnd_message.set_name('WMS', 'WMS_EPC_GEN_FAIL');

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;
4315: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => x_return_mesg);