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.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 58: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',

54: AND nvl(tast.REJECTED_FLAG,'N') <> 'Y' ;
55:
56: BEGIN
57:
58: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',
59: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);
60:
61: --Calculate ta + debrief
62: FOR r_closed_assignement IN c_closed_assignments( b_incident_id => p_history_id ) LOOP

Line 72: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',

68: p_error_msg=>l_error_msg,
69: x_return_status=>l_return_status);
70:
71: END LOOP;
72: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',
73: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECOR',FND_LOG.LEVEL_EXCEPTION);
74:
75:
76: EXCEPTION WHEN OTHERS THEN

Line 81: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',FND_LOG.LEVEL_EXCEPTION);

77: l_sqlerrno := to_char(SQLCODE);
78: l_sqlerrmsg := substr(SQLERRM, 1,2000);
79: l_error_msg := l_error_msg ||'- Exception in DELETE_HISTORY_SR_RECORD for incident_id:' || p_incident_id
80: || ' and user_id: ' || p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
81: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECORD',FND_LOG.LEVEL_EXCEPTION);
82: RAISE;
83: END DELETE_HISTORY_SR_RECORD;
84:
85: PROCEDURE CREATE_HISTORY_SR_RECORD( p_incident_id IN NUMBER

Line 133: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',

129: l_itemkey varchar2(1000);
130: l_seq_val number;
131: BEGIN
132:
133: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',
134: 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);
135:
136: --use the CSMTYPE3 itemtype
137: l_itemtype := 'CSMTYPE3';

Line 151: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',

147: p_error_msg=>l_error_msg,
148: x_return_status=>l_return_status);
149:
150: END LOOP;
151: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',
152: 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);
153:
154: EXCEPTION WHEN OTHERS THEN
155: l_sqlerrno := to_char(SQLCODE);

Line 159: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',FND_LOG.LEVEL_EXCEPTION);

155: l_sqlerrno := to_char(SQLCODE);
156: l_sqlerrmsg := substr(SQLERRM, 1,2000);
157: l_error_msg := l_error_msg ||'- Exception in CREATE_HISTORY_SR_RECORD for incident_id:' || p_incident_id
158: || ' and user_id: ' || p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
159: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECORD',FND_LOG.LEVEL_EXCEPTION);
160: RAISE;
161: END CREATE_HISTORY_SR_RECORD;
162:
163: /*Procedure calculates the x number of history service request for the given sr */

Line 282: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',

278: l_error_msg VARCHAR2(4000);
279: l_return_status VARCHAR2(2000);
280:
281: BEGIN
282: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',
283: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
284:
285: /*Get history count from profile*/
286: l_history_count := csm_profile_pkg.get_history_count(l_user_id);

Line 305: CSM_UTIL_PKG.LOG(' Service request is based on a customer product',

301: CLOSE c_task_time;
302: /*Check for sr type ( on CP or not )*/
303: IF r_sr_type.CUSTOMER_PRODUCT_ID IS NOT NULL THEN
304: /*Only history for CP product*/
305: CSM_UTIL_PKG.LOG(' Service request is based on a customer product',
306: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
307:
308: -- If csm_history_count profile value > 0
309: IF l_history_count > 0 THEN

Line 321: CSM_UTIL_PKG.LOG('Already replicated, deleting from PLSQL table',

317: FOR i IN l_history_table.FIRST .. l_history_table.LAST LOOP
318: IF l_history_table.EXISTS(i) THEN
319: IF l_history_table(i) = r_get_cp_history.incident_id THEN
320: /*Record does exist do not insert but remove reference from list*/
321: CSM_UTIL_PKG.LOG('Already replicated, deleting from PLSQL table',
322: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
323: l_history_table.DELETE(i);
324: l_not_exists := FALSE;
325: END IF;

Line 330: CSM_UTIL_PKG.LOG('Record not replicated yet; push it to client(s)',

326: END IF;
327: END LOOP; -- end of for looping over l_history table
328: IF l_not_exists THEN
329: /*Record does not yet exists so insert*/
330: CSM_UTIL_PKG.LOG('Record not replicated yet; push it to client(s)',
331: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
332: CREATE_HISTORY_SR_RECORD( p_incident_id => l_incident_id
333: , p_history_id => r_get_cp_history.incident_id
334: , p_user_id => l_user_id

Line 359: CSM_UTIL_PKG.LOG(' Service request is not based on a customer product',

355: END LOOP;
356: END IF;
357: ELSE
358: /*SR history for cust/install site*/
359: CSM_UTIL_PKG.LOG(' Service request is not based on a customer product',
360: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
361:
362: -- If csm_history_count profile value > 0
363: IF l_history_count > 0 THEN

Line 378: CSM_UTIL_PKG.LOG('Already replicated, deleting from PLSQL table',

374: FOR i IN l_history_table.FIRST .. l_history_table.LAST LOOP
375: IF l_history_table.EXISTS(i) THEN
376: IF l_history_table(i) = r_get_non_cp_history.incident_id THEN
377: /*Record does exist do not insert but remove reference from list*/
378: CSM_UTIL_PKG.LOG('Already replicated, deleting from PLSQL table',
379: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
380: l_history_table.DELETE(i);
381: l_not_exists := FALSE;
382: END IF;

Line 387: CSM_UTIL_PKG.LOG('Record not replicated yet; push it to client(s)',

383: END IF;
384: END LOOP;
385: IF l_not_exists THEN
386: /*Record does not yet exists so insert*/
387: CSM_UTIL_PKG.LOG('Record not replicated yet; push it to client(s)',
388: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
389:
390: CREATE_HISTORY_SR_RECORD( p_incident_id => l_incident_id
391: , p_history_id => r_get_non_cp_history.incident_id

Line 419: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',

415:
416: null ;
417: END IF;
418: CLOSE c_sr_type;
419: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',
420: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
421:
422:
423: EXCEPTION

Line 429: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_EXCEPTION);

425: l_sqlerrno := to_char(SQLCODE);
426: l_sqlerrmsg := substr(SQLERRM, 1,2000);
427: l_error_msg := ' Exception in CALCULATE_HISTORY for incident_id: ' || l_incident_id ||
428: ' and for user_id: ' || l_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
429: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_EXCEPTION);
430: RAISE;
431: END CALCULATE_HISTORY;
432:
433: PROCEDURE CONCURRENT_HISTORY(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

Line 489: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',

485: l_error_msg VARCHAR2(4000);
486: l_return_status VARCHAR2(2000);
487:
488: BEGIN
489: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',
490: 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_PROCEDURE);
491:
492: /* Assign flow_type to 'HISTORY' */
493: -- csm_util_pkg.g_flow_type := 'HISTORY' ;

Line 493: -- csm_util_pkg.g_flow_type := 'HISTORY' ;

489: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',
490: 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_PROCEDURE);
491:
492: /* Assign flow_type to 'HISTORY' */
493: -- csm_util_pkg.g_flow_type := 'HISTORY' ;
494: l_last_run_date := SYSDATE;
495:
496: -- get new history
497: FOR r_acc_incident IN c_acc_incidents LOOP

Line 521: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',

517: CLOSE l_upd_last_run_date_csr;
518:
519: COMMIT;
520:
521: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',
522: 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_PROCEDURE);
523: p_status := 'SUCCESS';
524: p_message := 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY Executed successfully';
525:

Line 531: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_EXCEPTION);

527: WHEN OTHERS THEN
528: l_sqlerrno := to_char(SQLCODE);
529: l_sqlerrmsg := substr(SQLERRM, 1,2000);
530: l_error_msg := ' Exception in CONCURRENT_HISTORY : ' || l_sqlerrno || ':' || l_sqlerrmsg;
531: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_EXCEPTION);
532: p_status := 'ERROR';
533: p_message := 'Error in CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY: ' || l_error_msg;
534: ROLLBACK;
535: END CONCURRENT_HISTORY;

Line 547: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id

543: l_error_msg VARCHAR2(4000);
544: l_return_status VARCHAR2(2000);
545:
546: BEGIN
547: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id
548: || ' and parent_incident_id:' || p_parent_incident_id,
549: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_PROCEDURE);
550:
551: CSM_ACC_PKG.Insert_Acc

Line 562: CSM_UTIL_PKG.LOG('Leaving SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id

558: ,P_PK2_NUM_VALUE => p_incident_id
559: ,p_USER_ID => p_user_id
560: );
561:
562: CSM_UTIL_PKG.LOG('Leaving SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id
563: || ' and parent_incident_id:' || p_parent_incident_id,
564: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_PROCEDURE);
565: EXCEPTION
566: WHEN OTHERS THEN

Line 571: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_EXCEPTION);

567: l_sqlerrno := to_char(SQLCODE);
568: l_sqlerrmsg := substr(SQLERRM, 1,2000);
569: l_error_msg := ' Exception in SERVICE_HISTORY_ACC_I for incident_id: ' || p_incident_id
570: || ' and parent_incident_id:' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
571: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_EXCEPTION);
572: RAISE;
573: END SERVICE_HISTORY_ACC_I;
574:
575: PROCEDURE DELETE_HISTORY(p_task_assignment_id IN NUMBER,

Line 601: CSM_UTIL_PKG.LOG('Entering DELETE_HISTORY for incident_id: ' || p_incident_id

597: AND ACC.USER_ID = b_user_id
598: AND ACC.TASK_ASSIGNMENT_ID <> b_task_assignment_id);
599:
600: BEGIN
601: CSM_UTIL_PKG.LOG('Entering DELETE_HISTORY for incident_id: ' || p_incident_id
602: || ' and task_assignment_id:' || p_task_assignment_id,
603: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
604:
605: FOR r_history IN c_history( p_incident_id, p_task_assignment_id, p_user_id ) LOOP

Line 609: CSM_UTIL_PKG.LOG('Leaving DELETE_HISTORY for incident_id: ' || p_incident_id

605: FOR r_history IN c_history( p_incident_id, p_task_assignment_id, p_user_id ) LOOP
606: DELETE_HISTORY_SR_RECORD( p_incident_id, r_history.HISTORY_INCIDENT_ID, p_user_id );
607: END LOOP;
608:
609: CSM_UTIL_PKG.LOG('Leaving DELETE_HISTORY for incident_id: ' || p_incident_id
610: || ' and task_assignment_id:' || p_task_assignment_id,
611: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_PROCEDURE);
612: EXCEPTION
613: WHEN OTHERS THEN

Line 618: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_EXCEPTION);

614: l_sqlerrno := to_char(SQLCODE);
615: l_sqlerrmsg := substr(SQLERRM, 1,2000);
616: l_error_msg := ' Exception in DELETE_HISTORY for incident_id: ' || p_incident_id
617: || ' and task_assignment_id:' || p_task_assignment_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
618: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_EXCEPTION);
619: RAISE;
620: END DELETE_HISTORY;
621:
622: PROCEDURE SERVICE_HISTORY_ACC_D(p_parent_incident_id IN NUMBER,

Line 632: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id

628: l_error_msg VARCHAR2(4000);
629: l_return_status VARCHAR2(2000);
630:
631: BEGIN
632: CSM_UTIL_PKG.LOG('Entering SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id
633: || ' and parent_incident_id:' || p_parent_incident_id,
634: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_PROCEDURE);
635:
636: CSM_ACC_PKG.Delete_Acc

Line 646: CSM_UTIL_PKG.LOG('Leaving SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id

642: ,P_PK2_NUM_VALUE => p_incident_id
643: ,p_USER_ID => p_user_id
644: );
645:
646: CSM_UTIL_PKG.LOG('Leaving SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id
647: || ' and parent_incident_id:' || p_parent_incident_id,
648: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_PROCEDURE);
649: EXCEPTION
650: WHEN OTHERS THEN

Line 655: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_EXCEPTION);

651: l_sqlerrno := to_char(SQLCODE);
652: l_sqlerrmsg := substr(SQLERRM, 1,2000);
653: l_error_msg := ' Exception in SERVICE_HISTORY_ACC_D for incident_id: ' || p_incident_id
654: || ' and parent_incident_id:' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
655: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_EXCEPTION);
656: RAISE;
657: END SERVICE_HISTORY_ACC_D;
658:
659: PROCEDURE PROCESS_OWNER_HISTORY( p_return_status OUT NOCOPY VARCHAR2,p_error_message OUT NOCOPY VARCHAR2

Line 727: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',

723: );
724:
725: BEGIN
726:
727: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',
728: 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_PROCEDURE);
729:
730: l_parent_incident_id := 1;
731:

Line 879: CSM_UTIL_PKG.LOG('The Profile Option CSM: Allow Service Request History Download for Parties

875: CLOSE l_sr_hist_del_csr;
876:
877: ELSE
878:
879: CSM_UTIL_PKG.LOG('The Profile Option CSM: Allow Service Request History Download for Parties
880: is set to NO',FND_LOG.LEVEL_PROCEDURE);
881:
882: END IF;
883:

Line 887: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',

883:
884: p_return_status := 'SUCCESS';
885: p_error_message := 'SR HISTORY Records are successfully processed';
886:
887: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',
888: 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_EXCEPTION);
889:
890:
891: EXCEPTION WHEN OTHERS THEN

Line 897: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_EXCEPTION);

893: l_sqlerrmsg := substr(SQLERRM, 1,2000);
894: p_return_status := 'ERROR';
895: p_error_message := l_sqlerrmsg;
896: l_error_msg :='Exception in PROCESS_OWNER_HISTORY ' || l_sqlerrno || ':' || l_sqlerrmsg;
897: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_EXCEPTION);
898: RAISE;
899: END PROCESS_OWNER_HISTORY;
900:
901: END;