DBA Data[Home] [Help]

APPS.OE_VALIDATE dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate AS

1: PACKAGE BODY OE_Validate AS
2: /* $Header: OEXSVATB.pls 120.11 2006/03/02 03:31:27 ksurendr ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate';

2: /* $Header: OEXSVATB.pls 120.11 2006/03/02 03:31:27 ksurendr ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate';
7:
8: G_RLM_INSTALLED_FLAG VARCHAR2(1) := 'N';
9:
10: -- Procedure Get_Attr_Tbl.

Line 11083: oe_validate_header/oe_validate_line.

11079: END IF;
11080:
11081: /*
11082: Blanket Number validation is done in procedure Entity for
11083: oe_validate_header/oe_validate_line.
11084: On Hold and Expired blankets are allowed for return/mixed
11085: orders.
11086: SELECT 'VALID'
11087: INTO l_dummy

Line 14964: IF NOT OE_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN

14960: FND_FLEX_DESCVAL.Set_Context_Value
14961: ( context_value => l_column_value);
14962:
14963: IF p_document_type = 'ORDER' THEN
14964: IF NOT OE_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN
14965: RETURN FALSE;
14966: END IF;
14967: ELSIF p_document_type = 'BLANKET' THEN
14968: IF NOT OE_Validate.Desc_Flex('OE_BLKT_HEADER_ATTRIBUTES') THEN

Line 14968: IF NOT OE_Validate.Desc_Flex('OE_BLKT_HEADER_ATTRIBUTES') THEN

14964: IF NOT OE_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN
14965: RETURN FALSE;
14966: END IF;
14967: ELSIF p_document_type = 'BLANKET' THEN
14968: IF NOT OE_Validate.Desc_Flex('OE_BLKT_HEADER_ATTRIBUTES') THEN
14969: RETURN FALSE;
14970: END IF;
14971: END IF;
14972:

Line 15350: IF NOT OE_Validate.Desc_Flex('OE_HEADER_GLOBAL_ATTRIBUTE') THEN

15346: END IF;
15347: FND_FLEX_DESCVAL.Set_Context_Value
15348: ( context_value => l_column_value);
15349:
15350: IF NOT OE_Validate.Desc_Flex('OE_HEADER_GLOBAL_ATTRIBUTE') THEN
15351: RETURN FALSE;
15352: END IF;
15353:
15354: --END IF;

Line 15646: IF NOT OE_Validate.Desc_Flex('OE_HEADER_TP_ATTRIBUTES') THEN

15642: END IF;
15643: FND_FLEX_DESCVAL.Set_Context_Value
15644: ( context_value => l_column_value);
15645:
15646: IF NOT OE_Validate.Desc_Flex('OE_HEADER_TP_ATTRIBUTES') THEN
15647: RETURN FALSE;
15648: END IF;
15649:
15650: --END IF;

Line 16026: IF NOT OE_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN

16022: FND_FLEX_DESCVAL.Set_Context_Value
16023: ( context_value => l_column_value);
16024:
16025: IF p_document_type = 'ORDER' THEN
16026: IF NOT OE_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN
16027: RETURN FALSE;
16028: END IF;
16029: ELSIF p_document_type = 'BLANKET' THEN
16030: IF NOT OE_Validate.Desc_Flex('OE_BLKT_LINE_ATTRIBUTES') THEN

Line 16030: IF NOT OE_Validate.Desc_Flex('OE_BLKT_LINE_ATTRIBUTES') THEN

16026: IF NOT OE_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN
16027: RETURN FALSE;
16028: END IF;
16029: ELSIF p_document_type = 'BLANKET' THEN
16030: IF NOT OE_Validate.Desc_Flex('OE_BLKT_LINE_ATTRIBUTES') THEN
16031: RETURN FALSE;
16032: END IF;
16033: END IF;
16034:

Line 16412: IF NOT OE_Validate.Desc_Flex('OE_LINE_GLOBAL_ATTRIBUTE') THEN

16408: END IF;
16409: FND_FLEX_DESCVAL.Set_Context_Value
16410: ( context_value => l_column_value);
16411: /*commenting this code due to bug# 993103
16412: IF NOT OE_Validate.Desc_Flex('OE_LINE_GLOBAL_ATTRIBUTE') THEN
16413:
16414: RETURN FALSE;
16415: END IF; */
16416:

Line 16631: IF NOT OE_Validate.Desc_Flex('OE_LINE_PRICING_ATTRIBUTE') THEN

16627: END IF;
16628: FND_FLEX_DESCVAL.Set_Context_Value
16629: ( context_value => l_column_value);
16630:
16631: IF NOT OE_Validate.Desc_Flex('OE_LINE_PRICING_ATTRIBUTE') THEN
16632: RETURN FALSE;
16633: END IF;
16634:
16635:

Line 17207: IF NOT OE_Validate.Desc_Flex('RLM_SCHEDULE_LINES') THEN

17203:
17204: IF OE_GLOBALS.G_RLM_INSTALLED = 'Y' THEN
17205:
17206: -- IF (G_RLM_INSTALLED_FLAG = 'Y') THEN
17207: IF NOT OE_Validate.Desc_Flex('RLM_SCHEDULE_LINES') THEN
17208: RETURN FALSE;
17209: END IF;
17210: ELSE
17211: IF NOT OE_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN

Line 17211: IF NOT OE_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN

17207: IF NOT OE_Validate.Desc_Flex('RLM_SCHEDULE_LINES') THEN
17208: RETURN FALSE;
17209: END IF;
17210: ELSE
17211: IF NOT OE_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN
17212: RETURN FALSE;
17213: END IF;
17214: END IF;
17215:

Line 17515: IF NOT OE_Validate.Desc_Flex('OE_LINE_TP_ATTRIBUTES') THEN

17511: END IF;
17512: FND_FLEX_DESCVAL.Set_Context_Value
17513: ( context_value => l_column_value);
17514:
17515: IF NOT OE_Validate.Desc_Flex('OE_LINE_TP_ATTRIBUTES') THEN
17516: RETURN FALSE;
17517: END IF;
17518:
17519:

Line 17568: to oe_validate.desc_flex is commented for Return Flex field, the global

17564:
17565: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURN_CONTEXT');
17566:
17567: /* Following assignments have been added for bug 2755607, since the call
17568: to oe_validate.desc_flex is commented for Return Flex field, the global
17569: variables holding the flex values need to be assigned with NULL, this
17570: can commented when call to oe_validate.desc_flex is uncommented below */
17571:
17572: g_context := NULL;

Line 17570: can commented when call to oe_validate.desc_flex is uncommented below */

17566:
17567: /* Following assignments have been added for bug 2755607, since the call
17568: to oe_validate.desc_flex is commented for Return Flex field, the global
17569: variables holding the flex values need to be assigned with NULL, this
17570: can commented when call to oe_validate.desc_flex is uncommented below */
17571:
17572: g_context := NULL;
17573: g_attribute1 := NULL;
17574: g_attribute2 := NULL;

Line 17842: -- IF NOT OE_Validate.Desc_Flex('OE_LINE_RETURN_ATTRIBUTE') THEN

17838:
17839:
17840: -- Remove after fixing :block.field_name stuff
17841:
17842: -- IF NOT OE_Validate.Desc_Flex('OE_LINE_RETURN_ATTRIBUTE') THEN
17843: -- RETURN FALSE;
17844: -- END IF;
17845:
17846: -- END IF;

Line 18125: IF NOT OE_Validate.Desc_Flex('OE_PRICE_ADJUSTMENT') THEN

18121: END IF;
18122: FND_FLEX_DESCVAL.Set_Context_Value
18123: ( context_value => l_column_value);
18124:
18125: IF NOT OE_Validate.Desc_Flex('OE_PRICE_ADJUSTMENT') THEN
18126: RETURN FALSE;
18127: END IF;
18128:
18129:

Line 18432: IF NOT OE_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN

18428: END IF;
18429: FND_FLEX_DESCVAL.Set_Context_Value
18430: ( context_value => l_column_value);
18431:
18432: IF NOT OE_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN
18433: OE_DEBUG_PUB.add('Error at validation of OE_SALES_CREDITS_ATTRIBUTES ',1);
18434: RETURN FALSE;
18435: END IF;
18436:

Line 19216: oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);

19212:
19213: RETURN TRUE;
19214: END IF;
19215: IF l_debug_level > 0 THEN
19216: oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19217: END IF;
19218: /*SELECT 'VALID'
19219: INTO l_dummy
19220: FROM OE_LOOKUPS

Line 19257: oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);

19253:
19254: END IF;
19255:
19256: IF l_debug_level > 0 THEN
19257: oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);
19258: END IF;
19259:
19260: RETURN FALSE;
19261:

Line 19273: oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);

19269: );
19270: END IF;
19271:
19272: IF l_debug_level > 0 THEN
19273: oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);
19274: END IF;
19275:
19276:
19277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 22878: IF NOT OE_Validate.Desc_Flex('OE_PAYMENTS_ATTRIBUTES') THEN

22874: FND_FLEX_DESCVAL.Set_Context_Value
22875: ( context_value => l_column_value);
22876: -- Suppressing the validation as payments flexfield is not registered
22877: /*
22878: IF NOT OE_Validate.Desc_Flex('OE_PAYMENTS_ATTRIBUTES') THEN
22879: OE_DEBUG_PUB.add('Error at validation of OE_PAYMENTS_ATTRIBUTES ',1);
22880: RETURN FALSE;
22881: END IF;
22882: */

Line 23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);

23462: WHERE uom_code = p_charge_periodicity
23463: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23464:
23465: IF l_debug_level > 0 THEN
23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);

Line 23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);

23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23472: END IF;
23473:
23474: RETURN TRUE;
23475:

Line 23855: END OE_Validate;

23851: --
23852: --
23853: --
23854:
23855: END OE_Validate;