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 JTM_HOOK_UTIL_PKG

Line 8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

4: /*** Globals ***/
5:
6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');
10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';
11: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12:

Line 9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');

5:
6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');
10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';
11: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12:
13: -- CSL_CONTR_BUSS_PROCESSES

Line 15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

11: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12:
13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');

12:
13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
20:

Line 23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
20:
21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
27: g_pk2_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';

Line 24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');

20:
21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
27: g_pk2_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
28: g_pk3_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 45: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

41: RETURN BOOLEAN
42: IS
43: BEGIN
44:
45: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_incident_id
48: , g_table_name1
49: , 'Entering INSERT_TXN_TYPES_RECORD'

Line 50: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

46: jtm_message_log_pkg.Log_Msg
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

Line 79: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

75: , sysdate
76: , 1
77: );
78:
79: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
80: jtm_message_log_pkg.Log_Msg
81: ( p_incident_id
82: , g_table_name1
83: , 'Leaving INSERT_TXN_TYPES_RECORD'

Line 84: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

80: jtm_message_log_pkg.Log_Msg
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;

Line 92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

88: RETURN TRUE;
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
93: jtm_message_log_pkg.Log_Msg
94: ( p_incident_id
95: , g_table_name1
96: , 'Exception occured in INSERT_TXN_TYPES_RECORD'

Line 97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

93: jtm_message_log_pkg.Log_Msg
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;

Line 143: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

139: x_msg_count NUMBER;
140: x_msg_data VARCHAR2(4000);
141: BEGIN
142:
143: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
144: jtm_message_log_pkg.Log_Msg
145: ( p_incident_id
146: , g_table_name1
147: , 'Entering INSERT_CONTRACT_TXN_TYPES'

Line 148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

144: jtm_message_log_pkg.Log_Msg
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

Line 201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

197: CLOSE c_csl_contr_txn_types;
198:
199: IF l_success THEN
200: -- Push record to the Resource (insert in ACC)
201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
202: jtm_message_log_pkg.Log_Msg
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

Line 206: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

202: jtm_message_log_pkg.Log_Msg
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

Line 210: JTM_HOOK_UTIL_PKG.Insert_Acc

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
212: ,P_ACC_TABLE_NAME => g_acc_table_name3
213: ,P_RESOURCE_ID => p_resource_id
214: ,P_PK1_NAME => g_pk1_name3

Line 229: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

225:
226: END LOOP;
227: END IF;
228:
229: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
230: jtm_message_log_pkg.Log_Msg
231: ( p_incident_id
232: , g_table_name1
233: , 'Leaving INSERT_CONTRACT_TXN_TYPES'

Line 234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

230: jtm_message_log_pkg.Log_Msg
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;

Line 242: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

238: RETURN l_effected_records;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
243: jtm_message_log_pkg.Log_Msg
244: ( p_incident_id
245: , g_table_name1
246: , 'Exception occured in INSERT_CONTRACT_TXN_TYPES'

Line 247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

243: jtm_message_log_pkg.Log_Msg
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;

Line 264: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

260: RETURN BOOLEAN
261: IS
262: BEGIN
263:
264: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
265: jtm_message_log_pkg.Log_Msg
266: ( p_incident_id
267: , g_table_name1
268: , 'Entering INSERT_BUSS_PROCESSES_RECORD'

Line 269: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

265: jtm_message_log_pkg.Log_Msg
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

Line 296: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

292: , sysdate
293: , 1
294: );
295:
296: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
297: jtm_message_log_pkg.Log_Msg
298: ( p_incident_id
299: , g_table_name1
300: , 'Leaving INSERT_BUSS_PROCESSES_RECORD'

Line 301: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

297: jtm_message_log_pkg.Log_Msg
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;

Line 309: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

305: RETURN TRUE;
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
310: jtm_message_log_pkg.Log_Msg
311: ( p_incident_id
312: , g_table_name1
313: , 'Exception occured in INSERT_BUSS_PROCESSES_RECORD'

Line 314: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

310: jtm_message_log_pkg.Log_Msg
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;

Line 352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

348: x_msg_count NUMBER;
349: x_msg_data VARCHAR2(4000);
350: BEGIN
351:
352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
353: jtm_message_log_pkg.Log_Msg
354: ( p_incident_id
355: , g_table_name1
356: , 'Entering INSERT_CONTRACT_BUSS_PROCESSES'

Line 357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

353: jtm_message_log_pkg.Log_Msg
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

Line 397: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

393: IF l_oks_out_tbl_bp.COUNT > 0 THEN
394: /* Looping over the table if table contain any record(s) */
395: FOR i IN l_oks_out_tbl_bp.FIRST .. l_oks_out_tbl_bp.LAST LOOP
396:
397: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
398: jtm_message_log_pkg.Log_Msg
399: ( p_incident_id
400: , g_table_name1
401: , 'Processing business_process_id ' || l_oks_out_tbl_bp(i).bp_id

Line 402: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

398: jtm_message_log_pkg.Log_Msg
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

Line 437: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

433: , p_resource_id => p_resource_id
434: );
435:
436: -- Push record to the Resource (insert in ACC)
437: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
438: jtm_message_log_pkg.Log_Msg
439: ( l_oks_out_tbl_bp(i).bp_id
440: , g_table_name2
441: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 442: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

438: jtm_message_log_pkg.Log_Msg
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

Line 446: JTM_HOOK_UTIL_PKG.Insert_Acc

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
448: ,P_ACC_TABLE_NAME => g_acc_table_name2
449: ,P_RESOURCE_ID => p_resource_id
450: ,P_PK1_NAME => g_pk1_name2

Line 463: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

459:
460: END LOOP;
461: END IF;
462:
463: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
464: jtm_message_log_pkg.Log_Msg
465: ( p_incident_id
466: , g_table_name1
467: , 'Leaving INSERT_CONTRACT_BUSS_PROCESSES'

Line 468: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

464: jtm_message_log_pkg.Log_Msg
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;

Line 476: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

472: RETURN l_effected_records;
473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
477: jtm_message_log_pkg.Log_Msg
478: ( p_incident_id
479: , g_table_name1
480: , 'Exception occured in INSERT_CONTRACT_BUSS_PROCESSES'

Line 481: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

477: jtm_message_log_pkg.Log_Msg
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;

Line 499: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

495: RETURN BOOLEAN
496: IS
497: BEGIN
498:
499: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg
501: ( p_incident_id
502: , g_table_name1
503: , 'Entering INSERT_CONTRACT_HEADER_RECORD'

Line 504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

500: jtm_message_log_pkg.Log_Msg
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

Line 533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

529: , sysdate
530: , 1
531: );
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_incident_id
536: , g_table_name1
537: , 'Leaving INSERT_CONTRACT_HEADER_RECORD'

Line 538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

534: jtm_message_log_pkg.Log_Msg
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;

Line 546: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

542: RETURN TRUE;
543:
544: EXCEPTION
545: WHEN OTHERS THEN
546: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
547: jtm_message_log_pkg.Log_Msg
548: ( p_incident_id
549: , g_table_name1
550: , 'Exception occured in INSERT_CONTRACT_HEADER_RECORD'

Line 551: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

547: jtm_message_log_pkg.Log_Msg
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;

Line 611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

607: WHERE CS.incident_id = b_incident_id;
608:
609: BEGIN
610:
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( p_incident_id
614: , g_table_name1
615: , 'Entering INSERT_CONTRACT_HEADER'

Line 616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

612: jtm_message_log_pkg.Log_Msg
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);

Line 624: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

620: OPEN c_csl_contr_record(p_incident_id);
621: FETCH c_csl_contr_record INTO r_csl_contr_record;
622: IF c_csl_contr_record%NOTFOUND THEN
623:
624: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
625: jtm_message_log_pkg.Log_Msg
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'

Line 629: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

625: jtm_message_log_pkg.Log_Msg
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

Line 636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

632: jtm_message_log_pkg.Log_Msg
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);

Line 647: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

643: , l_service_name
644: , l_service_description
645: , l_amount_uom_code;
646: IF c_csl_contract_line_details%NOTFOUND THEN
647: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
648: jtm_message_log_pkg.Log_Msg
649: ( p_incident_id
650: , g_table_name1
651: , 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id

Line 652: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

648: jtm_message_log_pkg.Log_Msg
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:

Line 657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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
658: jtm_message_log_pkg.Log_Msg
659: ( p_incident_id
660: , g_table_name1
661: , 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id

Line 667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

663: || ', CONTRACT_SERVICE_ID: ' || l_contract_nuber
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 */

Line 702: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

698: , p_resource_id => p_resource_id
699: );
700:
701: -- Push record to the Resource (insert in ACC)
702: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
703: jtm_message_log_pkg.Log_Msg
704: ( p_incident_id
705: , g_table_name1
706: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

703: jtm_message_log_pkg.Log_Msg
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:

Line 715: JTM_HOOK_UTIL_PKG.Insert_Acc

711: -- Bug 3107687 fix:
712: -- check if bus process is not empty insert header info to acc table.
713: IF l > 0 THEN
714:
715: JTM_HOOK_UTIL_PKG.Insert_Acc
716: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
717: ,P_ACC_TABLE_NAME => g_acc_table_name1
718: ,P_RESOURCE_ID => p_resource_id
719: ,P_PK1_NAME => g_pk1_name1

Line 731: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

727: , P_RESOURCE_ID => p_resource_id
728: );
729:
730: IF NOT(l_return) THEN
731: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
732: jtm_message_log_pkg.Log_Msg
733: ( l_contract_service_id
734: , g_table_name1
735: , 'Inserting Contract Notes Failed for resource_id = '

Line 737: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

733: ( l_contract_service_id
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:

Line 745: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

741:
742: END IF;
743: END IF;
744:
745: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
746: jtm_message_log_pkg.Log_Msg
747: ( p_incident_id
748: , g_table_name1
749: , 'Leaving INSERT_CONTRACT_HEADER'

Line 750: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

746: jtm_message_log_pkg.Log_Msg
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;

Line 758: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

754: RETURN TRUE;
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
759: jtm_message_log_pkg.Log_Msg
760: ( p_incident_id
761: , g_table_name1
762: , 'Exception occured in INSERT_CONTRACT_HEADER'

Line 763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

759: jtm_message_log_pkg.Log_Msg
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;

Line 781: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

777: )
778: IS
779: BEGIN
780:
781: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
782: jtm_message_log_pkg.Log_Msg
783: ( p_incident_id
784: , g_table_name1
785: , 'Entering DELETE_SR_CONTRACT_ACC'

Line 786: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

782: jtm_message_log_pkg.Log_Msg
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

Line 790: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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
792: ( p_incident_id
793: , g_table_name1
794: , 'Deleting Header ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id

Line 795: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

791: jtm_message_log_pkg.Log_Msg
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:

Line 800: JTM_HOOK_UTIL_PKG.Delete_Acc

796: , 'csl_contract_handling_pkg'
797: );
798: END IF;
799:
800: JTM_HOOK_UTIL_PKG.Delete_Acc
801: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
802: ,P_ACC_TABLE_NAME => g_acc_table_name1
803: ,P_PK1_NAME => g_pk1_name1
804: ,P_PK1_NUM_VALUE => p_incident_id

Line 808: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

804: ,P_PK1_NUM_VALUE => p_incident_id
805: ,P_RESOURCE_ID => p_resource_id
806: );
807:
808: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
809: jtm_message_log_pkg.Log_Msg
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

Line 813: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

809: jtm_message_log_pkg.Log_Msg
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

Line 817: JTM_HOOK_UTIL_PKG.Delete_Acc

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
819: ,P_ACC_TABLE_NAME => g_acc_table_name2
820: ,P_PK1_NAME => g_pk1_name2
821: ,P_PK1_NUM_VALUE => p_incident_id

Line 825: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

821: ,P_PK1_NUM_VALUE => p_incident_id
822: ,P_RESOURCE_ID => p_resource_id
823: );
824:
825: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
826: jtm_message_log_pkg.Log_Msg
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

Line 830: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

826: jtm_message_log_pkg.Log_Msg
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

Line 834: JTM_HOOK_UTIL_PKG.Delete_Acc

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
836: ,P_ACC_TABLE_NAME => g_acc_table_name3
837: ,P_PK1_NAME => g_pk1_name3
838: ,P_PK1_NUM_VALUE => p_incident_id

Line 850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

846: , P_SOURCE_OBJ_CODE => 'OKS_COV_NOTE'
847: , P_RESOURCE_ID => p_resource_id
848: );
849:
850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
851: jtm_message_log_pkg.Log_Msg
852: ( p_incident_id
853: , g_table_name1
854: , 'Leaving DELETE_SR_CONTRACT_ACC'

Line 855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

851: jtm_message_log_pkg.Log_Msg
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

Line 861: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

857: END IF;
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
862: jtm_message_log_pkg.Log_Msg
863: ( p_incident_id
864: , g_table_name1
865: , 'Exception occured in DELETE_SR_CONTRACT_ACC'

Line 866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

862: jtm_message_log_pkg.Log_Msg
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:

Line 881: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

877: IS
878: l_success BOOLEAN := FALSE;
879: BEGIN
880: /*** get debug level ***/
881: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
882:
883: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
884: jtm_message_log_pkg.Log_Msg
885: ( p_incident_id

Line 883: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

879: BEGIN
880: /*** get debug level ***/
881: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
882:
883: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
884: jtm_message_log_pkg.Log_Msg
885: ( p_incident_id
886: , g_table_name1
887: , 'Entering POST_INSERT_SR_CONTRACT_ACC'

Line 888: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

884: jtm_message_log_pkg.Log_Msg
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

Line 903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

899: ELSE
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: END IF;
902:
903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_incident_id
906: , g_table_name1
907: , 'Leaving POST_INSERT_SR_CONTRACT_ACC'

Line 908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

904: jtm_message_log_pkg.Log_Msg
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;

Line 931: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

927: r_csl_contr_record c_csl_contr_record%ROWTYPE;
928:
929: BEGIN
930: /*** get debug level ***/
931: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
932:
933: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
934: jtm_message_log_pkg.Log_Msg
935: ( p_incident_id

Line 933: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

929: BEGIN
930: /*** get debug level ***/
931: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
932:
933: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
934: jtm_message_log_pkg.Log_Msg
935: ( p_incident_id
936: , g_table_name1
937: , 'Entering POST_UPDATE_SR_CONTRACT_ACC'

Line 938: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

934: jtm_message_log_pkg.Log_Msg
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? ***/

Line 976: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

972: , x_return_status => x_return_status
973: );
974: END IF;
975:
976: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
977: jtm_message_log_pkg.Log_Msg
978: ( p_incident_id
979: , g_table_name1
980: , 'Leaving POST_UPDATE_SR_CONTRACT_ACC'

Line 981: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

977: jtm_message_log_pkg.Log_Msg
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;

Line 1002: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

998: r_csl_contr_record c_csl_contr_record%ROWTYPE;
999:
1000: BEGIN
1001: /*** get debug level ***/
1002: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1003:
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( p_incident_id

Line 1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1000: BEGIN
1001: /*** get debug level ***/
1002: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1003:
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( p_incident_id
1007: , g_table_name1
1008: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'

Line 1009: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1005: jtm_message_log_pkg.Log_Msg
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);

Line 1026: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1022: );
1023:
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1027: jtm_message_log_pkg.Log_Msg
1028: ( p_incident_id
1029: , g_table_name1
1030: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'

Line 1031: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1027: jtm_message_log_pkg.Log_Msg
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;