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 87: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);

83: l_i NUMBER;
84: BEGIN
85:
86: IF g_debug_mode = 'Y' THEN
87: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);
88: END IF;
89: --Bug 5929145 Log events only for projects and not templates
90: -- Insert into event log for the project structure change of current project
91: FORALL l_i IN p_wbs_version_id_tbl.FIRST..p_wbs_version_id_tbl.LAST

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

162:
163: BEGIN
164:
165: IF g_debug_mode = 'Y' THEN
166: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: beginning', TRUE , g_proc);
167: END IF;
168:
169: IF x_return_status IS NULL THEN
170: x_msg_count := 0;

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

567: END IF;
568: END IF;
569:
570: IF g_debug_mode = 'Y' THEN
571: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: before getting percent', TRUE , g_proc);
572: END IF;
573:
574: COMMIT;
575:

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

573:
574: COMMIT;
575:
576: IF g_debug_mode = 'Y' THEN
577: Pji_Utils.WRITE2LOG( 'populate_wbs_hierachy_cache: finishing', TRUE , g_proc);
578: END IF;
579:
580: EXCEPTION
581: WHEN OTHERS THEN

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

598: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
599:
600: BEGIN
601: IF g_debug_mode = 'Y' THEN
602: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: beginning', TRUE , g_proc);
603: END IF;
604:
605: IF x_return_status IS NULL THEN
606: x_msg_count := 0;

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

657: (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);
658: END IF;
659:
660: IF g_debug_mode = 'Y' THEN
661: Pji_Utils.WRITE2LOG( 'Populate_WP_Plan_Vers_Cache: finishing', TRUE , g_proc);
662: END IF;
663:
664: EXCEPTION
665: WHEN OTHERS THEN

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

681: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
682: BEGIN
683:
684: IF g_debug_mode = 'Y' THEN
685: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: beginning', TRUE , g_proc);
686: END IF;
687:
688: IF x_return_status IS NULL THEN
689: x_msg_count := 0;

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

731: , x_msg_data);
732:
733:
734: IF g_debug_mode = 'Y' THEN
735: Pji_Utils.WRITE2LOG( 'derive_default_calendar_info: finishing', TRUE , g_proc);
736: END IF;
737:
738: EXCEPTION
739: WHEN OTHERS THEN

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

755: l_time_phase_same_flag VARCHAR2(80);
756: BEGIN
757:
758: IF g_debug_mode = 'Y' THEN
759: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: beginning', TRUE , g_proc);
760: END IF;
761:
762:
763: /* SELECT fin_plan_type_id

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

777: , x_msg_count
778: , x_msg_data);
779:
780: IF g_debug_mode = 'Y' THEN
781: Pji_Utils.WRITE2LOG( 'derive_wp_calendar_info: finishing', TRUE , g_proc);
782: END IF;
783:
784: EXCEPTION
785: WHEN NO_DATA_FOUND THEN

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

813: l_working_version_id NUMBER;
814: BEGIN
815:
816: IF g_debug_mode = 'Y' THEN
817: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: beginning', TRUE , g_proc);
818: END IF;
819:
820: IF x_return_status IS NULL THEN
821: x_msg_count := 0;

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

922: x_calendar_id := l_gl_calendar_id;
923: END IF;
924:
925: IF g_debug_mode = 'Y' THEN
926: Pji_Utils.WRITE2LOG( 'derive_vp_calendar_info: finishing', TRUE , g_proc);
927: END IF;
928:
929: EXCEPTION
930: WHEN NO_DATA_FOUND THEN

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

947: l_version_type pa_budget_versions.version_type%TYPE;
948: BEGIN
949:
950: IF g_debug_mode = 'Y' THEN
951: Pji_Utils.WRITE2LOG( 'get_version_type: beginning', TRUE , g_proc);
952: END IF;
953:
954: SELECT fin_plan_preference_code
955: INTO l_version_type

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

964: l_version_type := p_version_type;
965: END IF;
966:
967: IF g_debug_mode = 'Y' THEN
968: Pji_Utils.WRITE2LOG( 'get_version_type: returning', TRUE , g_proc);
969: END IF;
970:
971: RETURN l_version_type;
972:

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

1008: l_temp_holder2 NUMBER;
1009: BEGIN
1010:
1011: IF g_debug_mode = 'Y' THEN
1012: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);
1013: END IF;
1014:
1015:
1016: IF x_return_status IS NULL THEN

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

1217: x_orig_cstbudget2_version_id := g_orig_cstbudget2_version_id;
1218: x_orig_revbudget2_version_id := g_orig_revbudget2_version_id;
1219:
1220: IF g_debug_mode = 'Y' THEN
1221: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);
1222: END IF;
1223:
1224: EXCEPTION
1225: WHEN OTHERS THEN

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

1244:
1245: BEGIN
1246:
1247: IF g_debug_mode = 'Y' THEN
1248: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: beginning', TRUE , g_proc);
1249: END IF;
1250:
1251: IF x_return_status IS NULL THEN
1252: x_msg_count := 0;

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

1267: x_currency_type:='P';
1268: x_currency_code:=g_proj_currency_code;
1269:
1270: IF g_debug_mode = 'Y' THEN
1271: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);
1272: END IF;
1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN

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

1292:
1293: BEGIN
1294:
1295: IF g_debug_mode = 'Y' THEN
1296: Pji_Utils.WRITE2LOG( 'derive_perf_currency_info: beginning', TRUE , g_proc);
1297: END IF;
1298:
1299: IF x_return_status IS NULL THEN
1300: x_msg_count := 0;

Line 1307: x_currency_code:=Pji_Utils.get_global_primary_currency;

1303:
1304: /*--bug 5593229
1305: x_currency_record_type:=1;
1306: x_currency_type:='G';
1307: x_currency_code:=Pji_Utils.get_global_primary_currency;
1308: */
1309:
1310: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1311: x_currency_record_type:= 1;

Line 1313: x_currency_code:= Pji_Utils.get_global_primary_currency;

1309:
1310: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1311: x_currency_record_type:= 1;
1312: x_currency_type:= 'G';
1313: x_currency_code:= Pji_Utils.get_global_primary_currency;
1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1315: x_currency_record_type:= 2;
1316: x_currency_type:= 'G';
1317: x_currency_code:= Pji_Utils.get_global_secondary_currency;

Line 1317: x_currency_code:= Pji_Utils.get_global_secondary_currency;

1313: x_currency_code:= Pji_Utils.get_global_primary_currency;
1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1315: x_currency_record_type:= 2;
1316: x_currency_type:= 'G';
1317: x_currency_code:= Pji_Utils.get_global_secondary_currency;
1318: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'PROJ_CURRENCY') THEN
1319: x_currency_record_type:= 8;
1320: x_currency_type:= 'P';
1321: x_currency_code:= g_proj_currency_code;

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

1325: x_currency_code := g_projfunc_currency_code;
1326: END IF;
1327:
1328: IF g_debug_mode = 'Y' THEN
1329: Pji_Utils.WRITE2LOG( 'derive_default_currency_info: finishing', TRUE , g_proc);
1330: END IF;
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN

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

1346: l_factor_by_code VARCHAR2(30);
1347: BEGIN
1348:
1349: IF g_debug_mode = 'Y' THEN
1350: Pji_Utils.WRITE2LOG( 'derive_factorby: beginning', TRUE , g_proc);
1351: END IF;
1352:
1353: IF x_return_status IS NULL THEN
1354: x_msg_count := 0;

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

1377: l_factor_by_code:= 1;
1378: END IF;
1379:
1380: IF g_debug_mode = 'Y' THEN
1381: Pji_Utils.WRITE2LOG( 'derive_factorby: returning', TRUE , g_proc);
1382: END IF;
1383:
1384: RETURN l_factor_by_code;
1385: EXCEPTION

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

1399: l_msg_data VARCHAR2(2000);
1400: BEGIN
1401:
1402: IF g_debug_mode = 'Y' THEN
1403: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: beginning', TRUE , g_proc);
1404: END IF;
1405:
1406: -- IF p_project_id <> g_project_id THEN
1407: /*

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

1414:
1415: -- RETURN 'N'; --bug 4127656 temporarily turn off program reporting
1416:
1417: IF g_debug_mode = 'Y' THEN
1418: Pji_Utils.WRITE2LOG( 'derive_prg_rollup_flag: finishing', TRUE , g_proc);
1419: END IF;
1420:
1421: EXCEPTION
1422: WHEN OTHERS THEN

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

1437: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1438: BEGIN
1439:
1440: IF g_debug_mode = 'Y' THEN
1441: Pji_Utils.WRITE2LOG( 'derive_project_attributes: beginning', TRUE , g_proc);
1442: END IF;
1443:
1444: IF x_return_status IS NULL THEN
1445: x_msg_count := 0;

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

1482: /* AND NVL(info.org_id,-99) = NVL(prj.org_id,-99); -- Added NVL for bug 3989132 */
1483: AND info.org_id = prj.org_id; -- Removed NVL for Bug5376591
1484:
1485: IF g_debug_mode = 'Y' THEN
1486: Pji_Utils.WRITE2LOG( 'derive_project_attributes: finishing', TRUE , g_proc);
1487: END IF;
1488:
1489: -- END IF;
1490: EXCEPTION

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

1513: IS
1514: BEGIN
1515:
1516: IF g_debug_mode = 'Y' THEN
1517: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: beginning', TRUE , g_proc);
1518: END IF;
1519:
1520:
1521: IF x_return_status IS NULL THEN

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

1540: , x_msg_count
1541: , x_msg_data);
1542:
1543: IF g_debug_mode = 'Y' THEN
1544: Pji_Utils.WRITE2LOG( 'derive_default_rbs_parameters: finishing', TRUE , g_proc);
1545: END IF;
1546:
1547: EXCEPTION
1548: WHEN NO_DATA_FOUND THEN

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

1583: ORDER BY primary_reporting_rbs_flag DESC;
1584: BEGIN
1585:
1586: IF g_debug_mode = 'Y' THEN
1587: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: beginning', TRUE , g_proc);
1588: END IF;
1589:
1590: IF x_return_status IS NULL THEN
1591: x_msg_count := 0;

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

1614: , x_msg_count
1615: , x_msg_data);
1616:
1617: IF g_debug_mode = 'Y' THEN
1618: Pji_Utils.WRITE2LOG( 'derive_perf_rbs_parameters: finishing', TRUE , g_proc);
1619: END IF;
1620:
1621: EXCEPTION
1622: WHEN NO_DATA_FOUND THEN

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

1651:
1652: BEGIN
1653:
1654: IF g_debug_mode = 'Y' THEN
1655: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: beginning', TRUE , g_proc);
1656: END IF;
1657:
1658: IF x_return_status IS NULL THEN
1659: x_msg_count := 0;

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

1669:
1670: CLOSE c_rbs_elements; -- Bug#3877822
1671:
1672: IF g_debug_mode = 'Y' THEN
1673: Pji_Utils.WRITE2LOG( 'derive_default_rbs_element_id: finishing', TRUE , g_proc);
1674: END IF;
1675:
1676: EXCEPTION
1677: WHEN NO_DATA_FOUND THEN

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

1696: IS
1697: BEGIN
1698:
1699: IF g_debug_mode = 'Y' THEN
1700: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: beginning', TRUE , g_proc);
1701: END IF;
1702:
1703: IF x_return_status IS NULL THEN
1704: x_msg_count := 0;

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

1740: AND hdr.project_id = p_project_id
1741: AND hdr.plan_version_id = p_plan_version_id;
1742: */
1743: IF g_debug_mode = 'Y' THEN
1744: Pji_Utils.WRITE2LOG( 'derive_default_wbs_parameter: finishing', TRUE , g_proc);
1745: END IF;
1746:
1747: EXCEPTION
1748: WHEN OTHERS THEN

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

1769: ORDER BY NVL(Latest_eff_published_flag,'N') DESC, NVL(current_working_flag,'N') DESC;
1770: BEGIN
1771:
1772: IF g_debug_mode = 'Y' THEN
1773: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: beginning', TRUE , g_proc);
1774: END IF;
1775:
1776: IF x_return_status IS NULL THEN
1777: x_msg_count := 0;

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

1787:
1788: CLOSE c_wbs_params; --bug#3877822
1789:
1790: IF g_debug_mode = 'Y' THEN
1791: Pji_Utils.WRITE2LOG( 'derive_wp_wbs_parameter: finishing', TRUE , g_proc);
1792: END IF;
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN

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

1824:
1825: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
1826: IF g_debug_mode = 'Y' THEN
1827: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
1828: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
1829: END IF;
1830:
1831: IF x_return_status IS NULL THEN
1832: x_msg_count := 0;

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

1918:
1919: END IF;
1920:
1921: IF g_debug_mode = 'Y' THEN
1922: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
1923: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
1924: END IF;
1925: Pa_Debug.Reset_Err_Stack;
1926:

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

1958: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1959: END IF;
1960:
1961: IF g_debug_mode = 'Y' THEN
1962: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: begining', TRUE , g_proc);
1963: END IF;
1964:
1965: SELECT pt.plan_class_code
1966: , pt.NAME

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

1993: x_budget_forecast_flag := 'F';
1994: END IF;
1995:
1996: IF g_debug_mode = 'Y' THEN
1997: Pji_Utils.WRITE2LOG( 'derive_plan_type_parameters: finishing', TRUE , g_proc);
1998: END IF;
1999:
2000: EXCEPTION
2001: WHEN NO_DATA_FOUND THEN

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

2025: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2026: END IF;
2027:
2028: IF g_debug_mode = 'Y' THEN
2029: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: begining', TRUE , g_proc);
2030: END IF;
2031:
2032: SELECT op.MARGIN_DERIVED_FROM_CODE
2033: INTO x_plan_margin_mask

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

2036: AND op.fin_plan_option_level_code = 'PLAN_VERSION'
2037: AND op.project_id = p_project_id;
2038:
2039: IF g_debug_mode = 'Y' THEN
2040: Pji_Utils.WRITE2LOG( 'derive_version_margin_mask: finishing', TRUE , g_proc);
2041: END IF;
2042: EXCEPTION
2043: WHEN NO_DATA_FOUND THEN
2044: x_msg_count := x_msg_count + 1;

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

2064: IS
2065: BEGIN
2066:
2067: IF g_debug_mode = 'Y' THEN
2068: Pji_Utils.WRITE2LOG( 'derive_version_parameters: begining', TRUE , g_proc);
2069: END IF;
2070:
2071: IF x_return_status IS NULL THEN
2072: x_msg_count := 0;

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

2078: FROM pa_budget_versions
2079: WHERE budget_version_id = p_version_id;
2080:
2081: IF g_debug_mode = 'Y' THEN
2082: Pji_Utils.WRITE2LOG( 'derive_version_parameters: finishing', TRUE , g_proc);
2083: END IF;
2084:
2085: EXCEPTION
2086: WHEN NO_DATA_FOUND THEN

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

2110: BEGIN
2111:
2112:
2113: IF g_debug_mode = 'Y' THEN
2114: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: begining', TRUE , g_proc);
2115: END IF;
2116:
2117: IF x_return_status IS NULL THEN
2118: x_msg_count := 0;

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

2152: x_prior_fcst_version_id := -99;
2153: END IF;
2154:
2155: IF g_debug_mode = 'Y' THEN
2156: Pji_Utils.WRITE2LOG( 'derive_fin_plan_versions: finishing', TRUE , g_proc);
2157: END IF;
2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN

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

2180: l_msg_data VARCHAR2(1000);
2181: BEGIN
2182:
2183: IF g_debug_mode = 'Y' THEN
2184: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: begining', TRUE , g_proc);
2185: END IF;
2186:
2187: IF x_return_status IS NULL THEN
2188: x_msg_count := 0;

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

2218: x_published_version_id := -99;
2219: END IF;
2220:
2221: IF g_debug_mode = 'Y' THEN
2222: Pji_Utils.WRITE2LOG( 'derive_work_plan_versions: finishing', TRUE , g_proc);
2223: END IF;
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN

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

2242:
2243: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2244: IF g_debug_mode = 'Y' THEN
2245: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2246: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2247: END IF;
2248:
2249: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN
2250: Derive_Period_Julian(p_calendar_type

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

2258: -- END IF;
2259: RETURN g_report_date_julian;
2260:
2261: IF g_debug_mode = 'Y' THEN
2262: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2263: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2264: END IF;
2265: Pa_Debug.Reset_Err_Stack;
2266:

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

2282:
2283: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2284: IF g_debug_mode = 'Y' THEN
2285: Pa_Debug.write_file('Get_Period_Name: begining',5);
2286: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2287: END IF;
2288:
2289: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN
2290: Derive_Period_Julian(p_calendar_type

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

2297: g_input_calendar_id := p_calendar_id;
2298: -- END IF;
2299:
2300: IF g_debug_mode = 'Y' THEN
2301: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2302: Pa_Debug.write_file('Get_Period_Name: returning',5);
2303: END IF;
2304: Pa_Debug.Reset_Err_Stack;
2305:

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

2339: BEGIN
2340: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2341: IF g_debug_mode = 'Y' THEN
2342: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2343: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2344: END IF;
2345:
2346: IF p_calendar_type = 'E' THEN
2347: x_calendar_id := -1;

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

2541:
2542:
2543:
2544: IF g_debug_mode = 'Y' THEN
2545: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2546: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2547: END IF;
2548: Pa_Debug.Reset_Err_Stack;
2549:

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

2568: l_struct_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
2569: BEGIN
2570:
2571: IF g_debug_mode = 'Y' THEN
2572: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: begining', TRUE , g_proc);
2573: END IF;
2574:
2575: l_struct_sharing_code := Pa_Project_Structure_Utils.get_Structure_sharing_code(
2576: p_project_id=> p_project_id );

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

2579: -- SPLIT_NO_MAPPING
2580: -- SPLILT_MAPPING
2581:
2582: IF g_debug_mode = 'Y' THEN
2583: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: returning', TRUE , g_proc);
2584: END IF;
2585:
2586: IF (l_struct_sharing_code = 'SPLIT_NO_MAPPING' OR l_struct_sharing_code = 'SPLILT_MAPPING') THEN
2587: RETURN -2;

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

2633:
2634: BEGIN
2635: -- ----------------------------------------------
2636: IF g_debug_mode = 'Y' THEN
2637: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);
2638: END IF;
2639:
2640: -- check if pji_org_extr_info table has a record for p_org_id
2641: -- Count funtion is introduced

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

2711:
2712: COMMIT;
2713:
2714: IF g_debug_mode = 'Y' THEN
2715: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: finishing', TRUE , g_proc);
2716: END IF;
2717:
2718:
2719: END update_curr_rep_periods;

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

2748: BEGIN
2749:
2750:
2751: IF g_debug_mode = 'Y' THEN
2752: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: begining', TRUE , g_proc);
2753: END IF;
2754:
2755: x_msg_count := 0;
2756: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

2988:
2989: END IF;
2990:
2991: IF g_debug_mode = 'Y' THEN
2992: Pji_Utils.WRITE2LOG( 'get_project_home_default_parameters: finishing', TRUE , g_proc);
2993: END IF;
2994:
2995:
2996: EXCEPTION

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

3025:
3026: BEGIN
3027:
3028: IF g_debug_mode = 'Y' THEN
3029: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: begining', TRUE , g_proc);
3030: END IF;
3031:
3032: IF x_return_status IS NULL THEN
3033: x_msg_count := 0;

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

3044:
3045: CLOSE c_dates;--bug#3877822
3046:
3047: IF g_debug_mode = 'Y' THEN
3048: Pji_Utils.WRITE2LOG( 'Derive_WP_Period: finishing', TRUE , g_proc);
3049: END IF;
3050:
3051: EXCEPTION
3052: WHEN NO_DATA_FOUND THEN

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

3070: IS
3071: BEGIN
3072:
3073: IF g_debug_mode = 'Y' THEN
3074: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: begining', TRUE , g_proc);
3075: END IF;
3076:
3077: IF x_return_status IS NULL THEN
3078: x_msg_count := 0;

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

3087: );
3088:
3089:
3090: IF g_debug_mode = 'Y' THEN
3091: Pji_Utils.WRITE2LOG( 'Derive_VP_Period: finishing', TRUE , g_proc);
3092: END IF;
3093:
3094: EXCEPTION
3095: WHEN NO_DATA_FOUND THEN

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

