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 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: ROLLBACK;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
526: fnd_log.string
527: (
528: FND_LOG.LEVEL_ERROR,

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: ROLLBACK;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
606: fnd_log.string
607: (
608: FND_LOG.LEVEL_ERROR,

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: ROLLBACK;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
686: fnd_log.string
687: (
688: FND_LOG.LEVEL_ERROR,

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: EXCEPTION
760: WHEN OTHERS THEN
761: --dbms_output.put_line(SQLERRM);
762: ROLLBACK;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
765: fnd_log.string
766: (
767: FND_LOG.LEVEL_ERROR,

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: EXCEPTION
834: WHEN OTHERS THEN
835: --dbms_output.put_line(SQLERRM);
836: ROLLBACK;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
839: fnd_log.string
840: (
841: FND_LOG.LEVEL_ERROR,

Line 965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: ROLLBACK;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
967: fnd_log.string
968: (
969: FND_LOG.LEVEL_ERROR,

Line 1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: ROLLBACK;
1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1042: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1043: fnd_log.string
1044: (
1045: FND_LOG.LEVEL_ERROR,

Line 1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: ROLLBACK;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1100: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1101: fnd_log.string
1102: (
1103: FND_LOG.LEVEL_ERROR,

Line 1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1179: WHEN OTHERS THEN
1180: --DBMS_OUTPUT.put_line('...Inside Object level API EXCEPTION block...');
1181:
1182: ROLLBACK;
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184:
1185: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1186: FND_LOG.String
1187: (

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: ROLLBACK;
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1267: fnd_log.string
1268: (
1269: FND_LOG.LEVEL_ERROR,