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.

[Home] [Help]

APPS.OE_OE_INLINE_ADDRESS dependencies on FND_PROFILE

Line 154: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');

150: l_person_rec.person_last_name:=p_contact_last_name;
151: l_person_rec.person_pre_name_adjunct:=p_contact_title;
152: l_person_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
153:
154: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
155: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
156: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
157:
158: -- if the party_number is not automatically generated then get it

Line 155: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');

151: l_person_rec.person_pre_name_adjunct:=p_contact_title;
152: l_person_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
153:
154: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
155: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
156: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
157:
158: -- if the party_number is not automatically generated then get it
159: -- from the sequence

Line 156: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');

152: l_person_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
153:
154: l_gen_party_number := nvl(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'),'Y');
155: --l_gen_contact_number := nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'),'Y');
156: l_gen_contact_number := nvl(fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER'),'Y');
157:
158: -- if the party_number is not automatically generated then get it
159: -- from the sequence
160: if l_gen_party_number = 'N' then

Line 1819: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);

1815:
1816:
1817: out_auto_cust_numbering :=sysparm.generate_customer_number;
1818: --g_home_country_code := sysparm.default_country;
1819: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);
1820: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);
1821:
1822: IF out_default_country_code is not null THEN
1823: select territory_short_name,address_style

Line 1820: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);

1816:
1817: out_auto_cust_numbering :=sysparm.generate_customer_number;
1818: --g_home_country_code := sysparm.default_country;
1819: fnd_profile.get('DEFAULT_COUNTRY',out_default_country_code);
1820: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',out_email_required);
1821:
1822: IF out_default_country_code is not null THEN
1823: select territory_short_name,address_style
1824: into out_default_country,out_address_style

Line 1829: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);

1825: from fnd_territories_vl
1826: where territory_code = out_default_country_code;
1827: END IF;
1828:
1829: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);
1830: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);
1831:
1832: if out_auto_site_numbering is null then
1833: out_auto_site_numbering :='Y';

Line 1830: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);

1826: where territory_code = out_default_country_code;
1827: END IF;
1828:
1829: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',out_auto_party_numbering);
1830: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER',out_auto_site_numbering);
1831:
1832: if out_auto_site_numbering is null then
1833: out_auto_site_numbering :='Y';
1834: end if;