eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_SECURITY dependencies on FND_API

Line 8: g_header_id NUMBER := FND_API.G_MISS_NUM;

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

Line 80: RAISE FND_API.G_EXC_ERROR;

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

Line 86: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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';

Line 142: If l_return_status = FND_API.G_RET_STS_SUCCESS And

138: x_is_delivery_required => l_is_delivery_reqd,
139: x_return_status => l_return_status
140: );
141:
142: If l_return_status = FND_API.G_RET_STS_SUCCESS And
143: l_is_delivery_reqd = 'Y'
144: Then
145: l_gen_xml := 'B';
146: End If;

Line 212: If l_return_status = FND_API.G_RET_STS_SUCCESS And

208: x_is_delivery_required => l_is_delivery_reqd,
209: x_return_status => l_return_status
210: );
211:
212: If l_return_status = FND_API.G_RET_STS_SUCCESS And
213: l_is_delivery_reqd = 'Y'
214: Then
215: l_gen_xml := 'B';
216: End IF;

Line 321: If l_return_status = FND_API.G_RET_STS_SUCCESS And

317: x_is_delivery_required => l_is_delivery_reqd,
318: x_return_status => l_return_status
319: );
320:
321: If l_return_status = FND_API.G_RET_STS_SUCCESS And
322: l_is_delivery_reqd = 'Y'
323: Then
324: l_gen_xml := 'B';
325: End If;

Line 1743: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN

1739: IF NVL(p_record.transaction_phase_code,'F') = 'F'
1740: AND p_operation = OE_PC_GLOBALS.UPDATE_OP
1741: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1742: AND NOT(p_record.split_action_code IS NOT NULL AND
1743: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1744: l_result := ORDERED_QUANTITY
1745: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1746: ,p_record => p_record
1747: ,x_on_operation_action => x_on_operation_action

Line 1751: p_record.split_action_code <> FND_API.G_MISS_CHAR AND

1747: ,x_on_operation_action => x_on_operation_action
1748: );
1749: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1750: AND (p_record.split_action_code IS NOT NULL AND
1751: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1752: p_record.split_action_code = 'SPLIT') THEN
1753: l_result := ORDERED_QUANTITY
1754: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1755: ,p_record => p_record

Line 1794: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN

1790: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED
1791: IF p_operation = OE_PC_GLOBALS.UPDATE_OP
1792: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1793: AND NOT(p_record.split_action_code IS NOT NULL AND
1794: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1795: l_result := ORDERED_QUANTITY2
1796: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1797: ,p_record => p_record
1798: ,x_on_operation_action => x_on_operation_action

Line 1802: p_record.split_action_code <> FND_API.G_MISS_CHAR AND

1798: ,x_on_operation_action => x_on_operation_action
1799: );
1800: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1801: AND (p_record.split_action_code IS NOT NULL AND
1802: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1803: p_record.split_action_code = 'SPLIT') THEN
1804: l_result := ORDERED_QUANTITY2
1805: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1806: ,p_record => p_record

Line 3306: x_return_status := FND_API.G_RET_STS_SUCCESS;

3302: oe_debug_pub.add('Enter OE_LINE_Security.Entity',1);
3303: END IF;
3304:
3305: -- Initializing return status to SUCCESS
3306: x_return_status := FND_API.G_RET_STS_SUCCESS;
3307:
3308: /* start of bug 2922204 */
3309:
3310: IF l_debug_level > 0 THEN

Line 3369: RAISE FND_API.G_EXC_ERROR;

3365: ELSE
3366: IF l_debug_level > 0 THEN
3367: oe_debug_pub.add('Invalid operation',1);
3368: END IF;
3369: RAISE FND_API.G_EXC_ERROR;
3370: END IF;
3371:
3372: OE_LINE_Util_Ext.API_Rec_To_Rowtype_Rec
3373: (p_LINE_rec => p_line_rec

Line 3403: WHEN FND_API.G_EXC_ERROR THEN

3399: IF l_debug_level > 0 THEN
3400: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3401: END IF;
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3407: WHEN OTHERS THEN

Line 3404: x_return_status := FND_API.G_RET_STS_ERROR;

3400: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3401: END IF;
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3407: WHEN OTHERS THEN
3408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3401: END IF;
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3407: WHEN OTHERS THEN
3408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3407: WHEN OTHERS THEN
3408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3410: OE_MSG_PUB.Add_Exc_Msg

Line 3408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3407: WHEN OTHERS THEN
3408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3410: OE_MSG_PUB.Add_Exc_Msg
3411: ( G_PKG_NAME
3412: , 'Entity'

Line 3440: x_return_status := FND_API.G_RET_STS_SUCCESS;

3436: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);
3437: END IF;
3438:
3439: -- Initializing return status to SUCCESS
3440: x_return_status := FND_API.G_RET_STS_SUCCESS;
3441: -- Initialize g_operation_action to null
3442: g_operation_action := null;
3443:
3444: -- Initializing out result to NOT CONSTRAINED

Line 3454: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM

3450: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3451: -- level check
3452: -- Bug 3859436 : if the line is being split, skip attribute check.
3453: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
3454: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3455: THEN
3456: RETURN;
3457: ELSE
3458: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: ELSE
3477: IF l_debug_level > 0 THEN
3478: oe_debug_pub.add('Invalid operation',1);
3479: END IF;
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:
3483: OE_LINE_Util_Ext.API_Rec_To_Rowtype_Rec
3484: (p_LINE_rec => p_line_rec

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

3489:
3490: -- Compare the new and old entity records and
3491: -- check constraints for all the changed attributes.
3492:
3493: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
3494: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
3495:
3496: l_result := ACCOUNTING_RULE
3497: (p_operation => l_operation

Line 3509: IF p_line_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;

3505: END IF;
3506:
3507: END IF;
3508:
3509: IF p_line_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
3510: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_OWNER,p_old_line_rec.IB_OWNER) THEN
3511:
3512: l_result := IB_OWNER
3513: (p_operation => l_operation

Line 3524: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

3520: x_result := OE_PC_GLOBALS.YES;
3521: END IF;
3522:
3523: END IF;
3524: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3525: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_CURRENT_LOCATION,p_old_line_rec.IB_CURRENT_LOCATION) THEN
3526:
3527: l_result := IB_CURRENT_LOCATION
3528: (p_operation => l_operation

Line 3539: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

3535: x_result := OE_PC_GLOBALS.YES;
3536: END IF;
3537:
3538: END IF;
3539: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3540: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_INSTALLED_AT_LOCATION,p_old_line_rec.IB_INSTALLED_AT_LOCATION) THEN
3541:
3542: l_result := IB_INSTALLED_AT_LOCATION
3543: (p_operation => l_operation

Line 3554: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;

3550: x_result := OE_PC_GLOBALS.YES;
3551: END IF;
3552:
3553: END IF;
3554: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
3555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_ID,p_old_line_rec.END_CUSTOMER_ID) THEN
3556:
3557: l_result := END_CUSTOMER
3558: (p_operation => l_operation

Line 3569: IF p_line_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;

3565: x_result := OE_PC_GLOBALS.YES;
3566: END IF;
3567:
3568: END IF;
3569: IF p_line_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
3570: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_CONTACT_ID,p_old_line_rec.END_CUSTOMER_CONTACT_ID) THEN
3571:
3572: l_result := END_CUSTOMER_CONTACT
3573: (p_operation => l_operation

Line 3584: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;

3580: x_result := OE_PC_GLOBALS.YES;
3581: END IF;
3582:
3583: END IF;
3584: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
3585: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_SITE_USE_ID,p_old_line_rec.END_CUSTOMER_SITE_USE_ID) THEN
3586:
3587: l_result := END_CUSTOMER_SITE_USE
3588: (p_operation => l_operation

Line 3600: IF p_line_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;

3596: END IF;
3597:
3598: END IF;
3599:
3600: IF p_line_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
3601: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_duration,p_old_line_rec.accounting_rule_duration) THEN
3602:
3603: l_result := ACCOUNTING_RULE_DURATION
3604: (p_operation => l_operation

Line 3616: IF p_line_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;

3612: END IF;
3613:
3614: END IF;
3615:
3616: IF p_line_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
3617: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id,p_old_line_rec.agreement_id) THEN
3618:
3619: l_result := AGREEMENT
3620: (p_operation => l_operation

Line 3632: IF p_line_rec.commitment_id = FND_API.G_MISS_NUM THEN NULL;

3628: END IF;
3629:
3630: END IF;
3631:
3632: IF p_line_rec.commitment_id = FND_API.G_MISS_NUM THEN NULL;
3633: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.commitment_id,p_old_line_rec.commitment_id) THEN
3634:
3635: l_result := COMMITMENT_ID
3636: (p_operation => l_operation

Line 3648: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;

3644: END IF;
3645:
3646: END IF;
3647:
3648: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3649: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3650: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3651:
3652: l_result := ARRIVAL_SET

Line 3665: IF p_line_rec.authorized_to_ship_flag = FND_API.G_MISS_CHAR THEN NULL;

3661: END IF;
3662:
3663: END IF;
3664:
3665: IF p_line_rec.authorized_to_ship_flag = FND_API.G_MISS_CHAR THEN NULL;
3666: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.authorized_to_ship_flag,p_old_line_rec.authorized_to_ship_flag) THEN
3667:
3668: l_result := AUTHORIZED_TO_SHIP
3669: (p_operation => l_operation

Line 3681: IF p_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN NULL;

3677: END IF;
3678:
3679: END IF;
3680:
3681: IF p_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN NULL;
3682: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.credit_invoice_line_id,p_old_line_rec.credit_invoice_line_id) THEN
3683:
3684: l_result := CREDIT_INVOICE_LINE
3685: (p_operation => l_operation

Line 3697: IF p_line_rec.customer_line_number = FND_API.G_MISS_CHAR THEN NULL;

3693: END IF;
3694:
3695: END IF;
3696:
3697: IF p_line_rec.customer_line_number = FND_API.G_MISS_CHAR THEN NULL;
3698: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_line_number,p_old_line_rec.customer_line_number) THEN
3699:
3700: l_result := CUSTOMER_LINE_NUMBER
3701: (p_operation => l_operation

Line 3713: IF p_line_rec.customer_trx_line_id = FND_API.G_MISS_NUM THEN NULL;

3709: END IF;
3710:
3711: END IF;
3712:
3713: IF p_line_rec.customer_trx_line_id = FND_API.G_MISS_NUM THEN NULL;
3714: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_trx_line_id,p_old_line_rec.customer_trx_line_id) THEN
3715:
3716: l_result := CUSTOMER_TRX_LINE
3717: (p_operation => l_operation

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

3725: END IF;
3726:
3727: END IF;
3728:
3729: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
3730: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
3731:
3732: l_result := CUST_PO_NUMBER
3733: (p_operation => l_operation

Line 3746: IF p_line_rec.customer_job = FND_API.G_MISS_CHAR THEN NULL;

3742:
3743: END IF;
3744:
3745: -- Added for bug #7608170
3746: IF p_line_rec.customer_job = FND_API.G_MISS_CHAR THEN NULL;
3747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_job,p_old_line_rec.customer_job) THEN
3748:
3749: l_result := CUSTOMER_JOB
3750: (p_operation => l_operation

Line 3762: IF p_line_rec.delivery_lead_time = FND_API.G_MISS_NUM THEN NULL;

3758: END IF;
3759:
3760: END IF;
3761:
3762: IF p_line_rec.delivery_lead_time = FND_API.G_MISS_NUM THEN NULL;
3763: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.delivery_lead_time,p_old_line_rec.delivery_lead_time) THEN
3764:
3765: l_result := DELIVERY_LEAD_TIME
3766: (p_operation => l_operation

Line 3778: IF p_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;

3774: END IF;
3775:
3776: END IF;
3777:
3778: IF p_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3779: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id,p_old_line_rec.deliver_to_contact_id) THEN
3780:
3781: l_result := DELIVER_TO_CONTACT
3782: (p_operation => l_operation

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

3790: END IF;
3791:
3792: END IF;
3793:
3794: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3795: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN
3796:
3797: l_result := DELIVER_TO_ORG
3798: (p_operation => l_operation

Line 3810: IF p_line_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;

3806: END IF;
3807:
3808: END IF;
3809:
3810: IF p_line_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
3811: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.demand_class_code,p_old_line_rec.demand_class_code) THEN
3812:
3813: l_result := DEMAND_CLASS
3814: (p_operation => l_operation

Line 3826: IF p_line_rec.dep_plan_required_flag = FND_API.G_MISS_CHAR THEN NULL;

3822: END IF;
3823:
3824: END IF;
3825:
3826: IF p_line_rec.dep_plan_required_flag = FND_API.G_MISS_CHAR THEN NULL;
3827: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.dep_plan_required_flag,p_old_line_rec.dep_plan_required_flag) THEN
3828:
3829: l_result := DEP_PLAN_REQUIRED
3830: (p_operation => l_operation

Line 3842: IF p_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;

3838: END IF;
3839:
3840: END IF;
3841:
3842: IF p_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3843: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.earliest_acceptable_date,p_old_line_rec.earliest_acceptable_date) THEN
3844:
3845: l_result := EARLIEST_ACCEPTABLE_DATE
3846: (p_operation => l_operation

Line 3858: IF p_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN NULL;

3854: END IF;
3855:
3856: END IF;
3857:
3858: IF p_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN NULL;
3859: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_item_unit_number,p_old_line_rec.end_item_unit_number) THEN
3860:
3861: l_result := END_ITEM_UNIT_NUMBER
3862: (p_operation => l_operation

Line 3874: IF p_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;

3870: END IF;
3871:
3872: END IF;
3873:
3874: IF p_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
3875: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fob_point_code,p_old_line_rec.fob_point_code) THEN
3876:
3877: l_result := FOB_POINT
3878: (p_operation => l_operation

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

3886: END IF;
3887:
3888: END IF;
3889:
3890: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
3891: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
3892:
3893: l_result := FREIGHT_TERMS
3894: (p_operation => l_operation

Line 3906: IF p_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN NULL;

3902: END IF;
3903:
3904: END IF;
3905:
3906: IF p_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN NULL;
3907: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,p_old_line_rec.fulfilled_quantity) THEN
3908:
3909: l_result := FULFILLED_QUANTITY
3910: (p_operation => l_operation

Line 3923: IF p_line_rec.fulfilled_quantity2 = FND_API.G_MISS_NUM THEN NULL;

3919:
3920: END IF;
3921:
3922: -- INVCONV
3923: IF p_line_rec.fulfilled_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3924: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity2,p_old_line_rec.fulfilled_quantity2) THEN
3925:
3926: l_result := FULFILLED_QUANTITY2
3927: (p_operation => l_operation

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

3935: END IF;
3936:
3937: END IF;
3938:
3939: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
3940: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
3941:
3942: l_result := INVENTORY_ITEM
3943: (p_operation => l_operation

Line 3955: IF p_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;

3951: END IF;
3952:
3953: END IF;
3954:
3955: IF p_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3956: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id,p_old_line_rec.invoice_to_contact_id) THEN
3957:
3958: l_result := INVOICE_TO_CONTACT
3959: (p_operation => l_operation

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

3967: END IF;
3968:
3969: END IF;
3970:
3971: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3972: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN
3973:
3974: l_result := INVOICE_TO_ORG
3975: (p_operation => l_operation

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

3983: END IF;
3984:
3985: END IF;
3986:
3987: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
3988: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN
3989:
3990: l_result := INVOICING_RULE
3991: (p_operation => l_operation

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

3999: END IF;
4000:
4001: END IF;
4002:
4003: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;
4004: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN
4005:
4006: l_result := ITEM_IDENTIFIER_TYPE
4007: (p_operation => l_operation

Line 4019: IF p_line_rec.item_revision = FND_API.G_MISS_CHAR THEN NULL;

4015: END IF;
4016:
4017: END IF;
4018:
4019: IF p_line_rec.item_revision = FND_API.G_MISS_CHAR THEN NULL;
4020: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_revision,p_old_line_rec.item_revision) THEN
4021:
4022: l_result := ITEM_REVISION
4023: (p_operation => l_operation

Line 4035: IF p_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN NULL;

4031: END IF;
4032:
4033: END IF;
4034:
4035: IF p_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN NULL;
4036: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_type_code,p_old_line_rec.item_type_code) THEN
4037:
4038: l_result := ITEM_TYPE
4039: (p_operation => l_operation

Line 4051: IF p_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;

4047: END IF;
4048:
4049: END IF;
4050:
4051: IF p_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
4052: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.latest_acceptable_date,p_old_line_rec.latest_acceptable_date) THEN
4053:
4054: l_result := LATEST_ACCEPTABLE_DATE
4055: (p_operation => l_operation

Line 4067: IF p_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN NULL;

4063: END IF;
4064:
4065: END IF;
4066:
4067: IF p_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN NULL;
4068: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code) THEN
4069:
4070: l_result := LINE_CATEGORY
4071: (p_operation => l_operation

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

4079: END IF;
4080:
4081: END IF;
4082:
4083: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;
4084: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN
4085:
4086: l_result := LINE_NUMBER
4087: (p_operation => l_operation

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

4095: END IF;
4096:
4097: END IF;
4098:
4099: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;
4100: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN
4101:
4102: l_result := LINE_TYPE
4103: (p_operation => l_operation

Line 4115: IF p_line_rec.ordered_quantity = FND_API.G_MISS_NUM THEN NULL;

4111: END IF;
4112:
4113: END IF;
4114:
4115: IF p_line_rec.ordered_quantity = FND_API.G_MISS_NUM THEN NULL;
4116: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
4117:
4118: l_result := ORDERED_QUANTITY
4119: (p_operation => l_operation

Line 4132: IF p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN NULL;

4128:
4129: END IF;
4130:
4131: -- OPM 1857167 start
4132: IF p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
4134:
4135: l_result := ORDERED_QUANTITY2
4136: (p_operation => l_operation

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

4147: -- OPM 1857167 end
4148:
4149:
4150:
4151: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4152: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
4153:
4154: l_result := ORDER_QUANTITY_UOM
4155: (p_operation => l_operation

Line 4167: IF p_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN NULL;

4163: END IF;
4164:
4165: END IF;
4166:
4167: IF p_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4168: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_reason_code,p_old_line_rec.over_ship_reason_code) THEN
4169:
4170: l_result := OVER_SHIP_REASON
4171: (p_operation => l_operation

Line 4183: IF p_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN NULL;

4179: END IF;
4180:
4181: END IF;
4182:
4183: IF p_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN NULL;
4184: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_resolved_flag,p_old_line_rec.over_ship_resolved_flag) THEN
4185:
4186: l_result := OVER_SHIP_RESOLVED
4187: (p_operation => l_operation

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

4195: END IF;
4196:
4197: END IF;
4198:
4199: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
4200: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
4201:
4202: l_result := PACKING_INSTRUCTIONS
4203: (p_operation => l_operation

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

4211: END IF;
4212:
4213: END IF;
4214:
4215: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
4216: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
4217:
4218: l_result := PAYMENT_TERM
4219: (p_operation => l_operation

Line 4231: IF p_line_rec.planning_priority = FND_API.G_MISS_NUM THEN NULL;

4227: END IF;
4228:
4229: END IF;
4230:
4231: IF p_line_rec.planning_priority = FND_API.G_MISS_NUM THEN NULL;
4232: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.planning_priority,p_old_line_rec.planning_priority) THEN
4233:
4234: l_result := PLANNING_PRIORITY
4235: (p_operation => l_operation

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

4243: END IF;
4244:
4245: END IF;
4246:
4247: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
4248: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
4249:
4250: l_result := PRICE_LIST
4251: (p_operation => l_operation

Line 4263: IF p_line_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;

4259: END IF;
4260:
4261: END IF;
4262:
4263: IF p_line_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
4264: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_date,p_old_line_rec.pricing_date) THEN
4265:
4266: l_result := PRICING_DATE
4267: (p_operation => l_operation

Line 4279: IF p_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN NULL;

4275: END IF;
4276:
4277: END IF;
4278:
4279: IF p_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN NULL;
4280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity) THEN
4281:
4282: l_result := PRICING_QUANTITY
4283: (p_operation => l_operation

Line 4295: IF p_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;

4291: END IF;
4292:
4293: END IF;
4294:
4295: IF p_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom) THEN
4297:
4298: l_result := PRICING_QUANTITY_UOM
4299: (p_operation => l_operation

Line 4311: IF p_line_rec.project_id = FND_API.G_MISS_NUM THEN NULL;

4307: END IF;
4308:
4309: END IF;
4310:
4311: IF p_line_rec.project_id = FND_API.G_MISS_NUM THEN NULL;
4312: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,p_old_line_rec.project_id) THEN
4313:
4314: l_result := PROJECT
4315: (p_operation => l_operation

Line 4327: IF p_line_rec.promise_date = FND_API.G_MISS_DATE THEN NULL;

4323: END IF;
4324:
4325: END IF;
4326:
4327: IF p_line_rec.promise_date = FND_API.G_MISS_DATE THEN NULL;
4328: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.promise_date,p_old_line_rec.promise_date) THEN
4329:
4330: l_result := PROMISE_DATE
4331: (p_operation => l_operation

Line 4343: IF p_line_rec.request_date = FND_API.G_MISS_DATE THEN NULL;

4339: END IF;
4340:
4341: END IF;
4342:
4343: IF p_line_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
4344: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.request_date,p_old_line_rec.request_date) THEN
4345:
4346: l_result := REQUEST_DATE
4347: (p_operation => l_operation

Line 4359: IF p_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;

4355: END IF;
4356:
4357: END IF;
4358:
4359: IF p_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4360: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_reason_code,p_old_line_rec.return_reason_code) THEN
4361:
4362: l_result := RETURN_REASON
4363: (p_operation => l_operation

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

4371: END IF;
4372:
4373: END IF;
4374:
4375: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
4376: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN
4377:
4378: l_result := SALESREP
4379: (p_operation => l_operation

Line 4391: IF p_line_rec.schedule_arrival_date = FND_API.G_MISS_DATE THEN NULL;

4387: END IF;
4388:
4389: END IF;
4390:
4391: IF p_line_rec.schedule_arrival_date = FND_API.G_MISS_DATE THEN NULL;
4392: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_arrival_date),trunc(p_old_line_rec.schedule_arrival_date)) THEN
4393:
4394: l_result := SCHEDULE_ARRIVAL_DATE
4395: (p_operation => l_operation

Line 4407: IF p_line_rec.schedule_ship_date = FND_API.G_MISS_DATE THEN NULL;

4403: END IF;
4404:
4405: END IF;
4406:
4407: IF p_line_rec.schedule_ship_date = FND_API.G_MISS_DATE THEN NULL;
4408: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_ship_date),trunc(p_old_line_rec.schedule_ship_date)) THEN
4409:
4410: l_result := SCHEDULE_SHIP_DATE
4411: (p_operation => l_operation

Line 4423: IF p_line_rec.service_reference_line_id = FND_API.G_MISS_NUM THEN NULL;

4419: END IF;
4420:
4421: END IF;
4422:
4423: IF p_line_rec.service_reference_line_id = FND_API.G_MISS_NUM THEN NULL;
4424: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_line_id,p_old_line_rec.service_reference_line_id) THEN
4425:
4426: l_result := SERVICE_REFERENCE_LINE
4427: (p_operation => l_operation

Line 4439: IF p_line_rec.service_reference_system_id = FND_API.G_MISS_NUM THEN NULL;

4435: END IF;
4436:
4437: END IF;
4438:
4439: IF p_line_rec.service_reference_system_id = FND_API.G_MISS_NUM THEN NULL;
4440: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_system_id,p_old_line_rec.service_reference_system_id) THEN
4441:
4442: l_result := SERVICE_REFERENCE_SYSTEM
4443: (p_operation => l_operation

Line 4455: IF p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR THEN NULL;

4451: END IF;
4452:
4453: END IF;
4454:
4455: IF p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR THEN NULL;
4456: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_type_code,p_old_line_rec.service_reference_type_code) THEN
4457:
4458: l_result := SERVICE_REFERENCE_TYPE
4459: (p_operation => l_operation

Line 4474: IF p_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN NULL;

4470:
4471: /* Fix to bug 2205900: Added constraints functions for
4472: some missing SERVICE fields */
4473:
4474: IF p_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN NULL;
4475: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_coterminate_flag,p_old_line_rec.service_coterminate_flag) THEN
4476:
4477: l_result := SERVICE_COTERMINATE
4478: (p_operation => l_operation

Line 4490: IF p_line_rec.service_duration = FND_API.G_MISS_NUM THEN NULL;

4486: END IF;
4487:
4488: END IF;
4489:
4490: IF p_line_rec.service_duration = FND_API.G_MISS_NUM THEN NULL;
4491: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_duration,p_old_line_rec.service_duration) THEN
4492:
4493: l_result := SERVICE_DURATION
4494: (p_operation => l_operation

Line 4506: IF p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN NULL;

4502: END IF;
4503:
4504: END IF;
4505:
4506: IF p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN NULL;
4507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_end_date,p_old_line_rec.service_end_date) THEN
4508:
4509: l_result := SERVICE_END_DATE
4510: (p_operation => l_operation

Line 4522: IF p_line_rec.service_period = FND_API.G_MISS_CHAR THEN NULL;

4518: END IF;
4519:
4520: END IF;
4521:
4522: IF p_line_rec.service_period = FND_API.G_MISS_CHAR THEN NULL;
4523: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_period,p_old_line_rec.service_period) THEN
4524:
4525: l_result := SERVICE_PERIOD
4526: (p_operation => l_operation

Line 4538: IF p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN NULL;

4534: END IF;
4535:
4536: END IF;
4537:
4538: IF p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN NULL;
4539: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_start_date,p_old_line_rec.service_start_date) THEN
4540:
4541: l_result := SERVICE_START_DATE
4542: (p_operation => l_operation

Line 4554: IF p_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN NULL;

4550: END IF;
4551:
4552: END IF;
4553:
4554: IF p_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN NULL;
4555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_comments,p_old_line_rec.service_txn_comments) THEN
4556:
4557: l_result := SERVICE_TXN_COMMENTS
4558: (p_operation => l_operation

Line 4570: IF p_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN NULL;

4566: END IF;
4567:
4568: END IF;
4569:
4570: IF p_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4571: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_reason_code,p_old_line_rec.service_txn_reason_code) THEN
4572:
4573: l_result := SERVICE_TXN_REASON
4574: (p_operation => l_operation

Line 4587: IF p_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN

4583:
4584: END IF;
4585:
4586: --sol_ord_er #16014165 start
4587: IF p_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN
4588: NULL;
4589: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_profile_id,p_old_line_rec.service_bill_profile_id) THEN
4590: l_result := SERVICE_BILLING_PROFILE
4591: (p_operation => l_operation

Line 4601: IF p_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN

4597: x_result := OE_PC_GLOBALS.YES;
4598: END IF;
4599: END IF;
4600:
4601: IF p_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN
4602: NULL;
4603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_option_code,p_old_line_rec.service_bill_option_code) THEN
4604: l_result := SERVICE_BILLING_OPTION
4605: (p_operation => l_operation

Line 4615: IF p_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN

4611: x_result := OE_PC_GLOBALS.YES;
4612: END IF;
4613: END IF;
4614:
4615: IF p_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN
4616: NULL;
4617: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_cov_template_id,p_old_line_rec.service_cov_template_id) THEN
4618: l_result := SERVICE_COVERAGE_TEMPLATE
4619: (p_operation => l_operation

Line 4629: IF p_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN

4625: x_result := OE_PC_GLOBALS.YES;
4626: END IF;
4627: END IF;
4628:
4629: IF p_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN
4630: NULL;
4631: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_subs_template_id,p_old_line_rec.service_subs_template_id) THEN
4632: l_result := SERVICE_SUBSCRIPTION_TEMPLATE
4633: (p_operation => l_operation

Line 4643: IF p_line_rec.SUBSCRIPTION_ENABLE_FLAG = FND_API.G_MISS_CHAR THEN

4639: x_result := OE_PC_GLOBALS.YES;
4640: END IF;
4641: END IF;
4642:
4643: IF p_line_rec.SUBSCRIPTION_ENABLE_FLAG = FND_API.G_MISS_CHAR THEN
4644: NULL;
4645: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.SUBSCRIPTION_ENABLE_FLAG,p_old_line_rec.SUBSCRIPTION_ENABLE_FLAG) THEN
4646: l_result := SUBSCRIPTION_ENABLE_FLAG
4647: (p_operation => l_operation

Line 4658: IF p_line_rec.shipment_number = FND_API.G_MISS_NUM THEN NULL;

4654: END IF;
4655: END IF;
4656: --sol_ord_er #16014165 end
4657:
4658: IF p_line_rec.shipment_number = FND_API.G_MISS_NUM THEN NULL;
4659: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_number,p_old_line_rec.shipment_number) THEN
4660:
4661: l_result := SHIPMENT_NUMBER
4662: (p_operation => l_operation

Line 4674: IF p_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;

4670: END IF;
4671:
4672: END IF;
4673:
4674: IF p_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
4675: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_priority_code,p_old_line_rec.shipment_priority_code) THEN
4676:
4677: l_result := SHIPMENT_PRIORITY
4678: (p_operation => l_operation

Line 4690: IF p_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN NULL;

4686: END IF;
4687:
4688: END IF;
4689:
4690: IF p_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN NULL;
4691: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity,p_old_line_rec.shipped_quantity) THEN
4692:
4693: l_result := SHIPPED_QUANTITY
4694: (p_operation => l_operation

Line 4707: IF p_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN NULL;

4703:
4704: END IF;
4705:
4706: -- INVCONV
4707: IF p_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4708: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity2,p_old_line_rec.shipped_quantity2) THEN
4709:
4710: l_result := SHIPPED_QUANTITY2
4711: (p_operation => l_operation

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

4720:
4721: END IF;
4722:
4723:
4724: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
4725: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
4726:
4727: l_result := SHIPPING_INSTRUCTIONS
4728: (p_operation => l_operation

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

4736: END IF;
4737:
4738: END IF;
4739:
4740: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
4741: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
4742:
4743: l_result := SHIPPING_METHOD
4744: (p_operation => l_operation

Line 4756: IF p_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN NULL;

4752: END IF;
4753:
4754: END IF;
4755:
4756: IF p_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN NULL;
4757: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity,p_old_line_rec.shipping_quantity) THEN
4758:
4759: l_result := SHIPPING_QUANTITY
4760: (p_operation => l_operation

Line 4773: IF p_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN NULL;

4769:
4770: END IF;
4771:
4772: -- INVCONV
4773: IF p_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4774: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity2,p_old_line_rec.shipping_quantity2) THEN
4775:
4776: l_result := SHIPPING_QUANTITY2
4777: (p_operation => l_operation

Line 4791: IF p_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;

4787: END IF;
4788:
4789:
4790:
4791: IF p_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4792: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom,p_old_line_rec.shipping_quantity_uom) THEN
4793:
4794: l_result := SHIPPING_QUANTITY_UOM
4795: (p_operation => l_operation

Line 4808: IF p_line_rec.shipping_quantity_uom2 = FND_API.G_MISS_CHAR THEN NULL;

4804:
4805: END IF;
4806:
4807: -- INVCONV
4808: IF p_line_rec.shipping_quantity_uom2 = FND_API.G_MISS_CHAR THEN NULL;
4809: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom2,p_old_line_rec.shipping_quantity_uom2) THEN
4810:
4811: l_result := SHIPPING_QUANTITY_UOM2
4812: (p_operation => l_operation

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

4821:
4822: END IF;
4823:
4824:
4825: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
4826: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
4827:
4828: l_result := SHIP_FROM_ORG
4829: (p_operation => l_operation

Line 4841: IF p_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN NULL;

4837: END IF;
4838:
4839: END IF;
4840:
4841: IF p_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN NULL;
4842: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_model_complete_flag,p_old_line_rec.ship_model_complete_flag) THEN
4843:
4844: l_result := SHIP_MODEL_COMPLETE
4845: (p_operation => l_operation

Line 4857: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;

4853: END IF;
4854:
4855: END IF;
4856:
4857: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4858: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4859: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4860:
4861: l_result := SHIP_SET

Line 4874: IF p_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;

4870: END IF;
4871:
4872: END IF;
4873:
4874: IF p_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
4875: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_above,p_old_line_rec.ship_tolerance_above) THEN
4876:
4877: l_result := SHIP_TOLERANCE_ABOVE
4878: (p_operation => l_operation

Line 4890: IF p_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;

4886: END IF;
4887:
4888: END IF;
4889:
4890: IF p_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
4891: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_below,p_old_line_rec.ship_tolerance_below) THEN
4892:
4893: l_result := SHIP_TOLERANCE_BELOW
4894: (p_operation => l_operation

Line 4906: IF p_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;

4902: END IF;
4903:
4904: END IF;
4905:
4906: IF p_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
4907: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id) THEN
4908:
4909: l_result := SHIP_TO_CONTACT
4910: (p_operation => l_operation

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

4918: END IF;
4919:
4920: END IF;
4921:
4922: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4923: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
4924:
4925: l_result := SHIP_TO_ORG
4926: (p_operation => l_operation

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

4934: END IF;
4935:
4936: END IF;
4937:
4938: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4939: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
4940:
4941: l_result := SOLD_TO_ORG
4942: (p_operation => l_operation

Line 4954: IF p_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN NULL;

4950: END IF;
4951:
4952: END IF;
4953:
4954: IF p_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN NULL;
4955: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.source_type_code,p_old_line_rec.source_type_code) THEN
4956:
4957: l_result := SOURCE_TYPE
4958: (p_operation => l_operation

Line 4970: IF p_line_rec.subinventory = FND_API.G_MISS_CHAR THEN NULL;

4966: END IF;
4967:
4968: END IF;
4969:
4970: IF p_line_rec.subinventory = FND_API.G_MISS_CHAR THEN NULL;
4971: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.subinventory,p_old_line_rec.subinventory) THEN
4972:
4973: l_result := SUBINVENTORY
4974: (p_operation => l_operation

Line 4986: IF p_line_rec.task_id = FND_API.G_MISS_NUM THEN NULL;

4982: END IF;
4983:
4984: END IF;
4985:
4986: IF p_line_rec.task_id = FND_API.G_MISS_NUM THEN NULL;
4987: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,p_old_line_rec.task_id) THEN
4988:
4989: l_result := TASK
4990: (p_operation => l_operation

Line 5002: IF p_line_rec.tax_code = FND_API.G_MISS_CHAR THEN NULL;

4998: END IF;
4999:
5000: END IF;
5001:
5002: IF p_line_rec.tax_code = FND_API.G_MISS_CHAR THEN NULL;
5003: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_code,p_old_line_rec.tax_code) THEN
5004:
5005: l_result := TAX
5006: (p_operation => l_operation

Line 5018: IF p_line_rec.tax_date = FND_API.G_MISS_DATE THEN NULL;

5014: END IF;
5015:
5016: END IF;
5017:
5018: IF p_line_rec.tax_date = FND_API.G_MISS_DATE THEN NULL;
5019: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_date,p_old_line_rec.tax_date) THEN
5020:
5021: l_result := TAX_DATE
5022: (p_operation => l_operation

Line 5034: IF p_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;

5030: END IF;
5031:
5032: END IF;
5033:
5034: IF p_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
5035: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_flag,p_old_line_rec.tax_exempt_flag) THEN
5036:
5037: l_result := TAX_EXEMPT
5038: (p_operation => l_operation

Line 5050: IF p_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;

5046: END IF;
5047:
5048: END IF;
5049:
5050: IF p_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
5051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number,p_old_line_rec.tax_exempt_number) THEN
5052:
5053: l_result := TAX_EXEMPT_NUMBER
5054: (p_operation => l_operation

Line 5066: IF p_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;

5062: END IF;
5063:
5064: END IF;
5065:
5066: IF p_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
5067: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_reason_code,p_old_line_rec.tax_exempt_reason_code) THEN
5068:
5069: l_result := TAX_EXEMPT_REASON
5070: (p_operation => l_operation

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

5078: END IF;
5079:
5080: END IF;
5081:
5082: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
5083: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
5084:
5085: l_result := UNIT_LIST_PRICE
5086: (p_operation => l_operation

Line 5098: IF p_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN NULL;

5094: END IF;
5095:
5096: END IF;
5097:
5098: IF p_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN NULL;
5099: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price) THEN
5100:
5101: l_result := UNIT_SELLING_PRICE
5102: (p_operation => l_operation

Line 5115: IF p_line_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;

5111:
5112: END IF;
5113:
5114: -- BEGIN: Blankets Code Merge
5115: IF p_line_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
5116: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_number,p_old_line_rec.blanket_number) THEN
5117:
5118: l_result := BLANKET_NUMBER
5119: (p_operation => l_operation

Line 5131: IF p_line_rec.blanket_line_number = FND_API.G_MISS_NUM THEN NULL;

5127: END IF;
5128:
5129: END IF;
5130:
5131: IF p_line_rec.blanket_line_number = FND_API.G_MISS_NUM THEN NULL;
5132: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number) THEN
5133:
5134: l_result := BLANKET_LINE_NUMBER
5135: (p_operation => l_operation

Line 5161: RAISE FND_API.G_EXC_ERROR;

5157:
5158: IF NVL(l_active_flag,'N')='N' THEN
5159: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
5160: OE_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;
5163: EXCEPTION
5164: WHEN OTHERS THEN
5165: IF l_debug_level > 0 THEN

Line 5171: IF p_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN

5167: END IF;
5168: END;
5169: END IF;
5170:
5171: IF p_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
5172: NULL;
5173: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.calculate_price_flag
5174: ,p_old_line_rec.calculate_price_flag) THEN
5175:

Line 5186: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN

5182: x_result := OE_PC_GLOBALS.YES;
5183: END IF;
5184: END IF;
5185:
5186: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN
5187: NULL;
5188: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_shipment_number,p_old_line_rec.customer_shipment_number) THEN
5189:
5190: l_result := CUSTOMER_SHIPMENT_NUMBER

Line 5221: IF p_line_rec.context = FND_API.G_MISS_CHAR THEN NULL;

5217: l_check_all_cols_constraint := g_check_all_cols_constraint;
5218: g_check_all_cols_constraint := 'N';
5219: END IF;
5220:
5221: IF p_line_rec.context = FND_API.G_MISS_CHAR THEN NULL;
5222: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.context,p_old_line_rec.context) THEN
5223:
5224: l_result := CONTEXT
5225: (p_operation => l_operation

Line 5237: IF p_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

5233: END IF;
5234:
5235: END IF;
5236:
5237: IF p_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
5238: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute1,p_old_line_rec.attribute1) THEN
5239:
5240: l_result := ATTRIBUTE1
5241: (p_operation => l_operation

Line 5253: IF p_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

5249: END IF;
5250:
5251: END IF;
5252:
5253: IF p_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
5254: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute10,p_old_line_rec.attribute10) THEN
5255:
5256: l_result := ATTRIBUTE10
5257: (p_operation => l_operation

Line 5269: IF p_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

5265: END IF;
5266:
5267: END IF;
5268:
5269: IF p_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
5270: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute11,p_old_line_rec.attribute11) THEN
5271:
5272: l_result := ATTRIBUTE11
5273: (p_operation => l_operation

Line 5285: IF p_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

5281: END IF;
5282:
5283: END IF;
5284:
5285: IF p_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
5286: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute12,p_old_line_rec.attribute12) THEN
5287:
5288: l_result := ATTRIBUTE12
5289: (p_operation => l_operation

Line 5301: IF p_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

5297: END IF;
5298:
5299: END IF;
5300:
5301: IF p_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
5302: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute13,p_old_line_rec.attribute13) THEN
5303:
5304: l_result := ATTRIBUTE13
5305: (p_operation => l_operation

Line 5317: IF p_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

5313: END IF;
5314:
5315: END IF;
5316:
5317: IF p_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
5318: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute14,p_old_line_rec.attribute14) THEN
5319:
5320: l_result := ATTRIBUTE14
5321: (p_operation => l_operation

Line 5333: IF p_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

5329: END IF;
5330:
5331: END IF;
5332:
5333: IF p_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
5334: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute15,p_old_line_rec.attribute15) THEN
5335:
5336: l_result := ATTRIBUTE15
5337: (p_operation => l_operation

Line 5351: IF p_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;

5347: END IF;
5348:
5349: -- For bug 2184255
5350:
5351: IF p_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
5352: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute16,p_old_line_rec.attribute16) THEN
5353:
5354: l_result := ATTRIBUTE16
5355: (p_operation => l_operation

Line 5367: IF p_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;

5363: END IF;
5364:
5365: END IF;
5366:
5367: IF p_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
5368: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute17,p_old_line_rec.attribute17) THEN
5369:
5370: l_result := ATTRIBUTE17
5371: (p_operation => l_operation

Line 5383: IF p_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;

5379: END IF;
5380:
5381: END IF;
5382:
5383: IF p_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
5384: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute18,p_old_line_rec.attribute18) THEN
5385:
5386: l_result := ATTRIBUTE18
5387: (p_operation => l_operation

Line 5399: IF p_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;

5395: END IF;
5396:
5397: END IF;
5398:
5399: IF p_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
5400: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute19,p_old_line_rec.attribute19) THEN
5401:
5402: l_result := ATTRIBUTE19
5403: (p_operation => l_operation

Line 5415: IF p_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

5411: END IF;
5412:
5413: END IF;
5414:
5415: IF p_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5416: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute2,p_old_line_rec.attribute2) THEN
5417:
5418: l_result := ATTRIBUTE2
5419: (p_operation => l_operation

Line 5432: IF p_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;

5428:
5429: END IF;
5430:
5431:
5432: IF p_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
5433: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute20,p_old_line_rec.attribute20) THEN
5434:
5435: l_result := ATTRIBUTE20
5436: (p_operation => l_operation

Line 5450: IF p_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

5446: END IF;
5447:
5448: -- End bug 2184255
5449:
5450: IF p_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
5451: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute3,p_old_line_rec.attribute3) THEN
5452:
5453: l_result := ATTRIBUTE3
5454: (p_operation => l_operation

Line 5466: IF p_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

5462: END IF;
5463:
5464: END IF;
5465:
5466: IF p_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
5467: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute4,p_old_line_rec.attribute4) THEN
5468:
5469: l_result := ATTRIBUTE4
5470: (p_operation => l_operation

Line 5482: IF p_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

5478: END IF;
5479:
5480: END IF;
5481:
5482: IF p_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
5483: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute5,p_old_line_rec.attribute5) THEN
5484:
5485: l_result := ATTRIBUTE5
5486: (p_operation => l_operation

Line 5498: IF p_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

5494: END IF;
5495:
5496: END IF;
5497:
5498: IF p_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
5499: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute6,p_old_line_rec.attribute6) THEN
5500:
5501: l_result := ATTRIBUTE6
5502: (p_operation => l_operation

Line 5514: IF p_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

5510: END IF;
5511:
5512: END IF;
5513:
5514: IF p_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
5515: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute7,p_old_line_rec.attribute7) THEN
5516:
5517: l_result := ATTRIBUTE7
5518: (p_operation => l_operation

Line 5530: IF p_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

5526: END IF;
5527:
5528: END IF;
5529:
5530: IF p_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
5531: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute8,p_old_line_rec.attribute8) THEN
5532:
5533: l_result := ATTRIBUTE8
5534: (p_operation => l_operation

Line 5546: IF p_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

5542: END IF;
5543:
5544: END IF;
5545:
5546: IF p_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
5547: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute9,p_old_line_rec.attribute9) THEN
5548:
5549: l_result := ATTRIBUTE9
5550: (p_operation => l_operation

Line 5563: IF p_line_rec.return_context = FND_API.G_MISS_CHAR THEN NULL;

5559:
5560: END IF;
5561:
5562: ---Start bug 14272033
5563: IF p_line_rec.return_context = FND_API.G_MISS_CHAR THEN NULL;
5564: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_context,p_old_line_rec.return_context) THEN
5565:
5566: l_result := return_context
5567: (p_operation => l_operation

Line 5579: IF p_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN NULL;

5575: END IF;
5576:
5577: END IF;
5578:
5579: IF p_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN NULL;
5580: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute1,p_old_line_rec.return_attribute1) THEN
5581:
5582: l_result := return_attribute1
5583: (p_operation => l_operation

Line 5595: IF p_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN NULL;

5591: END IF;
5592:
5593: END IF;
5594:
5595: IF p_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5596: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute2,p_old_line_rec.return_attribute2) THEN
5597:
5598: l_result := return_attribute2
5599: (p_operation => l_operation

Line 5612: IF p_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN NULL;

5608:
5609: END IF;
5610: ---END 14272033
5611:
5612: IF p_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN NULL;
5613: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.user_item_description, p_old_line_rec.user_item_description) THEN
5614:
5615: l_result := USER_ITEM_DESCRIPTION
5616: (p_operation => l_operation

Line 5629: IF p_line_rec.contingency_id = FND_API.G_MISS_NUM THEN NULL;

5625:
5626: END IF;
5627:
5628: /* Customer Acceptance - Start */
5629: IF p_line_rec.contingency_id = FND_API.G_MISS_NUM THEN NULL;
5630: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.contingency_id,p_old_line_rec.contingency_id) THEN
5631:
5632: l_result := CONTINGENCY
5633: (p_operation => l_operation

Line 5645: IF p_line_rec.revrec_expiration_days = FND_API.G_MISS_NUM THEN NULL;

5641: END IF;
5642:
5643: END IF;
5644:
5645: IF p_line_rec.revrec_expiration_days = FND_API.G_MISS_NUM THEN NULL;
5646: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.revrec_expiration_days,p_old_line_rec.revrec_expiration_days) THEN
5647:
5648: l_result := REVREC_EXPIRATION_DAYS
5649: (p_operation => l_operation

Line 5678: WHEN FND_API.G_EXC_ERROR THEN

5674: oe_debug_pub.add('Exit OE_LINE_Security.Attributes',1);
5675: END IF;
5676:
5677: EXCEPTION
5678: WHEN FND_API.G_EXC_ERROR THEN
5679: x_return_status := FND_API.G_RET_STS_ERROR;
5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682: WHEN OTHERS THEN

Line 5679: x_return_status := FND_API.G_RET_STS_ERROR;

5675: END IF;
5676:
5677: EXCEPTION
5678: WHEN FND_API.G_EXC_ERROR THEN
5679: x_return_status := FND_API.G_RET_STS_ERROR;
5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682: WHEN OTHERS THEN
5683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5676:
5677: EXCEPTION
5678: WHEN FND_API.G_EXC_ERROR THEN
5679: x_return_status := FND_API.G_RET_STS_ERROR;
5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682: WHEN OTHERS THEN
5683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5684: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5677: EXCEPTION
5678: WHEN FND_API.G_EXC_ERROR THEN
5679: x_return_status := FND_API.G_RET_STS_ERROR;
5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682: WHEN OTHERS THEN
5683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5684: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5685: OE_MSG_PUB.Add_Exc_Msg

Line 5683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5679: x_return_status := FND_API.G_RET_STS_ERROR;
5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682: WHEN OTHERS THEN
5683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5684: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5685: OE_MSG_PUB.Add_Exc_Msg
5686: ( G_PKG_NAME
5687: , 'Attributes'