DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on FND_API

Line 154: , p_init_msg_list => FND_API.G_TRUE

150: IF x_Op_tab(1).schedule_type <> k_SEQUENCED THEN
151: --
152: OE_Order_GRP.Process_order
153: ( p_api_version_number => x_oe_api_version
154: , p_init_msg_list => FND_API.G_TRUE
155: , p_return_values => FND_API.G_FALSE
156: , p_commit => FND_API.G_FALSE
157: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
158: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC

Line 155: , p_return_values => FND_API.G_FALSE

151: --
152: OE_Order_GRP.Process_order
153: ( p_api_version_number => x_oe_api_version
154: , p_init_msg_list => FND_API.G_TRUE
155: , p_return_values => FND_API.G_FALSE
156: , p_commit => FND_API.G_FALSE
157: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
158: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
159: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE

Line 156: , p_commit => FND_API.G_FALSE

152: OE_Order_GRP.Process_order
153: ( p_api_version_number => x_oe_api_version
154: , p_init_msg_list => FND_API.G_TRUE
155: , p_return_values => FND_API.G_FALSE
156: , p_commit => FND_API.G_FALSE
157: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
158: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
159: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE
160: , x_return_status => l_return_status

Line 157: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

153: ( p_api_version_number => x_oe_api_version
154: , p_init_msg_list => FND_API.G_TRUE
155: , p_return_values => FND_API.G_FALSE
156: , p_commit => FND_API.G_FALSE
157: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
158: , p_control_rec => OE_GLOBALS.G_MISS_CONTROL_REC
159: , p_api_service_level => OE_GLOBALS.G_ALL_SERVICE
160: , x_return_status => l_return_status
161: , x_msg_count => x_msg_count

Line 194: , p_init_msg_list => FND_API.G_TRUE

190: l_control_rec.process_partial := TRUE;
191: --
192: OE_Order_GRP.Process_order
193: ( p_api_version_number => x_oe_api_version
194: , p_init_msg_list => FND_API.G_TRUE
195: , p_control_rec => l_control_rec
196: , x_return_status => l_return_status
197: , x_msg_count => x_msg_count
198: , x_msg_data => x_msg_data

Line 255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

251: fnd_file.put_line(fnd_file.log, v_msg_text);
252: v_msg_text := 'Total Time - ' || g_total_time;
253: fnd_file.put_line(fnd_file.log, v_msg_text);
254: --
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
256: l_return_status = FND_API.G_RET_STS_ERROR THEN
257: --
258: RAISE e_ProcessOrderFailed;
259: --

Line 256: l_return_status = FND_API.G_RET_STS_ERROR THEN

252: v_msg_text := 'Total Time - ' || g_total_time;
253: fnd_file.put_line(fnd_file.log, v_msg_text);
254: --
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
256: l_return_status = FND_API.G_RET_STS_ERROR THEN
257: --
258: RAISE e_ProcessOrderFailed;
259: --
260: END IF;

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

296: IF (l_debug <> -1) THEN
297: rlm_core_sv.dlog(k_DEBUG, 'Line return status', l_oe_line_tbl_out(s).return_status);
298: END IF;
299: --
300: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
301: --
302: UPDATE rlm_schedule_lines_all
303: SET process_status = rlm_core_sv.k_PS_ERROR
304: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;

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

507: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
508: substr(x_msg,1,200));
509: END IF;
510: --
511: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>
512: FND_API.G_MISS_NUM THEN
513: BEGIN
514: --
515: SELECT interface_line_id, header_id, order_header_id, industry_attribute2

Line 512: FND_API.G_MISS_NUM THEN

508: substr(x_msg,1,200));
509: END IF;
510: --
511: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>
512: FND_API.G_MISS_NUM THEN
513: BEGIN
514: --
515: SELECT interface_line_id, header_id, order_header_id, industry_attribute2
516: INTO v_interface_line_id, v_schedule_header_id, v_order_header_id, v_request_date

Line 719: , p_init_msg_list => FND_API.G_TRUE

715: --
716: oe_order_grp.Process_order
717: ( p_api_version_number => x_api_version_number
718: , p_api_service_level => x_api_service_level
719: , p_init_msg_list => FND_API.G_TRUE
720: , x_return_status => l_return_status
721: , x_msg_count => x_msg_count
722: , x_msg_data => x_msg_data
723: , p_line_tbl => l_line_tbl

Line 752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

748: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
749: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
750: END IF;
751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSE

Line 753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

749: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
750: END IF;
751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSE
757: --

Line 754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

750: END IF;
751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSE
757: --
758: b_result := FALSE;

Line 755: RAISE FND_API.G_EXC_ERROR;

751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSE
757: --
758: b_result := FALSE;
759: --

Line 773: WHEN FND_API.G_EXC_ERROR THEN

769: RETURN(b_Result);
770: --
771: EXCEPTION
772: --
773: WHEN FND_API.G_EXC_ERROR THEN
774: --
775: b_result := TRUE;
776: --
777: IF (l_debug <> -1) THEN

Line 779: FND_API.G_RET_STS_ERROR');

775: b_result := TRUE;
776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
779: FND_API.G_RET_STS_ERROR');
780: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
781: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
782: END IF;
783: --

Line 812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

808: END IF;
809: --
810: RETURN(b_Result);
811: --
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: --
814: b_result := TRUE;
815: --
816: IF (l_debug <> -1) THEN

Line 818: FND_API.G_RET_STS_UNEXP_ERROR');

814: b_result := TRUE;
815: --
816: IF (l_debug <> -1) THEN
817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);

Line 848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

844: RETURN(b_Result);
845: --
846: WHEN OTHERS THEN
847: --
848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849: --
850: IF (l_debug <> -1) THEN
851: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
852: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));

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

1596: ELSIF x_Op_rec.supplier_item_ext is not null THEN
1597: x_oe_line_rec.ordered_item := x_Op_rec.supplier_item_ext;
1598: END IF;
1599: --
1600: --x_oe_line_rec.item_type_code := fnd_api.g_miss_char;
1601: IF (l_debug <> -1) THEN
1602: rlm_core_sv.dlog(k_DEBUG,'customer_item_revision', x_Op_rec.customer_item_revision);
1603: END IF;
1604: --