eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECEINI dependencies on EC_DEBUG

Line 36: ec_debug.enable_debug(i_debug_mode);

32: cEnabled VARCHAR2(1) := 'Y';
33: ece_transaction_disabled EXCEPTION;
34:
35: BEGIN
36: ec_debug.enable_debug(i_debug_mode);
37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);

Line 37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');

33: ece_transaction_disabled EXCEPTION;
34:
35: BEGIN
36: ec_debug.enable_debug(i_debug_mode);
37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

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

34:
35: BEGIN
36: ec_debug.enable_debug(i_debug_mode);
37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);

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

35: BEGIN
36: ec_debug.enable_debug(i_debug_mode);
37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);

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

36: ec_debug.enable_debug(i_debug_mode);
37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);

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

37: ec_debug.push('ECEINI.PROCESS_INVOICE_INBOUND');
38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);

Line 42: ec_debug.pl(3,'i_batch_name',i_batch_name);

38: ec_debug.pl(3,'i_file_path',i_file_path);
39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);

Line 43: ec_debug.pl(3,'i_hold_name',i_hold_name);

39: ec_debug.pl(3,'i_file_name',i_file_name);
40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);

Line 44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);

40: ec_debug.pl(3,'i_run_import',i_run_import);
41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);

Line 45: ec_debug.pl(3,'i_gl_date',i_gl_date);

41: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 46: ec_debug.pl(3,'i_purge',i_purge);

42: ec_debug.pl(3,'i_batch_name',i_batch_name);
43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
50: ec_debug.pl(3,'i_source_charset',i_source_charset);

Line 47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);

43: ec_debug.pl(3,'i_hold_name',i_hold_name);
44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
50: ec_debug.pl(3,'i_source_charset',i_source_charset);
51:

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

44: ec_debug.pl(3,'i_hold_reason',i_hold_reason);
45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
50: ec_debug.pl(3,'i_source_charset',i_source_charset);
51:
52: /* Check to see if the transaction is enabled. If not, abort */

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

45: ec_debug.pl(3,'i_gl_date',i_gl_date);
46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
50: ec_debug.pl(3,'i_source_charset',i_source_charset);
51:
52: /* Check to see if the transaction is enabled. If not, abort */
53: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);

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

46: ec_debug.pl(3,'i_purge',i_purge);
47: ec_debug.pl(3,'i_summarize_flag',i_summarize_flag);
48: ec_debug.pl(3,'i_map_id',i_map_id);
49: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
50: ec_debug.pl(3,'i_source_charset',i_source_charset);
51:
52: /* Check to see if the transaction is enabled. If not, abort */
53: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
54: IF cEnabled = 'N' THEN

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

54: IF cEnabled = 'N' THEN
55: RAISE ece_transaction_disabled;
56: END IF;
57:
58: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
59:
60: select map_type into i_map_type
61: from ece_mappings
62: where map_id = i_map_id

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

83: i_map_id,
84: i_run_id
85: );
86: END IF;
87: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
88:
89: -- Initialize the Stack Table
90: ec_utils.g_stack.DELETE;
91:

Line 95: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

91:
92: --- Put the IN Variables on the Stack.
93: --- None for INI
94:
95: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
96: ece_inbound.process_run_inbound
97: (i_transaction_type => i_transaction_type,
98: i_run_id => i_run_id);
99:

Line 100: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

96: ece_inbound.process_run_inbound
97: (i_transaction_type => i_transaction_type,
98: i_run_id => i_run_id);
99:
100: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
101:
102: --- Get out variables from the Stack .
103: /* Bug 2204431 start.
104: Get the Invoice Id and derive Group Id,

Line 116: ec_debug.pl(0,'o_invoice_id ',o_invoice_id);

112: m_var_found := ec_utils.find_variable(0,'L_HEADER_ID',m_stack_pos,m_plsql_pos);
113:
114: IF m_var_found THEN
115: o_invoice_id := ec_utils.g_stack(m_stack_pos).variable_value;
116: ec_debug.pl(0,'o_invoice_id ',o_invoice_id);
117: ELSE
118: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','L_HEADER_ID');
119: ec_utils.i_ret_code :=2;
120: raise EC_UTILS.PROGRAM_EXIT;

Line 118: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','L_HEADER_ID');

114: IF m_var_found THEN
115: o_invoice_id := ec_utils.g_stack(m_stack_pos).variable_value;
116: ec_debug.pl(0,'o_invoice_id ',o_invoice_id);
117: ELSE
118: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','L_HEADER_ID');
119: ec_utils.i_ret_code :=2;
120: raise EC_UTILS.PROGRAM_EXIT;
121: END IF;
122:

Line 128: ec_debug.pl(0,'o_group_id ',o_group_id);

124: select group_id
125: into o_group_id
126: from ap_invoices_interface
127: where invoice_id = o_invoice_id;
128: ec_debug.pl(0,'o_group_id ',o_group_id);
129: exception
130: when no_data_found then
131: ec_debug.pl(3,'o_group_id ',o_group_id);
132: ec_debug.pl(3,'Group id not found for invoice id');

Line 131: ec_debug.pl(3,'o_group_id ',o_group_id);

127: where invoice_id = o_invoice_id;
128: ec_debug.pl(0,'o_group_id ',o_group_id);
129: exception
130: when no_data_found then
131: ec_debug.pl(3,'o_group_id ',o_group_id);
132: ec_debug.pl(3,'Group id not found for invoice id');
133: raise EC_UTILS.PROGRAM_EXIT;
134: when others then
135: ec_debug.pl(3,'Unable to derive Group id from invoice id');

Line 132: ec_debug.pl(3,'Group id not found for invoice id');

128: ec_debug.pl(0,'o_group_id ',o_group_id);
129: exception
130: when no_data_found then
131: ec_debug.pl(3,'o_group_id ',o_group_id);
132: ec_debug.pl(3,'Group id not found for invoice id');
133: raise EC_UTILS.PROGRAM_EXIT;
134: when others then
135: ec_debug.pl(3,'Unable to derive Group id from invoice id');
136: ec_debug.pl(3,'o_group_id ',o_group_id);

Line 135: ec_debug.pl(3,'Unable to derive Group id from invoice id');

131: ec_debug.pl(3,'o_group_id ',o_group_id);
132: ec_debug.pl(3,'Group id not found for invoice id');
133: raise EC_UTILS.PROGRAM_EXIT;
134: when others then
135: ec_debug.pl(3,'Unable to derive Group id from invoice id');
136: ec_debug.pl(3,'o_group_id ',o_group_id);
137: end;
138:
139:

Line 136: ec_debug.pl(3,'o_group_id ',o_group_id);

132: ec_debug.pl(3,'Group id not found for invoice id');
133: raise EC_UTILS.PROGRAM_EXIT;
134: when others then
135: ec_debug.pl(3,'Unable to derive Group id from invoice id');
136: ec_debug.pl(3,'o_group_id ',o_group_id);
137: end;
138:
139:
140: /* --- Get the GROUP_ID

Line 151: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','L_GROUP_ID');

147:
148: IF m_var_found THEN
149: o_group_id := ec_utils.g_stack(m_stack_pos).variable_value;
150: ELSE
151: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','L_GROUP_ID');
152: ec_utils.i_ret_code :=2;
153: raise EC_UTILS.PROGRAM_EXIT;
154: END IF;
155:

Line 176: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,'REQUEST_ID',i_Submit_Id);

172: argument10 => i_summarize_flag
173: );
174: ----argument6 => i_gl_date,to_char(i_Date,'YYYY/MM/DD HH24:MI:SS'),
175:
176: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',i_transaction_type,'REQUEST_ID',i_Submit_Id);
177: END IF;
178:
179: COMMIT;
180:

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

180:
181: retcode := ec_utils.i_ret_code;
182:
183: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
184: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
185: retcode := 1;
186: END IF;
187:
188: ec_debug.pl(3,'retcode',retcode);

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

184: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
185: retcode := 1;
186: END IF;
187:
188: ec_debug.pl(3,'retcode',retcode);
189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

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

185: retcode := 1;
186: END IF;
187:
188: ec_debug.pl(3,'retcode',retcode);
189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
193: ec_debug.disable_debug;

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

186: END IF;
187:
188: ec_debug.pl(3,'retcode',retcode);
189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
193: ec_debug.disable_debug;
194:

Line 191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');

187:
188: ec_debug.pl(3,'retcode',retcode);
189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
193: ec_debug.disable_debug;
194:
195: EXCEPTION

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

188: ec_debug.pl(3,'retcode',retcode);
189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
193: ec_debug.disable_debug;
194:
195: EXCEPTION
196: WHEN ece_transaction_disabled THEN

Line 193: ec_debug.disable_debug;

189: ec_debug.pl(3,'errbuf',errbuf);
190: ec_debug.pl(3,'i_submit_id',i_submit_id);
191: ec_debug.pop('ECEINI.PROCESS_INVOICE_INBOUND');
192: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
193: ec_debug.disable_debug;
194:
195: EXCEPTION
196: WHEN ece_transaction_disabled THEN
197: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

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

193: ec_debug.disable_debug;
194:
195: EXCEPTION
196: WHEN ece_transaction_disabled THEN
197: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
198: retcode := 1;
199: ec_debug.disable_debug;
200: ROLLBACK WORK;
201:

Line 199: ec_debug.disable_debug;

195: EXCEPTION
196: WHEN ece_transaction_disabled THEN
197: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
198: retcode := 1;
199: ec_debug.disable_debug;
200: ROLLBACK WORK;
201:
202: WHEN ec_utils.program_exit then
203: retcode := ec_utils.i_ret_code;

Line 206: ec_debug.disable_debug;

202: WHEN ec_utils.program_exit then
203: retcode := ec_utils.i_ret_code;
204: ece_flatfile_pvt.print_attributes;
205: ROLLBACK WORK;
206: ec_debug.disable_debug;
207:
208: WHEN OTHERS THEN
209: ROLLBACK WORK;
210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECEINI.PROCESS_INVOICE_INBOUND');

Line 210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECEINI.PROCESS_INVOICE_INBOUND');

206: ec_debug.disable_debug;
207:
208: WHEN OTHERS THEN
209: ROLLBACK WORK;
210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECEINI.PROCESS_INVOICE_INBOUND');
211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: ece_flatfile_pvt.print_attributes;
213: retcode := 2;
214: ec_debug.disable_debug;

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

207:
208: WHEN OTHERS THEN
209: ROLLBACK WORK;
210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECEINI.PROCESS_INVOICE_INBOUND');
211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: ece_flatfile_pvt.print_attributes;
213: retcode := 2;
214: ec_debug.disable_debug;
215:

Line 214: ec_debug.disable_debug;

210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECEINI.PROCESS_INVOICE_INBOUND');
211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: ece_flatfile_pvt.print_attributes;
213: retcode := 2;
214: ec_debug.disable_debug;
215:
216: END process_invoice_inbound;
217:
218: /* Bug 2598743 */

Line 224: ec_debug.push('ECEINI.GET_GROUP_ID');

220: PROCEDURE get_group_id
221: IS
222: plsql_pos pls_integer;
223: BEGIN
224: ec_debug.push('ECEINI.GET_GROUP_ID');
225:
226: if l_group_id IS NULL then
227: select AP_INTERFACE_GROUPS_S.NEXTVAL
228: into l_group_id

Line 231: ec_debug.pl(3,'l_group_id',l_group_id);

227: select AP_INTERFACE_GROUPS_S.NEXTVAL
228: into l_group_id
229: from dual;
230: end if;
231: ec_debug.pl(3,'l_group_id',l_group_id);
232:
233: ec_utils.find_pos(1,'GROUP_ID',plsql_pos);
234: ec_utils.g_file_tbl(plsql_pos).value:=to_char(l_group_id);
235:

Line 236: ec_debug.pop('ECEINI.GET_GROUP_ID');

232:
233: ec_utils.find_pos(1,'GROUP_ID',plsql_pos);
234: ec_utils.g_file_tbl(plsql_pos).value:=to_char(l_group_id);
235:
236: ec_debug.pop('ECEINI.GET_GROUP_ID');
237:
238: EXCEPTION
239: WHEN OTHERS then
240: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.GET_NEXTVAL_SEQ');

Line 240: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.GET_NEXTVAL_SEQ');

236: ec_debug.pop('ECEINI.GET_GROUP_ID');
237:
238: EXCEPTION
239: WHEN OTHERS then
240: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.GET_NEXTVAL_SEQ');
241: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
242: ec_utils.i_ret_code := 2;
243: raise EC_UTILS.PROGRAM_EXIT;
244: END get_group_id;

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

237:
238: EXCEPTION
239: WHEN OTHERS then
240: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.GET_NEXTVAL_SEQ');
241: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
242: ec_utils.i_ret_code := 2;
243: raise EC_UTILS.PROGRAM_EXIT;
244: END get_group_id;
245: