eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_SYNC_INDEX_PKG dependencies on FND_API

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

206: ( x_request_id OUT NOCOPY NUMBER,
207: x_return_status OUT NOCOPY VARCHAR2 )
208: is
209: l_request_id NUMBER;
210: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
211: begin
212: -- bug 3359609
213: Request_Sync_Set_index(l_request_id,
214: l_return_status);

Line 215: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

211: begin
212: -- bug 3359609
213: Request_Sync_Set_index(l_request_id,
214: l_return_status);
215: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
216: THEN
217: RAISE Sync_Set_Index_Error;
218: END IF;
219:

Line 222: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

218: END IF;
219:
220: Request_Sync_Element_Index(l_request_id,
221: l_return_status);
222: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
223: THEN
224: RAISE Sync_Element_Index_Error;
225: END IF;
226: x_request_id := l_request_id;

Line 232: x_return_status := fnd_api.G_RET_STS_ERROR;

228:
229: exception
230: when others then
231: x_request_id := 0;
232: x_return_status := fnd_api.G_RET_STS_ERROR;
233: end Request_Sync_KM_Indexes;
234:
235:
236: /*

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

249: l_request_id NUMBER;
250: l_CS_appsname VARCHAR2(2) := 'CS';
251: l_mark_idx_progname VARCHAR2(30) := 'CS_KB_MARK_IDX_ON_SEC_CHG';
252: -- l_num_pending_requests NUMBER := 0;
253: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
254: begin
255:
256: l_request_id :=
257: fnd_request.submit_request

Line 269: l_return_status := fnd_api.G_RET_STS_SUCCESS;

265: argument3 => p_parameter2 );
266:
267: if( l_request_id > 0 )
268: then
269: l_return_status := fnd_api.G_RET_STS_SUCCESS;
270: else
271: l_return_status := fnd_api.G_RET_STS_ERROR;
272: end if;
273:

Line 271: l_return_status := fnd_api.G_RET_STS_ERROR;

267: if( l_request_id > 0 )
268: then
269: l_return_status := fnd_api.G_RET_STS_SUCCESS;
270: else
271: l_return_status := fnd_api.G_RET_STS_ERROR;
272: end if;
273:
274: x_request_id := l_request_id;
275: x_return_status := l_return_status;

Line 279: x_return_status := fnd_api.G_RET_STS_ERROR;

275: x_return_status := l_return_status;
276: exception
277: when others then
278: x_request_id := 0;
279: x_return_status := fnd_api.G_RET_STS_ERROR;
280: end Request_Mark_Idx_on_Sec_Change;
281:
282:
283: /*

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

841: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_SOLUTIONS_INDEX';
842: l_sync_mode VARCHAR2(1) := 'S';
843: l_pending_phase_code VARCHAR2(1) := 'P';
844: l_num_pending_requests NUMBER := 0;
845: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
846:
847: Cursor get_workers Is
848: select nvl(value,0) from v$parameter
849: where name='job_queue_processes';

Line 918: l_return_status := fnd_api.G_RET_STS_SUCCESS;

914: argument3 => null);
915:
916: if( l_request_id > 0 )
917: then
918: l_return_status := fnd_api.G_RET_STS_SUCCESS;
919: end if;
920: else
921: -- There is already a pending request, so just return success
922: l_request_id := 0;

Line 923: l_return_status := fnd_api.G_RET_STS_SUCCESS;

919: end if;
920: else
921: -- There is already a pending request, so just return success
922: l_request_id := 0;
923: l_return_status := fnd_api.G_RET_STS_SUCCESS;
924: end if;
925:
926: x_request_id := l_request_id;
927: x_return_status := l_return_status;

Line 931: x_return_status := fnd_api.G_RET_STS_ERROR;

927: x_return_status := l_return_status;
928: EXCEPTION
929: WHEN OTHERS THEN
930: x_request_id := 0;
931: x_return_status := fnd_api.G_RET_STS_ERROR;
932: END Request_Sync_Set_Index;
933:
934:
935: /*

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

948: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_STATEMENTS_INDEX';
949: l_sync_mode VARCHAR2(1) := 'S';
950: l_pending_phase_code VARCHAR2(1) := 'P';
951: l_num_pending_requests NUMBER := 0;
952: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
953: BEGIN
954:
955: -- Detect how many Pending, but not scheduled, KM Sync-Index
956: -- concurrent program requests there are.

Line 986: l_return_status := fnd_api.G_RET_STS_SUCCESS;

982: argument1 => l_sync_mode );
983:
984: if( l_request_id > 0 )
985: then
986: l_return_status := fnd_api.G_RET_STS_SUCCESS;
987: end if;
988: else
989: -- There is already a pending request, so just return success
990: l_request_id := 0;

Line 991: l_return_status := fnd_api.G_RET_STS_SUCCESS;

987: end if;
988: else
989: -- There is already a pending request, so just return success
990: l_request_id := 0;
991: l_return_status := fnd_api.G_RET_STS_SUCCESS;
992: end if;
993:
994: x_request_id := l_request_id;
995: x_return_status := l_return_status;

Line 999: x_return_status := fnd_api.G_RET_STS_ERROR;

995: x_return_status := l_return_status;
996: EXCEPTION
997: WHEN OTHERS THEN
998: x_request_id := 0;
999: x_return_status := fnd_api.G_RET_STS_ERROR;
1000: END Request_Sync_Element_Index;
1001:
1002:
1003: end CS_KB_SYNC_INDEX_PKG;