APPS.INV_LOT_APIS dependencies on INV_CALCULATE_EXP_DATE

Line 504: l_mmtt_txn_tbl INV_CALCULATE_EXP_DATE.MMTT_TAB;

500: l_new_lot BOOLEAN;
501: -- nsinghi bug#5209065 rework END.
502:
503: -- nsinghi bug 5209065 START
504: l_mmtt_txn_tbl INV_CALCULATE_EXP_DATE.MMTT_TAB;
505: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
506: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
507: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
508: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

Line 552: l_mmtt_txn_tbl := inv_calculate_exp_date.get_mmtt_tbl;

548: MTLI/MTLT record. This is because, when tabbing out of Lot LOV, there is no data related
549: to lot transaction. This data only gets built after user navigates through all lot fields.
550: Hence only passing the MMTT record to custom lot API. */
551:
552: l_mmtt_txn_tbl := inv_calculate_exp_date.get_mmtt_tbl;
553: IF l_mmtt_txn_tbl.COUNT > 0 THEN
554: l_mmtt_txn_rec := l_mmtt_txn_tbl(0);
555: inv_calculate_exp_date.get_lot_expiration_date(
556: p_mtli_lot_rec => l_mtli_txn_rec

Line 555: inv_calculate_exp_date.get_lot_expiration_date(

551:
552: l_mmtt_txn_tbl := inv_calculate_exp_date.get_mmtt_tbl;
553: IF l_mmtt_txn_tbl.COUNT > 0 THEN
554: l_mmtt_txn_rec := l_mmtt_txn_tbl(0);
555: inv_calculate_exp_date.get_lot_expiration_date(
556: p_mtli_lot_rec => l_mtli_txn_rec
557: ,p_mti_trx_rec => l_mti_txn_rec
558: ,p_mtlt_lot_rec => l_mtlt_txn_rec
559: ,p_mmtt_trx_rec => l_mmtt_txn_rec

Line 564: inv_calculate_exp_date.purge_mmtt_tab;

560: ,p_table => 2
561: ,x_lot_expiration_date => l_lot_expiration_date
562: ,x_return_status => l_return_status);
563:
564: inv_calculate_exp_date.purge_mmtt_tab;
565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
566: IF g_debug = 1 THEN
567: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
568: END IF;

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

563:
564: inv_calculate_exp_date.purge_mmtt_tab;
565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
566: IF g_debug = 1 THEN
567: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
568: END IF;
569: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
571: fnd_msg_pub.ADD;

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

566: IF g_debug = 1 THEN
567: print_debug('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception', 9);
568: END IF;
569: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
571: fnd_msg_pub.ADD;
572: RAISE fnd_api.g_exc_unexpected_error;
573: END IF;
574: IF g_debug = 1 THEN