APPS.CSM_MTL_ITEM_LOC_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 27: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

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

Line 28: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

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

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

162: l_sqlerrmsg := substr(SQLERRM, 1,2000);
163: p_status := 'ERROR';
164: p_message := 'Error in CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_Acc: '|| l_sqlerrno || ':' || l_sqlerrmsg;
165: ROLLBACK;
166: CSM_UTIL_PKG.LOG('CSM_MTL_ITEM_LOC_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_MTL_ITEM_LOC_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
167: END Refresh_Acc;
168:
169: END CSM_MTL_ITEM_LOC_EVENT_PKG;