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 336: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

332: END IF;
333:
334: IF x_return_status IS NULL THEN
335: x_msg_count := 0;
336: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
337: END IF;
338:
339: -- OLAP START
340: if ( p_element_version_id is not null ) then -- Bug 16507592

Line 362: x_return_status := Fnd_Api.G_RET_STS_ERROR;

358: and ppst.structure_type_id = pst.structure_type_id
359: and s.current_flag = 'Y'
360: and pst.structure_type_class_code = 'FINANCIAL';*/
361:
362: x_return_status := Fnd_Api.G_RET_STS_ERROR;
363: IF g_debug_mode = 'Y' THEN
364: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: p_element_version_id cannot be null', TRUE , g_proc);
365:
366: END IF;

Line 872: x_return_status := Fnd_Api.G_RET_STS_ERROR;

868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: x_msg_count := x_msg_count + 1;
872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
873: 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');
874: RAISE;
875: END;
876:

Line 900: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

896: END IF;
897:
898: IF x_return_status IS NULL THEN
899: x_msg_count := 0;
900: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
901: END IF;
902:
903: BEGIN
904: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

Line 982: x_return_status := Fnd_Api.G_RET_STS_ERROR;

978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: x_msg_count := x_msg_count + 1;
982: x_return_status := Fnd_Api.G_RET_STS_ERROR;
983: 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');
984: RAISE;
985: END Populate_WP_Plan_Vers_Cache;
986:

Line 1007: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1003: END IF;
1004:
1005: IF x_return_status IS NULL THEN
1006: x_msg_count := 0;
1007: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1008: END IF;
1009:
1010:
1011:

Line 1077: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1073:
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: x_msg_count := x_msg_count + 1;
1077: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1078: 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');
1079: RAISE;
1080: END Derive_Default_Calendar_Info;
1081:

Line 1123: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1119:
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: x_msg_count := x_msg_count + 1;
1123: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1124: 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');
1125: WHEN OTHERS THEN
1126: x_msg_count := x_msg_count + 1;
1127: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1127: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1123: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1124: 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');
1125: WHEN OTHERS THEN
1126: x_msg_count := x_msg_count + 1;
1127: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1128: 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');
1129: RAISE;
1130: END Derive_WP_Calendar_Info;
1131:

Line 1158: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1154: END IF;
1155:
1156: IF x_return_status IS NULL THEN
1157: x_msg_count := 0;
1158: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1159: END IF;
1160:
1161: IF p_cst_version_id IS NOT NULL AND p_cst_version_id <> -99 THEN
1162: IF p_cst_version_id = p_rev_version_id THEN

Line 1272: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1268: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
1269: 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');
1270: WHEN OTHERS THEN
1271: x_msg_count := x_msg_count + 1;
1272: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1273: 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');
1274: RAISE;
1275: END Derive_Vp_Calendar_Info;
1276:

Line 1354: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1350:
1351:
1352: IF x_return_status IS NULL THEN
1353: x_msg_count := 0;
1354: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1355: END IF;
1356:
1357: -- IF g_project_id <> p_project_id THEN
1358: /*

Line 1563: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1559:
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: x_msg_count := x_msg_count + 1;
1563: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1564: 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');
1565: RAISE;
1566: END Derive_Default_Plan_Versions;
1567:

Line 1589: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1585: END IF;
1586:
1587: IF x_return_status IS NULL THEN
1588: x_msg_count := 0;
1589: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1590: END IF;
1591:
1592: -- IF g_project_id <> p_project_id THEN
1593: /*

Line 1625: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: x_msg_count := x_msg_count + 1;
1625: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1626: 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');
1627: RAISE;
1628: END Derive_Default_Currency_Info;
1629:

Line 1649: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1645: END IF;
1646:
1647: IF x_return_status IS NULL THEN
1648: x_msg_count := 0;
1649: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1650: END IF;
1651:
1652: /*--bug 5593229
1653: x_currency_record_type:=1;

Line 1695: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1691:
1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: x_msg_count := x_msg_count + 1;
1695: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1696: 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');
1697: RAISE;
1698: END Derive_Perf_Currency_Info;
1699:

Line 1715: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1711: END IF;
1712:
1713: IF x_return_status IS NULL THEN
1714: x_msg_count := 0;
1715: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1716: END IF;
1717:
1718: IF p_fin_plan_version_id IS NOT NULL THEN
1719: /*

Line 1750: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1746: WHEN NO_DATA_FOUND THEN
1747: RETURN '1';
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_FactorBy');
1752: RETURN '1';
1753: END Derive_FactorBy;
1754:

Line 1806: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1802: END IF;
1803:
1804: IF x_return_status IS NULL THEN
1805: x_msg_count := 0;
1806: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1807: END IF;
1808:
1809: -- IF p_project_id <> g_project_id THEN
1810: /*

Line 1853: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1849: -- END IF;
1850: EXCEPTION
1851: WHEN NO_DATA_FOUND THEN
1852: x_msg_count := x_msg_count + 1;
1853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1854: 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');
1855: WHEN OTHERS THEN
1856: x_msg_count := x_msg_count + 1;
1857: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1857: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1854: 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');
1855: WHEN OTHERS THEN
1856: x_msg_count := x_msg_count + 1;
1857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1858: 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');
1859: RAISE;
1860: END Derive_Project_Attributes;
1861:

Line 1883: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1879:
1880:
1881: IF x_return_status IS NULL THEN
1882: x_msg_count := 0;
1883: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1884: END IF;
1885:
1886: SELECT rbs_version_id
1887: INTO x_rbs_version_id

Line 1916: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1912: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1913: 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);
1914: */ WHEN OTHERS THEN
1915: x_msg_count := x_msg_count + 1;
1916: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1917: 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');
1918: RAISE;
1919: END Derive_Default_RBS_Parameters;
1920:

Line 1952: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1948: END IF;
1949:
1950: IF x_return_status IS NULL THEN
1951: x_msg_count := 0;
1952: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1953: END IF;
1954:
1955:
1956: OPEN c_rbs_versions;

Line 1990: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1986: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1987: 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);
1988: */ WHEN OTHERS THEN
1989: x_msg_count := x_msg_count + 1;
1990: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1991: 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');
1992: RAISE;
1993: END Derive_Perf_RBS_Parameters;
1994:

Line 2020: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2016: END IF;
2017:
2018: IF x_return_status IS NULL THEN
2019: x_msg_count := 0;
2020: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2021: END IF;
2022:
2023: OPEN c_rbs_elements;
2024: FETCH c_rbs_elements INTO x_rbs_element_id;

Line 2043: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2039: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
2040: 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');
2041: WHEN OTHERS THEN
2042: x_msg_count := x_msg_count + 1;
2043: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2044: 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');
2045: RAISE;
2046: END Derive_Default_RBS_Element_Id;
2047:

Line 2065: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2061: END IF;
2062:
2063: IF x_return_status IS NULL THEN
2064: x_msg_count := 0;
2065: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2066: END IF;
2067:
2068: BEGIN
2069: /*

Line 2140: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: x_msg_count := x_msg_count + 1;
2140: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2141: 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');
2142: RAISE;
2143: END Derive_Default_WBS_Parameters;
2144:

Line 2168: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2164: END IF;
2165:
2166: IF x_return_status IS NULL THEN
2167: x_msg_count := 0;
2168: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2169: END IF;
2170:
2171: OPEN c_wbs_params;
2172: FETCH c_wbs_params INTO x_wbs_version_id,x_wbs_element_id;

Line 2187: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_msg_count := x_msg_count + 1;
2187: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2188: 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');
2189: RAISE;
2190: END Derive_WP_WBS_Parameters;
2191:

Line 2223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2219: END IF;
2220:
2221: IF x_return_status IS NULL THEN
2222: x_msg_count := 0;
2223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2224: END IF;
2225:
2226: SELECT start_date,NVL(completion_date,TRUNC(SYSDATE))
2227: INTO l_start_date, l_end_date

Line 2320: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2316:
2317: EXCEPTION
2318: WHEN NO_DATA_FOUND THEN
2319: x_msg_count := x_msg_count + 1;
2320: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2321: 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');
2322: WHEN OTHERS THEN
2323: x_msg_count := x_msg_count + 1;
2324: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2324: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2320: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2321: 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');
2322: WHEN OTHERS THEN
2323: x_msg_count := x_msg_count + 1;
2324: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2325: 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');
2326: RAISE;
2327: END Derive_Slice_Name;
2328:

Line 2348: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2344: BEGIN
2345:
2346: IF x_return_status IS NULL THEN
2347: x_msg_count := 0;
2348: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2349: END IF;
2350:
2351: IF g_debug_mode = 'Y' THEN
2352: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: begining', TRUE , g_proc);

Line 2393: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2389:
2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN
2392: x_msg_count := x_msg_count + 1;
2393: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2394: 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');
2395: WHEN OTHERS THEN
2396: x_msg_count := x_msg_count + 1;
2397: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2397: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2393: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2394: 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');
2395: WHEN OTHERS THEN
2396: x_msg_count := x_msg_count + 1;
2397: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2398: 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');
2399: RAISE;
2400: END Derive_Plan_Type_Parameters;
2401:

Line 2415: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2411: BEGIN
2412:
2413: IF x_return_status IS NULL THEN
2414: x_msg_count := 0;
2415: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2416: END IF;
2417:
2418: IF g_debug_mode = 'Y' THEN
2419: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: begining', TRUE , g_proc);

Line 2435: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2431: END IF;
2432: EXCEPTION
2433: WHEN NO_DATA_FOUND THEN
2434: x_msg_count := x_msg_count + 1;
2435: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2436: 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');
2437: x_plan_margin_mask := 'B';
2438: WHEN OTHERS THEN
2439: x_msg_count := x_msg_count + 1;

Line 2440: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2436: 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');
2437: x_plan_margin_mask := 'B';
2438: WHEN OTHERS THEN
2439: x_msg_count := x_msg_count + 1;
2440: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2441: 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');
2442: RAISE;
2443: END Derive_Version_Margin_Mask;
2444:

Line 2463: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2459: END IF;
2460:
2461: IF x_return_status IS NULL THEN
2462: x_msg_count := 0;
2463: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2464: END IF;
2465:
2466: SELECT version_number, version_name, record_version_number,budget_status_code
2467: INTO x_version_no, x_version_name, x_version_record_no , x_budget_status_code

Line 2478: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2474:
2475: EXCEPTION
2476: WHEN NO_DATA_FOUND THEN
2477: x_msg_count := x_msg_count + 1;
2478: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2479: 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);
2480: WHEN OTHERS THEN
2481: x_msg_count := x_msg_count + 1;
2482: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2482: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2478: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2479: 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);
2480: WHEN OTHERS THEN
2481: x_msg_count := x_msg_count + 1;
2482: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2483: 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');
2484: RAISE;
2485: END Derive_Version_Parameters;
2486:

Line 2509: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2505: END IF;
2506:
2507: IF x_return_status IS NULL THEN
2508: x_msg_count := 0;
2509: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2510: END IF;
2511:
2512: Pa_Planning_Element_Utils.get_finplan_bvids(
2513: p_project_id => p_project_id

Line 2552: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2548:
2549: EXCEPTION
2550: WHEN OTHERS THEN
2551: x_msg_count := x_msg_count + 1;
2552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2553: 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');
2554: RAISE;
2555: END Derive_Fin_Plan_Versions;
2556:

Line 2579: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2575: END IF;
2576:
2577: IF x_return_status IS NULL THEN
2578: x_msg_count := 0;
2579: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2580: END IF;
2581:
2582: Pa_Planning_Element_Utils.get_workplan_bvids
2583: (p_project_id

Line 2618: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2614:
2615: EXCEPTION
2616: WHEN OTHERS THEN
2617: x_msg_count := x_msg_count + 1;
2618: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2619: 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');
2620: RAISE;
2621: END Derive_Work_Plan_Versions;
2622:

Line 2787: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2783: END IF;
2784:
2785: IF l_active_rep IS NULL THEN
2786: x_msg_count := x_msg_count + 1;
2787: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2788: 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);
2789: x_report_date_julian :=2;
2790: RETURN;
2791: END IF;

Line 2811: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2807:
2808: EXCEPTION
2809: WHEN NO_DATA_FOUND THEN
2810: x_msg_count := x_msg_count + 1;
2811: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2812: 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);
2813: x_report_date_julian :=2;
2814: RETURN;
2815: END;

Line 2827: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2823: END IF;
2824:
2825: IF l_specific_period IS NULL THEN
2826: x_msg_count := x_msg_count + 1;
2827: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2828: 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);
2829: x_report_date_julian :=2;
2830: RETURN;
2831: END IF;

Line 2998: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2994:
2995: EXCEPTION
2996: WHEN NO_DATA_FOUND THEN
2997: x_msg_count := x_msg_count + 1;
2998: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2999: 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');
3000: x_report_date_julian :=2;
3001: WHEN OTHERS THEN
3002: x_msg_count := x_msg_count + 1;

Line 3003: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2999: 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');
3000: x_report_date_julian :=2;
3001: WHEN OTHERS THEN
3002: x_msg_count := x_msg_count + 1;
3003: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3004: 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');
3005: RAISE;
3006: END Derive_Pa_Calendar_Info;
3007:

Line 3200: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3196: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: begining', TRUE , g_proc);
3197: END IF;
3198:
3199: x_msg_count := 0;
3200: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3201:
3202:
3203: /* Get the Approved Budget - Cost and Revenue Plan Type */
3204:

Line 3443: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3439:
3440: EXCEPTION
3441: WHEN OTHERS THEN
3442: x_msg_count := 1;
3443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3444: 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');
3445: RAISE;
3446:
3447: END get_project_home_default_param;

Line 3478: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3474: END IF;
3475:
3476: IF x_return_status IS NULL THEN
3477: x_msg_count := 0;
3478: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3479: END IF;
3480:
3481: OPEN c_dates;
3482: FETCH c_dates INTO x_from_period,x_to_period;

Line 3501: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3497: x_from_period := NULL;
3498: x_to_period := NULL;
3499: WHEN OTHERS THEN
3500: x_msg_count := x_msg_count + 1;
3501: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3502: 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');
3503: RAISE;
3504: END Derive_WP_Period;
3505:

Line 3523: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3519: END IF;
3520:
3521: IF x_return_status IS NULL THEN
3522: x_msg_count := 0;
3523: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3524: END IF;
3525:
3526: Get_Default_Period_Dates (
3527: p_plan_version_id_tbl

Line 3544: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3540: x_from_period := NULL;
3541: x_to_period := NULL;
3542: WHEN OTHERS THEN
3543: x_msg_count := x_msg_count + 1;
3544: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3545: 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');
3546: RAISE;
3547: END Derive_VP_Period;
3548:

Line 3566: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3562: END IF;
3563:
3564: IF x_return_status IS NULL THEN
3565: x_msg_count := 0;
3566: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3567: END IF;
3568:
3569: Get_Default_Period_Dates (
3570: p_plan_version_id_tbl

Line 3586: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3582: x_from_period := NULL;
3583: x_to_period := NULL;
3584: WHEN OTHERS THEN
3585: x_msg_count := x_msg_count + 1;
3586: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3587: 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');
3588: RAISE;
3589: END Derive_Perf_Period;
3590:

Line 3743: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3739: END IF;
3740:
3741: IF x_return_status IS NULL THEN
3742: x_msg_count := 0;
3743: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3744: END IF;
3745:
3746: SELECT DISTINCT UPPER(t.project_type_class_code)
3747: INTO x_project_type

Line 3766: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3762: WHEN NO_DATA_FOUND THEN
3763: x_project_type := 'CONTRACT';
3764: WHEN OTHERS THEN
3765: x_msg_count := x_msg_count + 1;
3766: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3767: 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');
3768: RAISE;
3769: END Derive_Project_Type;
3770:

Line 3797: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3793: END IF;
3794:
3795: IF x_return_status IS NULL THEN
3796: x_msg_count := 0;
3797: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3798: END IF;
3799:
3800: BEGIN
3801: SELECT object_type

Line 3844: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3840: WHEN NO_DATA_FOUND THEN
3841: x_percent_complete := NULL;
3842: WHEN OTHERS THEN
3843: x_msg_count := x_msg_count + 1;
3844: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3845: 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');
3846: RAISE;
3847: END Derive_Percent_Complete;
3848:

Line 3868: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3864: END IF;
3865:
3866: IF x_return_status IS NULL THEN
3867: x_msg_count := 0;
3868: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3869: END IF;
3870:
3871: SELECT
3872: NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)

Line 3896: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3892: WHEN NO_DATA_FOUND THEN
3893: x_cross_org_flag := 'F';
3894: WHEN OTHERS THEN
3895: x_msg_count := x_msg_count + 1;
3896: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3897: 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');
3898: RAISE;
3899: END Check_Cross_Org;
3900:

Line 3938: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3934: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_PARAM_CONSISTENCY';
3935:
3936: BEGIN
3937: x_msg_count := 0;
3938: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3939: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3940:
3941: IF l_debug_mode = 'Y' THEN
3942: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',

Line 3956: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3952: ,x_return_status => x_return_status
3953: ,x_msg_count => x_msg_count
3954: ,x_msg_data => x_msg_data );
3955:
3956: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3957: RETURN;
3958: END IF;
3959:
3960: --Call the margin check API

Line 3970: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3966: ,x_return_status => x_return_status
3967: ,x_msg_count => x_msg_count
3968: ,x_msg_data => x_msg_data );
3969:
3970: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3971: RETURN;
3972: END IF;
3973:
3974: --Call the status check API

Line 3984: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3980: ,x_return_status => x_return_status
3981: ,x_msg_count => x_msg_count
3982: ,x_msg_data => x_msg_data );
3983:
3984: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3985: RETURN;
3986: END IF;
3987:
3988: --Call the time phase check API only if the published flag is Y

Line 4000: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3996: ,x_return_status => x_return_status
3997: ,x_msg_count => x_msg_count
3998: ,x_msg_data => x_msg_data );
3999:
4000: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4001: RETURN;
4002: END IF;
4003: END IF;
4004:

Line 4015: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4011: ,x_return_status => x_return_status
4012: ,x_msg_count => x_msg_count
4013: ,x_msg_data => x_msg_data );
4014:
4015: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4016: RETURN;
4017: END IF;
4018:
4019: IF l_debug_mode = 'Y' THEN

Line 4027: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4023: END IF;
4024: EXCEPTION
4025: WHEN OTHERS THEN
4026:
4027: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4028: x_msg_count := 1;
4029: x_msg_data := SQLERRM;
4030:
4031: Fnd_Msg_Pub.add_exc_msg

