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.PA_SECURITY_PVT dependencies on FND_MSG_PUB

Line 179: FND_MSG_PUB.initialize;

175: Init_global ;
176:
177: --Clear the global PL/SQL message table
178: IF p_init_msg_list = 'Y' THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:
182: pa_debug.Init_err_stack ( 'Check User Privilege');
183: x_msg_count :=0;

Line 251: FND_MSG_PUB.Count_And_Get

247: if v_fnd_api_ret_code=fnd_api.g_ret_sts_error
248: OR v_fnd_api_ret_code=fnd_api.g_ret_sts_unexp_error then
249: x_ret_code:=fnd_api.g_false;
250: x_return_status:=fnd_api.g_ret_sts_unexp_error;
251: FND_MSG_PUB.Count_And_Get
252: (p_count => x_msg_count ,
253: p_data => x_msg_data
254: );
255: return;

Line 299: FND_MSG_PUB.Count_And_Get

295: if secure_resp_flag =FND_API.G_RET_STS_UNEXP_ERROR then
296: x_ret_code:=fnd_api.g_false;
297: x_return_status:=fnd_api.g_ret_sts_unexp_error;
298:
299: FND_MSG_PUB.Count_And_Get
300: (p_count => x_msg_count ,
301: p_data => x_msg_data
302: );
303: return;

Line 334: fnd_msg_pub.ADD;

330: x_return_status:=fnd_api.g_ret_sts_success;
331:
332: ---The following code is for testing the error page
333: /* fnd_message.set_name('PA','PA_SEC_NO_ACCESS');
334: fnd_msg_pub.ADD;
335: FND_MSG_PUB.Count_And_Get
336: (p_count => x_msg_count ,
337: p_data => x_msg_data
338: ); */

Line 335: FND_MSG_PUB.Count_And_Get

331:
332: ---The following code is for testing the error page
333: /* fnd_message.set_name('PA','PA_SEC_NO_ACCESS');
334: fnd_msg_pub.ADD;
335: FND_MSG_PUB.Count_And_Get
336: (p_count => x_msg_count ,
337: p_data => x_msg_data
338: ); */
339:

Line 348: fnd_msg_pub.add_exc_msg

344: pa_debug.G_err_stage := 'exceptions raised';
345: IF G_debug_flag = 'Y' THEN
346: pa_debug.write_file('check_user_privilege: ' || 'LOG', pa_debug.G_err_stage);
347: END IF;
348: fnd_msg_pub.add_exc_msg
349: (p_pkg_name => G_PKG_NAME,
350: p_procedure_name =>'CHECK_USER_PRIVILEGE' );
351: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
352: x_ret_code :=fnd_api.g_false;

Line 353: FND_MSG_PUB.Count_And_Get

349: (p_pkg_name => G_PKG_NAME,
350: p_procedure_name =>'CHECK_USER_PRIVILEGE' );
351: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
352: x_ret_code :=fnd_api.g_false;
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count ,
355: p_data => x_msg_data
356: );
357: end check_user_privilege;

Line 407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

403: return fnd_api.g_false;
404: end if;
405: Exception
406: when others then
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: fnd_msg_pub.add_exc_msg
409: (p_pkg_name => G_PKG_NAME,
410: p_procedure_name => 'check_sec_by_role');
411: end if;

Line 408: fnd_msg_pub.add_exc_msg

404: end if;
405: Exception
406: when others then
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: fnd_msg_pub.add_exc_msg
409: (p_pkg_name => G_PKG_NAME,
410: p_procedure_name => 'check_sec_by_role');
411: end if;
412: return fnd_api.g_ret_sts_unexp_error;

Line 513: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

509: RETURN fnd_api.g_false;
510:
511: Exception
512: when others then
513: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
514: fnd_msg_pub.add_exc_msg
515: (p_pkg_name => G_PKG_NAME,
516: p_procedure_name => 'check_sec_by_resp');
517: end if;

Line 514: fnd_msg_pub.add_exc_msg

510:
511: Exception
512: when others then
513: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
514: fnd_msg_pub.add_exc_msg
515: (p_pkg_name => G_PKG_NAME,
516: p_procedure_name => 'check_sec_by_resp');
517: end if;
518: return fnd_api.g_ret_sts_unexp_error;

Line 572: FND_MSG_PUB.initialize;

568: Init_global ;
569:
570: --Clear the global PL/SQL message table : Changed for bug 5130421
571: IF p_init_msg_list = 'T' THEN
572: FND_MSG_PUB.initialize;
573: END IF;
574:
575: pa_debug.Init_err_stack ( 'check_confirm_asmt');
576: x_msg_count :=0;

Line 617: FND_MSG_PUB.add_exc_msg

613: x_msg_count := x_msg_count+1;
614: x_msg_data := v_error_message_code;
615: x_return_status := fnd_api.g_ret_sts_error;
616: x_ret_code:=fnd_api.g_false;
617: FND_MSG_PUB.add_exc_msg
618: (p_pkg_name =>'pa_resource_utils',
619: p_procedure_name => 'Check_ResourceName_Or_Id',
620: p_error_text => v_error_message_code);
621: RETURN;

Line 637: /*FND_MSG_PUB.add_exc_msg

633: x_msg_data := v_error_message_code;
634: x_return_status := v_return_status;
635: x_ret_code:=fnd_api.g_false;
636: --Bug# 6134740 Fix start
637: /*FND_MSG_PUB.add_exc_msg
638: (p_pkg_name =>G_PKG_NAME,
639: p_procedure_name => 'GET_RESOURCE_ORG_ID',
640: p_error_text => v_error_message_code);*/
641: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 739: FND_MSG_PUB.add_exc_msg

735: x_msg_count := x_msg_count+1;
736: x_msg_data := v_error_message_code;
737: x_return_status := v_return_status;
738: x_ret_code:=fnd_api.g_false;
739: FND_MSG_PUB.add_exc_msg
740: (p_pkg_name =>G_PKG_NAME,
741: p_procedure_name => 'CHECK_MANAGER_RELATION',
742: p_error_text => v_error_message_code);
743: RETURN;

Line 785: FND_MSG_PUB.Count_And_Get

781: if v_fnd_api_ret_code=fnd_api.g_ret_sts_error
782: OR v_fnd_api_ret_code=fnd_api.g_ret_sts_unexp_error then
783: x_ret_code:=fnd_api.g_false;
784: x_return_status:=fnd_api.g_ret_sts_unexp_error;
785: FND_MSG_PUB.Count_And_Get
786: (p_count => x_msg_count ,
787: p_data => x_msg_data
788: );
789: return;

Line 819: fnd_msg_pub.add_exc_msg

815: pa_debug.G_err_stage := SUBSTR(SQLERRM, 1, 200);
816: IF G_debug_flag = 'Y' THEN
817: pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
818: END IF;
819: fnd_msg_pub.add_exc_msg
820: (p_pkg_name => G_PKG_NAME,
821: p_procedure_name =>'CHECK_CONFIRM_ASMT' );
822: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
823: x_msg_count:=x_msg_count+1;

Line 1214: FND_MSG_PUB.Count_And_Get

1210: --dbms_output.put_line('l_exp_error: '||l_exp_error||' l_unexp_error: '||l_unexp_error);
1211: x_return_status := l_return_status;
1212:
1213: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1214: FND_MSG_PUB.Count_And_Get
1215: (p_count => x_msg_count ,
1216: p_data => x_msg_data
1217: );
1218: END IF;

Line 1257: -- FND_MSG_PUB.initialize; commented the call for Bug 2887390

1253:
1254: begin
1255:
1256: --Clear the global PL/SQL message table
1257: -- FND_MSG_PUB.initialize; commented the call for Bug 2887390
1258:
1259: --dbms_output.put_line('inside grant role');
1260: x_return_status:=fnd_api.g_ret_sts_success;
1261: x_msg_count:=0;

Line 1309: FND_MSG_PUB.Count_And_Get

1305: x_return_status:=fnd_api.g_ret_sts_error;
1306: else
1307: x_return_status:=fnd_api.g_ret_sts_unexp_error;
1308: end if;
1309: FND_MSG_PUB.Count_And_Get
1310: (p_count => x_msg_count ,
1311: p_data => x_msg_data
1312: );
1313: end if;

Line 1335: FND_MSG_PUB.initialize;

1331:
1332: begin
1333:
1334: --Clear the global PL/SQL message table
1335: FND_MSG_PUB.initialize;
1336:
1337: x_return_status :=fnd_api.g_ret_sts_success;
1338: x_msg_count:=0;
1339: x_msg_data :=null;

Line 1357: FND_MSG_PUB.Count_And_Get

1353: x_return_status:=fnd_api.g_ret_sts_error;
1354: else
1355: x_return_status:=fnd_api.g_ret_sts_unexp_error;
1356: end if;
1357: FND_MSG_PUB.Count_And_Get
1358: (p_count => x_msg_count ,
1359: p_data => x_msg_data
1360: );
1361: end if;

Line 1392: FND_MSG_PUB.initialize;

