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.OKS_PARTY_MERGE_PKG dependencies on ARP_MESSAGE

Line 25: arp_message.set_line(g_api_name||'.'||l_proc_name);

21: l_proc_name varchar2(30) := 'OKS_BILLING_PROFILES';
22: l_count number(10) := 0;
23:
24: BEGIN
25: arp_message.set_line(g_api_name||'.'||l_proc_name);
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: --If it is a Site Merge, nothing to be done. Return the x_to_id.

Line 42: arp_message.set_line('Updating OKS_BILLING_PROFILES_B...');

38:
39: if p_from_fk_id <> p_to_fk_id then
40: BEGIN
41:
42: arp_message.set_line('Updating OKS_BILLING_PROFILES_B...');
43:
44: update oks_billing_profiles_b
45: set owned_party_id1 = p_to_fk_id,
46: last_update_date = sysdate,

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

49: object_version_number = object_version_number+1
50: where owned_party_id1 = p_from_fk_id;
51:
52: l_count := sql%rowcount;
53: arp_message.set_name('AR','AR_ROWS_UPDATED');
54: arp_message.set_token('NUM_ROWS',to_char(l_count));
55:
56: EXCEPTION
57: when OTHERS then

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

50: where owned_party_id1 = p_from_fk_id;
51:
52: l_count := sql%rowcount;
53: arp_message.set_name('AR','AR_ROWS_UPDATED');
54: arp_message.set_token('NUM_ROWS',to_char(l_count));
55:
56: EXCEPTION
57: when OTHERS then
58: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

Line 58: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

54: arp_message.set_token('NUM_ROWS',to_char(l_count));
55:
56: EXCEPTION
57: when OTHERS then
58: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);
59: x_return_status := FND_API.G_RET_STS_ERROR;
60: raise;
61: END;
62: end if;

Line 100: arp_message.set_line(g_api_name||'.'||l_proc_name);

96: from_rec default_cur%ROWTYPE;
97: to_rec default_cur%ROWTYPE;
98:
99: BEGIN
100: arp_message.set_line(g_api_name||'.'||l_proc_name);
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --If it is a Site Merge, nothing to be done. Return the x_to_id.

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

190: and jtot_object_code = 'OKX_PARTY';
191:
192: END IF;
193: l_count := sql%rowcount;
194: arp_message.set_name('AR','AR_ROWS_UPDATED');
195: arp_message.set_token('NUM_ROWS',to_char(l_count));
196: update oks_k_defaults
197: set segment_id1 = p_to_fk_id,
198: last_update_date = sysdate,

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

191:
192: END IF;
193: l_count := sql%rowcount;
194: arp_message.set_name('AR','AR_ROWS_UPDATED');
195: arp_message.set_token('NUM_ROWS',to_char(l_count));
196: update oks_k_defaults
197: set segment_id1 = p_to_fk_id,
198: last_update_date = sysdate,
199: last_updated_by = g_user_id,

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

202: object_version_number = object_version_number+1
203: where segment_id1 = p_from_fk_id
204: and jtot_object_code = 'OKX_PARTY';
205: l_count := sql%rowcount;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: arp_message.set_line('Updating OKS_K_DEFAULTS...');
209:
210: END IF;

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

203: where segment_id1 = p_from_fk_id
204: and jtot_object_code = 'OKX_PARTY';
205: l_count := sql%rowcount;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: arp_message.set_line('Updating OKS_K_DEFAULTS...');
209:
210: END IF;
211:

Line 208: arp_message.set_line('Updating OKS_K_DEFAULTS...');

204: and jtot_object_code = 'OKX_PARTY';
205: l_count := sql%rowcount;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: arp_message.set_line('Updating OKS_K_DEFAULTS...');
209:
210: END IF;
211:
212: EXCEPTION

Line 214: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

210: END IF;
211:
212: EXCEPTION
213: when OTHERS then
214: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: raise;
217: END;
218: end if;

Line 238: arp_message.set_line(g_api_name||'.'||l_proc_name);

234: l_proc_name varchar2(30) := 'OKS_SERVICE_EXCEPTS';
235: l_count number(10) := 0;
236:
237: BEGIN
238: arp_message.set_line(g_api_name||'.'||l_proc_name);
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: --If it is a Site Merge, nothing to be done. Return the x_to_id.

Line 255: /* original code arp_message.set_line('Updating OKS_SERV_AVAIL_EXCEPTS...');

251:
252: if p_from_fk_id <> p_to_fk_id then
253: BEGIN
254:
255: /* original code arp_message.set_line('Updating OKS_SERV_AVAIL_EXCEPTS...');
256:
257: update oks_serv_avail_excepts
258: set object1_id1 = p_to_fk_id,
259: last_update_date = sysdate,

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

263: where object1_id1 = p_from_fk_id
264: and jtot_object1_code = 'OKX_PARTY';
265:
266: l_count := sql%rowcount;
267: arp_message.set_name('AR','AR_ROWS_UPDATED');
268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/
269:
270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');
271:

Line 268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/

264: and jtot_object1_code = 'OKX_PARTY';
265:
266: l_count := sql%rowcount;
267: arp_message.set_name('AR','AR_ROWS_UPDATED');
268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/
269:
270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');
271:
272: delete from oks_serv_avail_excepts

Line 270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');

266: l_count := sql%rowcount;
267: arp_message.set_name('AR','AR_ROWS_UPDATED');
268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/
269:
270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');
271:
272: delete from oks_serv_avail_excepts
273: where object1_id1 in (p_from_fk_id,p_to_fk_id)
274: and jtot_object1_code = 'OKX_PARTY';

Line 277: arp_message.set_name('AR','AR_ROWS_DELETED');

273: where object1_id1 in (p_from_fk_id,p_to_fk_id)
274: and jtot_object1_code = 'OKX_PARTY';
275:
276: l_count := sql%rowcount;
277: arp_message.set_name('AR','AR_ROWS_DELETED');
278: arp_message.set_token('NUM_ROWS',to_char(l_count));
279:
280: EXCEPTION
281: when OTHERS then

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

274: and jtot_object1_code = 'OKX_PARTY';
275:
276: l_count := sql%rowcount;
277: arp_message.set_name('AR','AR_ROWS_DELETED');
278: arp_message.set_token('NUM_ROWS',to_char(l_count));
279:
280: EXCEPTION
281: when OTHERS then
282: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

Line 282: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

278: arp_message.set_token('NUM_ROWS',to_char(l_count));
279:
280: EXCEPTION
281: when OTHERS then
282: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: raise;
285: END;
286: end if;

Line 306: arp_message.set_line(g_api_name||'.'||l_proc_name);

302: l_count number(10) := 0;
303: l_return_status VARCHAR2(1);
304:
305: BEGIN
306: arp_message.set_line(g_api_name||'.'||l_proc_name);
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: --If it is a Site Merge, nothing to be done. Return the x_to_id.

Line 323: arp_message.set_line('Updating OKS_QUALIFIERS...');

319:
320: if p_from_fk_id <> p_to_fk_id then
321: BEGIN
322:
323: arp_message.set_line('Updating OKS_QUALIFIERS...');
324:
325: OKS_QP_INT_PVT.QUALIFIER_PARTY_MERGE(
326: p_from_fk_id =>p_from_fk_id,
327: p_to_fk_id =>p_to_fk_id,

Line 336: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);

332: END IF;
333:
334: EXCEPTION
335: when OTHERS then
336: arp_message.set_line(g_api_name||'.'||l_proc_name||': '||sqlerrm);
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: raise;
339: END;
340: end if;