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.IBC_DATA_SECURITY_PVT dependencies on IBC_UTILITIES_PVT

Line 496: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

492: ROLLBACK TO svpt_set_inheritance_type;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
500: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 500: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

496: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
500: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
501: ,P_SQLCODE => SQLCODE
502: ,P_SQLERRM => SQLERRM
503: ,X_MSG_COUNT => X_MSG_COUNT
504: ,X_MSG_DATA => X_MSG_DATA

Line 512: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

508: ROLLBACK TO svpt_set_inheritance_type;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
511: p_data => x_msg_data);
512: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 516: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

512: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
517: ,P_SQLCODE => SQLCODE
518: ,P_SQLERRM => SQLERRM
519: ,X_MSG_COUNT => X_MSG_COUNT
520: ,X_MSG_DATA => X_MSG_DATA

Line 532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
529: END IF;
530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
531: p_data => x_msg_data);
532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
533: P_API_NAME => L_API_NAME
534: ,P_PKG_NAME => G_PKG_NAME
535: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
536: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 535: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

531: p_data => x_msg_data);
532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
533: P_API_NAME => L_API_NAME
534: ,P_PKG_NAME => G_PKG_NAME
535: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
536: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,X_MSG_COUNT => X_MSG_COUNT

Line 536: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
533: P_API_NAME => L_API_NAME
534: ,P_PKG_NAME => G_PKG_NAME
535: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
536: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,X_MSG_COUNT => X_MSG_COUNT
540: ,X_MSG_DATA => X_MSG_DATA

Line 688: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

684: ROLLBACK TO svpt_remove_instance;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
687: p_data => x_msg_data);
688: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
692: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 692: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

688: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
692: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
693: ,P_SQLCODE => SQLCODE
694: ,P_SQLERRM => SQLERRM
695: ,X_MSG_COUNT => X_MSG_COUNT
696: ,X_MSG_DATA => X_MSG_DATA

Line 704: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

700: ROLLBACK TO svpt_remove_instance;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
703: p_data => x_msg_data);
704: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME
707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
708: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 708: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

704: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME
707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
708: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
709: ,P_SQLCODE => SQLCODE
710: ,P_SQLERRM => SQLERRM
711: ,X_MSG_COUNT => X_MSG_COUNT
712: ,X_MSG_DATA => X_MSG_DATA

Line 724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

720: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
721: END IF;
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
723: p_data => x_msg_data);
724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
725: P_API_NAME => L_API_NAME
726: ,P_PKG_NAME => G_PKG_NAME
727: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
728: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 727: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

723: p_data => x_msg_data);
724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
725: P_API_NAME => L_API_NAME
726: ,P_PKG_NAME => G_PKG_NAME
727: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
728: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
729: ,P_SQLCODE => SQLCODE
730: ,P_SQLERRM => SQLERRM
731: ,X_MSG_COUNT => X_MSG_COUNT

Line 728: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
725: P_API_NAME => L_API_NAME
726: ,P_PKG_NAME => G_PKG_NAME
727: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
728: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
729: ,P_SQLCODE => SQLCODE
730: ,P_SQLERRM => SQLERRM
731: ,X_MSG_COUNT => X_MSG_COUNT
732: ,X_MSG_DATA => X_MSG_DATA

Line 1087: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1083: ROLLBACK TO svpt_establish_inheritance;
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1086: p_data => x_msg_data);
1087: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1088: P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1091: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1091: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1087: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1088: P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1091: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1092: ,P_SQLCODE => SQLCODE
1093: ,P_SQLERRM => SQLERRM
1094: ,X_MSG_COUNT => X_MSG_COUNT
1095: ,X_MSG_DATA => X_MSG_DATA

Line 1103: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1099: ROLLBACK TO svpt_establish_inheritance;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1102: p_data => x_msg_data);
1103: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1107: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1107: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1103: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1107: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1108: ,P_SQLCODE => SQLCODE
1109: ,P_SQLERRM => SQLERRM
1110: ,X_MSG_COUNT => X_MSG_COUNT
1111: ,X_MSG_DATA => X_MSG_DATA

Line 1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1119: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1120: END IF;
1121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1126: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1122: p_data => x_msg_data);
1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1128: ,P_SQLCODE => SQLCODE
1129: ,P_SQLERRM => SQLERRM
1130: ,X_MSG_COUNT => X_MSG_COUNT

Line 1127: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1128: ,P_SQLCODE => SQLCODE
1129: ,P_SQLERRM => SQLERRM
1130: ,X_MSG_COUNT => X_MSG_COUNT
1131: ,X_MSG_DATA => X_MSG_DATA

Line 1379: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1375: ROLLBACK TO svpt_reset_permissions;
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data);
1379: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1380: P_API_NAME => L_API_NAME
1381: ,P_PKG_NAME => G_PKG_NAME
1382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1383: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1383: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1379: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1380: P_API_NAME => L_API_NAME
1381: ,P_PKG_NAME => G_PKG_NAME
1382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1383: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1384: ,P_SQLCODE => SQLCODE
1385: ,P_SQLERRM => SQLERRM
1386: ,X_MSG_COUNT => X_MSG_COUNT
1387: ,X_MSG_DATA => X_MSG_DATA

Line 1407: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1403: ROLLBACK TO svpt_reset_permissions;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1406: p_data => x_msg_data);
1407: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1408: P_API_NAME => L_API_NAME
1409: ,P_PKG_NAME => G_PKG_NAME
1410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1411: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1411: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1407: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1408: P_API_NAME => L_API_NAME
1409: ,P_PKG_NAME => G_PKG_NAME
1410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1411: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1412: ,P_SQLCODE => SQLCODE
1413: ,P_SQLERRM => SQLERRM
1414: ,X_MSG_COUNT => X_MSG_COUNT
1415: ,X_MSG_DATA => X_MSG_DATA

Line 1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1438: p_data => x_msg_data);
1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1440: P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1443: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1442: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1438: p_data => x_msg_data);
1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1440: P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1443: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1444: ,P_SQLCODE => SQLCODE
1445: ,P_SQLERRM => SQLERRM
1446: ,X_MSG_COUNT => X_MSG_COUNT

Line 1443: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1440: P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME
1442: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1443: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1444: ,P_SQLCODE => SQLCODE
1445: ,P_SQLERRM => SQLERRM
1446: ,X_MSG_COUNT => X_MSG_COUNT
1447: ,X_MSG_DATA => X_MSG_DATA

Line 1690: AND cascade_flag = IBC_UTILITIES_PVT.g_true)

1686: l_grant_group_id grant_group_id,
1687: action, grant_level + 1 grant_level, cascade_flag
1688: FROM ibc_grants
1689: WHERE grant_group_id = l_old_grant_group_id
1690: AND cascade_flag = IBC_UTILITIES_PVT.g_true)
1691: LOOP
1692: IBC_GRANTS_PKG.insert_row(
1693: PX_ROWID => l_rowid
1694: ,P_GRANT_ID => r_data.grant_id

Line 1741: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1737: ROLLBACK TO svpt_override_permissions;
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1740: p_data => x_msg_data);
1741: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1742: P_API_NAME => L_API_NAME
1743: ,P_PKG_NAME => G_PKG_NAME
1744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1745: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1745: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1741: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1742: P_API_NAME => L_API_NAME
1743: ,P_PKG_NAME => G_PKG_NAME
1744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1745: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1746: ,P_SQLCODE => SQLCODE
1747: ,P_SQLERRM => SQLERRM
1748: ,X_MSG_COUNT => X_MSG_COUNT
1749: ,X_MSG_DATA => X_MSG_DATA

Line 1769: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1765: ROLLBACK TO svpt_override_permissions;
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1768: p_data => x_msg_data);
1769: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1770: P_API_NAME => L_API_NAME
1771: ,P_PKG_NAME => G_PKG_NAME
1772: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1773: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1773: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1769: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1770: P_API_NAME => L_API_NAME
1771: ,P_PKG_NAME => G_PKG_NAME
1772: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1773: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1774: ,P_SQLCODE => SQLCODE
1775: ,P_SQLERRM => SQLERRM
1776: ,X_MSG_COUNT => X_MSG_COUNT
1777: ,X_MSG_DATA => X_MSG_DATA

Line 1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1802: P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1805: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1804: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1800: p_data => x_msg_data);
1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1802: P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1805: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1806: ,P_SQLCODE => SQLCODE
1807: ,P_SQLERRM => SQLERRM
1808: ,X_MSG_COUNT => X_MSG_COUNT

Line 1805: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1802: P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1805: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1806: ,P_SQLCODE => SQLCODE
1807: ,P_SQLERRM => SQLERRM
1808: ,X_MSG_COUNT => X_MSG_COUNT
1809: ,X_MSG_DATA => X_MSG_DATA

Line 1929: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true

1925: CURSOR c_object_grant_group_tree (p_object_grant_group_id NUMBER) IS
1926: SELECT LEVEL - 1 grant_level, ogg.*
1927: FROM ibc_object_grant_groups ogg
1928: CONNECT BY PRIOR object_grant_group_id = inherited_from
1929: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true
1930: START WITH object_grant_group_id = p_object_grant_group_id;
1931:
1932: -- Cursor to apply/propagate changes for ObjectGrantGroups with same old grant group id
1933: CURSOR c_ogg_tree_update (p_object_grant_group_id NUMBER,

Line 1940: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true

1936: FROM ibc_object_grant_groups ogg
1937: WHERE grant_group_id = p_grant_group_id
1938: AND inherited_flag = 'Y'
1939: CONNECT BY PRIOR object_grant_group_id = inherited_from
1940: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true
1941: START WITH inherited_from = p_object_grant_group_id;
1942:
1943:
1944: -- Cursor to check if permission code belongs to permission_object_id

Line 2214: AND cascade_flag = IBC_UTILITIES_PVT.g_true)

2210: l_grant_group_id grant_group_id,
2211: action, grant_level + 1 grant_level, cascade_flag
2212: FROM ibc_grants
2213: WHERE grant_group_id = l_old_grant_group_id
2214: AND cascade_flag = IBC_UTILITIES_PVT.g_true)
2215: LOOP
2216: IBC_GRANTS_PKG.insert_row(
2217: PX_ROWID => l_rowid
2218: ,P_GRANT_ID => r_data.grant_id

Line 2331: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2327: ROLLBACK TO svpt_grant_permission;
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2330: p_data => x_msg_data);
2331: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2332: P_API_NAME => L_API_NAME
2333: ,P_PKG_NAME => G_PKG_NAME
2334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2335: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2335: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2331: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2332: P_API_NAME => L_API_NAME
2333: ,P_PKG_NAME => G_PKG_NAME
2334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2335: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2336: ,P_SQLCODE => SQLCODE
2337: ,P_SQLERRM => SQLERRM
2338: ,X_MSG_COUNT => X_MSG_COUNT
2339: ,X_MSG_DATA => X_MSG_DATA

Line 2359: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2355: ROLLBACK TO svpt_grant_permission;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2358: p_data => x_msg_data);
2359: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2360: P_API_NAME => L_API_NAME
2361: ,P_PKG_NAME => G_PKG_NAME
2362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2363: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2363: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2359: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2360: P_API_NAME => L_API_NAME
2361: ,P_PKG_NAME => G_PKG_NAME
2362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2363: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2364: ,P_SQLCODE => SQLCODE
2365: ,P_SQLERRM => SQLERRM
2366: ,X_MSG_COUNT => X_MSG_COUNT
2367: ,X_MSG_DATA => X_MSG_DATA

Line 2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2388: END IF;
2389: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2390: p_data => x_msg_data);
2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2392: P_API_NAME => L_API_NAME
2393: ,P_PKG_NAME => G_PKG_NAME
2394: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2395: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2394: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

2390: p_data => x_msg_data);
2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2392: P_API_NAME => L_API_NAME
2393: ,P_PKG_NAME => G_PKG_NAME
2394: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2395: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2396: ,P_SQLCODE => SQLCODE
2397: ,P_SQLERRM => SQLERRM
2398: ,X_MSG_COUNT => X_MSG_COUNT

Line 2395: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2392: P_API_NAME => L_API_NAME
2393: ,P_PKG_NAME => G_PKG_NAME
2394: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2395: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2396: ,P_SQLCODE => SQLCODE
2397: ,P_SQLERRM => SQLERRM
2398: ,X_MSG_COUNT => X_MSG_COUNT
2399: ,X_MSG_DATA => X_MSG_DATA

Line 3041: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3037: ROLLBACK TO svpt_revoke_permission;
3038: x_return_status := FND_API.G_RET_STS_ERROR;
3039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3040: p_data => x_msg_data);
3041: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3042: P_API_NAME => L_API_NAME
3043: ,P_PKG_NAME => G_PKG_NAME
3044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3045: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3045: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3041: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3042: P_API_NAME => L_API_NAME
3043: ,P_PKG_NAME => G_PKG_NAME
3044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3045: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3046: ,P_SQLCODE => SQLCODE
3047: ,P_SQLERRM => SQLERRM
3048: ,X_MSG_COUNT => X_MSG_COUNT
3049: ,X_MSG_DATA => X_MSG_DATA

Line 3069: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3065: ROLLBACK TO svpt_revoke_permission;
3066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3067: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3068: p_data => x_msg_data);
3069: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3070: P_API_NAME => L_API_NAME
3071: ,P_PKG_NAME => G_PKG_NAME
3072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3073: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3073: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3069: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3070: P_API_NAME => L_API_NAME
3071: ,P_PKG_NAME => G_PKG_NAME
3072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3073: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3074: ,P_SQLCODE => SQLCODE
3075: ,P_SQLERRM => SQLERRM
3076: ,X_MSG_COUNT => X_MSG_COUNT
3077: ,X_MSG_DATA => X_MSG_DATA

Line 3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3097: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3098: END IF;
3099: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3100: p_data => x_msg_data);
3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3102: P_API_NAME => L_API_NAME
3103: ,P_PKG_NAME => G_PKG_NAME
3104: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3105: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3104: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

3100: p_data => x_msg_data);
3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3102: P_API_NAME => L_API_NAME
3103: ,P_PKG_NAME => G_PKG_NAME
3104: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3105: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3106: ,P_SQLCODE => SQLCODE
3107: ,P_SQLERRM => SQLERRM
3108: ,X_MSG_COUNT => X_MSG_COUNT

Line 3105: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3102: P_API_NAME => L_API_NAME
3103: ,P_PKG_NAME => G_PKG_NAME
3104: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3105: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3106: ,P_SQLCODE => SQLCODE
3107: ,P_SQLERRM => SQLERRM
3108: ,X_MSG_COUNT => X_MSG_COUNT
3109: ,X_MSG_DATA => X_MSG_DATA

Line 3335: OR cascade_flag = IBC_UTILITIES_PVT.g_true

3331: WHERE object_id = p_instance_object_id
3332: AND permission_code = p_permission_code
3333: AND grant_group_id = p_grant_group_id
3334: AND (p_inherited_flag = 'N'
3335: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3336: )
3337: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3338: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3339: grantee_resource_id, grantee_resource_type,

Line 3338: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

3334: AND (p_inherited_flag = 'N'
3335: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3336: )
3337: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3338: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3339: grantee_resource_id, grantee_resource_type,
3340: p_current_user_id) = 'TRUE')
3341: )
3342: ORDER BY DECODE(p_inheritance_type, 'FOLDER', 0, 'HIDDEN-FOLDER', 0, grant_level) asc,

Line 3521: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

3517: FROM ibc_grants a0
3518: WHERE object_id = p_instance_object_id
3519: AND grant_group_id = p_grant_group_id
3520: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3521: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3522: grantee_resource_id, grantee_resource_type,
3523: p_current_user_id) = 'TRUE')
3524: )
3525: AND action = 'ALLOW'

Line 3527: OR cascade_flag = IBC_UTILITIES_PVT.g_true

3523: p_current_user_id) = 'TRUE')
3524: )
3525: AND action = 'ALLOW'
3526: AND (p_inherited_flag = 'N'
3527: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3528: )
3529: AND NOT EXISTS (
3530: SELECT 'x'
3531: FROM ibc_grants a1

Line 3550: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

3546: 'RS_GROUP', 2,
3547: 'GROUP', 2,
3548: DECODE(a0.grantee_user_id, NULL, 3, 1))
3549: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3550: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3551: grantee_resource_id, grantee_resource_type,
3552: p_current_user_id) = 'TRUE')
3553: )
3554: )

Line 3756: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

3752: FROM ibc_grants a0
3753: WHERE object_id = p_instance_object_id
3754: AND grant_group_id = p_grant_group_id
3755: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3756: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3757: grantee_resource_id, grantee_resource_type,
3758: p_current_user_id) = 'TRUE')
3759: )
3760: AND action = 'ALLOW'

Line 3762: OR cascade_flag = IBC_UTILITIES_PVT.g_true

3758: p_current_user_id) = 'TRUE')
3759: )
3760: AND action = 'ALLOW'
3761: AND (p_inherited_flag = 'N'
3762: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3763: )
3764: AND NOT EXISTS (
3765: SELECT 'x'
3766: FROM ibc_grants a1

Line 3785: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

3781: 'RS_GROUP', 2,
3782: 'GROUP', 2,
3783: DECODE(a0.grantee_user_id, NULL, 3, 1))
3784: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3785: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,
3786: grantee_resource_id, grantee_resource_type,
3787: p_current_user_id) = 'TRUE')
3788: )
3789: )

Line 3901: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3897: WHEN FND_API.G_EXC_ERROR THEN
3898: x_return_status := FND_API.G_RET_STS_ERROR;
3899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3900: p_data => x_msg_data);
3901: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3902: P_API_NAME => L_API_NAME
3903: ,P_PKG_NAME => G_PKG_NAME
3904: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3905: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3905: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3901: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3902: P_API_NAME => L_API_NAME
3903: ,P_PKG_NAME => G_PKG_NAME
3904: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3905: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3906: ,P_SQLCODE => SQLCODE
3907: ,P_SQLERRM => SQLERRM
3908: ,X_MSG_COUNT => X_MSG_COUNT
3909: ,X_MSG_DATA => X_MSG_DATA

Line 3916: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3915: p_data => x_msg_data);
3916: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3917: P_API_NAME => L_API_NAME
3918: ,P_PKG_NAME => G_PKG_NAME
3919: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3920: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3920: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3916: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3917: P_API_NAME => L_API_NAME
3918: ,P_PKG_NAME => G_PKG_NAME
3919: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3920: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3921: ,P_SQLCODE => SQLCODE
3922: ,P_SQLERRM => SQLERRM
3923: ,X_MSG_COUNT => X_MSG_COUNT
3924: ,X_MSG_DATA => X_MSG_DATA

Line 3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3931: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3932: END IF;
3933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3934: p_data => x_msg_data);
3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3936: P_API_NAME => L_API_NAME
3937: ,P_PKG_NAME => G_PKG_NAME
3938: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3939: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3938: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

3934: p_data => x_msg_data);
3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3936: P_API_NAME => L_API_NAME
3937: ,P_PKG_NAME => G_PKG_NAME
3938: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3939: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3940: ,P_SQLCODE => SQLCODE
3941: ,P_SQLERRM => SQLERRM
3942: ,X_MSG_COUNT => X_MSG_COUNT

Line 3939: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3936: P_API_NAME => L_API_NAME
3937: ,P_PKG_NAME => G_PKG_NAME
3938: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
3939: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3940: ,P_SQLCODE => SQLCODE
3941: ,P_SQLERRM => SQLERRM
3942: ,X_MSG_COUNT => X_MSG_COUNT
3943: ,X_MSG_DATA => X_MSG_DATA

Line 4310: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4306: WHEN FND_API.G_EXC_ERROR THEN
4307: x_return_status := FND_API.G_RET_STS_ERROR;
4308: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4309: p_data => x_msg_data);
4310: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4311: P_API_NAME => L_API_NAME
4312: ,P_PKG_NAME => G_PKG_NAME
4313: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4314: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4314: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4310: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4311: P_API_NAME => L_API_NAME
4312: ,P_PKG_NAME => G_PKG_NAME
4313: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4314: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4315: ,P_SQLCODE => SQLCODE
4316: ,P_SQLERRM => SQLERRM
4317: ,X_MSG_COUNT => X_MSG_COUNT
4318: ,X_MSG_DATA => X_MSG_DATA

Line 4337: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4335: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4336: p_data => x_msg_data);
4337: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4338: P_API_NAME => L_API_NAME
4339: ,P_PKG_NAME => G_PKG_NAME
4340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4341: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4341: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4337: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4338: P_API_NAME => L_API_NAME
4339: ,P_PKG_NAME => G_PKG_NAME
4340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4341: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4342: ,P_SQLCODE => SQLCODE
4343: ,P_SQLERRM => SQLERRM
4344: ,X_MSG_COUNT => X_MSG_COUNT
4345: ,X_MSG_DATA => X_MSG_DATA

Line 4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4365: END IF;
4366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4367: p_data => x_msg_data);
4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4369: P_API_NAME => L_API_NAME
4370: ,P_PKG_NAME => G_PKG_NAME
4371: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4372: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4371: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

4367: p_data => x_msg_data);
4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4369: P_API_NAME => L_API_NAME
4370: ,P_PKG_NAME => G_PKG_NAME
4371: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4372: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4373: ,P_SQLCODE => SQLCODE
4374: ,P_SQLERRM => SQLERRM
4375: ,X_MSG_COUNT => X_MSG_COUNT

Line 4372: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4369: P_API_NAME => L_API_NAME
4370: ,P_PKG_NAME => G_PKG_NAME
4371: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4372: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4373: ,P_SQLCODE => SQLCODE
4374: ,P_SQLERRM => SQLERRM
4375: ,X_MSG_COUNT => X_MSG_COUNT
4376: ,X_MSG_DATA => X_MSG_DATA

Line 4601: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4597: WHEN FND_API.G_EXC_ERROR THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4600: p_data => x_msg_data);
4601: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4602: P_API_NAME => L_API_NAME
4603: ,P_PKG_NAME => G_PKG_NAME
4604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4605: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4605: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4601: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4602: P_API_NAME => L_API_NAME
4603: ,P_PKG_NAME => G_PKG_NAME
4604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4605: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4606: ,P_SQLCODE => SQLCODE
4607: ,P_SQLERRM => SQLERRM
4608: ,X_MSG_COUNT => X_MSG_COUNT
4609: ,X_MSG_DATA => X_MSG_DATA

Line 4616: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4615: p_data => x_msg_data);
4616: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4617: P_API_NAME => L_API_NAME
4618: ,P_PKG_NAME => G_PKG_NAME
4619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4620: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4620: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4616: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4617: P_API_NAME => L_API_NAME
4618: ,P_PKG_NAME => G_PKG_NAME
4619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4620: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4621: ,P_SQLCODE => SQLCODE
4622: ,P_SQLERRM => SQLERRM
4623: ,X_MSG_COUNT => X_MSG_COUNT
4624: ,X_MSG_DATA => X_MSG_DATA

Line 4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4632: END IF;
4633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4634: p_data => x_msg_data);
4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4636: P_API_NAME => L_API_NAME
4637: ,P_PKG_NAME => G_PKG_NAME
4638: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4639: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4638: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

4634: p_data => x_msg_data);
4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4636: P_API_NAME => L_API_NAME
4637: ,P_PKG_NAME => G_PKG_NAME
4638: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4639: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4640: ,P_SQLCODE => SQLCODE
4641: ,P_SQLERRM => SQLERRM
4642: ,X_MSG_COUNT => X_MSG_COUNT

Line 4639: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4636: P_API_NAME => L_API_NAME
4637: ,P_PKG_NAME => G_PKG_NAME
4638: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4639: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4640: ,P_SQLCODE => SQLCODE
4641: ,P_SQLERRM => SQLERRM
4642: ,X_MSG_COUNT => X_MSG_COUNT
4643: ,X_MSG_DATA => X_MSG_DATA

Line 4780: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4776: WHEN FND_API.G_EXC_ERROR THEN
4777: x_return_status := FND_API.G_RET_STS_ERROR;
4778: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4779: p_data => x_msg_data);
4780: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4781: P_API_NAME => L_API_NAME
4782: ,P_PKG_NAME => G_PKG_NAME
4783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4784: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4784: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4780: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4781: P_API_NAME => L_API_NAME
4782: ,P_PKG_NAME => G_PKG_NAME
4783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4784: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4785: ,P_SQLCODE => SQLCODE
4786: ,P_SQLERRM => SQLERRM
4787: ,X_MSG_COUNT => X_MSG_COUNT
4788: ,X_MSG_DATA => X_MSG_DATA

Line 4795: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4793: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4794: p_data => x_msg_data);
4795: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4796: P_API_NAME => L_API_NAME
4797: ,P_PKG_NAME => G_PKG_NAME
4798: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4799: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4795: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4796: P_API_NAME => L_API_NAME
4797: ,P_PKG_NAME => G_PKG_NAME
4798: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4800: ,P_SQLCODE => SQLCODE
4801: ,P_SQLERRM => SQLERRM
4802: ,X_MSG_COUNT => X_MSG_COUNT
4803: ,X_MSG_DATA => X_MSG_DATA

Line 4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4810: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4811: END IF;
4812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4813: p_data => x_msg_data);
4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4815: P_API_NAME => L_API_NAME
4816: ,P_PKG_NAME => G_PKG_NAME
4817: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4818: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 4817: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

4813: p_data => x_msg_data);
4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4815: P_API_NAME => L_API_NAME
4816: ,P_PKG_NAME => G_PKG_NAME
4817: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4818: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4819: ,P_SQLCODE => SQLCODE
4820: ,P_SQLERRM => SQLERRM
4821: ,X_MSG_COUNT => X_MSG_COUNT

Line 4818: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4815: P_API_NAME => L_API_NAME
4816: ,P_PKG_NAME => G_PKG_NAME
4817: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
4818: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4819: ,P_SQLCODE => SQLCODE
4820: ,P_SQLERRM => SQLERRM
4821: ,X_MSG_COUNT => X_MSG_COUNT
4822: ,X_MSG_DATA => X_MSG_DATA