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.13.12020000.3 2013/01/07 07:26:21 sujithku 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.13.12020000.3 2013/01/07 07:26:21 sujithku 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 11277: oe_validate_header/oe_validate_line.

11273: END IF;
11274:
11275: /*
11276: Blanket Number validation is done in procedure Entity for
11277: oe_validate_header/oe_validate_line.
11278: On Hold and Expired blankets are allowed for return/mixed
11279: orders.
11280: SELECT 'VALID'
11281: INTO l_dummy

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

15154: FND_FLEX_DESCVAL.Set_Context_Value
15155: ( context_value => l_column_value);
15156:
15157: IF p_document_type = 'ORDER' THEN
15158: IF NOT OE_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN
15159: RETURN FALSE;
15160: END IF;
15161: ELSIF p_document_type = 'BLANKET' THEN
15162: IF NOT OE_Validate.Desc_Flex('OE_BLKT_HEADER_ATTRIBUTES') THEN

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

15158: IF NOT OE_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN
15159: RETURN FALSE;
15160: END IF;
15161: ELSIF p_document_type = 'BLANKET' THEN
15162: IF NOT OE_Validate.Desc_Flex('OE_BLKT_HEADER_ATTRIBUTES') THEN
15163: RETURN FALSE;
15164: END IF;
15165: END IF;
15166:

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

15540: END IF;
15541: FND_FLEX_DESCVAL.Set_Context_Value
15542: ( context_value => l_column_value);
15543:
15544: IF NOT OE_Validate.Desc_Flex('OE_HEADER_GLOBAL_ATTRIBUTE') THEN
15545: RETURN FALSE;
15546: END IF;
15547:
15548: --END IF;

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

15836: END IF;
15837: FND_FLEX_DESCVAL.Set_Context_Value
15838: ( context_value => l_column_value);
15839:
15840: IF NOT OE_Validate.Desc_Flex('OE_HEADER_TP_ATTRIBUTES') THEN
15841: RETURN FALSE;
15842: END IF;
15843:
15844: --END IF;

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

16216: FND_FLEX_DESCVAL.Set_Context_Value
16217: ( context_value => l_column_value);
16218:
16219: IF p_document_type = 'ORDER' THEN
16220: IF NOT OE_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN
16221: RETURN FALSE;
16222: END IF;
16223: ELSIF p_document_type = 'BLANKET' THEN
16224: IF NOT OE_Validate.Desc_Flex('OE_BLKT_LINE_ATTRIBUTES') THEN

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

16220: IF NOT OE_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN
16221: RETURN FALSE;
16222: END IF;
16223: ELSIF p_document_type = 'BLANKET' THEN
16224: IF NOT OE_Validate.Desc_Flex('OE_BLKT_LINE_ATTRIBUTES') THEN
16225: RETURN FALSE;
16226: END IF;
16227: END IF;
16228:

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

16602: END IF;
16603: FND_FLEX_DESCVAL.Set_Context_Value
16604: ( context_value => l_column_value);
16605: /*commenting this code due to bug# 993103
16606: IF NOT OE_Validate.Desc_Flex('OE_LINE_GLOBAL_ATTRIBUTE') THEN
16607:
16608: RETURN FALSE;
16609: END IF; */
16610:

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

16821: END IF;
16822: FND_FLEX_DESCVAL.Set_Context_Value
16823: ( context_value => l_column_value);
16824:
16825: IF NOT OE_Validate.Desc_Flex('OE_LINE_PRICING_ATTRIBUTE') THEN
16826: RETURN FALSE;
16827: END IF;
16828:
16829:

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

17397:
17398: IF OE_GLOBALS.G_RLM_INSTALLED = 'Y' THEN
17399:
17400: -- IF (G_RLM_INSTALLED_FLAG = 'Y') THEN
17401: IF NOT OE_Validate.Desc_Flex('RLM_SCHEDULE_LINES') THEN
17402: RETURN FALSE;
17403: END IF;
17404: ELSE
17405: IF NOT OE_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN

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

17401: IF NOT OE_Validate.Desc_Flex('RLM_SCHEDULE_LINES') THEN
17402: RETURN FALSE;
17403: END IF;
17404: ELSE
17405: IF NOT OE_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN
17406: RETURN FALSE;
17407: END IF;
17408: END IF;
17409:

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

17705: END IF;
17706: FND_FLEX_DESCVAL.Set_Context_Value
17707: ( context_value => l_column_value);
17708:
17709: IF NOT OE_Validate.Desc_Flex('OE_LINE_TP_ATTRIBUTES') THEN
17710: RETURN FALSE;
17711: END IF;
17712:
17713:

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

17758:
17759: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURN_CONTEXT');
17760:
17761: /* Following assignments have been added for bug 2755607, since the call
17762: to oe_validate.desc_flex is commented for Return Flex field, the global
17763: variables holding the flex values need to be assigned with NULL, this
17764: can commented when call to oe_validate.desc_flex is uncommented below */
17765:
17766: g_context := NULL;

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

17760:
17761: /* Following assignments have been added for bug 2755607, since the call
17762: to oe_validate.desc_flex is commented for Return Flex field, the global
17763: variables holding the flex values need to be assigned with NULL, this
17764: can commented when call to oe_validate.desc_flex is uncommented below */
17765:
17766: g_context := NULL;
17767: g_attribute1 := NULL;
17768: g_attribute2 := NULL;

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

18032:
18033:
18034: -- Remove after fixing :block.field_name stuff
18035:
18036: -- IF NOT OE_Validate.Desc_Flex('OE_LINE_RETURN_ATTRIBUTE') THEN
18037: -- RETURN FALSE;
18038: -- END IF;
18039:
18040: -- END IF;

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

18315: END IF;
18316: FND_FLEX_DESCVAL.Set_Context_Value
18317: ( context_value => l_column_value);
18318:
18319: IF NOT OE_Validate.Desc_Flex('OE_PRICE_ADJUSTMENT') THEN
18320: RETURN FALSE;
18321: END IF;
18322:
18323:

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

18622: END IF;
18623: FND_FLEX_DESCVAL.Set_Context_Value
18624: ( context_value => l_column_value);
18625:
18626: IF NOT OE_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN
18627: OE_DEBUG_PUB.add('Error at validation of OE_SALES_CREDITS_ATTRIBUTES ',1);
18628: RETURN FALSE;
18629: END IF;
18630:

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

19406:
19407: RETURN TRUE;
19408: END IF;
19409: --IF l_debug_level > 0 THEN
19410: --oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19411: --END IF;
19412: /*SELECT 'VALID'
19413: INTO l_dummy
19414: FROM OE_LOOKUPS

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

19447:
19448: END IF;
19449:
19450: --IF l_debug_level > 0 THEN
19451: --oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);
19452: --END IF;
19453:
19454: RETURN FALSE;
19455:

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

19463: );
19464: END IF;
19465:
19466: --IF l_debug_level > 0 THEN
19467: --oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);
19468: --END IF;
19469:
19470:
19471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

23068: FND_FLEX_DESCVAL.Set_Context_Value
23069: ( context_value => l_column_value);
23070: -- Suppressing the validation as payments flexfield is not registered
23071: /*
23072: IF NOT OE_Validate.Desc_Flex('OE_PAYMENTS_ATTRIBUTES') THEN
23073: OE_DEBUG_PUB.add('Error at validation of OE_PAYMENTS_ATTRIBUTES ',1);
23074: RETURN FALSE;
23075: END IF;
23076: */

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

23656: WHERE uom_code = p_charge_periodicity
23657: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23658:
23659: IF l_debug_level > 0 THEN
23660: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);

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

23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23665: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23666: END IF;
23667:
23668: RETURN TRUE;
23669:

Line 24049: END OE_Validate;

24045: --
24046: --
24047: --
24048:
24049: END OE_Validate;