DBA Data[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_API

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

98: 'fpa.sql.fpa_main_process_pvt.get_wf_attributes.end',
99: SQLERRM);
100: END IF;
101: wf_core.context('FPA_MAIN_PROCESS_PVT', 'GET_WF_ATTRIBUTES', null);
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
104: p_data => x_msg_data);
105: RAISE;
106: END GET_WF_ATTRIBUTES;

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.end',
271: SQLERRM);
272: END IF;
273: wf_core.context('FPA_MAIN_PROCESS_PVT', 'INITIATE_WORKFLOW', null);
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
276: p_data => x_msg_data
277: );
278: RAISE;

Line 406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

402: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.end',
403: SQLERRM);
404: END IF;
405: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CANCEL_WORKFLOW', null);
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
408: p_data => x_msg_data
409: );
410: RAISE;

Line 758: l_flag := FND_API.G_TRUE;

754: FETCH c_get_port_users INTO l_user, l_user_org_id;
755: EXIT WHEN c_get_port_users%NOTFOUND;
756:
757: if(l_portfolio_org_id is not null and l_portfolio_org_id = l_user_org_id) then
758: l_flag := FND_API.G_TRUE;
759: elsif(l_portfolio_org_id is not null) then
760: l_flag := null;
761: open verify_user_org_csr(l_pjp_org_version_id,
762: l_portfolio_org_id,

Line 767: l_flag := FND_API.G_TRUE;

763: l_user_org_id);
764: fetch verify_user_org_csr into l_flag;
765: close verify_user_org_csr;
766: else
767: l_flag := FND_API.G_TRUE;
768: end if;
769:
770: if(l_flag = FND_API.G_TRUE) then
771: -- Add users to the role.

Line 770: if(l_flag = FND_API.G_TRUE) then

766: else
767: l_flag := FND_API.G_TRUE;
768: end if;
769:
770: if(l_flag = FND_API.G_TRUE) then
771: -- Add users to the role.
772: wf_directory.AddUsersToAdHocRole(role_name => p_notify_role,
773: role_users => l_user);
774: IF l_user_exists ='N' then

Line 798: l_flag := FND_API.G_TRUE;

794: FETCH c_get_dlist_users INTO l_user, l_user_org_id;
795: EXIT WHEN c_get_dlist_users%NOTFOUND;
796:
797: if(l_portfolio_org_id is not null and l_portfolio_org_id = l_user_org_id) then
798: l_flag := FND_API.G_TRUE;
799: elsif(l_portfolio_org_id is not null) then
800: l_flag := null;
801: open verify_user_org_csr(l_pjp_org_version_id,
802: l_portfolio_org_id,

Line 807: l_flag := FND_API.G_TRUE;

803: l_user_org_id);
804: fetch verify_user_org_csr into l_flag;
805: close verify_user_org_csr;
806: else
807: l_flag := FND_API.G_TRUE;
808: end if;
809: if(l_flag = FND_API.G_TRUE) then
810: -- Add users to the role.
811: wf_directory.AddUsersToAdHocRole(role_name => p_notify_role,

Line 809: if(l_flag = FND_API.G_TRUE) then

805: close verify_user_org_csr;
806: else
807: l_flag := FND_API.G_TRUE;
808: end if;
809: if(l_flag = FND_API.G_TRUE) then
810: -- Add users to the role.
811: wf_directory.AddUsersToAdHocRole(role_name => p_notify_role,
812: role_users => l_user);
813: IF l_user_exists ='N' then

Line 1459: p_init_msg_list => FND_API.G_FALSE,

1455: END IF;
1456:
1457: Fpa_Project_Pvt.Load_Project_Details_Aw(
1458: p_api_version => 1.0,
1459: p_init_msg_list => FND_API.G_FALSE,
1460: p_type => 'COLLECT',
1461: p_scenario_id => l_scenario_id,
1462: p_projects => null,
1463: x_return_status => l_return_status,

Line 1495: p_init_msg_list => FND_API.G_FALSE,

1491:
1492: fpa_scorecards_pvt.Calc_Scenario_Wscores_Aw
1493: (
1494: p_api_version => 1.0,
1495: p_init_msg_list => FND_API.G_FALSE,
1496: p_scenario_id => l_scenario_id,
1497: x_return_status => l_return_status,
1498: x_msg_count => l_msg_count,
1499: x_msg_data => l_msg_data

Line 2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2028: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2029: SQLERRM);
2030: END IF;
2031: wf_core.context('FPA_MAIN_PROCESS_PVT', 'FORCE_USER_ACTION', SQLERRM);
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2034: p_data => x_msg_data
2035: );
2036: RAISE;

Line 2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2099: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2100: SQLERRM);
2101: END IF;
2102: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SUBMIT_PLAN', SQLERRM);
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );
2107: RAISE;

Line 2200: p_init_msg_list => FND_API.G_FALSE,

2196: END IF;
2197:
2198: FPA_SCORECARDS_PVT.Update_Scenario_App_Scores
2199: (p_api_version => 1.0,
2200: p_init_msg_list => FND_API.G_FALSE,
2201: p_scenario_id => l_sce_id,
2202: x_return_status => l_return_status,
2203: x_msg_count => l_msg_count,
2204: x_msg_data => l_msg_data

Line 2218: p_init_msg_list => FND_API.G_FALSE,

2214:
2215: FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS
2216: (
2217: p_api_version => 1.0,
2218: p_init_msg_list => FND_API.G_FALSE,
2219: p_commit => FND_API.G_FALSE,
2220: p_appr_scenario_id => l_sce_id,
2221: x_return_status => l_return_status,
2222: x_msg_count => l_msg_count,

Line 2219: p_commit => FND_API.G_FALSE,

2215: FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS
2216: (
2217: p_api_version => 1.0,
2218: p_init_msg_list => FND_API.G_FALSE,
2219: p_commit => FND_API.G_FALSE,
2220: p_appr_scenario_id => l_sce_id,
2221: x_return_status => l_return_status,
2222: x_msg_count => l_msg_count,
2223: x_msg_data => l_msg_data);

Line 2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2327: x_msg_data => x_msg_data
2328: );
2329:
2330: wf_core.context('FPA_MAIN_PROCESS_PVT', 'APPROVE_REJECT_PLAN', SQLERRM);
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2333: p_data => x_msg_data
2334: );
2335: RAISE;

Line 2406: p_init_msg_list => FND_API.G_FALSE,

2402: END IF;
2403:
2404: FPA_PROJECT_PVT.Submit_Project_Aw(
2405: p_api_version => 1.0,
2406: p_init_msg_list => FND_API.G_FALSE,
2407: p_commit => FND_API.G_FALSE,
2408: p_project_id => l_project_id_tbl(i),
2409: x_return_status => l_return_status,
2410: x_msg_count => l_msg_count,

Line 2407: p_commit => FND_API.G_FALSE,

2403:
2404: FPA_PROJECT_PVT.Submit_Project_Aw(
2405: p_api_version => 1.0,
2406: p_init_msg_list => FND_API.G_FALSE,
2407: p_commit => FND_API.G_FALSE,
2408: p_project_id => l_project_id_tbl(i),
2409: x_return_status => l_return_status,
2410: x_msg_count => l_msg_count,
2411: x_msg_data => l_msg_data);