[Home] [Help]
594: -- bank party sites.
595: CURSOR c_uniquepsedi IS
596: SELECT 1
597: FROM hz_contact_points hcp,
598: hz_party_sites hps,
599: hz_code_assignments hca
600: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
601: AND NVL(hcp.edi_ece_tp_location_code,
602: p_edi_rec.edi_ece_tp_location_code) =
603: p_edi_rec.edi_ece_tp_location_code
604: AND hcp.contact_point_id <> p_contact_point_rec.contact_point_id
605: AND hcp.contact_point_type = 'EDI'
606: AND hcp.status = 'A'
607: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
608: AND hcp.owner_table_id = hps.party_site_id
609: AND hps.party_id = hca.owner_table_id
610: AND hca.owner_table_name = 'HZ_PARTIES'
611: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
1485:
1486: CURSOR c_site IS
1487: SELECT hps.party_id,
1488: hps.location_id
1489: FROM hz_party_sites hps
1490: WHERE hps.party_site_id = p_party_site_rec.party_site_id;
1491:
1492: l_parent_country VARCHAR2(60);
1493: l_site_country VARCHAR2(60);
1526: IF p_mode = g_insert THEN
1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1528: fnd_message.set_token('FK', 'party or location');
1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1531: fnd_msg_pub.add;
1532: x_return_status := fnd_api.g_ret_sts_error;
1533: -- no point doing further validations. We're missing some data.
1534: RETURN;
1540: IF c_site%NOTFOUND THEN
1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1542: fnd_message.set_token('FK', 'party or location');
1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1545: fnd_msg_pub.add;
1546: x_return_status := fnd_api.g_ret_sts_error;
1547: -- no point doing further validations. We're missing some data.
1548: RETURN;