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 113: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

109:
110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
111: BEGIN
112: IF l_debug_level > 0 then
113: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
114: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
115: END IF;
116:
117:

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

123: AND site_use_id = p_deliver_to_org_id
124: AND status = 'A'
125: AND address_status ='A';--bug 2752321
126: IF l_debug_level > 0 then
127: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
128: END IF;
129: RETURN TRUE;
130:
131: ELSIF g_customer_relations = 'Y' THEN

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

154: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
155: AND ROWNUM = 1;
156:
157: IF l_debug_level > 0 then
158: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
159: END IF;
160: RETURN TRUE;
161:
162: ELSIF g_customer_relations = 'A' THEN

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

169: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
170: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
171: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
172: IF l_debug_level > 0 then
173: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
174: END IF;
175: RETURN TRUE;
176:
177:

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

176:
177:
178: END IF;
179: IF l_debug_level > 0 then
180: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
181: END IF;
182: RETURN TRUE;
183:
184: EXCEPTION

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

933: p_old_header_rec.accounting_rule_id OR
934: p_old_header_rec.accounting_rule_id IS NULL )
935: THEN
936:
937: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
938: THEN
939: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
940: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
941: p_x_header_rec.accounting_rule_id := NULL;

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

951: p_old_header_rec.freight_terms_code OR
952: p_old_header_rec.freight_terms_code IS NULL )
953: THEN
954:
955: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
956: THEN
957: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
959: p_x_header_rec.freight_terms_code := NULL;

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

969: p_old_header_rec.invoicing_rule_id OR
970: p_old_header_rec.invoicing_rule_id IS NULL )
971: THEN
972:
973: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
974: THEN
975: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
976: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
977: p_x_header_rec.invoicing_rule_id := NULL;

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

1006: ( p_x_header_rec.payment_term_id <>
1007: p_old_header_rec.payment_term_id OR
1008: p_old_header_rec.payment_term_id IS NULL )
1009: THEN
1010: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
1011: THEN
1012: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1013: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1014: p_x_header_rec.payment_term_id := NULL;

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

1023: ( p_x_header_rec.price_list_id <>
1024: p_old_header_rec.price_list_id OR
1025: p_old_header_rec.price_list_id IS NULL )
1026: THEN
1027: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)
1028: THEN
1029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1031: p_x_header_rec.price_list_id := NULL;

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

1041: p_old_header_rec.shipping_method_code OR
1042: p_old_header_rec.shipping_method_code IS NULL )
1043: THEN
1044:
1045: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
1046: THEN
1047: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1048: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1049: p_x_header_rec.shipping_method_code := NULL;

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

1059: p_old_header_rec.ship_from_org_id OR
1060: p_old_header_rec.ship_from_org_id IS NULL )
1061: THEN
1062:
1063: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
1064: THEN
1065: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1066: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1067: p_x_header_rec.ship_from_org_id := NULL;

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

1077: p_old_header_rec.sold_to_org_id OR
1078: p_old_header_rec.sold_to_org_id IS NULL )
1079: THEN
1080:
1081: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
1082: THEN
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084:
1085: END IF;

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

1092: p_old_header_rec.sold_to_site_use_id OR
1093: p_old_header_rec.sold_to_site_use_id IS NULL )
1094: THEN
1095:
1096: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
1097: THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099:
1100: END IF;

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

1108: p_old_header_rec.invoice_to_org_id OR
1109: p_old_header_rec.invoice_to_org_id IS NULL )
1110: THEN
1111:
1112: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
1113: THEN
1114: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1115: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1116: p_x_header_rec.invoice_to_org_id := NULL;

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

1126: p_old_header_rec.ship_to_org_id OR
1127: p_old_header_rec.ship_to_org_id IS NULL )
1128: THEN
1129:
1130: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
1131: THEN
1132: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1133: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1134: p_x_header_rec.ship_to_org_id := NULL;

Line 1148: IF NOT OE_Validate.Transactional_Curr

1144: p_old_header_rec.transactional_curr_code OR
1145: p_old_header_rec.transactional_curr_code IS NULL )
1146: THEN
1147:
1148: IF NOT OE_Validate.Transactional_Curr
1149: (p_x_header_rec.transactional_curr_code)
1150: THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: END IF;

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

1159: p_old_header_rec.salesrep_id OR
1160: p_old_header_rec.salesrep_id IS NULL )
1161: THEN
1162:
1163: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
1164: THEN
1165: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1166: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1167: p_x_header_rec.salesrep_id := NULL;

Line 1270: IF NOT OE_VALIDATE.Header_Desc_Flex

1266:
1267: oe_debug_pub.add('Before calling header_desc_flex',2);
1268: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_BLKT_HEADER_ATTRIBUTES') = 'Y' THEN
1269:
1270: IF NOT OE_VALIDATE.Header_Desc_Flex
1271: (p_context => p_x_header_rec.context
1272: ,p_attribute1 => p_x_header_rec.attribute1
1273: ,p_attribute2 => p_x_header_rec.attribute2
1274: ,p_attribute3 => p_x_header_rec.attribute3

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

1350: ELSE -- if the flex validation is successfull
1351: -- For bug 2511313
1352: IF p_x_header_rec.context IS NULL
1353: OR p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
1354: p_x_header_rec.context := oe_validate.g_context;
1355: END IF;
1356:
1357: IF p_x_header_rec.attribute1 IS NULL
1358: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1355: END IF;
1356:
1357: IF p_x_header_rec.attribute1 IS NULL
1358: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1359: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
1360: END IF;
1361:
1362: IF p_x_header_rec.attribute2 IS NULL
1363: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1360: END IF;
1361:
1362: IF p_x_header_rec.attribute2 IS NULL
1363: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1364: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
1365: END IF;
1366:
1367: IF p_x_header_rec.attribute3 IS NULL
1368: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1365: END IF;
1366:
1367: IF p_x_header_rec.attribute3 IS NULL
1368: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1369: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
1370: END IF;
1371:
1372: IF p_x_header_rec.attribute4 IS NULL
1373: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1370: END IF;
1371:
1372: IF p_x_header_rec.attribute4 IS NULL
1373: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1374: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
1375: END IF;
1376:
1377: IF p_x_header_rec.attribute5 IS NULL
1378: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1375: END IF;
1376:
1377: IF p_x_header_rec.attribute5 IS NULL
1378: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1379: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
1380: END IF;
1381:
1382: IF p_x_header_rec.attribute6 IS NULL
1383: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1380: END IF;
1381:
1382: IF p_x_header_rec.attribute6 IS NULL
1383: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1384: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
1385: END IF;
1386:
1387: IF p_x_header_rec.attribute7 IS NULL
1388: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1385: END IF;
1386:
1387: IF p_x_header_rec.attribute7 IS NULL
1388: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1389: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
1390: END IF;
1391:
1392: IF p_x_header_rec.attribute8 IS NULL
1393: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1390: END IF;
1391:
1392: IF p_x_header_rec.attribute8 IS NULL
1393: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1394: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
1395: END IF;
1396:
1397: IF p_x_header_rec.attribute9 IS NULL
1398: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1395: END IF;
1396:
1397: IF p_x_header_rec.attribute9 IS NULL
1398: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1399: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
1400: END IF;
1401:
1402: IF p_x_header_rec.attribute10 IS NULL
1403: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1400: END IF;
1401:
1402: IF p_x_header_rec.attribute10 IS NULL
1403: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1404: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
1405: End IF;
1406:
1407: IF p_x_header_rec.attribute11 IS NULL
1408: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1405: End IF;
1406:
1407: IF p_x_header_rec.attribute11 IS NULL
1408: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1409: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
1410: END IF;
1411:
1412: IF p_x_header_rec.attribute12 IS NULL
1413: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1410: END IF;
1411:
1412: IF p_x_header_rec.attribute12 IS NULL
1413: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1414: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
1415: END IF;
1416:
1417: IF p_x_header_rec.attribute13 IS NULL
1418: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1415: END IF;
1416:
1417: IF p_x_header_rec.attribute13 IS NULL
1418: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1419: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
1420: END IF;
1421:
1422: IF p_x_header_rec.attribute14 IS NULL
1423: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1420: END IF;
1421:
1422: IF p_x_header_rec.attribute14 IS NULL
1423: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1424: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
1425: END IF;
1426:
1427: IF p_x_header_rec.attribute15 IS NULL
1428: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1425: END IF;
1426:
1427: IF p_x_header_rec.attribute15 IS NULL
1428: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1429: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
1430: END IF;
1431:
1432: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
1433: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN

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

1430: END IF;
1431:
1432: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
1433: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
1434: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
1435: END IF;
1436:
1437: IF p_x_header_rec.attribute17 IS NULL
1438: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN

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

1435: END IF;
1436:
1437: IF p_x_header_rec.attribute17 IS NULL
1438: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
1439: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
1440: END IF;
1441:
1442: IF p_x_header_rec.attribute18 IS NULL
1443: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN

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

1440: END IF;
1441:
1442: IF p_x_header_rec.attribute18 IS NULL
1443: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
1444: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
1445: END IF;
1446:
1447: IF p_x_header_rec.attribute19 IS NULL
1448: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN

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

1445: END IF;
1446:
1447: IF p_x_header_rec.attribute19 IS NULL
1448: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
1449: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
1450: END IF;
1451:
1452: IF p_x_header_rec.attribute20 IS NULL
1453: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN

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

1450: END IF;
1451:
1452: IF p_x_header_rec.attribute20 IS NULL
1453: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
1454: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
1455: END IF;
1456:
1457: -- end of assignments, bug 2511313
1458: END IF;

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

1524: p_old_line_rec.accounting_rule_id OR
1525: p_old_line_rec.accounting_rule_id IS NULL )
1526: THEN
1527: if l_debug_level > 0 then
1528: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
1529: end if;
1530: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
1531: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1532: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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

1526: THEN
1527: if l_debug_level > 0 then
1528: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
1529: end if;
1530: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
1531: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1532: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1533: p_x_line_rec.accounting_rule_id := NULL;
1534: ELSE

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

1542: p_old_line_rec.freight_terms_code OR
1543: p_old_line_rec.freight_terms_code IS NULL )
1544: THEN
1545:
1546: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
1547: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1548: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1549: p_x_line_rec.freight_terms_code := NULL;
1550: ELSE

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

1557: ( p_x_line_rec.invoicing_rule_id <>
1558: p_old_line_rec.invoicing_rule_id OR
1559: p_old_line_rec.invoicing_rule_id IS NULL )
1560: THEN
1561: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
1562: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1563: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1564: p_x_line_rec.invoicing_rule_id := NULL;
1565: ELSE

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

1572: ( p_x_line_rec.item_type_code <>
1573: p_old_line_rec.item_type_code OR
1574: p_old_line_rec.item_type_code IS NULL )
1575: THEN
1576: IF NOT OE_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578: END IF;
1579: END IF;
1580:

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

1583: ( p_x_line_rec.payment_term_id <>
1584: p_old_line_rec.payment_term_id OR
1585: p_old_line_rec.payment_term_id IS NULL )
1586: THEN
1587: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
1588: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1589: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1590: p_x_line_rec.payment_term_id := NULL;
1591: ELSE

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

1598: ( p_x_line_rec.price_list_id <>
1599: p_old_line_rec.price_list_id OR
1600: p_old_line_rec.price_list_id IS NULL )
1601: THEN
1602: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: END IF;
1605: END IF;
1606:

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

1608: ( p_x_line_rec.shipping_method_code <>
1609: p_old_line_rec.shipping_method_code OR
1610: p_old_line_rec.shipping_method_code IS NULL )
1611: THEN
1612: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
1613: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1614: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1615: p_x_line_rec.shipping_method_code := NULL;
1616: ELSE

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

1623: ( p_x_line_rec.ship_from_org_id <>
1624: p_old_line_rec.ship_from_org_id OR
1625: p_old_line_rec.ship_from_org_id IS NULL )
1626: THEN
1627: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
1628: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1629: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1630: p_x_line_rec.ship_from_org_id := NULL;
1631: ELSE

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

1638: ( p_x_line_rec.salesrep_id <>
1639: p_old_line_rec.salesrep_id OR
1640: p_old_line_rec.salesrep_id IS NULL )
1641: THEN
1642: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
1643: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1644: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1645: p_x_line_rec.salesrep_id := NULL;
1646: ELSE

Line 1787: IF NOT OE_VALIDATE.Line_Desc_Flex

1783:
1784: oe_debug_pub.add('Before calling line_desc_flex',2);
1785: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_BLKT_LINE_ATTRIBUTES') = 'Y' THEN
1786:
1787: IF NOT OE_VALIDATE.Line_Desc_Flex
1788: (p_context => p_x_line_rec.context
1789: ,p_attribute1 => p_x_line_rec.attribute1
1790: ,p_attribute2 => p_x_line_rec.attribute2
1791: ,p_attribute3 => p_x_line_rec.attribute3

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

1868: ELSE -- if the flex validation is successfull
1869: -- For bug 2511313
1870: IF p_x_line_rec.context IS NULL
1871: OR p_x_line_rec.context = FND_API.G_MISS_CHAR THEN
1872: p_x_line_rec.context := oe_validate.g_context;
1873: END IF;
1874:
1875: IF p_x_line_rec.attribute1 IS NULL
1876: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1873: END IF;
1874:
1875: IF p_x_line_rec.attribute1 IS NULL
1876: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1877: p_x_line_rec.attribute1 := oe_validate.g_attribute1;
1878: END IF;
1879:
1880: IF p_x_line_rec.attribute2 IS NULL
1881: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1878: END IF;
1879:
1880: IF p_x_line_rec.attribute2 IS NULL
1881: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1882: p_x_line_rec.attribute2 := oe_validate.g_attribute2;
1883: END IF;
1884:
1885: IF p_x_line_rec.attribute3 IS NULL
1886: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1883: END IF;
1884:
1885: IF p_x_line_rec.attribute3 IS NULL
1886: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1887: p_x_line_rec.attribute3 := oe_validate.g_attribute3;
1888: END IF;
1889:
1890: IF p_x_line_rec.attribute4 IS NULL
1891: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1888: END IF;
1889:
1890: IF p_x_line_rec.attribute4 IS NULL
1891: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1892: p_x_line_rec.attribute4 := oe_validate.g_attribute4;
1893: END IF;
1894:
1895: IF p_x_line_rec.attribute5 IS NULL
1896: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1893: END IF;
1894:
1895: IF p_x_line_rec.attribute5 IS NULL
1896: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1897: p_x_line_rec.attribute5 := oe_validate.g_attribute5;
1898: END IF;
1899:
1900: IF p_x_line_rec.attribute6 IS NULL
1901: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1898: END IF;
1899:
1900: IF p_x_line_rec.attribute6 IS NULL
1901: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1902: p_x_line_rec.attribute6 := oe_validate.g_attribute6;
1903: END IF;
1904:
1905: IF p_x_line_rec.attribute7 IS NULL
1906: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1903: END IF;
1904:
1905: IF p_x_line_rec.attribute7 IS NULL
1906: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1907: p_x_line_rec.attribute7 := oe_validate.g_attribute7;
1908: END IF;
1909:
1910: IF p_x_line_rec.attribute8 IS NULL
1911: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1908: END IF;
1909:
1910: IF p_x_line_rec.attribute8 IS NULL
1911: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1912: p_x_line_rec.attribute8 := oe_validate.g_attribute8;
1913: END IF;
1914:
1915: IF p_x_line_rec.attribute9 IS NULL
1916: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1913: END IF;
1914:
1915: IF p_x_line_rec.attribute9 IS NULL
1916: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1917: p_x_line_rec.attribute9 := oe_validate.g_attribute9;
1918: END IF;
1919:
1920: IF p_x_line_rec.attribute10 IS NULL
1921: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1918: END IF;
1919:
1920: IF p_x_line_rec.attribute10 IS NULL
1921: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1922: p_x_line_rec.attribute10 := Oe_validate.G_attribute10;
1923: End IF;
1924:
1925: IF p_x_line_rec.attribute11 IS NULL
1926: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1923: End IF;
1924:
1925: IF p_x_line_rec.attribute11 IS NULL
1926: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1927: p_x_line_rec.attribute11 := oe_validate.g_attribute11;
1928: END IF;
1929:
1930: IF p_x_line_rec.attribute12 IS NULL
1931: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1928: END IF;
1929:
1930: IF p_x_line_rec.attribute12 IS NULL
1931: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1932: p_x_line_rec.attribute12 := oe_validate.g_attribute12;
1933: END IF;
1934:
1935: IF p_x_line_rec.attribute13 IS NULL
1936: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1933: END IF;
1934:
1935: IF p_x_line_rec.attribute13 IS NULL
1936: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1937: p_x_line_rec.attribute13 := oe_validate.g_attribute13;
1938: END IF;
1939:
1940: IF p_x_line_rec.attribute14 IS NULL
1941: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1938: END IF;
1939:
1940: IF p_x_line_rec.attribute14 IS NULL
1941: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1942: p_x_line_rec.attribute14 := oe_validate.g_attribute14;
1943: END IF;
1944:
1945: IF p_x_line_rec.attribute15 IS NULL
1946: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1943: END IF;
1944:
1945: IF p_x_line_rec.attribute15 IS NULL
1946: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1947: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
1948: END IF;
1949: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
1950: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
1951: p_x_line_rec.attribute16 := oe_validate.g_attribute16;

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

1947: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
1948: END IF;
1949: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
1950: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
1951: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
1952: END IF;
1953:
1954: IF p_x_line_rec.attribute17 IS NULL
1955: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN

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

1952: END IF;
1953:
1954: IF p_x_line_rec.attribute17 IS NULL
1955: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
1956: p_x_line_rec.attribute17 := oe_validate.g_attribute17;
1957: END IF;
1958:
1959: IF p_x_line_rec.attribute18 IS NULL
1960: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN

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

1957: END IF;
1958:
1959: IF p_x_line_rec.attribute18 IS NULL
1960: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
1961: p_x_line_rec.attribute18 := oe_validate.g_attribute18;
1962: END IF;
1963:
1964: IF p_x_line_rec.attribute19 IS NULL
1965: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN

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

1962: END IF;
1963:
1964: IF p_x_line_rec.attribute19 IS NULL
1965: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
1966: p_x_line_rec.attribute19 := oe_validate.g_attribute19;
1967: END IF;
1968:
1969: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
1970: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN

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

1967: END IF;
1968:
1969: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
1970: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
1971: p_x_line_rec.attribute20 := oe_validate.g_attribute20;
1972: END IF;
1973:
1974: -- end of assignments, bug 2511313
1975: END IF; -- Flex Validation successfull

Line 2023: --code taken from OE_validate_line.validate_item_fields

2019: RETURN BOOLEAN
2020: IS
2021: l_dummy VARCHAR2(240);
2022:
2023: --code taken from OE_validate_line.validate_item_fields
2024: /* added for 2219230 */
2025: l_org_flag NUMBER := 2;
2026: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2027:

Line 2101: --code taken from OE_validate_line.validate_item_fields

2097: ELSE
2098: if l_debug_level > 0 then
2099: oe_debug_pub.add('Blanket In validate generic');
2100: end if;
2101: --code taken from OE_validate_line.validate_item_fields
2102: /* SELECT replaced for with the following for 2219230 */
2103: if l_debug_level > 0 then
2104: oe_debug_pub.add('Validating generic item, item_val_org:'||to_char(item_val_org),5);
2105: end if;