DBA Data[Home] [Help]

APPS.OE_ORDER_GRP dependencies on OE_MSG_PUB

Line 339: OE_MSG_PUB.Add;

335: -- and raise an error though we don't do any validation for the org_id.
336: l_org_id := MO_GLOBAL.get_current_org_id;
337: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
338: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
339: OE_MSG_PUB.Add;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables

Line 723: OE_MSG_PUB.Count_And_Get

719: x_return_status := FND_API.G_RET_STS_ERROR;
720:
721: -- Get message count and data
722:
723: OE_MSG_PUB.Count_And_Get
724: ( p_count => x_msg_count
725: , p_data => x_msg_data
726: );
727:

Line 738: OE_MSG_PUB.Count_And_Get

734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735:
736: -- Get message count and data
737:
738: OE_MSG_PUB.Count_And_Get
739: ( p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742:

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

747: END IF;
748:
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750:
751: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
752: THEN
753: OE_MSG_PUB.Add_Exc_Msg
754: ( G_PKG_NAME
755: , 'Process_Order'

Line 753: OE_MSG_PUB.Add_Exc_Msg

749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750:
751: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
752: THEN
753: OE_MSG_PUB.Add_Exc_Msg
754: ( G_PKG_NAME
755: , 'Process_Order'
756: );
757: END IF;

Line 761: OE_MSG_PUB.Count_And_Get

757: END IF;
758:
759: -- Get message count and data
760:
761: OE_MSG_PUB.Count_And_Get
762: ( p_count => x_msg_count
763: , p_data => x_msg_data
764: );
765:

Line 984: OE_MSG_PUB.Count_And_Get

980: x_return_status := FND_API.G_RET_STS_ERROR;
981:
982: -- Get message count and data
983:
984: OE_MSG_PUB.Count_And_Get
985: ( p_count => x_msg_count
986: , p_data => x_msg_data
987: );
988:

Line 995: OE_MSG_PUB.Count_And_Get

991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
992:
993: -- Get message count and data
994:
995: OE_MSG_PUB.Count_And_Get
996: ( p_count => x_msg_count
997: , p_data => x_msg_data
998: );
999:

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

1000: WHEN OTHERS THEN
1001:
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003:
1004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1005: THEN
1006: OE_MSG_PUB.Add_Exc_Msg
1007: ( G_PKG_NAME
1008: , 'Lock_Order'

Line 1006: OE_MSG_PUB.Add_Exc_Msg

1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003:
1004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1005: THEN
1006: OE_MSG_PUB.Add_Exc_Msg
1007: ( G_PKG_NAME
1008: , 'Lock_Order'
1009: );
1010: END IF;

Line 1014: OE_MSG_PUB.Count_And_Get

1010: END IF;
1011:
1012: -- Get message count and data
1013:
1014: OE_MSG_PUB.Count_And_Get
1015: ( p_count => x_msg_count
1016: , p_data => x_msg_data
1017: );
1018:

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

1099: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1100:
1101: l_header_id := p_header_id;
1102:
1103: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1104: THEN
1105:
1106: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 1108: OE_MSG_PUB.Add;

1104: THEN
1105:
1106: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1108: OE_MSG_PUB.Add;
1109:
1110: END IF;
1111:
1112: ELSE

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

1117: ( p_header => p_header
1118: );*/
1119:
1120: IF l_header_id = FND_API.G_MISS_NUM THEN
1121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1122: THEN
1123:
1124: fnd_message.set_name('ONT','Invalid Business Object Value');
1125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 1126: OE_MSG_PUB.Add;

1122: THEN
1123:
1124: fnd_message.set_name('ONT','Invalid Business Object Value');
1125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
1126: OE_MSG_PUB.Add;
1127:
1128: END IF;
1129: END IF;
1130:

Line 1196: OE_MSG_PUB.Count_And_Get

1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194: -- Get message count and data
1195:
1196: OE_MSG_PUB.Count_And_Get
1197: ( p_count => x_msg_count
1198: , p_data => x_msg_data
1199: );
1200:

Line 1210: OE_MSG_PUB.Count_And_Get

1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207:
1208: -- Get message count and data
1209:
1210: OE_MSG_PUB.Count_And_Get
1211: ( p_count => x_msg_count
1212: , p_data => x_msg_data
1213: );
1214:

Line 1221: OE_MSG_PUB.Count_And_Get

1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: -- Get message count and data
1220:
1221: OE_MSG_PUB.Count_And_Get
1222: ( p_count => x_msg_count
1223: , p_data => x_msg_data
1224: );
1225:

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

1226: WHEN OTHERS THEN
1227:
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1229:
1230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1231: THEN
1232: OE_MSG_PUB.Add_Exc_Msg
1233: ( G_PKG_NAME
1234: , 'Get_Order'

Line 1232: OE_MSG_PUB.Add_Exc_Msg

1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1229:
1230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1231: THEN
1232: OE_MSG_PUB.Add_Exc_Msg
1233: ( G_PKG_NAME
1234: , 'Get_Order'
1235: );
1236: END IF;

Line 1240: OE_MSG_PUB.Count_And_Get

1236: END IF;
1237:
1238: -- Get message count and data
1239:
1240: OE_MSG_PUB.Count_And_Get
1241: ( p_count => x_msg_count
1242: , p_data => x_msg_data
1243: );
1244:

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

1334: EXCEPTION
1335:
1336: WHEN OTHERS THEN
1337:
1338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1339: THEN
1340: OE_MSG_PUB.Add_Exc_Msg
1341: ( G_PKG_NAME
1342: , 'Id_To_Value'

Line 1340: OE_MSG_PUB.Add_Exc_Msg

1336: WHEN OTHERS THEN
1337:
1338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1339: THEN
1340: OE_MSG_PUB.Add_Exc_Msg
1341: ( G_PKG_NAME
1342: , 'Id_To_Value'
1343: );
1344: END IF;

Line 1439: OE_MSG_PUB.set_msg_context(

1435: l_source_document_id := null;
1436: END;
1437: END IF;
1438:
1439: OE_MSG_PUB.set_msg_context(
1440: p_entity_code => 'HEADER'
1441: ,p_entity_id => p_header_rec.header_id
1442: ,p_header_id => p_header_rec.header_id
1443: ,p_line_id => null

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

1457: IF x_header_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: END IF;
1460:
1461: OE_MSG_PUB.reset_msg_context('HEADER');
1462:
1463: -- Convert Header_Adj
1464:
1465: x_Header_Adj_tbl := p_Header_Adj_tbl;

Line 1497: OE_MSG_PUB.set_msg_context(

1493: l_source_document_id := null;
1494: END;
1495: END IF;
1496:
1497: OE_MSG_PUB.set_msg_context(
1498: p_entity_code => 'HEADER_ADJ'
1499: ,p_entity_id => x_header_Adj_tbl(l_index).price_adjustment_id
1500: ,p_header_id => x_header_Adj_tbl(l_index).header_Id
1501: ,p_line_id => null

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

1517: END IF;
1518:
1519: l_index := p_Header_Adj_val_tbl.NEXT(l_index);
1520:
1521: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1522:
1523: END LOOP;
1524:
1525: -- Convert Header_Scredit

Line 1559: OE_MSG_PUB.set_msg_context(

1555: l_source_document_id := null;
1556: END;
1557: END IF;
1558:
1559: OE_MSG_PUB.set_msg_context(
1560: p_entity_code => 'HEADER_SCREDIT'
1561: ,p_entity_id => x_header_Scredit_tbl(l_index).sales_credit_id
1562: ,p_header_id => x_header_Scredit_tbl(l_index).header_Id
1563: ,p_line_id => null

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

1579: END IF;
1580:
1581: l_index := p_Header_Scredit_val_tbl.NEXT(l_index);
1582:
1583: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
1584:
1585: END LOOP;
1586:
1587: -- Convert Header_Payment

Line 1621: OE_MSG_PUB.set_msg_context(

1617: l_source_document_id := null;
1618: END;
1619: END IF;
1620:
1621: OE_MSG_PUB.set_msg_context(
1622: p_entity_code => 'HEADER_PAYMENT'
1623: ,p_entity_id => x_header_Payment_tbl(l_index).payment_number
1624: ,p_header_id => x_header_Payment_tbl(l_index).header_Id
1625: ,p_line_id => null

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

1641: END IF;
1642:
1643: l_index := p_Header_Payment_val_tbl.NEXT(l_index);
1644:
1645: OE_MSG_PUB.reset_msg_context('HEADER_PAYMENT');
1646:
1647: END LOOP;
1648:
1649: -- Convert line

Line 1656: OE_MSG_PUB.set_msg_context

1652:
1653: l_index := p_line_val_tbl.FIRST;
1654:
1655: WHILE l_index IS NOT NULL LOOP
1656: OE_MSG_PUB.set_msg_context
1657: ( p_entity_code => 'LINE'
1658: ,p_entity_id => x_line_tbl(l_index).line_id
1659: ,p_header_id => x_line_tbl(l_index).header_id
1660: ,p_line_id => x_line_tbl(l_index).line_id

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

1691: END IF;
1692:
1693: l_index := p_line_val_tbl.NEXT(l_index);
1694:
1695: OE_MSG_PUB.reset_msg_context('LINE');
1696:
1697: END LOOP;
1698:
1699: -- Convert Line_Adj

Line 1739: OE_MSG_PUB.set_msg_context(

1735: l_orig_sys_shipment_ref := null;
1736: END;
1737: END IF;
1738:
1739: OE_MSG_PUB.set_msg_context(
1740: p_entity_code => 'LINE_ADJ'
1741: ,p_entity_id => x_Line_Adj_tbl(l_index).price_adjustment_id
1742: ,p_header_id => x_Line_Adj_tbl(l_index).header_id
1743: ,p_line_id => x_Line_Adj_tbl(l_index).line_id

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

1760: END IF;
1761:
1762: l_index := p_Line_Adj_val_tbl.NEXT(l_index);
1763:
1764: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1765:
1766: END LOOP;
1767:
1768: -- Convert Line_Scredit

Line 1809: OE_MSG_PUB.set_msg_context(

1805: l_orig_sys_shipment_ref := null;
1806: END;
1807: END IF;
1808:
1809: OE_MSG_PUB.set_msg_context(
1810: p_entity_code => 'LINE_SCREDIT'
1811: ,p_entity_id => x_Line_Scredit_tbl(l_index).sales_credit_id
1812: ,p_header_id => x_Line_Scredit_tbl(l_index).header_id
1813: ,p_line_id => x_Line_Scredit_tbl(l_index).line_id

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

1830: END IF;
1831:
1832: l_index := p_Line_Scredit_val_tbl.NEXT(l_index);
1833:
1834: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
1835:
1836: END LOOP;
1837:
1838: -- Convert Line_Payment

Line 1879: OE_MSG_PUB.set_msg_context(

1875: l_orig_sys_shipment_ref := null;
1876: END;
1877: END IF;
1878:
1879: OE_MSG_PUB.set_msg_context(
1880: p_entity_code => 'LINE_PAYMENT'
1881: ,p_entity_id => x_Line_Payment_tbl(l_index).payment_number
1882: ,p_header_id => x_Line_Payment_tbl(l_index).header_id
1883: ,p_line_id => x_Line_Payment_tbl(l_index).line_id

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

1900: END IF;
1901:
1902: l_index := p_Line_Payment_val_tbl.NEXT(l_index);
1903:
1904: OE_MSG_PUB.reset_msg_context('LINE_PAYMENT');
1905:
1906: END LOOP;
1907:
1908: -- Convert Lot_Serial

Line 1949: OE_MSG_PUB.set_msg_context(

1945: l_orig_sys_shipment_ref := null;
1946: END;
1947: END IF;
1948:
1949: OE_MSG_PUB.set_msg_context(
1950: p_entity_code => 'LOT_SERIAL'
1951: ,p_entity_id => null
1952: ,p_header_id => p_header_rec.header_id
1953: ,p_line_id => x_Lot_Serial_tbl(l_index).line_id

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

1970: END IF;
1971:
1972: l_index := p_Lot_Serial_val_tbl.NEXT(l_index);
1973:
1974: OE_MSG_PUB.reset_msg_context('LOT_SERIAL_ID');
1975:
1976: END LOOP;
1977:
1978: EXCEPTION

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

1978: EXCEPTION
1979:
1980: WHEN OTHERS THEN
1981:
1982: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1983: THEN
1984: OE_MSG_PUB.Add_Exc_Msg
1985: ( G_PKG_NAME
1986: , 'Value_To_Id'

Line 1984: OE_MSG_PUB.Add_Exc_Msg

1980: WHEN OTHERS THEN
1981:
1982: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1983: THEN
1984: OE_MSG_PUB.Add_Exc_Msg
1985: ( G_PKG_NAME
1986: , 'Value_To_Id'
1987: );
1988: END IF;

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

2044: IF p_top_model_line_id <> FND_API.G_MISS_NUM THEN
2045:
2046: l_top_model_line_id := p_top_model_line_id;
2047:
2048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2049: THEN
2050: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
2052: OE_MSG_PUB.Add;

Line 2052: OE_MSG_PUB.Add;

2048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2049: THEN
2050: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
2052: OE_MSG_PUB.Add;
2053: END IF;
2054:
2055: ELSE
2056: IF l_top_model_line_id = FND_API.G_MISS_NUM THEN

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

2053: END IF;
2054:
2055: ELSE
2056: IF l_top_model_line_id = FND_API.G_MISS_NUM THEN
2057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2058: THEN
2059: fnd_message.set_name('ONT','Invalid Business Object Value');
2060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
2061: OE_MSG_PUB.Add;

Line 2061: OE_MSG_PUB.Add;

2057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2058: THEN
2059: fnd_message.set_name('ONT','Invalid Business Object Value');
2060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Top Model Line');
2061: OE_MSG_PUB.Add;
2062: END IF;
2063: END IF;
2064:
2065: RAISE FND_API.G_EXC_ERROR;

Line 2084: OE_MSG_PUB.Count_And_Get

2080: x_return_status := FND_API.G_RET_STS_SUCCESS;
2081:
2082: -- Get message count and data
2083:
2084: OE_MSG_PUB.Count_And_Get
2085: ( p_count =>x_msg_count
2086: , p_data =>x_msg_data
2087: );
2088:

Line 2096: OE_MSG_PUB.Count_And_Get

2092: x_return_status := FND_API.G_RET_STS_ERROR;
2093:
2094: -- Get message count and data
2095:
2096: OE_MSG_PUB.Count_And_Get
2097: ( p_count => x_msg_count
2098: , p_data => x_msg_data
2099: );
2100:

Line 2106: OE_MSG_PUB.Count_And_Get

2102:
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104:
2105: -- Get message count and data
2106: OE_MSG_PUB.Count_And_Get
2107: ( p_count => x_msg_count
2108: , p_data => x_msg_data
2109: );
2110:

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

2109: );
2110:
2111: WHEN OTHERS THEN
2112:
2113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2114: THEN
2115: OE_MSG_PUB.Add_Exc_Msg
2116: ( G_PKG_NAME
2117: , 'Get_Option_Lines'

Line 2115: OE_MSG_PUB.Add_Exc_Msg

2111: WHEN OTHERS THEN
2112:
2113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2114: THEN
2115: OE_MSG_PUB.Add_Exc_Msg
2116: ( G_PKG_NAME
2117: , 'Get_Option_Lines'
2118: );
2119: END IF;

Line 2122: OE_MSG_PUB.Count_And_Get

2118: );
2119: END IF;
2120:
2121: -- Get message count and data
2122: OE_MSG_PUB.Count_And_Get
2123: ( p_count => x_msg_count
2124: , p_data => x_msg_data
2125: );
2126:

Line 3346: l_count :=oe_msg_pub.count_msg;

3342: oe_debug_pub.add('AAC: after calling Create_Account_layer for header level site creation} ');
3343: END IF;
3344:
3345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3346: l_count :=oe_msg_pub.count_msg;
3347:
3348: IF l_debug_level > 0 THEN
3349: oe_debug_pub.add('AAC: Main Status is not success'||
3350: ' msg='||x_msg_data||

Line 4079: l_count :=oe_msg_pub.count_msg;

4075: END IF;
4076:
4077: /* check for errors{ */
4078: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4079: l_count :=oe_msg_pub.count_msg;
4080:
4081: IF l_debug_level > 0 THEN
4082: oe_debug_pub.add('AAC: line: Main Status is not success'||
4083: ' msg='||x_msg_data||

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

4161: EXCEPTION
4162:
4163: WHEN OTHERS THEN
4164:
4165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4166: THEN
4167: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Automatic_Account_Creation');
4168: END IF;
4169:

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

4163: WHEN OTHERS THEN
4164:
4165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4166: THEN
4167: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Automatic_Account_Creation');
4168: END IF;
4169:
4170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4171:

Line 4199: OE_MSG_PUB.initialize;

4195:
4196: BEGIN
4197:
4198:
4199: OE_MSG_PUB.initialize;
4200: x_return_status := FND_API.G_RET_STS_SUCCESS;
4201:
4202: IF(p_operation IS NULL or p_operation = '' ) THEN
4203: --raise an error for null operation

Line 4206: OE_MSG_PUB.Add;

4202: IF(p_operation IS NULL or p_operation = '' ) THEN
4203: --raise an error for null operation
4204: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Operation');
4206: OE_MSG_PUB.Add;
4207: RAISE FND_API.G_EXC_ERROR;
4208: END IF;
4209:
4210: IF(p_header_id IS NULL) THEN

Line 4214: OE_MSG_PUB.Add;

4210: IF(p_header_id IS NULL) THEN
4211: --raise an error for null header_id
4212: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');
4214: OE_MSG_PUB.Add;
4215: RAISE FND_API.G_EXC_ERROR;
4216: ELSE
4217: -- (1)query header_rec by header_id
4218: -- (2) convert to RowType Rec

Line 4226: OE_MSG_PUB.Add;

4222: IF(p_document_type IS NULL OR p_document_type ='') THEN
4223: -- raise an error for null document_type
4224: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4225: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','document_type');
4226: OE_MSG_PUB.Add;
4227: RAISE FND_API.G_EXC_ERROR;
4228: ELSIF p_document_type= 'O' THEN
4229: -- the caller is from Sales Order
4230: OE_HEADER_UTIL.QUERY_ROW(p_header_id=>p_header_id

Line 4269: OE_MSG_PUB.Count_And_Get

4265: x_return_status := FND_API.G_RET_STS_ERROR;
4266:
4267: -- Get message count and data
4268:
4269: OE_MSG_PUB.Count_And_Get
4270: ( p_count => x_msg_count
4271: , p_data => x_msg_data
4272: );
4273:

Line 4280: OE_MSG_PUB.Count_And_Get

4276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4277:
4278: -- Get message count and data
4279:
4280: OE_MSG_PUB.Count_And_Get
4281: ( p_count => x_msg_count
4282: , p_data => x_msg_data
4283: );
4284:

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

4284:
4285: WHEN OTHERS THEN
4286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4287:
4288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4289: THEN
4290: OE_MSG_PUB.Add_Exc_Msg
4291: ( G_PKG_NAME
4292: , 'Check_Header_Security'

Line 4290: OE_MSG_PUB.Add_Exc_Msg

4286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4287:
4288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4289: THEN
4290: OE_MSG_PUB.Add_Exc_Msg
4291: ( G_PKG_NAME
4292: , 'Check_Header_Security'
4293: );
4294: END IF;

Line 4297: OE_MSG_PUB.Count_And_Get

4293: );
4294: END IF;
4295: -- Get message count and data
4296:
4297: OE_MSG_PUB.Count_And_Get
4298: ( p_count => x_msg_count
4299: , p_data => x_msg_data
4300: );
4301: