APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on FND_LOG

Line 76: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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;
80: CLOSE c_lastrundate;

Line 83: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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;
87: CLOSE c_user_id;

Line 96: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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 );
100: END IF;

Line 108: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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:
112: --update--

Line 118: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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 );
122: END IF;

Line 126: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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:
130:

Line 137: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
141: ( ACCESS_ID,

Line 168: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
172: WHERE package_name = g_notes_type_map_pkg_name

Line 181: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
185: l_sqlerrno := TO_CHAR(SQLCODE);