DBA Data[Home] [Help]

APPS.CSL_NOTES_PKG dependencies on FND_GLOBAL

Line 58: , p_last_updated_by => FND_GLOBAL.USER_ID

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: );

Line 60: , p_last_update_login => FND_GLOBAL.LOGIN_ID

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

Line 85: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

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);

Line 140: , p_last_updated_by => FND_GLOBAL.USER_ID

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:

Line 142: , p_last_update_login => FND_GLOBAL.LOGIN_ID

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 ***/

Line 166: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

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);

Line 213: , v_message => 'Processing JTF_NOTE_ID = ' || p_record.jtf_note_id || fnd_global.local_chr(10) ||

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:

Line 285: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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);

Line 436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || 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;