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

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

1: package body FPA_PROJECT_PVT as
2: /* $Header: FPAVPRJB.pls 120.18 2011/08/09 01:14:49 skkoppul ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_PROJECT_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) := 'PROJECT';
8:
9: G_SELECTION_CATEGORY VARCHAR2(200) := FND_PROFILE.VALUE('PJP_PORTFOLIO_CLASS_CATEGORY');

Line 124: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

120: l_flag VARCHAR2(1) := null;
121:
122: BEGIN
123: x_valid_project := FND_API.G_FALSE;
124: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
125:
126: l_flag := FND_API.G_FALSE;
127: open funding_status_csr(p_project_id);
128: fetch funding_status_csr into l_flag;

Line 133: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

129: close funding_status_csr;
130:
131: if(l_flag is null or l_flag <> FND_API.G_TRUE) then
132: x_valid_project := FND_API.G_FALSE;
133: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
134: FPA_UTILITIES_PVT.END_ACTIVITY(
135: p_api_name => l_api_name,
136: p_pkg_name => G_PKG_NAME,
137: p_msg_log => null,

Line 134: FPA_UTILITIES_PVT.END_ACTIVITY(

130:
131: if(l_flag is null or l_flag <> FND_API.G_TRUE) then
132: x_valid_project := FND_API.G_FALSE;
133: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
134: FPA_UTILITIES_PVT.END_ACTIVITY(
135: p_api_name => l_api_name,
136: p_pkg_name => G_PKG_NAME,
137: p_msg_log => null,
138: x_msg_count => x_msg_count,

Line 155: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

151: -- get org version id for the PJP hierarchy org
152:
153: if(G_PJP_ORGS_HIER is null) then
154: x_valid_project := FND_API.G_FALSE;
155: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
156: FPA_UTILITIES_PVT.END_ACTIVITY(
157: p_api_name => l_api_name,
158: p_pkg_name => G_PKG_NAME,
159: p_msg_log => 'returning: PJP Hierarchy Org not set ',

Line 156: FPA_UTILITIES_PVT.END_ACTIVITY(

152:
153: if(G_PJP_ORGS_HIER is null) then
154: x_valid_project := FND_API.G_FALSE;
155: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
156: FPA_UTILITIES_PVT.END_ACTIVITY(
157: p_api_name => l_api_name,
158: p_pkg_name => G_PKG_NAME,
159: p_msg_log => 'returning: PJP Hierarchy Org not set ',
160: x_msg_count => x_msg_count,

Line 182: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

178: close portfolio_proj_csr;
179:
180: if(l_portfolio_id is null) then
181: x_valid_project := FND_API.G_FALSE;
182: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
183: FPA_UTILITIES_PVT.END_ACTIVITY(
184: p_api_name => l_api_name,
185: p_pkg_name => G_PKG_NAME,
186: p_msg_log => 'returning: no portfolio or class code for '||p_project_id,

Line 183: FPA_UTILITIES_PVT.END_ACTIVITY(

179:
180: if(l_portfolio_id is null) then
181: x_valid_project := FND_API.G_FALSE;
182: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
183: FPA_UTILITIES_PVT.END_ACTIVITY(
184: p_api_name => l_api_name,
185: p_pkg_name => G_PKG_NAME,
186: p_msg_log => 'returning: no portfolio or class code for '||p_project_id,
187: x_msg_count => x_msg_count,

Line 203: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

199: close portfolio_pc_csr;
200:
201: if(l_current_pc_id is null) then
202: x_valid_project := FND_API.G_FALSE;
203: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
204: FPA_UTILITIES_PVT.END_ACTIVITY(
205: p_api_name => l_api_name,
206: p_pkg_name => G_PKG_NAME,
207: p_msg_log => 'returning: no planning cycle or pc category for '||l_portfolio_id,

Line 204: FPA_UTILITIES_PVT.END_ACTIVITY(

200:
201: if(l_current_pc_id is null) then
202: x_valid_project := FND_API.G_FALSE;
203: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
204: FPA_UTILITIES_PVT.END_ACTIVITY(
205: p_api_name => l_api_name,
206: p_pkg_name => G_PKG_NAME,
207: p_msg_log => 'returning: no planning cycle or pc category for '||l_portfolio_id,
208: x_msg_count => x_msg_count,

Line 224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

220: x_proj_portfolio := l_portfolio_id;
221: x_proj_pc := l_current_pc_id;
222: x_class_code_id := l_class_code_id;
223: x_valid_project := FND_API.G_TRUE;
224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
225:
226: FPA_UTILITIES_PVT.END_ACTIVITY(
227: p_api_name => l_api_name,
228: p_pkg_name => G_PKG_NAME,

Line 226: FPA_UTILITIES_PVT.END_ACTIVITY(

222: x_class_code_id := l_class_code_id;
223: x_valid_project := FND_API.G_TRUE;
224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
225:
226: FPA_UTILITIES_PVT.END_ACTIVITY(
227: p_api_name => l_api_name,
228: p_pkg_name => G_PKG_NAME,
229: p_msg_log => 'FPA: returning valid project',
230: x_msg_count => x_msg_count,

Line 235: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

231: x_msg_data => x_msg_data);
232:
233:
234: EXCEPTION
235: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
236: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 236: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

232:
233:
234: EXCEPTION
235: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
236: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
240: p_msg_log => l_msg_log,

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

235: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
236: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
240: p_msg_log => l_msg_log,
241: x_msg_count => x_msg_count,
242: x_msg_data => x_msg_data,
243: p_api_type => G_API_TYPE);

Line 245: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

241: x_msg_count => x_msg_count,
242: x_msg_data => x_msg_data,
243: p_api_type => G_API_TYPE);
244:
245: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
246: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
247: p_api_name => l_api_name,
248: p_pkg_name => G_PKG_NAME,
249: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 246: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

242: x_msg_data => x_msg_data,
243: p_api_type => G_API_TYPE);
244:
245: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
246: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
247: p_api_name => l_api_name,
248: p_pkg_name => G_PKG_NAME,
249: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
250: p_msg_log => l_msg_log,

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

245: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
246: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
247: p_api_name => l_api_name,
248: p_pkg_name => G_PKG_NAME,
249: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
250: p_msg_log => l_msg_log,
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data,
253: p_api_type => G_API_TYPE);

Line 256: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

252: x_msg_data => x_msg_data,
253: p_api_type => G_API_TYPE);
254:
255: when OTHERS then
256: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
257: p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => 'OTHERS',
260: p_msg_log => l_msg_log||SQLERRM,

Line 284: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

280: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
281:
282: BEGIN
283:
284: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
285:
286: Get_Project_Details(
287: p_project_id => p_project_id,
288: x_proj_portfolio => l_portfolio_id,

Line 573: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

569:
570:
571: BEGIN
572:
573: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
574: -- call START_ACTIVITY to create savepoint, check compatibility
575: -- and initialize message list
576: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
577: p_api_name => l_api_name,

Line 576: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

572:
573: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
574: -- call START_ACTIVITY to create savepoint, check compatibility
575: -- and initialize message list
576: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
577: p_api_name => l_api_name,
578: p_pkg_name => G_PKG_NAME,
579: p_init_msg_list => p_init_msg_list,
580: l_api_version => l_api_version,

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

583: p_msg_log => 'Entering Fpa_Project_Load_Pvt.Submit_project_Aw',
584: x_return_status => x_return_status);
585:
586: -- check if activity started successfully
587: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
588: l_msg_log := 'start_activity';
589: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
590: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
591: l_msg_log := 'start_activity';

Line 589: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

585:
586: -- check if activity started successfully
587: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
588: l_msg_log := 'start_activity';
589: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
590: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
591: l_msg_log := 'start_activity';
592: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
593: end if;

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

586: -- check if activity started successfully
587: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
588: l_msg_log := 'start_activity';
589: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
590: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
591: l_msg_log := 'start_activity';
592: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
593: end if;
594:

Line 592: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

588: l_msg_log := 'start_activity';
589: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
590: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
591: l_msg_log := 'start_activity';
592: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
593: end if;
594:
595: Get_Project_Details(
596: p_project_id => p_project_id,

Line 607: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

603: x_msg_data => x_msg_data);
604:
605:
606: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) then
607: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
608: FPA_UTILITIES_PVT.END_ACTIVITY(
609: p_api_name => l_api_name,
610: p_pkg_name => G_PKG_NAME,
611: p_msg_log => 'returning: project not saved '||p_project_id,

Line 608: FPA_UTILITIES_PVT.END_ACTIVITY(

604:
605:
606: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) then
607: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
608: FPA_UTILITIES_PVT.END_ACTIVITY(
609: p_api_name => l_api_name,
610: p_pkg_name => G_PKG_NAME,
611: p_msg_log => 'returning: project not saved '||p_project_id,
612: x_msg_count => x_msg_count,

Line 619: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

615: end if;
616:
617: save_project;
618:
619: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
620:
621: FPA_UTILITIES_PVT.END_ACTIVITY(
622: p_api_name => l_api_name,
623: p_pkg_name => G_PKG_NAME,

Line 621: FPA_UTILITIES_PVT.END_ACTIVITY(

617: save_project;
618:
619: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
620:
621: FPA_UTILITIES_PVT.END_ACTIVITY(
622: p_api_name => l_api_name,
623: p_pkg_name => G_PKG_NAME,
624: p_msg_log => null,
625: x_msg_count => x_msg_count,

Line 630: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

626: x_msg_data => x_msg_data);
627:
628:
629: EXCEPTION
630: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
631: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
632: p_api_name => l_api_name,
633: p_pkg_name => G_PKG_NAME,
634: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 631: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

627:
628:
629: EXCEPTION
630: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
631: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
632: p_api_name => l_api_name,
633: p_pkg_name => G_PKG_NAME,
634: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
635: p_msg_log => l_msg_log,

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

630: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
631: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
632: p_api_name => l_api_name,
633: p_pkg_name => G_PKG_NAME,
634: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
635: p_msg_log => l_msg_log,
636: x_msg_count => x_msg_count,
637: x_msg_data => x_msg_data,
638: p_api_type => G_API_TYPE);

Line 640: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

636: x_msg_count => x_msg_count,
637: x_msg_data => x_msg_data,
638: p_api_type => G_API_TYPE);
639:
640: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
641: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
642: p_api_name => l_api_name,
643: p_pkg_name => G_PKG_NAME,
644: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 641: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

637: x_msg_data => x_msg_data,
638: p_api_type => G_API_TYPE);
639:
640: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
641: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
642: p_api_name => l_api_name,
643: p_pkg_name => G_PKG_NAME,
644: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
645: p_msg_log => l_msg_log,

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

640: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
641: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
642: p_api_name => l_api_name,
643: p_pkg_name => G_PKG_NAME,
644: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
645: p_msg_log => l_msg_log,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,
648: p_api_type => G_API_TYPE);

Line 651: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

647: x_msg_data => x_msg_data,
648: p_api_type => G_API_TYPE);
649:
650: when OTHERS 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 => 'OTHERS',
655: p_msg_log => l_msg_log||SQLERRM,

Line 687: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

683: l_pc_id NUMBER;
684:
685: BEGIN
686:
687: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
688: -- call START_ACTIVITY to create savepoint, check compatibility
689: -- and initialize message list
690: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
691: p_api_name => l_api_name,

Line 690: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

686:
687: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
688: -- call START_ACTIVITY to create savepoint, check compatibility
689: -- and initialize message list
690: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
691: p_api_name => l_api_name,
692: p_pkg_name => G_PKG_NAME,
693: p_init_msg_list => p_init_msg_list,
694: l_api_version => l_api_version,

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

697: p_msg_log => 'Entering Fpa_Project_Load_Pvt.Load_Project_Details_Aw',
698: x_return_status => x_return_status);
699:
700: -- check if activity started successfully
701: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
702: l_msg_log := 'start_activity';
703: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
704: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
705: l_msg_log := 'start_activity';

Line 703: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

699:
700: -- check if activity started successfully
701: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
702: l_msg_log := 'start_activity';
703: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
704: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
705: l_msg_log := 'start_activity';
706: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
707: end if;

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

700: -- check if activity started successfully
701: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
702: l_msg_log := 'start_activity';
703: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
704: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
705: l_msg_log := 'start_activity';
706: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
707: end if;
708:

Line 706: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

702: l_msg_log := 'start_activity';
703: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
704: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
705: l_msg_log := 'start_activity';
706: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
707: end if;
708:
709:
710: l_projects := p_projects;

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

742: x_msg_count => x_msg_count,
743: x_msg_data => x_msg_data);
744: end if;
745:
746: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
747: l_msg_log := 'unexpected error - load_project_details_aw';
748: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
749: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
750: l_msg_log := 'error - load_project_details_aw';

Line 748: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

744: end if;
745:
746: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
747: l_msg_log := 'unexpected error - load_project_details_aw';
748: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
749: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
750: l_msg_log := 'error - load_project_details_aw';
751: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
752: end if;

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

745:
746: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
747: l_msg_log := 'unexpected error - load_project_details_aw';
748: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
749: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
750: l_msg_log := 'error - load_project_details_aw';
751: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
752: end if;
753:

Line 751: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

747: l_msg_log := 'unexpected error - load_project_details_aw';
748: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
749: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
750: l_msg_log := 'error - load_project_details_aw';
751: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
752: end if;
753:
754:
755: IF (p_projects is null) THEN

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

787: 'Ending FPA_PROCESS_PVT.Validate.end'
788: );
789: END IF;
790:
791: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
792: l_msg_log := 'unexpected error - load_project_details_aw.Validate';
793: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
794: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
795: l_msg_log := 'error - load_project_details_aw.Validate';

Line 793: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

789: END IF;
790:
791: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
792: l_msg_log := 'unexpected error - load_project_details_aw.Validate';
793: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
794: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
795: l_msg_log := 'error - load_project_details_aw.Validate';
796: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
797: end if;

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

790:
791: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
792: l_msg_log := 'unexpected error - load_project_details_aw.Validate';
793: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
794: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
795: l_msg_log := 'error - load_project_details_aw.Validate';
796: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
797: end if;
798:

Line 796: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

792: l_msg_log := 'unexpected error - load_project_details_aw.Validate';
793: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
794: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
795: l_msg_log := 'error - load_project_details_aw.Validate';
796: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
797: end if;
798:
799: Fpa_Validation_Process_Pvt.Budget_Version_Validations(
800: p_api_version => 1.0,

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

814: 'End Fpa_Validation_Process_Pvt.Validate_Budget_Versions.end'
815: );
816: END IF;
817:
818: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
819: l_msg_log := 'unexpected error - load_project_details_aw.Validate_Budget_Versions';
820: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
821: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
822: l_msg_log := 'error - load_project_details_aw.Validate_Budget_Versions';

Line 820: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

816: END IF;
817:
818: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
819: l_msg_log := 'unexpected error - load_project_details_aw.Validate_Budget_Versions';
820: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
821: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
822: l_msg_log := 'error - load_project_details_aw.Validate_Budget_Versions';
823: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
824: end if;

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

817:
818: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
819: l_msg_log := 'unexpected error - load_project_details_aw.Validate_Budget_Versions';
820: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
821: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
822: l_msg_log := 'error - load_project_details_aw.Validate_Budget_Versions';
823: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
824: end if;
825:

Line 823: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

819: l_msg_log := 'unexpected error - load_project_details_aw.Validate_Budget_Versions';
820: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
821: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
822: l_msg_log := 'error - load_project_details_aw.Validate_Budget_Versions';
823: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
824: end if;
825:
826: END IF;
827:

Line 828: FPA_UTILITIES_PVT.END_ACTIVITY(

824: end if;
825:
826: END IF;
827:
828: FPA_UTILITIES_PVT.END_ACTIVITY(
829: p_api_name => l_api_name,
830: p_pkg_name => G_PKG_NAME,
831: p_msg_log => null,
832: x_msg_count => x_msg_count,

Line 836: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

832: x_msg_count => x_msg_count,
833: x_msg_data => x_msg_data);
834:
835: EXCEPTION
836: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
837: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
838: p_api_name => l_api_name,
839: p_pkg_name => G_PKG_NAME,
840: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 837: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

833: x_msg_data => x_msg_data);
834:
835: EXCEPTION
836: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
837: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
838: p_api_name => l_api_name,
839: p_pkg_name => G_PKG_NAME,
840: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
841: p_msg_log => l_msg_log,

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

836: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
837: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
838: p_api_name => l_api_name,
839: p_pkg_name => G_PKG_NAME,
840: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
841: p_msg_log => l_msg_log,
842: x_msg_count => x_msg_count,
843: x_msg_data => x_msg_data,
844: p_api_type => G_API_TYPE);

Line 846: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

842: x_msg_count => x_msg_count,
843: x_msg_data => x_msg_data,
844: p_api_type => G_API_TYPE);
845:
846: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
847: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
848: p_api_name => l_api_name,
849: p_pkg_name => G_PKG_NAME,
850: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 847: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

843: x_msg_data => x_msg_data,
844: p_api_type => G_API_TYPE);
845:
846: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
847: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
848: p_api_name => l_api_name,
849: p_pkg_name => G_PKG_NAME,
850: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
851: p_msg_log => l_msg_log,

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

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

Line 857: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

853: x_msg_data => x_msg_data,
854: p_api_type => G_API_TYPE);
855:
856: when OTHERS then
857: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
858: p_api_name => l_api_name,
859: p_pkg_name => G_PKG_NAME,
860: p_exc_name => 'OTHERS',
861: p_msg_log => l_msg_log||SQLERRM,

Line 1061: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',

1057: CLOSE c_approved_projects;
1058:
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',
1062: p_msg_name => 'PA_XC_RECORD_CHANGED');
1063: x_msg_data := 'PA_XC_RECORD_CHANGED';
1064:
1065: WHEN TIMEOUT_ON_RESOURCE THEN

Line 1066: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',

1062: p_msg_name => 'PA_XC_RECORD_CHANGED');
1063: x_msg_data := 'PA_XC_RECORD_CHANGED';
1064:
1065: WHEN TIMEOUT_ON_RESOURCE THEN
1066: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',
1067: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1068: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1069: x_return_status := 'E' ;
1070:

Line 1073: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',

1069: x_return_status := 'E' ;
1070:
1071: WHEN OTHERS THEN
1072: IF SQLCODE = -54 THEN
1073: FPA_UTILITIES_PVT.SET_MESSAGE( p_app_name => 'PA',
1074: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1075: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1076: END IF;
1077: