DBA Data[Home] [Help]

APPS.XNP_CSIPHYIN_U dependencies on CSI_INV_TRXS_PKG

Line 248: l_mtl_trx_rec CSI_INV_TRXS_PKG.MTL_TRX_TYPE;

244: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
245: l_trx_error_message VARCHAR2(2000);
246: l_trx_return_status VARCHAR2(1);
247: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
248: l_mtl_trx_rec CSI_INV_TRXS_PKG.MTL_TRX_TYPE;
249: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
250: l_msg_count NUMBER;
251: l_msg_data VARCHAR2(2000);
252: l_txn_error_id NUMBER;

Line 296: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

292: WHEN e_dpl_error THEN
293: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
294: l_trx_error_rec.message_id := p_msg_header.message_id;
295: l_trx_error_rec.message_string := p_msg_text;
296: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
297: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
298: rollback to one;
299: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
300: WHEN others THEN

Line 297: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

293: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
294: l_trx_error_rec.message_id := p_msg_header.message_id;
295: l_trx_error_rec.message_string := p_msg_text;
296: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
297: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
298: rollback to one;
299: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
300: WHEN others THEN
301: IF l_mtl_trx_rec.mtl_transaction_id IS NOT NULL THEN

Line 299: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);

295: l_trx_error_rec.message_string := p_msg_text;
296: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
297: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
298: rollback to one;
299: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
300: WHEN others THEN
301: IF l_mtl_trx_rec.mtl_transaction_id IS NOT NULL THEN
302: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
303: l_trx_error_rec.message_id := p_msg_header.message_id;

Line 311: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);

307: l_trx_error_rec.source_type := 'CSIPHYIN';
308: l_trx_error_rec.source_id := l_mtl_trx_rec.mtl_transaction_id;
309: l_trx_error_rec.inv_material_transaction_id := l_trx_error_rec.source_id;
310: rollback to one;
311: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
312: ELSE
313: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error - passing out to calling XNP Program'||l_trx_error_rec.error_text);
314: raise;
315: END IF;