DBA Data[Home] [Help]

APPS.CSL_CSF_DEBRIEF_LINE_ACC_PKG dependencies on FND_GLOBAL

Line 193: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id

189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
190: jtm_message_log_pkg.Log_Msg
191: ( p_debrief_line_id
192: , g_table_name
193: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
195: END IF;
196:
197: /*** Update debrief_line ACC record ***/

Line 593: , 'POST_INSERT_DEBRIEF_LINE' || fnd_global.local_chr(10) ||

589: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
590: jtm_message_log_pkg.Log_Msg
591: ( l_debrief_line_id
592: , g_table_name
593: , 'POST_INSERT_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
594: 'Resource_id ' || l_resource_id || ' is not a mobile user.'
595: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
596: END IF;
597: ELSE

Line 623: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm

619: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
620: jtm_message_log_pkg.Log_Msg
621: ( l_debrief_line_id
622: , g_table_name
623: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
624: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
625: END IF;
626: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_INSERT_DEBRIEF_LINE',sqlerrm);
627: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
703: jtm_message_log_pkg.Log_Msg
704: ( l_debrief_line_id
705: , g_table_name
706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
708: END IF;
709: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_UPDATE_DEBRIEF_LINE',sqlerrm);
710: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

875: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
876: jtm_message_log_pkg.Log_Msg
877: ( l_debrief_line_id
878: , g_table_name
879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
881: END IF;
882: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_UPDATE_DEBRIEF_LINE',sqlerrm);
883: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 934: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm

930: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
931: jtm_message_log_pkg.Log_Msg
932: ( v_object_id => l_debrief_line_id
933: , v_object_name => g_table_name
934: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
935: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
936: END IF;
937:
938: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_DELETE_DEBRIEF_LINE',sqlerrm);