DBA Data[Home] [Help]

APPS.CSM_USER_PKG dependencies on FND_LOG

Line 50: FND_LOG.LEVEL_PROCEDURE);

46: BEGIN
47: csm_util_pkg.log
48: ( g_object_name || '.APPLY_UPDATE entered',
49: g_object_name || '.APPLY_UPDATE',
50: FND_LOG.LEVEL_PROCEDURE);
51:
52: UPDATE ASG_USER
53: SET MIGRATION_COMPLETED = p_record.MIGRATION_COMPLETED,
54: MIGRATION_COMPLETED_DATE = p_record.MIGRATION_COMPLETED_DATE,

Line 74: FND_LOG.LEVEL_PROCEDURE);

70:
71: csm_util_pkg.log
72: ( 'Leaving '|| g_object_name || '.APPLY_UPDATE',
73: g_object_name || '.APPLY_UPDATE',
74: FND_LOG.LEVEL_PROCEDURE);
75:
76: EXCEPTION
77: WHEN others THEN
78: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

Line 81: FND_LOG.LEVEL_EXCEPTION );

77: WHEN others THEN
78: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
79: || ' for PK ' || p_record.user_id,
80: g_object_name || '.APPLY_UPDATE',
81: FND_LOG.LEVEL_EXCEPTION );
82:
83: x_return_status := FND_API.G_RET_STS_ERROR;
84:
85: END APPLY_UPDATE;

Line 119: FND_LOG.LEVEL_ERROR);

115: CSM_UTIL_PKG.LOG
116: ( 'Delete and Insert are not supported for this entity'
117: || ' for PK ' || p_record.user_id ,
118: g_object_name || '.APPLY_RECORD',
119: FND_LOG.LEVEL_ERROR);
120:
121: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
122: (
123: p_message => 'CSM_DML_OPERATION'

Line 138: FND_LOG.LEVEL_EXCEPTION);

134: CSM_UTIL_PKG.LOG
135: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
136: || ' for PK ' || p_record.user_id ,
137: g_object_name || '.APPLY_RECORD',
138: FND_LOG.LEVEL_EXCEPTION);
139:
140: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
141: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
142: (

Line 170: FND_LOG.LEVEL_PROCEDURE);

166: BEGIN
167: csm_util_pkg.log
168: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
169: g_object_name || '.APPLY_CLIENT_CHANGES',
170: FND_LOG.LEVEL_PROCEDURE);
171: g_debug_level := p_debug_level;
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: OPEN c_USER_inq( p_user_name, p_tranid);

Line 212: FND_LOG.LEVEL_ERROR); -- put PK column here

208: CSM_UTIL_PKG.LOG
209: ( 'Deleting from inqueue failed, rolling back to savepoint'
210: || ' for PK ' || r_USER.user_id ,
211: g_object_name || '.APPLY_CLIENT_CHANGES',
212: FND_LOG.LEVEL_ERROR); -- put PK column here
213: ROLLBACK TO save_rec;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: END IF;
216: END IF;

Line 225: FND_LOG.LEVEL_ERROR); -- put PK column here

221: CSM_UTIL_PKG.LOG
222: ( 'Record not processed successfully, deferring and rejecting record'
223: || ' for PK ' || r_USER.user_id ,
224: g_object_name || '.APPLY_CLIENT_CHANGES',
225: FND_LOG.LEVEL_ERROR); -- put PK column here
226:
227: CSM_UTIL_PKG.DEFER_RECORD
228: ( p_user_name
229: , p_tranid

Line 246: FND_LOG.LEVEL_ERROR); -- put PK column here

242: CSM_UTIL_PKG.LOG
243: ( 'Defer record failed, rolling back to savepoint'
244: || ' for PK ' || r_USER.user_id ,
245: g_object_name || '.APPLY_CLIENT_CHANGES',
246: FND_LOG.LEVEL_ERROR); -- put PK column here
247: ROLLBACK TO save_rec;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: END IF;
250: END IF;

Line 259: FND_LOG.LEVEL_EXCEPTION);

255: /*** catch and log exceptions ***/
256: CSM_UTIL_PKG.LOG
257: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
258: g_object_name || '.APPLY_CLIENT_CHANGES',
259: FND_LOG.LEVEL_EXCEPTION);
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: END APPLY_CLIENT_CHANGES;
263: