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 315: RAISE FND_API.G_EXC_ERROR;

311: -- Set error message.
312: FND_MESSAGE.SET_NAME('FPA','FPA_TARGET_FROM_GT_TO');
313: FND_MESSAGE.SET_TOKEN('FINMETRIC', l_target_name);
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: end if;
317:
318: -- Limit financial_metrics_d
319: dbms_aw.execute('LMT financial_metrics_d TO ''' || p_fin_targets_tbl(i).financial_metrics || '''' );

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: );
334: END IF;
335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: WHEN OTHERS THEN
340: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
341:

Line 338: RAISE FND_API.G_EXC_ERROR;

334: END IF;
335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: WHEN OTHERS THEN
340: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
341:
342: ROLLBACK;

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: WHEN OTHERS THEN
340: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
341:
342: ROLLBACK;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344:
345: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
346: FND_LOG.String
347: (

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

516: WHEN OTHERS THEN
517: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
518:
519: ROLLBACK;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
523: FND_LOG.String
524: (

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: ROLLBACK;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586:
587: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
588: FND_LOG.String
589: (

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: ROLLBACK;
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
650: FND_LOG.String
651: (

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: ROLLBACK;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731:
732: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
733: FND_LOG.String
734: (

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: ROLLBACK;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794:
795: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
796: FND_LOG.String
797: (

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

895:
896: EXCEPTION
897: WHEN OTHERS THEN
898: ROLLBACK;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900:
901: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: FND_LOG.String
903: (

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: ROLLBACK;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019:
1020: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1021: FND_LOG.String
1022: (

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1099:
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: ROLLBACK;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104:
1105: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1106: FND_LOG.String
1107: (

Line 1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1176:
1177: EXCEPTION
1178: WHEN OTHERS THEN
1179: ROLLBACK;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181:
1182: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1183: FND_LOG.String
1184: (

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: ROLLBACK;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259:
1260: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1261: FND_LOG.String
1262: (

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1343: WHEN OTHERS THEN
1344: ----DBMS_OUTPUT.put_line('...Inside EXCEPTION block...');
1345: ROLLBACK;
1346:
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348:
1349: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1350: FND_LOG.String
1351: (

Line 1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1469: WHEN OTHERS THEN
1470: --DBMS_OUTPUT.put_line('...Inside EXCEPTION block...');
1471: ROLLBACK;
1472:
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474:
1475: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1476: FND_LOG.String
1477: (

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532:
1533: EXCEPTION
1534: WHEN OTHERS THEN
1535: ROLLBACK;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1538: fnd_log.string
1539: (
1540: FND_LOG.LEVEL_ERROR,

Line 1644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1640:
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: ROLLBACK;
1644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1645: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1646: fnd_log.string
1647: (
1648: FND_LOG.LEVEL_ERROR,

Line 1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1748:
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: ROLLBACK;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1754: fnd_log.string
1755: (
1756: FND_LOG.LEVEL_ERROR,

Line 1804: RAISE FND_API.G_EXC_ERROR;

1800: ( FND_LOG.LEVEL_PROCEDURE,
1801: 'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1802: 'Checking API version.');
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;
1805: END IF;
1806:
1807: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1808: FND_LOG.String

Line 1833: WHEN FND_API.G_EXC_ERROR THEN

1829: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1830: END IF;
1831:
1832: EXCEPTION
1833: WHEN FND_API.G_EXC_ERROR THEN
1834: RAISE;
1835: WHEN OTHERS THEN
1836: ROLLBACK;
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1833: WHEN FND_API.G_EXC_ERROR THEN
1834: RAISE;
1835: WHEN OTHERS THEN
1836: ROLLBACK;
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String
1840: ( FND_LOG.LEVEL_ERROR,
1841: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',