54: , p_entered_by => p_record.entered_by
55: , p_entered_date => p_record.entered_date
56: , p_created_by => p_record.entered_by
57: , p_creation_date => SYSDATE
58: , p_last_updated_by => FND_GLOBAL.USER_ID
59: , p_last_update_date => SYSDATE
60: , p_last_update_login => FND_GLOBAL.LOGIN_ID
61: , x_jtf_note_id => l_note_id
62: );
56: , p_created_by => p_record.entered_by
57: , p_creation_date => SYSDATE
58: , p_last_updated_by => FND_GLOBAL.USER_ID
59: , p_last_update_date => SYSDATE
60: , p_last_update_login => FND_GLOBAL.LOGIN_ID
61: , x_jtf_note_id => l_note_id
62: );
63:
64: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
81: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
82: jtm_message_log_pkg.Log_Msg
83: ( v_object_id => p_record.jtf_note_id
84: , v_object_name => g_object_name
85: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
86: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
87: END IF;
88:
89: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
136: , p_notes => p_record.notes
137: , p_note_status => p_record.note_status
138: , p_note_type => p_record.note_type
139: , p_entered_by => p_record.entered_by
140: , p_last_updated_by => FND_GLOBAL.USER_ID
141: , p_last_update_date => SYSDATE
142: , p_last_update_login => FND_GLOBAL.LOGIN_ID
143: );
144:
138: , p_note_type => p_record.note_type
139: , p_entered_by => p_record.entered_by
140: , p_last_updated_by => FND_GLOBAL.USER_ID
141: , p_last_update_date => SYSDATE
142: , p_last_update_login => FND_GLOBAL.LOGIN_ID
143: );
144:
145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
146: /*** exception occurred in API -> return errmsg ***/
162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
163: jtm_message_log_pkg.Log_Msg
164: ( v_object_id => p_record.jtf_note_id
165: , v_object_name => g_object_name
166: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
167: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
168: END IF;
169:
170: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
210: jtm_message_log_pkg.Log_Msg
211: ( v_object_id => p_record.jtf_note_id
212: , v_object_name => g_object_name
213: , v_message => 'Processing JTF_NOTE_ID = ' || p_record.jtf_note_id || fnd_global.local_chr(10) ||
214: 'DMLTYPE = ' || p_record.dmltype$$
215: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
216: END IF;
217:
281: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
282: jtm_message_log_pkg.Log_Msg
283: ( v_object_id => p_record.jtf_note_id
284: , v_object_name => g_object_name
285: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
286: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
287: END IF;
288:
289: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
433: jtm_message_log_pkg.Log_Msg
434: ( v_object_id => null
435: , v_object_name => g_object_name
436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
437: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END APPLY_CLIENT_CHANGES;