APPS.WIP_JSI_VALIDATOR dependencies on PJM_PROJECT

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

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

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

1338: else
1339: l_project_id := nvl(wjsi_row.project_id, wdj_row.project_id);
1340: end if;
1341:
1342: if (PJM_PROJECT.val_task_idtonum(l_project_id, wjsi_row.task_id) is null)
1343: then
1344: raise fnd_api.g_exc_unexpected_error;
1345: end if;
1346:

Line 1359: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES

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

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

1365: x_calling_function => 'WILMLX',
1366: x_error_code => l_errcode
1367: );
1368:
1369: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
1370: raise fnd_api.g_exc_unexpected_error;
1371: end if;
1372: end if;
1373: exception

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

1373: exception
1374: when others then
1375: wip_utilities.get_message_stack(p_delete_stack => 'T',
1376: p_msg => l_message);
1377: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then
1378: wip_jsi_utils.record_error_text(l_message, false);
1379: wip_jsi_utils.abort_request;
1380: else
1381: wip_jsi_utils.record_error_text(l_message, true);

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

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

Line 1835: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,

1831: wjsi_row.completion_subinventory,
1832: wjsi_row.completion_locator_id,
1833: l_item_id,
1834: 2)) then
1835: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,
1836: wjsi_row.completion_locator_id,
1837: wjsi_row.project_id,
1838: wjsi_row.task_id,
1839: l_prj_loc_id);

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

1838: wjsi_row.task_id,
1839: l_prj_loc_id);
1840: if(l_prj_loc_id is not null) then
1841: wjsi_row.completion_locator_id := l_prj_loc_id; --for write to wjsi
1842: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,
1843: l_prj_loc_id,
1844: 'SPECIFIC', -- validation mode
1845: 'Y', -- required?
1846: wjsi_row.project_id,