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

Line 265: FND_MSG_PUB.initialize;

261: -- If user passes intentionally as N and calls singule update_progress then we will set it as Y
262: IF(G_bulk_load_flag = 'Y') THEN
263: l_project_id_out := p_project_id;
264: IF FND_API.to_boolean(p_init_msg_list) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: l_populate_pji_tables := p_populate_pji_tables;
268: l_rollup_entire_wbs := p_rollup_entire_wbs;
269: ELSE

Line 359: FND_MSG_PUB.add;

355: END IF;
356:
357: IF p_object_type <> 'PA_ASSIGNMENTS' AND p_object_type <> 'PA_DELIVERABLES' AND p_object_type <> 'PA_TASKS' AND p_object_type <> 'PA_STRUCTURES' THEN
358: FND_MESSAGE.SET_NAME('PA','PA_PROG_WRONG_OBJ_TYPE');
359: FND_MSG_PUB.add;
360: p_return_status := FND_API.G_RET_STS_ERROR;
361: RAISE FND_API.G_EXC_ERROR;
362: ELSE
363: l_object_type := p_object_type;

Line 368: FND_MSG_PUB.add;

364: END IF;
365:
366: IF ((l_object_type = 'PA_ASSIGNMENTS' OR l_object_type = 'PA_DELIVERABLES') AND p_structure_type = 'FINANCIAL') THEN
367: FND_MESSAGE.SET_NAME('PA','PA_PROG_ASGN_DEL_NOT_ALLOW_STR');
368: FND_MSG_PUB.add;
369: p_return_status := FND_API.G_RET_STS_ERROR;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:

Line 565: FND_MSG_PUB.add;

561: or ( l_object_version_id is null)
562: or ( l_structure_version_id is null AND l_object_type <> 'PA_DELIVERABLES' )
563: ) THEN
564: FND_MESSAGE.SET_NAME('PA','PA_TP_INV_PROJ_STRUC_INFO');
565: FND_MSG_PUB.add;
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: -- Bug 4218507 Added g_task_version_id_tbl

Line 903: FND_MSG_PUB.Count_And_Get

899: COMMIT;
900: END IF;
901: ELSE
902: ROLLBACK TO Update_Progress_Pub;
903: FND_MSG_PUB.Count_And_Get
904: ( p_count => p_msg_count
905: ,p_data => p_msg_data
906: );
907: END IF;

Line 915: FND_MSG_PUB.Count_And_Get

911:
912: p_return_status := FND_API.G_RET_STS_ERROR;
913: ROLLBACK TO Update_Progress_Pub;
914:
915: FND_MSG_PUB.Count_And_Get
916: ( p_count => p_msg_count
917: , p_data => p_msg_data
918: );
919:

Line 925: FND_MSG_PUB.Count_And_Get

921:
922: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: ROLLBACK TO Update_Progress_Pub;
924:
925: FND_MSG_PUB.Count_And_Get
926: ( p_count => p_msg_count
927: , p_data => p_msg_data
928: );
929:

Line 934: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

930:
931: WHEN ROW_ALREADY_LOCKED THEN
932:
933: p_return_status := FND_API.G_RET_STS_ERROR ;
934: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
937: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');
938: FND_MSG_PUB.Add;

Line 938: FND_MSG_PUB.Add;

934: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
937: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');
938: FND_MSG_PUB.Add;
939: END IF;
940: ROLLBACK TO Update_Progress_Pub;
941: FND_MSG_PUB.Count_And_Get
942: (p_count => p_msg_count

Line 941: FND_MSG_PUB.Count_And_Get

937: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');
938: FND_MSG_PUB.Add;
939: END IF;
940: ROLLBACK TO Update_Progress_Pub;
941: FND_MSG_PUB.Count_And_Get
942: (p_count => p_msg_count
943: , p_data => p_msg_data
944: );
945:

Line 951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

947:
948: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: ROLLBACK TO Update_Progress_Pub;
950:
951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , l_api_name
955: );

Line 952: FND_MSG_PUB.Add_Exc_Msg

948: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: ROLLBACK TO Update_Progress_Pub;
950:
951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , l_api_name
955: );
956: END IF;

Line 958: FND_MSG_PUB.Count_And_Get

954: , l_api_name
955: );
956: END IF;
957:
958: FND_MSG_PUB.Count_And_Get
959: ( p_count => p_msg_count
960: , p_data => p_msg_data
961: );
962:

Line 1136: FND_MSG_PUB.add;

1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134: IF l_function_allowed = 'N' THEN
1135: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1136: FND_MSG_PUB.add;
1137: p_return_status := FND_API.G_RET_STS_ERROR;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:

Line 1143: FND_MSG_PUB.initialize;

1139: END IF;
1140:
1141: IF FND_API.to_boolean(p_init_msg_list)
1142: THEN
1143: FND_MSG_PUB.initialize;
1144: END IF;
1145:
1146:
1147: -- VALUE LAYER -----------------------------------------------------------------------

Line 1171: FND_MSG_PUB.add;

1167: -- The user does not have query privileges on this project
1168: -- Hence, cannot update the project.Raise error
1169:
1170: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1171: FND_MSG_PUB.add;
1172: p_return_status := FND_API.G_RET_STS_ERROR;
1173: RAISE FND_API.G_EXC_ERROR;
1174: ELSE
1175: -- If the user has query privileges, then check whether

Line 1184: FND_MSG_PUB.add;

1180: -- The user does not have update privileges on this project
1181: -- Hence , raise error
1182:
1183: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1184: FND_MSG_PUB.add;
1185: p_return_status := FND_API.G_RET_STS_ERROR;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;

Line 1416: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1412:
1413:
1414: IF (SQL%ROWCOUNT = 0)
1415: THEN
1416: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1417: THEN
1418: FND_MESSAGE.SET_NAME('PA','PA_EV_INSERT_ERROR');
1419: FND_MSG_PUB.Add;
1420: END IF;

Line 1419: FND_MSG_PUB.Add;

1415: THEN
1416: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1417: THEN
1418: FND_MESSAGE.SET_NAME('PA','PA_EV_INSERT_ERROR');
1419: FND_MSG_PUB.Add;
1420: END IF;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:

Line 1435: FND_MSG_PUB.Count_And_Get

1431: WHEN FND_API.G_EXC_ERROR THEN
1432: p_return_status := FND_API.G_RET_STS_ERROR;
1433: ROLLBACK TO Update_Earned_Value_Pub;
1434:
1435: FND_MSG_PUB.Count_And_Get
1436: ( p_count => p_msg_count
1437: ,p_data => p_msg_data
1438: );
1439:

Line 1444: FND_MSG_PUB.Count_And_Get

1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: ROLLBACK TO Update_Earned_Value_Pub;
1443:
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_count => p_msg_count
1446: ,p_data => p_msg_data
1447: );
1448:

Line 1453: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1449: WHEN ROW_ALREADY_LOCKED THEN
1450:
1451: p_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1454: THEN
1455: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1456: FND_MESSAGE.SET_TOKEN('ENTITY', 'EARNED_VALUE');
1457: FND_MSG_PUB.Add;

Line 1457: FND_MSG_PUB.Add;

1453: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1454: THEN
1455: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1456: FND_MESSAGE.SET_TOKEN('ENTITY', 'EARNED_VALUE');
1457: FND_MSG_PUB.Add;
1458: END IF;
1459:
1460: ROLLBACK TO Update_Progress_Pub;
1461:

Line 1468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1464:
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: ROLLBACK TO Update_Earned_Value_Pub;
1467:
1468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1469: FND_MSG_PUB.Add_Exc_Msg
1470: ( G_PKG_NAME
1471: , l_api_name
1472: );

Line 1469: FND_MSG_PUB.Add_Exc_Msg

1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: ROLLBACK TO Update_Earned_Value_Pub;
1467:
1468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1469: FND_MSG_PUB.Add_Exc_Msg
1470: ( G_PKG_NAME
1471: , l_api_name
1472: );
1473: END IF;

Line 1475: FND_MSG_PUB.Count_And_Get

1471: , l_api_name
1472: );
1473: END IF;
1474:
1475: FND_MSG_PUB.Count_And_Get
1476: ( p_count => p_msg_count
1477: ,p_data => p_msg_data
1478: );
1479:

Line 1497: FND_MSG_PUB.initialize;

1493:
1494: BEGIN
1495: IF FND_API.to_boolean(p_init_msg_list)
1496: THEN
1497: FND_MSG_PUB.initialize;
1498: END IF;
1499:
1500: p_return_status := FND_API.G_RET_STS_SUCCESS;
1501:

Line 1506: FND_MSG_PUB.Count_And_Get

1502: G_TASK_PROGRESS_in_tbl.delete;
1503: G_TASK_PROGRESS_tbl_count := 0;
1504:
1505: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1506: FND_MSG_PUB.Count_And_Get
1507: ( p_count => p_msg_count
1508: ,p_data => p_msg_data
1509: );
1510: END IF;

Line 1514: FND_MSG_PUB.Count_And_Get

1510: END IF;
1511: EXCEPTION
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: p_return_status := FND_API.G_RET_STS_ERROR;
1514: FND_MSG_PUB.Count_And_Get
1515: ( p_count => p_msg_count
1516: ,p_data => p_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1520: FND_MSG_PUB.Count_And_Get

1516: ,p_data => p_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_count => p_msg_count
1522: ,p_data => p_msg_data
1523: );
1524: WHEN OTHERS THEN

Line 1526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1522: ,p_data => p_msg_data
1523: );
1524: WHEN OTHERS THEN
1525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1527: FND_MSG_PUB.Add_Exc_Msg
1528: ( G_PKG_NAME
1529: , l_api_name
1530: );

Line 1527: FND_MSG_PUB.Add_Exc_Msg

1523: );
1524: WHEN OTHERS THEN
1525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1527: FND_MSG_PUB.Add_Exc_Msg
1528: ( G_PKG_NAME
1529: , l_api_name
1530: );
1531: END IF;

Line 1532: FND_MSG_PUB.Count_And_Get

1528: ( G_PKG_NAME
1529: , l_api_name
1530: );
1531: END IF;
1532: FND_MSG_PUB.Count_And_Get
1533: ( p_count => p_msg_count
1534: ,p_data => p_msg_data
1535: );
1536:

Line 1620: FND_MSG_PUB.initialize;

1616: END IF;
1617:
1618: IF FND_API.to_boolean(p_init_msg_list)
1619: THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622:
1623: p_return_status := FND_API.G_RET_STS_SUCCESS;
1624:

Line 1985: FND_MSG_PUB.Count_And_Get

1981:
1982: END LOOP;
1983:
1984: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1985: FND_MSG_PUB.Count_And_Get
1986: ( p_count => p_msg_count
1987: ,p_data => p_msg_data
1988: );
1989: END IF;

Line 1993: FND_MSG_PUB.Count_And_Get

1989: END IF;
1990: EXCEPTION
1991: WHEN FND_API.G_EXC_ERROR THEN
1992: p_return_status := FND_API.G_RET_STS_ERROR;
1993: FND_MSG_PUB.Count_And_Get
1994: ( p_count => p_msg_count
1995: ,p_data => p_msg_data
1996: );
1997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1999: FND_MSG_PUB.Count_And_Get

1995: ,p_data => p_msg_data
1996: );
1997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1999: FND_MSG_PUB.Count_And_Get
2000: ( p_count => p_msg_count
2001: ,p_data => p_msg_data
2002: );
2003: WHEN OTHERS THEN

Line 2005: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2001: ,p_data => p_msg_data
2002: );
2003: WHEN OTHERS THEN
2004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2006: FND_MSG_PUB.Add_Exc_Msg
2007: ( G_PKG_NAME
2008: , l_api_name
2009: );

Line 2006: FND_MSG_PUB.Add_Exc_Msg

2002: );
2003: WHEN OTHERS THEN
2004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2006: FND_MSG_PUB.Add_Exc_Msg
2007: ( G_PKG_NAME
2008: , l_api_name
2009: );
2010: END IF;

Line 2011: FND_MSG_PUB.Count_And_Get

2007: ( G_PKG_NAME
2008: , l_api_name
2009: );
2010: END IF;
2011: FND_MSG_PUB.Count_And_Get
2012: ( p_count => p_msg_count
2013: ,p_data => p_msg_data
2014: );
2015: END Load_Task_Progress;

Line 2140: FND_MSG_PUB.initialize;

2136: BEGIN
2137:
2138: IF FND_API.to_boolean(p_init_msg_list)
2139: THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2143: savepoint Execute_Update_Task_Progress;
2144:

Line 2167: FND_MSG_PUB.add;

2163:
2164:
2165: IF(G_TASK_PROGRESS_tbl_count = 0) THEN
2166: FND_MESSAGE.SET_NAME('PA','PA_NO_TASK_PROGRESS_UPDATE');
2167: FND_MSG_PUB.add;
2168: p_return_status := FND_API.G_RET_STS_ERROR;
2169: RAISE FND_API.G_EXC_ERROR;
2170: -- Bug 3606627 : Changed the following if condition to >=1 from =1
2171: ELSIF(G_TASK_PROGRESS_tbl_count >= 1) THEN

