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.52.12010000.7 2008/12/11 11:47:50 nitagarw 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.52.12010000.7 2008/12/11 11:47:50 nitagarw 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 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ;
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 709: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

705: END IF;
706: END IF;
707: */
708: IF l_debug_level > 0 then
709: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
710: END IF;
711:
712: EXCEPTION
713: WHEN OTHERS THEN

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

748:
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: IF l_debug_level > 0 then
752: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);
753: END IF;
754:
755: -- Select statement to check the Ship Set Enforce Parameter.
756: BEGIN

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

849: END IF;
850:
851:
852: IF l_debug_level > 0 then
853: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'
854: ||x_return_status,1);
855: END IF;
856:
857: EXCEPTION

Line 877: ( 'OE_VALIDATE_LINE',

873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: OE_MSG_PUB.Add_Exc_Msg
877: ( 'OE_VALIDATE_LINE',
878: 'Validate_Shipset_SMC');
879: END IF;
880: END Validate_Shipset_SMC;
881:

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

920: l_qty_return_status VARCHAR2(1);
921: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
922: BEGIN
923: IF l_debug_level > 0 then
924: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
925: END IF;
926: -- validate input quantity
927: -- Changes for Decimal ATO's
928:

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

1019: END IF;
1020:
1021: END IF; -- quantity is null
1022: IF l_debug_level > 0 then
1023: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
1024: END IF;
1025: END Validate_Decimal_Quantity;
1026:
1027: /*---------------------------------------------------------------------

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

1168:
1169: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1170: BEGIN
1171: IF l_debug_level > 0 then
1172: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1173: END IF;
1174:
1175: /* Added for the bug #3257965.
1176: Validation for Line Type and Line Category.

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

1178: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code))
1179: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;

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

1179: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE

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

1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE
1188: into lline_category_code from oe_transaction_types_all

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

1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE
1188: into lline_category_code from oe_transaction_types_all
1189: where transaction_type_id = p_line_rec.line_type_id;

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

1276: END IF;
1277:
1278: END IF; -- Operation
1279: IF l_debug_level > 0 then
1280: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1281: END IF;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');

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

1308: l_dummy VARCHAR2(10);
1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310: BEGIN
1311: IF l_debug_level > 0 then
1312: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1313: END IF;
1314:
1315: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
1316: -- AND INVCONV

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

1344: FROM financials_system_parameters fsp);
1345:
1346: END IF;
1347: IF l_debug_level > 0 then
1348: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1349: END IF;
1350:
1351: RETURN TRUE;
1352: EXCEPTION

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

2356: l_site_use_code VARCHAR2(30);
2357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2358: BEGIN
2359: IF l_debug_level > 0 then
2360: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2361: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2362: END IF;
2363:
2364: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

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

2371: AND site_use_id = p_deliver_to_org_id
2372: AND status = 'A'
2373: AND address_status ='A';--bug 2752321
2374: IF l_debug_level > 0 then
2375: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2376: END IF;
2377: RETURN TRUE;
2378:
2379: ELSIF lcustomer_relations = 'Y' THEN

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

2402: -- bug 4205113
2403: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2404: AND ROWNUM = 1;
2405: IF l_debug_level > 0 then
2406: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2407: END IF;
2408: RETURN TRUE;
2409:
2410: ELSIF lcustomer_relations = 'A' THEN

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

2417: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2418: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
2419: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
2420: IF l_debug_level > 0 then
2421: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2422: END IF;
2423: RETURN TRUE;
2424:
2425:

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

2424:
2425:
2426: END IF;
2427: IF l_debug_level > 0 then
2428: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2429: END IF;
2430: RETURN TRUE;
2431:
2432: EXCEPTION

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

2468:
2469: x_return_status := FND_API.G_RET_STS_SUCCESS;
2470:
2471: if l_debug_level > 0 then
2472: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2473: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2474: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2475: end if;
2476:

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

2649: END IF;
2650:
2651: /* End: Fix Bug # 2507479 */
2652: IF l_debug_level > 0 then
2653: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);
2654: END IF;
2655: EXCEPTION
2656: WHEN NO_DATA_FOUND THEN
2657:

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

3009:
3010: x_return_status := fnd_api.g_ret_sts_success;
3011:
3012: if l_debug_level > 0 then
3013: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);
3014: end if;
3015:
3016: IF p_line_rec.blanket_line_number IS NULL OR
3017: p_line_rec.blanket_version_number IS NULL THEN

Line 3580: ( 'OE_VALIDATE_LINE',

3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( 'OE_VALIDATE_LINE',
3581: 'Validate_Blanket_Values');
3582: END IF;
3583:
3584: END Validate_Blanket_Values;

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

3624: x_item_type_code := p_line_rec.item_type_code;
3625: x_line_id := p_line_rec.reference_line_id;
3626:
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');
3629: END IF;
3630:
3631: END Get_Return_Line_Attributes;
3632:

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

3806: l_rule_type VARCHAR2(10);
3807:
3808: BEGIN
3809: IF l_debug_level > 0 then
3810: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3811: END IF;
3812:
3813: IF OE_GLOBALS.G_HEADER_CREATED
3814: THEN

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

7682: x_return_status := l_return_status;
7683:
7684: -- Done validating entity
7685: IF l_debug_level > 0 then
7686: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);
7687: END IF;
7688: EXCEPTION
7689:
7690: WHEN FND_API.G_EXC_ERROR THEN

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

7727: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7728:
7729: BEGIN
7730: IF l_debug_level > 0 then
7731: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);
7732: END IF;
7733: x_return_status := FND_API.G_RET_STS_SUCCESS;
7734: l_return_status := FND_API.G_RET_STS_SUCCESS;
7735:

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

8100: ( p_x_line_rec.line_type_id <>
8101: p_old_line_rec.line_type_id OR
8102: p_old_line_rec.line_type_id IS NULL )
8103: THEN
8104: IF NOT OE_Validate.Line_Type(p_x_line_rec.line_type_id) THEN
8105: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8106: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8107: p_x_line_rec.line_type_id := NULL;
8108: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

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

8595: ( p_x_line_rec.flow_status_code <>
8596: p_old_line_rec.flow_status_code OR
8597: p_old_line_rec.flow_status_code IS NULL )
8598: THEN
8599: IF NOT OE_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
8600: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8601: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8602: p_x_line_rec.flow_status_code := NULL;
8603: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND

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

8962: END IF;
8963: --
8964:
8965: IF l_debug_level > 0 then
8966: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);
8967: END IF;
8968:
8969: EXCEPTION
8970:

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

9138:
9139: BEGIN
9140: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4230230
9141: IF l_debug_level > 0 then
9142: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);
9143: END IF;
9144:
9145: -- Bug 2333071 : Excluding Flexfield validation for CONFIG line
9146: -- Fixing 2375476 to skip the Flex field validation in case of

Line 9280: IF NOT OE_VALIDATE.Line_Desc_Flex

9276: oe_debug_pub.add('Before calling line_desc_flex',2);
9277: END IF;
9278: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9279:
9280: IF NOT OE_VALIDATE.Line_Desc_Flex
9281: (p_context => p_x_line_rec.context
9282: ,p_attribute1 => p_x_line_rec.attribute1
9283: ,p_attribute2 => p_x_line_rec.attribute2
9284: ,p_attribute3 => p_x_line_rec.attribute3

Line 10643: END OE_Validate_Line;

10639: END IF;
10640:
10641: END Entity_Delete;
10642:
10643: END OE_Validate_Line;