APPS.OE_BULK_VALIDATE dependencies on OE_BULK_VALIDATE

Line 1: PACKAGE BODY OE_BULK_VALIDATE AS

1: PACKAGE BODY OE_BULK_VALIDATE AS
2: /* $Header: OEBSVATB.pls 120.9.12010000.2 2008/11/18 20:30:09 smusanna ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_VALIDATE';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_VALIDATE';

1: PACKAGE BODY OE_BULK_VALIDATE AS
2: /* $Header: OEBSVATB.pls 120.9.12010000.2 2008/11/18 20:30:09 smusanna ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_VALIDATE';
6:
7: ---------------------------------------------------------------------
8: -- PROCEDURE Pre_Process
9: --

Line 2297: oe_debug_pub.add( 'ENTERING OE_BULK_VALIDATE.Validate_BOM ') ;

2293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2294:
2295: BEGIN
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'ENTERING OE_BULK_VALIDATE.Validate_BOM ') ;
2298: END IF;
2299:
2300:
2301: -- Check if parent exists

Line 2336: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

2332: substr(L.component_code,1,instr(L.component_code,'-',-1,1)-1)
2333: AND L2.top_model_line_id = L.top_model_line_id);
2334:
2335:
2336: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2337: IF SQL%ROWCOUNT > 0 THEN
2338: OE_BULK_VALIDATE.g_error_count := 1;
2339: END IF;
2340: END IF;

Line 2338: OE_BULK_VALIDATE.g_error_count := 1;

2334:
2335:
2336: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2337: IF SQL%ROWCOUNT > 0 THEN
2338: OE_BULK_VALIDATE.g_error_count := 1;
2339: END IF;
2340: END IF;
2341:
2342:

Line 2381: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

2377: AND L2.ordered_quantity > 0
2378: AND ( TRUNC(L.ordered_quantity/L2.ordered_quantity) < L.low_quantity OR
2379: TRUNC(L.ordered_quantity/L2.ordered_quantity) > L.high_quantity );
2380:
2381: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2382: IF SQL%ROWCOUNT > 0 THEN
2383: OE_BULK_VALIDATE.g_error_count := 1;
2384: END IF;
2385: END IF;

Line 2383: OE_BULK_VALIDATE.g_error_count := 1;

2379: TRUNC(L.ordered_quantity/L2.ordered_quantity) > L.high_quantity );
2380:
2381: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2382: IF SQL%ROWCOUNT > 0 THEN
2383: OE_BULK_VALIDATE.g_error_count := 1;
2384: END IF;
2385: END IF;
2386:
2387:

Line 2425: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

2421: and substr(L2.component_code, 1, instr(l2.component_code,'-',-1)-1) =
2422: L.component_code );
2423:
2424:
2425: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2426: IF SQL%ROWCOUNT > 0 THEN
2427: OE_BULK_VALIDATE.g_error_count := 1;
2428: END IF;
2429: END IF;

Line 2427: OE_BULK_VALIDATE.g_error_count := 1;

2423:
2424:
2425: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2426: IF SQL%ROWCOUNT > 0 THEN
2427: OE_BULK_VALIDATE.g_error_count := 1;
2428: END IF;
2429: END IF;
2430:
2431: -- Check for mutually exclusive options

Line 2468: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

2464: L.component_code = substr(L2.component_code, 1,
2465: instr(l2.component_code,'-',-1)-1)
2466: and L2.top_model_line_id = L.top_model_line_id);
2467:
2468: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2469: IF SQL%ROWCOUNT > 0 THEN
2470: OE_BULK_VALIDATE.g_error_count := 1;
2471: END IF;
2472: END IF;

Line 2470: OE_BULK_VALIDATE.g_error_count := 1;

2466: and L2.top_model_line_id = L.top_model_line_id);
2467:
2468: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2469: IF SQL%ROWCOUNT > 0 THEN
2470: OE_BULK_VALIDATE.g_error_count := 1;
2471: END IF;
2472: END IF;
2473:
2474: -- Check for mandatory classes

Line 2523: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

2519: From oe_config_details_tmp L3
2520: Where L.top_model_line_id =
2521: L3.top_model_line_id) );
2522:
2523: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2524: IF SQL%ROWCOUNT > 0 THEN
2525: OE_BULK_VALIDATE.g_error_count := 1;
2526: END IF;
2527: END IF;

Line 2525: OE_BULK_VALIDATE.g_error_count := 1;

2521: L3.top_model_line_id) );
2522:
2523: IF OE_BULK_VALIDATE.g_error_count = 0 THEN
2524: IF SQL%ROWCOUNT > 0 THEN
2525: OE_BULK_VALIDATE.g_error_count := 1;
2526: END IF;
2527: END IF;
2528:
2529:

Line 2531: oe_debug_pub.add('LEAVING OE_BULK_VALIDATE.Validate_BOM' , 1);

2527: END IF;
2528:
2529:
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add('LEAVING OE_BULK_VALIDATE.Validate_BOM' , 1);
2532: END IF;
2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN

Line 2643: END OE_BULK_VALIDATE;

2639: );
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: END MARK_INTERFACE_ERROR;
2642:
2643: END OE_BULK_VALIDATE;