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 FND_LOG

Line 86: FND_LOG.LEVEL_ERROR);

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);
89: FETCH c_get_resp_id INTO l_level_id, l_level_value;
90: CLOSE c_get_resp_id ;

Line 109: FND_LOG.LEVEL_EXCEPTION);

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;
112: RETURN;
113: END IF;

Line 124: FND_LOG.LEVEL_EXCEPTION);

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;
127: RETURN;
128: END IF;

Line 140: FND_LOG.LEVEL_EXCEPTION);

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;
143: RETURN;
144: END IF;

Line 152: FND_LOG.LEVEL_ERROR);

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;
155: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
156: ' because of Variable Name and Variable Type Mismatch' ;

Line 165: FND_LOG.LEVEL_ERROR);

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;
168: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
169: ' because of Variable Name and Variable Type Mismatch' ;

Line 229: FND_LOG.LEVEL_ERROR);

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:
233: EXCEPTION WHEN OTHERS THEN

Line 237: FND_LOG.LEVEL_EXCEPTION);

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 ||
240: ' : ' || SUBSTR(SQLERRM,1,3000);
241: RETURN;

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 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 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 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 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 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 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 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 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;