72: cln_debug_pub.Add('p_event_name -- ' || l_event_name, 1);
73: END IF;
74:
75: -- set event parameters for CLN Add Message Event
76: wf_event.AddParameterToList(
77: p_name => 'COLLABORATION_DETAIL_ID',
78: p_value => p_collab_detail_id,
79: p_parameterlist => l_event_parameters );
80:
77: p_name => 'COLLABORATION_DETAIL_ID',
78: p_value => p_collab_detail_id,
79: p_parameterlist => l_event_parameters );
80:
81: wf_event.AddParameterToList(
82: p_name => 'DETAIL_MESSAGE',
83: p_value => l_error_description,
84: p_parameterlist => l_event_parameters );
85:
84: p_parameterlist => l_event_parameters );
85:
86:
87: -- add CLN event to add error messages as to collaboration history
88: wf_event.raise(
89: p_event_name => l_event_name,
90: p_event_key => l_event_key,
91: p_parameters => l_event_parameters
92: );
304: l_notif_mesg := 'Catalogue Item Confirmation received with following details';
305:
306: l_event_params := wf_parameter_list_t();
307:
308: wf_event.AddParameterToList(
309: p_name => 'COLLABORATION_ID',
310: p_value => p_cin_unique_id,
311: p_parameterlist => l_event_params );
312:
309: p_name => 'COLLABORATION_ID',
310: p_value => p_cin_unique_id,
311: p_parameterlist => l_event_params );
312:
313: wf_event.AddParameterToList(
314: p_name => 'COLLABORATION_POINT',
315: p_value => 'APPS',
316: p_parameterlist => l_event_params );
317:
314: p_name => 'COLLABORATION_POINT',
315: p_value => 'APPS',
316: p_parameterlist => l_event_params );
317:
318: wf_event.AddParameterToList(
319: p_name => 'APPLICATION_ID',
320: p_value => m4u_ucc_utils.c_resp_appl_id,
321: p_parameterlist => l_event_params );
322:
319: p_name => 'APPLICATION_ID',
320: p_value => m4u_ucc_utils.c_resp_appl_id,
321: p_parameterlist => l_event_params );
322:
323: wf_event.AddParameterToList(
324: p_name => 'NOTIFICATION_CODE',
325: p_value => 'M4UCIC',
326: p_parameterlist => l_event_params );
327:
324: p_name => 'NOTIFICATION_CODE',
325: p_value => 'M4UCIC',
326: p_parameterlist => l_event_params );
327:
328: wf_event.AddParameterToList(
329: p_name => 'NOTIFICATION_STATUS',
330: p_value => l_coll_status,
331: p_parameterlist => l_event_params );
332:
329: p_name => 'NOTIFICATION_STATUS',
330: p_value => l_coll_status,
331: p_parameterlist => l_event_params );
332:
333: wf_event.AddParameterToList(
334: p_name => 'NOTIFICATION_DESC',
335: p_value => l_notif_mesg,
336: p_parameterlist => l_event_params );
337:
344: cln_debug_pub.add('event-value -' || l_event_key ,1);
345: END IF;
346:
347: -- raise event to trigger CLN Notifcations
348: wf_event.raise(
349: p_event_name => l_event_name,
350: p_event_key => l_event_key,
351: p_parameters => l_event_params
352: );
890: l_notif_mesg := 'RCIR Batch status received';
891:
892: l_event_params := wf_parameter_list_t();
893:
894: wf_event.AddParameterToList(
895: p_name => 'ATTRIBUTE_NAME',
896: p_value => 'ATTRIBUTE12',
897: p_parameterlist => l_event_params );
898:
895: p_name => 'ATTRIBUTE_NAME',
896: p_value => 'ATTRIBUTE12',
897: p_parameterlist => l_event_params );
898:
899: wf_event.AddParameterToList(
900: p_name => 'ATTRIBUTE_VALUE',
901: p_value => l_batch_id,
902: p_parameterlist => l_event_params );
903:
900: p_name => 'ATTRIBUTE_VALUE',
901: p_value => l_batch_id,
902: p_parameterlist => l_event_params );
903:
904: wf_event.AddParameterToList(
905: p_name => 'BATCH_MODE_REQD',
906: p_value => 'Y',
907: p_parameterlist => l_event_params );
908:
906: p_value => 'Y',
907: p_parameterlist => l_event_params );
908:
909:
910: wf_event.AddParameterToList(
911: p_name => 'COLLABORATION_POINT',
912: p_value => 'APPS',
913: p_parameterlist => l_event_params );
914:
911: p_name => 'COLLABORATION_POINT',
912: p_value => 'APPS',
913: p_parameterlist => l_event_params );
914:
915: wf_event.AddParameterToList(
916: p_name => 'COLLABORATION_STANDARD',
917: p_value => 'UCCNET',
918: p_parameterlist => l_event_params );
919:
916: p_name => 'COLLABORATION_STANDARD',
917: p_value => 'UCCNET',
918: p_parameterlist => l_event_params );
919:
920: wf_event.AddParameterToList(
921: p_name => 'APPLICATION_ID',
922: p_value => m4u_ucc_utils.c_resp_appl_id,
923: p_parameterlist => l_event_params );
924:
921: p_name => 'APPLICATION_ID',
922: p_value => m4u_ucc_utils.c_resp_appl_id,
923: p_parameterlist => l_event_params );
924:
925: wf_event.AddParameterToList(
926: p_name => 'NOTIFICATION_CODE',
927: p_value => 'M4UBATCH',
928: p_parameterlist => l_event_params );
929:
926: p_name => 'NOTIFICATION_CODE',
927: p_value => 'M4UBATCH',
928: p_parameterlist => l_event_params );
929:
930: wf_event.AddParameterToList(
931: p_name => 'NOTIFICATION_STATUS',
932: p_value => 'SUCCESS',
933: p_parameterlist => l_event_params );
934:
931: p_name => 'NOTIFICATION_STATUS',
932: p_value => 'SUCCESS',
933: p_parameterlist => l_event_params );
934:
935: wf_event.AddParameterToList(
936: p_name => 'NOTIFICATION_DESC',
937: p_value => l_notif_mesg,
938: p_parameterlist => l_event_params );
939:
936: p_name => 'NOTIFICATION_DESC',
937: p_value => l_notif_mesg,
938: p_parameterlist => l_event_params );
939:
940: wf_event.AddParameterToList(
941: p_name => 'NOTIFICATION_RECEIVER_ROLE',
942: p_value => l_owner_role,
943: p_parameterlist => l_event_params );
944:
951: cln_debug_pub.add('event-value -' || l_event_key ,1);
952: END IF;
953:
954: -- raise event to trigger CLN Notifcations
955: wf_event.raise(
956: p_event_name => l_event_name,
957: p_event_key => l_event_key,
958: p_parameters => l_event_params
959: );
1341: l_notif_mesg := 'Acknowledgement received for RCIR, from UCCnet with following details';
1342:
1343: l_event_params := wf_parameter_list_t();
1344:
1345: wf_event.AddParameterToList(
1346: p_name => 'COLLABORATION_ID',
1347: p_value => p_command_unique_id,
1348: p_parameterlist => l_event_params );
1349:
1346: p_name => 'COLLABORATION_ID',
1347: p_value => p_command_unique_id,
1348: p_parameterlist => l_event_params );
1349:
1350: wf_event.AddParameterToList(
1351: p_name => 'COLLABORATION_POINT',
1352: p_value => 'APPS',
1353: p_parameterlist => l_event_params );
1354:
1351: p_name => 'COLLABORATION_POINT',
1352: p_value => 'APPS',
1353: p_parameterlist => l_event_params );
1354:
1355: wf_event.AddParameterToList(
1356: p_name => 'APPLICATION_ID',
1357: p_value => m4u_ucc_utils.c_resp_appl_id,
1358: p_parameterlist => l_event_params );
1359:
1356: p_name => 'APPLICATION_ID',
1357: p_value => m4u_ucc_utils.c_resp_appl_id,
1358: p_parameterlist => l_event_params );
1359:
1360: wf_event.AddParameterToList(
1361: p_name => 'NOTIFICATION_CODE',
1362: p_value => 'M4URCIR',
1363: p_parameterlist => l_event_params );
1364:
1361: p_name => 'NOTIFICATION_CODE',
1362: p_value => 'M4URCIR',
1363: p_parameterlist => l_event_params );
1364:
1365: wf_event.AddParameterToList(
1366: p_name => 'NOTIFICATION_STATUS',
1367: p_value => l_coll_status,
1368: p_parameterlist => l_event_params );
1369:
1366: p_name => 'NOTIFICATION_STATUS',
1367: p_value => l_coll_status,
1368: p_parameterlist => l_event_params );
1369:
1370: wf_event.AddParameterToList(
1371: p_name => 'NOTIFICATION_DESC',
1372: p_value => l_notif_mesg,
1373: p_parameterlist => l_event_params );
1374:
1381: cln_debug_pub.add('event-value -' || l_event_key ,1);
1382: END IF;
1383:
1384: -- raise event for notification
1385: wf_event.raise(
1386: p_event_name => l_event_name,
1387: p_event_key => l_event_key,
1388: p_parameters => l_event_params
1389: );
1605:
1606: l_event_params := wf_parameter_list_t();
1607:
1608:
1609: wf_event.AddParameterToList(
1610: p_name => 'ATTRIBUTE_NAME',
1611: p_value => 'ATTRIBUTE12',
1612: p_parameterlist => l_event_params );
1613:
1611: p_value => 'ATTRIBUTE12',
1612: p_parameterlist => l_event_params );
1613:
1614:
1615: wf_event.AddParameterToList(
1616: p_name => 'ATTRIBUTE_VALUE',
1617: p_value => p_command_unique_id,
1618: p_parameterlist => l_event_params );
1619:
1616: p_name => 'ATTRIBUTE_VALUE',
1617: p_value => p_command_unique_id,
1618: p_parameterlist => l_event_params );
1619:
1620: wf_event.AddParameterToList(
1621: p_name => 'BATCH_MODE_REQD',
1622: p_value => 'Y',
1623: p_parameterlist => l_event_params );
1624:
1621: p_name => 'BATCH_MODE_REQD',
1622: p_value => 'Y',
1623: p_parameterlist => l_event_params );
1624:
1625: wf_event.AddParameterToList(
1626: p_name => 'COLLABORATION_POINT',
1627: p_value => 'APPS',
1628: p_parameterlist => l_event_params );
1629:
1626: p_name => 'COLLABORATION_POINT',
1627: p_value => 'APPS',
1628: p_parameterlist => l_event_params );
1629:
1630: wf_event.AddParameterToList(
1631: p_name => 'COLLABORATION_STANDARD',
1632: p_value => 'UCCNET',
1633: p_parameterlist => l_event_params );
1634:
1631: p_name => 'COLLABORATION_STANDARD',
1632: p_value => 'UCCNET',
1633: p_parameterlist => l_event_params );
1634:
1635: wf_event.AddParameterToList(
1636: p_name => 'APPLICATION_ID',
1637: p_value => m4u_ucc_utils.c_resp_appl_id,
1638: p_parameterlist => l_event_params );
1639:
1636: p_name => 'APPLICATION_ID',
1637: p_value => m4u_ucc_utils.c_resp_appl_id,
1638: p_parameterlist => l_event_params );
1639:
1640: wf_event.AddParameterToList(
1641: p_name => 'NOTIFICATION_CODE',
1642: p_value => 'M4UBCHAK',
1643: p_parameterlist => l_event_params );
1644:
1641: p_name => 'NOTIFICATION_CODE',
1642: p_value => 'M4UBCHAK',
1643: p_parameterlist => l_event_params );
1644:
1645: wf_event.AddParameterToList(
1646: p_name => 'NOTIFICATION_STATUS',
1647: p_value => l_coll_status,
1648: p_parameterlist => l_event_params );
1649:
1646: p_name => 'NOTIFICATION_STATUS',
1647: p_value => l_coll_status,
1648: p_parameterlist => l_event_params );
1649:
1650: wf_event.AddParameterToList(
1651: p_name => 'NOTIFICATION_DESC',
1652: p_value => l_notif_mesg,
1653: p_parameterlist => l_event_params );
1654:
1663: WHEN NO_DATA_FOUND THEN
1664: l_owner_role := fnd_profile.value('CLN_ADMINISTRATOR');
1665: END;
1666:
1667: wf_event.AddParameterToList(
1668: p_name => 'NOTIFICATION_RECEIVER_ROLE',
1669: p_value => l_owner_role,
1670: p_parameterlist => l_event_params );
1671:
1678: cln_debug_pub.add('event-value -' || l_event_key ,1);
1679: END IF;
1680:
1681: -- raise event to trigger outbound wlq generation WF
1682: wf_event.raise(
1683: p_event_name => l_event_name,
1684: p_event_key => l_event_key,
1685: p_parameters => l_event_params
1686: );
1875:
1876: l_notif_mesg := 'Acknowledgement received from UCCnet for CIN message';
1877:
1878: l_event_params := wf_parameter_list_t();
1879: wf_event.AddParameterToList(
1880: p_name => 'COLLABORATION_ID',
1881: p_value => p_command_unique_id,
1882: p_parameterlist => l_event_params );
1883:
1880: p_name => 'COLLABORATION_ID',
1881: p_value => p_command_unique_id,
1882: p_parameterlist => l_event_params );
1883:
1884: wf_event.AddParameterToList(
1885: p_name => 'COLLABORATION_POINT',
1886: p_value => 'APPS',
1887: p_parameterlist => l_event_params );
1888:
1885: p_name => 'COLLABORATION_POINT',
1886: p_value => 'APPS',
1887: p_parameterlist => l_event_params );
1888:
1889: wf_event.AddParameterToList(
1890: p_name => 'APPLICATION_ID',
1891: p_value => m4u_ucc_utils.c_resp_appl_id,
1892: p_parameterlist => l_event_params );
1893:
1890: p_name => 'APPLICATION_ID',
1891: p_value => m4u_ucc_utils.c_resp_appl_id,
1892: p_parameterlist => l_event_params );
1893:
1894: wf_event.AddParameterToList(
1895: p_name => 'NOTIFICATION_CODE',
1896: p_value => 'M4UCINAK',
1897: p_parameterlist => l_event_params );
1898:
1895: p_name => 'NOTIFICATION_CODE',
1896: p_value => 'M4UCINAK',
1897: p_parameterlist => l_event_params );
1898:
1899: wf_event.AddParameterToList(
1900: p_name => 'NOTIFICATION_STATUS',
1901: p_value => l_coll_status,
1902: p_parameterlist => l_event_params );
1903:
1900: p_name => 'NOTIFICATION_STATUS',
1901: p_value => l_coll_status,
1902: p_parameterlist => l_event_params );
1903:
1904: wf_event.AddParameterToList(
1905: p_name => 'NOTIFICATION_DESC',
1906: p_value => l_notif_mesg,
1907: p_parameterlist => l_event_params );
1908:
1914: cln_debug_pub.add('event-value -' || l_event_key ,1);
1915: END IF;
1916:
1917: -- raise event to trigger outbound wlq generation WF
1918: wf_event.raise(
1919: p_event_name => l_event_name,
1920: p_event_key => l_event_key,
1921: p_parameters => l_event_params
1922: );
2094:
2095: l_notif_mesg := 'Request For CIN, received on with following details';
2096:
2097: l_event_params := wf_parameter_list_t();
2098: wf_event.AddParameterToList(
2099: p_name => 'COLLABORATION_ID',
2100: p_value => l_coll_id,
2101: p_parameterlist => l_event_params );
2102:
2099: p_name => 'COLLABORATION_ID',
2100: p_value => l_coll_id,
2101: p_parameterlist => l_event_params );
2102:
2103: wf_event.AddParameterToList(
2104: p_name => 'COLLABORATION_POINT',
2105: p_value => 'APPS',
2106: p_parameterlist => l_event_params );
2107:
2104: p_name => 'COLLABORATION_POINT',
2105: p_value => 'APPS',
2106: p_parameterlist => l_event_params );
2107:
2108: wf_event.AddParameterToList(
2109: p_name => 'APPLICATION_ID',
2110: p_value => m4u_ucc_utils.c_resp_appl_id,
2111: p_parameterlist => l_event_params );
2112:
2109: p_name => 'APPLICATION_ID',
2110: p_value => m4u_ucc_utils.c_resp_appl_id,
2111: p_parameterlist => l_event_params );
2112:
2113: wf_event.AddParameterToList(
2114: p_name => 'NOTIFICATION_CODE',
2115: p_value => 'M4URFCIN',
2116: p_parameterlist => l_event_params );
2117:
2114: p_name => 'NOTIFICATION_CODE',
2115: p_value => 'M4URFCIN',
2116: p_parameterlist => l_event_params );
2117:
2118: wf_event.AddParameterToList(
2119: p_name => 'NOTIFICATION_STATUS',
2120: p_value => 'SUCCESS',
2121: p_parameterlist => l_event_params );
2122:
2119: p_name => 'NOTIFICATION_STATUS',
2120: p_value => 'SUCCESS',
2121: p_parameterlist => l_event_params );
2122:
2123: wf_event.AddParameterToList(
2124: p_name => 'NOTIFICATION_DESC',
2125: p_value => l_notif_mesg,
2126: p_parameterlist => l_event_params );
2127:
2132: cln_debug_pub.Add('-- CLN notification raised -- event_key ' || l_event_key, 1);
2133: END IF;
2134:
2135: -- raise event to trigger outbound wlq generation WF
2136: wf_event.raise(
2137: p_event_name => l_event_name,
2138: p_event_key => l_event_key,
2139: p_parameters => l_event_params
2140: );