[Home] [Help]
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: /* Bugfix 12863728 */
96: l_line_tbl oe_order_pub.line_tbl_type;
97: i number;
98: j number;
92: l_start_time NUMBER;
93: l_end_time NUMBER;
94: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
95: /* Bugfix 12863728 */
96: l_line_tbl oe_order_pub.line_tbl_type;
97: i number;
98: j number;
99: l_lock_status varchar2(1);
100: e_LockOrderFailed EXCEPTION;
192: IF (l_debug <> -1) THEN
193: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl.count',l_line_tbl.count);
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
817: x_oe_api_version NUMBER:=1;
818: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
819: e_ProcessConstraint EXCEPTION;
820: l_control_rec OE_GLOBALS.control_rec_type;
821: l_line_rec oe_order_pub.line_rec_type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
818: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
819: e_ProcessConstraint EXCEPTION;
820: l_control_rec OE_GLOBALS.control_rec_type;
821: l_line_rec oe_order_pub.line_rec_type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
819: e_ProcessConstraint EXCEPTION;
820: l_control_rec OE_GLOBALS.control_rec_type;
821: l_line_rec oe_order_pub.line_rec_type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
820: l_control_rec OE_GLOBALS.control_rec_type;
821: l_line_rec oe_order_pub.line_rec_type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
821: l_line_rec oe_order_pub.line_rec_type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
822: l_line_tbl oe_order_pub.Line_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
823: l_header_out_rec oe_order_pub.Header_Rec_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
824: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
825: l_header_val_rec oe_order_pub.header_val_rec_type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
826: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
827: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
828: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
829: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
830: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
831: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
832: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
833: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
834: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
835: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
843: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
836: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
843: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
844: b_Result BOOLEAN := FALSE;
837: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
843: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
844: b_Result BOOLEAN := FALSE;
845: v_DebugMode NUMBER;
838: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
843: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
844: b_Result BOOLEAN := FALSE;
845: v_DebugMode NUMBER;
846: x_api_version_number NUMBER := 1;
839: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
840: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
841: l_action_request_out_tbl oe_order_pub.request_tbl_type;
842: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
843: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
844: b_Result BOOLEAN := FALSE;
845: v_DebugMode NUMBER;
846: x_api_version_number NUMBER := 1;
847: v_interface_line NUMBER;
855: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
856: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
857: END IF;
858: --
859: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
860: RLM_TPA_SV.BuildOELine(l_line_tbl(1),x_Key_rec.req_rec);
861: l_line_tbl(1).line_id := x_Key_rec.dem_rec.line_id;
862: l_line_tbl(1).operation := x_Operation;
863: l_line_tbl(1).ordered_quantity := x_OperationQty;
1423:
1424: PROCEDURE BuildTPOELine
1425:
1426: ===========================================================================*/
1427: PROCEDURE BuildTPOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1428: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1429: IS
1430: BEGIN
1431: --
1501:
1502: PROCEDURE BuildOELine
1503:
1504: ===========================================================================*/
1505: PROCEDURE BuildOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1506: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1507: IS
1508: b_ATP BOOLEAN;
1509: BEGIN