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 1369: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;

1365: -- Compare the new and old entity records and
1366: -- check constraints for all the changed attributes.
1367:
1368:
1369: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1370: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN
1371:
1372: l_result := AUTOMATIC
1373: (p_operation => l_operation

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

1381: END IF;
1382:
1383: END IF;
1384:
1385: IF p_line_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1386: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_id,p_old_line_adj_rec.discount_id) THEN
1387:
1388: l_result := DISCOUNT
1389: (p_operation => l_operation

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

1397: END IF;
1398:
1399: END IF;
1400:
1401: IF p_line_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;
1402: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.operand,p_old_line_adj_rec.operand) THEN
1403:
1404: l_result := OPERAND
1405: (p_operation => l_operation

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

1413: END IF;
1414:
1415: END IF;
1416:
1417: IF p_line_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;
1418: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_line_id,p_old_line_adj_rec.discount_line_id) THEN
1419:
1420: l_result := DISCOUNT_LINE
1421: (p_operation => l_operation

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

1429: END IF;
1430:
1431: END IF;
1432:
1433: IF p_line_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;
1434: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.percent,p_old_line_adj_rec.percent) THEN
1435:
1436: l_result := PERCENT
1437: (p_operation => l_operation

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

1445: END IF;
1446:
1447: END IF;
1448:
1449: IF p_line_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;
1450: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.request_id,p_old_line_adj_rec.request_id) THEN
1451:
1452: l_result := REQUEST
1453: (p_operation => l_operation

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

1477: l_check_all_cols_constraint := g_check_all_cols_constraint;
1478: g_check_all_cols_constraint := 'N';
1479: END IF;
1480:
1481: IF p_line_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1482: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.context,p_old_line_adj_rec.context) THEN
1483:
1484: l_result := CONTEXT
1485: (p_operation => l_operation

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

1493: END IF;
1494:
1495: END IF;
1496:
1497: IF p_line_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1498: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute1,p_old_line_adj_rec.attribute1) THEN
1499:
1500: l_result := ATTRIBUTE1
1501: (p_operation => l_operation

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

1509: END IF;
1510:
1511: END IF;
1512:
1513: IF p_line_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1514: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute10,p_old_line_adj_rec.attribute10) THEN
1515:
1516: l_result := ATTRIBUTE10
1517: (p_operation => l_operation

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

1525: END IF;
1526:
1527: END IF;
1528:
1529: IF p_line_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1530: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute11,p_old_line_adj_rec.attribute11) THEN
1531:
1532: l_result := ATTRIBUTE11
1533: (p_operation => l_operation

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

1541: END IF;
1542:
1543: END IF;
1544:
1545: IF p_line_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1546: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute12,p_old_line_adj_rec.attribute12) THEN
1547:
1548: l_result := ATTRIBUTE12
1549: (p_operation => l_operation

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

1557: END IF;
1558:
1559: END IF;
1560:
1561: IF p_line_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1562: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute13,p_old_line_adj_rec.attribute13) THEN
1563:
1564: l_result := ATTRIBUTE13
1565: (p_operation => l_operation

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

1573: END IF;
1574:
1575: END IF;
1576:
1577: IF p_line_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1578: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute14,p_old_line_adj_rec.attribute14) THEN
1579:
1580: l_result := ATTRIBUTE14
1581: (p_operation => l_operation

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

1589: END IF;
1590:
1591: END IF;
1592:
1593: IF p_line_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1594: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute15,p_old_line_adj_rec.attribute15) THEN
1595:
1596: l_result := ATTRIBUTE15
1597: (p_operation => l_operation

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

1605: END IF;
1606:
1607: END IF;
1608:
1609: IF p_line_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1610: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute2,p_old_line_adj_rec.attribute2) THEN
1611:
1612: l_result := ATTRIBUTE2
1613: (p_operation => l_operation

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

1621: END IF;
1622:
1623: END IF;
1624:
1625: IF p_line_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1626: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute3,p_old_line_adj_rec.attribute3) THEN
1627:
1628: l_result := ATTRIBUTE3
1629: (p_operation => l_operation

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

1637: END IF;
1638:
1639: END IF;
1640:
1641: IF p_line_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1642: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute4,p_old_line_adj_rec.attribute4) THEN
1643:
1644: l_result := ATTRIBUTE4
1645: (p_operation => l_operation

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

1653: END IF;
1654:
1655: END IF;
1656:
1657: IF p_line_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1658: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute5,p_old_line_adj_rec.attribute5) THEN
1659:
1660: l_result := ATTRIBUTE5
1661: (p_operation => l_operation

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

1669: END IF;
1670:
1671: END IF;
1672:
1673: IF p_line_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1674: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute6,p_old_line_adj_rec.attribute6) THEN
1675:
1676: l_result := ATTRIBUTE6
1677: (p_operation => l_operation

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

1685: END IF;
1686:
1687: END IF;
1688:
1689: IF p_line_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1690: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute7,p_old_line_adj_rec.attribute7) THEN
1691:
1692: l_result := ATTRIBUTE7
1693: (p_operation => l_operation

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

1701: END IF;
1702:
1703: END IF;
1704:
1705: IF p_line_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1706: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute8,p_old_line_adj_rec.attribute8) THEN
1707:
1708: l_result := ATTRIBUTE8
1709: (p_operation => l_operation

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

1717: END IF;
1718:
1719: END IF;
1720:
1721: IF p_line_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1722: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute9,p_old_line_adj_rec.attribute9) THEN
1723:
1724: l_result := ATTRIBUTE9
1725: (p_operation => l_operation

Line 1753: WHEN FND_API.G_EXC_ERROR THEN

1749: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1750: END IF;
1751:
1752: EXCEPTION
1753: WHEN FND_API.G_EXC_ERROR THEN
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: WHEN OTHERS THEN
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR;

1750: END IF;
1751:
1752: EXCEPTION
1753: WHEN FND_API.G_EXC_ERROR THEN
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: WHEN OTHERS THEN
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1758: OE_MSG_PUB.Add_Exc_Msg

Line 1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1752: EXCEPTION
1753: WHEN FND_API.G_EXC_ERROR THEN
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: WHEN OTHERS THEN
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1758: OE_MSG_PUB.Add_Exc_Msg
1759: ( G_PKG_NAME
1760: , 'Attributes'