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.52.12020000.11 2013/04/16 15:27:13 krkondur ship $ */
3:
4: g_project_id NUMBER:=-1;
5: g_pa_calendar_type VARCHAR2(1):='P';

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

203: Fnd_Msg_Pub.add_detail(p_message_type=>p_msg_type);
204: EXCEPTION
205: WHEN OTHERS THEN
206: Fnd_Message.set_name('PJI','PJI_REP_GENERIC_MSG');
207: Fnd_Message.set_token('PROC_NAME','Pji_Rep_Util.Add_Message');
208: END Add_Message;
209:
210: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE) IS
211: l_i NUMBER;

Line 270: 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');

266: );
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: 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');
271: RAISE;
272: END;
273:
274:

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

869: EXCEPTION
870: WHEN OTHERS THEN
871: x_msg_count := x_msg_count + 1;
872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
873: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Populate_WBS_Hierarchy_Cache');
874: RAISE;
875: END;
876:
877: PROCEDURE Populate_WP_Plan_Vers_Cache(p_project_id NUMBER

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

979: EXCEPTION
980: WHEN OTHERS THEN
981: x_msg_count := x_msg_count + 1;
982: x_return_status := Fnd_Api.G_RET_STS_ERROR;
983: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');
984: RAISE;
985: END Populate_WP_Plan_Vers_Cache;
986:
987: PROCEDURE Derive_Default_Calendar_Info(

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

1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: x_msg_count := x_msg_count + 1;
1077: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1078: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Calendar_Info');
1079: RAISE;
1080: END Derive_Default_Calendar_Info;
1081:
1082: PROCEDURE Derive_WP_Calendar_Info(

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

1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: x_msg_count := x_msg_count + 1;
1123: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1124: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WP CALENDAR');
1125: WHEN OTHERS THEN
1126: x_msg_count := x_msg_count + 1;
1127: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1128: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Calendar_Info');

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

1124: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'WP CALENDAR');
1125: WHEN OTHERS THEN
1126: x_msg_count := x_msg_count + 1;
1127: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1128: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Calendar_Info');
1129: RAISE;
1130: END Derive_WP_Calendar_Info;
1131:
1132: PROCEDURE Derive_VP_Calendar_Info(

Line 1268: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;

1264:
1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN
1267: x_msg_count := x_msg_count + 1;
1268: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
1269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
1270: WHEN OTHERS THEN
1271: x_msg_count := x_msg_count + 1;
1272: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN
1267: x_msg_count := x_msg_count + 1;
1268: x_return_status := Pji_Rep_Util.G_RET_STS_ERROR;
1269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
1270: WHEN OTHERS THEN
1271: x_msg_count := x_msg_count + 1;
1272: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1273: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Vp_Calendar_Info');

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

1269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'VP CALENDAR');
1270: WHEN OTHERS THEN
1271: x_msg_count := x_msg_count + 1;
1272: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1273: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Vp_Calendar_Info');
1274: RAISE;
1275: END Derive_Vp_Calendar_Info;
1276:
1277:

Line 1311: 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');

1307: RETURN l_version_type;
1308:
1309: EXCEPTION
1310: WHEN OTHERS THEN
1311: 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');
1312: RETURN NULL;
1313: END Get_Version_Type;
1314:
1315: /*

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

1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: x_msg_count := x_msg_count + 1;
1563: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1564: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Plan_Versions');
1565: RAISE;
1566: END Derive_Default_Plan_Versions;
1567:
1568: /*

Line 1607: if Pji_Rep_Util.G_PROJECT_LIST = 'Y' then

1603: This code has been added to honor the value of profile option
1604: PJI:Default Reporting Currency Type in Project List page. The IF-THEN
1605: condition ensures that this change does not impact current behaviour of
1606: View Budget and View Workplan Cost pages */
1607: if Pji_Rep_Util.G_PROJECT_LIST = 'Y' then
1608: Derive_Perf_Currency_Info(p_project_id, x_currency_record_type,
1609: x_currency_code, x_currency_type,
1610: x_return_status, x_msg_count, x_msg_data);
1611: else

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

1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: x_msg_count := x_msg_count + 1;
1625: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1626: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');
1627: RAISE;
1628: END Derive_Default_Currency_Info;
1629:
1630:

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

1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: x_msg_count := x_msg_count + 1;
1695: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1696: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_Currency_Info');
1697: RAISE;
1698: END Derive_Perf_Currency_Info;
1699:
1700: FUNCTION Derive_FactorBy(

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_FactorBy');

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

Line 1783: 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');

1779: END IF;
1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: 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');
1784: RETURN NULL;
1785: END Derive_Prg_Rollup_Flag;
1786:
1787: FUNCTION Derive_Perf_Prg_Rollup_Flag(

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

1850: EXCEPTION
1851: WHEN NO_DATA_FOUND THEN
1852: x_msg_count := x_msg_count + 1;
1853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1854: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PROJ ATTRIBUTES');
1855: WHEN OTHERS THEN
1856: x_msg_count := x_msg_count + 1;
1857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1858: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Attributes');

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

1854: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PROJ ATTRIBUTES');
1855: WHEN OTHERS THEN
1856: x_msg_count := x_msg_count + 1;
1857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1858: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Attributes');
1859: RAISE;
1860: END Derive_Project_Attributes;
1861:
1862: /*

Line 1912: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1908: WHEN NO_DATA_FOUND THEN
1909: x_rbs_version_id := -99;
1910: x_rbs_element_id := -99;
1911: /* x_msg_count := x_msg_count + 1;
1912: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1913: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1914: */ WHEN OTHERS THEN
1915: x_msg_count := x_msg_count + 1;
1916: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

1909: x_rbs_version_id := -99;
1910: x_rbs_element_id := -99;
1911: /* x_msg_count := x_msg_count + 1;
1912: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1913: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1914: */ WHEN OTHERS THEN
1915: x_msg_count := x_msg_count + 1;
1916: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1917: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Parameters');

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

1913: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1914: */ WHEN OTHERS THEN
1915: x_msg_count := x_msg_count + 1;
1916: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1917: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Parameters');
1918: RAISE;
1919: END Derive_Default_RBS_Parameters;
1920:
1921:

Line 1986: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

1982: WHEN NO_DATA_FOUND THEN
1983: x_rbs_version_id := -99;
1984: x_rbs_element_id := -99;
1985: /* x_msg_count := x_msg_count + 1;
1986: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1987: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1988: */ WHEN OTHERS THEN
1989: x_msg_count := x_msg_count + 1;
1990: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

1983: x_rbs_version_id := -99;
1984: x_rbs_element_id := -99;
1985: /* x_msg_count := x_msg_count + 1;
1986: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
1987: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1988: */ WHEN OTHERS THEN
1989: x_msg_count := x_msg_count + 1;
1990: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1991: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_RBS_Parameters');

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

1987: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_PERF_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
1988: */ WHEN OTHERS THEN
1989: x_msg_count := x_msg_count + 1;
1990: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1991: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_RBS_Parameters');
1992: RAISE;
1993: END Derive_Perf_RBS_Parameters;
1994:
1995:

Line 2039: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

2035:
2036: EXCEPTION
2037: WHEN NO_DATA_FOUND THEN
2038: x_msg_count := x_msg_count + 1;
2039: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
2040: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');
2041: WHEN OTHERS THEN
2042: x_msg_count := x_msg_count + 1;
2043: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

2036: EXCEPTION
2037: WHEN NO_DATA_FOUND THEN
2038: x_msg_count := x_msg_count + 1;
2039: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
2040: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');
2041: WHEN OTHERS THEN
2042: x_msg_count := x_msg_count + 1;
2043: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2044: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Element_Id');

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

2040: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'RBS ELEMENT');
2041: WHEN OTHERS THEN
2042: x_msg_count := x_msg_count + 1;
2043: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2044: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_RBS_Element_Id');
2045: RAISE;
2046: END Derive_Default_RBS_Element_Id;
2047:
2048: PROCEDURE Derive_Default_WBS_Parameters(

Line 2119: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

2115: WHERE elm.element_version_id = x_wbs_version_id;
2116: EXCEPTION
2117: WHEN NO_DATA_FOUND THEN
2118: x_msg_count := x_msg_count + 1;
2119: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
2120: 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');
2121: END;
2122:
2123: /* SELECT hdr.wbs_version_id,elm.proj_element_id

Line 2120: 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');

2116: EXCEPTION
2117: WHEN NO_DATA_FOUND THEN
2118: x_msg_count := x_msg_count + 1;
2119: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
2120: 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');
2121: END;
2122:
2123: /* SELECT hdr.wbs_version_id,elm.proj_element_id
2124: INTO x_wbs_version_id, x_wbs_element_id

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

2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: x_msg_count := x_msg_count + 1;
2140: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2141: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_WBS_Parameters');
2142: RAISE;
2143: END Derive_Default_WBS_Parameters;
2144:
2145: PROCEDURE Derive_WP_WBS_Parameters(

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

2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_msg_count := x_msg_count + 1;
2187: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2188: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_WBS_Parameters');
2189: RAISE;
2190: END Derive_WP_WBS_Parameters;
2191:
2192:

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

2211: l_end_date DATE;
2212: l_rec_count NUMBER;
2213: BEGIN
2214:
2215: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
2216: IF g_debug_mode = 'Y' THEN
2217: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
2218: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
2219: END IF;

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

2317: EXCEPTION
2318: WHEN NO_DATA_FOUND THEN
2319: x_msg_count := x_msg_count + 1;
2320: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2321: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'SLICE NAME');
2322: WHEN OTHERS THEN
2323: x_msg_count := x_msg_count + 1;
2324: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2325: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Slice_Name');

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

2321: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'SLICE NAME');
2322: WHEN OTHERS THEN
2323: x_msg_count := x_msg_count + 1;
2324: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2325: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Slice_Name');
2326: RAISE;
2327: END Derive_Slice_Name;
2328:
2329: PROCEDURE Derive_Plan_Type_Parameters(

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

2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN
2392: x_msg_count := x_msg_count + 1;
2393: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2394: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN TYPE PARAMETERS');
2395: WHEN OTHERS THEN
2396: x_msg_count := x_msg_count + 1;
2397: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2398: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Plan_Type_Parameters');

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

2394: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN TYPE PARAMETERS');
2395: WHEN OTHERS THEN
2396: x_msg_count := x_msg_count + 1;
2397: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2398: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Plan_Type_Parameters');
2399: RAISE;
2400: END Derive_Plan_Type_Parameters;
2401:
2402:

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

2432: EXCEPTION
2433: WHEN NO_DATA_FOUND THEN
2434: x_msg_count := x_msg_count + 1;
2435: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2436: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'PLAN VERSION MARGIN MASK');
2437: x_plan_margin_mask := 'B';
2438: WHEN OTHERS THEN
2439: x_msg_count := x_msg_count + 1;
2440: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

2437: x_plan_margin_mask := 'B';
2438: WHEN OTHERS THEN
2439: x_msg_count := x_msg_count + 1;
2440: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2441: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Margin_Mask');
2442: RAISE;
2443: END Derive_Version_Margin_Mask;
2444:
2445: PROCEDURE Derive_Version_Parameters(

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

2475: EXCEPTION
2476: WHEN NO_DATA_FOUND THEN
2477: x_msg_count := x_msg_count + 1;
2478: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2479: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NO_PLAN_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
2480: WHEN OTHERS THEN
2481: x_msg_count := x_msg_count + 1;
2482: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2483: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Parameters');

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

2479: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NO_PLAN_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
2480: WHEN OTHERS THEN
2481: x_msg_count := x_msg_count + 1;
2482: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2483: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Version_Parameters');
2484: RAISE;
2485: END Derive_Version_Parameters;
2486:
2487: PROCEDURE Derive_Fin_Plan_Versions(p_project_id NUMBER

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

2549: EXCEPTION
2550: WHEN OTHERS THEN
2551: x_msg_count := x_msg_count + 1;
2552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2553: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Fin_Plan_Versions');
2554: RAISE;
2555: END Derive_Fin_Plan_Versions;
2556:
2557:

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

2615: EXCEPTION
2616: WHEN OTHERS THEN
2617: x_msg_count := x_msg_count + 1;
2618: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2619: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Work_Plan_Versions');
2620: RAISE;
2621: END Derive_Work_Plan_Versions;
2622:
2623: /*

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

2629: l_msg_count NUMBER;
2630: l_msg_data VARCHAR2(2000);
2631: BEGIN
2632:
2633: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2634: IF g_debug_mode = 'Y' THEN
2635: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2636: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2637: END IF;

Line 2659: 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');

2655: Pa_Debug.Reset_Err_Stack;
2656:
2657: EXCEPTION
2658: WHEN OTHERS THEN
2659: 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');
2660: RETURN 1;
2661: END Get_Report_Date_Julian;
2662:
2663:

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

2669: l_msg_count NUMBER;
2670: l_msg_data VARCHAR2(2000);
2671: BEGIN
2672:
2673: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2674: IF g_debug_mode = 'Y' THEN
2675: Pa_Debug.write_file('Get_Period_Name: begining',5);
2676: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2677: END IF;

Line 2700: 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');

2696: RETURN g_period_name;
2697:
2698: EXCEPTION
2699: WHEN OTHERS THEN
2700: 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');
2701: RETURN NULL;
2702: END Get_Period_Name;
2703:
2704: */

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

2727: l_gl_calendar_id NUMBER;
2728: l_pa_calendar_id NUMBER;
2729: l_same_pa_gl_period varchar2(1); /* Added for bug 9859878 */
2730: BEGIN
2731: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2732: IF g_debug_mode = 'Y' THEN
2733: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2734: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2735: END IF;

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

2784:
2785: IF l_active_rep IS NULL THEN
2786: x_msg_count := x_msg_count + 1;
2787: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2788: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2789: x_report_date_julian :=2;
2790: RETURN;
2791: END IF;
2792:

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

2808: EXCEPTION
2809: WHEN NO_DATA_FOUND THEN
2810: x_msg_count := x_msg_count + 1;
2811: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2812: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2813: x_report_date_julian :=2;
2814: RETURN;
2815: END;
2816:

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

2824:
2825: IF l_specific_period IS NULL THEN
2826: x_msg_count := x_msg_count + 1;
2827: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2828: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_CUR_PERIOD_MISSING', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
2829: x_report_date_julian :=2;
2830: RETURN;
2831: END IF;
2832: END IF;

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

2995: EXCEPTION
2996: WHEN NO_DATA_FOUND THEN
2997: x_msg_count := x_msg_count + 1;
2998: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2999: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
3000: x_report_date_julian :=2;
3001: WHEN OTHERS THEN
3002: x_msg_count := x_msg_count + 1;
3003: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

3000: x_report_date_julian :=2;
3001: WHEN OTHERS THEN
3002: x_msg_count := x_msg_count + 1;
3003: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3004: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Period_Julian');
3005: RAISE;
3006: END Derive_Pa_Calendar_Info;
3007:
3008:

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

3440: EXCEPTION
3441: WHEN OTHERS THEN
3442: x_msg_count := 1;
3443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3444: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.get_project_home_default_param');
3445: RAISE;
3446:
3447: END get_project_home_default_param;
3448:

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

3498: x_to_period := NULL;
3499: WHEN OTHERS THEN
3500: x_msg_count := x_msg_count + 1;
3501: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3502: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_WP_Period');
3503: RAISE;
3504: END Derive_WP_Period;
3505:
3506: PROCEDURE Derive_VP_Period(

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

3541: x_to_period := NULL;
3542: WHEN OTHERS THEN
3543: x_msg_count := x_msg_count + 1;
3544: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3545: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_VP_Period');
3546: RAISE;
3547: END Derive_VP_Period;
3548:
3549: PROCEDURE Derive_Perf_Period(

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

3583: x_to_period := NULL;
3584: WHEN OTHERS THEN
3585: x_msg_count := x_msg_count + 1;
3586: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3587: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Perf_Period');
3588: RAISE;
3589: END Derive_Perf_Period;
3590:
3591: FUNCTION Get_Slice_Name(

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

3597: l_msg_count NUMBER;
3598: l_msg_data VARCHAR2(2000);
3599: BEGIN
3600:
3601: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3602: IF g_debug_mode = 'Y' THEN
3603: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3604: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3605: END IF;

Line 3625: 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');

3621: RETURN l_slice_name;
3622:
3623: EXCEPTION
3624: WHEN OTHERS THEN
3625: 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');
3626: RETURN NULL;
3627: END Get_Slice_Name;
3628: /*
3629: * Aded procedure for bug 3842347

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

3763: x_project_type := 'CONTRACT';
3764: WHEN OTHERS THEN
3765: x_msg_count := x_msg_count + 1;
3766: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3767: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Project_Type');
3768: RAISE;
3769: END Derive_Project_Type;
3770:
3771: PROCEDURE Derive_Percent_Complete

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

3841: x_percent_complete := NULL;
3842: WHEN OTHERS THEN
3843: x_msg_count := x_msg_count + 1;
3844: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3845: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');
3846: RAISE;
3847: END Derive_Percent_Complete;
3848:
3849:

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

3893: x_cross_org_flag := 'F';
3894: WHEN OTHERS THEN
3895: x_msg_count := x_msg_count + 1;
3896: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3897: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Cross_Org');
3898: RAISE;
3899: END Check_Cross_Org;
3900:
3901: /*

Line 3947: Pji_Rep_Util.CHECK_WP_CURRENCY_CONSISTENCY

3943: p_debug_mode => l_debug_mode );
3944: END IF;
3945:
3946: --Call the currency check API
3947: Pji_Rep_Util.CHECK_WP_CURRENCY_CONSISTENCY
3948: ( p_project_id => p_project_id
3949: ,p_wbs_version_id => p_wbs_version_id
3950: ,x_pc_flag => x_pc_flag
3951: ,x_pfc_flag => x_pfc_flag

Line 3961: Pji_Rep_Util.CHECK_WP_MARGIN_CONSISTENCY

3957: RETURN;
3958: END IF;
3959:
3960: --Call the margin check API
3961: Pji_Rep_Util.CHECK_WP_MARGIN_CONSISTENCY
3962: ( p_project_id => p_project_id
3963: ,p_wbs_version_id => p_wbs_version_id
3964: ,p_margin_code => p_margin_code
3965: ,x_margin_flag => x_margin_flag

Line 3975: Pji_Rep_Util.CHECK_WP_STATUS_CONSISTENCY

3971: RETURN;
3972: END IF;
3973:
3974: --Call the status check API
3975: Pji_Rep_Util.CHECK_WP_STATUS_CONSISTENCY
3976: ( p_project_id => p_project_id
3977: ,p_wbs_version_id => p_wbs_version_id
3978: ,p_published_flag => p_published_flag
3979: ,x_workpub_flag => x_workpub_flag

Line 3990: Pji_Rep_Util.CHECK_WP_TIME_CONSISTENCY

3986: END IF;
3987:
3988: --Call the time phase check API only if the published flag is Y
3989: IF p_published_flag = 'Y' THEN
3990: Pji_Rep_Util.CHECK_WP_TIME_CONSISTENCY
3991: ( p_project_id => p_project_id
3992: ,p_wbs_version_id => p_wbs_version_id
3993: ,p_calendar_type => p_calendar_type
3994: ,p_calendar_id => p_calendar_id

Line 4006: Pji_Rep_Util.CHECK_WP_RBS_CONSISTENCY

4002: END IF;
4003: END IF;
4004:
4005: --Call the RBS check API
4006: Pji_Rep_Util.CHECK_WP_RBS_CONSISTENCY
4007: ( p_project_id => p_project_id
4008: ,p_wbs_version_id => p_wbs_version_id
4009: ,p_rbs_version_id => p_rbs_version_id
4010: ,x_rbs_flag => x_rbs_flag

Line 4032: ( p_pkg_name => 'PJI_REP_UTIL'

4028: x_msg_count := 1;
4029: x_msg_data := SQLERRM;
4030:
4031: Fnd_Msg_Pub.add_exc_msg
4032: ( p_pkg_name => 'PJI_REP_UTIL'
4033: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4034: ,p_error_text => x_msg_data);
4035:
4036: IF l_debug_mode = 'Y' THEN

Line 4162: ( p_pkg_name => 'PJI_REP_UTIL'

4158: x_msg_count := 1;
4159: x_msg_data := SQLERRM;
4160:
4161: Fnd_Msg_Pub.add_exc_msg
4162: ( p_pkg_name => 'PJI_REP_UTIL'
4163: ,p_procedure_name => 'CHECK_WP_CURRENCY_CONSISTENCY'
4164: ,p_error_text => x_msg_data);
4165:
4166: IF l_debug_mode = 'Y' THEN

Line 4257: ( p_pkg_name => 'PJI_REP_UTIL'

4253: x_msg_count := 1;
4254: x_msg_data := SQLERRM;
4255:
4256: Fnd_Msg_Pub.add_exc_msg
4257: ( p_pkg_name => 'PJI_REP_UTIL'
4258: ,p_procedure_name => 'CHECK_WP_MARGIN_CONSISTENCY'
4259: ,p_error_text => x_msg_data);
4260:
4261: IF l_debug_mode = 'Y' THEN

Line 4351: ( p_pkg_name => 'PJI_REP_UTIL'

4347: x_msg_count := 1;
4348: x_msg_data := SQLERRM;
4349:
4350: Fnd_Msg_Pub.add_exc_msg
4351: ( p_pkg_name => 'PJI_REP_UTIL'
4352: ,p_procedure_name => 'CHECK_WP_STATUS_CONSISTENCY'
4353: ,p_error_text => x_msg_data);
4354:
4355: IF l_debug_mode = 'Y' THEN

Line 4426: Pji_Rep_Util.Derive_WP_Calendar_Info(

4422: --inconsistency.
4423: x_time_phase_flag := 'Y';
4424:
4425: FOR rec IN get_pgm_ver_details(p_project_id,p_wbs_version_id) LOOP
4426: Pji_Rep_Util.Derive_WP_Calendar_Info(
4427: p_project_id => rec.project_id
4428: ,p_plan_version_id => rec.plan_version_id
4429: ,x_calendar_id => l_calendar_id
4430: ,x_calendar_type => l_calendar_type

Line 4459: ( p_pkg_name => 'PJI_REP_UTIL'

4455: x_msg_count := 1;
4456: x_msg_data := SQLERRM;
4457:
4458: Fnd_Msg_Pub.add_exc_msg
4459: ( p_pkg_name => 'PJI_REP_UTIL'
4460: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4461: ,p_error_text => x_msg_data);
4462:
4463: IF l_debug_mode = 'Y' THEN

Line 4555: ( p_pkg_name => 'PJI_REP_UTIL'

4551: x_msg_count := 1;
4552: x_msg_data := SQLERRM;
4553:
4554: Fnd_Msg_Pub.add_exc_msg
4555: ( p_pkg_name => 'PJI_REP_UTIL'
4556: ,p_procedure_name => 'CHECK_WP_RBS_CONSISTENCY'
4557: ,p_error_text => x_msg_data);
4558:
4559: IF l_debug_mode = 'Y' THEN

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

5137: EXCEPTION
5138: WHEN OTHERS THEN
5139: x_msg_count := x_msg_count + 1;
5140: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5141: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Plan_Versions_Id');
5142: RAISE;
5143: END Derive_Plan_Version_Ids;
5144:
5145: /*

Line 5229: ( p_pkg_name => 'PJI_REP_UTIL'

5225: x_msg_count := 1;
5226: x_msg_data := SQLERRM;
5227:
5228: Fnd_Msg_Pub.add_exc_msg
5229: ( p_pkg_name => 'PJI_REP_UTIL'
5230: ,p_procedure_name => 'Check_Perf_Cal_Consistency'
5231: ,p_error_text => x_msg_data);
5232:
5233: IF l_debug_mode = 'Y' THEN

Line 5312: ( p_pkg_name => 'PJI_REP_UTIL'

5308: x_msg_count := 1;
5309: x_msg_data := SQLERRM;
5310:
5311: Fnd_Msg_Pub.add_exc_msg
5312: ( p_pkg_name => 'PJI_REP_UTIL'
5313: ,p_procedure_name => 'Check_Perf_Curr_Consistency'
5314: ,p_error_text => x_msg_data);
5315:
5316: IF l_debug_mode = 'Y' THEN

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

5763: ELSE
5764: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;
5765: x_msg_count := NVL(x_msg_count,0) + 1;
5766: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5767: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NOT_SAME_RBS', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
5768: END IF;
5769:
5770:
5771: EXCEPTION

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

5772: WHEN NO_DATA_FOUND THEN
5773: x_R_PlanVers_HavSame_RBS_Flag := 'N';
5774: x_msg_count := NVL(x_msg_count,0) + 1;
5775: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5776: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_NOT_SAME_RBS', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
5777: IF g_debug_mode = 'Y' THEN
5778: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: No data found ', TRUE , g_proc);
5779: END IF;
5780: END;

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

5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: x_msg_count := x_msg_count + 1;
5878: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5879: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Complete_Percentage');
5880: RAISE;
5881: END Get_Process_Status_Msg;
5882:
5883: PROCEDURE CHECK_PROJ_TYPE_CONSISTENCY

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

5937: EXCEPTION
5938: WHEN OTHERS THEN
5939: x_msg_count := x_msg_count + 1;
5940: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5941: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Check_Proj_Type_Consistency');
5942: RAISE;
5943: END Check_Proj_Type_Consistency;
5944:
5945:

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

6033: EXCEPTION
6034: WHEN NO_DATA_FOUND THEN
6035: x_msg_count := x_msg_count + 1;
6036: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6037: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');
6038: x_report_date_julian :=2;
6039: WHEN OTHERS THEN
6040: x_msg_count := x_msg_count + 1;
6041: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

6038: x_report_date_julian :=2;
6039: WHEN OTHERS THEN
6040: x_msg_count := x_msg_count + 1;
6041: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6042: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Calendar_Info');
6043: x_report_date_julian :=2;
6044: RAISE;
6045: END Derive_Pji_Calendar_Info;
6046:

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

6097: EXCEPTION
6098: WHEN OTHERS THEN
6099: x_msg_count := x_msg_count + 1;
6100: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6101: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Pji_Currency_Info');
6102: RAISE;
6103: END Derive_Pji_Currency_Info;
6104:
6105:

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

6141: EXCEPTION
6142: WHEN OTHERS THEN
6143: x_msg_count := x_msg_count + 1;
6144: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6145: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Validate_Plan_Type');
6146: RAISE;
6147: END Validate_Plan_Type;
6148:
6149: FUNCTION is_str_linked_to_working_ver

Line 6462: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;

6458: WHEN NO_DATA_FOUND THEN
6459: x_cbs_version_id := -99;
6460: x_cbs_element_id := -99;
6461: /* x_msg_count := x_msg_count + 1;
6462: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
6463: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
6464: */ WHEN OTHERS THEN
6465: x_msg_count := x_msg_count + 1;
6466: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

6459: x_cbs_version_id := -99;
6460: x_cbs_element_id := -99;
6461: /* x_msg_count := x_msg_count + 1;
6462: x_return_status := Pji_Rep_Util.G_RET_STS_WARNING;
6463: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
6464: */ WHEN OTHERS THEN
6465: x_msg_count := x_msg_count + 1;
6466: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6467: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_CBS_Parameters');

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

6463: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_VP_NO_RBS_VERSION', p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING);
6464: */ WHEN OTHERS THEN
6465: x_msg_count := x_msg_count + 1;
6466: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6467: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_CBS_Parameters');
6468: RAISE;
6469: END DERIVE_DEFAULT_CBS_PARAMETERS;
6470:
6471: END Pji_Rep_Util;

Line 6471: END Pji_Rep_Util;

6467: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Default_CBS_Parameters');
6468: RAISE;
6469: END DERIVE_DEFAULT_CBS_PARAMETERS;
6470:
6471: END Pji_Rep_Util;