DBA Data[Home] [Help]

APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT dependencies on FND_API

Line 97: /* IF (p_commit = FND_API.G_TRUE) THEN

93: dbms_aw.execute('LMT project_d to project_set_project_m eq yes');
94: dbms_aw.execute('project_set_project_m = na');
95: dbms_aw.execute('POP project_d');
96:
97: /* IF (p_commit = FND_API.G_TRUE) THEN
98: COMMIT;
99: dbms_aw.execute('UPDATE');
100: END IF;
101: */

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: EXCEPTION
113: WHEN OTHERS THEN
114: ROLLBACK;
115:
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: FND_LOG.STRING
120: (

Line 239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then -- Project Set creation failed

235: x_msg_data => x_msg_data);
236:
237: Fnd_message.CLEAR;
238:
239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then -- Project Set creation failed
240: raise PROGRAM_ERROR;
241: end if;
242: -- project set created successfully
243:

Line 300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then -- Project Set creation failed

296: x_msg_data => x_msg_data);
297:
298: Fnd_message.CLEAR;
299:
300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then -- Project Set creation failed
301: raise PROGRAM_ERROR;
302: end if;
303:
304: -- project set created successfully

Line 344: /* IF (p_commit = FND_API.G_TRUE) THEN

340:
341: END IF;
342: close c_project_sets;
343:
344: /* IF (p_commit = FND_API.G_TRUE) THEN
345: dbms_aw.execute('UPDATE');
346: COMMIT;
347: END IF;
348: */

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: WHEN OTHERS THEN
362: ROLLBACK;
363:
364:
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366:
367: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: FND_LOG.STRING
369: (

Line 513: /* IF (p_commit = FND_API.G_TRUE) THEN

509: dbms_aw.execute('LMT project_d TO ' || l_proj_list(i));
510: dbms_aw.execute('project_set_project_m = yes');
511: END LOOP;
512: END IF;
513: /* IF (p_commit = FND_API.G_TRUE) THEN
514: dbms_aw.execute('UPDATE');
515: COMMIT;
516: END IF;
517: */

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: EXCEPTION
529: WHEN OTHERS THEN
530: ROLLBACK;
531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
535: FND_LOG.STRING
536: (