DBA Data[Home] [Help]

APPS.FPA_SCENARIO_PVT dependencies on FND_API

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: ROLLBACK;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: fnd_log.string
163: (
164: FND_LOG.LEVEL_ERROR,

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234:
235: EXCEPTION
236: WHEN OTHERS THEN
237: ROLLBACK;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240: fnd_log.string
241: (
242: FND_LOG.LEVEL_ERROR,

Line 261: p_commit IN VARCHAR2 := FND_API.G_FALSE,

257: *******************************************************************************************/
258:
259: PROCEDURE lock_scenario
260: (
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_scenario_rec IN fpa_scenario_pvt.scenario_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2

Line 303: IF (p_commit = FND_API.G_TRUE) THEN

299: || to_char(SYSDATE, 'MM-DD-YYYY') || '''');
300:
301: IF g_attach_aw THEN
302: -- Update and commit our changes
303: IF (p_commit = FND_API.G_TRUE) THEN
304: dbms_aw.execute('UPDATE');
305: COMMIT;
306: END IF;
307:

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: ROLLBACK;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
334: fnd_log.string
335: (

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: ROLLBACK;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
379: fnd_log.string
380: (
381: FND_LOG.LEVEL_ERROR,

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: ROLLBACK;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449:
450: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: fnd_log.string
452: (

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530:
531: EXCEPTION
532: WHEN OTHERS THEN
533: ROLLBACK;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
536: fnd_log.string
537: (
538: FND_LOG.LEVEL_ERROR,

Line 624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

620:
621: EXCEPTION
622: WHEN OTHERS THEN
623: ROLLBACK;
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
626: fnd_log.string
627: (
628: FND_LOG.LEVEL_ERROR,

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: ROLLBACK;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
706: fnd_log.string
707: (
708: FND_LOG.LEVEL_ERROR,

Line 783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

779: EXCEPTION
780: WHEN OTHERS THEN
781: --dbms_output.put_line(SQLERRM);
782: ROLLBACK;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
785: fnd_log.string
786: (
787: FND_LOG.LEVEL_ERROR,

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

853: EXCEPTION
854: WHEN OTHERS THEN
855: --dbms_output.put_line(SQLERRM);
856: ROLLBACK;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859: fnd_log.string
860: (
861: FND_LOG.LEVEL_ERROR,

Line 985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: ROLLBACK;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: fnd_log.string
988: (
989: FND_LOG.LEVEL_ERROR,

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1063: fnd_log.string
1064: (
1065: FND_LOG.LEVEL_ERROR,

Line 1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1115:
1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: ROLLBACK;
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1121: fnd_log.string
1122: (
1123: FND_LOG.LEVEL_ERROR,

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1222: WHEN OTHERS THEN
1223: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
1224:
1225: ROLLBACK;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1229: FND_LOG.String
1230: (

Line 1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1304:
1305: EXCEPTION
1306: WHEN OTHERS THEN
1307: ROLLBACK;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1310: fnd_log.string
1311: (
1312: FND_LOG.LEVEL_ERROR,