DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_SECURITY dependencies on FND_API

Line 68: RAISE FND_API.G_EXC_ERROR;

64: INTO l_constrained_column
65: FROM oe_pc_constraints
66: WHERE constraint_id = l_constraint_id;
67: if l_constrained_column is null then
68: RAISE FND_API.G_EXC_ERROR;
69: end if;
70: END IF;
71:
72: elsif l_result = OE_PC_GLOBALS.ERROR then

Line 74: raise FND_API.G_EXC_UNEXPECTED_ERROR;

70: END IF;
71:
72: elsif l_result = OE_PC_GLOBALS.ERROR then
73:
74: raise FND_API.G_EXC_UNEXPECTED_ERROR;
75:
76: end if;
77:
78: g_check_all_cols_constraint := 'N';

Line 1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

1257: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ENTITY' , 1 ) ;
1258: END IF;
1259:
1260: -- Initializing return status to SUCCESS
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 1273: RAISE FND_API.G_EXC_ERROR;

1269: ELSE
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1272: END IF;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: OE_Line_Adj_Util.API_Rec_To_Rowtype_Rec
1277: (p_LINE_ADJ_rec

Line 1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1291: END IF;
1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1297: OE_MSG_PUB.Add_Exc_Msg
1298: ( G_PKG_NAME
1299: , 'Entity'

Line 1329: x_return_status := FND_API.G_RET_STS_SUCCESS;

1325: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1326: END IF;
1327:
1328: -- Initializing return status to SUCCESS
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330:
1331: -- Initializing out result to NOT CONSTRAINED
1332: x_result := OE_PC_GLOBALS.NO;
1333:

Line 1355: RAISE FND_API.G_EXC_ERROR;

1351: ELSE
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1354: END IF;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;
1357:
1358: OE_Line_Adj_Util.API_Rec_To_Rowtype_Rec
1359: (p_LINE_ADJ_rec,

Line 1368: IF p_line_adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN

1364:
1365: --Bug 9323560 starts
1366: oe_debug_pub.add( 'p_line_adj_rec.applied_flag: ' || p_line_adj_rec.applied_flag );
1367:
1368: IF p_line_adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN
1369: NULL;
1370: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.applied_flag,p_old_line_adj_rec.applied_flag) THEN
1371: oe_debug_pub.add( 'l_rowtype_rec.automatic_flag: ' || l_rowtype_rec.automatic_flag );
1372: oe_debug_pub.add( 'l_rowtype_rec.applied_flag: ' || l_rowtype_rec.applied_flag );

Line 1394: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;

1390: -- Compare the new and old entity records and
1391: -- check constraints for all the changed attributes.
1392:
1393:
1394: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1395: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN
1396:
1397: l_result := AUTOMATIC
1398: (p_operation => l_operation

Line 1410: IF p_line_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;

1406: END IF;
1407:
1408: END IF;
1409:
1410: IF p_line_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1411: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_id,p_old_line_adj_rec.discount_id) THEN
1412:
1413: l_result := DISCOUNT
1414: (p_operation => l_operation

Line 1426: IF p_line_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;

1422: END IF;
1423:
1424: END IF;
1425:
1426: IF p_line_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;
1427: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.operand,p_old_line_adj_rec.operand) THEN
1428:
1429: l_result := OPERAND
1430: (p_operation => l_operation

Line 1442: IF p_line_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;

1438: END IF;
1439:
1440: END IF;
1441:
1442: IF p_line_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;
1443: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_line_id,p_old_line_adj_rec.discount_line_id) THEN
1444:
1445: l_result := DISCOUNT_LINE
1446: (p_operation => l_operation

Line 1458: IF p_line_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;

1454: END IF;
1455:
1456: END IF;
1457:
1458: IF p_line_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;
1459: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.percent,p_old_line_adj_rec.percent) THEN
1460:
1461: l_result := PERCENT
1462: (p_operation => l_operation

Line 1474: IF p_line_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;

1470: END IF;
1471:
1472: END IF;
1473:
1474: IF p_line_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;
1475: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.request_id,p_old_line_adj_rec.request_id) THEN
1476:
1477: l_result := REQUEST
1478: (p_operation => l_operation

Line 1506: IF p_line_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;

1502: l_check_all_cols_constraint := g_check_all_cols_constraint;
1503: g_check_all_cols_constraint := 'N';
1504: END IF;
1505:
1506: IF p_line_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.context,p_old_line_adj_rec.context) THEN
1508:
1509: l_result := CONTEXT
1510: (p_operation => l_operation

Line 1522: IF p_line_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

1518: END IF;
1519:
1520: END IF;
1521:
1522: IF p_line_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1523: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute1,p_old_line_adj_rec.attribute1) THEN
1524:
1525: l_result := ATTRIBUTE1
1526: (p_operation => l_operation

Line 1538: IF p_line_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

1534: END IF;
1535:
1536: END IF;
1537:
1538: IF p_line_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1539: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute10,p_old_line_adj_rec.attribute10) THEN
1540:
1541: l_result := ATTRIBUTE10
1542: (p_operation => l_operation

Line 1554: IF p_line_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

1550: END IF;
1551:
1552: END IF;
1553:
1554: IF p_line_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute11,p_old_line_adj_rec.attribute11) THEN
1556:
1557: l_result := ATTRIBUTE11
1558: (p_operation => l_operation

Line 1570: IF p_line_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

1566: END IF;
1567:
1568: END IF;
1569:
1570: IF p_line_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1571: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute12,p_old_line_adj_rec.attribute12) THEN
1572:
1573: l_result := ATTRIBUTE12
1574: (p_operation => l_operation

Line 1586: IF p_line_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

1582: END IF;
1583:
1584: END IF;
1585:
1586: IF p_line_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1587: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute13,p_old_line_adj_rec.attribute13) THEN
1588:
1589: l_result := ATTRIBUTE13
1590: (p_operation => l_operation

Line 1602: IF p_line_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

1598: END IF;
1599:
1600: END IF;
1601:
1602: IF p_line_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute14,p_old_line_adj_rec.attribute14) THEN
1604:
1605: l_result := ATTRIBUTE14
1606: (p_operation => l_operation

Line 1618: IF p_line_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

1614: END IF;
1615:
1616: END IF;
1617:
1618: IF p_line_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1619: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute15,p_old_line_adj_rec.attribute15) THEN
1620:
1621: l_result := ATTRIBUTE15
1622: (p_operation => l_operation

Line 1634: IF p_line_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

1630: END IF;
1631:
1632: END IF;
1633:
1634: IF p_line_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1635: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute2,p_old_line_adj_rec.attribute2) THEN
1636:
1637: l_result := ATTRIBUTE2
1638: (p_operation => l_operation

Line 1650: IF p_line_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

1646: END IF;
1647:
1648: END IF;
1649:
1650: IF p_line_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1651: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute3,p_old_line_adj_rec.attribute3) THEN
1652:
1653: l_result := ATTRIBUTE3
1654: (p_operation => l_operation

Line 1666: IF p_line_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

1662: END IF;
1663:
1664: END IF;
1665:
1666: IF p_line_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1667: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute4,p_old_line_adj_rec.attribute4) THEN
1668:
1669: l_result := ATTRIBUTE4
1670: (p_operation => l_operation

Line 1682: IF p_line_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

1678: END IF;
1679:
1680: END IF;
1681:
1682: IF p_line_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1683: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute5,p_old_line_adj_rec.attribute5) THEN
1684:
1685: l_result := ATTRIBUTE5
1686: (p_operation => l_operation

Line 1698: IF p_line_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

1694: END IF;
1695:
1696: END IF;
1697:
1698: IF p_line_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1699: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute6,p_old_line_adj_rec.attribute6) THEN
1700:
1701: l_result := ATTRIBUTE6
1702: (p_operation => l_operation

Line 1714: IF p_line_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

1710: END IF;
1711:
1712: END IF;
1713:
1714: IF p_line_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1715: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute7,p_old_line_adj_rec.attribute7) THEN
1716:
1717: l_result := ATTRIBUTE7
1718: (p_operation => l_operation

Line 1730: IF p_line_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

1726: END IF;
1727:
1728: END IF;
1729:
1730: IF p_line_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1731: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute8,p_old_line_adj_rec.attribute8) THEN
1732:
1733: l_result := ATTRIBUTE8
1734: (p_operation => l_operation

Line 1746: IF p_line_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

1742: END IF;
1743:
1744: END IF;
1745:
1746: IF p_line_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute9,p_old_line_adj_rec.attribute9) THEN
1748:
1749: l_result := ATTRIBUTE9
1750: (p_operation => l_operation

Line 1778: WHEN FND_API.G_EXC_ERROR THEN

1774: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1775: END IF;
1776:
1777: EXCEPTION
1778: WHEN FND_API.G_EXC_ERROR THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1779: x_return_status := FND_API.G_RET_STS_ERROR;

1775: END IF;
1776:
1777: EXCEPTION
1778: WHEN FND_API.G_EXC_ERROR THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1783: OE_MSG_PUB.Add_Exc_Msg

Line 1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1777: EXCEPTION
1778: WHEN FND_API.G_EXC_ERROR THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1783: OE_MSG_PUB.Add_Exc_Msg
1784: ( G_PKG_NAME
1785: , 'Attributes'