DBA Data[Home] [Help]

APPS.OKL_RCA_PVT dependencies on ARP_MESSAGE

Line 3822: arp_message.set_line('OKL_RCA_PVT.OKL_RCA_PARTY_MERGE()+');

3818: BEGIN
3819: --
3820: fnd_file.put_line(fnd_file.log, 'OKL_RCA_PVT.OKL_RCA_PARTY_MERGE');
3821: --
3822: arp_message.set_line('OKL_RCA_PVT.OKL_RCA_PARTY_MERGE()+');
3823:
3824: x_return_status := FND_API.G_RET_STS_SUCCESS;
3825:
3826:

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

3853: -- not transfer and return the id of the duplicate record as the Merged To Id
3854:
3855: if p_from_fk_id <> p_to_fk_id then
3856: begin
3857: arp_message.set_name('AR','AR_UPDATING_TABLE');
3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
3859: --
3860: --
3861: UPDATE OKL_TXL_RCPT_APPS_B RCAB

Line 3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);

3854:
3855: if p_from_fk_id <> p_to_fk_id then
3856: begin
3857: arp_message.set_name('AR','AR_UPDATING_TABLE');
3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
3859: --
3860: --
3861: UPDATE OKL_TXL_RCPT_APPS_B RCAB
3862: SET RCAB.ILE_ID = p_to_fk_id

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

3866: ,RCAB.last_update_login = arp_standard.profile.last_update_login
3867: WHERE RCAB.ILE_ID = p_from_fk_id ;
3868:
3869: l_count := sql%rowcount;
3870: arp_message.set_name('AR','AR_ROWS_UPDATED');
3871: arp_message.set_token('NUM_ROWS',to_char(l_count));
3872: --
3873: exception
3874: when others then

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

3867: WHERE RCAB.ILE_ID = p_from_fk_id ;
3868:
3869: l_count := sql%rowcount;
3870: arp_message.set_name('AR','AR_ROWS_UPDATED');
3871: arp_message.set_token('NUM_ROWS',to_char(l_count));
3872: --
3873: exception
3874: when others then
3875: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

3871: arp_message.set_token('NUM_ROWS',to_char(l_count));
3872: --
3873: exception
3874: when others then
3875: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3876: --
3877: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3878: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
3879: --