[Home] [Help]
428: FOR UPDATE;
429:
430: l_line_id := to_number(itemkey);
431:
432: OE_MSG_PUB.set_msg_context(p_entity_code => 'LINE'
433: ,p_entity_id => l_line_id
434: ,p_header_id => l_header_id
435: ,p_line_id => l_line_id
436: ,p_order_source_id => l_order_source_id
727: ELSE
728: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
729: END IF;
730: -- End modified for bug 2515791
731: OE_MSG_PUB.Add;
732:
733: resultout := 'COMPLETE:ON_HOLD';
734: OE_STANDARD_WF.Save_Messages;
735: OE_STANDARD_WF.Clear_Msg_Context;
875: OE_Line_Util.Query_Row
876: (p_line_id => to_number(itemkey),
877: x_line_rec => l_line_rec);
878:
879: OE_MSG_PUB.update_msg_context( p_entity_code => 'LINE'
880: ,p_entity_id => l_line_rec.line_id
881: ,p_header_id => l_line_rec.header_id
882: ,p_line_id => l_line_rec.line_id
883: ,p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref
1265: resultout := 'COMPLETE:NOT_ELIGIBLE';
1266: return;
1267: END IF;
1268:
1269: OE_MSG_PUB.set_msg_context(
1270: p_entity_code => 'LINE'
1271: ,p_entity_id => l_line_rec.line_id
1272: ,p_header_id => l_line_rec.header_id
1273: ,p_line_id => l_line_rec.line_id
1283: IF l_line_rec.ship_from_org_id is null THEN
1284: -- ship_from_org_id reqd
1285:
1286: FND_MESSAGE.SET_NAME('ONT','OE_DS_WHSE_REQD');
1287: OE_MSG_PUB.Add;
1288: resultout := 'COMPLETE:INCOMPLETE';
1289: OE_STANDARD_WF.Save_Messages;
1290: OE_STANDARD_WF.Clear_Msg_Context;
1291: return;
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'UNABLE TO ASSOCIATE RECEIVING LOCATION ; OEXWSCHB.PLS ' , 1 ) ;
1351: END IF;
1352: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1353: OE_MSG_PUB.Add;
1354: resultout := 'COMPLETE:INCOMPLETE';
1355: OE_STANDARD_WF.Save_Messages;
1356: OE_STANDARD_WF.Clear_Msg_Context;
1357: return;