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 INV_CALCULATE_EXP_DATE

Line 798: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);

794: /* Expiration Date */
795: IF p_lot_rec.expiration_date IS NULL AND l_get_dft_attr_rec.shelf_life_code = 2 THEN -- Item shelf life days
796: -- nsinghi bug 5209065 START. This API defaults the expiration date. If MMTT or MTI table has data
797: -- and header id is set, we call the custom lot expiration API to get expiration date.
798: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
799: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
800:
801: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
802: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);

Line 799: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);

795: IF p_lot_rec.expiration_date IS NULL AND l_get_dft_attr_rec.shelf_life_code = 2 THEN -- Item shelf life days
796: -- nsinghi bug 5209065 START. This API defaults the expiration date. If MMTT or MTI table has data
797: -- and header id is set, we call the custom lot expiration API to get expiration date.
798: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
799: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
800:
801: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
802: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
803:

Line 801: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);

797: -- and header id is set, we call the custom lot expiration API to get expiration date.
798: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
799: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
800:
801: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
802: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
803:
804: IF l_mti_txn_id <> -1 AND l_mtli_txn_id <> '-1' THEN
805:

Line 802: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);

798: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
799: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
800:
801: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
802: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
803:
804: IF l_mti_txn_id <> -1 AND l_mtli_txn_id <> '-1' THEN
805:
806: OPEN cur_get_mti_rec (l_mti_txn_id);

Line 814: inv_calculate_exp_date.reset_header_id;

810: OPEN cur_get_mtli_rec (l_mtli_txn_id);
811: FETCH cur_get_mtli_rec INTO l_mtli_txn_rec;
812: CLOSE cur_get_mtli_rec;
813:
814: inv_calculate_exp_date.reset_header_id;
815:
816: inv_calculate_exp_date.get_lot_expiration_date(
817: p_mtli_lot_rec => l_mtli_txn_rec
818: ,p_mti_trx_rec => l_mti_txn_rec

Line 816: inv_calculate_exp_date.get_lot_expiration_date(

812: CLOSE cur_get_mtli_rec;
813:
814: inv_calculate_exp_date.reset_header_id;
815:
816: inv_calculate_exp_date.get_lot_expiration_date(
817: p_mtli_lot_rec => l_mtli_txn_rec
818: ,p_mti_trx_rec => l_mti_txn_rec
819: ,p_mtlt_lot_rec => l_mtlt_txn_rec
820: ,p_mmtt_trx_rec => l_mmtt_txn_rec

Line 827: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);

823: ,x_return_status => l_return_status);
824:
825: IF l_return_status <> fnd_api.g_ret_sts_success THEN
826: IF g_debug = 1 THEN
827: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
828: END IF;
829: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
831: fnd_msg_pub.ADD;

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

826: IF g_debug = 1 THEN
827: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
828: END IF;
829: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
831: fnd_msg_pub.ADD;
832: RAISE fnd_api.g_exc_unexpected_error;
833: END IF;
834: IF g_debug = 1 THEN

Line 849: inv_calculate_exp_date.get_lot_expiration_date(

845: OPEN cur_get_mtlt_rec (l_mtlt_txn_id);
846: FETCH cur_get_mtlt_rec INTO l_mtlt_txn_rec;
847: CLOSE cur_get_mtlt_rec;
848:
849: inv_calculate_exp_date.get_lot_expiration_date(
850: p_mtli_lot_rec => l_mtli_txn_rec
851: ,p_mti_trx_rec => l_mti_txn_rec
852: ,p_mtlt_lot_rec => l_mtlt_txn_rec
853: ,p_mmtt_trx_rec => l_mmtt_txn_rec

Line 860: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);

856: ,x_return_status => l_return_status);
857:
858: IF l_return_status <> fnd_api.g_ret_sts_success THEN
859: IF g_debug = 1 THEN
860: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
861: END IF;
862: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
863: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
864: fnd_msg_pub.ADD;

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

859: IF g_debug = 1 THEN
860: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
861: END IF;
862: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
863: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
864: fnd_msg_pub.ADD;
865: RAISE fnd_api.g_exc_unexpected_error;
866: END IF;
867: IF g_debug = 1 THEN