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 CSM_UTIL_PKG

Line 41: CSM_UTIL_PKG.LOG

37: IS
38: l_access_id NUMBER;
39: l_mark_dirty BOOLEAN;
40: BEGIN
41: CSM_UTIL_PKG.LOG
42: ( 'Entering UPDATE_EXE_STATUS for User ID, Query Id, Instance ID : ' || p_USER_ID ||
43: ':' || p_QUERY_ID || ':' || p_INSTANCE_ID,'CSM_QUERY_PKG.UPDATE_EXE_STATUS',
44: FND_LOG.LEVEL_ERROR);
45:

Line 56: IF csm_util_pkg.is_palm_user(p_USER_ID) AND l_access_id IS NOT NULL THEN

52: AND QUERY_ID = p_QUERY_ID
53: AND INSTANCE_ID = p_INSTANCE_ID
54: RETURNING ACCESS_ID INTO l_access_id;
55:
56: IF csm_util_pkg.is_palm_user(p_USER_ID) AND l_access_id IS NOT NULL THEN
57:
58: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
59: p_accessid => l_access_id,
60: p_userid => p_USER_ID,

Line 65: CSM_UTIL_PKG.LOG

61: p_dml => asg_download.upd,
62: p_timestamp => sysdate);
63: END IF;
64:
65: CSM_UTIL_PKG.LOG
66: ( 'Leaving UPDATE_EXE_STATUS for User ID, Query Id, Instance ID : ' || p_USER_ID ||
67: ':' || p_QUERY_ID || ':' || p_INSTANCE_ID,'CSM_QUERY_PKG.UPDATE_EXE_STATUS',
68: FND_LOG.LEVEL_ERROR);
69:

Line 72: CSM_UTIL_PKG.LOG

68: FND_LOG.LEVEL_ERROR);
69:
70: EXCEPTION WHEN OTHERS THEN
71: /*** catch and log exceptions ***/
72: CSM_UTIL_PKG.LOG
73: ( 'Exception occurred in UPDATE_EXE_STATUS for User ID, Query Id, Instance ID : ' || p_USER_ID ||
74: ':' || p_QUERY_ID || ':' || p_INSTANCE_ID || SQLERRM, 'CSM_QUERY_PKG.UPDATE_EXE_STATUS',
75: FND_LOG.LEVEL_EXCEPTION);
76: RAISE;

Line 130: CSM_UTIL_PKG.LOG

126: l_qry_with_no_var VARCHAR2(1) := 'N';
127: l_responsibility_id NUMBER := NULL;
128: l_VARIABLE_VALUE_CHAR VARCHAR2(4000);
129: BEGIN
130: CSM_UTIL_PKG.LOG
131: ( 'Entering INSERT_QUERY for Query Name :' || p_QUERY_NAME ,'CSM_QUERY_PKG.INSERT_QUERY',
132: FND_LOG.LEVEL_ERROR);
133:
134: IF p_LEVEL_ID = 10003 THEN

Line 148: CSM_UTIL_PKG.LOG

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;
152: x_error_message := 'Query Access Validation failed : ' || l_return_message;

Line 163: CSM_UTIL_PKG.LOG

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;
167: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 179: CSM_UTIL_PKG.LOG

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;
183: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 197: CSM_UTIL_PKG.LOG

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;
201: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 209: CSM_UTIL_PKG.LOG

205:
206: IF p_VARIABLE_NAME IS NOT NULL AND p_VARIABLE_TYPE IS NOT NULL THEN
207:
208: IF p_VARIABLE_NAME.COUNT <> p_VARIABLE_TYPE.COUNT THEN
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;

Line 222: CSM_UTIL_PKG.LOG

218: ELSE
219: IF p_VARIABLE_NAME IS NULL AND p_VARIABLE_TYPE IS NULL THEN
220: l_qry_with_no_var := 'Y';
221: ELSE
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;

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

284: END LOOP;
285: END IF;
286:
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:

Line 295: CSM_UTIL_PKG.LOG

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

Line 366: CSM_UTIL_PKG.LOG

362: l_responsibility_id NUMBER := NULL;
363: l_VARIABLE_VALUE_CHAR VARCHAR2(4000);
364:
365: BEGIN
366: CSM_UTIL_PKG.LOG
367: ( 'Entering UPDATE_QUERY for Query Id and Query Name : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
368: FND_LOG.LEVEL_ERROR);
369:
370: IF p_LEVEL_ID = 10003 THEN

Line 384: CSM_UTIL_PKG.LOG

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;
388: x_error_message := 'Query Access Validation failed : ' || l_return_message;

Line 400: CSM_UTIL_PKG.LOG

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;
404: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 416: CSM_UTIL_PKG.LOG

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;
420: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 432: CSM_UTIL_PKG.LOG

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;
436: x_error_message := 'Query Validation failed : ' || l_return_message;

Line 447: CSM_UTIL_PKG.LOG

443: CLOSE c_get_query;
444:
445: IF p_LEVEL_ID =10003 AND p_LEVEL_VALUE <> l_old_LEVEL_VALUE THEN
446:
447: CSM_UTIL_PKG.LOG
448: ( 'Responsibility Mapping for the query changed : ' || p_QUERY_ID || ' : ' || p_QUERY_NAME ,'CSM_QUERY_PKG.UPDATE_QUERY',
449: FND_LOG.LEVEL_ERROR);
450: --do soft delete to maintain history
451: DELETE_QUERY

Line 458: CSM_UTIL_PKG.LOG

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;
462: x_error_message := 'Query Delete failed durin Update: ' || l_return_message;

Line 499: CSM_UTIL_PKG.LOG

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;
503: x_error_message := 'INSERT_QUERY failed during UPDATE: ' || l_return_message;

Line 507: CSM_UTIL_PKG.LOG

503: x_error_message := 'INSERT_QUERY failed during UPDATE: ' || l_return_message;
504: ROLLBACK;
505: RETURN;
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;

Line 547: CSM_UTIL_PKG.LOG

543:
544: IF p_VARIABLE_NAME IS NOT NULL AND p_VARIABLE_TYPE IS NOT NULL THEN
545:
546: IF p_VARIABLE_NAME.COUNT <> p_VARIABLE_TYPE.COUNT THEN
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;

Line 560: CSM_UTIL_PKG.LOG

556: ELSE
557: IF p_VARIABLE_NAME IS NULL AND p_VARIABLE_TYPE IS NULL THEN
558: l_qry_with_no_var := 'Y';
559: ELSE
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;

Line 631: CSM_UTIL_PKG.LOG

627:
628: END IF;
629:
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

Line 637: CSM_UTIL_PKG.LOG

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',
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 ||

Line 657: CSM_UTIL_PKG.LOG

653: x_error_message OUT NOCOPY VARCHAR2
654: )
655: AS
656: BEGIN
657: CSM_UTIL_PKG.LOG
658: ( 'Entering DELETE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.DELETE_QUERY',
659: FND_LOG.LEVEL_ERROR);
660:
661: --Update the Query Definition in the base table

Line 679: CSM_UTIL_PKG.LOG

675: WHERE PARENT_QUERY_ID = p_QUERY_ID;
676:
677: COMMIT;
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

Line 685: CSM_UTIL_PKG.LOG

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

Line 720: CSM_UTIL_PKG.LOG

716: SELECT QUERY_TEXT1,QUERY_TEXT2
717: FROM CSM_QUERY_B
718: WHERE QUERY_ID = c_QUERY_ID;
719: BEGIN
720: CSM_UTIL_PKG.LOG
721: ( 'Entering VALIDATE_QUERY for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_QUERY',
722: FND_LOG.LEVEL_ERROR);
723:
724: l_QUERY_TEXT1 := p_QUERY_TEXT1;

Line 740: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_QUERY for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_QUERY',

736: --l_QUERY_TEXT1 := REPLACE(l_QUERY_TEXT1,'--','');
737: --l_QUERY_TEXT2 := REPLACE(l_QUERY_TEXT2,'--','');
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;

Line 776: CSM_UTIL_PKG.LOG

772: dbms_sql.parse(cursor_name, l_QUERY_TEXT1,dbms_sql.native);
773: dbms_sql.close_cursor(cursor_name);
774: END IF;
775:
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;

Line 786: CSM_UTIL_PKG.LOG

782:
783: EXCEPTION WHEN OTHERS THEN
784: /*** catch and log exceptions ***/
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 ;

Line 905: CSM_UTIL_PKG.LOG

901: i NUMBER;
902: l_bind_count NUMBER;
903:
904: BEGIN
905: CSM_UTIL_PKG.LOG
906: ( 'Entering EXECUTE_QUERY for Query Id and Query Name : ' || p_QUERY_ID ,'CSM_QUERY_PKG.EXECUTE_QUERY',
907: FND_LOG.LEVEL_ERROR);
908: SAVEPOINT EXECUTE_QUERY;
909:

Line 916: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.EXECUTE_QUERY',FND_LOG.LEVEL_ERROR);

912: SYSDATE,NULL,'RUNNING',NULL);
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;

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

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

Line 1057: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1053: END IF;
1054:
1055: END IF;
1056:
1057: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1058: IF l_rs_access_id IS NULL THEN
1059: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1060: p_accessid => l_access_id,
1061: p_userid => p_USER_ID,

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

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

Line 1153: CSM_UTIL_PKG.LOG

1149: CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT('CSM_QUERY_RESULTS',to_char(p_INSTANCE_ID),'NEW');
1150: END IF;
1151:
1152:
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;

Line 1162: CSM_UTIL_PKG.LOG

1158:
1159: EXCEPTION WHEN OTHERS THEN
1160: /*** catch and log exceptions ***/
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) ;

Line 1246: CSM_UTIL_PKG.LOG

1242: l_return_message VARCHAR2(4000);
1243: l_query_type VARCHAR2(255);
1244: l_VARIABLE_VALUE_CHAR VARCHAR2(4000);
1245: BEGIN
1246: CSM_UTIL_PKG.LOG
1247: ( 'Entering INSERT_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',
1248: FND_LOG.LEVEL_ERROR);
1249:
1250: OPEN c_check_query(p_QUERY_ID);

Line 1253: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.INSERT_INSTANCE',FND_LOG.LEVEL_ERROR);

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

Line 1274: CSM_UTIL_PKG.LOG

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;
1278: x_error_message := 'Query Access Validation failed : ' || l_return_message;

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

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

Line 1317: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1313: VALUES (l_instance_id, p_USER_ID, p_QUERY_ID, l_instance_id,l_instance_name,'OPEN',
1314: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
1315:
1316:
1317: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1318: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1319: p_accessid => l_instance_id, --same as access id
1320: p_userid => p_USER_ID,
1321: p_dml => asg_download.ins,

Line 1337: CSM_UTIL_PKG.LOG

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',
1339: FND_LOG.LEVEL_ERROR);
1340:
1341: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1348: CSM_UTIL_PKG.LOG

1344:
1345: END IF;
1346:
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 ;

Line 1360: CSM_UTIL_PKG.LOG

1356: --Check if the values send are proper according to the Type
1357: FOR i in 1..p_VARIABLE_ID.COUNT LOOP
1358: IF UPPER(l_var_type_lst(i)) = 'DATE' THEN
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 ;

Line 1371: CSM_UTIL_PKG.LOG

1367: END IF;
1368: ELSE
1369:
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 ;

Line 1401: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1397: l_instance_id, i, l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
1398: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id,l_qvariable_id)
1399: RETURNING ACCESS_ID into l_access_id;
1400:
1401: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1402: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_item_qval,
1403: p_accessid => l_access_id,
1404: p_userid => p_USER_ID,
1405: p_dml => asg_download.ins,

Line 1415: CSM_UTIL_PKG.LOG

1411: COMMIT WORK;
1412: END IF;
1413:
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 ;

Line 1422: CSM_UTIL_PKG.LOG

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

Line 1480: CSM_UTIL_PKG.LOG

1476: AND OWNER = c_schema
1477: AND OBJECT_TYPE IN('TABLE','VIEW','SYNONYM');
1478:
1479: BEGIN
1480: CSM_UTIL_PKG.LOG
1481: ( 'Entering VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_ACCESS',
1482: FND_LOG.LEVEL_ERROR);
1483: --Get profile Value
1484: l_MQ_SCHEMA := UPPER(CSM_PROFILE_PKG.Get_Mobile_Query_Schema(p_RESPONSIBILITY_ID));

Line 1487: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',

1483: --Get profile Value
1484: l_MQ_SCHEMA := UPPER(CSM_PROFILE_PKG.Get_Mobile_Query_Schema(p_RESPONSIBILITY_ID));
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:

Line 1506: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',

1502: CLOSE c_get_query_txt;
1503: END IF;
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;

Line 1526: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_ACCESS',

1522: EXIT WHEN l_found_from_num = 0;
1523: END LOOP;
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:

Line 1575: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_ACCESS for Query Id : ' || p_QUERY_ID,'CSM_QUERY_PKG.VALIDATE_ACCESS',

1571: FOR j in 1..l_TABLE_LIST.COUNT LOOP
1572: OPEN c_check_table_access (l_MQ_SCHEMA,UPPER(l_TABLE_LIST(j)));
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;

Line 1585: CSM_UTIL_PKG.LOG

1581: END IF;
1582: CLOSE c_check_table_access;
1583: END LOOP;
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;

Line 1594: CSM_UTIL_PKG.LOG

1590: END IF;
1591:
1592: EXCEPTION WHEN OTHERS THEN
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 ;

Line 1642: CSM_UTIL_PKG.LOG

1638: l_instance_name VARCHAR2(255);
1639: l_access_id NUMBER;
1640: l_mark_dirty BOOLEAN;
1641: BEGIN
1642: CSM_UTIL_PKG.LOG
1643: ( 'Entering DELETE_INSTANCE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.DELETE_INSTANCE',
1644: FND_LOG.LEVEL_ERROR);
1645:
1646: SAVEPOINT DELETE_INSTANCE;

Line 1654: CSM_UTIL_PKG.LOG( 'Invalid Instance Id : ' || p_INSTANCE_ID ,'CSM_QUERY_PKG.DELETE_INSTANCE',FND_LOG.LEVEL_ERROR);

1650: FETCH c_get_instance INTO l_access_id;
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;

Line 1663: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1659: END IF;
1660:
1661: DELETE FROM CSM_QUERY_INSTANCES_ACC WHERE ACCESS_ID = l_access_id;
1662:
1663: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1664: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1665: p_accessid => l_access_id, --same as access id
1666: p_userid => p_USER_ID,
1667: p_dml => asg_download.del,

Line 1679: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1675:
1676: FORALL i in 1..l_access_id_list.COUNT
1677: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE ACCESS_ID = l_access_id_list(i);
1678:
1679: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1680: FOR i in 1..l_access_id_list.COUNT LOOP
1681: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,
1682: p_accessid => l_access_id_list(i), --same as access id
1683: p_userid => p_USER_ID,

Line 1700: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1696:
1697: FORALL i in 1..l_access_id_list.COUNT
1698: DELETE FROM CSM_QUERY_RESULTS_ACC WHERE ACCESS_ID = l_access_id_list(i);
1699:
1700: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1701: FOR i in 1..l_access_id_list.COUNT LOOP
1702: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1703: p_accessid => l_access_id_list(i), --same as access id
1704: p_userid => p_USER_ID,

Line 1714: CSM_UTIL_PKG.LOG

1710: IF FND_API.To_Boolean(p_commit) THEN
1711: COMMIT WORK;
1712: END IF;
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 ;

Line 1722: CSM_UTIL_PKG.LOG

1718: x_error_message := 'Delete call Successful for Instance Id : ' || p_INSTANCE_ID ;
1719:
1720: EXCEPTION WHEN OTHERS THEN
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) ;

Line 1765: CSM_UTIL_PKG.LOG

1761: WHERE item_type = c_work_flow
1762: AND name = c_variable_name;
1763:
1764: BEGIN
1765: CSM_UTIL_PKG.LOG
1766: ( 'Entering VALIDATE_WORKFLOW for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_WORKFLOW',
1767: FND_LOG.LEVEL_ERROR);
1768:
1769:

Line 1780: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_WORKFLOW for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',

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

Line 1795: CSM_UTIL_PKG.LOG( 'The Given Work Flow for Query Id : ' || p_QUERY_ID || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',

1791: FETCH c_get_item_type INTO l_TEMP_WORKFLOW;
1792: CLOSE c_get_item_type;
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;

Line 1811: CSM_UTIL_PKG.LOG( 'The Variable : ' || p_VARIABLE_NAME(i) || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_WORKFLOW',

1807: FETCH c_get_item_variable INTO l_TEMP_VARIABLE;
1808: CLOSE c_get_item_variable;
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;

Line 1823: CSM_UTIL_PKG.LOG

1819: END IF;
1820: END IF;
1821:
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:

Line 1830: CSM_UTIL_PKG.LOG

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

Line 1868: CSM_UTIL_PKG.LOG

1864: AND object_type = 'PACKAGE'
1865: AND status = 'VALID';
1866:
1867: BEGIN
1868: CSM_UTIL_PKG.LOG
1869: ( 'Entering VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID ,'CSM_QUERY_PKG.VALIDATE_PROCEDURE',
1870: FND_LOG.LEVEL_ERROR);
1871: l_PROCEDURE := p_PROCEDURE;
1872: --if the Work Flow is empty get the query text using the query id from the table

Line 1881: CSM_UTIL_PKG.LOG( 'Error in VALIDATE_PROCEDURE for Query Id : ' || p_QUERY_ID, 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',

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

Line 1899: CSM_UTIL_PKG.LOG( 'The Given Package : ' || l_PACKAGE_NAME || ' is not Valid.', 'CSM_QUERY_PKG.VALIDATE_PROCEDURE',

1895: OPEN c_is_package_valid(l_PACKAGE_NAME, l_SCHEMA_NAME);
1896: FETCH c_is_package_valid INTO l_PACKAGE_NAME;
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;

Line 1909: CSM_UTIL_PKG.LOG

1905:
1906: CLOSE c_is_package_valid;
1907: END IF;
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

Line 1915: CSM_UTIL_PKG.LOG

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

Line 1951: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_PKG.INSERT_RESULT for Instance ID: ' || p_INSTANCE_ID,

1947: l_error_msg VARCHAR2(4000);
1948:
1949:
1950: BEGIN
1951: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_PKG.INSERT_RESULT for Instance ID: ' || p_INSTANCE_ID,
1952: 'CSM_QUERY_PKG.INSERT_RESULT',FND_LOG.LEVEL_PROCEDURE);
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;

Line 1997: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN

1993: END IF;
1994:
1995: END IF;
1996:
1997: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1998: IF l_rs_access_id IS NULL THEN
1999: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2000: p_accessid => l_access_id,
2001: p_userid => p_USER_ID,

Line 2019: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_PKG.INSERT_RESULT for Instance 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);
2021:
2022: x_return_status := FND_API.G_RET_STS_SUCCESS;
2023: x_error_message := 'Query Result Successfully Inserted into the Access Table';

Line 2033: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_QUERY_PKG.INSERT_RESULT',FND_LOG.LEVEL_EXCEPTION);

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);
2034: ROLLBACK TO INSERT_RESULT;
2035: END INSERT_RESULT;
2036:
2037: PROCEDURE SET_VALIDATE_PROCEDURE(p_validate_procedure IN VARCHAR2)