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.3 2006/03/16 13:06:42 appldev noship $ */
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 96: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 107: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

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

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

Line 153: FPA_UTILITIES_PVT.START_ACTIVITY(

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

Line 177: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 188: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 241: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 244: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

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

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

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

Line 257: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 260: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

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

Line 326: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 329: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 338: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

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

Line 339: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 348: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 349: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 359: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

Line 410: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 413: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

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

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

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

Line 426: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 429: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

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

Line 508: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 510: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 519: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

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

Line 520: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 529: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 530: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 540: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

Line 602: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 603: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

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

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

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

Line 616: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 619: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

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

Line 641: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 649: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

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

Line 650: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 659: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 660: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 670: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

Line 701: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 702: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

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

Line 745: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 753: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

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

Line 754: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 763: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 764: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 774: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

Line 871: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

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

Line 874: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

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

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

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

Line 887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

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

Line 901: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 987: FPA_UTILITIES_PVT.END_ACTIVITY(

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

Line 995: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

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

Line 996: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 1005: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 1006: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

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

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

Line 1016: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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