358:
359: -- Api Modified, version 3.0, new parameters for Assignment Mgr
360: CS_ServiceRequest_PUB.Create_ServiceRequest
361: ( p_api_version => 3.0
362: , p_init_msg_list => FND_API.G_TRUE
363: , p_commit => FND_API.G_TRUE
364: , x_return_status => x_return_status
365: , x_msg_count => l_msg_count
366: , x_msg_data => l_msg_data
359: -- Api Modified, version 3.0, new parameters for Assignment Mgr
360: CS_ServiceRequest_PUB.Create_ServiceRequest
361: ( p_api_version => 3.0
362: , p_init_msg_list => FND_API.G_TRUE
363: , p_commit => FND_API.G_TRUE
364: , x_return_status => x_return_status
365: , x_msg_count => l_msg_count
366: , x_msg_data => l_msg_data
367: , p_user_id => l_user_id
381: , x_individual_type => x_individual_type
382: , x_group_owner => x_group_owner
383: );
384:
385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: /*** exception occurred in API -> return errmsg ***/
387: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
388: (
389: p_api_error => TRUE
420: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
422: END IF;
423:
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: END APPLY_INSERT;
426:
427: /***
428: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.
491:
492: -- Check for Stale data
493: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
494: if l_profile_value = 'SERVER_WINS' AND
495: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE then
496: open c_last_update_date(b_incident_id => p_record.incident_id);
497: fetch c_last_update_date into r_last_update_date;
498: if c_last_update_date%found then
499: if r_last_update_date.last_update_date <> p_record.last_update_date then
518: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
519: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
520: END IF;
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: return;
524: end if;
525: else
526: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
552: then
553: l_ovn := r_ovn.object_version_number;
554: else
555: -- Let the API complain.
556: --l_ovn := FND_API.G_MISS_NUM;
557: -- FND_API.G_MISS_NUM is obsoleted. against GSCC standard
558: l_ovn := -1;
559: end if;
560: close c_ovn;
553: l_ovn := r_ovn.object_version_number;
554: else
555: -- Let the API complain.
556: --l_ovn := FND_API.G_MISS_NUM;
557: -- FND_API.G_MISS_NUM is obsoleted. against GSCC standard
558: l_ovn := -1;
559: end if;
560: close c_ovn;
561:
628: IF p_record.CREDIT_CARD_NUMBER IS NOT NULL THEN
629: open c_credit_card(b_incident_id => p_record.incident_id);
630: fetch c_credit_card into r_credit_card;
631: IF c_credit_card%found AND (
632: NVL(r_credit_card.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) OR
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
629: open c_credit_card(b_incident_id => p_record.incident_id);
630: fetch c_credit_card into r_credit_card;
631: IF c_credit_card%found AND (
632: NVL(r_credit_card.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) OR
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
630: fetch c_credit_card into r_credit_card;
631: IF c_credit_card%found AND (
632: NVL(r_credit_card.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) OR
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
631: IF c_credit_card%found AND (
632: NVL(r_credit_card.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) OR
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
639: THEN
632: NVL(r_credit_card.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_NUMBER,FND_API.G_MISS_CHAR) OR
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
639: THEN
640: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
633: NVL(r_credit_card.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_TYPE_CODE,FND_API.G_MISS_CHAR) OR
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
639: THEN
640: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
641: l_sr_rec.cc_number := l_decript_value;
634: NVL(r_credit_card.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) <> NVL(p_record.CREDIT_CARD_EXPIRATION_DATE,FND_API.G_MISS_DATE) OR
635: NVL(r_credit_card.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_FNAME,FND_API.G_MISS_CHAR) OR
636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
639: THEN
640: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
641: l_sr_rec.cc_number := l_decript_value;
642: l_sr_rec.cc_type_code := p_record.CREDIT_CARD_TYPE_CODE;
657: -- Finally the update itself.
658: -- Api Modified for CS 11.5.9 Uptake Version changed to 3.0
659: CS_ServiceRequest_PUB.Update_ServiceRequest
660: ( p_api_version => 3.0
661: , p_init_msg_list => FND_API.G_TRUE
662: , p_commit => FND_API.G_TRUE
663: , x_return_status => x_return_status
664: , x_msg_count => l_msg_count
665: , x_msg_data => l_msg_data
658: -- Api Modified for CS 11.5.9 Uptake Version changed to 3.0
659: CS_ServiceRequest_PUB.Update_ServiceRequest
660: ( p_api_version => 3.0
661: , p_init_msg_list => FND_API.G_TRUE
662: , p_commit => FND_API.G_TRUE
663: , x_return_status => x_return_status
664: , x_msg_count => l_msg_count
665: , x_msg_data => l_msg_data
666: , p_request_id => p_record.incident_id
674: , x_workflow_process_id => l_workflow_id
675: , x_interaction_id => l_interaction_id
676: );
677:
678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
679: /*** exception occurred in API -> return errmsg ***/
680: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
681: (
682: p_api_error => TRUE
721: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
722: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
723: END IF;
724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: END APPLY_UPDATE;
727:
728: /***
729: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.
737: l_rc BOOLEAN;
738: l_access_id NUMBER;
739: BEGIN
740: /*** initialize return status and message list ***/
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742: FND_MSG_PUB.INITIALIZE;
743:
744: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
745: jtm_message_log_pkg.Log_Msg
790: , p_token_name1 => 'DML'
791: , p_token_value1 => p_record.dmltype$$
792: );
793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: ELSE
796: -- invalid dml type
797: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
798: jtm_message_log_pkg.Log_Msg
808: , p_token_name1 => 'DML'
809: , p_token_value1 => p_record.dmltype$$
810: );
811:
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: END IF;
814:
815: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_access_id := jtm_hook_util_pkg.get_acc_id(
811:
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: END IF;
814:
815: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_access_id := jtm_hook_util_pkg.get_acc_id(
817: p_acc_table_name => 'CSL_CS_INCIDENTS_ALL_ACC',
818: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
819: p_pk1_name => 'INCIDENT_ID',
858: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
859: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
860: END IF;
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END APPLY_RECORD;
864:
865: /***
866: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CSL_CS_INCIDENTS_ALL_VL
879: l_process_status VARCHAR2(1);
880: l_error_msg VARCHAR2(4000);
881: BEGIN
882: g_debug_level := p_debug_level;
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884:
885: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
886: jtm_message_log_pkg.Log_Msg
887: ( v_object_id => null
901: , l_process_status
902: );
903:
904: /*** was record processed successfully? ***/
905: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
906: /*** Yes -> delete record from inqueue ***/
907: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
908: jtm_message_log_pkg.Log_Msg
909: ( v_object_id => r_incident.incident_id
923: l_error_msg,
924: l_process_status
925: );
926: /*** was delete successful? ***/
927: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
929: jtm_message_log_pkg.Log_Msg
930: ( v_object_id => r_incident.incident_id
931: , v_object_name => g_object_name
948: l_error_msg,
949: l_process_status
950: );
951: /*** was delete successful? ***/
952: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
953: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
954: jtm_message_log_pkg.Log_Msg
955: ( v_object_id => r_contacts.SR_CONTACT_POINT_ID
956: , v_object_name => g_object_name
958: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
959: END IF;
960: END IF;
961: END LOOP;
962: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
963: /*** Record was not applied successfully -> defer and reject records ***/
964: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
965: jtm_message_log_pkg.Log_Msg
966: ( v_object_id => r_incident.incident_id
1017: , v_object_name => g_object_name
1018: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
1019: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1020: END IF;
1021: x_return_status := FND_API.G_RET_STS_ERROR;
1022: END APPLY_CLIENT_CHANGES;
1023:
1024: END CSL_SERVICE_REQUESTS_PKG;