DBA Data[Home] [Help]

APPS.CSL_JTF_NOTES_ACC_PKG dependencies on FND_GLOBAL

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

227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
228: jtm_message_log_pkg.Log_Msg
229: ( p_jtf_note_id
230: , g_table_name
231: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
233: END IF;
234:
235: /*** Update jtf_note ACC record ***/

Line 671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||

667: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
668: jtm_message_log_pkg.Log_Msg
669: ( p_jtf_note_id
670: , g_table_name
671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||
672: 'Object id = '||r_object.SOURCE_OBJECT_ID||fnd_global.local_chr(10)||
673: 'Object_code = '||r_object.SOURCE_OBJECT_CODE
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
675: END IF; -- g_debug_level

Line 672: 'Object id = '||r_object.SOURCE_OBJECT_ID||fnd_global.local_chr(10)||

668: jtm_message_log_pkg.Log_Msg
669: ( p_jtf_note_id
670: , g_table_name
671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||
672: 'Object id = '||r_object.SOURCE_OBJECT_ID||fnd_global.local_chr(10)||
673: 'Object_code = '||r_object.SOURCE_OBJECT_CODE
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
675: END IF; -- g_debug_level
676: END IF; -- l_replicate = FALSE

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

691: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
692: jtm_message_log_pkg.Log_Msg
693: ( p_jtf_note_id
694: , g_table_name
695: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
696: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
697: END IF;
698: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_NOTES_ACC_PKG','POST_INSERT_JTF_NOTES',sqlerrm);
699: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 795: , 'POST_UPDATE_DEBRIEF_LINE' || fnd_global.local_chr(10) ||

791: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
792: jtm_message_log_pkg.Log_Msg
793: ( l_tab_resource_id(i)
794: , g_table_name
795: , 'POST_UPDATE_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
796: 'Resource_id ' || l_tab_resource_id(i) || ' is not a mobile user.'
797: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
798: END IF;
799: ELSE

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

824: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
825: jtm_message_log_pkg.Log_Msg
826: ( l_jtf_note_id
827: , g_table_name
828: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
829: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
830: END IF;
831: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_NOTES_ACC_PKG','POST_UPDATE_JTF_NOTES',sqlerrm);
832: -- x_return_status := FND_API.G_RET_STS_ERROR;