[Home] [Help]
62: if l_column_name is null then
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
65: END IF;
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then
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';
103: x_party_site_id => l_party_site_id,
104: x_is_delivery_required => l_is_delivery_reqd,
105: x_return_status => l_return_status
106: );
107: If l_return_status = FND_API.G_RET_STS_SUCCESS And
108: l_is_delivery_reqd = 'Y'
109: Then
110: l_gen_xml := 'B';
111: End If;
153: x_party_site_id => l_party_site_id,
154: x_is_delivery_required => l_is_delivery_reqd,
155: x_return_status => l_return_status
156: );
157: If l_return_status = FND_API.G_RET_STS_SUCCESS And
158: l_is_delivery_reqd = 'Y'
159: Then
160: l_gen_xml := 'B';
161: End If;
213: x_party_site_id => l_party_site_id,
214: x_is_delivery_required => l_is_delivery_reqd,
215: x_return_status => l_return_status
216: );
217: If l_return_status = FND_API.G_RET_STS_SUCCESS And
218: l_is_delivery_reqd = 'Y'
219: Then
220: l_gen_xml := 'B';
221: End If;
2401: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2402: END IF;
2403:
2404: -- Initializing return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2413: ELSE
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2416: END IF;
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:
2420: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
2421:
2433: END IF;
2434:
2435: EXCEPTION
2436: WHEN OTHERS THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2439: OE_MSG_PUB.Add_Exc_Msg
2440: ( G_PKG_NAME
2441: , 'Entity'
2487: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
2488: END IF;
2489:
2490: -- Initializing return status to SUCCESS
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;
2492:
2493: -- Initializing out result to NOT CONSTRAINED
2494: x_result := OE_PC_GLOBALS.NO;
2495:
2521: ELSE
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2524: END IF;
2525: RAISE FND_API.G_EXC_ERROR;
2526: END IF;
2527:
2528: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
2529:
2532:
2533: -- Compare the new and old entity records and
2534: -- check constraints for all the changed attributes.
2535:
2536: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
2537: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
2538: p_old_header_rec.cancelled_flag)
2539: THEN
2540: IF p_header_rec.cancelled_flag = 'Y' THEN
2576: END IF;
2577: END;
2578: END IF;
2579:
2580: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2581: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
2582:
2583: l_result := ACCOUNTING_RULE
2584: (p_operation => l_operation
2592: END IF;
2593:
2594: END IF;
2595:
2596: IF p_header_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
2597: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_OWNER,p_old_header_rec.IB_OWNER) THEN
2598:
2599: l_result := IB_OWNER
2600: (p_operation => l_operation
2607: x_result := OE_PC_GLOBALS.YES;
2608: END IF;
2609:
2610: END IF;
2611: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2612: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_INSTALLED_AT_LOCATION,p_old_header_rec.IB_INSTALLED_AT_LOCATION) THEN
2613:
2614: l_result := IB_INSTALLED_AT_LOCATION
2615: (p_operation => l_operation
2622: x_result := OE_PC_GLOBALS.YES;
2623: END IF;
2624:
2625: END IF;
2626: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2627: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_CURRENT_LOCATION,p_old_header_rec.IB_CURRENT_LOCATION) THEN
2628:
2629: l_result := IB_CURRENT_LOCATION
2630: (p_operation => l_operation
2637: x_result := OE_PC_GLOBALS.YES;
2638: END IF;
2639:
2640: END IF;
2641: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
2642: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_ID,p_old_header_rec.END_CUSTOMER_ID) THEN
2643:
2644: l_result := END_CUSTOMER
2645: (p_operation => l_operation
2652: x_result := OE_PC_GLOBALS.YES;
2653: END IF;
2654:
2655: END IF;
2656: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2657: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_SITE_USE_ID,p_old_header_rec.END_CUSTOMER_SITE_USE_ID) THEN
2658:
2659: l_result := END_CUSTOMER_SITE_USE
2660: (p_operation => l_operation
2667: x_result := OE_PC_GLOBALS.YES;
2668: END IF;
2669:
2670: END IF;
2671: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
2672: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_CONTACT_ID,p_old_header_rec.END_CUSTOMER_CONTACT_ID) THEN
2673:
2674: l_result := END_CUSTOMER_CONTACT
2675: (p_operation => l_operation
2683: END IF;
2684:
2685: END IF;
2686:
2687: IF p_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
2688: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_duration,p_old_header_rec.accounting_rule_duration) THEN
2689:
2690: l_result := ACCOUNTING_RULE_DURATION
2691: (p_operation => l_operation
2699: END IF;
2700:
2701: END IF;
2702:
2703: IF p_header_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
2704: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id,p_old_header_rec.agreement_id) THEN
2705:
2706: l_result := AGREEMENT
2707: (p_operation => l_operation
2715: END IF;
2716:
2717: END IF;
2718:
2719: IF p_header_rec.conversion_rate = FND_API.G_MISS_NUM THEN NULL;
2720: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate,p_old_header_rec.conversion_rate) THEN
2721:
2722: l_result := CONVERSION_RATE
2723: (p_operation => l_operation
2731: END IF;
2732:
2733: END IF;
2734:
2735: IF p_header_rec.conversion_rate_date = FND_API.G_MISS_DATE THEN NULL;
2736: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate_date,p_old_header_rec.conversion_rate_date) THEN
2737:
2738: l_result := CONVERSION_RATE_DATE
2739: (p_operation => l_operation
2747: END IF;
2748:
2749: END IF;
2750:
2751: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
2752: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
2753:
2754: l_result := CONVERSION_TYPE
2755: (p_operation => l_operation
2763: END IF;
2764:
2765: END IF;
2766:
2767: IF p_header_rec.created_by = FND_API.G_MISS_NUM THEN NULL;
2768: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.created_by,p_old_header_rec.created_by) THEN
2769:
2770: l_result := CREATED_BY
2771: (p_operation => l_operation
2779: END IF;
2780:
2781: END IF;
2782:
2783: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2784: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
2785:
2786: l_result := CUST_PO_NUMBER
2787: (p_operation => l_operation
2795: END IF;
2796:
2797: END IF;
2798:
2799: IF p_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2800: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id,p_old_header_rec.deliver_to_contact_id) THEN
2801:
2802: l_result := DELIVER_TO_CONTACT
2803: (p_operation => l_operation
2811: END IF;
2812:
2813: END IF;
2814:
2815: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2816: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
2817:
2818: l_result := DELIVER_TO_ORG
2819: (p_operation => l_operation
2827: END IF;
2828:
2829: END IF;
2830:
2831: IF p_header_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
2832: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.demand_class_code,p_old_header_rec.demand_class_code) THEN
2833:
2834: l_result := DEMAND_CLASS
2835: (p_operation => l_operation
2843: END IF;
2844:
2845: END IF;
2846:
2847: IF p_header_rec.earliest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2848: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.earliest_schedule_limit,p_old_header_rec.earliest_schedule_limit) THEN
2849:
2850: l_result := EARLIEST_SCHEDULE_LIMIT
2851: (p_operation => l_operation
2859: END IF;
2860:
2861: END IF;
2862:
2863: IF p_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
2864: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.fob_point_code,p_old_header_rec.fob_point_code) THEN
2865:
2866: l_result := FOB_POINT
2867: (p_operation => l_operation
2875: END IF;
2876:
2877: END IF;
2878:
2879: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2880: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
2881:
2882: l_result := FREIGHT_TERMS
2883: (p_operation => l_operation
2891: END IF;
2892:
2893: END IF;
2894:
2895: IF p_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2896: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id) THEN
2897:
2898: l_result := INVOICE_TO_CONTACT
2899: (p_operation => l_operation
2907: END IF;
2908:
2909: END IF;
2910:
2911: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2912: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
2913:
2914: l_result := INVOICE_TO_ORG
2915: (p_operation => l_operation
2923: END IF;
2924:
2925: END IF;
2926:
2927: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2928: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
2929:
2930: l_result := INVOICING_RULE
2931: (p_operation => l_operation
2939: END IF;
2940:
2941: END IF;
2942:
2943: IF p_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2944: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.latest_schedule_limit,p_old_header_rec.latest_schedule_limit) THEN
2945:
2946: l_result := LATEST_SCHEDULE_LIMIT
2947: (p_operation => l_operation
2955: END IF;
2956:
2957: END IF;
2958:
2959: IF p_header_rec.ordered_date = FND_API.G_MISS_DATE THEN NULL;
2960: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date,p_old_header_rec.ordered_date) THEN
2961:
2962: l_result := ORDERED_DATE
2963: (p_operation => l_operation
2971: END IF;
2972:
2973: END IF;
2974:
2975: IF p_header_rec.order_date_type_code = FND_API.G_MISS_CHAR THEN NULL;
2976: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_date_type_code,p_old_header_rec.order_date_type_code) THEN
2977:
2978: l_result := ORDER_DATE_TYPE_CODE
2979: (p_operation => l_operation
2987: END IF;
2988:
2989: END IF;
2990:
2991: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
2992: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
2993:
2994: l_result := ORDER_NUMBER
2995: (p_operation => l_operation
3003: END IF;
3004:
3005: END IF;
3006:
3007: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
3008: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
3009:
3010: l_result := ORDER_TYPE
3011: (p_operation => l_operation
3019: END IF;
3020:
3021: END IF;
3022:
3023: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
3024: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
3025:
3026: l_result := PACKING_INSTRUCTIONS
3027: (p_operation => l_operation
3035: END IF;
3036:
3037: END IF;
3038:
3039: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
3040: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
3041:
3042: l_result := PAYMENT_TERM
3043: (p_operation => l_operation
3051: END IF;
3052:
3053: END IF;
3054:
3055: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
3056: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
3057:
3058: l_result := PRICE_LIST
3059: (p_operation => l_operation
3067: END IF;
3068:
3069: END IF;
3070:
3071: IF p_header_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
3072: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.pricing_date,p_old_header_rec.pricing_date) THEN
3073:
3074: l_result := PRICING_DATE
3075: (p_operation => l_operation
3083: END IF;
3084:
3085: END IF;
3086:
3087: IF p_header_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
3088: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.request_date,p_old_header_rec.request_date) THEN
3089:
3090: l_result := REQUEST_DATE
3091: (p_operation => l_operation
3099: END IF;
3100:
3101: END IF;
3102:
3103: IF p_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3104: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.return_reason_code,p_old_header_rec.return_reason_code) THEN
3105:
3106: l_result := RETURN_REASON
3107: (p_operation => l_operation
3115: END IF;
3116:
3117: END IF;
3118:
3119: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
3120: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
3121:
3122: l_result := SALESREP
3123: (p_operation => l_operation
3131: END IF;
3132:
3133: END IF;
3134:
3135: IF p_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN NULL;
3136: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code) THEN
3137:
3138: l_result := SALES_CHANNEL_CODE
3139: (p_operation => l_operation
3148:
3149: END IF;
3150:
3151: /* START PREPAYMENT */
3152: IF p_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
3153: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code, p_old_header_rec.payment_type_code) THEN
3154:
3155: l_result := PAYMENT_TYPE
3156: (p_operation => l_operation
3163: END IF;
3164:
3165: END IF;
3166:
3167: IF p_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
3168: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name) THEN
3169:
3170: l_result := CREDIT_CARD_HOLDER_NAME
3171: (p_operation => l_operation
3178: END IF;
3179:
3180: END IF;
3181:
3182: IF p_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
3183: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code, p_old_header_rec.credit_card_code) THEN
3184:
3185: l_result := CREDIT_CARD
3186: (p_operation => l_operation
3193: END IF;
3194:
3195: END IF;
3196:
3197: IF p_header_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;
3198: --R12 CC Encryption
3199: --Since the credit card numbers are encrypted, calling
3200: --the function same credit card to determine whether the old
3201: --and new card numbers are equal.
3214: END IF;
3215:
3216: END IF;
3217:
3218: IF p_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
3219: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date) THEN
3220:
3221: l_result := CREDIT_CARD_EXPIRATION_DATE
3222: (p_operation => l_operation
3230:
3231: END IF;
3232: /* END PREPAYMENT */
3233:
3234: IF p_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
3235: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipment_priority_code,p_old_header_rec.shipment_priority_code) THEN
3236:
3237: l_result := SHIPMENT_PRIORITY
3238: (p_operation => l_operation
3246: END IF;
3247:
3248: END IF;
3249:
3250: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
3251: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
3252:
3253: l_result := SHIPPING_INSTRUCTIONS
3254: (p_operation => l_operation
3262: END IF;
3263:
3264: END IF;
3265:
3266: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
3267: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
3268:
3269: l_result := SHIPPING_METHOD
3270: (p_operation => l_operation
3278: END IF;
3279:
3280: END IF;
3281:
3282: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
3283: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
3284:
3285: l_result := SHIP_FROM_ORG
3286: (p_operation => l_operation
3294: END IF;
3295:
3296: END IF;
3297:
3298: IF p_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
3299: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_above,p_old_header_rec.ship_tolerance_above) THEN
3300:
3301: l_result := SHIP_TOLERANCE_ABOVE
3302: (p_operation => l_operation
3310: END IF;
3311:
3312: END IF;
3313:
3314: IF p_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
3315: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_below,p_old_header_rec.ship_tolerance_below) THEN
3316:
3317: l_result := SHIP_TOLERANCE_BELOW
3318: (p_operation => l_operation
3326: END IF;
3327:
3328: END IF;
3329:
3330: IF p_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3331: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id) THEN
3332:
3333: l_result := SHIP_TO_CONTACT
3334: (p_operation => l_operation
3342: END IF;
3343:
3344: END IF;
3345:
3346: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3347: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
3348:
3349: l_result := SHIP_TO_ORG
3350: (p_operation => l_operation
3358: END IF;
3359:
3360: END IF;
3361:
3362: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3363: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
3364:
3365: l_result := SOLD_TO_CONTACT
3366: (p_operation => l_operation
3374: END IF;
3375:
3376: END IF;
3377:
3378: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3379: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
3380:
3381: l_result := SOLD_TO_ORG
3382: (p_operation => l_operation
3390: END IF;
3391:
3392: END IF;
3393:
3394: IF p_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
3395: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag) THEN
3396:
3397: l_result := TAX_EXEMPT
3398: (p_operation => l_operation
3406: END IF;
3407:
3408: END IF;
3409:
3410: IF p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
3411: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number,p_old_header_rec.tax_exempt_number) THEN
3412:
3413: l_result := TAX_EXEMPT_NUMBER
3414: (p_operation => l_operation
3422: END IF;
3423:
3424: END IF;
3425:
3426: IF p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3427: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code,p_old_header_rec.tax_exempt_reason_code) THEN
3428:
3429: l_result := TAX_EXEMPT_REASON
3430: (p_operation => l_operation
3438: END IF;
3439:
3440: END IF;
3441:
3442: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
3443: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
3444:
3445: l_result := TRANSACTIONAL_CURR
3446: (p_operation => l_operation
3455:
3456: END IF;
3457:
3458: -- for bug 2395032
3459: IF p_header_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
3460: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount,p_old_header_rec.payment_amount) THEN
3461:
3462: l_result := PAYMENT_AMOUNT
3463: (p_operation => l_operation
3471: END IF;
3472:
3473: END IF;
3474:
3475: IF p_header_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
3476: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.check_number,p_old_header_rec.check_number) THEN
3477:
3478: l_result := CHECK_NUMBER
3479: (p_operation => l_operation
3489: END IF;
3490: -- end 2395032
3491:
3492: -- BEGIN: Blankets Code Merge
3493: IF p_header_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
3494: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number,p_old_header_rec.blanket_number) THEN
3495:
3496: l_result := BLANKET_NUMBER
3497: (p_operation => l_operation
3508: -- END: Blankets Code Merge
3509:
3510: -- Quoting Changes Start
3511:
3512: IF p_header_rec.quote_number = FND_API.G_MISS_NUM THEN NULL;
3513: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number,p_old_header_rec.quote_number) THEN
3514:
3515: l_result := QUOTE_NUMBER
3516: (p_operation => l_operation
3524: END IF;
3525:
3526: END IF;
3527:
3528: IF p_header_rec.quote_date = FND_API.G_MISS_DATE THEN NULL;
3529: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date,p_old_header_rec.quote_date) THEN
3530:
3531: l_result := QUOTE_DATE
3532: (p_operation => l_operation
3540: END IF;
3541:
3542: END IF;
3543:
3544: IF p_header_rec.sales_document_name = FND_API.G_MISS_CHAR THEN NULL;
3545: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_document_name,p_old_header_rec.sales_document_name) THEN
3546:
3547: l_result := SALES_DOCUMENT_NAME
3548: (p_operation => l_operation
3556: END IF;
3557:
3558: END IF;
3559:
3560: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
3561: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
3562:
3563: l_result := TRANSACTION_PHASE
3564: (p_operation => l_operation
3572: END IF;
3573:
3574: END IF;
3575:
3576: IF p_header_rec.user_status_code = FND_API.G_MISS_CHAR THEN NULL;
3577: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.user_status_code,p_old_header_rec.user_status_code) THEN
3578:
3579: l_result := USER_STATUS
3580: (p_operation => l_operation
3588: END IF;
3589:
3590: END IF;
3591:
3592: IF p_header_rec.expiration_date = FND_API.G_MISS_DATE THEN NULL;
3593: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.expiration_date),trunc(p_old_header_rec.expiration_date)) THEN
3594:
3595: l_result := EXPIRATION_DATE
3596: (p_operation => l_operation
3604: END IF;
3605:
3606: END IF;
3607:
3608: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
3609: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
3610:
3611: l_result := VERSION_NUMBER
3612: (p_operation => l_operation
3620: END IF;
3621:
3622: END IF;
3623:
3624: IF p_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN NULL;
3625: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id) THEN
3626:
3627: l_result := SOLD_TO_SITE_USE
3628: (p_operation => l_operation
3639:
3640: -- Quoting Changes END
3641:
3642: -- Bug 8217769 New IF added for Default Fulfillment Set
3643: IF p_header_rec.DEFAULT_FULFILLMENT_SET = FND_API.G_MISS_CHAR THEN NULL;
3644: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_FULFILLMENT_SET,p_old_header_rec.DEFAULT_FULFILLMENT_SET) THEN
3645:
3646: l_result := DEFAULT_FULFILLMENT_SET
3647: (p_operation => l_operation
3672: l_check_all_cols_constraint := g_check_all_cols_constraint;
3673: g_check_all_cols_constraint := 'N';
3674: END IF;
3675:
3676: IF p_header_rec.context = FND_API.G_MISS_CHAR THEN NULL;
3677: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.context,p_old_header_rec.context) THEN
3678:
3679: l_result := CONTEXT
3680: (p_operation => l_operation
3688: END IF;
3689:
3690: END IF;
3691:
3692: IF p_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
3693: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute1,p_old_header_rec.attribute1) THEN
3694:
3695: l_result := ATTRIBUTE1
3696: (p_operation => l_operation
3704: END IF;
3705:
3706: END IF;
3707:
3708: IF p_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
3709: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute10,p_old_header_rec.attribute10) THEN
3710:
3711: l_result := ATTRIBUTE10
3712: (p_operation => l_operation
3720: END IF;
3721:
3722: END IF;
3723:
3724: IF p_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
3725: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute11,p_old_header_rec.attribute11) THEN
3726:
3727: l_result := ATTRIBUTE11
3728: (p_operation => l_operation
3736: END IF;
3737:
3738: END IF;
3739:
3740: IF p_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
3741: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute12,p_old_header_rec.attribute12) THEN
3742:
3743: l_result := ATTRIBUTE12
3744: (p_operation => l_operation
3752: END IF;
3753:
3754: END IF;
3755:
3756: IF p_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
3757: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute13,p_old_header_rec.attribute13) THEN
3758:
3759: l_result := ATTRIBUTE13
3760: (p_operation => l_operation
3768: END IF;
3769:
3770: END IF;
3771:
3772: IF p_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
3773: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute14,p_old_header_rec.attribute14) THEN
3774:
3775: l_result := ATTRIBUTE14
3776: (p_operation => l_operation
3784: END IF;
3785:
3786: END IF;
3787:
3788: IF p_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
3789: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute15,p_old_header_rec.attribute15) THEN
3790:
3791: l_result := ATTRIBUTE15
3792: (p_operation => l_operation
3801:
3802: END IF;
3803:
3804: --For bug 2184255
3805: IF p_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
3806: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute16,p_old_header_rec.attribute16) THEN
3807:
3808: l_result := ATTRIBUTE16
3809: (p_operation => l_operation
3817: END IF;
3818:
3819: END IF;
3820:
3821: IF p_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
3822: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute17,p_old_header_rec.attribute17) THEN
3823:
3824: l_result := ATTRIBUTE17
3825: (p_operation => l_operation
3833: END IF;
3834:
3835: END IF;
3836:
3837: IF p_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
3838: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute18,p_old_header_rec.attribute18) THEN
3839:
3840: l_result := ATTRIBUTE18
3841: (p_operation => l_operation
3849: END IF;
3850:
3851: END IF;
3852:
3853: IF p_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
3854: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute19,p_old_header_rec.attribute19) THEN
3855:
3856: l_result := ATTRIBUTE19
3857: (p_operation => l_operation
3865: END IF;
3866:
3867: END IF;
3868:
3869: IF p_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
3870: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute2,p_old_header_rec.attribute2) THEN
3871:
3872: l_result := ATTRIBUTE2
3873: (p_operation => l_operation
3881: END IF;
3882:
3883: END IF;
3884:
3885: IF p_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
3886: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute20,p_old_header_rec.attribute20) THEN
3887:
3888: l_result := ATTRIBUTE20
3889: (p_operation => l_operation
3899: END IF;
3900:
3901: --End bug 2184255
3902:
3903: IF p_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
3904: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute3,p_old_header_rec.attribute3) THEN
3905:
3906: l_result := ATTRIBUTE3
3907: (p_operation => l_operation
3915: END IF;
3916:
3917: END IF;
3918:
3919: IF p_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
3920: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute4,p_old_header_rec.attribute4) THEN
3921:
3922: l_result := ATTRIBUTE4
3923: (p_operation => l_operation
3931: END IF;
3932:
3933: END IF;
3934:
3935: IF p_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
3936: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute5,p_old_header_rec.attribute5) THEN
3937:
3938: l_result := ATTRIBUTE5
3939: (p_operation => l_operation
3947: END IF;
3948:
3949: END IF;
3950:
3951: IF p_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
3952: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute6,p_old_header_rec.attribute6) THEN
3953:
3954: l_result := ATTRIBUTE6
3955: (p_operation => l_operation
3963: END IF;
3964:
3965: END IF;
3966:
3967: IF p_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
3968: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute7,p_old_header_rec.attribute7) THEN
3969:
3970: l_result := ATTRIBUTE7
3971: (p_operation => l_operation
3979: END IF;
3980:
3981: END IF;
3982:
3983: IF p_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
3984: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute8,p_old_header_rec.attribute8) THEN
3985:
3986: l_result := ATTRIBUTE8
3987: (p_operation => l_operation
3995: END IF;
3996:
3997: END IF;
3998:
3999: IF p_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
4000: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute9,p_old_header_rec.attribute9) THEN
4001:
4002: l_result := ATTRIBUTE9
4003: (p_operation => l_operation
4028: END IF;
4029:
4030: EXCEPTION
4031: WHEN e_inacitve_pl THEN
4032: x_return_status := FND_API.G_RET_STS_ERROR;
4033: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
4034: OE_MSG_PUB.ADD;
4035:
4036: WHEN FND_API.G_EXC_ERROR THEN
4032: x_return_status := FND_API.G_RET_STS_ERROR;
4033: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
4034: OE_MSG_PUB.ADD;
4035:
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: x_return_status := FND_API.G_RET_STS_ERROR;
4038: WHEN OTHERS THEN
4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4033: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
4034: OE_MSG_PUB.ADD;
4035:
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: x_return_status := FND_API.G_RET_STS_ERROR;
4038: WHEN OTHERS THEN
4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4041: OE_MSG_PUB.Add_Exc_Msg
4035:
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: x_return_status := FND_API.G_RET_STS_ERROR;
4038: WHEN OTHERS THEN
4039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4041: OE_MSG_PUB.Add_Exc_Msg
4042: ( G_PKG_NAME
4043: , 'Attributes'