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_TASK_ASSIGNMENTS_PUB dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.initialize;

111: IF FND_API.TO_BOOLEAN( p_init_msg_list )
112:
113: THEN
114:
115: FND_MSG_PUB.initialize;
116:
117: END IF;
118:
119: -- Set API return status to success

Line 551: FND_MSG_PUB.Count_And_Get

547: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
548: ,x_log_level => 5);
549: END IF;
550:
551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count ,
553: p_data => x_msg_data );
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

562: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
563: ,x_log_level => 5);
564: END IF;
565:
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: THEN
568: FND_MSG_PUB.add_exc_msg
569: ( p_pkg_name => G_PKG_NAME
570: , p_procedure_name => l_api_name );

Line 568: FND_MSG_PUB.add_exc_msg

564: END IF;
565:
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: THEN
568: FND_MSG_PUB.add_exc_msg
569: ( p_pkg_name => G_PKG_NAME
570: , p_procedure_name => l_api_name );
571:
572: END IF;

Line 574: FND_MSG_PUB.Count_And_Get

570: , p_procedure_name => l_api_name );
571:
572: END IF;
573:
574: FND_MSG_PUB.Count_And_Get
575: ( p_count => x_msg_count ,
576: p_data => x_msg_data );
577:
578: WHEN OTHERS THEN

Line 588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

584: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
585: ,x_log_level => 5);
586: END IF;
587:
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.add_exc_msg
591: ( p_pkg_name => G_PKG_NAME
592: , p_procedure_name => l_api_name );

Line 590: FND_MSG_PUB.add_exc_msg

586: END IF;
587:
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.add_exc_msg
591: ( p_pkg_name => G_PKG_NAME
592: , p_procedure_name => l_api_name );
593:
594: END IF;

Line 595: FND_MSG_PUB.Count_And_Get

591: ( p_pkg_name => G_PKG_NAME
592: , p_procedure_name => l_api_name );
593:
594: END IF;
595: FND_MSG_PUB.Count_And_Get
596: ( p_count => x_msg_count ,
597: p_data => x_msg_data );
598:
599: END LOAD_TASK_ASSIGNMENTS;

Line 668: FND_MSG_PUB.initialize;

664: IF FND_API.TO_BOOLEAN( p_init_msg_list )
665:
666: THEN
667:
668: FND_MSG_PUB.initialize;
669:
670: END IF;
671:
672: -- Set API return status to success

Line 926: FND_MSG_PUB.Count_And_Get

922: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
923: ,x_log_level => 5);
924: END IF;
925:
926: FND_MSG_PUB.Count_And_Get
927: ( p_count => x_msg_count ,
928: p_data => x_msg_data );
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

936: PA_DEBUG.write_log (x_module => G_PKG_NAME
937: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
938: ,x_log_level => 5);
939: END IF;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: FND_MSG_PUB.add_exc_msg
943: ( p_pkg_name => G_PKG_NAME
944: , p_procedure_name => l_api_name );

Line 942: FND_MSG_PUB.add_exc_msg

938: ,x_log_level => 5);
939: END IF;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: FND_MSG_PUB.add_exc_msg
943: ( p_pkg_name => G_PKG_NAME
944: , p_procedure_name => l_api_name );
945:
946: END IF;

Line 948: FND_MSG_PUB.Count_And_Get

944: , p_procedure_name => l_api_name );
945:
946: END IF;
947:
948: FND_MSG_PUB.Count_And_Get
949: ( p_count => x_msg_count ,
950: p_data => x_msg_data );
951:
952: WHEN OTHERS THEN

Line 961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

957: PA_DEBUG.write_log (x_module => G_PKG_NAME
958: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
959: ,x_log_level => 5);
960: END IF;
961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: FND_MSG_PUB.add_exc_msg
964: ( p_pkg_name => G_PKG_NAME
965: , p_procedure_name => l_api_name );

Line 963: FND_MSG_PUB.add_exc_msg

959: ,x_log_level => 5);
960: END IF;
961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: FND_MSG_PUB.add_exc_msg
964: ( p_pkg_name => G_PKG_NAME
965: , p_procedure_name => l_api_name );
966:
967: END IF;

Line 968: FND_MSG_PUB.Count_And_Get

964: ( p_pkg_name => G_PKG_NAME
965: , p_procedure_name => l_api_name );
966:
967: END IF;
968: FND_MSG_PUB.Count_And_Get
969: ( p_count => x_msg_count ,
970: p_data => x_msg_data );
971:
972: END Load_Task_Asgmt_Periods;

Line 1037: FND_MSG_PUB.initialize;

1033: -- Initialize the message table if requested.
1034:
1035: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1036: THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040: -- Set API return status to success
1041:

Line 1124: FND_MSG_PUB.Count_And_Get

1120: PA_DEBUG.write_log (x_module => G_PKG_NAME
1121: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1122: ,x_log_level => 5);
1123: END IF;
1124: FND_MSG_PUB.Count_And_Get
1125: ( p_count => x_msg_count ,
1126: p_data => x_msg_data );
1127:
1128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1138: FND_MSG_PUB.Count_And_Get

1134: PA_DEBUG.write_log (x_module => G_PKG_NAME
1135: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1136: ,x_log_level => 5);
1137: END IF;
1138: FND_MSG_PUB.Count_And_Get
1139: ( p_count => x_msg_count ,
1140: p_data => x_msg_data );
1141:
1142: WHEN OTHERS THEN

Line 1151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1147: PA_DEBUG.write_log (x_module => G_PKG_NAME
1148: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1149: ,x_log_level => 5);
1150: END IF;
1151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.add_exc_msg
1154: ( p_pkg_name => G_PKG_NAME
1155: , p_procedure_name => l_api_name );

Line 1153: FND_MSG_PUB.add_exc_msg

1149: ,x_log_level => 5);
1150: END IF;
1151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.add_exc_msg
1154: ( p_pkg_name => G_PKG_NAME
1155: , p_procedure_name => l_api_name );
1156:
1157: END IF;

Line 1159: FND_MSG_PUB.Count_And_Get

1155: , p_procedure_name => l_api_name );
1156:
1157: END IF;
1158:
1159: FND_MSG_PUB.Count_And_Get
1160: ( p_count => x_msg_count ,
1161: p_data => x_msg_data );
1162:
1163: END EXECUTE_CREATE_TASK_ASGMTS;

Line 1216: FND_MSG_PUB.initialize;

1212: -- Initialize the message table if requested.
1213:
1214: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1215: THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218:
1219:
1220:

Line 1297: FND_MSG_PUB.Count_And_Get

1293: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1294:
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296:
1297: FND_MSG_PUB.Count_And_Get
1298: ( p_count => x_msg_count ,
1299: p_data => x_msg_data );
1300:
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1302: THEN
1303: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.add_exc_msg
1309: ( p_pkg_name => G_PKG_NAME
1310: , p_procedure_name => l_api_name );

Line 1308: FND_MSG_PUB.add_exc_msg

1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.add_exc_msg
1309: ( p_pkg_name => G_PKG_NAME
1310: , p_procedure_name => l_api_name );
1311:
1312: END IF;

Line 1313: FND_MSG_PUB.Count_And_Get

1309: ( p_pkg_name => G_PKG_NAME
1310: , p_procedure_name => l_api_name );
1311:
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get
1314: ( p_count => x_msg_count ,
1315: p_data => x_msg_data );
1316:
1317: WHEN OTHERS THEN

Line 1322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1318: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1319:
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1323: THEN
1324: FND_MSG_PUB.add_exc_msg
1325: ( p_pkg_name => G_PKG_NAME
1326: , p_procedure_name => l_api_name );

Line 1324: FND_MSG_PUB.add_exc_msg

1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1323: THEN
1324: FND_MSG_PUB.add_exc_msg
1325: ( p_pkg_name => G_PKG_NAME
1326: , p_procedure_name => l_api_name );
1327:
1328: END IF;

Line 1330: FND_MSG_PUB.Count_And_Get

1326: , p_procedure_name => l_api_name );
1327:
1328: END IF;
1329:
1330: FND_MSG_PUB.Count_And_Get
1331: ( p_count => x_msg_count ,
1332: p_data => x_msg_data );
1333:
1334: END EXECUTE_UPDATE_TASK_ASGMTS;

Line 1631: FND_MSG_PUB.initialize;

1627:
1628: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1629: THEN
1630:
1631: FND_MSG_PUB.initialize;
1632:
1633: END IF;
1634:
1635: -- Set API return status to success

Line 1652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1648:
1649: IF p_pm_product_code IS NOT NULL
1650: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1651:
1652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1653: pa_interface_utils_pub.map_new_amg_msg
1654: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
1655: ,p_msg_attribute => 'CHANGE'
1656: ,p_resize_flag => 'N'

Line 1829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1825: --dbms_output.put_line('Project Id:' || l_project_id);
1826: begin
1827:
1828: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
1829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1830: THEN
1831: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
1832: pa_interface_utils_pub.map_new_amg_msg
1833: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'

Line 1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1871:
1872: THEN
1873: --dbms_output.put_line(' test struct.null or g miss..');
1874:
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1876: THEN
1877: --dbms_output.put_line(' test struct.null or gmiss err..');
1878: pa_interface_utils_pub.map_new_amg_msg
1879: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

Line 1897: IF FND_MSG_PUB.count_msg > 0 THEN

1893: -- Removed logic to lock version.
1894: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
1895:
1896: -- Bug 3940853: Raise locking error return from structure API
1897: IF FND_MSG_PUB.count_msg > 0 THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: RAISE FND_API.G_EXC_ERROR;
1900: END IF;
1901:

Line 1931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1927: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1928: l_budget_version_id IS NULL )
1929: THEN
1930: --dbms_output.put_line(' budget version not obtained.. successful' );
1931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1932: THEN
1933: PA_UTILS.ADD_MESSAGE
1934: (p_app_short_name => 'PA',
1935: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'

Line 2152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2148:
2149: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2150: l_d_task_id IS NULL )
2151: THEN
2152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2153: THEN
2154: PA_UTILS.ADD_MESSAGE
2155: (p_app_short_name => 'PA',
2156: p_msg_name => 'PA_TASK_REQUIRED'

Line 2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2182:
2183: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2184: l_d_task_id IS NULL )
2185: THEN
2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2187: THEN
2188: PA_UTILS.ADD_MESSAGE
2189: (p_app_short_name => 'PA',
2190: p_msg_name => 'PA_TASK_REQUIRED'

Line 2209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2205:
2206: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2207: l_task_elem_version_id IS NULL )
2208: THEN
2209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2210: THEN
2211: PA_UTILS.ADD_MESSAGE
2212: (p_app_short_name => 'PA',
2213: p_msg_name => 'PA_TASK_VERSION_REQUIRED'

Line 2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2247: Close C_Res_List_Mem_Check;
2248:
2249: ELSE
2250:
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2252: THEN
2253: IF p_pm_product_code = 'MSPROJECT'
2254: THEN
2255: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2327: p_task_assignments_in(i).end_date IS NOT NULL and
2328: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2329: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2330:
2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2332: IF p_pm_product_code = 'MSPROJECT'
2333: THEN
2334: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2335: ,p_msg_name => 'PA_INVALID_DATES_MSP'

Line 2360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2356: --dbms_output.put_line('test 7:');
2357: IF p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
2358: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2359: --dbms_output.put_line('pm_task_asgmt_reference is NULL/G_MISS...error');
2360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: PA_UTILS.ADD_MESSAGE
2363: (p_app_short_name => 'PA',
2364: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'

Line 2378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2374: OPEN C_Reference_Check(p_task_assignments_in(i).pm_task_asgmt_reference, l_budget_version_id);
2375: FETCH C_Reference_Check into C_Reference_Rec;
2376: IF C_Reference_Check%FOUND THEN
2377: --dbms_output.put_line('pm_task_asgmt_reference is EXISTING error');
2378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2379: THEN
2380: --CLOSE C_Reference_Check; Bug 3937017
2381: PA_UTILS.ADD_MESSAGE
2382: (p_app_short_name => 'PA'

Line 2506: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2502: lk_resource_list_member_id_tbl(i) );
2503: fetch c_unique_res_check into c_unique_res_rec;
2504:
2505: IF c_unique_res_check%FOUND THEN
2506: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2507: THEN
2508: --CLOSE c_unique_res_check; Bug 3937017
2509: IF p_pm_product_code = 'MSPROJECT'
2510: THEN

Line 2541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2537: lk_resource_list_member_id_tbl(i));
2538: fetch c_unique_res_check_for_cbs into c_unique_res_rec;
2539:
2540: IF c_unique_res_check_for_cbs%FOUND THEN
2541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2542: THEN
2543:
2544: PA_UTILS.ADD_MESSAGE
2545: ( p_app_short_name => 'PA'

Line 3003: FND_MSG_PUB.Count_And_Get

2999: ,x_log_level => 5);
3000: END IF;
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002:
3003: FND_MSG_PUB.Count_And_Get
3004: ( p_count => x_msg_count ,
3005: p_data => x_msg_data );
3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3014: ,x_log_level => 5);
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017:
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3019: THEN
3020: FND_MSG_PUB.add_exc_msg
3021: ( p_pkg_name => G_PKG_NAME
3022: , p_procedure_name => l_api_name );

