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_CONTRACT_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 81: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES'

77: l_sqlerrmsg VARCHAR2(2000);
78: l_bus_proc_cle_id NUMBER;
79:
80: BEGIN
81: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES'
82: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);
83:
84: --get the Business process Cle id
85: OPEN c_get_cov_id(p_contract_service_id, p_business_proc_id);

Line 94: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id and contract serviceid = '

90:
91: FOR r_get_cov_times IN c_get_cov_times(l_bus_proc_cle_id) LOOP
92:
93: -- Push record to the Resource (insert in ACC)
94: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id and contract serviceid = '
95: || p_user_id || ' - ' || p_contract_service_id
96: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_STATEMENT);
97:
98: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4

Line 122: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES'

118:
119: END LOOP;
120: END IF;
121:
122: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES'
123: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);
124:
125: EXCEPTION
126: WHEN OTHERS THEN

Line 129: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES:' || l_sqlerrno || ':' || l_sqlerrmsg

125: EXCEPTION
126: WHEN OTHERS THEN
127: l_sqlerrno := to_char(SQLCODE);
128: l_sqlerrmsg := substr(SQLERRM, 1,2000);
129: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES:' || l_sqlerrno || ':' || l_sqlerrmsg
130: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_ERROR);
131: RAISE;
132:
133: END INSERT_COV_ACTION_TIMES;

Line 154: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES'

150: l_sqlerrmsg VARCHAR2(2000);
151: l_bus_proc_cle_id NUMBER;
152:
153: BEGIN
154: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES'
155: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);
156:
157: FOR r_get_cov_times IN c_delete_cov_times(p_contract_service_id, p_business_proc_id, p_user_id) LOOP
158:

Line 160: CSM_UTIL_PKG.LOG( 'Deleting ACC record for user_id and contract serviceid = '

156:
157: FOR r_get_cov_times IN c_delete_cov_times(p_contract_service_id, p_business_proc_id, p_user_id) LOOP
158:
159: -- Push record to the Resource (insert in ACC)
160: CSM_UTIL_PKG.LOG( 'Deleting ACC record for user_id and contract serviceid = '
161: || p_user_id || ' - ' || p_contract_service_id
162: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_STATEMENT);
163:
164: CSM_ACC_PKG.Delete_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4

Line 177: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES'

173: );
174:
175: END LOOP;
176:
177: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES'
178: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);
179:
180: EXCEPTION
181: WHEN OTHERS THEN

Line 184: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES:' || l_sqlerrno || ':' || l_sqlerrmsg

180: EXCEPTION
181: WHEN OTHERS THEN
182: l_sqlerrno := to_char(SQLCODE);
183: l_sqlerrmsg := substr(SQLERRM, 1,2000);
184: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES:' || l_sqlerrno || ':' || l_sqlerrmsg
185: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_ERROR);
186: RAISE;
187:
188: END DELETE_COV_ACTION_TIMES;

Line 228: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'

224: l_access_id number;
225: l_counter number;
226:
227: BEGIN
228: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'
229: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);
230:
231: /* This call to the Contracts API will return the Txn billing types in table **
232: ** variable: l_oks_out_tbl_bt **

Line 256: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id

252: /* Looping over the table if table contain any record(s) */
253: FOR i IN l_oks_out_tbl_bt.FIRST .. l_oks_out_tbl_bt.LAST LOOP
254:
255: -- Push record to the Resource (insert in ACC)
256: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
257: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_STATEMENT);
258:
259: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
260: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 312: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'

308:
309: END LOOP;
310: END IF;
311:
312: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'
313: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);
314:
315: EXCEPTION
316: WHEN OTHERS THEN

Line 319: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES:' || l_sqlerrno || ':' || l_sqlerrmsg

315: EXCEPTION
316: WHEN OTHERS THEN
317: l_sqlerrno := to_char(SQLCODE);
318: l_sqlerrmsg := substr(SQLERRM, 1,2000);
319: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES:' || l_sqlerrno || ':' || l_sqlerrmsg
320: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_ERROR);
321: RAISE;
322: END INSERT_CONTRACT_TXN_TYPES;
323:

Line 358: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'

354: l_access_id number;
355: l_counter number;
356:
357: BEGIN
358: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'
359: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);
360:
361: /* The l_oks_rec_bp should contain the information about the contract line **
362: ** which the information should get from and the flags will make the criteria **

Line 414: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id

410: p_business_proc_id => l_oks_out_tbl_bp(i).bp_id
411: );
412:
413: -- Push record to the Resource (insert in ACC)
414: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
415: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_STATEMENT);
416:
417: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
418: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 463: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'

459:
460: END LOOP;
461: END IF;
462:
463: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'
464: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);
465:
466: EXCEPTION
467: WHEN OTHERS THEN

Line 470: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES:' || l_sqlerrno || ':' || l_sqlerrmsg

466: EXCEPTION
467: WHEN OTHERS THEN
468: l_sqlerrno := to_char(SQLCODE);
469: l_sqlerrmsg := substr(SQLERRM, 1,2000);
470: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES:' || l_sqlerrno || ':' || l_sqlerrmsg
471: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_ERROR);
472: RAISE;
473:
474: END INSERT_CONTRACT_BUSS_PROCESSES;

Line 517: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'

513: l_access_id number;
514: l_counter number;
515:
516: BEGIN
517: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
518: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_PROCEDURE);
519:
520: OPEN l_csm_contract_line_details(p_incident_id);
521: FETCH l_csm_contract_line_details INTO r_csm_contract_line_details;

Line 523: CSM_UTIL_PKG.LOG( 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id

519:
520: OPEN l_csm_contract_line_details(p_incident_id);
521: FETCH l_csm_contract_line_details INTO r_csm_contract_line_details;
522: IF l_csm_contract_line_details%NOTFOUND THEN
523: CSM_UTIL_PKG.LOG( 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
524: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_EXCEPTION);
525: ELSE
526: CSM_UTIL_PKG.LOG( 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id
527: || ', CONTRACT_SERVICE_ID: ' || r_csm_contract_line_details.contract_service_id

Line 526: CSM_UTIL_PKG.LOG( 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id

522: IF l_csm_contract_line_details%NOTFOUND THEN
523: CSM_UTIL_PKG.LOG( 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
524: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_EXCEPTION);
525: ELSE
526: CSM_UTIL_PKG.LOG( 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id
527: || ', CONTRACT_SERVICE_ID: ' || r_csm_contract_line_details.contract_service_id
528: || ', CONTRACT_NUMBER: ' || r_csm_contract_line_details.contract_number
529: || ', SERVICE_NAME: ' || r_csm_contract_line_details.name
530: || ', SERVICE_DESCRIPTION: ' || r_csm_contract_line_details.description

Line 540: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id

536: ( p_contract_service_id => r_csm_contract_line_details.contract_service_id
537: , p_user_id => p_user_id
538: );
539:
540: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
541: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_STATEMENT);
542:
543: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
544: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 590: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'

586:
587: END IF;
588: CLOSE l_csm_contract_line_details;
589:
590: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
591: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER' , FND_LOG.LEVEL_PROCEDURE);
592:
593: EXCEPTION
594: WHEN OTHERS THEN

Line 600: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER:' || l_sqlerrno || ':' || l_sqlerrmsg

596: CLOSE l_csm_contract_line_details;
597: END IF;
598: l_sqlerrno := to_char(SQLCODE);
599: l_sqlerrmsg := substr(SQLERRM, 1,2000);
600: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER:' || l_sqlerrno || ':' || l_sqlerrmsg
601: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_ERROR);
602: RAISE;
603: END INSERT_CONTRACT_HEADER;
604:

Line 642: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'

638: AND contract_service_id = p_contractserviceid
639: AND business_process_id = p_businessprocessid;
640:
641: BEGIN
642: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'
643: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);
644:
645: FOR r_contr_headers_rec IN l_contr_headers_csr(p_incident_id, p_user_id) LOOP
646:

Line 652: CSM_UTIL_PKG.LOG( 'Deleting Buss Txn type ACC record for user_id = ' || p_user_id ||

648:
649: FOR r_contr_buss_txn_types_rec IN l_contr_buss_txn_types_csr(r_contr_buss_processes_rec.contract_service_id,
650: r_contr_buss_processes_rec.business_process_id,
651: p_user_id) LOOP
652: CSM_UTIL_PKG.LOG( 'Deleting Buss Txn type ACC record for user_id = ' || p_user_id ||
653: ', contract_service_id = ' || r_contr_buss_txn_types_rec.contract_service_id ||
654: ', business_process_id = ' || r_contr_buss_txn_types_rec.business_process_id ||
655: ', txn_billing_type_id = ' || r_contr_buss_txn_types_rec.txn_billing_type_id
656: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);

Line 671: CSM_UTIL_PKG.LOG( 'Deleting Buss proc ACC record for user_id = ' || p_user_id ||

667: ,P_USER_ID => p_user_id
668: );
669: END LOOP;
670:
671: CSM_UTIL_PKG.LOG( 'Deleting Buss proc ACC record for user_id = ' || p_user_id ||
672: ', contract_service_id = ' || r_contr_buss_processes_rec.contract_service_id ||
673: ', business_process_id = ' || r_contr_buss_processes_rec.business_process_id
674: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
675:

Line 693: CSM_UTIL_PKG.LOG( 'Deleting Contract Header ACC record for user_id = ' || p_user_id ||

689: p_business_proc_id => r_contr_buss_processes_rec.business_process_id
690: );
691: END LOOP;
692:
693: CSM_UTIL_PKG.LOG( 'Deleting Contract Header ACC record for user_id = ' || p_user_id ||
694: ', incident_id = ' || p_incident_id
695: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
696:
697: CSM_ACC_PKG.Delete_Acc

Line 707: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'

703: );
704:
705: END LOOP;
706:
707: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'
708: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);
709:
710:
711: EXCEPTION

Line 715: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC:' || l_sqlerrno || ':' || l_sqlerrmsg

711: EXCEPTION
712: WHEN OTHERS THEN
713: l_sqlerrno := to_char(SQLCODE);
714: l_sqlerrmsg := substr(SQLERRM, 1,2000);
715: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC:' || l_sqlerrno || ':' || l_sqlerrmsg
716: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_ERROR);
717: RAISE;
718:
719: END DELETE_SR_CONTRACT_ACC;

Line 771: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),

767: end loop;
768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),
772: 'CSM_CONTRACT_EVENT_PKG.DELETE_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
773: RAISE;
774:
775: END DELETE_OKS_NOTES_ACC;

Line 821: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),

817:
818: end loop;
819:
820: EXCEPTION WHEN OTHERS THEN
821: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),
822: 'CSM_CONTRACT_EVENT_PKG.INSERT_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
823: RAISE;
824:
825: END INSERT_OKS_NOTES_ACC;

Line 835: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,

831: l_error_msg VARCHAR2(4000);
832: l_return_status VARCHAR2(2000);
833:
834: BEGIN
835: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,
836: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);
837:
838: INSERT_CONTRACT_HEADER( p_incident_id => p_incident_id
839: , p_user_id => p_user_id);

Line 841: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,

837:
838: INSERT_CONTRACT_HEADER( p_incident_id => p_incident_id
839: , p_user_id => p_user_id);
840:
841: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,
842: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);
843: EXCEPTION
844: WHEN OTHERS THEN
845: l_sqlerrno := to_char(SQLCODE);

Line 849: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_EXCEPTION);

845: l_sqlerrno := to_char(SQLCODE);
846: l_sqlerrmsg := substr(SQLERRM, 1,2000);
847: l_error_msg := ' Exception in SR_CONTRACT_ACC_I for incident_id:'
848: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
849: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_EXCEPTION);
850: RAISE;
851: END SR_CONTRACT_ACC_I;
852:
853: PROCEDURE SR_CONTRACT_ACC_D (p_incident_id IN NUMBER, p_user_id IN NUMBER)

Line 861: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,

857: l_error_msg VARCHAR2(4000);
858: l_return_status VARCHAR2(2000);
859:
860: BEGIN
861: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,
862: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);
863:
864: DELETE_SR_CONTRACT_ACC
865: ( p_incident_id => p_incident_id

Line 869: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,

865: ( p_incident_id => p_incident_id
866: , p_user_id => p_user_id
867: );
868:
869: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,
870: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);
871: EXCEPTION
872: WHEN OTHERS THEN
873: l_sqlerrno := to_char(SQLCODE);

Line 877: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_EXCEPTION);

873: l_sqlerrno := to_char(SQLCODE);
874: l_sqlerrmsg := substr(SQLERRM, 1,2000);
875: l_error_msg := ' Exception in SR_CONTRACT_ACC_D for incident_id:'
876: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
877: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_EXCEPTION);
878: RAISE;
879: END SR_CONTRACT_ACC_D;
880:
881: PROCEDURE SR_CONTRACT_ACC_U (p_incident_id IN NUMBER, p_old_contract_service_id IN NUMBER,

Line 890: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,

886: l_error_msg VARCHAR2(4000);
887: l_return_status VARCHAR2(2000);
888:
889: BEGIN
890: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,
891: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);
892:
893: IF p_old_contract_service_id IS NOT NULL THEN
894: /* The contract service id is updated for the SR **

Line 919: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,

915: p_user_id => p_user_id);
916:
917: END IF;
918:
919: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,
920: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);
921: EXCEPTION
922: WHEN OTHERS THEN
923: l_sqlerrno := to_char(SQLCODE);

Line 927: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_EXCEPTION);

923: l_sqlerrno := to_char(SQLCODE);
924: l_sqlerrmsg := substr(SQLERRM, 1,2000);
925: l_error_msg := ' Exception in SR_CONTRACT_ACC_U for incident_id:'
926: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
927: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_EXCEPTION);
928: RAISE;
929: END SR_CONTRACT_ACC_U;
930:
931: END CSM_CONTRACT_EVENT_PKG;