1: PACKAGE BODY arrx_c_cogs_rep_outer AS
2: /* $Header: ARRXCWRB.pls 120.1 2005/10/30 04:45:52 appldev noship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants
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);
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
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:
198: WHEN OTHERS 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:
208: END wrapper;
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);
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);
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
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:
394: WHEN OTHERS 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:
404: END summary;
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
425: fnd_file.put_line(fnd_file.log,
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;
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;