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 7281: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');

7277: BEGIN
7278: --
7279: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE');
7280: --
7281: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');
7282:
7283: x_return_status := FND_API.G_RET_STS_SUCCESS;
7284:
7285:

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

7312: -- not transfer and return the id of the duplicate record as the Merged To Id
7313:
7314: if p_from_fk_id <> p_to_fk_id then
7315: begin
7316: arp_message.set_name('AR','AR_UPDATING_TABLE');
7317: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7318: --
7319: --
7320:

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

7313:
7314: if p_from_fk_id <> p_to_fk_id then
7315: begin
7316: arp_message.set_name('AR','AR_UPDATING_TABLE');
7317: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7318: --
7319: --
7320:
7321: UPDATE OKL_INS_POLICIES_B IPYB

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

7326: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7327: WHERE IPYB.ISU_ID = p_from_fk_id ;
7328: x_to_id := p_from_id;
7329: l_count := sql%rowcount;
7330: arp_message.set_name('AR','AR_ROWS_UPDATED');
7331: arp_message.set_token('NUM_ROWS',to_char(l_count));
7332: --
7333: exception
7334: when others then

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

7327: WHERE IPYB.ISU_ID = p_from_fk_id ;
7328: x_to_id := p_from_id;
7329: l_count := sql%rowcount;
7330: arp_message.set_name('AR','AR_ROWS_UPDATED');
7331: arp_message.set_token('NUM_ROWS',to_char(l_count));
7332: --
7333: exception
7334: when others then
7335: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7331: arp_message.set_token('NUM_ROWS',to_char(l_count));
7332: --
7333: exception
7334: when others then
7335: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7336: --
7337: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7338: 'OKL_INS_POLICIES for = '|| p_from_id));
7339: --

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

7364: BEGIN
7365: --
7366: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE');
7367: --
7368: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE()+');
7369:
7370: x_return_status := FND_API.G_RET_STS_SUCCESS;
7371:
7372:

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

7399: -- not transfer and return the id of the duplicate record as the Merged To Id
7400:
7401: if p_from_fk_id <> p_to_fk_id then
7402: begin
7403: arp_message.set_name('AR','AR_UPDATING_TABLE');
7404: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7405: --
7406: --
7407:

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

7400:
7401: if p_from_fk_id <> p_to_fk_id then
7402: begin
7403: arp_message.set_name('AR','AR_UPDATING_TABLE');
7404: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7405: --
7406: --
7407:
7408: UPDATE OKL_INS_POLICIES_B IPYB

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

7413: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7414: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7415:
7416: l_count := sql%rowcount;
7417: arp_message.set_name('AR','AR_ROWS_UPDATED');
7418: arp_message.set_token('NUM_ROWS',to_char(l_count));
7419: --
7420: exception
7421: when others then

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

7414: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7415:
7416: l_count := sql%rowcount;
7417: arp_message.set_name('AR','AR_ROWS_UPDATED');
7418: arp_message.set_token('NUM_ROWS',to_char(l_count));
7419: --
7420: exception
7421: when others then
7422: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7418: arp_message.set_token('NUM_ROWS',to_char(l_count));
7419: --
7420: exception
7421: when others then
7422: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7423: --
7424: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7425: 'OKL_INS_POLICIES for = '|| p_from_id));
7426: --

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

7450: BEGIN
7451: --
7452: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE');
7453: --
7454: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE()+');
7455:
7456: x_return_status := FND_API.G_RET_STS_SUCCESS;
7457:
7458:

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

7485: -- not transfer and return the id of the duplicate record as the Merged To Id
7486:
7487: if p_from_fk_id <> p_to_fk_id then
7488: begin
7489: arp_message.set_name('AR','AR_UPDATING_TABLE');
7490: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7491: --
7492: --
7493:

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

7486:
7487: if p_from_fk_id <> p_to_fk_id then
7488: begin
7489: arp_message.set_name('AR','AR_UPDATING_TABLE');
7490: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7491: --
7492: --
7493:
7494: UPDATE OKL_INS_POLICIES_B IPYB

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

7499: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7500: WHERE IPYB.INT_ID = p_from_fk_id ;
7501:
7502: l_count := sql%rowcount;
7503: arp_message.set_name('AR','AR_ROWS_UPDATED');
7504: arp_message.set_token('NUM_ROWS',to_char(l_count));
7505: --
7506: exception
7507: when others then

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

7500: WHERE IPYB.INT_ID = p_from_fk_id ;
7501:
7502: l_count := sql%rowcount;
7503: arp_message.set_name('AR','AR_ROWS_UPDATED');
7504: arp_message.set_token('NUM_ROWS',to_char(l_count));
7505: --
7506: exception
7507: when others then
7508: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7504: arp_message.set_token('NUM_ROWS',to_char(l_count));
7505: --
7506: exception
7507: when others then
7508: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7509: --
7510: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7511: 'OKL_INS_POLICIES for = '|| p_from_id));
7512: --

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

7535: BEGIN
7536: --
7537: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE');
7538: --
7539: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE()+');
7540:
7541: x_return_status := FND_API.G_RET_STS_SUCCESS;
7542:
7543:

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

7570: -- not transfer and return the id of the duplicate record as the Merged To Id
7571:
7572: if p_from_fk_id <> p_to_fk_id then
7573: begin
7574: arp_message.set_name('AR','AR_UPDATING_TABLE');
7575: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7576: --
7577: --
7578:

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

7571:
7572: if p_from_fk_id <> p_to_fk_id then
7573: begin
7574: arp_message.set_name('AR','AR_UPDATING_TABLE');
7575: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7576: --
7577: --
7578:
7579: UPDATE OKL_INS_POLICIES_B IPYB

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

7584: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7585: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7586:
7587: l_count := sql%rowcount;
7588: arp_message.set_name('AR','AR_ROWS_UPDATED');
7589: arp_message.set_token('NUM_ROWS',to_char(l_count));
7590: --
7591: exception
7592: when others then

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

7585: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7586:
7587: l_count := sql%rowcount;
7588: arp_message.set_name('AR','AR_ROWS_UPDATED');
7589: arp_message.set_token('NUM_ROWS',to_char(l_count));
7590: --
7591: exception
7592: when others then
7593: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);

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

7589: arp_message.set_token('NUM_ROWS',to_char(l_count));
7590: --
7591: exception
7592: when others then
7593: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
7594: --
7595: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7596: 'OKL_INS_POLICIES for = '|| p_from_id));
7597: --