DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on FND_LOG

Line 277: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );

273: IF l_user_id Is NULL OR l_user_name IS NULL THEN
274: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
275: || ' Task Assignment ID :' || l_task_assignment_id
276: || 'UNDO Failed.User Invalid',
277: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279: RETURN;
280: END IF;
281:

Line 298: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );

294: l_markdirty_all := 'N';
295: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
296: || ' Task Assignment ID :' || l_task_assignment_id
297: || 'is no longer assigned to the user. UNDO Failed',
298: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: ELSE
301: --Task Assignment Markdirty
302: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => 'CSM_TASK_ASSIGNMENTS',

Line 680: FND_LOG.LEVEL_EXCEPTION );

676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677:
678: EXCEPTION WHEN OTHERS THEN
679: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
680: FND_LOG.LEVEL_EXCEPTION );
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END APPLY_UNDO;
683:
684:

Line 703: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: FND_MSG_PUB.INITIALIZE;
701:
702: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_RECORD for PK1 Value ' || p_record.PK1_VALUE ,
703: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
704:
705: IF p_record.dmltype$$='I' THEN
706: -- Process insert
707: APPLY_UNDO

Line 717: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

713: ELSE --Delete and update is not supported for this PI
714: -- invalid dml type
715: CSM_UTIL_PKG.LOG
716: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
717: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
718:
719: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
720: (
721: p_message => 'CSM_DML_OPERATION'

Line 730: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

726: x_return_status := FND_API.G_RET_STS_ERROR;
727: END IF;
728:
729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,
730: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
731: EXCEPTION WHEN OTHERS THEN
732: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
733: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
734: (

Line 738: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

734: (
735: p_api_error => TRUE
736: );
737: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
738: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: END APPLY_RECORD;

Line 763: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

759: l_error_msg VARCHAR2(4000);
760:
761: BEGIN
762: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_CLIENT_CHANGES ',
763: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
764: g_debug_level := p_debug_level;
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:
767: /*** loop through all the records in inqueue ***/

Line 797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

793: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
794: /*** no -> rollback ***/
795: CSM_UTIL_PKG.LOG
796: ( 'Reject record failed, rolling back to savepoint'
797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
798: ROLLBACK TO save_rec;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: END IF;
801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 804: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

800: END IF;
801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
802: /*** Record was not applied successfully -> defer and reject records ***/
803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
804: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
805:
806: CSM_UTIL_PKG.REJECT_RECORD
807: (
808: p_user_name

Line 823: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

819: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
820: /*** no -> rollback ***/
821: CSM_UTIL_PKG.LOG
822: ( 'Reject record failed, No rolling back to savepoint'
823: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
824: ROLLBACK TO save_rec;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: END IF;
827: END IF;

Line 832: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

828:
829: END LOOP;
830:
831: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',
832: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
833:
834: EXCEPTION WHEN OTHERS THEN
835: /*** catch and log exceptions ***/
836: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

Line 837: ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

833:
834: EXCEPTION WHEN OTHERS THEN
835: /*** catch and log exceptions ***/
836: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
837: ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: END APPLY_CLIENT_CHANGES;