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_UTILS

Line 1147: pa_utils.add_message

1143: IF l_temp_eff_flag = 'N' THEN
1144:
1145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1146:
1147: pa_utils.add_message
1148: (
1149: p_app_short_name => 'PA'
1150: ,p_msg_name => 'PA_TEMPLATE_NOT_ACTIVE'
1151: );

Line 2125: pa_utils.add_message

2121: ,p_attribute5 => '');
2122: */
2123:
2124: -- Added below code which throws correct error message
2125: pa_utils.add_message
2126: (
2127: p_app_short_name => 'PA'
2128: ,p_msg_name => 'PA_SU_INVALID_DATES'
2129: );

Line 2186: pa_utils.add_message

2182: IF l_project_in_rec.early_finish_date < l_early_start_date THEN
2183:
2184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185:
2186: pa_utils.add_message
2187: (
2188: p_app_short_name => 'PA'
2189: ,p_msg_name => 'PA_SU_INVALID_DATES'
2190: );

Line 2221: pa_utils.add_message

2217: IF l_project_in_rec.late_finish_date < l_late_start_date THEN
2218:
2219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2220:
2221: pa_utils.add_message
2222: (
2223: p_app_short_name => 'PA'
2224: ,p_msg_name => 'PA_SU_INVALID_DATES'
2225: );

Line 2316: pa_utils.add_message

2312: ,p_attribute5 => '');
2313: */
2314:
2315: -- Added below code which throws correct error message
2316: pa_utils.add_message
2317: (
2318: p_app_short_name => 'PA'
2319: ,p_msg_name => 'PA_SU_INVALID_DATES'
2320: );

Line 2685: PA_UTILS.ADD_MESSAGE

2681:
2682: ELSE
2683: --Added for bug 5214431
2684: IF l_project_in_rec.project_value IS NOT NULL AND l_project_in_rec.project_value < 0 THEN
2685: PA_UTILS.ADD_MESSAGE
2686: ( p_app_short_name => 'PA'
2687: ,p_msg_name => 'PA_INVLD_OPPORTUNITY_VALUE');
2688: RAISE FND_API.G_EXC_ERROR;
2689: ELSE

Line 2959: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

2955: IF l_valid_prio_code = 'N' THEN
2956:
2957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2958:
2959: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
2960: ,p_msg_name => 'PA_INVALID_PRIORITY_CODE');
2961:
2962: l_return_status := FND_API.G_RET_STS_ERROR;
2963:

Line 3054: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3050: CLOSE cur_rev_inv;
3051: */
3052: IF nvl(l_enable_funds_flag,'N')='N' AND l_project_in_rec.date_eff_funds_flag ='Y' THEN
3053:
3054: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3055: ,p_msg_name => 'PA_FUNDS_FLAG_CANT_ENABLED'
3056: );
3057:
3058: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3065: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3061: END IF;
3062: /*
3063: IF nvl(l_chk_rev_inv_flag,'N') ='Y' AND l_project_in_rec.date_eff_funds_flag <> l_orig_date_eff_funds_flag THEN
3064:
3065: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3066: ,p_msg_name => 'PA_FUNDS_FLAG_NOT_UPDATBL'
3067: );
3068:
3069: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3493: pa_utils.add_message

3489: /*IF p_customers_in(i).project_relationship_code IS NULL OR
3490: p_customers_in(i).project_relationship_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
3491: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3492: THEN
3493: pa_utils.add_message
3494: ( p_app_short_name => 'PA'-- new message for AA TRACKING
3495: ,p_msg_name => 'PA_RELATIONSHIP_CODE_REQD'
3496: ,p_token1 => 'PROJECT_NAME'
3497: ,p_value1 => l_project_rec.segment1

Line 3521: pa_utils.add_message

3517:
3518: IF (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE IS NULL) OR (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )THEN
3519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3520: THEN
3521: pa_utils.add_message
3522: ( p_app_short_name => 'PA'-- new message for tracking bug
3523: ,p_msg_name => 'PA_CONTACT_TYPE_REQD'
3524: ,p_token1 => 'PROJECT_NAME'
3525: ,p_value1 => l_project_in_rec.pm_project_reference

Line 4122: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

4118: l_orig_def_tt_flag = 'N'
4119: )
4120: )
4121: THEN
4122: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4123: ,p_msg_name => 'PA_TASK_FUNDING_EXIST'
4124: );
4125:
4126: l_return_status := FND_API.G_RET_STS_ERROR;

Line 4255: pa_utils.add_message

4251: FETCH c_prj_count INTO l_prj_mgr_count;
4252: CLOSE c_prj_count;
4253: IF l_prj_mgr_count = 0 THEN
4254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4255: pa_utils.add_message
4256: ( p_app_short_name => 'PA'
4257: ,p_msg_name => 'PA_PR_INSUF_PROJ_MGR'
4258: );
4259: RAISE FND_API.G_EXC_ERROR;

Line 4442: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

4438: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );
4439:
4440: IF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i)
4441: THEN
4442: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4443: p_msg_name =>'PA_WRONG_STR_TYPE_AMG'); -- 'PA_TASKS_NOT_ALLOWD_AMG' -- It is decided to use the same message in this case too
4444: -- Workplan or Financial Structures must be enabled at source project/template level in order to enter Tasks.
4445: RAISE FND_API.G_EXC_ERROR ;
4446: ELSIF l_bug_wp_enabled = 'Y' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i) AND l_structure_in_rec.structure_type = 'FINANCIAL'

Line 4448: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

4444: -- Workplan or Financial Structures must be enabled at source project/template level in order to enter Tasks.
4445: RAISE FND_API.G_EXC_ERROR ;
4446: ELSIF l_bug_wp_enabled = 'Y' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i) AND l_structure_in_rec.structure_type = 'FINANCIAL'
4447: THEN
4448: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4449: p_msg_name => 'PA_WRONG_STR_TYPE_AMG' );
4450: -- Please enter the correct structure type or enable the Workplan/Financial structure at the source project/template level.
4451: RAISE FND_API.G_EXC_ERROR ;
4452: ELSIF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'Y' AND p_tasks_in.exists(i) AND l_structure_in_rec.structure_type = 'WORKPLAN'

Line 4454: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

4450: -- Please enter the correct structure type or enable the Workplan/Financial structure at the source project/template level.
4451: RAISE FND_API.G_EXC_ERROR ;
4452: ELSIF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'Y' AND p_tasks_in.exists(i) AND l_structure_in_rec.structure_type = 'WORKPLAN'
4453: THEN
4454: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4455: p_msg_name => 'PA_WRONG_STR_TYPE_AMG' );
4456: -- Please enter the correct structure type or enable the Workplan/Financial structure at the source project/template level.
4457: RAISE FND_API.G_EXC_ERROR ;
4458: END IF;

Line 5236: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

5232: END IF;
5233:
5234: ELSE
5235: IF i IS NOT NULL THEN
5236: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
5237: ,p_msg_name => 'PA_DLV_STRUCTURE_DISABLED');
5238: l_return_status := FND_API.G_RET_STS_ERROR;
5239: RAISE FND_API.G_EXC_ERROR;
5240: END IF;

Line 5330: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',

5326: ROLLBACK TO create_project_pub;
5327:
5328: -- Bug 7335526
5329: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5330: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5331: p_user_id => FND_GLOBAL.USER_ID,
5332: p_unique_number => to_number(l_project_number_out));
5333: END IF;
5334:

Line 5349: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',

5345: ROLLBACK TO create_project_pub;
5346:
5347: -- Bug 7335526
5348: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5349: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5350: p_user_id => FND_GLOBAL.USER_ID,
5351: p_unique_number => to_number(l_project_number_out));
5352: END IF;
5353:

Line 5368: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',

5364: ROLLBACK TO create_project_pub;
5365:
5366: -- Bug 7335526
5367: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5368: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5369: p_user_id => FND_GLOBAL.USER_ID,
5370: p_unique_number => to_number(l_project_number_out));
5371: END IF;
5372:

Line 5867: -- Using PA_UTILS.ADD_MESSAGE

5863: -- id. So we should derive the id and use it.
5864: -- PA L Changes 3010538
5865: -- Need not use map new amg msg api here as we donot have context information to be displayed and
5866: -- _AMG messages are not defined.
5867: -- Using PA_UTILS.ADD_MESSAGE
5868: --IF p_structure_type IS NOT NULL THEN Replaced p_structure_type by l_str_type for 3746912
5869: IF l_str_type IS NOT NULL THEN
5870:
5871: -- Begin fix for Bug # 4373055.

Line 5882: PA_UTILS.ADD_MESSAGE

5878: IF nvl(l_process_code,'-1') = 'WUP' THEN
5879: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798
5880: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5881:
5882: PA_UTILS.ADD_MESSAGE
5883: (p_app_short_name => 'PA',
5884: --p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC');
5885: p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
5886: p_token1 => 'REQUESTID',

Line 5896: PA_UTILS.ADD_MESSAGE

5892: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
5893: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798
5894: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5895:
5896: PA_UTILS.ADD_MESSAGE
5897: (p_app_short_name => 'PA',
5898: -- p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');
5899: p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
5900: p_token1 => 'REQUESTID',

Line 5923: PA_UTILS.ADD_MESSAGE(

5919:
5920:
5921: if l_message_name is not null then
5922:
5923: PA_UTILS.ADD_MESSAGE(
5924: p_app_short_name => 'PA'
5925: , p_msg_name => l_message_name
5926: , p_token1 => 'REQUESTID'
5927: , p_value1 => l_conc_request_id);

Line 6256: PA_UTILS.ADD_MESSAGE

6252: ,p_attribute3 => ''
6253: ,p_attribute4 => ''
6254: ,p_attribute5 => '');
6255: ELSE
6256: PA_UTILS.ADD_MESSAGE
6257: (p_app_short_name => 'PA',
6258: p_msg_name => 'PA_INVALID_PROJECT_CUSTOMER',
6259: p_token1 => 'CUSTOMER_NAME',
6260: p_value1 => l_customer_name

Line 6574: -- PA_UTILS.ADD_MESSAGE

6570: -- Bug 3075623 : Added following condition to throw error if no ref task id
6571: -- IF (( (p_pa_parent_task_id IS NOT NULL AND p_pa_parent_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
6572: -- (p_pm_parent_task_reference IS NOT NULL AND p_pm_parent_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
6573: -- AND l_ref_task_id is null ) THEN
6574: -- PA_UTILS.ADD_MESSAGE
6575: -- (p_app_short_name => 'PA',
6576: -- p_msg_name => 'PA_PS_INV_REF_TASK_ID');
6577: --
6578: -- RAISE FND_API.G_EXC_ERROR;

Line 6701: PA_UTILS.ADD_MESSAGE('PA', 'PA_AMG_RES_INV_PARAMS',

6697: End If;
6698: End IF;
6699:
6700: IF l_financial_task_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
6701: PA_UTILS.ADD_MESSAGE('PA', 'PA_AMG_RES_INV_PARAMS',
6702: 'INVALID_PARAMS', 'FINANCIAL_TASK_FLAG');
6703: RAISE FND_API.G_EXC_ERROR;
6704: End If;
6705: --Bug 6410745 End Changes

Line 7591: PA_UTILS.ADD_MESSAGE

7587: IF nvl(l_process_code,'-1') = 'WUP' THEN
7588: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798
7589: ,p_structure_type => p_structure_type );
7590:
7591: PA_UTILS.ADD_MESSAGE
7592: (p_app_short_name => 'PA',
7593: -- p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC');
7594: p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
7595: p_token1 => 'REQUESTID',

Line 7604: PA_UTILS.ADD_MESSAGE

7600: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
7601: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id --Bug 3091798
7602: ,p_structure_type => p_structure_type );
7603:
7604: PA_UTILS.ADD_MESSAGE
7605: (p_app_short_name => 'PA',
7606: -- p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');
7607: p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
7608: p_token1 => 'REQUESTID',

Line 7630: PA_UTILS.ADD_MESSAGE(

7626:
7627:
7628: if l_message_name is not null then
7629:
7630: PA_UTILS.ADD_MESSAGE(
7631: p_app_short_name => 'PA'
7632: , p_msg_name => l_message_name
7633: , p_token1 => 'REQUESTID'
7634: , p_value1 => l_conc_request_id);

Line 10660: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

10656: AND PA_RELATIONSHIP_UTILS.Check_subproject_link_exists( p_project_in.pa_project_id ) = 'Y'
10657: AND p_structure_in.structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added the condition for Bug 7248969
10658: AND p_tasks_in.count > 0 -- Added the condition for Bug 7248969
10659: THEN
10660: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10661: p_msg_name => 'PA_PS_CANT_UPDATE_PROG_PRJ');
10662: RAISE FND_API.G_EXC_ERROR;
10663: END IF;
10664: --end bug 4619824

Line 10685: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

10681:
10682: -- End Bug # 4582750.
10683:
10684: --if yes, raise error.
10685: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10686: p_msg_name => 'PA_STR_LOCKED_BY_OTHER');
10687: RAISE FND_API.G_EXC_ERROR;
10688:
10689: -- Begin Bug # 4582750.

Line 10769: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

10765: --IF (p_update_mode = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
10766: --Check if str version is locked by another user
10767: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then
10768: --if yes, raise error.
10769: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10770: p_msg_name => 'PA_STR_LOCKED_BY_OTHER');
10771: RAISE FND_API.G_EXC_ERROR;
10772: end if;
10773: --END IF;

Line 10802: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_ORG_FC_CANT_UPD_ORG_PRJ');

10798: ,p_attribute4 => ''
10799: ,p_attribute5 => '');
10800: END IF;
10801:
10802: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_ORG_FC_CANT_UPD_ORG_PRJ');
10803: p_project_out.return_status := FND_API.G_RET_STS_ERROR;
10804: RAISE FND_API.G_EXC_ERROR;
10805: END IF;
10806: --Organization Forecasting.

Line 11157: PA_UTILS.ADD_MESSAGE('PA','PA_PS_PRJ_CURR_LNK_ERR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

11153: open cur_prog_name(l_project_id);
11154: fetch cur_prog_name into l_prog_name;
11155: close cur_prog_name;
11156:
11157: PA_UTILS.ADD_MESSAGE('PA','PA_PS_PRJ_CURR_LNK_ERR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
11158:
11159: -- Bug # 4329284.
11160:
11161: END IF ;

Line 11896: pa_utils.add_message

11892: l_validate, l_start_date_status, l_end_date_status);
11893:
11894: If l_validate = 'Y' and l_start_date_status = 'I' Then
11895:
11896: pa_utils.add_message
11897: ( p_app_short_name => 'PA'
11898: ,p_msg_name => 'PA_PROJ_DATE_START_ERROR'
11899: ,p_token1 => ''
11900: ,p_value1 => ''

Line 11912: pa_utils.add_message

11908: End If;
11909:
11910: If l_validate = 'Y' and l_end_date_status = 'I' Then
11911:
11912: pa_utils.add_message
11913: ( p_app_short_name => 'PA'
11914: ,p_msg_name => 'PA_PROJ_DATE_FINISH_ERROR'
11915: ,p_token1 => ''
11916: ,p_value1 => ''

Line 12051: pa_utils.add_message

12047: IF p_project_in.early_finish_date < p_project_in.early_start_date THEN
12048:
12049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12050:
12051: pa_utils.add_message
12052: (
12053: p_app_short_name => 'PA'
12054: ,p_msg_name => 'PA_SU_INVALID_DATES'
12055: );

Line 12072: pa_utils.add_message

12068: IF p_project_in.early_finish_date < l_project_rec.early_start_date THEN
12069:
12070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12071:
12072: pa_utils.add_message
12073: (
12074: p_app_short_name => 'PA'
12075: ,p_msg_name => 'PA_SU_INVALID_DATES'
12076: );

Line 12141: pa_utils.add_message

12137: IF p_project_in.late_finish_date < p_project_in.late_start_date THEN
12138:
12139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12140:
12141: pa_utils.add_message
12142: (
12143: p_app_short_name => 'PA'
12144: ,p_msg_name => 'PA_SU_INVALID_DATES'
12145: );

Line 12160: pa_utils.add_message

12156: IF p_project_in.late_finish_date < l_project_rec.late_start_date THEN
12157:
12158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12159:
12160: pa_utils.add_message
12161: (
12162: p_app_short_name => 'PA'
12163: ,p_msg_name => 'PA_SU_INVALID_DATES'
12164: );

Line 12475: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

12471: FETCH l_cur_retention_tax_code INTO l_dummy_cur_output_tax_code;
12472: CLOSE l_cur_retention_tax_code;
12473:
12474: IF l_dummy_cur_output_tax_code <> 'Y' THEN
12475: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
12476: p_msg_name => 'PA_INVLD_OUTPUT_TAX_CODE');
12477:
12478: p_return_status := FND_API.G_RET_STS_ERROR;
12479: RAISE FND_API.G_EXC_ERROR;

Line 12513: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

12509: FETCH l_cur_retention_tax_code INTO l_dummy_cur_retention_tax_code;
12510: CLOSE l_cur_retention_tax_code;
12511:
12512: IF l_dummy_cur_retention_tax_code <> 'Y' THEN
12513: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
12514: p_msg_name => 'PA_INVLD_RETENTION_TAX_CODE');
12515:
12516: p_return_status := FND_API.G_RET_STS_ERROR;
12517: RAISE FND_API.G_EXC_ERROR;

Line 12574: pa_utils.add_message

12570: IF l_allow_update_flag = 'N' THEN
12571:
12572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12573:
12574: pa_utils.add_message
12575: (
12576: p_app_short_name => 'PA'
12577: ,p_msg_name => 'PA_CURR_CODE_NOT_UPDATBL'
12578: );

Line 12603: pa_utils.add_message

12599:
12600: --invalid currency code has been passed hence throw error
12601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12602:
12603: pa_utils.add_message
12604: (
12605: p_app_short_name => 'PA'
12606: ,p_msg_name => 'PA_INVALID_PROJ_CURR_CODE'
12607: );

Line 12688: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

12684: CLOSE l_cur_project_rate_type;
12685:
12686: IF l_dummy_project_rate_type <> 'Y' THEN
12687:
12688: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
12689: p_msg_name => 'PA_INVLD_PROJ_RATE_TYPE');
12690: p_return_status := FND_API.G_RET_STS_ERROR;
12691: RAISE FND_API.G_EXC_ERROR;
12692: END IF ;

Line 13025: PA_UTILS.ADD_MESSAGE

13021: TO_CHAR(p_project_in.project_value)||',';
13022: */--Added for bug 5214431
13023: -- changed from l_project_in_rec.project_value to p_project_in.project_value
13024: IF p_project_in.project_value IS NOT NULL AND p_project_in.project_value < 0 THEN
13025: PA_UTILS.ADD_MESSAGE
13026: ( p_app_short_name => 'PA'
13027: ,p_msg_name => 'PA_INVLD_OPPORTUNITY_VALUE');
13028: RAISE FND_API.G_EXC_ERROR;
13029: END IF;

