207:
208: END IF; --Request_ID
209: BEGIN
210:
211: WF_EVENT.Raise(p_event_name => p_event_name
212: ,p_event_key => p_event_key
213: ,p_parameters => l_parameter_list);
214: EXCEPTION
215: WHEN OTHERS THEN
312: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
313:
314:
315: --Adding the parameters
316: wf_event.AddParameterToList(p_name => 'INVENTORY_ITEM_ID'
317: ,p_value => p_Inventory_Item_Id
318: ,p_ParameterList => l_parameter_List);
319: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID'
320: ,p_value => p_Organization_Id
315: --Adding the parameters
316: wf_event.AddParameterToList(p_name => 'INVENTORY_ITEM_ID'
317: ,p_value => p_Inventory_Item_Id
318: ,p_ParameterList => l_parameter_List);
319: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID'
320: ,p_value => p_Organization_Id
321: ,p_ParameterList => l_parameter_List);
322: wf_event.AddParameterToList(p_name => 'DML_TYPE'
323: ,p_value => p_dml_type
318: ,p_ParameterList => l_parameter_List);
319: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID'
320: ,p_value => p_Organization_Id
321: ,p_ParameterList => l_parameter_List);
322: wf_event.AddParameterToList(p_name => 'DML_TYPE'
323: ,p_value => p_dml_type
324: ,p_ParameterList => l_parameter_List);
325: wf_event.AddParameterToList(p_name => 'MANUFACTURER_ID'
326: ,p_value => p_Manufacturer_Id
321: ,p_ParameterList => l_parameter_List);
322: wf_event.AddParameterToList(p_name => 'DML_TYPE'
323: ,p_value => p_dml_type
324: ,p_ParameterList => l_parameter_List);
325: wf_event.AddParameterToList(p_name => 'MANUFACTURER_ID'
326: ,p_value => p_Manufacturer_Id
327: ,p_ParameterList => l_parameter_List);
328: wf_event.AddParameterToList(p_name => 'MFG_PART_NUM'
329: ,p_value => p_Mfg_Part_Num
324: ,p_ParameterList => l_parameter_List);
325: wf_event.AddParameterToList(p_name => 'MANUFACTURER_ID'
326: ,p_value => p_Manufacturer_Id
327: ,p_ParameterList => l_parameter_List);
328: wf_event.AddParameterToList(p_name => 'MFG_PART_NUM'
329: ,p_value => p_Mfg_Part_Num
330: ,p_ParameterList => l_parameter_List);
331:
332: /*R12: Business Events*/
329: ,p_value => p_Mfg_Part_Num
330: ,p_ParameterList => l_parameter_List);
331:
332: /*R12: Business Events*/
333: WF_EVENT.Raise(p_event_name => l_event_name
334: ,p_event_key => l_event_key
335: ,p_parameters => l_parameter_list);
336:
337: l_parameter_list.DELETE;
386:
387:
388: --Adding the parameters
389: IF p_request_id IS NOT NULL THEN --in case of Bulk Load
390: wf_event.AddParameterToList( p_name => 'REQUEST_ID'
391: ,p_value => p_request_id
392: ,p_ParameterList => l_parameter_List);
393: ELSE
394: -- Fix for bug#8474046
400: ELSE
401: l_org_id := p_organization_id;
402: END IF;
403:
404: wf_event.AddParameterToList( p_name => 'INVENTORY_ITEM_ID'
405: ,p_value => p_Inventory_Item_Id
406: ,p_ParameterList => l_parameter_List);
407: wf_event.AddParameterToList( p_name => 'ORGANIZATION_ID'
408: ,p_value => l_org_id -- fix for bug#8474046 p_Organization_Id
403:
404: wf_event.AddParameterToList( p_name => 'INVENTORY_ITEM_ID'
405: ,p_value => p_Inventory_Item_Id
406: ,p_ParameterList => l_parameter_List);
407: wf_event.AddParameterToList( p_name => 'ORGANIZATION_ID'
408: ,p_value => l_org_id -- fix for bug#8474046 p_Organization_Id
409: ,p_ParameterList => l_parameter_List);
410: wf_event.AddParameterToList( p_name => 'ORGANIZATION_CODE'
411: ,p_value => p_organization_code
406: ,p_ParameterList => l_parameter_List);
407: wf_event.AddParameterToList( p_name => 'ORGANIZATION_ID'
408: ,p_value => l_org_id -- fix for bug#8474046 p_Organization_Id
409: ,p_ParameterList => l_parameter_List);
410: wf_event.AddParameterToList( p_name => 'ORGANIZATION_CODE'
411: ,p_value => p_organization_code
412: ,p_ParameterList => l_parameter_List);
413: wf_event.AddParameterToList( p_name => 'ITEM_NUMBER'
414: ,p_value => p_item_number
409: ,p_ParameterList => l_parameter_List);
410: wf_event.AddParameterToList( p_name => 'ORGANIZATION_CODE'
411: ,p_value => p_organization_code
412: ,p_ParameterList => l_parameter_List);
413: wf_event.AddParameterToList( p_name => 'ITEM_NUMBER'
414: ,p_value => p_item_number
415: ,p_ParameterList => l_parameter_List);
416: wf_event.AddParameterToList( p_name => 'ITEM_DESCRIPTION'
417: ,p_value => p_item_description
412: ,p_ParameterList => l_parameter_List);
413: wf_event.AddParameterToList( p_name => 'ITEM_NUMBER'
414: ,p_value => p_item_number
415: ,p_ParameterList => l_parameter_List);
416: wf_event.AddParameterToList( p_name => 'ITEM_DESCRIPTION'
417: ,p_value => p_item_description
418: ,p_ParameterList => l_parameter_List);
419: wf_event.AddParameterToList( p_name => 'IS_MASTER_ATTR_MODIFIED'
420: ,p_value => p_is_master_attr_modified
415: ,p_ParameterList => l_parameter_List);
416: wf_event.AddParameterToList( p_name => 'ITEM_DESCRIPTION'
417: ,p_value => p_item_description
418: ,p_ParameterList => l_parameter_List);
419: wf_event.AddParameterToList( p_name => 'IS_MASTER_ATTR_MODIFIED'
420: ,p_value => p_is_master_attr_modified
421: ,p_ParameterList => l_parameter_List);
422:
423: END IF;
422:
423: END IF;
424:
425: /*R12: Business Events*/
426: WF_EVENT.Raise(p_event_name => l_event_name
427: ,p_event_key => l_event_key
428: ,p_parameters => l_parameter_list);
429:
430:
478: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
479: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
480:
481: IF p_request_id IS NOT NULL THEN --in case of Bulk Load
482: wf_event.AddParameterToList( p_name => 'REQUEST_ID'
483: ,p_value => p_request_id
484: ,p_ParameterList => l_parameter_List);
485: ELSE
486: wf_event.AddParameterToList( p_name => 'INVENTORY_ITEM_ID'
482: wf_event.AddParameterToList( p_name => 'REQUEST_ID'
483: ,p_value => p_request_id
484: ,p_ParameterList => l_parameter_List);
485: ELSE
486: wf_event.AddParameterToList( p_name => 'INVENTORY_ITEM_ID'
487: , p_value => p_Inventory_Item_Id
488: , p_ParameterList => l_parameter_List);
489: wf_event.AddParameterToList( p_name => 'ORGANIZATION_ID'
490: , p_value => p_Organization_Id
485: ELSE
486: wf_event.AddParameterToList( p_name => 'INVENTORY_ITEM_ID'
487: , p_value => p_Inventory_Item_Id
488: , p_ParameterList => l_parameter_List);
489: wf_event.AddParameterToList( p_name => 'ORGANIZATION_ID'
490: , p_value => p_Organization_Id
491: , p_ParameterList => l_parameter_List);
492:
493: IF p_dml_type IS NOT NULL THEN
490: , p_value => p_Organization_Id
491: , p_ParameterList => l_parameter_List);
492:
493: IF p_dml_type IS NOT NULL THEN
494: wf_event.AddParameterToList( p_name => 'DML_TYPE'
495: , p_value => p_dml_type
496: , p_ParameterList => l_parameter_List);
497: END IF;
498:
496: , p_ParameterList => l_parameter_List);
497: END IF;
498:
499: IF p_Revision_id IS NOT NULL THEN
500: wf_event.AddParameterToList( p_name => 'REVISION_ID'
501: , p_value => p_Revision_id
502: , p_ParameterList => l_parameter_List);
503: END IF;
504:
502: , p_ParameterList => l_parameter_List);
503: END IF;
504:
505: IF p_catalog_id IS NOT NULL THEN
506: wf_event.AddParameterToList( p_name => 'CATALOG_ID'
507: ,p_value => p_catalog_id
508: ,p_ParameterList => l_parameter_List);
509: END IF;
510: IF p_category_id IS NOT NULL THEN
507: ,p_value => p_catalog_id
508: ,p_ParameterList => l_parameter_List);
509: END IF;
510: IF p_category_id IS NOT NULL THEN
511: wf_event.AddParameterToList( p_name => 'CATEGORY_ID'
512: ,p_value => p_category_id
513: ,p_ParameterList => l_parameter_List);
514: END IF;
515: --add 8310065 with base bug 8351807
513: ,p_ParameterList => l_parameter_List);
514: END IF;
515: --add 8310065 with base bug 8351807
516: IF p_old_category_id IS NOT NULL THEN
517: wf_event.AddParameterToList( p_name => 'OLD_CATEGORY_ID'
518: ,p_value => p_old_category_id
519: ,p_ParameterList => l_parameter_List);
520: END IF;
521:
519: ,p_ParameterList => l_parameter_List);
520: END IF;
521:
522: IF p_cross_reference_type IS NOT NULL THEN
523: wf_event.AddParameterToList( p_name => 'CROSS_REFERENCE_TYPE'
524: ,p_value => p_cross_reference_type
525: ,p_ParameterList => l_parameter_List);
526: END IF;
527:
525: ,p_ParameterList => l_parameter_List);
526: END IF;
527:
528: IF p_cross_reference IS NOT NULL THEN
529: wf_event.AddParameterToList( p_name => 'CROSS_REFERENCE'
530: ,p_value => p_cross_reference
531: ,p_ParameterList => l_parameter_List);
532: END IF;
533: /***
533: /***
534: These parameters are commented as the associated events are not routed
535: through this package currently.
536: IF p_role_id IS NOT NULL THEN
537: wf_event.AddParameterToList( p_name => 'ROLE_ID'
538: ,p_value => p_role_id
539: ,p_ParameterList => l_parameter_List);
540: END IF;
541:
539: ,p_ParameterList => l_parameter_List);
540: END IF;
541:
542: IF p_party_type IS NOT NULL THEN
543: wf_event.AddParameterToList( p_name => 'PARTY_TYPE'
544: ,p_value => p_party_type
545: ,p_ParameterList => l_parameter_List);
546: END IF;
547:
545: ,p_ParameterList => l_parameter_List);
546: END IF;
547:
548: IF p_party_id IS NOT NULL THEN
549: wf_event.AddParameterToList( p_name => 'PARTY_ID'
550: ,p_value => p_party_id
551: ,p_ParameterList => l_parameter_List);
552: END IF;
553:
551: ,p_ParameterList => l_parameter_List);
552: END IF;
553:
554: IF p_start_date IS NOT NULL THEN
555: wf_event.AddParameterToList( p_name => 'START_DATE'
556: ,p_value => p_start_date
557: ,p_ParameterList => l_parameter_List);
558: END IF;
559:
557: ,p_ParameterList => l_parameter_List);
558: END IF;
559:
560: IF p_customer_item_id IS NOT NULL THEN
561: wf_event.AddParameterToList( p_name => 'CUSTOMER_ITEM_ID'
562: ,p_value => p_customer_item_id
563: ,p_ParameterList => l_parameter_List);
564: END IF;
565:
563: ,p_ParameterList => l_parameter_List);
564: END IF;
565:
566: IF p_related_item_id IS NOT NULL THEN
567: wf_event.AddParameterToList( p_name => 'RELATED_ITEM_ID'
568: ,p_value => p_related_item_id
569: ,p_ParameterList => l_parameter_List);
570: END IF;
571:
569: ,p_ParameterList => l_parameter_List);
570: END IF;
571:
572: IF p_relationship_type_id IS NOT NULL THEN
573: wf_event.AddParameterToList( p_name => 'RELATIONSHIP_TYPE_ID'
574: ,p_value => p_relationship_type_id
575: ,p_ParameterList => l_parameter_List);
576: END IF;
577: ***/
585: FROM mtl_category_sets_b
586: WHERE category_set_id = p_catalog_id;
587:
588: IF l_event_name = 'oracle.apps.ego.item.postCatalogAssignmentChange' AND l_raise_item_cat_assign = 'Y' THEN
589: WF_EVENT.Raise( p_event_name => l_event_name
590: ,p_event_key => l_event_key
591: ,p_parameters => l_parameter_list);
592: END IF;
593: IF l_event_name = 'oracle.apps.ego.item.postCatalogCategoryChange' AND l_raise_catalog_cat_chg = 'Y' THEN
590: ,p_event_key => l_event_key
591: ,p_parameters => l_parameter_list);
592: END IF;
593: IF l_event_name = 'oracle.apps.ego.item.postCatalogCategoryChange' AND l_raise_catalog_cat_chg = 'Y' THEN
594: WF_EVENT.Raise( p_event_name => l_event_name
595: ,p_event_key => l_event_key
596: ,p_parameters => l_parameter_list);
597: END IF;
598: IF l_event_name = 'oracle.apps.ego.item.postValidCategoryChange' AND l_raise_alt_cat_hier_chg = 'Y' THEN
595: ,p_event_key => l_event_key
596: ,p_parameters => l_parameter_list);
597: END IF;
598: IF l_event_name = 'oracle.apps.ego.item.postValidCategoryChange' AND l_raise_alt_cat_hier_chg = 'Y' THEN
599: WF_EVENT.Raise( p_event_name => l_event_name
600: ,p_event_key => l_event_key
601: ,p_parameters => l_parameter_list);
602: END IF;
603: END;
602: END IF;
603: END;
604: ELSE
605:
606: WF_EVENT.Raise( p_event_name => l_event_name
607: ,p_event_key => l_event_key
608: ,p_parameters => l_parameter_list);
609: END IF;
610:
643: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
644: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
645:
646: IF p_dml_type IS NOT NULL THEN
647: wf_event.AddParameterToList( p_name => 'DML_TYPE'
648: , p_value => p_dml_type
649: , p_ParameterList => l_parameter_List);
650: END IF;
651:
649: , p_ParameterList => l_parameter_List);
650: END IF;
651:
652: IF p_category_set_id IS NOT NULL THEN
653: wf_event.AddParameterToList( p_name => 'CATEGORY_SET_ID'
654: ,p_value => p_category_set_id
655: ,p_ParameterList => l_parameter_List);
656: END IF;
657:
656: END IF;
657:
658:
659: IF p_category_id IS NOT NULL THEN
660: wf_event.AddParameterToList( p_name => 'CATEGORY_ID'
661: ,p_value => p_category_id
662: ,p_ParameterList => l_parameter_List);
663: END IF;
664:
662: ,p_ParameterList => l_parameter_List);
663: END IF;
664:
665: IF p_category_name IS NOT NULL THEN
666: wf_event.AddParameterToList( p_name => 'CATEGORY_NAME'
667: ,p_value => p_category_name
668: ,p_ParameterList => l_parameter_List);
669: END IF;
670:
675: FROM mtl_category_sets_b
676: WHERE category_set_id = p_category_set_id;
677:
678: IF l_event_name = 'oracle.apps.ego.item.postCatalogAssignmentChange' AND l_raise_item_cat_assign = 'Y' THEN
679: WF_EVENT.Raise( p_event_name => l_event_name
680: ,p_event_key => l_event_key
681: ,p_parameters => l_parameter_list);
682: END IF;
683: IF l_event_name = 'oracle.apps.ego.item.postCatalogCategoryChange' AND l_raise_catalog_cat_chg = 'Y' THEN
680: ,p_event_key => l_event_key
681: ,p_parameters => l_parameter_list);
682: END IF;
683: IF l_event_name = 'oracle.apps.ego.item.postCatalogCategoryChange' AND l_raise_catalog_cat_chg = 'Y' THEN
684: WF_EVENT.Raise( p_event_name => l_event_name
685: ,p_event_key => l_event_key
686: ,p_parameters => l_parameter_list);
687: END IF;
688: IF l_event_name = 'oracle.apps.ego.item.postValidCategoryChange' AND l_raise_alt_cat_hier_chg = 'Y' THEN
685: ,p_event_key => l_event_key
686: ,p_parameters => l_parameter_list);
687: END IF;
688: IF l_event_name = 'oracle.apps.ego.item.postValidCategoryChange' AND l_raise_alt_cat_hier_chg = 'Y' THEN
689: WF_EVENT.Raise( p_event_name => l_event_name
690: ,p_event_key => l_event_key
691: ,p_parameters => l_parameter_list);
692: END IF;
693: END;
691: ,p_parameters => l_parameter_list);
692: END IF;
693: END;
694: ELSE
695: WF_EVENT.Raise( p_event_name => l_event_name
696: ,p_event_key => l_event_key
697: ,p_parameters => l_parameter_list);
698: END IF;
699:
734: SELECT TO_CHAR( SYSTIMESTAMP, 'dd-mon-yyyy hh24:mi:ss:ffff' )
735: INTO l_event_key
736: FROM DUAL;
737:
738: WF_EVENT.AddParameterToList( p_name => 'ENTITY_NAME'
739: ,p_value => p_entity_name
740: ,p_ParameterList => l_parameter_List);
741:
742:
739: ,p_value => p_entity_name
740: ,p_ParameterList => l_parameter_List);
741:
742:
743: WF_EVENT.AddParameterToList( p_name => 'PK1_VALUE'
744: ,p_value => p_pk1_value
745: ,p_ParameterList => l_parameter_List);
746:
747: WF_EVENT.AddParameterToList( p_name => 'PK2_VALUE'
743: WF_EVENT.AddParameterToList( p_name => 'PK1_VALUE'
744: ,p_value => p_pk1_value
745: ,p_ParameterList => l_parameter_List);
746:
747: WF_EVENT.AddParameterToList( p_name => 'PK2_VALUE'
748: ,p_value => p_pk2_value
749: ,p_ParameterList => l_parameter_List);
750:
751: WF_EVENT.AddParameterToList( p_name => 'PK3_VALUE'
747: WF_EVENT.AddParameterToList( p_name => 'PK2_VALUE'
748: ,p_value => p_pk2_value
749: ,p_ParameterList => l_parameter_List);
750:
751: WF_EVENT.AddParameterToList( p_name => 'PK3_VALUE'
752: ,p_value => p_pk3_value
753: ,p_ParameterList => l_parameter_List);
754:
755: WF_EVENT.AddParameterToList( p_name => 'PK4_VALUE'
751: WF_EVENT.AddParameterToList( p_name => 'PK3_VALUE'
752: ,p_value => p_pk3_value
753: ,p_ParameterList => l_parameter_List);
754:
755: WF_EVENT.AddParameterToList( p_name => 'PK4_VALUE'
756: ,p_value => p_pk4_value
757: ,p_ParameterList => l_parameter_List);
758:
759: WF_EVENT.AddParameterToList( p_name => 'PK5_VALUE'
755: WF_EVENT.AddParameterToList( p_name => 'PK4_VALUE'
756: ,p_value => p_pk4_value
757: ,p_ParameterList => l_parameter_List);
758:
759: WF_EVENT.AddParameterToList( p_name => 'PK5_VALUE'
760: ,p_value => p_pk5_value
761: ,p_ParameterList => l_parameter_List);
762:
763: WF_EVENT.AddParameterToList( p_name => 'PROCESSING_TYPE'
759: WF_EVENT.AddParameterToList( p_name => 'PK5_VALUE'
760: ,p_value => p_pk5_value
761: ,p_ParameterList => l_parameter_List);
762:
763: WF_EVENT.AddParameterToList( p_name => 'PROCESSING_TYPE'
764: ,p_value => p_processing_type
765: ,p_ParameterList => l_parameter_List);
766:
767: WF_EVENT.AddParameterToList( p_name => 'LANGUAGE_CODE'
763: WF_EVENT.AddParameterToList( p_name => 'PROCESSING_TYPE'
764: ,p_value => p_processing_type
765: ,p_ParameterList => l_parameter_List);
766:
767: WF_EVENT.AddParameterToList( p_name => 'LANGUAGE_CODE'
768: ,p_value => p_language_code
769: ,p_ParameterList => l_parameter_List);
770:
771: WF_EVENT.AddParameterToList( p_name => 'LAST_UPDATE_DATE'
767: WF_EVENT.AddParameterToList( p_name => 'LANGUAGE_CODE'
768: ,p_value => p_language_code
769: ,p_ParameterList => l_parameter_List);
770:
771: WF_EVENT.AddParameterToList( p_name => 'LAST_UPDATE_DATE'
772: ,p_value => p_last_update_date
773: ,p_ParameterList => l_parameter_List);
774:
775: WF_EVENT.Raise( p_event_name => l_event_name
771: WF_EVENT.AddParameterToList( p_name => 'LAST_UPDATE_DATE'
772: ,p_value => p_last_update_date
773: ,p_ParameterList => l_parameter_List);
774:
775: WF_EVENT.Raise( p_event_name => l_event_name
776: ,p_event_key => l_event_key
777: ,p_parameters => l_parameter_list);
778:
779: l_parameter_list.DELETE;