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 PJI_UTILS

Line 215: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);

211: l_i NUMBER;
212: BEGIN
213:
214: IF g_debug_mode = 'Y' THEN
215: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);
216: END IF;
217: --Bug 5929145 Log events only for projects and not templates
218: -- Insert into event log for the project structure change of current project
219: FORALL l_i IN p_wbs_version_id_tbl.FIRST..p_wbs_version_id_tbl.LAST

Line 331: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);

327: -- OLAP END
328: BEGIN
329:
330: IF g_debug_mode = 'Y' THEN
331: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);
332: END IF;
333:
334: IF x_return_status IS NULL THEN
335: x_msg_count := 0;

Line 364: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: p_element_version_id cannot be null', TRUE , g_proc);

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;
367: dbms_standard.raise_application_error(-20020, 'populate_wbs_hierachy_cache: p_element_version_id cannot be null');
368:

Line 860: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: before getting percent', TRUE , g_proc);

856: END IF;
857: END IF;
858:
859: IF g_debug_mode = 'Y' THEN
860: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: before getting percent', TRUE , g_proc);
861: END IF;
862:
863: COMMIT;
864:

Line 866: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: finishing', TRUE , g_proc);

862:
863: COMMIT;
864:
865: IF g_debug_mode = 'Y' THEN
866: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: finishing', TRUE , g_proc);
867: END IF;
868:
869: EXCEPTION
870: WHEN OTHERS THEN

Line 895: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: beginning', TRUE , g_proc);

891: -- OLAP END V2
892:
893: BEGIN
894: IF g_debug_mode = 'Y' THEN
895: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: beginning', TRUE , g_proc);
896: END IF;
897:
898: IF x_return_status IS NULL THEN
899: x_msg_count := 0;

Line 976: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: finishing', TRUE , g_proc);

972: (p_project_id, p_current_version_id, p_latest_version_id, p_baselined_version_id, p_plan1_version_id, p_plan2_version_id, p_curr_wbs_vers_id);
973: END IF;
974:
975: IF g_debug_mode = 'Y' THEN
976: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: finishing', TRUE , g_proc);
977: END IF;
978:
979: EXCEPTION
980: WHEN OTHERS THEN

Line 1002: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: beginning', TRUE , g_proc);

998: l_tp_flag varchar2(10); --Bug 9048624
999: BEGIN
1000:
1001: IF g_debug_mode = 'Y' THEN
1002: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: beginning', TRUE , g_proc);
1003: END IF;
1004:
1005: IF x_return_status IS NULL THEN
1006: x_msg_count := 0;

Line 1040: l_tp_flag := PJI_UTILS.get_setup_parameter('TIME_PHASE_FLAG');

1036: --Bug 5593229
1037: -- x_calendar_type := g_global_calendar_type;
1038:
1039: --Bug 9048624
1040: l_tp_flag := PJI_UTILS.get_setup_parameter('TIME_PHASE_FLAG');
1041:
1042: if(l_tp_flag = 'N') then
1043: x_calendar_type := NVL(Fnd_Profile.value('PJI_DEF_RPT_CAL_TYPE'), 'E');
1044: else

Line 1071: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: finishing', TRUE , g_proc);

1067: , x_msg_data);
1068:
1069:
1070: IF g_debug_mode = 'Y' THEN
1071: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: finishing', TRUE , g_proc);
1072: END IF;
1073:
1074: EXCEPTION
1075: WHEN OTHERS THEN

Line 1095: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: beginning', TRUE , g_proc);

1091: l_time_phase_same_flag VARCHAR2(80);
1092: BEGIN
1093:
1094: IF g_debug_mode = 'Y' THEN
1095: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: beginning', TRUE , g_proc);
1096: END IF;
1097:
1098:
1099: /* SELECT fin_plan_type_id

Line 1117: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: finishing', TRUE , g_proc);

1113: , x_msg_count
1114: , x_msg_data);
1115:
1116: IF g_debug_mode = 'Y' THEN
1117: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: finishing', TRUE , g_proc);
1118: END IF;
1119:
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN

Line 1153: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: beginning', TRUE , g_proc);

1149: l_working_version_id NUMBER;
1150: BEGIN
1151:
1152: IF g_debug_mode = 'Y' THEN
1153: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: beginning', TRUE , g_proc);
1154: END IF;
1155:
1156: IF x_return_status IS NULL THEN
1157: x_msg_count := 0;

Line 1262: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: finishing', TRUE , g_proc);

1258: x_calendar_id := l_gl_calendar_id;
1259: END IF;
1260:
1261: IF g_debug_mode = 'Y' THEN
1262: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: finishing', TRUE , g_proc);
1263: END IF;
1264:
1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN

Line 1287: Pji_Utils.WRITE2LOG( 'get_version_type: beginning', TRUE , g_proc);

1283: l_version_type pa_budget_versions.version_type%TYPE;
1284: BEGIN
1285:
1286: IF g_debug_mode = 'Y' THEN
1287: Pji_Utils.WRITE2LOG( 'get_version_type: beginning', TRUE , g_proc);
1288: END IF;
1289:
1290: SELECT fin_plan_preference_code
1291: INTO l_version_type

Line 1304: Pji_Utils.WRITE2LOG( 'get_version_type: returning', TRUE , g_proc);

1300: l_version_type := p_version_type;
1301: END IF;
1302:
1303: IF g_debug_mode = 'Y' THEN
1304: Pji_Utils.WRITE2LOG( 'get_version_type: returning', TRUE , g_proc);
1305: END IF;
1306:
1307: RETURN l_version_type;
1308:

Line 1348: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);

1344: l_temp_holder2 NUMBER;
1345: BEGIN
1346:
1347: IF g_debug_mode = 'Y' THEN
1348: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);
1349: END IF;
1350:
1351:
1352: IF x_return_status IS NULL THEN

Line 1557: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);

1553: x_orig_cstbudget2_version_id := g_orig_cstbudget2_version_id;
1554: x_orig_revbudget2_version_id := g_orig_revbudget2_version_id;
1555:
1556: IF g_debug_mode = 'Y' THEN
1557: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);
1558: END IF;
1559:
1560: EXCEPTION
1561: WHEN OTHERS THEN

Line 1584: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: beginning', TRUE , g_proc);

1580:
1581: BEGIN
1582:
1583: IF g_debug_mode = 'Y' THEN
1584: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: beginning', TRUE , g_proc);
1585: END IF;
1586:
1587: IF x_return_status IS NULL THEN
1588: x_msg_count := 0;

Line 1619: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);

1615: end if;
1616: /* Code added for 9112216 ends */
1617:
1618: IF g_debug_mode = 'Y' THEN
1619: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);
1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN

Line 1644: Pji_Utils.WRITE2LOG( 'derive_perf_currency_info: beginning', TRUE , g_proc);

1640:
1641: BEGIN
1642:
1643: IF g_debug_mode = 'Y' THEN
1644: Pji_Utils.WRITE2LOG( 'derive_perf_currency_info: beginning', TRUE , g_proc);
1645: END IF;
1646:
1647: IF x_return_status IS NULL THEN
1648: x_msg_count := 0;

Line 1655: x_currency_code:=Pji_Utils.get_global_primary_currency;

1651:
1652: /*--bug 5593229
1653: x_currency_record_type:=1;
1654: x_currency_type:='G';
1655: x_currency_code:=Pji_Utils.get_global_primary_currency;
1656: */
1657:
1658: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1659: IF pji_utils.get_setup_parameter('GLOBAL_CURR1_FLAG') = 'Y' THEN --Bug 9067029

Line 1659: IF pji_utils.get_setup_parameter('GLOBAL_CURR1_FLAG') = 'Y' THEN --Bug 9067029

1655: x_currency_code:=Pji_Utils.get_global_primary_currency;
1656: */
1657:
1658: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1659: IF pji_utils.get_setup_parameter('GLOBAL_CURR1_FLAG') = 'Y' THEN --Bug 9067029
1660: x_currency_record_type:= 1;
1661: x_currency_type:= 'G';
1662: x_currency_code:= Pji_Utils.get_global_primary_currency;
1663: ELSE

Line 1662: x_currency_code:= Pji_Utils.get_global_primary_currency;

1658: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1659: IF pji_utils.get_setup_parameter('GLOBAL_CURR1_FLAG') = 'Y' THEN --Bug 9067029
1660: x_currency_record_type:= 1;
1661: x_currency_type:= 'G';
1662: x_currency_code:= Pji_Utils.get_global_primary_currency;
1663: ELSE
1664: x_currency_record_type:= 4;
1665: x_currency_type:= 'F';
1666: x_currency_code := g_projfunc_currency_code;

Line 1669: IF pji_utils.get_setup_parameter('GLOBAL_CURR2_FLAG') = 'Y' THEN --Bug 9067029

1665: x_currency_type:= 'F';
1666: x_currency_code := g_projfunc_currency_code;
1667: END IF;
1668: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1669: IF pji_utils.get_setup_parameter('GLOBAL_CURR2_FLAG') = 'Y' THEN --Bug 9067029
1670: x_currency_record_type:= 2;
1671: x_currency_type:= 'G';
1672: x_currency_code:= Pji_Utils.get_global_secondary_currency;
1673: ELSE

Line 1672: x_currency_code:= Pji_Utils.get_global_secondary_currency;

1668: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1669: IF pji_utils.get_setup_parameter('GLOBAL_CURR2_FLAG') = 'Y' THEN --Bug 9067029
1670: x_currency_record_type:= 2;
1671: x_currency_type:= 'G';
1672: x_currency_code:= Pji_Utils.get_global_secondary_currency;
1673: ELSE
1674: x_currency_record_type:= 4;
1675: x_currency_type:= 'F';
1676: x_currency_code := g_projfunc_currency_code;

Line 1689: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);

1685: x_currency_code := g_projfunc_currency_code;
1686: END IF;
1687:
1688: IF g_debug_mode = 'Y' THEN
1689: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);
1690: END IF;
1691:
1692: EXCEPTION
1693: WHEN OTHERS THEN

Line 1710: Pji_Utils.WRITE2LOG( 'derive_factorby: beginning', TRUE , g_proc);

1706: l_factor_by_code VARCHAR2(30);
1707: BEGIN
1708:
1709: IF g_debug_mode = 'Y' THEN
1710: Pji_Utils.WRITE2LOG( 'derive_factorby: beginning', TRUE , g_proc);
1711: END IF;
1712:
1713: IF x_return_status IS NULL THEN
1714: x_msg_count := 0;

Line 1741: Pji_Utils.WRITE2LOG( 'derive_factorby: returning', TRUE , g_proc);

1737: l_factor_by_code:= 1;
1738: END IF;
1739:
1740: IF g_debug_mode = 'Y' THEN
1741: Pji_Utils.WRITE2LOG( 'derive_factorby: returning', TRUE , g_proc);
1742: END IF;
1743:
1744: RETURN l_factor_by_code;
1745: EXCEPTION

Line 1763: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: beginning', TRUE , g_proc);

1759: l_msg_data VARCHAR2(2000);
1760: BEGIN
1761:
1762: IF g_debug_mode = 'Y' THEN
1763: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: beginning', TRUE , g_proc);
1764: END IF;
1765:
1766: -- IF p_project_id <> g_project_id THEN
1767: /*

Line 1778: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: finishing', TRUE , g_proc);

1774:
1775: -- RETURN 'N'; --bug 4127656 temporarily turn off program reporting
1776:
1777: IF g_debug_mode = 'Y' THEN
1778: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: finishing', TRUE , g_proc);
1779: END IF;
1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN

Line 1801: Pji_Utils.WRITE2LOG( 'derive_project_attributes: beginning', TRUE , g_proc);

1797: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1798: BEGIN
1799:
1800: IF g_debug_mode = 'Y' THEN
1801: Pji_Utils.WRITE2LOG( 'derive_project_attributes: beginning', TRUE , g_proc);
1802: END IF;
1803:
1804: IF x_return_status IS NULL THEN
1805: x_msg_count := 0;

Line 1846: Pji_Utils.WRITE2LOG( 'derive_project_attributes: finishing', TRUE , g_proc);

1842: /* AND NVL(info.org_id,-99) = NVL(prj.org_id,-99); -- Added NVL for bug 3989132 */
1843: AND info.org_id = prj.org_id; -- Removed NVL for Bug5376591
1844:
1845: IF g_debug_mode = 'Y' THEN
1846: Pji_Utils.WRITE2LOG( 'derive_project_attributes: finishing', TRUE , g_proc);
1847: END IF;
1848:
1849: -- END IF;
1850: EXCEPTION

Line 1877: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: beginning', TRUE , g_proc);

1873: IS
1874: BEGIN
1875:
1876: IF g_debug_mode = 'Y' THEN
1877: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: beginning', TRUE , g_proc);
1878: END IF;
1879:
1880:
1881: IF x_return_status IS NULL THEN

Line 1904: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: finishing', TRUE , g_proc);

1900: , x_msg_count
1901: , x_msg_data);
1902:
1903: IF g_debug_mode = 'Y' THEN
1904: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: finishing', TRUE , g_proc);
1905: END IF;
1906:
1907: EXCEPTION
1908: WHEN NO_DATA_FOUND THEN

Line 1947: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: beginning', TRUE , g_proc);

1943: ORDER BY primary_reporting_rbs_flag DESC;
1944: BEGIN
1945:
1946: IF g_debug_mode = 'Y' THEN
1947: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: beginning', TRUE , g_proc);
1948: END IF;
1949:
1950: IF x_return_status IS NULL THEN
1951: x_msg_count := 0;

Line 1978: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: finishing', TRUE , g_proc);

1974: , x_msg_count
1975: , x_msg_data);
1976:
1977: IF g_debug_mode = 'Y' THEN
1978: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: finishing', TRUE , g_proc);
1979: END IF;
1980:
1981: EXCEPTION
1982: WHEN NO_DATA_FOUND THEN

Line 2015: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: beginning', TRUE , g_proc);

2011:
2012: BEGIN
2013:
2014: IF g_debug_mode = 'Y' THEN
2015: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: beginning', TRUE , g_proc);
2016: END IF;
2017:
2018: IF x_return_status IS NULL THEN
2019: x_msg_count := 0;

Line 2033: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: finishing', TRUE , g_proc);

2029:
2030: CLOSE c_rbs_elements; -- Bug#3877822
2031:
2032: IF g_debug_mode = 'Y' THEN
2033: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: finishing', TRUE , g_proc);
2034: END IF;
2035:
2036: EXCEPTION
2037: WHEN NO_DATA_FOUND THEN

Line 2060: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: beginning', TRUE , g_proc);

2056: IS
2057: BEGIN
2058:
2059: IF g_debug_mode = 'Y' THEN
2060: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: beginning', TRUE , g_proc);
2061: END IF;
2062:
2063: IF x_return_status IS NULL THEN
2064: x_msg_count := 0;

Line 2134: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: finishing', TRUE , g_proc);

2130: AND hdr.project_id = p_project_id
2131: AND hdr.plan_version_id = p_plan_version_id;
2132: */
2133: IF g_debug_mode = 'Y' THEN
2134: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: finishing', TRUE , g_proc);
2135: END IF;
2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN

Line 2163: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: beginning', TRUE , g_proc);

2159: ORDER BY NVL(Latest_eff_published_flag,'N') DESC, NVL(current_working_flag,'N') DESC;
2160: BEGIN
2161:
2162: IF g_debug_mode = 'Y' THEN
2163: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: beginning', TRUE , g_proc);
2164: END IF;
2165:
2166: IF x_return_status IS NULL THEN
2167: x_msg_count := 0;

Line 2181: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: finishing', TRUE , g_proc);

2177:
2178: CLOSE c_wbs_params; --bug#3877822
2179:
2180: IF g_debug_mode = 'Y' THEN
2181: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: finishing', TRUE , g_proc);
2182: END IF;
2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN

Line 2218: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);

2214:
2215: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
2216: IF g_debug_mode = 'Y' THEN
2217: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
2218: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
2219: END IF;
2220:
2221: IF x_return_status IS NULL THEN
2222: x_msg_count := 0;

Line 2312: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);

2308:
2309: END IF;
2310:
2311: IF g_debug_mode = 'Y' THEN
2312: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
2313: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
2314: END IF;
2315: Pa_Debug.Reset_Err_Stack;
2316:

Line 2352: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: begining', TRUE , g_proc);

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);
2353: END IF;
2354:
2355: SELECT pt.plan_class_code
2356: , pt.NAME

Line 2387: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: finishing', TRUE , g_proc);

2383: x_budget_forecast_flag := 'F';
2384: END IF;
2385:
2386: IF g_debug_mode = 'Y' THEN
2387: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: finishing', TRUE , g_proc);
2388: END IF;
2389:
2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN

Line 2419: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: begining', TRUE , g_proc);

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);
2420: END IF;
2421:
2422: SELECT op.MARGIN_DERIVED_FROM_CODE
2423: INTO x_plan_margin_mask

Line 2430: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: finishing', TRUE , g_proc);

2426: AND op.fin_plan_option_level_code = 'PLAN_VERSION'
2427: AND op.project_id = p_project_id;
2428:
2429: IF g_debug_mode = 'Y' THEN
2430: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: finishing', TRUE , g_proc);
2431: END IF;
2432: EXCEPTION
2433: WHEN NO_DATA_FOUND THEN
2434: x_msg_count := x_msg_count + 1;

Line 2458: Pji_Utils.WRITE2LOG( 'derive_version_parameters: begining', TRUE , g_proc);

2454: IS
2455: BEGIN
2456:
2457: IF g_debug_mode = 'Y' THEN
2458: Pji_Utils.WRITE2LOG( 'derive_version_parameters: begining', TRUE , g_proc);
2459: END IF;
2460:
2461: IF x_return_status IS NULL THEN
2462: x_msg_count := 0;

Line 2472: Pji_Utils.WRITE2LOG( 'derive_version_parameters: finishing', TRUE , g_proc);

2468: FROM pa_budget_versions
2469: WHERE budget_version_id = p_version_id;
2470:
2471: IF g_debug_mode = 'Y' THEN
2472: Pji_Utils.WRITE2LOG( 'derive_version_parameters: finishing', TRUE , g_proc);
2473: END IF;
2474:
2475: EXCEPTION
2476: WHEN NO_DATA_FOUND THEN

Line 2504: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: begining', TRUE , g_proc);

2500: BEGIN
2501:
2502:
2503: IF g_debug_mode = 'Y' THEN
2504: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: begining', TRUE , g_proc);
2505: END IF;
2506:
2507: IF x_return_status IS NULL THEN
2508: x_msg_count := 0;

Line 2546: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: finishing', TRUE , g_proc);

2542: x_prior_fcst_version_id := -99;
2543: END IF;
2544:
2545: IF g_debug_mode = 'Y' THEN
2546: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: finishing', TRUE , g_proc);
2547: END IF;
2548:
2549: EXCEPTION
2550: WHEN OTHERS THEN

Line 2574: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: begining', TRUE , g_proc);

2570: l_msg_data VARCHAR2(1000);
2571: BEGIN
2572:
2573: IF g_debug_mode = 'Y' THEN
2574: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: begining', TRUE , g_proc);
2575: END IF;
2576:
2577: IF x_return_status IS NULL THEN
2578: x_msg_count := 0;

Line 2612: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: finishing', TRUE , g_proc);

2608: x_published_version_id := -99;
2609: END IF;
2610:
2611: IF g_debug_mode = 'Y' THEN
2612: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: finishing', TRUE , g_proc);
2613: END IF;
2614:
2615: EXCEPTION
2616: WHEN OTHERS THEN

Line 2636: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);

2632:
2633: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2634: IF g_debug_mode = 'Y' THEN
2635: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2636: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2637: END IF;
2638:
2639: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN
2640: Derive_Period_Julian(p_calendar_type

Line 2652: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);

2648: -- END IF;
2649: RETURN g_report_date_julian;
2650:
2651: IF g_debug_mode = 'Y' THEN
2652: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2653: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2654: END IF;
2655: Pa_Debug.Reset_Err_Stack;
2656:

Line 2676: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);

2672:
2673: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2674: IF g_debug_mode = 'Y' THEN
2675: Pa_Debug.write_file('Get_Period_Name: begining',5);
2676: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2677: END IF;
2678:
2679: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN
2680: Derive_Period_Julian(p_calendar_type

Line 2691: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);

2687: g_input_calendar_id := p_calendar_id;
2688: -- END IF;
2689:
2690: IF g_debug_mode = 'Y' THEN
2691: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2692: Pa_Debug.write_file('Get_Period_Name: returning',5);
2693: END IF;
2694: Pa_Debug.Reset_Err_Stack;
2695:

Line 2734: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);

2730: BEGIN
2731: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2732: IF g_debug_mode = 'Y' THEN
2733: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2734: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2735: END IF;
2736:
2737: IF p_calendar_type = 'E' THEN
2738: x_calendar_id := -1;

Line 2989: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);

2985:
2986:
2987:
2988: IF g_debug_mode = 'Y' THEN
2989: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2990: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2991: END IF;
2992: Pa_Debug.Reset_Err_Stack;
2993:

Line 3016: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: begining', TRUE , g_proc);

3012: l_struct_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
3013: BEGIN
3014:
3015: IF g_debug_mode = 'Y' THEN
3016: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: begining', TRUE , g_proc);
3017: END IF;
3018:
3019: l_struct_sharing_code := Pa_Project_Structure_Utils.get_Structure_sharing_code(
3020: p_project_id=> p_project_id );

Line 3027: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: returning', TRUE , g_proc);

3023: -- SPLIT_NO_MAPPING
3024: -- SPLILT_MAPPING
3025:
3026: IF g_debug_mode = 'Y' THEN
3027: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: returning', TRUE , g_proc);
3028: END IF;
3029:
3030: IF (l_struct_sharing_code = 'SPLIT_NO_MAPPING' OR l_struct_sharing_code = 'SPLILT_MAPPING') THEN
3031: RETURN -2;

Line 3081: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);

3077:
3078: BEGIN
3079: -- ----------------------------------------------
3080: IF g_debug_mode = 'Y' THEN
3081: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);
3082: END IF;
3083:
3084: -- check if pji_org_extr_info table has a record for p_org_id
3085: -- Count funtion is introduced

Line 3159: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: finishing', TRUE , g_proc);

3155:
3156: COMMIT;
3157:
3158: IF g_debug_mode = 'Y' THEN
3159: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: finishing', TRUE , g_proc);
3160: END IF;
3161:
3162:
3163: END update_curr_rep_periods;

Line 3196: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: begining', TRUE , g_proc);

3192: BEGIN
3193:
3194:
3195: IF g_debug_mode = 'Y' THEN
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;

Line 3436: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: finishing', TRUE , g_proc);

3432:
3433: END IF;
3434:
3435: IF g_debug_mode = 'Y' THEN
3436: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: finishing', TRUE , g_proc);
3437: END IF;
3438:
3439:
3440: EXCEPTION

Line 3473: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: begining', TRUE , g_proc);

3469:
3470: BEGIN
3471:
3472: IF g_debug_mode = 'Y' THEN
3473: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: begining', TRUE , g_proc);
3474: END IF;
3475:
3476: IF x_return_status IS NULL THEN
3477: x_msg_count := 0;

Line 3492: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: finishing', TRUE , g_proc);

3488:
3489: CLOSE c_dates;--bug#3877822
3490:
3491: IF g_debug_mode = 'Y' THEN
3492: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: finishing', TRUE , g_proc);
3493: END IF;
3494:
3495: EXCEPTION
3496: WHEN NO_DATA_FOUND THEN

Line 3518: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: begining', TRUE , g_proc);

3514: IS
3515: BEGIN
3516:
3517: IF g_debug_mode = 'Y' THEN
3518: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: begining', TRUE , g_proc);
3519: END IF;
3520:
3521: IF x_return_status IS NULL THEN
3522: x_msg_count := 0;

Line 3535: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: finishing', TRUE , g_proc);

3531: );
3532:
3533:
3534: IF g_debug_mode = 'Y' THEN
3535: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: finishing', TRUE , g_proc);
3536: END IF;
3537:
3538: EXCEPTION
3539: WHEN NO_DATA_FOUND THEN

Line 3561: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: begining', TRUE , g_proc);

3557: IS
3558: BEGIN
3559:
3560: IF g_debug_mode = 'Y' THEN
3561: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: begining', TRUE , g_proc);
3562: END IF;
3563:
3564: IF x_return_status IS NULL THEN
3565: x_msg_count := 0;

Line 3577: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: finishing', TRUE , g_proc);

3573: , x_to_period
3574: );
3575:
3576: IF g_debug_mode = 'Y' THEN
3577: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: finishing', TRUE , g_proc);
3578: END IF;
3579:
3580: EXCEPTION
3581: WHEN NO_DATA_FOUND THEN

Line 3604: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);

3600:
3601: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3602: IF g_debug_mode = 'Y' THEN
3603: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3604: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3605: END IF;
3606:
3607: Derive_Slice_Name(p_project_id,
3608: p_calendar_id,

Line 3616: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);

3612: l_msg_data);
3613:
3614:
3615: IF g_debug_mode = 'Y' THEN
3616: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3617: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3618: END IF;
3619: Pa_Debug.Reset_Err_Stack;
3620:

Line 3649: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: begining', TRUE , g_proc);

3645: l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3646: j NUMBER := 0;
3647: BEGIN
3648: IF g_debug_mode = 'Y' THEN
3649: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: begining', TRUE , g_proc);
3650: END IF;
3651:
3652: -- Checking if project id is null or p_plan_version_ids's table is null then exiting smoothly
3653: IF ( p_project_id IS NULL OR p_plan_version_ids.COUNT <= 0 ) THEN

Line 3655: Pji_Utils.WRITE2LOG( 'Exiting from Get_Default_Period_Dates: no Project or Plan version id found', TRUE , g_proc);

3651:
3652: -- Checking if project id is null or p_plan_version_ids's table is null then exiting smoothly
3653: IF ( p_project_id IS NULL OR p_plan_version_ids.COUNT <= 0 ) THEN
3654: IF g_debug_mode = 'Y' THEN
3655: Pji_Utils.WRITE2LOG( 'Exiting from Get_Default_Period_Dates: no Project or Plan version id found', TRUE , g_proc);
3656: END IF;
3657:
3658: RETURN;
3659: END IF;

Line 3671: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: inside pa_resource_assignments table', TRUE , g_proc);

3667: j := j + 1;
3668: l_plan_version_ids(j) := p_plan_version_ids(i);
3669:
3670: IF g_debug_mode = 'Y' THEN
3671: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: inside pa_resource_assignments table', TRUE , g_proc);
3672: END IF;
3673: END IF;
3674: END LOOP;
3675:

Line 3697: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Done selecting pa_resource_assignments table', TRUE , g_proc);

3693: l_plan_version_ids(9),l_plan_version_ids(10),l_plan_version_ids(11),l_plan_version_ids(12),
3694: l_plan_version_ids(13),l_plan_version_ids(14),l_plan_version_ids(15),l_plan_version_ids(16),l_plan_version_ids(17) );
3695:
3696: IF g_debug_mode = 'Y' THEN
3697: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Done selecting pa_resource_assignments table', TRUE , g_proc);
3698: END IF;
3699: EXCEPTION
3700: WHEN NO_DATA_FOUND THEN
3701: l_min_date := NULL;

Line 3704: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: No data found in pa_resource_assignments table', TRUE , g_proc);

3700: WHEN NO_DATA_FOUND THEN
3701: l_min_date := NULL;
3702: l_max_date := NULL;
3703: IF g_debug_mode = 'Y' THEN
3704: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: No data found in pa_resource_assignments table', TRUE , g_proc);
3705: END IF;
3706: END;
3707: END IF;
3708:

Line 3713: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Leaving ', TRUE , g_proc);

3709: x_min_julian_date := TO_CHAR(l_min_date,'j');
3710: x_max_julian_date := TO_CHAR(l_max_date,'j');
3711:
3712: IF g_debug_mode = 'Y' THEN
3713: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Leaving ', TRUE , g_proc);
3714: END IF;
3715:
3716: EXCEPTION
3717: WHEN OTHERS THEN

Line 3721: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: When others ', TRUE , g_proc);

3717: WHEN OTHERS THEN
3718: x_min_julian_date := NULL;
3719: x_max_julian_date := NULL;
3720: IF g_debug_mode = 'Y' THEN
3721: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: When others ', TRUE , g_proc);
3722: END IF;
3723: NULL;
3724:
3725: END Get_Default_Period_Dates;

Line 3738: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: begining', TRUE , g_proc);

3734: IS
3735: BEGIN
3736:
3737: IF g_debug_mode = 'Y' THEN
3738: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: begining', TRUE , g_proc);
3739: END IF;
3740:
3741: IF x_return_status IS NULL THEN
3742: x_msg_count := 0;

Line 3758: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: finishing', TRUE , g_proc);

3754: AND p.org_id = t.org_id ; -- Removed NVL for Bug 5376591
3755:
3756:
3757: IF g_debug_mode = 'Y' THEN
3758: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: finishing', TRUE , g_proc);
3759: END IF;
3760:
3761: EXCEPTION
3762: WHEN NO_DATA_FOUND THEN

Line 3792: Pji_Utils.WRITE2LOG( 'Derive_Percent_Complete: begining', TRUE , g_proc);

3788: l_report_date DATE := NULL;
3789: BEGIN
3790:
3791: IF g_debug_mode = 'Y' THEN
3792: Pji_Utils.WRITE2LOG( 'Derive_Percent_Complete: begining', TRUE , g_proc);
3793: END IF;
3794:
3795: IF x_return_status IS NULL THEN
3796: x_msg_count := 0;

Line 3836: Pji_Utils.WRITE2LOG( 'Derive_Complete_Percent: finishing', TRUE , g_proc);

3832: ,p_as_of_date =>l_report_date
3833: ,p_program_flag => p_prg_flag);
3834: END IF;
3835: IF g_debug_mode = 'Y' THEN
3836: Pji_Utils.WRITE2LOG( 'Derive_Complete_Percent: finishing', TRUE , g_proc);
3837: END IF;
3838:
3839: EXCEPTION
3840: WHEN NO_DATA_FOUND THEN

Line 3863: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: begining', TRUE , g_proc);

3859: l_project_org NUMBER(15);
3860: BEGIN
3861:
3862: IF g_debug_mode = 'Y' THEN
3863: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: begining', TRUE , g_proc);
3864: END IF;
3865:
3866: IF x_return_status IS NULL THEN
3867: x_msg_count := 0;

Line 3888: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: finishing', TRUE , g_proc);

3884: x_cross_org_flag := 'T';
3885: END IF;
3886:
3887: IF g_debug_mode = 'Y' THEN
3888: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: finishing', TRUE , g_proc);
3889: END IF;
3890:
3891: EXCEPTION
3892: WHEN NO_DATA_FOUND THEN

Line 4680: Pji_Utils.WRITE2LOG( 'Get_Plan_Types_Id: beginning', TRUE , g_proc);

4676: l_rev_bgt_plan_type_id NUMBER := NULL;
4677:
4678: BEGIN
4679: IF g_debug_mode = 'Y' THEN
4680: Pji_Utils.WRITE2LOG( 'Get_Plan_Types_Id: beginning', TRUE , g_proc);
4681: END IF;
4682:
4683:
4684: IF x_return_status IS NULL THEN

Line 4789: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);

4785: l_tmp_orig_revforecast_ver_id NUMBER;
4786: BEGIN
4787:
4788: IF g_debug_mode = 'Y' THEN
4789: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);
4790: END IF;
4791:
4792:
4793: IF x_return_status IS NULL THEN

Line 5134: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);

5130:
5131: Fnd_Msg_Pub.Initialize;
5132:
5133: IF g_debug_mode = 'Y' THEN
5134: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);
5135: END IF;
5136:
5137: EXCEPTION
5138: WHEN OTHERS THEN

Line 5406: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: begining', TRUE , g_proc);

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:
5409:
5410: -- OLAP START

Line 5431: Pji_Utils.WRITE2LOG( 'NEW PPR END OF API ', TRUE , g_proc);

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:
5434: return ; -- NO NEED TO EXECUTE THE BELOW CODE.
5435:

Line 5448: Pji_Utils.WRITE2LOG( 'Exiting from Is_Smart_Slice_Created: no RBS or Plan version id found', TRUE , g_proc);

5444:
5445: -- Checking if RBS version id is null or p_plan_version_ids's table is null then exiting smoothly
5446: IF ( p_rbs_version_id IS NULL OR p_plan_version_id_tbl.COUNT <= 0 ) THEN
5447: IF g_debug_mode = 'Y' THEN
5448: Pji_Utils.WRITE2LOG( 'Exiting from Is_Smart_Slice_Created: no RBS or Plan version id found', TRUE , g_proc);
5449: END IF;
5450:
5451: RETURN;
5452: END IF;

Line 5468: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: inside assignment', TRUE , g_proc);

5464: IF ( NOT l_found ) THEN
5465: l_plan_version_id_tbl(l_plan_version_id_tbl.COUNT) := p_plan_version_id_tbl(i);
5466: l_plan_version_id_tbl.EXTEND;
5467: IF g_debug_mode = 'Y' THEN
5468: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: inside assignment', TRUE , g_proc);
5469: END IF;
5470: END IF;
5471: END IF;
5472: END LOOP;

Line 5489: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with logic', TRUE , g_proc);

5485: l_project_id_tbl(i) := p_project_id;
5486: END LOOP;
5487:
5488: IF ( g_debug_mode = 'Y') THEN
5489: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with logic', TRUE , g_proc);
5490: END IF;
5491:
5492: /* Program case */
5493: IF (NVL(p_prg_rollup_flag,'N') = 'Y') THEN

Line 5496: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Entering into Program logic', TRUE , g_proc);

5492: /* Program case */
5493: IF (NVL(p_prg_rollup_flag,'N') = 'Y') THEN
5494:
5495: IF g_debug_mode = 'Y' THEN
5496: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Entering into Program logic', TRUE , g_proc);
5497: END IF;
5498:
5499: BEGIN
5500: SELECT project_id

Line 5512: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with Project Select', TRUE , g_proc);

5508: NULL;
5509: END;
5510:
5511: IF (g_debug_mode = 'Y') THEN
5512: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with Project Select', TRUE , g_proc);
5513: END IF;
5514:
5515: BEGIN
5516: SELECT DISTINCT head.wbs_version_id BULK COLLECT

Line 5530: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in wbs_version_id Select', TRUE , g_proc);

5526: EXCEPTION
5527: WHEN NO_DATA_FOUND THEN
5528: NULL;
5529: IF g_debug_mode = 'Y' THEN
5530: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in wbs_version_id Select', TRUE , g_proc);
5531: END IF;
5532: END;
5533:
5534: IF g_debug_mode = 'Y' THEN

Line 5535: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with wbs_version_id Select', TRUE , g_proc);

5531: END IF;
5532: END;
5533:
5534: IF g_debug_mode = 'Y' THEN
5535: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with wbs_version_id Select', TRUE , g_proc);
5536: END IF;
5537:
5538: BEGIN
5539: SELECT DISTINCT NVL(head.plan_type_id,-1) BULK COLLECT

Line 5553: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in plan_type_id Select', TRUE , g_proc);

5549: EXCEPTION
5550: WHEN NO_DATA_FOUND THEN
5551: NULL;
5552: IF g_debug_mode = 'Y' THEN
5553: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in plan_type_id Select', TRUE , g_proc);
5554: END IF;
5555: END;
5556:
5557: IF g_debug_mode = 'Y' THEN

Line 5558: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with plan_type_id Select', TRUE , g_proc);

5554: END IF;
5555: END;
5556:
5557: IF g_debug_mode = 'Y' THEN
5558: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with plan_type_id Select', TRUE , g_proc);
5559: END IF;
5560:
5561: FOR i IN 1..17 LOOP
5562: IF ( l_get_wbs_version_id_tbl.EXISTS(i)) THEN

Line 5580: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before deleting project tem table and plan version temp table', TRUE , g_proc);

5576: END IF;
5577: END LOOP;
5578:
5579: IF g_debug_mode = 'Y' THEN
5580: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before deleting project tem table and plan version temp table', TRUE , g_proc);
5581: END IF;
5582:
5583: l_plan_version_id_tbl.DELETE;
5584: l_project_id_tbl.DELETE;

Line 5587: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before selecting plan version,project,wbs', TRUE , g_proc);

5583: l_plan_version_id_tbl.DELETE;
5584: l_project_id_tbl.DELETE;
5585:
5586: IF g_debug_mode = 'Y' THEN
5587: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before selecting plan version,project,wbs', TRUE , g_proc);
5588: END IF;
5589:
5590: BEGIN
5591: SELECT DISTINCT head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id BULK COLLECT

Line 5618: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in selecting plan version,project,wbs', TRUE , g_proc);

5614: EXCEPTION
5615: WHEN OTHERS THEN
5616: NULL;
5617: IF g_debug_mode = 'Y' THEN
5618: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in selecting plan version,project,wbs', TRUE , g_proc);
5619: END IF;
5620: END;
5621:
5622: IF g_debug_mode = 'Y' THEN

Line 5623: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with selecting plan version,project,wbs', TRUE , g_proc);

5619: END IF;
5620: END;
5621:
5622: IF g_debug_mode = 'Y' THEN
5623: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with selecting plan version,project,wbs', TRUE , g_proc);
5624: END IF;
5625:
5626: END IF; -- Program Case
5627:

Line 5629: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with program logic and checking status table', TRUE , g_proc);

5625:
5626: END IF; -- Program Case
5627:
5628: IF g_debug_mode = 'Y' THEN
5629: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with program logic and checking status table', TRUE , g_proc);
5630: END IF;
5631:
5632:
5633: FOR i IN 1..l_plan_version_id_tbl.COUNT LOOP

Line 5651: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found ', TRUE , g_proc);

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;
5654:
5655: IF ( g_debug_mode = 'Y') THEN

Line 5656: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Coming out as one of the version does not hace smart slice', TRUE , g_proc);

5652: END IF;
5653: END;
5654:
5655: IF ( g_debug_mode = 'Y') THEN
5656: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Coming out as one of the version does not hace smart slice', TRUE , g_proc);
5657: END IF;
5658:
5659: -- If smart slice does not exist mark to create the same
5660: IF ( l_exists = 'N' ) THEN

Line 5678: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: When others ', TRUE , g_proc);

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;
5681: END Is_Smart_Slice_Created;
5682:

Line 5712: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: begining', TRUE , g_proc);

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:
5715: -- Checking if p_plan_version_ids's table is null then exiting smoothly
5716: IF ( p_fin_plan_version_id_tbl.COUNT <= 0 ) THEN

Line 5718: Pji_Utils.WRITE2LOG( 'Exiting from Chk_plan_vers_have_same_RBS: No Plan version id found', TRUE , g_proc);

5714:
5715: -- Checking if p_plan_version_ids's table is null then exiting smoothly
5716: IF ( p_fin_plan_version_id_tbl.COUNT <= 0 ) THEN
5717: IF g_debug_mode = 'Y' THEN
5718: Pji_Utils.WRITE2LOG( 'Exiting from Chk_plan_vers_have_same_RBS: No Plan version id found', TRUE , g_proc);
5719: END IF;
5720:
5721: RETURN;
5722: END IF;

Line 5733: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: inside assignment', TRUE , g_proc);

5729: j := j + 1;
5730: l_fin_plan_version_ids(j) := p_fin_plan_version_id_tbl(i);
5731:
5732: IF g_debug_mode = 'Y' THEN
5733: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: inside assignment', TRUE , g_proc);
5734: END IF;
5735: END IF;
5736: END LOOP;
5737:

Line 5757: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);

5753: AND fin_plan_version_id IN (l_fin_plan_version_ids(1),l_fin_plan_version_ids(2),l_fin_plan_version_ids(3),l_fin_plan_version_ids(4),
5754: l_fin_plan_version_ids(5),l_fin_plan_version_ids(6),l_fin_plan_version_ids(7),l_fin_plan_version_ids(8));
5755:
5756: IF g_debug_mode = 'Y' THEN
5757: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);
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;

Line 5778: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: No data found ', TRUE , g_proc);

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;
5780: END;
5781: END IF;
5782: EXCEPTION

Line 5787: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: When others ', TRUE , g_proc);

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;
5790: END Chk_plan_vers_have_same_RBS;
5791:

Line 5824: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: beginning', TRUE , g_proc);

5820:
5821: BEGIN
5822:
5823: IF g_debug_mode = 'Y' THEN
5824: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: beginning', TRUE , g_proc);
5825: END IF;
5826:
5827: IF x_return_status IS NULL THEN
5828: x_msg_count := 0;

Line 5872: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: finishing', TRUE , g_proc);

5868: CLOSE struct_list;
5869: END IF;
5870:
5871: IF g_debug_mode = 'Y' THEN
5872: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: finishing', TRUE , g_proc);
5873: END IF;
5874:
5875: EXCEPTION
5876: WHEN OTHERS THEN

Line 5897: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: beginning', TRUE , g_proc);

5893: l_proj_type_count NUMBER;
5894: BEGIN
5895:
5896: IF g_debug_mode = 'Y' THEN
5897: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: beginning', TRUE , g_proc);
5898: END IF;
5899:
5900: IF x_return_status IS NULL THEN
5901: x_msg_count := 0;

Line 5934: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: finishing', TRUE , g_proc);

5930: x_ptc_flag := 'T';
5931: END IF;
5932:
5933: IF g_debug_mode = 'Y' THEN
5934: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: finishing', TRUE , g_proc);
5935: END IF;
5936:
5937: EXCEPTION
5938: WHEN OTHERS THEN

Line 5967: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: beginning', TRUE , g_proc);

5963:
5964: BEGIN
5965:
5966: IF g_debug_mode = 'Y' THEN
5967: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: beginning', TRUE , g_proc);
5968: END IF;
5969:
5970: IF x_return_status IS NULL THEN
5971: x_msg_count := 0;

Line 6030: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: finishing', TRUE , g_proc);

6026: x_msg_count,
6027: x_msg_data);
6028:
6029: IF g_debug_mode = 'Y' THEN
6030: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: finishing', TRUE , g_proc);
6031: END IF;
6032:
6033: EXCEPTION
6034: WHEN NO_DATA_FOUND THEN

Line 6062: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: beginning', TRUE , g_proc);

6058: l_project_currency_code VARCHAR2(15);
6059: BEGIN
6060:
6061: IF g_debug_mode = 'Y' THEN
6062: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: beginning', TRUE , g_proc);
6063: END IF;
6064:
6065: IF x_return_status IS NULL THEN
6066: x_msg_count := 0;

Line 6073: x_currency_code := Pji_Utils.get_global_primary_currency;

6069:
6070: x_currency_record_type := p_currency_record_type;
6071:
6072: IF p_currency_record_type = 1 THEN
6073: x_currency_code := Pji_Utils.get_global_primary_currency;
6074: x_currency_type := 'G';
6075: ELSIF p_currency_record_type = 2 THEN
6076: x_currency_type := 'G';
6077: x_currency_code := Pji_Utils.get_global_secondary_currency;

Line 6077: x_currency_code := Pji_Utils.get_global_secondary_currency;

6073: x_currency_code := Pji_Utils.get_global_primary_currency;
6074: x_currency_type := 'G';
6075: ELSIF p_currency_record_type = 2 THEN
6076: x_currency_type := 'G';
6077: x_currency_code := Pji_Utils.get_global_secondary_currency;
6078: ELSE
6079: SELECT projfunc_currency_code, project_currency_code
6080: INTO l_projfunc_currency_code,l_project_currency_code
6081: FROM pa_projects_all

Line 6094: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: finishing', TRUE , g_proc);

6090: END IF;
6091: END IF;
6092:
6093: IF g_debug_mode = 'Y' THEN
6094: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: finishing', TRUE , g_proc);
6095: END IF;
6096:
6097: EXCEPTION
6098: WHEN OTHERS THEN

Line 6117: Pji_Utils.WRITE2LOG( 'validate_plan_type: beginning', TRUE , g_proc);

6113: l_plan_type_count NUMBER;
6114: BEGIN
6115:
6116: IF g_debug_mode = 'Y' THEN
6117: Pji_Utils.WRITE2LOG( 'validate_plan_type: beginning', TRUE , g_proc);
6118: END IF;
6119:
6120: IF x_return_status IS NULL THEN
6121: x_msg_count := 0;

Line 6138: Pji_Utils.WRITE2LOG( 'validate_plan_type: finishing', TRUE , g_proc);

6134: x_plan_type_id := p_plan_type_id;
6135: END IF;
6136:
6137: IF g_debug_mode = 'Y' THEN
6138: Pji_Utils.WRITE2LOG( 'validate_plan_type: finishing', TRUE , g_proc);
6139: END IF;
6140:
6141: EXCEPTION
6142: WHEN OTHERS THEN

Line 6158: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: beginning', TRUE , g_proc);

6154: l_return_value VARCHAR2(1) := null;
6155: l_count NUMBER;
6156: BEGIN
6157: IF g_debug_mode = 'Y' THEN
6158: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: beginning', TRUE , g_proc);
6159: END IF;
6160:
6161: l_return_value := 'Y';
6162:

Line 6185: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: finishing', TRUE , g_proc);

6181: l_return_value := 'N';
6182: END IF;
6183:
6184: IF g_debug_mode = 'Y' THEN
6185: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: finishing', TRUE , g_proc);
6186: END IF;
6187:
6188: return(l_return_value);
6189: EXCEPTION

Line 6203: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Start', TRUE , g_proc);

6199: IS
6200: l_return_value VARCHAR2(255) := null;
6201: BEGIN
6202: IF g_debug_mode = 'Y' THEN
6203: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Start', TRUE , g_proc);
6204: END IF;
6205:
6206: IF p_project_type = 'CONTRACT' THEN
6207: SELECT ATTRIBUTE12 into l_return_value

Line 6221: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Finish', TRUE , g_proc);

6217: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6218: END IF;
6219:
6220: IF g_debug_mode = 'Y' THEN
6221: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Finish', TRUE , g_proc);
6222: END IF;
6223:
6224: return(l_return_value);
6225:

Line 6427: Pji_Utils.WRITE2LOG( 'derive_default_cbs_parameters: beginning', TRUE , g_proc);

6423: IS
6424: BEGIN
6425:
6426: IF G_DEBUG_MODE = 'Y' THEN
6427: Pji_Utils.WRITE2LOG( 'derive_default_cbs_parameters: beginning', TRUE , g_proc);
6428: END IF;
6429:
6430:
6431: IF x_return_status IS NULL THEN

Line 6454: Pji_Utils.WRITE2LOG( 'derive_default_cbs_parameters: finishing', TRUE , g_proc);

6450: RBS.RBS_VERSION_ID = X_CBS_VERSION_ID
6451: AND rbs.rbs_level = 1;
6452:
6453: IF G_DEBUG_MODE = 'Y' THEN
6454: Pji_Utils.WRITE2LOG( 'derive_default_cbs_parameters: finishing', TRUE , g_proc);
6455: END IF;
6456:
6457: EXCEPTION
6458: WHEN NO_DATA_FOUND THEN