[Home] [Help]
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
390: );
391: END IF;
407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
408: END IF;
409:
410: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
411: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
412: (
413: p_api_error => TRUE
414: );
415:
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
683: );
684: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
708: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
709: END IF;
710:
711: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
712: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
713: (
714: p_api_error => TRUE
715: );
716:
783: , v_message => 'Delete is not supported for this entity'
784: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
785: END IF;
786:
787: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
788: (
789: p_message => 'CSL_DML_OPERATION'
790: , p_token_name1 => 'DML'
791: , p_token_value1 => p_record.dmltype$$
801: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
802: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
803: END IF;
804:
805: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
806: (
807: p_message => 'CSL_DML_OPERATION'
808: , p_token_name1 => 'DML'
809: , p_token_value1 => p_record.dmltype$$
818: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
819: p_pk1_name => 'INCIDENT_ID',
820: p_pk1_num_value => p_record.INCIDENT_ID
821: );
822: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(
823: P_PUB_ITEM => g_pub_name,
824: P_ACCESSID => l_access_id,
825: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
826: P_DML => 'U',
845: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
846: END IF;
847:
848: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
849: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
850: (
851: p_api_error => TRUE
852: );
853:
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
867: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
868: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
869: public APIs.
870: ***/
911: , v_message => 'Record successfully processed, deleting from inqueue'
912: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
913: END IF;
914:
915: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
916: (
917: p_user_name,
918: p_tranid,
919: r_incident.seqno$$,
936:
937:
938: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
939: /* Delete matching contact record(s) */
940: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
941: (
942: p_user_name,
943: p_tranid,
944: r_contacts.seqno$$,
968: , v_message => 'Record not processed successfully, deferring and rejecting records'
969: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
970: END IF;
971:
972: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
973: (
974: p_user_name
975: , p_tranid
976: , r_incident.seqno$$
983: );
984:
985: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
986: /* Defer matching contact record(s) */
987: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
988: (
989: p_user_name,
990: p_tranid,
991: r_contacts.seqno$$,