DBA Data[Home] [Help]

APPS.OKL_OPI_PVT dependencies on ARP_MESSAGE

Line 1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');

1464: BEGIN
1465: --
1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');
1467: --
1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');
1469:
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;
1471:
1472:

Line 1503: arp_message.set_name('AR','AR_UPDATING_TABLE');

1499: -- not transfer and return the id of the duplicate record as the Merged To Id
1500:
1501: if p_from_fk_id <> p_to_fk_id then
1502: begin
1503: arp_message.set_name('AR','AR_UPDATING_TABLE');
1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);
1505: --
1506: --
1507: UPDATE OKL_OPEN_INT opi

Line 1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);

1500:
1501: if p_from_fk_id <> p_to_fk_id then
1502: begin
1503: arp_message.set_name('AR','AR_UPDATING_TABLE');
1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);
1505: --
1506: --
1507: UPDATE OKL_OPEN_INT opi
1508: SET opi.party_ID = p_to_fk_id

Line 1516: arp_message.set_name('AR','AR_ROWS_UPDATED');

1512: ,opi.last_update_login = arp_standard.profile.last_update_login
1513: WHERE opi.party_ID = p_from_fk_id ;
1514:
1515: l_count := sql%rowcount;
1516: arp_message.set_name('AR','AR_ROWS_UPDATED');
1517: arp_message.set_token('NUM_ROWS',to_char(l_count));
1518: --
1519: exception
1520: when others then

Line 1517: arp_message.set_token('NUM_ROWS',to_char(l_count));

1513: WHERE opi.party_ID = p_from_fk_id ;
1514:
1515: l_count := sql%rowcount;
1516: arp_message.set_name('AR','AR_ROWS_UPDATED');
1517: arp_message.set_token('NUM_ROWS',to_char(l_count));
1518: --
1519: exception
1520: when others then
1521: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

Line 1521: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

1517: arp_message.set_token('NUM_ROWS',to_char(l_count));
1518: --
1519: exception
1520: when others then
1521: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1522: --
1523: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1524: 'OKL_OPEN_INT for = '|| p_from_id));
1525: --