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 761: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END;
759:
760: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
761: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
762: ,p_old_header_rec.sold_to_org_id) OR
763: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
764: ,p_old_header_rec.blanket_number) ) THEN
765: If l_debug_level > 0 then

Line 763: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number

759:
760: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
761: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
762: ,p_old_header_rec.sold_to_org_id) OR
763: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
764: ,p_old_header_rec.blanket_number) ) THEN
765: If l_debug_level > 0 then
766: oe_debug_pub.add('Customer on release does not match blanket customer');
767: End if;

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

805: end if;
806: END IF;
807:
808: IF (p_header_rec.order_category_code = 'ORDER') AND ( l_on_hold_flag <> 'N') AND
809: (NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
810: ,p_old_header_rec.blanket_number) ) THEN
811: if l_debug_level > 0 then
812: OE_DEBUG_PUB.Add('Blanket order is currently on hold', 1);
813: end if;

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

816: x_return_status := FND_API.G_RET_STS_ERROR;
817: END IF;
818:
819: IF p_header_rec.order_category_code = 'ORDER' AND
820: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
821: ,p_old_header_rec.request_date) OR
822: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
823: ,p_old_header_rec.blanket_number)) AND
824: NOT (trunc(nvl(p_header_rec.request_date,sysdate))

Line 822: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number

818:
819: IF p_header_rec.order_category_code = 'ORDER' AND
820: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
821: ,p_old_header_rec.request_date) OR
822: NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number
823: ,p_old_header_rec.blanket_number)) AND
824: NOT (trunc(nvl(p_header_rec.request_date,sysdate))
825: BETWEEN trunc(l_start_date_active)
826: AND trunc(nvl(l_end_date_active, nvl(p_header_rec.request_date,sysdate)))) THEN

Line 930: l_control_rec OE_GLOBALS.Control_Rec_Type;

926: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
927: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
928:
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
930: l_control_rec OE_GLOBALS.Control_Rec_Type;
931: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
932: l_old_header_rec OE_Order_PUB.Header_Rec_Type := p_old_header_rec;
933: /* Added the above 3 line to fix the bug 2824240 */
934:

Line 991: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

987: END IF;
988:
989: -- QUOTING changes
990: IF oe_code_control.code_release_level >= '110510'
991: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
992: AND p_header_rec.transaction_phase_code IS NULL
993: THEN
994: l_return_status := FND_API.G_RET_STS_ERROR;
995:

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

1195: IF (p_header_rec.price_list_id <>
1196: Nvl(p_old_header_rec.price_list_id,FND_API.G_MISS_NUM) OR
1197: p_header_rec.transactional_curr_code <>
1198: p_old_header_rec.transactional_curr_code OR
1199: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND
1200: p_header_rec.price_list_id IS NOT NULL
1201: THEN
1202: Begin
1203: QP_UTIL_PUB.Validate_Price_list_Curr_code(p_header_rec.price_list_id,

Line 1234: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1230:
1231: Exception when no_data_found then
1232: --retro{
1233: /* Added the following if condition to fix the bug 2824240 */
1234: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1235: p_header_rec.operation = 'CREATE'
1236: THEN
1237: IF(p_header_rec.order_source_id=27) THEN
1238: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;

Line 1242: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1238: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;
1239: ELSE
1240: p_header_rec.price_list_id := NULL;
1241: END IF;
1242: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1243: p_header_rec.operation = 'CREATE'
1244: THEN
1245: IF(p_header_rec.order_source_id=27) THEN
1246: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;

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

1282: END IF; -- Price list or currency changed.
1283:
1284: -- bug 1618229, if the currency changed, also needs to revalidate commitment
1285: -- on the order line.
1286: IF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,
1287: p_old_header_rec.transactional_curr_code) THEN
1288:
1289: oe_debug_pub.add('OEXLHDRB: before validating currency for commitment.', 3);
1290: Validate_Commitment_Currency

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

1379:
1380: -- Agreement depends on Order Type AND Sold To Org
1381: -- Added OR condition for CREATE Operation. Bug 5060064
1382:
1383: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1384: ,p_old_header_rec.order_type_id)) OR
1385: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1386: ,p_old_header_rec.agreement_id)) OR
1387: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

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

1381: -- Added OR condition for CREATE Operation. Bug 5060064
1382:
1383: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1384: ,p_old_header_rec.order_type_id)) OR
1385: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1386: ,p_old_header_rec.agreement_id)) OR
1387: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1388: ,p_old_header_rec.sold_to_org_id)) OR
1389: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

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

1383: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id
1384: ,p_old_header_rec.order_type_id)) OR
1385: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1386: ,p_old_header_rec.agreement_id)) OR
1387: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1388: ,p_old_header_rec.sold_to_org_id)) OR
1389: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
1390: THEN
1391:

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

1385: (NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id
1386: ,p_old_header_rec.agreement_id)) OR
1387: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1388: ,p_old_header_rec.sold_to_org_id)) OR
1389: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
1390: THEN
1391:
1392: IF p_header_rec.agreement_id IS NOT NULL THEN
1393: -- commented by Geresh

Line 1427: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

1423:
1424: EXCEPTION
1425: WHEN NO_DATA_FOUND THEN
1426: /* Added the following if condition to fix the bug 2824240 */
1427: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1428: p_header_rec.operation = 'CREATE'
1429: THEN
1430: p_header_rec.agreement_id := NULL;
1431: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 1431: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

1427: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1428: p_header_rec.operation = 'CREATE'
1429: THEN
1430: p_header_rec.agreement_id := NULL;
1431: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1432: p_header_rec.operation = 'CREATE'
1433: THEN
1434: p_header_rec.agreement_id := FND_API.G_MISS_NUM;
1435: l_header_rec := p_header_rec;

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

1463: END;
1464:
1465: /* End of code added to fix the bug 2124912 */
1466:
1467: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
1468: -- any price list with 'PRL' type should be allowed to
1469: -- be associated with any agreement according to bug 1386406.
1470:
1471: select name ,sold_to_org_id , price_list_id

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

1491: END IF;
1492:
1493: --bug 5206956 to check for customer relationships
1494: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
1495: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN
1496: IF nvl(lcustomer_relations,'N') = 'N' THEN
1497: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1498: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1499: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

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

1573:
1574: -- Ship to Org id depends on sold to org.
1575: -- Added OR condition for CREATE Operation. Bug 5060064
1576: IF p_header_rec.ship_to_org_id IS NOT NULL AND
1577: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
1578: ,p_old_header_rec.ship_to_org_id)
1579: OR
1580: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1581: ,p_old_header_rec.sold_to_org_id)

Line 1580: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1576: IF p_header_rec.ship_to_org_id IS NOT NULL AND
1577: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
1578: ,p_old_header_rec.ship_to_org_id)
1579: OR
1580: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1581: ,p_old_header_rec.sold_to_org_id)
1582: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1583: THEN
1584:

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

1578: ,p_old_header_rec.ship_to_org_id)
1579: OR
1580: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1581: ,p_old_header_rec.sold_to_org_id)
1582: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1583: THEN
1584:
1585: BEGIN
1586: oe_debug_pub.add

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

1673: END IF; -- Ship To needed validation.
1674:
1675: -- Deliver to Org id depends on sold to org.
1676: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
1677: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
1678: ,p_old_header_rec.deliver_to_org_id)
1679: OR
1680: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1681: ,p_old_header_rec.sold_to_org_id)

Line 1680: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1676: IF p_header_rec.deliver_to_org_id IS NOT NULL AND
1677: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
1678: ,p_old_header_rec.deliver_to_org_id)
1679: OR
1680: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1681: ,p_old_header_rec.sold_to_org_id)
1682: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1683: THEN
1684: BEGIN

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

1678: ,p_old_header_rec.deliver_to_org_id)
1679: OR
1680: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1681: ,p_old_header_rec.sold_to_org_id)
1682: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1683: THEN
1684: BEGIN
1685:
1686: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_header_rec.deliver_to_org_id),2);

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

1771:
1772: -- Invoice to Org id depends on sold to org.
1773:
1774: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
1775: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1776: ,p_old_header_rec.invoice_to_org_id) OR
1777: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1778: ,p_old_header_rec.sold_to_org_id)
1779: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1777: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1773:
1774: IF p_header_rec.invoice_to_org_id IS NOT NULL AND
1775: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1776: ,p_old_header_rec.invoice_to_org_id) OR
1777: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1778: ,p_old_header_rec.sold_to_org_id)
1779: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1780: THEN
1781: BEGIN

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

1775: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
1776: ,p_old_header_rec.invoice_to_org_id) OR
1777: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1778: ,p_old_header_rec.sold_to_org_id)
1779: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1780: THEN
1781: BEGIN
1782: oe_debug_pub.add
1783: ('invoice_to_org_id :'||to_char(p_header_rec.invoice_to_org_id),2);

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

1851: -- QUOTING changes
1852: -- Customer Location depends on Sold To Org
1853:
1854: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
1855: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1856: ,p_old_header_rec.sold_to_site_use_id) OR
1857: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1858: ,p_old_header_rec.sold_to_org_id)
1859: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1857: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

1853:
1854: IF p_header_rec.sold_to_site_use_id IS NOT NULL AND
1855: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1856: ,p_old_header_rec.sold_to_site_use_id) OR
1857: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1858: ,p_old_header_rec.sold_to_org_id)
1859: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1860: THEN
1861:

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

1855: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id
1856: ,p_old_header_rec.sold_to_site_use_id) OR
1857: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
1858: ,p_old_header_rec.sold_to_org_id)
1859: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1860: THEN
1861:
1862: BEGIN
1863:

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

1907: -- QUOTING changes
1908:
1909: -- end customer contact id depends on end customer id
1910: IF p_header_rec.end_customer_contact_id IS NOT NULL AND
1911: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1912: ,p_old_header_rec.end_customer_contact_id) OR
1913: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1914: ,p_old_header_rec.end_customer_id)
1915: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1913: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id

1909: -- end customer contact id depends on end customer id
1910: IF p_header_rec.end_customer_contact_id IS NOT NULL AND
1911: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1912: ,p_old_header_rec.end_customer_contact_id) OR
1913: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1914: ,p_old_header_rec.end_customer_id)
1915: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1916: THEN
1917:

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

1911: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_contact_id
1912: ,p_old_header_rec.end_customer_contact_id) OR
1913: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1914: ,p_old_header_rec.end_customer_id)
1915: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1916: THEN
1917:
1918: BEGIN
1919:

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

1956: END IF; -- End Customer contact needed validation.
1957:
1958:
1959: IF p_header_rec.end_customer_site_use_id IS NOT NULL AND
1960: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
1961: ,p_old_header_rec.end_customer_id) OR
1962: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1963: ,p_old_header_rec.end_customer_id)
1964: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 1962: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id

1958:
1959: IF p_header_rec.end_customer_site_use_id IS NOT NULL AND
1960: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
1961: ,p_old_header_rec.end_customer_id) OR
1962: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1963: ,p_old_header_rec.end_customer_id)
1964: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1965: THEN
1966:

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

1960: ( NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id
1961: ,p_old_header_rec.end_customer_id) OR
1962: NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id
1963: ,p_old_header_rec.end_customer_id)
1964: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
1965: THEN
1966:
1967: BEGIN
1968:

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

2005:
2006: -- Sold to contact depends on Sold To Org
2007:
2008: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
2009: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2010: ,p_old_header_rec.sold_to_contact_id) OR
2011: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2012: ,p_old_header_rec.sold_to_org_id)
2013: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2011: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

2007:
2008: IF p_header_rec.sold_to_contact_id IS NOT NULL AND
2009: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2010: ,p_old_header_rec.sold_to_contact_id) OR
2011: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2012: ,p_old_header_rec.sold_to_org_id)
2013: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2014: THEN
2015:

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

2009: ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id
2010: ,p_old_header_rec.sold_to_contact_id) OR
2011: NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2012: ,p_old_header_rec.sold_to_org_id)
2013: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2014: THEN
2015:
2016: BEGIN
2017:

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

2056:
2057: -- Invoice to contact depends on Invoice To Org
2058:
2059: IF p_header_rec.invoice_to_contact_id IS NOT NULL AND
2060: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2061: ,p_old_header_rec.invoice_to_contact_id) OR
2062: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2063: ,p_old_header_rec.invoice_to_org_id)
2064: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2062: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

2058:
2059: IF p_header_rec.invoice_to_contact_id IS NOT NULL AND
2060: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2061: ,p_old_header_rec.invoice_to_contact_id) OR
2062: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2063: ,p_old_header_rec.invoice_to_org_id)
2064: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2065: THEN
2066: BEGIN

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

2060: ( NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id
2061: ,p_old_header_rec.invoice_to_contact_id) OR
2062: NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2063: ,p_old_header_rec.invoice_to_org_id)
2064: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2065: THEN
2066: BEGIN
2067: oe_debug_pub.add
2068: ('inv_to_contact :'||to_char(p_header_rec.invoice_to_contact_id),2);

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

2116:
2117: -- Ship to contact depends on Ship To Org
2118:
2119: IF p_header_rec.ship_to_contact_id IS NOT NULL AND
2120: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2121: ,p_old_header_rec.ship_to_contact_id) OR
2122: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2123: ,p_old_header_rec.ship_to_org_id)
2124: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2122: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

2118:
2119: IF p_header_rec.ship_to_contact_id IS NOT NULL AND
2120: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2121: ,p_old_header_rec.ship_to_contact_id) OR
2122: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2123: ,p_old_header_rec.ship_to_org_id)
2124: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2125: THEN
2126:

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

2120: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id
2121: ,p_old_header_rec.ship_to_contact_id) OR
2122: NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2123: ,p_old_header_rec.ship_to_org_id)
2124: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2125: THEN
2126:
2127: BEGIN
2128:

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

2176:
2177: -- Deliver to contact depends on Deliver To Org
2178:
2179: IF p_header_rec.deliver_to_contact_id IS NOT NULL AND
2180: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2181: ,p_old_header_rec.deliver_to_contact_id) OR
2182: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2183: ,p_old_header_rec.deliver_to_org_id)
2184: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))

Line 2182: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id

2178:
2179: IF p_header_rec.deliver_to_contact_id IS NOT NULL AND
2180: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2181: ,p_old_header_rec.deliver_to_contact_id) OR
2182: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2183: ,p_old_header_rec.deliver_to_org_id)
2184: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2185: THEN
2186:

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

2180: ( NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id
2181: ,p_old_header_rec.deliver_to_contact_id) OR
2182: NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id
2183: ,p_old_header_rec.deliver_to_org_id)
2184: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE))
2185: THEN
2186:
2187: BEGIN
2188:

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

2238: -- flag is 'S' (StANDard).
2239:
2240:
2241: /* IF p_header_rec.tax_exempt_flag IS NOT NULL
2242: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2243: ,p_old_header_rec.tax_exempt_number)
2244: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2245: ,p_old_header_rec.tax_exempt_reason_code)
2246: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id

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

2240:
2241: /* IF p_header_rec.tax_exempt_flag IS NOT NULL
2242: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2243: ,p_old_header_rec.tax_exempt_number)
2244: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2245: ,p_old_header_rec.tax_exempt_reason_code)
2246: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2247: ,p_old_header_rec.ship_to_org_id)
2248: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id

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

2242: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number
2243: ,p_old_header_rec.tax_exempt_number)
2244: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2245: ,p_old_header_rec.tax_exempt_reason_code)
2246: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2247: ,p_old_header_rec.ship_to_org_id)
2248: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2249: ,p_old_header_rec.invoice_to_org_id)
2250: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id

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

2244: OR NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code
2245: ,p_old_header_rec.tax_exempt_reason_code)
2246: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2247: ,p_old_header_rec.ship_to_org_id)
2248: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2249: ,p_old_header_rec.invoice_to_org_id)
2250: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2251: ,p_old_header_rec.sold_to_org_id)
2252: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

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

2246: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id
2247: ,p_old_header_rec.ship_to_org_id)
2248: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id
2249: ,p_old_header_rec.invoice_to_org_id)
2250: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2251: ,p_old_header_rec.sold_to_org_id)
2252: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2253: )
2254: THEN

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

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

Line 2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2331:
2332: -- Bug 6118092 Redefault as it may be no more valid
2333: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2334: null;
2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2337: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2338: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;

Line 2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2332: -- Bug 6118092 Redefault as it may be no more valid
2333: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2334: null;
2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2337: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2338: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2340:

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

2371:
2372: -- Fix bug 1162304: issue a warning message if the PO number
2373: -- is being referenced by another order
2374: IF p_header_rec.cust_po_number IS NOT NULL
2375: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2376: ,p_old_header_rec.sold_to_org_id)
2377: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2378: ,p_old_header_rec.cust_po_number)
2379: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

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

2373: -- is being referenced by another order
2374: IF p_header_rec.cust_po_number IS NOT NULL
2375: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2376: ,p_old_header_rec.sold_to_org_id)
2377: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2378: ,p_old_header_rec.cust_po_number)
2379: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2380: )
2381: THEN

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

2375: AND ( NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2376: ,p_old_header_rec.sold_to_org_id)
2377: OR NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number
2378: ,p_old_header_rec.cust_po_number)
2379: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2380: )
2381: THEN
2382:
2383: IF OE_Validate_Header.Is_Duplicate_PO_Number

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

2400: ** Fix Bug # 3015881
2401: ** No need to validate here as this will be validated anyway
2402: ** when the sold to org id changes are cascaded to the line.
2403:
2404: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
2405: ,p_old_header_rec.sold_to_org_id)) THEN
2406:
2407: oe_debug_pub.add('OEXLHDRB: before validating customer for commitment.', 3);
2408: Validate_Commitment_Customer

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

2465: --Commenting the following for bug 3733877
2466: /*
2467: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
2468:
2469: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code
2470: ,p_old_header_rec.payment_type_code))
2471: or
2472: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2473: ,p_old_header_rec.credit_card_code))

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

2468:
2469: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code
2470: ,p_old_header_rec.payment_type_code))
2471: or
2472: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2473: ,p_old_header_rec.credit_card_code))
2474: or
2475: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2476: ,p_old_header_rec.credit_card_number))

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

2471: or
2472: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code
2473: ,p_old_header_rec.credit_card_code))
2474: or
2475: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2476: ,p_old_header_rec.credit_card_number))
2477: or
2478: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2479: ,p_old_header_rec.credit_card_holder_name))

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

2474: or
2475: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_number
2476: ,p_old_header_rec.credit_card_number))
2477: or
2478: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2479: ,p_old_header_rec.credit_card_holder_name))
2480: or
2481: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2482: ,p_old_header_rec.credit_card_expiration_date))

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

2477: or
2478: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name
2479: ,p_old_header_rec.credit_card_holder_name))
2480: or
2481: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2482: ,p_old_header_rec.credit_card_expiration_date))
2483: or
2484: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2485: ,p_old_header_rec.check_number))

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

2480: or
2481: (NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date
2482: ,p_old_header_rec.credit_card_expiration_date))
2483: or
2484: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2485: ,p_old_header_rec.check_number))
2486: or
2487: (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount
2488: ,p_old_header_rec.payment_amount))

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

2483: or
2484: (NOT OE_GLOBALS.EQUAL(p_header_rec.check_number
2485: ,p_old_header_rec.check_number))
2486: or
2487: (NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount
2488: ,p_old_header_rec.payment_amount))
2489:
2490: THEN
2491:

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

2502: oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
2503:
2504: end if;
2505:
2506: END IF; -- if not oe_globals.equal...
2507:
2508: END IF; -- if multiple_payments is enabled
2509: */
2510: --distributed orders @

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

2509: */
2510: --distributed orders @
2511: oe_debug_pub.ADD('ib_owner: '||p_header_rec.ib_owner);
2512: IF p_header_rec.ib_owner IS NOT NULL AND
2513: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2514: OR p_old_header_rec.ib_owner is null
2515: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2516: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2517: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

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

2511: oe_debug_pub.ADD('ib_owner: '||p_header_rec.ib_owner);
2512: IF p_header_rec.ib_owner IS NOT NULL AND
2513: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2514: OR p_old_header_rec.ib_owner is null
2515: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2516: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2517: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2518: THEN
2519: IF (p_header_rec.ib_owner = 'SOLD_TO' AND

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

2512: IF p_header_rec.ib_owner IS NOT NULL AND
2513: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2514: OR p_old_header_rec.ib_owner is null
2515: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2516: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2517: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2518: THEN
2519: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2520: p_header_rec.sold_to_org_id is null)

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

2513: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_owner ,p_old_header_rec.ib_owner)
2514: OR p_old_header_rec.ib_owner is null
2515: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
2516: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_id, p_old_header_rec.end_customer_id)
2517: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2518: THEN
2519: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2520: p_header_rec.sold_to_org_id is null)
2521: THEN

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

2534: END IF;
2535: oe_debug_pub.ADD('ib_installed_at_location: '||p_header_rec.ib_installed_at_location);
2536:
2537: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2538: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2539: OR p_old_header_rec.ib_installed_at_location is null
2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)

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

2536:
2537: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2538: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2539: OR p_old_header_rec.ib_installed_at_location is null
2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

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

2537: IF p_header_rec.ib_installed_at_location IS NOT NULL AND
2538: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2539: OR p_old_header_rec.ib_installed_at_location is null
2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2545: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)

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

2538: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_installed_at_location ,p_old_header_rec.ib_installed_at_location)
2539: OR p_old_header_rec.ib_installed_at_location is null
2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2545: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2546: THEN

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

2539: OR p_old_header_rec.ib_installed_at_location is null
2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2545: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2546: THEN
2547: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND

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

2540: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2545: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2546: THEN
2547: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2548: p_header_rec.invoice_to_org_id is null)

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

2541: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2542: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2543: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2544: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2545: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2546: THEN
2547: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2548: p_header_rec.invoice_to_org_id is null)
2549: THEN

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

2583: END IF;
2584: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);
2585:
2586: IF p_header_rec.ib_current_location IS NOT NULL AND
2587: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)

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

2584: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);
2585:
2586: IF p_header_rec.ib_current_location IS NOT NULL AND
2587: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)

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

2585:
2586: IF p_header_rec.ib_current_location IS NOT NULL AND
2587: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2593: OR p_old_header_rec.ib_current_location is null

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

2586: IF p_header_rec.ib_current_location IS NOT NULL AND
2587: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2593: OR p_old_header_rec.ib_current_location is null
2594: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )

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

2587: ( NOT OE_GLOBALS.EQUAL(p_header_rec.ib_current_location ,p_old_header_rec.ib_current_location)
2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2593: OR p_old_header_rec.ib_current_location is null
2594: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2595: THEN

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

2588: OR NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id ,p_old_header_rec.invoice_to_org_id)
2589: OR NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id ,p_old_header_rec.ship_to_org_id)
2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2593: OR p_old_header_rec.ib_current_location is null
2594: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2595: THEN
2596: IF (p_header_rec.ib_current_location = 'BILL_TO' AND

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

2590: OR NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id ,p_old_header_rec.deliver_to_org_id)
2591: OR NOT OE_GLOBALS.EQUAL(p_header_rec.end_customer_site_use_id ,p_old_header_rec.end_customer_site_use_id)
2592: OR NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id ,p_old_header_rec.sold_to_site_use_id)
2593: OR p_old_header_rec.ib_current_location is null
2594: OR p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE )
2595: THEN
2596: IF (p_header_rec.ib_current_location = 'BILL_TO' AND
2597: p_header_rec.invoice_to_org_id is null)
2598: THEN

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

2753: old rec and new rec may have the same values. To make sure that
2754: validation is done for the attributes during CREATE added an
2755: additional check of
2756: OR
2757: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2758: in all the conditions.
2759: */
2760:
2761: IF p_x_header_rec.accounting_rule_id IS NOT NULL AND

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

2761: IF p_x_header_rec.accounting_rule_id IS NOT NULL AND
2762: ( ( p_x_header_rec.accounting_rule_id <>
2763: p_old_header_rec.accounting_rule_id OR
2764: p_old_header_rec.accounting_rule_id IS NULL ) OR
2765: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2766: --bug 5060064
2767: THEN
2768:
2769: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)

Line 2772: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2768:
2769: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2770: THEN
2771:
2772: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2774: THEN
2775: p_x_header_rec.accounting_rule_id := NULL;
2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2769: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2770: THEN
2771:
2772: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2774: THEN
2775: p_x_header_rec.accounting_rule_id := NULL;
2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2772: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2774: THEN
2775: p_x_header_rec.accounting_rule_id := NULL;
2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2778: THEN
2779: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE

Line 2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2774: THEN
2775: p_x_header_rec.accounting_rule_id := NULL;
2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2778: THEN
2779: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE
2781: x_return_status := FND_API.G_RET_STS_ERROR;

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

2788: IF p_x_header_rec.accounting_rule_duration IS NOT NULL AND
2789: ( (p_x_header_rec.accounting_rule_duration <>
2790: p_old_header_rec.accounting_rule_duration OR
2791: p_old_header_rec.accounting_rule_duration IS NULL ) OR
2792: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2793: --bug 5060064
2794: THEN
2795:
2796: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)

Line 2799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2795:
2796: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2797: THEN
2798:
2799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2801: THEN
2802: p_x_header_rec.accounting_rule_duration := NULL;
2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2796: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2797: THEN
2798:
2799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2801: THEN
2802: p_x_header_rec.accounting_rule_duration := NULL;
2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2801: THEN
2802: p_x_header_rec.accounting_rule_duration := NULL;
2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2805: THEN
2806: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2807: ELSE

Line 2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2801: THEN
2802: p_x_header_rec.accounting_rule_duration := NULL;
2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2805: THEN
2806: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2807: ELSE
2808: x_return_status := FND_API.G_RET_STS_ERROR;

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

2815: IF p_x_header_rec.agreement_id IS NOT NULL AND
2816: ( ( p_x_header_rec.agreement_id <>
2817: p_old_header_rec.agreement_id OR
2818: p_old_header_rec.agreement_id IS NULL ) OR
2819: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2820: --bug 5060064
2821: THEN
2822:
2823: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)

Line 2825: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2821: THEN
2822:
2823: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2824: THEN
2825: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2827: THEN
2828: p_x_header_rec.agreement_id := NULL;
2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2822:
2823: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2824: THEN
2825: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2827: THEN
2828: p_x_header_rec.agreement_id := NULL;
2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2825: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2827: THEN
2828: p_x_header_rec.agreement_id := NULL;
2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2831: THEN
2832: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2833: ELSE

Line 2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2827: THEN
2828: p_x_header_rec.agreement_id := NULL;
2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2831: THEN
2832: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2833: ELSE
2834: x_return_status := FND_API.G_RET_STS_ERROR;

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

2843: IF p_x_header_rec.booked_flag IS NOT NULL AND
2844: ( ( p_x_header_rec.booked_flag <>
2845: p_old_header_rec.booked_flag OR
2846: p_old_header_rec.booked_flag IS NULL ) OR
2847: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2848: --bug 5060064
2849: THEN
2850: oe_debug_pub.add('sarita:before validate booked flag');
2851:

Line 2854: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2850: oe_debug_pub.add('sarita:before validate booked flag');
2851:
2852: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2853: THEN
2854: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2856: THEN
2857: p_x_header_rec.booked_flag := NULL;
2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2851:
2852: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2853: THEN
2854: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2856: THEN
2857: p_x_header_rec.booked_flag := NULL;
2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2854: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2856: THEN
2857: p_x_header_rec.booked_flag := NULL;
2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2860: THEN
2861: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2862: ELSE

Line 2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2856: THEN
2857: p_x_header_rec.booked_flag := NULL;
2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2860: THEN
2861: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2862: ELSE
2863: x_return_status := FND_API.G_RET_STS_ERROR;

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

2869: IF p_x_header_rec.cancelled_flag IS NOT NULL AND
2870: ( (p_x_header_rec.cancelled_flag <>
2871: p_old_header_rec.cancelled_flag OR
2872: p_old_header_rec.cancelled_flag IS NULL ) OR
2873: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2874: --bug 5060064
2875: THEN
2876:
2877: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)

Line 2879: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2875: THEN
2876:
2877: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2878: THEN
2879: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2881: THEN
2882: p_x_header_rec.cancelled_flag := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2876:
2877: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2878: THEN
2879: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2881: THEN
2882: p_x_header_rec.cancelled_flag := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2879: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2881: THEN
2882: p_x_header_rec.cancelled_flag := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2885: THEN
2886: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2887: ELSE

Line 2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2881: THEN
2882: p_x_header_rec.cancelled_flag := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2885: THEN
2886: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2887: ELSE
2888: x_return_status := FND_API.G_RET_STS_ERROR;

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

2894: IF p_x_header_rec.conversion_type_code IS NOT NULL AND
2895: ( (p_x_header_rec.conversion_type_code <>
2896: p_old_header_rec.conversion_type_code OR
2897: p_old_header_rec.conversion_type_code IS NULL ) OR
2898: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2899: --bug 5060064
2900: THEN
2901:
2902: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)

Line 2904: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2900: THEN
2901:
2902: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2903: THEN
2904: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2906: THEN
2907: p_x_header_rec.conversion_type_code := NULL;
2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2901:
2902: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2903: THEN
2904: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2906: THEN
2907: p_x_header_rec.conversion_type_code := NULL;
2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2904: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2906: THEN
2907: p_x_header_rec.conversion_type_code := NULL;
2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2910: THEN
2911: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2912: ELSE

Line 2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2906: THEN
2907: p_x_header_rec.conversion_type_code := NULL;
2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2910: THEN
2911: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2912: ELSE
2913: x_return_status := FND_API.G_RET_STS_ERROR;

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

2919: IF p_x_header_rec.deliver_to_contact_id IS NOT NULL AND
2920: ( (p_x_header_rec.deliver_to_contact_id <>
2921: p_old_header_rec.deliver_to_contact_id OR
2922: p_old_header_rec.deliver_to_contact_id IS NULL ) OR
2923: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2924: --bug 5060064
2925: THEN
2926:
2927: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN

Line 2928: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2924: --bug 5060064
2925: THEN
2926:
2927: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2928: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2925: THEN
2926:
2927: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2928: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2928: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2934: THEN
2935: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2936: ELSE

Line 2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2934: THEN
2935: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2936: ELSE
2937: x_return_status := FND_API.G_RET_STS_ERROR;

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

2943: IF p_x_header_rec.deliver_to_org_id IS NOT NULL AND
2944: ( ( p_x_header_rec.deliver_to_org_id <>
2945: p_old_header_rec.deliver_to_org_id OR
2946: p_old_header_rec.deliver_to_org_id IS NULL ) OR
2947: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2948: --bug 5060064
2949: THEN
2950:
2951: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)

Line 2953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2949: THEN
2950:
2951: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
2952: THEN
2953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.deliver_to_org_id := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2950:
2951: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
2952: THEN
2953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.deliver_to_org_id := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.deliver_to_org_id := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2959: THEN
2960: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2961: ELSE

Line 2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.deliver_to_org_id := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2959: THEN
2960: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2961: ELSE
2962: x_return_status := FND_API.G_RET_STS_ERROR;

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

2968: IF p_x_header_rec.demAND_class_code IS NOT NULL AND
2969: ( (p_x_header_rec.demAND_class_code <>
2970: p_old_header_rec.demAND_class_code OR
2971: p_old_header_rec.demAND_class_code IS NULL ) OR
2972: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2973: --bug 5060064
2974: THEN
2975:
2976: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)

Line 2978: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2974: THEN
2975:
2976: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
2977: THEN
2978: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.demAND_class_code := NULL;
2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2975:
2976: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
2977: THEN
2978: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.demAND_class_code := NULL;
2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

2978: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.demAND_class_code := NULL;
2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2984: THEN
2985: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
2986: ELSE

Line 2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.demAND_class_code := NULL;
2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2984: THEN
2985: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
2986: ELSE
2987: x_return_status := FND_API.G_RET_STS_ERROR;

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

2993: IF p_x_header_rec.fob_point_code IS NOT NULL AND
2994: ( ( p_x_header_rec.fob_point_code <>
2995: p_old_header_rec.fob_point_code OR
2996: p_old_header_rec.fob_point_code IS NULL ) OR
2997: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2998: --bug 5060064
2999: THEN
3000:
3001: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)

Line 3003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

2999: THEN
3000:
3001: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3002: THEN
3003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3005: THEN
3006: p_x_header_rec.fob_point_code := NULL;
3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3000:
3001: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3002: THEN
3003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3005: THEN
3006: p_x_header_rec.fob_point_code := NULL;
3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3005: THEN
3006: p_x_header_rec.fob_point_code := NULL;
3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3009: THEN
3010: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3011: ELSE

Line 3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3005: THEN
3006: p_x_header_rec.fob_point_code := NULL;
3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3009: THEN
3010: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3011: ELSE
3012: x_return_status := FND_API.G_RET_STS_ERROR;

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

3018: IF p_x_header_rec.freight_terms_code IS NOT NULL AND
3019: ( (p_x_header_rec.freight_terms_code <>
3020: p_old_header_rec.freight_terms_code OR
3021: p_old_header_rec.freight_terms_code IS NULL ) OR
3022: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3023: --bug 5060064
3024: THEN
3025:
3026: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)

Line 3028: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3024: THEN
3025:
3026: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3027: THEN
3028: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3030: THEN
3031: p_x_header_rec.freight_terms_code := NULL;
3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3025:
3026: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3027: THEN
3028: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3030: THEN
3031: p_x_header_rec.freight_terms_code := NULL;
3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3028: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3030: THEN
3031: p_x_header_rec.freight_terms_code := NULL;
3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3034: THEN
3035: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3036: ELSE

Line 3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3030: THEN
3031: p_x_header_rec.freight_terms_code := NULL;
3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3034: THEN
3035: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3036: ELSE
3037: x_return_status := FND_API.G_RET_STS_ERROR;

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

3043: IF p_x_header_rec.invoice_to_contact_id IS NOT NULL AND
3044: ( (p_x_header_rec.invoice_to_contact_id <>
3045: p_old_header_rec.invoice_to_contact_id OR
3046: p_old_header_rec.invoice_to_contact_id IS NULL ) OR
3047: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3048: --bug 5060064
3049: THEN
3050:
3051: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN

Line 3052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3048: --bug 5060064
3049: THEN
3050:
3051: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3049: THEN
3050:
3051: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3058: THEN
3059: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3060: ELSE

Line 3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3058: THEN
3059: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3060: ELSE
3061: x_return_status := FND_API.G_RET_STS_ERROR;

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

3067: IF p_x_header_rec.invoice_to_org_id IS NOT NULL AND
3068: ( (p_x_header_rec.invoice_to_org_id <>
3069: p_old_header_rec.invoice_to_org_id OR
3070: p_old_header_rec.invoice_to_org_id IS NULL ) OR
3071: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3072: --bug 5060064
3073: THEN
3074:
3075: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)

Line 3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3073: THEN
3074:
3075: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3076: THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.invoice_to_org_id := NULL;
3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3074:
3075: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3076: THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.invoice_to_org_id := NULL;
3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.invoice_to_org_id := NULL;
3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3083: THEN
3084: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3085: ELSE

Line 3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.invoice_to_org_id := NULL;
3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3083: THEN
3084: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3085: ELSE
3086: x_return_status := FND_API.G_RET_STS_ERROR;

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

3092: IF p_x_header_rec.invoicing_rule_id IS NOT NULL AND
3093: ( ( p_x_header_rec.invoicing_rule_id <>
3094: p_old_header_rec.invoicing_rule_id OR
3095: p_old_header_rec.invoicing_rule_id IS NULL ) OR
3096: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3097: --bug 5060064
3098: THEN
3099:
3100: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)

Line 3102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3098: THEN
3099:
3100: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3101: THEN
3102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.invoicing_rule_id := NULL;
3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3099:
3100: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3101: THEN
3102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.invoicing_rule_id := NULL;
3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.invoicing_rule_id := NULL;
3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3108: THEN
3109: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3110: ELSE

Line 3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.invoicing_rule_id := NULL;
3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3108: THEN
3109: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3110: ELSE
3111: x_return_status := FND_API.G_RET_STS_ERROR;

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

3117: IF p_x_header_rec.open_flag IS NOT NULL AND
3118: ( (p_x_header_rec.open_flag <>
3119: p_old_header_rec.open_flag OR
3120: p_old_header_rec.open_flag IS NULL ) OR
3121: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3122: --bug 5060064
3123: THEN
3124:
3125: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)

Line 3127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3123: THEN
3124:
3125: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3126: THEN
3127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3129: THEN
3130: p_x_header_rec.open_flag := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3124:
3125: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3126: THEN
3127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3129: THEN
3130: p_x_header_rec.open_flag := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3129: THEN
3130: p_x_header_rec.open_flag := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3133: THEN
3134: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3135: ELSE

Line 3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3129: THEN
3130: p_x_header_rec.open_flag := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3133: THEN
3134: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3135: ELSE
3136: x_return_status := FND_API.G_RET_STS_ERROR;

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

3142: IF p_x_header_rec.order_date_type_code IS NOT NULL AND
3143: ( (p_x_header_rec.order_date_type_code <>
3144: p_old_header_rec.order_date_type_code OR
3145: p_old_header_rec.order_date_type_code IS NULL ) OR
3146: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3147: --bug 5060064
3148: THEN
3149:
3150: IF NOT OE_Validate.Order_Date_Type_Code

Line 3153: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3149:
3150: IF NOT OE_Validate.Order_Date_Type_Code
3151: (p_x_header_rec.order_date_type_code)
3152: THEN
3153: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3155: THEN
3156: p_x_header_rec.order_date_type_code := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3150: IF NOT OE_Validate.Order_Date_Type_Code
3151: (p_x_header_rec.order_date_type_code)
3152: THEN
3153: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3155: THEN
3156: p_x_header_rec.order_date_type_code := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3153: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3155: THEN
3156: p_x_header_rec.order_date_type_code := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3159: THEN
3160: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3161: ELSE

Line 3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3155: THEN
3156: p_x_header_rec.order_date_type_code := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3159: THEN
3160: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3161: ELSE
3162: x_return_status := FND_API.G_RET_STS_ERROR;

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

3173: IF p_x_header_rec.order_type_id IS NOT NULL AND
3174: ( (p_x_header_rec.order_type_id <>
3175: p_old_header_rec.order_type_id OR
3176: p_old_header_rec.order_type_id IS NULL ) OR
3177: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3178: --bug 5060064
3179: THEN
3180: oe_debug_pub.add('Before OE_Validate.Order_Type');
3181:

Line 3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3180: oe_debug_pub.add('Before OE_Validate.Order_Type');
3181:
3182: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3183: THEN
3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3186: THEN
3187: p_x_header_rec.order_type_id := NULL;
3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3181:
3182: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3183: THEN
3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3186: THEN
3187: p_x_header_rec.order_type_id := NULL;
3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3186: THEN
3187: p_x_header_rec.order_type_id := NULL;
3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3190: THEN
3191: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3192: ELSE

Line 3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3186: THEN
3187: p_x_header_rec.order_type_id := NULL;
3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3190: THEN
3191: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3192: ELSE
3193: x_return_status := FND_API.G_RET_STS_ERROR;

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

3199: IF p_x_header_rec.payment_term_id IS NOT NULL AND
3200: ( (p_x_header_rec.payment_term_id <>
3201: p_old_header_rec.payment_term_id OR
3202: p_old_header_rec.payment_term_id IS NULL ) OR
3203: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3204: --bug 5060064
3205: THEN
3206:
3207: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)

Line 3209: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3205: THEN
3206:
3207: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3208: THEN
3209: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3211: THEN
3212: p_x_header_rec.payment_term_id := NULL;
3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3206:
3207: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3208: THEN
3209: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3211: THEN
3212: p_x_header_rec.payment_term_id := NULL;
3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3209: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3211: THEN
3212: p_x_header_rec.payment_term_id := NULL;
3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3215: THEN
3216: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3217: ELSE

Line 3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3211: THEN
3212: p_x_header_rec.payment_term_id := NULL;
3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3215: THEN
3216: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3217: ELSE
3218: x_return_status := FND_API.G_RET_STS_ERROR;

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

3224: IF p_x_header_rec.price_list_id IS NOT NULL AND
3225: ( (p_x_header_rec.price_list_id <>
3226: p_old_header_rec.price_list_id OR
3227: p_old_header_rec.price_list_id IS NULL ) OR
3228: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3229: --bug 5060064
3230: THEN
3231:
3232: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)

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

3233: THEN
3234: -- Bug 3572931 Commented the code below.
3235: -- p_x_header_rec.price_list_id := NULL;
3236: -- ELSE
3237: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3238: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3239: -- THEN
3240: -- x_return_status := FND_API.G_RET_STS_ERROR;
3241: -- END IF;

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

3234: -- Bug 3572931 Commented the code below.
3235: -- p_x_header_rec.price_list_id := NULL;
3236: -- ELSE
3237: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3238: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3239: -- THEN
3240: -- x_return_status := FND_API.G_RET_STS_ERROR;
3241: -- END IF;
3242: -- Bug 3572931 if the validation level is partial set to NULL,

Line 3244: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3240: -- x_return_status := FND_API.G_RET_STS_ERROR;
3241: -- END IF;
3242: -- Bug 3572931 if the validation level is partial set to NULL,
3243: -- if partial with defaulting set to G_MISS_NUM.
3244: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3245: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3246: THEN
3247: p_x_header_rec.price_list_id := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3245: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3241: -- END IF;
3242: -- Bug 3572931 if the validation level is partial set to NULL,
3243: -- if partial with defaulting set to G_MISS_NUM.
3244: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3245: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3246: THEN
3247: p_x_header_rec.price_list_id := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3244: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3245: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3246: THEN
3247: p_x_header_rec.price_list_id := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3250: THEN
3251: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3252: ELSE

Line 3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3245: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3246: THEN
3247: p_x_header_rec.price_list_id := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3250: THEN
3251: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3252: ELSE
3253: x_return_status := FND_API.G_RET_STS_ERROR;

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

3259: IF p_x_header_rec.shipment_priority_code IS NOT NULL AND
3260: ( (p_x_header_rec.shipment_priority_code <>
3261: p_old_header_rec.shipment_priority_code OR
3262: p_old_header_rec.shipment_priority_code IS NULL ) OR
3263: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3264: --bug 5060064
3265: THEN
3266:
3267: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN

Line 3268: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3264: --bug 5060064
3265: THEN
3266:
3267: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3268: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3270: THEN
3271: p_x_header_rec.shipment_priority_code := NULL;
3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3265: THEN
3266:
3267: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3268: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3270: THEN
3271: p_x_header_rec.shipment_priority_code := NULL;
3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3268: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3270: THEN
3271: p_x_header_rec.shipment_priority_code := NULL;
3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3274: THEN
3275: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3276: ELSE

Line 3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3270: THEN
3271: p_x_header_rec.shipment_priority_code := NULL;
3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3274: THEN
3275: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;

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

3283: IF p_x_header_rec.shipping_method_code IS NOT NULL AND
3284: ( (p_x_header_rec.shipping_method_code <>
3285: p_old_header_rec.shipping_method_code OR
3286: p_old_header_rec.shipping_method_code IS NULL ) OR
3287: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3288: --bug 5060064
3289: THEN
3290:
3291: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)

Line 3293: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3289: THEN
3290:
3291: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3292: THEN
3293: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3295: THEN
3296: p_x_header_rec.shipping_method_code := NULL;
3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3290:
3291: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3292: THEN
3293: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3295: THEN
3296: p_x_header_rec.shipping_method_code := NULL;
3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3293: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3295: THEN
3296: p_x_header_rec.shipping_method_code := NULL;
3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3299: THEN
3300: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3301: ELSE

Line 3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3295: THEN
3296: p_x_header_rec.shipping_method_code := NULL;
3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3299: THEN
3300: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3301: ELSE
3302: x_return_status := FND_API.G_RET_STS_ERROR;

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

3308: IF p_x_header_rec.ship_from_org_id IS NOT NULL AND
3309: ( (p_x_header_rec.ship_from_org_id <>
3310: p_old_header_rec.ship_from_org_id OR
3311: p_old_header_rec.ship_from_org_id IS NULL ) OR
3312: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3313: --bug 5060064
3314: THEN
3315:
3316: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)

Line 3318: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3314: THEN
3315:
3316: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3317: THEN
3318: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.ship_from_org_id := NULL;
3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3315:
3316: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3317: THEN
3318: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.ship_from_org_id := NULL;
3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3318: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.ship_from_org_id := NULL;
3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3324: THEN
3325: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3326: ELSE

Line 3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.ship_from_org_id := NULL;
3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3324: THEN
3325: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3326: ELSE
3327: x_return_status := FND_API.G_RET_STS_ERROR;

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

3333: IF p_x_header_rec.ship_to_contact_id IS NOT NULL AND
3334: ( (p_x_header_rec.ship_to_contact_id <>
3335: p_old_header_rec.ship_to_contact_id OR
3336: p_old_header_rec.ship_to_contact_id IS NULL ) OR
3337: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3338: --bug 5060064
3339: THEN
3340:
3341: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)

Line 3343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3339: THEN
3340:
3341: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3342: THEN
3343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3345: THEN
3346: p_x_header_rec.ship_to_contact_id := NULL;
3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3340:
3341: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3342: THEN
3343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3345: THEN
3346: p_x_header_rec.ship_to_contact_id := NULL;
3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3345: THEN
3346: p_x_header_rec.ship_to_contact_id := NULL;
3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3349: THEN
3350: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3351: ELSE

Line 3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3345: THEN
3346: p_x_header_rec.ship_to_contact_id := NULL;
3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3349: THEN
3350: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3351: ELSE
3352: x_return_status := FND_API.G_RET_STS_ERROR;

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

3358: IF p_x_header_rec.ship_to_org_id IS NOT NULL AND
3359: ( (p_x_header_rec.ship_to_org_id <>
3360: p_old_header_rec.ship_to_org_id OR
3361: p_old_header_rec.ship_to_org_id IS NULL ) OR
3362: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3363: --bug 5060064
3364: THEN
3365:
3366: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)

Line 3368: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3364: THEN
3365:
3366: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3367: THEN
3368: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3370: THEN
3371: p_x_header_rec.ship_to_org_id := NULL;
3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3365:
3366: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3367: THEN
3368: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3370: THEN
3371: p_x_header_rec.ship_to_org_id := NULL;
3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3368: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3370: THEN
3371: p_x_header_rec.ship_to_org_id := NULL;
3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3374: THEN
3375: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3376: ELSE

Line 3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3370: THEN
3371: p_x_header_rec.ship_to_org_id := NULL;
3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3374: THEN
3375: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3376: ELSE
3377: x_return_status := FND_API.G_RET_STS_ERROR;

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

3384: IF p_x_header_rec.sold_to_contact_id IS NOT NULL AND
3385: ( (p_x_header_rec.sold_to_contact_id <>
3386: p_old_header_rec.sold_to_contact_id OR
3387: p_old_header_rec.sold_to_contact_id IS NULL ) OR
3388: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3389: --bug 5060064
3390: THEN
3391:
3392: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)

Line 3394: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3390: THEN
3391:
3392: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3393: THEN
3394: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3396: THEN
3397: p_x_header_rec.sold_to_contact_id := NULL;
3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3391:
3392: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3393: THEN
3394: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3396: THEN
3397: p_x_header_rec.sold_to_contact_id := NULL;
3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3394: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3396: THEN
3397: p_x_header_rec.sold_to_contact_id := NULL;
3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3400: THEN
3401: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3402: ELSE

Line 3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3396: THEN
3397: p_x_header_rec.sold_to_contact_id := NULL;
3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3400: THEN
3401: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3402: ELSE
3403: x_return_status := FND_API.G_RET_STS_ERROR;

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

3409: IF p_x_header_rec.sold_to_org_id IS NOT NULL AND
3410: ( (p_x_header_rec.sold_to_org_id <>
3411: p_old_header_rec.sold_to_org_id OR
3412: p_old_header_rec.sold_to_org_id IS NULL ) OR
3413: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3414: --bug 5060064
3415: THEN
3416:
3417: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)

Line 3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3415: THEN
3416:
3417: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3418: THEN
3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3421: THEN
3422: p_x_header_rec.sold_to_org_id := NULL;
3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3416:
3417: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3418: THEN
3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3421: THEN
3422: p_x_header_rec.sold_to_org_id := NULL;
3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3421: THEN
3422: p_x_header_rec.sold_to_org_id := NULL;
3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3425: THEN
3426: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3427: ELSE

Line 3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3421: THEN
3422: p_x_header_rec.sold_to_org_id := NULL;
3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3425: THEN
3426: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3427: ELSE
3428: x_return_status := FND_API.G_RET_STS_ERROR;

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

3434: IF p_x_header_rec.sold_to_phone_id IS NOT NULL AND
3435: ( (p_x_header_rec.sold_to_phone_id <>
3436: p_old_header_rec.sold_to_phone_id OR
3437: p_old_header_rec.sold_to_phone_id IS NULL ) OR
3438: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3439: --bug 5060064
3440: THEN
3441:
3442: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)

Line 3444: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3440: THEN
3441:
3442: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3443: THEN
3444: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3446: THEN
3447: p_x_header_rec.sold_to_phone_id := NULL;
3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3441:
3442: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3443: THEN
3444: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3446: THEN
3447: p_x_header_rec.sold_to_phone_id := NULL;
3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3444: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3446: THEN
3447: p_x_header_rec.sold_to_phone_id := NULL;
3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3450: THEN
3451: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3452: ELSE

Line 3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3446: THEN
3447: p_x_header_rec.sold_to_phone_id := NULL;
3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3450: THEN
3451: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3452: ELSE
3453: x_return_status := FND_API.G_RET_STS_ERROR;

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

3459: IF p_x_header_rec.source_document_type_id IS NOT NULL AND
3460: ( (p_x_header_rec.source_document_type_id <>
3461: p_old_header_rec.source_document_type_id OR
3462: p_old_header_rec.source_document_type_id IS NULL ) OR
3463: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3464: --bug 5060064
3465: THEN
3466:
3467: IF NOT OE_Validate.Source_Document_Type

Line 3470: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3466:
3467: IF NOT OE_Validate.Source_Document_Type
3468: (p_x_header_rec.source_document_type_id)
3469: THEN
3470: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3472: THEN
3473: p_x_header_rec.source_document_type_id := NULL;
3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3467: IF NOT OE_Validate.Source_Document_Type
3468: (p_x_header_rec.source_document_type_id)
3469: THEN
3470: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3472: THEN
3473: p_x_header_rec.source_document_type_id := NULL;
3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3470: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3472: THEN
3473: p_x_header_rec.source_document_type_id := NULL;
3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3476: THEN
3477: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3478: ELSE

Line 3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3472: THEN
3473: p_x_header_rec.source_document_type_id := NULL;
3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3476: THEN
3477: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3478: ELSE
3479: x_return_status := FND_API.G_RET_STS_ERROR;

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

3485: IF p_x_header_rec.tax_exempt_flag IS NOT NULL AND
3486: ( (p_x_header_rec.tax_exempt_flag <>
3487: p_old_header_rec.tax_exempt_flag OR
3488: p_old_header_rec.tax_exempt_flag IS NULL ) OR
3489: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3490: --bug 5060064
3491: THEN
3492: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3493: THEN

Line 3494: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3490: --bug 5060064
3491: THEN
3492: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3493: THEN
3494: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3496: THEN
3497: p_x_header_rec.tax_exempt_flag := NULL;
3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3491: THEN
3492: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3493: THEN
3494: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3496: THEN
3497: p_x_header_rec.tax_exempt_flag := NULL;
3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3494: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3496: THEN
3497: p_x_header_rec.tax_exempt_flag := NULL;
3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3500: THEN
3501: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3502: ELSE

Line 3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3496: THEN
3497: p_x_header_rec.tax_exempt_flag := NULL;
3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3500: THEN
3501: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3502: ELSE
3503: x_return_status := FND_API.G_RET_STS_ERROR;

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

3509: IF p_x_header_rec.tax_exempt_reason_code IS NOT NULL AND
3510: ( (p_x_header_rec.tax_exempt_reason_code <>
3511: p_old_header_rec.tax_exempt_reason_code OR
3512: p_old_header_rec.tax_exempt_reason_code IS NULL ) OR
3513: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3514: --bug 5060064
3515: THEN
3516:
3517: IF NOT OE_Validate.Tax_Exempt_Reason

Line 3520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3516:
3517: IF NOT OE_Validate.Tax_Exempt_Reason
3518: (p_x_header_rec.tax_exempt_reason_code)
3519: THEN
3520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3522: THEN
3523: p_x_header_rec.tax_exempt_reason_code := NULL;
3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3517: IF NOT OE_Validate.Tax_Exempt_Reason
3518: (p_x_header_rec.tax_exempt_reason_code)
3519: THEN
3520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3522: THEN
3523: p_x_header_rec.tax_exempt_reason_code := NULL;
3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3522: THEN
3523: p_x_header_rec.tax_exempt_reason_code := NULL;
3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3526: THEN
3527: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3528: ELSE

Line 3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3522: THEN
3523: p_x_header_rec.tax_exempt_reason_code := NULL;
3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3526: THEN
3527: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3528: ELSE
3529: x_return_status := FND_API.G_RET_STS_ERROR;

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

3535: IF p_x_header_rec.tax_point_code IS NOT NULL AND
3536: ( ( p_x_header_rec.tax_point_code <>
3537: p_old_header_rec.tax_point_code OR
3538: p_old_header_rec.tax_point_code IS NULL ) OR
3539: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3540: --bug 5060064
3541: THEN
3542:
3543: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)

Line 3545: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3541: THEN
3542:
3543: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3544: THEN
3545: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3547: THEN
3548: p_x_header_rec.tax_point_code := NULL;
3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3542:
3543: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3544: THEN
3545: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3547: THEN
3548: p_x_header_rec.tax_point_code := NULL;
3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3545: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3547: THEN
3548: p_x_header_rec.tax_point_code := NULL;
3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3551: THEN
3552: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3553: ELSE

Line 3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3547: THEN
3548: p_x_header_rec.tax_point_code := NULL;
3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3551: THEN
3552: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3553: ELSE
3554: x_return_status := FND_API.G_RET_STS_ERROR;

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

3560: IF p_x_header_rec.transactional_curr_code IS NOT NULL AND
3561: ( (p_x_header_rec.transactional_curr_code <>
3562: p_old_header_rec.transactional_curr_code OR
3563: p_old_header_rec.transactional_curr_code IS NULL ) OR
3564: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3565: --bug 5060064
3566: THEN
3567:
3568: IF NOT OE_Validate.Transactional_Curr

Line 3571: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3567:
3568: IF NOT OE_Validate.Transactional_Curr
3569: (p_x_header_rec.transactional_curr_code)
3570: THEN
3571: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3573: THEN
3574: p_x_header_rec.transactional_curr_code := NULL;
3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3568: IF NOT OE_Validate.Transactional_Curr
3569: (p_x_header_rec.transactional_curr_code)
3570: THEN
3571: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3573: THEN
3574: p_x_header_rec.transactional_curr_code := NULL;
3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3571: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3573: THEN
3574: p_x_header_rec.transactional_curr_code := NULL;
3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3577: THEN
3578: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3579: ELSE

Line 3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3573: THEN
3574: p_x_header_rec.transactional_curr_code := NULL;
3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3577: THEN
3578: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3579: ELSE
3580: x_return_status := FND_API.G_RET_STS_ERROR;

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

3586: IF p_x_header_rec.payment_type_code IS NOT NULL AND
3587: ( (p_x_header_rec.payment_type_code <>
3588: p_old_header_rec.payment_type_code OR
3589: p_old_header_rec.payment_type_code IS NULL ) OR
3590: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3591: --bug 5060064
3592: THEN
3593:
3594: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)

Line 3596: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3592: THEN
3593:
3594: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3595: THEN
3596: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3598: THEN
3599: p_x_header_rec.payment_type_code := NULL;
3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3593:
3594: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3595: THEN
3596: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3598: THEN
3599: p_x_header_rec.payment_type_code := NULL;
3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3596: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3598: THEN
3599: p_x_header_rec.payment_type_code := NULL;
3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3602: THEN
3603: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3604: ELSE

Line 3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3598: THEN
3599: p_x_header_rec.payment_type_code := NULL;
3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3602: THEN
3603: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3604: ELSE
3605: x_return_status := FND_API.G_RET_STS_ERROR;

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

3613: IF p_x_header_rec.credit_card_code IS NOT NULL AND
3614: ( ( p_x_header_rec.credit_card_code <>
3615: p_old_header_rec.credit_card_code OR
3616: p_old_header_rec.credit_card_code IS NULL ) OR
3617: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3618: --bug 5060064
3619: THEN
3620: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3621: THEN

Line 3622: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3618: --bug 5060064
3619: THEN
3620: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3621: THEN
3622: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3624: THEN
3625: p_x_header_rec.credit_card_code := NULL;
3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3619: THEN
3620: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3621: THEN
3622: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3624: THEN
3625: p_x_header_rec.credit_card_code := NULL;
3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3622: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3624: THEN
3625: p_x_header_rec.credit_card_code := NULL;
3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3628: THEN
3629: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3630: ELSE

Line 3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3624: THEN
3625: p_x_header_rec.credit_card_code := NULL;
3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3628: THEN
3629: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3630: ELSE
3631: x_return_status := FND_API.G_RET_STS_ERROR;

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

3654: IF p_x_header_rec.flow_status_code IS NOT NULL AND
3655: ( (p_x_header_rec.flow_status_code <>
3656: p_old_header_rec.flow_status_code OR
3657: p_old_header_rec.flow_status_code IS NULL ) OR
3658: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3659: --bug 5060064
3660: THEN
3661:
3662: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)

Line 3664: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3660: THEN
3661:
3662: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)
3663: THEN
3664: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3666: THEN
3667: p_x_header_rec.flow_status_code := NULL;
3668: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 3665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

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

Line 3668: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

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

Line 3669: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

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

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

3676:
3677: END IF;
3678:
3679: oe_Debug_pub.add('after flow_status_code');
3680: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3681: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3682: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3683:
3684: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

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

3678:
3679: oe_Debug_pub.add('after flow_status_code');
3680: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3681: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3682: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3683:
3684: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3685: (p_x_header_rec.attribute1 IS NOT NULL AND
3686: ( p_x_header_rec.attribute1 <>

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

3680: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3681: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3682: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3683:
3684: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3685: (p_x_header_rec.attribute1 IS NOT NULL AND
3686: ( p_x_header_rec.attribute1 <>
3687: p_old_header_rec.attribute1 OR
3688: p_old_header_rec.attribute1 IS NULL ))

Line 3811: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

3807: ,p_attribute19 => p_x_header_rec.attribute19
3808: ,p_attribute20 => p_x_header_rec.attribute20)
3809: THEN
3810:
3811: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3812: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3813: THEN
3814: p_x_header_rec.context := null;
3815: p_x_header_rec.attribute1 := null;

Line 3812: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3808: ,p_attribute20 => p_x_header_rec.attribute20)
3809: THEN
3810:
3811: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3812: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3813: THEN
3814: p_x_header_rec.context := null;
3815: p_x_header_rec.attribute1 := null;
3816: p_x_header_rec.attribute2 := null;

Line 3837: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

3833: p_x_header_rec.attribute19 := null;
3834: p_x_header_rec.attribute20 := null;
3835:
3836:
3837: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

3834: p_x_header_rec.attribute20 := null;
3835:
3836:
3837: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;

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

3975: END IF ; -- If flex enabled
3976: END IF;
3977:
3978: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);
3979: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
3980: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
3981: (p_x_header_rec.global_attribute1 IS NOT NULL AND
3982: ( p_x_header_rec.global_attribute1 <>
3983: p_old_header_rec.global_attribute1 OR

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

3976: END IF;
3977:
3978: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);
3979: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
3980: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
3981: (p_x_header_rec.global_attribute1 IS NOT NULL AND
3982: ( p_x_header_rec.global_attribute1 <>
3983: p_old_header_rec.global_attribute1 OR
3984: p_old_header_rec.global_attribute1 IS NULL ))

Line 4099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4095: ,p_attribute19 => p_x_header_rec.global_attribute19
4096: ,p_attribute20 => p_x_header_rec.global_attribute20)
4097: THEN
4098:
4099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4100: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4101: THEN
4102:
4103: p_x_header_rec.global_attribute_category := null;

Line 4100: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4096: ,p_attribute20 => p_x_header_rec.global_attribute20)
4097: THEN
4098:
4099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4100: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4101: THEN
4102:
4103: p_x_header_rec.global_attribute_category := null;
4104: p_x_header_rec.global_attribute1 := null;

Line 4124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4120: p_x_header_rec.global_attribute18 := null;
4121: p_x_header_rec.global_attribute19 := null;
4122: p_x_header_rec.global_attribute20 := null;
4123:
4124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4125: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4126: THEN
4127:
4128: p_x_header_rec.global_attribute_category

Line 4125: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4121: p_x_header_rec.global_attribute19 := null;
4122: p_x_header_rec.global_attribute20 := null;
4123:
4124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4125: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4126: THEN
4127:
4128: p_x_header_rec.global_attribute_category
4129: := FND_API.G_MISS_CHAR;

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

4264:
4265: -- Added the Trading Partner Flex Validation and also the changes for defaulting
4266: -- for bug 2511313
4267:
4268: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4269: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4270: (p_x_header_rec.tp_attribute1 IS NOT NULL AND
4271: ( p_x_header_rec.tp_attribute1 <>
4272: p_old_header_rec.tp_attribute1 OR

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

4265: -- Added the Trading Partner Flex Validation and also the changes for defaulting
4266: -- for bug 2511313
4267:
4268: IF p_x_header_rec.operation = oe_globals.g_opr_create OR
4269: ( p_x_header_rec.operation = oe_globals.g_opr_update AND
4270: (p_x_header_rec.tp_attribute1 IS NOT NULL AND
4271: ( p_x_header_rec.tp_attribute1 <>
4272: p_old_header_rec.tp_attribute1 OR
4273: p_old_header_rec.tp_attribute1 IS NULL ))

Line 4352: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4348: ,p_attribute13 => p_x_header_rec.tp_attribute13
4349: ,p_attribute14 => p_x_header_rec.tp_attribute14
4350: ,p_attribute15 => p_x_header_rec.tp_attribute15) THEN
4351:
4352: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4353: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4354:
4355:
4356: p_x_header_rec.tp_context := null;

Line 4353: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4349: ,p_attribute14 => p_x_header_rec.tp_attribute14
4350: ,p_attribute15 => p_x_header_rec.tp_attribute15) THEN
4351:
4352: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4353: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4354:
4355:
4356: p_x_header_rec.tp_context := null;
4357: p_x_header_rec.tp_attribute1 := null;

Line 4373: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4369: p_x_header_rec.tp_attribute13 := null;
4370: p_x_header_rec.tp_attribute14 := null;
4371: p_x_header_rec.tp_attribute15 := null;
4372:
4373: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;

Line 4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN

4370: p_x_header_rec.tp_attribute14 := null;
4371: p_x_header_rec.tp_attribute15 := null;
4372:
4373: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;

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

4489: IF p_x_header_rec.salesrep_id IS NOT NULL AND
4490: ( (p_x_header_rec.salesrep_id <>
4491: p_old_header_rec.salesrep_id OR
4492: p_old_header_rec.salesrep_id IS NULL ) OR
4493: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4494: --bug 5060064
4495: THEN
4496:
4497: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)

Line 4499: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4495: THEN
4496:
4497: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4498: THEN
4499: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4501: THEN
4502: p_x_header_rec.salesrep_id := NULL;
4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4496:
4497: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4498: THEN
4499: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4501: THEN
4502: p_x_header_rec.salesrep_id := NULL;
4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4499: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4501: THEN
4502: p_x_header_rec.salesrep_id := NULL;
4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4505: THEN
4506: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4507: ELSE

Line 4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4501: THEN
4502: p_x_header_rec.salesrep_id := NULL;
4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4505: THEN
4506: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4507: ELSE
4508: x_return_status := FND_API.G_RET_STS_ERROR;

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

4516: IF p_x_header_rec.sales_channel_code IS NOT NULL AND
4517: ( (p_x_header_rec.sales_channel_code <>
4518: p_old_header_rec.sales_channel_code OR
4519: p_old_header_rec.sales_channel_code IS NULL ) OR
4520: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4521: --bug 5060064
4522: THEN
4523:
4524: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)

Line 4526: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4522: THEN
4523:
4524: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4525: THEN
4526: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4528: THEN
4529: p_x_header_rec.sales_channel_code := NULL;
4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4523:
4524: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4525: THEN
4526: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4528: THEN
4529: p_x_header_rec.sales_channel_code := NULL;
4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4526: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4528: THEN
4529: p_x_header_rec.sales_channel_code := NULL;
4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4532: THEN
4533: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4534: ELSE

Line 4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4528: THEN
4529: p_x_header_rec.sales_channel_code := NULL;
4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4532: THEN
4533: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4534: ELSE
4535: x_return_status := FND_API.G_RET_STS_ERROR;

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

4543: IF p_x_header_rec.return_reason_code IS NOT NULL AND
4544: ( (p_x_header_rec.return_reason_code <>
4545: p_old_header_rec.return_reason_code OR
4546: p_old_header_rec.return_reason_code IS NULL ) OR
4547: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4548: --bug 5060064
4549: THEN
4550:
4551: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN

Line 4552: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4548: --bug 5060064
4549: THEN
4550:
4551: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4552: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4554: THEN
4555: p_x_header_rec.return_reason_code := NULL;
4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4549: THEN
4550:
4551: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4552: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4554: THEN
4555: p_x_header_rec.return_reason_code := NULL;
4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4552: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4554: THEN
4555: p_x_header_rec.return_reason_code := NULL;
4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4558: THEN
4559: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4560: ELSE

Line 4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4554: THEN
4555: p_x_header_rec.return_reason_code := NULL;
4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4558: THEN
4559: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4560: ELSE
4561: x_return_status := FND_API.G_RET_STS_ERROR;

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

4569: IF p_x_header_rec.Default_fulfillment_set IS NOT NULL AND
4570: ( (p_x_header_rec.default_fulfillment_set <>
4571: p_old_header_rec.default_fulfillment_set OR
4572: p_old_header_rec.default_fulfillment_set IS NULL ) OR
4573: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4574: --bug 5060064
4575: THEN
4576:
4577: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)

Line 4579: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4575: THEN
4576:
4577: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4578: THEN
4579: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4581: THEN
4582: p_x_header_rec.default_fulfillment_set := NULL;
4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4576:
4577: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4578: THEN
4579: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4581: THEN
4582: p_x_header_rec.default_fulfillment_set := NULL;
4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4579: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4581: THEN
4582: p_x_header_rec.default_fulfillment_set := NULL;
4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4585: THEN
4586: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4587: ELSE

Line 4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4581: THEN
4582: p_x_header_rec.default_fulfillment_set := NULL;
4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4585: THEN
4586: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4587: ELSE
4588: x_return_status := FND_API.G_RET_STS_ERROR;

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

4595: IF p_x_header_rec.fulfillment_set_name IS NOT NULL AND
4596: ( (p_x_header_rec.fulfillment_set_name <>
4597: p_old_header_rec.fulfillment_set_name OR
4598: p_old_header_rec.fulfillment_set_name IS NULL ) OR
4599: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4600: --bug 5060064
4601: THEN
4602:
4603: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)

Line 4605: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4601: THEN
4602:
4603: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4604: THEN
4605: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4607: THEN
4608: p_x_header_rec.fulfillment_set_name := NULL;
4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4602:
4603: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4604: THEN
4605: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4607: THEN
4608: p_x_header_rec.fulfillment_set_name := NULL;
4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4605: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4607: THEN
4608: p_x_header_rec.fulfillment_set_name := NULL;
4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4611: THEN
4612: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4613: ELSE

Line 4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4607: THEN
4608: p_x_header_rec.fulfillment_set_name := NULL;
4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4611: THEN
4612: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4613: ELSE
4614: x_return_status := FND_API.G_RET_STS_ERROR;

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

4621: IF p_x_header_rec.Line_set_name IS NOT NULL AND
4622: ( (p_x_header_rec.Line_set_name <>
4623: p_old_header_rec.Line_set_name OR
4624: p_old_header_rec.Line_set_name IS NULL ) OR
4625: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4626: --bug 5060064
4627: THEN
4628:
4629: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)

Line 4631: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4627: THEN
4628:
4629: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4630: THEN
4631: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4633: THEN
4634: p_x_header_rec.line_set_name := NULL;
4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4628:
4629: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4630: THEN
4631: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4633: THEN
4634: p_x_header_rec.line_set_name := NULL;
4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4631: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4633: THEN
4634: p_x_header_rec.line_set_name := NULL;
4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4637: THEN
4638: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4639: ELSE

Line 4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4633: THEN
4634: p_x_header_rec.line_set_name := NULL;
4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4637: THEN
4638: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4639: ELSE
4640: x_return_status := FND_API.G_RET_STS_ERROR;

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

4650: IF p_x_header_rec.user_status_code IS NOT NULL AND
4651: ( (p_x_header_rec.user_status_code <>
4652: p_old_header_rec.user_status_code OR
4653: p_old_header_rec.user_status_code IS NULL ) OR
4654: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4655: --bug 5060064
4656: THEN
4657:
4658: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)

Line 4660: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4656: THEN
4657:
4658: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4659: THEN
4660: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4662: THEN
4663: p_x_header_rec.user_status_code := NULL;
4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4657:
4658: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4659: THEN
4660: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4662: THEN
4663: p_x_header_rec.user_status_code := NULL;
4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4660: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4662: THEN
4663: p_x_header_rec.user_status_code := NULL;
4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4666: THEN
4667: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4668: ELSE

Line 4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4662: THEN
4663: p_x_header_rec.user_status_code := NULL;
4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4666: THEN
4667: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4668: ELSE
4669: x_return_status := FND_API.G_RET_STS_ERROR;

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

4677: IF p_x_header_rec.version_number IS NOT NULL AND
4678: ( (p_x_header_rec.version_number <>
4679: p_old_header_rec.version_number OR
4680: p_old_header_rec.version_number IS NULL ) OR
4681: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4682: --bug 5060064
4683: THEN
4684:
4685: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)

Line 4687: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4683: THEN
4684:
4685: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4686: THEN
4687: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4689: THEN
4690: p_x_header_rec.version_number := NULL;
4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4684:
4685: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4686: THEN
4687: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4689: THEN
4690: p_x_header_rec.version_number := NULL;
4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4687: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4689: THEN
4690: p_x_header_rec.version_number := NULL;
4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4693: THEN
4694: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4695: ELSE

Line 4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4689: THEN
4690: p_x_header_rec.version_number := NULL;
4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4693: THEN
4694: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4695: ELSE
4696: x_return_status := FND_API.G_RET_STS_ERROR;

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

4703: IF p_x_header_rec.expiration_date IS NOT NULL AND
4704: ( (p_x_header_rec.expiration_date <>
4705: p_old_header_rec.expiration_date OR
4706: p_old_header_rec.expiration_date IS NULL ) OR
4707: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4708: --bug 5060064
4709: THEN
4710:
4711: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)

Line 4713: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4709: THEN
4710:
4711: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4712: THEN
4713: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4715: THEN
4716: p_x_header_rec.expiration_date := NULL;
4717: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4710:
4711: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4712: THEN
4713: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4715: THEN
4716: p_x_header_rec.expiration_date := NULL;
4717: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4718: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4717: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4713: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4715: THEN
4716: p_x_header_rec.expiration_date := NULL;
4717: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4718: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4719: THEN
4720: -- Bug 3222419
4721: -- Copy was failing with numeric/value error if expiration date

Line 4718: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4715: THEN
4716: p_x_header_rec.expiration_date := NULL;
4717: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4718: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4719: THEN
4720: -- Bug 3222419
4721: -- Copy was failing with numeric/value error if expiration date
4722: -- supplied was < sysdate

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

4732: IF p_x_header_rec.sold_to_site_use_id IS NOT NULL AND
4733: ( (p_x_header_rec.sold_to_site_use_id <>
4734: p_old_header_rec.sold_to_site_use_id OR
4735: p_old_header_rec.sold_to_site_use_id IS NULL ) OR
4736: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4737: --bug 5060064
4738: THEN
4739: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4740: THEN

Line 4741: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4737: --bug 5060064
4738: THEN
4739: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4740: THEN
4741: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4743: THEN
4744: p_x_header_rec.sold_to_site_use_id := NULL;
4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4738: THEN
4739: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4740: THEN
4741: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4743: THEN
4744: p_x_header_rec.sold_to_site_use_id := NULL;
4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4741: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4743: THEN
4744: p_x_header_rec.sold_to_site_use_id := NULL;
4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4747: THEN
4748: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4749: ELSE

Line 4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4743: THEN
4744: p_x_header_rec.sold_to_site_use_id := NULL;
4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4747: THEN
4748: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4749: ELSE
4750: x_return_status := FND_API.G_RET_STS_ERROR;

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

4759: IF p_x_header_rec.Minisite_Id IS NOT NULL AND
4760: ( (p_x_header_rec.Minisite_Id <>
4761: p_old_header_rec.Minisite_Id OR
4762: p_old_header_rec.Minisite_Id IS NULL ) OR
4763: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4764: --bug 5060064
4765: THEN
4766:
4767: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)

Line 4769: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4765: THEN
4766:
4767: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4768: THEN
4769: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4771: THEN
4772: p_x_header_rec.Minisite_Id := NULL;
4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4766:
4767: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4768: THEN
4769: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4771: THEN
4772: p_x_header_rec.Minisite_Id := NULL;
4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4769: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4771: THEN
4772: p_x_header_rec.Minisite_Id := NULL;
4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4775: THEN
4776: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4777: ELSE

Line 4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4771: THEN
4772: p_x_header_rec.Minisite_Id := NULL;
4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4775: THEN
4776: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4777: ELSE
4778: x_return_status := FND_API.G_RET_STS_ERROR;

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

4785: IF p_x_header_rec.Ib_owner IS NOT NULL AND
4786: ( (p_x_header_rec.Ib_owner <>
4787: p_old_header_rec.Ib_owner OR
4788: p_old_header_rec.Ib_owner IS NULL ) OR
4789: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4790: --bug 5060064
4791: THEN
4792:
4793: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)

Line 4795: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4791: THEN
4792:
4793: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4794: THEN
4795: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4797: THEN
4798: p_x_header_rec.Ib_owner := NULL;
4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4792:
4793: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4794: THEN
4795: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4797: THEN
4798: p_x_header_rec.Ib_owner := NULL;
4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4795: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4797: THEN
4798: p_x_header_rec.Ib_owner := NULL;
4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4801: THEN
4802: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4803: ELSE

Line 4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4797: THEN
4798: p_x_header_rec.Ib_owner := NULL;
4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4801: THEN
4802: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4803: ELSE
4804: x_return_status := FND_API.G_RET_STS_ERROR;

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

4811: IF p_x_header_rec.Ib_installed_at_location IS NOT NULL AND
4812: ( (p_x_header_rec.Ib_installed_at_location <>
4813: p_old_header_rec.Ib_installed_at_location OR
4814: p_old_header_rec.Ib_installed_at_location IS NULL ) OR
4815: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4816: --bug 5060064
4817: THEN
4818:
4819: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)

Line 4821: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4817: THEN
4818:
4819: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4820: THEN
4821: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4823: THEN
4824: p_x_header_rec.Ib_installed_at_location := NULL;
4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4818:
4819: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4820: THEN
4821: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4823: THEN
4824: p_x_header_rec.Ib_installed_at_location := NULL;
4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4821: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4823: THEN
4824: p_x_header_rec.Ib_installed_at_location := NULL;
4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4827: THEN
4828: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4829: ELSE

Line 4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4823: THEN
4824: p_x_header_rec.Ib_installed_at_location := NULL;
4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4827: THEN
4828: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4829: ELSE
4830: x_return_status := FND_API.G_RET_STS_ERROR;

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

4837: IF p_x_header_rec.Ib_current_location IS NOT NULL AND
4838: ( (p_x_header_rec.Ib_current_location <>
4839: p_old_header_rec.Ib_current_location OR
4840: p_old_header_rec.Ib_current_location IS NULL ) OR
4841: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4842: --bug 5060064
4843: THEN
4844:
4845: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)

Line 4847: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4843: THEN
4844:
4845: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4846: THEN
4847: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4849: THEN
4850: p_x_header_rec.Ib_current_location := NULL;
4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4844:
4845: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4846: THEN
4847: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4849: THEN
4850: p_x_header_rec.Ib_current_location := NULL;
4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4847: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4849: THEN
4850: p_x_header_rec.Ib_current_location := NULL;
4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4853: THEN
4854: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4855: ELSE

Line 4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4849: THEN
4850: p_x_header_rec.Ib_current_location := NULL;
4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4853: THEN
4854: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4855: ELSE
4856: x_return_status := FND_API.G_RET_STS_ERROR;

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

4863: IF p_x_header_rec.End_customer_id IS NOT NULL AND
4864: ( (p_x_header_rec.End_customer_id <>
4865: p_old_header_rec.End_customer_id OR
4866: p_old_header_rec.End_customer_id IS NULL ) OR
4867: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4868: --bug 5060064
4869: THEN
4870:
4871: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)

Line 4873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4869: THEN
4870:
4871: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4872: THEN
4873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4875: THEN
4876: p_x_header_rec.End_customer_id := NULL;
4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4870:
4871: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4872: THEN
4873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4875: THEN
4876: p_x_header_rec.End_customer_id := NULL;
4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4875: THEN
4876: p_x_header_rec.End_customer_id := NULL;
4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4879: THEN
4880: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4881: ELSE

Line 4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4875: THEN
4876: p_x_header_rec.End_customer_id := NULL;
4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4879: THEN
4880: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4881: ELSE
4882: x_return_status := FND_API.G_RET_STS_ERROR;

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

4889: IF p_x_header_rec.End_customer_contact_id IS NOT NULL AND
4890: ( (p_x_header_rec.End_customer_contact_id <>
4891: p_old_header_rec.End_customer_contact_id OR
4892: p_old_header_rec.End_customer_contact_id IS NULL ) OR
4893: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4894: --bug 5060064
4895: THEN
4896:
4897: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)

Line 4899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4895: THEN
4896:
4897: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4898: THEN
4899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4901: THEN
4902: p_x_header_rec.End_customer_contact_id := NULL;
4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4896:
4897: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4898: THEN
4899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4901: THEN
4902: p_x_header_rec.End_customer_contact_id := NULL;
4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4901: THEN
4902: p_x_header_rec.End_customer_contact_id := NULL;
4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4905: THEN
4906: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4907: ELSE

Line 4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4901: THEN
4902: p_x_header_rec.End_customer_contact_id := NULL;
4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4905: THEN
4906: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4907: ELSE
4908: x_return_status := FND_API.G_RET_STS_ERROR;

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

4915: IF p_x_header_rec.End_customer_site_use_id IS NOT NULL AND
4916: ( (p_x_header_rec.End_customer_site_use_id <>
4917: p_old_header_rec.End_customer_site_use_id OR
4918: p_old_header_rec.End_customer_site_use_id IS NULL ) OR
4919: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4920: --bug 5060064
4921: THEN
4922:
4923: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)

Line 4925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4921: THEN
4922:
4923: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
4924: THEN
4925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4927: THEN
4928: p_x_header_rec.End_customer_site_use_id := NULL;
4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4922:
4923: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
4924: THEN
4925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4927: THEN
4928: p_x_header_rec.End_customer_site_use_id := NULL;
4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4927: THEN
4928: p_x_header_rec.End_customer_site_use_id := NULL;
4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4931: THEN
4932: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4933: ELSE

Line 4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4927: THEN
4928: p_x_header_rec.End_customer_site_use_id := NULL;
4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4931: THEN
4932: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4933: ELSE
4934: x_return_status := FND_API.G_RET_STS_ERROR;

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

4941: IF p_x_header_rec.supplier_signature IS NOT NULL AND
4942: ( (p_x_header_rec.supplier_signature <>
4943: p_old_header_rec.supplier_signature OR
4944: p_old_header_rec.supplier_signature IS NULL ) OR
4945: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4946: --bug 5060064
4947: THEN
4948:
4949: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)

Line 4951: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4947: THEN
4948:
4949: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
4950: THEN
4951: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4953: THEN
4954: p_x_header_rec.supplier_signature := NULL;
4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4948:
4949: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
4950: THEN
4951: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4953: THEN
4954: p_x_header_rec.supplier_signature := NULL;
4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4951: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4953: THEN
4954: p_x_header_rec.supplier_signature := NULL;
4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4957: THEN
4958: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
4959: ELSE

Line 4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4953: THEN
4954: p_x_header_rec.supplier_signature := NULL;
4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4957: THEN
4958: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
4959: ELSE
4960: x_return_status := FND_API.G_RET_STS_ERROR;

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

4967: IF p_x_header_rec.supplier_signature_date IS NOT NULL AND
4968: ( (p_x_header_rec.supplier_signature_date <>
4969: p_old_header_rec.supplier_signature_date OR
4970: p_old_header_rec.supplier_signature_date IS NULL ) OR
4971: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4972: --bug 5060064
4973: THEN
4974:
4975: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)

Line 4977: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4973: THEN
4974:
4975: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
4976: THEN
4977: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4979: THEN
4980: p_x_header_rec.supplier_signature_date := NULL;
4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4974:
4975: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
4976: THEN
4977: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4979: THEN
4980: p_x_header_rec.supplier_signature_date := NULL;
4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

4977: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4979: THEN
4980: p_x_header_rec.supplier_signature_date := NULL;
4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4983: THEN
4984: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4985: ELSE

Line 4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4979: THEN
4980: p_x_header_rec.supplier_signature_date := NULL;
4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4983: THEN
4984: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4985: ELSE
4986: x_return_status := FND_API.G_RET_STS_ERROR;

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

4993: IF p_x_header_rec.customer_signature IS NOT NULL AND
4994: ( (p_x_header_rec.customer_signature <>
4995: p_old_header_rec.customer_signature OR
4996: p_old_header_rec.customer_signature IS NULL ) OR
4997: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4998: --bug 5060064
4999: THEN
5000:
5001: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)

Line 5003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

4999: THEN
5000:
5001: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5002: THEN
5003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5005: THEN
5006: p_x_header_rec.customer_signature := NULL;
5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5000:
5001: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5002: THEN
5003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5005: THEN
5006: p_x_header_rec.customer_signature := NULL;
5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5005: THEN
5006: p_x_header_rec.customer_signature := NULL;
5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5009: THEN
5010: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5011: ELSE

Line 5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5005: THEN
5006: p_x_header_rec.customer_signature := NULL;
5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5009: THEN
5010: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5011: ELSE
5012: x_return_status := FND_API.G_RET_STS_ERROR;

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

5019: IF p_x_header_rec.customer_signature_date IS NOT NULL AND
5020: ( (p_x_header_rec.customer_signature_date <>
5021: p_old_header_rec.customer_signature_date OR
5022: p_old_header_rec.customer_signature_date IS NULL ) OR
5023: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5024: --bug 5060064
5025: THEN
5026:
5027: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)

Line 5029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

5025: THEN
5026:
5027: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5028: THEN
5029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5031: THEN
5032: p_x_header_rec.customer_signature_date := NULL;
5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5026:
5027: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5028: THEN
5029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5031: THEN
5032: p_x_header_rec.customer_signature_date := NULL;
5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

Line 5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

5029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5031: THEN
5032: p_x_header_rec.customer_signature_date := NULL;
5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5035: THEN
5036: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5037: ELSE

Line 5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5031: THEN
5032: p_x_header_rec.customer_signature_date := NULL;
5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5035: THEN
5036: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5037: ELSE
5038: x_return_status := FND_API.G_RET_STS_ERROR;