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.ARP_TRANS_FLEX dependencies on ARP_TRANS_FLEX

Line 1: PACKAGE BODY ARP_TRANS_FLEX AS

1: PACKAGE BODY ARP_TRANS_FLEX AS
2: /* $Header: ARTUFLXB.pls 115.7 2002/11/18 22:56:06 anukumar ship $ */
3:
4:
5: TYPE flex_context_type IS TABLE OF

Line 103: arp_util.debug('arp_trans_flex.setup_descr_flex()+');

99: l_prior_context := pg_char_dummy;
100: l_ctx_count := 0;
101: l_total_seg_count := 1;
102:
103: arp_util.debug('arp_trans_flex.setup_descr_flex()+');
104:
105: /*----------------------------------------------------------------------+
106: | get the active segment numbers for the transaction flex and store |
107: | the information in package globals |

Line 140: arp_util.debug('arp_trans_flex.setup_descr_flex()-');

136: END LOOP;
137:
138: pg_ctx_count := l_ctx_count;
139:
140: arp_util.debug('arp_trans_flex.setup_descr_flex()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION : arp_trans_flex.setup_descr_flex()');

Line 144: arp_util.debug('EXCEPTION : arp_trans_flex.setup_descr_flex()');

140: arp_util.debug('arp_trans_flex.setup_descr_flex()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION : arp_trans_flex.setup_descr_flex()');
145: arp_util.debug('p_appl_id : '||p_appl_id);
146: arp_util.debug('p_desc_flex : '||p_desc_flex);
147:
148: RAISE;

Line 184: arp_util.debug('arp_trans_flex.print_cache_contents()+');

180: IS
181: l_loc number;
182: BEGIN
183:
184: arp_util.debug('arp_trans_flex.print_cache_contents()+');
185:
186: arp_util.debug('Number of contexts : '||to_char(pg_ctx_count));
187:
188:

Line 204: arp_util.debug('arp_trans_flex.print_cache_contents()-');

200:
201: END LOOP;
202: END LOOP;
203:
204: arp_util.debug('arp_trans_flex.print_cache_contents()-');
205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: arp_util.debug('EXCEPTION: arp_trans_flex.print_cache_contents()');

Line 208: arp_util.debug('EXCEPTION: arp_trans_flex.print_cache_contents()');

204: arp_util.debug('arp_trans_flex.print_cache_contents()-');
205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: arp_util.debug('EXCEPTION: arp_trans_flex.print_cache_contents()');
209: RAISE;
210: END;
211:
212: /*===========================================================================+

Line 258: arp_util.debug('EXCEPTION : arp_trans_flex.find_context()');

254: return(0);
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: arp_util.debug('EXCEPTION : arp_trans_flex.find_context()');
259: arp_util.debug('p_context : '||p_context);
260:
261: RAISE;
262: END;

Line 317: arp_util.debug('arp_trans_flex.build_where_clause()+');

313: l_context ra_customer_trx_lines.interface_line_context%type;
314:
315: BEGIN
316:
317: arp_util.debug('arp_trans_flex.build_where_clause()+');
318:
319: l_context := p_context;
320: l_context_index := p_context_index;
321:

Line 383: arp_util.debug('arp_trans_flex.build_where_clause()-');

379: END LOOP;
380:
381: -- arp_util.debug('Where clause : '||p_where_clause);
382:
383: arp_util.debug('arp_trans_flex.build_where_clause()-');
384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: arp_util.debug('EXCEPTION : arp_trans_flex.build_where_clause');

Line 387: arp_util.debug('EXCEPTION : arp_trans_flex.build_where_clause');

383: arp_util.debug('arp_trans_flex.build_where_clause()-');
384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: arp_util.debug('EXCEPTION : arp_trans_flex.build_where_clause');
388: arp_util.debug('p_context : '||p_context);
389:
390: RAISE;
391: END;

Line 444: arp_util.debug('arp_trans_flex.check_uniqueness()+');

440: l_rows NUMBER;
441:
442: BEGIN
443:
444: arp_util.debug('arp_trans_flex.check_uniqueness()+');
445:
446: dbms_sql.define_column( p_cursor, 1, l_customer_trx_id);
447: dbms_sql.define_column( p_cursor, 2, l_customer_trx_line_id);
448:

Line 465: arp_util.debug('arp_trans_flex.check_uniqueness()-');

461: dbms_sql.column_value( p_cursor, 2, l_customer_trx_line_id);
462: p_customer_trx_id := l_customer_trx_id;
463: p_customer_trx_line_id := l_customer_trx_line_id;
464:
465: arp_util.debug('arp_trans_flex.check_uniqueness()-');
466: return(FALSE);
467: END IF;
468:
469: arp_util.debug('arp_trans_flex.check_uniqueness()-');

Line 469: arp_util.debug('arp_trans_flex.check_uniqueness()-');

465: arp_util.debug('arp_trans_flex.check_uniqueness()-');
466: return(FALSE);
467: END IF;
468:
469: arp_util.debug('arp_trans_flex.check_uniqueness()-');
470: return(TRUE);
471:
472: EXCEPTION
473: WHEN OTHERS THEN

Line 474: arp_util.debug('EXCEPTION : arp_trans_flex.check_uniqueness()');

470: return(TRUE);
471:
472: EXCEPTION
473: WHEN OTHERS THEN
474: arp_util.debug('EXCEPTION : arp_trans_flex.check_uniqueness()');
475: arp_util.debug('p_cursor : '|| p_cursor);
476:
477: IF (p_cursor IS NOT NULL)
478: THEN dbms_sql.close_cursor(p_cursor);

Line 532: arp_util.debug('arp_trans_flex.Get_Cursor()+');

528: l_cursor BINARY_INTEGER;
529:
530: BEGIN
531:
532: arp_util.debug('arp_trans_flex.Get_Cursor()+');
533:
534: l_context := pg_flex_contexts( p_context_index );
535:
536: /*-----------------------------+

Line 601: arp_util.debug('arp_trans_flex.Get_Cursor()-');

597: THEN pg_ctl_cursors( p_context_index ) := l_cursor;
598: ELSE pg_ril_cursors( p_context_index ) := l_cursor;
599: END IF;
600:
601: arp_util.debug('arp_trans_flex.Get_Cursor()-');
602:
603: RETURN(l_cursor);
604:
605: EXCEPTION

Line 607: arp_util.debug('EXCEPTION : arp_trans_flex.Get_Cursor()');

603: RETURN(l_cursor);
604:
605: EXCEPTION
606: WHEN OTHERS THEN
607: arp_util.debug('EXCEPTION : arp_trans_flex.Get_Cursor()');
608: arp_util.debug('p_context_index = ' || TO_CHAR( p_context_index));
609: arp_util.debug('p_table_name = ' || p_table_name);
610:
611: RAISE;

Line 653: arp_util.debug('arp_trans_flex.Bind_Variables()+');

649: p_value IN VARCHAR2
650: ) IS
651: BEGIN
652:
653: arp_util.debug('arp_trans_flex.Bind_Variables()+');
654:
655: dbms_sql.bind_variable( p_cursor,
656: p_bind_variable,
657: p_value );

Line 659: arp_util.debug('arp_trans_flex.Bind_Variables()-');

655: dbms_sql.bind_variable( p_cursor,
656: p_bind_variable,
657: p_value );
658:
659: arp_util.debug('arp_trans_flex.Bind_Variables()-');
660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: IF (SQLCODE = -1006)

Line 666: arp_util.debug('EXCEPTION : arp_trans_flex.Bind_Variable()');

662: WHEN OTHERS THEN
663: IF (SQLCODE = -1006)
664: THEN NULL;
665: ELSE
666: arp_util.debug('EXCEPTION : arp_trans_flex.Bind_Variable()');
667: arp_util.debug('p_cursor = ' || p_cursor);
668: arp_util.debug('p_bind_variable = ' || p_bind_variable);
669: arp_util.debug('p_value = ' || p_value);
670:

Line 762: arp_util.debug('arp_trans_flex.Bind_All_Variables()+');

758: p_interface_line_attribute15 IN
759: ra_customer_trx_lines.interface_line_attribute15%type) IS
760: BEGIN
761:
762: arp_util.debug('arp_trans_flex.Bind_All_Variables()+');
763:
764:
765: /*-------------------------------------------------------+
766: | Bind variables into the ra_customer_trx_line cursor |

Line 1020: arp_util.debug('arp_trans_flex.Bind_All_Variables()-');

1016: ':INTERFACE_LINE_ATTRIBUTE15',
1017: p_interface_line_attribute15
1018: );
1019:
1020: arp_util.debug('arp_trans_flex.Bind_All_Variables()-');
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: arp_util.debug('EXCEPTION : arp_trans_flex.Bind_All_Variables');

Line 1024: arp_util.debug('EXCEPTION : arp_trans_flex.Bind_All_Variables');

1020: arp_util.debug('arp_trans_flex.Bind_All_Variables()-');
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: arp_util.debug('EXCEPTION : arp_trans_flex.Bind_All_Variables');
1025:
1026: arp_util.debug('p_ctl_cursor : ' || p_ctl_cursor);
1027: arp_util.debug('p_ril_cursor : ' || p_ctl_cursor);
1028: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);

Line 1161: arp_util.debug('arp_trans_flex.unique_trans_flex()+');

1157: l_dummy BINARY_INTEGER;
1158:
1159: BEGIN
1160:
1161: arp_util.debug('arp_trans_flex.unique_trans_flex()+');
1162:
1163: /*------------------------------------------------+
1164: | Get the context index from the context cache |
1165: +------------------------------------------------*/

Line 1252: arp_util.debug('EXCEPTION : arp_trans_flex.unique_trans_flex');

1248: return(TRUE);
1249:
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: arp_util.debug('EXCEPTION : arp_trans_flex.unique_trans_flex');
1253:
1254: arp_util.debug('p_ctl_id : '|| p_ctl_id);
1255: arp_util.debug('p_interface_line_context : '||
1256: p_interface_line_context);