DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_HDLR dependencies on OE_HEADER_SECURITY

Line 44: OE_HEADER_Security.G_Is_Caller_Defaulting := 'Y';

40:
41: oe_debug_pub.ADD('Enter ONT_HEADER_Def_Hdlr.Default_Record');
42:
43: IF p_iteration =1 THEN
44: OE_HEADER_Security.G_Is_Caller_Defaulting := 'Y';
45: g_record := p_x_rec;
46: END IF;
47:
48: -- if max. iteration is reached exit

Line 71: IF OE_HEADER_SECURITY.SOLD_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

67: -- For UPDATE operations, check security if new defaulted value is not equal to old value
68: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
69: l_attr:=l_attr||' 3';
70: IF NOT OE_GLOBALS.Equal(g_record.sold_to_org_id, p_in_old_rec.sold_to_org_id) THEN
71: IF OE_HEADER_SECURITY.SOLD_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
72: -- Raise error if security returns YES, operation IS CONSTRAINED
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 101: IF OE_HEADER_SECURITY.SHIP_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

97: -- For UPDATE operations, check security if new defaulted value is not equal to old value
98: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
99: l_attr:=l_attr||' 3';
100: IF NOT OE_GLOBALS.Equal(g_record.ship_to_org_id, p_in_old_rec.ship_to_org_id) THEN
101: IF OE_HEADER_SECURITY.SHIP_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
102: -- Raise error if security returns YES, operation IS CONSTRAINED
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 131: IF OE_HEADER_SECURITY.DELIVER_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

127: -- For UPDATE operations, check security if new defaulted value is not equal to old value
128: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
129: l_attr:=l_attr||' 3';
130: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_org_id, p_in_old_rec.deliver_to_org_id) THEN
131: IF OE_HEADER_SECURITY.DELIVER_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
132: -- Raise error if security returns YES, operation IS CONSTRAINED
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 161: IF OE_HEADER_SECURITY.AGREEMENT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

157: -- For UPDATE operations, check security if new defaulted value is not equal to old value
158: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
159: l_attr:=l_attr||' 3';
160: IF NOT OE_GLOBALS.Equal(g_record.agreement_id, p_in_old_rec.agreement_id) THEN
161: IF OE_HEADER_SECURITY.AGREEMENT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
162: -- Raise error if security returns YES, operation IS CONSTRAINED
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 191: IF OE_HEADER_SECURITY.INVOICE_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

187: -- For UPDATE operations, check security if new defaulted value is not equal to old value
188: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
189: l_attr:=l_attr||' 3';
190: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_org_id, p_in_old_rec.invoice_to_org_id) THEN
191: IF OE_HEADER_SECURITY.INVOICE_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
192: -- Raise error if security returns YES, operation IS CONSTRAINED
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 225: IF OE_HEADER_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

221: -- For UPDATE operations, check security if new defaulted value is not equal to old value
222: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
223: l_attr:=l_attr||' 3';
224: IF NOT OE_GLOBALS.Equal(g_record.price_list_id, p_in_old_rec.price_list_id) THEN
225: IF OE_HEADER_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
226: -- Raise error if security returns YES, operation IS CONSTRAINED
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 261: IF OE_HEADER_SECURITY.REQUEST_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

257: -- For UPDATE operations, check security if new defaulted value is not equal to old value
258: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
259: l_attr:=l_attr||' 3';
260: IF NOT OE_GLOBALS.Equal(g_record.request_date, p_in_old_rec.request_date) THEN
261: IF OE_HEADER_SECURITY.REQUEST_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
262: -- Raise error if security returns YES, operation IS CONSTRAINED
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 301: IF OE_HEADER_SECURITY.ACCOUNTING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

297: -- For UPDATE operations, check security if new defaulted value is not equal to old value
298: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
299: l_attr:=l_attr||' 3';
300: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_id, p_in_old_rec.accounting_rule_id) THEN
301: IF OE_HEADER_SECURITY.ACCOUNTING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
302: -- Raise error if security returns YES, operation IS CONSTRAINED
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 332: IF OE_HEADER_SECURITY.ACCOUNTING_RULE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

