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

Line 114: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

110: NULL;
111:
112: ELSE
113:
114: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
115: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_HEADERS',FALSE);
116: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
117: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
118:

Line 115: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_HEADERS',FALSE);

111:
112: ELSE
113:
114: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
115: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_HEADERS',FALSE);
116: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
117: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
118:
119: open merged_records;

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

203: END IF;
204:
205: END LOOP;
206:
207: arp_message.set_name('AR','AR_ROWS_UPDATED');
208: arp_message.set_token('NUM_ROWS',to_char(l_count));
209:
210: END IF;
211:

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

204:
205: END LOOP;
206:
207: arp_message.set_name('AR','AR_ROWS_UPDATED');
208: arp_message.set_token('NUM_ROWS',to_char(l_count));
209:
210: END IF;
211:
212: ASO_MERGE_PVT.UPDATE_QUOTE_LINES(

Line 229: arp_message.set_line( 'CUSTOMER_MERGE');

225: EXCEPTION
226:
227: WHEN OTHERS THEN
228:
229: arp_message.set_line( 'CUSTOMER_MERGE');
230: RAISE;
231:
232: END CUSTOMER_MERGE;
233:

Line 309: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

305: IF process_mode='LOCK' THEN
306: NULL;
307: ELSE
308:
309: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
310: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_LINES',FALSE);
311: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
312: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
313:

Line 310: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_LINES',FALSE);

306: NULL;
307: ELSE
308:
309: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
310: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_LINES',FALSE);
311: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
312: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
313:
314: open merged_records;

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

393: END IF;
394:
395: END LOOP;
396:
397: arp_message.set_name('AR','AR_ROWS_UPDATED');
398: arp_message.set_token('NUM_ROWS',to_char(l_count));
399:
400: END IF;
401:

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

394:
395: END LOOP;
396:
397: arp_message.set_name('AR','AR_ROWS_UPDATED');
398: arp_message.set_token('NUM_ROWS',to_char(l_count));
399:
400: END IF;
401:
402: EXCEPTION

Line 406: arp_message.set_line( 'UPDATE_QUOTE_LINES');

402: EXCEPTION
403:
404: WHEN OTHERS THEN
405:
406: arp_message.set_line( 'UPDATE_QUOTE_LINES');
407: RAISE;
408:
409: END UPDATE_QUOTE_LINES;
410:

Line 477: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

473:
474: IF process_mode='LOCK' THEN
475: NULL;
476: ELSE
477: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
478: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_SHIPMENTS',FALSE);
479: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
480: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
481:

Line 478: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_SHIPMENTS',FALSE);

474: IF process_mode='LOCK' THEN
475: NULL;
476: ELSE
477: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
478: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_SHIPMENTS',FALSE);
479: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
480: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
481:
482: open merged_records;

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

553: END IF;
554:
555: END LOOP;
556:
557: arp_message.set_name('AR','AR_ROWS_UPDATED');
558: arp_message.set_token('NUM_ROWS',to_char(l_count));
559:
560: END IF;
561:

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

554:
555: END LOOP;
556:
557: arp_message.set_name('AR','AR_ROWS_UPDATED');
558: arp_message.set_token('NUM_ROWS',to_char(l_count));
559:
560: END IF;
561:
562: EXCEPTION

Line 566: arp_message.set_line( 'UPDATE_SHIPMENTS');

562: EXCEPTION
563:
564: WHEN OTHERS THEN
565:
566: arp_message.set_line( 'UPDATE_SHIPMENTS');
567: RAISE;
568:
569: END UPDATE_SHIPMENTS;
570:

Line 616: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()+');

612: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
613:
614: BEGIN
615:
616: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()+');
617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: /* Perform the merge operation */

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

633: if p_from_fk_id <> p_to_fk_id Then
634:
635: IF p_parent_entity_name = 'HZ_PARTIES' Then
636:
637: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
639:
640: UPDATE ASO_QUOTE_HEADERS_ALL SET
641: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),

Line 638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

634:
635: IF p_parent_entity_name = 'HZ_PARTIES' Then
636:
637: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
639:
640: UPDATE ASO_QUOTE_HEADERS_ALL SET
641: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
642: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),

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

657: OR invoice_to_cust_party_id = p_from_fk_id;
658:
659: l_count := sql%rowcount;
660:
661: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
662: arp_message.set_token('NUM_ROWS', to_char(l_count) );
663:
664: return;
665:

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

658:
659: l_count := sql%rowcount;
660:
661: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
662: arp_message.set_token('NUM_ROWS', to_char(l_count) );
663:
664: return;
665:
666: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN

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

664: return;
665:
666: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
667:
668: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
670:
671: UPDATE ASO_QUOTE_HEADERS_ALL SET
672: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),

Line 669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

665:
666: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
667:
668: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
670:
671: UPDATE ASO_QUOTE_HEADERS_ALL SET
672: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
673: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),

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

684: OR sold_to_party_site_id = p_from_fk_id;
685:
686: l_count := sql%rowcount;
687:
688: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
689: arp_message.set_token('NUM_ROWS', to_char(l_count) );
690:
691: return;
692:

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

685:
686: l_count := sql%rowcount;
687:
688: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
689: arp_message.set_token('NUM_ROWS', to_char(l_count) );
690:
691: return;
692:
693: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN

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

691: return;
692:
693: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN
694:
695: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
696: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
697:
698: UPDATE ASO_QUOTE_HEADERS_ALL SET
699: org_contact_id = p_to_fk_id,

Line 696: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

692:
693: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN
694:
695: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
696: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
697:
698: UPDATE ASO_QUOTE_HEADERS_ALL SET
699: org_contact_id = p_to_fk_id,
700: last_update_date = hz_utility_pub.last_update_date,

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

707: Where org_contact_id = p_from_fk_id;
708:
709: l_count := sql%rowcount;
710:
711: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
712: arp_message.set_token('NUM_ROWS', to_char(l_count) );
713:
714: return;
715:

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

708:
709: l_count := sql%rowcount;
710:
711: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
712: arp_message.set_token('NUM_ROWS', to_char(l_count) );
713:
714: return;
715:
716:

Line 721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');

717: END IF;
718:
719: End If;
720:
721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');
722:
723: Exception
724: When RESOURCE_BUSY Then
725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||

Line 725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||

721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');
722:
723: Exception
724: When RESOURCE_BUSY Then
725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||
726: 'on table ASO_QUOTE_HEADERS_ALL');
727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: raise;

Line 731: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);

727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: raise;
730: When Others Then
731: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: raise;
734: END MERGE_QUOTE_HEADERS;
735:

Line 779: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()+');

775: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
776:
777: BEGIN
778:
779: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()+');
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: /* Perform the merge operation */

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

796: if p_from_fk_id <> p_to_fk_id Then
797:
798: If p_parent_entity_name = 'HZ_PARTIES' Then
799:
800: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
802:
803: UPDATE ASO_QUOTE_LINES_ALL SET
804: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),

Line 801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);

797:
798: If p_parent_entity_name = 'HZ_PARTIES' Then
799:
800: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
802:
803: UPDATE ASO_QUOTE_LINES_ALL SET
804: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
805: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),

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

817: OR End_Customer_cust_party_id = p_from_fk_id;
818:
819: l_count := sql%rowcount;
820:
821: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
822: arp_message.set_token('NUM_ROWS', to_char(l_count) );
823:
824: return;
825:

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

818:
819: l_count := sql%rowcount;
820:
821: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
822: arp_message.set_token('NUM_ROWS', to_char(l_count) );
823:
824: return;
825:
826: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then

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

824: return;
825:
826: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
827:
828: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
830:
831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,

Line 829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);

825:
826: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
827:
828: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
830:
831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,

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

842: OR End_Customer_party_site_id = p_from_fk_id;
843:
844: l_count := sql%rowcount;
845:
846: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
847: arp_message.set_token('NUM_ROWS', to_char(l_count) );
848:
849: return;
850:

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

843:
844: l_count := sql%rowcount;
845:
846: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
847: arp_message.set_token('NUM_ROWS', to_char(l_count) );
848:
849: return;
850:
851: End If;

Line 855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');

851: End If;
852:
853: End If;
854:
855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');
856:
857: Exception
858: When RESOURCE_BUSY Then
859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||

Line 859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||

855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');
856:
857: Exception
858: When RESOURCE_BUSY Then
859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||
860: 'on table ASO_QUOTE_LINES_ALL');
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;

Line 865: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);

861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;
864: When Others Then
865: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: raise;
868:
869: END MERGE_QUOTE_LINES;

Line 914: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()+');

910: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
911:
912: BEGIN
913:
914: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()+');
915:
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:
918: /* Perform the merge operation */

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

931: if p_from_fk_id <> p_to_fk_id Then
932:
933: If p_parent_entity_name = 'HZ_PARTIES' Then
934:
935: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
936: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
937:
938: UPDATE ASO_SHIPMENTS SET
939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),

Line 936: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);

932:
933: If p_parent_entity_name = 'HZ_PARTIES' Then
934:
935: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
936: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
937:
938: UPDATE ASO_SHIPMENTS SET
939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
940: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),

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

949: OR ship_to_cust_party_id = p_from_fk_id;
950:
951: l_count := sql%rowcount;
952:
953: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
954: arp_message.set_token('NUM_ROWS', to_char(l_count) );
955:
956: return;
957:

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

950:
951: l_count := sql%rowcount;
952:
953: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
954: arp_message.set_token('NUM_ROWS', to_char(l_count) );
955:
956: return;
957:
958: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then

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

956: return;
957:
958: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
959:
960: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
961: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
962:
963: UPDATE ASO_SHIPMENTS SET
964: ship_to_party_site_id = p_to_fk_id,

Line 961: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);

957:
958: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
959:
960: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
961: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
962:
963: UPDATE ASO_SHIPMENTS SET
964: ship_to_party_site_id = p_to_fk_id,
965: last_update_date = hz_utility_pub.last_update_date,

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

972: Where ship_to_party_site_id = p_from_fk_id;
973:
974: l_count := sql%rowcount;
975:
976: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
977: arp_message.set_token('NUM_ROWS', to_char(l_count) );
978:
979: return;
980:

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

973:
974: l_count := sql%rowcount;
975:
976: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
977: arp_message.set_token('NUM_ROWS', to_char(l_count) );
978:
979: return;
980:
981: End If;

Line 985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');

981: End If;
982:
983: End If;
984:
985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');
986:
987: Exception
988: When RESOURCE_BUSY Then
989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||

Line 989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||

985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');
986:
987: Exception
988: When RESOURCE_BUSY Then
989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||
990: 'on table ASO_SHIPMENTS');
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;

Line 995: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);

991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;
994: When Others Then
995: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: raise;
998:
999: END MERGE_SHIPMENTS;