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.ARP_CMERGE_ARCUS dependencies on ARP_CMERGE_ARCUS

Line 1: PACKAGE BODY arp_cmerge_arcus AS

1: PACKAGE BODY arp_cmerge_arcus AS
2: /*$Header: ARHCMGNB.pls 120.52.12020000.3 2013/03/01 08:42:47 vsegu ship $*/
3:
4: g_count NUMBER := 0;
5:

Line 193: arp_message.set_line( 'ARP_CMERGE_ARCUS.MERGE()+' );

189: ) IS
190:
191: BEGIN
192:
193: arp_message.set_line( 'ARP_CMERGE_ARCUS.MERGE()+' );
194: --merge account site uses
195: ra_su( req_id, set_num, process_mode );
196:
197: --merge account sites

Line 245: arp_message.set_line( 'ARP_CMERGE_ARCUS.MERGE()-' );

241: --hz_cust_contact_points has been obsoleted.
242: --merge contact points: phone
243: --ra_ph( req_id, set_num, process_mode );
244:
245: arp_message.set_line( 'ARP_CMERGE_ARCUS.MERGE()-' );
246:
247: END merge;
248: /*===========================================================================+
249: | PROCEDURE

Line 303: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_BILL_TO_LOCATION()+' );

299: l_org_id NUMBER(15);
300:
301: BEGIN
302:
303: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_BILL_TO_LOCATION()+' );
304: OPEN c1;
305: LOOP
306: FETCH c1 INTO l_dup_site_id,l_cust_site_id,l_bill_to_site_use_id,
307: l_site_use_code,l_create_same_site,l_org_id; --SSUptake

Line 366: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_BILL_TO_LOCATION()-' );

362:
363:
364: END LOOP;
365: CLOSE c1;
366: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_BILL_TO_LOCATION()-' );
367: END;
368: /*===========================================================================+
369: | PROCEDURE
370: | ra_su

Line 445: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()+' );

441: AND (m.delete_duplicate_flag = 'N' OR m.delete_duplicate_flag = 'Y');
442:
443: BEGIN
444:
445: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()+' );
446:
447: /* locking tables by opening and closing cursors */
448: IF process_mode = 'LOCK' THEN
449:

Line 665: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()-' );

661:
662: end loop;
663: close c2;
664:
665: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()-' );
666:
667: EXCEPTION
668:
669: WHEN OTHERS THEN

Line 670: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_SU' );

666:
667: EXCEPTION
668:
669: WHEN OTHERS THEN
670: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_SU' );
671: RAISE;
672:
673: END ra_su;
674:

Line 778: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()+' );

774:
775:
776: BEGIN
777:
778: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()+' );
779:
780: /* locking tables by opening and closing cursors */
781: IF process_mode = 'LOCK' THEN
782:

Line 1117: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()-' );

1113: end loop;
1114: close c3;
1115:
1116:
1117: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()-' );
1118:
1119: EXCEPTION
1120:
1121: WHEN OTHERS THEN

Line 1122: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_ADDR' );

1118:
1119: EXCEPTION
1120:
1121: WHEN OTHERS THEN
1122: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_ADDR' );
1123: RAISE;
1124:
1125: END ra_addr;
1126:

Line 1229: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()+' );

1225:
1226:
1227: BEGIN
1228:
1229: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()+' );
1230:
1231: /* locking tables by opening and closing cursors */
1232: IF process_mode = 'LOCK' THEN
1233:

Line 1353: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()-' );

1349:
1350: end loop;
1351: close c3;
1352:
1353: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()-' );
1354:
1355: EXCEPTION
1356:
1357: WHEN OTHERS THEN

Line 1358: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CUST' );

1354:
1355: EXCEPTION
1356:
1357: WHEN OTHERS THEN
1358: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CUST' );
1359: RAISE;
1360:
1361: END ra_cust;
1362:

Line 1500: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()+' );

1496: --End of Bug No: 4527935
1497:
1498: BEGIN
1499:
1500: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()+' );
1501:
1502: /* locking tables by opening and closing cursors */
1503: IF process_mode = 'LOCK' THEN
1504:

Line 1862: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()-' );

1858: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1859:
1860: END IF;
1861:
1862: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()-' );
1863:
1864: EXCEPTION
1865:
1866: WHEN OTHERS THEN

Line 1867: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CR' );

1863:
1864: EXCEPTION
1865:
1866: WHEN OTHERS THEN
1867: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CR' );
1868: RAISE;
1869:
1870: END ra_cr;
1871:

Line 1966: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()+' );

1962: end_date end_date_tab;
1963: new_date date;
1964: BEGIN
1965:
1966: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()+' );
1967:
1968: /* locking tables by opening and closing cursors */
1969: IF process_mode = 'LOCK' THEN
1970:

Line 2210: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()-' );

2206: | arp_message.set_token( 'NUM_ROWS', to_char(g_count) ); */
2207:
2208: END IF;
2209:
2210: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()-' );
2211:
2212: EXCEPTION
2213:
2214: WHEN OTHERS THEN

Line 2215: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CRM' );

2211:
2212: EXCEPTION
2213:
2214: WHEN OTHERS THEN
2215: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CRM' );
2216: RAISE;
2217:
2218: END ra_crm;
2219:

Line 2279: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()+' );

2275: AND duplicate_id <> customer_id;
2276:
2277: BEGIN
2278:
2279: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()+' );
2280:
2281: OPEN accounts;
2282: LOOP
2283: FETCH accounts INTO from_account_id, to_account_id;

Line 2288: 'ARP_CMERGE_ARCUS:copy_contacts():from_account_id ' ||

2284: EXIT WHEN accounts%NOTFOUND;
2285:
2286: /**
2287: arp_message.set_line(
2288: 'ARP_CMERGE_ARCUS:copy_contacts():from_account_id ' ||
2289: from_account_id );
2290: arp_message.set_line(
2291: 'ARP_CMERGE_ARCUS:copy_contacts():to_account_id ' ||
2292: to_account_id );

Line 2291: 'ARP_CMERGE_ARCUS:copy_contacts():to_account_id ' ||

2287: arp_message.set_line(
2288: 'ARP_CMERGE_ARCUS:copy_contacts():from_account_id ' ||
2289: from_account_id );
2290: arp_message.set_line(
2291: 'ARP_CMERGE_ARCUS:copy_contacts():to_account_id ' ||
2292: to_account_id );
2293: **/
2294:
2295: SELECT party_id, status into from_party_id, from_account_status

Line 2305: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_id '||

2301: WHERE cust_account_id = to_account_id;
2302:
2303: /**
2304: arp_message.set_line(
2305: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_id '||
2306: from_party_id );
2307: arp_message.set_line(
2308: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_id '||
2309: to_party_id );

Line 2308: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_id '||

2304: arp_message.set_line(
2305: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_id '||
2306: from_party_id );
2307: arp_message.set_line(
2308: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_id '||
2309: to_party_id );
2310: **/
2311:
2312: --Based on customer merge high level design:

Line 2321: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||

2317: IF to_party_id = from_party_id THEN
2318:
2319: /**
2320: arp_message.set_line (
2321: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||
2322: 'merge_from party and merge_to party are same. ' ||
2323: 'Do not need copy org contact and contact points in account level.' );
2324: **/
2325: NULL;

Line 2352: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()-' );

2348:
2349: END LOOP;
2350: CLOSE accounts;
2351:
2352: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()-' );
2353:
2354: EXCEPTION
2355:
2356: WHEN OTHERS THEN

Line 2357: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts' );

2353:
2354: EXCEPTION
2355:
2356: WHEN OTHERS THEN
2357: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts' );
2358: RAISE;
2359:
2360: END copy_contacts;
2361:

Line 2418: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()+' );

2414: AND duplicate_address_id <> -1; --4693912
2415:
2416: BEGIN
2417:
2418: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()+' );
2419:
2420: OPEN sites;
2421: LOOP
2422: FETCH sites INTO

Line 2428: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():from_site_id ' ||

2424: EXIT WHEN sites%NOTFOUND;
2425:
2426: /**
2427: arp_message.set_line(
2428: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():from_site_id ' ||
2429: from_site_id );
2430: arp_message.set_line(
2431: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():to_site_id ' ||
2432: to_site_id );

Line 2431: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():to_site_id ' ||

2427: arp_message.set_line(
2428: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():from_site_id ' ||
2429: from_site_id );
2430: arp_message.set_line(
2431: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():to_site_id ' ||
2432: to_site_id );
2433: **/
2434:
2435: SELECT party_site_id into from_party_site_id

Line 2445: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_site_id '||

2441: WHERE cust_acct_site_id = to_site_id;
2442:
2443: /**
2444: arp_message.set_line(
2445: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_site_id '||
2446: from_party_site_id );
2447: arp_message.set_line(
2448: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_site_id '||
2449: to_party_site_id );

Line 2448: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_site_id '||

2444: arp_message.set_line(
2445: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_site_id '||
2446: from_party_site_id );
2447: arp_message.set_line(
2448: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_site_id '||
2449: to_party_site_id );
2450: **/
2451:
2452: --Based on customer merge high level design:

Line 2461: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||

2457: IF to_party_site_id = from_party_site_id THEN
2458:
2459: /**
2460: arp_message.set_line (
2461: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||
2462: 'merge_from party and merge_to party site are same. ' ||
2463: 'Do not need copy contact points.' );
2464: **/
2465:

Line 2479: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()-' );

2475:
2476: END LOOP;
2477: CLOSE sites;
2478:
2479: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()-' );
2480:
2481: EXCEPTION
2482:
2483: WHEN OTHERS THEN

Line 2484: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites' );

2480:
2481: EXCEPTION
2482:
2483: WHEN OTHERS THEN
2484: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites' );
2485: RAISE;
2486:
2487: END copy_contacts_in_sites;
2488:

Line 2594: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()+' );

2590: ---Bug NO: 5067291
2591:
2592: BEGIN
2593:
2594: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()+' );
2595:
2596: /* locking tables by opening and closing cursors */
2597: IF process_mode = 'LOCK' then
2598:

Line 2869: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()-' );

2865: CLOSE C3_1;--5067291
2866:
2867: END IF; --g_tranfer_account_contacts
2868: END IF; --process_mode
2869: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()-' );
2870:
2871: EXCEPTION
2872:
2873: WHEN OTHERS THEN

Line 2874: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CONT' );

2870:
2871: EXCEPTION
2872:
2873: WHEN OTHERS THEN
2874: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CONT' );
2875: RAISE;
2876:
2877: END ra_cont;
2878:

Line 2946: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()+' );

2942: FOR UPDATE NOWAIT;
2943:
2944: BEGIN
2945:
2946: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()+' );
2947:
2948: /* locking tables by opening and closing cursors */
2949: IF process_mode = 'LOCK' THEN
2950:

Line 3030: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()-' );

3026: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3027:
3028: END IF;
3029:
3030: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()-' );
3031:
3032: EXCEPTION
3033:
3034: WHEN OTHERS THEN

Line 3035: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_PH' );

3031:
3032: EXCEPTION
3033:
3034: WHEN OTHERS THEN
3035: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_PH' );
3036: RAISE;
3037:
3038: END ra_ph;
3039:

Line 3103: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()+' );

3099:
3100:
3101: BEGIN
3102:
3103: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()+' );
3104:
3105: /* locking tables by opening and closing cursors */
3106: IF process_mode = 'LOCK' THEN
3107:

Line 3275: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()-' );

3271: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3272:
3273:
3274: END IF;
3275: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()-' );
3276:
3277: EXCEPTION
3278:
3279: WHEN OTHERS THEN

Line 3280: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_USG' );

3276:
3277: EXCEPTION
3278:
3279: WHEN OTHERS THEN
3280: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_USG' );
3281: RAISE;
3282: END ra_usg;
3283: --4307679
3284:

Line 3384: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()+' );

3380: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
3381:
3382: BEGIN
3383:
3384: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()+' );
3385:
3386: /* Copy org contact */
3387: OPEN c;
3388: LOOP

Line 3416: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()-' );

3412:
3413: END LOOP;
3414: CLOSE c;
3415:
3416: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()-' );
3417:
3418: EXCEPTION
3419:
3420: WHEN OTHERS THEN

Line 3421: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts' );

3417:
3418: EXCEPTION
3419:
3420: WHEN OTHERS THEN
3421: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts' );
3422: RAISE;
3423:
3424: END do_cust_merge_contacts;
3425:

Line 3557: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()+' );

3553: AND set_number = p_set_num;
3554:
3555: BEGIN
3556:
3557: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()+' );
3558:
3559: /* For each site level org contact do the following */
3560: OPEN d;
3561: LOOP

Line 3622: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()-' );

3618:
3619: END LOOP;
3620: CLOSE d;
3621:
3622: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()-' );
3623:
3624: EXCEPTION
3625:
3626: WHEN OTHERS THEN

Line 3627: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_contacts' );

3623:
3624: EXCEPTION
3625:
3626: WHEN OTHERS THEN
3627: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_contacts' );
3628: RAISE;
3629:
3630: END do_site_merge_contacts;
3631:

Line 3717: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()+' );

3713: l_party_type varchar2(30);
3714: --End of Bug No: 4387523
3715: BEGIN
3716:
3717: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()+' );
3718:
3719: --check if the org contact has been migrated
3720: BEGIN
3721: l_sql := 'SELECT new_id ' ||

Line 3912: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()-' );

3908: p_org_party_id,
3909: x_org_party_id,
3910: p_from_account_id );
3911:
3912: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()-' );
3913:
3914: EXCEPTION
3915:
3916: WHEN OTHERS THEN

Line 3917: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_merge_contacts' );

3913:
3914: EXCEPTION
3915:
3916: WHEN OTHERS THEN
3917: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_merge_contacts' );
3918: RAISE;
3919:
3920: END do_merge_contacts;
3921:

Line 3970: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()+' );

3966: ) IS
3967:
3968: BEGIN
3969:
3970: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()+' );
3971:
3972: do_copy_contact_points ( 'HZ_PARTIES',
3973: p_from_party_id,
3974: p_to_party_id,

Line 3977: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()-' );

3973: p_from_party_id,
3974: p_to_party_id,
3975: p_from_account_id );
3976:
3977: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()-' );
3978:
3979: EXCEPTION
3980:
3981: WHEN OTHERS THEN

Line 3982: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint' );

3978:
3979: EXCEPTION
3980:
3981: WHEN OTHERS THEN
3982: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint' );
3983: RAISE;
3984:
3985: END do_cust_merge_cpoint;
3986:

Line 4035: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()+' );

4031: ) IS
4032:
4033: BEGIN
4034:
4035: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()+' );
4036:
4037: do_copy_contact_points ( 'HZ_PARTY_SITES',
4038: p_from_party_site_id,
4039: p_to_party_site_id,

Line 4042: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()-' );

4038: p_from_party_site_id,
4039: p_to_party_site_id,
4040: p_from_account_id );
4041:
4042: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()-' );
4043:
4044: EXCEPTION
4045:
4046: WHEN OTHERS THEN

Line 4047: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint' );

4043:
4044: EXCEPTION
4045:
4046: WHEN OTHERS THEN
4047: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint' );
4048: RAISE;
4049:
4050: END do_site_merge_cpoint;
4051:

Line 4132: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points ()+' );

4128: l_dup_exists VARCHAR2(10) := fnd_api.g_false;
4129:
4130: BEGIN
4131:
4132: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points ()+' );
4133:
4134: OPEN c;
4135: LOOP
4136: FETCH c INTO l_contact_point_id;

Line 4242: 'ARP_CMERGE_ARCUS:do_copy_contact_points():old contact point id =' ||

4238: END IF;
4239:
4240: /**
4241: arp_message.set_line(
4242: 'ARP_CMERGE_ARCUS:do_copy_contact_points():old contact point id =' ||
4243: l_contact_point_id );
4244:
4245: arp_message.set_line(
4246: 'ARP_CMERGE_ARCUS.do_copy_contact_points:contact_point_id = ' ||

Line 4246: 'ARP_CMERGE_ARCUS.do_copy_contact_points:contact_point_id = ' ||

4242: 'ARP_CMERGE_ARCUS:do_copy_contact_points():old contact point id =' ||
4243: l_contact_point_id );
4244:
4245: arp_message.set_line(
4246: 'ARP_CMERGE_ARCUS.do_copy_contact_points:contact_point_id = ' ||
4247: x_contact_point_id );
4248: **/
4249:
4250: END IF;

Line 4264: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points()-' );

4260: **/
4261: END LOOP;
4262: CLOSE c;
4263:
4264: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points()-' );
4265:
4266: EXCEPTION
4267:
4268: WHEN OTHERS THEN

Line 4269: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_copy_contact_points' );

4265:
4266: EXCEPTION
4267:
4268: WHEN OTHERS THEN
4269: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_copy_contact_points' );
4270: RAISE;
4271:
4272: END do_copy_contact_points;
4273:

Line 4385: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_org_contact_dup' );

4381:
4382: EXCEPTION
4383:
4384: WHEN OTHERS THEN
4385: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_org_contact_dup' );
4386: RAISE;
4387:
4388: END check_org_contact_dup;
4389:

Line 4518: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_contact_point_dup' );

4514: RETURN FND_API.G_TRUE;
4515:
4516: EXCEPTION
4517: WHEN OTHERS THEN
4518: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_contact_point_dup' );
4519: RAISE;
4520:
4521: END check_contact_point_dup;
4522:

Line 4556: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||

4552: l_sql VARCHAR2(1000);
4553:
4554: BEGIN
4555:
4556: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4557: g_table_name || ' )()+' );
4558:
4559: BEGIN
4560:

Line 4588: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||

4584: END IF;
4585:
4586: EXECUTE IMMEDIATE l_sql;
4587:
4588: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4589: g_table_name || ' )()-' );
4590:
4591: EXCEPTION
4592:

Line 4594: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||

4590:
4591: EXCEPTION
4592:
4593: WHEN OTHERS THEN
4594: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4595: g_table_name || ' )' );
4596: RAISE;
4597:
4598: END create_temporary_table;

Line 4734: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()+' );

4730: AND m.delete_duplicate_flag = 'Y');
4731:
4732: BEGIN
4733:
4734: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()+' );
4735:
4736: /*****************************************************/
4737:
4738: --4307679

Line 4981: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()-' );

4977:
4978: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
4979: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4980:
4981: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()-' );
4982:
4983: EXCEPTION
4984:
4985: WHEN OTHERS THEN

Line 4986: arp_message.set_error( 'ARP_CMERGE_ARCUS.delete_rows' );

4982:
4983: EXCEPTION
4984:
4985: WHEN OTHERS THEN
4986: arp_message.set_error( 'ARP_CMERGE_ARCUS.delete_rows' );
4987: RAISE;
4988:
4989: END delete_rows;
4990:

Line 5365: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()+' );

5361: l_error_text VARCHAR2(2000); --Bug 11824312
5362:
5363: BEGIN
5364:
5365: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()+' );
5366:
5367: OPEN sites_need_to_create;
5368: LOOP
5369: FETCH sites_need_to_create INTO

Line 6897: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()-' );

6893: CLOSE sites_need_to_create;
6894:
6895: status := 0;
6896:
6897: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()-' );
6898:
6899: EXCEPTION
6900:
6901: WHEN OTHERS THEN

Line 6902: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_same_sites' );

6898:
6899: EXCEPTION
6900:
6901: WHEN OTHERS THEN
6902: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_same_sites' );
6903: IF l_error_text IS NULL THEN
6904: error_text := substr(SQLERRM,1,2000);
6905: ELSE
6906: error_text := l_error_text;

Line 6947: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()+' );

6943:
6944:
6945: BEGIN
6946:
6947: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()+' );
6948:
6949: ---------Insert into HZ_CUST_ACCOUNTS_M--------------
6950: INSERT INTO HZ_CUST_ACCOUNTS_M(
6951: customer_merge_header_id,

Line 8308: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()-' );

8304:
8305: ---After storing the merge data sucessfully initialize the status to 0
8306: status := 0;
8307:
8308: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()-' );
8309:
8310: EXCEPTION
8311: WHEN NO_DATA_FOUND THEN
8312: NULL;

Line 8319: arp_message.set_error('ARP_CMERGE_ARCUS.Merge_History');

8315: arp_message.set_line('Index Violation: ' || SQLERRM );
8316:
8317:
8318: WHEN OTHERS THEN
8319: arp_message.set_error('ARP_CMERGE_ARCUS.Merge_History');
8320: status := -1;
8321:
8322:
8323: END merge_history;

Line 8388: END arp_cmerge_arcus;

8384: );
8385:
8386: END;
8387:
8388: END arp_cmerge_arcus;