APPS.IBC_CONTENT_SYNC_INDEX_PKG dependencies on FND_API

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

152:
153: index3 VARCHAR2(250) := 'IBC_CITEM_VERSIONS_TL_CT1';
154: index1 VARCHAR2(250) := 'IBC_ATTRIBUTE_BUNDLES_CTX';
155: l_mode VARCHAR2(10) := bmode;
156: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
157: l_create_cmmd VARCHAR2(500):= NULL;
158: l_temp VARCHAR2(250);
159:
160: BEGIN

Line 186: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

182: IF l_mode = 'DR' THEN
183: Drop_Index(index3,
184: errbuf,
185: l_return_status);
186: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
187: RAISE drop_index_error;
188: END IF;
189:
190: -- Create the index

Line 271: x_return_status := fnd_api.G_RET_STS_ERROR;

267: AND owner= UPPER(p_owner);
268: l_total NUMBER := 0;
269:
270: BEGIN
271: x_return_status := fnd_api.G_RET_STS_ERROR;
272: IF p_index_name IS NULL THEN
273: RETURN;
274: END IF;
275:

Line 286: x_return_status := fnd_api.G_RET_STS_SUCCESS;

282: drop_index := 'drop index '||g_ibc_short_name||'.'||p_index_name||' force ';
283: EXECUTE IMMEDIATE drop_index;
284: END IF;
285:
286: x_return_status := fnd_api.G_RET_STS_SUCCESS;
287: EXCEPTION
288: WHEN others THEN
289: x_msg_error := 'Drop_Index: '||
290: fnd_message.GET_STRING('IBC','IBC_UNEXPECTED_ERROR')||' '|| SQLERRM;

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

303: l_sync_idx_progname VARCHAR2(100) := 'IBC_CONTENT_SYNC_TEXT_INDEX';
304: l_sync_mode VARCHAR2(1) := 'S';
305: l_pending_phase_code VARCHAR2(1) := 'P';
306: l_num_pending_requests NUMBER := 0;
307: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
308: begin
309:
310: -- Detect how many Pending, but not scheduled Content Sync-Index
311: -- concurrent program requests.

Line 345: l_return_status := fnd_api.G_RET_STS_SUCCESS;

341: argument2 => 0);
342:
343: if( l_request_id > 0 )
344: then
345: l_return_status := fnd_api.G_RET_STS_SUCCESS;
346: end if;
347: else
348: -- There is already a pending request, so just return success
349: l_request_id := 0;

Line 350: l_return_status := fnd_api.G_RET_STS_SUCCESS;

346: end if;
347: else
348: -- There is already a pending request, so just return success
349: l_request_id := 0;
350: l_return_status := fnd_api.G_RET_STS_SUCCESS;
351: end if;
352:
353: x_request_id := l_request_id;
354: x_return_status := l_return_status;

Line 359: x_return_status := fnd_api.G_RET_STS_ERROR;

355:
356: EXCEPTION
357: WHEN OTHERS THEN
358: x_request_id := 0;
359: x_return_status := fnd_api.G_RET_STS_ERROR;
360: END Request_Content_Sync_Index;
361:
362: END IBC_CONTENT_SYNC_INDEX_PKG;