APPS.CSM_USER_PKG dependencies on CSM_UTIL_PKG

Line 47: csm_util_pkg.log

43: l_resp_app VARCHAR2(5);
44: l_resp_key VARCHAR2(20):='CSL_IMOBILE' ;
45: l_security_group VARCHAR2(20) :='STANDARD' ;
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:

Line 71: csm_util_pkg.log

67:
68: -- success
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 78: CSM_UTIL_PKG.log( 'Exception in ' || 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:'
79: || ' for PK ' || p_record.user_id,
80: g_object_name || '.APPLY_UPDATE',
81: FND_LOG.LEVEL_EXCEPTION );
82:

Line 115: CSM_UTIL_PKG.LOG

111: );
112: ELSE
113: -- Process delete and insert;
114: -- Not supported for this entity
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);

Line 121: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
124: , p_token_name1 => 'DML'
125: , p_token_value1 => p_record.dmltype$$

Line 134: CSM_UTIL_PKG.LOG

130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: /*** defer record when any process exception occurs ***/
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);

Line 141: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
143: p_api_error => TRUE
144: );
145:

Line 167: csm_util_pkg.log

163: l_process_status VARCHAR2(1);
164: l_error_msg VARCHAR2(4000);
165: r_user c_user_inq%ROWTYPE;
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;

Line 193: CSM_UTIL_PKG.DELETE_RECORD

189:
190: /*** was record processed successfully? ***/
191: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
192: /*** If Yes -> delete record from inqueue ***/
193: CSM_UTIL_PKG.DELETE_RECORD
194: (
195: p_user_name,
196: p_tranid,
197: r_USER.seqno$$,

Line 208: CSM_UTIL_PKG.LOG

204:
205: /*** was delete successful? ***/
206: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
207: /*** If No -> rollback ***/
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

Line 221: CSM_UTIL_PKG.LOG

217:
218: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
219: /*** Record was not processed successfully or delete failed
220: -> defer and reject record ***/
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

Line 227: CSM_UTIL_PKG.DEFER_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
230: , r_USER.seqno$$
231: , r_USER.user_id

Line 242: CSM_UTIL_PKG.LOG

238:
239: /*** Was defer successful? ***/
240: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
241: /*** no -> rollback ***/
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

Line 256: CSM_UTIL_PKG.LOG

252: END IF;
253:
254: EXCEPTION WHEN OTHERS THEN
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;