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_UNDO_PKG dependencies on CSM_UNDO_PKG

Line 1: PACKAGE BODY CSM_UNDO_PKG AS

1: PACKAGE BODY CSM_UNDO_PKG AS
2: /* $Header: csmucudb.pls 120.2 2011/01/10 10:27:49 saradhak noship $ */
3:
4: error EXCEPTION;
5:

Line 8: g_object_name CONSTANT VARCHAR2(30) := 'CSM_UNDO_PKG';

4: error EXCEPTION;
5:
6:
7: /*** Globals ***/
8: g_object_name CONSTANT VARCHAR2(30) := 'CSM_UNDO_PKG';
9: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_UNDO_REQUEST';
10: g_debug_level NUMBER; -- debug level
11:
12: /* Select all inq records */

Line 702: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_RECORD for PK1 Value ' || p_record.PK1_VALUE ,

698: /*** initialize return status and message list ***/
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

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 729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,

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

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 762: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_CLIENT_CHANGES ',

758: l_process_status VARCHAR2(1);
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:

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 831: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',

827: END IF;
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 ***/

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;

Line 844: END CSM_UNDO_PKG;

840:
841: END APPLY_CLIENT_CHANGES;
842:
843:
844: END CSM_UNDO_PKG;