eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_UTIL dependencies on OE_VALIDATE

Line 202: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

198:
199: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
200: BEGIN
201: IF l_debug_level > 0 then
202: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
203: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
204: END IF;
205:
206:

Line 216: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

212: AND site_use_id = p_deliver_to_org_id
213: AND status = 'A'
214: AND address_status ='A';--bug 2752321
215: IF l_debug_level > 0 then
216: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
217: END IF;
218: RETURN TRUE;
219:
220: ELSIF g_customer_relations = 'Y' THEN

Line 247: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

243: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
244: AND ROWNUM = 1;
245:
246: IF l_debug_level > 0 then
247: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
248: END IF;
249: RETURN TRUE;
250:
251: ELSIF g_customer_relations = 'A' THEN

Line 262: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

258: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
259: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
260: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
261: IF l_debug_level > 0 then
262: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
263: END IF;
264: RETURN TRUE;
265:
266:

Line 269: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

265:
266:
267: END IF;
268: IF l_debug_level > 0 then
269: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
270: END IF;
271: RETURN TRUE;
272:
273: EXCEPTION

Line 1079: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)

1075: p_old_header_rec.accounting_rule_id OR
1076: p_old_header_rec.accounting_rule_id IS NULL )
1077: THEN
1078:
1079: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
1080: THEN
1081: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1083: p_x_header_rec.accounting_rule_id := NULL;

Line 1097: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)

1093: p_old_header_rec.freight_terms_code OR
1094: p_old_header_rec.freight_terms_code IS NULL )
1095: THEN
1096:
1097: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
1098: THEN
1099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1100: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1101: p_x_header_rec.freight_terms_code := NULL;

Line 1115: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)

1111: p_old_header_rec.invoicing_rule_id OR
1112: p_old_header_rec.invoicing_rule_id IS NULL )
1113: THEN
1114:
1115: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
1116: THEN
1117: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1118: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1119: p_x_header_rec.invoicing_rule_id := NULL;

Line 1152: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)

1148: ( p_x_header_rec.payment_term_id <>
1149: p_old_header_rec.payment_term_id OR
1150: p_old_header_rec.payment_term_id IS NULL )
1151: THEN
1152: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
1153: THEN
1154: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1155: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1156: p_x_header_rec.payment_term_id := NULL;

Line 1169: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)

1165: ( p_x_header_rec.price_list_id <>
1166: p_old_header_rec.price_list_id OR
1167: p_old_header_rec.price_list_id IS NULL )
1168: THEN
1169: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)
1170: THEN
1171: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1172: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1173: p_x_header_rec.price_list_id := NULL;

Line 1187: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)

1183: p_old_header_rec.shipping_method_code OR
1184: p_old_header_rec.shipping_method_code IS NULL )
1185: THEN
1186:
1187: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
1188: THEN
1189: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1190: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1191: p_x_header_rec.shipping_method_code := NULL;

Line 1205: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)

1201: p_old_header_rec.ship_from_org_id OR
1202: p_old_header_rec.ship_from_org_id IS NULL )
1203: THEN
1204:
1205: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
1206: THEN
1207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1208: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1209: p_x_header_rec.ship_from_org_id := NULL;

Line 1223: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)

1219: p_old_header_rec.sold_to_org_id OR
1220: p_old_header_rec.sold_to_org_id IS NULL )
1221: THEN
1222:
1223: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
1224: THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226:
1227: END IF;

Line 1238: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)

1234: p_old_header_rec.sold_to_site_use_id OR
1235: p_old_header_rec.sold_to_site_use_id IS NULL )
1236: THEN
1237:
1238: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
1239: THEN
1240: x_return_status := FND_API.G_RET_STS_ERROR;
1241:
1242: END IF;

Line 1254: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)

1250: p_old_header_rec.invoice_to_org_id OR
1251: p_old_header_rec.invoice_to_org_id IS NULL )
1252: THEN
1253:
1254: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
1255: THEN
1256: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1257: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1258: p_x_header_rec.invoice_to_org_id := NULL;

Line 1272: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)

1268: p_old_header_rec.ship_to_org_id OR
1269: p_old_header_rec.ship_to_org_id IS NULL )
1270: THEN
1271:
1272: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
1273: THEN
1274: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1275: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: p_x_header_rec.ship_to_org_id := NULL;

Line 1290: IF NOT OE_Validate.Transactional_Curr

1286: p_old_header_rec.transactional_curr_code OR
1287: p_old_header_rec.transactional_curr_code IS NULL )
1288: THEN
1289:
1290: IF NOT OE_Validate.Transactional_Curr
1291: (p_x_header_rec.transactional_curr_code)
1292: THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: END IF;

Line 1305: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)

1301: p_old_header_rec.salesrep_id OR
1302: p_old_header_rec.salesrep_id IS NULL )
1303: THEN
1304:
1305: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
1306: THEN
1307: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1308: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1309: p_x_header_rec.salesrep_id := NULL;

Line 1412: IF NOT OE_VALIDATE.Header_Desc_Flex

1408:
1409: oe_debug_pub.add('Before calling header_desc_flex',2);
1410: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_BLKT_HEADER_ATTRIBUTES') = 'Y' THEN
1411:
1412: IF NOT OE_VALIDATE.Header_Desc_Flex
1413: (p_context => p_x_header_rec.context
1414: ,p_attribute1 => p_x_header_rec.attribute1
1415: ,p_attribute2 => p_x_header_rec.attribute2
1416: ,p_attribute3 => p_x_header_rec.attribute3

Line 1496: p_x_header_rec.context := oe_validate.g_context;

1492: ELSE -- if the flex validation is successfull
1493: -- For bug 2511313
1494: IF p_x_header_rec.context IS NULL
1495: OR p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
1496: p_x_header_rec.context := oe_validate.g_context;
1497: END IF;
1498:
1499: IF p_x_header_rec.attribute1 IS NULL
1500: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1501: p_x_header_rec.attribute1 := oe_validate.g_attribute1;

1497: END IF;
1498:
1499: IF p_x_header_rec.attribute1 IS NULL
1500: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1501: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
1502: END IF;
1503:
1504: IF p_x_header_rec.attribute2 IS NULL
1505: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1506: p_x_header_rec.attribute2 := oe_validate.g_attribute2;

1502: END IF;
1503:
1504: IF p_x_header_rec.attribute2 IS NULL
1505: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1506: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
1507: END IF;
1508:
1509: IF p_x_header_rec.attribute3 IS NULL
1510: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1511: p_x_header_rec.attribute3 := oe_validate.g_attribute3;

1507: END IF;
1508:
1509: IF p_x_header_rec.attribute3 IS NULL
1510: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1511: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
1512: END IF;
1513:
1514: IF p_x_header_rec.attribute4 IS NULL
1515: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1516: p_x_header_rec.attribute4 := oe_validate.g_attribute4;

1512: END IF;
1513:
1514: IF p_x_header_rec.attribute4 IS NULL
1515: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1516: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
1517: END IF;
1518:
1519: IF p_x_header_rec.attribute5 IS NULL
1520: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1521: p_x_header_rec.attribute5 := oe_validate.g_attribute5;

1517: END IF;
1518:
1519: IF p_x_header_rec.attribute5 IS NULL
1520: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1521: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
1522: END IF;
1523:
1524: IF p_x_header_rec.attribute6 IS NULL
1525: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1526: p_x_header_rec.attribute6 := oe_validate.g_attribute6;

1522: END IF;
1523:
1524: IF p_x_header_rec.attribute6 IS NULL
1525: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1526: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
1527: END IF;
1528:
1529: IF p_x_header_rec.attribute7 IS NULL
1530: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1531: p_x_header_rec.attribute7 := oe_validate.g_attribute7;

1527: END IF;
1528:
1529: IF p_x_header_rec.attribute7 IS NULL
1530: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1531: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
1532: END IF;
1533:
1534: IF p_x_header_rec.attribute8 IS NULL
1535: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1536: p_x_header_rec.attribute8 := oe_validate.g_attribute8;

1532: END IF;
1533:
1534: IF p_x_header_rec.attribute8 IS NULL
1535: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1536: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
1537: END IF;
1538:
1539: IF p_x_header_rec.attribute9 IS NULL
1540: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1541: p_x_header_rec.attribute9 := oe_validate.g_attribute9;

1537: END IF;
1538:
1539: IF p_x_header_rec.attribute9 IS NULL
1540: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1541: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
1542: END IF;
1543:
1544: IF p_x_header_rec.attribute10 IS NULL
1545: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1546: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;

1542: END IF;
1543:
1544: IF p_x_header_rec.attribute10 IS NULL
1545: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1546: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
1547: End IF;
1548:
1549: IF p_x_header_rec.attribute11 IS NULL
1550: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1551: p_x_header_rec.attribute11 := oe_validate.g_attribute11;

1547: End IF;
1548:
1549: IF p_x_header_rec.attribute11 IS NULL
1550: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1551: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
1552: END IF;
1553:
1554: IF p_x_header_rec.attribute12 IS NULL
1555: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1556: p_x_header_rec.attribute12 := oe_validate.g_attribute12;

1552: END IF;
1553:
1554: IF p_x_header_rec.attribute12 IS NULL
1555: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1556: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
1557: END IF;
1558:
1559: IF p_x_header_rec.attribute13 IS NULL
1560: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1561: p_x_header_rec.attribute13 := oe_validate.g_attribute13;

1557: END IF;
1558:
1559: IF p_x_header_rec.attribute13 IS NULL
1560: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1561: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
1562: END IF;
1563:
1564: IF p_x_header_rec.attribute14 IS NULL
1565: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1566: p_x_header_rec.attribute14 := oe_validate.g_attribute14;

1562: END IF;
1563:
1564: IF p_x_header_rec.attribute14 IS NULL
1565: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1566: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
1567: END IF;
1568:
1569: IF p_x_header_rec.attribute15 IS NULL
1570: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1571: p_x_header_rec.attribute15 := oe_validate.g_attribute15;

1567: END IF;
1568:
1569: IF p_x_header_rec.attribute15 IS NULL
1570: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1571: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
1572: END IF;
1573:
1574: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
1575: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN

Line 1576: p_x_header_rec.attribute16 := oe_validate.g_attribute16;

1572: END IF;
1573:
1574: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
1575: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
1576: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
1577: END IF;
1578:
1579: IF p_x_header_rec.attribute17 IS NULL
1580: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN

Line 1581: p_x_header_rec.attribute17 := oe_validate.g_attribute17;

1577: END IF;
1578:
1579: IF p_x_header_rec.attribute17 IS NULL
1580: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
1581: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
1582: END IF;
1583:
1584: IF p_x_header_rec.attribute18 IS NULL
1585: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN

Line 1586: p_x_header_rec.attribute18 := oe_validate.g_attribute18;

1582: END IF;
1583:
1584: IF p_x_header_rec.attribute18 IS NULL
1585: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
1586: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
1587: END IF;
1588:
1589: IF p_x_header_rec.attribute19 IS NULL
1590: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN

Line 1591: p_x_header_rec.attribute19 := oe_validate.g_attribute19;

1587: END IF;
1588:
1589: IF p_x_header_rec.attribute19 IS NULL
1590: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
1591: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
1592: END IF;
1593:
1594: IF p_x_header_rec.attribute20 IS NULL
1595: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN

Line 1596: p_x_header_rec.attribute20 := oe_validate.g_attribute20;

1592: END IF;
1593:
1594: IF p_x_header_rec.attribute20 IS NULL
1595: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
1596: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
1597: END IF;
1598:
1599: -- end of assignments, bug 2511313
1600: END IF;

Line 1670: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);

1666: p_old_line_rec.accounting_rule_id OR
1667: p_old_line_rec.accounting_rule_id IS NULL )
1668: THEN
1669: if l_debug_level > 0 then
1670: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
1671: end if;
1672: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
1673: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1674: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 1672: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN

1668: THEN
1669: if l_debug_level > 0 then
1670: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
1671: end if;
1672: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
1673: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1674: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1675: p_x_line_rec.accounting_rule_id := NULL;
1676: ELSE

Line 1688: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN

1684: p_old_line_rec.freight_terms_code OR
1685: p_old_line_rec.freight_terms_code IS NULL )
1686: THEN
1687:
1688: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
1689: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1690: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1691: p_x_line_rec.freight_terms_code := NULL;
1692: ELSE

Line 1703: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN

1699: ( p_x_line_rec.invoicing_rule_id <>
1700: p_old_line_rec.invoicing_rule_id OR
1701: p_old_line_rec.invoicing_rule_id IS NULL )
1702: THEN
1703: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
1704: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1705: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1706: p_x_line_rec.invoicing_rule_id := NULL;
1707: ELSE

Line 1718: IF NOT OE_Validate.Item_Type(p_x_line_rec.item_type_code) THEN

1714: ( p_x_line_rec.item_type_code <>
1715: p_old_line_rec.item_type_code OR
1716: p_old_line_rec.item_type_code IS NULL )
1717: THEN
1718: IF NOT OE_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
1719: x_return_status := FND_API.G_RET_STS_ERROR;
1720: END IF;
1721: END IF;
1722:

Line 1729: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN

1725: ( p_x_line_rec.payment_term_id <>
1726: p_old_line_rec.payment_term_id OR
1727: p_old_line_rec.payment_term_id IS NULL )
1728: THEN
1729: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
1730: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1731: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1732: p_x_line_rec.payment_term_id := NULL;
1733: ELSE

Line 1744: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN

1740: ( p_x_line_rec.price_list_id <>
1741: p_old_line_rec.price_list_id OR
1742: p_old_line_rec.price_list_id IS NULL )
1743: THEN
1744: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
1745: x_return_status := FND_API.G_RET_STS_ERROR;
1746: END IF;
1747: END IF;
1748:

Line 1754: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN

1750: ( p_x_line_rec.shipping_method_code <>
1751: p_old_line_rec.shipping_method_code OR
1752: p_old_line_rec.shipping_method_code IS NULL )
1753: THEN
1754: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
1755: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1756: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1757: p_x_line_rec.shipping_method_code := NULL;
1758: ELSE

Line 1769: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN

1765: ( p_x_line_rec.ship_from_org_id <>
1766: p_old_line_rec.ship_from_org_id OR
1767: p_old_line_rec.ship_from_org_id IS NULL )
1768: THEN
1769: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
1770: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1771: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1772: p_x_line_rec.ship_from_org_id := NULL;
1773: ELSE

Line 1784: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN

1780: ( p_x_line_rec.salesrep_id <>
1781: p_old_line_rec.salesrep_id OR
1782: p_old_line_rec.salesrep_id IS NULL )
1783: THEN
1784: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
1785: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1786: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1787: p_x_line_rec.salesrep_id := NULL;
1788: ELSE

Line 1929: IF NOT OE_VALIDATE.Line_Desc_Flex

1925:
1926: oe_debug_pub.add('Before calling line_desc_flex',2);
1927: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_BLKT_LINE_ATTRIBUTES') = 'Y' THEN
1928:
1929: IF NOT OE_VALIDATE.Line_Desc_Flex
1930: (p_context => p_x_line_rec.context
1931: ,p_attribute1 => p_x_line_rec.attribute1
1932: ,p_attribute2 => p_x_line_rec.attribute2
1933: ,p_attribute3 => p_x_line_rec.attribute3

Line 2014: p_x_line_rec.context := oe_validate.g_context;

2010: ELSE -- if the flex validation is successfull
2011: -- For bug 2511313
2012: IF p_x_line_rec.context IS NULL
2013: OR p_x_line_rec.context = FND_API.G_MISS_CHAR THEN
2014: p_x_line_rec.context := oe_validate.g_context;
2015: END IF;
2016:
2017: IF p_x_line_rec.attribute1 IS NULL
2018: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 2019: p_x_line_rec.attribute1 := oe_validate.g_attribute1;

2015: END IF;
2016:
2017: IF p_x_line_rec.attribute1 IS NULL
2018: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2019: p_x_line_rec.attribute1 := oe_validate.g_attribute1;
2020: END IF;
2021:
2022: IF p_x_line_rec.attribute2 IS NULL
2023: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 2024: p_x_line_rec.attribute2 := oe_validate.g_attribute2;

2020: END IF;
2021:
2022: IF p_x_line_rec.attribute2 IS NULL
2023: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2024: p_x_line_rec.attribute2 := oe_validate.g_attribute2;
2025: END IF;
2026:
2027: IF p_x_line_rec.attribute3 IS NULL
2028: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 2029: p_x_line_rec.attribute3 := oe_validate.g_attribute3;

2025: END IF;
2026:
2027: IF p_x_line_rec.attribute3 IS NULL
2028: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2029: p_x_line_rec.attribute3 := oe_validate.g_attribute3;
2030: END IF;
2031:
2032: IF p_x_line_rec.attribute4 IS NULL
2033: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 2034: p_x_line_rec.attribute4 := oe_validate.g_attribute4;

2030: END IF;
2031:
2032: IF p_x_line_rec.attribute4 IS NULL
2033: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2034: p_x_line_rec.attribute4 := oe_validate.g_attribute4;
2035: END IF;
2036:
2037: IF p_x_line_rec.attribute5 IS NULL
2038: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 2039: p_x_line_rec.attribute5 := oe_validate.g_attribute5;

2035: END IF;
2036:
2037: IF p_x_line_rec.attribute5 IS NULL
2038: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2039: p_x_line_rec.attribute5 := oe_validate.g_attribute5;
2040: END IF;
2041:
2042: IF p_x_line_rec.attribute6 IS NULL
2043: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 2044: p_x_line_rec.attribute6 := oe_validate.g_attribute6;

2040: END IF;
2041:
2042: IF p_x_line_rec.attribute6 IS NULL
2043: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2044: p_x_line_rec.attribute6 := oe_validate.g_attribute6;
2045: END IF;
2046:
2047: IF p_x_line_rec.attribute7 IS NULL
2048: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 2049: p_x_line_rec.attribute7 := oe_validate.g_attribute7;

2045: END IF;
2046:
2047: IF p_x_line_rec.attribute7 IS NULL
2048: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2049: p_x_line_rec.attribute7 := oe_validate.g_attribute7;
2050: END IF;
2051:
2052: IF p_x_line_rec.attribute8 IS NULL
2053: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 2054: p_x_line_rec.attribute8 := oe_validate.g_attribute8;

2050: END IF;
2051:
2052: IF p_x_line_rec.attribute8 IS NULL
2053: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2054: p_x_line_rec.attribute8 := oe_validate.g_attribute8;
2055: END IF;
2056:
2057: IF p_x_line_rec.attribute9 IS NULL
2058: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 2059: p_x_line_rec.attribute9 := oe_validate.g_attribute9;

2055: END IF;
2056:
2057: IF p_x_line_rec.attribute9 IS NULL
2058: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2059: p_x_line_rec.attribute9 := oe_validate.g_attribute9;
2060: END IF;
2061:
2062: IF p_x_line_rec.attribute10 IS NULL
2063: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 2064: p_x_line_rec.attribute10 := Oe_validate.G_attribute10;

2060: END IF;
2061:
2062: IF p_x_line_rec.attribute10 IS NULL
2063: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2064: p_x_line_rec.attribute10 := Oe_validate.G_attribute10;
2065: End IF;
2066:
2067: IF p_x_line_rec.attribute11 IS NULL
2068: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 2069: p_x_line_rec.attribute11 := oe_validate.g_attribute11;

2065: End IF;
2066:
2067: IF p_x_line_rec.attribute11 IS NULL
2068: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2069: p_x_line_rec.attribute11 := oe_validate.g_attribute11;
2070: END IF;
2071:
2072: IF p_x_line_rec.attribute12 IS NULL
2073: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 2074: p_x_line_rec.attribute12 := oe_validate.g_attribute12;

2070: END IF;
2071:
2072: IF p_x_line_rec.attribute12 IS NULL
2073: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2074: p_x_line_rec.attribute12 := oe_validate.g_attribute12;
2075: END IF;
2076:
2077: IF p_x_line_rec.attribute13 IS NULL
2078: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 2079: p_x_line_rec.attribute13 := oe_validate.g_attribute13;

2075: END IF;
2076:
2077: IF p_x_line_rec.attribute13 IS NULL
2078: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2079: p_x_line_rec.attribute13 := oe_validate.g_attribute13;
2080: END IF;
2081:
2082: IF p_x_line_rec.attribute14 IS NULL
2083: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 2084: p_x_line_rec.attribute14 := oe_validate.g_attribute14;

2080: END IF;
2081:
2082: IF p_x_line_rec.attribute14 IS NULL
2083: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2084: p_x_line_rec.attribute14 := oe_validate.g_attribute14;
2085: END IF;
2086:
2087: IF p_x_line_rec.attribute15 IS NULL
2088: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 2089: p_x_line_rec.attribute15 := oe_validate.g_attribute15;

2085: END IF;
2086:
2087: IF p_x_line_rec.attribute15 IS NULL
2088: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2089: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
2090: END IF;
2091: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
2092: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
2093: p_x_line_rec.attribute16 := oe_validate.g_attribute16;

Line 2093: p_x_line_rec.attribute16 := oe_validate.g_attribute16;

2089: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
2090: END IF;
2091: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
2092: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
2093: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
2094: END IF;
2095:
2096: IF p_x_line_rec.attribute17 IS NULL
2097: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN

Line 2098: p_x_line_rec.attribute17 := oe_validate.g_attribute17;

2094: END IF;
2095:
2096: IF p_x_line_rec.attribute17 IS NULL
2097: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
2098: p_x_line_rec.attribute17 := oe_validate.g_attribute17;
2099: END IF;
2100:
2101: IF p_x_line_rec.attribute18 IS NULL
2102: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN

Line 2103: p_x_line_rec.attribute18 := oe_validate.g_attribute18;

2099: END IF;
2100:
2101: IF p_x_line_rec.attribute18 IS NULL
2102: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
2103: p_x_line_rec.attribute18 := oe_validate.g_attribute18;
2104: END IF;
2105:
2106: IF p_x_line_rec.attribute19 IS NULL
2107: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN

Line 2108: p_x_line_rec.attribute19 := oe_validate.g_attribute19;

2104: END IF;
2105:
2106: IF p_x_line_rec.attribute19 IS NULL
2107: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
2108: p_x_line_rec.attribute19 := oe_validate.g_attribute19;
2109: END IF;
2110:
2111: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
2112: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN

Line 2113: p_x_line_rec.attribute20 := oe_validate.g_attribute20;

2109: END IF;
2110:
2111: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
2112: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
2113: p_x_line_rec.attribute20 := oe_validate.g_attribute20;
2114: END IF;
2115:
2116: -- end of assignments, bug 2511313
2117: END IF; -- Flex Validation successfull

Line 2165: --code taken from OE_validate_line.validate_item_fields

2161: RETURN BOOLEAN
2162: IS
2163: l_dummy VARCHAR2(240);
2164:
2165: --code taken from OE_validate_line.validate_item_fields
2166: /* added for 2219230 */
2167: l_org_flag NUMBER := 2;
2168: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2169:

Line 2243: --code taken from OE_validate_line.validate_item_fields

2239: ELSE
2240: if l_debug_level > 0 then
2241: oe_debug_pub.add('Blanket In validate generic');
2242: end if;
2243: --code taken from OE_validate_line.validate_item_fields
2244: /* SELECT replaced for with the following for 2219230 */
2245: if l_debug_level > 0 then
2246: oe_debug_pub.add('Validating generic item, item_val_org:'||to_char(item_val_org),5);
2247: end if;