APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 160: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

156: l_dummy BOOLEAN;
157: l_current_run_date DATE;
158:
159: BEGIN
160: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
161: jtm_message_log_pkg.Log_Msg
162: ( 1
163: , g_table_name1
164: , 'Entering CONC_ORDER_UPDATE hook'

Line 165: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

161: jtm_message_log_pkg.Log_Msg
162: ( 1
163: , g_table_name1
164: , 'Entering CONC_ORDER_UPDATE hook'
165: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
166: END IF;
167:
168: l_current_run_date := sysdate;
169:

Line 185: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

181: CLOSE c_order_info;
182:
183: IF l_tab_access_id.COUNT > 0 THEN
184: /*** 1 or more acc rows retrieved -> push to resource ***/
185: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
186: jtm_message_log_pkg.Log_Msg
187: ( l_tab_access_id(1)
188: , g_table_name1
189: , 'Updating Order Lines'

Line 190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

186: jtm_message_log_pkg.Log_Msg
187: ( l_tab_access_id(1)
188: , g_table_name1
189: , 'Updating Order Lines'
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
191: END IF;
192:
193: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST
194: LOOP

Line 215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

211: AND procedure_name = 'CONC_ORDER_UPDATE';
212:
213: COMMIT;
214:
215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
216: jtm_message_log_pkg.Log_Msg
217: ( 1
218: , g_table_name1
219: , 'Leaving CONC_ORDER_UPDATE hook'

Line 220: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

216: jtm_message_log_pkg.Log_Msg
217: ( 1
218: , g_table_name1
219: , 'Leaving CONC_ORDER_UPDATE hook'
220: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
221: END IF;
222:
223: p_status := 'FINE';
224: p_message := 'CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE Executed successfully';

Line 231: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

227: EXCEPTION WHEN OTHERS THEN
228: p_status := 'ERROR';
229: p_message := 'Error in CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE: ' || substr(SQLERRM, 1, 2000);
230: /*** hook failed -> log error ***/
231: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
232: jtm_message_log_pkg.Log_Msg
233: ( 1
234: , g_table_name1
235: , 'Caught exception in CONC_ORDER_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

232: jtm_message_log_pkg.Log_Msg
233: ( 1
234: , g_table_name1
235: , 'Caught exception in CONC_ORDER_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
237: END IF;
238: fnd_msg_pub.Add_Exc_Msg('CSM_CSP_REQ_LINES_EVENT_PKG','CONC_ORDER_UPDATE',sqlerrm);
239: END CONC_ORDER_UPDATE;
240: