347: IF g_upgraded_flag IN ('P','I') THEN
348: IF l_debug_level > 0 THEN
349: oe_debug_pub.add( 'ORDER PARTIALLY UPGRADED ' ) ;
350: END IF;
351: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_UPG_ORDER');
352: OE_MSG_PUB.Add;
353: RETURN FALSE;
354: END IF;
355:
399: BEGIN
400: --Moac changes start
401: l_org_id := MO_GLOBAL.get_current_org_id;
402: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
403: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
404: OE_MSG_PUB.Add;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: --Moac changes end
954:
955: --MOAC changes start
956: l_org_id := MO_GLOBAL.get_current_org_id;
957: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
958: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
959: OE_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962: --MOAC changes end
1539:
1540: --MOAC changes start
1541: l_org_id := MO_GLOBAL.get_current_org_id;
1542: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
1543: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
1544: OE_MSG_PUB.Add;
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF;
1547: --MOAC changes end
2452:
2453: --Moac changes start
2454: l_org_id := MO_GLOBAL.get_current_org_id;
2455: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
2456: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
2457: OE_MSG_PUB.Add;
2458: RAISE FND_API.G_EXC_ERROR;
2459: END IF;
2460: --Moac changes end
3895: BEGIN
3896: --MOAC changes start
3897: l_org_id := MO_GLOBAL.get_current_org_id;
3898: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
3899: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
3900: OE_MSG_PUB.Add;
3901: RAISE FND_API.G_EXC_ERROR;
3902: END IF;
3903: --MOAC changes end
4479: BEGIN
4480: --MOAC changes start
4481: l_org_id := MO_GLOBAL.get_current_org_id;
4482: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4483: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4484: OE_MSG_PUB.Add;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: --MOAC changes end
5127: BEGIN
5128: --MOAC changes start
5129: l_org_id := MO_GLOBAL.get_current_org_id;
5130: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
5131: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
5132: OE_MSG_PUB.Add;
5133: RAISE FND_API.G_EXC_ERROR;
5134: END IF;
5135: --MOAC changes end
6443: IF p_x_header_rec.operation IS NOT NULL AND
6444: p_x_header_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
6445: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
6446: OE_GLOBALS.G_OPR_NONE) THEN
6447: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
6448: OE_MSG_PUB.Add;
6449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6450: END IF;
6451: END IF;
6515: p_x_header_adj_tbl(I).header_id = FND_API.G_MISS_NUM)
6516: THEN
6517: IF p_x_header_rec.header_id IS NULL OR
6518: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6519: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6520: OE_MSG_PUB.Add;
6521: RAISE FND_API.G_EXC_ERROR;
6522: ELSE
6523: -- Copy parent_id.
6598: p_x_header_price_att_tbl(I).header_id = FND_API.G_MISS_NUM)
6599: THEN
6600: IF p_x_header_rec.header_id IS NULL OR
6601: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6602: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6603: OE_MSG_PUB.Add;
6604: RAISE FND_API.G_EXC_ERROR;
6605: ELSE
6606:
6684: IF l_debug_level > 0 THEN
6685: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6686: END IF;
6687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6688: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6689: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6690: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6691: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6692: OE_MSG_PUB.Add;
6685: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6686: END IF;
6687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6688: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6689: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6690: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6691: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6692: OE_MSG_PUB.Add;
6693: END IF;
6686: END IF;
6687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6688: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6689: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6690: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6691: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6692: OE_MSG_PUB.Add;
6693: END IF;
6694: END IF;
6687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6688: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6689: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6690: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6691: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6692: OE_MSG_PUB.Add;
6693: END IF;
6694: END IF;
6695:
6746: IF l_debug_level > 0 THEN
6747: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6748: END IF;
6749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6750: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6751: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6752: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6753: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6754: OE_MSG_PUB.Add;
6747: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6748: END IF;
6749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6750: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6751: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6752: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6753: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6754: OE_MSG_PUB.Add;
6755: END IF;
6748: END IF;
6749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6750: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6751: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6752: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6753: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6754: OE_MSG_PUB.Add;
6755: END IF;
6756: END IF;
6749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6750: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6751: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6752: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6753: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6754: OE_MSG_PUB.Add;
6755: END IF;
6756: END IF;
6757:
6812: THEN
6813:
6814: IF p_x_header_rec.header_id IS NULL OR
6815: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6816: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6817: OE_MSG_PUB.Add;
6818: RAISE FND_API.G_EXC_ERROR;
6819: ELSE
6820: -- Copy parent_id.
6923: THEN
6924:
6925: IF p_x_header_rec.header_id IS NULL OR
6926: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6927: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6928: OE_MSG_PUB.Add;
6929: RAISE FND_API.G_EXC_ERROR;
6930: ELSE
6931: -- Copy parent_id.
7000: IF p_x_line_tbl(I).operation IS NOT NULL AND
7001: p_x_line_tbl(I).operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
7002: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
7003: OE_GLOBALS.G_OPR_INSERT, OE_GLOBALS.G_OPR_NONE) THEN
7004: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
7005: OE_MSG_PUB.Add;
7006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7007: END IF;
7008:
7025: END;
7026:
7027: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
7028: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
7029: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
7030: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
7031: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
7032: OE_MSG_PUB.Add;
7033: RAISE FND_API.G_EXC_ERROR;
7026:
7027: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
7028: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
7029: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
7030: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
7031: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
7032: OE_MSG_PUB.Add;
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSE
7027: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
7028: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
7029: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
7030: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
7031: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
7032: OE_MSG_PUB.Add;
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSE
7035: l_call_split := TRUE;
7080: -- from header ID on the header record or other lines
7081: IF (l_header_id IS NOT NULL AND
7082: l_header_id <> FND_API.G_MISS_NUM) THEN
7083: IF p_x_line_tbl(I).header_id <> l_header_id THEN
7084: fnd_message.set_name('ONT', 'OE_HEADER_MISSING');
7085: oe_msg_pub.add;
7086: RAISE FND_API.G_EXC_ERROR;
7087: END IF;
7088: END IF;
7168: IF l_debug_level > 0 THEN
7169: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
7170: END IF;
7171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7172: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7173: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
7174: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7175: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
7176: OE_MSG_PUB.Add;
7169: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
7170: END IF;
7171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7172: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7173: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
7174: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7175: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
7176: OE_MSG_PUB.Add;
7177:
7170: END IF;
7171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7172: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7173: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
7174: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7175: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
7176: OE_MSG_PUB.Add;
7177:
7178: END IF;
7171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7172: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7173: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
7174: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7175: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
7176: OE_MSG_PUB.Add;
7177:
7178: END IF;
7179: END IF;
7214: IF l_debug_level > 0 THEN
7215: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
7216: END IF;
7217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7218: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7219: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
7220: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7221: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7222: OE_MSG_PUB.Add;
7215: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
7216: END IF;
7217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7218: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7219: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
7220: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7221: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7222: OE_MSG_PUB.Add;
7223:
7216: END IF;
7217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7218: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7219: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
7220: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7221: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7222: OE_MSG_PUB.Add;
7223:
7224: END IF;
7217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7218: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7219: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
7220: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7221: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7222: OE_MSG_PUB.Add;
7223:
7224: END IF;
7225: END IF;
7269: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
7270: END IF;
7271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7272:
7273: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7274: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7276: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7277: OE_MSG_PUB.Add;
7270: END IF;
7271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7272:
7273: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7274: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7276: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7277: OE_MSG_PUB.Add;
7278:
7271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7272:
7273: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7274: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7276: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7277: OE_MSG_PUB.Add;
7278:
7279: END IF;
7272:
7273: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7274: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7276: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7277: OE_MSG_PUB.Add;
7278:
7279: END IF;
7280: END IF;
7491:
7492: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
7493: THEN
7494:
7495: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7496: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7497: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7498: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7499: oe_msg_pub.Add;
7492: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
7493: THEN
7494:
7495: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7496: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7497: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7498: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7499: oe_msg_pub.Add;
7500:
7493: THEN
7494:
7495: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7496: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7497: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7498: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7499: oe_msg_pub.Add;
7500:
7501: END IF;
7494:
7495: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7496: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7497: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7498: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7499: oe_msg_pub.Add;
7500:
7501: END IF;
7502: END IF;
7574: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( P_X_LINE_PRICE_ATT_TBL ( I ) .LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
7575: END IF;
7576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7577:
7578: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7579: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7580: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7581: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7582: OE_MSG_PUB.Add;
7575: END IF;
7576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7577:
7578: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7579: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7580: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7581: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7582: OE_MSG_PUB.Add;
7583:
7576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7577:
7578: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7579: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7580: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7581: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7582: OE_MSG_PUB.Add;
7583:
7584: END IF;
7577:
7578: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7579: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7580: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7581: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7582: OE_MSG_PUB.Add;
7583:
7584: END IF;
7585: END IF;
7659: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( P_X_LINE_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) ||'ON ADJ ATTRIBS' , 2 ) ;
7660: END IF;
7661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7662:
7663: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7664: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7665: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7666: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7667: OE_MSG_PUB.Add;
7660: END IF;
7661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7662:
7663: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7664: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7665: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7666: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7667: OE_MSG_PUB.Add;
7668:
7661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7662:
7663: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7664: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7665: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7666: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7667: OE_MSG_PUB.Add;
7668:
7669: END IF;
7662:
7663: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7664: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7665: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7666: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7667: OE_MSG_PUB.Add;
7668:
7669: END IF;
7670: END IF;
7721: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( P_X_LINE_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) ||'ON ADJ ASSOCS' , 2 ) ;
7722: END IF;
7723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7724:
7725: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7726: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7727: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7728: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7729: OE_MSG_PUB.Add;
7722: END IF;
7723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7724:
7725: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7726: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7727: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7728: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7729: OE_MSG_PUB.Add;
7730:
7723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7724:
7725: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7726: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7727: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7728: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7729: OE_MSG_PUB.Add;
7730:
7731: END IF;
7724:
7725: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7726: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7727: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7728: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7729: OE_MSG_PUB.Add;
7730:
7731: END IF;
7732: END IF;
7799: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR HEADER ENTITY' , 2 ) ;
7800: END IF;
7801: IF p_x_header_rec.header_id IS NULL OR
7802: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
7803: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
7804: OE_MSG_PUB.Add;
7805: RAISE FND_API.G_EXC_ERROR;
7806: ELSE
7807: p_x_action_request_tbl(I).entity_id := p_x_header_rec.header_id;
7846: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR VERIFY_PAYMENT' , 2 ) ;
7847: END IF;
7848: IF p_x_header_rec.header_id IS NULL OR
7849: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
7850: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
7851: OE_MSG_PUB.Add;
7852: RAISE FND_API.G_EXC_ERROR;
7853: ELSE
7854: p_x_action_request_tbl(I).entity_id := p_x_header_rec.header_id;
8666: IF l_header_rec.operation IS NOT NULL AND
8667: l_header_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
8668: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
8669: OE_GLOBALS.G_OPR_NONE) THEN
8670: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
8671: OE_MSG_PUB.Add;
8672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8673: END IF;
8674: END IF;
8739: l_Header_Adj_rec.header_id = FND_API.G_MISS_NUM)
8740: THEN
8741: IF l_header_rec.header_id IS NULL OR
8742: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
8743: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
8744: OE_MSG_PUB.Add;
8745: RAISE FND_API.G_EXC_ERROR;
8746: ELSE
8747: -- Copy parent_id.
8824: l_Header_Price_Att_rec.header_id = FND_API.G_MISS_NUM)
8825: THEN
8826: IF l_header_rec.header_id IS NULL OR
8827: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
8828: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
8829: OE_MSG_PUB.Add;
8830: RAISE FND_API.G_EXC_ERROR;
8831: ELSE
8832:
8912: IF l_debug_level > 0 THEN
8913: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ATT_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8914: END IF;
8915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8916: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8917: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8918: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8919: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8920: OE_MSG_PUB.Add;
8913: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ATT_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8914: END IF;
8915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8916: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8917: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8918: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8919: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8920: OE_MSG_PUB.Add;
8921: END IF;
8914: END IF;
8915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8916: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8917: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8918: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8919: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8920: OE_MSG_PUB.Add;
8921: END IF;
8922: END IF;
8915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8916: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8917: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8918: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8919: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8920: OE_MSG_PUB.Add;
8921: END IF;
8922: END IF;
8923:
9002: IF l_debug_level > 0 THEN
9003: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ASSOC_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
9004: END IF;
9005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9006: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
9008: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9009: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
9010: OE_MSG_PUB.Add;
9003: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ASSOC_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
9004: END IF;
9005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9006: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
9008: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9009: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
9010: OE_MSG_PUB.Add;
9011: END IF;
9004: END IF;
9005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9006: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
9008: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9009: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
9010: OE_MSG_PUB.Add;
9011: END IF;
9012: END IF;
9005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9006: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
9008: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9009: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
9010: OE_MSG_PUB.Add;
9011: END IF;
9012: END IF;
9013:
9098: l_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM)
9099: THEN
9100: IF l_header_rec.header_id IS NULL OR -- p_x_header_rec replaced with l_header_rec for 2896409
9101: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
9102: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
9103: OE_MSG_PUB.Add;
9104: RAISE FND_API.G_EXC_ERROR;
9105: ELSE
9106:
9208: IF l_line_rec.operation IS NOT NULL AND
9209: l_line_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
9210: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
9211: OE_GLOBALS.G_OPR_INSERT, OE_GLOBALS.G_OPR_NONE) THEN
9212: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
9213: OE_MSG_PUB.Add;
9214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9215: END IF;
9216:
9266: -- from header ID on the header record or other lines
9267: IF (l_header_id IS NOT NULL AND
9268: l_header_id <> FND_API.G_MISS_NUM) THEN
9269: IF l_line_tbl(I).header_id <> l_header_id THEN
9270: fnd_message.set_name('ONT', 'OE_HEADER_MISSING');
9271: oe_msg_pub.add;
9272: RAISE FND_API.G_EXC_ERROR;
9273: END IF;
9274: END IF;
9454: IF l_debug_level > 0 THEN
9455: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
9456: END IF;
9457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9458: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9459: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9460: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9461: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9462: OE_MSG_PUB.Add;
9455: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
9456: END IF;
9457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9458: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9459: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9460: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9461: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9462: OE_MSG_PUB.Add;
9463:
9456: END IF;
9457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9458: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9459: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9460: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9461: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9462: OE_MSG_PUB.Add;
9463:
9464: END IF;
9457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9458: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9459: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9460: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9461: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9462: OE_MSG_PUB.Add;
9463:
9464: END IF;
9465: END IF;
9511: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
9512: END IF;
9513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9514:
9515: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9517: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9518: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9519: OE_MSG_PUB.Add;
9512: END IF;
9513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9514:
9515: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9517: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9518: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9519: OE_MSG_PUB.Add;
9520:
9513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9514:
9515: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9517: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9518: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9519: OE_MSG_PUB.Add;
9520:
9521: END IF;
9514:
9515: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9517: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9518: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9519: OE_MSG_PUB.Add;
9520:
9521: END IF;
9522: END IF;
9678:
9679: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
9680: THEN
9681:
9682: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9683: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9684: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9685: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9686: oe_msg_pub.Add;
9679: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
9680: THEN
9681:
9682: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9683: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9684: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9685: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9686: oe_msg_pub.Add;
9687:
9680: THEN
9681:
9682: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9683: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9684: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9685: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9686: oe_msg_pub.Add;
9687:
9688: END IF;
9681:
9682: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9683: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9684: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9685: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9686: oe_msg_pub.Add;
9687:
9688: END IF;
9689: END IF;
9763: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_PRICE_ATT_REC.LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
9764: END IF;
9765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9766:
9767: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9768: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9769: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9770: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9771: OE_MSG_PUB.Add;
9764: END IF;
9765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9766:
9767: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9768: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9769: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9770: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9771: OE_MSG_PUB.Add;
9772:
9765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9766:
9767: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9768: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9769: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9770: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9771: OE_MSG_PUB.Add;
9772:
9773: END IF;
9766:
9767: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9768: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9769: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9770: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9771: OE_MSG_PUB.Add;
9772:
9773: END IF;
9774: END IF;
9849: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( L_LINE_ADJ_ATT_REC.ADJ_INDEX ) ||'ON ADJ ATTRIBS' , 2 ) ;
9850: END IF;
9851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9852:
9853: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9854: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9855: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9856: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9857: OE_MSG_PUB.Add;
9850: END IF;
9851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9852:
9853: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9854: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9855: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9856: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9857: OE_MSG_PUB.Add;
9858:
9851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9852:
9853: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9854: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9855: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9856: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9857: OE_MSG_PUB.Add;
9858:
9859: END IF;
9852:
9853: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9854: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9855: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9856: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9857: OE_MSG_PUB.Add;
9858:
9859: END IF;
9860: END IF;
9936: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( L_LINE_ADJ_ASSOC_REC.ADJ_INDEX ) ||'ON ADJ ASSOCS' , 2 ) ;
9937: END IF;
9938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9939:
9940: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9941: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9942: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9943: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9944: OE_MSG_PUB.Add;
9937: END IF;
9938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9939:
9940: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9941: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9942: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9943: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9944: OE_MSG_PUB.Add;
9945:
9938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9939:
9940: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9941: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9942: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9943: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9944: OE_MSG_PUB.Add;
9945:
9946: END IF;
9939:
9940: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9941: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9942: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9943: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9944: OE_MSG_PUB.Add;
9945:
9946: END IF;
9947: END IF;
10033: IF (l_request_tbl(k).entity_id = FND_API.G_MISS_NUM
10034: OR l_request_tbl(k).entity_id is null ) THEN
10035: IF l_header_rec.header_id IS NULL OR
10036: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
10037: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
10038: OE_MSG_PUB.Add;
10039: RAISE FND_API.G_EXC_ERROR;
10040: ELSE
10041:
10092: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR HEADER ENTITY' , 2 ) ;
10093: END IF;
10094: IF l_header_rec.header_id IS NULL OR
10095: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
10096: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
10097: OE_MSG_PUB.Add;
10098: RAISE FND_API.G_EXC_ERROR;
10099: ELSE
10100: l_request_tbl(I).entity_id := l_header_rec.header_id;
11934: IF l_debug_level > 0 THEN
11935: oe_debug_pub.add( 'SELECT COMP_CODE FAILED , NO DATA FOUND ' , 1 ) ;
11936: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11937: END IF;
11938: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_IN_BILL');
11939: --bug4015696
11940: IF p_x_line_rec.ordered_item IS NULL OR
11941: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11942: IF p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN
11954: ,p_sold_to_org_id => p_x_line_rec.sold_to_org_id
11955: ,x_ordered_item => p_x_line_rec.ordered_item );
11956: IF p_x_line_rec.ordered_item IS NULL OR
11957: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11958: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.inventory_item_id);
11959: ELSE
11960: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11961: END IF;
11962: ELSE
11956: IF p_x_line_rec.ordered_item IS NULL OR
11957: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11958: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.inventory_item_id);
11959: ELSE
11960: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11961: END IF;
11962: ELSE
11963: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11964: END IF;
11959: ELSE
11960: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11961: END IF;
11962: ELSE
11963: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11964: END IF;
11965: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11966: oe_msg_pub.add;
11967:
11961: END IF;
11962: ELSE
11963: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11964: END IF;
11965: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11966: oe_msg_pub.add;
11967:
11968: IF p_process_partial THEN
11969: IF l_debug_level > 0 THEN /* Bug # 4036765 */
11984: oe_debug_pub.add( 'SELECT COMP_CODE FAILED , TOO_MANY ROWS ' , 1 ) ;
11985: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11986: END IF;
11987:
11988: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11989: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11990: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11991: oe_msg_pub.add;
11992: RAISE FND_API.G_EXC_ERROR;
11985: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11986: END IF;
11987:
11988: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11989: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11990: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11991: oe_msg_pub.add;
11992: RAISE FND_API.G_EXC_ERROR;
11993:
11986: END IF;
11987:
11988: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11989: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11990: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11991: oe_msg_pub.add;
11992: RAISE FND_API.G_EXC_ERROR;
11993:
11994: WHEN OTHERS THEN
12329: oe_debug_pub.add
12330: ('TOO MANY ROWS IN MISSING_CLASSES: PACK H NEW MI',1);
12331: END IF;
12332: ELSE
12333: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12334: FND_MESSAGE.SET_TOKEN
12335: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12336: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12337: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12330: ('TOO MANY ROWS IN MISSING_CLASSES: PACK H NEW MI',1);
12331: END IF;
12332: ELSE
12333: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12334: FND_MESSAGE.SET_TOKEN
12335: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12336: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12337: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12338: p_x_line_tbl(l_top_model_line_index).line_number ||
12333: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12334: FND_MESSAGE.SET_TOKEN
12335: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12336: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12337: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12338: p_x_line_tbl(l_top_model_line_index).line_number ||
12339: p_x_line_tbl(l_top_model_line_index).shipment_number);
12340: OE_MSG_PUB.Add;
12341: RAISE;