DBA Data[Home] [Help]

APPS.CSL_JTF_TASKS_ACC_PKG dependencies on FND_GLOBAL

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

86: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
87: jtm_message_log_pkg.Log_Msg
88: ( p_task_id
89: , g_table_name
90: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
91: 'SOURCE_OBJECT_TYPE CODE NOT IN (''SR'',''TASK'')'
92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
93: END IF;
94: RETURN FALSE;

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

101: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
102: jtm_message_log_pkg.Log_Msg
103: ( p_task_id
104: , g_table_name
105: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
106: 'SCHEDULED_START_DATE and SCHEDULED_END_DATE should both be NOT NULL.'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
108: END IF;
109: RETURN FALSE;

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

121: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
122: jtm_message_log_pkg.Log_Msg
123: ( p_task_id
124: , g_table_name
125: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
126: 'Task''s task type RULE <> ''DISPATCH''.'
127: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
128: END IF;
129: RETURN FALSE;

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

139: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
140: jtm_message_log_pkg.Log_Msg
141: ( p_task_id
142: , g_table_name
143: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
144: 'Task status for SR tasks should have either ASSIGNED_FLAG, CANCELLED_FLAG, '||
145: 'COMPLETED_FLAG or CLOSED_FLAG set to ''Y''.'
146: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
147: END IF;

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

161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_task_id
164: , g_table_name
165: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
166: 'Task''s task type private flag <> ''Y''.'
167: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
168: END IF;
169: RETURN FALSE;

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

311: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_task_id
314: , g_table_name
315: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
316: 'access_id = ' || p_acc_id
317: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
318: END IF;
319:

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

610: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
611: jtm_message_log_pkg.Log_Msg
612: ( l_task_id
613: , g_table_name
614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm
615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
616: END IF;
617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);
618: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

672: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
673: jtm_message_log_pkg.Log_Msg
674: ( l_task_id
675: , g_table_name
676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
678: END IF;
679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
680: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 804: r_task_assignment.task_assignment_id || fnd_global.local_chr(10) ||

800: jtm_message_log_pkg.Log_Msg
801: ( l_task_id
802: , g_table_name
803: , 'Evaluating task_assignment_id ' ||
804: r_task_assignment.task_assignment_id || fnd_global.local_chr(10) ||
805: 'for resource_id ' || r_task_assignment.resource_id
806: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
807: END IF;
808:

Line 835: fnd_global.local_chr(10) ||'for resource_id ' || r_task_assignment.resource_id

831: jtm_message_log_pkg.Log_Msg
832: ( l_task_id
833: , g_table_name
834: , 'Evaluating task_assignment_id ' || r_task_assignment.task_assignment_id ||
835: fnd_global.local_chr(10) ||'for resource_id ' || r_task_assignment.resource_id
836: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
837: END IF;
838:
839: /*** delete task assignment data ***/

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

860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
861: jtm_message_log_pkg.Log_Msg
862: ( l_task_id
863: , g_table_name
864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
866: END IF;
867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
868: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm

932: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
933: jtm_message_log_pkg.Log_Msg
934: ( p_resource_id
935: , g_table_name
936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
937: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
938: END IF;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: END INSERT_ALL_ACC_RECORDS;