APPS.ECECATI dependencies on EC_DEBUG

Line 14: if EC_DEBUG.G_debug_level >= 2 then

10: m_stack_pos number;
11: m_plsql_pos number;
12: m_var_found BOOLEAN := FALSE;
13: BEGIN
14: if EC_DEBUG.G_debug_level >= 2 then
15: ec_debug.push('ECECATI.PROCESS_CATI_DOCS');
16: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
17: ec_debug.pl(3,'i_run_id',i_run_id);
18: END IF;

Line 15: ec_debug.push('ECECATI.PROCESS_CATI_DOCS');

11: m_plsql_pos number;
12: m_var_found BOOLEAN := FALSE;
13: BEGIN
14: if EC_DEBUG.G_debug_level >= 2 then
15: ec_debug.push('ECECATI.PROCESS_CATI_DOCS');
16: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
17: ec_debug.pl(3,'i_run_id',i_run_id);
18: END IF;
19: /**

Line 16: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

12: m_var_found BOOLEAN := FALSE;
13: BEGIN
14: if EC_DEBUG.G_debug_level >= 2 then
15: ec_debug.push('ECECATI.PROCESS_CATI_DOCS');
16: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
17: ec_debug.pl(3,'i_run_id',i_run_id);
18: END IF;
19: /**
20: Initialize the Stack Table

Line 17: ec_debug.pl(3,'i_run_id',i_run_id);

13: BEGIN
14: if EC_DEBUG.G_debug_level >= 2 then
15: ec_debug.push('ECECATI.PROCESS_CATI_DOCS');
16: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
17: ec_debug.pl(3,'i_run_id',i_run_id);
18: END IF;
19: /**
20: Initialize the Stack Table
21: **/

Line 23: if EC_DEBUG.G_debug_level >= 1 then

19: /**
20: Initialize the Stack Table
21: **/
22: ec_utils.g_stack.DELETE;
23: if EC_DEBUG.G_debug_level >= 1 then
24: ec_debug.pl(1,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
25: END IF;
26: ece_inbound.process_run_inbound
27: (

Line 24: ec_debug.pl(1,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

20: Initialize the Stack Table
21: **/
22: ec_utils.g_stack.DELETE;
23: if EC_DEBUG.G_debug_level >= 1 then
24: ec_debug.pl(1,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
25: END IF;
26: ece_inbound.process_run_inbound
27: (
28: i_transaction_type => i_transaction_type,

Line 31: if EC_DEBUG.G_debug_level >= 1 then

27: (
28: i_transaction_type => i_transaction_type,
29: i_run_id => i_run_id
30: );
31: if EC_DEBUG.G_debug_level >= 1 then
32: ec_debug.pl(1,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
33: END IF;
34: ---Get out variables from the Stack .
35: m_var_found := ec_utils.find_variable

Line 32: ec_debug.pl(1,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

28: i_transaction_type => i_transaction_type,
29: i_run_id => i_run_id
30: );
31: if EC_DEBUG.G_debug_level >= 1 then
32: ec_debug.pl(1,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
33: END IF;
34: ---Get out variables from the Stack .
35: m_var_found := ec_utils.find_variable
36: (

Line 46: if EC_DEBUG.G_debug_level >= 3 then

42: if ( m_var_found )
43: then
44: o_po_batch_id := ec_utils.g_stack(m_stack_pos).variable_value;
45: else
46: if EC_DEBUG.G_debug_level >= 3 then
47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');
48: end if;
49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;

Line 47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');

43: then
44: o_po_batch_id := ec_utils.g_stack(m_stack_pos).variable_value;
45: else
46: if EC_DEBUG.G_debug_level >= 3 then
47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');
48: end if;
49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;
51: end if;

Line 52: if EC_DEBUG.G_debug_level >= 2 then

48: end if;
49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;
51: end if;
52: if EC_DEBUG.G_debug_level >= 2 then
53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);
54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');
55: end if;
56: EXCEPTION

Line 53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);

49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;
51: end if;
52: if EC_DEBUG.G_debug_level >= 2 then
53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);
54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');
55: end if;
56: EXCEPTION
57: WHEN EC_UTILS.PROGRAM_EXIT then

Line 54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');

50: raise ec_utils.program_exit;
51: end if;
52: if EC_DEBUG.G_debug_level >= 2 then
53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);
54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');
55: end if;
56: EXCEPTION
57: WHEN EC_UTILS.PROGRAM_EXIT then
58: raise;

Line 60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');

56: EXCEPTION
57: WHEN EC_UTILS.PROGRAM_EXIT then
58: raise;
59: WHEN OTHERS THEN
60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');
61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
62: ec_utils.i_ret_code :=2;
63: raise ec_utils.program_exit;
64: end process_cati_docs;

Line 61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

57: WHEN EC_UTILS.PROGRAM_EXIT then
58: raise;
59: WHEN OTHERS THEN
60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');
61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
62: ec_utils.i_ret_code :=2;
63: raise ec_utils.program_exit;
64: end process_cati_docs;
65:

Line 93: ec_debug.enable_debug(i_debug_mode);

89: i_map_type varchar2(40);
90: cEnabled VARCHAR2(1) := 'Y';
91: ece_transaction_disabled EXCEPTION;
92: begin
93: ec_debug.enable_debug(i_debug_mode);
94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);

Line 94: if EC_DEBUG.G_debug_level >= 1 then

90: cEnabled VARCHAR2(1) := 'Y';
91: ece_transaction_disabled EXCEPTION;
92: begin
93: ec_debug.enable_debug(i_debug_mode);
94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);

Line 95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

91: ece_transaction_disabled EXCEPTION;
92: begin
93: ec_debug.enable_debug(i_debug_mode);
94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);

Line 96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');

92: begin
93: ec_debug.enable_debug(i_debug_mode);
94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);

