DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on FND_LOG

Line 106: 'CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS',FND_LOG.LEVEL_EXCEPTION);

102:
103: RETURN FALSE;
104: EXCEPTION WHEN OTHERS THEN
105: CSM_UTIL_PKG.log( 'Exception occurred in CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || SQLERRM,
106: 'CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS',FND_LOG.LEVEL_EXCEPTION);
107:
108: RETURN FALSE;
109: END ITEM_EXISTS;
110:

Line 310: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );

306:
307:
308: EXCEPTION WHEN OTHERS THEN
309: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || SQLERRM,
310: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );
311:
312: END APPLY_DIRTY_PUBITEMS;
313:
314: /***

Line 339: csm_util_pkg.log('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i),'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

335: l_return_status);
336:
337: FOR i IN 1..l_pubitems_tbl.count LOOP
338:
339: csm_util_pkg.log('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i),'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
340: -- logm('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i));
341: END LOOP;
342:
343: /*** successfully retrieved item names? ***/

Line 384: || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

380:
381: EXCEPTION WHEN OTHERS THEN
382: /*** catch and log exceptions ***/
383: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.Apply_Client_Changes: ' || sqlerrm
384: || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
385:
386:
387: END APPLY_CLIENT_CHANGES;
388:

Line 411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

407:
408: l_resp_rec l_resp_csr%ROWTYPE;
409:
410: BEGIN
411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
412:
413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);

Line 417: ,FND_LOG.LEVEL_STATEMENT );

413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
416: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
417: ,FND_LOG.LEVEL_STATEMENT );
418: CSM_WF_PKG.User_Resp_Post_Ins(p_user_id => p_userid,
419: p_responsibility_id => l_resp_rec.RESPONSIBILITY_ID );
420: END LOOP;
421: END POPULATE_ACCESS_RECORDS; -- end POPULATE_ACCESS_RECORDS

Line 432: csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

428: */
429: PROCEDURE DELETE_ACCESS_RECORDS ( p_userid in number)
430: IS
431: BEGIN
432: csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
433: CSM_WF_PKG.User_Del(p_user_id => p_userid);
434: END DELETE_ACCESS_RECORDS; -- end DELETE_ACCESS_RECORDS
435:
436: /*

Line 483: 'CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT',FND_LOG.LEVEL_PROCEDURE);

479:
480: FUNCTION detect_conflict(p_user_name IN VARCHAR2) RETURN VARCHAR2 IS
481: BEGIN
482: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT for user ' || p_user_name ,
483: 'CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT',FND_LOG.LEVEL_PROCEDURE);
484:
485: RETURN 'Y' ;
486: EXCEPTION
487: WHEN OTHERS THEN

Line 498: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

494: RETURN VARCHAR2 IS
495: l_profile_value VARCHAR2(30) ;
496: BEGIN
497: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,
498: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
499: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
500:
501: if l_profile_value = 'SERVER_WINS' then
502: RETURN 'S' ;