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 1702: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1698: l_attr:=l_attr||' 1';
1699: g_record.INVOICING_RULE_ID := ONT_D2_INVOICING_RULE_ID.Get_Default_Value(g_record);
1700: l_attr:=l_attr||' 2';
1701: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1702: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1703: l_attr:=l_attr||' 3';
1704: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN
1705: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1706: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1700: l_attr:=l_attr||' 2';
1701: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1702: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1703: l_attr:=l_attr||' 3';
1704: IF NOT OE_GLOBALS.Equal(g_record.invoicing_rule_id, p_in_old_rec.invoicing_rule_id) THEN
1705: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1706: -- Raise error if security returns YES, operation IS CONSTRAINED
1707: RAISE FND_API.G_EXC_ERROR;
1708: END IF;

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

1705: IF OE_LINE_SECURITY.INVOICING_RULE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1706: -- Raise error if security returns YES, operation IS CONSTRAINED
1707: RAISE FND_API.G_EXC_ERROR;
1708: END IF;
1709: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1710: END IF;
1711: END IF;
1712: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1713: l_attr:=l_attr||' 4';

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

1739: l_attr:=l_attr||' 1';
1740: g_record.ITEM_REVISION := ONT_D2_ITEM_REVISION.Get_Default_Value(g_record);
1741: l_attr:=l_attr||' 2';
1742: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1743: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1744: l_attr:=l_attr||' 3';
1745: IF NOT OE_GLOBALS.Equal(g_record.item_revision, p_in_old_rec.item_revision) THEN
1746: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1747: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1741: l_attr:=l_attr||' 2';
1742: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1743: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1744: l_attr:=l_attr||' 3';
1745: IF NOT OE_GLOBALS.Equal(g_record.item_revision, p_in_old_rec.item_revision) THEN
1746: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1747: -- Raise error if security returns YES, operation IS CONSTRAINED
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;

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

1746: IF OE_LINE_SECURITY.ITEM_REVISION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1747: -- Raise error if security returns YES, operation IS CONSTRAINED
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1751: END IF;
1752: END IF;
1753: IF g_record.ITEM_REVISION IS NOT NULL THEN
1754: l_attr:=l_attr||' 4';

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

1806: l_attr:=l_attr||' 1';
1807: g_record.LATEST_ACCEPTABLE_DATE := ONT_D2_LATEST_ACCEPTABLE_DA.Get_Default_Value(g_record);
1808: l_attr:=l_attr||' 2';
1809: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1810: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1811: l_attr:=l_attr||' 3';
1812: IF NOT OE_GLOBALS.Equal(g_record.latest_acceptable_date, p_in_old_rec.latest_acceptable_date) THEN
1813: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1814: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1808: l_attr:=l_attr||' 2';
1809: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1810: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1811: l_attr:=l_attr||' 3';
1812: IF NOT OE_GLOBALS.Equal(g_record.latest_acceptable_date, p_in_old_rec.latest_acceptable_date) THEN
1813: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1814: -- Raise error if security returns YES, operation IS CONSTRAINED
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;

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

1813: IF OE_LINE_SECURITY.LATEST_ACCEPTABLE_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1814: -- Raise error if security returns YES, operation IS CONSTRAINED
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;
1817: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1818: END IF;
1819: END IF;
1820: IF g_record.LATEST_ACCEPTABLE_DATE IS NOT NULL THEN
1821: l_attr:=l_attr||' 4';

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

1913: l_attr:=l_attr||' 1';
1914: g_record.ORDER_QUANTITY_UOM := ONT_D2_ORDER_QUANTITY_UOM.Get_Default_Value(g_record);
1915: l_attr:=l_attr||' 2';
1916: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1917: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1918: l_attr:=l_attr||' 3';
1919: IF NOT OE_GLOBALS.Equal(g_record.order_quantity_uom, p_in_old_rec.order_quantity_uom) THEN
1920: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1921: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1915: l_attr:=l_attr||' 2';
1916: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1917: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1918: l_attr:=l_attr||' 3';
1919: IF NOT OE_GLOBALS.Equal(g_record.order_quantity_uom, p_in_old_rec.order_quantity_uom) THEN
1920: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1921: -- Raise error if security returns YES, operation IS CONSTRAINED
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;

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

1920: IF OE_LINE_SECURITY.ORDER_QUANTITY_UOM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1921: -- Raise error if security returns YES, operation IS CONSTRAINED
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;
1924: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1925: END IF;
1926: END IF;
1927: IF g_record.ORDER_QUANTITY_UOM IS NOT NULL THEN
1928: l_attr:=l_attr||' 4';

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

1955: l_attr:=l_attr||' 1';
1956: g_record.ORDERED_QUANTITY := ONT_D2_ORDERED_QUANTITY.Get_Default_Value(g_record);
1957: l_attr:=l_attr||' 2';
1958: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1959: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1960: l_attr:=l_attr||' 3';
1961: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity, p_in_old_rec.ordered_quantity) THEN
1962: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1963: -- Raise error if security returns YES, operation IS CONSTRAINED

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

1957: l_attr:=l_attr||' 2';
1958: -- For UPDATE operations, check security if new defaulted value is not equal to old value
1959: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1960: l_attr:=l_attr||' 3';
1961: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity, p_in_old_rec.ordered_quantity) THEN
1962: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1963: -- Raise error if security returns YES, operation IS CONSTRAINED
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;

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

1962: IF OE_LINE_SECURITY.ORDERED_QUANTITY(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
1963: -- Raise error if security returns YES, operation IS CONSTRAINED
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
1967: END IF;
1968: END IF;
1969: IF g_record.ORDERED_QUANTITY IS NOT NULL THEN
1970: l_attr:=l_attr||' 4';

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

2015: l_attr:=l_attr||' 1';
2016: g_record.IB_OWNER := ONT_D2_IB_OWNER.Get_Default_Value(g_record);
2017: l_attr:=l_attr||' 2';
2018: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2019: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2020: l_attr:=l_attr||' 3';
2021: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN
2022: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2023: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2017: l_attr:=l_attr||' 2';
2018: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2019: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2020: l_attr:=l_attr||' 3';
2021: IF NOT OE_GLOBALS.Equal(g_record.ib_owner, p_in_old_rec.ib_owner) THEN
2022: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2023: -- Raise error if security returns YES, operation IS CONSTRAINED
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;

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

2022: IF OE_LINE_SECURITY.IB_OWNER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2023: -- Raise error if security returns YES, operation IS CONSTRAINED
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2027: END IF;
2028: END IF;
2029: IF g_record.IB_OWNER IS NOT NULL THEN
2030: l_attr:=l_attr||' 4';

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

2066: l_attr:=l_attr||' 1';
2067: g_record.PAYMENT_TERM_ID := ONT_D2_PAYMENT_TERM_ID.Get_Default_Value(g_record);
2068: l_attr:=l_attr||' 2';
2069: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2070: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2071: l_attr:=l_attr||' 3';
2072: IF NOT OE_GLOBALS.Equal(g_record.payment_term_id, p_in_old_rec.payment_term_id) THEN
2073: IF OE_LINE_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2074: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2068: l_attr:=l_attr||' 2';
2069: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2070: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2071: l_attr:=l_attr||' 3';
2072: IF NOT OE_GLOBALS.Equal(g_record.payment_term_id, p_in_old_rec.payment_term_id) THEN
2073: IF OE_LINE_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2074: -- Raise error if security returns YES, operation IS CONSTRAINED
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;

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

2073: IF OE_LINE_SECURITY.PAYMENT_TERM(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2074: -- Raise error if security returns YES, operation IS CONSTRAINED
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2078: END IF;
2079: END IF;
2080: IF g_record.PAYMENT_TERM_ID IS NOT NULL THEN
2081: l_attr:=l_attr||' 4';

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

2107: AND p_in_old_rec.PRICE_LIST_ID <> FND_API.G_MISS_NUM THEN
2108: g_record.PRICE_LIST_ID := p_in_old_rec.PRICE_LIST_ID;
2109: END IF;
2110: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2111: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2112: l_attr:=l_attr||' 3';
2113: IF NOT OE_GLOBALS.Equal(g_record.price_list_id, p_in_old_rec.price_list_id) THEN
2114: IF OE_LINE_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2115: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2109: END IF;
2110: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2111: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2112: l_attr:=l_attr||' 3';
2113: IF NOT OE_GLOBALS.Equal(g_record.price_list_id, p_in_old_rec.price_list_id) THEN
2114: IF OE_LINE_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2115: -- Raise error if security returns YES, operation IS CONSTRAINED
2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;

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

2114: IF OE_LINE_SECURITY.PRICE_LIST(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2115: -- Raise error if security returns YES, operation IS CONSTRAINED
2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;
2118: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2119: END IF;
2120: END IF;
2121: IF g_record.PRICE_LIST_ID IS NOT NULL THEN
2122: l_attr:=l_attr||' 4';

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

2203: l_attr:=l_attr||' 1';
2204: g_record.PRICING_DATE := ONT_D2_PRICING_DATE.Get_Default_Value(g_record);
2205: l_attr:=l_attr||' 2';
2206: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2207: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2208: l_attr:=l_attr||' 3';
2209: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN
2210: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2211: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2205: l_attr:=l_attr||' 2';
2206: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2207: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2208: l_attr:=l_attr||' 3';
2209: IF NOT OE_GLOBALS.Equal(g_record.pricing_date, p_in_old_rec.pricing_date) THEN
2210: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2211: -- Raise error if security returns YES, operation IS CONSTRAINED
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;

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

2210: IF OE_LINE_SECURITY.PRICING_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2211: -- Raise error if security returns YES, operation IS CONSTRAINED
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2215: END IF;
2216: END IF;
2217: IF g_record.PRICING_DATE IS NOT NULL THEN
2218: l_attr:=l_attr||' 4';

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

2408: l_attr:=l_attr||' 1';
2409: g_record.RETURN_REASON_CODE := ONT_D2_RETURN_REASON_CODE.Get_Default_Value(g_record);
2410: l_attr:=l_attr||' 2';
2411: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2412: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2413: l_attr:=l_attr||' 3';
2414: IF NOT OE_GLOBALS.Equal(g_record.return_reason_code, p_in_old_rec.return_reason_code) THEN
2415: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2416: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2410: l_attr:=l_attr||' 2';
2411: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2412: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2413: l_attr:=l_attr||' 3';
2414: IF NOT OE_GLOBALS.Equal(g_record.return_reason_code, p_in_old_rec.return_reason_code) THEN
2415: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2416: -- Raise error if security returns YES, operation IS CONSTRAINED
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;

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

2415: IF OE_LINE_SECURITY.RETURN_REASON(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2416: -- Raise error if security returns YES, operation IS CONSTRAINED
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2420: END IF;
2421: END IF;
2422: IF g_record.RETURN_REASON_CODE IS NOT NULL THEN
2423: l_attr:=l_attr||' 4';

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

2469: l_attr:=l_attr||' 1';
2470: g_record.BLANKET_NUMBER := ONT_D2_BLANKET_NUMBER.Get_Default_Value(g_record);
2471: l_attr:=l_attr||' 2';
2472: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2473: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2474: l_attr:=l_attr||' 3';
2475: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN
2476: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2477: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2471: l_attr:=l_attr||' 2';
2472: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2473: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2474: l_attr:=l_attr||' 3';
2475: IF NOT OE_GLOBALS.Equal(g_record.blanket_number, p_in_old_rec.blanket_number) THEN
2476: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2477: -- Raise error if security returns YES, operation IS CONSTRAINED
2478: RAISE FND_API.G_EXC_ERROR;
2479: END IF;

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

2476: IF OE_LINE_SECURITY.BLANKET_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2477: -- Raise error if security returns YES, operation IS CONSTRAINED
2478: RAISE FND_API.G_EXC_ERROR;
2479: END IF;
2480: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2481: END IF;
2482: END IF;
2483: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
2484: l_attr:=l_attr||' 4';

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

2509: AND p_in_old_rec.SALESREP_ID <> FND_API.G_MISS_NUM THEN
2510: g_record.SALESREP_ID := p_in_old_rec.SALESREP_ID;
2511: END IF;
2512: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2513: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2514: l_attr:=l_attr||' 3';
2515: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN
2516: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2517: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2511: END IF;
2512: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2513: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2514: l_attr:=l_attr||' 3';
2515: IF NOT OE_GLOBALS.Equal(g_record.salesrep_id, p_in_old_rec.salesrep_id) THEN
2516: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2517: -- Raise error if security returns YES, operation IS CONSTRAINED
2518: RAISE FND_API.G_EXC_ERROR;
2519: END IF;

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

2516: IF OE_LINE_SECURITY.SALESREP(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2517: -- Raise error if security returns YES, operation IS CONSTRAINED
2518: RAISE FND_API.G_EXC_ERROR;
2519: END IF;
2520: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2521: END IF;
2522: END IF;
2523: IF g_record.SALESREP_ID IS NOT NULL THEN
2524: l_attr:=l_attr||' 4';

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

2546: l_attr:=l_attr||' 1';
2547: g_record.SCHEDULE_ARRIVAL_DATE := ONT_D2_SCHEDULE_ARRIVAL_DAT.Get_Default_Value(g_record);
2548: l_attr:=l_attr||' 2';
2549: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2550: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2551: l_attr:=l_attr||' 3';
2552: IF NOT OE_GLOBALS.Equal(g_record.schedule_arrival_date, p_in_old_rec.schedule_arrival_date) THEN
2553: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2554: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2548: l_attr:=l_attr||' 2';
2549: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2550: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2551: l_attr:=l_attr||' 3';
2552: IF NOT OE_GLOBALS.Equal(g_record.schedule_arrival_date, p_in_old_rec.schedule_arrival_date) THEN
2553: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2554: -- Raise error if security returns YES, operation IS CONSTRAINED
2555: RAISE FND_API.G_EXC_ERROR;
2556: END IF;

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

2553: IF OE_LINE_SECURITY.SCHEDULE_ARRIVAL_DATE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2554: -- Raise error if security returns YES, operation IS CONSTRAINED
2555: RAISE FND_API.G_EXC_ERROR;
2556: END IF;
2557: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2558: END IF;
2559: END IF;
2560: IF g_record.SCHEDULE_ARRIVAL_DATE IS NOT NULL THEN
2561: l_attr:=l_attr||' 4';

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

2595: l_attr:=l_attr||' 1';
2596: g_record.ORDERED_QUANTITY2 := ONT_D2_ORDERED_QUANTITY2.Get_Default_Value(g_record);
2597: l_attr:=l_attr||' 2';
2598: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2599: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2600: l_attr:=l_attr||' 3';
2601: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity2, p_in_old_rec.ordered_quantity2) THEN
2602: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2603: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2597: l_attr:=l_attr||' 2';
2598: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2599: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2600: l_attr:=l_attr||' 3';
2601: IF NOT OE_GLOBALS.Equal(g_record.ordered_quantity2, p_in_old_rec.ordered_quantity2) THEN
2602: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2603: -- Raise error if security returns YES, operation IS CONSTRAINED
2604: RAISE FND_API.G_EXC_ERROR;
2605: END IF;

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

2602: IF OE_LINE_SECURITY.ORDERED_QUANTITY2(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2603: -- Raise error if security returns YES, operation IS CONSTRAINED
2604: RAISE FND_API.G_EXC_ERROR;
2605: END IF;
2606: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2607: END IF;
2608: END IF;
2609: -- There is no validation api registered in the AK dictionary
2610: END IF;

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

2649: l_attr:=l_attr||' 1';
2650: g_record.SERVICE_DURATION := ONT_D2_SERVICE_DURATION.Get_Default_Value(g_record);
2651: l_attr:=l_attr||' 2';
2652: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2653: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2654: l_attr:=l_attr||' 3';
2655: IF NOT OE_GLOBALS.Equal(g_record.service_duration, p_in_old_rec.service_duration) THEN
2656: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2657: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2651: l_attr:=l_attr||' 2';
2652: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2653: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2654: l_attr:=l_attr||' 3';
2655: IF NOT OE_GLOBALS.Equal(g_record.service_duration, p_in_old_rec.service_duration) THEN
2656: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2657: -- Raise error if security returns YES, operation IS CONSTRAINED
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;

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

2656: IF OE_LINE_SECURITY.SERVICE_DURATION(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2657: -- Raise error if security returns YES, operation IS CONSTRAINED
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2661: END IF;
2662: END IF;
2663: IF g_record.SERVICE_DURATION IS NOT NULL THEN
2664: l_attr:=l_attr||' 4';

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

2692: l_attr:=l_attr||' 1';
2693: g_record.SERVICE_PERIOD := ONT_D2_SERVICE_PERIOD.Get_Default_Value(g_record);
2694: l_attr:=l_attr||' 2';
2695: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2696: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2697: l_attr:=l_attr||' 3';
2698: IF NOT OE_GLOBALS.Equal(g_record.service_period, p_in_old_rec.service_period) THEN
2699: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2700: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2694: l_attr:=l_attr||' 2';
2695: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2696: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2697: l_attr:=l_attr||' 3';
2698: IF NOT OE_GLOBALS.Equal(g_record.service_period, p_in_old_rec.service_period) THEN
2699: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2700: -- Raise error if security returns YES, operation IS CONSTRAINED
2701: RAISE FND_API.G_EXC_ERROR;
2702: END IF;

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

2699: IF OE_LINE_SECURITY.SERVICE_PERIOD(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2700: -- Raise error if security returns YES, operation IS CONSTRAINED
2701: RAISE FND_API.G_EXC_ERROR;
2702: END IF;
2703: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2704: END IF;
2705: END IF;
2706: IF g_record.SERVICE_PERIOD IS NOT NULL THEN
2707: l_attr:=l_attr||' 4';

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

2735: l_attr:=l_attr||' 1';
2736: g_record.SERVICE_REFERENCE_TYPE_CODE := ONT_D2_SERVICE_REFERENCE_TY.Get_Default_Value(g_record);
2737: l_attr:=l_attr||' 2';
2738: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2739: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2740: l_attr:=l_attr||' 3';
2741: IF NOT OE_GLOBALS.Equal(g_record.service_reference_type_code, p_in_old_rec.service_reference_type_code) THEN
2742: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2743: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2737: l_attr:=l_attr||' 2';
2738: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2739: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2740: l_attr:=l_attr||' 3';
2741: IF NOT OE_GLOBALS.Equal(g_record.service_reference_type_code, p_in_old_rec.service_reference_type_code) THEN
2742: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2743: -- Raise error if security returns YES, operation IS CONSTRAINED
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;

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

2742: IF OE_LINE_SECURITY.SERVICE_REFERENCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2743: -- Raise error if security returns YES, operation IS CONSTRAINED
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;
2746: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2747: END IF;
2748: END IF;
2749: IF g_record.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL THEN
2750: l_attr:=l_attr||' 4';

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

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

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

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

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

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

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

2827: l_attr:=l_attr||' 1';
2828: g_record.SHIP_TO_CONTACT_ID := ONT_D2_SHIP_TO_CONTACT_ID.Get_Default_Value(g_record);
2829: l_attr:=l_attr||' 2';
2830: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2831: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2832: l_attr:=l_attr||' 3';
2833: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN
2834: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2835: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2829: l_attr:=l_attr||' 2';
2830: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2831: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2832: l_attr:=l_attr||' 3';
2833: IF NOT OE_GLOBALS.Equal(g_record.ship_to_contact_id, p_in_old_rec.ship_to_contact_id) THEN
2834: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2835: -- Raise error if security returns YES, operation IS CONSTRAINED
2836: RAISE FND_API.G_EXC_ERROR;
2837: END IF;

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

2834: IF OE_LINE_SECURITY.SHIP_TO_CONTACT(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2835: -- Raise error if security returns YES, operation IS CONSTRAINED
2836: RAISE FND_API.G_EXC_ERROR;
2837: END IF;
2838: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2839: END IF;
2840: END IF;
2841: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
2842: l_attr:=l_attr||' 4';

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

2857: l_attr:=l_attr||' 1';
2858: g_record.SHIP_TOLERANCE_ABOVE := ONT_D2_SHIP_TOLERANCE_ABOVE.Get_Default_Value(g_record);
2859: l_attr:=l_attr||' 2';
2860: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2861: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2862: l_attr:=l_attr||' 3';
2863: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN
2864: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2865: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2859: l_attr:=l_attr||' 2';
2860: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2861: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2862: l_attr:=l_attr||' 3';
2863: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_above, p_in_old_rec.ship_tolerance_above) THEN
2864: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2865: -- Raise error if security returns YES, operation IS CONSTRAINED
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;

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

2864: IF OE_LINE_SECURITY.SHIP_TOLERANCE_ABOVE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2865: -- Raise error if security returns YES, operation IS CONSTRAINED
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;
2868: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2869: END IF;
2870: END IF;
2871: IF g_record.SHIP_TOLERANCE_ABOVE IS NOT NULL THEN
2872: l_attr:=l_attr||' 4';

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

2888: l_attr:=l_attr||' 1';
2889: g_record.SHIP_TOLERANCE_BELOW := ONT_D2_SHIP_TOLERANCE_BELOW.Get_Default_Value(g_record);
2890: l_attr:=l_attr||' 2';
2891: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2892: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2893: l_attr:=l_attr||' 3';
2894: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN
2895: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2896: -- Raise error if security returns YES, operation IS CONSTRAINED

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

2890: l_attr:=l_attr||' 2';
2891: -- For UPDATE operations, check security if new defaulted value is not equal to old value
2892: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2893: l_attr:=l_attr||' 3';
2894: IF NOT OE_GLOBALS.Equal(g_record.ship_tolerance_below, p_in_old_rec.ship_tolerance_below) THEN
2895: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2896: -- Raise error if security returns YES, operation IS CONSTRAINED
2897: RAISE FND_API.G_EXC_ERROR;
2898: END IF;

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

2895: IF OE_LINE_SECURITY.SHIP_TOLERANCE_BELOW(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
2896: -- Raise error if security returns YES, operation IS CONSTRAINED
2897: RAISE FND_API.G_EXC_ERROR;
2898: END IF;
2899: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
2900: END IF;
2901: END IF;
2902: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
2903: 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.SHIPMENT_PRIORITY_CODE := ONT_D2_SHIPMENT_PRIORITY_CO.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.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN
2932: IF OE_LINE_SECURITY.SHIPMENT_PRIORITY(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.shipment_priority_code, p_in_old_rec.shipment_priority_code) 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.shipment_priority_code, p_in_old_rec.shipment_priority_code) THEN
2932: IF OE_LINE_SECURITY.SHIPMENT_PRIORITY(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.SHIPMENT_PRIORITY(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.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
2940: l_attr:=l_attr||' 4';

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

3052: l_attr:=l_attr||' 1';
3053: g_record.SOURCE_TYPE_CODE := ONT_D2_SOURCE_TYPE_CODE.Get_Default_Value(g_record);
3054: l_attr:=l_attr||' 2';
3055: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3056: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3057: l_attr:=l_attr||' 3';
3058: IF NOT OE_GLOBALS.Equal(g_record.source_type_code, p_in_old_rec.source_type_code) THEN
3059: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3060: -- Raise error if security returns YES, operation IS CONSTRAINED

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

3054: l_attr:=l_attr||' 2';
3055: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3056: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3057: l_attr:=l_attr||' 3';
3058: IF NOT OE_GLOBALS.Equal(g_record.source_type_code, p_in_old_rec.source_type_code) THEN
3059: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3060: -- Raise error if security returns YES, operation IS CONSTRAINED
3061: RAISE FND_API.G_EXC_ERROR;
3062: END IF;

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

3059: IF OE_LINE_SECURITY.SOURCE_TYPE(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3060: -- Raise error if security returns YES, operation IS CONSTRAINED
3061: RAISE FND_API.G_EXC_ERROR;
3062: END IF;
3063: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3064: END IF;
3065: END IF;
3066: IF g_record.SOURCE_TYPE_CODE IS NOT NULL THEN
3067: l_attr:=l_attr||' 4';

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

3122: l_attr:=l_attr||' 1';
3123: g_record.TAX_EXEMPT_NUMBER := ONT_D2_TAX_EXEMPT_NUMBER.Get_Default_Value(g_record);
3124: l_attr:=l_attr||' 2';
3125: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3126: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3127: l_attr:=l_attr||' 3';
3128: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN
3129: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3130: -- Raise error if security returns YES, operation IS CONSTRAINED

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

3124: l_attr:=l_attr||' 2';
3125: -- For UPDATE operations, check security if new defaulted value is not equal to old value
3126: IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3127: l_attr:=l_attr||' 3';
3128: IF NOT OE_GLOBALS.Equal(g_record.tax_exempt_number, p_in_old_rec.tax_exempt_number) THEN
3129: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3130: -- Raise error if security returns YES, operation IS CONSTRAINED
3131: RAISE FND_API.G_EXC_ERROR;
3132: END IF;

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

3129: IF OE_LINE_SECURITY.TAX_EXEMPT_NUMBER(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN
3130: -- Raise error if security returns YES, operation IS CONSTRAINED
3131: RAISE FND_API.G_EXC_ERROR;
3132: END IF;
3133: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';
3134: END IF;
3135: END IF;
3136: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
3137: l_attr:=l_attr||' 4';

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

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

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

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

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

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