36: END IF;
37: --
38: x_linecount := counter;
39: --
40: g_oe_line_tbl(x_linecount) := oe_order_pub.g_miss_line_rec;
41: --
42: RLM_TPA_SV.BuildOELine(g_oe_line_tbl(x_linecount),x_Op_tab(counter));
43: RLM_TPA_SV.BuildTpOELine(g_oe_line_tbl(x_linecount),x_Op_tab(counter));
44: --
83: e_ProcessOrderFailed EXCEPTION;
84: v_DebugMode NUMBER;
85: v_FileName VARCHAR2(2000);
86: l_control_rec OE_GLOBALS.Control_Rec_Type := OE_GLOBALS.G_MISS_CONTROL_REC;
87: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
88: v_line_id NUMBER;
89: x_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
90: x_token FND_NEW_MESSAGES.TYPE%TYPE;
91: v_msg_text VARCHAR2(32000);
90: x_token FND_NEW_MESSAGES.TYPE%TYPE;
91: v_msg_text VARCHAR2(32000);
92: l_start_time NUMBER;
93: l_end_time NUMBER;
94: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
95: --
96: BEGIN
97: --
98: IF (l_debug <> -1) THEN
645: x_oe_api_version NUMBER:=1;
646: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
646: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;
674: x_api_version_number NUMBER := 1;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;
674: x_api_version_number NUMBER := 1;
675: v_interface_line NUMBER;
683: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
684: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
685: END IF;
686: --
687: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
688: RLM_TPA_SV.BuildOELine(l_line_tbl(1),x_Key_rec.req_rec);
689: l_line_tbl(1).line_id := x_Key_rec.dem_rec.line_id;
690: l_line_tbl(1).operation := x_Operation;
691: l_line_tbl(1).ordered_quantity := x_OperationQty;
1251:
1252: PROCEDURE BuildTPOELine
1253:
1254: ===========================================================================*/
1255: PROCEDURE BuildTPOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1256: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1257: IS
1258: BEGIN
1259: --
1329:
1330: PROCEDURE BuildOELine
1331:
1332: ===========================================================================*/
1333: PROCEDURE BuildOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1334: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1335: IS
1336: b_ATP BOOLEAN;
1337: BEGIN