Line 4115: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4111: l_dummy NUMBER;
4112:
4113: BEGIN
4114: x_msg_count := 0;
4115: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4116: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4117:
4118: IF l_debug_mode = 'Y' THEN
4119: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',

Line 4157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4153: EXCEPTION
4154:
4155: WHEN OTHERS THEN
4156:
4157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4158: x_msg_count := 1;
4159: x_msg_data := SQLERRM;
4160:
4161: Fnd_Msg_Pub.add_exc_msg

Line 4223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4219: l_dummy NUMBER;
4220:
4221: BEGIN
4222: x_msg_count := 0;
4223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4224: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4225:
4226: IF l_debug_mode = 'Y' THEN
4227: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',

Line 4252: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4248: EXCEPTION
4249:
4250: WHEN OTHERS THEN
4251:
4252: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4253: x_msg_count := 1;
4254: x_msg_data := SQLERRM;
4255:
4256: Fnd_Msg_Pub.add_exc_msg

Line 4316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4312: l_dummy NUMBER;
4313:
4314: BEGIN
4315: x_msg_count := 0;
4316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4317: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4318:
4319: IF l_debug_mode = 'Y' THEN
4320: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',

Line 4346: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4342: EXCEPTION
4343:
4344: WHEN OTHERS THEN
4345:
4346: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4347: x_msg_count := 1;
4348: x_msg_data := SQLERRM;
4349:
4350: Fnd_Msg_Pub.add_exc_msg

Line 4412: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4408: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE;
4409:
4410: BEGIN
4411: x_msg_count := 0;
4412: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4413: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4414:
4415: IF l_debug_mode = 'Y' THEN
4416: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',

Line 4435: IF x_return_status = Fnd_Api.G_RET_STS_SUCCESS THEN

4431: ,x_return_status => x_return_status
4432: ,x_msg_count => x_msg_count
4433: ,x_msg_data => x_msg_data);
4434:
4435: IF x_return_status = Fnd_Api.G_RET_STS_SUCCESS THEN
4436: IF NVL(l_calendar_id,-99) <> NVL(p_calendar_id,-99) AND l_calendar_type <> p_calendar_type THEN
4437: x_time_phase_flag := 'N';
4438: EXIT;
4439: END IF;

Line 4454: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4450: EXCEPTION
4451:
4452: WHEN OTHERS THEN
4453:
4454: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4455: x_msg_count := 1;
4456: x_msg_data := SQLERRM;
4457:
4458: Fnd_Msg_Pub.add_exc_msg

Line 4521: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4517: l_dummy NUMBER;
4518:
4519: BEGIN
4520: x_msg_count := 0;
4521: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4522: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4523:
4524: IF l_debug_mode = 'Y' THEN
4525: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',

Line 4550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4546: EXCEPTION
4547:
4548: WHEN OTHERS THEN
4549:
4550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4551: x_msg_count := 1;
4552: x_msg_data := SQLERRM;
4553:
4554: Fnd_Msg_Pub.add_exc_msg

Line 4686: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4682:
4683:
4684: IF x_return_status IS NULL THEN
4685: x_msg_count := 0;
4686: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4687: END IF;
4688:
4689: IF p_project_id IS NOT NULL THEN
4690:

Line 4795: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

4791:
4792:
4793: IF x_return_status IS NULL THEN
4794: x_msg_count := 0;
4795: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4796: END IF;
4797:
4798: IF p_project_id IS NOT NULL THEN
4799: /*

Line 5140: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5136:
5137: EXCEPTION
5138: WHEN OTHERS THEN
5139: x_msg_count := x_msg_count + 1;
5140: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5141: 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');
5142: RAISE;
5143: END Derive_Plan_Version_Ids;
5144:

Line 5171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5167: l_module_name VARCHAR2(100) := 'pa.plsql.Check_Perf_Cal_Consistency';
5168:
5169: BEGIN
5170: x_msg_count := 0;
5171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5172: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5173:
5174: IF l_debug_mode = 'Y' THEN
5175: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',

Line 5224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

5220: Pa_Debug.reset_curr_function;
5221: END IF;
5222: EXCEPTION
5223: WHEN OTHERS THEN
5224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5225: x_msg_count := 1;
5226: x_msg_data := SQLERRM;
5227:
5228: Fnd_Msg_Pub.add_exc_msg

Line 5265: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5261: l_num_of_projfunc_curr NUMBER;
5262:
5263: BEGIN
5264: x_msg_count := 0;
5265: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5266: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5267:
5268: IF l_debug_mode = 'Y' THEN
5269: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',

Line 5307: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

5303: Pa_Debug.reset_curr_function;
5304: END IF;
5305: EXCEPTION
5306: WHEN OTHERS THEN
5307: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5308: x_msg_count := 1;
5309: x_msg_data := SQLERRM;
5310:
5311: Fnd_Msg_Pub.add_exc_msg

Line 5404: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5400: -- OLAP END
5401: BEGIN
5402: l_IsSmartSliceCreated_Flag := 'Y';
5403:
5404: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5405: IF g_debug_mode = 'Y' THEN
5406: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: begining', TRUE , g_proc);
5407: END IF;
5408:

Line 5429: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5425:
5426:
5427:
5428:
5429: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5430: IF g_debug_mode = 'Y' THEN
5431: Pji_Utils.WRITE2LOG( 'NEW PPR END OF API ', TRUE , g_proc);
5432: END IF;
5433:

Line 5649: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5645: AND rst.project_id = l_project_id_tbl(i));
5646: EXCEPTION
5647: WHEN NO_DATA_FOUND THEN
5648: x_Smart_Slice_Flag := 'Y';
5649: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5650: IF ( g_debug_mode = 'Y' ) THEN
5651: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found ', TRUE , g_proc);
5652: END IF;
5653: END;

Line 5672: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5668:
5669: /* Important: If the process is Deferred for getting the data, then a new status will be passed i.e. 'D' */
5670:
5671: x_Smart_Slice_Flag := l_IsSmartSliceCreated_Flag;
5672: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5673: EXCEPTION
5674: WHEN OTHERS THEN
5675: x_msg_count := 1;
5676: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 5676: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5672: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5673: EXCEPTION
5674: WHEN OTHERS THEN
5675: x_msg_count := 1;
5676: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5677: IF g_debug_mode = 'Y' THEN
5678: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: When others ', TRUE , g_proc);
5679: END IF;
5680: NULL;

Line 5710: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5706: l_R_PlanVers_HavSame_RBS_Flag VARCHAR2(1) := 'Y';
5707: BEGIN
5708: l_R_PlanVers_HavSame_RBS_Flag := 'Y';
5709:
5710: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5711: IF g_debug_mode = 'Y' THEN
5712: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: begining', TRUE , g_proc);
5713: END IF;
5714:

Line 5762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5758: END IF;
5759:
5760: IF ( l_R_PlanVers_HavSame_RBS_Flag = 'Y') THEN
5761: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5763: ELSE
5764: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5765: x_msg_count := NVL(x_msg_count,0) + 1;
5766: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 5766: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5763: ELSE
5764: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5765: x_msg_count := NVL(x_msg_count,0) + 1;
5766: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5767: 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);
5768: END IF;
5769:
5770:

Line 5775: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5771: EXCEPTION
5772: WHEN NO_DATA_FOUND THEN
5773: x_R_PlanVers_HavSame_RBS_Flag := 'N';
5774: x_msg_count := NVL(x_msg_count,0) + 1;
5775: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5776: 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);
5777: IF g_debug_mode = 'Y' THEN
5778: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: No data found ', TRUE , g_proc);
5779: END IF;

Line 5785: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5781: END IF;
5782: EXCEPTION
5783: WHEN OTHERS THEN
5784: x_msg_count := 1;
5785: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5786: IF g_debug_mode = 'Y' THEN
5787: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: When others ', TRUE , g_proc);
5788: END IF;
5789: NULL;

Line 5829: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5825: END IF;
5826:
5827: IF x_return_status IS NULL THEN
5828: x_msg_count := 0;
5829: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5830: END IF;
5831:
5832: IF p_prg_flag = 'N' THEN
5833: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(

Line 5878: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5874:
5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: x_msg_count := x_msg_count + 1;
5878: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5879: 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');
5880: RAISE;
5881: END Get_Process_Status_Msg;
5882:

Line 5902: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5898: END IF;
5899:
5900: IF x_return_status IS NULL THEN
5901: x_msg_count := 0;
5902: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5903: END IF;
5904:
5905: IF p_structure_type = 'WORKPLAN' THEN
5906: l_relationship_type := 'LW';

Line 5940: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5936:
5937: EXCEPTION
5938: WHEN OTHERS THEN
5939: x_msg_count := x_msg_count + 1;
5940: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5941: 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');
5942: RAISE;
5943: END Check_Proj_Type_Consistency;
5944:

Line 5972: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

5968: END IF;
5969:
5970: IF x_return_status IS NULL THEN
5971: x_msg_count := 0;
5972: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5973: END IF;
5974:
5975: SELECT info.gl_calendar_id, info.pa_calendar_id
5976: INTO l_gl_calendar_id, l_pa_calendar_id

Line 6036: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6032:
6033: EXCEPTION
6034: WHEN NO_DATA_FOUND THEN
6035: x_msg_count := x_msg_count + 1;
6036: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6037: 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');
6038: x_report_date_julian :=2;
6039: WHEN OTHERS THEN
6040: x_msg_count := x_msg_count + 1;

Line 6041: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6037: 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');
6038: x_report_date_julian :=2;
6039: WHEN OTHERS THEN
6040: x_msg_count := x_msg_count + 1;
6041: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6042: 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');
6043: x_report_date_julian :=2;
6044: RAISE;
6045: END Derive_Pji_Calendar_Info;

Line 6067: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

6063: END IF;
6064:
6065: IF x_return_status IS NULL THEN
6066: x_msg_count := 0;
6067: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6068: END IF;
6069:
6070: x_currency_record_type := p_currency_record_type;
6071:

Line 6100: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6096:
6097: EXCEPTION
6098: WHEN OTHERS THEN
6099: x_msg_count := x_msg_count + 1;
6100: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6101: 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');
6102: RAISE;
6103: END Derive_Pji_Currency_Info;
6104:

Line 6122: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

6118: END IF;
6119:
6120: IF x_return_status IS NULL THEN
6121: x_msg_count := 0;
6122: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6123: END IF;
6124:
6125: SELECT COUNT(*)
6126: INTO l_plan_type_count

Line 6144: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6140:
6141: EXCEPTION
6142: WHEN OTHERS THEN
6143: x_msg_count := x_msg_count + 1;
6144: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6145: 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');
6146: RAISE;
6147: END Validate_Plan_Type;
6148:

Line 6433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

6429:
6430:
6431: IF x_return_status IS NULL THEN
6432: x_msg_count := 0;
6433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6434: END IF;
6435:
6436: SELECT CBS_VERSION_ID
6437: INTO x_cbs_version_id

Line 6466: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

6462: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
6463: 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);
6464: */ WHEN OTHERS THEN
6465: x_msg_count := x_msg_count + 1;
6466: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6467: 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_CBS_Parameters');
6468: RAISE;
6469: END DERIVE_DEFAULT_CBS_PARAMETERS;
6470: