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_MSG_PUB

Line 64: fnd_msg_pub.ADD;

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

Line 102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

98: /******************* End Item validation ********************/
99: EXCEPTION
100: WHEN NO_DATA_FOUND THEN
101: x_return_status := fnd_api.g_ret_sts_error;
102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
103: if( x_msg_count > 1 ) then
104: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
105: end if;
106: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);

Line 104: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

100: WHEN NO_DATA_FOUND THEN
101: x_return_status := fnd_api.g_ret_sts_error;
102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
103: if( x_msg_count > 1 ) then
104: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
105: end if;
106: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
107: WHEN fnd_api.g_exc_error THEN
108: x_return_status := fnd_api.g_ret_sts_error;

Line 109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

105: end if;
106: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
107: WHEN fnd_api.g_exc_error THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
110: if( x_msg_count > 1 ) then
111: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
112: end if;
113: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);

Line 111: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

107: WHEN fnd_api.g_exc_error THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
110: if( x_msg_count > 1 ) then
111: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
112: end if;
113: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

112: end if;
113: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
117: if( x_msg_count > 1 ) then
118: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
119: end if;
120: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);

Line 118: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
117: if( x_msg_count > 1 ) then
118: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
119: end if;
120: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
121: WHEN OTHERS THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

119: end if;
120: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
121: WHEN OTHERS THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
124: if( x_msg_count > 1 ) then
125: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
126: end if;
127: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);

Line 125: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

121: WHEN OTHERS THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
124: if( x_msg_count > 1 ) then
125: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
126: end if;
127: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);
128:
129: END Check_Item_Attributes;

Line 221: FND_MSG_PUB.ADD;

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:
225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 231: fnd_msg_pub.ADD;

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:
235: IF (l_lot_cont = FALSE) THEN

Line 240: fnd_msg_pub.ADD;

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

Line 251: fnd_msg_pub.ADD;

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 ;
255: /******************* End Item validation ********************/

Line 439: FND_MSG_PUB.ADD;

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

Line 479: FND_MSG_PUB.ADD;

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
483: /* Validate parent lot record x_parent_lot_rec by calling VALIDATE_LOT_ATTRIBUTES API */

Line 505: FND_MSG_PUB.ADD;

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

Line 516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: x_return_status := fnd_api.g_ret_sts_error;
515: ROLLBACK TO inv_pop_lot ;
516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
517: if( x_msg_count > 1 ) then
518: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
519: end if;
520: print_debug('In No data found Populate_Lot_Records ' || SQLERRM, 9);

Line 518: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

514: x_return_status := fnd_api.g_ret_sts_error;
515: ROLLBACK TO inv_pop_lot ;
516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
517: if( x_msg_count > 1 ) then
518: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
519: end if;
520: print_debug('In No data found Populate_Lot_Records ' || SQLERRM, 9);
521: WHEN fnd_api.g_exc_error THEN
522: x_return_status := fnd_api.g_ret_sts_error;

Line 524: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

520: print_debug('In No data found Populate_Lot_Records ' || SQLERRM, 9);
521: WHEN fnd_api.g_exc_error THEN
522: x_return_status := fnd_api.g_ret_sts_error;
523: ROLLBACK TO inv_pop_lot ;
524: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
525: if( x_msg_count > 1 ) then
526: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
527: end if;
528: print_debug('In g_exc_error Populate_Lot_Records ' || SQLERRM, 9);

Line 526: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

522: x_return_status := fnd_api.g_ret_sts_error;
523: ROLLBACK TO inv_pop_lot ;
524: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
525: if( x_msg_count > 1 ) then
526: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
527: end if;
528: print_debug('In g_exc_error Populate_Lot_Records ' || SQLERRM, 9);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

528: print_debug('In g_exc_error Populate_Lot_Records ' || SQLERRM, 9);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: x_return_status := fnd_api.g_ret_sts_unexp_error;
531: ROLLBACK TO inv_pop_lot ;
532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
533: if( x_msg_count > 1 ) then
534: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
535: end if;
536: print_debug('In g_exc_unexpected_error Populate_Lot_Records ' || SQLERRM, 9);

Line 534: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

530: x_return_status := fnd_api.g_ret_sts_unexp_error;
531: ROLLBACK TO inv_pop_lot ;
532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
533: if( x_msg_count > 1 ) then
534: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
535: end if;
536: print_debug('In g_exc_unexpected_error Populate_Lot_Records ' || SQLERRM, 9);
537: WHEN OTHERS THEN
538: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 540: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

536: print_debug('In g_exc_unexpected_error Populate_Lot_Records ' || SQLERRM, 9);
537: WHEN OTHERS THEN
538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: ROLLBACK TO inv_pop_lot ;
540: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
541: if( x_msg_count > 1 ) then
542: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
543: end if;
544: print_debug('In others Populate_Lot_Records ' || SQLERRM, 9);

Line 542: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: ROLLBACK TO inv_pop_lot ;
540: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
541: if( x_msg_count > 1 ) then
542: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
543: end if;
544: print_debug('In others Populate_Lot_Records ' || SQLERRM, 9);
545:
546: END Populate_Lot_Records;

Line 658: FND_MSG_PUB.ADD;

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:
662: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 668: fnd_msg_pub.ADD;

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:
672: IF (l_lot_cont = FALSE) THEN

Line 677: fnd_msg_pub.ADD;

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

Line 688: fnd_msg_pub.ADD;

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

Line 788: fnd_msg_pub.ADD;

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
792: print_debug('l_lot_expiration_date (1) '||l_lot_expiration_date, 9);

Line 821: fnd_msg_pub.ADD;

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
825: print_debug('l_lot_expiration_date (2) '||l_lot_expiration_date, 9);

Line 870: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

866:
867: EXCEPTION
868: WHEN NO_DATA_FOUND THEN
869: x_return_status := fnd_api.g_ret_sts_error;
870: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
871: if( x_msg_count > 1 ) then
872: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
873: end if;
874: print_debug('In Set_Msi_Default_Attr, No data found ' || SQLERRM, 9);

Line 872: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

868: WHEN NO_DATA_FOUND THEN
869: x_return_status := fnd_api.g_ret_sts_error;
870: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
871: if( x_msg_count > 1 ) then
872: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
873: end if;
874: print_debug('In Set_Msi_Default_Attr, No data found ' || SQLERRM, 9);
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;

Line 877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

873: end if;
874: print_debug('In Set_Msi_Default_Attr, No data found ' || SQLERRM, 9);
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
878: if( x_msg_count > 1 ) then
879: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
880: end if;
881: print_debug('In Set_Msi_Default_Attr, g_exc_error ' || SQLERRM, 9);

Line 879: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
878: if( x_msg_count > 1 ) then
879: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
880: end if;
881: print_debug('In Set_Msi_Default_Attr, g_exc_error ' || SQLERRM, 9);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

880: end if;
881: print_debug('In Set_Msi_Default_Attr, g_exc_error ' || SQLERRM, 9);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: x_return_status := fnd_api.g_ret_sts_unexp_error;
884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
885: if( x_msg_count > 1 ) then
886: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
887: end if;
888: print_debug('In Set_Msi_Default_Attr, g_exc_unexpected_error ' || SQLERRM, 9);

Line 886: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

882: WHEN fnd_api.g_exc_unexpected_error THEN
883: x_return_status := fnd_api.g_ret_sts_unexp_error;
884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
885: if( x_msg_count > 1 ) then
886: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
887: end if;
888: print_debug('In Set_Msi_Default_Attr, g_exc_unexpected_error ' || SQLERRM, 9);
889: WHEN OTHERS THEN
890: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 891: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

887: end if;
888: print_debug('In Set_Msi_Default_Attr, g_exc_unexpected_error ' || SQLERRM, 9);
889: WHEN OTHERS THEN
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
892: if( x_msg_count > 1 ) then
893: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
894: end if;
895: print_debug('In Set_Msi_Default_Attr, Others ' || SQLERRM, 9);

Line 893: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

