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.ARRX_C_COGS_REP_OUTER dependencies on FND_FILE

Line 135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');

131: -- call the inner report passing mandatory parameters
132: -- and report specific parameters
133:
134: IF pg_debug in ('Y', 'C') THEN
135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');
136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);

Line 136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);

132: -- and report specific parameters
133:
134: IF pg_debug in ('Y', 'C') THEN
135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');
136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);

Line 137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);

133:
134: IF pg_debug in ('Y', 'C') THEN
135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');
136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);

Line 138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);

134: IF pg_debug in ('Y', 'C') THEN
135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');
136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
142: END IF;

Line 139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);

135: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()+');
136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
142: END IF;
143:

Line 140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);

136: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
142: END IF;
143:
144: -- Populate mandatory parameters for request_id and user_id

Line 141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);

137: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
138: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
139: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
140: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
141: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
142: END IF;
143:
144: -- Populate mandatory parameters for request_id and user_id
145:

Line 159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);

155: l_sales_order_high := argument4;
156: l_posted_lines_only := argument5;
157: l_unmatched_items_only := argument6;
158:
159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);

Line 160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);

156: l_posted_lines_only := argument5;
157: l_unmatched_items_only := argument6;
158:
159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);

Line 161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);

157: l_unmatched_items_only := argument6;
158:
159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||

Line 162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);

158:
159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
166: l_posted_lines_only);

Line 163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);

159: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
166: l_posted_lines_only);
167: fnd_file.put_line(fnd_file.log, 'unmatched items only: ' ||

Line 164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);

160: fnd_file.put_line(fnd_file.log, 'user id : ' || l_user_id);
161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
166: l_posted_lines_only);
167: fnd_file.put_line(fnd_file.log, 'unmatched items only: ' ||
168: l_unmatched_items_only);

Line 165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||

161: fnd_file.put_line(fnd_file.log, 'low gl date: ' || l_gl_date_low);
162: fnd_file.put_line(fnd_file.log, 'high gl date: ' || l_gl_date_high);
163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
166: l_posted_lines_only);
167: fnd_file.put_line(fnd_file.log, 'unmatched items only: ' ||
168: l_unmatched_items_only);
169:

Line 167: fnd_file.put_line(fnd_file.log, 'unmatched items only: ' ||

163: fnd_file.put_line(fnd_file.log, 'low sales order: ' || l_sales_order_low);
164: fnd_file.put_line(fnd_file.log, 'high sales order: ' || l_sales_order_high);
165: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
166: l_posted_lines_only);
167: fnd_file.put_line(fnd_file.log, 'unmatched items only: ' ||
168: l_unmatched_items_only);
169:
170: arrx_cogs_rep_inner.populate_rows
171: (

Line 184: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');

180: x_retcode => retcode,
181: x_errbuf => errbuf
182: );
183:
184: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');
185:
186: IF PG_DEBUG in ('Y', 'C') THEN
187: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');
188: END IF;

Line 187: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');

183:
184: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');
185:
186: IF PG_DEBUG in ('Y', 'C') THEN
187: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');
188: END IF;
189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN

Line 193: fnd_file.put_line(fnd_file.log,

189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: IF PG_DEBUG in ('Y', 'C') THEN
193: fnd_file.put_line(fnd_file.log,
194: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
195: END IF;
196: RAISE;
197:

Line 200: fnd_file.put_line(fnd_file.log, sqlcode);

196: RAISE;
197:
198: WHEN OTHERS THEN
199: IF PG_DEBUG in ('Y', 'C') THEN
200: fnd_file.put_line(fnd_file.log, sqlcode);
201: fnd_file.put_line(fnd_file.log, sqlerrm);
202: retcode := 2;
203: fnd_file.put_line(fnd_file.log,
204: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');

Line 201: fnd_file.put_line(fnd_file.log, sqlerrm);

197:
198: WHEN OTHERS THEN
199: IF PG_DEBUG in ('Y', 'C') THEN
200: fnd_file.put_line(fnd_file.log, sqlcode);
201: fnd_file.put_line(fnd_file.log, sqlerrm);
202: retcode := 2;
203: fnd_file.put_line(fnd_file.log,
204: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
205: END IF;

Line 203: fnd_file.put_line(fnd_file.log,

199: IF PG_DEBUG in ('Y', 'C') THEN
200: fnd_file.put_line(fnd_file.log, sqlcode);
201: fnd_file.put_line(fnd_file.log, sqlerrm);
202: retcode := 2;
203: fnd_file.put_line(fnd_file.log,
204: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
205: END IF;
206: RAISE;
207:

Line 329: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');

325:
326: -- call the inner report passing mandatory parameters
327: -- and report specific parameters
328:
329: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
330:
331: IF pg_debug in ('Y', 'C') THEN
332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);

Line 332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');

328:
329: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
330:
331: IF pg_debug in ('Y', 'C') THEN
332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);

Line 333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);

329: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
330:
331: IF pg_debug in ('Y', 'C') THEN
332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);

Line 334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);

330:
331: IF pg_debug in ('Y', 'C') THEN
332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);

Line 335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);

331: IF pg_debug in ('Y', 'C') THEN
332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
339: END IF;

Line 336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);

332: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.SUMMARY()+');
333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
339: END IF;
340:

Line 337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);

333: fnd_file.put_line(fnd_file.log, 'argument1 : ' || argument1);
334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
339: END IF;
340:
341: -- Populate mandatory parameters for request_id and user_id

Line 338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);

334: fnd_file.put_line(fnd_file.log, 'argument2 : ' || argument2);
335: fnd_file.put_line(fnd_file.log, 'argument3 : ' || argument3);
336: fnd_file.put_line(fnd_file.log, 'argument4 : ' || argument4);
337: fnd_file.put_line(fnd_file.log, 'argument5 : ' || argument5);
338: fnd_file.put_line(fnd_file.log, 'argument6 : ' || argument6);
339: END IF;
340:
341: -- Populate mandatory parameters for request_id and user_id
342:

Line 356: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);

352: l_gl_account_low := argument4;
353: l_gl_account_high := argument5;
354: l_posted_lines_only := argument6;
355:
356: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);
358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);

Line 357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);

353: l_gl_account_high := argument5;
354: l_posted_lines_only := argument6;
355:
356: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);
358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);
361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);

Line 358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||

354: l_posted_lines_only := argument6;
355:
356: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);
358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);
361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);
362: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||

Line 360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);

356: fnd_file.put_line(fnd_file.log, 'request id: ' || l_request_id);
357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);
358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);
361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);
362: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
363: l_posted_lines_only);
364:

Line 361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);

357: fnd_file.put_line(fnd_file.log, 'user id: ' || l_user_id);
358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);
361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);
362: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
363: l_posted_lines_only);
364:
365: -- call the inner routine to actually populate the interface table.

Line 362: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||

358: fnd_file.put_line(fnd_file.log, 'chart of account: ' ||
359: l_chart_of_accounts_id);
360: fnd_file.put_line(fnd_file.log, 'low gl account: ' || l_gl_date_low);
361: fnd_file.put_line(fnd_file.log, 'high gl account: ' || l_gl_date_high);
362: fnd_file.put_line(fnd_file.log, 'posted lines only: ' ||
363: l_posted_lines_only);
364:
365: -- call the inner routine to actually populate the interface table.
366: arrx_cogs_rep_inner.populate_summary

Line 380: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');

376: x_retcode => retcode,
377: x_errbuf => errbuf
378: );
379:
380: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');
381:
382: IF PG_DEBUG in ('Y', 'C') THEN
383: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');
384: END IF;

Line 383: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');

379:
380: fnd_file.put_line(fnd_file.log, 'after arrx_cogs_rep_inner.populate_rows');
381:
382: IF PG_DEBUG in ('Y', 'C') THEN
383: fnd_file.put_line(fnd_file.log, 'ARRX_C_COGS_REP_OUTER.WRAPPER()-');
384: END IF;
385:
386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN

Line 389: fnd_file.put_line(fnd_file.log,

385:
386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN
388: IF PG_DEBUG in ('Y', 'C') THEN
389: fnd_file.put_line(fnd_file.log,
390: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
391: END IF;
392: RAISE;
393:

Line 396: fnd_file.put_line(fnd_file.log, sqlcode);

392: RAISE;
393:
394: WHEN OTHERS THEN
395: IF PG_DEBUG in ('Y', 'C') THEN
396: fnd_file.put_line(fnd_file.log, sqlcode);
397: fnd_file.put_line(fnd_file.log, sqlerrm);
398: retcode := 2;
399: fnd_file.put_line(fnd_file.log,
400: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');

Line 397: fnd_file.put_line(fnd_file.log, sqlerrm);

393:
394: WHEN OTHERS THEN
395: IF PG_DEBUG in ('Y', 'C') THEN
396: fnd_file.put_line(fnd_file.log, sqlcode);
397: fnd_file.put_line(fnd_file.log, sqlerrm);
398: retcode := 2;
399: fnd_file.put_line(fnd_file.log,
400: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
401: END IF;

Line 399: fnd_file.put_line(fnd_file.log,

395: IF PG_DEBUG in ('Y', 'C') THEN
396: fnd_file.put_line(fnd_file.log, sqlcode);
397: fnd_file.put_line(fnd_file.log, sqlerrm);
398: retcode := 2;
399: fnd_file.put_line(fnd_file.log,
400: 'EXCEPTION: arrx_c_cogs_rep_outer.wrapper()');
401: END IF;
402: RAISE;
403:

Line 420: fnd_file.put_line(fnd_file.log,

416: NULL;
417:
418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: fnd_file.put_line(fnd_file.log,
421: 'EXCEPTION: arrx_c_cogs_rep_outer.initialize()');
422: RAISE;
423:
424: WHEN OTHERS THEN

Line 425: fnd_file.put_line(fnd_file.log,

421: 'EXCEPTION: arrx_c_cogs_rep_outer.initialize()');
422: RAISE;
423:
424: WHEN OTHERS THEN
425: fnd_file.put_line(fnd_file.log,
426: 'EXCEPTION: arrx_c_cogs_rep_outer.initialize()');
427: RAISE;
428:
429: END arrx_c_cogs_rep_outer;