[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;
2365: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2366: END IF;
2367:
2368: -- Initializing return status to SUCCESS
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;
2370:
2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2377: ELSE
2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2380: END IF;
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383:
2384: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
2385:
2397: END IF;
2398:
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2403: OE_MSG_PUB.Add_Exc_Msg
2404: ( G_PKG_NAME
2405: , 'Entity'
2433: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
2434: END IF;
2435:
2436: -- Initializing return status to SUCCESS
2437: x_return_status := FND_API.G_RET_STS_SUCCESS;
2438:
2439: -- Initializing out result to NOT CONSTRAINED
2440: x_result := OE_PC_GLOBALS.NO;
2441:
2467: ELSE
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2470: END IF;
2471: RAISE FND_API.G_EXC_ERROR;
2472: END IF;
2473:
2474: OE_HEADER_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
2475:
2478:
2479: -- Compare the new and old entity records and
2480: -- check constraints for all the changed attributes.
2481:
2482: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
2483: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
2484: p_old_header_rec.cancelled_flag)
2485: THEN
2486: IF p_header_rec.cancelled_flag = 'Y' THEN
2522: END IF;
2523: END;
2524: END IF;
2525:
2526: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2527: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
2528:
2529: l_result := ACCOUNTING_RULE
2530: (p_operation => l_operation
2538: END IF;
2539:
2540: END IF;
2541:
2542: IF p_header_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
2543: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_OWNER,p_old_header_rec.IB_OWNER) THEN
2544:
2545: l_result := IB_OWNER
2546: (p_operation => l_operation
2553: x_result := OE_PC_GLOBALS.YES;
2554: END IF;
2555:
2556: END IF;
2557: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2558: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_INSTALLED_AT_LOCATION,p_old_header_rec.IB_INSTALLED_AT_LOCATION) THEN
2559:
2560: l_result := IB_INSTALLED_AT_LOCATION
2561: (p_operation => l_operation
2568: x_result := OE_PC_GLOBALS.YES;
2569: END IF;
2570:
2571: END IF;
2572: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2573: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_CURRENT_LOCATION,p_old_header_rec.IB_CURRENT_LOCATION) THEN
2574:
2575: l_result := IB_CURRENT_LOCATION
2576: (p_operation => l_operation
2583: x_result := OE_PC_GLOBALS.YES;
2584: END IF;
2585:
2586: END IF;
2587: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
2588: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_ID,p_old_header_rec.END_CUSTOMER_ID) THEN
2589:
2590: l_result := END_CUSTOMER
2591: (p_operation => l_operation
2598: x_result := OE_PC_GLOBALS.YES;
2599: END IF;
2600:
2601: END IF;
2602: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2603: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_SITE_USE_ID,p_old_header_rec.END_CUSTOMER_SITE_USE_ID) THEN
2604:
2605: l_result := END_CUSTOMER_SITE_USE
2606: (p_operation => l_operation
2613: x_result := OE_PC_GLOBALS.YES;
2614: END IF;
2615:
2616: END IF;
2617: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
2618: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_CONTACT_ID,p_old_header_rec.END_CUSTOMER_CONTACT_ID) THEN
2619:
2620: l_result := END_CUSTOMER_CONTACT
2621: (p_operation => l_operation
2629: END IF;
2630:
2631: END IF;
2632:
2633: IF p_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
2634: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_duration,p_old_header_rec.accounting_rule_duration) THEN
2635:
2636: l_result := ACCOUNTING_RULE_DURATION
2637: (p_operation => l_operation
2645: END IF;
2646:
2647: END IF;
2648:
2649: IF p_header_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
2650: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id,p_old_header_rec.agreement_id) THEN
2651:
2652: l_result := AGREEMENT
2653: (p_operation => l_operation
2661: END IF;
2662:
2663: END IF;
2664:
2665: IF p_header_rec.conversion_rate = FND_API.G_MISS_NUM THEN NULL;
2666: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate,p_old_header_rec.conversion_rate) THEN
2667:
2668: l_result := CONVERSION_RATE
2669: (p_operation => l_operation
2677: END IF;
2678:
2679: END IF;
2680:
2681: IF p_header_rec.conversion_rate_date = FND_API.G_MISS_DATE THEN NULL;
2682: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate_date,p_old_header_rec.conversion_rate_date) THEN
2683:
2684: l_result := CONVERSION_RATE_DATE
2685: (p_operation => l_operation
2693: END IF;
2694:
2695: END IF;
2696:
2697: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
2698: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
2699:
2700: l_result := CONVERSION_TYPE
2701: (p_operation => l_operation
2709: END IF;
2710:
2711: END IF;
2712:
2713: IF p_header_rec.created_by = FND_API.G_MISS_NUM THEN NULL;
2714: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.created_by,p_old_header_rec.created_by) THEN
2715:
2716: l_result := CREATED_BY
2717: (p_operation => l_operation
2725: END IF;
2726:
2727: END IF;
2728:
2729: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2730: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
2731:
2732: l_result := CUST_PO_NUMBER
2733: (p_operation => l_operation
2741: END IF;
2742:
2743: END IF;
2744:
2745: IF p_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2746: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id,p_old_header_rec.deliver_to_contact_id) THEN
2747:
2748: l_result := DELIVER_TO_CONTACT
2749: (p_operation => l_operation
2757: END IF;
2758:
2759: END IF;
2760:
2761: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2762: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
2763:
2764: l_result := DELIVER_TO_ORG
2765: (p_operation => l_operation
2773: END IF;
2774:
2775: END IF;
2776:
2777: IF p_header_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.demand_class_code,p_old_header_rec.demand_class_code) THEN
2779:
2780: l_result := DEMAND_CLASS
2781: (p_operation => l_operation
2789: END IF;
2790:
2791: END IF;
2792:
2793: IF p_header_rec.earliest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2794: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.earliest_schedule_limit,p_old_header_rec.earliest_schedule_limit) THEN
2795:
2796: l_result := EARLIEST_SCHEDULE_LIMIT
2797: (p_operation => l_operation
2805: END IF;
2806:
2807: END IF;
2808:
2809: IF p_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
2810: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.fob_point_code,p_old_header_rec.fob_point_code) THEN
2811:
2812: l_result := FOB_POINT
2813: (p_operation => l_operation
2821: END IF;
2822:
2823: END IF;
2824:
2825: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2826: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
2827:
2828: l_result := FREIGHT_TERMS
2829: (p_operation => l_operation
2837: END IF;
2838:
2839: END IF;
2840:
2841: IF p_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2842: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id) THEN
2843:
2844: l_result := INVOICE_TO_CONTACT
2845: (p_operation => l_operation
2853: END IF;
2854:
2855: END IF;
2856:
2857: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2858: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
2859:
2860: l_result := INVOICE_TO_ORG
2861: (p_operation => l_operation
2869: END IF;
2870:
2871: END IF;
2872:
2873: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2874: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
2875:
2876: l_result := INVOICING_RULE
2877: (p_operation => l_operation
2885: END IF;
2886:
2887: END IF;
2888:
2889: IF p_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2890: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.latest_schedule_limit,p_old_header_rec.latest_schedule_limit) THEN
2891:
2892: l_result := LATEST_SCHEDULE_LIMIT
2893: (p_operation => l_operation
2901: END IF;
2902:
2903: END IF;
2904:
2905: IF p_header_rec.ordered_date = FND_API.G_MISS_DATE THEN NULL;
2906: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date,p_old_header_rec.ordered_date) THEN
2907:
2908: l_result := ORDERED_DATE
2909: (p_operation => l_operation
2917: END IF;
2918:
2919: END IF;
2920:
2921: IF p_header_rec.order_date_type_code = FND_API.G_MISS_CHAR THEN NULL;
2922: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_date_type_code,p_old_header_rec.order_date_type_code) THEN
2923:
2924: l_result := ORDER_DATE_TYPE_CODE
2925: (p_operation => l_operation
2933: END IF;
2934:
2935: END IF;
2936:
2937: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
2938: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
2939:
2940: l_result := ORDER_NUMBER
2941: (p_operation => l_operation
2949: END IF;
2950:
2951: END IF;
2952:
2953: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
2954: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
2955:
2956: l_result := ORDER_TYPE
2957: (p_operation => l_operation
2965: END IF;
2966:
2967: END IF;
2968:
2969: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
2970: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
2971:
2972: l_result := PACKING_INSTRUCTIONS
2973: (p_operation => l_operation
2981: END IF;
2982:
2983: END IF;
2984:
2985: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
2986: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
2987:
2988: l_result := PAYMENT_TERM
2989: (p_operation => l_operation
2997: END IF;
2998:
2999: END IF;
3000:
3001: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
3002: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
3003:
3004: l_result := PRICE_LIST
3005: (p_operation => l_operation
3013: END IF;
3014:
3015: END IF;
3016:
3017: IF p_header_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
3018: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.pricing_date,p_old_header_rec.pricing_date) THEN
3019:
3020: l_result := PRICING_DATE
3021: (p_operation => l_operation
3029: END IF;
3030:
3031: END IF;
3032:
3033: IF p_header_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
3034: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.request_date,p_old_header_rec.request_date) THEN
3035:
3036: l_result := REQUEST_DATE
3037: (p_operation => l_operation
3045: END IF;
3046:
3047: END IF;
3048:
3049: IF p_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3050: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.return_reason_code,p_old_header_rec.return_reason_code) THEN
3051:
3052: l_result := RETURN_REASON
3053: (p_operation => l_operation
3061: END IF;
3062:
3063: END IF;
3064:
3065: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
3066: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
3067:
3068: l_result := SALESREP
3069: (p_operation => l_operation
3077: END IF;
3078:
3079: END IF;
3080:
3081: IF p_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN NULL;
3082: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code) THEN
3083:
3084: l_result := SALES_CHANNEL_CODE
3085: (p_operation => l_operation
3094:
3095: END IF;
3096:
3097: /* START PREPAYMENT */
3098: IF p_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
3099: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code, p_old_header_rec.payment_type_code) THEN
3100:
3101: l_result := PAYMENT_TYPE
3102: (p_operation => l_operation
3109: END IF;
3110:
3111: END IF;
3112:
3113: IF p_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
3114: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name) THEN
3115:
3116: l_result := CREDIT_CARD_HOLDER_NAME
3117: (p_operation => l_operation
3124: END IF;
3125:
3126: END IF;
3127:
3128: IF p_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
3129: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code, p_old_header_rec.credit_card_code) THEN
3130:
3131: l_result := CREDIT_CARD
3132: (p_operation => l_operation
3139: END IF;
3140:
3141: END IF;
3142:
3143: IF p_header_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;
3144: --R12 CC Encryption
3145: --Since the credit card numbers are encrypted, calling
3146: --the function same credit card to determine whether the old
3147: --and new card numbers are equal.
3160: END IF;
3161:
3162: END IF;
3163:
3164: IF p_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
3165: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date) THEN
3166:
3167: l_result := CREDIT_CARD_EXPIRATION_DATE
3168: (p_operation => l_operation
3176:
3177: END IF;
3178: /* END PREPAYMENT */
3179:
3180: IF p_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
3181: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipment_priority_code,p_old_header_rec.shipment_priority_code) THEN
3182:
3183: l_result := SHIPMENT_PRIORITY
3184: (p_operation => l_operation
3192: END IF;
3193:
3194: END IF;
3195:
3196: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
3197: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
3198:
3199: l_result := SHIPPING_INSTRUCTIONS
3200: (p_operation => l_operation
3208: END IF;
3209:
3210: END IF;
3211:
3212: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
3213: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
3214:
3215: l_result := SHIPPING_METHOD
3216: (p_operation => l_operation
3224: END IF;
3225:
3226: END IF;
3227:
3228: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
3229: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
3230:
3231: l_result := SHIP_FROM_ORG
3232: (p_operation => l_operation
3240: END IF;
3241:
3242: END IF;
3243:
3244: IF p_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
3245: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_above,p_old_header_rec.ship_tolerance_above) THEN
3246:
3247: l_result := SHIP_TOLERANCE_ABOVE
3248: (p_operation => l_operation
3256: END IF;
3257:
3258: END IF;
3259:
3260: IF p_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
3261: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_below,p_old_header_rec.ship_tolerance_below) THEN
3262:
3263: l_result := SHIP_TOLERANCE_BELOW
3264: (p_operation => l_operation
3272: END IF;
3273:
3274: END IF;
3275:
3276: IF p_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3277: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id) THEN
3278:
3279: l_result := SHIP_TO_CONTACT
3280: (p_operation => l_operation
3288: END IF;
3289:
3290: END IF;
3291:
3292: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3293: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
3294:
3295: l_result := SHIP_TO_ORG
3296: (p_operation => l_operation
3304: END IF;
3305:
3306: END IF;
3307:
3308: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3309: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
3310:
3311: l_result := SOLD_TO_CONTACT
3312: (p_operation => l_operation
3320: END IF;
3321:
3322: END IF;
3323:
3324: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3325: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
3326:
3327: l_result := SOLD_TO_ORG
3328: (p_operation => l_operation
3336: END IF;
3337:
3338: END IF;
3339:
3340: IF p_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
3341: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag) THEN
3342:
3343: l_result := TAX_EXEMPT
3344: (p_operation => l_operation
3352: END IF;
3353:
3354: END IF;
3355:
3356: IF p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
3357: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number,p_old_header_rec.tax_exempt_number) THEN
3358:
3359: l_result := TAX_EXEMPT_NUMBER
3360: (p_operation => l_operation
3368: END IF;
3369:
3370: END IF;
3371:
3372: IF p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3373: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code,p_old_header_rec.tax_exempt_reason_code) THEN
3374:
3375: l_result := TAX_EXEMPT_REASON
3376: (p_operation => l_operation
3384: END IF;
3385:
3386: END IF;
3387:
3388: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
3389: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
3390:
3391: l_result := TRANSACTIONAL_CURR
3392: (p_operation => l_operation
3401:
3402: END IF;
3403:
3404: -- for bug 2395032
3405: IF p_header_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
3406: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount,p_old_header_rec.payment_amount) THEN
3407:
3408: l_result := PAYMENT_AMOUNT
3409: (p_operation => l_operation
3417: END IF;
3418:
3419: END IF;
3420:
3421: IF p_header_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
3422: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.check_number,p_old_header_rec.check_number) THEN
3423:
3424: l_result := CHECK_NUMBER
3425: (p_operation => l_operation
3435: END IF;
3436: -- end 2395032
3437:
3438: -- BEGIN: Blankets Code Merge
3439: IF p_header_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
3440: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number,p_old_header_rec.blanket_number) THEN
3441:
3442: l_result := BLANKET_NUMBER
3443: (p_operation => l_operation
3454: -- END: Blankets Code Merge
3455:
3456: -- Quoting Changes Start
3457:
3458: IF p_header_rec.quote_number = FND_API.G_MISS_NUM THEN NULL;
3459: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number,p_old_header_rec.quote_number) THEN
3460:
3461: l_result := QUOTE_NUMBER
3462: (p_operation => l_operation
3470: END IF;
3471:
3472: END IF;
3473:
3474: IF p_header_rec.quote_date = FND_API.G_MISS_DATE THEN NULL;
3475: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date,p_old_header_rec.quote_date) THEN
3476:
3477: l_result := QUOTE_DATE
3478: (p_operation => l_operation
3486: END IF;
3487:
3488: END IF;
3489:
3490: IF p_header_rec.sales_document_name = FND_API.G_MISS_CHAR THEN NULL;
3491: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_document_name,p_old_header_rec.sales_document_name) THEN
3492:
3493: l_result := SALES_DOCUMENT_NAME
3494: (p_operation => l_operation
3502: END IF;
3503:
3504: END IF;
3505:
3506: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
3507: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
3508:
3509: l_result := TRANSACTION_PHASE
3510: (p_operation => l_operation
3518: END IF;
3519:
3520: END IF;
3521:
3522: IF p_header_rec.user_status_code = FND_API.G_MISS_CHAR THEN NULL;
3523: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.user_status_code,p_old_header_rec.user_status_code) THEN
3524:
3525: l_result := USER_STATUS
3526: (p_operation => l_operation
3534: END IF;
3535:
3536: END IF;
3537:
3538: IF p_header_rec.expiration_date = FND_API.G_MISS_DATE THEN NULL;
3539: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.expiration_date),trunc(p_old_header_rec.expiration_date)) THEN
3540:
3541: l_result := EXPIRATION_DATE
3542: (p_operation => l_operation
3550: END IF;
3551:
3552: END IF;
3553:
3554: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
3555: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
3556:
3557: l_result := VERSION_NUMBER
3558: (p_operation => l_operation
3566: END IF;
3567:
3568: END IF;
3569:
3570: IF p_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN NULL;
3571: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id) THEN
3572:
3573: l_result := SOLD_TO_SITE_USE
3574: (p_operation => l_operation
3600: l_check_all_cols_constraint := g_check_all_cols_constraint;
3601: g_check_all_cols_constraint := 'N';
3602: END IF;
3603:
3604: IF p_header_rec.context = FND_API.G_MISS_CHAR THEN NULL;
3605: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.context,p_old_header_rec.context) THEN
3606:
3607: l_result := CONTEXT
3608: (p_operation => l_operation
3616: END IF;
3617:
3618: END IF;
3619:
3620: IF p_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
3621: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute1,p_old_header_rec.attribute1) THEN
3622:
3623: l_result := ATTRIBUTE1
3624: (p_operation => l_operation
3632: END IF;
3633:
3634: END IF;
3635:
3636: IF p_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
3637: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute10,p_old_header_rec.attribute10) THEN
3638:
3639: l_result := ATTRIBUTE10
3640: (p_operation => l_operation
3648: END IF;
3649:
3650: END IF;
3651:
3652: IF p_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
3653: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute11,p_old_header_rec.attribute11) THEN
3654:
3655: l_result := ATTRIBUTE11
3656: (p_operation => l_operation
3664: END IF;
3665:
3666: END IF;
3667:
3668: IF p_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
3669: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute12,p_old_header_rec.attribute12) THEN
3670:
3671: l_result := ATTRIBUTE12
3672: (p_operation => l_operation
3680: END IF;
3681:
3682: END IF;
3683:
3684: IF p_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
3685: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute13,p_old_header_rec.attribute13) THEN
3686:
3687: l_result := ATTRIBUTE13
3688: (p_operation => l_operation
3696: END IF;
3697:
3698: END IF;
3699:
3700: IF p_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
3701: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute14,p_old_header_rec.attribute14) THEN
3702:
3703: l_result := ATTRIBUTE14
3704: (p_operation => l_operation
3712: END IF;
3713:
3714: END IF;
3715:
3716: IF p_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
3717: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute15,p_old_header_rec.attribute15) THEN
3718:
3719: l_result := ATTRIBUTE15
3720: (p_operation => l_operation
3729:
3730: END IF;
3731:
3732: --For bug 2184255
3733: IF p_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
3734: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute16,p_old_header_rec.attribute16) THEN
3735:
3736: l_result := ATTRIBUTE16
3737: (p_operation => l_operation
3745: END IF;
3746:
3747: END IF;
3748:
3749: IF p_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
3750: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute17,p_old_header_rec.attribute17) THEN
3751:
3752: l_result := ATTRIBUTE17
3753: (p_operation => l_operation
3761: END IF;
3762:
3763: END IF;
3764:
3765: IF p_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
3766: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute18,p_old_header_rec.attribute18) THEN
3767:
3768: l_result := ATTRIBUTE18
3769: (p_operation => l_operation
3777: END IF;
3778:
3779: END IF;
3780:
3781: IF p_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
3782: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute19,p_old_header_rec.attribute19) THEN
3783:
3784: l_result := ATTRIBUTE19
3785: (p_operation => l_operation
3793: END IF;
3794:
3795: END IF;
3796:
3797: IF p_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
3798: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute2,p_old_header_rec.attribute2) THEN
3799:
3800: l_result := ATTRIBUTE2
3801: (p_operation => l_operation
3809: END IF;
3810:
3811: END IF;
3812:
3813: IF p_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
3814: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute20,p_old_header_rec.attribute20) THEN
3815:
3816: l_result := ATTRIBUTE20
3817: (p_operation => l_operation
3827: END IF;
3828:
3829: --End bug 2184255
3830:
3831: IF p_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
3832: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute3,p_old_header_rec.attribute3) THEN
3833:
3834: l_result := ATTRIBUTE3
3835: (p_operation => l_operation
3843: END IF;
3844:
3845: END IF;
3846:
3847: IF p_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
3848: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute4,p_old_header_rec.attribute4) THEN
3849:
3850: l_result := ATTRIBUTE4
3851: (p_operation => l_operation
3859: END IF;
3860:
3861: END IF;
3862:
3863: IF p_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
3864: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute5,p_old_header_rec.attribute5) THEN
3865:
3866: l_result := ATTRIBUTE5
3867: (p_operation => l_operation
3875: END IF;
3876:
3877: END IF;
3878:
3879: IF p_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
3880: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute6,p_old_header_rec.attribute6) THEN
3881:
3882: l_result := ATTRIBUTE6
3883: (p_operation => l_operation
3891: END IF;
3892:
3893: END IF;
3894:
3895: IF p_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
3896: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute7,p_old_header_rec.attribute7) THEN
3897:
3898: l_result := ATTRIBUTE7
3899: (p_operation => l_operation
3907: END IF;
3908:
3909: END IF;
3910:
3911: IF p_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
3912: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute8,p_old_header_rec.attribute8) THEN
3913:
3914: l_result := ATTRIBUTE8
3915: (p_operation => l_operation
3923: END IF;
3924:
3925: END IF;
3926:
3927: IF p_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
3928: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute9,p_old_header_rec.attribute9) THEN
3929:
3930: l_result := ATTRIBUTE9
3931: (p_operation => l_operation
3956: END IF;
3957:
3958: EXCEPTION
3959: WHEN e_inacitve_pl THEN
3960: x_return_status := FND_API.G_RET_STS_ERROR;
3961: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
3962: OE_MSG_PUB.ADD;
3963:
3964: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_ERROR;
3961: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
3962: OE_MSG_PUB.ADD;
3963:
3964: WHEN FND_API.G_EXC_ERROR THEN
3965: x_return_status := FND_API.G_RET_STS_ERROR;
3966: WHEN OTHERS THEN
3967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3961: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
3962: OE_MSG_PUB.ADD;
3963:
3964: WHEN FND_API.G_EXC_ERROR THEN
3965: x_return_status := FND_API.G_RET_STS_ERROR;
3966: WHEN OTHERS THEN
3967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3969: OE_MSG_PUB.Add_Exc_Msg
3963:
3964: WHEN FND_API.G_EXC_ERROR THEN
3965: x_return_status := FND_API.G_RET_STS_ERROR;
3966: WHEN OTHERS THEN
3967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3969: OE_MSG_PUB.Add_Exc_Msg
3970: ( G_PKG_NAME
3971: , 'Attributes'