APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 75: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',

71: l_dummy BOOLEAN;
72:
73: BEGIN
74:
75: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
76: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
77:
78: OPEN c_lastrundate;
79: FETCH c_lastrundate INTO l_lastrundate;

Line 82: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',

78: OPEN c_lastrundate;
79: FETCH c_lastrundate INTO l_lastrundate;
80: CLOSE c_lastrundate;
81:
82: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
83: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
84:
85: OPEN c_user_id;
86: FETCH c_user_id BULK COLLECT INTO l_user_list;

Line 95: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_access_list.count||' records',

91: FETCH c_delete BULK COLLECT INTO l_access_list;
92: CLOSE c_delete;
93:
94:
95: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_access_list.count||' records',
96: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
97:
98: IF l_access_list.COUNT > 0 THEN
99: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'D', sysdate,TRUE );

Line 107: CSM_UTIL_PKG.LOG('DELETION successful',

103: DELETE FROM CSM_NOTES_TYPE_MAPPING_ACC WHERE ACCESS_ID=l_access_list(I);
104:
105:
106:
107: CSM_UTIL_PKG.LOG('DELETION successful',
108: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
109:
110: l_access_list.DELETE;
111:

Line 117: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_access_list.count||' records',

113: OPEN c_update(l_lastrundate.LAST_RUN_DATE);
114: FETCH c_update BULK COLLECT INTO l_access_list;
115: CLOSE c_update;
116:
117: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_access_list.count||' records',
118: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
119:
120: IF l_access_list.COUNT >0 THEN
121: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'U', sysdate,TRUE );

Line 125: CSM_UTIL_PKG.LOG('UPDATE Successful ',

121: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'U', sysdate,TRUE );
122: END IF;
123:
124:
125: CSM_UTIL_PKG.LOG('UPDATE Successful ',
126: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
127:
128: l_access_list.DELETE;
129:

Line 136: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_id_tab.count||' records',

132: OPEN c_insert;
133: FETCH c_insert BULK COLLECT INTO l_id_tab;
134: CLOSE c_insert;
135:
136: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_id_tab.count||' records',
137: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
138:
139: FORALL I IN 1..l_id_tab.COUNT
140: INSERT INTO CSM_NOTES_TYPE_MAPPING_ACC

Line 167: CSM_UTIL_PKG.LOG('INSERTION Successful ',

163: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'I', sysdate,TRUE );
164: END IF;
165:
166:
167: CSM_UTIL_PKG.LOG('INSERTION Successful ',
168: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
169:
170: UPDATE JTM_CON_REQUEST_DATA
171: SET LAST_RUN_DATE = SYSDATE

Line 180: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',

176:
177: p_status := 'FINE';
178: p_message := 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC executed successfully';
179:
180: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
181: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
182:
183: EXCEPTION
184: WHEN OTHERS THEN

Line 190: csm_util_pkg.log('CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

186: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
187: p_status := 'ERROR';
188: p_message := 'Error in CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
189: ROLLBACK;
190: csm_util_pkg.log('CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
191:
192: END REFRESH_ACC;
193:
194: END CSM_NOTES_TYPE_MAP_EVENT_PKG;