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: --
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:
292: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
293: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',NULL);
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 (+)');
297: WF_ENGINE.setItemAttrText('P2P',
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 (-)');
301:
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: --
307: -- Starting the process
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:
314: commit;
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(-)');
684: --
700: -- '('||mo_utils.get_ledger_name(l_org_id) ||')';
701: -- end if;
702:
703: ap_debug_pkg.print('Y','subject:'||l_temp_string);
704: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_SUBJECT',l_temp_string);
705: ap_debug_pkg.print('Y','Initializing Mail Subject (-)');
706:
707: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
708: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
707: ap_debug_pkg.print('Y','Initializing Mail Header (+)');
708: FND_MESSAGE.SET_NAME('SQLAP', 'AP_XML_WF_SUPPLIER_EMAIL_CONT');
709: l_temp_string := FND_MESSAGE.GET;
710: ap_debug_pkg.print('Y','mail header:'||l_temp_string);
711: WF_ENGINE.setItemAttrText('P2P',l_item_key, 'MAIL_HEADER',l_temp_string);
712: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
713:
714: for j in 1..8 loop
715: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
712: ap_debug_pkg.print('Y','Initializing Mail Header (-)');
713:
714: for j in 1..8 loop
715: ap_debug_pkg.print('Y','Initializing Mail Content (+)');
716: WF_ENGINE.setItemAttrText('P2P',l_item_key,'MAIL_CONTENT'||
717: to_char(j),l_message_table(j));
718: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
719: end loop;
720:
718: ap_debug_pkg.print('Y','Initializing Mail Content (-)');
719: end loop;
720:
721: ap_debug_pkg.print('Y','Initializing Adhoc Role(+)');
722: WF_ENGINE.setItemAttrText('P2P',l_item_key,'ADHOC_ROLE',l_role);
723: ap_debug_pkg.print('Y','Initializing Adhoc Role(-)');
724:
725: --
726: -- Starting the process
725: --
726: -- Starting the process
727: --
728: ap_debug_pkg.print('Y','Starting the process(+)');
729: WF_ENGINE.startProcess('P2P', l_item_key);
730: ap_debug_pkg.print('Y','Starting the process(-)');
731: end loop;
732: --
733: --