DBA Data[Home] [Help]

APPS.CSM_TASKS_PKG dependencies on FND_API

Line 162: p_init_msg_list => fnd_api.g_true,

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

Line 163: p_commit => fnd_api.g_false,

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

Line 177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

173: x_msg_count => l_msg_count,
174: x_msg_data => l_msg_data
175: );
176:
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
178: THEN
179: x_return_status := FND_API.G_RET_STS_ERROR;
180:
181: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: );
176:
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
178: THEN
179: x_return_status := FND_API.G_RET_STS_ERROR;
180:
181: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
182: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
183: || ' for PK ' || p_record.TASK_ID || l_msg_data,

Line 205: p_init_msg_list => fnd_api.g_true,

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

Line 206: p_commit => fnd_api.g_false,

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

Line 255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 378: p_init_msg_list => FND_API.G_TRUE,

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

Line 379: p_commit => FND_API.G_FALSE,

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

Line 415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 456: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507: (
508: p_api_error => TRUE
509: );
510:
511: x_return_status := FND_API.G_RET_STS_ERROR;
512:
513: END APPLY_RECORD;
514:
515:

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 555: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

580: l_return_status --Introduced new variable l_return_status since Defer
581: ); --process doesn't depend on this delete_record API
582: END IF;
583: /*** was delete/reject successful? ***/
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: /*** If No -> rollback ***/
586: CSM_UTIL_PKG.LOG
587: ( 'Deleting from inqueue failed, rolling back to savepoint'
588: || ' for PK ' || r_tasks.task_id ,

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: || ' for PK ' || r_tasks.task_id ,
589: g_object_name || '.APPLY_CLIENT_CHANGES',
590: FND_LOG.LEVEL_ERROR); -- put PK column here
591: ROLLBACK TO save_rec;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;
595:
596: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 596: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;
595:
596: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
597: /*** Record was not processed successfully or delete failed
598: -> defer and reject record ***/
599: CSM_UTIL_PKG.LOG
600: ( 'Record not processed successfully, deferring and rejecting record'

Line 618: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

614: , r_tasks.dmltype$$
615: );
616:
617: /*** Was defer successful? ***/
618: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
619: /*** no -> rollback ***/
620: CSM_UTIL_PKG.LOG
621: ( 'Defer record failed, rolling back to savepoint'
622: || ' for PK ' || r_tasks.task_id ,

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: || ' for PK ' || r_tasks.task_id ,
623: g_object_name || '.APPLY_CLIENT_CHANGES',
624: FND_LOG.LEVEL_ERROR); -- put PK column here
625: ROLLBACK TO save_rec;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: END IF;
629:
630: END LOOP;

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: CSM_UTIL_PKG.LOG
635: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
636: g_object_name || '.APPLY_CLIENT_CHANGES',
637: FND_LOG.LEVEL_EXCEPTION);
638: x_return_status := FND_API.G_RET_STS_ERROR;
639:
640: END APPLY_CLIENT_CHANGES;
641:
642: END CSM_TASKS_PKG; -- Package spec