DBA Data[Home] [Help]

APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_OPEN_INT_ALL

Line 1143: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT_ALL',FALSE);

1139: -- not transfer and return the id of the duplicate record as the Merged To Id
1140: if p_from_fk_id <> p_to_fk_id then
1141: begin
1142: arp_message.set_name('AR','AR_UPDATING_TABLE');
1143: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT_ALL',FALSE);
1144:
1145: UPDATE OKL_OPEN_INT_ALL opi
1146: SET opi.party_ID = p_to_fk_id
1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)

Line 1145: UPDATE OKL_OPEN_INT_ALL opi

1141: begin
1142: arp_message.set_name('AR','AR_UPDATING_TABLE');
1143: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT_ALL',FALSE);
1144:
1145: UPDATE OKL_OPEN_INT_ALL opi
1146: SET opi.party_ID = p_to_fk_id
1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)
1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)
1149: ,opi.object_version_number = opi.object_version_number + 1

Line 1163: 'OKL_OPEN_INT_ALL for = '|| p_from_id));

1159: exception
1160: when others then
1161: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1162: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1163: 'OKL_OPEN_INT_ALL for = '|| p_from_id));
1164: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: end;
1167: end if;