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

Line 50: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

46: l_task_status_id NUMBER;
47: l_task_status_name VARCHAR2(30);
48:
49: BEGIN
50: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
51: jtm_message_log_pkg.Log_Msg
52: ( v_object_id => p_record.task_assignment_id
53: , v_object_name => g_object_name
54: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

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

51: jtm_message_log_pkg.Log_Msg
52: ( v_object_id => p_record.task_assignment_id
53: , v_object_name => g_object_name
54: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
55: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
56: END IF;
57:
58: -- Create a Task Assignment
59: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (

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

62: p_commit => FND_API.G_FALSE,
63: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,
64: p_task_id => p_record.TASK_ID,
65: p_resource_type_code => 'RS_EMPLOYEE',
66: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id(p_record.clid$$cs),
67: p_assignment_status_id => p_record.ASSIGNMENT_STATUS_ID,
68: x_return_status => x_return_status,
69: x_msg_count => l_msg_count,
70: x_msg_data => l_msg_data,

Line 92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

88: FETCH c_task_assignment
89: INTO r_task_assignment;
90: IF c_task_assignment%NOTFOUND THEN
91: CLOSE c_task_assignment;
92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
93: jtm_message_log_pkg.Log_Msg
94: ( v_object_id => p_record.task_assignment_id
95: , v_object_name => g_object_name
96: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

93: jtm_message_log_pkg.Log_Msg
94: ( v_object_id => p_record.task_assignment_id
95: , v_object_name => g_object_name
96: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
97: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
98: END IF;
99: -- Bail out.
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: RETURN; --TODO ADD error msg.

Line 131: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

127: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
128: (
129: p_api_error => TRUE
130: );
131: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
132: jtm_message_log_pkg.Log_Msg
133: ( v_object_id => p_record.task_assignment_id
134: , v_object_name => g_object_name
135: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

132: jtm_message_log_pkg.Log_Msg
133: ( v_object_id => p_record.task_assignment_id
134: , v_object_name => g_object_name
135: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
136: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
137: END IF;
138: RETURN;
139: END IF;
140:

Line 141: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

137: END IF;
138: RETURN;
139: END IF;
140:
141: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
142: jtm_message_log_pkg.Log_Msg
143: ( v_object_id => p_record.task_assignment_id
144: , v_object_name => g_object_name
145: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

142: jtm_message_log_pkg.Log_Msg
143: ( v_object_id => p_record.task_assignment_id
144: , v_object_name => g_object_name
145: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
146: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
147: END IF;
148:
149: EXCEPTION WHEN OTHERS THEN
150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

146: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
147: END IF;
148:
149: EXCEPTION WHEN OTHERS THEN
150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
151: jtm_message_log_pkg.Log_Msg
152: ( v_object_id => p_record.task_assignment_id
153: , v_object_name => g_object_name
154: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

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

151: jtm_message_log_pkg.Log_Msg
152: ( v_object_id => p_record.task_assignment_id
153: , v_object_name => g_object_name
154: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
155: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
156: END IF;
157:
158: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
159: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

160: (
161: p_api_error => TRUE
162: );
163:
164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
165: jtm_message_log_pkg.Log_Msg
166: ( v_object_id => p_record.task_assignment_id
167: , v_object_name => g_object_name
168: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

165: jtm_message_log_pkg.Log_Msg
166: ( v_object_id => p_record.task_assignment_id
167: , v_object_name => g_object_name
168: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
169: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
170: END IF;
171:
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: END APPLY_INSERT;

Line 217: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

213: l_profile_value VARCHAR2(240);
214: l_task_type_id NUMBER;
215:
216: BEGIN
217: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
218: jtm_message_log_pkg.Log_Msg
219: ( v_object_id => p_record.task_assignment_id
220: , v_object_name => g_object_name
221: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

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

218: jtm_message_log_pkg.Log_Msg
219: ( v_object_id => p_record.task_assignment_id
220: , v_object_name => g_object_name
221: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
222: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
223: END IF;
224:
225: -- Initialize API return status to success
226: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 238: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

234: fetch c_last_update_date into r_last_update_date;
235: if c_last_update_date%found then
236: if r_last_update_date.last_updated_by <> asg_base.get_user_id( p_record.clid$$cs ) AND r_last_update_date.last_update_date <> p_record.last_update_date then
237: close c_last_update_date;
238: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
239: jtm_message_log_pkg.Log_Msg
240: ( v_object_id => p_record.task_assignment_id
241: , v_object_name => g_object_name
242: , v_message => 'Record is stale data'

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

239: jtm_message_log_pkg.Log_Msg
240: ( v_object_id => p_record.task_assignment_id
241: , v_object_name => g_object_name
242: , v_message => 'Record is stale data'
243: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
244: END IF;
245: fnd_message.set_name
246: ( 'JTM'
247: , 'JTM_STALE_DATA'

Line 251: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

247: , 'JTM_STALE_DATA'
248: );
249: fnd_msg_pub.add;
250:
251: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
252: jtm_message_log_pkg.Log_Msg
253: ( v_object_id => p_record.task_assignment_id
254: , v_object_name => g_object_name
255: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

252: jtm_message_log_pkg.Log_Msg
253: ( v_object_id => p_record.task_assignment_id
254: , v_object_name => g_object_name
255: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
256: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
257: END IF;
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260: return;

Line 263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260: return;
261: end if;
262: else
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => p_record.task_assignment_id
266: , v_object_name => g_object_name
267: , v_message => 'No record found in Apps Database.'

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

264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => p_record.task_assignment_id
266: , v_object_name => g_object_name
267: , v_message => 'No record found in Apps Database.'
268: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
269: END IF;
270: end if;
271: close c_last_update_date;
272: end if;

Line 283: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

279: FETCH c_task_assignment
280: INTO r_task_assignment;
281: IF c_task_assignment%NOTFOUND THEN
282: CLOSE c_task_assignment;
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_assignment_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving ' || g_object_name || '.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_assignment_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
289: END IF;
290: -- Bail out.
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: RETURN; --TODO ADD error msg.

Line 346: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

342: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
343: (
344: p_api_error => TRUE
345: );
346: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
347: jtm_message_log_pkg.Log_Msg
348: ( v_object_id => p_record.task_assignment_id
349: , v_object_name => g_object_name
350: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

347: jtm_message_log_pkg.Log_Msg
348: ( v_object_id => p_record.task_assignment_id
349: , v_object_name => g_object_name
350: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
351: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
352: END IF;
353: RETURN;
354: END IF;
355:

Line 390: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

386: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
387: (
388: p_api_error => TRUE
389: );
390: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
391: jtm_message_log_pkg.Log_Msg
392: ( v_object_id => p_record.task_assignment_id
393: , v_object_name => g_object_name
394: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

391: jtm_message_log_pkg.Log_Msg
392: ( v_object_id => p_record.task_assignment_id
393: , v_object_name => g_object_name
394: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
395: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
396: END IF;
397: RETURN;
398: END IF;
399: END IF;

Line 401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

397: RETURN;
398: END IF;
399: END IF;
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
402: jtm_message_log_pkg.Log_Msg
403: ( v_object_id => p_record.task_assignment_id
404: , v_object_name => g_object_name
405: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

402: jtm_message_log_pkg.Log_Msg
403: ( v_object_id => p_record.task_assignment_id
404: , v_object_name => g_object_name
405: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
406: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
407: END IF;
408:
409: EXCEPTION WHEN OTHERS THEN
410: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 410: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

406: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
407: END IF;
408:
409: EXCEPTION WHEN OTHERS THEN
410: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
411: jtm_message_log_pkg.Log_Msg
412: ( v_object_id => p_record.task_assignment_id
413: , v_object_name => g_object_name
414: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

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

411: jtm_message_log_pkg.Log_Msg
412: ( v_object_id => p_record.task_assignment_id
413: , v_object_name => g_object_name
414: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
415: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
416: END IF;
417:
418: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
419: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 424: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

420: (
421: p_api_error => TRUE
422: );
423:
424: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
425: jtm_message_log_pkg.Log_Msg
426: ( v_object_id => p_record.task_assignment_id
427: , v_object_name => g_object_name
428: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

425: jtm_message_log_pkg.Log_Msg
426: ( v_object_id => p_record.task_assignment_id
427: , v_object_name => g_object_name
428: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
429: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
430: END IF;
431:
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: END APPLY_UPDATE;

Line 451: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

447: /*** initialize return status and message list ***/
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: FND_MSG_PUB.INITIALIZE;
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 => p_record.task_assignment_id
454: , v_object_name => g_object_name
455: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

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

452: jtm_message_log_pkg.Log_Msg
453: ( v_object_id => p_record.task_assignment_id
454: , v_object_name => g_object_name
455: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
457: END IF;
458:
459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
460: jtm_message_log_pkg.Log_Msg

Line 459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

455: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
457: END IF;
458:
459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
460: jtm_message_log_pkg.Log_Msg
461: ( v_object_id => p_record.task_assignment_id
462: , v_object_name => g_object_name
463: , v_message => 'Processing TASK_ASSIGNMENT_ID = ' || p_record.task_assignment_id || fnd_global.local_chr(10) ||

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

461: ( v_object_id => p_record.task_assignment_id
462: , v_object_name => g_object_name
463: , v_message => 'Processing TASK_ASSIGNMENT_ID = ' || p_record.task_assignment_id || fnd_global.local_chr(10) ||
464: 'DMLTYPE = ' || p_record.dmltype$$
465: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
466: END IF;
467:
468: IF p_record.dmltype$$='I' THEN
469: -- Process insert

Line 486: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

482: x_return_status
483: );
484: ELSIF p_record.dmltype$$='D' THEN
485: -- Process delete; not supported for this entity
486: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
487: jtm_message_log_pkg.Log_Msg
488: ( v_object_id => p_record.task_assignment_id
489: , v_object_name => g_object_name
490: , v_message => 'Delete is not supported for this entity'

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

487: jtm_message_log_pkg.Log_Msg
488: ( v_object_id => p_record.task_assignment_id
489: , v_object_name => g_object_name
490: , v_message => 'Delete is not supported for this entity'
491: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
492: END IF;
493:
494: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
495: (

Line 504: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: ELSE
503: -- invalid dml type
504: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
505: jtm_message_log_pkg.Log_Msg
506: ( v_object_id => p_record.task_assignment_id
507: , v_object_name => g_object_name
508: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

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

505: jtm_message_log_pkg.Log_Msg
506: ( v_object_id => p_record.task_assignment_id
507: , v_object_name => g_object_name
508: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
509: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
510: END IF;
511:
512: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
513: (

Line 524: l_access_id := jtm_hook_util_pkg.get_acc_id(

520: END IF;
521:
522:
523: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
524: l_access_id := jtm_hook_util_pkg.get_acc_id(
525: p_acc_table_name => 'CSL_JTF_TASK_ASS_ACC',
526: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
527: p_pk1_name => 'TASK_ASSIGNMENT_ID',
528: p_pk1_num_value => p_record.TASK_ASSIGNMENT_ID

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

522:
523: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
524: l_access_id := jtm_hook_util_pkg.get_acc_id(
525: p_acc_table_name => 'CSL_JTF_TASK_ASS_ACC',
526: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
527: p_pk1_name => 'TASK_ASSIGNMENT_ID',
528: p_pk1_num_value => p_record.TASK_ASSIGNMENT_ID
529: );
530: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(

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

529: );
530: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(
531: P_PUB_ITEM => g_pub_name,
532: P_ACCESSID => l_access_id,
533: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
534: P_DML => 'U',
535: P_TIMESTAMP => sysdate
536: );
537: END IF;

Line 539: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

535: P_TIMESTAMP => sysdate
536: );
537: END IF;
538:
539: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
540: jtm_message_log_pkg.Log_Msg
541: ( v_object_id => p_record.task_assignment_id
542: , v_object_name => g_object_name
543: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

540: jtm_message_log_pkg.Log_Msg
541: ( v_object_id => p_record.task_assignment_id
542: , v_object_name => g_object_name
543: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
544: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
545: END IF;
546: EXCEPTION WHEN OTHERS THEN
547: /*** defer record when any process exception occurs ***/
548: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 548: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

544: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
545: END IF;
546: EXCEPTION WHEN OTHERS THEN
547: /*** defer record when any process exception occurs ***/
548: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => p_record.task_assignment_id
551: , v_object_name => g_object_name
552: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => p_record.task_assignment_id
551: , v_object_name => g_object_name
552: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
554: END IF;
555:
556: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
557: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

558: (
559: p_api_error => TRUE
560: );
561:
562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
563: jtm_message_log_pkg.Log_Msg
564: ( v_object_id => p_record.task_assignment_id
565: , v_object_name => g_object_name
566: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

563: jtm_message_log_pkg.Log_Msg
564: ( v_object_id => p_record.task_assignment_id
565: , v_object_name => g_object_name
566: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
567: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
568: END IF;
569:
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: END APPLY_RECORD;

Line 630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

626: BEGIN
627: g_debug_level := p_debug_level;
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
631: jtm_message_log_pkg.Log_Msg
632: ( v_object_id => null
633: , v_object_name => g_object_name
634: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

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

631: jtm_message_log_pkg.Log_Msg
632: ( v_object_id => null
633: , v_object_name => g_object_name
634: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
635: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
636: END IF;
637:
638: /*** loop through CSL_JTF_TASK_ASSIGNMENTS records in inqueue ***/
639: FOR r_task_ass IN c_task_ass( p_user_name, p_tranid) LOOP

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

652: ( v_object_id => r_task_ass.task_assignment_id
653: , v_object_name => g_object_name
654: , v_message => 'l_error_msg = ' || l_error_msg || fnd_global.local_chr(10) ||
655: 'l_process_status = ' || l_process_status
656: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
657:
658: /*** was record processed successfully? ***/
659: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
660:

Line 684: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

680:
681: END IF;
682:
683: /*** Yes -> delete record from inqueue ***/
684: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => r_task_ass.task_assignment_id
687: , v_object_name => g_object_name
688: , v_message => 'Record successfully processed, deleting from inqueue'

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

685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => r_task_ass.task_assignment_id
687: , v_object_name => g_object_name
688: , v_message => 'Record successfully processed, deleting from inqueue'
689: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
690: END IF;
691:
692: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
693: (

Line 707: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

703:
704: /*** was delete successful? ***/
705: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
706: /*** no -> rollback ***/
707: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
708: jtm_message_log_pkg.Log_Msg
709: ( v_object_id => r_task_ass.task_assignment_id
710: , v_object_name => g_object_name
711: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

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

708: jtm_message_log_pkg.Log_Msg
709: ( v_object_id => r_task_ass.task_assignment_id
710: , v_object_name => g_object_name
711: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
712: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
713: END IF;
714: ROLLBACK TO save_rec;
715: END IF;
716: END IF;

Line 720: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

716: END IF;
717:
718: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
719: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
720: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
721: jtm_message_log_pkg.Log_Msg
722: ( v_object_id => r_task_ass.task_assignment_id
723: , v_object_name => g_object_name
724: , v_message => 'Record not processed successfully, deferring and rejecting record'

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

721: jtm_message_log_pkg.Log_Msg
722: ( v_object_id => r_task_ass.task_assignment_id
723: , v_object_name => g_object_name
724: , v_message => 'Record not processed successfully, deferring and rejecting record'
725: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
726: END IF;
727:
728: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
729: (

Line 744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

740:
741: /*** Was defer successful? ***/
742: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
743: /*** no -> rollback ***/
744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => r_task_ass.task_assignment_id
747: , v_object_name => g_object_name
748: , v_message => 'Defer record failed, rolling back to savepoint'

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

745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => r_task_ass.task_assignment_id
747: , v_object_name => g_object_name
748: , v_message => 'Defer record failed, rolling back to savepoint'
749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
750: END IF;
751: ROLLBACK TO save_rec;
752: END IF;
753: END IF;

Line 757: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

753: END IF;
754:
755: END LOOP;
756:
757: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
758: jtm_message_log_pkg.Log_Msg
759: ( v_object_id => null
760: , v_object_name => g_object_name
761: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

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

758: jtm_message_log_pkg.Log_Msg
759: ( v_object_id => null
760: , v_object_name => g_object_name
761: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
762: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
763: END IF;
764:
765: EXCEPTION WHEN OTHERS THEN
766: /*** catch and log exceptions ***/

Line 767: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

763: END IF;
764:
765: EXCEPTION WHEN OTHERS THEN
766: /*** catch and log exceptions ***/
767: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
768: jtm_message_log_pkg.Log_Msg
769: ( v_object_id => null
770: , v_object_name => g_object_name
771: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

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

768: jtm_message_log_pkg.Log_Msg
769: ( v_object_id => null
770: , v_object_name => g_object_name
771: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
772: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
773: END IF;
774:
775: -- ER 3218717
776: IF c_chk_debrief_lines%ISOPEN THEN

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

807: ( v_object_id => null
808: , v_object_name => g_object_name
809: , v_message => 'Entering Task Assignments CONFLICT_RESOLUTION_HANDLER : User '
810: ||p_user_name
811: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
812:
813: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
814:
815: OPEN get_user_id(p_tran_id,p_user_name) ;