APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 26: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

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

Line 27: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

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

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

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