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_CMERGE_MASTER

Line 1: PACKAGE BODY ARP_CMERGE_MASTER as

1: PACKAGE BODY ARP_CMERGE_MASTER as
2: /* $Header: ARHCMSTB.pls 120.34 2011/10/05 12:25:55 vsegu ship $ */
3:
4: --Global variable to catch the name of product raising exception
5: G_PRODUCT_RAISING_EXCEPTION varchar2(255) ;

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 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 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 804: 'WHERE package_name = ''ARP_CMERGE_MASTER'' ' ||

800: IF l_exist = 'Y' THEN
801:
802: cur_sql := 'SELECT hook_package, hook_api,product_code ' ||
803: 'FROM jtf_hooks_data '||
804: 'WHERE package_name = ''ARP_CMERGE_MASTER'' ' ||
805: 'AND api_name = ''MERGE_PRODUCTS'' ' ||
806: 'AND execute_flag = ''Y'' ' ||
807: 'ORDER BY execution_order ';
808:

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 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 1762: arp_cmerge_master.delete_customer_alt_names ( req_id , set_num ) ;

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:
1764: UPDATE ra_customer_merges
1765: SET process_flag = 'Y',
1766: last_update_date = sysdate,

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 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 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 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;

Line 2580: END ARP_CMERGE_MASTER;

2576: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );
2577: RAISE;
2578: END raise_events;
2579:
2580: END ARP_CMERGE_MASTER;