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_PROJECT_PUB dependencies on PA_PROJECT_PVT

Line 1398: IF pa_project_pvt.check_class_code_valid(l_class_categories(j).class_category,

1394: AND l_class_categories(j).class_code IS NOT NULL
1395: THEN
1396: l_class_code_categories := 1;
1397: -- check whether the class category and class code combination is a valid one
1398: IF pa_project_pvt.check_class_code_valid(l_class_categories(j).class_category,
1399: l_class_categories(j).class_code) = 'N'
1400: THEN
1401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1402: THEN

Line 2066: IF pa_project_pvt.check_valid_dist_rule

2062:
2063: IF l_project_in_rec.distribution_rule <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2064: AND l_project_in_rec.distribution_rule IS NOT NULL
2065: THEN
2066: IF pa_project_pvt.check_valid_dist_rule
2067: (l_source_project_type,
2068: l_project_in_rec.distribution_rule,
2069: l_project_in_rec.enable_top_task_inv_mth_flag ) = 'N' --Bug 3279981
2070: THEN

Line 2092: IF pa_project_pvt.check_valid_org

2088:
2089: IF l_project_in_rec.carrying_out_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2090: AND l_project_in_rec.carrying_out_organization_id IS NOT NULL
2091: THEN
2092: IF pa_project_pvt.check_valid_org
2093: (l_project_in_rec.carrying_out_organization_id) = 'N'
2094: THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2096: THEN

Line 2381: IF pa_project_pvt.check_valid_project_status

2377: l_project_in_rec.project_status_code :=
2378: pa_project_stus_utils.Get_Default_Starting_Status
2379: (x_project_type => l_source_project_type);
2380: ELSE
2381: IF pa_project_pvt.check_valid_project_status
2382: ( p_project_status => l_project_in_rec.project_status_code ) = 'N'
2383: THEN
2384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2385: THEN

Line 3354: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

3350:
3351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3352: THEN
3353:
3354: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
3355: THEN
3356:
3357: pa_interface_utils_pub.map_new_amg_msg('PA_COPY_PROJECT_FAILED','CHANGE','N',
3358: 'PROJ',l_project_in_rec.pm_project_reference,

Line 3875: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

3871:
3872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3873: THEN
3874:
3875: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
3876: THEN
3877: pa_interface_utils_pub.map_new_amg_msg
3878: ( p_old_message_code => 'PA_GET_CUSTOMER_INFO_FAILED'
3879: ,p_msg_attribute => 'CHANGE'

Line 4059: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

4055:
4056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4057: THEN
4058:
4059: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4060: THEN
4061: pa_interface_utils_pub.map_new_amg_msg
4062: ( p_old_message_code => 'PA_CREATE_CONTACTS_FAILED'
4063: ,p_msg_attribute => 'CHANGE'

Line 4280: pa_project_pvt.add_key_members(l_return_status

4276: i := l_key_members.next(i);
4277:
4278: END LOOP;
4279:
4280: pa_project_pvt.add_key_members(l_return_status
4281: ,l_project_in_rec.created_from_project_id
4282: ,l_project_id
4283: ,l_key_members
4284: );

Line 4384: pa_project_pvt.add_org_roles(l_return_status

4380: i := l_org_roles.next(i);
4381:
4382: END LOOP;
4383:
4384: pa_project_pvt.add_org_roles(l_return_status
4385: ,l_project_in_rec.created_from_project_id
4386: ,l_project_id
4387: ,l_org_roles
4388: );

Line 4415: pa_project_pvt.add_class_categories(l_return_status

4411: THEN
4412:
4413: --checking for overridability is done in the called procedure add_class_categories
4414:
4415: pa_project_pvt.add_class_categories(l_return_status
4416: ,l_project_in_rec.created_from_project_id
4417: ,l_project_id
4418: ,p_class_categories
4419: );

Line 4464: PA_PROJECT_PVT.get_structure_version(

4460: END IF;
4461: */
4462:
4463: --Project Connect 4.0
4464: PA_PROJECT_PVT.get_structure_version(
4465: p_project_id => l_project_id
4466: ,p_structure_versions_out => g_struc_out_tbl
4467: );
4468:

Line 4573: pa_project_pvt.validate_billing_info (

4569: p_tasks_out(i).return_status := FND_API.G_RET_STS_SUCCESS;
4570:
4571: l_task_in_rec := p_tasks_in(i);
4572:
4573: pa_project_pvt.validate_billing_info (
4574: p_project_id =>l_project_id, -- Added for Bug 5643876
4575: p_project_class_code =>l_project_type_rec.project_type_class_code,
4576: p_in_task_rec =>l_task_in_rec,
4577: p_return_status =>l_return_status

Line 4677: pa_project_pvt.add_task_round_one(l_return_status

4673: END IF;
4674:
4675: /*Code addition for bug 2982057 ends*/
4676:
4677: pa_project_pvt.add_task_round_one(l_return_status
4678: ,l_project_rec
4679: ,l_task_in_rec
4680: ,l_project_type_rec.project_type_class_code
4681: ,l_project_type_rec.service_type_code

Line 4715: pa_project_pvt.add_task_round_two(l_return_status

4711:
4712: --get the unique task ID for this task
4713: l_task_id := p_tasks_out(i).pa_task_id;
4714:
4715: pa_project_pvt.add_task_round_two(l_return_status
4716: ,l_project_rec
4717: ,l_task_id
4718: ,l_task_in_rec
4719: --project structures

Line 4964: pa_project_pvt.validate_data(

4960:
4961: END IF; --p_tasks_in.exists(i)
4962:
4963: -- Bug 5622539
4964: pa_project_pvt.validate_data(
4965: p_calling_context => 'CREATE_PROJECT',
4966: p_project_id => l_project_id,
4967: x_msg_count => l_msg_count,
4968: x_msg_data => l_msg_data,

Line 5087: /*PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_project_out.pa_project_id

5083: l_d_loop_count := p_tasks_in.first;
5084: WHILE l_d_loop_count IS NOT NULL LOOP
5085: l_task_in_rec := p_tasks_in(l_d_loop_count);
5086:
5087: /*PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_project_out.pa_project_id
5088: ,p_pm_task_reference => l_task_in_rec.pm_task_reference
5089: ,p_out_task_id => l_d_task_id
5090: ,p_return_status => l_return_status);*/
5091:

Line 5107: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id

5103: IF l_d_task_id IS NULL AND
5104: l_task_in_rec.pm_task_reference IS NOT NULL AND
5105: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5106: THEN
5107: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id
5108: ,p_pm_task_reference => l_task_in_rec.pm_task_reference
5109: ,p_structure_type => p_structure_in.structure_type
5110: ,p_out_task_id => l_d_task_id
5111: ,p_return_status => l_return_status);

Line 5893: --will be populated from project CC attributes in pa_project_pvt.add_task_round_one api

5889: and lookup_code = p_adj_on_std_inv;
5890:
5891:
5892: --Initializiing all the CC attributes to missing values so that if the new task is top task then values of these CC attibites
5893: --will be populated from project CC attributes in pa_project_pvt.add_task_round_one api
5894: l_allow_cross_charge_flag VARCHAR(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
5895: l_cc_process_labor_flag VARCHAR(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
5896: l_labor_tp_schedule_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5897: l_labor_tp_fixed_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

Line 6044: PA_PROJECT_PVT.Convert_pm_projref_to_id

6040:
6041: --Moved from below for bug 2471668
6042: -- get the project ID
6043:
6044: PA_PROJECT_PVT.Convert_pm_projref_to_id
6045: ( p_pm_project_reference => p_pm_project_reference
6046: , p_pa_project_id => p_pa_project_id
6047: , p_out_project_id => l_project_id
6048: , p_return_status => l_return_status

Line 6227: PA_PROJECT_PVT.Convert_pm_projref_to_id

6223: it is converted and l_project_id is used subsequently.
6224: --bug 2471668
6225: -- get the project ID
6226:
6227: PA_PROJECT_PVT.Convert_pm_projref_to_id
6228: ( p_pm_project_reference => p_pm_project_reference
6229: , p_pa_project_id => p_pa_project_id
6230: , p_out_project_id => l_project_id
6231: , p_return_status => l_return_status

Line 6418: IF pa_project_pvt.check_valid_dist_rule

6414: CLOSE cur_get_proj_billing_info;
6415:
6416: IF 'Y' = l_proj_top_task_inv_mth_flag
6417: AND p_invoice_method IS NOT NULL AND p_invoice_method <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
6418: IF pa_project_pvt.check_valid_dist_rule
6419: ( l_proj_type,
6420: l_proj_revenue_acc_method||'/'||p_invoice_method,
6421: l_proj_top_task_inv_mth_flag ) = 'N' THEN
6422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 6813: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

6809:
6810: --Begin change by rtarway for BUG 3661788, use Convert_pm_taskref_to_id_all to get task id instead of using l_task_ref_to_id_csr
6811: --OPEN l_task_ref_to_id_csr(l_project_id,p_pm_parent_task_reference);
6812: --FETCH l_task_ref_to_id_csr INTO l_ref_task_id;
6813: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
6814: (
6815: p_pa_project_id => l_project_id ,
6816: p_structure_type => l_structure_type,
6817: p_pm_task_reference => p_pm_parent_task_reference ,

Line 6983: pa_project_pvt.add_task_round_one(p_return_status => l_return_status

6979:
6980: --ROUND TRIP 1
6981:
6982:
6983: pa_project_pvt.add_task_round_one(p_return_status => l_return_status
6984: ,p_project_rec => l_project_rec
6985: ,p_task_rec => l_task_in_rec
6986: ,p_project_type_class_code => l_project_type_rec.project_type_class_code
6987: ,p_service_type_code => l_project_type_rec.service_type_code

Line 7016: pa_project_pvt.add_task_round_two(p_return_status => l_return_status

7012:
7013:
7014: --ROUND TRIP 2
7015:
7016: pa_project_pvt.add_task_round_two(p_return_status => l_return_status
7017: ,p_project_rec => l_project_rec
7018: ,p_task_id => l_task_id
7019: ,p_task_rec => l_task_in_rec
7020: --Project structures

Line 7108: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_pa_project_id

7104: END IF;
7105:
7106: -- FP-M Bug # 3301192 --add_task
7107: /*
7108: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_pa_project_id
7109: ,p_pm_task_reference => l_task_in_rec.pm_task_reference
7110: ,p_out_task_id => l_d_task_id
7111: ,p_return_status => l_return_status);
7112: */

Line 7122: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => p_pa_project_id

7118: THEN
7119:
7120: /* Start commenting out the following code for issue in bug # 3663166.
7121:
7122: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => p_pa_project_id
7123: ,p_pm_task_reference => l_task_in_rec.pm_task_reference
7124: ,p_out_task_id => l_d_task_id
7125: ,p_return_status => l_return_status);
7126:

Line 7722: PA_PROJECT_PVT.Convert_pm_projref_to_id

7718: --called from the private API. But I discussed with Sakthi and he is ok to ca ll this
7719: --twice once here and second time in private API. The idea is to make the adv anced security changes
7720: --only in public APIs.
7721:
7722: PA_PROJECT_PVT.Convert_pm_projref_to_id
7723: ( p_pm_project_reference => p_pm_project_reference
7724: , p_pa_project_id => p_pa_project_id
7725: , p_out_project_id => l_project_id
7726: , p_return_status => l_return_status

Line 7902: pa_project_pvt.delete_task1

7898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7899: END ;
7900: */
7901:
7902: pa_project_pvt.delete_task1
7903: ( p_api_version_number => p_api_version_number
7904: ,p_commit => FND_API.G_FALSE--bug 3766967
7905: ,p_init_msg_list => p_init_msg_list
7906: ,p_msg_count => p_msg_count

Line 11222: Pa_project_pvt.Convert_pm_projref_to_id (

11218: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11219: END IF;
11220:
11221:
11222: Pa_project_pvt.Convert_pm_projref_to_id (
11223: p_pm_project_reference => p_project_in.pm_project_reference,
11224: p_pa_project_id => p_project_in.pa_project_id,
11225: p_out_project_id => l_project_id,
11226: p_return_status => l_return_status );

Line 11298: Pa_project_pvt.Convert_pm_projref_to_id (

11294:
11295: /* Moving this code before doing security check for bug 2471668
11296: -- convert pm_project_reference to id
11297:
11298: Pa_project_pvt.Convert_pm_projref_to_id (
11299: p_pm_project_reference => p_project_in.pm_project_reference,
11300: p_pa_project_id => p_project_in.pa_project_id,
11301: p_out_project_id => l_project_id,
11302: p_return_status => l_return_status );

Line 11556: IF NOT pa_project_pvt.check_valid_message (l_err_stage)

11552: THEN
11553:
11554: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11555: THEN
11556: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
11557: THEN
11558: pa_interface_utils_pub.map_new_amg_msg
11559: ( p_old_message_code => 'PA_CANT_CHANGE_PROJ_NUM'
11560: ,p_msg_attribute => 'CHANGE'

Line 11815: IF pa_project_pvt.check_valid_org

11811: AND p_project_in.carrying_out_organization_id IS NOT NULL THEN
11812: IF p_project_in.carrying_out_organization_id <>
11813: l_project_rec.carrying_out_organization_id THEN
11814: -- check whether this is a valid organization
11815: IF pa_project_pvt.check_valid_org
11816: (p_project_in.carrying_out_organization_id) = 'N' THEN
11817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11818: THEN
11819: pa_interface_utils_pub.map_new_amg_msg

Line 11886: IF NOT pa_project_pvt.check_valid_message (l_err_stage) THEN

11882: ,X_err_stack => l_err_stack );
11883:
11884: IF l_err_code > 0 THEN
11885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11886: IF NOT pa_project_pvt.check_valid_message (l_err_stage) THEN
11887: pa_interface_utils_pub.map_new_amg_msg
11888: ( p_old_message_code => 'PA_PR_CANT_CHG_PROJ_TYPE'
11889: ,p_msg_attribute => 'CHANGE'
11890: ,p_resize_flag => 'N'

Line 12009: IF pa_project_pvt.check_valid_dist_rule

12005:
12006: THEN
12007:
12008: -- Verify whether the dist rule is a valid one
12009: IF pa_project_pvt.check_valid_dist_rule
12010: (l_project_rec.project_type,
12011: p_project_in.distribution_rule,
12012: p_project_in.enable_top_task_inv_mth_flag ) = 'N' --Bug 3279981
12013: THEN

Line 12044: IF NOT pa_project_pvt.check_valid_message (l_err_stage)

12040: THEN
12041:
12042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12043: THEN
12044: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
12045: THEN
12046: pa_interface_utils_pub.map_new_amg_msg
12047: ( p_old_message_code => 'PA_CANT_CHANGE_DIST_RULE'
12048: ,p_msg_attribute => 'CHANGE'

Line 12135: IF pa_project_pvt.check_valid_project_status

12131: AND p_project_in.project_status_code IS NOT NULL --NULL will be ignored
12132: THEN
12133: IF p_project_in.project_status_code <>
12134: l_project_rec.project_status_code THEN
12135: IF pa_project_pvt.check_valid_project_status
12136: (p_project_status => p_project_in.project_status_code ) = 'N'
12137: THEN
12138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12139: pa_interface_utils_pub.map_new_amg_msg

Line 12190: pa_project_pvt.check_start_end_date

12186: END IF;
12187:
12188: -- Bug 503976 Project Completion is set to default g_miss_date ... Ends
12189:
12190: pa_project_pvt.check_start_end_date
12191: (p_old_start_date => l_project_rec.start_date
12192: ,p_new_start_date => l_project_start_date
12193: ,p_old_end_date => l_project_rec.completion_date
12194: ,p_new_end_date => l_project_completion_date

Line 13433: pa_project_pvt.Check_Schedule_type

13429: /*Commenting till here for bug 2802984 */
13430:
13431: /* Code for the bug 2802984 starts*/
13432:
13433: pa_project_pvt.Check_Schedule_type
13434: (p_pa_task_id => '',
13435: p_pa_project_id => l_project_id,
13436: p_in_labor_sch_type => p_project_in.labor_sch_type,
13437: p_in_nl_sch_type => p_project_in.non_labor_sch_type,

Line 13455: pa_project_pvt.validate_schedule_values

13451: RAISE FND_API.G_EXC_ERROR;
13452: END IF;
13453:
13454:
13455: pa_project_pvt.validate_schedule_values
13456: (p_pa_project_id => l_project_id,
13457: p_pa_task_id => '',
13458: p_task_name => '',
13459: p_pm_task_reference => '',

Line 16927: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to

16923: END IF;
16924:
16925: ELSE --if task_id is given, check it's validity
16926: --pambu1('Check Task ID validity');
16927: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
16928: -- pa_project_pvt.convert_pm_taskref_to_id_all
16929: pa_project_pvt.convert_pm_taskref_to_id_all
16930: (p_pa_project_id => l_project_id
16931: ,p_structure_type => l_structure_type

Line 16928: -- pa_project_pvt.convert_pm_taskref_to_id_all

16924:
16925: ELSE --if task_id is given, check it's validity
16926: --pambu1('Check Task ID validity');
16927: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
16928: -- pa_project_pvt.convert_pm_taskref_to_id_all
16929: pa_project_pvt.convert_pm_taskref_to_id_all
16930: (p_pa_project_id => l_project_id
16931: ,p_structure_type => l_structure_type
16932: ,p_pa_task_id => p_tasks_in(i).pa_task_id

Line 16929: pa_project_pvt.convert_pm_taskref_to_id_all

16925: ELSE --if task_id is given, check it's validity
16926: --pambu1('Check Task ID validity');
16927: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
16928: -- pa_project_pvt.convert_pm_taskref_to_id_all
16929: pa_project_pvt.convert_pm_taskref_to_id_all
16930: (p_pa_project_id => l_project_id
16931: ,p_structure_type => l_structure_type
16932: ,p_pa_task_id => p_tasks_in(i).pa_task_id
16933: ,p_pm_task_reference => NULL

Line 17040: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to

17036: IF (p_tasks_in(i).pa_parent_task_id IS NOT NULL AND p_tasks_in(i).pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
17037: (p_tasks_in(i).pm_parent_task_reference IS NOT NULL
17038: AND p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17039: THEN
17040: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17041: -- pa_project_pvt.convert_pm_taskref_to_id_all
17042: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17043: ( p_pa_project_id => l_project_id
17044: , p_structure_type => l_structure_type

Line 17041: -- pa_project_pvt.convert_pm_taskref_to_id_all

17037: (p_tasks_in(i).pm_parent_task_reference IS NOT NULL
17038: AND p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17039: THEN
17040: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17041: -- pa_project_pvt.convert_pm_taskref_to_id_all
17042: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17043: ( p_pa_project_id => l_project_id
17044: , p_structure_type => l_structure_type
17045: , p_pa_task_id => p_tasks_in(i).pa_parent_task_id

Line 17042: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

17038: AND p_tasks_in(i).pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17039: THEN
17040: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17041: -- pa_project_pvt.convert_pm_taskref_to_id_all
17042: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17043: ( p_pa_project_id => l_project_id
17044: , p_structure_type => l_structure_type
17045: , p_pa_task_id => p_tasks_in(i).pa_parent_task_id
17046: , p_pm_task_reference => p_tasks_in(i).pm_parent_task_reference

Line 17071: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

17067:
17068: IF l_err_code <> 0
17069: THEN
17070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
17071: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
17072: THEN
17073: pa_interface_utils_pub.map_new_amg_msg
17074: ( p_old_message_code => 'PA_CHECK_ADD_SUBTASK_FAILED'
17075: ,p_msg_attribute => 'CHANGE'

Line 17111: PA_PROJECT_PVT.add_task_round_one

17107: else
17108: l_task_rec.long_task_name :=l_task_rec.long_task_name;
17109: end if;
17110: /* Code addition for bug 2982057 ends */
17111: PA_PROJECT_PVT.add_task_round_one
17112: (p_return_status => l_return_status,
17113: p_project_rec => l_project_rec,
17114: p_task_rec => l_task_rec,
17115: p_project_type_class_code => l_project_type_class_code,

Line 17168: ----dbms_output.put_line('calling pa_project_pvt.handle_task_number_changes l_task_id'||l_task_id);

17164: -- process the next task in the array
17165:
17166: --------------------------------------------------------------------------------
17167: l_proceed_with_update_flag := 'Y';
17168: ----dbms_output.put_line('calling pa_project_pvt.handle_task_number_changes l_task_id'||l_task_id);
17169: ----dbms_output.put_line('value of p_tasks_in(i).pa_task_number'||p_tasks_in(i).pa_task_number);
17170:
17171: pa_project_pvt.handle_task_number_change
17172: (p_project_id => l_project_id,

Line 17171: pa_project_pvt.handle_task_number_change

17167: l_proceed_with_update_flag := 'Y';
17168: ----dbms_output.put_line('calling pa_project_pvt.handle_task_number_changes l_task_id'||l_task_id);
17169: ----dbms_output.put_line('value of p_tasks_in(i).pa_task_number'||p_tasks_in(i).pa_task_number);
17170:
17171: pa_project_pvt.handle_task_number_change
17172: (p_project_id => l_project_id,
17173: p_task_id => l_task_id,
17174: p_array_cell_number => i,
17175: p_in_task_number => p_tasks_in(i).pa_task_number,

Line 17220: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to

17216: AND p_structure_in.structure_type = 'FINANCIAL'
17217:
17218: THEN
17219:
17220: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17221: -- pa_project_pvt.convert_pm_taskref_to_id_all
17222: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17223: ( p_pa_project_id => l_project_id
17224: , p_structure_type => l_structure_type

Line 17221: -- pa_project_pvt.convert_pm_taskref_to_id_all

17217:
17218: THEN
17219:
17220: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17221: -- pa_project_pvt.convert_pm_taskref_to_id_all
17222: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17223: ( p_pa_project_id => l_project_id
17224: , p_structure_type => l_structure_type
17225: , p_pa_task_id => p_tasks_in(i).pa_parent_task_id

Line 17222: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

17218: THEN
17219:
17220: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17221: -- pa_project_pvt.convert_pm_taskref_to_id_all
17222: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17223: ( p_pa_project_id => l_project_id
17224: , p_structure_type => l_structure_type
17225: , p_pa_task_id => p_tasks_in(i).pa_parent_task_id
17226: , p_pm_task_reference => p_tasks_in(i).pm_parent_task_reference

Line 17847: PA_PROJECT_PVT.add_task_round_one

17843: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
17844: p_msg_name => 'PA_WBS_CANT_CHANGE');
17845: RAISE FND_API.G_EXC_ERROR;
17846: END IF;
17847: PA_PROJECT_PVT.add_task_round_one
17848: (p_return_status => l_return_status,
17849: p_project_rec => l_project_rec,
17850: p_task_rec => l_task_rec,
17851: p_project_type_class_code => l_project_type_class_code,

Line 17856: pa_debug.g_err_stage := 'After PA_PROJECT_PVT.add_task_round_one...l_return_status=||l_return_status';

17852: p_service_type_code => l_service_type_code,
17853: p_task_id => l_task_id);
17854:
17855: IF l_debug_mode = 'Y' THEN
17856: pa_debug.g_err_stage := 'After PA_PROJECT_PVT.add_task_round_one...l_return_status=||l_return_status';
17857: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
17858: END IF;
17859:
17860:

Line 17895: 3. If the pass_entire_struct param is 'N', then call PA_PROJECT_PVT.add_task_round_two with

17891: -- Change required here for bug 3548473 : 3627124 (modifying the changes done for bug 2931183) :
17892: /*
17893: 1. Check if the user wants to pass the entire struct or single tasks.
17894: 2. If pass_entire_struct param is 'Y', let the prog flow be as it is now.
17895: 3. If the pass_entire_struct param is 'N', then call PA_PROJECT_PVT.add_task_round_two with
17896: p_create_task_structure => 'Y' parameter.
17897: */
17898: /* The code below was added for Bug 3841742 : 3857419 .This is to ensure that add_task_round_two is called
17899: for all the tasks that have inserted through add_task_round_one for updating wbs_level, top_task_id and

Line 17907: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to

17903: IF (l_task_rec.pa_parent_task_id IS NOT NULL AND l_task_rec.pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
17904: (l_task_rec.pm_parent_task_reference IS NOT NULL
17905: AND l_task_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17906: THEN
17907: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17908: -- pa_project_pvt.convert_pm_taskref_to_id_all
17909: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17910: ( p_pa_project_id => l_project_id
17911: , p_structure_type => l_structure_type

Line 17908: -- pa_project_pvt.convert_pm_taskref_to_id_all

17904: (l_task_rec.pm_parent_task_reference IS NOT NULL
17905: AND l_task_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17906: THEN
17907: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17908: -- pa_project_pvt.convert_pm_taskref_to_id_all
17909: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17910: ( p_pa_project_id => l_project_id
17911: , p_structure_type => l_structure_type
17912: , p_pa_task_id => l_task_rec.pa_parent_task_id

Line 17909: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

17905: AND l_task_rec.pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
17906: THEN
17907: -- Bug 5262740 Changed pa_project_pvt.convert_pm_taskref_to_id call to
17908: -- pa_project_pvt.convert_pm_taskref_to_id_all
17909: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
17910: ( p_pa_project_id => l_project_id
17911: , p_structure_type => l_structure_type
17912: , p_pa_task_id => l_task_rec.pa_parent_task_id
17913: , p_pm_task_reference => l_task_rec.pm_parent_task_reference

Line 17945: PA_PROJECT_PVT.add_task_round_two

17941: WHERE task_id = l_task_id_tbl(i).pa_task_id;
17942: END IF;
17943:
17944:
17945: PA_PROJECT_PVT.add_task_round_two
17946: (p_return_status => l_return_status,
17947: p_project_rec => l_project_rec,
17948: p_task_id => l_task_id_tbl(i).pa_task_id,
17949: p_task_rec => l_task_rec,

Line 17960: pa_debug.g_err_stage := 'After calling PA_PROJECT_PVT.add_task_round_two l_return_status='||l_return_status;

17956: --project structure
17957: ); -- modified p_update_task_structure value for bug 3548473 : 3627124
17958:
17959: IF l_debug_mode = 'Y' THEN
17960: pa_debug.g_err_stage := 'After calling PA_PROJECT_PVT.add_task_round_two l_return_status='||l_return_status;
17961: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
17962: END IF;
17963:
17964:

Line 18603: PA_PROJECT_PVT.get_structure_version(

18599:
18600: IF l_structure_version_id IS NULL OR l_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18601: THEN
18602:
18603: PA_PROJECT_PVT.get_structure_version(
18604: p_project_id => l_project_id
18605: ,p_structure_versions_out => g_struc_out_tbl
18606: );
18607:

Line 18761: Pa_project_pvt.check_parent_child_task_dates

18757:
18758: -- Call the api to check the task dates
18759: --9839807 - added clause to skip check for MSP since MSP already validates dates
18760: If G_ParChildTsk_chks_deferred = 'Y' and p_pm_product_code <> 'MSPROJECT' THEN
18761: Pa_project_pvt.check_parent_child_task_dates
18762: (p_project_id => l_project_id,
18763: p_return_status => l_return_status );
18764:
18765: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 18864: pa_project_pvt.check_for_one_manager

18860: END IF;
18861: END IF;
18862: END IF;
18863:
18864: pa_project_pvt.check_for_one_manager
18865: (l_project_id,
18866: p_key_members(i).person_id,
18867: p_key_members,
18868: p_key_members(i).start_date,

Line 19046: PA_PROJECT_PVT.add_key_members (

19042: RAISE FND_API.G_EXC_ERROR;
19043: END IF;
19044:
19045: IF l_key_members_tbl.COUNT > 0 THEN
19046: PA_PROJECT_PVT.add_key_members (
19047: p_return_status =>l_return_status,
19048: p_pa_source_template_id =>l_project_rec.created_from_project_id,
19049: p_project_id =>l_project_id,
19050: p_key_members =>l_key_members_tbl );

Line 19260: PA_PROJECT_PVT.add_org_roles (

19256: RAISE FND_API.G_EXC_ERROR;
19257: END IF;
19258:
19259: IF l_org_roles_tbl.COUNT > 0 THEN
19260: PA_PROJECT_PVT.add_org_roles (
19261: p_return_status =>l_return_status,
19262: p_pa_source_template_id =>l_project_rec.created_from_project_id,
19263: p_project_id =>l_project_id,
19264: p_org_roles =>l_org_roles_tbl );

Line 19431: PA_PROJECT_PVT.add_class_categories ( p_return_status =>l_return_status

19427:
19428: IF l_class_categories_tbl.exists(i)
19429: THEN
19430:
19431: PA_PROJECT_PVT.add_class_categories ( p_return_status =>l_return_status
19432: , p_pa_source_template_id =>l_project_rec.created_from_project_id
19433: , p_project_id =>l_project_id
19434: , p_class_categories =>l_class_categories_tbl );
19435:

Line 19687: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

19683:
19684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
19685: THEN
19686:
19687: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
19688: THEN
19689: pa_interface_utils_pub.map_new_amg_msg
19690: ( p_old_message_code => 'PA_GET_CUSTOMER_INFO_FAILED'
19691: ,p_msg_attribute => 'CHANGE'

Line 20339: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

20335:
20336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20337: THEN
20338:
20339: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
20340: THEN
20341: pa_interface_utils_pub.map_new_amg_msg
20342: ( p_old_message_code => 'PA_GET_CUSTOMER_INFO_FAILED'
20343: ,p_msg_attribute => 'CHANGE'

Line 20611: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

20607:
20608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20609: THEN
20610:
20611: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
20612: THEN
20613: pa_interface_utils_pub.map_new_amg_msg
20614: ( p_old_message_code => 'PA_CREATE_CONTACTS_FAILED'
20615: ,p_msg_attribute => 'CHANGE'

Line 20929: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

20925:
20926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20927: THEN
20928:
20929: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
20930: THEN
20931: pa_interface_utils_pub.map_new_amg_msg
20932: ( p_old_message_code => 'PA_GET_CUSTOMER_INFO_FAILED'
20933: ,p_msg_attribute => 'CHANGE'

Line 21208: IF NOT pa_project_pvt.check_valid_message(l_err_stage)

21204:
21205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
21206: THEN
21207:
21208: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
21209: THEN
21210: pa_interface_utils_pub.map_new_amg_msg
21211: ( p_old_message_code => 'PA_CREATE_CONTACTS_FAILED'
21212: ,p_msg_attribute => 'CHANGE'

Line 21301: pa_project_pvt.validate_data(

21297: END IF;
21298: END IF;
21299:
21300: -- Bug 5622539
21301: pa_project_pvt.validate_data(
21302: p_calling_context => 'UPDATE_PROJECT',
21303: p_project_id => l_project_id,
21304: x_msg_count => x_msg_count,
21305: x_msg_data => x_msg_data,

Line 21816: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id

21812: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
21813: IF l_d_task_id IS NULL AND l_task_in_rec.pm_task_reference IS NOT NULL AND
21814: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21815: THEN
21816: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id
21817: ,p_pm_task_reference => l_task_in_rec.pm_task_reference
21818: ,p_structure_type => l_structure_type
21819: ,p_out_task_id => l_d_task_id
21820: ,p_return_status => l_return_status);

Line 23078: PA_PROJECT_PVT.Convert_pm_projref_to_id

23074:
23075: END IF;
23076: -- rbruno bug 12660639 end
23077: --bug 3880482
23078: PA_PROJECT_PVT.Convert_pm_projref_to_id
23079: ( p_pm_project_reference => p_pm_project_reference
23080: , p_pa_project_id => p_pa_project_id
23081: , p_out_project_id => l_project_id
23082: , p_return_status => l_return_status

Line 23104: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

23100: if (p_pa_task_id is not null and p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
23101: then l_pa_task_id := p_pa_task_id;
23102: end if;
23103: --Also Validate task id
23104: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
23105: (
23106: p_pa_project_id => l_project_id ,
23107: p_structure_type => l_structure_type,
23108: p_pa_task_id => p_pa_task_id ,

Line 23262: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

23258:
23259: --Begin change by rtarway for BUG 3661788, use Convert_pm_taskref_to_id_all to get task id instead of using l_task_ref_to_id_csr
23260: --OPEN l_task_ref_to_id_csr(l_project_id,p_pm_parent_task_reference);
23261: --FETCH l_task_ref_to_id_csr INTO l_ref_task_id;
23262: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
23263: (
23264: p_pa_project_id => l_project_id ,
23265: p_structure_type => l_structure_type, --Bug#3747312 p_structure_type,
23266: p_pm_task_reference => p_pm_parent_task_reference ,

Line 23313: IF pa_project_pvt.check_valid_dist_rule

23309: IF 'Y' = l_proj_top_task_inv_mth_flag THEN
23310: IF ( p_invoice_method IS NOT NULL AND p_invoice_method <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
23311: --changed p_pa_task_id to l_pa_task_id, 3919800, rtarway
23312: AND PA_BILLING_CORE.Update_Top_Task_Invoice_Method( l_project_id, l_pa_task_id ) = 'Y' THEN
23313: IF pa_project_pvt.check_valid_dist_rule
23314: ( l_proj_type,
23315: l_proj_revenue_acc_method||'/'||p_invoice_method,
23316: l_proj_top_task_inv_mth_flag ) = 'N' THEN
23317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 23744: PA_PROJECT_PVT.Update_One_Task (

23740:
23741: --project structures
23742: ----dbms_output.put_line('value OF p_task_number BEFORE UPDATE_ONE_TASK'||p_task_number);
23743:
23744: PA_PROJECT_PVT.Update_One_Task (
23745: p_api_version_number => p_api_version_number,
23746: p_commit => FND_API.G_FALSE,
23747: p_msg_count => p_msg_count,
23748: p_msg_data => p_msg_data,

Line 24164: PA_PROJECT_PVT.Update_One_Task

24160:
24161: --In case of Shared Structures, we do not need to update dff attributes in pa_tasks, instead
24162: --dff fields of pa_proj_elem_ver_schedule are updated
24163:
24164: PA_PROJECT_PVT.Update_One_Task
24165: (
24166: p_api_version_number => p_api_version_number,
24167: p_commit => FND_API.G_FALSE,
24168: p_msg_count => p_msg_count,

Line 24569: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_pa_project_id

24565: -- PA L Changes 3010538
24566:
24567: -- FP-M Bug # 3301192 update task
24568: /*
24569: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID(p_pa_project_id => p_pa_project_id
24570: ,p_pm_task_reference => p_pm_task_reference
24571: ,p_out_task_id => l_d_task_id
24572: ,p_return_status => l_return_status);
24573: */

Line 24579: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id --Bug#3747312 p_pa_project_id

24575: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN --Bug#3747312
24576:
24577: IF l_d_task_id IS NULL AND p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
24578: THEN
24579: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id --Bug#3747312 p_pa_project_id
24580: , p_structure_type => l_structure_type -- Bug 10052686
24581: ,p_pm_task_reference => p_pm_task_reference
24582: ,p_out_task_id => l_d_task_id
24583: ,p_return_status => l_return_status);

Line 24912: PA_PROJECT_PVT.Convert_pm_projref_to_id

24908: --called from the private API. But I discussed with Sakthi and he is ok to call this
24909: --twice once here and second time in private API. The idea is to make the advanced security changes
24910: --only in public APIs.
24911:
24912: PA_PROJECT_PVT.Convert_pm_projref_to_id
24913: ( p_pm_project_reference => p_pm_project_reference
24914: , p_pa_project_id => p_pa_project_id
24915: , p_out_project_id => l_project_id
24916: , p_return_status => l_return_status

Line 24930: pa_project_pvt.delete_project1

24926:
24927: PA_INTERFACE_UTILS_PUB.G_PROJECt_ID := l_project_id; --bug 2471668 ( in the project context )
24928: --end of bug 2471668
24929:
24930: pa_project_pvt.delete_project1
24931: (p_api_version_number => p_api_version_number
24932: ,p_commit => p_commit -- added for bug#16386039 --FND_API.G_FALSE--bug 3766967
24933: ,p_init_msg_list => p_init_msg_list
24934: ,p_msg_count => p_msg_count

Line 25638: pa_project_pvt.approve_project1

25634:
25635: -- 4537865 : Initialize return status to success
25636: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25637:
25638: pa_project_pvt.approve_project1
25639: ( p_api_version_number => p_api_version_number
25640: , p_commit => FND_API.G_FALSE--bug 3766967
25641: , p_init_msg_list => p_init_msg_list
25642: , p_msg_count => p_msg_count

Line 29139: PA_PROJECT_PVT.Convert_pm_projref_to_id

29135: END IF;
29136:
29137: /* Converting project_reference to project_id */
29138:
29139: PA_PROJECT_PVT.Convert_pm_projref_to_id
29140: (p_pm_project_reference => p_pm_project_reference
29141: , p_pa_project_id => p_pa_project_id
29142: , p_out_project_id => l_project_id
29143: , p_return_status => l_return_status);

Line 30226: PA_PROJECT_PVT.Convert_pm_projref_to_id (

30222: END IF;
30223:
30224: -- validate the input parameters.
30225: -- Get the task and Project details based on source reference passed
30226: PA_PROJECT_PVT.Convert_pm_projref_to_id (
30227: p_pm_project_reference => p_proj_source_reference
30228: , p_pa_project_id => p_project_id
30229: , p_out_project_id => l_project_id
30230: , p_return_status => x_return_status

Line 30244: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

30240: RAISE FND_API.G_EXC_ERROR;
30241: END IF;
30242:
30243: IF ( l_task_id IS NOT NULL OR l_task_source_reference IS NOT NULL ) THEN
30244: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
30245: p_pa_project_id => l_project_id
30246: , p_structure_type => 'WORKPLAN'
30247: , p_pa_task_id => p_task_id
30248: , p_pm_task_reference => p_task_source_reference

Line 30863: PA_PROJECT_PVT.Convert_pm_projref_to_id (

30859: RAISE FND_API.G_EXC_ERROR;
30860: END IF;
30861:
30862: -- validate the input parameters.
30863: PA_PROJECT_PVT.Convert_pm_projref_to_id (
30864: p_pm_project_reference => p_pm_proj_reference -- 3729250 , earlier was passed as null
30865: , p_pa_project_id => p_project_id
30866: , p_out_project_id => l_project_id
30867: , p_return_status => x_return_status

Line 30899: -- PA_PROJECT_PVT.Convert_pm_taskref_to_id_all should only be called if either p_financial_task_id or

30895: RAISE FND_API.G_EXC_ERROR;
30896: END IF;
30897:
30898: -- 3729250, Validate Financial Task Reference / ID
30899: -- PA_PROJECT_PVT.Convert_pm_taskref_to_id_all should only be called if either p_financial_task_id or
30900: -- p_financial_task_reference is passed
30901:
30902: IF ( ( p_financial_task_id IS NOT NULL AND p_financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
30903: ( p_financial_task_reference IS NOT NULL AND p_financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) ) THEN

Line 30905: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

30901:
30902: IF ( ( p_financial_task_id IS NOT NULL AND p_financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
30903: ( p_financial_task_reference IS NOT NULL AND p_financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) ) THEN
30904:
30905: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
30906: p_pa_project_id => l_project_id
30907: , p_structure_type => 'FINANCIAL'
30908: , p_pa_task_id => p_financial_task_id
30909: , p_pm_task_reference => p_financial_task_reference

Line 31386: PA_PROJECT_PVT.Convert_pm_projref_to_id (

31382: END IF;
31383:
31384: -- validate the input parameters.
31385: -- Get the task and Project details based on source reference passed
31386: PA_PROJECT_PVT.Convert_pm_projref_to_id (
31387: p_pm_project_reference => p_proj_source_reference
31388: , p_pa_project_id => p_project_id
31389: , p_out_project_id => l_project_id
31390: , p_return_status => x_return_status

Line 31407: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

31403: -- 3749447 Changed from p_task_id to l_task_id in if conditon
31404: -- also did the same change in below api's parameter passing
31405:
31406: IF ( l_task_id IS NOT NULL OR l_task_source_reference IS NOT NULL ) THEN
31407: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
31408: p_pa_project_id => l_project_id
31409: , p_structure_type => 'WORKPLAN'
31410: , p_pa_task_id => l_task_id
31411: , p_pm_task_reference => l_task_source_reference

Line 31942: PA_PROJECT_PVT.Convert_pm_projref_to_id (

31938: END IF;
31939:
31940: -- validate the input parameters.
31941: -- Validate Project reference/id
31942: PA_PROJECT_PVT.Convert_pm_projref_to_id (
31943: p_pm_project_reference => p_pm_proj_reference -- 3729250, earlier was passed as null
31944: , p_pa_project_id => p_project_id
31945: , p_out_project_id => l_project_id
31946: , p_return_status => x_return_status

Line 31998: -- PA_PROJECT_PVT.Convert_pm_taskref_to_id_all should only be called if either p_financial_task_id or

31994: RAISE FND_API.G_EXC_ERROR;
31995: END IF;
31996:
31997: -- 3729250, Validate Financial Task Reference / ID
31998: -- PA_PROJECT_PVT.Convert_pm_taskref_to_id_all should only be called if either p_financial_task_id or
31999: -- p_financial_task_reference is passed
32000:
32001: IF ( ( p_financial_task_id IS NOT NULL AND p_financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
32002: ( p_financial_task_reference IS NOT NULL AND p_financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) ) THEN

Line 32003: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

31999: -- p_financial_task_reference is passed
32000:
32001: IF ( ( p_financial_task_id IS NOT NULL AND p_financial_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
32002: ( p_financial_task_reference IS NOT NULL AND p_financial_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) ) THEN
32003: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
32004: p_pa_project_id => l_project_id
32005: , p_structure_type => 'FINANCIAL'
32006: , p_pa_task_id => p_financial_task_id
32007: , p_pm_task_reference => p_financial_task_reference

Line 32288: PA_PROJECT_PVT.Convert_pm_projref_to_id (

32284: END IF;
32285:
32286: -- validate the input parameters.
32287: -- Validate Project Reference / ID
32288: PA_PROJECT_PVT.Convert_pm_projref_to_id (
32289: p_pm_project_reference => p_pm_project_reference
32290: , p_pa_project_id => p_project_id
32291: , p_out_project_id => l_project_id
32292: , p_return_status => x_return_status

Line 32561: PA_PROJECT_PVT.Convert_pm_projref_to_id (

32557: END IF;
32558:
32559: -- validate the input parameters.
32560: -- Validate Project Reference / ID
32561: PA_PROJECT_PVT.Convert_pm_projref_to_id (
32562: p_pm_project_reference => p_pm_project_reference
32563: , p_pa_project_id => p_project_id
32564: , p_out_project_id => l_project_id
32565: , p_return_status => x_return_status

Line 32859: PA_PROJECT_PVT.Convert_pm_projref_to_id (

32855: END IF;
32856:
32857: -- validate the input parameters.
32858: -- Validate Project Reference / ID
32859: PA_PROJECT_PVT.Convert_pm_projref_to_id (
32860: p_pm_project_reference => p_pm_project_reference
32861: , p_pa_project_id => p_project_id
32862: , p_out_project_id => l_project_id
32863: , p_return_status => x_return_status

Line 32901: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

32897: l_task_reference := p_task_reference;
32898: END IF;
32899:
32900: IF ( p_task_id IS NOT NULL OR l_task_reference IS NOT NULL ) THEN
32901: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
32902: p_pa_project_id => l_project_id
32903: , p_structure_type => 'WORKPLAN'
32904: , p_pa_task_id => p_task_id
32905: , p_pm_task_reference => p_task_reference

Line 33148: PA_PROJECT_PVT.Convert_pm_projref_to_id (

33144: END IF;
33145:
33146: -- validate the input parameters.
33147: -- Validate Project Reference / ID
33148: PA_PROJECT_PVT.Convert_pm_projref_to_id (
33149: p_pm_project_reference => p_pm_project_reference -- 3729250, earlier null was passed
33150: , p_pa_project_id => p_project_id
33151: , p_out_project_id => l_project_id
33152: , p_return_status => x_return_status

Line 33177: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

33173: RAISE FND_API.G_EXC_ERROR;
33174: END IF;
33175:
33176: -- Validate Task Reference / ID
33177: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
33178: p_pa_project_id => l_project_id
33179: , p_structure_type => 'WORKPLAN'
33180: , p_pa_task_id => p_task_id
33181: , p_pm_task_reference => p_pm_task_reference -- 3729250, earlier null was passed

Line 33435: PA_PROJECT_PVT.Convert_pm_projref_to_id (

33431: END IF;
33432:
33433: -- validate the input parameters.
33434: -- Validate Project Reference / ID
33435: PA_PROJECT_PVT.Convert_pm_projref_to_id (
33436: p_pm_project_reference => p_pm_project_reference -- 3729250, earlier was passed as null
33437: , p_pa_project_id => p_project_id
33438: , p_out_project_id => l_project_id
33439: , p_return_status => x_return_status

Line 33718: PA_PROJECT_PVT.Convert_pm_projref_to_id (

33714: END IF;
33715:
33716: -- validate the input parameters.
33717: -- Validate Project Reference / ID
33718: PA_PROJECT_PVT.Convert_pm_projref_to_id (
33719: p_pm_project_reference => p_pm_project_reference -- 3729250 , earlier null was passed
33720: , p_pa_project_id => p_project_id
33721: , p_out_project_id => l_project_id
33722: , p_return_status => x_return_status

Line 34044: PA_PROJECT_PVT.Convert_pm_projref_to_id (

34040: ( p_proj_source_reference IS NOT NULL AND p_proj_source_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
34041: )
34042: THEN
34043:
34044: PA_PROJECT_PVT.Convert_pm_projref_to_id (
34045: p_pm_project_reference => p_proj_source_reference
34046: , p_pa_project_id => p_project_id
34047: , p_out_project_id => l_project_id
34048: , p_return_status => x_return_status

Line 34072: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all(

34068: (p_pm_wp_task_reference IS NOT NULL AND p_pm_wp_task_reference <>PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34069: )
34070: THEN
34071: --get the task id from task reference
34072: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all(
34073: p_pa_project_id => l_project_id
34074: ,p_structure_type => 'WORKPLAN'
34075: ,p_pm_task_reference => p_pm_wp_task_reference
34076: ,p_out_task_id => l_wp_task_id

Line 34097: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all(

34093: (p_pm_fp_task_reference IS NOT NULL AND p_pm_fp_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34094: )
34095: THEN
34096: --get the task id from task reference
34097: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all(
34098: p_pa_project_id => l_project_id
34099: ,p_structure_type => 'FINANCIAL'
34100: ,p_pm_task_reference => p_pm_fp_task_reference
34101: ,p_out_task_id => l_fp_task_id

Line 34402: PA_PROJECT_PVT.Convert_pm_projref_to_id (

34398: p_project_id IS NULL
34399: AND ( p_proj_source_reference IS NOT NULL AND p_proj_source_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
34400: )
34401: THEN
34402: PA_PROJECT_PVT.Convert_pm_projref_to_id (
34403: p_pm_project_reference => p_proj_source_reference
34404: , p_pa_project_id => p_project_id
34405: , p_out_project_id => l_project_id
34406: , p_return_status => x_return_status

Line 34428: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

34424: AND
34425: (p_wkp_task_reference IS NOT NULL AND p_wkp_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34426: )
34427: THEN
34428: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
34429: p_pa_project_id => l_project_id
34430: , p_structure_type => 'WORKPLAN'
34431: , p_pm_task_reference => p_wkp_task_reference
34432: , p_out_task_id => l_wkp_task_id

Line 34453: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

34449: AND
34450: l_mapped_task_reference IS NOT NULL
34451: )
34452: THEN
34453: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
34454: p_pa_project_id => l_project_id
34455: , p_structure_type => 'FINANCIAL'
34456: , p_pm_task_reference => p_mapped_task_reference
34457: , p_out_task_id => l_mapped_task_id

Line 34753: PA_PROJECT_PVT.Convert_pm_projref_to_id (

34749: AND
34750: ( p_proj_source_reference IS NOT NULL AND p_proj_source_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
34751: )
34752: THEN
34753: PA_PROJECT_PVT.Convert_pm_projref_to_id (
34754: p_pm_project_reference => p_proj_source_reference
34755: , p_pa_project_id => p_project_id
34756: , p_out_project_id => l_project_id
34757: , p_return_status => x_return_status

Line 34777: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

34773: AND
34774: (p_wkp_task_reference IS NOT NULL AND p_wkp_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34775: )
34776: THEN
34777: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
34778: p_pa_project_id => l_project_id
34779: , p_structure_type => 'WORKPLAN'
34780: , p_pm_task_reference => p_wkp_task_reference
34781: , p_out_task_id => l_wkp_task_id

Line 34802: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (

34798: AND
34799: (l_mapped_task_reference IS NOT NULL AND l_mapped_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34800: )
34801: THEN
34802: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all (
34803: p_pa_project_id => l_project_id
34804: , p_structure_type => 'FINANCIAL'
34805: , p_pm_task_reference => p_mapped_task_reference
34806: , p_out_task_id => l_mapped_task_id

Line 35029: PA_PROJECT_PVT.Convert_pm_projref_to_id (

35025:
35026:
35027: -- Get the task and Project details based on source reference passed
35028: IF (p_project_id IS NULL AND p_proj_source_reference IS NOT NULL ) THEN
35029: PA_PROJECT_PVT.Convert_pm_projref_to_id (
35030: p_pm_project_reference => p_proj_source_reference
35031: , p_pa_project_id => p_project_id
35032: , p_out_project_id => l_project_id
35033: , p_return_status => x_return_status

Line 35183: PA_PROJECT_PVT.Convert_pm_projref_to_id

35179: FND_MSG_PUB.Initialize;
35180: END IF;
35181:
35182: --get project id
35183: PA_PROJECT_PVT.Convert_pm_projref_to_id
35184: ( p_pm_project_reference => p_pm_project_reference
35185: , p_pa_project_id => p_pa_project_id
35186: , p_out_project_id => l_project_id
35187: , p_return_status => l_return_status

Line 35442: PA_PROJECT_PVT.Convert_pm_projref_to_id

35438: FND_MSG_PUB.Initialize;
35439: END IF;
35440:
35441: --get project id
35442: PA_PROJECT_PVT.Convert_pm_projref_to_id
35443: ( p_pm_project_reference => p_pm_project_reference
35444: , p_pa_project_id => p_pa_project_id
35445: , p_out_project_id => l_project_id
35446: , p_return_status => l_return_status

Line 35703: PA_PROJECT_PVT.Convert_pm_projref_to_id

35699: FND_MSG_PUB.Initialize;
35700: END IF;
35701:
35702: --get project id
35703: PA_PROJECT_PVT.Convert_pm_projref_to_id
35704: ( p_pm_project_reference => p_pm_project_reference
35705: , p_pa_project_id => p_pa_project_id
35706: , p_out_project_id => l_project_id
35707: , p_return_status => l_return_status

Line 36054: PA_PROJECT_PVT.Convert_pm_projref_to_id

36050: l_pub_ver_exists :='N' ;
36051:
36052: -- Convert project reference to id.
36053:
36054: PA_PROJECT_PVT.Convert_pm_projref_to_id
36055: (p_pm_project_reference => p_pm_project_reference
36056: , p_pa_project_id => p_project_id
36057: , p_out_project_id => l_project_id
36058: , p_return_status => l_return_status);

Line 36093: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all

36089: OR nvl(l_derive,'N') = 'Y'
36090: THEN
36091: -- Convert task reference to id.
36092:
36093: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
36094: (p_pa_project_id => l_project_id
36095: , p_pa_task_id => p_task_id
36096: , p_pm_task_reference => p_pm_task_reference
36097: , p_out_task_id => l_task_id

Line 36437: PA_PROJECT_PVT.Convert_pm_projref_to_id

36433: l_project_id := p_pa_project_id;
36434:
36435: ELSE
36436:
36437: PA_PROJECT_PVT.Convert_pm_projref_to_id
36438: ( p_pm_project_reference => p_pm_project_reference
36439: , p_pa_project_id => p_pa_project_id
36440: , p_out_project_id => l_project_id
36441: , p_return_status => l_return_status

Line 36867: PA_PROJECT_PVT.Convert_pm_projref_to_id

36863: -- Initialize the return status
36864: x_return_status := FND_API.G_RET_STS_SUCCESS;
36865:
36866: -- Convert project reference to id.
36867: PA_PROJECT_PVT.Convert_pm_projref_to_id
36868: (p_pm_project_reference => p_pm_project_reference
36869: , p_pa_project_id => p_project_id
36870: , p_out_project_id => l_project_id
36871: , p_return_status => l_return_status);

Line 37169: PA_PROJECT_PVT.Convert_pm_projref_to_id

37165: or (p_program_links_tbl(l_count).task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) then
37166:
37167: -- Convert parent project reference to id.
37168: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37169: PA_PROJECT_PVT.Convert_pm_projref_to_id
37170: (p_pm_project_reference => p_program_links_tbl(l_count).pm_parent_project_reference
37171: , p_pa_project_id => p_program_links_tbl(l_count).parent_project_id
37172: , p_out_project_id => l_parent_project_id
37173: , p_return_status => l_return_status);

Line 37185: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

37181: end if;
37182:
37183: -- Convert task reference to id.
37184: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37185: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
37186: (p_pa_project_id => l_parent_project_id
37187: , p_pm_task_reference => p_program_links_tbl(l_count).pm_task_reference
37188: , p_pa_task_id => p_program_links_tbl(l_count).task_id
37189: , p_structure_type => p_program_links_tbl(l_count).structure_type

Line 37233: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

37229: end if;
37230:
37231: -- Validate the task id and project id of the task version id.
37232: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37233: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
37234: (p_pa_project_id => l_parent_project_id
37235: , p_pa_task_id => l_task_id
37236: , p_structure_type => p_program_links_tbl(l_count).structure_type
37237: , p_out_task_id => l_task_id_out

Line 37768: PA_PROJECT_PVT.Convert_pm_projref_to_id

37764: or (p_program_links_tbl(l_count).task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) then
37765:
37766: -- Convert parent project reference to id.
37767: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37768: PA_PROJECT_PVT.Convert_pm_projref_to_id
37769: (p_pm_project_reference => p_program_links_tbl(l_count).pm_parent_project_reference
37770: , p_pa_project_id => p_program_links_tbl(l_count).parent_project_id
37771: , p_out_project_id => l_parent_project_id
37772: , p_return_status => l_return_status);

Line 37783: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

37779: end if;
37780:
37781: -- Convert task reference to id
37782: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37783: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
37784: (p_pa_project_id => l_parent_project_id
37785: , p_pm_task_reference => p_program_links_tbl(l_count).pm_task_reference
37786: , p_pa_task_id => p_program_links_tbl(l_count).task_id
37787: , p_structure_type => p_program_links_tbl(l_count).structure_type

Line 37831: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

37827: end if;
37828:
37829: -- Validate the task id and project id of the task version id.
37830: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37831: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
37832: (p_pa_project_id => l_parent_project_id
37833: , p_pa_task_id => l_task_id
37834: , p_structure_type => p_program_links_tbl(l_count).structure_type
37835: , p_out_task_id => l_task_id_out

Line 38309: PA_PROJECT_PVT.Convert_pm_projref_to_id

38305: if ((p_task_version_id is null)
38306: or (p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) then
38307:
38308: -- Convert parent project reference to id.
38309: PA_PROJECT_PVT.Convert_pm_projref_to_id
38310: (p_pm_project_reference => p_pm_parent_project_reference
38311: , p_pa_project_id => p_parent_project_id
38312: , p_out_project_id => l_parent_project_id
38313: , p_return_status => l_return_status);

Line 38322: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

38318: raise FND_API.G_EXC_ERROR;
38319: end if;
38320:
38321: -- Convert task reference to id
38322: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
38323: (p_pa_project_id => l_parent_project_id
38324: , p_pm_task_reference => p_pm_task_reference
38325: , p_pa_task_id => p_task_id
38326: , p_structure_type => p_structure_type

Line 38360: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL

38356: end if;
38357: close l_cur_project_id2;
38358:
38359: -- Validate the task id and project id of the task version id.
38360: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_ALL
38361: (p_pa_project_id => l_parent_project_id
38362: , p_pa_task_id => l_task_id
38363: , p_structure_type => p_structure_type
38364: , p_out_task_id => l_task_id_out

Line 38809: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'UPDATE',l_msg_data,l_return_status);

38805: -- Set the G_ROLLUP_FLAG based on profile options
38806: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
38807: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
38808: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38809: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'UPDATE',l_msg_data,l_return_status);
38810: IF l_return_status <> 'S'
38811: THEN
38812: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
38813: p_msg_name =>'PA_CANT_USE_LITE_API' );

Line 38816: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,l_structure_version_id,'UPDATE');

38812: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
38813: p_msg_name =>'PA_CANT_USE_LITE_API' );
38814: RAISE FND_API.G_EXC_ERROR;
38815: ELSE
38816: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,l_structure_version_id,'UPDATE');
38817: END IF;
38818: END IF;
38819:
38820:

Line 38924: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_tasks_in(j).pa_task_id,l_structure_version_id,'UPDATE');

38920: l_tasks_in(l_count).BASELINE_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
38921: l_tasks_in(l_count).CLOSED_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
38922: END IF;
38923: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38924: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_tasks_in(j).pa_task_id,l_structure_version_id,'UPDATE');
38925: END IF;
38926: END LOOP;
38927:
38928: pa_project_pub.update_project(p_api_version_number => p_api_version_number,

Line 38949: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

38945: p_msg_name => 'PA_ERROR_UPDATING_PROJECT');
38946: RAISE FND_API.G_EXC_ERROR;
38947: END IF;
38948: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38949: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
38950: END IF;
38951: -- reset all global variables with NULL
38952: PA_PROJECT_PUB.G_MASS_UPDATE_TASKS := NULL;
38953: PA_PROJECT_PUB.G_UPDATE_TASK_ALLOWED := NULL;

Line 38980: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

38976: FND_MSG_PUB.Count_And_Get
38977: ( p_count => x_msg_count ,
38978: p_data => x_msg_data );
38979: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38980: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
38981: END IF;
38982:
38983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
38984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 38992: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

38988: ( p_count => x_msg_count ,
38989: p_data => x_msg_data );
38990:
38991: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38992: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
38993: END IF;
38994:
38995: WHEN OTHERS THEN
38996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 39010: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39006: ( p_count => x_msg_count ,
39007: p_data => x_msg_data );
39008:
39009: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39010: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39011: END IF;
39012:
39013: END BULK_UPDATE_TASKS_LITE;
39014:

Line 39128: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD',l_msg_data,l_return_status);

39124: -- Set the G_ROLLUP_FLAG based on profile options
39125: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
39126: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39127: IF l_incremental_add_tasks = 'Y' THEN
39128: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD',l_msg_data,l_return_status);
39129: ELSE
39130: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD_F',l_msg_data,l_return_status);
39131: END IF;
39132: IF l_return_status <> 'S'

Line 39130: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD_F',l_msg_data,l_return_status);

39126: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39127: IF l_incremental_add_tasks = 'Y' THEN
39128: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD',l_msg_data,l_return_status);
39129: ELSE
39130: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD_F',l_msg_data,l_return_status);
39131: END IF;
39132: IF l_return_status <> 'S'
39133: THEN
39134: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 39138: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD');

39134: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39135: p_msg_name =>l_msg_data );
39136: RAISE FND_API.G_EXC_ERROR;
39137: ELSE
39138: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD');
39139: END IF;
39140: END IF;
39141:
39142: IF l_incremental_add_tasks = 'Y' THEN

Line 39253: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,l_task_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_INC');

39249: p_tasks_out(j).pa_task_id:=l_task_id;
39250:
39251: END IF;
39252: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39253: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,l_task_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_INC');
39254: END IF;
39255: END LOOP;
39256:
39257: ELSE -- NON_DATES scenario while adding tasking incrementally

Line 39347: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,l_task_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_INC');

39343: p_tasks_out(j).pa_task_id:=l_task_id;
39344:
39345: END IF;
39346: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39347: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,l_task_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_INC');
39348: END IF;
39349: END LOOP;
39350:
39351: END IF;

Line 39488: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_FIRST');

39484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39485: p_msg_name => 'PA_ERROR_UPDATING_PROJECT');
39486: RAISE FND_API.G_EXC_ERROR;
39487: END IF;
39488: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_FIRST');
39489: --PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39490:
39491:
39492: END IF; -- add_task or update_project

Line 39489: --PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39485: p_msg_name => 'PA_ERROR_UPDATING_PROJECT');
39486: RAISE FND_API.G_EXC_ERROR;
39487: END IF;
39488: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,PA_PROJECT_PUB.G_STRUC_VERSION_ID,PA_PROJECT_PUB.G_STRUC_VERSION_ID,'ADD_FIRST');
39489: --PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39490:
39491:
39492: END IF; -- add_task or update_project
39493: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .

Line 39534: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39530:
39531: x_return_status := FND_API.G_RET_STS_SUCCESS;
39532:
39533: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39534: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39535: END IF;
39536:
39537: EXCEPTION
39538: WHEN FND_API.G_EXC_ERROR THEN

Line 39541: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39537: EXCEPTION
39538: WHEN FND_API.G_EXC_ERROR THEN
39539: x_return_status := FND_API.G_RET_STS_ERROR ;
39540: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39541: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39542: END IF;
39543: ROLLBACK TO BULK_ADD_TASKS_LITE;
39544:
39545: FND_MSG_PUB.Count_And_Get

Line 39553: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39549:
39550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
39551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
39552: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39553: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39554: END IF;
39555: ROLLBACK TO BULK_ADD_TASKS_LITE;
39556:
39557: FND_MSG_PUB.Count_And_Get

Line 39565: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

39561:
39562: WHEN OTHERS THEN
39563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
39564: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39565: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
39566: END IF;
39567: ROLLBACK TO BULK_ADD_TASKS_LITE;
39568:
39569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 39734: PA_PROJECT_PVT.CONC_LOCK_PROJECT(l_project_id,'MOVE',l_msg_data,l_return_status);

39730: END IF;
39731: -- Set the G_ROLLUP_FLAG based on profile options
39732: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
39733: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39734: PA_PROJECT_PVT.CONC_LOCK_PROJECT(l_project_id,'MOVE',l_msg_data,l_return_status);
39735: IF l_return_status <> 'S'
39736: THEN
39737: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39738: p_msg_name =>l_msg_data );

Line 39741: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(l_project_id,p_structure_version_id,'MOVE');

39737: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39738: p_msg_name =>l_msg_data );
39739: RAISE FND_API.G_EXC_ERROR;
39740: ELSE
39741: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(l_project_id,p_structure_version_id,'MOVE');
39742: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_ref_task_version_id,p_structure_version_id,'MOVE');
39743: --Loop through and update log event for all the tasks
39744: for i in 1..p_task_version_id_tbl.count LOOP
39745: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_task_version_id_tbl(i),p_structure_version_id,'MOVE');

Line 39742: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_ref_task_version_id,p_structure_version_id,'MOVE');

39738: p_msg_name =>l_msg_data );
39739: RAISE FND_API.G_EXC_ERROR;
39740: ELSE
39741: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(l_project_id,p_structure_version_id,'MOVE');
39742: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_ref_task_version_id,p_structure_version_id,'MOVE');
39743: --Loop through and update log event for all the tasks
39744: for i in 1..p_task_version_id_tbl.count LOOP
39745: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_task_version_id_tbl(i),p_structure_version_id,'MOVE');
39746: END LOOP;

Line 39745: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_task_version_id_tbl(i),p_structure_version_id,'MOVE');

39741: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(l_project_id,p_structure_version_id,'MOVE');
39742: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_ref_task_version_id,p_structure_version_id,'MOVE');
39743: --Loop through and update log event for all the tasks
39744: for i in 1..p_task_version_id_tbl.count LOOP
39745: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(l_project_id,p_task_version_id_tbl(i),p_structure_version_id,'MOVE');
39746: END LOOP;
39747: END IF;
39748: END IF;
39749:

Line 39868: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);

39864: END LOOP;
39865:
39866: END IF;
39867: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39868: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);
39869: END IF;
39870:
39871: IF (p_commit = FND_API.G_TRUE) THEN
39872: COMMIT;

Line 39895: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);

39891: , p_msg_index_out => l_msg_index_out);
39892: x_msg_data := l_data;
39893: END IF;
39894: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39895: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);
39896: END IF;
39897: FND_MSG_PUB.Count_And_Get
39898: ( p_count => x_msg_count ,
39899: p_data => x_msg_data );

Line 39910: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);

39906: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
39907: p_procedure_name => l_api_name,
39908: p_error_text => SUBSTRB(SQLERRM,1,240));
39909: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39910: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);
39911: END IF;
39912: when OTHERS then
39913: if p_commit = FND_API.G_TRUE then
39914: rollback to BULK_MOVE_TASKS_LITE;

Line 39921: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);

39917: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
39918: p_procedure_name => l_api_name,
39919: p_error_text => SUBSTRB(SQLERRM,1,240));
39920: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39921: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(l_project_id);
39922: END IF;
39923: FND_MSG_PUB.Count_And_Get
39924: ( p_count => x_msg_count ,
39925: p_data => x_msg_data );

Line 40248: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'INDENT',l_msg_data,l_return_status);

40244: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
40245: --END IF;
40246:
40247: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
40248: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'INDENT',l_msg_data,l_return_status);
40249: IF l_return_status <> 'S'
40250: THEN
40251: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
40252: p_msg_name =>l_msg_data );

Line 40255: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'INDENT');

40251: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
40252: p_msg_name =>l_msg_data );
40253: RAISE FND_API.G_EXC_ERROR;
40254: ELSE
40255: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'INDENT');
40256: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'INDENT');
40257: END IF;
40258: END IF;
40259:

Line 40256: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'INDENT');

40252: p_msg_name =>l_msg_data );
40253: RAISE FND_API.G_EXC_ERROR;
40254: ELSE
40255: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'INDENT');
40256: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'INDENT');
40257: END IF;
40258: END IF;
40259:
40260: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 40659: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

40655:
40656: EXCEPTION
40657: WHEN OTHERS THEN
40658: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
40659: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
40660: END IF;
40661: raise;
40662: END;
40663:

Line 41290: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

41286: COMMIT;
41287: END IF;
41288:
41289: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41290: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
41291: END IF;
41292:
41293: IF (p_debug_mode = 'Y') THEN
41294: pa_debug.debug('PA_PROJECT_PUB.BULK_INDENT_TASKS_LITE END');

Line 41304: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

41300: rollback to BULK_INDENT_TASKS_LITE;
41301: end if;
41302: x_return_status := FND_API.G_RET_STS_ERROR;
41303: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41304: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
41305: END IF;
41306: FND_MSG_PUB.Count_And_Get
41307: ( p_count => x_msg_count ,
41308: p_data => x_msg_data );

Line 41318: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

41314: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
41315: p_procedure_name => 'BULK_INDENT_TASKS_LITE',
41316: p_error_text => SUBSTRB(SQLERRM,1,240));
41317: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41318: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
41319: END IF;
41320: when OTHERS then
41321: if p_commit = FND_API.G_TRUE then
41322: rollback to BULK_INDENT_TASKS_LITE;

Line 41329: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

41325: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
41326: p_procedure_name => 'BULK_INDENT_TASKS_LITE',
41327: p_error_text => SUBSTRB(SQLERRM,1,240));
41328: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41329: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
41330: END IF;
41331: FND_MSG_PUB.Count_And_Get
41332: ( p_count => x_msg_count ,
41333: p_data => x_msg_data );

Line 41703: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'OUTDENT',l_msg_data,l_return_status);

41699: --IF(p_calling_module = 'AMG') THEN
41700: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
41701: --END IF;
41702: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41703: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'OUTDENT',l_msg_data,l_return_status);
41704: IF l_return_status <> 'S'
41705: THEN
41706: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
41707: p_msg_name =>l_msg_data );

Line 41710: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'OUTDENT');

41706: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
41707: p_msg_name =>l_msg_data );
41708: RAISE FND_API.G_EXC_ERROR;
41709: ELSE
41710: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'OUTDENT');
41711: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'OUTDENT');
41712: END IF;
41713: END IF;
41714:

Line 41711: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'OUTDENT');

41707: p_msg_name =>l_msg_data );
41708: RAISE FND_API.G_EXC_ERROR;
41709: ELSE
41710: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'OUTDENT');
41711: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_version_id,p_structure_version_id,'OUTDENT');
41712: END IF;
41713: END IF;
41714:
41715: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 42815: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

42811: pa_debug.debug('PA_PROJECT_PUB.BULK_OUTDENT_TASKS_LITE END');
42812: END IF;
42813:
42814: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42815: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
42816: END IF;
42817:
42818: EXCEPTION
42819: when FND_API.G_EXC_ERROR then

Line 42824: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

42820: if p_commit = FND_API.G_TRUE then
42821: rollback to BULK_OUTDENT_TASKS_LITE;
42822: end if;
42823: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42824: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
42825: END IF;
42826: x_return_status := FND_API.G_RET_STS_ERROR;
42827: FND_MSG_PUB.Count_And_Get
42828: ( p_count => x_msg_count ,

Line 42839: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

42835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
42836: p_procedure_name => 'BULK_OUTDENT_TASKS_LITE',
42837: p_error_text => SUBSTRB(SQLERRM,1,240));
42838: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42839: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
42840: END IF;
42841: when OTHERS then
42842: if p_commit = FND_API.G_TRUE then
42843: rollback to BULK_OUTDENT_TASKS_LITE;

Line 42850: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);

42846: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
42847: p_procedure_name => 'BULK_OUTDENT_TASKS_LITE',
42848: p_error_text => SUBSTRB(SQLERRM,1,240));
42849: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42850: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
42851: END IF;
42852: FND_MSG_PUB.Count_And_Get
42853: ( p_count => x_msg_count ,
42854: p_data => x_msg_data );

Line 42919: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_pa_project_id,'DELETE',p_msg_data,p_return_status);

42915:
42916: -- Set the G_ROLLUP_FLAG based on profile options
42917: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
42918: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42919: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_pa_project_id,'DELETE',p_msg_data,p_return_status);
42920: IF p_return_status <> 'S'
42921: THEN
42922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
42923: p_msg_name => p_msg_data);

Line 42926: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_pa_project_id,l_structure_version_id,'DELETE');

42922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
42923: p_msg_name => p_msg_data);
42924: RAISE FND_API.G_EXC_ERROR;
42925: ELSE
42926: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_pa_project_id,l_structure_version_id,'DELETE');
42927: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,l_structure_version_id,'DELETE');
42928: END IF;
42929: END IF;
42930:

Line 42927: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,l_structure_version_id,'DELETE');

42923: p_msg_name => p_msg_data);
42924: RAISE FND_API.G_EXC_ERROR;
42925: ELSE
42926: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_pa_project_id,l_structure_version_id,'DELETE');
42927: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,l_structure_version_id,'DELETE');
42928: END IF;
42929: END IF;
42930:
42931:

Line 42958: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);

42954:
42955: PA_PROJECT_PUB.G_PROJECT_ID:=NULL;
42956:
42957: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42958: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);
42959: END IF;
42960:
42961: EXCEPTION
42962: WHEN FND_API.G_EXC_ERROR THEN

Line 42968: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);

42964: FND_MSG_PUB.Count_And_Get
42965: ( p_count => p_msg_count ,
42966: p_data => p_msg_data );
42967: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42968: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);
42969: END IF;
42970:
42971: WHEN OTHERS THEN
42972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 42978: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);

42974: p_project_id := NULL ;
42975: p_task_id := NULL;
42976: PA_PROJECT_PUB.G_PROJECT_ID:=NULL;
42977: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42978: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_pa_project_id);
42979: END IF;
42980: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
42981: FND_MSG_PUB.add_exc_msg
42982: ( p_pkg_name => G_PKG_NAME

Line 43360: PA_PROJECT_PVT.Convert_pm_projref_to_id

43356: END IF;
43357: IF p_pa_project_id is not null then
43358: l_project_id:=p_pa_project_id;
43359: ELSE
43360: PA_PROJECT_PVT.Convert_pm_projref_to_id
43361: ( p_pm_project_reference => p_pm_project_reference
43362: , p_pa_project_id => p_pa_project_id
43363: , p_out_project_id => l_project_id
43364: , p_return_status => l_return_status

Line 43653: PA_PROJECT_PVT.Convert_pm_projref_to_id

43649: END IF;
43650: IF p_pa_project_id is not null then
43651: l_project_id:=p_pa_project_id;
43652: ELSE
43653: PA_PROJECT_PVT.Convert_pm_projref_to_id
43654: ( p_pm_project_reference => p_pm_project_reference
43655: , p_pa_project_id => p_pa_project_id
43656: , p_out_project_id => l_project_id
43657: , p_return_status => l_return_status