Line 97: ec_debug.pl(3,'i_file_path',i_file_path);

93: ec_debug.enable_debug(i_debug_mode);
94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);

Line 98: ec_debug.pl(3,'i_file_name',i_file_name);

94: if EC_DEBUG.G_debug_level >= 1 then
95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);

Line 99: ec_debug.pl(3,'i_run_import',i_run_import);

95: ec_debug.pl(1,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);

Line 100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);

96: ec_debug.push('ECECATI.PROCESS_CATI_INBOUND');
97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);

Line 101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);

97: ec_debug.pl(3,'i_file_path',i_file_path);
98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);

Line 102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);

98: ec_debug.pl(3,'i_file_name',i_file_name);
99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);

Line 103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);

99: ec_debug.pl(3,'i_run_import',i_run_import);
100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);

Line 104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);

100: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);

101: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
109: ec_debug.pl(3,'i_source_charset',i_source_charset);

Line 106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);

102: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
109: ec_debug.pl(3,'i_source_charset',i_source_charset);
110: end if;

Line 107: ec_debug.pl(3,'i_map_id',i_map_id);

103: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
109: ec_debug.pl(3,'i_source_charset',i_source_charset);
110: end if;
111: /* Check to see if the transaction is enabled. If not, abort */

Line 108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

104: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
109: ec_debug.pl(3,'i_source_charset',i_source_charset);
110: end if;
111: /* Check to see if the transaction is enabled. If not, abort */
112: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);

Line 109: ec_debug.pl(3,'i_source_charset',i_source_charset);

105: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
106: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
107: ec_debug.pl(3,'i_map_id',i_map_id);
108: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
109: ec_debug.pl(3,'i_source_charset',i_source_charset);
110: end if;
111: /* Check to see if the transaction is enabled. If not, abort */
112: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
113: IF cEnabled = 'N' THEN

Line 116: if EC_DEBUG.G_debug_level >= 1 then

