APPS.BSC_WEB_ADI_LOADER_PKG dependencies on FND_API

Line 270: x_retcode := FND_API.G_RET_STS_SUCCESS;

266: query VARCHAR2(5000);
267: content_code VARCHAR2(100);
268: l_stmt VARCHAR2(3000);
269: BEGIN
270: x_retcode := FND_API.G_RET_STS_SUCCESS;
271: col_list := '';
272: FOR TAB_COL_REC IN TAB_COL LOOP
273: col_list := col_list || TAB_COL_REC.COLUMN_NAME || ',';
274: IF(LENGTH(col_list) > 1957) THEN

Line 276: x_retcode := FND_API.G_RET_STS_ERROR;

272: FOR TAB_COL_REC IN TAB_COL LOOP
273: col_list := col_list || TAB_COL_REC.COLUMN_NAME || ',';
274: IF(LENGTH(col_list) > 1957) THEN
275: x_errbuf := 'BSC_PMA_TOO_MANY_COLS';
276: x_retcode := FND_API.G_RET_STS_ERROR;
277: RETURN;
278: END IF;
279: END LOOP;
280: col_list := SUBSTR(col_list,1,LENGTH(col_list)-1);

Line 911: IF RETCODE <> FND_API.G_RET_STS_SUCCESS THEN

907: CREATE_INTERFACE(TAB_NAME);
908: CREATE_INTERFACE_COLUMNS(TAB_NAME);
909: CREATE_LAYOUT(TAB_NAME);
910: CREATE_CONTENT(TAB_NAME, ERRBUF,RETCODE);
911: IF RETCODE <> FND_API.G_RET_STS_SUCCESS THEN
912: RETURN;
913: END IF;
914: CREATE_MAPPING(TAB_NAME);
915: key_cols := CREATE_INTERFACE_KEYS( TAB_NAME );

Line 923: RETCODE := FND_API.G_RET_STS_SUCCESS;

919: END IF;
920: CREATE_PARAM_DEFN( TAB_NAME, key_cols );
921: CREATE_PARAM_LIST( TAB_NAME, key_cols );
922: COMMIT;
923: RETCODE := FND_API.G_RET_STS_SUCCESS;
924: ERRBUF := ' ';
925: null;
926: END;
927: