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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 374: , FND_LOG.LEVEL_STATEMENT);

370: || ', SERVICE_NAME: ' || r_csm_contract_line_details.name
371: || ', SERVICE_DESCRIPTION: ' || r_csm_contract_line_details.description
372: || ', AMOUNT_UOM_CODE: ' || r_csm_contract_line_details.currency_code
373: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER'
374: , FND_LOG.LEVEL_STATEMENT);
375:
376: INSERT_CONTRACT_BUSS_PROCESSES
377: ( p_contract_service_id => r_csm_contract_line_details.contract_service_id
378: , p_user_id => p_user_id

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

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

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

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

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

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

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

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

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

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);
498:
499: CSM_ACC_PKG.Delete_Acc
500: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
501: ,P_ACC_TABLE_NAME => g_acc_table_name3

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

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:
517: CSM_ACC_PKG.Delete_Acc
518: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
519: ,P_ACC_TABLE_NAME => g_acc_table_name2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;