APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 28: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

24: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
25: p_message OUT NOCOPY VARCHAR2)
26: IS
27: PRAGMA AUTONOMOUS_TRANSACTION;
28: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
30: l_dsql varchar2(2048);
31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 29: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

25: p_message OUT NOCOPY VARCHAR2)
26: IS
27: PRAGMA AUTONOMOUS_TRANSACTION;
28: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
30: l_dsql varchar2(2048);
31: l_pub_item VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;

Line 213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);

209: l_sqlerrmsg := substr(SQLERRM, 1,2000);
210: p_status := 'ERROR';
211: p_message := 'Error in CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
212: ROLLBACK;
213: CSM_UTIL_PKG.LOG('CSM_MTL_SEC_LOCATORS_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_SEC_LOCATORS_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
214: END Refresh_Acc;
215:
216: END CSM_MTL_SEC_LOCATORS_EVENT_PKG;