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.5.12020000.4 2013/05/09 10:01:24 jputta 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.5.12020000.4 2013/05/09 10:01:24 jputta 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 2276: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN

2272: ( p_MODIFIERS_rec.arithmetic_operator <>
2273: p_old_MODIFIERS_rec.arithmetic_operator OR
2274: p_old_MODIFIERS_rec.arithmetic_operator IS NULL )
2275: THEN
2276: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN
2277: x_return_status := FND_API.G_RET_STS_ERROR;
2278: END IF;
2279: END IF;
2280: oe_debug_pub.add('here3');

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

2283: ( p_MODIFIERS_rec.automatic_flag <>
2284: p_old_MODIFIERS_rec.automatic_flag OR
2285: p_old_MODIFIERS_rec.automatic_flag IS NULL )
2286: THEN
2287: IF NOT QP_Validate.Automatic(p_MODIFIERS_rec.automatic_flag) THEN
2288: x_return_status := FND_API.G_RET_STS_ERROR;
2289: END IF;
2290: END IF;
2291:

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

2293: ( p_MODIFIERS_rec.base_qty <>
2294: p_old_MODIFIERS_rec.base_qty OR
2295: p_old_MODIFIERS_rec.base_qty IS NULL )
2296: THEN
2297: IF NOT QP_Validate.Base_Qty(p_MODIFIERS_rec.base_qty) THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: END IF;
2300: END IF;
2301: */

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

2303: ( p_MODIFIERS_rec.pricing_phase_id <>
2304: p_old_MODIFIERS_rec.pricing_phase_id OR
2305: p_old_MODIFIERS_rec.pricing_phase_id IS NULL )
2306: THEN
2307: IF NOT QP_Validate.Pricing_Phase(p_MODIFIERS_rec.pricing_phase_id) THEN
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309: END IF;
2310: END IF;
2311:

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

2314: ( p_MODIFIERS_rec.base_uom_code <>
2315: p_old_MODIFIERS_rec.base_uom_code OR
2316: p_old_MODIFIERS_rec.base_uom_code IS NULL )
2317: THEN
2318: IF NOT QP_Validate.Base_Uom(p_MODIFIERS_rec.base_uom_code) THEN
2319: x_return_status := FND_API.G_RET_STS_ERROR;
2320: END IF;
2321: END IF;
2322: */

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

2324: ( p_MODIFIERS_rec.comments <>
2325: p_old_MODIFIERS_rec.comments OR
2326: p_old_MODIFIERS_rec.comments IS NULL )
2327: THEN
2328: IF NOT QP_Validate.Comments(p_MODIFIERS_rec.comments) THEN
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: END IF;
2331: END IF;
2332:

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

2334: ( p_MODIFIERS_rec.created_by <>
2335: p_old_MODIFIERS_rec.created_by OR
2336: p_old_MODIFIERS_rec.created_by IS NULL )
2337: THEN
2338: IF NOT QP_Validate.Created_By(p_MODIFIERS_rec.created_by) THEN
2339: x_return_status := FND_API.G_RET_STS_ERROR;
2340: END IF;
2341: END IF;
2342:

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

2344: ( p_MODIFIERS_rec.creation_date <>
2345: p_old_MODIFIERS_rec.creation_date OR
2346: p_old_MODIFIERS_rec.creation_date IS NULL )
2347: THEN
2348: IF NOT QP_Validate.Creation_Date(p_MODIFIERS_rec.creation_date) THEN
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: END IF;
2351: END IF;
2352:

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

2354: ( p_MODIFIERS_rec.effective_period_uom <>
2355: p_old_MODIFIERS_rec.effective_period_uom OR
2356: p_old_MODIFIERS_rec.effective_period_uom IS NULL )
2357: THEN
2358: IF NOT QP_Validate.Effective_Period_Uom(p_MODIFIERS_rec.effective_period_uom) THEN
2359: x_return_status := FND_API.G_RET_STS_ERROR;
2360: END IF;
2361: END IF;
2362:

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

2364: ( p_MODIFIERS_rec.end_date_active <>
2365: p_old_MODIFIERS_rec.end_date_active OR
2366: p_old_MODIFIERS_rec.end_date_active IS NULL )
2367: THEN
2368: IF NOT QP_Validate.End_Date_Active(p_MODIFIERS_rec.end_date_active) THEN
2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370: END IF;
2371: END IF;
2372:

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

2374: ( p_MODIFIERS_rec.estim_accrual_rate <>
2375: p_old_MODIFIERS_rec.estim_accrual_rate OR
2376: p_old_MODIFIERS_rec.estim_accrual_rate IS NULL )
2377: THEN
2378: IF NOT QP_Validate.Estim_Accrual_Rate(p_MODIFIERS_rec.estim_accrual_rate) THEN
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: END IF;
2381: END IF;
2382:

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

2384: ( p_MODIFIERS_rec.generate_using_formula_id <>
2385: p_old_MODIFIERS_rec.generate_using_formula_id OR
2386: p_old_MODIFIERS_rec.generate_using_formula_id IS NULL )
2387: THEN
2388: IF NOT QP_Validate.Generate_Using_Formula(p_MODIFIERS_rec.generate_using_formula_id) THEN
2389: x_return_status := FND_API.G_RET_STS_ERROR;
2390: END IF;
2391: END IF;
2392:

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

2394: ( p_MODIFIERS_rec.gl_class_id <>
2395: p_old_MODIFIERS_rec.gl_class_id OR
2396: p_old_MODIFIERS_rec.gl_class_id IS NULL )
2397: THEN
2398: IF NOT QP_Validate.Gl_Class(p_MODIFIERS_rec.gl_class_id) THEN
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: END IF;
2401: END IF;
2402: */

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

2404: ( p_MODIFIERS_rec.inventory_item_id <>
2405: p_old_MODIFIERS_rec.inventory_item_id OR
2406: p_old_MODIFIERS_rec.inventory_item_id IS NULL )
2407: THEN
2408: IF NOT QP_Validate.Inventory_Item(p_MODIFIERS_rec.inventory_item_id) THEN
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410: END IF;
2411: END IF;
2412:

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

2414: ( p_MODIFIERS_rec.last_updated_by <>
2415: p_old_MODIFIERS_rec.last_updated_by OR
2416: p_old_MODIFIERS_rec.last_updated_by IS NULL )
2417: THEN
2418: IF NOT QP_Validate.Last_Updated_By(p_MODIFIERS_rec.last_updated_by) THEN
2419: x_return_status := FND_API.G_RET_STS_ERROR;
2420: END IF;
2421: END IF;
2422:

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

2424: ( p_MODIFIERS_rec.last_update_date <>
2425: p_old_MODIFIERS_rec.last_update_date OR
2426: p_old_MODIFIERS_rec.last_update_date IS NULL )
2427: THEN
2428: IF NOT QP_Validate.Last_Update_Date(p_MODIFIERS_rec.last_update_date) THEN
2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: END IF;
2431: END IF;
2432:

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

2434: ( p_MODIFIERS_rec.last_update_login <>
2435: p_old_MODIFIERS_rec.last_update_login OR
2436: p_old_MODIFIERS_rec.last_update_login IS NULL )
2437: THEN
2438: IF NOT QP_Validate.Last_Update_Login(p_MODIFIERS_rec.last_update_login) THEN
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: END IF;
2441: END IF;
2442:

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

2445: ( p_MODIFIERS_rec.list_header_id <>
2446: p_old_MODIFIERS_rec.list_header_id OR
2447: p_old_MODIFIERS_rec.list_header_id IS NULL )
2448: THEN
2449: IF NOT QP_Validate.List_Header(p_MODIFIERS_rec.list_header_id) THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR;
2451: END IF;
2452: END IF;
2453:

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

2455: ( p_MODIFIERS_rec.list_line_id <>
2456: p_old_MODIFIERS_rec.list_line_id OR
2457: p_old_MODIFIERS_rec.list_line_id IS NULL )
2458: THEN
2459: IF NOT QP_Validate.List_Line(p_MODIFIERS_rec.list_line_id) THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: END IF;
2462: END IF;
2463:

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

