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.M4R_7B5_OSFM_PKG dependencies on WF_EVENT

Line 743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);

739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;
742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);

Line 744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);

740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;
742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);

Line 745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);

741: END IF;
742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);

Line 746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);

742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);

Line 747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);

743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);

Line 748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);

744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);
745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);

Line 749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);

745: WF_EVENT.AddParameterToList('ECX_PARTY_TYPE', 'S', l_gen_wf_param);
746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);

Line 750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);

746: WF_EVENT.AddParameterToList('ECX_PARTY_ID', l_party_id, l_gen_wf_param);
747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);

Line 751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);

747: WF_EVENT.AddParameterToList('ECX_PARTY_SITE_ID', l_party_site_id, l_gen_wf_param);
748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);

Line 752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);

748: WF_EVENT.AddParameterToList('ECX_DOCUMENT_ID', l_event_key, l_gen_wf_param);
749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);

Line 753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);

749: WF_EVENT.AddParameterToList('ORG_ID', l_org_id, l_gen_wf_param);
750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);

Line 754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);

750: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_num, l_gen_wf_param);
751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);

Line 755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);

751: WF_EVENT.AddParameterToList('VALIDATION_REQUIRED_YN', 'N', l_gen_wf_param);
752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);
759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);

Line 756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);

752: WF_EVENT.AddParameterToList('CH_MESSAGE_BEFORE_GENERATE_XML', 'M4R_7B5_OSFM_CH_CREATED', l_gen_wf_param);
753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);
759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);
760:

Line 757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);

753: WF_EVENT.AddParameterToList('CH_MESSAGE_AFTER_XML_SENT', 'M4R_7B5_OSFM_CH_XML_GENERATED', l_gen_wf_param);
754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);
759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);
760:
761: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_rev_date)';

Line 758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);

754: WF_EVENT.AddParameterToList('ECX_DELIVERY_CHECK_REQUIRED', 'N', l_gen_wf_param);
755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);
759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);
760:
761: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_rev_date)';
762:

Line 759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);

755: WF_EVENT.AddParameterToList('ECX_PARAMETER1', l_po_header_id, l_gen_wf_param);
756: WF_EVENT.AddParameterToList('ECX_PARAMETER2', l_po_rev_num, l_gen_wf_param);
757: WF_EVENT.AddParameterToList('ECX_PARAMETER3', lines_rec.po_line_id, l_gen_wf_param);
758: WF_EVENT.AddParameterToList('ECX_PARAMETER4', l_action_code, l_gen_wf_param);
759: WF_EVENT.AddParameterToList('ECX_PARAMETER5', l_wip_entity_id, l_gen_wf_param);
760:
761: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_rev_date)';
762:
763: l_cn_rev_date := FND_DATE.DATE_TO_CANONICAL(l_rev_date);

Line 764: WF_EVENT.AddParameterToList('DOCUMENT_REVISION_DATE', l_cn_rev_date, l_gen_wf_param);

760:
761: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_rev_date)';
762:
763: l_cn_rev_date := FND_DATE.DATE_TO_CANONICAL(l_rev_date);
764: WF_EVENT.AddParameterToList('DOCUMENT_REVISION_DATE', l_cn_rev_date, l_gen_wf_param);
765:
766: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_creation_date)';
767:
768: l_cn_create_date := FND_DATE.DATE_TO_CANONICAL(l_creation_date);

Line 769: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', l_cn_create_date, l_gen_wf_param);

765:
766: g_exception_tracking_msg := 'FND_DATE.DATE_TO_CANONICAL(l_creation_date)';
767:
768: l_cn_create_date := FND_DATE.DATE_TO_CANONICAL(l_creation_date);
769: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', l_cn_create_date, l_gen_wf_param);
770:
771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);

Line 771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);

767:
768: l_cn_create_date := FND_DATE.DATE_TO_CANONICAL(l_creation_date);
769: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', l_cn_create_date, l_gen_wf_param);
770:
771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);

Line 772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);

768: l_cn_create_date := FND_DATE.DATE_TO_CANONICAL(l_creation_date);
769: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', l_cn_create_date, l_gen_wf_param);
770:
771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);

Line 773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);

769: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', l_cn_create_date, l_gen_wf_param);
770:
771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);

Line 774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);

770:
771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);

Line 775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);

771: WF_EVENT.AddParameterToList('COLLABORATION_STATUS_SET', 'Y', l_gen_wf_param);
772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);

Line 776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);

772: WF_EVENT.AddParameterToList('ATTRIBUTE1', l_po_rel_id, l_gen_wf_param);
773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);

Line 777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);

773: WF_EVENT.AddParameterToList('ATTRIBUTE2', l_rout_seq_num, l_gen_wf_param);
774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);

Line 778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);

774: WF_EVENT.AddParameterToList('ATTRIBUTE3', l_line_loc_id, l_gen_wf_param);
775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);

Line 779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);

775: WF_EVENT.AddParameterToList('ATTRIBUTE5', l_po_rel_num, l_gen_wf_param);
776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);
783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);

Line 780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);

776: WF_EVENT.AddParameterToList('ATTRIBUTE6', l_assembly_name, l_gen_wf_param);
777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);
783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);
784:

Line 781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);

777: WF_EVENT.AddParameterToList('ATTRIBUTE7', l_op_desc, l_gen_wf_param);
778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);
783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);
784:
785: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime)';

Line 782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);

778: WF_EVENT.AddParameterToList('ATTRIBUTE8', l_line_loc_rev_num, l_gen_wf_param);
779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);
783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);
784:
785: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime)';
786:

Line 783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);

779: WF_EVENT.AddParameterToList('ATTRIBUTE9', l_line_rev_num, l_gen_wf_param);
780: WF_EVENT.AddParameterToList('ATTRIBUTE10', l_dist_quant_ord, l_gen_wf_param);
781: WF_EVENT.AddParameterToList('ATTRIBUTE11', l_item, l_gen_wf_param);
782: WF_EVENT.AddParameterToList('ATTRIBUTE12', l_item_rv, l_gen_wf_param);
783: WF_EVENT.AddParameterToList('ATTRIBUTE13', l_uom, l_gen_wf_param);
784:
785: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime)';
786:
787: cln_rn_utils.CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime);

Line 788: WF_EVENT.AddParameterToList('DATTRIBUTE1', x_rn_datetime, l_gen_wf_param);

784:
785: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime)';
786:
787: cln_rn_utils.CONVERT_TO_RN_DATETIME(l_rev_date,x_rn_datetime);
788: WF_EVENT.AddParameterToList('DATTRIBUTE1', x_rn_datetime, l_gen_wf_param);
789:
790: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_creation_date,x_rn_datetime)';
791:
792: cln_rn_utils.CONVERT_TO_RN_DATETIME(l_creation_date,x_rn_datetime);

Line 793: WF_EVENT.AddParameterToList('DATTRIBUTE2', x_rn_datetime, l_gen_wf_param);

789:
790: g_exception_tracking_msg := 'CONVERT_TO_RN_DATETIME(l_creation_date,x_rn_datetime)';
791:
792: cln_rn_utils.CONVERT_TO_RN_DATETIME(l_creation_date,x_rn_datetime);
793: WF_EVENT.AddParameterToList('DATTRIBUTE2', x_rn_datetime, l_gen_wf_param);
794:
795: IF l_po_doc_type = 'RELEASE' THEN
796: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rel_rev_num, l_gen_wf_param); -- Release Revision Number
797: ELSE

Line 796: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rel_rev_num, l_gen_wf_param); -- Release Revision Number

792: cln_rn_utils.CONVERT_TO_RN_DATETIME(l_creation_date,x_rn_datetime);
793: WF_EVENT.AddParameterToList('DATTRIBUTE2', x_rn_datetime, l_gen_wf_param);
794:
795: IF l_po_doc_type = 'RELEASE' THEN
796: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rel_rev_num, l_gen_wf_param); -- Release Revision Number
797: ELSE
798: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rev_num, l_gen_wf_param); ---- PO Revision Number
799: END IF;
800:

Line 798: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rev_num, l_gen_wf_param); ---- PO Revision Number

794:
795: IF l_po_doc_type = 'RELEASE' THEN
796: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rel_rev_num, l_gen_wf_param); -- Release Revision Number
797: ELSE
798: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rev_num, l_gen_wf_param); ---- PO Revision Number
799: END IF;
800:
801: IF (g_debug_level <= 2) THEN
802: cln_debug_pub.Add('ATTRIBUTE4 : ' || l_po_rev_num || ' Header Revision Number' ,2);

Line 805: WF_EVENT.AddParameterToList('REFERENCE_ID', l_event_key, l_gen_wf_param);

801: IF (g_debug_level <= 2) THEN
802: cln_debug_pub.Add('ATTRIBUTE4 : ' || l_po_rev_num || ' Header Revision Number' ,2);
803: END IF;
804:
805: WF_EVENT.AddParameterToList('REFERENCE_ID', l_event_key, l_gen_wf_param);
806:
807: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_event_key, NULL, l_gen_wf_param, NULL);
808:
809: IF (g_debug_Level <= 1) THEN

Line 807: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_event_key, NULL, l_gen_wf_param, NULL);

803: END IF;
804:
805: WF_EVENT.AddParameterToList('REFERENCE_ID', l_event_key, l_gen_wf_param);
806:
807: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_event_key, NULL, l_gen_wf_param, NULL);
808:
809: IF (g_debug_Level <= 1) THEN
810: cln_debug_pub.Add('---------Generic Workflow Triggered ---------', 1);
811: END IF;