1388: l_error_code NUMBER;
1389:
1390: begin
1391: --Clear the global PL/SQL message table
1392: FND_MSG_PUB.initialize;
1393:
1394: x_msg_count:=0;
1395: x_msg_data:=null;
1396:

Line 1443: FND_MSG_PUB.Count_And_Get

1439: x_return_status:=fnd_api.g_ret_sts_error;
1440: ELSE
1441: x_return_status:=fnd_api.g_ret_sts_unexp_error;
1442: END IF;
1443: FND_MSG_PUB.Count_And_Get
1444: (p_count => x_msg_count ,
1445: p_data => x_msg_data
1446: );
1447: RETURN;

Line 1458: IF FND_MSG_PUB.Check_Msg_Level

1454: EXCEPTION
1455: WHEN OTHERS THEN
1456: ROLLBACK TO revoke_role_PUB;
1457: x_return_status := FND_API.g_ret_sts_unexp_error ;
1458: IF FND_MSG_PUB.Check_Msg_Level
1459: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN
1461: FND_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME ,

Line 1459: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1455: WHEN OTHERS THEN
1456: ROLLBACK TO revoke_role_PUB;
1457: x_return_status := FND_API.g_ret_sts_unexp_error ;
1458: IF FND_MSG_PUB.Check_Msg_Level
1459: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN
1461: FND_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME ,
1463: 'revoke_role'

Line 1461: FND_MSG_PUB.Add_Exc_Msg

1457: x_return_status := FND_API.g_ret_sts_unexp_error ;
1458: IF FND_MSG_PUB.Check_Msg_Level
1459: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN
1461: FND_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME ,
1463: 'revoke_role'
1464: );
1465: END IF;

Line 1466: FND_MSG_PUB.Count_And_Get

1462: ( G_PKG_NAME ,
1463: 'revoke_role'
1464: );
1465: END IF;
1466: FND_MSG_PUB.Count_And_Get
1467: (p_count => x_msg_count ,
1468: p_data => x_msg_data
1469: );
1470: end;

Line 1494: FND_MSG_PUB.initialize;

1490: l_success varchar2(1);
1491:
1492: begin
1493: --Clear the global PL/SQL message table
1494: FND_MSG_PUB.initialize;
1495:
1496: x_return_status:=fnd_api.g_ret_sts_success;
1497: x_msg_count:=0;
1498: x_msg_data:=null;

Line 1511: FND_MSG_PUB.Count_And_Get

1507: if l_success=fnd_api.g_true then
1508: x_return_status:=fnd_api.g_ret_sts_success;
1509: else
1510: x_return_status:=fnd_api.g_ret_sts_unexp_error;
1511: FND_MSG_PUB.Count_And_Get
1512: (p_count => x_msg_count ,
1513: p_data => x_msg_data
1514: );
1515: end if;

Line 1555: FND_MSG_PUB.initialize;

1551: l_object_id number;
1552:
1553: begin
1554: --Clear the global PL/SQL message table
1555: FND_MSG_PUB.initialize;
1556:
1557: x_msg_count:=0;
1558: x_msg_data:=null;
1559:

Line 1615: fnd_msg_pub.ADD;

1611: return l_set_id;
1612: exception
1613: when no_data_found then
1614: fnd_message.set_name('PA','PA_COMMON_NO_INS_SET');
1615: fnd_msg_pub.ADD;
1616: return null;
1617: when others then
1618: IF FND_MSG_PUB.Check_Msg_Level
1619: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1618: IF FND_MSG_PUB.Check_Msg_Level

1614: fnd_message.set_name('PA','PA_COMMON_NO_INS_SET');
1615: fnd_msg_pub.ADD;
1616: return null;
1617: when others then
1618: IF FND_MSG_PUB.Check_Msg_Level
1619: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: FND_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME ,

Line 1619: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1615: fnd_msg_pub.ADD;
1616: return null;
1617: when others then
1618: IF FND_MSG_PUB.Check_Msg_Level
1619: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: FND_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME ,
1623: l_api_name

Line 1621: FND_MSG_PUB.Add_Exc_Msg

1617: when others then
1618: IF FND_MSG_PUB.Check_Msg_Level
1619: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: FND_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME ,
1623: l_api_name
1624: );
1625: END IF;

Line 1645: --fnd_msg_pub.ADD;

1641: return v_menu_name;
1642: exception
1643: when no_data_found then
1644: --fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1645: --fnd_msg_pub.ADD;
1646: return null;
1647: when others then
1648: IF FND_MSG_PUB.Check_Msg_Level
1649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1648: IF FND_MSG_PUB.Check_Msg_Level

1644: --fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1645: --fnd_msg_pub.ADD;
1646: return null;
1647: when others then
1648: IF FND_MSG_PUB.Check_Msg_Level
1649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1650: THEN
1651: FND_MSG_PUB.Add_Exc_Msg
1652: ( G_PKG_NAME ,

Line 1649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1645: --fnd_msg_pub.ADD;
1646: return null;
1647: when others then
1648: IF FND_MSG_PUB.Check_Msg_Level
1649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1650: THEN
1651: FND_MSG_PUB.Add_Exc_Msg
1652: ( G_PKG_NAME ,
1653: l_api_name

Line 1651: FND_MSG_PUB.Add_Exc_Msg

1647: when others then
1648: IF FND_MSG_PUB.Check_Msg_Level
1649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1650: THEN
1651: FND_MSG_PUB.Add_Exc_Msg
1652: ( G_PKG_NAME ,
1653: l_api_name
1654: );
1655: END IF;

Line 1688: --fnd_msg_pub.ADD;

1684: return v_menu_name;
1685: exception
1686: when no_data_found then
1687: --fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1688: --fnd_msg_pub.ADD;
1689: return null;
1690: when others then
1691: IF FND_MSG_PUB.Check_Msg_Level
1692: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1691: IF FND_MSG_PUB.Check_Msg_Level

1687: --fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1688: --fnd_msg_pub.ADD;
1689: return null;
1690: when others then
1691: IF FND_MSG_PUB.Check_Msg_Level
1692: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg
1695: ( G_PKG_NAME ,

Line 1692: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1688: --fnd_msg_pub.ADD;
1689: return null;
1690: when others then
1691: IF FND_MSG_PUB.Check_Msg_Level
1692: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg
1695: ( G_PKG_NAME ,
1696: l_api_name

Line 1694: FND_MSG_PUB.Add_Exc_Msg

1690: when others then
1691: IF FND_MSG_PUB.Check_Msg_Level
1692: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg
1695: ( G_PKG_NAME ,
1696: l_api_name
1697: );
1698: END IF;

Line 1714: -- fnd_msg_pub.ADD;

1710: return v_menu_id;
1711: exception
1712: when no_data_found then
1713: -- fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1714: -- fnd_msg_pub.ADD;
1715: return null;
1716: when others then
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1717: IF FND_MSG_PUB.Check_Msg_Level

1713: -- fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1714: -- fnd_msg_pub.ADD;
1715: return null;
1716: when others then
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME ,

Line 1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1714: -- fnd_msg_pub.ADD;
1715: return null;
1716: when others then
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME ,
1722: l_api_name

Line 1720: FND_MSG_PUB.Add_Exc_Msg

1716: when others then
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME ,
1722: l_api_name
1723: );
1724: END IF;

Line 1740: -- fnd_msg_pub.ADD;

1736: return v_menu_id;
1737: exception
1738: when no_data_found then
1739: -- fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1740: -- fnd_msg_pub.ADD;
1741: return null;
1742: when others then
1743: IF FND_MSG_PUB.Check_Msg_Level
1744: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1743: IF FND_MSG_PUB.Check_Msg_Level

1739: -- fnd_message.set_name('PA','PA_COMMON_NO_ROLE_MENU');
1740: -- fnd_msg_pub.ADD;
1741: return null;
1742: when others then
1743: IF FND_MSG_PUB.Check_Msg_Level
1744: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1745: THEN
1746: FND_MSG_PUB.Add_Exc_Msg
1747: ( G_PKG_NAME ,

Line 1744: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1740: -- fnd_msg_pub.ADD;
1741: return null;
1742: when others then
1743: IF FND_MSG_PUB.Check_Msg_Level
1744: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1745: THEN
1746: FND_MSG_PUB.Add_Exc_Msg
1747: ( G_PKG_NAME ,
1748: l_api_name

Line 1746: FND_MSG_PUB.Add_Exc_Msg

1742: when others then
1743: IF FND_MSG_PUB.Check_Msg_Level
1744: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1745: THEN
1746: FND_MSG_PUB.Add_Exc_Msg
1747: ( G_PKG_NAME ,
1748: l_api_name
1749: );
1750: END IF;

Line 1959: FND_MSG_PUB.initialize;

1955: l_sql VARCHAR2(32767);
1956: l_predicate VARCHAR2(32767);
1957: BEGIN
1958: --Clear the global PL/SQL message table
1959: FND_MSG_PUB.initialize;
1960:
1961: pa_debug.Init_err_stack ( 'Check_Access_Exist');
1962:
1963: Init_global;

Line 2071: FND_MSG_PUB.Count_And_Get

2067: -- IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2068: IF x_return_status<>'T' AND x_return_status<>'F' THEN
2069: x_ret_code := FND_API.G_FALSE;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: FND_MSG_PUB.Count_And_Get
2072: (p_count => x_msg_count ,
2073: p_data => x_msg_data);
2074: RETURN;
2075: ELSIF x_return_status='F' THEN

Line 2113: FND_MSG_PUB.Count_And_Get

2109: pa_debug.write_file('check_access_exist: ' || 'LOG', pa_debug.G_err_stage);
2110: END IF;
2111: x_ret_code := FND_API.G_FALSE;
2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113: FND_MSG_PUB.Count_And_Get
2114: (p_count => x_msg_count ,
2115: p_data => x_msg_data);
2116:
2117: END check_access_exist;

Line 2202: fnd_msg_pub.add_exc_msg

2198:
2199: EXCEPTION
2200: when others then
2201: x_return_status:=fnd_api.g_ret_sts_unexp_error;
2202: fnd_msg_pub.add_exc_msg
2203: (p_pkg_name => 'PA_SECURITY_PVT',
2204: p_procedure_name => 'UPDATE_MENU',
2205: p_error_text => SQLCODE);
2206: x_msg_count := 1;

Line 2239: fnd_msg_pub.add_exc_msg

2235:
2236: EXCEPTION
2237: when others then
2238: x_return_status:=fnd_api.g_ret_sts_unexp_error;
2239: fnd_msg_pub.add_exc_msg
2240: (p_pkg_name => 'PA_SECURITY_PVT',
2241: p_procedure_name => 'REVOKE_ROLE_BASED_SEC',
2242: p_error_text => SQLCODE);
2243: x_msg_count := 1;

Line 2445: FND_MSG_PUB.Count_And_Get

2441:
2442: x_return_status:=l_return_status;
2443:
2444: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2445: FND_MSG_PUB.Count_And_Get
2446: (p_count => x_msg_count ,
2447: p_data => x_msg_data
2448: );
2449: END IF;

Line 2454: fnd_msg_pub.add_exc_msg

2450:
2451: EXCEPTION
2452: when others then
2453: x_return_status:=fnd_api.g_ret_sts_unexp_error;
2454: fnd_msg_pub.add_exc_msg
2455: (p_pkg_name => 'PA_SECURITY_PVT',
2456: p_procedure_name => 'GRANT_ROLE_BASED_SEC',
2457: p_error_text => SQLCODE);
2458: FND_MSG_PUB.Count_And_Get

Line 2458: FND_MSG_PUB.Count_And_Get

2454: fnd_msg_pub.add_exc_msg
2455: (p_pkg_name => 'PA_SECURITY_PVT',
2456: p_procedure_name => 'GRANT_ROLE_BASED_SEC',
2457: p_error_text => SQLCODE);
2458: FND_MSG_PUB.Count_And_Get
2459: (p_count => x_msg_count ,
2460: p_data => x_msg_data
2461: );
2462: END grant_role_based_sec;

Line 2494: fnd_msg_pub.add_exc_msg

2490:
2491: EXCEPTION
2492: when others then
2493: x_return_status:=fnd_api.g_ret_sts_unexp_error;
2494: fnd_msg_pub.add_exc_msg
2495: (p_pkg_name => 'PA_SECURITY_PVT',
2496: p_procedure_name => 'REVOKE_STATUS_BASED_SEC',
2497: p_error_text => SQLCODE);
2498: x_msg_count := 1;

Line 2682: fnd_msg_pub.add_exc_msg

2678:
2679: EXCEPTION
2680: when others then
2681: x_return_status:=fnd_api.g_ret_sts_unexp_error;
2682: fnd_msg_pub.add_exc_msg
2683: (p_pkg_name => 'PA_SECURITY_PVT',
2684: p_procedure_name => 'UPDATE_STATUS_BASED_SEC',
2685: p_error_text => SQLCODE);
2686: FND_MSG_PUB.Count_And_Get

Line 2686: FND_MSG_PUB.Count_And_Get

2682: fnd_msg_pub.add_exc_msg
2683: (p_pkg_name => 'PA_SECURITY_PVT',
2684: p_procedure_name => 'UPDATE_STATUS_BASED_SEC',
2685: p_error_text => SQLCODE);
2686: FND_MSG_PUB.Count_And_Get
2687: (p_count => x_msg_count ,
2688: p_data => x_msg_data
2689: );
2690: END update_status_based_sec;