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_API

Line 24: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

20: ***/
21: PROCEDURE INSERT_QUERY
22: (
23: p_API_VERSION IN NUMBER,
24: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
25: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
26: p_QUERY_ID IN NUMBER,
27: p_QUERY_NAME IN VARCHAR2,
28: P_QUERY_DESC IN VARCHAR2,

Line 25: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

21: PROCEDURE INSERT_QUERY
22: (
23: p_API_VERSION IN NUMBER,
24: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
25: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
26: p_QUERY_ID IN NUMBER,
27: p_QUERY_NAME IN VARCHAR2,
28: P_QUERY_DESC IN VARCHAR2,
29: P_QUERY_TYPE IN VARCHAR2,

Line 98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

94: x_return_status => x_return_status,
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;

Line 102: x_return_status := FND_API.G_RET_STS_ERROR;

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;
106: END IF;

Line 108: IF FND_API.To_Boolean(p_COMMIT) THEN

104: ROLLBACK TO CSM_INSERT_QUERY_PUB;
105: RETURN;
106: END IF;
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);

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ***/
117: CSM_UTIL_PKG.LOG

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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;
124: END INSERT_QUERY;

Line 134: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

130: ***/
131: PROCEDURE UPDATE_QUERY
132: (
133: p_API_VERSION IN NUMBER,
134: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
135: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
136: p_QUERY_ID IN NUMBER,
137: p_QUERY_NAME IN VARCHAR2,
138: P_QUERY_DESC IN VARCHAR2,

Line 135: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

131: PROCEDURE UPDATE_QUERY
132: (
133: p_API_VERSION IN NUMBER,
134: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
135: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
136: p_QUERY_ID IN NUMBER,
137: p_QUERY_NAME IN VARCHAR2,
138: P_QUERY_DESC IN VARCHAR2,
139: P_QUERY_TYPE IN VARCHAR2,

Line 207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

203: p_DISABLED_FLAG => p_DISABLED_FLAG,
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;

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

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;
215: END IF;

Line 217: IF FND_API.To_Boolean(p_COMMIT) THEN

213: ROLLBACK TO CSM_UPDATE_QUERY_PUB;
214: RETURN;
215: END IF;
216:
217: IF FND_API.To_Boolean(p_COMMIT) THEN
218: COMMIT WORK;
219: END IF;
220:
221: CSM_UTIL_PKG.LOG

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ***/
228: CSM_UTIL_PKG.LOG

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

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;
235: END UPDATE_QUERY;

Line 243: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

239: ***/
240: PROCEDURE DELETE_QUERY
241: (
242: p_API_VERSION IN NUMBER,
243: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
244: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
245: p_QUERY_ID IN NUMBER,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_error_message OUT NOCOPY VARCHAR2

Line 244: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

240: PROCEDURE DELETE_QUERY
241: (
242: p_API_VERSION IN NUMBER,
243: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
244: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
245: p_QUERY_ID IN NUMBER,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_error_message OUT NOCOPY VARCHAR2
248: )

Line 264: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

260: x_return_status => x_return_status,
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;

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

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;
272: END IF;

Line 274: IF FND_API.To_Boolean(p_COMMIT) THEN

270: ROLLBACK TO CSM_DELETE_QUERY_PUB;
271: RETURN;
272: END IF;
273:
274: IF FND_API.To_Boolean(p_COMMIT) THEN
275: COMMIT WORK;
276: END IF;
277:
278: CSM_UTIL_PKG.LOG

Line 281: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ***/
285: CSM_UTIL_PKG.LOG

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 298: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

294: This procedure can be used to Execute a given query
295: ***/
296: PROCEDURE EXECUTE_QUERY
297: ( p_API_VERSION IN NUMBER,
298: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
299: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
300: p_USER_ID IN NUMBER,
301: p_QUERY_ID IN NUMBER,
302: p_INSTANCE_ID IN NUMBER,

Line 299: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

295: ***/
296: PROCEDURE EXECUTE_QUERY
297: ( p_API_VERSION IN NUMBER,
298: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
299: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
300: p_USER_ID IN NUMBER,
301: p_QUERY_ID IN NUMBER,
302: p_INSTANCE_ID IN NUMBER,
303: x_return_status OUT NOCOPY VARCHAR2,

Line 324: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

320: x_error_message => x_error_message,
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;

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

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;
332: END IF;

Line 334: IF FND_API.To_Boolean(p_COMMIT) THEN

330: ROLLBACK TO CSM_EXECUTE_QUERY_PUB;
331: RETURN;
332: END IF;
333:
334: IF FND_API.To_Boolean(p_COMMIT) THEN
335: COMMIT WORK;
336: END IF;
337:
338: CSM_UTIL_PKG.LOG

Line 342: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ***/
346:

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 359: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

355: --Procedure to Create a Instance for a Given Query and store in the Acc table
356:
357: PROCEDURE INSERT_INSTANCE
358: ( p_API_VERSION IN NUMBER,
359: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
360: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
361: p_USER_ID IN NUMBER,
362: p_QUERY_ID IN NUMBER,
363: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,

Line 360: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

356:
357: PROCEDURE INSERT_INSTANCE
358: ( p_API_VERSION IN NUMBER,
359: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
360: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
361: p_USER_ID IN NUMBER,
362: p_QUERY_ID IN NUMBER,
363: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
364: p_INSTANCE_NAME IN VARCHAR2,

Line 394: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

390: x_return_status => x_return_status,
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;

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

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;
402: END IF;

Line 404: IF FND_API.To_Boolean(p_COMMIT) THEN

400: ROLLBACK TO CSM_INSERT_INSTANCE_PUB;
401: RETURN;
402: END IF;
403:
404: IF FND_API.To_Boolean(p_COMMIT) THEN
405: COMMIT WORK;
406: END IF;
407:
408: CSM_UTIL_PKG.LOG

Line 411: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
415: /*** catch and log exceptions ***/

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 427: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

423:
424: --Procedure to Delete a Instance for a Given Query
425: PROCEDURE DELETE_INSTANCE
426: ( p_API_VERSION IN NUMBER,
427: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
428: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
429: p_USER_ID IN NUMBER,
430: p_QUERY_ID IN NUMBER,
431: p_INSTANCE_ID IN NUMBER,

Line 428: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

424: --Procedure to Delete a Instance for a Given Query
425: PROCEDURE DELETE_INSTANCE
426: ( p_API_VERSION IN NUMBER,
427: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
428: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
429: p_USER_ID IN NUMBER,
430: p_QUERY_ID IN NUMBER,
431: p_INSTANCE_ID IN NUMBER,
432: x_return_status OUT NOCOPY VARCHAR2,

Line 452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

448: x_return_status => x_return_status,
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;

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

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;
460: END IF;

Line 462: IF FND_API.To_Boolean(p_COMMIT) THEN

458: ROLLBACK TO CSM_DELETE_INSTANCE_PUB;
459: RETURN;
460: END IF;
461:
462: IF FND_API.To_Boolean(p_COMMIT) THEN
463: COMMIT WORK;
464: END IF;
465:
466: CSM_UTIL_PKG.LOG

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
473: /*** catch and log exceptions ***/

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 487: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

483: --Public Procedure to Insert a Result once a Given Query is executed by Custom code
484:
485: PROCEDURE INSERT_RESULT
486: ( p_API_VERSION IN NUMBER,
487: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
488: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
489: p_USER_ID IN NUMBER,
490: p_QUERY_ID IN NUMBER,
491: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,

Line 488: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

484:
485: PROCEDURE INSERT_RESULT
486: ( p_API_VERSION IN NUMBER,
487: p_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
488: p_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
489: p_USER_ID IN NUMBER,
490: p_QUERY_ID IN NUMBER,
491: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
492: p_QUERY_RESULT IN BLOB,

Line 514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

510: x_return_status => x_return_status,
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;

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

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;
522: END IF;

Line 524: IF FND_API.To_Boolean(p_COMMIT) THEN

520: ROLLBACK TO CSM_INSERT_RESULT_PUB;
521: RETURN;
522: END IF;
523:
524: IF FND_API.To_Boolean(p_COMMIT) THEN
525: COMMIT WORK;
526: END IF;
527:
528: CSM_UTIL_PKG.LOG

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
535: /*** catch and log exceptions ***/

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

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