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 JTM_MESSAGE_LOG_PKG

Line 32: jtm_message_log_pkg.Log_Msg

28: /*** get debug level ***/
29: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
30:
31: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
32: jtm_message_log_pkg.Log_Msg
33: ( v_object_id => p_csp_inv_loc_assignment_id
34: , v_object_name => g_table_name
35: , v_message => 'Entering Replicate_Record'
36: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 45: jtm_message_log_pkg.Log_Msg

41: FETCH c_csp_inv_loc_assignment INTO r_csp_inv_loc_assignment;
42: IF c_csp_inv_loc_assignment%NOTFOUND THEN
43: /*** could not find assignment record -> exit ***/
44: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
45: jtm_message_log_pkg.Log_Msg
46: ( v_object_id => p_csp_inv_loc_assignment_id
47: , v_object_name => g_table_name
48: , v_message => 'Replicate_Record error: Could not find '
49: || g_pk1_name || ' ' || p_csp_inv_loc_assignment_id

Line 62: jtm_message_log_pkg.Log_Msg

58: /*** is this an RS_EMPLOYEE assignment? ***/
59: IF NVL(r_csp_inv_loc_assignment.resource_type,'') <> 'RS_EMPLOYEE' THEN
60: /*** No -> exit ***/
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'''

Line 76: jtm_message_log_pkg.Log_Msg

72: /*** is resource a mobile user? ***/
73: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( r_csp_inv_loc_assignment.resource_id ) THEN
74: /*** No -> exit ***/
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.'

Line 90: jtm_message_log_pkg.Log_Msg

86: END IF;
87:
88: /*** Record is found OK return status ***/
89: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
90: jtm_message_log_pkg.Log_Msg
91: ( v_object_id => p_csp_inv_loc_assignment_id
92: , v_object_name => g_table_name
93: , v_message => 'Replicate_Record returned TRUE'
94: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 111: jtm_message_log_pkg.Log_Msg

107: IS
108: l_success BOOLEAN;
109: BEGIN
110: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
111: jtm_message_log_pkg.Log_Msg
112: ( v_object_id => p_csp_inv_loc_assignment_id
113: , v_object_name => g_table_name
114: , v_message => 'Entering Insert_ACC_Record'
115: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 119: jtm_message_log_pkg.Log_Msg

115: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
116: END IF;
117:
118: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
119: jtm_message_log_pkg.Log_Msg
120: ( v_object_id => p_csp_inv_loc_assignment_id
121: , v_object_name => g_table_name
122: , v_message => 'Inserting ACC record for resource_id = ' || p_resource_id
123: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 136: jtm_message_log_pkg.Log_Msg

132: ,p_resource_id => p_resource_id
133: );
134:
135: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
136: jtm_message_log_pkg.Log_Msg
137: ( v_object_id => p_csp_inv_loc_assignment_id
138: , v_object_name => g_table_name
139: , v_message => 'Leaving Insert_ACC_Record'
140: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 155: jtm_message_log_pkg.Log_Msg

151: IS
152:
153: BEGIN
154: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
155: jtm_message_log_pkg.Log_Msg
156: ( v_object_id => p_csp_inv_loc_assignment_id
157: , v_object_name => g_table_name
158: , v_message => 'Entering Update_ACC_Record'
159: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 163: jtm_message_log_pkg.Log_Msg

159: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
160: END IF;
161:
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

Line 180: jtm_message_log_pkg.Log_Msg

176: ,p_access_id => p_acc_id
177: );
178:
179: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
180: jtm_message_log_pkg.Log_Msg
181: ( v_object_id => p_csp_inv_loc_assignment_id
182: , v_object_name => g_table_name
183: , v_message => 'Leaving Update_ACC_Record'
184: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 197: jtm_message_log_pkg.Log_Msg

193: IS
194:
195: BEGIN
196: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
197: jtm_message_log_pkg.Log_Msg
198: ( v_object_id => p_csp_inv_loc_assignment_id
199: , v_object_name => g_table_name
200: , v_message => 'Entering Delete_ACC_Record'
201: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 205: jtm_message_log_pkg.Log_Msg

201: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
202: END IF;
203:
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

Line 223: jtm_message_log_pkg.Log_Msg

219: ,p_resource_id => p_resource_id
220: );
221:
222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
223: jtm_message_log_pkg.Log_Msg
224: ( v_object_id => p_csp_inv_loc_assignment_id
225: , v_object_name => g_table_name
226: , v_message => 'Leaving Delete_ACC_Record'
227: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 254: jtm_message_log_pkg.Log_Msg

250: /*** get debug level ***/
251: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
252:
253: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
254: jtm_message_log_pkg.Log_Msg
255: ( v_object_id => p_csp_inv_loc_assignment_id
256: , v_object_name => g_table_name
257: , v_message => 'Entering Pre_Insert_Child procedure'
258: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 293: jtm_message_log_pkg.Log_Msg

289: CLOSE c_retreive_org_name;
290: END IF;
291:
292: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
293: jtm_message_log_pkg.Log_Msg
294: ( p_csp_inv_loc_assignment_id
295: , g_table_name
296: , 'Leaving Pre_Insert_Child procedure'
297: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 326: jtm_message_log_pkg.Log_Msg

322: /*** get debug level ***/
323: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
324:
325: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
326: jtm_message_log_pkg.Log_Msg
327: ( p_csp_inv_loc_assignment_id
328: , g_table_name
329: , 'Entering Post_Delete_Child'
330: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 356: jtm_message_log_pkg.Log_Msg

352: END IF;
353: CLOSE c_retreive_org_name;
354:
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( p_csp_inv_loc_assignment_id
358: , g_table_name
359: , 'Leaving Post_Delete_Child'
360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 396: jtm_message_log_pkg.Log_Msg

392: /*** get debug level ***/
393: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
394:
395: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
396: jtm_message_log_pkg.Log_Msg
397: ( v_object_id => l_csp_inv_loc_assignment_id
398: , v_object_name => g_table_name
399: , v_message => 'Entering POST_INSERT hook'
400: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 416: jtm_message_log_pkg.Log_Msg

412: ,l_resource_id
413: );
414: ELSE
415: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
416: jtm_message_log_pkg.Log_Msg
417: ( v_object_id => l_csp_inv_loc_assignment_id
418: , v_object_name => g_table_name
419: , v_message => 'Cannot find resource for inv loc assignment '||l_csp_inv_loc_assignment_id
420: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 426: jtm_message_log_pkg.Log_Msg

422: END IF;
423: CLOSE c_resource;
424:
425: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
426: jtm_message_log_pkg.Log_Msg
427: ( v_object_id => l_csp_inv_loc_assignment_id
428: , v_object_name => g_table_name
429: , v_message => 'Leaving POST_INSERT hook'
430: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 439: jtm_message_log_pkg.Log_Msg

435:
436: EXCEPTION WHEN OTHERS THEN
437: /*** hook failed -> log error ***/
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);

Line 476: jtm_message_log_pkg.Log_Msg

472: /*** get debug level ***/
473: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
474:
475: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
476: jtm_message_log_pkg.Log_Msg
477: ( v_object_id => l_csp_inv_loc_assignment
478: , v_object_name => g_table_name
479: , v_message => 'Entering PRE_UPDATE hook'
480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 490: jtm_message_log_pkg.Log_Msg

486: g_old_resource_id := r_csp_inv_loc_assignment.resource_id;
487: CLOSE c_csp_inv_loc_assignment;
488:
489: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
490: jtm_message_log_pkg.Log_Msg
491: ( v_object_id => l_csp_inv_loc_assignment
492: , v_object_name => g_table_name
493: , v_message => 'Leaving PRE_UPDATE hook'
494: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 502: jtm_message_log_pkg.Log_Msg

498:
499: EXCEPTION WHEN OTHERS THEN
500: /*** hook failed -> log error ***/
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);

Line 549: jtm_message_log_pkg.Log_Msg

545: /*** get debug level ***/
546: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
547:
548: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => l_csp_inv_loc_assignment
551: , v_object_name => g_table_name
552: , v_message => 'Entering POST_UPDATE hook'
553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 570: jtm_message_log_pkg.Log_Msg

566: /*** did resource_id get changed? ***/
567: IF (g_old_resource_id <> l_resource_id) THEN
568: /*** yes -> do cascading delete for old resource_id ***/
569: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
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) ||

Line 626: jtm_message_log_pkg.Log_Msg

622: /*** record should not be replicated ***/
623: IF l_acc_id > -1 THEN
624: /*** record exists on mobile but should not be replicated anymore -> delete from mobile ***/
625: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
626: jtm_message_log_pkg.Log_Msg
627: ( l_csp_inv_loc_assignment
628: , g_table_name
629: , 'Inventory Location Assignment was replicated before update, but should not be replicated anymore.'
630: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 640: jtm_message_log_pkg.Log_Msg

636: END IF;
637: END IF;
638:
639: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
640: jtm_message_log_pkg.Log_Msg
641: ( v_object_id => l_csp_inv_loc_assignment
642: , v_object_name => g_table_name
643: , v_message => 'Leaving POST_UPDATE hook'
644: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 651: jtm_message_log_pkg.Log_Msg

647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION WHEN OTHERS THEN
649: /*** hook failed -> log error ***/
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);

Line 684: jtm_message_log_pkg.Log_Msg

680: /*** get debug level ***/
681: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
682:
683: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
684: jtm_message_log_pkg.Log_Msg
685: ( v_object_id => l_csp_inv_loc_assignment
686: , v_object_name => g_table_name
687: , v_message => 'Entering PRE_DELETE hook'
688: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 699: jtm_message_log_pkg.Log_Msg

695:
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
699: jtm_message_log_pkg.Log_Msg
700: ( v_object_id => l_csp_inv_loc_assignment
701: , v_object_name => g_table_name
702: , v_message => 'Leaving PRE_DELETE hook'
703: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 709: jtm_message_log_pkg.Log_Msg

705:
706: EXCEPTION WHEN OTHERS THEN
707: /*** hook failed -> log error ***/
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);

Line 748: jtm_message_log_pkg.Log_Msg

744: l_dummy BOOLEAN;
745: BEGIN
746: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;
747: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
748: jtm_message_log_pkg.Log_Msg
749: ( p_resource_id
750: , g_table_name
751: , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 755: jtm_message_log_pkg.Log_Msg

751: , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
753: END IF;
754: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
755: jtm_message_log_pkg.Log_Msg
756: ( p_resource_id
757: , g_table_name
758: , 'Delete all Inventory Location Assignemts acc records for user: ' || p_resource_id
759: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 766: jtm_message_log_pkg.Log_Msg

762: OPEN c_csp_inv_loc_assignment( p_resource_id );
763: FETCH c_csp_inv_loc_assignment INTO r_csp_inv_loc_assignment;
764: IF c_csp_inv_loc_assignment%NOTFOUND THEN
765: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
766: jtm_message_log_pkg.Log_Msg
767: ( v_object_id => p_resource_id
768: , v_object_name => g_table_name
769: , v_message => 'There are no rows returned for user : ' || p_resource_id
770: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 784: jtm_message_log_pkg.Log_Msg

780: END IF;
781: CLOSE c_csp_inv_loc_assignment;
782:
783: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
784: jtm_message_log_pkg.Log_Msg
785: ( p_resource_id
786: , g_table_name
787: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
788: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 820: jtm_message_log_pkg.Log_Msg

816: l_dummy BOOLEAN;
817: BEGIN
818: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;
819: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
820: jtm_message_log_pkg.Log_Msg
821: ( p_resource_id
822: , g_table_name
823: , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
824: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 827: jtm_message_log_pkg.Log_Msg

823: , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
824: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
825: END IF;
826: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
827: jtm_message_log_pkg.Log_Msg
828: ( p_resource_id
829: , g_table_name
830: , 'Insert all Inventory Location Assignments acc records for user: ' || p_resource_id
831: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 842: jtm_message_log_pkg.Log_Msg

838: OPEN c_csp_inv_loc_assignment( p_resource_id );
839: FETCH c_csp_inv_loc_assignment INTO r_csp_inv_loc_assignment;
840: IF c_csp_inv_loc_assignment%NOTFOUND THEN
841: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
842: jtm_message_log_pkg.Log_Msg
843: ( v_object_id => p_resource_id
844: , v_object_name => g_table_name
845: , v_message => 'There are no rows returned for user : ' || p_resource_id
846: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 861: jtm_message_log_pkg.Log_Msg

857: CLOSE c_csp_inv_loc_assignment;
858: l_return_value := FND_API.G_RET_STS_SUCCESS;
859: ELSE
860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
861: jtm_message_log_pkg.Log_Msg
862: ( v_object_id => p_resource_id
863: , v_object_name => g_table_name
864: , v_message => 'User with resource id : ' || p_resource_id || ' is not a Mobile User.'
865: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);