889: WHEN OTHERS THEN
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
892: if( x_msg_count > 1 ) then
893: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
894: end if;
895: print_debug('In Set_Msi_Default_Attr, Others ' || SQLERRM, 9);
896:
897: END Set_Msi_Default_Attr ;

Line 1148: FND_MSG_PUB.ADD;

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:
1152: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1158: fnd_msg_pub.ADD;

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:
1162: IF (l_lot_cont = FALSE) THEN

Line 1167: fnd_msg_pub.ADD;

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

Line 1178: fnd_msg_pub.ADD;

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 ;
1182: /******************* End Item validation ********************/

Line 1202: fnd_msg_pub.ADD;

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

Line 1234: fnd_msg_pub.ADD;

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;
1238: RAISE fnd_api.g_exc_error;

Line 1249: fnd_msg_pub.ADD;

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

Line 1267: fnd_msg_pub.ADD;

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

Line 1289: FND_MSG_PUB.ADD;

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

Line 1380: fnd_msg_pub.ADD;

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

Line 1419: fnd_msg_pub.ADD;

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

Line 1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1572: EXCEPTION
1573: WHEN NO_DATA_FOUND THEN
1574: x_return_status := fnd_api.g_ret_sts_error;
1575: ROLLBACK TO inv_val_lot ;
1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1577: if( x_msg_count > 1 ) then
1578: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1579: end if;
1580: print_debug('In No data found Validate_Lot_Attributes ' || SQLERRM, 9);

Line 1578: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

1574: x_return_status := fnd_api.g_ret_sts_error;
1575: ROLLBACK TO inv_val_lot ;
1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1577: if( x_msg_count > 1 ) then
1578: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1579: end if;
1580: print_debug('In No data found Validate_Lot_Attributes ' || SQLERRM, 9);
1581: WHEN fnd_api.g_exc_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;

Line 1584: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1580: print_debug('In No data found Validate_Lot_Attributes ' || SQLERRM, 9);
1581: WHEN fnd_api.g_exc_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;
1583: ROLLBACK TO inv_val_lot ;
1584: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1585: if( x_msg_count > 1 ) then
1586: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1587: end if;
1588: print_debug('In g_exc_error Validate_Lot_Attributes ' || SQLERRM, 9);

Line 1586: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

1582: x_return_status := fnd_api.g_ret_sts_error;
1583: ROLLBACK TO inv_val_lot ;
1584: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1585: if( x_msg_count > 1 ) then
1586: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1587: end if;
1588: print_debug('In g_exc_error Validate_Lot_Attributes ' || SQLERRM, 9);
1589: WHEN fnd_api.g_exc_unexpected_error THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1592: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1588: print_debug('In g_exc_error Validate_Lot_Attributes ' || SQLERRM, 9);
1589: WHEN fnd_api.g_exc_unexpected_error THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: ROLLBACK TO inv_val_lot ;
1592: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1593: if( x_msg_count > 1 ) then
1594: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1595: end if;
1596: print_debug('In g_exc_unexpected_error Validate_Lot_Attributes ' || SQLERRM, 9);

Line 1594: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: ROLLBACK TO inv_val_lot ;
1592: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1593: if( x_msg_count > 1 ) then
1594: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1595: end if;
1596: print_debug('In g_exc_unexpected_error Validate_Lot_Attributes ' || SQLERRM, 9);
1597: WHEN OTHERS THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1596: print_debug('In g_exc_unexpected_error Validate_Lot_Attributes ' || SQLERRM, 9);
1597: WHEN OTHERS THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: ROLLBACK TO inv_val_lot ;
1600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1601: if( x_msg_count > 1 ) then
1602: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1603: end if;
1604: print_debug('In others Validate_Lot_Attributes ' || SQLERRM, 9);

Line 1602: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: ROLLBACK TO inv_val_lot ;
1600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1601: if( x_msg_count > 1 ) then
1602: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
1603: end if;
1604: print_debug('In others Validate_Lot_Attributes ' || SQLERRM, 9);
1605:
1606: END Validate_Lot_Attributes ;

