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.AP_XML_INVOICE_INBOUND_PKG dependencies on FND_GLOBAL

Line 329: select fnd_global.tab||displayed_field||': '

325: procedure notify_supplier(p_request_id in NUMBER,
326: p_calling_sequence VARCHAR2) as
327:
328: cursor l_invoice_line_number_csr is
329: select fnd_global.tab||displayed_field||': '
330: from ap_lookup_codes
331: where lookup_type = 'XML TOKEN NAME' and
332: lookup_code = 'INVOICE LINE NUMBER';
333:

Line 349: fnd_global.tab||fnd_global.tab||lc.description||

345:
346: cursor l_message_csr(c_request_id in NUMBER,
347: c_vendor_email_address in VARCHAR2) is
348: select h.invoice_id, to_number(null),h.invoice_num, to_number(null),
349: fnd_global.tab||fnd_global.tab||lc.description||
350: decode(r.token_name1, null, null,
351: fnd_global.newline||fnd_global.tab||fnd_global.tab||
352: get_token_display_field(r.token_name1)
353: ||': '||r.token_value1) ||

Line 351: fnd_global.newline||fnd_global.tab||fnd_global.tab||

347: c_vendor_email_address in VARCHAR2) is
348: select h.invoice_id, to_number(null),h.invoice_num, to_number(null),
349: fnd_global.tab||fnd_global.tab||lc.description||
350: decode(r.token_name1, null, null,
351: fnd_global.newline||fnd_global.tab||fnd_global.tab||
352: get_token_display_field(r.token_name1)
353: ||': '||r.token_value1) ||
354: decode(r.token_name2, null, null,
355: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 355: fnd_global.newline||fnd_global.tab||fnd_global.tab||

351: fnd_global.newline||fnd_global.tab||fnd_global.tab||
352: get_token_display_field(r.token_name1)
353: ||': '||r.token_value1) ||
354: decode(r.token_name2, null, null,
355: fnd_global.newline||fnd_global.tab||fnd_global.tab||
356: get_token_display_field(r.token_name2)
357: ||': '||r.token_value2) ||
358: decode(r.token_name3, null, null,
359: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 359: fnd_global.newline||fnd_global.tab||fnd_global.tab||

355: fnd_global.newline||fnd_global.tab||fnd_global.tab||
356: get_token_display_field(r.token_name2)
357: ||': '||r.token_value2) ||
358: decode(r.token_name3, null, null,
359: fnd_global.newline||fnd_global.tab||fnd_global.tab||
360: get_token_display_field(r.token_name3)
361: ||': '||r.token_value3) ||
362: decode(r.token_name4, null, null,
363: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 363: fnd_global.newline||fnd_global.tab||fnd_global.tab||

359: fnd_global.newline||fnd_global.tab||fnd_global.tab||
360: get_token_display_field(r.token_name3)
361: ||': '||r.token_value3) ||
362: decode(r.token_name4, null, null,
363: fnd_global.newline||fnd_global.tab||fnd_global.tab||
364: get_token_display_field(r.token_name4)
365: ||': '||r.token_value4) ||
366: decode(r.token_name5, null, null,
367: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 367: fnd_global.newline||fnd_global.tab||fnd_global.tab||

363: fnd_global.newline||fnd_global.tab||fnd_global.tab||
364: get_token_display_field(r.token_name4)
365: ||': '||r.token_value4) ||
366: decode(r.token_name5, null, null,
367: fnd_global.newline||fnd_global.tab||fnd_global.tab||
368: get_token_display_field(r.token_name5)
369: ||': '||r.token_value5) ||
370: decode(r.token_name6, null, null,
371: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 371: fnd_global.newline||fnd_global.tab||fnd_global.tab||

367: fnd_global.newline||fnd_global.tab||fnd_global.tab||
368: get_token_display_field(r.token_name5)
369: ||': '||r.token_value5) ||
370: decode(r.token_name6, null, null,
371: fnd_global.newline||fnd_global.tab||fnd_global.tab||
372: get_token_display_field(r.token_name6)
373: ||': '||r.token_value6) ||
374: decode(r.token_name7, null, null,
375: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 375: fnd_global.newline||fnd_global.tab||fnd_global.tab||

371: fnd_global.newline||fnd_global.tab||fnd_global.tab||
372: get_token_display_field(r.token_name6)
373: ||': '||r.token_value6) ||
374: decode(r.token_name7, null, null,
375: fnd_global.newline||fnd_global.tab||fnd_global.tab||
376: get_token_display_field(r.token_name7)
377: ||': '||r.token_value7) ||
378: decode(r.token_name8, null, null,
379: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 379: fnd_global.newline||fnd_global.tab||fnd_global.tab||

375: fnd_global.newline||fnd_global.tab||fnd_global.tab||
376: get_token_display_field(r.token_name7)
377: ||': '||r.token_value7) ||
378: decode(r.token_name8, null, null,
379: fnd_global.newline||fnd_global.tab||fnd_global.tab||
380: get_token_display_field(r.token_name8)
381: ||': '||r.token_value8) ||
382: decode(r.token_name9, null, null,
383: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 383: fnd_global.newline||fnd_global.tab||fnd_global.tab||

379: fnd_global.newline||fnd_global.tab||fnd_global.tab||
380: get_token_display_field(r.token_name8)
381: ||': '||r.token_value8) ||
382: decode(r.token_name9, null, null,
383: fnd_global.newline||fnd_global.tab||fnd_global.tab||
384: get_token_display_field(r.token_name9)
385: ||': '||r.token_value9) ||
386: decode(r.token_name10, null, null,
387: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 387: fnd_global.newline||fnd_global.tab||fnd_global.tab||

383: fnd_global.newline||fnd_global.tab||fnd_global.tab||
384: get_token_display_field(r.token_name9)
385: ||': '||r.token_value9) ||
386: decode(r.token_name10, null, null,
387: fnd_global.newline||fnd_global.tab||fnd_global.tab||
388: get_token_display_field(r.token_name10)
389: ||': '||r.token_value10)||
390: fnd_global.newline
391: -- Bug 4065112 starts

Line 390: fnd_global.newline

386: decode(r.token_name10, null, null,
387: fnd_global.newline||fnd_global.tab||fnd_global.tab||
388: get_token_display_field(r.token_name10)
389: ||': '||r.token_value10)||
390: fnd_global.newline
391: -- Bug 4065112 starts
392: ,group_id, external_doc_ref
393: -- Bug 4065112 ends
394:

Line 407: fnd_global.tab||fnd_global.tab||lc.description||

403: and lc.lookup_code = r.reject_lookup_code
404: and lc.lookup_type = 'REJECT CODE'
405: union all
406: select h.invoice_id, l.invoice_line_id,h.invoice_num, l.line_number,
407: fnd_global.tab||fnd_global.tab||lc.description||
408: decode(r.token_name1, null, null,
409: fnd_global.newline||fnd_global.tab||fnd_global.tab||
410: get_token_display_field(r.token_name1)
411: ||': '||r.token_value1) ||

Line 409: fnd_global.newline||fnd_global.tab||fnd_global.tab||

405: union all
406: select h.invoice_id, l.invoice_line_id,h.invoice_num, l.line_number,
407: fnd_global.tab||fnd_global.tab||lc.description||
408: decode(r.token_name1, null, null,
409: fnd_global.newline||fnd_global.tab||fnd_global.tab||
410: get_token_display_field(r.token_name1)
411: ||': '||r.token_value1) ||
412: decode(r.token_name2, null, null,
413: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 413: fnd_global.newline||fnd_global.tab||fnd_global.tab||

409: fnd_global.newline||fnd_global.tab||fnd_global.tab||
410: get_token_display_field(r.token_name1)
411: ||': '||r.token_value1) ||
412: decode(r.token_name2, null, null,
413: fnd_global.newline||fnd_global.tab||fnd_global.tab||
414: get_token_display_field(r.token_name2)
415: ||': '||r.token_value2) ||
416: decode(r.token_name3, null, null,
417: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 417: fnd_global.newline||fnd_global.tab||fnd_global.tab||

413: fnd_global.newline||fnd_global.tab||fnd_global.tab||
414: get_token_display_field(r.token_name2)
415: ||': '||r.token_value2) ||
416: decode(r.token_name3, null, null,
417: fnd_global.newline||fnd_global.tab||fnd_global.tab||
418: get_token_display_field(r.token_name3)
419: ||': '||r.token_value3) ||
420: decode(r.token_name4, null, null,
421: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 421: fnd_global.newline||fnd_global.tab||fnd_global.tab||

417: fnd_global.newline||fnd_global.tab||fnd_global.tab||
418: get_token_display_field(r.token_name3)
419: ||': '||r.token_value3) ||
420: decode(r.token_name4, null, null,
421: fnd_global.newline||fnd_global.tab||fnd_global.tab||
422: get_token_display_field(r.token_name4)
423: ||': '||r.token_value4) ||
424: decode(r.token_name5, null, null,
425: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 425: fnd_global.newline||fnd_global.tab||fnd_global.tab||

421: fnd_global.newline||fnd_global.tab||fnd_global.tab||
422: get_token_display_field(r.token_name4)
423: ||': '||r.token_value4) ||
424: decode(r.token_name5, null, null,
425: fnd_global.newline||fnd_global.tab||fnd_global.tab||
426: get_token_display_field(r.token_name5)
427: ||': '||r.token_value5) ||
428: decode(r.token_name6, null, null,
429: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 429: fnd_global.newline||fnd_global.tab||fnd_global.tab||

425: fnd_global.newline||fnd_global.tab||fnd_global.tab||
426: get_token_display_field(r.token_name5)
427: ||': '||r.token_value5) ||
428: decode(r.token_name6, null, null,
429: fnd_global.newline||fnd_global.tab||fnd_global.tab||
430: get_token_display_field(r.token_name6)
431: ||': '||r.token_value6) ||
432: decode(r.token_name7, null, null,
433: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 433: fnd_global.newline||fnd_global.tab||fnd_global.tab||

429: fnd_global.newline||fnd_global.tab||fnd_global.tab||
430: get_token_display_field(r.token_name6)
431: ||': '||r.token_value6) ||
432: decode(r.token_name7, null, null,
433: fnd_global.newline||fnd_global.tab||fnd_global.tab||
434: get_token_display_field(r.token_name7)
435: ||': '||r.token_value7) ||
436: decode(r.token_name8, null, null,
437: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 437: fnd_global.newline||fnd_global.tab||fnd_global.tab||

433: fnd_global.newline||fnd_global.tab||fnd_global.tab||
434: get_token_display_field(r.token_name7)
435: ||': '||r.token_value7) ||
436: decode(r.token_name8, null, null,
437: fnd_global.newline||fnd_global.tab||fnd_global.tab||
438: get_token_display_field(r.token_name8)
439: ||': '||r.token_value8) ||
440: decode(r.token_name9, null, null,
441: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 441: fnd_global.newline||fnd_global.tab||fnd_global.tab||

437: fnd_global.newline||fnd_global.tab||fnd_global.tab||
438: get_token_display_field(r.token_name8)
439: ||': '||r.token_value8) ||
440: decode(r.token_name9, null, null,
441: fnd_global.newline||fnd_global.tab||fnd_global.tab||
442: get_token_display_field(r.token_name9)
443: ||': '||r.token_value9) ||
444: decode(r.token_name10, null, null,
445: fnd_global.newline||fnd_global.tab||fnd_global.tab||

Line 445: fnd_global.newline||fnd_global.tab||fnd_global.tab||

441: fnd_global.newline||fnd_global.tab||fnd_global.tab||
442: get_token_display_field(r.token_name9)
443: ||': '||r.token_value9) ||
444: decode(r.token_name10, null, null,
445: fnd_global.newline||fnd_global.tab||fnd_global.tab||
446: get_token_display_field(r.token_name10)
447: ||': '||r.token_value10)||
448: fnd_global.newline
449: -- Bug 4065112 starts

Line 448: fnd_global.newline

444: decode(r.token_name10, null, null,
445: fnd_global.newline||fnd_global.tab||fnd_global.tab||
446: get_token_display_field(r.token_name10)
447: ||': '||r.token_value10)||
448: fnd_global.newline
449: -- Bug 4065112 starts
450: ,group_id, external_doc_ref
451: -- Bug 4065112 ends
452: from ap_invoices_interface h,

Line 552: l_message_line := fnd_global.newline||

548: --
549: ap_debug_pkg.print('Y','New Invoice');
550: -- Bug 4065112: add the check condition for '3C4'
551: if ( l_vendor_email_address <> '3C4' ) then
552: l_message_line := fnd_global.newline||
553: l_invoice_number ||l_invoice_number_tmp||
554: fnd_global.newline||l_message_line;
555: end if;
556: end if;

Line 554: fnd_global.newline||l_message_line;

550: -- Bug 4065112: add the check condition for '3C4'
551: if ( l_vendor_email_address <> '3C4' ) then
552: l_message_line := fnd_global.newline||
553: l_invoice_number ||l_invoice_number_tmp||
554: fnd_global.newline||l_message_line;
555: end if;
556: end if;
557: --
558: if (l_invoice_line_id is not null and

Line 567: l_message_line := fnd_global.newline||

563: --
564: ap_debug_pkg.print('Y','New Invoice Line');
565: -- Bug 4065112: add the check condition for '3C4'
566: if ( l_vendor_email_address <> '3C4' ) then
567: l_message_line := fnd_global.newline||
568: l_invoice_number || l_invoice_number_tmp||
569: fnd_global.newline||
570: l_invoice_line_number ||
571: l_invoice_line_number_tmp||

Line 569: fnd_global.newline||

565: -- Bug 4065112: add the check condition for '3C4'
566: if ( l_vendor_email_address <> '3C4' ) then
567: l_message_line := fnd_global.newline||
568: l_invoice_number || l_invoice_number_tmp||
569: fnd_global.newline||
570: l_invoice_line_number ||
571: l_invoice_line_number_tmp||
572: fnd_global.newline||
573: l_message_line;

Line 572: fnd_global.newline||

568: l_invoice_number || l_invoice_number_tmp||
569: fnd_global.newline||
570: l_invoice_line_number ||
571: l_invoice_line_number_tmp||
572: fnd_global.newline||
573: l_message_line;
574: end if;
575:
576: end if;

Line 760: where request_id = FND_GLOBAL.CONC_REQUEST_ID;

756:
757: cursor parent_req is
758: select PRIORITY_REQUEST_ID
759: from fnd_concurrent_requests
760: where request_id = FND_GLOBAL.CONC_REQUEST_ID;
761:
762: l_priority_request_id number;
763:
764: cursor req_set is

Line 765: select fnd_global.tab||PROGRAM ||' with Request ID: '||

761:
762: l_priority_request_id number;
763:
764: cursor req_set is
765: select fnd_global.tab||PROGRAM ||' with Request ID: '||
766: to_char(request_id)||fnd_global.newline
767: from fnd_conc_req_summary_v
768: where priority_request_id = l_priority_request_id
769: order by request_id;

Line 766: to_char(request_id)||fnd_global.newline

762: l_priority_request_id number;
763:
764: cursor req_set is
765: select fnd_global.tab||PROGRAM ||' with Request ID: '||
766: to_char(request_id)||fnd_global.newline
767: from fnd_conc_req_summary_v
768: where priority_request_id = l_priority_request_id
769: order by request_id;
770:

Line 796: fnd_global.newline||fnd_global.newline||

792: close req_set;
793:
794: if l_requests is not null then
795: l_requests := 'The following requests are submitted:'||
796: fnd_global.newline||fnd_global.newline||
797: l_requests||fnd_global.newline||
798: 'Please check the result for each request.';
799:
800: ap_debug_pkg.print('Y','l_requests:'||l_requests);

Line 797: l_requests||fnd_global.newline||

793:
794: if l_requests is not null then
795: l_requests := 'The following requests are submitted:'||
796: fnd_global.newline||fnd_global.newline||
797: l_requests||fnd_global.newline||
798: 'Please check the result for each request.';
799:
800: ap_debug_pkg.print('Y','l_requests:'||l_requests);
801: ap_debug_pkg.print('Y','sending email +');