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 CSM_UTIL_PKG

Line 59: CSM_UTIL_PKG.LOG

55: x_error_message OUT NOCOPY VARCHAR2
56: )
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;

Line 99: CSM_UTIL_PKG.LOG

95: x_error_message => x_error_message);
96:
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;

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

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

Line 117: CSM_UTIL_PKG.LOG

113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
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 ||

Line 169: CSM_UTIL_PKG.LOG

165: x_error_message OUT NOCOPY VARCHAR2
166: )
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;

Line 208: CSM_UTIL_PKG.LOG

204: x_return_status => x_return_status,
205: x_error_message => x_error_message);
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;

Line 221: CSM_UTIL_PKG.LOG

217: IF FND_API.To_Boolean(p_COMMIT) THEN
218: COMMIT WORK;
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:

Line 228: CSM_UTIL_PKG.LOG

224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
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 ||

Line 251: CSM_UTIL_PKG.LOG

247: x_error_message OUT NOCOPY VARCHAR2
248: )
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;

Line 265: CSM_UTIL_PKG.LOG

261: x_error_message => x_error_message
262: );
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;

Line 278: CSM_UTIL_PKG.LOG

274: IF FND_API.To_Boolean(p_COMMIT) THEN
275: COMMIT WORK;
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;

Line 285: CSM_UTIL_PKG.LOG

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

Line 308: CSM_UTIL_PKG.LOG

304: x_error_message OUT NOCOPY VARCHAR2
305: )
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;

Line 325: CSM_UTIL_PKG.LOG

321: p_commit => p_COMMIT
322: );
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;

Line 338: CSM_UTIL_PKG.LOG

334: IF FND_API.To_Boolean(p_COMMIT) THEN
335: COMMIT WORK;
336: END IF;
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;

Line 347: CSM_UTIL_PKG.LOG

343: x_error_message := 'Query Execution Successful ';
344: EXCEPTION WHEN OTHERS THEN
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) ;

Line 374: CSM_UTIL_PKG.LOG

370: x_error_message OUT NOCOPY VARCHAR2
371: )
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;

Line 395: CSM_UTIL_PKG.LOG

391: x_error_message => x_error_message
392: );
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;

Line 408: CSM_UTIL_PKG.LOG

404: IF FND_API.To_Boolean(p_COMMIT) THEN
405: COMMIT WORK;
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 ;

Line 416: CSM_UTIL_PKG.LOG

412: x_error_message := 'Insert Successful for Instance Id : ' || x_INSTANCE_ID ;
413:
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) ;

Line 437: CSM_UTIL_PKG.LOG

433: x_error_message OUT NOCOPY VARCHAR2
434: )
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;

Line 453: CSM_UTIL_PKG.LOG

449: x_error_message => x_error_message
450: );
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;

Line 466: CSM_UTIL_PKG.LOG

462: IF FND_API.To_Boolean(p_COMMIT) THEN
463: COMMIT WORK;
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 ;

Line 474: CSM_UTIL_PKG.LOG

470: x_error_message := 'Delete call Successful for Instance Id : ' || p_INSTANCE_ID ;
471:
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) ;

Line 498: CSM_UTIL_PKG.LOG

494: x_error_message OUT NOCOPY VARCHAR2
495: )
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;

Line 515: CSM_UTIL_PKG.LOG

511: x_error_message => x_error_message
512: );
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;

Line 528: CSM_UTIL_PKG.LOG

524: IF FND_API.To_Boolean(p_COMMIT) THEN
525: COMMIT WORK;
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 ;

Line 536: CSM_UTIL_PKG.LOG

532: x_error_message := 'Insert Result Successful for Instance Id : ' || p_INSTANCE_ID ;
533:
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) ;