40: BEGIN
41: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
42:
43: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
44: jtm_message_log_pkg.Log_Msg
45: ( p_notification_id
46: , g_table_name
47: , 'Entering function REPLICATE_RECORD'
48: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
70: END IF;
71: CLOSE c_mobile;
72: IF l_ret_value = FALSE THEN
73: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
74: jtm_message_log_pkg.Log_Msg
75: ( p_notification_id
76: , g_table_name
77: , 'Notification '||p_notification_id||' is not for a valid mobile field service user.'
78: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
80: END IF;
81: END IF;
82: ELSE
83: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
84: jtm_message_log_pkg.Log_Msg
85: ( p_notification_id
86: , g_table_name
87: , 'Notification '||p_notification_id||' is not an open CS_MSGS/FYI_MESSAGE'
88: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
90: END IF;
91: CLOSE c_notification;
92:
93: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
94: jtm_message_log_pkg.Log_Msg
95: ( p_notification_id
96: , g_table_name
97: , 'Leaving function REPLICATE_RECORD'
98: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
137:
138: BEGIN
139: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
141: jtm_message_log_pkg.Log_Msg
142: ( p_notification_id
143: , g_table_name
144: , 'Entering Procedure INSERT_NOTIFICATION'
145: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
184: CLOSE c_get_sender;
185: END IF;
186:
187: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
188: jtm_message_log_pkg.LOG_MSG
189: ( p_notification_id
190: , g_table_name
191: , 'Leaving Procedure INSERT_NOTIFICATION'
192: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);