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_QUERY_PUB dependencies on FND_LOG

Line 61: FND_LOG.LEVEL_ERROR);

57: AS
58: BEGIN
59: CSM_UTIL_PKG.LOG
60: ( 'Entering INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
61: FND_LOG.LEVEL_ERROR);
62:
63: SAVEPOINT CSM_INSERT_QUERY_PUB;
64:
65: CSM_QUERY_PKG.INSERT_QUERY

Line 101: FND_LOG.LEVEL_EXCEPTION);

97:
98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
99: CSM_UTIL_PKG.LOG
100: ( 'Error occurred in Insert Query for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
101: FND_LOG.LEVEL_EXCEPTION);
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: x_error_message := 'Query Insert failed : ' || x_error_message;
104: ROLLBACK TO CSM_INSERT_QUERY_PUB;
105: RETURN;

Line 112: FND_LOG.LEVEL_ERROR);

108: IF FND_API.To_Boolean(p_COMMIT) THEN
109: COMMIT WORK;
110: END IF;
111: CSM_UTIL_PKG.LOG( 'Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
112: FND_LOG.LEVEL_ERROR);
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: EXCEPTION WHEN OTHERS THEN
116: /*** catch and log exceptions ***/

Line 119: FND_LOG.LEVEL_EXCEPTION);

115: EXCEPTION WHEN OTHERS THEN
116: /*** catch and log exceptions ***/
117: CSM_UTIL_PKG.LOG
118: ( 'Exception occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
119: FND_LOG.LEVEL_EXCEPTION);
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
122: ' : ' || SUBSTR(SQLERRM,1,3000);
123: ROLLBACK TO CSM_INSERT_QUERY_PUB;

Line 171: FND_LOG.LEVEL_ERROR);

167: AS
168: BEGIN
169: CSM_UTIL_PKG.LOG
170: ( 'Entering UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,
171: FND_LOG.LEVEL_ERROR);
172:
173: SAVEPOINT CSM_UPDATE_QUERY_PUB;
174:
175: CSM_QUERY_PKG.UPDATE_QUERY

Line 210: FND_LOG.LEVEL_EXCEPTION);

206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: CSM_UTIL_PKG.LOG
209: ( 'Exception occurred in UPDATE QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'UPDATE_QUERY',
210: FND_LOG.LEVEL_EXCEPTION);
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: x_error_message := 'Query Update failed : ' || x_error_message;
213: ROLLBACK TO CSM_UPDATE_QUERY_PUB;
214: RETURN;

Line 223: FND_LOG.LEVEL_ERROR);

219: END IF;
220:
221: CSM_UTIL_PKG.LOG
222: ( 'Leaving UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,
223: FND_LOG.LEVEL_ERROR);
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: EXCEPTION WHEN OTHERS THEN
227: /*** catch and log exceptions ***/

Line 230: FND_LOG.LEVEL_EXCEPTION);

226: EXCEPTION WHEN OTHERS THEN
227: /*** catch and log exceptions ***/
228: CSM_UTIL_PKG.LOG
229: ( 'Exception occurred in UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME || SQLERRM, 'UPDATE_QUERY',
230: FND_LOG.LEVEL_EXCEPTION);
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: x_error_message := 'Query Update Failed for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ||
233: ' : ' || SUBSTR(SQLERRM,1,3000);
234: ROLLBACK TO CSM_UPDATE_QUERY_PUB;

Line 253: FND_LOG.LEVEL_ERROR);

249: AS
250: BEGIN
251: CSM_UTIL_PKG.LOG
252: ( 'Entering DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,
253: FND_LOG.LEVEL_ERROR);
254:
255: SAVEPOINT CSM_DELETE_QUERY_PUB;
256:
257: CSM_QUERY_PKG.DELETE_QUERY

Line 267: FND_LOG.LEVEL_EXCEPTION);

263:
264: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
265: CSM_UTIL_PKG.LOG
266: ( 'Exception occurred in DELETE QUERY for Query Id ' || p_QUERY_ID || SQLERRM, 'DELETE_QUERY',
267: FND_LOG.LEVEL_EXCEPTION);
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: x_error_message := 'Query Delete failed : ' || x_error_message;
270: ROLLBACK TO CSM_DELETE_QUERY_PUB;
271: RETURN;

Line 280: FND_LOG.LEVEL_ERROR);

276: END IF;
277:
278: CSM_UTIL_PKG.LOG
279: ( 'Leaving DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,
280: FND_LOG.LEVEL_ERROR);
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: x_error_message := 'Delete Query Call Successful for Query id '|| p_QUERY_ID;
283: EXCEPTION WHEN OTHERS THEN
284: /*** catch and log exceptions ***/

Line 287: FND_LOG.LEVEL_EXCEPTION);

283: EXCEPTION WHEN OTHERS THEN
284: /*** catch and log exceptions ***/
285: CSM_UTIL_PKG.LOG
286: ( 'Exception occurred in DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || SQLERRM, 'DELETE_QUERY',
287: FND_LOG.LEVEL_EXCEPTION);
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: x_error_message := 'Query Delete Failed for Query Id and Query Name : ' || p_QUERY_ID ;
290: ROLLBACK TO CSM_DELETE_QUERY_PUB;
291: END DELETE_QUERY;

Line 310: FND_LOG.LEVEL_ERROR);

306: AS
307: BEGIN
308: CSM_UTIL_PKG.LOG
309: ( 'Entering EXECUTE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,
310: FND_LOG.LEVEL_ERROR);
311: --Query Execution status update
312: SAVEPOINT CSM_EXECUTE_QUERY_PUB;
313:
314: CSM_QUERY_PKG.EXECUTE_QUERY

Line 327: FND_LOG.LEVEL_EXCEPTION);

323:
324: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
325: CSM_UTIL_PKG.LOG
326: ( 'Exception occurred in QUERY Execution for Instance ID ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'EXECUTE_QUERY',
327: FND_LOG.LEVEL_EXCEPTION);
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: x_error_message := 'Query Execution failed : ' || x_error_message;
330: ROLLBACK TO CSM_EXECUTE_QUERY_PUB;
331: RETURN;

Line 341: FND_LOG.LEVEL_ERROR);

337:
338: CSM_UTIL_PKG.LOG
339: ( 'Leaving EXECUTE_QUERY for Query Id and Instance Id after successfully Executing :
340: ' || p_QUERY_ID || '-' || p_INSTANCE_ID ,
341: FND_LOG.LEVEL_ERROR);
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343: x_error_message := 'Query Execution Successful ';
344: EXCEPTION WHEN OTHERS THEN
345: /*** catch and log exceptions ***/

Line 349: FND_LOG.LEVEL_EXCEPTION);

345: /*** catch and log exceptions ***/
346:
347: CSM_UTIL_PKG.LOG
348: ( 'Exception occurred in EXECUTE_QUERY for Instance id : ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'EXECUTE_QUERY',
349: FND_LOG.LEVEL_EXCEPTION);
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: x_error_message := 'Query Execution Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
352: ROLLBACK TO CSM_EXECUTE_QUERY_PUB;
353: END EXECUTE_QUERY;

Line 376: FND_LOG.LEVEL_ERROR);

372: AS
373: BEGIN
374: CSM_UTIL_PKG.LOG
375: ( 'Entering INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,
376: FND_LOG.LEVEL_ERROR);
377:
378: SAVEPOINT CSM_INSERT_INSTANCE_PUB;
379:
380: CSM_QUERY_PKG.INSERT_INSTANCE

Line 397: FND_LOG.LEVEL_EXCEPTION);

393:
394: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
395: CSM_UTIL_PKG.LOG
396: ( 'Exception occurred for Instance ID ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'INSERT_INSTANCE',
397: FND_LOG.LEVEL_EXCEPTION);
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: x_error_message := 'Insert Instance failed : ' || x_error_message;
400: ROLLBACK TO CSM_INSERT_INSTANCE_PUB;
401: RETURN;

Line 410: FND_LOG.LEVEL_ERROR);

406: END IF;
407:
408: CSM_UTIL_PKG.LOG
409: ( 'Leaving INSERT_INSTANCE for Instance Id : ' || x_INSTANCE_ID ,
410: FND_LOG.LEVEL_ERROR);
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: x_error_message := 'Insert Successful for Instance Id : ' || x_INSTANCE_ID ;
413:
414: EXCEPTION WHEN OTHERS THEN

Line 418: FND_LOG.LEVEL_EXCEPTION);

414: EXCEPTION WHEN OTHERS THEN
415: /*** catch and log exceptions ***/
416: CSM_UTIL_PKG.LOG
417: ( 'Exception occurred in INSERT_INSTANCE for Query Id : ' || p_QUERY_ID || SQLERRM, 'EXECUTE_QUERY',
418: FND_LOG.LEVEL_EXCEPTION);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: x_error_message := 'Exception occurred in INSERT_INSTANCE With Message : ' || SUBSTR(SQLERRM,1,3000) ;
421: ROLLBACK TO CSM_INSERT_INSTANCE_PUB;
422: END INSERT_INSTANCE;

Line 439: FND_LOG.LEVEL_ERROR);

435: AS
436: BEGIN
437: CSM_UTIL_PKG.LOG
438: ( 'Entering DELETE_INSTANCE for Instance Id : ' || p_INSTANCE_ID ,
439: FND_LOG.LEVEL_ERROR);
440:
441: SAVEPOINT CSM_DELETE_INSTANCE_PUB;
442:
443: CSM_QUERY_PKG.DELETE_INSTANCE

Line 455: FND_LOG.LEVEL_EXCEPTION);

451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: CSM_UTIL_PKG.LOG
454: ( 'Exception occurred for Instance ID ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'DELETE_INSTANCE',
455: FND_LOG.LEVEL_EXCEPTION);
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: x_error_message := 'Delete Instance failed : ' || x_error_message;
458: ROLLBACK TO CSM_DELETE_INSTANCE_PUB;
459: RETURN;

Line 468: FND_LOG.LEVEL_ERROR);

464: END IF;
465:
466: CSM_UTIL_PKG.LOG
467: ( 'Leaving DELETE_INSTANCE for Query Id and Query Name : ' || p_QUERY_ID ,
468: FND_LOG.LEVEL_ERROR);
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470: x_error_message := 'Delete call Successful for Instance Id : ' || p_INSTANCE_ID ;
471:
472: EXCEPTION WHEN OTHERS THEN

Line 476: FND_LOG.LEVEL_EXCEPTION);

472: EXCEPTION WHEN OTHERS THEN
473: /*** catch and log exceptions ***/
474: CSM_UTIL_PKG.LOG
475: ( 'Exception occurred in DELETE_INSTANCE for Query Id : ' || p_QUERY_ID || SQLERRM, 'DELETE_INSTANCE',
476: FND_LOG.LEVEL_EXCEPTION);
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: x_error_message := 'Exception occurred in DELETE_INSTANCE With Message : ' || SUBSTR(SQLERRM,1,3000) ;
479: ROLLBACK TO CSM_DELETE_INSTANCE_PUB;
480: END DELETE_INSTANCE;

Line 500: FND_LOG.LEVEL_ERROR);

496: AS
497: BEGIN
498: CSM_UTIL_PKG.LOG
499: ( 'Entering INSERT_RESULT for Instance Id : ' || p_INSTANCE_ID ,
500: FND_LOG.LEVEL_ERROR);
501:
502: SAVEPOINT CSM_INSERT_RESULT_PUB;
503:
504: CSM_QUERY_PKG.INSERT_RESULT

Line 517: FND_LOG.LEVEL_EXCEPTION);

513:
514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
515: CSM_UTIL_PKG.LOG
516: ( 'Exception occurred for Instance ID ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'INSERT_RESULT',
517: FND_LOG.LEVEL_EXCEPTION);
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: x_error_message := 'Insert Result for Instance failed : ' || x_error_message;
520: ROLLBACK TO CSM_INSERT_RESULT_PUB;
521: RETURN;

Line 530: FND_LOG.LEVEL_ERROR);

526: END IF;
527:
528: CSM_UTIL_PKG.LOG
529: ( 'Leaving INSERT_RESULT for Instance ID : ' || p_INSTANCE_ID ,
530: FND_LOG.LEVEL_ERROR);
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: x_error_message := 'Insert Result Successful for Instance Id : ' || p_INSTANCE_ID ;
533:
534: EXCEPTION WHEN OTHERS THEN

Line 538: FND_LOG.LEVEL_EXCEPTION);

534: EXCEPTION WHEN OTHERS THEN
535: /*** catch and log exceptions ***/
536: CSM_UTIL_PKG.LOG
537: ( 'Exception occurred in INSERT_RESULT for Instance ID : ' || p_INSTANCE_ID || SQLERRM, 'INSERT_RESULT',
538: FND_LOG.LEVEL_EXCEPTION);
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: x_error_message := 'Exception occurred in INSERT_RESULT With Message : ' || SUBSTR(SQLERRM,1,3000) ;
541: ROLLBACK TO CSM_INSERT_RESULT_PUB;
542: END INSERT_RESULT;