APPS.CSM_ACC_PKG dependencies on FND_LOG

Line 124: 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_PROCEDURE);

120: END IF;
121:
122: CSM_UTIL_PKG.LOG( l_stmt || fnd_global.local_chr(10) ||
123: ':1 = ' || p_user_id || fnd_global.local_chr(10) || l_error_msg,
124: 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_PROCEDURE);
125:
126:
127: IF p_pk2_name IS NULL THEN
128: EXECUTE IMMEDIATE l_stmt INTO l_access_id USING p_user_id, l_pk1_value;

Line 140: ':1 = ' || p_user_id, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);

136:
137: EXCEPTION
138: WHEN NO_DATA_FOUND THEN
139: CSM_UTIL_PKG.LOG( 'No Access_ID found for Statement:' || l_stmt || fnd_global.local_chr(10) ||
140: ':1 = ' || p_user_id, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);
141: /*** Record doesn't exist ***/
142: RETURN -1;
143: WHEN OTHERS THEN
144: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.GET_ACC_ID' || sqlerrm, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);

Line 144: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.GET_ACC_ID' || sqlerrm, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);

140: ':1 = ' || p_user_id, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);
141: /*** Record doesn't exist ***/
142: RETURN -1;
143: WHEN OTHERS THEN
144: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.GET_ACC_ID' || sqlerrm, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);
145: /*** Raise any other error ***/
146: RAISE;
147: END Get_Acc_Id;
148:

Line 212: CSM_UTIL_PKG.LOG( l_stmt, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

208: ' WHERE ACCESS_ID = :1'; -- ||l_access_id;
209:
210:
211:
212: CSM_UTIL_PKG.LOG( l_stmt, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
213:
214: EXECUTE IMMEDIATE l_stmt using l_access_id;
215:
216: ELSE

Line 296: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

292: END IF;
293:
294: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
295: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_user_id
296: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
297:
298:
299: /*We have at least one PK so get the value*/
300: IF l_pk2_value IS NULL THEN

Line 325: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.INSERT_ACC' || sqlerrm, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);

321: END IF;
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.INSERT_ACC' || sqlerrm, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);
326: /*** Raise any other error ***/
327: RAISE;
328:
329: END Insert_Acc;

Line 443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
440: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
441: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
442: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
444:
445:
446: l_count := dbms_sql.execute( l_cursor );
447: LOOP

Line 540: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.DELETE_ACC' || sqlerrm, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);

536: EXCEPTION WHEN OTHERS THEN
537: IF l_cursor <> 0 THEN
538: dbms_sql.close_cursor( l_cursor );
539: END IF;
540: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.DELETE_ACC' || sqlerrm, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);
541: /*** Raise any other error ***/
542: RAISE;
543: END Delete_Acc;
544:

Line 568: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.UPDATE_ACC' || sqlerrm, 'CSM_ACC_PKG.UPDATE_ACC',FND_LOG.LEVEL_EXCEPTION);

564: END LOOP;
565: END IF;
566: EXCEPTION
567: WHEN OTHERS THEN
568: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_ACC_PKG.UPDATE_ACC' || sqlerrm, 'CSM_ACC_PKG.UPDATE_ACC',FND_LOG.LEVEL_EXCEPTION);
569: /*** Raise any other error ***/
570: RAISE;
571:
572: END Update_Acc;