DBA Data[Home] [Help]

APPS.FPA_PLANNINGCYCLE_PVT dependencies on FND_API

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

136: CLOSE l_language_csr;
137: END IF;
138:
139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141:
142: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
143: FND_LOG.String
144: (

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: WHEN OTHERS THEN
233: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
234:
235: ROLLBACK;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237:
238: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
239: FND_LOG.String
240: (

Line 321: RAISE FND_API.G_EXC_ERROR;

317: -- Set error message.
318: FND_MESSAGE.SET_NAME('FPA','FPA_TARGET_FROM_GT_TO');
319: FND_MESSAGE.SET_TOKEN('FINMETRIC', l_target_name);
320: FND_MSG_PUB.ADD;
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323:
324: -- Limit financial_metrics_d
325: l_financial_target_from_c := REPLACE( To_Char(p_fin_targets_tbl(i).financial_target_from*l_pc_disply_factor), l_decimal_marker,'.');

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344: );
345: END IF;
346:
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: WHEN OTHERS THEN
351: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
352:

Line 349: RAISE FND_API.G_EXC_ERROR;

345: END IF;
346:
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: WHEN OTHERS THEN
351: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
352:
353: ROLLBACK;

Line 354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

350: WHEN OTHERS THEN
351: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
352:
353: ROLLBACK;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355:
356: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
357: FND_LOG.String
358: (

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: WHEN OTHERS THEN
528: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
529:
530: ROLLBACK;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532:
533: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
534: FND_LOG.String
535: (

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: ROLLBACK;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597:
598: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
599: FND_LOG.String
600: (

Line 658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

654:
655: EXCEPTION
656: WHEN OTHERS THEN
657: ROLLBACK;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661: FND_LOG.String
662: (

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

737:
738: EXCEPTION
739: WHEN OTHERS THEN
740: ROLLBACK;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742:
743: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: FND_LOG.String
745: (

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: ROLLBACK;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:
806: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.String
808: (

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906:
907: EXCEPTION
908: WHEN OTHERS THEN
909: ROLLBACK;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911:
912: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
913: FND_LOG.String
914: (

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1025:
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: ROLLBACK;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030:
1031: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1032: FND_LOG.String
1033: (

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: ROLLBACK;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1117: FND_LOG.String
1118: (

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196:
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: ROLLBACK;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1203: FND_LOG.String
1204: (

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: ROLLBACK;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1281: FND_LOG.String
1282: (

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1363: WHEN OTHERS THEN
1364: ----DBMS_OUTPUT.put_line('...Inside EXCEPTION block...');
1365: ROLLBACK;
1366:
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1370: FND_LOG.String
1371: (

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1489: WHEN OTHERS THEN
1490: --DBMS_OUTPUT.put_line('...Inside EXCEPTION block...');
1491: ROLLBACK;
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1496: FND_LOG.String
1497: (

Line 1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1552:
1553: EXCEPTION
1554: WHEN OTHERS THEN
1555: ROLLBACK;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1558: fnd_log.string
1559: (
1560: FND_LOG.LEVEL_ERROR,

Line 1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1660:
1661: EXCEPTION
1662: WHEN OTHERS THEN
1663: ROLLBACK;
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: fnd_log.string
1667: (
1668: FND_LOG.LEVEL_ERROR,

Line 1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1774: fnd_log.string
1775: (
1776: FND_LOG.LEVEL_ERROR,

Line 1824: RAISE FND_API.G_EXC_ERROR;

1820: ( FND_LOG.LEVEL_PROCEDURE,
1821: 'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1822: 'Checking API version.');
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF;
1826:
1827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1828: FND_LOG.String

Line 1853: WHEN FND_API.G_EXC_ERROR THEN

1849: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1850: END IF;
1851:
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: RAISE;
1855: WHEN OTHERS THEN
1856: ROLLBACK;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1853: WHEN FND_API.G_EXC_ERROR THEN
1854: RAISE;
1855: WHEN OTHERS THEN
1856: ROLLBACK;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1859: FND_LOG.String
1860: ( FND_LOG.LEVEL_ERROR,
1861: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',