APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on CSM_UTIL_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

172: OPEN c_insert;
173: FETCH c_insert BULK COLLECT INTO l_tab;
174: CLOSE c_insert;
175:
176: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
177: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
178:
179: FOR I IN 1..l_tab.COUNT
180: 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_SRCH_TITLE_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_SRCH_TITLE_EVENT_PKG.REFRESH_ACC executed successfully';
233:
234: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
235: 'CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
236:
237: EXCEPTION
238: WHEN OTHERS THEN

Line 244: csm_util_pkg.log('CSM_AD_SRCH_TITLE_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_SRCH_TITLE_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
243: ROLLBACK;
244: csm_util_pkg.log('CSM_AD_SRCH_TITLE_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
245:
246: END REFRESH_ACC;
247:
248: END CSM_AD_SRCH_TITLE_EVENT_PKG;