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_SECURITY_INT dependencies on ASO_UTILITY_PVT

Line 539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

535: -- Girish Sachdeva 8/30/2005
536: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
537:
538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
540: END IF;
541:
542: -- Call to insert record in ASO_CHANGED_QUOTES
543: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 543: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
540: END IF;
541:
542: -- Call to insert record in ASO_CHANGED_QUOTES
543: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
544:
545: -- Change END
546:
547: -- End of API body

Line 566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

562: );
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
567: P_API_NAME => L_API_NAME,
568: P_PKG_NAME => G_PKG_NAME,
569: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
570: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 570: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
567: P_API_NAME => L_API_NAME,
568: P_PKG_NAME => G_PKG_NAME,
569: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
570: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
571: P_SQLCODE => SQLCODE,
572: P_SQLERRM => SQLERRM,
573: X_MSG_COUNT => X_MSG_COUNT,
574: X_MSG_DATA => X_MSG_DATA,

Line 579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

575: X_RETURN_STATUS => X_RETURN_STATUS
576: );
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME,
581: P_PKG_NAME => G_PKG_NAME,
582: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
583: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 583: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME,
581: P_PKG_NAME => G_PKG_NAME,
582: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
583: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
584: P_SQLCODE => SQLCODE,
585: P_SQLERRM => SQLERRM,
586: X_MSG_COUNT => X_MSG_COUNT,
587: X_MSG_DATA => X_MSG_DATA,

Line 592: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

588: X_RETURN_STATUS => X_RETURN_STATUS
589: );
590:
591: WHEN OTHERS THEN
592: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
593: P_API_NAME => L_API_NAME,
594: P_PKG_NAME => G_PKG_NAME,
595: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
596: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 595: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

591: WHEN OTHERS THEN
592: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
593: P_API_NAME => L_API_NAME,
594: P_PKG_NAME => G_PKG_NAME,
595: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
596: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
597: P_SQLCODE => SQLCODE,
598: P_SQLERRM => SQLERRM,
599: X_MSG_COUNT => X_MSG_COUNT,

Line 596: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

592: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
593: P_API_NAME => L_API_NAME,
594: P_PKG_NAME => G_PKG_NAME,
595: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
596: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
597: P_SQLCODE => SQLCODE,
598: P_SQLERRM => SQLERRM,
599: X_MSG_COUNT => X_MSG_COUNT,
600: X_MSG_DATA => X_MSG_DATA,

Line 900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

896: -- Girish Sachdeva 8/30/2005
897: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
898:
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
901: end if;
902:
903: -- Call to insert record in ASO_CHANGED_QUOTES
904: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 904: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
901: end if;
902:
903: -- Call to insert record in ASO_CHANGED_QUOTES
904: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
905:
906: -- Change END
907:
908: -- End of API body

Line 926: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

922: );
923:
924: EXCEPTION
925: WHEN FND_API.G_EXC_ERROR THEN
926: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
927: P_API_NAME => L_API_NAME,
928: P_PKG_NAME => G_PKG_NAME,
929: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
930: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 930: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

926: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
927: P_API_NAME => L_API_NAME,
928: P_PKG_NAME => G_PKG_NAME,
929: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
930: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
931: P_SQLCODE => SQLCODE,
932: P_SQLERRM => SQLERRM,
933: X_MSG_COUNT => X_MSG_COUNT,
934: X_MSG_DATA => X_MSG_DATA,

Line 939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

935: X_RETURN_STATUS => X_RETURN_STATUS
936: );
937:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME,
941: P_PKG_NAME => G_PKG_NAME,
942: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
943: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 943: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME,
941: P_PKG_NAME => G_PKG_NAME,
942: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
943: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
944: P_SQLCODE => SQLCODE,
945: P_SQLERRM => SQLERRM,
946: X_MSG_COUNT => X_MSG_COUNT,
947: X_MSG_DATA => X_MSG_DATA,

Line 952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

948: X_RETURN_STATUS => X_RETURN_STATUS
949: );
950:
951: WHEN OTHERS THEN
952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME,
954: P_PKG_NAME => G_PKG_NAME,
955: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
956: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 955: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

951: WHEN OTHERS THEN
952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME,
954: P_PKG_NAME => G_PKG_NAME,
955: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
956: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
957: P_SQLCODE => SQLCODE,
958: P_SQLERRM => SQLERRM,
959: X_MSG_COUNT => X_MSG_COUNT,

Line 956: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME,
954: P_PKG_NAME => G_PKG_NAME,
955: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
956: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
957: P_SQLCODE => SQLCODE,
958: P_SQLERRM => SQLERRM,
959: X_MSG_COUNT => X_MSG_COUNT,
960: X_MSG_DATA => X_MSG_DATA,

Line 1059: l_qte_access_rec.ROLE_ID := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_ROLE,p_qte_header_rec.org_id);

1055: CLOSE C_get_resource_role;
1056:
1057: -- if the resource does not have a group, get it from the QOT Params
1058: IF (l_qte_access_rec.ROLE_ID IS NULL OR l_qte_access_rec.ROLE_ID = FND_API.G_MISS_NUM) THEN
1059: l_qte_access_rec.ROLE_ID := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_ROLE,p_qte_header_rec.org_id);
1060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1061: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: getting role from QOT PARAMS ', 1, 'N');
1062: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1063: END IF;

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

1081: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1082: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: Before calling Get_Profile_Obsolete_Status', 1, 'N');
1083: END IF;
1084:
1085: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1086: p_application_id => 521);
1087:
1088: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1089: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 1209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1205: );
1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1210: P_API_NAME => L_API_NAME,
1211: P_PKG_NAME => G_PKG_NAME,
1212: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1213: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 1213: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1210: P_API_NAME => L_API_NAME,
1211: P_PKG_NAME => G_PKG_NAME,
1212: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1213: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1214: P_SQLCODE => SQLCODE,
1215: P_SQLERRM => SQLERRM,
1216: X_MSG_COUNT => X_MSG_COUNT,
1217: X_MSG_DATA => X_MSG_DATA,

Line 1222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1218: X_RETURN_STATUS => X_RETURN_STATUS
1219: );
1220:
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1223: P_API_NAME => L_API_NAME,
1224: P_PKG_NAME => G_PKG_NAME,
1225: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1226: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 1226: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1223: P_API_NAME => L_API_NAME,
1224: P_PKG_NAME => G_PKG_NAME,
1225: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1226: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1227: P_SQLCODE => SQLCODE,
1228: P_SQLERRM => SQLERRM,
1229: X_MSG_COUNT => X_MSG_COUNT,
1230: X_MSG_DATA => X_MSG_DATA,

Line 1235: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1231: X_RETURN_STATUS => X_RETURN_STATUS
1232: );
1233:
1234: WHEN OTHERS THEN
1235: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1236: P_API_NAME => L_API_NAME,
1237: P_PKG_NAME => G_PKG_NAME,
1238: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1239: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

Line 1238: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1234: WHEN OTHERS THEN
1235: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1236: P_API_NAME => L_API_NAME,
1237: P_PKG_NAME => G_PKG_NAME,
1238: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1239: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1240: P_SQLCODE => SQLCODE,
1241: P_SQLERRM => SQLERRM,
1242: X_MSG_COUNT => X_MSG_COUNT,

Line 1239: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1235: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1236: P_API_NAME => L_API_NAME,
1237: P_PKG_NAME => G_PKG_NAME,
1238: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1239: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1240: P_SQLCODE => SQLCODE,
1241: P_SQLERRM => SQLERRM,
1242: X_MSG_COUNT => X_MSG_COUNT,
1243: X_MSG_DATA => X_MSG_DATA,