Line 1693: FND_MSG_PUB.ADD;

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:
1697: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1703: fnd_msg_pub.ADD;

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:
1707: IF (l_lot_cont = FALSE) THEN

Line 1712: fnd_msg_pub.ADD;

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

Line 1723: fnd_msg_pub.ADD;

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 ;
1727: /******************* End Item validation ********************/

Line 1763: fnd_msg_pub.ADD;

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:
1767: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1773: fnd_msg_pub.ADD;

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
1777: ELSE

Line 1787: fnd_msg_pub.ADD;

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;
1791: END IF; /* Check Lot */

Line 1825: FND_MSG_PUB.ADD;

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

Line 1866: FND_MSG_PUB.ADD;

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

Line 1906: FND_MSG_PUB.ADD;

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

Line 1953: FND_MSG_PUB.ADD;

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
1957: END IF ; -- Cursor If

Line 1996: FND_MSG_PUB.ADD;

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

Line 2035: FND_MSG_PUB.ADD;

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

Line 2074: FND_MSG_PUB.ADD;

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

Line 2087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2083: EXCEPTION
2084: WHEN NO_DATA_FOUND THEN
2085: x_return_status := fnd_api.g_ret_sts_error;
2086: ROLLBACK TO val_lot_attr_information;
2087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2088: if( x_msg_count > 1 ) then
2089: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2090: end if;
2091: print_debug('In No data found Validate_Additional_Attr ' || SQLERRM, 9);

Line 2089: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2085: x_return_status := fnd_api.g_ret_sts_error;
2086: ROLLBACK TO val_lot_attr_information;
2087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2088: if( x_msg_count > 1 ) then
2089: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2090: end if;
2091: print_debug('In No data found Validate_Additional_Attr ' || SQLERRM, 9);
2092: WHEN fnd_api.g_exc_error THEN
2093: x_return_status := fnd_api.g_ret_sts_error;

Line 2095: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2091: print_debug('In No data found Validate_Additional_Attr ' || SQLERRM, 9);
2092: WHEN fnd_api.g_exc_error THEN
2093: x_return_status := fnd_api.g_ret_sts_error;
2094: ROLLBACK TO val_lot_attr_information;
2095: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2096: if( x_msg_count > 1 ) then
2097: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2098: end if;
2099: print_debug('In g_exc_error Validate_Additional_Attr ' || SQLERRM, 9);

Line 2097: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2093: x_return_status := fnd_api.g_ret_sts_error;
2094: ROLLBACK TO val_lot_attr_information;
2095: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2096: if( x_msg_count > 1 ) then
2097: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2098: end if;
2099: print_debug('In g_exc_error Validate_Additional_Attr ' || SQLERRM, 9);
2100: WHEN fnd_api.g_exc_unexpected_error THEN
2101: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2099: print_debug('In g_exc_error Validate_Additional_Attr ' || SQLERRM, 9);
2100: WHEN fnd_api.g_exc_unexpected_error THEN
2101: x_return_status := fnd_api.g_ret_sts_unexp_error;
2102: ROLLBACK TO val_lot_attr_information;
2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2104: if( x_msg_count > 1 ) then
2105: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2106: end if;
2107: print_debug('In g_exc_unexpected_error Validate_Additional_Attr ' || SQLERRM, 9);

Line 2105: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2101: x_return_status := fnd_api.g_ret_sts_unexp_error;
2102: ROLLBACK TO val_lot_attr_information;
2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2104: if( x_msg_count > 1 ) then
2105: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2106: end if;
2107: print_debug('In g_exc_unexpected_error Validate_Additional_Attr ' || SQLERRM, 9);
2108: WHEN OTHERS THEN
2109: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2107: print_debug('In g_exc_unexpected_error Validate_Additional_Attr ' || SQLERRM, 9);
2108: WHEN OTHERS THEN
2109: x_return_status := fnd_api.g_ret_sts_unexp_error;
2110: ROLLBACK TO val_lot_attr_information;
2111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2112: if( x_msg_count > 1 ) then
2113: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2114: end if;
2115: print_debug('In others Validate_Additional_Attr ' || SQLERRM, 9);

Line 2113: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2109: x_return_status := fnd_api.g_ret_sts_unexp_error;
2110: ROLLBACK TO val_lot_attr_information;
2111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2112: if( x_msg_count > 1 ) then
2113: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2114: end if;
2115: print_debug('In others Validate_Additional_Attr ' || SQLERRM, 9);
2116:
2117: END Validate_Additional_Attr;

Line 2172: fnd_msg_pub.ADD;

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:
2176: IF p_inventory_item_id IS NULL THEN

Line 2181: fnd_msg_pub.ADD;

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:
2185: IF p_lot_number IS NULL THEN

Line 2190: fnd_msg_pub.ADD;

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*/
2194:

Line 2221: FND_MSG_PUB.ADD;

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:
2225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2231: fnd_msg_pub.ADD;

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:
2235: IF (l_lot_cont = FALSE) THEN

Line 2240: fnd_msg_pub.ADD;

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

Line 2305: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2301: EXCEPTION
2302: WHEN NO_DATA_FOUND THEN
2303: x_return_status := fnd_api.g_ret_sts_error;
2304: ROLLBACK TO inv_delete_lot;
2305: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2306: if( x_msg_count > 1 ) then
2307: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2308: end if;
2309: print_debug('In Delete_Lot, No data found ' || SQLERRM, 9);

Line 2307: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2303: x_return_status := fnd_api.g_ret_sts_error;
2304: ROLLBACK TO inv_delete_lot;
2305: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2306: if( x_msg_count > 1 ) then
2307: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2308: end if;
2309: print_debug('In Delete_Lot, No data found ' || SQLERRM, 9);
2310: WHEN fnd_api.g_exc_error THEN
2311: x_return_status := fnd_api.g_ret_sts_error;

Line 2313: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2309: print_debug('In Delete_Lot, No data found ' || SQLERRM, 9);
2310: WHEN fnd_api.g_exc_error THEN
2311: x_return_status := fnd_api.g_ret_sts_error;
2312: ROLLBACK TO inv_delete_lot;
2313: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2314: if( x_msg_count > 1 ) then
2315: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2316: end if;
2317: print_debug('In Delete_Lot, g_exc_error ' || SQLERRM, 9);

Line 2315: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2311: x_return_status := fnd_api.g_ret_sts_error;
2312: ROLLBACK TO inv_delete_lot;
2313: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2314: if( x_msg_count > 1 ) then
2315: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2316: end if;
2317: print_debug('In Delete_Lot, g_exc_error ' || SQLERRM, 9);
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2317: print_debug('In Delete_Lot, g_exc_error ' || SQLERRM, 9);
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320: ROLLBACK TO inv_delete_lot;
2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2322: if( x_msg_count > 1 ) then
2323: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2324: end if;
2325: print_debug('In Delete_Lot, g_exc_unexpected_error ' || SQLERRM, 9);

Line 2323: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320: ROLLBACK TO inv_delete_lot;
2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2322: if( x_msg_count > 1 ) then
2323: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2324: end if;
2325: print_debug('In Delete_Lot, g_exc_unexpected_error ' || SQLERRM, 9);
2326: WHEN OTHERS THEN
2327: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2325: print_debug('In Delete_Lot, g_exc_unexpected_error ' || SQLERRM, 9);
2326: WHEN OTHERS THEN
2327: x_return_status := fnd_api.g_ret_sts_unexp_error;
2328: ROLLBACK TO inv_delete_lot;
2329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2330: if( x_msg_count > 1 ) then
2331: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2332: end if;
2333: print_debug('In Delete_Lot, Others ' || SQLERRM, 9);

Line 2331: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2327: x_return_status := fnd_api.g_ret_sts_unexp_error;
2328: ROLLBACK TO inv_delete_lot;
2329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2330: if( x_msg_count > 1 ) then
2331: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2332: end if;
2333: print_debug('In Delete_Lot, Others ' || SQLERRM, 9);
2334:
2335: END Delete_Lot;