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

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

136: BEGIN
137: IF process_mode='LOCK' THEN
138: NULL;
139: ELSE
140: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
141: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
142: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
143: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
144: --cursor to get party and account ID

Line 141: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);

137: IF process_mode='LOCK' THEN
138: NULL;
139: ELSE
140: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
141: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
142: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
143: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
144: --cursor to get party and account ID
145: open merged_records;

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

187: EXIT;
188: END IF;
189: END LOOP;
190: close merged_records;
191: arp_message.set_name('AR','AR_ROWS_UPDATED');
192: arp_message.set_token('NUM_ROWS',to_char(l_count));
193: END IF;
194: EXCEPTION
195: WHEN OTHERS THEN

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

188: END IF;
189: END LOOP;
190: close merged_records;
191: arp_message.set_name('AR','AR_ROWS_UPDATED');
192: arp_message.set_token('NUM_ROWS',to_char(l_count));
193: END IF;
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_message.set_line( 'acc_merge_oneclick');

Line 196: arp_message.set_line( 'acc_merge_oneclick');

192: arp_message.set_token('NUM_ROWS',to_char(l_count));
193: END IF;
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_message.set_line( 'acc_merge_oneclick');
197: IBE_UTIL.debug('IBE_MERGE_PVT.acc_merge_oneclick errored :' ||sqlerrm);
198: RAISE;
199: END acc_merge_oneclick;
200:

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

257: BEGIN
258: IF process_mode='LOCK' THEN
259: NULL;
260: ELSE
261: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
262: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
263: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
264: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
265: --cursor to get party and account ID

Line 262: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);

258: IF process_mode='LOCK' THEN
259: NULL;
260: ELSE
261: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
262: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
263: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
264: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
265: --cursor to get party and account ID
266: open merged_records;

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

343: EXIT;
344: END IF;
345: END LOOP;
346: close merged_records;
347: arp_message.set_name('AR','AR_ROWS_UPDATED');
348: arp_message.set_token('NUM_ROWS',to_char(l_count));
349: END IF;
350: EXCEPTION
351: WHEN OTHERS THEN

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

344: END IF;
345: END LOOP;
346: close merged_records;
347: arp_message.set_name('AR','AR_ROWS_UPDATED');
348: arp_message.set_token('NUM_ROWS',to_char(l_count));
349: END IF;
350: EXCEPTION
351: WHEN OTHERS THEN
352: arp_message.set_line( 'acc_merge_shp_lists');

Line 352: arp_message.set_line( 'acc_merge_shp_lists');

348: arp_message.set_token('NUM_ROWS',to_char(l_count));
349: END IF;
350: EXCEPTION
351: WHEN OTHERS THEN
352: arp_message.set_line( 'acc_merge_shp_lists');
353: IBE_UTIL.debug('IBE_MERGE_PVT.acc_merge_shp_lists errored :' ||sqlerrm);
354: RAISE;
355: END acc_merge_shp_lists;
356:

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

418: BEGIN
419: IF process_mode='LOCK' THEN
420: NULL;
421: ELSE
422: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
423: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
424: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
425: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
426:

Line 423: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);

419: IF process_mode='LOCK' THEN
420: NULL;
421: ELSE
422: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
423: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
424: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
425: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
426:
427: open C_ACTIVE_QUOTE_FROM;

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

475: End;
476:
477: END LOOP;
478: close C_ACTIVE_QUOTE_FROM;
479: arp_message.set_name('AR','AR_ROWS_UPDATED');
480: arp_message.set_token('NUM_ROWS',to_char(l_count));
481: END IF;
482: EXCEPTION
483: WHEN OTHERS THEN

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

476:
477: END LOOP;
478: close C_ACTIVE_QUOTE_FROM;
479: arp_message.set_name('AR','AR_ROWS_UPDATED');
480: arp_message.set_token('NUM_ROWS',to_char(l_count));
481: END IF;
482: EXCEPTION
483: WHEN OTHERS THEN
484: arp_message.set_line( 'acc_merge_active_quotes');

Line 484: arp_message.set_line( 'acc_merge_active_quotes');

480: arp_message.set_token('NUM_ROWS',to_char(l_count));
481: END IF;
482: EXCEPTION
483: WHEN OTHERS THEN
484: arp_message.set_line( 'acc_merge_active_quotes');
485: IBE_UTIL.debug('IBE_MERGE_PVT.acc_merge_active_quotes errored :' ||sqlerrm);
486: RAISE;
487: END acc_merge_active_quotes;
488:

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

570: BEGIN
571: IF process_mode='LOCK' THEN
572: NULL;
573: ELSE
574: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
575: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
576: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
577: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
578:

Line 575: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);

571: IF process_mode='LOCK' THEN
572: NULL;
573: ELSE
574: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
575: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
576: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
577: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
578:
579: --retrieve shared carts

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

636: hz_utility_pub.LAST_UPDATED_BY );
637: end if;
638: else
639: --if shared cart not a duplicate of , update party/account ID to merge to
640: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
641: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
642: --fix for 2940366
643: if customer_type = 'CUSTOMER_ORG' then
644: --B2B, partyID stays the same

Line 641: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

637: end if;
638: else
639: --if shared cart not a duplicate of , update party/account ID to merge to
640: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
641: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
642: --fix for 2940366
643: if customer_type = 'CUSTOMER_ORG' then
644: --B2B, partyID stays the same
645: l_to_party_id := l_from_party_id;

Line 760: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()+');

756:
757: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE() entered with Request_id: '||Request_id||' Set Number: '||Set_Number
758: ||' and process_mode: '||Process_MODE);
759:
760: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()+');
761:
762: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE()+');
763:
764: p_request_id := request_id;

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

782:
783: End Loop;
784: Close C_CUST;
785:
786: arp_message.set_name('AR','AR_UPDATING_TABLE');
787: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
788:
789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');
790: --2940366

Line 787: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);

783: End Loop;
784: Close C_CUST;
785:
786: arp_message.set_name('AR','AR_UPDATING_TABLE');
787: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
788:
789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');
790: --2940366
791: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);

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

789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');
790: --2940366
791: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
792: g_count := sql%rowcount;
793: arp_message.set_name('AR','AR_ROWS_UPDATED');
794: arp_message.set_token('NUM_ROWS',to_char(g_count));
795:
796: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_ORD_ONECLICK_ALL table');
797: /* 4/8/02

Line 794: arp_message.set_token('NUM_ROWS',to_char(g_count));

790: --2940366
791: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
792: g_count := sql%rowcount;
793: arp_message.set_name('AR','AR_ROWS_UPDATED');
794: arp_message.set_token('NUM_ROWS',to_char(g_count));
795:
796: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_ORD_ONECLICK_ALL table');
797: /* 4/8/02
798: If oneclick table already has entry for the merge to account, ignore and do nothing

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

797: /* 4/8/02
798: If oneclick table already has entry for the merge to account, ignore and do nothing
799: */
800: acc_merge_oneclick(request_id,set_number,process_mode);
801: arp_message.set_name('AR','AR_UPDATING_TABLE');
802: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
803: g_count := sql%rowcount;
804:
805:

Line 802: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);

798: If oneclick table already has entry for the merge to account, ignore and do nothing
799: */
800: acc_merge_oneclick(request_id,set_number,process_mode);
801: arp_message.set_name('AR','AR_UPDATING_TABLE');
802: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
803: g_count := sql%rowcount;
804:
805:
806: /* account merge for shared quote

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

808: */
809: --2940366
810: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating shared quote table');
811: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
812: arp_message.set_name('AR','AR_UPDATING_TABLE');
813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
814: arp_message.set_name('AR','AR_ROWS_UPDATED');
815: arp_message.set_token('NUM_ROWS',to_char(g_count));
816:

Line 813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);

809: --2940366
810: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating shared quote table');
811: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
812: arp_message.set_name('AR','AR_UPDATING_TABLE');
813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
814: arp_message.set_name('AR','AR_ROWS_UPDATED');
815: arp_message.set_token('NUM_ROWS',to_char(g_count));
816:
817:

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

810: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating shared quote table');
811: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
812: arp_message.set_name('AR','AR_UPDATING_TABLE');
813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
814: arp_message.set_name('AR','AR_ROWS_UPDATED');
815: arp_message.set_token('NUM_ROWS',to_char(g_count));
816:
817:
818: /*merge active cart

Line 815: arp_message.set_token('NUM_ROWS',to_char(g_count));

811: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
812: arp_message.set_name('AR','AR_UPDATING_TABLE');
813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
814: arp_message.set_name('AR','AR_ROWS_UPDATED');
815: arp_message.set_token('NUM_ROWS',to_char(g_count));
816:
817:
818: /*merge active cart
819: 12/18/02

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

819: 12/18/02
820: */
821: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating active cart table');
822: acc_merge_active_quotes(request_id,set_number,process_mode);
823: arp_message.set_name('AR','AR_UPDATING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:

Line 824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);

820: */
821: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating active cart table');
822: acc_merge_active_quotes(request_id,set_number,process_mode);
823: arp_message.set_name('AR','AR_UPDATING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:
828:

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

821: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating active cart table');
822: acc_merge_active_quotes(request_id,set_number,process_mode);
823: arp_message.set_name('AR','AR_UPDATING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:
828:
829: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');

Line 826: arp_message.set_token('NUM_ROWS',to_char(g_count));

822: acc_merge_active_quotes(request_id,set_number,process_mode);
823: arp_message.set_name('AR','AR_UPDATING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:
828:
829: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');
830: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE()- exiting');

Line 829: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');

825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:
828:
829: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');
830: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE()- exiting');
831: EXCEPTION
832:
833: WHEN MERGE_NOT_ALLOWED THEN

Line 834: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');

830: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE()- exiting');
831: EXCEPTION
832:
833: WHEN MERGE_NOT_ALLOWED THEN
834: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');
835: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
836: raise;
837:
838: WHEN OTHERS THEN

Line 835: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

831: EXCEPTION
832:
833: WHEN MERGE_NOT_ALLOWED THEN
834: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');
835: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
836: raise;
837:
838: WHEN OTHERS THEN
839: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

Line 839: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

835: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
836: raise;
837:
838: WHEN OTHERS THEN
839: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
840: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE() caught an exception:'|| sqlerrm) ;
841: raise;
842:
843: End Customer_Merge;

Line 897: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');

893:
894:
895: Begin
896:
897: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
898: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
899:
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:

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

934: /* If the Parent has changed(i.e. Parent is getting merged), then transfer the dependent record to the new parent. */
935:
936: if p_from_fk_id <> p_to_fk_id Then
937:
938: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
939: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
940:
941: Open C1;
942: Close C1;

Line 939: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

935:
936: if p_from_fk_id <> p_to_fk_id Then
937:
938: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
939: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
940:
941: Open C1;
942: Close C1;
943:

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

940:
941: Open C1;
942: Close C1;
943:
944: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,

Line 945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

941: Open C1;
942: Close C1;
943:
944: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,

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

957:
958:
959: l_count := sql%rowcount;
960:
961: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
962: arp_message.set_token('NUM_ROWS', to_char(l_count) );
963:
964: return;
965:

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

958:
959: l_count := sql%rowcount;
960:
961: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
962: arp_message.set_token('NUM_ROWS', to_char(l_count) );
963:
964: return;
965:
966: End If;

Line 968: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');

964: return;
965:
966: End If;
967:
968: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
969: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
970:
971: Exception
972: When RESOURCE_BUSY Then

Line 973: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||

969: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
970:
971: Exception
972: When RESOURCE_BUSY Then
973: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
974: 'on table IBE_SH_SHP_LISTS_ALL');
975: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
976: 'on table IBE_SH_SHP_LISTS_ALL');
977: x_return_status := FND_API.G_RET_STS_ERROR;

Line 981: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);

977: x_return_status := FND_API.G_RET_STS_ERROR;
978: raise;
979: When Others Then
980:
981: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
982: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: raise;
985:

Line 1046: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');

1042: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1043:
1044: Begin
1045:
1046: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1047: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1048:
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:

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

1113: If l_ord_oneclick_id is null Then
1114:
1115: -- Lock the table and update the record(s).
1116:
1117: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1118: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1119:
1120: Open C1;
1121: Close C1;

Line 1118: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1114:
1115: -- Lock the table and update the record(s).
1116:
1117: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1118: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1119:
1120: Open C1;
1121: Close C1;
1122:

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

1119:
1120: Open C1;
1121: Close C1;
1122:
1123: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1124: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1125:
1126:
1127: -- 4/8/02

Line 1124: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1120: Open C1;
1121: Close C1;
1122:
1123: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1124: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1125:
1126:
1127: -- 4/8/02
1128: -- If updating party_id results in uniqueness violation, means oneclick already has

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

1139: NULL;
1140: END;
1141: l_count := sql%rowcount;
1142:
1143: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1144: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1145:
1146: Return;
1147:

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

1140: END;
1141: l_count := sql%rowcount;
1142:
1143: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1144: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1145:
1146: Return;
1147:
1148: Else

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

1158: /* Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
1159:
1160: -- Lock the table and update the record(s).
1161:
1162: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1163: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1164:
1165: Open C1;
1166: Close C1;

Line 1163: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1159:
1160: -- Lock the table and update the record(s).
1161:
1162: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1163: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1164:
1165: Open C1;
1166: Close C1;
1167:

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

1164:
1165: Open C1;
1166: Close C1;
1167:
1168: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1170:
1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),

Line 1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1165: Open C1;
1166: Close C1;
1167:
1168: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1170:
1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),

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

1178: Or ship_to_pty_site_id = p_from_fk_id;
1179:
1180: l_count := sql%rowcount;
1181:
1182: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1183: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1184:
1185: Return;
1186: */

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

1179:
1180: l_count := sql%rowcount;
1181:
1182: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1183: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1184:
1185: Return;
1186: */
1187: End If;

Line 1191: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');

1187: End If;
1188:
1189: End If;
1190:
1191: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1192: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1193: Exception
1194: When RESOURCE_BUSY Then
1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||

Line 1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||

1191: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1192: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1193: Exception
1194: When RESOURCE_BUSY Then
1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1196: 'on table IBE_ORD_ONECLICK_ALL');
1197: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1198: 'on table IBE_ORD_ONECLICK_ALL');
1199: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1202: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);

1198: 'on table IBE_ORD_ONECLICK_ALL');
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: raise;
1201: When Others Then
1202: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1203: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: raise;
1206:

Line 1273: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');

1269: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1270:
1271: Begin
1272:
1273: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1274: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:

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

1305: loop
1306: fetch merge_records into l_msite_id, l_party_access_code;
1307: EXIT When merge_records%NOTFOUND;
1308: Begin
1309: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1310: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1311: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1312: ' merging msite:'||l_msite_id||' both & are BOTH on');
1313: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||

Line 1310: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);

1306: fetch merge_records into l_msite_id, l_party_access_code;
1307: EXIT When merge_records%NOTFOUND;
1308: Begin
1309: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1310: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1311: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1312: ' merging msite:'||l_msite_id||' both & are BOTH on');
1313: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1314: ' merging msite:'||l_msite_id||' both & are BOTH on');

Line 1311: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||

1307: EXIT When merge_records%NOTFOUND;
1308: Begin
1309: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1310: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1311: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1312: ' merging msite:'||l_msite_id||' both & are BOTH on');
1313: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1314: ' merging msite:'||l_msite_id||' both & are BOTH on');
1315:

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

1326: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code
1327: and b.site_type = 'I'
1328: );
1329: l_count := sql%rowcount;
1330: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1331: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1332:
1333:
1334: -- for a given msite, if has party access and doesn't

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

1327: and b.site_type = 'I'
1328: );
1329: l_count := sql%rowcount;
1330: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1331: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1332:
1333:
1334: -- for a given msite, if has party access and doesn't
1335: -- then end_date to prevent dangling party layer data

Line 1344: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);

1340: end if;
1341:
1342: Exception
1343: When Others Then
1344: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1345: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: raise;
1348: end;

Line 1355: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');

1351:
1352: End If;
1353: End If;
1354:
1355: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1356: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1357: Exception
1358: When RESOURCE_BUSY Then
1359: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||

Line 1359: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||

1355: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1356: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1357: Exception
1358: When RESOURCE_BUSY Then
1359: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1360: 'on table IBE_MSITE_PRTY_ACCSS');
1361: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1362: 'on table IBE_MSITE_PRTY_ACCSS');
1363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1366: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);

1362: 'on table IBE_MSITE_PRTY_ACCSS');
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: raise;
1365: When Others Then
1366: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1367: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: raise;
1370:

Line 1437: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');

1433: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1434:
1435: Begin
1436:
1437: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1438: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441:

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

1451:
1452:
1453:
1454: if p_from_fk_id <> p_to_fk_id Then
1455: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1456: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1457: open find_account(p_to_fk_id);
1458: fetch find_account into l_to_cust_account_id ;
1459: if p_parent_entity_name = 'HZ_PARTIES' Then

Line 1456: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

1452:
1453:
1454: if p_from_fk_id <> p_to_fk_id Then
1455: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1456: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1457: open find_account(p_to_fk_id);
1458: fetch find_account into l_to_cust_account_id ;
1459: if p_parent_entity_name = 'HZ_PARTIES' Then
1460: Open MERGE_FROM_SH;

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

1475: and cust_account_id = l_from_cust_account_id;
1476: Exception
1477: --update party ID to merge to if not a duplicate for merge to party
1478: When NO_DATA_FOUND Then
1479: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,

Line 1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

1476: Exception
1477: --update party ID to merge to if not a duplicate for merge to party
1478: When NO_DATA_FOUND Then
1479: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,

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

1520: end if; --end if p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1521:
1522: l_count := sql%rowcount;
1523:
1524: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1525: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1526: return;
1527:
1528:

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

1521:
1522: l_count := sql%rowcount;
1523:
1524: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1525: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1526: return;
1527:
1528:
1529: End If; --end if p_from_fk_id <> p_to_fk_id Then

Line 1531: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()-');

1527:
1528:
1529: End If; --end if p_from_fk_id <> p_to_fk_id Then
1530:
1531: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()-');
1532: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()-');
1533:
1534: Exception
1535: When RESOURCE_BUSY Then

Line 1536: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||

1532: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()-');
1533:
1534: Exception
1535: When RESOURCE_BUSY Then
1536: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1537: 'on table IBE_SH_QUOTE_ACCESS');
1538: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1539: 'on table IBE_SH_QUOTE_ACCESS');
1540: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1543: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);

1539: 'on table IBE_SH_QUOTE_ACCESS');
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: raise;
1542: When Others Then
1543: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1544: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: raise;
1547: End MERGE_SHARED_QUOTE;

Line 1606: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');

1602:
1603:
1604: BEGIN
1605:
1606: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1607: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1608:
1609: x_return_status := FND_API.G_RET_STS_SUCCESS;
1610:

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

1616:
1617:
1618:
1619: if p_from_fk_id <> p_to_fk_id Then
1620: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1621: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1622: open merge_from_active;
1623: loop
1624: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;

Line 1621: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

1617:
1618:
1619: if p_from_fk_id <> p_to_fk_id Then
1620: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1621: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1622: open merge_from_active;
1623: loop
1624: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;
1625: EXIT When merge_from_active%NOTFOUND;

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

1641:
1642: END LOOP;
1643: CLOSE MERGE_FROM_ACTIVE;
1644: l_count := sql%rowcount;
1645: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1646: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1647:
1648: return;
1649:

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

1642: END LOOP;
1643: CLOSE MERGE_FROM_ACTIVE;
1644: l_count := sql%rowcount;
1645: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1646: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1647:
1648: return;
1649:
1650: END IF;

Line 1652: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');

1648: return;
1649:
1650: END IF;
1651:
1652: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');
1653: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');
1654:
1655: Exception
1656: When RESOURCE_BUSY Then

Line 1657: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||

1653: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');
1654:
1655: Exception
1656: When RESOURCE_BUSY Then
1657: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1658: 'on table IBE_ACTIVE_QUOTES_ALL');
1659: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1660: 'on table IBE_ACTIVE_QUOTES_ALL');
1661: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1664: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);

1660: 'on table IBE_ACTIVE_QUOTES_ALL');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: raise;
1663: When Others Then
1664: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1665: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1666: x_return_status := FND_API.G_RET_STS_ERROR;
1667: raise;
1668: END MERGE_ACTIVE_QUOTE;