DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on INV_CALCULATE_EXP_DATE

Line 4470: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;

4466: x_expiration_date OUT NOCOPY DATE
4467: , x_return_status OUT NOCOPY VARCHAR2
4468: ) IS
4469:
4470: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4471: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4472: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4473: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4474: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

Line 4483: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;

4479: IF (g_debug IS NOT NULL) THEN
4480: gme_debug.log_initialize ('MobileGetExpDate');
4481: END IF;
4482:
4483: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4484: IF l_mti_txn_tbl.COUNT > 0 THEN
4485: l_mti_txn_rec := l_mti_txn_tbl(0);
4486: inv_calculate_exp_date.get_lot_expiration_date(
4487: p_mtli_lot_rec => l_mtli_txn_rec

Line 4486: inv_calculate_exp_date.get_lot_expiration_date(

4482:
4483: l_mti_txn_tbl := inv_calculate_exp_date.get_mti_tbl;
4484: IF l_mti_txn_tbl.COUNT > 0 THEN
4485: l_mti_txn_rec := l_mti_txn_tbl(0);
4486: inv_calculate_exp_date.get_lot_expiration_date(
4487: p_mtli_lot_rec => l_mtli_txn_rec
4488: ,p_mti_trx_rec => l_mti_txn_rec
4489: ,p_mtlt_lot_rec => l_mtlt_txn_rec
4490: ,p_mmtt_trx_rec => l_mmtt_txn_rec

Line 4495: inv_calculate_exp_date.purge_mti_tab;

4491: ,p_table => 1
4492: ,x_lot_expiration_date => l_lot_expiration_date
4493: ,x_return_status => x_return_status);
4494:
4495: inv_calculate_exp_date.purge_mti_tab;
4496: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4497: IF g_debug <= gme_debug.g_log_statement THEN
4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;

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

4494:
4495: inv_calculate_exp_date.purge_mti_tab;
4496: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4497: IF g_debug <= gme_debug.g_log_statement THEN
4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;
4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4502: fnd_msg_pub.ADD;

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

4497: IF g_debug <= gme_debug.g_log_statement THEN
4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;
4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4502: fnd_msg_pub.ADD;
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;
4505: IF g_debug = 1 THEN