DBA Data[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_API

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 768: -- l_flag := FND_API.G_TRUE;

764: FETCH c_get_port_users INTO l_user, l_user_org_id;
765: EXIT WHEN c_get_port_users%NOTFOUND;
766: -- Bug#13514467 modifications start.
767: -- if(l_portfolio_org_id is not null and l_portfolio_org_id = l_user_org_id) then
768: -- l_flag := FND_API.G_TRUE;
769: -- elsif(l_portfolio_org_id is not null) then
770: -- l_flag := null;
771: -- open verify_user_org_csr(l_pjp_org_version_id,
772: -- l_portfolio_org_id,

Line 777: -- l_flag := FND_API.G_TRUE;

773: -- l_user_org_id);
774: -- fetch verify_user_org_csr into l_flag;
775: -- close verify_user_org_csr;
776: -- else
777: -- l_flag := FND_API.G_TRUE;
778: -- end if;
779:
780: -- if(l_flag = FND_API.G_TRUE) then
781: -- Add users to the role.

Line 780: -- if(l_flag = FND_API.G_TRUE) then

776: -- else
777: -- l_flag := FND_API.G_TRUE;
778: -- end if;
779:
780: -- if(l_flag = FND_API.G_TRUE) then
781: -- Add users to the role.
782: if wf_directory.IsPerformer (l_user, p_notify_role)= false then -- Bug#14558240
783: wf_directory.AddUsersToAdHocRole(role_name => p_notify_role,
784: role_users => l_user);

Line 811: -- l_flag := FND_API.G_TRUE;

807: FETCH c_get_dlist_users INTO l_user, l_user_org_id;
808: EXIT WHEN c_get_dlist_users%NOTFOUND;
809: -- Bug#13514467 modifications start.
810: -- if(l_portfolio_org_id is not null and l_portfolio_org_id = l_user_org_id) then
811: -- l_flag := FND_API.G_TRUE;
812: -- elsif(l_portfolio_org_id is not null) then
813: -- l_flag := null;
814: -- open verify_user_org_csr(l_pjp_org_version_id,
815: -- l_portfolio_org_id,

Line 820: -- l_flag := FND_API.G_TRUE;

816: -- l_user_org_id);
817: -- fetch verify_user_org_csr into l_flag;
818: -- close verify_user_org_csr;
819: -- else
820: -- l_flag := FND_API.G_TRUE;
821: -- end if;
822: -- if(l_flag = FND_API.G_TRUE) then
823: -- Add users to the role.
824: if wf_directory.IsPerformer (l_user, p_notify_role)= false then -- Bug#14558240

Line 822: -- if(l_flag = FND_API.G_TRUE) then

818: -- close verify_user_org_csr;
819: -- else
820: -- l_flag := FND_API.G_TRUE;
821: -- end if;
822: -- if(l_flag = FND_API.G_TRUE) then
823: -- Add users to the role.
824: if wf_directory.IsPerformer (l_user, p_notify_role)= false then -- Bug#14558240
825: wf_directory.AddUsersToAdHocRole(role_name => p_notify_role,
826: role_users => l_user);

Line 1480: p_init_msg_list => FND_API.G_FALSE,

1476: END IF;
1477:
1478: Fpa_Project_Pvt.Load_Project_Details_Aw(
1479: p_api_version => 1.0,
1480: p_init_msg_list => FND_API.G_FALSE,
1481: p_type => 'COLLECT',
1482: p_scenario_id => l_scenario_id,
1483: p_projects => null,
1484: x_return_status => l_return_status,

Line 1516: p_init_msg_list => FND_API.G_FALSE,

1512:
1513: fpa_scorecards_pvt.Calc_Scenario_Wscores_Aw
1514: (
1515: p_api_version => 1.0,
1516: p_init_msg_list => FND_API.G_FALSE,
1517: p_scenario_id => l_scenario_id,
1518: x_return_status => l_return_status,
1519: x_msg_count => l_msg_count,
1520: x_msg_data => l_msg_data

Line 2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2049: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2050: SQLERRM);
2051: END IF;
2052: wf_core.context('FPA_MAIN_PROCESS_PVT', 'FORCE_USER_ACTION', SQLERRM);
2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2054: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2055: p_data => x_msg_data
2056: );
2057: RAISE;

Line 2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2120: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2121: SQLERRM);
2122: END IF;
2123: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SUBMIT_PLAN', SQLERRM);
2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2125: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2126: p_data => x_msg_data
2127: );
2128: RAISE;

Line 2221: p_init_msg_list => FND_API.G_FALSE,

2217: END IF;
2218:
2219: FPA_SCORECARDS_PVT.Update_Scenario_App_Scores
2220: (p_api_version => 1.0,
2221: p_init_msg_list => FND_API.G_FALSE,
2222: p_scenario_id => l_sce_id,
2223: x_return_status => l_return_status,
2224: x_msg_count => l_msg_count,
2225: x_msg_data => l_msg_data

Line 2239: p_init_msg_list => FND_API.G_FALSE,

2235:
2236: FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS
2237: (
2238: p_api_version => 1.0,
2239: p_init_msg_list => FND_API.G_FALSE,
2240: p_commit => FND_API.G_FALSE,
2241: p_appr_scenario_id => l_sce_id,
2242: x_return_status => l_return_status,
2243: x_msg_count => l_msg_count,

Line 2240: p_commit => FND_API.G_FALSE,

2236: FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS
2237: (
2238: p_api_version => 1.0,
2239: p_init_msg_list => FND_API.G_FALSE,
2240: p_commit => FND_API.G_FALSE,
2241: p_appr_scenario_id => l_sce_id,
2242: x_return_status => l_return_status,
2243: x_msg_count => l_msg_count,
2244: x_msg_data => l_msg_data);

Line 2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2348: x_msg_data => x_msg_data
2349: );
2350:
2351: wf_core.context('FPA_MAIN_PROCESS_PVT', 'APPROVE_REJECT_PLAN', SQLERRM);
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2353: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );
2356: RAISE;

Line 2427: p_init_msg_list => FND_API.G_FALSE,

2423: END IF;
2424:
2425: FPA_PROJECT_PVT.Submit_Project_Aw(
2426: p_api_version => 1.0,
2427: p_init_msg_list => FND_API.G_FALSE,
2428: p_commit => FND_API.G_FALSE,
2429: p_project_id => l_project_id_tbl(i),
2430: x_return_status => l_return_status,
2431: x_msg_count => l_msg_count,

Line 2428: p_commit => FND_API.G_FALSE,

2424:
2425: FPA_PROJECT_PVT.Submit_Project_Aw(
2426: p_api_version => 1.0,
2427: p_init_msg_list => FND_API.G_FALSE,
2428: p_commit => FND_API.G_FALSE,
2429: p_project_id => l_project_id_tbl(i),
2430: x_return_status => l_return_status,
2431: x_msg_count => l_msg_count,
2432: x_msg_data => l_msg_data);