328: -- For UPDATE operations, check security if new defaulted value is not equal to old value
329: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
330: l_attr:=l_attr||' 3';
331: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_duration, p_in_old_rec.accounting_rule_duration) THEN
332: IF OE_HEADER_SECURITY.ACCOUNTING_RULE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
333: -- Raise error if security returns YES, operation IS CONSTRAINED
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 482: IF OE_HEADER_SECURITY.INVOICE_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

478: -- For UPDATE operations, check security if new defaulted value is not equal to old value
479: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
480: l_attr:=l_attr||' 3';
481: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_contact_id, p_in_old_rec.invoice_to_contact_id) THEN
482: IF OE_HEADER_SECURITY.INVOICE_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
483: -- Raise error if security returns YES, operation IS CONSTRAINED
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 548: IF OE_HEADER_SECURITY.SOLD_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

544: -- For UPDATE operations, check security if new defaulted value is not equal to old value
545: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
546: l_attr:=l_attr||' 3';
547: IF NOT OE_GLOBALS.Equal(g_record.sold_to_contact_id, p_in_old_rec.sold_to_contact_id) THEN
548: IF OE_HEADER_SECURITY.SOLD_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
549: -- Raise error if security returns YES, operation IS CONSTRAINED
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 596: IF OE_HEADER_SECURITY.CONVERSION_RATE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

592: -- For UPDATE operations, check security if new defaulted value is not equal to old value
593: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
594: l_attr:=l_attr||' 3';
595: IF NOT OE_GLOBALS.Equal(g_record.conversion_rate_date, p_in_old_rec.conversion_rate_date) THEN
596: IF OE_HEADER_SECURITY.CONVERSION_RATE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
597: -- Raise error if security returns YES, operation IS CONSTRAINED
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 627: IF OE_HEADER_SECURITY.CONVERSION_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

623: -- For UPDATE operations, check security if new defaulted value is not equal to old value
624: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
625: l_attr:=l_attr||' 3';
626: IF NOT OE_GLOBALS.Equal(g_record.conversion_type_code, p_in_old_rec.conversion_type_code) THEN
627: IF OE_HEADER_SECURITY.CONVERSION_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
628: -- Raise error if security returns YES, operation IS CONSTRAINED
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 702: IF OE_HEADER_SECURITY.TRANSACTIONAL_CURR(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

698: -- For UPDATE operations, check security if new defaulted value is not equal to old value
699: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
700: l_attr:=l_attr||' 3';
701: IF NOT OE_GLOBALS.Equal(g_record.transactional_curr_code, p_in_old_rec.transactional_curr_code) THEN
702: IF OE_HEADER_SECURITY.TRANSACTIONAL_CURR(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
703: -- Raise error if security returns YES, operation IS CONSTRAINED
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 733: IF OE_HEADER_SECURITY.IB_CURRENT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

729: -- For UPDATE operations, check security if new defaulted value is not equal to old value
730: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
731: l_attr:=l_attr||' 3';
732: IF NOT OE_GLOBALS.Equal(g_record.ib_current_location, p_in_old_rec.ib_current_location) THEN
733: IF OE_HEADER_SECURITY.IB_CURRENT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
734: -- Raise error if security returns YES, operation IS CONSTRAINED
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 757: IF OE_HEADER_SECURITY.SOLD_TO_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

753: -- For UPDATE operations, check security if new defaulted value is not equal to old value
754: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
755: l_attr:=l_attr||' 3';
756: IF NOT OE_GLOBALS.Equal(g_record.sold_to_site_use_id, p_in_old_rec.sold_to_site_use_id) THEN
757: IF OE_HEADER_SECURITY.SOLD_TO_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
758: -- Raise error if security returns YES, operation IS CONSTRAINED
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 781: IF OE_HEADER_SECURITY.CUST_PO_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

777: -- For UPDATE operations, check security if new defaulted value is not equal to old value
778: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
779: l_attr:=l_attr||' 3';
780: IF NOT OE_GLOBALS.Equal(g_record.cust_po_number, p_in_old_rec.cust_po_number) THEN
781: IF OE_HEADER_SECURITY.CUST_PO_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
782: -- Raise error if security returns YES, operation IS CONSTRAINED
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 842: IF OE_HEADER_SECURITY.DELIVER_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

838: -- For UPDATE operations, check security if new defaulted value is not equal to old value
839: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
840: l_attr:=l_attr||' 3';
841: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_contact_id, p_in_old_rec.deliver_to_contact_id) THEN
842: IF OE_HEADER_SECURITY.DELIVER_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
843: -- Raise error if security returns YES, operation IS CONSTRAINED
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 872: IF OE_HEADER_SECURITY.DEMAND_CLASS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

868: -- For UPDATE operations, check security if new defaulted value is not equal to old value
869: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
870: l_attr:=l_attr||' 3';
871: IF NOT OE_GLOBALS.Equal(g_record.demand_class_code, p_in_old_rec.demand_class_code) THEN
872: IF OE_HEADER_SECURITY.DEMAND_CLASS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
873: -- Raise error if security returns YES, operation IS CONSTRAINED
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 930: IF OE_HEADER_SECURITY.END_CUSTOMER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

926: -- For UPDATE operations, check security if new defaulted value is not equal to old value
927: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
928: l_attr:=l_attr||' 3';
929: IF NOT OE_GLOBALS.Equal(g_record.end_customer_id, p_in_old_rec.end_customer_id) THEN
930: IF OE_HEADER_SECURITY.END_CUSTOMER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
931: -- Raise error if security returns YES, operation IS CONSTRAINED
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 954: IF OE_HEADER_SECURITY.END_CUSTOMER_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

950: -- For UPDATE operations, check security if new defaulted value is not equal to old value
951: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
952: l_attr:=l_attr||' 3';
953: IF NOT OE_GLOBALS.Equal(g_record.end_customer_contact_id, p_in_old_rec.end_customer_contact_id) THEN
954: IF OE_HEADER_SECURITY.END_CUSTOMER_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
955: -- Raise error if security returns YES, operation IS CONSTRAINED
956: RAISE FND_API.G_EXC_ERROR;
957: END IF;
958: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 978: IF OE_HEADER_SECURITY.END_CUSTOMER_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

974: -- For UPDATE operations, check security if new defaulted value is not equal to old value
975: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
976: l_attr:=l_attr||' 3';
977: IF NOT OE_GLOBALS.Equal(g_record.end_customer_site_use_id, p_in_old_rec.end_customer_site_use_id) THEN
978: IF OE_HEADER_SECURITY.END_CUSTOMER_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
979: -- Raise error if security returns YES, operation IS CONSTRAINED
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
982: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1002: IF OE_HEADER_SECURITY.EXPIRATION_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

998: -- For UPDATE operations, check security if new defaulted value is not equal to old value
999: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1000: l_attr:=l_attr||' 3';
1001: IF NOT OE_GLOBALS.Equal(g_record.expiration_date, p_in_old_rec.expiration_date) THEN
1002: IF OE_HEADER_SECURITY.EXPIRATION_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1003: -- Raise error if security returns YES, operation IS CONSTRAINED
1004: RAISE FND_API.G_EXC_ERROR;
1005: END IF;
1006: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1032: IF OE_HEADER_SECURITY.FOB_POINT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1028: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1029: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1030: l_attr:=l_attr||' 3';
1031: IF NOT OE_GLOBALS.Equal(g_record.fob_point_code, p_in_old_rec.fob_point_code) THEN
1032: IF OE_HEADER_SECURITY.FOB_POINT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1033: -- Raise error if security returns YES, operation IS CONSTRAINED
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1081: IF OE_HEADER_SECURITY.FREIGHT_TERMS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1077: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1078: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1079: l_attr:=l_attr||' 3';
1080: IF NOT OE_GLOBALS.Equal(g_record.freight_terms_code, p_in_old_rec.freight_terms_code) THEN
1081: IF OE_HEADER_SECURITY.FREIGHT_TERMS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1082: -- Raise error if security returns YES, operation IS CONSTRAINED
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1264: IF OE_HEADER_SECURITY.IB_INSTALLED_AT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1260: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1261: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1262: l_attr:=l_attr||' 3';
1263: IF NOT OE_GLOBALS.Equal(g_record.ib_installed_at_location, p_in_old_rec.ib_installed_at_location) THEN
1264: IF OE_HEADER_SECURITY.IB_INSTALLED_AT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1265: -- Raise error if security returns YES, operation IS CONSTRAINED
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1288: IF OE_HEADER_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1284: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1285: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1286: l_attr:=l_attr||' 3';
1287: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN
1288: IF OE_HEADER_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1289: -- Raise error if security returns YES, operation IS CONSTRAINED
1290: RAISE FND_API.G_EXC_ERROR;
1291: END IF;
1292: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1461: IF OE_HEADER_SECURITY.ORDER_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1457: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1458: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1459: l_attr:=l_attr||' 3';
1460: IF NOT OE_GLOBALS.Equal(g_record.order_type_id, p_in_old_rec.order_type_id) THEN
1461: IF OE_HEADER_SECURITY.ORDER_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1462: -- Raise error if security returns YES, operation IS CONSTRAINED
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1491: IF OE_HEADER_SECURITY.ORDERED_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1487: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1488: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1489: l_attr:=l_attr||' 3';
1490: IF NOT OE_GLOBALS.Equal(g_record.ordered_date, p_in_old_rec.ordered_date) THEN
1491: IF OE_HEADER_SECURITY.ORDERED_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1492: -- Raise error if security returns YES, operation IS CONSTRAINED
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1534: IF OE_HEADER_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1530: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1531: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1532: l_attr:=l_attr||' 3';
1533: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN
1534: IF OE_HEADER_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1535: -- Raise error if security returns YES, operation IS CONSTRAINED
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1597: IF OE_HEADER_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1593: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1594: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1595: l_attr:=l_attr||' 3';
1596: IF NOT OE_GLOBALS.Equal(g_record.payment_term_id, p_in_old_rec.payment_term_id) THEN
1597: IF OE_HEADER_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1598: -- Raise error if security returns YES, operation IS CONSTRAINED
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1628: IF OE_HEADER_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1624: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1625: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1626: l_attr:=l_attr||' 3';
1627: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN
1628: IF OE_HEADER_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1629: -- Raise error if security returns YES, operation IS CONSTRAINED
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1677: IF OE_HEADER_SECURITY.QUOTE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1673: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1674: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1675: l_attr:=l_attr||' 3';
1676: IF NOT OE_GLOBALS.Equal(g_record.quote_date, p_in_old_rec.quote_date) THEN
1677: IF OE_HEADER_SECURITY.QUOTE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1678: -- Raise error if security returns YES, operation IS CONSTRAINED
1679: RAISE FND_API.G_EXC_ERROR;
1680: END IF;
1681: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1721: IF OE_HEADER_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1717: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1718: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1719: l_attr:=l_attr||' 3';
1720: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN
1721: IF OE_HEADER_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1722: -- Raise error if security returns YES, operation IS CONSTRAINED
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1751: IF OE_HEADER_SECURITY.SALES_CHANNEL_CODE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1747: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1748: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1749: l_attr:=l_attr||' 3';
1750: IF NOT OE_GLOBALS.Equal(g_record.sales_channel_code, p_in_old_rec.sales_channel_code) THEN
1751: IF OE_HEADER_SECURITY.SALES_CHANNEL_CODE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1752: -- Raise error if security returns YES, operation IS CONSTRAINED
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;
1755: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1786: IF OE_HEADER_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1782: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1783: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1784: l_attr:=l_attr||' 3';
1785: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN
1786: IF OE_HEADER_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1787: -- Raise error if security returns YES, operation IS CONSTRAINED
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1823: IF OE_HEADER_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1819: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1820: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1821: l_attr:=l_attr||' 3';
1822: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN
1823: IF OE_HEADER_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1824: -- Raise error if security returns YES, operation IS CONSTRAINED
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1853: IF OE_HEADER_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1849: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1850: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1851: l_attr:=l_attr||' 3';
1852: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN
1853: IF OE_HEADER_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1854: -- Raise error if security returns YES, operation IS CONSTRAINED
1855: RAISE FND_API.G_EXC_ERROR;
1856: END IF;
1857: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1884: IF OE_HEADER_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1880: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1881: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1882: l_attr:=l_attr||' 3';
1883: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN
1884: IF OE_HEADER_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1885: -- Raise error if security returns YES, operation IS CONSTRAINED
1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;
1888: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 1915: IF OE_HEADER_SECURITY.SHIPMENT_PRIORITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

1911: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1912: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1913: l_attr:=l_attr||' 3';
1914: IF NOT OE_GLOBALS.Equal(g_record.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN
1915: IF OE_HEADER_SECURITY.SHIPMENT_PRIORITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1916: -- Raise error if security returns YES, operation IS CONSTRAINED
1917: RAISE FND_API.G_EXC_ERROR;
1918: END IF;
1919: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2024: IF OE_HEADER_SECURITY.TAX_EXEMPT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

2020: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2021: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2022: l_attr:=l_attr||' 3';
2023: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_flag, p_in_old_rec.tax_exempt_flag) THEN
2024: IF OE_HEADER_SECURITY.TAX_EXEMPT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2025: -- Raise error if security returns YES, operation IS CONSTRAINED
2026: RAISE FND_API.G_EXC_ERROR;
2027: END IF;
2028: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2054: IF OE_HEADER_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

2050: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2051: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2052: l_attr:=l_attr||' 3';
2053: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN
2054: IF OE_HEADER_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2055: -- Raise error if security returns YES, operation IS CONSTRAINED
2056: RAISE FND_API.G_EXC_ERROR;
2057: END IF;
2058: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2085: IF OE_HEADER_SECURITY.TAX_EXEMPT_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

2081: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2082: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2083: l_attr:=l_attr||' 3';
2084: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_reason_code, p_in_old_rec.tax_exempt_reason_code) THEN
2085: IF OE_HEADER_SECURITY.TAX_EXEMPT_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2086: -- Raise error if security returns YES, operation IS CONSTRAINED
2087: RAISE FND_API.G_EXC_ERROR;
2088: END IF;
2089: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2126: IF OE_HEADER_SECURITY.TRANSACTION_PHASE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

