DBA Data[Home] [Help]

APPS.OE_ORDER_GRP dependencies on OE_MSG_PUB

Line 329: OE_MSG_PUB.Add;

325: -- and raise an error though we don't do any validation for the org_id.
326: l_org_id := MO_GLOBAL.get_current_org_id;
327: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
328: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
329: OE_MSG_PUB.Add;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables

Line 642: OE_MSG_PUB.Count_And_Get

638: x_return_status := FND_API.G_RET_STS_ERROR;
639:
640: -- Get message count and data
641:
642: OE_MSG_PUB.Count_And_Get
643: ( p_count => x_msg_count
644: , p_data => x_msg_data
645: );
646:

Line 653: OE_MSG_PUB.Count_And_Get

649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
650:
651: -- Get message count and data
652:
653: OE_MSG_PUB.Count_And_Get
654: ( p_count => x_msg_count
655: , p_data => x_msg_data
656: );
657:

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

658: WHEN OTHERS THEN
659:
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: OE_MSG_PUB.Add_Exc_Msg
665: ( G_PKG_NAME
666: , 'Process_Order'

Line 664: OE_MSG_PUB.Add_Exc_Msg

660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: OE_MSG_PUB.Add_Exc_Msg
665: ( G_PKG_NAME
666: , 'Process_Order'
667: );
668: END IF;

Line 672: OE_MSG_PUB.Count_And_Get

668: END IF;
669:
670: -- Get message count and data
671:
672: OE_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count
674: , p_data => x_msg_data
675: );
676:

Line 895: OE_MSG_PUB.Count_And_Get

891: x_return_status := FND_API.G_RET_STS_ERROR;
892:
893: -- Get message count and data
894:
895: OE_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count
897: , p_data => x_msg_data
898: );
899:

Line 906: OE_MSG_PUB.Count_And_Get

902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: -- Get message count and data
905:
906: OE_MSG_PUB.Count_And_Get
907: ( p_count => x_msg_count
908: , p_data => x_msg_data
909: );
910:

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

911: WHEN OTHERS THEN
912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
914:
915: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: OE_MSG_PUB.Add_Exc_Msg
918: ( G_PKG_NAME
919: , 'Lock_Order'

Line 917: OE_MSG_PUB.Add_Exc_Msg

913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
914:
915: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: OE_MSG_PUB.Add_Exc_Msg
918: ( G_PKG_NAME
919: , 'Lock_Order'
920: );
921: END IF;

Line 925: OE_MSG_PUB.Count_And_Get

921: END IF;
922:
923: -- Get message count and data
924:
925: OE_MSG_PUB.Count_And_Get
926: ( p_count => x_msg_count
927: , p_data => x_msg_data
928: );
929:

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

1010: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1011:
1012: l_header_id := p_header_id;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1015: THEN
1016:
1017: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 1019: OE_MSG_PUB.Add;

1015: THEN
1016:
1017: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1019: OE_MSG_PUB.Add;
1020:
1021: END IF;
1022:
1023: ELSE

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

1028: ( p_header => p_header
1029: );*/
1030:
1031: IF l_header_id = FND_API.G_MISS_NUM THEN
1032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1033: THEN
1034:
1035: fnd_message.set_name('ONT','Invalid Business Object Value');
1036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 1037: OE_MSG_PUB.Add;

1033: THEN
1034:
1035: fnd_message.set_name('ONT','Invalid Business Object Value');
1036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1037: OE_MSG_PUB.Add;
1038:
1039: END IF;
1040: END IF;
1041:

Line 1107: OE_MSG_PUB.Count_And_Get

1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: -- Get message count and data
1106:
1107: OE_MSG_PUB.Count_And_Get
1108: ( p_count => x_msg_count
1109: , p_data => x_msg_data
1110: );
1111:

Line 1121: OE_MSG_PUB.Count_And_Get

1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118:
1119: -- Get message count and data
1120:
1121: OE_MSG_PUB.Count_And_Get
1122: ( p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125:

Line 1132: OE_MSG_PUB.Count_And_Get

1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129:
1130: -- Get message count and data
1131:
1132: OE_MSG_PUB.Count_And_Get
1133: ( p_count => x_msg_count
1134: , p_data => x_msg_data
1135: );
1136:

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

1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140:
1141: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1142: THEN
1143: OE_MSG_PUB.Add_Exc_Msg
1144: ( G_PKG_NAME
1145: , 'Get_Order'

Line 1143: OE_MSG_PUB.Add_Exc_Msg

1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140:
1141: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1142: THEN
1143: OE_MSG_PUB.Add_Exc_Msg
1144: ( G_PKG_NAME
1145: , 'Get_Order'
1146: );
1147: END IF;

Line 1151: OE_MSG_PUB.Count_And_Get

1147: END IF;
1148:
1149: -- Get message count and data
1150:
1151: OE_MSG_PUB.Count_And_Get
1152: ( p_count => x_msg_count
1153: , p_data => x_msg_data
1154: );
1155:

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

1245: EXCEPTION
1246:
1247: WHEN OTHERS THEN
1248:
1249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: OE_MSG_PUB.Add_Exc_Msg
1252: ( G_PKG_NAME
1253: , 'Id_To_Value'

Line 1251: OE_MSG_PUB.Add_Exc_Msg

1247: WHEN OTHERS THEN
1248:
1249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: OE_MSG_PUB.Add_Exc_Msg
1252: ( G_PKG_NAME
1253: , 'Id_To_Value'
1254: );
1255: END IF;

Line 1350: OE_MSG_PUB.set_msg_context(

1346: l_source_document_id := null;
1347: END;
1348: END IF;
1349:
1350: OE_MSG_PUB.set_msg_context(
1351: p_entity_code => 'HEADER'
1352: ,p_entity_id => p_header_rec.header_id
1353: ,p_header_id => p_header_rec.header_id
1354: ,p_line_id => null

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

1368: IF x_header_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370: END IF;
1371:
1372: OE_MSG_PUB.reset_msg_context('HEADER');
1373:
1374: -- Convert Header_Adj
1375:
1376: x_Header_Adj_tbl := p_Header_Adj_tbl;

Line 1408: OE_MSG_PUB.set_msg_context(

1404: l_source_document_id := null;
1405: END;
1406: END IF;
1407:
1408: OE_MSG_PUB.set_msg_context(
1409: p_entity_code => 'HEADER_ADJ'
1410: ,p_entity_id => x_header_Adj_tbl(l_index).price_adjustment_id
1411: ,p_header_id => x_header_Adj_tbl(l_index).header_Id
1412: ,p_line_id => null

Line 1432: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

1428: END IF;
1429:
1430: l_index := p_Header_Adj_val_tbl.NEXT(l_index);
1431:
1432: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1433:
1434: END LOOP;
1435:
1436: -- Convert Header_Scredit

Line 1470: OE_MSG_PUB.set_msg_context(

1466: l_source_document_id := null;
1467: END;
1468: END IF;
1469:
1470: OE_MSG_PUB.set_msg_context(
1471: p_entity_code => 'HEADER_SCREDIT'
1472: ,p_entity_id => x_header_Scredit_tbl(l_index).sales_credit_id
1473: ,p_header_id => x_header_Scredit_tbl(l_index).header_Id
1474: ,p_line_id => null

Line 1494: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

1490: END IF;
1491:
1492: l_index := p_Header_Scredit_val_tbl.NEXT(l_index);
1493:
1494: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
1495:
1496: END LOOP;
1497:
1498: -- Convert Header_Payment

Line 1532: OE_MSG_PUB.set_msg_context(

1528: l_source_document_id := null;
1529: END;
1530: END IF;
1531:
1532: OE_MSG_PUB.set_msg_context(
1533: p_entity_code => 'HEADER_PAYMENT'
1534: ,p_entity_id => x_header_Payment_tbl(l_index).payment_number
1535: ,p_header_id => x_header_Payment_tbl(l_index).header_Id
1536: ,p_line_id => null

Line 1556: OE_MSG_PUB.reset_msg_context('HEADER_PAYMENT');

1552: END IF;
1553:
1554: l_index := p_Header_Payment_val_tbl.NEXT(l_index);
1555:
1556: OE_MSG_PUB.reset_msg_context('HEADER_PAYMENT');
1557:
1558: END LOOP;
1559:
1560: -- Convert line

Line 1567: OE_MSG_PUB.set_msg_context

1563:
1564: l_index := p_line_val_tbl.FIRST;
1565:
1566: WHILE l_index IS NOT NULL LOOP
1567: OE_MSG_PUB.set_msg_context
1568: ( p_entity_code => 'LINE'
1569: ,p_entity_id => x_line_tbl(l_index).line_id
1570: ,p_header_id => x_line_tbl(l_index).header_id
1571: ,p_line_id => x_line_tbl(l_index).line_id

Line 1606: OE_MSG_PUB.reset_msg_context('LINE');

1602: END IF;
1603:
1604: l_index := p_line_val_tbl.NEXT(l_index);
1605:
1606: OE_MSG_PUB.reset_msg_context('LINE');
1607:
1608: END LOOP;
1609:
1610: -- Convert Line_Adj

Line 1650: OE_MSG_PUB.set_msg_context(

1646: l_orig_sys_shipment_ref := null;
1647: END;
1648: END IF;
1649:
1650: OE_MSG_PUB.set_msg_context(
1651: p_entity_code => 'LINE_ADJ'
1652: ,p_entity_id => x_Line_Adj_tbl(l_index).price_adjustment_id
1653: ,p_header_id => x_Line_Adj_tbl(l_index).header_id
1654: ,p_line_id => x_Line_Adj_tbl(l_index).line_id

Line 1675: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

1671: END IF;
1672:
1673: l_index := p_Line_Adj_val_tbl.NEXT(l_index);
1674:
1675: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1676:
1677: END LOOP;
1678:
1679: -- Convert Line_Scredit

Line 1720: OE_MSG_PUB.set_msg_context(

1716: l_orig_sys_shipment_ref := null;
1717: END;
1718: END IF;
1719:
1720: OE_MSG_PUB.set_msg_context(
1721: p_entity_code => 'LINE_SCREDIT'
1722: ,p_entity_id => x_Line_Scredit_tbl(l_index).sales_credit_id
1723: ,p_header_id => x_Line_Scredit_tbl(l_index).header_id
1724: ,p_line_id => x_Line_Scredit_tbl(l_index).line_id

Line 1745: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

1741: END IF;
1742:
1743: l_index := p_Line_Scredit_val_tbl.NEXT(l_index);
1744:
1745: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
1746:
1747: END LOOP;
1748:
1749: -- Convert Line_Payment

Line 1790: OE_MSG_PUB.set_msg_context(

1786: l_orig_sys_shipment_ref := null;
1787: END;
1788: END IF;
1789:
1790: OE_MSG_PUB.set_msg_context(
1791: p_entity_code => 'LINE_PAYMENT'
1792: ,p_entity_id => x_Line_Payment_tbl(l_index).payment_number
1793: ,p_header_id => x_Line_Payment_tbl(l_index).header_id
1794: ,p_line_id => x_Line_Payment_tbl(l_index).line_id

Line 1815: OE_MSG_PUB.reset_msg_context('LINE_PAYMENT');

1811: END IF;
1812:
1813: l_index := p_Line_Payment_val_tbl.NEXT(l_index);
1814:
1815: OE_MSG_PUB.reset_msg_context('LINE_PAYMENT');
1816:
1817: END LOOP;
1818:
1819: -- Convert Lot_Serial

Line 1860: OE_MSG_PUB.set_msg_context(

1856: l_orig_sys_shipment_ref := null;
1857: END;
1858: END IF;
1859:
1860: OE_MSG_PUB.set_msg_context(
1861: p_entity_code => 'LOT_SERIAL'
1862: ,p_entity_id => null
1863: ,p_header_id => p_header_rec.header_id
1864: ,p_line_id => x_Lot_Serial_tbl(l_index).line_id

Line 1885: OE_MSG_PUB.reset_msg_context('LOT_SERIAL_ID');

1881: END IF;
1882:
1883: l_index := p_Lot_Serial_val_tbl.NEXT(l_index);
1884:
1885: OE_MSG_PUB.reset_msg_context('LOT_SERIAL_ID');
1886:
1887: END LOOP;
1888:
1889: EXCEPTION

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

1889: EXCEPTION
1890:
1891: WHEN OTHERS THEN
1892:
1893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: OE_MSG_PUB.Add_Exc_Msg
1896: ( G_PKG_NAME
1897: , 'Value_To_Id'

Line 1895: OE_MSG_PUB.Add_Exc_Msg

1891: WHEN OTHERS THEN
1892:
1893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: OE_MSG_PUB.Add_Exc_Msg
1896: ( G_PKG_NAME
1897: , 'Value_To_Id'
1898: );
1899: END IF;

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

1955: IF p_top_model_line_id <> FND_API.G_MISS_NUM THEN
1956:
1957: l_top_model_line_id := p_top_model_line_id;
1958:
1959: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1960: THEN
1961: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
1963: OE_MSG_PUB.Add;

Line 1963: OE_MSG_PUB.Add;

1959: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1960: THEN
1961: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
1963: OE_MSG_PUB.Add;
1964: END IF;
1965:
1966: ELSE
1967: IF l_top_model_line_id = FND_API.G_MISS_NUM THEN

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

1964: END IF;
1965:
1966: ELSE
1967: IF l_top_model_line_id = FND_API.G_MISS_NUM THEN
1968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1969: THEN
1970: fnd_message.set_name('ONT','Invalid Business Object Value');
1971: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
1972: OE_MSG_PUB.Add;

Line 1972: OE_MSG_PUB.Add;

1968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1969: THEN
1970: fnd_message.set_name('ONT','Invalid Business Object Value');
1971: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
1972: OE_MSG_PUB.Add;
1973: END IF;
1974: END IF;
1975:
1976: RAISE FND_API.G_EXC_ERROR;

Line 1995: OE_MSG_PUB.Count_And_Get

1991: x_return_status := FND_API.G_RET_STS_SUCCESS;
1992:
1993: -- Get message count and data
1994:
1995: OE_MSG_PUB.Count_And_Get
1996: ( p_count =>x_msg_count
1997: , p_data =>x_msg_data
1998: );
1999:

Line 2007: OE_MSG_PUB.Count_And_Get

2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004:
2005: -- Get message count and data
2006:
2007: OE_MSG_PUB.Count_And_Get
2008: ( p_count => x_msg_count
2009: , p_data => x_msg_data
2010: );
2011:

Line 2017: OE_MSG_PUB.Count_And_Get

2013:
2014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2015:
2016: -- Get message count and data
2017: OE_MSG_PUB.Count_And_Get
2018: ( p_count => x_msg_count
2019: , p_data => x_msg_data
2020: );
2021:

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

2020: );
2021:
2022: WHEN OTHERS THEN
2023:
2024: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: OE_MSG_PUB.Add_Exc_Msg
2027: ( G_PKG_NAME
2028: , 'Get_Option_Lines'

Line 2026: OE_MSG_PUB.Add_Exc_Msg

2022: WHEN OTHERS THEN
2023:
2024: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: OE_MSG_PUB.Add_Exc_Msg
2027: ( G_PKG_NAME
2028: , 'Get_Option_Lines'
2029: );
2030: END IF;

Line 2033: OE_MSG_PUB.Count_And_Get

2029: );
2030: END IF;
2031:
2032: -- Get message count and data
2033: OE_MSG_PUB.Count_And_Get
2034: ( p_count => x_msg_count
2035: , p_data => x_msg_data
2036: );
2037:

Line 3249: l_count :=oe_msg_pub.count_msg;

3245: oe_debug_pub.add('AAC: after calling Create_Account_layer for header level site creation} ');
3246: END IF;
3247:
3248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3249: l_count :=oe_msg_pub.count_msg;
3250:
3251: IF l_debug_level > 0 THEN
3252: oe_debug_pub.add('AAC: Main Status is not success'||
3253: ' msg='||x_msg_data||

Line 3982: l_count :=oe_msg_pub.count_msg;

3978: END IF;
3979:
3980: /* check for errors{ */
3981: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3982: l_count :=oe_msg_pub.count_msg;
3983:
3984: IF l_debug_level > 0 THEN
3985: oe_debug_pub.add('AAC: line: Main Status is not success'||
3986: ' msg='||x_msg_data||

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

4064: EXCEPTION
4065:
4066: WHEN OTHERS THEN
4067:
4068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4069: THEN
4070: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Automatic_Account_Creation');
4071: END IF;
4072:

Line 4070: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Automatic_Account_Creation');

4066: WHEN OTHERS THEN
4067:
4068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4069: THEN
4070: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Automatic_Account_Creation');
4071: END IF;
4072:
4073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4074:

Line 4102: OE_MSG_PUB.initialize;

4098:
4099: BEGIN
4100:
4101:
4102: OE_MSG_PUB.initialize;
4103: x_return_status := FND_API.G_RET_STS_SUCCESS;
4104:
4105: IF(p_operation IS NULL or p_operation = '' ) THEN
4106: --raise an error for null operation

Line 4109: OE_MSG_PUB.Add;

4105: IF(p_operation IS NULL or p_operation = '' ) THEN
4106: --raise an error for null operation
4107: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Operation');
4109: OE_MSG_PUB.Add;
4110: RAISE FND_API.G_EXC_ERROR;
4111: END IF;
4112:
4113: IF(p_header_id IS NULL) THEN

Line 4117: OE_MSG_PUB.Add;

4113: IF(p_header_id IS NULL) THEN
4114: --raise an error for null header_id
4115: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');
4117: OE_MSG_PUB.Add;
4118: RAISE FND_API.G_EXC_ERROR;
4119: ELSE
4120: -- (1)query header_rec by header_id
4121: -- (2) convert to RowType Rec

Line 4129: OE_MSG_PUB.Add;

4125: IF(p_document_type IS NULL OR p_document_type ='') THEN
4126: -- raise an error for null document_type
4127: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','document_type');
4129: OE_MSG_PUB.Add;
4130: RAISE FND_API.G_EXC_ERROR;
4131: ELSIF p_document_type= 'O' THEN
4132: -- the caller is from Sales Order
4133: OE_HEADER_UTIL.QUERY_ROW(p_header_id=>p_header_id

Line 4172: OE_MSG_PUB.Count_And_Get

4168: x_return_status := FND_API.G_RET_STS_ERROR;
4169:
4170: -- Get message count and data
4171:
4172: OE_MSG_PUB.Count_And_Get
4173: ( p_count => x_msg_count
4174: , p_data => x_msg_data
4175: );
4176:

Line 4183: OE_MSG_PUB.Count_And_Get

4179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4180:
4181: -- Get message count and data
4182:
4183: OE_MSG_PUB.Count_And_Get
4184: ( p_count => x_msg_count
4185: , p_data => x_msg_data
4186: );
4187:

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

4187:
4188: WHEN OTHERS THEN
4189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4190:
4191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4192: THEN
4193: OE_MSG_PUB.Add_Exc_Msg
4194: ( G_PKG_NAME
4195: , 'Check_Header_Security'

Line 4193: OE_MSG_PUB.Add_Exc_Msg

4189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4190:
4191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4192: THEN
4193: OE_MSG_PUB.Add_Exc_Msg
4194: ( G_PKG_NAME
4195: , 'Check_Header_Security'
4196: );
4197: END IF;

Line 4200: OE_MSG_PUB.Count_And_Get

4196: );
4197: END IF;
4198: -- Get message count and data
4199:
4200: OE_MSG_PUB.Count_And_Get
4201: ( p_count => x_msg_count
4202: , p_data => x_msg_data
4203: );
4204: