DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_UTILS

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

109:
110:
111: IF x_structure_id IS NULL OR l_return_status <> 'S'
112: THEN
113: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
114: ,p_msg_name => 'PA_PS_NO_STRUC_CREATED');
115: raise API_ERROR;
116: END IF;
117:

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

167: -- added for Bug fix: 4537865
168:
169: IF x_struc_version_id IS NULL
170: THEN
171: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
172: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
173: raise API_ERROR;
174: END IF;
175:

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

225: );
226:
227: IF l_return_status <> 'S'
228: THEN
229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
230: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
231: raise api_error;
232: END IF;
233: END IF;

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

381:
382:
383: savepoint create_dflt_task_struc;
384: if p_project_id is null then
385: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
386: ,p_msg_name => 'PA_NO_PROJECT_ID');
387: end if;
388:
389:

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

522: END IF;
523:
524: IF l_return_status <> 'S'
525: THEN
526: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
527: ,p_msg_name => 'PA_PS_NO_TASK_VER_CREATED');
528: raise api_error;
529: END IF;
530:

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

571: -- end xxlu changes
572:
573: IF l_return_status <> 'S'
574: THEN
575: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
576: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
577: raise api_error;
578: END IF;
579: END IF;

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

1215: ,x_error_message_code => l_msg_data
1216: );
1217: IF l_return_status <> 'S'
1218: THEN
1219: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1220: ,p_msg_name => l_msg_data );
1221: raise api_error;
1222: END IF;
1223:

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

1226: ( p_project_id => p_project_id
1227: ,p_structure_version_id => p_structure_version_id );
1228: IF l_str_status_code IS NULL
1229: THEN
1230: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1231: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1232: raise api_error;
1233: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1234: THEN

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

1231: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1232: raise api_error;
1233: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1234: THEN
1235: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1236: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1237: raise api_error;
1238: END IF;
1239: --bug 2736392

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

1249: ( p_project_id => p_project_id
1250: ,p_structure_version_id => p_structure_version_id );
1251: IF l_str_status_code IS NULL
1252: THEN
1253: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1254: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1255: raise api_error;
1256: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1257: THEN

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

1254: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1255: raise api_error;
1256: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1257: THEN
1258: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1259: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1260: raise api_error;
1261: END IF;
1262: ELSIF l_structure_version_id IS NULL

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

1265: FETCH cur_struc_ver_wp2 INTO l_dummy_num;
1266: CLOSE cur_struc_ver_wp2;
1267:
1268: IF l_dummy_num is NOT NULL THEN
1269: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1270: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1271: raise api_error;
1272: ELSE
1273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

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

1269: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1270: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1271: raise api_error;
1272: ELSE
1273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1274: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1275: raise api_error;
1276: END IF;
1277: END IF;

Line 1328: /*PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

1324: );
1325:
1326: IF l_return_status <> 'S'
1327: THEN
1328: /*PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1329: ,p_msg_name => l_msg_data );
1330: */
1331: raise api_error;
1332: END IF;

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

1560: ,x_error_message_code => l_error_msg_code
1561: );
1562:
1563: IF (l_return_status <> 'Y') THEN
1564: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1565: p_msg_name => l_error_msg_code);
1566: raise api_error;
1567: END IF;
1568: ELSE

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

1572: ,x_error_message_code => l_error_msg_code
1573: );
1574:
1575: IF (l_return_status <> 'Y') THEN
1576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1577: p_msg_name => l_error_msg_code);
1578: raise api_error;
1579: END IF;
1580: END IF;

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

1595: );
1596:
1597: IF l_return_status <> 'S'
1598: THEN
1599: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1600: ,p_msg_name => 'PA_PS_NO_TASK_VER_CREATED');
1601: raise api_error;
1602: END IF;
1603:

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

2001: CLOSE cur_pa_proj_elem_vers2;
2002:
2003: IF l_return_status <> 'S'
2004: THEN
2005: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2006: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
2007: raise api_error;
2008: END IF;
2009:

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

2650: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);
2651:
2652: IF l_return_status <> 'S'
2653: THEN
2654: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2655: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
2656: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
2657: ,p_token1 => 'PROJECT'
2658: ,p_value1 => p_project_id

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