2465: ( p_MODIFIERS_rec.list_line_type_code <>
2466: p_old_MODIFIERS_rec.list_line_type_code OR
2467: p_old_MODIFIERS_rec.list_line_type_code IS NULL )
2468: THEN
2469: IF NOT QP_Validate.List_Line_Type(p_MODIFIERS_rec.list_line_type_code) THEN
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471: END IF;
2472: END IF;
2473:

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

2475: ( p_MODIFIERS_rec.list_price <>
2476: p_old_MODIFIERS_rec.list_price OR
2477: p_old_MODIFIERS_rec.list_price IS NULL )
2478: THEN
2479: IF NOT QP_Validate.List_Price(p_MODIFIERS_rec.list_price) THEN
2480: x_return_status := FND_API.G_RET_STS_ERROR;
2481: END IF;
2482: END IF;
2483:

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

2485: ( p_MODIFIERS_rec.list_price_uom_code <>
2486: p_old_MODIFIERS_rec.list_price_uom_code OR
2487: p_old_MODIFIERS_rec.list_price_uom_code IS NULL )
2488: THEN
2489: IF NOT QP_Validate.List_Price_Uom(p_MODIFIERS_rec.list_price_uom_code) THEN
2490: x_return_status := FND_API.G_RET_STS_ERROR;
2491: END IF;
2492: END IF;
2493: */

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

2495: ( p_MODIFIERS_rec.modifier_level_code <>
2496: p_old_MODIFIERS_rec.modifier_level_code OR
2497: p_old_MODIFIERS_rec.modifier_level_code IS NULL )
2498: THEN
2499: IF NOT QP_Validate.Modifier_Level(p_MODIFIERS_rec.modifier_level_code) THEN
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: END IF;
2502: END IF;
2503:

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

2505: ( p_MODIFIERS_rec.new_price <>
2506: p_old_MODIFIERS_rec.new_price OR
2507: p_old_MODIFIERS_rec.new_price IS NULL )
2508: THEN
2509: IF NOT QP_Validate.New_Price(p_MODIFIERS_rec.new_price) THEN
2510: x_return_status := FND_API.G_RET_STS_ERROR;
2511: END IF;
2512: END IF;
2513: */

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

2515: ( p_MODIFIERS_rec.number_effective_periods <>
2516: p_old_MODIFIERS_rec.number_effective_periods OR
2517: p_old_MODIFIERS_rec.number_effective_periods IS NULL )
2518: THEN
2519: IF NOT QP_Validate.Number_Effective_Periods(p_MODIFIERS_rec.number_effective_periods) THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END IF;
2522: END IF;
2523:

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

2527: p_old_MODIFIERS_rec.operand OR
2528: p_old_MODIFIERS_rec.operand IS NULL )
2529: THEN
2530: oe_debug_pub.add('here7');
2531: IF NOT QP_Validate.Operand(p_MODIFIERS_rec.operand) THEN
2532: oe_debug_pub.add('here8');
2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: END IF;
2535: END IF;

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

2539: ( p_MODIFIERS_rec.organization_id <>
2540: p_old_MODIFIERS_rec.organization_id OR
2541: p_old_MODIFIERS_rec.organization_id IS NULL )
2542: THEN
2543: IF NOT QP_Validate.Organization(p_MODIFIERS_rec.organization_id) THEN
2544: x_return_status := FND_API.G_RET_STS_ERROR;
2545: END IF;
2546: END IF;
2547:

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

2550: ( p_MODIFIERS_rec.override_flag <>
2551: p_old_MODIFIERS_rec.override_flag OR
2552: p_old_MODIFIERS_rec.override_flag IS NULL )
2553: THEN
2554: IF NOT QP_Validate.Override(p_MODIFIERS_rec.override_flag) THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: END IF;
2557: END IF;
2558:

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

2561: ( p_MODIFIERS_rec.percent_price <>
2562: p_old_MODIFIERS_rec.percent_price OR
2563: p_old_MODIFIERS_rec.percent_price IS NULL )
2564: THEN
2565: IF NOT QP_Validate.Percent_Price(p_MODIFIERS_rec.percent_price) THEN
2566: x_return_status := FND_API.G_RET_STS_ERROR;
2567: END IF;
2568: END IF;
2569:

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

2571: ( p_MODIFIERS_rec.price_break_type_code <>
2572: p_old_MODIFIERS_rec.price_break_type_code OR
2573: p_old_MODIFIERS_rec.price_break_type_code IS NULL )
2574: THEN
2575: IF NOT QP_Validate.Price_Break_Type(p_MODIFIERS_rec.price_break_type_code) THEN
2576: x_return_status := FND_API.G_RET_STS_ERROR;
2577: END IF;
2578: END IF;
2579:

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

2581: ( p_MODIFIERS_rec.price_by_formula_id <>
2582: p_old_MODIFIERS_rec.price_by_formula_id OR
2583: p_old_MODIFIERS_rec.price_by_formula_id IS NULL )
2584: THEN
2585: IF NOT QP_Validate.Price_By_Formula(p_MODIFIERS_rec.price_by_formula_id) THEN
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: END IF;
2588: END IF;
2589:

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

2591: ( p_MODIFIERS_rec.primary_uom_flag <>
2592: p_old_MODIFIERS_rec.primary_uom_flag OR
2593: p_old_MODIFIERS_rec.primary_uom_flag IS NULL )
2594: THEN
2595: IF NOT QP_Validate.Primary_Uom(p_MODIFIERS_rec.primary_uom_flag) THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: END IF;
2598: END IF;
2599:

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

2603: ( p_MODIFIERS_rec.print_on_invoice_flag <>
2604: p_old_MODIFIERS_rec.print_on_invoice_flag OR
2605: p_old_MODIFIERS_rec.print_on_invoice_flag IS NULL )
2606: THEN
2607: IF NOT QP_Validate.Print_On_Invoice(p_MODIFIERS_rec.print_on_invoice_flag) THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: END IF;
2610: END IF;
2611: */

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

2614: ( p_MODIFIERS_rec.program_application_id <>
2615: p_old_MODIFIERS_rec.program_application_id OR
2616: p_old_MODIFIERS_rec.program_application_id IS NULL )
2617: THEN
2618: IF NOT QP_Validate.Program_Application(p_MODIFIERS_rec.program_application_id) THEN
2619: x_return_status := FND_API.G_RET_STS_ERROR;
2620: END IF;
2621: END IF;
2622:

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

2624: ( p_MODIFIERS_rec.program_id <>
2625: p_old_MODIFIERS_rec.program_id OR
2626: p_old_MODIFIERS_rec.program_id IS NULL )
2627: THEN
2628: IF NOT QP_Validate.Program(p_MODIFIERS_rec.program_id) THEN
2629: x_return_status := FND_API.G_RET_STS_ERROR;
2630: END IF;
2631: END IF;
2632:

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

2634: ( p_MODIFIERS_rec.program_update_date <>
2635: p_old_MODIFIERS_rec.program_update_date OR
2636: p_old_MODIFIERS_rec.program_update_date IS NULL )
2637: THEN
2638: IF NOT QP_Validate.Program_Update_Date(p_MODIFIERS_rec.program_update_date) THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: END IF;
2641: END IF;
2642:

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

2644: ( p_MODIFIERS_rec.rebate_subtype_code <>
2645: p_old_MODIFIERS_rec.rebate_subtype_code OR
2646: p_old_MODIFIERS_rec.rebate_subtype_code IS NULL )
2647: THEN
2648: IF NOT QP_Validate.Rebate_Subtype(p_MODIFIERS_rec.rebate_subtype_code) THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: END IF;
2651: END IF;
2652: */

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

2654: ( p_MODIFIERS_rec.rebate_trxn_type_code <>
2655: p_old_MODIFIERS_rec.rebate_trxn_type_code OR
2656: p_old_MODIFIERS_rec.rebate_trxn_type_code IS NULL )
2657: THEN
2658: IF NOT QP_Validate.Rebate_Transaction_Type(p_MODIFIERS_rec.rebate_trxn_type_code) THEN
2659: x_return_status := FND_API.G_RET_STS_ERROR;
2660: END IF;
2661: END IF;
2662:

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

2664: ( p_MODIFIERS_rec.related_item_id <>
2665: p_old_MODIFIERS_rec.related_item_id OR
2666: p_old_MODIFIERS_rec.related_item_id IS NULL )
2667: THEN
2668: IF NOT QP_Validate.Related_Item(p_MODIFIERS_rec.related_item_id) THEN
2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: END IF;
2671: END IF;
2672:

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

2674: ( p_MODIFIERS_rec.relationship_type_id <>
2675: p_old_MODIFIERS_rec.relationship_type_id OR
2676: p_old_MODIFIERS_rec.relationship_type_id IS NULL )
2677: THEN
2678: IF NOT QP_Validate.Relationship_Type(p_MODIFIERS_rec.relationship_type_id) THEN
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680: END IF;
2681: END IF;
2682:

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

2684: ( p_MODIFIERS_rec.reprice_flag <>
2685: p_old_MODIFIERS_rec.reprice_flag OR
2686: p_old_MODIFIERS_rec.reprice_flag IS NULL )
2687: THEN
2688: IF NOT QP_Validate.Reprice(p_MODIFIERS_rec.reprice_flag) THEN
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: END IF;
2691: END IF;
2692:

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

2694: ( p_MODIFIERS_rec.request_id <>
2695: p_old_MODIFIERS_rec.request_id OR
2696: p_old_MODIFIERS_rec.request_id IS NULL )
2697: THEN
2698: IF NOT QP_Validate.Request(p_MODIFIERS_rec.request_id) THEN
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700: END IF;
2701: END IF;
2702:

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

2704: ( p_MODIFIERS_rec.revision <>
2705: p_old_MODIFIERS_rec.revision OR
2706: p_old_MODIFIERS_rec.revision IS NULL )
2707: THEN
2708: IF NOT QP_Validate.Revision(p_MODIFIERS_rec.revision) THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: END IF;
2711: END IF;
2712:

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

2714: ( p_MODIFIERS_rec.revision_date <>
2715: p_old_MODIFIERS_rec.revision_date OR
2716: p_old_MODIFIERS_rec.revision_date IS NULL )
2717: THEN
2718: IF NOT QP_Validate.Revision_Date(p_MODIFIERS_rec.revision_date) THEN
2719: x_return_status := FND_API.G_RET_STS_ERROR;
2720: END IF;
2721: END IF;
2722:

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

2724: ( p_MODIFIERS_rec.revision_reason_code <>
2725: p_old_MODIFIERS_rec.revision_reason_code OR
2726: p_old_MODIFIERS_rec.revision_reason_code IS NULL )
2727: THEN
2728: IF NOT QP_Validate.Revision_Reason(p_MODIFIERS_rec.revision_reason_code) THEN
2729: x_return_status := FND_API.G_RET_STS_ERROR;
2730: END IF;
2731: END IF;
2732:

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

2734: ( p_MODIFIERS_rec.start_date_active <>
2735: p_old_MODIFIERS_rec.start_date_active OR
2736: p_old_MODIFIERS_rec.start_date_active IS NULL )
2737: THEN
2738: IF NOT QP_Validate.Start_Date_Active(p_MODIFIERS_rec.start_date_active) THEN
2739: x_return_status := FND_API.G_RET_STS_ERROR;
2740: END IF;
2741: END IF;
2742:

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

2744: ( p_MODIFIERS_rec.substitution_attribute <>
2745: p_old_MODIFIERS_rec.substitution_attribute OR
2746: p_old_MODIFIERS_rec.substitution_attribute IS NULL )
2747: THEN
2748: IF NOT QP_Validate.Substitution_Attribute(p_MODIFIERS_rec.substitution_attribute) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: END IF;
2751: END IF;
2752:

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

2754: ( p_MODIFIERS_rec.substitution_context <>
2755: p_old_MODIFIERS_rec.substitution_context OR
2756: p_old_MODIFIERS_rec.substitution_context IS NULL )
2757: THEN
2758: IF NOT QP_Validate.Substitution_Context(p_MODIFIERS_rec.substitution_context) THEN
2759: x_return_status := FND_API.G_RET_STS_ERROR;
2760: END IF;
2761: END IF;
2762:

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

2764: ( p_MODIFIERS_rec.substitution_value <>
2765: p_old_MODIFIERS_rec.substitution_value OR
2766: p_old_MODIFIERS_rec.substitution_value IS NULL )
2767: THEN
2768: IF NOT QP_Validate.Substitution_Value(p_MODIFIERS_rec.substitution_value) THEN
2769: x_return_status := FND_API.G_RET_STS_ERROR;
2770: END IF;
2771: END IF;
2772:

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

2774: ( p_MODIFIERS_rec.accrual_flag <>
2775: p_old_MODIFIERS_rec.accrual_flag OR
2776: p_old_MODIFIERS_rec.accrual_flag IS NULL )
2777: THEN
2778: IF NOT QP_Validate.Accrual_Flag(p_MODIFIERS_rec.accrual_flag) THEN
2779: x_return_status := FND_API.G_RET_STS_ERROR;
2780: END IF;
2781: END IF;
2782:

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

2784: ( p_MODIFIERS_rec.pricing_group_sequence <>
2785: p_old_MODIFIERS_rec.pricing_group_sequence OR
2786: p_old_MODIFIERS_rec.pricing_group_sequence IS NULL )
2787: THEN
2788: IF NOT QP_Validate.Pricing_Group_Sequence(p_MODIFIERS_rec.pricing_group_sequence) THEN
2789: x_return_status := FND_API.G_RET_STS_ERROR;
2790: END IF;
2791: END IF;
2792: oe_debug_pub.add('here12');

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

2794: ( p_MODIFIERS_rec.incompatibility_grp_code <>
2795: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2796: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )
2797: THEN
2798: IF NOT QP_Validate.Incompatibility_Grp_Code(p_MODIFIERS_rec.incompatibility_grp_code) THEN
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: END IF;
2801: END IF;
2802:

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

2805: ( p_MODIFIERS_rec.list_line_no <>
2806: p_old_MODIFIERS_rec.list_line_no OR
2807: p_old_MODIFIERS_rec.list_line_no IS NULL )
2808: THEN
2809: IF NOT QP_Validate.List_Line_No(p_MODIFIERS_rec.list_line_no) THEN
2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: END IF;
2812: END IF;
2813:

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

2815: ( p_MODIFIERS_rec.product_precedence <>
2816: p_old_MODIFIERS_rec.product_precedence OR
2817: p_old_MODIFIERS_rec.product_precedence IS NULL )
2818: THEN
2819: IF NOT QP_Validate.Product_Precedence(p_MODIFIERS_rec.product_precedence) THEN
2820: x_return_status := FND_API.G_RET_STS_ERROR;
2821: END IF;
2822: END IF;
2823:

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

2825: ( p_MODIFIERS_rec.expiration_period_start_date <>
2826: p_old_MODIFIERS_rec.expiration_period_start_date OR
2827: p_old_MODIFIERS_rec.expiration_period_start_date IS NULL )
2828: THEN
2829: IF NOT QP_Validate.Exp_Period_Start_Date(p_MODIFIERS_rec.expiration_period_start_date) THEN
2830: x_return_status := FND_API.G_RET_STS_ERROR;
2831: END IF;
2832: END IF;
2833:

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

2835: ( p_MODIFIERS_rec.number_expiration_periods <>
2836: p_old_MODIFIERS_rec.number_expiration_periods OR
2837: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2838: THEN
2839: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841: END IF;
2842: END IF;
2843:

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

2845: ( p_MODIFIERS_rec.number_expiration_periods <>
2846: p_old_MODIFIERS_rec.number_expiration_periods OR
2847: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2848: THEN
2849: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2850: x_return_status := FND_API.G_RET_STS_ERROR;
2851: END IF;
2852: END IF;
2853:

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

2855: ( p_MODIFIERS_rec.expiration_period_uom <>
2856: p_old_MODIFIERS_rec.expiration_period_uom OR
2857: p_old_MODIFIERS_rec.expiration_period_uom IS NULL )
2858: THEN
2859: IF NOT QP_Validate.Expiration_Period_Uom(p_MODIFIERS_rec.expiration_period_uom) THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR;
2861: END IF;
2862: END IF;
2863:

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

2865: ( p_MODIFIERS_rec.expiration_date <>
2866: p_old_MODIFIERS_rec.expiration_date OR
2867: p_old_MODIFIERS_rec.expiration_date IS NULL )
2868: THEN
2869: IF NOT QP_Validate.Expiration_Date(p_MODIFIERS_rec.expiration_date) THEN
2870: x_return_status := FND_API.G_RET_STS_ERROR;
2871: END IF;
2872: END IF;
2873:

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

2875: ( p_MODIFIERS_rec.estim_gl_value <>
2876: p_old_MODIFIERS_rec.estim_gl_value OR
2877: p_old_MODIFIERS_rec.estim_gl_value IS NULL )
2878: THEN
2879: IF NOT QP_Validate.Estim_Gl_Value(p_MODIFIERS_rec.estim_gl_value) THEN
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881: END IF;
2882: END IF;
2883:

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

2885: ( p_MODIFIERS_rec.benefit_price_list_line_id <>
2886: p_old_MODIFIERS_rec.benefit_price_list_line_id OR
2887: p_old_MODIFIERS_rec.benefit_price_list_line_id IS NULL )
2888: THEN
2889: IF NOT QP_Validate.Ben_Price_List_Line(p_MODIFIERS_rec.benefit_price_list_line_id) THEN
2890: x_return_status := FND_API.G_RET_STS_ERROR;
2891: END IF;
2892: END IF;
2893:

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

2895: ( p_MODIFIERS_rec.recurring_flag <>
2896: p_old_MODIFIERS_rec.recurring_flag OR
2897: p_old_MODIFIERS_rec.recurring_flag IS NULL )
2898: THEN
2899: IF NOT QP_Validate.Recurring(p_MODIFIERS_rec.recurring_flag) THEN
2900: x_return_status := FND_API.G_RET_STS_ERROR;
2901: END IF;
2902: END IF;
2903: */

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

2905: ( p_MODIFIERS_rec.benefit_limit <>
2906: p_old_MODIFIERS_rec.benefit_limit OR
2907: p_old_MODIFIERS_rec.benefit_limit IS NULL )
2908: THEN
2909: IF NOT QP_Validate.Benefit_Limit(p_MODIFIERS_rec.benefit_limit) THEN
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: END IF;
2912: END IF;
2913:

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

2915: ( p_MODIFIERS_rec.charge_type_code <>
2916: p_old_MODIFIERS_rec.charge_type_code OR
2917: p_old_MODIFIERS_rec.charge_type_code IS NULL )
2918: THEN
2919: IF NOT QP_Validate.Charge_Type(p_MODIFIERS_rec.charge_type_code) THEN
2920: x_return_status := FND_API.G_RET_STS_ERROR;
2921: END IF;
2922: END IF;
2923:

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

2925: ( p_MODIFIERS_rec.charge_subtype_code <>
2926: p_old_MODIFIERS_rec.charge_subtype_code OR
2927: p_old_MODIFIERS_rec.charge_subtype_code IS NULL )
2928: THEN
2929: IF NOT QP_Validate.Charge_Subtype(p_MODIFIERS_rec.charge_subtype_code) THEN
2930: x_return_status := FND_API.G_RET_STS_ERROR;
2931: END IF;
2932: END IF;
2933:

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

2935: ( p_MODIFIERS_rec.benefit_qty <>
2936: p_old_MODIFIERS_rec.benefit_qty OR
2937: p_old_MODIFIERS_rec.benefit_qty IS NULL )
2938: THEN
2939: IF NOT QP_Validate.Benefit_Qty(p_MODIFIERS_rec.benefit_qty) THEN
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: END IF;
2942: END IF;
2943:

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

2945: ( p_MODIFIERS_rec.benefit_uom_code <>
2946: p_old_MODIFIERS_rec.benefit_uom_code OR
2947: p_old_MODIFIERS_rec.benefit_uom_code IS NULL )
2948: THEN
2949: IF NOT QP_Validate.Benefit_Uom(p_MODIFIERS_rec.benefit_uom_code) THEN
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: END IF;
2952: END IF;
2953:

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

2955: ( p_MODIFIERS_rec.accrual_conversion_rate <>
2956: p_old_MODIFIERS_rec.accrual_conversion_rate OR
2957: p_old_MODIFIERS_rec.accrual_conversion_rate IS NULL )
2958: THEN
2959: IF NOT QP_Validate.Accrual_Conversion_Rate(p_MODIFIERS_rec.accrual_conversion_rate) THEN
2960: x_return_status := FND_API.G_RET_STS_ERROR;
2961: END IF;
2962: END IF;
2963:

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

2965: ( p_MODIFIERS_rec.proration_type_code <>
2966: p_old_MODIFIERS_rec.proration_type_code OR
2967: p_old_MODIFIERS_rec.proration_type_code IS NULL )
2968: THEN
2969: IF NOT QP_Validate.Proration_Type(p_MODIFIERS_rec.proration_type_code) THEN
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: END IF;
2972: END IF;
2973:

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

2975: ( p_MODIFIERS_rec.from_rltd_modifier_id <>
2976: p_old_MODIFIERS_rec.from_rltd_modifier_id OR
2977: p_old_MODIFIERS_rec.from_rltd_modifier_id IS NULL )
2978: THEN
2979: IF NOT QP_Validate.From_Rltd_Modifier(p_MODIFIERS_rec.from_rltd_modifier_id) THEN
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981: END IF;
2982: END IF;
2983:

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

2985: ( p_MODIFIERS_rec.to_rltd_modifier_id <>
2986: p_old_MODIFIERS_rec.to_rltd_modifier_id OR
2987: p_old_MODIFIERS_rec.to_rltd_modifier_id IS NULL )
2988: THEN
2989: IF NOT QP_Validate.To_Rltd_Modifier(p_MODIFIERS_rec.to_rltd_modifier_id) THEN
2990: x_return_status := FND_API.G_RET_STS_ERROR;
2991: END IF;
2992: END IF;
2993:

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

2995: ( p_MODIFIERS_rec.rltd_modifier_grp_no <>
2996: p_old_MODIFIERS_rec.rltd_modifier_grp_no OR
2997: p_old_MODIFIERS_rec.rltd_modifier_grp_no IS NULL )
2998: THEN
2999: IF NOT QP_Validate.Rltd_Modifier_Grp_No(p_MODIFIERS_rec.rltd_modifier_grp_no) THEN
3000: x_return_status := FND_API.G_RET_STS_ERROR;
3001: END IF;
3002: END IF;
3003:

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

3005: ( p_MODIFIERS_rec.rltd_modifier_grp_type <>
3006: p_old_MODIFIERS_rec.rltd_modifier_grp_type OR
3007: p_old_MODIFIERS_rec.rltd_modifier_grp_type IS NULL )
3008: THEN
3009: IF NOT QP_Validate.Rltd_Modifier_Grp_Type(p_MODIFIERS_rec.rltd_modifier_grp_type) THEN
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: END IF;
3012: END IF;
3013:

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

3016: ( p_MODIFIERS_rec.net_amount_flag <>
3017: p_old_MODIFIERS_rec.net_amount_flag OR
3018: p_old_MODIFIERS_rec.net_amount_flag IS NULL )
3019: THEN
3020: IF NOT QP_Validate.Net_Amount(p_MODIFIERS_rec.net_amount_flag) THEN
3021: x_return_status := FND_API.G_RET_STS_ERROR;
3022: END IF;
3023: END IF;
3024:

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

3027: ( p_MODIFIERS_rec.accum_attribute <>
3028: p_old_MODIFIERS_rec.accum_attribute OR
3029: p_old_MODIFIERS_rec.accum_attribute IS NULL )
3030: THEN
3031: IF NOT QP_Validate.Accum_Attribute(p_MODIFIERS_rec.accum_attribute) THEN
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3033: END IF;
3034: END IF;
3035:

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

3172: */
3173:
3174: -- Validate descriptive flexfield.
3175:
3176: IF NOT QP_Validate.Desc_Flex( 'MODIFIERS' ) THEN
3177: x_return_status := FND_API.G_RET_STS_ERROR;
3178: END IF;
3179:
3180: END IF;

Line 3264: END QP_Validate_Modifiers;

3260: END IF;
3261:
3262: END Entity_Delete;
3263:
3264: END QP_Validate_Modifiers;