APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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