2715: ,x_error_message_code => l_msg_data
2716: );
2717: IF l_return_status <> 'S'
2718: THEN
2719: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2720: ,p_msg_name => l_msg_data );
2721: raise api_error;
2722: END IF;
2723: --bug 2736392

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

2725: ( p_project_id => p_project_id
2726: ,p_structure_version_id => p_structure_version_id );
2727: IF l_str_status_code IS NULL
2728: THEN
2729: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2730: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2731: raise api_error;
2732: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2733: THEN

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

2730: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2731: raise api_error;
2732: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2733: THEN
2734: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2735: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2736: raise api_error;
2737: END IF;
2738: --bug 2736392

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

2746: ( p_project_id => p_project_id
2747: ,p_structure_version_id => p_structure_version_id );
2748: IF l_str_status_code IS NULL
2749: THEN
2750: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2751: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2752: raise api_error;
2753: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2754: THEN

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

2751: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2752: raise api_error;
2753: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2754: THEN
2755: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2756: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2757: raise api_error;
2758: END IF;
2759: ELSIF l_structure_version_id IS NULL

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

2762: FETCH cur_struc_ver_wp2 INTO l_dummy_num;
2763: CLOSE cur_struc_ver_wp2;
2764:
2765: IF l_dummy_num is NOT NULL THEN
2766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2767: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2768: raise api_error;
2769: ELSE
2770: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

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

2766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2767: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2768: raise api_error;
2769: ELSE
2770: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2771: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2772: raise api_error;
2773: END IF;
2774: END IF;

Line 2882: PA_UTILS.ADD_MESSAGE

2878: IF nvl(l_process_code,'-1') = 'WUP' THEN
2879:
2880: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id -- Bug 3091798
2881: ,p_structure_type => p_structure_type );
2882: PA_UTILS.ADD_MESSAGE
2883: (p_app_short_name => 'PA',
2884: -- p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC'); Bug 3091798
2885: p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
2886: p_token1 => 'REQUESTID',

Line 2894: PA_UTILS.ADD_MESSAGE

2890:
2891: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
2892: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id --Bug 3091798
2893: ,p_structure_type => p_structure_type );
2894: PA_UTILS.ADD_MESSAGE
2895: (p_app_short_name => 'PA',
2896: -- p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');
2897: p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
2898: p_token1 => 'REQUESTID',

Line 2920: PA_UTILS.ADD_MESSAGE(

2916:
2917:
2918: if l_message_name is not null then
2919:
2920: PA_UTILS.ADD_MESSAGE(
2921: p_app_short_name => 'PA'
2922: , p_msg_name => l_message_name
2923: , p_token1 => 'REQUESTID'
2924: , p_value1 => l_conc_request_id);

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

2946: );
2947:
2948: IF l_return_status <> 'S'
2949: THEN
2950: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2951: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
2952: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
2953: ,p_token1 => 'PROJECT'
2954: ,p_value1 => p_project_id

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

3264: );
3265: -- end xxlu changes ,
3266: IF l_return_status <> 'S'
3267: THEN
3268: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3269: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
3270: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
3271: ,p_token1 => 'PROJECT'
3272: ,p_value1 => p_project_id

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

3600: END IF;
3601:
3602: IF l_return_status <> 'S'
3603: THEN
3604: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3605: ,p_msg_name => 'PA_PS_TASK_NOT_DELETED');
3606: raise api_error;
3607: END IF;
3608: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3700: );
3701:
3702: IF l_return_status <> 'S'
3703: THEN
3704: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3705: ,p_msg_name => l_error_message_code);
3706: raise api_error;
3707: END IF;
3708:

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

3724: );
3725:
3726: IF l_return_status <> 'S'
3727: THEN
3728: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3729: ,p_msg_name => l_error_message_code);
3730: raise api_error;
3731: END IF;
3732:

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

4043: WHERE project_id = p_project_id;
4044:
4045: IF p_split_workplan = l_split_flag
4046: THEN
4047: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4048: ,p_msg_name => 'PA_PS_WRONG_SPLIT_OPTION');
4049: raise api_error;
4050: END IF;
4051:

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

4050: END IF;
4051:
4052: IF p_project_id IS NULL
4053: THEN
4054: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4055: ,p_msg_name => 'PA_PS_PROJ_ID_NULL');
4056: raise api_error;
4057: END IF;
4058:

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

4060: THEN
4061:
4062: IF p_project_number IS NULL OR p_project_number = 'JUNK_CHARS'
4063: THEN
4064: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4065: ,p_msg_name => 'PA_PS_INV_PROJ_NUM');
4066: raise api_error;
4067: END IF;
4068:

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

4067: END IF;
4068:
4069: IF p_project_name IS NULL OR p_project_name = 'JUNK_CHARS'
4070: THEN
4071: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4072: ,p_msg_name => 'PA_PS_INV_PROJ_NAME');
4073: raise api_error;
4074: ELSE
4075: l_name := p_project_name;

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

4190: );
4191:
4192: IF l_return_status <> 'S'
4193: THEN
4194: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4195: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
4196: raise api_error;
4197: END IF;
4198: FOR cur_pa_proj_elem_vers_rec3 IN cur_pa_proj_elem_vers3(cur_pa_proj_elem_vers_rec2.element_version_id) LOOP

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

4208: );
4209:
4210: IF l_return_status <> 'S'
4211: THEN
4212: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4213: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
4214: raise api_error;
4215: END IF;
4216: END LOOP;

Line 4761: --PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

4757: p_structure_type,
4758: l_return_status,
4759: l_error_message_code);
4760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4761: --PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4762: --,p_msg_name => l_error_message_code);
4763: --raise FND_API.G_EXC_ERROR;
4764:
4765: -- Bug 3075609. When the structure type exists we need to ignore the error.

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

4800: ,x_msg_count => l_msg_count
4801: ,x_msg_data => l_msg_data
4802: );
4803: IF x_structure_id IS NULL OR l_return_status <> 'S' THEN
4804: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4805: ,p_msg_name => 'PA_PS_NO_STRUC_CREATED');
4806: raise FND_API.G_EXC_ERROR;
4807: END IF;
4808: --Create structure version

Line 4857: PA_UTILS.ADD_MESSAGE(

4853: x_structure_version_id := l_new_structure_version_id;
4854: -- added for Bug Fix: 4537865
4855:
4856: IF x_structure_version_id IS NULL THEN
4857: PA_UTILS.ADD_MESSAGE(
4858: p_app_short_name => 'PA'
4859: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
4860: raise FND_API.G_EXC_ERROR;
4861: END IF;

Line 4922: PA_UTILS.ADD_MESSAGE(

4918: ,x_msg_data => l_msg_data
4919: );
4920:
4921: IF l_return_status <> 'S' THEN
4922: PA_UTILS.ADD_MESSAGE(
4923: p_app_short_name => 'PA'
4924: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
4925: raise FND_API.G_EXC_ERROR;
4926: END IF;

Line 5034: PA_UTILS.ADD_MESSAGE(

5030: --get structure for input type
5031: OPEN c2;
5032: FETCH c2 into l_proj_element_id;
5033: IF c2%NOTFOUND THEN
5034: PA_UTILS.ADD_MESSAGE(
5035: p_app_short_name => 'PA'
5036: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5037: CLOSE c2;
5038: RAISE FND_API.G_EXC_ERROR;

Line 5051: PA_UTILS.ADD_MESSAGE(

5047: ,p_project_id => p_project_id
5048: ,p_structure_id => l_proj_element_id
5049: ) = 'N'
5050: THEN
5051: PA_UTILS.ADD_MESSAGE(
5052: p_app_short_name => 'PA'
5053: ,p_msg_name => 'PA_PS_STRUC_VER_NAM_UNIQUE');
5054: RAISE FND_API.G_EXC_ERROR;
5055: END IF;

Line 5071: PA_UTILS.ADD_MESSAGE(

5067: FETCH c4 into l_dummy;
5068: IF (c4%FOUND) THEN
5069: --there is a working version; cannot create another one.
5070: CLOSE c4;
5071: PA_UTILS.ADD_MESSAGE(
5072: p_app_short_name => 'PA'
5073: --,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5074: ,p_msg_name => 'PA_PS_WORKING_STRUC_VER_EXIST'); --bug # 3713107
5075: RAISE FND_API.G_EXC_ERROR;

Line 5129: PA_UTILS.ADD_MESSAGE(

5125: x_structure_version_id := l_new_structure_version_id;
5126: -- added for Bug fix: 4537865
5127:
5128: IF x_structure_version_id IS NULL THEN
5129: PA_UTILS.ADD_MESSAGE(
5130: p_app_short_name => 'PA'
5131: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5132: raise FND_API.G_EXC_ERROR;
5133: END IF;

Line 5182: PA_UTILS.ADD_MESSAGE(

5178: ,x_msg_data => l_msg_data
5179: );
5180:
5181: IF l_return_status <> 'S' THEN
5182: PA_UTILS.ADD_MESSAGE(
5183: p_app_short_name => 'PA'
5184: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
5185: raise FND_API.G_EXC_ERROR;
5186: END IF;

Line 5190: PA_UTILS.ADD_MESSAGE(

5186: END IF;
5187:
5188: ELSE
5189: --a version exists. Cannot create.
5190: PA_UTILS.ADD_MESSAGE(
5191: p_app_short_name => 'PA'
5192: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5193: RAISE FND_API.G_EXC_ERROR;
5194: END IF;

Line 5201: PA_UTILS.ADD_MESSAGE(

5197: --check if this is workplan type structure only
5198: IF (PA_PROJECT_STRUCTURE_UTILS.Get_struc_Type_for_Structure(
5199: l_proj_element_id, 'FINANCIAL') = 'Y') THEN
5200: --cannot create because this structure contains financial information also
5201: PA_UTILS.ADD_MESSAGE(
5202: p_app_short_name => 'PA'
5203: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5204: RAISE FND_API.G_EXC_ERROR;
5205: END IF;

Line 5210: PA_UTILS.ADD_MESSAGE(

5206: */
5207: IF NVL( IS_WP_VERSIONING_ENABLED( p_project_id ), 'N' ) = 'N'
5208: THEN
5209: --cannot create because versioning is not enabled.
5210: PA_UTILS.ADD_MESSAGE(
5211: p_app_short_name => 'PA'
5212: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5213: RAISE FND_API.G_EXC_ERROR;
5214: END IF;

Line 5264: PA_UTILS.ADD_MESSAGE(

5260: x_structure_version_id := l_new_structure_version_id;
5261: -- added for Bug fix: 4537865
5262:
5263: IF x_structure_version_id IS NULL THEN
5264: PA_UTILS.ADD_MESSAGE(
5265: p_app_short_name => 'PA'
5266: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5267: raise FND_API.G_EXC_ERROR;
5268: END IF;

Line 5326: PA_UTILS.ADD_MESSAGE(

5322: ,x_msg_data => l_msg_data
5323: );
5324:
5325: IF l_return_status <> 'S' THEN
5326: PA_UTILS.ADD_MESSAGE(
5327: p_app_short_name => 'PA'
5328: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
5329: raise FND_API.G_EXC_ERROR;
5330: END IF;

Line 13757: PA_UTILS.ADD_MESSAGE

13753: (p_is_wp_versioning_enabled IS NULL)OR
13754: (p_process_mode IS NULL)
13755: THEN
13756:
13757: PA_UTILS.ADD_MESSAGE
13758: (p_app_short_name => 'PA',
13759: p_msg_name => 'PA_INV_PARAM_PASSED'); -- Bug 2955589. Changed the message name to
13760: RAISE Invalid_Arg_Exc_WP; -- have a generic message.
13761:

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

13817: -- ,p_attribute5 => '');
13818: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id -- Bug 3091798
13819: ,p_structure_type => p_structure_type );
13820:
13821: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
13822: -- ,p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC');Bug 3091798.
13823: ,p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
13824: p_token1 => 'REQUESTID',
13825: p_value1 => l_request_id);

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

13844: -- ,p_attribute2 => ''
13845: -- ,p_attribute3 => ''
13846: -- ,p_attribute4 => ''
13847: -- ,p_attribute5 => '');
13848: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
13849: -- ,p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');Bug 3091798.
13850: ,p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
13851: p_token1 => 'REQUESTID',
13852: p_value1 => l_request_id);

Line 13873: PA_UTILS.ADD_MESSAGE(

13869:
13870:
13871: if l_message_name is not null then
13872:
13873: PA_UTILS.ADD_MESSAGE(
13874: p_app_short_name => 'PA'
13875: , p_msg_name => l_message_name
13876: , p_token1 => 'REQUESTID'
13877: , p_value1 => l_conc_request_id);

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

13891: p_project_id => p_project_id
13892: ,p_structure_version_id => p_structure_version_id );
13893: IF l_str_status_code IS NULL
13894: THEN
13895: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
13896: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
13897: raise Invalid_Arg_Exc_WP;
13898: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
13899: THEN

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

13896: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
13897: raise Invalid_Arg_Exc_WP;
13898: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
13899: THEN
13900: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
13901: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
13902: raise Invalid_Arg_Exc_WP;
13903: END IF;
13904:

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

14298: RAISE Invalid_Arg_Exc_WP;
14299: END IF;
14300: --rtarway, for DHI ER, BUG 4413568
14301: IF (PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
14302: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14303: p_msg_name => 'PA_WBS_CANT_CHANGE');
14304: RAISE Invalid_Arg_Exc_WP;
14305: END IF;
14306: -- task reference and task names need to be validated only for workplan cases. For financial cases

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

14866:
14867: px_tasks_out_tbl(i).return_status := x_return_status;
14868:
14869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14870: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14871: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
14872: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
14873: ,p_token1 => 'PROJECT'
14874: ,p_value1 => p_project_id

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

14971: );
14972: px_tasks_out_tbl(i).return_status := x_return_status;
14973:
14974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14975: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14976: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
14977: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
14978: ,p_token1 => 'PROJECT'
14979: ,p_value1 => p_project_id

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

15047: l_hierarchy_count := l_hierarchy_count +1;
15048: ELSE
15049: IF l_parent_task_id IS NOT NULL THEN
15050:
15051: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15052: ,p_msg_name => 'PA_TASK_NOT_IN_HIERARCHY_ORD'
15053: ,p_token1 => 'TASK'
15054: ,p_value1 => l_err_task_number); Raise Invalid_Arg_Exc_WP;
15055: Raise Invalid_Arg_Exc_WP;

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

15091: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
15092: END IF;
15093:
15094: IF l_temp_success = 'F' THEN
15095: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15096: ,p_msg_name => 'PA_TASK_NOT_IN_HIERARCHY_ORD'
15097: ,p_token1 => 'TASK'
15098: ,p_value1 => l_err_task_number);
15099: Raise Invalid_Arg_Exc_WP;

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

15589: END IF;
15590:
15591: x_return_status := FND_API.G_RET_STS_ERROR;
15592: px_tasks_out_tbl(i).return_status := x_return_status;
15593: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15594: p_msg_name => l_error_msg_code);
15595: Raise Invalid_Arg_Exc_WP;
15596: END IF;
15597: END IF; --l_parent_task_id IS NOT NULL

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

15626: IF (l_parent_task_version_id <> l_db_parent_task_version_id)
15627: THEN
15628: --rtarway, for DHI ER, BUG 4413568
15629: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
15630: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15631: p_msg_name => 'PA_WBS_CANT_CHANGE');
15632: RAISE Invalid_Arg_Exc_WP;
15633: END IF;
15634: -- Lifecycle Phase validation . Check if task has phase associated with it

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

15633: END IF;
15634: -- Lifecycle Phase validation . Check if task has phase associated with it
15635: IF (pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(l_task_in_rec.pa_task_id) = 'Y')
15636: THEN
15637: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15638: p_msg_name => 'PA_LC_NO_MOVE_PHASE_TASK');
15639: RAISE Invalid_Arg_Exc_WP;
15640: END IF;
15641:

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

15645: ,x_return_status => x_return_status
15646: ,x_error_message_code => x_msg_data
15647: );
15648: IF (x_return_status <> 'Y') THEN
15649: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15650: p_msg_name => x_msg_data);
15651: raise Invalid_Arg_Exc_WP;
15652: END IF;
15653:

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

15656: p_parent_task_ver_id => l_parent_task_version_id
15657: ,x_return_status => x_return_status
15658: ,x_error_message_code => x_msg_data);
15659: IF (x_return_status <> 'Y') THEN
15660: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15661: p_msg_name => x_msg_data);
15662: raise Invalid_Arg_Exc_WP;
15663: END IF;
15664: END IF;

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

15814: AND record_version_number = l_proj_elem_ver_rvn
15815: FOR UPDATE OF record_version_number NOWAIT;
15816: EXCEPTION
15817: WHEN TIMEOUT_ON_RESOURCE THEN
15818: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15819: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
15820: raise Invalid_Arg_Exc_WP;
15821: WHEN NO_DATA_FOUND THEN
15822: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

15818: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15819: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
15820: raise Invalid_Arg_Exc_WP;
15821: WHEN NO_DATA_FOUND THEN
15822: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15823: p_msg_name => 'PA_XC_RECORD_CHANGED');
15824: raise Invalid_Arg_Exc_WP;
15825: WHEN OTHERS THEN
15826: IF SQLCODE = -54 then

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

15823: p_msg_name => 'PA_XC_RECORD_CHANGED');
15824: raise Invalid_Arg_Exc_WP;
15825: WHEN OTHERS THEN
15826: IF SQLCODE = -54 then
15827: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15828: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
15829: raise Invalid_Arg_Exc_WP;
15830: ELSE
15831: raise;

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

15970: -- px_tasks_out_tbl(i).return_status
15971: --rtarway, for DHI ER, BUG 4413568
15972: /*
15973: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
15974: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15975: p_msg_name => 'PA_WBS_CANT_CHANGE');
15976: RAISE Invalid_Arg_Exc_WP;
15977: END IF;
15978: This code is not required here. */

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

16228: pa_debug.g_err_stage := 'Error calling create schedule version : ' || l_task_version_id ;
16229: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16230: END IF;
16231:
16232: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
16233: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
16234: RAISE Invalid_Arg_Exc_WP;
16235: END IF;
16236:

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

16376: pa_debug.g_err_stage := 'Error calling update schedule version : ' || l_task_version_id ;
16377: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16378: END IF;
16379:
16380: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
16381: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
16382: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
16383: ,p_token1 => 'PROJECT'
16384: ,p_value1 => p_project_id

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

16505: OPEN cur_ver_id_to_task_num(row_task_ver_id.element_version_id);
16506: FETCH cur_ver_id_to_task_num INTO l_err_task_number;
16507: CLOSE cur_ver_id_to_task_num;
16508:
16509: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
16510: ,p_msg_name => 'PA_TASK_MISS_IN_HIERARCHY_ORD'
16511: ,p_token1 => 'TASK'
16512: ,p_value1 => l_err_task_number);
16513:

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

17532: CLOSE c_get_process_code;
17533:
17534: IF p_calling_context = 'UPDATE' AND l_process_code = 'PUE'
17535: THEN
17536: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
17537: ,p_msg_name => 'PA_PS_PUBLISH_ERROR');
17538:
17539: RAISE Invalid_Arg_Exc_WP;
17540: END IF;

Line 17581: PA_UTILS.ADD_MESSAGE

17577: -- Throw an error if any of the mandatory parameter is NULL.
17578: IF (p_project_id IS NULL) OR
17579: (p_structure_version_id IS NULL)
17580: THEN
17581: PA_UTILS.ADD_MESSAGE
17582: (p_app_short_name => 'PA',
17583: p_msg_name => 'PA_INV_PARAM_PASSED');
17584: RAISE Invalid_Arg_Exc_WP;
17585: END IF;

Line 17862: PA_UTILS.ADD_MESSAGE

17858: -- Throw an error if any of the mandatory parameter is NULL.
17859: IF (p_project_id IS NULL) OR
17860: (p_structure_version_id IS NULL)
17861: THEN
17862: PA_UTILS.ADD_MESSAGE
17863: (p_app_short_name => 'PA',
17864: p_msg_name => 'PA_INV_PARAM_PASSED');
17865: RAISE Invalid_Arg_Exc_WP;
17866: END IF;

Line 17968: PA_UTILS.ADD_MESSAGE

17964: END IF;
17965:
17966: -- Throw an error if the request could not be submitted.
17967: IF l_request_id = 0 THEN
17968: PA_UTILS.ADD_MESSAGE
17969: (p_app_short_name => 'PA',
17970: p_msg_name => 'PA_WP_TW_CONC_PGM_ERR');
17971: RAISE Invalid_Arg_Exc_WP;
17972: END IF;

Line 18180: PA_UTILS.ADD_MESSAGE

18176: IF l_debug_mode = 'Y' THEN
18177: pa_debug.g_err_stage:= 'Some of the mandatory parameters to this API are NULL';
18178: pa_debug.log_message(p_message => pa_debug.g_err_stage);
18179: END IF;
18180: PA_UTILS.ADD_MESSAGE
18181: (p_app_short_name => 'PA',
18182: p_msg_name => 'PA_INV_PARAM_PASSED');
18183: RAISE Invalid_Arg_Exc_WP;
18184: END IF;

Line 18601: PA_UTILS.ADD_MESSAGE

18597: END IF;
18598:
18599: -- Throw an error if any of the mandatory parameter is NULL.
18600: IF (p_project_id IS NULL) OR (p_structure_version_id IS NULL) THEN
18601: PA_UTILS.ADD_MESSAGE
18602: (p_app_short_name => 'PA',
18603: p_msg_name => 'PA_INV_PARAM_PASSED');
18604: RAISE Invalid_Arg_Exc_WP;
18605: END IF;

Line 20526: PA_UTILS.ADD_MESSAGE

20522:
20523: IF (p_project_id IS NULL) OR
20524: (p_structure_version_id IS NULL)
20525: THEN
20526: PA_UTILS.ADD_MESSAGE
20527: (p_app_short_name => 'PA',
20528: p_msg_name => 'PA_INV_PARAM_PASSED');
20529: RAISE Invalid_Arg_Exc_WP;
20530: END IF;

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

20573: EXCEPTION
20574: WHEN OTHERS THEN
20575: IF SQLCODE = -54 THEN
20576: -- If the record have already been locked, then the sql code would be -54.
20577: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
20578: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
20579: RAISE Invalid_Arg_Exc_WP;
20580: ELSE
20581: raise;

Line 20950: PA_UTILS.ADD_MESSAGE

20946: IF (p_project_id IS NULL) OR
20947: (p_structure_version_id IS NULL) OR
20948: (p_update_wbs_flag not in ('Y','N'))
20949: THEN
20950: PA_UTILS.ADD_MESSAGE
20951: (p_app_short_name => 'PA',
20952: p_msg_name => 'PA_INV_PARAM_PASSED');
20953: RAISE Invalid_Arg_Exc_WP;
20954: END IF;

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

21396: x_project_id => l_project_id,
21397: x_return_status => l_return_status,
21398: x_error_msg_code => l_error_msg_code);
21399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
21400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
21401: p_msg_name => l_error_msg_code);
21402: RAISE API_ERROR;
21403: END IF;
21404: END IF;

Line 21435: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);

21431: ,x_return_status => l_return_status
21432: ,x_error_msg_code => l_error_msg_code);
21433:
21434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
21435: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
21436: RAISE API_ERROR;
21437: END IF;
21438: END IF;
21439:

Line 21448: PA_UTILS.ADD_MESSAGE

21444: 'PA_PAXPREPR_OPT_WORKPLAN_STR',
21445: 'PA_PROJECTS',
21446: l_project_id
21447: ) THEN
21448: PA_UTILS.ADD_MESSAGE
21449: (p_app_short_name => 'PA',
21450: p_msg_name => 'PA_FUNCTION_SECURITY_ENFORCED');
21451: RAISE API_ERROR;
21452: END IF;