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 CSL_SERVICE_HISTORY_PKG

Line 1: PACKAGE BODY CSL_SERVICE_HISTORY_PKG AS

1: PACKAGE BODY CSL_SERVICE_HISTORY_PKG AS
2: /* $Header: cslsrhib.pls 115.7 2004/05/10 06:42:37 utekumal ship $ */
3:
4: /*** Globals ***/
5: g_debug_level NUMBER;

Line 6: g_table_name CONSTANT VARCHAR2(30) := 'CSL_SERVICE_HISTORY_PKG';

2: /* $Header: cslsrhib.pls 115.7 2004/05/10 06:42:37 utekumal ship $ */
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';

Line 25: , 'csl_service_history_pkg');

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
29: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 44: , 'csl_service_history_pkg');

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
48: , g_table_name

Line 49: , 'Exception in CSL_SERVICE_HISTORY_PKG.INSERT_MAPPING_RECORD for incident '||p_incident_id||

45: END IF;
46: EXCEPTION WHEN OTHERS THEN
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;

Line 52: , 'csl_service_history_pkg');

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:
56: PROCEDURE DELETE_MAPPING_RECORD( p_incident_id NUMBER

Line 67: , 'csl_service_history_pkg');

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
71: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 86: , 'csl_service_history_pkg');

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
90: , g_table_name

Line 91: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_MAPPING_RECORD for incident '||p_incident_id||

87: END IF;
88: EXCEPTION WHEN OTHERS THEN
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;

Line 94: , 'csl_service_history_pkg');

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:
98: /*** Function to retreive the amount of history records***/

Line 122: , 'csl_service_history_pkg');

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
126: for responsibility for the highest value

Line 147: , 'csl_service_history_pkg');

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
151: jtm_message_log_pkg.Log_Msg( null

Line 153: , 'Exception in CSL_SERVICE_HISTORY_PKG.GET_HISTORY_COUNT for resource '||p_resource_id||':'

149: RETURN l_max_count;
150: EXCEPTION WHEN OTHERS THEN
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;

Line 156: , 'csl_service_history_pkg');

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:
160: PROCEDURE DELETE_HISTORY_SR_RECORD( p_incident_id NUMBER

Line 195: , 'csl_service_history_pkg');

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
199: , p_resource_id => p_resource_id

Line 228: , 'csl_service_history_pkg');

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
232: ( null

Line 234: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY_SR_RECORD for incident '||p_incident_id||

230: EXCEPTION WHEN OTHERS THEN
231: jtm_message_log_pkg.Log_Msg
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;

Line 237: , 'csl_service_history_pkg');

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:
241: PROCEDURE CREATE_HISTORY_SR_RECORD( p_incident_id IN NUMBER

Line 280: , 'csl_service_history_pkg');

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

Line 290: , 'csl_service_history_pkg');

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 );
294: --Insert SR

Line 326: , 'csl_service_history_pkg');

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
330: ( null

Line 332: , 'Exception in CSL_SERVICE_HISTORY_PKG.CREATE_HISTORY_SR_RECORD for incident '||p_incident_id||

328: EXCEPTION WHEN OTHERS THEN
329: jtm_message_log_pkg.Log_Msg
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;

Line 335: , 'csl_service_history_pkg');

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:
339: PROCEDURE DELETE_HISTORY( p_incident_id IN NUMBER

Line 359: , 'csl_service_history_pkg');

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
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 370: , 'csl_service_history_pkg');

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

Line 381: , 'csl_service_history_pkg');

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
385: ( null

Line 387: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY for incident '||p_incident_id||

383: EXCEPTION WHEN OTHERS THEN
384: jtm_message_log_pkg.Log_Msg
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;

Line 390: , 'csl_service_history_pkg');

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 */
394: PROCEDURE CALCULATE_HISTORY( p_incident_id IN NUMBER

Line 509: , 'csl_service_history_pkg');

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*/
513: l_history_count := GET_HISTORY_COUNT( p_resource_id);

Line 538: , 'csl_service_history_pkg');

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 ),
542: b_customer_product_id => r_sr_type.CUSTOMER_PRODUCT_ID )

Line 594: , 'csl_service_history_pkg');

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 ),
598: b_customer_id => r_sr_type.CUSTOMER_ID,

Line 611: , 'csl_service_history_pkg');

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
615: IF l_history_table.EXISTS(i) THEN

Line 624: , 'csl_service_history_pkg');

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

Line 639: , 'csl_service_history_pkg');

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
643: , p_resource_id => p_resource_id

Line 672: , 'csl_service_history_pkg');

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

Line 683: , 'csl_service_history_pkg');

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

Line 690: , 'Exception in CSL_SERVICE_HISTORY_PKG.CALCULATE_HISTORY for incident '||p_incident_id||

686: EXCEPTION WHEN OTHERS THEN
687: jtm_message_log_pkg.Log_Msg
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;

Line 693: , 'csl_service_history_pkg');

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
697: IS

Line 721: , 'csl_service_history_pkg');

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
725: CALCULATE_HISTORY( p_incident_id => r_acc_incident.INCIDENT_ID

Line 732: AND PACKAGE_NAME = 'CSL_SERVICE_HISTORY_PKG'

728:
729: UPDATE JTM_CON_REQUEST_DATA
730: SET LAST_RUN_DATE = SYSDATE
731: WHERE PRODUCT_CODE = 'CSL'
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

Line 742: , 'csl_service_history_pkg');

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
746: ROLLBACK;

Line 750: , 'Exception in CSL_SERVICE_HISTORY_PKG.CONCURRENT_HISTORY'||':'

746: ROLLBACK;
747: jtm_message_log_pkg.Log_Msg
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;

Line 753: , 'csl_service_history_pkg');

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;

Line 756: END CSL_SERVICE_HISTORY_PKG;

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;