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_LOBS_ACC_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 4: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

1: PACKAGE BODY CSL_LOBS_ACC_PKG AS
2: /* $Header: csllbacb.pls 120.0 2005/05/30 07:41:21 appldev noship $ */
3:
4: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
5: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_LOBS');
6:
7: g_debug_level NUMBER; -- debug level
8: g_table_name CONSTANT VARCHAR2(30) := 'CSL_LOBS';

Line 5: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_LOBS');

1: PACKAGE BODY CSL_LOBS_ACC_PKG AS
2: /* $Header: csllbacb.pls 120.0 2005/05/30 07:41:21 appldev noship $ */
3:
4: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
5: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_LOBS');
6:
7: g_debug_level NUMBER; -- debug level
8: g_table_name CONSTANT VARCHAR2(30) := 'CSL_LOBS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'FILE_ID';

Line 59: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

55: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
56:
57: BEGIN
58:
59: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
60:
61: l_task_assignment_id := p_task_assignment_id;
62: l_resource_id := p_resource_id;
63: l_publicationitemname := 'CSL_LOBS';

Line 103: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

99: jtm_message_log_pkg.Log_Msg (
100: p_task_assignment_id
101: , 'LOBS_ACC_PKG.INSERT_ACC'
102: , l_err_mesg
103: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
104:
105: RAISE;
106:
107: WHEN OTHERS THEN

Line 114: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

110: jtm_message_log_pkg.Log_Msg (
111: p_task_assignment_id
112: , 'LOBS_ACC_PKG.INSERT_ACC'
113: , l_err_mesg
114: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
115:
116: RAISE;
117:
118: END INSERT_ACC_RECORD;

Line 169: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

165: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
166:
167: BEGIN
168:
169: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
170:
171: l_task_assignment_id := p_task_assignment_id;
172: l_resource_id := p_resource_id;
173: l_publicationitemname := 'CSL_LOBS';

Line 211: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

207: jtm_message_log_pkg.Log_Msg (
208: p_task_assignment_id
209: , 'LOBS_ACC_PKG.INSERT_ACC'
210: , l_err_mesg
211: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
212: RAISE;
213:
214: WHEN OTHERS THEN
215: l_err_mesg := 'EXCEPTION IN CSL_LOBS_PKG.DELETE_ACC_RECORD :'

Line 221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

217: jtm_message_log_pkg.Log_Msg (
218: p_task_assignment_id
219: , 'LOBS_ACC_PKG.INSERT_ACC'
220: , l_err_mesg
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
222: RAISE;
223:
224: END DELETE_ACC_RECORD;
225:

Line 354: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

350:
351: BEGIN
352:
353: /*** get debug level ***/
354: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( 0
358: , g_table_name

Line 355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

351: BEGIN
352:
353: /*** get debug level ***/
354: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( 0
358: , g_table_name
359: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'

Line 360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

356: jtm_message_log_pkg.Log_Msg
357: ( 0
358: , g_table_name
359: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'
360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
361: );
362: END IF;
363:
364: /*** First retrieve last run date of the conccurent program ***/

Line 389: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

385: p_status := 'FINE';
386: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
387: || ' Executed successfully';
388:
389: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
390: jtm_message_log_pkg.Log_Msg
391: ( 0
392: , g_table_name
393: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'

Line 394: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

390: jtm_message_log_pkg.Log_Msg
391: ( 0
392: , g_table_name
393: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'
394: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
395: );
396: END IF;
397:
398: RETURN;

Line 406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

402: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
403: CLOSE c_SRAtt;
404:
405: IF l_tab_access_id.COUNT > 0 THEN
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
407: jtm_message_log_pkg.Log_Msg
408: ( 0
409: , g_table_name
410: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

407: jtm_message_log_pkg.Log_Msg
408: ( 0
409: , g_table_name
410: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
412: );
413: END IF;
414:
415: l_dummy := asg_download.markdirty(

Line 434: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

430: FETCH c_TaskAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
431: CLOSE c_TaskAtt;
432:
433: IF l_tab_access_id.COUNT > 0 THEN
434: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
435: jtm_message_log_pkg.Log_Msg
436: ( 0
437: , g_table_name
438: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 439: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

435: jtm_message_log_pkg.Log_Msg
436: ( 0
437: , g_table_name
438: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
439: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
440: );
441: END IF;
442:
443: l_dummy := asg_download.markdirty(

Line 462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

458: FETCH c_PartyAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
459: CLOSE c_PartyAtt;
460:
461: IF l_tab_access_id.COUNT > 0 THEN
462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( 0
465: , g_table_name
466: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 467: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

463: jtm_message_log_pkg.Log_Msg
464: ( 0
465: , g_table_name
466: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
467: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
468: );
469: END IF;
470:
471: l_dummy := asg_download.markdirty(

Line 489: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

485: FETCH c_IBItemAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
486: CLOSE c_IBItemAtt;
487:
488: IF l_tab_access_id.COUNT > 0 THEN
489: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
490: jtm_message_log_pkg.Log_Msg
491: ( 0
492: , g_table_name
493: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 494: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

490: jtm_message_log_pkg.Log_Msg
491: ( 0
492: , g_table_name
493: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
494: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
495: );
496: END IF;
497:
498: l_dummy := asg_download.markdirty(

Line 517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

513: FETCH c_DebriefAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
514: CLOSE c_DebriefAtt;
515:
516: IF l_tab_access_id.COUNT > 0 THEN
517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
518: jtm_message_log_pkg.Log_Msg
519: ( 0
520: , g_table_name
521: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 522: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

518: jtm_message_log_pkg.Log_Msg
519: ( 0
520: , g_table_name
521: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
522: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
523: );
524: END IF;
525:
526: l_dummy := asg_download.markdirty(

Line 547: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

543: p_status := 'FINE';
544: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
545: || ' Executed successfully';
546:
547: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
548: jtm_message_log_pkg.Log_Msg
549: ( 0
550: , g_table_name
551: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS'

Line 552: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

548: jtm_message_log_pkg.Log_Msg
549: ( 0
550: , g_table_name
551: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS'
552: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
553: );
554: END IF;
555:
556: EXCEPTION

Line 565: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

561: 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS: '
562: || substr(SQLERRM, 1, 2000);
563:
564:
565: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
566: jtm_message_log_pkg.Log_Msg
567: ( 0
568: , g_table_name
569: , 'CONC_DOWNLOAD_ATTACHMENTS'||fnd_global.local_chr(10)||

Line 571: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

567: ( 0
568: , g_table_name
569: , 'CONC_DOWNLOAD_ATTACHMENTS'||fnd_global.local_chr(10)||
570: 'Error: '||sqlerrm
571: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
572: END IF;
573: ROLLBACK;
574:
575: END CONC_DOWNLOAD_ATTACHMENTS;

Line 610: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

606:
607: BEGIN
608:
609: /*** get debug level ***/
610: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( 0
614: , g_table_name

Line 611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

607: BEGIN
608:
609: /*** get debug level ***/
610: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( 0
614: , g_table_name
615: , 'Entering DOWNLOAD_SR_ATTACHMENTS'

Line 616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

612: jtm_message_log_pkg.Log_Msg
613: ( 0
614: , g_table_name
615: , 'Entering DOWNLOAD_SR_ATTACHMENTS'
616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
617: );
618: END IF;
619:
620: --SR

Line 629: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

625: --If the max size of attachment is less than 1, then exit.
626: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
627: /*Update the last run date*/
628:
629: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
630: jtm_message_log_pkg.Log_Msg
631: ( 0
632: , g_table_name
633: , 'Leaving DOWNLOAD_SR_ATTACHMENTS - Max att download size is less than 1'

Line 634: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

630: jtm_message_log_pkg.Log_Msg
631: ( 0
632: , g_table_name
633: , 'Leaving DOWNLOAD_SR_ATTACHMENTS - Max att download size is less than 1'
634: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
635: );
636: END IF;
637:
638: RETURN;

Line 646: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

642: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
643: CLOSE c_SRAtt;
644:
645: IF l_tab_access_id.COUNT > 0 THEN
646: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
647: jtm_message_log_pkg.Log_Msg
648: ( 0
649: , g_table_name
650: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 651: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

647: jtm_message_log_pkg.Log_Msg
648: ( 0
649: , g_table_name
650: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
651: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
652: );
653: END IF;
654:
655: l_dummy := asg_download.markdirty(

Line 665: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

661:
662: END IF;
663:
664:
665: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
666: jtm_message_log_pkg.Log_Msg
667: ( 0
668: , g_table_name
669: , 'Leaving DOWNLOAD_SR_ATTACHMENTS'

Line 670: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

666: jtm_message_log_pkg.Log_Msg
667: ( 0
668: , g_table_name
669: , 'Leaving DOWNLOAD_SR_ATTACHMENTS'
670: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
671: );
672: END IF;
673:
674: EXCEPTION

Line 677: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

673:
674: EXCEPTION
675:
676: WHEN OTHERS THEN
677: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
678: jtm_message_log_pkg.Log_Msg
679: ( 0
680: , g_table_name
681: , 'DOWNLOAD_SR_ATTACHMENTS'||fnd_global.local_chr(10)||

Line 683: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

679: ( 0
680: , g_table_name
681: , 'DOWNLOAD_SR_ATTACHMENTS'||fnd_global.local_chr(10)||
682: 'Error: '||sqlerrm
683: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
684: END IF;
685: ROLLBACK;
686:
687: END DOWNLOAD_SR_ATTACHMENTS;

Line 723: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

719:
720: BEGIN
721:
722: /*** get debug level ***/
723: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
724: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
725: jtm_message_log_pkg.Log_Msg
726: ( 0
727: , g_table_name

Line 724: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

720: BEGIN
721:
722: /*** get debug level ***/
723: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
724: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
725: jtm_message_log_pkg.Log_Msg
726: ( 0
727: , g_table_name
728: , 'Entering DOWNLOAD_TASK_ATTACHMENTS'

Line 729: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

725: jtm_message_log_pkg.Log_Msg
726: ( 0
727: , g_table_name
728: , 'Entering DOWNLOAD_TASK_ATTACHMENTS'
729: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
730: );
731: END IF;
732:
733: --If the max size of attachment is less than 1, then exit.

Line 736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

732:
733: --If the max size of attachment is less than 1, then exit.
734: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( 0
739: , g_table_name
740: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS - Max att download size is less than 1'

Line 741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

737: jtm_message_log_pkg.Log_Msg
738: ( 0
739: , g_table_name
740: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS - Max att download size is less than 1'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
742: );
743: END IF;
744:
745: RETURN;

Line 757: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

753: FETCH c_TaskAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
754: CLOSE c_TaskAtt;
755:
756: IF l_tab_access_id.COUNT > 0 THEN
757: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
758: jtm_message_log_pkg.Log_Msg
759: ( 0
760: , g_table_name
761: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 762: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

758: jtm_message_log_pkg.Log_Msg
759: ( 0
760: , g_table_name
761: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
762: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
763: );
764: END IF;
765:
766: l_dummy := asg_download.markdirty(

Line 775: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

771: , P_TIMESTAMP => SYSDATE);
772:
773: END IF;
774:
775: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
776: jtm_message_log_pkg.Log_Msg
777: ( 0
778: , g_table_name
779: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS'

Line 780: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

776: jtm_message_log_pkg.Log_Msg
777: ( 0
778: , g_table_name
779: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS'
780: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
781: );
782: END IF;
783:
784: EXCEPTION

Line 787: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

783:
784: EXCEPTION
785:
786: WHEN OTHERS THEN
787: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
788: jtm_message_log_pkg.Log_Msg
789: ( 0
790: , g_table_name
791: , 'DOWNLOAD_TASK_ATTACHMENTS'||fnd_global.local_chr(10)||

Line 793: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

789: ( 0
790: , g_table_name
791: , 'DOWNLOAD_TASK_ATTACHMENTS'||fnd_global.local_chr(10)||
792: 'Error: '||sqlerrm
793: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
794: END IF;
795: ROLLBACK;
796:
797: END DOWNLOAD_TASK_ATTACHMENTS;

Line 855: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

851:
852: l_err_mesg VARCHAR2(1000);
853: BEGIN
854:
855: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
856:
857: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
858: jtm_message_log_pkg.Log_Msg
859: ( p_primary_key

Line 857: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

853: BEGIN
854:
855: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
856:
857: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
858: jtm_message_log_pkg.Log_Msg
859: ( p_primary_key
860: , g_table_name
861: , 'Entering Delete_Attachments'

Line 862: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

858: jtm_message_log_pkg.Log_Msg
859: ( p_primary_key
860: , g_table_name
861: , 'Entering Delete_Attachments'
862: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
863: END IF;
864:
865: IF (p_entity_name = 'CS_INCIDENTS') THEN
866:

Line 867: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

863: END IF;
864:
865: IF (p_entity_name = 'CS_INCIDENTS') THEN
866:
867: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
868: jtm_message_log_pkg.Log_Msg
869: ( p_primary_key
870: , g_table_name
871: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id

Line 872: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

868: jtm_message_log_pkg.Log_Msg
869: ( p_primary_key
870: , g_table_name
871: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
872: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
873: END IF;
874:
875: OPEN c_SRAtt(p_primary_key, p_resource_id);
876: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;

Line 880: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

876: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
877: CLOSE c_SRAtt;
878:
879: IF l_tab_access_id.COUNT > 0 THEN
880: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
881: jtm_message_log_pkg.Log_Msg
882: ( 0
883: , g_table_name
884: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 885: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

881: jtm_message_log_pkg.Log_Msg
882: ( 0
883: , g_table_name
884: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
885: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
886: );
887: END IF;
888:
889: l_dummy := asg_download.markdirty(

Line 903: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

899:
900:
901: IF (p_entity_name = 'JTF_TASKS_B') THEN
902:
903: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_primary_key
906: , g_table_name
907: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id

Line 908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

904: jtm_message_log_pkg.Log_Msg
905: ( p_primary_key
906: , g_table_name
907: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
909: END IF;
910:
911: OPEN c_TaskAtt(p_primary_key, p_resource_id);
912: FETCH c_TaskAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;

Line 916: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

912: FETCH c_TaskAtt BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
913: CLOSE c_TaskAtt;
914:
915: IF l_tab_access_id.COUNT > 0 THEN
916: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
917: jtm_message_log_pkg.Log_Msg
918: ( 0
919: , g_table_name
920: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 921: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

917: jtm_message_log_pkg.Log_Msg
918: ( 0
919: , g_table_name
920: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
921: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
922: );
923: END IF;
924:
925: l_dummy := asg_download.markdirty(

Line 935: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

931:
932: END IF;
933: END IF; --IF (p_entity_name = 'JTF_TASKS_B') THEN
934:
935: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
936: jtm_message_log_pkg.Log_Msg
937: ( p_primary_key
938: , g_table_name
939: , 'Exiting Delete_Attachments'

Line 940: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

936: jtm_message_log_pkg.Log_Msg
937: ( p_primary_key
938: , g_table_name
939: , 'Exiting Delete_Attachments'
940: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
941: END IF;
942:
943: EXCEPTION
944:

Line 952: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

948: jtm_message_log_pkg.Log_Msg (
949: p_primary_key
950: , 'LOBS_ACC_PKG.DELETE_ATTACHMENTS'
951: , l_err_mesg
952: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
953: RAISE;
954:
955: END DELETE_ATTACHMENTS;
956: