eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_QUERY_INSTANCE_PKG dependencies on CSM_UTIL_PKG

Line 111: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,

107: l_query_type VARCHAR2(255);
108: BEGIN
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,
112: 'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
113: l_query_id := p_record.QUERY_ID;
114: --Check if the Query id is valid
115: OPEN c_check_query(l_query_id);

Line 118: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

114: --Check if the Query id is valid
115: OPEN c_check_query(l_query_id);
116: FETCH c_check_query INTO l_instance_name, l_level_id, l_level_value,l_query_type;
117: IF c_check_query%NOTFOUND THEN
118: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: p_error_msg := 'Invalid Query Id : ' || l_query_id ;
121: CLOSE c_check_query;
122: x_return_status := FND_API.G_RET_STS_ERROR;

Line 140: CSM_UTIL_PKG.LOG

136: x_return_status => x_return_status,
137: x_error_message => l_error_msg);
138:
139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
140: CSM_UTIL_PKG.LOG
141: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || l_instance_name || SQLERRM, 'INSERT_INSTANCE',
142: FND_LOG.LEVEL_EXCEPTION);
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: p_error_msg := 'Query Access Validation failed : ' || l_error_msg;

Line 173: IF csm_util_pkg.is_palm_user(l_user_id) THEN

169: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
170: VALUES (l_instance_id, l_user_id, l_query_id, l_instance_id,l_instance_name,'OPEN',
171: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
172:
173: IF csm_util_pkg.is_palm_user(l_user_id) THEN
174: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_name,
175: p_accessid => l_instance_id, --same as access id
176: p_userid => l_user_id,
177: p_dml => asg_download.ins,

Line 198: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

194: p_commit => fnd_api.G_FALSE,
195: p_source_module => 'MFSCLIENT'
196: );
197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
198: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
199: p_error_msg := 'Query Upload Failed at execution for Instance id : '
200: || l_instance_id || 'With Message' || l_error_msg;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: ROLLBACK TO INSERT_QUERY_INSTANCE;

Line 206: CSM_UTIL_PKG.LOG( 'Leaving INSERT_INSTANCE for Query Id : ' || l_user_id , FND_LOG.LEVEL_ERROR);

202: ROLLBACK TO INSERT_QUERY_INSTANCE;
203: RETURN;
204: END IF;
205:
206: CSM_UTIL_PKG.LOG( 'Leaving INSERT_INSTANCE for Query Id : ' || l_user_id , FND_LOG.LEVEL_ERROR);
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: p_error_msg := 'Leaving INSERT_INSTANCE for Query Id : ' || l_user_id ;
209: RETURN;
210:

Line 219: CSM_UTIL_PKG.LOG

215: FETCH c_get_variables_from_inq BULK COLLECT INTO l_variable_id_inq_lst, l_var_value_char_inq_lst, l_var_value_date_inq_lst, g_seqno_lst;
216: CLOSE c_get_variables_from_inq;
217:
218: IF l_variable_id_lst.COUNT <> l_variable_id_inq_lst.COUNT THEN
219: CSM_UTIL_PKG.LOG
220: ( 'Variable Count mismatch.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
221: FND_LOG.LEVEL_ERROR);
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: p_error_msg := 'Variable Count mismatch.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;

Line 230: CSM_UTIL_PKG.LOG

226: --Check if the values send are proper according to the Type
227: FOR i in 1..l_variable_id_inq_lst.COUNT LOOP
228: IF UPPER(l_var_type_lst(i)) = 'DATE' THEN
229: IF l_var_value_date_inq_lst(i) IS NULL THEN
230: CSM_UTIL_PKG.LOG
231: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
232: FND_LOG.LEVEL_ERROR);
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: p_error_msg := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;

Line 240: CSM_UTIL_PKG.LOG

236: END IF;
237: ELSE
238:
239: IF l_var_value_char_inq_lst(i) IS NULL THEN
240: CSM_UTIL_PKG.LOG
241: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
242: FND_LOG.LEVEL_ERROR);
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: p_error_msg := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;

Line 266: IF csm_util_pkg.is_palm_user(l_user_id) THEN

262: l_instance_id, i, l_var_value_char_inq_lst(i), l_var_value_date_inq_lst(i),
263: l_user_id, SYSDATE, l_user_id, SYSDATE, l_user_id,l_qvariable_id)
264: RETURNING ACCESS_ID into l_access_id;
265:
266: IF csm_util_pkg.is_palm_user(l_user_id) THEN
267: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_qvv_name,
268: p_accessid => l_access_id,
269: p_userid => l_user_id,
270: p_dml => asg_download.ins,

Line 285: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

281: p_commit => fnd_api.G_FALSE,
282: p_source_module => 'MFSCLIENT'
283: );
284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
286: p_error_msg := 'Query Upload Failed at execution for Instance id : '
287: || l_instance_id || ' With Message ' || l_error_msg;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: ROLLBACK TO INSERT_QUERY_INSTANCE;

Line 293: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,

289: ROLLBACK TO INSERT_QUERY_INSTANCE;
290: RETURN;
291: END IF;
292:
293: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,
294: 'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: p_error_msg := 'Upload Successful for the Instance Id : ' || l_instance_id ;
297: RETURN;

Line 301: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

297: RETURN;
298:
299: EXCEPTION WHEN OTHERS THEN
300: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
301: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
302: (
303: p_api_error => TRUE
304: );
305: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

Line 305: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

301: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
302: (
303: p_api_error => TRUE
304: );
305: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
306: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
307: p_error_msg := 'Exception in APPLY_INSERT for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: ROLLBACK TO INSERT_QUERY_INSTANCE;

Line 345: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,

341:
342: BEGIN
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,
346: 'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
347: l_query_id := p_record.QUERY_ID;
348: l_instance_id := p_record.instance_id;
349: --get user_id

Line 361: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);

357: CLOSE c_get_queryid;
358: END IF;
359:
360: IF l_query_id IS NULL THEN
361: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: p_error_msg := 'Delete request failed for Instance Id : ' || l_instance_id || ' as it does not exist.';
364: RETURN;
365: END IF;

Line 377: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);

373: x_return_status => x_return_status,
374: x_error_message => p_error_msg) ;
375:
376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
377: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: RETURN;
380: END IF;
381:

Line 382: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,

378: x_return_status := FND_API.G_RET_STS_ERROR;
379: RETURN;
380: END IF;
381:
382: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,
383: 'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: p_error_msg := 'Delete Successful for the Instance Id : ' || l_instance_id ;
386: RETURN;

Line 390: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT (p_api_error => TRUE);

386: RETURN;
387:
388: EXCEPTION WHEN OTHERS THEN
389: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_DELETE', sqlerrm);
390: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT (p_api_error => TRUE);
391: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || sqlerrm
392: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
393: p_error_msg := 'Exception in APPLY_DELETE for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);
394: x_return_status := FND_API.G_RET_STS_ERROR;

Line 391: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || sqlerrm

387:
388: EXCEPTION WHEN OTHERS THEN
389: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_DELETE', sqlerrm);
390: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT (p_api_error => TRUE);
391: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || sqlerrm
392: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
393: p_error_msg := 'Exception in APPLY_DELETE for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: END APPLY_DELETE;

Line 412: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,

408: /*** initialize return status and message list ***/
409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410: FND_MSG_PUB.INITIALIZE;
411:
412: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
413: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
414:
415: IF p_record.dmltype$$='I' THEN
416: -- Process insert

Line 433: CSM_UTIL_PKG.LOG

429: x_return_status
430: );
431: ELSE -- update is not supported for this PI
432: -- invalid dml type
433: CSM_UTIL_PKG.LOG
434: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
435: || ' for Query Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
436:
437: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 437: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

433: CSM_UTIL_PKG.LOG
434: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
435: || ' for Query Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
436:
437: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
438: (
439: p_message => 'CSM_DML_OPERATION'
440: , p_token_name1 => 'DML'
441: , p_token_value1 => p_record.dmltype$$

Line 447: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,

443:
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: END IF;
446:
447: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
448: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
449: EXCEPTION WHEN OTHERS THEN
450: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
451: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 451: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

447: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
448: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
449: EXCEPTION WHEN OTHERS THEN
450: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
451: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
452: (
453: p_api_error => TRUE
454: );
455: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

Line 455: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

451: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
452: (
453: p_api_error => TRUE
454: );
455: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
456: || ' for Query Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
457:
458: x_return_status := FND_API.G_RET_STS_ERROR;
459:

Line 481: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES ',

477: l_process_status VARCHAR2(1);
478: l_error_msg VARCHAR2(4000);
479:
480: BEGIN
481: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES ',
482: 'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
483: g_debug_level := p_debug_level;
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:

Line 500: CSM_UTIL_PKG.REJECT_RECORD

496:
497: /*** was record processed successfully? ***/
498: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
499: /*** Yes -> delete record from inqueue ***/
500: CSM_UTIL_PKG.REJECT_RECORD
501: (
502: p_user_name,
503: p_tranid,
504: r_qi_rec.seqno$$,

Line 515: CSM_UTIL_PKG.REJECT_RECORD

511: /*** was Instance delete successful? ***/
512: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
513: /*** Yes -> delete Variable Values record from inqueue ***/
514: FOR r_qvv_rec IN c_query_variable_values( p_user_name, p_tranid, r_qi_rec.INSTANCE_ID) LOOP
515: CSM_UTIL_PKG.REJECT_RECORD
516: (
517: p_user_name,
518: p_tranid,
519: r_qvv_rec.seqno$$,

Line 535: CSM_UTIL_PKG.LOG

531:
532: /*** was delete successful? ***/
533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** no -> rollback ***/
535: CSM_UTIL_PKG.LOG
536: ( 'Deleting from inqueue failed, rolling back to savepoint'
537: || ' for Instance ID ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
538: ROLLBACK TO save_rec;
539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 542: CSM_UTIL_PKG.LOG

538: ROLLBACK TO save_rec;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: END IF;
541: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync = 'Y' THEN
542: CSM_UTIL_PKG.LOG
543: ( 'Defer record failed, rolling back to savepoint'
544: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
545: ROLLBACK TO save_rec;
546: x_return_status := FND_API.G_RET_STS_ERROR;

Line 549: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

545: ROLLBACK TO save_rec;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync ='N' THEN
548: /*** Record was not applied successfully -> defer and reject records ***/
549: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
550: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
551:
552: CSM_UTIL_PKG.DEFER_RECORD
553: (

Line 552: CSM_UTIL_PKG.DEFER_RECORD

548: /*** Record was not applied successfully -> defer and reject records ***/
549: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
550: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
551:
552: CSM_UTIL_PKG.DEFER_RECORD
553: (
554: p_user_name
555: , p_tranid
556: , r_qi_rec.seqno$$

Line 569: CSM_UTIL_PKG.DEFER_RECORD

565: /*** was Instance defer successful? ***/
566: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
567: /*** Yes -> defer Variable Values record from inqueue ***/
568: FOR r_qvv_rec IN c_query_variable_values( p_user_name, p_tranid, r_qi_rec.INSTANCE_ID) LOOP
569: CSM_UTIL_PKG.DEFER_RECORD
570: (
571: p_user_name,
572: p_tranid,
573: r_qvv_rec.seqno$$,

Line 591: CSM_UTIL_PKG.LOG

587:
588: /*** Was defer successful? ***/
589: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
590: /*** no -> rollback ***/
591: CSM_UTIL_PKG.LOG
592: ( 'Defer record failed, rolling back to savepoint'
593: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
594: ROLLBACK TO save_rec;
595: x_return_status := FND_API.G_RET_STS_ERROR;

Line 601: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',

597: END IF;
598:
599: END LOOP;
600:
601: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',
602: 'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
603:
604: EXCEPTION WHEN OTHERS THEN
605: /*** catch and log exceptions ***/

Line 606: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

602: 'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
603:
604: EXCEPTION WHEN OTHERS THEN
605: /*** catch and log exceptions ***/
606: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
607: ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
608:
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: