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_MASTER dependencies on ARP_MESSAGE

Line 236: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()+' );

232: BEGIN
233:
234: -- execute immediate 'alter session disable commit in procedure'; bug 3897822
235:
236: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()+' );
237:
238:
239: g_excluded_apps := FND_PROFILE.VALUE('HZ_CMERGE_EXCLUDED_APPS');
240:

Line 247: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()-' );

243: END IF;
244:
245: IF g_excluded_apps = 'ALL' THEN
246: status := 0;
247: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()-' );
248: RETURN;
249: ELSE
250: g_excluded_apps := replace(g_excluded_apps,' ')||',';
251: END IF;

Line 432: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()-' );

428: 'ARP_GENERIC_CMERGE', 'merge',
429: req_id, set_num, process_mode,'GENERIC');
430:
431:
432: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_products()-' );
433:
434: -- execute immediate 'alter session enable commit in procedure'; bug 3897822
435:
436: EXCEPTION

Line 441: v_message_text := arp_message.get_last_few_messages(2);

437:
438: WHEN OTHERS THEN
439: begin
440: status := -1;
441: v_message_text := arp_message.get_last_few_messages(2);
442: error_text := G_PRODUCT_RAISING_EXCEPTION ||' '||v_message_text;
443: arp_message.set_line(v_message_text);
444: exception
445: when others then

Line 443: arp_message.set_line(v_message_text);

439: begin
440: status := -1;
441: v_message_text := arp_message.get_last_few_messages(2);
442: error_text := G_PRODUCT_RAISING_EXCEPTION ||' '||v_message_text;
443: arp_message.set_line(v_message_text);
444: exception
445: when others then
446: null;
447: end;

Line 576: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_product(' ||

572: IF instrb(g_excluded_apps,product_code||',') > 0 THEN
573: RETURN;
574: END IF;
575:
576: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_product(' ||
577: package_name || ')+' );
578:
579: BEGIN
580: c := dbms_sql.open_cursor;

Line 644: error_text := G_PRODUCT_RAISING_EXCEPTION || ' ' || arp_message.get_last_few_messages(2);

640: IF SQLCODE = -6550 THEN
641: dbms_sql.close_cursor(c);
642: ELSIF SQLCODE <> -6550 THEN
643: G_PRODUCT_RAISING_EXCEPTION := product_code||'.'|| package_name || '.' || api_name ;
644: error_text := G_PRODUCT_RAISING_EXCEPTION || ' ' || arp_message.get_last_few_messages(2);
645:
646: --raji
647:
648: BEGIN

Line 713: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_product(' || package_name || ')-' );

709: WHEN OTHERS THEN
710: -- G_PRODUCT_RAISING_EXCEPTION := product_code||'.'|| package_name || '.' || api_name ;
711: raise;
712:
713: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_product(' || package_name || ')-' );
714:
715: END merge_product;
716:
717: /*===========================================================================+

Line 778: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_crm_products()+' );

774: l_schema VARCHAR2(255);
775: l_tmp VARCHAR2(2000);
776: BEGIN
777:
778: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_crm_products()+' );
779:
780: --To minimize dependency, we need to call CRM's merge procedure
781: --dynanmically. First we need to check if table jtf_hooks_data
782: --exists, if yes, we need to see if there are crm's merge procedures

Line 834: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_crm_products()-' );

830: CLOSE crm_products;
831:
832: END IF;
833:
834: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_crm_products()-' );
835:
836: EXCEPTION
837:
838: WHEN OTHERS THEN

Line 839: arp_message.set_error( 'ARP_CMERGE_MASTER.merge_crm_products');

835:
836: EXCEPTION
837:
838: WHEN OTHERS THEN
839: arp_message.set_error( 'ARP_CMERGE_MASTER.merge_crm_products');
840:
841: IF crm_products%ISOPEN THEN
842: CLOSE crm_products;
843: END IF;

Line 885: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_customers()+' );

881: ) IS
882:
883: BEGIN
884:
885: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_customers()+' );
886:
887: --merge accout site uses, sites, account etc.
888: arp_cmerge_arcus.merge(req_id, set_num, process_mode);
889:

Line 895: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_customers()-' );

891: arp_cmerge_arcpf.merge(req_id, set_num, process_mode);
892:
893: status := 0;
894:
895: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_customers()-' );
896:
897: EXCEPTION
898:
899: WHEN OTHERS THEN

Line 900: arp_message.set_error( 'ARP_CMERGE_MASTER.merge_customers');

896:
897: EXCEPTION
898:
899: WHEN OTHERS THEN
900: arp_message.set_error( 'ARP_CMERGE_MASTER.merge_customers');
901: status := -1;
902:
903: END merge_customers;
904:

Line 940: arp_message.set_line( 'ARP_CMERGE_MASTER.delete_rows()+' );

936: ) IS
937:
938: BEGIN
939:
940: arp_message.set_line( 'ARP_CMERGE_MASTER.delete_rows()+' );
941:
942: --delete customer tables
943: arp_cmerge_arcus.delete_rows( req_id, set_num );
944:

Line 950: arp_message.set_line( 'ARP_CMERGE_MASTER.delete_rows()-' );

946: arp_cmerge_arcpf.delete_rows( req_id, set_num );
947:
948: status := 0;
949:
950: arp_message.set_line( 'ARP_CMERGE_MASTER.delete_rows()-' );
951:
952: EXCEPTION
953:
954: WHEN OTHERS THEN

Line 955: arp_message.set_error( 'ARP_CMERGE_MASTER.delete_rows');

951:
952: EXCEPTION
953:
954: WHEN OTHERS THEN
955: arp_message.set_error( 'ARP_CMERGE_MASTER.delete_rows');
956: status := -1;
957:
958: END delete_rows;
959:

Line 1033: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()+' );

1029: l_header_id_t customer_merge_header_id_tab;
1030: l_process_flag_t process_flag_tab;
1031: BEGIN
1032:
1033: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()+' );
1034:
1035: /* >>>MODIFY: need to pick up terminated rows as well */
1036:
1037: /** N/A

Line 1246: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()-' );

1242: WHERE mh.process_flag = l_new_process_flag
1243: AND request_id = req_id
1244: AND mh.priority = p_priority); --3897822
1245:
1246: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()-' );
1247:
1248: EXCEPTION
1249:
1250: WHEN OTHERS THEN

Line 1251: arp_message.set_error( 'ARP_CMERGE_MASTER.mark_merge_rows');

1247:
1248: EXCEPTION
1249:
1250: WHEN OTHERS THEN
1251: arp_message.set_error( 'ARP_CMERGE_MASTER.mark_merge_rows');
1252: RAISE;
1253:
1254: END mark_merge_rows;
1255:

Line 1289: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()+' );

1285: ) IS
1286:
1287: BEGIN
1288:
1289: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()+' );
1290:
1291: INSERT into ar_conc_process_requests
1292: (request_id, concurrent_program_name)
1293: VALUES

Line 1296: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()-' );

1292: (request_id, concurrent_program_name)
1293: VALUES
1294: (req_id, program_name);
1295:
1296: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()-' );
1297:
1298: EXCEPTION
1299:
1300: WHEN OTHERS THEN

Line 1301: arp_message.set_error( 'ARP_CMERGE_MASTER.add_request' );

1297:
1298: EXCEPTION
1299:
1300: WHEN OTHERS THEN
1301: arp_message.set_error( 'ARP_CMERGE_MASTER.add_request' );
1302: RAISE;
1303:
1304: END add_request;
1305:

Line 1445: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()+' );

1441: invalid_merges check_invalid_merges%ROWTYPE;
1442: error_msg VARCHAR2(240); -- Bug No: 3743818
1443: BEGIN
1444:
1445: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()+' );
1446:
1447: FOR missing_sites IN val_all_sites_merged LOOP
1448:
1449: --Mark Invalid Merges

Line 1467: arp_message.set_line('Duplicate Id : '|| missing_sites.duplicate_id ||' -- '||error_msg);

1463: AND process_flag = p_process_flag;
1464: ---Start of Bug No : 3743818
1465: fnd_message.set_name('AR', 'AR_CMERGE_MISSING_SITES');
1466: error_msg := fnd_message.get();
1467: arp_message.set_line('Duplicate Id : '|| missing_sites.duplicate_id ||' -- '||error_msg);
1468: --End Of Bug No: 3743818
1469:
1470: END LOOP;
1471:

Line 1493: arp_message.set_line( ' Duplicate Id : '||invalid_merges.duplicate_id ||' -- '||error_msg);

1489:
1490: ---Start of Bug No : 3743818
1491: fnd_message.set_name('AR', 'AR_CMERGE_DUPLICATE_SITE');
1492: error_msg := fnd_message.get();
1493: arp_message.set_line( ' Duplicate Id : '||invalid_merges.duplicate_id ||' -- '||error_msg);
1494: --End Of Bug No: 3743818
1495:
1496: END LOOP;
1497:

Line 1498: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()-' );

1494: --End Of Bug No: 3743818
1495:
1496: END LOOP;
1497:
1498: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()-' );
1499:
1500: EXCEPTION
1501:
1502: WHEN OTHERS THEN

Line 1503: arp_message.set_error( 'ARP_CMERGE_MASTER.validate_merges' );

1499:
1500: EXCEPTION
1501:
1502: WHEN OTHERS THEN
1503: arp_message.set_error( 'ARP_CMERGE_MASTER.validate_merges' );
1504: RAISE;
1505:
1506: END validate_merges;
1507:

Line 1556: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()+' );

1552: v_last_set NUMBER := 1;
1553:
1554: BEGIN
1555:
1556: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()+' );
1557:
1558: v_set_size := fnd_profile.value('AR_CMERGE_SET_SIZE');
1559:
1560: OPEN partition;

Line 1596: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );

1592:
1593: last_set := v_last_set;
1594:
1595:
1596: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );
1597:
1598: EXCEPTION
1599:
1600: WHEN OTHERS THEN

Line 1601: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );

1597:
1598: EXCEPTION
1599:
1600: WHEN OTHERS THEN
1601: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );
1602: RAISE;
1603:
1604: END partiton_merge_data;
1605:

Line 1659: arp_message.set_line( 'ARP_CMERGE_MASTER.unpartiton_merge_data()+' );

1655: l_count number;
1656:
1657: BEGIN
1658:
1659: arp_message.set_line( 'ARP_CMERGE_MASTER.unpartiton_merge_data()+' );
1660:
1661: v_set_size := 1001;
1662:
1663: OPEN partition;

Line 1711: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );

1707:
1708: last_set := v_last_set;
1709:
1710:
1711: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );
1712:
1713: EXCEPTION
1714:
1715: WHEN OTHERS THEN

Line 1716: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );

1712:
1713: EXCEPTION
1714:
1715: WHEN OTHERS THEN
1716: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );
1717: RAISE;
1718:
1719: END unpartiton_merge_data;
1720: /*===========================================================================+

Line 1759: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()+' );

1755: ) IS
1756:
1757: BEGIN
1758:
1759: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()+' );
1760:
1761: --delete customer alternative names
1762: arp_cmerge_master.delete_customer_alt_names ( req_id , set_num ) ;
1763:

Line 1814: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()-' );

1810:
1811: --Added for debug purpose, should be always commented out.
1812: --read_temporary_table;
1813:
1814: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()-' );
1815:
1816: EXCEPTION
1817:
1818: WHEN OTHERS THEN

Line 1819: arp_message.set_error( 'ARP_CMERGE_MASTER.done_merge_rows' );

1815:
1816: EXCEPTION
1817:
1818: WHEN OTHERS THEN
1819: arp_message.set_error( 'ARP_CMERGE_MASTER.done_merge_rows' );
1820: RAISE;
1821:
1822: END done_merge_rows;
1823:

Line 1866: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()+' );

1862: ) IS
1863:
1864: BEGIN
1865:
1866: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()+' );
1867:
1868: --If its database problem, set back status to 'SAVED'
1869: --Bug fix 2669389
1870: if (p_process_flag = 'SAVED') then

Line 1872: arp_message.set_line('in resetmerge flag is saved');

1868: --If its database problem, set back status to 'SAVED'
1869: --Bug fix 2669389
1870: if (p_process_flag = 'SAVED') then
1871:
1872: arp_message.set_line('in resetmerge flag is saved');
1873: UPDATE ra_customer_merges
1874: SET
1875: -- set_number = null,
1876: -- request_id = null,

Line 1977: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()-' );

1973: AND m.set_number = set_num );
1974:
1975: end if;
1976:
1977: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()-' );
1978:
1979: EXCEPTION
1980:
1981: WHEN OTHERS THEN

Line 1982: --arp_message.set_error( 'ARP_CMERGE_MASTER.reset_merge_rows' );

1978:
1979: EXCEPTION
1980:
1981: WHEN OTHERS THEN
1982: --arp_message.set_error( 'ARP_CMERGE_MASTER.reset_merge_rows' );
1983: RAISE;
1984:
1985: END reset_merge_rows;
1986:

Line 2024: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()+' );

2020: ) IS
2021:
2022: BEGIN
2023:
2024: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()+' );
2025:
2026: --Bug 1518688: should not reset request_id to NULL.
2027: --Set process_flag = 'FAILED' indicate this is a failed merge, we need
2028: --to pick it up next time.

Line 2075: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()-' );

2071: WHERE mh.request_id = req_id
2072: AND mh.process_flag = 'FAILED' )
2073: AND process_flag in ('ERROR 1', 'ERROR 2');
2074:
2075: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()-' );
2076:
2077: EXCEPTION
2078:
2079: WHEN OTHERS THEN

Line 2080: --arp_message.set_error( 'ARP_CMERGE_MASTER.clear_error_merge_rows' );

2076:
2077: EXCEPTION
2078:
2079: WHEN OTHERS THEN
2080: --arp_message.set_error( 'ARP_CMERGE_MASTER.clear_error_merge_rows' );
2081: RAISE;
2082:
2083: END clear_error_merge_rows;
2084:

Line 2116: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()+' );

2112: ) IS
2113:
2114: BEGIN
2115:
2116: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()+' );
2117:
2118: DELETE FROM ar_conc_process_requests
2119: WHERE request_id = req_id;
2120:

Line 2121: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()-' );

2117:
2118: DELETE FROM ar_conc_process_requests
2119: WHERE request_id = req_id;
2120:
2121: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()-' );
2122:
2123: EXCEPTION
2124:
2125: WHEN OTHERS THEN

Line 2126: --arp_message.set_error( 'ARP_CMERGE_MASTER.remove_request' );

2122:
2123: EXCEPTION
2124:
2125: WHEN OTHERS THEN
2126: --arp_message.set_error( 'ARP_CMERGE_MASTER.remove_request' );
2127: RAISE;
2128:
2129: END remove_request;
2130:

Line 2176: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()+' );

2172: ORDER BY duplicate_id ;
2173:
2174: BEGIN
2175:
2176: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()+' );
2177:
2178: -- Bug 2092530: Removed condition that checked the now-obsolete
2179: -- 'AR_ALT_NAME_SEARCH' profile option before executing the delete.
2180:

Line 2215: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()-' );

2211:
2212: END LOOP;
2213: CLOSE alt_names_deletion;
2214:
2215: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()-' );
2216:
2217: EXCEPTION
2218:
2219: WHEN OTHERS THEN

Line 2220: arp_message.set_error( 'ARP_CMERGE_MASTER.delete_customer_alt_names' );

2216:
2217: EXCEPTION
2218:
2219: WHEN OTHERS THEN
2220: arp_message.set_error( 'ARP_CMERGE_MASTER.delete_customer_alt_names' );
2221: RAISE;
2222:
2223: END delete_customer_alt_names;
2224:

Line 2256: arp_message.set_line('read temporary table');

2252: l_sql VARCHAR2(1000);
2253:
2254: BEGIN
2255:
2256: arp_message.set_line('read temporary table');
2257:
2258: l_sql :=
2259: 'DECLARE ' ||
2260: 'CURSOR c IS ' ||

Line 2267: 'arp_message.set_line( ''ORG CONTACT MAPPING : '' );' ||

2263: 'l_old_id NUMBER; ' ||
2264: 'l_new_id NUMBER; ' ||
2265: 'l_type VARCHAR2(30); ' ||
2266: 'BEGIN ' ||
2267: 'arp_message.set_line( ''ORG CONTACT MAPPING : '' );' ||
2268: 'OPEN c; ' ||
2269: 'LOOP ' ||
2270: 'FETCH c INTO l_type, l_old_id, l_new_id; ' ||
2271: 'EXIT WHEN c%NOTFOUND; ' ||

Line 2272: 'arp_message.set_line( ' ||

2268: 'OPEN c; ' ||
2269: 'LOOP ' ||
2270: 'FETCH c INTO l_type, l_old_id, l_new_id; ' ||
2271: 'EXIT WHEN c%NOTFOUND; ' ||
2272: 'arp_message.set_line( ' ||
2273: '''type = '' || l_type || '', '' || ' ||
2274: '''old = '' || to_char(l_old_id) || '', '' || ' ||
2275: '''new = '' || to_char(l_new_id) );' ||
2276: 'END LOOP;' ||

Line 2317: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );

2313: part_delete VARCHAR2 DEFAULT 'N') IS
2314:
2315: BEGIN
2316:
2317: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2318:
2319: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2320: UPDATE ra_customer_merges m
2321: SET delete_duplicate_flag = 'N'

Line 2367: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');

2363: )
2364: AND status = 'D'
2365: AND part_delete = 'N'; --5747129
2366:
2367: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2368:
2369:
2370: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake

Line 2392: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');

2388: )
2389: AND addr.status = 'D'
2390: AND part_delete = 'N'; --5747129
2391:
2392: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2393:
2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),

Line 2407: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCOUNTS');

2403: program_update_date = sysdate
2404: where acct.cust_account_id = from_customer_id
2405: and status ='D';
2406:
2407: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCOUNTS');
2408:
2409: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE cust_account_id */
2410: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2411: SET status = 'I',

Line 2430: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCT_RELATE for cust_account_id' );

2426: )
2427: AND status ='D'
2428: AND part_delete = 'N'; --5747129
2429:
2430: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCT_RELATE for cust_account_id' );
2431:
2432: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE
2433: --related_cust_account_id*/
2434: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake

Line 2454: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Rows updated in HZ_CUST_ACCT_RELATE for related_cust_account_id' );

2450: )
2451: AND status ='D'
2452: AND part_delete = 'N'; --5747129
2453:
2454: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Rows updated in HZ_CUST_ACCT_RELATE for related_cust_account_id' );
2455:
2456: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2457: *--not required at site level as all the site uses get merged for an acct
2458: *--delete is prevented by delete_duplicate_flag='N' */

Line 2484: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');

2480: FROM hz_cust_accounts acct
2481: WHERE acct.cust_account_id = yt.customer_id
2482: AND acct.status = 'A' );
2483:
2484: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2485:
2486: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2487: * ---acct and site level */
2488: UPDATE hz_customer_profiles yt

Line 2516: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');

2512: AND yt.cust_account_id = from_customer_id
2513: AND site_use_id is NULL ;
2514:
2515:
2516: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');
2517:
2518:
2519: /* ---Profile amts in ar_cpa are not getting Inactivated
2520: ---so delete duplicate flag in merge table can handle that */

Line 2533: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );

2529: AND m.process_flag = 'N'
2530: AND m.request_id = req_id
2531: AND m.set_number = set_num);
2532:
2533: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );
2534:
2535: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );
2536:
2537: END veto_delete;

Line 2535: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );

2531: AND m.set_number = set_num);
2532:
2533: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );
2534:
2535: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );
2536:
2537: END veto_delete;
2538:
2539: --4230396

Line 2550: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() +');

2546: FROM ra_customer_merge_headers
2547: WHERE request_id = p_req_id
2548: AND process_flag = 'Y';
2549: BEGIN
2550: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() +');
2551:
2552: OPEN merges;
2553: LOOP
2554: FETCH merges into l_header_id;

Line 2573: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() -');

2569: p_parameters => l_list );
2570: l_list.DELETE;
2571: END LOOP;
2572: CLOSE merges;
2573: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() -');
2574: EXCEPTION
2575: WHEN OTHERS THEN
2576: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );
2577: RAISE;

Line 2576: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );

2572: CLOSE merges;
2573: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() -');
2574: EXCEPTION
2575: WHEN OTHERS THEN
2576: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );
2577: RAISE;
2578: END raise_events;
2579:
2580: END ARP_CMERGE_MASTER;