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 325: --l_default_salesrep_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');

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

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

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:
331: -- Change End
332:

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

331: -- Change End
332:
333:
334: l_ots_role_prof VARCHAR2(50);
335: -- := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
336:
337: l_ots_grp_prof VARCHAR2(50);
338:
339: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',

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

335: -- := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
336:
337: l_ots_grp_prof VARCHAR2(50);
338:
339: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
340: G_USER_ID, NULL, 522),
341: FND_PROFILE.Value_Specific(
342: 'AST_DEFAULT_ROLE_AND_GROUP',
343: G_USER_ID, NULL, 521));

Line 341: FND_PROFILE.Value_Specific(

337: l_ots_grp_prof VARCHAR2(50);
338:
339: /* := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
340: G_USER_ID, NULL, 522),
341: FND_PROFILE.Value_Specific(
342: 'AST_DEFAULT_ROLE_AND_GROUP',
343: G_USER_ID, NULL, 521));
344: */
345:

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

344: */
345:
346: l_role_prof VARCHAR2(50);
347:
348: l_sales_team_prof VARCHAR2(30) := NVL(FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN'),'NONE');
349:
350: i NUMBER;
351: j NUMBER;
352: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'ASSIGN_SALES_TEAM';

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

454: */
455: --Commented Code End Yogeshwar (MOAC)
456: BEGIN
457:
458: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
459:
460: -- Standard Start of API savepoint
461: SAVEPOINT ASSIGN_SALES_TEAM_PVT;
462:

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

487: END IF;
488: -- BASIC VALIDATIONS
489:
490: -- Check if profiles are set
491: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'N') OR (l_sales_team_prof = 'NONE') THEN
492:
493: IF aso_debug_pub.g_debug_flag = 'Y' THEN
494: aso_debug_pub.add('API_Enable_Sec is N or sales_team_prof is None: ',1,'Y');
495: END IF;

Line 582: If (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y') Then

578: l_qte_header_rec.cust_account_id; -- Code change done for Bug 11076978
579: CLOSE C_Get_Header_Info;
580:
581: /*** Start : Code change done for Bug 11076978 ***/
582: If (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y') Then
583: If (l_sales_team_prof = 'FULL' OR l_sales_team_prof = 'PARTIAL') Then
584: If (p_qte_header_rec.cust_account_id IS NOT NULL AND
585: p_qte_header_rec.cust_account_id <> FND_API.G_MISS_NUM) Then
586: If (l_qte_header_rec.cust_account_id <> P_Qte_Header_Rec.cust_account_id) Then

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

694: END IF;
695:
696: if l_obsolete_status = 'T' then
697:
698: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
699:
700: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
701:
702: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

696: if l_obsolete_status = 'T' then
697:
698: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
699:
700: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
701:
702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
703: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
704: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

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

711: END IF;
712:
713: if l_creator_grp is null then
714:
715: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
716:
717: IF aso_debug_pub.g_debug_flag = 'Y' THEN
718: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
719: END IF;

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

727: end if;
728:
729: else
730:
731: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
732:
733: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
734:
735: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

729: else
730:
731: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
732:
733: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
734:
735: IF aso_debug_pub.g_debug_flag = 'Y' THEN
736: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
737: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

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

744: END IF;
745:
746: if l_creator_grp is null then
747:
748: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
749:
750: IF aso_debug_pub.g_debug_flag = 'Y' THEN
751: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
752: END IF;

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

890: END IF;
891:
892: if l_obsolete_status = 'T' then
893:
894: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
895:
896: IF aso_debug_pub.g_debug_flag = 'Y' THEN
897: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
898: END IF;

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

904: END IF;
905:
906: if l_primary_res_grp is null then
907:
908: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
909:
910: IF aso_debug_pub.g_debug_flag = 'Y' THEN
911: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
912: END IF;

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

920: end if;
921:
922: else
923:
924: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
925:
926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
927: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
928: END IF;

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

934: END IF;
935:
936: if l_primary_res_grp is null then
937:
938: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
939:
940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
941: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
942: END IF;

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

1248: END IF;
1249:
1250: if l_obsolete_status = 'T' then
1251:
1252: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
1253:
1254: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1255:
1256: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1250: if l_obsolete_status = 'T' then
1251:
1252: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE');
1253:
1254: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1255:
1256: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1257: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
1258: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

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

1265: END IF;
1266:
1267: if l_creator_grp is null then
1268:
1269: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
1270:
1271: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1272: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1273: END IF;

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

1281: end if;
1282:
1283: else
1284:
1285: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
1286:
1287: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1288:
1289: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1283: else
1284:
1285: l_ots_role_prof := fnd_profile.value('AST_DEFAULT_ROLE_AND_GROUP');
1286:
1287: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1288:
1289: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1290: aso_debug_pub.add('l_ots_role_prof: ' || l_ots_role_prof, 1, 'N');
1291: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');

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

1298: END IF;
1299:
1300: if l_creator_grp is null then
1301:
1302: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1303:
1304: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1305: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
1306: END IF;

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

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

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

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:
2076: -- Change End
2077:

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

2077:
2078: l_ots_grp_prof VARCHAR2(50);
2079:
2080: /*
2081: := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
2082: G_USER_ID, NULL, 522),
2083: FND_PROFILE.Value_Specific(
2084: 'AST_DEFAULT_ROLE_AND_GROUP',
2085: G_USER_ID, NULL, 521));

Line 2083: FND_PROFILE.Value_Specific(

2079:
2080: /*
2081: := NVL(FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE',
2082: G_USER_ID, NULL, 522),
2083: FND_PROFILE.Value_Specific(
2084: 'AST_DEFAULT_ROLE_AND_GROUP',
2085: G_USER_ID, NULL, 521));
2086: */
2087:

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

2176: END IF;
2177:
2178: if l_obsolete_status = 'T' then
2179:
2180: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2181:
2182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2183: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2184: END IF;

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

2190: END IF;
2191:
2192: if l_primary_res_grp is null then
2193:
2194: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
2195:
2196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2197: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2198: END IF;

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

2206: end if;
2207:
2208: else
2209:
2210: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2211:
2212: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2213: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2214: END IF;

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

2220: END IF;
2221:
2222: if l_primary_res_grp is null then
2223:
2224: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
2225:
2226: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2227: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2228: END IF;

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

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

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

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:
2413: -- Change End
2414:

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

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');
2416: l_ots_grp_prof VARCHAR2(50);
2417:
2418: /*
2419: := NVL(FND_PROFILE.Value_Specific(

Line 2419: := NVL(FND_PROFILE.Value_Specific(

2415: l_ots_role_prof VARCHAR2(50) := FND_PROFILE.Value('AST_DEFAULT_ROLE_AND_GROUP');
2416: l_ots_grp_prof VARCHAR2(50);
2417:
2418: /*
2419: := NVL(FND_PROFILE.Value_Specific(
2420: 'ASF_DEFAULT_GROUP_ROLE',
2421: G_USER_ID, NULL, 522),
2422: FND_PROFILE.Value_Specific(
2423: 'AST_DEFAULT_ROLE_AND_GROUP',

Line 2422: FND_PROFILE.Value_Specific(

2418: /*
2419: := NVL(FND_PROFILE.Value_Specific(
2420: 'ASF_DEFAULT_GROUP_ROLE',
2421: G_USER_ID, NULL, 522),
2422: FND_PROFILE.Value_Specific(
2423: 'AST_DEFAULT_ROLE_AND_GROUP',
2424: G_USER_ID, NULL, 521));
2425: */
2426:

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

2497: */
2498: --Commented Code End Yogeshwar (MOAC)
2499: BEGIN
2500:
2501: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2502:
2503: -- Standard Start of API savepoint
2504: SAVEPOINT OPP_QUOTE_PRIMARY_SALESREP_PVT;
2505:

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

2595: END IF;
2596:
2597: if l_obsolete_status = 'T' then
2598:
2599: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2600:
2601: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2602: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2603: END IF;

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

2609: END IF;
2610:
2611: if l_primary_res_grp is null then
2612:
2613: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
2614:
2615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2616: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2617: END IF;

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

2625: end if;
2626:
2627: else
2628:
2629: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2630:
2631: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2632: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2633: END IF;

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

2639: END IF;
2640:
2641: if l_primary_res_grp is null then
2642:
2643: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
2644:
2645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2646: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2647: END IF;

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

2764: END IF;
2765:
2766: if l_obsolete_status = 'T' then
2767:
2768: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2769:
2770: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2771: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2772: END IF;

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

2778: END IF;
2779:
2780: if l_primary_res_grp is null then
2781:
2782: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
2783:
2784: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2785: aso_debug_pub.add('l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2786: END IF;

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

2794: end if;
2795:
2796: else
2797:
2798: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
2799:
2800: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2801: aso_debug_pub.add('ASF_DEFAULT_GROUP_ROLE value: l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2802: END IF;

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

2808: END IF;
2809:
2810: if l_primary_res_grp is null then
2811:
2812: l_ots_grp_prof := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
2813:
2814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2815: aso_debug_pub.add('AST_DEFAULT_ROLE_AND_GROUP value :l_ots_grp_prof: ' || l_ots_grp_prof, 1, 'N');
2816: END IF;