eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on ARP_MESSAGE

Line 7288: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');

7284: BEGIN
7285: --
7286: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE');
7287: --
7288: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');
7289:
7290: x_return_status := FND_API.G_RET_STS_SUCCESS;
7291:
7292:

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

7319: -- not transfer and return the id of the duplicate record as the Merged To Id
7320:
7321: if p_from_fk_id <> p_to_fk_id then
7322: begin
7323: arp_message.set_name('AR','AR_UPDATING_TABLE');
7324: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7325: --
7326: --
7327:

Line 7324: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);

7320:
7321: if p_from_fk_id <> p_to_fk_id then
7322: begin
7323: arp_message.set_name('AR','AR_UPDATING_TABLE');
7324: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7325: --
7326: --
7327:
7328: UPDATE OKL_INS_POLICIES_B IPYB

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

7333: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7334: WHERE IPYB.ISU_ID = p_from_fk_id ;
7335: x_to_id := p_from_id;
7336: l_count := sql%rowcount;
7337: arp_message.set_name('AR','AR_ROWS_UPDATED');
7338: arp_message.set_token('NUM_ROWS',to_char(l_count));
7339: --
7340: exception
7341: when others then

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

7334: WHERE IPYB.ISU_ID = p_from_fk_id ;
7335: x_to_id := p_from_id;
7336: l_count := sql%rowcount;
7337: arp_message.set_name('AR','AR_ROWS_UPDATED');
7338: arp_message.set_token('NUM_ROWS',to_char(l_count));
7339: --
7340: exception
7341: when others then
7342: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7338: arp_message.set_token('NUM_ROWS',to_char(l_count));
7339: --
7340: exception
7341: when others then
7342: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7343: --
7344: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7345: 'OKL_INS_POLICIES for = '|| p_from_id));
7346: --

Line 7375: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE()+');

7371: BEGIN
7372: --
7373: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE');
7374: --
7375: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE()+');
7376:
7377: x_return_status := FND_API.G_RET_STS_SUCCESS;
7378:
7379:

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

7406: -- not transfer and return the id of the duplicate record as the Merged To Id
7407:
7408: if p_from_fk_id <> p_to_fk_id then
7409: begin
7410: arp_message.set_name('AR','AR_UPDATING_TABLE');
7411: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7412: --
7413: --
7414:

Line 7411: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);

7407:
7408: if p_from_fk_id <> p_to_fk_id then
7409: begin
7410: arp_message.set_name('AR','AR_UPDATING_TABLE');
7411: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7412: --
7413: --
7414:
7415: UPDATE OKL_INS_POLICIES_B IPYB

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

7420: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7421: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7422:
7423: l_count := sql%rowcount;
7424: arp_message.set_name('AR','AR_ROWS_UPDATED');
7425: arp_message.set_token('NUM_ROWS',to_char(l_count));
7426: --
7427: exception
7428: when others then

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

7421: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7422:
7423: l_count := sql%rowcount;
7424: arp_message.set_name('AR','AR_ROWS_UPDATED');
7425: arp_message.set_token('NUM_ROWS',to_char(l_count));
7426: --
7427: exception
7428: when others then
7429: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7425: arp_message.set_token('NUM_ROWS',to_char(l_count));
7426: --
7427: exception
7428: when others then
7429: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7430: --
7431: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7432: 'OKL_INS_POLICIES for = '|| p_from_id));
7433: --

Line 7461: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE()+');

7457: BEGIN
7458: --
7459: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE');
7460: --
7461: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE()+');
7462:
7463: x_return_status := FND_API.G_RET_STS_SUCCESS;
7464:
7465:

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

7492: -- not transfer and return the id of the duplicate record as the Merged To Id
7493:
7494: if p_from_fk_id <> p_to_fk_id then
7495: begin
7496: arp_message.set_name('AR','AR_UPDATING_TABLE');
7497: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7498: --
7499: --
7500:

Line 7497: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);

7493:
7494: if p_from_fk_id <> p_to_fk_id then
7495: begin
7496: arp_message.set_name('AR','AR_UPDATING_TABLE');
7497: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7498: --
7499: --
7500:
7501: UPDATE OKL_INS_POLICIES_B IPYB

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

7506: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7507: WHERE IPYB.INT_ID = p_from_fk_id ;
7508:
7509: l_count := sql%rowcount;
7510: arp_message.set_name('AR','AR_ROWS_UPDATED');
7511: arp_message.set_token('NUM_ROWS',to_char(l_count));
7512: --
7513: exception
7514: when others then

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

7507: WHERE IPYB.INT_ID = p_from_fk_id ;
7508:
7509: l_count := sql%rowcount;
7510: arp_message.set_name('AR','AR_ROWS_UPDATED');
7511: arp_message.set_token('NUM_ROWS',to_char(l_count));
7512: --
7513: exception
7514: when others then
7515: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7511: arp_message.set_token('NUM_ROWS',to_char(l_count));
7512: --
7513: exception
7514: when others then
7515: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7516: --
7517: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7518: 'OKL_INS_POLICIES for = '|| p_from_id));
7519: --

Line 7546: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE()+');

7542: BEGIN
7543: --
7544: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE');
7545: --
7546: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE()+');
7547:
7548: x_return_status := FND_API.G_RET_STS_SUCCESS;
7549:
7550:

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

7577: -- not transfer and return the id of the duplicate record as the Merged To Id
7578:
7579: if p_from_fk_id <> p_to_fk_id then
7580: begin
7581: arp_message.set_name('AR','AR_UPDATING_TABLE');
7582: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7583: --
7584: --
7585:

Line 7582: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);

7578:
7579: if p_from_fk_id <> p_to_fk_id then
7580: begin
7581: arp_message.set_name('AR','AR_UPDATING_TABLE');
7582: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7583: --
7584: --
7585:
7586: UPDATE OKL_INS_POLICIES_B IPYB

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

7591: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7592: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7593:
7594: l_count := sql%rowcount;
7595: arp_message.set_name('AR','AR_ROWS_UPDATED');
7596: arp_message.set_token('NUM_ROWS',to_char(l_count));
7597: --
7598: exception
7599: when others then

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

7592: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7593:
7594: l_count := sql%rowcount;
7595: arp_message.set_name('AR','AR_ROWS_UPDATED');
7596: arp_message.set_token('NUM_ROWS',to_char(l_count));
7597: --
7598: exception
7599: when others then
7600: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7596: arp_message.set_token('NUM_ROWS',to_char(l_count));
7597: --
7598: exception
7599: when others then
7600: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7601: --
7602: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7603: 'OKL_INS_POLICIES for = '|| p_from_id));
7604: --