APPS.CSM_ACC_PKG dependencies on CSM_UTIL_PKG

Line 122: CSM_UTIL_PKG.LOG( l_stmt || fnd_global.local_chr(10) ||

118: end if;
119: END IF;
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:

Line 139: CSM_UTIL_PKG.LOG( 'No Access_ID found for Statement:' || l_stmt || fnd_global.local_chr(10) ||

135: RETURN l_access_id;
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

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 294: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||

290: end if;
291: END IF;
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:

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 439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||

435: dbms_sql.define_array( l_cursor, 1, l_tab_mobile_user_id, 10, l_index);
436: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
437:
438:
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);

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;