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.

[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on FND_API

Line 64: p_init_msg_list => FND_API.G_TRUE,

60:
61: -- Create a Task Assignment
62: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
63: p_api_version => 1.0,
64: p_init_msg_list => FND_API.G_TRUE,
65: p_commit => FND_API.G_FALSE,
66: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,
67: p_task_id => p_record.TASK_ID,
68: p_resource_type_code => 'RS_EMPLOYEE',

Line 65: p_commit => FND_API.G_FALSE,

61: -- Create a Task Assignment
62: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
63: p_api_version => 1.0,
64: p_init_msg_list => FND_API.G_TRUE,
65: p_commit => FND_API.G_FALSE,
66: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,
67: p_task_id => p_record.TASK_ID,
68: p_resource_type_code => 'RS_EMPLOYEE',
69: p_resource_id => p_record.resource_id,

Line 93: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

89: x_msg_count => l_msg_count,
90: x_msg_data => l_msg_data,
91: x_task_assignment_id => l_task_assignment_id
92: );
93: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
94: THEN
95:
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: );
93: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
94: THEN
95:
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
98: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
99: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
100: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

Line 112: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

108: FETCH c_task_assignment INTO l_ovn;
109: CLOSE c_task_assignment;
110:
111: -- Synchronize Task Assignment and Task statuses
112: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
113:
114: csf_task_assignments_pub.update_assignment_status
115: ( p_api_version => 1.0
116: , p_init_msg_list => FND_API.G_TRUE

Line 116: , p_init_msg_list => FND_API.G_TRUE

112: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
113:
114: csf_task_assignments_pub.update_assignment_status
115: ( p_api_version => 1.0
116: , p_init_msg_list => FND_API.G_TRUE
117: , p_commit => FND_API.G_FALSE
118: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
119: , x_return_status => x_return_status
120: , x_msg_count => l_msg_count

Line 117: , p_commit => FND_API.G_FALSE

113:
114: csf_task_assignments_pub.update_assignment_status
115: ( p_api_version => 1.0
116: , p_init_msg_list => FND_API.G_TRUE
117: , p_commit => FND_API.G_FALSE
118: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
119: , x_return_status => x_return_status
120: , x_msg_count => l_msg_count
121: , x_msg_data => l_msg_data

Line 118: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

114: csf_task_assignments_pub.update_assignment_status
115: ( p_api_version => 1.0
116: , p_init_msg_list => FND_API.G_TRUE
117: , p_commit => FND_API.G_FALSE
118: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
119: , x_return_status => x_return_status
120: , x_msg_count => l_msg_count
121: , x_msg_data => l_msg_data
122: , p_task_assignment_id => p_record.task_assignment_id

Line 130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

126: , x_task_object_version_number => l_task_object_version_number
127: , x_task_status_id => l_task_status_id
128: );
129: END IF;
130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
131: THEN
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: END IF;
130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
131: THEN
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
135: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
136: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
137: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: END IF;
140:
141:
142: -- success
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: EXCEPTION WHEN OTHERS THEN
146: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
147: FND_LOG.LEVEL_EXCEPTION );

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: EXCEPTION WHEN OTHERS THEN
146: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
147: FND_LOG.LEVEL_EXCEPTION );
148:
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END APPLY_INSERT;
151:
152: /***
153: This procedure is called by APPLY_CRECORD when

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

196: --check for the stale data
197: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
198: -- SERVER_WINS profile value
199: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS AND
200: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE)
201: THEN
202: IF(r_task_assignment.last_update_date <> p_record.server_last_update_date AND r_task_assignment.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
203: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
204: || p_record.task_assignment_id;

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: THEN
202: IF(r_task_assignment.last_update_date <> p_record.server_last_update_date AND r_task_assignment.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
203: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
204: || p_record.task_assignment_id;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: csm_util_pkg.log(p_error_msg,
207: g_object_name || '.APPLY_UPDATE',
208: FND_LOG.LEVEL_ERROR);
209: RETURN;

Line 223: , p_init_msg_list => FND_API.G_TRUE

219: -- step is not sent to CRM, the API will see A -> C and refuse it.
220: -- To allow for A -> C no validation is done.
221: csf_task_assignments_pub.update_assignment_status
222: ( p_api_version => 1.0
223: , p_init_msg_list => FND_API.G_TRUE
224: , p_commit => FND_API.G_FALSE
225: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
226: , x_return_status => x_return_status
227: , x_msg_count => l_msg_count

Line 224: , p_commit => FND_API.G_FALSE

220: -- To allow for A -> C no validation is done.
221: csf_task_assignments_pub.update_assignment_status
222: ( p_api_version => 1.0
223: , p_init_msg_list => FND_API.G_TRUE
224: , p_commit => FND_API.G_FALSE
225: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
226: , x_return_status => x_return_status
227: , x_msg_count => l_msg_count
228: , x_msg_data => l_msg_data

Line 225: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

221: csf_task_assignments_pub.update_assignment_status
222: ( p_api_version => 1.0
223: , p_init_msg_list => FND_API.G_TRUE
224: , p_commit => FND_API.G_FALSE
225: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
226: , x_return_status => x_return_status
227: , x_msg_count => l_msg_count
228: , x_msg_data => l_msg_data
229: , p_task_assignment_id => p_record.task_assignment_id

Line 236: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

232: , p_update_task => 'T'
233: , x_task_object_version_number => l_task_object_version_number
234: , x_task_status_id => l_task_status_id
235: );
236: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
237: THEN
238:
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: );
236: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
237: THEN
238:
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
241: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
242: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
243: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line 253: , p_init_msg_list => FND_API.G_TRUE

249: -- doesn't support the actual times and the csf_tasks_pub.Update_Task_Assignment doen't
250: -- support the validation level set to none.
251: csf_task_assignments_pub.Update_Task_Assignment
252: ( p_api_version => 1.0
253: , p_init_msg_list => FND_API.G_TRUE
254: , p_commit => FND_API.G_FALSE
255: , p_task_assignment_id => p_record.task_assignment_id
256: , p_object_version_number => l_ovn
257: , p_task_id => p_record.task_id

Line 254: , p_commit => FND_API.G_FALSE

250: -- support the validation level set to none.
251: csf_task_assignments_pub.Update_Task_Assignment
252: ( p_api_version => 1.0
253: , p_init_msg_list => FND_API.G_TRUE
254: , p_commit => FND_API.G_FALSE
255: , p_task_assignment_id => p_record.task_assignment_id
256: , p_object_version_number => l_ovn
257: , p_task_id => p_record.task_id
258: , p_resource_type_code => FND_API.G_MISS_CHAR

Line 258: , p_resource_type_code => FND_API.G_MISS_CHAR

254: , p_commit => FND_API.G_FALSE
255: , p_task_assignment_id => p_record.task_assignment_id
256: , p_object_version_number => l_ovn
257: , p_task_id => p_record.task_id
258: , p_resource_type_code => FND_API.G_MISS_CHAR
259: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
260: , p_resource_territory_id => FND_API.G_MISS_NUM
261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date

Line 259: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id

255: , p_task_assignment_id => p_record.task_assignment_id
256: , p_object_version_number => l_ovn
257: , p_task_id => p_record.task_id
258: , p_resource_type_code => FND_API.G_MISS_CHAR
259: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
260: , p_resource_territory_id => FND_API.G_MISS_NUM
261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date

Line 260: , p_resource_territory_id => FND_API.G_MISS_NUM

256: , p_object_version_number => l_ovn
257: , p_task_id => p_record.task_id
258: , p_resource_type_code => FND_API.G_MISS_CHAR
259: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
260: , p_resource_territory_id => FND_API.G_MISS_NUM
261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM

Line 261: , p_assignment_status_id => FND_API.G_MISS_NUM

257: , p_task_id => p_record.task_id
258: , p_resource_type_code => FND_API.G_MISS_CHAR
259: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
260: , p_resource_territory_id => FND_API.G_MISS_NUM
261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM

Line 264: , p_sched_travel_distance => FND_API.G_MISS_NUM

260: , p_resource_territory_id => FND_API.G_MISS_NUM
261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM
266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
267: , p_shift_construct_id => FND_API.G_MISS_NUM
268: , p_object_capacity_id => FND_API.G_MISS_NUM

Line 265: , p_sched_travel_duration => FND_API.G_MISS_NUM

261: , p_assignment_status_id => FND_API.G_MISS_NUM
262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM
266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
267: , p_shift_construct_id => FND_API.G_MISS_NUM
268: , p_object_capacity_id => FND_API.G_MISS_NUM
269: , p_attribute1 => p_record.attribute1

Line 266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR

262: , p_actual_start_date => p_record.actual_start_date
263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM
266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
267: , p_shift_construct_id => FND_API.G_MISS_NUM
268: , p_object_capacity_id => FND_API.G_MISS_NUM
269: , p_attribute1 => p_record.attribute1
270: , p_attribute2 => p_record.attribute2

Line 267: , p_shift_construct_id => FND_API.G_MISS_NUM

263: , p_actual_end_date => p_record.actual_end_date
264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM
266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
267: , p_shift_construct_id => FND_API.G_MISS_NUM
268: , p_object_capacity_id => FND_API.G_MISS_NUM
269: , p_attribute1 => p_record.attribute1
270: , p_attribute2 => p_record.attribute2
271: , p_attribute3 => p_record.attribute3

Line 268: , p_object_capacity_id => FND_API.G_MISS_NUM

264: , p_sched_travel_distance => FND_API.G_MISS_NUM
265: , p_sched_travel_duration => FND_API.G_MISS_NUM
266: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
267: , p_shift_construct_id => FND_API.G_MISS_NUM
268: , p_object_capacity_id => FND_API.G_MISS_NUM
269: , p_attribute1 => p_record.attribute1
270: , p_attribute2 => p_record.attribute2
271: , p_attribute3 => p_record.attribute3
272: , p_attribute4 => p_record.attribute4

Line 293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

289: , x_task_object_version_number => l_task_object_version_number
290: , x_task_status_id => l_task_status_id
291: );
292:
293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
294: THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:
297: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: );
292:
293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
294: THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:
297: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
298: || ' ROOT ERROR: csf_tasks_pub.Update_Task_Assignment'
299: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: RETURN ;
303: END IF;
304:
305: -- success
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: EXCEPTION
309: WHEN others THEN
310: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: || ' for PK ' || p_record.task_assignment_id,
312: g_object_name || '.APPLY_UPDATE',
313: FND_LOG.LEVEL_EXCEPTION );
314:
315: x_return_status := FND_API.G_RET_STS_ERROR;
316:
317: END APPLY_UPDATE;
318:
319:

Line 333: x_return_status := FND_API.G_RET_STS_SUCCESS;

329: ) IS
330: BEGIN
331:
332: /*** initialize return status and message list ***/
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334: FND_MSG_PUB.INITIALIZE;
335:
336:
337: IF p_record.dmltype$$='I' THEN

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: , p_token_name1 => 'DML'
366: , p_token_value1 => p_record.dmltype$$
367: );
368:
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: END IF;
371:
372: EXCEPTION WHEN OTHERS THEN
373: /*** defer record when any process exception occurs ***/

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: (
382: p_api_error => TRUE
383: );
384:
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: END APPLY_RECORD;
388:
389:

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
429: g_object_name || '.APPLY_CLIENT_CHANGES',
430: FND_LOG.LEVEL_PROCEDURE);
431: g_debug_level := p_debug_level;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: /*** loop through task assignments records in inqueue ***/
435: FOR r_task_assignments IN c_task_assignments_inq( p_user_name, p_tranid) LOOP
436:

Line 448: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

444: , l_process_status
445: );
446:
447: /*** was record processed successfully? ***/
448: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
449: -- if update to charges fail, then do not defer the record
450: BEGIN
451: OPEN c_chk_task_status (r_task_assignments.task_assignment_id);
452: FETCH c_chk_task_status INTO l_header_id, l_rejected_flag,

Line 484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

480: l_process_status
481: );
482:
483: /*** was delete successful? ***/
484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
485: /*** If No -> rollback ***/
486: CSM_UTIL_PKG.LOG
487: ( 'Deleting from inqueue failed, rolling back to savepoint'
488: || ' for PK ' || r_task_assignments.task_assignment_id ,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: || ' for PK ' || r_task_assignments.task_assignment_id ,
489: g_object_name || '.APPLY_CLIENT_CHANGES',
490: FND_LOG.LEVEL_ERROR); -- put PK column here
491: ROLLBACK TO save_rec;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:
496: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 496: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:
496: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
497: /*** Record was not processed successfully or delete failed
498: -> defer and reject record ***/
499: CSM_UTIL_PKG.LOG
500: ( 'Record not processed successfully, deferring and rejecting record'

Line 518: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

514: , 'U'
515: );
516:
517: /*** Was defer successful? ***/
518: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
519: /*** no -> rollback ***/
520: CSM_UTIL_PKG.LOG
521: ( 'Defer record failed, rolling back to savepoint'
522: || ' for PK ' || r_task_assignments.task_assignment_id ,

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: || ' for PK ' || r_task_assignments.task_assignment_id ,
523: g_object_name || '.APPLY_CLIENT_CHANGES',
524: FND_LOG.LEVEL_ERROR); -- put PK column here
525: ROLLBACK TO save_rec;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: END IF;
528: END IF;
529:
530: END LOOP;

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: /*** catch and log exceptions ***/
538: CSM_UTIL_PKG.LOG
539: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
540: g_object_name || '.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
541: x_return_status := FND_API.G_RET_STS_ERROR;
542:
543: END APPLY_CLIENT_CHANGES;
544:
545: FUNCTION CONFLICT_RESOLUTION_METHOD (p_user_name IN VARCHAR2,