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 899: FND_MSG_PUB.Count_And_Get

895: COMMIT;
896: END IF;
897: ELSE
898: ROLLBACK TO Update_Progress_Pub;
899: FND_MSG_PUB.Count_And_Get
900: ( p_count => p_msg_count
901: ,p_data => p_msg_data
902: );
903: END IF;

Line 911: FND_MSG_PUB.Count_And_Get

907:
908: p_return_status := FND_API.G_RET_STS_ERROR;
909: ROLLBACK TO Update_Progress_Pub;
910:
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => p_msg_count
913: , p_data => p_msg_data
914: );
915:

Line 921: FND_MSG_PUB.Count_And_Get

917:
918: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: ROLLBACK TO Update_Progress_Pub;
920:
921: FND_MSG_PUB.Count_And_Get
922: ( p_count => p_msg_count
923: , p_data => p_msg_data
924: );
925:

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

926:
927: WHEN ROW_ALREADY_LOCKED THEN
928:
929: p_return_status := FND_API.G_RET_STS_ERROR ;
930: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
931: THEN
932: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
933: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');
934: FND_MSG_PUB.Add;

Line 934: FND_MSG_PUB.Add;

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

Line 937: FND_MSG_PUB.Count_And_Get

933: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');
934: FND_MSG_PUB.Add;
935: END IF;
936: ROLLBACK TO Update_Progress_Pub;
937: FND_MSG_PUB.Count_And_Get
938: (p_count => p_msg_count
939: , p_data => p_msg_data
940: );
941:

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

943:
944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: ROLLBACK TO Update_Progress_Pub;
946:
947: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg
949: ( G_PKG_NAME
950: , l_api_name
951: );

Line 948: FND_MSG_PUB.Add_Exc_Msg

944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: ROLLBACK TO Update_Progress_Pub;
946:
947: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg
949: ( G_PKG_NAME
950: , l_api_name
951: );
952: END IF;

Line 954: FND_MSG_PUB.Count_And_Get

950: , l_api_name
951: );
952: END IF;
953:
954: FND_MSG_PUB.Count_And_Get
955: ( p_count => p_msg_count
956: , p_data => p_msg_data
957: );
958:

Line 1132: FND_MSG_PUB.add;

1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130: IF l_function_allowed = 'N' THEN
1131: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1132: FND_MSG_PUB.add;
1133: p_return_status := FND_API.G_RET_STS_ERROR;
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:

Line 1139: FND_MSG_PUB.initialize;

1135: END IF;
1136:
1137: IF FND_API.to_boolean(p_init_msg_list)
1138: THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141:
1142:
1143: -- VALUE LAYER -----------------------------------------------------------------------

Line 1167: FND_MSG_PUB.add;

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

Line 1180: FND_MSG_PUB.add;

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

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

1408:
1409:
1410: IF (SQL%ROWCOUNT = 0)
1411: THEN
1412: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1413: THEN
1414: FND_MESSAGE.SET_NAME('PA','PA_EV_INSERT_ERROR');
1415: FND_MSG_PUB.Add;
1416: END IF;

Line 1415: FND_MSG_PUB.Add;

1411: THEN
1412: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1413: THEN
1414: FND_MESSAGE.SET_NAME('PA','PA_EV_INSERT_ERROR');
1415: FND_MSG_PUB.Add;
1416: END IF;
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419:

Line 1431: FND_MSG_PUB.Count_And_Get

1427: WHEN FND_API.G_EXC_ERROR THEN
1428: p_return_status := FND_API.G_RET_STS_ERROR;
1429: ROLLBACK TO Update_Earned_Value_Pub;
1430:
1431: FND_MSG_PUB.Count_And_Get
1432: ( p_count => p_msg_count
1433: ,p_data => p_msg_data
1434: );
1435:

Line 1440: FND_MSG_PUB.Count_And_Get

1436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1437: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: ROLLBACK TO Update_Earned_Value_Pub;
1439:
1440: FND_MSG_PUB.Count_And_Get
1441: ( p_count => p_msg_count
1442: ,p_data => p_msg_data
1443: );
1444:

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

1445: WHEN ROW_ALREADY_LOCKED THEN
1446:
1447: p_return_status := FND_API.G_RET_STS_ERROR ;
1448:
1449: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1450: THEN
1451: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1452: FND_MESSAGE.SET_TOKEN('ENTITY', 'EARNED_VALUE');
1453: FND_MSG_PUB.Add;

Line 1453: FND_MSG_PUB.Add;

1449: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1450: THEN
1451: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1452: FND_MESSAGE.SET_TOKEN('ENTITY', 'EARNED_VALUE');
1453: FND_MSG_PUB.Add;
1454: END IF;
1455:
1456: ROLLBACK TO Update_Progress_Pub;
1457:

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

1460:
1461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1462: ROLLBACK TO Update_Earned_Value_Pub;
1463:
1464: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1465: FND_MSG_PUB.Add_Exc_Msg
1466: ( G_PKG_NAME
1467: , l_api_name
1468: );

Line 1465: FND_MSG_PUB.Add_Exc_Msg

1461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1462: ROLLBACK TO Update_Earned_Value_Pub;
1463:
1464: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1465: FND_MSG_PUB.Add_Exc_Msg
1466: ( G_PKG_NAME
1467: , l_api_name
1468: );
1469: END IF;

Line 1471: FND_MSG_PUB.Count_And_Get

1467: , l_api_name
1468: );
1469: END IF;
1470:
1471: FND_MSG_PUB.Count_And_Get
1472: ( p_count => p_msg_count
1473: ,p_data => p_msg_data
1474: );
1475:

Line 1493: FND_MSG_PUB.initialize;

1489:
1490: BEGIN
1491: IF FND_API.to_boolean(p_init_msg_list)
1492: THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495:
1496: p_return_status := FND_API.G_RET_STS_SUCCESS;
1497:

Line 1502: FND_MSG_PUB.Count_And_Get

1498: G_TASK_PROGRESS_in_tbl.delete;
1499: G_TASK_PROGRESS_tbl_count := 0;
1500:
1501: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1502: FND_MSG_PUB.Count_And_Get
1503: ( p_count => p_msg_count
1504: ,p_data => p_msg_data
1505: );
1506: END IF;

Line 1510: FND_MSG_PUB.Count_And_Get

1506: END IF;
1507: EXCEPTION
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: p_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get
1511: ( p_count => p_msg_count
1512: ,p_data => p_msg_data
1513: );
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1516: FND_MSG_PUB.Count_And_Get

1512: ,p_data => p_msg_data
1513: );
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => p_msg_count
1518: ,p_data => p_msg_data
1519: );
1520: WHEN OTHERS THEN

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

1518: ,p_data => p_msg_data
1519: );
1520: WHEN OTHERS THEN
1521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1523: FND_MSG_PUB.Add_Exc_Msg
1524: ( G_PKG_NAME
1525: , l_api_name
1526: );

Line 1523: FND_MSG_PUB.Add_Exc_Msg

1519: );
1520: WHEN OTHERS THEN
1521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1523: FND_MSG_PUB.Add_Exc_Msg
1524: ( G_PKG_NAME
1525: , l_api_name
1526: );
1527: END IF;

Line 1528: FND_MSG_PUB.Count_And_Get

1524: ( G_PKG_NAME
1525: , l_api_name
1526: );
1527: END IF;
1528: FND_MSG_PUB.Count_And_Get
1529: ( p_count => p_msg_count
1530: ,p_data => p_msg_data
1531: );
1532:

Line 1616: FND_MSG_PUB.initialize;

1612: END IF;
1613:
1614: IF FND_API.to_boolean(p_init_msg_list)
1615: THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619: p_return_status := FND_API.G_RET_STS_SUCCESS;
1620:

Line 1981: FND_MSG_PUB.Count_And_Get

1977:
1978: END LOOP;
1979:
1980: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1981: FND_MSG_PUB.Count_And_Get
1982: ( p_count => p_msg_count
1983: ,p_data => p_msg_data
1984: );
1985: END IF;

Line 1989: FND_MSG_PUB.Count_And_Get

1985: END IF;
1986: EXCEPTION
1987: WHEN FND_API.G_EXC_ERROR THEN
1988: p_return_status := FND_API.G_RET_STS_ERROR;
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => p_msg_count
1991: ,p_data => p_msg_data
1992: );
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1995: FND_MSG_PUB.Count_And_Get

1991: ,p_data => p_msg_data
1992: );
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1995: FND_MSG_PUB.Count_And_Get
1996: ( p_count => p_msg_count
1997: ,p_data => p_msg_data
1998: );
1999: WHEN OTHERS THEN

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

1997: ,p_data => p_msg_data
1998: );
1999: WHEN OTHERS THEN
2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2002: FND_MSG_PUB.Add_Exc_Msg
2003: ( G_PKG_NAME
2004: , l_api_name
2005: );

Line 2002: FND_MSG_PUB.Add_Exc_Msg

1998: );
1999: WHEN OTHERS THEN
2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2002: FND_MSG_PUB.Add_Exc_Msg
2003: ( G_PKG_NAME
2004: , l_api_name
2005: );
2006: END IF;

Line 2007: FND_MSG_PUB.Count_And_Get

2003: ( G_PKG_NAME
2004: , l_api_name
2005: );
2006: END IF;
2007: FND_MSG_PUB.Count_And_Get
2008: ( p_count => p_msg_count
2009: ,p_data => p_msg_data
2010: );
2011: END Load_Task_Progress;

Line 2123: FND_MSG_PUB.initialize;

2119: BEGIN
2120:
2121: IF FND_API.to_boolean(p_init_msg_list)
2122: THEN
2123: FND_MSG_PUB.initialize;
2124: END IF;
2125: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2126: savepoint Execute_Update_Task_Progress;
2127:

Line 2150: FND_MSG_PUB.add;

2146:
2147:
2148: IF(G_TASK_PROGRESS_tbl_count = 0) THEN
2149: FND_MESSAGE.SET_NAME('PA','PA_NO_TASK_PROGRESS_UPDATE');
2150: FND_MSG_PUB.add;
2151: p_return_status := FND_API.G_RET_STS_ERROR;
2152: RAISE FND_API.G_EXC_ERROR;
2153: -- Bug 3606627 : Changed the following if condition to >=1 from =1
2154: ELSIF(G_TASK_PROGRESS_tbl_count >= 1) THEN

Line 2331: FND_MSG_PUB.get (

2327:
2328: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2329: p_return_status := l_return_status;
2330:
2331: FND_MSG_PUB.get (
2332: p_msg_index => l_msg_count,
2333: p_encoded => FND_API.G_FALSE,
2334: p_data => l_data,
2335: p_msg_index_out => l_msg_index_out );

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

2334: p_data => l_data,
2335: p_msg_index_out => l_msg_index_out );
2336:
2337: IF l_data IS NOT NULL THEN
2338: FND_MSG_PUB.DELETE_MSG(p_msg_index => l_msg_count);
2339:
2340: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NAME_NUM_ERR',
2341: 'ROWNUM', 'ROW# '||i,--Added by rtarway for bug 4293075
2342: 'TASK_NAME', G_TASK_PROGRESS_in_tbl(i).TASK_NAME,

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

2424: delete from PA_PROG_ACT_BY_PERIOD_TEMP where project_id = l_project_id_out
2425: AND structure_version_id = l_structure_version_id;
2426: EXCEPTION
2427: WHEN OTHERS THEN
2428: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2429: p_procedure_name => 'execute_update_progress',
2430: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
2431: RAISE FND_API.G_EXC_ERROR;
2432: END;

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

2442: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
2443: x_return_status => l_return_status);
2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2447: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2448: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE Failed:'||SQLERRM,1,120));
2449: RAISE FND_API.G_EXC_ERROR;
2450: END;

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

2484: x_msg_code => l_msg_code
2485: );
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2489: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2490: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data: failed'||SQLERRM,1,120));
2491: RAISE FND_API.G_EXC_ERROR;
2492: END;

Line 2825: FND_MSG_PUB.Count_And_Get

2821: COMMIT;
2822: END IF;
2823: ELSE
2824: ROLLBACK TO Execute_Update_Task_Progress;
2825: FND_MSG_PUB.Count_And_Get
2826: ( p_count => p_msg_count
2827: ,p_data => p_msg_data
2828: );
2829: END IF;

Line 2837: FND_MSG_PUB.Count_And_Get

2833: EXCEPTION
2834: WHEN FND_API.G_EXC_ERROR THEN
2835: p_return_status := FND_API.G_RET_STS_ERROR;
2836: ROLLBACK TO Execute_Update_Task_Progress;
2837: FND_MSG_PUB.Count_And_Get
2838: ( p_count => p_msg_count
2839: ,p_data => p_msg_data
2840: );
2841: G_bulk_load_flag :='N';

Line 2847: FND_MSG_PUB.Count_And_Get

2843: G_TASK_PROGRESS_tbl_count := 0;
2844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2845: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846: ROLLBACK TO Execute_Update_Task_Progress;
2847: FND_MSG_PUB.Count_And_Get
2848: ( p_count => p_msg_count
2849: ,p_data => p_msg_data
2850: );
2851: G_bulk_load_flag :='N';

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

2853: G_TASK_PROGRESS_tbl_count := 0;
2854: WHEN OTHERS THEN
2855: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: ROLLBACK TO Execute_Update_Task_Progress;
2857: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2858: FND_MSG_PUB.Add_Exc_Msg
2859: ( G_PKG_NAME
2860: , l_api_name
2861: );

Line 2858: FND_MSG_PUB.Add_Exc_Msg

2854: WHEN OTHERS THEN
2855: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: ROLLBACK TO Execute_Update_Task_Progress;
2857: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2858: FND_MSG_PUB.Add_Exc_Msg
2859: ( G_PKG_NAME
2860: , l_api_name
2861: );
2862: END IF;

Line 2863: FND_MSG_PUB.Count_And_Get

2859: ( G_PKG_NAME
2860: , l_api_name
2861: );
2862: END IF;
2863: FND_MSG_PUB.Count_And_Get
2864: ( p_count => p_msg_count
2865: ,p_data => p_msg_data
2866: );
2867: G_bulk_load_flag :='N';

Line 2906: FND_MSG_PUB.initialize;

2902:
2903: BEGIN
2904: IF FND_API.to_boolean(p_init_msg_list)
2905: THEN
2906: FND_MSG_PUB.initialize;
2907: END IF;
2908:
2909: p_return_status := FND_API.G_RET_STS_SUCCESS;
2910:

Line 2975: FND_MSG_PUB.add;

2971: RAISE FND_API.G_EXC_ERROR;
2972: END IF;
2973: IF l_function_allowed = 'N' THEN
2974: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
2975: FND_MSG_PUB.add;
2976: p_return_status := FND_API.G_RET_STS_ERROR;
2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;
2979: IF FND_API.to_boolean(p_init_msg_list)

Line 2981: FND_MSG_PUB.initialize;

2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;
2979: IF FND_API.to_boolean(p_init_msg_list)
2980: THEN
2981: FND_MSG_PUB.initialize;
2982: END IF;
2983:
2984: -- VALUE LAYER -----------------------------------------------------------------------
2985:

Line 2992: FND_MSG_PUB.add;

2988: -- The user does not have query privileges on this project
2989: -- Hence, cannot update the project.Raise error
2990:
2991: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
2992: FND_MSG_PUB.add;
2993: p_return_status := FND_API.G_RET_STS_ERROR;
2994: RAISE FND_API.G_EXC_ERROR;
2995: ELSE
2996: -- If the user has query privileges, then check whether

Line 3005: FND_MSG_PUB.add;

3001: -- The user does not have update privileges on this project
3002: -- Hence , raise error
3003:
3004: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3005: FND_MSG_PUB.add;
3006: p_return_status := FND_API.G_RET_STS_ERROR;
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009: END IF;

Line 3012: FND_MSG_PUB.Count_And_Get

3008: END IF;
3009: END IF;
3010:
3011: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
3012: FND_MSG_PUB.Count_And_Get
3013: ( p_count => p_msg_count
3014: ,p_data => p_msg_data
3015: );
3016: END IF;

Line 3020: FND_MSG_PUB.Count_And_Get

3016: END IF;
3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN
3019: p_return_status := FND_API.G_RET_STS_ERROR;
3020: FND_MSG_PUB.Count_And_Get
3021: ( p_count => p_msg_count
3022: ,p_data => p_msg_data
3023: );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3026: FND_MSG_PUB.Count_And_Get

3022: ,p_data => p_msg_data
3023: );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026: FND_MSG_PUB.Count_And_Get
3027: ( p_count => p_msg_count
3028: ,p_data => p_msg_data
3029: );
3030: WHEN OTHERS THEN

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

3028: ,p_data => p_msg_data
3029: );
3030: WHEN OTHERS THEN
3031: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3032: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3033: FND_MSG_PUB.Add_Exc_Msg
3034: ( G_PKG_NAME
3035: , l_api_name
3036: );

Line 3033: FND_MSG_PUB.Add_Exc_Msg

3029: );
3030: WHEN OTHERS THEN
3031: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3032: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3033: FND_MSG_PUB.Add_Exc_Msg
3034: ( G_PKG_NAME
3035: , l_api_name
3036: );
3037: END IF;

Line 3038: FND_MSG_PUB.Count_And_Get

3034: ( G_PKG_NAME
3035: , l_api_name
3036: );
3037: END IF;
3038: FND_MSG_PUB.Count_And_Get
3039: ( p_count => p_msg_count
3040: ,p_data => p_msg_data
3041: );
3042:

Line 3073: FND_MSG_PUB.initialize;

3069: l_api_name VARCHAR2(30) := 'update_task_progress_amg';
3070: begin
3071: IF FND_API.to_boolean(p_init_msg_list)
3072: THEN
3073: FND_MSG_PUB.initialize;
3074: END IF;
3075:
3076: x_return_status := FND_API.G_RET_STS_SUCCESS;
3077:

Line 3184: fnd_msg_pub.count_and_get

3180: ,x_msg_count => x_msg_count
3181: ,x_msg_data => x_msg_data);
3182:
3183: if (x_return_status <> fnd_api.g_ret_sts_success ) then
3184: fnd_msg_pub.count_and_get
3185: (p_count => x_msg_count
3186: ,p_data => x_msg_data);
3187: end if;
3188:

Line 3193: fnd_msg_pub.count_and_get

3189: exception
3190:
3191: when fnd_api.g_exc_error then
3192: x_return_status := fnd_api.g_ret_sts_error;
3193: fnd_msg_pub.count_and_get
3194: (p_count => x_msg_count
3195: ,p_data => x_msg_data);
3196: when fnd_api.g_exc_unexpected_error then
3197: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3198: fnd_msg_pub.count_and_get

3194: (p_count => x_msg_count
3195: ,p_data => x_msg_data);
3196: when fnd_api.g_exc_unexpected_error then
3197: x_return_status := fnd_api.g_ret_sts_unexp_error;
3198: fnd_msg_pub.count_and_get
3199: (p_count => x_msg_count
3200: ,p_data => x_msg_data);
3201: when others then
3202: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3199: (p_count => x_msg_count
3200: ,p_data => x_msg_data);
3201: when others then
3202: x_return_status := fnd_api.g_ret_sts_unexp_error;
3203: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3204: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3205: end if;
3206: fnd_msg_pub.count_and_get
3207: (p_count => x_msg_count

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

3200: ,p_data => x_msg_data);
3201: when others then
3202: x_return_status := fnd_api.g_ret_sts_unexp_error;
3203: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3204: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3205: end if;
3206: fnd_msg_pub.count_and_get
3207: (p_count => x_msg_count
3208: ,p_data => x_msg_data);

Line 3206: fnd_msg_pub.count_and_get

3202: x_return_status := fnd_api.g_ret_sts_unexp_error;
3203: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3204: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3205: end if;
3206: fnd_msg_pub.count_and_get
3207: (p_count => x_msg_count
3208: ,p_data => x_msg_data);
3209:
3210: end update_task_progress_amg;