112: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
113: IF cEnabled = 'N' THEN
114: RAISE ece_transaction_disabled;
115: END IF;
116: if EC_DEBUG.G_debug_level >= 1 then
117: ec_debug.pl(1,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
118: end if;
119: select map_type into i_map_type
120: from ece_mappings

Line 117: ec_debug.pl(1,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);

113: IF cEnabled = 'N' THEN
114: RAISE ece_transaction_disabled;
115: END IF;
116: if EC_DEBUG.G_debug_level >= 1 then
117: ec_debug.pl(1,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
118: end if;
119: select map_type into i_map_type
120: from ece_mappings
121: where map_id = i_map_id

Line 148: if EC_DEBUG.G_debug_level >= 1 then

144: i_map_id,
145: i_run_id
146: );
147: END IF;
148: if EC_DEBUG.G_debug_level >= 1 then
149: ec_debug.pl(1,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
150: end if;
151:
152: process_cati_docs

Line 149: ec_debug.pl(1,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);

145: i_run_id
146: );
147: END IF;
148: if EC_DEBUG.G_debug_level >= 1 then
149: ec_debug.pl(1,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
150: end if;
151:
152: process_cati_docs
153: (

Line 165: ec_debug.pl(3,'o_PO_batch_id',o_PO_batch_id);

161:
162: /* bug2321102: Modified the Argument for batch_id from Argument8 to Argument9 */
163: /* Bug 2513695: Added the argument9(Org_id) to the following submit request */
164:
165: ec_debug.pl(3,'o_PO_batch_id',o_PO_batch_id);
166:
167: i_submit_id := fnd_request.submit_request
168: (
169: application => 'PO',

Line 275: if EC_DEBUG.G_debug_level >= 1 then

271: Argument99 => NULL,
272: Argument100 => NULL
273: );
274:
275: if EC_DEBUG.G_debug_level >= 1 then
276: ec_debug.pl(1,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,
277: 'REQUEST_ID',i_Submit_Id);
278: end if;
279:

Line 276: ec_debug.pl(1,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,

272: Argument100 => NULL
273: );
274:
275: if EC_DEBUG.G_debug_level >= 1 then
276: ec_debug.pl(1,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,
277: 'REQUEST_ID',i_Submit_Id);
278: end if;
279:
280: end if;

Line 286: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

282:
283: retcode := ec_utils.i_ret_code;
284:
285: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
286: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
287: retcode := 1;
288: END IF;
289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);

Line 289: if EC_DEBUG.G_debug_level >= 1 then

285: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
286: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
287: retcode := 1;
288: END IF;
289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');

Line 290: ec_debug.pl(3,'i_submit_id',i_submit_id);

286: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
287: retcode := 1;
288: END IF;
289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

Line 291: ec_debug.pl(3,'retcode',retcode);

287: retcode := 1;
288: END IF;
289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
295: end if;

Line 292: ec_debug.pl(3,'errbuf',errbuf);

288: END IF;
289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
295: end if;
296: ec_debug.disable_debug;

Line 293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');

289: if EC_DEBUG.G_debug_level >= 1 then
290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
295: end if;
296: ec_debug.disable_debug;
297: EXCEPTION

Line 294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

290: ec_debug.pl(3,'i_submit_id',i_submit_id);
291: ec_debug.pl(3,'retcode',retcode);
292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
295: end if;
296: ec_debug.disable_debug;
297: EXCEPTION
298: WHEN ece_transaction_disabled THEN

Line 296: ec_debug.disable_debug;

292: ec_debug.pl(3,'errbuf',errbuf);
293: ec_debug.pop('ECECATI.PROCESS_CATI_INBOUND');
294: ec_debug.pl(1,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
295: end if;
296: ec_debug.disable_debug;
297: EXCEPTION
298: WHEN ece_transaction_disabled THEN
299: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
300: retcode := 1;

Line 299: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

295: end if;
296: ec_debug.disable_debug;
297: EXCEPTION
298: WHEN ece_transaction_disabled THEN
299: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
300: retcode := 1;
301: ec_debug.disable_debug;
302: ROLLBACK WORK;
303:

Line 301: ec_debug.disable_debug;

297: EXCEPTION
298: WHEN ece_transaction_disabled THEN
299: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
300: retcode := 1;
301: ec_debug.disable_debug;
302: ROLLBACK WORK;
303:
304: WHEN EC_UTILS.PROGRAM_EXIT then
305: rollback work;

Line 308: ec_debug.disable_debug;

304: WHEN EC_UTILS.PROGRAM_EXIT then
305: rollback work;
306: retcode := ec_utils.i_ret_code;
307: ece_flatfile_pvt.print_attributes;
308: ec_debug.disable_debug;
309: WHEN OTHERS THEN
310: rollback work;
311: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_INBOUND');
312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 311: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_INBOUND');

307: ece_flatfile_pvt.print_attributes;
308: ec_debug.disable_debug;
309: WHEN OTHERS THEN
310: rollback work;
311: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_INBOUND');
312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
313: ece_flatfile_pvt.print_attributes;
314: retcode :=2;
315: ec_debug.disable_debug;

Line 312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

308: ec_debug.disable_debug;
309: WHEN OTHERS THEN
310: rollback work;
311: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_INBOUND');
312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
313: ece_flatfile_pvt.print_attributes;
314: retcode :=2;
315: ec_debug.disable_debug;
316: end process_cati_inbound;

Line 315: ec_debug.disable_debug;

311: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_INBOUND');
312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
313: ece_flatfile_pvt.print_attributes;
314: retcode :=2;
315: ec_debug.disable_debug;
316: end process_cati_inbound;
317:
318: procedure process_rrqi_inbound
319: (

Line 346: ec_debug.enable_debug(i_debug_mode);

342: cEnabled VARCHAR2(1) := 'Y';
343: ece_transaction_disabled EXCEPTION;
344:
345: begin
346: ec_debug.enable_debug(i_debug_mode);
347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);

Line 347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

343: ece_transaction_disabled EXCEPTION;
344:
345: begin
346: ec_debug.enable_debug(i_debug_mode);
347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);

Line 348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');

344:
345: begin
346: ec_debug.enable_debug(i_debug_mode);
347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);

Line 349: if EC_DEBUG.G_debug_level >= 3 then

345: begin
346: ec_debug.enable_debug(i_debug_mode);
347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);

