82: e_BuildOELineTab EXCEPTION;
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;
136: IF (l_debug <> -1) THEN
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
144: END IF;
178: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).operation', g_oe_line_tbl(i).operation);
179: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).line_id', g_oe_line_tbl(i).line_id);
180: END IF;
181:
182: IF g_oe_line_tbl(i).operation <> OE_GLOBALS.G_OPR_CREATE THEN
183: l_line_tbl(j).line_id := g_oe_line_tbl(i).line_id;
184: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_LOCK;
185: j:= j+1;
186: END IF;
180: END IF;
181:
182: IF g_oe_line_tbl(i).operation <> OE_GLOBALS.G_OPR_CREATE THEN
183: l_line_tbl(j).line_id := g_oe_line_tbl(i).line_id;
184: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_LOCK;
185: j:= j+1;
186: END IF;
187: i := g_oe_line_tbl.NEXT(i);
188: END LOOP;
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
268: , x_msg_data => x_msg_data
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
268: , x_msg_data => x_msg_data
269: , p_line_tbl => g_oe_line_tbl
814: x_msg VARCHAR2(32000);
815: l_return_status VARCHAR2(1);
816: x_msg_data VARCHAR2(4000);
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;
816: x_msg_data VARCHAR2(4000);
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;
877: --
878: IF (l_debug <> -1) THEN
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
1530: END IF;
1531: END IF;
1532:
1533: IF( x_Op_rec.ordered_quantity = 0
1534: AND x_Op_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1535: --
1536: x_oe_line_rec.operation := x_Op_rec.operation;
1537: x_oe_line_rec.change_reason := 'EDI CANCELLATION';
1538: x_oe_line_rec.ordered_quantity := x_Op_rec.ordered_quantity;
1546: END IF;
1547: --
1548: ELSE
1549: --
1550: IF x_Op_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1551: --
1552: x_oe_line_rec.change_reason := 'EDI CANCELLATION';
1553: --
1554: END IF;
1650: IF x_Op_rec.attribute_category IS NOT NULL THEN
1651: x_oe_line_rec.context:= x_Op_rec.attribute_category;
1652: END IF;
1653: --
1654: IF x_Op_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --Bugfix 9223338 Added IF Condition
1655: x_oe_line_rec.created_by := FND_GLOBAL.USER_ID;
1656: x_oe_line_rec.creation_date := SYSDATE;
1657: END IF;
1658: x_oe_line_rec.last_updated_by := FND_GLOBAL.USER_ID;