DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on INV_CALCULATE_EXP_DATE

Line 4340: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;

4336: x_expiration_date OUT NOCOPY DATE
4337: , x_return_status OUT NOCOPY VARCHAR2
4338: ) IS
4339:
4340: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4341: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4342: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4343: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4344: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

Line 4353: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;

4349: IF (g_debug IS NOT NULL) THEN
4350: gme_debug.log_initialize ('MobileGetExpDate');
4351: END IF;
4352:
4353: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4354: IF l_mti_txn_tbl.COUNT > 0 THEN
4355: l_mti_txn_rec := l_mti_txn_tbl(0);
4356: inv_calculate_exp_date.get_lot_expiration_date(
4357: p_mtli_lot_rec => l_mtli_txn_rec

Line 4356: inv_calculate_exp_date.get_lot_expiration_date(

4352:
4353: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4354: IF l_mti_txn_tbl.COUNT > 0 THEN
4355: l_mti_txn_rec := l_mti_txn_tbl(0);
4356: inv_calculate_exp_date.get_lot_expiration_date(
4357: p_mtli_lot_rec => l_mtli_txn_rec
4358: ,p_mti_trx_rec => l_mti_txn_rec
4359: ,p_mtlt_lot_rec => l_mtlt_txn_rec
4360: ,p_mmtt_trx_rec => l_mmtt_txn_rec

Line 4365: inv_calculate_exp_date.purge_mti_tab;

4361: ,p_table => 1
4362: ,x_lot_expiration_date => l_lot_expiration_date
4363: ,x_return_status => x_return_status);
4364:
4365: inv_calculate_exp_date.purge_mti_tab;
4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;

Line 4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');

4364:
4365: inv_calculate_exp_date.purge_mti_tab;
4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;

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

4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;
4375: IF g_debug = 1 THEN