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

Line 326: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);

322: -- Changes Done by : Girish
323: -- Comments : Using HR EIT in place of org striped profile
324:
325: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
326: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
327:
328: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
329: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
330:

Line 329: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);

325: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
326: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
327:
328: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
329: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
330:
331: -- Change End
332:
333:

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

685: IF aso_debug_pub.g_debug_flag = 'Y' THEN
686: aso_debug_pub.add('Assign_Sales_Team: Before calling Get_Profile_Obsolete_Status', 1, 'N');
687: END IF;
688:
689: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
690: p_application_id => 521);
691:
692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
693: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
882: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
883: END IF;
884:
885: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
886: p_application_id => 521);
887:
888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
889: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

1239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1240: aso_debug_pub.add('Assign_Sales_Team: Before calling Get_Profile_Obsolete_Status', 1, 'N');
1241: END IF;
1242:
1243: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1244: p_application_id => 521);
1245:
1246: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1247: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 1442: aso_debug_pub.add('ASO_SALES_TEAM_PVT.Assign_Sales_Team : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_Qte_Header_Rec.Quote_Number, 1, 'Y');

1438: -- Girish Sachdeva 8/30/2005
1439: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
1440:
1441: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1442: aso_debug_pub.add('ASO_SALES_TEAM_PVT.Assign_Sales_Team : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_Qte_Header_Rec.Quote_Number, 1, 'Y');
1443: END IF;
1444:
1445: -- Call to insert record in ASO_CHANGED_QUOTES
1446: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_Qte_Header_Rec.Quote_Number);

Line 1446: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_Qte_Header_Rec.Quote_Number);

1442: aso_debug_pub.add('ASO_SALES_TEAM_PVT.Assign_Sales_Team : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_Qte_Header_Rec.Quote_Number, 1, 'Y');
1443: END IF;
1444:
1445: -- Call to insert record in ASO_CHANGED_QUOTES
1446: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_Qte_Header_Rec.Quote_Number);
1447:
1448: -- Change END
1449:
1450:

Line 1456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1452: WHEN Leave_Proc THEN
1453: NULL;
1454:
1455: WHEN FND_API.G_EXC_ERROR THEN
1456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1457: P_API_NAME => L_API_NAME,
1458: P_PKG_NAME => G_PKG_NAME,
1459: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1460: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1460: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1457: P_API_NAME => L_API_NAME,
1458: P_PKG_NAME => G_PKG_NAME,
1459: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1460: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1461: P_SQLCODE => SQLCODE,
1462: P_SQLERRM => SQLERRM,
1463: X_MSG_COUNT => X_MSG_COUNT,
1464: X_MSG_DATA => X_MSG_DATA,

Line 1469: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1465: X_RETURN_STATUS => X_RETURN_STATUS
1466: );
1467:
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1470: P_API_NAME => L_API_NAME,
1471: P_PKG_NAME => G_PKG_NAME,
1472: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1473: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1473: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1469: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1470: P_API_NAME => L_API_NAME,
1471: P_PKG_NAME => G_PKG_NAME,
1472: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1473: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1474: P_SQLCODE => SQLCODE,
1475: P_SQLERRM => SQLERRM,
1476: X_MSG_COUNT => X_MSG_COUNT,
1477: X_MSG_DATA => X_MSG_DATA,

Line 1482: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1478: X_RETURN_STATUS => X_RETURN_STATUS
1479: );
1480:
1481: WHEN OTHERS THEN
1482: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1483: P_API_NAME => L_API_NAME,
1484: P_PKG_NAME => G_PKG_NAME,
1485: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1486: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1485: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1481: WHEN OTHERS THEN
1482: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1483: P_API_NAME => L_API_NAME,
1484: P_PKG_NAME => G_PKG_NAME,
1485: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1486: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1487: P_SQLCODE => SQLCODE,
1488: P_SQLERRM => SQLERRM,
1489: X_MSG_COUNT => X_MSG_COUNT,

Line 1486: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1482: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1483: P_API_NAME => L_API_NAME,
1484: P_PKG_NAME => G_PKG_NAME,
1485: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1486: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1487: P_SQLCODE => SQLCODE,
1488: P_SQLERRM => SQLERRM,
1489: X_MSG_COUNT => X_MSG_COUNT,
1490: X_MSG_DATA => X_MSG_DATA,

Line 1683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1679:
1680: EXCEPTION
1681:
1682: WHEN FND_API.G_EXC_ERROR THEN
1683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1684: P_API_NAME => L_API_NAME,
1685: P_PKG_NAME => G_PKG_NAME,
1686: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1687: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1687: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1684: P_API_NAME => L_API_NAME,
1685: P_PKG_NAME => G_PKG_NAME,
1686: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1687: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1688: P_SQLCODE => SQLCODE,
1689: P_SQLERRM => SQLERRM,
1690: X_MSG_COUNT => X_MSG_COUNT,
1691: X_MSG_DATA => X_MSG_DATA,

Line 1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1692: X_RETURN_STATUS => X_RETURN_STATUS
1693: );
1694:
1695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME,
1698: P_PKG_NAME => G_PKG_NAME,
1699: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1700: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1700: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME,
1698: P_PKG_NAME => G_PKG_NAME,
1699: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1700: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1701: P_SQLCODE => SQLCODE,
1702: P_SQLERRM => SQLERRM,
1703: X_MSG_COUNT => X_MSG_COUNT,
1704: X_MSG_DATA => X_MSG_DATA,

Line 1709: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1705: X_RETURN_STATUS => X_RETURN_STATUS
1706: );
1707:
1708: WHEN OTHERS THEN
1709: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1710: P_API_NAME => L_API_NAME,
1711: P_PKG_NAME => G_PKG_NAME,
1712: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1713: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1712: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1708: WHEN OTHERS THEN
1709: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1710: P_API_NAME => L_API_NAME,
1711: P_PKG_NAME => G_PKG_NAME,
1712: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1713: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1714: P_SQLCODE => SQLCODE,
1715: P_SQLERRM => SQLERRM,
1716: X_MSG_COUNT => X_MSG_COUNT,

Line 1713: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1709: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1710: P_API_NAME => L_API_NAME,
1711: P_PKG_NAME => G_PKG_NAME,
1712: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1713: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1714: P_SQLCODE => SQLCODE,
1715: P_SQLERRM => SQLERRM,
1716: X_MSG_COUNT => X_MSG_COUNT,
1717: X_MSG_DATA => X_MSG_DATA,

Line 1881: aso_utility_pvt.print_login_info();

1877: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.party_id: '||P_qte_header_rec.party_id,1,'N');
1878: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.cust_party_id: '||P_qte_header_rec.cust_party_id,1,'N');
1879: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.sold_to_party_site_id: '||P_qte_header_rec.sold_to_party_site_id,1,'N');
1880: aso_debug_pub.add('Before Calling JTY_ASSIGN_REALTIME_PUB.get_winners',1,'Y');
1881: aso_utility_pvt.print_login_info();
1882: END IF;
1883:
1884: -- Call the new JTF Terr Assignment API
1885: JTY_ASSIGN_REALTIME_PUB.get_winners (

Line 1904: aso_utility_pvt.print_login_info();

1900: X_winners_rec => X_Winners_Rec
1901: );
1902: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1903: aso_debug_pub.add('Get_Sales_Team: x_return_status '||x_return_status,1,'N');
1904: aso_utility_pvt.print_login_info();
1905: aso_debug_pub.add('Get_Sales_Team: lx_bulk_winners_rec.count: '||X_Winners_Rec.Resource_Id.count,1,'N');
1906: IF X_Winners_Rec.Resource_Id.count > 0 THEN
1907: FOR i IN X_Winners_Rec.Resource_Id.FIRST..X_Winners_Rec.Resource_Id.LAST LOOP
1908: aso_debug_pub.add('Get_Sales_Team: Trans_Object_Id: '||X_Winners_Rec.Trans_Object_Id(i),1,'N');

