1288: x_return_status := FND_API.G_RET_STS_SUCCESS;
1289:
1290: -- Begin
1291:
1292: IF IBC_DEBUG_PVT.debug_enabled THEN
1293: IBC_DEBUG_PVT.start_process(
1294: p_proc_type => 'PROCEDURE',
1295: p_proc_name => 'Reset_Permissions',
1296: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1289:
1290: -- Begin
1291:
1292: IF IBC_DEBUG_PVT.debug_enabled THEN
1293: IBC_DEBUG_PVT.start_process(
1294: p_proc_type => 'PROCEDURE',
1295: p_proc_name => 'Reset_Permissions',
1296: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1297: p_tag => 'PARAMETERS',
1292: IF IBC_DEBUG_PVT.debug_enabled THEN
1293: IBC_DEBUG_PVT.start_process(
1294: p_proc_type => 'PROCEDURE',
1295: p_proc_name => 'Reset_Permissions',
1296: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1297: p_tag => 'PARAMETERS',
1298: p_parms => JTF_VARCHAR2_TABLE_4000(
1299: 'p_instance_object_id', p_instance_object_id,
1300: 'p_instance_pk1_value', p_instance_pk1_value,
1356: -- Standard call to get message count and if count=1, get the message
1357: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1358: p_data => x_msg_data);
1359:
1360: IF IBC_DEBUG_PVT.debug_enabled THEN
1361: IBC_DEBUG_PVT.end_process(
1362: IBC_DEBUG_PVT.make_parameter_list(
1363: p_tag => 'OUTPUT',
1364: p_parms => JTF_VARCHAR2_TABLE_4000(
1357: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1358: p_data => x_msg_data);
1359:
1360: IF IBC_DEBUG_PVT.debug_enabled THEN
1361: IBC_DEBUG_PVT.end_process(
1362: IBC_DEBUG_PVT.make_parameter_list(
1363: p_tag => 'OUTPUT',
1364: p_parms => JTF_VARCHAR2_TABLE_4000(
1365: 'x_return_status', x_return_status,
1358: p_data => x_msg_data);
1359:
1360: IF IBC_DEBUG_PVT.debug_enabled THEN
1361: IBC_DEBUG_PVT.end_process(
1362: IBC_DEBUG_PVT.make_parameter_list(
1363: p_tag => 'OUTPUT',
1364: p_parms => JTF_VARCHAR2_TABLE_4000(
1365: 'x_return_status', x_return_status,
1366: 'x_msg_count', x_msg_count,
1386: ,X_MSG_COUNT => X_MSG_COUNT
1387: ,X_MSG_DATA => X_MSG_DATA
1388: ,X_RETURN_STATUS => X_RETURN_STATUS
1389: );
1390: IF IBC_DEBUG_PVT.debug_enabled THEN
1391: IBC_DEBUG_PVT.end_process(
1392: IBC_DEBUG_PVT.make_parameter_list(
1393: p_tag => 'OUTPUT',
1394: p_parms => JTF_VARCHAR2_TABLE_4000(
1387: ,X_MSG_DATA => X_MSG_DATA
1388: ,X_RETURN_STATUS => X_RETURN_STATUS
1389: );
1390: IF IBC_DEBUG_PVT.debug_enabled THEN
1391: IBC_DEBUG_PVT.end_process(
1392: IBC_DEBUG_PVT.make_parameter_list(
1393: p_tag => 'OUTPUT',
1394: p_parms => JTF_VARCHAR2_TABLE_4000(
1395: 'x_return_status', x_return_status,
1388: ,X_RETURN_STATUS => X_RETURN_STATUS
1389: );
1390: IF IBC_DEBUG_PVT.debug_enabled THEN
1391: IBC_DEBUG_PVT.end_process(
1392: IBC_DEBUG_PVT.make_parameter_list(
1393: p_tag => 'OUTPUT',
1394: p_parms => JTF_VARCHAR2_TABLE_4000(
1395: 'x_return_status', x_return_status,
1396: 'x_msg_count', x_msg_count,
1414: ,X_MSG_COUNT => X_MSG_COUNT
1415: ,X_MSG_DATA => X_MSG_DATA
1416: ,X_RETURN_STATUS => X_RETURN_STATUS
1417: );
1418: IF IBC_DEBUG_PVT.debug_enabled THEN
1419: IBC_DEBUG_PVT.end_process(
1420: IBC_DEBUG_PVT.make_parameter_list(
1421: p_tag => 'OUTPUT',
1422: p_parms => JTF_VARCHAR2_TABLE_4000(
1415: ,X_MSG_DATA => X_MSG_DATA
1416: ,X_RETURN_STATUS => X_RETURN_STATUS
1417: );
1418: IF IBC_DEBUG_PVT.debug_enabled THEN
1419: IBC_DEBUG_PVT.end_process(
1420: IBC_DEBUG_PVT.make_parameter_list(
1421: p_tag => 'OUTPUT',
1422: p_parms => JTF_VARCHAR2_TABLE_4000(
1423: 'x_return_status', x_return_status,
1416: ,X_RETURN_STATUS => X_RETURN_STATUS
1417: );
1418: IF IBC_DEBUG_PVT.debug_enabled THEN
1419: IBC_DEBUG_PVT.end_process(
1420: IBC_DEBUG_PVT.make_parameter_list(
1421: p_tag => 'OUTPUT',
1422: p_parms => JTF_VARCHAR2_TABLE_4000(
1423: 'x_return_status', x_return_status,
1424: 'x_msg_count', x_msg_count,
1446: ,X_MSG_COUNT => X_MSG_COUNT
1447: ,X_MSG_DATA => X_MSG_DATA
1448: ,X_RETURN_STATUS => X_RETURN_STATUS
1449: );
1450: IF IBC_DEBUG_PVT.debug_enabled THEN
1451: IBC_DEBUG_PVT.end_process(
1452: IBC_DEBUG_PVT.make_parameter_list(
1453: p_tag => 'OUTPUT',
1454: p_parms => JTF_VARCHAR2_TABLE_4000(
1447: ,X_MSG_DATA => X_MSG_DATA
1448: ,X_RETURN_STATUS => X_RETURN_STATUS
1449: );
1450: IF IBC_DEBUG_PVT.debug_enabled THEN
1451: IBC_DEBUG_PVT.end_process(
1452: IBC_DEBUG_PVT.make_parameter_list(
1453: p_tag => 'OUTPUT',
1454: p_parms => JTF_VARCHAR2_TABLE_4000(
1455: 'x_return_status', x_return_status,
1448: ,X_RETURN_STATUS => X_RETURN_STATUS
1449: );
1450: IF IBC_DEBUG_PVT.debug_enabled THEN
1451: IBC_DEBUG_PVT.end_process(
1452: IBC_DEBUG_PVT.make_parameter_list(
1453: p_tag => 'OUTPUT',
1454: p_parms => JTF_VARCHAR2_TABLE_4000(
1455: 'x_return_status', x_return_status,
1456: 'x_msg_count', x_msg_count,
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;
1569:
1570: -- Begin
1571:
1572: IF IBC_DEBUG_PVT.debug_enabled THEN
1573: IBC_DEBUG_PVT.start_process(
1574: p_proc_type => 'PROCEDURE',
1575: p_proc_name => 'Override_Permissions',
1576: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1569:
1570: -- Begin
1571:
1572: IF IBC_DEBUG_PVT.debug_enabled THEN
1573: IBC_DEBUG_PVT.start_process(
1574: p_proc_type => 'PROCEDURE',
1575: p_proc_name => 'Override_Permissions',
1576: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1577: p_tag => 'PARAMETERS',
1572: IF IBC_DEBUG_PVT.debug_enabled THEN
1573: IBC_DEBUG_PVT.start_process(
1574: p_proc_type => 'PROCEDURE',
1575: p_proc_name => 'Override_Permissions',
1576: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1577: p_tag => 'PARAMETERS',
1578: p_parms => JTF_VARCHAR2_TABLE_4000(
1579: 'p_instance_object_id', p_instance_object_id,
1580: 'p_instance_pk1_value', p_instance_pk1_value,
1656: ,p_inheritance_type => r_data.inheritance_type
1657: );
1658: END LOOP;
1659:
1660: IBC_DEBUG_PVT.debug_message('** l_object_grant_group_id:' || l_object_grant_group_id ||
1661: ' l_old_grant_group_id: ' || l_old_grant_group_id);
1662:
1663: FOR r_tree_ogg IN c_ogg_tree_update (l_object_grant_group_id,
1664: l_old_grant_group_id)
1718: -- Standard call to get message count and if count=1, get the message
1719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1720: p_data => x_msg_data);
1721:
1722: IF IBC_DEBUG_PVT.debug_enabled THEN
1723: IBC_DEBUG_PVT.end_process(
1724: IBC_DEBUG_PVT.make_parameter_list(
1725: p_tag => 'OUTPUT',
1726: p_parms => JTF_VARCHAR2_TABLE_4000(
1719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1720: p_data => x_msg_data);
1721:
1722: IF IBC_DEBUG_PVT.debug_enabled THEN
1723: IBC_DEBUG_PVT.end_process(
1724: IBC_DEBUG_PVT.make_parameter_list(
1725: p_tag => 'OUTPUT',
1726: p_parms => JTF_VARCHAR2_TABLE_4000(
1727: 'x_return_status', x_return_status,
1720: p_data => x_msg_data);
1721:
1722: IF IBC_DEBUG_PVT.debug_enabled THEN
1723: IBC_DEBUG_PVT.end_process(
1724: IBC_DEBUG_PVT.make_parameter_list(
1725: p_tag => 'OUTPUT',
1726: p_parms => JTF_VARCHAR2_TABLE_4000(
1727: 'x_return_status', x_return_status,
1728: 'x_msg_count', x_msg_count,
1748: ,X_MSG_COUNT => X_MSG_COUNT
1749: ,X_MSG_DATA => X_MSG_DATA
1750: ,X_RETURN_STATUS => X_RETURN_STATUS
1751: );
1752: IF IBC_DEBUG_PVT.debug_enabled THEN
1753: IBC_DEBUG_PVT.end_process(
1754: IBC_DEBUG_PVT.make_parameter_list(
1755: p_tag => 'OUTPUT',
1756: p_parms => JTF_VARCHAR2_TABLE_4000(
1749: ,X_MSG_DATA => X_MSG_DATA
1750: ,X_RETURN_STATUS => X_RETURN_STATUS
1751: );
1752: IF IBC_DEBUG_PVT.debug_enabled THEN
1753: IBC_DEBUG_PVT.end_process(
1754: IBC_DEBUG_PVT.make_parameter_list(
1755: p_tag => 'OUTPUT',
1756: p_parms => JTF_VARCHAR2_TABLE_4000(
1757: 'x_return_status', x_return_status,
1750: ,X_RETURN_STATUS => X_RETURN_STATUS
1751: );
1752: IF IBC_DEBUG_PVT.debug_enabled THEN
1753: IBC_DEBUG_PVT.end_process(
1754: IBC_DEBUG_PVT.make_parameter_list(
1755: p_tag => 'OUTPUT',
1756: p_parms => JTF_VARCHAR2_TABLE_4000(
1757: 'x_return_status', x_return_status,
1758: 'x_msg_count', x_msg_count,
1776: ,X_MSG_COUNT => X_MSG_COUNT
1777: ,X_MSG_DATA => X_MSG_DATA
1778: ,X_RETURN_STATUS => X_RETURN_STATUS
1779: );
1780: IF IBC_DEBUG_PVT.debug_enabled THEN
1781: IBC_DEBUG_PVT.end_process(
1782: IBC_DEBUG_PVT.make_parameter_list(
1783: p_tag => 'OUTPUT',
1784: p_parms => JTF_VARCHAR2_TABLE_4000(
1777: ,X_MSG_DATA => X_MSG_DATA
1778: ,X_RETURN_STATUS => X_RETURN_STATUS
1779: );
1780: IF IBC_DEBUG_PVT.debug_enabled THEN
1781: IBC_DEBUG_PVT.end_process(
1782: IBC_DEBUG_PVT.make_parameter_list(
1783: p_tag => 'OUTPUT',
1784: p_parms => JTF_VARCHAR2_TABLE_4000(
1785: 'x_return_status', x_return_status,
1778: ,X_RETURN_STATUS => X_RETURN_STATUS
1779: );
1780: IF IBC_DEBUG_PVT.debug_enabled THEN
1781: IBC_DEBUG_PVT.end_process(
1782: IBC_DEBUG_PVT.make_parameter_list(
1783: p_tag => 'OUTPUT',
1784: p_parms => JTF_VARCHAR2_TABLE_4000(
1785: 'x_return_status', x_return_status,
1786: 'x_msg_count', x_msg_count,
1808: ,X_MSG_COUNT => X_MSG_COUNT
1809: ,X_MSG_DATA => X_MSG_DATA
1810: ,X_RETURN_STATUS => X_RETURN_STATUS
1811: );
1812: IF IBC_DEBUG_PVT.debug_enabled THEN
1813: IBC_DEBUG_PVT.end_process(
1814: IBC_DEBUG_PVT.make_parameter_list(
1815: p_tag => 'OUTPUT',
1816: p_parms => JTF_VARCHAR2_TABLE_4000(
1809: ,X_MSG_DATA => X_MSG_DATA
1810: ,X_RETURN_STATUS => X_RETURN_STATUS
1811: );
1812: IF IBC_DEBUG_PVT.debug_enabled THEN
1813: IBC_DEBUG_PVT.end_process(
1814: IBC_DEBUG_PVT.make_parameter_list(
1815: p_tag => 'OUTPUT',
1816: p_parms => JTF_VARCHAR2_TABLE_4000(
1817: 'x_return_status', x_return_status,
1810: ,X_RETURN_STATUS => X_RETURN_STATUS
1811: );
1812: IF IBC_DEBUG_PVT.debug_enabled THEN
1813: IBC_DEBUG_PVT.end_process(
1814: IBC_DEBUG_PVT.make_parameter_list(
1815: p_tag => 'OUTPUT',
1816: p_parms => JTF_VARCHAR2_TABLE_4000(
1817: 'x_return_status', x_return_status,
1818: 'x_msg_count', x_msg_count,
1977:
1978: -- Begin
1979:
1980:
1981: IF IBC_DEBUG_PVT.debug_enabled THEN
1982: IBC_DEBUG_PVT.start_process(
1983: p_proc_type => 'PROCEDURE',
1984: p_proc_name => 'Grant_Permission',
1985: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1978: -- Begin
1979:
1980:
1981: IF IBC_DEBUG_PVT.debug_enabled THEN
1982: IBC_DEBUG_PVT.start_process(
1983: p_proc_type => 'PROCEDURE',
1984: p_proc_name => 'Grant_Permission',
1985: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1986: p_tag => 'PARAMETERS',
1981: IF IBC_DEBUG_PVT.debug_enabled THEN
1982: IBC_DEBUG_PVT.start_process(
1983: p_proc_type => 'PROCEDURE',
1984: p_proc_name => 'Grant_Permission',
1985: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1986: p_tag => 'PARAMETERS',
1987: p_parms => JTF_VARCHAR2_TABLE_4000(
1988: 'p_instance_object_id', p_instance_object_id,
1989: 'p_instance_pk1_value', p_instance_pk1_value,
2178: ,p_inheritance_type => r_data.inheritance_type
2179: );
2180: END LOOP;
2181:
2182: IBC_DEBUG_PVT.debug_message('** l_object_grant_group_id:' || l_object_grant_group_id ||
2183: ' l_old_grant_group_id: ' || l_old_grant_group_id);
2184:
2185: FOR r_ogg IN c_ogg_tree_update (l_object_grant_group_id,
2186: l_old_grant_group_id)
2308: -- Standard call to get message count and if count=1, get the message
2309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2310: p_data => x_msg_data);
2311:
2312: IF IBC_DEBUG_PVT.debug_enabled THEN
2313: IBC_DEBUG_PVT.end_process(
2314: IBC_DEBUG_PVT.make_parameter_list(
2315: p_tag => 'OUTPUT',
2316: p_parms => JTF_VARCHAR2_TABLE_4000(
2309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2310: p_data => x_msg_data);
2311:
2312: IF IBC_DEBUG_PVT.debug_enabled THEN
2313: IBC_DEBUG_PVT.end_process(
2314: IBC_DEBUG_PVT.make_parameter_list(
2315: p_tag => 'OUTPUT',
2316: p_parms => JTF_VARCHAR2_TABLE_4000(
2317: 'x_return_status', x_return_status,
2310: p_data => x_msg_data);
2311:
2312: IF IBC_DEBUG_PVT.debug_enabled THEN
2313: IBC_DEBUG_PVT.end_process(
2314: IBC_DEBUG_PVT.make_parameter_list(
2315: p_tag => 'OUTPUT',
2316: p_parms => JTF_VARCHAR2_TABLE_4000(
2317: 'x_return_status', x_return_status,
2318: 'x_msg_count', x_msg_count,
2338: ,X_MSG_COUNT => X_MSG_COUNT
2339: ,X_MSG_DATA => X_MSG_DATA
2340: ,X_RETURN_STATUS => X_RETURN_STATUS
2341: );
2342: IF IBC_DEBUG_PVT.debug_enabled THEN
2343: IBC_DEBUG_PVT.end_process(
2344: IBC_DEBUG_PVT.make_parameter_list(
2345: p_tag => 'OUTPUT',
2346: p_parms => JTF_VARCHAR2_TABLE_4000(
2339: ,X_MSG_DATA => X_MSG_DATA
2340: ,X_RETURN_STATUS => X_RETURN_STATUS
2341: );
2342: IF IBC_DEBUG_PVT.debug_enabled THEN
2343: IBC_DEBUG_PVT.end_process(
2344: IBC_DEBUG_PVT.make_parameter_list(
2345: p_tag => 'OUTPUT',
2346: p_parms => JTF_VARCHAR2_TABLE_4000(
2347: 'x_return_status', x_return_status,
2340: ,X_RETURN_STATUS => X_RETURN_STATUS
2341: );
2342: IF IBC_DEBUG_PVT.debug_enabled THEN
2343: IBC_DEBUG_PVT.end_process(
2344: IBC_DEBUG_PVT.make_parameter_list(
2345: p_tag => 'OUTPUT',
2346: p_parms => JTF_VARCHAR2_TABLE_4000(
2347: 'x_return_status', x_return_status,
2348: 'x_msg_count', x_msg_count,
2366: ,X_MSG_COUNT => X_MSG_COUNT
2367: ,X_MSG_DATA => X_MSG_DATA
2368: ,X_RETURN_STATUS => X_RETURN_STATUS
2369: );
2370: IF IBC_DEBUG_PVT.debug_enabled THEN
2371: IBC_DEBUG_PVT.end_process(
2372: IBC_DEBUG_PVT.make_parameter_list(
2373: p_tag => 'OUTPUT',
2374: p_parms => JTF_VARCHAR2_TABLE_4000(
2367: ,X_MSG_DATA => X_MSG_DATA
2368: ,X_RETURN_STATUS => X_RETURN_STATUS
2369: );
2370: IF IBC_DEBUG_PVT.debug_enabled THEN
2371: IBC_DEBUG_PVT.end_process(
2372: IBC_DEBUG_PVT.make_parameter_list(
2373: p_tag => 'OUTPUT',
2374: p_parms => JTF_VARCHAR2_TABLE_4000(
2375: 'x_return_status', x_return_status,
2368: ,X_RETURN_STATUS => X_RETURN_STATUS
2369: );
2370: IF IBC_DEBUG_PVT.debug_enabled THEN
2371: IBC_DEBUG_PVT.end_process(
2372: IBC_DEBUG_PVT.make_parameter_list(
2373: p_tag => 'OUTPUT',
2374: p_parms => JTF_VARCHAR2_TABLE_4000(
2375: 'x_return_status', x_return_status,
2376: 'x_msg_count', x_msg_count,
2398: ,X_MSG_COUNT => X_MSG_COUNT
2399: ,X_MSG_DATA => X_MSG_DATA
2400: ,X_RETURN_STATUS => X_RETURN_STATUS
2401: );
2402: IF IBC_DEBUG_PVT.debug_enabled THEN
2403: IBC_DEBUG_PVT.end_process(
2404: IBC_DEBUG_PVT.make_parameter_list(
2405: p_tag => 'OUTPUT',
2406: p_parms => JTF_VARCHAR2_TABLE_4000(
2399: ,X_MSG_DATA => X_MSG_DATA
2400: ,X_RETURN_STATUS => X_RETURN_STATUS
2401: );
2402: IF IBC_DEBUG_PVT.debug_enabled THEN
2403: IBC_DEBUG_PVT.end_process(
2404: IBC_DEBUG_PVT.make_parameter_list(
2405: p_tag => 'OUTPUT',
2406: p_parms => JTF_VARCHAR2_TABLE_4000(
2407: 'x_return_status', x_return_status,
2400: ,X_RETURN_STATUS => X_RETURN_STATUS
2401: );
2402: IF IBC_DEBUG_PVT.debug_enabled THEN
2403: IBC_DEBUG_PVT.end_process(
2404: IBC_DEBUG_PVT.make_parameter_list(
2405: p_tag => 'OUTPUT',
2406: p_parms => JTF_VARCHAR2_TABLE_4000(
2407: 'x_return_status', x_return_status,
2408: 'x_msg_count', x_msg_count,
2731:
2732: -- Begin
2733:
2734:
2735: IF IBC_DEBUG_PVT.debug_enabled THEN
2736: IBC_DEBUG_PVT.start_process(
2737: p_proc_type => 'PROCEDURE',
2738: p_proc_name => 'Revoke_Permission',
2739: p_parms => IBC_DEBUG_PVT.make_parameter_list(
2732: -- Begin
2733:
2734:
2735: IF IBC_DEBUG_PVT.debug_enabled THEN
2736: IBC_DEBUG_PVT.start_process(
2737: p_proc_type => 'PROCEDURE',
2738: p_proc_name => 'Revoke_Permission',
2739: p_parms => IBC_DEBUG_PVT.make_parameter_list(
2740: p_tag => 'PARAMETERS',
2735: IF IBC_DEBUG_PVT.debug_enabled THEN
2736: IBC_DEBUG_PVT.start_process(
2737: p_proc_type => 'PROCEDURE',
2738: p_proc_name => 'Revoke_Permission',
2739: p_parms => IBC_DEBUG_PVT.make_parameter_list(
2740: p_tag => 'PARAMETERS',
2741: p_parms => JTF_VARCHAR2_TABLE_4000(
2742: 'p_instance_object_id', p_instance_object_id,
2743: 'p_instance_pk1_value', p_instance_pk1_value,
2773: ,x_inherited_flag => l_inherited_flag
2774: ,x_inherited_from => l_inherited_from
2775: ,x_inheritance_type => l_inheritance_type
2776: );
2777: IBC_DEBUG_PVT.debug_message('GRANT_GROUP_ROWID=' || l_object_grant_group_rowid);
2778:
2779: IF l_object_grant_group_rowid IS NOT NULL THEN
2780:
2781:
2906: ' AND grant_level = :p_grant_level';
2907: ELSIF r_object_grant_group.grant_level > 0 THEN
2908: EXIT;
2909: END IF;
2910: IBC_DEBUG_PVT.debug_message(l_curr_statement);
2911: l_count := 0;
2912:
2913: IF p_grantee_user_id IS NOT NULL THEN
2914: IF r_object_grant_group.inheritance_type = 'FULL' THEN
2947: END IF;
2948: END IF;
2949:
2950: LOOP
2951: IBC_DEBUG_PVT.debug_message('LOOP');
2952: FETCH l_cursor INTO l_grant_id;
2953: EXIT WHEN l_cursor%NOTFOUND;
2954: l_count := l_count + 1;
2955: IBC_GRANTS_PKG.delete_row(l_grant_id);
3018: -- Standard call to get message count and if count=1, get the message
3019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3020: p_data => x_msg_data);
3021:
3022: IF IBC_DEBUG_PVT.debug_enabled THEN
3023: IBC_DEBUG_PVT.end_process(
3024: IBC_DEBUG_PVT.make_parameter_list(
3025: p_tag => 'OUTPUT',
3026: p_parms => JTF_VARCHAR2_TABLE_4000(
3019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3020: p_data => x_msg_data);
3021:
3022: IF IBC_DEBUG_PVT.debug_enabled THEN
3023: IBC_DEBUG_PVT.end_process(
3024: IBC_DEBUG_PVT.make_parameter_list(
3025: p_tag => 'OUTPUT',
3026: p_parms => JTF_VARCHAR2_TABLE_4000(
3027: 'x_return_status', x_return_status,
3020: p_data => x_msg_data);
3021:
3022: IF IBC_DEBUG_PVT.debug_enabled THEN
3023: IBC_DEBUG_PVT.end_process(
3024: IBC_DEBUG_PVT.make_parameter_list(
3025: p_tag => 'OUTPUT',
3026: p_parms => JTF_VARCHAR2_TABLE_4000(
3027: 'x_return_status', x_return_status,
3028: 'x_msg_count', x_msg_count,
3048: ,X_MSG_COUNT => X_MSG_COUNT
3049: ,X_MSG_DATA => X_MSG_DATA
3050: ,X_RETURN_STATUS => X_RETURN_STATUS
3051: );
3052: IF IBC_DEBUG_PVT.debug_enabled THEN
3053: IBC_DEBUG_PVT.end_process(
3054: IBC_DEBUG_PVT.make_parameter_list(
3055: p_tag => 'OUTPUT',
3056: p_parms => JTF_VARCHAR2_TABLE_4000(
3049: ,X_MSG_DATA => X_MSG_DATA
3050: ,X_RETURN_STATUS => X_RETURN_STATUS
3051: );
3052: IF IBC_DEBUG_PVT.debug_enabled THEN
3053: IBC_DEBUG_PVT.end_process(
3054: IBC_DEBUG_PVT.make_parameter_list(
3055: p_tag => 'OUTPUT',
3056: p_parms => JTF_VARCHAR2_TABLE_4000(
3057: 'x_return_status', x_return_status,
3050: ,X_RETURN_STATUS => X_RETURN_STATUS
3051: );
3052: IF IBC_DEBUG_PVT.debug_enabled THEN
3053: IBC_DEBUG_PVT.end_process(
3054: IBC_DEBUG_PVT.make_parameter_list(
3055: p_tag => 'OUTPUT',
3056: p_parms => JTF_VARCHAR2_TABLE_4000(
3057: 'x_return_status', x_return_status,
3058: 'x_msg_count', x_msg_count,
3076: ,X_MSG_COUNT => X_MSG_COUNT
3077: ,X_MSG_DATA => X_MSG_DATA
3078: ,X_RETURN_STATUS => X_RETURN_STATUS
3079: );
3080: IF IBC_DEBUG_PVT.debug_enabled THEN
3081: IBC_DEBUG_PVT.end_process(
3082: IBC_DEBUG_PVT.make_parameter_list(
3083: p_tag => 'OUTPUT',
3084: p_parms => JTF_VARCHAR2_TABLE_4000(
3077: ,X_MSG_DATA => X_MSG_DATA
3078: ,X_RETURN_STATUS => X_RETURN_STATUS
3079: );
3080: IF IBC_DEBUG_PVT.debug_enabled THEN
3081: IBC_DEBUG_PVT.end_process(
3082: IBC_DEBUG_PVT.make_parameter_list(
3083: p_tag => 'OUTPUT',
3084: p_parms => JTF_VARCHAR2_TABLE_4000(
3085: 'x_return_status', x_return_status,
3078: ,X_RETURN_STATUS => X_RETURN_STATUS
3079: );
3080: IF IBC_DEBUG_PVT.debug_enabled THEN
3081: IBC_DEBUG_PVT.end_process(
3082: IBC_DEBUG_PVT.make_parameter_list(
3083: p_tag => 'OUTPUT',
3084: p_parms => JTF_VARCHAR2_TABLE_4000(
3085: 'x_return_status', x_return_status,
3086: 'x_msg_count', x_msg_count,
3108: ,X_MSG_COUNT => X_MSG_COUNT
3109: ,X_MSG_DATA => X_MSG_DATA
3110: ,X_RETURN_STATUS => X_RETURN_STATUS
3111: );
3112: IF IBC_DEBUG_PVT.debug_enabled THEN
3113: IBC_DEBUG_PVT.end_process(
3114: IBC_DEBUG_PVT.make_parameter_list(
3115: p_tag => 'OUTPUT',
3116: p_parms => JTF_VARCHAR2_TABLE_4000(
3109: ,X_MSG_DATA => X_MSG_DATA
3110: ,X_RETURN_STATUS => X_RETURN_STATUS
3111: );
3112: IF IBC_DEBUG_PVT.debug_enabled THEN
3113: IBC_DEBUG_PVT.end_process(
3114: IBC_DEBUG_PVT.make_parameter_list(
3115: p_tag => 'OUTPUT',
3116: p_parms => JTF_VARCHAR2_TABLE_4000(
3117: 'x_return_status', x_return_status,
3110: ,X_RETURN_STATUS => X_RETURN_STATUS
3111: );
3112: IF IBC_DEBUG_PVT.debug_enabled THEN
3113: IBC_DEBUG_PVT.end_process(
3114: IBC_DEBUG_PVT.make_parameter_list(
3115: p_tag => 'OUTPUT',
3116: p_parms => JTF_VARCHAR2_TABLE_4000(
3117: 'x_return_status', x_return_status,
3118: 'x_msg_count', x_msg_count,
3348: action;
3349:
3350: BEGIN
3351:
3352: IF IBC_DEBUG_PVT.debug_enabled THEN
3353: IBC_DEBUG_PVT.start_process(
3354: p_proc_type => 'PROCEDURE',
3355: p_proc_name => 'has_permission',
3356: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3349:
3350: BEGIN
3351:
3352: IF IBC_DEBUG_PVT.debug_enabled THEN
3353: IBC_DEBUG_PVT.start_process(
3354: p_proc_type => 'PROCEDURE',
3355: p_proc_name => 'has_permission',
3356: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3357: p_tag => 'PARAMETERS',
3352: IF IBC_DEBUG_PVT.debug_enabled THEN
3353: IBC_DEBUG_PVT.start_process(
3354: p_proc_type => 'PROCEDURE',
3355: p_proc_name => 'has_permission',
3356: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3357: p_tag => 'PARAMETERS',
3358: p_parms => JTF_VARCHAR2_TABLE_4000(
3359: 'p_instance_object_id', p_instance_object_id,
3360: 'p_instance_pk1_value', p_instance_pk1_value,
3429: -- not set or not set to 'Y'
3430: l_result := FND_API.g_true;
3431: END IF;
3432:
3433: IF IBC_DEBUG_PVT.debug_enabled THEN
3434: IBC_DEBUG_PVT.end_process(
3435: IBC_DEBUG_PVT.make_parameter_list(
3436: p_tag => 'OUTPUT',
3437: p_parms => JTF_VARCHAR2_TABLE_4000(
3430: l_result := FND_API.g_true;
3431: END IF;
3432:
3433: IF IBC_DEBUG_PVT.debug_enabled THEN
3434: IBC_DEBUG_PVT.end_process(
3435: IBC_DEBUG_PVT.make_parameter_list(
3436: p_tag => 'OUTPUT',
3437: p_parms => JTF_VARCHAR2_TABLE_4000(
3438: 'RESULT', l_result
3431: END IF;
3432:
3433: IF IBC_DEBUG_PVT.debug_enabled THEN
3434: IBC_DEBUG_PVT.end_process(
3435: IBC_DEBUG_PVT.make_parameter_list(
3436: p_tag => 'OUTPUT',
3437: p_parms => JTF_VARCHAR2_TABLE_4000(
3438: 'RESULT', l_result
3439: )
3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: l_result := FND_API.g_false;
3449:
3450: IF IBC_DEBUG_PVT.debug_enabled THEN
3451: IBC_DEBUG_PVT.end_process(
3452: IBC_DEBUG_PVT.make_parameter_list(
3453: p_tag => 'OUTPUT',
3454: p_parms => JTF_VARCHAR2_TABLE_4000(
3447: WHEN OTHERS THEN
3448: l_result := FND_API.g_false;
3449:
3450: IF IBC_DEBUG_PVT.debug_enabled THEN
3451: IBC_DEBUG_PVT.end_process(
3452: IBC_DEBUG_PVT.make_parameter_list(
3453: p_tag => 'OUTPUT',
3454: p_parms => JTF_VARCHAR2_TABLE_4000(
3455: 'RESULT', l_result
3448: l_result := FND_API.g_false;
3449:
3450: IF IBC_DEBUG_PVT.debug_enabled THEN
3451: IBC_DEBUG_PVT.end_process(
3452: IBC_DEBUG_PVT.make_parameter_list(
3453: p_tag => 'OUTPUT',
3454: p_parms => JTF_VARCHAR2_TABLE_4000(
3455: 'RESULT', l_result
3456: )
3554: )
3555: ORDER BY grant_level asc, grantee_resource_id asc;
3556: BEGIN
3557:
3558: IF IBC_DEBUG_PVT.debug_enabled THEN
3559: IBC_DEBUG_PVT.start_process(
3560: p_proc_type => 'PROCEDURE',
3561: p_proc_name => 'Get_Permissions_As_String',
3562: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3555: ORDER BY grant_level asc, grantee_resource_id asc;
3556: BEGIN
3557:
3558: IF IBC_DEBUG_PVT.debug_enabled THEN
3559: IBC_DEBUG_PVT.start_process(
3560: p_proc_type => 'PROCEDURE',
3561: p_proc_name => 'Get_Permissions_As_String',
3562: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3563: p_tag => 'PARAMETERS',
3558: IF IBC_DEBUG_PVT.debug_enabled THEN
3559: IBC_DEBUG_PVT.start_process(
3560: p_proc_type => 'PROCEDURE',
3561: p_proc_name => 'Get_Permissions_As_String',
3562: p_parms => IBC_DEBUG_PVT.make_parameter_list(
3563: p_tag => 'PARAMETERS',
3564: p_parms => JTF_VARCHAR2_TABLE_4000(
3565: 'p_instance_object_id', p_instance_object_id,
3566: 'p_instance_pk1_value', p_instance_pk1_value,
3646: END IF;
3647: END LOOP;
3648: END IF;
3649:
3650: IF IBC_DEBUG_PVT.debug_enabled THEN
3651: IBC_DEBUG_PVT.end_process(
3652: IBC_DEBUG_PVT.make_parameter_list(
3653: p_tag => 'OUTPUT',
3654: p_parms => JTF_VARCHAR2_TABLE_4000(
3647: END LOOP;
3648: END IF;
3649:
3650: IF IBC_DEBUG_PVT.debug_enabled THEN
3651: IBC_DEBUG_PVT.end_process(
3652: IBC_DEBUG_PVT.make_parameter_list(
3653: p_tag => 'OUTPUT',
3654: p_parms => JTF_VARCHAR2_TABLE_4000(
3655: 'RESULT', l_result
3648: END IF;
3649:
3650: IF IBC_DEBUG_PVT.debug_enabled THEN
3651: IBC_DEBUG_PVT.end_process(
3652: IBC_DEBUG_PVT.make_parameter_list(
3653: p_tag => 'OUTPUT',
3654: p_parms => JTF_VARCHAR2_TABLE_4000(
3655: 'RESULT', l_result
3656: )
3662: RETURN l_result;
3663: -- Exception Handler Added for NOCOPY Change (11/08/2002) By ENUNEZ
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: IF IBC_DEBUG_PVT.debug_enabled THEN
3667: IBC_DEBUG_PVT.end_process(
3668: IBC_DEBUG_PVT.make_parameter_list(
3669: p_tag => 'OUTPUT',
3670: p_parms => JTF_VARCHAR2_TABLE_4000(
3663: -- Exception Handler Added for NOCOPY Change (11/08/2002) By ENUNEZ
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: IF IBC_DEBUG_PVT.debug_enabled THEN
3667: IBC_DEBUG_PVT.end_process(
3668: IBC_DEBUG_PVT.make_parameter_list(
3669: p_tag => 'OUTPUT',
3670: p_parms => JTF_VARCHAR2_TABLE_4000(
3671: 'RESULT', l_result,
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: IF IBC_DEBUG_PVT.debug_enabled THEN
3667: IBC_DEBUG_PVT.end_process(
3668: IBC_DEBUG_PVT.make_parameter_list(
3669: p_tag => 'OUTPUT',
3670: p_parms => JTF_VARCHAR2_TABLE_4000(
3671: 'RESULT', l_result,
3672: 'EXCEPTION', '****EXCEPTION:' || SQLERRM
4164: x_return_status := FND_API.G_RET_STS_SUCCESS;
4165:
4166: -- Begin
4167:
4168: IF IBC_DEBUG_PVT.debug_enabled THEN
4169: IBC_DEBUG_PVT.start_process(
4170: p_proc_type => 'PROCEDURE',
4171: p_proc_name => l_api_name,
4172: p_parms => IBC_DEBUG_PVT.make_parameter_list(
4165:
4166: -- Begin
4167:
4168: IF IBC_DEBUG_PVT.debug_enabled THEN
4169: IBC_DEBUG_PVT.start_process(
4170: p_proc_type => 'PROCEDURE',
4171: p_proc_name => l_api_name,
4172: p_parms => IBC_DEBUG_PVT.make_parameter_list(
4173: p_tag => 'PARAMETERS',
4168: IF IBC_DEBUG_PVT.debug_enabled THEN
4169: IBC_DEBUG_PVT.start_process(
4170: p_proc_type => 'PROCEDURE',
4171: p_proc_name => l_api_name,
4172: p_parms => IBC_DEBUG_PVT.make_parameter_list(
4173: p_tag => 'PARAMETERS',
4174: p_parms => JTF_VARCHAR2_TABLE_4000(
4175: 'p_instance_object_id', p_instance_object_id,
4176: 'p_instance_pk1_value', p_instance_pk1_value,
4287: -- Standard call to get message count and if count=1, get the message
4288: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4289: p_data => x_msg_data);
4290:
4291: IF IBC_DEBUG_PVT.debug_enabled THEN
4292: IBC_DEBUG_PVT.end_process(
4293: IBC_DEBUG_PVT.make_parameter_list(
4294: p_tag => 'OUTPUT',
4295: p_parms => JTF_VARCHAR2_TABLE_4000(
4288: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4289: p_data => x_msg_data);
4290:
4291: IF IBC_DEBUG_PVT.debug_enabled THEN
4292: IBC_DEBUG_PVT.end_process(
4293: IBC_DEBUG_PVT.make_parameter_list(
4294: p_tag => 'OUTPUT',
4295: p_parms => JTF_VARCHAR2_TABLE_4000(
4296: 'x_usernames', x_usernames,
4289: p_data => x_msg_data);
4290:
4291: IF IBC_DEBUG_PVT.debug_enabled THEN
4292: IBC_DEBUG_PVT.end_process(
4293: IBC_DEBUG_PVT.make_parameter_list(
4294: p_tag => 'OUTPUT',
4295: p_parms => JTF_VARCHAR2_TABLE_4000(
4296: 'x_usernames', x_usernames,
4297: 'x_return_status', x_return_status,
4317: ,X_MSG_COUNT => X_MSG_COUNT
4318: ,X_MSG_DATA => X_MSG_DATA
4319: ,X_RETURN_STATUS => X_RETURN_STATUS
4320: );
4321: IF IBC_DEBUG_PVT.debug_enabled THEN
4322: IBC_DEBUG_PVT.end_process(
4323: IBC_DEBUG_PVT.make_parameter_list(
4324: p_tag => 'OUTPUT',
4325: p_parms => JTF_VARCHAR2_TABLE_4000(
4318: ,X_MSG_DATA => X_MSG_DATA
4319: ,X_RETURN_STATUS => X_RETURN_STATUS
4320: );
4321: IF IBC_DEBUG_PVT.debug_enabled THEN
4322: IBC_DEBUG_PVT.end_process(
4323: IBC_DEBUG_PVT.make_parameter_list(
4324: p_tag => 'OUTPUT',
4325: p_parms => JTF_VARCHAR2_TABLE_4000(
4326: 'x_return_status', x_return_status,
4319: ,X_RETURN_STATUS => X_RETURN_STATUS
4320: );
4321: IF IBC_DEBUG_PVT.debug_enabled THEN
4322: IBC_DEBUG_PVT.end_process(
4323: IBC_DEBUG_PVT.make_parameter_list(
4324: p_tag => 'OUTPUT',
4325: p_parms => JTF_VARCHAR2_TABLE_4000(
4326: 'x_return_status', x_return_status,
4327: 'x_msg_count', x_msg_count,
4344: ,X_MSG_COUNT => X_MSG_COUNT
4345: ,X_MSG_DATA => X_MSG_DATA
4346: ,X_RETURN_STATUS => X_RETURN_STATUS
4347: );
4348: IF IBC_DEBUG_PVT.debug_enabled THEN
4349: IBC_DEBUG_PVT.end_process(
4350: IBC_DEBUG_PVT.make_parameter_list(
4351: p_tag => 'OUTPUT',
4352: p_parms => JTF_VARCHAR2_TABLE_4000(
4345: ,X_MSG_DATA => X_MSG_DATA
4346: ,X_RETURN_STATUS => X_RETURN_STATUS
4347: );
4348: IF IBC_DEBUG_PVT.debug_enabled THEN
4349: IBC_DEBUG_PVT.end_process(
4350: IBC_DEBUG_PVT.make_parameter_list(
4351: p_tag => 'OUTPUT',
4352: p_parms => JTF_VARCHAR2_TABLE_4000(
4353: 'x_return_status', x_return_status,
4346: ,X_RETURN_STATUS => X_RETURN_STATUS
4347: );
4348: IF IBC_DEBUG_PVT.debug_enabled THEN
4349: IBC_DEBUG_PVT.end_process(
4350: IBC_DEBUG_PVT.make_parameter_list(
4351: p_tag => 'OUTPUT',
4352: p_parms => JTF_VARCHAR2_TABLE_4000(
4353: 'x_return_status', x_return_status,
4354: 'x_msg_count', x_msg_count,
4375: ,X_MSG_COUNT => X_MSG_COUNT
4376: ,X_MSG_DATA => X_MSG_DATA
4377: ,X_RETURN_STATUS => X_RETURN_STATUS
4378: );
4379: IF IBC_DEBUG_PVT.debug_enabled THEN
4380: IBC_DEBUG_PVT.end_process(
4381: IBC_DEBUG_PVT.make_parameter_list(
4382: p_tag => 'OUTPUT',
4383: p_parms => JTF_VARCHAR2_TABLE_4000(
4376: ,X_MSG_DATA => X_MSG_DATA
4377: ,X_RETURN_STATUS => X_RETURN_STATUS
4378: );
4379: IF IBC_DEBUG_PVT.debug_enabled THEN
4380: IBC_DEBUG_PVT.end_process(
4381: IBC_DEBUG_PVT.make_parameter_list(
4382: p_tag => 'OUTPUT',
4383: p_parms => JTF_VARCHAR2_TABLE_4000(
4384: 'x_return_status', x_return_status,
4377: ,X_RETURN_STATUS => X_RETURN_STATUS
4378: );
4379: IF IBC_DEBUG_PVT.debug_enabled THEN
4380: IBC_DEBUG_PVT.end_process(
4381: IBC_DEBUG_PVT.make_parameter_list(
4382: p_tag => 'OUTPUT',
4383: p_parms => JTF_VARCHAR2_TABLE_4000(
4384: 'x_return_status', x_return_status,
4385: 'x_msg_count', x_msg_count,