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 FND_API

Line 123: x_valid_project := FND_API.G_FALSE;

119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;
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);

Line 126: l_flag := FND_API.G_FALSE;

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;
129: close funding_status_csr;
130:

Line 131: if(l_flag is null or l_flag <> FND_API.G_TRUE) then

127: open funding_status_csr(p_project_id);
128: fetch funding_status_csr into l_flag;
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,

Line 132: x_valid_project := FND_API.G_FALSE;

128: fetch funding_status_csr into l_flag;
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,

Line 154: x_valid_project := FND_API.G_FALSE;

150:
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,

Line 181: x_valid_project := FND_API.G_FALSE;

177: l_portfolio_org_id, l_project_org_id;
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,

Line 202: x_valid_project := FND_API.G_FALSE;

198: fetch portfolio_pc_csr into l_current_pc_id, l_class_code_id;
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,

Line 223: x_valid_project := FND_API.G_TRUE;

219:
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,

Line 280: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;

276:
277: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
278: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
279: l_class_code_id NUMBER;
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;

Line 296: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) 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_valid_project is null or l_valid_project <> FND_API.G_TRUE) then
297: return FND_API.G_FALSE;
298: else
299: return FND_API.G_TRUE;
300: end if;

Line 297: return FND_API.G_FALSE;

293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data);
295:
296: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) then
297: return FND_API.G_FALSE;
298: else
299: return FND_API.G_TRUE;
300: end if;
301:

Line 299: return FND_API.G_TRUE;

295:
296: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) then
297: return FND_API.G_FALSE;
298: else
299: return FND_API.G_TRUE;
300: end if;
301:
302: EXCEPTION
303: when OTHERS then

Line 304: return FND_API.G_FALSE;

300: end if;
301:
302: EXCEPTION
303: when OTHERS then
304: return FND_API.G_FALSE;
305: END Valid_Project;
306:
307: /** Verify_Budget_Versions is used to determine if projects under a given scenario have
308: the latest revenue and cost budget data .

Line 478: return FND_API.G_FALSE;

474: an individual project or for the entire scenario.
475: **/
476: if(l_cost_version_id <> l_new_cost_version_id or
477: l_benefit_version_id <> l_new_benefit_version_id) then
478: return FND_API.G_FALSE;
479: else
480: /** If IDs are identical and querying a single project then we return
481: a TRUE flag.
482: **/

Line 484: return FND_API.G_TRUE;

480: /** If IDs are identical and querying a single project then we return
481: a TRUE flag.
482: **/
483: if p_project_id is not null then
484: return FND_API.G_TRUE;
485: /** If IDs are identical and we have verified all projects under the scenario
486: contain the latest data, then we return a TRUE fla
487: **/
488: else

Line 497: return FND_API.G_TRUE;

493: ' and the last project is: ' || new_projs(new_projs.last).project_id);
494: END IF;
495:
496: if new_projs(i).project_id = new_projs(new_projs.last).project_id then
497: return FND_API.G_TRUE;
498: end if;
499: end if;
500: end if;
501:

Line 506: return FND_API.G_FALSE;

502: end loop;
503:
504: EXCEPTION
505: when OTHERS then
506: return FND_API.G_FALSE;
507: END Verify_Budget_Versions;
508:
509:
510: PROCEDURE Submit_Project_Aw

Line 513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

509:
510: PROCEDURE Submit_Project_Aw
511: (
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_project_id IN NUMBER,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,

Line 514: p_commit IN VARCHAR2 := FND_API.G_FALSE,

510: PROCEDURE Submit_Project_Aw
511: (
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_project_id IN NUMBER,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2

Line 531: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;

527:
528: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
529: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
530: l_class_code_id NUMBER;
531: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
532:
533: PROCEDURE save_project
534: IS
535: BEGIN

Line 606: if(l_valid_project is null or l_valid_project <> FND_API.G_TRUE) then

602: x_msg_count => x_msg_count,
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,

Line 666: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

662:
663: PROCEDURE Load_Project_Details_Aw
664: (
665: p_api_version IN NUMBER,
666: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
667: p_type IN VARCHAR2,
668: p_scenario_id IN NUMBER,
669: p_projects IN VARCHAR2,
670: x_return_status OUT NOCOPY VARCHAR2,

Line 1085: RAISE FND_API.G_EXC_ERROR;

1081: l_msg_count := FND_MSG_PUB.count_msg;
1082: IF l_msg_count > 0 THEN
1083: x_msg_count := l_msg_count;
1084: x_return_status := 'E';
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:
1088: IF p_commit = FND_API.G_TRUE then
1089: COMMIT;

Line 1088: IF p_commit = FND_API.G_TRUE then

1084: x_return_status := 'E';
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:
1088: IF p_commit = FND_API.G_TRUE then
1089: COMMIT;
1090: END IF;
1091:
1092: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1100:
1101:
1102: EXCEPTION
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105:
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROJECT_PVT',
1108: p_procedure_name => 'UPDATE_PROJ_FUNDING_STATUS',

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102: EXCEPTION
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105:
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROJECT_PVT',
1108: p_procedure_name => 'UPDATE_PROJ_FUNDING_STATUS',
1109: p_error_text => SUBSTRB(SQLERRM,1,240));
1110:

Line 1114: IF p_commit = FND_API.G_TRUE THEN

1110:
1111: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1112: p_data => x_msg_data);
1113:
1114: IF p_commit = FND_API.G_TRUE THEN
1115: ROLLBACK;
1116: END IF;
1117:
1118: raise;

Line 1120: WHEN FND_API.G_EXC_ERROR THEN

1116: END IF;
1117:
1118: raise;
1119:
1120: WHEN FND_API.G_EXC_ERROR THEN
1121: IF p_commit = FND_API.G_TRUE THEN
1122: ROLLBACK;
1123: END IF;
1124: x_return_status := 'E';

Line 1121: IF p_commit = FND_API.G_TRUE THEN

1117:
1118: raise;
1119:
1120: WHEN FND_API.G_EXC_ERROR THEN
1121: IF p_commit = FND_API.G_TRUE THEN
1122: ROLLBACK;
1123: END IF;
1124: x_return_status := 'E';
1125:

Line 1127: IF p_commit = FND_API.G_TRUE THEN

1123: END IF;
1124: x_return_status := 'E';
1125:
1126: WHEN OTHERS THEN
1127: IF p_commit = FND_API.G_TRUE THEN
1128: ROLLBACK;
1129: END IF;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROJECT_PVT',

Line 1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1126: WHEN OTHERS THEN
1127: IF p_commit = FND_API.G_TRUE THEN
1128: ROLLBACK;
1129: END IF;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROJECT_PVT',
1132: p_procedure_name => 'UPDATE_PROJ_FUNDING_STATUS',
1133: p_error_text => SUBSTRB(SQLERRM,1,240));
1134: