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.CSM_TASKS_PKG dependencies on FND_API

Line 164: p_init_msg_list => fnd_api.g_true,

160: l_task_attribute_rec.task_priority_id := l_task_priority;
161:
162: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource
163: (p_api_version => 1.0,
164: p_init_msg_list => fnd_api.g_true,
165: p_commit => fnd_api.g_false,
166: p_incident_id => p_record.source_object_id,
167: p_service_request_rec => l_service_request_rec,
168: p_task_attribute_rec => l_task_attribute_rec,

Line 165: p_commit => fnd_api.g_false,

161:
162: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource
163: (p_api_version => 1.0,
164: p_init_msg_list => fnd_api.g_true,
165: p_commit => fnd_api.g_false,
166: p_incident_id => p_record.source_object_id,
167: p_service_request_rec => l_service_request_rec,
168: p_task_attribute_rec => l_task_attribute_rec,
169: x_owner_group_id => l_owner_group_id,

Line 179: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

175: x_msg_count => l_msg_count,
176: x_msg_data => l_msg_data
177: );
178:
179: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
180: IF l_owner_id IS NULL THEN
181: l_owner_type := l_group_type;
182: l_owner_id := l_owner_group_id;
183: END IF;

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: l_owner_type := l_group_type;
182: l_owner_id := l_owner_group_id;
183: END IF;
184: ELSE
185: x_return_status := FND_API.G_RET_STS_ERROR;
186:
187: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
188: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
189: || ' for PK ' || p_record.TASK_ID || l_msg_data,

Line 207: p_init_msg_list => fnd_api.g_true,

203:
204: -- Create new Task
205: jtf_tasks_pub.Create_Task
206: ( p_api_version => 1.0,
207: p_init_msg_list => fnd_api.g_true,
208: p_commit => fnd_api.g_false,
209: p_task_id => p_record.task_id,
210: p_task_name => p_record.task_name,
211: p_task_type_id => l_task_type,

Line 208: p_commit => fnd_api.g_false,

204: -- Create new Task
205: jtf_tasks_pub.Create_Task
206: ( p_api_version => 1.0,
207: p_init_msg_list => fnd_api.g_true,
208: p_commit => fnd_api.g_false,
209: p_task_id => p_record.task_id,
210: p_task_name => p_record.task_name,
211: p_task_type_id => l_task_type,
212: p_description => p_record.description,

Line 257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

253: p_location_id => l_location_id,
254: p_cust_account_id => p_record.cust_account_id
255: );
256:
257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
258: THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260:
261: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: );
256:
257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
258: THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260:
261: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
262: || ' ROOT ERROR: jtf_tasks_pub.Create_Task'
263: || ' for PK ' || p_record.TASK_ID,

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: RETURN ;
267: END IF;
268:
269: -- success
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: EXCEPTION
273: WHEN others THEN
274: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: || ' for PK ' || p_record.task_id,
276: g_object_name || '.APPLY_INSERT',
277: FND_LOG.LEVEL_EXCEPTION );
278:
279: x_return_status := FND_API.G_RET_STS_ERROR;
280:
281: END APPLY_INSERT;
282:
283:

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

321: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
322: l_user_id := asg_base.get_user_id(p_record.clid$$cs);
323:
324: IF l_profile_value = 'SERVER_WINS' AND
325: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE
326: THEN
327: OPEN c_last_update_date(b_task_id => p_record.task_id);
328: FETCH c_last_update_date INTO r_last_update_date;
329:

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338: ( 'JTM'
339: , 'JTM_STALE_DATA'
340: );
341: fnd_msg_pub.add;
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: RETURN;
344: END IF;
345: ELSE
346: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_INSERT:',

Line 380: p_init_msg_list => FND_API.G_TRUE,

