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 76: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'

72: l_access_id number;
73: l_counter number;
74:
75: BEGIN
76: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'
77: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);
78:
79: /* This call to the Contracts API will return the Txn billing types in table **
80: ** variable: l_oks_out_tbl_bt **

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

100: /* Looping over the table if table contain any record(s) */
101: FOR i IN l_oks_out_tbl_bt.FIRST .. l_oks_out_tbl_bt.LAST LOOP
102:
103: -- Push record to the Resource (insert in ACC)
104: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
105: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_STATEMENT);
106:
107: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
108: ,P_ACC_TABLE_NAME => g_acc_table_name3

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

156:
157: END LOOP;
158: END IF;
159:
160: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES'
161: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_PROCEDURE);
162:
163: EXCEPTION
164: WHEN OTHERS THEN

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

163: EXCEPTION
164: WHEN OTHERS THEN
165: l_sqlerrno := to_char(SQLCODE);
166: l_sqlerrmsg := substr(SQLERRM, 1,2000);
167: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES:' || l_sqlerrno || ':' || l_sqlerrmsg
168: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_ERROR);
169: RAISE;
170: END INSERT_CONTRACT_TXN_TYPES;
171:

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

202: l_access_id number;
203: l_counter number;
204:
205: BEGIN
206: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'
207: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);
208:
209: /* The l_oks_rec_bp should contain the information about the contract line **
210: ** which the information should get from and the flags will make the criteria **

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

251: , p_user_id => p_user_id
252: );
253:
254: -- Push record to the Resource (insert in ACC)
255: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
256: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_STATEMENT);
257:
258: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
259: ,P_ACC_TABLE_NAME => g_acc_table_name2

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

300:
301: END LOOP;
302: END IF;
303:
304: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES'
305: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_PROCEDURE);
306:
307: EXCEPTION
308: WHEN OTHERS THEN

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

307: EXCEPTION
308: WHEN OTHERS THEN
309: l_sqlerrno := to_char(SQLCODE);
310: l_sqlerrmsg := substr(SQLERRM, 1,2000);
311: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES:' || l_sqlerrno || ':' || l_sqlerrmsg
312: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_ERROR);
313: RAISE;
314:
315: END INSERT_CONTRACT_BUSS_PROCESSES;

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

354: l_access_id number;
355: l_counter number;
356:
357: BEGIN
358: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
359: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_PROCEDURE);
360:
361: OPEN l_csm_contract_line_details(p_incident_id);
362: FETCH l_csm_contract_line_details INTO r_csm_contract_line_details;

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

360:
361: OPEN l_csm_contract_line_details(p_incident_id);
362: FETCH l_csm_contract_line_details INTO r_csm_contract_line_details;
363: IF l_csm_contract_line_details%NOTFOUND THEN
364: CSM_UTIL_PKG.LOG( 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
365: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_EXCEPTION);
366: ELSE
367: CSM_UTIL_PKG.LOG( 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id
368: || ', CONTRACT_SERVICE_ID: ' || r_csm_contract_line_details.contract_service_id

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

363: IF l_csm_contract_line_details%NOTFOUND THEN
364: CSM_UTIL_PKG.LOG( 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
365: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_EXCEPTION);
366: ELSE
367: CSM_UTIL_PKG.LOG( 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id
368: || ', CONTRACT_SERVICE_ID: ' || r_csm_contract_line_details.contract_service_id
369: || ', CONTRACT_NUMBER: ' || r_csm_contract_line_details.contract_number
370: || ', SERVICE_NAME: ' || r_csm_contract_line_details.name
371: || ', SERVICE_DESCRIPTION: ' || r_csm_contract_line_details.description

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

377: ( p_contract_service_id => r_csm_contract_line_details.contract_service_id
378: , p_user_id => p_user_id
379: );
380:
381: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
382: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_STATEMENT);
383:
384: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
385: ,P_ACC_TABLE_NAME => g_acc_table_name1

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

427:
428: END IF;
429: CLOSE l_csm_contract_line_details;
430:
431: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
432: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER' , FND_LOG.LEVEL_PROCEDURE);
433:
434: EXCEPTION
435: WHEN OTHERS THEN

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

437: CLOSE l_csm_contract_line_details;
438: END IF;
439: l_sqlerrno := to_char(SQLCODE);
440: l_sqlerrmsg := substr(SQLERRM, 1,2000);
441: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER:' || l_sqlerrno || ':' || l_sqlerrmsg
442: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_ERROR);
443: RAISE;
444: END INSERT_CONTRACT_HEADER;
445:

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

479: AND contract_service_id = p_contractserviceid
480: AND business_process_id = p_businessprocessid;
481:
482: BEGIN
483: CSM_UTIL_PKG.LOG( 'Entering CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'
484: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);
485:
486: FOR r_contr_headers_rec IN l_contr_headers_csr(p_incident_id, p_user_id) LOOP
487:

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

489:
490: FOR r_contr_buss_txn_types_rec IN l_contr_buss_txn_types_csr(r_contr_buss_processes_rec.contract_service_id,
491: r_contr_buss_processes_rec.business_process_id,
492: p_user_id) LOOP
493: CSM_UTIL_PKG.LOG( 'Deleting Buss Txn type ACC record for user_id = ' || p_user_id ||
494: ', contract_service_id = ' || r_contr_buss_txn_types_rec.contract_service_id ||
495: ', business_process_id = ' || r_contr_buss_txn_types_rec.business_process_id ||
496: ', txn_billing_type_id = ' || r_contr_buss_txn_types_rec.txn_billing_type_id
497: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);

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

508: ,P_USER_ID => p_user_id
509: );
510: END LOOP;
511:
512: CSM_UTIL_PKG.LOG( 'Deleting Buss proc ACC record for user_id = ' || p_user_id ||
513: ', contract_service_id = ' || r_contr_buss_processes_rec.contract_service_id ||
514: ', business_process_id = ' || r_contr_buss_processes_rec.business_process_id
515: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
516:

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

525: );
526:
527: END LOOP;
528:
529: CSM_UTIL_PKG.LOG( 'Deleting Contract Header ACC record for user_id = ' || p_user_id ||
530: ', incident_id = ' || p_incident_id
531: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
532:
533: CSM_ACC_PKG.Delete_Acc

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

539: );
540:
541: END LOOP;
542:
543: CSM_UTIL_PKG.LOG( 'Leaving CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC'
544: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_PROCEDURE);
545:
546:
547: EXCEPTION

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

547: EXCEPTION
548: WHEN OTHERS THEN
549: l_sqlerrno := to_char(SQLCODE);
550: l_sqlerrmsg := substr(SQLERRM, 1,2000);
551: CSM_UTIL_PKG.LOG( 'Exception occured in CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC:' || l_sqlerrno || ':' || l_sqlerrmsg
552: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_ERROR);
553: RAISE;
554:
555: END DELETE_SR_CONTRACT_ACC;

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

603: end loop;
604:
605: EXCEPTION
606: WHEN OTHERS THEN
607: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),
608: 'CSM_CONTRACT_EVENT_PKG.DELETE_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
609: RAISE;
610:
611: END DELETE_OKS_NOTES_ACC;

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

653:
654: end loop;
655:
656: EXCEPTION WHEN OTHERS THEN
657: CSM_UTIL_PKG.LOG( sqlerrm|| ' for Contract_Service_Id ' || to_char(l_sourceobjectid),
658: 'CSM_CONTRACT_EVENT_PKG.INSERT_OKS_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
659: RAISE;
660:
661: END INSERT_OKS_NOTES_ACC;

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

667: l_error_msg VARCHAR2(4000);
668: l_return_status VARCHAR2(2000);
669:
670: BEGIN
671: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,
672: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);
673:
674: INSERT_CONTRACT_HEADER( p_incident_id => p_incident_id
675: , p_user_id => p_user_id);

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

673:
674: INSERT_CONTRACT_HEADER( p_incident_id => p_incident_id
675: , p_user_id => p_user_id);
676:
677: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_I for incident_id: ' || p_incident_id,
678: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_PROCEDURE);
679: EXCEPTION
680: WHEN OTHERS THEN
681: l_sqlerrno := to_char(SQLCODE);

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

681: l_sqlerrno := to_char(SQLCODE);
682: l_sqlerrmsg := substr(SQLERRM, 1,2000);
683: l_error_msg := ' Exception in SR_CONTRACT_ACC_I for incident_id:'
684: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
685: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_I',FND_LOG.LEVEL_EXCEPTION);
686: RAISE;
687: END SR_CONTRACT_ACC_I;
688:
689: PROCEDURE SR_CONTRACT_ACC_D (p_incident_id IN NUMBER, p_user_id IN NUMBER)

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

693: l_error_msg VARCHAR2(4000);
694: l_return_status VARCHAR2(2000);
695:
696: BEGIN
697: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,
698: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);
699:
700: DELETE_SR_CONTRACT_ACC
701: ( p_incident_id => p_incident_id

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

701: ( p_incident_id => p_incident_id
702: , p_user_id => p_user_id
703: );
704:
705: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_D for incident_id: ' || p_incident_id,
706: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_PROCEDURE);
707: EXCEPTION
708: WHEN OTHERS THEN
709: l_sqlerrno := to_char(SQLCODE);

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

709: l_sqlerrno := to_char(SQLCODE);
710: l_sqlerrmsg := substr(SQLERRM, 1,2000);
711: l_error_msg := ' Exception in SR_CONTRACT_ACC_D for incident_id:'
712: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
713: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_D',FND_LOG.LEVEL_EXCEPTION);
714: RAISE;
715: END SR_CONTRACT_ACC_D;
716:
717: PROCEDURE SR_CONTRACT_ACC_U (p_incident_id IN NUMBER, p_old_contract_service_id IN NUMBER,

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

722: l_error_msg VARCHAR2(4000);
723: l_return_status VARCHAR2(2000);
724:
725: BEGIN
726: CSM_UTIL_PKG.LOG('Entering SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,
727: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);
728:
729: IF p_old_contract_service_id IS NOT NULL THEN
730: /* The contract service id is updated for the SR **

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

751: p_user_id => p_user_id);
752:
753: END IF;
754:
755: CSM_UTIL_PKG.LOG('Leaving SR_CONTRACT_ACC_U for incident_id: ' || p_incident_id,
756: 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_PROCEDURE);
757: EXCEPTION
758: WHEN OTHERS THEN
759: l_sqlerrno := to_char(SQLCODE);

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

759: l_sqlerrno := to_char(SQLCODE);
760: l_sqlerrmsg := substr(SQLERRM, 1,2000);
761: l_error_msg := ' Exception in SR_CONTRACT_ACC_U for incident_id:'
762: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
763: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CONTRACT_EVENT_PKG.SR_CONTRACT_ACC_U',FND_LOG.LEVEL_EXCEPTION);
764: RAISE;
765: END SR_CONTRACT_ACC_U;
766:
767: END CSM_CONTRACT_EVENT_PKG;