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_AUTO_SYNC_LOG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30


  SELECT *
  FROM  csm_auto_sync_log_inq
  WHERE tranid$$ = b_tranid
  AND   clid$$cs = b_user_name;

Line: 36


PROCEDURE INSERT_AUTO_SYNC_LOG_ACC (p_notification_id IN wf_notifications.notification_id%TYPE,
                                    p_user_id   IN fnd_user.user_id%TYPE)
IS
  l_sysdate 	DATE;

Line: 42


    CSM_ACC_PKG.Insert_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_auto_sync_log_pubi_name
     ,P_ACC_TABLE_NAME         => g_auto_sync_log_acc_table_name
     ,P_SEQ_NAME               => g_auto_sync_log_seq_name
     ,P_PK1_NAME               => g_auto_sync_log_pk1_name
     ,P_PK1_NUM_VALUE          => p_notification_id
     ,P_USER_ID                => p_user_id
    );

Line: 51


  CSM_UTIL_PKG.LOG( 'Exception occurred in ' || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC: '
|| SQLERRM,' for PK ' || to_char(p_notification_id) || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 55


END INSERT_AUTO_SYNC_LOG_ACC;-- end INSERT_AUTO_SYNC_LOG_ACC

Line: 67


 SELECT DISTINCT notification_id
    FROM CSM_AUTO_SYNC_LOG_ACC ACC;

Line: 77


   INSERT_AUTO_SYNC_LOG_ACC (l_notf_rec.notification_id, p_user_id);

Line: 98


  an inserted record is to be processed.
***/
PROCEDURE APPLY_INSERT
         (
           p_record        IN c_auto_sync_log_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2,
           x_reject_row    OUT NOCOPY BOOLEAN
         ) IS

  l_id  csm_auto_sync_log.id%TYPE;

Line: 122


  )IS SELECT ROWID
      FROM   CSM_AUTO_SYNC_LOG
      WHERE  notification_id = b_notification_id;

Line: 131


CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
               || ' for PK ' || p_record.notification_id,
               'CSM_AUTO_SYNC_LOG.APPLY_INSERT',
               FND_LOG.LEVEL_PROCEDURE );

Line: 149


insert into csm_auto_sync_log(ID,
NOTIFICATION_ID,
AS_TYPE,
AS_START_DATE,
AS_FINISH_DATE,
AS_RESULT,
EMAIL_SENT,
CREATION_DATE ,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY)
 values (l_id,l_notification_id,l_as_type, l_as_start_date, l_as_finish_date , l_as_result, l_email_sent,p_record.creation_date ,p_record.created_by,p_record.last_update_date,p_record.last_updated_by);

Line: 163


  ** Check whether the insert was succesfull
  ***************************************************************************/
  IF (c_record_exists%ISOPEN)THEN
    CLOSE c_record_exists;

Line: 189


    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
      || ' ROOT ERROR: create statement'
      || ' for PK ' || p_record.NOTIFICATION_ID,
      g_object_name || '.APPLY_INSERT',
      FND_LOG.LEVEL_ERROR );

Line: 206


     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
       || ' for PK ' || p_record.notification_id,
       g_object_name || '.APPLY_INSERT',
       FND_LOG.LEVEL_EXCEPTION );

Line: 213


END APPLY_INSERT;

Line: 218


  an updated record is to be processed.
  For CSM 11583, we support updates on the DFF columns
***/
PROCEDURE APPLY_UPDATE
         (
           p_record        IN c_auto_sync_log_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         )
IS
CURSOR	 c_auto_sync_log ( b_notification_id NUMBER ) IS
SELECT 	 *
FROM   	 csm_auto_sync_log
WHERE  	 notification_id = b_notification_id;

Line: 233


CURSOR c_last_update_date ( b_notification_id NUMBER)
IS
SELECT LAST_UPDATE_DATE,
       last_updated_by
FROM   csm_auto_sync_log
WHERE  notification_id = b_notification_id;

Line: 255


CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
               || ' for PK ' || p_record.notification_id,
               'CSM_AUTO_SYNC_LOG.APPLY_UPDATE',
               FND_LOG.LEVEL_PROCEDURE );

Line: 290


  ** Update the record
  ***************************************************************************/

UPDATE csm_auto_sync_log
SET ID = p_record.id,
NOTIFICATION_ID = p_record.notification_id,
AS_TYPE = p_record.as_type,
AS_START_DATE = p_record.as_start_date,
AS_FINISH_DATE = p_record.as_finish_date,
AS_RESULT = p_record.as_result,
EMAIL_SENT = p_record.email_sent,
CREATION_DATE = p_record.creation_date ,
CREATED_BY = p_record.created_by,
LAST_UPDATE_DATE = p_record.last_update_date,
LAST_UPDATED_BY	= p_record.last_updated_by
where ID=p_record.id;

Line: 310


  ** Check if the update was succesful
  ***************************************************************************/

  IF (SQL%NOTFOUND)
  THEN
    RAISE NO_DATA_FOUND;

Line: 332


     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
       || ' for PK ' || p_record.notification_id,
       g_object_name || '.APPLY_UPDATE',
       FND_LOG.LEVEL_EXCEPTION );

Line: 339


END APPLY_UPDATE;

Line: 362


    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status,
        x_reject_row
      );

Line: 369


  ELSIF p_record.dmltype$$='U' THEN -- YLIAO: for 11583, we do support UPDATE
    -- Process update
    APPLY_UPDATE
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 381


      ( 'Delete and Update is not supported for this entity'
        || ' for PK ' || p_record.notification_id ,
        g_object_name || '.APPLY_RECORD',
        FND_LOG.LEVEL_ERROR);

Line: 454


      /*** If Yes -> delete record from inqueue ***/
      IF l_reject_row THEN
       CSM_UTIL_PKG.REJECT_RECORD
        (
          p_user_name,
          p_tranid,
          r_auto_sync_log.seqno$$,
          r_auto_sync_log.notification_id,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_return_status
        );

Line: 468


       CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_auto_sync_log.seqno$$,
          r_auto_sync_log.notification_id,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_return_status --Introduced new variable l_return_status since Defer
        );                --process doesn't depend on this delete_record API

Line: 481


      /*** was delete/reject successful? ***/
      IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
        /*** If No -> rollback ***/
        CSM_UTIL_PKG.LOG
        ( 'Deleting from inqueue failed, rolling back to savepoint'
          || ' for PK ' || r_auto_sync_log.notification_id ,
          g_object_name || '.APPLY_CLIENT_CHANGES',
          FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 495


      /*** Record was not processed successfully or delete failed
      -> defer and reject record ***/
      CSM_UTIL_PKG.LOG
      ( 'Record not processed successfully, deferring and rejecting record'
        || ' for PK ' || r_auto_sync_log.notification_id ,
        g_object_name || '.APPLY_CLIENT_CHANGES',
        FND_LOG.LEVEL_ERROR); -- put PK column here