[Home] [Help]
582: -- bank party sites.
583: CURSOR c_uniquepsedi IS
584: SELECT 1
585: FROM hz_contact_points hcp,
586: hz_party_sites hps,
587: hz_code_assignments hca
588: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
589: AND NVL(hcp.edi_ece_tp_location_code,
590: p_edi_rec.edi_ece_tp_location_code) =
591: p_edi_rec.edi_ece_tp_location_code
592: AND hcp.contact_point_id <> p_contact_point_rec.contact_point_id
593: AND hcp.contact_point_type = 'EDI'
594: AND hcp.status = 'A'
595: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
596: AND hcp.owner_table_id = hps.party_site_id
597: AND hps.party_id = hca.owner_table_id
598: AND hca.owner_table_name = 'HZ_PARTIES'
599: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
1473:
1474: CURSOR c_site IS
1475: SELECT hps.party_id,
1476: hps.location_id
1477: FROM hz_party_sites hps
1478: WHERE hps.party_site_id = p_party_site_rec.party_site_id;
1479:
1480: l_parent_country VARCHAR2(60);
1481: l_site_country VARCHAR2(60);
1514: IF p_mode = g_insert THEN
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: -- no point doing further validations. We're missing some data.
1522: RETURN;
1528: IF c_site%NOTFOUND THEN
1529: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1530: fnd_message.set_token('FK', 'party or location');
1531: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1532: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1533: fnd_msg_pub.add;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: -- no point doing further validations. We're missing some data.
1536: RETURN;