eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_SCORECARDS_PVT dependencies on FPA_UTILITIES_PVT

Line 5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

1: package body FPA_SCORECARDS_PVT as
2: /* $Header: FPAVSCRB.pls 120.6 2011/03/29 21:44:12 skkoppul ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SCORECARDS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'SCORECARDS';
8:
9:

Line 20: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

16: ) IS
17:
18: l_api_version CONSTANT NUMBER := 1;
19: l_api_name CONSTANT VARCHAR2(30) := 'insert_tl_rec';
20: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
21: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;
22: l_msg_log VARCHAR2(2000) := null;
23:
24: CURSOR get_languages IS

Line 36: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

32: FUNCTION Set_Attributes (
33: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
34: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
35: ) RETURN VARCHAR2 IS
36: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
37: BEGIN
38: x_scorecards_tl_rec := p_scorecards_tl_rec;
39:
40: x_scorecards_tl_rec.LANGUAGE := USERENV('LANG');

Line 53: FPA_UTILITIES_PVT.START_ACTIVITY(

49:
50: END Set_Attributes;
51:
52: BEGIN
53: FPA_UTILITIES_PVT.START_ACTIVITY(
54: p_api_name => l_api_name,
55: p_pkg_name => G_PKG_NAME,
56: p_init_msg_list => p_init_msg_list,
57: p_msg_log => 'Entering Fpa_Scorecards_Pvt.insert_tl_rec');

Line 97: FPA_UTILITIES_PVT.END_ACTIVITY(

93: END LOOP;
94:
95: x_return_status := l_return_status;
96:
97: FPA_UTILITIES_PVT.END_ACTIVITY(
98: p_api_name => l_api_name,
99: p_pkg_name => G_PKG_NAME,
100: p_msg_log => null,
101: x_msg_count => x_msg_count,

Line 108: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

104: EXCEPTION
105:
106: when OTHERS then
107: -- to change for using call with no rollback
108: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
109: p_api_name => l_api_name,
110: p_pkg_name => G_PKG_NAME,
111: p_exc_name => 'OTHERS',
112: p_msg_log => l_msg_log||SQLERRM,

Line 131: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

127: ) IS
128:
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'update_tl_rec';
131: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
132: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;
133: l_msg_log VARCHAR2(2000) := null;
134: -----------------------------------------
135: -- Set_Attributes for:FPA_SCORECARDS_TL --

Line 141: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

137: FUNCTION Set_Attributes (
138: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
139: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
140: ) RETURN VARCHAR2 IS
141: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
142: BEGIN
143: x_scorecards_tl_rec := p_scorecards_tl_rec;
144:
145: x_scorecards_tl_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 154: FPA_UTILITIES_PVT.START_ACTIVITY(

150:
151: END Set_Attributes;
152:
153: BEGIN
154: FPA_UTILITIES_PVT.START_ACTIVITY(
155: p_api_name => l_api_name,
156: p_pkg_name => G_PKG_NAME,
157: p_init_msg_list => p_init_msg_list,
158: p_msg_log => 'Entering Fpa_Scorecards_Pvt.update_tl_rec');

Line 178: FPA_UTILITIES_PVT.END_ACTIVITY(

174: source_lang = userenv('LANG');
175:
176: x_return_status := l_return_status;
177:
178: FPA_UTILITIES_PVT.END_ACTIVITY(
179: p_api_name => l_api_name,
180: p_pkg_name => G_PKG_NAME,
181: p_msg_log => null,
182: x_msg_count => x_msg_count,

Line 189: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

185: EXCEPTION
186:
187: when OTHERS then
188: -- to change for using call with no rollback
189: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
190: p_api_name => l_api_name,
191: p_pkg_name => G_PKG_NAME,
192: p_exc_name => 'OTHERS',
193: p_msg_log => l_msg_log||SQLERRM,

Line 240: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

236:
237:
238: BEGIN
239:
240: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
241:
242: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
243: -- call START_ACTIVITY to create savepoint, check compatibility
244: -- and initialize message list

Line 242: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

238: BEGIN
239:
240: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
241:
242: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
243: -- call START_ACTIVITY to create savepoint, check compatibility
244: -- and initialize message list
245: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
246: p_api_name => l_api_name,

Line 245: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

241:
242: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
243: -- call START_ACTIVITY to create savepoint, check compatibility
244: -- and initialize message list
245: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
246: p_api_name => l_api_name,
247: p_pkg_name => G_PKG_NAME,
248: p_init_msg_list => p_init_msg_list,
249: l_api_version => l_api_version,

Line 256: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

252: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Pjt_Scorecard_Aw',
253: x_return_status => x_return_status);
254:
255: -- check if activity started successfully
256: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
257: l_msg_log := 'start_activity';
258: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
259: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
260: l_msg_log := 'start_activity';

Line 258: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

254:
255: -- check if activity started successfully
256: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
257: l_msg_log := 'start_activity';
258: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
259: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
260: l_msg_log := 'start_activity';
261: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
262: end if;

Line 259: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

255: -- check if activity started successfully
256: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
257: l_msg_log := 'start_activity';
258: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
259: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
260: l_msg_log := 'start_activity';
261: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
262: end if;
263:

Line 261: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

257: l_msg_log := 'start_activity';
258: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
259: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
260: l_msg_log := 'start_activity';
261: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
262: end if;
263:
264: if(p_scorecard_tbl.count > 0) then
265:

Line 327: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

323: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
324: dbms_aw.execute('project_strategic_obj_weights_score_m = NA' );
325:
326: end if;
327: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
328:
329:
330: FPA_UTILITIES_PVT.END_ACTIVITY(
331: p_api_name => l_api_name,

Line 330: FPA_UTILITIES_PVT.END_ACTIVITY(

326: end if;
327: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
328:
329:
330: FPA_UTILITIES_PVT.END_ACTIVITY(
331: p_api_name => l_api_name,
332: p_pkg_name => G_PKG_NAME,
333: p_msg_log => null,
334: x_msg_count => x_msg_count,

Line 339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

335: x_msg_data => x_msg_data);
336:
337:
338: EXCEPTION
339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

336:
337:
338: EXCEPTION
339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
344: p_msg_log => l_msg_log,

Line 343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
344: p_msg_log => l_msg_log,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,
347: p_api_type => G_API_TYPE);

Line 349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,
347: p_api_type => G_API_TYPE);
348:
349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
351: p_api_name => l_api_name,
352: p_pkg_name => G_PKG_NAME,
353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

346: x_msg_data => x_msg_data,
347: p_api_type => G_API_TYPE);
348:
349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
351: p_api_name => l_api_name,
352: p_pkg_name => G_PKG_NAME,
353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
354: p_msg_log => l_msg_log,

Line 353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
351: p_api_name => l_api_name,
352: p_pkg_name => G_PKG_NAME,
353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
354: p_msg_log => l_msg_log,
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: p_api_type => G_API_TYPE);

Line 360: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

356: x_msg_data => x_msg_data,
357: p_api_type => G_API_TYPE);
358:
359: when OTHERS then
360: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
361: p_api_name => l_api_name,
362: p_pkg_name => G_PKG_NAME,
363: p_exc_name => 'OTHERS',
364: p_msg_log => l_msg_log||SQLERRM,

Line 411: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

407: and source_lang = USERENV('LANG');
408:
409: BEGIN
410:
411: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
412: -- call START_ACTIVITY to create savepoint, check compatibility
413: -- and initialize message list
414: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
415: p_api_name => l_api_name,

Line 414: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

410:
411: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
412: -- call START_ACTIVITY to create savepoint, check compatibility
413: -- and initialize message list
414: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
415: p_api_name => l_api_name,
416: p_pkg_name => G_PKG_NAME,
417: p_init_msg_list => p_init_msg_list,
418: l_api_version => l_api_version,

Line 425: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

421: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Scen_Scorecard_Aw',
422: x_return_status => x_return_status);
423:
424: -- check if activity started successfully
425: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
426: l_msg_log := 'start_activity';
427: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
428: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
429: l_msg_log := 'start_activity';

Line 427: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

423:
424: -- check if activity started successfully
425: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
426: l_msg_log := 'start_activity';
427: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
428: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
429: l_msg_log := 'start_activity';
430: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
431: end if;

Line 428: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

424: -- check if activity started successfully
425: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
426: l_msg_log := 'start_activity';
427: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
428: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
429: l_msg_log := 'start_activity';
430: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
431: end if;
432:

Line 430: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

426: l_msg_log := 'start_activity';
427: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
428: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
429: l_msg_log := 'start_activity';
430: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
431: end if;
432:
433: if(p_scorecard_tbl.count > 0) then
434:

Line 509: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

505: 'na,' ||
506: p_project_id || ')' );
507:
508: end if;
509: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
510:
511: FPA_UTILITIES_PVT.END_ACTIVITY(
512: p_api_name => l_api_name,
513: p_pkg_name => G_PKG_NAME,

Line 511: FPA_UTILITIES_PVT.END_ACTIVITY(

507:
508: end if;
509: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
510:
511: FPA_UTILITIES_PVT.END_ACTIVITY(
512: p_api_name => l_api_name,
513: p_pkg_name => G_PKG_NAME,
514: p_msg_log => null,
515: x_msg_count => x_msg_count,

Line 520: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

516: x_msg_data => x_msg_data);
517:
518:
519: EXCEPTION
520: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
521: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
522: p_api_name => l_api_name,
523: p_pkg_name => G_PKG_NAME,
524: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 521: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

517:
518:
519: EXCEPTION
520: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
521: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
522: p_api_name => l_api_name,
523: p_pkg_name => G_PKG_NAME,
524: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
525: p_msg_log => l_msg_log,

Line 524: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

520: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
521: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
522: p_api_name => l_api_name,
523: p_pkg_name => G_PKG_NAME,
524: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
525: p_msg_log => l_msg_log,
526: x_msg_count => x_msg_count,
527: x_msg_data => x_msg_data,
528: p_api_type => G_API_TYPE);

Line 530: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

526: x_msg_count => x_msg_count,
527: x_msg_data => x_msg_data,
528: p_api_type => G_API_TYPE);
529:
530: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
531: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
532: p_api_name => l_api_name,
533: p_pkg_name => G_PKG_NAME,
534: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 531: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

527: x_msg_data => x_msg_data,
528: p_api_type => G_API_TYPE);
529:
530: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
531: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
532: p_api_name => l_api_name,
533: p_pkg_name => G_PKG_NAME,
534: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
535: p_msg_log => l_msg_log,

Line 534: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

530: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
531: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
532: p_api_name => l_api_name,
533: p_pkg_name => G_PKG_NAME,
534: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
535: p_msg_log => l_msg_log,
536: x_msg_count => x_msg_count,
537: x_msg_data => x_msg_data,
538: p_api_type => G_API_TYPE);

Line 541: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

537: x_msg_data => x_msg_data,
538: p_api_type => G_API_TYPE);
539:
540: when OTHERS then
541: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
542: p_api_name => l_api_name,
543: p_pkg_name => G_PKG_NAME,
544: p_exc_name => 'OTHERS',
545: p_msg_log => l_msg_log||SQLERRM,

Line 603: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

599: END Calc_Scenario_Wscores;
600:
601: BEGIN
602:
603: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
604: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
605: p_api_name => l_api_name,
606: p_pkg_name => G_PKG_NAME,
607: p_init_msg_list => p_init_msg_list,

Line 604: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

600:
601: BEGIN
602:
603: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
604: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
605: p_api_name => l_api_name,
606: p_pkg_name => G_PKG_NAME,
607: p_init_msg_list => p_init_msg_list,
608: l_api_version => l_api_version,

Line 615: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

611: p_msg_log => 'Entering Fpa_Project_Load_Pvt.Calc_Scenario_Wscores_Aw',
612: x_return_status => x_return_status);
613:
614: -- check if activity started successfully
615: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
616: l_msg_log := 'start_activity';
617: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
618: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
619: l_msg_log := 'start_activity';

Line 617: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

613:
614: -- check if activity started successfully
615: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
616: l_msg_log := 'start_activity';
617: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
618: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
619: l_msg_log := 'start_activity';
620: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
621: end if;

Line 618: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

614: -- check if activity started successfully
615: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
616: l_msg_log := 'start_activity';
617: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
618: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
619: l_msg_log := 'start_activity';
620: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
621: end if;
622:

Line 620: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

616: l_msg_log := 'start_activity';
617: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
618: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
619: l_msg_log := 'start_activity';
620: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
621: end if;
622:
623: -- calculate scenario weighted scores
624: -- fetch planning cycle (and initial scenario on the planning cycle)

Line 642: FPA_UTILITIES_PVT.END_ACTIVITY(

638: calc_scenario_wscores(l_planning_cycle_id, l_init_scenario_id);
639: end if;
640:
641:
642: FPA_UTILITIES_PVT.END_ACTIVITY(
643: p_api_name => l_api_name,
644: p_pkg_name => G_PKG_NAME,
645: p_msg_log => null,
646: x_msg_count => x_msg_count,

Line 650: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data);
648:
649: EXCEPTION
650: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
651: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 651: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

647: x_msg_data => x_msg_data);
648:
649: EXCEPTION
650: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
651: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
655: p_msg_log => l_msg_log,

Line 654: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

650: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
651: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
655: p_msg_log => l_msg_log,
656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data,
658: p_api_type => G_API_TYPE);

Line 660: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data,
658: p_api_type => G_API_TYPE);
659:
660: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => G_PKG_NAME,
664: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 661: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

657: x_msg_data => x_msg_data,
658: p_api_type => G_API_TYPE);
659:
660: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => G_PKG_NAME,
664: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
665: p_msg_log => l_msg_log,

Line 664: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

660: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => G_PKG_NAME,
664: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
665: p_msg_log => l_msg_log,
666: x_msg_count => x_msg_count,
667: x_msg_data => x_msg_data,
668: p_api_type => G_API_TYPE);

Line 671: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

667: x_msg_data => x_msg_data,
668: p_api_type => G_API_TYPE);
669:
670: when OTHERS then
671: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
672: p_api_name => l_api_name,
673: p_pkg_name => G_PKG_NAME,
674: p_exc_name => 'OTHERS',
675: p_msg_log => l_msg_log||SQLERRM,

Line 702: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

698: l_msg_log VARCHAR2(2000) := null;
699:
700: begin
701:
702: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
703: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
704: p_api_name => l_api_name,
705: p_pkg_name => G_PKG_NAME,
706: p_init_msg_list => p_init_msg_list,

Line 703: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

699:
700: begin
701:
702: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
703: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
704: p_api_name => l_api_name,
705: p_pkg_name => G_PKG_NAME,
706: p_init_msg_list => p_init_msg_list,
707: l_api_version => l_api_version,

Line 746: FPA_UTILITIES_PVT.END_ACTIVITY(

742: END IF;
743:
744:
745:
746: FPA_UTILITIES_PVT.END_ACTIVITY(
747: p_api_name => l_api_name,
748: p_pkg_name => G_PKG_NAME,
749: p_msg_log => null,
750: x_msg_count => x_msg_count,

Line 754: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

750: x_msg_count => x_msg_count,
751: x_msg_data => x_msg_data);
752:
753: EXCEPTION
754: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
755: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
756: p_api_name => l_api_name,
757: p_pkg_name => G_PKG_NAME,
758: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 755: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

751: x_msg_data => x_msg_data);
752:
753: EXCEPTION
754: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
755: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
756: p_api_name => l_api_name,
757: p_pkg_name => G_PKG_NAME,
758: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
759: p_msg_log => l_msg_log,

Line 758: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

754: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
755: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
756: p_api_name => l_api_name,
757: p_pkg_name => G_PKG_NAME,
758: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
759: p_msg_log => l_msg_log,
760: x_msg_count => x_msg_count,
761: x_msg_data => x_msg_data,
762: p_api_type => G_API_TYPE);

Line 764: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

760: x_msg_count => x_msg_count,
761: x_msg_data => x_msg_data,
762: p_api_type => G_API_TYPE);
763:
764: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
765: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 765: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

761: x_msg_data => x_msg_data,
762: p_api_type => G_API_TYPE);
763:
764: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
765: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
769: p_msg_log => l_msg_log,

Line 768: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

764: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
765: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
769: p_msg_log => l_msg_log,
770: x_msg_count => x_msg_count,
771: x_msg_data => x_msg_data,
772: p_api_type => G_API_TYPE);

Line 775: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

771: x_msg_data => x_msg_data,
772: p_api_type => G_API_TYPE);
773:
774: when OTHERS then
775: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
776: p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,
778: p_exc_name => 'OTHERS',
779: p_msg_log => l_msg_log||SQLERRM,

Line 872: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

868:
869:
870: BEGIN
871:
872: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
873: -- call START_ACTIVITY to create savepoint, check compatibility
874: -- and initialize message list
875: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
876: p_api_name => l_api_name,

Line 875: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

871:
872: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
873: -- call START_ACTIVITY to create savepoint, check compatibility
874: -- and initialize message list
875: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
876: p_api_name => l_api_name,
877: p_pkg_name => G_PKG_NAME,
878: p_init_msg_list => p_init_msg_list,
879: l_api_version => l_api_version,

Line 886: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

882: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Handle_Comments '||p_scenario_id,
883: x_return_status => x_return_status);
884:
885: -- check if activity started successfully
886: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
887: l_msg_log := 'start_activity';
888: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
889: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
890: l_msg_log := 'start_activity';

Line 888: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

884:
885: -- check if activity started successfully
886: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
887: l_msg_log := 'start_activity';
888: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
889: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
890: l_msg_log := 'start_activity';
891: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
892: end if;

Line 889: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

885: -- check if activity started successfully
886: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
887: l_msg_log := 'start_activity';
888: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
889: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
890: l_msg_log := 'start_activity';
891: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
892: end if;
893:

Line 891: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

887: l_msg_log := 'start_activity';
888: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
889: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
890: l_msg_log := 'start_activity';
891: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
892: end if;
893:
894: IF (p_delete_project_id is not null) then
895: DELETE

Line 902: FPA_UTILITIES_PVT.END_ACTIVITY(

898: AND PROJECT_ID = P_DELETE_PROJECT_ID
899: AND LANGUAGE = userenv('LANG')
900: AND SOURCE_LANG = userenv('LANG');
901:
902: FPA_UTILITIES_PVT.END_ACTIVITY(
903: p_api_name => l_api_name,
904: p_pkg_name => G_PKG_NAME,
905: p_msg_log => null,
906: x_msg_count => x_msg_count,

Line 988: FPA_UTILITIES_PVT.END_ACTIVITY(

984: END IF;
985:
986: END IF; -- elsif PJP
987:
988: FPA_UTILITIES_PVT.END_ACTIVITY(
989: p_api_name => l_api_name,
990: p_pkg_name => G_PKG_NAME,
991: p_msg_log => null,
992: x_msg_count => x_msg_count,

Line 996: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

992: x_msg_count => x_msg_count,
993: x_msg_data => x_msg_data);
994:
995: EXCEPTION
996: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
997: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
998: p_api_name => l_api_name,
999: p_pkg_name => G_PKG_NAME,
1000: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 997: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

993: x_msg_data => x_msg_data);
994:
995: EXCEPTION
996: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
997: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
998: p_api_name => l_api_name,
999: p_pkg_name => G_PKG_NAME,
1000: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1001: p_msg_log => l_msg_log,

Line 1000: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

996: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
997: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
998: p_api_name => l_api_name,
999: p_pkg_name => G_PKG_NAME,
1000: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1001: p_msg_log => l_msg_log,
1002: x_msg_count => x_msg_count,
1003: x_msg_data => x_msg_data,
1004: p_api_type => G_API_TYPE);

Line 1006: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1002: x_msg_count => x_msg_count,
1003: x_msg_data => x_msg_data,
1004: p_api_type => G_API_TYPE);
1005:
1006: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1007: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1008: p_api_name => l_api_name,
1009: p_pkg_name => G_PKG_NAME,
1010: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1007: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1003: x_msg_data => x_msg_data,
1004: p_api_type => G_API_TYPE);
1005:
1006: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1007: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1008: p_api_name => l_api_name,
1009: p_pkg_name => G_PKG_NAME,
1010: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1011: p_msg_log => l_msg_log,

Line 1010: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

1006: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1007: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1008: p_api_name => l_api_name,
1009: p_pkg_name => G_PKG_NAME,
1010: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1011: p_msg_log => l_msg_log,
1012: x_msg_count => x_msg_count,
1013: x_msg_data => x_msg_data,
1014: p_api_type => G_API_TYPE);

Line 1017: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1013: x_msg_data => x_msg_data,
1014: p_api_type => G_API_TYPE);
1015:
1016: when OTHERS then
1017: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1018: p_api_name => l_api_name,
1019: p_pkg_name => G_PKG_NAME,
1020: p_exc_name => 'OTHERS',
1021: p_msg_log => l_msg_log||SQLERRM,