APPS.OE_VALIDATE_HEADER dependencies on OE_GLOBALS

Line 34: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33:
34: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
35:
36: -- Transaction phase cannot be updated on a saved transaction.
37:
38: IF OE_Quote_Util.G_COMPLETE_NEG = 'N' AND

Line 39: NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code

35:
36: -- Transaction phase cannot be updated on a saved transaction.
37:
38: IF OE_Quote_Util.G_COMPLETE_NEG = 'N' AND
39: NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code
40: ,p_old_header_rec.transaction_phase_code)
41: THEN
42: FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');
43: OE_MSG_PUB.ADD;

Line 65: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number

61: IF nvl(p_header_rec.transaction_phase_code,'F') = 'F' THEN
62:
63: -- Cannot update following quote attributes in fulfillment phase
64:
65: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number
66: ,p_old_header_rec.quote_number)) OR
67: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
68: p_header_rec.quote_number IS NOT NULL )
69: --OR cnd added for Bug 5060064

Line 67: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

63: -- Cannot update following quote attributes in fulfillment phase
64:
65: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number
66: ,p_old_header_rec.quote_number)) OR
67: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
68: p_header_rec.quote_number IS NOT NULL )
69: --OR cnd added for Bug 5060064
70: THEN
71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');

Line 78: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date

74: OE_MSG_PUB.ADD;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: END IF;
77:
78: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date
79: ,p_old_header_rec.quote_date)) OR
80: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
81: p_header_rec.quote_date IS NOT NULL )
82: --OR cnd added for Bug 5060064

Line 80: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

76: END IF;
77:
78: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date
79: ,p_old_header_rec.quote_date)) OR
80: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
81: p_header_rec.quote_date IS NOT NULL )
82: --OR cnd added for Bug 5060064
83: THEN
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');

Line 91: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.expiration_date

87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90:
91: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.expiration_date
92: ,p_old_header_rec.expiration_date)) OR
93: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
94: p_header_rec.expiration_date IS NOT NULL )
95: --OR cnd added for Bug 5060064

Line 93: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

89: END IF;
90:
91: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.expiration_date
92: ,p_old_header_rec.expiration_date)) OR
93: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
94: p_header_rec.expiration_date IS NOT NULL )
95: --OR cnd added for Bug 5060064
96: THEN
97: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');

Line 114: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_number

110: ELSIF p_header_rec.transaction_phase_code = 'N' THEN
111:
112: -- Cannot update following order attributes in negotiation phase
113:
114: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_number
115: ,p_old_header_rec.order_number)) OR
116: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
117: p_header_rec.order_number IS NOT NULL)
118: --OR cnd added for Bug 5060064

Line 116: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

112: -- Cannot update following order attributes in negotiation phase
113:
114: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_number
115: ,p_old_header_rec.order_number)) OR
116: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
117: p_header_rec.order_number IS NOT NULL)
118: --OR cnd added for Bug 5060064
119: THEN
120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');

Line 127: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date

123: OE_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;
126:
127: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date
128: ,p_old_header_rec.ordered_date)) OR
129: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
130: p_header_rec.ordered_date IS NOT NULL )
131: --OR cnd added for Bug 5060064

Line 129: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

125: END IF;
126:
127: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date
128: ,p_old_header_rec.ordered_date)) OR
129: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
130: p_header_rec.ordered_date IS NOT NULL )
131: --OR cnd added for Bug 5060064
132: THEN
133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');

Line 253: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

249: -- Ship To Org and Payment Term are required only on regular or
250: -- MIXED orders, NOT on RETURN orders
251:
252: IF p_header_rec.order_category_code <>
253: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
254:
255: IF p_header_rec.ship_to_org_id IS NULL
256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;

Line 425: IF p_operation = OE_GLOBALS.G_OPR_UPDATE

421: lprocessname varchar2(80);
422: BEGIN
423:
424: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.Validate_Order_Type',1);
425: IF p_operation = OE_GLOBALS.G_OPR_UPDATE
426: THEN
427: IF NOT OE_GLOBALS.EQUAL(p_order_type_id
428: ,p_old_Order_type_id)
429: THEN

Line 427: IF NOT OE_GLOBALS.EQUAL(p_order_type_id

423:
424: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.Validate_Order_Type',1);
425: IF p_operation = OE_GLOBALS.G_OPR_UPDATE
426: THEN
427: IF NOT OE_GLOBALS.EQUAL(p_order_type_id
428: ,p_old_Order_type_id)
429: THEN
430: SELECT root_activity
431: into lprocessname

Line 506: IF NOT OE_GLOBALS.EQUAL(l_commitment_curr_code, p_transactional_curr_code) THEN

502:
503: oe_debug_pub.add('OEXLHDRB: commitment currency is: '||l_commitment_curr_code, 3);
504: oe_debug_pub.add('OEXLHDRB: order currency is: '||p_transactional_curr_code, 3);
505:
506: IF NOT OE_GLOBALS.EQUAL(l_commitment_curr_code, p_transactional_curr_code) THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: EXIT;
509: END IF;
510: END IF;

Line 792: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:
791: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
792: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
793: ,p_old_header_rec.sold_to_org_id) OR
794: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
795: ,p_old_header_rec.blanket_number) ) THEN
796: If l_debug_level > 0 then

Line 794: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number

790:
791: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
792: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
793: ,p_old_header_rec.sold_to_org_id) OR
794: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
795: ,p_old_header_rec.blanket_number) ) THEN
796: If l_debug_level > 0 then
797: oe_debug_pub.add('Customer on release does not match blanket customer');
798: End if;

Line 840: (NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number

836: end if;
837: END IF;
838:
839: IF (p_header_rec.order_category_code = 'ORDER') AND ( l_on_hold_flag <> 'N') AND
840: (NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
841: ,p_old_header_rec.blanket_number) ) THEN
842: if l_debug_level > 0 then
843: OE_DEBUG_PUB.Add('Blanket order is currently on hold', 1);
844: end if;

Line 851: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date

847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849:
850: IF p_header_rec.order_category_code = 'ORDER' AND
851: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
852: ,p_old_header_rec.request_date) OR
853: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
854: ,p_old_header_rec.blanket_number)) AND
855: NOT (trunc(nvl(p_header_rec.request_date,sysdate))

Line 853: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number

849:
850: IF p_header_rec.order_category_code = 'ORDER' AND
851: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
852: ,p_old_header_rec.request_date) OR
853: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
854: ,p_old_header_rec.blanket_number)) AND
855: NOT (trunc(nvl(p_header_rec.request_date,sysdate))
856: BETWEEN trunc(l_start_date_active)
857: AND trunc(nvl(l_end_date_active, nvl(p_header_rec.request_date,sysdate)))) THEN

Line 961: l_control_rec OE_GLOBALS.Control_Rec_Type;

957: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
958: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
959:
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
961: l_control_rec OE_GLOBALS.Control_Rec_Type;
962: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
963: l_old_header_rec OE_Order_PUB.Header_Rec_Type := p_old_header_rec;
964: /* Added the above 3 line to fix the bug 2824240 */
965:

Line 1022: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

1018: END IF;
1019:
1020: -- QUOTING changes
1021: IF oe_code_control.code_release_level >= '110510'
1022: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1023: AND p_header_rec.transaction_phase_code IS NULL
1024: THEN
1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026:

Line 1267: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND

1263: IF (p_header_rec.price_list_id <>
1264: Nvl(p_old_header_rec.price_list_id,FND_API.G_MISS_NUM) OR
1265: p_header_rec.transactional_curr_code <>
1266: p_old_header_rec.transactional_curr_code OR
1267: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND
1268: p_header_rec.price_list_id IS NOT NULL
1269: THEN
1270: Begin
1271: QP_UTIL_PUB.Validate_Price_list_Curr_code(p_header_rec.price_list_id,

Line 1302: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1298:
1299: Exception when no_data_found then
1300: --retro{
1301: /* Added the following if condition to fix the bug 2824240 */
1302: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1303: p_header_rec.operation = 'CREATE'
1304: THEN
1305: IF(p_header_rec.order_source_id=27) THEN
1306: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;

Line 1310: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1306: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;
1307: ELSE
1308: p_header_rec.price_list_id := NULL;
1309: END IF;
1310: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1311: p_header_rec.operation = 'CREATE'
1312: THEN
1313: IF(p_header_rec.order_source_id=27) THEN
1314: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;

Line 1354: IF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,

1350: END IF; -- Price list or currency changed.
1351:
1352: -- bug 1618229, if the currency changed, also needs to revalidate commitment
1353: -- on the order line.
1354: IF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,
1355: p_old_header_rec.transactional_curr_code) THEN
1356:
1357: oe_debug_pub.add('OEXLHDRB: before validating currency for commitment.', 3);
1358: Validate_Commitment_Currency

Line 1451: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id

1447:
1448: -- Agreement depends on Order Type AND Sold To Org
1449: -- Added OR condition for CREATE Operation. Bug 5060064
1450:
1451: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1452: ,p_old_header_rec.order_type_id)) OR
1453: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1454: ,p_old_header_rec.agreement_id)) OR
1455: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

Line 1453: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id

1449: -- Added OR condition for CREATE Operation. Bug 5060064
1450:
1451: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1452: ,p_old_header_rec.order_type_id)) OR
1453: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1454: ,p_old_header_rec.agreement_id)) OR
1455: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1456: ,p_old_header_rec.sold_to_org_id)) OR
1457: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

Line 1455: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1451: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1452: ,p_old_header_rec.order_type_id)) OR
1453: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1454: ,p_old_header_rec.agreement_id)) OR
1455: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1456: ,p_old_header_rec.sold_to_org_id)) OR
1457: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
1458: THEN
1459:

Line 1457: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

1453: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1454: ,p_old_header_rec.agreement_id)) OR
1455: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1456: ,p_old_header_rec.sold_to_org_id)) OR
1457: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
1458: THEN
1459:
1460: IF p_header_rec.agreement_id IS NOT NULL THEN
1461: -- commented by Geresh

Line 1495: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1491:
1492: EXCEPTION
1493: WHEN NO_DATA_FOUND THEN
1494: /* Added the following if condition to fix the bug 2824240 */
1495: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1496: p_header_rec.operation = 'CREATE'
1497: THEN
1498: p_header_rec.agreement_id := NULL;
1499: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 1499: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1495: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1496: p_header_rec.operation = 'CREATE'
1497: THEN
1498: p_header_rec.agreement_id := NULL;
1499: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1500: p_header_rec.operation = 'CREATE'
1501: THEN
1502: p_header_rec.agreement_id := FND_API.G_MISS_NUM;
1503: l_header_rec := p_header_rec;

Line 1535: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN

1531: END;
1532:
1533: /* End of code added to fix the bug 2124912 */
1534:
1535: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
1536: -- any price list with 'PRL' type should be allowed to
1537: -- be associated with any agreement according to bug 1386406.
1538:
1539: select name ,sold_to_org_id , price_list_id

Line 1563: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN

1559: END IF;
1560:
1561: --bug 5206956 to check for customer relationships
1562: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
1563: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN
1564: IF nvl(lcustomer_relations,'N') = 'N' THEN
1565: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1567: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

Line 1645: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

1641:
1642: -- Ship to Org id depends on sold to org.
1643: -- Added OR condition for CREATE Operation. Bug 5060064
1644: IF p_header_rec.ship_to_org_id IS NOT NULL AND
1645: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
1646: ,p_old_header_rec.ship_to_org_id)
1647: OR
1648: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1649: ,p_old_header_rec.sold_to_org_id)

Line 1648: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1644: IF p_header_rec.ship_to_org_id IS NOT NULL AND
1645: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
1646: ,p_old_header_rec.ship_to_org_id)
1647: OR
1648: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1649: ,p_old_header_rec.sold_to_org_id)
1650: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1651: THEN
1652:

Line 1650: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

1646: ,p_old_header_rec.ship_to_org_id)
1647: OR
1648: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1649: ,p_old_header_rec.sold_to_org_id)
1650: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1651: THEN
1652:
1653: BEGIN
1654: oe_debug_pub.add

Line 1745: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id

1741: END IF; -- Ship To needed validation.
1742:
1743: -- Deliver to Org id depends on sold to org.
1744: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
1745: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
1746: ,p_old_header_rec.deliver_to_org_id)
1747: OR
1748: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1749: ,p_old_header_rec.sold_to_org_id)

Line 1748: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1744: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
1745: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
1746: ,p_old_header_rec.deliver_to_org_id)
1747: OR
1748: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1749: ,p_old_header_rec.sold_to_org_id)
1750: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1751: THEN
1752: BEGIN

Line 1750: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

1746: ,p_old_header_rec.deliver_to_org_id)
1747: OR
1748: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1749: ,p_old_header_rec.sold_to_org_id)
1750: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1751: THEN
1752: BEGIN
1753:
1754: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_header_rec.deliver_to_org_id),2);

Line 1843: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

1839:
1840: -- Invoice to Org id depends on sold to org.
1841:
1842: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
1843: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1844: ,p_old_header_rec.invoice_to_org_id) OR
1845: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1846: ,p_old_header_rec.sold_to_org_id)
1847: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1845: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1841:
1842: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
1843: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1844: ,p_old_header_rec.invoice_to_org_id) OR
1845: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1846: ,p_old_header_rec.sold_to_org_id)
1847: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1848: THEN
1849: BEGIN

Line 1847: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

1843: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1844: ,p_old_header_rec.invoice_to_org_id) OR
1845: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1846: ,p_old_header_rec.sold_to_org_id)
1847: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1848: THEN
1849: BEGIN
1850: oe_debug_pub.add
1851: ('invoice_to_org_id :'||to_char(p_header_rec.invoice_to_org_id),2);

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

1920: -- QUOTING changes
1921: -- Customer Location depends on Sold To Org
1922:
1923: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
1924: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1925: ,p_old_header_rec.sold_to_site_use_id) OR
1926: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1927: ,p_old_header_rec.sold_to_org_id)
1928: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1926: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1922:
1923: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
1924: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1925: ,p_old_header_rec.sold_to_site_use_id) OR
1926: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1927: ,p_old_header_rec.sold_to_org_id)
1928: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1929: THEN
1930:

Line 1928: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

1924: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1925: ,p_old_header_rec.sold_to_site_use_id) OR
1926: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1927: ,p_old_header_rec.sold_to_org_id)
1928: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1929: THEN
1930:
1931: BEGIN
1932:

Line 1980: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id

1976: -- QUOTING changes
1977:
1978: -- end customer contact id depends on end customer id
1979: IF p_header_rec.end_customer_contact_id IS NOT NULL AND
1980: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1981: ,p_old_header_rec.end_customer_contact_id) OR
1982: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1983: ,p_old_header_rec.end_customer_id)
1984: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1982: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id

1978: -- end customer contact id depends on end customer id
1979: IF p_header_rec.end_customer_contact_id IS NOT NULL AND
1980: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1981: ,p_old_header_rec.end_customer_contact_id) OR
1982: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1983: ,p_old_header_rec.end_customer_id)
1984: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1985: THEN
1986:

Line 1984: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

1980: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1981: ,p_old_header_rec.end_customer_contact_id) OR
1982: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1983: ,p_old_header_rec.end_customer_id)
1984: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1985: THEN
1986:
1987: BEGIN
1988:

Line 2029: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id

2025: END IF; -- End Customer contact needed validation.
2026:
2027:
2028: IF p_header_rec.end_customer_site_use_id IS NOT NULL AND
2029: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
2030: ,p_old_header_rec.end_customer_id) OR
2031: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
2032: ,p_old_header_rec.end_customer_id)
2033: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2031: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id

2027:
2028: IF p_header_rec.end_customer_site_use_id IS NOT NULL AND
2029: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
2030: ,p_old_header_rec.end_customer_id) OR
2031: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
2032: ,p_old_header_rec.end_customer_id)
2033: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2034: THEN
2035:

Line 2033: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

2029: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
2030: ,p_old_header_rec.end_customer_id) OR
2031: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
2032: ,p_old_header_rec.end_customer_id)
2033: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2034: THEN
2035:
2036: BEGIN
2037:

Line 2078: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id

2074:
2075: -- Sold to contact depends on Sold To Org
2076:
2077: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
2078: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2079: ,p_old_header_rec.sold_to_contact_id) OR
2080: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2081: ,p_old_header_rec.sold_to_org_id)
2082: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2080: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

2076:
2077: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
2078: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2079: ,p_old_header_rec.sold_to_contact_id) OR
2080: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2081: ,p_old_header_rec.sold_to_org_id)
2082: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2083: THEN
2084:

Line 2082: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

2078: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2079: ,p_old_header_rec.sold_to_contact_id) OR
2080: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2081: ,p_old_header_rec.sold_to_org_id)
2082: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2083: THEN
2084:
2085: BEGIN
2086:

Line 2129: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id

2125:
2126: -- Invoice to contact depends on Invoice To Org
2127:
2128: IF p_header_rec.invoice_to_contact_id IS NOT NULL AND
2129: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2130: ,p_old_header_rec.invoice_to_contact_id) OR
2131: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2132: ,p_old_header_rec.invoice_to_org_id)
2133: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2131: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

2127:
2128: IF p_header_rec.invoice_to_contact_id IS NOT NULL AND
2129: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2130: ,p_old_header_rec.invoice_to_contact_id) OR
2131: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2132: ,p_old_header_rec.invoice_to_org_id)
2133: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2134: THEN
2135: BEGIN

Line 2133: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

2129: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2130: ,p_old_header_rec.invoice_to_contact_id) OR
2131: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2132: ,p_old_header_rec.invoice_to_org_id)
2133: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2134: THEN
2135: BEGIN
2136: oe_debug_pub.add
2137: ('inv_to_contact :'||to_char(p_header_rec.invoice_to_contact_id),2);

Line 2189: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id

2185:
2186: -- Ship to contact depends on Ship To Org
2187:
2188: IF p_header_rec.ship_to_contact_id IS NOT NULL AND
2189: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2190: ,p_old_header_rec.ship_to_contact_id) OR
2191: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2192: ,p_old_header_rec.ship_to_org_id)
2193: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2191: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

2187:
2188: IF p_header_rec.ship_to_contact_id IS NOT NULL AND
2189: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2190: ,p_old_header_rec.ship_to_contact_id) OR
2191: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2192: ,p_old_header_rec.ship_to_org_id)
2193: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2194: THEN
2195:

Line 2193: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

2189: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2190: ,p_old_header_rec.ship_to_contact_id) OR
2191: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2192: ,p_old_header_rec.ship_to_org_id)
2193: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2194: THEN
2195:
2196: BEGIN
2197:

Line 2249: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id

2245:
2246: -- Deliver to contact depends on Deliver To Org
2247:
2248: IF p_header_rec.deliver_to_contact_id IS NOT NULL AND
2249: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2250: ,p_old_header_rec.deliver_to_contact_id) OR
2251: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2252: ,p_old_header_rec.deliver_to_org_id)
2253: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2251: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id

2247:
2248: IF p_header_rec.deliver_to_contact_id IS NOT NULL AND
2249: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2250: ,p_old_header_rec.deliver_to_contact_id) OR
2251: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2252: ,p_old_header_rec.deliver_to_org_id)
2253: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2254: THEN
2255:

Line 2253: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

2249: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2250: ,p_old_header_rec.deliver_to_contact_id) OR
2251: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2252: ,p_old_header_rec.deliver_to_org_id)
2253: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2254: THEN
2255:
2256: BEGIN
2257:

Line 2311: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number

2307: -- flag is 'S' (StANDard).
2308:
2309:
2310: /* IF p_header_rec.tax_exempt_flag IS NOT NULL
2311: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2312: ,p_old_header_rec.tax_exempt_number)
2313: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2314: ,p_old_header_rec.tax_exempt_reason_code)
2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

Line 2313: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code

2309:
2310: /* IF p_header_rec.tax_exempt_flag IS NOT NULL
2311: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2312: ,p_old_header_rec.tax_exempt_number)
2313: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2314: ,p_old_header_rec.tax_exempt_reason_code)
2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2316: ,p_old_header_rec.ship_to_org_id)
2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

Line 2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

2311: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2312: ,p_old_header_rec.tax_exempt_number)
2313: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2314: ,p_old_header_rec.tax_exempt_reason_code)
2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2316: ,p_old_header_rec.ship_to_org_id)
2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2318: ,p_old_header_rec.invoice_to_org_id)
2319: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

Line 2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

2313: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2314: ,p_old_header_rec.tax_exempt_reason_code)
2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2316: ,p_old_header_rec.ship_to_org_id)
2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2318: ,p_old_header_rec.invoice_to_org_id)
2319: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2320: ,p_old_header_rec.sold_to_org_id)
2321: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

Line 2319: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

2315: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2316: ,p_old_header_rec.ship_to_org_id)
2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2318: ,p_old_header_rec.invoice_to_org_id)
2319: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2320: ,p_old_header_rec.sold_to_org_id)
2321: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2322: )
2323: THEN

Line 2321: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

2317: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2318: ,p_old_header_rec.invoice_to_org_id)
2319: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2320: ,p_old_header_rec.sold_to_org_id)
2321: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2322: )
2323: THEN
2324:
2325: BEGIN

Line 2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2400:
2401: -- Bug 6118092 Redefault as it may be no more valid
2402: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2403: null;
2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2406: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2407: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;

Line 2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2401: -- Bug 6118092 Redefault as it may be no more valid
2402: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2403: null;
2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2406: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2407: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2409:

Line 2444: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

2440:
2441: -- Fix bug 1162304: issue a warning message if the PO number
2442: -- is being referenced by another order
2443: IF p_header_rec.cust_po_number IS NOT NULL
2444: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2445: ,p_old_header_rec.sold_to_org_id)
2446: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2447: ,p_old_header_rec.cust_po_number)
2448: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

Line 2446: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number

2442: -- is being referenced by another order
2443: IF p_header_rec.cust_po_number IS NOT NULL
2444: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2445: ,p_old_header_rec.sold_to_org_id)
2446: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2447: ,p_old_header_rec.cust_po_number)
2448: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2449: )
2450: THEN

Line 2448: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

2444: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2445: ,p_old_header_rec.sold_to_org_id)
2446: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2447: ,p_old_header_rec.cust_po_number)
2448: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2449: )
2450: THEN
2451:
2452: IF OE_Validate_Header.Is_Duplicate_PO_Number

Line 2473: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

2469: ** Fix Bug # 3015881
2470: ** No need to validate here as this will be validated anyway
2471: ** when the sold to org id changes are cascaded to the line.
2472:
2473: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2474: ,p_old_header_rec.sold_to_org_id)) THEN
2475:
2476: oe_debug_pub.add('OEXLHDRB: before validating customer for commitment.', 3);
2477: Validate_Commitment_Customer

Line 2538: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code

2534: --Commenting the following for bug 3733877
2535: /*
2536: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
2537:
2538: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code
2539: ,p_old_header_rec.payment_type_code))
2540: or
2541: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2542: ,p_old_header_rec.credit_card_code))

Line 2541: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code

2537:
2538: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code
2539: ,p_old_header_rec.payment_type_code))
2540: or
2541: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2542: ,p_old_header_rec.credit_card_code))
2543: or
2544: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2545: ,p_old_header_rec.credit_card_number))

Line 2544: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number

2540: or
2541: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2542: ,p_old_header_rec.credit_card_code))
2543: or
2544: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2545: ,p_old_header_rec.credit_card_number))
2546: or
2547: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2548: ,p_old_header_rec.credit_card_holder_name))

Line 2547: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name

2543: or
2544: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2545: ,p_old_header_rec.credit_card_number))
2546: or
2547: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2548: ,p_old_header_rec.credit_card_holder_name))
2549: or
2550: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2551: ,p_old_header_rec.credit_card_expiration_date))

Line 2550: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date

2546: or
2547: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2548: ,p_old_header_rec.credit_card_holder_name))
2549: or
2550: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2551: ,p_old_header_rec.credit_card_expiration_date))
2552: or
2553: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2554: ,p_old_header_rec.check_number))

Line 2553: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number

2549: or
2550: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2551: ,p_old_header_rec.credit_card_expiration_date))
2552: or
2553: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2554: ,p_old_header_rec.check_number))
2555: or
2556: (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount
2557: ,p_old_header_rec.payment_amount))

Line 2556: (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount

2552: or
2553: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2554: ,p_old_header_rec.check_number))
2555: or
2556: (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount
2557: ,p_old_header_rec.payment_amount))
2558:
2559: THEN
2560:

Line 2575: END IF; -- if not oe_globals.equal...

2571: oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
2572:
2573: end if;
2574:
2575: END IF; -- if not oe_globals.equal...
2576:
2577: END IF; -- if multiple_payments is enabled
2578: */
2579: --distributed orders @

Line 2582: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)

2578: */
2579: --distributed orders @
2580: oe_debug_pub.ADD('ib_owner: '||p_header_rec.ib_owner);
2581: IF p_header_rec.ib_owner IS NOT NULL AND
2582: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2583: OR p_old_header_rec.ib_owner is null
2584: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2585: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2586: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

Line 2584: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)

2580: oe_debug_pub.ADD('ib_owner: '||p_header_rec.ib_owner);
2581: IF p_header_rec.ib_owner IS NOT NULL AND
2582: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2583: OR p_old_header_rec.ib_owner is null
2584: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2585: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2586: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2587: THEN
2588: IF (p_header_rec.ib_owner = 'SOLD_TO' AND

Line 2585: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)

2581: IF p_header_rec.ib_owner IS NOT NULL AND
2582: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2583: OR p_old_header_rec.ib_owner is null
2584: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2585: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2586: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2587: THEN
2588: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2589: p_header_rec.sold_to_org_id is null)

Line 2586: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

2582: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2583: OR p_old_header_rec.ib_owner is null
2584: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2585: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2586: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2587: THEN
2588: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2589: p_header_rec.sold_to_org_id is null)
2590: THEN

Line 2607: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)

2603: END IF;
2604: oe_debug_pub.ADD('ib_installed_at_location: '||p_header_rec.ib_installed_at_location);
2605:
2606: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2607: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2608: OR p_old_header_rec.ib_installed_at_location is null
2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)

Line 2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)

2605:
2606: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2607: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2608: OR p_old_header_rec.ib_installed_at_location is null
2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

Line 2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)

2606: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2607: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2608: OR p_old_header_rec.ib_installed_at_location is null
2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

Line 2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)

2607: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2608: OR p_old_header_rec.ib_installed_at_location is null
2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2615: THEN

Line 2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)

2608: OR p_old_header_rec.ib_installed_at_location is null
2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2615: THEN
2616: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND

Line 2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

2609: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2615: THEN
2616: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2617: p_header_rec.invoice_to_org_id is null)

Line 2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

2610: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2611: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2612: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2613: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2614: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2615: THEN
2616: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2617: p_header_rec.invoice_to_org_id is null)
2618: THEN

Line 2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)

2652: END IF;
2653: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);
2654:
2655: IF p_header_rec.ib_current_location IS NOT NULL AND
2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)

Line 2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)

2653: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);
2654:
2655: IF p_header_rec.ib_current_location IS NOT NULL AND
2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

Line 2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)

2654:
2655: IF p_header_rec.ib_current_location IS NOT NULL AND
2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2662: OR p_old_header_rec.ib_current_location is null

Line 2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)

2655: IF p_header_rec.ib_current_location IS NOT NULL AND
2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2662: OR p_old_header_rec.ib_current_location is null
2663: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )

Line 2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)

2656: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2662: OR p_old_header_rec.ib_current_location is null
2663: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2664: THEN

Line 2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

2657: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2658: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2662: OR p_old_header_rec.ib_current_location is null
2663: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2664: THEN
2665: IF (p_header_rec.ib_current_location = 'BILL_TO' AND

Line 2663: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )

2659: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2660: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2661: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2662: OR p_old_header_rec.ib_current_location is null
2663: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2664: THEN
2665: IF (p_header_rec.ib_current_location = 'BILL_TO' AND
2666: p_header_rec.invoice_to_org_id is null)
2667: THEN

Line 2827: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2823: old rec and new rec may have the same values. To make sure that
2824: validation is done for the attributes during CREATE added an
2825: additional check of
2826: OR
2827: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2828: in all the conditions.
2829: */
2830:
2831: IF p_x_header_rec.accounting_rule_id IS NOT NULL AND

Line 2835: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2831: IF p_x_header_rec.accounting_rule_id IS NOT NULL AND
2832: ( ( p_x_header_rec.accounting_rule_id <>
2833: p_old_header_rec.accounting_rule_id OR
2834: p_old_header_rec.accounting_rule_id IS NULL ) OR
2835: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2836: --bug 5060064
2837: THEN
2838:
2839: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)

Line 2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2838:
2839: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2840: THEN
2841:
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2844: THEN
2845: p_x_header_rec.accounting_rule_id := NULL;
2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2839: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2840: THEN
2841:
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2844: THEN
2845: p_x_header_rec.accounting_rule_id := NULL;
2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2844: THEN
2845: p_x_header_rec.accounting_rule_id := NULL;
2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2848: THEN
2849: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2850: ELSE

Line 2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2844: THEN
2845: p_x_header_rec.accounting_rule_id := NULL;
2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2848: THEN
2849: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2850: ELSE
2851: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2862: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2858: IF p_x_header_rec.accounting_rule_duration IS NOT NULL AND
2859: ( (p_x_header_rec.accounting_rule_duration <>
2860: p_old_header_rec.accounting_rule_duration OR
2861: p_old_header_rec.accounting_rule_duration IS NULL ) OR
2862: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2863: --bug 5060064
2864: THEN
2865:
2866: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)

Line 2869: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2865:
2866: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2867: THEN
2868:
2869: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2871: THEN
2872: p_x_header_rec.accounting_rule_duration := NULL;
2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2866: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2867: THEN
2868:
2869: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2871: THEN
2872: p_x_header_rec.accounting_rule_duration := NULL;
2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2869: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2871: THEN
2872: p_x_header_rec.accounting_rule_duration := NULL;
2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2875: THEN
2876: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2877: ELSE

Line 2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2871: THEN
2872: p_x_header_rec.accounting_rule_duration := NULL;
2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2875: THEN
2876: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2877: ELSE
2878: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2889: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2885: IF p_x_header_rec.agreement_id IS NOT NULL AND
2886: ( ( p_x_header_rec.agreement_id <>
2887: p_old_header_rec.agreement_id OR
2888: p_old_header_rec.agreement_id IS NULL ) OR
2889: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2890: --bug 5060064
2891: THEN
2892:
2893: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)

Line 2895: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2891: THEN
2892:
2893: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2894: THEN
2895: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2897: THEN
2898: p_x_header_rec.agreement_id := NULL;
2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2892:
2893: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2894: THEN
2895: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2897: THEN
2898: p_x_header_rec.agreement_id := NULL;
2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2895: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2897: THEN
2898: p_x_header_rec.agreement_id := NULL;
2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2901: THEN
2902: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2903: ELSE

Line 2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2897: THEN
2898: p_x_header_rec.agreement_id := NULL;
2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2901: THEN
2902: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2903: ELSE
2904: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2917: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2913: IF p_x_header_rec.booked_flag IS NOT NULL AND
2914: ( ( p_x_header_rec.booked_flag <>
2915: p_old_header_rec.booked_flag OR
2916: p_old_header_rec.booked_flag IS NULL ) OR
2917: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2918: --bug 5060064
2919: THEN
2920: oe_debug_pub.add('sarita:before validate booked flag');
2921:

Line 2924: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2920: oe_debug_pub.add('sarita:before validate booked flag');
2921:
2922: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2923: THEN
2924: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2926: THEN
2927: p_x_header_rec.booked_flag := NULL;
2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2921:
2922: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2923: THEN
2924: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2926: THEN
2927: p_x_header_rec.booked_flag := NULL;
2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2924: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2926: THEN
2927: p_x_header_rec.booked_flag := NULL;
2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2932: ELSE

Line 2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2926: THEN
2927: p_x_header_rec.booked_flag := NULL;
2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2932: ELSE
2933: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2943: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2939: IF p_x_header_rec.cancelled_flag IS NOT NULL AND
2940: ( (p_x_header_rec.cancelled_flag <>
2941: p_old_header_rec.cancelled_flag OR
2942: p_old_header_rec.cancelled_flag IS NULL ) OR
2943: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2944: --bug 5060064
2945: THEN
2946:
2947: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)

Line 2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2945: THEN
2946:
2947: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2948: THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2951: THEN
2952: p_x_header_rec.cancelled_flag := NULL;
2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2946:
2947: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2948: THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2951: THEN
2952: p_x_header_rec.cancelled_flag := NULL;
2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2951: THEN
2952: p_x_header_rec.cancelled_flag := NULL;
2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2957: ELSE

Line 2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2951: THEN
2952: p_x_header_rec.cancelled_flag := NULL;
2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2957: ELSE
2958: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2968: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2964: IF p_x_header_rec.conversion_type_code IS NOT NULL AND
2965: ( (p_x_header_rec.conversion_type_code <>
2966: p_old_header_rec.conversion_type_code OR
2967: p_old_header_rec.conversion_type_code IS NULL ) OR
2968: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2969: --bug 5060064
2970: THEN
2971:
2972: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)

Line 2974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2970: THEN
2971:
2972: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2973: THEN
2974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2976: THEN
2977: p_x_header_rec.conversion_type_code := NULL;
2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2971:
2972: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2973: THEN
2974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2976: THEN
2977: p_x_header_rec.conversion_type_code := NULL;
2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2976: THEN
2977: p_x_header_rec.conversion_type_code := NULL;
2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2982: ELSE

Line 2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2976: THEN
2977: p_x_header_rec.conversion_type_code := NULL;
2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2982: ELSE
2983: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2993: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

2989: IF p_x_header_rec.deliver_to_contact_id IS NOT NULL AND
2990: ( (p_x_header_rec.deliver_to_contact_id <>
2991: p_old_header_rec.deliver_to_contact_id OR
2992: p_old_header_rec.deliver_to_contact_id IS NULL ) OR
2993: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2994: --bug 5060064
2995: THEN
2996:
2997: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN

Line 2998: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2994: --bug 5060064
2995: THEN
2996:
2997: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2998: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3000: THEN
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2995: THEN
2996:
2997: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2998: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3000: THEN
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2998: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3000: THEN
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3004: THEN
3005: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3006: ELSE

Line 3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3000: THEN
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3004: THEN
3005: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3006: ELSE
3007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3017: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3013: IF p_x_header_rec.deliver_to_org_id IS NOT NULL AND
3014: ( ( p_x_header_rec.deliver_to_org_id <>
3015: p_old_header_rec.deliver_to_org_id OR
3016: p_old_header_rec.deliver_to_org_id IS NULL ) OR
3017: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3018: --bug 5060064
3019: THEN
3020:
3021: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)

Line 3023: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3019: THEN
3020:
3021: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
3022: THEN
3023: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3025: THEN
3026: p_x_header_rec.deliver_to_org_id := NULL;
3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3020:
3021: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
3022: THEN
3023: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3025: THEN
3026: p_x_header_rec.deliver_to_org_id := NULL;
3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3023: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3025: THEN
3026: p_x_header_rec.deliver_to_org_id := NULL;
3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3029: THEN
3030: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3031: ELSE

Line 3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3025: THEN
3026: p_x_header_rec.deliver_to_org_id := NULL;
3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3029: THEN
3030: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3031: ELSE
3032: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3042: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3038: IF p_x_header_rec.demAND_class_code IS NOT NULL AND
3039: ( (p_x_header_rec.demAND_class_code <>
3040: p_old_header_rec.demAND_class_code OR
3041: p_old_header_rec.demAND_class_code IS NULL ) OR
3042: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3043: --bug 5060064
3044: THEN
3045:
3046: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)

Line 3048: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3044: THEN
3045:
3046: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
3047: THEN
3048: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3050: THEN
3051: p_x_header_rec.demAND_class_code := NULL;
3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3045:
3046: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
3047: THEN
3048: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3050: THEN
3051: p_x_header_rec.demAND_class_code := NULL;
3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3048: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3050: THEN
3051: p_x_header_rec.demAND_class_code := NULL;
3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
3056: ELSE

Line 3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3050: THEN
3051: p_x_header_rec.demAND_class_code := NULL;
3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
3056: ELSE
3057: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3067: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3063: IF p_x_header_rec.fob_point_code IS NOT NULL AND
3064: ( ( p_x_header_rec.fob_point_code <>
3065: p_old_header_rec.fob_point_code OR
3066: p_old_header_rec.fob_point_code IS NULL ) OR
3067: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3068: --bug 5060064
3069: THEN
3070:
3071: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)

Line 3073: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3069: THEN
3070:
3071: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3072: THEN
3073: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3075: THEN
3076: p_x_header_rec.fob_point_code := NULL;
3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3070:
3071: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3072: THEN
3073: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3075: THEN
3076: p_x_header_rec.fob_point_code := NULL;
3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3073: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3075: THEN
3076: p_x_header_rec.fob_point_code := NULL;
3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3081: ELSE

Line 3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3075: THEN
3076: p_x_header_rec.fob_point_code := NULL;
3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3092: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3088: IF p_x_header_rec.freight_terms_code IS NOT NULL AND
3089: ( (p_x_header_rec.freight_terms_code <>
3090: p_old_header_rec.freight_terms_code OR
3091: p_old_header_rec.freight_terms_code IS NULL ) OR
3092: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3093: --bug 5060064
3094: THEN
3095:
3096: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)

Line 3098: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3094: THEN
3095:
3096: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3097: THEN
3098: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3100: THEN
3101: p_x_header_rec.freight_terms_code := NULL;
3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3095:
3096: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3097: THEN
3098: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3100: THEN
3101: p_x_header_rec.freight_terms_code := NULL;
3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3098: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3100: THEN
3101: p_x_header_rec.freight_terms_code := NULL;
3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3106: ELSE

Line 3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3100: THEN
3101: p_x_header_rec.freight_terms_code := NULL;
3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3106: ELSE
3107: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3117: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3113: IF p_x_header_rec.invoice_to_contact_id IS NOT NULL AND
3114: ( (p_x_header_rec.invoice_to_contact_id <>
3115: p_old_header_rec.invoice_to_contact_id OR
3116: p_old_header_rec.invoice_to_contact_id IS NULL ) OR
3117: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3118: --bug 5060064
3119: THEN
3120:
3121: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN

Line 3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3118: --bug 5060064
3119: THEN
3120:
3121: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3124: THEN
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3119: THEN
3120:
3121: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3124: THEN
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3124: THEN
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3128: THEN
3129: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3130: ELSE

Line 3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3124: THEN
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3128: THEN
3129: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3130: ELSE
3131: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3141: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3137: IF p_x_header_rec.invoice_to_org_id IS NOT NULL AND
3138: ( (p_x_header_rec.invoice_to_org_id <>
3139: p_old_header_rec.invoice_to_org_id OR
3140: p_old_header_rec.invoice_to_org_id IS NULL ) OR
3141: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3142: --bug 5060064
3143: THEN
3144:
3145: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)

Line 3147: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3143: THEN
3144:
3145: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3146: THEN
3147: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3149: THEN
3150: p_x_header_rec.invoice_to_org_id := NULL;
3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3144:
3145: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3146: THEN
3147: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3149: THEN
3150: p_x_header_rec.invoice_to_org_id := NULL;
3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3147: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3149: THEN
3150: p_x_header_rec.invoice_to_org_id := NULL;
3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3153: THEN
3154: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3155: ELSE

Line 3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3149: THEN
3150: p_x_header_rec.invoice_to_org_id := NULL;
3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3153: THEN
3154: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3155: ELSE
3156: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3166: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3162: IF p_x_header_rec.invoicing_rule_id IS NOT NULL AND
3163: ( ( p_x_header_rec.invoicing_rule_id <>
3164: p_old_header_rec.invoicing_rule_id OR
3165: p_old_header_rec.invoicing_rule_id IS NULL ) OR
3166: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3167: --bug 5060064
3168: THEN
3169:
3170: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)

Line 3172: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3168: THEN
3169:
3170: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3171: THEN
3172: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3174: THEN
3175: p_x_header_rec.invoicing_rule_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3169:
3170: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3171: THEN
3172: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3174: THEN
3175: p_x_header_rec.invoicing_rule_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3172: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3174: THEN
3175: p_x_header_rec.invoicing_rule_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3178: THEN
3179: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3180: ELSE

Line 3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3174: THEN
3175: p_x_header_rec.invoicing_rule_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3178: THEN
3179: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3180: ELSE
3181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3191: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3187: IF p_x_header_rec.open_flag IS NOT NULL AND
3188: ( (p_x_header_rec.open_flag <>
3189: p_old_header_rec.open_flag OR
3190: p_old_header_rec.open_flag IS NULL ) OR
3191: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3192: --bug 5060064
3193: THEN
3194:
3195: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)

Line 3197: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3193: THEN
3194:
3195: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3196: THEN
3197: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3199: THEN
3200: p_x_header_rec.open_flag := NULL;
3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3194:
3195: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3196: THEN
3197: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3199: THEN
3200: p_x_header_rec.open_flag := NULL;
3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3197: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3199: THEN
3200: p_x_header_rec.open_flag := NULL;
3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3203: THEN
3204: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3205: ELSE

Line 3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3199: THEN
3200: p_x_header_rec.open_flag := NULL;
3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3203: THEN
3204: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3205: ELSE
3206: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3216: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3212: IF p_x_header_rec.order_date_type_code IS NOT NULL AND
3213: ( (p_x_header_rec.order_date_type_code <>
3214: p_old_header_rec.order_date_type_code OR
3215: p_old_header_rec.order_date_type_code IS NULL ) OR
3216: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3217: --bug 5060064
3218: THEN
3219:
3220: IF NOT OE_Validate.Order_Date_Type_Code

Line 3223: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3219:
3220: IF NOT OE_Validate.Order_Date_Type_Code
3221: (p_x_header_rec.order_date_type_code)
3222: THEN
3223: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3225: THEN
3226: p_x_header_rec.order_date_type_code := NULL;
3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3220: IF NOT OE_Validate.Order_Date_Type_Code
3221: (p_x_header_rec.order_date_type_code)
3222: THEN
3223: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3225: THEN
3226: p_x_header_rec.order_date_type_code := NULL;
3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3223: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3225: THEN
3226: p_x_header_rec.order_date_type_code := NULL;
3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3229: THEN
3230: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3231: ELSE

Line 3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3225: THEN
3226: p_x_header_rec.order_date_type_code := NULL;
3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3229: THEN
3230: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3231: ELSE
3232: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3247: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3243: IF p_x_header_rec.order_type_id IS NOT NULL AND
3244: ( (p_x_header_rec.order_type_id <>
3245: p_old_header_rec.order_type_id OR
3246: p_old_header_rec.order_type_id IS NULL ) OR
3247: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3248: --bug 5060064
3249: THEN
3250: oe_debug_pub.add('Before OE_Validate.Order_Type');
3251:

Line 3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3250: oe_debug_pub.add('Before OE_Validate.Order_Type');
3251:
3252: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3253: THEN
3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3256: THEN
3257: p_x_header_rec.order_type_id := NULL;
3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3251:
3252: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3253: THEN
3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3256: THEN
3257: p_x_header_rec.order_type_id := NULL;
3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3256: THEN
3257: p_x_header_rec.order_type_id := NULL;
3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3260: THEN
3261: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3262: ELSE

Line 3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3256: THEN
3257: p_x_header_rec.order_type_id := NULL;
3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3260: THEN
3261: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3262: ELSE
3263: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3273: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3269: IF p_x_header_rec.payment_term_id IS NOT NULL AND
3270: ( (p_x_header_rec.payment_term_id <>
3271: p_old_header_rec.payment_term_id OR
3272: p_old_header_rec.payment_term_id IS NULL ) OR
3273: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3274: --bug 5060064
3275: THEN
3276:
3277: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)

Line 3279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3275: THEN
3276:
3277: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3278: THEN
3279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3281: THEN
3282: p_x_header_rec.payment_term_id := NULL;
3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3276:
3277: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3278: THEN
3279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3281: THEN
3282: p_x_header_rec.payment_term_id := NULL;
3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3281: THEN
3282: p_x_header_rec.payment_term_id := NULL;
3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3285: THEN
3286: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3287: ELSE

Line 3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3281: THEN
3282: p_x_header_rec.payment_term_id := NULL;
3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3285: THEN
3286: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3287: ELSE
3288: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3298: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3294: IF p_x_header_rec.price_list_id IS NOT NULL AND
3295: ( (p_x_header_rec.price_list_id <>
3296: p_old_header_rec.price_list_id OR
3297: p_old_header_rec.price_list_id IS NULL ) OR
3298: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3299: --bug 5060064
3300: THEN
3301:
3302: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)

Line 3307: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3303: THEN
3304: -- Bug 3572931 Commented the code below.
3305: -- p_x_header_rec.price_list_id := NULL;
3306: -- ELSE
3307: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3308: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3309: -- THEN
3310: -- x_return_status := FND_API.G_RET_STS_ERROR;
3311: -- END IF;

Line 3308: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3304: -- Bug 3572931 Commented the code below.
3305: -- p_x_header_rec.price_list_id := NULL;
3306: -- ELSE
3307: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3308: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3309: -- THEN
3310: -- x_return_status := FND_API.G_RET_STS_ERROR;
3311: -- END IF;
3312: -- Bug 3572931 if the validation level is partial set to NULL,

Line 3314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3310: -- x_return_status := FND_API.G_RET_STS_ERROR;
3311: -- END IF;
3312: -- Bug 3572931 if the validation level is partial set to NULL,
3313: -- if partial with defaulting set to G_MISS_NUM.
3314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3315: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3316: THEN
3317: p_x_header_rec.price_list_id := NULL;
3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3315: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3311: -- END IF;
3312: -- Bug 3572931 if the validation level is partial set to NULL,
3313: -- if partial with defaulting set to G_MISS_NUM.
3314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3315: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3316: THEN
3317: p_x_header_rec.price_list_id := NULL;
3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3315: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3316: THEN
3317: p_x_header_rec.price_list_id := NULL;
3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3322: ELSE

Line 3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3315: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3316: THEN
3317: p_x_header_rec.price_list_id := NULL;
3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3322: ELSE
3323: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3333: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3329: IF p_x_header_rec.shipment_priority_code IS NOT NULL AND
3330: ( (p_x_header_rec.shipment_priority_code <>
3331: p_old_header_rec.shipment_priority_code OR
3332: p_old_header_rec.shipment_priority_code IS NULL ) OR
3333: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3334: --bug 5060064
3335: THEN
3336:
3337: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN

Line 3338: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3334: --bug 5060064
3335: THEN
3336:
3337: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3338: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3340: THEN
3341: p_x_header_rec.shipment_priority_code := NULL;
3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3335: THEN
3336:
3337: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3338: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3340: THEN
3341: p_x_header_rec.shipment_priority_code := NULL;
3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3338: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3340: THEN
3341: p_x_header_rec.shipment_priority_code := NULL;
3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3344: THEN
3345: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3346: ELSE

Line 3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3340: THEN
3341: p_x_header_rec.shipment_priority_code := NULL;
3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3344: THEN
3345: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3346: ELSE
3347: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3357: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3353: IF p_x_header_rec.shipping_method_code IS NOT NULL AND
3354: ( (p_x_header_rec.shipping_method_code <>
3355: p_old_header_rec.shipping_method_code OR
3356: p_old_header_rec.shipping_method_code IS NULL ) OR
3357: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3358: --bug 5060064
3359: THEN
3360:
3361: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)

Line 3363: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3359: THEN
3360:
3361: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3362: THEN
3363: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3365: THEN
3366: p_x_header_rec.shipping_method_code := NULL;
3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3360:
3361: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3362: THEN
3363: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3365: THEN
3366: p_x_header_rec.shipping_method_code := NULL;
3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3363: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3365: THEN
3366: p_x_header_rec.shipping_method_code := NULL;
3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3369: THEN
3370: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3371: ELSE

Line 3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3365: THEN
3366: p_x_header_rec.shipping_method_code := NULL;
3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3369: THEN
3370: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3371: ELSE
3372: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3382: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3378: IF p_x_header_rec.ship_from_org_id IS NOT NULL AND
3379: ( (p_x_header_rec.ship_from_org_id <>
3380: p_old_header_rec.ship_from_org_id OR
3381: p_old_header_rec.ship_from_org_id IS NULL ) OR
3382: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3383: --bug 5060064
3384: THEN
3385:
3386: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)

Line 3388: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3384: THEN
3385:
3386: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3387: THEN
3388: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3390: THEN
3391: p_x_header_rec.ship_from_org_id := NULL;
3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3385:
3386: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3387: THEN
3388: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3390: THEN
3391: p_x_header_rec.ship_from_org_id := NULL;
3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3388: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3390: THEN
3391: p_x_header_rec.ship_from_org_id := NULL;
3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3394: THEN
3395: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3396: ELSE

Line 3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3390: THEN
3391: p_x_header_rec.ship_from_org_id := NULL;
3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3394: THEN
3395: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3396: ELSE
3397: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3407: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3403: IF p_x_header_rec.ship_to_contact_id IS NOT NULL AND
3404: ( (p_x_header_rec.ship_to_contact_id <>
3405: p_old_header_rec.ship_to_contact_id OR
3406: p_old_header_rec.ship_to_contact_id IS NULL ) OR
3407: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3408: --bug 5060064
3409: THEN
3410:
3411: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)

Line 3413: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3409: THEN
3410:
3411: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3412: THEN
3413: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3415: THEN
3416: p_x_header_rec.ship_to_contact_id := NULL;
3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3410:
3411: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3412: THEN
3413: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3415: THEN
3416: p_x_header_rec.ship_to_contact_id := NULL;
3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3413: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3415: THEN
3416: p_x_header_rec.ship_to_contact_id := NULL;
3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3419: THEN
3420: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3421: ELSE

Line 3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3415: THEN
3416: p_x_header_rec.ship_to_contact_id := NULL;
3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3419: THEN
3420: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3421: ELSE
3422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3432: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3428: IF p_x_header_rec.ship_to_org_id IS NOT NULL AND
3429: ( (p_x_header_rec.ship_to_org_id <>
3430: p_old_header_rec.ship_to_org_id OR
3431: p_old_header_rec.ship_to_org_id IS NULL ) OR
3432: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3433: --bug 5060064
3434: THEN
3435:
3436: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)

Line 3438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3434: THEN
3435:
3436: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3437: THEN
3438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3440: THEN
3441: p_x_header_rec.ship_to_org_id := NULL;
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3435:
3436: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3437: THEN
3438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3440: THEN
3441: p_x_header_rec.ship_to_org_id := NULL;
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3440: THEN
3441: p_x_header_rec.ship_to_org_id := NULL;
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3444: THEN
3445: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3446: ELSE

Line 3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3440: THEN
3441: p_x_header_rec.ship_to_org_id := NULL;
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3444: THEN
3445: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3446: ELSE
3447: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3458: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3454: IF p_x_header_rec.sold_to_contact_id IS NOT NULL AND
3455: ( (p_x_header_rec.sold_to_contact_id <>
3456: p_old_header_rec.sold_to_contact_id OR
3457: p_old_header_rec.sold_to_contact_id IS NULL ) OR
3458: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3459: --bug 5060064
3460: THEN
3461:
3462: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)

Line 3464: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3460: THEN
3461:
3462: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3463: THEN
3464: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3466: THEN
3467: p_x_header_rec.sold_to_contact_id := NULL;
3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3461:
3462: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3463: THEN
3464: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3466: THEN
3467: p_x_header_rec.sold_to_contact_id := NULL;
3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3464: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3466: THEN
3467: p_x_header_rec.sold_to_contact_id := NULL;
3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3470: THEN
3471: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3472: ELSE

Line 3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3466: THEN
3467: p_x_header_rec.sold_to_contact_id := NULL;
3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3470: THEN
3471: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3472: ELSE
3473: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3483: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3479: IF p_x_header_rec.sold_to_org_id IS NOT NULL AND
3480: ( (p_x_header_rec.sold_to_org_id <>
3481: p_old_header_rec.sold_to_org_id OR
3482: p_old_header_rec.sold_to_org_id IS NULL ) OR
3483: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3484: --bug 5060064
3485: THEN
3486:
3487: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)

Line 3489: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3485: THEN
3486:
3487: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3488: THEN
3489: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3491: THEN
3492: p_x_header_rec.sold_to_org_id := NULL;
3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3486:
3487: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3488: THEN
3489: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3491: THEN
3492: p_x_header_rec.sold_to_org_id := NULL;
3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3489: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3491: THEN
3492: p_x_header_rec.sold_to_org_id := NULL;
3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3495: THEN
3496: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3497: ELSE

Line 3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3491: THEN
3492: p_x_header_rec.sold_to_org_id := NULL;
3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3495: THEN
3496: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3497: ELSE
3498: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3508: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3504: IF p_x_header_rec.sold_to_phone_id IS NOT NULL AND
3505: ( (p_x_header_rec.sold_to_phone_id <>
3506: p_old_header_rec.sold_to_phone_id OR
3507: p_old_header_rec.sold_to_phone_id IS NULL ) OR
3508: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3509: --bug 5060064
3510: THEN
3511:
3512: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)

Line 3514: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3510: THEN
3511:
3512: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3513: THEN
3514: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3516: THEN
3517: p_x_header_rec.sold_to_phone_id := NULL;
3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3511:
3512: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3513: THEN
3514: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3516: THEN
3517: p_x_header_rec.sold_to_phone_id := NULL;
3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3514: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3516: THEN
3517: p_x_header_rec.sold_to_phone_id := NULL;
3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3520: THEN
3521: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3522: ELSE

Line 3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3516: THEN
3517: p_x_header_rec.sold_to_phone_id := NULL;
3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3520: THEN
3521: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3522: ELSE
3523: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3533: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3529: IF p_x_header_rec.source_document_type_id IS NOT NULL AND
3530: ( (p_x_header_rec.source_document_type_id <>
3531: p_old_header_rec.source_document_type_id OR
3532: p_old_header_rec.source_document_type_id IS NULL ) OR
3533: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3534: --bug 5060064
3535: THEN
3536:
3537: IF NOT OE_Validate.Source_Document_Type

Line 3540: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3536:
3537: IF NOT OE_Validate.Source_Document_Type
3538: (p_x_header_rec.source_document_type_id)
3539: THEN
3540: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3542: THEN
3543: p_x_header_rec.source_document_type_id := NULL;
3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3537: IF NOT OE_Validate.Source_Document_Type
3538: (p_x_header_rec.source_document_type_id)
3539: THEN
3540: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3542: THEN
3543: p_x_header_rec.source_document_type_id := NULL;
3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3540: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3542: THEN
3543: p_x_header_rec.source_document_type_id := NULL;
3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3546: THEN
3547: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3548: ELSE

Line 3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3542: THEN
3543: p_x_header_rec.source_document_type_id := NULL;
3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3546: THEN
3547: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3548: ELSE
3549: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3559: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3555: IF p_x_header_rec.tax_exempt_flag IS NOT NULL AND
3556: ( (p_x_header_rec.tax_exempt_flag <>
3557: p_old_header_rec.tax_exempt_flag OR
3558: p_old_header_rec.tax_exempt_flag IS NULL ) OR
3559: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3560: --bug 5060064
3561: THEN
3562: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3563: THEN

Line 3564: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3560: --bug 5060064
3561: THEN
3562: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3563: THEN
3564: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3566: THEN
3567: p_x_header_rec.tax_exempt_flag := NULL;
3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3561: THEN
3562: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3563: THEN
3564: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3566: THEN
3567: p_x_header_rec.tax_exempt_flag := NULL;
3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3564: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3566: THEN
3567: p_x_header_rec.tax_exempt_flag := NULL;
3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3570: THEN
3571: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3572: ELSE

Line 3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3566: THEN
3567: p_x_header_rec.tax_exempt_flag := NULL;
3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3570: THEN
3571: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3572: ELSE
3573: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3583: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3579: IF p_x_header_rec.tax_exempt_reason_code IS NOT NULL AND
3580: ( (p_x_header_rec.tax_exempt_reason_code <>
3581: p_old_header_rec.tax_exempt_reason_code OR
3582: p_old_header_rec.tax_exempt_reason_code IS NULL ) OR
3583: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3584: --bug 5060064
3585: THEN
3586:
3587: IF NOT OE_Validate.Tax_Exempt_Reason

Line 3590: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3586:
3587: IF NOT OE_Validate.Tax_Exempt_Reason
3588: (p_x_header_rec.tax_exempt_reason_code)
3589: THEN
3590: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3592: THEN
3593: p_x_header_rec.tax_exempt_reason_code := NULL;
3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3587: IF NOT OE_Validate.Tax_Exempt_Reason
3588: (p_x_header_rec.tax_exempt_reason_code)
3589: THEN
3590: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3592: THEN
3593: p_x_header_rec.tax_exempt_reason_code := NULL;
3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3590: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3592: THEN
3593: p_x_header_rec.tax_exempt_reason_code := NULL;
3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3596: THEN
3597: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3598: ELSE

Line 3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3592: THEN
3593: p_x_header_rec.tax_exempt_reason_code := NULL;
3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3596: THEN
3597: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3598: ELSE
3599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3609: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3605: IF p_x_header_rec.tax_point_code IS NOT NULL AND
3606: ( ( p_x_header_rec.tax_point_code <>
3607: p_old_header_rec.tax_point_code OR
3608: p_old_header_rec.tax_point_code IS NULL ) OR
3609: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3610: --bug 5060064
3611: THEN
3612:
3613: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)

Line 3615: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3611: THEN
3612:
3613: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3614: THEN
3615: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3617: THEN
3618: p_x_header_rec.tax_point_code := NULL;
3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3612:
3613: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3614: THEN
3615: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3617: THEN
3618: p_x_header_rec.tax_point_code := NULL;
3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3615: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3617: THEN
3618: p_x_header_rec.tax_point_code := NULL;
3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3621: THEN
3622: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3623: ELSE

Line 3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3617: THEN
3618: p_x_header_rec.tax_point_code := NULL;
3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3621: THEN
3622: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3623: ELSE
3624: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3634: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3630: IF p_x_header_rec.transactional_curr_code IS NOT NULL AND
3631: ( (p_x_header_rec.transactional_curr_code <>
3632: p_old_header_rec.transactional_curr_code OR
3633: p_old_header_rec.transactional_curr_code IS NULL ) OR
3634: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3635: --bug 5060064
3636: THEN
3637:
3638: IF NOT OE_Validate.Transactional_Curr

Line 3641: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3637:
3638: IF NOT OE_Validate.Transactional_Curr
3639: (p_x_header_rec.transactional_curr_code)
3640: THEN
3641: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3643: THEN
3644: p_x_header_rec.transactional_curr_code := NULL;
3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3638: IF NOT OE_Validate.Transactional_Curr
3639: (p_x_header_rec.transactional_curr_code)
3640: THEN
3641: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3643: THEN
3644: p_x_header_rec.transactional_curr_code := NULL;
3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3641: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3643: THEN
3644: p_x_header_rec.transactional_curr_code := NULL;
3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3647: THEN
3648: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3649: ELSE

Line 3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3643: THEN
3644: p_x_header_rec.transactional_curr_code := NULL;
3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3647: THEN
3648: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3649: ELSE
3650: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3660: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3656: IF p_x_header_rec.payment_type_code IS NOT NULL AND
3657: ( (p_x_header_rec.payment_type_code <>
3658: p_old_header_rec.payment_type_code OR
3659: p_old_header_rec.payment_type_code IS NULL ) OR
3660: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3661: --bug 5060064
3662: THEN
3663:
3664: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)

Line 3666: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3662: THEN
3663:
3664: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3665: THEN
3666: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3668: THEN
3669: p_x_header_rec.payment_type_code := NULL;
3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3663:
3664: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3665: THEN
3666: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3668: THEN
3669: p_x_header_rec.payment_type_code := NULL;
3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3666: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3668: THEN
3669: p_x_header_rec.payment_type_code := NULL;
3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3672: THEN
3673: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3674: ELSE

Line 3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3668: THEN
3669: p_x_header_rec.payment_type_code := NULL;
3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3672: THEN
3673: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3674: ELSE
3675: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3687: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3683: IF p_x_header_rec.credit_card_code IS NOT NULL AND
3684: ( ( p_x_header_rec.credit_card_code <>
3685: p_old_header_rec.credit_card_code OR
3686: p_old_header_rec.credit_card_code IS NULL ) OR
3687: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3688: --bug 5060064
3689: THEN
3690: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3691: THEN

Line 3692: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3688: --bug 5060064
3689: THEN
3690: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3691: THEN
3692: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3694: THEN
3695: p_x_header_rec.credit_card_code := NULL;
3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3689: THEN
3690: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3691: THEN
3692: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3694: THEN
3695: p_x_header_rec.credit_card_code := NULL;
3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3692: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3694: THEN
3695: p_x_header_rec.credit_card_code := NULL;
3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3698: THEN
3699: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3700: ELSE

Line 3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3694: THEN
3695: p_x_header_rec.credit_card_code := NULL;
3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3698: THEN
3699: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3700: ELSE
3701: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3748: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))

3744: IF p_x_header_rec.flow_status_code IS NOT NULL AND
3745: ( (p_x_header_rec.flow_status_code <>
3746: p_old_header_rec.flow_status_code OR
3747: p_old_header_rec.flow_status_code IS NULL ) OR
3748: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3749: --bug 5060064
3750: THEN
3751:
3752: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)

Line 3754: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3750: THEN
3751:
3752: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)
3753: THEN
3754: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3756: THEN
3757: p_x_header_rec.flow_status_code := NULL;
3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3751:
3752: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)
3753: THEN
3754: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3756: THEN
3757: p_x_header_rec.flow_status_code := NULL;
3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3754: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3756: THEN
3757: p_x_header_rec.flow_status_code := NULL;
3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3760: THEN
3761: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3762: ELSE

Line 3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3756: THEN
3757: p_x_header_rec.flow_status_code := NULL;
3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3760: THEN
3761: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3762: ELSE
3763: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3770: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612

3766:
3767: END IF;
3768:
3769: oe_Debug_pub.add('after flow_status_code');
3770: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3771: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3772: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3773:
3774: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

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

3768:
3769: oe_Debug_pub.add('after flow_status_code');
3770: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3771: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3772: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3773:
3774: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3775: (p_x_header_rec.attribute1 IS NOT NULL AND
3776: ( p_x_header_rec.attribute1 <>

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

3770: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3771: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3772: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3773:
3774: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3775: (p_x_header_rec.attribute1 IS NOT NULL AND
3776: ( p_x_header_rec.attribute1 <>
3777: p_old_header_rec.attribute1 OR
3778: p_old_header_rec.attribute1 IS NULL ))

Line 3901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3897: ,p_attribute19 => p_x_header_rec.attribute19
3898: ,p_attribute20 => p_x_header_rec.attribute20)
3899: THEN
3900:
3901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3902: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3903: THEN
3904: p_x_header_rec.context := null;
3905: p_x_header_rec.attribute1 := null;

Line 3902: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3898: ,p_attribute20 => p_x_header_rec.attribute20)
3899: THEN
3900:
3901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3902: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3903: THEN
3904: p_x_header_rec.context := null;
3905: p_x_header_rec.attribute1 := null;
3906: p_x_header_rec.attribute2 := null;

Line 3927: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3923: p_x_header_rec.attribute19 := null;
3924: p_x_header_rec.attribute20 := null;
3925:
3926:
3927: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3924: p_x_header_rec.attribute20 := null;
3925:
3926:
3927: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 4069: IF p_x_header_rec.operation = oe_globals.g_opr_create OR

4065: END IF ; -- If flex enabled
4066: END IF;
4067:
4068: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);
4069: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4070: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4071: (p_x_header_rec.global_attribute1 IS NOT NULL AND
4072: ( p_x_header_rec.global_attribute1 <>
4073: p_old_header_rec.global_attribute1 OR

Line 4070: ( p_x_header_rec.operation = oe_globals.g_opr_update AND

4066: END IF;
4067:
4068: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);
4069: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4070: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4071: (p_x_header_rec.global_attribute1 IS NOT NULL AND
4072: ( p_x_header_rec.global_attribute1 <>
4073: p_old_header_rec.global_attribute1 OR
4074: p_old_header_rec.global_attribute1 IS NULL ))

Line 4189: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4185: ,p_attribute19 => p_x_header_rec.global_attribute19
4186: ,p_attribute20 => p_x_header_rec.global_attribute20)
4187: THEN
4188:
4189: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4190: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4191: THEN
4192:
4193: p_x_header_rec.global_attribute_category := null;

Line 4190: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4186: ,p_attribute20 => p_x_header_rec.global_attribute20)
4187: THEN
4188:
4189: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4190: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4191: THEN
4192:
4193: p_x_header_rec.global_attribute_category := null;
4194: p_x_header_rec.global_attribute1 := null;

Line 4214: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4210: p_x_header_rec.global_attribute18 := null;
4211: p_x_header_rec.global_attribute19 := null;
4212: p_x_header_rec.global_attribute20 := null;
4213:
4214: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4215: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4216: THEN
4217:
4218: p_x_header_rec.global_attribute_category

Line 4215: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4211: p_x_header_rec.global_attribute19 := null;
4212: p_x_header_rec.global_attribute20 := null;
4213:
4214: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4215: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4216: THEN
4217:
4218: p_x_header_rec.global_attribute_category
4219: := FND_API.G_MISS_CHAR;

Line 4358: IF p_x_header_rec.operation = oe_globals.g_opr_create OR

4354:
4355: -- Added the Trading Partner Flex Validation and also the changes for defaulting
4356: -- for bug 2511313
4357:
4358: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4359: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4360: (p_x_header_rec.tp_attribute1 IS NOT NULL AND
4361: ( p_x_header_rec.tp_attribute1 <>
4362: p_old_header_rec.tp_attribute1 OR

Line 4359: ( p_x_header_rec.operation = oe_globals.g_opr_update AND

4355: -- Added the Trading Partner Flex Validation and also the changes for defaulting
4356: -- for bug 2511313
4357:
4358: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4359: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4360: (p_x_header_rec.tp_attribute1 IS NOT NULL AND
4361: ( p_x_header_rec.tp_attribute1 <>
4362: p_old_header_rec.tp_attribute1 OR
4363: p_old_header_rec.tp_attribute1 IS NULL ))

Line 4442: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4438: ,p_attribute13 => p_x_header_rec.tp_attribute13
4439: ,p_attribute14 => p_x_header_rec.tp_attribute14
4440: ,p_attribute15 => p_x_header_rec.tp_attribute15) THEN
4441:
4442: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4444:
4445:
4446: p_x_header_rec.tp_context := null;

Line 4443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4439: ,p_attribute14 => p_x_header_rec.tp_attribute14
4440: ,p_attribute15 => p_x_header_rec.tp_attribute15) THEN
4441:
4442: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4444:
4445:
4446: p_x_header_rec.tp_context := null;
4447: p_x_header_rec.tp_attribute1 := null;

Line 4463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4459: p_x_header_rec.tp_attribute13 := null;
4460: p_x_header_rec.tp_attribute14 := null;
4461: p_x_header_rec.tp_attribute15 := null;
4462:
4463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;

Line 4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN

4460: p_x_header_rec.tp_attribute14 := null;
4461: p_x_header_rec.tp_attribute15 := null;
4462:
4463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;

Line 4583: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4579: IF p_x_header_rec.salesrep_id IS NOT NULL AND
4580: ( (p_x_header_rec.salesrep_id <>
4581: p_old_header_rec.salesrep_id OR
4582: p_old_header_rec.salesrep_id IS NULL ) OR
4583: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4584: --bug 5060064
4585: THEN
4586:
4587: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)

Line 4589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4585: THEN
4586:
4587: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4588: THEN
4589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4591: THEN
4592: p_x_header_rec.salesrep_id := NULL;
4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4586:
4587: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4588: THEN
4589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4591: THEN
4592: p_x_header_rec.salesrep_id := NULL;
4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4591: THEN
4592: p_x_header_rec.salesrep_id := NULL;
4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4595: THEN
4596: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4597: ELSE

Line 4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4591: THEN
4592: p_x_header_rec.salesrep_id := NULL;
4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4595: THEN
4596: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4597: ELSE
4598: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4610: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4606: IF p_x_header_rec.sales_channel_code IS NOT NULL AND
4607: ( (p_x_header_rec.sales_channel_code <>
4608: p_old_header_rec.sales_channel_code OR
4609: p_old_header_rec.sales_channel_code IS NULL ) OR
4610: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4611: --bug 5060064
4612: THEN
4613:
4614: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)

Line 4616: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4612: THEN
4613:
4614: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4615: THEN
4616: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4618: THEN
4619: p_x_header_rec.sales_channel_code := NULL;
4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4613:
4614: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4615: THEN
4616: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4618: THEN
4619: p_x_header_rec.sales_channel_code := NULL;
4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4616: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4618: THEN
4619: p_x_header_rec.sales_channel_code := NULL;
4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4622: THEN
4623: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4624: ELSE

Line 4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4618: THEN
4619: p_x_header_rec.sales_channel_code := NULL;
4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4622: THEN
4623: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4624: ELSE
4625: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4637: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4633: IF p_x_header_rec.return_reason_code IS NOT NULL AND
4634: ( (p_x_header_rec.return_reason_code <>
4635: p_old_header_rec.return_reason_code OR
4636: p_old_header_rec.return_reason_code IS NULL ) OR
4637: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4638: --bug 5060064
4639: THEN
4640:
4641: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN

Line 4642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4638: --bug 5060064
4639: THEN
4640:
4641: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4644: THEN
4645: p_x_header_rec.return_reason_code := NULL;
4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4639: THEN
4640:
4641: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4644: THEN
4645: p_x_header_rec.return_reason_code := NULL;
4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4644: THEN
4645: p_x_header_rec.return_reason_code := NULL;
4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4648: THEN
4649: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4650: ELSE

Line 4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4644: THEN
4645: p_x_header_rec.return_reason_code := NULL;
4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4648: THEN
4649: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4650: ELSE
4651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4663: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4659: IF p_x_header_rec.Default_fulfillment_set IS NOT NULL AND
4660: ( (p_x_header_rec.default_fulfillment_set <>
4661: p_old_header_rec.default_fulfillment_set OR
4662: p_old_header_rec.default_fulfillment_set IS NULL ) OR
4663: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4664: --bug 5060064
4665: THEN
4666:
4667: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)

Line 4669: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4665: THEN
4666:
4667: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4668: THEN
4669: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4671: THEN
4672: p_x_header_rec.default_fulfillment_set := NULL;
4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4666:
4667: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4668: THEN
4669: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4671: THEN
4672: p_x_header_rec.default_fulfillment_set := NULL;
4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4669: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4671: THEN
4672: p_x_header_rec.default_fulfillment_set := NULL;
4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4675: THEN
4676: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4677: ELSE

Line 4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4671: THEN
4672: p_x_header_rec.default_fulfillment_set := NULL;
4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4675: THEN
4676: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4677: ELSE
4678: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4689: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4685: IF p_x_header_rec.fulfillment_set_name IS NOT NULL AND
4686: ( (p_x_header_rec.fulfillment_set_name <>
4687: p_old_header_rec.fulfillment_set_name OR
4688: p_old_header_rec.fulfillment_set_name IS NULL ) OR
4689: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4690: --bug 5060064
4691: THEN
4692:
4693: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)

Line 4695: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4691: THEN
4692:
4693: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4694: THEN
4695: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4697: THEN
4698: p_x_header_rec.fulfillment_set_name := NULL;
4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4692:
4693: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4694: THEN
4695: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4697: THEN
4698: p_x_header_rec.fulfillment_set_name := NULL;
4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4695: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4697: THEN
4698: p_x_header_rec.fulfillment_set_name := NULL;
4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4701: THEN
4702: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4703: ELSE

Line 4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4697: THEN
4698: p_x_header_rec.fulfillment_set_name := NULL;
4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4701: THEN
4702: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4703: ELSE
4704: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4715: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4711: IF p_x_header_rec.Line_set_name IS NOT NULL AND
4712: ( (p_x_header_rec.Line_set_name <>
4713: p_old_header_rec.Line_set_name OR
4714: p_old_header_rec.Line_set_name IS NULL ) OR
4715: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4716: --bug 5060064
4717: THEN
4718:
4719: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)

Line 4721: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4717: THEN
4718:
4719: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4720: THEN
4721: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4723: THEN
4724: p_x_header_rec.line_set_name := NULL;
4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4718:
4719: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4720: THEN
4721: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4723: THEN
4724: p_x_header_rec.line_set_name := NULL;
4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4721: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4723: THEN
4724: p_x_header_rec.line_set_name := NULL;
4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4727: THEN
4728: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4729: ELSE

Line 4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4723: THEN
4724: p_x_header_rec.line_set_name := NULL;
4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4727: THEN
4728: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4729: ELSE
4730: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4744: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4740: IF p_x_header_rec.user_status_code IS NOT NULL AND
4741: ( (p_x_header_rec.user_status_code <>
4742: p_old_header_rec.user_status_code OR
4743: p_old_header_rec.user_status_code IS NULL ) OR
4744: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4745: --bug 5060064
4746: THEN
4747:
4748: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)

Line 4750: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4746: THEN
4747:
4748: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4749: THEN
4750: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4752: THEN
4753: p_x_header_rec.user_status_code := NULL;
4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4747:
4748: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4749: THEN
4750: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4752: THEN
4753: p_x_header_rec.user_status_code := NULL;
4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4750: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4752: THEN
4753: p_x_header_rec.user_status_code := NULL;
4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4756: THEN
4757: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4758: ELSE

Line 4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4752: THEN
4753: p_x_header_rec.user_status_code := NULL;
4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4756: THEN
4757: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4758: ELSE
4759: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4771: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4767: IF p_x_header_rec.version_number IS NOT NULL AND
4768: ( (p_x_header_rec.version_number <>
4769: p_old_header_rec.version_number OR
4770: p_old_header_rec.version_number IS NULL ) OR
4771: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4772: --bug 5060064
4773: THEN
4774:
4775: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)

Line 4777: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4773: THEN
4774:
4775: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4776: THEN
4777: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4779: THEN
4780: p_x_header_rec.version_number := NULL;
4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4774:
4775: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4776: THEN
4777: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4779: THEN
4780: p_x_header_rec.version_number := NULL;
4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4777: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4779: THEN
4780: p_x_header_rec.version_number := NULL;
4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4783: THEN
4784: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4785: ELSE

Line 4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4779: THEN
4780: p_x_header_rec.version_number := NULL;
4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4783: THEN
4784: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4785: ELSE
4786: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4797: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4793: IF p_x_header_rec.expiration_date IS NOT NULL AND
4794: ( (p_x_header_rec.expiration_date <>
4795: p_old_header_rec.expiration_date OR
4796: p_old_header_rec.expiration_date IS NULL ) OR
4797: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4798: --bug 5060064
4799: THEN
4800:
4801: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)

Line 4803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4799: THEN
4800:
4801: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4802: THEN
4803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4805: THEN
4806: p_x_header_rec.expiration_date := NULL;
4807: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4800:
4801: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4802: THEN
4803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4805: THEN
4806: p_x_header_rec.expiration_date := NULL;
4807: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4808: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4807: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4805: THEN
4806: p_x_header_rec.expiration_date := NULL;
4807: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4808: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4809: THEN
4810: -- Bug 3222419
4811: -- Copy was failing with numeric/value error if expiration date

Line 4808: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4805: THEN
4806: p_x_header_rec.expiration_date := NULL;
4807: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4808: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4809: THEN
4810: -- Bug 3222419
4811: -- Copy was failing with numeric/value error if expiration date
4812: -- supplied was < sysdate

Line 4826: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4822: IF p_x_header_rec.sold_to_site_use_id IS NOT NULL AND
4823: ( (p_x_header_rec.sold_to_site_use_id <>
4824: p_old_header_rec.sold_to_site_use_id OR
4825: p_old_header_rec.sold_to_site_use_id IS NULL ) OR
4826: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4827: --bug 5060064
4828: THEN
4829: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4830: THEN

Line 4831: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4827: --bug 5060064
4828: THEN
4829: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4830: THEN
4831: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4833: THEN
4834: p_x_header_rec.sold_to_site_use_id := NULL;
4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4828: THEN
4829: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4830: THEN
4831: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4833: THEN
4834: p_x_header_rec.sold_to_site_use_id := NULL;
4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4831: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4833: THEN
4834: p_x_header_rec.sold_to_site_use_id := NULL;
4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4837: THEN
4838: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4839: ELSE

Line 4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4833: THEN
4834: p_x_header_rec.sold_to_site_use_id := NULL;
4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4837: THEN
4838: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4839: ELSE
4840: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4849: IF p_x_header_rec.Minisite_Id IS NOT NULL AND
4850: ( (p_x_header_rec.Minisite_Id <>
4851: p_old_header_rec.Minisite_Id OR
4852: p_old_header_rec.Minisite_Id IS NULL ) OR
4853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4854: --bug 5060064
4855: THEN
4856:
4857: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)

Line 4859: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4855: THEN
4856:
4857: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4858: THEN
4859: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4861: THEN
4862: p_x_header_rec.Minisite_Id := NULL;
4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4856:
4857: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4858: THEN
4859: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4861: THEN
4862: p_x_header_rec.Minisite_Id := NULL;
4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4859: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4861: THEN
4862: p_x_header_rec.Minisite_Id := NULL;
4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4865: THEN
4866: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4867: ELSE

Line 4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4861: THEN
4862: p_x_header_rec.Minisite_Id := NULL;
4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4865: THEN
4866: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4867: ELSE
4868: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4879: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4875: IF p_x_header_rec.Ib_owner IS NOT NULL AND
4876: ( (p_x_header_rec.Ib_owner <>
4877: p_old_header_rec.Ib_owner OR
4878: p_old_header_rec.Ib_owner IS NULL ) OR
4879: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4880: --bug 5060064
4881: THEN
4882:
4883: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)

Line 4885: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4881: THEN
4882:
4883: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4884: THEN
4885: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4887: THEN
4888: p_x_header_rec.Ib_owner := NULL;
4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4882:
4883: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4884: THEN
4885: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4887: THEN
4888: p_x_header_rec.Ib_owner := NULL;
4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4885: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4887: THEN
4888: p_x_header_rec.Ib_owner := NULL;
4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4891: THEN
4892: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4893: ELSE

Line 4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4887: THEN
4888: p_x_header_rec.Ib_owner := NULL;
4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4891: THEN
4892: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4893: ELSE
4894: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4905: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4901: IF p_x_header_rec.Ib_installed_at_location IS NOT NULL AND
4902: ( (p_x_header_rec.Ib_installed_at_location <>
4903: p_old_header_rec.Ib_installed_at_location OR
4904: p_old_header_rec.Ib_installed_at_location IS NULL ) OR
4905: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4906: --bug 5060064
4907: THEN
4908:
4909: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)

Line 4911: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4907: THEN
4908:
4909: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4910: THEN
4911: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4913: THEN
4914: p_x_header_rec.Ib_installed_at_location := NULL;
4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4908:
4909: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4910: THEN
4911: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4913: THEN
4914: p_x_header_rec.Ib_installed_at_location := NULL;
4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4911: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4913: THEN
4914: p_x_header_rec.Ib_installed_at_location := NULL;
4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4917: THEN
4918: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4919: ELSE

Line 4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4913: THEN
4914: p_x_header_rec.Ib_installed_at_location := NULL;
4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4917: THEN
4918: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4919: ELSE
4920: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4931: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4927: IF p_x_header_rec.Ib_current_location IS NOT NULL AND
4928: ( (p_x_header_rec.Ib_current_location <>
4929: p_old_header_rec.Ib_current_location OR
4930: p_old_header_rec.Ib_current_location IS NULL ) OR
4931: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4932: --bug 5060064
4933: THEN
4934:
4935: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)

Line 4937: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4933: THEN
4934:
4935: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4936: THEN
4937: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4939: THEN
4940: p_x_header_rec.Ib_current_location := NULL;
4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4934:
4935: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4936: THEN
4937: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4939: THEN
4940: p_x_header_rec.Ib_current_location := NULL;
4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4937: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4939: THEN
4940: p_x_header_rec.Ib_current_location := NULL;
4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4943: THEN
4944: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4945: ELSE

Line 4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4939: THEN
4940: p_x_header_rec.Ib_current_location := NULL;
4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4943: THEN
4944: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4945: ELSE
4946: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4957: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4953: IF p_x_header_rec.End_customer_id IS NOT NULL AND
4954: ( (p_x_header_rec.End_customer_id <>
4955: p_old_header_rec.End_customer_id OR
4956: p_old_header_rec.End_customer_id IS NULL ) OR
4957: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4958: --bug 5060064
4959: THEN
4960:
4961: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)

Line 4963: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4959: THEN
4960:
4961: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4962: THEN
4963: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4965: THEN
4966: p_x_header_rec.End_customer_id := NULL;
4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4960:
4961: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4962: THEN
4963: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4965: THEN
4966: p_x_header_rec.End_customer_id := NULL;
4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4963: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4965: THEN
4966: p_x_header_rec.End_customer_id := NULL;
4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4969: THEN
4970: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4971: ELSE

Line 4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4965: THEN
4966: p_x_header_rec.End_customer_id := NULL;
4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4969: THEN
4970: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4971: ELSE
4972: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4983: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

4979: IF p_x_header_rec.End_customer_contact_id IS NOT NULL AND
4980: ( (p_x_header_rec.End_customer_contact_id <>
4981: p_old_header_rec.End_customer_contact_id OR
4982: p_old_header_rec.End_customer_contact_id IS NULL ) OR
4983: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4984: --bug 5060064
4985: THEN
4986:
4987: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)

Line 4989: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4985: THEN
4986:
4987: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4988: THEN
4989: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4991: THEN
4992: p_x_header_rec.End_customer_contact_id := NULL;
4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4986:
4987: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4988: THEN
4989: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4991: THEN
4992: p_x_header_rec.End_customer_contact_id := NULL;
4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4989: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4991: THEN
4992: p_x_header_rec.End_customer_contact_id := NULL;
4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4995: THEN
4996: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4997: ELSE

Line 4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4991: THEN
4992: p_x_header_rec.End_customer_contact_id := NULL;
4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4995: THEN
4996: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4997: ELSE
4998: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5009: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

5005: IF p_x_header_rec.End_customer_site_use_id IS NOT NULL AND
5006: ( (p_x_header_rec.End_customer_site_use_id <>
5007: p_old_header_rec.End_customer_site_use_id OR
5008: p_old_header_rec.End_customer_site_use_id IS NULL ) OR
5009: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5010: --bug 5060064
5011: THEN
5012:
5013: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)

Line 5015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5011: THEN
5012:
5013: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
5014: THEN
5015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5017: THEN
5018: p_x_header_rec.End_customer_site_use_id := NULL;
5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5012:
5013: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
5014: THEN
5015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5017: THEN
5018: p_x_header_rec.End_customer_site_use_id := NULL;
5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5017: THEN
5018: p_x_header_rec.End_customer_site_use_id := NULL;
5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5021: THEN
5022: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
5023: ELSE

Line 5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5017: THEN
5018: p_x_header_rec.End_customer_site_use_id := NULL;
5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5021: THEN
5022: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
5023: ELSE
5024: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5035: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

5031: IF p_x_header_rec.supplier_signature IS NOT NULL AND
5032: ( (p_x_header_rec.supplier_signature <>
5033: p_old_header_rec.supplier_signature OR
5034: p_old_header_rec.supplier_signature IS NULL ) OR
5035: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5036: --bug 5060064
5037: THEN
5038:
5039: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)

Line 5041: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5037: THEN
5038:
5039: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
5040: THEN
5041: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5043: THEN
5044: p_x_header_rec.supplier_signature := NULL;
5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5038:
5039: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
5040: THEN
5041: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5043: THEN
5044: p_x_header_rec.supplier_signature := NULL;
5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5041: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5043: THEN
5044: p_x_header_rec.supplier_signature := NULL;
5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5047: THEN
5048: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
5049: ELSE

Line 5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5043: THEN
5044: p_x_header_rec.supplier_signature := NULL;
5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5047: THEN
5048: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
5049: ELSE
5050: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5061: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

5057: IF p_x_header_rec.supplier_signature_date IS NOT NULL AND
5058: ( (p_x_header_rec.supplier_signature_date <>
5059: p_old_header_rec.supplier_signature_date OR
5060: p_old_header_rec.supplier_signature_date IS NULL ) OR
5061: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5062: --bug 5060064
5063: THEN
5064:
5065: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)

Line 5067: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5063: THEN
5064:
5065: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
5066: THEN
5067: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5069: THEN
5070: p_x_header_rec.supplier_signature_date := NULL;
5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5064:
5065: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
5066: THEN
5067: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5069: THEN
5070: p_x_header_rec.supplier_signature_date := NULL;
5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5067: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5069: THEN
5070: p_x_header_rec.supplier_signature_date := NULL;
5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5073: THEN
5074: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
5075: ELSE

Line 5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5069: THEN
5070: p_x_header_rec.supplier_signature_date := NULL;
5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5073: THEN
5074: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
5075: ELSE
5076: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5087: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

5083: IF p_x_header_rec.customer_signature IS NOT NULL AND
5084: ( (p_x_header_rec.customer_signature <>
5085: p_old_header_rec.customer_signature OR
5086: p_old_header_rec.customer_signature IS NULL ) OR
5087: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5088: --bug 5060064
5089: THEN
5090:
5091: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)

Line 5093: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5089: THEN
5090:
5091: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5092: THEN
5093: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5095: THEN
5096: p_x_header_rec.customer_signature := NULL;
5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5090:
5091: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5092: THEN
5093: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5095: THEN
5096: p_x_header_rec.customer_signature := NULL;
5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5093: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5095: THEN
5096: p_x_header_rec.customer_signature := NULL;
5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5099: THEN
5100: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5101: ELSE

Line 5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5095: THEN
5096: p_x_header_rec.customer_signature := NULL;
5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5099: THEN
5100: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5101: ELSE
5102: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5113: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )

5109: IF p_x_header_rec.customer_signature_date IS NOT NULL AND
5110: ( (p_x_header_rec.customer_signature_date <>
5111: p_old_header_rec.customer_signature_date OR
5112: p_old_header_rec.customer_signature_date IS NULL ) OR
5113: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5114: --bug 5060064
5115: THEN
5116:
5117: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)

Line 5119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5115: THEN
5116:
5117: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5118: THEN
5119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5121: THEN
5122: p_x_header_rec.customer_signature_date := NULL;
5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5116:
5117: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5118: THEN
5119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5121: THEN
5122: p_x_header_rec.customer_signature_date := NULL;
5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5121: THEN
5122: p_x_header_rec.customer_signature_date := NULL;
5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5125: THEN
5126: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5127: ELSE

Line 5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5121: THEN
5122: p_x_header_rec.customer_signature_date := NULL;
5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5125: THEN
5126: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5127: ELSE
5128: x_return_status := FND_API.G_RET_STS_ERROR;