127:
128: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_HOOK_ERROR');
129: FND_MESSAGE.SET_TOKEN('HOOK_API','OE_DUAL_UOM_HOOK.GET_PRICING_UOM');
130: FND_MESSAGE.SET_TOKEN('VALID_VALUES','Ordered UOM (O), Primary UOM (P) or Secondary UOM (S)');
131: OE_MSG_PUB.Add;
132: RAISE FND_API.G_EXC_ERROR;
133:
134: END IF;
135:
458: RAISE FND_API.G_EXC_ERROR;
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: WHEN OTHERS THEN
462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
463: THEN
464: OE_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME
466: , 'Delete_Dependents'
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: WHEN OTHERS THEN
462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
463: THEN
464: OE_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME
466: , 'Delete_Dependents'
467: );
468: END IF;
855: oe_debug_pub.add('Need not query shipping tables hence setting the counter to -1');
856: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
857: end if;
858: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
859: OE_MSG_PUB.ADD;
860:
861: ELSIF p_x_line_rec.LINE_CATEGORY_CODE='ORDER' THEN
862:
863: BEGIN
891: if l_debug_level > 0 then
892: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
893: end if;
894: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
895: OE_MSG_PUB.ADD;
896:
897: ELSIF l_ship_inv_count=0 THEN
898:
899: l_update_shipping := FND_API.G_TRUE;
1840: G_ORDERED_QTY_CHANGE := FALSE;
1841:
1842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1843: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
1844: oe_msg_pub.add;
1845: RAISE FND_API.G_EXC_ERROR;
1846: END IF;
1847: END IF;
1848: Fix ends */
1942: -- { start fix for 2648277
1943: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
1944: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1945: -- end fix for 2648277}
1946: OE_MSG_PUB.Add;
1947:
1948: */
1949: /* IR ISO Change Management : Comment this code Ends */
1950:
2895: -- { start fix for 2648277
2896: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
2897: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
2898: -- end fix for 2648277}
2899: OE_MSG_PUB.Add;
2900: END IF;
2901:
2902: END IF;
2903: */ -- Commented for IR ISO Ends.
3640: oe_debug_pub.add('old sold_to is' || to_char(p_old_line_rec.sold_to_org_id), 1);
3641: oe_debug_pub.add('new sold_to is' || to_char(p_x_line_rec.sold_to_org_id), 1);
3642: end if;
3643: fnd_message.set_name('ONT','OE_CUSTOMER_ITEM_EXIST');
3644: OE_MSG_PUB.Add;
3645: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
3646: END IF;
3647: END IF;
3648: END IF;
6357: oe_debug_pub.add( 'Value of fte count '||l_fte_count);
6358: end if;
6359: If l_fte_count > 0 Then
6360: --fnd_message.set_name('ONT','MY_MESSAGE');
6361: --OE_MSG_PUB.Add;
6362: --NULL;
6363: OE_GLOBALS.G_FTE_REINVOKE := 'Y';
6364: ELSE
6365: OE_GLOBALS.G_FTE_REINVOKE := 'N';
9819:
9820:
9821: WHEN OTHERS THEN
9822:
9823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9824: THEN
9825: OE_MSG_PUB.Add_Exc_Msg
9826: ( G_PKG_NAME
9827: , 'Update_Row'
9821: WHEN OTHERS THEN
9822:
9823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9824: THEN
9825: OE_MSG_PUB.Add_Exc_Msg
9826: ( G_PKG_NAME
9827: , 'Update_Row'
9828: );
9829: END IF;
10703: EXCEPTION
10704:
10705: WHEN OTHERS THEN
10706:
10707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10708: THEN
10709: OE_MSG_PUB.Add_Exc_Msg
10710: ( G_PKG_NAME
10711: , 'Insert_Row'
10705: WHEN OTHERS THEN
10706:
10707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10708: THEN
10709: OE_MSG_PUB.Add_Exc_Msg
10710: ( G_PKG_NAME
10711: , 'Insert_Row'
10712: );
10713: END IF;
11198: END IF;
11199:
11200: WHEN others THEN
11201: IF l_debug_level > 0 THEN
11202: oe_msg_pub.add_text
11203: ('Update_Shipping_From_OE, DCP post process'|| sqlerrm);
11204: oe_debug_pub.add('OM call to WSH DCP,others '|| sqlerrm, 1);
11205: END IF;
11206: END;
11215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11217:
11218: WHEN OTHERS THEN
11219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11220: THEN
11221: OE_MSG_PUB.Add_Exc_Msg
11222: ( G_PKG_NAME
11223: ,'Delete_Row');
11217:
11218: WHEN OTHERS THEN
11219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11220: THEN
11221: OE_MSG_PUB.Add_Exc_Msg
11222: ( G_PKG_NAME
11223: ,'Delete_Row');
11224: END IF;
11225:
12041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12042:
12043: WHEN OTHERS THEN
12044:
12045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12046: THEN
12047: OE_MSG_PUB.Add_Exc_Msg
12048: ( G_PKG_NAME
12049: , 'Query_Row'
12043: WHEN OTHERS THEN
12044:
12045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12046: THEN
12047: OE_MSG_PUB.Add_Exc_Msg
12048: ( G_PKG_NAME
12049: , 'Query_Row'
12050: );
12051: END IF;
12874: (p_header_id IS NOT NULL
12875: AND
12876: p_header_id <> FND_API.G_MISS_NUM)
12877: THEN
12878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12879: THEN
12880: OE_MSG_PUB.Add_Exc_Msg
12881: ( G_PKG_NAME
12882: , 'Query Rows'
12876: p_header_id <> FND_API.G_MISS_NUM)
12877: THEN
12878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12879: THEN
12880: OE_MSG_PUB.Add_Exc_Msg
12881: ( G_PKG_NAME
12882: , 'Query Rows'
12883: , 'Keys are mutually exclusive: line_id = '|| p_line_id || ', header_id = '|| p_header_id
12884: );
13721: END IF;
13722:
13723: WHEN OTHERS THEN
13724:
13725: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13726: THEN
13727: OE_MSG_PUB.Add_Exc_Msg
13728: ( G_PKG_NAME
13729: , 'Query_Rows'
13723: WHEN OTHERS THEN
13724:
13725: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13726: THEN
13727: OE_MSG_PUB.Add_Exc_Msg
13728: ( G_PKG_NAME
13729: , 'Query_Rows'
13730: );
13731: END IF;
13889: oe_debug_pub.add('in lock model exception');
13890: END IF;
13891:
13892: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
13893: OE_MSG_PUB.Add;
13894:
13895: RAISE CAN_NOT_LOCK_MODEL;
13896:
13897: WHEN NO_DATA_FOUND THEN
13996:
13997: x_return_status := FND_API.G_RET_STS_ERROR;
13998: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
13999:
14000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14001: THEN
14002:
14003: -- Release the lock
14004: ROLLBACK TO Lock_Row;
14003: -- Release the lock
14004: ROLLBACK TO Lock_Row;
14005:
14006: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
14007: OE_MSG_PUB.Add;
14008:
14009: END IF;
14010:
14011: END IF;
14033: OE_GLOBALS.G_LOCK_TEST := 'N';
14034: x_return_status := FND_API.G_RET_STS_ERROR;
14035: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
14036:
14037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14038: THEN
14039:
14040: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14041: OE_MSG_PUB.Add;
14037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14038: THEN
14039:
14040: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14041: OE_MSG_PUB.Add;
14042:
14043: END IF;
14044: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
14045: OE_GLOBALS.G_LOCK_TEST := 'N';
14045: OE_GLOBALS.G_LOCK_TEST := 'N';
14046: x_return_status := FND_API.G_RET_STS_ERROR;
14047: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
14048:
14049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14050: THEN
14051:
14052: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14053: OE_MSG_PUB.Add;
14049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14050: THEN
14051:
14052: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14053: OE_MSG_PUB.Add;
14054:
14055: END IF;
14056: WHEN OTHERS THEN
14057: OE_GLOBALS.G_LOCK_TEST := 'N';
14057: OE_GLOBALS.G_LOCK_TEST := 'N';
14058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14059: p_x_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14060:
14061: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14062: THEN
14063: OE_MSG_PUB.Add_Exc_Msg
14064: ( G_PKG_NAME
14065: , 'Lock_Row'
14059: p_x_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14060:
14061: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14062: THEN
14063: OE_MSG_PUB.Add_Exc_Msg
14064: ( G_PKG_NAME
14065: , 'Lock_Row'
14066: );
14067: END IF;
14097: p_line_id <> FND_API.G_MISS_NUM) AND
14098: (p_header_id IS NOT NULL AND
14099: p_header_id <> FND_API.G_MISS_NUM)
14100: THEN
14101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14102: THEN
14103: OE_MSG_PUB.Add_Exc_Msg
14104: ( G_PKG_NAME
14105: , 'Lock Rows'
14099: p_header_id <> FND_API.G_MISS_NUM)
14100: THEN
14101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14102: THEN
14103: OE_MSG_PUB.Add_Exc_Msg
14104: ( G_PKG_NAME
14105: , 'Lock Rows'
14106: , 'Keys are mutually exclusive: line_id = '||
14107: p_line_id || ', header_id = '|| p_header_id );
14168: WHEN NO_DATA_FOUND THEN
14169:
14170: x_return_status := FND_API.G_RET_STS_ERROR;
14171:
14172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14173: THEN
14174: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14175: OE_MSG_PUB.Add;
14176: END IF;
14171:
14172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14173: THEN
14174: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14175: OE_MSG_PUB.Add;
14176: END IF;
14177:
14178: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
14179:
14177:
14178: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
14179:
14180: x_return_status := FND_API.G_RET_STS_ERROR;
14181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14182: THEN
14183: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14184: OE_MSG_PUB.Add;
14185: END IF;
14180: x_return_status := FND_API.G_RET_STS_ERROR;
14181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14182: THEN
14183: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14184: OE_MSG_PUB.Add;
14185: END IF;
14186:
14187: WHEN OTHERS THEN
14188:
14187: WHEN OTHERS THEN
14188:
14189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14190:
14191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14192: THEN
14193: OE_MSG_PUB.Add_Exc_Msg
14194: ( G_PKG_NAME
14195: , 'Lock_Row'
14189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14190:
14191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14192: THEN
14193: OE_MSG_PUB.Add_Exc_Msg
14194: ( G_PKG_NAME
14195: , 'Lock_Row'
14196: );
14197: END IF;
14940: THEN
14941:
14942: IF p_x_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
14943:
14944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14945: THEN
14946:
14947: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
14945: THEN
14946:
14947: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
14949: OE_MSG_PUB.Add;
14950:
14951: END IF;
14952:
14953: ELSE
14968: THEN
14969:
14970: IF p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
14971:
14972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14973: THEN
14974:
14975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
14973: THEN
14974:
14975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
14977: OE_MSG_PUB.Add;
14978:
14979: END IF;
14980:
14981: ELSE
14996: THEN
14997:
14998: IF p_x_line_rec.demand_bucket_type_code <> FND_API.G_MISS_CHAR THEN
14999:
15000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15001: THEN
15002:
15003: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
15001: THEN
15002:
15003: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
15005: OE_MSG_PUB.Add;
15006:
15007: END IF;
15008:
15009: ELSE
15024: THEN
15025:
15026: IF p_x_line_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
15027:
15028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15029: THEN
15030:
15031: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
15029: THEN
15030:
15031: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
15033: OE_MSG_PUB.Add;
15034:
15035: END IF;
15036:
15037: ELSE
15052: THEN
15053:
15054: IF p_x_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
15055:
15056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15057: THEN
15058:
15059: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
15057: THEN
15058:
15059: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
15061: OE_MSG_PUB.Add;
15062:
15063: END IF;
15064:
15065: ELSE
15080: THEN
15081:
15082: IF p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
15083:
15084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15085: THEN
15086:
15087: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
15085: THEN
15086:
15087: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
15089: OE_MSG_PUB.Add;
15090:
15091: END IF;
15092:
15093: ELSE
15110: THEN
15111:
15112: IF p_x_line_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
15113:
15114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15115: THEN
15116:
15117: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
15115: THEN
15116:
15117: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
15119: OE_MSG_PUB.Add;
15120:
15121: END IF;
15122:
15123: ELSE
15139: THEN
15140:
15141: IF p_x_line_rec.intermed_ship_to_contact_id <> FND_API.G_MISS_NUM THEN
15142:
15143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15144: THEN
15145:
15146: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
15144: THEN
15145:
15146: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
15148: OE_MSG_PUB.Add;
15149:
15150: END IF;
15151:
15152: ELSE
15173: THEN
15174:
15175: IF p_x_line_rec.intermed_ship_to_org_id <> FND_API.G_MISS_NUM THEN
15176:
15177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15178: THEN
15179:
15180: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15181: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
15178: THEN
15179:
15180: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15181: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
15182: OE_MSG_PUB.Add;
15183:
15184: END IF;
15185:
15186: ELSE
15213: THEN
15214:
15215: IF p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
15216:
15217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15218: THEN
15219:
15220: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
15218: THEN
15219:
15220: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
15222: OE_MSG_PUB.Add;
15223:
15224: END IF;
15225:
15226: ELSE
15241: THEN
15242:
15243: IF p_x_line_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
15244:
15245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15246: THEN
15247:
15248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
15246: THEN
15247:
15248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
15250: OE_MSG_PUB.Add;
15251:
15252: END IF;
15253:
15254: ELSE
15269: THEN
15270:
15271: IF p_x_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
15272:
15273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15274: THEN
15275:
15276: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
15274: THEN
15275:
15276: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
15278: OE_MSG_PUB.Add;
15279:
15280: END IF;
15281:
15282: ELSE
15297: THEN
15298:
15299: IF p_x_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN
15300:
15301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15302: THEN
15303:
15304: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
15302: THEN
15303:
15304: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
15306: OE_MSG_PUB.Add;
15307:
15308: END IF;
15309:
15310: ELSE
15325: THEN
15326:
15327: IF p_x_line_rec.over_ship_reason_code <> FND_API.G_MISS_CHAR THEN
15328:
15329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15330: THEN
15331:
15332: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
15330: THEN
15331:
15332: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
15334: OE_MSG_PUB.Add;
15335:
15336: END IF;
15337:
15338: ELSE
15353: THEN
15354:
15355: IF p_x_line_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
15356:
15357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15358: THEN
15359:
15360: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
15358: THEN
15359:
15360: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
15362: OE_MSG_PUB.Add;
15363:
15364: END IF;
15365:
15366: ELSE
15381: THEN
15382:
15383: IF p_x_line_rec.price_list_id <> FND_API.G_MISS_NUM THEN
15384:
15385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15386: THEN
15387:
15388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
15386: THEN
15387:
15388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
15390: OE_MSG_PUB.Add;
15391:
15392: END IF;
15393:
15394: ELSE
15409: THEN
15410:
15411: IF p_x_line_rec.project_id <> FND_API.G_MISS_NUM THEN
15412:
15413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15414: THEN
15415:
15416: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
15414: THEN
15415:
15416: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
15418: OE_MSG_PUB.Add;
15419:
15420: END IF;
15421:
15422: ELSE
15437: THEN
15438:
15439: IF p_x_line_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
15440:
15441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15442: THEN
15443:
15444: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
15442: THEN
15443:
15444: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
15446: OE_MSG_PUB.Add;
15447:
15448: END IF;
15449:
15450: ELSE
15467: THEN
15468:
15469: IF p_x_line_rec.rla_schedule_type_code <> FND_API.G_MISS_CHAR THEN
15470:
15471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15472: THEN
15473:
15474: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
15472: THEN
15473:
15474: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
15476: OE_MSG_PUB.Add;
15477:
15478: END IF;
15479:
15480: ELSE
15495: THEN
15496:
15497: IF p_x_line_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
15498:
15499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15500: THEN
15501:
15502: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
15500: THEN
15501:
15502: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
15504: OE_MSG_PUB.Add;
15505:
15506: END IF;
15507:
15508: ELSE
15523: THEN
15524:
15525: IF p_x_line_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
15526:
15527: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15528: THEN
15529:
15530: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
15528: THEN
15529:
15530: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
15532: OE_MSG_PUB.Add;
15533:
15534: END IF;
15535:
15536: ELSE
15556: THEN
15557:
15558: IF p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
15559:
15560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15561: THEN
15562:
15563: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
15561: THEN
15562:
15563: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
15565: OE_MSG_PUB.Add;
15566:
15567: END IF;
15568:
15569: ELSE
15589: THEN
15590:
15591: IF p_x_line_rec.task_id <> FND_API.G_MISS_NUM THEN
15592:
15593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15594: THEN
15595:
15596: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
15594: THEN
15595:
15596: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
15598: OE_MSG_PUB.Add;
15599:
15600: END IF;
15601:
15602: ELSE
15617: THEN
15618:
15619: IF p_x_line_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
15620:
15621: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15622: THEN
15623:
15624: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
15622: THEN
15623:
15624: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
15626: OE_MSG_PUB.Add;
15627:
15628: END IF;
15629:
15630: ELSE
15645: THEN
15646:
15647: IF p_x_line_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
15648:
15649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15650: THEN
15651:
15652: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
15650: THEN
15651:
15652: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
15654: OE_MSG_PUB.Add;
15655:
15656: END IF;
15657:
15658: ELSE
15673: THEN
15674:
15675: IF p_x_line_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
15676:
15677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15678: THEN
15679:
15680: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
15678: THEN
15679:
15680: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
15682: OE_MSG_PUB.Add;
15683:
15684: END IF;
15685:
15686: ELSE
15702: THEN
15703:
15704: IF p_x_line_rec.veh_cus_item_cum_key_id <> FND_API.G_MISS_NUM THEN
15705:
15706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15707: THEN
15708:
15709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
15707: THEN
15708:
15709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
15711: OE_MSG_PUB.Add;
15712:
15713: END IF;
15714:
15715: ELSE
15737:
15738: IF p_x_line_rec.invoice_to_customer_id <> FND_API.G_MISS_NUM THEN
15739:
15740:
15741: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15742: THEN
15743:
15744: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
15742: THEN
15743:
15744: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
15746: OE_MSG_PUB.Add;
15747:
15748: END IF;
15749:
15750: ELSE
15773:
15774: IF p_x_line_rec.ship_to_customer_id <> FND_API.G_MISS_NUM THEN
15775:
15776:
15777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15778: THEN
15779:
15780: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
15778: THEN
15779:
15780: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
15782: OE_MSG_PUB.Add;
15783:
15784: END IF;
15785:
15786: ELSE
15810:
15811: IF p_x_line_rec.deliver_to_customer_id <> FND_API.G_MISS_NUM THEN
15812:
15813:
15814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15815: THEN
15816:
15817: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
15815: THEN
15816:
15817: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
15819: OE_MSG_PUB.Add;
15820:
15821: END IF;
15822:
15823: ELSE
15883:
15884: IF p_x_line_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
15885:
15886:
15887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15888: THEN
15889:
15890: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
15888: THEN
15889:
15890: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
15892: OE_MSG_PUB.Add;
15893:
15894: END IF;
15895:
15896: ELSE
15929:
15930: IF p_x_line_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
15931:
15932:
15933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15934: THEN
15935:
15936: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15937: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
15934: THEN
15935:
15936: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15937: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
15938: OE_MSG_PUB.Add;
15939:
15940: END IF;
15941:
15942: ELSE
15975:
15976: IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
15977:
15978:
15979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15980: THEN
15981:
15982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
15980: THEN
15981:
15982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
15984: OE_MSG_PUB.Add;
15985:
15986: END IF;
15987:
15988: ELSE
16055:
16056: IF p_x_line_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
16057:
16058:
16059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16060: THEN
16061:
16062: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
16060: THEN
16061:
16062: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
16064: OE_MSG_PUB.Add;
16065:
16066: END IF;
16067:
16068: ELSE
16085:
16086: IF p_x_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
16087:
16088:
16089: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16090: THEN
16091:
16092: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
16090: THEN
16091:
16092: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
16094: OE_MSG_PUB.Add;
16095:
16096: END IF;
16097:
16098: ELSE
16115:
16116: IF p_x_line_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
16117:
16118:
16119: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16120: THEN
16121:
16122: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
16120: THEN
16121:
16122: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
16124: OE_MSG_PUB.Add;
16125:
16126: END IF;
16127:
16128: ELSE
16145: THEN
16146:
16147: IF p_x_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
16148:
16149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16150: THEN
16151:
16152: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
16150: THEN
16151:
16152: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
16154: OE_MSG_PUB.Add;
16155:
16156: END IF;
16157:
16158: ELSE
16175:
16176: IF p_x_line_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
16177:
16178:
16179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16180: THEN
16181:
16182: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
16180: THEN
16181:
16182: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
16184: OE_MSG_PUB.Add;
16185:
16186: END IF;
16187:
16188: ELSE
16206: IF p_x_line_rec.end_customer_id <>FND_API.G_MISS_NUM and
16207: p_x_line_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
16208:
16209:
16210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16211: THEN
16212:
16213: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16214: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
16211: THEN
16212:
16213: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16214: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
16215: OE_MSG_PUB.Add;
16216:
16217: END IF;
16218:
16219: ELSE
16246:
16247: IF p_x_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
16248:
16249:
16250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16251: THEN
16252:
16253: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
16251: THEN
16252:
16253: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
16255: OE_MSG_PUB.Add;
16256:
16257: END IF;
16258:
16259: ELSE
16288: IF p_line_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
16289: THEN
16290: IF p_x_line_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
16291:
16292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16293: THEN
16294:
16295: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
16293: THEN
16294:
16295: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
16297: OE_MSG_PUB.Add;
16298:
16299: END IF;
16300:
16301: ELSE
16315: IF p_line_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
16316: THEN
16317: IF p_x_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
16318:
16319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16320: THEN
16321:
16322: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
16320: THEN
16321:
16322: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
16324: OE_MSG_PUB.Add;
16325:
16326: END IF;
16327:
16328: ELSE
16342: IF p_line_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
16343: THEN
16344: IF p_x_line_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
16345:
16346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16347: THEN
16348:
16349: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
16347: THEN
16348:
16349: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
16351: OE_MSG_PUB.Add;
16352:
16353: END IF;
16354:
16355: ELSE
16369: --sol_ord_er #16014165 (Used in Order Import)
16370: IF p_line_val_rec.service_bill_profile <> FND_API.G_MISS_CHAR
16371: THEN
16372: IF p_x_line_rec.service_bill_profile_id <> FND_API.G_MISS_NUM THEN
16373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16374: THEN
16375: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_PROFILE');
16377: OE_MSG_PUB.Add;
16373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16374: THEN
16375: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_PROFILE');
16377: OE_MSG_PUB.Add;
16378: END IF;
16379: ELSE
16380: p_x_line_rec.service_bill_profile_id := OE_Value_To_Id.Billing_Profile
16381: ( p_service_bill_profile => p_line_val_rec.service_bill_profile
16388: -- Billing Option
16389: IF p_line_val_rec.service_bill_option <> FND_API.G_MISS_CHAR
16390: THEN
16391: IF p_x_line_rec.service_bill_option_code <> FND_API.G_MISS_CHAR THEN
16392: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16393: THEN
16394: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_OPTION');
16396: OE_MSG_PUB.Add;
16392: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16393: THEN
16394: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_OPTION');
16396: OE_MSG_PUB.Add;
16397: END IF;
16398: ELSE
16399: p_x_line_rec.service_bill_option_code := OE_Value_To_Id.Billing_Option
16400: ( p_service_bill_option => p_line_val_rec.service_bill_option
16407: --- Subscription Template
16408: IF p_line_val_rec.service_subs_template <> FND_API.G_MISS_CHAR
16409: THEN
16410: IF p_x_line_rec.service_subs_template_id <> FND_API.G_MISS_NUM THEN
16411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16412: THEN
16413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBSCRIPTION_TEMPLATE');
16415: OE_MSG_PUB.Add;
16411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16412: THEN
16413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBSCRIPTION_TEMPLATE');
16415: OE_MSG_PUB.Add;
16416: END IF;
16417: ELSE
16418: p_x_line_rec.service_subs_template_id := OE_Value_To_Id.Subscription_Template
16419: ( p_service_subs_template => p_line_val_rec.service_subs_template
16426: -- Coverage Template
16427: IF p_line_val_rec.service_cov_template <> FND_API.G_MISS_CHAR
16428: THEN
16429: IF p_x_line_rec.service_cov_template_id <> FND_API.G_MISS_NUM THEN
16430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16431: THEN
16432: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COVERAGE_TEMPLATE');
16434: OE_MSG_PUB.Add;
16430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16431: THEN
16432: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COVERAGE_TEMPLATE');
16434: OE_MSG_PUB.Add;
16435: END IF;
16436: ELSE
16437: p_x_line_rec.service_cov_template_id := OE_Value_To_Id.Coverage_Template
16438: ( p_service_cov_template => p_line_val_rec.service_cov_template
17182: oe_debug_pub.add('l_error_flag: ' || l_error_flag, 1);
17183: oe_debug_pub.add('l_error_message: ' || l_error_message, 1);
17184: oe_debug_pub.add('p_x_line_rec.ordered_item_id:'||p_x_line_rec.ordered_item_id,1);
17185: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');
17186: OE_MSG_PUB.Add;
17187: x_return_status := FND_API.G_RET_STS_ERROR;
17188: END IF;
17189:
17190: oe_debug_pub.add('Return Status after calling CI_Attribute_Value '||x_return_status, 1);
17953: oe_debug_pub.ADD('Calling IS_OVER_RETURN ',1);
17954: end if;
17955: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN
17956: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
17957: OE_MSG_PUB.Add;
17958: RAISE FND_API.G_EXC_ERROR;
17959: END IF;
17960: END IF;
17961: */
18041: oe_debug_pub.add('SYSTEM SPLIT Donot clear the Shipping Method',2);
18042: end if;
18043: END IF;
18044:
18045: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
18046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
18047: --bug 4190357 added l_meaning to the token
18048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
18049: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
18046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
18047: --bug 4190357 added l_meaning to the token
18048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
18049: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
18050: OE_MSG_PUB.Add;
18051: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
18052:
18053: if l_debug_level > 0 then
18054: oe_debug_pub.add('Value of freight_carrier after the call :'
18047: --bug 4190357 added l_meaning to the token
18048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
18049: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
18050: OE_MSG_PUB.Add;
18051: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
18052:
18053: if l_debug_level > 0 then
18054: oe_debug_pub.add('Value of freight_carrier after the call :'
18055: ||p_x_line_rec.shipping_method_code,2);
18414: p_x_line_rec.late_demand_penalty_factor <> FND_API.G_MISS_NUM AND
18415: p_x_line_rec.late_demand_penalty_factor < 0) THEN
18416:
18417: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_DEMAND_FACTOR_ZERO');
18418: OE_MSG_PUB.Add;
18419: RAISE FND_API.G_EXC_ERROR;
18420: END IF;
18421: ------------------------------------------------------------------------
18422: -- Call Scheduling to perform any scheduling on the line, if needed
18522: -- { start fix for 2648277
18523: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
18524: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
18525: -- end fix for 2648277}
18526: OE_MSG_PUB.ADD;
18527: END IF;
18528:
18529: */ -- Commented for IR ISO CMS project
18530:
18631: RAISE;
18632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
18633: RAISE;
18634: WHEN OTHERS THEN
18635: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18636: THEN
18637: oe_msg_pub.Add_Exc_Msg
18638: ( G_PKG_NAME
18639: , 'Pre_Write_Process'
18633: RAISE;
18634: WHEN OTHERS THEN
18635: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18636: THEN
18637: oe_msg_pub.Add_Exc_Msg
18638: ( G_PKG_NAME
18639: , 'Pre_Write_Process'
18640: );
18641: END IF;
18698: ELSE
18699: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18700: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18701: fnd_message.set_token('OBJECT','ORDER LINE');
18702: oe_msg_pub.add;
18703: RAISE FND_API.G_EXC_ERROR;
18704: END IF;
18705: END IF;
18706: END IF;
18709: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18710: end if;
18711: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18712: fnd_message.set_token('OBJECT','ORDER LINE');
18713: oe_msg_pub.add;
18714: raise FND_API.G_EXC_ERROR;
18715: END IF;
18716: END IF;
18717: END IF;
19173: ELSE
19174: CLOSE Model_Line_Number;
19175: END IF;
19176:
19177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
19178: THEN
19179:
19180: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
19181: OE_MSG_PUB.Add;
19177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
19178: THEN
19179:
19180: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
19181: OE_MSG_PUB.Add;
19182: RAISE FND_API.G_EXC_ERROR;
19183:
19184: END IF;
19185:
19192: ELSIF l_cursor_flag = 'O' THEN
19193: CLOSE Service_line_number;
19194: END IF;
19195:
19196: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
19197: THEN
19198: oe_msg_pub.Add_Exc_Msg
19199: ( G_PKG_NAME
19200: , 'Cascade_line_number'
19194: END IF;
19195:
19196: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
19197: THEN
19198: oe_msg_pub.Add_Exc_Msg
19199: ( G_PKG_NAME
19200: , 'Cascade_line_number'
19201: );
19202: END IF;
19614: and s.activity_status = 'COMPLETE';
19615: IF l_close_act_complete = 0 THEN
19616: oe_debug_pub.add(' Close_Line failed. Rollback the changes');
19617: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_ERROR');
19618: OE_MSG_PUB.ADD;
19619: RAISE FND_API.G_EXC_ERROR;
19620: END IF;
19621: END IF;
19622:
19847: RAISE;
19848:
19849: WHEN OTHERS THEN
19850:
19851: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
19852: THEN
19853: oe_msg_pub.Add_Exc_Msg
19854: ( G_PKG_NAME
19855: , 'Post_Write_Process'
19849: WHEN OTHERS THEN
19850:
19851: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
19852: THEN
19853: oe_msg_pub.Add_Exc_Msg
19854: ( G_PKG_NAME
19855: , 'Post_Write_Process'
19856: );
19857: END IF;
20102: END IF; --Added for bug 14298755
20103:
20104: IF l_valid_line_number = 'N' THEN
20105: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
20106: OE_MSG_PUB.ADD;
20107: l_return_status := FND_API.G_RET_STS_ERROR;
20108: RAISE FND_API.G_EXC_ERROR; --added for bug 14298755
20109: END IF;
20110:
20229: RAISE;
20230:
20231: WHEN OTHERS THEN
20232: oe_debug_pub.add('others error', 1);
20233: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
20234: THEN
20235: oe_msg_pub.Add_Exc_Msg
20236: ( G_PKG_NAME
20237: , 'Pre_Line_Process'
20231: WHEN OTHERS THEN
20232: oe_debug_pub.add('others error', 1);
20233: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
20234: THEN
20235: oe_msg_pub.Add_Exc_Msg
20236: ( G_PKG_NAME
20237: , 'Pre_Line_Process'
20238: );
20239: END IF;
20335: EXCEPTION
20336: WHEN NO_DATA_FOUND THEN
20337: RETURN NULL;
20338: WHEN OTHERS THEN
20339: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20340: THEN
20341: OE_MSG_PUB.Add_Exc_Msg
20342: ( G_PKG_NAME ,
20343: 'dual_uom_control'
20337: RETURN NULL;
20338: WHEN OTHERS THEN
20339: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20340: THEN
20341: OE_MSG_PUB.Add_Exc_Msg
20342: ( G_PKG_NAME ,
20343: 'dual_uom_control'
20344: );
20345: END IF;
20402: end if;
20403: RETURN NULL;
20404:
20405: WHEN OTHERS THEN
20406: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20407: THEN
20408: OE_MSG_PUB.Add_Exc_Msg
20409: ( G_PKG_NAME ,
20410: 'Get_Dual_Uom'
20404:
20405: WHEN OTHERS THEN
20406: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20407: THEN
20408: OE_MSG_PUB.Add_Exc_Msg
20409: ( G_PKG_NAME ,
20410: 'Get_Dual_Uom'
20411: );
20412: END IF;
20481: EXCEPTION
20482:
20483:
20484: WHEN OTHERS THEN
20485: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20486: THEN
20487: OE_MSG_PUB.Add_Exc_Msg
20488: ( G_PKG_NAME ,
20489: 'Get_Preferred_Grade'
20483:
20484: WHEN OTHERS THEN
20485: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
20486: THEN
20487: OE_MSG_PUB.Add_Exc_Msg
20488: ( G_PKG_NAME ,
20489: 'Get_Preferred_Grade'
20490: );
20491: END IF;
20833: END IF;
20834:
20835: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
20836: p_encoded => 'F');
20837: oe_msg_pub.add_text(p_message_text => l_buffer);
20838: IF l_debug_level > 0 THEN
20839: oe_debug_pub.add(l_buffer,1);
20840: END IF;
20841: RAISE fnd_api.g_exc_error;
20954: END IF;
20955:
20956: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
20957: p_encoded => 'F');
20958: oe_msg_pub.add_text(p_message_text => l_buffer);
20959: IF l_debug_level > 0 THEN
20960: oe_debug_pub.add(l_buffer,1);
20961: END IF;
20962: RAISE fnd_api.g_exc_error;
21060:
21061: --
21062: -- OPM END - BUG 2586841
21063: --
21064: OE_MSG_PUB.Add;
21065: RAISE FND_API.G_EXC_ERROR;
21066: --OPM B1478461 End
21067:
21068: WHEN fnd_api.g_exc_error THEN -- INVCONV
21068: WHEN fnd_api.g_exc_error THEN -- INVCONV
21069: RAISE FND_API.G_EXC_ERROR;
21070:
21071: WHEN OTHERS THEN
21072: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21073: THEN
21074: OE_MSG_PUB.Add_Exc_Msg
21075: ( G_PKG_NAME ,
21076: 'Sync_Dual_Qty'
21070:
21071: WHEN OTHERS THEN
21072: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21073: THEN
21074: OE_MSG_PUB.Add_Exc_Msg
21075: ( G_PKG_NAME ,
21076: 'Sync_Dual_Qty'
21077: );
21078: END IF;
21147:
21148: EXCEPTION
21149:
21150: WHEN OTHERS THEN
21151: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21152: THEN
21153: OE_MSG_PUB.Add_Exc_Msg
21154: ( G_PKG_NAME ,
21155: 'Calculate Ordered Quantity2'
21149:
21150: WHEN OTHERS THEN
21151: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21152: THEN
21153: OE_MSG_PUB.Add_Exc_Msg
21154: ( G_PKG_NAME ,
21155: 'Calculate Ordered Quantity2'
21156: );
21157: END IF;
22066:
22067: IF l_model_open_flag = 'N' THEN
22068: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22069: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22070: OE_MSG_PUB.Add;
22071: if l_debug_level > 0 then
22072: oe_debug_pub.add('model line is closed', 1);
22073: end if;
22074: RAISE FND_API.G_EXC_ERROR;
22076:
22077: IF l_fulfilled_flag = 'Y' THEN
22078: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22079: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22080: OE_MSG_PUB.Add;
22081: if l_debug_level > 0 then
22082: oe_debug_pub.add('model line is fulfilled', 1);
22083: end if;
22084: RAISE FND_API.G_EXC_ERROR;
22197:
22198: IF l_model_open_flag = 'N' THEN
22199: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22200: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22201: OE_MSG_PUB.Add;
22202: if l_debug_level > 0 then
22203: oe_debug_pub.add('model line is closed', 1);
22204: end if;
22205: RAISE FND_API.G_EXC_ERROR;
22207:
22208: IF l_fulfilled_flag = 'Y' THEN
22209: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22210: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22211: OE_MSG_PUB.Add;
22212: if l_debug_level > 0 then
22213: oe_debug_pub.add('model line is fulfilled', 1);
22214: end if;
22215: RAISE FND_API.G_EXC_ERROR;
22227: END IF;
22228:
22229: FND_MESSAGE.Set_Name('ONT', 'OE_ZERO_CHILD_QTY');
22230: FND_MESSAGE.Set_Token('ITEM', l_ord_item);
22231: OE_MSG_PUB.Add;
22232:
22233: IF l_debug_level > 0 THEN
22234: oe_debug_pub.add
22235: ('Child lines with zero qty can not be created', 1);
23009: EXCEPTION
23010:
23011: WHEN NO_DATA_FOUND THEN
23012:
23013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
23014: THEN
23015:
23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
23017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
23014: THEN
23015:
23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
23017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
23018: OE_MSG_PUB.Add;
23019:
23020: END IF;
23021:
23022:
23021:
23022:
23023: WHEN OTHERS THEN
23024:
23025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23026: THEN
23027: OE_MSG_PUB.Add_Exc_Msg
23028: ( G_PKG_NAME
23029: , 'get_customer_details'
23023: WHEN OTHERS THEN
23024:
23025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23026: THEN
23027: OE_MSG_PUB.Add_Exc_Msg
23028: ( G_PKG_NAME
23029: , 'get_customer_details'
23030: );
23031: END IF;
23071: -- { start fix for 2648277
23072: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
23073: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
23074: -- end fix for 2648277}
23075: OE_MSG_PUB.Add;
23076:
23077: END IF;
23078:
23079: */ -- COmmented for IR ISO CMS Project
23124: oe_debug_pub.add('Audit Required Reason missing - error', 1);
23125: end if;
23126: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
23127: fnd_message.set_token('OBJECT','ORDER LINE');
23128: oe_msg_pub.add;
23129: RAISE FND_API.G_EXC_ERROR;
23130: END IF;
23131:
23132: END IF;
23328: END IF;
23329:
23330: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
23331: p_encoded => 'F');
23332: oe_msg_pub.add_text(p_message_text => l_buffer);
23333: IF l_debug_level > 0 THEN
23334: oe_debug_pub.add(l_buffer,1);
23335: END IF;
23336: RAISE TOLERANCE_ERROR ;
23353: ,0);
23354: IF (l_return = -68 ) THEN
23355: x_return_status := -1;
23356: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23357: OE_MSG_PUB.Add;
23358: ELSIF(l_return = -69 ) THEN
23359: x_return_status := -1;
23360: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23361: OE_MSG_PUB.Add;
23357: OE_MSG_PUB.Add;
23358: ELSIF(l_return = -69 ) THEN
23359: x_return_status := -1;
23360: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23361: OE_MSG_PUB.Add;
23362: END IF; */
23363:
23364:
23365: END IF; -- IF (NVL(p_ordered_quantity2,0) = 0
23458: oe_debug_pub.add('Calculate_dual_quantity - tolerance error 2' ,1);
23459: END IF;
23460: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
23461: p_encoded => 'F');
23462: oe_msg_pub.add_text(p_message_text => l_buffer);
23463: IF l_debug_level > 0 THEN
23464: oe_debug_pub.add(l_buffer,1);
23465: END IF;
23466: RAISE TOLERANCE_ERROR ;
23575: END IF;
23576:
23577: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
23578: p_encoded => 'F');
23579: oe_msg_pub.add_text(p_message_text => l_buffer);
23580: IF l_debug_level > 0 THEN
23581: oe_debug_pub.add(l_buffer,1);
23582: END IF;
23583: RAISE TOLERANCE_ERROR ;
23662:
23663: WHEN UOM_CONVERSION_FAILED THEN
23664: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qty', 1);
23665: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
23666: OE_MSG_PUB.Add;
23667: x_return_status := -99999;
23668: --RAISE FND_API.G_EXC_ERROR;
23669:
23670:
23673: x_return_status := -1;
23674: --RAISE -- FND_API.G_EXC_ERROR; -- INVCONV
23675:
23676: WHEN OTHERS THEN
23677: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23678: THEN
23679: OE_MSG_PUB.Add_Exc_Msg
23680: ( G_PKG_NAME ,
23681: 'Calculate_dual_quantity'
23675:
23676: WHEN OTHERS THEN
23677: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23678: THEN
23679: OE_MSG_PUB.Add_Exc_Msg
23680: ( G_PKG_NAME ,
23681: 'Calculate_dual_quantity'
23682: );
23683: END IF;
23939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
23940: WHEN OTHERS THEN
23941: oe_debug_pub.add('Others error in Log_Blanket_Request');
23942: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200));
23943: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23944: THEN
23945: OE_MSG_PUB.Add_Exc_Msg
23946: ( G_PKG_NAME ,
23947: 'Log_Blanket_Request'
23941: oe_debug_pub.add('Others error in Log_Blanket_Request');
23942: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200));
23943: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
23944: THEN
23945: OE_MSG_PUB.Add_Exc_Msg
23946: ( G_PKG_NAME ,
23947: 'Log_Blanket_Request'
23948: );
23949: END IF;
24116: EXCEPTION
24117:
24118: WHEN OTHERS THEN
24119:
24120: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24121: THEN
24122: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'GET_ITEM_INFO');
24123: END IF;
24124:
24118: WHEN OTHERS THEN
24119:
24120: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24121: THEN
24122: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'GET_ITEM_INFO');
24123: END IF;
24124:
24125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
24126:
24176: (p_line_id => p_x_line_rec.line_id
24177: ,p_header_id => p_x_line_rec.header_id) THEN
24178:
24179: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_PO_CANCELLED');
24180: OE_MSG_PUB.Add;
24181: RAISE FND_API.G_EXC_ERROR;
24182: END IF;
24183:
24184:
24274: /* IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity2 - remove this as valid now for INVCONV
24275: ,p_old_line_rec.ordered_quantity2) THEN
24276:
24277: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_QTY_CHANGED');
24278: OE_MSG_PUB.Add;
24279:
24280: IF l_debug_level > 0 THEN
24281: OE_DEBUG_PUB.Add('Warning!! Secondary Qty Changed...', 2);
24282: END IF;
24285: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity_uom2
24286: ,p_old_line_rec.ordered_quantity_uom2) THEN
24287:
24288: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_UOM_CHANGED');
24289: OE_MSG_PUB.Add;
24290:
24291: IF l_debug_level > 0 THEN
24292: OE_DEBUG_PUB.Add('Warning!! Secondary Qty UOM Changed...', 2);
24293: END IF;
24296: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.preferred_grade
24297: ,p_old_line_rec.preferred_grade) THEN
24298:
24299: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_OPM_GRADE_CHANGED');
24300: OE_MSG_PUB.Add;
24301:
24302: IF l_debug_level > 0 THEN
24303: OE_DEBUG_PUB.Add('Warning!! OPM Grade Changed...', 2);
24304: END IF;
24399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
24400:
24401: WHEN OTHERS THEN
24402:
24403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24404: THEN
24405: OE_MSG_PUB.Add_Exc_Msg
24406: ( G_PKG_NAME,
24407: 'Log_Dropship_CMS_Request');
24401: WHEN OTHERS THEN
24402:
24403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24404: THEN
24405: OE_MSG_PUB.Add_Exc_Msg
24406: ( G_PKG_NAME,
24407: 'Log_Dropship_CMS_Request');
24408: END IF;
24409:
24586: l_index := p_x_line_tbl.FIRST;
24587:
24588: WHILE l_index IS NOT NULL LOOP
24589:
24590: OE_MSG_PUB.set_msg_context
24591: ( p_entity_code => 'LINE'
24592: ,p_entity_id => p_x_line_tbl(l_index).line_id
24593: ,p_header_id => p_x_line_tbl(l_index).header_id
24594: ,p_line_id => p_x_line_tbl(l_index).line_id
24720: END IF;
24721:
24722:
24723: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
24724: OE_MSG_PUB.reset_msg_context('LINE');
24725: RETURN;
24726: END IF;
24727:
24728: l_index := p_x_line_tbl.NEXT(l_index);
24726: END IF;
24727:
24728: l_index := p_x_line_tbl.NEXT(l_index);
24729:
24730: OE_MSG_PUB.reset_msg_context('LINE');
24731:
24732: END LOOP;
24733:
24734: OE_CUSTOMER_INFO_PVT.G_SOLD_TO_CUSTOMER_ID := NULL;
24742: EXCEPTION
24743: WHEN OTHERS THEN
24744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
24745:
24746: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24747: THEN
24748: OE_MSG_PUB.Add_Exc_Msg
24749: ( G_PKG_NAME
24750: , 'Get_customer_info_ids'
24744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
24745:
24746: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
24747: THEN
24748: OE_MSG_PUB.Add_Exc_Msg
24749: ( G_PKG_NAME
24750: , 'Get_customer_info_ids'
24751: );
24752: END IF;