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_BLANKET_LINE_SECURITY dependencies on FND_API

Line 8: g_order_number NUMBER := FND_API.G_MISS_NUM;

4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_Line_Security';
7:
8: g_order_number NUMBER := FND_API.G_MISS_NUM;
9:
10: -- LOCAL PROCEDURES
11:
12: FUNCTION Is_Op_Constrained

Line 66: RAISE FND_API.G_EXC_ERROR;

62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_column_name is null and x_on_operation_action = 0 then
65: oe_debug_pub.add('Constraint on UPDATE of all columns!');
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then

Line 72: raise FND_API.G_EXC_UNEXPECTED_ERROR;

68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then
71:
72: raise FND_API.G_EXC_UNEXPECTED_ERROR;
73:
74: end if;
75:
76: g_check_all_cols_constraint := 'N';

Line 2191: x_return_status := FND_API.G_RET_STS_SUCCESS;

2187:
2188: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Entity',1);
2189:
2190: -- Initializing return status to SUCCESS
2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:
2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 2201: RAISE FND_API.G_EXC_ERROR;

2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE
2200: oe_debug_pub.add('Invalid operation',1);
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204: OE_Blanket_Util.Line_API_Rec_To_Rowtype_Rec
2205: (p_LINE_rec => p_line_rec

Line 2220: WHEN FND_API.G_EXC_ERROR THEN

2216:
2217: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Entity',1);
2218:
2219: EXCEPTION
2220: WHEN FND_API.G_EXC_ERROR THEN
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: WHEN OTHERS THEN

Line 2221: x_return_status := FND_API.G_RET_STS_ERROR;

2217: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Entity',1);
2218:
2219: EXCEPTION
2220: WHEN FND_API.G_EXC_ERROR THEN
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2218:
2219: EXCEPTION
2220: WHEN FND_API.G_EXC_ERROR THEN
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2219: EXCEPTION
2220: WHEN FND_API.G_EXC_ERROR THEN
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2227: OE_MSG_PUB.Add_Exc_Msg

Line 2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2227: OE_MSG_PUB.Add_Exc_Msg
2228: ( G_PKG_NAME
2229: , 'Entity'

Line 2252: x_return_status := FND_API.G_RET_STS_SUCCESS;

2248: BEGIN
2249: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Attributes',1);
2250:
2251: -- Initializing return status to SUCCESS
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:
2254: -- Initializing out result to NOT CONSTRAINED
2255: x_result := OE_PC_GLOBALS.NO;
2256:

Line 2286: RAISE FND_API.G_EXC_ERROR;

2282: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2283: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2284: ELSE
2285: oe_debug_pub.add('Invalid operation',1);
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: OE_Blanket_Util.Line_API_Rec_To_Rowtype_Rec
2290: (p_LINE_rec => p_line_rec

Line 2299: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;

2295:
2296: -- Compare the new and old entity records and
2297: -- check constraints for all the changed attributes.
2298:
2299: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2300: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
2301:
2302: l_result := ACCOUNTING_RULE
2303: (p_operation => l_operation

Line 2315: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;

2311: END IF;
2312:
2313: END IF;
2314:
2315: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
2317:
2318: l_result := CUST_PO_NUMBER
2319: (p_operation => l_operation

Line 2331: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2327: END IF;
2328:
2329: END IF;
2330:
2331: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN
2333:
2334: l_result := DELIVER_TO_ORG
2335: (p_operation => l_operation

Line 2347: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;

2343: END IF;
2344:
2345: END IF;
2346:
2347: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2348: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
2349:
2350: l_result := FREIGHT_TERMS
2351: (p_operation => l_operation

Line 2363: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;

2359: END IF;
2360:
2361: END IF;
2362:
2363: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
2364: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
2365:
2366: l_result := INVENTORY_ITEM
2367: (p_operation => l_operation

Line 2379: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2375: END IF;
2376:
2377: END IF;
2378:
2379: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2380: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN
2381:
2382: l_result := INVOICE_TO_ORG
2383: (p_operation => l_operation

Line 2395: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;

2391: END IF;
2392:
2393: END IF;
2394:
2395: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2396: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN
2397:
2398: l_result := INVOICING_RULE
2399: (p_operation => l_operation

Line 2411: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;

2407: END IF;
2408:
2409: END IF;
2410:
2411: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;
2412: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN
2413:
2414: l_result := ITEM_IDENTIFIER_TYPE
2415: (p_operation => l_operation

Line 2427: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;

2423: END IF;
2424:
2425: END IF;
2426:
2427: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;
2428: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN
2429:
2430: l_result := LINE_NUMBER
2431: (p_operation => l_operation

Line 2443: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;

2439: END IF;
2440:
2441: END IF;
2442:
2443: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;
2444: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN
2445:
2446: l_result := LINE_TYPE
2447: (p_operation => l_operation

Line 2459: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;

2455: END IF;
2456:
2457: END IF;
2458:
2459: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
2460: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
2461:
2462: l_result := ORDER_QUANTITY_UOM
2463: (p_operation => l_operation

Line 2475: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;

2471: END IF;
2472:
2473: END IF;
2474:
2475: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
2476: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
2477:
2478: l_result := PACKING_INSTRUCTIONS
2479: (p_operation => l_operation

Line 2491: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;

2487: END IF;
2488:
2489: END IF;
2490:
2491: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
2492: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
2493:
2494: l_result := PAYMENT_TERM
2495: (p_operation => l_operation

Line 2507: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;

2503: END IF;
2504:
2505: END IF;
2506:
2507: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
2508: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
2509:
2510: l_result := PRICE_LIST
2511: (p_operation => l_operation

Line 2523: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;

2519: END IF;
2520:
2521: END IF;
2522:
2523: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
2524: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN
2525:
2526: l_result := SALESREP
2527: (p_operation => l_operation

Line 2539: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;

2535: END IF;
2536:
2537: END IF;
2538:
2539: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
2540: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
2541:
2542: l_result := SHIPPING_INSTRUCTIONS
2543: (p_operation => l_operation

Line 2555: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;

2551: END IF;
2552:
2553: END IF;
2554:
2555: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
2556: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
2557:
2558: l_result := SHIPPING_METHOD
2559: (p_operation => l_operation

Line 2571: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;

2567: END IF;
2568:
2569: END IF;
2570:
2571: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
2572: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
2573:
2574: l_result := SHIP_FROM_ORG
2575: (p_operation => l_operation

Line 2587: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2583: END IF;
2584:
2585: END IF;
2586:
2587: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2588: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
2589:
2590: l_result := SHIP_TO_ORG
2591: (p_operation => l_operation

Line 2603: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2599: END IF;
2600:
2601: END IF;
2602:
2603: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2604: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
2605:
2606: l_result := SOLD_TO_ORG
2607: (p_operation => l_operation

Line 2619: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;

2615: END IF;
2616:
2617: END IF;
2618:
2619: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
2620: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
2621:
2622: l_result := UNIT_LIST_PRICE
2623: (p_operation => l_operation

Line 2635: IF p_line_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;

2631: END IF;
2632:
2633: END IF;
2634:
2635: IF p_line_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;
2636: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.start_date_active,p_old_line_rec.start_date_active) THEN
2637:
2638: l_result := START_DATE_ACTIVE
2639: (p_operation => l_operation

Line 2651: IF p_line_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;

2647: END IF;
2648:
2649: END IF;
2650:
2651: IF p_line_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;
2652: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_date_active,p_old_line_rec.end_date_active) THEN
2653:
2654: l_result := END_DATE_ACTIVE
2655: (p_operation => l_operation

Line 2667: IF p_line_rec.preferred_grade = FND_API.G_MISS_CHAR THEN NULL;

2663: END IF;
2664:
2665: END IF;
2666:
2667: IF p_line_rec.preferred_grade = FND_API.G_MISS_CHAR THEN NULL;
2668: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.preferred_grade,p_old_line_rec.preferred_grade) THEN
2669:
2670: l_result := PREFERRED_GRADE
2671: (p_operation => l_operation

Line 2683: IF p_line_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;

2679: END IF;
2680:
2681: END IF;
2682:
2683: IF p_line_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2684: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_ship_to_flag,p_old_line_rec.enforce_ship_to_flag) THEN
2685:
2686: l_result := ENFORCE_SHIP_TO_FLAG
2687: (p_operation => l_operation

Line 2699: IF p_line_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;

2695: END IF;
2696:
2697: END IF;
2698:
2699: IF p_line_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2700: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_freight_term_flag,p_old_line_rec.enforce_freight_term_flag) THEN
2701:
2702: l_result := ENFORCE_FREIGHT_TERM_FLAG
2703: (p_operation => l_operation

Line 2715: IF p_line_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;

2711: END IF;
2712:
2713: END IF;
2714:
2715: IF p_line_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;
2716: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_shipping_method_flag,p_old_line_rec.enforce_shipping_method_flag) THEN
2717:
2718: l_result := ENFORCE_SHIPPING_METHOD_FLAG
2719: (p_operation => l_operation

Line 2731: IF p_line_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;

2727: END IF;
2728:
2729: END IF;
2730:
2731: IF p_line_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2732: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoice_to_flag,p_old_line_rec.enforce_invoice_to_flag) THEN
2733:
2734: l_result := ENFORCE_INVOICE_TO_FLAG
2735: (p_operation => l_operation

Line 2747: IF p_line_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;

2743: END IF;
2744:
2745: END IF;
2746:
2747: IF p_line_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;
2748: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_price_list_flag,p_old_line_rec.enforce_price_list_flag) THEN
2749:
2750: l_result := ENFORCE_PRICE_LIST_FLAG
2751: (p_operation => l_operation

Line 2763: IF p_line_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;

2759: END IF;
2760:
2761: END IF;
2762:
2763: IF p_line_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2764: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_payment_term_flag,p_old_line_rec.enforce_payment_term_flag) THEN
2765:
2766: l_result := ENFORCE_PAYMENT_TERM_FLAG
2767: (p_operation => l_operation

Line 2779: IF p_line_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;

2775: END IF;
2776:
2777: END IF;
2778:
2779: IF p_line_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2780: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_accounting_rule_flag,p_old_line_rec.enforce_accounting_rule_flag) THEN
2781:
2782: l_result := ENFORCE_ACCOUNTING_RULE_FLAG
2783: (p_operation => l_operation

Line 2795: IF p_line_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;

2791: END IF;
2792:
2793: END IF;
2794:
2795: IF p_line_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2796: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoicing_rule_flag,p_old_line_rec.enforce_invoicing_rule_flag) THEN
2797:
2798: l_result := ENFORCE_INVOICING_RULE_FLAG
2799: (p_operation => l_operation

Line 2811: IF p_line_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;

2807: END IF;
2808:
2809: END IF;
2810:
2811: IF p_line_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;
2812: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_amount,p_old_line_rec.blanket_min_amount) THEN
2813:
2814: l_result := BLANKET_LINE_MIN_AMOUNT
2815: (p_operation => l_operation

Line 2827: IF p_line_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;

2823: END IF;
2824:
2825: END IF;
2826:
2827: IF p_line_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;
2828: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_amount,p_old_line_rec.blanket_max_amount) THEN
2829:
2830: l_result := BLANKET_LINE_MAX_AMOUNT
2831: (p_operation => l_operation

Line 2843: IF p_line_rec.blanket_min_quantity = FND_API.G_MISS_NUM THEN NULL;

2839: END IF;
2840:
2841: END IF;
2842:
2843: IF p_line_rec.blanket_min_quantity = FND_API.G_MISS_NUM THEN NULL;
2844: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_quantity,p_old_line_rec.blanket_min_quantity) THEN
2845:
2846: l_result := BLANKET_MIN_QUANTITY
2847: (p_operation => l_operation

Line 2859: IF p_line_rec.blanket_max_quantity = FND_API.G_MISS_NUM THEN NULL;

2855: END IF;
2856:
2857: END IF;
2858:
2859: IF p_line_rec.blanket_max_quantity = FND_API.G_MISS_NUM THEN NULL;
2860: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_quantity,p_old_line_rec.blanket_max_quantity) THEN
2861:
2862: l_result := BLANKET_MAX_QUANTITY
2863: (p_operation => l_operation

Line 2875: IF p_line_rec.min_release_amount = FND_API.G_MISS_NUM THEN NULL;

2871: END IF;
2872:
2873: END IF;
2874:
2875: IF p_line_rec.min_release_amount = FND_API.G_MISS_NUM THEN NULL;
2876: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_amount,p_old_line_rec.min_release_amount) THEN
2877:
2878: l_result := MIN_RELEASE_AMOUNT
2879: (p_operation => l_operation

Line 2891: IF p_line_rec.max_release_amount = FND_API.G_MISS_NUM THEN NULL;

2887: END IF;
2888:
2889: END IF;
2890:
2891: IF p_line_rec.max_release_amount = FND_API.G_MISS_NUM THEN NULL;
2892: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_amount,p_old_line_rec.max_release_amount) THEN
2893:
2894: l_result := MAX_RELEASE_AMOUNT
2895: (p_operation => l_operation

Line 2907: IF p_line_rec.min_release_quantity = FND_API.G_MISS_NUM THEN NULL;

2903: END IF;
2904:
2905: END IF;
2906:
2907: IF p_line_rec.min_release_quantity = FND_API.G_MISS_NUM THEN NULL;
2908: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_quantity,p_old_line_rec.min_release_quantity) THEN
2909:
2910: l_result := MIN_RELEASE_QUANTITY
2911: (p_operation => l_operation

Line 2923: IF p_line_rec.max_release_quantity = FND_API.G_MISS_NUM THEN NULL;

2919: END IF;
2920:
2921: END IF;
2922:
2923: IF p_line_rec.max_release_quantity = FND_API.G_MISS_NUM THEN NULL;
2924: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_quantity,p_old_line_rec.max_release_quantity) THEN
2925:
2926: l_result := MAX_RELEASE_QUANTITY
2927: (p_operation => l_operation

Line 2939: IF p_line_rec.override_blanket_controls_flag = FND_API.G_MISS_CHAR THEN NULL;

2935: END IF;
2936:
2937: END IF;
2938:
2939: IF p_line_rec.override_blanket_controls_flag = FND_API.G_MISS_CHAR THEN NULL;
2940: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_blanket_controls_flag,p_old_line_rec.override_blanket_controls_flag) THEN
2941:
2942: l_result := OVERRIDE_BLANKET_CONTROLS_FLAG
2943: (p_operation => l_operation

Line 2955: IF p_line_rec.override_release_controls_flag = FND_API.G_MISS_CHAR THEN NULL;

2951: END IF;
2952:
2953: END IF;
2954:
2955: IF p_line_rec.override_release_controls_flag = FND_API.G_MISS_CHAR THEN NULL;
2956: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_release_controls_flag,p_old_line_rec.override_release_controls_flag) THEN
2957:
2958: l_result := OVERRIDE_RELEASE_CONTROLS_FLAG
2959: (p_operation => l_operation

Line 2971: IF p_line_rec.pricing_uom = FND_API.G_MISS_CHAR THEN NULL;

2967: END IF;
2968:
2969: END IF;
2970:
2971: IF p_line_rec.pricing_uom = FND_API.G_MISS_CHAR THEN NULL;
2972: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,p_old_line_rec.pricing_uom) THEN
2973:
2974: l_result := PRICING_QUANTITY_UOM
2975: (p_operation => l_operation

Line 2987: IF p_line_rec.discount_percent = FND_API.G_MISS_NUM THEN NULL;

2983: END IF;
2984:
2985: END IF;
2986:
2987: IF p_line_rec.discount_percent = FND_API.G_MISS_NUM THEN NULL;
2988: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,p_old_line_rec.discount_percent) THEN
2989:
2990: l_result := DISCOUNT_PERCENT
2991: (p_operation => l_operation

Line 3003: IF p_line_rec.discount_amount = FND_API.G_MISS_NUM THEN NULL;

2999: END IF;
3000:
3001: END IF;
3002:
3003: IF p_line_rec.discount_amount = FND_API.G_MISS_NUM THEN NULL;
3004: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,p_old_line_rec.discount_amount) THEN
3005:
3006: l_result := DISCOUNT_AMOUNT
3007: (p_operation => l_operation

Line 3020: IF p_line_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;

3016:
3017: END IF;
3018:
3019: --bug6531947
3020: IF p_line_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;
3021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.CONTEXT,p_old_line_rec.CONTEXT )
3022: THEN
3023: l_result := CONTEXT
3024: (p_operation => l_operation

Line 3036: IF p_line_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;

3032:
3033: END IF;
3034:
3035:
3036: IF p_line_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;
3037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE1,p_old_line_rec.ATTRIBUTE1) THEN
3038: l_result := ATTRIBUTE1
3039: (p_operation => l_operation
3040: ,p_record => l_rowtype_rec

Line 3050: IF p_line_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;

3046: END IF;
3047:
3048: END IF;
3049:
3050: IF p_line_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;
3051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE2,p_old_line_rec.ATTRIBUTE2) THEN
3052: l_result := ATTRIBUTE2
3053: (p_operation => l_operation
3054: ,p_record => l_rowtype_rec

Line 3064: IF p_line_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;

3060: END IF;
3061:
3062: END IF;
3063:
3064: IF p_line_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;
3065: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE3,p_old_line_rec.ATTRIBUTE3) THEN
3066: l_result := ATTRIBUTE3
3067: (p_operation => l_operation
3068: ,p_record => l_rowtype_rec

Line 3078: IF p_line_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;

3074: END IF;
3075:
3076: END IF;
3077:
3078: IF p_line_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;
3079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE4,p_old_line_rec.ATTRIBUTE4) THEN
3080: l_result := ATTRIBUTE4
3081: (p_operation => l_operation
3082: ,p_record => l_rowtype_rec

Line 3092: IF p_line_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;

3088: END IF;
3089:
3090: END IF;
3091:
3092: IF p_line_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;
3093: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE5,p_old_line_rec.ATTRIBUTE5) THEN
3094: l_result := ATTRIBUTE5
3095: (p_operation => l_operation
3096: ,p_record => l_rowtype_rec

Line 3106: IF p_line_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;

3102: END IF;
3103:
3104: END IF;
3105:
3106: IF p_line_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;
3107: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE6,p_old_line_rec.ATTRIBUTE6) THEN
3108: l_result := ATTRIBUTE6
3109: (p_operation => l_operation
3110: ,p_record => l_rowtype_rec

Line 3120: IF p_line_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;

3116: END IF;
3117:
3118: END IF;
3119:
3120: IF p_line_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;
3121: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE7,p_old_line_rec.ATTRIBUTE7) THEN
3122: l_result := ATTRIBUTE7
3123: (p_operation => l_operation
3124: ,p_record => l_rowtype_rec

Line 3134: IF p_line_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;

3130: END IF;
3131:
3132: END IF;
3133:
3134: IF p_line_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;
3135: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE8,p_old_line_rec.ATTRIBUTE8) THEN
3136: l_result := ATTRIBUTE8
3137: (p_operation => l_operation
3138: ,p_record => l_rowtype_rec

Line 3148: IF p_line_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;

3144: END IF;
3145:
3146: END IF;
3147:
3148: IF p_line_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;
3149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE9,p_old_line_rec.ATTRIBUTE9) THEN
3150: l_result := ATTRIBUTE9
3151: (p_operation => l_operation
3152: ,p_record => l_rowtype_rec

Line 3162: IF p_line_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;

3158: END IF;
3159:
3160: END IF;
3161:
3162: IF p_line_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;
3163: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE10,p_old_line_rec.ATTRIBUTE10) THEN
3164: l_result := ATTRIBUTE10
3165: (p_operation => l_operation
3166: ,p_record => l_rowtype_rec

Line 3176: IF p_line_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;

3172: END IF;
3173:
3174: END IF;
3175:
3176: IF p_line_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;
3177: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE11,p_old_line_rec.ATTRIBUTE11) THEN
3178: l_result := ATTRIBUTE11
3179: (p_operation => l_operation
3180: ,p_record => l_rowtype_rec

Line 3190: IF p_line_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;

3186: END IF;
3187:
3188: END IF;
3189:
3190: IF p_line_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;
3191: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE12,p_old_line_rec.ATTRIBUTE12) THEN
3192: l_result := ATTRIBUTE12
3193: (p_operation => l_operation
3194: ,p_record => l_rowtype_rec

Line 3204: IF p_line_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;

3200: END IF;
3201:
3202: END IF;
3203:
3204: IF p_line_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;
3205: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE13,p_old_line_rec.ATTRIBUTE13) THEN
3206: l_result := ATTRIBUTE13
3207: (p_operation => l_operation
3208: ,p_record => l_rowtype_rec

Line 3218: IF p_line_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN NULL;

3214: END IF;
3215:
3216: END IF;
3217:
3218: IF p_line_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN NULL;
3219: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE14,p_old_line_rec.ATTRIBUTE14) THEN
3220: l_result := ATTRIBUTE14
3221: (p_operation => l_operation
3222: ,p_record => l_rowtype_rec

Line 3232: IF p_line_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;

3228: END IF;
3229:
3230: END IF;
3231:
3232: IF p_line_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;
3233: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE15,p_old_line_rec.ATTRIBUTE15) THEN
3234: l_result := ATTRIBUTE15
3235: (p_operation => l_operation
3236: ,p_record => l_rowtype_rec

Line 3246: IF p_line_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;

3242: END IF;
3243:
3244: END IF;
3245:
3246: IF p_line_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;
3247: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE16,p_old_line_rec.ATTRIBUTE16) THEN
3248: l_result := ATTRIBUTE16
3249: (p_operation => l_operation
3250: ,p_record => l_rowtype_rec

Line 3260: IF p_line_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;

3256: END IF;
3257:
3258: END IF;
3259:
3260: IF p_line_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;
3261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE17,p_old_line_rec.ATTRIBUTE17) THEN
3262: l_result := ATTRIBUTE17
3263: (p_operation => l_operation
3264: ,p_record => l_rowtype_rec

Line 3274: IF p_line_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;

3270: END IF;
3271:
3272: END IF;
3273:
3274: IF p_line_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;
3275: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE18,p_old_line_rec.ATTRIBUTE18) THEN
3276: l_result := ATTRIBUTE18
3277: (p_operation => l_operation
3278: ,p_record => l_rowtype_rec

Line 3288: IF p_line_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;

3284: END IF;
3285:
3286: END IF;
3287:
3288: IF p_line_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;
3289: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE19,p_old_line_rec.ATTRIBUTE19) THEN
3290: l_result := ATTRIBUTE19
3291: (p_operation => l_operation
3292: ,p_record => l_rowtype_rec

Line 3302: IF p_line_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;

3298: END IF;
3299:
3300: END IF;
3301:
3302: IF p_line_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;
3303: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE20,p_old_line_rec.ATTRIBUTE20) THEN
3304: l_result := ATTRIBUTE20
3305: (p_operation => l_operation
3306: ,p_record => l_rowtype_rec

Line 3319: WHEN FND_API.G_EXC_ERROR THEN

3315:
3316: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Attributes',1);
3317:
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: WHEN OTHERS THEN

Line 3320: x_return_status := FND_API.G_RET_STS_ERROR;

3316: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Attributes',1);
3317:
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3317:
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3326: OE_MSG_PUB.Add_Exc_Msg

Line 3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3326: OE_MSG_PUB.Add_Exc_Msg
3327: ( G_PKG_NAME
3328: , 'Attributes'