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.11.12010000.4 2008/09/05 03:59:33 mmaiya ship $ */
3:
4: /****************************************************************************************
5:

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

23:
24: ***************************************************************************************/
25:
26: FUNCTION CS_Custom_Rule_Func (p_subscription_guid in raw,
27: p_event in out nocopy WF_EVENT_T) return varchar2 is
28:
29: l_event_name VARCHAR2(240) := p_event.getEventName( );
30: l_request_number VARCHAR2(64);
31: l_event_key VARCHAR2(240);

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

218:
219: --
220: -- WF_CORE.CONTEXT('', '',
221: -- p_event.getEventName( ), p_subscription_guid);
222: -- WF_EVENT.setErrorInfo(p_event, 'WARNING');
223: -- return 'WARNING';
224:
225: EXCEPTION
226:

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

228: WHEN l_UPDATE_FAILED THEN
229: IF sel_workflow_csr%ISOPEN THEN
230: CLOSE sel_workflow_csr;
231: END IF;
232: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
233: l_event_name , p_subscription_guid);
234: WF_EVENT.setErrorInfo(p_event, 'WARNING');
235: return 'WARNING';
236: ******/

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

230: CLOSE sel_workflow_csr;
231: END IF;
232: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
233: l_event_name , p_subscription_guid);
234: WF_EVENT.setErrorInfo(p_event, 'WARNING');
235: return 'WARNING';
236: ******/
237:
238: WHEN others THEN

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

241:
242: IF sel_workflow_csr%ISOPEN THEN
243: CLOSE sel_workflow_csr;
244: END IF;
245: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
246: l_event_name , p_subscription_guid);
247: WF_EVENT.setErrorInfo(p_event, 'ERROR');
248: return 'WARNING';
249:

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

243: CLOSE sel_workflow_csr;
244: END IF;
245: WF_CORE.CONTEXT('CS_WF_EVENT_PKG', 'CS_Custom_Rule_Func',
246: l_event_name , p_subscription_guid);
247: WF_EVENT.setErrorInfo(p_event, 'ERROR');
248: return 'WARNING';
249:
250: END CS_Custom_Rule_Func;
251:

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

537: This section sets the Event Parameter List. These parameters are
538: converted to workflow item attributes.
539: *******************************************************************/
540:
541: wf_event.AddParameterToList(p_name => 'REQUEST_NUMBER',
542: p_value => p_Incident_Number,
543: p_parameterlist => l_param_list);
544:
545: /* Roopa - Begin - Fix for bug 3360069 */

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

544:
545: /* Roopa - Begin - Fix for bug 3360069 */
546: /* Initializing the vars with FND_GLOBAL values if the input vars are null in value */
547: IF(p_USER_ID is NULL or p_USER_ID = -1) THEN
548: wf_event.AddParameterToList(p_name => 'USER_ID',
549: p_value => FND_GLOBAL.USER_ID,
550: p_parameterlist => l_param_list);
551: ELSE
552: wf_event.AddParameterToList(p_name => 'USER_ID',

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

548: wf_event.AddParameterToList(p_name => 'USER_ID',
549: p_value => FND_GLOBAL.USER_ID,
550: p_parameterlist => l_param_list);
551: ELSE
552: wf_event.AddParameterToList(p_name => 'USER_ID',
553: p_value => p_USER_ID,
554: p_parameterlist => l_param_list);
555:
556: END IF;

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

555:
556: END IF;
557:
558: IF(p_RESP_ID is NULL or p_RESP_ID = -1) THEN
559: wf_event.AddParameterToList(p_name => 'RESP_ID',
560: p_value => FND_GLOBAL.RESP_ID,
561: p_parameterlist => l_param_list);
562: ELSE
563: wf_event.AddParameterToList(p_name => 'RESP_ID',

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

559: wf_event.AddParameterToList(p_name => 'RESP_ID',
560: p_value => FND_GLOBAL.RESP_ID,
561: p_parameterlist => l_param_list);
562: ELSE
563: wf_event.AddParameterToList(p_name => 'RESP_ID',
564: p_value => p_RESP_ID,
565: p_parameterlist => l_param_list);
566: END IF;
567:

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

565: p_parameterlist => l_param_list);
566: END IF;
567:
568: IF(p_RESP_APPL_ID is NULL or p_RESP_APPL_ID = -1) THEN
569: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
570: p_value => FND_GLOBAL.RESP_APPL_ID,
571: p_parameterlist => l_param_list);
572: ELSE
573: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

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

569: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
570: p_value => FND_GLOBAL.RESP_APPL_ID,
571: p_parameterlist => l_param_list);
572: ELSE
573: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
574: p_value => p_RESP_APPL_ID,
575: p_parameterlist => l_param_list);
576: END IF;
577: /* Roopa - End - Fix for bug 3360069 */

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

575: p_parameterlist => l_param_list);
576: END IF;
577: /* Roopa - End - Fix for bug 3360069 */
578:
579: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
580: p_value => l_initiator_role,
581: p_parameterlist => l_param_list);
582:
583: -- We need this parameter since manual launch will also unnecessarily launch the

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

582:
583: -- We need this parameter since manual launch will also unnecessarily launch the
584: -- auto-notify workflow. Validation not to process will have to be done in the
585: -- activity of the workflow itself.
586: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
587: p_value => p_wf_manual_launch,
588: p_parameterlist => l_param_list);
589:
590:

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

629: IF l_cs_sr_get_empid_csr%ISOPEN THEN
630: CLOSE l_cs_sr_get_empid_csr;
631: END IF;
632:
633: wf_event.AddParameterToList(p_name => 'SENDER_ROLE',
634: p_value => l_role_name,
635: p_parameterlist=> l_param_list);
636:
637:

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

639:
640: BEGIN
641: l_administrator := FND_PROFILE.VALUE('CS_WF_ADMINISTRATOR');
642:
643: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',
644: p_value => l_administrator,
645: p_parameterlist => l_param_list);
646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN

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

655: INTO l_old_request_status
656: FROM cs_incident_statuses_vl
657: WHERE INCIDENT_STATUS_ID = p_Old_SR_Rec.STATUS_ID;
658:
659: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',
660: p_value => l_old_request_status,
661: p_parameterlist => l_param_list);
662: END IF;
663:

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

683: */
684: OPEN l_cs_sr_get_empid_csr(p_Old_SR_Rec.OWNER_ID);
685: FETCH l_cs_sr_get_empid_csr INTO l_cs_sr_get_empid_rec;
686: IF (l_cs_sr_get_empid_csr%FOUND) THEN
687: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
688: p_value => l_cs_sr_get_empid_rec.source_id,
689: p_parameterlist => l_param_list);
690: ELSE
691: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',

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

687: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
688: p_value => l_cs_sr_get_empid_rec.source_id,
689: p_parameterlist => l_param_list);
690: ELSE
691: wf_event.AddParameterToList(p_name => 'PREV_OWNER_ID',
692: p_value => p_Old_SR_Rec.OWNER_ID,
693: p_parameterlist => l_param_list);
694: END IF;
695: CLOSE l_cs_sr_get_empid_csr;

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

708: INTO l_link_type_name
709: FROM CS_SR_LINK_TYPES_VL
710: WHERE link_type_id = p_Link_Rec.LINK_TYPE_ID;
711:
712: wf_event.AddParameterToList(p_name => 'NTFY_LINK_TYPE',
713: p_value => l_link_type_name,
714: p_parameterlist => l_param_list);
715: END IF;
716:

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

724: ********************************************************/
725:
726: IF (p_Link_Rec.OBJECT_NUMBER IS NOT NULL) THEN
727:
728: wf_event.AddParameterToList(p_name => 'NTFY_LINKED_INCIDENT_NUMBER',
729: p_value => p_Link_Rec.OBJECT_NUMBER,
730: p_parameterlist => l_param_list);
731: END IF;
732:

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

828:
829: END LOOP;
830:
831: IF (l_new_contact_point_name IS NOT NULL) THEN
832: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_NAME',
833: p_value => l_new_contact_point_name,
834: p_parameterlist => l_param_list);
835: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_ID_LIST',
836: p_value => l_new_contact_point_id,

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

831: IF (l_new_contact_point_name IS NOT NULL) THEN
832: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_NAME',
833: p_value => l_new_contact_point_name,
834: p_parameterlist => l_param_list);
835: wf_event.AddParameterToList(p_name => 'NEW_CONTACT_POINT_ID_LIST',
836: p_value => l_new_contact_point_id,
837: p_parameterlist => l_param_list);
838: END IF;
839:

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

837: p_parameterlist => l_param_list);
838: END IF;
839:
840: IF (l_new_associated_party_name IS NOT NULL) THEN
841: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_NAME',
842: p_value => l_new_associated_party_name,
843: p_parameterlist => l_param_list);
844: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_ID_LIST',
845: p_value => l_new_associated_party_id,

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

840: IF (l_new_associated_party_name IS NOT NULL) THEN
841: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_NAME',
842: p_value => l_new_associated_party_name,
843: p_parameterlist => l_param_list);
844: wf_event.AddParameterToList(p_name => 'NEW_ASSOCIATED_PARTY_ID_LIST',
845: p_value => l_new_associated_party_id,
846: p_parameterlist => l_param_list);
847:
848: -- 523892

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

845: p_value => l_new_associated_party_id,
846: p_parameterlist => l_param_list);
847:
848: -- 523892
849: wf_event.AddParameterToList(p_name => 'NEW_PARTY_ROLE_NAME',
850: p_value => l_new_party_role_name,
851: p_parameterlist => l_param_list);
852:
853: -- 5238921_eof

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

863:
864: /* Roopa - begin
865: Fix for bug # 2809232
866: */
867: wf_event.AddParameterToList(p_name => 'PREV_TYPE_ID',
868: p_value => p_Old_SR_Rec.type_id,
869: p_parameterlist => l_param_list);
870:
871: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',

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

867: wf_event.AddParameterToList(p_name => 'PREV_TYPE_ID',
868: p_value => p_Old_SR_Rec.type_id,
869: p_parameterlist => l_param_list);
870:
871: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',
872: p_value => p_Old_SR_Rec.severity_id,
873: p_parameterlist => l_param_list);
874:
875: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',

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

871: wf_event.AddParameterToList(p_name => 'PREV_SEVERITY_ID',
872: p_value => p_Old_SR_Rec.severity_id,
873: p_parameterlist => l_param_list);
874:
875: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',
876: p_value => p_Old_SR_Rec.status_id,
877: p_parameterlist => l_param_list);
878:
879: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',

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

875: wf_event.AddParameterToList(p_name => 'PREV_STATUS_ID',
876: p_value => p_Old_SR_Rec.status_id,
877: p_parameterlist => l_param_list);
878:
879: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',
880: p_value => p_Old_SR_Rec.urgency_id,
881: p_parameterlist => l_param_list);
882:
883: wf_event.AddParameterToList(p_name => 'PREV_SUMMARY',

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

879: wf_event.AddParameterToList(p_name => 'PREV_URGENCY_ID',
880: p_value => p_Old_SR_Rec.urgency_id,
881: p_parameterlist => l_param_list);
882:
883: wf_event.AddParameterToList(p_name => 'PREV_SUMMARY',
884: p_value => p_Old_SR_Rec.summary,
885: p_parameterlist => l_param_list);
886:
887: /* Roopa - end

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

909: EXIT WHEN get_status_id_csr%NOTFOUND;
910: IF ( p_New_SR_Rec.STATUS_ID =l_status_id ) THEN
911:
912: --RAISE the WF Business event.
913: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.statuschanged',
914: p_event_key => l_event_key,
915: p_parameters => l_param_list);
916:
917: /* Roopa - begin

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

950: -- Construct the unique event key
951: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
952:
953: --RAISE the WF Business event.
954: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.reassigned',
955: p_event_key => l_event_key,
956: p_parameters => l_param_list);
957:
958: /* Roopa - begin

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

982: -- Construct the unique event key
983: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
984:
985: --RAISE the WF Business event.
986: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.newcontactadded',
987: p_event_key => l_event_key,
988: p_parameters => l_param_list);
989:
990: END IF;

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

999: -- Construct the unique event key
1000: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1001:
1002: --RAISE the WF Business event.
1003: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.associatedpartyadded',
1004: p_event_key => l_event_key,
1005: p_parameters => l_param_list);
1006:
1007: END IF;

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

1016: /* Roopa - Fix for bug 3528510 */
1017: /* The following 2 parameters are added to the payload so that
1018: the business event wf will catch the non-SR -> SR link scenario
1019: */
1020: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1021: p_value => p_link_rec.subject_type,
1022: p_parameterlist => l_param_list);
1023: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1024: p_value => p_link_rec.object_type,

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

1019: */
1020: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1021: p_value => p_link_rec.subject_type,
1022: p_parameterlist => l_param_list);
1023: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1024: p_value => p_link_rec.object_type,
1025: p_parameterlist => l_param_list);
1026: l_business_event := 'oracle.apps.cs.sr.ServiceRequest.relationshipcreated';
1027: ELSE

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

1034: /* Roopa - Fix for bug 3528510 */
1035: /* The following 2 parameters are added to the payload so that
1036: the business event wf will catch the non-SR -> SR link scenario
1037: */
1038: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1039: p_value => p_link_rec.subject_type,
1040: p_parameterlist => l_param_list);
1041: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1042: p_value => p_link_rec.object_type,

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

1037: */
1038: wf_event.AddParameterToList(p_name => 'LINK_SUBJECT_TYPE',
1039: p_value => p_link_rec.subject_type,
1040: p_parameterlist => l_param_list);
1041: wf_event.AddParameterToList(p_name => 'LINK_OBJECT_TYPE',
1042: p_value => p_link_rec.object_type,
1043: p_parameterlist => l_param_list);
1044: l_business_event := 'oracle.apps.cs.sr.ServiceRequest.relationshipdeleted';
1045: ELSE

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

1082: --INSERT INTO rm_tmp values (p_Incident_Number, 'Raising WF from event code ',rm_tmp_seq.nextval);
1083: --INSERT INTO rm_tmp values (p_Incident_Number, 'l_business_event='||l_business_event||' ,l_event_key= '|| l_event_key ,rm_tmp_seq.nextval);
1084:
1085:
1086: wf_event.raise(p_event_name => l_business_event,
1087: p_event_key => l_event_key,
1088: p_parameters => l_param_list);
1089:
1090: l_param_list.DELETE;

Line 1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1294: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1295: --l_param_list.DELETE;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1299: 'Raise_ServiceRequest_Event' );
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1302: p_data => x_msg_data,

Line 1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1306: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1307: --l_param_list.DELETE;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1311: 'Raise_ServiceRequest_Event' );
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1314: p_data => x_msg_data,

Line 1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1340: --dbms_output.put_line('Exception : WHEN OTHERS');
1341: --l_param_list.DELETE;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1345: 'Raise_ServiceRequest_Event' );
1346: END IF;
1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1348: p_data => x_msg_data,

Line 1391: END CS_WF_EVENT_PKG;

1387: ***************************/
1388:
1389:
1390:
1391: END CS_WF_EVENT_PKG;