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

Line 1: PACKAGE BODY CS_WF_EVENT_PKG AS

1: PACKAGE BODY CS_WF_EVENT_PKG AS
2: /* $Header: cswfevtb.pls 120.23.12020000.2 2012/07/10 06:35:54 bkanimoz ship $ */
3:
4: /****************************************************************************************
5:

Line 33: p_event in out nocopy WF_EVENT_T) return varchar2 is

29: x_role_display_name OUT NOCOPY VARCHAR2 );
30:
31:
32: FUNCTION CS_Custom_Rule_Func (p_subscription_guid in raw,
33: p_event in out nocopy WF_EVENT_T) return varchar2 is
34:
35: l_event_name VARCHAR2(240) := p_event.getEventName( );
36: l_request_number VARCHAR2(64);
37: l_event_key VARCHAR2(240);

Line 229: -- WF_EVENT.setErrorInfo(p_event, 'WARNING');

225:
226: --
227: -- WF_CORE.CONTEXT('', '',
228: -- p_event.getEventName( ), p_subscription_guid);
229: -- WF_EVENT.setErrorInfo(p_event, 'WARNING');
230: -- return 'WARNING';
231:
232: EXCEPTION
233:

Line 239: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',

235: WHEN l_UPDATE_FAILED THEN
236: IF sel_workflow_csr%ISOPEN THEN
237: CLOSE sel_workflow_csr;
238: END IF;
239: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
240: l_event_name , p_subscription_guid);
241: WF_EVENT.setErrorInfo(p_event, 'WARNING');
242: return 'WARNING';
243: ******/

Line 241: WF_EVENT.setErrorInfo(p_event, 'WARNING');

237: CLOSE sel_workflow_csr;
238: END IF;
239: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
240: l_event_name , p_subscription_guid);
241: WF_EVENT.setErrorInfo(p_event, 'WARNING');
242: return 'WARNING';
243: ******/
244:
245: WHEN others THEN

Line 252: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',

248:
249: IF sel_workflow_csr%ISOPEN THEN
250: CLOSE sel_workflow_csr;
251: END IF;
252: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
253: l_event_name , p_subscription_guid);
254: WF_EVENT.setErrorInfo(p_event, 'ERROR');
255: return 'WARNING';
256:

Line 254: WF_EVENT.setErrorInfo(p_event, 'ERROR');

250: CLOSE sel_workflow_csr;
251: END IF;
252: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
253: l_event_name , p_subscription_guid);
254: WF_EVENT.setErrorInfo(p_event, 'ERROR');
255: return 'WARNING';
256:
257: END CS_Custom_Rule_Func;
258:

Line 276: p_event in out nocopy WF_EVENT_T) return varchar2 is

272: This provides backward compatibility for those clients who has custom
273: workflow processes but has not converted to BES.
274: ***************************************************************************************/
275: FUNCTION CS_Custom_Rule_Func1 (p_subscription_guid in raw,
276: p_event in out nocopy WF_EVENT_T) return varchar2 is
277:
278: l_event_name VARCHAR2(240) := p_event.getEventName( );
279: l_request_number VARCHAR2(64);
280: l_event_key VARCHAR2(240);

Line 526: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func1',

522:
523: IF sel_workflow_csr%ISOPEN THEN
524: CLOSE sel_workflow_csr;
525: END IF;
526: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func1',
527: l_event_name , p_subscription_guid);
528: WF_EVENT.setErrorInfo(p_event, 'ERROR');
529: return 'WARNING';
530:

Line 528: WF_EVENT.setErrorInfo(p_event, 'ERROR');

524: CLOSE sel_workflow_csr;
525: END IF;
526: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func1',
527: l_event_name , p_subscription_guid);
528: WF_EVENT.setErrorInfo(p_event, 'ERROR');
529: return 'WARNING';
530:
531: END CS_Custom_Rule_Func1;
532:

