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 174: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

170:
171: -- data program is run
172: l_run_date := SYSDATE;
173: /*** get debug level ***/
174: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
175: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
176: jtm_message_log_pkg.Log_Msg
177: ( 0
178: , g_table_name

Line 175: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

171: -- data program is run
172: l_run_date := SYSDATE;
173: /*** get debug level ***/
174: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
175: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
176: jtm_message_log_pkg.Log_Msg
177: ( 0
178: , g_table_name
179: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'

Line 180: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

176: jtm_message_log_pkg.Log_Msg
177: ( 0
178: , g_table_name
179: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'
180: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
181: );
182: END IF;
183:
184: --Emptying all lists.

Line 216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

212: p_status := 'FINE';
213: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
214: || ' Executed successfully';
215:
216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
217: jtm_message_log_pkg.Log_Msg
218: ( 0
219: , g_table_name
220: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'

Line 221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

217: jtm_message_log_pkg.Log_Msg
218: ( 0
219: , g_table_name
220: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
222: );
223: END IF;
224: RETURN;
225: END IF;

Line 228: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

224: RETURN;
225: END IF;
226:
227:
228: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
229: jtm_message_log_pkg.Log_Msg
230: ( 0
231: , g_table_name
232: , 'Downloading Attachments for SRs'

Line 233: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

229: jtm_message_log_pkg.Log_Msg
230: ( 0
231: , g_table_name
232: , 'Downloading Attachments for SRs'
233: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
234: );
235: END IF;
236:
237: --- DOWNLOAD SR ATTACHMENTS

Line 246: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

242: l_tab_datatype_id,l_tab_document_id,l_tab_title;
243: CLOSE l_SRAtt_csr;
244:
245: IF l_tab_access_id.COUNT > 0 THEN
246: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
247: jtm_message_log_pkg.Log_Msg
248: ( 0
249: , g_table_name
250: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 251: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

247: jtm_message_log_pkg.Log_Msg
248: ( 0
249: , g_table_name
250: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
251: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
252: );
253: END IF;
254:
255: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 325: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

321: l_tab_datatype_id,l_tab_document_id,l_tab_title;
322: CLOSE l_TaskAtt_csr;
323:
324: IF l_tab_access_id.COUNT > 0 THEN
325: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
326: jtm_message_log_pkg.Log_Msg
327: ( 0
328: , g_table_name
329: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 330: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

326: jtm_message_log_pkg.Log_Msg
327: ( 0
328: , g_table_name
329: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
330: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
331: );
332: END IF;
333: --insert the rows into access table
334: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 405: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

401: l_tab_datatype_id,l_tab_document_id,l_tab_title;
402: CLOSE c_Signature;
403:
404: IF l_tab_access_id.COUNT > 0 THEN
405: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
406: jtm_message_log_pkg.Log_Msg
407: ( 0
408: , g_table_name
409: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 410: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

406: jtm_message_log_pkg.Log_Msg
407: ( 0
408: , g_table_name
409: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
410: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
411: );
412: END IF;
413: --insert the rows into access table
414: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 592: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

588: x_return_status varchar2(2000);
589: BEGIN
590:
591: /*** get debug level ***/
592: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
594: jtm_message_log_pkg.Log_Msg
595: ( 0
596: , g_table_name

Line 593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

589: BEGIN
590:
591: /*** get debug level ***/
592: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
594: jtm_message_log_pkg.Log_Msg
595: ( 0
596: , g_table_name
597: , 'Entering INSERT_ALL_ACC_RECORDS'

Line 598: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

594: jtm_message_log_pkg.Log_Msg
595: ( 0
596: , g_table_name
597: , 'Entering INSERT_ALL_ACC_RECORDS'
598: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
599: );
600: END IF;
601: --Empty the access table for the user before insert it freshly
602: --bug 5213097

Line 632: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

628: l_tab_datatype_id,l_tab_document_id,l_tab_title;
629: CLOSE c_Signature;
630:
631: IF l_tab_access_id.COUNT > 0 THEN
632: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
633: jtm_message_log_pkg.Log_Msg
634: ( 0
635: , g_table_name
636: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 637: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

633: jtm_message_log_pkg.Log_Msg
634: ( 0
635: , g_table_name
636: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
637: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
638: );
639: END IF;
640:
641: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 685: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

681: l_tab_title.delete;
682:
683: --If the max size of attachment is less than 1, then exit.
684: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
685: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
686: jtm_message_log_pkg.Log_Msg
687: ( 0
688: , g_table_name
689: , 'Leaving INSERT_ALL_ACC_RECORDS - Max att download size is less than 1'

Line 690: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

686: jtm_message_log_pkg.Log_Msg
687: ( 0
688: , g_table_name
689: , 'Leaving INSERT_ALL_ACC_RECORDS - Max att download size is less than 1'
690: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
691: );
692: END IF;
693:
694: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 698: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

694: x_return_status := FND_API.G_RET_STS_SUCCESS;
695: RETURN;
696: END IF;
697:
698: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
699: jtm_message_log_pkg.Log_Msg
700: ( 0
701: , g_table_name
702: , 'Downloading Attachments for SRs'

Line 703: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

699: jtm_message_log_pkg.Log_Msg
700: ( 0
701: , g_table_name
702: , 'Downloading Attachments for SRs'
703: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
704: );
705: END IF;
706:
707: OPEN c_SRAtt(p_user_id);

Line 715: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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

Line 720: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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

Line 747: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

743: , P_TIMESTAMP => SYSDATE);
744:
745: END IF;
746:
747: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
748: jtm_message_log_pkg.Log_Msg
749: ( 0
750: , g_table_name
751: , 'Downloading Attachments for Tasks'

Line 752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

748: jtm_message_log_pkg.Log_Msg
749: ( 0
750: , g_table_name
751: , 'Downloading Attachments for Tasks'
752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
753: );
754: END IF;
755:
756: --TASK

Line 783: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

779: l_tab_datatype_id,l_tab_document_id,l_tab_title;
780: CLOSE c_TaskAtt;
781:
782: IF l_tab_access_id.COUNT > 0 THEN
783: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
784: jtm_message_log_pkg.Log_Msg
785: ( 0
786: , g_table_name
787: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 788: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

784: jtm_message_log_pkg.Log_Msg
785: ( 0
786: , g_table_name
787: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
788: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
789: );
790: END IF;
791:
792: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 816: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

812:
813: END IF;
814:
815:
816: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
817: jtm_message_log_pkg.Log_Msg
818: ( 0
819: , g_table_name
820: , 'Downloading Signatures'

Line 821: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

817: jtm_message_log_pkg.Log_Msg
818: ( 0
819: , g_table_name
820: , 'Downloading Signatures'
821: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
822: );
823: END IF;
824:
825:

Line 828: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

824:
825:
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
829: jtm_message_log_pkg.Log_Msg
830: ( 0
831: , g_table_name
832: , 'Leaving INSERT_ALL_ACC_RECORDS'

Line 833: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

829: jtm_message_log_pkg.Log_Msg
830: ( 0
831: , g_table_name
832: , 'Leaving INSERT_ALL_ACC_RECORDS'
833: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
834: );
835: END IF;
836:
837: EXCEPTION

Line 841: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

837: EXCEPTION
838:
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
842: jtm_message_log_pkg.Log_Msg
843: ( 0
844: , g_table_name
845: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||

Line 847: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

843: ( 0
844: , g_table_name
845: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
846: 'Error: '||sqlerrm
847: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
848: END IF;
849: RAISE;
850: END INSERT_ALL_ACC_RECORDS;
851:

Line 1016: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1012:
1013:
1014: ---DOWNLOAD SR AND TASK Attachments
1015: /*** get debug level ***/
1016: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1017: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1018: jtm_message_log_pkg.Log_Msg
1019: ( 0
1020: , g_table_name

Line 1017: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1013:
1014: ---DOWNLOAD SR AND TASK Attachments
1015: /*** get debug level ***/
1016: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1017: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1018: jtm_message_log_pkg.Log_Msg
1019: ( 0
1020: , g_table_name
1021: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'

Line 1022: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1018: jtm_message_log_pkg.Log_Msg
1019: ( 0
1020: , g_table_name
1021: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'
1022: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1023: );
1024: END IF;
1025:
1026: --Emptying all lists.

Line 1054: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1050: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1051: CLOSE l_signature_csr;
1052:
1053: IF l_tab_access_id.COUNT > 0 THEN
1054: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1055: jtm_message_log_pkg.Log_Msg
1056: ( 0
1057: , g_table_name
1058: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1059: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1055: jtm_message_log_pkg.Log_Msg
1056: ( 0
1057: , g_table_name
1058: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1059: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1060: );
1061: END IF;
1062:
1063: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1090: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1086:
1087: --If the max size of attachment is less than 1, then exit.(this should be done only
1088: --for SR and TASK attachments)
1089: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1090: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1091: jtm_message_log_pkg.Log_Msg
1092: ( 0
1093: , g_table_name
1094: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'

Line 1095: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1091: jtm_message_log_pkg.Log_Msg
1092: ( 0
1093: , g_table_name
1094: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'
1095: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1096: );
1097: END IF;
1098: RETURN;
1099: END IF;

Line 1102: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1098: RETURN;
1099: END IF;
1100:
1101:
1102: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1103: jtm_message_log_pkg.Log_Msg
1104: ( 0
1105: , g_table_name
1106: , 'Downloading Attachments for SRs'

Line 1107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1103: jtm_message_log_pkg.Log_Msg
1104: ( 0
1105: , g_table_name
1106: , 'Downloading Attachments for SRs'
1107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1108: );
1109: END IF;
1110:
1111: --Emptying all lists.

Line 1139: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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

Line 1144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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

Line 1201: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1197: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1198: CLOSE l_TaskAtt_csr;
1199:
1200: IF l_tab_access_id.COUNT > 0 THEN
1201: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1202: jtm_message_log_pkg.Log_Msg
1203: ( 0
1204: , g_table_name
1205: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1206: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1202: jtm_message_log_pkg.Log_Msg
1203: ( 0
1204: , g_table_name
1205: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1206: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1207: );
1208: END IF;
1209:
1210: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1313: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1309: l_userid NUMBER;
1310:
1311: BEGIN
1312:
1313: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1314:
1315: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1316: jtm_message_log_pkg.Log_Msg
1317: ( p_task_assignment_id

Line 1315: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1311: BEGIN
1312:
1313: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1314:
1315: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1316: jtm_message_log_pkg.Log_Msg
1317: ( p_task_assignment_id
1318: , g_table_name
1319: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

Line 1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1316: jtm_message_log_pkg.Log_Msg
1317: ( p_task_assignment_id
1318: , g_table_name
1319: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1321: END IF;
1322:
1323: --cursor to get language
1324: OPEN l_userid_csr (p_resource_id);

Line 1330: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1326: CLOSE l_userid_csr;
1327:
1328: --Deleting Signature attachments
1329:
1330: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1331: jtm_message_log_pkg.Log_Msg
1332: ( p_task_assignment_id
1333: , g_table_name
1334: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id

Line 1335: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1331: jtm_message_log_pkg.Log_Msg
1332: ( p_task_assignment_id
1333: , g_table_name
1334: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1335: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1336: END IF;
1337:
1338: OPEN l_signature_csr(p_task_assignment_id, l_userid);
1339: FETCH l_signature_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1343: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1339: FETCH l_signature_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1340: CLOSE l_signature_csr;
1341:
1342: IF l_tab_access_id.COUNT > 0 THEN
1343: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1344: jtm_message_log_pkg.Log_Msg
1345: ( 0
1346: , g_table_name
1347: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1348: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1344: jtm_message_log_pkg.Log_Msg
1345: ( 0
1346: , g_table_name
1347: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1348: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1349: );
1350: END IF;
1351:
1352: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1367: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1363:
1364: END IF;
1365:
1366: --SR attachment deletion
1367: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1368: jtm_message_log_pkg.Log_Msg
1369: ( p_task_assignment_id
1370: , g_table_name
1371: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id

Line 1372: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1368: jtm_message_log_pkg.Log_Msg
1369: ( p_task_assignment_id
1370: , g_table_name
1371: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1372: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1373: END IF;
1374:
1375: OPEN c_SRAtt(p_task_assignment_id, l_userid);
1376: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1380: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1376: FETCH c_SRAtt BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1377: CLOSE c_SRAtt;
1378:
1379: IF l_tab_access_id.COUNT > 0 THEN
1380: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1381: jtm_message_log_pkg.Log_Msg
1382: ( 0
1383: , g_table_name
1384: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1385: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1381: jtm_message_log_pkg.Log_Msg
1382: ( 0
1383: , g_table_name
1384: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1385: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1386: );
1387: END IF;
1388:
1389: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1402:
1403: ----------------------------------
1404: --Deletion for Tasks
1405: -----------------------------------
1406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1407: jtm_message_log_pkg.Log_Msg
1408: ( p_task_assignment_id
1409: , g_table_name
1410: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id

Line 1411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1407: jtm_message_log_pkg.Log_Msg
1408: ( p_task_assignment_id
1409: , g_table_name
1410: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
1411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1412: END IF;
1413:
1414: OPEN l_TaskAtt_csr(p_task_assignment_id, l_userid);
1415: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;

Line 1419: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1415: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_user_id;
1416: CLOSE l_TaskAtt_csr;
1417:
1418: IF l_tab_access_id.COUNT > 0 THEN
1419: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1420: jtm_message_log_pkg.Log_Msg
1421: ( 0
1422: , g_table_name
1423: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1424: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1420: jtm_message_log_pkg.Log_Msg
1421: ( 0
1422: , g_table_name
1423: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1424: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1425: );
1426: END IF;
1427:
1428: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST

Line 1442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1438: COMMIT;
1439:
1440: END IF;
1441:
1442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1443: jtm_message_log_pkg.Log_Msg
1444: ( p_task_assignment_id
1445: , g_table_name
1446: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

Line 1447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1443: jtm_message_log_pkg.Log_Msg
1444: ( p_task_assignment_id
1445: , g_table_name
1446: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1448: END IF;
1449:
1450: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1451: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 1616: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1612: l_publicationitemname := 'CSF_M_LOBS';
1613:
1614: ---DOWNLOAD SR AND TASK Attachments
1615: /*** get debug level ***/
1616: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1618: jtm_message_log_pkg.Log_Msg
1619: ( 0
1620: , g_table_name

Line 1617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1613:
1614: ---DOWNLOAD SR AND TASK Attachments
1615: /*** get debug level ***/
1616: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1618: jtm_message_log_pkg.Log_Msg
1619: ( 0
1620: , g_table_name
1621: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'

Line 1622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1618: jtm_message_log_pkg.Log_Msg
1619: ( 0
1620: , g_table_name
1621: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'
1622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1623: );
1624: END IF;
1625: --If the max size of attachment is less than 1, then exit.(this should be done only
1626: --for SR and TASK attachments)

Line 1628: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1624: END IF;
1625: --If the max size of attachment is less than 1, then exit.(this should be done only
1626: --for SR and TASK attachments)
1627: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1628: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1629: jtm_message_log_pkg.Log_Msg
1630: ( 0
1631: , g_table_name
1632: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'

Line 1633: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1629: jtm_message_log_pkg.Log_Msg
1630: ( 0
1631: , g_table_name
1632: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'
1633: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1634: );
1635: END IF;
1636: RETURN;
1637: END IF;

Line 1658: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1654: l_tab_datatype_id.delete;
1655: l_tab_document_id.delete;
1656: l_tab_title.delete;
1657:
1658: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1659: jtm_message_log_pkg.Log_Msg
1660: ( 0
1661: , g_table_name
1662: , 'Downloading Attachments for SRs'

Line 1663: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1659: jtm_message_log_pkg.Log_Msg
1660: ( 0
1661: , g_table_name
1662: , 'Downloading Attachments for SRs'
1663: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1664: );
1665: END IF;
1666:
1667: IF p_entity_name = 'CS_INCIDENTS' THEN

Line 1702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1698: END IF;
1699:
1700: IF l_tab_access_id.COUNT > 0 THEN
1701:
1702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1703: jtm_message_log_pkg.Log_Msg
1704: ( 0
1705: , g_table_name
1706: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1703: jtm_message_log_pkg.Log_Msg
1704: ( 0
1705: , g_table_name
1706: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1708: );
1709: END IF;
1710:
1711: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST