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.AS_OPP_SALES_CREDIT_PVT dependencies on FND_PROFILE

Line 85: nvl(FND_PROFILE.Value('ASN_FRCST_DEFAULTING_TYPE'), 'z');

81: l_Trigger_Mode := nvl(p_Trigger_Mode, 'NONE');
82:
83: l_apply_frcst_def := FALSE;
84: l_defaulting_type :=
85: nvl(FND_PROFILE.Value('ASN_FRCST_DEFAULTING_TYPE'), 'z');
86:
87: IF nvl(l_forecast_rollup_flag, 'N') = 'Y' THEN
88: l_prob_bucket := get_prob_bucket(l_win_probability);
89: IF l_Trigger_Mode = 'ON-UPDATE' THEN

Line 211: -- SELECT decode(count(*), 1, to_char(max(c.group_id)), decode(fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE', max(a.user_id)),'XXXXX',null,fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE',max(a.user_id))))

207:
208: -- Jean add here. Use to get sales group id
209: -- for partner contact resource type
210: CURSOR c_group_id(c_SALESFORCE_ID NUMBER) IS
211: -- SELECT decode(count(*), 1, to_char(max(c.group_id)), decode(fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE', max(a.user_id)),'XXXXX',null,fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE',max(a.user_id))))
212: -- SELECT decode(count(*), 1, to_char(max(c.group_id)))
213: -- SELECT to_char(max(c.group_id))
214: -- FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c
215: -- WHERE a.user_id = b.user_id

Line 303: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')

299: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
300: /*
301: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y', callout procedure
302: -- is invoked for customization purpose
303: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
304: THEN
305: AS_CALLOUT_PKG.Create_sales_credit_BC(
306: p_api_version_number => 2.0,
307: p_init_msg_list => FND_API.G_FALSE,

Line 399: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');

395: CLOSE c_get_opp_freeze_flag;
396:
397: IF l_freeze_flag = 'Y'
398: THEN
399: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
400: IF l_allow_flag <> 'Y' THEN
401: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
402: 'API_OPP_FROZEN');
403: RAISE FND_API.G_EXC_ERROR;

Line 530: nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

526: l_sales_credit_rec.OPP_BEST_FORECAST_AMOUNT);
527: -- Begin Added for ASNB
528: IF (l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG IS NULL or
529: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG = FND_API.G_MISS_CHAR) AND
530: nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
531: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') = l_sales_credit_rec.CREDIT_TYPE_ID
532: THEN
533: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'Y';
534: END IF;

Line 531: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') = l_sales_credit_rec.CREDIT_TYPE_ID

527: -- Begin Added for ASNB
528: IF (l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG IS NULL or
529: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG = FND_API.G_MISS_CHAR) AND
530: nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
531: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') = l_sales_credit_rec.CREDIT_TYPE_ID
532: THEN
533: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'Y';
534: END IF;
535: -- End Added for ASNB

Line 626: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then

622: l_sales_team_rec.partner_address_id := l_sales_credit_rec.PARTNER_ADDRESS_ID;
623: IF get_dup_sales_team%NOTFOUND THEN
624: -- Jean 5/11, for bug 1610145
625: -- the following condition added for ASNB
626: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then
627: l_Sales_Team_Rec.team_leader_flag := 'Y';
628: ELSE
629: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))
630: THEN

Line 629: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))

625: -- the following condition added for ASNB
626: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then
627: l_Sales_Team_Rec.team_leader_flag := 'Y';
628: ELSE
629: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))
630: THEN
631: l_Sales_Team_Rec.team_leader_flag := 'Y';
632: ELSE
633: l_Sales_Team_Rec.team_leader_flag := 'N';

Line 640: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');

636: -- end bug 1610145
637:
638: l_Sales_Team_Rec.reassign_flag := 'N';
639: l_Sales_Team_Rec.freeze_flag :=
640: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
641:
642: -- Debug Message
643: IF l_debug THEN
644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 685: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

681: If the sales creditor exists in the sales team then update the
682: full access flag ie team_leader_flag to 'Y' if not already set.
683: */
684: ELSE -- get_dup_sales_team found
685: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
686: nvl(l_upd_team_flag,'N') <> 'Y'
687: THEN
688: l_Sales_Team_Rec.last_update_date := l_upd_date;
689: l_Sales_Team_Rec.access_id := l_upd_access_id;

Line 753: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')

749: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
750: /*
751: -- if profile AS_POST_CUSTOM_ENABLED is set to 'Y', callout
752: -- procedure is invoked for customization purpose
753: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
754: THEN
755: AS_CALLOUT_PKG.Create_sales_credit_AC(
756: p_api_version_number => 2.0,
757: p_init_msg_list => FND_API.G_FALSE,

Line 950: l_forecast_credit_type_id CONSTANT NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

946:
947: l_upd_access_id NUMBER;
948: l_upd_team_flag VARCHAR2(1);
949: l_upd_date DATE;
950: l_forecast_credit_type_id CONSTANT NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
951: l_opp_worst_forecast_amount NUMBER;
952: l_opp_forecast_amount NUMBER;
953: l_opp_best_forecast_amount NUMBER;
954: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Update_sales_credits';

Line 995: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')

991: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
992: /*
993: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y', callout
994: -- procedure is invoked for customization purpose
995: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
996: THEN
997: AS_CALLOUT_PKG.Update_sales_credit_BU(
998: p_api_version_number => 2.0,
999: p_init_msg_list => FND_API.G_FALSE,

Line 1075: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');

1071: CLOSE c_get_opp_freeze_flag;
1072:
1073: IF l_freeze_flag = 'Y'
1074: THEN
1075: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1076: IF l_allow_flag <> 'Y' THEN
1077: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1078: 'API_OPP_FROZEN');
1079: RAISE FND_API.G_EXC_ERROR;

Line 1321: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y'

1317: END IF;
1318: END IF;
1319:
1320: -- Begin Added for ASNB
1321: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y'
1322: and (l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG IS NULL or
1323: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG = FND_API.G_MISS_CHAR)
1324: THEN
1325: IF nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), -1) = l_sales_credit_rec.CREDIT_TYPE_ID

Line 1325: IF nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), -1) = l_sales_credit_rec.CREDIT_TYPE_ID

1321: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y'
1322: and (l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG IS NULL or
1323: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG = FND_API.G_MISS_CHAR)
1324: THEN
1325: IF nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), -1) = l_sales_credit_rec.CREDIT_TYPE_ID
1326: THEN
1327: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'Y';
1328: ELSE
1329: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'N';

Line 1419: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then

1415: IF get_dup_sales_team%NOTFOUND THEN
1416: -- Jean 5/11, for bug 1610145
1417:
1418: -- The followng condition added for ASNB
1419: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then
1420: l_Sales_Team_Rec.team_leader_flag := 'Y';
1421: ELSE
1422: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))
1423: THEN

Line 1422: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))

1418: -- The followng condition added for ASNB
1419: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' then
1420: l_Sales_Team_Rec.team_leader_flag := 'Y';
1421: ELSE
1422: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))
1423: THEN
1424: l_Sales_Team_Rec.team_leader_flag := 'Y';
1425: ELSE
1426: l_Sales_Team_Rec.team_leader_flag := 'N';

Line 1433: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');

1429: -- end bug 1610145
1430:
1431: l_Sales_Team_Rec.reassign_flag := 'N';
1432: l_Sales_Team_Rec.freeze_flag :=
1433: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1434:
1435: -- Debug Message
1436: IF l_debug THEN
1437: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1478: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

1474: If the sales creditor exists in the sales team then update the
1475: full access flag ie team_leader_flag to 'Y' if not already set.
1476: */
1477: ELSE -- get_dup_sales_team found
1478: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
1479: nvl(l_upd_team_flag,'N') <> 'Y'
1480: THEN
1481: l_Sales_Team_Rec.last_update_date := l_upd_date;
1482: l_Sales_Team_Rec.access_id := l_upd_access_id;

Line 1534: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))

1530: l_sales_team_rec.person_id := l_sales_credit_rec.PERSON_ID;
1531: l_sales_team_rec.partner_customer_id := l_sales_credit_rec.PARTNER_CUSTOMER_ID;
1532: l_sales_team_rec.partner_address_id := l_sales_credit_rec.PARTNER_ADDRESS_ID;
1533: -- Jean 5/11, for bug 1610145
1534: IF(l_sales_credit_rec.CREDIT_TYPE_ID = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID') AND (l_sales_team_rec.partner_customer_id IS NULL OR l_sales_team_rec.partner_customer_id = FND_API.G_MISS_NUM))
1535: THEN
1536: l_Sales_Team_Rec.team_leader_flag := 'Y';
1537: ELSE
1538: l_Sales_Team_Rec.team_leader_flag := 'N';

Line 1544: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');

1540: -- end bug 1610145
1541:
1542: l_Sales_Team_Rec.reassign_flag := 'N';
1543: l_Sales_Team_Rec.freeze_flag :=
1544: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1545:
1546: -- Debug Message
1547: IF l_debug THEN
1548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1618: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')

1614: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
1615: /*
1616: -- if profile AS_POST_CUSTOM_ENABLED is set to 'Y', callout
1617: -- procedure is invoked for customization purpose
1618: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
1619: THEN
1620: AS_CALLOUT_PKG.Update_sales_credit_AU(
1621: p_api_version_number => 2.0,
1622: p_init_msg_list => FND_API.G_FALSE,

Line 1710: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

1706:
1707: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
1708: l_total_forecast_amount NUMBER;
1709: l_total_forecast_percent NUMBER := 0;
1710: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
1711:
1712: l_update_access_flag VARCHAR2(1);
1713: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1714:

Line 1837: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');

1833: -- end of Jean correct
1834:
1835: IF l_freeze_flag = 'Y'
1836: THEN
1837: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1838: IF l_allow_flag <> 'Y' THEN
1839: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1840: 'API_OPP_FROZEN');
1841: RAISE FND_API.G_EXC_ERROR;

Line 2278: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')

2274: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
2275: /*
2276: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y', callout
2277: -- procedure is invoked for customization purpose
2278: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
2279: THEN
2280: AS_CALLOUT_PKG.Delete_sales_credit_BD(
2281: p_api_version_number => 2.0,
2282: p_init_msg_list => FND_API.G_FALSE,

Line 2360: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');

2356: CLOSE c_get_opp_freeze_flag;
2357:
2358: IF l_freeze_flag = 'Y'
2359: THEN
2360: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
2361: IF l_allow_flag <> 'Y' THEN
2362: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2363: 'API_OPP_FROZEN');
2364: RAISE FND_API.G_EXC_ERROR;

Line 2431: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')

2427: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
2428: /*
2429: -- if profile AS_POST_CUSTOM_ENABLED is set to 'Y', callout
2430: -- procedure is invoked for customization purpose
2431: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
2432: THEN
2433: AS_CALLOUT_PKG.Delete_sales_credit_AD(
2434: p_api_version_number => 2.0,
2435: p_init_msg_list => FND_API.G_FALSE,

Line 3322: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

3318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3319: 'Private API 52: Validate Items start');
3320: END IF;
3321: -- Begin Added for ASNB
3322: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
3323: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') <> P_SALES_CREDIT_Rec.CREDIT_TYPE_ID THEN
3324: duplicate_sales_credit(
3325: p_init_msg_list => FND_API.G_FALSE,
3326: p_validation_mode => p_validation_mode,

Line 3323: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') <> P_SALES_CREDIT_Rec.CREDIT_TYPE_ID THEN

3319: 'Private API 52: Validate Items start');
3320: END IF;
3321: -- Begin Added for ASNB
3322: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
3323: nvl(fnd_profile.value('AS_FORECAST_CREDIT_TYPE_ID'), 'N') <> P_SALES_CREDIT_Rec.CREDIT_TYPE_ID THEN
3324: duplicate_sales_credit(
3325: p_init_msg_list => FND_API.G_FALSE,
3326: p_validation_mode => p_validation_mode,
3327: P_SALES_CREDIT_Rec => P_SALES_CREDIT_Rec,