Line 2352: FND_MSG_PUB.get (

2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: p_return_status := l_return_status;
2351:
2352: FND_MSG_PUB.get (
2353: p_msg_index => l_msg_count,
2354: p_encoded => FND_API.G_FALSE,
2355: p_data => l_data,
2356: p_msg_index_out => l_msg_index_out );

Line 2359: FND_MSG_PUB.DELETE_MSG(p_msg_index => l_msg_count);

2355: p_data => l_data,
2356: p_msg_index_out => l_msg_index_out );
2357:
2358: IF l_data IS NOT NULL THEN
2359: FND_MSG_PUB.DELETE_MSG(p_msg_index => l_msg_count);
2360:
2361: /* Commenting for bug 8472681
2362: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NAME_NUM_ERR',
2363: 'ROWNUM', 'ROW# '||i,--Added by rtarway for bug 4293075

Line 2527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',

2523: delete from PA_PROG_ACT_BY_PERIOD_TEMP where project_id = l_project_id_out
2524: AND structure_version_id = l_structure_version_id;
2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2528: p_procedure_name => 'execute_update_progress',
2529: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
2530: RAISE FND_API.G_EXC_ERROR;
2531: END;

Line 2545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',

2541: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
2542: x_return_status => l_return_status);
2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2546: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2547: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE Failed:'||SQLERRM,1,120));
2548: RAISE FND_API.G_EXC_ERROR;
2549: END;

Line 2587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',

2583: x_msg_code => l_msg_code
2584: );
2585: EXCEPTION
2586: WHEN OTHERS THEN
2587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2588: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2589: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data: failed'||SQLERRM,1,120));
2590: RAISE FND_API.G_EXC_ERROR;
2591: END;

Line 2924: FND_MSG_PUB.Count_And_Get

2920: COMMIT;
2921: END IF;
2922: ELSE
2923: ROLLBACK TO Execute_Update_Task_Progress;
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_count => p_msg_count
2926: ,p_data => p_msg_data
2927: );
2928: END IF;

Line 2936: FND_MSG_PUB.Count_And_Get

2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: p_return_status := FND_API.G_RET_STS_ERROR;
2935: ROLLBACK TO Execute_Update_Task_Progress;
2936: FND_MSG_PUB.Count_And_Get
2937: ( p_count => p_msg_count
2938: ,p_data => p_msg_data
2939: );
2940: G_bulk_load_flag :='N';

Line 2946: FND_MSG_PUB.Count_And_Get

2942: G_TASK_PROGRESS_tbl_count := 0;
2943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2945: ROLLBACK TO Execute_Update_Task_Progress;
2946: FND_MSG_PUB.Count_And_Get
2947: ( p_count => p_msg_count
2948: ,p_data => p_msg_data
2949: );
2950: G_bulk_load_flag :='N';

Line 2956: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2952: G_TASK_PROGRESS_tbl_count := 0;
2953: WHEN OTHERS THEN
2954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955: ROLLBACK TO Execute_Update_Task_Progress;
2956: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957: FND_MSG_PUB.Add_Exc_Msg
2958: ( G_PKG_NAME
2959: , l_api_name
2960: );

Line 2957: FND_MSG_PUB.Add_Exc_Msg

2953: WHEN OTHERS THEN
2954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955: ROLLBACK TO Execute_Update_Task_Progress;
2956: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957: FND_MSG_PUB.Add_Exc_Msg
2958: ( G_PKG_NAME
2959: , l_api_name
2960: );
2961: END IF;

Line 2962: FND_MSG_PUB.Count_And_Get

2958: ( G_PKG_NAME
2959: , l_api_name
2960: );
2961: END IF;
2962: FND_MSG_PUB.Count_And_Get
2963: ( p_count => p_msg_count
2964: ,p_data => p_msg_data
2965: );
2966: G_bulk_load_flag :='N';

Line 3005: FND_MSG_PUB.initialize;

3001:
3002: BEGIN
3003: IF FND_API.to_boolean(p_init_msg_list)
3004: THEN
3005: FND_MSG_PUB.initialize;
3006: END IF;
3007:
3008: p_return_status := FND_API.G_RET_STS_SUCCESS;
3009:

Line 3074: FND_MSG_PUB.add;

3070: RAISE FND_API.G_EXC_ERROR;
3071: END IF;
3072: IF l_function_allowed = 'N' THEN
3073: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
3074: FND_MSG_PUB.add;
3075: p_return_status := FND_API.G_RET_STS_ERROR;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: IF FND_API.to_boolean(p_init_msg_list)

Line 3080: FND_MSG_PUB.initialize;

3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: IF FND_API.to_boolean(p_init_msg_list)
3079: THEN
3080: FND_MSG_PUB.initialize;
3081: END IF;
3082:
3083: -- VALUE LAYER -----------------------------------------------------------------------
3084:

Line 3091: FND_MSG_PUB.add;

3087: -- The user does not have query privileges on this project
3088: -- Hence, cannot update the project.Raise error
3089:
3090: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3091: FND_MSG_PUB.add;
3092: p_return_status := FND_API.G_RET_STS_ERROR;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSE
3095: -- If the user has query privileges, then check whether

Line 3104: FND_MSG_PUB.add;

3100: -- The user does not have update privileges on this project
3101: -- Hence , raise error
3102:
3103: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3104: FND_MSG_PUB.add;
3105: p_return_status := FND_API.G_RET_STS_ERROR;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: END IF;

Line 3111: FND_MSG_PUB.Count_And_Get

3107: END IF;
3108: END IF;
3109:
3110: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
3111: FND_MSG_PUB.Count_And_Get
3112: ( p_count => p_msg_count
3113: ,p_data => p_msg_data
3114: );
3115: END IF;

Line 3119: FND_MSG_PUB.Count_And_Get

3115: END IF;
3116: EXCEPTION
3117: WHEN FND_API.G_EXC_ERROR THEN
3118: p_return_status := FND_API.G_RET_STS_ERROR;
3119: FND_MSG_PUB.Count_And_Get
3120: ( p_count => p_msg_count
3121: ,p_data => p_msg_data
3122: );
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3125: FND_MSG_PUB.Count_And_Get

3121: ,p_data => p_msg_data
3122: );
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => p_msg_count
3127: ,p_data => p_msg_data
3128: );
3129: WHEN OTHERS THEN

Line 3131: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3127: ,p_data => p_msg_data
3128: );
3129: WHEN OTHERS THEN
3130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3132: FND_MSG_PUB.Add_Exc_Msg
3133: ( G_PKG_NAME
3134: , l_api_name
3135: );

Line 3132: FND_MSG_PUB.Add_Exc_Msg

3128: );
3129: WHEN OTHERS THEN
3130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3132: FND_MSG_PUB.Add_Exc_Msg
3133: ( G_PKG_NAME
3134: , l_api_name
3135: );
3136: END IF;

Line 3137: FND_MSG_PUB.Count_And_Get

3133: ( G_PKG_NAME
3134: , l_api_name
3135: );
3136: END IF;
3137: FND_MSG_PUB.Count_And_Get
3138: ( p_count => p_msg_count
3139: ,p_data => p_msg_data
3140: );
3141:

Line 3172: FND_MSG_PUB.initialize;

3168: l_api_name VARCHAR2(30) := 'update_task_progress_amg';
3169: begin
3170: IF FND_API.to_boolean(p_init_msg_list)
3171: THEN
3172: FND_MSG_PUB.initialize;
3173: END IF;
3174:
3175: x_return_status := FND_API.G_RET_STS_SUCCESS;
3176:

Line 3283: fnd_msg_pub.count_and_get

3279: ,x_msg_count => x_msg_count
3280: ,x_msg_data => x_msg_data);
3281:
3282: if (x_return_status <> fnd_api.g_ret_sts_success ) then
3283: fnd_msg_pub.count_and_get
3284: (p_count => x_msg_count
3285: ,p_data => x_msg_data);
3286: end if;
3287:

Line 3292: fnd_msg_pub.count_and_get

3288: exception
3289:
3290: when fnd_api.g_exc_error then
3291: x_return_status := fnd_api.g_ret_sts_error;
3292: fnd_msg_pub.count_and_get
3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);
3295: when fnd_api.g_exc_unexpected_error then
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3297: fnd_msg_pub.count_and_get

3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);
3295: when fnd_api.g_exc_unexpected_error then
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;
3297: fnd_msg_pub.count_and_get
3298: (p_count => x_msg_count
3299: ,p_data => x_msg_data);
3300: when others then
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3302: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then

3298: (p_count => x_msg_count
3299: ,p_data => x_msg_data);
3300: when others then
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3303: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3304: end if;
3305: fnd_msg_pub.count_and_get
3306: (p_count => x_msg_count

Line 3303: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);

3299: ,p_data => x_msg_data);
3300: when others then
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3303: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3304: end if;
3305: fnd_msg_pub.count_and_get
3306: (p_count => x_msg_count
3307: ,p_data => x_msg_data);

Line 3305: fnd_msg_pub.count_and_get

3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3303: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3304: end if;
3305: fnd_msg_pub.count_and_get
3306: (p_count => x_msg_count
3307: ,p_data => x_msg_data);
3308:
3309: end update_task_progress_amg;

Line 3482: FND_MSG_PUB.Count_And_Get

3478: x_return_status := FND_API.G_RET_STS_ERROR ;
3479: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3480: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3481: END IF;
3482: FND_MSG_PUB.Count_And_Get
3483: ( p_count => x_msg_count ,
3484: p_data => x_msg_data );
3485: when OTHERS then
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3483: ( p_count => x_msg_count ,
3484: p_data => x_msg_data );
3485: when OTHERS then
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3488: FND_MSG_PUB.add_exc_msg
3489: ( p_pkg_name => G_PKG_NAME
3490: , p_procedure_name => 'UPDATE_PROGRESS_BULK' );
3491: END IF;

Line 3488: FND_MSG_PUB.add_exc_msg

3484: p_data => x_msg_data );
3485: when OTHERS then
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3488: FND_MSG_PUB.add_exc_msg
3489: ( p_pkg_name => G_PKG_NAME
3490: , p_procedure_name => 'UPDATE_PROGRESS_BULK' );
3491: END IF;
3492: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN

Line 3495: FND_MSG_PUB.Count_And_Get

3491: END IF;
3492: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3493: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3494: END IF;
3495: FND_MSG_PUB.Count_And_Get
3496: ( p_count => x_msg_count ,
3497: p_data => x_msg_data );
3498: END update_progress_bulk;
3499: