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 FND_API

Line 61: p_init_msg_list => FND_API.G_TRUE,

57:
58: -- Create a Task Assignment
59: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
60: p_api_version => 1.0,
61: p_init_msg_list => FND_API.G_TRUE,
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',

Line 62: p_commit => FND_API.G_FALSE,

58: -- Create a Task Assignment
59: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
60: p_api_version => 1.0,
61: p_init_msg_list => FND_API.G_TRUE,
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),

Line 74: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

70: x_msg_data => l_msg_data,
71: x_task_assignment_id => l_task_assignment_id
72: );
73:
74: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
75: /*** exception occurred in API -> return errmsg ***/
76: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
77: (
78: p_api_error => TRUE

Line 100: x_return_status := FND_API.G_RET_STS_ERROR;

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.
102: END IF;
103:
104: l_assignment_obj_version_nr := r_task_assignment.object_version_number;

Line 112: , p_init_msg_list => FND_API.G_TRUE

108:
109:
110: csf_task_assignments_pub.update_assignment_status
111: ( p_api_version => 1.0
112: , p_init_msg_list => FND_API.G_TRUE
113: , p_commit => FND_API.G_FALSE
114: , x_return_status => x_return_status
115: , x_msg_count => l_msg_count
116: , x_msg_data => l_msg_data

Line 113: , p_commit => FND_API.G_FALSE

109:
110: csf_task_assignments_pub.update_assignment_status
111: ( p_api_version => 1.0
112: , p_init_msg_list => FND_API.G_TRUE
113: , p_commit => FND_API.G_FALSE
114: , x_return_status => x_return_status
115: , x_msg_count => l_msg_count
116: , x_msg_data => l_msg_data
117: , p_task_assignment_id => p_record.task_assignment_id

Line 125: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

121: , x_task_object_version_number => l_task_obj_version_nr
122: , x_task_status_id => l_task_status_id
123: );
124:
125: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
126: /*** exception occurred in API -> return errmsg ***/
127: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
128: (
129: p_api_error => TRUE

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

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;
174:
175: /***
176: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
227:
228: -- Check for Stale data
229: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
230: if l_profile_value = 'SERVER_WINS' AND

Line 231: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE

227:
228: -- Check for Stale data
229: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
230: if l_profile_value = 'SERVER_WINS' AND
231: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE
232: then
233: open c_last_update_date(b_task_assignment_id => p_record.task_assignment_id);
234: fetch c_last_update_date into r_last_update_date;
235: if c_last_update_date%found then

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
261: end if;
262: else
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

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.
293: END IF;
294:
295: l_assignment_obj_version_nr := r_task_assignment.object_version_number;

Line 312: , p_resource_territory_id => FND_API.G_MISS_NUM

308: , p_object_version_number => l_assignment_obj_version_nr
309: , p_task_id => p_record.task_id
310: , p_resource_type_code => p_record.resource_type_code
311: , p_resource_id => p_record.resource_id
312: , p_resource_territory_id => FND_API.G_MISS_NUM
313: , p_actual_start_date => p_record.actual_start_date
314: , p_actual_end_date => p_record.actual_end_date
315: , p_sched_travel_distance => p_record.sched_travel_distance
316: , p_sched_travel_duration => p_record.sched_travel_duration

Line 318: , p_shift_construct_id => FND_API.G_MISS_NUM

314: , p_actual_end_date => p_record.actual_end_date
315: , p_sched_travel_distance => p_record.sched_travel_distance
316: , p_sched_travel_duration => p_record.sched_travel_duration
317: , p_sched_travel_duration_uom => p_record.sched_travel_duration_uom
318: , p_shift_construct_id => FND_API.G_MISS_NUM
319: , p_attribute1 => p_record.attribute1
320: , p_attribute2 => p_record.attribute2
321: , p_attribute3 => p_record.attribute3
322: , p_attribute4 => p_record.attribute4

Line 340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

336: , x_msg_count => l_msg_count
337: , x_msg_data => l_msg_data
338: );
339:
340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: /*** exception occurred in API -> return errmsg ***/
342: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
343: (
344: p_api_error => TRUE

Line 372: , p_init_msg_list => FND_API.G_TRUE

368: -- steps is valid.
369:
370: csf_task_assignments_pub.update_assignment_status
371: ( p_api_version => 1.0
372: , p_init_msg_list => FND_API.G_TRUE
373: , p_commit => FND_API.G_FALSE
374: , x_return_status => x_return_status
375: , x_msg_count => l_msg_count
376: , x_msg_data => l_msg_data

Line 373: , p_commit => FND_API.G_FALSE

369:
370: csf_task_assignments_pub.update_assignment_status
371: ( p_api_version => 1.0
372: , p_init_msg_list => FND_API.G_TRUE
373: , p_commit => FND_API.G_FALSE
374: , x_return_status => x_return_status
375: , x_msg_count => l_msg_count
376: , x_msg_data => l_msg_data
377: , p_task_assignment_id => p_record.task_assignment_id

Line 384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

380: , p_update_task => 'T'
381: , x_task_object_version_number => l_task_obj_version_nr
382: , x_task_status_id => l_task_status_id
383: );
384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** exception occurred in API -> return errmsg ***/
386: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
387: (
388: p_api_error => TRUE

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

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;
434:
435: /***
436: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

444: l_rc BOOLEAN;
445: l_access_id NUMBER;
446: BEGIN
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

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: , p_token_name1 => 'DML'
498: , p_token_value1 => p_record.dmltype$$
499: );
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

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: , p_token_name1 => 'DML'
516: , p_token_value1 => p_record.dmltype$$
517: );
518:
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: END IF;
521:
522:
523: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 523: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

519: x_return_status := FND_API.G_RET_STS_ERROR;
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',

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

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;
572:
573: /***
574: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CSL_JTF_TASK_ASSIGNMENTS

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: l_header_id NUMBER := NULL;
625:
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

Line 659: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

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:
661: -- ER 3218717 Check if there are any Debrief Line records
662: OPEN c_chk_debrief_lines (r_task_ass.task_assignment_id);
663: FETCH c_chk_debrief_lines INTO l_dbl_count;

Line 705: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

701: l_process_status
702: );
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

Line 718: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

714: ROLLBACK TO save_rec;
715: END IF;
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

Line 742: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

738: , r_task_ass.dmltype$$
739: );
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

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780: IF c_chk_task_status%ISOPEN THEN
781: CLOSE c_chk_task_status;
782: END IF;
783:
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: END APPLY_CLIENT_CHANGES;
786:
787:
788: /* New for Scottish Water Bug */