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 FND_PROFILE

Line 49: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');

45: -- Release 12 MOAC Changes : Bug 4500739
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);

Line 52: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');

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:
55: -- Change End
56:

Line 59: -- := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');

55: -- Change End
56:
57:
58: l_ots_role_prof VARCHAR2(50);
59: -- := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
60:
61: l_ots_grp_prof VARCHAR2(50);
62:
63: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',

Line 63: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',

59: -- := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
60:
61: l_ots_grp_prof VARCHAR2(50);
62:
63: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
64: G_USER_ID, NULL, 522),
65: FND_PROFILE.Value_Specific(
66: 'AST_DEFAULT_ROLE_AND_GROUP',
67: G_USER_ID, NULL, 521));

Line 65: FND_PROFILE.Value_Specific(

61: l_ots_grp_prof VARCHAR2(50);
62:
63: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
64: G_USER_ID, NULL, 522),
65: FND_PROFILE.Value_Specific(
66: 'AST_DEFAULT_ROLE_AND_GROUP',
67: G_USER_ID, NULL, 521));
68: */
69:

Line 72: l_sales_team_prof VARCHAR2(30) := NVL(FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN'),'NONE');

68: */
69:
70: l_role_prof VARCHAR2(50);
71:
72: l_sales_team_prof VARCHAR2(30) := NVL(FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN'),'NONE');
73:
74: i NUMBER;
75: j NUMBER;
76: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'ASSIGN_SALES_TEAM';

Line 181: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

177: */
178: --Commented Code End Yogeshwar (MOAC)
179: BEGIN
180:
181: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
182:
183: -- Standard Start of API savepoint
184: SAVEPOINT ASSIGN_SALES_TEAM_PVT;
185:

Line 214: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'N') OR (l_sales_team_prof = 'NONE') THEN

210: END IF;
211: -- BASIC VALIDATIONS
212:
213: -- Check if profiles are set
214: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'N') OR (l_sales_team_prof = 'NONE') THEN
215:
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('API_Enable_Sec is N or sales_team_prof is None: ',1,'Y');
218: END IF;

Line 407: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');

403: END IF;
404:
405: if l_obsolete_status = 'T' then
406:
407: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
408:
409: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
410:
411: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 409: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

405: if l_obsolete_status = 'T' then
406:
407: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
408:
409: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
410:
411: IF aso_debug_pub.g_debug_flag = 'Y' THEN
412: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
413: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

Line 424: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

420: END IF;
421:
422: if l_creator_grp is null then
423:
424: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
425:
426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
428: END IF;

Line 440: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');

436: end if;
437:
438: else
439:
440: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
441:
442: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
443:
444: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 442: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

438: else
439:
440: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
441:
442: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
443:
444: IF aso_debug_pub.g_debug_flag = 'Y' THEN
445: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
446: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

Line 457: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

453: END IF;
454:
455: if l_creator_grp is null then
456:
457: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
458:
459: IF aso_debug_pub.g_debug_flag = 'Y' THEN
460: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
461: END IF;

Line 603: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

599: END IF;
600:
601: if l_obsolete_status = 'T' then
602:
603: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
604:
605: IF aso_debug_pub.g_debug_flag = 'Y' THEN
606: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
607: END IF;

Line 617: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

613: END IF;
614:
615: if l_primary_res_grp is null then
616:
617: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
618:
619: IF aso_debug_pub.g_debug_flag = 'Y' THEN
620: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
621: END IF;

Line 633: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

629: end if;
630:
631: else
632:
633: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
634:
635: IF aso_debug_pub.g_debug_flag = 'Y' THEN
636: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
637: END IF;

Line 647: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

643: END IF;
644:
645: if l_primary_res_grp is null then
646:
647: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
648:
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
651: END IF;

Line 958: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');

954: END IF;
955:
956: if l_obsolete_status = 'T' then
957:
958: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
959:
960: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
961:
962: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 960: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

956: if l_obsolete_status = 'T' then
957:
958: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
959:
960: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
961:
962: IF aso_debug_pub.g_debug_flag = 'Y' THEN
963: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
964: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

Line 975: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

971: END IF;
972:
973: if l_creator_grp is null then
974:
975: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
976:
977: IF aso_debug_pub.g_debug_flag = 'Y' THEN
978: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
979: END IF;

Line 991: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');

987: end if;
988:
989: else
990:
991: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
992:
993: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
994:
995: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 993: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

989: else
990:
991: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
992:
993: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
994:
995: IF aso_debug_pub.g_debug_flag = 'Y' THEN
996: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
997: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

Line 1008: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

1004: END IF;
1005:
1006: if l_creator_grp is null then
1007:
1008: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1009:
1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1012: END IF;

Line 1631: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');

1627: -- Release 12 MOAC Changes : Bug 4500739
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);

Line 1634: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');

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:
1637: -- Change End
1638:

Line 1642: := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',

1638:
1639: l_ots_grp_prof VARCHAR2(50);
1640:
1641: /*
1642: := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
1643: G_USER_ID, NULL, 522),
1644: FND_PROFILE.Value_Specific(
1645: 'AST_DEFAULT_ROLE_AND_GROUP',
1646: G_USER_ID, NULL, 521));

Line 1644: FND_PROFILE.Value_Specific(

1640:
1641: /*
1642: := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
1643: G_USER_ID, NULL, 522),
1644: FND_PROFILE.Value_Specific(
1645: 'AST_DEFAULT_ROLE_AND_GROUP',
1646: G_USER_ID, NULL, 521));
1647: */
1648:

Line 1741: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

1737: END IF;
1738:
1739: if l_obsolete_status = 'T' then
1740:
1741: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1742:
1743: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1744: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1745: END IF;

Line 1755: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

1751: END IF;
1752:
1753: if l_primary_res_grp is null then
1754:
1755: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
1756:
1757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1758: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1759: END IF;

Line 1771: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

1767: end if;
1768:
1769: else
1770:
1771: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1772:
1773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1774: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1775: END IF;

Line 1785: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

1781: END IF;
1782:
1783: if l_primary_res_grp is null then
1784:
1785: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1786:
1787: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1788: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1789: END IF;

Line 1968: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');

1964: -- Release 12 MOAC Changes : Bug 4500739
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);

Line 1971: --l_default_role_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_SALES_ROLE');

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:
1974: -- Change End
1975:

Line 1976: l_ots_role_prof VARCHAR2(50) := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');

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');
1977: l_ots_grp_prof VARCHAR2(50);
1978:
1979: /*
1980: := NVL(FND_PROFILE.Value_Specific(

Line 1980: := NVL(FND_PROFILE.Value_Specific(

1976: l_ots_role_prof VARCHAR2(50) := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
1977: l_ots_grp_prof VARCHAR2(50);
1978:
1979: /*
1980: := NVL(FND_PROFILE.Value_Specific(
1981: 'ASF_DEFAULT_GROUP_ROLE',
1982: G_USER_ID, NULL, 522),
1983: FND_PROFILE.Value_Specific(
1984: 'AST_DEFAULT_ROLE_AND_GROUP',

Line 1983: FND_PROFILE.Value_Specific(

1979: /*
1980: := NVL(FND_PROFILE.Value_Specific(
1981: 'ASF_DEFAULT_GROUP_ROLE',
1982: G_USER_ID, NULL, 522),
1983: FND_PROFILE.Value_Specific(
1984: 'AST_DEFAULT_ROLE_AND_GROUP',
1985: G_USER_ID, NULL, 521));
1986: */
1987:

Line 2062: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2058: */
2059: --Commented Code End Yogeshwar (MOAC)
2060: BEGIN
2061:
2062: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2063:
2064: -- Standard Start of API savepoint
2065: SAVEPOINT OPP_QUOTE_PRIMARY_SALESREP_PVT;
2066:

Line 2160: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

2156: END IF;
2157:
2158: if l_obsolete_status = 'T' then
2159:
2160: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2161:
2162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2163: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2164: END IF;

Line 2174: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

2170: END IF;
2171:
2172: if l_primary_res_grp is null then
2173:
2174: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
2175:
2176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2177: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2178: END IF;

Line 2190: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

2186: end if;
2187:
2188: else
2189:
2190: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2191:
2192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2193: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2194: END IF;

Line 2204: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

2200: END IF;
2201:
2202: if l_primary_res_grp is null then
2203:
2204: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
2205:
2206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2207: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2208: END IF;

Line 2329: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

2325: END IF;
2326:
2327: if l_obsolete_status = 'T' then
2328:
2329: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2330:
2331: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2332: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2333: END IF;

Line 2343: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

2339: END IF;
2340:
2341: if l_primary_res_grp is null then
2342:
2343: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
2344:
2345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2346: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2347: END IF;

Line 2359: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

2355: end if;
2356:
2357: else
2358:
2359: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2360:
2361: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2362: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2363: END IF;

Line 2373: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

2369: END IF;
2370:
2371: if l_primary_res_grp is null then
2372:
2373: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
2374:
2375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2376: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2377: END IF;