APPS.ONT_HEADER_DEF_HDLR dependencies on OE_GLOBALS

Line 68: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

64: AND p_in_old_rec.SOLD_TO_ORG_ID <> FND_API.G_MISS_NUM THEN
65: g_record.SOLD_TO_ORG_ID := p_in_old_rec.SOLD_TO_ORG_ID;
66: END IF;
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

Line 70: IF NOT OE_GLOBALS.Equal(g_record.sold_to_org_id, p_in_old_rec.sold_to_org_id) THEN

66: END IF;
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;

Line 75: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
76: END IF;
77: END IF;
78: IF g_record.SOLD_TO_ORG_ID IS NOT NULL THEN
79: l_attr:=l_attr||' 4';

Line 98: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

94: l_attr:=l_attr||' 1';
95: g_record.SHIP_TO_ORG_ID := ONT_D1_SHIP_TO_ORG_ID.Get_Default_Value(g_record);
96: l_attr:=l_attr||' 2';
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

Line 100: IF NOT OE_GLOBALS.Equal(g_record.ship_to_org_id, p_in_old_rec.ship_to_org_id) THEN

96: l_attr:=l_attr||' 2';
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;

Line 105: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
106: END IF;
107: END IF;
108: IF g_record.SHIP_TO_ORG_ID IS NOT NULL THEN
109: l_attr:=l_attr||' 4';

Line 128: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

124: l_attr:=l_attr||' 1';
125: g_record.DELIVER_TO_ORG_ID := ONT_D1_DELIVER_TO_ORG_ID.Get_Default_Value(g_record);
126: l_attr:=l_attr||' 2';
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

Line 130: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_org_id, p_in_old_rec.deliver_to_org_id) THEN

126: l_attr:=l_attr||' 2';
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;

Line 135: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
136: END IF;
137: END IF;
138: IF g_record.DELIVER_TO_ORG_ID IS NOT NULL THEN
139: l_attr:=l_attr||' 4';

Line 158: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

154: l_attr:=l_attr||' 1';
155: g_record.AGREEMENT_ID := ONT_D1_AGREEMENT_ID.Get_Default_Value(g_record);
156: l_attr:=l_attr||' 2';
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

Line 160: IF NOT OE_GLOBALS.Equal(g_record.agreement_id, p_in_old_rec.agreement_id) THEN

156: l_attr:=l_attr||' 2';
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;

Line 165: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
166: END IF;
167: END IF;
168: IF g_record.AGREEMENT_ID IS NOT NULL THEN
169: l_attr:=l_attr||' 4';

Line 188: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

184: l_attr:=l_attr||' 1';
185: g_record.INVOICE_TO_ORG_ID := ONT_D1_INVOICE_TO_ORG_ID.Get_Default_Value(g_record);
186: l_attr:=l_attr||' 2';
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

Line 190: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_org_id, p_in_old_rec.invoice_to_org_id) THEN

186: l_attr:=l_attr||' 2';
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;

Line 195: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
196: END IF;
197: END IF;
198: IF g_record.INVOICE_TO_ORG_ID IS NOT NULL THEN
199: l_attr:=l_attr||' 4';

Line 222: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

218: AND p_in_old_rec.PRICE_LIST_ID <> FND_API.G_MISS_NUM THEN
219: g_record.PRICE_LIST_ID := p_in_old_rec.PRICE_LIST_ID;
220: END IF;
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

Line 224: IF NOT OE_GLOBALS.Equal(g_record.price_list_id, p_in_old_rec.price_list_id) THEN

220: END IF;
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;

Line 229: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
230: END IF;
231: END IF;
232: IF g_record.PRICE_LIST_ID IS NOT NULL THEN
233: l_attr:=l_attr||' 4';

Line 258: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

254: l_attr:=l_attr||' 1';
255: g_record.REQUEST_DATE := ONT_D1_REQUEST_DATE.Get_Default_Value(g_record);
256: l_attr:=l_attr||' 2';
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

Line 260: IF NOT OE_GLOBALS.Equal(g_record.request_date, p_in_old_rec.request_date) THEN

256: l_attr:=l_attr||' 2';
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;

Line 265: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
266: END IF;
267: END IF;
268: IF g_record.REQUEST_DATE IS NOT NULL THEN
269: l_attr:=l_attr||' 4';

Line 298: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

294: l_attr:=l_attr||' 1';
295: g_record.ACCOUNTING_RULE_ID := ONT_D1_ACCOUNTING_RULE_ID.Get_Default_Value(g_record);
296: l_attr:=l_attr||' 2';
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

Line 300: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_id, p_in_old_rec.accounting_rule_id) THEN

296: l_attr:=l_attr||' 2';
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;

Line 305: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
306: END IF;
307: END IF;
308: IF g_record.ACCOUNTING_RULE_ID IS NOT NULL THEN
309: l_attr:=l_attr||' 4';

Line 329: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

325: l_attr:=l_attr||' 1';
326: g_record.ACCOUNTING_RULE_DURATION := ONT_D1_ACCOUNTING_RULE_DURA.Get_Default_Value(g_record);
327: l_attr:=l_attr||' 2';
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

Line 331: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_duration, p_in_old_rec.accounting_rule_duration) THEN

327: l_attr:=l_attr||' 2';
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;

Line 336: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
337: END IF;
338: END IF;
339: IF g_record.ACCOUNTING_RULE_DURATION IS NOT NULL THEN
340: l_attr:=l_attr||' 4';

Line 479: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

475: l_attr:=l_attr||' 1';
476: g_record.INVOICE_TO_CONTACT_ID := ONT_D1_INVOICE_TO_CONTACT_I.Get_Default_Value(g_record);
477: l_attr:=l_attr||' 2';
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

Line 481: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_contact_id, p_in_old_rec.invoice_to_contact_id) THEN

477: l_attr:=l_attr||' 2';
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;

Line 486: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
487: END IF;
488: END IF;
489: IF g_record.INVOICE_TO_CONTACT_ID IS NOT NULL THEN
490: l_attr:=l_attr||' 4';

Line 545: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

541: l_attr:=l_attr||' 1';
542: g_record.SOLD_TO_CONTACT_ID := ONT_D1_SOLD_TO_CONTACT_ID.Get_Default_Value(g_record);
543: l_attr:=l_attr||' 2';
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

Line 547: IF NOT OE_GLOBALS.Equal(g_record.sold_to_contact_id, p_in_old_rec.sold_to_contact_id) THEN

543: l_attr:=l_attr||' 2';
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;

Line 552: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
553: END IF;
554: END IF;
555: IF g_record.SOLD_TO_CONTACT_ID IS NOT NULL THEN
556: l_attr:=l_attr||' 4';

Line 593: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

589: l_attr:=l_attr||' 1';
590: g_record.CONVERSION_RATE_DATE := ONT_D1_CONVERSION_RATE_DATE.Get_Default_Value(g_record);
591: l_attr:=l_attr||' 2';
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

Line 595: IF NOT OE_GLOBALS.Equal(g_record.conversion_rate_date, p_in_old_rec.conversion_rate_date) THEN

591: l_attr:=l_attr||' 2';
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;

Line 600: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
601: END IF;
602: END IF;
603: IF g_record.CONVERSION_RATE_DATE IS NOT NULL THEN
604: l_attr:=l_attr||' 4';

Line 624: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

620: l_attr:=l_attr||' 1';
621: g_record.CONVERSION_TYPE_CODE := ONT_D1_CONVERSION_TYPE_CODE.Get_Default_Value(g_record);
622: l_attr:=l_attr||' 2';
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

Line 626: IF NOT OE_GLOBALS.Equal(g_record.conversion_type_code, p_in_old_rec.conversion_type_code) THEN

622: l_attr:=l_attr||' 2';
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;

Line 631: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
632: END IF;
633: END IF;
634: IF g_record.CONVERSION_TYPE_CODE IS NOT NULL THEN
635: l_attr:=l_attr||' 4';

Line 699: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

695: l_attr:=l_attr||' 1';
696: g_record.TRANSACTIONAL_CURR_CODE := ONT_D1_TRANSACTIONAL_CURR_C.Get_Default_Value(g_record);
697: l_attr:=l_attr||' 2';
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

Line 701: IF NOT OE_GLOBALS.Equal(g_record.transactional_curr_code, p_in_old_rec.transactional_curr_code) THEN

697: l_attr:=l_attr||' 2';
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;

Line 706: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
707: END IF;
708: END IF;
709: IF g_record.TRANSACTIONAL_CURR_CODE IS NOT NULL THEN
710: l_attr:=l_attr||' 4';

Line 730: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

726: l_attr:=l_attr||' 1';
727: g_record.IB_CURRENT_LOCATION := ONT_D1_IB_CURRENT_LOCATION.Get_Default_Value(g_record);
728: l_attr:=l_attr||' 2';
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

Line 732: IF NOT OE_GLOBALS.Equal(g_record.ib_current_location, p_in_old_rec.ib_current_location) THEN

728: l_attr:=l_attr||' 2';
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;

Line 737: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
738: END IF;
739: END IF;
740: IF g_record.IB_CURRENT_LOCATION IS NOT NULL THEN
741: l_attr:=l_attr||' 4';

Line 754: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

750: l_attr:=l_attr||' 1';
751: g_record.SOLD_TO_SITE_USE_ID := ONT_D1_SOLD_TO_SITE_USE_ID.Get_Default_Value(g_record);
752: l_attr:=l_attr||' 2';
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

Line 756: IF NOT OE_GLOBALS.Equal(g_record.sold_to_site_use_id, p_in_old_rec.sold_to_site_use_id) THEN

752: l_attr:=l_attr||' 2';
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;

Line 761: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
762: END IF;
763: END IF;
764: -- There is no validation api registered in the AK dictionary
765: END IF;

Line 778: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

774: AND p_in_old_rec.CUST_PO_NUMBER <> FND_API.G_MISS_CHAR THEN
775: g_record.CUST_PO_NUMBER := p_in_old_rec.CUST_PO_NUMBER;
776: END IF;
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

Line 780: IF NOT OE_GLOBALS.Equal(g_record.cust_po_number, p_in_old_rec.cust_po_number) THEN

776: END IF;
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;

Line 785: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
786: END IF;
787: END IF;
788: IF g_record.CUST_PO_NUMBER IS NOT NULL THEN
789: l_attr:=l_attr||' 4';

Line 839: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

835: l_attr:=l_attr||' 1';
836: g_record.DELIVER_TO_CONTACT_ID := ONT_D1_DELIVER_TO_CONTACT_I.Get_Default_Value(g_record);
837: l_attr:=l_attr||' 2';
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

Line 841: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_contact_id, p_in_old_rec.deliver_to_contact_id) THEN

837: l_attr:=l_attr||' 2';
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;

Line 846: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
847: END IF;
848: END IF;
849: IF g_record.DELIVER_TO_CONTACT_ID IS NOT NULL THEN
850: l_attr:=l_attr||' 4';

Line 869: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

865: l_attr:=l_attr||' 1';
866: g_record.DEMAND_CLASS_CODE := ONT_D1_DEMAND_CLASS_CODE.Get_Default_Value(g_record);
867: l_attr:=l_attr||' 2';
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

Line 871: IF NOT OE_GLOBALS.Equal(g_record.demand_class_code, p_in_old_rec.demand_class_code) THEN

867: l_attr:=l_attr||' 2';
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;

Line 876: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
877: END IF;
878: END IF;
879: IF g_record.DEMAND_CLASS_CODE IS NOT NULL THEN
880: l_attr:=l_attr||' 4';

Line 927: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

923: l_attr:=l_attr||' 1';
924: g_record.END_CUSTOMER_ID := ONT_D1_END_CUSTOMER_ID.Get_Default_Value(g_record);
925: l_attr:=l_attr||' 2';
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

Line 929: IF NOT OE_GLOBALS.Equal(g_record.end_customer_id, p_in_old_rec.end_customer_id) THEN

925: l_attr:=l_attr||' 2';
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;

Line 934: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
935: END IF;
936: END IF;
937: IF g_record.END_CUSTOMER_ID IS NOT NULL THEN
938: l_attr:=l_attr||' 4';

Line 951: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

947: l_attr:=l_attr||' 1';
948: g_record.END_CUSTOMER_CONTACT_ID := ONT_D1_END_CUSTOMER_CONTACT.Get_Default_Value(g_record);
949: l_attr:=l_attr||' 2';
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

Line 953: IF NOT OE_GLOBALS.Equal(g_record.end_customer_contact_id, p_in_old_rec.end_customer_contact_id) THEN

949: l_attr:=l_attr||' 2';
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;

Line 958: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
959: END IF;
960: END IF;
961: IF g_record.END_CUSTOMER_CONTACT_ID IS NOT NULL THEN
962: l_attr:=l_attr||' 4';

Line 975: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

971: l_attr:=l_attr||' 1';
972: g_record.END_CUSTOMER_SITE_USE_ID := ONT_D1_END_CUSTOMER_SITE_US.Get_Default_Value(g_record);
973: l_attr:=l_attr||' 2';
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

Line 977: IF NOT OE_GLOBALS.Equal(g_record.end_customer_site_use_id, p_in_old_rec.end_customer_site_use_id) THEN

973: l_attr:=l_attr||' 2';
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;

Line 982: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
983: END IF;
984: END IF;
985: IF g_record.END_CUSTOMER_SITE_USE_ID IS NOT NULL THEN
986: l_attr:=l_attr||' 4';

Line 999: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

995: l_attr:=l_attr||' 1';
996: g_record.EXPIRATION_DATE := ONT_D1_EXPIRATION_DATE.Get_Default_Value(g_record);
997: l_attr:=l_attr||' 2';
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

Line 1001: IF NOT OE_GLOBALS.Equal(g_record.expiration_date, p_in_old_rec.expiration_date) THEN

997: l_attr:=l_attr||' 2';
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;

Line 1006: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1007: END IF;
1008: END IF;
1009: IF g_record.EXPIRATION_DATE IS NOT NULL THEN
1010: l_attr:=l_attr||' 4';

Line 1029: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1025: l_attr:=l_attr||' 1';
1026: g_record.FOB_POINT_CODE := ONT_D1_FOB_POINT_CODE.Get_Default_Value(g_record);
1027: l_attr:=l_attr||' 2';
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

Line 1031: IF NOT OE_GLOBALS.Equal(g_record.fob_point_code, p_in_old_rec.fob_point_code) THEN

1027: l_attr:=l_attr||' 2';
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;

Line 1036: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1037: END IF;
1038: END IF;
1039: IF g_record.FOB_POINT_CODE IS NOT NULL THEN
1040: l_attr:=l_attr||' 4';

Line 1078: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1074: l_attr:=l_attr||' 1';
1075: g_record.FREIGHT_TERMS_CODE := ONT_D1_FREIGHT_TERMS_CODE.Get_Default_Value(g_record);
1076: l_attr:=l_attr||' 2';
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

Line 1080: IF NOT OE_GLOBALS.Equal(g_record.freight_terms_code, p_in_old_rec.freight_terms_code) THEN

1076: l_attr:=l_attr||' 2';
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;

Line 1085: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1086: END IF;
1087: END IF;
1088: IF g_record.FREIGHT_TERMS_CODE IS NOT NULL THEN
1089: l_attr:=l_attr||' 4';

Line 1261: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1257: l_attr:=l_attr||' 1';
1258: g_record.IB_INSTALLED_AT_LOCATION := ONT_D1_IB_INSTALLED_AT_LOCA.Get_Default_Value(g_record);
1259: l_attr:=l_attr||' 2';
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

Line 1263: IF NOT OE_GLOBALS.Equal(g_record.ib_installed_at_location, p_in_old_rec.ib_installed_at_location) THEN

1259: l_attr:=l_attr||' 2';
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;

Line 1268: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1269: END IF;
1270: END IF;
1271: IF g_record.IB_INSTALLED_AT_LOCATION IS NOT NULL THEN
1272: l_attr:=l_attr||' 4';

Line 1285: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1281: l_attr:=l_attr||' 1';
1282: g_record.INVOICING_RULE_ID := ONT_D1_INVOICING_RULE_ID.Get_Default_Value(g_record);
1283: l_attr:=l_attr||' 2';
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

Line 1287: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN

1283: l_attr:=l_attr||' 2';
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;

Line 1292: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1293: END IF;
1294: END IF;
1295: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1296: l_attr:=l_attr||' 4';

Line 1458: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1454: AND p_in_old_rec.ORDER_TYPE_ID <> FND_API.G_MISS_NUM THEN
1455: g_record.ORDER_TYPE_ID := p_in_old_rec.ORDER_TYPE_ID;
1456: END IF;
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

Line 1460: IF NOT OE_GLOBALS.Equal(g_record.order_type_id, p_in_old_rec.order_type_id) THEN

1456: END IF;
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;

Line 1465: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1466: END IF;
1467: END IF;
1468: IF g_record.ORDER_TYPE_ID IS NOT NULL THEN
1469: l_attr:=l_attr||' 4';

Line 1488: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1484: l_attr:=l_attr||' 1';
1485: g_record.ORDERED_DATE := ONT_D1_ORDERED_DATE.Get_Default_Value(g_record);
1486: l_attr:=l_attr||' 2';
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

Line 1490: IF NOT OE_GLOBALS.Equal(g_record.ordered_date, p_in_old_rec.ordered_date) THEN

1486: l_attr:=l_attr||' 2';
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;

Line 1495: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1496: END IF;
1497: END IF;
1498: IF g_record.ORDERED_DATE IS NOT NULL THEN
1499: l_attr:=l_attr||' 4';

Line 1531: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1527: l_attr:=l_attr||' 1';
1528: g_record.IB_OWNER := ONT_D1_IB_OWNER.Get_Default_Value(g_record);
1529: l_attr:=l_attr||' 2';
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

Line 1533: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN

1529: l_attr:=l_attr||' 2';
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;

Line 1538: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1539: END IF;
1540: END IF;
1541: IF g_record.IB_OWNER IS NOT NULL THEN
1542: l_attr:=l_attr||' 4';

Line 1594: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1590: l_attr:=l_attr||' 1';
1591: g_record.PAYMENT_TERM_ID := ONT_D1_PAYMENT_TERM_ID.Get_Default_Value(g_record);
1592: l_attr:=l_attr||' 2';
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

Line 1596: IF NOT OE_GLOBALS.Equal(g_record.payment_term_id, p_in_old_rec.payment_term_id) THEN

1592: l_attr:=l_attr||' 2';
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;

Line 1601: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1602: END IF;
1603: END IF;
1604: IF g_record.PAYMENT_TERM_ID IS NOT NULL THEN
1605: l_attr:=l_attr||' 4';

Line 1625: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1621: l_attr:=l_attr||' 1';
1622: g_record.PRICING_DATE := ONT_D1_PRICING_DATE.Get_Default_Value(g_record);
1623: l_attr:=l_attr||' 2';
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

Line 1627: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN

1623: l_attr:=l_attr||' 2';
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;

Line 1632: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1633: END IF;
1634: END IF;
1635: IF g_record.PRICING_DATE IS NOT NULL THEN
1636: l_attr:=l_attr||' 4';

Line 1674: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1670: l_attr:=l_attr||' 1';
1671: g_record.QUOTE_DATE := ONT_D1_QUOTE_DATE.Get_Default_Value(g_record);
1672: l_attr:=l_attr||' 2';
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

Line 1676: IF NOT OE_GLOBALS.Equal(g_record.quote_date, p_in_old_rec.quote_date) THEN

1672: l_attr:=l_attr||' 2';
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;

Line 1681: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1682: END IF;
1683: END IF;
1684: -- There is no validation api registered in the AK dictionary
1685: END IF;

Line 1718: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1714: l_attr:=l_attr||' 1';
1715: g_record.BLANKET_NUMBER := ONT_D1_BLANKET_NUMBER.Get_Default_Value(g_record);
1716: l_attr:=l_attr||' 2';
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

Line 1720: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN

1716: l_attr:=l_attr||' 2';
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;

Line 1725: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1726: END IF;
1727: END IF;
1728: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
1729: l_attr:=l_attr||' 4';

Line 1748: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1744: l_attr:=l_attr||' 1';
1745: g_record.SALES_CHANNEL_CODE := ONT_D1_SALES_CHANNEL_CODE.Get_Default_Value(g_record);
1746: l_attr:=l_attr||' 2';
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

Line 1750: IF NOT OE_GLOBALS.Equal(g_record.sales_channel_code, p_in_old_rec.sales_channel_code) THEN

1746: l_attr:=l_attr||' 2';
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;

Line 1755: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1756: END IF;
1757: END IF;
1758: IF g_record.SALES_CHANNEL_CODE IS NOT NULL THEN
1759: l_attr:=l_attr||' 4';

Line 1783: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1779: AND p_in_old_rec.SALESREP_ID <> FND_API.G_MISS_NUM THEN
1780: g_record.SALESREP_ID := p_in_old_rec.SALESREP_ID;
1781: END IF;
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

Line 1785: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN

1781: END IF;
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;

Line 1790: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1791: END IF;
1792: END IF;
1793: IF g_record.SALESREP_ID IS NOT NULL THEN
1794: l_attr:=l_attr||' 4';

Line 1820: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1816: l_attr:=l_attr||' 1';
1817: g_record.SHIP_TO_CONTACT_ID := ONT_D1_SHIP_TO_CONTACT_ID.Get_Default_Value(g_record);
1818: l_attr:=l_attr||' 2';
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

Line 1822: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN

1818: l_attr:=l_attr||' 2';
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;

Line 1827: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1828: END IF;
1829: END IF;
1830: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
1831: l_attr:=l_attr||' 4';

Line 1850: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1846: l_attr:=l_attr||' 1';
1847: g_record.SHIP_TOLERANCE_ABOVE := ONT_D1_SHIP_TOLERANCE_ABOVE.Get_Default_Value(g_record);
1848: l_attr:=l_attr||' 2';
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

Line 1852: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN

1848: l_attr:=l_attr||' 2';
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;

Line 1857: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1858: END IF;
1859: END IF;
1860: IF g_record.SHIP_TOLERANCE_ABOVE IS NOT NULL THEN
1861: l_attr:=l_attr||' 4';

Line 1881: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1877: l_attr:=l_attr||' 1';
1878: g_record.SHIP_TOLERANCE_BELOW := ONT_D1_SHIP_TOLERANCE_BELOW.Get_Default_Value(g_record);
1879: l_attr:=l_attr||' 2';
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

Line 1883: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN

1879: l_attr:=l_attr||' 2';
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;

Line 1888: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1889: END IF;
1890: END IF;
1891: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
1892: l_attr:=l_attr||' 4';

Line 1912: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1908: l_attr:=l_attr||' 1';
1909: g_record.SHIPMENT_PRIORITY_CODE := ONT_D1_SHIPMENT_PRIORITY_CO.Get_Default_Value(g_record);
1910: l_attr:=l_attr||' 2';
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

Line 1914: IF NOT OE_GLOBALS.Equal(g_record.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN

1910: l_attr:=l_attr||' 2';
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;

Line 1919: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
1920: END IF;
1921: END IF;
1922: IF g_record.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
1923: l_attr:=l_attr||' 4';

Line 2021: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2017: l_attr:=l_attr||' 1';
2018: g_record.TAX_EXEMPT_FLAG := ONT_D1_TAX_EXEMPT_FLAG.Get_Default_Value(g_record);
2019: l_attr:=l_attr||' 2';
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

Line 2023: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_flag, p_in_old_rec.tax_exempt_flag) THEN

2019: l_attr:=l_attr||' 2';
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;

Line 2028: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
2029: END IF;
2030: END IF;
2031: IF g_record.TAX_EXEMPT_FLAG IS NOT NULL THEN
2032: l_attr:=l_attr||' 4';

Line 2051: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2047: l_attr:=l_attr||' 1';
2048: g_record.TAX_EXEMPT_NUMBER := ONT_D1_TAX_EXEMPT_NUMBER.Get_Default_Value(g_record);
2049: l_attr:=l_attr||' 2';
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

Line 2053: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN

2049: l_attr:=l_attr||' 2';
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;

Line 2058: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
2059: END IF;
2060: END IF;
2061: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
2062: l_attr:=l_attr||' 4';

Line 2082: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2078: l_attr:=l_attr||' 1';
2079: g_record.TAX_EXEMPT_REASON_CODE := ONT_D1_TAX_EXEMPT_REASON_CO.Get_Default_Value(g_record);
2080: l_attr:=l_attr||' 2';
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

Line 2084: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_reason_code, p_in_old_rec.tax_exempt_reason_code) THEN

2080: l_attr:=l_attr||' 2';
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;

Line 2089: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
2090: END IF;
2091: END IF;
2092: IF g_record.TAX_EXEMPT_REASON_CODE IS NOT NULL THEN
2093: l_attr:=l_attr||' 4';

Line 2123: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2119: AND p_in_old_rec.TRANSACTION_PHASE_CODE <> FND_API.G_MISS_CHAR THEN
2120: g_record.TRANSACTION_PHASE_CODE := p_in_old_rec.TRANSACTION_PHASE_CODE;
2121: END IF;
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

Line 2125: IF NOT OE_GLOBALS.Equal(g_record.transaction_phase_code, p_in_old_rec.transaction_phase_code) THEN

2121: END IF;
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;

Line 2130: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
2131: END IF;
2132: END IF;
2133: IF g_record.TRANSACTION_PHASE_CODE IS NOT NULL THEN
2134: l_attr:=l_attr||' 4';

Line 2171: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2167: l_attr:=l_attr||' 1';
2168: g_record.SHIP_FROM_ORG_ID := ONT_D1_SHIP_FROM_ORG_ID.Get_Default_Value(g_record);
2169: l_attr:=l_attr||' 2';
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

Line 2173: IF NOT OE_GLOBALS.Equal(g_record.ship_from_org_id, p_in_old_rec.ship_from_org_id) THEN

2169: l_attr:=l_attr||' 2';
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;

Line 2178: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

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';
2179: END IF;
2180: END IF;
2181: IF g_record.SHIP_FROM_ORG_ID IS NOT NULL THEN
2182: l_attr:=l_attr||' 4';