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 50: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);

46: -- Changes Done by : Girish
47: -- Comments : Using HR EIT in place of org striped profile
48:
49: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
50: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
51:
52: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
53: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
54:

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

49: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
50: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
51:
52: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
53: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
54:
55: -- Change End
56:
57:

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

394: IF aso_debug_pub.g_debug_flag = 'Y' THEN
395: aso_debug_pub.add('Assign_Sales_Team: Before calling Get_Profile_Obsolete_Status', 1, 'N');
396: END IF;
397:
398: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
399: p_application_id => 521);
400:
401: IF aso_debug_pub.g_debug_flag = 'Y' THEN
402: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

590: IF aso_debug_pub.g_debug_flag = 'Y' THEN
591: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
592: END IF;
593:
594: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
595: p_application_id => 521);
596:
597: IF aso_debug_pub.g_debug_flag = 'Y' THEN
598: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

945: IF aso_debug_pub.g_debug_flag = 'Y' THEN
946: aso_debug_pub.add('Assign_Sales_Team: Before calling Get_Profile_Obsolete_Status', 1, 'N');
947: END IF;
948:
949: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
950: p_application_id => 521);
951:
952: IF aso_debug_pub.g_debug_flag = 'Y' THEN
953: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 1148: 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');

1144: -- Girish Sachdeva 8/30/2005
1145: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
1146:
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: 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');
1149: END IF;
1150:
1151: -- Call to insert record in ASO_CHANGED_QUOTES
1152: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_Qte_Header_Rec.Quote_Number);

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

1148: 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');
1149: END IF;
1150:
1151: -- Call to insert record in ASO_CHANGED_QUOTES
1152: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_Qte_Header_Rec.Quote_Number);
1153:
1154: -- Change END
1155:
1156:

Line 1162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1158: WHEN Leave_Proc THEN
1159: NULL;
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
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_ERROR,
1166: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1166: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

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_ERROR,
1166: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1167: P_SQLCODE => SQLCODE,
1168: P_SQLERRM => SQLERRM,
1169: X_MSG_COUNT => X_MSG_COUNT,
1170: X_MSG_DATA => X_MSG_DATA,

Line 1175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1171: X_RETURN_STATUS => X_RETURN_STATUS
1172: );
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1176: P_API_NAME => L_API_NAME,
1177: P_PKG_NAME => G_PKG_NAME,
1178: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1179: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1179: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1176: P_API_NAME => L_API_NAME,
1177: P_PKG_NAME => G_PKG_NAME,
1178: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1179: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1180: P_SQLCODE => SQLCODE,
1181: P_SQLERRM => SQLERRM,
1182: X_MSG_COUNT => X_MSG_COUNT,
1183: X_MSG_DATA => X_MSG_DATA,

Line 1188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1184: X_RETURN_STATUS => X_RETURN_STATUS
1185: );
1186:
1187: WHEN OTHERS THEN
1188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME,
1190: P_PKG_NAME => G_PKG_NAME,
1191: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1192: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1191: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1187: WHEN OTHERS THEN
1188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME,
1190: P_PKG_NAME => G_PKG_NAME,
1191: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1192: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1193: P_SQLCODE => SQLCODE,
1194: P_SQLERRM => SQLERRM,
1195: X_MSG_COUNT => X_MSG_COUNT,

Line 1192: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME,
1190: P_PKG_NAME => G_PKG_NAME,
1191: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1192: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1193: P_SQLCODE => SQLCODE,
1194: P_SQLERRM => SQLERRM,
1195: X_MSG_COUNT => X_MSG_COUNT,
1196: X_MSG_DATA => X_MSG_DATA,

Line 1389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1385:
1386: EXCEPTION
1387:
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1390: P_API_NAME => L_API_NAME,
1391: P_PKG_NAME => G_PKG_NAME,
1392: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1393: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1393: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1390: P_API_NAME => L_API_NAME,
1391: P_PKG_NAME => G_PKG_NAME,
1392: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1393: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1394: P_SQLCODE => SQLCODE,
1395: P_SQLERRM => SQLERRM,
1396: X_MSG_COUNT => X_MSG_COUNT,
1397: X_MSG_DATA => X_MSG_DATA,

Line 1402: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1398: X_RETURN_STATUS => X_RETURN_STATUS
1399: );
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1403: P_API_NAME => L_API_NAME,
1404: P_PKG_NAME => G_PKG_NAME,
1405: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1406: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1406: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1402: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1403: P_API_NAME => L_API_NAME,
1404: P_PKG_NAME => G_PKG_NAME,
1405: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1406: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1407: P_SQLCODE => SQLCODE,
1408: P_SQLERRM => SQLERRM,
1409: X_MSG_COUNT => X_MSG_COUNT,
1410: X_MSG_DATA => X_MSG_DATA,

Line 1415: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1411: X_RETURN_STATUS => X_RETURN_STATUS
1412: );
1413:
1414: WHEN OTHERS THEN
1415: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1416: P_API_NAME => L_API_NAME,
1417: P_PKG_NAME => G_PKG_NAME,
1418: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1419: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1418: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1414: WHEN OTHERS THEN
1415: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1416: P_API_NAME => L_API_NAME,
1417: P_PKG_NAME => G_PKG_NAME,
1418: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1419: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1420: P_SQLCODE => SQLCODE,
1421: P_SQLERRM => SQLERRM,
1422: X_MSG_COUNT => X_MSG_COUNT,

Line 1419: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1415: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1416: P_API_NAME => L_API_NAME,
1417: P_PKG_NAME => G_PKG_NAME,
1418: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1419: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1420: P_SQLCODE => SQLCODE,
1421: P_SQLERRM => SQLERRM,
1422: X_MSG_COUNT => X_MSG_COUNT,
1423: X_MSG_DATA => X_MSG_DATA,

Line 1469: aso_utility_pvt.print_login_info();

1465: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.party_id: '||P_qte_header_rec.party_id,1,'N');
1466: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.cust_party_id: '||P_qte_header_rec.cust_party_id,1,'N');
1467: 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');
1468: aso_debug_pub.add('Before Calling JTY_ASSIGN_REALTIME_PUB.get_winners',1,'Y');
1469: aso_utility_pvt.print_login_info();
1470: END IF;
1471:
1472: -- Call the new JTF Terr Assignment API
1473: JTY_ASSIGN_REALTIME_PUB.get_winners (

Line 1493: aso_utility_pvt.print_login_info();

1489: );
1490:
1491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1492: aso_debug_pub.add('Get_Sales_Team: x_return_status '||x_return_status,1,'N');
1493: aso_utility_pvt.print_login_info();
1494: aso_debug_pub.add('Get_Sales_Team: lx_bulk_winners_rec.count: '||X_Winners_Rec.Resource_Id.count,1,'N');
1495: IF X_Winners_Rec.Resource_Id.count > 0 THEN
1496: FOR i IN X_Winners_Rec.Resource_Id.FIRST..X_Winners_Rec.Resource_Id.LAST LOOP
1497: aso_debug_pub.add('Get_Sales_Team: Trans_Object_Id: '||X_Winners_Rec.Trans_Object_Id(i),1,'N');

Line 1510: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1506:
1507: EXCEPTION
1508:
1509: WHEN FND_API.G_EXC_ERROR THEN
1510: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1511: P_API_NAME => L_API_NAME,
1512: P_PKG_NAME => G_PKG_NAME,
1513: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1514: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1514: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1510: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1511: P_API_NAME => L_API_NAME,
1512: P_PKG_NAME => G_PKG_NAME,
1513: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1514: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1515: P_SQLCODE => SQLCODE,
1516: P_SQLERRM => SQLERRM,
1517: X_MSG_COUNT => X_MSG_COUNT,
1518: X_MSG_DATA => X_MSG_DATA,

Line 1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1519: X_RETURN_STATUS => X_RETURN_STATUS
1520: );
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME,
1525: P_PKG_NAME => G_PKG_NAME,
1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1527: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1527: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME,
1525: P_PKG_NAME => G_PKG_NAME,
1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1527: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1528: P_SQLCODE => SQLCODE,
1529: P_SQLERRM => SQLERRM,
1530: X_MSG_COUNT => X_MSG_COUNT,
1531: X_MSG_DATA => X_MSG_DATA,

Line 1536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1532: X_RETURN_STATUS => X_RETURN_STATUS
1533: );
1534:
1535: WHEN OTHERS THEN
1536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1537: P_API_NAME => L_API_NAME,
1538: P_PKG_NAME => G_PKG_NAME,
1539: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1540: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1539: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1535: WHEN OTHERS THEN
1536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1537: P_API_NAME => L_API_NAME,
1538: P_PKG_NAME => G_PKG_NAME,
1539: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1540: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1541: P_SQLCODE => SQLCODE,
1542: P_SQLERRM => SQLERRM,
1543: X_MSG_COUNT => X_MSG_COUNT,

Line 1540: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1537: P_API_NAME => L_API_NAME,
1538: P_PKG_NAME => G_PKG_NAME,
1539: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1540: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1541: P_SQLCODE => SQLCODE,
1542: P_SQLERRM => SQLERRM,
1543: X_MSG_COUNT => X_MSG_COUNT,
1544: X_MSG_DATA => X_MSG_DATA,

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

1628: -- Changes Done by : Girish
1629: -- Comments : Using HR EIT in place of org striped profile
1630:
1631: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
1632: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
1633:
1634: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
1635: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
1636:

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

1631: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
1632: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
1633:
1634: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
1635: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
1636:
1637: -- Change End
1638:
1639: l_ots_grp_prof VARCHAR2(50);

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

1728: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1729: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
1730: END IF;
1731:
1732: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1733: p_application_id => 521);
1734:
1735: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1736: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 1901: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1897:
1898: EXCEPTION
1899:
1900: WHEN FND_API.G_EXC_ERROR THEN
1901: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1902: P_API_NAME => L_API_NAME,
1903: P_PKG_NAME => G_PKG_NAME,
1904: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1905: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1905: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1901: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1902: P_API_NAME => L_API_NAME,
1903: P_PKG_NAME => G_PKG_NAME,
1904: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1905: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1906: P_SQLCODE => SQLCODE,
1907: P_SQLERRM => SQLERRM,
1908: X_MSG_COUNT => X_MSG_COUNT,
1909: X_MSG_DATA => X_MSG_DATA,

Line 1914: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1910: X_RETURN_STATUS => X_RETURN_STATUS
1911: );
1912:
1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1914: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME,
1916: P_PKG_NAME => G_PKG_NAME,
1917: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1918: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1918: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1914: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME,
1916: P_PKG_NAME => G_PKG_NAME,
1917: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1918: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1919: P_SQLCODE => SQLCODE,
1920: P_SQLERRM => SQLERRM,
1921: X_MSG_COUNT => X_MSG_COUNT,
1922: X_MSG_DATA => X_MSG_DATA,

Line 1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1923: X_RETURN_STATUS => X_RETURN_STATUS
1924: );
1925:
1926: WHEN OTHERS THEN
1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME,
1929: P_PKG_NAME => G_PKG_NAME,
1930: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1931: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1930: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1926: WHEN OTHERS THEN
1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME,
1929: P_PKG_NAME => G_PKG_NAME,
1930: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1931: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1932: P_SQLCODE => SQLCODE,
1933: P_SQLERRM => SQLERRM,
1934: X_MSG_COUNT => X_MSG_COUNT,

Line 1931: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME,
1929: P_PKG_NAME => G_PKG_NAME,
1930: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1931: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1932: P_SQLCODE => SQLCODE,
1933: P_SQLERRM => SQLERRM,
1934: X_MSG_COUNT => X_MSG_COUNT,
1935: X_MSG_DATA => X_MSG_DATA,

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

1965: -- Changes Done by : Girish
1966: -- Comments : Using HR EIT in place of org striped profile
1967:
1968: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
1969: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
1970:
1971: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
1972: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
1973:

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

1968: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
1969: l_default_salesrep_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
1970:
1971: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');
1972: l_default_role_prof VARCHAR2(50) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALES_ROLE);
1973:
1974: -- Change End
1975:
1976: l_ots_role_prof VARCHAR2(50) := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');

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

2147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2148: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
2149: END IF;
2150:
2151: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
2152: p_application_id => 521);
2153:
2154: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2155: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

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

2316: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2317: aso_debug_pub.add('Before calling Get_Profile_Obsolete_Status', 1, 'N');
2318: END IF;
2319:
2320: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
2321: p_application_id => 521);
2322:
2323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2324: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

Line 2479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2475:
2476: EXCEPTION
2477:
2478: WHEN FND_API.G_EXC_ERROR THEN
2479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2480: P_API_NAME => L_API_NAME,
2481: P_PKG_NAME => G_PKG_NAME,
2482: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2483: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2483: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2480: P_API_NAME => L_API_NAME,
2481: P_PKG_NAME => G_PKG_NAME,
2482: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2483: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2484: P_SQLCODE => SQLCODE,
2485: P_SQLERRM => SQLERRM,
2486: X_MSG_COUNT => X_MSG_COUNT,
2487: X_MSG_DATA => X_MSG_DATA,

Line 2492: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2488: X_RETURN_STATUS => X_RETURN_STATUS
2489: );
2490:
2491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2492: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_API_NAME => L_API_NAME,
2494: P_PKG_NAME => G_PKG_NAME,
2495: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2496: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2496: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2492: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_API_NAME => L_API_NAME,
2494: P_PKG_NAME => G_PKG_NAME,
2495: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2496: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2497: P_SQLCODE => SQLCODE,
2498: P_SQLERRM => SQLERRM,
2499: X_MSG_COUNT => X_MSG_COUNT,
2500: X_MSG_DATA => X_MSG_DATA,

Line 2505: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2501: X_RETURN_STATUS => X_RETURN_STATUS
2502: );
2503:
2504: WHEN OTHERS THEN
2505: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2506: P_API_NAME => L_API_NAME,
2507: P_PKG_NAME => G_PKG_NAME,
2508: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2509: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 2508: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

2504: WHEN OTHERS THEN
2505: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2506: P_API_NAME => L_API_NAME,
2507: P_PKG_NAME => G_PKG_NAME,
2508: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2509: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2510: P_SQLCODE => SQLCODE,
2511: P_SQLERRM => SQLERRM,
2512: X_MSG_COUNT => X_MSG_COUNT,

Line 2509: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

2505: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2506: P_API_NAME => L_API_NAME,
2507: P_PKG_NAME => G_PKG_NAME,
2508: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
2509: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2510: P_SQLCODE => SQLCODE,
2511: P_SQLERRM => SQLERRM,
2512: X_MSG_COUNT => X_MSG_COUNT,
2513: X_MSG_DATA => X_MSG_DATA,