Line 1949: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1945:
1946: EXCEPTION
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1950: P_API_NAME => L_API_NAME,
1951: P_PKG_NAME => G_PKG_NAME,
1952: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1953: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1953: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1949: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1950: P_API_NAME => L_API_NAME,
1951: P_PKG_NAME => G_PKG_NAME,
1952: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1953: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1954: P_SQLCODE => SQLCODE,
1955: P_SQLERRM => SQLERRM,
1956: X_MSG_COUNT => X_MSG_COUNT,
1957: X_MSG_DATA => X_MSG_DATA,

Line 1962: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1958: X_RETURN_STATUS => X_RETURN_STATUS
1959: );
1960:
1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1962: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1963: P_API_NAME => L_API_NAME,
1964: P_PKG_NAME => G_PKG_NAME,
1965: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1966: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1966: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1962: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1963: P_API_NAME => L_API_NAME,
1964: P_PKG_NAME => G_PKG_NAME,
1965: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1966: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1967: P_SQLCODE => SQLCODE,
1968: P_SQLERRM => SQLERRM,
1969: X_MSG_COUNT => X_MSG_COUNT,
1970: X_MSG_DATA => X_MSG_DATA,

Line 1975: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1971: X_RETURN_STATUS => X_RETURN_STATUS
1972: );
1973:
1974: WHEN OTHERS THEN
1975: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1976: P_API_NAME => L_API_NAME,
1977: P_PKG_NAME => G_PKG_NAME,
1978: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1979: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1978: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1974: WHEN OTHERS THEN
1975: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1976: P_API_NAME => L_API_NAME,
1977: P_PKG_NAME => G_PKG_NAME,
1978: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1979: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1980: P_SQLCODE => SQLCODE,
1981: P_SQLERRM => SQLERRM,
1982: X_MSG_COUNT => X_MSG_COUNT,

Line 1979: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1975: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1976: P_API_NAME => L_API_NAME,
1977: P_PKG_NAME => G_PKG_NAME,
1978: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1979: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1980: P_SQLCODE => SQLCODE,
1981: P_SQLERRM => SQLERRM,
1982: X_MSG_COUNT => X_MSG_COUNT,
1983: X_MSG_DATA => X_MSG_DATA,

Line 2071: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);

2067: -- Changes Done by : Girish
2068: -- Comments : Using HR EIT in place of org striped profile
2069:
2070: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
2071: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
2072:
2073: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
2074: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
2075:

Line 2074: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);

2070: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
2071: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
2072:
2073: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
2074: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
2075:
2076: -- Change End
2077:
2078: l_ots_grp_prof VARCHAR2(50);

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

2167: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2168: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
2169: END IF;
2170:
2171: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
2172: p_application_id => 521);
2173:
2174: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2175: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 2340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2336:
2337: EXCEPTION
2338:
2339: WHEN FND_API.G_EXC_ERROR THEN
2340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2341: P_API_NAME => L_API_NAME,
2342: P_PKG_NAME => G_PKG_NAME,
2343: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2344: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2344: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2341: P_API_NAME => L_API_NAME,
2342: P_PKG_NAME => G_PKG_NAME,
2343: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2344: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2345: P_SQLCODE => SQLCODE,
2346: P_SQLERRM => SQLERRM,
2347: X_MSG_COUNT => X_MSG_COUNT,
2348: X_MSG_DATA => X_MSG_DATA,

Line 2353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2349: X_RETURN_STATUS => X_RETURN_STATUS
2350: );
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2354: P_API_NAME => L_API_NAME,
2355: P_PKG_NAME => G_PKG_NAME,
2356: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2357: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2357: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2354: P_API_NAME => L_API_NAME,
2355: P_PKG_NAME => G_PKG_NAME,
2356: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2357: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2358: P_SQLCODE => SQLCODE,
2359: P_SQLERRM => SQLERRM,
2360: X_MSG_COUNT => X_MSG_COUNT,
2361: X_MSG_DATA => X_MSG_DATA,

Line 2366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2362: X_RETURN_STATUS => X_RETURN_STATUS
2363: );
2364:
2365: WHEN OTHERS THEN
2366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2367: P_API_NAME => L_API_NAME,
2368: P_PKG_NAME => G_PKG_NAME,
2369: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2370: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2369: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

2365: WHEN OTHERS THEN
2366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2367: P_API_NAME => L_API_NAME,
2368: P_PKG_NAME => G_PKG_NAME,
2369: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2370: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2371: P_SQLCODE => SQLCODE,
2372: P_SQLERRM => SQLERRM,
2373: X_MSG_COUNT => X_MSG_COUNT,

Line 2370: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2367: P_API_NAME => L_API_NAME,
2368: P_PKG_NAME => G_PKG_NAME,
2369: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2370: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2371: P_SQLCODE => SQLCODE,
2372: P_SQLERRM => SQLERRM,
2373: X_MSG_COUNT => X_MSG_COUNT,
2374: X_MSG_DATA => X_MSG_DATA,

Line 2408: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);

2404: -- Changes Done by : Girish
2405: -- Comments : Using HR EIT in place of org striped profile
2406:
2407: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
2408: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
2409:
2410: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
2411: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
2412:

Line 2411: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);

2407: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
2408: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
2409:
2410: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
2411: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
2412:
2413: -- Change End
2414:
2415: l_ots_role_prof VARCHAR2(50) := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');

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

2586: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2587: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
2588: END IF;
2589:
2590: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
2591: p_application_id => 521);
2592:
2593: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2594: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

2755: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2756: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
2757: END IF;
2758:
2759: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
2760: p_application_id => 521);
2761:
2762: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2763: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 2918: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2914:
2915: EXCEPTION
2916:
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2919: P_API_NAME => L_API_NAME,
2920: P_PKG_NAME => G_PKG_NAME,
2921: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2922: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2922: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2918: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2919: P_API_NAME => L_API_NAME,
2920: P_PKG_NAME => G_PKG_NAME,
2921: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2922: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2923: P_SQLCODE => SQLCODE,
2924: P_SQLERRM => SQLERRM,
2925: X_MSG_COUNT => X_MSG_COUNT,
2926: X_MSG_DATA => X_MSG_DATA,

Line 2931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2927: X_RETURN_STATUS => X_RETURN_STATUS
2928: );
2929:
2930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2932: P_API_NAME => L_API_NAME,
2933: P_PKG_NAME => G_PKG_NAME,
2934: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2935: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2935: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2932: P_API_NAME => L_API_NAME,
2933: P_PKG_NAME => G_PKG_NAME,
2934: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2935: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2936: P_SQLCODE => SQLCODE,
2937: P_SQLERRM => SQLERRM,
2938: X_MSG_COUNT => X_MSG_COUNT,
2939: X_MSG_DATA => X_MSG_DATA,

Line 2944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2940: X_RETURN_STATUS => X_RETURN_STATUS
2941: );
2942:
2943: WHEN OTHERS THEN
2944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2945: P_API_NAME => L_API_NAME,
2946: P_PKG_NAME => G_PKG_NAME,
2947: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2948: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2947: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

2943: WHEN OTHERS THEN
2944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2945: P_API_NAME => L_API_NAME,
2946: P_PKG_NAME => G_PKG_NAME,
2947: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2948: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2949: P_SQLCODE => SQLCODE,
2950: P_SQLERRM => SQLERRM,
2951: X_MSG_COUNT => X_MSG_COUNT,

Line 2948: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2945: P_API_NAME => L_API_NAME,
2946: P_PKG_NAME => G_PKG_NAME,
2947: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2948: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2949: P_SQLCODE => SQLCODE,
2950: P_SQLERRM => SQLERRM,
2951: X_MSG_COUNT => X_MSG_COUNT,
2952: X_MSG_DATA => X_MSG_DATA,