DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_UTILS

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

325:
326:
327: IF x_structure_id IS NULL OR l_return_status <> 'S'
328: THEN
329: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
330: ,p_msg_name => 'PA_PS_NO_STRUC_CREATED');
331: raise API_ERROR;
332: END IF;
333:

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

383: -- added for Bug fix: 4537865
384:
385: IF x_struc_version_id IS NULL
386: THEN
387: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
388: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
389: raise API_ERROR;
390: END IF;
391:

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

441: );
442:
443: IF l_return_status <> 'S'
444: THEN
445: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
446: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
447: raise api_error;
448: END IF;
449: END IF;

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

597:
598:
599: savepoint create_dflt_task_struc;
600: if p_project_id is null then
601: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
602: ,p_msg_name => 'PA_NO_PROJECT_ID');
603: end if;
604:
605:

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

738: END IF;
739:
740: IF l_return_status <> 'S'
741: THEN
742: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
743: ,p_msg_name => 'PA_PS_NO_TASK_VER_CREATED');
744: raise api_error;
745: END IF;
746:

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

787: -- end xxlu changes
788:
789: IF l_return_status <> 'S'
790: THEN
791: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
792: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
793: raise api_error;
794: END IF;
795: END IF;

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

1431: ,x_error_message_code => l_msg_data
1432: );
1433: IF l_return_status <> 'S'
1434: THEN
1435: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1436: ,p_msg_name => l_msg_data );
1437: raise api_error;
1438: END IF;
1439:

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

1442: ( p_project_id => p_project_id
1443: ,p_structure_version_id => p_structure_version_id );
1444: IF l_str_status_code IS NULL
1445: THEN
1446: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1447: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1448: raise api_error;
1449: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1450: THEN

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

1447: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1448: raise api_error;
1449: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1450: THEN
1451: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1452: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1453: raise api_error;
1454: END IF;
1455: --bug 2736392

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

1465: ( p_project_id => p_project_id
1466: ,p_structure_version_id => p_structure_version_id );
1467: IF l_str_status_code IS NULL
1468: THEN
1469: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1470: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1471: raise api_error;
1472: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1473: THEN

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

1470: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1471: raise api_error;
1472: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
1473: THEN
1474: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1475: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1476: raise api_error;
1477: END IF;
1478: ELSIF l_structure_version_id IS NULL

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

1481: FETCH cur_struc_ver_wp2 INTO l_dummy_num;
1482: CLOSE cur_struc_ver_wp2;
1483:
1484: IF l_dummy_num is NOT NULL THEN
1485: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1486: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1487: raise api_error;
1488: ELSE
1489: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

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

1485: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1486: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
1487: raise api_error;
1488: ELSE
1489: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1490: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
1491: raise api_error;
1492: END IF;
1493: END IF;

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

1540: );
1541:
1542: IF l_return_status <> 'S'
1543: THEN
1544: /*PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1545: ,p_msg_name => l_msg_data );
1546: */
1547: raise api_error;
1548: END IF;

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

1776: ,x_error_message_code => l_error_msg_code
1777: );
1778:
1779: IF (l_return_status <> 'Y') THEN
1780: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1781: p_msg_name => l_error_msg_code);
1782: raise api_error;
1783: END IF;
1784: ELSE

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

1788: ,x_error_message_code => l_error_msg_code
1789: );
1790:
1791: IF (l_return_status <> 'Y') THEN
1792: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1793: p_msg_name => l_error_msg_code);
1794: raise api_error;
1795: END IF;
1796: END IF;

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

1811: );
1812:
1813: IF l_return_status <> 'S'
1814: THEN
1815: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1816: ,p_msg_name => 'PA_PS_NO_TASK_VER_CREATED');
1817: raise api_error;
1818: END IF;
1819:

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

2217: CLOSE cur_pa_proj_elem_vers2;
2218:
2219: IF l_return_status <> 'S'
2220: THEN
2221: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2222: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
2223: raise api_error;
2224: END IF;
2225:

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

2868: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);
2869:
2870: IF l_return_status <> 'S'
2871: THEN
2872: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2873: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
2874: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
2875: ,p_token1 => 'PROJECT'
2876: ,p_value1 => p_project_id

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

2933: ,x_error_message_code => l_msg_data
2934: );
2935: IF l_return_status <> 'S'
2936: THEN
2937: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2938: ,p_msg_name => l_msg_data );
2939: raise api_error;
2940: END IF;
2941: --bug 2736392

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

2943: ( p_project_id => p_project_id
2944: ,p_structure_version_id => p_structure_version_id );
2945: IF l_str_status_code IS NULL
2946: THEN
2947: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2948: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2949: raise api_error;
2950: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2951: THEN

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

2948: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2949: raise api_error;
2950: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2951: THEN
2952: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2953: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2954: raise api_error;
2955: END IF;
2956: --bug 2736392

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

2964: ( p_project_id => p_project_id
2965: ,p_structure_version_id => p_structure_version_id );
2966: IF l_str_status_code IS NULL
2967: THEN
2968: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2969: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2970: raise api_error;
2971: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2972: THEN

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

2969: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2970: raise api_error;
2971: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
2972: THEN
2973: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2974: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2975: raise api_error;
2976: END IF;
2977: ELSIF l_structure_version_id IS NULL

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

2980: FETCH cur_struc_ver_wp2 INTO l_dummy_num;
2981: CLOSE cur_struc_ver_wp2;
2982:
2983: IF l_dummy_num is NOT NULL THEN
2984: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2985: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2986: raise api_error;
2987: ELSE
2988: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

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

2984: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2985: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
2986: raise api_error;
2987: ELSE
2988: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2989: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
2990: raise api_error;
2991: END IF;
2992: END IF;

Line 3100: PA_UTILS.ADD_MESSAGE

3096: IF nvl(l_process_code,'-1') = 'WUP' THEN
3097:
3098: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id -- Bug 3091798
3099: ,p_structure_type => p_structure_type );
3100: PA_UTILS.ADD_MESSAGE
3101: (p_app_short_name => 'PA',
3102: -- p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC'); Bug 3091798
3103: p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
3104: p_token1 => 'REQUESTID',

Line 3112: PA_UTILS.ADD_MESSAGE

3108:
3109: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
3110: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id --Bug 3091798
3111: ,p_structure_type => p_structure_type );
3112: PA_UTILS.ADD_MESSAGE
3113: (p_app_short_name => 'PA',
3114: -- p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');
3115: p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
3116: p_token1 => 'REQUESTID',

Line 3138: PA_UTILS.ADD_MESSAGE(

3134:
3135:
3136: if l_message_name is not null then
3137:
3138: PA_UTILS.ADD_MESSAGE(
3139: p_app_short_name => 'PA'
3140: , p_msg_name => l_message_name
3141: , p_token1 => 'REQUESTID'
3142: , p_value1 => l_conc_request_id);

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

3164: );
3165:
3166: IF l_return_status <> 'S'
3167: THEN
3168: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3169: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
3170: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
3171: ,p_token1 => 'PROJECT'
3172: ,p_value1 => p_project_id

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

3482: );
3483: -- end xxlu changes ,
3484: IF l_return_status <> 'S'
3485: THEN
3486: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3487: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
3488: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
3489: ,p_token1 => 'PROJECT'
3490: ,p_value1 => p_project_id

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

3821: END IF;
3822:
3823: IF l_return_status <> 'S'
3824: THEN
3825: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3826: ,p_msg_name => 'PA_PS_TASK_NOT_DELETED');
3827: raise api_error;
3828: END IF;
3829: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3921: );
3922:
3923: IF l_return_status <> 'S'
3924: THEN
3925: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3926: ,p_msg_name => l_error_message_code);
3927: raise api_error;
3928: END IF;
3929:

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

3945: );
3946:
3947: IF l_return_status <> 'S'
3948: THEN
3949: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3950: ,p_msg_name => l_error_message_code);
3951: raise api_error;
3952: END IF;
3953:

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

4264: WHERE project_id = p_project_id;
4265:
4266: IF p_split_workplan = l_split_flag
4267: THEN
4268: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4269: ,p_msg_name => 'PA_PS_WRONG_SPLIT_OPTION');
4270: raise api_error;
4271: END IF;
4272:

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

4271: END IF;
4272:
4273: IF p_project_id IS NULL
4274: THEN
4275: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4276: ,p_msg_name => 'PA_PS_PROJ_ID_NULL');
4277: raise api_error;
4278: END IF;
4279:

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

4281: THEN
4282:
4283: IF p_project_number IS NULL OR p_project_number = 'JUNK_CHARS'
4284: THEN
4285: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4286: ,p_msg_name => 'PA_PS_INV_PROJ_NUM');
4287: raise api_error;
4288: END IF;
4289:

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

4288: END IF;
4289:
4290: IF p_project_name IS NULL OR p_project_name = 'JUNK_CHARS'
4291: THEN
4292: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4293: ,p_msg_name => 'PA_PS_INV_PROJ_NAME');
4294: raise api_error;
4295: ELSE
4296: l_name := p_project_name;

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

4411: );
4412:
4413: IF l_return_status <> 'S'
4414: THEN
4415: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4416: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
4417: raise api_error;
4418: END IF;
4419: FOR cur_pa_proj_elem_vers_rec3 IN cur_pa_proj_elem_vers3(cur_pa_proj_elem_vers_rec2.element_version_id) LOOP

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

4429: );
4430:
4431: IF l_return_status <> 'S'
4432: THEN
4433: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4434: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
4435: raise api_error;
4436: END IF;
4437: END LOOP;

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

4978: p_structure_type,
4979: l_return_status,
4980: l_error_message_code);
4981: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4982: --PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
4983: --,p_msg_name => l_error_message_code);
4984: --raise FND_API.G_EXC_ERROR;
4985:
4986: -- Bug 3075609. When the structure type exists we need to ignore the error.

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

5021: ,x_msg_count => l_msg_count
5022: ,x_msg_data => l_msg_data
5023: );
5024: IF x_structure_id IS NULL OR l_return_status <> 'S' THEN
5025: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5026: ,p_msg_name => 'PA_PS_NO_STRUC_CREATED');
5027: raise FND_API.G_EXC_ERROR;
5028: END IF;
5029: --Create structure version

Line 5078: PA_UTILS.ADD_MESSAGE(

5074: x_structure_version_id := l_new_structure_version_id;
5075: -- added for Bug Fix: 4537865
5076:
5077: IF x_structure_version_id IS NULL THEN
5078: PA_UTILS.ADD_MESSAGE(
5079: p_app_short_name => 'PA'
5080: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5081: raise FND_API.G_EXC_ERROR;
5082: END IF;

Line 5143: PA_UTILS.ADD_MESSAGE(

5139: ,x_msg_data => l_msg_data
5140: );
5141:
5142: IF l_return_status <> 'S' THEN
5143: PA_UTILS.ADD_MESSAGE(
5144: p_app_short_name => 'PA'
5145: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
5146: raise FND_API.G_EXC_ERROR;
5147: END IF;

Line 5255: PA_UTILS.ADD_MESSAGE(

5251: --get structure for input type
5252: OPEN c2;
5253: FETCH c2 into l_proj_element_id;
5254: IF c2%NOTFOUND THEN
5255: PA_UTILS.ADD_MESSAGE(
5256: p_app_short_name => 'PA'
5257: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5258: CLOSE c2;
5259: RAISE FND_API.G_EXC_ERROR;

Line 5272: PA_UTILS.ADD_MESSAGE(

5268: ,p_project_id => p_project_id
5269: ,p_structure_id => l_proj_element_id
5270: ) = 'N'
5271: THEN
5272: PA_UTILS.ADD_MESSAGE(
5273: p_app_short_name => 'PA'
5274: ,p_msg_name => 'PA_PS_STRUC_VER_NAM_UNIQUE');
5275: RAISE FND_API.G_EXC_ERROR;
5276: END IF;

Line 5292: PA_UTILS.ADD_MESSAGE(

5288: FETCH c4 into l_dummy;
5289: IF (c4%FOUND) THEN
5290: --there is a working version; cannot create another one.
5291: CLOSE c4;
5292: PA_UTILS.ADD_MESSAGE(
5293: p_app_short_name => 'PA'
5294: --,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5295: ,p_msg_name => 'PA_PS_WORKING_STRUC_VER_EXIST'); --bug # 3713107
5296: RAISE FND_API.G_EXC_ERROR;

Line 5350: PA_UTILS.ADD_MESSAGE(

5346: x_structure_version_id := l_new_structure_version_id;
5347: -- added for Bug fix: 4537865
5348:
5349: IF x_structure_version_id IS NULL THEN
5350: PA_UTILS.ADD_MESSAGE(
5351: p_app_short_name => 'PA'
5352: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5353: raise FND_API.G_EXC_ERROR;
5354: END IF;

Line 5403: PA_UTILS.ADD_MESSAGE(

5399: ,x_msg_data => l_msg_data
5400: );
5401:
5402: IF l_return_status <> 'S' THEN
5403: PA_UTILS.ADD_MESSAGE(
5404: p_app_short_name => 'PA'
5405: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
5406: raise FND_API.G_EXC_ERROR;
5407: END IF;

Line 5411: PA_UTILS.ADD_MESSAGE(

5407: END IF;
5408:
5409: ELSE
5410: --a version exists. Cannot create.
5411: PA_UTILS.ADD_MESSAGE(
5412: p_app_short_name => 'PA'
5413: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5414: RAISE FND_API.G_EXC_ERROR;
5415: END IF;

Line 5422: PA_UTILS.ADD_MESSAGE(

5418: --check if this is workplan type structure only
5419: IF (PA_PROJECT_STRUCTURE_UTILS.Get_struc_Type_for_Structure(
5420: l_proj_element_id, 'FINANCIAL') = 'Y') THEN
5421: --cannot create because this structure contains financial information also
5422: PA_UTILS.ADD_MESSAGE(
5423: p_app_short_name => 'PA'
5424: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5425: RAISE FND_API.G_EXC_ERROR;
5426: END IF;

Line 5431: PA_UTILS.ADD_MESSAGE(

5427: */
5428: IF NVL( IS_WP_VERSIONING_ENABLED( p_project_id ), 'N' ) = 'N'
5429: THEN
5430: --cannot create because versioning is not enabled.
5431: PA_UTILS.ADD_MESSAGE(
5432: p_app_short_name => 'PA'
5433: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;

Line 5485: PA_UTILS.ADD_MESSAGE(

5481: x_structure_version_id := l_new_structure_version_id;
5482: -- added for Bug fix: 4537865
5483:
5484: IF x_structure_version_id IS NULL THEN
5485: PA_UTILS.ADD_MESSAGE(
5486: p_app_short_name => 'PA'
5487: ,p_msg_name => 'PA_PS_NO_STRUC_VER_CREATED');
5488: raise FND_API.G_EXC_ERROR;
5489: END IF;

Line 5547: PA_UTILS.ADD_MESSAGE(

5543: ,x_msg_data => l_msg_data
5544: );
5545:
5546: IF l_return_status <> 'S' THEN
5547: PA_UTILS.ADD_MESSAGE(
5548: p_app_short_name => 'PA'
5549: ,p_msg_name => 'PA_PS_NO_STRUC_SCH_VER_CREATED');
5550: raise FND_API.G_EXC_ERROR;
5551: END IF;

Line 14262: PA_UTILS.ADD_MESSAGE

14258: (p_is_wp_versioning_enabled IS NULL)OR
14259: (p_process_mode IS NULL)
14260: THEN
14261:
14262: PA_UTILS.ADD_MESSAGE
14263: (p_app_short_name => 'PA',
14264: p_msg_name => 'PA_INV_PARAM_PASSED'); -- Bug 2955589. Changed the message name to
14265: RAISE Invalid_Arg_Exc_WP; -- have a generic message.
14266:

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

14322: -- ,p_attribute5 => '');
14323: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => p_project_id -- Bug 3091798
14324: ,p_structure_type => p_structure_type );
14325:
14326: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14327: -- ,p_msg_name => 'PA_PS_VD_UPDWBS_PRC_INPROC');Bug 3091798.
14328: ,p_msg_name => 'PA_PS_UPDWBS_PRC_INPROC_AMG', -- Bug 3091798. Message includes the request id.
14329: p_token1 => 'REQUESTID',
14330: p_value1 => l_request_id);

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

14349: -- ,p_attribute2 => ''
14350: -- ,p_attribute3 => ''
14351: -- ,p_attribute4 => ''
14352: -- ,p_attribute5 => '');
14353: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14354: -- ,p_msg_name => 'PA_PS_VD_UPD_WBS_PRC_ERR');Bug 3091798.
14355: ,p_msg_name => 'PA_PS_UPDWBS_PRC_ERR_AMG', -- Bug 3091798. Message includes the request id.
14356: p_token1 => 'REQUESTID',
14357: p_value1 => l_request_id);

Line 14378: PA_UTILS.ADD_MESSAGE(

14374:
14375:
14376: if l_message_name is not null then
14377:
14378: PA_UTILS.ADD_MESSAGE(
14379: p_app_short_name => 'PA'
14380: , p_msg_name => l_message_name
14381: , p_token1 => 'REQUESTID'
14382: , p_value1 => l_conc_request_id);

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

14396: p_project_id => p_project_id
14397: ,p_structure_version_id => p_structure_version_id );
14398: IF l_str_status_code IS NULL
14399: THEN
14400: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14401: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
14402: raise Invalid_Arg_Exc_WP;
14403: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
14404: THEN

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

14401: ,p_msg_name => 'PA_PS_INV_STR_VER_ID' );
14402: raise Invalid_Arg_Exc_WP;
14403: ELSIF l_str_status_code in ( 'STRUCTURE_SUBMITTED', 'STRUCTURE_REJECTED', 'STRUCTURE_APPROVED' )
14404: THEN
14405: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
14406: ,p_msg_name => 'PA_PS_INV_STR_VER_ID2' );
14407: raise Invalid_Arg_Exc_WP;
14408: END IF;
14409:

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

14805: RAISE Invalid_Arg_Exc_WP;
14806: END IF;
14807: --rtarway, for DHI ER, BUG 4413568
14808: IF (PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
14809: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14810: p_msg_name => 'PA_WBS_CANT_CHANGE');
14811: RAISE Invalid_Arg_Exc_WP;
14812: END IF;
14813: -- task reference and task names need to be validated only for workplan cases. For financial cases

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

15394:
15395: px_tasks_out_tbl(i).return_status := x_return_status;
15396:
15397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
15398: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15399: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
15400: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
15401: ,p_token1 => 'PROJECT'
15402: ,p_value1 => p_project_id

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

15549: );
15550: px_tasks_out_tbl(i).return_status := x_return_status;
15551:
15552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
15553: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15554: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
15555: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
15556: ,p_token1 => 'PROJECT'
15557: ,p_value1 => p_project_id

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

15625: l_hierarchy_count := l_hierarchy_count +1;
15626: ELSE
15627: IF l_parent_task_id IS NOT NULL THEN
15628:
15629: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15630: ,p_msg_name => 'PA_TASK_NOT_IN_HIERARCHY_ORD'
15631: ,p_token1 => 'TASK'
15632: ,p_value1 => l_err_task_number); Raise Invalid_Arg_Exc_WP;
15633: Raise Invalid_Arg_Exc_WP;

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

15669: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
15670: END IF;
15671:
15672: IF l_temp_success = 'F' THEN
15673: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
15674: ,p_msg_name => 'PA_TASK_NOT_IN_HIERARCHY_ORD'
15675: ,p_token1 => 'TASK'
15676: ,p_value1 => l_err_task_number);
15677: Raise Invalid_Arg_Exc_WP;

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

16167: END IF;
16168:
16169: x_return_status := FND_API.G_RET_STS_ERROR;
16170: px_tasks_out_tbl(i).return_status := x_return_status;
16171: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16172: p_msg_name => l_error_msg_code);
16173: Raise Invalid_Arg_Exc_WP;
16174: END IF;
16175: END IF; --l_parent_task_id IS NOT NULL

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

16204: IF (l_parent_task_version_id <> l_db_parent_task_version_id)
16205: THEN
16206: --rtarway, for DHI ER, BUG 4413568
16207: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
16208: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16209: p_msg_name => 'PA_WBS_CANT_CHANGE');
16210: RAISE Invalid_Arg_Exc_WP;
16211: END IF;
16212: -- Lifecycle Phase validation . Check if task has phase associated with it

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

16211: END IF;
16212: -- Lifecycle Phase validation . Check if task has phase associated with it
16213: IF (pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(l_task_in_rec.pa_task_id) = 'Y')
16214: THEN
16215: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16216: p_msg_name => 'PA_LC_NO_MOVE_PHASE_TASK');
16217: RAISE Invalid_Arg_Exc_WP;
16218: END IF;
16219:

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

16223: ,x_return_status => x_return_status
16224: ,x_error_message_code => x_msg_data
16225: );
16226: IF (x_return_status <> 'Y') THEN
16227: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16228: p_msg_name => x_msg_data);
16229: raise Invalid_Arg_Exc_WP;
16230: END IF;
16231:

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

16234: p_parent_task_ver_id => l_parent_task_version_id
16235: ,x_return_status => x_return_status
16236: ,x_error_message_code => x_msg_data);
16237: IF (x_return_status <> 'Y') THEN
16238: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16239: p_msg_name => x_msg_data);
16240: raise Invalid_Arg_Exc_WP;
16241: END IF;
16242: END IF;

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

16392: AND record_version_number = l_proj_elem_ver_rvn
16393: FOR UPDATE OF record_version_number NOWAIT;
16394: EXCEPTION
16395: WHEN TIMEOUT_ON_RESOURCE THEN
16396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16397: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
16398: raise Invalid_Arg_Exc_WP;
16399: WHEN NO_DATA_FOUND THEN
16400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

16396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16397: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
16398: raise Invalid_Arg_Exc_WP;
16399: WHEN NO_DATA_FOUND THEN
16400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16401: p_msg_name => 'PA_XC_RECORD_CHANGED');
16402: raise Invalid_Arg_Exc_WP;
16403: WHEN OTHERS THEN
16404: IF SQLCODE = -54 then

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

16401: p_msg_name => 'PA_XC_RECORD_CHANGED');
16402: raise Invalid_Arg_Exc_WP;
16403: WHEN OTHERS THEN
16404: IF SQLCODE = -54 then
16405: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16406: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
16407: raise Invalid_Arg_Exc_WP;
16408: ELSE
16409: raise;

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

16548: -- px_tasks_out_tbl(i).return_status
16549: --rtarway, for DHI ER, BUG 4413568
16550: /*
16551: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
16552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16553: p_msg_name => 'PA_WBS_CANT_CHANGE');
16554: RAISE Invalid_Arg_Exc_WP;
16555: END IF;
16556: This code is not required here. */

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

16806: pa_debug.g_err_stage := 'Error calling create schedule version : ' || l_task_version_id ;
16807: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16808: END IF;
16809:
16810: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
16811: ,p_msg_name => 'PA_PS_NO_TASK_SCH_VER_CREATED');
16812: RAISE Invalid_Arg_Exc_WP;
16813: END IF;
16814:

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

16953: pa_debug.g_err_stage := 'Error calling update schedule version : ' || l_task_version_id ;
16954: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16955: END IF;
16956:
16957: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
16958: ,p_msg_name => 'PA_PS_TASK_NOT_UPDATED'
16959: /* ADDED PROJECT_ID AND TASK_ID TOKENS FOR BUG 4219451 */
16960: ,p_token1 => 'PROJECT'
16961: ,p_value1 => p_project_id

Line 17073: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);

17069: x_msg_count => l_msg_count,
17070: x_msg_data => l_msg_data);
17071:
17072: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
17073: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);
17074: END IF;
17075:
17076: END IF;
17077:

Line 17091: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);

17087: x_msg_count => l_msg_count,
17088: x_msg_data => l_msg_data);
17089:
17090: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
17091: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);
17092: END IF;
17093:
17094: END IF;
17095:

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

17152: OPEN cur_ver_id_to_task_num(row_task_ver_id.element_version_id);
17153: FETCH cur_ver_id_to_task_num INTO l_err_task_number;
17154: CLOSE cur_ver_id_to_task_num;
17155:
17156: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
17157: ,p_msg_name => 'PA_TASK_MISS_IN_HIERARCHY_ORD'
17158: ,p_token1 => 'TASK'
17159: ,p_value1 => l_err_task_number);
17160:

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

18268: CLOSE c_get_process_code;
18269:
18270: IF p_calling_context = 'UPDATE' AND l_process_code = 'PUE'
18271: THEN
18272: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
18273: ,p_msg_name => 'PA_PS_PUBLISH_ERROR');
18274:
18275: RAISE Invalid_Arg_Exc_WP;
18276: END IF;

Line 18317: PA_UTILS.ADD_MESSAGE

18313: -- Throw an error if any of the mandatory parameter is NULL.
18314: IF (p_project_id IS NULL) OR
18315: (p_structure_version_id IS NULL)
18316: THEN
18317: PA_UTILS.ADD_MESSAGE
18318: (p_app_short_name => 'PA',
18319: p_msg_name => 'PA_INV_PARAM_PASSED');
18320: RAISE Invalid_Arg_Exc_WP;
18321: END IF;

Line 18598: PA_UTILS.ADD_MESSAGE

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

Line 18704: PA_UTILS.ADD_MESSAGE

18700: END IF;
18701:
18702: -- Throw an error if the request could not be submitted.
18703: IF l_request_id = 0 THEN
18704: PA_UTILS.ADD_MESSAGE
18705: (p_app_short_name => 'PA',
18706: p_msg_name => 'PA_WP_TW_CONC_PGM_ERR');
18707: RAISE Invalid_Arg_Exc_WP;
18708: END IF;

Line 18928: PA_UTILS.ADD_MESSAGE

18924: IF l_debug_mode = 'Y' THEN
18925: pa_debug.g_err_stage:= 'Some of the mandatory parameters to this API are NULL';
18926: pa_debug.log_message(p_message => pa_debug.g_err_stage);
18927: END IF;
18928: PA_UTILS.ADD_MESSAGE
18929: (p_app_short_name => 'PA',
18930: p_msg_name => 'PA_INV_PARAM_PASSED');
18931: RAISE Invalid_Arg_Exc_WP;
18932: END IF;

Line 19394: PA_UTILS.ADD_MESSAGE

19390: END IF;
19391:
19392: -- Throw an error if any of the mandatory parameter is NULL.
19393: IF (p_project_id IS NULL) OR (p_structure_version_id IS NULL) THEN
19394: PA_UTILS.ADD_MESSAGE
19395: (p_app_short_name => 'PA',
19396: p_msg_name => 'PA_INV_PARAM_PASSED');
19397: RAISE Invalid_Arg_Exc_WP;
19398: END IF;

Line 21321: PA_UTILS.ADD_MESSAGE

21317:
21318: IF (p_project_id IS NULL) OR
21319: (p_structure_version_id IS NULL)
21320: THEN
21321: PA_UTILS.ADD_MESSAGE
21322: (p_app_short_name => 'PA',
21323: p_msg_name => 'PA_INV_PARAM_PASSED');
21324: RAISE Invalid_Arg_Exc_WP;
21325: END IF;

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

21368: EXCEPTION
21369: WHEN OTHERS THEN
21370: IF SQLCODE = -54 THEN
21371: -- If the record have already been locked, then the sql code would be -54.
21372: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
21373: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
21374: RAISE Invalid_Arg_Exc_WP;
21375: ELSE
21376: raise;

Line 21745: PA_UTILS.ADD_MESSAGE

21741: IF (p_project_id IS NULL) OR
21742: (p_structure_version_id IS NULL) OR
21743: (p_update_wbs_flag not in ('Y','N'))
21744: THEN
21745: PA_UTILS.ADD_MESSAGE
21746: (p_app_short_name => 'PA',
21747: p_msg_name => 'PA_INV_PARAM_PASSED');
21748: RAISE Invalid_Arg_Exc_WP;
21749: END IF;

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

22198: x_project_id => l_project_id,
22199: x_return_status => l_return_status,
22200: x_error_msg_code => l_error_msg_code);
22201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
22202: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
22203: p_msg_name => l_error_msg_code);
22204: RAISE API_ERROR;
22205: END IF;
22206: END IF;

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

22236: ,x_return_status => l_return_status
22237: ,x_error_msg_code => l_error_msg_code);
22238:
22239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
22240: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
22241: RAISE API_ERROR;
22242: END IF;
22243: END IF;
22244:

Line 22253: PA_UTILS.ADD_MESSAGE

22249: 'PA_PAXPREPR_OPT_WORKPLAN_STR',
22250: 'PA_PROJECTS',
22251: l_project_id
22252: ) THEN
22253: PA_UTILS.ADD_MESSAGE
22254: (p_app_short_name => 'PA',
22255: p_msg_name => 'PA_FUNCTION_SECURITY_ENFORCED');
22256: RAISE API_ERROR;
22257: END IF;