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 755: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);

751: /* Expiration Date */
752: IF p_lot_rec.expiration_date IS NULL AND l_get_dft_attr_rec.shelf_life_code = 2 THEN -- Item shelf life days
753: -- nsinghi bug 5209065 START. This API defaults the expiration date. If MMTT or MTI table has data
754: -- and header id is set, we call the custom lot expiration API to get expiration date.
755: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
756: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
757:
758: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
759: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);

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

752: IF p_lot_rec.expiration_date IS NULL AND l_get_dft_attr_rec.shelf_life_code = 2 THEN -- Item shelf life days
753: -- nsinghi bug 5209065 START. This API defaults the expiration date. If MMTT or MTI table has data
754: -- and header id is set, we call the custom lot expiration API to get expiration date.
755: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
756: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
757:
758: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
759: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
760:

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

754: -- and header id is set, we call the custom lot expiration API to get expiration date.
755: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
756: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
757:
758: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
759: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
760:
761: IF l_mti_txn_id <> -1 AND l_mtli_txn_id <> '-1' THEN
762:

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

755: l_mti_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 1);
756: l_mtli_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 1);
757:
758: l_mmtt_txn_id := inv_calculate_exp_date.get_txn_id (p_table => 2);
759: l_mtlt_txn_id := inv_calculate_exp_date.get_lot_txn_id (p_table => 2);
760:
761: IF l_mti_txn_id <> -1 AND l_mtli_txn_id <> '-1' THEN
762:
763: OPEN cur_get_mti_rec (l_mti_txn_id);

Line 771: inv_calculate_exp_date.reset_header_id;

767: OPEN cur_get_mtli_rec (l_mtli_txn_id);
768: FETCH cur_get_mtli_rec INTO l_mtli_txn_rec;
769: CLOSE cur_get_mtli_rec;
770:
771: inv_calculate_exp_date.reset_header_id;
772:
773: inv_calculate_exp_date.get_lot_expiration_date(
774: p_mtli_lot_rec => l_mtli_txn_rec
775: ,p_mti_trx_rec => l_mti_txn_rec

Line 773: inv_calculate_exp_date.get_lot_expiration_date(

769: CLOSE cur_get_mtli_rec;
770:
771: inv_calculate_exp_date.reset_header_id;
772:
773: inv_calculate_exp_date.get_lot_expiration_date(
774: p_mtli_lot_rec => l_mtli_txn_rec
775: ,p_mti_trx_rec => l_mti_txn_rec
776: ,p_mtlt_lot_rec => l_mtlt_txn_rec
777: ,p_mmtt_trx_rec => l_mmtt_txn_rec

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

780: ,x_return_status => l_return_status);
781:
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;

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 806: inv_calculate_exp_date.get_lot_expiration_date(

802: OPEN cur_get_mtlt_rec (l_mtlt_txn_id);
803: FETCH cur_get_mtlt_rec INTO l_mtlt_txn_rec;
804: CLOSE cur_get_mtlt_rec;
805:
806: inv_calculate_exp_date.get_lot_expiration_date(
807: p_mtli_lot_rec => l_mtli_txn_rec
808: ,p_mti_trx_rec => l_mti_txn_rec
809: ,p_mtlt_lot_rec => l_mtlt_txn_rec
810: ,p_mmtt_trx_rec => l_mmtt_txn_rec

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

813: ,x_return_status => l_return_status);
814:
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;

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