DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on FND_API

Line 170: l_lock_status:=FND_API.G_RET_STS_SUCCESS ;

166: SELECT hsecs INTO l_start_time from v$timer;
167: --
168: /* Bugfix 12863728 Start */
169: l_line_tbl.delete;
170: l_lock_status:=FND_API.G_RET_STS_SUCCESS ;
171:
172: j:=1;
173: i := g_oe_line_tbl.FIRST;
174:

Line 198: ,p_init_msg_list => FND_API.G_TRUE

194: END IF;
195:
196: OE_ORDER_PUB.Lock_Order(
197: p_api_version_number => x_oe_api_version
198: ,p_init_msg_list => FND_API.G_TRUE
199: ,p_return_values => FND_API.G_FALSE
200: ,x_return_status => l_lock_status
201: ,x_msg_count => x_msg_count
202: ,x_msg_data => x_msg_data

Line 199: ,p_return_values => FND_API.G_FALSE

195:
196: OE_ORDER_PUB.Lock_Order(
197: p_api_version_number => x_oe_api_version
198: ,p_init_msg_list => FND_API.G_TRUE
199: ,p_return_values => FND_API.G_FALSE
200: ,x_return_status => l_lock_status
201: ,x_msg_count => x_msg_count
202: ,x_msg_data => x_msg_data
203: ,p_line_tbl => l_line_tbl

Line 235: IF l_lock_status = FND_API.G_RET_STS_UNEXP_ERROR OR

231: END IF;
232: --
233: END IF; --}
234:
235: IF l_lock_status = FND_API.G_RET_STS_UNEXP_ERROR OR
236: l_lock_status = FND_API.G_RET_STS_ERROR THEN
237: --
238: IF (l_debug <> -1) THEN
239: rlm_core_sv.dlog(k_DEBUG,'Raising e_LockOrderFailed');

Line 236: l_lock_status = FND_API.G_RET_STS_ERROR THEN

232: --
233: END IF; --}
234:
235: IF l_lock_status = FND_API.G_RET_STS_UNEXP_ERROR OR
236: l_lock_status = FND_API.G_RET_STS_ERROR THEN
237: --
238: IF (l_debug <> -1) THEN
239: rlm_core_sv.dlog(k_DEBUG,'Raising e_LockOrderFailed');
240: END IF;

Line 260: , p_init_msg_list => FND_API.G_TRUE

256: END IF;
257:
258: OE_Order_GRP.Process_order
259: ( p_api_version_number => x_oe_api_version
260: , p_init_msg_list => FND_API.G_TRUE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
264: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC

Line 261: , p_return_values => FND_API.G_FALSE

257:
258: OE_Order_GRP.Process_order
259: ( p_api_version_number => x_oe_api_version
260: , p_init_msg_list => FND_API.G_TRUE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
264: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
265: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE

Line 262: , p_commit => FND_API.G_FALSE

258: OE_Order_GRP.Process_order
259: ( p_api_version_number => x_oe_api_version
260: , p_init_msg_list => FND_API.G_TRUE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
264: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
265: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE
266: , x_return_status => l_return_status

Line 263: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

259: ( p_api_version_number => x_oe_api_version
260: , p_init_msg_list => FND_API.G_TRUE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
264: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
265: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE
266: , x_return_status => l_return_status
267: , x_msg_count => x_msg_count

Line 304: , p_init_msg_list => FND_API.G_TRUE

300: END IF;
301:
302: OE_Order_GRP.Process_order
303: ( p_api_version_number => x_oe_api_version
304: , p_init_msg_list => FND_API.G_TRUE
305: , p_control_rec => l_control_rec
306: , x_return_status => l_return_status
307: , x_msg_count => x_msg_count
308: , x_msg_data => x_msg_data

Line 365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

361: fnd_file.put_line(fnd_file.log, v_msg_text);
362: v_msg_text := 'Total Time - ' || g_total_time;
363: fnd_file.put_line(fnd_file.log, v_msg_text);
364: --
365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
366: l_return_status = FND_API.G_RET_STS_ERROR THEN
367: --
368: RAISE e_ProcessOrderFailed;
369: --

Line 366: l_return_status = FND_API.G_RET_STS_ERROR THEN

362: v_msg_text := 'Total Time - ' || g_total_time;
363: fnd_file.put_line(fnd_file.log, v_msg_text);
364: --
365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
366: l_return_status = FND_API.G_RET_STS_ERROR THEN
367: --
368: RAISE e_ProcessOrderFailed;
369: --
370: END IF;

Line 410: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN

406: IF (l_debug <> -1) THEN
407: rlm_core_sv.dlog(k_DEBUG, 'Line return status', l_oe_line_tbl_out(s).return_status);
408: END IF;
409: --
410: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: --
412: UPDATE rlm_schedule_lines_all
413: SET process_status = rlm_core_sv.k_PS_ERROR
414: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;

Line 683: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>

679: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
680: substr(x_msg,1,200));
681: END IF;
682: --
683: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>
684: FND_API.G_MISS_NUM THEN
685: BEGIN
686: --
687: SELECT interface_line_id, header_id, order_header_id, industry_attribute2

Line 684: FND_API.G_MISS_NUM THEN

680: substr(x_msg,1,200));
681: END IF;
682: --
683: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>
684: FND_API.G_MISS_NUM THEN
685: BEGIN
686: --
687: SELECT interface_line_id, header_id, order_header_id, industry_attribute2
688: INTO v_interface_line_id, v_schedule_header_id, v_order_header_id, v_request_date

Line 891: , p_init_msg_list => FND_API.G_TRUE

887: --
888: oe_order_grp.Process_order
889: ( p_api_version_number => x_api_version_number
890: , p_api_service_level => x_api_service_level
891: , p_init_msg_list => FND_API.G_TRUE
892: , x_return_status => l_return_status
893: , x_msg_count => x_msg_count
894: , x_msg_data => x_msg_data
895: , p_line_tbl => l_line_tbl

Line 924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

920: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
921: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
922: END IF;
923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSE

Line 925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

921: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
922: END IF;
923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSE
929: --

Line 926: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

922: END IF;
923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSE
929: --
930: b_result := FALSE;

Line 927: RAISE FND_API.G_EXC_ERROR;

923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSE
929: --
930: b_result := FALSE;
931: --

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941: RETURN(b_Result);
942: --
943: EXCEPTION
944: --
945: WHEN FND_API.G_EXC_ERROR THEN
946: --
947: b_result := TRUE;
948: --
949: IF (l_debug <> -1) THEN

Line 951: FND_API.G_RET_STS_ERROR');

947: b_result := TRUE;
948: --
949: IF (l_debug <> -1) THEN
950: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
951: FND_API.G_RET_STS_ERROR');
952: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
953: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
954: END IF;
955: --

Line 984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

980: END IF;
981: --
982: RETURN(b_Result);
983: --
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: --
986: b_result := TRUE;
987: --
988: IF (l_debug <> -1) THEN

Line 990: FND_API.G_RET_STS_UNEXP_ERROR');

986: b_result := TRUE;
987: --
988: IF (l_debug <> -1) THEN
989: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);

Line 1020: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1016: RETURN(b_Result);
1017: --
1018: WHEN OTHERS THEN
1019: --
1020: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: --
1022: IF (l_debug <> -1) THEN
1023: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
1024: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));

Line 1774: --x_oe_line_rec.item_type_code := fnd_api.g_miss_char;

1770: ELSIF x_Op_rec.supplier_item_ext is not null THEN
1771: x_oe_line_rec.ordered_item := x_Op_rec.supplier_item_ext;
1772: END IF;
1773: --
1774: --x_oe_line_rec.item_type_code := fnd_api.g_miss_char;
1775: IF (l_debug <> -1) THEN
1776: rlm_core_sv.dlog(k_DEBUG,'customer_item_revision', x_Op_rec.customer_item_revision);
1777: END IF;
1778: --