APPS.CSM_LOBS_PKG dependencies on FND_API

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: and OWNER = c_schema;
150:
151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: l_dodirty := FALSE;--mark dirty for datatypeid =6 is not necessary
155:
156: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'|| ' for PK ' || to_char( p_record.file_id);
157: CSM_UTIL_PKG.LOG ( l_error_msg ,

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: --the record exists. Dont show any error.
343: null;
344: ELSE
345: --record could not be inserted, throw the exception
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: raise;
348: END IF;
349: CLOSE l_lobs_fileid_csr;
350: END;

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
411: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
412:
413: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE );
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: END APPLY_INSERT;
417:
418: /***

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS;

426: ) IS
427: l_error_msg varchar(1024);
428: BEGIN
429: /*** initialize return status and message list ***/
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431: FND_MSG_PUB.INITIALIZE;
432:
433:
434: l_error_msg := 'Entering ' || g_object_name || '.APPLY_RECORD'

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

467: , p_token_name1 => 'DML'
468: , p_token_value1 => p_record.dmltype$$
469: );
470:
471: x_return_status := FND_API.G_RET_STS_ERROR;
472:
473: ELSIF p_record.dmltype$$='D' THEN
474: -- Process delete; not supported for this entity
475:

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: , p_token_name1 => 'DML'
486: , p_token_value1 => p_record.dmltype$$
487: );
488:
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: ELSE
491: -- invalid dml type
492:
493: CSM_UTIL_PKG.LOG

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: , p_token_name1 => 'DML'
501: , p_token_value1 => p_record.dmltype$$
502: );
503:
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506:
507: CSM_UTIL_PKG.LOG ( 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || p_record.FILE_ID,
508: 'CSM_LOBS_LOBS.APPLY_RECORD',

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

529: 'CSM_LOBS_LOBS.APPLY_RECORD',
530: FND_LOG.LEVEL_ERROR );
531:
532:
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: END APPLY_RECORD;
535:
536: /***
537: This procedure is called by CSM_SERVICEP_WRAPPER_PKG when publication item CSF_M_LOBS

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: l_process_status VARCHAR2(1);
551: l_error_msg VARCHAR2(4000);
552: BEGIN
553: g_debug_level := p_debug_level;
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: CSM_UTIL_PKG.LOG ( 'Entering ' || g_object_name || '.Apply_Client_Changes',
557: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
558: FND_LOG.LEVEL_PROCEDURE);

Line 576: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

572: );
573:
574:
575: /*** was record processed successfully? ***/
576: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
577: /*** Yes -> delete record from inqueue ***/
578: CSM_UTIL_PKG.LOG
579: ( 'Record successfully processed, deleting from inqueue ' || g_object_name
580: || ' for PK ' || r_FND_LOBS.FILE_ID,

Line 598: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

594: l_process_status
595: );
596:
597: /*** was delete successful? ***/
598: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
599: /*** no -> rollback ***/
600: CSM_UTIL_PKG.LOG
601: ( 'Deleting from inqueue failed, rolling back to savepoint for entity ' || g_object_name
602: || ' and PK ' || r_FND_LOBS.FILE_ID,

Line 610: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

606: ROLLBACK TO save_rec;
607: END IF;
608: END IF;
609:
610: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
611: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
612:
613: CSM_UTIL_PKG.LOG
614: ( 'Record not processed successfully, deferring and rejecting record for entity ' || g_object_name

Line 634: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

630: , r_FND_LOBS.dmltype$$
631: );
632:
633: /*** Was defer successful? ***/
634: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
635: /*** no -> rollback ***/
636: CSM_UTIL_PKG.LOG
637: ( 'Defer record failed, rolling back to savepoint for entity ' || g_object_name
638: || ' and PK ' || r_FND_LOBS.FILE_ID,

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655: /*** catch and log exceptions ***/
656: CSM_UTIL_PKG.LOG ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
657: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES', FND_LOG.LEVEL_ERROR);
658:
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END APPLY_CLIENT_CHANGES;
661:
662:
663: END CSM_LOBS_PKG;