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_TASKS_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

26: l_msg_count NUMBER;
27: l_msg_data VARCHAR2(240);
28: l_task_id jtf_tasks_b.task_id%type;
29: BEGIN
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.task_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering CSL_TASKS_PKG.APPLY_INSERT'

Line 35: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.task_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering CSL_TASKS_PKG.APPLY_INSERT'
35: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
36: END IF;
37:
38: JTF_TASKS_PUB.create_task (
39: p_api_version => 1.0,

Line 49: p_owner_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),

45: p_description => p_record.DESCRIPTION,
46: p_task_status_id => p_record.TASK_STATUS_ID,
47: p_task_priority_id => p_record.TASK_PRIORITY_ID,
48: p_owner_type_code => 'RS_EMPLOYEE',
49: p_owner_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
50: p_customer_id => p_record.CUSTOMER_ID,
51: p_planned_start_date => p_record.PLANNED_START_DATE,
52: p_planned_end_date => p_record.PLANNED_END_DATE,
53: p_scheduled_start_date => p_record.SCHEDULED_START_DATE,

Line 91: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

87: p_api_error => TRUE
88: );
89: END IF;
90:
91: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
92: jtm_message_log_pkg.Log_Msg
93: ( v_object_id => p_record.task_id
94: , v_object_name => g_object_name
95: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'

Line 96: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

92: jtm_message_log_pkg.Log_Msg
93: ( v_object_id => p_record.task_id
94: , v_object_name => g_object_name
95: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'
96: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
97: END IF;
98:
99: EXCEPTION WHEN OTHERS THEN
100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

96: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
97: END IF;
98:
99: EXCEPTION WHEN OTHERS THEN
100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
101: jtm_message_log_pkg.Log_Msg
102: ( v_object_id => p_record.task_id
103: , v_object_name => g_object_name
104: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

Line 105: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

101: jtm_message_log_pkg.Log_Msg
102: ( v_object_id => p_record.task_id
103: , v_object_name => g_object_name
104: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
105: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
106: END IF;
107:
108: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
109: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 114: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

110: (
111: p_api_error => TRUE
112: );
113:
114: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
115: jtm_message_log_pkg.Log_Msg
116: ( v_object_id => p_record.task_id
117: , v_object_name => g_object_name
118: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'

Line 119: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

115: jtm_message_log_pkg.Log_Msg
116: ( v_object_id => p_record.task_id
117: , v_object_name => g_object_name
118: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'
119: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
120: END IF;
121:
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END APPLY_INSERT;

Line 156: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

152:
153: l_profile_value VARCHAR2(240);
154:
155: BEGIN
156: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
157: jtm_message_log_pkg.Log_Msg
158: ( v_object_id => p_record.task_id
159: , v_object_name => g_object_name
160: , v_message => 'Entering CSL_TASKS_PKG.APPLY_UPDATE'

Line 161: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

157: jtm_message_log_pkg.Log_Msg
158: ( v_object_id => p_record.task_id
159: , v_object_name => g_object_name
160: , v_message => 'Entering CSL_TASKS_PKG.APPLY_UPDATE'
161: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
162: END IF;
163:
164: -- Check for Stale data
165: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');

Line 173: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

169: fetch c_last_update_date into r_last_update_date;
170: if c_last_update_date%found then
171: if r_last_update_date.last_update_date <> p_record.last_update_date then
172: close c_last_update_date;
173: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
174: jtm_message_log_pkg.Log_Msg
175: ( v_object_id => p_record.task_id
176: , v_object_name => g_object_name
177: , v_message => 'Record has stale data'

Line 178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

174: jtm_message_log_pkg.Log_Msg
175: ( v_object_id => p_record.task_id
176: , v_object_name => g_object_name
177: , v_message => 'Record has stale data'
178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
179: END IF;
180: fnd_message.set_name
181: ( 'JTM'
182: , 'JTM_STALE_DATA'

Line 185: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

181: ( 'JTM'
182: , 'JTM_STALE_DATA'
183: );
184: fnd_msg_pub.add;
185: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
186: jtm_message_log_pkg.Log_Msg
187: ( v_object_id => p_record.task_id
188: , v_object_name => g_object_name
189: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 190: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

186: jtm_message_log_pkg.Log_Msg
187: ( v_object_id => p_record.task_id
188: , v_object_name => g_object_name
189: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
190: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
191: END IF;
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: return;

Line 197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: return;
195: end if;
196: else
197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
198: jtm_message_log_pkg.Log_Msg
199: ( v_object_id => p_record.task_id
200: , v_object_name => g_object_name
201: , v_message => 'No record found in Apps Database.'

Line 202: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

198: jtm_message_log_pkg.Log_Msg
199: ( v_object_id => p_record.task_id
200: , v_object_name => g_object_name
201: , v_message => 'No record found in Apps Database.'
202: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
203: END IF;
204: end if;
205: close c_last_update_date;
206: end if;

Line 260: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

256: p_api_error => TRUE
257: );
258: END IF;
259:
260: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
261: jtm_message_log_pkg.Log_Msg
262: ( v_object_id => p_record.task_id
263: , v_object_name => g_object_name
264: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'

Line 265: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

261: jtm_message_log_pkg.Log_Msg
262: ( v_object_id => p_record.task_id
263: , v_object_name => g_object_name
264: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'
265: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
266: END IF;
267:
268: EXCEPTION WHEN OTHERS THEN
269: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 269: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

265: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
266: END IF;
267:
268: EXCEPTION WHEN OTHERS THEN
269: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
270: jtm_message_log_pkg.Log_Msg
271: ( v_object_id => p_record.task_id
272: , v_object_name => g_object_name
273: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

Line 274: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

270: jtm_message_log_pkg.Log_Msg
271: ( v_object_id => p_record.task_id
272: , v_object_name => g_object_name
273: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
274: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
275: END IF;
276:
277: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
278: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 283: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

279: (
280: p_api_error => TRUE
281: );
282:
283: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
284: jtm_message_log_pkg.Log_Msg
285: ( v_object_id => p_record.task_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'

Line 288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

284: jtm_message_log_pkg.Log_Msg
285: ( v_object_id => p_record.task_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'
288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
289: END IF;
290:
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END APPLY_UPDATE;

Line 310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

306: /*** initialize return status and message list ***/
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: FND_MSG_PUB.INITIALIZE;
309:
310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.task_id
313: , v_object_name => g_object_name
314: , v_message => 'Entering CSL_TASKS_PKG.APPLY_RECORD'

Line 315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.task_id
313: , v_object_name => g_object_name
314: , v_message => 'Entering CSL_TASKS_PKG.APPLY_RECORD'
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
316: END IF;
317:
318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
319: jtm_message_log_pkg.Log_Msg

Line 318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

314: , v_message => 'Entering CSL_TASKS_PKG.APPLY_RECORD'
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
316: END IF;
317:
318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
319: jtm_message_log_pkg.Log_Msg
320: ( v_object_id => p_record.task_id
321: , v_object_name => g_object_name
322: , v_message => 'Processing task_id = ' || p_record.task_id || fnd_global.local_chr(10) ||

Line 324: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

320: ( v_object_id => p_record.task_id
321: , v_object_name => g_object_name
322: , v_message => 'Processing task_id = ' || p_record.task_id || fnd_global.local_chr(10) ||
323: 'DMLTYPE = ' || p_record.dmltype$$
324: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
325: END IF;
326:
327: IF p_record.dmltype$$='I' THEN
328: -- Process insert

Line 345: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

341: x_return_status
342: );
343: ELSIF p_record.dmltype$$='D' THEN
344: -- Process delete; not supported for this entity
345: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
346: jtm_message_log_pkg.Log_Msg
347: ( v_object_id => p_record.task_id
348: , v_object_name => g_object_name
349: , v_message => 'Delete is not supported for this entity'

Line 350: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

346: jtm_message_log_pkg.Log_Msg
347: ( v_object_id => p_record.task_id
348: , v_object_name => g_object_name
349: , v_message => 'Delete is not supported for this entity'
350: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
351: END IF;
352:
353: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
354: (

Line 363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

359:
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: ELSE
362: -- invalid dml type
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
364: jtm_message_log_pkg.Log_Msg
365: ( v_object_id => p_record.task_id
366: , v_object_name => g_object_name
367: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

Line 368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

364: jtm_message_log_pkg.Log_Msg
365: ( v_object_id => p_record.task_id
366: , v_object_name => g_object_name
367: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
369: END IF;
370:
371: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
372: (

Line 382: l_access_id := jtm_hook_util_pkg.get_acc_id(

378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
382: l_access_id := jtm_hook_util_pkg.get_acc_id(
383: p_acc_table_name => 'CSL_JTF_TASKS_ACC',
384: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
385: p_pk1_name => 'TASK_ID',
386: p_pk1_num_value => p_record.TASK_ID

Line 384: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),

380:
381: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
382: l_access_id := jtm_hook_util_pkg.get_acc_id(
383: p_acc_table_name => 'CSL_JTF_TASKS_ACC',
384: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
385: p_pk1_name => 'TASK_ID',
386: p_pk1_num_value => p_record.TASK_ID
387: );
388: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(

Line 391: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),

387: );
388: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(
389: P_PUB_ITEM => g_pub_name,
390: P_ACCESSID => l_access_id,
391: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
392: P_DML => 'U',
393: P_TIMESTAMP => sysdate
394: );
395: END IF;

Line 397: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

393: P_TIMESTAMP => sysdate
394: );
395: END IF;
396:
397: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
398: jtm_message_log_pkg.Log_Msg
399: ( v_object_id => p_record.task_id
400: , v_object_name => g_object_name
401: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'

Line 402: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

398: jtm_message_log_pkg.Log_Msg
399: ( v_object_id => p_record.task_id
400: , v_object_name => g_object_name
401: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'
402: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
403: END IF;
404: EXCEPTION WHEN OTHERS THEN
405: /*** defer record when any process exception occurs ***/
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

402: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
403: END IF;
404: EXCEPTION WHEN OTHERS THEN
405: /*** defer record when any process exception occurs ***/
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
407: jtm_message_log_pkg.Log_Msg
408: ( v_object_id => p_record.task_id
409: , v_object_name => g_object_name
410: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

Line 411: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

407: jtm_message_log_pkg.Log_Msg
408: ( v_object_id => p_record.task_id
409: , v_object_name => g_object_name
410: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
411: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
412: END IF;
413:
414: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
415: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

416: (
417: p_api_error => TRUE
418: );
419:
420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.task_id
423: , v_object_name => g_object_name
424: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'

Line 425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.task_id
423: , v_object_name => g_object_name
424: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'
425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
426: END IF;
427:
428: x_return_status := FND_API.G_RET_STS_ERROR;
429: END APPLY_RECORD;

Line 451: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

447: BEGIN
448: g_debug_level := p_debug_level;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
452: jtm_message_log_pkg.Log_Msg
453: ( v_object_id => null
454: , v_object_name => g_object_name
455: , v_message => 'Entering CSL_TASKS_PKG.Apply_Client_Changes'

Line 456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

452: jtm_message_log_pkg.Log_Msg
453: ( v_object_id => null
454: , v_object_name => g_object_name
455: , v_message => 'Entering CSL_TASKS_PKG.Apply_Client_Changes'
456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
457: END IF;
458:
459: /*** loop through task records in inqueue ***/
460: FOR r_task IN c_task( p_user_name, p_tranid) LOOP

Line 475: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

471:
472: /*** was record processed successfully? ***/
473: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
474: /*** Yes -> delete record from inqueue ***/
475: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
476: jtm_message_log_pkg.Log_Msg
477: ( v_object_id => r_task.task_id
478: , v_object_name => g_object_name
479: , v_message => 'Record successfully processed, deleting from inqueue'

Line 480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

476: jtm_message_log_pkg.Log_Msg
477: ( v_object_id => r_task.task_id
478: , v_object_name => g_object_name
479: , v_message => 'Record successfully processed, deleting from inqueue'
480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
481: END IF;
482:
483: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
484: (

Line 498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

494:
495: /*** was delete successful? ***/
496: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
497: /*** no -> rollback ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_task.task_id
501: , v_object_name => g_object_name
502: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

Line 503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_task.task_id
501: , v_object_name => g_object_name
502: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
504: END IF;
505: ROLLBACK TO save_rec;
506: END IF;
507: END IF;

Line 511: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

507: END IF;
508:
509: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
510: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
511: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
512: jtm_message_log_pkg.Log_Msg
513: ( v_object_id => r_task.task_id
514: , v_object_name => g_object_name
515: , v_message => 'Record not processed successfully, deferring and rejecting record'

Line 516: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

512: jtm_message_log_pkg.Log_Msg
513: ( v_object_id => r_task.task_id
514: , v_object_name => g_object_name
515: , v_message => 'Record not processed successfully, deferring and rejecting record'
516: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
517: END IF;
518:
519: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
520: (

Line 535: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

531:
532: /*** Was defer successful? ***/
533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** no -> rollback ***/
535: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
536: jtm_message_log_pkg.Log_Msg
537: ( v_object_id => r_task.task_id
538: , v_object_name => g_object_name
539: , v_message => 'Defer record failed, rolling back to savepoint'

Line 540: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

536: jtm_message_log_pkg.Log_Msg
537: ( v_object_id => r_task.task_id
538: , v_object_name => g_object_name
539: , v_message => 'Defer record failed, rolling back to savepoint'
540: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
541: END IF;
542: ROLLBACK TO save_rec;
543: END IF;
544: END IF;

Line 548: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

544: END IF;
545:
546: END LOOP;
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 => null
551: , v_object_name => g_object_name
552: , v_message => 'Leaving CSL_TASKS_PKG.Apply_Client_Changes'

Line 553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => null
551: , v_object_name => g_object_name
552: , v_message => 'Leaving CSL_TASKS_PKG.Apply_Client_Changes'
553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
554: END IF;
555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** catch and log exceptions ***/

Line 558: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

554: END IF;
555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** catch and log exceptions ***/
558: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
559: jtm_message_log_pkg.Log_Msg
560: ( v_object_id => null
561: , v_object_name => g_object_name
562: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

Line 563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

559: jtm_message_log_pkg.Log_Msg
560: ( v_object_id => null
561: , v_object_name => g_object_name
562: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
564: END IF;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: END APPLY_CLIENT_CHANGES;
567: