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

Line 7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

3:
4: /*** Globals ***/
5: g_debug_level NUMBER;
6: g_table_name CONSTANT VARCHAR2(30) := 'CSL_SERVICE_HISTORY_PKG';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SERVICE_HISTORY');
9: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_SERVICE_HISTORY';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'HISTORY_INCIDENT_ID';

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SERVICE_HISTORY');

4: /*** Globals ***/
5: g_debug_level NUMBER;
6: g_table_name CONSTANT VARCHAR2(30) := 'CSL_SERVICE_HISTORY_PKG';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SERVICE_HISTORY');
9: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_SERVICE_HISTORY';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'HISTORY_INCIDENT_ID';
12:

Line 19: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

15: , p_history_id NUMBER
16: , p_resource_id NUMBER )
17: IS
18: BEGIN
19: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
20: jtm_message_log_pkg.Log_Msg
21: ( null
22: , g_table_name
23: , 'Entering INSERT_MAPPING_RECORD for incident '||p_incident_id

Line 24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

20: jtm_message_log_pkg.Log_Msg
21: ( null
22: , g_table_name
23: , 'Entering INSERT_MAPPING_RECORD for incident '||p_incident_id
24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
25: , 'csl_service_history_pkg');
26: END IF;
27:
28: JTM_HOOK_UTIL_PKG.Insert_Acc

Line 28: JTM_HOOK_UTIL_PKG.Insert_Acc

24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
25: , 'csl_service_history_pkg');
26: END IF;
27:
28: JTM_HOOK_UTIL_PKG.Insert_Acc
29: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
30: ,P_ACC_TABLE_NAME => g_acc_table_name
31: ,P_RESOURCE_ID => p_resource_id
32: ,P_PK1_NAME => g_pk1_name

Line 38: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

34: ,P_PK2_NAME => g_pk2_name
35: ,P_PK2_NUM_VALUE => p_history_id
36: );
37:
38: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
39: jtm_message_log_pkg.Log_Msg
40: ( null
41: , g_table_name
42: , 'Leaving INSERT_MAPPING_RECORD for incident '||p_incident_id

Line 43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

39: jtm_message_log_pkg.Log_Msg
40: ( null
41: , g_table_name
42: , 'Leaving INSERT_MAPPING_RECORD for incident '||p_incident_id
43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
44: , 'csl_service_history_pkg');
45: END IF;
46: EXCEPTION WHEN OTHERS THEN
47: jtm_message_log_pkg.Log_Msg( null

Line 51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

47: jtm_message_log_pkg.Log_Msg( null
48: , g_table_name
49: , 'Exception in CSL_SERVICE_HISTORY_PKG.INSERT_MAPPING_RECORD for incident '||p_incident_id||
50: ' and resource '||p_resource_id || ':' || fnd_global.local_chr(10) || sqlerrm
51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
52: , 'csl_service_history_pkg');
53: RAISE;
54: END INSERT_MAPPING_RECORD;
55:

Line 61: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

57: , p_history_id NUMBER
58: , p_resource_id NUMBER )
59: IS
60: BEGIN
61: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
62: jtm_message_log_pkg.Log_Msg
63: ( null
64: , g_table_name
65: , 'Entering DELETE_MAPPING_RECORD for incident '||p_incident_id

Line 66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

62: jtm_message_log_pkg.Log_Msg
63: ( null
64: , g_table_name
65: , 'Entering DELETE_MAPPING_RECORD for incident '||p_incident_id
66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
67: , 'csl_service_history_pkg');
68: END IF;
69:
70: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 70: JTM_HOOK_UTIL_PKG.Delete_Acc

66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
67: , 'csl_service_history_pkg');
68: END IF;
69:
70: JTM_HOOK_UTIL_PKG.Delete_Acc
71: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
72: ,P_ACC_TABLE_NAME => g_acc_table_name
73: ,P_RESOURCE_ID => p_resource_id
74: ,P_PK1_NAME => g_pk1_name

Line 80: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

76: ,P_PK2_NAME => g_pk2_name
77: ,P_PK2_NUM_VALUE => p_history_id
78: );
79:
80: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
81: jtm_message_log_pkg.Log_Msg
82: ( null
83: , g_table_name
84: , 'Leaving DELETE_MAPPING_RECORD for incident '||p_incident_id

Line 85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

81: jtm_message_log_pkg.Log_Msg
82: ( null
83: , g_table_name
84: , 'Leaving DELETE_MAPPING_RECORD for incident '||p_incident_id
85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
86: , 'csl_service_history_pkg');
87: END IF;
88: EXCEPTION WHEN OTHERS THEN
89: jtm_message_log_pkg.Log_Msg( null

Line 93: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

89: jtm_message_log_pkg.Log_Msg( null
90: , g_table_name
91: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_MAPPING_RECORD for incident '||p_incident_id||
92: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
93: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
94: , 'csl_service_history_pkg');
95: RAISE;
96: END DELETE_MAPPING_RECORD;
97:

Line 116: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

112: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(fur.start_date,sysdate))
113: AND TRUNC(NVL(fur.end_date,sysdate));
114:
115: BEGIN
116: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
117: jtm_message_log_pkg.Log_Msg
118: ( null
119: , g_table_name
120: , 'Entering GET_HISTORY_COUNT for resource '||p_resource_id

Line 121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

117: jtm_message_log_pkg.Log_Msg
118: ( null
119: , g_table_name
120: , 'Entering GET_HISTORY_COUNT for resource '||p_resource_id
121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
122: , 'csl_service_history_pkg');
123: END IF;
124: /*If multiple values can be gotton from the profile the maximum value will be returned
125: Leading is the profile order of user ->resp -> appl -> site so it basicly only counts

Line 140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

136: l_max_count := l_profile_value;
137: END IF;
138: END LOOP;
139:
140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
141: jtm_message_log_pkg.Log_Msg
142: ( null
143: , g_table_name
144: , 'Leaving GET_HISTORY_COUNT for for resource '||p_resource_id||

Line 146: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

142: ( null
143: , g_table_name
144: , 'Leaving GET_HISTORY_COUNT for for resource '||p_resource_id||
145: ' with value '||l_max_count
146: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
147: , 'csl_service_history_pkg');
148: END IF;
149: RETURN l_max_count;
150: EXCEPTION WHEN OTHERS THEN

Line 155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

151: jtm_message_log_pkg.Log_Msg( null
152: , g_table_name
153: , 'Exception in CSL_SERVICE_HISTORY_PKG.GET_HISTORY_COUNT for resource '||p_resource_id||':'
154: || fnd_global.local_chr(10) || sqlerrm
155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
156: , 'csl_service_history_pkg');
157: RETURN 0;
158: END GET_HISTORY_COUNT;
159:

Line 189: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

185: OR ts.COMPLETED_FLAG = 'Y' )
186: AND NVL(ts.CANCELLED_FLAG,'N') <> 'Y'
187: AND NVL(ts.REJECTED_FLAG, 'N') <> 'Y';
188: BEGIN
189: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
190: jtm_message_log_pkg.Log_Msg
191: ( null
192: , g_table_name
193: , 'Entering DELETE_HISTORY_SR_RECORD for incident '||p_incident_id

Line 194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

190: jtm_message_log_pkg.Log_Msg
191: ( null
192: , g_table_name
193: , 'Entering DELETE_HISTORY_SR_RECORD for incident '||p_incident_id
194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
195: , 'csl_service_history_pkg');
196: END IF;
197:
198: CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child( p_incident_id => p_history_id

Line 222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

218: p_resource_id => p_resource_id );
219: END LOOP;
220: END LOOP;
221: DELETE_MAPPING_RECORD( p_incident_id, p_history_id, p_resource_id );
222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
223: jtm_message_log_pkg.Log_Msg
224: ( null
225: , g_table_name
226: , 'Leaving DELETE_HISTORY_SR_RECORD for incident '||p_incident_id

Line 227: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

223: jtm_message_log_pkg.Log_Msg
224: ( null
225: , g_table_name
226: , 'Leaving DELETE_HISTORY_SR_RECORD for incident '||p_incident_id
227: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
228: , 'csl_service_history_pkg');
229: END IF;
230: EXCEPTION WHEN OTHERS THEN
231: jtm_message_log_pkg.Log_Msg

Line 236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

232: ( null
233: , g_table_name
234: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY_SR_RECORD for incident '||p_incident_id||
235: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
237: , 'csl_service_history_pkg');
238: RAISE;
239: END DELETE_HISTORY_SR_RECORD;
240:

Line 274: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

270: AND NVL(ts.CANCELLED_FLAG,'N') <> 'Y'
271: AND NVL(ts.REJECTED_FLAG,'N') <> 'Y';
272:
273: BEGIN
274: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
275: jtm_message_log_pkg.Log_Msg
276: ( null
277: , g_table_name
278: , 'Entering CREATE_HISTORY_SR_RECORD for incident '||p_incident_id

Line 279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

275: jtm_message_log_pkg.Log_Msg
276: ( null
277: , g_table_name
278: , 'Entering CREATE_HISTORY_SR_RECORD for incident '||p_incident_id
279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
280: , 'csl_service_history_pkg');
281: END IF;
282:
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
280: , 'csl_service_history_pkg');
281: END IF;
282:
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
284: jtm_message_log_pkg.Log_Msg
285: ( null
286: , g_table_name
287: , 'Inserting history record '||p_history_id||' for incident '||

Line 289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

285: ( null
286: , g_table_name
287: , 'Inserting history record '||p_history_id||' for incident '||
288: p_incident_id||' and resource '||p_resource_id
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
290: , 'csl_service_history_pkg');
291: END IF;
292:
293: INSERT_MAPPING_RECORD( p_incident_id, p_history_id, p_resource_id );

Line 320: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

316:
317: END LOOP;
318: END LOOP;
319:
320: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
321: jtm_message_log_pkg.Log_Msg
322: ( null
323: , g_table_name
324: , 'Leaving CREATE_HISTORY_SR_RECORD for incident '||p_incident_id

Line 325: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

321: jtm_message_log_pkg.Log_Msg
322: ( null
323: , g_table_name
324: , 'Leaving CREATE_HISTORY_SR_RECORD for incident '||p_incident_id
325: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
326: , 'csl_service_history_pkg');
327: END IF;
328: EXCEPTION WHEN OTHERS THEN
329: jtm_message_log_pkg.Log_Msg

Line 334: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

330: ( null
331: , g_table_name
332: , 'Exception in CSL_SERVICE_HISTORY_PKG.CREATE_HISTORY_SR_RECORD for incident '||p_incident_id||
333: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
334: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
335: , 'csl_service_history_pkg');
336: RAISE;
337: END CREATE_HISTORY_SR_RECORD;
338:

Line 351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

347:
348:
349: BEGIN
350: /*** get debug level ***/
351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
354: jtm_message_log_pkg.Log_Msg
355: ( null

Line 353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

349: BEGIN
350: /*** get debug level ***/
351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
354: jtm_message_log_pkg.Log_Msg
355: ( null
356: , g_table_name
357: , 'Entering DELETE_HISTORY for incident '||p_incident_id

Line 358: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

354: jtm_message_log_pkg.Log_Msg
355: ( null
356: , g_table_name
357: , 'Entering DELETE_HISTORY for incident '||p_incident_id
358: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
359: , 'csl_service_history_pkg');
360: END IF;
361:
362: FOR r_history IN c_history( p_incident_id, p_resource_id ) LOOP

Line 363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

359: , 'csl_service_history_pkg');
360: END IF;
361:
362: FOR r_history IN c_history( p_incident_id, p_resource_id ) LOOP
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
364: jtm_message_log_pkg.Log_Msg
365: ( null
366: , g_table_name
367: , 'Calling delete history record for incident id '||p_incident_id||

Line 369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

365: ( null
366: , g_table_name
367: , 'Calling delete history record for incident id '||p_incident_id||
368: ' and history id '||r_history.HISTORY_INCIDENT_ID||' and resource id '||p_resource_id
369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
370: , 'csl_service_history_pkg');
371: END IF;
372: DELETE_HISTORY_SR_RECORD( p_incident_id, r_history.HISTORY_INCIDENT_ID, p_resource_id );
373: END LOOP;

Line 375: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

371: END IF;
372: DELETE_HISTORY_SR_RECORD( p_incident_id, r_history.HISTORY_INCIDENT_ID, p_resource_id );
373: END LOOP;
374:
375: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
376: jtm_message_log_pkg.Log_Msg
377: ( null
378: , g_table_name
379: , 'Leaving DELETE_HISTORY for incident '||p_incident_id

Line 380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

376: jtm_message_log_pkg.Log_Msg
377: ( null
378: , g_table_name
379: , 'Leaving DELETE_HISTORY for incident '||p_incident_id
380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
381: , 'csl_service_history_pkg');
382: END IF;
383: EXCEPTION WHEN OTHERS THEN
384: jtm_message_log_pkg.Log_Msg

Line 389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

385: ( null
386: , g_table_name
387: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY for incident '||p_incident_id||
388: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
390: , 'csl_service_history_pkg');
391: END DELETE_HISTORY;
392:
393: /*Procedure calculates the x number of history service request for the given sr */

Line 501: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

497: l_not_exists BOOLEAN;
498:
499: BEGIN
500: /*** get debug level ***/
501: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
502:
503: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
504: jtm_message_log_pkg.Log_Msg
505: ( null

Line 503: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

499: BEGIN
500: /*** get debug level ***/
501: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
502:
503: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
504: jtm_message_log_pkg.Log_Msg
505: ( null
506: , g_table_name
507: , 'Entering CALCULATE_HISTORY for incident '||p_incident_id

Line 508: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

504: jtm_message_log_pkg.Log_Msg
505: ( null
506: , g_table_name
507: , 'Entering CALCULATE_HISTORY for incident '||p_incident_id
508: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
509: , 'csl_service_history_pkg');
510: END IF;
511:
512: /*Get history count from profile*/

Line 532: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

528: CLOSE c_task_time;
529: /*Check for sr type ( on CP or not )*/
530: IF r_sr_type.CUSTOMER_PRODUCT_ID IS NOT NULL THEN
531: /*Only history for CP product*/
532: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
533: jtm_message_log_pkg.Log_Msg
534: ( null
535: , g_table_name
536: , 'Service request is based on a customer product'

Line 537: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

533: jtm_message_log_pkg.Log_Msg
534: ( null
535: , g_table_name
536: , 'Service request is based on a customer product'
537: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
538: , 'csl_service_history_pkg');
539: END IF;
540:
541: FOR r_get_cp_history IN c_get_cp_history( b_max_date => nvl( r_task_time.TASK_TIME, SYSDATE ),

Line 585: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

581: END LOOP;
582: END IF;
583: ELSE
584: /*SR history for cust/install site*/
585: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
586: jtm_message_log_pkg.Log_Msg
587: ( null
588: , g_table_name
589: , 'Service request is not based on a customer product, retrieving history for' ||

Line 593: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

589: , 'Service request is not based on a customer product, retrieving history for' ||
590: fnd_global.local_chr(10) || 'task time = ' || to_char(r_task_time.TASK_TIME, 'DD-MON-YYYY HH24:MI') ||
591: fnd_global.local_chr(10) || 'customer_id = ' || r_sr_type.CUSTOMER_ID ||
592: fnd_global.local_chr(10) || 'incident_location_id = ' || r_sr_type.incident_location_id
593: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
594: , 'csl_service_history_pkg');
595: END IF;
596:
597: FOR r_get_non_cp_history IN c_get_non_cp_history( b_max_date => nvl( r_task_time.TASK_TIME, SYSDATE ),

Line 605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

601:
602: IF l_history_table.COUNT > 0 THEN
603: l_not_exists := TRUE;
604: /*Check if record exists*/
605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
606: jtm_message_log_pkg.Log_Msg
607: ( null
608: , g_table_name
609: , 'Checking if incident_id ' || r_get_non_cp_history.incident_id ||' needs to be replicated'

Line 610: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

606: jtm_message_log_pkg.Log_Msg
607: ( null
608: , g_table_name
609: , 'Checking if incident_id ' || r_get_non_cp_history.incident_id ||' needs to be replicated'
610: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
611: , 'csl_service_history_pkg');
612: END IF;
613:
614: FOR i IN l_history_table.FIRST .. l_history_table.LAST LOOP

Line 618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

614: FOR i IN l_history_table.FIRST .. l_history_table.LAST LOOP
615: IF l_history_table.EXISTS(i) THEN
616: IF l_history_table(i) = r_get_non_cp_history.incident_id THEN
617: /*Record does exist do not insert but remove reference from list*/
618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
619: jtm_message_log_pkg.Log_Msg
620: ( null
621: , g_table_name
622: , 'Already replicated, deleting from PL/SQL table'

Line 623: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

619: jtm_message_log_pkg.Log_Msg
620: ( null
621: , g_table_name
622: , 'Already replicated, deleting from PL/SQL table'
623: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
624: , 'csl_service_history_pkg');
625: END IF;
626: l_history_table.DELETE(i);
627: l_not_exists := FALSE;

Line 633: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

629: END IF;
630: END LOOP;
631: IF l_not_exists THEN
632: /*Record does not yet exists so insert*/
633: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
634: jtm_message_log_pkg.Log_Msg
635: ( null
636: , g_table_name
637: , 'Record not replicated yet; push it to client(s)'

Line 638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

634: jtm_message_log_pkg.Log_Msg
635: ( null
636: , g_table_name
637: , 'Record not replicated yet; push it to client(s)'
638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
639: , 'csl_service_history_pkg');
640: END IF;
641: CREATE_HISTORY_SR_RECORD( p_incident_id => p_incident_id
642: , p_history_id => r_get_non_cp_history.incident_id

Line 666: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

662: END LOOP;
663: END IF;
664: END IF;
665: ELSE
666: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
667: jtm_message_log_pkg.Log_Msg
668: ( null
669: , g_table_name
670: , 'Could not find data for incident id '||p_incident_id

Line 671: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

667: jtm_message_log_pkg.Log_Msg
668: ( null
669: , g_table_name
670: , 'Could not find data for incident id '||p_incident_id
671: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
672: , 'csl_service_history_pkg');
673: END IF;
674: END IF;
675: CLOSE c_sr_type;

Line 677: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

673: END IF;
674: END IF;
675: CLOSE c_sr_type;
676:
677: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
678: jtm_message_log_pkg.Log_Msg
679: ( null
680: , g_table_name
681: , 'Leaving CALCULATE_HISTORY for incident '||p_incident_id

Line 682: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

678: jtm_message_log_pkg.Log_Msg
679: ( null
680: , g_table_name
681: , 'Leaving CALCULATE_HISTORY for incident '||p_incident_id
682: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
683: , 'csl_service_history_pkg');
684: END IF;
685:
686: EXCEPTION WHEN OTHERS THEN

Line 692: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

688: ( null
689: , g_table_name
690: , 'Exception in CSL_SERVICE_HISTORY_PKG.CALCULATE_HISTORY for incident '||p_incident_id||
691: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
692: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
693: , 'csl_service_history_pkg');
694: END CALCULATE_HISTORY;
695:
696: PROCEDURE CONCURRENT_HISTORY

Line 715: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

711: AND tsk.SCHEDULED_END_DATE >= TRUNC(SYSDATE)
712: AND NVL(inc.CLOSE_DATE, SYSDATE ) >= SYSDATE;
713:
714: BEGIN
715: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
716: jtm_message_log_pkg.Log_Msg
717: ( null
718: , g_table_name
719: , 'Entering CONCURRENT_HISTORY'

Line 720: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

716: jtm_message_log_pkg.Log_Msg
717: ( null
718: , g_table_name
719: , 'Entering CONCURRENT_HISTORY'
720: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
721: , 'csl_service_history_pkg');
722: END IF;
723:
724: FOR r_acc_incident IN c_acc_incidents LOOP

Line 736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

732: AND PACKAGE_NAME = 'CSL_SERVICE_HISTORY_PKG'
733: AND PROCEDURE_NAME = 'CONCURRENT_HISTORY';
734:
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( null
739: , g_table_name
740: , 'Leaving CONCURRENT_HISTORY'

Line 741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

737: jtm_message_log_pkg.Log_Msg
738: ( null
739: , g_table_name
740: , 'Leaving CONCURRENT_HISTORY'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
742: , 'csl_service_history_pkg');
743: END IF;
744: COMMIT;
745: EXCEPTION WHEN OTHERS THEN

Line 752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

748: ( null
749: , g_table_name
750: , 'Exception in CSL_SERVICE_HISTORY_PKG.CONCURRENT_HISTORY'||':'
751: || fnd_global.local_chr(10) || sqlerrm
752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
753: , 'csl_service_history_pkg');
754: END CONCURRENT_HISTORY;
755:
756: END CSL_SERVICE_HISTORY_PKG;