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

Line 143: px_SALES_LEAD_rec.channel_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_CHANNEL');

139: /* IF (px_SALES_LEAD_rec.channel_code IS NULL) OR
140: (px_SALES_LEAD_rec.channel_code = FND_API.G_MISS_CHAR
141: AND p_mode = AS_UTILITY_PVT.G_CREATE)
142: THEN
143: px_SALES_LEAD_rec.channel_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_CHANNEL');
144: END IF; */
145:
146: IF (px_SALES_LEAD_rec.status_code IS NULL) OR
147: (px_SALES_LEAD_rec.status_code = FND_API.G_MISS_CHAR

Line 150: px_SALES_LEAD_rec.status_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_STATUS');

146: IF (px_SALES_LEAD_rec.status_code IS NULL) OR
147: (px_SALES_LEAD_rec.status_code = FND_API.G_MISS_CHAR
148: AND p_mode = AS_UTILITY_PVT.G_CREATE)
149: THEN
150: px_SALES_LEAD_rec.status_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_STATUS');
151: END IF;
152:
153:
154: IF (px_SALES_LEAD_rec.vehicle_response_code IS NULL) OR

Line 158: px_SALES_LEAD_rec.vehicle_response_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');

154: IF (px_SALES_LEAD_rec.vehicle_response_code IS NULL) OR
155: (px_SALES_LEAD_rec.vehicle_response_code = FND_API.G_MISS_CHAR
156: AND p_mode = AS_UTILITY_PVT.G_CREATE)
157: THEN
158: px_SALES_LEAD_rec.vehicle_response_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
159: END IF;
160:
161:
162: IF (px_SALES_LEAD_rec.budget_status_code IS NULL) OR

Line 166: px_SALES_LEAD_rec.budget_status_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_BUDGET_STATUS');

162: IF (px_SALES_LEAD_rec.budget_status_code IS NULL) OR
163: (px_SALES_LEAD_rec.budget_status_code = FND_API.G_MISS_CHAR
164: AND p_mode = AS_UTILITY_PVT.G_CREATE)
165: THEN
166: px_SALES_LEAD_rec.budget_status_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_BUDGET_STATUS');
167: END IF;
168:
169:
170:

Line 175: px_SALES_LEAD_rec.decision_timeframe_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_DECISION_TIMEFRAME');

171: IF (px_SALES_LEAD_rec.decision_timeframe_code IS NULL) OR
172: (px_SALES_LEAD_rec.decision_timeframe_code = FND_API.G_MISS_CHAR
173: AND p_mode = AS_UTILITY_PVT.G_CREATE)
174: THEN
175: px_SALES_LEAD_rec.decision_timeframe_code := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_DECISION_TIMEFRAME');
176: END IF;
177:
178:
179:

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

253: (px_SALES_LEAD_rec.currency_code = FND_API.G_MISS_CHAR
254: and p_mode = AS_UTILITY_PVT.G_CREATE)
255: THEN
256: px_SALES_LEAD_rec.currency_code :=
257: FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY');
258: End If;
259: --END IF;
260:
261: End Set_default_values;

Line 781: 'ADDRESS_REQUIRED: ' || FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'));

777: END IF;
778: IF (AS_DEBUG_LOW_ON) THEN
779:
780: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
781: 'ADDRESS_REQUIRED: ' || FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'));
782: --FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'));
783: END IF;
784:
785: l_check_address :=

Line 782: --FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'));

778: IF (AS_DEBUG_LOW_ON) THEN
779:
780: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
781: 'ADDRESS_REQUIRED: ' || FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'));
782: --FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'));
783: END IF;
784:
785: l_check_address :=
786: --nvl(FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'),'Y');

Line 786: --nvl(FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'),'Y');

782: --FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'));
783: END IF;
784:
785: l_check_address :=
786: --nvl(FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'),'Y');
787: nvl(FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'),'Y');
788: IF (l_check_address = 'Y')
789: THEN
790: AS_UTILITY_PVT.Set_Message(

Line 787: nvl(FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'),'Y');

783: END IF;
784:
785: l_check_address :=
786: --nvl(FND_PROFILE.Value('AS_CUSTOMER_ADDRESS_REQUIRED'),'Y');
787: nvl(FND_PROFILE.Value('AS_LEAD_ADDRESS_REQUIRED'),'Y');
788: IF (l_check_address = 'Y')
789: THEN
790: AS_UTILITY_PVT.Set_Message(
791: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 895: l_newStateTransition := FND_PROFILE.VALUE('AS_LEAD_STATE_TRANSITION');

891: -- OS: Lead Link Status profile (e.g Converted to Opportunity) then
892: -- first check lead link table to make sure an opportunity exists
893: -- This check will be dependent on a profile.
894: --l_val := 'N';
895: l_newStateTransition := FND_PROFILE.VALUE('AS_LEAD_STATE_TRANSITION');
896: l_linkStatus := FND_PROFILE.VALUE('AS_LEAD_LINK_STATUS');
897:
898: OPEN C_GET_STATUS_CODE (p_sales_lead_id);
899: FETCH C_GET_STATUS_CODE INTO l_status_code;

Line 896: l_linkStatus := FND_PROFILE.VALUE('AS_LEAD_LINK_STATUS');

892: -- first check lead link table to make sure an opportunity exists
893: -- This check will be dependent on a profile.
894: --l_val := 'N';
895: l_newStateTransition := FND_PROFILE.VALUE('AS_LEAD_STATE_TRANSITION');
896: l_linkStatus := FND_PROFILE.VALUE('AS_LEAD_LINK_STATUS');
897:
898: OPEN C_GET_STATUS_CODE (p_sales_lead_id);
899: FETCH C_GET_STATUS_CODE INTO l_status_code;
900: CLOSE C_GET_STATUS_CODE;

Line 1029: FND_PROFILE.Value('AS_SOURCE_CODE_MANDATORY_LEADS'));

1025:
1026:
1027: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1028: 'SOURCE CODE REQUIRED: ' ||
1029: FND_PROFILE.Value('AS_SOURCE_CODE_MANDATORY_LEADS'));
1030:
1031: END IF;
1032:
1033: l_source_promotion_id :=

Line 1034: nvl(FND_PROFILE.Value('AS_SOURCE_CODE_MANDATORY_LEADS'),'Y');

1030:
1031: END IF;
1032:
1033: l_source_promotion_id :=
1034: nvl(FND_PROFILE.Value('AS_SOURCE_CODE_MANDATORY_LEADS'),'Y');
1035:
1036:
1037: -- validate SOURCE_PROMOTION_ID (NOT NULL column)
1038: IF (l_source_promotion_id='Y' AND ( p_source_promotion_id is NULL or

Line 1838: l_profile_opp_lead_link := FND_PROFILE.Value('AS_LEAD_LINK_STATUS');

1834: OPEN C_Status_Exists ( p_status_code);
1835: FETCH C_Status_Exists into l_val;
1836:
1837:
1838: l_profile_opp_lead_link := FND_PROFILE.Value('AS_LEAD_LINK_STATUS');
1839: IF (AS_DEBUG_LOW_ON) THEN
1840:
1841: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1842: 'l_profile_opp_lead_link: ' || l_profile_opp_lead_link);

Line 1873: l_profile_def_close_reason := FND_PROFILE.Value('AS_DEFAULT_LEAD_CLOSE_REASON');

1869:
1870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1871: 'yes lead link');
1872: END IF;
1873: l_profile_def_close_reason := FND_PROFILE.Value('AS_DEFAULT_LEAD_CLOSE_REASON');
1874: IF (AS_DEBUG_LOW_ON) THEN
1875:
1876: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1877: 'def_close: ' || l_profile_def_close_reason);

Line 3280: l_default_address_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_ADDRESS');

3276:
3277: l_default_lead_name VARCHAR2(2000);
3278: l_default_sales_stage NUMBER;
3279:
3280: l_default_address_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_DEFAULT_LEAD_ADDRESS');
3281:
3282: -- Bug 3385646 - MKTU3R10:COUNTRY IS NOT POPULATED WHEN THE LEAD IS CREATED THROUGH HTML
3283: CURSOR c_get_country_code (X_CUSTOMER_ID NUMBER, X_ADDRESS_ID NUMBER) IS
3284: select LOC.COUNTRY

Line 3588: l_auto_qualify_profile := nvl(FND_PROFILE.Value('AS_AUTO_QUALIFY'),'N');

3584:
3585:
3586:
3587: /*
3588: l_auto_qualify_profile := nvl(FND_PROFILE.Value('AS_AUTO_QUALIFY'),'N');
3589: IF(l_sales_lead_rec.qualified_flag = 'N' and
3590: l_auto_qualify_profile = 'Y')
3591:
3592: --IF (l_sales_lead_rec.status_code = 'NEW' or

Line 3630: l_referral_status_profile := FND_PROFILE.Value('REF_STATUS_FOR_NEW_LEAD');

3626:
3627: if ((l_SALES_LEAD_rec.REFERRAL_STATUS is null or l_SALES_LEAD_rec.REFERRAL_STATUS = FND_API.G_MISS_CHAR )
3628: and l_SALES_LEAD_rec.REFERRAL_TYPE is not null and l_sales_lead_rec.REFERRAL_TYPE <> FND_API.G_MISS_CHAR)
3629: then
3630: l_referral_status_profile := FND_PROFILE.Value('REF_STATUS_FOR_NEW_LEAD');
3631: else
3632: l_referral_status_profile := l_sales_lead_rec.REFERRAL_STATUS;
3633: end if;
3634:

Line 4869: l_lead_owner_privilege := fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER');

4865:
4866:
4867:
4868:
4869: l_lead_owner_privilege := fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER');
4870: IF l_check_owner <> 'Y'
4871: AND ((l_assign_to_salesforce_id <> p_sales_lead_rec.assign_to_salesforce_id) OR
4872: (p_sales_lead_rec.assign_to_salesforce_id is null))
4873: AND l_lead_owner_privilege <> 'Y' -- exception made, even if not owner but if profile is set then lets you

Line 4961: /* l_auto_qualify_profile := nvl(FND_PROFILE.Value('AS_AUTO_QUALIFY'),'N');

4957: FETCH C_GET_STATUS_CODE INTO l_status_code;
4958: CLOSE C_GET_STATUS_CODE;
4959:
4960:
4961: /* l_auto_qualify_profile := nvl(FND_PROFILE.Value('AS_AUTO_QUALIFY'),'N');
4962:
4963: IF (AS_DEBUG_LOW_ON) THEN
4964:
4965:

Line 5091: --l_tar_SALES_LEAD_rec.status_code := fnd_profile.value('AS_LEAD_ROUTING_STATUS');

5087: l_assign_to_salesforce_id
5088: THEN
5089:
5090: -- as per bug 2238553 routing shud not change status of lead hence commenting out the next line.
5091: --l_tar_SALES_LEAD_rec.status_code := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5092: l_tar_SALES_LEAD_rec.accept_flag := 'N';
5093: l_tar_SALES_LEAD_rec.assign_date := SYSDATE;
5094:
5095: END IF;

Line 5108: l_referral_status_profile := FND_PROFILE.Value('REF_STATUS_FOR_NEW_LEAD');

5104: if (l_tar_SALES_LEAD_rec.REFERRAL_TYPE is not null and l_tar_sales_lead_rec.REFERRAL_TYPE <> FND_API.G_MISS_CHAR)
5105: -- if referral type lead and the current referral status in database is null then need to do something.
5106: then
5107: if (l_current_ref_status is null) then
5108: l_referral_status_profile := FND_PROFILE.Value('REF_STATUS_FOR_NEW_LEAD');
5109: else
5110: l_referral_status_profile := FND_API.G_MISS_CHAR; -- you dont want to change the non null referral status
5111: end if ; -- if l_current_ref_status is null
5112: end if; -- if a referral type lead

Line 6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');

6510: 'p_contact_role_code is '||p_contact_role_code);
6511: END IF;
6512:
6513: -- get all of the required variables for a Lead to be qualified
6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');
6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');

Line 6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');

6511: END IF;
6512:
6513: -- get all of the required variables for a Lead to be qualified
6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');
6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');

Line 6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');

6512:
6513: -- get all of the required variables for a Lead to be qualified
6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');
6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');

Line 6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');

6513: -- get all of the required variables for a Lead to be qualified
6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');
6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');
6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');

Line 6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');

6514: l_project_name_req := fnd_profile.value('AS_SALES_LEAD_PROJECT_NAME_REQ');
6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');
6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');
6522:

Line 6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');

6515: l_channel_req := fnd_profile.value('AS_SALES_LEAD_CHANNEL_REQ');
6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');
6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');
6522:
6523:

Line 6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');

6516: l_time_frame_req := fnd_profile.value('AS_SALES_LEAD_TIME_FRAME_REQ');
6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');
6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');
6522:
6523:
6524: IF (AS_DEBUG_LOW_ON) THEN

Line 6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');

6517: l_total_budget_req := fnd_profile.value('AS_SALES_LEAD_TOTAL_BUDGET_REQ');
6518: l_contact_phone_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_PHONE_REQ');
6519: l_contact_role_req := fnd_profile.value('AS_SALES_LEAD_CONTACT_ROLE_REQ');
6520: l_budget_status_req := fnd_profile.value('AS_SALES_LEAD_BUDGET_STATUS_REQ');
6521: l_campaign_code_req := fnd_profile.value('AS_SALES_LEAD_CAMPAIGN_CODE_REQ');
6522:
6523:
6524: IF (AS_DEBUG_LOW_ON) THEN
6525: