607: l_location_rec.created_by_module := 'POS_SUPPLIER_MGMT';
608: l_location_rec.application_id := 177;
609:
610: hz_location_v2pub.create_location (
611: p_init_msg_list => fnd_api.g_true,
612: p_location_rec => l_location_rec,
613: x_location_id => x_location_id,
614: x_return_status => x_status,
615: x_msg_count => l_msg_count,
682: l_location_rec.country := p_country;
683: l_location_rec.address1 := p_address1;
684:
685: if p_address2 is not null then l_location_rec.address2 := p_address2;
686: else l_location_rec.address2 := FND_API.G_MISS_CHAR;
687: end if;
688:
689: if p_address3 is not null then l_location_rec.address3 := p_address3;
690: else l_location_rec.address3 := FND_API.G_MISS_CHAR;
686: else l_location_rec.address2 := FND_API.G_MISS_CHAR;
687: end if;
688:
689: if p_address3 is not null then l_location_rec.address3 := p_address3;
690: else l_location_rec.address3 := FND_API.G_MISS_CHAR;
691: end if;
692:
693: if p_address4 is not null then l_location_rec.address4 := p_address4;
694: else l_location_rec.address4 := FND_API.G_MISS_CHAR;
690: else l_location_rec.address3 := FND_API.G_MISS_CHAR;
691: end if;
692:
693: if p_address4 is not null then l_location_rec.address4 := p_address4;
694: else l_location_rec.address4 := FND_API.G_MISS_CHAR;
695: end if;
696:
697: l_location_rec.city := p_city;
698: l_location_rec.postal_code := p_zip;
697: l_location_rec.city := p_city;
698: l_location_rec.postal_code := p_zip;
699:
700: if p_state is not null then l_location_rec.state := p_state;
701: else l_location_rec.state := FND_API.G_MISS_CHAR;
702: end if;
703:
704: if p_province is not null then l_location_rec.province := p_province;
705: else l_location_rec.province := FND_API.G_MISS_CHAR;
701: else l_location_rec.state := FND_API.G_MISS_CHAR;
702: end if;
703:
704: if p_province is not null then l_location_rec.province := p_province;
705: else l_location_rec.province := FND_API.G_MISS_CHAR;
706: end if;
707:
708: if p_county is not null then l_location_rec.county := p_county;
709: else l_location_rec.county := FND_API.G_MISS_CHAR;
705: else l_location_rec.province := FND_API.G_MISS_CHAR;
706: end if;
707:
708: if p_county is not null then l_location_rec.county := p_county;
709: else l_location_rec.county := FND_API.G_MISS_CHAR;
710: end if;
711:
712: l_location_rec.created_by_module := l_created_by_module;
713: l_location_rec.application_id := 177;
711:
712: l_location_rec.created_by_module := l_created_by_module;
713: l_location_rec.application_id := 177;
714: hz_location_v2pub.update_location (
715: p_init_msg_list => fnd_api.g_true,
716: p_location_rec => l_location_rec,
717: p_object_version_number => l_obj_ver,
718: x_return_status => x_status,
719: x_msg_count => l_msg_count,
946:
947: l_step := 7;
948:
949: if p_ext_bank_account_id is null then
950: l_create_flag := FND_API.G_TRUE;
951: else
952: l_create_flag := FND_API.G_FALSE;
953: end if;
954:
948:
949: if p_ext_bank_account_id is null then
950: l_create_flag := FND_API.G_TRUE;
951: else
952: l_create_flag := FND_API.G_FALSE;
953: end if;
954:
955: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
956: p_api_version => 1.0,
953: end if;
954:
955: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
956: p_api_version => 1.0,
957: p_init_msg_list => FND_API.G_TRUE,
958: p_create_flag => l_create_flag,
959: p_ext_bank_rec => l_ext_bank_rec,
960: p_ext_bank_branch_rec => l_ext_bank_branch_rec,
961: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1138: END IF;
1139:
1140: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
1141: p_api_version => 1.0,
1142: p_init_msg_list => FND_API.G_FALSE,
1143: p_commit => FND_API.G_FALSE,
1144: x_return_status => x_status,
1145: x_msg_count => l_msg_count,
1146: x_msg_data => x_exception_msg,
1139:
1140: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
1141: p_api_version => 1.0,
1142: p_init_msg_list => FND_API.G_FALSE,
1143: p_commit => FND_API.G_FALSE,
1144: x_return_status => x_status,
1145: x_msg_count => l_msg_count,
1146: x_msg_data => x_exception_msg,
1147: p_payee => l_payee_rec,
1350:
1351: -- Create a bank
1352: IBY_EXT_BANKACCT_PUB.create_ext_bank (
1353: p_api_version => 1.0,
1354: p_init_msg_list => FND_API.G_TRUE,
1355: p_ext_bank_rec => l_ext_bank_rec,
1356: x_bank_id => l_bank_id,
1357: x_return_status => x_status,
1358: x_msg_count => l_msg_count,
1386: l_party_site_rec.application_id := 177;
1387:
1388: hz_party_site_v2pub.create_party_site
1389: (
1390: p_init_msg_list => FND_API.G_FALSE,
1391: p_party_site_rec => l_party_site_rec,
1392: x_party_site_id => l_bank_party_site_id,
1393: x_party_site_number => l_bank_party_site_number,
1394: x_return_status => x_status,
1431: END IF;
1432:
1433: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (
1434: p_api_version => 1.0,
1435: p_init_msg_list => FND_API.G_TRUE,
1436: p_ext_bank_branch_rec => l_ext_bank_branch_rec,
1437: x_branch_id => l_branch_id,
1438: x_return_status => x_status,
1439: x_msg_count => l_msg_count,
1467: l_party_site_rec.application_id := 177;
1468:
1469: hz_party_site_v2pub.create_party_site
1470: (
1471: p_init_msg_list => FND_API.G_FALSE,
1472: p_party_site_rec => l_party_site_rec,
1473: x_party_site_id => l_branch_party_site_id,
1474: x_party_site_number => l_branch_party_site_number,
1475: x_return_status => x_status,
1483: -- Find out if it exists
1484: if l_ext_bank_account_id is null then
1485: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1486: p_api_version => 1.0,
1487: p_init_msg_list => FND_API.G_FALSE,
1488: p_bank_id => l_bank_id,
1489: p_branch_id => l_branch_id,
1490: p_acct_number => l_temp_account_rec.bank_account_num,
1491: p_acct_name => l_temp_account_rec.bank_account_name,
1512:
1513: if l_primary_owner_id <> l_temp_account_rec.ACCOUNT_OWNER_PARTY_ID then
1514: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (
1515: p_api_version => 1.0,
1516: p_init_msg_list => FND_API.G_FALSE,
1517: p_bank_account_id => l_ext_bank_account_id,
1518: p_acct_owner_party_id => l_non_primary_owner_id,
1519: x_joint_acct_owner_id => l_joint_acct_owner_id,
1520: x_return_status => x_status,
1615: END IF;
1616:
1617: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
1618: p_api_version => 1.0,
1619: p_init_msg_list => FND_API.G_TRUE,
1620: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1621: x_acct_id => l_ext_bank_account_id,
1622: x_return_status => x_status,
1623: x_msg_count => l_msg_count,
1673: /* BUG 10384712 END */
1674:
1675: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct (
1676: p_api_version => 1.0,
1677: p_init_msg_list => FND_API.G_TRUE,
1678: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1679: x_return_status => x_status,
1680: x_msg_count => l_msg_count,
1681: x_msg_data => x_exception_msg,
1952: if l_bank_id is not null and l_branch_id is not null and
1953: p_EXT_BANK_ACCOUNT_ID is null and x_status = 'S' then
1954: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1955: p_api_version => 1.0,
1956: p_init_msg_list => FND_API.G_FALSE,
1957: p_bank_id => l_bank_id,
1958: p_branch_id => l_branch_id,
1959: p_acct_number => p_bank_account_number,
1960: p_acct_name => p_bank_account_name,