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.PJI_REP_UTIL dependencies on FND_API

Line 171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

167: END IF;
168:
169: IF x_return_status IS NULL THEN
170: x_msg_count := 0;
171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
172: END IF;
173:
174:
175: SELECT COUNT(*)

Line 583: x_return_status := Fnd_Api.G_RET_STS_ERROR;

579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: x_msg_count := x_msg_count + 1;
583: x_return_status := Fnd_Api.G_RET_STS_ERROR;
584: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Populate_WBS_Hierarchy_Cache');
585: RAISE;
586: END;
587:

Line 607: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

603: END IF;
604:
605: IF x_return_status IS NULL THEN
606: x_msg_count := 0;
607: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
608: END IF;
609:
610: BEGIN
611: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

Line 667: x_return_status := Fnd_Api.G_RET_STS_ERROR;

663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: x_msg_count := x_msg_count + 1;
667: x_return_status := Fnd_Api.G_RET_STS_ERROR;
668: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');
669: RAISE;
670: END Populate_WP_Plan_Vers_Cache;
671:

Line 690: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

686: END IF;
687:
688: IF x_return_status IS NULL THEN
689: x_msg_count := 0;
690: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
691: END IF;
692:
693:
694:

Line 741: x_return_status := Fnd_Api.G_RET_STS_ERROR;

737:
738: EXCEPTION
739: WHEN OTHERS THEN
740: x_msg_count := x_msg_count + 1;
741: x_return_status := Fnd_Api.G_RET_STS_ERROR;
742: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');
743: RAISE;
744: END Derive_Default_Calendar_Info;
745:

Line 787: x_return_status := Fnd_Api.G_RET_STS_ERROR;

783:
784: EXCEPTION
785: WHEN NO_DATA_FOUND THEN
786: x_msg_count := x_msg_count + 1;
787: x_return_status := Fnd_Api.G_RET_STS_ERROR;
788: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WP CALENDAR');
789: WHEN OTHERS THEN
790: x_msg_count := x_msg_count + 1;
791: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 791: x_return_status := Fnd_Api.G_RET_STS_ERROR;

787: x_return_status := Fnd_Api.G_RET_STS_ERROR;
788: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WP CALENDAR');
789: WHEN OTHERS THEN
790: x_msg_count := x_msg_count + 1;
791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
792: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Calendar_Info');
793: RAISE;
794: END Derive_WP_Calendar_Info;
795:

Line 822: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

818: END IF;
819:
820: IF x_return_status IS NULL THEN
821: x_msg_count := 0;
822: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
823: END IF;
824:
825: IF p_cst_version_id IS NOT NULL AND p_cst_version_id <> -99 THEN
826: IF p_cst_version_id = p_rev_version_id THEN

Line 936: x_return_status := Fnd_Api.G_RET_STS_ERROR;

932: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
933: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
934: WHEN OTHERS THEN
935: x_msg_count := x_msg_count + 1;
936: x_return_status := Fnd_Api.G_RET_STS_ERROR;
937: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Vp_Calendar_Info');
938: RAISE;
939: END Derive_Vp_Calendar_Info;
940:

Line 1018: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1014:
1015:
1016: IF x_return_status IS NULL THEN
1017: x_msg_count := 0;
1018: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1019: END IF;
1020:
1021: -- IF g_project_id <> p_project_id THEN
1022: /*

Line 1227: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1223:
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: x_msg_count := x_msg_count + 1;
1227: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1228: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Plan_Versions');
1229: RAISE;
1230: END Derive_Default_Plan_Versions;
1231:

Line 1253: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1249: END IF;
1250:
1251: IF x_return_status IS NULL THEN
1252: x_msg_count := 0;
1253: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1254: END IF;
1255:
1256: -- IF g_project_id <> p_project_id THEN
1257: /*

Line 1277: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: x_msg_count := x_msg_count + 1;
1277: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1278: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');
1279: RAISE;
1280: END Derive_Default_Currency_Info;
1281:

Line 1301: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1297: END IF;
1298:
1299: IF x_return_status IS NULL THEN
1300: x_msg_count := 0;
1301: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1302: END IF;
1303:
1304: /*--bug 5593229
1305: x_currency_record_type:=1;

Line 1335: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: x_msg_count := x_msg_count + 1;
1335: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1336: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');
1337: RAISE;
1338: END Derive_Perf_Currency_Info;
1339:

Line 1355: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1351: END IF;
1352:
1353: IF x_return_status IS NULL THEN
1354: x_msg_count := 0;
1355: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1356: END IF;
1357:
1358: IF p_fin_plan_version_id IS NOT NULL THEN
1359: /*

Line 1390: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1386: WHEN NO_DATA_FOUND THEN
1387: RETURN '1';
1388: WHEN OTHERS THEN
1389: x_msg_count := x_msg_count + 1;
1390: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1391: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_FactorBy');
1392: RETURN '1';
1393: END Derive_FactorBy;
1394:

Line 1446: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1442: END IF;
1443:
1444: IF x_return_status IS NULL THEN
1445: x_msg_count := 0;
1446: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1447: END IF;
1448:
1449: -- IF p_project_id <> g_project_id THEN
1450: /*

Line 1493: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1489: -- END IF;
1490: EXCEPTION
1491: WHEN NO_DATA_FOUND THEN
1492: x_msg_count := x_msg_count + 1;
1493: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1494: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PROJ ATTRIBUTES');
1495: WHEN OTHERS THEN
1496: x_msg_count := x_msg_count + 1;
1497: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1497: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1493: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1494: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PROJ ATTRIBUTES');
1495: WHEN OTHERS THEN
1496: x_msg_count := x_msg_count + 1;
1497: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1498: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Attributes');
1499: RAISE;
1500: END Derive_Project_Attributes;
1501:

Line 1523: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1519:
1520:
1521: IF x_return_status IS NULL THEN
1522: x_msg_count := 0;
1523: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1524: END IF;
1525:
1526: SELECT rbs_version_id
1527: INTO x_rbs_version_id

Line 1556: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1552: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1554: */ WHEN OTHERS THEN
1555: x_msg_count := x_msg_count + 1;
1556: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1557: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Parameters');
1558: RAISE;
1559: END Derive_Default_RBS_Parameters;
1560:

Line 1592: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1588: END IF;
1589:
1590: IF x_return_status IS NULL THEN
1591: x_msg_count := 0;
1592: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1593: END IF;
1594:
1595:
1596: OPEN c_rbs_versions;

Line 1630: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1626: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1627: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1628: */ WHEN OTHERS THEN
1629: x_msg_count := x_msg_count + 1;
1630: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1631: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_RBS_Parameters');
1632: RAISE;
1633: END Derive_Perf_RBS_Parameters;
1634:

Line 1660: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1656: END IF;
1657:
1658: IF x_return_status IS NULL THEN
1659: x_msg_count := 0;
1660: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1661: END IF;
1662:
1663: OPEN c_rbs_elements;
1664: FETCH c_rbs_elements INTO x_rbs_element_id;

Line 1683: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1679: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1680: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');
1681: WHEN OTHERS THEN
1682: x_msg_count := x_msg_count + 1;
1683: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1684: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Element_Id');
1685: RAISE;
1686: END Derive_Default_RBS_Element_Id;
1687:

Line 1705: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1701: END IF;
1702:
1703: IF x_return_status IS NULL THEN
1704: x_msg_count := 0;
1705: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1706: END IF;
1707:
1708: BEGIN
1709: SELECT hdr.wbs_version_id

Line 1750: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1746:
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: x_msg_count := x_msg_count + 1;
1750: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1751: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_WBS_Parameters');
1752: RAISE;
1753: END Derive_Default_WBS_Parameters;
1754:

Line 1778: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1774: END IF;
1775:
1776: IF x_return_status IS NULL THEN
1777: x_msg_count := 0;
1778: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1779: END IF;
1780:
1781: OPEN c_wbs_params;
1782: FETCH c_wbs_params INTO x_wbs_version_id,x_wbs_element_id;

Line 1797: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: x_msg_count := x_msg_count + 1;
1797: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1798: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_WBS_Parameters');
1799: RAISE;
1800: END Derive_WP_WBS_Parameters;
1801:

Line 1833: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1829: END IF;
1830:
1831: IF x_return_status IS NULL THEN
1832: x_msg_count := 0;
1833: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1834: END IF;
1835:
1836: SELECT start_date,NVL(completion_date,TRUNC(SYSDATE))
1837: INTO l_start_date, l_end_date

Line 1930: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1926:
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: x_msg_count := x_msg_count + 1;
1930: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1931: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'SLICE NAME');
1932: WHEN OTHERS THEN
1933: x_msg_count := x_msg_count + 1;
1934: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1934: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1930: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1931: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'SLICE NAME');
1932: WHEN OTHERS THEN
1933: x_msg_count := x_msg_count + 1;
1934: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1935: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Slice_Name');
1936: RAISE;
1937: END Derive_Slice_Name;
1938:

Line 1958: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1954: BEGIN
1955:
1956: IF x_return_status IS NULL THEN
1957: x_msg_count := 0;
1958: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1959: END IF;
1960:
1961: IF g_debug_mode = 'Y' THEN
1962: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: begining', TRUE , g_proc);

Line 2003: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1999:
2000: EXCEPTION
2001: WHEN NO_DATA_FOUND THEN
2002: x_msg_count := x_msg_count + 1;
2003: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2004: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN TYPE PARAMETERS');
2005: WHEN OTHERS THEN
2006: x_msg_count := x_msg_count + 1;
2007: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2007: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2003: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2004: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN TYPE PARAMETERS');
2005: WHEN OTHERS THEN
2006: x_msg_count := x_msg_count + 1;
2007: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2008: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Plan_Type_Parameters');
2009: RAISE;
2010: END Derive_Plan_Type_Parameters;
2011:

Line 2025: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2021: BEGIN
2022:
2023: IF x_return_status IS NULL THEN
2024: x_msg_count := 0;
2025: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2026: END IF;
2027:
2028: IF g_debug_mode = 'Y' THEN
2029: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: begining', TRUE , g_proc);

Line 2045: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2041: END IF;
2042: EXCEPTION
2043: WHEN NO_DATA_FOUND THEN
2044: x_msg_count := x_msg_count + 1;
2045: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2046: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN VERSION MARGIN MASK');
2047: x_plan_margin_mask := 'B';
2048: WHEN OTHERS THEN
2049: x_msg_count := x_msg_count + 1;

Line 2050: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2046: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN VERSION MARGIN MASK');
2047: x_plan_margin_mask := 'B';
2048: WHEN OTHERS THEN
2049: x_msg_count := x_msg_count + 1;
2050: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2051: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Margin_Mask');
2052: RAISE;
2053: END Derive_Version_Margin_Mask;
2054:

Line 2073: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2069: END IF;
2070:
2071: IF x_return_status IS NULL THEN
2072: x_msg_count := 0;
2073: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2074: END IF;
2075:
2076: SELECT version_number, version_name, record_version_number,budget_status_code
2077: INTO x_version_no, x_version_name, x_version_record_no , x_budget_status_code

Line 2088: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2084:
2085: EXCEPTION
2086: WHEN NO_DATA_FOUND THEN
2087: x_msg_count := x_msg_count + 1;
2088: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2089: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NO_PLAN_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
2090: WHEN OTHERS THEN
2091: x_msg_count := x_msg_count + 1;
2092: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2092: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2088: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2089: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NO_PLAN_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
2090: WHEN OTHERS THEN
2091: x_msg_count := x_msg_count + 1;
2092: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2093: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Parameters');
2094: RAISE;
2095: END Derive_Version_Parameters;
2096:

Line 2119: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2115: END IF;
2116:
2117: IF x_return_status IS NULL THEN
2118: x_msg_count := 0;
2119: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2120: END IF;
2121:
2122: Pa_Planning_Element_Utils.get_finplan_bvids(
2123: p_project_id => p_project_id

Line 2162: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: x_msg_count := x_msg_count + 1;
2162: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2163: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Fin_Plan_Versions');
2164: RAISE;
2165: END Derive_Fin_Plan_Versions;
2166:

Line 2189: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2185: END IF;
2186:
2187: IF x_return_status IS NULL THEN
2188: x_msg_count := 0;
2189: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2190: END IF;
2191:
2192: Pa_Planning_Element_Utils.get_workplan_bvids
2193: (p_project_id

Line 2228: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: x_msg_count := x_msg_count + 1;
2228: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2229: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Work_Plan_Versions');
2230: RAISE;
2231: END Derive_Work_Plan_Versions;
2232:

Line 2386: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2382: END IF;
2383:
2384: IF l_active_rep IS NULL THEN
2385: x_msg_count := x_msg_count + 1;
2386: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2387: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2388: x_report_date_julian :=2;
2389: RETURN;
2390: END IF;

Line 2410: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2406:
2407: EXCEPTION
2408: WHEN NO_DATA_FOUND THEN
2409: x_msg_count := x_msg_count + 1;
2410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2411: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2412: x_report_date_julian :=2;
2413: RETURN;
2414: END;

Line 2426: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2422: END IF;
2423:
2424: IF l_specific_period IS NULL THEN
2425: x_msg_count := x_msg_count + 1;
2426: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2427: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2428: x_report_date_julian :=2;
2429: RETURN;
2430: END IF;

Line 2554: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2550:
2551: EXCEPTION
2552: WHEN NO_DATA_FOUND THEN
2553: x_msg_count := x_msg_count + 1;
2554: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2555: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
2556: x_report_date_julian :=2;
2557: WHEN OTHERS THEN
2558: x_msg_count := x_msg_count + 1;

Line 2559: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2555: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
2556: x_report_date_julian :=2;
2557: WHEN OTHERS THEN
2558: x_msg_count := x_msg_count + 1;
2559: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2560: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Julian');
2561: RAISE;
2562: END Derive_Pa_Calendar_Info;
2563:

Line 2756: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2752: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: begining', TRUE , g_proc);
2753: END IF;
2754:
2755: x_msg_count := 0;
2756: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2757:
2758:
2759: /* Get the Approved Budget - Cost and Revenue Plan Type */
2760:

Line 2999: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2995:
2996: EXCEPTION
2997: WHEN OTHERS THEN
2998: x_msg_count := 1;
2999: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3000: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.get_project_home_default_param');
3001: RAISE;
3002:
3003: END get_project_home_default_param;

Line 3034: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3030: END IF;
3031:
3032: IF x_return_status IS NULL THEN
3033: x_msg_count := 0;
3034: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3035: END IF;
3036:
3037: OPEN c_dates;
3038: FETCH c_dates INTO x_from_period,x_to_period;

Line 3057: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3053: x_from_period := NULL;
3054: x_to_period := NULL;
3055: WHEN OTHERS THEN
3056: x_msg_count := x_msg_count + 1;
3057: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3058: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Period');
3059: RAISE;
3060: END Derive_WP_Period;
3061:

Line 3079: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3075: END IF;
3076:
3077: IF x_return_status IS NULL THEN
3078: x_msg_count := 0;
3079: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3080: END IF;
3081:
3082: Get_Default_Period_Dates (
3083: p_plan_version_id_tbl

Line 3100: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3096: x_from_period := NULL;
3097: x_to_period := NULL;
3098: WHEN OTHERS THEN
3099: x_msg_count := x_msg_count + 1;
3100: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3101: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_VP_Period');
3102: RAISE;
3103: END Derive_VP_Period;
3104:

Line 3122: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3118: END IF;
3119:
3120: IF x_return_status IS NULL THEN
3121: x_msg_count := 0;
3122: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3123: END IF;
3124:
3125: Get_Default_Period_Dates (
3126: p_plan_version_id_tbl

Line 3142: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3138: x_from_period := NULL;
3139: x_to_period := NULL;
3140: WHEN OTHERS THEN
3141: x_msg_count := x_msg_count + 1;
3142: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3143: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_Period');
3144: RAISE;
3145: END Derive_Perf_Period;
3146:

Line 3299: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3295: END IF;
3296:
3297: IF x_return_status IS NULL THEN
3298: x_msg_count := 0;
3299: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3300: END IF;
3301:
3302: SELECT DISTINCT UPPER(t.project_type_class_code)
3303: INTO x_project_type

Line 3322: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3318: WHEN NO_DATA_FOUND THEN
3319: x_project_type := 'CONTRACT';
3320: WHEN OTHERS THEN
3321: x_msg_count := x_msg_count + 1;
3322: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3323: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Type');
3324: RAISE;
3325: END Derive_Project_Type;
3326:

Line 3353: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3349: END IF;
3350:
3351: IF x_return_status IS NULL THEN
3352: x_msg_count := 0;
3353: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3354: END IF;
3355:
3356: BEGIN
3357: SELECT object_type

Line 3400: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3396: WHEN NO_DATA_FOUND THEN
3397: x_percent_complete := NULL;
3398: WHEN OTHERS THEN
3399: x_msg_count := x_msg_count + 1;
3400: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3401: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');
3402: RAISE;
3403: END Derive_Percent_Complete;
3404:

Line 3424: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3420: END IF;
3421:
3422: IF x_return_status IS NULL THEN
3423: x_msg_count := 0;
3424: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3425: END IF;
3426:
3427: SELECT
3428: NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)

Line 3452: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3448: WHEN NO_DATA_FOUND THEN
3449: x_cross_org_flag := 'F';
3450: WHEN OTHERS THEN
3451: x_msg_count := x_msg_count + 1;
3452: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3453: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Cross_Org');
3454: RAISE;
3455: END Check_Cross_Org;
3456:

Line 3494: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3490: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_PARAM_CONSISTENCY';
3491:
3492: BEGIN
3493: x_msg_count := 0;
3494: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3496:
3497: IF l_debug_mode = 'Y' THEN
3498: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',

Line 3512: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3508: ,x_return_status => x_return_status
3509: ,x_msg_count => x_msg_count
3510: ,x_msg_data => x_msg_data );
3511:
3512: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3513: RETURN;
3514: END IF;
3515:
3516: --Call the margin check API

Line 3526: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3522: ,x_return_status => x_return_status
3523: ,x_msg_count => x_msg_count
3524: ,x_msg_data => x_msg_data );
3525:
3526: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3527: RETURN;
3528: END IF;
3529:
3530: --Call the status check API

Line 3540: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3536: ,x_return_status => x_return_status
3537: ,x_msg_count => x_msg_count
3538: ,x_msg_data => x_msg_data );
3539:
3540: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3541: RETURN;
3542: END IF;
3543:
3544: --Call the time phase check API only if the published flag is Y

Line 3556: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3552: ,x_return_status => x_return_status
3553: ,x_msg_count => x_msg_count
3554: ,x_msg_data => x_msg_data );
3555:
3556: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3557: RETURN;
3558: END IF;
3559: END IF;
3560:

Line 3571: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3567: ,x_return_status => x_return_status
3568: ,x_msg_count => x_msg_count
3569: ,x_msg_data => x_msg_data );
3570:
3571: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3572: RETURN;
3573: END IF;
3574:
3575: IF l_debug_mode = 'Y' THEN

Line 3583: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3579: END IF;
3580: EXCEPTION
3581: WHEN OTHERS THEN
3582:
3583: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3584: x_msg_count := 1;
3585: x_msg_data := SQLERRM;
3586:
3587: Fnd_Msg_Pub.add_exc_msg

Line 3671: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3667: l_dummy NUMBER;
3668:
3669: BEGIN
3670: x_msg_count := 0;
3671: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3673:
3674: IF l_debug_mode = 'Y' THEN
3675: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',

Line 3713: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3709: EXCEPTION
3710:
3711: WHEN OTHERS THEN
3712:
3713: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3714: x_msg_count := 1;
3715: x_msg_data := SQLERRM;
3716:
3717: Fnd_Msg_Pub.add_exc_msg

Line 3779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3775: l_dummy NUMBER;
3776:
3777: BEGIN
3778: x_msg_count := 0;
3779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3781:
3782: IF l_debug_mode = 'Y' THEN
3783: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',

Line 3808: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3804: EXCEPTION
3805:
3806: WHEN OTHERS THEN
3807:
3808: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3809: x_msg_count := 1;
3810: x_msg_data := SQLERRM;
3811:
3812: Fnd_Msg_Pub.add_exc_msg

Line 3872: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3868: l_dummy NUMBER;
3869:
3870: BEGIN
3871: x_msg_count := 0;
3872: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3874:
3875: IF l_debug_mode = 'Y' THEN
3876: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',

Line 3902: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3898: EXCEPTION
3899:
3900: WHEN OTHERS THEN
3901:
3902: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3903: x_msg_count := 1;
3904: x_msg_data := SQLERRM;
3905:
3906: Fnd_Msg_Pub.add_exc_msg

Line 3968: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3964: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE;
3965:
3966: BEGIN
3967: x_msg_count := 0;
3968: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3970:
3971: IF l_debug_mode = 'Y' THEN
3972: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',

Line 3991: IF x_return_status = Fnd_Api.G_RET_STS_SUCCESS THEN

3987: ,x_return_status => x_return_status
3988: ,x_msg_count => x_msg_count
3989: ,x_msg_data => x_msg_data);
3990:
3991: IF x_return_status = Fnd_Api.G_RET_STS_SUCCESS THEN
3992: IF NVL(l_calendar_id,-99) <> NVL(p_calendar_id,-99) AND l_calendar_type <> p_calendar_type THEN
3993: x_time_phase_flag := 'N';
3994: EXIT;
3995: END IF;

Line 4010: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4006: EXCEPTION
4007:
4008: WHEN OTHERS THEN
4009:
4010: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4011: x_msg_count := 1;
4012: x_msg_data := SQLERRM;
4013:
4014: Fnd_Msg_Pub.add_exc_msg

Line 4077: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4073: l_dummy NUMBER;
4074:
4075: BEGIN
4076: x_msg_count := 0;
4077: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4079:
4080: IF l_debug_mode = 'Y' THEN
4081: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',

Line 4106: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4102: EXCEPTION
4103:
4104: WHEN OTHERS THEN
4105:
4106: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4107: x_msg_count := 1;
4108: x_msg_data := SQLERRM;
4109:
4110: Fnd_Msg_Pub.add_exc_msg

Line 4242: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4238:
4239:
4240: IF x_return_status IS NULL THEN
4241: x_msg_count := 0;
4242: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4243: END IF;
4244:
4245: IF p_project_id IS NOT NULL THEN
4246:

Line 4351: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4347:
4348:
4349: IF x_return_status IS NULL THEN
4350: x_msg_count := 0;
4351: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4352: END IF;
4353:
4354: IF p_project_id IS NOT NULL THEN
4355: /*

Line 4696: x_return_status := Fnd_Api.G_RET_STS_ERROR;

4692:
4693: EXCEPTION
4694: WHEN OTHERS THEN
4695: x_msg_count := x_msg_count + 1;
4696: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4697: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Plan_Versions_Id');
4698: RAISE;
4699: END Derive_Plan_Version_Ids;
4700:

Line 4727: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4723: l_module_name VARCHAR2(100) := 'pa.plsql.Check_Perf_Cal_Consistency';
4724:
4725: BEGIN
4726: x_msg_count := 0;
4727: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4729:
4730: IF l_debug_mode = 'Y' THEN
4731: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',

Line 4780: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4776: Pa_Debug.reset_curr_function;
4777: END IF;
4778: EXCEPTION
4779: WHEN OTHERS THEN
4780: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4781: x_msg_count := 1;
4782: x_msg_data := SQLERRM;
4783:
4784: Fnd_Msg_Pub.add_exc_msg

Line 4821: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4817: l_num_of_projfunc_curr NUMBER;
4818:
4819: BEGIN
4820: x_msg_count := 0;
4821: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4823:
4824: IF l_debug_mode = 'Y' THEN
4825: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',

Line 4863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4859: Pa_Debug.reset_curr_function;
4860: END IF;
4861: EXCEPTION
4862: WHEN OTHERS THEN
4863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4864: x_msg_count := 1;
4865: x_msg_data := SQLERRM;
4866:
4867: Fnd_Msg_Pub.add_exc_msg

Line 4956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4952: l_project_id NUMBER := 1;
4953: BEGIN
4954: l_IsSmartSliceCreated_Flag := 'Y';
4955:
4956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4957: IF g_debug_mode = 'Y' THEN
4958: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: begining', TRUE , g_proc);
4959: END IF;
4960:

Line 5165: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5161: AND rst.project_id = l_project_id_tbl(i));
5162: EXCEPTION
5163: WHEN NO_DATA_FOUND THEN
5164: x_Smart_Slice_Flag := 'Y';
5165: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5166: IF ( g_debug_mode = 'Y' ) THEN
5167: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found ', TRUE , g_proc);
5168: END IF;
5169: END;

Line 5188: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5184:
5185: /* Important: If the process is Deferred for getting the data, then a new status will be passed i.e. 'D' */
5186:
5187: x_Smart_Slice_Flag := l_IsSmartSliceCreated_Flag;
5188: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5189: EXCEPTION
5190: WHEN OTHERS THEN
5191: x_msg_count := 1;
5192: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 5192: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5188: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5189: EXCEPTION
5190: WHEN OTHERS THEN
5191: x_msg_count := 1;
5192: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5193: IF g_debug_mode = 'Y' THEN
5194: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: When others ', TRUE , g_proc);
5195: END IF;
5196: NULL;

Line 5226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5222: l_R_PlanVers_HavSame_RBS_Flag VARCHAR2(1) := 'Y';
5223: BEGIN
5224: l_R_PlanVers_HavSame_RBS_Flag := 'Y';
5225:
5226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5227: IF g_debug_mode = 'Y' THEN
5228: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: begining', TRUE , g_proc);
5229: END IF;
5230:

