APPS.CSL_SERVICEL_WRAPPER_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 22: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

18: RETURN BOOLEAN IS
19: l_index BINARY_INTEGER;
20: BEGIN
21:
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'

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

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
31: /*** no items in list -> item name not found ***/

Line 40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

36: IF p_pubitems_tbl( l_index ) = p_item_name THEN
37: /*** found item -> delete from array and return TRUE ***/
38: p_pubitems_tbl.DELETE( l_index );
39:
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'

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

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;
49: END IF;

Line 53: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

49: END IF;
50: END LOOP;
51: /*** item name not found ***/
52:
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'

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

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;
62: EXCEPTION WHEN OTHERS THEN

Line 64: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

60:
61: RETURN FALSE;
62: EXCEPTION WHEN OTHERS THEN
63: /*** catch and log exceptions ***/
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

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

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
73: jtm_message_log_pkg.Log_Msg

Line 72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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
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'

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

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;
81: END ITEM_EXISTS;

Line 99: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

95: l_index BINARY_INTEGER;
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
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'

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

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 ***/
108: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_CS_INCIDENTS_ALL_VL') THEN

Line 109: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

105: END IF;
106:
107: /*** call incident wrapper ***/
108: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_CS_INCIDENTS_ALL_VL') THEN
109: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
110: jtm_message_log_pkg.Log_Msg
111: ( v_object_id => 'CSL_CS_INCIDENTS_ALL_VL'
112: , v_object_name => g_object_name
113: , v_message => 'Calling wrapper for publication item CSL_CS_INCIDENTS_ALL_VL'

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

110: jtm_message_log_pkg.Log_Msg
111: ( v_object_id => 'CSL_CS_INCIDENTS_ALL_VL'
112: , v_object_name => g_object_name
113: , v_message => 'Calling wrapper for publication item CSL_CS_INCIDENTS_ALL_VL'
114: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
115: END IF;
116:
117: CSL_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES
118: (

Line 128: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

124: END IF;
125:
126: /*** call task wrapper ***/
127: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_JTF_TASKS_VL') THEN
128: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
129: jtm_message_log_pkg.Log_Msg
130: ( v_object_id => 'CSL_JTF_TASKS_VL'
131: , v_object_name => g_object_name
132: , v_message => 'Calling wrapper for publication item CSL_JTF_TASKS_VL'

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

129: jtm_message_log_pkg.Log_Msg
130: ( v_object_id => 'CSL_JTF_TASKS_VL'
131: , v_object_name => g_object_name
132: , v_message => 'Calling wrapper for publication item CSL_JTF_TASKS_VL'
133: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
134: END IF;
135:
136: CSL_TASKS_PKG.APPLY_CLIENT_CHANGES
137: (

Line 147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

143: END IF;
144:
145: /*** call task assignment wrapper ***/
146: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_JTF_TASK_ASSIGNMENTS') THEN
147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
148: jtm_message_log_pkg.Log_Msg
149: ( v_object_id => 'CSL_JTF_TASK_ASSIGNMENTS'
150: , v_object_name => g_object_name
151: , v_message => 'Calling wrapper for publication item CSL_JTF_TASK_ASSIGNMENTS'

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

148: jtm_message_log_pkg.Log_Msg
149: ( v_object_id => 'CSL_JTF_TASK_ASSIGNMENTS'
150: , v_object_name => g_object_name
151: , v_message => 'Calling wrapper for publication item CSL_JTF_TASK_ASSIGNMENTS'
152: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
153: END IF;
154:
155: CSL_TASK_ASSIGNMENTS_PKG.APPLY_CLIENT_CHANGES
156: (

Line 168: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

164: /*** call debrief header wrapper ***/
165: IF ITEM_EXISTS( p_pubitems_tbl, 'CSF_DEBRIEF_LINES')
166: OR ITEM_EXISTS( p_pubitems_tbl, 'CSF_DEBRIEF_HEADERS')
167: THEN
168: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
169: jtm_message_log_pkg.Log_Msg
170: ( v_object_id => 'CSF_DEBRIEF_LINES'
171: , v_object_name => g_object_name
172: , v_message => 'Calling wrapper for publication item CSF_DEBRIEF_LINES'

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

169: jtm_message_log_pkg.Log_Msg
170: ( v_object_id => 'CSF_DEBRIEF_LINES'
171: , v_object_name => g_object_name
172: , v_message => 'Calling wrapper for publication item CSF_DEBRIEF_LINES'
173: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
174: END IF;
175:
176: CSL_DEBRIEF_PKG.APPLY_CLIENT_CHANGES
177: (

Line 187: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

183: END IF;
184:
185: /*** call notes wrapper ***/
186: IF ITEM_EXISTS( p_pubitems_tbl, 'JTF_NOTES_VL') THEN
187: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
188: jtm_message_log_pkg.Log_Msg
189: ( v_object_id => 'JTF_NOTES_VL'
190: , v_object_name => g_object_name
191: , v_message => 'Calling wrapper for publication item JTF_NOTES_VL'

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

188: jtm_message_log_pkg.Log_Msg
189: ( v_object_id => 'JTF_NOTES_VL'
190: , v_object_name => g_object_name
191: , v_message => 'Calling wrapper for publication item JTF_NOTES_VL'
192: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
193: END IF;
194:
195: CSL_NOTES_PKG.APPLY_CLIENT_CHANGES
196: (

Line 206: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

202: END IF;
203:
204: /*** call notifications wrapper ***/
205: IF ITEM_EXISTS( p_pubitems_tbl, 'WF_NOTIFICATIONS') THEN
206: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
207: jtm_message_log_pkg.Log_Msg
208: ( v_object_id => 'WF_NOTIFICATIONS'
209: , v_object_name => g_object_name
210: , v_message => 'Calling wrapper for publication item WF_NOTIFICATIONS'

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

207: jtm_message_log_pkg.Log_Msg
208: ( v_object_id => 'WF_NOTIFICATIONS'
209: , v_object_name => g_object_name
210: , v_message => 'Calling wrapper for publication item WF_NOTIFICATIONS'
211: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
212: END IF;
213:
214: CSL_NOTIFICATIONS_PKG.APPLY_CLIENT_CHANGES
215: (

Line 226: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

222:
223:
224: /*** call lobs wrapper ***/
225: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_LOBS') THEN
226: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
227: jtm_message_log_pkg.Log_Msg
228: ( v_object_id => 'CSL_LOBS'
229: , v_object_name => g_object_name
230: , v_message => 'Calling wrapper for publication item CSL_LOBS'

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

227: jtm_message_log_pkg.Log_Msg
228: ( v_object_id => 'CSL_LOBS'
229: , v_object_name => g_object_name
230: , v_message => 'Calling wrapper for publication item CSL_LOBS'
231: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
232: END IF;
233:
234: CSL_LOBS_PKG.APPLY_CLIENT_CHANGES
235: (

Line 246: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

242:
243:
244: /*** call notification attributes wrapper ***/
245: IF ITEM_EXISTS( p_pubitems_tbl, 'WF_NOTIFICATION_ATTR') THEN
246: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => 'WF_NOTIFICATION_ATTR'
249: , v_object_name => g_object_name
250: , v_message => 'Calling wrapper for publication item WF_NOTIFICATION_ATTR'

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

247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => 'WF_NOTIFICATION_ATTR'
249: , v_object_name => g_object_name
250: , v_message => 'Calling wrapper for publication item WF_NOTIFICATION_ATTR'
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
252: END IF;
253:
254: CSL_NOTIFICATION_ATTR_PKG.APPLY_CLIENT_CHANGES
255: (

Line 265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

261: END IF;
262:
263: /*** call requirements wrapper ***/
264: IF ITEM_EXISTS( p_pubitems_tbl, 'CSP_REQUIREMENT_LINES') THEN
265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
266: jtm_message_log_pkg.Log_Msg
267: ( v_object_id => 'CSP_REQUIREMENT_LINES'
268: , v_object_name => g_object_name
269: , v_message => 'Calling wrapper for publication item CSP_REQUIREMENT_LINES'

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

266: jtm_message_log_pkg.Log_Msg
267: ( v_object_id => 'CSP_REQUIREMENT_LINES'
268: , v_object_name => g_object_name
269: , v_message => 'Calling wrapper for publication item CSP_REQUIREMENT_LINES'
270: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
271: END IF;
272:
273: CSL_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES
274: (

Line 284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

280: END IF;
281:
282: /*** call counter wrapper ***/
283: IF ITEM_EXISTS( p_pubitems_tbl, 'CS_COUNTER_VALUES') THEN
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg
286: ( v_object_id => 'CS_COUNTER_VALUES'
287: , v_object_name => g_object_name
288: , v_message => 'Calling wrapper for publication item CS_COUNTER_VALUES'

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

285: jtm_message_log_pkg.Log_Msg
286: ( v_object_id => 'CS_COUNTER_VALUES'
287: , v_object_name => g_object_name
288: , v_message => 'Calling wrapper for publication item CS_COUNTER_VALUES'
289: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
290: END IF;
291:
292: CSL_COUNTER_VALUES_PKG.APPLY_CLIENT_CHANGES
293: (

Line 303: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

299: END IF;
300:
301: /*** call counter properties wrapper ***/
302: IF ITEM_EXISTS( p_pubitems_tbl, 'CS_COUNTER_PROP_VALS') THEN
303: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
304: jtm_message_log_pkg.Log_Msg
305: ( v_object_id => 'CS_COUNTER_PROP_VALS'
306: , v_object_name => g_object_name
307: , v_message => 'Calling wrapper for publication item CS_COUNTER_PROP_VALS'

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

304: jtm_message_log_pkg.Log_Msg
305: ( v_object_id => 'CS_COUNTER_PROP_VALS'
306: , v_object_name => g_object_name
307: , v_message => 'Calling wrapper for publication item CS_COUNTER_PROP_VALS'
308: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
309: END IF;
310:
311: CSL_COUNTER_PROP_VALUES_PKG.APPLY_CLIENT_CHANGES
312: (

Line 322: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

318: END IF;
319:
320: /*** call material transaction wrapper ***/
321: IF ITEM_EXISTS( p_pubitems_tbl, 'MTL_MAT_TRANSACTIONS') THEN
322: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
323: jtm_message_log_pkg.Log_Msg
324: ( v_object_id => 'MTL_MAT_TRANSACTIONS'
325: , v_object_name => g_object_name
326: , v_message => 'Calling wrapper for publication item MTL_MAT_TRANSACTIONS'

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

323: jtm_message_log_pkg.Log_Msg
324: ( v_object_id => 'MTL_MAT_TRANSACTIONS'
325: , v_object_name => g_object_name
326: , v_message => 'Calling wrapper for publication item MTL_MAT_TRANSACTIONS'
327: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
328: END IF;
329:
330: CSL_MATERIAL_TRANSACTION_PKG.APPLY_CLIENT_CHANGES
331: (

Line 344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

340: IF p_pubitems_tbl.COUNT > 0 THEN
341: /*** no -> print publication item names that are still dirty ***/
342: FOR l_index IN p_pubitems_tbl.FIRST..p_pubitems_tbl.LAST LOOP
343: IF p_pubitems_tbl.EXISTS( l_index) THEN
344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_pubitems_tbl(l_index)
347: , v_object_name => g_object_name
348: , v_message => 'No wrapper available for dirty publication item ' || p_pubitems_tbl(l_index)

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

345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_pubitems_tbl(l_index)
347: , v_object_name => g_object_name
348: , v_message => 'No wrapper available for dirty publication item ' || p_pubitems_tbl(l_index)
349: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
350: END IF;
351: END IF;
352: END LOOP;
353: END IF;

Line 355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

351: END IF;
352: END LOOP;
353: END IF;
354:
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'

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

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
364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

360: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
361: END IF;
362:
363: EXCEPTION WHEN OTHERS THEN
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

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

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
373: jtm_message_log_pkg.Log_Msg

Line 372: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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
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'

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

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;
381:

Line 396: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

392: ) IS
393: l_pubitems_tbl asg_apply.vc2_tbl_type;
394: l_return_status VARCHAR2(1);
395: BEGIN
396: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
397:
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

Line 398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

394: l_return_status VARCHAR2(1);
395: BEGIN
396: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
397:
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'

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

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
407: jtm_message_log_pkg.Log_Msg

Line 406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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
407: jtm_message_log_pkg.Log_Msg
408: ( v_object_id => null
409: , v_object_name => g_object_name
410: , v_message => 'Applying changes for user ' || p_user_name ||

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

408: ( v_object_id => null
409: , v_object_name => g_object_name
410: , v_message => 'Applying changes for user ' || p_user_name ||
411: ', tranid = ' || TO_CHAR( p_tranid )
412: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
413: END IF;
414:
415: /*** retrieve names of non-deferred dirty SERVICEL publication items ***/
416: /*** get_all_dirty and get_all_defered_pub_items is replaced by get_all_pub_items ***/

Line 426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

422:
423: /*** successfully retrieved item names? ***/
424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
425: /*** No -> log that no items were retrieved ***/
426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => null
429: , v_object_name => g_object_name
430: , v_message => 'asg_apply.get_all_dirty_pub_items didn''t return any records'

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

427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => null
429: , v_object_name => g_object_name
430: , v_message => 'asg_apply.get_all_dirty_pub_items didn''t return any records'
431: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
432: END IF;
433: ELSE
434: /*** yes -> process them ***/
435: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 435: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

431: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
432: END IF;
433: ELSE
434: /*** yes -> process them ***/
435: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
436: jtm_message_log_pkg.Log_Msg
437: ( v_object_id => null
438: , v_object_name => g_object_name
439: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty non-deferred publication item(s)'

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

436: jtm_message_log_pkg.Log_Msg
437: ( v_object_id => null
438: , v_object_name => g_object_name
439: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty non-deferred publication item(s)'
440: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
441: END IF;
442:
443: APPLY_DIRTY_PUBITEMS
444: ( p_user_name

Line 462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

458:
459: /*** successfully retrieved item names? ***/
460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
461: /*** No -> log that no items were retrieved ***/
462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( v_object_id => null
465: , v_object_name => g_object_name
466: , v_message => 'asg_apply.get_all_deferred_pub_items didn''t return any records'

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

463: jtm_message_log_pkg.Log_Msg
464: ( v_object_id => null
465: , v_object_name => g_object_name
466: , v_message => 'asg_apply.get_all_deferred_pub_items didn''t return any records'
467: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
468: END IF;
469: ELSE
470: /*** yes -> process them ***/
471: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 471: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

467: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
468: END IF;
469: ELSE
470: /*** yes -> process them ***/
471: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
472: jtm_message_log_pkg.Log_Msg
473: ( v_object_id => null
474: , v_object_name => g_object_name
475: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty deferred publication item(s)'

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

472: jtm_message_log_pkg.Log_Msg
473: ( v_object_id => null
474: , v_object_name => g_object_name
475: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty deferred publication item(s)'
476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
477: END IF;
478:
479: APPLY_DIRTY_PUBITEMS
480: ( p_user_name

Line 487: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

483: , l_return_status
484: );
485: END IF;
486:
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'

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

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
496: /*** catch and log exceptions ***/

Line 497: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

493: END IF;
494:
495: EXCEPTION WHEN OTHERS THEN
496: /*** catch and log exceptions ***/
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

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

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
506: jtm_message_log_pkg.Log_Msg

Line 505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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
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'

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

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:
514: /***

Line 537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

533: l_counter NUMBER;
534: l_msg_data VARCHAR2(4000);
535: l_msg_dummy NUMBER;
536: BEGIN
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'

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

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? ***/
546: IF NOT p_api_error THEN

Line 599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

595: END LOOP;
596: END IF;
597: END IF;
598:
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'

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

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
608:

Line 609: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

605: END IF;
606: RETURN l_fnd_message;
607: EXCEPTION WHEN OTHERS THEN
608:
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

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

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
618: jtm_message_log_pkg.Log_Msg

Line 617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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
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'

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

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;
626: END GET_ERROR_MESSAGE_TEXT;

Line 646: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

642: ) IS
643: BEGIN
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
647: jtm_message_log_pkg.Log_Msg
648: ( v_object_id => p_pk
649: , v_object_name => p_object_name
650: , v_message => 'Entering ' || g_object_name || '.DELETE_RECORD'

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

647: jtm_message_log_pkg.Log_Msg
648: ( v_object_id => p_pk
649: , v_object_name => p_object_name
650: , v_message => 'Entering ' || g_object_name || '.DELETE_RECORD'
651: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
652: END IF;
653:
654: asg_apply.delete_row(p_user_name,
655: p_tranid,

Line 669: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

665: p_api_error => TRUE
666: );
667: END IF;
668:
669: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
670: jtm_message_log_pkg.Log_Msg
671: ( v_object_id => p_pk
672: , v_object_name => p_object_name
673: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'

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

670: jtm_message_log_pkg.Log_Msg
671: ( v_object_id => p_pk
672: , v_object_name => p_object_name
673: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
674: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
675: END IF;
676:
677: EXCEPTION WHEN OTHERS THEN
678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

674: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
675: END IF;
676:
677: EXCEPTION WHEN OTHERS THEN
678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
679: jtm_message_log_pkg.Log_Msg
680: ( v_object_id => p_pk
681: , v_object_name => p_object_name
682: , v_message => 'Exception occurred in DELETE_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

679: jtm_message_log_pkg.Log_Msg
680: ( v_object_id => p_pk
681: , v_object_name => p_object_name
682: , v_message => 'Exception occurred in DELETE_RECORD:' || fnd_global.local_chr(10) || sqlerrm
683: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
684: END IF;
685:
686: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', sqlerrm);
687: p_error_msg := GET_ERROR_MESSAGE_TEXT

Line 692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

688: (
689: p_api_error => TRUE
690: );
691:
692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
693: jtm_message_log_pkg.Log_Msg
694: ( v_object_id => p_pk
695: , v_object_name => p_object_name
696: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'

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

693: jtm_message_log_pkg.Log_Msg
694: ( v_object_id => p_pk
695: , v_object_name => p_object_name
696: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
697: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END DELETE_RECORD;
701:

Line 721: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

717: ) IS
718: BEGIN
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
722: jtm_message_log_pkg.Log_Msg
723: ( v_object_id => p_pk
724: , v_object_name => p_object_name
725: , v_message => 'Entering ' || g_object_name || '.DEFER_RECORD'

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

722: jtm_message_log_pkg.Log_Msg
723: ( v_object_id => p_pk
724: , v_object_name => p_object_name
725: , v_message => 'Entering ' || g_object_name || '.DEFER_RECORD'
726: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
727: END IF;
728:
729: asg_defer.defer_row(p_user_name,
730: p_tranid,

Line 738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

734: x_return_status);
735: /*** check if defer was successfull ***/
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: /*** no -> log and return error ***/
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
739: jtm_message_log_pkg.Log_Msg
740: ( v_object_id => p_pk
741: , v_object_name => p_object_name
742: , v_message => 'asg_defer.defer_row failed:' || fnd_global.local_chr(10) || p_error_msg

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

739: jtm_message_log_pkg.Log_Msg
740: ( v_object_id => p_pk
741: , v_object_name => p_object_name
742: , v_message => 'asg_defer.defer_row failed:' || fnd_global.local_chr(10) || p_error_msg
743: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
744: END IF;
745:
746: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
747: jtm_message_log_pkg.Log_Msg

Line 746: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

742: , v_message => 'asg_defer.defer_row failed:' || fnd_global.local_chr(10) || p_error_msg
743: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
744: END IF;
745:
746: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
747: jtm_message_log_pkg.Log_Msg
748: ( v_object_id => p_pk
749: , v_object_name => p_object_name
750: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'

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

747: jtm_message_log_pkg.Log_Msg
748: ( v_object_id => p_pk
749: , v_object_name => p_object_name
750: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
751: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
752: END IF;
753: RETURN;
754: END IF;
755:

Line 758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

754: END IF;
755:
756: /*** defer successful -> reject record except for updates ***/
757: IF p_dml_type = 'I' THEN
758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
759: jtm_message_log_pkg.Log_Msg
760: ( v_object_id => p_pk
761: , v_object_name => p_object_name
762: , v_message => 'Rejecting record'

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

759: jtm_message_log_pkg.Log_Msg
760: ( v_object_id => p_pk
761: , v_object_name => p_object_name
762: , v_message => 'Rejecting record'
763: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
764: END IF;
765:
766: asg_defer.reject_row(p_user_name,
767: p_tranid,

Line 775: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

771: x_return_status);
772: /*** check if reject was successfull ***/
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: /*** no -> log error ***/
775: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
776: jtm_message_log_pkg.Log_Msg
777: ( v_object_id => p_pk
778: , v_object_name => p_object_name
779: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg

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

776: jtm_message_log_pkg.Log_Msg
777: ( v_object_id => p_pk
778: , v_object_name => p_object_name
779: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg
780: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
781: END IF;
782: END IF;
783: END IF;
784:

Line 785: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

781: END IF;
782: END IF;
783: END IF;
784:
785: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
786: jtm_message_log_pkg.Log_Msg
787: ( v_object_id => p_pk
788: , v_object_name => p_object_name
789: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'

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

786: jtm_message_log_pkg.Log_Msg
787: ( v_object_id => p_pk
788: , v_object_name => p_object_name
789: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
791: END IF;
792:
793: EXCEPTION WHEN OTHERS THEN
794: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 794: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
791: END IF;
792:
793: EXCEPTION WHEN OTHERS THEN
794: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
795: jtm_message_log_pkg.Log_Msg
796: ( v_object_id => p_pk
797: , v_object_name => p_object_name
798: , v_message => 'Exception occurred in ' || g_object_name || '.DEFER_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

795: jtm_message_log_pkg.Log_Msg
796: ( v_object_id => p_pk
797: , v_object_name => p_object_name
798: , v_message => 'Exception occurred in ' || g_object_name || '.DEFER_RECORD:' || fnd_global.local_chr(10) || sqlerrm
799: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
800: END IF;
801:
802: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
803: jtm_message_log_pkg.Log_Msg

Line 802: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

798: , v_message => 'Exception occurred in ' || g_object_name || '.DEFER_RECORD:' || fnd_global.local_chr(10) || sqlerrm
799: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
800: END IF;
801:
802: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
803: jtm_message_log_pkg.Log_Msg
804: ( v_object_id => p_pk
805: , v_object_name => p_object_name
806: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'

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

803: jtm_message_log_pkg.Log_Msg
804: ( v_object_id => p_pk
805: , v_object_name => p_object_name
806: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
807: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
808: END IF;
809:
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END DEFER_RECORD;

Line 830: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

826: )IS
827: BEGIN
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
831: jtm_message_log_pkg.Log_Msg
832: ( v_object_id => p_pk
833: , v_object_name => p_object_name
834: , v_message => 'Entering ' || g_object_name || '.REJECT_RECORD'

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

831: jtm_message_log_pkg.Log_Msg
832: ( v_object_id => p_pk
833: , v_object_name => p_object_name
834: , v_message => 'Entering ' || g_object_name || '.REJECT_RECORD'
835: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
836: END IF;
837:
838:
839: asg_defer.reject_row(p_user_name,

Line 849: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

845:
846: /*** check if reject was successfull ***/
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: /*** no -> log error ***/
849: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
850: jtm_message_log_pkg.Log_Msg
851: ( v_object_id => p_pk
852: , v_object_name => p_object_name
853: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg

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

850: jtm_message_log_pkg.Log_Msg
851: ( v_object_id => p_pk
852: , v_object_name => p_object_name
853: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg
854: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
855: END IF;
856: END IF;
857:
858: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 858: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

854: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
855: END IF;
856: END IF;
857:
858: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
859: jtm_message_log_pkg.Log_Msg
860: ( v_object_id => p_pk
861: , v_object_name => p_object_name
862: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'

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

859: jtm_message_log_pkg.Log_Msg
860: ( v_object_id => p_pk
861: , v_object_name => p_object_name
862: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
863: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
864: END IF;
865: EXCEPTION WHEN OTHERS THEN
866: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
867: jtm_message_log_pkg.Log_Msg

Line 866: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

862: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
863: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
864: END IF;
865: EXCEPTION WHEN OTHERS THEN
866: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
867: jtm_message_log_pkg.Log_Msg
868: ( v_object_id => p_pk
869: , v_object_name => p_object_name
870: , v_message => 'Exception occurred in ' || g_object_name || '.REJECT_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

867: jtm_message_log_pkg.Log_Msg
868: ( v_object_id => p_pk
869: , v_object_name => p_object_name
870: , v_message => 'Exception occurred in ' || g_object_name || '.REJECT_RECORD:' || fnd_global.local_chr(10) || sqlerrm
871: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
872: END IF;
873:
874: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
875: jtm_message_log_pkg.Log_Msg

Line 874: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

870: , v_message => 'Exception occurred in ' || g_object_name || '.REJECT_RECORD:' || fnd_global.local_chr(10) || sqlerrm
871: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
872: END IF;
873:
874: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
875: jtm_message_log_pkg.Log_Msg
876: ( v_object_id => p_pk
877: , v_object_name => p_object_name
878: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'

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

875: jtm_message_log_pkg.Log_Msg
876: ( v_object_id => p_pk
877: , v_object_name => p_object_name
878: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
879: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
880: END IF;
881:
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: END REJECT_RECORD;

Line 959: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

955: RETURN BOOLEAN IS
956: PRAGMA AUTONOMOUS_TRANSACTION;
957: l_rc BOOLEAN;
958: BEGIN
959: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
960: jtm_message_log_pkg.Log_Msg
961: ( v_object_id => null
962: , v_object_name => g_object_name
963: , v_message => 'Entering ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'

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

960: jtm_message_log_pkg.Log_Msg
961: ( v_object_id => null
962: , v_object_name => g_object_name
963: , v_message => 'Entering ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'
964: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
965: END IF;
966: l_rc := asg_download.markDirty(
967: P_PUB_ITEM => p_pub_item,
968: P_ACCESSID => p_accessid,

Line 975: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

971: P_TIMESTAMP => p_timestamp
972: );
973: COMMIT;
974:
975: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
976: jtm_message_log_pkg.Log_Msg
977: ( v_object_id => null
978: , v_object_name => g_object_name
979: , v_message => 'Leaving ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'

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

976: jtm_message_log_pkg.Log_Msg
977: ( v_object_id => null
978: , v_object_name => g_object_name
979: , v_message => 'Leaving ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'
980: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
981: END IF;
982:
983: RETURN l_rc;
984: EXCEPTION WHEN OTHERS THEN

Line 985: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

981: END IF;
982:
983: RETURN l_rc;
984: EXCEPTION WHEN OTHERS THEN
985: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
986: jtm_message_log_pkg.Log_Msg
987: ( v_object_id => null
988: , v_object_name => g_object_name
989: , v_message => 'Exception occurred in AUTONOMOUS_MARK_DIRTY.'

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

986: jtm_message_log_pkg.Log_Msg
987: ( v_object_id => null
988: , v_object_name => g_object_name
989: , v_message => 'Exception occurred in AUTONOMOUS_MARK_DIRTY.'
990: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
991: END IF;
992: COMMIT;
993: RETURN FALSE;
994: END AUTONOMOUS_MARK_DIRTY;

Line 1004: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1000: jtm_message_log_pkg.Log_Msg
1001: ( v_object_id => null
1002: , v_object_name => g_object_name
1003: , v_message => 'Entering DETECT_CONFLICT : User '||p_user_name
1004: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1005: );
1006:
1007: RETURN 'Y' ;
1008:

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

1025: ( v_object_id => null
1026: , v_object_name => g_object_name
1027: , v_message => 'Entering CONFLICT_RESOLUTION_HANDLER : User '
1028: ||p_user_name
1029: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1030:
1031: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
1032: IF l_profile_value = 'SERVER_WINS' THEN
1033: RETURN 'S' ;