APPS.CSL_JTF_TASK_REFS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 60: jtm_message_log_pkg.Log_Msg

56: BEGIN
57: /*** get debug level ***/
58: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
59: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
60: jtm_message_log_pkg.Log_Msg
61: ( 0
62: , g_table_name
63: , 'Entering CON_REQUEST_TASK_REFERENCES'
64: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 74: jtm_message_log_pkg.Log_Msg

70: FETCH c_LastRundate INTO r_LastRundate;
71: IF c_LastRundate%NOTFOUND THEN
72: /*ERROR package is not seeded*/
73: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
74: jtm_message_log_pkg.Log_Msg
75: ( 0
76: , g_table_name
77: , 'CON_REQUEST_TASK_REFERENCES called but not seeded'
78: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 90: jtm_message_log_pkg.Log_Msg

86: END IF;
87: CLOSE c_LastRundate;
88:
89: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
90: jtm_message_log_pkg.Log_Msg
91: ( 0
92: , g_table_name
93: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||sysdate
94: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 110: jtm_message_log_pkg.Log_Msg

106: OPEN c_esc( r_task.task_id, r_task.resource_id, l_last_rundate );
107: FETCH c_esc INTO r_esc;
108: IF c_esc%FOUND THEN
109: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
110: jtm_message_log_pkg.Log_Msg
111: ( r_esc.task_reference_id
112: , g_table_name
113: , 'Inserting escalation '||r_esc.task_reference_id||' for resource '||r_task.resource_id
114: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 137: jtm_message_log_pkg.Log_Msg

133:
134: COMMIT;
135:
136: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
137: jtm_message_log_pkg.Log_Msg
138: ( 0
139: , g_table_name
140: , 'Leaving CON_REQUEST_TASK_REFERENCES'
141: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 146: jtm_message_log_pkg.Log_Msg

142: );
143: END IF;
144: EXCEPTION
145: WHEN OTHERS THEN
146: jtm_message_log_pkg.Log_Msg
147: ( 0
148: , g_table_name
149: , 'CON_REQUEST_TASK_REFERENCES'||fnd_global.local_chr(10)||
150: 'Error: '||sqlerrm

Line 183: jtm_message_log_pkg.Log_Msg

179: BEGIN
180: /*** get debug level ***/
181: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
182: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
183: jtm_message_log_pkg.Log_Msg
184: ( p_resource_id
185: , g_table_name
186: , 'Entering DELETE_ALL_ACC_RECORDS'
187: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 193: jtm_message_log_pkg.Log_Msg

189: END IF;
190:
191: FOR r_no_esc IN c_no_esc( p_resource_id ) LOOP
192: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
193: jtm_message_log_pkg.Log_Msg
194: ( r_no_esc.task_reference_id
195: , g_table_name
196: , 'Removing escalation '||r_no_esc.task_reference_id||' for resource '||p_resource_id
197: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 212: jtm_message_log_pkg.Log_Msg

208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
212: jtm_message_log_pkg.Log_Msg
213: ( p_resource_id
214: , g_table_name
215: , 'Leaving DELETE_ALL_ACC_RECORDS'
216: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 223: jtm_message_log_pkg.Log_Msg

219: EXCEPTION
220: WHEN OTHERS THEN
221: -- x_return_status := FND_API.G_RET_STS_ERROR;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: jtm_message_log_pkg.Log_Msg
224: ( p_resource_id
225: , g_table_name
226: , 'CON_REQUEST_TASK_REFERENCES'||fnd_global.local_chr(10)||
227: 'Error: '||sqlerrm