[Home] [Help]
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Security';
7:
8: g_header_id NUMBER := FND_API.G_MISS_NUM;
9:
10: -- LOCAL PROCEDURES
11:
12: FUNCTION Is_Op_Constrained
76: if l_column_name is null then
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
79: END IF;
80: RAISE FND_API.G_EXC_ERROR;
81: end if;
82: END IF;
83:
84: elsif l_result = OE_PC_GLOBALS.ERROR then
82: END IF;
83:
84: elsif l_result = OE_PC_GLOBALS.ERROR then
85:
86: raise FND_API.G_EXC_UNEXPECTED_ERROR;
87:
88: end if;
89:
90: g_check_all_cols_constraint := 'N';
136: x_is_delivery_required => l_is_delivery_reqd,
137: x_return_status => l_return_status
138: );
139:
140: If l_return_status = FND_API.G_RET_STS_SUCCESS And
141: l_is_delivery_reqd = 'Y'
142: Then
143: l_gen_xml := 'B';
144: End If;
206: x_is_delivery_required => l_is_delivery_reqd,
207: x_return_status => l_return_status
208: );
209:
210: If l_return_status = FND_API.G_RET_STS_SUCCESS And
211: l_is_delivery_reqd = 'Y'
212: Then
213: l_gen_xml := 'B';
214: End IF;
315: x_is_delivery_required => l_is_delivery_reqd,
316: x_return_status => l_return_status
317: );
318:
319: If l_return_status = FND_API.G_RET_STS_SUCCESS And
320: l_is_delivery_reqd = 'Y'
321: Then
322: l_gen_xml := 'B';
323: End If;
1653: IF NVL(p_record.transaction_phase_code,'F') = 'F'
1654: AND p_operation = OE_PC_GLOBALS.UPDATE_OP
1655: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1656: AND NOT(p_record.split_action_code IS NOT NULL AND
1657: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1658: l_result := ORDERED_QUANTITY
1659: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1660: ,p_record => p_record
1661: ,x_on_operation_action => x_on_operation_action
1661: ,x_on_operation_action => x_on_operation_action
1662: );
1663: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1664: AND (p_record.split_action_code IS NOT NULL AND
1665: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1666: p_record.split_action_code = 'SPLIT') THEN
1667: l_result := ORDERED_QUANTITY
1668: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1669: ,p_record => p_record
1704: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED
1705: IF p_operation = OE_PC_GLOBALS.UPDATE_OP
1706: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1707: AND NOT(p_record.split_action_code IS NOT NULL AND
1708: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1709: l_result := ORDERED_QUANTITY2
1710: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1711: ,p_record => p_record
1712: ,x_on_operation_action => x_on_operation_action
1712: ,x_on_operation_action => x_on_operation_action
1713: );
1714: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1715: AND (p_record.split_action_code IS NOT NULL AND
1716: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1717: p_record.split_action_code = 'SPLIT') THEN
1718: l_result := ORDERED_QUANTITY2
1719: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1720: ,p_record => p_record
3130: oe_debug_pub.add('Enter OE_LINE_Security.Entity',1);
3131: END IF;
3132:
3133: -- Initializing return status to SUCCESS
3134: x_return_status := FND_API.G_RET_STS_SUCCESS;
3135:
3136: /* start of bug 2922204 */
3137:
3138: IF l_debug_level > 0 THEN
3193: ELSE
3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Invalid operation',1);
3196: END IF;
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:
3200: OE_LINE_Util_Ext.API_Rec_To_Rowtype_Rec
3201: (p_LINE_rec => p_line_rec
3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3223: END IF;
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3229: WHEN OTHERS THEN
3222: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3223: END IF;
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223: END IF;
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3232: OE_MSG_PUB.Add_Exc_Msg
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3232: OE_MSG_PUB.Add_Exc_Msg
3233: ( G_PKG_NAME
3234: , 'Entity'
3258: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);
3259: END IF;
3260:
3261: -- Initializing return status to SUCCESS
3262: x_return_status := FND_API.G_RET_STS_SUCCESS;
3263: -- Initialize g_operation_action to null
3264: g_operation_action := null;
3265:
3266: -- Initializing out result to NOT CONSTRAINED
3272: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3273: -- level check
3274: -- Bug 3859436 : if the line is being split, skip attribute check.
3275: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
3276: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3277: THEN
3278: RETURN;
3279: ELSE
3280: l_operation := OE_PC_GLOBALS.CREATE_OP;
3298: ELSE
3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add('Invalid operation',1);
3301: END IF;
3302: RAISE FND_API.G_EXC_ERROR;
3303: END IF;
3304:
3305: OE_LINE_Util_Ext.API_Rec_To_Rowtype_Rec
3306: (p_LINE_rec => p_line_rec
3311:
3312: -- Compare the new and old entity records and
3313: -- check constraints for all the changed attributes.
3314:
3315: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
3316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
3317:
3318: l_result := ACCOUNTING_RULE
3319: (p_operation => l_operation
3327: END IF;
3328:
3329: END IF;
3330:
3331: IF p_line_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
3332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_OWNER,p_old_line_rec.IB_OWNER) THEN
3333:
3334: l_result := IB_OWNER
3335: (p_operation => l_operation
3342: x_result := OE_PC_GLOBALS.YES;
3343: END IF;
3344:
3345: END IF;
3346: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3347: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_CURRENT_LOCATION,p_old_line_rec.IB_CURRENT_LOCATION) THEN
3348:
3349: l_result := IB_CURRENT_LOCATION
3350: (p_operation => l_operation
3357: x_result := OE_PC_GLOBALS.YES;
3358: END IF;
3359:
3360: END IF;
3361: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3362: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_INSTALLED_AT_LOCATION,p_old_line_rec.IB_INSTALLED_AT_LOCATION) THEN
3363:
3364: l_result := IB_INSTALLED_AT_LOCATION
3365: (p_operation => l_operation
3372: x_result := OE_PC_GLOBALS.YES;
3373: END IF;
3374:
3375: END IF;
3376: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
3377: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_ID,p_old_line_rec.END_CUSTOMER_ID) THEN
3378:
3379: l_result := END_CUSTOMER
3380: (p_operation => l_operation
3387: x_result := OE_PC_GLOBALS.YES;
3388: END IF;
3389:
3390: END IF;
3391: IF p_line_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
3392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_CONTACT_ID,p_old_line_rec.END_CUSTOMER_CONTACT_ID) THEN
3393:
3394: l_result := END_CUSTOMER_CONTACT
3395: (p_operation => l_operation
3402: x_result := OE_PC_GLOBALS.YES;
3403: END IF;
3404:
3405: END IF;
3406: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
3407: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_SITE_USE_ID,p_old_line_rec.END_CUSTOMER_SITE_USE_ID) THEN
3408:
3409: l_result := END_CUSTOMER_SITE_USE
3410: (p_operation => l_operation
3418: END IF;
3419:
3420: END IF;
3421:
3422: IF p_line_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
3423: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_duration,p_old_line_rec.accounting_rule_duration) THEN
3424:
3425: l_result := ACCOUNTING_RULE_DURATION
3426: (p_operation => l_operation
3434: END IF;
3435:
3436: END IF;
3437:
3438: IF p_line_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
3439: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id,p_old_line_rec.agreement_id) THEN
3440:
3441: l_result := AGREEMENT
3442: (p_operation => l_operation
3450: END IF;
3451:
3452: END IF;
3453:
3454: IF p_line_rec.commitment_id = FND_API.G_MISS_NUM THEN NULL;
3455: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.commitment_id,p_old_line_rec.commitment_id) THEN
3456:
3457: l_result := COMMITMENT_ID
3458: (p_operation => l_operation
3466: END IF;
3467:
3468: END IF;
3469:
3470: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3471: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3472: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3473:
3474: l_result := ARRIVAL_SET
3483: END IF;
3484:
3485: END IF;
3486:
3487: IF p_line_rec.authorized_to_ship_flag = FND_API.G_MISS_CHAR THEN NULL;
3488: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.authorized_to_ship_flag,p_old_line_rec.authorized_to_ship_flag) THEN
3489:
3490: l_result := AUTHORIZED_TO_SHIP
3491: (p_operation => l_operation
3499: END IF;
3500:
3501: END IF;
3502:
3503: IF p_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN NULL;
3504: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.credit_invoice_line_id,p_old_line_rec.credit_invoice_line_id) THEN
3505:
3506: l_result := CREDIT_INVOICE_LINE
3507: (p_operation => l_operation
3515: END IF;
3516:
3517: END IF;
3518:
3519: IF p_line_rec.customer_line_number = FND_API.G_MISS_CHAR THEN NULL;
3520: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_line_number,p_old_line_rec.customer_line_number) THEN
3521:
3522: l_result := CUSTOMER_LINE_NUMBER
3523: (p_operation => l_operation
3531: END IF;
3532:
3533: END IF;
3534:
3535: IF p_line_rec.customer_trx_line_id = FND_API.G_MISS_NUM THEN NULL;
3536: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_trx_line_id,p_old_line_rec.customer_trx_line_id) THEN
3537:
3538: l_result := CUSTOMER_TRX_LINE
3539: (p_operation => l_operation
3547: END IF;
3548:
3549: END IF;
3550:
3551: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
3552: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
3553:
3554: l_result := CUST_PO_NUMBER
3555: (p_operation => l_operation
3563: END IF;
3564:
3565: END IF;
3566:
3567: IF p_line_rec.delivery_lead_time = FND_API.G_MISS_NUM THEN NULL;
3568: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.delivery_lead_time,p_old_line_rec.delivery_lead_time) THEN
3569:
3570: l_result := DELIVERY_LEAD_TIME
3571: (p_operation => l_operation
3579: END IF;
3580:
3581: END IF;
3582:
3583: IF p_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3584: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id,p_old_line_rec.deliver_to_contact_id) THEN
3585:
3586: l_result := DELIVER_TO_CONTACT
3587: (p_operation => l_operation
3595: END IF;
3596:
3597: END IF;
3598:
3599: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3600: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN
3601:
3602: l_result := DELIVER_TO_ORG
3603: (p_operation => l_operation
3611: END IF;
3612:
3613: END IF;
3614:
3615: IF p_line_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
3616: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.demand_class_code,p_old_line_rec.demand_class_code) THEN
3617:
3618: l_result := DEMAND_CLASS
3619: (p_operation => l_operation
3627: END IF;
3628:
3629: END IF;
3630:
3631: IF p_line_rec.dep_plan_required_flag = FND_API.G_MISS_CHAR THEN NULL;
3632: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.dep_plan_required_flag,p_old_line_rec.dep_plan_required_flag) THEN
3633:
3634: l_result := DEP_PLAN_REQUIRED
3635: (p_operation => l_operation
3643: END IF;
3644:
3645: END IF;
3646:
3647: IF p_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3648: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.earliest_acceptable_date,p_old_line_rec.earliest_acceptable_date) THEN
3649:
3650: l_result := EARLIEST_ACCEPTABLE_DATE
3651: (p_operation => l_operation
3659: END IF;
3660:
3661: END IF;
3662:
3663: IF p_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN NULL;
3664: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_item_unit_number,p_old_line_rec.end_item_unit_number) THEN
3665:
3666: l_result := END_ITEM_UNIT_NUMBER
3667: (p_operation => l_operation
3675: END IF;
3676:
3677: END IF;
3678:
3679: IF p_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
3680: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fob_point_code,p_old_line_rec.fob_point_code) THEN
3681:
3682: l_result := FOB_POINT
3683: (p_operation => l_operation
3691: END IF;
3692:
3693: END IF;
3694:
3695: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
3696: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
3697:
3698: l_result := FREIGHT_TERMS
3699: (p_operation => l_operation
3707: END IF;
3708:
3709: END IF;
3710:
3711: IF p_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN NULL;
3712: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,p_old_line_rec.fulfilled_quantity) THEN
3713:
3714: l_result := FULFILLED_QUANTITY
3715: (p_operation => l_operation
3724:
3725: END IF;
3726:
3727: -- INVCONV
3728: IF p_line_rec.fulfilled_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3729: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity2,p_old_line_rec.fulfilled_quantity2) THEN
3730:
3731: l_result := FULFILLED_QUANTITY2
3732: (p_operation => l_operation
3740: END IF;
3741:
3742: END IF;
3743:
3744: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
3745: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
3746:
3747: l_result := INVENTORY_ITEM
3748: (p_operation => l_operation
3756: END IF;
3757:
3758: END IF;
3759:
3760: IF p_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3761: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id,p_old_line_rec.invoice_to_contact_id) THEN
3762:
3763: l_result := INVOICE_TO_CONTACT
3764: (p_operation => l_operation
3772: END IF;
3773:
3774: END IF;
3775:
3776: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3777: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN
3778:
3779: l_result := INVOICE_TO_ORG
3780: (p_operation => l_operation
3788: END IF;
3789:
3790: END IF;
3791:
3792: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
3793: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN
3794:
3795: l_result := INVOICING_RULE
3796: (p_operation => l_operation
3804: END IF;
3805:
3806: END IF;
3807:
3808: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;
3809: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN
3810:
3811: l_result := ITEM_IDENTIFIER_TYPE
3812: (p_operation => l_operation
3820: END IF;
3821:
3822: END IF;
3823:
3824: IF p_line_rec.item_revision = FND_API.G_MISS_CHAR THEN NULL;
3825: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_revision,p_old_line_rec.item_revision) THEN
3826:
3827: l_result := ITEM_REVISION
3828: (p_operation => l_operation
3836: END IF;
3837:
3838: END IF;
3839:
3840: IF p_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN NULL;
3841: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_type_code,p_old_line_rec.item_type_code) THEN
3842:
3843: l_result := ITEM_TYPE
3844: (p_operation => l_operation
3852: END IF;
3853:
3854: END IF;
3855:
3856: IF p_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3857: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.latest_acceptable_date,p_old_line_rec.latest_acceptable_date) THEN
3858:
3859: l_result := LATEST_ACCEPTABLE_DATE
3860: (p_operation => l_operation
3868: END IF;
3869:
3870: END IF;
3871:
3872: IF p_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN NULL;
3873: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code) THEN
3874:
3875: l_result := LINE_CATEGORY
3876: (p_operation => l_operation
3884: END IF;
3885:
3886: END IF;
3887:
3888: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;
3889: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN
3890:
3891: l_result := LINE_NUMBER
3892: (p_operation => l_operation
3900: END IF;
3901:
3902: END IF;
3903:
3904: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;
3905: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN
3906:
3907: l_result := LINE_TYPE
3908: (p_operation => l_operation
3916: END IF;
3917:
3918: END IF;
3919:
3920: IF p_line_rec.ordered_quantity = FND_API.G_MISS_NUM THEN NULL;
3921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
3922:
3923: l_result := ORDERED_QUANTITY
3924: (p_operation => l_operation
3933:
3934: END IF;
3935:
3936: -- OPM 1857167 start
3937: IF p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3938: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
3939:
3940: l_result := ORDERED_QUANTITY2
3941: (p_operation => l_operation
3952: -- OPM 1857167 end
3953:
3954:
3955:
3956: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
3957: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
3958:
3959: l_result := ORDER_QUANTITY_UOM
3960: (p_operation => l_operation
3968: END IF;
3969:
3970: END IF;
3971:
3972: IF p_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3973: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_reason_code,p_old_line_rec.over_ship_reason_code) THEN
3974:
3975: l_result := OVER_SHIP_REASON
3976: (p_operation => l_operation
3984: END IF;
3985:
3986: END IF;
3987:
3988: IF p_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN NULL;
3989: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_resolved_flag,p_old_line_rec.over_ship_resolved_flag) THEN
3990:
3991: l_result := OVER_SHIP_RESOLVED
3992: (p_operation => l_operation
4000: END IF;
4001:
4002: END IF;
4003:
4004: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
4005: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
4006:
4007: l_result := PACKING_INSTRUCTIONS
4008: (p_operation => l_operation
4016: END IF;
4017:
4018: END IF;
4019:
4020: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
4021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
4022:
4023: l_result := PAYMENT_TERM
4024: (p_operation => l_operation
4032: END IF;
4033:
4034: END IF;
4035:
4036: IF p_line_rec.planning_priority = FND_API.G_MISS_NUM THEN NULL;
4037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.planning_priority,p_old_line_rec.planning_priority) THEN
4038:
4039: l_result := PLANNING_PRIORITY
4040: (p_operation => l_operation
4048: END IF;
4049:
4050: END IF;
4051:
4052: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
4053: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
4054:
4055: l_result := PRICE_LIST
4056: (p_operation => l_operation
4064: END IF;
4065:
4066: END IF;
4067:
4068: IF p_line_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
4069: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_date,p_old_line_rec.pricing_date) THEN
4070:
4071: l_result := PRICING_DATE
4072: (p_operation => l_operation
4080: END IF;
4081:
4082: END IF;
4083:
4084: IF p_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN NULL;
4085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity) THEN
4086:
4087: l_result := PRICING_QUANTITY
4088: (p_operation => l_operation
4096: END IF;
4097:
4098: END IF;
4099:
4100: IF p_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom) THEN
4102:
4103: l_result := PRICING_QUANTITY_UOM
4104: (p_operation => l_operation
4112: END IF;
4113:
4114: END IF;
4115:
4116: IF p_line_rec.project_id = FND_API.G_MISS_NUM THEN NULL;
4117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,p_old_line_rec.project_id) THEN
4118:
4119: l_result := PROJECT
4120: (p_operation => l_operation
4128: END IF;
4129:
4130: END IF;
4131:
4132: IF p_line_rec.promise_date = FND_API.G_MISS_DATE THEN NULL;
4133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.promise_date,p_old_line_rec.promise_date) THEN
4134:
4135: l_result := PROMISE_DATE
4136: (p_operation => l_operation
4144: END IF;
4145:
4146: END IF;
4147:
4148: IF p_line_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
4149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.request_date,p_old_line_rec.request_date) THEN
4150:
4151: l_result := REQUEST_DATE
4152: (p_operation => l_operation
4160: END IF;
4161:
4162: END IF;
4163:
4164: IF p_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4165: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_reason_code,p_old_line_rec.return_reason_code) THEN
4166:
4167: l_result := RETURN_REASON
4168: (p_operation => l_operation
4176: END IF;
4177:
4178: END IF;
4179:
4180: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
4181: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN
4182:
4183: l_result := SALESREP
4184: (p_operation => l_operation
4192: END IF;
4193:
4194: END IF;
4195:
4196: IF p_line_rec.schedule_arrival_date = FND_API.G_MISS_DATE THEN NULL;
4197: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_arrival_date),trunc(p_old_line_rec.schedule_arrival_date)) THEN
4198:
4199: l_result := SCHEDULE_ARRIVAL_DATE
4200: (p_operation => l_operation
4208: END IF;
4209:
4210: END IF;
4211:
4212: IF p_line_rec.schedule_ship_date = FND_API.G_MISS_DATE THEN NULL;
4213: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_ship_date),trunc(p_old_line_rec.schedule_ship_date)) THEN
4214:
4215: l_result := SCHEDULE_SHIP_DATE
4216: (p_operation => l_operation
4224: END IF;
4225:
4226: END IF;
4227:
4228: IF p_line_rec.service_reference_line_id = FND_API.G_MISS_NUM THEN NULL;
4229: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_line_id,p_old_line_rec.service_reference_line_id) THEN
4230:
4231: l_result := SERVICE_REFERENCE_LINE
4232: (p_operation => l_operation
4240: END IF;
4241:
4242: END IF;
4243:
4244: IF p_line_rec.service_reference_system_id = FND_API.G_MISS_NUM THEN NULL;
4245: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_system_id,p_old_line_rec.service_reference_system_id) THEN
4246:
4247: l_result := SERVICE_REFERENCE_SYSTEM
4248: (p_operation => l_operation
4256: END IF;
4257:
4258: END IF;
4259:
4260: IF p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR THEN NULL;
4261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_type_code,p_old_line_rec.service_reference_type_code) THEN
4262:
4263: l_result := SERVICE_REFERENCE_TYPE
4264: (p_operation => l_operation
4275:
4276: /* Fix to bug 2205900: Added constraints functions for
4277: some missing SERVICE fields */
4278:
4279: IF p_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN NULL;
4280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_coterminate_flag,p_old_line_rec.service_coterminate_flag) THEN
4281:
4282: l_result := SERVICE_COTERMINATE
4283: (p_operation => l_operation
4291: END IF;
4292:
4293: END IF;
4294:
4295: IF p_line_rec.service_duration = FND_API.G_MISS_NUM THEN NULL;
4296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_duration,p_old_line_rec.service_duration) THEN
4297:
4298: l_result := SERVICE_DURATION
4299: (p_operation => l_operation
4307: END IF;
4308:
4309: END IF;
4310:
4311: IF p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN NULL;
4312: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_end_date,p_old_line_rec.service_end_date) THEN
4313:
4314: l_result := SERVICE_END_DATE
4315: (p_operation => l_operation
4323: END IF;
4324:
4325: END IF;
4326:
4327: IF p_line_rec.service_period = FND_API.G_MISS_CHAR THEN NULL;
4328: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_period,p_old_line_rec.service_period) THEN
4329:
4330: l_result := SERVICE_PERIOD
4331: (p_operation => l_operation
4339: END IF;
4340:
4341: END IF;
4342:
4343: IF p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN NULL;
4344: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_start_date,p_old_line_rec.service_start_date) THEN
4345:
4346: l_result := SERVICE_START_DATE
4347: (p_operation => l_operation
4355: END IF;
4356:
4357: END IF;
4358:
4359: IF p_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN NULL;
4360: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_comments,p_old_line_rec.service_txn_comments) THEN
4361:
4362: l_result := SERVICE_TXN_COMMENTS
4363: (p_operation => l_operation
4371: END IF;
4372:
4373: END IF;
4374:
4375: IF p_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4376: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_reason_code,p_old_line_rec.service_txn_reason_code) THEN
4377:
4378: l_result := SERVICE_TXN_REASON
4379: (p_operation => l_operation
4387: END IF;
4388:
4389: END IF;
4390:
4391: IF p_line_rec.shipment_number = FND_API.G_MISS_NUM THEN NULL;
4392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_number,p_old_line_rec.shipment_number) THEN
4393:
4394: l_result := SHIPMENT_NUMBER
4395: (p_operation => l_operation
4403: END IF;
4404:
4405: END IF;
4406:
4407: IF p_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
4408: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_priority_code,p_old_line_rec.shipment_priority_code) THEN
4409:
4410: l_result := SHIPMENT_PRIORITY
4411: (p_operation => l_operation
4419: END IF;
4420:
4421: END IF;
4422:
4423: IF p_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN NULL;
4424: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity,p_old_line_rec.shipped_quantity) THEN
4425:
4426: l_result := SHIPPED_QUANTITY
4427: (p_operation => l_operation
4436:
4437: END IF;
4438:
4439: -- INVCONV
4440: IF p_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4441: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity2,p_old_line_rec.shipped_quantity2) THEN
4442:
4443: l_result := SHIPPED_QUANTITY2
4444: (p_operation => l_operation
4453:
4454: END IF;
4455:
4456:
4457: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
4458: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
4459:
4460: l_result := SHIPPING_INSTRUCTIONS
4461: (p_operation => l_operation
4469: END IF;
4470:
4471: END IF;
4472:
4473: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
4474: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
4475:
4476: l_result := SHIPPING_METHOD
4477: (p_operation => l_operation
4485: END IF;
4486:
4487: END IF;
4488:
4489: IF p_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN NULL;
4490: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity,p_old_line_rec.shipping_quantity) THEN
4491:
4492: l_result := SHIPPING_QUANTITY
4493: (p_operation => l_operation
4502:
4503: END IF;
4504:
4505: -- INVCONV
4506: IF p_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity2,p_old_line_rec.shipping_quantity2) THEN
4508:
4509: l_result := SHIPPING_QUANTITY2
4510: (p_operation => l_operation
4520: END IF;
4521:
4522:
4523:
4524: IF p_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4525: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom,p_old_line_rec.shipping_quantity_uom) THEN
4526:
4527: l_result := SHIPPING_QUANTITY_UOM
4528: (p_operation => l_operation
4537:
4538: END IF;
4539:
4540: -- INVCONV
4541: IF p_line_rec.shipping_quantity_uom2 = FND_API.G_MISS_CHAR THEN NULL;
4542: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom2,p_old_line_rec.shipping_quantity_uom2) THEN
4543:
4544: l_result := SHIPPING_QUANTITY_UOM2
4545: (p_operation => l_operation
4554:
4555: END IF;
4556:
4557:
4558: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
4559: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
4560:
4561: l_result := SHIP_FROM_ORG
4562: (p_operation => l_operation
4570: END IF;
4571:
4572: END IF;
4573:
4574: IF p_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN NULL;
4575: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_model_complete_flag,p_old_line_rec.ship_model_complete_flag) THEN
4576:
4577: l_result := SHIP_MODEL_COMPLETE
4578: (p_operation => l_operation
4586: END IF;
4587:
4588: END IF;
4589:
4590: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4591: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4592: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4593:
4594: l_result := SHIP_SET
4603: END IF;
4604:
4605: END IF;
4606:
4607: IF p_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
4608: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_above,p_old_line_rec.ship_tolerance_above) THEN
4609:
4610: l_result := SHIP_TOLERANCE_ABOVE
4611: (p_operation => l_operation
4619: END IF;
4620:
4621: END IF;
4622:
4623: IF p_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
4624: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_below,p_old_line_rec.ship_tolerance_below) THEN
4625:
4626: l_result := SHIP_TOLERANCE_BELOW
4627: (p_operation => l_operation
4635: END IF;
4636:
4637: END IF;
4638:
4639: IF p_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
4640: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id) THEN
4641:
4642: l_result := SHIP_TO_CONTACT
4643: (p_operation => l_operation
4651: END IF;
4652:
4653: END IF;
4654:
4655: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4656: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
4657:
4658: l_result := SHIP_TO_ORG
4659: (p_operation => l_operation
4667: END IF;
4668:
4669: END IF;
4670:
4671: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4672: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
4673:
4674: l_result := SOLD_TO_ORG
4675: (p_operation => l_operation
4683: END IF;
4684:
4685: END IF;
4686:
4687: IF p_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN NULL;
4688: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.source_type_code,p_old_line_rec.source_type_code) THEN
4689:
4690: l_result := SOURCE_TYPE
4691: (p_operation => l_operation
4699: END IF;
4700:
4701: END IF;
4702:
4703: IF p_line_rec.subinventory = FND_API.G_MISS_CHAR THEN NULL;
4704: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.subinventory,p_old_line_rec.subinventory) THEN
4705:
4706: l_result := SUBINVENTORY
4707: (p_operation => l_operation
4715: END IF;
4716:
4717: END IF;
4718:
4719: IF p_line_rec.task_id = FND_API.G_MISS_NUM THEN NULL;
4720: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,p_old_line_rec.task_id) THEN
4721:
4722: l_result := TASK
4723: (p_operation => l_operation
4731: END IF;
4732:
4733: END IF;
4734:
4735: IF p_line_rec.tax_code = FND_API.G_MISS_CHAR THEN NULL;
4736: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_code,p_old_line_rec.tax_code) THEN
4737:
4738: l_result := TAX
4739: (p_operation => l_operation
4747: END IF;
4748:
4749: END IF;
4750:
4751: IF p_line_rec.tax_date = FND_API.G_MISS_DATE THEN NULL;
4752: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_date,p_old_line_rec.tax_date) THEN
4753:
4754: l_result := TAX_DATE
4755: (p_operation => l_operation
4763: END IF;
4764:
4765: END IF;
4766:
4767: IF p_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
4768: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_flag,p_old_line_rec.tax_exempt_flag) THEN
4769:
4770: l_result := TAX_EXEMPT
4771: (p_operation => l_operation
4779: END IF;
4780:
4781: END IF;
4782:
4783: IF p_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
4784: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number,p_old_line_rec.tax_exempt_number) THEN
4785:
4786: l_result := TAX_EXEMPT_NUMBER
4787: (p_operation => l_operation
4795: END IF;
4796:
4797: END IF;
4798:
4799: IF p_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4800: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_reason_code,p_old_line_rec.tax_exempt_reason_code) THEN
4801:
4802: l_result := TAX_EXEMPT_REASON
4803: (p_operation => l_operation
4811: END IF;
4812:
4813: END IF;
4814:
4815: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
4816: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
4817:
4818: l_result := UNIT_LIST_PRICE
4819: (p_operation => l_operation
4827: END IF;
4828:
4829: END IF;
4830:
4831: IF p_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN NULL;
4832: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price) THEN
4833:
4834: l_result := UNIT_SELLING_PRICE
4835: (p_operation => l_operation
4844:
4845: END IF;
4846:
4847: -- BEGIN: Blankets Code Merge
4848: IF p_line_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
4849: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_number,p_old_line_rec.blanket_number) THEN
4850:
4851: l_result := BLANKET_NUMBER
4852: (p_operation => l_operation
4860: END IF;
4861:
4862: END IF;
4863:
4864: IF p_line_rec.blanket_line_number = FND_API.G_MISS_NUM THEN NULL;
4865: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number) THEN
4866:
4867: l_result := BLANKET_LINE_NUMBER
4868: (p_operation => l_operation
4890:
4891: IF NVL(l_active_flag,'N')='N' THEN
4892: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
4893: OE_MSG_PUB.ADD;
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896: EXCEPTION
4897: WHEN OTHERS THEN
4898: IF l_debug_level > 0 THEN
4900: END IF;
4901: END;
4902: END IF;
4903:
4904: IF p_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
4905: NULL;
4906: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.calculate_price_flag
4907: ,p_old_line_rec.calculate_price_flag) THEN
4908:
4915: x_result := OE_PC_GLOBALS.YES;
4916: END IF;
4917: END IF;
4918:
4919: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN
4920: NULL;
4921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_shipment_number,p_old_line_rec.customer_shipment_number) THEN
4922:
4923: l_result := CUSTOMER_SHIPMENT_NUMBER
4950: l_check_all_cols_constraint := g_check_all_cols_constraint;
4951: g_check_all_cols_constraint := 'N';
4952: END IF;
4953:
4954: IF p_line_rec.context = FND_API.G_MISS_CHAR THEN NULL;
4955: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.context,p_old_line_rec.context) THEN
4956:
4957: l_result := CONTEXT
4958: (p_operation => l_operation
4966: END IF;
4967:
4968: END IF;
4969:
4970: IF p_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
4971: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute1,p_old_line_rec.attribute1) THEN
4972:
4973: l_result := ATTRIBUTE1
4974: (p_operation => l_operation
4982: END IF;
4983:
4984: END IF;
4985:
4986: IF p_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
4987: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute10,p_old_line_rec.attribute10) THEN
4988:
4989: l_result := ATTRIBUTE10
4990: (p_operation => l_operation
4998: END IF;
4999:
5000: END IF;
5001:
5002: IF p_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
5003: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute11,p_old_line_rec.attribute11) THEN
5004:
5005: l_result := ATTRIBUTE11
5006: (p_operation => l_operation
5014: END IF;
5015:
5016: END IF;
5017:
5018: IF p_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
5019: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute12,p_old_line_rec.attribute12) THEN
5020:
5021: l_result := ATTRIBUTE12
5022: (p_operation => l_operation
5030: END IF;
5031:
5032: END IF;
5033:
5034: IF p_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
5035: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute13,p_old_line_rec.attribute13) THEN
5036:
5037: l_result := ATTRIBUTE13
5038: (p_operation => l_operation
5046: END IF;
5047:
5048: END IF;
5049:
5050: IF p_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
5051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute14,p_old_line_rec.attribute14) THEN
5052:
5053: l_result := ATTRIBUTE14
5054: (p_operation => l_operation
5062: END IF;
5063:
5064: END IF;
5065:
5066: IF p_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
5067: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute15,p_old_line_rec.attribute15) THEN
5068:
5069: l_result := ATTRIBUTE15
5070: (p_operation => l_operation
5080: END IF;
5081:
5082: -- For bug 2184255
5083:
5084: IF p_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
5085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute16,p_old_line_rec.attribute16) THEN
5086:
5087: l_result := ATTRIBUTE16
5088: (p_operation => l_operation
5096: END IF;
5097:
5098: END IF;
5099:
5100: IF p_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
5101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute17,p_old_line_rec.attribute17) THEN
5102:
5103: l_result := ATTRIBUTE17
5104: (p_operation => l_operation
5112: END IF;
5113:
5114: END IF;
5115:
5116: IF p_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
5117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute18,p_old_line_rec.attribute18) THEN
5118:
5119: l_result := ATTRIBUTE18
5120: (p_operation => l_operation
5128: END IF;
5129:
5130: END IF;
5131:
5132: IF p_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
5133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute19,p_old_line_rec.attribute19) THEN
5134:
5135: l_result := ATTRIBUTE19
5136: (p_operation => l_operation
5144: END IF;
5145:
5146: END IF;
5147:
5148: IF p_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute2,p_old_line_rec.attribute2) THEN
5150:
5151: l_result := ATTRIBUTE2
5152: (p_operation => l_operation
5161:
5162: END IF;
5163:
5164:
5165: IF p_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
5166: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute20,p_old_line_rec.attribute20) THEN
5167:
5168: l_result := ATTRIBUTE20
5169: (p_operation => l_operation
5179: END IF;
5180:
5181: -- End bug 2184255
5182:
5183: IF p_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
5184: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute3,p_old_line_rec.attribute3) THEN
5185:
5186: l_result := ATTRIBUTE3
5187: (p_operation => l_operation
5195: END IF;
5196:
5197: END IF;
5198:
5199: IF p_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
5200: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute4,p_old_line_rec.attribute4) THEN
5201:
5202: l_result := ATTRIBUTE4
5203: (p_operation => l_operation
5211: END IF;
5212:
5213: END IF;
5214:
5215: IF p_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
5216: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute5,p_old_line_rec.attribute5) THEN
5217:
5218: l_result := ATTRIBUTE5
5219: (p_operation => l_operation
5227: END IF;
5228:
5229: END IF;
5230:
5231: IF p_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
5232: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute6,p_old_line_rec.attribute6) THEN
5233:
5234: l_result := ATTRIBUTE6
5235: (p_operation => l_operation
5243: END IF;
5244:
5245: END IF;
5246:
5247: IF p_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
5248: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute7,p_old_line_rec.attribute7) THEN
5249:
5250: l_result := ATTRIBUTE7
5251: (p_operation => l_operation
5259: END IF;
5260:
5261: END IF;
5262:
5263: IF p_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
5264: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute8,p_old_line_rec.attribute8) THEN
5265:
5266: l_result := ATTRIBUTE8
5267: (p_operation => l_operation
5275: END IF;
5276:
5277: END IF;
5278:
5279: IF p_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
5280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute9,p_old_line_rec.attribute9) THEN
5281:
5282: l_result := ATTRIBUTE9
5283: (p_operation => l_operation
5291: END IF;
5292:
5293: END IF;
5294:
5295: IF p_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN NULL;
5296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.user_item_description, p_old_line_rec.user_item_description) THEN
5297:
5298: l_result := USER_ITEM_DESCRIPTION
5299: (p_operation => l_operation
5308:
5309: END IF;
5310:
5311: /* Customer Acceptance - Start */
5312: IF p_line_rec.contingency_id = FND_API.G_MISS_NUM THEN NULL;
5313: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.contingency_id,p_old_line_rec.contingency_id) THEN
5314:
5315: l_result := CONTINGENCY
5316: (p_operation => l_operation
5324: END IF;
5325:
5326: END IF;
5327:
5328: IF p_line_rec.revrec_expiration_days = FND_API.G_MISS_NUM THEN NULL;
5329: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.revrec_expiration_days,p_old_line_rec.revrec_expiration_days) THEN
5330:
5331: l_result := REVREC_EXPIRATION_DAYS
5332: (p_operation => l_operation
5357: oe_debug_pub.add('Exit OE_LINE_Security.Attributes',1);
5358: END IF;
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: x_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5365: WHEN OTHERS THEN
5358: END IF;
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: x_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5365: WHEN OTHERS THEN
5366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: x_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5365: WHEN OTHERS THEN
5366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: x_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5365: WHEN OTHERS THEN
5366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5368: OE_MSG_PUB.Add_Exc_Msg
5362: x_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5365: WHEN OTHERS THEN
5366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5368: OE_MSG_PUB.Add_Exc_Msg
5369: ( G_PKG_NAME
5370: , 'Attributes'