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

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

Line: 31


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

Line: 37


PROCEDURE INSERT_CLIENT_NFN_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: 43


    CSM_ACC_PKG.Insert_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_cl_nfn_log_pubi_name
     ,P_ACC_TABLE_NAME         => g_cl_nfn_log_acc_table_name
     ,P_SEQ_NAME               => g_cl_nfn_log_seq_name
     ,P_PK1_NAME               => g_cl_nfn_log_pk1_name
     ,P_PK1_NUM_VALUE          => p_notification_id
     ,P_USER_ID                => p_user_id
    );

Line: 53


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

Line: 57


END INSERT_CLIENT_NFN_LOG_ACC;-- end INSERT_CLIENT_NFN_LOG_ACC

Line: 69


 SELECT DISTINCT notification_id
  FROM CSM_CLIENT_NFN_LOG_ACC ACC;

Line: 80


   INSERT_CLIENT_NFN_LOG_ACC (l_notf_rec.notification_id, p_user_id);

Line: 101


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


  l_notification_id    csm_client_nfn_log.notification_id%TYPE  ;

Line: 121


  )IS SELECT ROWID
      FROM   CSM_CLIENT_NFN_LOG
      WHERE  notification_id = b_notification_id;

Line: 130


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

Line: 144


insert into csm_client_nfn_log(NOTIFICATION_ID,
OBJECT_ID ,
OBJECT_NAME,
MESSAGE,
STATUS,
REPLYTOEMAIL,
NID,
CREATION_DATE ,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY)
 values (l_notification_id,l_object_id ,l_object_name,p_record.message ,p_record.status,p_record.replytoemail,p_record.nid,p_record.creation_date ,p_record.created_by,p_record.last_update_date,p_record.last_updated_by)
RETURNING NOTIFICATION_ID INTO l_notification_id;

Line: 159


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

Line: 185


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


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


END APPLY_INSERT;

Line: 212


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

Line: 227


CURSOR c_last_update_date ( b_notification_id NUMBER)
IS
SELECT LAST_UPDATE_DATE
FROM   csm_client_nfn_log
WHERE  notification_id = b_notification_id;

Line: 248


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

Line: 283


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

UPDATE csm_client_nfn_log
SET NOTIFICATION_ID = p_record.notification_id,
OBJECT_ID  = p_record.object_id ,
OBJECT_NAME = p_record.object_name,
MESSAGE = p_record.message,
STATUS = p_record.status,
REPLYTOEMAIL = p_record.replytoemail,
NID = p_record.nid,
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 NOTIFICATION_ID = p_record.notification_id;

Line: 303


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

  IF (SQL%NOTFOUND)
  THEN
    RAISE NO_DATA_FOUND;

Line: 324


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


END APPLY_UPDATE;

Line: 349


    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status,
        x_reject_row         --Bug 5288413
      );

Line: 356


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


      ( '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: 443


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

Line: 457


       CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_client_nfn_log.seqno$$,
          r_client_nfn_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: 470


      /*** 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_client_nfn_log.notification_id ,
          g_object_name || '.APPLY_CLIENT_CHANGES',
          FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 484


      /*** 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_client_nfn_log.notification_id ,
        g_object_name || '.APPLY_CLIENT_CHANGES',
        FND_LOG.LEVEL_ERROR); -- put PK column here