DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on FND_LOG

Line 61: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

57:
58:
59: BEGIN
60: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,
61: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
62:
63: -- Create a Task Assignment
64: csf_task_assignments_pub.create_task_assignment (
65: p_api_version => 1.0,

Line 116: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

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 );
117: RETURN ;
118: END IF;
119:
120: -- Ask for the task. It must exist. Exceptions will abort.

Line 137: 'CSM_TASK_ASSIGNMENT_PKG.apply_insert', FND_LOG.LEVEL_PROCEDURE);

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);
138: END;
139:
140: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
141:

Line 169: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

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 );
170: RETURN ;
171: END IF;
172:
173:

Line 179: FND_LOG.LEVEL_EXCEPTION );

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 );
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END APPLY_INSERT;
183: /***

Line 373: FND_LOG.LEVEL_EXCEPTION );

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 );
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: END APPLY_UNDO;
376:
377: /***

Line 430: FND_LOG.LEVEL_ERROR);

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;
432: END IF;
433: END IF;
434:

Line 451: 'CSM_TASK_ASSIGNMENT_PKG.apply_update', FND_LOG.LEVEL_PROCEDURE);

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);
452: END;
453:
454: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
455:

Line 481: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

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 );
482: RETURN ;
483: END IF;
484:
485: -- Also need to update the actual times of the task assignment update

Line 539: FND_LOG.LEVEL_ERROR );

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,
538: g_object_name || '.APPLY_UPDATE',
539: FND_LOG.LEVEL_ERROR );
540: RETURN ;
541: END IF;
542:
543: -- success

Line 551: FND_LOG.LEVEL_EXCEPTION );

547: WHEN others THEN
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
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;

Line 598: CSM_UTIL_PKG.LOG('Task is about to be closed. So Processing debriefs first ' ,'CSM_TASK_ASSIGNMENT_PKG.apply_record', FND_LOG.LEVEL_PROCEDURE);

594: FETCH c_new_status_closed INTO l_is_closed;
595: CLOSE c_new_status_closed;
596:
597: IF l_is_closed='Y' THEN
598: CSM_UTIL_PKG.LOG('Task is about to be closed. So Processing debriefs first ' ,'CSM_TASK_ASSIGNMENT_PKG.apply_record', FND_LOG.LEVEL_PROCEDURE);
599: CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
600: CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
601: CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
602: CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);

Line 619: FND_LOG.LEVEL_ERROR);

615: CSM_UTIL_PKG.LOG
616: ( 'Delete and Insert is not supported for this entity'
617: || ' for PK ' || p_record.task_assignment_id ,
618: g_object_name || '.APPLY_RECORD',
619: FND_LOG.LEVEL_ERROR);
620:
621: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
622: (
623: p_message => 'CSM_DML_OPERATION'

Line 637: FND_LOG.LEVEL_EXCEPTION);

633: CSM_UTIL_PKG.LOG
634: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
635: || ' for PK ' || p_record.task_assignment_id ,
636: g_object_name || '.APPLY_RECORD',
637: FND_LOG.LEVEL_EXCEPTION);
638: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
639: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
640: (
641: p_api_error => TRUE

Line 698: FND_LOG.LEVEL_PROCEDURE);

694: BEGIN
695: csm_util_pkg.log
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 ***/

Line 779: FND_LOG.LEVEL_ERROR); -- put PK column here

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 ,
778: g_object_name || '.APPLY_CLIENT_CHANGES',
779: FND_LOG.LEVEL_ERROR); -- put PK column here
780: END IF;
781:
782: ELSE
783: /*** If No -> rollback ***/

Line 788: FND_LOG.LEVEL_ERROR); -- put PK column here

784: CSM_UTIL_PKG.LOG
785: ( 'Deleting from inqueue failed, rolling back to savepoint'
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

Line 799: FND_LOG.LEVEL_ERROR); -- put PK column here

795: CSM_UTIL_PKG.LOG
796: ( 'Record not processed successfully, deferring and rejecting record'
797: || ' for PK ' || r_task_assignments.task_assignment_id ,
798: g_object_name || '.APPLY_CLIENT_CHANGES',
799: FND_LOG.LEVEL_ERROR); -- put PK column here
800:
801: CSM_UTIL_PKG.DEFER_RECORD
802: ( p_user_name
803: , p_tranid

Line 819: FND_LOG.LEVEL_ERROR); -- put PK column here

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',
819: FND_LOG.LEVEL_ERROR); -- put PK column here
820:
821: CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES
822: (
823: p_user_name =>p_user_name,

Line 838: FND_LOG.LEVEL_ERROR); -- put PK column here

834: CSM_UTIL_PKG.LOG
835: ( 'Defer record failed, rolling back to savepoint'
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:

Line 854: g_object_name || '.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

850:
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:

Line 878: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

874: AND seqno$$ = l_sequence
875: AND a.task_assignment_id = b.task_assignment_id ;
876:
877: BEGIN
878: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
879: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
880: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
881: FETCH get_user_id
882: INTO l_user_id ;