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_MOBILE_QUERY_PKG dependencies on CSM_MOBILE_QUERY_PKG

Line 1: PACKAGE BODY CSM_MOBILE_QUERY_PKG AS

1: PACKAGE BODY CSM_MOBILE_QUERY_PKG AS
2: /* $Header: csmuqryb.pls 120.5 2009/10/22 04:00:18 trajasek noship $ */
3:
4: error EXCEPTION;
5:

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

4: error EXCEPTION;
5:
6:
7: /*** Globals ***/
8: g_object_name CONSTANT VARCHAR2(30) := 'CSM_MOBILE_QUERY_PKG';
9: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_QUERY';
10: g_query_var_pub_name CONSTANT VARCHAR2(30) := 'CSM_QUERY_VARIABLES';
11:
12: g_debug_level NUMBER; -- debug level

Line 310: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID ' || p_record.QUERY_ID ,

306: --p_error_msg VARCHAR2(4000);
307: BEGIN
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID ' || p_record.QUERY_ID ,
311: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
312: l_PARENT_QUERY_ID := p_record.PARENT_QUERY_ID;
313: l_query_id := p_record.QUERY_ID;
314:

Line 311: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

307: BEGIN
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID ' || p_record.QUERY_ID ,
311: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
312: l_PARENT_QUERY_ID := p_record.PARENT_QUERY_ID;
313: l_query_id := p_record.QUERY_ID;
314:
315: IF l_PARENT_QUERY_ID IS NULL THEN

Line 399: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID : ' || p_record.QUERY_ID ,

395: x_return_status := FND_API.G_RET_STS_ERROR;
396: RETURN;
397: END IF;
398:
399: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID : ' || p_record.QUERY_ID ,
400: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
401: p_error_msg := 'Query Upload is Successful for Query ID : '|| l_query_id;
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:

Line 400: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

396: RETURN;
397: END IF;
398:
399: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID : ' || p_record.QUERY_ID ,
400: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
401: p_error_msg := 'Query Upload is Successful for Query ID : '|| l_query_id;
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404:

Line 408: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

404:
405: EXCEPTION WHEN OTHERS THEN
406: p_error_msg := 'Exeception in Query Upload for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);
407: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || SUBSTR(SQLERRM,1,3000)
408: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END APPLY_INSERT;
411:
412: /***

Line 444: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID ' || p_record.QUERY_ID ,

440: l_USER_ID NUMBER := NULL;
441: l_QUERY_ID NUMBER;
442: BEGIN
443:
444: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID ' || p_record.QUERY_ID ,
445: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
446: l_query_id := p_record.QUERY_ID;
447:
448: OPEN c_get_user(p_record.CLID$$CS);

Line 445: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);

441: l_QUERY_ID NUMBER;
442: BEGIN
443:
444: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID ' || p_record.QUERY_ID ,
445: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
446: l_query_id := p_record.QUERY_ID;
447:
448: OPEN c_get_user(p_record.CLID$$CS);
449: FETCH c_get_user INTO l_USER_ID;

Line 475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,

471: LAST_UPDATED_BY = fnd_global.user_id,
472: LAST_UPDATE_LOGIN = fnd_global.login_id
473: WHERE QUERY_ID = l_QUERY_ID;
474:
475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,
476: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
477: p_error_msg := 'Query Delete is Successful for Query ID : '|| l_query_id;
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:

Line 476: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);

472: LAST_UPDATE_LOGIN = fnd_global.login_id
473: WHERE QUERY_ID = l_QUERY_ID;
474:
475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,
476: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
477: p_error_msg := 'Query Delete is Successful for Query ID : '|| l_query_id;
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480:

Line 484: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);

480:
481: EXCEPTION WHEN OTHERS THEN
482: p_error_msg := 'Exeception in Query Delete for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);
483: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || SUBSTR(SQLERRM,1,3000)
484: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: END APPLY_DELETE;
487:
488: /***

Line 504: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,

500: /*** initialize return status and message list ***/
501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502: FND_MSG_PUB.INITIALIZE;
503:
504: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
505: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
506:
507: IF p_record.dmltype$$='I' THEN
508: -- Process insert

Line 505: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502: FND_MSG_PUB.INITIALIZE;
503:
504: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
505: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
506:
507: IF p_record.dmltype$$='I' THEN
508: -- Process insert
509: APPLY_INSERT

Line 528: || ' for Query Instance ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

524: ELSE --Delete and update is not supported for this PI
525: -- invalid dml type
526: CSM_UTIL_PKG.LOG
527: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
528: || ' for Query Instance ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
529:
530: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
531: (
532: p_message => 'CSM_DML_OPERATION'

Line 540: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,

536:
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539:
540: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
541: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
542: EXCEPTION WHEN OTHERS THEN
543: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
544: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 541: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539:
540: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
541: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
542: EXCEPTION WHEN OTHERS THEN
543: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
544: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
545: (

Line 549: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

545: (
546: p_api_error => TRUE
547: );
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || SUBSTR(SQLERRM,1,3000)
549: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
550:
551: x_return_status := FND_API.G_RET_STS_ERROR;
552:
553: END APPLY_RECORD;

Line 573: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES ',

569: l_process_status VARCHAR2(1);
570: l_error_msg VARCHAR2(4000);
571:
572: BEGIN
573: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES ',
574: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
575: g_debug_level := p_debug_level;
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:

Line 574: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

570: l_error_msg VARCHAR2(4000);
571:
572: BEGIN
573: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES ',
574: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
575: g_debug_level := p_debug_level;
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: /*** loop through all the records in inqueue ***/

Line 624: || ' for Instance ID ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

620: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
621: /*** no -> rollback ***/
622: CSM_UTIL_PKG.LOG
623: ( 'Deleting from inqueue failed, rolling back to savepoint'
624: || ' for Instance ID ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
625: ROLLBACK TO save_rec;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 631: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

627: END IF;
628: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
629: /*** Record was not applied successfully -> defer and reject records ***/
630: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
631: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
632:
633: CSM_UTIL_PKG.DEFER_RECORD
634: (
635: p_user_name

Line 668: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

664: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
665: /*** no -> rollback ***/
666: CSM_UTIL_PKG.LOG
667: ( 'Defer record failed, rolling back to savepoint'
668: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
669: ROLLBACK TO save_rec;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END IF;
672: END IF;

Line 676: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',

672: END IF;
673:
674: END LOOP;
675:
676: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',
677: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
678:
679: EXCEPTION WHEN OTHERS THEN
680: /*** catch and log exceptions ***/

Line 677: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

673:
674: END LOOP;
675:
676: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',
677: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
678:
679: EXCEPTION WHEN OTHERS THEN
680: /*** catch and log exceptions ***/
681: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

Line 682: ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

678:
679: EXCEPTION WHEN OTHERS THEN
680: /*** catch and log exceptions ***/
681: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
682: ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
683:
684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: END APPLY_CLIENT_CHANGES;

Line 688: END CSM_MOBILE_QUERY_PKG;

684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: END APPLY_CLIENT_CHANGES;
687:
688: END CSM_MOBILE_QUERY_PKG;