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

Line 157: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

153: BEGIN
154: -- data program is run
155: l_run_date := SYSDATE;
156: /*** get debug level ***/
157: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
158: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
159: jtm_message_log_pkg.Log_Msg
160: ( 0
161: , g_table_name

Line 158: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

154: -- data program is run
155: l_run_date := SYSDATE;
156: /*** get debug level ***/
157: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
158: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
159: jtm_message_log_pkg.Log_Msg
160: ( 0
161: , g_table_name
162: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'

Line 163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

159: jtm_message_log_pkg.Log_Msg
160: ( 0
161: , g_table_name
162: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'
163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
164: );
165: END IF;
166:
167: --Emptying all lists.

Line 199: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

195: p_status := 'FINE';
196: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
197: || ' Executed successfully';
198:
199: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
200: jtm_message_log_pkg.Log_Msg
201: ( 0
202: , g_table_name
203: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'

Line 204: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

200: jtm_message_log_pkg.Log_Msg
201: ( 0
202: , g_table_name
203: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'
204: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
205: );
206: END IF;
207: RETURN;
208: END IF;

Line 211: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

207: RETURN;
208: END IF;
209:
210:
211: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
212: jtm_message_log_pkg.Log_Msg
213: ( 0
214: , g_table_name
215: , 'Downloading Attachments for SRs'

Line 216: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

212: jtm_message_log_pkg.Log_Msg
213: ( 0
214: , g_table_name
215: , 'Downloading Attachments for SRs'
216: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
217: );
218: END IF;
219:
220: --- DOWNLOAD SR ATTACHMENTS

Line 229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

225: l_tab_datatype_id,l_tab_document_id,l_tab_title;
226: CLOSE l_SRAtt_csr;
227:
228: IF l_tab_access_id.COUNT > 0 THEN
229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
230: jtm_message_log_pkg.Log_Msg
231: ( 0
232: , g_table_name
233: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

230: jtm_message_log_pkg.Log_Msg
231: ( 0
232: , g_table_name
233: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
235: );
236: END IF;
237:
238: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 291: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

287: l_tab_datatype_id,l_tab_document_id,l_tab_title;
288: CLOSE l_TaskAtt_csr;
289:
290: IF l_tab_access_id.COUNT > 0 THEN
291: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
292: jtm_message_log_pkg.Log_Msg
293: ( 0
294: , g_table_name
295: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 296: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

292: jtm_message_log_pkg.Log_Msg
293: ( 0
294: , g_table_name
295: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
296: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
297: );
298: END IF;
299: --insert the rows into access table
300: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

350: l_tab_datatype_id,l_tab_document_id,l_tab_title;
351: CLOSE c_Signature;
352:
353: IF l_tab_access_id.COUNT > 0 THEN
354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
355: jtm_message_log_pkg.Log_Msg
356: ( 0
357: , g_table_name
358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

355: jtm_message_log_pkg.Log_Msg
356: ( 0
357: , g_table_name
358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
360: );
361: END IF;
362: --insert the rows into access table
363: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 527: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

523: x_return_status varchar2(2000);
524: BEGIN
525:
526: /*** get debug level ***/
527: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
528: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
529: jtm_message_log_pkg.Log_Msg
530: ( 0
531: , g_table_name

Line 528: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

524: BEGIN
525:
526: /*** get debug level ***/
527: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
528: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
529: jtm_message_log_pkg.Log_Msg
530: ( 0
531: , g_table_name
532: , 'Entering INSERT_ALL_ACC_RECORDS'

Line 533: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

529: jtm_message_log_pkg.Log_Msg
530: ( 0
531: , g_table_name
532: , 'Entering INSERT_ALL_ACC_RECORDS'
533: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
534: );
535: END IF;
536: --Empty the access table for the user before insert it freshly
537: --bug 5213097

Line 567: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

563: l_tab_datatype_id,l_tab_document_id,l_tab_title;
564: CLOSE c_Signature;
565:
566: IF l_tab_access_id.COUNT > 0 THEN
567: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
568: jtm_message_log_pkg.Log_Msg
569: ( 0
570: , g_table_name
571: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 572: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

568: jtm_message_log_pkg.Log_Msg
569: ( 0
570: , g_table_name
571: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
572: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
573: );
574: END IF;
575:
576: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 620: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

616: l_tab_title.delete;
617:
618: --If the max size of attachment is less than 1, then exit.
619: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
620: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
621: jtm_message_log_pkg.Log_Msg
622: ( 0
623: , g_table_name
624: , 'Leaving INSERT_ALL_ACC_RECORDS - Max att download size is less than 1'

Line 625: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

621: jtm_message_log_pkg.Log_Msg
622: ( 0
623: , g_table_name
624: , 'Leaving INSERT_ALL_ACC_RECORDS - Max att download size is less than 1'
625: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
626: );
627: END IF;
628:
629: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 633: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630: RETURN;
631: END IF;
632:
633: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
634: jtm_message_log_pkg.Log_Msg
635: ( 0
636: , g_table_name
637: , 'Downloading Attachments for SRs'

Line 638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

634: jtm_message_log_pkg.Log_Msg
635: ( 0
636: , g_table_name
637: , 'Downloading Attachments for SRs'
638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
639: );
640: END IF;
641:
642: OPEN c_SRAtt(p_user_id);

Line 650: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

646: l_tab_datatype_id,l_tab_document_id,l_tab_title;
647: CLOSE c_SRAtt;
648:
649: IF l_tab_access_id.COUNT > 0 THEN
650: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
651: jtm_message_log_pkg.Log_Msg
652: ( 0
653: , g_table_name
654: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 655: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

651: jtm_message_log_pkg.Log_Msg
652: ( 0
653: , g_table_name
654: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
655: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
656: );
657: END IF;
658:
659: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 682: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

678: , P_TIMESTAMP => SYSDATE);
679:
680: END IF;
681:
682: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
683: jtm_message_log_pkg.Log_Msg
684: ( 0
685: , g_table_name
686: , 'Downloading Attachments for Tasks'

Line 687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

683: jtm_message_log_pkg.Log_Msg
684: ( 0
685: , g_table_name
686: , 'Downloading Attachments for Tasks'
687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
688: );
689: END IF;
690:
691: --TASK

Line 718: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

714: l_tab_datatype_id,l_tab_document_id,l_tab_title;
715: CLOSE c_TaskAtt;
716:
717: IF l_tab_access_id.COUNT > 0 THEN
718: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
719: jtm_message_log_pkg.Log_Msg
720: ( 0
721: , g_table_name
722: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

719: jtm_message_log_pkg.Log_Msg
720: ( 0
721: , g_table_name
722: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
724: );
725: END IF;
726:
727: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 751: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

747:
748: END IF;
749:
750:
751: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
752: jtm_message_log_pkg.Log_Msg
753: ( 0
754: , g_table_name
755: , 'Downloading Signatures'

Line 756: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

752: jtm_message_log_pkg.Log_Msg
753: ( 0
754: , g_table_name
755: , 'Downloading Signatures'
756: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
757: );
758: END IF;
759:
760:

Line 763: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

759:
760:
761: x_return_status := FND_API.G_RET_STS_SUCCESS;
762:
763: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
764: jtm_message_log_pkg.Log_Msg
765: ( 0
766: , g_table_name
767: , 'Leaving INSERT_ALL_ACC_RECORDS'

Line 768: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

764: jtm_message_log_pkg.Log_Msg
765: ( 0
766: , g_table_name
767: , 'Leaving INSERT_ALL_ACC_RECORDS'
768: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
769: );
770: END IF;
771:
772: EXCEPTION

Line 776: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

772: EXCEPTION
773:
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
777: jtm_message_log_pkg.Log_Msg
778: ( 0
779: , g_table_name
780: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||

Line 782: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

778: ( 0
779: , g_table_name
780: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
781: 'Error: '||sqlerrm
782: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
783: END IF;
784: RAISE;
785: END INSERT_ALL_ACC_RECORDS;
786:

Line 951: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

947:
948:
949: ---DOWNLOAD SR AND TASK Attachments
950: /*** get debug level ***/
951: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
952: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
953: jtm_message_log_pkg.Log_Msg
954: ( 0
955: , g_table_name

Line 952: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

948:
949: ---DOWNLOAD SR AND TASK Attachments
950: /*** get debug level ***/
951: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
952: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
953: jtm_message_log_pkg.Log_Msg
954: ( 0
955: , g_table_name
956: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'

Line 957: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

953: jtm_message_log_pkg.Log_Msg
954: ( 0
955: , g_table_name
956: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'
957: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
958: );
959: END IF;
960:
961: --Emptying all lists.

Line 989: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

985: l_tab_datatype_id,l_tab_document_id,l_tab_title;
986: CLOSE l_signature_csr;
987:
988: IF l_tab_access_id.COUNT > 0 THEN
989: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
990: jtm_message_log_pkg.Log_Msg
991: ( 0
992: , g_table_name
993: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 994: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

990: jtm_message_log_pkg.Log_Msg
991: ( 0
992: , g_table_name
993: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
994: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
995: );
996: END IF;
997:
998: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1025: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1021:
1022: --If the max size of attachment is less than 1, then exit.(this should be done only
1023: --for SR and TASK attachments)
1024: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1025: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1026: jtm_message_log_pkg.Log_Msg
1027: ( 0
1028: , g_table_name
1029: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'

Line 1030: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1026: jtm_message_log_pkg.Log_Msg
1027: ( 0
1028: , g_table_name
1029: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'
1030: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1031: );
1032: END IF;
1033: RETURN;
1034: END IF;

Line 1037: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1033: RETURN;
1034: END IF;
1035:
1036:
1037: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1038: jtm_message_log_pkg.Log_Msg
1039: ( 0
1040: , g_table_name
1041: , 'Downloading Attachments for SRs'

Line 1042: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1038: jtm_message_log_pkg.Log_Msg
1039: ( 0
1040: , g_table_name
1041: , 'Downloading Attachments for SRs'
1042: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1043: );
1044: END IF;
1045:
1046: --Emptying all lists.

Line 1074: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1070: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1071: CLOSE l_SRAtt_csr;
1072:
1073: IF l_tab_access_id.COUNT > 0 THEN
1074: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1075: jtm_message_log_pkg.Log_Msg
1076: ( 0
1077: , g_table_name
1078: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1079: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1075: jtm_message_log_pkg.Log_Msg
1076: ( 0
1077: , g_table_name
1078: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1079: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1080: );
1081: END IF;
1082:
1083: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1136: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1132: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1133: CLOSE l_TaskAtt_csr;
1134:
1135: IF l_tab_access_id.COUNT > 0 THEN
1136: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1137: jtm_message_log_pkg.Log_Msg
1138: ( 0
1139: , g_table_name
1140: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1141: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1137: jtm_message_log_pkg.Log_Msg
1138: ( 0
1139: , g_table_name
1140: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1141: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1142: );
1143: END IF;
1144:
1145: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1244: l_userid NUMBER;
1245:
1246: BEGIN
1247:
1248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1249:
1250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1251: jtm_message_log_pkg.Log_Msg
1252: ( p_task_assignment_id

Line 1250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1246: BEGIN
1247:
1248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1249:
1250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1251: jtm_message_log_pkg.Log_Msg
1252: ( p_task_assignment_id
1253: , g_table_name
1254: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

Line 1255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1251: jtm_message_log_pkg.Log_Msg
1252: ( p_task_assignment_id
1253: , g_table_name
1254: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1256: END IF;
1257:
1258: --cursor to get language
1259: OPEN l_userid_csr (p_resource_id);

Line 1265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1261: CLOSE l_userid_csr;
1262:
1263: --Deleting Signature attachments
1264:
1265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1266: jtm_message_log_pkg.Log_Msg
1267: ( p_task_assignment_id
1268: , g_table_name
1269: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id

Line 1270: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1266: jtm_message_log_pkg.Log_Msg
1267: ( p_task_assignment_id
1268: , g_table_name
1269: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1270: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1271: END IF;
1272:
1273: OPEN l_signature_csr(p_task_assignment_id, l_userid);
1274: FETCH l_signature_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1278: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1274: FETCH l_signature_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1275: CLOSE l_signature_csr;
1276:
1277: IF l_tab_access_id.COUNT > 0 THEN
1278: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1279: jtm_message_log_pkg.Log_Msg
1280: ( 0
1281: , g_table_name
1282: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1283: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1279: jtm_message_log_pkg.Log_Msg
1280: ( 0
1281: , g_table_name
1282: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1283: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1284: );
1285: END IF;
1286:
1287: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1302: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1298:
1299: END IF;
1300:
1301: --SR attachment deletion
1302: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1303: jtm_message_log_pkg.Log_Msg
1304: ( p_task_assignment_id
1305: , g_table_name
1306: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id

Line 1307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1303: jtm_message_log_pkg.Log_Msg
1304: ( p_task_assignment_id
1305: , g_table_name
1306: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1308: END IF;
1309:
1310: OPEN c_SRAtt(p_task_assignment_id, l_userid);
1311: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1311: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1312: CLOSE c_SRAtt;
1313:
1314: IF l_tab_access_id.COUNT > 0 THEN
1315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1316: jtm_message_log_pkg.Log_Msg
1317: ( 0
1318: , g_table_name
1319: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1316: jtm_message_log_pkg.Log_Msg
1317: ( 0
1318: , g_table_name
1319: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1321: );
1322: END IF;
1323:
1324: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1341: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1337:
1338: ----------------------------------
1339: --Deletion for Tasks
1340: -----------------------------------
1341: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1342: jtm_message_log_pkg.Log_Msg
1343: ( p_task_assignment_id
1344: , g_table_name
1345: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id

Line 1346: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1342: jtm_message_log_pkg.Log_Msg
1343: ( p_task_assignment_id
1344: , g_table_name
1345: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
1346: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1347: END IF;
1348:
1349: OPEN l_TaskAtt_csr(p_task_assignment_id, l_userid);
1350: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1350: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1351: CLOSE l_TaskAtt_csr;
1352:
1353: IF l_tab_access_id.COUNT > 0 THEN
1354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1355: jtm_message_log_pkg.Log_Msg
1356: ( 0
1357: , g_table_name
1358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1355: jtm_message_log_pkg.Log_Msg
1356: ( 0
1357: , g_table_name
1358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1360: );
1361: END IF;
1362:
1363: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1377: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1373: COMMIT;
1374:
1375: END IF;
1376:
1377: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1378: jtm_message_log_pkg.Log_Msg
1379: ( p_task_assignment_id
1380: , g_table_name
1381: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

Line 1382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1378: jtm_message_log_pkg.Log_Msg
1379: ( p_task_assignment_id
1380: , g_table_name
1381: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1383: END IF;
1384:
1385: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1386: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 1551: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1547: l_publicationitemname := 'CSF_M_LOBS';
1548:
1549: ---DOWNLOAD SR AND TASK Attachments
1550: /*** get debug level ***/
1551: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1552: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1553: jtm_message_log_pkg.Log_Msg
1554: ( 0
1555: , g_table_name

Line 1552: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1548:
1549: ---DOWNLOAD SR AND TASK Attachments
1550: /*** get debug level ***/
1551: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1552: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1553: jtm_message_log_pkg.Log_Msg
1554: ( 0
1555: , g_table_name
1556: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'

Line 1557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1553: jtm_message_log_pkg.Log_Msg
1554: ( 0
1555: , g_table_name
1556: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'
1557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1558: );
1559: END IF;
1560: --If the max size of attachment is less than 1, then exit.(this should be done only
1561: --for SR and TASK attachments)

Line 1563: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1559: END IF;
1560: --If the max size of attachment is less than 1, then exit.(this should be done only
1561: --for SR and TASK attachments)
1562: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1563: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1564: jtm_message_log_pkg.Log_Msg
1565: ( 0
1566: , g_table_name
1567: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'

Line 1568: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1564: jtm_message_log_pkg.Log_Msg
1565: ( 0
1566: , g_table_name
1567: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'
1568: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1569: );
1570: END IF;
1571: RETURN;
1572: END IF;

Line 1593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1589: l_tab_datatype_id.delete;
1590: l_tab_document_id.delete;
1591: l_tab_title.delete;
1592:
1593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1594: jtm_message_log_pkg.Log_Msg
1595: ( 0
1596: , g_table_name
1597: , 'Downloading Attachments for SRs'

Line 1598: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1594: jtm_message_log_pkg.Log_Msg
1595: ( 0
1596: , g_table_name
1597: , 'Downloading Attachments for SRs'
1598: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1599: );
1600: END IF;
1601:
1602: IF p_entity_name = 'CS_INCIDENTS' THEN

Line 1637: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1633: END IF;
1634:
1635: IF l_tab_access_id.COUNT > 0 THEN
1636:
1637: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1638: jtm_message_log_pkg.Log_Msg
1639: ( 0
1640: , g_table_name
1641: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1642: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1638: jtm_message_log_pkg.Log_Msg
1639: ( 0
1640: , g_table_name
1641: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1642: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1643: );
1644: END IF;
1645:
1646: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST