APPS.WIP_JSI_VALIDATOR dependencies on PJM_PROJECT

Line 1325: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp

1321: -- Bug 4890215. Performance Fix
1322: -- sugupta 26th-May-2006
1323: select mpv.project_id --this query will return multiple rows if the project has tasks
1324: into g_dummy
1325: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp
1326: where mpv.project_id = ppp.project_id
1327: and mpv.project_id = wjsi_row.project_id
1328: and ppp.organization_id = wjsi_row.organization_id
1329: and ppp.organization_id = mp.organization_id

Line 1347: if (PJM_PROJECT.val_task_idtonum(l_project_id, wjsi_row.task_id) is null)

1343: else
1344: l_project_id := nvl(wjsi_row.project_id, wdj_row.project_id);
1345: end if;
1346:
1347: if (PJM_PROJECT.val_task_idtonum(l_project_id, wjsi_row.task_id) is null)
1348: then
1349: raise fnd_api.g_exc_unexpected_error;
1350: end if;
1351:

Line 1364: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES

1360: l_errcode VARCHAR2(80);
1361: l_message VARCHAR2(2000);
1362: begin
1363: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job) and wjsi_row.project_id is not null) then
1364: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
1365: (x_inventory_org_id => wjsi_row.organization_id,
1366: x_project_id => wjsi_row.project_id,
1367: x_task_id => wjsi_row.task_id,
1368: x_date1 => wjsi_row.first_unit_start_date,

Line 1374: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then

1370: x_calling_function => 'WILMLX',
1371: x_error_code => l_errcode
1372: );
1373:
1374: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
1375: raise fnd_api.g_exc_unexpected_error;
1376: end if;
1377: end if;
1378: exception

Line 1382: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then

1378: exception
1379: when others then
1380: wip_utilities.get_message_stack(p_delete_stack => 'T',
1381: p_msg => l_message);
1382: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then
1383: wip_jsi_utils.record_error_text(l_message, false);
1384: wip_jsi_utils.abort_request;
1385: else
1386: wip_jsi_utils.record_error_text(l_message, true);

Line 1835: if(pjm_project_locator.check_itemLocatorControl(wjsi_row.organization_id,

1831: -- If successful, PJM will set the output locator parameter.
1832: -- If unsuccessful, they will leave it at its current value or,
1833: -- if things really go wrong, throw a no_data_found.
1834: if(wjsi_row.project_id is not null) then
1835: if(pjm_project_locator.check_itemLocatorControl(wjsi_row.organization_id,
1836: wjsi_row.completion_subinventory,
1837: wjsi_row.completion_locator_id,
1838: l_item_id,
1839: 2)) then

Line 1840: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,

1836: wjsi_row.completion_subinventory,
1837: wjsi_row.completion_locator_id,
1838: l_item_id,
1839: 2)) then
1840: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,
1841: wjsi_row.completion_locator_id,
1842: wjsi_row.project_id,
1843: wjsi_row.task_id,
1844: l_prj_loc_id);

Line 1847: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,

1843: wjsi_row.task_id,
1844: l_prj_loc_id);
1845: if(l_prj_loc_id is not null) then
1846: wjsi_row.completion_locator_id := l_prj_loc_id; --for write to wjsi
1847: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,
1848: l_prj_loc_id,
1849: 'SPECIFIC', -- validation mode
1850: 'Y', -- required?
1851: wjsi_row.project_id,