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.39.12010000.2 2008/09/22 06:41:25 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 629: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()-' );

625:
626: end loop;
627: close c2;
628:
629: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_SU()-' );
630:
631: EXCEPTION
632:
633: WHEN OTHERS THEN

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

630:
631: EXCEPTION
632:
633: WHEN OTHERS THEN
634: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_SU' );
635: RAISE;
636:
637: END ra_su;
638:

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

738:
739:
740: BEGIN
741:
742: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()+' );
743:
744: /* locking tables by opening and closing cursors */
745: IF process_mode = 'LOCK' THEN
746:

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

978: end loop;
979: close c3;
980:
981:
982: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_ADDR()-' );
983:
984: EXCEPTION
985:
986: WHEN OTHERS THEN

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

983:
984: EXCEPTION
985:
986: WHEN OTHERS THEN
987: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_ADDR' );
988: RAISE;
989:
990: END ra_addr;
991:

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

1090:
1091:
1092: BEGIN
1093:
1094: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()+' );
1095:
1096: /* locking tables by opening and closing cursors */
1097: IF process_mode = 'LOCK' THEN
1098:

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

1214:
1215: end loop;
1216: close c3;
1217:
1218: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CUST()-' );
1219:
1220: EXCEPTION
1221:
1222: WHEN OTHERS THEN

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

1219:
1220: EXCEPTION
1221:
1222: WHEN OTHERS THEN
1223: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CUST' );
1224: RAISE;
1225:
1226: END ra_cust;
1227:

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

1361: --End of Bug No: 4527935
1362:
1363: BEGIN
1364:
1365: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()+' );
1366:
1367: /* locking tables by opening and closing cursors */
1368: IF process_mode = 'LOCK' THEN
1369:

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

1723: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1724:
1725: END IF;
1726:
1727: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CR()-' );
1728:
1729: EXCEPTION
1730:
1731: WHEN OTHERS THEN

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

1728:
1729: EXCEPTION
1730:
1731: WHEN OTHERS THEN
1732: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CR' );
1733: RAISE;
1734:
1735: END ra_cr;
1736:

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

1827: end_date end_date_tab;
1828: new_date date;
1829: BEGIN
1830:
1831: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()+' );
1832:
1833: /* locking tables by opening and closing cursors */
1834: IF process_mode = 'LOCK' THEN
1835:

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

2071: | arp_message.set_token( 'NUM_ROWS', to_char(g_count) ); */
2072:
2073: END IF;
2074:
2075: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CRM()-' );
2076:
2077: EXCEPTION
2078:
2079: WHEN OTHERS THEN

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

2076:
2077: EXCEPTION
2078:
2079: WHEN OTHERS THEN
2080: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CRM' );
2081: RAISE;
2082:
2083: END ra_crm;
2084:

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

2139: AND duplicate_id <> customer_id;
2140:
2141: BEGIN
2142:
2143: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()+' );
2144:
2145: OPEN accounts;
2146: LOOP
2147: FETCH accounts INTO from_account_id, to_account_id;

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

2148: EXIT WHEN accounts%NOTFOUND;
2149:
2150: /**
2151: arp_message.set_line(
2152: 'ARP_CMERGE_ARCUS:copy_contacts():from_account_id ' ||
2153: from_account_id );
2154: arp_message.set_line(
2155: 'ARP_CMERGE_ARCUS:copy_contacts():to_account_id ' ||
2156: to_account_id );

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

2151: arp_message.set_line(
2152: 'ARP_CMERGE_ARCUS:copy_contacts():from_account_id ' ||
2153: from_account_id );
2154: arp_message.set_line(
2155: 'ARP_CMERGE_ARCUS:copy_contacts():to_account_id ' ||
2156: to_account_id );
2157: **/
2158:
2159: SELECT party_id into from_party_id

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

2165: WHERE cust_account_id = to_account_id;
2166:
2167: /**
2168: arp_message.set_line(
2169: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_id '||
2170: from_party_id );
2171: arp_message.set_line(
2172: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_id '||
2173: to_party_id );

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

2168: arp_message.set_line(
2169: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_id '||
2170: from_party_id );
2171: arp_message.set_line(
2172: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_id '||
2173: to_party_id );
2174: **/
2175:
2176: --Based on customer merge high level design:

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

2181: IF to_party_id = from_party_id THEN
2182:
2183: /**
2184: arp_message.set_line (
2185: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||
2186: 'merge_from party and merge_to party are same. ' ||
2187: 'Do not need copy org contact and contact points in account level.' );
2188: **/
2189: NULL;

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

2209:
2210: END LOOP;
2211: CLOSE accounts;
2212:
2213: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts()-' );
2214:
2215: EXCEPTION
2216:
2217: WHEN OTHERS THEN

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

2214:
2215: EXCEPTION
2216:
2217: WHEN OTHERS THEN
2218: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts' );
2219: RAISE;
2220:
2221: END copy_contacts;
2222:

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

2275: AND duplicate_address_id <> -1; --4693912
2276:
2277: BEGIN
2278:
2279: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()+' );
2280:
2281: OPEN sites;
2282: LOOP
2283: FETCH sites INTO

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

2285: EXIT WHEN sites%NOTFOUND;
2286:
2287: /**
2288: arp_message.set_line(
2289: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():from_site_id ' ||
2290: from_site_id );
2291: arp_message.set_line(
2292: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():to_site_id ' ||
2293: to_site_id );

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

2288: arp_message.set_line(
2289: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():from_site_id ' ||
2290: from_site_id );
2291: arp_message.set_line(
2292: 'ARP_CMERGE_ARCUS:copy_contacts_in_sites():to_site_id ' ||
2293: to_site_id );
2294: **/
2295:
2296: SELECT party_site_id into from_party_site_id

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

2302: WHERE cust_acct_site_id = to_site_id;
2303:
2304: /**
2305: arp_message.set_line(
2306: 'ARP_CMERGE_ARCUS:copy_contacts():from_party_site_id '||
2307: from_party_site_id );
2308: arp_message.set_line(
2309: 'ARP_CMERGE_ARCUS:copy_contacts():to_party_site_id '||
2310: to_party_site_id );

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

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

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

2318: IF to_party_site_id = from_party_site_id THEN
2319:
2320: /**
2321: arp_message.set_line (
2322: 'ARP_CMERGE_ARCUS:copy_contacts(): ' ||
2323: 'merge_from party and merge_to party site are same. ' ||
2324: 'Do not need copy contact points.' );
2325: **/
2326:

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

2336:
2337: END LOOP;
2338: CLOSE sites;
2339:
2340: arp_message.set_line( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites()-' );
2341:
2342: EXCEPTION
2343:
2344: WHEN OTHERS THEN

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

2341:
2342: EXCEPTION
2343:
2344: WHEN OTHERS THEN
2345: arp_message.set_error( 'ARP_CMERGE_ARCUS.copy_contacts_in_sites' );
2346: RAISE;
2347:
2348: END copy_contacts_in_sites;
2349:

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

2419: ---Bug NO: 5067291
2420:
2421: BEGIN
2422:
2423: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()+' );
2424:
2425: /* locking tables by opening and closing cursors */
2426: IF process_mode = 'LOCK' then
2427:

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

2557: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2558: CLOSE c3;--5067291
2559: END IF;
2560:
2561: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_CONT()-' );
2562:
2563: EXCEPTION
2564:
2565: WHEN OTHERS THEN

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

2562:
2563: EXCEPTION
2564:
2565: WHEN OTHERS THEN
2566: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_CONT' );
2567: RAISE;
2568:
2569: END ra_cont;
2570:

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

2634: FOR UPDATE NOWAIT;
2635:
2636: BEGIN
2637:
2638: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()+' );
2639:
2640: /* locking tables by opening and closing cursors */
2641: IF process_mode = 'LOCK' THEN
2642:

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

2718: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2719:
2720: END IF;
2721:
2722: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_PH()-' );
2723:
2724: EXCEPTION
2725:
2726: WHEN OTHERS THEN

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

2723:
2724: EXCEPTION
2725:
2726: WHEN OTHERS THEN
2727: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_PH' );
2728: RAISE;
2729:
2730: END ra_ph;
2731:

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

2791:
2792:
2793: BEGIN
2794:
2795: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()+' );
2796:
2797: /* locking tables by opening and closing cursors */
2798: IF process_mode = 'LOCK' THEN
2799:

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

2963: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2964:
2965:
2966: END IF;
2967: arp_message.set_line( 'ARP_CMERGE_ARCUS.RA_USG()-' );
2968:
2969: EXCEPTION
2970:
2971: WHEN OTHERS THEN

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

2968:
2969: EXCEPTION
2970:
2971: WHEN OTHERS THEN
2972: arp_message.set_error( 'ARP_CMERGE_ARCUS.RA_USG' );
2973: RAISE;
2974: END ra_usg;
2975: --4307679
2976:

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

3072: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
3073:
3074: BEGIN
3075:
3076: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()+' );
3077:
3078: /* Copy org contact */
3079: OPEN c;
3080: LOOP

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

3104:
3105: END LOOP;
3106: CLOSE c;
3107:
3108: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts()-' );
3109:
3110: EXCEPTION
3111:
3112: WHEN OTHERS THEN

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

3109:
3110: EXCEPTION
3111:
3112: WHEN OTHERS THEN
3113: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_contacts' );
3114: RAISE;
3115:
3116: END do_cust_merge_contacts;
3117:

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

3245: AND set_number = p_set_num;
3246:
3247: BEGIN
3248:
3249: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()+' );
3250:
3251: /* For each site level org contact do the following */
3252: OPEN d;
3253: LOOP

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

3310:
3311: END LOOP;
3312: CLOSE d;
3313:
3314: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_contacts()-' );
3315:
3316: EXCEPTION
3317:
3318: WHEN OTHERS THEN

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

3315:
3316: EXCEPTION
3317:
3318: WHEN OTHERS THEN
3319: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_contacts' );
3320: RAISE;
3321:
3322: END do_site_merge_contacts;
3323:

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

3405: l_party_type varchar2(30);
3406: --End of Bug No: 4387523
3407: BEGIN
3408:
3409: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()+' );
3410:
3411: --check if the org contact has been migrated
3412: BEGIN
3413: l_sql := 'SELECT new_id ' ||

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

3600: p_org_party_id,
3601: x_org_party_id,
3602: p_from_account_id );
3603:
3604: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_merge_contacts()-' );
3605:
3606: EXCEPTION
3607:
3608: WHEN OTHERS THEN

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

3605:
3606: EXCEPTION
3607:
3608: WHEN OTHERS THEN
3609: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_merge_contacts' );
3610: RAISE;
3611:
3612: END do_merge_contacts;
3613:

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

3658: ) IS
3659:
3660: BEGIN
3661:
3662: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()+' );
3663:
3664: do_copy_contact_points ( 'HZ_PARTIES',
3665: p_from_party_id,
3666: p_to_party_id,

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

3665: p_from_party_id,
3666: p_to_party_id,
3667: p_from_account_id );
3668:
3669: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint()-' );
3670:
3671: EXCEPTION
3672:
3673: WHEN OTHERS THEN

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

3670:
3671: EXCEPTION
3672:
3673: WHEN OTHERS THEN
3674: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_cust_merge_cpoint' );
3675: RAISE;
3676:
3677: END do_cust_merge_cpoint;
3678:

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

3723: ) IS
3724:
3725: BEGIN
3726:
3727: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()+' );
3728:
3729: do_copy_contact_points ( 'HZ_PARTY_SITES',
3730: p_from_party_site_id,
3731: p_to_party_site_id,

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

3730: p_from_party_site_id,
3731: p_to_party_site_id,
3732: p_from_account_id );
3733:
3734: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()-' );
3735:
3736: EXCEPTION
3737:
3738: WHEN OTHERS THEN

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

3735:
3736: EXCEPTION
3737:
3738: WHEN OTHERS THEN
3739: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint' );
3740: RAISE;
3741:
3742: END do_site_merge_cpoint;
3743:

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

3820: l_dup_exists VARCHAR2(10) := fnd_api.g_false;
3821:
3822: BEGIN
3823:
3824: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points ()+' );
3825:
3826: OPEN c;
3827: LOOP
3828: FETCH c INTO l_contact_point_id;

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

3930: END IF;
3931:
3932: /**
3933: arp_message.set_line(
3934: 'ARP_CMERGE_ARCUS:do_copy_contact_points():old contact point id =' ||
3935: l_contact_point_id );
3936:
3937: arp_message.set_line(
3938: 'ARP_CMERGE_ARCUS.do_copy_contact_points:contact_point_id = ' ||

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

3934: 'ARP_CMERGE_ARCUS:do_copy_contact_points():old contact point id =' ||
3935: l_contact_point_id );
3936:
3937: arp_message.set_line(
3938: 'ARP_CMERGE_ARCUS.do_copy_contact_points:contact_point_id = ' ||
3939: x_contact_point_id );
3940: **/
3941:
3942: END IF;

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

3952: **/
3953: END LOOP;
3954: CLOSE c;
3955:
3956: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_copy_contact_points()-' );
3957:
3958: EXCEPTION
3959:
3960: WHEN OTHERS THEN

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

3957:
3958: EXCEPTION
3959:
3960: WHEN OTHERS THEN
3961: arp_message.set_error( 'ARP_CMERGE_ARCUS.do_copy_contact_points' );
3962: RAISE;
3963:
3964: END do_copy_contact_points;
3965:

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

4073:
4074: EXCEPTION
4075:
4076: WHEN OTHERS THEN
4077: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_org_contact_dup' );
4078: RAISE;
4079:
4080: END check_org_contact_dup;
4081:

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

4204: RETURN FND_API.G_TRUE;
4205:
4206: EXCEPTION
4207: WHEN OTHERS THEN
4208: arp_message.set_error( 'ARP_CMERGE_ARCUS.check_contact_point_dup' );
4209: RAISE;
4210:
4211: END check_contact_point_dup;
4212:

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

4242: l_sql VARCHAR2(1000);
4243:
4244: BEGIN
4245:
4246: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4247: g_table_name || ' )()+' );
4248:
4249: BEGIN
4250:

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

4274: END IF;
4275:
4276: EXECUTE IMMEDIATE l_sql;
4277:
4278: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4279: g_table_name || ' )()-' );
4280:
4281: EXCEPTION
4282:

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

4280:
4281: EXCEPTION
4282:
4283: WHEN OTHERS THEN
4284: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_temporary_table ( ' ||
4285: g_table_name || ' )' );
4286: RAISE;
4287:
4288: END create_temporary_table;

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

4420: AND m.delete_duplicate_flag = 'Y');
4421:
4422: BEGIN
4423:
4424: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()+' );
4425:
4426: /*****************************************************/
4427:
4428: --4307679

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

4667:
4668: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
4669: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4670:
4671: arp_message.set_line( 'ARP_CMERGE_ARCUS.delete_rows()-' );
4672:
4673: EXCEPTION
4674:
4675: WHEN OTHERS THEN

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

4672:
4673: EXCEPTION
4674:
4675: WHEN OTHERS THEN
4676: arp_message.set_error( 'ARP_CMERGE_ARCUS.delete_rows' );
4677: RAISE;
4678:
4679: END delete_rows;
4680:

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

5048: l_dun_exists VARCHAR2(1); --Added for Bug 6469732
5049:
5050: BEGIN
5051:
5052: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()+' );
5053:
5054: OPEN sites_need_to_create;
5055: LOOP
5056: FETCH sites_need_to_create INTO

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

6555: CLOSE sites_need_to_create;
6556:
6557: status := 0;
6558:
6559: arp_message.set_line( 'ARP_CMERGE_ARCUS.create_same_sites()-' );
6560:
6561: EXCEPTION
6562:
6563: WHEN OTHERS THEN

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

6560:
6561: EXCEPTION
6562:
6563: WHEN OTHERS THEN
6564: arp_message.set_error( 'ARP_CMERGE_ARCUS.create_same_sites' );
6565: status := -1;
6566:
6567: END create_same_sites;
6568:

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

6600:
6601:
6602: BEGIN
6603:
6604: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()+' );
6605:
6606: ---------Insert into HZ_CUST_ACCOUNTS_M--------------
6607: INSERT INTO HZ_CUST_ACCOUNTS_M(
6608: customer_merge_header_id,

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

7949:
7950: ---After storing the merge data sucessfully initialize the status to 0
7951: status := 0;
7952:
7953: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()-' );
7954:
7955: EXCEPTION
7956: WHEN NO_DATA_FOUND THEN
7957: NULL;

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

7960: arp_message.set_line('Index Violation: ' || SQLERRM );
7961:
7962:
7963: WHEN OTHERS THEN
7964: arp_message.set_error('ARP_CMERGE_ARCUS.Merge_History');
7965: status := -1;
7966:
7967:
7968: END merge_history;

Line 8033: END arp_cmerge_arcus;

8029: );
8030:
8031: END;
8032:
8033: END arp_cmerge_arcus;