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_UTILS

Line 90: ec_utils.g_stack.DELETE;

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:
92: --- Put the IN Variables on the Stack.
93: --- None for INI
94:

Line 112: m_var_found := ec_utils.find_variable(0,'L_HEADER_ID',m_stack_pos,m_plsql_pos);

108: or else no need to derive.
109: */
110:
111: IF i_run_import = 'Y' THEN
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);

Line 115: o_invoice_id := ec_utils.g_stack(m_stack_pos).variable_value;

111: IF i_run_import = 'Y' THEN
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;

Line 119: ec_utils.i_ret_code :=2;

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:
123: begin

Line 120: raise EC_UTILS.PROGRAM_EXIT;

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:
123: begin
124: select group_id

Line 133: raise EC_UTILS.PROGRAM_EXIT;

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);
137: end;

Line 142: m_var_found := ec_utils.find_variable(0,'L_GROUP_ID',m_stack_pos,m_plsql_pos);

138:
139:
140: /* --- Get the GROUP_ID
141:
142: m_var_found := ec_utils.find_variable(0,'L_GROUP_ID',m_stack_pos,m_plsql_pos);
143: Bug No: 2101935 Commented the If condition and modified the search for group_id.
144:
145: ec_utils.find_pos(1,'GROUP_ID',m_plsql_pos);
146: o_group_id := ec_utils.g_file_tbl(m_plsql_pos).value;

Line 145: ec_utils.find_pos(1,'GROUP_ID',m_plsql_pos);

141:
142: m_var_found := ec_utils.find_variable(0,'L_GROUP_ID',m_stack_pos,m_plsql_pos);
143: Bug No: 2101935 Commented the If condition and modified the search for group_id.
144:
145: ec_utils.find_pos(1,'GROUP_ID',m_plsql_pos);
146: o_group_id := ec_utils.g_file_tbl(m_plsql_pos).value;
147:
148: IF m_var_found THEN
149: o_group_id := ec_utils.g_stack(m_stack_pos).variable_value;

Line 146: o_group_id := ec_utils.g_file_tbl(m_plsql_pos).value;

142: m_var_found := ec_utils.find_variable(0,'L_GROUP_ID',m_stack_pos,m_plsql_pos);
143: Bug No: 2101935 Commented the If condition and modified the search for group_id.
144:
145: ec_utils.find_pos(1,'GROUP_ID',m_plsql_pos);
146: o_group_id := ec_utils.g_file_tbl(m_plsql_pos).value;
147:
148: IF m_var_found THEN
149: o_group_id := ec_utils.g_stack(m_stack_pos).variable_value;
150: ELSE

Line 149: o_group_id := ec_utils.g_stack(m_stack_pos).variable_value;

145: ec_utils.find_pos(1,'GROUP_ID',m_plsql_pos);
146: o_group_id := ec_utils.g_file_tbl(m_plsql_pos).value;
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;

Line 152: ec_utils.i_ret_code :=2;

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:
156: IF i_run_import = 'Y' THEN

Line 153: raise EC_UTILS.PROGRAM_EXIT;

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:
156: IF i_run_import = 'Y' THEN
157: Bug 2204431 end

Line 180: retcode := ec_utils.i_ret_code;

176: END IF;
177:
178: COMMIT;
179:
180: retcode := ec_utils.i_ret_code;
181:
182: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
183: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
184: retcode := 1;

Line 201: WHEN ec_utils.program_exit then

197: retcode := 1;
198: ec_debug.disable_debug;
199: ROLLBACK WORK;
200:
201: WHEN ec_utils.program_exit then
202: retcode := ec_utils.i_ret_code;
203: ece_flatfile_pvt.print_attributes;
204: ROLLBACK WORK;
205: ec_debug.disable_debug;

Line 202: retcode := ec_utils.i_ret_code;

198: ec_debug.disable_debug;
199: ROLLBACK WORK;
200:
201: WHEN ec_utils.program_exit then
202: retcode := ec_utils.i_ret_code;
203: ece_flatfile_pvt.print_attributes;
204: ROLLBACK WORK;
205: ec_debug.disable_debug;
206:

Line 232: ec_utils.find_pos(1,'GROUP_ID',plsql_pos);

228: from dual;
229: end if;
230: ec_debug.pl(3,'l_group_id',l_group_id);
231:
232: ec_utils.find_pos(1,'GROUP_ID',plsql_pos);
233: ec_utils.g_file_tbl(plsql_pos).value:=to_char(l_group_id);
234:
235: ec_debug.pop('ECEINI.GET_GROUP_ID');
236:

Line 233: ec_utils.g_file_tbl(plsql_pos).value:=to_char(l_group_id);

229: end if;
230: ec_debug.pl(3,'l_group_id',l_group_id);
231:
232: ec_utils.find_pos(1,'GROUP_ID',plsql_pos);
233: ec_utils.g_file_tbl(plsql_pos).value:=to_char(l_group_id);
234:
235: ec_debug.pop('ECEINI.GET_GROUP_ID');
236:
237: EXCEPTION

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

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

Line 241: ec_utils.i_ret_code := 2;

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

Line 242: raise EC_UTILS.PROGRAM_EXIT;

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