APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_T_GEN_UTILITY_PVT

Line 4: l_debug NUMBER := csi_t_gen_utility_pvt.g_debug_level;

1: package body CSI_INV_TXNSTUB_PKG AS
2: -- $Header: csiinvhb.pls 120.6.12000000.2 2007/07/12 11:28:47 ngoutam ship $
3:
4: l_debug NUMBER := csi_t_gen_utility_pvt.g_debug_level;
5:
6: PROCEDURE debug(
7: p_message IN varchar2)
8: IS

Line 11: csi_t_gen_utility_pvt.add(p_message);

7: p_message IN varchar2)
8: IS
9: BEGIN
10: IF l_debug > 0 THEN
11: csi_t_gen_utility_pvt.add(p_message);
12: END IF;
13: END debug;
14:
15: PROCEDURE execute_trx_dpl(p_transaction_type IN VARCHAR2,

Line 76: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => lower(p_transaction_type),

72: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
73: l_trx_error_rec.source_type := p_transaction_type;
74:
75: IF (l_debug > 0) THEN
76: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => lower(p_transaction_type),
77: p_file_segment2 => p_transaction_id);
78: END IF;
79:
80: -- Added for Cursor Optimization on CSI_INSTALL_PARAMETERS

Line 105: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_soful_exist_txns.transaction_id);

101: OPEN c_csi_soful_exist_txns (p_transaction_id);
102: FETCH c_csi_soful_exist_txns into r_csi_soful_exist_txns;
103:
104: IF c_csi_soful_exist_txns%FOUND THEN
105: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_soful_exist_txns.transaction_id);
106: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
107: RAISE csi_txn_exists;
108: ELSE
109: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');

Line 106: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');

102: FETCH c_csi_soful_exist_txns into r_csi_soful_exist_txns;
103:
104: IF c_csi_soful_exist_txns%FOUND THEN
105: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_soful_exist_txns.transaction_id);
106: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
107: RAISE csi_txn_exists;
108: ELSE
109: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
110: END IF;

Line 109: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');

105: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_soful_exist_txns.transaction_id);
106: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
107: RAISE csi_txn_exists;
108: ELSE
109: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
110: END IF;
111: CLOSE c_csi_soful_exist_txns;
112:
113: ELSE

Line 118: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id); csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');

114: OPEN c_csi_inv_exist_txns (p_transaction_id);
115: FETCH c_csi_inv_exist_txns into r_csi_inv_exist_txns;
116:
117: IF c_csi_inv_exist_txns%FOUND THEN
118: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id); csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
119: RAISE csi_txn_exists;
120: ELSE
121: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
122: END IF;

Line 121: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');

117: IF c_csi_inv_exist_txns%FOUND THEN
118: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id); csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
119: RAISE csi_txn_exists;
120: ELSE
121: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
122: END IF;
123: CLOSE c_csi_inv_exist_txns;
124:
125: END IF;

Line 751: csi_t_gen_utility_pvt.add('In CSI_TXN_EXISTS in CSIINVHB - CSI Transaction Exists so Just

747:
748: EXCEPTION
749: WHEN csi_txn_exists THEN
750: IF (l_debug > 0) THEN
751: csi_t_gen_utility_pvt.add('In CSI_TXN_EXISTS in CSIINVHB - CSI Transaction Exists so Just
752: exit doing nothing');
753: END IF;
754: x_trx_return_status := l_fnd_success;
755: x_trx_error_rec.error_text := NULL;