APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on CSM_UTIL_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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