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.OE_HEADER_UTIL dependencies on OE_MSG_PUB

Line 943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

939: RAISE FND_API.G_EXC_ERROR;
940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: WHEN OTHERS THEN
943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
944: THEN
945: OE_MSG_PUB.Add_Exc_Msg
946: ( G_PKG_NAME
947: , 'Clear_Dependents'

Line 945: OE_MSG_PUB.Add_Exc_Msg

941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: WHEN OTHERS THEN
943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
944: THEN
945: OE_MSG_PUB.Add_Exc_Msg
946: ( G_PKG_NAME
947: , 'Clear_Dependents'
948: );
949: END IF;

Line 1132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1128:
1129: EXCEPTION
1130:
1131: WHEN OTHERS THEN
1132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1133: THEN
1134: OE_MSG_PUB.Add_Exc_Msg
1135: ( G_PKG_NAME
1136: , 'G_MISS_OE_AK_HEADER_REC'

Line 1134: OE_MSG_PUB.Add_Exc_Msg

1130:
1131: WHEN OTHERS THEN
1132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1133: THEN
1134: OE_MSG_PUB.Add_Exc_Msg
1135: ( G_PKG_NAME
1136: , 'G_MISS_OE_AK_HEADER_REC'
1137: );
1138: END IF;

Line 1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1325:
1326: EXCEPTION
1327:
1328: WHEN OTHERS THEN
1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: OE_MSG_PUB.Add_Exc_Msg
1332: ( G_PKG_NAME
1333: , 'API_Rec_To_RowType_Rec'

Line 1331: OE_MSG_PUB.Add_Exc_Msg

1327:
1328: WHEN OTHERS THEN
1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: OE_MSG_PUB.Add_Exc_Msg
1332: ( G_PKG_NAME
1333: , 'API_Rec_To_RowType_Rec'
1334: );
1335: END IF;

Line 1525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1521:
1522: EXCEPTION
1523:
1524: WHEN OTHERS THEN
1525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: OE_MSG_PUB.Add_Exc_Msg
1528: ( G_PKG_NAME
1529: , 'Rowtype_Rec_To_API_Rec'

Line 1527: OE_MSG_PUB.Add_Exc_Msg

1523:
1524: WHEN OTHERS THEN
1525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: OE_MSG_PUB.Add_Exc_Msg
1528: ( G_PKG_NAME
1529: , 'Rowtype_Rec_To_API_Rec'
1530: );
1531: END IF;

Line 1717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1713: RAISE FND_API.G_EXC_ERROR;
1714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: WHEN OTHERS THEN
1717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1718: THEN
1719: OE_MSG_PUB.Add_Exc_Msg
1720: ( G_PKG_NAME
1721: , 'Clear_Dependent_Attr'

Line 1719: OE_MSG_PUB.Add_Exc_Msg

1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: WHEN OTHERS THEN
1717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1718: THEN
1719: OE_MSG_PUB.Add_Exc_Msg
1720: ( G_PKG_NAME
1721: , 'Clear_Dependent_Attr'
1722: );
1723: END IF;

Line 4203: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4199: EXCEPTION
4200:
4201: WHEN OTHERS THEN
4202:
4203: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4204: THEN
4205: OE_MSG_PUB.Add_Exc_Msg
4206: ( G_PKG_NAME
4207: , 'Update_Row'

Line 4205: OE_MSG_PUB.Add_Exc_Msg

4201: WHEN OTHERS THEN
4202:
4203: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4204: THEN
4205: OE_MSG_PUB.Add_Exc_Msg
4206: ( G_PKG_NAME
4207: , 'Update_Row'
4208: );
4209: END IF;

Line 4648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4644: EXCEPTION
4645:
4646: WHEN OTHERS THEN
4647:
4648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4649: THEN
4650: OE_MSG_PUB.Add_Exc_Msg
4651: ( G_PKG_NAME
4652: , 'Insert_Row'

Line 4650: OE_MSG_PUB.Add_Exc_Msg

4646: WHEN OTHERS THEN
4647:
4648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4649: THEN
4650: OE_MSG_PUB.Add_Exc_Msg
4651: ( G_PKG_NAME
4652: , 'Insert_Row'
4653: );
4654: END IF;

Line 4809: OE_MSG_PUB.Count_And_Get

4805:
4806: EXCEPTION
4807: WHEN FND_API.G_EXC_ERROR THEN
4808: --takintoy, added for delete articles
4809: OE_MSG_PUB.Count_And_Get
4810: (
4811: p_count => l_msg_count,
4812: p_data => l_msg_data
4813: );

Line 4817: OE_MSG_PUB.Count_And_Get

4813: );
4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: --takintoy, added for delete articles
4817: OE_MSG_PUB.Count_And_Get
4818: (
4819: p_count => l_msg_count,
4820: p_data => l_msg_data
4821: );

Line 4824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4820: p_data => l_msg_data
4821: );
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: WHEN OTHERS THEN
4824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4825: THEN
4826: OE_MSG_PUB.Add_Exc_Msg
4827: ( G_PKG_NAME
4828: , 'Delete_Row'

Line 4826: OE_MSG_PUB.Add_Exc_Msg

4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: WHEN OTHERS THEN
4824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4825: THEN
4826: OE_MSG_PUB.Add_Exc_Msg
4827: ( G_PKG_NAME
4828: , 'Delete_Row'
4829: );
4830: END IF;

Line 5451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5447: RAISE NO_DATA_FOUND;
5448:
5449: WHEN OTHERS THEN
5450:
5451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5452: THEN
5453: OE_MSG_PUB.Add_Exc_Msg
5454: ( G_PKG_NAME
5455: , 'Query_Row'

Line 5453: OE_MSG_PUB.Add_Exc_Msg

5449: WHEN OTHERS THEN
5450:
5451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5452: THEN
5453: OE_MSG_PUB.Add_Exc_Msg
5454: ( G_PKG_NAME
5455: , 'Query_Row'
5456: );
5457: END IF;

Line 5560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5556:
5557: x_return_status := FND_API.G_RET_STS_ERROR;
5558: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5559:
5560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5561: THEN
5562:
5563: -- Release the lock
5564: ROLLBACK TO Lock_Row;

Line 5567: OE_MSG_PUB.Add;

5563: -- Release the lock
5564: ROLLBACK TO Lock_Row;
5565:
5566: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
5567: OE_MSG_PUB.Add;
5568:
5569: END IF;
5570:
5571: END IF;

Line 5585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5581: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5582:
5583: oe_debug_pub.add('no data found in lock_header', 1);
5584:
5585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5586: THEN
5587:
5588: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5589: OE_MSG_PUB.Add;

Line 5589: OE_MSG_PUB.Add;

5585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5586: THEN
5587:
5588: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5589: OE_MSG_PUB.Add;
5590:
5591: END IF;
5592:
5593: OE_GLOBALS.G_LOCK_TEST := 'N';

Line 5602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5598: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5599:
5600: oe_debug_pub.add('record_lock in lock_header', 1);
5601:
5602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5603: THEN
5604:
5605: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5606: OE_MSG_PUB.Add;

Line 5606: OE_MSG_PUB.Add;

5602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5603: THEN
5604:
5605: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5606: OE_MSG_PUB.Add;
5607:
5608: END IF;
5609: OE_GLOBALS.G_LOCK_TEST := 'N';
5610: WHEN OTHERS THEN

Line 5616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5612: oe_debug_pub.add('others in lock_header', 1);
5613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5614: p_x_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5615:
5616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5617: THEN
5618: OE_MSG_PUB.Add_Exc_Msg
5619: ( G_PKG_NAME
5620: , 'Lock_Row'

Line 5618: OE_MSG_PUB.Add_Exc_Msg

5614: p_x_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5615:
5616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5617: THEN
5618: OE_MSG_PUB.Add_Exc_Msg
5619: ( G_PKG_NAME
5620: , 'Lock_Row'
5621: );
5622: END IF;

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

6185:
6186: IF p_x_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
6187:
6188:
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6190: THEN
6191:
6192: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 6194: OE_MSG_PUB.Add;

6190: THEN
6191:
6192: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6194: OE_MSG_PUB.Add;
6195:
6196: END IF;
6197:
6198: ELSE

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

6215: IF p_x_header_rec.agreement_id <> FND_API.G_MISS_NUM THEN
6216:
6217:
6218:
6219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6220: THEN
6221:
6222: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 6224: OE_MSG_PUB.Add;

6220: THEN
6221:
6222: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6224: OE_MSG_PUB.Add;
6225:
6226: END IF;
6227:
6228: ELSE

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

6244:
6245: IF p_x_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR THEN
6246:
6247:
6248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6249: THEN
6250:
6251: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');

Line 6253: OE_MSG_PUB.Add;

6249: THEN
6250:
6251: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6253: OE_MSG_PUB.Add;
6254:
6255: END IF;
6256:
6257: ELSE

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

6273:
6274: IF p_x_header_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
6275:
6276:
6277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6278: THEN
6279:
6280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');

Line 6282: OE_MSG_PUB.Add;

6278: THEN
6279:
6280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6282: OE_MSG_PUB.Add;
6283:
6284: END IF;
6285:
6286: ELSE

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

6302:
6303: IF p_x_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
6304:
6305:
6306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6307: THEN
6308:
6309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 6311: OE_MSG_PUB.Add;

6307: THEN
6308:
6309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6311: OE_MSG_PUB.Add;
6312:
6313: END IF;
6314:
6315: ELSE

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

6330:
6331: IF p_x_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
6332:
6333:
6334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6335: THEN
6336:
6337: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');

Line 6339: OE_MSG_PUB.Add;

6335: THEN
6336:
6337: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6339: OE_MSG_PUB.Add;
6340:
6341: END IF;
6342:
6343: ELSE

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

6361:
6362: IF p_x_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
6363:
6364:
6365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6366: THEN
6367:
6368: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');

Line 6370: OE_MSG_PUB.Add;

6366: THEN
6367:
6368: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6370: OE_MSG_PUB.Add;
6371:
6372: END IF;
6373:
6374: ELSE

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

6391:
6392: IF p_x_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
6393:
6394:
6395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6396: THEN
6397:
6398: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 6400: OE_MSG_PUB.Add;

6396: THEN
6397:
6398: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6400: OE_MSG_PUB.Add;
6401:
6402: END IF;
6403:
6404: ELSE

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

6420:
6421: IF p_x_header_rec.order_source_id <> FND_API.G_MISS_NUM THEN
6422:
6423:
6424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6425: THEN
6426:
6427: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');

Line 6429: OE_MSG_PUB.Add;

6425: THEN
6426:
6427: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6429: OE_MSG_PUB.Add;
6430:
6431: END IF;
6432:
6433: ELSE

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

6449:
6450: IF p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM THEN
6451:
6452:
6453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6454: THEN
6455:
6456: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6457: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');

Line 6458: OE_MSG_PUB.Add;

6454: THEN
6455:
6456: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6457: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6458: OE_MSG_PUB.Add;
6459:
6460: END IF;
6461:
6462: ELSE

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

6478:
6479: IF p_x_header_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
6480:
6481:
6482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6483: THEN
6484:
6485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');

Line 6487: OE_MSG_PUB.Add;

6483: THEN
6484:
6485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
6487: OE_MSG_PUB.Add;
6488:
6489: END IF;
6490:
6491: ELSE

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

6507:
6508: IF p_x_header_rec.price_list_id <> FND_API.G_MISS_NUM THEN
6509:
6510:
6511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6512: THEN
6513:
6514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 6516: OE_MSG_PUB.Add;

6512: THEN
6513:
6514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6516: OE_MSG_PUB.Add;
6517:
6518: END IF;
6519:
6520: ELSE

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

6536:
6537: IF p_x_header_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
6538:
6539:
6540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6541: THEN
6542:
6543: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');

Line 6545: OE_MSG_PUB.Add;

6541: THEN
6542:
6543: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6545: OE_MSG_PUB.Add;
6546:
6547: END IF;
6548:
6549: ELSE

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

6565:
6566: IF p_x_header_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
6567:
6568:
6569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6570: THEN
6571:
6572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 6574: OE_MSG_PUB.Add;

6570: THEN
6571:
6572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6574: OE_MSG_PUB.Add;
6575:
6576: END IF;
6577:
6578: ELSE

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

6594:
6595: IF p_x_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR THEN
6596:
6597:
6598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6599: THEN
6600:
6601: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');

Line 6603: OE_MSG_PUB.Add;

6599: THEN
6600:
6601: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6603: OE_MSG_PUB.Add;
6604:
6605: END IF;
6606:
6607: ELSE

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

6623:
6624: IF p_x_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
6625:
6626:
6627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6628: THEN
6629:
6630: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');

Line 6632: OE_MSG_PUB.Add;

6628: THEN
6629:
6630: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6632: OE_MSG_PUB.Add;
6633:
6634: END IF;
6635:
6636: ELSE

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

6657:
6658: IF p_x_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
6659:
6660:
6661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6662: THEN
6663:
6664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');

Line 6666: OE_MSG_PUB.Add;

6662: THEN
6663:
6664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
6666: OE_MSG_PUB.Add;
6667:
6668: END IF;
6669:
6670: ELSE

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

6691:
6692: IF p_x_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
6693:
6694:
6695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6696: THEN
6697:
6698: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');

Line 6700: OE_MSG_PUB.Add;

6696: THEN
6697:
6698: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6700: OE_MSG_PUB.Add;
6701:
6702: END IF;
6703:
6704: ELSE

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

6720:
6721: IF p_x_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
6722:
6723:
6724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6725: THEN
6726:
6727: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6728: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');

Line 6729: OE_MSG_PUB.Add;

6725: THEN
6726:
6727: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6728: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6729: OE_MSG_PUB.Add;
6730:
6731: END IF;
6732:
6733: ELSE

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

6749:
6750: IF p_x_header_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
6751:
6752:
6753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6754: THEN
6755:
6756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');

Line 6758: OE_MSG_PUB.Add;

6754: THEN
6755:
6756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6758: OE_MSG_PUB.Add;
6759:
6760: END IF;
6761:
6762: ELSE

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

6778:
6779: IF p_x_header_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
6780:
6781:
6782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6783: THEN
6784:
6785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');

Line 6787: OE_MSG_PUB.Add;

6783: THEN
6784:
6785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6787: OE_MSG_PUB.Add;
6788:
6789: END IF;
6790:
6791: ELSE

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

6807:
6808: IF p_x_header_rec.credit_card_code <> FND_API.G_MISS_CHAR THEN
6809:
6810:
6811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6812: THEN
6813:
6814: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');

Line 6816: OE_MSG_PUB.Add;

6812: THEN
6813:
6814: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
6816: OE_MSG_PUB.Add;
6817:
6818: END IF;
6819:
6820: ELSE

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

6843:
6844: IF p_x_header_rec.invoice_to_customer_id <> FND_API.G_MISS_NUM THEN
6845:
6846:
6847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6848: THEN
6849:
6850: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');

Line 6852: OE_MSG_PUB.Add;

6848: THEN
6849:
6850: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');
6852: OE_MSG_PUB.Add;
6853:
6854: END IF;
6855:
6856: ELSE

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

6879:
6880: IF p_x_header_rec.ship_to_customer_id <> FND_API.G_MISS_NUM THEN
6881:
6882:
6883: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6884: THEN
6885:
6886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');

Line 6888: OE_MSG_PUB.Add;

6884: THEN
6885:
6886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6888: OE_MSG_PUB.Add;
6889:
6890: END IF;
6891:
6892: ELSE

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

6916:
6917: IF p_x_header_rec.deliver_to_customer_id <> FND_API.G_MISS_NUM THEN
6918:
6919:
6920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6921: THEN
6922:
6923: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6924: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');

Line 6925: OE_MSG_PUB.Add;

6921: THEN
6922:
6923: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6924: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6925: OE_MSG_PUB.Add;
6926:
6927: END IF;
6928:
6929: ELSE

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

6953:
6954: IF p_x_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
6955:
6956:
6957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6958: THEN
6959:
6960: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');

Line 6962: OE_MSG_PUB.Add;

6958: THEN
6959:
6960: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6962: OE_MSG_PUB.Add;
6963:
6964: END IF;
6965:
6966: ELSE

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

7002:
7003: IF p_x_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM THEN
7004:
7005:
7006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7007: THEN
7008:
7009: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');

Line 7011: OE_MSG_PUB.Add;

7007: THEN
7008:
7009: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
7011: OE_MSG_PUB.Add;
7012:
7013: END IF;
7014:
7015: ELSE

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

7037:
7038: IF p_x_header_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
7039:
7040:
7041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7042: THEN
7043:
7044: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7045: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');

Line 7046: OE_MSG_PUB.Add;

7042: THEN
7043:
7044: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7045: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
7046: OE_MSG_PUB.Add;
7047:
7048: END IF;
7049:
7050: ELSE

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

7083:
7084: IF p_x_header_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
7085:
7086:
7087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7088: THEN
7089:
7090: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');

Line 7092: OE_MSG_PUB.Add;

7088: THEN
7089:
7090: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
7092: OE_MSG_PUB.Add;
7093:
7094: END IF;
7095:
7096: ELSE

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

7129:
7130: IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
7131:
7132:
7133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7134: THEN
7135:
7136: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');

Line 7138: OE_MSG_PUB.Add;

7134: THEN
7135:
7136: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
7138: OE_MSG_PUB.Add;
7139:
7140: END IF;
7141:
7142: ELSE

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

7176:
7177: IF p_x_header_rec.sold_to_site_use_id <> FND_API.G_MISS_NUM THEN
7178:
7179:
7180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7181: THEN
7182:
7183: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');

Line 7185: OE_MSG_PUB.Add;

7181: THEN
7182:
7183: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7185: OE_MSG_PUB.Add;
7186:
7187: END IF;
7188:
7189: ELSE

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

7254:
7255: IF p_x_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
7256:
7257:
7258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7259: THEN
7260:
7261: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');

Line 7263: OE_MSG_PUB.Add;

7259: THEN
7260:
7261: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7263: OE_MSG_PUB.Add;
7264:
7265: END IF;
7266:
7267: ELSE

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

7284:
7285: IF p_x_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
7286:
7287:
7288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7289: THEN
7290:
7291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');

Line 7293: OE_MSG_PUB.Add;

7289: THEN
7290:
7291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7293: OE_MSG_PUB.Add;
7294:
7295: END IF;
7296:
7297: ELSE

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

7314:
7315: IF p_x_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
7316:
7317:
7318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7319: THEN
7320:
7321: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');

Line 7323: OE_MSG_PUB.Add;

7319: THEN
7320:
7321: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7323: OE_MSG_PUB.Add;
7324:
7325: END IF;
7326:
7327: ELSE

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

7346:
7347: IF p_x_header_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
7348:
7349:
7350: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7351: THEN
7352:
7353: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');

Line 7355: OE_MSG_PUB.Add;

7351: THEN
7352:
7353: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7355: OE_MSG_PUB.Add;
7356:
7357: END IF;
7358:
7359: ELSE

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

7377: IF p_x_header_rec.end_customer_id <>FND_API.G_MISS_NUM and
7378: p_x_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
7379:
7380:
7381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7382: THEN
7383:
7384: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7385: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');

Line 7386: OE_MSG_PUB.Add;

7382: THEN
7383:
7384: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7385: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7386: OE_MSG_PUB.Add;
7387:
7388: END IF;
7389:
7390: ELSE

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

7417:
7418: IF p_x_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
7419:
7420:
7421: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7422: THEN
7423:
7424: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');

Line 7426: OE_MSG_PUB.Add;

7422: THEN
7423:
7424: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7426: OE_MSG_PUB.Add;
7427:
7428: END IF;
7429:
7430: ELSE

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

7460: THEN
7461:
7462: IF p_x_header_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
7463:
7464: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7465: THEN
7466:
7467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');

Line 7469: OE_MSG_PUB.Add;

7465: THEN
7466:
7467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7469: OE_MSG_PUB.Add;
7470:
7471: END IF;
7472:
7473: ELSE

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

7489: THEN
7490:
7491: IF p_x_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
7492:
7493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7494: THEN
7495:
7496: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');

Line 7498: OE_MSG_PUB.Add;

7494: THEN
7495:
7496: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7498: OE_MSG_PUB.Add;
7499:
7500: END IF;
7501:
7502: ELSE

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

7517: IF p_header_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
7518: THEN
7519: IF p_x_header_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
7520:
7521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7522: THEN
7523:
7524: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');

Line 7526: OE_MSG_PUB.Add;

7522: THEN
7523:
7524: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7526: OE_MSG_PUB.Add;
7527:
7528: END IF;
7529:
7530: ELSE

Line 7583: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

7579:
7580: IF p_order_type_id IS NULL OR
7581: p_order_type_id = FND_API.G_MISS_NUM
7582: THEN
7583: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
7584: RETURN NULL;
7585: END IF;
7586:
7587: l_set_of_books_rec :=

Line 7791: OE_MSG_PUB.Add;

7787: THEN
7788: if p_x_header_rec.booked_flag = 'Y' and
7789: nvl(p_x_header_rec.open_flag,'Y') = 'Y' then
7790: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7791: OE_MSG_PUB.Add;
7792: RAISE FND_API.G_EXC_ERROR;
7793: end if;
7794: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7795: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;

Line 7822: OE_MSG_PUB.Add;

7818: if p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
7819: x_doc_sequence_type = 'A'
7820: then
7821: FND_MESSAGE.SET_NAME('ONT','ONT_ORD_NUM_MISMATCH');
7822: OE_MSG_PUB.Add;
7823: RAISE FND_API.G_EXC_ERROR;
7824: end if;
7825:
7826: END IF;

Line 7891: OE_MSG_PUB.Add;

7887:
7888: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7889: IF x_result = FND_SEQNUM.NOTUSED THEN
7890: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7891: OE_MSG_PUB.Add;
7892: RAISE FND_API.G_EXC_ERROR;
7893: END IF;
7894: END IF;
7895: l_doc_seq_type := x_doc_sequence_type;

Line 7937: OE_MSG_PUB.Add;

7933: IF p_x_header_rec.order_number IS NULL THEN
7934: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7936: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7937: OE_MSG_PUB.Add;
7938: RAISE FND_API.G_EXC_ERROR;
7939: ELSE
7940: x_doc_sequence_value := p_x_header_rec.order_number;
7941: END IF;

Line 7947: OE_MSG_PUB.Add;

7943: IF p_x_header_rec.quote_number IS NULL THEN
7944: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7946: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7947: OE_MSG_PUB.Add;
7948: RAISE FND_API.G_EXC_ERROR;
7949: ELSE
7950: x_doc_sequence_value := p_x_header_rec.quote_number;
7951: p_x_header_rec.order_number := x_doc_sequence_value;

Line 7973: OE_MSG_PUB.Add;

7969: and header_id <> p_x_header_rec.header_id;
7970:
7971: IF lcount > 0 THEN
7972: fnd_message.set_name('ONT','OE_ORDER_NUM_EXISTS');
7973: OE_MSG_PUB.Add;
7974: RAISE FND_API.G_EXC_ERROR;
7975: END IF;
7976:
7977: -- Fix for bug# 3526149. Also see bug 3485680

Line 8008: OE_MSG_PUB.Add;

8004: and header_id <> p_x_header_rec.header_id;
8005:
8006: IF lcount > 0 THEN
8007: fnd_message.set_name('ONT','OE_QUOTE_NUM_EXISTS');
8008: OE_MSG_PUB.Add;
8009: RAISE FND_API.G_EXC_ERROR;
8010: END IF;
8011:
8012: -- Fix for bug# 3526149. Also see bug 3485680

Line 8047: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8043: WHEN OTHERS THEN
8044: oe_debug_pub.ADD('Get Order Number-exception ', 1);
8045:
8046:
8047: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8048: THEN
8049: OE_MSG_PUB.Add_Exc_Msg
8050: ( G_PKG_NAME ,
8051: 'Get_Order_Number'

Line 8049: OE_MSG_PUB.Add_Exc_Msg

8045:
8046:
8047: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8048: THEN
8049: OE_MSG_PUB.Add_Exc_Msg
8050: ( G_PKG_NAME ,
8051: 'Get_Order_Number'
8052: );
8053: END IF;

Line 8211: oe_msg_pub.add;

8207: ELSE
8208: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8209: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8210: fnd_message.set_token('OBJECT','ORDER');
8211: oe_msg_pub.add;
8212: RAISE FND_API.G_EXC_ERROR;
8213: END IF;
8214: END IF;
8215: END IF;

Line 8220: oe_msg_pub.add;

8216: ELSE
8217: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8218: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8219: fnd_message.set_token('OBJECT','ORDER');
8220: oe_msg_pub.add;
8221: RAISE FND_API.G_EXC_ERROR;
8222: END IF;
8223: END IF;
8224: END IF;

Line 8233: OE_MSG_PUB.Add;

8229: NOT OE_GLOBALS.Equal(p_x_header_rec.payment_term_id,p_old_header_rec.payment_term_id))
8230: THEN
8231: IF OE_PREPAYMENT_UTIL.Is_Prepaid_Order(p_x_header_rec) = 'Y' THEN
8232: FND_MESSAGE.SET_NAME('ONT', 'ONT_USE_HDR_TERMS_FOR_INVOICE');
8233: OE_MSG_PUB.Add;
8234: END IF;
8235: END IF;
8236: /* END PREPAYMENT */
8237: -- Included to fix bug 1589196 Begin

Line 8247: OE_MSG_PUB.Add;

8243: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8244: CLOSE C_HSC_COUNT;
8245: if l_sales_crd_cnt > 1 then
8246: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
8247: OE_MSG_PUB.Add;
8248: RAISE FND_API.G_EXC_ERROR;
8249: end if;
8250: END IF;
8251: END IF;

Line 8508: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');

8504: RAISE FND_API.G_EXC_ERROR;
8505: END IF;
8506:
8507:
8508: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8509: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8510: --bug 4190357 added l_meaning to the token
8511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8512: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);

Line 8513: OE_MSG_PUB.Add;

8509: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8510: --bug 4190357 added l_meaning to the token
8511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8512: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8513: OE_MSG_PUB.Add;
8514: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8515:
8516: oe_debug_pub.add('Value of shipping Method:'
8517: ||p_x_header_rec.shipping_method_code,2);

Line 8514: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

8510: --bug 4190357 added l_meaning to the token
8511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8512: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8513: OE_MSG_PUB.Add;
8514: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8515:
8516: oe_debug_pub.add('Value of shipping Method:'
8517: ||p_x_header_rec.shipping_method_code,2);
8518:

Line 8878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8874:
8875: OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL := FALSE;
8876: -- Adding this for IR ISO Tracking bug 7667702
8877:
8878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8879: THEN
8880: OE_MSG_PUB.Add_Exc_Msg
8881: ( G_PKG_NAME
8882: , 'Pre_Write_Process'

Line 8880: OE_MSG_PUB.Add_Exc_Msg

8876: -- Adding this for IR ISO Tracking bug 7667702
8877:
8878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8879: THEN
8880: OE_MSG_PUB.Add_Exc_Msg
8881: ( G_PKG_NAME
8882: , 'Pre_Write_Process'
8883: );
8884: END IF;

Line 9266: OE_MSG_PUB.Add;

9262: IF p_x_header_rec.contract_source_doc_type_code IS NOT NULL AND
9263: p_x_header_rec.Contract_Template_Id IS NULL AND
9264: p_x_header_rec.contract_source_document_id IS NULL THEN
9265: fnd_message.set_name('ONT','OE_INVALID_CONTRACT_ATTR_COMB');
9266: OE_MSG_PUB.Add;
9267: END IF;
9268:
9269: OE_CONTRACTS_UTIL.Copy_Doc(
9270: p_api_version => 1.0,

Line 9577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9573: RAISE FND_API.G_EXC_ERROR;
9574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9576: WHEN OTHERS THEN
9577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9578: THEN
9579: OE_MSG_PUB.Add_Exc_Msg
9580: ( G_PKG_NAME
9581: , 'Post_Write_Process'

Line 9579: OE_MSG_PUB.Add_Exc_Msg

9575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9576: WHEN OTHERS THEN
9577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9578: THEN
9579: OE_MSG_PUB.Add_Exc_Msg
9580: ( G_PKG_NAME
9581: , 'Post_Write_Process'
9582: );
9583: END IF;

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

9702: EXCEPTION
9703:
9704: WHEN NO_DATA_FOUND THEN
9705:
9706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9707: THEN
9708:
9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');

Line 9711: OE_MSG_PUB.Add;

9707: THEN
9708:
9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9711: OE_MSG_PUB.Add;
9712:
9713: END IF;
9714:
9715:

Line 9718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9714:
9715:
9716: WHEN OTHERS THEN
9717:
9718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9719: THEN
9720: OE_MSG_PUB.Add_Exc_Msg
9721: ( G_PKG_NAME
9722: , 'get_customer_details'

Line 9720: OE_MSG_PUB.Add_Exc_Msg

9716: WHEN OTHERS THEN
9717:
9718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9719: THEN
9720: OE_MSG_PUB.Add_Exc_Msg
9721: ( G_PKG_NAME
9722: , 'get_customer_details'
9723: );
9724: END IF;

Line 9897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9893: EXCEPTION
9894:
9895: WHEN OTHERS THEN
9896:
9897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9898: THEN
9899: OE_MSG_PUB.Add_Exc_Msg
9900: ( G_PKG_NAME
9901: , 'Blkt_Req_For_Curr_Upd_And_Del'

Line 9899: OE_MSG_PUB.Add_Exc_Msg

9895: WHEN OTHERS THEN
9896:
9897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9898: THEN
9899: OE_MSG_PUB.Add_Exc_Msg
9900: ( G_PKG_NAME
9901: , 'Blkt_Req_For_Curr_Upd_And_Del'
9902: );
9903: END IF;

Line 9989: OE_MSG_PUB.set_msg_context(

9985: END;
9986: END IF;
9987:
9988:
9989: OE_MSG_PUB.set_msg_context(
9990: p_entity_code => 'HEADER'
9991: ,p_entity_id => p_x_header_rec.header_id
9992: ,p_header_id => p_x_header_rec.header_id
9993: ,p_line_id => null

Line 10098: OE_MSG_PUB.reset_msg_context('HEADER');

10094:
10095: OE_CUSTOMER_INFO_PVT.G_SOLD_TO_CUSTOMER_ID := x_sold_to_customer_id;
10096: OE_CUSTOMER_INFO_PVT.G_SOLD_TO_CONTACT_ID := x_sold_to_contact_id;
10097:
10098: OE_MSG_PUB.reset_msg_context('HEADER');
10099:
10100:
10101: IF l_debug_level >0 then
10102:

Line 10130: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10126:
10127: WHEN OTHERS THEN
10128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10129:
10130: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10131: THEN
10132: OE_MSG_PUB.Add_Exc_Msg
10133: ( G_PKG_NAME
10134: , 'Get_customer_info_ids'

Line 10132: OE_MSG_PUB.Add_Exc_Msg

10128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10129:
10130: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10131: THEN
10132: OE_MSG_PUB.Add_Exc_Msg
10133: ( G_PKG_NAME
10134: , 'Get_customer_info_ids'
10135: );
10136: END IF;