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.CSL_COUNTER_PROP_VALUES_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 75: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

71:
72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(240);
74: BEGIN
75: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
76: jtm_message_log_pkg.Log_Msg
77: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
78: , v_object_name => g_object_name
79: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

Line 80: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

76: jtm_message_log_pkg.Log_Msg
77: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
78: , v_object_name => g_object_name
79: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
80: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
81: END IF;
82:
83: -- For mobile Field Service we know that a counter_group_id is not
84: -- known, but the counter_id is known. Therefore we need to retrieve

Line 179: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

175: p_api_error => TRUE
176: );
177: END IF;
178:
179: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
180: jtm_message_log_pkg.Log_Msg
181: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
182: , v_object_name => g_object_name
183: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 184: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

180: jtm_message_log_pkg.Log_Msg
181: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
182: , v_object_name => g_object_name
183: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
184: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
185: END IF;
186:
187: EXCEPTION WHEN OTHERS THEN
188: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 188: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

184: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
185: END IF;
186:
187: EXCEPTION WHEN OTHERS THEN
188: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
189: jtm_message_log_pkg.Log_Msg
190: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
191: , v_object_name => g_object_name
192: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

Line 193: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

189: jtm_message_log_pkg.Log_Msg
190: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
191: , v_object_name => g_object_name
192: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
193: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
194: END IF;
195:
196: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
197: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

198: (
199: p_api_error => TRUE
200: );
201:
202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
205: , v_object_name => g_object_name
206: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 207: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

203: jtm_message_log_pkg.Log_Msg
204: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
205: , v_object_name => g_object_name
206: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
207: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
208: END IF;
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END APPLY_INSERT;

Line 246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

242:
243: l_msg_count NUMBER;
244: l_msg_data VARCHAR2(240);
245: BEGIN
246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
249: , v_object_name => g_object_name
250: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

Line 251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
249: , v_object_name => g_object_name
250: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
252: END IF;
253:
254:
255: --Bug 4496299

Line 301: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

297: p_api_error => TRUE
298: );
299: END IF;
300:
301: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
302: jtm_message_log_pkg.Log_Msg
303: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
304: , v_object_name => g_object_name
305: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

302: jtm_message_log_pkg.Log_Msg
303: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
304: , v_object_name => g_object_name
305: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
307: END IF;
308:
309: EXCEPTION WHEN OTHERS THEN
310: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 310: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
307: END IF;
308:
309: EXCEPTION WHEN OTHERS THEN
310: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
313: , v_object_name => g_object_name
314: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

Line 315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
313: , v_object_name => g_object_name
314: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
316: END IF;
317:
318: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
319: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

320: (
321: p_api_error => TRUE
322: );
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
327: , v_object_name => g_object_name
328: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

325: jtm_message_log_pkg.Log_Msg
326: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
327: , v_object_name => g_object_name
328: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END APPLY_UPDATE;

Line 349: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

345: /*** initialize return status and message list ***/
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347: FND_MSG_PUB.INITIALIZE;
348:
349: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
350: jtm_message_log_pkg.Log_Msg
351: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
352: , v_object_name => g_object_name
353: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

Line 354: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

350: jtm_message_log_pkg.Log_Msg
351: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
352: , v_object_name => g_object_name
353: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
354: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
355: END IF;
356:
357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
358: jtm_message_log_pkg.Log_Msg

Line 357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

353: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
354: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
355: END IF;
356:
357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
358: jtm_message_log_pkg.Log_Msg
359: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
360: , v_object_name => g_object_name
361: , v_message => 'Processing CS_COUNTER_PROP_VALS = ' || p_record.COUNTER_PROP_VALUE_ID /* put PK column here */ || fnd_global.local_chr(10) ||

Line 363: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

359: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
360: , v_object_name => g_object_name
361: , v_message => 'Processing CS_COUNTER_PROP_VALS = ' || p_record.COUNTER_PROP_VALUE_ID /* put PK column here */ || fnd_global.local_chr(10) ||
362: 'DMLTYPE = ' || p_record.dmltype$$
363: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
364: END IF;
365:
366: IF p_record.dmltype$$='I' THEN
367: -- Process insert

Line 384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

380: x_return_status
381: );
382: ELSIF p_record.dmltype$$='D' THEN
383: -- Process delete; not supported for this entity
384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
385: jtm_message_log_pkg.Log_Msg
386: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
387: , v_object_name => g_object_name
388: , v_message => 'Delete is not supported for this entity'

Line 389: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

385: jtm_message_log_pkg.Log_Msg
386: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
387: , v_object_name => g_object_name
388: , v_message => 'Delete is not supported for this entity'
389: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
390: END IF;
391:
392: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
393: (

Line 402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

398:
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: ELSE
401: -- invalid dml type
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
405: , v_object_name => g_object_name
406: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

Line 407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
405: , v_object_name => g_object_name
406: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
408: END IF;
409:
410: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
411: (

Line 420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

416:
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: END IF;
419:
420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
423: , v_object_name => g_object_name
424: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
423: , v_object_name => g_object_name
424: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
426: END IF;
427: EXCEPTION WHEN OTHERS THEN
428: /*** defer record when any process exception occurs ***/
429: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 429: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
426: END IF;
427: EXCEPTION WHEN OTHERS THEN
428: /*** defer record when any process exception occurs ***/
429: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
430: jtm_message_log_pkg.Log_Msg
431: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
432: , v_object_name => g_object_name
433: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

Line 434: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

430: jtm_message_log_pkg.Log_Msg
431: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
432: , v_object_name => g_object_name
433: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
434: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
435: END IF;
436:
437: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
438: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 443: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

439: (
440: p_api_error => TRUE
441: );
442:
443: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
446: , v_object_name => g_object_name
447: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
446: , v_object_name => g_object_name
447: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
449: END IF;
450:
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: END APPLY_RECORD;

Line 474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

470: BEGIN
471: g_debug_level := p_debug_level;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
475: jtm_message_log_pkg.Log_Msg
476: ( v_object_id => null
477: , v_object_name => g_object_name
478: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

Line 479: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

475: jtm_message_log_pkg.Log_Msg
476: ( v_object_id => null
477: , v_object_name => g_object_name
478: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
479: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
480: END IF;
481:
482: /*** loop through CS_COUNTER_PROP_VALS records in inqueue ***/
483: FOR r_CS_COUNTER_PROP_VALS IN c_CS_COUNTER_PROP_VALS( p_user_name, p_tranid) LOOP

Line 498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

494:
495: /*** was record processed successfully? ***/
496: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
497: /*** Yes -> delete record from inqueue ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
501: , v_object_name => g_object_name
502: , v_message => 'Record successfully processed, deleting from inqueue'

Line 503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
501: , v_object_name => g_object_name
502: , v_message => 'Record successfully processed, deleting from inqueue'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
504: END IF;
505:
506: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
507: (

Line 521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

517:
518: /*** was delete successful? ***/
519: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
520: /*** no -> rollback ***/
521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
522: jtm_message_log_pkg.Log_Msg
523: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
524: , v_object_name => g_object_name
525: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

Line 526: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

522: jtm_message_log_pkg.Log_Msg
523: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
524: , v_object_name => g_object_name
525: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
526: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
527: END IF;
528: ROLLBACK TO save_rec;
529: END IF;
530: END IF;

Line 534: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

530: END IF;
531:
532: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
533: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
534: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
535: jtm_message_log_pkg.Log_Msg
536: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
537: , v_object_name => g_object_name
538: , v_message => 'Record not processed successfully, deferring and rejecting record'

Line 539: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

535: jtm_message_log_pkg.Log_Msg
536: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
537: , v_object_name => g_object_name
538: , v_message => 'Record not processed successfully, deferring and rejecting record'
539: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
540: END IF;
541:
542: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
543: (

Line 557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

553:
554: /*** Was defer successful? ***/
555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
556: /*** no -> rollback ***/
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
558: jtm_message_log_pkg.Log_Msg
559: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
560: , v_object_name => g_object_name
561: , v_message => 'Defer record failed, rolling back to savepoint'

Line 562: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

558: jtm_message_log_pkg.Log_Msg
559: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
560: , v_object_name => g_object_name
561: , v_message => 'Defer record failed, rolling back to savepoint'
562: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
563: END IF;
564: ROLLBACK TO save_rec;
565: END IF;
566: END IF;

Line 570: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

566: END IF;
567:
568: END LOOP;
569:
570: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
571: jtm_message_log_pkg.Log_Msg
572: ( v_object_id => null
573: , v_object_name => g_object_name
574: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

Line 575: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

571: jtm_message_log_pkg.Log_Msg
572: ( v_object_id => null
573: , v_object_name => g_object_name
574: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
575: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
576: END IF;
577:
578: EXCEPTION WHEN OTHERS THEN
579: /*** catch and log exceptions ***/

Line 580: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

576: END IF;
577:
578: EXCEPTION WHEN OTHERS THEN
579: /*** catch and log exceptions ***/
580: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
581: jtm_message_log_pkg.Log_Msg
582: ( v_object_id => null
583: , v_object_name => g_object_name
584: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

Line 585: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

581: jtm_message_log_pkg.Log_Msg
582: ( v_object_id => null
583: , v_object_name => g_object_name
584: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
585: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
586: END IF;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: END APPLY_CLIENT_CHANGES;
589: