38: /*** get debug level ***/
39: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
40:
41: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
42: jtm_message_log_pkg.Log_Msg
43: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
44: , v_object_name => g_table_name
45: , v_message => 'Entering Insert_CSP_Sec_Inventory'
46: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
51: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
52: IF c_csp_sec_inventories%NOTFOUND THEN
53: /*** could not find assignment record -> exit ***/
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
55: jtm_message_log_pkg.Log_Msg
56: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
57: , v_object_name => g_table_name
58: , v_message => 'Insert_CSP_Sec_Inventory could not find :' || p_subinventory_code ||
59: ' , ' || p_organization_id || ' for resource id ' || p_resource_id
64:
65: CLOSE c_csp_sec_inventories;
66: ELSE
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
70: , v_object_name => g_table_name
71: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||
72: ' for resource id ' || p_resource_id
125: /*** get debug level ***/
126: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
127:
128: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
129: jtm_message_log_pkg.Log_Msg
130: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
131: , v_object_name => g_table_name
132: , v_message => 'Entering Update_CSP_Sec_Inventory'
133: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
138: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
139: IF c_csp_sec_inventories%NOTFOUND THEN
140: /*** could not find assignment record -> exit ***/
141: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
142: jtm_message_log_pkg.Log_Msg
143: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
144: , v_object_name => g_table_name
145: , v_message => 'Update_CSP_Sec_Inventory could not find :' || p_subinventory_code || ' , '
146: || p_organization_id || ' for resource id ' || p_resource_id
149:
150: CLOSE c_csp_sec_inventories;
151: ELSE
152: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
153: jtm_message_log_pkg.Log_Msg
154: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
155: , v_object_name => g_table_name
156: , v_message => 'Update ACC record :' || p_subinventory_code || ' , ' || p_organization_id
157: || ' for resource id ' || p_resource_id
204:
205: END IF;
206:
207: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
208: jtm_message_log_pkg.Log_Msg
209: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
210: , v_object_name => g_table_name
211: , v_message => 'Leaving Update_CSP_Sec_Inventory'
212: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
243: /*** get debug level ***/
244: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
245:
246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
249: , v_object_name => g_table_name
250: , v_message => 'Entering Delete_CSP_Sec_Inventory'
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
256: FETCH c_csp_sec_inventories INTO r_csp_sec_inventories;
257: IF c_csp_sec_inventories%NOTFOUND THEN
258: /*** could not find assignment record -> exit ***/
259: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
260: jtm_message_log_pkg.Log_Msg
261: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
262: , v_object_name => g_table_name
263: , v_message => 'Delete_CSP_Sec_Inventory could not find :' || p_subinventory_code || ' , '
264: || p_organization_id || ' for resource id ' || p_resource_id
268: CLOSE c_csp_sec_inventories;
269: RETURN l_return_value;
270: ELSE
271: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
272: jtm_message_log_pkg.Log_Msg
273: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
274: , v_object_name => g_table_name
275: , v_message => 'Deleting ACC record :' || p_subinventory_code || ' , ' || p_organization_id
276: || ' for resource id ' || p_resource_id