APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on CSM_UTIL_PKG

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

95: l_sqlerrmsg VARCHAR2(4000);
96:
97: BEGIN
98:
99: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
100: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
101:
102: OPEN c_lastrundate;
103: FETCH c_lastrundate INTO l_lastrundate;

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

102: OPEN c_lastrundate;
103: FETCH c_lastrundate INTO l_lastrundate;
104: CLOSE c_lastrundate;
105:
106: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
107: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
108:
109: OPEN c_get_user_list;
110: FETCH c_get_user_list BULK COLLECT INTO l_user_list;

Line 113: CSM_UTIL_PKG.LOG('Got USER list : ',

109: OPEN c_get_user_list;
110: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
111: CLOSE c_get_user_list;
112:
113: CSM_UTIL_PKG.LOG('Got USER list : ',
114: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
115:
116: --delete--
117: OPEN c_delete;

Line 121: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',

117: OPEN c_delete;
118: FETCH c_delete BULK COLLECT INTO l_tab;
119: CLOSE c_delete;
120:
121: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
122: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
123:
124: FOR I IN 1..l_tab.COUNT
125: LOOP

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

131: END LOOP;
132:
133: COMMIT;
134:
135: CSM_UTIL_PKG.LOG('DELETION successful',
136: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
137:
138: IF l_tab.COUNT > 0 THEN
139: l_tab.DELETE;

Line 147: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',

143: OPEN c_update(l_lastrundate.Last_run_date);
144: FETCH c_update BULK COLLECT INTO l_tab;
145: CLOSE c_update;
146:
147: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
148: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
149:
150: FOR I IN 1..l_tab.COUNT
151: LOOP

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

162: END LOOP;
163:
164: COMMIT;
165:
166: CSM_UTIL_PKG.LOG('UPDATE Successful ',
167: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
168: IF l_tab.COUNT > 0 THEN
169: l_tab.DELETE;
170: END IF;

Line 177: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',

173: OPEN c_insert;
174: FETCH c_insert BULK COLLECT INTO l_tab;
175: CLOSE c_insert;
176:
177: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
178: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
179:
180: FOR I IN 1..l_tab.COUNT
181: LOOP

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

217: IF l_tab.COUNT > 0 THEN
218: l_tab.DELETE;
219: END IF;
220:
221: CSM_UTIL_PKG.LOG('INSERTION Successful ',
222: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
223:
224: UPDATE JTM_CON_REQUEST_DATA
225: SET LAST_RUN_DATE = SYSDATE

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

230:
231: p_status := 'FINE';
232: p_message := 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC executed successfully';
233:
234: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
235: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
236:
237: EXCEPTION
238: WHEN OTHERS THEN

Line 244: csm_util_pkg.log('CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

240: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
241: p_status := 'ERROR';
242: p_message := 'Error in CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
243: ROLLBACK;
244: csm_util_pkg.log('CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
245:
246: END REFRESH_ACC;
247:
248: END CSM_AD_SRCH_REGION_EVENT_PKG;