Line 350: ec_debug.pl(3,'i_file_path',i_file_path);

346: ec_debug.enable_debug(i_debug_mode);
347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);

Line 351: ec_debug.pl(3,'i_file_name',i_file_name);

347: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);

Line 352: ec_debug.pl(3,'i_run_import',i_run_import);

348: ec_debug.push('ECECATI.PROCESS_RRQI_INBOUND');
349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);

Line 353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);

349: if EC_DEBUG.G_debug_level >= 3 then
350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);

Line 354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);

350: ec_debug.pl(3,'i_file_path',i_file_path);
351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);

Line 355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);

351: ec_debug.pl(3,'i_file_name',i_file_name);
352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);

Line 356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);

352: ec_debug.pl(3,'i_run_import',i_run_import);
353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);

Line 357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);

353: ec_debug.pl(3,'i_default_buyer',i_default_buyer);
354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);
361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);

354: ec_debug.pl(3,'i_po_document_type',i_po_document_type);
355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);
361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
362: end if;

Line 359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);

355: ec_debug.pl(3,'i_po_document_sub_type',i_po_document_sub_type);
356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);
361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
362: end if;
363: /* Check to see if the transaction is enabled. If not, abort */

Line 360: ec_debug.pl(3,'i_map_id',i_map_id);

356: ec_debug.pl(3,'i_po_create_item_flag',i_po_create_item_flag);
357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);
361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
362: end if;
363: /* Check to see if the transaction is enabled. If not, abort */
364: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);

Line 361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

357: ec_debug.pl(3,'i_po_sourcing_rules',i_po_sourcing_rules);
358: ec_debug.pl(3,'i_po_approval_status',i_po_approval_status);
359: ec_debug.pl(3,'i_po_release_method',i_po_release_method);
360: ec_debug.pl(3,'i_map_id',i_map_id);
361: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
362: end if;
363: /* Check to see if the transaction is enabled. If not, abort */
364: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
365: IF cEnabled = 'N' THEN

Line 369: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);

365: IF cEnabled = 'N' THEN
366: RAISE ece_transaction_disabled;
367: END IF;
368:
369: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
370: select map_type into i_map_type
371: from ece_mappings
372: where map_id = i_map_id
373: and enabled ='Y';

Line 397: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);

393: i_map_id,
394: i_run_id
395: );
396: END IF;
397: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
398:
399: process_cati_docs
400: (
401: i_transaction_type,

Line 412: ec_debug.pl(3,'o_PO_batch_id',o_PO_batch_id);

408:
409: /* bug2321102: Modified the Argument for batch_id from Argument8 to Argument9 */
410: /* Bug 2513695: Added the argument8(Org_id) to the following submit request */
411:
412: ec_debug.pl(3,'o_PO_batch_id',o_PO_batch_id);
413:
414: i_submit_id := fnd_request.submit_request
415: (
416: application => 'PO',

Line 522: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,

518: Argument99 => NULL,
519: Argument100 => NULL
520: );
521:
522: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,
523: 'REQUEST_ID',i_Submit_Id);
524:
525: end if;
526: commit;

Line 531: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

527:
528: retcode := ec_utils.i_ret_code;
529:
530: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
531: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
532: retcode := 1;
533: END IF;
534: if EC_DEBUG.G_debug_level >= 3 then
535: ec_debug.pl(3,'i_submit_id',i_submit_id);

Line 534: if EC_DEBUG.G_debug_level >= 3 then

530: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
531: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
532: retcode := 1;
533: END IF;
534: if EC_DEBUG.G_debug_level >= 3 then
535: ec_debug.pl(3,'i_submit_id',i_submit_id);
536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;

Line 535: ec_debug.pl(3,'i_submit_id',i_submit_id);

531: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
532: retcode := 1;
533: END IF;
534: if EC_DEBUG.G_debug_level >= 3 then
535: ec_debug.pl(3,'i_submit_id',i_submit_id);
536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');

Line 536: ec_debug.pl(3,'retcode',retcode);

532: retcode := 1;
533: END IF;
534: if EC_DEBUG.G_debug_level >= 3 then
535: ec_debug.pl(3,'i_submit_id',i_submit_id);
536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');
540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

Line 537: ec_debug.pl(3,'errbuf',errbuf);

533: END IF;
534: if EC_DEBUG.G_debug_level >= 3 then
535: ec_debug.pl(3,'i_submit_id',i_submit_id);
536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');
540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
541: ec_debug.disable_debug;

Line 539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');

535: ec_debug.pl(3,'i_submit_id',i_submit_id);
536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');
540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
541: ec_debug.disable_debug;
542: EXCEPTION
543: WHEN ece_transaction_disabled THEN

Line 540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

536: ec_debug.pl(3,'retcode',retcode);
537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');
540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
541: ec_debug.disable_debug;
542: EXCEPTION
543: WHEN ece_transaction_disabled THEN
544: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

Line 541: ec_debug.disable_debug;

537: ec_debug.pl(3,'errbuf',errbuf);
538: end if;
539: ec_debug.pop('ECECATI.PROCESS_RRQI_INBOUND');
540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
541: ec_debug.disable_debug;
542: EXCEPTION
543: WHEN ece_transaction_disabled THEN
544: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
545: retcode := 1;

Line 544: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

540: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
541: ec_debug.disable_debug;
542: EXCEPTION
543: WHEN ece_transaction_disabled THEN
544: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
545: retcode := 1;
546: ec_debug.disable_debug;
547: ROLLBACK WORK;
548:

Line 546: ec_debug.disable_debug;

542: EXCEPTION
543: WHEN ece_transaction_disabled THEN
544: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
545: retcode := 1;
546: ec_debug.disable_debug;
547: ROLLBACK WORK;
548:
549: WHEN EC_UTILS.PROGRAM_EXIT then
550: rollback work;

Line 553: ec_debug.disable_debug;

549: WHEN EC_UTILS.PROGRAM_EXIT then
550: rollback work;
551: retcode := ec_utils.i_ret_code;
552: ece_flatfile_pvt.print_attributes;
553: ec_debug.disable_debug;
554: WHEN OTHERS THEN
555: rollback work;
556: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_RRQI_INBOUND');
557: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 556: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_RRQI_INBOUND');

552: ece_flatfile_pvt.print_attributes;
553: ec_debug.disable_debug;
554: WHEN OTHERS THEN
555: rollback work;
556: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_RRQI_INBOUND');
557: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
558: ece_flatfile_pvt.print_attributes;
559: retcode :=2;
560: ec_debug.disable_debug;

Line 557: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

553: ec_debug.disable_debug;
554: WHEN OTHERS THEN
555: rollback work;
556: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_RRQI_INBOUND');
557: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
558: ece_flatfile_pvt.print_attributes;
559: retcode :=2;
560: ec_debug.disable_debug;
561: end process_rrqi_inbound;

Line 560: ec_debug.disable_debug;

556: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_RRQI_INBOUND');
557: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
558: ece_flatfile_pvt.print_attributes;
559: retcode :=2;
560: ec_debug.disable_debug;
561: end process_rrqi_inbound;
562:
563: end ececati;