186: cln_debug_pub.Add('l_invoice_num :'|| l_invoice_num ,1);
187: END IF;
188:
189: -- raise event to start 3c4 invoice error processing
190: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'CLN', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
187: END IF;
188:
189: -- raise event to start 3c4 invoice error processing
190: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'CLN', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
188:
189: -- raise event to start 3c4 invoice error processing
190: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'CLN', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
189: -- raise event to start 3c4 invoice error processing
190: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'CLN', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
190: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'CLN', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
191: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', 'INV_REJECT_NOTIF_OUT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
192: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', l_party_type, l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
193: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
194: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
195: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_doc_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
196: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
197: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
198: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'CLN_CH_COLLABORATION_CREATED', l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
199: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'CLN_3C4_XML_SENT', l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
200: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'Y', l_raise_3c4_parameters);
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
208:
201: WF_EVENT.AddParameterToList('CH_MESSAGE_NO_TP_SETUP', 'CLN_CH_TP_SETUP_NOTFOUND', l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
208:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
202: WF_EVENT.AddParameterToList('ECX_PARAMETER1', P_invoice_id, l_raise_3c4_parameters);
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
208:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
210: --REFERENCE_ID?
203: WF_EVENT.AddParameterToList('ECX_PARAMETER2', p_reference_id, l_raise_3c4_parameters);
204: WF_EVENT.AddParameterToList('ECX_PARAMETER3', p_error_reject_string, l_raise_3c4_parameters);
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
208:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
210: --REFERENCE_ID?
211: --@@@@ - Add these params
205: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_org_id, l_raise_3c4_parameters);
206: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_invoice_amt, l_raise_3c4_parameters);
207: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_invoice_num, l_raise_3c4_parameters);
208:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
210: --REFERENCE_ID?
211: --@@@@ - Add these params
212: --WF_EVENT.AddParameterToList('INVOICE_DATE', l_invoice_id, l_raise_3c4_parameters);
213: --WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_po_num, l_raise_3c4_parameters);
208:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
210: --REFERENCE_ID?
211: --@@@@ - Add these params
212: --WF_EVENT.AddParameterToList('INVOICE_DATE', l_invoice_id, l_raise_3c4_parameters);
213: --WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_po_num, l_raise_3c4_parameters);
214: --WF_EVENT.Raise('oracle.apps.cln.error.ntfyinvi',l_event_key, NULL, l_raise_3c4_parameters, NULL);
215: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_doc_id, NULL, l_raise_3c4_parameters, NULL);
216:
209: --WF_EVENT.AddParameterToList('CLN_DOCUMENT_NUMBER', l_invoice_num, l_raise_3c4_parameters);
210: --REFERENCE_ID?
211: --@@@@ - Add these params
212: --WF_EVENT.AddParameterToList('INVOICE_DATE', l_invoice_id, l_raise_3c4_parameters);
213: --WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_po_num, l_raise_3c4_parameters);
214: --WF_EVENT.Raise('oracle.apps.cln.error.ntfyinvi',l_event_key, NULL, l_raise_3c4_parameters, NULL);
215: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_doc_id, NULL, l_raise_3c4_parameters, NULL);
216:
217: IF (l_Debug_Level <= 1) THEN
210: --REFERENCE_ID?
211: --@@@@ - Add these params
212: --WF_EVENT.AddParameterToList('INVOICE_DATE', l_invoice_id, l_raise_3c4_parameters);
213: --WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_po_num, l_raise_3c4_parameters);
214: --WF_EVENT.Raise('oracle.apps.cln.error.ntfyinvi',l_event_key, NULL, l_raise_3c4_parameters, NULL);
215: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_doc_id, NULL, l_raise_3c4_parameters, NULL);
216:
217: IF (l_Debug_Level <= 1) THEN
218: cln_debug_pub.Add('---------3c4 event raised ---------', 1);
211: --@@@@ - Add these params
212: --WF_EVENT.AddParameterToList('INVOICE_DATE', l_invoice_id, l_raise_3c4_parameters);
213: --WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_po_num, l_raise_3c4_parameters);
214: --WF_EVENT.Raise('oracle.apps.cln.error.ntfyinvi',l_event_key, NULL, l_raise_3c4_parameters, NULL);
215: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_doc_id, NULL, l_raise_3c4_parameters, NULL);
216:
217: IF (l_Debug_Level <= 1) THEN
218: cln_debug_pub.Add('---------3c4 event raised ---------', 1);
219: END IF;
893: END IF;
894:
895: l_update_cln_parameter_list := wf_parameter_list_t();
896:
897: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_update_cln_parameter_list);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
894:
895: l_update_cln_parameter_list := wf_parameter_list_t();
896:
897: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_update_cln_parameter_list);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
902: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_update_cln_parameter_list);
895: l_update_cln_parameter_list := wf_parameter_list_t();
896:
897: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_update_cln_parameter_list);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
902: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_update_cln_parameter_list);
903:
896:
897: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_update_cln_parameter_list);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
902: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_update_cln_parameter_list);
903:
904: IF (l_Debug_Level <= 1) THEN
897: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_update_cln_parameter_list);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
902: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_update_cln_parameter_list);
903:
904: IF (l_Debug_Level <= 1) THEN
905: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
898: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_3C3_INVOICE_RCVD', l_update_cln_parameter_list);
899: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_update_cln_parameter_list);
900: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_update_cln_parameter_list);--sysdate
901: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_int_cnt_num,l_update_cln_parameter_list);
902: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_update_cln_parameter_list);
903:
904: IF (l_Debug_Level <= 1) THEN
905: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
906: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
905: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
906: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
907: END IF;
908:
909: wf_event.raise(p_event_name => 'oracle.apps.cln.ch.collaboration.update',
910: p_event_key => p_document_id ||'.'|| p_int_cnt_num,
911: p_parameters => l_update_cln_parameter_list);
912:
913:
1029: END IF;
1030:
1031: l_event_key := p_internal_control_number;
1032:
1033: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1030:
1031: l_event_key := p_internal_control_number;
1032:
1033: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1038: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_cln_ch_parameters);
1031: l_event_key := p_internal_control_number;
1032:
1033: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1038: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_cln_ch_parameters);
1039:
1032:
1033: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1038: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_cln_ch_parameters);
1039:
1040: IF (l_Debug_Level <= 1) THEN
1033: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1038: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_cln_ch_parameters);
1039:
1040: IF (l_Debug_Level <= 1) THEN
1041: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);
1034: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
1035: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
1036: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',l_canonical_date,l_cln_ch_parameters);
1037: WF_EVENT.AddParameterToList('DOCUMENT_NO',p_document_id,l_cln_ch_parameters);
1038: WF_EVENT.AddParameterToList('ORG_ID',p_org_id,l_cln_ch_parameters);
1039:
1040: IF (l_Debug_Level <= 1) THEN
1041: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);
1042: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
1041: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);
1042: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
1043: END IF;
1044:
1045: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
1046:
1047: -- this is required for the proper processing in workflow.
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: