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_JTF_TASKS_ACC_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

2: /* $Header: csltkacb.pls 120.0 2005/05/24 17:32:14 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASKS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASKS_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASKS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ID';
10:

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASKS_VL');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASKS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASKS_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASKS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ID';
10:
11: g_debug_level NUMBER; -- debug level

Line 56: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

52: r_private_task_type c_private_task_type%ROWTYPE;
53:
54: BEGIN
55: /*** get debug level ***/
56: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
57:
58: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
59: jtm_message_log_pkg.Log_Msg
60: ( p_task_id

Line 58: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

54: BEGIN
55: /*** get debug level ***/
56: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
57:
58: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
59: jtm_message_log_pkg.Log_Msg
60: ( p_task_id
61: , g_table_name
62: , 'Entering Replicate_Record'

Line 63: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

59: jtm_message_log_pkg.Log_Msg
60: ( p_task_id
61: , g_table_name
62: , 'Entering Replicate_Record'
63: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
64: END IF;
65:
66: OPEN c_task( p_task_id );
67: FETCH c_task INTO r_task;

Line 70: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

66: OPEN c_task( p_task_id );
67: FETCH c_task INTO r_task;
68: IF c_task%NOTFOUND THEN
69: /*** could not find task record -> exit ***/
70: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
71: jtm_message_log_pkg.Log_Msg
72: ( p_task_id
73: , g_table_name
74: , 'Replicate_Record error: Could not find task_id ' || p_task_id

Line 75: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

71: jtm_message_log_pkg.Log_Msg
72: ( p_task_id
73: , g_table_name
74: , 'Replicate_Record error: Could not find task_id ' || p_task_id
75: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
76: END IF;
77:
78: CLOSE c_task;
79: RETURN FALSE;

Line 86: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

82:
83: /*** is this a SR or personal (trip) task? ***/
84: IF r_task.source_object_type_code NOT IN ('TASK', 'SR') THEN
85: /*** no -> don't replicate ***/
86: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
87: jtm_message_log_pkg.Log_Msg
88: ( p_task_id
89: , g_table_name
90: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

Line 92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

88: ( p_task_id
89: , g_table_name
90: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
91: 'SOURCE_OBJECT_TYPE CODE NOT IN (''SR'',''TASK'')'
92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
93: END IF;
94: RETURN FALSE;
95: END IF;
96:

Line 101: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

97: /*** check if scheduled start and end dates are not null ***/
98: IF r_task.scheduled_start_date IS NULL OR
99: r_task.scheduled_end_date IS NULL THEN
100: /*** no -> don't replicate ***/
101: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
102: jtm_message_log_pkg.Log_Msg
103: ( p_task_id
104: , g_table_name
105: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||

Line 107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

103: ( p_task_id
104: , g_table_name
105: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
106: 'SCHEDULED_START_DATE and SCHEDULED_END_DATE should both be NOT NULL.'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
108: END IF;
109: RETURN FALSE;
110: END IF;
111:

Line 121: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

117: FETCH c_task_type INTO r_task_type;
118: IF c_task_type%NOTFOUND THEN
119: /*** no -> don't replicate ***/
120: CLOSE c_task_type;
121: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
122: jtm_message_log_pkg.Log_Msg
123: ( p_task_id
124: , g_table_name
125: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||

Line 127: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

123: ( p_task_id
124: , g_table_name
125: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
126: 'Task''s task type RULE <> ''DISPATCH''.'
127: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
128: END IF;
129: RETURN FALSE;
130: END IF;
131: CLOSE c_task_type;

Line 139: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

135: FETCH c_task_status INTO r_task_status;
136: IF c_task_status%NOTFOUND THEN
137: /*** no -> don't replicate ***/
138: CLOSE c_task_status;
139: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
140: jtm_message_log_pkg.Log_Msg
141: ( p_task_id
142: , g_table_name
143: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||

Line 146: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

142: , g_table_name
143: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
144: 'Task status for SR tasks should have either ASSIGNED_FLAG, CANCELLED_FLAG, '||
145: 'COMPLETED_FLAG or CLOSED_FLAG set to ''Y''.'
146: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
147: END IF;
148: RETURN FALSE;
149: END IF;
150: CLOSE c_task_status;

Line 161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

157: FETCH c_private_task_type INTO r_private_task_type;
158: IF c_private_task_type%NOTFOUND THEN
159: /*** no -> don't replicate ***/
160: CLOSE c_private_task_type;
161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_task_id
164: , g_table_name
165: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||

Line 167: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

163: ( p_task_id
164: , g_table_name
165: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
166: 'Task''s task type private flag <> ''Y''.'
167: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
168: END IF;
169: RETURN FALSE;
170: END IF;
171: CLOSE c_private_task_type;

Line 174: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

170: END IF;
171: CLOSE c_private_task_type;
172: END IF;
173:
174: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
175: jtm_message_log_pkg.Log_Msg
176: ( p_task_id
177: , g_table_name
178: , 'Replicate_Record returned TRUE'

Line 179: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

175: jtm_message_log_pkg.Log_Msg
176: ( p_task_id
177: , g_table_name
178: , 'Replicate_Record returned TRUE'
179: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
180: END IF;
181:
182: /** Record matched criteria -> return true ***/
183: RETURN TRUE;

Line 224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

220:
221: r_task c_task%ROWTYPE;
222:
223: BEGIN
224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
225: jtm_message_log_pkg.Log_Msg
226: ( p_task_id
227: , g_table_name
228: , 'Entering Insert_ACC_Record'

Line 229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

225: jtm_message_log_pkg.Log_Msg
226: ( p_task_id
227: , g_table_name
228: , 'Entering Insert_ACC_Record'
229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
233: jtm_message_log_pkg.Log_Msg

Line 232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

228: , 'Entering Insert_ACC_Record'
229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
233: jtm_message_log_pkg.Log_Msg
234: ( p_task_id
235: , g_table_name
236: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

233: jtm_message_log_pkg.Log_Msg
234: ( p_task_id
235: , g_table_name
236: , 'Inserting ACC record for resource_id = ' || p_resource_id
237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
238: END IF;
239:
240: /*** Insert task ACC record ***/
241: JTM_HOOK_UTIL_PKG.Insert_Acc

Line 241: JTM_HOOK_UTIL_PKG.Insert_Acc

237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
238: END IF;
239:
240: /*** Insert task ACC record ***/
241: JTM_HOOK_UTIL_PKG.Insert_Acc
242: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
243: ,P_ACC_TABLE_NAME => g_acc_table_name
244: ,P_PK1_NAME => g_pk1_name
245: ,P_PK1_NUM_VALUE => p_task_id

Line 250: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

246: ,P_RESOURCE_ID => p_resource_id
247: );
248:
249: /*Insert the non critical dependant record*/
250: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
251: jtm_message_log_pkg.Log_Msg
252: ( p_task_id
253: , g_table_name
254: , 'Inserting non-critical dependant records'

Line 255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

251: jtm_message_log_pkg.Log_Msg
252: ( p_task_id
253: , g_table_name
254: , 'Inserting non-critical dependant records'
255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
256: END IF;
257:
258: /*Do not replicate notes for history tasks*/
259: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

Line 286: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

282: END IF;
283: CLOSE c_task;
284:
285:
286: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
287: jtm_message_log_pkg.Log_Msg
288: ( p_task_id
289: , g_table_name
290: , 'Leaving Insert_ACC_Record'

Line 291: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

287: jtm_message_log_pkg.Log_Msg
288: ( p_task_id
289: , g_table_name
290: , 'Leaving Insert_ACC_Record'
291: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
292: END IF;
293: END Insert_ACC_Record;
294:
295: /*** Private procedure that re-sends given task to mobile ***/

Line 303: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

299: ,p_acc_id IN NUMBER
300: )
301: IS
302: BEGIN
303: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
304: jtm_message_log_pkg.Log_Msg
305: ( p_task_id
306: , g_table_name
307: , 'Entering Update_ACC_Record'

Line 308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

304: jtm_message_log_pkg.Log_Msg
305: ( p_task_id
306: , g_table_name
307: , 'Entering Update_ACC_Record'
308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
309: END IF;
310:
311: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
312: jtm_message_log_pkg.Log_Msg

Line 311: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

307: , 'Entering Update_ACC_Record'
308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
309: END IF;
310:
311: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_task_id
314: , g_table_name
315: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||

Line 317: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

313: ( p_task_id
314: , g_table_name
315: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
316: 'access_id = ' || p_acc_id
317: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
318: END IF;
319:
320: JTM_HOOK_UTIL_PKG.Update_Acc
321: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 320: JTM_HOOK_UTIL_PKG.Update_Acc

316: 'access_id = ' || p_acc_id
317: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
318: END IF;
319:
320: JTM_HOOK_UTIL_PKG.Update_Acc
321: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
322: ,P_ACC_TABLE_NAME => g_acc_table_name
323: ,P_RESOURCE_ID => p_resource_id
324: ,P_ACCESS_ID => p_acc_id

Line 327: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

323: ,P_RESOURCE_ID => p_resource_id
324: ,P_ACCESS_ID => p_acc_id
325: );
326:
327: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
328: jtm_message_log_pkg.Log_Msg
329: ( p_task_id
330: , g_table_name
331: , 'Leaving Update_ACC_Record'

Line 332: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

328: jtm_message_log_pkg.Log_Msg
329: ( p_task_id
330: , g_table_name
331: , 'Leaving Update_ACC_Record'
332: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
333: END IF;
334: END Update_ACC_Record;
335:
336: /*** Private procedure that deletes task for resource from acc table ***/

Line 351: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

347:
348: r_task c_task%ROWTYPE;
349:
350: BEGIN
351: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
352: jtm_message_log_pkg.Log_Msg
353: ( p_task_id
354: , g_table_name
355: , 'Entering Delete_ACC_Record'

Line 356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

352: jtm_message_log_pkg.Log_Msg
353: ( p_task_id
354: , g_table_name
355: , 'Entering Delete_ACC_Record'
356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
357: END IF;
358:
359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
360: jtm_message_log_pkg.Log_Msg

Line 359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

355: , 'Entering Delete_ACC_Record'
356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
357: END IF;
358:
359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
360: jtm_message_log_pkg.Log_Msg
361: ( p_task_id
362: , g_table_name
363: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 364: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

360: jtm_message_log_pkg.Log_Msg
361: ( p_task_id
362: , g_table_name
363: , 'Deleting ACC record for resource_id = ' || p_resource_id
364: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
365: END IF;
366:
367: /*** Delete task ACC record ***/
368: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 368: JTM_HOOK_UTIL_PKG.Delete_Acc

364: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
365: END IF;
366:
367: /*** Delete task ACC record ***/
368: JTM_HOOK_UTIL_PKG.Delete_Acc
369: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
370: ,P_ACC_TABLE_NAME => g_acc_table_name
371: ,P_PK1_NAME => g_pk1_name
372: ,P_PK1_NUM_VALUE => p_task_id

Line 376: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

372: ,P_PK1_NUM_VALUE => p_task_id
373: ,P_RESOURCE_ID => p_resource_id
374: );
375:
376: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
377: jtm_message_log_pkg.Log_Msg
378: ( p_task_id
379: , g_table_name
380: , 'Deleting Non-critical dependant records'

Line 381: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

377: jtm_message_log_pkg.Log_Msg
378: ( p_task_id
379: , g_table_name
380: , 'Deleting Non-critical dependant records'
381: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
382: END IF;
383:
384: /*Notes are not replicated for history so we do not need to delete them*/
385: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

Line 410: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

406:
407: END IF;
408: CLOSE c_task;
409:
410: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
411: jtm_message_log_pkg.Log_Msg
412: ( p_task_id
413: , g_table_name
414: , 'Leaving Delete_ACC_Record'

Line 415: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

411: jtm_message_log_pkg.Log_Msg
412: ( p_task_id
413: , g_table_name
414: , 'Leaving Delete_ACC_Record'
415: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
416: END IF;
417: END Delete_ACC_Record;
418:
419: /***

Line 434: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

430: l_success BOOLEAN;
431: l_incident_id NUMBER;
432: BEGIN
433: /*** get debug level ***/
434: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
435:
436: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
437: jtm_message_log_pkg.Log_Msg
438: ( p_task_id

Line 436: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

432: BEGIN
433: /*** get debug level ***/
434: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
435:
436: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
437: jtm_message_log_pkg.Log_Msg
438: ( p_task_id
439: , g_table_name
440: , 'Entering Pre_Insert_Child procedure'

Line 441: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

437: jtm_message_log_pkg.Log_Msg
438: ( p_task_id
439: , g_table_name
440: , 'Entering Pre_Insert_Child procedure'
441: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
442: END IF;
443:
444: l_success := FALSE;
445:

Line 477: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

473: , p_flow_type
474: );
475: END IF;
476:
477: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
478: jtm_message_log_pkg.Log_Msg
479: ( p_task_id
480: , g_table_name
481: , 'Leaving Pre_Insert_Child procedure'

Line 482: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

478: jtm_message_log_pkg.Log_Msg
479: ( p_task_id
480: , g_table_name
481: , 'Leaving Pre_Insert_Child procedure'
482: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
483: END IF;
484:
485: RETURN l_success;
486: END Pre_Insert_Child;

Line 499: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

495: IS
496: l_incident_id NUMBER;
497: BEGIN
498: /*** get debug level ***/
499: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
500:
501: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
502: jtm_message_log_pkg.Log_Msg
503: ( p_task_id

Line 501: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

497: BEGIN
498: /*** get debug level ***/
499: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
500:
501: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
502: jtm_message_log_pkg.Log_Msg
503: ( p_task_id
504: , g_table_name
505: , 'Entering Post_Delete_Child'

Line 506: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

502: jtm_message_log_pkg.Log_Msg
503: ( p_task_id
504: , g_table_name
505: , 'Entering Post_Delete_Child'
506: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
507: END IF;
508:
509: /*** delete task record from ACC ***/
510: Delete_ACC_Record

Line 516: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

512: , p_resource_id
513: , p_flow_type);
514:
515: /*** call delete service request ***/
516: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
517: jtm_message_log_pkg.Log_Msg
518: ( p_task_id
519: , g_table_name
520: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child'

Line 521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

517: jtm_message_log_pkg.Log_Msg
518: ( p_task_id
519: , g_table_name
520: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child'
521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
522: END IF;
523:
524: /*Do not delete sr when history, flow is sr -> task -> assignment */
525: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

Line 533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

529: CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child( l_incident_id, p_resource_id );
530: END IF;
531: END IF;
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_task_id
536: , g_table_name
537: , 'Leaving Post_Delete_Child'

Line 538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

534: jtm_message_log_pkg.Log_Msg
535: ( p_task_id
536: , g_table_name
537: , 'Leaving Post_Delete_Child'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
539: END IF;
540: END Post_Delete_Child;
541:
542:

Line 574: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: RETURN;
572: END IF;
573: /*** get debug level ***/
574: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
575:
576: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
577: jtm_message_log_pkg.Log_Msg
578: ( l_task_id

Line 576: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

572: END IF;
573: /*** get debug level ***/
574: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
575:
576: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
577: jtm_message_log_pkg.Log_Msg
578: ( l_task_id
579: , g_table_name
580: , 'Entering POST_INSERT_TASK hook'

Line 581: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

577: jtm_message_log_pkg.Log_Msg
578: ( l_task_id
579: , g_table_name
580: , 'Entering POST_INSERT_TASK hook'
581: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
582: END IF;
583:
584: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
585: OPEN c_task( l_task_id );

Line 589: JTM_HOOK_UTIL_PKG.isMobileFSresource(r_task.RESOURCE_ID) = TRUE THEN

585: OPEN c_task( l_task_id );
586: FETCH c_task INTO r_task;
587: IF c_task%FOUND THEN
588: IF r_task.SOURCE_OBJECT_TYPE_CODE = 'SR' AND
589: JTM_HOOK_UTIL_PKG.isMobileFSresource(r_task.RESOURCE_ID) = TRUE THEN
590: Insert_ACC_Record
591: ( l_task_id
592: , r_task.RESOURCE_ID
593: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

Line 599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

595: END IF;--Type = SR
596: END IF;--c_task%FOUND
597: CLOSE c_task;
598:
599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
600: jtm_message_log_pkg.Log_Msg
601: ( l_task_id
602: , g_table_name
603: , 'Leaving POST_INSERT_TASK hook'

Line 604: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

600: jtm_message_log_pkg.Log_Msg
601: ( l_task_id
602: , g_table_name
603: , 'Leaving POST_INSERT_TASK hook'
604: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
605: END IF;
606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: EXCEPTION WHEN OTHERS THEN

Line 610: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: EXCEPTION WHEN OTHERS THEN
609: /*** hook failed -> log error ***/
610: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
611: jtm_message_log_pkg.Log_Msg
612: ( l_task_id
613: , g_table_name
614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm

Line 615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

611: jtm_message_log_pkg.Log_Msg
612: ( l_task_id
613: , g_table_name
614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm
615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
616: END IF;
617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);
618: -- x_return_status := FND_API.G_RET_STS_ERROR;
619: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 643: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

639: /*** get task record details from public API ***/
640: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
641:
642: /*** get debug level ***/
643: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
644:
645: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
646: jtm_message_log_pkg.Log_Msg
647: ( l_task_id

Line 645: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

641:
642: /*** get debug level ***/
643: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
644:
645: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
646: jtm_message_log_pkg.Log_Msg
647: ( l_task_id
648: , g_table_name
649: , 'Entering PRE_UPDATE hook'

Line 650: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

646: jtm_message_log_pkg.Log_Msg
647: ( l_task_id
648: , g_table_name
649: , 'Entering PRE_UPDATE hook'
650: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
651: END IF;
652:
653: /*** Check if task before update matched criteria ***/
654: g_replicate_pre_update := Replicate_Record( l_task_id );

Line 662: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

658: CLOSE c_task_address;
659:
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
663: jtm_message_log_pkg.Log_Msg
664: ( l_task_id
665: , g_table_name
666: , 'Leaving PRE_UPDATE hook'

Line 667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

663: jtm_message_log_pkg.Log_Msg
664: ( l_task_id
665: , g_table_name
666: , 'Leaving PRE_UPDATE hook'
667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
668: END IF;
669:
670: EXCEPTION WHEN OTHERS THEN
671: /*** hook failed -> log error ***/

Line 672: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

668: END IF;
669:
670: EXCEPTION WHEN OTHERS THEN
671: /*** hook failed -> log error ***/
672: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
673: jtm_message_log_pkg.Log_Msg
674: ( l_task_id
675: , g_table_name
676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

673: jtm_message_log_pkg.Log_Msg
674: ( l_task_id
675: , g_table_name
676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
678: END IF;
679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 720: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

716: /*** get task record details from public API ***/
717: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
718:
719: /*** get debug level ***/
720: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
721:
722: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
723: jtm_message_log_pkg.Log_Msg
724: ( l_task_id

Line 722: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

718:
719: /*** get debug level ***/
720: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
721:
722: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
723: jtm_message_log_pkg.Log_Msg
724: ( l_task_id
725: , g_table_name
726: , 'Entering POST_UPDATE hook'

Line 727: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

723: jtm_message_log_pkg.Log_Msg
724: ( l_task_id
725: , g_table_name
726: , 'Entering POST_UPDATE hook'
727: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
728: END IF;
729:
730: /*** Check if task after update matches criteria ***/
731: l_replicate := Replicate_Record( l_task_id );

Line 738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

734: IF l_replicate THEN
735: /*** yes -> was record already replicated? ***/
736: IF g_replicate_pre_update THEN
737: /*** yes -> re-send updated task record to all resources ***/
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
739: jtm_message_log_pkg.Log_Msg
740: ( l_task_id
741: , g_table_name
742: , 'Task was replicateable before and after update. Re-sending task record to mobile users.'

Line 743: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

739: jtm_message_log_pkg.Log_Msg
740: ( l_task_id
741: , g_table_name
742: , 'Task was replicateable before and after update. Re-sending task record to mobile users.'
743: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
744: END IF;
745: /*** get list of resources to whom the record was replicated ***/
746: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
747: ( P_ACC_TABLE_NAME => g_acc_table_name

Line 746: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

742: , 'Task was replicateable before and after update. Re-sending task record to mobile users.'
743: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
744: END IF;
745: /*** get list of resources to whom the record was replicated ***/
746: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
747: ( P_ACC_TABLE_NAME => g_acc_table_name
748: ,P_PK1_NAME => g_pk1_name
749: ,P_PK1_NUM_VALUE => l_task_id
750: ,L_TAB_RESOURCE_ID => l_tab_resource_id

Line 789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

785: /***
786: record was not replicated before update but should be replicated now ->
787: send record related data to all resources
788: ***/
789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
790: jtm_message_log_pkg.Log_Msg
791: ( l_task_id
792: , g_table_name
793: , 'Task was not replicated before update, but should be replicated now.'

Line 794: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

790: jtm_message_log_pkg.Log_Msg
791: ( l_task_id
792: , g_table_name
793: , 'Task was not replicated before update, but should be replicated now.'
794: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
795: END IF;
796:
797: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
798:

Line 799: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

795: END IF;
796:
797: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
798:
799: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
800: jtm_message_log_pkg.Log_Msg
801: ( l_task_id
802: , g_table_name
803: , 'Evaluating task_assignment_id ' ||

Line 806: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

802: , g_table_name
803: , 'Evaluating task_assignment_id ' ||
804: r_task_assignment.task_assignment_id || fnd_global.local_chr(10) ||
805: 'for resource_id ' || r_task_assignment.resource_id
806: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
807: END IF;
808:
809: /*** insert task assignment data ***/
810: l_dummy := CSL_JTF_TASK_ASS_ACC_PKG.Pre_Insert_Child

Line 820: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

816: ELSE
817: /*** record should not be replicated anymore -> was it replicated before? ***/
818: IF g_replicate_pre_update THEN
819: /*** yes -> delete record related data for all resources ***/
820: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
821: jtm_message_log_pkg.Log_Msg
822: ( l_task_id
823: , g_table_name
824: , 'Task was replicated before update, but should no longer be replicated.'

Line 825: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

821: jtm_message_log_pkg.Log_Msg
822: ( l_task_id
823: , g_table_name
824: , 'Task was replicated before update, but should no longer be replicated.'
825: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
826: END IF;
827:
828: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
829:

Line 830: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

826: END IF;
827:
828: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
829:
830: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
831: jtm_message_log_pkg.Log_Msg
832: ( l_task_id
833: , g_table_name
834: , 'Evaluating task_assignment_id ' || r_task_assignment.task_assignment_id ||

Line 836: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

832: ( l_task_id
833: , g_table_name
834: , 'Evaluating task_assignment_id ' || r_task_assignment.task_assignment_id ||
835: fnd_global.local_chr(10) ||'for resource_id ' || r_task_assignment.resource_id
836: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
837: END IF;
838:
839: /*** delete task assignment data ***/
840: CSL_JTF_TASK_ASS_ACC_PKG.Post_Delete_Child

Line 850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

846: END IF;
847:
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
851: jtm_message_log_pkg.Log_Msg
852: ( l_task_id
853: , g_table_name
854: , 'Leaving POST_UPDATE hook'

Line 855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

851: jtm_message_log_pkg.Log_Msg
852: ( l_task_id
853: , g_table_name
854: , 'Leaving POST_UPDATE hook'
855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
856: END IF;
857:
858: EXCEPTION WHEN OTHERS THEN
859: /*** hook failed -> log error ***/

Line 860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

856: END IF;
857:
858: EXCEPTION WHEN OTHERS THEN
859: /*** hook failed -> log error ***/
860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
861: jtm_message_log_pkg.Log_Msg
862: ( l_task_id
863: , g_table_name
864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

861: jtm_message_log_pkg.Log_Msg
862: ( l_task_id
863: , g_table_name
864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
866: END IF;
867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
868: -- x_return_status := FND_API.G_RET_STS_ERROR;
869: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

899: AND tk.CREATED_BY = au.USER_ID
900: AND au.RESOURCE_ID = b_resource_id;
901: r_task c_task%ROWTYPE;
902: BEGIN
903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_resource_id
906: , g_table_name
907: , 'Entering POST_INSERT hook'

Line 908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

904: jtm_message_log_pkg.Log_Msg
905: ( p_resource_id
906: , g_table_name
907: , 'Entering POST_INSERT hook'
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
909: END IF;
910:
911: /*** insert all tasks created by resource ***/
912: FOR r_task IN c_task( p_resource_id ) LOOP

Line 920: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

916: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
917: );
918: END LOOP;
919:
920: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
921: jtm_message_log_pkg.Log_Msg
922: ( p_resource_id
923: , g_table_name
924: , 'Leaving POST_INSERT hook'

Line 925: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

921: jtm_message_log_pkg.Log_Msg
922: ( p_resource_id
923: , g_table_name
924: , 'Leaving POST_INSERT hook'
925: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
926: END IF;
927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:

Line 932: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: EXCEPTION
931: WHEN OTHERS THEN
932: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
933: jtm_message_log_pkg.Log_Msg
934: ( p_resource_id
935: , g_table_name
936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm

Line 937: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

933: jtm_message_log_pkg.Log_Msg
934: ( p_resource_id
935: , g_table_name
936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
937: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
938: END IF;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: END INSERT_ALL_ACC_RECORDS;
941:

Line 978: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

974: jtm_message_log_pkg.Log_Msg
975: (rcur_purge_tasks.task_id,
976: 'CSL_JTF_TASK_ASS_ACC',
977: 'Exception occured in PURGE_TASKS for id: ' || rcur_purge_tasks.task_id,
978: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
979:
980: END;
981:
982: END CSL_JTF_TASKS_ACC_PKG;