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 397: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

393:
394: -- Start processing
395:
396: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
397: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
398: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
399: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
400: FND_MSG_PUB.ADD;
401: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

394: -- Start processing
395:
396: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
397: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
398: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
399: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
400: FND_MSG_PUB.ADD;
401: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
402: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

395:
396: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
397: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
398: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
399: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
400: FND_MSG_PUB.ADD;
401: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
402: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
403: END IF;

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

404: RAISE Fnd_Api.g_exc_error;
405: END IF;
406:
407: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
408: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
409: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
410: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
411: FND_MSG_PUB.ADD;
412: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

405: END IF;
406:
407: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
408: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
409: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
410: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
411: FND_MSG_PUB.ADD;
412: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
413: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

406:
407: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
408: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
409: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
410: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
411: FND_MSG_PUB.ADD;
412: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
413: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
414: END IF;

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

415: RAISE Fnd_Api.g_exc_error;
416: END IF;
417:
418: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
419: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
420: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
421: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
422: FND_MSG_PUB.ADD;
423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

417:
418: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
419: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
420: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
421: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
422: FND_MSG_PUB.ADD;
423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
425: END IF;

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

1457: FETCH ahl_osp_header_id_csr INTO l_dummy;
1458: IF (ahl_osp_header_id_csr%NOTFOUND) THEN
1459: CLOSE ahl_osp_header_id_csr;
1460: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1461: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');
1462: Fnd_Msg_Pub.ADD;
1463: END IF;
1464: RAISE Fnd_Api.g_exc_error;
1465: END IF;

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

1479: END IF;
1480: ELSE --This may mean that the Sales Order has been deleted from the OM Forms and Synch has not been done
1481: CLOSE ahl_osp_oe_closed_csr;
1482: l_closed := FND_API.G_FALSE;
1483: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_HEADER_ID_INV');
1484: FND_MSG_PUB.ADD;
1485: RAISE Fnd_Api.g_exc_error;
1486: END IF;
1487: CLOSE ahl_osp_oe_closed_csr;

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

1715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_vendor_cust_dtls.customer_site_id = ' || l_vendor_cust_dtls.customer_site_id);
1716: END IF;
1717:
1718: IF l_vendor_cust_dtls.customer_site_id IS NULL THEN
1719: Fnd_Message.set_name('AHL', 'AHL_OSP_VENDOR_INFO_NULL');
1720: Fnd_Msg_Pub.ADD;
1721: RAISE Fnd_Api.g_exc_error;
1722: END IF;
1723:

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

1735: FETCH ahl_sold_to_orgs_csr INTO x_header_rec.sold_to_org_id;
1736: IF (ahl_sold_to_orgs_csr%NOTFOUND) THEN
1737: CLOSE ahl_sold_to_orgs_csr;
1738: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1739: Fnd_Message.set_name('AHL', 'AHL_OSP_SOLD_TO_ORG_INV');
1740: FND_MESSAGE.SET_TOKEN('SOLD_TO_ORG',p_header_rec.sold_to_custom_number);
1741: Fnd_Msg_Pub.ADD;
1742: END IF;
1743: RAISE Fnd_Api.g_exc_error;

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

1736: IF (ahl_sold_to_orgs_csr%NOTFOUND) THEN
1737: CLOSE ahl_sold_to_orgs_csr;
1738: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1739: Fnd_Message.set_name('AHL', 'AHL_OSP_SOLD_TO_ORG_INV');
1740: FND_MESSAGE.SET_TOKEN('SOLD_TO_ORG',p_header_rec.sold_to_custom_number);
1741: Fnd_Msg_Pub.ADD;
1742: END IF;
1743: RAISE Fnd_Api.g_exc_error;
1744: END IF;

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

1763: FETCH ahl_ship_to_orgs_csr INTO x_header_rec.ship_to_org_id;
1764: IF (ahl_ship_to_orgs_csr%NOTFOUND) THEN
1765: CLOSE ahl_ship_to_orgs_csr;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1767: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_TO_ORG_INV');
1768: FND_MESSAGE.SET_TOKEN('SHIP_TO_ORG',p_header_rec.ship_to_org);
1769: Fnd_Msg_Pub.ADD;
1770: END IF;
1771: RAISE Fnd_Api.g_exc_error;

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

1764: IF (ahl_ship_to_orgs_csr%NOTFOUND) THEN
1765: CLOSE ahl_ship_to_orgs_csr;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1767: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_TO_ORG_INV');
1768: FND_MESSAGE.SET_TOKEN('SHIP_TO_ORG',p_header_rec.ship_to_org);
1769: Fnd_Msg_Pub.ADD;
1770: END IF;
1771: RAISE Fnd_Api.g_exc_error;
1772: END IF;

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

1787: FETCH ahl_ship_from_orgs_csr INTO x_header_rec.ship_from_org_id;
1788: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
1789: CLOSE ahl_ship_from_orgs_csr;
1790: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1791: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
1792: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG',p_header_rec.ship_from_org);
1793: Fnd_Msg_Pub.ADD;
1794: END IF;
1795: RAISE Fnd_Api.g_exc_error;

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

1788: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
1789: CLOSE ahl_ship_from_orgs_csr;
1790: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1791: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
1792: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG',p_header_rec.ship_from_org);
1793: Fnd_Msg_Pub.ADD;
1794: END IF;
1795: RAISE Fnd_Api.g_exc_error;
1796: END IF;

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

