eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECTS

Line 1: PACKAGE BODY PA_PROJECTS_MAINT_PUB AS

1: PACKAGE BODY PA_PROJECTS_MAINT_PUB AS
2: /* $Header: PARMPRPB.pls 120.4.12010000.4 2008/09/22 07:17:12 kjai ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PUB';
4:
5: -- API name : create_project

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PUB';

1: PACKAGE BODY PA_PROJECTS_MAINT_PUB AS
2: /* $Header: PARMPRPB.pls 120.4.12010000.4 2008/09/22 07:17:12 kjai ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PUB';
4:
5: -- API name : create_project
6: -- Type : Public
7: -- Pre-reqs : None.

Line 141: l_project_id pa_projects.project_id%TYPE;

137: -- 4363092 end
138:
139: l_organization_id hr_organization_units.organization_id%TYPE;
140: l_project_status_code pa_project_statuses.project_status_code%TYPE;
141: l_project_id pa_projects.project_id%TYPE;
142: l_project_type pa_projects_all.project_type%TYPE;
143: l_project_number_out pa_projects.segment1%TYPE;
144: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
145: l_team_template_id pa_team_templates.team_template_id%TYPE;

Line 142: l_project_type pa_projects_all.project_type%TYPE;

138:
139: l_organization_id hr_organization_units.organization_id%TYPE;
140: l_project_status_code pa_project_statuses.project_status_code%TYPE;
141: l_project_id pa_projects.project_id%TYPE;
142: l_project_type pa_projects_all.project_type%TYPE;
143: l_project_number_out pa_projects.segment1%TYPE;
144: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
145: l_team_template_id pa_team_templates.team_template_id%TYPE;
146: l_country_code pa_locations.country_code%TYPE;

Line 143: l_project_number_out pa_projects.segment1%TYPE;

139: l_organization_id hr_organization_units.organization_id%TYPE;
140: l_project_status_code pa_project_statuses.project_status_code%TYPE;
141: l_project_id pa_projects.project_id%TYPE;
142: l_project_type pa_projects_all.project_type%TYPE;
143: l_project_number_out pa_projects.segment1%TYPE;
144: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
145: l_team_template_id pa_team_templates.team_template_id%TYPE;
146: l_country_code pa_locations.country_code%TYPE;
147: l_return_status VARCHAR2(1);

Line 165: From pa_projects_all

161:
162: CURSOR l_project_csr (c_project_id NUMBER)
163: Is
164: Select project_type
165: From pa_projects_all
166: Where project_id = c_project_id;
167:
168: BEGIN
169:

Line 176: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PUB.CREATE_PROJECT ... ');

172: if (p_debug_mode = 'Y') then
173: pa_debug.debug('Create_Project PUB : Checking the api version number.');
174: end if;
175:
176: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PUB.CREATE_PROJECT ... ');
177:
178: IF p_commit = FND_API.G_TRUE THEN
179: SAVEPOINT prm_create_project;
180: END IF;

Line 198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');

194: if (p_debug_mode = 'Y') then
195: pa_debug.debug('CREATE_PROJECT PUB : Initializing message stack.');
196: end if;
197:
198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');
199:
200: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
201: fnd_msg_pub.initialize;
202: end if;

Line 253: PA_PROJECTS_MAINT_UTILS.CHECK_PROJECT_STATUS_OR_ID

249: if (p_debug_mode = 'Y') then
250: pa_debug.debug('Create_Project PUB : Checking Project status');
251: end if;
252:
253: PA_PROJECTS_MAINT_UTILS.CHECK_PROJECT_STATUS_OR_ID
254: (p_project_status_code => p_project_status_code
255: ,p_project_status_name => p_project_status_name
256: ,p_check_id_flag => 'A'
257: ,x_project_status_code => l_project_status_code

Line 286: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID

282: THEN
283: if (p_debug_mode = 'Y') then
284: pa_debug.debug('Create_Project PUB : Checking Probability code');
285: end if;
286: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID
287: ( p_probability_member_id => p_probability_member_id
288: ,p_probability_percentage => p_probability_percentage
289: ,p_project_type => l_project_type
290: ,p_check_id_flag => 'Y'

Line 449: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE

445: if (p_debug_mode = 'Y') then
446: pa_debug.debug('Create_Project PUB : Checking agreement currency');
447: end if;
448:
449: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE
450: ( p_agreement_currency => p_agreement_currency
451: ,p_agreement_currency_name => p_agreement_currency_name
452: ,p_check_id_flag => 'Y'
453: ,x_agreement_currency => l_agreement_currency

Line 473: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE

469: if (p_debug_mode = 'Y') then
470: pa_debug.debug('Create_Project PUB : Checking Opportunity Value currency');
471: end if;
472:
473: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE
474: ( p_agreement_currency => p_opp_value_currency_code
475: ,p_agreement_currency_name => p_opp_value_currency_name
476: ,p_check_id_flag => 'Y'
477: ,x_agreement_currency => l_opp_value_currency_code

Line 498: PA_PROJECTS_MAINT_UTILS.CHECK_AGREEMENT_ORG_NAME_OR_ID

494: if (p_debug_mode = 'Y') then
495: pa_debug.debug('Create_Project PUB : Checking agreement org');
496: end if;
497:
498: PA_PROJECTS_MAINT_UTILS.CHECK_AGREEMENT_ORG_NAME_OR_ID
499: ( p_agreement_org_id => p_agreement_org_id
500: ,p_agreement_org_name => p_agreement_org_name
501: ,p_check_id_flag => 'Y'
502: ,x_agreement_org_id => l_agreement_org_id

Line 549: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');

545: RAISE FND_API.G_EXC_ERROR;
546: end if;
547: */
548:
549: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
550:
551: /* For Bug 2731449 modified p_bill_to_customer_id to l_bill_to_customer_id
552: and p_ship_to_customer_id to l_ship_to_customer_id */
553:

Line 558: PA_PROJECTS_MAINT_PVT.CREATE_PROJECT

554: if (p_debug_mode = 'Y') then
555: pa_debug.debug('Create_Project PUB : Calling private api Create_project');
556: end if;
557:
558: PA_PROJECTS_MAINT_PVT.CREATE_PROJECT
559: (
560: p_commit => FND_API.G_FALSE,
561: p_validate_only => p_validate_only,
562: p_validation_level => p_validation_level,

Line 658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

654: IF p_commit = FND_API.G_TRUE THEN
655: ROLLBACK TO prm_create_project;
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
659: p_procedure_name => 'CREATE_PROJECT',
660: p_error_text => SUBSTRB(SQLERRM,1,240));
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662:

Line 674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

670: IF p_commit = FND_API.G_TRUE THEN
671: ROLLBACK TO prm_create_project;
672: END IF;
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
675: p_procedure_name => 'CREATE_PROJECT',
676: p_error_text => SUBSTRB(SQLERRM,1,240));
677: raise;
678:

Line 755: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_CUSTOMER');

751: THEN
752: SAVEPOINT create_customer;
753: END IF;
754:
755: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_CUSTOMER');
756:
757: if (p_debug_mode = 'Y') then
758: pa_debug.debug('Create_Customer PUB : checking API compatibility');
759: end if;

Line 816: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER

812: if (p_debug_mode = 'Y') then
813: pa_debug.debug('Create_Customer PUB : calling Create_customer private API');
814: end if;
815:
816: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER
817: ( p_commit => FND_API.G_FALSE ,
818: p_validate_only => p_validate_only ,
819: p_validation_level => p_validation_level ,
820: p_debug_mode => p_debug_mode ,

Line 876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

872: IF p_commit = FND_API.G_TRUE THEN
873: ROLLBACK TO create_customer;
874: END IF;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
877: p_procedure_name => 'CREATE_CUSTOMER',
878: p_error_text => SUBSTRB(SQLERRM,1,240));
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:

Line 892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

888: IF p_commit = FND_API.G_TRUE THEN
889: ROLLBACK TO create_customer;
890: END IF;
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
893: p_procedure_name => 'CREATE_CUSTOMER',
894: p_error_text => SUBSTRB(SQLERRM,1,240));
895: raise;
896:

Line 1026: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PUB.CREATE_PROJECT ... ');

1022: l_data VARCHAR2(250);
1023:
1024: BEGIN
1025:
1026: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PUB.CREATE_PROJECT ... ');
1027:
1028: IF p_commit = FND_API.G_TRUE THEN
1029: SAVEPOINT update_project_basic_info;
1030: END IF;

Line 1032: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_basic_info');

1028: IF p_commit = FND_API.G_TRUE THEN
1029: SAVEPOINT update_project_basic_info;
1030: END IF;
1031:
1032: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_basic_info');
1033:
1034: --dbms_output.put_line('Starts here FND_API.COMPATIBLE_API_CALL ... ');
1035:
1036: if (p_debug_mode = 'Y') then

Line 1138: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_BASIC_INFO

1134: --dbms_output.put_line(' location **** '||to_char(p_location_id));
1135: if (p_debug_mode = 'Y') then
1136: pa_debug.debug('Update_project_basic_info PUB : Calling private API update_project_basic_info');
1137: end if;
1138: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_BASIC_INFO
1139: (
1140: p_commit => FND_API.G_FALSE,
1141: p_validate_only => p_validate_only,
1142: p_validation_level => p_validation_level,

Line 1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1231: IF p_commit = FND_API.G_TRUE THEN
1232: ROLLBACK TO update_project_basic_info;
1233: END IF;
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1236: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1237: p_error_text => SUBSTRB(SQLERRM,1,240));
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239:

Line 1251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1247: IF p_commit = FND_API.G_TRUE THEN
1248: ROLLBACK TO update_project_basic_info;
1249: END IF;
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1252: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1253: p_error_text => SUBSTRB(SQLERRM,1,240));
1254: raise;
1255:

Line 1349: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_additional_info');

1345: IF p_commit = FND_API.G_TRUE THEN
1346: SAVEPOINT update_project_additional_info;
1347: END IF;
1348:
1349: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_additional_info');
1350:
1351: if (p_debug_mode = 'Y') then
1352: pa_debug.debug('Update_project_Additional_info PUB : Checking API Compatibility');
1353: end if;

Line 1368: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_ADDITIONAL_INFO ');

1364: end if;
1365:
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367:
1368: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_ADDITIONAL_INFO ');
1369: -- write your program logic from here
1370:
1371: IF (p_calendar_id is not null AND
1372: p_calendar_id <> FND_API.G_MISS_NUM) OR

Line 1404: l_cost_job_Group_id := PA_PROJECTS_MAINT_UTILS.GET_COST_JOB_GROUP_ID;

1400:
1401: l_cost_job_group_id := p_cost_job_group_id;
1402: IF l_cost_job_Group_id is null
1403: THEN
1404: l_cost_job_Group_id := PA_PROJECTS_MAINT_UTILS.GET_COST_JOB_GROUP_ID;
1405: END IF;
1406:
1407: l_msg_count := FND_MSG_PUB.count_msg;
1408: If l_msg_count > 0 THEN

Line 1443: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');

1439: if (p_debug_mode = 'Y') then
1440: pa_debug.debug('Update_project_Additional_info PUB : Calling private API Update_project_additional_info ');
1441: end if;
1442:
1443: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
1444:
1445: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_ADDITIONAL_INFO
1446: (
1447: p_commit => FND_API.G_FALSE,

Line 1445: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_ADDITIONAL_INFO

1441: end if;
1442:
1443: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
1444:
1445: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_ADDITIONAL_INFO
1446: (
1447: p_commit => FND_API.G_FALSE,
1448: p_validate_only => p_validate_only,
1449: p_validation_level => p_validation_level,

Line 1523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1519: IF p_commit = FND_API.G_TRUE THEN
1520: ROLLBACK TO update_project_additional_info;
1521: END IF;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1524: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
1525: p_error_text => SUBSTRB(SQLERRM,1,240));
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:

Line 1540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1536: IF p_commit = FND_API.G_TRUE THEN
1537: ROLLBACK TO update_project_additional_info;
1538: END IF;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1541: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
1542: p_error_text => SUBSTRB(SQLERRM,1,240));
1543: raise;
1544:

Line 1612: l_project_type pa_projects_all.project_type%TYPE;

1608: l_data VARCHAR2(250);
1609: l_msg_index_out NUMBER;
1610: l_dummy VARCHAR2(1);
1611: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1612: l_project_type pa_projects_all.project_type%TYPE;
1613: l_expected_approval_date DATE;
1614: l_opportunity_value NUMBER;
1615: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1616:

Line 1621: From pa_projects_all pr, pa_project_opp_attrs op

1617: CURSOR c1
1618: IS
1619: Select pr.project_type, pr.probability_member_id, pr.expected_approval_date,
1620: op.opportunity_value, op.opp_value_currency_code
1621: From pa_projects_all pr, pa_project_opp_attrs op
1622: Where pr.project_id = op.project_id
1623: AND pr.project_id = p_project_id;
1624:
1625: v_c1 c1%ROWTYPE;

