342: IF g_upgraded_flag IN ('P','I') THEN
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'ORDER PARTIALLY UPGRADED ' ) ;
345: END IF;
346: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_UPG_ORDER');
347: OE_MSG_PUB.Add;
348: RETURN FALSE;
349: END IF;
350:
394: BEGIN
395: --Moac changes start
396: l_org_id := MO_GLOBAL.get_current_org_id;
397: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
398: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
399: OE_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: --Moac changes end
917:
918: --MOAC changes start
919: l_org_id := MO_GLOBAL.get_current_org_id;
920: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
921: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
922: OE_MSG_PUB.Add;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925: --MOAC changes end
1502:
1503: --MOAC changes start
1504: l_org_id := MO_GLOBAL.get_current_org_id;
1505: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
1506: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
1507: OE_MSG_PUB.Add;
1508: RAISE FND_API.G_EXC_ERROR;
1509: END IF;
1510: --MOAC changes end
2410: BEGIN
2411: --Moac changes start
2412: l_org_id := MO_GLOBAL.get_current_org_id;
2413: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
2414: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
2415: OE_MSG_PUB.Add;
2416: RAISE FND_API.G_EXC_ERROR;
2417: END IF;
2418: --Moac changes end
3753: BEGIN
3754: --MOAC changes start
3755: l_org_id := MO_GLOBAL.get_current_org_id;
3756: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
3757: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
3758: OE_MSG_PUB.Add;
3759: RAISE FND_API.G_EXC_ERROR;
3760: END IF;
3761: --MOAC changes end
4337: BEGIN
4338: --MOAC changes start
4339: l_org_id := MO_GLOBAL.get_current_org_id;
4340: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4341: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4342: OE_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4345: --MOAC changes end
4985: BEGIN
4986: --MOAC changes start
4987: l_org_id := MO_GLOBAL.get_current_org_id;
4988: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4989: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4990: OE_MSG_PUB.Add;
4991: RAISE FND_API.G_EXC_ERROR;
4992: END IF;
4993: --MOAC changes end
6222: IF p_x_header_rec.operation IS NOT NULL AND
6223: p_x_header_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
6224: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
6225: OE_GLOBALS.G_OPR_NONE) THEN
6226: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
6227: OE_MSG_PUB.Add;
6228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6229: END IF;
6230: END IF;
6294: p_x_header_adj_tbl(I).header_id = FND_API.G_MISS_NUM)
6295: THEN
6296: IF p_x_header_rec.header_id IS NULL OR
6297: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6298: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6299: OE_MSG_PUB.Add;
6300: RAISE FND_API.G_EXC_ERROR;
6301: ELSE
6302: -- Copy parent_id.
6377: p_x_header_price_att_tbl(I).header_id = FND_API.G_MISS_NUM)
6378: THEN
6379: IF p_x_header_rec.header_id IS NULL OR
6380: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6381: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6382: OE_MSG_PUB.Add;
6383: RAISE FND_API.G_EXC_ERROR;
6384: ELSE
6385:
6463: IF l_debug_level > 0 THEN
6464: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6465: END IF;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6468: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6469: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6470: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6471: OE_MSG_PUB.Add;
6464: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6465: END IF;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6468: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6469: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6470: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6471: OE_MSG_PUB.Add;
6472: END IF;
6465: END IF;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6468: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6469: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6470: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6471: OE_MSG_PUB.Add;
6472: END IF;
6473: END IF;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6468: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
6469: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6470: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_att_tbl(I).adj_index);
6471: OE_MSG_PUB.Add;
6472: END IF;
6473: END IF;
6474:
6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6527: END IF;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6530: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6531: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6532: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6533: OE_MSG_PUB.Add;
6526: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( P_X_HEADER_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
6527: END IF;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6530: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6531: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6532: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6533: OE_MSG_PUB.Add;
6534: END IF;
6527: END IF;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6530: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6531: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6532: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6533: OE_MSG_PUB.Add;
6534: END IF;
6535: END IF;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6530: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
6531: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6532: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_header_adj_assoc_tbl(I).adj_index);
6533: OE_MSG_PUB.Add;
6534: END IF;
6535: END IF;
6536:
6591: THEN
6592:
6593: IF p_x_header_rec.header_id IS NULL OR
6594: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6595: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6596: OE_MSG_PUB.Add;
6597: RAISE FND_API.G_EXC_ERROR;
6598: ELSE
6599: -- Copy parent_id.
6702: THEN
6703:
6704: IF p_x_header_rec.header_id IS NULL OR
6705: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
6706: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
6707: OE_MSG_PUB.Add;
6708: RAISE FND_API.G_EXC_ERROR;
6709: ELSE
6710: -- Copy parent_id.
6779: IF p_x_line_tbl(I).operation IS NOT NULL AND
6780: p_x_line_tbl(I).operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
6781: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
6782: OE_GLOBALS.G_OPR_INSERT, OE_GLOBALS.G_OPR_NONE) THEN
6783: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
6784: OE_MSG_PUB.Add;
6785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6786: END IF;
6787:
6804: END;
6805:
6806: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
6807: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
6808: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
6809: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
6810: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
6811: OE_MSG_PUB.Add;
6812: RAISE FND_API.G_EXC_ERROR;
6805:
6806: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
6807: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
6808: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
6809: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
6810: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
6811: OE_MSG_PUB.Add;
6812: RAISE FND_API.G_EXC_ERROR;
6813: ELSE
6806: IF NVL(l_transaction_phase_code,'F') = 'N' THEN
6807: oe_debug_pub.add(' Line Id : '||p_x_line_tbl(I).line_id||' cannot be split. It is in Negotiation Phase.');
6808: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');
6809: FND_MESSAGE.SET_TOKEN('OBJECT',p_x_line_tbl(I).line_id);
6810: FND_MESSAGE.SET_TOKEN('REASON','Line is in Negotiation Phase');
6811: OE_MSG_PUB.Add;
6812: RAISE FND_API.G_EXC_ERROR;
6813: ELSE
6814: l_call_split := TRUE;
6859: -- from header ID on the header record or other lines
6860: IF (l_header_id IS NOT NULL AND
6861: l_header_id <> FND_API.G_MISS_NUM) THEN
6862: IF p_x_line_tbl(I).header_id <> l_header_id THEN
6863: fnd_message.set_name('ONT', 'OE_HEADER_MISSING');
6864: oe_msg_pub.add;
6865: RAISE FND_API.G_EXC_ERROR;
6866: END IF;
6867: END IF;
6947: IF l_debug_level > 0 THEN
6948: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
6949: END IF;
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
6953: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6954: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
6955: OE_MSG_PUB.Add;
6948: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
6949: END IF;
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
6953: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6954: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
6955: OE_MSG_PUB.Add;
6956:
6949: END IF;
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
6953: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6954: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
6955: OE_MSG_PUB.Add;
6956:
6957: END IF;
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
6953: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
6954: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_scredit_tbl(I).line_index);
6955: OE_MSG_PUB.Add;
6956:
6957: END IF;
6958: END IF;
6993: IF l_debug_level > 0 THEN
6994: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
6995: END IF;
6996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6997: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
6999: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7000: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7001: OE_MSG_PUB.Add;
6994: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
6995: END IF;
6996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6997: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
6999: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7000: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7001: OE_MSG_PUB.Add;
7002:
6995: END IF;
6996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6997: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
6999: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7000: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7001: OE_MSG_PUB.Add;
7002:
7003: END IF;
6996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6997: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
6998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Payment');
6999: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7000: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_payment_tbl(I).line_index);
7001: OE_MSG_PUB.Add;
7002:
7003: END IF;
7004: END IF;
7048: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
7049: END IF;
7050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7051:
7052: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7054: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7055: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7056: OE_MSG_PUB.Add;
7049: END IF;
7050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7051:
7052: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7054: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7055: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7056: OE_MSG_PUB.Add;
7057:
7050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7051:
7052: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7054: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7055: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7056: OE_MSG_PUB.Add;
7057:
7058: END IF;
7051:
7052: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
7054: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7055: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_tbl(I).line_index);
7056: OE_MSG_PUB.Add;
7057:
7058: END IF;
7059: END IF;
7270:
7271: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
7272: THEN
7273:
7274: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7276: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7277: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7278: oe_msg_pub.Add;
7271: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
7272: THEN
7273:
7274: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7276: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7277: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7278: oe_msg_pub.Add;
7279:
7272: THEN
7273:
7274: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7276: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7277: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7278: oe_msg_pub.Add;
7279:
7280: END IF;
7273:
7274: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
7276: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7277: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_lot_serial_tbl(I).line_index);
7278: oe_msg_pub.Add;
7279:
7280: END IF;
7281: END IF;
7353: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( P_X_LINE_PRICE_ATT_TBL ( I ) .LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
7354: END IF;
7355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7356:
7357: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7359: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7360: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7361: OE_MSG_PUB.Add;
7354: END IF;
7355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7356:
7357: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7359: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7360: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7361: OE_MSG_PUB.Add;
7362:
7355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7356:
7357: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7359: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7360: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7361: OE_MSG_PUB.Add;
7362:
7363: END IF;
7356:
7357: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
7359: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7360: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_price_att_tbl(I).line_index);
7361: OE_MSG_PUB.Add;
7362:
7363: END IF;
7364: END IF;
7438: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( P_X_LINE_ADJ_ATT_TBL ( I ) .ADJ_INDEX ) ||'ON ADJ ATTRIBS' , 2 ) ;
7439: END IF;
7440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7441:
7442: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7443: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7444: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7445: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7446: OE_MSG_PUB.Add;
7439: END IF;
7440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7441:
7442: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7443: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7444: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7445: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7446: OE_MSG_PUB.Add;
7447:
7440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7441:
7442: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7443: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7444: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7445: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7446: OE_MSG_PUB.Add;
7447:
7448: END IF;
7441:
7442: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7443: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
7444: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7445: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_att_tbl(I).Adj_index);
7446: OE_MSG_PUB.Add;
7447:
7448: END IF;
7449: END IF;
7500: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( P_X_LINE_ADJ_ASSOC_TBL ( I ) .ADJ_INDEX ) ||'ON ADJ ASSOCS' , 2 ) ;
7501: END IF;
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503:
7504: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7505: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7506: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7507: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7508: OE_MSG_PUB.Add;
7501: END IF;
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503:
7504: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7505: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7506: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7507: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7508: OE_MSG_PUB.Add;
7509:
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503:
7504: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7505: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7506: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7507: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7508: OE_MSG_PUB.Add;
7509:
7510: END IF;
7503:
7504: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
7505: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
7506: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
7507: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',p_x_line_adj_assoc_tbl(I).Adj_index);
7508: OE_MSG_PUB.Add;
7509:
7510: END IF;
7511: END IF;
7578: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR HEADER ENTITY' , 2 ) ;
7579: END IF;
7580: IF p_x_header_rec.header_id IS NULL OR
7581: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
7582: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
7583: OE_MSG_PUB.Add;
7584: RAISE FND_API.G_EXC_ERROR;
7585: ELSE
7586: p_x_action_request_tbl(I).entity_id := p_x_header_rec.header_id;
7624: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR VERIFY_PAYMENT' , 2 ) ;
7625: END IF;
7626: IF p_x_header_rec.header_id IS NULL OR
7627: p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
7628: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
7629: OE_MSG_PUB.Add;
7630: RAISE FND_API.G_EXC_ERROR;
7631: ELSE
7632: p_x_action_request_tbl(I).entity_id := p_x_header_rec.header_id;
8437: IF l_header_rec.operation IS NOT NULL AND
8438: l_header_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
8439: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
8440: OE_GLOBALS.G_OPR_NONE) THEN
8441: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
8442: OE_MSG_PUB.Add;
8443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8444: END IF;
8445: END IF;
8510: l_Header_Adj_rec.header_id = FND_API.G_MISS_NUM)
8511: THEN
8512: IF l_header_rec.header_id IS NULL OR
8513: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
8514: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
8515: OE_MSG_PUB.Add;
8516: RAISE FND_API.G_EXC_ERROR;
8517: ELSE
8518: -- Copy parent_id.
8595: l_Header_Price_Att_rec.header_id = FND_API.G_MISS_NUM)
8596: THEN
8597: IF l_header_rec.header_id IS NULL OR
8598: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
8599: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
8600: OE_MSG_PUB.Add;
8601: RAISE FND_API.G_EXC_ERROR;
8602: ELSE
8603:
8683: IF l_debug_level > 0 THEN
8684: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ATT_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8685: END IF;
8686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8687: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8688: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8689: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8690: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8691: OE_MSG_PUB.Add;
8684: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ATT_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8685: END IF;
8686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8687: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8688: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8689: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8690: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8691: OE_MSG_PUB.Add;
8692: END IF;
8685: END IF;
8686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8687: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8688: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8689: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8690: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8691: OE_MSG_PUB.Add;
8692: END IF;
8693: END IF;
8686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8687: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8688: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Attribs');
8689: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8690: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Att_Rec.adj_index);
8691: OE_MSG_PUB.Add;
8692: END IF;
8693: END IF;
8694:
8773: IF l_debug_level > 0 THEN
8774: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ASSOC_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8775: END IF;
8776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8777: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8778: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
8779: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8780: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
8781: OE_MSG_PUB.Add;
8774: oe_debug_pub.add( 'INVALID ADJ INDEX '|| TO_CHAR ( L_HEADER_ADJ_ASSOC_REC.ADJ_INDEX ) || 'ON HEADER ADJ ATTRIBUTES' , 2 ) ;
8775: END IF;
8776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8777: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8778: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
8779: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8780: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
8781: OE_MSG_PUB.Add;
8782: END IF;
8775: END IF;
8776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8777: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8778: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
8779: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8780: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
8781: OE_MSG_PUB.Add;
8782: END IF;
8783: END IF;
8776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8777: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
8778: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Header_Adj_Assocs');
8779: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
8780: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Header_Adj_Assoc_Rec.adj_index);
8781: OE_MSG_PUB.Add;
8782: END IF;
8783: END IF;
8784:
8869: l_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM)
8870: THEN
8871: IF l_header_rec.header_id IS NULL OR -- p_x_header_rec replaced with l_header_rec for 2896409
8872: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
8873: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
8874: OE_MSG_PUB.Add;
8875: RAISE FND_API.G_EXC_ERROR;
8876: ELSE
8877:
8979: IF l_line_rec.operation IS NOT NULL AND
8980: l_line_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE,
8981: OE_GLOBALS.G_OPR_DELETE, OE_GLOBALS.G_OPR_UPDATE,
8982: OE_GLOBALS.G_OPR_INSERT, OE_GLOBALS.G_OPR_NONE) THEN
8983: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
8984: OE_MSG_PUB.Add;
8985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8986: END IF;
8987:
9037: -- from header ID on the header record or other lines
9038: IF (l_header_id IS NOT NULL AND
9039: l_header_id <> FND_API.G_MISS_NUM) THEN
9040: IF l_line_tbl(I).header_id <> l_header_id THEN
9041: fnd_message.set_name('ONT', 'OE_HEADER_MISSING');
9042: oe_msg_pub.add;
9043: RAISE FND_API.G_EXC_ERROR;
9044: END IF;
9045: END IF;
9225: IF l_debug_level > 0 THEN
9226: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
9227: END IF;
9228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9229: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9231: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9232: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9233: OE_MSG_PUB.Add;
9226: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON LINE SALES CREDITS' , 2 ) ;
9227: END IF;
9228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9229: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9231: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9232: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9233: OE_MSG_PUB.Add;
9234:
9227: END IF;
9228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9229: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9231: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9232: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9233: OE_MSG_PUB.Add;
9234:
9235: END IF;
9228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9229: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Scredit');
9231: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9232: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Scredit_rec.line_index);
9233: OE_MSG_PUB.Add;
9234:
9235: END IF;
9236: END IF;
9282: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
9283: END IF;
9284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9285:
9286: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9287: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9288: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9289: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9290: OE_MSG_PUB.Add;
9283: END IF;
9284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9285:
9286: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9287: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9288: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9289: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9290: OE_MSG_PUB.Add;
9291:
9284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9285:
9286: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9287: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9288: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9289: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9290: OE_MSG_PUB.Add;
9291:
9292: END IF;
9285:
9286: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9287: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj');
9288: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9289: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_rec.line_index);
9290: OE_MSG_PUB.Add;
9291:
9292: END IF;
9293: END IF;
9449:
9450: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
9451: THEN
9452:
9453: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9455: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9456: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9457: oe_msg_pub.Add;
9450: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
9451: THEN
9452:
9453: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9455: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9456: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9457: oe_msg_pub.Add;
9458:
9451: THEN
9452:
9453: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9455: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9456: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9457: oe_msg_pub.Add;
9458:
9459: END IF;
9452:
9453: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Lot_Serial');
9455: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9456: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Lot_Serial_rec.line_index);
9457: oe_msg_pub.Add;
9458:
9459: END IF;
9460: END IF;
9534: oe_debug_pub.add( 'INVALID LINE INDEX ' ||TO_CHAR ( L_LINE_PRICE_ATT_REC.LINE_INDEX ) ||'ON PRICE ADJUSTMENTS' , 2 ) ;
9535: END IF;
9536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9537:
9538: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9539: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9540: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9541: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9542: OE_MSG_PUB.Add;
9535: END IF;
9536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9537:
9538: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9539: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9540: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9541: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9542: OE_MSG_PUB.Add;
9543:
9536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9537:
9538: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9539: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9540: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9541: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9542: OE_MSG_PUB.Add;
9543:
9544: END IF;
9537:
9538: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9539: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Price_Att');
9540: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9541: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Price_Att_rec.line_index);
9542: OE_MSG_PUB.Add;
9543:
9544: END IF;
9545: END IF;
9620: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( L_LINE_ADJ_ATT_REC.ADJ_INDEX ) ||'ON ADJ ATTRIBS' , 2 ) ;
9621: END IF;
9622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9623:
9624: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9625: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9626: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9627: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9628: OE_MSG_PUB.Add;
9621: END IF;
9622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9623:
9624: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9625: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9626: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9627: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9628: OE_MSG_PUB.Add;
9629:
9622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9623:
9624: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9625: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9626: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9627: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9628: OE_MSG_PUB.Add;
9629:
9630: END IF;
9623:
9624: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9625: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Att');
9626: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9627: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Att_rec.Adj_index);
9628: OE_MSG_PUB.Add;
9629:
9630: END IF;
9631: END IF;
9707: oe_debug_pub.add( 'INVALID ADJ INDEX ' ||TO_CHAR ( L_LINE_ADJ_ASSOC_REC.ADJ_INDEX ) ||'ON ADJ ASSOCS' , 2 ) ;
9708: END IF;
9709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9710:
9711: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9713: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9714: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9715: OE_MSG_PUB.Add;
9708: END IF;
9709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9710:
9711: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9713: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9714: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9715: OE_MSG_PUB.Add;
9716:
9709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9710:
9711: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9713: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9714: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9715: OE_MSG_PUB.Add;
9716:
9717: END IF;
9710:
9711: fnd_message.set_name('ONT','OE_API_INV_PARENT_INDEX');
9712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Line_Adj_Assoc');
9713: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
9714: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Line_Adj_Assoc_rec.Adj_index);
9715: OE_MSG_PUB.Add;
9716:
9717: END IF;
9718: END IF;
9804: IF (l_request_tbl(k).entity_id = FND_API.G_MISS_NUM
9805: OR l_request_tbl(k).entity_id is null ) THEN
9806: IF l_header_rec.header_id IS NULL OR
9807: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
9808: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
9809: OE_MSG_PUB.Add;
9810: RAISE FND_API.G_EXC_ERROR;
9811: ELSE
9812:
9863: oe_debug_pub.add( 'SETTING HEADER IDS ON REQUEST TABLE FOR HEADER ENTITY' , 2 ) ;
9864: END IF;
9865: IF l_header_rec.header_id IS NULL OR
9866: l_header_rec.header_id = FND_API.G_MISS_NUM THEN
9867: FND_MESSAGE.SET_NAME('ONT','OE_HEADER_MISSING');
9868: OE_MSG_PUB.Add;
9869: RAISE FND_API.G_EXC_ERROR;
9870: ELSE
9871: l_request_tbl(I).entity_id := l_header_rec.header_id;
11705: IF l_debug_level > 0 THEN
11706: oe_debug_pub.add( 'SELECT COMP_CODE FAILED , NO DATA FOUND ' , 1 ) ;
11707: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11708: END IF;
11709: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_IN_BILL');
11710: --bug4015696
11711: IF p_x_line_rec.ordered_item IS NULL OR
11712: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11713: IF p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN
11725: ,p_sold_to_org_id => p_x_line_rec.sold_to_org_id
11726: ,x_ordered_item => p_x_line_rec.ordered_item );
11727: IF p_x_line_rec.ordered_item IS NULL OR
11728: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11729: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.inventory_item_id);
11730: ELSE
11731: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11732: END IF;
11733: ELSE
11727: IF p_x_line_rec.ordered_item IS NULL OR
11728: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
11729: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.inventory_item_id);
11730: ELSE
11731: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11732: END IF;
11733: ELSE
11734: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11735: END IF;
11730: ELSE
11731: FND_MESSAGE.Set_Token('ITEM',p_x_line_rec.ordered_item);
11732: END IF;
11733: ELSE
11734: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11735: END IF;
11736: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11737: oe_msg_pub.add;
11738:
11732: END IF;
11733: ELSE
11734: FND_MESSAGE.Set_Token('ITEM', p_x_line_rec.ordered_item);
11735: END IF;
11736: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11737: oe_msg_pub.add;
11738:
11739: IF p_process_partial THEN
11740: IF l_debug_level > 0 THEN /* Bug # 4036765 */
11755: oe_debug_pub.add( 'SELECT COMP_CODE FAILED , TOO_MANY ROWS ' , 1 ) ;
11756: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11757: END IF;
11758:
11759: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11760: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11761: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11762: oe_msg_pub.add;
11763: RAISE FND_API.G_EXC_ERROR;
11756: oe_debug_pub.add( 'ITEM: '|| P_X_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
11757: END IF;
11758:
11759: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11760: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11761: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11762: oe_msg_pub.add;
11763: RAISE FND_API.G_EXC_ERROR;
11764:
11757: END IF;
11758:
11759: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
11760: FND_MESSAGE.Set_Token('COMPONENT', p_x_line_rec.ordered_item);
11761: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_line_rec.inventory_item_id));
11762: oe_msg_pub.add;
11763: RAISE FND_API.G_EXC_ERROR;
11764:
11765: WHEN OTHERS THEN
12100: oe_debug_pub.add
12101: ('TOO MANY ROWS IN MISSING_CLASSES: PACK H NEW MI',1);
12102: END IF;
12103: ELSE
12104: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12105: FND_MESSAGE.SET_TOKEN
12106: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12107: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12108: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12101: ('TOO MANY ROWS IN MISSING_CLASSES: PACK H NEW MI',1);
12102: END IF;
12103: ELSE
12104: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12105: FND_MESSAGE.SET_TOKEN
12106: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12107: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12108: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12109: p_x_line_tbl(l_top_model_line_index).line_number ||
12104: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MI_NOT_ALLOWED');
12105: FND_MESSAGE.SET_TOKEN
12106: ('MODEL', nvl(p_x_line_tbl(l_top_model_line_index).ordered_item,
12107: p_x_line_tbl(l_top_model_line_index).inventory_item_id));
12108: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
12109: p_x_line_tbl(l_top_model_line_index).line_number ||
12110: p_x_line_tbl(l_top_model_line_index).shipment_number);
12111: OE_MSG_PUB.Add;
12112: RAISE;