3113: IS
3114: BEGIN
3115:
3116: IF g_debug_mode = 'Y' THEN
3117: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: begining', TRUE , g_proc);
3118: END IF;
3119:
3120: IF x_return_status IS NULL THEN
3121: x_msg_count := 0;

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

3129: , x_to_period
3130: );
3131:
3132: IF g_debug_mode = 'Y' THEN
3133: Pji_Utils.WRITE2LOG( 'Derive_Perf_Period: finishing', TRUE , g_proc);
3134: END IF;
3135:
3136: EXCEPTION
3137: WHEN NO_DATA_FOUND THEN

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

3156:
3157: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3158: IF g_debug_mode = 'Y' THEN
3159: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3160: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3161: END IF;
3162:
3163: Derive_Slice_Name(p_project_id,
3164: p_calendar_id,

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

3168: l_msg_data);
3169:
3170:
3171: IF g_debug_mode = 'Y' THEN
3172: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3173: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3174: END IF;
3175: Pa_Debug.Reset_Err_Stack;
3176:

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

3201: l_plan_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3202: j NUMBER := 0;
3203: BEGIN
3204: IF g_debug_mode = 'Y' THEN
3205: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: begining', TRUE , g_proc);
3206: END IF;
3207:
3208: -- Checking if project id is null or p_plan_version_ids's table is null then exiting smoothly
3209: IF ( p_project_id IS NULL OR p_plan_version_ids.COUNT <= 0 ) THEN

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

3207:
3208: -- Checking if project id is null or p_plan_version_ids's table is null then exiting smoothly
3209: IF ( p_project_id IS NULL OR p_plan_version_ids.COUNT <= 0 ) THEN
3210: IF g_debug_mode = 'Y' THEN
3211: Pji_Utils.WRITE2LOG( 'Exiting from Get_Default_Period_Dates: no Project or Plan version id found', TRUE , g_proc);
3212: END IF;
3213:
3214: RETURN;
3215: END IF;

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

3223: j := j + 1;
3224: l_plan_version_ids(j) := p_plan_version_ids(i);
3225:
3226: IF g_debug_mode = 'Y' THEN
3227: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: inside pa_resource_assignments table', TRUE , g_proc);
3228: END IF;
3229: END IF;
3230: END LOOP;
3231:

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

3249: l_plan_version_ids(9),l_plan_version_ids(10),l_plan_version_ids(11),l_plan_version_ids(12),
3250: 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) );
3251:
3252: IF g_debug_mode = 'Y' THEN
3253: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Done selecting pa_resource_assignments table', TRUE , g_proc);
3254: END IF;
3255: EXCEPTION
3256: WHEN NO_DATA_FOUND THEN
3257: l_min_date := NULL;

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

3256: WHEN NO_DATA_FOUND THEN
3257: l_min_date := NULL;
3258: l_max_date := NULL;
3259: IF g_debug_mode = 'Y' THEN
3260: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: No data found in pa_resource_assignments table', TRUE , g_proc);
3261: END IF;
3262: END;
3263: END IF;
3264:

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

3265: x_min_julian_date := TO_CHAR(l_min_date,'j');
3266: x_max_julian_date := TO_CHAR(l_max_date,'j');
3267:
3268: IF g_debug_mode = 'Y' THEN
3269: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: Leaving ', TRUE , g_proc);
3270: END IF;
3271:
3272: EXCEPTION
3273: WHEN OTHERS THEN

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

3273: WHEN OTHERS THEN
3274: x_min_julian_date := NULL;
3275: x_max_julian_date := NULL;
3276: IF g_debug_mode = 'Y' THEN
3277: Pji_Utils.WRITE2LOG( 'Get_Default_Period_Dates: When others ', TRUE , g_proc);
3278: END IF;
3279: NULL;
3280:
3281: END Get_Default_Period_Dates;

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

3290: IS
3291: BEGIN
3292:
3293: IF g_debug_mode = 'Y' THEN
3294: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: begining', TRUE , g_proc);
3295: END IF;
3296:
3297: IF x_return_status IS NULL THEN
3298: x_msg_count := 0;

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

3310: AND p.org_id = t.org_id ; -- Removed NVL for Bug 5376591
3311:
3312:
3313: IF g_debug_mode = 'Y' THEN
3314: Pji_Utils.WRITE2LOG( 'Derive_Project_Type: finishing', TRUE , g_proc);
3315: END IF;
3316:
3317: EXCEPTION
3318: WHEN NO_DATA_FOUND THEN

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

3344: l_report_date DATE := NULL;
3345: BEGIN
3346:
3347: IF g_debug_mode = 'Y' THEN
3348: Pji_Utils.WRITE2LOG( 'Derive_Percent_Complete: begining', TRUE , g_proc);
3349: END IF;
3350:
3351: IF x_return_status IS NULL THEN
3352: x_msg_count := 0;

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

3388: ,p_as_of_date =>l_report_date
3389: ,p_program_flag => p_prg_flag);
3390: END IF;
3391: IF g_debug_mode = 'Y' THEN
3392: Pji_Utils.WRITE2LOG( 'Derive_Complete_Percent: finishing', TRUE , g_proc);
3393: END IF;
3394:
3395: EXCEPTION
3396: WHEN NO_DATA_FOUND THEN

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

3415: l_project_org NUMBER(15);
3416: BEGIN
3417:
3418: IF g_debug_mode = 'Y' THEN
3419: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: begining', TRUE , g_proc);
3420: END IF;
3421:
3422: IF x_return_status IS NULL THEN
3423: x_msg_count := 0;

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

3440: x_cross_org_flag := 'T';
3441: END IF;
3442:
3443: IF g_debug_mode = 'Y' THEN
3444: Pji_Utils.WRITE2LOG( 'Check_Cross_Org: finishing', TRUE , g_proc);
3445: END IF;
3446:
3447: EXCEPTION
3448: WHEN NO_DATA_FOUND THEN

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

4232: l_rev_bgt_plan_type_id NUMBER := NULL;
4233:
4234: BEGIN
4235: IF g_debug_mode = 'Y' THEN
4236: Pji_Utils.WRITE2LOG( 'Get_Plan_Types_Id: beginning', TRUE , g_proc);
4237: END IF;
4238:
4239:
4240: IF x_return_status IS NULL THEN

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

4341: l_tmp_orig_revforecast_ver_id NUMBER;
4342: BEGIN
4343:
4344: IF g_debug_mode = 'Y' THEN
4345: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: beginning', TRUE , g_proc);
4346: END IF;
4347:
4348:
4349: IF x_return_status IS NULL THEN

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

4686:
4687: Fnd_Msg_Pub.Initialize;
4688:
4689: IF g_debug_mode = 'Y' THEN
4690: Pji_Utils.WRITE2LOG( 'derive_default_plan_versions: finishing', TRUE , g_proc);
4691: END IF;
4692:
4693: EXCEPTION
4694: WHEN OTHERS THEN

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

4954: l_IsSmartSliceCreated_Flag := 'Y';
4955:
4956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4957: IF g_debug_mode = 'Y' THEN
4958: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: begining', TRUE , g_proc);
4959: END IF;
4960:
4961: -- Checking if RBS version id is null or p_plan_version_ids's table is null then exiting smoothly
4962: IF ( p_rbs_version_id IS NULL OR p_plan_version_id_tbl.COUNT <= 0 ) THEN

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

4960:
4961: -- Checking if RBS version id is null or p_plan_version_ids's table is null then exiting smoothly
4962: IF ( p_rbs_version_id IS NULL OR p_plan_version_id_tbl.COUNT <= 0 ) THEN
4963: IF g_debug_mode = 'Y' THEN
4964: Pji_Utils.WRITE2LOG( 'Exiting from Is_Smart_Slice_Created: no RBS or Plan version id found', TRUE , g_proc);
4965: END IF;
4966:
4967: RETURN;
4968: END IF;

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

4980: IF ( NOT l_found ) THEN
4981: l_plan_version_id_tbl(l_plan_version_id_tbl.COUNT) := p_plan_version_id_tbl(i);
4982: l_plan_version_id_tbl.EXTEND;
4983: IF g_debug_mode = 'Y' THEN
4984: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: inside assignment', TRUE , g_proc);
4985: END IF;
4986: END IF;
4987: END IF;
4988: END LOOP;

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

5001: l_project_id_tbl(i) := p_project_id;
5002: END LOOP;
5003:
5004: IF ( g_debug_mode = 'Y') THEN
5005: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with logic', TRUE , g_proc);
5006: END IF;
5007:
5008: /* Program case */
5009: IF (NVL(p_prg_rollup_flag,'N') = 'Y') THEN

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

5008: /* Program case */
5009: IF (NVL(p_prg_rollup_flag,'N') = 'Y') THEN
5010:
5011: IF g_debug_mode = 'Y' THEN
5012: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Entering into Program logic', TRUE , g_proc);
5013: END IF;
5014:
5015: BEGIN
5016: SELECT project_id

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

5024: NULL;
5025: END;
5026:
5027: IF (g_debug_mode = 'Y') THEN
5028: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with Project Select', TRUE , g_proc);
5029: END IF;
5030:
5031: BEGIN
5032: SELECT DISTINCT head.wbs_version_id BULK COLLECT

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

5042: EXCEPTION
5043: WHEN NO_DATA_FOUND THEN
5044: NULL;
5045: IF g_debug_mode = 'Y' THEN
5046: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in wbs_version_id Select', TRUE , g_proc);
5047: END IF;
5048: END;
5049:
5050: IF g_debug_mode = 'Y' THEN

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

5047: END IF;
5048: END;
5049:
5050: IF g_debug_mode = 'Y' THEN
5051: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with wbs_version_id Select', TRUE , g_proc);
5052: END IF;
5053:
5054: BEGIN
5055: SELECT DISTINCT NVL(head.plan_type_id,-1) BULK COLLECT

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

5065: EXCEPTION
5066: WHEN NO_DATA_FOUND THEN
5067: NULL;
5068: IF g_debug_mode = 'Y' THEN
5069: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in plan_type_id Select', TRUE , g_proc);
5070: END IF;
5071: END;
5072:
5073: IF g_debug_mode = 'Y' THEN

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

5070: END IF;
5071: END;
5072:
5073: IF g_debug_mode = 'Y' THEN
5074: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with plan_type_id Select', TRUE , g_proc);
5075: END IF;
5076:
5077: FOR i IN 1..17 LOOP
5078: IF ( l_get_wbs_version_id_tbl.EXISTS(i)) THEN

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

5092: END IF;
5093: END LOOP;
5094:
5095: IF g_debug_mode = 'Y' THEN
5096: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before deleting project tem table and plan version temp table', TRUE , g_proc);
5097: END IF;
5098:
5099: l_plan_version_id_tbl.DELETE;
5100: l_project_id_tbl.DELETE;

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

5099: l_plan_version_id_tbl.DELETE;
5100: l_project_id_tbl.DELETE;
5101:
5102: IF g_debug_mode = 'Y' THEN
5103: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Before selecting plan version,project,wbs', TRUE , g_proc);
5104: END IF;
5105:
5106: BEGIN
5107: SELECT DISTINCT head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id BULK COLLECT

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

5130: EXCEPTION
5131: WHEN OTHERS THEN
5132: NULL;
5133: IF g_debug_mode = 'Y' THEN
5134: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found in selecting plan version,project,wbs', TRUE , g_proc);
5135: END IF;
5136: END;
5137:
5138: IF g_debug_mode = 'Y' THEN

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

5135: END IF;
5136: END;
5137:
5138: IF g_debug_mode = 'Y' THEN
5139: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with selecting plan version,project,wbs', TRUE , g_proc);
5140: END IF;
5141:
5142: END IF; -- Program Case
5143:

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

5141:
5142: END IF; -- Program Case
5143:
5144: IF g_debug_mode = 'Y' THEN
5145: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Done with program logic and checking status table', TRUE , g_proc);
5146: END IF;
5147:
5148:
5149: FOR i IN 1..l_plan_version_id_tbl.COUNT LOOP

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

5163: WHEN NO_DATA_FOUND THEN
5164: x_Smart_Slice_Flag := 'Y';
5165: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5166: IF ( g_debug_mode = 'Y' ) THEN
5167: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: No data found ', TRUE , g_proc);
5168: END IF;
5169: END;
5170:
5171: IF ( g_debug_mode = 'Y') THEN

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

5168: END IF;
5169: END;
5170:
5171: IF ( g_debug_mode = 'Y') THEN
5172: Pji_Utils.WRITE2LOG( 'Is_Smart_Slice_Created: Coming out as one of the version does not hace smart slice', TRUE , g_proc);
5173: END IF;
5174:
5175: -- If smart slice does not exist mark to create the same
5176: IF ( l_exists = 'N' ) THEN

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

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

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

5224: l_R_PlanVers_HavSame_RBS_Flag := 'Y';
5225:
5226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5227: IF g_debug_mode = 'Y' THEN
5228: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: begining', TRUE , g_proc);
5229: END IF;
5230:
5231: -- Checking if p_plan_version_ids's table is null then exiting smoothly
5232: IF ( p_fin_plan_version_id_tbl.COUNT <= 0 ) THEN

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

5230:
5231: -- Checking if p_plan_version_ids's table is null then exiting smoothly
5232: IF ( p_fin_plan_version_id_tbl.COUNT <= 0 ) THEN
5233: IF g_debug_mode = 'Y' THEN
5234: Pji_Utils.WRITE2LOG( 'Exiting from Chk_plan_vers_have_same_RBS: No Plan version id found', TRUE , g_proc);
5235: END IF;
5236:
5237: RETURN;
5238: END IF;

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

5245: j := j + 1;
5246: l_fin_plan_version_ids(j) := p_fin_plan_version_id_tbl(i);
5247:
5248: IF g_debug_mode = 'Y' THEN
5249: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: inside assignment', TRUE , g_proc);
5250: END IF;
5251: END IF;
5252: END LOOP;
5253:

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

5269: 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),
5270: l_fin_plan_version_ids(5),l_fin_plan_version_ids(6),l_fin_plan_version_ids(7),l_fin_plan_version_ids(8));
5271:
5272: IF g_debug_mode = 'Y' THEN
5273: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);
5274: END IF;
5275:
5276: IF ( l_R_PlanVers_HavSame_RBS_Flag = 'Y') THEN
5277: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;

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

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

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

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

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

5336:
5337: BEGIN
5338:
5339: IF g_debug_mode = 'Y' THEN
5340: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: beginning', TRUE , g_proc);
5341: END IF;
5342:
5343: IF x_return_status IS NULL THEN
5344: x_msg_count := 0;

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

5384: CLOSE struct_list;
5385: END IF;
5386:
5387: IF g_debug_mode = 'Y' THEN
5388: Pji_Utils.WRITE2LOG( 'Get_Process_Status_Msg: finishing', TRUE , g_proc);
5389: END IF;
5390:
5391: EXCEPTION
5392: WHEN OTHERS THEN

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

5409: l_proj_type_count NUMBER;
5410: BEGIN
5411:
5412: IF g_debug_mode = 'Y' THEN
5413: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: beginning', TRUE , g_proc);
5414: END IF;
5415:
5416: IF x_return_status IS NULL THEN
5417: x_msg_count := 0;

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

5446: x_ptc_flag := 'T';
5447: END IF;
5448:
5449: IF g_debug_mode = 'Y' THEN
5450: Pji_Utils.WRITE2LOG( 'Check_Proj_Type_Consistency: finishing', TRUE , g_proc);
5451: END IF;
5452:
5453: EXCEPTION
5454: WHEN OTHERS THEN

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

5479:
5480: BEGIN
5481:
5482: IF g_debug_mode = 'Y' THEN
5483: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: beginning', TRUE , g_proc);
5484: END IF;
5485:
5486: IF x_return_status IS NULL THEN
5487: x_msg_count := 0;

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

5542: x_msg_count,
5543: x_msg_data);
5544:
5545: IF g_debug_mode = 'Y' THEN
5546: Pji_Utils.WRITE2LOG( 'derive_pji_calendar_info: finishing', TRUE , g_proc);
5547: END IF;
5548:
5549: EXCEPTION
5550: WHEN NO_DATA_FOUND THEN

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

5574: l_project_currency_code VARCHAR2(15);
5575: BEGIN
5576:
5577: IF g_debug_mode = 'Y' THEN
5578: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: beginning', TRUE , g_proc);
5579: END IF;
5580:
5581: IF x_return_status IS NULL THEN
5582: x_msg_count := 0;

Line 5589: x_currency_code := Pji_Utils.get_global_primary_currency;

5585:
5586: x_currency_record_type := p_currency_record_type;
5587:
5588: IF p_currency_record_type = 1 THEN
5589: x_currency_code := Pji_Utils.get_global_primary_currency;
5590: x_currency_type := 'G';
5591: ELSIF p_currency_record_type = 2 THEN
5592: x_currency_type := 'G';
5593: x_currency_code := Pji_Utils.get_global_secondary_currency;

Line 5593: x_currency_code := Pji_Utils.get_global_secondary_currency;

5589: x_currency_code := Pji_Utils.get_global_primary_currency;
5590: x_currency_type := 'G';
5591: ELSIF p_currency_record_type = 2 THEN
5592: x_currency_type := 'G';
5593: x_currency_code := Pji_Utils.get_global_secondary_currency;
5594: ELSE
5595: SELECT projfunc_currency_code, project_currency_code
5596: INTO l_projfunc_currency_code,l_project_currency_code
5597: FROM pa_projects_all

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

5606: END IF;
5607: END IF;
5608:
5609: IF g_debug_mode = 'Y' THEN
5610: Pji_Utils.WRITE2LOG( 'derive_pji_currency_info: finishing', TRUE , g_proc);
5611: END IF;
5612:
5613: EXCEPTION
5614: WHEN OTHERS THEN

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

5629: l_plan_type_count NUMBER;
5630: BEGIN
5631:
5632: IF g_debug_mode = 'Y' THEN
5633: Pji_Utils.WRITE2LOG( 'validate_plan_type: beginning', TRUE , g_proc);
5634: END IF;
5635:
5636: IF x_return_status IS NULL THEN
5637: x_msg_count := 0;

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

5650: x_plan_type_id := p_plan_type_id;
5651: END IF;
5652:
5653: IF g_debug_mode = 'Y' THEN
5654: Pji_Utils.WRITE2LOG( 'validate_plan_type: finishing', TRUE , g_proc);
5655: END IF;
5656:
5657: EXCEPTION
5658: WHEN OTHERS THEN

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

5670: l_return_value VARCHAR2(1) := null;
5671: l_count NUMBER;
5672: BEGIN
5673: IF g_debug_mode = 'Y' THEN
5674: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: beginning', TRUE , g_proc);
5675: END IF;
5676:
5677: l_return_value := 'Y';
5678:

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

5697: l_return_value := 'N';
5698: END IF;
5699:
5700: IF g_debug_mode = 'Y' THEN
5701: Pji_Utils.WRITE2LOG( 'is_str_linked_to_working_ver: finishing', TRUE , g_proc);
5702: END IF;
5703:
5704: return(l_return_value);
5705: EXCEPTION

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

5715: IS
5716: l_return_value VARCHAR2(255) := null;
5717: BEGIN
5718: IF g_debug_mode = 'Y' THEN
5719: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Start', TRUE , g_proc);
5720: END IF;
5721:
5722: IF p_project_type = 'CONTRACT' THEN
5723: SELECT ATTRIBUTE12 into l_return_value

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

5733: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5734: END IF;
5735:
5736: IF g_debug_mode = 'Y' THEN
5737: Pji_Utils.WRITE2LOG( 'Get_Page_Pers_Function_Name : Finish', TRUE , g_proc);
5738: END IF;
5739:
5740: return(l_return_value);
5741: