APPS.CS_SR_SYNC_INDEX_PKG dependencies on FND_API

Line 442: x_return_status := fnd_api.G_RET_STS_SUCCESS;

438: l_index_name VARCHAR2(250);
439:
440: BEGIN
441: -- Initialize local variables.
442: x_return_status := fnd_api.G_RET_STS_SUCCESS;
443: l_index_name := 'CS_INCIDENTS_ALL_TL_N1';
444:
445: -- Bulk fetch a list of row id
446: OPEN all_srs;

Line 481: x_return_status := fnd_api.G_RET_STS_ERROR;

477: ROLLBACK; -- do not use savepoint because savepoint is cleared when commit.
478: x_msg_error := 'populate_sr_text_index: '
479: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '
480: ||SQLERRM;
481: x_return_status := fnd_api.G_RET_STS_ERROR;
482: END populate_sr_text_index;
483: -- 4917652_eof
484:
485: /*

Line 500: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

496:
497: IS
498: index3 VARCHAR2(250) := 'CS_INCIDENTS_ALL_TL_N1';
499: l_mode VARCHAR2(10) := bmode;
500: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
501: l_create_cmmd VARCHAR2(500):= NULL;
502: l_index_with varchar2(30) := pindex_with;
503:
504: BEGIN

Line 523: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

519: IF l_mode = 'DR' THEN
520: Drop_Index(index3,
521: errbuf,
522: l_return_status);
523: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
524: RAISE drop_index_error;
525: END IF;
526:
527: -- Create the index

Line 645: x_return_status := fnd_api.G_RET_STS_ERROR;

641: AND owner= UPPER(p_owner);
642: l_total NUMBER := 0;
643:
644: BEGIN
645: x_return_status := fnd_api.G_RET_STS_ERROR;
646: IF p_index_name IS NULL THEN
647: RETURN;
648: END IF;
649:

Line 660: x_return_status := fnd_api.G_RET_STS_SUCCESS;

656: drop_index := 'drop index '||g_cs_short_name||'.'||p_index_name||' force ';
657: EXECUTE IMMEDIATE drop_index;
658: END IF;
659:
660: x_return_status := fnd_api.G_RET_STS_SUCCESS;
661: EXCEPTION
662: WHEN others THEN
663: x_msg_error := 'Drop_Index: '||
664: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '|| SQLERRM;