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

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: l_error_msg VARCHAR2(4000);
107: l_query_type VARCHAR2(255);
108: BEGIN
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,
112: 'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
113: l_query_id := p_record.QUERY_ID;
114: --Check if the Query id is valid

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

115: OPEN c_check_query(l_query_id);
116: FETCH c_check_query INTO l_instance_name, l_level_id, l_level_value,l_query_type;
117: IF c_check_query%NOTFOUND THEN
118: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: p_error_msg := 'Invalid Query Id : ' || l_query_id ;
121: CLOSE c_check_query;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: RETURN;

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: CSM_UTIL_PKG.LOG( 'Invalid Query Id : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: p_error_msg := 'Invalid Query Id : ' || l_query_id ;
121: CLOSE c_check_query;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: RETURN;
124: END IF;
125: CLOSE c_check_query;
126:

Line 139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

135: p_RESPONSIBILITY_ID => l_responsibility_id,
136: x_return_status => x_return_status,
137: x_error_message => l_error_msg);
138:
139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
140: CSM_UTIL_PKG.LOG
141: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || l_instance_name || SQLERRM, 'INSERT_INSTANCE',
142: FND_LOG.LEVEL_EXCEPTION);
143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
140: CSM_UTIL_PKG.LOG
141: ( 'Exception occurred in VALIDATE_ACCESS for Query Name ' || l_instance_name || SQLERRM, 'INSERT_INSTANCE',
142: FND_LOG.LEVEL_EXCEPTION);
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: p_error_msg := 'Query Access Validation failed : ' || l_error_msg;
145: RETURN;
146: END IF;
147: END IF;

Line 194: p_commit => fnd_api.G_FALSE,

190: p_QUERY_ID => l_query_id,
191: p_INSTANCE_ID => l_instance_id,
192: x_return_status => x_return_status,
193: x_error_message => l_error_msg,
194: p_commit => fnd_api.G_FALSE,
195: p_source_module => 'MFSCLIENT'
196: );
197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
198: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

Line 197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

193: x_error_message => l_error_msg,
194: p_commit => fnd_api.G_FALSE,
195: p_source_module => 'MFSCLIENT'
196: );
197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
198: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
199: p_error_msg := 'Query Upload Failed at execution for Instance id : '
200: || l_instance_id || 'With Message' || l_error_msg;
201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
198: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
199: p_error_msg := 'Query Upload Failed at execution for Instance id : '
200: || l_instance_id || 'With Message' || l_error_msg;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: ROLLBACK TO INSERT_QUERY_INSTANCE;
203: RETURN;
204: END IF;
205:

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: RETURN;
204: END IF;
205:
206: CSM_UTIL_PKG.LOG( 'Leaving INSERT_INSTANCE for Query Id : ' || l_user_id , FND_LOG.LEVEL_ERROR);
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: p_error_msg := 'Leaving INSERT_INSTANCE for Query Id : ' || l_user_id ;
209: RETURN;
210:
211: END IF;

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218: IF l_variable_id_lst.COUNT <> l_variable_id_inq_lst.COUNT THEN
219: CSM_UTIL_PKG.LOG
220: ( 'Variable Count mismatch.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
221: FND_LOG.LEVEL_ERROR);
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: p_error_msg := 'Variable Count mismatch.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;
224: RETURN;
225: END IF;
226: --Check if the values send are proper according to the Type

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: IF l_var_value_date_inq_lst(i) IS NULL THEN
230: CSM_UTIL_PKG.LOG
231: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
232: FND_LOG.LEVEL_ERROR);
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: p_error_msg := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;
235: RETURN;
236: END IF;
237: ELSE

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: IF l_var_value_char_inq_lst(i) IS NULL THEN
240: CSM_UTIL_PKG.LOG
241: ( 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ,
242: FND_LOG.LEVEL_ERROR);
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: p_error_msg := 'Variable Value sent not matching with Type.Leaving INSERT_INSTANCE for Query Id : ' || l_query_id ;
245: RETURN;
246: END IF;
247: END IF;

Line 281: p_commit => fnd_api.G_FALSE,

277: p_QUERY_ID => l_query_id,
278: p_INSTANCE_ID => l_instance_id,
279: x_return_status => x_return_status,
280: x_error_message => l_error_msg,
281: p_commit => fnd_api.G_FALSE,
282: p_source_module => 'MFSCLIENT'
283: );
284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);

Line 284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

280: x_error_message => l_error_msg,
281: p_commit => fnd_api.G_FALSE,
282: p_source_module => 'MFSCLIENT'
283: );
284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
286: p_error_msg := 'Query Upload Failed at execution for Instance id : '
287: || l_instance_id || ' With Message ' || l_error_msg;
288: x_return_status := FND_API.G_RET_STS_ERROR;

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: CSM_UTIL_PKG.LOG( 'Query Upload Failed for : ' || l_query_id ,FND_LOG.LEVEL_ERROR);
286: p_error_msg := 'Query Upload Failed at execution for Instance id : '
287: || l_instance_id || ' With Message ' || l_error_msg;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: ROLLBACK TO INSERT_QUERY_INSTANCE;
290: RETURN;
291: END IF;
292:

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291: END IF;
292:
293: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_INSERT for Instance ID ' || p_record.INSTANCE_ID ,
294: 'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: p_error_msg := 'Upload Successful for the Instance Id : ' || l_instance_id ;
297: RETURN;
298:
299: EXCEPTION WHEN OTHERS THEN

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

304: );
305: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
306: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
307: p_error_msg := 'Exception in APPLY_INSERT for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: ROLLBACK TO INSERT_QUERY_INSTANCE;
310: END APPLY_INSERT;
311:
312:

Line 344: x_return_status := FND_API.G_RET_STS_SUCCESS;

340: l_user_id NUMBER;
341:
342: BEGIN
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,
346: 'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
347: l_query_id := p_record.QUERY_ID;
348: l_instance_id := p_record.instance_id;

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: END IF;
359:
360: IF l_query_id IS NULL THEN
361: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: p_error_msg := 'Delete request failed for Instance Id : ' || l_instance_id || ' as it does not exist.';
364: RETURN;
365: END IF;
366:

Line 372: p_commit => fnd_api.G_FALSE,

368: CSM_QUERY_PKG.DELETE_INSTANCE
369: ( p_USER_ID => l_user_id,
370: p_QUERY_ID => l_query_id,
371: p_INSTANCE_ID => l_instance_id,
372: p_commit => fnd_api.G_FALSE,
373: x_return_status => x_return_status,
374: x_error_message => p_error_msg) ;
375:
376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

372: p_commit => fnd_api.G_FALSE,
373: x_return_status => x_return_status,
374: x_error_message => p_error_msg) ;
375:
376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
377: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: RETURN;
380: END IF;

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: x_error_message => p_error_msg) ;
375:
376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
377: CSM_UTIL_PKG.LOG( 'Query Instance Delete Failed for : ' || l_instance_id ,FND_LOG.LEVEL_ERROR);
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: RETURN;
380: END IF;
381:
382: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: END IF;
381:
382: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_DELETE for Instance ID ' || p_record.INSTANCE_ID ,
383: 'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: p_error_msg := 'Delete Successful for the Instance Id : ' || l_instance_id ;
386: RETURN;
387:
388: EXCEPTION WHEN OTHERS THEN

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT (p_api_error => TRUE);
391: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || sqlerrm
392: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
393: p_error_msg := 'Exception in APPLY_DELETE for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: END APPLY_DELETE;
396: /***
397: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.
398: ***/

Line 409: x_return_status := FND_API.G_RET_STS_SUCCESS;

405: l_rc BOOLEAN;
406: l_access_id NUMBER;
407: BEGIN
408: /*** initialize return status and message list ***/
409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410: FND_MSG_PUB.INITIALIZE;
411:
412: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
413: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 444: x_return_status := FND_API.G_RET_STS_ERROR;

440: , p_token_name1 => 'DML'
441: , p_token_value1 => p_record.dmltype$$
442: );
443:
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: END IF;
446:
447: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
448: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454: );
455: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
456: || ' for Query Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
457:
458: x_return_status := FND_API.G_RET_STS_ERROR;
459:
460: END APPLY_RECORD;
461:
462: /***

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: BEGIN
481: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES ',
482: 'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
483: g_debug_level := p_debug_level;
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: /*** loop through all the records in inqueue ***/
487: FOR r_qi_rec IN c_query_instances( p_user_name, p_tranid, p_from_sync) LOOP
488: SAVEPOINT save_rec ;

Line 498: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

494: , l_process_status
495: );
496:
497: /*** was record processed successfully? ***/
498: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
499: /*** Yes -> delete record from inqueue ***/
500: CSM_UTIL_PKG.REJECT_RECORD
501: (
502: p_user_name,

Line 512: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

508: l_error_msg,
509: l_process_status
510: );
511: /*** was Instance delete successful? ***/
512: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
513: /*** Yes -> delete Variable Values record from inqueue ***/
514: FOR r_qvv_rec IN c_query_variable_values( p_user_name, p_tranid, r_qi_rec.INSTANCE_ID) LOOP
515: CSM_UTIL_PKG.REJECT_RECORD
516: (

Line 526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

522: g_pub_qvv_name,
523: l_error_msg,
524: l_process_status
525: );
526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
527: EXIT;
528: END IF;
529: END LOOP;
530: END IF;

Line 533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

529: END LOOP;
530: END IF;
531:
532: /*** was delete successful? ***/
533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** no -> rollback ***/
535: CSM_UTIL_PKG.LOG
536: ( 'Deleting from inqueue failed, rolling back to savepoint'
537: || ' for Instance ID ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: CSM_UTIL_PKG.LOG
536: ( 'Deleting from inqueue failed, rolling back to savepoint'
537: || ' for Instance ID ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
538: ROLLBACK TO save_rec;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: END IF;
541: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync = 'Y' THEN
542: CSM_UTIL_PKG.LOG
543: ( 'Defer record failed, rolling back to savepoint'

Line 541: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync = 'Y' THEN

537: || ' for Instance ID ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
538: ROLLBACK TO save_rec;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: END IF;
541: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync = 'Y' THEN
542: CSM_UTIL_PKG.LOG
543: ( 'Defer record failed, rolling back to savepoint'
544: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
545: ROLLBACK TO save_rec;

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

542: CSM_UTIL_PKG.LOG
543: ( 'Defer record failed, rolling back to savepoint'
544: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
545: ROLLBACK TO save_rec;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync ='N' THEN
548: /*** Record was not applied successfully -> defer and reject records ***/
549: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
550: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 547: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync ='N' THEN

543: ( 'Defer record failed, rolling back to savepoint'
544: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
545: ROLLBACK TO save_rec;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS AND p_from_sync ='N' THEN
548: /*** Record was not applied successfully -> defer and reject records ***/
549: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
550: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
551:

Line 566: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

562: , r_qi_rec.dmltype$$
563: );
564:
565: /*** was Instance defer successful? ***/
566: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
567: /*** Yes -> defer Variable Values record from inqueue ***/
568: FOR r_qvv_rec IN c_query_variable_values( p_user_name, p_tranid, r_qi_rec.INSTANCE_ID) LOOP
569: CSM_UTIL_PKG.DEFER_RECORD
570: (

Line 581: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

577: l_error_msg,
578: l_process_status,
579: r_qvv_rec.dmltype$$
580: );
581: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
582: EXIT;
583: END IF;
584: END LOOP;
585: END IF;

Line 589: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

585: END IF;
586:
587:
588: /*** Was defer successful? ***/
589: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
590: /*** no -> rollback ***/
591: CSM_UTIL_PKG.LOG
592: ( 'Defer record failed, rolling back to savepoint'
593: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 595: x_return_status := FND_API.G_RET_STS_ERROR;

591: CSM_UTIL_PKG.LOG
592: ( 'Defer record failed, rolling back to savepoint'
593: || ' for PK ' || r_qi_rec.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
594: ROLLBACK TO save_rec;
595: x_return_status := FND_API.G_RET_STS_ERROR;
596: END IF;
597: END IF;
598:
599: END LOOP;

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: /*** catch and log exceptions ***/
606: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
607: ,'CSM_QUERY_INSTANCE_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
608:
609: x_return_status := FND_API.G_RET_STS_ERROR;
610:
611: END APPLY_CLIENT_CHANGES;
612:
613: END CSM_QUERY_INSTANCE_PKG;