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

Line 63: fnd_message.set_name('INV', 'INV_INVALID_ITEM');

59: x_lot_cont := FALSE ;
60: x_child_lot_cont := FALSE ;
61: x_return_status := fnd_api.g_ret_sts_error;
62:
63: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
64: fnd_msg_pub.ADD;
65: RAISE fnd_api.g_exc_error;
66: ELSE
67: CLOSE c_chk_msi_attr;

Line 219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

215: IF l_return_status = fnd_api.g_ret_sts_error THEN
216: IF g_debug = 1 THEN
217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
218: END IF;
219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
221: FND_MSG_PUB.ADD;
222: RAISE fnd_api.g_exc_error;
223: END IF;

Line 220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

216: IF g_debug = 1 THEN
217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
218: END IF;
219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
221: FND_MSG_PUB.ADD;
222: RAISE fnd_api.g_exc_error;
223: END IF;
224:

Line 229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
226: IF g_debug = 1 THEN
227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
228: END IF;
229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
231: fnd_msg_pub.ADD;
232: RAISE fnd_api.g_exc_unexpected_error;
233: END IF;

Line 230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

226: IF g_debug = 1 THEN
227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
228: END IF;
229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
231: fnd_msg_pub.ADD;
232: RAISE fnd_api.g_exc_unexpected_error;
233: END IF;
234:

Line 239: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');

235: IF (l_lot_cont = FALSE) THEN
236: IF g_debug = 1 THEN
237: print_debug(' Item is not lot controlled ', 9);
238: END IF;
239: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
240: fnd_msg_pub.ADD;
241: x_return_status := fnd_api.g_ret_sts_error;
242: RAISE fnd_api.g_exc_error;
243: END IF ;

Line 250: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');

246:
247: IF g_debug = 1 THEN
248: print_debug(' Item is not Child lot controlled ', 9);
249: END IF;
250: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
251: fnd_msg_pub.ADD;
252: x_return_status := fnd_api.g_ret_sts_error;
253: RAISE fnd_api.g_exc_error;
254: END IF ;

Line 437: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

433: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
434: IF g_debug = 1 THEN
435: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a Unexpected exception', 9);
436: END IF;
437: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');
439: FND_MSG_PUB.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;

Line 438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');

434: IF g_debug = 1 THEN
435: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a Unexpected exception', 9);
436: END IF;
437: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');
439: FND_MSG_PUB.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:

Line 477: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

473: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: IF g_debug = 1 THEN
475: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
476: END IF;
477: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
478: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
479: FND_MSG_PUB.ADD;
480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;

Line 478: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');

474: IF g_debug = 1 THEN
475: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
476: END IF;
477: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
478: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
479: FND_MSG_PUB.ADD;
480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;
482: END IF ; --parent lot check

Line 503: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
500: IF g_debug = 1 THEN
501: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a Unexpected exception', 9);
502: END IF;
503: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');
505: FND_MSG_PUB.ADD;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;

Line 504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');

500: IF g_debug = 1 THEN
501: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a Unexpected exception', 9);
502: END IF;
503: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');
505: FND_MSG_PUB.ADD;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508:

Line 656: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

652: IF l_return_status = fnd_api.g_ret_sts_error THEN
653: IF g_debug = 1 THEN
654: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
655: END IF;
656: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
658: FND_MSG_PUB.ADD;
659: RAISE fnd_api.g_exc_error;
660: END IF;

Line 657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

653: IF g_debug = 1 THEN
654: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
655: END IF;
656: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
658: FND_MSG_PUB.ADD;
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:

Line 666: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

662: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
663: IF g_debug = 1 THEN
664: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
665: END IF;
666: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
668: fnd_msg_pub.ADD;
669: RAISE fnd_api.g_exc_unexpected_error;
670: END IF;

Line 667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

663: IF g_debug = 1 THEN
664: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
665: END IF;
666: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
668: fnd_msg_pub.ADD;
669: RAISE fnd_api.g_exc_unexpected_error;
670: END IF;
671:

Line 676: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');

672: IF (l_lot_cont = FALSE) THEN
673: IF g_debug = 1 THEN
674: print_debug(' Item is not lot controlled ', 9);
675: END IF;
676: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
677: fnd_msg_pub.ADD;
678: x_return_status := fnd_api.g_ret_sts_error;
679: RAISE fnd_api.g_exc_error;
680: END IF ;

Line 687: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');

683:
684: IF g_debug = 1 THEN
685: print_debug(' Item is not Child lot controlled ', 9);
686: END IF;
687: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
688: fnd_msg_pub.ADD;
689: x_return_status := fnd_api.g_ret_sts_error;
690: RAISE fnd_api.g_exc_error;
691: END IF ;

Line 786: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

782: IF l_return_status <> fnd_api.g_ret_sts_success THEN
783: IF g_debug = 1 THEN
784: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
785: END IF;
786: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
787: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
788: fnd_msg_pub.ADD;
789: RAISE fnd_api.g_exc_unexpected_error;
790: END IF;

Line 787: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');

783: IF g_debug = 1 THEN
784: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
785: END IF;
786: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
787: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
788: fnd_msg_pub.ADD;
789: RAISE fnd_api.g_exc_unexpected_error;
790: END IF;
791: IF g_debug = 1 THEN

Line 819: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

815: IF l_return_status <> fnd_api.g_ret_sts_success THEN
816: IF g_debug = 1 THEN
817: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
818: END IF;
819: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
820: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;

Line 820: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');

816: IF g_debug = 1 THEN
817: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
818: END IF;
819: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
820: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824: IF g_debug = 1 THEN

Line 1146: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

1142: IF l_return_status = fnd_api.g_ret_sts_error THEN
1143: IF g_debug = 1 THEN
1144: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1145: END IF;
1146: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1148: FND_MSG_PUB.ADD;
1149: RAISE fnd_api.g_exc_error;
1150: END IF;

Line 1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1143: IF g_debug = 1 THEN
1144: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1145: END IF;
1146: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1148: FND_MSG_PUB.ADD;
1149: RAISE fnd_api.g_exc_error;
1150: END IF;
1151:

Line 1156: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1152: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1153: IF g_debug = 1 THEN
1154: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1155: END IF;
1156: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1158: fnd_msg_pub.ADD;
1159: RAISE fnd_api.g_exc_unexpected_error;
1160: END IF;

Line 1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1153: IF g_debug = 1 THEN
1154: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1155: END IF;
1156: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1158: fnd_msg_pub.ADD;
1159: RAISE fnd_api.g_exc_unexpected_error;
1160: END IF;
1161:

Line 1166: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');

1162: IF (l_lot_cont = FALSE) THEN
1163: IF g_debug = 1 THEN
1164: print_debug(' Item is not lot controlled ', 9);
1165: END IF;
1166: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
1167: fnd_msg_pub.ADD;
1168: x_return_status := fnd_api.g_ret_sts_error;
1169: RAISE fnd_api.g_exc_error;
1170: END IF ;

Line 1177: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');

1173:
1174: IF g_debug = 1 THEN
1175: print_debug(' Item is not Child lot controlled ', 9);
1176: END IF;
1177: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
1178: fnd_msg_pub.ADD;
1179: x_return_status := fnd_api.g_ret_sts_error;
1180: RAISE fnd_api.g_exc_error;
1181: END IF ;

Line 1200: fnd_message.set_name('INV', 'INV_SHELF_LIFE_ERROR');

1196: WHERE inventory_item_id = p_inventory_item_id
1197: AND organization_id = p_organization_id;
1198: EXCEPTION
1199: WHEN NO_DATA_FOUND THEN
1200: fnd_message.set_name('INV', 'INV_SHELF_LIFE_ERROR');
1201: fnd_message.set_token('INV', 'ITEM');
1202: fnd_msg_pub.ADD;
1203:
1204: IF g_debug = 1 THEN

Line 1201: fnd_message.set_token('INV', 'ITEM');

1197: AND organization_id = p_organization_id;
1198: EXCEPTION
1199: WHEN NO_DATA_FOUND THEN
1200: fnd_message.set_name('INV', 'INV_SHELF_LIFE_ERROR');
1201: fnd_message.set_token('INV', 'ITEM');
1202: fnd_msg_pub.ADD;
1203:
1204: IF g_debug = 1 THEN
1205: print_debug('Unable to fetch shelf life code for the inventory item passed', 9);

Line 1233: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');

1229: INTO l_expiration_date
1230: FROM DUAL;
1231:
1232: IF TRUNC(l_expiration_date) <> trunc(p_expiration_date) THEN
1233: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
1234: fnd_msg_pub.ADD;
1235: IF g_debug = 1 THEN
1236: print_debug('Expiration will not be considered for shelf_life code of type ITEM_SHELF_LIFE_DAYS', 9);
1237: END IF;