2122: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2123: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2124: l_attr:=l_attr||' 3';
2125: IF NOT OE_GLOBALS.Equal(g_record.transaction_phase_code, p_in_old_rec.transaction_phase_code) THEN
2126: IF OE_HEADER_SECURITY.TRANSACTION_PHASE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2127: -- Raise error if security returns YES, operation IS CONSTRAINED
2128: RAISE FND_API.G_EXC_ERROR;
2129: END IF;
2130: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2174: IF OE_HEADER_SECURITY.SHIP_FROM_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN

2170: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2171: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2172: l_attr:=l_attr||' 3';
2173: IF NOT OE_GLOBALS.Equal(g_record.ship_from_org_id, p_in_old_rec.ship_from_org_id) THEN
2174: IF OE_HEADER_SECURITY.SHIP_FROM_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2175: -- Raise error if security returns YES, operation IS CONSTRAINED
2176: RAISE FND_API.G_EXC_ERROR;
2177: END IF;
2178: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line 2364: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';

2360: p_iteration => p_iteration+1 );
2361: END IF;
2362:
2363: IF p_iteration =1 THEN
2364: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2365: p_x_rec := g_record;
2366: END IF;
2367:
2368: oe_debug_pub.ADD('Exit ONT_HEADER_Def_Hdlr.Default_Record');

Line 2373: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';

2369:
2370: EXCEPTION
2371:
2372: WHEN FND_API.G_EXC_ERROR THEN
2373: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2374: RAISE FND_API.G_EXC_ERROR;
2375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2376: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2376: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';

2372: WHEN FND_API.G_EXC_ERROR THEN
2373: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2374: RAISE FND_API.G_EXC_ERROR;
2375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2376: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: WHEN OTHERS THEN
2379: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2380: THEN

Line 2386: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';

2382: ( G_PKG_NAME
2383: ,'Default_Record: '||l_attr
2384: );
2385: END IF;
2386: OE_HEADER_Security.G_Is_Caller_Defaulting := 'N';
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388:
2389: END Default_Record;
2390: