DBA Data[Home] [Help]

APPS.CSL_MTL_MAT_TRANS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 34: jtm_message_log_pkg.Log_Msg

30: /*** get debug level ***/
31: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
32:
33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
34: jtm_message_log_pkg.Log_Msg
35: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
36: , v_object_name => g_table_name
37: , v_message => 'Entering Insert_MTL_Mat_Transaction'
38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 47: jtm_message_log_pkg.Log_Msg

43: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
44: IF c_mtl_mat_transactions%NOTFOUND THEN
45: /*** could not find assignment record -> exit ***/
46: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
47: jtm_message_log_pkg.Log_Msg
48: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
49: , v_object_name => g_table_name
50: , v_message => 'Insert_MTL_Mat_Transaction => no transactions for sub inventory :' ||
51: p_subinventory_code ||', organization '||p_organization_id||

Line 60: jtm_message_log_pkg.Log_Msg

56: CLOSE c_mtl_mat_transactions;
57: -- RETURN FALSE;
58: ELSE
59: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
60: jtm_message_log_pkg.Log_Msg
61: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
62: , v_object_name => g_table_name
63: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||
64: ' for resource id ' || p_resource_id

Line 99: jtm_message_log_pkg.Log_Msg

95: END LOOP;
96: END IF;
97:
98: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
99: jtm_message_log_pkg.Log_Msg
100: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
101: , v_object_name => g_table_name
102: , v_message => 'Leaving Insert_MTL_Mat_Transaction'
103: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 134: jtm_message_log_pkg.Log_Msg

130: /*** get debug level ***/
131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
132:
133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
134: jtm_message_log_pkg.Log_Msg
135: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
136: , v_object_name => g_table_name
137: , v_message => 'Entering Update_CSP_Sec_Inventory'
138: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 147: jtm_message_log_pkg.Log_Msg

143: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
144: IF c_mtl_mat_transactions%NOTFOUND THEN
145: /*** could not find assignment record -> exit ***/
146: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
147: jtm_message_log_pkg.Log_Msg
148: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
149: , v_object_name => g_table_name
150: , v_message => 'Update_MTL_Mat_Transaction could not find records for :' || p_subinventory_code || ','
151: || p_organization_id || ' for resource id ' || p_resource_id

Line 158: jtm_message_log_pkg.Log_Msg

154:
155: CLOSE c_mtl_mat_transactions;
156: ELSE
157: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
158: jtm_message_log_pkg.Log_Msg
159: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
160: , v_object_name => g_table_name
161: , v_message => 'Update ACC record :' || p_subinventory_code || ' , ' || p_organization_id
162: || ' for resource id ' || p_resource_id

Line 216: jtm_message_log_pkg.Log_Msg

212:
213: END IF;
214:
215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
216: jtm_message_log_pkg.Log_Msg
217: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
218: , v_object_name => g_table_name
219: , v_message => 'Leaving Update_MTL_Mat_Transaction'
220: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 251: jtm_message_log_pkg.Log_Msg

247: /*** get debug level ***/
248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
249:
250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
251: jtm_message_log_pkg.Log_Msg
252: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
253: , v_object_name => g_table_name
254: , v_message => 'Entering Delete_MTL_Mat_Transaction'
255: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 264: jtm_message_log_pkg.Log_Msg

260: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
261: IF c_mtl_mat_transactions%NOTFOUND THEN
262: /*** could not find assignment record -> exit ***/
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
266: , v_object_name => g_table_name
267: , v_message => 'Delete_MTL_Mat_Transaction could not find records for :' || p_subinventory_code ||
268: ' , ' || p_organization_id || ' for resource id ' || p_resource_id

Line 276: jtm_message_log_pkg.Log_Msg

272: CLOSE c_mtl_mat_transactions;
273: -- RETURN FALSE;
274: ELSE
275: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
276: jtm_message_log_pkg.Log_Msg
277: ( v_object_id => p_organization_id
278: , v_object_name => g_table_name
279: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||
280: ' for resource id ' || p_resource_id

Line 325: jtm_message_log_pkg.Log_Msg

321: BEGIN
322: /*** get debug level ***/
323: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_resource_id
327: , g_table_name
328: , 'Entering DELETE_ALL_ACC_RECORDS'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 339: jtm_message_log_pkg.Log_Msg

335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
339: jtm_message_log_pkg.Log_Msg
340: ( p_resource_id
341: , g_table_name
342: , 'Leaving DELETE_ALL_ACC_RECORDS'
343: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 351: jtm_message_log_pkg.Log_Msg

347: /*** hook failed -> log error ***/
348: -- x_return_status := FND_API.G_RET_STS_ERROR;
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => 1
353: , v_object_name => g_table_name
354: , v_message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
355: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);