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_GLOBALS

Line 37: IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND

33: BEGIN
34: IF l_debug_level > 0 then
35: oe_debug_pub.add('Entering is_end_date_operation ');
36: end if;
37: IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND
38: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN
39:
40: IF p_line_rec.override_blanket_controls_flag = 'N' THEN
41: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN

Line 38: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN

34: IF l_debug_level > 0 then
35: oe_debug_pub.add('Entering is_end_date_operation ');
36: end if;
37: IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND
38: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN
39:
40: IF p_line_rec.override_blanket_controls_flag = 'N' THEN
41: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN
42: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

Line 692: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

688:
689: K := ppr_price_list_line_tbl.next(K);
690: END LOOP;
691:
692: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
693: g_new_price_list := false;
694: EXCEPTION
695:
696: WHEN FND_API.G_EXC_ERROR THEN

Line 1081: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1084: ELSE
1085: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1084: ELSE
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: END IF;

Line 1099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1102: ELSE
1103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1100: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1102: ELSE
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;

Line 1117: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1120: ELSE
1121: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1118: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1120: ELSE
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: END IF;

Line 1154: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1157: ELSE
1158: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1155: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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;
1157: ELSE
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;

Line 1171: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1174: ELSE
1175: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1172: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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;
1174: ELSE
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: END IF;

Line 1189: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1192: ELSE
1193: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1190: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1192: ELSE
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;

Line 1207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1210: ELSE
1211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1208: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1210: ELSE
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: END IF;

Line 1256: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1259: ELSE
1260: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1257: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1259: ELSE
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: END IF;

Line 1274: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1277: ELSE
1278: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1275: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1277: ELSE
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279: END IF;

Line 1307: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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;
1310: ELSE
1311: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1308: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE 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;
1310: ELSE
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: END IF;

Line 1319: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR

1315: END IF;
1316:
1317: -- Validate descriptive flex
1318:
1319: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
1320:
1321: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
1322: (p_x_header_rec.attribute1 IS NOT NULL AND
1323: ( p_x_header_rec.attribute1 <>

Line 1321: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

1317: -- Validate descriptive flex
1318:
1319: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
1320:
1321: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
1322: (p_x_header_rec.attribute1 IS NOT NULL AND
1323: ( p_x_header_rec.attribute1 <>
1324: p_old_header_rec.attribute1 OR
1325: p_old_header_rec.attribute1 IS NULL ))

Line 1437: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1433: ,p_attribute20 => p_x_header_rec.attribute20
1434: ,p_document_type => 'BLANKET')
1435: THEN
1436:
1437: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1438: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1439: THEN
1440: p_x_header_rec.context := null;
1441: p_x_header_rec.attribute1 := null;

Line 1438: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

1434: ,p_document_type => 'BLANKET')
1435: THEN
1436:
1437: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1438: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1439: THEN
1440: p_x_header_rec.context := null;
1441: p_x_header_rec.attribute1 := null;
1442: p_x_header_rec.attribute2 := null;

Line 1463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1459: p_x_header_rec.attribute19 := null;
1460: p_x_header_rec.attribute20 := null;
1461:
1462:
1463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1464: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1465: THEN
1466: p_x_header_rec.context := FND_API.G_MISS_CHAR;
1467: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 1464: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

1460: p_x_header_rec.attribute20 := null;
1461:
1462:
1463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1464: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1465: THEN
1466: p_x_header_rec.context := FND_API.G_MISS_CHAR;
1467: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1468: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 1673: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1677: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1674: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE 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
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: END IF;

Line 1689: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1693: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1690: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: END IF;

Line 1704: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1708: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1705: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: END IF;

Line 1730: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1734: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1731: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: END IF;

Line 1755: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1759: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1756: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: END IF;

Line 1770: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1774: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1771: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: END IF;

Line 1785: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

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
1789: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1786: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: END IF;

Line 1803: IF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND (OE_GLOBALS.G_UI_FLAG) THEN

1799:
1800: oe_debug_pub.add('Maitrayee: Entering the code change in Validate_Attributes');
1801: -- Skip the Validation if not changes are made in the DFF from the UI.
1802:
1803: IF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND (OE_GLOBALS.G_UI_FLAG) THEN
1804:
1805: l_validate_line := 'N';
1806: IF l_debug_level > 0 then
1807: oe_debug_pub.add('Skipping Validation');

Line 1810: ELSIF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND NOT (OE_GLOBALS.G_UI_FLAG) THEN

1806: IF l_debug_level > 0 then
1807: oe_debug_pub.add('Skipping Validation');
1808: END IF;
1809:
1810: ELSIF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND NOT (OE_GLOBALS.G_UI_FLAG) THEN
1811:
1812: -- Show Error message if appropriate context value is not passed
1813: -- from the Process Order Call and if the Context field is required.
1814:

Line 1838: IF p_x_line_rec.operation = oe_globals.g_opr_create OR

1834: -- Bug # 5562785)
1835:
1836: IF(l_validate_line = 'Y') THEN -- Bug # 5562785
1837:
1838: IF p_x_line_rec.operation = oe_globals.g_opr_create OR
1839: (p_x_line_rec.operation = oe_globals.g_opr_update AND
1840: (p_x_line_rec.attribute1 IS NOT NULL AND
1841: ( p_x_line_rec.attribute1 <>
1842: p_old_line_rec.attribute1 OR

Line 1839: (p_x_line_rec.operation = oe_globals.g_opr_update AND

1835:
1836: IF(l_validate_line = 'Y') THEN -- Bug # 5562785
1837:
1838: IF p_x_line_rec.operation = oe_globals.g_opr_create OR
1839: (p_x_line_rec.operation = oe_globals.g_opr_update AND
1840: (p_x_line_rec.attribute1 IS NOT NULL AND
1841: ( p_x_line_rec.attribute1 <>
1842: p_old_line_rec.attribute1 OR
1843: p_old_line_rec.attribute1 IS NULL ))

Line 1953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1949: ,p_attribute19 => p_x_line_rec.attribute19
1950: ,p_attribute20 => p_x_line_rec.attribute20
1951: ,p_document_type => 'BLANKET' ) THEN -- Bug # 5562785
1952:
1953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1954: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1955:
1956: p_x_line_rec.context := null;
1957: p_x_line_rec.attribute1 := null;

Line 1954: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1950: ,p_attribute20 => p_x_line_rec.attribute20
1951: ,p_document_type => 'BLANKET' ) THEN -- Bug # 5562785
1952:
1953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1954: p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1955:
1956: p_x_line_rec.context := null;
1957: p_x_line_rec.attribute1 := null;
1958: p_x_line_rec.attribute2 := null;

Line 1978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1974: p_x_line_rec.attribute18 := null;
1975: p_x_line_rec.attribute19 := null;
1976: p_x_line_rec.attribute20 := null;
1977:
1978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1979: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
1980:
1981: p_x_line_rec.context := FND_API.G_MISS_CHAR;
1982: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 1979: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN

1975: p_x_line_rec.attribute19 := null;
1976: p_x_line_rec.attribute20 := null;
1977:
1978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1979: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
1980:
1981: p_x_line_rec.context := FND_API.G_MISS_CHAR;
1982: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
1983: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 2309: IF OE_GLOBALS.Equal(l_dummy,'VALID') THEN

2305: WHEN OTHERS THEN
2306: l_dummy := null;
2307: END;
2308:
2309: IF OE_GLOBALS.Equal(l_dummy,'VALID') THEN
2310: RETURN TRUE;
2311: ELSE
2312: IF p_inventory_item_id IS NOT NULL THEN
2313: select service_item_flag,bom_item_type

Line 2387: IF p_line_rec.operation = oe_globals.g_opr_update THEN

2383: oe_debug_pub.add('Header end date : '||g_header_rec.end_date_active);
2384: end if;
2385:
2386: -- Load old line rec if not passed
2387: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2388: IF l_old_line_rec.line_id is null THEN
2389: l_old_line_rec := Query_Row(p_line_id => p_line_rec.line_id);
2390: END IF;
2391: END IF;

Line 2395: IF p_line_rec.operation = oe_globals.g_opr_update

2391: END IF;
2392:
2393: -- Validate Last Updated By values.
2394: -- Added for bug #6270818.
2395: IF p_line_rec.operation = oe_globals.g_opr_update
2396: THEN
2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2399: THEN

Line 2417: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN

2413: END IF;
2414:
2415: -- Versioning/Reasons changes (moved to beginning for bug 3775937
2416: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
2417: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
2418: OE_GLOBALS.G_REASON_CODE := p_line_rec.revision_change_reason_code;
2419: OE_GLOBALS.G_REASON_COMMENTS := p_line_rec.revision_change_comments;
2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2421: end if;

Line 2418: OE_GLOBALS.G_REASON_CODE := p_line_rec.revision_change_reason_code;

2414:
2415: -- Versioning/Reasons changes (moved to beginning for bug 3775937
2416: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
2417: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
2418: OE_GLOBALS.G_REASON_CODE := p_line_rec.revision_change_reason_code;
2419: OE_GLOBALS.G_REASON_COMMENTS := p_line_rec.revision_change_comments;
2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2421: end if;
2422:

Line 2419: OE_GLOBALS.G_REASON_COMMENTS := p_line_rec.revision_change_comments;

2415: -- Versioning/Reasons changes (moved to beginning for bug 3775937
2416: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
2417: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
2418: OE_GLOBALS.G_REASON_CODE := p_line_rec.revision_change_reason_code;
2419: OE_GLOBALS.G_REASON_COMMENTS := p_line_rec.revision_change_comments;
2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2421: end if;
2422:
2423: -- added for bug 3443777 need to call validate entity for reasons capture

Line 2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

2416: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
2417: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
2418: OE_GLOBALS.G_REASON_CODE := p_line_rec.revision_change_reason_code;
2419: OE_GLOBALS.G_REASON_COMMENTS := p_line_rec.revision_change_comments;
2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2421: end if;
2422:
2423: -- added for bug 3443777 need to call validate entity for reasons capture
2424: IF (p_line_rec.operation <> OE_GLOBALS.g_opr_delete)

Line 2424: IF (p_line_rec.operation <> OE_GLOBALS.g_opr_delete)

2420: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2421: end if;
2422:
2423: -- added for bug 3443777 need to call validate entity for reasons capture
2424: IF (p_line_rec.operation <> OE_GLOBALS.g_opr_delete)
2425: and not OE_BLANKET_UTIL.is_end_date_operation(p_line_rec, l_old_line_rec) -- Added for bug 9027699
2426:
2427: THEN
2428:

Line 2429: /* IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND

2425: and not OE_BLANKET_UTIL.is_end_date_operation(p_line_rec, l_old_line_rec) -- Added for bug 9027699
2426:
2427: THEN
2428:
2429: /* IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND
2430: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN
2431:
2432: null;
2433:

Line 2430: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN

2426:
2427: THEN
2428:
2429: /* IF p_line_rec.operation = oe_globals.g_opr_update AND p_line_rec.end_date_active = trunc(sysdate) AND
2430: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN
2431:
2432: null;
2433:
2434: else*/

Line 2503: IF (p_line_rec.operation = oe_globals.g_opr_update or p_line_rec.operation = oe_globals.g_opr_create) AND

2499: oe_debug_pub.add('Blanket In validate entity 2');
2500: end if;
2501:
2502: -- Customer Item Validation
2503: IF (p_line_rec.operation = oe_globals.g_opr_update or p_line_rec.operation = oe_globals.g_opr_create) AND
2504: p_line_rec.ITEM_IDENTIFIER_TYPE = 'CUST' then
2505: oe_blanket_util.Get_Inventory_Item(p_x_line_rec => p_line_rec,
2506: x_return_status => l_return_status);
2507: END if;

Line 2532: IF NOT OE_GLOBALS.Equal

2528: ---------------------------------------------------------------------
2529:
2530: -- Log request to validate line number if line number changed
2531:
2532: IF NOT OE_GLOBALS.Equal
2533: (p_line_rec.line_number,l_old_line_rec.line_number)
2534: THEN
2535: --some fields not allowed to update if release exists against line
2536: IF (p_line_rec.released_amount > 0) THEN

Line 2561: IF NOT OE_GLOBALS.Equal

2557:
2558:
2559: -- Inventory Item Validations
2560:
2561: IF NOT OE_GLOBALS.Equal
2562: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)
2563: OR NOT OE_GLOBALS.Equal
2564: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)
2565: OR NOT OE_GLOBALS.Equal

Line 2563: OR NOT OE_GLOBALS.Equal

2559: -- Inventory Item Validations
2560:
2561: IF NOT OE_GLOBALS.Equal
2562: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)
2563: OR NOT OE_GLOBALS.Equal
2564: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)
2565: OR NOT OE_GLOBALS.Equal
2566: (p_line_rec.end_date_active,l_old_line_rec.end_date_active)
2567: OR NOT OE_GLOBALS.Equal

Line 2565: OR NOT OE_GLOBALS.Equal

2561: IF NOT OE_GLOBALS.Equal
2562: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)
2563: OR NOT OE_GLOBALS.Equal
2564: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)
2565: OR NOT OE_GLOBALS.Equal
2566: (p_line_rec.end_date_active,l_old_line_rec.end_date_active)
2567: OR NOT OE_GLOBALS.Equal
2568: (p_line_rec.start_date_active,l_old_line_rec.start_date_active)
2569: THEN

Line 2567: OR NOT OE_GLOBALS.Equal

2563: OR NOT OE_GLOBALS.Equal
2564: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)
2565: OR NOT OE_GLOBALS.Equal
2566: (p_line_rec.end_date_active,l_old_line_rec.end_date_active)
2567: OR NOT OE_GLOBALS.Equal
2568: (p_line_rec.start_date_active,l_old_line_rec.start_date_active)
2569: THEN
2570: --fields not allowed to update if releases exist against this line
2571: IF (p_line_rec.released_amount > 0) AND

Line 2572: (NOT OE_GLOBALS.Equal

2568: (p_line_rec.start_date_active,l_old_line_rec.start_date_active)
2569: THEN
2570: --fields not allowed to update if releases exist against this line
2571: IF (p_line_rec.released_amount > 0) AND
2572: (NOT OE_GLOBALS.Equal
2573: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)) THEN
2574:
2575: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2576: fnd_message.set_token('ATTRIBUTE',

Line 2582: (NOT OE_GLOBALS.Equal

2578: OE_MSG_PUB.add;
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580:
2581: ELSIF (p_line_rec.released_amount > 0) AND
2582: (NOT OE_GLOBALS.Equal
2583: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)) THEN
2584: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2585: fnd_message.set_token('ATTRIBUTE',
2586: OE_Order_UTIL.Get_Attribute_Name('ITEM_IDENTIFIER_TYPE'));

Line 2652: ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id ,l_old_line_rec.ship_to_org_id) OR

2648:
2649: -- Validate Ship to
2650:
2651: IF p_line_rec.ship_to_org_id IS NOT NULL AND
2652: ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id ,l_old_line_rec.ship_to_org_id) OR
2653: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2654: -- ER 5743580
2655: IF ( NOT Validate_Ship_To_Org(p_line_rec.ship_to_org_id,
2656: p_line_rec.sold_to_org_id )) THEN

Line 2653: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN

2649: -- Validate Ship to
2650:
2651: IF p_line_rec.ship_to_org_id IS NOT NULL AND
2652: ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id ,l_old_line_rec.ship_to_org_id) OR
2653: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2654: -- ER 5743580
2655: IF ( NOT Validate_Ship_To_Org(p_line_rec.ship_to_org_id,
2656: p_line_rec.sold_to_org_id )) THEN
2657: if l_debug_level > 0 then

Line 2674: ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,l_old_line_rec.deliver_to_org_id) OR

2670: oe_debug_pub.add('Validating deliver_to_org_id :'|| to_char(p_line_rec.deliver_to_org_id),2);
2671: oe_debug_pub.add(' Customer Relations :'|| g_customer_relations, 1);
2672: end if;
2673: IF p_line_rec.deliver_to_org_id IS NOT NULL AND
2674: ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,l_old_line_rec.deliver_to_org_id) OR
2675: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2676: -- ER 5743580
2677: IF NOT (Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2678: p_line_rec.sold_to_org_id )) THEN

Line 2675: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN

2671: oe_debug_pub.add(' Customer Relations :'|| g_customer_relations, 1);
2672: end if;
2673: IF p_line_rec.deliver_to_org_id IS NOT NULL AND
2674: ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,l_old_line_rec.deliver_to_org_id) OR
2675: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2676: -- ER 5743580
2677: IF NOT (Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2678: p_line_rec.sold_to_org_id )) THEN
2679:

Line 2692: ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id ,l_old_line_rec.invoice_to_org_id) OR

2688:
2689: -- Invoice to Org id depends on sold to org.
2690:
2691: IF p_line_rec.invoice_to_org_id IS NOT NULL AND
2692: ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id ,l_old_line_rec.invoice_to_org_id) OR
2693: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2694: -- ER 5743580
2695: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
2696: p_line_rec.sold_to_org_id )) THEN

Line 2693: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN

2689: -- Invoice to Org id depends on sold to org.
2690:
2691: IF p_line_rec.invoice_to_org_id IS NOT NULL AND
2692: ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id ,l_old_line_rec.invoice_to_org_id) OR
2693: NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id ,l_old_line_rec.sold_to_org_id)) THEN
2694: -- ER 5743580
2695: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
2696: p_line_rec.sold_to_org_id )) THEN
2697: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2716: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)

2712: if (p_line_rec.end_date_active is not NULL and
2713: (p_line_rec.start_date_active)
2714: > (p_line_rec.end_date_active)) THEN
2715: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
2716: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2717: then
2718: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2719: OE_MSG_PUB.ADD;
2720: oe_debug_pub.add('1: Not Setting Error',1);

Line 2863: IF p_line_rec.operation = oe_globals.g_opr_update THEN

2859: x_return_status := FND_API.G_RET_STS_ERROR;
2860:
2861: END IF;
2862:
2863: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2864:
2865: if l_debug_level > 0 then
2866: oe_debug_pub.add('Blanket In validate entity 4: update');
2867: end if;

Line 2883: IF NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, l_old_line_rec.end_date_active) AND

2879: --End srini
2880: --display warning if we haven't fulfilled minimum requirements
2881:
2882:
2883: IF NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, l_old_line_rec.end_date_active) AND
2884: p_line_rec.end_date_active <= trunc(sysdate) AND
2885: p_line_rec.override_blanket_controls_flag = 'N' THEN
2886: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN
2887: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

Line 2904: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,

2900: END IF;
2901:
2902: --some fields are not allowed to update if release exists against line
2903: IF (p_line_rec.released_amount > 0) THEN
2904: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,
2905: l_old_line_rec.order_quantity_uom) THEN
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2908: fnd_message.set_token('ATTRIBUTE',

Line 2914: /* IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN

2910: OE_MSG_PUB.Add;
2911: END IF;
2912: END IF;
2913:
2914: /* IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN
2915: --validate item uniqueness
2916: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2917: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2918: p_Entity_Id => p_line_rec.line_id,

Line 2974: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,

2970: -- line creation is anyway restricted to line CREATE operation.
2971: oe_debug_pub.add('old pricing uom :'||l_old_line_rec.pricing_uom);
2972: oe_debug_pub.add('new pricing uom :'||p_line_rec.pricing_uom);
2973: --pricing uom not allowed to change if blanket price list
2974: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,
2975: l_old_line_rec.pricing_uom) THEN
2976: if (g_new_price_list) THEN
2977: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2978: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 2998: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,

2994:
2995: if l_debug_level > 0 then
2996: oe_debug_pub.add('Blanket In validate entity update 1');
2997: end if;
2998: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,
2999: l_old_line_rec.released_amount) THEN
3000: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');
3002: OE_MSG_PUB.ADD;

Line 3006: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,

3002: OE_MSG_PUB.ADD;
3003: x_return_status := FND_API.G_RET_STS_ERROR;
3004: end if;
3005:
3006: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,
3007: l_old_line_rec.returned_amount) THEN
3008: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');
3010: OE_MSG_PUB.ADD;

Line 3014: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,

3010: OE_MSG_PUB.ADD;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: end if;
3013:
3014: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,
3015: Round(l_old_line_rec.released_quantity, 6)) THEN --round() added for bug 9587613
3016: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');
3018: OE_MSG_PUB.ADD;

Line 3022: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,

3018: OE_MSG_PUB.ADD;
3019: x_return_status := FND_API.G_RET_STS_ERROR;
3020: end if;
3021:
3022: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,
3023: Round(l_old_line_rec.fulfilled_quantity, 6)) THEN --round() added for bug 9587613
3024: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');
3026: OE_MSG_PUB.ADD;

Line 3030: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,

3026: OE_MSG_PUB.ADD;
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: end if;
3029:
3030: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,
3031: l_old_line_rec.fulfilled_amount) THEN
3032: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');
3034: OE_MSG_PUB.ADD;

Line 3038: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,

3034: OE_MSG_PUB.ADD;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: end if;
3037:
3038: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,
3039: Round(l_old_line_rec.returned_quantity, 6)) THEN --round() added for bug 9587613
3040: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');
3042: OE_MSG_PUB.ADD;

Line 3057: if (NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.end_date_active),

3053: -- Bug 3193220
3054: -- Expiration Date cannot be less than sysdate
3055: ---------------------------------------------------------------------
3056: --Changes made for Bug No 5528599
3057: if (NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.end_date_active),
3058: trunc(l_old_line_rec.end_date_active))
3059: AND trunc(p_line_rec.end_date_active) < trunc(sysdate))
3060: THEN
3061: oe_debug_pub.add('2:source_document_type_id :'|| p_line_rec.source_document_type_id,1);

Line 3065: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)

3061: oe_debug_pub.add('2:source_document_type_id :'|| p_line_rec.source_document_type_id,1);
3062: oe_debug_pub.add('2:source_document_line_id :'|| p_line_rec.source_document_line_id,1);
3063:
3064: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
3065: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3066: then
3067: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3068: OE_MSG_PUB.ADD;
3069: oe_debug_pub.add('2: Not Setting Error',1);

Line 3091: --IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

3087: -- blanket line is updated with list price information i.e. list
3088: -- price was originally null on the line.
3089: -- Note that it's not supported if list price existed before
3090: -- and user tries to update list price itself.
3091: --IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3092:
3093: --only add line information if new price list
3094: -- This if is for the scenario where price list is also being
3095: -- created i.e. blanket header with new price list is being

Line 3106: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)

3102: end if;
3103:
3104: --for bug 3229225.Commented out NOCOPY /* file.sql.39 change */ the If condition and added modified condition
3105: -- IF p_line_rec.unit_list_price IS NOT NULL
3106: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)
3107: THEN
3108: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3109: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3110: p_Entity_Id => p_line_rec.line_id,

Line 3143: AND OE_GLOBALS.Equal(p_line_rec.price_list_id, g_header_rec.price_list_id))

3139: THEN
3140: -- Only for release before 11i10 check if header and line price list
3141: -- are same.
3142: IF (OE_Code_Control.Get_Code_Release_Level < '110510'
3143: AND OE_GLOBALS.Equal(p_line_rec.price_list_id, g_header_rec.price_list_id))
3144: OR OE_Code_Control.Get_Code_Release_Level >= '110510'
3145: THEN
3146:
3147: if l_debug_level > 0 then

Line 3156: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price))

3152: --for bug 3229225.Commented out NOCOPY /* file.sql.39 change */ the If condition and added modified condition
3153: -- IF p_line_rec.unit_list_price IS NOT NULL
3154: -- AND p_line_rec.qp_list_line_id IS NULL THEN
3155:
3156: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price))
3157: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
3158: p_line_rec.unit_list_price IS NOT NULL) --Bug#4694968
3159: THEN
3160:

Line 3157: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

3153: -- IF p_line_rec.unit_list_price IS NOT NULL
3154: -- AND p_line_rec.qp_list_line_id IS NULL THEN
3155:
3156: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price))
3157: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
3158: p_line_rec.unit_list_price IS NOT NULL) --Bug#4694968
3159: THEN
3160:
3161: -- Bug 3380740

Line 3241: p_request_type => OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE,

3237: p_Entity_Id => p_line_rec.line_id,
3238: p_requesting_entity_code =>
3239: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3240: p_requesting_entity_id => p_line_rec.line_id,
3241: p_request_type => OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE,
3242: p_param1=> p_line_rec.qp_list_line_id,
3243: p_param2 => g_header_rec.new_price_list_id,
3244: p_param3 => p_line_rec.price_list_id,
3245: p_param4 => p_line_rec.header_id,

Line 3251: IF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,

3247: END IF;
3248:
3249: -- 11i10 Pricing Changes Start
3250: -- Log request to create new discount line
3251: IF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,
3252: p_old_line_rec.discount_percent)
3253: OR NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,
3254: p_old_line_rec.discount_amount)
3255: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND --bug#4691643

Line 3253: OR NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,

3249: -- 11i10 Pricing Changes Start
3250: -- Log request to create new discount line
3251: IF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,
3252: p_old_line_rec.discount_percent)
3253: OR NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,
3254: p_old_line_rec.discount_amount)
3255: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND --bug#4691643
3256: (p_line_rec.discount_amount IS NOT NULL OR
3257: p_line_rec.discount_percent IS NOT NULL))

Line 3255: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND --bug#4691643

3251: IF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,
3252: p_old_line_rec.discount_percent)
3253: OR NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,
3254: p_old_line_rec.discount_amount)
3255: OR (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND --bug#4691643
3256: (p_line_rec.discount_amount IS NOT NULL OR
3257: p_line_rec.discount_percent IS NOT NULL))
3258: THEN
3259:

Line 3358: IF p_header_rec.operation = oe_globals.g_opr_update THEN

3354: oe_debug_pub.add('new end date :'||p_header_rec.end_date_active);
3355: oe_debug_pub.add('old end date :'||l_old_header_rec.end_date_active);
3356: end if;
3357:
3358: IF p_header_rec.operation = oe_globals.g_opr_update THEN
3359: if l_old_header_rec.header_id is null THEN
3360: Query_Header(
3361: p_header_id => p_header_rec.header_id,
3362: x_header_rec => l_old_header_Rec,

Line 3372: IF p_header_rec.operation = oe_globals.g_opr_update

3368: END IF;
3369:
3370: -- Validate Last Updated By valued issue
3371: -- Added for a bug #6270818.
3372: IF p_header_rec.operation = oe_globals.g_opr_update
3373: THEN
3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3376: THEN

Line 3389: IF p_header_rec.operation = oe_globals.g_opr_create and

3385:
3386:
3387: -- Validate Transaction Phase
3388: -- Added for Pack -j Srini.
3389: IF p_header_rec.operation = oe_globals.g_opr_create and
3390: oe_code_control.get_code_release_level >= '110510'
3391: THEN
3392: If p_header_rec.TRANSACTION_PHASE_CODE is null and
3393: l_old_header_rec.TRANSACTION_PHASE_CODE is null

Line 3403: IF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,

3399:
3400: g_header_rec := p_header_rec;
3401:
3402: -- Get Blanket Number
3403: IF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,
3404: l_old_header_rec.order_type_id) THEN
3405: IF p_header_rec.order_number is null or
3406: p_header_rec.order_number = FND_API.G_MISS_NUM
3407: Then

Line 3432: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN

3428: g_header_rec := p_header_rec;
3429:
3430: -- Versioning/Reasons changes (moved to beginning for bug 3775937
3431: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
3432: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
3433: OE_GLOBALS.G_REASON_CODE := p_header_rec.revision_change_reason_code;
3434: OE_GLOBALS.G_REASON_COMMENTS := p_header_rec.revision_change_comments;
3435: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
3436: end if;

Line 3433: OE_GLOBALS.G_REASON_CODE := p_header_rec.revision_change_reason_code;

3429:
3430: -- Versioning/Reasons changes (moved to beginning for bug 3775937
3431: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
3432: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
3433: OE_GLOBALS.G_REASON_CODE := p_header_rec.revision_change_reason_code;
3434: OE_GLOBALS.G_REASON_COMMENTS := p_header_rec.revision_change_comments;
3435: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
3436: end if;
3437:

Line 3434: OE_GLOBALS.G_REASON_COMMENTS := p_header_rec.revision_change_comments;

3430: -- Versioning/Reasons changes (moved to beginning for bug 3775937
3431: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
3432: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
3433: OE_GLOBALS.G_REASON_CODE := p_header_rec.revision_change_reason_code;
3434: OE_GLOBALS.G_REASON_COMMENTS := p_header_rec.revision_change_comments;
3435: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
3436: end if;
3437:
3438: -- Check Required attributes

Line 3435: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

3431: if OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
3432: OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
3433: OE_GLOBALS.G_REASON_CODE := p_header_rec.revision_change_reason_code;
3434: OE_GLOBALS.G_REASON_COMMENTS := p_header_rec.revision_change_comments;
3435: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
3436: end if;
3437:
3438: -- Check Required attributes
3439: IF p_header_rec.header_id IS NULL THEN

Line 3485: if (NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.end_date_active),

3481: -- Bug 3193220
3482: -- Expiration Date cannot be less than sysdate
3483: ---------------------------------------------------------------------
3484: --Changes made for Bug No 5528599 start
3485: if (NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.end_date_active),
3486: trunc(l_old_header_rec.end_date_active))
3487: AND trunc(p_header_rec.end_date_active) < trunc(sysdate))
3488: then
3489:

Line 3491: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3487: AND trunc(p_header_rec.end_date_active) < trunc(sysdate))
3488: then
3489:
3490: if ( nvl(p_header_rec.source_document_type_id,0) = 2) --bug#5528507
3491: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3492: then
3493: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3494: OE_MSG_PUB.ADD;
3495: oe_debug_pub.add('3: Not Setting Error',1);

Line 3509: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,l_old_header_rec.ship_to_org_id) OR

3505: -- End Expiration Date < sysdate check
3506:
3507: -- Validate Ship to
3508: IF p_header_rec.ship_to_org_id IS NOT NULL AND
3509: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,l_old_header_rec.ship_to_org_id) OR
3510: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3511: -- ER 5743580
3512: IF ( NOT Validate_Ship_To_Org(p_header_rec.ship_to_org_id,
3513: p_header_rec.sold_to_org_id )) THEN

Line 3510: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN

3506:
3507: -- Validate Ship to
3508: IF p_header_rec.ship_to_org_id IS NOT NULL AND
3509: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,l_old_header_rec.ship_to_org_id) OR
3510: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3511: -- ER 5743580
3512: IF ( NOT Validate_Ship_To_Org(p_header_rec.ship_to_org_id,
3513: p_header_rec.sold_to_org_id )) THEN
3514: if l_debug_level > 0 then

Line 3532: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id

3528:
3529: -- Customer Location depends on Sold To Org
3530:
3531: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
3532: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
3533: ,p_old_header_rec.sold_to_site_use_id) OR
3534: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
3535: ,p_old_header_rec.sold_to_org_id))
3536: THEN

Line 3534: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

3530:
3531: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
3532: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
3533: ,p_old_header_rec.sold_to_site_use_id) OR
3534: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
3535: ,p_old_header_rec.sold_to_org_id))
3536: THEN
3537:
3538: BEGIN

Line 3589: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,l_old_header_rec.deliver_to_org_id) OR

3585: oe_debug_pub.add('Validating deliver_to_org_id :'|| to_char(p_header_rec.deliver_to_org_id),2);
3586: oe_debug_pub.add(' Customer Relations :'|| g_customer_relations, 1);
3587: end if;
3588: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
3589: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,l_old_header_rec.deliver_to_org_id) OR
3590: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3591: -- ER 5743580
3592: IF NOT (Validate_Deliver_To_Org(p_header_rec.deliver_to_org_id,
3593: p_header_rec.sold_to_org_id )) THEN

Line 3590: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN

3586: oe_debug_pub.add(' Customer Relations :'|| g_customer_relations, 1);
3587: end if;
3588: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
3589: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,l_old_header_rec.deliver_to_org_id) OR
3590: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3591: -- ER 5743580
3592: IF NOT (Validate_Deliver_To_Org(p_header_rec.deliver_to_org_id,
3593: p_header_rec.sold_to_org_id )) THEN
3594:

Line 3606: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,l_old_header_rec.invoice_to_org_id) OR

3602: END if; -- Deliver to
3603:
3604: -- Invoice to Org id depends on sold to org.
3605: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
3606: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,l_old_header_rec.invoice_to_org_id) OR
3607: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3608: -- ER 5743580
3609: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
3610: p_header_rec.sold_to_org_id )) THEN

Line 3607: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN

3603:
3604: -- Invoice to Org id depends on sold to org.
3605: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
3606: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,l_old_header_rec.invoice_to_org_id) OR
3607: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3608: -- ER 5743580
3609: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
3610: p_header_rec.sold_to_org_id )) THEN
3611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3622: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id ,l_old_header_rec.sold_to_contact_id) OR

3618: END IF; -- Invoice to org
3619:
3620: -- Sold to contact depends on Sold To Org
3621: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
3622: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id ,l_old_header_rec.sold_to_contact_id) OR
3623: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3624: BEGIN
3625:
3626: SELECT 'VALID'

Line 3623: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN

3619:
3620: -- Sold to contact depends on Sold To Org
3621: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
3622: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id ,l_old_header_rec.sold_to_contact_id) OR
3623: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id ,l_old_header_rec.sold_to_org_id)) THEN
3624: BEGIN
3625:
3626: SELECT 'VALID'
3627: INTO l_dummy

Line 3705: IF NOT OE_GLOBALS.EQUAL(p_header_rec.new_price_list_id,

3701: oe_debug_pub.add('ml id :'||p_header_rec.new_modifier_list_id);
3702: oe_debug_pub.add('old ml id :'||p_old_header_rec.new_modifier_list_id);
3703: end if;
3704:
3705: IF NOT OE_GLOBALS.EQUAL(p_header_rec.new_price_list_id,
3706: p_old_header_rec.new_price_list_id)
3707: THEN
3708:
3709: -- Cannot enter ID for a new price list, only name

Line 3718: AND NOT OE_GLOBALS.EQUAL(p_header_rec.new_price_list_name

3714: ELSIF p_header_rec.new_price_list_name IS NOT NULL
3715: -- Bug 3213174
3716: -- Changes from null to not null will be allowed
3717: AND p_old_header_rec.new_price_list_name IS NULL
3718: AND NOT OE_GLOBALS.EQUAL(p_header_rec.new_price_list_name
3719: ,p_old_header_rec.new_price_list_name
3720: )
3721: THEN
3722:

Line 3743: IF NOT OE_GLOBALS.EQUAL(p_header_rec.new_modifier_list_id,

3739: END;
3740:
3741: END IF;
3742:
3743: IF NOT OE_GLOBALS.EQUAL(p_header_rec.new_modifier_list_id,
3744: p_old_header_rec.new_modifier_list_id)
3745: THEN
3746:
3747: -- Cannot enter ID for a new modifier list, only name

Line 3756: AND NOT OE_GLOBALS.EQUAL(p_header_rec.new_modifier_list_name

3752: ELSIF p_header_rec.new_modifier_list_name IS NOT NULL
3753: -- Bug 3213174
3754: -- Changes from null to not null will be allowed
3755: AND p_old_header_rec.new_modifier_list_name IS NULL
3756: AND NOT OE_GLOBALS.EQUAL(p_header_rec.new_modifier_list_name
3757: ,p_old_header_rec.new_modifier_list_name
3758: )
3759: THEN
3760:

Line 3789: IF (p_header_rec.operation = oe_globals.g_opr_create) OR

3785:
3786:
3787: -- Apending Time component to End Date Active for Create or Update Operation.
3788: -- Pack J
3789: IF (p_header_rec.operation = oe_globals.g_opr_create) OR
3790: (p_header_rec.operation = oe_globals.g_opr_update)
3791: THEN
3792: IF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active
3793: ,l_old_header_rec.end_date_active)

Line 3790: (p_header_rec.operation = oe_globals.g_opr_update)

3786:
3787: -- Apending Time component to End Date Active for Create or Update Operation.
3788: -- Pack J
3789: IF (p_header_rec.operation = oe_globals.g_opr_create) OR
3790: (p_header_rec.operation = oe_globals.g_opr_update)
3791: THEN
3792: IF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active
3793: ,l_old_header_rec.end_date_active)
3794: THEN

Line 3792: IF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active

3788: -- Pack J
3789: IF (p_header_rec.operation = oe_globals.g_opr_create) OR
3790: (p_header_rec.operation = oe_globals.g_opr_update)
3791: THEN
3792: IF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active
3793: ,l_old_header_rec.end_date_active)
3794: THEN
3795: p_header_rec.end_date_active :=
3796: trunc(p_header_rec.end_date_active,'DD') +

Line 3808: IF p_header_rec.operation = oe_globals.g_opr_update THEN

3804: Validate_Min_Max_Range(p_min_value => p_header_rec.Blanket_Min_amount,
3805: p_max_value => p_header_rec.Blanket_Max_amount,
3806: p_attribute => 'BLANKET_HEADER_AMOUNT', x_return_status => x_return_status);
3807:
3808: IF p_header_rec.operation = oe_globals.g_opr_update THEN
3809: --validate for updates
3810:
3811:
3812: --commented because waiting for message

Line 3823: IF NOT OE_GLOBALS.Equal(p_header_rec.end_date_active, l_old_header_rec.end_date_active) AND

3819: END IF;
3820:
3821:
3822: --display warning if we haven't fulfilled minimum requirements
3823: IF NOT OE_GLOBALS.Equal(p_header_rec.end_date_active, l_old_header_rec.end_date_active) AND
3824: p_header_rec.end_date_active <= trunc(sysdate) AND
3825: nvl(p_header_rec.released_amount,0) < p_header_rec.blanket_min_amount THEN
3826: if l_debug_level > 0 then
3827: oe_debug_pub.add('Blanket header close min amount ');

Line 3834: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,

3830: OE_MSG_PUB.ADD;
3831: END IF;
3832:
3833:
3834: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,
3835: l_old_header_rec.header_id) THEN
3836: x_return_status := FND_API.G_RET_STS_ERROR;
3837: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3838: fnd_message.set_token('ATTRIBUTE',

Line 3843: IF NOT OE_GLOBALS.Equal (p_header_rec.order_number,

3839: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
3840: OE_MSG_PUB.Add;
3841: END IF;
3842:
3843: IF NOT OE_GLOBALS.Equal (p_header_rec.order_number,
3844: l_old_header_rec.order_number) THEN
3845: x_return_status := FND_API.G_RET_STS_ERROR;
3846: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3847: fnd_message.set_token('ATTRIBUTE',

Line 3852: IF NOT OE_GLOBALS.Equal (p_header_rec.order_category_code,

3848: OE_Order_UTIL.Get_Attribute_Name('BLANKET_NUMBER'));
3849: OE_MSG_PUB.Add;
3850: END IF;
3851:
3852: IF NOT OE_GLOBALS.Equal (p_header_rec.order_category_code,
3853: l_old_header_rec.order_category_code) THEN
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3856: fnd_message.set_token('ATTRIBUTE',

Line 3861: IF NOT OE_GLOBALS.Equal (p_header_rec.org_id,

3857: OE_Order_UTIL.Get_Attribute_Name('ORDER_CATEGORY_CODE'));
3858: OE_MSG_PUB.Add;
3859: END IF;
3860:
3861: IF NOT OE_GLOBALS.Equal (p_header_rec.org_id,
3862: l_old_header_rec.org_id) THEN
3863: x_return_status := FND_API.G_RET_STS_ERROR;
3864: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3865: fnd_message.set_token('ATTRIBUTE',

Line 3872: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,

3868: END IF;
3869:
3870: --restricted from changing if releases exist
3871: IF p_header_rec.released_amount > 0 THEN
3872: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,
3873: l_old_header_rec.sold_to_org_id) THEN
3874: x_return_status := FND_API.G_RET_STS_ERROR;
3875: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3876: fnd_message.set_token('ATTRIBUTE',

Line 3881: IF NOT OE_GLOBALS.Equal (p_header_rec.transactional_curr_code,

3877: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
3878: OE_MSG_PUB.Add;
3879: END IF;
3880:
3881: IF NOT OE_GLOBALS.Equal (p_header_rec.transactional_curr_code,
3882: l_old_header_rec.transactional_curr_code) THEN
3883: x_return_status := FND_API.G_RET_STS_ERROR;
3884: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3885: fnd_message.set_token('ATTRIBUTE',

Line 3890: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,

3886: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
3887: OE_MSG_PUB.Add;
3888: END IF;
3889:
3890: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
3891: l_old_header_rec.start_date_active) THEN
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3894: fnd_message.set_token('ATTRIBUTE','Activation Date');

Line 3899: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,

3895: OE_MSG_PUB.Add;
3896: END IF;
3897: END IF; --if releases exist
3898:
3899: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,
3900: l_old_header_rec.released_amount) THEN
3901: x_return_status := FND_API.G_RET_STS_ERROR;
3902: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3903: fnd_message.set_token('ATTRIBUTE','Released Amount');

Line 3907: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,

3903: fnd_message.set_token('ATTRIBUTE','Released Amount');
3904: OE_MSG_PUB.Add;
3905: END IF;
3906:
3907: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3908: l_old_header_rec.returned_amount) THEN
3909: x_return_status := FND_API.G_RET_STS_ERROR;
3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');

Line 3917: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,

3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3914: OE_MSG_PUB.Add;
3915: END IF;
3916:
3917: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3918: l_old_header_rec.fulfilled_amount) THEN
3919: x_return_status := FND_API.G_RET_STS_ERROR;
3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');

Line 3931: AND NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active

3927:
3928: -- Date Validations
3929:
3930: IF p_header_rec.end_date_active IS NOT NULL
3931: AND NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active
3932: ,l_old_header_rec.end_date_active)
3933: THEN
3934:
3935: IF (l_old_header_rec.end_date_active IS NOT NULL

Line 4001: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

3997: AND END_DATE_ACTIVE IS NULL
3998: AND ROWNUM = 1;
3999:
4000: IF l_dummy = 'CASCADE' THEN
4001: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
4002:
4003: --if cascading, check to see if minimum values are satisfied
4004: IF (p_header_rec.end_date_active <= trunc(sysdate)) THEN
4005: SELECT 'WARNING'

Line 4033: IF NOT OE_GLOBALS.Equal (p_header_rec.blanket_max_amount,

4029:
4030:
4031: --verify max limits
4032:
4033: IF NOT OE_GLOBALS.Equal (p_header_rec.blanket_max_amount,
4034: l_old_header_rec.blanket_max_amount)
4035: AND p_header_rec.blanket_max_amount < p_header_rec.released_amount
4036: AND nvl(p_header_rec.override_amount_flag, 'N') = 'N' THEN
4037: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4045: IF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,

4041:
4042: -- Version Change
4043: -- Validations and Record History
4044:
4045: IF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,
4046: l_old_header_rec.version_number)
4047: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110510'
4048: THEN
4049:

Line 4106: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN

4102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4103: x_return_status := l_return_status;
4104: END IF;
4105:
4106: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN
4107: OE_Delayed_Requests_PVT.Log_Request
4108: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4109: ,p_Entity_Id => p_header_rec.header_id
4110: ,p_requesting_entity_code =>

Line 4134: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR

4130:
4131: -- Validate WF STATUS for Start and End Date for a BSA. For Pack J
4132: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4133: THEN
4134: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
4135: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
4136: THEN
4137: OE_Delayed_Requests_PVT.Log_Request
4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 4135: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))

4131: -- Validate WF STATUS for Start and End Date for a BSA. For Pack J
4132: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4133: THEN
4134: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
4135: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
4136: THEN
4137: OE_Delayed_Requests_PVT.Log_Request
4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4139: ,p_Entity_Id => p_header_rec.header_id

Line 4157: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and

4153:
4154: -- For bug #4447494
4155: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4156: THEN
4157: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
4158: p_header_rec.operation = oe_globals.g_opr_update) THEN
4159: OE_Delayed_Requests_PVT.Log_Request
4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4161: ,p_Entity_Id => p_header_rec.header_id

Line 4158: p_header_rec.operation = oe_globals.g_opr_update) THEN

4154: -- For bug #4447494
4155: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4156: THEN
4157: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
4158: p_header_rec.operation = oe_globals.g_opr_update) THEN
4159: OE_Delayed_Requests_PVT.Log_Request
4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4161: ,p_Entity_Id => p_header_rec.header_id
4162: ,p_param1 => p_header_rec.sold_to_org_id

Line 4258: OE_GLOBALS.Set_Context;

4254: oe_debug_pub.add('Entering OE_BLANKET_UTIL.INSERT_ROW - Header ID :'||
4255: p_header_rec.header_id);
4256: end if;
4257: --bug 7139169
4258: OE_GLOBALS.Set_Context;
4259: l_org_id := OE_GLOBALS.G_ORG_ID;
4260:
4261: --l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));
4262: -- for bug 3342548. Added column CONTEXT

Line 4259: l_org_id := OE_GLOBALS.G_ORG_ID;

4255: p_header_rec.header_id);
4256: end if;
4257: --bug 7139169
4258: OE_GLOBALS.Set_Context;
4259: l_org_id := OE_GLOBALS.G_ORG_ID;
4260:
4261: --l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));
4262: -- for bug 3342548. Added column CONTEXT
4263: INSERT INTO OE_BLANKET_HEADERS

Line 4722: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER

4718: END IF;
4719:
4720: -- added for delete attachments
4721: OE_Atchmt_Util.Delete_Attachments
4722: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
4723: , p_entity_id => p_header_id
4724: , x_return_status => l_return_status
4725: );
4726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5260: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE

5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: END IF;
5258:
5259: OE_Atchmt_Util.Delete_Attachments
5260: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
5261: , p_entity_id => p_line_id
5262: , x_return_status => l_return_status
5263: );
5264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 6466: OE_GLOBALS.G_UI_FLAG := FALSE;

6462:
6463: EXCEPTION
6464: WHEN FND_API.G_EXC_ERROR THEN
6465:
6466: OE_GLOBALS.G_UI_FLAG := FALSE;
6467:
6468: x_return_status := FND_API.G_RET_STS_ERROR;
6469:
6470: -- Get message count and data

Line 6479: OE_GLOBALS.G_UI_FLAG := FALSE;

6475: );
6476:
6477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6478:
6479: OE_GLOBALS.G_UI_FLAG := FALSE;
6480:
6481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6482:
6483: -- Get message count and data

Line 6631: -- OE_GLOBALS.G_LOCK_CONST := 0;

6627: -- following constants are used to debug lock_order,
6628: -- please do not use them for any other purpose.
6629: -- set G_LOCK_TEST := 'Y', for debugging.
6630:
6631: -- OE_GLOBALS.G_LOCK_CONST := 0;
6632: --OE_GLOBALS.G_LOCK_TEST := 'Y';
6633: -- OE_GLOBALS.G_LOCK_TEST := 'N';
6634:
6635: IF OE_GLOBALS.Equal(p_x_lock_control,

Line 6632: --OE_GLOBALS.G_LOCK_TEST := 'Y';

6628: -- please do not use them for any other purpose.
6629: -- set G_LOCK_TEST := 'Y', for debugging.
6630:
6631: -- OE_GLOBALS.G_LOCK_CONST := 0;
6632: --OE_GLOBALS.G_LOCK_TEST := 'Y';
6633: -- OE_GLOBALS.G_LOCK_TEST := 'N';
6634:
6635: IF OE_GLOBALS.Equal(p_x_lock_control,
6636: l_db_lock_control)

Line 6633: -- OE_GLOBALS.G_LOCK_TEST := 'N';

6629: -- set G_LOCK_TEST := 'Y', for debugging.
6630:
6631: -- OE_GLOBALS.G_LOCK_CONST := 0;
6632: --OE_GLOBALS.G_LOCK_TEST := 'Y';
6633: -- OE_GLOBALS.G_LOCK_TEST := 'N';
6634:
6635: IF OE_GLOBALS.Equal(p_x_lock_control,
6636: l_db_lock_control)
6637: THEN

Line 6635: IF OE_GLOBALS.Equal(p_x_lock_control,

6631: -- OE_GLOBALS.G_LOCK_CONST := 0;
6632: --OE_GLOBALS.G_LOCK_TEST := 'Y';
6633: -- OE_GLOBALS.G_LOCK_TEST := 'N';
6634:
6635: IF OE_GLOBALS.Equal(p_x_lock_control,
6636: l_db_lock_control)
6637: THEN
6638:
6639: if l_debug_level > 0 then

Line 6669: OE_GLOBALS.G_LOCK_TEST := 'N';

6665: if l_debug_level > 0 then
6666: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.LOCK_BLANKET', 1);
6667: end if;
6668:
6669: OE_GLOBALS.G_LOCK_TEST := 'N';
6670:
6671:
6672: EXCEPTION
6673:

Line 6685: OE_GLOBALS.G_LOCK_TEST := 'N';

6681:
6682: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
6683: OE_MSG_PUB.Add;
6684:
6685: OE_GLOBALS.G_LOCK_TEST := 'N';
6686:
6687: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
6688:
6689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6698: OE_GLOBALS.G_LOCK_TEST := 'N';

6694:
6695: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
6696: OE_MSG_PUB.Add;
6697:
6698: OE_GLOBALS.G_LOCK_TEST := 'N';
6699:
6700: WHEN OTHERS THEN
6701:
6702: if l_debug_level > 0 then

Line 6712: OE_GLOBALS.G_LOCK_TEST := 'N';

6708: ( G_PKG_NAME
6709: , 'Lock_Blanket'
6710: );
6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6712: OE_GLOBALS.G_LOCK_TEST := 'N';
6713:
6714: END Lock_Blanket;
6715:
6716:

Line 6754: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

6750: p_x_header_rec.start_Date_active := trunc(sysdate);
6751: END IF;
6752:
6753: -- Default Who Columns
6754: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6755: p_x_header_rec.creation_Date := sysdate;
6756: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;
6757: END IF;
6758:

Line 6822: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

6818: IF p_x_header_rec.order_type_id IS NULL THEN
6819: p_x_header_rec.order_type_id := FND_PROFILE.VALUE('OE_DEFAULT_BLANKET_ORDER_TYPE');
6820: END IF;
6821:
6822: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6823: -- Revision Number
6824: p_x_header_rec.version_number := 0.0;
6825: -- Operating unit
6826: -- START

Line 7088: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

7084: -- 11i10 Pricing Changes End
7085: END IF; --if default from header
7086:
7087: -- WHO columns
7088: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7089: p_x_line_rec.creation_Date := sysdate;
7090: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;
7091: END IF;
7092: p_x_line_rec.last_update_date := sysdate;

Line 7352: G_Header_Rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

7348: END IF;
7349:
7350:
7351: IF oe_code_control.get_code_release_level >= '110510' and
7352: G_Header_Rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7353: oe_debug_pub.ADD('Create and Start Flow srini : '||G_Header_Rec.operation) ;
7354: oe_blanket_wf_util.create_and_start_flow(
7355: p_header_id => G_header_rec.header_id,
7356: p_transaction_phase_code => G_header_rec.transaction_phase_code,

Line 7378: IF G_Header_Rec.operation = OE_GLOBALS.G_OPR_CREATE AND

7374:
7375: -- moved instantiate call after create_and_start_flow procedure for bug 3691452
7376:
7377: -- Instantiate the contract template id against the BSA if new record --ABH
7378: IF G_Header_Rec.operation = OE_GLOBALS.G_OPR_CREATE AND
7379: OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
7380: -- Do not instantiate for copied orders
7381: AND nvl(g_header_rec.source_document_type_id,-1) <> 2
7382: THEN

Line 7414: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND

7410:
7411: END IF;
7412:
7413: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
7414: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
7415: Not OE_GLOBALS.Equal(G_Header_Rec.operation, OE_GLOBALS.G_OPR_CREATE) THEN
7416: OE_Versioning_Util.Perform_Versioning(p_header_id => g_header_rec.header_id,
7417: p_document_type => 'BLANKETS',
7418: x_msg_count => lx_msg_count,

Line 7415: Not OE_GLOBALS.Equal(G_Header_Rec.operation, OE_GLOBALS.G_OPR_CREATE) THEN

7411: END IF;
7412:
7413: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
7414: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
7415: Not OE_GLOBALS.Equal(G_Header_Rec.operation, OE_GLOBALS.G_OPR_CREATE) THEN
7416: OE_Versioning_Util.Perform_Versioning(p_header_id => g_header_rec.header_id,
7417: p_document_type => 'BLANKETS',
7418: x_msg_count => lx_msg_count,
7419: x_msg_data => lx_msg_data,

Line 7458: G_Header_Rec.operation := OE_GLOBALS.G_OPR_NONE;

7454:
7455: END IF;
7456:
7457: g_old_version_captured := FALSE;
7458: G_Header_Rec.operation := OE_GLOBALS.G_OPR_NONE;
7459:
7460: EXCEPTION
7461:
7462: WHEN FND_API.G_EXC_ERROR THEN

Line 7881: l_header_rec.operation := oe_globals.g_opr_create;

7877: FROM DUAL;
7878:
7879: l_header_rec.order_number := NULL;
7880: l_header_rec.version_number := 0;
7881: l_header_rec.operation := oe_globals.g_opr_create;
7882: --l_header_rec.start_date_active := trunc(SYSDATE);
7883: --l_header_rec.end_date_active := NULL;
7884: l_header_rec.revision_change_date := NULL;
7885: l_header_rec.revision_change_reason_code := NULL;

Line 7931: l_line_tbl(l_count).operation := oe_globals.g_opr_create;

7927: SELECT OE_ORDER_LINES_S.NEXTVAL
7928: INTO l_line_tbl(l_count).line_id
7929: FROM DUAL;
7930:
7931: l_line_tbl(l_count).operation := oe_globals.g_opr_create;
7932: l_line_tbl(l_count).order_number := NULL;
7933: l_line_tbl(l_count).line_number := NULL;
7934: --l_line_tbl(l_count).start_date_active := NULL;
7935: --l_line_tbl(l_count).end_date_active := NULL;

Line 7960: , p_validation_level => OE_GLOBALS.G_VALID_LEVEL_PARTIAL

7956: END LOOP;
7957:
7958: OE_BLANKET_PVT.Process_Blanket
7959: ( p_api_version_number => 1.0
7960: , p_validation_level => OE_GLOBALS.G_VALID_LEVEL_PARTIAL
7961: , x_return_status => x_return_status
7962: , x_msg_count => x_msg_count
7963: , x_msg_data => x_msg_data
7964: , p_header_rec => l_header_rec

Line 7991: IF NOT OE_GLOBALS.EQUAL(l_return_status, FND_API.G_RET_STS_SUCCESS) THEN

7987: x_msg_data => x_msg_data
7988: );
7989:
7990:
7991: IF NOT OE_GLOBALS.EQUAL(l_return_status, FND_API.G_RET_STS_SUCCESS) THEN
7992: x_return_status := nvl(l_return_status, x_return_status);
7993: END IF;
7994:
7995: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 9751: if OE_GLOBALS.G_UI_FLAG THEN

9747: if l_debug_level > 0 then
9748: oe_debug_pub.add('Enter OE_Blanket_Util.Batch_Call');
9749: end if;
9750:
9751: if OE_GLOBALS.G_UI_FLAG THEN
9752: oe_debug_pub.add(' UI Call ');
9753: ELSE
9754: oe_debug_pub.add(' Batch call' );
9755: end if;

Line 9756: IF NOT (OE_GLOBALS.G_UI_FLAG ) THEN

9752: oe_debug_pub.add(' UI Call ');
9753: ELSE
9754: oe_debug_pub.add(' Batch call' );
9755: end if;
9756: IF NOT (OE_GLOBALS.G_UI_FLAG ) THEN
9757: p_result :=1;
9758: ELSE
9759: p_result :=0;
9760: END IF;