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_HEADER_PVT dependencies on FND_PROFILE

Line 91: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') <> 'Y' THEN -- Added for ASNB

87: IS
88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;
89:
90: BEGIN
91: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') <> 'Y' THEN -- Added for ASNB
92: If (l_opp_rec.sales_stage_id IS NULL) or
93: (l_opp_rec.sales_stage_id = FND_API.G_MISS_NUM
94: and p_mode = AS_UTILITY_PVT.G_CREATE)
95: THEN

Line 97: to_number(FND_PROFILE.VALUE ('AS_OPP_SALES_STAGE'));

93: (l_opp_rec.sales_stage_id = FND_API.G_MISS_NUM
94: and p_mode = AS_UTILITY_PVT.G_CREATE)
95: THEN
96: l_opp_rec.sales_stage_id :=
97: to_number(FND_PROFILE.VALUE ('AS_OPP_SALES_STAGE'));
98: End If;
99: END IF;
100:
101: If (l_opp_rec.win_probability IS NULL) or

Line 106: to_number(FND_PROFILE.VALUE ('AS_OPP_WIN_PROBABILITY'));

102: (l_opp_rec.win_probability = FND_API.G_MISS_NUM
103: and p_mode = AS_UTILITY_PVT.G_CREATE)
104: THEN
105: l_opp_rec.win_probability :=
106: to_number(FND_PROFILE.VALUE ('AS_OPP_WIN_PROBABILITY'));
107: End If;
108:
109: If (l_opp_rec.channel_code IS NULL) or
110: (l_opp_rec.channel_code = FND_API.G_MISS_CHAR

Line 113: l_opp_rec.channel_code := FND_PROFILE.VALUE ('AS_OPP_SALES_CHANNEL');

109: If (l_opp_rec.channel_code IS NULL) or
110: (l_opp_rec.channel_code = FND_API.G_MISS_CHAR
111: and p_mode = AS_UTILITY_PVT.G_CREATE)
112: THEN
113: l_opp_rec.channel_code := FND_PROFILE.VALUE ('AS_OPP_SALES_CHANNEL');
114: End If;
115:
116: If (l_opp_rec.status_code IS NULL) or
117: (l_opp_rec.status_code = FND_API.G_MISS_CHAR

Line 120: l_opp_rec.status_code := FND_PROFILE.VALUE ('AS_OPP_STATUS');

116: If (l_opp_rec.status_code IS NULL) or
117: (l_opp_rec.status_code = FND_API.G_MISS_CHAR
118: and p_mode = AS_UTILITY_PVT.G_CREATE)
119: THEN
120: l_opp_rec.status_code := FND_PROFILE.VALUE ('AS_OPP_STATUS');
121: End If;
122:
123: If (l_opp_rec.decision_date IS NULL) or
124: (l_opp_rec.decision_date = FND_API.G_MISS_DATE

Line 128: trunc(sysdate) + to_number(FND_PROFILE.VALUE('AS_OPP_CLOSING_DATE_DAYS'));

124: (l_opp_rec.decision_date = FND_API.G_MISS_DATE
125: and p_mode = AS_UTILITY_PVT.G_CREATE)
126: THEN
127: l_opp_rec.decision_date :=
128: trunc(sysdate) + to_number(FND_PROFILE.VALUE('AS_OPP_CLOSING_DATE_DAYS'));
129: End If;
130:
131: If (l_opp_rec.currency_code IS NULL) or
132: (l_opp_rec.currency_code = FND_API.G_MISS_CHAR

Line 136: FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY');

132: (l_opp_rec.currency_code = FND_API.G_MISS_CHAR
133: and p_mode = AS_UTILITY_PVT.G_CREATE)
134: THEN
135: l_opp_rec.currency_code :=
136: FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY');
137: End If;
138:
139: -- ffang 091400 for bug 1407007
140: If (l_opp_rec.auto_assignment_type IS NULL) or

Line 441: nvl(FND_PROFILE.VALUE ('AS_SM_CREATE_TASKS'), 'N') = 'Y' THEN

437: (p_SALES_METHODOLOGY_ID <> FND_API.G_MISS_NUM ) THEN
438:
439: IF ((nvl(p_OLD_SALES_METHODOLOGY_ID, -99) <> p_SALES_METHODOLOGY_ID) OR
440: (nvl(p_OLD_SALES_STAGE_ID, -99) <> p_SALES_STAGE_ID) ) AND
441: nvl(FND_PROFILE.VALUE ('AS_SM_CREATE_TASKS'), 'N') = 'Y' THEN
442:
443: open template(p_sales_methodology_id, p_sales_stage_id);
444: fetch template into l_tmplate_group_id ;
445: close template;

Line 674: l_default_address_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_OPP_DEFAULT_ADDRESS');

670:
671: l_warning_msg VARCHAR2(2000) := '';
672: l_winprob_warning_msg VARCHAR2(2000) := '';
673:
674: l_default_address_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_OPP_DEFAULT_ADDRESS');
675:
676: CURSOR get_person_id_csr(c_salesforce_id NUMBER) is
677: select employee_person_id
678: from as_salesforce_v

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

736: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
737: /*
738: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y',
739: -- callout procedure is invoked for customization purpose
740: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
741: THEN
742: AS_CALLOUT_PKG.Create_opp_header_BC(
743: p_api_version_number => 2.0,
744: p_init_msg_list => FND_API.G_FALSE,

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

1069: l_Sales_Team_Rec.lead_id := x_lead_id;
1070: l_Sales_Team_Rec.team_leader_flag := 'Y';
1071: l_Sales_Team_Rec.reassign_flag := 'N';
1072: l_Sales_Team_Rec.freeze_flag :=
1073: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1074:
1075: l_sales_team_rec.sales_group_id := l_salesgroup_id;
1076: l_sales_team_rec.salesforce_role_code := FND_PROFILE.Value('AS_DEF_OPP_ST_ROLE');
1077:

Line 1076: l_sales_team_rec.salesforce_role_code := FND_PROFILE.Value('AS_DEF_OPP_ST_ROLE');

1072: l_Sales_Team_Rec.freeze_flag :=
1073: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1074:
1075: l_sales_team_rec.sales_group_id := l_salesgroup_id;
1076: l_sales_team_rec.salesforce_role_code := FND_PROFILE.Value('AS_DEF_OPP_ST_ROLE');
1077:
1078: OPEN get_person_id_csr(P_Identity_Salesforce_Id);
1079: FETCH get_person_id_csr into l_Sales_Team_Rec.person_id;
1080:

Line 1118: l_Sales_Team_Rec.freeze_flag := nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');

1114: Is_Employee(P_Identity_Salesforce_Id)
1115: THEN
1116: --l_sales_team_rec.owner_flag := 'Y';
1117: --l_Sales_Team_Rec.freeze_flag := 'Y';
1118: l_Sales_Team_Rec.freeze_flag := nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1119: l_is_owner := 'Y';
1120: END IF;
1121:
1122: -- Debug Message

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

1352: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
1353: /*
1354: -- if profile AS_POST_CUSTOM_ENABLED is set to 'Y', callout procedure is
1355: -- invoked for customization purpose
1356: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
1357: THEN
1358: AS_CALLOUT_PKG.Create_opp_header_AC(
1359: p_api_version_number => 2.0,
1360: p_init_msg_list => FND_API.G_FALSE,

Line 1501: l_comp_required_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_COMPETITOR_REQUIRED');

1497: l_old_sales_stage_id NUMBER := null;
1498: l_new_SALES_METHODOLOGY_ID NUMBER := null;
1499: l_new_SALES_STAGE_ID NUMBER := null;
1500:
1501: l_comp_required_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_COMPETITOR_REQUIRED');
1502:
1503: l_warning_msg VARCHAR2(2000) := '';
1504: l_winprob_warning_msg VARCHAR2(2000) := '';
1505:

Line 1526: l_forecast_credit_type_id CONSTANT NUMBER := FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID');

1522: l_old_tot_rev_opp_forecast_amt NUMBER; -- Added for ASNB
1523: l_tot_rev_opp_forecast_amt NUMBER; -- Added for R12
1524: l_update_count NUMBER;
1525: l_count NUMBER;
1526: l_forecast_credit_type_id CONSTANT NUMBER := FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID');
1527: l_temp_bool BOOLEAN;
1528: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1529: x_lead_id NUMBER;
1530: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Update_opp_header';

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

1565: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
1566: /*
1567: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y', callout procedure is
1568: -- invoked for customization purpose
1569: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
1570: THEN
1571: AS_CALLOUT_PKG.Update_opp_header_BU(
1572: p_api_version_number => 2.0,
1573: p_init_msg_list => FND_API.G_FALSE,

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

1632: -- Moved the following section for bug 2407000
1633: -- solin, for bug 1554330
1634: IF l_freeze_flag = 'Y'
1635: THEN
1636: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1637: IF l_allow_flag <> 'Y' THEN
1638: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1639: 'API_OPP_FROZEN');
1640: RAISE FND_API.G_EXC_ERROR;

Line 1838: IF NVL(FND_PROFILE.Value('AS_OPPTY_GENERATE_NOTES'),'N') = 'Y'

1834: -- if profile AS_OPPTY_GENERATE_NOTES is Y;
1835: -- when status, decision_date, sales_stage_id, or win prob. changes,
1836: -- note will be created automatically.
1837:
1838: IF NVL(FND_PROFILE.Value('AS_OPPTY_GENERATE_NOTES'),'N') = 'Y'
1839: THEN
1840:
1841: IF l_header_rec.status_code = FND_API.G_MISS_CHAR THEN
1842: l_header_rec.status_code := l_status;

Line 2205: l_sales_team_rec.salesforce_role_code := FND_PROFILE.Value('AS_DEF_OPP_ST_ROLE');

2201: l_Sales_Team_Rec.address_id := l_Address_Id;
2202: l_Sales_Team_Rec.lead_id := l_header_rec.lead_id;
2203: l_Sales_Team_Rec.salesforce_id := l_header_rec.owner_salesforce_id;
2204: l_sales_team_rec.sales_group_id := l_header_rec.owner_sales_group_id;
2205: l_sales_team_rec.salesforce_role_code := FND_PROFILE.Value('AS_DEF_OPP_ST_ROLE');
2206: l_Sales_Team_Rec.team_leader_flag := 'Y';
2207: l_Sales_Team_Rec.reassign_flag := 'N';
2208: l_Sales_Team_Rec.freeze_flag := 'Y';
2209: --l_Sales_Team_Rec.owner_flag := 'Y';

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

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

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

2559: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
2560: /*
2561: -- if profile AS_PRE_CUSTOM_ENABLED is set to 'Y', callout procedure is
2562: -- invoked for customization purpose
2563: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
2564: THEN
2565: AS_CALLOUT_PKG.Delete_opp_header_BU(
2566: p_api_version_number => 2.0,
2567: p_init_msg_list => FND_API.G_FALSE,

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

2718:
2719: -- solin, for bug 1554330
2720: IF l_freeze_flag = 'Y'
2721: THEN
2722: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
2723: IF l_allow_flag <> 'Y' THEN
2724: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2725: 'API_OPP_FROZEN');
2726: RAISE FND_API.G_EXC_ERROR;

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

2847: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
2848: /*
2849: -- if profile AS_POST_CUSTOM_ENABLED is set to 'Y', callout procedure is
2850: -- invoked for customization purpose
2851: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
2852: THEN
2853: AS_CALLOUT_PKG.Delete_opp_header_AU(
2854: p_api_version_number => 2.0,
2855: p_init_msg_list => FND_API.G_FALSE,

Line 3609: l_source_code_required VARCHAR2(1) := FND_PROFILE.value('AS_OPP_SOURCE_CODE_REQUIRED');

3605: and ARC_SOURCE_CODE_FOR <> 'OFFR';
3606: -- nkamble commented below line and put OFFR condition for bug#3133993
3607: --in ('CAMP', 'CSCH', 'EVEO', 'EVEH');
3608:
3609: l_source_code_required VARCHAR2(1) := FND_PROFILE.value('AS_OPP_SOURCE_CODE_REQUIRED');
3610:
3611: l_val VARCHAR2(1);
3612: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3613: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_SOURCE_PROMOTION_ID';

Line 4799: FND_PROFILE.Value('AS_OPP_ADDRESS_REQUIRED'));

4795: IF l_debug THEN
4796: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4797: 'ADDRESS_ID is not entered');
4798: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4799: FND_PROFILE.Value('AS_OPP_ADDRESS_REQUIRED'));
4800:
4801: END IF;
4802:
4803: l_check_address :=

Line 4804: nvl(FND_PROFILE.Value('AS_OPP_ADDRESS_REQUIRED'),'Y');

4800:
4801: END IF;
4802:
4803: l_check_address :=
4804: nvl(FND_PROFILE.Value('AS_OPP_ADDRESS_REQUIRED'),'Y');
4805: IF (l_check_address = 'Y')
4806: THEN
4807: AS_UTILITY_PVT.Set_Message(
4808: p_module => l_module,

Line 5504: NVL(FND_PROFILE.Value('AS_OPPTY_PROB_SS_LINK'), 'WARNING');

5500: l_max_winprob NUMBER;
5501: l_warning_msg VARCHAR2(2000) := '';
5502:
5503: l_prob_ss_link VARCHAR2(10) :=
5504: NVL(FND_PROFILE.Value('AS_OPPTY_PROB_SS_LINK'), 'WARNING');
5505:
5506: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_WinPorb_StageID';
5507:
5508: BEGIN

Line 5780: IF FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY') IS NOT NULL THEN

5776: -- Initialize API return status to SUCCESS
5777: x_return_status := FND_API.G_RET_STS_SUCCESS;
5778:
5779:
5780: IF FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY') IS NOT NULL THEN
5781: l_max_date := TRUNC(SYSDATE)+ to_number(FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY'));
5782: IF TRUNC(P_DECISION_DATE) > l_max_date THEN
5783: --DBMS_OUTPUT.PUT_LINE('rAISE ERROR');
5784: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5781: l_max_date := TRUNC(SYSDATE)+ to_number(FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY'));

5777: x_return_status := FND_API.G_RET_STS_SUCCESS;
5778:
5779:
5780: IF FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY') IS NOT NULL THEN
5781: l_max_date := TRUNC(SYSDATE)+ to_number(FND_PROFILE.value('AS_MAX_DAY_CLOSE_OPPORTUNITY'));
5782: IF TRUNC(P_DECISION_DATE) > l_max_date THEN
5783: --DBMS_OUTPUT.PUT_LINE('rAISE ERROR');
5784: x_return_status := FND_API.G_RET_STS_ERROR;
5785: AS_UTILITY_PVT.Set_Message(