DBA Data[Home] [Help]

APPS.WIP_REPSCHEDULE_UTIL dependencies on FND_MSG_PUB

Line 838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

834: EXCEPTION
835:
836: WHEN OTHERS THEN
837:
838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: FND_MSG_PUB.Add_Exc_Msg
841: ( G_PKG_NAME
842: , 'Update_Row'

Line 840: FND_MSG_PUB.Add_Exc_Msg

836: WHEN OTHERS THEN
837:
838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: FND_MSG_PUB.Add_Exc_Msg
841: ( G_PKG_NAME
842: , 'Update_Row'
843: );
844: END IF;

Line 985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

981: EXCEPTION
982:
983: WHEN OTHERS THEN
984:
985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
986: THEN
987: FND_MSG_PUB.Add_Exc_Msg
988: ( G_PKG_NAME
989: , 'Insert_Row'

Line 987: FND_MSG_PUB.Add_Exc_Msg

983: WHEN OTHERS THEN
984:
985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
986: THEN
987: FND_MSG_PUB.Add_Exc_Msg
988: ( G_PKG_NAME
989: , 'Insert_Row'
990: );
991: END IF;

Line 1013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1009: EXCEPTION
1010:
1011: WHEN OTHERS THEN
1012:
1013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Delete_Row'

Line 1015: FND_MSG_PUB.Add_Exc_Msg

1011: WHEN OTHERS THEN
1012:
1013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Delete_Row'
1018: );
1019: END IF;

Line 1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1138: (p_wip_entity_id IS NOT NULL
1139: AND
1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1141: THEN
1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg
1145: ( G_PKG_NAME
1146: , 'Query Rows'

Line 1144: FND_MSG_PUB.Add_Exc_Msg

1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1141: THEN
1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg
1145: ( G_PKG_NAME
1146: , 'Query Rows'
1147: , 'Keys are mutually exclusive: repetitive_schedule_id = '|| p_repetitive_schedule_id || ', wip_entity_id = '|| p_wip_entity_id
1148: );

Line 1250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247:
1248: WHEN OTHERS THEN
1249:
1250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: FND_MSG_PUB.Add_Exc_Msg
1253: ( G_PKG_NAME
1254: , 'Query_Rows'

Line 1252: FND_MSG_PUB.Add_Exc_Msg

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

Line 1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1533:
1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536:
1537: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
1538: FND_MSG_PUB.Add;

Line 1538: FND_MSG_PUB.Add;

1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536:
1537: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
1538: FND_MSG_PUB.Add;
1539:
1540: END IF;
1541:
1542: END IF;

Line 1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
1555: FND_MSG_PUB.Add;

Line 1555: FND_MSG_PUB.Add;

1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
1555: FND_MSG_PUB.Add;
1556:
1557: END IF;
1558: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1559:

Line 1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1559:
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1565:
1566: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
1567: FND_MSG_PUB.Add;

Line 1567: FND_MSG_PUB.Add;

1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1565:
1566: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
1567: FND_MSG_PUB.Add;
1568:
1569: END IF;
1570: WHEN OTHERS THEN
1571:

Line 1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1571:
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1577: FND_MSG_PUB.Add_Exc_Msg
1578: ( G_PKG_NAME
1579: , 'Lock_Row'

Line 1577: FND_MSG_PUB.Add_Exc_Msg

1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1577: FND_MSG_PUB.Add_Exc_Msg
1578: ( G_PKG_NAME
1579: , 'Lock_Row'
1580: );
1581: END IF;