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.7.12010000.5 2009/01/23 19:43:11 fli 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 90: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => lower(p_transaction_type),

86: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
87: l_trx_error_rec.source_type := p_transaction_type;
88:
89: IF (l_debug > 0) THEN
90: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => lower(p_transaction_type),
91: p_file_segment2 => p_transaction_id);
92: END IF;
93:
94: -- Added for Cursor Optimization on CSI_INSTALL_PARAMETERS

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

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

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

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

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

119: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_soful_exist_txns.transaction_id);
120: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
121: RAISE csi_txn_exists;
122: ELSE
123: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
124: END IF;
125: CLOSE c_csi_soful_exist_txns;
126:
127: ELSE

Line 136: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id);

132: OPEN c_csi_inv_exist_txns_and_items (p_transaction_id);
133: FETCH c_csi_inv_exist_txns_and_items into r_csi_inv_exist_txns_and_items;
134:
135: IF c_csi_inv_exist_txns_and_items%FOUND THEN
136: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id);
137: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
138: RAISE csi_txn_exists;
139: ELSE
140: csi_t_gen_utility_pvt.add('No CSI Transaction for the same Inventory Item Exists so Continue Processing');

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

133: FETCH c_csi_inv_exist_txns_and_items into r_csi_inv_exist_txns_and_items;
134:
135: IF c_csi_inv_exist_txns_and_items%FOUND THEN
136: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id);
137: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
138: RAISE csi_txn_exists;
139: ELSE
140: csi_t_gen_utility_pvt.add('No CSI Transaction for the same Inventory Item Exists so Continue Processing');
141: END IF;

Line 140: csi_t_gen_utility_pvt.add('No CSI Transaction for the same Inventory Item Exists so Continue Processing');

136: csi_t_gen_utility_pvt.add('CSI Transaction Exists: '||r_csi_inv_exist_txns.transaction_id);
137: csi_t_gen_utility_pvt.add('Call exception to exit execute_trx_dpl');
138: RAISE csi_txn_exists;
139: ELSE
140: csi_t_gen_utility_pvt.add('No CSI Transaction for the same Inventory Item Exists so Continue Processing');
141: END IF;
142: CLOSE c_csi_inv_exist_txns_and_items;
143: ELSE
144: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');

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

140: csi_t_gen_utility_pvt.add('No CSI Transaction for the same Inventory Item Exists so Continue Processing');
141: END IF;
142: CLOSE c_csi_inv_exist_txns_and_items;
143: ELSE
144: csi_t_gen_utility_pvt.add('No CSI Transaction Exists so Continue Processing');
145: END IF;
146: CLOSE c_csi_inv_exist_txns;
147:
148: END IF;

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

770:
771: EXCEPTION
772: WHEN csi_txn_exists THEN
773: IF (l_debug > 0) THEN
774: csi_t_gen_utility_pvt.add('In CSI_TXN_EXISTS in CSIINVHB - CSI Transaction Exists so Just
775: exit doing nothing');
776: END IF;
777: x_trx_return_status := l_fnd_success;
778: x_trx_error_rec.error_text := NULL;