Line 1248: fnd_message.set_name('INV', 'INV_LOT_EXPREQD');

1244: print_debug('Shelf_life code is of type USER_DEFINED_EXP_DATE', 9);
1245: END IF;
1246:
1247: IF p_expiration_date IS NULL THEN
1248: fnd_message.set_name('INV', 'INV_LOT_EXPREQD');
1249: fnd_msg_pub.ADD;
1250:
1251: IF g_debug = 1 THEN
1252: print_debug('The value of expiration date is required ', 9);

Line 1266: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');

1262: IF g_debug = 1 THEN
1263: print_debug('Shelf_life code is of type NO_SHELF_LIFE_CONTROL', 9);
1264: END IF;
1265:
1266: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
1267: fnd_msg_pub.ADD;
1268: END IF; /* l_shelf_life_code = item_shelf_life_days */
1269: END IF; /*p_source NOT IN(OSFM_FORM,OSFM_OPEN_INTERFACE)*/
1270:

Line 1288: FND_MESSAGE.SET_NAME('INV','INV_WRONG_CONTEXT');

1284:
1285:
1286: IF p_lot_attribute_category IS NOT NULL AND
1287: (nvl(l_lot_attribute_category, p_lot_attribute_category) <> p_lot_attribute_category) THEN
1288: FND_MESSAGE.SET_NAME('INV','INV_WRONG_CONTEXT');
1289: FND_MSG_PUB.ADD;
1290: RAISE fnd_api.g_exc_error;
1291: END IF;
1292: END IF ;

Line 1378: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1374: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1375: IF g_debug = 1 THEN
1376: print_debug('Program VALIDATE_LOT_ATTR_IN_PARAM has failed with a Unexpected exception', 9);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1379: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_LOT_ATTR_IN_PARAM');
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;

Line 1379: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_LOT_ATTR_IN_PARAM');

1375: IF g_debug = 1 THEN
1376: print_debug('Program VALIDATE_LOT_ATTR_IN_PARAM has failed with a Unexpected exception', 9);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1379: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_LOT_ATTR_IN_PARAM');
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383:

Line 1417: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1413: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1414: IF g_debug = 1 THEN
1415: print_debug('Program VALIDATE_ADDITIONAL_ATTR has failed with a Unexpected exception', 9);
1416: END IF;
1417: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1418: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_ADDITIONAL_ATTR');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;

Line 1418: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_ADDITIONAL_ATTR');

1414: IF g_debug = 1 THEN
1415: print_debug('Program VALIDATE_ADDITIONAL_ATTR has failed with a Unexpected exception', 9);
1416: END IF;
1417: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1418: FND_MESSAGE.SET_TOKEN('PROG_NAME','VALIDATE_ADDITIONAL_ATTR');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422:

Line 1691: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

1687: IF l_return_status = fnd_api.g_ret_sts_error THEN
1688: IF g_debug = 1 THEN
1689: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1690: END IF;
1691: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1693: FND_MSG_PUB.ADD;
1694: RAISE fnd_api.g_exc_error;
1695: END IF;

Line 1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1688: IF g_debug = 1 THEN
1689: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1690: END IF;
1691: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1693: FND_MSG_PUB.ADD;
1694: RAISE fnd_api.g_exc_error;
1695: END IF;
1696:

Line 1701: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1697: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1698: IF g_debug = 1 THEN
1699: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1700: END IF;
1701: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1703: fnd_msg_pub.ADD;
1704: RAISE fnd_api.g_exc_unexpected_error;
1705: END IF;

Line 1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1698: IF g_debug = 1 THEN
1699: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1700: END IF;
1701: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1703: fnd_msg_pub.ADD;
1704: RAISE fnd_api.g_exc_unexpected_error;
1705: END IF;
1706:

Line 1711: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');

1707: IF (l_lot_cont = FALSE) THEN
1708: IF g_debug = 1 THEN
1709: print_debug(' Item is not lot controlled ', 9);
1710: END IF;
1711: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
1712: fnd_msg_pub.ADD;
1713: x_return_status := fnd_api.g_ret_sts_error;
1714: RAISE fnd_api.g_exc_error;
1715: END IF ;

Line 1722: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');

1718:
1719: IF g_debug = 1 THEN
1720: print_debug(' Item is not Child lot controlled ', 9);
1721: END IF;
1722: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
1723: fnd_msg_pub.ADD;
1724: x_return_status := fnd_api.g_ret_sts_error;
1725: RAISE fnd_api.g_exc_error;
1726: END IF ;

Line 1761: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1757: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1758: IF g_debug = 1 THEN
1759: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1760: END IF;
1761: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1762: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1763: fnd_msg_pub.ADD;
1764: RAISE fnd_api.g_exc_unexpected_error;
1765: END IF;

Line 1762: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');

1758: IF g_debug = 1 THEN
1759: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1760: END IF;
1761: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1762: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1763: fnd_msg_pub.ADD;
1764: RAISE fnd_api.g_exc_unexpected_error;
1765: END IF;
1766:

Line 1772: fnd_message.set_name('INV', 'INV_INVALID_CHILD_LOT_EXP') ;

1768: IF g_debug = 1 THEN
1769: print_debug('Invalid child lot Naming convention', 9);
1770: END IF;
1771:
1772: fnd_message.set_name('INV', 'INV_INVALID_CHILD_LOT_EXP') ;
1773: fnd_msg_pub.ADD;
1774: RAISE fnd_api.g_exc_error;
1775: END IF;
1776: END IF ; -- parent_lot check

Line 1786: fnd_message.set_name('INV', 'INV_INVALID_PARENT_LOT_EXP') ;

1782: IF g_debug = 1 THEN
1783: print_debug('Invalid relationship between parent and child lots', 9);
1784: END IF;
1785:
1786: fnd_message.set_name('INV', 'INV_INVALID_PARENT_LOT_EXP') ;
1787: fnd_msg_pub.ADD;
1788: RAISE fnd_api.g_exc_error;
1789: END IF;
1790: END IF;

Line 1823: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1819: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1820: IF g_debug = 1 THEN
1821: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1822: END IF;
1823: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1825: FND_MSG_PUB.ADD;
1826: RAISE fnd_api.g_exc_unexpected_error;
1827: END IF;

Line 1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1820: IF g_debug = 1 THEN
1821: print_debug('Program INV_LOT_ATTR_PUB.validate_origination_type has failed with a Unexpected exception', 9);
1822: END IF;
1823: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1824: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1825: FND_MSG_PUB.ADD;
1826: RAISE fnd_api.g_exc_unexpected_error;
1827: END IF;
1828:

Line 1864: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1860: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1861: IF g_debug = 1 THEN
1862: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1863: END IF;
1864: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1866: FND_MSG_PUB.ADD;
1867: RAISE fnd_api.g_exc_unexpected_error;
1868: END IF;

Line 1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1861: IF g_debug = 1 THEN
1862: print_debug('Program INV_LOT_ATTR_PUB.validate_grade_code has failed with a Unexpected exception', 9);
1863: END IF;
1864: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1865: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1866: FND_MSG_PUB.ADD;
1867: RAISE fnd_api.g_exc_unexpected_error;
1868: END IF;
1869:

Line 1904: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1901: IF g_debug = 1 THEN
1902: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1903: END IF;
1904: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1906: FND_MSG_PUB.ADD;
1907: RAISE fnd_api.g_exc_unexpected_error;
1908: END IF;

Line 1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1901: IF g_debug = 1 THEN
1902: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_code has failed with a Unexpected exception', 9);
1903: END IF;
1904: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1905: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1906: FND_MSG_PUB.ADD;
1907: RAISE fnd_api.g_exc_unexpected_error;
1908: END IF;
1909:

Line 1951: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1947: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1948: IF g_debug = 1 THEN
1949: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
1950: END IF;
1951: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1953: FND_MSG_PUB.ADD;
1954: RAISE fnd_api.g_exc_unexpected_error;
1955: END IF;

Line 1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1948: IF g_debug = 1 THEN
1949: print_debug('Program INV_LOT_ATTR_PUB.validate_exp_action_date has failed with a Unexpected exception', 9);
1950: END IF;
1951: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1952: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1953: FND_MSG_PUB.ADD;
1954: RAISE fnd_api.g_exc_unexpected_error;
1955: END IF;
1956: END IF ; -- Check for positive expiration action interval

Line 1994: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

1990: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1991: IF g_debug = 1 THEN
1992: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
1993: END IF;
1994: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1996: FND_MSG_PUB.ADD;
1997: RAISE fnd_api.g_exc_unexpected_error;
1998: END IF;

Line 1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

1991: IF g_debug = 1 THEN
1992: print_debug('Program INV_LOT_ATTR_PUB.validate_retest_date has failed with a Unexpected exception', 9);
1993: END IF;
1994: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1995: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
1996: FND_MSG_PUB.ADD;
1997: RAISE fnd_api.g_exc_unexpected_error;
1998: END IF;
1999:

Line 2033: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

2029: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2030: IF g_debug = 1 THEN
2031: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2032: END IF;
2033: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2035: FND_MSG_PUB.ADD;
2036: RAISE fnd_api.g_exc_unexpected_error;
2037: END IF;

Line 2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

2030: IF g_debug = 1 THEN
2031: print_debug('Program INV_LOT_ATTR_PUB.validate_maturity_date has failed with a Unexpected exception', 9);
2032: END IF;
2033: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2034: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2035: FND_MSG_PUB.ADD;
2036: RAISE fnd_api.g_exc_unexpected_error;
2037: END IF;
2038:

Line 2072: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

2068: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2069: IF g_debug = 1 THEN
2070: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2071: END IF;
2072: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2074: FND_MSG_PUB.ADD;
2075: RAISE fnd_api.g_exc_unexpected_error;
2076: END IF;

Line 2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');

2069: IF g_debug = 1 THEN
2070: print_debug('Program INV_LOT_ATTR_PUB.validate_hold_date has failed with a Unexpected exception', 9);
2071: END IF;
2072: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2073: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_ATTR_PUB. ');
2074: FND_MSG_PUB.ADD;
2075: RAISE fnd_api.g_exc_unexpected_error;
2076: END IF;
2077:

Line 2171: fnd_message.set_name('INV', 'INV_NULL_ORG_EXP') ;

2167: IF p_organization_id IS NULL THEN
2168: IF g_debug = 1 THEN
2169: print_debug('Value for mandatory field organization id cannot be null.', 9);
2170: END IF;
2171: fnd_message.set_name('INV', 'INV_NULL_ORG_EXP') ;
2172: fnd_msg_pub.ADD;
2173: RAISE fnd_api.g_exc_error;
2174: END IF ;
2175:

Line 2180: fnd_message.set_name('INV', 'INV_INVALID_ITEM') ;

2176: IF p_inventory_item_id IS NULL THEN
2177: IF g_debug = 1 THEN
2178: print_debug('Value for mandatory field inventory item id cannot be null.', 9);
2179: END IF;
2180: fnd_message.set_name('INV', 'INV_INVALID_ITEM') ;
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: END IF ;
2184:

Line 2189: fnd_message.set_name('INV', 'INV_NULL_CLOT_EXP');

2185: IF p_lot_number IS NULL THEN
2186: IF g_debug = 1 THEN
2187: print_debug('Value for mandatory field Lot Number cannot be null', 9);
2188: END IF;
2189: fnd_message.set_name('INV', 'INV_NULL_CLOT_EXP');
2190: fnd_msg_pub.ADD;
2191: RAISE fnd_api.g_exc_error;
2192: END IF;
2193: /*Basic Validations - End*/

Line 2219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

2215: IF l_return_status = fnd_api.g_ret_sts_error THEN
2216: IF g_debug = 1 THEN
2217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
2218: END IF;
2219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2221: FND_MSG_PUB.ADD;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;

Line 2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

2216: IF g_debug = 1 THEN
2217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
2218: END IF;
2219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2221: FND_MSG_PUB.ADD;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:

Line 2229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

2225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2226: IF g_debug = 1 THEN
2227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
2228: END IF;
2229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2231: fnd_msg_pub.ADD;
2232: RAISE fnd_api.g_exc_unexpected_error;
2233: END IF;

Line 2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

2226: IF g_debug = 1 THEN
2227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
2228: END IF;
2229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2231: fnd_msg_pub.ADD;
2232: RAISE fnd_api.g_exc_unexpected_error;
2233: END IF;
2234:

Line 2239: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');

2235: IF (l_lot_cont = FALSE) THEN
2236: IF g_debug = 1 THEN
2237: print_debug(' Item is not lot controlled ', 9);
2238: END IF;
2239: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
2240: fnd_msg_pub.ADD;
2241: x_return_status := fnd_api.g_ret_sts_error;
2242: RAISE g_exc_error;
2243: END IF ;