Line 849: wf_event.AddParameterToList(p_name => 'REQUEST_NUMBER',

845: This section sets the Event Parameter List. These parameters are
846: converted to workflow item attributes.
847: *******************************************************************/
848:
849: wf_event.AddParameterToList(p_name => 'REQUEST_NUMBER',
850: p_value => p_Incident_Number,
851: p_parameterlist => l_param_list);
852:
853: /* Roopa - Begin - Fix for bug 3360069 */

Line 856: wf_event.AddParameterToList(p_name => 'USER_ID',

852:
853: /* Roopa - Begin - Fix for bug 3360069 */
854: /* Initializing the vars with FND_GLOBAL values if the input vars are null in value */
855: IF(p_USER_ID is NULL or p_USER_ID = -1) THEN
856: wf_event.AddParameterToList(p_name => 'USER_ID',
857: p_value => FND_GLOBAL.USER_ID,
858: p_parameterlist => l_param_list);
859: ELSE
860: wf_event.AddParameterToList(p_name => 'USER_ID',

Line 860: wf_event.AddParameterToList(p_name => 'USER_ID',

856: wf_event.AddParameterToList(p_name => 'USER_ID',
857: p_value => FND_GLOBAL.USER_ID,
858: p_parameterlist => l_param_list);
859: ELSE
860: wf_event.AddParameterToList(p_name => 'USER_ID',
861: p_value => p_USER_ID,
862: p_parameterlist => l_param_list);
863:
864: END IF;

Line 867: wf_event.AddParameterToList(p_name => 'RESP_ID',

863:
864: END IF;
865:
866: IF(p_RESP_ID is NULL or p_RESP_ID = -1) THEN
867: wf_event.AddParameterToList(p_name => 'RESP_ID',
868: p_value => FND_GLOBAL.RESP_ID,
869: p_parameterlist => l_param_list);
870: ELSE
871: wf_event.AddParameterToList(p_name => 'RESP_ID',

Line 871: wf_event.AddParameterToList(p_name => 'RESP_ID',

867: wf_event.AddParameterToList(p_name => 'RESP_ID',
868: p_value => FND_GLOBAL.RESP_ID,
869: p_parameterlist => l_param_list);
870: ELSE
871: wf_event.AddParameterToList(p_name => 'RESP_ID',
872: p_value => p_RESP_ID,
873: p_parameterlist => l_param_list);
874: END IF;
875:

Line 877: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

873: p_parameterlist => l_param_list);
874: END IF;
875:
876: IF(p_RESP_APPL_ID is NULL or p_RESP_APPL_ID = -1) THEN
877: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
878: p_value => FND_GLOBAL.RESP_APPL_ID,
879: p_parameterlist => l_param_list);
880: ELSE
881: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

Line 881: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

877: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
878: p_value => FND_GLOBAL.RESP_APPL_ID,
879: p_parameterlist => l_param_list);
880: ELSE
881: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
882: p_value => p_RESP_APPL_ID,
883: p_parameterlist => l_param_list);
884: END IF;
885: /* Roopa - End - Fix for bug 3360069 */

Line 887: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',

883: p_parameterlist => l_param_list);
884: END IF;
885: /* Roopa - End - Fix for bug 3360069 */
886:
887: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
888: p_value => l_initiator_role,
889: p_parameterlist => l_param_list);
890:
891: -- We need this parameter since manual launch will also unnecessarily launch the

Line 894: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',

890:
891: -- We need this parameter since manual launch will also unnecessarily launch the
892: -- auto-notify workflow. Validation not to process will have to be done in the
893: -- activity of the workflow itself.
894: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
895: p_value => p_wf_manual_launch,
896: p_parameterlist => l_param_list);
897:
898:

Line 941: wf_event.AddParameterToList(p_name => 'SENDER_ROLE',

937: IF l_cs_sr_get_empid_csr%ISOPEN THEN
938: CLOSE l_cs_sr_get_empid_csr;
939: END IF;
940:
941: wf_event.AddParameterToList(p_name => 'SENDER_ROLE',
942: p_value => l_role_name,
943: p_parameterlist=> l_param_list);
944:
945:

Line 951: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',

947:
948: BEGIN
949: l_administrator := FND_PROFILE.VALUE('CS_WF_ADMINISTRATOR');
950:
951: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',
952: p_value => l_administrator,
953: p_parameterlist => l_param_list);
954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN

Line 967: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',

963: INTO l_old_request_status
964: FROM cs_incident_statuses_vl
965: WHERE INCIDENT_STATUS_ID = p_Old_SR_Rec.STATUS_ID;
966:
967: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',
968: p_value => l_old_request_status,
969: p_parameterlist => l_param_list);
970:
971:

Line 982: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_NEW',

978: FROM cs_incident_statuses_vl
979: WHERE INCIDENT_STATUS_ID = p_New_SR_Rec.STATUS_ID;
980:
981:
982: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_NEW',
983: p_value =>l_new_request_status,
984: p_parameterlist => l_param_list);
985: END IF;
986:

Line 1010: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',

1006: */
1007: OPEN l_cs_sr_get_empid_csr(p_Old_SR_Rec.OWNER_ID);
1008: FETCH l_cs_sr_get_empid_csr INTO l_cs_sr_get_empid_rec;
1009: IF (l_cs_sr_get_empid_csr%FOUND) THEN
1010: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
1011: p_value => l_cs_sr_get_empid_rec.source_id,
1012: p_parameterlist => l_param_list);
1013: ELSE
1014: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',

Line 1014: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',

1010: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
1011: p_value => l_cs_sr_get_empid_rec.source_id,
1012: p_parameterlist => l_param_list);
1013: ELSE
1014: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
1015: p_value => p_Old_SR_Rec.OWNER_ID,
1016: p_parameterlist => l_param_list);
1017: END IF;
1018: CLOSE l_cs_sr_get_empid_csr;

Line 1035: wf_event.AddParameterToList(p_name => 'NTFY_LINK_TYPE',

1031: INTO l_link_type_name
1032: FROM CS_SR_LINK_TYPES_VL
1033: WHERE link_type_id = p_Link_Rec.LINK_TYPE_ID;
1034:
1035: wf_event.AddParameterToList(p_name => 'NTFY_LINK_TYPE',
1036: p_value => l_link_type_name,
1037: p_parameterlist => l_param_list);
1038: END IF;
1039:

Line 1051: wf_event.AddParameterToList(p_name => 'NTFY_LINKED_INCIDENT_NUMBER',

1047: ********************************************************/
1048:
1049: IF (p_Link_Rec.OBJECT_NUMBER IS NOT NULL) THEN
1050:
1051: wf_event.AddParameterToList(p_name => 'NTFY_LINKED_INCIDENT_NUMBER',
1052: p_value => p_Link_Rec.OBJECT_NUMBER,
1053: p_parameterlist => l_param_list);
1054: END IF;
1055:

Line 1176: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_NAME',

1172:
1173: END LOOP;
1174:
1175: IF (l_new_contact_point_name IS NOT NULL) THEN
1176: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_NAME',
1177: p_value => l_new_contact_point_name,
1178: p_parameterlist => l_param_list);
1179: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_ID_LIST',
1180: p_value => l_new_contact_point_id,

Line 1179: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_ID_LIST',

1175: IF (l_new_contact_point_name IS NOT NULL) THEN
1176: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_NAME',
1177: p_value => l_new_contact_point_name,
1178: p_parameterlist => l_param_list);
1179: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_ID_LIST',
1180: p_value => l_new_contact_point_id,
1181: p_parameterlist => l_param_list);
1182: END IF;
1183:

Line 1185: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_NAME',

1181: p_parameterlist => l_param_list);
1182: END IF;
1183:
1184: IF (l_new_associated_party_name IS NOT NULL) THEN
1185: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_NAME',
1186: p_value => l_new_associated_party_name,
1187: p_parameterlist => l_param_list);
1188: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_ID_LIST',
1189: p_value => l_new_associated_party_id,

Line 1188: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_ID_LIST',

1184: IF (l_new_associated_party_name IS NOT NULL) THEN
1185: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_NAME',
1186: p_value => l_new_associated_party_name,
1187: p_parameterlist => l_param_list);
1188: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_ID_LIST',
1189: p_value => l_new_associated_party_id,
1190: p_parameterlist => l_param_list);
1191:
1192: -- 523892

Line 1193: wf_event.AddParameterToList(p_name => 'NEW_PARTY_ROLE_NAME',

1189: p_value => l_new_associated_party_id,
1190: p_parameterlist => l_param_list);
1191:
1192: -- 523892
1193: wf_event.AddParameterToList(p_name => 'NEW_PARTY_ROLE_NAME',
1194: p_value => l_new_party_role_name,
1195: p_parameterlist => l_param_list);
1196:
1197: -- 5238921_eof

Line 1211: wf_event.AddParameterToList(p_name => 'PREV_TYPE_ID',

1207:
1208: /* Roopa - begin
1209: Fix for bug # 2809232
1210: */
1211: wf_event.AddParameterToList(p_name => 'PREV_TYPE_ID',
1212: p_value => p_Old_SR_Rec.type_id,
1213: p_parameterlist => l_param_list);
1214:
1215: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',

Line 1215: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',

1211: wf_event.AddParameterToList(p_name => 'PREV_TYPE_ID',
1212: p_value => p_Old_SR_Rec.type_id,
1213: p_parameterlist => l_param_list);
1214:
1215: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',
1216: p_value => p_Old_SR_Rec.severity_id,
1217: p_parameterlist => l_param_list);
1218:
1219: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',

Line 1219: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',

1215: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',
1216: p_value => p_Old_SR_Rec.severity_id,
1217: p_parameterlist => l_param_list);
1218:
1219: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',
1220: p_value => p_Old_SR_Rec.status_id,
1221: p_parameterlist => l_param_list);
1222: --bkanimoz for 12.2 Workflow enhancements
1223: -- Req: To Launch a Workflow when SR status transition happens

Line 1224: wf_event.AddParameterToList(p_name => 'CURR_STATUS_ID',

1220: p_value => p_Old_SR_Rec.status_id,
1221: p_parameterlist => l_param_list);
1222: --bkanimoz for 12.2 Workflow enhancements
1223: -- Req: To Launch a Workflow when SR status transition happens
1224: wf_event.AddParameterToList(p_name => 'CURR_STATUS_ID',
1225: p_value => p_New_SR_Rec.status_id,
1226: p_parameterlist => l_param_list);
1227:
1228: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',

Line 1228: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',

1224: wf_event.AddParameterToList(p_name => 'CURR_STATUS_ID',
1225: p_value => p_New_SR_Rec.status_id,
1226: p_parameterlist => l_param_list);
1227:
1228: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',
1229: p_value => p_Old_SR_Rec.urgency_id,
1230: p_parameterlist => l_param_list);
1231:
1232: wf_event.AddParameterToList(p_name => 'PREV_SUMMARY',

Line 1232: wf_event.AddParameterToList(p_name => 'PREV_SUMMARY',

1228: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',
1229: p_value => p_Old_SR_Rec.urgency_id,
1230: p_parameterlist => l_param_list);
1231:
1232: wf_event.AddParameterToList(p_name => 'PREV_SUMMARY',
1233: p_value => p_Old_SR_Rec.summary,
1234: p_parameterlist => l_param_list);
1235:
1236: /* Roopa - end

Line 1262: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.statuschanged',

1258: EXIT WHEN get_status_id_csr%NOTFOUND;
1259: IF ( p_New_SR_Rec.STATUS_ID =l_status_id ) THEN*/
1260: BEGIN
1261: --RAISE the WF Business event.
1262: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.statuschanged',
1263: p_event_key => l_event_key,
1264: p_parameters => l_param_list);
1265: EXCEPTION -- Added the exception for bug 8849523
1266: WHEN OTHERS THEN

Line 1307: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.reassigned',

1303: -- Construct the unique event key
1304: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1305:
1306: --RAISE the WF Business event.
1307: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.reassigned',
1308: p_event_key => l_event_key,
1309: p_parameters => l_param_list);
1310:
1311: /* Roopa - begin

Line 1339: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.newcontactadded',

1335: -- Construct the unique event key
1336: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1337:
1338: --RAISE the WF Business event.
1339: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.newcontactadded',
1340: p_event_key => l_event_key,
1341: p_parameters => l_param_list);
1342:
1343: END IF;

Line 1356: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.associatedpartyadded',

1352: -- Construct the unique event key
1353: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1354:
1355: --RAISE the WF Business event.
1356: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.associatedpartyadded',
1357: p_event_key => l_event_key,
1358: p_parameters => l_param_list);
1359:
1360: END IF;

Line 1373: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',

1369: /* Roopa - Fix for bug 3528510 */
1370: /* The following 2 parameters are added to the payload so that
1371: the business event wf will catch the non-SR -> SR link scenario
1372: */
1373: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1374: p_value => p_link_rec.subject_type,
1375: p_parameterlist => l_param_list);
1376: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1377: p_value => p_link_rec.object_type,

Line 1376: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',

1372: */
1373: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1374: p_value => p_link_rec.subject_type,
1375: p_parameterlist => l_param_list);
1376: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1377: p_value => p_link_rec.object_type,
1378: p_parameterlist => l_param_list);
1379: l_business_event := 'oracle.apps.cs.sr.ServiceRequest.relationshipcreated';
1380: ELSE

Line 1391: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',

1387: /* Roopa - Fix for bug 3528510 */
1388: /* The following 2 parameters are added to the payload so that
1389: the business event wf will catch the non-SR -> SR link scenario
1390: */
1391: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1392: p_value => p_link_rec.subject_type,
1393: p_parameterlist => l_param_list);
1394: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1395: p_value => p_link_rec.object_type,

Line 1394: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',

1390: */
1391: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1392: p_value => p_link_rec.subject_type,
1393: p_parameterlist => l_param_list);
1394: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1395: p_value => p_link_rec.object_type,
1396: p_parameterlist => l_param_list);
1397: l_business_event := 'oracle.apps.cs.sr.ServiceRequest.relationshipdeleted';
1398: ELSE

Line 1439: wf_event.raise(p_event_name => l_business_event,

1435: --INSERT INTO rm_tmp values (p_Incident_Number, 'Raising WF from event code ',rm_tmp_seq.nextval);
1436: --INSERT INTO rm_tmp values (p_Incident_Number, 'l_business_event='||l_business_event||' ,l_event_key= '|| l_event_key ,rm_tmp_seq.nextval);
1437:
1438:
1439: wf_event.raise(p_event_name => l_business_event,
1440: p_event_key => l_event_key,
1441: p_parameters => l_param_list);
1442:
1443: l_param_list.DELETE;

Line 1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1648: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1649: --l_param_list.DELETE;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1653: 'Raise_ServiceRequest_Event' );
1654: END IF;
1655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1656: p_data => x_msg_data,

Line 1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1660: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1661: --l_param_list.DELETE;
1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1665: 'Raise_ServiceRequest_Event' );
1666: END IF;
1667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1668: p_data => x_msg_data,

Line 1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1694: --dbms_output.put_line('Exception : WHEN OTHERS');
1695: --l_param_list.DELETE;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1699: 'Raise_ServiceRequest_Event' );
1700: END IF;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1702: p_data => x_msg_data,

Line 1745: END CS_WF_EVENT_PKG;

1741:
1742:
1743:
1744:
1745: END CS_WF_EVENT_PKG;