Line 5278: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5274: END IF;
5275:
5276: IF ( l_R_PlanVers_HavSame_RBS_Flag = 'Y') THEN
5277: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5278: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5279: ELSE
5280: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5281: x_msg_count := NVL(x_msg_count,0) + 1;
5282: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 5282: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5278: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5279: ELSE
5280: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5281: x_msg_count := NVL(x_msg_count,0) + 1;
5282: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5283: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NOT_SAME_RBS', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
5284: END IF;
5285:
5286:

Line 5291: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5287: EXCEPTION
5288: WHEN NO_DATA_FOUND THEN
5289: x_R_PlanVers_HavSame_RBS_Flag := 'N';
5290: x_msg_count := NVL(x_msg_count,0) + 1;
5291: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5292: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NOT_SAME_RBS', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
5293: IF g_debug_mode = 'Y' THEN
5294: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: No data found ', TRUE , g_proc);
5295: END IF;

Line 5301: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5297: END IF;
5298: EXCEPTION
5299: WHEN OTHERS THEN
5300: x_msg_count := 1;
5301: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5302: IF g_debug_mode = 'Y' THEN
5303: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: When others ', TRUE , g_proc);
5304: END IF;
5305: NULL;

Line 5345: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5341: END IF;
5342:
5343: IF x_return_status IS NULL THEN
5344: x_msg_count := 0;
5345: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5346: END IF;
5347:
5348: IF p_prg_flag = 'N' THEN
5349: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(

Line 5394: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5390:
5391: EXCEPTION
5392: WHEN OTHERS THEN
5393: x_msg_count := x_msg_count + 1;
5394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5395: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');
5396: RAISE;
5397: END Get_Process_Status_Msg;
5398:

Line 5418: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5414: END IF;
5415:
5416: IF x_return_status IS NULL THEN
5417: x_msg_count := 0;
5418: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5419: END IF;
5420:
5421: IF p_structure_type = 'WORKPLAN' THEN
5422: l_relationship_type := 'LW';

Line 5456: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5452:
5453: EXCEPTION
5454: WHEN OTHERS THEN
5455: x_msg_count := x_msg_count + 1;
5456: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5457: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Proj_Type_Consistency');
5458: RAISE;
5459: END Check_Proj_Type_Consistency;
5460:

Line 5488: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5484: END IF;
5485:
5486: IF x_return_status IS NULL THEN
5487: x_msg_count := 0;
5488: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5489: END IF;
5490:
5491: SELECT info.gl_calendar_id, info.pa_calendar_id
5492: INTO l_gl_calendar_id, l_pa_calendar_id

Line 5552: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5548:
5549: EXCEPTION
5550: WHEN NO_DATA_FOUND THEN
5551: x_msg_count := x_msg_count + 1;
5552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');
5554: x_report_date_julian :=2;
5555: WHEN OTHERS THEN
5556: x_msg_count := x_msg_count + 1;

Line 5557: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');
5554: x_report_date_julian :=2;
5555: WHEN OTHERS THEN
5556: x_msg_count := x_msg_count + 1;
5557: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5558: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');
5559: x_report_date_julian :=2;
5560: RAISE;
5561: END Derive_Pji_Calendar_Info;

Line 5583: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5579: END IF;
5580:
5581: IF x_return_status IS NULL THEN
5582: x_msg_count := 0;
5583: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5584: END IF;
5585:
5586: x_currency_record_type := p_currency_record_type;
5587:

Line 5616: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5612:
5613: EXCEPTION
5614: WHEN OTHERS THEN
5615: x_msg_count := x_msg_count + 1;
5616: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5617: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Currency_Info');
5618: RAISE;
5619: END Derive_Pji_Currency_Info;
5620:

Line 5638: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5634: END IF;
5635:
5636: IF x_return_status IS NULL THEN
5637: x_msg_count := 0;
5638: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5639: END IF;
5640:
5641: SELECT COUNT(*)
5642: INTO l_plan_type_count

Line 5660: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5656:
5657: EXCEPTION
5658: WHEN OTHERS THEN
5659: x_msg_count := x_msg_count + 1;
5660: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5661: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Validate_Plan_Type');
5662: RAISE;
5663: END Validate_Plan_Type;
5664: