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.QP_VALIDATE_MODIFIERS dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Modifiers AS

1: PACKAGE BODY QP_Validate_Modifiers AS
2: /* $Header: QPXLMLLB.pls 120.3.12000000.2 2007/04/26 04:59:24 rassharm ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXLMLLB.pls 120.3.12000000.2 2007/04/26 04:59:24 rassharm ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Modifiers';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 2263: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN

2259: ( p_MODIFIERS_rec.arithmetic_operator <>
2260: p_old_MODIFIERS_rec.arithmetic_operator OR
2261: p_old_MODIFIERS_rec.arithmetic_operator IS NULL )
2262: THEN
2263: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265: END IF;
2266: END IF;
2267: oe_debug_pub.add('here3');

Line 2274: IF NOT QP_Validate.Automatic(p_MODIFIERS_rec.automatic_flag) THEN

2270: ( p_MODIFIERS_rec.automatic_flag <>
2271: p_old_MODIFIERS_rec.automatic_flag OR
2272: p_old_MODIFIERS_rec.automatic_flag IS NULL )
2273: THEN
2274: IF NOT QP_Validate.Automatic(p_MODIFIERS_rec.automatic_flag) THEN
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2276: END IF;
2277: END IF;
2278:

Line 2284: IF NOT QP_Validate.Base_Qty(p_MODIFIERS_rec.base_qty) THEN

2280: ( p_MODIFIERS_rec.base_qty <>
2281: p_old_MODIFIERS_rec.base_qty OR
2282: p_old_MODIFIERS_rec.base_qty IS NULL )
2283: THEN
2284: IF NOT QP_Validate.Base_Qty(p_MODIFIERS_rec.base_qty) THEN
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286: END IF;
2287: END IF;
2288: */

Line 2294: IF NOT QP_Validate.Pricing_Phase(p_MODIFIERS_rec.pricing_phase_id) THEN

2290: ( p_MODIFIERS_rec.pricing_phase_id <>
2291: p_old_MODIFIERS_rec.pricing_phase_id OR
2292: p_old_MODIFIERS_rec.pricing_phase_id IS NULL )
2293: THEN
2294: IF NOT QP_Validate.Pricing_Phase(p_MODIFIERS_rec.pricing_phase_id) THEN
2295: x_return_status := FND_API.G_RET_STS_ERROR;
2296: END IF;
2297: END IF;
2298:

Line 2305: IF NOT QP_Validate.Base_Uom(p_MODIFIERS_rec.base_uom_code) THEN

2301: ( p_MODIFIERS_rec.base_uom_code <>
2302: p_old_MODIFIERS_rec.base_uom_code OR
2303: p_old_MODIFIERS_rec.base_uom_code IS NULL )
2304: THEN
2305: IF NOT QP_Validate.Base_Uom(p_MODIFIERS_rec.base_uom_code) THEN
2306: x_return_status := FND_API.G_RET_STS_ERROR;
2307: END IF;
2308: END IF;
2309: */

Line 2315: IF NOT QP_Validate.Comments(p_MODIFIERS_rec.comments) THEN

2311: ( p_MODIFIERS_rec.comments <>
2312: p_old_MODIFIERS_rec.comments OR
2313: p_old_MODIFIERS_rec.comments IS NULL )
2314: THEN
2315: IF NOT QP_Validate.Comments(p_MODIFIERS_rec.comments) THEN
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: END IF;
2318: END IF;
2319:

Line 2325: IF NOT QP_Validate.Created_By(p_MODIFIERS_rec.created_by) THEN

2321: ( p_MODIFIERS_rec.created_by <>
2322: p_old_MODIFIERS_rec.created_by OR
2323: p_old_MODIFIERS_rec.created_by IS NULL )
2324: THEN
2325: IF NOT QP_Validate.Created_By(p_MODIFIERS_rec.created_by) THEN
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: END IF;
2328: END IF;
2329:

Line 2335: IF NOT QP_Validate.Creation_Date(p_MODIFIERS_rec.creation_date) THEN

2331: ( p_MODIFIERS_rec.creation_date <>
2332: p_old_MODIFIERS_rec.creation_date OR
2333: p_old_MODIFIERS_rec.creation_date IS NULL )
2334: THEN
2335: IF NOT QP_Validate.Creation_Date(p_MODIFIERS_rec.creation_date) THEN
2336: x_return_status := FND_API.G_RET_STS_ERROR;
2337: END IF;
2338: END IF;
2339:

Line 2345: IF NOT QP_Validate.Effective_Period_Uom(p_MODIFIERS_rec.effective_period_uom) THEN

2341: ( p_MODIFIERS_rec.effective_period_uom <>
2342: p_old_MODIFIERS_rec.effective_period_uom OR
2343: p_old_MODIFIERS_rec.effective_period_uom IS NULL )
2344: THEN
2345: IF NOT QP_Validate.Effective_Period_Uom(p_MODIFIERS_rec.effective_period_uom) THEN
2346: x_return_status := FND_API.G_RET_STS_ERROR;
2347: END IF;
2348: END IF;
2349:

Line 2355: IF NOT QP_Validate.End_Date_Active(p_MODIFIERS_rec.end_date_active) THEN

2351: ( p_MODIFIERS_rec.end_date_active <>
2352: p_old_MODIFIERS_rec.end_date_active OR
2353: p_old_MODIFIERS_rec.end_date_active IS NULL )
2354: THEN
2355: IF NOT QP_Validate.End_Date_Active(p_MODIFIERS_rec.end_date_active) THEN
2356: x_return_status := FND_API.G_RET_STS_ERROR;
2357: END IF;
2358: END IF;
2359:

Line 2365: IF NOT QP_Validate.Estim_Accrual_Rate(p_MODIFIERS_rec.estim_accrual_rate) THEN

2361: ( p_MODIFIERS_rec.estim_accrual_rate <>
2362: p_old_MODIFIERS_rec.estim_accrual_rate OR
2363: p_old_MODIFIERS_rec.estim_accrual_rate IS NULL )
2364: THEN
2365: IF NOT QP_Validate.Estim_Accrual_Rate(p_MODIFIERS_rec.estim_accrual_rate) THEN
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: END IF;
2368: END IF;
2369:

Line 2375: IF NOT QP_Validate.Generate_Using_Formula(p_MODIFIERS_rec.generate_using_formula_id) THEN

2371: ( p_MODIFIERS_rec.generate_using_formula_id <>
2372: p_old_MODIFIERS_rec.generate_using_formula_id OR
2373: p_old_MODIFIERS_rec.generate_using_formula_id IS NULL )
2374: THEN
2375: IF NOT QP_Validate.Generate_Using_Formula(p_MODIFIERS_rec.generate_using_formula_id) THEN
2376: x_return_status := FND_API.G_RET_STS_ERROR;
2377: END IF;
2378: END IF;
2379:

Line 2385: IF NOT QP_Validate.Gl_Class(p_MODIFIERS_rec.gl_class_id) THEN

2381: ( p_MODIFIERS_rec.gl_class_id <>
2382: p_old_MODIFIERS_rec.gl_class_id OR
2383: p_old_MODIFIERS_rec.gl_class_id IS NULL )
2384: THEN
2385: IF NOT QP_Validate.Gl_Class(p_MODIFIERS_rec.gl_class_id) THEN
2386: x_return_status := FND_API.G_RET_STS_ERROR;
2387: END IF;
2388: END IF;
2389: */

Line 2395: IF NOT QP_Validate.Inventory_Item(p_MODIFIERS_rec.inventory_item_id) THEN

2391: ( p_MODIFIERS_rec.inventory_item_id <>
2392: p_old_MODIFIERS_rec.inventory_item_id OR
2393: p_old_MODIFIERS_rec.inventory_item_id IS NULL )
2394: THEN
2395: IF NOT QP_Validate.Inventory_Item(p_MODIFIERS_rec.inventory_item_id) THEN
2396: x_return_status := FND_API.G_RET_STS_ERROR;
2397: END IF;
2398: END IF;
2399:

Line 2405: IF NOT QP_Validate.Last_Updated_By(p_MODIFIERS_rec.last_updated_by) THEN

2401: ( p_MODIFIERS_rec.last_updated_by <>
2402: p_old_MODIFIERS_rec.last_updated_by OR
2403: p_old_MODIFIERS_rec.last_updated_by IS NULL )
2404: THEN
2405: IF NOT QP_Validate.Last_Updated_By(p_MODIFIERS_rec.last_updated_by) THEN
2406: x_return_status := FND_API.G_RET_STS_ERROR;
2407: END IF;
2408: END IF;
2409:

Line 2415: IF NOT QP_Validate.Last_Update_Date(p_MODIFIERS_rec.last_update_date) THEN

2411: ( p_MODIFIERS_rec.last_update_date <>
2412: p_old_MODIFIERS_rec.last_update_date OR
2413: p_old_MODIFIERS_rec.last_update_date IS NULL )
2414: THEN
2415: IF NOT QP_Validate.Last_Update_Date(p_MODIFIERS_rec.last_update_date) THEN
2416: x_return_status := FND_API.G_RET_STS_ERROR;
2417: END IF;
2418: END IF;
2419:

Line 2425: IF NOT QP_Validate.Last_Update_Login(p_MODIFIERS_rec.last_update_login) THEN

2421: ( p_MODIFIERS_rec.last_update_login <>
2422: p_old_MODIFIERS_rec.last_update_login OR
2423: p_old_MODIFIERS_rec.last_update_login IS NULL )
2424: THEN
2425: IF NOT QP_Validate.Last_Update_Login(p_MODIFIERS_rec.last_update_login) THEN
2426: x_return_status := FND_API.G_RET_STS_ERROR;
2427: END IF;
2428: END IF;
2429:

Line 2436: IF NOT QP_Validate.List_Header(p_MODIFIERS_rec.list_header_id) THEN

2432: ( p_MODIFIERS_rec.list_header_id <>
2433: p_old_MODIFIERS_rec.list_header_id OR
2434: p_old_MODIFIERS_rec.list_header_id IS NULL )
2435: THEN
2436: IF NOT QP_Validate.List_Header(p_MODIFIERS_rec.list_header_id) THEN
2437: x_return_status := FND_API.G_RET_STS_ERROR;
2438: END IF;
2439: END IF;
2440:

Line 2446: IF NOT QP_Validate.List_Line(p_MODIFIERS_rec.list_line_id) THEN

2442: ( p_MODIFIERS_rec.list_line_id <>
2443: p_old_MODIFIERS_rec.list_line_id OR
2444: p_old_MODIFIERS_rec.list_line_id IS NULL )
2445: THEN
2446: IF NOT QP_Validate.List_Line(p_MODIFIERS_rec.list_line_id) THEN
2447: x_return_status := FND_API.G_RET_STS_ERROR;
2448: END IF;
2449: END IF;
2450:

Line 2456: IF NOT QP_Validate.List_Line_Type(p_MODIFIERS_rec.list_line_type_code) THEN

2452: ( p_MODIFIERS_rec.list_line_type_code <>
2453: p_old_MODIFIERS_rec.list_line_type_code OR
2454: p_old_MODIFIERS_rec.list_line_type_code IS NULL )
2455: THEN
2456: IF NOT QP_Validate.List_Line_Type(p_MODIFIERS_rec.list_line_type_code) THEN
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: END IF;
2459: END IF;
2460:

Line 2466: IF NOT QP_Validate.List_Price(p_MODIFIERS_rec.list_price) THEN

2462: ( p_MODIFIERS_rec.list_price <>
2463: p_old_MODIFIERS_rec.list_price OR
2464: p_old_MODIFIERS_rec.list_price IS NULL )
2465: THEN
2466: IF NOT QP_Validate.List_Price(p_MODIFIERS_rec.list_price) THEN
2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END IF;
2469: END IF;
2470:

Line 2476: IF NOT QP_Validate.List_Price_Uom(p_MODIFIERS_rec.list_price_uom_code) THEN

2472: ( p_MODIFIERS_rec.list_price_uom_code <>
2473: p_old_MODIFIERS_rec.list_price_uom_code OR
2474: p_old_MODIFIERS_rec.list_price_uom_code IS NULL )
2475: THEN
2476: IF NOT QP_Validate.List_Price_Uom(p_MODIFIERS_rec.list_price_uom_code) THEN
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: END IF;
2479: END IF;
2480: */

Line 2486: IF NOT QP_Validate.Modifier_Level(p_MODIFIERS_rec.modifier_level_code) THEN

2482: ( p_MODIFIERS_rec.modifier_level_code <>
2483: p_old_MODIFIERS_rec.modifier_level_code OR
2484: p_old_MODIFIERS_rec.modifier_level_code IS NULL )
2485: THEN
2486: IF NOT QP_Validate.Modifier_Level(p_MODIFIERS_rec.modifier_level_code) THEN
2487: x_return_status := FND_API.G_RET_STS_ERROR;
2488: END IF;
2489: END IF;
2490:

Line 2496: IF NOT QP_Validate.New_Price(p_MODIFIERS_rec.new_price) THEN

2492: ( p_MODIFIERS_rec.new_price <>
2493: p_old_MODIFIERS_rec.new_price OR
2494: p_old_MODIFIERS_rec.new_price IS NULL )
2495: THEN
2496: IF NOT QP_Validate.New_Price(p_MODIFIERS_rec.new_price) THEN
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: END IF;
2499: END IF;
2500: */

Line 2506: IF NOT QP_Validate.Number_Effective_Periods(p_MODIFIERS_rec.number_effective_periods) THEN

2502: ( p_MODIFIERS_rec.number_effective_periods <>
2503: p_old_MODIFIERS_rec.number_effective_periods OR
2504: p_old_MODIFIERS_rec.number_effective_periods IS NULL )
2505: THEN
2506: IF NOT QP_Validate.Number_Effective_Periods(p_MODIFIERS_rec.number_effective_periods) THEN
2507: x_return_status := FND_API.G_RET_STS_ERROR;
2508: END IF;
2509: END IF;
2510:

Line 2518: IF NOT QP_Validate.Operand(p_MODIFIERS_rec.operand) THEN

2514: p_old_MODIFIERS_rec.operand OR
2515: p_old_MODIFIERS_rec.operand IS NULL )
2516: THEN
2517: oe_debug_pub.add('here7');
2518: IF NOT QP_Validate.Operand(p_MODIFIERS_rec.operand) THEN
2519: oe_debug_pub.add('here8');
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END IF;
2522: END IF;

Line 2530: IF NOT QP_Validate.Organization(p_MODIFIERS_rec.organization_id) THEN

2526: ( p_MODIFIERS_rec.organization_id <>
2527: p_old_MODIFIERS_rec.organization_id OR
2528: p_old_MODIFIERS_rec.organization_id IS NULL )
2529: THEN
2530: IF NOT QP_Validate.Organization(p_MODIFIERS_rec.organization_id) THEN
2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532: END IF;
2533: END IF;
2534:

Line 2541: IF NOT QP_Validate.Override(p_MODIFIERS_rec.override_flag) THEN

2537: ( p_MODIFIERS_rec.override_flag <>
2538: p_old_MODIFIERS_rec.override_flag OR
2539: p_old_MODIFIERS_rec.override_flag IS NULL )
2540: THEN
2541: IF NOT QP_Validate.Override(p_MODIFIERS_rec.override_flag) THEN
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: END IF;
2544: END IF;
2545:

Line 2552: IF NOT QP_Validate.Percent_Price(p_MODIFIERS_rec.percent_price) THEN

2548: ( p_MODIFIERS_rec.percent_price <>
2549: p_old_MODIFIERS_rec.percent_price OR
2550: p_old_MODIFIERS_rec.percent_price IS NULL )
2551: THEN
2552: IF NOT QP_Validate.Percent_Price(p_MODIFIERS_rec.percent_price) THEN
2553: x_return_status := FND_API.G_RET_STS_ERROR;
2554: END IF;
2555: END IF;
2556:

Line 2562: IF NOT QP_Validate.Price_Break_Type(p_MODIFIERS_rec.price_break_type_code) THEN

2558: ( p_MODIFIERS_rec.price_break_type_code <>
2559: p_old_MODIFIERS_rec.price_break_type_code OR
2560: p_old_MODIFIERS_rec.price_break_type_code IS NULL )
2561: THEN
2562: IF NOT QP_Validate.Price_Break_Type(p_MODIFIERS_rec.price_break_type_code) THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: END IF;
2565: END IF;
2566:

Line 2572: IF NOT QP_Validate.Price_By_Formula(p_MODIFIERS_rec.price_by_formula_id) THEN

2568: ( p_MODIFIERS_rec.price_by_formula_id <>
2569: p_old_MODIFIERS_rec.price_by_formula_id OR
2570: p_old_MODIFIERS_rec.price_by_formula_id IS NULL )
2571: THEN
2572: IF NOT QP_Validate.Price_By_Formula(p_MODIFIERS_rec.price_by_formula_id) THEN
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: END IF;
2575: END IF;
2576:

Line 2582: IF NOT QP_Validate.Primary_Uom(p_MODIFIERS_rec.primary_uom_flag) THEN

2578: ( p_MODIFIERS_rec.primary_uom_flag <>
2579: p_old_MODIFIERS_rec.primary_uom_flag OR
2580: p_old_MODIFIERS_rec.primary_uom_flag IS NULL )
2581: THEN
2582: IF NOT QP_Validate.Primary_Uom(p_MODIFIERS_rec.primary_uom_flag) THEN
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: END IF;
2585: END IF;
2586:

Line 2592: IF NOT QP_Validate.Print_On_Invoice(p_MODIFIERS_rec.print_on_invoice_flag) THEN

2588: ( p_MODIFIERS_rec.print_on_invoice_flag <>
2589: p_old_MODIFIERS_rec.print_on_invoice_flag OR
2590: p_old_MODIFIERS_rec.print_on_invoice_flag IS NULL )
2591: THEN
2592: IF NOT QP_Validate.Print_On_Invoice(p_MODIFIERS_rec.print_on_invoice_flag) THEN
2593: x_return_status := FND_API.G_RET_STS_ERROR;
2594: END IF;
2595: END IF;
2596:

Line 2602: IF NOT QP_Validate.Program_Application(p_MODIFIERS_rec.program_application_id) THEN

2598: ( p_MODIFIERS_rec.program_application_id <>
2599: p_old_MODIFIERS_rec.program_application_id OR
2600: p_old_MODIFIERS_rec.program_application_id IS NULL )
2601: THEN
2602: IF NOT QP_Validate.Program_Application(p_MODIFIERS_rec.program_application_id) THEN
2603: x_return_status := FND_API.G_RET_STS_ERROR;
2604: END IF;
2605: END IF;
2606:

Line 2612: IF NOT QP_Validate.Program(p_MODIFIERS_rec.program_id) THEN

2608: ( p_MODIFIERS_rec.program_id <>
2609: p_old_MODIFIERS_rec.program_id OR
2610: p_old_MODIFIERS_rec.program_id IS NULL )
2611: THEN
2612: IF NOT QP_Validate.Program(p_MODIFIERS_rec.program_id) THEN
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: END IF;
2615: END IF;
2616:

Line 2622: IF NOT QP_Validate.Program_Update_Date(p_MODIFIERS_rec.program_update_date) THEN

2618: ( p_MODIFIERS_rec.program_update_date <>
2619: p_old_MODIFIERS_rec.program_update_date OR
2620: p_old_MODIFIERS_rec.program_update_date IS NULL )
2621: THEN
2622: IF NOT QP_Validate.Program_Update_Date(p_MODIFIERS_rec.program_update_date) THEN
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;
2625: END IF;
2626:

Line 2632: IF NOT QP_Validate.Rebate_Subtype(p_MODIFIERS_rec.rebate_subtype_code) THEN

2628: ( p_MODIFIERS_rec.rebate_subtype_code <>
2629: p_old_MODIFIERS_rec.rebate_subtype_code OR
2630: p_old_MODIFIERS_rec.rebate_subtype_code IS NULL )
2631: THEN
2632: IF NOT QP_Validate.Rebate_Subtype(p_MODIFIERS_rec.rebate_subtype_code) THEN
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: END IF;
2635: END IF;
2636: */

Line 2642: IF NOT QP_Validate.Rebate_Transaction_Type(p_MODIFIERS_rec.rebate_trxn_type_code) THEN

2638: ( p_MODIFIERS_rec.rebate_trxn_type_code <>
2639: p_old_MODIFIERS_rec.rebate_trxn_type_code OR
2640: p_old_MODIFIERS_rec.rebate_trxn_type_code IS NULL )
2641: THEN
2642: IF NOT QP_Validate.Rebate_Transaction_Type(p_MODIFIERS_rec.rebate_trxn_type_code) THEN
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: END IF;
2645: END IF;
2646:

Line 2652: IF NOT QP_Validate.Related_Item(p_MODIFIERS_rec.related_item_id) THEN

2648: ( p_MODIFIERS_rec.related_item_id <>
2649: p_old_MODIFIERS_rec.related_item_id OR
2650: p_old_MODIFIERS_rec.related_item_id IS NULL )
2651: THEN
2652: IF NOT QP_Validate.Related_Item(p_MODIFIERS_rec.related_item_id) THEN
2653: x_return_status := FND_API.G_RET_STS_ERROR;
2654: END IF;
2655: END IF;
2656:

Line 2662: IF NOT QP_Validate.Relationship_Type(p_MODIFIERS_rec.relationship_type_id) THEN

2658: ( p_MODIFIERS_rec.relationship_type_id <>
2659: p_old_MODIFIERS_rec.relationship_type_id OR
2660: p_old_MODIFIERS_rec.relationship_type_id IS NULL )
2661: THEN
2662: IF NOT QP_Validate.Relationship_Type(p_MODIFIERS_rec.relationship_type_id) THEN
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: END IF;
2665: END IF;
2666:

Line 2672: IF NOT QP_Validate.Reprice(p_MODIFIERS_rec.reprice_flag) THEN

2668: ( p_MODIFIERS_rec.reprice_flag <>
2669: p_old_MODIFIERS_rec.reprice_flag OR
2670: p_old_MODIFIERS_rec.reprice_flag IS NULL )
2671: THEN
2672: IF NOT QP_Validate.Reprice(p_MODIFIERS_rec.reprice_flag) THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: END IF;
2675: END IF;
2676:

Line 2682: IF NOT QP_Validate.Request(p_MODIFIERS_rec.request_id) THEN

2678: ( p_MODIFIERS_rec.request_id <>
2679: p_old_MODIFIERS_rec.request_id OR
2680: p_old_MODIFIERS_rec.request_id IS NULL )
2681: THEN
2682: IF NOT QP_Validate.Request(p_MODIFIERS_rec.request_id) THEN
2683: x_return_status := FND_API.G_RET_STS_ERROR;
2684: END IF;
2685: END IF;
2686:

Line 2692: IF NOT QP_Validate.Revision(p_MODIFIERS_rec.revision) THEN

2688: ( p_MODIFIERS_rec.revision <>
2689: p_old_MODIFIERS_rec.revision OR
2690: p_old_MODIFIERS_rec.revision IS NULL )
2691: THEN
2692: IF NOT QP_Validate.Revision(p_MODIFIERS_rec.revision) THEN
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: END IF;
2695: END IF;
2696:

Line 2702: IF NOT QP_Validate.Revision_Date(p_MODIFIERS_rec.revision_date) THEN

2698: ( p_MODIFIERS_rec.revision_date <>
2699: p_old_MODIFIERS_rec.revision_date OR
2700: p_old_MODIFIERS_rec.revision_date IS NULL )
2701: THEN
2702: IF NOT QP_Validate.Revision_Date(p_MODIFIERS_rec.revision_date) THEN
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: END IF;
2705: END IF;
2706:

Line 2712: IF NOT QP_Validate.Revision_Reason(p_MODIFIERS_rec.revision_reason_code) THEN

2708: ( p_MODIFIERS_rec.revision_reason_code <>
2709: p_old_MODIFIERS_rec.revision_reason_code OR
2710: p_old_MODIFIERS_rec.revision_reason_code IS NULL )
2711: THEN
2712: IF NOT QP_Validate.Revision_Reason(p_MODIFIERS_rec.revision_reason_code) THEN
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2714: END IF;
2715: END IF;
2716:

Line 2722: IF NOT QP_Validate.Start_Date_Active(p_MODIFIERS_rec.start_date_active) THEN

2718: ( p_MODIFIERS_rec.start_date_active <>
2719: p_old_MODIFIERS_rec.start_date_active OR
2720: p_old_MODIFIERS_rec.start_date_active IS NULL )
2721: THEN
2722: IF NOT QP_Validate.Start_Date_Active(p_MODIFIERS_rec.start_date_active) THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: END IF;
2725: END IF;
2726:

Line 2732: IF NOT QP_Validate.Substitution_Attribute(p_MODIFIERS_rec.substitution_attribute) THEN

2728: ( p_MODIFIERS_rec.substitution_attribute <>
2729: p_old_MODIFIERS_rec.substitution_attribute OR
2730: p_old_MODIFIERS_rec.substitution_attribute IS NULL )
2731: THEN
2732: IF NOT QP_Validate.Substitution_Attribute(p_MODIFIERS_rec.substitution_attribute) THEN
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: END IF;
2735: END IF;
2736:

Line 2742: IF NOT QP_Validate.Substitution_Context(p_MODIFIERS_rec.substitution_context) THEN

2738: ( p_MODIFIERS_rec.substitution_context <>
2739: p_old_MODIFIERS_rec.substitution_context OR
2740: p_old_MODIFIERS_rec.substitution_context IS NULL )
2741: THEN
2742: IF NOT QP_Validate.Substitution_Context(p_MODIFIERS_rec.substitution_context) THEN
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: END IF;
2745: END IF;
2746:

Line 2752: IF NOT QP_Validate.Substitution_Value(p_MODIFIERS_rec.substitution_value) THEN

2748: ( p_MODIFIERS_rec.substitution_value <>
2749: p_old_MODIFIERS_rec.substitution_value OR
2750: p_old_MODIFIERS_rec.substitution_value IS NULL )
2751: THEN
2752: IF NOT QP_Validate.Substitution_Value(p_MODIFIERS_rec.substitution_value) THEN
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: END IF;
2755: END IF;
2756:

Line 2762: IF NOT QP_Validate.Accrual_Flag(p_MODIFIERS_rec.accrual_flag) THEN

2758: ( p_MODIFIERS_rec.accrual_flag <>
2759: p_old_MODIFIERS_rec.accrual_flag OR
2760: p_old_MODIFIERS_rec.accrual_flag IS NULL )
2761: THEN
2762: IF NOT QP_Validate.Accrual_Flag(p_MODIFIERS_rec.accrual_flag) THEN
2763: x_return_status := FND_API.G_RET_STS_ERROR;
2764: END IF;
2765: END IF;
2766:

Line 2772: IF NOT QP_Validate.Pricing_Group_Sequence(p_MODIFIERS_rec.pricing_group_sequence) THEN

2768: ( p_MODIFIERS_rec.pricing_group_sequence <>
2769: p_old_MODIFIERS_rec.pricing_group_sequence OR
2770: p_old_MODIFIERS_rec.pricing_group_sequence IS NULL )
2771: THEN
2772: IF NOT QP_Validate.Pricing_Group_Sequence(p_MODIFIERS_rec.pricing_group_sequence) THEN
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: END IF;
2775: END IF;
2776: oe_debug_pub.add('here12');

Line 2782: IF NOT QP_Validate.Incompatibility_Grp_Code(p_MODIFIERS_rec.incompatibility_grp_code) THEN

2778: ( p_MODIFIERS_rec.incompatibility_grp_code <>
2779: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2780: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )
2781: THEN
2782: IF NOT QP_Validate.Incompatibility_Grp_Code(p_MODIFIERS_rec.incompatibility_grp_code) THEN
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: END IF;
2785: END IF;
2786:

Line 2793: IF NOT QP_Validate.List_Line_No(p_MODIFIERS_rec.list_line_no) THEN

2789: ( p_MODIFIERS_rec.list_line_no <>
2790: p_old_MODIFIERS_rec.list_line_no OR
2791: p_old_MODIFIERS_rec.list_line_no IS NULL )
2792: THEN
2793: IF NOT QP_Validate.List_Line_No(p_MODIFIERS_rec.list_line_no) THEN
2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795: END IF;
2796: END IF;
2797:

Line 2803: IF NOT QP_Validate.Product_Precedence(p_MODIFIERS_rec.product_precedence) THEN

2799: ( p_MODIFIERS_rec.product_precedence <>
2800: p_old_MODIFIERS_rec.product_precedence OR
2801: p_old_MODIFIERS_rec.product_precedence IS NULL )
2802: THEN
2803: IF NOT QP_Validate.Product_Precedence(p_MODIFIERS_rec.product_precedence) THEN
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: END IF;
2806: END IF;
2807:

Line 2813: IF NOT QP_Validate.Exp_Period_Start_Date(p_MODIFIERS_rec.expiration_period_start_date) THEN

2809: ( p_MODIFIERS_rec.expiration_period_start_date <>
2810: p_old_MODIFIERS_rec.expiration_period_start_date OR
2811: p_old_MODIFIERS_rec.expiration_period_start_date IS NULL )
2812: THEN
2813: IF NOT QP_Validate.Exp_Period_Start_Date(p_MODIFIERS_rec.expiration_period_start_date) THEN
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: END IF;
2816: END IF;
2817:

Line 2823: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN

2819: ( p_MODIFIERS_rec.number_expiration_periods <>
2820: p_old_MODIFIERS_rec.number_expiration_periods OR
2821: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2822: THEN
2823: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: END IF;
2826: END IF;
2827:

Line 2833: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN

2829: ( p_MODIFIERS_rec.number_expiration_periods <>
2830: p_old_MODIFIERS_rec.number_expiration_periods OR
2831: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2832: THEN
2833: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: END IF;
2836: END IF;
2837:

Line 2843: IF NOT QP_Validate.Expiration_Period_Uom(p_MODIFIERS_rec.expiration_period_uom) THEN

2839: ( p_MODIFIERS_rec.expiration_period_uom <>
2840: p_old_MODIFIERS_rec.expiration_period_uom OR
2841: p_old_MODIFIERS_rec.expiration_period_uom IS NULL )
2842: THEN
2843: IF NOT QP_Validate.Expiration_Period_Uom(p_MODIFIERS_rec.expiration_period_uom) THEN
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: END IF;
2846: END IF;
2847:

Line 2853: IF NOT QP_Validate.Expiration_Date(p_MODIFIERS_rec.expiration_date) THEN

2849: ( p_MODIFIERS_rec.expiration_date <>
2850: p_old_MODIFIERS_rec.expiration_date OR
2851: p_old_MODIFIERS_rec.expiration_date IS NULL )
2852: THEN
2853: IF NOT QP_Validate.Expiration_Date(p_MODIFIERS_rec.expiration_date) THEN
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: END IF;
2856: END IF;
2857:

Line 2863: IF NOT QP_Validate.Estim_Gl_Value(p_MODIFIERS_rec.estim_gl_value) THEN

2859: ( p_MODIFIERS_rec.estim_gl_value <>
2860: p_old_MODIFIERS_rec.estim_gl_value OR
2861: p_old_MODIFIERS_rec.estim_gl_value IS NULL )
2862: THEN
2863: IF NOT QP_Validate.Estim_Gl_Value(p_MODIFIERS_rec.estim_gl_value) THEN
2864: x_return_status := FND_API.G_RET_STS_ERROR;
2865: END IF;
2866: END IF;
2867:

Line 2873: IF NOT QP_Validate.Ben_Price_List_Line(p_MODIFIERS_rec.benefit_price_list_line_id) THEN

2869: ( p_MODIFIERS_rec.benefit_price_list_line_id <>
2870: p_old_MODIFIERS_rec.benefit_price_list_line_id OR
2871: p_old_MODIFIERS_rec.benefit_price_list_line_id IS NULL )
2872: THEN
2873: IF NOT QP_Validate.Ben_Price_List_Line(p_MODIFIERS_rec.benefit_price_list_line_id) THEN
2874: x_return_status := FND_API.G_RET_STS_ERROR;
2875: END IF;
2876: END IF;
2877:

Line 2883: IF NOT QP_Validate.Recurring(p_MODIFIERS_rec.recurring_flag) THEN

2879: ( p_MODIFIERS_rec.recurring_flag <>
2880: p_old_MODIFIERS_rec.recurring_flag OR
2881: p_old_MODIFIERS_rec.recurring_flag IS NULL )
2882: THEN
2883: IF NOT QP_Validate.Recurring(p_MODIFIERS_rec.recurring_flag) THEN
2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: END IF;
2886: END IF;
2887: */

Line 2893: IF NOT QP_Validate.Benefit_Limit(p_MODIFIERS_rec.benefit_limit) THEN

2889: ( p_MODIFIERS_rec.benefit_limit <>
2890: p_old_MODIFIERS_rec.benefit_limit OR
2891: p_old_MODIFIERS_rec.benefit_limit IS NULL )
2892: THEN
2893: IF NOT QP_Validate.Benefit_Limit(p_MODIFIERS_rec.benefit_limit) THEN
2894: x_return_status := FND_API.G_RET_STS_ERROR;
2895: END IF;
2896: END IF;
2897:

Line 2903: IF NOT QP_Validate.Charge_Type(p_MODIFIERS_rec.charge_type_code) THEN

2899: ( p_MODIFIERS_rec.charge_type_code <>
2900: p_old_MODIFIERS_rec.charge_type_code OR
2901: p_old_MODIFIERS_rec.charge_type_code IS NULL )
2902: THEN
2903: IF NOT QP_Validate.Charge_Type(p_MODIFIERS_rec.charge_type_code) THEN
2904: x_return_status := FND_API.G_RET_STS_ERROR;
2905: END IF;
2906: END IF;
2907:

Line 2913: IF NOT QP_Validate.Charge_Subtype(p_MODIFIERS_rec.charge_subtype_code) THEN

2909: ( p_MODIFIERS_rec.charge_subtype_code <>
2910: p_old_MODIFIERS_rec.charge_subtype_code OR
2911: p_old_MODIFIERS_rec.charge_subtype_code IS NULL )
2912: THEN
2913: IF NOT QP_Validate.Charge_Subtype(p_MODIFIERS_rec.charge_subtype_code) THEN
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END IF;
2916: END IF;
2917:

Line 2923: IF NOT QP_Validate.Benefit_Qty(p_MODIFIERS_rec.benefit_qty) THEN

2919: ( p_MODIFIERS_rec.benefit_qty <>
2920: p_old_MODIFIERS_rec.benefit_qty OR
2921: p_old_MODIFIERS_rec.benefit_qty IS NULL )
2922: THEN
2923: IF NOT QP_Validate.Benefit_Qty(p_MODIFIERS_rec.benefit_qty) THEN
2924: x_return_status := FND_API.G_RET_STS_ERROR;
2925: END IF;
2926: END IF;
2927:

Line 2933: IF NOT QP_Validate.Benefit_Uom(p_MODIFIERS_rec.benefit_uom_code) THEN

2929: ( p_MODIFIERS_rec.benefit_uom_code <>
2930: p_old_MODIFIERS_rec.benefit_uom_code OR
2931: p_old_MODIFIERS_rec.benefit_uom_code IS NULL )
2932: THEN
2933: IF NOT QP_Validate.Benefit_Uom(p_MODIFIERS_rec.benefit_uom_code) THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935: END IF;
2936: END IF;
2937:

Line 2943: IF NOT QP_Validate.Accrual_Conversion_Rate(p_MODIFIERS_rec.accrual_conversion_rate) THEN

2939: ( p_MODIFIERS_rec.accrual_conversion_rate <>
2940: p_old_MODIFIERS_rec.accrual_conversion_rate OR
2941: p_old_MODIFIERS_rec.accrual_conversion_rate IS NULL )
2942: THEN
2943: IF NOT QP_Validate.Accrual_Conversion_Rate(p_MODIFIERS_rec.accrual_conversion_rate) THEN
2944: x_return_status := FND_API.G_RET_STS_ERROR;
2945: END IF;
2946: END IF;
2947:

Line 2953: IF NOT QP_Validate.Proration_Type(p_MODIFIERS_rec.proration_type_code) THEN

2949: ( p_MODIFIERS_rec.proration_type_code <>
2950: p_old_MODIFIERS_rec.proration_type_code OR
2951: p_old_MODIFIERS_rec.proration_type_code IS NULL )
2952: THEN
2953: IF NOT QP_Validate.Proration_Type(p_MODIFIERS_rec.proration_type_code) THEN
2954: x_return_status := FND_API.G_RET_STS_ERROR;
2955: END IF;
2956: END IF;
2957:

Line 2963: IF NOT QP_Validate.From_Rltd_Modifier(p_MODIFIERS_rec.from_rltd_modifier_id) THEN

2959: ( p_MODIFIERS_rec.from_rltd_modifier_id <>
2960: p_old_MODIFIERS_rec.from_rltd_modifier_id OR
2961: p_old_MODIFIERS_rec.from_rltd_modifier_id IS NULL )
2962: THEN
2963: IF NOT QP_Validate.From_Rltd_Modifier(p_MODIFIERS_rec.from_rltd_modifier_id) THEN
2964: x_return_status := FND_API.G_RET_STS_ERROR;
2965: END IF;
2966: END IF;
2967:

Line 2973: IF NOT QP_Validate.To_Rltd_Modifier(p_MODIFIERS_rec.to_rltd_modifier_id) THEN

2969: ( p_MODIFIERS_rec.to_rltd_modifier_id <>
2970: p_old_MODIFIERS_rec.to_rltd_modifier_id OR
2971: p_old_MODIFIERS_rec.to_rltd_modifier_id IS NULL )
2972: THEN
2973: IF NOT QP_Validate.To_Rltd_Modifier(p_MODIFIERS_rec.to_rltd_modifier_id) THEN
2974: x_return_status := FND_API.G_RET_STS_ERROR;
2975: END IF;
2976: END IF;
2977:

Line 2983: IF NOT QP_Validate.Rltd_Modifier_Grp_No(p_MODIFIERS_rec.rltd_modifier_grp_no) THEN

2979: ( p_MODIFIERS_rec.rltd_modifier_grp_no <>
2980: p_old_MODIFIERS_rec.rltd_modifier_grp_no OR
2981: p_old_MODIFIERS_rec.rltd_modifier_grp_no IS NULL )
2982: THEN
2983: IF NOT QP_Validate.Rltd_Modifier_Grp_No(p_MODIFIERS_rec.rltd_modifier_grp_no) THEN
2984: x_return_status := FND_API.G_RET_STS_ERROR;
2985: END IF;
2986: END IF;
2987:

Line 2993: IF NOT QP_Validate.Rltd_Modifier_Grp_Type(p_MODIFIERS_rec.rltd_modifier_grp_type) THEN

2989: ( p_MODIFIERS_rec.rltd_modifier_grp_type <>
2990: p_old_MODIFIERS_rec.rltd_modifier_grp_type OR
2991: p_old_MODIFIERS_rec.rltd_modifier_grp_type IS NULL )
2992: THEN
2993: IF NOT QP_Validate.Rltd_Modifier_Grp_Type(p_MODIFIERS_rec.rltd_modifier_grp_type) THEN
2994: x_return_status := FND_API.G_RET_STS_ERROR;
2995: END IF;
2996: END IF;
2997:

Line 3004: IF NOT QP_Validate.Net_Amount(p_MODIFIERS_rec.net_amount_flag) THEN

3000: ( p_MODIFIERS_rec.net_amount_flag <>
3001: p_old_MODIFIERS_rec.net_amount_flag OR
3002: p_old_MODIFIERS_rec.net_amount_flag IS NULL )
3003: THEN
3004: IF NOT QP_Validate.Net_Amount(p_MODIFIERS_rec.net_amount_flag) THEN
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: END IF;
3007: END IF;
3008:

Line 3015: IF NOT QP_Validate.Accum_Attribute(p_MODIFIERS_rec.accum_attribute) THEN

3011: ( p_MODIFIERS_rec.accum_attribute <>
3012: p_old_MODIFIERS_rec.accum_attribute OR
3013: p_old_MODIFIERS_rec.accum_attribute IS NULL )
3014: THEN
3015: IF NOT QP_Validate.Accum_Attribute(p_MODIFIERS_rec.accum_attribute) THEN
3016: x_return_status := FND_API.G_RET_STS_ERROR;
3017: END IF;
3018: END IF;
3019:

Line 3160: IF NOT QP_Validate.Desc_Flex( 'MODIFIERS' ) THEN

3156: */
3157:
3158: -- Validate descriptive flexfield.
3159:
3160: IF NOT QP_Validate.Desc_Flex( 'MODIFIERS' ) THEN
3161: x_return_status := FND_API.G_RET_STS_ERROR;
3162: END IF;
3163:
3164: END IF;

Line 3248: END QP_Validate_Modifiers;

3244: END IF;
3245:
3246: END Entity_Delete;
3247:
3248: END QP_Validate_Modifiers;