376:
377: -- Update the task.
378: JTF_TASKS_PUB.Update_Task (
379: p_api_version => 1.0,
380: p_init_msg_list => FND_API.G_TRUE,
381: p_commit => FND_API.G_FALSE,
382: p_task_id => p_record.TASK_ID,
383: p_task_name => p_record.TASK_NAME,
384: p_description => p_record.description,

Line 381: p_commit => FND_API.G_FALSE,

377: -- Update the task.
378: JTF_TASKS_PUB.Update_Task (
379: p_api_version => 1.0,
380: p_init_msg_list => FND_API.G_TRUE,
381: p_commit => FND_API.G_FALSE,
382: p_task_id => p_record.TASK_ID,
383: p_task_name => p_record.TASK_NAME,
384: p_description => p_record.description,
385: p_object_version_number => r_task.object_version_number,

Line 418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

414: p_cust_account_id => p_record.cust_account_id,
415: p_task_priority_id => p_record.task_priority_id
416: );
417:
418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
419: THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421:
422: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

416: );
417:
418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
419: THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421:
422: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
423: || ' ROOT ERROR: jtf_tasks_pub.UPDATE_TASK'
424: || ' for PK ' || p_record.TASK_ID,

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: RETURN ;
428: END IF;
429:
430: -- success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: EXCEPTION
434: WHEN others THEN
435: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: || ' for PK ' || p_record.task_id,
437: g_object_name || '.APPLY_UPDATE',
438: FND_LOG.LEVEL_EXCEPTION );
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: END APPLY_UPDATE;
443:
444:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: ) IS
456: BEGIN
457:
458: /*** initialize return status and message list ***/
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460: FND_MSG_PUB.INITIALIZE;
461:
462:
463: IF p_record.dmltype$$='I' THEN

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: , p_token_name1 => 'DML'
493: , p_token_value1 => p_record.dmltype$$
494: );
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: END IF;
498:
499: EXCEPTION
500: WHEN OTHERS THEN

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510: (
511: p_api_error => TRUE
512: );
513:
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: END APPLY_RECORD;
517:
518:

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
538: g_object_name || '.APPLY_CLIENT_CHANGES',
539: FND_LOG.LEVEL_PROCEDURE);
540: g_debug_level := p_debug_level;
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: /*** loop through tasks records in inqueue ***/
544: FOR r_tasks IN c_tasks_inq( p_user_name, p_tranid) LOOP
545:

Line 558: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

554: , l_reject_row --Bug 5288413
555: );
556:
557: /*** was record processed successfully? ***/
558: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
559: /*** If Yes -> delete record from inqueue ***/
560: --Bug 5288413
561: IF l_reject_row THEN
562: CSM_UTIL_PKG.REJECT_RECORD

Line 575: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

571: l_return_status
572: );
573:
574: --Bug 8931803 - Asg REJECT_ROW doesn't call delete_row on reapply as the record was deferred.
575: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
576: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_tasks.seqno$$)=FND_API.G_TRUE) THEN
577: CSM_UTIL_PKG.DELETE_RECORD
578: (
579: p_user_name,

Line 576: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_tasks.seqno$$)=FND_API.G_TRUE) THEN

572: );
573:
574: --Bug 8931803 - Asg REJECT_ROW doesn't call delete_row on reapply as the record was deferred.
575: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
576: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_tasks.seqno$$)=FND_API.G_TRUE) THEN
577: CSM_UTIL_PKG.DELETE_RECORD
578: (
579: p_user_name,
580: p_tranid,

Line 603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

599: l_return_status --Introduced new variable l_return_status since Defer
600: ); --process doesn't depend on this delete_record API
601: END IF;
602: /*** was delete/reject successful? ***/
603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: /*** If No -> rollback ***/
605: CSM_UTIL_PKG.LOG
606: ( 'Deleting from inqueue failed, rolling back to savepoint'
607: || ' for PK ' || r_tasks.task_id ,

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607: || ' for PK ' || r_tasks.task_id ,
608: g_object_name || '.APPLY_CLIENT_CHANGES',
609: FND_LOG.LEVEL_ERROR); -- put PK column here
610: ROLLBACK TO save_rec;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: END IF;
613: END IF;
614:
615: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 615: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

611: x_return_status := FND_API.G_RET_STS_ERROR;
612: END IF;
613: END IF;
614:
615: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
616: /*** Record was not processed successfully or delete failed
617: -> defer and reject record ***/
618: CSM_UTIL_PKG.LOG
619: ( 'Record not processed successfully, deferring and rejecting record'

Line 637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

633: , r_tasks.dmltype$$
634: );
635:
636: /*** Was defer successful? ***/
637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
638: /*** no -> rollback ***/
639: CSM_UTIL_PKG.LOG
640: ( 'Defer record failed, rolling back to savepoint'
641: || ' for PK ' || r_tasks.task_id ,

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641: || ' for PK ' || r_tasks.task_id ,
642: g_object_name || '.APPLY_CLIENT_CHANGES',
643: FND_LOG.LEVEL_ERROR); -- put PK column here
644: ROLLBACK TO save_rec;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647: END IF;
648:
649: END LOOP;

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: CSM_UTIL_PKG.LOG
654: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
655: g_object_name || '.APPLY_CLIENT_CHANGES',
656: FND_LOG.LEVEL_EXCEPTION);
657: x_return_status := FND_API.G_RET_STS_ERROR;
658:
659: END APPLY_CLIENT_CHANGES;
660:
661: END CSM_TASKS_PKG; -- Package spec