Line 1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');

1629: IF p_commit = FND_API.G_TRUE THEN
1630: SAVEPOINT update_project_pipeline_info;
1631: END IF;
1632:
1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');
1634:
1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1636: if (p_debug_mode = 'Y') then
1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

Line 1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');
1634:
1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1636: if (p_debug_mode = 'Y') then
1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1638: ,x_msg => 'Beginning of update_project_pipeline_info'
1639: ,x_log_level => 3);
1640: end if;
1641: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1681: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID

1677: THEN
1678: if (p_debug_mode = 'Y') then
1679: pa_debug.debug('Create_Project PUB : Checking Probability code');
1680: end if;
1681: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID
1682: ( p_probability_member_id => p_probability_member_id
1683: ,p_probability_percentage => p_probability_percentage
1684: ,p_project_type => l_project_type
1685: ,p_check_id_flag => 'A'

Line 1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1688: ,x_error_msg_code => l_error_msg_code);
1689:
1690: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1691: if (p_debug_mode = 'Y') then
1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1693: ,x_msg => 'AFTER check probablity ... '||l_return_status
1694: ,x_log_level => 3);
1695: end if;
1696: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1730: end if;
1731:
1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1733: if (p_debug_mode = 'Y') then
1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1736: ,x_log_level => 3);
1737: end if;
1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'

1731:
1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1733: if (p_debug_mode = 'Y') then
1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1736: ,x_log_level => 3);
1737: end if;
1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1739:

Line 1740: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO (

1736: ,x_log_level => 3);
1737: end if;
1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1739:
1740: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO (
1741: p_commit => FND_API.G_FALSE,
1742: p_validate_only => p_validate_only,
1743: p_validation_level => p_validation_level,
1744: p_calling_module => p_calling_module,

Line 1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1754: x_msg_data => l_msg_data);
1755:
1756: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1757: if (p_debug_mode = 'Y') then
1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1760: ,x_log_level => 3);
1761: end if;
1762: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'

1755:
1756: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1757: if (p_debug_mode = 'Y') then
1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1760: ,x_log_level => 3);
1761: end if;
1762: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1763:

Line 1825: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1821: IF p_commit = FND_API.G_TRUE THEN
1822: ROLLBACK TO update_project_pipeline_info;
1823: END IF;
1824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1825: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1826: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
1827: p_error_text => SUBSTRB(SQLERRM,1,240));
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1829:

Line 1841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1837: IF p_commit = FND_API.G_TRUE THEN
1838: ROLLBACK TO update_project_pipeline_info;
1839: END IF;
1840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1842: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
1843: p_error_text => SUBSTRB(SQLERRM,1,240));
1844: raise;
1845:

Line 1926: l_created_from_project_id pa_projects.created_from_project_id%TYPE;

1922: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1923: IS
1924:
1925: l_dummy VARCHAR2(1);
1926: l_created_from_project_id pa_projects.created_from_project_id%TYPE;
1927: l_api_name CONSTANT VARCHAR(30) := 'create_classifications';
1928: l_api_version CONSTANT NUMBER := 1.0;
1929: l_project_id pa_projects.project_id%TYPE;
1930: l_row_id VARCHAR2(250);

Line 1929: l_project_id pa_projects.project_id%TYPE;

1925: l_dummy VARCHAR2(1);
1926: l_created_from_project_id pa_projects.created_from_project_id%TYPE;
1927: l_api_name CONSTANT VARCHAR(30) := 'create_classifications';
1928: l_api_version CONSTANT NUMBER := 1.0;
1929: l_project_id pa_projects.project_id%TYPE;
1930: l_row_id VARCHAR2(250);
1931: l_return_status VARCHAR2(250);
1932: l_error_msg_code VARCHAR2(250);
1933: l_msg_count NUMBER;

Line 1946: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.create_classifications');

1942: IF p_commit = FND_API.G_TRUE THEN
1943: SAVEPOINT create_classifications;
1944: END IF;
1945:
1946: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.create_classifications');
1947:
1948: if (p_debug_mode = 'Y') then
1949: pa_debug.debug('Create_classifications PUB : Checking API compatibility');
1950: end if;

Line 1989: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1985: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
1986: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
1987: x_return_status := 'E' ;
1988: WHEN OTHERS THEN
1989: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1990: p_procedure_name => 'CREATE_CLASSIFICATIONS',
1991: p_error_text => SUBSTRB(SQLERRM,1,240));
1992: raise;
1993: END;

Line 2013: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2009: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2010: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2011: x_return_status := 'E' ;
2012: WHEN OTHERS THEN
2013: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2014: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2015: p_error_text => SUBSTRB(SQLERRM,1,240));
2016: raise;
2017: END;

Line 2052: PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATIONS

2048: x_return_status := 'E';
2049: RAISE FND_API.G_EXC_ERROR;
2050: end if;
2051: */
2052: PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATIONS
2053: (
2054: p_commit => FND_API.G_FALSE,
2055: p_validate_only => p_validate_only,
2056: p_validation_level => p_validation_level,

Line 2111: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATIONS '||to_char(l_msg_count));

2107: ELSE
2108: x_msg_count := l_msg_count;
2109: END IF;
2110:
2111: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATIONS '||to_char(l_msg_count));
2112:
2113: if (p_debug_mode = 'Y') then
2114: pa_debug.debug('Create_classifications PUB : Checking message count');
2115: end if;

Line 2117: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT. '||l_data);

2113: if (p_debug_mode = 'Y') then
2114: pa_debug.debug('Create_classifications PUB : Checking message count');
2115: end if;
2116:
2117: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT. '||l_data);
2118:
2119: IF l_msg_count > 0 THEN
2120: x_return_status := 'E';
2121: RAISE FND_API.G_EXC_ERROR;

Line 2134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2130: IF p_commit = FND_API.G_TRUE THEN
2131: ROLLBACK TO create_classifications;
2132: END IF;
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2135: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2136: p_error_text => SUBSTRB(SQLERRM,1,240));
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138:

Line 2150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2146: IF p_commit = FND_API.G_TRUE THEN
2147: ROLLBACK TO CREATE_CLASSIFICATIONS;
2148: END IF;
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2151: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2152: p_error_text => SUBSTRB(SQLERRM,1,240));
2153: raise;
2154:

Line 2240: l_created_from_project_id pa_projects.created_from_project_id%TYPE;

2236: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2237: IS
2238:
2239: l_dummy VARCHAR2(1);
2240: l_created_from_project_id pa_projects.created_from_project_id%TYPE;
2241: l_api_name CONSTANT VARCHAR(30) := 'create_classifications';
2242: l_api_version CONSTANT NUMBER := 1.0;
2243: l_project_id pa_projects.project_id%TYPE;
2244: l_row_id VARCHAR2(250);

Line 2243: l_project_id pa_projects.project_id%TYPE;

2239: l_dummy VARCHAR2(1);
2240: l_created_from_project_id pa_projects.created_from_project_id%TYPE;
2241: l_api_name CONSTANT VARCHAR(30) := 'create_classifications';
2242: l_api_version CONSTANT NUMBER := 1.0;
2243: l_project_id pa_projects.project_id%TYPE;
2244: l_row_id VARCHAR2(250);
2245: l_return_status VARCHAR2(250);
2246: l_error_msg_code VARCHAR2(250);
2247: l_msg_count NUMBER;

Line 2260: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_classifications');

2256: IF p_commit = FND_API.G_TRUE THEN
2257: SAVEPOINT update_classifications;
2258: END IF;
2259:
2260: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_classifications');
2261:
2262: if (p_debug_mode = 'Y') then
2263: pa_debug.debug('Update_classifications PUB : Checking API compatibility');
2264: end if;

Line 2303: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2299: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
2300: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
2301: x_return_status := 'E' ;
2302: WHEN OTHERS THEN
2303: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2304: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2305: p_error_text => SUBSTRB(SQLERRM,1,240));
2306: raise;
2307: END;

Line 2327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2323: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2324: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2325: x_return_status := 'E' ;
2326: WHEN OTHERS THEN
2327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2328: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2329: p_error_text => SUBSTRB(SQLERRM,1,240));
2330: raise;
2331: END;

Line 2350: PA_PROJECTS_MAINT_PVT.UPDATE_CLASSIFICATIONS

2346: RAISE FND_API.G_EXC_ERROR;
2347: End if;
2348:
2349:
2350: PA_PROJECTS_MAINT_PVT.UPDATE_CLASSIFICATIONS
2351: (
2352: p_commit => FND_API.G_FALSE,
2353: p_validate_only => p_validate_only,
2354: p_validation_level => p_validation_level,

Line 2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2407: IF p_commit = FND_API.G_TRUE THEN
2408: ROLLBACK TO update_classifications;
2409: END IF;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2412: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2413: p_error_text => SUBSTRB(SQLERRM,1,240));
2414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2415:

Line 2427: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2423: IF p_commit = FND_API.G_TRUE THEN
2424: ROLLBACK TO UPDATE_CLASSIFICATIONS;
2425: END IF;
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2428: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2429: p_error_text => SUBSTRB(SQLERRM,1,240));
2430: raise;
2431:

Line 2482: l_project_id pa_projects.project_id%TYPE;

2478: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2479: IS
2480: l_api_name CONSTANT VARCHAR(30) := 'delete_classifications';
2481: l_api_version CONSTANT NUMBER := 1.0;
2482: l_project_id pa_projects.project_id%TYPE;
2483: l_dummy VARCHAR2(1);
2484: l_delete_flag VARCHAR2(1) := 'N';
2485: l_return_status VARCHAR2(250);
2486: l_error_msg_code VARCHAR2(250);

Line 2503: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.delete_classifications');

2499: IF p_commit = FND_API.G_TRUE THEN
2500: SAVEPOINT delete_classifications;
2501: END IF;
2502:
2503: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.delete_classifications');
2504:
2505: if (p_debug_mode = 'Y') then
2506: pa_debug.debug('delete_classifications PUB : Checking API Compatibility');
2507: end if;

Line 2527: PA_PROJECTS_MAINT_PVT.DELETE_CLASSIFICATIONS

2523:
2524: if (p_debug_mode = 'Y') then
2525: pa_debug.debug('delete_classifications PUB : Calling private API delete_classifcations');
2526: end if;
2527: PA_PROJECTS_MAINT_PVT.DELETE_CLASSIFICATIONS
2528: (
2529: p_commit => FND_API.G_FALSE,
2530: p_validate_only => p_validate_only,
2531: p_validation_level => p_validation_level,

Line 2588: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2584: IF p_commit = FND_API.G_TRUE THEN
2585: ROLLBACK TO delete_classifications;
2586: END IF;
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2589: p_procedure_name => 'DELETE_CLASSIFICATIONS',
2590: p_error_text => SUBSTRB(SQLERRM,1,240));
2591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2592:

Line 2604: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2600: IF p_commit = FND_API.G_TRUE THEN
2601: ROLLBACK TO delete_classifications;
2602: END IF;
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2604: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2605: p_procedure_name => 'DELETE_CLASSIFICATIONS',
2606: p_error_text => SUBSTRB(SQLERRM,1,240));
2607: raise;
2608:

Line 2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

2621: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
2622: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

2622: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

Line 2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM

2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR

2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required

Line 2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required
2638: -- x_return_status OUT VARCHAR2 Required
2639: -- x_msg_count OUT NUMBER Required

Line 2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required
2638: -- x_return_status OUT VARCHAR2 Required
2639: -- x_msg_count OUT NUMBER Required
2640: -- x_msg_data OUT VARCHAR2 Required

Line 2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,

2653: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
2654: p_debug_mode IN VARCHAR2 := 'N' ,
2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

Line 2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,

2654: p_debug_mode IN VARCHAR2 := 'N' ,
2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,

Line 2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

Line 2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,

2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,

Line 2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

Line 2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

Line 2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,

Line 2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,
2670: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
2671: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,
2670: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
2671: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2672: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;

2686: l_data VARCHAR2(250);
2687: l_msg_index_out NUMBER;
2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN

Line 2691: l_search_country_code pa_projects_all.search_country_code%TYPE;

2687: l_msg_index_out NUMBER;
2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN
2695:

Line 2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;

2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN
2695:
2696: IF p_commit = FND_API.G_TRUE THEN

Line 2700: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_staffing_info');

2696: IF p_commit = FND_API.G_TRUE THEN
2697: SAVEPOINT update_project_staffing_info;
2698: END IF;
2699:
2700: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_staffing_info');
2701:
2702: if (p_debug_mode = 'Y') then
2703: pa_debug.debug('Update_project_staffing_info PUB : Checking API Compatibility');
2704: end if;

Line 2946: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_STAFFING_INFO

2942: pa_debug.debug('update_project_staffing_info PUB : Calling private API update_project_staffing_info');
2943: end if;
2944:
2945:
2946: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_STAFFING_INFO
2947: (
2948: p_commit => FND_API.G_FALSE,
2949: p_validate_only => p_validate_only,
2950: p_validation_level => p_validation_level,

Line 2997: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2993: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2994: IF p_commit = FND_API.G_TRUE THEN
2995: ROLLBACK TO update_project_staffing_info;
2996: END IF;
2997: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2998: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
2999: p_error_text => SUBSTRB(SQLERRM,1,240));
3000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3001:

Line 3013: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3009: IF p_commit = FND_API.G_TRUE THEN
3010: ROLLBACK TO update_project_staffing_info;
3011: END IF;
3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3013: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3014: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
3015: p_error_text => SUBSTRB(SQLERRM,1,240));
3016: raise;
3017:

Line 3117: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');

3113: FROM pa_project_role_types_b /* Bug#2788814-Changed pa_project_role_types_vl to pa_project_role_types_b */
3114: WHERE project_role_id = c_project_role_id;
3115:
3116: BEGIN
3117: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');
3118:
3119: if (p_debug_mode = 'Y') then
3120: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');
3121: end if;

Line 3120: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');

3116: BEGIN
3117: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');
3118:
3119: if (p_debug_mode = 'Y') then
3120: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');
3121: end if;
3122:
3123: if p_commit = FND_API.G_TRUE then
3124: savepoint create_org_role;

Line 3309: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role END');

3305: commit work;
3306: end if;
3307:
3308: if (p_debug_mode = 'Y') then
3309: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role END');
3310: end if;
3311:
3312: EXCEPTION
3313: when FND_API.G_EXC_ERROR then

Line 3323: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3319: if p_commit = FND_API.G_TRUE then
3320: rollback to create_org_role;
3321: end if;
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3323: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3324: p_procedure_name => 'Create_Org_Role',
3325: p_error_text => SUBSTRB(SQLERRM,1,240));
3326: when OTHERS then
3327: if p_commit = FND_API.G_TRUE then

Line 3331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3327: if p_commit = FND_API.G_TRUE then
3328: rollback to create_org_role;
3329: end if;
3330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3332: p_procedure_name => 'Create_Org_Role',
3333: p_error_text => SUBSTRB(SQLERRM,1,240));
3334: raise;
3335: END CREATE_ORG_ROLE;

Line 3379: FROM pa_projects_all

3375: ,attribute9
3376: ,attribute10
3377: ,pm_product_code
3378: ,segment1 -- 3671408 added column to retrieve project number value
3379: FROM pa_projects_all
3380: WHERE project_id = p_project_id;
3381:
3382: CURSOR cur_get_project_status_code( c_project_id IN NUMBER ) IS
3383: SELECT project_status_code

Line 3384: FROM pa_projects_all

3380: WHERE project_id = p_project_id;
3381:
3382: CURSOR cur_get_project_status_code( c_project_id IN NUMBER ) IS
3383: SELECT project_status_code
3384: FROM pa_projects_all
3385: WHERE project_id = c_project_id;
3386:
3387: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
3388: SELECT pps.project_system_status_code

Line 3462: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :

3458: ( p_new_status_code IS NULL OR p_new_status_code = FND_API.G_MISS_CHAR )
3459: )
3460: THEN
3461: IF l_debug_mode = 'Y' THEN
3462: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :
3463: p_project_id, p_new_status_code are NULL';
3464: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3465: l_debug_level3);
3466: END IF;

Line 3577: X_OBJECT_TYPE => 'PA_PROJECTS',

3573: --For inserting status change comment into the status history table
3574: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW
3575: ( X_ROWID => l_rowid,
3576: X_OBJ_STATUS_CHANGE_ID => l_obj_status_change_id,
3577: X_OBJECT_TYPE => 'PA_PROJECTS',
3578: X_OBJECT_ID => p_project_id,
3579: X_STATUS_TYPE => 'PROJECT',
3580: X_NEW_PROJECT_STATUS_CODE => p_new_status_code,
3581: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,

Line 3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');

3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3590:
3591: IF (l_debug_mode = 'Y') THEN
3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3593: END IF;
3594:
3595: /*Stubbed Out Auto Initiate Demand On Project Approval Functionality
3596: Bug 3819086 */

Line 3620: FROM PA_PROJECTS_ALL

3616:
3617: END;
3618:
3619: SELECT wf_status_code INTO l_wf_status_code
3620: FROM PA_PROJECTS_ALL
3621: WHERE project_id = p_project_id;
3622:
3623: IF (l_debug_mode = 'Y') THEN
3624: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,

Line 3634: UPDATE pa_projects_all

3630: -- 4364878 : if new system status corresponds to CLOSED
3631: -- Then Populate the closed date as sysdate
3632:
3633: IF l_new_sys_status = 'CLOSED' THEN
3634: UPDATE pa_projects_all
3635: SET wf_status_code = NULL
3636: ,project_status_code = p_new_status_code
3637: ,closed_date = sysdate
3638: ,last_update_date = sysdate

Line 3644: UPDATE pa_projects_all

3640: ,last_update_login = fnd_global.login_id
3641: WHERE project_id = p_project_id;
3642: ELSE
3643:
3644: UPDATE pa_projects_all
3645: SET wf_status_code = NULL
3646: ,project_status_code = p_new_status_code --Added for bug 3818322
3647: /*4364878 : Included update of who columns also*/
3648: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3661: -- Update wf status in pa_projects_all

3657:
3658:
3659: ELSIF l_wf_status_code IS NULL THEN -- Made ELSEIF against the existing IF, for BUG# 6661144
3660: IF l_wf_enabled_flag = 'Y' THEN
3661: -- Update wf status in pa_projects_all
3662:
3663: -- 4364878 : if new system status corresponds to CLOSED
3664: -- Then Populate the closed date as sysdate
3665:

Line 3667: UPDATE pa_projects_all

3663: -- 4364878 : if new system status corresponds to CLOSED
3664: -- Then Populate the closed date as sysdate
3665:
3666: If l_new_sys_status = 'CLOSED' THEN
3667: UPDATE pa_projects_all
3668: SET wf_status_code = 'IN_ROUTE'
3669: ,project_status_code = p_new_status_code
3670: ,closed_date = sysdate
3671: ,last_update_date = sysdate

Line 3677: UPDATE pa_projects_all

3673: ,last_update_login = fnd_global.login_id
3674: WHERE project_id = p_project_id;
3675: ELSE
3676:
3677: UPDATE pa_projects_all
3678: SET wf_status_code = 'IN_ROUTE'
3679: ,project_status_code = p_new_status_code --Added for bug 3818322
3680: /*4364878 : Included update of who columns also*/
3681: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3716: UPDATE pa_projects_all

3712: -- 4364878 : if new system status corresponds to CLOSED
3713: -- Then Populate the closed date as sysdate
3714: If l_new_sys_status = 'CLOSED' THEN
3715:
3716: UPDATE pa_projects_all
3717: SET project_status_code = p_new_status_code
3718: ,closed_date = sysdate
3719: ,last_update_date = sysdate
3720: ,last_updated_by = fnd_global.user_id

Line 3726: UPDATE pa_projects_all

3722: WHERE project_id = p_project_id ;
3723:
3724: Else
3725:
3726: UPDATE pa_projects_all
3727: SET project_status_code = p_new_status_code
3728: /*4364878 : Included update of who columns also*/
3729: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3730: ,last_update_date = sysdate

Line 3775: x_msg_data := ' PA_PROJECTS_MAINT_PUB : project_status_change : NULL parameters passed';

3771:
3772: WHEN Invalid_Arg_Exc THEN
3773: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3774: x_msg_count := 1;
3775: x_msg_data := ' PA_PROJECTS_MAINT_PUB : project_status_change : NULL parameters passed';
3776:
3777: IF p_commit = FND_API.G_TRUE THEN
3778: ROLLBACK TO project_status_change;
3779: END IF;

Line 3782: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'

3778: ROLLBACK TO project_status_change;
3779: END IF;
3780:
3781: Fnd_Msg_Pub.add_exc_msg
3782: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3783: , p_procedure_name => 'project_status_change'
3784: , p_error_text => x_msg_data);
3785:
3786: IF l_debug_mode = 'Y' THEN

Line 3804: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'

3800: ROLLBACK TO project_status_change;
3801: END IF;
3802:
3803: Fnd_Msg_Pub.add_exc_msg
3804: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3805: , p_procedure_name => 'project_status_change'
3806: , p_error_text => x_msg_data);
3807:
3808: IF l_debug_mode = 'Y' THEN

Line 3819: END PA_PROJECTS_MAINT_PUB;

3815:
3816: END project_status_change;
3817:
3818:
3819: END PA_PROJECTS_MAINT_PUB;