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_REP_UTIL

Line 1: PACKAGE BODY Pji_Rep_Util AS

1: PACKAGE BODY Pji_Rep_Util AS
2: /* $Header: PJIRX07B.pls 120.42.12010000.4 2008/11/28 07:34:32 rballamu ship $ */
3:
4: g_project_id NUMBER:=-1;
5: g_pa_calendar_type VARCHAR2(1):='P';

Line 79: Fnd_Message.set_token('PROC_NAME','Pji_Rep_Util.Add_Message');

75: Fnd_Msg_Pub.add_detail(p_message_type=>p_msg_type);
76: EXCEPTION
77: WHEN OTHERS THEN
78: Fnd_Message.set_name('PJI','PJI_REP_GENERIC_MSG');
79: Fnd_Message.set_token('PROC_NAME','Pji_Rep_Util.Add_Message');
80: END Add_Message;
81:
82: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS
83: l_i NUMBER;

Line 130: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Log_Struct_Change_Event');

126: );
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Log_Struct_Change_Event');
131: RAISE;
132: END;
133:
134:

Line 584: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Populate_WBS_Hierarchy_Cache');

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

Line 668: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');

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

Line 742: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');

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

Line 788: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WP CALENDAR');

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

Line 792: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Calendar_Info');

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

Line 932: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;

928:
929: EXCEPTION
930: WHEN NO_DATA_FOUND THEN
931: x_msg_count := x_msg_count + 1;
932: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
933: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
934: WHEN OTHERS THEN
935: x_msg_count := x_msg_count + 1;
936: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 933: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');

929: EXCEPTION
930: WHEN NO_DATA_FOUND THEN
931: x_msg_count := x_msg_count + 1;
932: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
933: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
934: WHEN OTHERS THEN
935: x_msg_count := x_msg_count + 1;
936: x_return_status := Fnd_Api.G_RET_STS_ERROR;
937: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Vp_Calendar_Info');

Line 937: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Vp_Calendar_Info');

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

Line 975: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VERSION TYPE');

971: RETURN l_version_type;
972:
973: EXCEPTION
974: WHEN OTHERS THEN
975: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VERSION TYPE');
976: RETURN NULL;
977: END Get_Version_Type;
978:
979: /*

Line 1228: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Plan_Versions');

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

Line 1278: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');

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

Line 1336: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');

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

Line 1391: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_FactorBy');

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

Line 1423: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_prg_rollup_flag');

1419: END IF;
1420:
1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_prg_rollup_flag');
1424: RETURN NULL;
1425: END Derive_Prg_Rollup_Flag;
1426:
1427: FUNCTION Derive_Perf_Prg_Rollup_Flag(

Line 1494: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PROJ ATTRIBUTES');

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

Line 1498: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Attributes');

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

Line 1552: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1548: WHEN NO_DATA_FOUND THEN
1549: x_rbs_version_id := -99;
1550: x_rbs_element_id := -99;
1551: /* x_msg_count := x_msg_count + 1;
1552: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1554: */ WHEN OTHERS THEN
1555: x_msg_count := x_msg_count + 1;
1556: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);

1549: x_rbs_version_id := -99;
1550: x_rbs_element_id := -99;
1551: /* x_msg_count := x_msg_count + 1;
1552: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1554: */ WHEN OTHERS THEN
1555: x_msg_count := x_msg_count + 1;
1556: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1557: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Parameters');

Line 1557: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Parameters');

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

Line 1626: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1622: WHEN NO_DATA_FOUND THEN
1623: x_rbs_version_id := -99;
1624: x_rbs_element_id := -99;
1625: /* x_msg_count := x_msg_count + 1;
1626: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1627: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1628: */ WHEN OTHERS THEN
1629: x_msg_count := x_msg_count + 1;
1630: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1627: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);

1623: x_rbs_version_id := -99;
1624: x_rbs_element_id := -99;
1625: /* x_msg_count := x_msg_count + 1;
1626: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1627: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1628: */ WHEN OTHERS THEN
1629: x_msg_count := x_msg_count + 1;
1630: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1631: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_RBS_Parameters');

Line 1631: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_RBS_Parameters');

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

Line 1679: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1675:
1676: EXCEPTION
1677: WHEN NO_DATA_FOUND THEN
1678: x_msg_count := x_msg_count + 1;
1679: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1680: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');
1681: WHEN OTHERS THEN
1682: x_msg_count := x_msg_count + 1;
1683: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1680: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');

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

Line 1684: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Element_Id');

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

Line 1729: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1725: WHERE elm.element_version_id = x_wbs_version_id;
1726: EXCEPTION
1727: WHEN NO_DATA_FOUND THEN
1728: x_msg_count := x_msg_count + 1;
1729: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1730: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WBS ELEMENT');
1731: END;
1732:
1733: /* SELECT hdr.wbs_version_id,elm.proj_element_id

Line 1730: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WBS ELEMENT');

1726: EXCEPTION
1727: WHEN NO_DATA_FOUND THEN
1728: x_msg_count := x_msg_count + 1;
1729: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1730: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WBS ELEMENT');
1731: END;
1732:
1733: /* SELECT hdr.wbs_version_id,elm.proj_element_id
1734: INTO x_wbs_version_id, x_wbs_element_id

Line 1751: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_WBS_Parameters');

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

Line 1798: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_WBS_Parameters');

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

Line 1825: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');

1821: l_end_date DATE;
1822: l_rec_count NUMBER;
1823: BEGIN
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;

Line 1931: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'SLICE NAME');

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

Line 1935: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Slice_Name');

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

Line 2004: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN TYPE PARAMETERS');

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

Line 2008: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Plan_Type_Parameters');

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

Line 2046: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN VERSION MARGIN MASK');

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

Line 2051: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Margin_Mask');

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

Line 2089: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NO_PLAN_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);

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

Line 2093: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Parameters');

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

Line 2163: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Fin_Plan_Versions');

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

Line 2229: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Work_Plan_Versions');

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

Line 2243: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');

2239: l_msg_count NUMBER;
2240: l_msg_data VARCHAR2(2000);
2241: BEGIN
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;

Line 2269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Report_Date_Julian');

2265: Pa_Debug.Reset_Err_Stack;
2266:
2267: EXCEPTION
2268: WHEN OTHERS THEN
2269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Report_Date_Julian');
2270: RETURN 1;
2271: END Get_Report_Date_Julian;
2272:
2273:

Line 2283: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');

2279: l_msg_count NUMBER;
2280: l_msg_data VARCHAR2(2000);
2281: BEGIN
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;

Line 2310: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Name');

2306: RETURN g_period_name;
2307:
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Name');
2311: RETURN NULL;
2312: END Get_Period_Name;
2313:
2314: */

Line 2340: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');

2336: l_period_name VARCHAR2(100);
2337: l_gl_calendar_id NUMBER;
2338: l_pa_calendar_id NUMBER;
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;

Line 2387: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

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

Line 2411: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

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

Line 2427: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

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

Line 2555: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');

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

Line 2560: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Julian');

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

Line 3000: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.get_project_home_default_param');

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

Line 3058: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Period');

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

Line 3101: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_VP_Period');

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

Line 3143: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_Period');

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

Line 3157: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');

3153: l_msg_count NUMBER;
3154: l_msg_data VARCHAR2(2000);
3155: BEGIN
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;

Line 3181: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Name');

3177: RETURN l_slice_name;
3178:
3179: EXCEPTION
3180: WHEN OTHERS THEN
3181: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Name');
3182: RETURN NULL;
3183: END Get_Slice_Name;
3184: /*
3185: * Aded procedure for bug 3842347

Line 3323: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Type');

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

Line 3401: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');

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

Line 3453: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Cross_Org');

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

Line 3503: Pji_Rep_Util.CHECK_WP_CURRENCY_CONSISTENCY

3499: p_debug_mode => l_debug_mode );
3500: END IF;
3501:
3502: --Call the currency check API
3503: Pji_Rep_Util.CHECK_WP_CURRENCY_CONSISTENCY
3504: ( p_project_id => p_project_id
3505: ,p_wbs_version_id => p_wbs_version_id
3506: ,x_pc_flag => x_pc_flag
3507: ,x_pfc_flag => x_pfc_flag

Line 3517: Pji_Rep_Util.CHECK_WP_MARGIN_CONSISTENCY

3513: RETURN;
3514: END IF;
3515:
3516: --Call the margin check API
3517: Pji_Rep_Util.CHECK_WP_MARGIN_CONSISTENCY
3518: ( p_project_id => p_project_id
3519: ,p_wbs_version_id => p_wbs_version_id
3520: ,p_margin_code => p_margin_code
3521: ,x_margin_flag => x_margin_flag

Line 3531: Pji_Rep_Util.CHECK_WP_STATUS_CONSISTENCY

3527: RETURN;
3528: END IF;
3529:
3530: --Call the status check API
3531: Pji_Rep_Util.CHECK_WP_STATUS_CONSISTENCY
3532: ( p_project_id => p_project_id
3533: ,p_wbs_version_id => p_wbs_version_id
3534: ,p_published_flag => p_published_flag
3535: ,x_workpub_flag => x_workpub_flag

Line 3546: Pji_Rep_Util.CHECK_WP_TIME_CONSISTENCY

3542: END IF;
3543:
3544: --Call the time phase check API only if the published flag is Y
3545: IF p_published_flag = 'Y' THEN
3546: Pji_Rep_Util.CHECK_WP_TIME_CONSISTENCY
3547: ( p_project_id => p_project_id
3548: ,p_wbs_version_id => p_wbs_version_id
3549: ,p_calendar_type => p_calendar_type
3550: ,p_calendar_id => p_calendar_id

Line 3562: Pji_Rep_Util.CHECK_WP_RBS_CONSISTENCY

3558: END IF;
3559: END IF;
3560:
3561: --Call the RBS check API
3562: Pji_Rep_Util.CHECK_WP_RBS_CONSISTENCY
3563: ( p_project_id => p_project_id
3564: ,p_wbs_version_id => p_wbs_version_id
3565: ,p_rbs_version_id => p_rbs_version_id
3566: ,x_rbs_flag => x_rbs_flag

Line 3588: ( p_pkg_name => 'PJI_REP_UTIL'

3584: x_msg_count := 1;
3585: x_msg_data := SQLERRM;
3586:
3587: Fnd_Msg_Pub.add_exc_msg
3588: ( p_pkg_name => 'PJI_REP_UTIL'
3589: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
3590: ,p_error_text => x_msg_data);
3591:
3592: IF l_debug_mode = 'Y' THEN

Line 3718: ( p_pkg_name => 'PJI_REP_UTIL'

3714: x_msg_count := 1;
3715: x_msg_data := SQLERRM;
3716:
3717: Fnd_Msg_Pub.add_exc_msg
3718: ( p_pkg_name => 'PJI_REP_UTIL'
3719: ,p_procedure_name => 'CHECK_WP_CURRENCY_CONSISTENCY'
3720: ,p_error_text => x_msg_data);
3721:
3722: IF l_debug_mode = 'Y' THEN

Line 3813: ( p_pkg_name => 'PJI_REP_UTIL'

3809: x_msg_count := 1;
3810: x_msg_data := SQLERRM;
3811:
3812: Fnd_Msg_Pub.add_exc_msg
3813: ( p_pkg_name => 'PJI_REP_UTIL'
3814: ,p_procedure_name => 'CHECK_WP_MARGIN_CONSISTENCY'
3815: ,p_error_text => x_msg_data);
3816:
3817: IF l_debug_mode = 'Y' THEN

Line 3907: ( p_pkg_name => 'PJI_REP_UTIL'

3903: x_msg_count := 1;
3904: x_msg_data := SQLERRM;
3905:
3906: Fnd_Msg_Pub.add_exc_msg
3907: ( p_pkg_name => 'PJI_REP_UTIL'
3908: ,p_procedure_name => 'CHECK_WP_STATUS_CONSISTENCY'
3909: ,p_error_text => x_msg_data);
3910:
3911: IF l_debug_mode = 'Y' THEN

Line 3982: Pji_Rep_Util.Derive_WP_Calendar_Info(

3978: --inconsistency.
3979: x_time_phase_flag := 'Y';
3980:
3981: FOR rec IN get_pgm_ver_details(p_project_id,p_wbs_version_id) LOOP
3982: Pji_Rep_Util.Derive_WP_Calendar_Info(
3983: p_project_id => rec.project_id
3984: ,p_plan_version_id => rec.plan_version_id
3985: ,x_calendar_id => l_calendar_id
3986: ,x_calendar_type => l_calendar_type

Line 4015: ( p_pkg_name => 'PJI_REP_UTIL'

4011: x_msg_count := 1;
4012: x_msg_data := SQLERRM;
4013:
4014: Fnd_Msg_Pub.add_exc_msg
4015: ( p_pkg_name => 'PJI_REP_UTIL'
4016: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4017: ,p_error_text => x_msg_data);
4018:
4019: IF l_debug_mode = 'Y' THEN

Line 4111: ( p_pkg_name => 'PJI_REP_UTIL'

4107: x_msg_count := 1;
4108: x_msg_data := SQLERRM;
4109:
4110: Fnd_Msg_Pub.add_exc_msg
4111: ( p_pkg_name => 'PJI_REP_UTIL'
4112: ,p_procedure_name => 'CHECK_WP_RBS_CONSISTENCY'
4113: ,p_error_text => x_msg_data);
4114:
4115: IF l_debug_mode = 'Y' THEN

Line 4697: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Plan_Versions_Id');

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

Line 4785: ( p_pkg_name => 'PJI_REP_UTIL'

4781: x_msg_count := 1;
4782: x_msg_data := SQLERRM;
4783:
4784: Fnd_Msg_Pub.add_exc_msg
4785: ( p_pkg_name => 'PJI_REP_UTIL'
4786: ,p_procedure_name => 'Check_Perf_Cal_Consistency'
4787: ,p_error_text => x_msg_data);
4788:
4789: IF l_debug_mode = 'Y' THEN

Line 4868: ( p_pkg_name => 'PJI_REP_UTIL'

4864: x_msg_count := 1;
4865: x_msg_data := SQLERRM;
4866:
4867: Fnd_Msg_Pub.add_exc_msg
4868: ( p_pkg_name => 'PJI_REP_UTIL'
4869: ,p_procedure_name => 'Check_Perf_Curr_Consistency'
4870: ,p_error_text => x_msg_data);
4871:
4872: IF l_debug_mode = 'Y' THEN

Line 5283: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NOT_SAME_RBS', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

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

Line 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);

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

Line 5395: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');

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

Line 5457: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Proj_Type_Consistency');

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

Line 5553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');

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

Line 5558: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');

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

Line 5617: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Currency_Info');

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

Line 5661: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Validate_Plan_Type');

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

Line 5766: END Pji_Rep_Util;

5762: x_to_period := TO_CHAR(l_to_date,'j');
5763:
5764: END drv_prf_prd;
5765:
5766: END Pji_Rep_Util;