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_SERVICEL_WRAPPER_PKG dependencies on CSL_SERVICEL_WRAPPER_PKG

Line 1: PACKAGE BODY CSL_SERVICEL_WRAPPER_PKG AS

1: PACKAGE BODY CSL_SERVICEL_WRAPPER_PKG AS
2: /* $Header: csllwrpb.pls 115.22 2003/08/27 07:34:13 vekrishn ship $ */
3:
4: /*** Globals ***/
5: g_debug_level NUMBER; -- debug level

Line 6: g_object_name CONSTANT VARCHAR2(30) := 'CSL_SERVICEL_WRAPPER_PKG';

2: /* $Header: csllwrpb.pls 115.22 2003/08/27 07:34:13 vekrishn ship $ */
3:
4: /*** Globals ***/
5: g_debug_level NUMBER; -- debug level
6: g_object_name CONSTANT VARCHAR2(30) := 'CSL_SERVICEL_WRAPPER_PKG';
7:
8: /***
9: This function accepts a list of publication items and a publication item name and
10: returns whether the item name was found within the item list.

Line 26: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'

22: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
23: jtm_message_log_pkg.Log_Msg
24: ( v_object_id => null
25: , v_object_name => g_object_name
26: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
27: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
28: END IF;
29:
30: IF p_pubitems_tbl.COUNT <= 0 THEN

Line 44: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'

40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
41: jtm_message_log_pkg.Log_Msg
42: ( v_object_id => null
43: , v_object_name => g_object_name
44: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
45: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
46: END IF;
47: RETURN TRUE;
48: END IF;

Line 57: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'

53: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
54: jtm_message_log_pkg.Log_Msg
55: ( v_object_id => null
56: , v_object_name => g_object_name
57: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
58: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
59: END IF;
60:
61: RETURN FALSE;

Line 68: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || sqlerrm

64: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
65: jtm_message_log_pkg.Log_Msg
66: ( v_object_id => null
67: , v_object_name => g_object_name
68: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || sqlerrm
69: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
70: END IF;
71:
72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 76: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'

72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
73: jtm_message_log_pkg.Log_Msg
74: ( v_object_id => null
75: , v_object_name => g_object_name
76: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
78: END IF;
79:
80: RETURN FALSE;

Line 103: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'

99: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
100: jtm_message_log_pkg.Log_Msg
101: ( v_object_id => null
102: , v_object_name => g_object_name
103: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
104: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
105: END IF;
106:
107: /*** call incident wrapper ***/

Line 359: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'

355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( v_object_id => null
358: , v_object_name => g_object_name
359: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
360: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
361: END IF;
362:
363: EXCEPTION WHEN OTHERS THEN

Line 368: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || sqlerrm

364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
365: jtm_message_log_pkg.Log_Msg
366: ( v_object_id => null
367: , v_object_name => g_object_name
368: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || sqlerrm
369: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
370: END IF;
371:
372: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 376: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'

372: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
373: jtm_message_log_pkg.Log_Msg
374: ( v_object_id => null
375: , v_object_name => g_object_name
376: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
377: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
378: END IF;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: END APPLY_DIRTY_PUBITEMS;

Line 402: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'

398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
399: jtm_message_log_pkg.Log_Msg
400: ( v_object_id => null
401: , v_object_name => g_object_name
402: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
404: END IF;
405:
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 491: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'

487: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
488: jtm_message_log_pkg.Log_Msg
489: ( v_object_id => null
490: , v_object_name => g_object_name
491: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
492: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
493: END IF;
494:
495: EXCEPTION WHEN OTHERS THEN

Line 501: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes:' || fnd_global.local_chr(10) || sqlerrm

497: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
498: jtm_message_log_pkg.Log_Msg
499: ( v_object_id => null
500: , v_object_name => g_object_name
501: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes:' || fnd_global.local_chr(10) || sqlerrm
502: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
503: END IF;
504:
505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 509: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'

505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => null
508: , v_object_name => g_object_name
509: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
511: END IF;
512: END APPLY_CLIENT_CHANGES;
513:

Line 541: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'

537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
538: jtm_message_log_pkg.Log_Msg
539: ( v_object_id => null
540: , v_object_name => g_object_name
541: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
542: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
543: END IF;
544:
545: /*** Is this an API error? ***/

Line 603: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'

599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
600: jtm_message_log_pkg.Log_Msg
601: ( v_object_id => null
602: , v_object_name => g_object_name
603: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
604: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
605: END IF;
606: RETURN l_fnd_message;
607: EXCEPTION WHEN OTHERS THEN

Line 613: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text:' || fnd_global.local_chr(10) || sqlerrm

609: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
610: jtm_message_log_pkg.Log_Msg
611: ( v_object_id => null
612: , v_object_name => g_object_name
613: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text:' || fnd_global.local_chr(10) || sqlerrm
614: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
615: END IF;
616:
617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 621: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'

617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
618: jtm_message_log_pkg.Log_Msg
619: ( v_object_id => null
620: , v_object_name => g_object_name
621: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
622: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
623: END IF;
624:
625: RETURN l_fnd_message;

Line 1043: END CSL_SERVICEL_WRAPPER_PKG;

1039: WHEN OTHERS THEN
1040: RETURN 'C';
1041: END ;
1042:
1043: END CSL_SERVICEL_WRAPPER_PKG;