APPS.CSM_LOBS_PKG dependencies on FND_API

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: and col.column_name = 'FILE_DATA';
161:
162: BEGIN
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165: l_dodirty := FALSE;--mark dirty for datatypeid =6 is not necessary
166:
167: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'|| ' for PK ' || to_char( p_record.file_id);
168: CSM_UTIL_PKG.LOG ( l_error_msg ,

Line 357: x_return_status := FND_API.G_RET_STS_ERROR;

353: --the record exists. Dont show any error.
354: null;
355: ELSE
356: --record could not be inserted, throw the exception
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: raise;
359: END IF;
360: CLOSE l_lobs_fileid_csr;
361: END;

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
422: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
423:
424: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE );
425: x_return_status := FND_API.G_RET_STS_ERROR;
426:
427: END APPLY_INSERT;
428:
429: /***

Line 441: x_return_status := FND_API.G_RET_STS_SUCCESS;

437: ) IS
438: l_error_msg varchar(1024);
439: BEGIN
440: /*** initialize return status and message list ***/
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: FND_MSG_PUB.INITIALIZE;
443:
444:
445: l_error_msg := 'Entering ' || g_object_name || '.APPLY_RECORD'

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: , p_token_name1 => 'DML'
479: , p_token_value1 => p_record.dmltype$$
480: );
481:
482: x_return_status := FND_API.G_RET_STS_ERROR;
483:
484: ELSIF p_record.dmltype$$='D' THEN
485: -- Process delete; not supported for this entity
486:

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: , p_token_name1 => 'DML'
497: , p_token_value1 => p_record.dmltype$$
498: );
499:
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: ELSE
502: -- invalid dml type
503:
504: CSM_UTIL_PKG.LOG

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: , p_token_name1 => 'DML'
512: , p_token_value1 => p_record.dmltype$$
513: );
514:
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: END IF;
517:
518: CSM_UTIL_PKG.LOG ( 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || p_record.FILE_ID,
519: 'CSM_LOBS_LOBS.APPLY_RECORD',

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: 'CSM_LOBS_LOBS.APPLY_RECORD',
541: FND_LOG.LEVEL_ERROR );
542:
543:
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: END APPLY_RECORD;
546:
547: /***
548: This procedure is called by CSM_SERVICEP_WRAPPER_PKG when publication item CSF_M_LOBS

Line 565: x_return_status := FND_API.G_RET_STS_SUCCESS;

561: l_process_status VARCHAR2(1);
562: l_error_msg VARCHAR2(4000);
563: BEGIN
564: g_debug_level := p_debug_level;
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: CSM_UTIL_PKG.LOG ( 'Entering ' || g_object_name || '.Apply_Client_Changes',
568: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
569: FND_LOG.LEVEL_PROCEDURE);

Line 587: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

583: );
584:
585:
586: /*** was record processed successfully? ***/
587: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
588: /*** Yes -> delete record from inqueue ***/
589: CSM_UTIL_PKG.LOG
590: ( 'Record successfully processed, deleting from inqueue ' || g_object_name
591: || ' for PK ' || r_FND_LOBS.FILE_ID,

Line 609: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

605: l_process_status
606: );
607:
608: /*** was delete successful? ***/
609: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
610: /*** no -> rollback ***/
611: CSM_UTIL_PKG.LOG
612: ( 'Deleting from inqueue failed, rolling back to savepoint for entity ' || g_object_name
613: || ' and PK ' || r_FND_LOBS.FILE_ID,

Line 621: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

617: ROLLBACK TO save_rec;
618: END IF;
619: END IF;
620:
621: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
622: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
623:
624: CSM_UTIL_PKG.LOG
625: ( 'Record not processed successfully, deferring and rejecting record for entity ' || g_object_name

Line 645: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

641: , r_FND_LOBS.dmltype$$
642: );
643:
644: /*** Was defer successful? ***/
645: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
646: /*** no -> rollback ***/
647: CSM_UTIL_PKG.LOG
648: ( 'Defer record failed, rolling back to savepoint for entity ' || g_object_name
649: || ' and PK ' || r_FND_LOBS.FILE_ID,

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: /*** catch and log exceptions ***/
667: CSM_UTIL_PKG.LOG ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
668: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES', FND_LOG.LEVEL_ERROR);
669:
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END APPLY_CLIENT_CHANGES;
672:
673:
674: END CSM_LOBS_PKG;