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.AR_INVOICE_VALIDATE_FLEX dependencies on AR_INVOICE_UTILS

Line 42: ar_invoice_utils.debug('setup_descr_flex()+');

38: l_total_seg_count := 1;
39:
40: IF pg_debug = 'Y'
41: THEN
42: ar_invoice_utils.debug('setup_descr_flex()+');
43: END IF;
44:
45: /*----------------------------------------------------------------------+
46: | get the active segment numbers for the transaction flex and store |

Line 81: ar_invoice_utils.debug('setup_descr_flex()-');

77:
78: pg_ctx_count := l_ctx_count;
79: IF pg_debug = 'Y'
80: THEN
81: ar_invoice_utils.debug('setup_descr_flex()-');
82: END IF;
83:
84:
85: EXCEPTION

Line 89: ar_invoice_utils.debug('EXCEPTION : setup_descr_flex()');

85: EXCEPTION
86: WHEN OTHERS THEN
87: IF pg_debug = 'Y'
88: THEN
89: ar_invoice_utils.debug('EXCEPTION : setup_descr_flex()');
90: ar_invoice_utils.debug('p_appl_id : '||p_appl_id);
91: ar_invoice_utils.debug('p_desc_flex : '||p_desc_flex);
92: END IF;
93: RAISE;

Line 90: ar_invoice_utils.debug('p_appl_id : '||p_appl_id);

86: WHEN OTHERS THEN
87: IF pg_debug = 'Y'
88: THEN
89: ar_invoice_utils.debug('EXCEPTION : setup_descr_flex()');
90: ar_invoice_utils.debug('p_appl_id : '||p_appl_id);
91: ar_invoice_utils.debug('p_desc_flex : '||p_desc_flex);
92: END IF;
93: RAISE;
94: END setup_descr_flex;

Line 91: ar_invoice_utils.debug('p_desc_flex : '||p_desc_flex);

87: IF pg_debug = 'Y'
88: THEN
89: ar_invoice_utils.debug('EXCEPTION : setup_descr_flex()');
90: ar_invoice_utils.debug('p_appl_id : '||p_appl_id);
91: ar_invoice_utils.debug('p_desc_flex : '||p_desc_flex);
92: END IF;
93: RAISE;
94: END setup_descr_flex;
95:

Line 115: ar_invoice_utils.debug('EXCEPTION : find_context()');

111: EXCEPTION
112: WHEN OTHERS THEN
113: IF pg_debug = 'Y'
114: THEN
115: ar_invoice_utils.debug('EXCEPTION : find_context()');
116: ar_invoice_utils.debug('p_context : '||p_context);
117: END IF;
118: RAISE;
119: END;

Line 116: ar_invoice_utils.debug('p_context : '||p_context);

112: WHEN OTHERS THEN
113: IF pg_debug = 'Y'
114: THEN
115: ar_invoice_utils.debug('EXCEPTION : find_context()');
116: ar_invoice_utils.debug('p_context : '||p_context);
117: END IF;
118: RAISE;
119: END;
120:

Line 135: ar_invoice_utils.debug('build_where_clause()+');

131:
132: BEGIN
133: IF pg_debug = 'Y'
134: THEN
135: ar_invoice_utils.debug('build_where_clause()+');
136: END IF;
137: l_context := p_context;
138: l_context_index := p_context_index;
139:

Line 187: ar_invoice_utils.debug('AR', 'AR_INV_TRANS_FLEX_CONTEXT');

183: END LOOP;
184: ELSE
185: IF pg_debug = 'Y'
186: THEN
187: ar_invoice_utils.debug('AR', 'AR_INV_TRANS_FLEX_CONTEXT');
188: END IF;
189: app_exception.raise_exception;
190: END IF;
191:

Line 203: ar_invoice_utils.debug('Where clause : '||p_where_clause);

199:
200: END LOOP;
201: IF pg_debug = 'Y'
202: THEN
203: ar_invoice_utils.debug('Where clause : '||p_where_clause);
204: ar_invoice_utils.debug('build_where_clause()-');
205: END IF;
206:
207: EXCEPTION

Line 204: ar_invoice_utils.debug('build_where_clause()-');

200: END LOOP;
201: IF pg_debug = 'Y'
202: THEN
203: ar_invoice_utils.debug('Where clause : '||p_where_clause);
204: ar_invoice_utils.debug('build_where_clause()-');
205: END IF;
206:
207: EXCEPTION
208: WHEN OTHERS THEN

Line 211: ar_invoice_utils.debug('EXCEPTION : build_where_clause');

207: EXCEPTION
208: WHEN OTHERS THEN
209: IF pg_debug = 'Y'
210: THEN
211: ar_invoice_utils.debug('EXCEPTION : build_where_clause');
212: ar_invoice_utils.debug('p_context : '||p_context);
213: END IF;
214: RAISE;
215: END Build_where_clause;

Line 212: ar_invoice_utils.debug('p_context : '||p_context);

208: WHEN OTHERS THEN
209: IF pg_debug = 'Y'
210: THEN
211: ar_invoice_utils.debug('EXCEPTION : build_where_clause');
212: ar_invoice_utils.debug('p_context : '||p_context);
213: END IF;
214: RAISE;
215: END Build_where_clause;
216:

Line 231: ar_invoice_utils.debug('Get_Cursor()+');

227:
228: BEGIN
229: IF pg_debug = 'Y'
230: THEN
231: ar_invoice_utils.debug('Get_Cursor()+');
232: END IF;
233:
234: l_context := pg_flex_contexts( p_context_index );
235:

Line 287: ar_invoice_utils.debug('SQL Stmt : '||l_stmt);

283:
284: END IF;
285: IF pg_debug = 'Y'
286: THEN
287: ar_invoice_utils.debug('SQL Stmt : '||l_stmt);
288: END IF;
289: /*---------------------------------------------------+
290: | Open, Parse and Execute the constructed SQL stmt |
291: +---------------------------------------------------*/

Line 302: ar_invoice_utils.debug('Get_Cursor()-');

298: ELSE pg_ril_cursors( p_context_index ) := l_cursor;
299: END IF;
300: IF pg_debug = 'Y'
301: THEN
302: ar_invoice_utils.debug('Get_Cursor()-');
303: END IF;
304:
305: RETURN(l_cursor);
306:

Line 311: ar_invoice_utils.debug('EXCEPTION : Get_Cursor()');

307: EXCEPTION
308: WHEN OTHERS THEN
309: IF pg_debug = 'Y'
310: THEN
311: ar_invoice_utils.debug('EXCEPTION : Get_Cursor()');
312: ar_invoice_utils.debug('p_context_index = ' || TO_CHAR( p_context_index));
313: ar_invoice_utils.debug('p_table_name = ' || p_table_name);
314: END IF;
315: RAISE;

Line 312: ar_invoice_utils.debug('p_context_index = ' || TO_CHAR( p_context_index));

308: WHEN OTHERS THEN
309: IF pg_debug = 'Y'
310: THEN
311: ar_invoice_utils.debug('EXCEPTION : Get_Cursor()');
312: ar_invoice_utils.debug('p_context_index = ' || TO_CHAR( p_context_index));
313: ar_invoice_utils.debug('p_table_name = ' || p_table_name);
314: END IF;
315: RAISE;
316:

Line 313: ar_invoice_utils.debug('p_table_name = ' || p_table_name);

309: IF pg_debug = 'Y'
310: THEN
311: ar_invoice_utils.debug('EXCEPTION : Get_Cursor()');
312: ar_invoice_utils.debug('p_context_index = ' || TO_CHAR( p_context_index));
313: ar_invoice_utils.debug('p_table_name = ' || p_table_name);
314: END IF;
315: RAISE;
316:
317: END get_cursor;

Line 327: ar_invoice_utils.debug('Bind_Variables()+');

323: ) IS
324: BEGIN
325: IF pg_debug = 'Y'
326: THEN
327: ar_invoice_utils.debug('Bind_Variables()+');
328: END IF;
329: dbms_sql.bind_variable( p_cursor,
330: p_bind_variable,
331: p_value );

Line 334: ar_invoice_utils.debug('Bind_Variables()-');

330: p_bind_variable,
331: p_value );
332: IF pg_debug = 'Y'
333: THEN
334: ar_invoice_utils.debug('Bind_Variables()-');
335: END IF;
336:
337: EXCEPTION
338: WHEN OTHERS THEN

Line 344: ar_invoice_utils.debug('EXCEPTION : Bind_Variable()');

340: THEN NULL;
341: ELSE
342: IF pg_debug = 'Y'
343: THEN
344: ar_invoice_utils.debug('EXCEPTION : Bind_Variable()');
345: ar_invoice_utils.debug('p_cursor = ' || p_cursor);
346: ar_invoice_utils.debug('p_bind_variable = ' || p_bind_variable);
347: ar_invoice_utils.debug('p_value = ' || p_value);
348: END IF;

Line 345: ar_invoice_utils.debug('p_cursor = ' || p_cursor);

341: ELSE
342: IF pg_debug = 'Y'
343: THEN
344: ar_invoice_utils.debug('EXCEPTION : Bind_Variable()');
345: ar_invoice_utils.debug('p_cursor = ' || p_cursor);
346: ar_invoice_utils.debug('p_bind_variable = ' || p_bind_variable);
347: ar_invoice_utils.debug('p_value = ' || p_value);
348: END IF;
349: RAISE;

Line 346: ar_invoice_utils.debug('p_bind_variable = ' || p_bind_variable);

342: IF pg_debug = 'Y'
343: THEN
344: ar_invoice_utils.debug('EXCEPTION : Bind_Variable()');
345: ar_invoice_utils.debug('p_cursor = ' || p_cursor);
346: ar_invoice_utils.debug('p_bind_variable = ' || p_bind_variable);
347: ar_invoice_utils.debug('p_value = ' || p_value);
348: END IF;
349: RAISE;
350: END IF;

Line 347: ar_invoice_utils.debug('p_value = ' || p_value);

343: THEN
344: ar_invoice_utils.debug('EXCEPTION : Bind_Variable()');
345: ar_invoice_utils.debug('p_cursor = ' || p_cursor);
346: ar_invoice_utils.debug('p_bind_variable = ' || p_bind_variable);
347: ar_invoice_utils.debug('p_value = ' || p_value);
348: END IF;
349: RAISE;
350: END IF;
351:

Line 397: ar_invoice_utils.debug('Bind_All_Variables()+');

393: BEGIN
394:
395: IF pg_debug = 'Y'
396: THEN
397: ar_invoice_utils.debug('Bind_All_Variables()+');
398: END IF;
399:
400:
401: /*-------------------------------------------------------+

Line 423: ar_invoice_utils.debug('Handling INVALID_CURSOR exception by reparsing');

419:
420: WHEN INVALID_CURSOR THEN
421: IF pg_debug = 'Y'
422: THEN
423: ar_invoice_utils.debug('Handling INVALID_CURSOR exception by reparsing');
424: END IF;
425:
426: p_ctl_cursor := Get_Cursor(
427: p_context_index,

Line 554: ar_invoice_utils.debug('Handling INVALID_CURSOR exception by reparsing');

550:
551: WHEN INVALID_CURSOR THEN
552: IF pg_debug = 'Y'
553: THEN
554: ar_invoice_utils.debug('Handling INVALID_CURSOR exception by reparsing');
555: END IF;
556:
557: p_ril_cursor := Get_Cursor(
558: p_context_index,

Line 664: ar_invoice_utils.debug('Bind_All_Variables()-');

660: );
661:
662: IF pg_debug = 'Y'
663: THEN
664: ar_invoice_utils.debug('Bind_All_Variables()-');
665: END IF;
666:
667: EXCEPTION
668: WHEN OTHERS THEN

Line 671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');

667: EXCEPTION
668: WHEN OTHERS THEN
669: IF pg_debug = 'Y'
670: THEN
671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');
672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);
673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||

Line 672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);

668: WHEN OTHERS THEN
669: IF pg_debug = 'Y'
670: THEN
671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');
672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);
673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);

Line 673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);

669: IF pg_debug = 'Y'
670: THEN
671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');
672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);
673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);
677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||

Line 674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);

670: THEN
671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');
672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);
673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);
677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||
678: p_interface_line_attribute2);

Line 675: ar_invoice_utils.debug('p_interface_line_context : '||

671: ar_invoice_utils.debug('EXCEPTION : Bind_All_Variables');
672: ar_invoice_utils.debug('p_ctl_cursor : ' || p_ctl_cursor);
673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);
677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||
678: p_interface_line_attribute2);
679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||

Line 677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||

673: ar_invoice_utils.debug('p_ril_cursor : ' || p_ctl_cursor);
674: ar_invoice_utils.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);
677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||
678: p_interface_line_attribute2);
679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||
680: p_interface_line_attribute3);
681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||

Line 679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||

675: ar_invoice_utils.debug('p_interface_line_context : '||
676: p_interface_line_context);
677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||
678: p_interface_line_attribute2);
679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||
680: p_interface_line_attribute3);
681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||
682: p_interface_line_attribute4);
683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||

Line 681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||

677: ar_invoice_utils.debug('p_interface_line_attribute2 : '||
678: p_interface_line_attribute2);
679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||
680: p_interface_line_attribute3);
681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||
682: p_interface_line_attribute4);
683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||
684: p_interface_line_attribute5);
685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||

Line 683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||

679: ar_invoice_utils.debug('p_interface_line_attribute3 : '||
680: p_interface_line_attribute3);
681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||
682: p_interface_line_attribute4);
683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||
684: p_interface_line_attribute5);
685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||
686: p_interface_line_attribute6);
687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||

Line 685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||

681: ar_invoice_utils.debug('p_interface_line_attribute4 : '||
682: p_interface_line_attribute4);
683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||
684: p_interface_line_attribute5);
685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||
686: p_interface_line_attribute6);
687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||
688: p_interface_line_attribute7);
689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||

Line 687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||

683: ar_invoice_utils.debug('p_interface_line_attribute5 : '||
684: p_interface_line_attribute5);
685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||
686: p_interface_line_attribute6);
687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||
688: p_interface_line_attribute7);
689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||
690: p_interface_line_attribute8);
691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||

Line 689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||

685: ar_invoice_utils.debug('p_interface_line_attribute6 : '||
686: p_interface_line_attribute6);
687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||
688: p_interface_line_attribute7);
689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||
690: p_interface_line_attribute8);
691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||
692: p_interface_line_attribute9);
693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||

Line 691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||

687: ar_invoice_utils.debug('p_interface_line_attribute7 : '||
688: p_interface_line_attribute7);
689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||
690: p_interface_line_attribute8);
691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||
692: p_interface_line_attribute9);
693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||
694: p_interface_line_attribute10);
695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||

Line 693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||

689: ar_invoice_utils.debug('p_interface_line_attribute8 : '||
690: p_interface_line_attribute8);
691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||
692: p_interface_line_attribute9);
693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||
694: p_interface_line_attribute10);
695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||
696: p_interface_line_attribute11);
697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||

Line 695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||

691: ar_invoice_utils.debug('p_interface_line_attribute9 : '||
692: p_interface_line_attribute9);
693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||
694: p_interface_line_attribute10);
695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||
696: p_interface_line_attribute11);
697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||
698: p_interface_line_attribute12);
699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||

Line 697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||

693: ar_invoice_utils.debug('p_interface_line_attribute10 : '||
694: p_interface_line_attribute10);
695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||
696: p_interface_line_attribute11);
697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||
698: p_interface_line_attribute12);
699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||
700: p_interface_line_attribute13);
701: ar_invoice_utils.debug('p_interface_line_attribute14 : '||

Line 699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||

695: ar_invoice_utils.debug('p_interface_line_attribute11 : '||
696: p_interface_line_attribute11);
697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||
698: p_interface_line_attribute12);
699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||
700: p_interface_line_attribute13);
701: ar_invoice_utils.debug('p_interface_line_attribute14 : '||
702: p_interface_line_attribute14);
703: ar_invoice_utils.debug('p_interface_line_attribute15 : '||

Line 701: ar_invoice_utils.debug('p_interface_line_attribute14 : '||

697: ar_invoice_utils.debug('p_interface_line_attribute12 : '||
698: p_interface_line_attribute12);
699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||
700: p_interface_line_attribute13);
701: ar_invoice_utils.debug('p_interface_line_attribute14 : '||
702: p_interface_line_attribute14);
703: ar_invoice_utils.debug('p_interface_line_attribute15 : '||
704: p_interface_line_attribute15);
705: END IF;

Line 703: ar_invoice_utils.debug('p_interface_line_attribute15 : '||

699: ar_invoice_utils.debug('p_interface_line_attribute13 : '||
700: p_interface_line_attribute13);
701: ar_invoice_utils.debug('p_interface_line_attribute14 : '||
702: p_interface_line_attribute14);
703: ar_invoice_utils.debug('p_interface_line_attribute15 : '||
704: p_interface_line_attribute15);
705: END IF;
706: RAISE;
707:

Line 728: ar_invoice_utils.debug('check_uniqueness()+');

724: BEGIN
725:
726: IF pg_debug = 'Y'
727: THEN
728: ar_invoice_utils.debug('check_uniqueness()+');
729: END IF;
730:
731: dbms_sql.define_column( p_cursor, 1, l_customer_trx_id);
732: dbms_sql.define_column( p_cursor, 2, l_customer_trx_line_id);

Line 753: ar_invoice_utils.debug('check_uniqueness()-');

749: p_customer_trx_line_id := l_customer_trx_line_id;
750:
751: IF pg_debug = 'Y'
752: THEN
753: ar_invoice_utils.debug('check_uniqueness()-');
754: END IF;
755: return(FALSE);
756: ELSIF ( l_rows > 1 and p_table_name = 'AR_TRX_LINES_GT' )
757: THEN

Line 764: ar_invoice_utils.debug('check_uniqueness for ar_trx_lines_gt()-');

760: p_customer_trx_id := l_customer_trx_id;
761: p_customer_trx_line_id := l_customer_trx_line_id;
762: IF pg_debug = 'Y'
763: THEN
764: ar_invoice_utils.debug('check_uniqueness for ar_trx_lines_gt()-');
765: END IF;
766: return(FALSE);
767: END IF;
768:

Line 771: ar_invoice_utils.debug('check_uniqueness()-');

767: END IF;
768:
769: IF pg_debug = 'Y'
770: THEN
771: ar_invoice_utils.debug('check_uniqueness()-');
772: END IF;
773: return(TRUE);
774:
775: EXCEPTION

Line 779: ar_invoice_utils.debug('EXCEPTION : check_uniqueness()');

775: EXCEPTION
776: WHEN OTHERS THEN
777: IF pg_debug = 'Y'
778: THEN
779: ar_invoice_utils.debug('EXCEPTION : check_uniqueness()');
780: ar_invoice_utils.debug('p_cursor : '|| p_cursor);
781: END IF;
782: IF (p_cursor IS NOT NULL)
783: THEN dbms_sql.close_cursor(p_cursor);

Line 780: ar_invoice_utils.debug('p_cursor : '|| p_cursor);

776: WHEN OTHERS THEN
777: IF pg_debug = 'Y'
778: THEN
779: ar_invoice_utils.debug('EXCEPTION : check_uniqueness()');
780: ar_invoice_utils.debug('p_cursor : '|| p_cursor);
781: END IF;
782: IF (p_cursor IS NOT NULL)
783: THEN dbms_sql.close_cursor(p_cursor);
784: END IF;

Line 810: ar_invoice_utils.debug('unique_trans_flex()+');

806: l_customer_trx_line_id NUMBER;
807: BEGIN
808: IF pg_debug = 'Y'
809: THEN
810: ar_invoice_utils.debug('unique_trans_flex()+');
811: END IF;
812: setup_descr_flex(222, 'RA_INTERFACE_LINES');
813:
814: /*------------------------------------------------+

Line 914: ar_invoice_utils.debug('EXCEPTION : arp_invoice_validate_flex.unique_flex');

910: EXCEPTION
911: WHEN OTHERS THEN
912: IF pg_debug = 'Y'
913: THEN
914: ar_invoice_utils.debug('EXCEPTION : arp_invoice_validate_flex.unique_flex');
915: END IF;
916: RAISE;
917:
918: END unique_flex;

Line 937: ar_invoice_utils.debug('' || 'AR_INVOICE_UTILS.Validate_LINE_Int_Flex ()+');

933: WHERE application_id = 222
934: and descriptive_flexfield_name = p_desc_flex_name;
935: BEGIN
936: IF PG_DEBUG = 'Y' THEN
937: ar_invoice_utils.debug('' || 'AR_INVOICE_UTILS.Validate_LINE_Int_Flex ()+');
938: END IF;
939: p_return_status := FND_API.G_RET_STS_SUCCESS;
940:
941: OPEN desc_flex_exists;

Line 1058: ar_invoice_utils.debug('' || 'AR_INVOICE_UTILS.Validate_Int_Desc_Flex ()+');

1054: WHERE application_id = 222
1055: and descriptive_flexfield_name = p_desc_flex_name;
1056: BEGIN
1057: IF PG_DEBUG = 'Y' THEN
1058: ar_invoice_utils.debug('' || 'AR_INVOICE_UTILS.Validate_Int_Desc_Flex ()+');
1059: END IF;
1060: p_return_status := FND_API.G_RET_STS_SUCCESS;
1061:
1062: OPEN desc_flex_exists;

Line 1351: ar_invoice_utils.debug ('AR_INVOICE_UTILS.validate_hd_desc_flex (+)' );

1347: OR attribute15 IS NOT NULL;
1348: BEGIN
1349: IF pg_debug = 'Y'
1350: THEN
1351: ar_invoice_utils.debug ('AR_INVOICE_UTILS.validate_hd_desc_flex (+)' );
1352: END IF;
1353: x_return_status := FND_API.G_RET_STS_SUCCESS;
1354:
1355: -- call flex validation rtn for all header