APPS.IBE_MERGE_PVT dependencies on ARP_MESSAGE

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

151: BEGIN
152: IF process_mode='LOCK' THEN
153: NULL;
154: ELSE
155: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
156: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
157: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
158: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
159: --cursor to get party and account ID

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

152: IF process_mode='LOCK' THEN
153: NULL;
154: ELSE
155: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
156: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
157: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
158: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
159: --cursor to get party and account ID
160: open merged_records;

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

202: EXIT;
203: END IF;
204: END LOOP;
205: close merged_records;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: END IF;
209: EXCEPTION
210: WHEN OTHERS THEN

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

203: END IF;
204: END LOOP;
205: close merged_records;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: END IF;
209: EXCEPTION
210: WHEN OTHERS THEN
211: arp_message.set_line( 'acc_merge_oneclick');

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

207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: END IF;
209: EXCEPTION
210: WHEN OTHERS THEN
211: arp_message.set_line( 'acc_merge_oneclick');
212: RAISE;
213: END acc_merge_oneclick;
214:
215:

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

271: BEGIN
272: IF process_mode='LOCK' THEN
273: NULL;
274: ELSE
275: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
276: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
277: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
278: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
279: --cursor to get party and account ID

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

272: IF process_mode='LOCK' THEN
273: NULL;
274: ELSE
275: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
276: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
277: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
278: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
279: --cursor to get party and account ID
280: open merged_records;

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

357: EXIT;
358: END IF;
359: END LOOP;
360: close merged_records;
361: arp_message.set_name('AR','AR_ROWS_UPDATED');
362: arp_message.set_token('NUM_ROWS',to_char(l_count));
363: END IF;
364: EXCEPTION
365: WHEN OTHERS THEN

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

358: END IF;
359: END LOOP;
360: close merged_records;
361: arp_message.set_name('AR','AR_ROWS_UPDATED');
362: arp_message.set_token('NUM_ROWS',to_char(l_count));
363: END IF;
364: EXCEPTION
365: WHEN OTHERS THEN
366: arp_message.set_line( 'acc_merge_shp_lists');

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

362: arp_message.set_token('NUM_ROWS',to_char(l_count));
363: END IF;
364: EXCEPTION
365: WHEN OTHERS THEN
366: arp_message.set_line( 'acc_merge_shp_lists');
367: RAISE;
368: END acc_merge_shp_lists;
369:
370:

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

431: BEGIN
432: IF process_mode='LOCK' THEN
433: NULL;
434: ELSE
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
437: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
438: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
439:

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

432: IF process_mode='LOCK' THEN
433: NULL;
434: ELSE
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
437: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
438: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
439:
440: open C_ACTIVE_QUOTE_FROM;

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

488: End;
489:
490: END LOOP;
491: close C_ACTIVE_QUOTE_FROM;
492: arp_message.set_name('AR','AR_ROWS_UPDATED');
493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN

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

489:
490: END LOOP;
491: close C_ACTIVE_QUOTE_FROM;
492: arp_message.set_name('AR','AR_ROWS_UPDATED');
493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN
497: arp_message.set_line( 'acc_merge_active_quotes');

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

493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN
497: arp_message.set_line( 'acc_merge_active_quotes');
498: RAISE;
499: END acc_merge_active_quotes;
500:
501:

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

582: BEGIN
583: IF process_mode='LOCK' THEN
584: NULL;
585: ELSE
586: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
587: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
588: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
589: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
590:

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

583: IF process_mode='LOCK' THEN
584: NULL;
585: ELSE
586: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
587: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
588: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
589: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
590:
591: --retrieve shared carts

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

648: hz_utility_pub.LAST_UPDATED_BY );
649: end if;
650: else
651: --if shared cart not a duplicate of , update party/account ID to merge to
652: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
654: --fix for 2940366
655: if customer_type = 'CUSTOMER_ORG' then
656: --B2B, partyID stays the same

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

649: end if;
650: else
651: --if shared cart not a duplicate of , update party/account ID to merge to
652: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
654: --fix for 2940366
655: if customer_type = 'CUSTOMER_ORG' then
656: --B2B, partyID stays the same
657: l_to_party_id := l_from_party_id;

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

787: AND RACM.SET_NUMBER = set_number;
788:
789: BEGIN
790:
791: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()+');
792:
793: p_request_id := request_id;
794:
795: /* Check to See if you can allow the customer merge to happen */

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

813: /*obsolete code after consulting with TCA, lock mode not used*/
814: /*
815: If process_mode = 'LOCK' then
816:
817: arp_message.set_name('AR','AR_LOCKING_TABLE');
818: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
819:
820: open C;
821: close C;

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

814: /*
815: If process_mode = 'LOCK' then
816:
817: arp_message.set_name('AR','AR_LOCKING_TABLE');
818: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
819:
820: open C;
821: close C;
822:

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

819:
820: open C;
821: close C;
822:
823: arp_message.set_name('AR','AR_LOCKING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
825:
826: open C1;
827: close C1;

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

820: open C;
821: close C;
822:
823: arp_message.set_name('AR','AR_LOCKING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
825:
826: open C1;
827: close C1;
828:

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

825:
826: open C1;
827: close C1;
828:
829: arp_message.set_name('AR','AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
831:
832: open C2;
833: close C2;

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

826: open C1;
827: close C1;
828:
829: arp_message.set_name('AR','AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
831:
832: open C2;
833: close C2;
834:

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

833: close C2;
834:
835: End If; */
836:
837: arp_message.set_name('AR','AR_UPDATING_TABLE');
838: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
839:
840: /* For updating IBE_SH_SHP_LISTS_ALL table*/
841: --2940366

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

834:
835: End If; */
836:
837: arp_message.set_name('AR','AR_UPDATING_TABLE');
838: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
839:
840: /* For updating IBE_SH_SHP_LISTS_ALL table*/
841: --2940366
842: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);

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

840: /* For updating IBE_SH_SHP_LISTS_ALL table*/
841: --2940366
842: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
843: g_count := sql%rowcount;
844: arp_message.set_name('AR','AR_ROWS_UPDATED');
845: arp_message.set_token('NUM_ROWS',to_char(g_count));
846:
847: /* For updating IBE_ORD_ONECLICK_ALL Table */
848: /* 4/8/02

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

841: --2940366
842: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
843: g_count := sql%rowcount;
844: arp_message.set_name('AR','AR_ROWS_UPDATED');
845: arp_message.set_token('NUM_ROWS',to_char(g_count));
846:
847: /* For updating IBE_ORD_ONECLICK_ALL Table */
848: /* 4/8/02
849: If oneclick table already has entry for the merge to account, ignore and do nothing

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

848: /* 4/8/02
849: If oneclick table already has entry for the merge to account, ignore and do nothing
850: */
851: acc_merge_oneclick(request_id,set_number,process_mode);
852: arp_message.set_name('AR','AR_UPDATING_TABLE');
853: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
854: g_count := sql%rowcount;
855:
856:

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

849: If oneclick table already has entry for the merge to account, ignore and do nothing
850: */
851: acc_merge_oneclick(request_id,set_number,process_mode);
852: arp_message.set_name('AR','AR_UPDATING_TABLE');
853: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
854: g_count := sql%rowcount;
855:
856:
857: /* account merge for shared quote

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

858: 12/18/02
859: */
860: --2940366
861: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
862: arp_message.set_name('AR','AR_UPDATING_TABLE');
863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
864: arp_message.set_name('AR','AR_ROWS_UPDATED');
865: arp_message.set_token('NUM_ROWS',to_char(g_count));
866:

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

859: */
860: --2940366
861: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
862: arp_message.set_name('AR','AR_UPDATING_TABLE');
863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
864: arp_message.set_name('AR','AR_ROWS_UPDATED');
865: arp_message.set_token('NUM_ROWS',to_char(g_count));
866:
867:

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

860: --2940366
861: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
862: arp_message.set_name('AR','AR_UPDATING_TABLE');
863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
864: arp_message.set_name('AR','AR_ROWS_UPDATED');
865: arp_message.set_token('NUM_ROWS',to_char(g_count));
866:
867:
868: /*merge active cart

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

861: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
862: arp_message.set_name('AR','AR_UPDATING_TABLE');
863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
864: arp_message.set_name('AR','AR_ROWS_UPDATED');
865: arp_message.set_token('NUM_ROWS',to_char(g_count));
866:
867:
868: /*merge active cart
869: 12/18/02

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

868: /*merge active cart
869: 12/18/02
870: */
871: acc_merge_active_quotes(request_id,set_number,process_mode);
872: arp_message.set_name('AR','AR_UPDATING_TABLE');
873: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:

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

869: 12/18/02
870: */
871: acc_merge_active_quotes(request_id,set_number,process_mode);
872: arp_message.set_name('AR','AR_UPDATING_TABLE');
873: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:

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

870: */
871: acc_merge_active_quotes(request_id,set_number,process_mode);
872: arp_message.set_name('AR','AR_UPDATING_TABLE');
873: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:
878: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');

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

871: acc_merge_active_quotes(request_id,set_number,process_mode);
872: arp_message.set_name('AR','AR_UPDATING_TABLE');
873: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:
878: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');
879:

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

874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:
878: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');
879:
880: EXCEPTION
881:
882: WHEN MERGE_NOT_ALLOWED THEN

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

879:
880: EXCEPTION
881:
882: WHEN MERGE_NOT_ALLOWED THEN
883: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');
884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
885: raise;
886:
887: WHEN OTHERS THEN

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

880: EXCEPTION
881:
882: WHEN MERGE_NOT_ALLOWED THEN
883: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');
884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
885: raise;
886:
887: WHEN OTHERS THEN
888: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

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

884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
885: raise;
886:
887: WHEN OTHERS THEN
888: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
889: raise;
890:
891: End Customer_Merge;
892:

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

941:
942:
943: Begin
944:
945: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
946:
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949:

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

981: /* If the Parent has changed(i.e. Parent is getting merged), then transfer the dependent record to the new parent. */
982:
983: if p_from_fk_id <> p_to_fk_id Then
984:
985: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
986: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
987:
988: Open C1;
989: Close C1;

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

982:
983: if p_from_fk_id <> p_to_fk_id Then
984:
985: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
986: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
987:
988: Open C1;
989: Close C1;
990:

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

987:
988: Open C1;
989: Close C1;
990:
991: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,

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

988: Open C1;
989: Close C1;
990:
991: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,

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

1004:
1005:
1006: l_count := sql%rowcount;
1007:
1008: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1009: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1010:
1011: return;
1012:

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

1005:
1006: l_count := sql%rowcount;
1007:
1008: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1009: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1010:
1011: return;
1012:
1013: End If;

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

1011: return;
1012:
1013: End If;
1014:
1015: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
1016:
1017:
1018: Exception
1019: When RESOURCE_BUSY Then

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

1016:
1017:
1018: Exception
1019: When RESOURCE_BUSY Then
1020: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
1021: 'on table IBE_SH_SHP_LISTS_ALL');
1022:
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: raise;

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

1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: raise;
1025: When Others Then
1026:
1027: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030: raise;
1031:

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

1088: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1089:
1090: Begin
1091:
1092: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1093:
1094: x_return_status := FND_API.G_RET_STS_SUCCESS;
1095:
1096: --Do All Validations

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

1158: If l_ord_oneclick_id is null 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:
1172: -- 4/8/02

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:
1172: -- 4/8/02
1173: -- If updating party_id results in uniqueness violation, means oneclick already has

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

1184: NULL;
1185: END;
1186: l_count := sql%rowcount;
1187:
1188: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1189: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1190:
1191: Return;
1192:

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

1185: END;
1186: l_count := sql%rowcount;
1187:
1188: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1189: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1190:
1191: Return;
1192:
1193: Else

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

1203: /* Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
1204:
1205: -- Lock the table and update the record(s).
1206:
1207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1208: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1209:
1210: Open C1;
1211: Close C1;

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

1204:
1205: -- Lock the table and update the record(s).
1206:
1207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1208: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1209:
1210: Open C1;
1211: Close C1;
1212:

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

1209:
1210: Open C1;
1211: Close C1;
1212:
1213: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1214: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1215:
1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: 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 1214: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1210: Open C1;
1211: Close C1;
1212:
1213: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1214: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1215:
1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: 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 1227: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

1223: Or ship_to_pty_site_id = p_from_fk_id;
1224:
1225: l_count := sql%rowcount;
1226:
1227: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1228: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1229:
1230: Return;
1231: */

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

1224:
1225: l_count := sql%rowcount;
1226:
1227: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1228: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1229:
1230: Return;
1231: */
1232: End If;

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

1232: End If;
1233:
1234: End If;
1235:
1236: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1237:
1238: Exception
1239: When RESOURCE_BUSY Then
1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||

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

1236: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1237:
1238: Exception
1239: When RESOURCE_BUSY Then
1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1241: 'on table IBE_ORD_ONECLICK_ALL');
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: raise;
1244: When Others Then

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

1241: 'on table IBE_ORD_ONECLICK_ALL');
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: raise;
1244: When Others Then
1245: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: raise;
1248:
1249:

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

1311: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1312:
1313: Begin
1314:
1315: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1316:
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319:

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

1346: loop
1347: fetch merge_records into l_msite_id, l_party_access_code;
1348: EXIT When merge_records%NOTFOUND;
1349: Begin
1350: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1351: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1352: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1353: ' merging msite:'||l_msite_id||' both & are BOTH on');
1354:

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

1347: fetch merge_records into l_msite_id, l_party_access_code;
1348: EXIT When merge_records%NOTFOUND;
1349: Begin
1350: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1351: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1352: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1353: ' merging msite:'||l_msite_id||' both & are BOTH on');
1354:
1355: -- only merge when both & are BOTH on

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

1348: EXIT When merge_records%NOTFOUND;
1349: Begin
1350: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1351: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1352: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1353: ' merging msite:'||l_msite_id||' both & are BOTH on');
1354:
1355: -- only merge when both & are BOTH on
1356: -- and doesn't have restrictions on the minisite

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

1365: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code
1366: and b.site_type = 'I'
1367: );
1368: l_count := sql%rowcount;
1369: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1370: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1371:
1372:
1373: -- for a given msite, if has party access and doesn't

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

1366: and b.site_type = 'I'
1367: );
1368: l_count := sql%rowcount;
1369: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1370: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1371:
1372:
1373: -- for a given msite, if has party access and doesn't
1374: -- then end_date to prevent dangling party layer data

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

1379: end if;
1380:
1381: Exception
1382: When Others Then
1383: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: raise;
1386: end;
1387: end loop;

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

1389:
1390: End If;
1391: End If;
1392:
1393: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1394:
1395: Exception
1396: When RESOURCE_BUSY Then
1397: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||

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

1393: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1394:
1395: Exception
1396: When RESOURCE_BUSY Then
1397: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1398: 'on table IBE_MSITE_PRTY_ACCSS');
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: raise;
1401: When Others Then

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

1398: 'on table IBE_MSITE_PRTY_ACCSS');
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: raise;
1401: When Others Then
1402: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: raise;
1405:
1406:

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

1468: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1469:
1470: Begin
1471:
1472: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1473:
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475:
1476: /* Perform the merge operation */

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

1485:
1486:
1487:
1488: if p_from_fk_id <> p_to_fk_id Then
1489: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1490: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1491: open find_account(p_to_fk_id);
1492: fetch find_account into l_to_cust_account_id ;
1493: if p_parent_entity_name = 'HZ_PARTIES' Then

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

1486:
1487:
1488: if p_from_fk_id <> p_to_fk_id Then
1489: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1490: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1491: open find_account(p_to_fk_id);
1492: fetch find_account into l_to_cust_account_id ;
1493: if p_parent_entity_name = 'HZ_PARTIES' Then
1494: Open MERGE_FROM_SH;

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

1509: and cust_account_id = l_from_cust_account_id;
1510: Exception
1511: --update party ID to merge to if not a duplicate for merge to party
1512: When NO_DATA_FOUND Then
1513: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,

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

1510: Exception
1511: --update party ID to merge to if not a duplicate for merge to party
1512: When NO_DATA_FOUND Then
1513: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,

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

1554: end if; --end if p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1555:
1556: l_count := sql%rowcount;
1557:
1558: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1559: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1560: return;
1561:
1562:

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

1555:
1556: l_count := sql%rowcount;
1557:
1558: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1559: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1560: return;
1561:
1562:
1563: End If; --end if p_from_fk_id <> p_to_fk_id Then

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

1561:
1562:
1563: End If; --end if p_from_fk_id <> p_to_fk_id Then
1564:
1565: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
1566:
1567:
1568: Exception
1569: When RESOURCE_BUSY Then

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

1566:
1567:
1568: Exception
1569: When RESOURCE_BUSY Then
1570: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1571: 'on table IBE_SH_QUOTE_ACCESS');
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: raise;
1574: When Others Then

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

1571: 'on table IBE_SH_QUOTE_ACCESS');
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: raise;
1574: When Others Then
1575: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: raise;
1578: End MERGE_SHARED_QUOTE;
1579:

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

1633:
1634:
1635: BEGIN
1636:
1637: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1638:
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641:

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

1646:
1647:
1648:
1649: if p_from_fk_id <> p_to_fk_id Then
1650: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1651: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1652: open merge_from_active;
1653: loop
1654: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;

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

1647:
1648:
1649: if p_from_fk_id <> p_to_fk_id Then
1650: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1651: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1652: open merge_from_active;
1653: loop
1654: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;
1655: EXIT When merge_from_active%NOTFOUND;

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

1671:
1672: END LOOP;
1673: CLOSE MERGE_FROM_ACTIVE;
1674: l_count := sql%rowcount;
1675: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1676: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1677:
1678: return;
1679:

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

1672: END LOOP;
1673: CLOSE MERGE_FROM_ACTIVE;
1674: l_count := sql%rowcount;
1675: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1676: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1677:
1678: return;
1679:
1680: END IF;

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

1678: return;
1679:
1680: END IF;
1681:
1682: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');
1683:
1684:
1685: Exception
1686: When RESOURCE_BUSY Then

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

1683:
1684:
1685: Exception
1686: When RESOURCE_BUSY Then
1687: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1688: 'on table IBE_ACTIVE_QUOTES_ALL');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: raise;
1691: When Others Then

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

1688: 'on table IBE_ACTIVE_QUOTES_ALL');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: raise;
1691: When Others Then
1692: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: raise;
1695: END MERGE_ACTIVE_QUOTE;
1696: