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

Line 66: p_init_msg_list => fnd_api.g_true,

62:
63: -- Create a Task Assignment
64: csf_task_assignments_pub.create_task_assignment (
65: p_api_version => 1.0,
66: p_init_msg_list => fnd_api.g_true,
67: p_commit => fnd_api.g_false,
68: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,
69: p_validation_level => NULL,
70: p_task_id => p_record.TASK_ID,

Line 67: p_commit => fnd_api.g_false,

63: -- Create a Task Assignment
64: csf_task_assignments_pub.create_task_assignment (
65: p_api_version => 1.0,
66: p_init_msg_list => fnd_api.g_true,
67: p_commit => fnd_api.g_false,
68: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,
69: p_validation_level => NULL,
70: p_task_id => p_record.TASK_ID,
71: p_task_name => NULL,

Line 109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

105: x_task_object_version_number => l_task_object_version_number,
106: x_task_status_id => l_task_status_id
107: );
108:
109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
110: THEN
111:
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108:
109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
110: THEN
111:
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
114: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
115: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
116: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

Line 128: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

124: FETCH c_task_assignment INTO l_ovn;
125: CLOSE c_task_assignment;
126:
127: -- Synchronize Task Assignment and Task statuses
128: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
129:
130: /* Bug 16013131 */
131: BEGIN
132: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'

Line 132: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'

128: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
129:
130: /* Bug 16013131 */
131: BEGIN
132: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
133: USING FND_API.G_FALSE;
134: EXCEPTION
135: WHEN OTHERS THEN
136: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,

Line 133: USING FND_API.G_FALSE;

129:
130: /* Bug 16013131 */
131: BEGIN
132: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
133: USING FND_API.G_FALSE;
134: EXCEPTION
135: WHEN OTHERS THEN
136: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
137: 'CSM_TASK_ASSIGNMENT_PKG.apply_insert', FND_LOG.LEVEL_PROCEDURE);

Line 144: , p_init_msg_list => FND_API.G_TRUE

140: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
141:
142: csf_task_assignments_pub.update_assignment_status
143: ( p_api_version => 1.0
144: , p_init_msg_list => FND_API.G_TRUE
145: , p_commit => FND_API.G_FALSE
146: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
147: , x_return_status => x_return_status
148: , x_msg_count => l_msg_count

Line 145: , p_commit => FND_API.G_FALSE

141:
142: csf_task_assignments_pub.update_assignment_status
143: ( p_api_version => 1.0
144: , p_init_msg_list => FND_API.G_TRUE
145: , p_commit => FND_API.G_FALSE
146: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
147: , x_return_status => x_return_status
148: , x_msg_count => l_msg_count
149: , x_msg_data => l_msg_data

Line 146: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

142: csf_task_assignments_pub.update_assignment_status
143: ( p_api_version => 1.0
144: , p_init_msg_list => FND_API.G_TRUE
145: , p_commit => FND_API.G_FALSE
146: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
147: , x_return_status => x_return_status
148: , x_msg_count => l_msg_count
149: , x_msg_data => l_msg_data
150: , p_task_assignment_id => p_record.task_assignment_id

Line 162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

158: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);
159:
160: END IF;
161:
162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
163: THEN
164:
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161:
162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
163: THEN
164:
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
167: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
168: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
169: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: END IF;
172:
173:
174: -- success
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: EXCEPTION WHEN OTHERS THEN
178: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
179: FND_LOG.LEVEL_EXCEPTION );

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: EXCEPTION WHEN OTHERS THEN
178: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
179: FND_LOG.LEVEL_EXCEPTION );
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END APPLY_INSERT;
183: /***
184: This procedure is called by APPLY_INSERT when
185: an update is to be reverted.

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

365: l_dml_type VARCHAR2(1) := '';
366:
367: BEGIN
368:
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: EXCEPTION WHEN OTHERS THEN
372: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
373: FND_LOG.LEVEL_EXCEPTION );

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370:
371: EXCEPTION WHEN OTHERS THEN
372: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
373: FND_LOG.LEVEL_EXCEPTION );
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: END APPLY_UNDO;
376:
377: /***
378: This procedure is called by APPLY_CRECORD when

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

418: --check for the stale data
419: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
420: -- SERVER_WINS profile value
421: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS AND
422: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE)
423: THEN
424: 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
425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
426: || p_record.task_assignment_id;

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: THEN
424: 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
425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
426: || p_record.task_assignment_id;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: csm_util_pkg.log(p_error_msg,
429: g_object_name || '.APPLY_UPDATE',
430: FND_LOG.LEVEL_ERROR);
431: RETURN;

Line 446: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'

442: -- step is not sent to CRM, the API will see A -> C and refuse it.
443: -- To allow for A -> C no validation is done.
444: /* Bug 16013131 */
445: BEGIN
446: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
447: USING FND_API.G_FALSE;
448: EXCEPTION
449: WHEN OTHERS THEN
450: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,

Line 447: USING FND_API.G_FALSE;

443: -- To allow for A -> C no validation is done.
444: /* Bug 16013131 */
445: BEGIN
446: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
447: USING FND_API.G_FALSE;
448: EXCEPTION
449: WHEN OTHERS THEN
450: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
451: 'CSM_TASK_ASSIGNMENT_PKG.apply_update', FND_LOG.LEVEL_PROCEDURE);

Line 458: , p_init_msg_list => FND_API.G_TRUE

454: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
455:
456: csf_task_assignments_pub.update_assignment_status
457: ( p_api_version => 1.0
458: , p_init_msg_list => FND_API.G_TRUE
459: , p_commit => FND_API.G_FALSE
460: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
461: , x_return_status => x_return_status
462: , x_msg_count => l_msg_count

Line 459: , p_commit => FND_API.G_FALSE

455:
456: csf_task_assignments_pub.update_assignment_status
457: ( p_api_version => 1.0
458: , p_init_msg_list => FND_API.G_TRUE
459: , p_commit => FND_API.G_FALSE
460: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
461: , x_return_status => x_return_status
462: , x_msg_count => l_msg_count
463: , x_msg_data => l_msg_data

Line 460: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

456: csf_task_assignments_pub.update_assignment_status
457: ( p_api_version => 1.0
458: , p_init_msg_list => FND_API.G_TRUE
459: , p_commit => FND_API.G_FALSE
460: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
461: , x_return_status => x_return_status
462: , x_msg_count => l_msg_count
463: , x_msg_data => l_msg_data
464: , p_task_assignment_id => p_record.task_assignment_id

Line 474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

470: );
471:
472: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);
473:
474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
475: THEN
476:
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

473:
474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
475: THEN
476:
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
479: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
480: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
481: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line 491: , p_init_msg_list => FND_API.G_TRUE

487: -- doesn't support the actual times and the csf_tasks_pub.Update_Task_Assignment doen't
488: -- support the validation level set to none.
489: csf_task_assignments_pub.Update_Task_Assignment
490: ( p_api_version => 1.0
491: , p_init_msg_list => FND_API.G_TRUE
492: , p_commit => FND_API.G_FALSE
493: , p_task_assignment_id => p_record.task_assignment_id
494: , p_object_version_number => l_ovn
495: , p_task_id => p_record.task_id

Line 492: , p_commit => FND_API.G_FALSE

488: -- support the validation level set to none.
489: csf_task_assignments_pub.Update_Task_Assignment
490: ( p_api_version => 1.0
491: , p_init_msg_list => FND_API.G_TRUE
492: , p_commit => FND_API.G_FALSE
493: , p_task_assignment_id => p_record.task_assignment_id
494: , p_object_version_number => l_ovn
495: , p_task_id => p_record.task_id
496: , p_resource_type_code => FND_API.G_MISS_CHAR

Line 496: , p_resource_type_code => FND_API.G_MISS_CHAR

492: , p_commit => FND_API.G_FALSE
493: , p_task_assignment_id => p_record.task_assignment_id
494: , p_object_version_number => l_ovn
495: , p_task_id => p_record.task_id
496: , p_resource_type_code => FND_API.G_MISS_CHAR
497: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
498: , p_resource_territory_id => FND_API.G_MISS_NUM
499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date

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

493: , p_task_assignment_id => p_record.task_assignment_id
494: , p_object_version_number => l_ovn
495: , p_task_id => p_record.task_id
496: , p_resource_type_code => FND_API.G_MISS_CHAR
497: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
498: , p_resource_territory_id => FND_API.G_MISS_NUM
499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date

Line 498: , p_resource_territory_id => FND_API.G_MISS_NUM

494: , p_object_version_number => l_ovn
495: , p_task_id => p_record.task_id
496: , p_resource_type_code => FND_API.G_MISS_CHAR
497: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
498: , p_resource_territory_id => FND_API.G_MISS_NUM
499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM

Line 499: , p_assignment_status_id => FND_API.G_MISS_NUM

495: , p_task_id => p_record.task_id
496: , p_resource_type_code => FND_API.G_MISS_CHAR
497: , p_resource_id => FND_API.G_MISS_NUM --p_record.resource_id
498: , p_resource_territory_id => FND_API.G_MISS_NUM
499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM

Line 502: , p_sched_travel_distance => FND_API.G_MISS_NUM

498: , p_resource_territory_id => FND_API.G_MISS_NUM
499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM
504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
505: , p_shift_construct_id => FND_API.G_MISS_NUM
506: , p_object_capacity_id => FND_API.G_MISS_NUM

Line 503: , p_sched_travel_duration => FND_API.G_MISS_NUM

499: , p_assignment_status_id => FND_API.G_MISS_NUM
500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM
504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
505: , p_shift_construct_id => FND_API.G_MISS_NUM
506: , p_object_capacity_id => FND_API.G_MISS_NUM
507: , p_attribute1 => p_record.attribute1

Line 504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR

500: , p_actual_start_date => p_record.actual_start_date
501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM
504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
505: , p_shift_construct_id => FND_API.G_MISS_NUM
506: , p_object_capacity_id => FND_API.G_MISS_NUM
507: , p_attribute1 => p_record.attribute1
508: , p_attribute2 => p_record.attribute2

Line 505: , p_shift_construct_id => FND_API.G_MISS_NUM

501: , p_actual_end_date => p_record.actual_end_date
502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM
504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
505: , p_shift_construct_id => FND_API.G_MISS_NUM
506: , p_object_capacity_id => FND_API.G_MISS_NUM
507: , p_attribute1 => p_record.attribute1
508: , p_attribute2 => p_record.attribute2
509: , p_attribute3 => p_record.attribute3

Line 506: , p_object_capacity_id => FND_API.G_MISS_NUM

502: , p_sched_travel_distance => FND_API.G_MISS_NUM
503: , p_sched_travel_duration => FND_API.G_MISS_NUM
504: , p_sched_travel_duration_uom => FND_API.G_MISS_CHAR
505: , p_shift_construct_id => FND_API.G_MISS_NUM
506: , p_object_capacity_id => FND_API.G_MISS_NUM
507: , p_attribute1 => p_record.attribute1
508: , p_attribute2 => p_record.attribute2
509: , p_attribute3 => p_record.attribute3
510: , p_attribute4 => p_record.attribute4

Line 531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

527: , x_task_object_version_number => l_task_object_version_number
528: , x_task_status_id => l_task_status_id
529: );
530:
531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: x_return_status := FND_API.G_RET_STS_ERROR;
534:
535: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

529: );
530:
531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: x_return_status := FND_API.G_RET_STS_ERROR;
534:
535: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
536: || ' ROOT ERROR: csf_tasks_pub.Update_Task_Assignment'
537: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,

Line 544: x_return_status := FND_API.G_RET_STS_SUCCESS;

540: RETURN ;
541: END IF;
542:
543: -- success
544: x_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: EXCEPTION
547: WHEN others THEN
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: || ' for PK ' || p_record.task_assignment_id,
550: g_object_name || '.APPLY_UPDATE',
551: FND_LOG.LEVEL_EXCEPTION );
552:
553: x_return_status := FND_API.G_RET_STS_ERROR;
554:
555: END APPLY_UPDATE;
556:
557:

Line 578: x_return_status := FND_API.G_RET_STS_SUCCESS;

574: l_is_closed VARCHAR2(100):='N';
575: BEGIN
576:
577: /*** initialize return status and message list ***/
578: x_return_status := FND_API.G_RET_STS_SUCCESS;
579: FND_MSG_PUB.INITIALIZE;
580:
581:
582: IF p_record.dmltype$$='I' THEN

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: , p_token_name1 => 'DML'
625: , p_token_value1 => p_record.dmltype$$
626: );
627:
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END IF;
630:
631: EXCEPTION WHEN OTHERS THEN
632: /*** defer record when any process exception occurs ***/

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640: (
641: p_api_error => TRUE
642: );
643:
644: x_return_status := FND_API.G_RET_STS_ERROR;
645:
646: END APPLY_RECORD;
647:
648:

Line 700: x_return_status := FND_API.G_RET_STS_SUCCESS;

696: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
697: g_object_name || '.APPLY_CLIENT_CHANGES',
698: FND_LOG.LEVEL_PROCEDURE);
699: g_debug_level := p_debug_level;
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
701:
702: /*** loop through task assignments records in inqueue ***/
703: FOR r_task_assignments IN c_task_assignments_inq( p_user_name, p_tranid) LOOP
704:

Line 716: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

