APPS.MST_WB_UTIL dependencies on FND_PROFILE

Line 45: l_partner_type_str := fnd_profile.value ( 'MST_COMPANY_NAME' );

41: IF l_Partner_Id IS NOT NULL AND l_Partner_Type IS NOT NULL
42: THEN
43: IF l_Partner_Type = 1
44: THEN -- Organization
45: l_partner_type_str := fnd_profile.value ( 'MST_COMPANY_NAME' );
46: ELSIF l_Partner_Type = 2
47: THEN -- Customer
48: l_partner_type_str := 'CUSTOMER';
49: ELSIF l_Partner_Type = 3

Line 602: l_name := fnd_profile.value('MST_COMPANY_NAME');

598: END IF;
599: END LOOP;
600:
601: IF l_owner_type = 1 THEN
602: l_name := fnd_profile.value('MST_COMPANY_NAME');
603: ELSE
604: OPEN CUR_COMPANY_NAME(l_owner_party_ID);
605: FETCH CUR_COMPANY_NAME INTO l_Name;
606: CLOSE CUR_COMPANY_NAME;

Line 2374: l_contact_person := fnd_profile.value('MST_COMPANY_CONTACT_NAME');

2370:
2371: begin
2372: if p_owner_type_id = 1 then
2373: if p_ret_str_type = 'NAME' then
2374: l_contact_person := fnd_profile.value('MST_COMPANY_CONTACT_NAME');
2375: return l_contact_person;
2376: elsif p_ret_str_type = 'PHONE' then
2377: l_phone_num := fnd_profile.value('MST_COMPANY_CONTACT_PHONE');
2378: return l_phone_num;

Line 2377: l_phone_num := fnd_profile.value('MST_COMPANY_CONTACT_PHONE');

2373: if p_ret_str_type = 'NAME' then
2374: l_contact_person := fnd_profile.value('MST_COMPANY_CONTACT_NAME');
2375: return l_contact_person;
2376: elsif p_ret_str_type = 'PHONE' then
2377: l_phone_num := fnd_profile.value('MST_COMPANY_CONTACT_PHONE');
2378: return l_phone_num;
2379: elsif p_ret_str_type = 'EMAIL' then
2380: l_email_address := fnd_profile.value('MST_COMPANY_CONTACT_EMAIL');
2381: return l_email_address;

Line 2380: l_email_address := fnd_profile.value('MST_COMPANY_CONTACT_EMAIL');

2376: elsif p_ret_str_type = 'PHONE' then
2377: l_phone_num := fnd_profile.value('MST_COMPANY_CONTACT_PHONE');
2378: return l_phone_num;
2379: elsif p_ret_str_type = 'EMAIL' then
2380: l_email_address := fnd_profile.value('MST_COMPANY_CONTACT_EMAIL');
2381: return l_email_address;
2382: else
2383: return null;
2384: end if;

Line 2471: l_Name := fnd_profile.value('MST_COMPANY_NAME');

2467: FROM wsh_location_owners wlo
2468: WHERE wlo.wsh_location_id = P_Location_id
2469: AND wlo.owner_type = P_Owner_Type;
2470: IF P_Owner_Type = 1 THEN
2471: l_Name := fnd_profile.value('MST_COMPANY_NAME');
2472: ELSE
2473: OPEN CUR_COMPANY_NAME(l_owner_party_id);
2474: FETCH CUR_COMPANY_NAME INTO l_Name;
2475: CLOSE CUR_COMPANY_NAME;

Line 5609: l_str2 := fnd_profile.value('MST_COMPANY_NAME');

5605: l_str2 := Get_Partner_Name(l_id4, 1);
5606: Elsif l_id5 Is Not Null Then
5607: l_str2 := Get_Partner_Name(l_id5, 2);
5608: Elsif l_id6 Is Not Null Then
5609: l_str2 := fnd_profile.value('MST_COMPANY_NAME');
5610: End If;
5611: fnd_message.set_token('CUST_SUPPLIER', l_str2);
5612: l_message := fnd_message.get;
5613: ELSIF P_EXCEPTION_TYPE = 1000 THEN