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

Line 106: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

102: p_RESPONSIBILITY_ID => l_responsibility_id,
103: x_return_status => l_return_status,
104: x_error_message => l_return_message);
105:
106: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
107: CSM_UTIL_PKG.LOG
108: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
109: FND_LOG.LEVEL_EXCEPTION);
110: x_return_status := FND_API.G_RET_STS_ERROR;

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
107: CSM_UTIL_PKG.LOG
108: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
109: FND_LOG.LEVEL_EXCEPTION);
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: x_error_message := 'Query Validation failed : ' || l_return_message;
112: RETURN;
113: END IF;
114: --Validate the Query

Line 121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

117: p_QUERY_TEXT2 => p_QUERY_TEXT2,
118: x_return_status => l_return_status,
119: x_error_message => l_return_message);
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: CSM_UTIL_PKG.LOG
123: ( 'Exception occurred in VALIDATE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
124: FND_LOG.LEVEL_EXCEPTION);
125: x_return_status := FND_API.G_RET_STS_ERROR;

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: CSM_UTIL_PKG.LOG
123: ( 'Exception occurred in VALIDATE_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
124: FND_LOG.LEVEL_EXCEPTION);
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: x_error_message := 'Query Validation failed : ' || l_return_message;
127: RETURN;
128: END IF;
129: ELSIF UPPER(P_QUERY_TYPE) ='WORKFLOW' THEN

Line 137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

133: p_VARIABLE_NAME => p_VARIABLE_NAME,
134: x_return_status => l_return_status,
135: x_error_message => l_return_message
136: );
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: CSM_UTIL_PKG.LOG
139: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
140: FND_LOG.LEVEL_EXCEPTION);
141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: CSM_UTIL_PKG.LOG
139: ( 'Exception occurred in VALIDATE_WORLFLOW for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
140: FND_LOG.LEVEL_EXCEPTION);
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: x_error_message := 'Query Validation failed : ' || l_return_message;
143: RETURN;
144: END IF;
145: END IF;

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: CSM_UTIL_PKG.LOG
151: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
152: FND_LOG.LEVEL_ERROR);
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
156: ' because of Variable Name and Variable Type Mismatch' ;
157: RETURN;
158: END IF;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: CSM_UTIL_PKG.LOG
164: ( 'Variable Name and Variable Type Mismatch: Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
165: FND_LOG.LEVEL_ERROR);
166:
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
169: ' because of Variable Name and Variable Type Mismatch' ;
170: RETURN;
171: END IF;

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227:
228: CSM_UTIL_PKG.LOG( 'Leaving INSERT_QUERY for Query Name :' || p_QUERY_NAME ,
229: FND_LOG.LEVEL_ERROR);
230: x_error_message := 'Query insert is Successful for Query Name: ' || p_QUERY_NAME ;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: EXCEPTION WHEN OTHERS THEN
234: /*** catch and log exceptions ***/
235: CSM_UTIL_PKG.LOG

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234: /*** catch and log exceptions ***/
235: CSM_UTIL_PKG.LOG
236: ( 'Exception occurred in INSERT_QUERY for Query Name ' || p_QUERY_NAME || SQLERRM, 'INSERT_QUERY',
237: FND_LOG.LEVEL_EXCEPTION);
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: x_error_message := 'Query insert failed for Query Name: ' || p_QUERY_NAME ||
240: ' : ' || SUBSTR(SQLERRM,1,3000);
241: RETURN;
242: END INSERT_QUERY;

Line 309: x_return_status := FND_API.G_RET_STS_SUCCESS;

305: --x_return_status VARCHAR2(255);
306: --p_error_msg VARCHAR2(4000);
307: BEGIN
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID ' || p_record.QUERY_ID ,
311: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
312: l_PARENT_QUERY_ID := p_record.PARENT_QUERY_ID;
313: l_query_id := p_record.QUERY_ID;

Line 318: x_return_status := FND_API.G_RET_STS_ERROR;

314:
315: IF l_PARENT_QUERY_ID IS NULL THEN
316: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);
317: p_error_msg := 'Parent Query Id is Invalid for Query Id : ' || l_query_id ;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: RETURN;
320: END IF;
321:
322: --Check if the Query id is valid

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: IF c_check_query%NOTFOUND THEN
329: CSM_UTIL_PKG.LOG( 'Parent Query Id is Invalid for Query Id: ' || l_query_id ,FND_LOG.LEVEL_ERROR);
330: p_error_msg := 'Parent Query Id is Invalid for Query Id : ' || l_query_id ;
331: CLOSE c_check_query;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: RETURN;
334: END IF;
335: CLOSE c_check_query;
336: --get user_id

Line 392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