Line 14755: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

14751: IF l_valid_prio_code = 'N' THEN
14752:
14753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14754:
14755: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
14756: ,p_msg_name => 'PA_INVALID_PRIORITY_CODE');
14757:
14758: l_return_status := FND_API.G_RET_STS_ERROR;
14759:

Line 15287: PA_UTILS.ADD_MESSAGE(

15283: l_enable_top_task_cust_flag := 'Y';
15284: l_update_yes_flag := 'Y';
15285: ELSE--Added by rtarway for BUG 4168069
15286: --Add the error message in the pl/sql stack and raise exception
15287: PA_UTILS.ADD_MESSAGE(
15288: p_app_short_name => 'PA',
15289: p_msg_name =>'PA_NO_TOP_TASK_CUST_ALLOWED'
15290: );
15291: p_project_out.return_status := FND_API.G_RET_STS_ERROR;

Line 15357: PA_UTILS.ADD_MESSAGE(

15353: l_statement := l_statement || ' enable_top_task_inv_mth_flag = :enable_top_task_inv_mth_flg ,';
15354: l_enable_top_task_inv_mth_flag := 'Y';
15355: l_update_yes_flag := 'Y';
15356: ELSE --Added for Bug 4193730
15357: PA_UTILS.ADD_MESSAGE(
15358: p_app_short_name => 'PA',
15359: p_msg_name => 'PA_INV_MTH_TT_NOT_SET'
15360: );
15361: p_project_out.return_status := FND_API.G_RET_STS_ERROR;

Line 15437: PA_UTILS.ADD_MESSAGE(

15433: CLOSE cur_rev_inv;
15434:
15435: IF nvl(l_enable_funds_flag,'N')='N' AND p_project_in.date_eff_funds_flag ='Y' THEN
15436:
15437: PA_UTILS.ADD_MESSAGE(
15438: p_app_short_name => 'PA',
15439: p_msg_name => 'PA_FUNDS_FLAG_CANT_ENABLED'
15440: );
15441: p_project_out.return_status := FND_API.G_RET_STS_ERROR;

Line 15447: PA_UTILS.ADD_MESSAGE(

15443: END IF;
15444:
15445: IF nvl(l_chk_rev_inv_flag,'N')= 'Y' THEN
15446:
15447: PA_UTILS.ADD_MESSAGE(
15448: p_app_short_name => 'PA',
15449: p_msg_name => 'PA_FUNDS_FLAG_NOT_UPDATBL'
15450: );
15451: p_project_out.return_status := FND_API.G_RET_STS_ERROR;

Line 16124: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

16120: END IF;
16121:
16122:
16123: if l_return_status <> 'S' then
16124: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
16125: p_msg_name => 'PA_ERR_MOD_PROJ_OPP_ATTR');
16126: RAISE FND_API.G_EXC_ERROR;
16127: end if;
16128: -- End of code changes for bug 4473105

Line 16613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

16609:
16610: --BUG 4413568 DHI ER , rtarway, if p_update_mode is PA_UPD_TASK_ATTR, WBS/FBS hierarchy can not be changed.
16611: --if l_task_id is null, means this is a new task, so we should be raising an error at this point itself
16612: IF ( p_update_mode = 'PA_UPD_TASK_ATTR') THEN
16613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16614: p_msg_name => 'PA_WBS_CANT_CHANGE');
16615: RAISE FND_API.G_EXC_ERROR;
16616: END IF;
16617:

Line 17458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

17454: end if;
17455: /* Code addition for bug 2982057 ends */
17456: --DHI ER, bug 4413568
17457: IF ( p_update_mode = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
17458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
17459: p_msg_name => 'PA_WBS_CANT_CHANGE');
17460: RAISE FND_API.G_EXC_ERROR;
17461: END IF;
17462: PA_PROJECT_PVT.add_task_round_one

Line 18389: pa_utils.add_message

18385: IF p_key_members(i).start_date IS NULL OR
18386: p_key_members(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE then
18387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
18388: THEN
18389: pa_utils.add_message
18390: ( p_app_short_name => 'PA'-- new message for bug 3326468
18391: ,p_msg_name => 'PA_KEYMBR_NO_START_DATE'
18392: ,p_token1 => 'PROJECT_NAME'
18393: ,p_value1 => l_project_rec.segment1

Line 18703: pa_utils.add_message

18699: FETCH c_prj_count INTO l_prj_mgr_count;
18700: CLOSE c_prj_count;
18701: IF l_prj_mgr_count = 0 THEN
18702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
18703: pa_utils.add_message
18704: ( p_app_short_name => 'PA'
18705: ,p_msg_name => 'PA_PR_INSUF_PROJ_MGR'
18706: );
18707: RAISE FND_API.G_EXC_ERROR;

Line 19085: pa_utils.add_message

19081: --dbms_output.put_line('five'||l_check_relationship_flag);
19082: --passed customer does not exist
19083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
19084: --Changed the error message from PA_CUSTOMER_NOT_EXIST to PA_CUSTOMER_ID_INVALID for Bug#5183150
19085: pa_utils.add_message
19086: ( p_app_short_name => 'PA'
19087: ,p_msg_name => 'PA_CUSTOMER_ID_INVALID'
19088: );
19089: END IF;

Line 19099: pa_utils.add_message

19095: --dbms_output.put_line('four'||l_check_relationship_flag);
19096: IF ( l_cust_status = 'I' ) THEN
19097: --customer is not active
19098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
19099: pa_utils.add_message
19100: ( p_app_short_name => 'PA'
19101: ,p_msg_name => 'PA_CUSTOMER_NOT_ACTIVE'
19102: ,p_token1 => 'PROJECT_NAME'
19103: ,p_value1 => l_project_rec.segment1

Line 19678: pa_utils.add_message

19674: IF p_customers_in(i).project_relationship_code IS NULL OR
19675: p_customers_in(i).project_relationship_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
19676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
19677: THEN
19678: pa_utils.add_message
19679: ( p_app_short_name => 'PA'-- using existing message for AA TRACKING
19680: ,p_msg_name => 'PA_RELATIONSHIP_CODE_REQD'
19681: ,p_token1 => 'PROJECT_NAME'
19682: ,p_value1 => l_project_rec.segment1

Line 19698: pa_utils.add_message

19694: IF p_customers_in(i).CUSTOMER_BILL_SPLIT IS NULL OR
19695: p_customers_in(i).CUSTOMER_BILL_SPLIT = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM then
19696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
19697: THEN
19698: pa_utils.add_message
19699: ( p_app_short_name => 'PA'-- new message for AA TRACKING
19700: ,p_msg_name => 'PA_CUST_BILL_SPLIT_REQD'
19701: ,p_token1 => 'PROJECT_NAME'
19702: ,p_value1 => l_project_rec.segment1

Line 19715: pa_utils.add_message

19711: ( p_customer_bill_split => p_customers_in(i).CUSTOMER_BILL_SPLIT
19712: ,x_return_status => l_return_status
19713: ,x_error_msg_code => l_error_msg_code);
19714: If l_return_status <> FND_API.G_RET_STS_SUCCESS then
19715: pa_utils.add_message
19716: ( p_app_short_name => 'PA' --TRACKING
19717: ,p_msg_name => 'PA_CUST_BILL_SPLIT_INVALID'
19718: ,p_token1 => 'PROJECT_NAME'
19719: ,p_value1 => l_project_rec.segment1

Line 19869: pa_utils.add_message

19865:
19866: IF (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE IS NULL) OR (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )THEN
19867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
19868: THEN
19869: pa_utils.add_message
19870: ( p_app_short_name => 'PA'-- existing message for tracking bug
19871: ,p_msg_name => 'PA_CONTACT_TYPE_REQD'
19872: ,p_token1 => 'PROJECT_NAME'
19873: ,p_value1 => l_project_in_rec.pm_project_reference

Line 20325: pa_utils.add_message

20321: Else
20322: If (pa_customer_info.revenue_accrued_or_billed(l_project_id)) then
20323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20324: THEN
20325: pa_utils.add_message
20326: ( p_app_short_name => 'PA'-- new message for bug 3326468
20327: ,p_msg_name => 'PA_UPD_CUST_NOT_ALLOWED'
20328: ,p_token1 => 'PROJECT_NAME'
20329: ,p_value1 => l_project_id

Line 20353: pa_utils.add_message

20349: Else /* Some value of passed for receiver_task_id */
20350: If l_bill_another_project_flag = 'N' Then
20351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20352: THEN
20353: pa_utils.add_message
20354: ( p_app_short_name => 'PA'-- new message for bug 4153629
20355: ,p_msg_name => 'PA_UPD_RCVR_TSK_NOT_ALLOWED'
20356: ,p_token1 => 'PROJECT_NAME'
20357: ,p_value1 => l_project_id

Line 20375: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

20371: ,x_error_msg_code => l_error_msg_code
20372: );
20373: --dbms_output..put_line('value of l_bill_another_project_flag'||l_bill_another_project_flag);
20374: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
20375: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
20376: p_msg_name => l_error_msg_code
20377: ,p_token1 => 'PROJECT_NAME'
20378: ,p_value1 => l_project_id
20379: ,p_token2 => 'CUSTOMER_ID'

Line 20398: pa_utils.add_message

20394: Else /* Some value of passed for receiver_task_id */
20395: If l_bill_another_project_flag = 'N' Then
20396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20397: THEN
20398: pa_utils.add_message
20399: ( p_app_short_name => 'PA'-- new message for bug 4153629
20400: ,p_msg_name => 'PA_UPD_RCVR_TSK_NOT_ALLOWED'
20401: ,p_token1 => 'PROJECT_NAME'
20402: ,p_value1 => l_project_id

Line 20421: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

20417: );
20418: --dbms_output..put_line('value of l_bill_another_project_flag'||l_bill_another_project_flag);
20419:
20420: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
20421: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
20422: p_msg_name => l_error_msg_code
20423: ,p_token1 => 'PROJECT_NAME'
20424: ,p_value1 => l_project_id
20425: ,p_token2 => 'CUSTOMER_ID'

Line 20469: pa_utils.add_message

20465:
20466: IF (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE IS NULL) OR (p_customers_in(i).PROJECT_CONTACT_TYPE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )THEN
20467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
20468: THEN
20469: pa_utils.add_message
20470: ( p_app_short_name => 'PA'-- existing message for tracking bug
20471: ,p_msg_name => 'PA_CONTACT_TYPE_REQD'
20472: ,p_token1 => 'PROJECT_NAME'
20473: ,p_value1 => l_project_in_rec.pm_project_reference

Line 20889: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

20885: ,p_attribute2 => ''
20886: ,p_attribute3 => ''
20887: ,p_attribute4 => ''
20888: ,p_attribute5 => ''); */
20889: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20890: ,p_msg_name => 'PA_TOT_CUST_BILL_SPLIT_INVLD');
20891: p_project_out.return_status := FND_API.G_RET_STS_ERROR;
20892: p_return_status := FND_API.G_RET_STS_ERROR;
20893: RAISE FND_API.G_EXC_ERROR;

Line 21161: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

21157: l_old_cust_top_task_flag = 'N'
21158: )
21159: )
21160: THEN
21161: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
21162: ,p_msg_name => 'PA_TASK_FUNDING_EXIST'
21163: );
21164: p_project_out.return_status := FND_API.G_RET_STS_ERROR;
21165: RAISE FND_API.G_EXC_ERROR;

Line 22870: PA_UTILS.ADD_MESSAGE

22866: ,p_attribute3 => ''
22867: ,p_attribute4 => ''
22868: ,p_attribute5 => '');
22869: ELSE
22870: PA_UTILS.ADD_MESSAGE
22871: (p_app_short_name => 'PA',
22872: p_msg_name => 'PA_INVALID_PROJECT_CUSTOMER',
22873: p_token1 => 'CUSTOMER_NAME',
22874: p_value1 => l_customer_name

Line 27446: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

27442: -- Validate the structure type. It should be FINANCIAL / WORKPLAN /DELIVERABLE.
27443: -- Throw an error otherwise.
27444:
27445: IF nvl(p_structure_type,'-99') not in ('FINANCIAL','WORKPLAN', 'DELIVERABLE') THEN
27446: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
27447: ,p_msg_name => 'PA_PS_INV_STR_TYPE');
27448:
27449: RAISE FND_API.G_EXC_ERROR;
27450: END IF;

Line 28203: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

28199: --although it does not convey full message here and we will change it later
28200: --The message PA_PS_INV_STR_VER_ID does not have the AMG at the end so I cant use the standard api
28201: --call for AMG messages i.e,pa_interface_utils_pub.map_new_amg_msg
28202:
28203: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
28204: ,p_msg_name => 'PA_PS_INV_STR_VER_ID');
28205: END IF;
28206: p_return_status := FND_API.G_RET_STS_ERROR;
28207: RAISE FND_API.G_EXC_ERROR;

Line 28326: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

28322: THEN
28323:
28324: -- Using the message name PA_PS_INV_STR_VER_ID
28325:
28326: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
28327: ,p_msg_name => 'PA_PS_INV_STR_VER_ID');
28328: END IF;
28329: p_return_status := FND_API.G_RET_STS_ERROR;
28330: RAISE FND_API.G_EXC_ERROR;

Line 28342: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

28338: CLOSE l_temp_cursor;
28339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
28340: THEN
28341: -- Using the message name PA_PS_INV_STR_VER_ID
28342: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
28343: ,p_msg_name => 'PA_PS_INV_STR_VER_ID');
28344: END IF;
28345: p_return_status := FND_API.G_RET_STS_ERROR;
28346: RAISE FND_API.G_EXC_ERROR;

Line 28558: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

28554: ,x_msg_count => l_msg_count
28555: ,x_msg_data => l_msg_data);
28556:
28557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
28558: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
28559: p_msg_name => l_msg_data);
28560: p_msg_data := l_msg_data;
28561: p_return_status := 'E';
28562: p_msg_count := l_msg_count;

Line 29593: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

29589: RAISE FND_API.G_EXC_ERROR;
29590: END IF;
29591:
29592: IF l_function_allowed = 'N' THEN
29593: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
29594: ,p_msg_name => 'PA_FUNCTION_SECURITY_ENFORCED');
29595: x_return_status := FND_API.G_RET_STS_ERROR;
29596: RAISE FND_API.G_EXC_ERROR;
29597: END IF;

Line 29649: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

29645:
29646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
29647: THEN
29648:
29649: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
29650: ,p_msg_name => 'PA_TASK_ID_INVALID');
29651:
29652: x_return_status := FND_API.G_RET_STS_ERROR;
29653: RAISE FND_API.G_EXC_ERROR;

Line 29722: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

29718: END IF;
29719: END IF;
29720:
29721: IF G_DLVR_STRUCTURE_ENABLED = 'N' THEN
29722: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
29723: ,p_msg_name => 'PA_DLV_STRUCTURE_DISABLED');
29724: x_return_status := FND_API.G_RET_STS_ERROR;
29725: RAISE FND_API.G_EXC_ERROR;
29726: END IF;

Line 29944: PA_UTILS.ADD_MESSAGE

29940: ELSE --l_dlvr_action_enabled <> 'Y'
29941:
29942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
29943: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_ACTION_NOT_ENABLED') ;
29944: PA_UTILS.ADD_MESSAGE
29945: (p_app_short_name => 'PA',
29946: p_msg_name => 'PA_DLVR_VALID_ERR',
29947: p_token1 => 'PROJECT',
29948: p_value1 => l_project_number,

Line 30417: PA_UTILS.ADD_MESSAGE

30413: ELSE --l_dlvr_action_enabled <> 'Y'
30414:
30415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
30416: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_ACTION_NOT_ENABLED') ;
30417: PA_UTILS.ADD_MESSAGE
30418: (p_app_short_name => 'PA',
30419: p_msg_name => 'PA_DLVR_VALID_ERR',
30420: p_token1 => 'PROJECT',
30421: p_value1 => l_project_number,

Line 31655: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

31651: RAISE FND_API.G_EXC_ERROR;
31652: END IF;
31653:
31654: IF l_function_allowed = 'N' THEN
31655: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
31656: ,p_msg_name => 'PA_FUNCTION_SECURITY_ENFORCED');
31657: x_return_status := FND_API.G_RET_STS_ERROR;
31658: RAISE FND_API.G_EXC_ERROR;
31659: END IF;

Line 32579: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

32575:
32576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
32577: THEN
32578:
32579: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
32580: ,p_msg_name => 'PA_TASK_ID_INVALID');
32581:
32582: x_return_status := FND_API.G_RET_STS_ERROR;
32583: RAISE FND_API.G_EXC_ERROR;

Line 34553: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34549: --
34550: --Bug 3768875
34551: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34552: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34553: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34554: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34555: RAISE FND_API.G_EXC_ERROR;
34556: End If;
34557: Else

Line 34558: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34554: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34555: RAISE FND_API.G_EXC_ERROR;
34556: End If;
34557: Else
34558: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34559: p_msg_name => 'PA_INV_PROJECT_ID');
34560: RAISE FND_API.G_EXC_ERROR;
34561: End If;
34562: --

Line 34580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34576: OPEN get_workplan_status(l_project_id, p_structure_version_id);
34577: FETCH get_workplan_status into l_wp_status;
34578: CLOSE get_workplan_status;
34579: IF l_wp_status <> 'STRUCTURE_WORKING' THEN
34580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34581: p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
34582: RAISE FND_API.G_EXC_ERROR;
34583: END IF;
34584: ELSE

Line 34586: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34582: RAISE FND_API.G_EXC_ERROR;
34583: END IF;
34584: ELSE
34585: IF (l_versioning IS NULL) THEN
34586: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34587: p_msg_name => 'PA_PS_WORKPLAN_DISABLED');
34588: RAISE FND_API.G_EXC_ERROR;
34589: END IF;
34590: END IF;

Line 34599: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34595: open get_task_ver_id(l_project_id, p_pm_task_reference);
34596: Fetch get_task_ver_id into l_task_ver_id;
34597: -- Bug 3768875
34598: IF get_task_ver_id%NOTFOUND THEN
34599: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34600: p_msg_name => 'PA_PS_INV_TASK_ID');
34601: CLOSE get_task_ver_id;
34602: RAISE FND_API.G_EXC_ERROR;
34603: END IF;

Line 34613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34609: --need to get id using task id
34610: OPEN get_task_ver_id2(l_project_id, p_pa_task_id);
34611: FETCH get_task_Ver_id2 into l_task_ver_id;
34612: IF get_task_ver_id2%NOTFOUND THEN
34613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34614: p_msg_name => 'PA_PS_INV_TASK_ID');
34615: CLOSE get_task_ver_id2;
34616: RAISE FND_API.G_EXC_ERROR;
34617: END IF;

Line 34628: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34624: open get_task_ver_id(l_project_id, p_pm_pred_reference);
34625: Fetch get_task_ver_id into l_pred_ver_id;
34626: --Bug 3768875
34627: IF get_task_ver_id%NOTFOUND THEN
34628: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34629: p_msg_name => 'PA_PS_INV_TASK_ID');
34630: CLOSE get_task_ver_id;
34631: RAISE FND_API.G_EXC_ERROR;
34632: END IF;

Line 34642: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34638: --need to get id using task id
34639: OPEN get_task_ver_id2(l_project_id, p_pa_pred_id);
34640: FETCH get_task_Ver_id2 into l_pred_ver_id;
34641: IF get_task_ver_id2%NOTFOUND THEN
34642: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34643: p_msg_name => 'PA_PS_INV_TASK_ID');
34644: CLOSE get_task_ver_id2;
34645: RAISE FND_API.G_EXC_ERROR;
34646: END IF;

Line 34653: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34649: --end bug 3880403
34650: --
34651: -- Bug 3768933 Validating the relationship_subtype
34652: IF PA_PROJ_ELEMENTS_UTILS.check_pa_lookup_exists('PA_OBJECT_DEPENDENCY_TYPES',p_type) <> 'Y' THEN
34653: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34654: p_msg_name => 'PA_PS_INV_REL_SUBTYPE_VAL');
34655: RAISE FND_API.G_EXC_ERROR;
34656: END IF;
34657: --

Line 34811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34807: --
34808: --Bug 3769089
34809: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34810: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34812: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34813:
34814: RAISE FND_API.G_EXC_ERROR;
34815: End If;

Line 34817: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34813:
34814: RAISE FND_API.G_EXC_ERROR;
34815: End If;
34816: Else
34817: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34818: p_msg_name => 'PA_INV_PROJECT_ID');
34819: RAISE FND_API.G_EXC_ERROR;
34820: End If;
34821: --

Line 34840: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34836: OPEN get_workplan_status(l_project_id, p_structure_version_id);
34837: FETCH get_workplan_status into l_wp_status;
34838: CLOSE get_workplan_status;
34839: IF l_wp_status <> 'STRUCTURE_WORKING' THEN
34840: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34841: p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
34842: RAISE FND_API.G_EXC_ERROR;
34843: END IF;
34844: ELSE

Line 34846: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34842: RAISE FND_API.G_EXC_ERROR;
34843: END IF;
34844: ELSE
34845: IF (l_versioning IS NULL) THEN
34846: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34847: p_msg_name => 'PA_PS_WORKPLAN_DISABLED');
34848: RAISE FND_API.G_EXC_ERROR;
34849: END IF;
34850: END IF;

Line 34859: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34855: open get_task_ver_id(l_project_id, p_pm_task_reference);
34856: Fetch get_task_ver_id into l_task_ver_id;
34857: --Bug 3769089
34858: IF get_task_ver_id%NOTFOUND THEN
34859: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34860: p_msg_name => 'PA_PS_INV_TASK_ID');
34861: CLOSE get_task_ver_id;
34862: RAISE FND_API.G_EXC_ERROR;
34863: END IF;

Line 34873: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34869: --need to get id using task id
34870: OPEN get_task_ver_id2(l_project_id, p_pa_task_id);
34871: FETCH get_task_Ver_id2 into l_task_ver_id;
34872: IF get_task_ver_id2%NOTFOUND THEN
34873: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34874: p_msg_name => 'PA_PS_INV_TASK_ID');
34875: CLOSE get_task_ver_id2;
34876: RAISE FND_API.G_EXC_ERROR;
34877: END IF;

Line 34889: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34885: open get_task_ver_id(l_project_id, p_pm_pred_reference);
34886: Fetch get_task_ver_id into l_pred_ver_id;
34887: --Bug 3769089
34888: IF get_task_ver_id%NOTFOUND THEN
34889: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34890: p_msg_name => 'PA_PS_INV_TASK_ID');
34891: CLOSE get_task_ver_id;
34892: RAISE FND_API.G_EXC_ERROR;
34893: END IF;

Line 34903: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34899: --need to get id using task id
34900: OPEN get_task_ver_id2(l_project_id, p_pa_pred_id);
34901: FETCH get_task_Ver_id2 into l_pred_ver_id;
34902: IF get_task_ver_id2%NOTFOUND THEN
34903: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34904: p_msg_name => 'PA_PS_INV_TASK_ID');
34905: CLOSE get_task_ver_id2;
34906: RAISE FND_API.G_EXC_ERROR;
34907: END IF;

Line 34918: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

34914: open get_rvn(l_task_ver_id, l_pred_ver_id);
34915: FETCH get_rvn into l_record_version_number;
34916: --Bug 3769047
34917: IF get_rvn%NOTFOUND THEN
34918: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34919: p_msg_name => 'PA_PS_INV_DEP_ID');
34920: RAISE FND_API.G_EXC_ERROR;
34921: END IF;
34922: CLOSE get_rvn;

Line 35072: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35068: --
35069: --Bug 3769079
35070: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35071: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35072: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35073: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35074: RAISE FND_API.G_EXC_ERROR;
35075: End If;
35076: Else

Line 35077: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35073: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35074: RAISE FND_API.G_EXC_ERROR;
35075: End If;
35076: Else
35077: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35078: p_msg_name => 'PA_INV_PROJECT_ID');
35079: RAISE FND_API.G_EXC_ERROR;
35080: End If;
35081: --

Line 35100: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35096: OPEN get_workplan_status(l_project_id, p_structure_version_id);
35097: FETCH get_workplan_status into l_wp_status;
35098: CLOSE get_workplan_status;
35099: IF l_wp_status <> 'STRUCTURE_WORKING' THEN
35100: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35101: p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
35102: RAISE FND_API.G_EXC_ERROR;
35103: END IF;
35104: ELSE

Line 35106: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35102: RAISE FND_API.G_EXC_ERROR;
35103: END IF;
35104: ELSE
35105: IF (l_versioning IS NULL) THEN
35106: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35107: p_msg_name => 'PA_PS_WORKPLAN_DISABLED');
35108: RAISE FND_API.G_EXC_ERROR;
35109: END IF;
35110: END IF;

Line 35119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35115: open get_task_ver_id(l_project_id, p_pm_task_reference);
35116: Fetch get_task_ver_id into l_task_ver_id;
35117: --Bug 3769079
35118: IF get_task_ver_id%NOTFOUND THEN
35119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35120: p_msg_name => 'PA_PS_INV_TASK_ID');
35121: CLOSE get_task_ver_id;
35122: RAISE FND_API.G_EXC_ERROR;
35123: END IF;

Line 35133: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35129: --need to get id using task id
35130: OPEN get_task_ver_id2(l_project_id, p_pa_task_id);
35131: FETCH get_task_Ver_id2 into l_task_ver_id;
35132: IF get_task_ver_id2%NOTFOUND THEN
35133: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35134: p_msg_name => 'PA_PS_INV_TASK_ID');
35135: CLOSE get_task_ver_id2;
35136: RAISE FND_API.G_EXC_ERROR;
35137: END IF;

Line 35148: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35144: open get_task_ver_id(l_project_id, p_pm_pred_reference);
35145: Fetch get_task_ver_id into l_pred_ver_id;
35146: --Bug 3769079
35147: IF get_task_ver_id%NOTFOUND THEN
35148: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35149: p_msg_name => 'PA_PS_INV_TASK_ID');
35150: CLOSE get_task_ver_id;
35151: RAISE FND_API.G_EXC_ERROR;
35152: END IF;

Line 35162: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35158: --need to get id using task id
35159: OPEN get_task_ver_id2(l_project_id, p_pa_pred_id);
35160: FETCH get_task_Ver_id2 into l_pred_ver_id;
35161: IF get_task_ver_id2%NOTFOUND THEN
35162: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35163: p_msg_name => 'PA_PS_INV_TASK_ID');
35164: CLOSE get_task_ver_id2;
35165: RAISE FND_API.G_EXC_ERROR;
35166: END IF;

Line 35178: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35174: open get_rvn(l_task_ver_id, l_pred_ver_id);
35175: FETCH get_rvn into l_obj_rel_id, l_record_version_number;
35176: --Bug 3769066
35177: IF get_rvn%NOTFOUND THEN
35178: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35179: p_msg_name => 'PA_PS_INV_DEP_ID');
35180: RAISE FND_API.G_EXC_ERROR;
35181: END IF;
35182: CLOSE get_rvn;

Line 35804: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

35800:
35801: END IF;
35802:
35803: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id, p_structure_version_id) <> 'Y' THEN
35804: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35805: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35806:
35807: RAISE FND_API.G_EXC_ERROR;
35808: End If;

Line 35871: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

35867: ,p_structure_version_id => p_structure_version_id );
35868:
35869: IF l_process_code = 'PUE'
35870: THEN
35871: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
35872: ,p_msg_name => 'PA_PS_PUBLISH_ERROR');
35873:
35874: RAISE FND_API.G_EXC_ERROR;
35875: END IF;

Line 36555: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');

36551: close l_cur_task_ver_id;
36552:
36553: -- Validate that the task has a version in the specified structure type.
36554: if (l_task_version_id is null) then
36555: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');
36556: l_exp_error_flag := 'Y';
36557: end if;
36558:
36559: end if;

Line 36571: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');

36567: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
36568: open l_cur_project_id2(l_task_version_id);
36569: fetch l_cur_project_id2 into l_parent_project_id, l_task_id;
36570: if l_cur_project_id2%NOTFOUND then
36571: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');
36572: l_exp_error_flag := 'Y';
36573: end if;
36574: close l_cur_project_id2;
36575: end if;

Line 36629: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');

36625: end if;
36626:
36627: if (l_sub_project_id is null) then
36628:
36629: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');
36630: l_exp_error_flag := 'Y';
36631:
36632: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.
36633:

Line 36654: PA_UTILS.ADD_MESSAGE('PA','PA_PS_CANT_LINK_SUMMARY_TASK'

36650: open l_cur_task_name(l_task_version_id);
36651: fetch l_cur_task_name into l_task_name;
36652: close l_cur_task_name;
36653:
36654: PA_UTILS.ADD_MESSAGE('PA','PA_PS_CANT_LINK_SUMMARY_TASK'
36655: ,'PROJ', l_project_name
36656: ,'PROG', l_program_name
36657: ,'TASK', l_task_name);
36658:

Line 36748: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_WORKPLAN_TO_LINK'

36744: open l_cur_proj_name(l_sub_project_id);
36745: fetch l_cur_proj_name into l_project_name;
36746: close l_cur_proj_name;
36747:
36748: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_WORKPLAN_TO_LINK'
36749: ,'PROJ', l_project_name);
36750: l_exp_error_flag := 'Y';
36751:
36752: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.

Line 36762: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_FINANCIAL_TO_LINK'

36758: open l_cur_proj_name(l_sub_project_id);
36759: fetch l_cur_proj_name into l_project_name;
36760: close l_cur_proj_name;
36761:
36762: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_FINANCIAL_TO_LINK'
36763: ,'PROJ', l_project_name);
36764: l_exp_error_flag := 'Y';
36765:
36766: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.

Line 36869: PA_UTILS.ADD_MESSAGE('PA','PA_PS_GENERIC_ERROR');

36865: -- Clear all previous messages from the message stack.
36866: FND_MSG_PUB.initialize;
36867:
36868: -- Populate the generic error message.
36869: PA_UTILS.ADD_MESSAGE('PA','PA_PS_GENERIC_ERROR');
36870:
36871: -- Loop through the local pl/sql error table to populate the tokenized error messages.
36872: for l in l_prog_error_tbl.first..l_prog_error_tbl.last
36873: loop

Line 36875: PA_UTILS.ADD_MESSAGE('PA','PA_PS_TOKENIZED_ERROR'

36871: -- Loop through the local pl/sql error table to populate the tokenized error messages.
36872: for l in l_prog_error_tbl.first..l_prog_error_tbl.last
36873: loop
36874: if (l_prog_error_tbl.exists(l)) then
36875: PA_UTILS.ADD_MESSAGE('PA','PA_PS_TOKENIZED_ERROR'
36876: ,'TASKNAME',l_prog_error_tbl(l).program_name
36877: ,'TASKNUMBER',l_prog_error_tbl(l).object_relationship_id
36878: ,'ERRORMSG', l_prog_error_tbl(l).error_msg);
36879: end if;

Line 37150: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');

37146: close l_cur_task_ver_id;
37147:
37148: -- Validate that the task has a version in the specified structure type.
37149: if (l_task_version_id is null) then
37150: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');
37151: l_exp_error_flag := 'Y';
37152: end if;
37153:
37154: end if;

Line 37166: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');

37162: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37163: open l_cur_project_id2(l_task_version_id);
37164: fetch l_cur_project_id2 into l_parent_project_id, l_task_id;
37165: if l_cur_project_id2%NOTFOUND then
37166: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');
37167: l_exp_error_flag := 'Y';
37168: end if;
37169:
37170: close l_cur_project_id2;

Line 37225: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');

37221: end if;
37222:
37223: if (l_sub_project_id is null) then
37224:
37225: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');
37226: l_exp_error_flag := 'Y';
37227:
37228: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.
37229:

Line 37251: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_LINK_EXISTS'

37247: open l_cur_task_name(l_task_version_id);
37248: fetch l_cur_task_name into l_task_name;
37249: close l_cur_task_name;
37250:
37251: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_LINK_EXISTS'
37252: ,'PROJ', l_project_name
37253: ,'PROG', l_program_name
37254: ,'TASK', l_task_name
37255: ,'STR', p_program_links_tbl(l_count).structure_type);

Line 37269: PA_UTILS.ADD_MESSAGE('PA','PA_PS_INVALID_OBJ_REL_ID'

37265: open l_cur_por2(p_program_links_tbl(l_count).object_relationship_id);
37266: fetch l_cur_por2 into l_object_relationship_id, l_record_version_number, l_parent_project_id;
37267: if l_cur_por2%NOTFOUND then
37268: -- Invalid object_relationship_id.
37269: PA_UTILS.ADD_MESSAGE('PA','PA_PS_INVALID_OBJ_REL_ID'
37270: ,'OBJRELID', p_program_links_tbl(l_count).object_relationship_id);
37271:
37272: l_exp_error_flag := 'Y';
37273: end if;

Line 37450: PA_UTILS.ADD_MESSAGE('PA','PA_PS_GENERIC_ERROR');

37446: -- Clear all previous messages from the message stack.
37447: FND_MSG_PUB.initialize;
37448:
37449: -- Populate the generic error message.
37450: PA_UTILS.ADD_MESSAGE('PA','PA_PS_GENERIC_ERROR');
37451:
37452: -- Loop through the local pl/sql error table to populate the tokenized error messages.
37453: for l in l_prog_error_tbl.first..l_prog_error_tbl.last
37454: loop

Line 37456: PA_UTILS.ADD_MESSAGE('PA','PA_PS_TOKENIZED_ERROR'

37452: -- Loop through the local pl/sql error table to populate the tokenized error messages.
37453: for l in l_prog_error_tbl.first..l_prog_error_tbl.last
37454: loop
37455: if (l_prog_error_tbl.exists(l)) then
37456: PA_UTILS.ADD_MESSAGE('PA','PA_PS_TOKENIZED_ERROR'
37457: ,'TASKNAME',l_prog_error_tbl(l).program_name
37458: ,'TASKNUMBER',l_prog_error_tbl(l).object_relationship_id
37459: ,'ERRORMSG', l_prog_error_tbl(l).error_msg);
37460: end if;

Line 37686: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');

37682: close l_cur_task_ver_id;
37683:
37684: -- Validate that the task has a version in the specified structure type.
37685: if (l_task_version_id is null) then
37686: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_ID_INVALID');
37687: raise FND_API.G_EXC_ERROR;
37688: end if;
37689:
37690: -- If task version id is passed in.

Line 37697: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');

37693:
37694: open l_cur_project_id2(l_task_version_id);
37695: fetch l_cur_project_id2 into l_parent_project_id, l_task_id;
37696: if l_cur_project_id2%NOTFOUND then
37697: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_VERSION_REQUIRED');
37698: raise FND_API.G_EXC_ERROR;
37699: end if;
37700: close l_cur_project_id2;
37701:

Line 37750: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');

37746: end if;
37747:
37748: if (l_sub_project_id is null) then
37749:
37750: PA_UTILS.ADD_MESSAGE('PA','PA_INV_PROJECT_ID');
37751: raise FND_API.G_EXC_ERROR;
37752:
37753: end if;
37754:

Line 37772: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_LINK_EXISTS'

37768: open l_cur_task_name(l_task_version_id);
37769: fetch l_cur_task_name into l_task_name;
37770: close l_cur_task_name;
37771:
37772: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_LINK_EXISTS'
37773: ,'PROJ', l_project_name
37774: ,'PROG', l_program_name
37775: ,'TASK', l_task_name
37776: ,'STR', p_structure_type);

Line 37792: PA_UTILS.ADD_MESSAGE('PA','PA_PS_INVALID_OBJ_REL_ID'

37788: fetch l_cur_por2 into l_object_relationship_id, l_record_version_number, l_parent_project_id;
37789: if l_cur_por2%NOTFOUND then
37790: -- Invalid object_relationship_id.
37791:
37792: PA_UTILS.ADD_MESSAGE('PA','PA_PS_INVALID_OBJ_REL_ID'
37793: ,'OBJRELID', p_object_relationship_id);
37794:
37795: close l_cur_por2;
37796: