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 912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

908: RAISE FND_API.G_EXC_ERROR;
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: WHEN OTHERS THEN
912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: OE_MSG_PUB.Add_Exc_Msg
915: ( G_PKG_NAME
916: , 'Clear_Dependents'

Line 914: OE_MSG_PUB.Add_Exc_Msg

910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: WHEN OTHERS THEN
912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: OE_MSG_PUB.Add_Exc_Msg
915: ( G_PKG_NAME
916: , 'Clear_Dependents'
917: );
918: END IF;

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

1097:
1098: EXCEPTION
1099:
1100: WHEN OTHERS THEN
1101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1102: THEN
1103: OE_MSG_PUB.Add_Exc_Msg
1104: ( G_PKG_NAME
1105: , 'G_MISS_OE_AK_HEADER_REC'

Line 1103: OE_MSG_PUB.Add_Exc_Msg

1099:
1100: WHEN OTHERS THEN
1101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1102: THEN
1103: OE_MSG_PUB.Add_Exc_Msg
1104: ( G_PKG_NAME
1105: , 'G_MISS_OE_AK_HEADER_REC'
1106: );
1107: END IF;

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

1294:
1295: EXCEPTION
1296:
1297: WHEN OTHERS THEN
1298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1299: THEN
1300: OE_MSG_PUB.Add_Exc_Msg
1301: ( G_PKG_NAME
1302: , 'API_Rec_To_RowType_Rec'

Line 1300: OE_MSG_PUB.Add_Exc_Msg

1296:
1297: WHEN OTHERS THEN
1298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1299: THEN
1300: OE_MSG_PUB.Add_Exc_Msg
1301: ( G_PKG_NAME
1302: , 'API_Rec_To_RowType_Rec'
1303: );
1304: END IF;

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

1490:
1491: EXCEPTION
1492:
1493: WHEN OTHERS THEN
1494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: OE_MSG_PUB.Add_Exc_Msg
1497: ( G_PKG_NAME
1498: , 'Rowtype_Rec_To_API_Rec'

Line 1496: OE_MSG_PUB.Add_Exc_Msg

1492:
1493: WHEN OTHERS THEN
1494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: OE_MSG_PUB.Add_Exc_Msg
1497: ( G_PKG_NAME
1498: , 'Rowtype_Rec_To_API_Rec'
1499: );
1500: END IF;

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

1682: RAISE FND_API.G_EXC_ERROR;
1683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: WHEN OTHERS THEN
1686: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: OE_MSG_PUB.Add_Exc_Msg
1689: ( G_PKG_NAME
1690: , 'Clear_Dependent_Attr'

Line 1688: OE_MSG_PUB.Add_Exc_Msg

1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: WHEN OTHERS THEN
1686: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: OE_MSG_PUB.Add_Exc_Msg
1689: ( G_PKG_NAME
1690: , 'Clear_Dependent_Attr'
1691: );
1692: END IF;

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

4050: EXCEPTION
4051:
4052: WHEN OTHERS THEN
4053:
4054: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4055: THEN
4056: OE_MSG_PUB.Add_Exc_Msg
4057: ( G_PKG_NAME
4058: , 'Update_Row'

Line 4056: OE_MSG_PUB.Add_Exc_Msg

4052: WHEN OTHERS THEN
4053:
4054: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4055: THEN
4056: OE_MSG_PUB.Add_Exc_Msg
4057: ( G_PKG_NAME
4058: , 'Update_Row'
4059: );
4060: END IF;

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

4495: EXCEPTION
4496:
4497: WHEN OTHERS THEN
4498:
4499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4500: THEN
4501: OE_MSG_PUB.Add_Exc_Msg
4502: ( G_PKG_NAME
4503: , 'Insert_Row'

Line 4501: OE_MSG_PUB.Add_Exc_Msg

4497: WHEN OTHERS THEN
4498:
4499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4500: THEN
4501: OE_MSG_PUB.Add_Exc_Msg
4502: ( G_PKG_NAME
4503: , 'Insert_Row'
4504: );
4505: END IF;

Line 4659: OE_MSG_PUB.Count_And_Get

4655:
4656: EXCEPTION
4657: WHEN FND_API.G_EXC_ERROR THEN
4658: --takintoy, added for delete articles
4659: OE_MSG_PUB.Count_And_Get
4660: (
4661: p_count => l_msg_count,
4662: p_data => l_msg_data
4663: );

Line 4667: OE_MSG_PUB.Count_And_Get

4663: );
4664: RAISE FND_API.G_EXC_ERROR;
4665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4666: --takintoy, added for delete articles
4667: OE_MSG_PUB.Count_And_Get
4668: (
4669: p_count => l_msg_count,
4670: p_data => l_msg_data
4671: );

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

4670: p_data => l_msg_data
4671: );
4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: WHEN OTHERS THEN
4674: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4675: THEN
4676: OE_MSG_PUB.Add_Exc_Msg
4677: ( G_PKG_NAME
4678: , 'Delete_Row'

Line 4676: OE_MSG_PUB.Add_Exc_Msg

4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: WHEN OTHERS THEN
4674: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4675: THEN
4676: OE_MSG_PUB.Add_Exc_Msg
4677: ( G_PKG_NAME
4678: , 'Delete_Row'
4679: );
4680: END IF;

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

5297: RAISE NO_DATA_FOUND;
5298:
5299: WHEN OTHERS THEN
5300:
5301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5302: THEN
5303: OE_MSG_PUB.Add_Exc_Msg
5304: ( G_PKG_NAME
5305: , 'Query_Row'

Line 5303: OE_MSG_PUB.Add_Exc_Msg

5299: WHEN OTHERS THEN
5300:
5301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5302: THEN
5303: OE_MSG_PUB.Add_Exc_Msg
5304: ( G_PKG_NAME
5305: , 'Query_Row'
5306: );
5307: END IF;

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

5406:
5407: x_return_status := FND_API.G_RET_STS_ERROR;
5408: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5409:
5410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5411: THEN
5412:
5413: -- Release the lock
5414: ROLLBACK TO Lock_Row;

Line 5417: OE_MSG_PUB.Add;

5413: -- Release the lock
5414: ROLLBACK TO Lock_Row;
5415:
5416: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
5417: OE_MSG_PUB.Add;
5418:
5419: END IF;
5420:
5421: END IF;

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

5431: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5432:
5433: oe_debug_pub.add('no data found in lock_header', 1);
5434:
5435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5436: THEN
5437:
5438: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5439: OE_MSG_PUB.Add;

Line 5439: OE_MSG_PUB.Add;

5435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5436: THEN
5437:
5438: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5439: OE_MSG_PUB.Add;
5440:
5441: END IF;
5442:
5443: OE_GLOBALS.G_LOCK_TEST := 'N';

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

5448: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
5449:
5450: oe_debug_pub.add('record_lock in lock_header', 1);
5451:
5452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5453: THEN
5454:
5455: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5456: OE_MSG_PUB.Add;

Line 5456: OE_MSG_PUB.Add;

5452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5453: THEN
5454:
5455: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5456: OE_MSG_PUB.Add;
5457:
5458: END IF;
5459: OE_GLOBALS.G_LOCK_TEST := 'N';
5460: WHEN OTHERS THEN

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

5462: oe_debug_pub.add('others in lock_header', 1);
5463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5464: p_x_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5465:
5466: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5467: THEN
5468: OE_MSG_PUB.Add_Exc_Msg
5469: ( G_PKG_NAME
5470: , 'Lock_Row'

Line 5468: OE_MSG_PUB.Add_Exc_Msg

5464: p_x_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5465:
5466: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5467: THEN
5468: OE_MSG_PUB.Add_Exc_Msg
5469: ( G_PKG_NAME
5470: , 'Lock_Row'
5471: );
5472: END IF;

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

6035:
6036: IF p_x_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
6037:
6038:
6039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6040: THEN
6041:
6042: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 6044: OE_MSG_PUB.Add;

6040: THEN
6041:
6042: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6044: OE_MSG_PUB.Add;
6045:
6046: END IF;
6047:
6048: ELSE

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

6065: IF p_x_header_rec.agreement_id <> FND_API.G_MISS_NUM THEN
6066:
6067:
6068:
6069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6070: THEN
6071:
6072: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 6074: OE_MSG_PUB.Add;

6070: THEN
6071:
6072: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6074: OE_MSG_PUB.Add;
6075:
6076: END IF;
6077:
6078: ELSE

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

6094:
6095: IF p_x_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR THEN
6096:
6097:
6098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6099: THEN
6100:
6101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');

Line 6103: OE_MSG_PUB.Add;

6099: THEN
6100:
6101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6103: OE_MSG_PUB.Add;
6104:
6105: END IF;
6106:
6107: ELSE

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

6123:
6124: IF p_x_header_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
6125:
6126:
6127: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6128: THEN
6129:
6130: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');

Line 6132: OE_MSG_PUB.Add;

6128: THEN
6129:
6130: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6132: OE_MSG_PUB.Add;
6133:
6134: END IF;
6135:
6136: ELSE

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

6152:
6153: IF p_x_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
6154:
6155:
6156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6157: THEN
6158:
6159: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6160: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 6161: OE_MSG_PUB.Add;

6157: THEN
6158:
6159: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6160: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6161: OE_MSG_PUB.Add;
6162:
6163: END IF;
6164:
6165: ELSE

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

6180:
6181: IF p_x_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
6182:
6183:
6184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6185: THEN
6186:
6187: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');

Line 6189: OE_MSG_PUB.Add;

6185: THEN
6186:
6187: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6189: OE_MSG_PUB.Add;
6190:
6191: END IF;
6192:
6193: ELSE

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

6211:
6212: IF p_x_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
6213:
6214:
6215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6216: THEN
6217:
6218: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');

Line 6220: OE_MSG_PUB.Add;

6216: THEN
6217:
6218: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6220: OE_MSG_PUB.Add;
6221:
6222: END IF;
6223:
6224: ELSE

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

6241:
6242: IF p_x_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
6243:
6244:
6245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6246: THEN
6247:
6248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 6250: OE_MSG_PUB.Add;

6246: THEN
6247:
6248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6250: OE_MSG_PUB.Add;
6251:
6252: END IF;
6253:
6254: ELSE

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

6270:
6271: IF p_x_header_rec.order_source_id <> FND_API.G_MISS_NUM THEN
6272:
6273:
6274: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6275: THEN
6276:
6277: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');

Line 6279: OE_MSG_PUB.Add;

6275: THEN
6276:
6277: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6279: OE_MSG_PUB.Add;
6280:
6281: END IF;
6282:
6283: ELSE

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

6299:
6300: IF p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM THEN
6301:
6302:
6303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6304: THEN
6305:
6306: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');

Line 6308: OE_MSG_PUB.Add;

6304: THEN
6305:
6306: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6308: OE_MSG_PUB.Add;
6309:
6310: END IF;
6311:
6312: ELSE

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

6328:
6329: IF p_x_header_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
6330:
6331:
6332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6333: THEN
6334:
6335: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');

Line 6337: OE_MSG_PUB.Add;

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

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

6357:
6358: IF p_x_header_rec.price_list_id <> FND_API.G_MISS_NUM THEN
6359:
6360:
6361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6362: THEN
6363:
6364: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 6366: OE_MSG_PUB.Add;

6362: THEN
6363:
6364: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6366: OE_MSG_PUB.Add;
6367:
6368: END IF;
6369:
6370: ELSE

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

6386:
6387: IF p_x_header_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
6388:
6389:
6390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6391: THEN
6392:
6393: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');

Line 6395: OE_MSG_PUB.Add;

6391: THEN
6392:
6393: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6395: OE_MSG_PUB.Add;
6396:
6397: END IF;
6398:
6399: ELSE

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

6415:
6416: IF p_x_header_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
6417:
6418:
6419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6420: THEN
6421:
6422: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 6424: OE_MSG_PUB.Add;

6420: THEN
6421:
6422: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6424: OE_MSG_PUB.Add;
6425:
6426: END IF;
6427:
6428: ELSE

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

6444:
6445: IF p_x_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR THEN
6446:
6447:
6448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6449: THEN
6450:
6451: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');

Line 6453: OE_MSG_PUB.Add;

6449: THEN
6450:
6451: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6453: OE_MSG_PUB.Add;
6454:
6455: END IF;
6456:
6457: ELSE

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

6473:
6474: IF p_x_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
6475:
6476:
6477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6478: THEN
6479:
6480: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');

Line 6482: OE_MSG_PUB.Add;

6478: THEN
6479:
6480: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6482: OE_MSG_PUB.Add;
6483:
6484: END IF;
6485:
6486: ELSE

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

6507:
6508: IF p_x_header_rec.ship_from_org_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','ship_from_org');

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','ship_from_org');
6516: OE_MSG_PUB.Add;
6517:
6518: END IF;
6519:
6520: ELSE

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

6541:
6542: IF p_x_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
6543:
6544:
6545: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6546: THEN
6547:
6548: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');

Line 6550: OE_MSG_PUB.Add;

6546: THEN
6547:
6548: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6550: OE_MSG_PUB.Add;
6551:
6552: END IF;
6553:
6554: ELSE

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

6570:
6571: IF p_x_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
6572:
6573:
6574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6575: THEN
6576:
6577: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');

Line 6579: OE_MSG_PUB.Add;

6575: THEN
6576:
6577: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6579: OE_MSG_PUB.Add;
6580:
6581: END IF;
6582:
6583: ELSE

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

6599:
6600: IF p_x_header_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
6601:
6602:
6603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6604: THEN
6605:
6606: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');

Line 6608: OE_MSG_PUB.Add;

6604: THEN
6605:
6606: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6608: OE_MSG_PUB.Add;
6609:
6610: END IF;
6611:
6612: ELSE

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

6628:
6629: IF p_x_header_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
6630:
6631:
6632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6633: THEN
6634:
6635: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');

Line 6637: OE_MSG_PUB.Add;

6633: THEN
6634:
6635: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6637: OE_MSG_PUB.Add;
6638:
6639: END IF;
6640:
6641: ELSE

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

6657:
6658: IF p_x_header_rec.credit_card_code <> FND_API.G_MISS_CHAR 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','credit_card');

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','credit_card');
6666: OE_MSG_PUB.Add;
6667:
6668: END IF;
6669:
6670: ELSE

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

6693:
6694: IF p_x_header_rec.invoice_to_customer_id <> FND_API.G_MISS_NUM THEN
6695:
6696:
6697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6698: THEN
6699:
6700: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');

Line 6702: OE_MSG_PUB.Add;

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

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

6729:
6730: IF p_x_header_rec.ship_to_customer_id <> FND_API.G_MISS_NUM THEN
6731:
6732:
6733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6734: THEN
6735:
6736: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');

Line 6738: OE_MSG_PUB.Add;

6734: THEN
6735:
6736: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6738: OE_MSG_PUB.Add;
6739:
6740: END IF;
6741:
6742: ELSE

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

6766:
6767: IF p_x_header_rec.deliver_to_customer_id <> FND_API.G_MISS_NUM THEN
6768:
6769:
6770: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6771: THEN
6772:
6773: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');

Line 6775: OE_MSG_PUB.Add;

6771: THEN
6772:
6773: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6775: OE_MSG_PUB.Add;
6776:
6777: END IF;
6778:
6779: ELSE

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

6803:
6804: IF p_x_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
6805:
6806:
6807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6808: THEN
6809:
6810: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');

Line 6812: OE_MSG_PUB.Add;

6808: THEN
6809:
6810: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6812: OE_MSG_PUB.Add;
6813:
6814: END IF;
6815:
6816: ELSE

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

6852:
6853: IF p_x_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM THEN
6854:
6855:
6856: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6857: THEN
6858:
6859: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');

Line 6861: OE_MSG_PUB.Add;

6857: THEN
6858:
6859: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
6861: OE_MSG_PUB.Add;
6862:
6863: END IF;
6864:
6865: ELSE

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

6887:
6888: IF p_x_header_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
6889:
6890:
6891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6892: THEN
6893:
6894: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');

Line 6896: OE_MSG_PUB.Add;

6892: THEN
6893:
6894: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
6896: OE_MSG_PUB.Add;
6897:
6898: END IF;
6899:
6900: ELSE

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

6933:
6934: IF p_x_header_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
6935:
6936:
6937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6938: THEN
6939:
6940: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');

Line 6942: OE_MSG_PUB.Add;

6938: THEN
6939:
6940: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
6942: OE_MSG_PUB.Add;
6943:
6944: END IF;
6945:
6946: ELSE

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

6979:
6980: IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
6981:
6982:
6983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6984: THEN
6985:
6986: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6987: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');

Line 6988: OE_MSG_PUB.Add;

6984: THEN
6985:
6986: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6987: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
6988: OE_MSG_PUB.Add;
6989:
6990: END IF;
6991:
6992: ELSE

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

7026:
7027: IF p_x_header_rec.sold_to_site_use_id <> FND_API.G_MISS_NUM THEN
7028:
7029:
7030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7031: THEN
7032:
7033: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7034: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');

Line 7035: OE_MSG_PUB.Add;

7031: THEN
7032:
7033: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7034: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7035: OE_MSG_PUB.Add;
7036:
7037: END IF;
7038:
7039: ELSE

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

7102:
7103: IF p_x_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
7104:
7105:
7106: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7107: THEN
7108:
7109: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');

Line 7111: OE_MSG_PUB.Add;

7107: THEN
7108:
7109: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7111: OE_MSG_PUB.Add;
7112:
7113: END IF;
7114:
7115: ELSE

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

7132:
7133: IF p_x_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
7134:
7135:
7136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7137: THEN
7138:
7139: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');

Line 7141: OE_MSG_PUB.Add;

7137: THEN
7138:
7139: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7141: OE_MSG_PUB.Add;
7142:
7143: END IF;
7144:
7145: ELSE

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

7162:
7163: IF p_x_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
7164:
7165:
7166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7167: THEN
7168:
7169: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');

Line 7171: OE_MSG_PUB.Add;

7167: THEN
7168:
7169: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7171: OE_MSG_PUB.Add;
7172:
7173: END IF;
7174:
7175: ELSE

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

7194:
7195: IF p_x_header_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
7196:
7197:
7198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7199: THEN
7200:
7201: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');

Line 7203: OE_MSG_PUB.Add;

7199: THEN
7200:
7201: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7203: OE_MSG_PUB.Add;
7204:
7205: END IF;
7206:
7207: ELSE

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

7225: IF p_x_header_rec.end_customer_id <>FND_API.G_MISS_NUM and
7226: p_x_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
7227:
7228:
7229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7230: THEN
7231:
7232: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');

Line 7234: OE_MSG_PUB.Add;

7230: THEN
7231:
7232: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7234: OE_MSG_PUB.Add;
7235:
7236: END IF;
7237:
7238: ELSE

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

7265:
7266: IF p_x_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
7267:
7268:
7269: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7270: THEN
7271:
7272: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');

Line 7274: OE_MSG_PUB.Add;

7270: THEN
7271:
7272: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7274: OE_MSG_PUB.Add;
7275:
7276: END IF;
7277:
7278: ELSE

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

7308: THEN
7309:
7310: IF p_x_header_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
7311:
7312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7313: THEN
7314:
7315: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');

Line 7317: OE_MSG_PUB.Add;

7313: THEN
7314:
7315: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7317: OE_MSG_PUB.Add;
7318:
7319: END IF;
7320:
7321: ELSE

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

7337: THEN
7338:
7339: IF p_x_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
7340:
7341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7342: THEN
7343:
7344: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');

Line 7346: OE_MSG_PUB.Add;

7342: THEN
7343:
7344: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7346: OE_MSG_PUB.Add;
7347:
7348: END IF;
7349:
7350: ELSE

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

7365: IF p_header_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
7366: THEN
7367: IF p_x_header_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
7368:
7369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7370: THEN
7371:
7372: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');

Line 7374: OE_MSG_PUB.Add;

7370: THEN
7371:
7372: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7374: OE_MSG_PUB.Add;
7375:
7376: END IF;
7377:
7378: ELSE

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

7427:
7428: IF p_order_type_id IS NULL OR
7429: p_order_type_id = FND_API.G_MISS_NUM
7430: THEN
7431: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
7432: RETURN NULL;
7433: END IF;
7434:
7435: l_set_of_books_rec :=

Line 7639: OE_MSG_PUB.Add;

7635: THEN
7636: if p_x_header_rec.booked_flag = 'Y' and
7637: nvl(p_x_header_rec.open_flag,'Y') = 'Y' then
7638: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7639: OE_MSG_PUB.Add;
7640: RAISE FND_API.G_EXC_ERROR;
7641: end if;
7642: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7643: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;

Line 7670: OE_MSG_PUB.Add;

7666: if p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
7667: x_doc_sequence_type = 'A'
7668: then
7669: FND_MESSAGE.SET_NAME('ONT','ONT_ORD_NUM_MISMATCH');
7670: OE_MSG_PUB.Add;
7671: RAISE FND_API.G_EXC_ERROR;
7672: end if;
7673:
7674: END IF;

Line 7739: OE_MSG_PUB.Add;

7735:
7736: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7737: IF x_result = FND_SEQNUM.NOTUSED THEN
7738: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7739: OE_MSG_PUB.Add;
7740: RAISE FND_API.G_EXC_ERROR;
7741: END IF;
7742: END IF;
7743: l_doc_seq_type := x_doc_sequence_type;

Line 7785: OE_MSG_PUB.Add;

7781: IF p_x_header_rec.order_number IS NULL THEN
7782: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7784: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7785: OE_MSG_PUB.Add;
7786: RAISE FND_API.G_EXC_ERROR;
7787: ELSE
7788: x_doc_sequence_value := p_x_header_rec.order_number;
7789: END IF;

Line 7795: OE_MSG_PUB.Add;

7791: IF p_x_header_rec.quote_number IS NULL THEN
7792: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7793: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7794: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7795: OE_MSG_PUB.Add;
7796: RAISE FND_API.G_EXC_ERROR;
7797: ELSE
7798: x_doc_sequence_value := p_x_header_rec.quote_number;
7799: p_x_header_rec.order_number := x_doc_sequence_value;

Line 7821: OE_MSG_PUB.Add;

7817: and header_id <> p_x_header_rec.header_id;
7818:
7819: IF lcount > 0 THEN
7820: fnd_message.set_name('ONT','OE_ORDER_NUM_EXISTS');
7821: OE_MSG_PUB.Add;
7822: RAISE FND_API.G_EXC_ERROR;
7823: END IF;
7824:
7825: -- Fix for bug# 3526149. Also see bug 3485680

Line 7856: OE_MSG_PUB.Add;

7852: and header_id <> p_x_header_rec.header_id;
7853:
7854: IF lcount > 0 THEN
7855: fnd_message.set_name('ONT','OE_QUOTE_NUM_EXISTS');
7856: OE_MSG_PUB.Add;
7857: RAISE FND_API.G_EXC_ERROR;
7858: END IF;
7859:
7860: -- Fix for bug# 3526149. Also see bug 3485680

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

7891: WHEN OTHERS THEN
7892: oe_debug_pub.ADD('Get Order Number-exception ', 1);
7893:
7894:
7895: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7896: THEN
7897: OE_MSG_PUB.Add_Exc_Msg
7898: ( G_PKG_NAME ,
7899: 'Get_Order_Number'

Line 7897: OE_MSG_PUB.Add_Exc_Msg

7893:
7894:
7895: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7896: THEN
7897: OE_MSG_PUB.Add_Exc_Msg
7898: ( G_PKG_NAME ,
7899: 'Get_Order_Number'
7900: );
7901: END IF;

Line 8026: oe_msg_pub.add;

8022: ELSE
8023: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8024: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8025: fnd_message.set_token('OBJECT','ORDER');
8026: oe_msg_pub.add;
8027: RAISE FND_API.G_EXC_ERROR;
8028: END IF;
8029: END IF;
8030: END IF;

Line 8035: oe_msg_pub.add;

8031: ELSE
8032: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8033: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8034: fnd_message.set_token('OBJECT','ORDER');
8035: oe_msg_pub.add;
8036: RAISE FND_API.G_EXC_ERROR;
8037: END IF;
8038: END IF;
8039: END IF;

Line 8048: OE_MSG_PUB.Add;

8044: NOT OE_GLOBALS.Equal(p_x_header_rec.payment_term_id,p_old_header_rec.payment_term_id))
8045: THEN
8046: IF OE_PREPAYMENT_UTIL.Is_Prepaid_Order(p_x_header_rec) = 'Y' THEN
8047: FND_MESSAGE.SET_NAME('ONT', 'ONT_USE_HDR_TERMS_FOR_INVOICE');
8048: OE_MSG_PUB.Add;
8049: END IF;
8050: END IF;
8051: /* END PREPAYMENT */
8052: -- Included to fix bug 1589196 Begin

Line 8062: OE_MSG_PUB.Add;

8058: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8059: CLOSE C_HSC_COUNT;
8060: if l_sales_crd_cnt > 1 then
8061: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
8062: OE_MSG_PUB.Add;
8063: RAISE FND_API.G_EXC_ERROR;
8064: end if;
8065: END IF;
8066: END IF;

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

8316: RAISE FND_API.G_EXC_ERROR;
8317: END IF;
8318:
8319:
8320: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8321: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8322: --bug 4190357 added l_meaning to the token
8323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8324: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);

Line 8325: OE_MSG_PUB.Add;

8321: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8322: --bug 4190357 added l_meaning to the token
8323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8324: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8325: OE_MSG_PUB.Add;
8326: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8327:
8328: oe_debug_pub.add('Value of shipping Method:'
8329: ||p_x_header_rec.shipping_method_code,2);

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

8322: --bug 4190357 added l_meaning to the token
8323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8324: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8325: OE_MSG_PUB.Add;
8326: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8327:
8328: oe_debug_pub.add('Value of shipping Method:'
8329: ||p_x_header_rec.shipping_method_code,2);
8330:

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

8681:
8682: OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL := FALSE;
8683: -- Adding this for IR ISO Tracking bug 7667702
8684:
8685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8686: THEN
8687: OE_MSG_PUB.Add_Exc_Msg
8688: ( G_PKG_NAME
8689: , 'Pre_Write_Process'

Line 8687: OE_MSG_PUB.Add_Exc_Msg

8683: -- Adding this for IR ISO Tracking bug 7667702
8684:
8685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8686: THEN
8687: OE_MSG_PUB.Add_Exc_Msg
8688: ( G_PKG_NAME
8689: , 'Pre_Write_Process'
8690: );
8691: END IF;

Line 9050: OE_MSG_PUB.Add;

9046: IF p_x_header_rec.contract_source_doc_type_code IS NOT NULL AND
9047: p_x_header_rec.Contract_Template_Id IS NULL AND
9048: p_x_header_rec.contract_source_document_id IS NULL THEN
9049: fnd_message.set_name('ONT','OE_INVALID_CONTRACT_ATTR_COMB');
9050: OE_MSG_PUB.Add;
9051: END IF;
9052:
9053: OE_CONTRACTS_UTIL.Copy_Doc(
9054: p_api_version => 1.0,

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

9355: RAISE FND_API.G_EXC_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9358: WHEN OTHERS THEN
9359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9360: THEN
9361: OE_MSG_PUB.Add_Exc_Msg
9362: ( G_PKG_NAME
9363: , 'Post_Write_Process'

Line 9361: OE_MSG_PUB.Add_Exc_Msg

9357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9358: WHEN OTHERS THEN
9359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9360: THEN
9361: OE_MSG_PUB.Add_Exc_Msg
9362: ( G_PKG_NAME
9363: , 'Post_Write_Process'
9364: );
9365: END IF;

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

9484: EXCEPTION
9485:
9486: WHEN NO_DATA_FOUND THEN
9487:
9488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9489: THEN
9490:
9491: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');

Line 9493: OE_MSG_PUB.Add;

9489: THEN
9490:
9491: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9493: OE_MSG_PUB.Add;
9494:
9495: END IF;
9496:
9497:

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

9496:
9497:
9498: WHEN OTHERS THEN
9499:
9500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9501: THEN
9502: OE_MSG_PUB.Add_Exc_Msg
9503: ( G_PKG_NAME
9504: , 'get_customer_details'

Line 9502: OE_MSG_PUB.Add_Exc_Msg

9498: WHEN OTHERS THEN
9499:
9500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9501: THEN
9502: OE_MSG_PUB.Add_Exc_Msg
9503: ( G_PKG_NAME
9504: , 'get_customer_details'
9505: );
9506: END IF;

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

9674: EXCEPTION
9675:
9676: WHEN OTHERS THEN
9677:
9678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9679: THEN
9680: OE_MSG_PUB.Add_Exc_Msg
9681: ( G_PKG_NAME
9682: , 'Blkt_Req_For_Curr_Upd_And_Del'

Line 9680: OE_MSG_PUB.Add_Exc_Msg

9676: WHEN OTHERS THEN
9677:
9678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9679: THEN
9680: OE_MSG_PUB.Add_Exc_Msg
9681: ( G_PKG_NAME
9682: , 'Blkt_Req_For_Curr_Upd_And_Del'
9683: );
9684: END IF;