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_PROGRESS_PUB dependencies on PA_UTILS

Line 103: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);

99: l_est_remaining_eff_flag VARCHAR2(1);
100: l_percent_complete_flag VARCHAR2(1);
101: l_error_message_code VARCHAR2(250);
102: l_rollup_rec_ver_number NUMBER;
103: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
104: l_task_status VARCHAR2(150);
105: l_task_status2 VARCHAR2(150);
106: l_task_status_temp VARCHAR2(150); -- Bug#5374114
107: l_task_status2_temp VARCHAR2(150); -- Bug#5374114

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

812: ( p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: and p_actual_effort IS NOT NULL
814: )
815: THEN
816: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
817: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_4FN_STR');
818: x_msg_data := 'PA_TP_CANT_NTER_ACT_4FN_STR';
819: x_return_status := 'E';
820: RAISE FND_API.G_EXC_ERROR;

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

830: THEN
831: IF ( p_est_remaining_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
832: and p_est_remaining_effort IS NOT NULL)
833: THEN
834: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
835: ,p_msg_name => 'PA_WP_VD_CANT_UPDATE_ETC');
836: x_msg_data := 'PA_WP_VD_CANT_UPDATE_ETC';
837: x_return_status := 'E';
838: RAISE FND_API.G_EXC_ERROR;

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

862: l_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
863: l_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
864: EXCEPTION
865: WHEN OTHERS THEN
866: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
867: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
868: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
869: x_return_status := 'E';
870: x_msg_count := fnd_msg_pub.count_msg;

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

936: AND l_element_struc_type = 'WORKPLAN'
937: THEN
938: IF p_pm_product_code = 'MSPROJECT' OR p_calling_module <> 'AMG' --Bug:14537482
939: THEN
940: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
941: ,p_msg_name => 'PA_TP_CANT_NTER_PRG_CANCEL_MSP'
942: ,p_token1 => 'TASK_NAME'
943: ,p_value1 => PA_TASK_UTILS.get_task_name(l_task_id)
944: ,p_token2 => 'TASK_NUMBER'

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

946: x_msg_data := 'PA_TP_CANT_NTER_PRG_CANCEL';
947: x_return_status := 'E';
948: RAISE FND_API.G_EXC_ERROR;
949: ELSE
950: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
951: ,p_msg_name => 'PA_TP_CANT_NTER_PRG_CANCEL_AMG'
952: ,p_token1 => 'TASK_ID'
953: ,p_value1 => p_object_id
954: );

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

1000: IF NVL( l_progress_entry_enable_flag, 'N' ) = 'N' and p_object_type = 'PA_TASKS'
1001: THEN
1002: IF p_pm_product_code = 'MSPROJECT'
1003: THEN
1004: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1005: ,p_msg_name => 'PA_TP_CANT_ENTER_PROG_MSP'
1006: ,p_token1 => 'TASK_NAME'
1007: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1008: ,p_token2 => 'TASK_NUMBER'

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

1014: x_msg_data := 'PA_TP_CANT_ENTER_PROG';
1015: x_return_status := 'E';
1016: RAISE FND_API.G_EXC_ERROR;
1017: ELSE
1018: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1019: ,p_msg_name => 'PA_TP_CANT_ENTER_PROG_AMG'
1020: ,p_token1 => 'TASK_ID'
1021: ,p_value1 => p_object_id
1022: ,p_token2 => 'PROJECT_ID'

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

1030:
1031: ----- Wrong MODE
1032: IF p_progress_mode not in ( 'BACKDATED','FUTURE' )
1033: THEN
1034: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1035: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
1036: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
1037: x_return_status := 'E';
1038: RAISE FND_API.G_EXC_ERROR;

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

1041:
1042: ----- Wrong DATE
1043: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
1044: THEN
1045: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1046: ,p_msg_name => 'PA_TP_INV_AOD'
1047: ,p_token1 => 'AS_OF_DATE'
1048: ,p_value1 => p_as_of_date);
1049: x_msg_data := 'PA_TP_INV_AOD';

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

1054:
1055: ----- Wrong PROGRESS STATUS
1056: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
1057: THEN
1058: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1059: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
1060: x_msg_data := 'PA_TP_INV_PRG_STAT';
1061: x_return_status := 'E';
1062: RAISE FND_API.G_EXC_ERROR;

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

1074: EXCEPTION
1075: WHEN NO_DATA_FOUND THEN
1076: IF p_pm_product_code = 'MSPROJECT'
1077: THEN
1078: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1079: ,p_msg_name => 'PA_TP_INV_PRG_STAT_MSP'
1080: ,p_token1 => 'PROG_STATUS'
1081: ,p_value1 => p_progress_status_code
1082: ,p_token2 => 'TASK_NAME'

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

1090: x_msg_data := 'PA_TP_INV_PRG_STAT';
1091: x_return_status := 'E';
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1095: p_msg_name => 'PA_TP_INV_PRG_STAT_AMG'
1096: ,p_token1 => 'PROG_STATUS'
1097: ,p_value1 => p_progress_status_code
1098: ,p_token2 => 'TASK_ID'

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

1115: IF p_object_type = 'PA_TASKS'
1116: THEN
1117: IF p_pm_product_code = 'MSPROJECT'
1118: THEN
1119: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1120: ,p_msg_name => 'PA_TP_INV_TSK_STAT_MSP'
1121: ,p_token1 => 'TASK_NAME'
1122: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1123: ,p_token2 => 'TASK_NUMBER'

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

1125: x_msg_data := 'PA_TP_INV_TSK_STAT';
1126: x_return_status := 'E';
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSE
1129: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1130: ,p_msg_name => 'PA_TP_INV_TSK_STAT_AMG'
1131: ,p_token1 => 'TASK_ID'
1132: ,p_value1 => p_object_id
1133: );

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

1150: --bug 4368945 , rtarway, added check for -ve WQ
1151: IF (p_actual_work_quantity < 0) THEN
1152: IF p_pm_product_code = 'MSPROJECT'
1153: THEN
1154: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1155: ,p_msg_name => 'PA_TP_NO_NEG_WQ_MSP'
1156: ,p_token1 => 'TASK_NAME'
1157: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1158: ,p_token2 => 'TASK_NUMBER'

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

1160: x_msg_data := 'PA_TP_NO_NEG_WQ';
1161: x_return_status := 'E';
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSE
1164: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1165: ,p_msg_name => 'PA_TP_NO_NEG_WQ_AMG'
1166: ,p_token1 => 'TASK_ID'
1167: ,p_value1 => p_object_id);
1168: x_msg_data := 'PA_TP_NO_NEG_WQ';

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

1189: /* 5726773
1190: --3779387
1191: IF l_est_remaining_effort < 0
1192: THEN
1193: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1194: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
1195: x_msg_data := 'PA_TP_NO_NEG_ETC';
1196: x_return_status := 'E';
1197: RAISE FND_API.G_EXC_ERROR;

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

1323: THEN
1324: IF l_percent_complete > 0
1325: THEN
1326: --You cannot override percent_complete
1327: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1328: p_msg_name => 'PA_TP_NO_PC_OVRIDE');
1329: x_msg_data := 'PA_TP_NO_PC_OVRIDE';
1330: x_return_status := 'E';
1331: -- RAISE FND_API.G_EXC_ERROR;

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

1335:
1336: IF (l_percent_complete < 0 or l_percent_complete > 100) THEN
1337: IF p_pm_product_code = 'MSPROJECT'
1338: THEN
1339: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1340: ,p_msg_name => 'PA_PERC_COMP_INV_MSP'
1341: ,p_token1 => 'TASK_NAME'
1342: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1343: ,p_token2 => 'TASK_NUMBER'

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

1345: x_msg_data := 'PA_PERC_COMP_INV';
1346: x_return_status := 'E';
1347: RAISE FND_API.G_EXC_ERROR;
1348: ELSE
1349: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1350: ,p_msg_name => 'PA_PERC_COMP_INV_AMG'
1351: ,p_token1 => 'TASK_ID'
1352: ,p_value1 => p_object_id
1353: );

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

1368: --Get the SCHEDULE DATES for lowest level task.
1369:
1370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1371: THEN
1372: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1373: ,p_msg_name => l_error_message_code);
1374: x_msg_data := l_error_message_code;
1375: x_return_status := 'E';
1376: RAISE FND_API.G_EXC_ERROR;

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

1402: IF p_object_type = 'PA_TASKS'
1403: THEN
1404: IF p_pm_product_code = 'MSPROJECT'
1405: THEN
1406: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1407: ,p_msg_name => 'PA_TP_INV_TSK_STAT_MSP'
1408: ,p_token1 => 'TASK_NAME'
1409: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1410: ,p_token2 => 'TASK_NUMBER'

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

1412: x_msg_data := 'PA_TP_INV_TSK_STAT';
1413: x_return_status := 'E';
1414: RAISE FND_API.G_EXC_ERROR;
1415: ELSE
1416: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1417: ,p_msg_name => 'PA_TP_INV_TSK_STAT_AMG'
1418: ,p_token1 => 'TASK_ID'
1419: ,p_value1 => p_object_id
1420: );

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

1435: THEN
1436: --You cannot enter actual effort.
1437: IF p_pm_product_code = 'MSPROJECT'
1438: THEN
1439: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1440: ,p_msg_name => 'PA_TP_ACT_EFF_DISABL_MSP'
1441: ,p_token1 => 'TASK_NAME'
1442: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1443: ,p_token2 => 'TASK_NUMBER'

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

1450: x_msg_data := 'PA_TP_ACT_EFF_DISABL';
1451: x_return_status := 'E';
1452: l_tp_pcc_est_disabl := 'Y';
1453: ELSE
1454: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1455: ,p_msg_name => 'PA_TP_ACT_EFF_DISABL_AMG'
1456: ,p_token2 => 'TASK_ID'
1457: ,p_value2 => p_object_id
1458: ,p_token3 => 'PROJECT_ID'

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

1476:
1477: IF (( l_est_remaining_effort > 0) and (l_structure_sharing_code in ('SHARE_FULL', 'SHARE_PARTIAL')))
1478: THEN
1479: --You cannot enter etc effort.
1480: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1481: p_msg_name => 'PA_TP_EST_REM_EFF_DISABL');
1482: x_msg_data := 'PA_TP_EST_REM_EFF_DISABL';
1483: x_return_status := 'E';
1484: l_tp_pcc_est_disabl := 'Y';

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

1496: IF NVL( l_lowest_level_task, 'N' ) = 'N' AND (l_structure_sharing_code = 'SHARE_FULL') AND --Added for Bug# 6944034
1497: ( l_actual_effort > 0 OR l_est_remaining_effort > 0 )
1498: THEN
1499: --You cannot enter actual or ETC effort at summary level.
1500: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1501: p_msg_name => 'PA_TP_CANT_NTR_EFF_SUMMRY');
1502: x_msg_data := 'PA_TP_CANT_NTR_EFF_SUMMRY';
1503: x_return_status := 'E';
1504: --RAISE FND_API.G_EXC_ERROR; --rasie error message.

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

1508: THEN
1509: --You cannot effort when assignments exists for the task.
1510: IF p_pm_product_code = 'MSPROJECT'
1511: THEN
1512: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1513: ,p_msg_name => 'PA_TP_NO_EFF_WITH_ASSN_MSP'
1514: ,p_token1 => 'TASK_NAME'
1515: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1516: ,p_token2 => 'TASK_NUMBER'

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

1520: x_return_status := 'E';
1521: --RAISE FND_API.G_EXC_ERROR; --rasie error message.
1522: l_tp_pcc_est_disabl := 'Y';
1523: ELSE
1524: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1525: ,p_msg_name => 'PA_TP_NO_EFF_WITH_ASSN_AMG'
1526: ,p_token1 => 'TASK_ID'
1527: ,p_value1 => p_object_id);
1528: x_msg_data := 'PA_TP_NO_EFF_WITH_ASSN';

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

1534: AND l_structure_sharing_code = 'SHARE_FULL' --Bug 3586648
1535: AND ( l_actual_effort > 0 )
1536: THEN
1537: --You cannot enter actual effort for shared structures.
1538: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1539: p_msg_name => 'PA_TP_NO_ACT_EFF_4SH_STR');
1540: x_msg_data := 'PA_TP_NO_ACT_EFF_4SH_STR';
1541: x_return_status := 'E';
1542: --RAISE FND_API.G_EXC_ERROR; --rasie error message.

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

1563: THEN
1564: --You cannot enter estimated remaing effort.
1565: IF p_pm_product_code = 'MSPROJECT'
1566: THEN
1567: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1568: ,p_msg_name => 'PA_TP_EST_REM_EFF_DISABL_MSP'
1569: ,p_token1 => 'TASK_NAME'
1570: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1571: ,p_token2 => 'TASK_NUMBER'

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

1579: x_return_status := 'E';
1580: --RAISE FND_API.G_EXC_ERROR;
1581: l_tp_pcc_est_disabl := 'Y';
1582: ELSE
1583: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1584: ,p_msg_name => 'PA_TP_EST_REM_EFF_DISABL_AMG'
1585: ,p_token1 => 'TASK_ID'
1586: ,p_value1 => p_object_id
1587: ,p_token2 => 'PROJECT_ID'

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

1603: THEN
1604: --You cannot enter percent_complete
1605: IF p_pm_product_code = 'MSPROJECT'
1606: THEN
1607: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1608: ,p_msg_name => 'PA_TP_PCC_DISABL_MSP'
1609: ,p_token1 => 'TASK_NAME'
1610: ,p_value1 => PA_TASK_UTILS.get_task_name(p_object_id)
1611: ,p_token2 => 'TASK_NUMBER'

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

1619: x_return_status := 'E';
1620: -- RAISE FND_API.G_EXC_ERROR;
1621: l_tp_pcc_est_disabl := 'Y';
1622: ELSE
1623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1624: ,p_msg_name => 'PA_TP_PCC_DISABL_AMG'
1625: ,p_token1 => 'TASK_ID'
1626: ,p_value1 => p_object_id
1627: ,p_token2 => 'PROJECT_ID'

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

1835: THEN
1836: --Add message
1837: --You cannot create a backdated progress when there does not
1838: --exists any progress for this task.
1839: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1840: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE1');
1841: x_msg_data := 'PA_TP_WRONG_PRG_MODE1';
1842: x_return_status := 'E';
1843: RAISE FND_API.G_EXC_ERROR;

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

1844: ELSIF p_as_of_date > l_last_progress_date -- progress exists before as of date
1845: THEN
1846: --You cannot create a backdated progress when there exists a progress
1847: --before AS_OF_DATE for this task.
1848: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1849: p_msg_name => 'PA_TP_WRONG_PRG_MODE2',
1850: p_token1 => 'AS_OF_DATE',
1851: p_value1 => l_last_progress_date );
1852: x_msg_data := 'PA_TP_WRONG_PRG_MODE2';

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

1867: l_db_action := 'CREATE';
1868: ELSIF l_progress_exists_on_aod = 'PUBLISHED' and p_record_version_number is null THEN
1869: --You cannot create a backdated progress when there exists a progress
1870: -- on AS_OF_DATE for this task. can correct but no backdate.
1871: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1872: p_msg_name => 'PA_TP_WRONG_PRG_MODE5');
1873: x_msg_data := 'PA_TP_WRONG_PRG_MODE5';
1874: x_return_status := 'E';
1875: RAISE FND_API.G_EXC_ERROR;

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

1885: ( p_actual_work_quantity IS NOT NULL AND p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1886: THEN
1887: --Add message
1888: --You cannot pass actuals for backdated progress.
1889: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1890: ,p_msg_name => 'PA_TP_ACTUALS_NOT_ALLWD');
1891: x_msg_data := 'PA_TP_ACTUALS_NOT_ALLWD';
1892: x_return_status := 'E';
1893: RAISE FND_API.G_EXC_ERROR;

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

1900: l_db_action := 'UPDATE';
1901: ELSIF l_progress_exists_on_aod = 'PUBLISHED' and p_record_version_number is null THEN
1902: --You cannot create a backdated progress when there exists a progress
1903: -- on AS_OF_DATE for this task. can correct but no backdate.
1904: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1905: p_msg_name => 'PA_TP_WRONG_PRG_MODE5');
1906: x_msg_data := 'PA_TP_WRONG_PRG_MODE5';
1907: x_return_status := 'E';
1908: RAISE FND_API.G_EXC_ERROR;

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

1934: l_db_action := 'CREATE';
1935: ELSIF l_progress_exists_on_aod = 'PUBLISHED' and p_record_version_number is null THEN
1936: --You cannot create a backdated progress when there exists a progress
1937: -- on AS_OF_DATE for this task. can correct but no backdate.
1938: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1939: p_msg_name => 'PA_TP_WRONG_PRG_MODE5');
1940: x_msg_data := 'PA_TP_WRONG_PRG_MODE5';
1941: x_return_status := 'E';
1942: RAISE FND_API.G_EXC_ERROR;

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

1955: AND l_element_struc_type = 'WORKPLAN' --maansari fpm changes
1956: THEN
1957: --You cannot create a future progress when there exists a progress
1958: --after AS_OF_DATE for this task.
1959: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1960: p_msg_name => 'PA_TP_WRONG_PRG_MODE3',
1961: p_token1 => 'AS_OF_DATE',
1962: p_value1 => p_as_of_date );
1963: x_msg_data := 'PA_TP_WRONG_PRG_MODE3';

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

1975: THEN
1976: --Add message
1977: --Invalid as of date
1978:
1979: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1980: ,p_msg_name => 'PA_TP_INV_AOD2'
1981: ,p_token1 => 'AS_OF_DATE'
1982: ,p_value1 => p_as_of_date);
1983: x_msg_data := 'PA_TP_INV_AOD2';

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

2136: RAISE fnd_api.g_exc_error;
2137: END;
2138:
2139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2140: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2141: p_msg_name => l_msg_data);
2142: x_msg_data := l_msg_data;
2143: x_return_status := 'E';
2144: x_msg_count := l_msg_count;

Line 2377: pa_utils.add_message(p_app_short_name => 'PA',

2373: -- 4533112 End
2374:
2375: IF (l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date)) THEN --removed +1 bug 5186825
2376: x_return_status := FND_API.G_RET_STS_ERROR;
2377: pa_utils.add_message(p_app_short_name => 'PA',
2378: p_msg_name => 'PA_EST_DATES_INV');
2379: raise fnd_api.g_exc_error;
2380: END IF;
2381: -- Bug 3922325 : Actual Start date and Finish date should efualt even if percent completete is not enabled

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

2448:
2449: IF (nvl(l_percent_complete, l_BASE_PERCENT_COMPLETE) > 0 and nvl(l_percent_complete, l_BASE_PERCENT_COMPLETE) < 100
2450: and l_actual_start_date is null ) THEN
2451:
2452: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2453: ,p_msg_name => 'PA_TP_ACT_ST_DATE_NOT_NULL');
2454: x_msg_data := 'PA_TP_ACT_ST_DATE_NOT_NULL';
2455: x_return_status := 'E';
2456: RAISE FND_API.G_EXC_ERROR;

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

2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458:
2459: IF (nvl(l_percent_complete, l_BASE_PERCENT_COMPLETE) = 100 and l_actual_finish_date is null ) THEN
2460: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2461: ,p_msg_name => 'PA_TP_ACT_END_DT_NOT_NULL');
2462: x_msg_data := 'PA_TP_ACT_END_DT_NOT_NULL';
2463: x_return_status := 'E';
2464: RAISE FND_API.G_EXC_ERROR;

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

2466: END IF;
2467: */
2468: IF ( l_task_status2 IN ('COMPLETED','IN_PROGRESS') and l_actual_start_date is null ) THEN
2469:
2470: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2471: ,p_msg_name => 'PA_TP_ACT_ST_DATE_NOT_NULL');
2472: x_msg_data := 'PA_TP_ACT_ST_DATE_NOT_NULL';
2473: x_return_status := 'E';
2474: RAISE FND_API.G_EXC_ERROR;

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

2474: RAISE FND_API.G_EXC_ERROR;
2475: END IF;
2476:
2477: IF (l_task_status2 = 'COMPLETED' and l_actual_finish_date is null ) THEN
2478: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2479: ,p_msg_name => 'PA_TP_ACT_END_DT_NOT_NULL');
2480: x_msg_data := 'PA_TP_ACT_END_DT_NOT_NULL';
2481: x_return_status := 'E';
2482: RAISE FND_API.G_EXC_ERROR;

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

2526: --AND L_ALLW_PHY_PRCNT_CMP_OVERRIDES = 'Y' --maansari: fpm changes
2527: THEN
2528: IF p_pm_product_code = 'MSPROJECT'
2529: THEN
2530: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2531: ,p_msg_name => 'PA_TP_STAT_DTES_PC_COMB_MSP'
2532: ,p_token1 => 'TASK_NAME'
2533: ,p_value1 => PA_TASK_UTILS.get_task_name(l_task_id)
2534: ,p_token2 => 'TASK_NUMBER'

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

2536: x_msg_data := 'PA_TP_STAT_DTES_PC_COMB';
2537: x_return_status := 'E';
2538: RAISE FND_API.G_EXC_ERROR;
2539: ELSE
2540: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2541: ,p_msg_name => 'PA_TP_STAT_DTES_PC_COMB_AMG'
2542: ,p_token1 => 'TASK_ID'
2543: ,p_value1 => l_task_id
2544: );

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

2607: AND l_percent_complete_flag = 'N'
2608: THEN
2609: IF p_pm_product_code = 'MSPROJECT'
2610: THEN
2611: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2612: ,p_msg_name => 'PA_TP_STAT_DTES_PC_COMB_MSP'
2613: ,p_token1 => 'TASK_NAME'
2614: ,p_value1 => PA_TASK_UTILS.get_task_name(l_task_id)
2615: ,p_token2 => 'TASK_NUMBER'

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

2617: x_msg_data := 'PA_TP_STAT_DTES_PC_COMB';
2618: x_return_status := 'E';
2619: RAISE FND_API.G_EXC_ERROR;
2620: ELSE
2621: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2622: ,p_msg_name => 'PA_TP_STAT_DTES_PC_COMB_AMG'
2623: ,p_token1 => 'TASK_ID'
2624: ,p_value1 => l_task_id
2625: );

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

3917: ,x_error_message_code => l_error_message_code
3918: );
3919:
3920: IF (l_return_status <> 'S') THEN
3921: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3922: p_msg_name => l_error_message_code);
3923: raise FND_API.G_EXC_ERROR;
3924: END IF;
3925: END IF;

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

3967: END IF;
3968:
3969: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3970: THEN
3971: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3972: p_msg_name => l_msg_data
3973: );
3974: x_msg_data := l_msg_data;
3975: x_return_status := 'E';

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

4122:
4123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4124: THEN
4125: -- Bug 3248988 : Update_schedule_version adds the message, here message shd not be added
4126: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4127: -- p_msg_name => l_msg_data
4128: -- );
4129: -- x_msg_data := l_msg_data;
4130: x_return_status := 'E';

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

4151: ,x_msg_count => l_msg_count
4152: ,x_msg_data => l_msg_data );
4153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4154: THEN
4155: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4156: p_msg_name => l_msg_data
4157: );
4158: x_msg_data := l_msg_data;
4159: x_return_status := 'E';

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

4197: END IF;
4198:
4199: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4200: THEN
4201: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4202: p_msg_name => l_msg_data
4203: );
4204:
4205: x_msg_data := l_msg_data;

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

4407: ,x_msg_count => l_msg_count
4408: ,x_msg_data => l_msg_data);
4409:
4410: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4411: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4412: p_msg_name => l_msg_data
4413: );
4414: x_msg_data := l_msg_data;
4415: x_return_status := 'E';

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

4589: ,x_msg_count => l_msg_count
4590: ,x_msg_data => l_msg_data);
4591:
4592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4593: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4594: p_msg_name => l_msg_data);
4595: x_msg_data := l_msg_data;
4596: x_return_status := 'E';
4597: x_msg_count := l_msg_count;

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

5000:
5001: IF p_PERCENT_COMP_ENABLE_FLAG = 'N' AND
5002: l_old_PERCENT_COMP_ENABLE_FLAG = 'Y'
5003: THEN
5004: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5005: p_msg_name => 'PA_TP_CANT_DIS_PC');
5006: x_msg_data := 'PA_TP_CANT_DIS_PC';
5007: x_return_status := 'E';
5008: RAISE FND_API.G_EXC_ERROR;

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

5010:
5011: IF p_WQ_ENABLE_FLAG = 'N' AND
5012: l_old_enable_wq_flag = 'Y'
5013: THEN
5014: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5015: p_msg_name => 'PA_TP_CANT_DIS_WQ');
5016: x_msg_data := 'PA_TP_CANT_DIS_WQ';
5017: x_return_status := 'E';
5018: RAISE FND_API.G_EXC_ERROR;

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

5020:
5021: IF p_REMAIN_EFFORT_ENABLE_FLAG = 'N' AND
5022: l_old_REMAIN_EFF_ENABLE_FLAG = 'Y'
5023: THEN
5024: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5025: p_msg_name => 'PA_TP_CANT_DIS_REM_EFF');
5026: x_msg_data := 'PA_TP_CANT_DIS_REM_EFF';
5027: x_return_status := 'E';
5028: RAISE FND_API.G_EXC_ERROR;

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

5083: end if;
5084: -- Bug # 4576303.
5085: --------------dbms_output.put_line('ret stat = '||l_return_status);
5086: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5087: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5088: p_msg_name => l_msg_data
5089: );
5090: x_msg_data := l_msg_data;
5091: x_return_status := 'E';

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

5118: end if;
5119: -- Bug # 4576303.
5120: --------------dbms_output.put_line('ret stat = '||l_return_status);
5121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5122: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5123: p_msg_name => l_msg_data
5124: );
5125: x_msg_data := l_msg_data;
5126: x_return_status := 'E';

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

5150: x_msg_data => l_msg_data
5151: );
5152: --------------dbms_output.put_line('ret stat = '||l_return_status);
5153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5154: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5155: p_msg_name => l_msg_data
5156: );
5157: x_msg_data := l_msg_data;
5158: x_return_status := 'E';

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

5179: x_msg_data => l_msg_data
5180: );
5181: --------------dbms_output.put_line('ret stat = '||l_return_status);
5182: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5183: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5184: p_msg_name => l_msg_data
5185: );
5186: x_msg_data := l_msg_data;
5187: x_return_status := 'E';

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

7164: ,x_msg_count => l_msg_count
7165: ,x_msg_data => l_msg_data);
7166:
7167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7168: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7169: p_msg_name => l_msg_data);
7170: x_msg_data := l_msg_data;
7171: x_return_status := 'E';
7172: x_msg_count := l_msg_count;

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

7980:
7981: -- BEGIN: Adding code to fix Bug # 3815741.
7982:
7983: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7985: p_msg_name => l_msg_data);
7986: x_msg_data := l_msg_data;
7987: x_return_status := 'E';
7988: x_msg_count := l_msg_count;

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

8500: RAISE FND_API.G_EXC_ERROR;
8501: END;
8502:
8503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8504: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8505: p_msg_name => l_msg_data);
8506: x_msg_data := l_msg_data;
8507: x_return_status := 'E';
8508: x_msg_count := l_msg_count;

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

8651: RAISE FND_API.G_EXC_ERROR;
8652: END;
8653:
8654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8655: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8656: p_msg_name => l_msg_code);
8657: x_msg_data := l_msg_code;
8658: x_return_status := 'E';
8659: RAISE FND_API.G_EXC_ERROR;

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

8917:
8918: end if;
8919:
8920: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8921: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8922: p_msg_name => l_msg_data);
8923: x_msg_data := l_msg_data;
8924: x_return_status := 'E';
8925: x_msg_count := l_msg_count;

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

9475: if ((l_rec_publish.process = 'CONC_PUBLISH')
9476: and (l_process_code in ('WUP', 'WUE'))
9477: and (l_wp_ver_enabled_flag = 'Y')) then
9478:
9479: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
9480: ,p_msg_name => 'PA_PS_PUBLISH_NO_PROG');
9481:
9482: x_msg_data := 'PA_PS_PUBLISH_NO_PROG';
9483:

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

9488: elsif ((l_rec_publish.process = 'CONC_UPDATE')
9489: and (l_process_code = 'WUP')
9490: and (l_wp_ver_enabled_flag = 'N')) then
9491:
9492: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
9493: ,p_msg_name => 'PA_PS_UPDATE_NO_PROG');
9494:
9495: x_msg_data := 'PA_PS_UPDATE_NO_PROG';
9496:

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

9501: elsif ((l_rec_publish.process = 'APPLY_PROGRESS')
9502: and (l_process_code = 'WUP')
9503: and (l_wp_ver_enabled_flag = 'N')) then
9504:
9505: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
9506: ,p_msg_name => 'PA_PS_APLPRG_NO_PROG');
9507:
9508: x_msg_data := 'PA_PS_APLPRG_NO_PROG';
9509:

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

9553:
9554: IF (l_flag = 'Y')
9555: THEN
9556: --Raise Error
9557: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
9558: ,p_msg_name => 'PA_TEMPL_PROGRESS_NOT_ALLOWED');
9559: x_msg_data := 'PA_TEMPL_PROGRESS_NOT_ALLOWED';
9560: x_return_status := FND_API.G_RET_STS_ERROR;
9561: RAISE FND_API.G_EXC_ERROR;

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

9931: RAISE FND_API.G_EXC_ERROR;
9932: END;
9933:
9934: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9935: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9936: p_msg_name => l_msg_data);
9937: x_msg_data := l_msg_data;
9938: x_return_status := 'E';
9939: x_msg_count := l_msg_count;

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

9960: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
9961: RAISE FND_API.G_EXC_ERROR;
9962: END;
9963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9964: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9965: p_msg_name => l_msg_code);
9966: x_return_status := 'E';
9967: RAISE FND_API.G_EXC_ERROR;
9968: END IF;

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

10059: ,x_msg_count => l_msg_count
10060: ,x_msg_data => l_msg_data );
10061: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10062: THEN
10063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10064: p_msg_name => l_msg_data);
10065: x_msg_data := l_msg_data;
10066: x_return_status := 'E';
10067: RAISE FND_API.G_EXC_ERROR;

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

10375: RAISE FND_API.G_EXC_ERROR;
10376: END;
10377:
10378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10379: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10380: p_msg_name => l_msg_data);
10381: x_msg_data := l_msg_data;
10382: x_return_status := 'E';
10383: x_msg_count := l_msg_count;

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

11263:
11264:
11265: IF PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled(p_project_id) = 'N'
11266: THEN
11267: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
11268: ,p_msg_name => 'PA_PS_WORKPLAN_DISABLED');
11269: x_msg_data := 'PA_PS_WORKPLAN_DISABLED';
11270: x_return_status := 'E';
11271: RAISE FND_API.G_EXC_ERROR;

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

11273:
11274:
11275: IF ((l_structure_sharing_code = 'SPLIT_NO_MAPPING') or l_structure_sharing_code is null) -- Added OR condition for Bug no 4767821.
11276: THEN
11277: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
11278: ,p_msg_name => 'PA_TRAN_SHCODE_INV');
11279: x_msg_data := 'PA_TRAN_SHCODE_INV';
11280: x_return_status := 'E';
11281: RAISE FND_API.G_EXC_ERROR;

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

11344: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);
11345:
11346: IF l_structure_version_id = -1
11347: THEN
11348: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
11349: ,p_msg_name => 'PA_NO_PUBLISHED_VERSION');
11350: x_msg_data := 'PA_NO_PUBLISHED_VERSION';
11351: x_return_status := 'E';
11352: RAISE FND_API.G_EXC_ERROR;

Line 11814: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);

11810: l_as_of_date DATE := NULL;
11811: l_max_as_of_date DATE := NULL;
11812: l_user_id NUMBER := fnd_global.user_id;
11813: l_login_id NUMBER := fnd_global.login_id;
11814: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11815: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11816: L_PRE_PUB_STR_VER_ID NUMBER;
11817: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;
11818: L_OBJECT_VERSION_ID NUMBER;

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

14573:
14574: /* Begin: Added for bug 5526638*/
14575: /* Added and condition for bug#5659575*/
14576: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS and p_extraction_type <> 'PUBLISH') then
14577: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14578: p_msg_name => x_msg_code);
14579: x_msg_data := x_msg_code;
14580: x_return_status := 'E';
14581: pa_debug.log_message('GET_SUMM_ACT: Error in pji_fm_xbs_accum_utils.get_summarized_data', 1);

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

14628: x_msg_code => x_msg_code );
14629: /* Begin: Added for bug 5526638*/
14630: /* Added and condition for bug#5659575*/
14631: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS and p_extraction_type <> 'PUBLISH') THEN
14632: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14633: p_msg_name => x_msg_code);
14634: x_msg_data := x_msg_code;
14635: x_return_status := 'E';
14636: pa_debug.log_message('GET_SUMM_ACT: Error in pji_fm_xbs_accum_utils.populate_workplan_data', 1);

Line 14725: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,

14721: --- call api to get pa and gl period names for this date
14722:
14723: begin
14724:
14725: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,
14726: p_org_id => proj_org_ids_tbl(l_index));
14727: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,
14728: p_org_id => proj_org_ids_tbl(l_index));
14729:

Line 14727: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,

14723: begin
14724:
14725: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,
14726: p_org_id => proj_org_ids_tbl(l_index));
14727: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,
14728: p_org_id => proj_org_ids_tbl(l_index));
14729:
14730: exception when others then
14731: pa_debug.log_message('GET_SUMM_ACT: Project Id:'||l_project_id||' Issue in finding periods.', 1);

Line 14740: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));

14736: /* Added If condition for Bug#5659575*/
14737: if p_extraction_type = 'PUBLISH' then
14738: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14739: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14740: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));
14741: x_return_status := 'E';
14742: RAISE;
14743: else
14744: l_err_msg := 'Periods are not defined for the transaction date :'||l_temp_as_of_date;

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

14946: l_ignore_rec := 'Y';
14947: --- l_return_status := 'W'; bug 5526638
14948: l_return_status := 'E'; -- Added for bug#5659575
14949: pa_debug.log_message('GET_SUMM_ACT: Derive task assignment failed for Res Id: '||l_res_list_member_id||' Task version id: '||l_object_version_id, 1);
14950: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14951: p_msg_name => 'Derive Task Assignment failed for RLMId: '||l_res_list_member_id);
14952: /* Begin: Fix for Bug # 5526638. */
14953: if p_extraction_type <> 'PUBLISH' then
14954: l_err_msg := 'Derive task assignment to track actuals failed for resource list member id :'||l_res_list_member_id||' and Task version id :'||l_object_version_id;

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

18062: END IF;
18063:
18064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
18065: pa_debug.log_message('PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: Error in PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', 1);
18066: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
18067: p_msg_name => x_msg_data);
18068: x_msg_data := x_msg_data;
18069: x_return_status := 'E';
18070:

Line 19931: l_published_by_party_id NUMBER := PA_UTILS.get_party_id( l_user_id ) ;

19927: l_actual_finish_date DATE ;
19928: l_estimated_start_date DATE ;
19929: l_estimated_finish_date DATE ;
19930: l_rollup_rec_ver_number NUMBER ;
19931: l_published_by_party_id NUMBER := PA_UTILS.get_party_id( l_user_id ) ;
19932: l_object_type VARCHAR2(15) := p_object_type ;
19933: -- Bug 3595585 : Initialized l_object_type to p_object_type instead of PA_TASKS
19934: l_structure_version_id NUMBER ;
19935: l_published_structure VARCHAR2(1) ;

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

20106:
20107: --bug 3850475, Percent complete should be between 0 and 100
20108: IF l_percent_complete < 0 OR l_percent_complete > 100
20109: THEN
20110: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20111: ,p_msg_name => 'PA_FIN_PERCENT_INVALID');
20112: x_msg_data := 'PA_FIN_PERCENT_INVALID';
20113: x_return_status := 'E';
20114: RAISE FND_API.G_EXC_ERROR;

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

20119: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'
20120: THEN
20121: IF p_pm_product_code = 'MSPROJECT' OR p_calling_module <> 'AMG' --Bug:14537482
20122: THEN
20123: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20124: ,p_msg_name => 'PA_TP_CANT_NTER_PRG_CANCEL_MSP'
20125: ,p_token1 => 'TASK_NAME'
20126: ,p_value1 => PA_TASK_UTILS.get_task_name(l_task_id)
20127: ,p_token2 => 'TASK_NUMBER'

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

20129: x_msg_data := 'PA_TP_CANT_NTER_PRG_CANCEL';
20130: x_return_status := 'E';
20131: RAISE FND_API.G_EXC_ERROR;
20132: ELSE
20133: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20134: ,p_msg_name => 'PA_TP_CANT_NTER_PRG_CANCEL_AMG'
20135: ,p_token1 => 'TASK_ID'
20136: ,p_value1 => p_object_id
20137: );

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

20144:
20145: ----- Invalid DATE
20146: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
20147: THEN
20148: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20149: ,p_msg_name => 'PA_TP_INV_AOD'
20150: ,p_token1 => 'AS_OF_DATE'
20151: ,p_value1 => p_as_of_date);
20152: x_msg_data := 'PA_TP_INV_AOD';

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

21054: ,x_msg_count => l_msg_count
21055: ,x_msg_data => l_msg_data);
21056:
21057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
21058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
21059: p_msg_name => l_msg_data);
21060: x_msg_data := l_msg_data;
21061: x_return_status := 'E';
21062: x_msg_count := l_msg_count;

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

22300: end if;
22301:
22302:
22303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
22304: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
22305: p_msg_name => l_msg_data);
22306: x_msg_data := l_msg_data;
22307: x_return_status := 'E';
22308: x_msg_count := l_msg_count;

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

22829: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK', x_Msg => 'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK p_rbs_element_id_tbl.COUNT '||p_rbs_element_id_tbl.COUNT, x_Log_Level=> 3);
22830: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK', x_Msg => 'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK p_eff_rup_percent_complete_tbl.COUNT '||p_eff_rup_percent_complete_tbl.COUNT, x_Log_Level=> 3);
22831: END IF;
22832:
22833: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
22834: ,p_msg_name => 'PA_INV_PARAM_PASSED');
22835: x_msg_data := 'PA_INV_PARAM_PASSED';
22836: x_return_status := FND_API.G_RET_STS_ERROR;
22837: RAISE FND_API.G_EXC_ERROR;

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

22916: if ((l_rec_publish.process = 'CONC_PUBLISH')
22917: and (l_process_code in ('WUP', 'WUE'))
22918: and (l_wp_ver_enabled_flag = 'Y')) then
22919:
22920: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
22921: ,p_msg_name => 'PA_PS_PUBLISH_NO_PROG');
22922:
22923: x_msg_data := 'PA_PS_PUBLISH_NO_PROG';
22924:

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

22929: elsif ((l_rec_publish.process = 'CONC_UPDATE')
22930: and (l_process_code = 'WUP')
22931: and (l_wp_ver_enabled_flag = 'N')) then
22932:
22933: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
22934: ,p_msg_name => 'PA_PS_UPDATE_NO_PROG');
22935:
22936: x_msg_data := 'PA_PS_UPDATE_NO_PROG';
22937:

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

22942: elsif ((l_rec_publish.process = 'APPLY_PROGRESS')
22943: and (l_process_code = 'WUP')
22944: and (l_wp_ver_enabled_flag = 'N')) then
22945:
22946: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
22947: ,p_msg_name => 'PA_PS_APLPRG_NO_PROG');
22948:
22949: x_msg_data := 'PA_PS_APLPRG_NO_PROG';
22950:

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

22957: -- End fix for Bug # 4524977.
22958:
22959: -- Call repective update_task_progress, finc, assgn, dlv depdening on object_type
22960: IF (p_object_type_tbl(i) IS NULL OR p_object_id_tbl(i) IS NULL OR p_as_of_date_tbl(i) IS NULL ) THEN
22961: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
22962: ,p_msg_name => 'PA_INV_PARAM_PASSED');
22963: x_msg_data := 'PA_INV_PARAM_PASSED';
22964: x_return_status := FND_API.G_RET_STS_ERROR;
22965: RAISE FND_API.G_EXC_ERROR;

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

23008: OPEN c_get_template_flag(p_project_id_tbl(i));
23009: FETCH c_get_template_flag INTO l_flag;
23010: CLOSE c_get_template_flag;
23011: IF (l_flag = 'Y') THEN
23012: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
23013: ,p_msg_name => 'PA_TEMPL_PROGRESS_NOT_ALLOWED');
23014: x_msg_data := 'PA_TEMPL_PROGRESS_NOT_ALLOWED';
23015: x_return_status := FND_API.G_RET_STS_ERROR;
23016: RAISE FND_API.G_EXC_ERROR;

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

23437: END IF;
23438:
23439:
23440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
23441: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
23442: p_msg_name => l_msg_data);
23443: x_msg_data := l_msg_data;
23444: x_return_status := 'E';
23445: x_msg_count := l_msg_count;

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

23684: ,x_msg_count => l_msg_count
23685: ,x_msg_data => l_msg_data );
23686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
23687: THEN
23688: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
23689: p_msg_name => l_msg_data);
23690: x_msg_data := l_msg_data;
23691: x_return_status := 'E';
23692: RAISE FND_API.G_EXC_ERROR;

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

23913: END IF;
23914:
23915:
23916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
23917: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
23918: p_msg_name => l_msg_data);
23919: x_msg_data := l_msg_data;
23920: x_return_status := 'E';
23921: x_msg_count := l_msg_count;

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

23938: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Done with PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP l_return_status='||l_return_status, x_Log_Level=> 3);
23939: END IF;
23940:
23941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
23942: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
23943: p_msg_name => l_msg_data);
23944: x_msg_data := l_msg_data;
23945: x_return_status := 'E';
23946: x_msg_count := l_msg_count;