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 AP_DEBUG_PKG

Line 29: ap_debug_pkg.print('Y',

25: +===========================================================================*/
26: procedure correct_freight_line(p_invoice_id in NUMBER) as
27:
28: begin
29: ap_debug_pkg.print('Y',
30: 'AP_XML_INVOICE_INBOUND_PKG.correct_freight_line(+)');
31:
32: update ap_invoice_lines_interface
33: set DIST_CODE_COMBINATION_ID =

Line 40: ap_debug_pkg.print('Y',

36: where sys.org_id = h.org_id and h.invoice_id = p_invoice_id)
37: where line_type_lookup_code = 'FREIGHT' and
38: invoice_id = p_invoice_id;
39:
40: ap_debug_pkg.print('Y',
41: 'AP_XML_INVOICE_INBOUND_PKG.correct_freight)lihe(-)');
42: end;
43:
44:

Line 53: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND.correct_line_type(+)');

49: | DESCRIPTION |
50: +===========================================================================*/
51: procedure correct_line_type(p_invoice_id in number) as
52: begin
53: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND.correct_line_type(+)');
54: --
55: UPDATE AP_INVOICE_LINES_INTERFACE
56: SET LINE_TYPE_LOOKUP_CODE = 'MISCELLANEOUS'
57: WHERE LINE_TYPE_LOOKUP_CODE NOT IN ('ITEM', 'TAX', 'FREIGHT') and

Line 60: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND.correct_line_type(-)');

56: SET LINE_TYPE_LOOKUP_CODE = 'MISCELLANEOUS'
57: WHERE LINE_TYPE_LOOKUP_CODE NOT IN ('ITEM', 'TAX', 'FREIGHT') and
58: INVOICE_ID = p_invoice_id;
59: --
60: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND.correct_line_type(-)');
61: end;
62:
63:
64: /*===========================================================================+

Line 77: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.change_case(+)');

73: p_out_string out NOCOPY VARCHAR2,
74: p_direction in VARCHAR2 default 'U') as
75:
76: begin
77: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.change_case(+)');
78:
79: if p_direction = 'U' then
80: p_out_string := upper(p_in_string);
81: elsif p_direction = 'L' then

Line 87: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.change_case(-)');

83: else
84: null;
85: end if;
86:
87: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.change_case(-)');
88: end;
89:
90: /*===========================================================================+
91: | PROCEDURE |

Line 101: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_org_id(+)');

97: procedure derive_org_id(p_po_number in VARCHAR2 default NULL,
98: p_org_id out NOCOPY NUMBER) as
99: l_org_id NUMBER;
100: begin
101: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_org_id(+)');
102: begin
103: select distinct org_id into l_org_id
104: from po_headers_all
105: where segment1 = p_po_number;

Line 108: ap_debug_pkg.print('Y',

104: from po_headers_all
105: where segment1 = p_po_number;
106: exception
107: when others then
108: ap_debug_pkg.print('Y',
109: 'AP_XML_INVOICE_INBOUND_PKG.derive_org_id(EXCEPTION)');
110: l_org_id := NULL;
111: end;
112: p_org_id := l_org_id;

Line 113: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_org_id(-)');

109: 'AP_XML_INVOICE_INBOUND_PKG.derive_org_id(EXCEPTION)');
110: l_org_id := NULL;
111: end;
112: p_org_id := l_org_id;
113: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_org_id(-)');
114: end;
115:
116: /*===========================================================================+
117: | PROCEDURE |

Line 127: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(+)');

123: procedure derive_vendor_id(p_vendor_site_id in NUMBER,
124: p_org_id in NUMBER,
125: p_vendor_id out NOCOPY NUMBER) as
126: begin
127: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(+)');
128: select vendor_id into p_vendor_id
129: from po_vendor_sites_all
130: where org_id = p_org_id and vendor_site_id = p_vendor_site_id;
131: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(-)');

Line 131: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(-)');

127: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(+)');
128: select vendor_id into p_vendor_id
129: from po_vendor_sites_all
130: where org_id = p_org_id and vendor_site_id = p_vendor_site_id;
131: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(-)');
132: exception
133: when others then
134: ap_debug_pkg.print('Y',
135: 'AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(EXCEPTION)');

Line 134: ap_debug_pkg.print('Y',

130: where org_id = p_org_id and vendor_site_id = p_vendor_site_id;
131: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(-)');
132: exception
133: when others then
134: ap_debug_pkg.print('Y',
135: 'AP_XML_INVOICE_INBOUND_PKG.derive_vendor_id(EXCEPTION)');
136: p_vendor_id := NULL;
137: end;
138: /*===========================================================================+

Line 154: ap_debug_pkg.print('Y',

150: l_party_type varchar2(1) := 'S';
151:
152:
153: begin
154: ap_debug_pkg.print('Y',
155: 'AP_XML_INVOICE_INBOUND_PKG.derive_email_address(+)');
156:
157: /* Bug 2079388
158: Replace the sql below with dynamic sql to prevent dependency on XML

Line 167: ap_debug_pkg.print('Y',

163: from ecx_tp_headers
164: where party_type = 'S' and
165: party_site_id = p_vendor_site_id and
166: party_id = p_vendor_id;
167: ap_debug_pkg.print('Y',
168: 'AP_XML_INVOICE_INBOUND_PKG.derive_email_address(-)');
169:
170: */
171: l_statement :=

Line 185: ap_debug_pkg.print('Y',

181:
182:
183: exception
184: when others then
185: ap_debug_pkg.print('Y',
186: 'AP_XML_INVOICE_INBOUND_PKG.derive_email_address(EXCEPTION)');
187: p_email_address := NULL;
188: end;
189:

Line 213: ap_debug_pkg.print('Y',

209: h.status is NULL and
210: h.vendor_name is NOT NULL;
211:
212: begin
213: ap_debug_pkg.print('Y',
214: 'AP_XML_INVOICE_INBOUND_PKG.start_open_interface(+)');
215:
216: open inv_csr;
217: fetch inv_csr bulk collect into l_inv_ids, l_vendor_ids;

Line 253: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.start_open_interface(-)');

249: sub_request=>FALSE,
250: argument1=>'XML GATEWAY');
251: arp_util_tax.debug('Request_id:'||l_request_id);
252: */
253: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.start_open_interface(-)');
254: end;
255:
256:
257: procedure send_email(p_mail_subject in VARCHAR2,

Line 266: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(+)');

262: l_display_role_name VARCHAR2(100);
263: l_item_key VARCHAR2(100);
264:
265: begin
266: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(+)');
267: arp_util_tax.debug('Creating adhoc role(+)');
268: l_role := null;
269: l_display_role_name := null;
270: WF_DIRECTORY.createAdhocRole(role_name => l_role,

Line 274: ap_debug_pkg.print('Y','Creating adhoc role(-)');

270: WF_DIRECTORY.createAdhocRole(role_name => l_role,
271: role_display_name => l_display_role_name,
272: email_address => p_mail_address,
273: notification_preference => 'MAILTEXT');
274: ap_debug_pkg.print('Y','Creating adhoc role(-)');
275: --
276: -- Creating a workflow process
277: --
278: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;

Line 279: ap_debug_pkg.print('Y','Creating a workflow process(+)');

275: --
276: -- Creating a workflow process
277: --
278: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;
279: ap_debug_pkg.print('Y','Creating a workflow process(+)');
280: WF_ENGINE.createProcess('P2P',l_item_key, 'PROCESS_FOR_NOTIFICATION');
281:
282: ap_debug_pkg.print('Y','Creating a workflow process(-)');
283: --

Line 282: ap_debug_pkg.print('Y','Creating a workflow process(-)');

278: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;
279: ap_debug_pkg.print('Y','Creating a workflow process(+)');
280: WF_ENGINE.createProcess('P2P',l_item_key, 'PROCESS_FOR_NOTIFICATION');
281:
282: ap_debug_pkg.print('Y','Creating a workflow process(-)');
283: --
284: -- Initializing attributes
285: --
286: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');

Line 286: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');

282: ap_debug_pkg.print('Y','Creating a workflow process(-)');
283: --
284: -- Initializing attributes
285: --
286: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');
287: ap_debug_pkg.print('Y','subject:'||p_mail_subject);
288:
289: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',p_mail_subject);
290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');

Line 287: ap_debug_pkg.print('Y','subject:'||p_mail_subject);

283: --
284: -- Initializing attributes
285: --
286: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');
287: ap_debug_pkg.print('Y','subject:'||p_mail_subject);
288:
289: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',p_mail_subject);
290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
291:

Line 290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');

286: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');
287: ap_debug_pkg.print('Y','subject:'||p_mail_subject);
288:
289: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',p_mail_subject);
290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
291:
292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
293: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',NULL);
294: ap_debug_pkg.print('Y','Initializing Mail Header (-)');

Line 292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');

288:
289: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',p_mail_subject);
290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
291:
292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
293: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',NULL);
294: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
295:
296: ap_debug_pkg.print('Y','Initializing Mail Content (+)');

Line 294: ap_debug_pkg.print('Y','Initializing Mail Header (-)');

290: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
291:
292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
293: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',NULL);
294: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
295:
296: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
297: WF_ENGINE.setItemAttrText('P2P',
298: l_item_key,'MAIL_CONTENT1', p_mail_content);

Line 296: ap_debug_pkg.print('Y','Initializing Mail Content (+)');

292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
293: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',NULL);
294: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
295:
296: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
297: WF_ENGINE.setItemAttrText('P2P',
298: l_item_key,'MAIL_CONTENT1', p_mail_content);
299:
300: ap_debug_pkg.print('Y','Initializing Mail Content (-)');

Line 300: ap_debug_pkg.print('Y','Initializing Mail Content (-)');

296: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
297: WF_ENGINE.setItemAttrText('P2P',
298: l_item_key,'MAIL_CONTENT1', p_mail_content);
299:
300: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
301:
302: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
303: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
304: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');

Line 302: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');

298: l_item_key,'MAIL_CONTENT1', p_mail_content);
299:
300: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
301:
302: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
303: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
304: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');
305:
306: --

Line 304: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');

300: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
301:
302: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
303: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
304: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');
305:
306: --
307: -- Starting the process
308: --

Line 309: ap_debug_pkg.print('Y','Starting the process(+)');

305:
306: --
307: -- Starting the process
308: --
309: ap_debug_pkg.print('Y','Starting the process(+)');
310: WF_ENGINE.startProcess('P2P', l_item_key);
311: ap_debug_pkg.print('Y','Starting the process(-)');
312: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(-)');
313:

Line 311: ap_debug_pkg.print('Y','Starting the process(-)');

307: -- Starting the process
308: --
309: ap_debug_pkg.print('Y','Starting the process(+)');
310: WF_ENGINE.startProcess('P2P', l_item_key);
311: ap_debug_pkg.print('Y','Starting the process(-)');
312: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(-)');
313:
314: commit;
315: end;

Line 312: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(-)');

308: --
309: ap_debug_pkg.print('Y','Starting the process(+)');
310: WF_ENGINE.startProcess('P2P', l_item_key);
311: ap_debug_pkg.print('Y','Starting the process(-)');
312: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.send_email(-)');
313:
314: commit;
315: end;
316:

Line 509: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(+)');

505: l_call_3c4_invoice_id ap_invoices_interface.invoice_id%TYPE;
506: -- Bug 4065112 ends
507:
508: begin
509: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(+)');
510: ap_debug_pkg.print('Y','request_id: '||to_char(p_request_id));
511: --
512: open l_invoice_number_csr;
513: fetch l_invoice_number_csr into l_invoice_number;

Line 510: ap_debug_pkg.print('Y','request_id: '||to_char(p_request_id));

506: -- Bug 4065112 ends
507:
508: begin
509: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(+)');
510: ap_debug_pkg.print('Y','request_id: '||to_char(p_request_id));
511: --
512: open l_invoice_number_csr;
513: fetch l_invoice_number_csr into l_invoice_number;
514: close l_invoice_number_csr;

Line 526: ap_debug_pkg.print('Y','distinct email:'||l_vendor_email_address);

522: open l_email_csr(p_request_id);
523: loop
524: fetch l_email_csr into l_vendor_email_address;
525: exit when l_email_csr%notfound;
526: ap_debug_pkg.print('Y','distinct email:'||l_vendor_email_address);
527: --
528: open l_message_csr(p_request_id, l_vendor_email_address);
529: loop
530: fetch l_message_csr into l_invoice_id, l_invoice_line_id,

Line 538: ap_debug_pkg.print('Y','invoice_num:'||l_invoice_number_tmp);

534: --Bug 4065112 ends
535:
536: exit when l_message_csr%notfound;
537: --
538: ap_debug_pkg.print('Y','invoice_num:'||l_invoice_number_tmp);
539: --
540: -- SQL is ordered by invoice_id and invoice_line_id
541: --
542: if (l_invoice_line_id is null and

Line 549: ap_debug_pkg.print('Y','New Invoice');

545: l_prev_invoice_id := l_invoice_id;
546: l_prev_invoice_line_id := NULL;
547: l_invoice_id_table(l_invoice_index) := l_invoice_id;
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||

Line 564: ap_debug_pkg.print('Y','New Invoice Line');

560: l_invoice_line_index := l_invoice_line_index + 1;
561: l_prev_invoice_line_id := l_invoice_line_id;
562: l_invoice_line_id_table(l_invoice_line_index) := l_invoice_line_id;
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||

Line 579: ap_debug_pkg.print('Y','invoice_id:'||to_char(l_invoice_id));

575:
576: end if;
577: --
578: --
579: ap_debug_pkg.print('Y','invoice_id:'||to_char(l_invoice_id));
580: ap_debug_pkg.print('Y','invoice_line_id:'||to_char(l_invoice_line_id));
581: -- Bug 4065112: add the check condition for '3C4'
582: if ( l_vendor_email_address <> '3C4' ) then
583: ap_debug_pkg.print('Y','Email prepared for sending main notification');

Line 580: ap_debug_pkg.print('Y','invoice_line_id:'||to_char(l_invoice_line_id));

576: end if;
577: --
578: --
579: ap_debug_pkg.print('Y','invoice_id:'||to_char(l_invoice_id));
580: ap_debug_pkg.print('Y','invoice_line_id:'||to_char(l_invoice_line_id));
581: -- Bug 4065112: add the check condition for '3C4'
582: if ( l_vendor_email_address <> '3C4' ) then
583: ap_debug_pkg.print('Y','Email prepared for sending main notification');
584:

Line 583: ap_debug_pkg.print('Y','Email prepared for sending main notification');

579: ap_debug_pkg.print('Y','invoice_id:'||to_char(l_invoice_id));
580: ap_debug_pkg.print('Y','invoice_line_id:'||to_char(l_invoice_line_id));
581: -- Bug 4065112: add the check condition for '3C4'
582: if ( l_vendor_email_address <> '3C4' ) then
583: ap_debug_pkg.print('Y','Email prepared for sending main notification');
584:
585:
586: if ( lengthb(l_message||l_message_line) > 32000) then
587: l_index := l_index + 1;

Line 598: ap_debug_pkg.print('Y','Calling API to generate reject xml message for 3C4');

594: end if;
595: else
596: -- Bug 4065112 starts
597: if ( nvl(l_call_3c4_invoice_id, 0 ) <> nvl( l_invoice_id, 0)) then
598: ap_debug_pkg.print('Y','Calling API to generate reject xml message for 3C4');
599: CLN_3C3_AP_TRIGGER_PKG.TRIGGER_REJECTION(l_invoice_id,
600: l_group_id,
601: p_request_id,
602: l_external_doc_ref);

Line 639: ap_debug_pkg.print('Y','index:'||to_char(i));

635: ---
636: -- Now start Workflow process for each element of the table
637: --
638: for i in 1..nvl(l_email_and_message_table.last, 0) loop
639: ap_debug_pkg.print('Y','index:'||to_char(i));
640: ap_debug_pkg.print('Y',
641: 'size of message:'||lengthb(l_email_and_message_table(i).message));
642: ap_debug_pkg.print('Y',
643: 'email:'||l_email_and_message_table(i).vendor_email_address);

Line 640: ap_debug_pkg.print('Y',

636: -- Now start Workflow process for each element of the table
637: --
638: for i in 1..nvl(l_email_and_message_table.last, 0) loop
639: ap_debug_pkg.print('Y','index:'||to_char(i));
640: ap_debug_pkg.print('Y',
641: 'size of message:'||lengthb(l_email_and_message_table(i).message));
642: ap_debug_pkg.print('Y',
643: 'email:'||l_email_and_message_table(i).vendor_email_address);
644: ap_debug_pkg.print('Y',

Line 642: ap_debug_pkg.print('Y',

638: for i in 1..nvl(l_email_and_message_table.last, 0) loop
639: ap_debug_pkg.print('Y','index:'||to_char(i));
640: ap_debug_pkg.print('Y',
641: 'size of message:'||lengthb(l_email_and_message_table(i).message));
642: ap_debug_pkg.print('Y',
643: 'email:'||l_email_and_message_table(i).vendor_email_address);
644: ap_debug_pkg.print('Y',
645: l_email_and_message_table(i).message);
646: --

Line 644: ap_debug_pkg.print('Y',

640: ap_debug_pkg.print('Y',
641: 'size of message:'||lengthb(l_email_and_message_table(i).message));
642: ap_debug_pkg.print('Y',
643: 'email:'||l_email_and_message_table(i).vendor_email_address);
644: ap_debug_pkg.print('Y',
645: l_email_and_message_table(i).message);
646: --
647: l_message_table(1) := substrb(l_email_and_message_table(i).message,
648: 1, 4000);

Line 666: ap_debug_pkg.print('Y','Creating adhoc role(+)');

662: 28001, 4000);
663: --
664: -- Create an Adhoc role
665: --
666: ap_debug_pkg.print('Y','Creating adhoc role(+)');
667: l_role := null;
668: l_display_role_name := null;
669: WF_DIRECTORY.createAdhocRole(role_name => l_role,
670: role_display_name => l_display_role_name,

Line 674: ap_debug_pkg.print('Y','Creating adhoc role(-)');

670: role_display_name => l_display_role_name,
671: email_address =>
672: l_email_and_message_table(i).vendor_email_address,
673: notification_preference => 'MAILTEXT');
674: ap_debug_pkg.print('Y','Creating adhoc role(-)');
675: --
676: -- Creating a workflow process
677: --
678: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;

Line 679: ap_debug_pkg.print('Y','Creating a workflow process(+)');

675: --
676: -- Creating a workflow process
677: --
678: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;
679: ap_debug_pkg.print('Y','Creating a workflow process(+)');
680: WF_ENGINE.createProcess('P2P',l_item_key,
681: 'PROCESS_FOR_NOTIFICATION');
682:
683: ap_debug_pkg.print('Y','Creating a workflow process(-)');

Line 683: ap_debug_pkg.print('Y','Creating a workflow process(-)');

679: ap_debug_pkg.print('Y','Creating a workflow process(+)');
680: WF_ENGINE.createProcess('P2P',l_item_key,
681: 'PROCESS_FOR_NOTIFICATION');
682:
683: ap_debug_pkg.print('Y','Creating a workflow process(-)');
684: --
685: -- Initializing attributes
686: --
687: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');

Line 687: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');

683: ap_debug_pkg.print('Y','Creating a workflow process(-)');
684: --
685: -- Initializing attributes
686: --
687: ap_debug_pkg.print('Y','Initializing Mail Subject (+)');
688: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_SUBJ');
689: l_temp_string := FND_MESSAGE.GET;
690:
691: select NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ',

Line 701: ap_debug_pkg.print('Y','subject:'||l_temp_string);

697: l_temp_string := l_temp_string ||
698: '('||mo_utils.get_ledger_name(l_org_id) ||')';
699: end if;
700:
701: ap_debug_pkg.print('Y','subject:'||l_temp_string);
702: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',l_temp_string);
703: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
704:
705: ap_debug_pkg.print('Y','Initializing Mail Header (+)');

Line 703: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');

699: end if;
700:
701: ap_debug_pkg.print('Y','subject:'||l_temp_string);
702: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',l_temp_string);
703: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
704:
705: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
706: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
707: l_temp_string := FND_MESSAGE.GET;

Line 705: ap_debug_pkg.print('Y','Initializing Mail Header (+)');

701: ap_debug_pkg.print('Y','subject:'||l_temp_string);
702: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',l_temp_string);
703: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
704:
705: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
706: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
707: l_temp_string := FND_MESSAGE.GET;
708: ap_debug_pkg.print('Y','mail header:'||l_temp_string);
709: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',l_temp_string);

Line 708: ap_debug_pkg.print('Y','mail header:'||l_temp_string);

704:
705: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
706: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
707: l_temp_string := FND_MESSAGE.GET;
708: ap_debug_pkg.print('Y','mail header:'||l_temp_string);
709: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',l_temp_string);
710: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
711:
712: for j in 1..8 loop

Line 710: ap_debug_pkg.print('Y','Initializing Mail Header (-)');

706: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
707: l_temp_string := FND_MESSAGE.GET;
708: ap_debug_pkg.print('Y','mail header:'||l_temp_string);
709: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',l_temp_string);
710: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
711:
712: for j in 1..8 loop
713: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
714: WF_ENGINE.setItemAttrText('P2P',l_item_key,'MAIL_CONTENT'||

Line 713: ap_debug_pkg.print('Y','Initializing Mail Content (+)');

709: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',l_temp_string);
710: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
711:
712: for j in 1..8 loop
713: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
714: WF_ENGINE.setItemAttrText('P2P',l_item_key,'MAIL_CONTENT'||
715: to_char(j),l_message_table(j));
716: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
717: end loop;

Line 716: ap_debug_pkg.print('Y','Initializing Mail Content (-)');

712: for j in 1..8 loop
713: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
714: WF_ENGINE.setItemAttrText('P2P',l_item_key,'MAIL_CONTENT'||
715: to_char(j),l_message_table(j));
716: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
717: end loop;
718:
719: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
720: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);

Line 719: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');

715: to_char(j),l_message_table(j));
716: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
717: end loop;
718:
719: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
720: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
721: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');
722:
723: --

Line 721: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');

717: end loop;
718:
719: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
720: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
721: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');
722:
723: --
724: -- Starting the process
725: --

Line 726: ap_debug_pkg.print('Y','Starting the process(+)');

722:
723: --
724: -- Starting the process
725: --
726: ap_debug_pkg.print('Y','Starting the process(+)');
727: WF_ENGINE.startProcess('P2P', l_item_key);
728: ap_debug_pkg.print('Y','Starting the process(-)');
729: end loop;
730: --

Line 728: ap_debug_pkg.print('Y','Starting the process(-)');

724: -- Starting the process
725: --
726: ap_debug_pkg.print('Y','Starting the process(+)');
727: WF_ENGINE.startProcess('P2P', l_item_key);
728: ap_debug_pkg.print('Y','Starting the process(-)');
729: end loop;
730: --
731: --
732: ap_debug_pkg.print('Y','Deleting from the interfaces(+)');

Line 732: ap_debug_pkg.print('Y','Deleting from the interfaces(+)');

728: ap_debug_pkg.print('Y','Starting the process(-)');
729: end loop;
730: --
731: --
732: ap_debug_pkg.print('Y','Deleting from the interfaces(+)');
733: ap_debug_pkg.print('Y','# of element in l_invoice_id_table:'||
734: to_char(nvl(l_invoice_id_table.last,0)));
735: ap_debug_pkg.print('Y','# of element in l_invoice_line_id_table:'||
736: to_char(nvl(l_invoice_line_id_table.last,0)));

Line 733: ap_debug_pkg.print('Y','# of element in l_invoice_id_table:'||

729: end loop;
730: --
731: --
732: ap_debug_pkg.print('Y','Deleting from the interfaces(+)');
733: ap_debug_pkg.print('Y','# of element in l_invoice_id_table:'||
734: to_char(nvl(l_invoice_id_table.last,0)));
735: ap_debug_pkg.print('Y','# of element in l_invoice_line_id_table:'||
736: to_char(nvl(l_invoice_line_id_table.last,0)));
737: l_result := ap_utilities_pkg.delete_invoice_from_interface(

Line 735: ap_debug_pkg.print('Y','# of element in l_invoice_line_id_table:'||

731: --
732: ap_debug_pkg.print('Y','Deleting from the interfaces(+)');
733: ap_debug_pkg.print('Y','# of element in l_invoice_id_table:'||
734: to_char(nvl(l_invoice_id_table.last,0)));
735: ap_debug_pkg.print('Y','# of element in l_invoice_line_id_table:'||
736: to_char(nvl(l_invoice_line_id_table.last,0)));
737: l_result := ap_utilities_pkg.delete_invoice_from_interface(
738: l_invoice_id_table,
739: l_invoice_line_id_table,

Line 741: ap_debug_pkg.print('Y','Deleting from the interfaces(-)');

737: l_result := ap_utilities_pkg.delete_invoice_from_interface(
738: l_invoice_id_table,
739: l_invoice_line_id_table,
740: 'AP_XML_INVOICE_INBOUND_PKG.notify_supplier');
741: ap_debug_pkg.print('Y','Deleting from the interfaces(-)');
742: --
743: --
744: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(-)');
745: end;

Line 744: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(-)');

740: 'AP_XML_INVOICE_INBOUND_PKG.notify_supplier');
741: ap_debug_pkg.print('Y','Deleting from the interfaces(-)');
742: --
743: --
744: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(-)');
745: end;
746:
747: /*===========================================================================+
748: | PROCEDURE |

Line 776: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_recipient(+)');

772: l_requests varchar2(3000);
773: l_email_address varchar2(200);
774:
775: begin
776: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_recipient(+)');
777: fnd_profile.get('AP_NOTIFICATION_EMAIL', l_email_address);
778: ap_debug_pkg.print('Y','email address: '||l_email_address);
779:
780: open parent_req;

Line 778: ap_debug_pkg.print('Y','email address: '||l_email_address);

774:
775: begin
776: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_recipient(+)');
777: fnd_profile.get('AP_NOTIFICATION_EMAIL', l_email_address);
778: ap_debug_pkg.print('Y','email address: '||l_email_address);
779:
780: open parent_req;
781: fetch parent_req into l_priority_request_id;
782: close parent_req;

Line 800: ap_debug_pkg.print('Y','l_requests:'||l_requests);

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 +');
802: send_email('P2P Inbound Process Request Set has been submitted',
803: l_requests,
804: l_email_address);

Line 801: ap_debug_pkg.print('Y','sending email +');

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 +');
802: send_email('P2P Inbound Process Request Set has been submitted',
803: l_requests,
804: l_email_address);
805: ap_debug_pkg.print('Y','sending email -');

Line 805: ap_debug_pkg.print('Y','sending email -');

801: ap_debug_pkg.print('Y','sending email +');
802: send_email('P2P Inbound Process Request Set has been submitted',
803: l_requests,
804: l_email_address);
805: ap_debug_pkg.print('Y','sending email -');
806: end if;
807:
808: p_return_code := '0';
809: ap_debug_pkg.print('Y','ap_xml_invoice_inbound_pkg.notify_recipient(-)');

Line 809: ap_debug_pkg.print('Y','ap_xml_invoice_inbound_pkg.notify_recipient(-)');

805: ap_debug_pkg.print('Y','sending email -');
806: end if;
807:
808: p_return_code := '0';
809: ap_debug_pkg.print('Y','ap_xml_invoice_inbound_pkg.notify_recipient(-)');
810: exception
811: when others then
812: ap_debug_pkg.print('Y',
813: 'ap_xml_invoice_inbound_pkg.notify_recipient EXCEPTION(-)');

Line 812: ap_debug_pkg.print('Y',

808: p_return_code := '0';
809: ap_debug_pkg.print('Y','ap_xml_invoice_inbound_pkg.notify_recipient(-)');
810: exception
811: when others then
812: ap_debug_pkg.print('Y',
813: 'ap_xml_invoice_inbound_pkg.notify_recipient EXCEPTION(-)');
814: p_return_code := '2';
815:
816: end notify_recipient;

Line 906: ap_debug_pkg.print('Y',

902: WHERE GROUP_ID = p_group_id
903: AND SOURCE = 'XML GATEWAY';
904:
905: begin
906: ap_debug_pkg.print('Y',
907: 'AP_XML_INVOICE_INBOUND_PKG.correct_charge_ccid(+)');
908:
909: open org_csr;
910: loop

Line 957: ap_debug_pkg.print('Y',

953:
954: end loop; -- finish looping through org_id
955: close org_csr;
956:
957: ap_debug_pkg.print('Y',
958: 'AP_XML_INVOICE_INBOUND_PKG.correct_charge_ccid(-)');
959: end correct_charge_ccid;
960:
961: /*===========================================================================+