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

APPS.ONT_LINE_DEF_HDLR dependencies on OE_GLOBALS

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

60: l_attr:=l_attr||' 1';
61: g_record.LINE_TYPE_ID := ONT_D2_LINE_TYPE_ID.Get_Default_Value(g_record);
62: l_attr:=l_attr||' 2';
63: -- For UPDATE operations, check security if new defaulted value is not equal to old value
64: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
65: l_attr:=l_attr||' 3';
66: IF NOT OE_GLOBALS.Equal(g_record.line_type_id, p_in_old_rec.line_type_id) THEN
67: IF OE_LINE_SECURITY.LINE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
68: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 66: IF NOT OE_GLOBALS.Equal(g_record.line_type_id, p_in_old_rec.line_type_id) THEN

62: l_attr:=l_attr||' 2';
63: -- For UPDATE operations, check security if new defaulted value is not equal to old value
64: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
65: l_attr:=l_attr||' 3';
66: IF NOT OE_GLOBALS.Equal(g_record.line_type_id, p_in_old_rec.line_type_id) THEN
67: IF OE_LINE_SECURITY.LINE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
68: -- Raise error if security returns YES, operation IS CONSTRAINED
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;

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

67: IF OE_LINE_SECURITY.LINE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
68: -- Raise error if security returns YES, operation IS CONSTRAINED
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
72: END IF;
73: END IF;
74: IF g_record.LINE_TYPE_ID IS NOT NULL THEN
75: l_attr:=l_attr||' 4';

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

90: l_attr:=l_attr||' 1';
91: g_record.AGREEMENT_ID := ONT_D2_AGREEMENT_ID.Get_Default_Value(g_record);
92: l_attr:=l_attr||' 2';
93: -- For UPDATE operations, check security if new defaulted value is not equal to old value
94: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
95: l_attr:=l_attr||' 3';
96: IF NOT OE_GLOBALS.Equal(g_record.agreement_id, p_in_old_rec.agreement_id) THEN
97: IF OE_LINE_SECURITY.AGREEMENT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
98: -- Raise error if security returns YES, operation IS CONSTRAINED

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

92: l_attr:=l_attr||' 2';
93: -- For UPDATE operations, check security if new defaulted value is not equal to old value
94: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
95: l_attr:=l_attr||' 3';
96: IF NOT OE_GLOBALS.Equal(g_record.agreement_id, p_in_old_rec.agreement_id) THEN
97: IF OE_LINE_SECURITY.AGREEMENT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
98: -- Raise error if security returns YES, operation IS CONSTRAINED
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;

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

97: IF OE_LINE_SECURITY.AGREEMENT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
98: -- Raise error if security returns YES, operation IS CONSTRAINED
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
102: END IF;
103: END IF;
104: IF g_record.AGREEMENT_ID IS NOT NULL THEN
105: l_attr:=l_attr||' 4';

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

124: AND p_in_old_rec.SOLD_TO_ORG_ID <> FND_API.G_MISS_NUM THEN
125: g_record.SOLD_TO_ORG_ID := p_in_old_rec.SOLD_TO_ORG_ID;
126: END IF;
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.sold_to_org_id, p_in_old_rec.sold_to_org_id) THEN
131: IF OE_LINE_SECURITY.SOLD_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.sold_to_org_id, p_in_old_rec.sold_to_org_id) THEN

126: END IF;
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.sold_to_org_id, p_in_old_rec.sold_to_org_id) THEN
131: IF OE_LINE_SECURITY.SOLD_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_LINE_SECURITY.SOLD_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.SOLD_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.SHIP_TO_ORG_ID := ONT_D2_SHIP_TO_ORG_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.ship_to_org_id, p_in_old_rec.ship_to_org_id) THEN
161: IF OE_LINE_SECURITY.SHIP_TO_ORG(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.ship_to_org_id, p_in_old_rec.ship_to_org_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.ship_to_org_id, p_in_old_rec.ship_to_org_id) THEN
161: IF OE_LINE_SECURITY.SHIP_TO_ORG(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_LINE_SECURITY.SHIP_TO_ORG(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.SHIP_TO_ORG_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_D2_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_LINE_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_LINE_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_LINE_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 218: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

214: l_attr:=l_attr||' 1';
215: g_record.DELIVER_TO_ORG_ID := ONT_D2_DELIVER_TO_ORG_ID.Get_Default_Value(g_record);
216: l_attr:=l_attr||' 2';
217: -- For UPDATE operations, check security if new defaulted value is not equal to old value
218: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
219: l_attr:=l_attr||' 3';
220: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_org_id, p_in_old_rec.deliver_to_org_id) THEN
221: IF OE_LINE_SECURITY.DELIVER_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
222: -- Raise error if security returns YES, operation IS CONSTRAINED

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

216: l_attr:=l_attr||' 2';
217: -- For UPDATE operations, check security if new defaulted value is not equal to old value
218: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
219: l_attr:=l_attr||' 3';
220: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_org_id, p_in_old_rec.deliver_to_org_id) THEN
221: IF OE_LINE_SECURITY.DELIVER_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
222: -- Raise error if security returns YES, operation IS CONSTRAINED
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;

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

221: IF OE_LINE_SECURITY.DELIVER_TO_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
222: -- Raise error if security returns YES, operation IS CONSTRAINED
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
226: END IF;
227: END IF;
228: IF g_record.DELIVER_TO_ORG_ID IS NOT NULL THEN
229: l_attr:=l_attr||' 4';

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

244: l_attr:=l_attr||' 1';
245: g_record.REQUEST_DATE := ONT_D2_REQUEST_DATE.Get_Default_Value(g_record);
246: l_attr:=l_attr||' 2';
247: -- For UPDATE operations, check security if new defaulted value is not equal to old value
248: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
249: l_attr:=l_attr||' 3';
250: IF NOT OE_GLOBALS.Equal(g_record.request_date, p_in_old_rec.request_date) THEN
251: IF OE_LINE_SECURITY.REQUEST_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
252: -- Raise error if security returns YES, operation IS CONSTRAINED

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

246: l_attr:=l_attr||' 2';
247: -- For UPDATE operations, check security if new defaulted value is not equal to old value
248: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
249: l_attr:=l_attr||' 3';
250: IF NOT OE_GLOBALS.Equal(g_record.request_date, p_in_old_rec.request_date) THEN
251: IF OE_LINE_SECURITY.REQUEST_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
252: -- Raise error if security returns YES, operation IS CONSTRAINED
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;

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

251: IF OE_LINE_SECURITY.REQUEST_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
252: -- Raise error if security returns YES, operation IS CONSTRAINED
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
256: END IF;
257: END IF;
258: IF g_record.REQUEST_DATE IS NOT NULL THEN
259: l_attr:=l_attr||' 4';

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

295: l_attr:=l_attr||' 1';
296: g_record.PROMISE_DATE := ONT_D2_PROMISE_DATE.Get_Default_Value(g_record);
297: l_attr:=l_attr||' 2';
298: -- For UPDATE operations, check security if new defaulted value is not equal to old value
299: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
300: l_attr:=l_attr||' 3';
301: IF NOT OE_GLOBALS.Equal(g_record.promise_date, p_in_old_rec.promise_date) THEN
302: IF OE_LINE_SECURITY.PROMISE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
303: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 301: IF NOT OE_GLOBALS.Equal(g_record.promise_date, p_in_old_rec.promise_date) THEN

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

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

302: IF OE_LINE_SECURITY.PROMISE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
303: -- Raise error if security returns YES, operation IS CONSTRAINED
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
307: END IF;
308: END IF;
309: IF g_record.PROMISE_DATE IS NOT NULL THEN
310: 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.TAX_DATE := ONT_D2_TAX_DATE.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.tax_date, p_in_old_rec.tax_date) THEN
332: IF OE_LINE_SECURITY.TAX_DATE(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.tax_date, p_in_old_rec.tax_date) 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.tax_date, p_in_old_rec.tax_date) THEN
332: IF OE_LINE_SECURITY.TAX_DATE(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_LINE_SECURITY.TAX_DATE(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.TAX_DATE IS NOT NULL THEN
340: l_attr:=l_attr||' 4';

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

355: l_attr:=l_attr||' 1';
356: g_record.TAX_CODE := ONT_D2_TAX_CODE.Get_Default_Value(g_record);
357: l_attr:=l_attr||' 2';
358: -- For UPDATE operations, check security if new defaulted value is not equal to old value
359: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
360: l_attr:=l_attr||' 3';
361: IF NOT OE_GLOBALS.Equal(g_record.tax_code, p_in_old_rec.tax_code) THEN
362: IF OE_LINE_SECURITY.TAX(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
363: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 361: IF NOT OE_GLOBALS.Equal(g_record.tax_code, p_in_old_rec.tax_code) THEN

357: l_attr:=l_attr||' 2';
358: -- For UPDATE operations, check security if new defaulted value is not equal to old value
359: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
360: l_attr:=l_attr||' 3';
361: IF NOT OE_GLOBALS.Equal(g_record.tax_code, p_in_old_rec.tax_code) THEN
362: IF OE_LINE_SECURITY.TAX(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
363: -- Raise error if security returns YES, operation IS CONSTRAINED
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;

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

362: IF OE_LINE_SECURITY.TAX(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
363: -- Raise error if security returns YES, operation IS CONSTRAINED
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
367: END IF;
368: END IF;
369: IF g_record.TAX_CODE IS NOT NULL THEN
370: l_attr:=l_attr||' 4';

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

385: l_attr:=l_attr||' 1';
386: g_record.TAX_EXEMPT_FLAG := ONT_D2_TAX_EXEMPT_FLAG.Get_Default_Value(g_record);
387: l_attr:=l_attr||' 2';
388: -- For UPDATE operations, check security if new defaulted value is not equal to old value
389: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
390: l_attr:=l_attr||' 3';
391: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_flag, p_in_old_rec.tax_exempt_flag) THEN
392: IF OE_LINE_SECURITY.TAX_EXEMPT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
393: -- Raise error if security returns YES, operation IS CONSTRAINED

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

387: l_attr:=l_attr||' 2';
388: -- For UPDATE operations, check security if new defaulted value is not equal to old value
389: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
390: l_attr:=l_attr||' 3';
391: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_flag, p_in_old_rec.tax_exempt_flag) THEN
392: IF OE_LINE_SECURITY.TAX_EXEMPT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
393: -- Raise error if security returns YES, operation IS CONSTRAINED
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;

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

392: IF OE_LINE_SECURITY.TAX_EXEMPT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
393: -- Raise error if security returns YES, operation IS CONSTRAINED
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
397: END IF;
398: END IF;
399: IF g_record.TAX_EXEMPT_FLAG IS NOT NULL THEN
400: l_attr:=l_attr||' 4';

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

415: l_attr:=l_attr||' 1';
416: g_record.SHIP_FROM_ORG_ID := ONT_D2_SHIP_FROM_ORG_ID.Get_Default_Value(g_record);
417: l_attr:=l_attr||' 2';
418: -- For UPDATE operations, check security if new defaulted value is not equal to old value
419: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
420: l_attr:=l_attr||' 3';
421: IF NOT OE_GLOBALS.Equal(g_record.ship_from_org_id, p_in_old_rec.ship_from_org_id) THEN
422: IF OE_LINE_SECURITY.SHIP_FROM_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
423: -- Raise error if security returns YES, operation IS CONSTRAINED

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

417: l_attr:=l_attr||' 2';
418: -- For UPDATE operations, check security if new defaulted value is not equal to old value
419: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
420: l_attr:=l_attr||' 3';
421: IF NOT OE_GLOBALS.Equal(g_record.ship_from_org_id, p_in_old_rec.ship_from_org_id) THEN
422: IF OE_LINE_SECURITY.SHIP_FROM_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
423: -- Raise error if security returns YES, operation IS CONSTRAINED
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;

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

422: IF OE_LINE_SECURITY.SHIP_FROM_ORG(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
423: -- Raise error if security returns YES, operation IS CONSTRAINED
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
427: END IF;
428: END IF;
429: IF g_record.SHIP_FROM_ORG_ID IS NOT NULL THEN
430: l_attr:=l_attr||' 4';

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

451: l_attr:=l_attr||' 1';
452: g_record.ACCOUNTING_RULE_ID := ONT_D2_ACCOUNTING_RULE_ID.Get_Default_Value(g_record);
453: l_attr:=l_attr||' 2';
454: -- For UPDATE operations, check security if new defaulted value is not equal to old value
455: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
456: l_attr:=l_attr||' 3';
457: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_id, p_in_old_rec.accounting_rule_id) THEN
458: IF OE_LINE_SECURITY.ACCOUNTING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
459: -- Raise error if security returns YES, operation IS CONSTRAINED

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

453: l_attr:=l_attr||' 2';
454: -- For UPDATE operations, check security if new defaulted value is not equal to old value
455: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
456: l_attr:=l_attr||' 3';
457: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_id, p_in_old_rec.accounting_rule_id) THEN
458: IF OE_LINE_SECURITY.ACCOUNTING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
459: -- Raise error if security returns YES, operation IS CONSTRAINED
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;

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

458: IF OE_LINE_SECURITY.ACCOUNTING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
459: -- Raise error if security returns YES, operation IS CONSTRAINED
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
463: END IF;
464: END IF;
465: IF g_record.ACCOUNTING_RULE_ID IS NOT NULL THEN
466: l_attr:=l_attr||' 4';

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

482: l_attr:=l_attr||' 1';
483: g_record.ACCOUNTING_RULE_DURATION := ONT_D2_ACCOUNTING_RULE_DURA.Get_Default_Value(g_record);
484: l_attr:=l_attr||' 2';
485: -- For UPDATE operations, check security if new defaulted value is not equal to old value
486: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
487: l_attr:=l_attr||' 3';
488: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_duration, p_in_old_rec.accounting_rule_duration) THEN
489: IF OE_LINE_SECURITY.ACCOUNTING_RULE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
490: -- Raise error if security returns YES, operation IS CONSTRAINED

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

484: l_attr:=l_attr||' 2';
485: -- For UPDATE operations, check security if new defaulted value is not equal to old value
486: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
487: l_attr:=l_attr||' 3';
488: IF NOT OE_GLOBALS.Equal(g_record.accounting_rule_duration, p_in_old_rec.accounting_rule_duration) THEN
489: IF OE_LINE_SECURITY.ACCOUNTING_RULE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
490: -- Raise error if security returns YES, operation IS CONSTRAINED
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

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

489: IF OE_LINE_SECURITY.ACCOUNTING_RULE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
490: -- Raise error if security returns YES, operation IS CONSTRAINED
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
494: END IF;
495: END IF;
496: IF g_record.ACCOUNTING_RULE_DURATION IS NOT NULL THEN
497: l_attr:=l_attr||' 4';

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

674: l_attr:=l_attr||' 1';
675: g_record.INVOICE_TO_CONTACT_ID := ONT_D2_INVOICE_TO_CONTACT_I.Get_Default_Value(g_record);
676: l_attr:=l_attr||' 2';
677: -- For UPDATE operations, check security if new defaulted value is not equal to old value
678: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
679: l_attr:=l_attr||' 3';
680: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_contact_id, p_in_old_rec.invoice_to_contact_id) THEN
681: IF OE_LINE_SECURITY.INVOICE_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
682: -- Raise error if security returns YES, operation IS CONSTRAINED

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

676: l_attr:=l_attr||' 2';
677: -- For UPDATE operations, check security if new defaulted value is not equal to old value
678: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
679: l_attr:=l_attr||' 3';
680: IF NOT OE_GLOBALS.Equal(g_record.invoice_to_contact_id, p_in_old_rec.invoice_to_contact_id) THEN
681: IF OE_LINE_SECURITY.INVOICE_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
682: -- Raise error if security returns YES, operation IS CONSTRAINED
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;

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

681: IF OE_LINE_SECURITY.INVOICE_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
682: -- Raise error if security returns YES, operation IS CONSTRAINED
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
686: END IF;
687: END IF;
688: IF g_record.INVOICE_TO_CONTACT_ID IS NOT NULL THEN
689: l_attr:=l_attr||' 4';

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

836: l_attr:=l_attr||' 1';
837: g_record.IB_CURRENT_LOCATION := ONT_D2_IB_CURRENT_LOCATION.Get_Default_Value(g_record);
838: l_attr:=l_attr||' 2';
839: -- For UPDATE operations, check security if new defaulted value is not equal to old value
840: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
841: l_attr:=l_attr||' 3';
842: IF NOT OE_GLOBALS.Equal(g_record.ib_current_location, p_in_old_rec.ib_current_location) THEN
843: IF OE_LINE_SECURITY.IB_CURRENT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
844: -- Raise error if security returns YES, operation IS CONSTRAINED

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

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

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

843: IF OE_LINE_SECURITY.IB_CURRENT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
844: -- Raise error if security returns YES, operation IS CONSTRAINED
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
848: END IF;
849: END IF;
850: IF g_record.IB_CURRENT_LOCATION IS NOT NULL THEN
851: l_attr:=l_attr||' 4';

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

882: AND p_in_old_rec.CUST_PO_NUMBER <> FND_API.G_MISS_CHAR THEN
883: g_record.CUST_PO_NUMBER := p_in_old_rec.CUST_PO_NUMBER;
884: END IF;
885: -- For UPDATE operations, check security if new defaulted value is not equal to old value
886: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
887: l_attr:=l_attr||' 3';
888: IF NOT OE_GLOBALS.Equal(g_record.cust_po_number, p_in_old_rec.cust_po_number) THEN
889: IF OE_LINE_SECURITY.CUST_PO_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
890: -- Raise error if security returns YES, operation IS CONSTRAINED

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

884: END IF;
885: -- For UPDATE operations, check security if new defaulted value is not equal to old value
886: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
887: l_attr:=l_attr||' 3';
888: IF NOT OE_GLOBALS.Equal(g_record.cust_po_number, p_in_old_rec.cust_po_number) THEN
889: IF OE_LINE_SECURITY.CUST_PO_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
890: -- Raise error if security returns YES, operation IS CONSTRAINED
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;

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

889: IF OE_LINE_SECURITY.CUST_PO_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
890: -- Raise error if security returns YES, operation IS CONSTRAINED
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
894: END IF;
895: END IF;
896: IF g_record.CUST_PO_NUMBER IS NOT NULL THEN
897: l_attr:=l_attr||' 4';

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

913: l_attr:=l_attr||' 1';
914: g_record.CUSTOMER_LINE_NUMBER := ONT_D2_CUSTOMER_LINE_NUMBER.Get_Default_Value(g_record);
915: l_attr:=l_attr||' 2';
916: -- For UPDATE operations, check security if new defaulted value is not equal to old value
917: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
918: l_attr:=l_attr||' 3';
919: IF NOT OE_GLOBALS.Equal(g_record.customer_line_number, p_in_old_rec.customer_line_number) THEN
920: IF OE_LINE_SECURITY.CUSTOMER_LINE_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
921: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 919: IF NOT OE_GLOBALS.Equal(g_record.customer_line_number, p_in_old_rec.customer_line_number) THEN

915: l_attr:=l_attr||' 2';
916: -- For UPDATE operations, check security if new defaulted value is not equal to old value
917: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
918: l_attr:=l_attr||' 3';
919: IF NOT OE_GLOBALS.Equal(g_record.customer_line_number, p_in_old_rec.customer_line_number) THEN
920: IF OE_LINE_SECURITY.CUSTOMER_LINE_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
921: -- Raise error if security returns YES, operation IS CONSTRAINED
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;

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

920: IF OE_LINE_SECURITY.CUSTOMER_LINE_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
921: -- Raise error if security returns YES, operation IS CONSTRAINED
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
925: END IF;
926: END IF;
927: -- There is no validation api registered in the AK dictionary
928: END IF;

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

978: l_attr:=l_attr||' 1';
979: g_record.DELIVER_TO_CONTACT_ID := ONT_D2_DELIVER_TO_CONTACT_I.Get_Default_Value(g_record);
980: l_attr:=l_attr||' 2';
981: -- For UPDATE operations, check security if new defaulted value is not equal to old value
982: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
983: l_attr:=l_attr||' 3';
984: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_contact_id, p_in_old_rec.deliver_to_contact_id) THEN
985: IF OE_LINE_SECURITY.DELIVER_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
986: -- Raise error if security returns YES, operation IS CONSTRAINED

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

980: l_attr:=l_attr||' 2';
981: -- For UPDATE operations, check security if new defaulted value is not equal to old value
982: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
983: l_attr:=l_attr||' 3';
984: IF NOT OE_GLOBALS.Equal(g_record.deliver_to_contact_id, p_in_old_rec.deliver_to_contact_id) THEN
985: IF OE_LINE_SECURITY.DELIVER_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
986: -- Raise error if security returns YES, operation IS CONSTRAINED
987: RAISE FND_API.G_EXC_ERROR;
988: END IF;

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

985: IF OE_LINE_SECURITY.DELIVER_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
986: -- Raise error if security returns YES, operation IS CONSTRAINED
987: RAISE FND_API.G_EXC_ERROR;
988: END IF;
989: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
990: END IF;
991: END IF;
992: IF g_record.DELIVER_TO_CONTACT_ID IS NOT NULL THEN
993: l_attr:=l_attr||' 4';

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

1020: l_attr:=l_attr||' 1';
1021: g_record.DEMAND_CLASS_CODE := ONT_D2_DEMAND_CLASS_CODE.Get_Default_Value(g_record);
1022: l_attr:=l_attr||' 2';
1023: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1024: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1025: l_attr:=l_attr||' 3';
1026: IF NOT OE_GLOBALS.Equal(g_record.demand_class_code, p_in_old_rec.demand_class_code) THEN
1027: IF OE_LINE_SECURITY.DEMAND_CLASS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1028: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1022: l_attr:=l_attr||' 2';
1023: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1024: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1025: l_attr:=l_attr||' 3';
1026: IF NOT OE_GLOBALS.Equal(g_record.demand_class_code, p_in_old_rec.demand_class_code) THEN
1027: IF OE_LINE_SECURITY.DEMAND_CLASS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1028: -- Raise error if security returns YES, operation IS CONSTRAINED
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;

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

1027: IF OE_LINE_SECURITY.DEMAND_CLASS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1028: -- Raise error if security returns YES, operation IS CONSTRAINED
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1032: END IF;
1033: END IF;
1034: IF g_record.DEMAND_CLASS_CODE IS NOT NULL THEN
1035: l_attr:=l_attr||' 4';

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

1051: l_attr:=l_attr||' 1';
1052: g_record.DEP_PLAN_REQUIRED_FLAG := ONT_D2_DEP_PLAN_REQUIRED_FL.Get_Default_Value(g_record);
1053: l_attr:=l_attr||' 2';
1054: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1055: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1056: l_attr:=l_attr||' 3';
1057: IF NOT OE_GLOBALS.Equal(g_record.dep_plan_required_flag, p_in_old_rec.dep_plan_required_flag) THEN
1058: IF OE_LINE_SECURITY.DEP_PLAN_REQUIRED(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1059: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1057: IF NOT OE_GLOBALS.Equal(g_record.dep_plan_required_flag, p_in_old_rec.dep_plan_required_flag) THEN

1053: l_attr:=l_attr||' 2';
1054: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1055: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1056: l_attr:=l_attr||' 3';
1057: IF NOT OE_GLOBALS.Equal(g_record.dep_plan_required_flag, p_in_old_rec.dep_plan_required_flag) THEN
1058: IF OE_LINE_SECURITY.DEP_PLAN_REQUIRED(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1059: -- Raise error if security returns YES, operation IS CONSTRAINED
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF;

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

1058: IF OE_LINE_SECURITY.DEP_PLAN_REQUIRED(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1059: -- Raise error if security returns YES, operation IS CONSTRAINED
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF;
1062: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1063: END IF;
1064: END IF;
1065: IF g_record.DEP_PLAN_REQUIRED_FLAG IS NOT NULL THEN
1066: l_attr:=l_attr||' 4';

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

1082: l_attr:=l_attr||' 1';
1083: g_record.EARLIEST_ACCEPTABLE_DATE := ONT_D2_EARLIEST_ACCEPTABLE.Get_Default_Value(g_record);
1084: l_attr:=l_attr||' 2';
1085: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1086: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1087: l_attr:=l_attr||' 3';
1088: IF NOT OE_GLOBALS.Equal(g_record.earliest_acceptable_date, p_in_old_rec.earliest_acceptable_date) THEN
1089: IF OE_LINE_SECURITY.EARLIEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1090: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1088: IF NOT OE_GLOBALS.Equal(g_record.earliest_acceptable_date, p_in_old_rec.earliest_acceptable_date) THEN

1084: l_attr:=l_attr||' 2';
1085: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1086: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1087: l_attr:=l_attr||' 3';
1088: IF NOT OE_GLOBALS.Equal(g_record.earliest_acceptable_date, p_in_old_rec.earliest_acceptable_date) THEN
1089: IF OE_LINE_SECURITY.EARLIEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1090: -- Raise error if security returns YES, operation IS CONSTRAINED
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;

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

1089: IF OE_LINE_SECURITY.EARLIEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1090: -- Raise error if security returns YES, operation IS CONSTRAINED
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1094: END IF;
1095: END IF;
1096: IF g_record.EARLIEST_ACCEPTABLE_DATE IS NOT NULL THEN
1097: l_attr:=l_attr||' 4';

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

1113: l_attr:=l_attr||' 1';
1114: g_record.END_CUSTOMER_ID := ONT_D2_END_CUSTOMER_ID.Get_Default_Value(g_record);
1115: l_attr:=l_attr||' 2';
1116: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1117: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1118: l_attr:=l_attr||' 3';
1119: IF NOT OE_GLOBALS.Equal(g_record.end_customer_id, p_in_old_rec.end_customer_id) THEN
1120: IF OE_LINE_SECURITY.END_CUSTOMER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1121: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1115: l_attr:=l_attr||' 2';
1116: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1117: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1118: l_attr:=l_attr||' 3';
1119: IF NOT OE_GLOBALS.Equal(g_record.end_customer_id, p_in_old_rec.end_customer_id) THEN
1120: IF OE_LINE_SECURITY.END_CUSTOMER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1121: -- Raise error if security returns YES, operation IS CONSTRAINED
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;

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

1120: IF OE_LINE_SECURITY.END_CUSTOMER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1121: -- Raise error if security returns YES, operation IS CONSTRAINED
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1125: END IF;
1126: END IF;
1127: IF g_record.END_CUSTOMER_ID IS NOT NULL THEN
1128: l_attr:=l_attr||' 4';

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

1137: l_attr:=l_attr||' 1';
1138: g_record.END_CUSTOMER_CONTACT_ID := ONT_D2_END_CUSTOMER_CONTACT.Get_Default_Value(g_record);
1139: l_attr:=l_attr||' 2';
1140: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1141: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1142: l_attr:=l_attr||' 3';
1143: IF NOT OE_GLOBALS.Equal(g_record.end_customer_contact_id, p_in_old_rec.end_customer_contact_id) THEN
1144: IF OE_LINE_SECURITY.END_CUSTOMER_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1145: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1139: l_attr:=l_attr||' 2';
1140: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1141: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1142: l_attr:=l_attr||' 3';
1143: IF NOT OE_GLOBALS.Equal(g_record.end_customer_contact_id, p_in_old_rec.end_customer_contact_id) THEN
1144: IF OE_LINE_SECURITY.END_CUSTOMER_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1145: -- Raise error if security returns YES, operation IS CONSTRAINED
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;

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

1144: IF OE_LINE_SECURITY.END_CUSTOMER_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1145: -- Raise error if security returns YES, operation IS CONSTRAINED
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1149: END IF;
1150: END IF;
1151: IF g_record.END_CUSTOMER_CONTACT_ID IS NOT NULL THEN
1152: l_attr:=l_attr||' 4';

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

1161: l_attr:=l_attr||' 1';
1162: g_record.END_CUSTOMER_SITE_USE_ID := ONT_D2_END_CUSTOMER_SITE_US.Get_Default_Value(g_record);
1163: l_attr:=l_attr||' 2';
1164: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1165: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1166: l_attr:=l_attr||' 3';
1167: IF NOT OE_GLOBALS.Equal(g_record.end_customer_site_use_id, p_in_old_rec.end_customer_site_use_id) THEN
1168: IF OE_LINE_SECURITY.END_CUSTOMER_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1169: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1163: l_attr:=l_attr||' 2';
1164: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1165: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1166: l_attr:=l_attr||' 3';
1167: IF NOT OE_GLOBALS.Equal(g_record.end_customer_site_use_id, p_in_old_rec.end_customer_site_use_id) THEN
1168: IF OE_LINE_SECURITY.END_CUSTOMER_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1169: -- Raise error if security returns YES, operation IS CONSTRAINED
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;

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

1168: IF OE_LINE_SECURITY.END_CUSTOMER_SITE_USE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1169: -- Raise error if security returns YES, operation IS CONSTRAINED
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1173: END IF;
1174: END IF;
1175: IF g_record.END_CUSTOMER_SITE_USE_ID IS NOT NULL THEN
1176: l_attr:=l_attr||' 4';

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

1212: l_attr:=l_attr||' 1';
1213: g_record.FOB_POINT_CODE := ONT_D2_FOB_POINT_CODE.Get_Default_Value(g_record);
1214: l_attr:=l_attr||' 2';
1215: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1216: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1217: l_attr:=l_attr||' 3';
1218: IF NOT OE_GLOBALS.Equal(g_record.fob_point_code, p_in_old_rec.fob_point_code) THEN
1219: IF OE_LINE_SECURITY.FOB_POINT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1220: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1214: l_attr:=l_attr||' 2';
1215: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1216: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1217: l_attr:=l_attr||' 3';
1218: IF NOT OE_GLOBALS.Equal(g_record.fob_point_code, p_in_old_rec.fob_point_code) THEN
1219: IF OE_LINE_SECURITY.FOB_POINT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1220: -- Raise error if security returns YES, operation IS CONSTRAINED
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;

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

1219: IF OE_LINE_SECURITY.FOB_POINT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1220: -- Raise error if security returns YES, operation IS CONSTRAINED
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1224: END IF;
1225: END IF;
1226: IF g_record.FOB_POINT_CODE IS NOT NULL THEN
1227: l_attr:=l_attr||' 4';

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

1261: l_attr:=l_attr||' 1';
1262: g_record.FREIGHT_TERMS_CODE := ONT_D2_FREIGHT_TERMS_CODE.Get_Default_Value(g_record);
1263: l_attr:=l_attr||' 2';
1264: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1265: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_attr:=l_attr||' 3';
1267: IF NOT OE_GLOBALS.Equal(g_record.freight_terms_code, p_in_old_rec.freight_terms_code) THEN
1268: IF OE_LINE_SECURITY.FREIGHT_TERMS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1269: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1263: l_attr:=l_attr||' 2';
1264: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1265: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_attr:=l_attr||' 3';
1267: IF NOT OE_GLOBALS.Equal(g_record.freight_terms_code, p_in_old_rec.freight_terms_code) THEN
1268: IF OE_LINE_SECURITY.FREIGHT_TERMS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1269: -- Raise error if security returns YES, operation IS CONSTRAINED
1270: RAISE FND_API.G_EXC_ERROR;
1271: END IF;

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

1268: IF OE_LINE_SECURITY.FREIGHT_TERMS(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1269: -- Raise error if security returns YES, operation IS CONSTRAINED
1270: RAISE FND_API.G_EXC_ERROR;
1271: END IF;
1272: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1273: END IF;
1274: END IF;
1275: IF g_record.FREIGHT_TERMS_CODE IS NOT NULL THEN
1276: l_attr:=l_attr||' 4';

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

1644: l_attr:=l_attr||' 1';
1645: g_record.IB_INSTALLED_AT_LOCATION := ONT_D2_IB_INSTALLED_AT_LOCA.Get_Default_Value(g_record);
1646: l_attr:=l_attr||' 2';
1647: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1648: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1649: l_attr:=l_attr||' 3';
1650: IF NOT OE_GLOBALS.Equal(g_record.ib_installed_at_location, p_in_old_rec.ib_installed_at_location) THEN
1651: IF OE_LINE_SECURITY.IB_INSTALLED_AT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1652: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1646: l_attr:=l_attr||' 2';
1647: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1648: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1649: l_attr:=l_attr||' 3';
1650: IF NOT OE_GLOBALS.Equal(g_record.ib_installed_at_location, p_in_old_rec.ib_installed_at_location) THEN
1651: IF OE_LINE_SECURITY.IB_INSTALLED_AT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1652: -- Raise error if security returns YES, operation IS CONSTRAINED
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;

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

1651: IF OE_LINE_SECURITY.IB_INSTALLED_AT_LOCATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1652: -- Raise error if security returns YES, operation IS CONSTRAINED
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1656: END IF;
1657: END IF;
1658: IF g_record.IB_INSTALLED_AT_LOCATION IS NOT NULL THEN
1659: l_attr:=l_attr||' 4';

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

1712: l_attr:=l_attr||' 1';
1713: g_record.INVOICING_RULE_ID := ONT_D2_INVOICING_RULE_ID.Get_Default_Value(g_record);
1714: l_attr:=l_attr||' 2';
1715: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1716: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1717: l_attr:=l_attr||' 3';
1718: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN
1719: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1720: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1714: l_attr:=l_attr||' 2';
1715: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1716: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1717: l_attr:=l_attr||' 3';
1718: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN
1719: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1720: -- Raise error if security returns YES, operation IS CONSTRAINED
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;

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

1719: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1720: -- Raise error if security returns YES, operation IS CONSTRAINED
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1724: END IF;
1725: END IF;
1726: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1727: l_attr:=l_attr||' 4';

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

1753: l_attr:=l_attr||' 1';
1754: g_record.ITEM_REVISION := ONT_D2_ITEM_REVISION.Get_Default_Value(g_record);
1755: l_attr:=l_attr||' 2';
1756: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1757: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1758: l_attr:=l_attr||' 3';
1759: IF NOT OE_GLOBALS.Equal(g_record.item_revision, p_in_old_rec.item_revision) THEN
1760: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1761: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1759: IF NOT OE_GLOBALS.Equal(g_record.item_revision, p_in_old_rec.item_revision) THEN

1755: l_attr:=l_attr||' 2';
1756: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1757: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1758: l_attr:=l_attr||' 3';
1759: IF NOT OE_GLOBALS.Equal(g_record.item_revision, p_in_old_rec.item_revision) THEN
1760: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1761: -- Raise error if security returns YES, operation IS CONSTRAINED
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;

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

1760: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1761: -- Raise error if security returns YES, operation IS CONSTRAINED
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1765: END IF;
1766: END IF;
1767: IF g_record.ITEM_REVISION IS NOT NULL THEN
1768: l_attr:=l_attr||' 4';

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

1820: l_attr:=l_attr||' 1';
1821: g_record.LATEST_ACCEPTABLE_DATE := ONT_D2_LATEST_ACCEPTABLE_DA.Get_Default_Value(g_record);
1822: l_attr:=l_attr||' 2';
1823: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1824: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1825: l_attr:=l_attr||' 3';
1826: IF NOT OE_GLOBALS.Equal(g_record.latest_acceptable_date, p_in_old_rec.latest_acceptable_date) THEN
1827: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1828: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1826: IF NOT OE_GLOBALS.Equal(g_record.latest_acceptable_date, p_in_old_rec.latest_acceptable_date) THEN

1822: l_attr:=l_attr||' 2';
1823: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1824: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1825: l_attr:=l_attr||' 3';
1826: IF NOT OE_GLOBALS.Equal(g_record.latest_acceptable_date, p_in_old_rec.latest_acceptable_date) THEN
1827: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1828: -- Raise error if security returns YES, operation IS CONSTRAINED
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;

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

1827: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1828: -- Raise error if security returns YES, operation IS CONSTRAINED
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1832: END IF;
1833: END IF;
1834: IF g_record.LATEST_ACCEPTABLE_DATE IS NOT NULL THEN
1835: l_attr:=l_attr||' 4';

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

1927: l_attr:=l_attr||' 1';
1928: g_record.ORDER_QUANTITY_UOM := ONT_D2_ORDER_QUANTITY_UOM.Get_Default_Value(g_record);
1929: l_attr:=l_attr||' 2';
1930: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1931: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1932: l_attr:=l_attr||' 3';
1933: IF NOT OE_GLOBALS.Equal(g_record.order_quantity_uom, p_in_old_rec.order_quantity_uom) THEN
1934: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1935: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1933: IF NOT OE_GLOBALS.Equal(g_record.order_quantity_uom, p_in_old_rec.order_quantity_uom) THEN

1929: l_attr:=l_attr||' 2';
1930: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1931: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1932: l_attr:=l_attr||' 3';
1933: IF NOT OE_GLOBALS.Equal(g_record.order_quantity_uom, p_in_old_rec.order_quantity_uom) THEN
1934: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1935: -- Raise error if security returns YES, operation IS CONSTRAINED
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;

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

1934: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1935: -- Raise error if security returns YES, operation IS CONSTRAINED
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1939: END IF;
1940: END IF;
1941: IF g_record.ORDER_QUANTITY_UOM IS NOT NULL THEN
1942: l_attr:=l_attr||' 4';

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

1969: l_attr:=l_attr||' 1';
1970: g_record.ORDERED_QUANTITY := ONT_D2_ORDERED_QUANTITY.Get_Default_Value(g_record);
1971: l_attr:=l_attr||' 2';
1972: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1973: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1974: l_attr:=l_attr||' 3';
1975: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity, p_in_old_rec.ordered_quantity) THEN
1976: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1977: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 1975: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity, p_in_old_rec.ordered_quantity) THEN

1971: l_attr:=l_attr||' 2';
1972: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1973: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1974: l_attr:=l_attr||' 3';
1975: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity, p_in_old_rec.ordered_quantity) THEN
1976: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1977: -- Raise error if security returns YES, operation IS CONSTRAINED
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;

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

1976: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1977: -- Raise error if security returns YES, operation IS CONSTRAINED
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;
1980: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1981: END IF;
1982: END IF;
1983: IF g_record.ORDERED_QUANTITY IS NOT NULL THEN
1984: l_attr:=l_attr||' 4';

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

2029: l_attr:=l_attr||' 1';
2030: g_record.IB_OWNER := ONT_D2_IB_OWNER.Get_Default_Value(g_record);
2031: l_attr:=l_attr||' 2';
2032: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2033: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2034: l_attr:=l_attr||' 3';
2035: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN
2036: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2037: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2031: l_attr:=l_attr||' 2';
2032: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2033: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2034: l_attr:=l_attr||' 3';
2035: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN
2036: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2037: -- Raise error if security returns YES, operation IS CONSTRAINED
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;

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

2036: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2037: -- Raise error if security returns YES, operation IS CONSTRAINED
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2041: END IF;
2042: END IF;
2043: IF g_record.IB_OWNER IS NOT NULL THEN
2044: l_attr:=l_attr||' 4';

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

2080: l_attr:=l_attr||' 1';
2081: g_record.PAYMENT_TERM_ID := ONT_D2_PAYMENT_TERM_ID.Get_Default_Value(g_record);
2082: l_attr:=l_attr||' 2';
2083: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2084: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2085: l_attr:=l_attr||' 3';
2086: IF NOT OE_GLOBALS.Equal(g_record.payment_term_id, p_in_old_rec.payment_term_id) THEN
2087: IF OE_LINE_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2088: -- Raise error if security returns YES, operation IS CONSTRAINED

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

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

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

2087: IF OE_LINE_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2088: -- Raise error if security returns YES, operation IS CONSTRAINED
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2092: END IF;
2093: END IF;
2094: IF g_record.PAYMENT_TERM_ID IS NOT NULL THEN
2095: l_attr:=l_attr||' 4';

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

2121: AND p_in_old_rec.PRICE_LIST_ID <> FND_API.G_MISS_NUM THEN
2122: g_record.PRICE_LIST_ID := p_in_old_rec.PRICE_LIST_ID;
2123: END IF;
2124: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2125: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2126: l_attr:=l_attr||' 3';
2127: IF NOT OE_GLOBALS.Equal(g_record.price_list_id, p_in_old_rec.price_list_id) THEN
2128: IF OE_LINE_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2129: -- Raise error if security returns YES, operation IS CONSTRAINED

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

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

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

2128: IF OE_LINE_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2129: -- Raise error if security returns YES, operation IS CONSTRAINED
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2133: END IF;
2134: END IF;
2135: IF g_record.PRICE_LIST_ID IS NOT NULL THEN
2136: l_attr:=l_attr||' 4';

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

2217: l_attr:=l_attr||' 1';
2218: g_record.PRICING_DATE := ONT_D2_PRICING_DATE.Get_Default_Value(g_record);
2219: l_attr:=l_attr||' 2';
2220: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2221: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2222: l_attr:=l_attr||' 3';
2223: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN
2224: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2225: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2219: l_attr:=l_attr||' 2';
2220: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2221: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2222: l_attr:=l_attr||' 3';
2223: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN
2224: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2225: -- Raise error if security returns YES, operation IS CONSTRAINED
2226: RAISE FND_API.G_EXC_ERROR;
2227: END IF;

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

2224: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2225: -- Raise error if security returns YES, operation IS CONSTRAINED
2226: RAISE FND_API.G_EXC_ERROR;
2227: END IF;
2228: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2229: END IF;
2230: END IF;
2231: IF g_record.PRICING_DATE IS NOT NULL THEN
2232: l_attr:=l_attr||' 4';

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

2422: l_attr:=l_attr||' 1';
2423: g_record.RETURN_REASON_CODE := ONT_D2_RETURN_REASON_CODE.Get_Default_Value(g_record);
2424: l_attr:=l_attr||' 2';
2425: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2426: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2427: l_attr:=l_attr||' 3';
2428: IF NOT OE_GLOBALS.Equal(g_record.return_reason_code, p_in_old_rec.return_reason_code) THEN
2429: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2430: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2428: IF NOT OE_GLOBALS.Equal(g_record.return_reason_code, p_in_old_rec.return_reason_code) THEN

2424: l_attr:=l_attr||' 2';
2425: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2426: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2427: l_attr:=l_attr||' 3';
2428: IF NOT OE_GLOBALS.Equal(g_record.return_reason_code, p_in_old_rec.return_reason_code) THEN
2429: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2430: -- Raise error if security returns YES, operation IS CONSTRAINED
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;

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

2429: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2430: -- Raise error if security returns YES, operation IS CONSTRAINED
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2434: END IF;
2435: END IF;
2436: IF g_record.RETURN_REASON_CODE IS NOT NULL THEN
2437: l_attr:=l_attr||' 4';

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

2483: l_attr:=l_attr||' 1';
2484: g_record.BLANKET_NUMBER := ONT_D2_BLANKET_NUMBER.Get_Default_Value(g_record);
2485: l_attr:=l_attr||' 2';
2486: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2487: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2488: l_attr:=l_attr||' 3';
2489: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN
2490: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2491: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2485: l_attr:=l_attr||' 2';
2486: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2487: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2488: l_attr:=l_attr||' 3';
2489: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN
2490: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2491: -- Raise error if security returns YES, operation IS CONSTRAINED
2492: RAISE FND_API.G_EXC_ERROR;
2493: END IF;

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

2490: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2491: -- Raise error if security returns YES, operation IS CONSTRAINED
2492: RAISE FND_API.G_EXC_ERROR;
2493: END IF;
2494: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2495: END IF;
2496: END IF;
2497: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
2498: l_attr:=l_attr||' 4';

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

2523: AND p_in_old_rec.SALESREP_ID <> FND_API.G_MISS_NUM THEN
2524: g_record.SALESREP_ID := p_in_old_rec.SALESREP_ID;
2525: END IF;
2526: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2527: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2528: l_attr:=l_attr||' 3';
2529: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN
2530: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2531: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2525: END IF;
2526: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2527: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2528: l_attr:=l_attr||' 3';
2529: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN
2530: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2531: -- Raise error if security returns YES, operation IS CONSTRAINED
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;

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

2530: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2531: -- Raise error if security returns YES, operation IS CONSTRAINED
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2535: END IF;
2536: END IF;
2537: IF g_record.SALESREP_ID IS NOT NULL THEN
2538: l_attr:=l_attr||' 4';

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

2560: l_attr:=l_attr||' 1';
2561: g_record.SCHEDULE_ARRIVAL_DATE := ONT_D2_SCHEDULE_ARRIVAL_DAT.Get_Default_Value(g_record);
2562: l_attr:=l_attr||' 2';
2563: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2564: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2565: l_attr:=l_attr||' 3';
2566: IF NOT OE_GLOBALS.Equal(g_record.schedule_arrival_date, p_in_old_rec.schedule_arrival_date) THEN
2567: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2568: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2566: IF NOT OE_GLOBALS.Equal(g_record.schedule_arrival_date, p_in_old_rec.schedule_arrival_date) THEN

2562: l_attr:=l_attr||' 2';
2563: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2564: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2565: l_attr:=l_attr||' 3';
2566: IF NOT OE_GLOBALS.Equal(g_record.schedule_arrival_date, p_in_old_rec.schedule_arrival_date) THEN
2567: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2568: -- Raise error if security returns YES, operation IS CONSTRAINED
2569: RAISE FND_API.G_EXC_ERROR;
2570: END IF;

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

2567: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2568: -- Raise error if security returns YES, operation IS CONSTRAINED
2569: RAISE FND_API.G_EXC_ERROR;
2570: END IF;
2571: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2572: END IF;
2573: END IF;
2574: IF g_record.SCHEDULE_ARRIVAL_DATE IS NOT NULL THEN
2575: l_attr:=l_attr||' 4';

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

2609: l_attr:=l_attr||' 1';
2610: g_record.ORDERED_QUANTITY2 := ONT_D2_ORDERED_QUANTITY2.Get_Default_Value(g_record);
2611: l_attr:=l_attr||' 2';
2612: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2613: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2614: l_attr:=l_attr||' 3';
2615: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity2, p_in_old_rec.ordered_quantity2) THEN
2616: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2617: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2615: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity2, p_in_old_rec.ordered_quantity2) THEN

2611: l_attr:=l_attr||' 2';
2612: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2613: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2614: l_attr:=l_attr||' 3';
2615: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity2, p_in_old_rec.ordered_quantity2) THEN
2616: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2617: -- Raise error if security returns YES, operation IS CONSTRAINED
2618: RAISE FND_API.G_EXC_ERROR;
2619: END IF;

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

2616: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2617: -- Raise error if security returns YES, operation IS CONSTRAINED
2618: RAISE FND_API.G_EXC_ERROR;
2619: END IF;
2620: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2621: END IF;
2622: END IF;
2623: -- There is no validation api registered in the AK dictionary
2624: END IF;

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

2726: l_attr:=l_attr||' 1';
2727: g_record.SERVICE_DURATION := ONT_D2_SERVICE_DURATION.Get_Default_Value(g_record);
2728: l_attr:=l_attr||' 2';
2729: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2730: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2731: l_attr:=l_attr||' 3';
2732: IF NOT OE_GLOBALS.Equal(g_record.service_duration, p_in_old_rec.service_duration) THEN
2733: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2734: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2732: IF NOT OE_GLOBALS.Equal(g_record.service_duration, p_in_old_rec.service_duration) THEN

2728: l_attr:=l_attr||' 2';
2729: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2730: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2731: l_attr:=l_attr||' 3';
2732: IF NOT OE_GLOBALS.Equal(g_record.service_duration, p_in_old_rec.service_duration) THEN
2733: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2734: -- Raise error if security returns YES, operation IS CONSTRAINED
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;

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

2733: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2734: -- Raise error if security returns YES, operation IS CONSTRAINED
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2738: END IF;
2739: END IF;
2740: IF g_record.SERVICE_DURATION IS NOT NULL THEN
2741: l_attr:=l_attr||' 4';

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

2769: l_attr:=l_attr||' 1';
2770: g_record.SERVICE_PERIOD := ONT_D2_SERVICE_PERIOD.Get_Default_Value(g_record);
2771: l_attr:=l_attr||' 2';
2772: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2773: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2774: l_attr:=l_attr||' 3';
2775: IF NOT OE_GLOBALS.Equal(g_record.service_period, p_in_old_rec.service_period) THEN
2776: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2777: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2775: IF NOT OE_GLOBALS.Equal(g_record.service_period, p_in_old_rec.service_period) THEN

2771: l_attr:=l_attr||' 2';
2772: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2773: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2774: l_attr:=l_attr||' 3';
2775: IF NOT OE_GLOBALS.Equal(g_record.service_period, p_in_old_rec.service_period) THEN
2776: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2777: -- Raise error if security returns YES, operation IS CONSTRAINED
2778: RAISE FND_API.G_EXC_ERROR;
2779: END IF;

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

2776: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2777: -- Raise error if security returns YES, operation IS CONSTRAINED
2778: RAISE FND_API.G_EXC_ERROR;
2779: END IF;
2780: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2781: END IF;
2782: END IF;
2783: IF g_record.SERVICE_PERIOD IS NOT NULL THEN
2784: l_attr:=l_attr||' 4';

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

2812: l_attr:=l_attr||' 1';
2813: g_record.SERVICE_REFERENCE_TYPE_CODE := ONT_D2_SERVICE_REFERENCE_TY.Get_Default_Value(g_record);
2814: l_attr:=l_attr||' 2';
2815: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2816: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2817: l_attr:=l_attr||' 3';
2818: IF NOT OE_GLOBALS.Equal(g_record.service_reference_type_code, p_in_old_rec.service_reference_type_code) THEN
2819: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2820: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2818: IF NOT OE_GLOBALS.Equal(g_record.service_reference_type_code, p_in_old_rec.service_reference_type_code) THEN

2814: l_attr:=l_attr||' 2';
2815: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2816: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2817: l_attr:=l_attr||' 3';
2818: IF NOT OE_GLOBALS.Equal(g_record.service_reference_type_code, p_in_old_rec.service_reference_type_code) THEN
2819: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2820: -- Raise error if security returns YES, operation IS CONSTRAINED
2821: RAISE FND_API.G_EXC_ERROR;
2822: END IF;

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

2819: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2820: -- Raise error if security returns YES, operation IS CONSTRAINED
2821: RAISE FND_API.G_EXC_ERROR;
2822: END IF;
2823: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2824: END IF;
2825: END IF;
2826: IF g_record.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL THEN
2827: l_attr:=l_attr||' 4';

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

2843: l_attr:=l_attr||' 1';
2844: g_record.SERVICE_START_DATE := ONT_D2_SERVICE_START_DATE.Get_Default_Value(g_record);
2845: l_attr:=l_attr||' 2';
2846: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2847: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2848: l_attr:=l_attr||' 3';
2849: IF NOT OE_GLOBALS.Equal(g_record.service_start_date, p_in_old_rec.service_start_date) THEN
2850: IF OE_LINE_SECURITY.SERVICE_START_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2851: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 2849: IF NOT OE_GLOBALS.Equal(g_record.service_start_date, p_in_old_rec.service_start_date) THEN

2845: l_attr:=l_attr||' 2';
2846: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2847: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2848: l_attr:=l_attr||' 3';
2849: IF NOT OE_GLOBALS.Equal(g_record.service_start_date, p_in_old_rec.service_start_date) THEN
2850: IF OE_LINE_SECURITY.SERVICE_START_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2851: -- Raise error if security returns YES, operation IS CONSTRAINED
2852: RAISE FND_API.G_EXC_ERROR;
2853: END IF;

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

2850: IF OE_LINE_SECURITY.SERVICE_START_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2851: -- Raise error if security returns YES, operation IS CONSTRAINED
2852: RAISE FND_API.G_EXC_ERROR;
2853: END IF;
2854: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2855: END IF;
2856: END IF;
2857: IF g_record.SERVICE_START_DATE IS NOT NULL THEN
2858: l_attr:=l_attr||' 4';

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

2925: l_attr:=l_attr||' 1';
2926: g_record.SHIP_TO_CONTACT_ID := ONT_D2_SHIP_TO_CONTACT_ID.Get_Default_Value(g_record);
2927: l_attr:=l_attr||' 2';
2928: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2929: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2930: l_attr:=l_attr||' 3';
2931: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN
2932: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2933: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2927: l_attr:=l_attr||' 2';
2928: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2929: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2930: l_attr:=l_attr||' 3';
2931: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN
2932: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2933: -- Raise error if security returns YES, operation IS CONSTRAINED
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;

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

2932: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2933: -- Raise error if security returns YES, operation IS CONSTRAINED
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;
2936: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2937: END IF;
2938: END IF;
2939: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
2940: l_attr:=l_attr||' 4';

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

2955: l_attr:=l_attr||' 1';
2956: g_record.SHIP_TOLERANCE_ABOVE := ONT_D2_SHIP_TOLERANCE_ABOVE.Get_Default_Value(g_record);
2957: l_attr:=l_attr||' 2';
2958: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2959: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2960: l_attr:=l_attr||' 3';
2961: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN
2962: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2963: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2957: l_attr:=l_attr||' 2';
2958: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2959: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2960: l_attr:=l_attr||' 3';
2961: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN
2962: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2963: -- Raise error if security returns YES, operation IS CONSTRAINED
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;

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

2962: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2963: -- Raise error if security returns YES, operation IS CONSTRAINED
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;
2966: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2967: END IF;
2968: END IF;
2969: IF g_record.SHIP_TOLERANCE_ABOVE IS NOT NULL THEN
2970: l_attr:=l_attr||' 4';

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

2986: l_attr:=l_attr||' 1';
2987: g_record.SHIP_TOLERANCE_BELOW := ONT_D2_SHIP_TOLERANCE_BELOW.Get_Default_Value(g_record);
2988: l_attr:=l_attr||' 2';
2989: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2990: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2991: l_attr:=l_attr||' 3';
2992: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN
2993: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2994: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2988: l_attr:=l_attr||' 2';
2989: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2990: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2991: l_attr:=l_attr||' 3';
2992: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN
2993: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2994: -- Raise error if security returns YES, operation IS CONSTRAINED
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;

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

2993: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2994: -- Raise error if security returns YES, operation IS CONSTRAINED
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2998: END IF;
2999: END IF;
3000: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
3001: l_attr:=l_attr||' 4';

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

3023: l_attr:=l_attr||' 1';
3024: g_record.SHIPMENT_PRIORITY_CODE := ONT_D2_SHIPMENT_PRIORITY_CO.Get_Default_Value(g_record);
3025: l_attr:=l_attr||' 2';
3026: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3027: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3028: l_attr:=l_attr||' 3';
3029: IF NOT OE_GLOBALS.Equal(g_record.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN
3030: IF OE_LINE_SECURITY.SHIPMENT_PRIORITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3031: -- Raise error if security returns YES, operation IS CONSTRAINED

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

3025: l_attr:=l_attr||' 2';
3026: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3027: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3028: l_attr:=l_attr||' 3';
3029: IF NOT OE_GLOBALS.Equal(g_record.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN
3030: IF OE_LINE_SECURITY.SHIPMENT_PRIORITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3031: -- Raise error if security returns YES, operation IS CONSTRAINED
3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF;

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

3030: IF OE_LINE_SECURITY.SHIPMENT_PRIORITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3031: -- Raise error if security returns YES, operation IS CONSTRAINED
3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF;
3034: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3035: END IF;
3036: END IF;
3037: IF g_record.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
3038: l_attr:=l_attr||' 4';

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

3150: l_attr:=l_attr||' 1';
3151: g_record.SOURCE_TYPE_CODE := ONT_D2_SOURCE_TYPE_CODE.Get_Default_Value(g_record);
3152: l_attr:=l_attr||' 2';
3153: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3154: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3155: l_attr:=l_attr||' 3';
3156: IF NOT OE_GLOBALS.Equal(g_record.source_type_code, p_in_old_rec.source_type_code) THEN
3157: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3158: -- Raise error if security returns YES, operation IS CONSTRAINED

Line 3156: IF NOT OE_GLOBALS.Equal(g_record.source_type_code, p_in_old_rec.source_type_code) THEN

3152: l_attr:=l_attr||' 2';
3153: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3154: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3155: l_attr:=l_attr||' 3';
3156: IF NOT OE_GLOBALS.Equal(g_record.source_type_code, p_in_old_rec.source_type_code) THEN
3157: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3158: -- Raise error if security returns YES, operation IS CONSTRAINED
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;

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

3157: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3158: -- Raise error if security returns YES, operation IS CONSTRAINED
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3162: END IF;
3163: END IF;
3164: IF g_record.SOURCE_TYPE_CODE IS NOT NULL THEN
3165: l_attr:=l_attr||' 4';

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

3226: l_attr:=l_attr||' 1';
3227: g_record.TAX_EXEMPT_NUMBER := ONT_D2_TAX_EXEMPT_NUMBER.Get_Default_Value(g_record);
3228: l_attr:=l_attr||' 2';
3229: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3230: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3231: l_attr:=l_attr||' 3';
3232: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN
3233: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3234: -- Raise error if security returns YES, operation IS CONSTRAINED

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

3228: l_attr:=l_attr||' 2';
3229: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3230: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3231: l_attr:=l_attr||' 3';
3232: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN
3233: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3234: -- Raise error if security returns YES, operation IS CONSTRAINED
3235: RAISE FND_API.G_EXC_ERROR;
3236: END IF;

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

3233: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3234: -- Raise error if security returns YES, operation IS CONSTRAINED
3235: RAISE FND_API.G_EXC_ERROR;
3236: END IF;
3237: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3238: END IF;
3239: END IF;
3240: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
3241: l_attr:=l_attr||' 4';

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

3257: l_attr:=l_attr||' 1';
3258: g_record.TAX_EXEMPT_REASON_CODE := ONT_D2_TAX_EXEMPT_REASON_CO.Get_Default_Value(g_record);
3259: l_attr:=l_attr||' 2';
3260: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3261: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3262: l_attr:=l_attr||' 3';
3263: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_reason_code, p_in_old_rec.tax_exempt_reason_code) THEN
3264: IF OE_LINE_SECURITY.TAX_EXEMPT_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3265: -- Raise error if security returns YES, operation IS CONSTRAINED

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

3259: l_attr:=l_attr||' 2';
3260: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3261: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3262: l_attr:=l_attr||' 3';
3263: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_reason_code, p_in_old_rec.tax_exempt_reason_code) THEN
3264: IF OE_LINE_SECURITY.TAX_EXEMPT_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3265: -- Raise error if security returns YES, operation IS CONSTRAINED
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;

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

3264: IF OE_LINE_SECURITY.TAX_EXEMPT_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3265: -- Raise error if security returns YES, operation IS CONSTRAINED
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3269: END IF;
3270: END IF;
3271: IF g_record.TAX_EXEMPT_REASON_CODE IS NOT NULL THEN
3272: l_attr:=l_attr||' 4';