[Home] [Help]
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: --check for project number uniqueness
246: IF pa_project_utils.check_unique_project_number (x_project_number => p_project_number
247: ,x_rowid => null ) = 0
248: THEN
249: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
250: p_msg_name => 'PA_SETUP_TMPL_NUM_NOT_UNIQUE' );
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: --check for project name uniqueness
258: IF pa_project_utils.check_unique_project_name (x_project_name => p_project_name
259: ,x_rowid => null ) = 0
260: THEN
261: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
262: p_msg_name => 'PA_SETUP_TMPL_NAME_NOT_UNIQUE' );
268:
269: -- anlee
270: -- Project Long Name changes
271: -- check for long name uniqueness
272: IF pa_project_utils.check_unique_long_name (p_long_name, null ) = 0
273: THEN
274: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
275: p_msg_name => 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE' );
276: --x_msg_data := 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE';
485:
486: --Validdate attribute change from WHEN-VALIDATE-RECORD projects form
487: --The following validation is done in forms when a template is created.
488:
489: pa_project_utils2.validate_attribute_change
490: ('ORGANIZATION_VALIDATION' -- X_context
491: , 'INSERT' -- X_insert_update_mode
492: , 'SELF_SERVICE' -- X_calling_module
493: , null -- X_project_id
1459:
1460: --Check proj number change
1461: IF l_proj_number <> p_project_number
1462: THEN
1463: pa_project_utils.change_proj_num_ok (
1464: p_project_id,
1465: l_err_code,
1466: l_err_stage,
1467: l_err_stack);
1474: end If;
1475: END IF;
1476:
1477: --check for project number uniqueness
1478: IF pa_project_utils.check_unique_project_number (x_project_number => p_project_number
1479: ,x_rowid => l_row_id ) = 0
1480: THEN
1481: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1482: p_msg_name => 'PA_SETUP_TMPL_NUM_NOT_UNIQUE' );
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488: --check for project name uniqueness
1489: IF pa_project_utils.check_unique_project_name (x_project_name => p_project_name
1490: ,x_rowid => l_row_id ) = 0
1491: THEN
1492: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1493: p_msg_name => 'PA_SETUP_TMPL_NAME_NOT_UNIQUE' );
1497: END IF;
1498:
1499: -- anlee
1500: -- Project Long Name changes
1501: IF pa_project_utils.check_unique_long_name (p_long_name, l_row_id ) = 0
1502: THEN
1503: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1504: p_msg_name => 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE' );
1505: x_msg_data := 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE';
1618: THEN
1619: OPEN cur_dist_rule;
1620: FETCH cur_dist_rule INTO l_distribution_rule;
1621: CLOSE cur_dist_rule;
1622: /* Pa_project_utils.check_dist_rule_chg_ok( p_project_id,
1623: l_old_distribution_rule,
1624: l_distribution_rule,
1625: x_err_code,
1626: x_err_stage,
1642: WHERE PROJECT_ID = P_PROJECT_ID;
1643:
1644: IF l_project_type_class_code IS NOT NULL AND l_project_type_class_code <> 'CONTRACT'
1645: THEN
1646: IF pa_project_utils.check_proj_funding ( p_project_id ) <> 0
1647: THEN
1648: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1649: p_msg_name => 'PA_PR_CANT_CHG_DIR_TO_INDIR' );
1650: x_msg_data := 'PA_PR_CANT_CHG_DIR_TO_INDIR';
1676: l_emp_bill_rate_Schedule_id := null;
1677: l_job_bill_rate_Schedule_id := null;
1678: END IF;
1679:
1680: /* pa_project_utils.change_pt_org_ok( x_project_id => p_project_id,
1681: x_err_code => l_err_code,
1682: x_err_stage => l_err_stage,
1683: x_err_stack => l_err_stack );
1684: IF l_err_code <> 0
1751: --The following validation is done in forms when a template is created.
1752:
1753: IF ( p_organization_id <> l_old_organization_id OR l_old_project_type <> p_project_type )
1754: THEN
1755: pa_project_utils2.validate_attribute_change
1756: ('ORGANIZATION_VALIDATION' -- X_context
1757: , 'INSERT' -- X_insert_update_mode
1758: , 'SELF_SERVICE' -- X_calling_module
1759: , p_project_id -- X_project_id