712: , l_process_status
713: );
714:
715: /*** was record processed successfully? ***/
716: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
717: -- if update to charges fail, then do not defer the record
718: BEGIN
719: OPEN c_chk_task_status (r_task_assignments.task_assignment_id);
720: FETCH c_chk_task_status INTO l_header_id, l_rejected_flag,

Line 758: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

754: l_process_status
755: );
756:
757: /*** was delete successful? ***/
758: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
759: --Task Assignment Audit information is not important and hence
760: -- Task Assignment Audit information failure should not be
761: -- considered as failure and stops TA Upload
762: --Call Task Assignment Audit Upload

Line 773: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

769: x_return_status =>l_process_status
770: );
771:
772: /*** was TA AUDIT UPLOAD successful? ***/
773: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
774: /*** If No -> rollback ***/
775: CSM_UTIL_PKG.LOG
776: ( 'Inserting Task Assignment Audit Failed, Task Assignment Audit Failed for '
777: || ' for PK ' || r_task_assignments.task_assignment_id ,

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: || ' for PK ' || r_task_assignments.task_assignment_id ,
787: g_object_name || '.APPLY_CLIENT_CHANGES',
788: FND_LOG.LEVEL_ERROR); -- put PK column here
789: ROLLBACK TO save_rec;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
793: /*** Record was not processed successfully or delete failed
794: -> defer and reject record ***/

Line 792: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

788: FND_LOG.LEVEL_ERROR); -- put PK column here
789: ROLLBACK TO save_rec;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
793: /*** Record was not processed successfully or delete failed
794: -> defer and reject record ***/
795: CSM_UTIL_PKG.LOG
796: ( 'Record not processed successfully, deferring and rejecting record'

Line 814: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

810: , r_task_assignments.dmltype$$
811: );
812:
813: /*** Was defer successful? ***/
814: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
815: CSM_UTIL_PKG.LOG
816: ( 'Inserting Task Assignment Audit , Task Assignment Audit for '
817: || ' for PK ' || r_task_assignments.task_assignment_id ,
818: g_object_name || '.APPLY_CLIENT_CHANGES',

Line 832: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

828: );
829:
830: END IF;
831:
832: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
833: /*** no -> rollback ***/
834: CSM_UTIL_PKG.LOG
835: ( 'Defer record failed, rolling back to savepoint'
836: || ' for PK ' || r_task_assignments.task_assignment_id ,

Line 840: x_return_status := FND_API.G_RET_STS_ERROR;

836: || ' for PK ' || r_task_assignments.task_assignment_id ,
837: g_object_name || '.APPLY_CLIENT_CHANGES',
838: FND_LOG.LEVEL_ERROR); -- put PK column here
839: ROLLBACK TO save_rec;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: END IF;
842:
843: END IF;
844: END LOOP;

Line 855: x_return_status := FND_API.G_RET_STS_ERROR;

851: /*** catch and log exceptions ***/
852: CSM_UTIL_PKG.LOG
853: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
854: g_object_name || '.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
855: x_return_status := FND_API.G_RET_STS_ERROR;
856:
857: END APPLY_CLIENT_CHANGES;
858:
859: FUNCTION CONFLICT_RESOLUTION_METHOD (p_user_name IN VARCHAR2,