[Home] [Help]
2257: WHERE HR.organization_id = FIN.org_id
2258: AND ( HR.name = p_org_name OR
2259: HR.organization_id = p_org_id);
2260:
2261: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);
2262: --
2263: --
2264: if ( l_default_country_code is null ) then
2265: p_country_code := l_home_country_code;
3696: -- Commenting this code as part of bug 5066199
3697: -- l_org_rec.sic_code := l_vendor_rec.sic_code;
3698: l_org_rec.tax_reference := l_vendor_rec.tax_reference;
3699:
3700: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
3701: IF nvl(l_party_num, 'Y') = 'N' THEN
3702: SELECT HZ_PARTY_NUMBER_S.Nextval
3703: INTO l_party_rec.party_number
3704: FROM DUAL;
5105: -- Validate the jgzz_fiscal_code value
5106: --
5107:
5108:
5109: fnd_profile.get('DEFAULT_COUNTRY',l_default_country_code);
5110:
5111: IF( l_default_country_code is null
5112: AND
5113: p_vendor_rec.set_of_books_id IS NOT NULL) then
8600: --Bug 6753822 - Added NVL on vendor_type_lookup_code
8601: IF (NVL(l_vendor_type_lookup_code,'DUMMY') <> 'EMPLOYEE') then
8602: -- udhenuko Bug 6823885 start
8603: --We need to populate the party site number based on profile value.
8604: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
8605: IF nvl(l_party_site_num, 'Y') = 'N' THEN
8606: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
8607: INTO l_party_site_rec.party_site_number
8608: FROM DUAL;
13979: --bug 13339733
13980: --l_per_rec.person_name_phonetic := l_vendor_contact_rec.contact_name_phonetic;
13981: l_per_rec.known_as := l_vendor_contact_rec.contact_name_phonetic;
13982:
13983: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
13984: IF nvl(l_party_num, 'Y') = 'N' THEN
13985: SELECT HZ_PARTY_NUMBER_S.Nextval
13986: INTO l_party_rec.party_number
13987: FROM DUAL;
14091: l_rel_rec.start_date := sysdate;
14092: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';
14093: l_rel_rec.application_id := 200;
14094:
14095: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
14096: IF nvl(l_party_num, 'Y') = 'N' THEN
14097: SELECT HZ_PARTY_NUMBER_S.Nextval
14098: INTO l_party_rec.party_number
14099: FROM DUAL;
14195: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
14196: l_party_site_rec.application_id := 200;
14197: l_party_site_rec.party_id := l_vendor_contact_rec.rel_party_id;
14198: -- udhenuko Bug 6823885 start. Party site number populated based on profile.
14199: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
14200: IF nvl(l_party_site_num, 'Y') = 'N' THEN
14201: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
14202: INTO l_party_site_rec.party_site_number
14203: FROM DUAL;
15918: -POS (UI) implemented this thru bug 8819829 */
15919:
15920: l_unique := 'Y'; /* Bug 9580651 - assigned 'Y' instead of NULL */
15921: /* Bug 9580651 - Getting the value of the profile "Allow Suppliers with duplicated TP id" */
15922: fnd_profile.get('POS_ALLOW_SUPP_DUPE_TAXPYR_ID',l_allow_dupe_taxpyr_id);
15923: if (l_allow_dupe_taxpyr_id = 'N') then
15924: pos_vendor_reg_pkg.is_taxpayer_id_unique
15925: ( p_supp_regid => -1
15926: , p_taxpayer_id => vendor_int_rec.num_1099