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

Line 65: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SOURCE_PARTY()+');

61: RESOURCE_BUSY EXCEPTION;
62: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
63:
64: BEGIN
65: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SOURCE_PARTY()+');
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: select merge_reason_code

Line 103: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

99:
100: if p_from_fk_id <> p_to_fk_id then
101: begin
102: -- obtain lock on records to be updated.
103: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
104: arp_message.set_token('TABLE_NAME', 'AHL_DOCUMENTS_B', FALSE);
105:
106: open c1;
107: close c1;

Line 104: arp_message.set_token('TABLE_NAME', 'AHL_DOCUMENTS_B', FALSE);

100: if p_from_fk_id <> p_to_fk_id then
101: begin
102: -- obtain lock on records to be updated.
103: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
104: arp_message.set_token('TABLE_NAME', 'AHL_DOCUMENTS_B', FALSE);
105:
106: open c1;
107: close c1;
108:

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

114: where source_party_id = p_from_fk_id;
115:
116: l_count := sql%rowcount;
117:
118: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
119: arp_message.set_token('NUM_ROWS', to_char(l_count) );
120:
121: exception
122: when resource_busy then

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

115:
116: l_count := sql%rowcount;
117:
118: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
119: arp_message.set_token('NUM_ROWS', to_char(l_count) );
120:
121: exception
122: when resource_busy then
123: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 123: arp_message.set_line(g_proc_name || '.' || l_api_name ||

119: arp_message.set_token('NUM_ROWS', to_char(l_count) );
120:
121: exception
122: when resource_busy then
123: arp_message.set_line(g_proc_name || '.' || l_api_name ||
124: '; Could not obtain lock for records in table ' ||
125: 'AHL_DOCUMENTS_B for source_party_id = ' || p_from_fk_id );
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: raise;

Line 130: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

126: x_return_status := FND_API.G_RET_STS_ERROR;
127: raise;
128:
129: when others then
130: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: raise;
133: end;
134: end if;

Line 169: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUPPLIER()+');

165: BEGIN
166: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('I','S') ) then
167: return;
168: end if;
169: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUPPLIER()+');
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: select merge_reason_code

Line 207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

203:
204: if p_from_fk_id <> p_to_fk_id then
205: begin
206: -- obtain lock on records to be updated.
207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
208: arp_message.set_token('TABLE_NAME', 'AHL_SUPPLIER_DOCUMENTS', FALSE);
209:
210: open c1;
211: close c1;

Line 208: arp_message.set_token('TABLE_NAME', 'AHL_SUPPLIER_DOCUMENTS', FALSE);

204: if p_from_fk_id <> p_to_fk_id then
205: begin
206: -- obtain lock on records to be updated.
207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
208: arp_message.set_token('TABLE_NAME', 'AHL_SUPPLIER_DOCUMENTS', FALSE);
209:
210: open c1;
211: close c1;
212:

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

218: where supplier_id = p_from_fk_id;
219:
220: l_count := sql%rowcount;
221:
222: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
223: arp_message.set_token('NUM_ROWS', to_char(l_count) );
224:
225: exception
226: when resource_busy then

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

219:
220: l_count := sql%rowcount;
221:
222: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
223: arp_message.set_token('NUM_ROWS', to_char(l_count) );
224:
225: exception
226: when resource_busy then
227: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 227: arp_message.set_line(g_proc_name || '.' || l_api_name ||

223: arp_message.set_token('NUM_ROWS', to_char(l_count) );
224:
225: exception
226: when resource_busy then
227: arp_message.set_line(g_proc_name || '.' || l_api_name ||
228: '; Could not obtain lock for records in table ' ||
229: 'AHL_SUPPLIER_DOCUMENTS for supplier_id = ' || p_from_fk_id );
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: raise;

Line 234: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

230: x_return_status := FND_API.G_RET_STS_ERROR;
231: raise;
232:
233: when others then
234: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: raise;
237: end;
238: end if;

Line 269: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECIPIENT_PARTY()+');

265: RESOURCE_BUSY EXCEPTION;
266: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
267:
268: BEGIN
269: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECIPIENT_PARTY()+');
270:
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: select merge_reason_code

Line 307: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

303:
304: if p_from_fk_id <> p_to_fk_id then
305: begin
306: -- obtain lock on records to be updated.
307: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
308: arp_message.set_token('TABLE_NAME', 'AHL_RECIPIENT_DOCUMENTS', FALSE);
309:
310: open c1;
311: close c1;

Line 308: arp_message.set_token('TABLE_NAME', 'AHL_RECIPIENT_DOCUMENTS', FALSE);

304: if p_from_fk_id <> p_to_fk_id then
305: begin
306: -- obtain lock on records to be updated.
307: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
308: arp_message.set_token('TABLE_NAME', 'AHL_RECIPIENT_DOCUMENTS', FALSE);
309:
310: open c1;
311: close c1;
312:

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

318: where recipient_party_id = p_from_fk_id;
319:
320: l_count := sql%rowcount;
321:
322: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
323: arp_message.set_token('NUM_ROWS', to_char(l_count) );
324:
325: exception
326: when resource_busy then

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

319:
320: l_count := sql%rowcount;
321:
322: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
323: arp_message.set_token('NUM_ROWS', to_char(l_count) );
324:
325: exception
326: when resource_busy then
327: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 327: arp_message.set_line(g_proc_name || '.' || l_api_name ||

323: arp_message.set_token('NUM_ROWS', to_char(l_count) );
324:
325: exception
326: when resource_busy then
327: arp_message.set_line(g_proc_name || '.' || l_api_name ||
328: '; Could not obtain lock for records in table ' ||
329: 'AHL_RECIPIENT_DOCUMENTS for recipient_party_id = ' || p_from_fk_id );
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: raise;

Line 334: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

330: x_return_status := FND_API.G_RET_STS_ERROR;
331: raise;
332:
333: when others then
334: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: raise;
337: end;
338: end if;

Line 372: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_REQUESTED_BY_PARTY ()+');

368: BEGIN
369: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S') ) then
370: return;
371: end if;
372: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_REQUESTED_BY_PARTY ()+');
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: select merge_reason_code

Line 410: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

406:
407: if p_from_fk_id <> p_to_fk_id then
408: begin
409: -- obtain lock on records to be updated.
410: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
411: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);
412:
413: open c1;
414: close c1;

Line 411: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);

407: if p_from_fk_id <> p_to_fk_id then
408: begin
409: -- obtain lock on records to be updated.
410: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
411: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);
412:
413: open c1;
414: close c1;
415:

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

421: where requested_by_party_id = p_from_fk_id;
422:
423: l_count := sql%rowcount;
424:
425: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
426: arp_message.set_token('NUM_ROWS', to_char(l_count) );
427:
428: exception
429: when resource_busy then

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

422:
423: l_count := sql%rowcount;
424:
425: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
426: arp_message.set_token('NUM_ROWS', to_char(l_count) );
427:
428: exception
429: when resource_busy then
430: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 430: arp_message.set_line(g_proc_name || '.' || l_api_name ||

426: arp_message.set_token('NUM_ROWS', to_char(l_count) );
427:
428: exception
429: when resource_busy then
430: arp_message.set_line(g_proc_name || '.' || l_api_name ||
431: '; Could not obtain lock for records in table ' ||
432: 'AHL_SUBSCRIPTIONS_B for requested_by_party_id = ' || p_from_fk_id );
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: raise;

Line 437: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

433: x_return_status := FND_API.G_RET_STS_ERROR;
434: raise;
435:
436: when others then
437: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: raise;
440: end;
441: end if;

Line 475: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUBSCRIBED_FRM_PARTY()+');

471: BEGIN
472: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('I','S') ) then
473: return;
474: end if;
475: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUBSCRIBED_FRM_PARTY()+');
476:
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: select merge_reason_code

Line 513: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

509:
510: if p_from_fk_id <> p_to_fk_id then
511: begin
512: -- obtain lock on records to be updated.
513: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
514: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);
515:
516: open c1;
517: close c1;

Line 514: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);

510: if p_from_fk_id <> p_to_fk_id then
511: begin
512: -- obtain lock on records to be updated.
513: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
514: arp_message.set_token('TABLE_NAME', 'AHL_SUBSCRIPTIONS_B', FALSE);
515:
516: open c1;
517: close c1;
518:

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

524: where SUBSCRIBED_FRM_PARTY_ID = p_from_fk_id;
525:
526: l_count := sql%rowcount;
527:
528: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
529: arp_message.set_token('NUM_ROWS', to_char(l_count) );
530:
531: exception
532: when resource_busy then

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

525:
526: l_count := sql%rowcount;
527:
528: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
529: arp_message.set_token('NUM_ROWS', to_char(l_count) );
530:
531: exception
532: when resource_busy then
533: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 533: arp_message.set_line(g_proc_name || '.' || l_api_name ||

529: arp_message.set_token('NUM_ROWS', to_char(l_count) );
530:
531: exception
532: when resource_busy then
533: arp_message.set_line(g_proc_name || '.' || l_api_name ||
534: '; Could not obtain lock for records in table ' ||
535: 'AHL_SUBSCRIPTIONS_B for requested_by_party_id = ' || p_from_fk_id );
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: raise;

Line 540: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

536: x_return_status := FND_API.G_RET_STS_ERROR;
537: raise;
538:
539: when others then
540: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: raise;
543: end;
544: end if;

Line 579: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_APPROVED_BY_PARTY ()+');

575: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S') ) then
576: return;
577: end if;
578:
579: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_APPROVED_BY_PARTY ()+');
580:
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: select merge_reason_code

Line 617: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

613:
614: if p_from_fk_id <> p_to_fk_id then
615: begin
616: -- obtain lock on records to be updated.
617: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
618: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISIONS_B', FALSE);
619:
620: open c1;
621: close c1;

Line 618: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISIONS_B', FALSE);

614: if p_from_fk_id <> p_to_fk_id then
615: begin
616: -- obtain lock on records to be updated.
617: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
618: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISIONS_B', FALSE);
619:
620: open c1;
621: close c1;
622:

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

628: where approved_by_party_id = p_from_fk_id;
629:
630: l_count := sql%rowcount;
631:
632: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
633: arp_message.set_token('NUM_ROWS', to_char(l_count) );
634:
635: exception
636: when resource_busy then

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

629:
630: l_count := sql%rowcount;
631:
632: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
633: arp_message.set_token('NUM_ROWS', to_char(l_count) );
634:
635: exception
636: when resource_busy then
637: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 637: arp_message.set_line(g_proc_name || '.' || l_api_name ||

633: arp_message.set_token('NUM_ROWS', to_char(l_count) );
634:
635: exception
636: when resource_busy then
637: arp_message.set_line(g_proc_name || '.' || l_api_name ||
638: '; Could not obtain lock for records in table ' ||
639: 'AHL_DOC_REVSIONS_B for approved_by_party_id = ' || p_from_fk_id );
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: raise;

Line 644: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

640: x_return_status := FND_API.G_RET_STS_ERROR;
641: raise;
642:
643: when others then
644: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: raise;
647: end;
648: end if;

Line 679: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECEIVED_BY_PARTY ()+');

675: RESOURCE_BUSY EXCEPTION;
676: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
677:
678: BEGIN
679: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECEIVED_BY_PARTY ()+');
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: select merge_reason_code

Line 717: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

713:
714: if p_from_fk_id <> p_to_fk_id then
715: begin
716: -- obtain lock on records to be updated.
717: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
718: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISION_COPIES', FALSE);
719:
720: open c1;
721: close c1;

Line 718: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISION_COPIES', FALSE);

714: if p_from_fk_id <> p_to_fk_id then
715: begin
716: -- obtain lock on records to be updated.
717: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
718: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISION_COPIES', FALSE);
719:
720: open c1;
721: close c1;
722:

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

728: where received_by_party_id = p_from_fk_id;
729:
730: l_count := sql%rowcount;
731:
732: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
733: arp_message.set_token('NUM_ROWS', to_char(l_count) );
734:
735: exception
736: when resource_busy then

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

729:
730: l_count := sql%rowcount;
731:
732: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
733: arp_message.set_token('NUM_ROWS', to_char(l_count) );
734:
735: exception
736: when resource_busy then
737: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 737: arp_message.set_line(g_proc_name || '.' || l_api_name ||

733: arp_message.set_token('NUM_ROWS', to_char(l_count) );
734:
735: exception
736: when resource_busy then
737: arp_message.set_line(g_proc_name || '.' || l_api_name ||
738: '; Could not obtain lock for records in table ' ||
739: 'AHL_DOC_REVISION_COPIES for received_by_party_id = ' || p_from_fk_id );
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: raise;

Line 744: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

740: x_return_status := FND_API.G_RET_STS_ERROR;
741: raise;
742:
743: when others then
744: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: raise;
747: end;
748: end if;

Line 779: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_OPERATOR_PARTY ()+');

775: RESOURCE_BUSY EXCEPTION;
776: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
777:
778: BEGIN
779: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_OPERATOR_PARTY ()+');
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: select merge_reason_code

Line 814: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

810:
811: if p_from_fk_id <> p_to_fk_id then
812: begin
813: -- obtain lock on records to be updated.
814: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
815: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_B', FALSE);
816:
817: open c1;
818: close c1;

Line 815: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_B', FALSE);

811: if p_from_fk_id <> p_to_fk_id then
812: begin
813: -- obtain lock on records to be updated.
814: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
815: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_B', FALSE);
816:
817: open c1;
818: close c1;
819:

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

825: where operator_party_id = p_from_fk_id;
826:
827: l_count := sql%rowcount;
828:
829: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
830: arp_message.set_token('NUM_ROWS', to_char(l_count) );
831:
832: exception
833: when resource_busy then

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

826:
827: l_count := sql%rowcount;
828:
829: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
830: arp_message.set_token('NUM_ROWS', to_char(l_count) );
831:
832: exception
833: when resource_busy then
834: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 834: arp_message.set_line(g_proc_name || '.' || l_api_name ||

830: arp_message.set_token('NUM_ROWS', to_char(l_count) );
831:
832: exception
833: when resource_busy then
834: arp_message.set_line(g_proc_name || '.' || l_api_name ||
835: '; Could not obtain lock for records in table ' ||
836: 'AHL_OPERATIONS_B for operator_party_id = ' || p_from_fk_id );
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: raise;

Line 841: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

837: x_return_status := FND_API.G_RET_STS_ERROR;
838: raise;
839:
840: when others then
841: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: raise;
844: end;
845: end if;

Line 876: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_H_OPERATOR_PARTY ()+');

872: RESOURCE_BUSY EXCEPTION;
873: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
874:
875: BEGIN
876: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_H_OPERATOR_PARTY ()+');
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: select merge_reason_code

Line 911: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

907:
908: if p_from_fk_id <> p_to_fk_id then
909: begin
910: -- obtain lock on records to be updated.
911: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
912: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_H_B', FALSE);
913:
914: open c1;
915: close c1;

Line 912: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_H_B', FALSE);

908: if p_from_fk_id <> p_to_fk_id then
909: begin
910: -- obtain lock on records to be updated.
911: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
912: arp_message.set_token('TABLE_NAME', 'AHL_OPERATIONS_H_B', FALSE);
913:
914: open c1;
915: close c1;
916:

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

922: where operator_party_id = p_from_fk_id;
923:
924: l_count := sql%rowcount;
925:
926: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
927: arp_message.set_token('NUM_ROWS', to_char(l_count) );
928:
929: exception
930: when resource_busy then

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

923:
924: l_count := sql%rowcount;
925:
926: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
927: arp_message.set_token('NUM_ROWS', to_char(l_count) );
928:
929: exception
930: when resource_busy then
931: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 931: arp_message.set_line(g_proc_name || '.' || l_api_name ||

927: arp_message.set_token('NUM_ROWS', to_char(l_count) );
928:
929: exception
930: when resource_busy then
931: arp_message.set_line(g_proc_name || '.' || l_api_name ||
932: '; Could not obtain lock for records in table ' ||
933: 'AHL_OPERATIONS_H_B for operator_party_id = ' || p_from_fk_id );
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: raise;

Line 938: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

934: x_return_status := FND_API.G_RET_STS_ERROR;
935: raise;
936:
937: when others then
938: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: raise;
941: end;
942: end if;

Line 973: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_OPERATOR_PARTY ()+');

969: RESOURCE_BUSY EXCEPTION;
970: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
971:
972: BEGIN
973: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_OPERATOR_PARTY ()+');
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: select merge_reason_code

Line 1008: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1004:
1005: if p_from_fk_id <> p_to_fk_id then
1006: begin
1007: -- obtain lock on records to be updated.
1008: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1009: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_B', FALSE);
1010:
1011: open c1;
1012: close c1;

Line 1009: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_B', FALSE);

1005: if p_from_fk_id <> p_to_fk_id then
1006: begin
1007: -- obtain lock on records to be updated.
1008: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1009: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_B', FALSE);
1010:
1011: open c1;
1012: close c1;
1013:

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

1019: where operator_party_id = p_from_fk_id;
1020:
1021: l_count := sql%rowcount;
1022:
1023: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1024: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1025:
1026: exception
1027: when resource_busy then

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

1020:
1021: l_count := sql%rowcount;
1022:
1023: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1024: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1025:
1026: exception
1027: when resource_busy then
1028: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 1028: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1024: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1025:
1026: exception
1027: when resource_busy then
1028: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1029: '; Could not obtain lock for records in table ' ||
1030: 'AHL_ROUTES_B for operator_party_id = ' || p_from_fk_id );
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: raise;

Line 1035: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: raise;
1033:
1034: when others then
1035: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: raise;
1038: end;
1039: end if;

Line 1070: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_H_OPERATOR_PARTY ()+');

1066: RESOURCE_BUSY EXCEPTION;
1067: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1068:
1069: BEGIN
1070: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_H_OPERATOR_PARTY ()+');
1071:
1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: select merge_reason_code

Line 1105: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1101:
1102: if p_from_fk_id <> p_to_fk_id then
1103: begin
1104: -- obtain lock on records to be updated.
1105: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1106: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_H_B', FALSE);
1107:
1108: open c1;
1109: close c1;

Line 1106: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_H_B', FALSE);

1102: if p_from_fk_id <> p_to_fk_id then
1103: begin
1104: -- obtain lock on records to be updated.
1105: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1106: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_H_B', FALSE);
1107:
1108: open c1;
1109: close c1;
1110:

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

1116: where operator_party_id = p_from_fk_id;
1117:
1118: l_count := sql%rowcount;
1119:
1120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1121: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1122:
1123: exception
1124: when resource_busy then

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

1117:
1118: l_count := sql%rowcount;
1119:
1120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1121: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1122:
1123: exception
1124: when resource_busy then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 1125: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1121: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1122:
1123: exception
1124: when resource_busy then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1126: '; Could not obtain lock for records in table ' ||
1127: 'AHL_ROUTES_H_B for operator_party_id = ' || p_from_fk_id );
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: raise;

Line 1132: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: raise;
1130:
1131: when others then
1132: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: raise;
1135: end;
1136: end if;

Line 1168: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_OSP_CUSTOMER()+');

1164: RESOURCE_BUSY EXCEPTION;
1165: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1166:
1167: BEGIN
1168: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_OSP_CUSTOMER()+');
1169:
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171:
1172: select merge_reason_code

Line 1206: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1202:
1203: if p_from_fk_id <> p_to_fk_id then
1204: begin
1205: -- obtain lock on records to be updated.
1206: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1207: arp_message.set_token('TABLE_NAME', 'AHL_OSP_ORDERS_B', FALSE);
1208:
1209: open c1;
1210: close c1;

Line 1207: arp_message.set_token('TABLE_NAME', 'AHL_OSP_ORDERS_B', FALSE);

1203: if p_from_fk_id <> p_to_fk_id then
1204: begin
1205: -- obtain lock on records to be updated.
1206: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1207: arp_message.set_token('TABLE_NAME', 'AHL_OSP_ORDERS_B', FALSE);
1208:
1209: open c1;
1210: close c1;
1211:

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

1217: where customer_id = p_from_fk_id;
1218:
1219: l_count := sql%rowcount;
1220:
1221: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1222: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1223:
1224: exception
1225: when resource_busy then

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

1218:
1219: l_count := sql%rowcount;
1220:
1221: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1222: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1223:
1224: exception
1225: when resource_busy then
1226: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 1226: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1222: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1223:
1224: exception
1225: when resource_busy then
1226: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1227: '; Could not obtain lock for records in table ' ||
1228: 'AHL_OSP_ORDERS_B for customer_id = ' || p_from_fk_id );
1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: raise;

Line 1233: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: raise;
1231:
1232: when others then
1233: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: raise;
1236: end;
1237: end if;