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.ASO_PA_APR_INT dependencies on ASO_UTILITY_PVT

Line 662: aso_utility_pvt.handle_exceptions (

658: 1,
659: 'N'
660: );
661: END IF;
662: aso_utility_pvt.handle_exceptions (
663: p_api_name => l_api_name,
664: p_pkg_name => g_pkg_name,
665: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
666: p_package_type => aso_utility_pvt.g_int,

Line 666: p_package_type => aso_utility_pvt.g_int,

662: aso_utility_pvt.handle_exceptions (
663: p_api_name => l_api_name,
664: p_pkg_name => g_pkg_name,
665: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
666: p_package_type => aso_utility_pvt.g_int,
667: p_sqlcode => SQLCODE,
668: p_sqlerrm => SQLERRM,
669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data,

Line 682: aso_utility_pvt.handle_exceptions (

678: 1,
679: 'N'
680: );
681: END IF;
682: aso_utility_pvt.handle_exceptions (
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
686: p_package_type => aso_utility_pvt.g_int,

Line 686: p_package_type => aso_utility_pvt.g_int,

682: aso_utility_pvt.handle_exceptions (
683: p_api_name => l_api_name,
684: p_pkg_name => g_pkg_name,
685: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
686: p_package_type => aso_utility_pvt.g_int,
687: p_sqlcode => SQLCODE,
688: p_sqlerrm => SQLERRM,
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,

Line 702: aso_utility_pvt.handle_exceptions (

698: 1,
699: 'N'
700: );
701: END IF;
702: aso_utility_pvt.handle_exceptions (
703: p_api_name => l_api_name,
704: p_pkg_name => g_pkg_name,
705: p_exception_level => aso_utility_pvt.g_exc_others,
706: p_package_type => aso_utility_pvt.g_int,

Line 705: p_exception_level => aso_utility_pvt.g_exc_others,

701: END IF;
702: aso_utility_pvt.handle_exceptions (
703: p_api_name => l_api_name,
704: p_pkg_name => g_pkg_name,
705: p_exception_level => aso_utility_pvt.g_exc_others,
706: p_package_type => aso_utility_pvt.g_int,
707: p_sqlcode => SQLCODE,
708: p_sqlerrm => SQLERRM,
709: x_msg_count => x_msg_count,

Line 706: p_package_type => aso_utility_pvt.g_int,

702: aso_utility_pvt.handle_exceptions (
703: p_api_name => l_api_name,
704: p_pkg_name => g_pkg_name,
705: p_exception_level => aso_utility_pvt.g_exc_others,
706: p_package_type => aso_utility_pvt.g_int,
707: p_sqlcode => SQLCODE,
708: p_sqlerrm => SQLERRM,
709: x_msg_count => x_msg_count,
710: x_msg_data => x_msg_data,

Line 896: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');

892: -- Get the Requester Group id
893: begin
894:
895: IF aso_debug_pub.g_debug_flag = 'Y' THEN
896: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
897: END IF;
898:
899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
900: p_application_id => 521);

Line 899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',

895: IF aso_debug_pub.g_debug_flag = 'Y' THEN
896: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
897: END IF;
898:
899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
900: p_application_id => 521);
901:
902: IF aso_debug_pub.g_debug_flag = 'Y' THEN
903: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 1142: aso_utility_pvt.handle_exceptions (

1138: 1,
1139: 'N'
1140: );
1141: END IF;
1142: aso_utility_pvt.handle_exceptions (
1143: p_api_name => l_api_name,
1144: p_pkg_name => g_pkg_name,
1145: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1146: p_package_type => aso_utility_pvt.g_int,

Line 1146: p_package_type => aso_utility_pvt.g_int,

1142: aso_utility_pvt.handle_exceptions (
1143: p_api_name => l_api_name,
1144: p_pkg_name => g_pkg_name,
1145: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1146: p_package_type => aso_utility_pvt.g_int,
1147: p_sqlcode => SQLCODE,
1148: p_sqlerrm => SQLERRM,
1149: x_msg_count => x_msg_count,
1150: x_msg_data => x_msg_data,

Line 1162: aso_utility_pvt.handle_exceptions (

1158: 1,
1159: 'N'
1160: );
1161: END IF;
1162: aso_utility_pvt.handle_exceptions (
1163: p_api_name => l_api_name,
1164: p_pkg_name => g_pkg_name,
1165: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1166: p_package_type => aso_utility_pvt.g_int,

Line 1166: p_package_type => aso_utility_pvt.g_int,

1162: aso_utility_pvt.handle_exceptions (
1163: p_api_name => l_api_name,
1164: p_pkg_name => g_pkg_name,
1165: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1166: p_package_type => aso_utility_pvt.g_int,
1167: p_sqlcode => SQLCODE,
1168: p_sqlerrm => SQLERRM,
1169: x_msg_count => x_msg_count,
1170: x_msg_data => x_msg_data,

Line 1183: aso_utility_pvt.handle_exceptions (

1179: 1,
1180: 'N'
1181: );
1182: END IF;
1183: aso_utility_pvt.handle_exceptions (
1184: p_api_name => l_api_name,
1185: p_pkg_name => g_pkg_name,
1186: p_exception_level => aso_utility_pvt.g_exc_others,
1187: p_package_type => aso_utility_pvt.g_int,

Line 1186: p_exception_level => aso_utility_pvt.g_exc_others,

1182: END IF;
1183: aso_utility_pvt.handle_exceptions (
1184: p_api_name => l_api_name,
1185: p_pkg_name => g_pkg_name,
1186: p_exception_level => aso_utility_pvt.g_exc_others,
1187: p_package_type => aso_utility_pvt.g_int,
1188: p_sqlcode => SQLCODE,
1189: p_sqlerrm => SQLERRM,
1190: x_msg_count => x_msg_count,

Line 1187: p_package_type => aso_utility_pvt.g_int,

1183: aso_utility_pvt.handle_exceptions (
1184: p_api_name => l_api_name,
1185: p_pkg_name => g_pkg_name,
1186: p_exception_level => aso_utility_pvt.g_exc_others,
1187: p_package_type => aso_utility_pvt.g_int,
1188: p_sqlcode => SQLCODE,
1189: p_sqlerrm => SQLERRM,
1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data,

Line 1408: aso_utility_pvt.handle_exceptions (

1404: 1,
1405: 'N'
1406: );
1407: END IF;
1408: aso_utility_pvt.handle_exceptions (
1409: p_api_name => l_api_name,
1410: p_pkg_name => g_pkg_name,
1411: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1412: p_package_type => aso_utility_pvt.g_int,

Line 1412: p_package_type => aso_utility_pvt.g_int,

1408: aso_utility_pvt.handle_exceptions (
1409: p_api_name => l_api_name,
1410: p_pkg_name => g_pkg_name,
1411: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1412: p_package_type => aso_utility_pvt.g_int,
1413: p_sqlcode => SQLCODE,
1414: p_sqlerrm => SQLERRM,
1415: x_msg_count => x_msg_count,
1416: x_msg_data => x_msg_data,

Line 1428: aso_utility_pvt.handle_exceptions (

1424: 1,
1425: 'N'
1426: );
1427: END IF;
1428: aso_utility_pvt.handle_exceptions (
1429: p_api_name => l_api_name,
1430: p_pkg_name => g_pkg_name,
1431: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1432: p_package_type => aso_utility_pvt.g_int,

Line 1432: p_package_type => aso_utility_pvt.g_int,

1428: aso_utility_pvt.handle_exceptions (
1429: p_api_name => l_api_name,
1430: p_pkg_name => g_pkg_name,
1431: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1432: p_package_type => aso_utility_pvt.g_int,
1433: p_sqlcode => SQLCODE,
1434: p_sqlerrm => SQLERRM,
1435: x_msg_count => x_msg_count,
1436: x_msg_data => x_msg_data,

Line 1448: aso_utility_pvt.handle_exceptions (

1444: 1,
1445: 'N'
1446: );
1447: END IF;
1448: aso_utility_pvt.handle_exceptions (
1449: p_api_name => l_api_name,
1450: p_pkg_name => g_pkg_name,
1451: p_exception_level => aso_utility_pvt.g_exc_others,
1452: p_package_type => aso_utility_pvt.g_int,

Line 1451: p_exception_level => aso_utility_pvt.g_exc_others,

1447: END IF;
1448: aso_utility_pvt.handle_exceptions (
1449: p_api_name => l_api_name,
1450: p_pkg_name => g_pkg_name,
1451: p_exception_level => aso_utility_pvt.g_exc_others,
1452: p_package_type => aso_utility_pvt.g_int,
1453: p_sqlcode => SQLCODE,
1454: p_sqlerrm => SQLERRM,
1455: x_msg_count => x_msg_count,

Line 1452: p_package_type => aso_utility_pvt.g_int,

1448: aso_utility_pvt.handle_exceptions (
1449: p_api_name => l_api_name,
1450: p_pkg_name => g_pkg_name,
1451: p_exception_level => aso_utility_pvt.g_exc_others,
1452: p_package_type => aso_utility_pvt.g_int,
1453: p_sqlcode => SQLCODE,
1454: p_sqlerrm => SQLERRM,
1455: x_msg_count => x_msg_count,
1456: x_msg_data => x_msg_data,

Line 1607: aso_utility_pvt.handle_exceptions (

1603:
1604: EXCEPTION
1605: WHEN fnd_api.g_exc_error
1606: THEN
1607: aso_utility_pvt.handle_exceptions (
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1611: p_package_type => aso_utility_pvt.g_int,

Line 1611: p_package_type => aso_utility_pvt.g_int,

1607: aso_utility_pvt.handle_exceptions (
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1611: p_package_type => aso_utility_pvt.g_int,
1612: p_sqlcode => SQLCODE,
1613: p_sqlerrm => SQLERRM,
1614: x_msg_count => x_msg_count,
1615: x_msg_data => x_msg_data,

Line 1620: aso_utility_pvt.handle_exceptions (

1616: x_return_status => x_return_status
1617: );
1618: WHEN fnd_api.g_exc_unexpected_error
1619: THEN
1620: aso_utility_pvt.handle_exceptions (
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1624: p_package_type => aso_utility_pvt.g_int,

Line 1624: p_package_type => aso_utility_pvt.g_int,

1620: aso_utility_pvt.handle_exceptions (
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1624: p_package_type => aso_utility_pvt.g_int,
1625: p_sqlcode => SQLCODE,
1626: p_sqlerrm => SQLERRM,
1627: x_msg_count => x_msg_count,
1628: x_msg_data => x_msg_data,

Line 1633: aso_utility_pvt.handle_exceptions (

1629: x_return_status => x_return_status
1630: );
1631: WHEN OTHERS
1632: THEN
1633: aso_utility_pvt.handle_exceptions (
1634: p_api_name => l_api_name,
1635: p_pkg_name => g_pkg_name,
1636: p_exception_level => aso_utility_pvt.g_exc_others,
1637: p_package_type => aso_utility_pvt.g_int,

Line 1636: p_exception_level => aso_utility_pvt.g_exc_others,

1632: THEN
1633: aso_utility_pvt.handle_exceptions (
1634: p_api_name => l_api_name,
1635: p_pkg_name => g_pkg_name,
1636: p_exception_level => aso_utility_pvt.g_exc_others,
1637: p_package_type => aso_utility_pvt.g_int,
1638: p_sqlcode => SQLCODE,
1639: p_sqlerrm => SQLERRM,
1640: x_msg_count => x_msg_count,

Line 1637: p_package_type => aso_utility_pvt.g_int,

1633: aso_utility_pvt.handle_exceptions (
1634: p_api_name => l_api_name,
1635: p_pkg_name => g_pkg_name,
1636: p_exception_level => aso_utility_pvt.g_exc_others,
1637: p_package_type => aso_utility_pvt.g_int,
1638: p_sqlcode => SQLCODE,
1639: p_sqlerrm => SQLERRM,
1640: x_msg_count => x_msg_count,
1641: x_msg_data => x_msg_data,

Line 1827: aso_utility_pvt.handle_exceptions (

1823:
1824: EXCEPTION
1825: WHEN fnd_api.g_exc_error
1826: THEN
1827: aso_utility_pvt.handle_exceptions (
1828: p_api_name => l_api_name,
1829: p_pkg_name => g_pkg_name,
1830: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1831: p_package_type => aso_utility_pvt.g_int,

Line 1831: p_package_type => aso_utility_pvt.g_int,

1827: aso_utility_pvt.handle_exceptions (
1828: p_api_name => l_api_name,
1829: p_pkg_name => g_pkg_name,
1830: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1831: p_package_type => aso_utility_pvt.g_int,
1832: p_sqlcode => SQLCODE,
1833: p_sqlerrm => SQLERRM,
1834: x_msg_count => x_msg_count,
1835: x_msg_data => x_msg_data,

Line 1840: aso_utility_pvt.handle_exceptions (

1836: x_return_status => x_return_status
1837: );
1838: WHEN fnd_api.g_exc_unexpected_error
1839: THEN
1840: aso_utility_pvt.handle_exceptions (
1841: p_api_name => l_api_name,
1842: p_pkg_name => g_pkg_name,
1843: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1844: p_package_type => aso_utility_pvt.g_int,

Line 1844: p_package_type => aso_utility_pvt.g_int,

1840: aso_utility_pvt.handle_exceptions (
1841: p_api_name => l_api_name,
1842: p_pkg_name => g_pkg_name,
1843: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1844: p_package_type => aso_utility_pvt.g_int,
1845: p_sqlcode => SQLCODE,
1846: p_sqlerrm => SQLERRM,
1847: x_msg_count => x_msg_count,
1848: x_msg_data => x_msg_data,

Line 1853: aso_utility_pvt.handle_exceptions (

1849: x_return_status => x_return_status
1850: );
1851: WHEN OTHERS
1852: THEN
1853: aso_utility_pvt.handle_exceptions (
1854: p_api_name => l_api_name,
1855: p_pkg_name => g_pkg_name,
1856: p_exception_level => aso_utility_pvt.g_exc_others,
1857: p_package_type => aso_utility_pvt.g_int,

Line 1856: p_exception_level => aso_utility_pvt.g_exc_others,

1852: THEN
1853: aso_utility_pvt.handle_exceptions (
1854: p_api_name => l_api_name,
1855: p_pkg_name => g_pkg_name,
1856: p_exception_level => aso_utility_pvt.g_exc_others,
1857: p_package_type => aso_utility_pvt.g_int,
1858: p_sqlcode => SQLCODE,
1859: p_sqlerrm => SQLERRM,
1860: x_msg_count => x_msg_count,

Line 1857: p_package_type => aso_utility_pvt.g_int,

1853: aso_utility_pvt.handle_exceptions (
1854: p_api_name => l_api_name,
1855: p_pkg_name => g_pkg_name,
1856: p_exception_level => aso_utility_pvt.g_exc_others,
1857: p_package_type => aso_utility_pvt.g_int,
1858: p_sqlcode => SQLCODE,
1859: p_sqlerrm => SQLERRM,
1860: x_msg_count => x_msg_count,
1861: x_msg_data => x_msg_data,

Line 2111: aso_utility_pvt.handle_exceptions (

2107: exception
2108:
2109: WHEN fnd_api.g_exc_error
2110: THEN
2111: aso_utility_pvt.handle_exceptions (
2112: p_api_name => l_api_name,
2113: p_pkg_name => g_pkg_name,
2114: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
2115: p_package_type => aso_utility_pvt.g_int,

Line 2115: p_package_type => aso_utility_pvt.g_int,

2111: aso_utility_pvt.handle_exceptions (
2112: p_api_name => l_api_name,
2113: p_pkg_name => g_pkg_name,
2114: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
2115: p_package_type => aso_utility_pvt.g_int,
2116: p_sqlcode => SQLCODE,
2117: p_sqlerrm => SQLERRM,
2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data,

Line 2124: aso_utility_pvt.handle_exceptions (

2120: x_return_status => x_return_status
2121: );
2122: WHEN fnd_api.g_exc_unexpected_error
2123: THEN
2124: aso_utility_pvt.handle_exceptions (
2125: p_api_name => l_api_name,
2126: p_pkg_name => g_pkg_name,
2127: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
2128: p_package_type => aso_utility_pvt.g_int,

Line 2128: p_package_type => aso_utility_pvt.g_int,

2124: aso_utility_pvt.handle_exceptions (
2125: p_api_name => l_api_name,
2126: p_pkg_name => g_pkg_name,
2127: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
2128: p_package_type => aso_utility_pvt.g_int,
2129: p_sqlcode => SQLCODE,
2130: p_sqlerrm => SQLERRM,
2131: x_msg_count => x_msg_count,
2132: x_msg_data => x_msg_data,

Line 2137: aso_utility_pvt.handle_exceptions (

2133: x_return_status => x_return_status
2134: );
2135: WHEN OTHERS
2136: THEN
2137: aso_utility_pvt.handle_exceptions (
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exception_level => aso_utility_pvt.g_exc_others,
2141: p_package_type => aso_utility_pvt.g_int,

Line 2140: p_exception_level => aso_utility_pvt.g_exc_others,

2136: THEN
2137: aso_utility_pvt.handle_exceptions (
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exception_level => aso_utility_pvt.g_exc_others,
2141: p_package_type => aso_utility_pvt.g_int,
2142: p_sqlcode => SQLCODE,
2143: p_sqlerrm => SQLERRM,
2144: x_msg_count => x_msg_count,

Line 2141: p_package_type => aso_utility_pvt.g_int,

2137: aso_utility_pvt.handle_exceptions (
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exception_level => aso_utility_pvt.g_exc_others,
2141: p_package_type => aso_utility_pvt.g_int,
2142: p_sqlcode => SQLCODE,
2143: p_sqlerrm => SQLERRM,
2144: x_msg_count => x_msg_count,
2145: x_msg_data => x_msg_data,