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.AHL_OSP_SHIPMENT_PUB dependencies on FND_MESSAGE

Line 206: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');

202: -- 3 = Dynamic Entry at inventory receipt.)
203: IF (nvl(p_serial_number_control,0) IN (2,5,6)) THEN
204: -- serial number is mandatory.
205: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN
206: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');
207: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
208: FND_MSG_PUB.ADD;
209: --dbms_output.put_line('Serial Number is null');
210: /*

Line 207: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

203: IF (nvl(p_serial_number_control,0) IN (2,5,6)) THEN
204: -- serial number is mandatory.
205: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN
206: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');
207: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
208: FND_MSG_PUB.ADD;
209: --dbms_output.put_line('Serial Number is null');
210: /*
211: ELSE

Line 217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');

213: IF (p_serialnum_tag_code = 'INVENTORY') THEN
214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
220: FND_MSG_PUB.ADD;
221: --dbms_output.put_line('Serial Number does not exist in master ');

Line 218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);

214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
220: FND_MSG_PUB.ADD;
221: --dbms_output.put_line('Serial Number does not exist in master ');
222: END IF;

Line 219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
220: FND_MSG_PUB.ADD;
221: --dbms_output.put_line('Serial Number does not exist in master ');
222: END IF;
223: CLOSE mtl_serial_numbers_csr;

Line 230: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');

226: END IF;
227: ELSE
228: -- if not serialized item, then serial number must be null.
229: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
230: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
231: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
232: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
233: FND_MSG_PUB.ADD;
234: --dbms_output.put_line('Serial Number is not null');

Line 231: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);

227: ELSE
228: -- if not serialized item, then serial number must be null.
229: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
230: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
231: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
232: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
233: FND_MSG_PUB.ADD;
234: --dbms_output.put_line('Serial Number is not null');
235: END IF;

Line 232: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

228: -- if not serialized item, then serial number must be null.
229: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
230: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
231: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
232: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
233: FND_MSG_PUB.ADD;
234: --dbms_output.put_line('Serial Number is not null');
235: END IF;
236:

Line 405: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

401:
402: -- Start processing
403:
404: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
405: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
406: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
407: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
408: FND_MSG_PUB.ADD;
409: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 406: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');

402: -- Start processing
403:
404: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
405: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
406: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
407: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
408: FND_MSG_PUB.ADD;
409: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 407: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));

403:
404: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
405: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
406: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
407: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
408: FND_MSG_PUB.ADD;
409: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
411: END IF;

Line 416: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

412: RAISE Fnd_Api.g_exc_error;
413: END IF;
414:
415: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
416: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
417: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
418: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
419: FND_MSG_PUB.ADD;
420: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 417: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');

413: END IF;
414:
415: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
416: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
417: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
418: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
419: FND_MSG_PUB.ADD;
420: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 418: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));

414:
415: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
416: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
417: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
418: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
419: FND_MSG_PUB.ADD;
420: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
422: END IF;

Line 427: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

423: RAISE Fnd_Api.g_exc_error;
424: END IF;
425:
426: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
427: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
428: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
429: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
430: FND_MSG_PUB.ADD;
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 428: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');

424: END IF;
425:
426: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
427: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
428: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
429: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
430: FND_MSG_PUB.ADD;
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 429: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));

425:
426: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
427: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
428: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
429: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
430: FND_MSG_PUB.ADD;
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
433: END IF;

Line 466: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_OSP_LN_INV_LOV');

462: IF (p_x_lines_tbl(i).osp_line_flag <> 'N') THEN
463: OPEN is_osp_line_id_valid_csr(p_x_lines_tbl(i).osp_line_id, p_x_lines_tbl(i).osp_order_id);
464: FETCH is_osp_line_id_valid_csr into l_dummy;
465: IF (is_osp_line_id_valid_csr%NOTFOUND) THEN
466: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_OSP_LN_INV_LOV');
467: FND_MSG_PUB.ADD;
468: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
470: 'Invalid OSP Line id : '||p_x_lines_tbl(i).osp_line_id||' for OSP Order id : '||p_x_lines_tbl(i).osp_order_id);

Line 1496: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');

1492: FETCH ahl_osp_header_id_csr INTO l_dummy;
1493: IF (ahl_osp_header_id_csr%NOTFOUND) THEN
1494: CLOSE ahl_osp_header_id_csr;
1495: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1496: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');
1497: Fnd_Msg_Pub.ADD;
1498: END IF;
1499: RAISE Fnd_Api.g_exc_error;
1500: END IF;

Line 1518: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_HEADER_ID_INV');

1514: END IF;
1515: ELSE --This may mean that the Sales Order has been deleted from the OM Forms and Synch has not been done
1516: CLOSE ahl_osp_oe_closed_csr;
1517: l_closed := FND_API.G_FALSE;
1518: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_HEADER_ID_INV');
1519: FND_MSG_PUB.ADD;
1520: RAISE Fnd_Api.g_exc_error;
1521: END IF;
1522: CLOSE ahl_osp_oe_closed_csr;

Line 1754: Fnd_Message.set_name('AHL', 'AHL_OSP_VENDOR_INFO_NULL');

1750: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_vendor_cust_dtls.customer_site_id = ' || l_vendor_cust_dtls.customer_site_id);
1751: END IF;
1752:
1753: IF l_vendor_cust_dtls.customer_site_id IS NULL THEN
1754: Fnd_Message.set_name('AHL', 'AHL_OSP_VENDOR_INFO_NULL');
1755: Fnd_Msg_Pub.ADD;
1756: RAISE Fnd_Api.g_exc_error;
1757: END IF;
1758:

Line 1774: Fnd_Message.set_name('AHL', 'AHL_OSP_SOLD_TO_ORG_INV');

1770: FETCH ahl_sold_to_orgs_csr INTO x_header_rec.sold_to_org_id;
1771: IF (ahl_sold_to_orgs_csr%NOTFOUND) THEN
1772: CLOSE ahl_sold_to_orgs_csr;
1773: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1774: Fnd_Message.set_name('AHL', 'AHL_OSP_SOLD_TO_ORG_INV');
1775: FND_MESSAGE.SET_TOKEN('SOLD_TO_ORG',p_header_rec.sold_to_custom_number);
1776: Fnd_Msg_Pub.ADD;
1777: END IF;
1778: RAISE Fnd_Api.g_exc_error;

Line 1775: FND_MESSAGE.SET_TOKEN('SOLD_TO_ORG',p_header_rec.sold_to_custom_number);

1771: IF (ahl_sold_to_orgs_csr%NOTFOUND) THEN
1772: CLOSE ahl_sold_to_orgs_csr;
1773: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1774: Fnd_Message.set_name('AHL', 'AHL_OSP_SOLD_TO_ORG_INV');
1775: FND_MESSAGE.SET_TOKEN('SOLD_TO_ORG',p_header_rec.sold_to_custom_number);
1776: Fnd_Msg_Pub.ADD;
1777: END IF;
1778: RAISE Fnd_Api.g_exc_error;
1779: END IF;

Line 1802: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_TO_ORG_INV');

1798: FETCH ahl_ship_to_orgs_csr INTO x_header_rec.ship_to_org_id;
1799: IF (ahl_ship_to_orgs_csr%NOTFOUND) THEN
1800: CLOSE ahl_ship_to_orgs_csr;
1801: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1802: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_TO_ORG_INV');
1803: FND_MESSAGE.SET_TOKEN('SHIP_TO_ORG',p_header_rec.ship_to_org);
1804: Fnd_Msg_Pub.ADD;
1805: END IF;
1806: RAISE Fnd_Api.g_exc_error;

Line 1803: FND_MESSAGE.SET_TOKEN('SHIP_TO_ORG',p_header_rec.ship_to_org);

1799: IF (ahl_ship_to_orgs_csr%NOTFOUND) THEN
1800: CLOSE ahl_ship_to_orgs_csr;
1801: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1802: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_TO_ORG_INV');
1803: FND_MESSAGE.SET_TOKEN('SHIP_TO_ORG',p_header_rec.ship_to_org);
1804: Fnd_Msg_Pub.ADD;
1805: END IF;
1806: RAISE Fnd_Api.g_exc_error;
1807: END IF;

Line 1826: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');

1822: FETCH ahl_ship_from_orgs_csr INTO x_header_rec.ship_from_org_id;
1823: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
1824: CLOSE ahl_ship_from_orgs_csr;
1825: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1826: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
1827: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG',p_header_rec.ship_from_org);
1828: Fnd_Msg_Pub.ADD;
1829: END IF;
1830: RAISE Fnd_Api.g_exc_error;

Line 1827: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG',p_header_rec.ship_from_org);

1823: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
1824: CLOSE ahl_ship_from_orgs_csr;
1825: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1826: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
1827: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG',p_header_rec.ship_from_org);
1828: Fnd_Msg_Pub.ADD;
1829: END IF;
1830: RAISE Fnd_Api.g_exc_error;
1831: END IF;

Line 1916: Fnd_Message.set_name('AHL', 'AHL_OSP_PAYMENT_TERM_NULL');

1912: -- JR: Coded on 8/19/2003 as fix for Bug 3095543
1913: -- Payment Term is mandatory
1914: IF ((p_module_type = 'JSP') AND (p_header_rec.payment_term = FND_API.G_MISS_CHAR)) THEN
1915: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1916: Fnd_Message.set_name('AHL', 'AHL_OSP_PAYMENT_TERM_NULL');
1917: Fnd_Msg_Pub.ADD;
1918: END IF;
1919: RAISE Fnd_Api.g_exc_error;
1920: END IF;

Line 2606: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');

2602: OPEN osp_line_details_csr(p_x_line_tbl(i).osp_order_id,
2603: p_x_line_tbl(i).osp_line_id);
2604: FETCH osp_line_details_csr INTO l_osp_line_det_type;
2605: IF osp_line_details_csr%NOTFOUND THEN
2606: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
2607: Fnd_Msg_Pub.ADD;
2608: CLOSE osp_line_details_csr;
2609: RAISE Fnd_Api.g_exc_error;
2610: END IF;

Line 2632: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_NO_DATA_FOUND');

2628: IF get_so_line_details%NOTFOUND THEN
2629: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Details not found for Shipment Line ID: '||p_x_line_tbl(i).line_id);
2631: END IF;
2632: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_NO_DATA_FOUND');
2633: FND_MSG_PUB.ADD;
2634: CLOSE get_so_line_details;
2635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2636: END IF;

Line 2647: FND_MESSAGE.SET_NAME('AHL', 'AHL_OSP_OM_LINE_CLOSED');

2643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_get_so_line_details.cancelled_quantity: '||l_get_so_line_details.cancelled_quantity);
2644: END IF;
2645:
2646: IF(nvl(l_get_so_line_details.open_flag,'Y') = 'N') THEN
2647: FND_MESSAGE.SET_NAME('AHL', 'AHL_OSP_OM_LINE_CLOSED');
2648: FND_MSG_PUB.ADD;
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF;
2651: --mpothuku End

Line 2657: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');

2653: OPEN osp_line_details_csr3(p_x_line_tbl(i).osp_order_id,
2654: p_x_line_tbl(i).line_id);
2655: FETCH osp_line_details_csr3 INTO l_osp_line_det_type;
2656: IF osp_line_details_csr3%NOTFOUND THEN
2657: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
2658: Fnd_Msg_Pub.ADD;
2659: CLOSE osp_line_details_csr3;
2660: RAISE Fnd_Api.g_exc_error;
2661: END IF;

Line 2696: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

2692:
2693: IF l_service_duration is null THEN
2694: -- Check if the Default Duration Profile has been Set
2695: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2696: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2697: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2698: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2699: FND_MSG_PUB.ADD;
2700: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2697: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');

2693: IF l_service_duration is null THEN
2694: -- Check if the Default Duration Profile has been Set
2695: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2696: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2697: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2698: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2699: FND_MSG_PUB.ADD;
2700: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2701: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 2698: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));

2694: -- Check if the Default Duration Profile has been Set
2695: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2696: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2697: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2698: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2699: FND_MSG_PUB.ADD;
2700: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2701: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
2702: END IF;

Line 2787: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');

2783: IF (p_x_line_tbl(i).operation <> 'D') THEN
2784: IF (l_osp_line_det_type.exchange_instance_id IS NULL OR l_osp_line_det_type.exchange_instance_id = FND_API.G_MISS_NUM) THEN
2785: -- Need to set exchange instance before creating return shipment line for exchange orders
2786: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2787: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');
2788: Fnd_Msg_Pub.ADD;
2789: END IF;
2790: RAISE Fnd_Api.g_exc_error;
2791: END IF;

Line 2828: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');

2824: NVL(p_x_line_tbl(i).serial_number, 'X') <> NVL(l_old_serial_number, 'X') OR
2825: p_x_line_tbl(i).ordered_quantity <> l_old_quantity OR
2826: p_x_line_tbl(i).order_quantity_uom <> l_old_uom OR
2827: NVL(p_x_line_tbl(i).lot_number, 'X') <> NVL(l_old_lot_number, 'X')) THEN
2828: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');
2829: Fnd_Msg_Pub.ADD;
2830: RAISE Fnd_Api.g_exc_error;
2831: END IF;
2832: --Bug fix 4580226 ends

Line 2929: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');

2925: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
2926: -- Instance is installed as a component
2927: CLOSE ahl_csi_unit_test_csr;
2928: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2929: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
2930: Fnd_Msg_Pub.ADD;
2931: END IF;
2932: RAISE Fnd_Api.g_exc_error;
2933: END IF;

Line 2980: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');

2976: FETCH ahl_oe_ship_id_csr INTO l_return_line_id;
2977: IF (ahl_oe_ship_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
2978: CLOSE ahl_oe_ship_id_csr;
2979: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2980: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');
2981: Fnd_Msg_Pub.ADD;
2982: END IF;
2983: RAISE Fnd_Api.g_exc_error;
2984: END IF;

Line 3003: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');

2999: /*
3000: IF (p_x_line_tbl(i).order_type = 'BORROW' AND l_return_line_id IS NULL) THEN
3001: CLOSE ahl_oe_schedule_date_csr;
3002: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3003: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');
3004: Fnd_Msg_Pub.ADD;
3005: END IF;
3006: RAISE Fnd_Api.g_exc_error;
3007: END IF;

Line 3016: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3012: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3013: IF (l_return_date > p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Ship-only line
3014: CLOSE ahl_oe_schedule_date_csr;
3015: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3016: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3017: Fnd_Msg_Pub.ADD;
3018: END IF;
3019: RAISE Fnd_Api.g_exc_error;
3020: END IF;

Line 3027: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3023: --For others, ship date must be before return date
3024: IF (l_return_date < p_x_line_tbl(i).schedule_ship_date) THEN
3025: CLOSE ahl_oe_schedule_date_csr;
3026: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3027: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3028: Fnd_Msg_Pub.ADD;
3029: END IF;
3030: RAISE Fnd_Api.g_exc_error;
3031: END IF; -- Return Date < Ship Date

Line 3071: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');

3067: FETCH ahl_oe_return_id_csr INTO l_dummy;
3068: IF (ahl_oe_return_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3069: CLOSE ahl_oe_return_id_csr;
3070: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3071: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');
3072: Fnd_Msg_Pub.ADD;
3073: END IF;
3074: RAISE Fnd_Api.g_exc_error;
3075: END IF;

Line 3092: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3088: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3089: IF (l_ship_date < p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Return line
3090: CLOSE ahl_oe_schedule_date_csr;
3091: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3092: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3093: Fnd_Msg_Pub.ADD;
3094: END IF;
3095: RAISE Fnd_Api.g_exc_error;
3096: END IF;

Line 3103: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3099: --For others, return date must be after the ship date
3100: IF (l_ship_date > p_x_line_tbl(i).schedule_ship_date) THEN
3101: CLOSE ahl_oe_schedule_date_csr;
3102: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3103: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3104: Fnd_Msg_Pub.ADD;
3105: END IF;
3106: RAISE Fnd_Api.g_exc_error;
3107: END IF; -- Ship Date > Return Date

Line 3189: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');

3185: IF (p_x_line_tbl(i).operation <> 'D') THEN
3186: IF (l_osp_line_det_type.exchange_instance_id IS NULL OR l_osp_line_det_type.exchange_instance_id = FND_API.G_MISS_NUM) THEN
3187: -- Need to set exchange instance before creating return shipment line for exchange orders
3188: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3189: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');
3190: Fnd_Msg_Pub.ADD;
3191: END IF;
3192: RAISE Fnd_Api.g_exc_error;
3193: END IF;

Line 3230: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');

3226: NVL(p_x_line_tbl(i).serial_number, 'X') <> NVL(l_old_serial_number, 'X') OR
3227: p_x_line_tbl(i).ordered_quantity <> l_old_quantity OR
3228: p_x_line_tbl(i).order_quantity_uom <> l_old_uom OR
3229: NVL(p_x_line_tbl(i).lot_number, 'X') <> NVL(l_old_lot_number, 'X')) THEN
3230: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');
3231: Fnd_Msg_Pub.ADD;
3232: RAISE Fnd_Api.g_exc_error;
3233: END IF;
3234: --Bug fix 4580226 ends

Line 3331: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');

3327: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
3328: -- Instance is installed as a component
3329: CLOSE ahl_csi_unit_test_csr;
3330: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3331: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
3332: Fnd_Msg_Pub.ADD;
3333: END IF;
3334: RAISE Fnd_Api.g_exc_error;
3335: END IF;

Line 3389: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');

3385: FETCH ahl_oe_ship_id_csr INTO l_return_line_id;
3386: IF (ahl_oe_ship_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3387: CLOSE ahl_oe_ship_id_csr;
3388: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3389: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');
3390: Fnd_Msg_Pub.ADD;
3391: END IF;
3392: RAISE Fnd_Api.g_exc_error;
3393: END IF;

Line 3420: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');

3416: /*
3417: IF (p_x_line_tbl(i).order_type = 'BORROW' AND l_return_line_id IS NULL) THEN
3418: CLOSE ahl_oe_Inv_schedule_date_csr;
3419: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3420: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');
3421: Fnd_Msg_Pub.ADD;
3422: END IF;
3423: RAISE Fnd_Api.g_exc_error;
3424: END IF;

Line 3433: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3429: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3430: IF (l_return_date > p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Ship-only line
3431: CLOSE ahl_oe_Inv_schedule_date_csr;
3432: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3433: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3434: Fnd_Msg_Pub.ADD;
3435: END IF;
3436: RAISE Fnd_Api.g_exc_error;
3437: END IF;

Line 3444: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3440: --For others, ship date must be before return date
3441: IF (l_return_date < p_x_line_tbl(i).schedule_ship_date) THEN
3442: CLOSE ahl_oe_Inv_schedule_date_csr;
3443: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3444: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3445: Fnd_Msg_Pub.ADD;
3446: END IF;
3447: RAISE Fnd_Api.g_exc_error;
3448: END IF; -- Return Date < Ship Date

Line 3498: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');

3494: IF (ahl_oe_return_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3495:
3496: CLOSE ahl_oe_return_id_csr;
3497: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3498: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');
3499: Fnd_Msg_Pub.ADD;
3500: END IF;
3501: RAISE Fnd_Api.g_exc_error;
3502: END IF;

Line 3526: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3522: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3523: IF (l_ship_date < p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Return line
3524: CLOSE ahl_oe_Inv_schedule_date_csr;
3525: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3526: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3527: Fnd_Msg_Pub.ADD;
3528: END IF;
3529: RAISE Fnd_Api.g_exc_error;
3530: END IF;

Line 3537: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');

3533: --For others, return date must be after the ship date
3534: IF (l_ship_date > p_x_line_tbl(i).schedule_ship_date) THEN
3535: CLOSE ahl_oe_Inv_schedule_date_csr;
3536: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3537: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3538: Fnd_Msg_Pub.ADD;
3539: END IF;
3540: RAISE Fnd_Api.g_exc_error;
3541: END IF; -- Ship Date > Return Date

Line 3557: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_DATE_LT_SYS');

3553: p_x_line_tbl(i).osp_line_id := null;
3554: p_x_line_tbl(i).osp_line_number := null;
3555:
3556: IF p_x_line_tbl(i).schedule_ship_date < TRUNC(sysdate) THEN
3557: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_DATE_LT_SYS');
3558: Fnd_Msg_Pub.ADD;
3559: RAISE Fnd_Api.g_exc_error;
3560: END IF;
3561:

Line 3567: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');

3563: p_x_line_tbl(i).line_type := 'SHIP';
3564: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3565: p_x_line_tbl(i).line_type := 'RETURN';
3566: ELSE
3567: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3568: Fnd_Msg_Pub.ADD;
3569: END IF;
3570: IF p_x_line_tbl(i).line_type IS NULL THEN
3571: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');

Line 3571: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');

3567: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3568: Fnd_Msg_Pub.ADD;
3569: END IF;
3570: IF p_x_line_tbl(i).line_type IS NULL THEN
3571: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3572: Fnd_Msg_Pub.ADD;
3573: ELSIF p_x_line_tbl(i).line_type = 'RETURN' AND p_x_line_tbl(i).return_reason_code IS NULL THEN
3574: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_REASON_NULL');
3575: Fnd_Msg_Pub.ADD;

Line 3574: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_REASON_NULL');

3570: IF p_x_line_tbl(i).line_type IS NULL THEN
3571: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3572: Fnd_Msg_Pub.ADD;
3573: ELSIF p_x_line_tbl(i).line_type = 'RETURN' AND p_x_line_tbl(i).return_reason_code IS NULL THEN
3574: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_REASON_NULL');
3575: Fnd_Msg_Pub.ADD;
3576: END IF;
3577:
3578: IF p_x_line_tbl(i).osp_order_id IS NULL THEN

Line 3579: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');

3575: Fnd_Msg_Pub.ADD;
3576: END IF;
3577:
3578: IF p_x_line_tbl(i).osp_order_id IS NULL THEN
3579: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
3580: Fnd_Msg_Pub.ADD;
3581: END IF;
3582:
3583:

Line 3602: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');

3598: --p_x_line_tbl(i).serial_number,
3599: --p_x_line_tbl(i).LOT_NUMBER
3600: FETCH validate_item INTO l_dummy;
3601: IF validate_item%NOTFOUND THEN
3602: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');
3603: Fnd_Msg_Pub.ADD;
3604: CLOSE validate_item;
3605: RAISE Fnd_Api.g_exc_error;
3606: END IF;

Line 3667: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

3663:
3664: -- Default the Return Reason from the Profile
3665: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3666: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3667: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3668: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3669: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3670: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3671: FND_MSG_PUB.ADD;

Line 3669: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');

3665: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3666: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3667: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3668: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3669: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3670: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3671: FND_MSG_PUB.ADD;
3672: RAISE Fnd_Api.g_exc_error;
3673: END IF;

Line 3670: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));

3666: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3667: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3668: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3669: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3670: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3671: FND_MSG_PUB.ADD;
3672: RAISE Fnd_Api.g_exc_error;
3673: END IF;
3674: p_x_line_tbl(l_index).return_reason := NULL;

Line 3694: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

3690:
3691: IF l_service_duration is null THEN
3692: -- Check if the Default Duration Profile has been Set
3693: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3694: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3695: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3696: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3697: FND_MSG_PUB.ADD;
3698: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3695: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');

3691: IF l_service_duration is null THEN
3692: -- Check if the Default Duration Profile has been Set
3693: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3694: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3695: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3696: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3697: FND_MSG_PUB.ADD;
3698: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3699: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 3696: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));

3692: -- Check if the Default Duration Profile has been Set
3693: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3694: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3695: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3696: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3697: FND_MSG_PUB.ADD;
3698: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3699: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
3700: END IF;

Line 3754: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_OSP_LN_INV_WO');

3750: OPEN ahl_osp_work_csr(I.WORKORDER_ID);
3751: FETCH ahl_osp_work_csr INTO l_work_det;
3752: -- jaramana June 4, 2005: Added check for Workorder
3753: IF(ahl_osp_work_csr%NOTFOUND) THEN
3754: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_OSP_LN_INV_WO');
3755: FND_MESSAGE.Set_Token('WORKORDER_ID', I.WORKORDER_ID);
3756: CLOSE ahl_osp_work_csr;
3757: RAISE Fnd_Api.g_exc_error;
3758: END IF;

Line 3755: FND_MESSAGE.Set_Token('WORKORDER_ID', I.WORKORDER_ID);

3751: FETCH ahl_osp_work_csr INTO l_work_det;
3752: -- jaramana June 4, 2005: Added check for Workorder
3753: IF(ahl_osp_work_csr%NOTFOUND) THEN
3754: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_OSP_LN_INV_WO');
3755: FND_MESSAGE.Set_Token('WORKORDER_ID', I.WORKORDER_ID);
3756: CLOSE ahl_osp_work_csr;
3757: RAISE Fnd_Api.g_exc_error;
3758: END IF;
3759: CLOSE ahl_osp_work_csr;

Line 3786: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');

3782: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
3783: -- Instance is installed as a component
3784: CLOSE ahl_csi_unit_test_csr;
3785: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3786: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
3787: Fnd_Msg_Pub.ADD;
3788: END IF;
3789: RAISE Fnd_Api.g_exc_error;
3790: END IF;

Line 4011: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');

4007: FETCH ahl_ship_from_orgs_csr INTO l_line_rec.ship_from_org_id;
4008: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
4009: CLOSE ahl_ship_from_orgs_csr;
4010: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4011: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
4012: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG', p_line_tbl(i).ship_from_org);
4013: FND_MSG_PUB.ADD;
4014: END IF;
4015: RAISE Fnd_Api.g_exc_error;

Line 4012: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG', p_line_tbl(i).ship_from_org);

4008: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
4009: CLOSE ahl_ship_from_orgs_csr;
4010: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4011: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
4012: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG', p_line_tbl(i).ship_from_org);
4013: FND_MSG_PUB.ADD;
4014: END IF;
4015: RAISE Fnd_Api.g_exc_error;
4016: END IF;

Line 4234: Fnd_Message.set_name('AHL', 'AHL_OSP_OSP_ID_NULL');

4230: FETCH ahl_osp_order_csr INTO l_osp_order;
4231: IF (ahl_osp_order_csr%NOTFOUND) THEN
4232: CLOSE ahl_osp_order_csr;
4233: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4234: Fnd_Message.set_name('AHL', 'AHL_OSP_OSP_ID_NULL');
4235: Fnd_Msg_Pub.ADD;
4236: END IF;
4237: RAISE Fnd_Api.g_exc_error;
4238: END IF;

Line 4429: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');

4425: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4426: END LOOP;
4427:
4428: IF l_row_check = 'N' THEN
4429: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4430: Fnd_Msg_Pub.ADD;
4431: RAISE Fnd_Api.g_exc_error;
4432: END IF;
4433:

Line 4702: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');

4698: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4699: END LOOP;
4700:
4701: IF l_row_check = 'N' THEN
4702: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4703: Fnd_Msg_Pub.ADD;
4704: RAISE Fnd_Api.g_exc_error;
4705: END IF;
4706:

Line 4799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIP_COMPONENT');

4795: -- Validate exchange instance
4796: OPEN val_exg_instance_id_csr(p_exchange_instance_id);
4797: FETCH val_exg_instance_id_csr INTO l_exist;
4798: IF (val_exg_instance_id_csr %NOTFOUND) THEN
4799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIP_COMPONENT');
4800: FND_MSG_PUB.ADD;
4801: CLOSE val_exg_instance_id_csr;
4802: RAISE Fnd_Api.g_exc_error;
4803: END IF;

Line 4861: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');

4857: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4858: END LOOP;
4859:
4860: IF l_row_check = 'N' THEN
4861: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4862: Fnd_Msg_Pub.ADD;
4863: RAISE Fnd_Api.g_exc_error;
4864: END IF;
4865:

Line 5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

5074: OPEN csi_txn_types_csr(G_OM_ORDER);
5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5080: FND_MSG_PUB.ADD;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5082: RETURN;

Line 5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);

5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5080: FND_MSG_PUB.ADD;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5082: RETURN;
5083: END IF;

Line 5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5087: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5088: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5089: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5090: IF l_subtxn_id IS NULL THEN
5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5094: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5095: FND_MSG_PUB.ADD;

Line 5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');

5088: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5089: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5090: IF l_subtxn_id IS NULL THEN
5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5094: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5095: FND_MSG_PUB.ADD;
5096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5089: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5090: IF l_subtxn_id IS NULL THEN
5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5094: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5095: FND_MSG_PUB.ADD;
5096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5097: RETURN;

Line 5094: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));

5090: IF l_subtxn_id IS NULL THEN
5091: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5092: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5093: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5094: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5095: FND_MSG_PUB.ADD;
5096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5097: RETURN;
5098: END IF;

Line 5103: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');

5099: OPEN get_sold_to_org(p_oe_line_id);
5100: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_account_id;
5101: IF (get_sold_to_org%NOTFOUND) THEN
5102: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5103: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5104: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5105: Fnd_Msg_Pub.ADD;
5106: END IF;
5107: CLOSE get_sold_to_org;

Line 5104: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));

5100: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_account_id;
5101: IF (get_sold_to_org%NOTFOUND) THEN
5102: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5103: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5104: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5105: Fnd_Msg_Pub.ADD;
5106: END IF;
5107: CLOSE get_sold_to_org;
5108: RAISE Fnd_Api.g_exc_error;

Line 5126: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');

5122: FETCH get_owner_ip_id INTO l_curr_inst_pty_id,
5123: l_curr_pty_id;
5124: IF (get_owner_ip_id%NOTFOUND) THEN
5125: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5126: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5127: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5128: Fnd_Msg_Pub.ADD;
5129: END IF;
5130: CLOSE get_owner_ip_id;

Line 5127: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));

5123: l_curr_pty_id;
5124: IF (get_owner_ip_id%NOTFOUND) THEN
5125: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5126: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5127: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5128: Fnd_Msg_Pub.ADD;
5129: END IF;
5130: CLOSE get_owner_ip_id;
5131: RAISE Fnd_Api.g_exc_error;

Line 5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5151: END IF;
5152: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5153: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5154: IF l_subtxn_id IS NULL THEN
5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5158: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5159: FND_MSG_PUB.ADD;

Line 5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');

5152: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5153: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5154: IF l_subtxn_id IS NULL THEN
5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5158: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5159: FND_MSG_PUB.ADD;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5153: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5154: IF l_subtxn_id IS NULL THEN
5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5158: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5159: FND_MSG_PUB.ADD;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5161: RETURN;

Line 5158: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));

5154: IF l_subtxn_id IS NULL THEN
5155: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5156: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5157: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5158: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5159: FND_MSG_PUB.ADD;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5161: RETURN;
5162: END IF;

Line 5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5163: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5164: --l_subtxn_name := G_SUBTXN_ORDER;
5165: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5166: IF l_subtxn_id IS NULL THEN
5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5170: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5171: FND_MSG_PUB.ADD;

Line 5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');

5164: --l_subtxn_name := G_SUBTXN_ORDER;
5165: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5166: IF l_subtxn_id IS NULL THEN
5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5170: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5171: FND_MSG_PUB.ADD;
5172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5165: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5166: IF l_subtxn_id IS NULL THEN
5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5170: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5171: FND_MSG_PUB.ADD;
5172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5173: RETURN;

Line 5170: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));

5166: IF l_subtxn_id IS NULL THEN
5167: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5168: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5169: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5170: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5171: FND_MSG_PUB.ADD;
5172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5173: RETURN;
5174: END IF;

Line 5182: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5178: OPEN csi_txn_sub_types_csr(l_om_order_id, l_subtxn_name);
5179: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5180: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5181: CLOSE csi_txn_sub_types_csr;
5182: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5183: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5184: FND_MSG_PUB.ADD;
5185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5186: RETURN;

Line 5183: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);

5179: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5180: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5181: CLOSE csi_txn_sub_types_csr;
5182: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5183: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5184: FND_MSG_PUB.ADD;
5185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5186: RETURN;
5187: END IF;

Line 5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

5193: OPEN csi_txn_types_csr(G_OM_RETURN);
5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5199: FND_MSG_PUB.ADD;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5201: RETURN;

Line 5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);

5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5199: FND_MSG_PUB.ADD;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5201: RETURN;
5202: END IF;

Line 5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5206: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5207: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5208: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5209: IF l_subtxn_id IS NULL THEN
5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5213: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5214: FND_MSG_PUB.ADD;

Line 5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');

5207: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5208: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5209: IF l_subtxn_id IS NULL THEN
5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5213: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5214: FND_MSG_PUB.ADD;
5215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5208: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5209: IF l_subtxn_id IS NULL THEN
5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5213: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5214: FND_MSG_PUB.ADD;
5215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5216: RETURN;

Line 5213: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));

5209: IF l_subtxn_id IS NULL THEN
5210: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5211: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5212: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5213: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5214: FND_MSG_PUB.ADD;
5215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5216: RETURN;
5217: END IF;

Line 5223: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');

5219: OPEN get_internal_party_csr;
5220: FETCH get_internal_party_csr INTO l_internal_party_id;
5221: IF (get_internal_party_csr%NOTFOUND) THEN
5222: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5223: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');
5224: Fnd_Msg_Pub.ADD;
5225: END IF;
5226: CLOSE get_internal_party_csr;
5227: RAISE Fnd_Api.g_exc_error;

Line 5243: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');

5239: FETCH get_owner_ip_id INTO l_curr_inst_pty_id,
5240: l_curr_pty_id;
5241: IF (get_owner_ip_id%NOTFOUND) THEN
5242: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5243: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5244: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5245: Fnd_Msg_Pub.ADD;
5246: END IF;
5247: CLOSE get_owner_ip_id;

Line 5244: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));

5240: l_curr_pty_id;
5241: IF (get_owner_ip_id%NOTFOUND) THEN
5242: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5243: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5244: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5245: Fnd_Msg_Pub.ADD;
5246: END IF;
5247: CLOSE get_owner_ip_id;
5248: RAISE Fnd_Api.g_exc_error;

Line 5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5263: END IF;
5264: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5265: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5266: IF l_subtxn_id IS NULL THEN
5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5270: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5271: FND_MSG_PUB.ADD;

Line 5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');

5264: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5265: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5266: IF l_subtxn_id IS NULL THEN
5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5270: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5271: FND_MSG_PUB.ADD;
5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5265: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5266: IF l_subtxn_id IS NULL THEN
5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5270: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5271: FND_MSG_PUB.ADD;
5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: RETURN;

Line 5270: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));

5266: IF l_subtxn_id IS NULL THEN
5267: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5268: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5269: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5270: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5271: FND_MSG_PUB.ADD;
5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: RETURN;
5274: END IF;

Line 5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5274: END IF;
5275: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5276: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5277: IF l_subtxn_id IS NULL THEN
5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5281: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5282: FND_MSG_PUB.ADD;

Line 5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');

5275: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5276: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5277: IF l_subtxn_id IS NULL THEN
5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5281: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5282: FND_MSG_PUB.ADD;
5283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

5276: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5277: IF l_subtxn_id IS NULL THEN
5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5281: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5282: FND_MSG_PUB.ADD;
5283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5284: RETURN;

Line 5281: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));

5277: IF l_subtxn_id IS NULL THEN
5278: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5279: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5280: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5281: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5282: FND_MSG_PUB.ADD;
5283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5284: RETURN;
5285: END IF;

Line 5293: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');

5289: OPEN csi_txn_sub_types_csr(l_om_order_id, l_subtxn_name);
5290: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5291: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5292: CLOSE csi_txn_sub_types_csr;
5293: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5294: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5295: FND_MSG_PUB.ADD;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5297: RETURN;

Line 5294: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);

5290: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5291: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5292: CLOSE csi_txn_sub_types_csr;
5293: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5294: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5295: FND_MSG_PUB.ADD;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5297: RETURN;
5298: END IF;

Line 5596: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');

5592: FETCH validate_osp_id_csr INTO l_dummy;
5593: IF (validate_osp_id_csr%NOTFOUND) THEN
5594: CLOSE validate_osp_id_csr;
5595: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5596: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');
5597: Fnd_Msg_Pub.ADD;
5598: END IF;
5599: RAISE Fnd_Api.g_exc_error;
5600: END IF;

Line 5616: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');

5612: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) OR
5613: (p_new_order_type_code NOT IN (AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE,
5614: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE))) THEN
5615: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5616: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');
5617: Fnd_Msg_Pub.ADD;
5618: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5619: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5620: END IF;

Line 5640: Fnd_Message.set_name('AHL', 'AHL_OSP_ALREADY_SHIPPED');

5636: IF (l_shipped_quantity IS NOT NULL AND
5637: l_shipped_quantity > 0) THEN
5638: -- Return line is already shipped: Too late to convert!
5639: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5640: Fnd_Message.set_name('AHL', 'AHL_OSP_ALREADY_SHIPPED');
5641: Fnd_Msg_Pub.ADD;
5642: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5643: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5644: END IF;

Line 5832: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');

5828: OPEN get_internal_party_csr;
5829: FETCH get_internal_party_csr INTO l_internal_party_id;
5830: IF (get_internal_party_csr%NOTFOUND) THEN
5831: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5832: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');
5833: Fnd_Msg_Pub.ADD;
5834: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5835: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5836: END IF;

Line 5870: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');

5866: l_curr_pty_id,
5867: l_party_ovn;
5868: IF (get_owner_ip_id%NOTFOUND) THEN
5869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5870: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5871: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5872: Fnd_Msg_Pub.ADD;
5873: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5874: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 5871: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));

5867: l_party_ovn;
5868: IF (get_owner_ip_id%NOTFOUND) THEN
5869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5870: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5871: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5872: Fnd_Msg_Pub.ADD;
5873: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5874: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5875: END IF;

Line 5900: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');

5896: OPEN get_sold_to_org(l_oe_ship_line_id);
5897: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_acc_id;
5898: IF (get_sold_to_org%NOTFOUND) THEN
5899: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5900: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5901: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5902: Fnd_Msg_Pub.ADD;
5903: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5904: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 5901: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));

5897: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_acc_id;
5898: IF (get_sold_to_org%NOTFOUND) THEN
5899: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5900: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5901: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5902: Fnd_Msg_Pub.ADD;
5903: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5904: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5905: END IF;

Line 5917: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');

5913: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Service to Exchange conversion: New external owner (party) = ' || l_new_party_id || ', New Party Account = ' || l_new_party_acc_id);
5914: END IF;
5915: ELSE
5916: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5917: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');
5918: Fnd_Msg_Pub.ADD;
5919: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5920: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5921: END IF;

Line 6220: Fnd_Message.set_name('AHL', 'AHL_OSP_CUST_SETUP_NOTFOUND');

6216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_vendor_cust_dtls.customer_site_id = ' || l_vendor_cust_dtls.customer_site_id);
6217: END IF;
6218:
6219: IF l_vendor_cust_dtls.customer_site_id IS NULL THEN
6220: Fnd_Message.set_name('AHL', 'AHL_OSP_CUST_SETUP_NOTFOUND');
6221: Fnd_Msg_Pub.ADD;
6222: RAISE Fnd_Api.g_exc_error;
6223: END IF;
6224:

Line 6810: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPLID_NLL');

6806: END IF;
6807:
6808: --osp_order_line_id should not be null
6809: IF(p_serialnum_change_rec.osp_line_id is NULL) THEN
6810: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPLID_NLL');
6811: FND_MSG_PUB.ADD;
6812: RAISE FND_API.G_EXC_ERROR;
6813: END IF;
6814:

Line 6819: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INVOP_OSP_LN_NFOUND');

6815: --validate the osp_order_line_id
6816: OPEN get_osp_order_line_dtls(l_serialnum_change_rec.osp_line_id);
6817: FETCH get_osp_order_line_dtls INTO l_osp_order_line_dtls;
6818: IF (get_osp_order_line_dtls%NOTFOUND) THEN
6819: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INVOP_OSP_LN_NFOUND');
6820: FND_MSG_PUB.ADD;
6821: CLOSE get_osp_order_line_dtls;
6822: RAISE FND_API.G_EXC_ERROR;
6823: END IF;

Line 6828: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPL_INV');

6824: CLOSE get_osp_order_line_dtls;
6825:
6826: --check that the osp line is valid for the part number change
6827: IF(Is_part_chg_valid_for_ospline(p_serialnum_change_rec.osp_line_id) = 'N') THEN
6828: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPL_INV');
6829: FND_MSG_PUB.ADD;
6830: RAISE FND_API.G_EXC_ERROR;
6831: END IF;
6832:

Line 6840: FND_MESSAGE.Set_Name('AHL','AHL_OSP_ITEM_INVALID');

6836: OPEN c_get_inv_item_id(l_serialnum_change_rec.new_item_number);
6837: FETCH c_get_inv_item_id INTO l_inventory_item_id;
6838: CLOSE c_get_inv_item_id;
6839: IF l_inventory_item_id IS NULL THEN
6840: FND_MESSAGE.Set_Name('AHL','AHL_OSP_ITEM_INVALID');
6841: FND_MESSAGE.Set_token('ITEM',l_serialnum_change_rec.new_item_number);
6842: FND_MSG_PUB.ADD;
6843: RAISE FND_API.G_EXC_ERROR;
6844: END IF;

Line 6841: FND_MESSAGE.Set_token('ITEM',l_serialnum_change_rec.new_item_number);

6837: FETCH c_get_inv_item_id INTO l_inventory_item_id;
6838: CLOSE c_get_inv_item_id;
6839: IF l_inventory_item_id IS NULL THEN
6840: FND_MESSAGE.Set_Name('AHL','AHL_OSP_ITEM_INVALID');
6841: FND_MESSAGE.Set_token('ITEM',l_serialnum_change_rec.new_item_number);
6842: FND_MSG_PUB.ADD;
6843: RAISE FND_API.G_EXC_ERROR;
6844: END IF;
6845: ELSE

Line 6846: FND_MESSAGE.Set_Name('AHL','AHL_OSP_INV_ITEM_NULL');

6842: FND_MSG_PUB.ADD;
6843: RAISE FND_API.G_EXC_ERROR;
6844: END IF;
6845: ELSE
6846: FND_MESSAGE.Set_Name('AHL','AHL_OSP_INV_ITEM_NULL');
6847: FND_MSG_PUB.ADD;
6848: RAISE FND_API.G_EXC_ERROR;
6849: END IF;
6850:

Line 6866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIPLINE_NO_INST');

6862: --If passed instance_id is null, derive it from the osp line, else check that its the one present on the osp line.
6863: OPEN get_ship_line_instance(l_serialnum_change_rec.osp_line_id);
6864: FETCH get_ship_line_instance INTO l_ship_line_instance_id;
6865: IF (get_ship_line_instance%NOTFOUND) THEN
6866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIPLINE_NO_INST');
6867: FND_MSG_PUB.ADD;
6868: CLOSE get_ship_line_instance;
6869: RAISE FND_API.G_EXC_ERROR;
6870: END IF;

Line 6880: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');

6876: IF (l_serialnum_change_rec.instance_id is NULL) THEN
6877: l_serialnum_change_rec.instance_id := l_ship_line_instance_id;
6878: ELSE
6879: IF(l_serialnum_change_rec.instance_id <> l_ship_line_instance_id) THEN
6880: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
6881: FND_MSG_PUB.ADD;
6882: RAISE FND_API.G_EXC_ERROR;
6883: END IF;
6884: END IF;

Line 6894: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');

6890: OPEN get_instance_details(l_serialnum_change_rec.instance_id);
6891: FETCH get_instance_details INTO l_instance_dtls_rec;
6892: CLOSE get_instance_details;
6893: IF l_instance_dtls_rec.instance_id IS NULL THEN
6894: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
6895: FND_MSG_PUB.ADD;
6896: RAISE FND_API.G_EXC_ERROR;
6897: END IF;
6898:

Line 6938: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');

6934: l_serialnum_change_rec.New_Serial_Tag_Mean,
6935: l_lookup_code,
6936: l_return_val);
6937: IF NOT(l_return_val) THEN
6938: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
6939: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
6940: FND_MSG_PUB.ADD;
6941: RAISE FND_API.G_EXC_ERROR;
6942: ELSE

Line 6939: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);

6935: l_lookup_code,
6936: l_return_val);
6937: IF NOT(l_return_val) THEN
6938: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
6939: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
6940: FND_MSG_PUB.ADD;
6941: RAISE FND_API.G_EXC_ERROR;
6942: ELSE
6943: l_serialnum_change_rec.New_Serial_Tag_Code := l_lookup_code;

Line 6952: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ITEM_INVALID');

6948: --get the item information
6949: OPEN mtl_system_items_csr(l_inventory_item_id, l_organization_id);
6950: FETCH mtl_system_items_csr INTO l_mtl_system_items_rec;
6951: IF (mtl_system_items_csr%NOTFOUND) THEN
6952: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ITEM_INVALID');
6953: FND_MESSAGE.Set_token('ITEM',l_inventory_item_id);
6954: FND_MSG_PUB.ADD;
6955: CLOSE mtl_system_items_csr;
6956: RAISE FND_API.G_EXC_ERROR;

Line 6953: FND_MESSAGE.Set_token('ITEM',l_inventory_item_id);

6949: OPEN mtl_system_items_csr(l_inventory_item_id, l_organization_id);
6950: FETCH mtl_system_items_csr INTO l_mtl_system_items_rec;
6951: IF (mtl_system_items_csr%NOTFOUND) THEN
6952: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ITEM_INVALID');
6953: FND_MESSAGE.Set_token('ITEM',l_inventory_item_id);
6954: FND_MSG_PUB.ADD;
6955: CLOSE mtl_system_items_csr;
6956: RAISE FND_API.G_EXC_ERROR;
6957: END IF;

Line 6966: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_ITEM_SER_TR');

6962: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Invalid Item: Has to be serial controlled and IB trackable '||
6964: ' l_serial_number_control_code =>' || l_mtl_system_items_rec.serial_number_control_code || 'l_comms_nl_trackable_flag =>'||l_mtl_system_items_rec.comms_nl_trackable_flag );
6965: END IF;
6966: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_ITEM_SER_TR');
6967: FND_MESSAGE.Set_token('ITEM',l_mtl_system_items_rec.concatenated_segments);
6968: FND_MSG_PUB.ADD;
6969: RAISE FND_API.G_EXC_ERROR;
6970: END IF;

Line 6967: FND_MESSAGE.Set_token('ITEM',l_mtl_system_items_rec.concatenated_segments);

6963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Invalid Item: Has to be serial controlled and IB trackable '||
6964: ' l_serial_number_control_code =>' || l_mtl_system_items_rec.serial_number_control_code || 'l_comms_nl_trackable_flag =>'||l_mtl_system_items_rec.comms_nl_trackable_flag );
6965: END IF;
6966: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_ITEM_SER_TR');
6967: FND_MESSAGE.Set_token('ITEM',l_mtl_system_items_rec.concatenated_segments);
6968: FND_MSG_PUB.ADD;
6969: RAISE FND_API.G_EXC_ERROR;
6970: END IF;
6971:

Line 7147: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');

7143: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) THEN
7144: -- create extended attributes.
7145: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7146: IF NOT(l_return_val) THEN
7147: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7148: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7149: FND_MSG_PUB.ADD;
7150: ELSE
7151: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;

Line 7148: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');

7144: -- create extended attributes.
7145: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7146: IF NOT(l_return_val) THEN
7147: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7148: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7149: FND_MSG_PUB.ADD;
7150: ELSE
7151: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;
7152: l_csi_extend_attrib_rec1.attribute_value := l_serialnum_change_rec.New_Serial_Tag_Code;