DBA Data[Home] [Help]

APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on FND_GLOBAL

Line 89: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

85: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
86: jtm_message_log_pkg.Log_Msg
87: ( p_task_assignment_id
88: , g_table_name
89: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
90: 'ASSIGNEE_ROLE <> ''ASSIGNEE'''
91: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
92: END IF;
93: RETURN FALSE;

Line 104: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
101: jtm_message_log_pkg.Log_Msg
102: ( p_task_assignment_id
103: , g_table_name
104: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
105: 'Resource_id ' || r_task_assignment.resource_id || ' is not a mobile user.'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
107: END IF;
108:

Line 127: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

123: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
124: jtm_message_log_pkg.Log_Msg
125: ( p_task_assignment_id
126: , g_table_name
127: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
128: 'Assignment status should have either ASSIGNED_FLAG, CANCELLED_FLAG, '||
129: 'COMPLETED_FLAG or CLOSED_FLAG set to ''Y''.'
130: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
131: END IF;

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

232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
233: jtm_message_log_pkg.Log_Msg
234: ( p_task_assignment_id
235: , g_table_name
236: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
238: END IF;
239:
240: JTM_HOOK_UTIL_PKG.Update_Acc

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

558: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
559: jtm_message_log_pkg.Log_Msg
560: ( l_task_assignment_id
561: , g_table_name
562: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
563: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
564: END IF;
565: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_INSERT_TASK_ASSIGNMENT',sqlerrm);
566: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

621: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
622: jtm_message_log_pkg.Log_Msg
623: ( l_task_assignment_id
624: , g_table_name
625: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
626: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
627: END IF;
628: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_UPDATE_TASK_ASSIGNMENT',sqlerrm);
629: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 672: , 'Task assignment resource_id changed from ' || g_old_resource_id || ' to ' || l_resource_id || '.' || fnd_global.local_chr(10) ||

668: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
669: jtm_message_log_pkg.Log_Msg
670: ( l_task_assignment_id
671: , g_table_name
672: , 'Task assignment resource_id changed from ' || g_old_resource_id || ' to ' || l_resource_id || '.' || fnd_global.local_chr(10) ||
673: 'Deleting old assignment ACC record (if exists).'
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
675: END IF;
676:

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

737: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
738: jtm_message_log_pkg.Log_Msg
739: ( l_task_assignment_id
740: , g_table_name
741: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
742: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
743: END IF;
744: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_UPDATE_TASK_ASSIGNMENT',sqlerrm);
745: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

795: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
796: jtm_message_log_pkg.Log_Msg
797: ( l_task_assignment_id
798: , g_table_name
799: , 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
801: END IF;
802: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_DELETE_TASK_ASSIGNMENT',sqlerrm);
803: -- x_return_status := FND_API.G_RET_STS_ERROR;