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_UTIL_PKG

Line 84: CSM_UTIL_PKG.LOG

80: l_level_value NUMBER := NULL;
81: l_level_id NUMBER;
82: l_responsibility_id NUMBER;
83: BEGIN
84: CSM_UTIL_PKG.LOG
85: ( 'Entering INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
86: FND_LOG.LEVEL_ERROR);
87: --Check if the user has valid access to responsibility
88: OPEN c_get_resp_id (p_PARENT_QUERY_ID);

Line 107: CSM_UTIL_PKG.LOG

103: x_return_status => l_return_status,
104: x_error_message => l_return_message);
105:
106: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
107: CSM_UTIL_PKG.LOG
108: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
109: FND_LOG.LEVEL_EXCEPTION);
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 122: CSM_UTIL_PKG.LOG

118: x_return_status => l_return_status,
119: x_error_message => l_return_message);
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: CSM_UTIL_PKG.LOG
123: ( 'Exception occurred in VALIDATE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
124: FND_LOG.LEVEL_EXCEPTION);
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 138: CSM_UTIL_PKG.LOG

134: x_return_status => l_return_status,
135: x_error_message => l_return_message
136: );
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: CSM_UTIL_PKG.LOG
139: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
140: FND_LOG.LEVEL_EXCEPTION);
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 150: CSM_UTIL_PKG.LOG

146:
147: IF p_VARIABLE_NAME IS NOT NULL AND p_VARIABLE_TYPE IS NOT NULL THEN
148:
149: IF p_VARIABLE_NAME.COUNT <> p_VARIABLE_TYPE.COUNT THEN
150: CSM_UTIL_PKG.LOG
151: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
152: FND_LOG.LEVEL_ERROR);
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;

Line 163: CSM_UTIL_PKG.LOG

159: ELSE
160: IF p_VARIABLE_NAME IS NULL AND p_VARIABLE_TYPE IS NULL THEN
161: l_qry_with_no_var := 'Y';
162: ELSE
163: CSM_UTIL_PKG.LOG
164: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
165: FND_LOG.LEVEL_ERROR);
166:
167: x_return_status := FND_API.G_RET_STS_ERROR;

Line 228: CSM_UTIL_PKG.LOG( 'Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,

224:
225: END LOOP;
226: END IF;
227:
228: CSM_UTIL_PKG.LOG( 'Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
229: FND_LOG.LEVEL_ERROR);
230: x_error_message := 'Query insert is Successful for Query Name: ' || p_QUERY_NAME ;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:

Line 235: CSM_UTIL_PKG.LOG

231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: EXCEPTION WHEN OTHERS THEN
234: /*** catch and log exceptions ***/
235: CSM_UTIL_PKG.LOG
236: ( 'Exception occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
237: FND_LOG.LEVEL_EXCEPTION);
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||

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 316: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);

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
316: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);
317: p_error_msg := 'Parent Query Id is Invalid for Query Id : ' || l_query_id ;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: RETURN;
320: END IF;

Line 329: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);

325: l_QUERY_OUTPUT_FORMAT, l_MIME_TYPE, l_WORK_FLOW, l_RETENTION_POLICY,
326: l_RETENTION_DAYS,l_TEMPLATE, l_TEMPLATE_FILE, l_EXECUTION_MODE;
327:
328: IF c_check_query%NOTFOUND THEN
329: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);
330: p_error_msg := 'Parent Query Id is Invalid for Query Id : ' || l_query_id ;
331: CLOSE c_check_query;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: RETURN;

Line 393: CSM_UTIL_PKG.LOG( 'Query Upload Failed for Query ID : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

389: x_error_message => p_error_msg);
390:
391:
392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: CSM_UTIL_PKG.LOG( 'Query Upload Failed for Query ID : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
394: p_error_msg := 'Query Upload Failed for Query ID : '|| l_query_id || ' with error ' || p_error_msg;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: RETURN;
397: END IF;

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 407: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || SUBSTR(SQLERRM,1,3000)

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

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 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 483: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || SUBSTR(SQLERRM,1,3000)

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

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 526: CSM_UTIL_PKG.LOG

522: );
523:
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

Line 530: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
533: , p_token_name1 => 'DML'
534: , p_token_value1 => p_record.dmltype$$

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 544: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
546: p_api_error => TRUE
547: );
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || SUBSTR(SQLERRM,1,3000)

Line 548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || SUBSTR(SQLERRM,1,3000)

544: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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:

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 592: CSM_UTIL_PKG.DELETE_RECORD

588:
589: /*** was record processed successfully? ***/
590: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
591: /*** Yes -> delete record from inqueue ***/
592: CSM_UTIL_PKG.DELETE_RECORD
593: (
594: p_user_name,
595: p_tranid,
596: r_query_rec.seqno$$,

Line 605: CSM_UTIL_PKG.DELETE_RECORD

601: l_process_status
602: );
603: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
604: FOR r_query_var_inq_rec IN c_query_var_inq( p_user_name, p_tranid,r_query_rec.QUERY_ID ) LOOP
605: CSM_UTIL_PKG.DELETE_RECORD
606: (
607: p_user_name,
608: p_tranid,
609: r_query_var_inq_rec.seqno$$,

Line 622: CSM_UTIL_PKG.LOG

618: END IF;
619: /*** was delete successful? ***/
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;

Line 630: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

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

Line 633: CSM_UTIL_PKG.DEFER_RECORD

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
636: , p_tranid
637: , r_query_rec.seqno$$

Line 648: CSM_UTIL_PKG.DEFER_RECORD

644: );
645:
646: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
647: FOR r_query_var_inq_rec IN c_query_var_inq( p_user_name, p_tranid,r_query_rec.QUERY_ID ) LOOP
648: CSM_UTIL_PKG.DEFER_RECORD
649: (
650: p_user_name,
651: p_tranid,
652: r_query_var_inq_rec.seqno$$,

Line 666: CSM_UTIL_PKG.LOG

662: END IF;
663: /*** Was defer successful? ***/
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;

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 681: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

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
682: ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
683:
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: