DBA Data[Home] [Help]

APPS.QP_QP_FORM_PLL_PRICING_ATTR dependencies on OE_MSG_PUB

Line 257: oe_msg_pub.Count_And_Get

253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- Get message count and data
256:
257: oe_msg_pub.Count_And_Get
258: ( p_count => x_msg_count
259: , p_data => x_msg_data
260: );
261:

Line 275: oe_msg_pub.Count_And_Get

271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: -- Get message count and data
274:
275: oe_msg_pub.Count_And_Get
276: ( p_count => x_msg_count
277: , p_data => x_msg_data
278: );
279:

Line 286: oe_msg_pub.Count_And_Get

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: -- Get message count and data
285:
286: oe_msg_pub.Count_And_Get
287: ( p_count => x_msg_count
288: , p_data => x_msg_data
289: );
290:

Line 295: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

291: WHEN OTHERS THEN
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294:
295: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: oe_msg_pub.Add_Exc_Msg
298: ( G_PKG_NAME
299: , 'Default_Attributes'

Line 297: oe_msg_pub.Add_Exc_Msg

293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294:
295: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: oe_msg_pub.Add_Exc_Msg
298: ( G_PKG_NAME
299: , 'Default_Attributes'
300: );
301: END IF;

Line 305: oe_msg_pub.Count_And_Get

301: END IF;
302:
303: -- Get message count and data
304:
305: oe_msg_pub.Count_And_Get
306: ( p_count => x_msg_count
307: , p_data => x_msg_data
308: );
309:

Line 491: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

487: ELSE
488:
489: -- Unexpected error, unrecognized attribute
490:
491: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
492: THEN
493: oe_msg_pub.Add_Exc_Msg
494: ( G_PKG_NAME
495: , 'Change_Attribute'

Line 493: oe_msg_pub.Add_Exc_Msg

489: -- Unexpected error, unrecognized attribute
490:
491: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
492: THEN
493: oe_msg_pub.Add_Exc_Msg
494: ( G_PKG_NAME
495: , 'Change_Attribute'
496: , 'Unrecognized attribute'
497: );

Line 812: oe_msg_pub.Count_And_Get

808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: -- Get message count and data
811:
812: oe_msg_pub.Count_And_Get
813: ( p_count => x_msg_count
814: , p_data => x_msg_data
815: );
816:

Line 826: oe_msg_pub.Count_And_Get

822: x_return_status := FND_API.G_RET_STS_ERROR;
823:
824: -- Get message count and data
825:
826: oe_msg_pub.Count_And_Get
827: ( p_count => x_msg_count
828: , p_data => x_msg_data
829: );
830:

Line 837: oe_msg_pub.Count_And_Get

833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834:
835: -- Get message count and data
836:
837: oe_msg_pub.Count_And_Get
838: ( p_count => x_msg_count
839: , p_data => x_msg_data
840: );
841:

Line 846: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

842: WHEN OTHERS THEN
843:
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
845:
846: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: oe_msg_pub.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Change_Attribute'

Line 848: oe_msg_pub.Add_Exc_Msg

844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
845:
846: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: oe_msg_pub.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Change_Attribute'
851: );
852: END IF;

Line 856: oe_msg_pub.Count_And_Get

852: END IF;
853:
854: -- Get message count and data
855:
856: oe_msg_pub.Count_And_Get
857: ( p_count => x_msg_count
858: , p_data => x_msg_data
859: );
860:

Line 993: oe_msg_pub.Count_And_Get

989: -- Get message count and data
990:
991: oe_debug_pub.add('Ren: msg data in val_and_write of attr 1 is :' || x_msg_data);
992:
993: oe_msg_pub.Count_And_Get
994: ( p_count => x_msg_count
995: , p_data => x_msg_data
996: );
997: oe_debug_pub.add('Ren: msg data in val_and_write of attr 2 is :' || x_msg_data);

Line 1009: oe_msg_pub.Count_And_Get

1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006:
1007: -- Get message count and data
1008:
1009: oe_msg_pub.Count_And_Get
1010: ( p_count => x_msg_count
1011: , p_data => x_msg_data
1012: );
1013: oe_debug_pub.add('Ren: msg data in val_and_write of attr 10 is :' || x_msg_data);

Line 1021: oe_msg_pub.Count_And_Get

1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018:
1019: -- Get message count and data
1020:
1021: oe_msg_pub.Count_And_Get
1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025: oe_debug_pub.add('Ren: msg data in val_and_write of attr 11 is :' || x_msg_data);

Line 1031: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1027: WHEN OTHERS THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030:
1031: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: oe_msg_pub.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Validate_And_Write'

Line 1033: oe_msg_pub.Add_Exc_Msg

1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030:
1031: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: oe_msg_pub.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Validate_And_Write'
1036: );
1037: END IF;

Line 1041: oe_msg_pub.Count_And_Get

1037: END IF;
1038:
1039: -- Get message count and data
1040:
1041: oe_msg_pub.Count_And_Get
1042: ( p_count => x_msg_count
1043: , p_data => x_msg_data
1044: );
1045: oe_debug_pub.add('Ren: msg data in val_and_write of attr 12 is :' || x_msg_data);

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: , 'Delete_Row'

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: , 'Delete_Row'
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 1311: oe_msg_pub.Count_And_Get

1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: -- Get message count and data
1310:
1311: oe_msg_pub.Count_And_Get
1312: ( p_count => x_msg_count
1313: , p_data => x_msg_data
1314: );
1315:

Line 1325: oe_msg_pub.Count_And_Get

1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Get message count and data
1324:
1325: oe_msg_pub.Count_And_Get
1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data
1328: );
1329:

Line 1336: oe_msg_pub.Count_And_Get

1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1333:
1334: -- Get message count and data
1335:
1336: oe_msg_pub.Count_And_Get
1337: ( p_count => x_msg_count
1338: , p_data => x_msg_data
1339: );
1340:

Line 1345: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1341: WHEN OTHERS THEN
1342:
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1344:
1345: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: oe_msg_pub.Add_Exc_Msg
1348: ( G_PKG_NAME
1349: , 'Process_Entity'

Line 1347: oe_msg_pub.Add_Exc_Msg

1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1344:
1345: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: oe_msg_pub.Add_Exc_Msg
1348: ( G_PKG_NAME
1349: , 'Process_Entity'
1350: );
1351: END IF;

Line 1355: oe_msg_pub.Count_And_Get

1351: END IF;
1352:
1353: -- Get message count and data
1354:
1355: oe_msg_pub.Count_And_Get
1356: ( p_count => x_msg_count
1357: , p_data => x_msg_data
1358: );
1359:

Line 1507: oe_msg_pub.Count_And_Get

1503: x_return_status := l_return_status;
1504:
1505: -- Get message count and data
1506:
1507: oe_msg_pub.Count_And_Get
1508: ( p_count => x_msg_count
1509: , p_data => x_msg_data
1510: );
1511:

Line 1517: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1513: EXCEPTION
1514:
1515: WHEN OTHERS THEN
1516:
1517: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1518: THEN
1519: oe_msg_pub.Add_Exc_Msg
1520: ( G_PKG_NAME
1521: , 'Lock_Row'

Line 1519: oe_msg_pub.Add_Exc_Msg

1515: WHEN OTHERS THEN
1516:
1517: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1518: THEN
1519: oe_msg_pub.Add_Exc_Msg
1520: ( G_PKG_NAME
1521: , 'Lock_Row'
1522: );
1523: END IF;

Line 1529: oe_msg_pub.Count_And_Get

1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526:
1527: -- Get message count and data
1528:
1529: oe_msg_pub.Count_And_Get
1530: ( p_count => x_msg_count
1531: , p_data => x_msg_data
1532: );
1533:

Line 1615: OE_MSG_PUB.initialize;

1611: )
1612: IS
1613: l_return_status Varchar2(30);
1614: BEGIN
1615: OE_MSG_PUB.initialize;
1616: x_return_status := FND_API.G_RET_STS_SUCCESS;
1617: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1618: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1619: ,p_entity_id => p_pricing_attribute_id

Line 1622: OE_MSG_PUB.Count_And_Get

1618: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1619: ,p_entity_id => p_pricing_attribute_id
1620: ,x_return_status => l_return_status);
1621:
1622: OE_MSG_PUB.Count_And_Get
1623: ( p_count => x_msg_count
1624: , p_data => x_msg_data
1625: );
1626:

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

1628: Clear_Pricing_Attr;
1629:
1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1633: THEN
1634: OE_MSG_PUB.Add_Exc_Msg
1635: ( G_PKG_NAME
1636: , 'Clear_Record'

Line 1634: OE_MSG_PUB.Add_Exc_Msg

1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1633: THEN
1634: OE_MSG_PUB.Add_Exc_Msg
1635: ( G_PKG_NAME
1636: , 'Clear_Record'
1637: );
1638: END IF;

Line 1640: OE_MSG_PUB.Count_And_Get

1636: , 'Clear_Record'
1637: );
1638: END IF;
1639: -- Get message count and data
1640: OE_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count
1642: , p_data => x_msg_data
1643: );
1644: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1659: OE_MSG_PUB.initialize;

1655: )
1656: IS
1657: l_return_status Varchar2(30);
1658: BEGIN
1659: OE_MSG_PUB.initialize;
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661: QP_DELAYED_REQUESTS_PVT.Clear_Request(
1662: x_return_status => l_return_status);
1663:

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

1662: x_return_status => l_return_status);
1663:
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1667: THEN
1668: OE_MSG_PUB.Add_Exc_Msg
1669: ( G_PKG_NAME
1670: , 'Delete_All_Requests'

Line 1668: OE_MSG_PUB.Add_Exc_Msg

1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1667: THEN
1668: OE_MSG_PUB.Add_Exc_Msg
1669: ( G_PKG_NAME
1670: , 'Delete_All_Requests'
1671: );
1672: END IF;

Line 1674: OE_MSG_PUB.Count_And_Get

1670: , 'Delete_All_Requests'
1671: );
1672: END IF;
1673: -- Get message count and data
1674: OE_MSG_PUB.Count_And_Get
1675: ( p_count => x_msg_count
1676: , p_data => x_msg_data
1677: );
1678: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2194: oe_msg_pub.Count_And_Get

2190: -- x_return_status := FND_API.G_RET_STS_ERROR;
2191:
2192: -- Get message count and data
2193:
2194: oe_msg_pub.Count_And_Get
2195: ( p_count => x_msg_count
2196: , p_data => x_msg_data
2197: );
2198:

Line 2205: oe_msg_pub.Count_And_Get

2201: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2202:
2203: -- Get message count and data
2204:
2205: oe_msg_pub.Count_And_Get
2206: ( p_count => x_msg_count
2207: , p_data => x_msg_data
2208: );
2209:

Line 2214: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2210: WHEN OTHERS THEN
2211:
2212: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2213:
2214: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: oe_msg_pub.Add_Exc_Msg
2217: ( G_PKG_NAME
2218: , 'Write to DB'

Line 2216: oe_msg_pub.Add_Exc_Msg

2212: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2213:
2214: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: oe_msg_pub.Add_Exc_Msg
2217: ( G_PKG_NAME
2218: , 'Write to DB'
2219: );
2220: END IF;

Line 2224: oe_msg_pub.Count_And_Get

2220: END IF;
2221:
2222: -- Get message count and data
2223:
2224: oe_msg_pub.Count_And_Get
2225: ( p_count => x_msg_count
2226: , p_data => x_msg_data
2227: );
2228: