APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on FND_MSG_PUB

Line 114: FND_MSG_PUB.initialize;

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

Line 543: FND_MSG_PUB.Count_And_Get

539: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
540: ,x_log_level => 5);
541: END IF;
542:
543: FND_MSG_PUB.Count_And_Get
544: ( p_count => x_msg_count ,
545: p_data => x_msg_data );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

554: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
555: ,x_log_level => 5);
556: END IF;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
559: THEN
560: FND_MSG_PUB.add_exc_msg
561: ( p_pkg_name => G_PKG_NAME
562: , p_procedure_name => l_api_name );

Line 560: FND_MSG_PUB.add_exc_msg

556: END IF;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
559: THEN
560: FND_MSG_PUB.add_exc_msg
561: ( p_pkg_name => G_PKG_NAME
562: , p_procedure_name => l_api_name );
563:
564: END IF;

Line 566: FND_MSG_PUB.Count_And_Get

562: , p_procedure_name => l_api_name );
563:
564: END IF;
565:
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count ,
568: p_data => x_msg_data );
569:
570: WHEN OTHERS THEN

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

576: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
577: ,x_log_level => 5);
578: END IF;
579:
580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.add_exc_msg
583: ( p_pkg_name => G_PKG_NAME
584: , p_procedure_name => l_api_name );

Line 582: FND_MSG_PUB.add_exc_msg

578: END IF;
579:
580: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.add_exc_msg
583: ( p_pkg_name => G_PKG_NAME
584: , p_procedure_name => l_api_name );
585:
586: END IF;

Line 587: FND_MSG_PUB.Count_And_Get

583: ( p_pkg_name => G_PKG_NAME
584: , p_procedure_name => l_api_name );
585:
586: END IF;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count ,
589: p_data => x_msg_data );
590:
591: END LOAD_TASK_ASSIGNMENTS;

Line 659: FND_MSG_PUB.initialize;

655: IF FND_API.TO_BOOLEAN( p_init_msg_list )
656:
657: THEN
658:
659: FND_MSG_PUB.initialize;
660:
661: END IF;
662:
663: -- Set API return status to success

Line 909: FND_MSG_PUB.Count_And_Get

905: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
906: ,x_log_level => 5);
907: END IF;
908:
909: FND_MSG_PUB.Count_And_Get
910: ( p_count => x_msg_count ,
911: p_data => x_msg_data );
912:
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

919: PA_DEBUG.write_log (x_module => G_PKG_NAME
920: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
921: ,x_log_level => 5);
922: END IF;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
924: THEN
925: FND_MSG_PUB.add_exc_msg
926: ( p_pkg_name => G_PKG_NAME
927: , p_procedure_name => l_api_name );

Line 925: FND_MSG_PUB.add_exc_msg

921: ,x_log_level => 5);
922: END IF;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
924: THEN
925: FND_MSG_PUB.add_exc_msg
926: ( p_pkg_name => G_PKG_NAME
927: , p_procedure_name => l_api_name );
928:
929: END IF;

Line 931: FND_MSG_PUB.Count_And_Get

927: , p_procedure_name => l_api_name );
928:
929: END IF;
930:
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count ,
933: p_data => x_msg_data );
934:
935: WHEN OTHERS THEN

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

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

Line 946: FND_MSG_PUB.add_exc_msg

942: ,x_log_level => 5);
943: END IF;
944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
945: THEN
946: FND_MSG_PUB.add_exc_msg
947: ( p_pkg_name => G_PKG_NAME
948: , p_procedure_name => l_api_name );
949:
950: END IF;

Line 951: FND_MSG_PUB.Count_And_Get

947: ( p_pkg_name => G_PKG_NAME
948: , p_procedure_name => l_api_name );
949:
950: END IF;
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count ,
953: p_data => x_msg_data );
954:
955: END Load_Task_Asgmt_Periods;

Line 1020: FND_MSG_PUB.initialize;

1016: -- Initialize the message table if requested.
1017:
1018: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1019: THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:
1023: -- Set API return status to success
1024:

Line 1107: FND_MSG_PUB.Count_And_Get