1877: -- JR: Coded on 8/19/2003 as fix for Bug 3095543
1878: -- Payment Term is mandatory
1879: IF ((p_module_type = 'JSP') AND (p_header_rec.payment_term = FND_API.G_MISS_CHAR)) THEN
1880: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1881: Fnd_Message.set_name('AHL', 'AHL_OSP_PAYMENT_TERM_NULL');
1882: Fnd_Msg_Pub.ADD;
1883: END IF;
1884: RAISE Fnd_Api.g_exc_error;
1885: END IF;

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

2567: OPEN osp_line_details_csr(p_x_line_tbl(i).osp_order_id,
2568: p_x_line_tbl(i).osp_line_id);
2569: FETCH osp_line_details_csr INTO l_osp_line_det_type;
2570: IF osp_line_details_csr%NOTFOUND THEN
2571: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
2572: Fnd_Msg_Pub.ADD;
2573: CLOSE osp_line_details_csr;
2574: RAISE Fnd_Api.g_exc_error;
2575: END IF;

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

2593: IF get_so_line_details%NOTFOUND THEN
2594: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Details not found for Shipment Line ID: '||p_x_line_tbl(i).line_id);
2596: END IF;
2597: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_NO_DATA_FOUND');
2598: FND_MSG_PUB.ADD;
2599: CLOSE get_so_line_details;
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: END IF;

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

2608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_get_so_line_details.cancelled_quantity: '||l_get_so_line_details.cancelled_quantity);
2609: END IF;
2610:
2611: IF(nvl(l_get_so_line_details.open_flag,'Y') = 'N') THEN
2612: FND_MESSAGE.SET_NAME('AHL', 'AHL_OSP_OM_LINE_CLOSED');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616: --mpothuku End

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

2618: OPEN osp_line_details_csr3(p_x_line_tbl(i).osp_order_id,
2619: p_x_line_tbl(i).line_id);
2620: FETCH osp_line_details_csr3 INTO l_osp_line_det_type;
2621: IF osp_line_details_csr3%NOTFOUND THEN
2622: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
2623: Fnd_Msg_Pub.ADD;
2624: CLOSE osp_line_details_csr3;
2625: RAISE Fnd_Api.g_exc_error;
2626: END IF;

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

2657:
2658: IF l_service_duration is null THEN
2659: -- Check if the Default Duration Profile has been Set
2660: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2661: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2662: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2663: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2664: FND_MSG_PUB.ADD;
2665: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2658: IF l_service_duration is null THEN
2659: -- Check if the Default Duration Profile has been Set
2660: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2661: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2662: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2663: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2664: FND_MSG_PUB.ADD;
2665: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

2659: -- Check if the Default Duration Profile has been Set
2660: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2661: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2662: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2663: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2664: FND_MSG_PUB.ADD;
2665: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
2667: END IF;

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

2745: IF (p_x_line_tbl(i).operation <> 'D') THEN
2746: 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
2747: -- Need to set exchange instance before creating return shipment line for exchange orders
2748: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2749: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');
2750: Fnd_Msg_Pub.ADD;
2751: END IF;
2752: RAISE Fnd_Api.g_exc_error;
2753: END IF;

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

2786: NVL(p_x_line_tbl(i).serial_number, 'X') <> NVL(l_old_serial_number, 'X') OR
2787: p_x_line_tbl(i).ordered_quantity <> l_old_quantity OR
2788: p_x_line_tbl(i).order_quantity_uom <> l_old_uom OR
2789: NVL(p_x_line_tbl(i).lot_number, 'X') <> NVL(l_old_lot_number, 'X')) THEN
2790: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');
2791: Fnd_Msg_Pub.ADD;
2792: RAISE Fnd_Api.g_exc_error;
2793: END IF;
2794: --Bug fix 4580226 ends

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

2887: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
2888: -- Instance is installed as a component
2889: CLOSE ahl_csi_unit_test_csr;
2890: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2891: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
2892: Fnd_Msg_Pub.ADD;
2893: END IF;
2894: RAISE Fnd_Api.g_exc_error;
2895: END IF;

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

2938: FETCH ahl_oe_ship_id_csr INTO l_return_line_id;
2939: IF (ahl_oe_ship_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
2940: CLOSE ahl_oe_ship_id_csr;
2941: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2942: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');
2943: Fnd_Msg_Pub.ADD;
2944: END IF;
2945: RAISE Fnd_Api.g_exc_error;
2946: END IF;

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

2961: /*
2962: IF (p_x_line_tbl(i).order_type = 'BORROW' AND l_return_line_id IS NULL) THEN
2963: CLOSE ahl_oe_schedule_date_csr;
2964: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2965: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');
2966: Fnd_Msg_Pub.ADD;
2967: END IF;
2968: RAISE Fnd_Api.g_exc_error;
2969: END IF;

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

2974: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
2975: 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
2976: CLOSE ahl_oe_schedule_date_csr;
2977: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2978: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
2979: Fnd_Msg_Pub.ADD;
2980: END IF;
2981: RAISE Fnd_Api.g_exc_error;
2982: END IF;

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

2985: --For others, ship date must be before return date
2986: IF (l_return_date < p_x_line_tbl(i).schedule_ship_date) THEN
2987: CLOSE ahl_oe_schedule_date_csr;
2988: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2989: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
2990: Fnd_Msg_Pub.ADD;
2991: END IF;
2992: RAISE Fnd_Api.g_exc_error;
2993: END IF; -- Return Date < Ship Date

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

3029: FETCH ahl_oe_return_id_csr INTO l_dummy;
3030: IF (ahl_oe_return_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3031: CLOSE ahl_oe_return_id_csr;
3032: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3033: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');
3034: Fnd_Msg_Pub.ADD;
3035: END IF;
3036: RAISE Fnd_Api.g_exc_error;
3037: END IF;

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

3050: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3051: IF (l_ship_date < p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Return line
3052: CLOSE ahl_oe_schedule_date_csr;
3053: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3054: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3055: Fnd_Msg_Pub.ADD;
3056: END IF;
3057: RAISE Fnd_Api.g_exc_error;
3058: END IF;

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

3061: --For others, return date must be after the ship date
3062: IF (l_ship_date > p_x_line_tbl(i).schedule_ship_date) THEN
3063: CLOSE ahl_oe_schedule_date_csr;
3064: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3065: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3066: Fnd_Msg_Pub.ADD;
3067: END IF;
3068: RAISE Fnd_Api.g_exc_error;
3069: END IF; -- Ship Date > Return Date

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

3140: IF (p_x_line_tbl(i).operation <> 'D') THEN
3141: 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
3142: -- Need to set exchange instance before creating return shipment line for exchange orders
3143: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3144: Fnd_Message.set_name('AHL', 'AHL_OSP_EXC_INST_ID_NULL');
3145: Fnd_Msg_Pub.ADD;
3146: END IF;
3147: RAISE Fnd_Api.g_exc_error;
3148: END IF;

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

3181: NVL(p_x_line_tbl(i).serial_number, 'X') <> NVL(l_old_serial_number, 'X') OR
3182: p_x_line_tbl(i).ordered_quantity <> l_old_quantity OR
3183: p_x_line_tbl(i).order_quantity_uom <> l_old_uom OR
3184: NVL(p_x_line_tbl(i).lot_number, 'X') <> NVL(l_old_lot_number, 'X')) THEN
3185: Fnd_Message.set_name('AHL', 'AHL_OSP_ITEM_ATTR_NO_CHANGE');
3186: Fnd_Msg_Pub.ADD;
3187: RAISE Fnd_Api.g_exc_error;
3188: END IF;
3189: --Bug fix 4580226 ends

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

3282: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
3283: -- Instance is installed as a component
3284: CLOSE ahl_csi_unit_test_csr;
3285: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3286: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
3287: Fnd_Msg_Pub.ADD;
3288: END IF;
3289: RAISE Fnd_Api.g_exc_error;
3290: END IF;

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

3340: FETCH ahl_oe_ship_id_csr INTO l_return_line_id;
3341: IF (ahl_oe_ship_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3342: CLOSE ahl_oe_ship_id_csr;
3343: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3344: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_LINE_DEFINED');
3345: Fnd_Msg_Pub.ADD;
3346: END IF;
3347: RAISE Fnd_Api.g_exc_error;
3348: END IF;

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

3371: /*
3372: IF (p_x_line_tbl(i).order_type = 'BORROW' AND l_return_line_id IS NULL) THEN
3373: CLOSE ahl_oe_Inv_schedule_date_csr;
3374: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3375: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_BORROW_ORDER');
3376: Fnd_Msg_Pub.ADD;
3377: END IF;
3378: RAISE Fnd_Api.g_exc_error;
3379: END IF;

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

3384: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3385: 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
3386: CLOSE ahl_oe_Inv_schedule_date_csr;
3387: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3388: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3389: Fnd_Msg_Pub.ADD;
3390: END IF;
3391: RAISE Fnd_Api.g_exc_error;
3392: END IF;

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

3395: --For others, ship date must be before return date
3396: IF (l_return_date < p_x_line_tbl(i).schedule_ship_date) THEN
3397: CLOSE ahl_oe_Inv_schedule_date_csr;
3398: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3399: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3400: Fnd_Msg_Pub.ADD;
3401: END IF;
3402: RAISE Fnd_Api.g_exc_error;
3403: END IF; -- Return Date < Ship Date

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

3449: IF (ahl_oe_return_id_csr%FOUND AND p_x_line_tbl(i).operation = 'C') THEN
3450:
3451: CLOSE ahl_oe_return_id_csr;
3452: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3453: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_LINE_DEFINED');
3454: Fnd_Msg_Pub.ADD;
3455: END IF;
3456: RAISE Fnd_Api.g_exc_error;
3457: END IF;

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

3477: IF(p_x_line_tbl(i).order_type = 'BORROW') THEN
3478: IF (l_ship_date < p_x_line_tbl(i).schedule_ship_date) THEN -- Note that we are in the context of a Return line
3479: CLOSE ahl_oe_Inv_schedule_date_csr;
3480: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3481: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3482: Fnd_Msg_Pub.ADD;
3483: END IF;
3484: RAISE Fnd_Api.g_exc_error;
3485: END IF;

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

3488: --For others, return date must be after the ship date
3489: IF (l_ship_date > p_x_line_tbl(i).schedule_ship_date) THEN
3490: CLOSE ahl_oe_Inv_schedule_date_csr;
3491: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3492: Fnd_Message.set_name('AHL', 'AHL_OSP_SCHEDULE_DATE_ERROR');
3493: Fnd_Msg_Pub.ADD;
3494: END IF;
3495: RAISE Fnd_Api.g_exc_error;
3496: END IF; -- Ship Date > Return Date

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

3508: p_x_line_tbl(i).osp_line_id := null;
3509: p_x_line_tbl(i).osp_line_number := null;
3510:
3511: IF p_x_line_tbl(i).schedule_ship_date < TRUNC(sysdate) THEN
3512: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_DATE_LT_SYS');
3513: Fnd_Msg_Pub.ADD;
3514: RAISE Fnd_Api.g_exc_error;
3515: END IF;
3516:

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

3518: p_x_line_tbl(i).line_type := 'SHIP';
3519: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3520: p_x_line_tbl(i).line_type := 'RETURN';
3521: ELSE
3522: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3523: Fnd_Msg_Pub.ADD;
3524: END IF;
3525: IF p_x_line_tbl(i).line_type IS NULL THEN
3526: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');

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

3522: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3523: Fnd_Msg_Pub.ADD;
3524: END IF;
3525: IF p_x_line_tbl(i).line_type IS NULL THEN
3526: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3527: Fnd_Msg_Pub.ADD;
3528: ELSIF p_x_line_tbl(i).line_type = 'RETURN' AND p_x_line_tbl(i).return_reason_code IS NULL THEN
3529: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_REASON_NULL');
3530: Fnd_Msg_Pub.ADD;

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

3525: IF p_x_line_tbl(i).line_type IS NULL THEN
3526: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3527: Fnd_Msg_Pub.ADD;
3528: ELSIF p_x_line_tbl(i).line_type = 'RETURN' AND p_x_line_tbl(i).return_reason_code IS NULL THEN
3529: Fnd_Message.set_name('AHL', 'AHL_OSP_RETURN_REASON_NULL');
3530: Fnd_Msg_Pub.ADD;
3531: END IF;
3532:
3533: IF p_x_line_tbl(i).osp_order_id IS NULL THEN

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

3530: Fnd_Msg_Pub.ADD;
3531: END IF;
3532:
3533: IF p_x_line_tbl(i).osp_order_id IS NULL THEN
3534: Fnd_Message.set_name('AHL', 'AHL_OSP_PRIMARY_KEY_NULL');
3535: Fnd_Msg_Pub.ADD;
3536: END IF;
3537:
3538:

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

3553: --p_x_line_tbl(i).serial_number,
3554: --p_x_line_tbl(i).LOT_NUMBER
3555: FETCH validate_item INTO l_dummy;
3556: IF validate_item%NOTFOUND THEN
3557: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');
3558: Fnd_Msg_Pub.ADD;
3559: CLOSE validate_item;
3560: RAISE Fnd_Api.g_exc_error;
3561: END IF;

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

3618:
3619: -- Default the Return Reason from the Profile
3620: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3621: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3622: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3623: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3624: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3625: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3626: FND_MSG_PUB.ADD;

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

3620: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3621: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3622: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3623: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3624: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3625: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3626: FND_MSG_PUB.ADD;
3627: RAISE Fnd_Api.g_exc_error;
3628: END IF;

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

3621: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3622: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3623: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3624: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');
3625: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_LINE_RET_REASON_CODE'));
3626: FND_MSG_PUB.ADD;
3627: RAISE Fnd_Api.g_exc_error;
3628: END IF;
3629: p_x_line_tbl(l_index).return_reason := NULL;

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

3645:
3646: IF l_service_duration is null THEN
3647: -- Check if the Default Duration Profile has been Set
3648: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3649: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3650: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3651: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3652: FND_MSG_PUB.ADD;
3653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3646: IF l_service_duration is null THEN
3647: -- Check if the Default Duration Profile has been Set
3648: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3649: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3650: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3651: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3652: FND_MSG_PUB.ADD;
3653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3654: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

3647: -- Check if the Default Duration Profile has been Set
3648: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3649: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3650: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3651: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3652: FND_MSG_PUB.ADD;
3653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3654: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
3655: END IF;

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

3705: OPEN ahl_osp_work_csr(I.WORKORDER_ID);
3706: FETCH ahl_osp_work_csr INTO l_work_det;
3707: -- jaramana June 4, 2005: Added check for Workorder
3708: IF(ahl_osp_work_csr%NOTFOUND) THEN
3709: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_OSP_LN_INV_WO');
3710: FND_MESSAGE.Set_Token('WORKORDER_ID', I.WORKORDER_ID);
3711: CLOSE ahl_osp_work_csr;
3712: RAISE Fnd_Api.g_exc_error;
3713: END IF;

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

3706: FETCH ahl_osp_work_csr INTO l_work_det;
3707: -- jaramana June 4, 2005: Added check for Workorder
3708: IF(ahl_osp_work_csr%NOTFOUND) THEN
3709: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_OSP_LN_INV_WO');
3710: FND_MESSAGE.Set_Token('WORKORDER_ID', I.WORKORDER_ID);
3711: CLOSE ahl_osp_work_csr;
3712: RAISE Fnd_Api.g_exc_error;
3713: END IF;
3714: CLOSE ahl_osp_work_csr;

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

3734: IF (ahl_csi_unit_test_csr%NOTFOUND) THEN
3735: -- Instance is installed as a component
3736: CLOSE ahl_csi_unit_test_csr;
3737: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3738: Fnd_Message.set_name('AHL', 'AHL_OSP_SHIP_COMPONENT');
3739: Fnd_Msg_Pub.ADD;
3740: END IF;
3741: RAISE Fnd_Api.g_exc_error;
3742: END IF;

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

4023: FETCH ahl_ship_from_orgs_csr INTO l_line_rec.ship_from_org_id;
4024: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
4025: CLOSE ahl_ship_from_orgs_csr;
4026: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4027: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
4028: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG', p_line_tbl(i).ship_from_org);
4029: FND_MSG_PUB.ADD;
4030: END IF;
4031: RAISE Fnd_Api.g_exc_error;

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

4024: IF (ahl_ship_from_orgs_csr%NOTFOUND) THEN
4025: CLOSE ahl_ship_from_orgs_csr;
4026: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4027: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_FROM_ORG_INV');
4028: FND_MESSAGE.SET_TOKEN('SHIP_FROM_ORG', p_line_tbl(i).ship_from_org);
4029: FND_MSG_PUB.ADD;
4030: END IF;
4031: RAISE Fnd_Api.g_exc_error;
4032: END IF;

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

4246: FETCH ahl_osp_order_csr INTO l_osp_order;
4247: IF (ahl_osp_order_csr%NOTFOUND) THEN
4248: CLOSE ahl_osp_order_csr;
4249: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4250: Fnd_Message.set_name('AHL', 'AHL_OSP_OSP_ID_NULL');
4251: Fnd_Msg_Pub.ADD;
4252: END IF;
4253: RAISE Fnd_Api.g_exc_error;
4254: END IF;

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

4441: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4442: END LOOP;
4443:
4444: IF l_row_check = 'N' THEN
4445: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4446: Fnd_Msg_Pub.ADD;
4447: RAISE Fnd_Api.g_exc_error;
4448: END IF;
4449:

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

4653: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4654: END LOOP;
4655:
4656: IF l_row_check = 'N' THEN
4657: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4658: Fnd_Msg_Pub.ADD;
4659: RAISE Fnd_Api.g_exc_error;
4660: END IF;
4661:

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

4750: -- Validate exchange instance
4751: OPEN val_exg_instance_id_csr(p_exchange_instance_id);
4752: FETCH val_exg_instance_id_csr INTO l_exist;
4753: IF (val_exg_instance_id_csr %NOTFOUND) THEN
4754: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIP_COMPONENT');
4755: FND_MSG_PUB.ADD;
4756: CLOSE val_exg_instance_id_csr;
4757: RAISE Fnd_Api.g_exc_error;
4758: END IF;

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

4812: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
4813: END LOOP;
4814:
4815: IF l_row_check = 'N' THEN
4816: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
4817: Fnd_Msg_Pub.ADD;
4818: RAISE Fnd_Api.g_exc_error;
4819: END IF;
4820:

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

5029: OPEN csi_txn_types_csr(G_OM_ORDER);
5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5034: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5035: FND_MSG_PUB.ADD;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5037: RETURN;

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

5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5034: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5035: FND_MSG_PUB.ADD;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5037: RETURN;
5038: END IF;

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

5042: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5043: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5044: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5045: IF l_subtxn_id IS NULL THEN
5046: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5047: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5048: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5049: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5050: FND_MSG_PUB.ADD;

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

5043: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5044: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5045: IF l_subtxn_id IS NULL THEN
5046: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5047: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5048: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5049: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5050: FND_MSG_PUB.ADD;
5051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5044: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5045: IF l_subtxn_id IS NULL THEN
5046: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5047: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5048: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5049: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5050: FND_MSG_PUB.ADD;
5051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5052: RETURN;

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

5045: IF l_subtxn_id IS NULL THEN
5046: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5047: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5048: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5049: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_SHIP'));
5050: FND_MSG_PUB.ADD;
5051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5052: RETURN;
5053: END IF;

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

5054: OPEN get_sold_to_org(p_oe_line_id);
5055: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_account_id;
5056: IF (get_sold_to_org%NOTFOUND) THEN
5057: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5058: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5059: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5060: Fnd_Msg_Pub.ADD;
5061: END IF;
5062: CLOSE get_sold_to_org;

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

5055: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_account_id;
5056: IF (get_sold_to_org%NOTFOUND) THEN
5057: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5058: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5059: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5060: Fnd_Msg_Pub.ADD;
5061: END IF;
5062: CLOSE get_sold_to_org;
5063: RAISE Fnd_Api.g_exc_error;

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

5077: FETCH get_owner_ip_id INTO l_curr_inst_pty_id,
5078: l_curr_pty_id;
5079: IF (get_owner_ip_id%NOTFOUND) THEN
5080: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5081: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5082: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5083: Fnd_Msg_Pub.ADD;
5084: END IF;
5085: CLOSE get_owner_ip_id;

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

5078: l_curr_pty_id;
5079: IF (get_owner_ip_id%NOTFOUND) THEN
5080: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5081: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5082: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5083: Fnd_Msg_Pub.ADD;
5084: END IF;
5085: CLOSE get_owner_ip_id;
5086: RAISE Fnd_Api.g_exc_error;

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

5106: END IF;
5107: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5108: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5109: IF l_subtxn_id IS NULL THEN
5110: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5111: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5112: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5113: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5114: FND_MSG_PUB.ADD;

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

5107: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5108: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5109: IF l_subtxn_id IS NULL THEN
5110: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5111: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5112: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5113: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5114: FND_MSG_PUB.ADD;
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5108: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5109: IF l_subtxn_id IS NULL THEN
5110: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5111: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5112: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5113: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5114: FND_MSG_PUB.ADD;
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5116: RETURN;

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

5109: IF l_subtxn_id IS NULL THEN
5110: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5111: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5112: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5113: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_SHIP'));
5114: FND_MSG_PUB.ADD;
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5116: RETURN;
5117: END IF;

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

5118: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5119: --l_subtxn_name := G_SUBTXN_ORDER;
5120: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5121: IF l_subtxn_id IS NULL THEN
5122: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5123: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5124: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5125: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5126: FND_MSG_PUB.ADD;

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

5119: --l_subtxn_name := G_SUBTXN_ORDER;
5120: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5121: IF l_subtxn_id IS NULL THEN
5122: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5123: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5124: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5125: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5126: FND_MSG_PUB.ADD;
5127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5120: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5121: IF l_subtxn_id IS NULL THEN
5122: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5123: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5124: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5125: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5126: FND_MSG_PUB.ADD;
5127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5128: RETURN;

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

5121: IF l_subtxn_id IS NULL THEN
5122: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5123: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5124: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5125: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_SHIP'));
5126: FND_MSG_PUB.ADD;
5127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5128: RETURN;
5129: END IF;

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

5133: OPEN csi_txn_sub_types_csr(l_om_order_id, l_subtxn_name);
5134: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5135: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5136: CLOSE csi_txn_sub_types_csr;
5137: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5138: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5139: FND_MSG_PUB.ADD;
5140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5141: RETURN;

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

5134: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5135: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5136: CLOSE csi_txn_sub_types_csr;
5137: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5138: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5139: FND_MSG_PUB.ADD;
5140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5141: RETURN;
5142: END IF;

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

5148: OPEN csi_txn_types_csr(G_OM_RETURN);
5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5153: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5154: FND_MSG_PUB.ADD;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5156: RETURN;

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

5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5153: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5154: FND_MSG_PUB.ADD;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5156: RETURN;
5157: END IF;

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

5161: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5162: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5163: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5164: IF l_subtxn_id IS NULL THEN
5165: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5166: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5167: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5168: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5169: FND_MSG_PUB.ADD;

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

5162: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5163: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5164: IF l_subtxn_id IS NULL THEN
5165: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5166: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5167: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5168: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5169: FND_MSG_PUB.ADD;
5170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5163: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5164: IF l_subtxn_id IS NULL THEN
5165: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5166: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5167: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5168: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_EXC_RETURN'));
5169: FND_MSG_PUB.ADD;
5170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5171: RETURN;

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

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

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

5174: OPEN get_internal_party_csr;
5175: FETCH get_internal_party_csr INTO l_internal_party_id;
5176: IF (get_internal_party_csr%NOTFOUND) THEN
5177: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5178: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');
5179: Fnd_Msg_Pub.ADD;
5180: END IF;
5181: CLOSE get_internal_party_csr;
5182: RAISE Fnd_Api.g_exc_error;

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

5194: FETCH get_owner_ip_id INTO l_curr_inst_pty_id,
5195: l_curr_pty_id;
5196: IF (get_owner_ip_id%NOTFOUND) THEN
5197: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5198: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5199: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5200: Fnd_Msg_Pub.ADD;
5201: END IF;
5202: CLOSE get_owner_ip_id;

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

5195: l_curr_pty_id;
5196: IF (get_owner_ip_id%NOTFOUND) THEN
5197: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5198: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5199: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(p_csi_instance_id));
5200: Fnd_Msg_Pub.ADD;
5201: END IF;
5202: CLOSE get_owner_ip_id;
5203: RAISE Fnd_Api.g_exc_error;

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

5218: END IF;
5219: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5220: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5221: IF l_subtxn_id IS NULL THEN
5222: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5223: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5224: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5225: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5226: FND_MSG_PUB.ADD;

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

5219: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5220: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5221: IF l_subtxn_id IS NULL THEN
5222: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5223: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5224: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5225: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5226: FND_MSG_PUB.ADD;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5220: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5221: IF l_subtxn_id IS NULL THEN
5222: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5223: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5224: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5225: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5226: FND_MSG_PUB.ADD;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: RETURN;

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

5221: IF l_subtxn_id IS NULL THEN
5222: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5223: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5224: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5225: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_SER_RETURN'));
5226: FND_MSG_PUB.ADD;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: RETURN;
5229: END IF;

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

5229: END IF;
5230: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5231: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5232: IF l_subtxn_id IS NULL THEN
5233: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5234: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5235: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5236: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5237: FND_MSG_PUB.ADD;

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

5230: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5231: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5232: IF l_subtxn_id IS NULL THEN
5233: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5234: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5235: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5236: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5237: FND_MSG_PUB.ADD;
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5231: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5232: IF l_subtxn_id IS NULL THEN
5233: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5234: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5235: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5236: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5237: FND_MSG_PUB.ADD;
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: RETURN;

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

5232: IF l_subtxn_id IS NULL THEN
5233: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5234: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5235: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
5236: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_IB_SUBTXN_BOR_RETURN'));
5237: FND_MSG_PUB.ADD;
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: RETURN;
5240: END IF;

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

5244: OPEN csi_txn_sub_types_csr(l_om_order_id, l_subtxn_name);
5245: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5246: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5247: CLOSE csi_txn_sub_types_csr;
5248: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5249: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5250: FND_MSG_PUB.ADD;
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252: RETURN;

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

5245: FETCH csi_txn_sub_types_csr INTO l_subtxn_id;
5246: IF (csi_txn_sub_types_csr%NOTFOUND) THEN
5247: CLOSE csi_txn_sub_types_csr;
5248: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5249: FND_MESSAGE.Set_Token('TYPE',l_subtxn_name);
5250: FND_MSG_PUB.ADD;
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252: RETURN;
5253: END IF;

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

5547: FETCH validate_osp_id_csr INTO l_dummy;
5548: IF (validate_osp_id_csr%NOTFOUND) THEN
5549: CLOSE validate_osp_id_csr;
5550: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5551: Fnd_Message.set_name('AHL', 'AHL_OSP_HEADER_ID_INV');
5552: Fnd_Msg_Pub.ADD;
5553: END IF;
5554: RAISE Fnd_Api.g_exc_error;
5555: END IF;

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

5567: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) OR
5568: (p_new_order_type_code NOT IN (AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE,
5569: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE))) THEN
5570: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5571: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');
5572: Fnd_Msg_Pub.ADD;
5573: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5574: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5575: END IF;

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

5591: IF (l_shipped_quantity IS NOT NULL AND
5592: l_shipped_quantity > 0) THEN
5593: -- Return line is already shipped: Too late to convert!
5594: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5595: Fnd_Message.set_name('AHL', 'AHL_OSP_ALREADY_SHIPPED');
5596: Fnd_Msg_Pub.ADD;
5597: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5598: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5599: END IF;

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

5783: OPEN get_internal_party_csr;
5784: FETCH get_internal_party_csr INTO l_internal_party_id;
5785: IF (get_internal_party_csr%NOTFOUND) THEN
5786: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5787: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_INT_PARTY');
5788: Fnd_Msg_Pub.ADD;
5789: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5790: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5791: END IF;

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

5821: l_curr_pty_id,
5822: l_party_ovn;
5823: IF (get_owner_ip_id%NOTFOUND) THEN
5824: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5825: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5826: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5827: Fnd_Msg_Pub.ADD;
5828: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5829: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

5822: l_party_ovn;
5823: IF (get_owner_ip_id%NOTFOUND) THEN
5824: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5825: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_CURR_PARTY');
5826: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5827: Fnd_Msg_Pub.ADD;
5828: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5829: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5830: END IF;

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

5851: OPEN get_sold_to_org(l_oe_ship_line_id);
5852: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_acc_id;
5853: IF (get_sold_to_org%NOTFOUND) THEN
5854: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5855: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5856: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5857: Fnd_Msg_Pub.ADD;
5858: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5859: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

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

5852: FETCH get_sold_to_org INTO l_new_party_id, l_new_party_acc_id;
5853: IF (get_sold_to_org%NOTFOUND) THEN
5854: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5855: Fnd_Message.set_name('AHL', 'AHL_OSP_CANT_GET_NEW_PARTY');
5856: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', GET_INSTANCE_NUM_FROM_ID(l_item_instance_id));
5857: Fnd_Msg_Pub.ADD;
5858: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5859: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
5860: END IF;

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

5868: 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);
5869: END IF;
5870: ELSE
5871: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5872: Fnd_Message.set_name('AHL', 'AHL_OSP_INV_TYPE_CHANGE');
5873: Fnd_Msg_Pub.ADD;
5874: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5875: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
5876: END IF;

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

6171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_vendor_cust_dtls.customer_site_id = ' || l_vendor_cust_dtls.customer_site_id);
6172: END IF;
6173:
6174: IF l_vendor_cust_dtls.customer_site_id IS NULL THEN
6175: Fnd_Message.set_name('AHL', 'AHL_OSP_CUST_SETUP_NOTFOUND');
6176: Fnd_Msg_Pub.ADD;
6177: RAISE Fnd_Api.g_exc_error;
6178: END IF;
6179:

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

6758: END IF;
6759:
6760: --osp_order_line_id should not be null
6761: IF(p_serialnum_change_rec.osp_line_id is NULL) THEN
6762: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPLID_NLL');
6763: FND_MSG_PUB.ADD;
6764: RAISE FND_API.G_EXC_ERROR;
6765: END IF;
6766:

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

6767: --validate the osp_order_line_id
6768: OPEN get_osp_order_line_dtls(l_serialnum_change_rec.osp_line_id);
6769: FETCH get_osp_order_line_dtls INTO l_osp_order_line_dtls;
6770: IF (get_osp_order_line_dtls%NOTFOUND) THEN
6771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INVOP_OSP_LN_NFOUND');
6772: FND_MSG_PUB.ADD;
6773: CLOSE get_osp_order_line_dtls;
6774: RAISE FND_API.G_EXC_ERROR;
6775: END IF;

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

6776: CLOSE get_osp_order_line_dtls;
6777:
6778: --check that the osp line is valid for the part number change
6779: IF(Is_part_chg_valid_for_ospline(p_serialnum_change_rec.osp_line_id) = 'N') THEN
6780: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_OSPL_INV');
6781: FND_MSG_PUB.ADD;
6782: RAISE FND_API.G_EXC_ERROR;
6783: END IF;
6784:

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

6788: OPEN c_get_inv_item_id(l_serialnum_change_rec.new_item_number);
6789: FETCH c_get_inv_item_id INTO l_inventory_item_id;
6790: CLOSE c_get_inv_item_id;
6791: IF l_inventory_item_id IS NULL THEN
6792: FND_MESSAGE.Set_Name('AHL','AHL_OSP_ITEM_INVALID');
6793: FND_MESSAGE.Set_token('ITEM',l_serialnum_change_rec.new_item_number);
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;

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

6789: FETCH c_get_inv_item_id INTO l_inventory_item_id;
6790: CLOSE c_get_inv_item_id;
6791: IF l_inventory_item_id IS NULL THEN
6792: FND_MESSAGE.Set_Name('AHL','AHL_OSP_ITEM_INVALID');
6793: FND_MESSAGE.Set_token('ITEM',l_serialnum_change_rec.new_item_number);
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;
6797: ELSE

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

6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;
6797: ELSE
6798: FND_MESSAGE.Set_Name('AHL','AHL_OSP_INV_ITEM_NULL');
6799: FND_MSG_PUB.ADD;
6800: RAISE FND_API.G_EXC_ERROR;
6801: END IF;
6802:

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

6814: --If passed instance_id is null, derive it from the osp line, else check that its the one present on the osp line.
6815: OPEN get_ship_line_instance(l_serialnum_change_rec.osp_line_id);
6816: FETCH get_ship_line_instance INTO l_ship_line_instance_id;
6817: IF (get_ship_line_instance%NOTFOUND) THEN
6818: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SHIPLINE_NO_INST');
6819: FND_MSG_PUB.ADD;
6820: CLOSE get_ship_line_instance;
6821: RAISE FND_API.G_EXC_ERROR;
6822: END IF;

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

6828: IF (l_serialnum_change_rec.instance_id is NULL) THEN
6829: l_serialnum_change_rec.instance_id := l_ship_line_instance_id;
6830: ELSE
6831: IF(l_serialnum_change_rec.instance_id <> l_ship_line_instance_id) THEN
6832: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
6833: FND_MSG_PUB.ADD;
6834: RAISE FND_API.G_EXC_ERROR;
6835: END IF;
6836: END IF;

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

6842: OPEN get_instance_details(l_serialnum_change_rec.instance_id);
6843: FETCH get_instance_details INTO l_instance_dtls_rec;
6844: CLOSE get_instance_details;
6845: IF l_instance_dtls_rec.instance_id IS NULL THEN
6846: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
6847: FND_MSG_PUB.ADD;
6848: RAISE FND_API.G_EXC_ERROR;
6849: END IF;
6850:

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

6886: l_serialnum_change_rec.New_Serial_Tag_Mean,
6887: l_lookup_code,
6888: l_return_val);
6889: IF NOT(l_return_val) THEN
6890: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
6891: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
6892: FND_MSG_PUB.ADD;
6893: RAISE FND_API.G_EXC_ERROR;
6894: ELSE

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

6887: l_lookup_code,
6888: l_return_val);
6889: IF NOT(l_return_val) THEN
6890: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
6891: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
6892: FND_MSG_PUB.ADD;
6893: RAISE FND_API.G_EXC_ERROR;
6894: ELSE
6895: l_serialnum_change_rec.New_Serial_Tag_Code := l_lookup_code;

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

6900: --get the item information
6901: OPEN mtl_system_items_csr(l_inventory_item_id, l_organization_id);
6902: FETCH mtl_system_items_csr INTO l_mtl_system_items_rec;
6903: IF (mtl_system_items_csr%NOTFOUND) THEN
6904: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ITEM_INVALID');
6905: FND_MESSAGE.Set_token('ITEM',l_inventory_item_id);
6906: FND_MSG_PUB.ADD;
6907: CLOSE mtl_system_items_csr;
6908: RAISE FND_API.G_EXC_ERROR;

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

6901: OPEN mtl_system_items_csr(l_inventory_item_id, l_organization_id);
6902: FETCH mtl_system_items_csr INTO l_mtl_system_items_rec;
6903: IF (mtl_system_items_csr%NOTFOUND) THEN
6904: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ITEM_INVALID');
6905: FND_MESSAGE.Set_token('ITEM',l_inventory_item_id);
6906: FND_MSG_PUB.ADD;
6907: CLOSE mtl_system_items_csr;
6908: RAISE FND_API.G_EXC_ERROR;
6909: END IF;

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

6914: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Invalid Item: Has to be serial controlled and IB trackable '||
6916: ' 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 );
6917: END IF;
6918: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_ITEM_SER_TR');
6919: FND_MESSAGE.Set_token('ITEM',l_mtl_system_items_rec.concatenated_segments);
6920: FND_MSG_PUB.ADD;
6921: RAISE FND_API.G_EXC_ERROR;
6922: END IF;

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

6915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Invalid Item: Has to be serial controlled and IB trackable '||
6916: ' 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 );
6917: END IF;
6918: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_CHG_ITEM_SER_TR');
6919: FND_MESSAGE.Set_token('ITEM',l_mtl_system_items_rec.concatenated_segments);
6920: FND_MSG_PUB.ADD;
6921: RAISE FND_API.G_EXC_ERROR;
6922: END IF;
6923:

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

7093: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) THEN
7094: -- create extended attributes.
7095: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7096: IF NOT(l_return_val) THEN
7097: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7098: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7099: FND_MSG_PUB.ADD;
7100: ELSE
7101: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;

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

7094: -- create extended attributes.
7095: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7096: IF NOT(l_return_val) THEN
7097: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7098: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7099: FND_MSG_PUB.ADD;
7100: ELSE
7101: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;
7102: l_csi_extend_attrib_rec1.attribute_value := l_serialnum_change_rec.New_Serial_Tag_Code;