DBA Data[Home] [Help]

APPS.OE_CNCL_UTIL dependencies on OE_MSG_PUB

Line 34: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

30:
31: IF p_x_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
32:
33:
34: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
35: THEN
36:
37: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
38: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 39: OE_MSG_PUB.Add;

35: THEN
36:
37: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
38: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
39: OE_MSG_PUB.Add;
40:
41: END IF;
42:
43: ELSE

Line 65: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

61: IF p_x_header_rec.agreement_id <> FND_API.G_MISS_NUM THEN
62:
63:
64:
65: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
66: THEN
67:
68: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
69: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 70: OE_MSG_PUB.Add;

66: THEN
67:
68: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
69: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
70: OE_MSG_PUB.Add;
71:
72: END IF;
73:
74: ELSE

Line 94: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

90:
91: IF p_x_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR THEN
92:
93:
94: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
95: THEN
96:
97: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');

Line 99: OE_MSG_PUB.Add;

95: THEN
96:
97: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
99: OE_MSG_PUB.Add;
100:
101: END IF;
102:
103: ELSE

Line 124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

120:
121: IF p_x_header_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
122:
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
125: THEN
126:
127: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');

Line 129: OE_MSG_PUB.Add;

125: THEN
126:
127: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
129: OE_MSG_PUB.Add;
130:
131: END IF;
132:
133: ELSE

Line 153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

149:
150: IF p_x_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
151:
152:
153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
154: THEN
155:
156: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 158: OE_MSG_PUB.Add;

154: THEN
155:
156: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
158: OE_MSG_PUB.Add;
159:
160: END IF;
161:
162: ELSE

Line 183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

179:
180: IF p_x_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
181:
182:
183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
184: THEN
185:
186: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');

Line 188: OE_MSG_PUB.Add;

184: THEN
185:
186: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
188: OE_MSG_PUB.Add;
189:
190: END IF;
191:
192: ELSE

Line 216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

212:
213: IF p_x_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
214:
215:
216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
217: THEN
218:
219: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');

Line 221: OE_MSG_PUB.Add;

217: THEN
218:
219: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
221: OE_MSG_PUB.Add;
222:
223: END IF;
224:
225: ELSE

Line 247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

243:
244: IF p_x_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
245:
246:
247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
248: THEN
249:
250: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 252: OE_MSG_PUB.Add;

248: THEN
249:
250: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
252: OE_MSG_PUB.Add;
253:
254: END IF;
255:
256: ELSE

Line 277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

273:
274: IF p_x_header_rec.order_source_id <> FND_API.G_MISS_NUM THEN
275:
276:
277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
278: THEN
279:
280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');

Line 282: OE_MSG_PUB.Add;

278: THEN
279:
280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
282: OE_MSG_PUB.Add;
283:
284: END IF;
285:
286: ELSE

Line 306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

302:
303: IF p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM THEN
304:
305:
306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
307: THEN
308:
309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');

Line 311: OE_MSG_PUB.Add;

307: THEN
308:
309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
311: OE_MSG_PUB.Add;
312:
313: END IF;
314:
315: ELSE

Line 335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

331:
332: IF p_x_header_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
333:
334:
335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
336: THEN
337:
338: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
339: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');

Line 340: OE_MSG_PUB.Add;

336: THEN
337:
338: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
339: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
340: OE_MSG_PUB.Add;
341:
342: END IF;
343:
344: ELSE

Line 364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

360:
361: IF p_x_header_rec.price_list_id <> FND_API.G_MISS_NUM THEN
362:
363:
364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
365: THEN
366:
367: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
368: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 369: OE_MSG_PUB.Add;

365: THEN
366:
367: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
368: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
369: OE_MSG_PUB.Add;
370:
371: END IF;
372:
373: ELSE

Line 393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

389:
390: IF p_x_header_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
391:
392:
393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
394: THEN
395:
396: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');

Line 398: OE_MSG_PUB.Add;

394: THEN
395:
396: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
398: OE_MSG_PUB.Add;
399:
400: END IF;
401:
402: ELSE

Line 423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

419:
420: IF p_x_header_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
421:
422:
423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
424: THEN
425:
426: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
427: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 428: OE_MSG_PUB.Add;

424: THEN
425:
426: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
427: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
428: OE_MSG_PUB.Add;
429:
430: END IF;
431:
432: ELSE

Line 452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

448:
449: IF p_x_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR THEN
450:
451:
452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
453: THEN
454:
455: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');

Line 457: OE_MSG_PUB.Add;

453: THEN
454:
455: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
457: OE_MSG_PUB.Add;
458:
459: END IF;
460:
461: ELSE

Line 482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

478:
479: IF p_x_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
480:
481:
482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
483: THEN
484:
485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');

Line 487: OE_MSG_PUB.Add;

483: THEN
484:
485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
487: OE_MSG_PUB.Add;
488:
489: END IF;
490:
491: ELSE

Line 519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

515:
516: IF p_x_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
517:
518:
519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
520: THEN
521:
522: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');

Line 524: OE_MSG_PUB.Add;

520: THEN
521:
522: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
524: OE_MSG_PUB.Add;
525:
526: END IF;
527:
528: ELSE

Line 553: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

549:
550: IF p_x_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
551:
552:
553: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
554: THEN
555:
556: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');

Line 558: OE_MSG_PUB.Add;

554: THEN
555:
556: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
558: OE_MSG_PUB.Add;
559:
560: END IF;
561:
562: ELSE

Line 582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

578:
579: IF p_x_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
580:
581:
582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
583: THEN
584:
585: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');

Line 587: OE_MSG_PUB.Add;

583: THEN
584:
585: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
587: OE_MSG_PUB.Add;
588:
589: END IF;
590:
591: ELSE

Line 612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

608:
609: IF p_x_header_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
610:
611:
612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
613: THEN
614:
615: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');

Line 617: OE_MSG_PUB.Add;

613: THEN
614:
615: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
617: OE_MSG_PUB.Add;
618:
619: END IF;
620:
621: ELSE

Line 641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

637:
638: IF p_x_header_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
639:
640:
641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
642: THEN
643:
644: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');

Line 646: OE_MSG_PUB.Add;

642: THEN
643:
644: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
646: OE_MSG_PUB.Add;
647:
648: END IF;
649:
650: ELSE

Line 671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

667:
668: IF p_x_header_rec.credit_card_code <> FND_API.G_MISS_CHAR THEN
669:
670:
671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
672: THEN
673:
674: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
675: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');

Line 676: OE_MSG_PUB.Add;

672: THEN
673:
674: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
675: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
676: OE_MSG_PUB.Add;
677:
678: END IF;
679:
680: ELSE

Line 706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

702:
703: IF p_x_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
704:
705:
706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
707: THEN
708:
709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');

Line 711: OE_MSG_PUB.Add;

707: THEN
708:
709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
711: OE_MSG_PUB.Add;
712:
713: END IF;
714:
715: ELSE

Line 756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

752:
753: IF p_x_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM THEN
754:
755:
756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
757: THEN
758:
759: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');

Line 761: OE_MSG_PUB.Add;

757: THEN
758:
759: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
761: OE_MSG_PUB.Add;
762:
763: END IF;
764:
765: ELSE

Line 792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

788:
789: IF p_x_header_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
790:
791:
792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
793: THEN
794:
795: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
796: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');

Line 797: OE_MSG_PUB.Add;

793: THEN
794:
795: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
796: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
797: OE_MSG_PUB.Add;
798:
799: END IF;
800:
801: ELSE

Line 838: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

834:
835: IF p_x_header_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
836:
837:
838: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
839: THEN
840:
841: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');

Line 843: OE_MSG_PUB.Add;

839: THEN
840:
841: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
843: OE_MSG_PUB.Add;
844:
845: END IF;
846:
847: ELSE

Line 884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

880:
881: IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
882:
883:
884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
885: THEN
886:
887: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');

Line 889: OE_MSG_PUB.Add;

885: THEN
886:
887: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
889: OE_MSG_PUB.Add;
890:
891: END IF;
892:
893: ELSE

Line 928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

924:
925: IF p_x_header_rec.sold_to_site_use_id <> FND_API.G_MISS_NUM THEN
926:
927:
928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
929: THEN
930:
931: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');

Line 933: OE_MSG_PUB.Add;

929: THEN
930:
931: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');
933: OE_MSG_PUB.Add;
934:
935: END IF;
936:
937: ELSE

Line 972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

968:
969: IF p_x_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
970:
971:
972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
973: THEN
974:
975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');

Line 977: OE_MSG_PUB.Add;

973: THEN
974:
975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
977: OE_MSG_PUB.Add;
978:
979: END IF;
980:
981: ELSE

Line 1003: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

999:
1000: IF p_x_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
1001:
1002:
1003: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1004: THEN
1005:
1006: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');

Line 1008: OE_MSG_PUB.Add;

1004: THEN
1005:
1006: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
1008: OE_MSG_PUB.Add;
1009:
1010: END IF;
1011:
1012: ELSE

Line 1034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1030:
1031: IF p_x_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
1032:
1033:
1034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1035: THEN
1036:
1037: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');

Line 1039: OE_MSG_PUB.Add;

1035: THEN
1036:
1037: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
1039: OE_MSG_PUB.Add;
1040:
1041: END IF;
1042:
1043: ELSE

Line 1067: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1063:
1064: IF p_x_header_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
1065:
1066:
1067: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1068: THEN
1069:
1070: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');

Line 1072: OE_MSG_PUB.Add;

1068: THEN
1069:
1070: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
1072: OE_MSG_PUB.Add;
1073:
1074: END IF;
1075:
1076: ELSE

Line 1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1094: IF p_x_header_rec.end_customer_id <>FND_API.G_MISS_NUM and
1095: p_x_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
1096:
1097:
1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1099: THEN
1100:
1101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');

Line 1103: OE_MSG_PUB.Add;

1099: THEN
1100:
1101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
1103: OE_MSG_PUB.Add;
1104:
1105: END IF;
1106:
1107: ELSE

Line 1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1133:
1134: IF p_x_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
1135:
1136:
1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1138: THEN
1139:
1140: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');

Line 1142: OE_MSG_PUB.Add;

1138: THEN
1139:
1140: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');
1142: OE_MSG_PUB.Add;
1143:
1144: END IF;
1145:
1146: ELSE

Line 1178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1174: IF p_header_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
1175: THEN
1176: IF p_x_header_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
1177:
1178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1179: THEN
1180:
1181: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');

Line 1183: OE_MSG_PUB.Add;

1179: THEN
1180:
1181: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
1183: OE_MSG_PUB.Add;
1184:
1185: END IF;
1186:
1187: ELSE

Line 1205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1201: IF p_header_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
1202: THEN
1203: IF p_x_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
1204:
1205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1206: THEN
1207:
1208: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');

Line 1210: OE_MSG_PUB.Add;

1206: THEN
1207:
1208: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
1210: OE_MSG_PUB.Add;
1211:
1212: END IF;
1213:
1214: ELSE

Line 1232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1228: IF p_header_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
1229: THEN
1230: IF p_x_header_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
1231:
1232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1233: THEN
1234:
1235: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');

Line 1237: OE_MSG_PUB.Add;

1233: THEN
1234:
1235: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
1237: OE_MSG_PUB.Add;
1238:
1239: END IF;
1240:
1241: ELSE

Line 1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1284: THEN
1285:
1286: IF p_x_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1289: THEN
1290:
1291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 1293: OE_MSG_PUB.Add;

1289: THEN
1290:
1291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
1293: OE_MSG_PUB.Add;
1294:
1295: END IF;
1296:
1297: ELSE

Line 1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1313: THEN
1314:
1315: IF p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
1316:
1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1318: THEN
1319:
1320: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 1322: OE_MSG_PUB.Add;

1318: THEN
1319:
1320: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
1322: OE_MSG_PUB.Add;
1323:
1324: END IF;
1325:
1326: ELSE

Line 1345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1341: THEN
1342:
1343: IF p_x_line_rec.demand_bucket_type_code <> FND_API.G_MISS_CHAR THEN
1344:
1345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1346: THEN
1347:
1348: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');

Line 1350: OE_MSG_PUB.Add;

1346: THEN
1347:
1348: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
1350: OE_MSG_PUB.Add;
1351:
1352: END IF;
1353:
1354: ELSE

Line 1374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1370: THEN
1371:
1372: IF p_x_line_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
1373:
1374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1375: THEN
1376:
1377: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');

Line 1379: OE_MSG_PUB.Add;

1375: THEN
1376:
1377: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
1379: OE_MSG_PUB.Add;
1380:
1381: END IF;
1382:
1383: ELSE

Line 1402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1398: THEN
1399:
1400: IF p_x_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
1401:
1402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1403: THEN
1404:
1405: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1406: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 1407: OE_MSG_PUB.Add;

1403: THEN
1404:
1405: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1406: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
1407: OE_MSG_PUB.Add;
1408:
1409: END IF;
1410:
1411: ELSE

Line 1431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1427: THEN
1428:
1429: IF p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
1430:
1431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1432: THEN
1433:
1434: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1435: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');

Line 1436: OE_MSG_PUB.Add;

1432: THEN
1433:
1434: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1435: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
1436: OE_MSG_PUB.Add;
1437:
1438: END IF;
1439:
1440: ELSE

Line 1464: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1460: THEN
1461:
1462: IF p_x_line_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
1463:
1464: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1465: THEN
1466:
1467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');

Line 1469: OE_MSG_PUB.Add;

1465: THEN
1466:
1467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
1469: OE_MSG_PUB.Add;
1470:
1471: END IF;
1472:
1473: ELSE

Line 1494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1490: THEN
1491:
1492: IF p_x_line_rec.intermed_ship_to_contact_id <> FND_API.G_MISS_NUM THEN
1493:
1494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1495: THEN
1496:
1497: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1498: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');

Line 1499: OE_MSG_PUB.Add;

1495: THEN
1496:
1497: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1498: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
1499: OE_MSG_PUB.Add;
1500:
1501: END IF;
1502:
1503: ELSE

Line 1529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1525: THEN
1526:
1527: IF p_x_line_rec.intermed_ship_to_org_id <> FND_API.G_MISS_NUM THEN
1528:
1529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1530: THEN
1531:
1532: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1533: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');

Line 1534: OE_MSG_PUB.Add;

1530: THEN
1531:
1532: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1533: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
1534: OE_MSG_PUB.Add;
1535:
1536: END IF;
1537:
1538: ELSE

Line 1569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1565: THEN
1566:
1567: IF p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
1568:
1569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1570: THEN
1571:
1572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 1574: OE_MSG_PUB.Add;

1570: THEN
1571:
1572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
1574: OE_MSG_PUB.Add;
1575:
1576: END IF;
1577:
1578: ELSE

Line 1597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1593: THEN
1594:
1595: IF p_x_line_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
1596:
1597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1598: THEN
1599:
1600: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 1602: OE_MSG_PUB.Add;

1598: THEN
1599:
1600: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1602: OE_MSG_PUB.Add;
1603:
1604: END IF;
1605:
1606: ELSE

Line 1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1621: THEN
1622:
1623: IF p_x_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
1624:
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1626: THEN
1627:
1628: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');

Line 1630: OE_MSG_PUB.Add;

1626: THEN
1627:
1628: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
1630: OE_MSG_PUB.Add;
1631:
1632: END IF;
1633:
1634: ELSE

Line 1653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1649: THEN
1650:
1651: IF p_x_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN
1652:
1653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1654: THEN
1655:
1656: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');

Line 1658: OE_MSG_PUB.Add;

1654: THEN
1655:
1656: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
1658: OE_MSG_PUB.Add;
1659:
1660: END IF;
1661:
1662: ELSE

Line 1681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1677: THEN
1678:
1679: IF p_x_line_rec.over_ship_reason_code <> FND_API.G_MISS_CHAR THEN
1680:
1681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1682: THEN
1683:
1684: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');

Line 1686: OE_MSG_PUB.Add;

1682: THEN
1683:
1684: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
1686: OE_MSG_PUB.Add;
1687:
1688: END IF;
1689:
1690: ELSE

Line 1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1706: THEN
1707:
1708: IF p_x_line_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
1709:
1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1711: THEN
1712:
1713: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1714: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');

Line 1715: OE_MSG_PUB.Add;

1711: THEN
1712:
1713: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1714: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
1715: OE_MSG_PUB.Add;
1716:
1717: END IF;
1718:
1719: ELSE

Line 1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1735: THEN
1736:
1737: IF p_x_line_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1738:
1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1740: THEN
1741:
1742: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 1744: OE_MSG_PUB.Add;

1740: THEN
1741:
1742: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1744: OE_MSG_PUB.Add;
1745:
1746: END IF;
1747:
1748: ELSE

Line 1767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1763: THEN
1764:
1765: IF p_x_line_rec.project_id <> FND_API.G_MISS_NUM THEN
1766:
1767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1768: THEN
1769:
1770: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1771: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');

Line 1772: OE_MSG_PUB.Add;

1768: THEN
1769:
1770: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1771: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
1772: OE_MSG_PUB.Add;
1773:
1774: END IF;
1775:
1776: ELSE

Line 1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1791: THEN
1792:
1793: IF p_x_line_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
1794:
1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1796: THEN
1797:
1798: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');

Line 1800: OE_MSG_PUB.Add;

1796: THEN
1797:
1798: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
1800: OE_MSG_PUB.Add;
1801:
1802: END IF;
1803:
1804: ELSE

Line 1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1821: THEN
1822:
1823: IF p_x_line_rec.rla_schedule_type_code <> FND_API.G_MISS_CHAR THEN
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1826: THEN
1827:
1828: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');

Line 1830: OE_MSG_PUB.Add;

1826: THEN
1827:
1828: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
1830: OE_MSG_PUB.Add;
1831:
1832: END IF;
1833:
1834: ELSE

Line 1854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1850: THEN
1851:
1852: IF p_x_line_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
1853:
1854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1855: THEN
1856:
1857: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 1859: OE_MSG_PUB.Add;

1855: THEN
1856:
1857: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
1859: OE_MSG_PUB.Add;
1860:
1861: END IF;
1862:
1863: ELSE

Line 1882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1878: THEN
1879:
1880: IF p_x_line_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
1881:
1882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1883: THEN
1884:
1885: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');

Line 1887: OE_MSG_PUB.Add;

1883: THEN
1884:
1885: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
1887: OE_MSG_PUB.Add;
1888:
1889: END IF;
1890:
1891: ELSE

Line 1916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1912: THEN
1913:
1914: IF p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
1915:
1916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1917: THEN
1918:
1919: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');

Line 1921: OE_MSG_PUB.Add;

1917: THEN
1918:
1919: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
1921: OE_MSG_PUB.Add;
1922:
1923: END IF;
1924:
1925: ELSE

Line 1949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1945: THEN
1946:
1947: IF p_x_line_rec.task_id <> FND_API.G_MISS_NUM THEN
1948:
1949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1950: THEN
1951:
1952: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');

Line 1954: OE_MSG_PUB.Add;

1950: THEN
1951:
1952: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
1954: OE_MSG_PUB.Add;
1955:
1956: END IF;
1957:
1958: ELSE

Line 1977: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1973: THEN
1974:
1975: IF p_x_line_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
1976:
1977: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1978: THEN
1979:
1980: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');

Line 1982: OE_MSG_PUB.Add;

1978: THEN
1979:
1980: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
1982: OE_MSG_PUB.Add;
1983:
1984: END IF;
1985:
1986: ELSE

Line 2005: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2001: THEN
2002:
2003: IF p_x_line_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
2004:
2005: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2006: THEN
2007:
2008: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');

Line 2010: OE_MSG_PUB.Add;

2006: THEN
2007:
2008: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
2010: OE_MSG_PUB.Add;
2011:
2012: END IF;
2013:
2014: ELSE

Line 2034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2030: THEN
2031:
2032: IF p_x_line_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
2033:
2034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2035: THEN
2036:
2037: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');

Line 2039: OE_MSG_PUB.Add;

2035: THEN
2036:
2037: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
2039: OE_MSG_PUB.Add;
2040:
2041: END IF;
2042:
2043: ELSE

Line 2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2059: THEN
2060:
2061: IF p_x_line_rec.veh_cus_item_cum_key_id <> FND_API.G_MISS_NUM THEN
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2064: THEN
2065:
2066: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');

Line 2068: OE_MSG_PUB.Add;

2064: THEN
2065:
2066: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
2068: OE_MSG_PUB.Add;
2069:
2070: END IF;
2071:
2072: ELSE

Line 2132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2128:
2129: IF p_x_line_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
2130:
2131:
2132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2133: THEN
2134:
2135: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');

Line 2137: OE_MSG_PUB.Add;

2133: THEN
2134:
2135: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
2137: OE_MSG_PUB.Add;
2138:
2139: END IF;
2140:
2141: ELSE

Line 2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2174:
2175: IF p_x_line_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2176:
2177:
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2179: THEN
2180:
2181: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');

Line 2183: OE_MSG_PUB.Add;

2179: THEN
2180:
2181: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
2183: OE_MSG_PUB.Add;
2184:
2185: END IF;
2186:
2187: ELSE

Line 2224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2220:
2221: IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
2222:
2223:
2224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2225: THEN
2226:
2227: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');

Line 2229: OE_MSG_PUB.Add;

2225: THEN
2226:
2227: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
2229: OE_MSG_PUB.Add;
2230:
2231: END IF;
2232:
2233: ELSE

Line 2300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2296:
2297: IF p_x_line_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
2298:
2299:
2300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2301: THEN
2302:
2303: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');

Line 2305: OE_MSG_PUB.Add;

2301: THEN
2302:
2303: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
2305: OE_MSG_PUB.Add;
2306:
2307: END IF;
2308:
2309: ELSE

Line 2331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2327:
2328: IF p_x_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
2329:
2330:
2331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2332: THEN
2333:
2334: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2335: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');

Line 2336: OE_MSG_PUB.Add;

2332: THEN
2333:
2334: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2335: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
2336: OE_MSG_PUB.Add;
2337:
2338: END IF;
2339:
2340: ELSE

Line 2362: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2358:
2359: IF p_x_line_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
2360:
2361:
2362: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2363: THEN
2364:
2365: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');

Line 2367: OE_MSG_PUB.Add;

2363: THEN
2364:
2365: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
2367: OE_MSG_PUB.Add;
2368:
2369: END IF;
2370:
2371: ELSE

Line 2398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2394:
2395: IF p_x_line_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
2396:
2397:
2398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2399: THEN
2400:
2401: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');

Line 2403: OE_MSG_PUB.Add;

2399: THEN
2400:
2401: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
2403: OE_MSG_PUB.Add;
2404:
2405: END IF;
2406:
2407: ELSE

Line 2430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2426: IF p_x_line_rec.end_customer_id <>FND_API.G_MISS_NUM and
2427: p_x_line_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
2428:
2429:
2430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2431: THEN
2432:
2433: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');

Line 2435: OE_MSG_PUB.Add;

2431: THEN
2432:
2433: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
2435: OE_MSG_PUB.Add;
2436:
2437: END IF;
2438:
2439: ELSE

Line 2469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2465:
2466: IF p_x_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
2467:
2468:
2469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2470: THEN
2471:
2472: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');

Line 2474: OE_MSG_PUB.Add;

2470: THEN
2471:
2472: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');
2474: OE_MSG_PUB.Add;
2475:
2476: END IF;
2477:
2478: ELSE

Line 2511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2507: IF p_line_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
2508: THEN
2509: IF p_x_line_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
2510:
2511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2512: THEN
2513:
2514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');

Line 2516: OE_MSG_PUB.Add;

2512: THEN
2513:
2514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
2516: OE_MSG_PUB.Add;
2517:
2518: END IF;
2519:
2520: ELSE

Line 2538: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2534: IF p_line_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
2535: THEN
2536: IF p_x_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
2537:
2538: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2539: THEN
2540:
2541: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');

Line 2543: OE_MSG_PUB.Add;

2539: THEN
2540:
2541: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
2543: OE_MSG_PUB.Add;
2544:
2545: END IF;
2546:
2547: ELSE

Line 2565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2561: IF p_line_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
2562: THEN
2563: IF p_x_line_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
2564:
2565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2566: THEN
2567:
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');

Line 2570: OE_MSG_PUB.Add;

2566: THEN
2567:
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
2570: OE_MSG_PUB.Add;
2571:
2572: END IF;
2573:
2574: ELSE

Line 2626: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2622: IF p_x_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2623:
2624:
2625:
2626: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2627: THEN
2628:
2629: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2631: oe_msg_pub.Add;

2627: THEN
2628:
2629: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2631: oe_msg_pub.Add;
2632:
2633: END IF;
2634:
2635: ELSE

Line 2655: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2651:
2652: IF p_x_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2653:
2654:
2655: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2656: THEN
2657:
2658: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');

Line 2660: oe_msg_pub.Add;

2656: THEN
2657:
2658: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2660: oe_msg_pub.Add;
2661:
2662: END IF;
2663:
2664: ELSE

Line 2704: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2700: THEN
2701:
2702: IF p_x_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2703:
2704: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2705: THEN
2706:
2707: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2709: oe_msg_pub.Add;

2705: THEN
2706:
2707: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2709: oe_msg_pub.Add;
2710:
2711: END IF;
2712:
2713: ELSE

Line 2732: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2728: THEN
2729:
2730: IF p_x_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2731:
2732: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2733: THEN
2734:
2735: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');

Line 2737: oe_msg_pub.Add;

2733: THEN
2734:
2735: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2737: oe_msg_pub.Add;
2738:
2739: END IF;
2740:
2741: ELSE