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_PKG dependencies on FND_API

Line 147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

143: p_RESPONSIBILITY_ID => l_responsibility_id,
144: x_return_status => l_return_status,
145: x_error_message => l_return_message);
146:
147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: CSM_UTIL_PKG.LOG
149: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
150: FND_LOG.LEVEL_EXCEPTION);
151: x_return_status := FND_API.G_RET_STS_ERROR;

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: CSM_UTIL_PKG.LOG
149: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
150: FND_LOG.LEVEL_EXCEPTION);
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: x_error_message := 'Query Access Validation failed : ' || l_return_message;
153: RETURN;
154: END IF;
155: --Validate the Query

Line 162: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

158: p_QUERY_TEXT2 => p_QUERY_TEXT2,
159: x_return_status => l_return_status,
160: x_error_message => l_return_message);
161:
162: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: CSM_UTIL_PKG.LOG
164: ( 'Exception occurred in VALIDATE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
165: FND_LOG.LEVEL_EXCEPTION);
166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 166: x_return_status := FND_API.G_RET_STS_ERROR;

162: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: CSM_UTIL_PKG.LOG
164: ( 'Exception occurred in VALIDATE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
165: FND_LOG.LEVEL_EXCEPTION);
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: x_error_message := 'Query Validation failed : ' || l_return_message;
168: RETURN;
169: END IF;
170: ELSIF UPPER(P_QUERY_TYPE) ='WORKFLOW' THEN

Line 178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

174: p_VARIABLE_NAME => p_VARIABLE_NAME,
175: x_return_status => l_return_status,
176: x_error_message => l_return_message
177: );
178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
179: CSM_UTIL_PKG.LOG
180: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
181: FND_LOG.LEVEL_EXCEPTION);
182: x_return_status := FND_API.G_RET_STS_ERROR;

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
179: CSM_UTIL_PKG.LOG
180: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
181: FND_LOG.LEVEL_EXCEPTION);
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: x_error_message := 'Query Validation failed : ' || l_return_message;
184: RETURN;
185: END IF;
186:

Line 196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

192: x_return_status => l_return_status,
193: x_error_message => l_return_message
194: );
195:
196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
197: CSM_UTIL_PKG.LOG
198: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
199: FND_LOG.LEVEL_EXCEPTION);
200: x_return_status := FND_API.G_RET_STS_ERROR;

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
197: CSM_UTIL_PKG.LOG
198: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
199: FND_LOG.LEVEL_EXCEPTION);
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_error_message := 'Query Validation failed : ' || l_return_message;
202: RETURN;
203: END IF;
204: END IF;

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: CSM_UTIL_PKG.LOG
210: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,'CSM_QUERY_PKG.INSERT_QUERY',
211: FND_LOG.LEVEL_ERROR);
212:
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
215: ' because of Variable Name and Variable Type Mismatch' ;
216: RETURN;
217: END IF;

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: CSM_UTIL_PKG.LOG
223: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,'CSM_QUERY_PKG.INSERT_QUERY',
224: FND_LOG.LEVEL_ERROR);
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
228: ' because of Variable Name and Variable Type Mismatch' ;
229: RETURN;
230: END IF;

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: COMMIT;
288: CSM_UTIL_PKG.LOG( 'Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,'CSM_QUERY_PKG.INSERT_QUERY',
289: FND_LOG.LEVEL_ERROR);
290:
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: EXCEPTION WHEN OTHERS THEN
294: /*** catch and log exceptions ***/
295: CSM_UTIL_PKG.LOG

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: /*** catch and log exceptions ***/
295: CSM_UTIL_PKG.LOG
296: ( 'Exception occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.INSERT_QUERY',
297: FND_LOG.LEVEL_EXCEPTION);
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
300: ' : ' || SUBSTR(SQLERRM,1,3000);
301: ROLLBACK;
302: END INSERT_QUERY;

Line 383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

379: p_RESPONSIBILITY_ID => l_responsibility_id,
380: x_return_status => l_return_status,
381: x_error_message => l_return_message);
382:
383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: CSM_UTIL_PKG.LOG
385: ( 'Exception occurred in VALIDATE_Access for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
386: FND_LOG.LEVEL_EXCEPTION);
387: x_return_status := FND_API.G_RET_STS_ERROR;

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: CSM_UTIL_PKG.LOG
385: ( 'Exception occurred in VALIDATE_Access for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
386: FND_LOG.LEVEL_EXCEPTION);
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: x_error_message := 'Query Access Validation failed : ' || l_return_message;
389: RETURN;
390: END IF;
391:

Line 399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

395: p_QUERY_TEXT2 => p_QUERY_TEXT2,
396: x_return_status => l_return_status,
397: x_error_message => l_return_message);
398:
399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
400: CSM_UTIL_PKG.LOG
401: ( 'Exception occurred in VALIDATE_QUERY for Query Id ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
402: FND_LOG.LEVEL_EXCEPTION);
403: x_return_status := FND_API.G_RET_STS_ERROR;

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
400: CSM_UTIL_PKG.LOG
401: ( 'Exception occurred in VALIDATE_QUERY for Query Id ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
402: FND_LOG.LEVEL_EXCEPTION);
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: x_error_message := 'Query Validation failed : ' || l_return_message;
405: RETURN;
406: END IF;
407: ELSIF UPPER(P_QUERY_TYPE) ='WORKFLOW' THEN

Line 415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

411: p_VARIABLE_NAME => p_VARIABLE_NAME,
412: x_return_status => l_return_status,
413: x_error_message => l_return_message
414: );
415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: CSM_UTIL_PKG.LOG
417: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
418: FND_LOG.LEVEL_EXCEPTION);
419: x_return_status := FND_API.G_RET_STS_ERROR;

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: CSM_UTIL_PKG.LOG
417: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
418: FND_LOG.LEVEL_EXCEPTION);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: x_error_message := 'Query Validation failed : ' || l_return_message;
421: RETURN;
422: END IF;
423:

Line 431: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

427: p_PROCEDURE => p_PROCEDURE,
428: x_return_status => l_return_status,
429: x_error_message => l_return_message
430: );
431: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: CSM_UTIL_PKG.LOG
433: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
434: FND_LOG.LEVEL_EXCEPTION);
435: x_return_status := FND_API.G_RET_STS_ERROR;

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: CSM_UTIL_PKG.LOG
433: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
434: FND_LOG.LEVEL_EXCEPTION);
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: x_error_message := 'Query Validation failed : ' || l_return_message;
437: RETURN;
438: END IF;
439: END IF;

Line 457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

453: x_return_status => l_return_status,
454: x_error_message => l_return_message
455: );
456:
457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
458: CSM_UTIL_PKG.LOG
459: ( 'ERROR occurred in DELETE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
460: FND_LOG.LEVEL_EXCEPTION);
461: x_return_status := FND_API.G_RET_STS_ERROR;

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
458: CSM_UTIL_PKG.LOG
459: ( 'ERROR occurred in DELETE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
460: FND_LOG.LEVEL_EXCEPTION);
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: x_error_message := 'Query Delete failed durin Update: ' || l_return_message;
463: RETURN;
464: ELSE --Insert the query again for the new responsibility
465: INSERT_QUERY

Line 498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

494: x_return_status => l_return_status,
495: x_error_message => l_return_message
496: );
497:
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: CSM_UTIL_PKG.LOG
500: ( 'ERROR occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SUBSTR(SQLERRM,1,3000) , 'CSM_QUERY_PKG.UPDATE_QUERY',
501: FND_LOG.LEVEL_EXCEPTION);
502: x_return_status := FND_API.G_RET_STS_ERROR;

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: CSM_UTIL_PKG.LOG
500: ( 'ERROR occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SUBSTR(SQLERRM,1,3000) , 'CSM_QUERY_PKG.UPDATE_QUERY',
501: FND_LOG.LEVEL_EXCEPTION);
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: x_error_message := 'INSERT_QUERY failed during UPDATE: ' || l_return_message;
504: ROLLBACK;
505: RETURN;
506: ELSE

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506: ELSE
507: CSM_UTIL_PKG.LOG
508: ( 'Leaving CSM_QUERY_PKG.UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
509: FND_LOG.LEVEL_ERROR);
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511: COMMIT;
512: RETURN;
513: END IF;
514:

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: CSM_UTIL_PKG.LOG
548: ( 'Variable Name and Variable Type Mismatch: Leaving UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
549: FND_LOG.LEVEL_ERROR);
550:
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: x_error_message := ' UPDATE_QUERY Failed for Query Id and Query Name : ' || p_QUERY_ID || ' : ' ||
553: p_QUERY_NAME || ' because of Variable Name and Variable Type Mismatch';
554: RETURN;
555: END IF;

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: CSM_UTIL_PKG.LOG
561: ( 'Variable Name and Variable Type Mismatch: Leaving UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
562: FND_LOG.LEVEL_ERROR);
563:
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: x_error_message := ' UPDATE_QUERY Failed for Query Id and Query Name : ' || p_QUERY_ID || ' : ' ||
566: p_QUERY_NAME || ' because of Variable Name and Variable Type Mismatch';
567: RETURN;
568: END IF;

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630: COMMIT;
631: CSM_UTIL_PKG.LOG
632: ( 'Leaving UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
633: FND_LOG.LEVEL_ERROR);
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635: EXCEPTION WHEN OTHERS THEN
636: /*** catch and log exceptions ***/
637: CSM_UTIL_PKG.LOG
638: ( 'Exception occurred in UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',

Line 640: x_return_status := FND_API.G_RET_STS_ERROR;

636: /*** catch and log exceptions ***/
637: CSM_UTIL_PKG.LOG
638: ( 'Exception occurred in UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME || SQLERRM, 'CSM_QUERY_PKG.UPDATE_QUERY',
639: FND_LOG.LEVEL_EXCEPTION);
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: x_error_message := 'Query Update Failed for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ||
642: ' : ' || SUBSTR(SQLERRM,1,3000);
643: ROLLBACK;
644: END UPDATE_QUERY;

Line 682: x_return_status := FND_API.G_RET_STS_SUCCESS;

678:
679: CSM_UTIL_PKG.LOG
680: ( 'Leaving DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.DELETE_QUERY',
681: FND_LOG.LEVEL_ERROR);
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683: EXCEPTION WHEN OTHERS THEN
684: /*** catch and log exceptions ***/
685: CSM_UTIL_PKG.LOG
686: ( 'Exception occurred in DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.DELETE_QUERY',

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684: /*** catch and log exceptions ***/
685: CSM_UTIL_PKG.LOG
686: ( 'Exception occurred in DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.DELETE_QUERY',
687: FND_LOG.LEVEL_EXCEPTION);
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_error_message := 'Query Delete Failed for Query Id and Query Name : ' || p_QUERY_ID ;
690: END DELETE_QUERY;
691:
692: /***

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738:
739: IF l_QUERY_TEXT1 IS NULL AND l_QUERY_TEXT2 IS NULL THEN
740: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_QUERY for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_QUERY',
741: FND_LOG.LEVEL_EXCEPTION);
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: x_error_message := 'Query Text is Empty ';
744: RETURN;
745: END IF;
746:

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: CSM_UTIL_PKG.LOG
777: ( 'Leaving VALIDATE_QUERY for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_QUERY',
778: FND_LOG.LEVEL_ERROR);
779:
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: END IF;
782:
783: EXCEPTION WHEN OTHERS THEN
784: /*** catch and log exceptions ***/

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

785: dbms_sql.close_cursor(cursor_name);
786: CSM_UTIL_PKG.LOG
787: ( 'Exception occurred in VALIDATE_QUERY for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.VALIDATE_QUERY',
788: FND_LOG.LEVEL_EXCEPTION);
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: x_error_message := 'Query Validation Failed With Message : ' || SQLERRM ;
791: END VALIDATE_QUERY;
792:
793:

Line 804: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,

800: p_QUERY_ID IN NUMBER,
801: p_INSTANCE_ID IN NUMBER,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_error_message OUT NOCOPY VARCHAR2,
804: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
805: p_source_module IN VARCHAR2 DEFAULT 'MOBILEADMIN'
806: )
807: AS
808: CURSOR c_check_query(c_QUERY_ID NUMBER)

Line 917: x_return_status := FND_API.G_RET_STS_ERROR;

913: OPEN c_check_query(p_QUERY_ID);
914: FETCH c_check_query INTO l_QUERY_TEXT1, l_QUERY_TEXT2,l_QUERY_TYPE,l_WORK_FLOW, l_PROCEDURE_NAME;
915: IF c_check_query%NOTFOUND THEN
916: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.EXECUTE_QUERY',FND_LOG.LEVEL_ERROR);
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_error_message := 'Invalid Query Id : ' || p_QUERY_ID ;
919: CLOSE c_check_query;
920: ROLLBACK TO EXECUTE_QUERY;
921: RETURN;

Line 933: x_return_status := FND_API.G_RET_STS_ERROR;

929: OPEN c_check_instance(p_USER_ID, p_QUERY_ID, p_INSTANCE_ID);
930: FETCH c_check_instance INTO l_instance_id;
931: IF c_check_instance%NOTFOUND THEN
932: CSM_UTIL_PKG.LOG( 'The User : ' || p_USER_ID || ' does not have valid Instance ID : ' || p_INSTANCE_ID ,'CSM_QUERY_PKG.EXECUTE_QUERY',FND_LOG.LEVEL_ERROR);
933: x_return_status := FND_API.G_RET_STS_ERROR;
934: x_error_message := 'The User : ' || p_USER_ID || ' does not have valid Instance ID : ' || p_INSTANCE_ID ;
935: CLOSE c_check_instance;
936: ROLLBACK TO EXECUTE_QUERY;
937: RETURN;

Line 1007: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1003:
1004: DBMS_SQL.CLOSE_CURSOR (l_cursor_name);
1005: x_error_message := l_return_message;
1006:
1007: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1008: UPDATE_EXE_STATUS( p_USER_ID, p_QUERY_ID, p_INSTANCE_ID,
1009: NULL,SYSDATE,'ERROR','Query Completed with Error: '||SUBSTR(l_return_message,1,3000));
1010: x_error_message := l_return_message;
1011: G_INST_IN_PROCESS:=NULL;

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083: OPEN c_get_wf_root(l_item_type);
1084: FETCH c_get_wf_root INTO l_root_process;
1085: IF c_get_wf_root%NOTFOUND THEN
1086: CSM_UTIL_PKG.LOG( 'The Workflow : ' || l_item_type || ' does not have valid Root Process ' ,'CSM_QUERY_PKG.EXECUTE_QUERY',FND_LOG.LEVEL_ERROR);
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: x_error_message := 'The Workflow : ' || l_item_type || ' does not have valid Root Process ' ;
1089: CLOSE c_get_wf_root;
1090: ROLLBACK TO EXECUTE_QUERY;
1091: RETURN;

Line 1143: IF FND_API.To_Boolean(p_commit) THEN

1139: NULL,SYSDATE,'RUNNING','Query Successfully Executed');
1140:
1141: END IF;--Query Type
1142:
1143: IF FND_API.To_Boolean(p_commit) THEN
1144: COMMIT WORK;
1145: END IF;
1146:
1147: IF UPPER(l_QUERY_TYPE) ='SQL' AND l_rs_access_id IS NULL THEN

Line 1157: x_return_status := FND_API.G_RET_STS_SUCCESS;

1153: CSM_UTIL_PKG.LOG
1154: ( 'Leaving EXECUTE_QUERY for Query Id and Instance Id after successfully Executing :
1155: ' || p_QUERY_ID || '-' || p_INSTANCE_ID ,'CSM_QUERY_PKG.EXECUTE_QUERY',
1156: FND_LOG.LEVEL_ERROR);
1157: x_return_status := FND_API.G_RET_STS_SUCCESS;
1158:
1159: EXCEPTION WHEN OTHERS THEN
1160: /*** catch and log exceptions ***/
1161:

Line 1165: x_return_status := FND_API.G_RET_STS_ERROR;

1161:
1162: CSM_UTIL_PKG.LOG
1163: ( 'Exception occurred in EXECUTE_QUERY for Instance id : ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'CSM_QUERY_PKG.EXECUTE_QUERY',
1164: FND_LOG.LEVEL_EXCEPTION);
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_error_message := 'Query Execution Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
1167: IF FND_API.To_Boolean(p_commit) AND p_source_module ='MOBILEADMIN' THEN
1168: UPDATE_EXE_STATUS( p_USER_ID, p_QUERY_ID, p_INSTANCE_ID,
1169: NULL,SYSDATE,'ERROR','Query Completed with Error'||SUBSTR(SQLERRM,1,3000) );

Line 1167: IF FND_API.To_Boolean(p_commit) AND p_source_module ='MOBILEADMIN' THEN

1163: ( 'Exception occurred in EXECUTE_QUERY for Instance id : ' || p_INSTANCE_ID || SUBSTR(SQLERRM,1,3000), 'CSM_QUERY_PKG.EXECUTE_QUERY',
1164: FND_LOG.LEVEL_EXCEPTION);
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_error_message := 'Query Execution Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
1167: IF FND_API.To_Boolean(p_commit) AND p_source_module ='MOBILEADMIN' THEN
1168: UPDATE_EXE_STATUS( p_USER_ID, p_QUERY_ID, p_INSTANCE_ID,
1169: NULL,SYSDATE,'ERROR','Query Completed with Error'||SUBSTR(SQLERRM,1,3000) );
1170: COMMIT WORK;
1171: ELSE

Line 1186: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,

1182: p_INSTANCE_NAME IN VARCHAR2,
1183: p_VARIABLE_ID IN CSM_INTEGER_LIST,
1184: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
1185: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
1186: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
1187: x_INSTANCE_ID OUT NOCOPY NUMBER,
1188: x_return_status OUT NOCOPY VARCHAR2,
1189: x_error_message OUT NOCOPY VARCHAR2
1190: )

Line 1254: x_return_status := FND_API.G_RET_STS_ERROR;

1250: OPEN c_check_query(p_QUERY_ID);
1251: FETCH c_check_query INTO l_instance_name, l_level_id, l_level_value,l_query_type;
1252: IF c_check_query%NOTFOUND THEN
1253: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',FND_LOG.LEVEL_ERROR);
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: x_error_message := 'Invalid Query Id : ' || p_QUERY_ID ;
1256: CLOSE c_check_query;
1257: RETURN;
1258: END IF;

Line 1273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1269: p_RESPONSIBILITY_ID => l_responsibility_id,
1270: x_return_status => l_return_status,
1271: x_error_message => l_return_message);
1272:
1273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1274: CSM_UTIL_PKG.LOG
1275: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || l_instance_name || SQLERRM, 'CSM_QUERY_PKG.INSERT_INSTANCE',
1276: FND_LOG.LEVEL_EXCEPTION);
1277: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1274: CSM_UTIL_PKG.LOG
1275: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || l_instance_name || SQLERRM, 'CSM_QUERY_PKG.INSERT_INSTANCE',
1276: FND_LOG.LEVEL_EXCEPTION);
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: x_error_message := 'Query Access Validation failed : ' || l_return_message;
1279:
1280: RETURN;
1281: END IF;

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

1283: /*OPEN c_check_query_acc(p_QUERY_ID, p_USER_ID);
1284: FETCH c_check_query_acc INTO l_dummy_qry_id;
1285: IF c_check_query_acc%NOTFOUND THEN
1286: CSM_UTIL_PKG.LOG( 'User does not have access to the Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',FND_LOG.LEVEL_ERROR);
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: x_error_message := 'User does not have access to the Query Id : ' || p_QUERY_ID ||
1289: '. Please run the Concurrent program and try again';
1290: CLOSE c_check_query_acc;
1291: RETURN;

Line 1334: IF FND_API.To_Boolean(p_commit) THEN

1330: CLOSE c_get_variables;
1331:
1332: IF l_variable_id_lst.COUNT = 0 THEN
1333:
1334: IF FND_API.To_Boolean(p_commit) THEN
1335: COMMIT WORK;
1336: END IF;
1337: CSM_UTIL_PKG.LOG
1338: ( 'Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',

Line 1341: x_return_status := FND_API.G_RET_STS_SUCCESS;

1337: CSM_UTIL_PKG.LOG
1338: ( 'Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1339: FND_LOG.LEVEL_ERROR);
1340:
1341: x_return_status := FND_API.G_RET_STS_SUCCESS;
1342: x_error_message := 'Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ;
1343: RETURN;
1344:
1345: END IF;

Line 1351: x_return_status := FND_API.G_RET_STS_ERROR;

1347: IF l_variable_id_lst.COUNT <> p_VARIABLE_ID.COUNT THEN
1348: CSM_UTIL_PKG.LOG
1349: ( 'Variable Count mismatch.Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1350: FND_LOG.LEVEL_ERROR);
1351: x_return_status := FND_API.G_RET_STS_ERROR;
1352: x_error_message := 'Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ;
1353: ROLLBACK TO INSERT_INSTANCE;
1354: RETURN;
1355: END IF;

Line 1363: x_return_status := FND_API.G_RET_STS_ERROR;

1359: IF p_VARIABLE_VALUE_DATE(i) IS NULL THEN
1360: CSM_UTIL_PKG.LOG
1361: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1362: FND_LOG.LEVEL_ERROR);
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: x_error_message := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ;
1365: ROLLBACK TO INSERT_INSTANCE;
1366: RETURN;
1367: END IF;

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR;

1370: IF p_VARIABLE_VALUE_CHAR(i) IS NULL THEN
1371: CSM_UTIL_PKG.LOG
1372: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1373: FND_LOG.LEVEL_ERROR);
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: x_error_message := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ;
1376:
1377: ROLLBACK TO INSERT_INSTANCE;
1378: RETURN;

Line 1410: IF FND_API.To_Boolean(p_commit) THEN

1406: p_timestamp => sysdate);
1407: END IF;
1408: END LOOP;
1409:
1410: IF FND_API.To_Boolean(p_commit) THEN
1411: COMMIT WORK;
1412: END IF;
1413:
1414: x_INSTANCE_ID := l_instance_id;

Line 1418: x_return_status := FND_API.G_RET_STS_SUCCESS;

1414: x_INSTANCE_ID := l_instance_id;
1415: CSM_UTIL_PKG.LOG
1416: ( 'Leaving INSERT_INSTANCE for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1417: FND_LOG.LEVEL_ERROR);
1418: x_return_status := FND_API.G_RET_STS_SUCCESS;
1419: x_error_message := 'Insert Successful for Instance Id : ' || p_INSTANCE_ID ;
1420: EXCEPTION WHEN OTHERS THEN
1421: /*** catch and log exceptions ***/
1422: CSM_UTIL_PKG.LOG

Line 1425: x_return_status := FND_API.G_RET_STS_ERROR;

1421: /*** catch and log exceptions ***/
1422: CSM_UTIL_PKG.LOG
1423: ( 'Exception occurred in INSERT_INSTANCE for Query Id : ' || p_QUERY_ID || SQLERRM,'CSM_QUERY_PKG.INSERT_INSTANCE',
1424: FND_LOG.LEVEL_EXCEPTION);
1425: x_return_status := FND_API.G_RET_STS_ERROR;
1426: x_error_message := 'Exception occurred in INSERT_INSTANCE With Message : ' || SUBSTR(SQLERRM,1,3000) ;
1427:
1428: ROLLBACK TO INSERT_INSTANCE;
1429: END INSERT_INSTANCE;

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485:
1486: IF l_MQ_SCHEMA IS NULL THEN
1487: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',
1488: FND_LOG.LEVEL_EXCEPTION);
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_error_message := 'The Schema to Execute the Query is Null.Please set the profile CSM: Mobile Query Schema Name';
1491:
1492: RETURN;
1493: END IF;

Line 1508: x_return_status := FND_API.G_RET_STS_ERROR;

1504:
1505: IF l_QUERY_TEXT1 IS NULL AND l_QUERY_TEXT2 IS NULL THEN
1506: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',
1507: FND_LOG.LEVEL_EXCEPTION);
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509: x_error_message := 'Query Text is Empty ';
1510: RETURN;
1511: END IF;
1512: l_query_clob := l_QUERY_TEXT1 || l_QUERY_TEXT2;

Line 1528: x_return_status := FND_API.G_RET_STS_ERROR;

1524:
1525: IF l_from_count-1 = 0 THEN
1526: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',
1527: FND_LOG.LEVEL_EXCEPTION);
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: x_error_message := 'Query Does not have any From Please check the Query ';
1530:
1531: RETURN;
1532: END IF;

Line 1577: x_return_status := FND_API.G_RET_STS_ERROR;

1573: FETCH c_check_table_access INTO l_dummy;
1574: IF c_check_table_access%NOTFOUND THEN
1575: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID,'CSM_QUERY_PKG.VALIDATE_ACCESS',
1576: FND_LOG.LEVEL_EXCEPTION);
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578: x_error_message := 'The Object : ' || l_TABLE_LIST(j) || ' does not present in the Mobile Query Schema :' || l_MQ_SCHEMA || ' Please Check.' ;
1579: CLOSE c_check_table_access;
1580: RETURN;
1581: END IF;

Line 1588: x_return_status := FND_API.G_RET_STS_SUCCESS;

1584:
1585: CSM_UTIL_PKG.LOG
1586: ( 'Query Validation Succeeded for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_ACCESS',
1587: FND_LOG.LEVEL_ERROR);
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589: x_error_message := 'ACCESS VALIDATION SUCCESSFUL FOR QUERY ID : ' || p_QUERY_ID;
1590: END IF;
1591:
1592: EXCEPTION WHEN OTHERS THEN

Line 1597: x_return_status := FND_API.G_RET_STS_ERROR;

1593: /*** catch and log exceptions ***/
1594: CSM_UTIL_PKG.LOG
1595: ( 'Exception occurred in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.VALIDATE_ACCESS',
1596: FND_LOG.LEVEL_EXCEPTION);
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: x_error_message := 'Query Validation Failed With Message : ' || SQLERRM ;
1599:
1600: END VALIDATE_ACCESS;
1601:

Line 1608: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,

1604: PROCEDURE DELETE_INSTANCE
1605: ( p_USER_ID IN NUMBER,
1606: p_QUERY_ID IN NUMBER,
1607: p_INSTANCE_ID IN NUMBER,
1608: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
1609: x_return_status OUT NOCOPY VARCHAR2,
1610: x_error_message OUT NOCOPY VARCHAR2
1611: )
1612: AS

Line 1655: x_return_status := FND_API.G_RET_STS_ERROR;

1651: CLOSE c_get_instance;
1652:
1653: IF l_access_id IS NULL THEN
1654: CSM_UTIL_PKG.LOG( 'Invalid Instance Id : ' || p_INSTANCE_ID ,'CSM_QUERY_PKG.DELETE_INSTANCE',FND_LOG.LEVEL_ERROR);
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656: x_error_message := 'Invalid Instance Id : ' || p_INSTANCE_ID ;
1657: ROLLBACK TO DELETE_INSTANCE;
1658: RETURN;
1659: END IF;

Line 1710: IF FND_API.To_Boolean(p_commit) THEN

1706: p_timestamp => sysdate);
1707: END LOOP;
1708: END IF;
1709:
1710: IF FND_API.To_Boolean(p_commit) THEN
1711: COMMIT WORK;
1712: END IF;
1713:
1714: CSM_UTIL_PKG.LOG

Line 1717: x_return_status := FND_API.G_RET_STS_SUCCESS;

1713:
1714: CSM_UTIL_PKG.LOG
1715: ( 'Leaving DELETE_INSTANCE for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.DELETE_INSTANCE',
1716: FND_LOG.LEVEL_ERROR);
1717: x_return_status := FND_API.G_RET_STS_SUCCESS;
1718: x_error_message := 'Delete call Successful for Instance Id : ' || p_INSTANCE_ID ;
1719:
1720: EXCEPTION WHEN OTHERS THEN
1721: /*** catch and log exceptions ***/

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: /*** catch and log exceptions ***/
1722: CSM_UTIL_PKG.LOG
1723: ( 'Exception occurred in DELETE_INSTANCE for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.DELETE_INSTANCE',
1724: FND_LOG.LEVEL_EXCEPTION);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: x_error_message := 'Exception occurred in DELETE_INSTANCE With Message : ' || SUBSTR(SQLERRM,1,3000) ;
1727: ROLLBACK TO DELETE_INSTANCE;
1728: END DELETE_INSTANCE;
1729:

Line 1782: x_return_status := FND_API.G_RET_STS_ERROR;

1778:
1779: IF l_WORKFLOW IS NULL THEN
1780: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_WORKFLOW for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1781: FND_LOG.LEVEL_EXCEPTION);
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: x_error_message := 'Workflow Name is Empty ';
1784: RETURN;
1785: END IF;
1786:

Line 1797: x_return_status := FND_API.G_RET_STS_ERROR;

1793:
1794: IF l_TEMP_WORKFLOW IS NULL THEN
1795: CSM_UTIL_PKG.LOG( 'The Given Work Flow for Query Id : ' || p_QUERY_ID || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1796: FND_LOG.LEVEL_EXCEPTION);
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: x_error_message := 'The given Workflow Name is not Valid. ';
1799: RETURN;
1800: END IF;
1801: --check if work flow parameters are valid

Line 1813: x_return_status := FND_API.G_RET_STS_ERROR;

1809:
1810: IF l_TEMP_VARIABLE IS NULL THEN
1811: CSM_UTIL_PKG.LOG( 'The Variable : ' || p_VARIABLE_NAME(i) || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1812: FND_LOG.LEVEL_EXCEPTION);
1813: x_return_status := FND_API.G_RET_STS_ERROR;
1814: x_error_message := 'The Variable Name is not Valid : '|| p_VARIABLE_NAME(i);
1815: RETURN;
1816: END IF;
1817:

Line 1826: x_return_status := FND_API.G_RET_STS_SUCCESS;

1822:
1823: CSM_UTIL_PKG.LOG
1824: ( 'Leaving VALIDATE_WORKFLOW for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1825: FND_LOG.LEVEL_ERROR);
1826: x_return_status := FND_API.G_RET_STS_SUCCESS;
1827:
1828: EXCEPTION WHEN OTHERS THEN
1829: /*** catch and log exceptions ***/
1830: CSM_UTIL_PKG.LOG

Line 1833: x_return_status := FND_API.G_RET_STS_ERROR;

1829: /*** catch and log exceptions ***/
1830: CSM_UTIL_PKG.LOG
1831: ( 'Exception occurred in VALIDATE_WORKFLOW for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1832: FND_LOG.LEVEL_EXCEPTION);
1833: x_return_status := FND_API.G_RET_STS_ERROR;
1834: x_error_message := 'Query Validation Failed With Message : ' || SQLERRM ;
1835: END VALIDATE_WORKFLOW;
1836:
1837: /***

Line 1883: x_return_status := FND_API.G_RET_STS_ERROR;

1879:
1880: IF l_PROCEDURE IS NULL THEN
1881: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',
1882: FND_LOG.LEVEL_EXCEPTION);
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: x_error_message := 'Procedure Name is Empty ';
1885: RETURN;
1886: END IF;
1887:

Line 1901: x_return_status := FND_API.G_RET_STS_ERROR;

1897:
1898: IF c_is_package_valid%NOTFOUND THEN
1899: CSM_UTIL_PKG.LOG( 'The Given Package : ' || l_PACKAGE_NAME || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',
1900: FND_LOG.LEVEL_EXCEPTION);
1901: x_return_status := FND_API.G_RET_STS_ERROR;
1902: x_error_message := 'The Given Package for Query Id : ' || p_QUERY_ID || ' is not Valid.';
1903: RETURN;
1904: END IF;
1905:

Line 1912: x_return_status := FND_API.G_RET_STS_SUCCESS;

1908:
1909: CSM_UTIL_PKG.LOG
1910: ( 'Leaving VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_PROCEDURE',
1911: FND_LOG.LEVEL_ERROR);
1912: x_return_status := FND_API.G_RET_STS_SUCCESS;
1913: EXCEPTION WHEN OTHERS THEN
1914: /*** catch and log exceptions ***/
1915: CSM_UTIL_PKG.LOG
1916: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',

Line 1918: x_return_status := FND_API.G_RET_STS_ERROR;

1914: /*** catch and log exceptions ***/
1915: CSM_UTIL_PKG.LOG
1916: ( 'Exception occurred in VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID || SQLERRM, 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',
1917: FND_LOG.LEVEL_EXCEPTION);
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: x_error_message := 'Query Validation Failed With Message : ' || SQLERRM ;
1920: END VALIDATE_PROCEDURE;
1921:
1922:

Line 1928: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,

1924: ( p_USER_ID IN NUMBER,
1925: p_QUERY_ID IN NUMBER,
1926: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
1927: p_QUERY_RESULT IN BLOB,
1928: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
1929: x_return_status OUT NOCOPY VARCHAR2,
1930: x_error_message OUT NOCOPY VARCHAR2
1931: )
1932: AS

Line 1957: x_return_status := FND_API.G_RET_STS_SUCCESS;

1953:
1954: OPEN c_check_results(p_USER_ID, p_QUERY_ID, p_INSTANCE_ID);
1955: FETCH c_check_results INTO l_rs_access_id;
1956: CLOSE c_check_results;
1957: x_return_status := FND_API.G_RET_STS_SUCCESS;
1958: SAVEPOINT INSERT_RESULT;
1959:
1960: IF p_QUERY_RESULT IS NOT NULL THEN
1961: IF l_rs_access_id IS NOT NULL THEN

Line 2016: IF FND_API.To_Boolean(p_commit) THEN

2012: END IF;
2013: --Update the Status of the Workflow
2014: UPDATE_EXE_STATUS( p_USER_ID, p_QUERY_ID, p_INSTANCE_ID,
2015: NULL,SYSDATE,'EXECUTED','Query Successfully Executed');
2016: IF FND_API.To_Boolean(p_commit) THEN
2017: COMMIT WORK;
2018: END IF;
2019: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_PKG.INSERT_RESULT for Instance ID : ' || p_INSTANCE_ID,
2020: 'CSM_QUERY_PKG.INSERT_RESULT',FND_LOG.LEVEL_EXCEPTION);

Line 2022: x_return_status := FND_API.G_RET_STS_SUCCESS;

2018: END IF;
2019: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_PKG.INSERT_RESULT for Instance ID : ' || p_INSTANCE_ID,
2020: 'CSM_QUERY_PKG.INSERT_RESULT',FND_LOG.LEVEL_EXCEPTION);
2021:
2022: x_return_status := FND_API.G_RET_STS_SUCCESS;
2023: x_error_message := 'Query Result Successfully Inserted into the Access Table';
2024:
2025: EXCEPTION
2026: WHEN OTHERS THEN

Line 2029: x_return_status := FND_API.G_RET_STS_ERROR;

2025: EXCEPTION
2026: WHEN OTHERS THEN
2027: l_sqlerrno := to_char(SQLCODE);
2028: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2029: x_return_status := FND_API.G_RET_STS_ERROR;
2030: x_error_message := l_error_msg;
2031: l_error_msg := ' Exception in CSM_QUERY_PKG for Instance ID :' || to_char(p_INSTANCE_ID)
2032: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
2033: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_QUERY_PKG.INSERT_RESULT',FND_LOG.LEVEL_EXCEPTION);