Line 3020: FND_MSG_PUB.add_exc_msg

3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017:
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3019: THEN
3020: FND_MSG_PUB.add_exc_msg
3021: ( p_pkg_name => G_PKG_NAME
3022: , p_procedure_name => l_api_name );
3023:
3024: END IF;

Line 3025: FND_MSG_PUB.Count_And_Get

3021: ( p_pkg_name => G_PKG_NAME
3022: , p_procedure_name => l_api_name );
3023:
3024: END IF;
3025: FND_MSG_PUB.Count_And_Get
3026: ( p_count => x_msg_count ,
3027: p_data => x_msg_data );
3028:
3029:

Line 3044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3040: ,x_log_level => 5);
3041: END IF;
3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043:
3044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3045: THEN
3046: FND_MSG_PUB.add_exc_msg
3047: ( p_pkg_name => G_PKG_NAME
3048: , p_procedure_name => l_api_name );

Line 3046: FND_MSG_PUB.add_exc_msg

3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043:
3044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3045: THEN
3046: FND_MSG_PUB.add_exc_msg
3047: ( p_pkg_name => G_PKG_NAME
3048: , p_procedure_name => l_api_name );
3049:
3050: END IF;

Line 3052: FND_MSG_PUB.Count_And_Get

3048: , p_procedure_name => l_api_name );
3049:
3050: END IF;
3051:
3052: FND_MSG_PUB.Count_And_Get
3053: ( p_count => x_msg_count ,
3054: p_data => x_msg_data );
3055:
3056: END CREATE_TASK_ASSIGNMENTS;

Line 3125: FND_MSG_PUB.initialize;

3121: -- Initialize the message table if requested.
3122:
3123: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3124: THEN
3125: FND_MSG_PUB.initialize;
3126: END IF;
3127:
3128: -- Set API return status to success
3129: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3135: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3136: END IF;
3137:
3138: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3140: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3141: ,p_msg_attribute => 'CHANGE'
3142: ,p_resize_flag => 'N'
3143: ,p_msg_context => 'GENERAL'

Line 3158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3154: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3155: CLOSE C_Get_Budget_Version_Id;
3156:
3157: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3159: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3160: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3161: );
3162: END IF;

Line 3288: FND_MSG_PUB.Count_And_Get

3284: PA_DEBUG.write_log (x_module => G_PKG_NAME
3285: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3286: ,x_log_level => 5);
3287: END IF;
3288: FND_MSG_PUB.Count_And_Get
3289: ( p_count => x_msg_count ,
3290: p_data => x_msg_data );
3291:
3292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3302: FND_MSG_PUB.Count_And_Get

3298: PA_DEBUG.write_log (x_module => G_PKG_NAME
3299: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3300: ,x_log_level => 5);
3301: END IF;
3302: FND_MSG_PUB.Count_And_Get
3303: ( p_count => x_msg_count ,
3304: p_data => x_msg_data );
3305:
3306: WHEN OTHERS THEN

Line 3319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3315: PA_DEBUG.write_log (x_module => G_PKG_NAME
3316: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3317: ,x_log_level => 5);
3318: END IF;
3319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3320: THEN
3321: FND_MSG_PUB.add_exc_msg
3322: ( p_pkg_name => G_PKG_NAME
3323: , p_procedure_name => l_api_name );

Line 3321: FND_MSG_PUB.add_exc_msg

3317: ,x_log_level => 5);
3318: END IF;
3319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3320: THEN
3321: FND_MSG_PUB.add_exc_msg
3322: ( p_pkg_name => G_PKG_NAME
3323: , p_procedure_name => l_api_name );
3324:
3325: END IF;

Line 3327: FND_MSG_PUB.Count_And_Get

3323: , p_procedure_name => l_api_name );
3324:
3325: END IF;
3326:
3327: FND_MSG_PUB.Count_And_Get
3328: ( p_count => x_msg_count ,
3329: p_data => x_msg_data );
3330:
3331: END Create_Task_Assignment_Periods;

Line 3398: FND_MSG_PUB.initialize;

3394: -- Initialize the message table if requested.
3395:
3396: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3397: THEN
3398: FND_MSG_PUB.initialize;
3399: END IF;
3400:
3401:
3402:

Line 3415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3411: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3412: END IF;
3413:
3414: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3416: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3417: ,p_msg_attribute => 'CHANGE'
3418: ,p_resize_flag => 'N'
3419: ,p_msg_context => 'GENERAL'

Line 3435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3431: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3432: CLOSE C_Get_Budget_Version_Id;
3433:
3434: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3436: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3437: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3438: );
3439: END IF;

Line 3566: FND_MSG_PUB.Count_And_Get

3562: PA_DEBUG.write_log (x_module => G_PKG_NAME
3563: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3564: ,x_log_level => 5);
3565: END IF;
3566: FND_MSG_PUB.Count_And_Get
3567: ( p_count => x_msg_count ,
3568: p_data => x_msg_data );
3569:
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3580: FND_MSG_PUB.Count_And_Get

3576: PA_DEBUG.write_log (x_module => G_PKG_NAME
3577: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3578: ,x_log_level => 5);
3579: END IF;
3580: FND_MSG_PUB.Count_And_Get
3581: ( p_count => x_msg_count ,
3582: p_data => x_msg_data );
3583:
3584: WHEN OTHERS THEN

Line 3597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3593: PA_DEBUG.write_log (x_module => G_PKG_NAME
3594: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3595: ,x_log_level => 5);
3596: END IF;
3597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3598: THEN
3599: FND_MSG_PUB.add_exc_msg
3600: ( p_pkg_name => G_PKG_NAME
3601: , p_procedure_name => l_api_name );

Line 3599: FND_MSG_PUB.add_exc_msg

3595: ,x_log_level => 5);
3596: END IF;
3597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3598: THEN
3599: FND_MSG_PUB.add_exc_msg
3600: ( p_pkg_name => G_PKG_NAME
3601: , p_procedure_name => l_api_name );
3602:
3603: END IF;

Line 3605: FND_MSG_PUB.Count_And_Get

3601: , p_procedure_name => l_api_name );
3602:
3603: END IF;
3604:
3605: FND_MSG_PUB.Count_And_Get
3606: ( p_count => x_msg_count ,
3607: p_data => x_msg_data );
3608: END Update_Task_Assignment_Periods;
3609:

Line 3668: FND_MSG_PUB.initialize;

3664: -- Initialize the message table if requested.
3665:
3666: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3667: THEN
3668: FND_MSG_PUB.initialize;
3669: END IF;
3670:
3671:
3672:

Line 3732: FND_MSG_PUB.Count_And_Get

3728: PA_DEBUG.write_log (x_module => G_PKG_NAME
3729: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3730: ,x_log_level => 5);
3731: END IF;
3732: FND_MSG_PUB.Count_And_Get
3733: ( p_count => x_msg_count ,
3734: p_data => x_msg_data );
3735:
3736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3746: FND_MSG_PUB.Count_And_Get

3742: PA_DEBUG.write_log (x_module => G_PKG_NAME
3743: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3744: ,x_log_level => 5);
3745: END IF;
3746: FND_MSG_PUB.Count_And_Get
3747: ( p_count => x_msg_count ,
3748: p_data => x_msg_data );
3749:
3750: WHEN OTHERS THEN

Line 3759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3755: PA_DEBUG.write_log (x_module => G_PKG_NAME
3756: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3757: ,x_log_level => 5);
3758: END IF;
3759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3760: THEN
3761: FND_MSG_PUB.add_exc_msg
3762: ( p_pkg_name => G_PKG_NAME
3763: , p_procedure_name => l_api_name );

Line 3761: FND_MSG_PUB.add_exc_msg

3757: ,x_log_level => 5);
3758: END IF;
3759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3760: THEN
3761: FND_MSG_PUB.add_exc_msg
3762: ( p_pkg_name => G_PKG_NAME
3763: , p_procedure_name => l_api_name );
3764:
3765: END IF;

Line 3767: FND_MSG_PUB.Count_And_Get

3763: , p_procedure_name => l_api_name );
3764:
3765: END IF;
3766:
3767: FND_MSG_PUB.Count_And_Get
3768: ( p_count => x_msg_count ,
3769: p_data => x_msg_data );
3770: END Delete_Task_Assignments;
3771:

Line 4317: FND_MSG_PUB.initialize;

4313:
4314: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4315: THEN
4316:
4317: FND_MSG_PUB.initialize;
4318:
4319: END IF;
4320:
4321: --dbms_output.put_line('Update Task Asgmts.: API Comp. checked.');

Line 4340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4336:
4337: IF p_pm_product_code IS NOT NULL
4338: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4339:
4340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4341: pa_interface_utils_pub.map_new_amg_msg
4342: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4343: ,p_msg_attribute => 'CHANGE'
4344: ,p_resize_flag => 'N'

Line 4479: FND_MSG_PUB.initialize;

4475:
4476: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4477: THEN
4478:
4479: FND_MSG_PUB.initialize;
4480:
4481: END IF;
4482:
4483:

Line 4528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4524:
4525: --dbms_output.put_line('Project Id:' || l_project_id);
4526:
4527: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
4528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4529: THEN
4530: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
4531: pa_interface_utils_pub.map_new_amg_msg
4532: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'

Line 4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4566:
4567: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4568: l_struct_elem_version_id IS NULL )
4569: THEN
4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4571: THEN
4572: pa_interface_utils_pub.map_new_amg_msg
4573: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
4574: ,p_msg_attribute => 'CHANGE'

Line 4597: IF FND_MSG_PUB.count_msg > 0 THEN

4593: -- Removed logic to lock version.
4594: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
4595:
4596: -- Bug 3940853: Raise locking error return from structure API
4597: IF FND_MSG_PUB.count_msg > 0 THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: RAISE FND_API.G_EXC_ERROR;
4600: END IF;
4601:

Line 4631: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4627: CLOSE C_Get_Budget_Version_Id;
4628:
4629: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4630: l_budget_version_id IS NULL ) THEN
4631: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4632: THEN
4633: PA_UTILS.ADD_MESSAGE
4634: (p_app_short_name => 'PA',
4635: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'

Line 4802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4798:
4799: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4800: l_d_task_id IS NULL )
4801: THEN
4802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4803: THEN
4804: PA_UTILS.ADD_MESSAGE
4805: (p_app_short_name => 'PA',
4806: p_msg_name => 'PA_TASK_REQUIRED'

Line 4844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4840:
4841: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4842: l_d_task_id IS NULL )
4843: THEN
4844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4845: THEN
4846: PA_UTILS.ADD_MESSAGE
4847: (p_app_short_name => 'PA',
4848: p_msg_name => 'PA_TASK_REQUIRED'

Line 4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4866:
4867: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;
4868:
4869: ELSE
4870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4871: THEN
4872: PA_UTILS.ADD_MESSAGE
4873: (p_app_short_name => 'PA',
4874: p_msg_name => 'PA_TASK_VERSION_REQUIRED'

Line 5003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4999: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND
5000: p_task_assignments_in(i).p_context <> 'D' AND
5001: (p_task_assignments_in(i).resource_list_member_id IS NULL OR
5002: p_task_assignments_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5004: THEN
5005: IF p_pm_product_code = 'MSPROJECT'
5006: THEN
5007: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 5072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5068: p_task_assignments_in(i).end_date IS NOT NULL and
5069: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
5070: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
5071:
5072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5073: IF p_pm_product_code = 'MSPROJECT'
5074: THEN
5075: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5076: ,p_msg_name => 'PA_INVALID_DATES_MSP'

Line 5102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5098: -- For Bug 8842724
5099: IF p_task_assignments_in(i).pa_task_assignment_id IS NULL and
5100: (l_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
5101: l_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
5102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5103: THEN
5104: PA_UTILS.ADD_MESSAGE
5105: (p_app_short_name => 'PA',
5106: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'

Line 5122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5118:
5119: IF p_task_assignments_in(i).use_task_schedule_flag IS NOT NULL AND
5120: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
5121: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
5122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5123: THEN
5124: pa_interface_utils_pub.map_new_amg_msg
5125: ( p_old_message_code => 'PA_TASK_SCHED_FLAG_INVALID' -->>>>
5126: ,p_msg_attribute => 'CHANGE'

Line 5158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5154:
5155: IF C_currency_exists%FOUND THEN
5156: l_currency_code := p_task_assignments_in(i).currency_code ;
5157: ELSIF C_currency_exists%NOTFOUND THEN
5158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5159: THEN
5160: pa_interface_utils_pub.map_new_amg_msg
5161: ( p_old_message_code => 'PA_INVALID_CURRENCY' -->>>>
5162: ,p_msg_attribute => 'CHANGE'

Line 5240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5236: IF p_task_assignments_in(i).billable_work_percent IS NOT NULL AND
5237: p_task_assignments_in(i).billable_work_percent <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5238: ( p_task_assignments_in(i).billable_work_percent < 0 OR
5239: p_task_assignments_in(i).billable_work_percent > 100) THEN
5240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5241: THEN
5242: IF p_pm_product_code = 'MSPROJECT'
5243: THEN
5244: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 5307: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5303: l_Cost_Type_id := p_task_assignments_in(i).mfg_cost_type_id ;
5304: END IF;
5305:
5306: IF l_Cost_Type_exists is NOT NULL and l_Cost_Type_exists = 'N' THEN
5307: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5308: THEN
5309: pa_interface_utils_pub.map_new_amg_msg
5310: ( p_old_message_code => 'PA_INVALID_COST_TYPE' -->>>>
5311: ,p_msg_attribute => 'CHANGE'

Line 5336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5332:
5333: IF ( (l_time_phased_code IS NULL OR (l_time_phased_code <> 'P' AND l_time_phased_code<> 'G'))
5334: AND ((p_task_assignments_in(i).spread_curve_id IS NOT NULL AND p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
5335: (p_task_assignments_in(i).spread_curve_name IS NOT NULL AND p_task_assignments_in(i).spread_curve_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ))) THEN
5336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5337: pa_interface_utils_pub.map_new_amg_msg
5338: ( p_old_message_code => 'PA_DISABL_WP_NA' -->>>>
5339: ,p_msg_attribute => 'CHANGE'
5340: ,p_resize_flag => 'N'

Line 5380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5376: END IF;
5377:
5378: IF (l_spread_curve_exists is NOT NULL and l_spread_curve_exists = 'N') OR
5379: (p_task_assignments_in(i).spread_curve_id IS NULL) THEN
5380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5381: pa_interface_utils_pub.map_new_amg_msg
5382: ( p_old_message_code => 'PA_INVALID_SPREAD_CURVE' -->>>>
5383: ,p_msg_attribute => 'CHANGE'
5384: ,p_resize_flag => 'N'

Line 5406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5402: END IF;
5403:
5404: IF l_spread_curve_code is NOT NULL THEN
5405: IF l_spread_curve_code = 'FIXED_DATE' and (l_fixed_date is null or l_fixed_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
5406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5407: pa_interface_utils_pub.map_new_amg_msg
5408: ( p_old_message_code => 'PA_FIXED_DATE_MISSING' -->>>>
5409: ,p_msg_attribute => 'CHANGE'
5410: ,p_resize_flag => 'N'

Line 5916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5912: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5913: pa_debug.g_err_stage:='pm_task_asgmt_reference is EXISTING error';
5914: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5915: END IF;
5916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5917: THEN
5918: --CLOSE C_Reference_Check;Bug 3937017
5919: PA_UTILS.ADD_MESSAGE
5920: (p_app_short_name => 'PA'

Line 6710: FND_MSG_PUB.Count_And_Get

6706: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
6707: ,x_log_level => 5);
6708: END IF;
6709:
6710: FND_MSG_PUB.Count_And_Get
6711: ( p_count => x_msg_count ,
6712: p_data => x_msg_data );
6713:
6714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 6725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6721: PA_DEBUG.write_log (x_module => G_PKG_NAME
6722: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6723: ,x_log_level => 5);
6724: END IF;
6725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6726: THEN
6727: FND_MSG_PUB.add_exc_msg
6728: ( p_pkg_name => G_PKG_NAME
6729: , p_procedure_name => l_api_name );

Line 6727: FND_MSG_PUB.add_exc_msg

6723: ,x_log_level => 5);
6724: END IF;
6725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6726: THEN
6727: FND_MSG_PUB.add_exc_msg
6728: ( p_pkg_name => G_PKG_NAME
6729: , p_procedure_name => l_api_name );
6730:
6731: END IF;

Line 6732: FND_MSG_PUB.Count_And_Get

6728: ( p_pkg_name => G_PKG_NAME
6729: , p_procedure_name => l_api_name );
6730:
6731: END IF;
6732: FND_MSG_PUB.Count_And_Get
6733: ( p_count => x_msg_count ,
6734: p_data => x_msg_data );
6735:
6736: WHEN OTHERS THEN

Line 6748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6744: PA_DEBUG.write_log (x_module => G_PKG_NAME
6745: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6746: ,x_log_level => 5);
6747: END IF;
6748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6749: THEN
6750: FND_MSG_PUB.add_exc_msg
6751: ( p_pkg_name => G_PKG_NAME
6752: , p_procedure_name => l_api_name );

Line 6750: FND_MSG_PUB.add_exc_msg

6746: ,x_log_level => 5);
6747: END IF;
6748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6749: THEN
6750: FND_MSG_PUB.add_exc_msg
6751: ( p_pkg_name => G_PKG_NAME
6752: , p_procedure_name => l_api_name );
6753:
6754: END IF;

Line 6756: FND_MSG_PUB.Count_And_Get

6752: , p_procedure_name => l_api_name );
6753:
6754: END IF;
6755:
6756: FND_MSG_PUB.Count_And_Get
6757: ( p_count => x_msg_count ,
6758: p_data => x_msg_data );
6759:
6760: END UPDATE_TASK_ASSIGNMENTS;

Line 6834: FND_MSG_PUB.initialize;

6830: -- Initialize the message table if requested.
6831:
6832: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6833: THEN
6834: FND_MSG_PUB.initialize;
6835: END IF;
6836:
6837: -- Set API return status to success
6838:

Line 6853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6849: --dbms_output.put_line('Asgmt index is not passed.');
6850:
6851: RETURN;
6852:
6853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6854: pa_interface_utils_pub.map_new_amg_msg
6855: ( p_old_message_code => 'PA_INDEX_NOT_PROVIDED'
6856: ,p_msg_attribute => 'CHANGE'
6857: ,p_resize_flag => 'N'

Line 7137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7133: AND p_pa_project_id IS NOT NULL THEN
7134:
7135: IF l_dummy IS NULL THEN
7136:
7137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7138: THEN
7139: pa_interface_utils_pub.map_new_amg_msg
7140: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
7141: ,p_msg_attribute => 'CHANGE'

Line 7156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7152: END IF;
7153:
7154: ELSE
7155:
7156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7157: THEN
7158: pa_interface_utils_pub.map_new_amg_msg
7159: ( p_old_message_code => 'PA_PROJECT_ID_MISSING'
7160: ,p_msg_attribute => 'CHANGE'

Line 7219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7215:
7216: THEN
7217: --dbms_output.put_line(' test struct.null or g miss..');
7218:
7219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7220: THEN
7221: --dbms_output.put_line(' test struct.null or gmiss err..');
7222: pa_interface_utils_pub.map_new_amg_msg
7223: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

Line 7252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7248: p_pa_task_id);
7249: --dbms_output.put_line(l_task_ver_id);
7250: IF l_task_ver_id is NULL
7251: THEN
7252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7253: THEN
7254: pa_interface_utils_pub.map_new_amg_msg
7255: ( p_old_message_code => 'PA_TASK_ID_INVALID'
7256: ,p_msg_attribute => 'CHANGE'

Line 7292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7288: FETCH l_task_asgmt_id_csr INTO l_dummy;
7289:
7290: IF l_task_asgmt_id_csr%NOTFOUND
7291: THEN
7292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7293: THEN
7294: pa_interface_utils_pub.map_new_amg_msg
7295: ( p_old_message_code => 'PA_TASK_ASGMT_ID_INVALID'
7296: ,p_msg_attribute => 'CHANGE'

Line 7346: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

7342: -- END OF 4216541
7343:
7344: IF l_task_asgmt_id IS NULL THEN
7345:
7346: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
7347: AND p_add_error_msg_flag = 'Y' -- Bug 3937017
7348: -- In update_task_assignments flow, convert_pm_taref_to_id is called to determine whether
7349: -- the given assignment data should be created (if failed to convert) or updated (if conversion
7350: -- succeeds). Therefore, in this flow, failing to convert is not really an expected error

Line 7357: FND_MSG_PUB.add;

7353: THEN
7354: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
7355: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
7356: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
7357: FND_MSG_PUB.add;
7358:
7359: RAISE FND_API.G_EXC_ERROR;
7360:
7361: END IF;

Line 7389: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

7385: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
7386: IF l_task_asgmt_id IS NULL
7387: THEN
7388:
7389: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
7390: AND p_add_error_msg_flag = 'Y' -- Bug 3937017
7391: THEN
7392: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
7393: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');

Line 7395: FND_MSG_PUB.add;

7391: THEN
7392: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
7393: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
7394: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
7395: FND_MSG_PUB.add;
7396:
7397: RAISE FND_API.G_EXC_ERROR;
7398:
7399: END IF;

Line 7410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7406:
7407:
7408: ELSE
7409:
7410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7411: THEN
7412: pa_interface_utils_pub.map_new_amg_msg
7413: ( p_old_message_code => 'PA_TASK_ASGMT_REF_ID_MISSING'
7414: ,p_msg_attribute => 'CHANGE'

Line 7447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7443:
7444:
7445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7446:
7447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7448: THEN
7449: FND_MSG_PUB.add_exc_msg
7450: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'
7451: , p_procedure_name => l_api_name );

Line 7449: FND_MSG_PUB.add_exc_msg

7445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7446:
7447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7448: THEN
7449: FND_MSG_PUB.add_exc_msg
7450: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'
7451: , p_procedure_name => l_api_name );
7452:
7453: END IF;