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 FND_LOG

Line 82: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);

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);
86: FETCH c_get_cov_id INTO l_bus_proc_cle_id;

Line 96: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_STATEMENT);

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
99: ,P_ACC_TABLE_NAME => g_acc_table_name4
100: ,P_SEQ_NAME => g_sequence_name4

Line 123: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);

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

Line 130: , 'CSM_CONTRACT_EVENT_PKG.INSERT_COV_ACTION_TIMES', FND_LOG.LEVEL_ERROR);

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

Line 155: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);

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:
159: -- Push record to the Resource (insert in ACC)

Line 162: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_STATEMENT);

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
165: ,P_ACC_TABLE_NAME => g_acc_table_name4
166: ,P_PK1_NAME => g_pk1_name4

Line 178: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_PROCEDURE);

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

Line 185: , 'CSM_CONTRACT_EVENT_PKG.DELETE_COV_ACTION_TIMES', FND_LOG.LEVEL_ERROR);

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

Line 229: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);

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 **
233: ** This table should contain the following information: **

Line 257: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_STATEMENT);

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
261: ,P_SEQ_NAME => g_sequence_name3

Line 313: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);

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

Line 320: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_ERROR);

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

Line 359: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);

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 **
363: ** of the result set which you're interest in */

Line 415: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_STATEMENT);

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
419: ,P_SEQ_NAME => g_sequence_name2

Line 464: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);

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

Line 471: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_ERROR);

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

Line 518: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_PROCEDURE);

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;
522: IF l_csm_contract_line_details%NOTFOUND THEN

Line 524: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_EXCEPTION);

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
528: || ', CONTRACT_NUMBER: ' || r_csm_contract_line_details.contract_number

Line 533: , FND_LOG.LEVEL_STATEMENT);

529: || ', SERVICE_NAME: ' || r_csm_contract_line_details.name
530: || ', SERVICE_DESCRIPTION: ' || r_csm_contract_line_details.description
531: || ', AMOUNT_UOM_CODE: ' || r_csm_contract_line_details.currency_code
532: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
533: , FND_LOG.LEVEL_STATEMENT);
534:
535: INSERT_CONTRACT_BUSS_PROCESSES
536: ( p_contract_service_id => r_csm_contract_line_details.contract_service_id
537: , p_user_id => p_user_id

Line 541: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_STATEMENT);

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
545: ,P_SEQ_NAME => g_sequence_name1

Line 591: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER' , FND_LOG.LEVEL_PROCEDURE);

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
595: IF l_csm_contract_line_details%ISOPEN THEN

Line 601: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_ERROR);

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

Line 643: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);

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:
647: FOR r_contr_buss_processes_rec IN l_contr_buss_processes_csr(r_contr_headers_rec.contract_service_id, p_user_id) LOOP

Line 656: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);

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);
657:
658: CSM_ACC_PKG.Delete_Acc
659: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
660: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 674: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);

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:
676: CSM_ACC_PKG.Delete_Acc
677: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
678: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 695: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);

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
698: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
699: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 708: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);

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

Line 716: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_ERROR);

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

Line 772: 'CSM_CONTRACT_EVENT_PKG.DELETE_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);

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

Line 822: 'CSM_CONTRACT_EVENT_PKG.INSERT_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);

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

Line 836: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);

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

Line 842: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);

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

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 862: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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

Line 870: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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

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 891: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);

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 **
895: ** the ACC records has to be deleted for this SR-contract records */

Line 920: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);

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

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;