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_COUNTER_VALUES_PKG dependencies on CSM_UTIL_PKG

Line 44: CSM_UTIL_PKG.LOG

40: AND inq.clid$$cs = b_user_name
41: AND inq.COUNTER_VALUE_ID = b_ctr_val_id;
42: BEGIN
43:
44: CSM_UTIL_PKG.LOG
45: ( 'Entering CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
46: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
47: FND_LOG.LEVEL_STATEMENT); -- put PK column here
48:

Line 54: CSM_UTIL_PKG.DELETE_RECORD

50: -- Loop through this cursor to delete all requirement headers from the requirement header inqueue
51: FOR r_get_ctr_prop_read_from_inq IN c_get_ctr_prop_read_from_inq ( p_user_name, p_tranid, p_ctr_val_id) LOOP
52:
53: -- Delete the requirement header from the requirement header inqueue.
54: CSM_UTIL_PKG.DELETE_RECORD
55: (
56: p_user_name,
57: p_tranid,
58: r_get_ctr_prop_read_from_inq.seqno$$,

Line 70: CSM_UTIL_PKG.LOG

66: /*** was delete successful? ***/
67: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: /*** no -> rollback ***/
69:
70: CSM_UTIL_PKG.LOG
71: ( 'Deleting from inqueue failed, rolling back to savepoinT'|| 'for PK '||r_get_ctr_prop_read_from_inq.counter_prop_value_id,
72: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
73: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
74:

Line 81: CSM_UTIL_PKG.LOG

77:
78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
80:
81: CSM_UTIL_PKG.LOG
82: ( 'Record not processed successfully, deferring and rejecting record'|| 'for PK '|| r_get_ctr_prop_read_from_inq.counter_prop_value_id,
83: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
84: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
85:

Line 87: CSM_UTIL_PKG.DEFER_RECORD

83: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
84: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
85:
86:
87: CSM_UTIL_PKG.DEFER_RECORD
88: (
89: p_user_name
90: , p_tranid
91: , r_get_ctr_prop_read_from_inq.seqno$$

Line 104: CSM_UTIL_PKG.LOG

100: /*** Was defer successful? ***/
101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
102: /*** no -> rollback ***/
103:
104: CSM_UTIL_PKG.LOG
105: ( 'Defer record failed, rolling back to savepoint'|| 'for PK '||r_get_ctr_prop_read_from_inq.counter_prop_value_id,
106: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
107: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
108:

Line 114: CSM_UTIL_PKG.LOG

110: END IF;
111: END IF;
112: END LOOP;
113:
114: CSM_UTIL_PKG.LOG
115: ( 'Leaving CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ ',
116: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
117: FND_LOG.LEVEL_STATEMENT); -- put PK column here
118:

Line 123: CSM_UTIL_PKG.LOG

119:
120: EXCEPTION WHEN OTHERS THEN
121: /*** catch and log exceptions ***/
122:
123: CSM_UTIL_PKG.LOG
124: ( 'Exception occurred in DELETE_PROP_READ_FROM_INQ: '|| FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
125: 'CSM_COUNTER_VALUES_PKG.DELETE_PROP_READ_FROM_INQ',
126: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
127:

Line 180: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

176:
177: BEGIN
178:
179: l_err_msg := 'Entering ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
180: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
181:
182: --anu
183: --initialize return status
184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 262: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

258: CLOSE c_counter_value_id;
259:
260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
261: /*** exception occurred in API -> return errmsg ***/
262: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
263: (
264: p_api_error => TRUE
265: );
266: l_err_msg:= 'Error' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);

Line 267: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

263: (
264: p_api_error => TRUE
265: );
266: l_err_msg:= 'Error' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
267: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
268: END IF;
269:
270: l_err_msg:= 'Leaving ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
271: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line 271: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

267: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
268: END IF;
269:
270: l_err_msg:= 'Leaving ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
271: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
272:
273:
274: EXCEPTION WHEN OTHERS THEN
275: l_err_msg := 'Exception occurred in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm|| ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);

Line 276: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

272:
273:
274: EXCEPTION WHEN OTHERS THEN
275: l_err_msg := 'Exception occurred in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm|| ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
276: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
277:
278:
279: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
280: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 280: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

276: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
277:
278:
279: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
280: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
281: (
282: p_api_error => TRUE
283: );
284:

Line 286: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

282: p_api_error => TRUE
283: );
284:
285: l_err_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char( p_record.COUNTER_VALUE_ID);
286: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
287:
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: END APPLY_INSERT;
290:

Line 341: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE );

337:
338: -- l_server_value_timestamp date;
339: BEGIN
340: l_err_msg := 'Entering ' || g_object_name || '.APPLY_UPDATE' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
341: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE );
342:
343: -- ANURAG Convert the client time to server time before storing in the backend
344: -- l_server_value_timestamp := csm_util_pkg.GetServerTime(
345: -- p_record.value_timestamp, p_record.clid$$cs);

Line 344: -- l_server_value_timestamp := csm_util_pkg.GetServerTime(

340: l_err_msg := 'Entering ' || g_object_name || '.APPLY_UPDATE' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
341: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE );
342:
343: -- ANURAG Convert the client time to server time before storing in the backend
344: -- l_server_value_timestamp := csm_util_pkg.GetServerTime(
345: -- p_record.value_timestamp, p_record.clid$$cs);
346:
347:
348: l_ctr_rdg_rec.counter_value_id := p_record.counter_value_id;

Line 390: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

386: IF(r_counter_value.last_update_date <> p_record.server_last_update_date) THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: l_err_msg:= 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_COUNTER_VALUES_PKG.APPLY_UPDATE: P_KEY = '
389: || p_record.counter_value_id;
390: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
391: p_error_msg := l_err_msg;
392: RETURN;
393: END IF;
394: END IF;

Line 434: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

430: CLOSE c_counter_value_check;
431:
432: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: /*** exception occurred in API -> return errmsg ***/
434: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
435: (
436: p_api_error => TRUE
437: );
438: END IF;

Line 441: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);

437: );
438: END IF;
439:
440: l_err_msg := 'Leaving ' || g_object_name || '.APPLY_UPDATE'|| ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
441: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
442:
443: EXCEPTION WHEN OTHERS THEN
444: l_err_msg:= 'Exception occurred in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm
445: || ' for PK ' || p_record.COUNTER_VALUE_ID;

Line 446: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

442:
443: EXCEPTION WHEN OTHERS THEN
444: l_err_msg:= 'Exception occurred in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm
445: || ' for PK ' || p_record.COUNTER_VALUE_ID;
446: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
447:
448: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
449: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
450: (

Line 449: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

445: || ' for PK ' || p_record.COUNTER_VALUE_ID;
446: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
447:
448: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
449: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
450: (
451: p_api_error => TRUE
452: );
453:

Line 455: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

451: p_api_error => TRUE
452: );
453:
454: l_err_msg := 'Leaving ' || g_object_name || '.APPLY_UPDATE'|| ' for PK ' ||to_char(p_record.COUNTER_VALUE_ID);
455: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
456:
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: END APPLY_UPDATE;
459:

Line 477: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

473: FND_MSG_PUB.INITIALIZE;
474:
475:
476: l_err_msg:= 'Entering ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || to_char(p_record.COUNTER_VALUE_ID);
477: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
478:
479: l_err_msg:= 'Processing ' || g_object_name || ' for PK ' || p_record.COUNTER_VALUE_ID /* put PK column here */ || ' ' ||
480: 'DMLTYPE = ' || p_record.dmltype$$ ;
481: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 481: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

477: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
478:
479: l_err_msg:= 'Processing ' || g_object_name || ' for PK ' || p_record.COUNTER_VALUE_ID /* put PK column here */ || ' ' ||
480: 'DMLTYPE = ' || p_record.dmltype$$ ;
481: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
482:
483: IF p_record.dmltype$$='I' THEN
484: -- Process insert
485: APPLY_INSERT

Line 503: CSM_UTIL_PKG.LOG( l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

499: );
500: ELSIF p_record.dmltype$$='D' THEN
501: -- Process delete; not supported for this entity
502: l_err_msg := 'Delete is not supported for this entity ' || g_object_name;
503: CSM_UTIL_PKG.LOG( l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
504:
505: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
506: (
507: p_message => 'CSM_DML_OPERATION'

Line 505: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

501: -- Process delete; not supported for this entity
502: l_err_msg := 'Delete is not supported for this entity ' || g_object_name;
503: CSM_UTIL_PKG.LOG( l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
504:
505: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
506: (
507: p_message => 'CSM_DML_OPERATION'
508: , p_token_name1 => 'DML'
509: , p_token_value1 => p_record.dmltype$$

Line 516: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

512: x_return_status := FND_API.G_RET_STS_ERROR;
513: ELSE
514: -- invalid dml type
515: l_err_msg := 'Invalid DML type: ' || p_record.dmltype$$ || ' for this entity '|| g_object_name;
516: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
517:
518: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
519: (
520: p_message => 'CSM_DML_OPERATION'

Line 518: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

514: -- invalid dml type
515: l_err_msg := 'Invalid DML type: ' || p_record.dmltype$$ || ' for this entity '|| g_object_name;
516: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
517:
518: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
519: (
520: p_message => 'CSM_DML_OPERATION'
521: , p_token_name1 => 'DML'
522: , p_token_value1 => p_record.dmltype$$

Line 529: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

525: x_return_status := FND_API.G_RET_STS_ERROR;
526: END IF;
527:
528: l_err_msg := 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || to_Char(p_record.COUNTER_VALUE_ID);
529: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
530:
531: EXCEPTION WHEN OTHERS THEN
532: /*** defer record when any process exception occurs ***/
533: l_err_msg:= 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM || ' for PK ' ||to_char( p_record.COUNTER_VALUE_ID);

Line 534: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

530:
531: EXCEPTION WHEN OTHERS THEN
532: /*** defer record when any process exception occurs ***/
533: l_err_msg:= 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM || ' for PK ' ||to_char( p_record.COUNTER_VALUE_ID);
534: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
535:
536: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
537: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
538: (

Line 537: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

533: l_err_msg:= 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM || ' for PK ' ||to_char( p_record.COUNTER_VALUE_ID);
534: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
535:
536: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
537: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
538: (
539: p_api_error => TRUE
540: );
541:

Line 543: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

539: p_api_error => TRUE
540: );
541:
542: l_err_msg := 'Leaving ' || g_object_name || '.APPLY_RECORD'|| ' for PK ' ||to_char(p_record.COUNTER_VALUE_ID);
543: CSM_UTIL_PKG.LOG(l_err_msg,'CSM_COUNTER_VALUES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
544:
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: END APPLY_RECORD;
547:

Line 569: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

565: g_debug_level := p_debug_level;
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: l_error_msg := 'Entering ' || g_object_name || '.Apply_Client_Changes';
569: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
570:
571:
572: /*** loop through CS_COUNTER_VALUES records in inqueue ***/
573: FOR r_CS_COUNTER_VALUES IN c_CS_COUNTER_VALUES( p_user_name, p_tranid) LOOP

Line 590: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

586: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
587: /*** Yes -> delete record from inqueue ***/
588: l_error_msg := 'Record successfully processed, deleting from inqueue ' || g_object_name
589: || ' for PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID;
590: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
591:
592: CSM_UTIL_PKG.DELETE_RECORD
593: (
594: p_user_name,

Line 592: CSM_UTIL_PKG.DELETE_RECORD

588: l_error_msg := 'Record successfully processed, deleting from inqueue ' || g_object_name
589: || ' for PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID;
590: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
591:
592: CSM_UTIL_PKG.DELETE_RECORD
593: (
594: p_user_name,
595: p_tranid,
596: r_CS_COUNTER_VALUES.seqno$$,

Line 609: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

605: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
606: /*** no -> rollback ***/
607: l_error_msg := 'Deleting from inqueue failed, rolling back to savepoint for entity ' || g_object_name
608: || ' and PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID ;
609: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
610:
611: ROLLBACK TO save_rec;
612: END IF;
613: END IF;

Line 619: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

615: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
616: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
617: l_error_msg :='Record not processed successfully, deferring and rejecting record for entity ' || g_object_name
618: || ' and PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID ;
619: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
620:
621: CSM_UTIL_PKG.DEFER_RECORD
622: (
623: p_user_name

Line 621: CSM_UTIL_PKG.DEFER_RECORD

617: l_error_msg :='Record not processed successfully, deferring and rejecting record for entity ' || g_object_name
618: || ' and PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID ;
619: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
620:
621: CSM_UTIL_PKG.DEFER_RECORD
622: (
623: p_user_name
624: , p_tranid
625: , r_CS_COUNTER_VALUES.seqno$$

Line 639: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

635: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
636: /*** no -> rollback ***/
637: l_error_msg :='Defer record failed, rolling back to savepoint for entity ' || g_object_name
638: || ' and PK ' || r_CS_COUNTER_VALUES.COUNTER_VALUE_ID;
639: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
640:
641: ROLLBACK TO save_rec;
642: END IF;
643: END IF;

Line 648: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

644:
645: END LOOP;
646:
647: l_error_msg :='Leaving ' || g_object_name || '.Apply_Client_Changes';
648: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
649:
650:
651: EXCEPTION WHEN OTHERS THEN
652: /*** catch and log exceptions ***/

Line 654: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

650:
651: EXCEPTION WHEN OTHERS THEN
652: /*** catch and log exceptions ***/
653: l_error_msg := 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ;
654: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
655:
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END APPLY_CLIENT_CHANGES;
658: