eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_LINE dependencies on OE_VALIDATE_LINE

Line 1: PACKAGE BODY OE_Validate_Line AS

1: PACKAGE BODY OE_Validate_Line AS
2: /* $Header: OEXLLINB.pls 120.73.12020000.13 2013/05/15 07:08:21 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXLLINB.pls 120.73.12020000.13 2013/05/15 07:08:21 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line';
7: --var added for bug 4171642
8: g_master_org_id NUMBER; --Bug#12426110
9: --g_cust_ord_enabled_flag varchar2(1):=nvl(FND_PROFILE.Value('ONT_VAL_CUST_ORD_ENABLED_FLAG'),'N'); --bug4343544
10: -- LOCAL PROCEDURES

Line 29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);

25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: BEGIN
27:
28: if l_debug_level > 0 then
29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
30: oe_debug_pub.add('Phase: '||p_line_rec.transaction_phase_code,1);
31: end if;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 212: oe_debug_pub.add('Exit OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);

208:
209: END IF; -- End of check if phase = F/N
210:
211: if l_debug_level > 0 then
212: oe_debug_pub.add('Exit OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
213: end if;
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN

Line 271: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269:
270: IF l_debug_level > 0 then
271: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
272: END IF;
273: -- Check for fields required on a booked order line
274:
275: IF p_line_rec.sold_to_org_id IS NULL THEN

Line 733: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

729: END IF;
730: END IF;
731: */
732: IF l_debug_level > 0 then
733: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
734: END IF;
735:
736: EXCEPTION
737: WHEN OTHERS THEN

Line 776: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);

772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: IF l_debug_level > 0 then
776: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);
777: END IF;
778:
779: -- Select statement to check the Ship Set Enforce Parameter.
780: BEGIN

Line 877: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'

873: END IF;
874:
875:
876: IF l_debug_level > 0 then
877: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'
878: ||x_return_status,1);
879: END IF;
880:
881: EXCEPTION

Line 901: ( 'OE_VALIDATE_LINE',

897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: OE_MSG_PUB.Add_Exc_Msg
901: ( 'OE_VALIDATE_LINE',
902: 'Validate_Shipset_SMC');
903: END IF;
904: END Validate_Shipset_SMC;
905:

Line 948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);

944: l_qty_return_status VARCHAR2(1);
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: BEGIN
947: IF l_debug_level > 0 then
948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
949: END IF;
950: -- validate input quantity
951: -- Changes for Decimal ATO's
952:

Line 1047: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);

1043: END IF;
1044:
1045: END IF; -- quantity is null
1046: IF l_debug_level > 0 then
1047: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
1048: END IF;
1049: END Validate_Decimal_Quantity;
1050:
1051: /*---------------------------------------------------------------------

Line 1196: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);

1192:
1193: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1194: BEGIN
1195: IF l_debug_level > 0 then
1196: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1197: END IF;
1198:
1199: /* Added for the bug #3257965.
1200: Validation for Line Type and Line Category.

Line 1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);

1202: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code))
1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;

Line 1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);

1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE

Line 1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);

1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all

Line 1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);

1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1213: where transaction_type_id = p_line_rec.line_type_id;

Line 1304: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);

1300: END IF;
1301:
1302: END IF; -- Operation
1303: IF l_debug_level > 0 then
1304: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1305: END IF;
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');

Line 1336: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);

1332: l_dummy VARCHAR2(10);
1333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1334: BEGIN
1335: IF l_debug_level > 0 then
1336: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1337: END IF;
1338:
1339: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
1340: -- AND INVCONV

Line 1372: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);

1368: FROM financials_system_parameters fsp);
1369:
1370: END IF;
1371: IF l_debug_level > 0 then
1372: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1373: END IF;
1374:
1375: RETURN TRUE;
1376: EXCEPTION

Line 2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

2481: l_site_use_code VARCHAR2(30);
2482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2483: BEGIN
2484: IF l_debug_level > 0 then
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2487: END IF;
2488:
2489: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

Line 2500: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

2496: AND site_use_id = p_deliver_to_org_id
2497: AND status = 'A'
2498: AND address_status ='A';--bug 2752321
2499: IF l_debug_level > 0 then
2500: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2501: END IF;
2502: RETURN TRUE;
2503:
2504: ELSIF lcustomer_relations = 'Y' THEN

Line 2531: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

2527: -- bug 4205113
2528: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2529: AND ROWNUM = 1;
2530: IF l_debug_level > 0 then
2531: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2532: END IF;
2533: RETURN TRUE;
2534:
2535: ELSIF lcustomer_relations = 'A' THEN

Line 2546: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

2542: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2543: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
2544: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
2545: IF l_debug_level > 0 then
2546: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2547: END IF;
2548: RETURN TRUE;
2549:
2550:

Line 2553: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);

2549:
2550:
2551: END IF;
2552: IF l_debug_level > 0 then
2553: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2554: END IF;
2555: RETURN TRUE;
2556:
2557: EXCEPTION

Line 2597: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);

2593:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2595:
2596: if l_debug_level > 0 then
2597: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2598: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2599: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2600: end if;
2601:

Line 2778: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);

2774: END IF;
2775:
2776: /* End: Fix Bug # 2507479 */
2777: IF l_debug_level > 0 then
2778: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);
2779: END IF;
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND THEN
2782:

Line 3138: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);

3134:
3135: x_return_status := fnd_api.g_ret_sts_success;
3136:
3137: if l_debug_level > 0 then
3138: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);
3139: end if;
3140:
3141: IF p_line_rec.blanket_line_number IS NULL OR
3142: p_line_rec.blanket_version_number IS NULL THEN

Line 3705: ( 'OE_VALIDATE_LINE',

3701:
3702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: OE_MSG_PUB.Add_Exc_Msg
3705: ( 'OE_VALIDATE_LINE',
3706: 'Validate_Blanket_Values');
3707: END IF;
3708:
3709: END Validate_Blanket_Values;

Line 3753: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');

3749: x_item_type_code := p_line_rec.item_type_code;
3750: x_line_id := p_line_rec.reference_line_id;
3751:
3752: IF l_debug_level > 0 THEN
3753: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');
3754: END IF;
3755:
3756: END Get_Return_Line_Attributes;
3757:

Line 3942: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);

3938: l_rule_type VARCHAR2(10);
3939: l_line_type VARCHAR2(80);
3940: BEGIN
3941: IF l_debug_level > 0 then
3942: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3943: END IF;
3944: g_master_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ; --Bug#12426110
3945: IF OE_GLOBALS.G_HEADER_CREATED
3946: THEN

Line 8097: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);

8093: x_return_status := l_return_status;
8094:
8095: -- Done validating entity
8096: IF l_debug_level > 0 then
8097: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);
8098: END IF;
8099: EXCEPTION
8100:
8101: WHEN FND_API.G_EXC_ERROR THEN

Line 8143: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);

8139: l_ret_sts_dff VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ; --bug8302126
8140:
8141: BEGIN
8142: IF l_debug_level > 0 then
8143: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);
8144: END IF;
8145: x_return_status := FND_API.G_RET_STS_SUCCESS;
8146: l_return_status := FND_API.G_RET_STS_SUCCESS;
8147:

Line 8516: IF NOT OE_Validate.Line_Type(p_x_line_rec.line_type_id) THEN

8512: ( p_x_line_rec.line_type_id <>
8513: p_old_line_rec.line_type_id OR
8514: p_old_line_rec.line_type_id IS NULL )
8515: THEN
8516: IF NOT OE_Validate.Line_Type(p_x_line_rec.line_type_id) THEN
8517: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8518: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8519: p_x_line_rec.line_type_id := NULL;
8520: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 9011: IF NOT OE_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN

9007: ( p_x_line_rec.flow_status_code <>
9008: p_old_line_rec.flow_status_code OR
9009: p_old_line_rec.flow_status_code IS NULL )
9010: THEN
9011: IF NOT OE_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
9012: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9013: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9014: p_x_line_rec.flow_status_code := NULL;
9015: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

Line 9454: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);

9450: END IF;
9451: --sol_ord_er #16014165
9452:
9453: IF l_debug_level > 0 then
9454: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);
9455: END IF;
9456:
9457: EXCEPTION
9458:

Line 9631: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);

9627:
9628: BEGIN
9629: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4230230
9630: IF l_debug_level > 0 then
9631: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);
9632: END IF;
9633:
9634: -- Bug 2333071 : Excluding Flexfield validation for CONFIG line
9635: -- Fixing 2375476 to skip the Flex field validation in case of

Line 9777: IF NOT OE_VALIDATE.Line_Desc_Flex

9773: oe_debug_pub.add('Before calling line_desc_flex',2);
9774: END IF;
9775: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9776:
9777: IF NOT OE_VALIDATE.Line_Desc_Flex
9778: (p_context => p_x_line_rec.context
9779: ,p_attribute1 => p_x_line_rec.attribute1
9780: ,p_attribute2 => p_x_line_rec.attribute2
9781: ,p_attribute3 => p_x_line_rec.attribute3

Line 11117: Oe_debug_pub.ADD('Entering Oe_validate_line.entity_delete for line ID : ' || p_line_rec.line_id);

11113: -- RMA as delinking of a config item triggers deletion and invalidates the
11114: -- reference on any open RMAs ceated against it.
11115:
11116: IF l_debug_level > 0 THEN
11117: Oe_debug_pub.ADD('Entering Oe_validate_line.entity_delete for line ID : ' || p_line_rec.line_id);
11118: END IF;
11119:
11120: IF p_line_rec.line_category_code = 'ORDER' AND p_line_rec.item_type_code = 'CONFIG'
11121: THEN

Line 11132: oe_debug_pub.add('Leaving Oe_validate_line.entity_delete with status : '||l_return_status, 1);

11128: END IF;
11129: END IF;
11130:
11131: IF l_debug_level > 0 THEN
11132: oe_debug_pub.add('Leaving Oe_validate_line.entity_delete with status : '||l_return_status, 1);
11133: END IF;
11134: -- NULL;
11135: -- End : Changes for bug 7707133
11136:

Line 11165: END OE_Validate_Line;

11161: END IF;
11162:
11163: END Entity_Delete;
11164:
11165: END OE_Validate_Line;