388: x_return_status => x_return_status,
389: x_error_message => p_error_msg);
390:
391:
392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: CSM_UTIL_PKG.LOG( 'Query Upload Failed for Query ID : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
394: p_error_msg := 'Query Upload Failed for Query ID : '|| l_query_id || ' with error ' || p_error_msg;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: RETURN;

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391:
392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: CSM_UTIL_PKG.LOG( 'Query Upload Failed for Query ID : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
394: p_error_msg := 'Query Upload Failed for Query ID : '|| l_query_id || ' with error ' || p_error_msg;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: RETURN;
397: END IF;
398:
399: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID : ' || p_record.QUERY_ID ,

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398:
399: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_INSERT for Query ID : ' || p_record.QUERY_ID ,
400: 'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
401: p_error_msg := 'Query Upload is Successful for Query ID : '|| l_query_id;
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404:
405: EXCEPTION WHEN OTHERS THEN
406: p_error_msg := 'Exeception in Query Upload for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405: EXCEPTION WHEN OTHERS THEN
406: p_error_msg := 'Exeception in Query Upload for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);
407: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || SUBSTR(SQLERRM,1,3000)
408: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END APPLY_INSERT;
411:
412: /***
413: This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: CLOSE c_get_user;
451:
452: IF l_USER_ID IS NULL THEN
453: p_error_msg := 'The user is invalid.Please Check. User Name : '|| p_record.CLID$$CS;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: RETURN;
456: END IF;
457:
458: OPEN c_check_query(l_QUERY_ID, l_USER_ID);

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

460: CLOSE c_check_query;
461:
462: IF l_DELETE_FLAG IS NULL THEN
463: p_error_msg := 'User may not have permission to Delete the Query or The Query is not available for Delete. Query ID : '|| l_query_id;
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: RETURN;
466: END IF;
467: --Update the Query Definition in the base table
468: UPDATE CSM_QUERY_B

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474:
475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,
476: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
477: p_error_msg := 'Query Delete is Successful for Query ID : '|| l_query_id;
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480:
481: EXCEPTION WHEN OTHERS THEN
482: p_error_msg := 'Exeception in Query Delete for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: EXCEPTION WHEN OTHERS THEN
482: p_error_msg := 'Exeception in Query Delete for Query Id : '|| l_query_id ||' with Error ' ||SUBSTR(SQLERRM,1,3000);
483: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || SUBSTR(SQLERRM,1,3000)
484: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: END APPLY_DELETE;
487:
488: /***
489: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 501: x_return_status := FND_API.G_RET_STS_SUCCESS;

497: l_rc BOOLEAN;
498: l_access_id NUMBER;
499: BEGIN
500: /*** initialize return status and message list ***/
501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502: FND_MSG_PUB.INITIALIZE;
503:
504: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
505: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: , p_token_name1 => 'DML'
534: , p_token_value1 => p_record.dmltype$$
535: );
536:
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539:
540: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_RECORD for Query ID ' || p_record.QUERY_ID ,
541: 'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: );
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || SUBSTR(SQLERRM,1,3000)
549: || ' for Query ID ' || p_record.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
550:
551: x_return_status := FND_API.G_RET_STS_ERROR;
552:
553: END APPLY_RECORD;
554:
555: /***

Line 576: x_return_status := FND_API.G_RET_STS_SUCCESS;

572: BEGIN
573: CSM_UTIL_PKG.LOG('Entering CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES ',
574: 'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
575: g_debug_level := p_debug_level;
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: /*** loop through all the records in inqueue ***/
579: FOR r_query_rec IN c_query( p_user_name, p_tranid) LOOP
580: SAVEPOINT save_rec ;

Line 590: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

586: , l_process_status
587: );
588:
589: /*** was record processed successfully? ***/
590: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
591: /*** Yes -> delete record from inqueue ***/
592: CSM_UTIL_PKG.DELETE_RECORD
593: (
594: p_user_name,

Line 603: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

599: g_pub_name,
600: l_error_msg,
601: l_process_status
602: );
603: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
604: FOR r_query_var_inq_rec IN c_query_var_inq( p_user_name, p_tranid,r_query_rec.QUERY_ID ) LOOP
605: CSM_UTIL_PKG.DELETE_RECORD
606: (
607: p_user_name,

Line 616: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;

612: g_query_var_pub_name,
613: l_error_msg,
614: l_process_status
615: );
616: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;
617: END LOOP;
618: END IF;
619: /*** was delete successful? ***/
620: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 620: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

616: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;
617: END LOOP;
618: END IF;
619: /*** was delete successful? ***/
620: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
621: /*** no -> rollback ***/
622: CSM_UTIL_PKG.LOG
623: ( 'Deleting from inqueue failed, rolling back to savepoint'
624: || ' for Instance ID ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: CSM_UTIL_PKG.LOG
623: ( 'Deleting from inqueue failed, rolling back to savepoint'
624: || ' for Instance ID ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
625: ROLLBACK TO save_rec;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
629: /*** Record was not applied successfully -> defer and reject records ***/
630: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

Line 628: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

624: || ' for Instance ID ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
625: ROLLBACK TO save_rec;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
629: /*** Record was not applied successfully -> defer and reject records ***/
630: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
631: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
632:

Line 646: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

642: , l_process_status
643: , r_query_rec.dmltype$$
644: );
645:
646: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
647: FOR r_query_var_inq_rec IN c_query_var_inq( p_user_name, p_tranid,r_query_rec.QUERY_ID ) LOOP
648: CSM_UTIL_PKG.DEFER_RECORD
649: (
650: p_user_name,

Line 660: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;

656: l_error_msg,
657: l_process_status,
658: r_query_var_inq_rec.dmltype$$
659: );
660: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;
661: END LOOP;
662: END IF;
663: /*** Was defer successful? ***/
664: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 664: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

660: EXIT WHEN l_process_status <> FND_API.G_RET_STS_SUCCESS;
661: END LOOP;
662: END IF;
663: /*** Was defer successful? ***/
664: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
665: /*** no -> rollback ***/
666: CSM_UTIL_PKG.LOG
667: ( 'Defer record failed, rolling back to savepoint'
668: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: CSM_UTIL_PKG.LOG
667: ( 'Defer record failed, rolling back to savepoint'
668: || ' for PK ' || r_query_rec.QUERY_ID ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
669: ROLLBACK TO save_rec;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END IF;
672: END IF;
673:
674: END LOOP;

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: /*** catch and log exceptions ***/
681: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
682: ,'CSM_MOBILE_QUERY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
683:
684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: END APPLY_CLIENT_CHANGES;
687:
688: END CSM_MOBILE_QUERY_PKG;