eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CSP_INV_LOC_ASS_ACC_PKG dependencies on FND_GLOBAL

Line 65: , v_message => 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

61: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
62: jtm_message_log_pkg.Log_Msg
63: ( v_object_id => p_csp_inv_loc_assignment_id
64: , v_object_name => g_table_name
65: , v_message => 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
66: 'RESOURCE_TYPE <> ''RS_EMPLOYEE'''
67: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
68: END IF;
69: RETURN l_return_value;

Line 79: , v_message => 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
76: jtm_message_log_pkg.Log_Msg
77: ( v_object_id => p_csp_inv_loc_assignment_id
78: , v_object_name => g_table_name
79: , v_message => 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
80: 'Resource_id ' || r_csp_inv_loc_assignment.resource_id || ' is not a mobile user.'
81: || fnd_global.local_chr(10) || 'For location assignment : ' || p_csp_inv_loc_assignment_id
82: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
83: END IF;

Line 81: || fnd_global.local_chr(10) || 'For location assignment : ' || p_csp_inv_loc_assignment_id

77: ( v_object_id => p_csp_inv_loc_assignment_id
78: , v_object_name => g_table_name
79: , v_message => 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
80: 'Resource_id ' || r_csp_inv_loc_assignment.resource_id || ' is not a mobile user.'
81: || fnd_global.local_chr(10) || 'For location assignment : ' || p_csp_inv_loc_assignment_id
82: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
83: END IF;
84:
85: RETURN l_return_value;

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

162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
163: jtm_message_log_pkg.Log_Msg
164: ( v_object_id => p_csp_inv_loc_assignment_id
165: , v_object_name => g_table_name
166: , v_message => 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
167: 'access_id = ' || p_acc_id
168: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
169: END IF;
170:

Line 208: , v_message => 'Deleting ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||

204: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
205: jtm_message_log_pkg.Log_Msg
206: ( v_object_id => p_csp_inv_loc_assignment_id
207: , v_object_name => g_table_name
208: , v_message => 'Deleting ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
209: 'Location assignment = ' || p_csp_inv_loc_assignment_id
210: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
211: END IF;
212:

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

438: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
439: jtm_message_log_pkg.Log_Msg
440: ( v_object_id => l_csp_inv_loc_assignment_id
441: , v_object_name => g_table_name
442: , v_message => 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
443: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
444: END IF;
445: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','POST_INSERT_INV_LOC_ASSIGNMENT',sqlerrm);
446: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
502: jtm_message_log_pkg.Log_Msg
503: ( v_object_id => l_csp_inv_loc_assignment
504: , v_object_name => g_table_name
505: , v_message => 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
506: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
507: END IF;
508: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','PRE_UPDATE_INV_LOC_ASSIGNMENT',sqlerrm);
509: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 574: ' to ' || l_resource_id || '.' || fnd_global.local_chr(10) ||

570: jtm_message_log_pkg.Log_Msg
571: ( l_csp_inv_loc_assignment
572: , g_table_name
573: , 'Invntory Location Assignment resource_id changed from ' || g_old_resource_id ||
574: ' to ' || l_resource_id || '.' || fnd_global.local_chr(10) ||
575: 'Deleting old assignment ACC record (if exists).'
576: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
577: END IF;
578:

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

650: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
651: jtm_message_log_pkg.Log_Msg
652: ( v_object_id => l_csp_inv_loc_assignment
653: , v_object_name => g_table_name
654: , v_message => 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
655: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
656: END IF;
657: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','POST_UPDATE_INV_LOC_ASSIGNMENT',sqlerrm);
658: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

708: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
709: jtm_message_log_pkg.Log_Msg
710: ( v_object_id => l_csp_inv_loc_assignment
711: , v_object_name => g_table_name
712: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
713: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
714: END IF;
715: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','PRE_DELETE_INV_LOC_ASSIGNMENT',sqlerrm);
716: -- x_return_status := FND_API.G_RET_STS_ERROR;