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.CSL_CONTRACT_HANDLING_PKG dependencies on CSL_CONTRACT_HANDLING_PKG

Line 1: PACKAGE BODY CSL_CONTRACT_HANDLING_PKG AS

1: PACKAGE BODY CSL_CONTRACT_HANDLING_PKG AS
2: /* $Header: cslctrhb.pls 120.0 2005/05/25 11:06:41 appldev noship $ */
3:
4: /*** Globals ***/
5:

Line 51: , 'csl_contract_handling_pkg');

47: ( p_incident_id
48: , g_table_name1
49: , 'Entering INSERT_TXN_TYPES_RECORD'
50: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
51: , 'csl_contract_handling_pkg');
52: END IF;
53:
54: INSERT INTO CSL_CONTR_BUSS_TXN_TYPES
55: ( INCIDENT_ID

Line 85: , 'csl_contract_handling_pkg');

81: ( p_incident_id
82: , g_table_name1
83: , 'Leaving INSERT_TXN_TYPES_RECORD'
84: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
85: , 'csl_contract_handling_pkg');
86: END IF;
87:
88: RETURN TRUE;
89:

Line 98: , 'csl_contract_handling_pkg');

94: ( p_incident_id
95: , g_table_name1
96: , 'Exception occured in INSERT_TXN_TYPES_RECORD'
97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
98: , 'csl_contract_handling_pkg');
99: END IF;
100: RETURN FALSE;
101: END INSERT_TXN_TYPES_RECORD;
102:

Line 149: , 'csl_contract_handling_pkg');

145: ( p_incident_id
146: , g_table_name1
147: , 'Entering INSERT_CONTRACT_TXN_TYPES'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
149: , 'csl_contract_handling_pkg');
150: END IF;
151:
152: /* This call to the Contracts API will return the Txn billing types in table
153: ** variable: l_oks_out_tbl_bt

Line 207: , 'csl_contract_handling_pkg');

203: ( l_oks_out_tbl_bt(i).txn_bt_line_id
204: , g_table_name3
205: , 'Inserting ACC record for resource_id = ' || p_resource_id
206: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
207: , 'csl_contract_handling_pkg');
208: END IF;
209:
210: JTM_HOOK_UTIL_PKG.Insert_Acc
211: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3

Line 235: , 'csl_contract_handling_pkg');

231: ( p_incident_id
232: , g_table_name1
233: , 'Leaving INSERT_CONTRACT_TXN_TYPES'
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
235: , 'csl_contract_handling_pkg');
236: END IF;
237:
238: RETURN l_effected_records;
239:

Line 248: , 'csl_contract_handling_pkg');

244: ( p_incident_id
245: , g_table_name1
246: , 'Exception occured in INSERT_CONTRACT_TXN_TYPES'
247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
248: , 'csl_contract_handling_pkg');
249: END IF;
250: RETURN l_effected_records;
251: END INSERT_CONTRACT_TXN_TYPES;
252:

Line 270: , 'csl_contract_handling_pkg');

266: ( p_incident_id
267: , g_table_name1
268: , 'Entering INSERT_BUSS_PROCESSES_RECORD'
269: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
270: , 'csl_contract_handling_pkg');
271: END IF;
272:
273: INSERT INTO CSL_CONTR_BUSS_PROCESSES
274: ( INCIDENT_ID

Line 302: , 'csl_contract_handling_pkg');

298: ( p_incident_id
299: , g_table_name1
300: , 'Leaving INSERT_BUSS_PROCESSES_RECORD'
301: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
302: , 'csl_contract_handling_pkg');
303: END IF;
304:
305: RETURN TRUE;
306:

Line 315: , 'csl_contract_handling_pkg');

311: ( p_incident_id
312: , g_table_name1
313: , 'Exception occured in INSERT_BUSS_PROCESSES_RECORD'
314: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
315: , 'csl_contract_handling_pkg');
316: END IF;
317: RETURN FALSE;
318: END INSERT_BUSS_PROCESSES_RECORD;
319:

Line 358: , 'csl_contract_handling_pkg');

354: ( p_incident_id
355: , g_table_name1
356: , 'Entering INSERT_CONTRACT_BUSS_PROCESSES'
357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
358: , 'csl_contract_handling_pkg');
359: END IF;
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 403: , 'csl_contract_handling_pkg');

399: ( p_incident_id
400: , g_table_name1
401: , 'Processing business_process_id ' || l_oks_out_tbl_bp(i).bp_id
402: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
403: , 'csl_contract_handling_pkg');
404: END IF;
405:
406: OPEN c_csl_contr_bus_proc
407: ( p_incident_id

Line 443: , 'csl_contract_handling_pkg');

439: ( l_oks_out_tbl_bp(i).bp_id
440: , g_table_name2
441: , 'Inserting ACC record for resource_id = ' || p_resource_id
442: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
443: , 'csl_contract_handling_pkg');
444: END IF;
445:
446: JTM_HOOK_UTIL_PKG.Insert_Acc
447: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

Line 469: , 'csl_contract_handling_pkg');

465: ( p_incident_id
466: , g_table_name1
467: , 'Leaving INSERT_CONTRACT_BUSS_PROCESSES'
468: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
469: , 'csl_contract_handling_pkg');
470: END IF;
471:
472: RETURN l_effected_records;
473:

Line 482: , 'csl_contract_handling_pkg');

478: ( p_incident_id
479: , g_table_name1
480: , 'Exception occured in INSERT_CONTRACT_BUSS_PROCESSES'
481: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
482: , 'csl_contract_handling_pkg');
483: END IF;
484: RETURN l_effected_records;
485: END INSERT_CONTRACT_BUSS_PROCESSES;
486:

Line 505: , 'csl_contract_handling_pkg');

501: ( p_incident_id
502: , g_table_name1
503: , 'Entering INSERT_CONTRACT_HEADER_RECORD'
504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
505: , 'csl_contract_handling_pkg');
506: END IF;
507:
508: INSERT INTO CSL_SR_CONTRACT_HEADERS
509: ( INCIDENT_ID

Line 539: , 'csl_contract_handling_pkg');

535: ( p_incident_id
536: , g_table_name1
537: , 'Leaving INSERT_CONTRACT_HEADER_RECORD'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
539: , 'csl_contract_handling_pkg');
540: END IF;
541:
542: RETURN TRUE;
543:

Line 552: , 'csl_contract_handling_pkg');

548: ( p_incident_id
549: , g_table_name1
550: , 'Exception occured in INSERT_CONTRACT_HEADER_RECORD'
551: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
552: , 'csl_contract_handling_pkg');
553: END IF;
554: RETURN FALSE;
555: END INSERT_CONTRACT_HEADER_RECORD;
556:

Line 617: , 'csl_contract_handling_pkg');

613: ( p_incident_id
614: , g_table_name1
615: , 'Entering INSERT_CONTRACT_HEADER'
616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
617: , 'csl_contract_handling_pkg');
618: END IF;
619:
620: OPEN c_csl_contr_record(p_incident_id);
621: FETCH c_csl_contr_record INTO r_csl_contr_record;

Line 630: , 'csl_contract_handling_pkg');

626: ( p_incident_id
627: , g_table_name1
628: , 'Contract Line for INCIDENT_ID: ' || p_incident_id || ' does not exist in CSL_SR_CONTRACT_HEADERS'
629: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
630: , 'csl_contract_handling_pkg');
631:
632: jtm_message_log_pkg.Log_Msg
633: ( p_incident_id
634: , g_table_name1

Line 637: , 'csl_contract_handling_pkg');

633: ( p_incident_id
634: , g_table_name1
635: , 'Getting the details of the Contract Line for INCIDENT_ID: ' || p_incident_id
636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
637: , 'csl_contract_handling_pkg');
638: END IF;
639:
640: OPEN c_csl_contract_line_details(p_incident_id);
641: FETCH c_csl_contract_line_details INTO l_contract_service_id

Line 653: , 'csl_contract_handling_pkg');

649: ( p_incident_id
650: , g_table_name1
651: , 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
652: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
653: , 'csl_contract_handling_pkg');
654: END IF;
655: ELSE
656:
657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 668: , 'csl_contract_handling_pkg');

664: || ', CONTRACT_SERVICE_ID: ' || l_service_name
665: || ', CONTRACT_SERVICE_ID: ' || l_service_description
666: || ', CONTRACT_SERVICE_ID: ' || l_amount_uom_code
667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
668: , 'csl_contract_handling_pkg');
669: END IF;
670:
671: /* Insert the new contract line record into the CSL contract table */
672: l_success := INSERT_CONTRACT_HEADER_RECORD

Line 708: , 'csl_contract_handling_pkg');

704: ( p_incident_id
705: , g_table_name1
706: , 'Inserting ACC record for resource_id = ' || p_resource_id
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
708: , 'csl_contract_handling_pkg');
709: END IF;
710:
711: -- Bug 3107687 fix:
712: -- check if bus process is not empty insert header info to acc table.

Line 738: , 'csl_contract_handling_pkg');

734: , g_table_name1
735: , 'Inserting Contract Notes Failed for resource_id = '
736: || p_resource_id
737: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
738: , 'csl_contract_handling_pkg');
739: END IF;
740: END IF;
741:
742: END IF;

Line 751: , 'csl_contract_handling_pkg');

747: ( p_incident_id
748: , g_table_name1
749: , 'Leaving INSERT_CONTRACT_HEADER'
750: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
751: , 'csl_contract_handling_pkg');
752: END IF;
753:
754: RETURN TRUE;
755:

Line 764: , 'csl_contract_handling_pkg');

760: ( p_incident_id
761: , g_table_name1
762: , 'Exception occured in INSERT_CONTRACT_HEADER'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
764: , 'csl_contract_handling_pkg');
765: END IF;
766: RETURN FALSE;
767: END INSERT_CONTRACT_HEADER;
768:

Line 787: , 'csl_contract_handling_pkg');

783: ( p_incident_id
784: , g_table_name1
785: , 'Entering DELETE_SR_CONTRACT_ACC'
786: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
787: , 'csl_contract_handling_pkg');
788: END IF;
789:
790: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
791: jtm_message_log_pkg.Log_Msg

Line 796: , 'csl_contract_handling_pkg'

792: ( p_incident_id
793: , g_table_name1
794: , 'Deleting Header ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
795: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
796: , 'csl_contract_handling_pkg'
797: );
798: END IF;
799:
800: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 814: , 'csl_contract_handling_pkg');

810: ( p_incident_id
811: , g_table_name2
812: , 'Deleting Buss proc ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
813: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
814: , 'csl_contract_handling_pkg');
815: END IF;
816:
817: JTM_HOOK_UTIL_PKG.Delete_Acc
818: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

Line 831: , 'csl_contract_handling_pkg');

827: ( p_incident_id
828: , g_table_name3
829: , 'Deleting Buss Txn type ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
830: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
831: , 'csl_contract_handling_pkg');
832: END IF;
833:
834: JTM_HOOK_UTIL_PKG.Delete_Acc
835: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3

Line 856: , 'csl_contract_handling_pkg');

852: ( p_incident_id
853: , g_table_name1
854: , 'Leaving DELETE_SR_CONTRACT_ACC'
855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
856: , 'csl_contract_handling_pkg');
857: END IF;
858:
859: EXCEPTION
860: WHEN OTHERS THEN

Line 867: , 'csl_contract_handling_pkg');

863: ( p_incident_id
864: , g_table_name1
865: , 'Exception occured in DELETE_SR_CONTRACT_ACC'
866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
867: , 'csl_contract_handling_pkg');
868: END IF;
869: END DELETE_SR_CONTRACT_ACC;
870:
871:

Line 889: , 'csl_contract_handling_pkg');

885: ( p_incident_id
886: , g_table_name1
887: , 'Entering POST_INSERT_SR_CONTRACT_ACC'
888: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
889: , 'csl_contract_handling_pkg');
890: END IF;
891:
892: l_success := INSERT_CONTRACT_HEADER
893: ( p_incident_id => p_incident_id

Line 909: , 'csl_contract_handling_pkg');

905: ( p_incident_id
906: , g_table_name1
907: , 'Leaving POST_INSERT_SR_CONTRACT_ACC'
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
909: , 'csl_contract_handling_pkg');
910: END IF;
911:
912: END POST_INSERT_SR_CONTRACT_ACC;
913:

Line 939: , 'csl_contract_handling_pkg');

935: ( p_incident_id
936: , g_table_name1
937: , 'Entering POST_UPDATE_SR_CONTRACT_ACC'
938: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
939: , 'csl_contract_handling_pkg');
940: END IF;
941:
942: /*** is new contract different from contract stored in csl_sr_contract_headers? ***/
943: OPEN c_csl_contr_record( p_incident_id );

Line 982: , 'csl_contract_handling_pkg');

978: ( p_incident_id
979: , g_table_name1
980: , 'Leaving POST_UPDATE_SR_CONTRACT_ACC'
981: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
982: , 'csl_contract_handling_pkg');
983: END IF;
984:
985: END POST_UPDATE_SR_CONTRACT_ACC;
986:

Line 1010: , 'csl_contract_handling_pkg');

1006: ( p_incident_id
1007: , g_table_name1
1008: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'
1009: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1010: , 'csl_contract_handling_pkg');
1011: END IF;
1012:
1013: OPEN c_csl_contr_record (p_incident_id);
1014: FETCH c_csl_contr_record INTO r_csl_contr_record;

Line 1032: , 'csl_contract_handling_pkg');

1028: ( p_incident_id
1029: , g_table_name1
1030: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'
1031: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1032: , 'csl_contract_handling_pkg');
1033: END IF;
1034:
1035: END PRE_DELETE_SR_CONTRACT_ACC;
1036:

Line 1037: END CSL_CONTRACT_HANDLING_PKG;

1033: END IF;
1034:
1035: END PRE_DELETE_SR_CONTRACT_ACC;
1036:
1037: END CSL_CONTRACT_HANDLING_PKG;