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_VALIDATION_PROCESS_PVT dependencies on FPA_UTILITIES_PVT

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

1: package body FPA_VALIDATION_PROCESS_PVT as
2: /* $Header: FPAVVLPB.pls 120.16 2011/08/09 01:17:31 skkoppul noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_VALIDATION_PROCESS_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) := 'VALIDATION_PROCESS';
8:
9: PROCEDURE Validate_Project_Details

Line 68: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

64: l_exists VARCHAR2(1) := NULL;
65:
66: BEGIN
67:
68: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
69:
70: select
71: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST'),
72: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')

Line 116: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

112: FPA_VALIDATION_PVT.G_WARNING,
113: p_object_id, 'PROJECT');
114: end if;
115:
116: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
117:
118: FPA_UTILITIES_PVT.END_ACTIVITY(
119: p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,

Line 118: FPA_UTILITIES_PVT.END_ACTIVITY(

114: end if;
115:
116: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
117:
118: FPA_UTILITIES_PVT.END_ACTIVITY(
119: p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_msg_log => null,
122: x_msg_count => x_msg_count,

Line 127: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

123: x_msg_data => x_msg_data);
124:
125:
126: EXCEPTION
127: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
128: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
129: p_api_name => l_api_name,
130: p_pkg_name => G_PKG_NAME,
131: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 128: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

124:
125:
126: EXCEPTION
127: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
128: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
129: p_api_name => l_api_name,
130: p_pkg_name => G_PKG_NAME,
131: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
132: p_msg_log => l_msg_log,

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

127: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
128: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
129: p_api_name => l_api_name,
130: p_pkg_name => G_PKG_NAME,
131: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
132: p_msg_log => l_msg_log,
133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data,
135: p_api_type => G_API_TYPE);

Line 137: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data,
135: p_api_type => G_API_TYPE);
136:
137: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
138: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => G_PKG_NAME,
141: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 138: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

134: x_msg_data => x_msg_data,
135: p_api_type => G_API_TYPE);
136:
137: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
138: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => G_PKG_NAME,
141: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
142: p_msg_log => l_msg_log,

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

137: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
138: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => G_PKG_NAME,
141: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
142: p_msg_log => l_msg_log,
143: x_msg_count => x_msg_count,
144: x_msg_data => x_msg_data,
145: p_api_type => G_API_TYPE);

Line 148: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

144: x_msg_data => x_msg_data,
145: p_api_type => G_API_TYPE);
146:
147: when OTHERS then
148: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
149: p_api_name => l_api_name,
150: p_pkg_name => G_PKG_NAME,
151: p_exc_name => 'OTHERS',
152: p_msg_log => l_msg_log||SQLERRM,

Line 193: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

189:
190:
191: BEGIN
192:
193: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
194:
195: BEGIN
196: SELECT
197: C.VALIDATION_ID,

Line 244: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

240: x_return_status => l_return_status,
241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data);
243:
244: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
245: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
246: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
247: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
248: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';

Line 246: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

242: x_msg_data => l_msg_data);
243:
244: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
245: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
246: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
247: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
248: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
249: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
250: end if;

Line 247: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

243:
244: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
245: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
246: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
247: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
248: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
249: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
250: end if;
251:

Line 249: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

245: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
246: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
247: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
248: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
249: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
250: end if;
251:
252: l_validation_lines_rec := null;
253: l_validation_lines_rec.header_id := l_proj_validation_id;

Line 270: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

266: x_return_status => l_return_status,
267: x_msg_count => l_msg_count,
268: x_msg_data => l_msg_data);
269:
270: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
271: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
272: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
273: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
274: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';

Line 272: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

268: x_msg_data => l_msg_data);
269:
270: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
271: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
272: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
273: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
274: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
275: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
276: end if;

Line 273: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

269:
270: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
271: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
272: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
273: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
274: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
275: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
276: end if;
277:

Line 275: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

271: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
272: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
273: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
274: l_msg_log := 'BUDGET_VERSION_COST-Create_Validation_Line';
275: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
276: end if;
277:
278: l_validation_lines_rec := null;
279: l_validation_lines_rec.header_id := l_proj_validation_id;

Line 296: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

292: x_return_status => l_return_status,
293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data);
295:
296: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
297: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
298: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
299: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
300: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';

Line 298: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

294: x_msg_data => l_msg_data);
295:
296: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
297: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
298: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
299: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
300: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
301: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
302: end if;

Line 299: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

295:
296: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
297: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
298: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
299: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
300: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
301: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
302: end if;
303:

Line 301: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

297: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
298: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
299: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
300: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
301: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
302: end if;
303:
304: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
305:

Line 304: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

300: l_msg_log := 'BUDGET_VERSION_BENEFIT-Create_Validation_Line';
301: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
302: end if;
303:
304: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
305:
306: FPA_UTILITIES_PVT.END_ACTIVITY(
307: p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,

Line 306: FPA_UTILITIES_PVT.END_ACTIVITY(

302: end if;
303:
304: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
305:
306: FPA_UTILITIES_PVT.END_ACTIVITY(
307: p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_msg_log => null,
310: x_msg_count => x_msg_count,

Line 315: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

311: x_msg_data => x_msg_data);
312:
313:
314: EXCEPTION
315: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
316: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
317: p_api_name => l_api_name,
318: p_pkg_name => G_PKG_NAME,
319: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 316: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

312:
313:
314: EXCEPTION
315: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
316: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
317: p_api_name => l_api_name,
318: p_pkg_name => G_PKG_NAME,
319: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
320: p_msg_log => l_msg_log,

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

315: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
316: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
317: p_api_name => l_api_name,
318: p_pkg_name => G_PKG_NAME,
319: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
320: p_msg_log => l_msg_log,
321: x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data,
323: p_api_type => G_API_TYPE);

Line 325: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

321: x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data,
323: p_api_type => G_API_TYPE);
324:
325: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
326: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
327: p_api_name => l_api_name,
328: p_pkg_name => G_PKG_NAME,
329: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 326: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

322: x_msg_data => x_msg_data,
323: p_api_type => G_API_TYPE);
324:
325: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
326: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
327: p_api_name => l_api_name,
328: p_pkg_name => G_PKG_NAME,
329: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
330: p_msg_log => l_msg_log,

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

325: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
326: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
327: p_api_name => l_api_name,
328: p_pkg_name => G_PKG_NAME,
329: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
330: p_msg_log => l_msg_log,
331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_api_type => G_API_TYPE);

Line 336: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

332: x_msg_data => x_msg_data,
333: p_api_type => G_API_TYPE);
334:
335: when OTHERS then
336: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
337: p_api_name => l_api_name,
338: p_pkg_name => G_PKG_NAME,
339: p_exc_name => 'OTHERS',
340: p_msg_log => l_msg_log||SQLERRM,

Line 377: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

373: L_BENEFIT_VLINE_ID NUMBER;
374:
375: BEGIN
376:
377: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
378:
379: SELECT
380: C.VALIDATION_ID,
381: B.VALIDATION_ID

Line 422: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

418: WHERE
419: VALIDATION_ID = L_BENEFIT_VLINE_ID;
420:
421: EXCEPTION
422: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
423: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 423: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

419: VALIDATION_ID = L_BENEFIT_VLINE_ID;
420:
421: EXCEPTION
422: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
423: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
427: p_msg_log => l_msg_log,

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

422: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
423: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
427: p_msg_log => l_msg_log,
428: x_msg_count => x_msg_count,
429: x_msg_data => x_msg_data,
430: p_api_type => G_API_TYPE);

Line 432: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

428: x_msg_count => x_msg_count,
429: x_msg_data => x_msg_data,
430: p_api_type => G_API_TYPE);
431:
432: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
433: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
434: p_api_name => l_api_name,
435: p_pkg_name => G_PKG_NAME,
436: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 433: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

429: x_msg_data => x_msg_data,
430: p_api_type => G_API_TYPE);
431:
432: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
433: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
434: p_api_name => l_api_name,
435: p_pkg_name => G_PKG_NAME,
436: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
437: p_msg_log => l_msg_log,

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

432: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
433: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
434: p_api_name => l_api_name,
435: p_pkg_name => G_PKG_NAME,
436: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
437: p_msg_log => l_msg_log,
438: x_msg_count => x_msg_count,
439: x_msg_data => x_msg_data,
440: p_api_type => G_API_TYPE);

Line 443: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

439: x_msg_data => x_msg_data,
440: p_api_type => G_API_TYPE);
441:
442: when OTHERS then
443: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
444: p_api_name => l_api_name,
445: p_pkg_name => G_PKG_NAME,
446: p_exc_name => 'OTHERS',
447: p_msg_log => l_msg_log||SQLERRM,

Line 513: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

509: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.');
510: END IF;
511:
512: dbms_aw.execute('ALLSTAT');
513: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
514:
515: if(p_header_object_type = 'SCENARIO') then
516: l_scenario_id := p_header_object_id;
517: else

Line 542: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

538: x_return_status => l_return_status,
539: x_msg_count => l_msg_count,
540: x_msg_data => l_msg_data);
541:
542: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
543: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
544: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
545: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
546: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';

Line 544: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

540: x_msg_data => l_msg_data);
541:
542: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
543: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
544: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
545: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
546: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
547: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
548: end if;

Line 545: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

541:
542: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
543: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
544: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
545: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
546: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
547: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
548: end if;
549:

Line 547: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

543: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
544: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
545: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
546: l_msg_log := 'BUDGET_VERSIONS_SCENARIO-Create_Validation_Line';
547: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
548: end if;
549:
550:
551:

Line 566: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

562: x_return_status => l_return_status,
563: x_msg_count => l_msg_count,
564: x_msg_data => l_msg_data);
565:
566: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
567: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
568: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
569: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
570: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';

Line 568: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

564: x_msg_data => l_msg_data);
565:
566: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
567: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
568: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
569: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
570: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
571: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
572: end if;

Line 569: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

565:
566: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
567: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
568: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
569: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
570: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
571: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
572: end if;
573:

Line 571: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

567: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
568: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
569: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
570: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
571: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
572: end if;
573:
574: END LOOP;
575:

Line 576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

572: end if;
573:
574: END LOOP;
575:
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
577:
578: FPA_UTILITIES_PVT.END_ACTIVITY(
579: p_api_name => l_api_name,
580: p_pkg_name => G_PKG_NAME,

Line 578: FPA_UTILITIES_PVT.END_ACTIVITY(

574: END LOOP;
575:
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
577:
578: FPA_UTILITIES_PVT.END_ACTIVITY(
579: p_api_name => l_api_name,
580: p_pkg_name => G_PKG_NAME,
581: p_msg_log => null,
582: x_msg_count => x_msg_count,

Line 587: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

583: x_msg_data => x_msg_data);
584:
585:
586: EXCEPTION
587: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
588: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
589: p_api_name => l_api_name,
590: p_pkg_name => G_PKG_NAME,
591: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 588: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

584:
585:
586: EXCEPTION
587: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
588: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
589: p_api_name => l_api_name,
590: p_pkg_name => G_PKG_NAME,
591: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
592: p_msg_log => l_msg_log,

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

587: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
588: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
589: p_api_name => l_api_name,
590: p_pkg_name => G_PKG_NAME,
591: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
592: p_msg_log => l_msg_log,
593: x_msg_count => x_msg_count,
594: x_msg_data => x_msg_data,
595: p_api_type => G_API_TYPE);

Line 597: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

593: x_msg_count => x_msg_count,
594: x_msg_data => x_msg_data,
595: p_api_type => G_API_TYPE);
596:
597: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
598: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
599: p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 598: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

594: x_msg_data => x_msg_data,
595: p_api_type => G_API_TYPE);
596:
597: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
598: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
599: p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
602: p_msg_log => l_msg_log,

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

597: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
598: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
599: p_api_name => l_api_name,
600: p_pkg_name => G_PKG_NAME,
601: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
602: p_msg_log => l_msg_log,
603: x_msg_count => x_msg_count,
604: x_msg_data => x_msg_data,
605: p_api_type => G_API_TYPE);

Line 609: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

605: p_api_type => G_API_TYPE);
606:
607:
608: when OTHERS then
609: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
610: p_api_name => l_api_name,
611: p_pkg_name => G_PKG_NAME,
612: p_exc_name => 'OTHERS',
613: p_msg_log => l_msg_log||SQLERRM,

Line 676: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

672: END IF;
673:
674: l_type := p_type;
675:
676: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
677:
678: IF(p_header_object_type = 'SCENARIO') THEN
679: l_scenario_id := p_header_object_id;
680: ELSE

Line 803: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

799: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
800: 'Checking return status inside loop for inserting creating FPA_VALIDATION_LINES.');
801: END IF;
802:
803: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
804: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
805: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
806: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
807: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';

Line 805: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

801: END IF;
802:
803: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
804: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
805: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
806: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
807: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
808: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
809: end if;

Line 806: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

802:
803: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
804: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
805: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
806: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
807: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
808: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
809: end if;
810:

Line 808: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

804: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
805: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
806: elsif (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
807: l_msg_log := 'BUDGET_VERSIONS_PROJ-Create_Validation_Line';
808: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
809: end if;
810:
811: END LOOP;
812:

Line 822: 'Calling FPA_UTILITIES_PVT.G_RET_STS_SUCCESS.');

818:
819: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
820: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
821: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
822: 'Calling FPA_UTILITIES_PVT.G_RET_STS_SUCCESS.');
823: END IF;
824:
825: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
826:

Line 825: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

821: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
822: 'Calling FPA_UTILITIES_PVT.G_RET_STS_SUCCESS.');
823: END IF;
824:
825: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
826:
827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
828: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
829: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

Line 830: 'Calling FPA_UTILITIES_PVT.END_ACTIVITY.');

826:
827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
828: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
829: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
830: 'Calling FPA_UTILITIES_PVT.END_ACTIVITY.');
831: END IF;
832:
833: FPA_UTILITIES_PVT.END_ACTIVITY(
834: p_api_name => l_api_name,

Line 833: FPA_UTILITIES_PVT.END_ACTIVITY(

829: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
830: 'Calling FPA_UTILITIES_PVT.END_ACTIVITY.');
831: END IF;
832:
833: FPA_UTILITIES_PVT.END_ACTIVITY(
834: p_api_name => l_api_name,
835: p_pkg_name => G_PKG_NAME,
836: p_msg_log => null,
837: x_msg_count => x_msg_count,

Line 848: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

844: END IF;
845:
846:
847: EXCEPTION
848: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
849: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
850: p_api_name => l_api_name,
851: p_pkg_name => G_PKG_NAME,
852: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 849: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

845:
846:
847: EXCEPTION
848: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
849: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
850: p_api_name => l_api_name,
851: p_pkg_name => G_PKG_NAME,
852: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
853: p_msg_log => l_msg_log,

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

848: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
849: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
850: p_api_name => l_api_name,
851: p_pkg_name => G_PKG_NAME,
852: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
853: p_msg_log => l_msg_log,
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data,
856: p_api_type => G_API_TYPE);

Line 858: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data,
856: p_api_type => G_API_TYPE);
857:
858: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
859: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
860: p_api_name => l_api_name,
861: p_pkg_name => G_PKG_NAME,
862: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 859: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

855: x_msg_data => x_msg_data,
856: p_api_type => G_API_TYPE);
857:
858: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
859: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
860: p_api_name => l_api_name,
861: p_pkg_name => G_PKG_NAME,
862: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
863: p_msg_log => l_msg_log,

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

858: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
859: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
860: p_api_name => l_api_name,
861: p_pkg_name => G_PKG_NAME,
862: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
863: p_msg_log => l_msg_log,
864: x_msg_count => x_msg_count,
865: x_msg_data => x_msg_data,
866: p_api_type => G_API_TYPE);

Line 869: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

865: x_msg_data => x_msg_data,
866: p_api_type => G_API_TYPE);
867:
868: when OTHERS then
869: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
870: p_api_name => l_api_name,
871: p_pkg_name => G_PKG_NAME,
872: p_exc_name => 'OTHERS',
873: p_msg_log => l_msg_log||SQLERRM,

Line 917: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

913:
914: collect_projects_rec collect_projects_csr%ROWTYPE;
915:
916: BEGIN
917: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
918:
919: FOR collect_projects_rec in collect_projects_csr(p_header_object_id) LOOP
920:
921: Fpa_Project_Pvt.Get_Project_Details(

Line 957: FPA_UTILITIES_PVT.END_ACTIVITY(

953:
954: END LOOP;
955:
956:
957: FPA_UTILITIES_PVT.END_ACTIVITY(
958: p_api_name => l_api_name,
959: p_pkg_name => G_PKG_NAME,
960: p_msg_log => null,
961: x_msg_count => x_msg_count,

Line 966: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

962: x_msg_data => x_msg_data);
963:
964:
965: EXCEPTION
966: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
967: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
968: p_api_name => l_api_name,
969: p_pkg_name => G_PKG_NAME,
970: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 967: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

963:
964:
965: EXCEPTION
966: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
967: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
968: p_api_name => l_api_name,
969: p_pkg_name => G_PKG_NAME,
970: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
971: p_msg_log => l_msg_log,

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

966: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
967: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
968: p_api_name => l_api_name,
969: p_pkg_name => G_PKG_NAME,
970: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
971: p_msg_log => l_msg_log,
972: x_msg_count => x_msg_count,
973: x_msg_data => x_msg_data,
974: p_api_type => G_API_TYPE);

Line 976: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

972: x_msg_count => x_msg_count,
973: x_msg_data => x_msg_data,
974: p_api_type => G_API_TYPE);
975:
976: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
977: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
978: p_api_name => l_api_name,
979: p_pkg_name => G_PKG_NAME,
980: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 977: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

973: x_msg_data => x_msg_data,
974: p_api_type => G_API_TYPE);
975:
976: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
977: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
978: p_api_name => l_api_name,
979: p_pkg_name => G_PKG_NAME,
980: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
981: p_msg_log => l_msg_log,

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

976: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
977: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
978: p_api_name => l_api_name,
979: p_pkg_name => G_PKG_NAME,
980: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
981: p_msg_log => l_msg_log,
982: x_msg_count => x_msg_count,
983: x_msg_data => x_msg_data,
984: p_api_type => G_API_TYPE);

Line 987: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

983: x_msg_data => x_msg_data,
984: p_api_type => G_API_TYPE);
985:
986: when OTHERS then
987: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
988: p_api_name => l_api_name,
989: p_pkg_name => G_PKG_NAME,
990: p_exc_name => 'OTHERS',
991: p_msg_log => l_msg_log||SQLERRM,

Line 1035: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1031: l_exists VARCHAR2(1) := NULL;
1032:
1033: BEGIN
1034:
1035: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1036:
1037: SELECT
1038: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST'),
1039: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')

Line 1071: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1067: FPA_VALIDATION_PVT.G_WARNING,
1068: p_project_id, 'PROJECT');
1069: end if;
1070:
1071: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1072:
1073: FPA_UTILITIES_PVT.END_ACTIVITY(
1074: p_api_name => l_api_name,
1075: p_pkg_name => G_PKG_NAME,

Line 1073: FPA_UTILITIES_PVT.END_ACTIVITY(

1069: end if;
1070:
1071: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1072:
1073: FPA_UTILITIES_PVT.END_ACTIVITY(
1074: p_api_name => l_api_name,
1075: p_pkg_name => G_PKG_NAME,
1076: p_msg_log => null,
1077: x_msg_count => x_msg_count,

Line 1082: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1078: x_msg_data => x_msg_data);
1079:
1080:
1081: EXCEPTION
1082: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1083: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1084: p_api_name => l_api_name,
1085: p_pkg_name => G_PKG_NAME,
1086: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1083: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1079:
1080:
1081: EXCEPTION
1082: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1083: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1084: p_api_name => l_api_name,
1085: p_pkg_name => G_PKG_NAME,
1086: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1087: p_msg_log => l_msg_log,

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

1082: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1083: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1084: p_api_name => l_api_name,
1085: p_pkg_name => G_PKG_NAME,
1086: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1087: p_msg_log => l_msg_log,
1088: x_msg_count => x_msg_count,
1089: x_msg_data => x_msg_data,
1090: p_api_type => G_API_TYPE);

Line 1092: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1088: x_msg_count => x_msg_count,
1089: x_msg_data => x_msg_data,
1090: p_api_type => G_API_TYPE);
1091:
1092: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1093: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1094: p_api_name => l_api_name,
1095: p_pkg_name => G_PKG_NAME,
1096: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1093: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1089: x_msg_data => x_msg_data,
1090: p_api_type => G_API_TYPE);
1091:
1092: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1093: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1094: p_api_name => l_api_name,
1095: p_pkg_name => G_PKG_NAME,
1096: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1097: p_msg_log => l_msg_log,

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

1092: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1093: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1094: p_api_name => l_api_name,
1095: p_pkg_name => G_PKG_NAME,
1096: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1097: p_msg_log => l_msg_log,
1098: x_msg_count => x_msg_count,
1099: x_msg_data => x_msg_data,
1100: p_api_type => G_API_TYPE);

Line 1103: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1099: x_msg_data => x_msg_data,
1100: p_api_type => G_API_TYPE);
1101:
1102: when OTHERS then
1103: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1104: p_api_name => l_api_name,
1105: p_pkg_name => G_PKG_NAME,
1106: p_exc_name => 'OTHERS',
1107: p_msg_log => l_msg_log||SQLERRM,

Line 1147: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1143: i NUMBER;
1144:
1145:
1146: BEGIN
1147: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1148:
1149: SELECT PLANNING_CYCLE INTO L_PC_ID
1150: FROM FPA_AW_SCES_V WHERE SCENARIO = P_SCENARIO_ID;
1151:

Line 1173: FPA_UTILITIES_PVT.END_ACTIVITY(

1169:
1170:
1171: END LOOP;
1172:
1173: FPA_UTILITIES_PVT.END_ACTIVITY(
1174: p_api_name => l_api_name,
1175: p_pkg_name => G_PKG_NAME,
1176: p_msg_log => null,
1177: x_msg_count => x_msg_count,

Line 1182: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1178: x_msg_data => x_msg_data);
1179:
1180:
1181: EXCEPTION
1182: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1183: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1184: p_api_name => l_api_name,
1185: p_pkg_name => G_PKG_NAME,
1186: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1183: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1179:
1180:
1181: EXCEPTION
1182: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1183: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1184: p_api_name => l_api_name,
1185: p_pkg_name => G_PKG_NAME,
1186: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1187: p_msg_log => l_msg_log,

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

1182: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1183: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1184: p_api_name => l_api_name,
1185: p_pkg_name => G_PKG_NAME,
1186: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1187: p_msg_log => l_msg_log,
1188: x_msg_count => x_msg_count,
1189: x_msg_data => x_msg_data,
1190: p_api_type => G_API_TYPE);

Line 1192: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1188: x_msg_count => x_msg_count,
1189: x_msg_data => x_msg_data,
1190: p_api_type => G_API_TYPE);
1191:
1192: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1193: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1194: p_api_name => l_api_name,
1195: p_pkg_name => G_PKG_NAME,
1196: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1193: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1189: x_msg_data => x_msg_data,
1190: p_api_type => G_API_TYPE);
1191:
1192: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1193: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1194: p_api_name => l_api_name,
1195: p_pkg_name => G_PKG_NAME,
1196: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1197: p_msg_log => l_msg_log,

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

1192: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1193: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1194: p_api_name => l_api_name,
1195: p_pkg_name => G_PKG_NAME,
1196: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1197: p_msg_log => l_msg_log,
1198: x_msg_count => x_msg_count,
1199: x_msg_data => x_msg_data,
1200: p_api_type => G_API_TYPE);

Line 1203: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1199: x_msg_data => x_msg_data,
1200: p_api_type => G_API_TYPE);
1201:
1202: when OTHERS then
1203: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1204: p_api_name => l_api_name,
1205: p_pkg_name => G_PKG_NAME,
1206: p_exc_name => 'OTHERS',
1207: p_msg_log => l_msg_log||SQLERRM,

Line 1236: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1232: ----------------------------------------------------------------------------
1233:
1234: BEGIN
1235:
1236: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1237:
1238: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1239: p_api_name => l_api_name,
1240: p_pkg_name => G_PKG_NAME,

Line 1238: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

1234: BEGIN
1235:
1236: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1237:
1238: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1239: p_api_name => l_api_name,
1240: p_pkg_name => G_PKG_NAME,
1241: p_init_msg_list => p_init_msg_list,
1242: l_api_version => l_api_version,

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

1244: p_api_type => G_API_TYPE,
1245: p_msg_log => 'Entering Fpa_Validation_Process_Pvt.Validate',
1246: x_return_status => x_return_status);
1247:
1248: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1249: l_msg_log := 'start_activity';
1250: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1251: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1252: l_msg_log := 'start_activity';

Line 1250: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1246: x_return_status => x_return_status);
1247:
1248: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1249: l_msg_log := 'start_activity';
1250: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1251: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1252: l_msg_log := 'start_activity';
1253: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1254: end if;

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

1247:
1248: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1249: l_msg_log := 'start_activity';
1250: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1251: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1252: l_msg_log := 'start_activity';
1253: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1254: end if;
1255:

Line 1253: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1249: l_msg_log := 'start_activity';
1250: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1251: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1252: l_msg_log := 'start_activity';
1253: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1254: end if;
1255:
1256: if(p_header_object_type = 'PLANNING_CYCLE') then
1257:

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

1277: x_msg_data => x_msg_data);
1278:
1279: end if;
1280:
1281: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1282: l_msg_log := 'Validate_Collect_Projects';
1283: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1284: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1285: l_msg_log := 'Validate_Collect_Projects';

Line 1283: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1279: end if;
1280:
1281: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1282: l_msg_log := 'Validate_Collect_Projects';
1283: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1284: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1285: l_msg_log := 'Validate_Collect_Projects';
1286: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1287: end if;

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

1280:
1281: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1282: l_msg_log := 'Validate_Collect_Projects';
1283: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1284: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1285: l_msg_log := 'Validate_Collect_Projects';
1286: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1287: end if;
1288:

Line 1286: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1282: l_msg_log := 'Validate_Collect_Projects';
1283: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1284: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1285: l_msg_log := 'Validate_Collect_Projects';
1286: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1287: end if;
1288:
1289: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1290:

Line 1289: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1285: l_msg_log := 'Validate_Collect_Projects';
1286: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1287: end if;
1288:
1289: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1290:
1291: FPA_UTILITIES_PVT.END_ACTIVITY(
1292: p_api_name => l_api_name,
1293: p_pkg_name => G_PKG_NAME,

Line 1291: FPA_UTILITIES_PVT.END_ACTIVITY(

1287: end if;
1288:
1289: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1290:
1291: FPA_UTILITIES_PVT.END_ACTIVITY(
1292: p_api_name => l_api_name,
1293: p_pkg_name => G_PKG_NAME,
1294: p_msg_log => null,
1295: x_msg_count => x_msg_count,

Line 1300: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1296: x_msg_data => x_msg_data);
1297:
1298:
1299: EXCEPTION
1300: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1301: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1302: p_api_name => l_api_name,
1303: p_pkg_name => G_PKG_NAME,
1304: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1301: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1297:
1298:
1299: EXCEPTION
1300: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1301: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1302: p_api_name => l_api_name,
1303: p_pkg_name => G_PKG_NAME,
1304: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1305: p_msg_log => l_msg_log,

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

1300: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1301: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1302: p_api_name => l_api_name,
1303: p_pkg_name => G_PKG_NAME,
1304: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1305: p_msg_log => l_msg_log,
1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: p_api_type => G_API_TYPE);

Line 1310: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: p_api_type => G_API_TYPE);
1309:
1310: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1311: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1312: p_api_name => l_api_name,
1313: p_pkg_name => G_PKG_NAME,
1314: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1311: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1307: x_msg_data => x_msg_data,
1308: p_api_type => G_API_TYPE);
1309:
1310: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1311: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1312: p_api_name => l_api_name,
1313: p_pkg_name => G_PKG_NAME,
1314: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1315: p_msg_log => l_msg_log,

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

1310: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1311: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1312: p_api_name => l_api_name,
1313: p_pkg_name => G_PKG_NAME,
1314: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1315: p_msg_log => l_msg_log,
1316: x_msg_count => x_msg_count,
1317: x_msg_data => x_msg_data,
1318: p_api_type => G_API_TYPE);

Line 1321: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1317: x_msg_data => x_msg_data,
1318: p_api_type => G_API_TYPE);
1319:
1320: when OTHERS then
1321: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1322: p_api_name => l_api_name,
1323: p_pkg_name => G_PKG_NAME,
1324: p_exc_name => 'OTHERS',
1325: p_msg_log => l_msg_log||SQLERRM,