1103: PA_DEBUG.write_log (x_module => G_PKG_NAME
1104: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1105: ,x_log_level => 5);
1106: END IF;
1107: FND_MSG_PUB.Count_And_Get
1108: ( p_count => x_msg_count ,
1109: p_data => x_msg_data );
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1121: FND_MSG_PUB.Count_And_Get

1117: PA_DEBUG.write_log (x_module => G_PKG_NAME
1118: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1119: ,x_log_level => 5);
1120: END IF;
1121: FND_MSG_PUB.Count_And_Get
1122: ( p_count => x_msg_count ,
1123: p_data => x_msg_data );
1124:
1125: WHEN OTHERS THEN

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

1130: PA_DEBUG.write_log (x_module => G_PKG_NAME
1131: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1132: ,x_log_level => 5);
1133: END IF;
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN
1136: FND_MSG_PUB.add_exc_msg
1137: ( p_pkg_name => G_PKG_NAME
1138: , p_procedure_name => l_api_name );

Line 1136: FND_MSG_PUB.add_exc_msg

1132: ,x_log_level => 5);
1133: END IF;
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN
1136: FND_MSG_PUB.add_exc_msg
1137: ( p_pkg_name => G_PKG_NAME
1138: , p_procedure_name => l_api_name );
1139:
1140: END IF;

Line 1142: FND_MSG_PUB.Count_And_Get

1138: , p_procedure_name => l_api_name );
1139:
1140: END IF;
1141:
1142: FND_MSG_PUB.Count_And_Get
1143: ( p_count => x_msg_count ,
1144: p_data => x_msg_data );
1145:
1146: END EXECUTE_CREATE_TASK_ASGMTS;

Line 1199: FND_MSG_PUB.initialize;

1195: -- Initialize the message table if requested.
1196:
1197: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1198: THEN
1199: FND_MSG_PUB.initialize;
1200: END IF;
1201:
1202:
1203:

Line 1280: FND_MSG_PUB.Count_And_Get

1276: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1277:
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: FND_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count ,
1282: p_data => x_msg_data );
1283:
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

1285: THEN
1286: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.add_exc_msg
1292: ( p_pkg_name => G_PKG_NAME
1293: , p_procedure_name => l_api_name );

Line 1291: FND_MSG_PUB.add_exc_msg

1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.add_exc_msg
1292: ( p_pkg_name => G_PKG_NAME
1293: , p_procedure_name => l_api_name );
1294:
1295: END IF;

Line 1296: FND_MSG_PUB.Count_And_Get

1292: ( p_pkg_name => G_PKG_NAME
1293: , p_procedure_name => l_api_name );
1294:
1295: END IF;
1296: FND_MSG_PUB.Count_And_Get
1297: ( p_count => x_msg_count ,
1298: p_data => x_msg_data );
1299:
1300: WHEN OTHERS THEN

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

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

Line 1307: FND_MSG_PUB.add_exc_msg

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

Line 1313: FND_MSG_PUB.Count_And_Get

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

Line 1576: FND_MSG_PUB.initialize;

1572:
1573: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1574: THEN
1575:
1576: FND_MSG_PUB.initialize;
1577:
1578: END IF;
1579:
1580: -- Set API return status to success

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

1593:
1594: IF p_pm_product_code IS NOT NULL
1595: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1596:
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1598: pa_interface_utils_pub.map_new_amg_msg
1599: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
1600: ,p_msg_attribute => 'CHANGE'
1601: ,p_resize_flag => 'N'

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

1767: --dbms_output.put_line('Project Id:' || l_project_id);
1768: begin
1769:
1770: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
1771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1772: THEN
1773: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
1774: pa_interface_utils_pub.map_new_amg_msg
1775: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'

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

1813:
1814: THEN
1815: --dbms_output.put_line(' test struct.null or g miss..');
1816:
1817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1818: THEN
1819: --dbms_output.put_line(' test struct.null or gmiss err..');
1820: pa_interface_utils_pub.map_new_amg_msg
1821: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

Line 1839: IF FND_MSG_PUB.count_msg > 0 THEN

1835: -- Removed logic to lock version.
1836: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
1837:
1838: -- Bug 3940853: Raise locking error return from structure API
1839: IF FND_MSG_PUB.count_msg > 0 THEN
1840: x_return_status := FND_API.G_RET_STS_ERROR;
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:

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

1869: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1870: l_budget_version_id IS NULL )
1871: THEN
1872: --dbms_output.put_line(' budget version not obtained.. successful' );
1873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1874: THEN
1875: PA_UTILS.ADD_MESSAGE
1876: (p_app_short_name => 'PA',
1877: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'

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

2057:
2058: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2059: l_d_task_id IS NULL )
2060: THEN
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2062: THEN
2063: PA_UTILS.ADD_MESSAGE
2064: (p_app_short_name => 'PA',
2065: p_msg_name => 'PA_TASK_REQUIRED'

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

2091:
2092: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2093: l_d_task_id IS NULL )
2094: THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2096: THEN
2097: PA_UTILS.ADD_MESSAGE
2098: (p_app_short_name => 'PA',
2099: p_msg_name => 'PA_TASK_REQUIRED'

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

2114:
2115: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2116: l_task_elem_version_id IS NULL )
2117: THEN
2118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2119: THEN
2120: PA_UTILS.ADD_MESSAGE
2121: (p_app_short_name => 'PA',
2122: p_msg_name => 'PA_TASK_VERSION_REQUIRED'

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

2156: Close C_Res_List_Mem_Check;
2157:
2158: ELSE
2159:
2160: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2161: THEN
2162: PA_UTILS.ADD_MESSAGE
2163: (p_app_short_name => 'PA',
2164: p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID'

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

2189: p_task_assignments_in(i).end_date IS NOT NULL and
2190: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2191: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2192:
2193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2194: PA_UTILS.ADD_MESSAGE
2195: (p_app_short_name => 'PA',
2196: p_msg_name => 'PA_INVALID_DATES'
2197: );

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

2205: --dbms_output.put_line('test 7:');
2206: IF p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
2207: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2208: --dbms_output.put_line('pm_task_asgmt_reference is NULL/G_MISS...error');
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_PM_TASK_ASGMT_REF_REQ'

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

2223: OPEN C_Reference_Check(p_task_assignments_in(i).pm_task_asgmt_reference, l_budget_version_id);
2224: FETCH C_Reference_Check into C_Reference_Rec;
2225: IF C_Reference_Check%FOUND THEN
2226: --dbms_output.put_line('pm_task_asgmt_reference is EXISTING error');
2227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2228: THEN
2229: --CLOSE C_Reference_Check; Bug 3937017
2230: PA_UTILS.ADD_MESSAGE
2231: (p_app_short_name => 'PA',

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

2343: lk_resource_list_member_id_tbl(i) );
2344: fetch c_unique_res_check into c_unique_res_rec;
2345:
2346: IF c_unique_res_check%FOUND THEN
2347: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2348: THEN
2349: --CLOSE c_unique_res_check; Bug 3937017
2350: PA_UTILS.ADD_MESSAGE
2351: (p_app_short_name => 'PA',

Line 2762: FND_MSG_PUB.Count_And_Get

2758: ,x_log_level => 5);
2759: END IF;
2760: x_return_status := FND_API.G_RET_STS_ERROR;
2761:
2762: FND_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count ,
2764: p_data => x_msg_data );
2765:
2766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

2773: ,x_log_level => 5);
2774: END IF;
2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2776:
2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2778: THEN
2779: FND_MSG_PUB.add_exc_msg
2780: ( p_pkg_name => G_PKG_NAME
2781: , p_procedure_name => l_api_name );

Line 2779: FND_MSG_PUB.add_exc_msg

2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2776:
2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2778: THEN
2779: FND_MSG_PUB.add_exc_msg
2780: ( p_pkg_name => G_PKG_NAME
2781: , p_procedure_name => l_api_name );
2782:
2783: END IF;

Line 2784: FND_MSG_PUB.Count_And_Get

2780: ( p_pkg_name => G_PKG_NAME
2781: , p_procedure_name => l_api_name );
2782:
2783: END IF;
2784: FND_MSG_PUB.Count_And_Get
2785: ( p_count => x_msg_count ,
2786: p_data => x_msg_data );
2787:
2788:

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

2799: ,x_log_level => 5);
2800: END IF;
2801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2802:
2803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2804: THEN
2805: FND_MSG_PUB.add_exc_msg
2806: ( p_pkg_name => G_PKG_NAME
2807: , p_procedure_name => l_api_name );

Line 2805: FND_MSG_PUB.add_exc_msg

2801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2802:
2803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2804: THEN
2805: FND_MSG_PUB.add_exc_msg
2806: ( p_pkg_name => G_PKG_NAME
2807: , p_procedure_name => l_api_name );
2808:
2809: END IF;

Line 2811: FND_MSG_PUB.Count_And_Get

2807: , p_procedure_name => l_api_name );
2808:
2809: END IF;
2810:
2811: FND_MSG_PUB.Count_And_Get
2812: ( p_count => x_msg_count ,
2813: p_data => x_msg_data );
2814:
2815: END CREATE_TASK_ASSIGNMENTS;

Line 2884: FND_MSG_PUB.initialize;

2880: -- Initialize the message table if requested.
2881:
2882: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2883: THEN
2884: FND_MSG_PUB.initialize;
2885: END IF;
2886:
2887: -- Set API return status to success
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2894: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
2895: END IF;
2896:
2897: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
2898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2899: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
2900: ,p_msg_attribute => 'CHANGE'
2901: ,p_resize_flag => 'N'
2902: ,p_msg_context => 'GENERAL'

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

2913: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
2914: CLOSE C_Get_Budget_Version_Id;
2915:
2916: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
2917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2918: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
2919: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
2920: );
2921: END IF;

Line 3047: FND_MSG_PUB.Count_And_Get

3043: PA_DEBUG.write_log (x_module => G_PKG_NAME
3044: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3045: ,x_log_level => 5);
3046: END IF;
3047: FND_MSG_PUB.Count_And_Get
3048: ( p_count => x_msg_count ,
3049: p_data => x_msg_data );
3050:
3051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3061: FND_MSG_PUB.Count_And_Get

3057: PA_DEBUG.write_log (x_module => G_PKG_NAME
3058: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3059: ,x_log_level => 5);
3060: END IF;
3061: FND_MSG_PUB.Count_And_Get
3062: ( p_count => x_msg_count ,
3063: p_data => x_msg_data );
3064:
3065: WHEN OTHERS THEN

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

3074: PA_DEBUG.write_log (x_module => G_PKG_NAME
3075: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3076: ,x_log_level => 5);
3077: END IF;
3078: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: FND_MSG_PUB.add_exc_msg
3081: ( p_pkg_name => G_PKG_NAME
3082: , p_procedure_name => l_api_name );

Line 3080: FND_MSG_PUB.add_exc_msg

3076: ,x_log_level => 5);
3077: END IF;
3078: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: FND_MSG_PUB.add_exc_msg
3081: ( p_pkg_name => G_PKG_NAME
3082: , p_procedure_name => l_api_name );
3083:
3084: END IF;

Line 3086: FND_MSG_PUB.Count_And_Get

3082: , p_procedure_name => l_api_name );
3083:
3084: END IF;
3085:
3086: FND_MSG_PUB.Count_And_Get
3087: ( p_count => x_msg_count ,
3088: p_data => x_msg_data );
3089:
3090: END Create_Task_Assignment_Periods;

Line 3157: FND_MSG_PUB.initialize;

3153: -- Initialize the message table if requested.
3154:
3155: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3156: THEN
3157: FND_MSG_PUB.initialize;
3158: END IF;
3159:
3160:
3161:

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

3170: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3171: END IF;
3172:
3173: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3175: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3176: ,p_msg_attribute => 'CHANGE'
3177: ,p_resize_flag => 'N'
3178: ,p_msg_context => 'GENERAL'

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

3190: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3191: CLOSE C_Get_Budget_Version_Id;
3192:
3193: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3194: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3195: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3196: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3197: );
3198: END IF;

Line 3325: FND_MSG_PUB.Count_And_Get

3321: PA_DEBUG.write_log (x_module => G_PKG_NAME
3322: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3323: ,x_log_level => 5);
3324: END IF;
3325: FND_MSG_PUB.Count_And_Get
3326: ( p_count => x_msg_count ,
3327: p_data => x_msg_data );
3328:
3329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3339: FND_MSG_PUB.Count_And_Get

3335: PA_DEBUG.write_log (x_module => G_PKG_NAME
3336: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3337: ,x_log_level => 5);
3338: END IF;
3339: FND_MSG_PUB.Count_And_Get
3340: ( p_count => x_msg_count ,
3341: p_data => x_msg_data );
3342:
3343: WHEN OTHERS THEN

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

3352: PA_DEBUG.write_log (x_module => G_PKG_NAME
3353: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3354: ,x_log_level => 5);
3355: END IF;
3356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3357: THEN
3358: FND_MSG_PUB.add_exc_msg
3359: ( p_pkg_name => G_PKG_NAME
3360: , p_procedure_name => l_api_name );

Line 3358: FND_MSG_PUB.add_exc_msg

3354: ,x_log_level => 5);
3355: END IF;
3356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3357: THEN
3358: FND_MSG_PUB.add_exc_msg
3359: ( p_pkg_name => G_PKG_NAME
3360: , p_procedure_name => l_api_name );
3361:
3362: END IF;

Line 3364: FND_MSG_PUB.Count_And_Get

3360: , p_procedure_name => l_api_name );
3361:
3362: END IF;
3363:
3364: FND_MSG_PUB.Count_And_Get
3365: ( p_count => x_msg_count ,
3366: p_data => x_msg_data );
3367: END Update_Task_Assignment_Periods;
3368:

Line 3427: FND_MSG_PUB.initialize;

3423: -- Initialize the message table if requested.
3424:
3425: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3426: THEN
3427: FND_MSG_PUB.initialize;
3428: END IF;
3429:
3430:
3431:

Line 3491: FND_MSG_PUB.Count_And_Get

3487: PA_DEBUG.write_log (x_module => G_PKG_NAME
3488: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3489: ,x_log_level => 5);
3490: END IF;
3491: FND_MSG_PUB.Count_And_Get
3492: ( p_count => x_msg_count ,
3493: p_data => x_msg_data );
3494:
3495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3505: FND_MSG_PUB.Count_And_Get

3501: PA_DEBUG.write_log (x_module => G_PKG_NAME
3502: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3503: ,x_log_level => 5);
3504: END IF;
3505: FND_MSG_PUB.Count_And_Get
3506: ( p_count => x_msg_count ,
3507: p_data => x_msg_data );
3508:
3509: WHEN OTHERS THEN

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

3514: PA_DEBUG.write_log (x_module => G_PKG_NAME
3515: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3516: ,x_log_level => 5);
3517: END IF;
3518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3519: THEN
3520: FND_MSG_PUB.add_exc_msg
3521: ( p_pkg_name => G_PKG_NAME
3522: , p_procedure_name => l_api_name );

Line 3520: FND_MSG_PUB.add_exc_msg

3516: ,x_log_level => 5);
3517: END IF;
3518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3519: THEN
3520: FND_MSG_PUB.add_exc_msg
3521: ( p_pkg_name => G_PKG_NAME
3522: , p_procedure_name => l_api_name );
3523:
3524: END IF;

Line 3526: FND_MSG_PUB.Count_And_Get

3522: , p_procedure_name => l_api_name );
3523:
3524: END IF;
3525:
3526: FND_MSG_PUB.Count_And_Get
3527: ( p_count => x_msg_count ,
3528: p_data => x_msg_data );
3529: END Delete_Task_Assignments;
3530:

Line 3982: FND_MSG_PUB.initialize;

3978:
3979: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3980: THEN
3981:
3982: FND_MSG_PUB.initialize;
3983:
3984: END IF;
3985:
3986: --dbms_output.put_line('Update Task Asgmts.: API Comp. checked.');

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

4001:
4002: IF p_pm_product_code IS NOT NULL
4003: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4004:
4005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4006: pa_interface_utils_pub.map_new_amg_msg
4007: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4008: ,p_msg_attribute => 'CHANGE'
4009: ,p_resize_flag => 'N'

Line 4142: FND_MSG_PUB.initialize;

4138:
4139: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4140: THEN
4141:
4142: FND_MSG_PUB.initialize;
4143:
4144: END IF;
4145:
4146:

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

4187:
4188: --dbms_output.put_line('Project Id:' || l_project_id);
4189:
4190: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
4191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4192: THEN
4193: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
4194: pa_interface_utils_pub.map_new_amg_msg
4195: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'

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

4229:
4230: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4231: l_struct_elem_version_id IS NULL )
4232: THEN
4233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4234: THEN
4235: pa_interface_utils_pub.map_new_amg_msg
4236: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
4237: ,p_msg_attribute => 'CHANGE'

Line 4260: IF FND_MSG_PUB.count_msg > 0 THEN

4256: -- Removed logic to lock version.
4257: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
4258:
4259: -- Bug 3940853: Raise locking error return from structure API
4260: IF FND_MSG_PUB.count_msg > 0 THEN
4261: x_return_status := FND_API.G_RET_STS_ERROR;
4262: RAISE FND_API.G_EXC_ERROR;
4263: END IF;
4264:

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

4290: CLOSE C_Get_Budget_Version_Id;
4291:
4292: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4293: l_budget_version_id IS NULL ) THEN
4294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4295: THEN
4296: PA_UTILS.ADD_MESSAGE
4297: (p_app_short_name => 'PA',
4298: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'

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

4452:
4453: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4454: l_d_task_id IS NULL )
4455: THEN
4456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4457: THEN
4458: PA_UTILS.ADD_MESSAGE
4459: (p_app_short_name => 'PA',
4460: p_msg_name => 'PA_TASK_REQUIRED'

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

4494:
4495: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4496: l_d_task_id IS NULL )
4497: THEN
4498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4499: THEN
4500: PA_UTILS.ADD_MESSAGE
4501: (p_app_short_name => 'PA',
4502: p_msg_name => 'PA_TASK_REQUIRED'

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

4520:
4521: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;
4522:
4523: ELSE
4524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4525: THEN
4526: PA_UTILS.ADD_MESSAGE
4527: (p_app_short_name => 'PA',
4528: p_msg_name => 'PA_TASK_VERSION_REQUIRED'

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

4624: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND
4625: p_task_assignments_in(i).p_context <> 'D' AND
4626: (p_task_assignments_in(i).resource_list_member_id IS NULL OR
4627: p_task_assignments_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4629: THEN
4630: PA_UTILS.ADD_MESSAGE
4631: (p_app_short_name => 'PA',
4632: p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID'

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

4646: p_task_assignments_in(i).end_date IS NOT NULL and
4647: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
4648: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
4649:
4650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4651: PA_UTILS.ADD_MESSAGE
4652: (p_app_short_name => 'PA',
4653: p_msg_name => 'PA_INVALID_DATES'
4654: );

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

4661:
4662: IF p_task_assignments_in(i).pa_task_assignment_id IS NULL and
4663: (p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
4664: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
4665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4666: THEN
4667: PA_UTILS.ADD_MESSAGE
4668: (p_app_short_name => 'PA',
4669: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'

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

4681:
4682: IF p_task_assignments_in(i).use_task_schedule_flag IS NOT NULL AND
4683: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
4684: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4686: THEN
4687: pa_interface_utils_pub.map_new_amg_msg
4688: ( p_old_message_code => 'PA_TASK_SCHED_FLAG_INVALID' -->>>>
4689: ,p_msg_attribute => 'CHANGE'

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

4717:
4718: IF C_currency_exists%FOUND THEN
4719: l_currency_code := p_task_assignments_in(i).currency_code ;
4720: ELSIF C_currency_exists%NOTFOUND THEN
4721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4722: THEN
4723: pa_interface_utils_pub.map_new_amg_msg
4724: ( p_old_message_code => 'PA_INVALID_CURRENCY' -->>>>
4725: ,p_msg_attribute => 'CHANGE'

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

4799: IF p_task_assignments_in(i).billable_work_percent IS NOT NULL AND
4800: p_task_assignments_in(i).billable_work_percent <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
4801: ( p_task_assignments_in(i).billable_work_percent < 0 OR
4802: p_task_assignments_in(i).billable_work_percent > 100) THEN
4803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4804: THEN
4805: PA_UTILS.ADD_MESSAGE
4806: (p_app_short_name => 'PA',
4807: p_msg_name => 'PA_WEIGHTING_NOT_POSITIVE'

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

4851: l_Cost_Type_id := p_task_assignments_in(i).mfg_cost_type_id ;
4852: END IF;
4853:
4854: IF l_Cost_Type_exists is NOT NULL and l_Cost_Type_exists = 'N' THEN
4855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4856: THEN
4857: pa_interface_utils_pub.map_new_amg_msg
4858: ( p_old_message_code => 'PA_INVALID_COST_TYPE' -->>>>
4859: ,p_msg_attribute => 'CHANGE'

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

5275: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5276: pa_debug.g_err_stage:='pm_task_asgmt_reference is EXISTING error';
5277: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5278: END IF;
5279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5280: THEN
5281: --CLOSE C_Reference_Check;Bug 3937017
5282: PA_UTILS.ADD_MESSAGE
5283: (p_app_short_name => 'PA',

Line 6019: FND_MSG_PUB.Count_And_Get

6015: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
6016: ,x_log_level => 5);
6017: END IF;
6018:
6019: FND_MSG_PUB.Count_And_Get
6020: ( p_count => x_msg_count ,
6021: p_data => x_msg_data );
6022:
6023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

6030: PA_DEBUG.write_log (x_module => G_PKG_NAME
6031: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6032: ,x_log_level => 5);
6033: END IF;
6034: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6035: THEN
6036: FND_MSG_PUB.add_exc_msg
6037: ( p_pkg_name => G_PKG_NAME
6038: , p_procedure_name => l_api_name );

Line 6036: FND_MSG_PUB.add_exc_msg

6032: ,x_log_level => 5);
6033: END IF;
6034: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6035: THEN
6036: FND_MSG_PUB.add_exc_msg
6037: ( p_pkg_name => G_PKG_NAME
6038: , p_procedure_name => l_api_name );
6039:
6040: END IF;

Line 6041: FND_MSG_PUB.Count_And_Get

6037: ( p_pkg_name => G_PKG_NAME
6038: , p_procedure_name => l_api_name );
6039:
6040: END IF;
6041: FND_MSG_PUB.Count_And_Get
6042: ( p_count => x_msg_count ,
6043: p_data => x_msg_data );
6044:
6045: WHEN OTHERS THEN

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

6053: PA_DEBUG.write_log (x_module => G_PKG_NAME
6054: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6055: ,x_log_level => 5);
6056: END IF;
6057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6058: THEN
6059: FND_MSG_PUB.add_exc_msg
6060: ( p_pkg_name => G_PKG_NAME
6061: , p_procedure_name => l_api_name );

Line 6059: FND_MSG_PUB.add_exc_msg

6055: ,x_log_level => 5);
6056: END IF;
6057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6058: THEN
6059: FND_MSG_PUB.add_exc_msg
6060: ( p_pkg_name => G_PKG_NAME
6061: , p_procedure_name => l_api_name );
6062:
6063: END IF;

Line 6065: FND_MSG_PUB.Count_And_Get

6061: , p_procedure_name => l_api_name );
6062:
6063: END IF;
6064:
6065: FND_MSG_PUB.Count_And_Get
6066: ( p_count => x_msg_count ,
6067: p_data => x_msg_data );
6068:
6069: END UPDATE_TASK_ASSIGNMENTS;

Line 6139: FND_MSG_PUB.initialize;

6135: -- Initialize the message table if requested.
6136:
6137: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6138: THEN
6139: FND_MSG_PUB.initialize;
6140: END IF;
6141:
6142: -- Set API return status to success
6143:

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

6154: --dbms_output.put_line('Asgmt index is not passed.');
6155:
6156: RETURN;
6157:
6158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6159: pa_interface_utils_pub.map_new_amg_msg
6160: ( p_old_message_code => 'PA_INDEX_NOT_PROVIDED'
6161: ,p_msg_attribute => 'CHANGE'
6162: ,p_resize_flag => 'N'

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

6427: AND p_pa_project_id IS NOT NULL THEN
6428:
6429: IF l_dummy IS NULL THEN
6430:
6431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6432: THEN
6433: pa_interface_utils_pub.map_new_amg_msg
6434: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
6435: ,p_msg_attribute => 'CHANGE'

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

6446: END IF;
6447:
6448: ELSE
6449:
6450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6451: THEN
6452: pa_interface_utils_pub.map_new_amg_msg
6453: ( p_old_message_code => 'PA_PROJECT_ID_MISSING'
6454: ,p_msg_attribute => 'CHANGE'

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

6509:
6510: THEN
6511: --dbms_output.put_line(' test struct.null or g miss..');
6512:
6513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6514: THEN
6515: --dbms_output.put_line(' test struct.null or gmiss err..');
6516: pa_interface_utils_pub.map_new_amg_msg
6517: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

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

6542: p_pa_task_id);
6543: --dbms_output.put_line(l_task_ver_id);
6544: IF l_task_ver_id is NULL
6545: THEN
6546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6547: THEN
6548: pa_interface_utils_pub.map_new_amg_msg
6549: ( p_old_message_code => 'PA_TASK_ID_INVALID'
6550: ,p_msg_attribute => 'CHANGE'

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

6582: FETCH l_task_asgmt_id_csr INTO l_dummy;
6583:
6584: IF l_task_asgmt_id_csr%NOTFOUND
6585: THEN
6586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6587: THEN
6588: pa_interface_utils_pub.map_new_amg_msg
6589: ( p_old_message_code => 'PA_TASK_ASGMT_ID_INVALID'
6590: ,p_msg_attribute => 'CHANGE'

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

6636: -- END OF 4216541
6637:
6638: IF l_task_asgmt_id IS NULL THEN
6639:
6640: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
6641: AND p_add_error_msg_flag = 'Y' -- Bug 3937017
6642: -- In update_task_assignments flow, convert_pm_taref_to_id is called to determine whether
6643: -- the given assignment data should be created (if failed to convert) or updated (if conversion
6644: -- succeeds). Therefore, in this flow, failing to convert is not really an expected error

Line 6651: FND_MSG_PUB.add;

6647: THEN
6648: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
6649: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
6650: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
6651: FND_MSG_PUB.add;
6652:
6653: RAISE FND_API.G_EXC_ERROR;
6654:
6655: END IF;

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

6679: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
6680: IF l_task_asgmt_id IS NULL
6681: THEN
6682:
6683: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
6684: AND p_add_error_msg_flag = 'Y' -- Bug 3937017
6685: THEN
6686: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
6687: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');

Line 6689: FND_MSG_PUB.add;

6685: THEN
6686: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
6687: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
6688: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
6689: FND_MSG_PUB.add;
6690:
6691: RAISE FND_API.G_EXC_ERROR;
6692:
6693: END IF;

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

6700:
6701:
6702: ELSE
6703:
6704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6705: THEN
6706: pa_interface_utils_pub.map_new_amg_msg
6707: ( p_old_message_code => 'PA_TASK_ASGMT_REF_ID_MISSING'
6708: ,p_msg_attribute => 'CHANGE'

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

6737:
6738:
6739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6740:
6741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6742: THEN
6743: FND_MSG_PUB.add_exc_msg
6744: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'
6745: , p_procedure_name => l_api_name );

Line 6743: FND_MSG_PUB.add_exc_msg

6739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6740:
6741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6742: THEN
6743: FND_MSG_PUB.add_exc_msg
6744: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'
6745: , p_procedure_name => l_api_name );
6746:
6747: END IF;