DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_PARTIES

Line 983: FROM hz_parties

979: IF(l_party_id <> -1) THEN
980:
981: SELECT party_id
982: INTO l_party_id
983: FROM hz_parties
984: WHERE party_id = l_party_id
985: FOR UPDATE NOWAIT;
986:
987: log('Denormalize location record to party: '||l_party_id);

Line 989: UPDATE HZ_PARTIES

985: FOR UPDATE NOWAIT;
986:
987: log('Denormalize location record to party: '||l_party_id);
988:
989: UPDATE HZ_PARTIES
990: SET country = l_location_rec.country,
991: address1 = l_location_rec.address1,
992: address2 = l_location_rec.address2,
993: address3 = l_location_rec.address3,

Line 1016: fnd_message.set_token('TABLE', 'HZ_PARTIES');

1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: log('Cannot update party due to record change.');
1015: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1016: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1017: fnd_msg_pub.add;
1018: CLOSE ident_address;
1019: RAISE fnd_api.g_exc_error;
1020: END;