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 FND_LOG

Line 59: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);

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

Line 73: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY_SR_RECOR',FND_LOG.LEVEL_EXCEPTION);

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
77: l_sqlerrno := to_char(SQLCODE);

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 134: 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);

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';
138:

Line 152: 'CSM_SERVICE_HISTORY_EVENT_PKG.CREATE_HISTORY_SR_RECOR',FND_LOG.LEVEL_PROCEDURE);

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);
156: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 283: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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);
287:

Line 306: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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

Line 322: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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

Line 331: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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
335: , p_closed_date => r_get_cp_history.close_date );

Line 360: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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

Line 379: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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

Line 388: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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
392: , p_user_id => l_user_id

Line 420: 'CSM_SERVICE_HISTORY_EVENT_PKG.CALCULATE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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
424: WHEN OTHERS THEN

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 490: 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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' ;
494: l_last_run_date := SYSDATE;

Line 522: 'CSM_SERVICE_HISTORY_EVENT_PKG.CONCURRENT_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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:
526: EXCEPTION

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 549: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_PROCEDURE);

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
552: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
553: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 564: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_I',FND_LOG.LEVEL_PROCEDURE);

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
567: l_sqlerrno := to_char(SQLCODE);
568: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 603: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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
606: DELETE_HISTORY_SR_RECORD( p_incident_id, r_history.HISTORY_INCIDENT_ID, p_user_id );
607: END LOOP;

Line 611: 'CSM_SERVICE_HISTORY_EVENT_PKG.DELETE_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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
614: l_sqlerrno := to_char(SQLCODE);
615: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 634: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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
637: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
638: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 648: 'CSM_SERVICE_HISTORY_EVENT_PKG.SERVICE_HISTORY_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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
651: l_sqlerrno := to_char(SQLCODE);
652: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 728: 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_PROCEDURE);

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:
732: l_sr_profile_value := fnd_profile.value_specific('CSM_SR_HIST_DWLD_PARTY');

Line 880: is set to NO',FND_LOG.LEVEL_PROCEDURE);

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:
884: p_return_status := 'SUCCESS';

Line 888: 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_EXCEPTION);

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
892: l_sqlerrno := to_char(SQLCODE);

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;