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 1101: ( nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y') = 'Y' ) AND --Code added for bug14172624

1097: IF (l_header_rec.owner_salesforce_id IS NOT NULL) AND
1098: (l_header_rec.owner_sales_group_id IS NOT NULL) AND
1099: (l_header_rec.owner_salesforce_id = P_Identity_Salesforce_Id ) AND
1100: (l_header_rec.owner_sales_group_id = l_salesgroup_id ) AND
1101: ( nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y') = 'Y' ) AND --Code added for bug14172624
1102: Is_Employee(l_header_rec.owner_salesforce_id)
1103: THEN
1104: --l_sales_team_rec.owner_flag := 'Y';
1105: l_Sales_Team_Rec.freeze_flag := 'Y';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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