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 1239: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()-' );

1235: WHERE mh.process_flag = l_new_process_flag
1236: AND request_id = req_id
1237: AND mh.priority = p_priority); --3897822
1238:
1239: arp_message.set_line( 'ARP_CMERGE_MASTER.mark_merge_rows()-' );
1240:
1241: EXCEPTION
1242:
1243: WHEN OTHERS THEN

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

1240:
1241: EXCEPTION
1242:
1243: WHEN OTHERS THEN
1244: arp_message.set_error( 'ARP_CMERGE_MASTER.mark_merge_rows');
1245: RAISE;
1246:
1247: END mark_merge_rows;
1248:

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

1278: ) IS
1279:
1280: BEGIN
1281:
1282: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()+' );
1283:
1284: INSERT into ar_conc_process_requests
1285: (request_id, concurrent_program_name)
1286: VALUES

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

1285: (request_id, concurrent_program_name)
1286: VALUES
1287: (req_id, program_name);
1288:
1289: arp_message.set_line( 'ARP_CMERGE_MASTER.add_request()-' );
1290:
1291: EXCEPTION
1292:
1293: WHEN OTHERS THEN

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

1290:
1291: EXCEPTION
1292:
1293: WHEN OTHERS THEN
1294: arp_message.set_error( 'ARP_CMERGE_MASTER.add_request' );
1295: RAISE;
1296:
1297: END add_request;
1298:

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

1434: invalid_merges check_invalid_merges%ROWTYPE;
1435: error_msg VARCHAR2(240); -- Bug No: 3743818
1436: BEGIN
1437:
1438: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()+' );
1439:
1440: FOR missing_sites IN val_all_sites_merged LOOP
1441:
1442: --Mark Invalid Merges

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

1456: AND process_flag = p_process_flag;
1457: ---Start of Bug No : 3743818
1458: fnd_message.set_name('AR', 'AR_CMERGE_MISSING_SITES');
1459: error_msg := fnd_message.get();
1460: arp_message.set_line('Duplicate Id : '|| missing_sites.duplicate_id ||' -- '||error_msg);
1461: --End Of Bug No: 3743818
1462:
1463: END LOOP;
1464:

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

1482:
1483: ---Start of Bug No : 3743818
1484: fnd_message.set_name('AR', 'AR_CMERGE_DUPLICATE_SITE');
1485: error_msg := fnd_message.get();
1486: arp_message.set_line( ' Duplicate Id : '||invalid_merges.duplicate_id ||' -- '||error_msg);
1487: --End Of Bug No: 3743818
1488:
1489: END LOOP;
1490:

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

1487: --End Of Bug No: 3743818
1488:
1489: END LOOP;
1490:
1491: arp_message.set_line( 'ARP_CMERGE_MASTER.validate_merges()-' );
1492:
1493: EXCEPTION
1494:
1495: WHEN OTHERS THEN

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

1492:
1493: EXCEPTION
1494:
1495: WHEN OTHERS THEN
1496: arp_message.set_error( 'ARP_CMERGE_MASTER.validate_merges' );
1497: RAISE;
1498:
1499: END validate_merges;
1500:

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

1545: v_last_set NUMBER := 1;
1546:
1547: BEGIN
1548:
1549: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()+' );
1550:
1551: v_set_size := fnd_profile.value('AR_CMERGE_SET_SIZE');
1552:
1553: OPEN partition;

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

1585:
1586: last_set := v_last_set;
1587:
1588:
1589: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );
1590:
1591: EXCEPTION
1592:
1593: WHEN OTHERS THEN

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

1590:
1591: EXCEPTION
1592:
1593: WHEN OTHERS THEN
1594: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );
1595: RAISE;
1596:
1597: END partiton_merge_data;
1598:

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

1648: l_count number;
1649:
1650: BEGIN
1651:
1652: arp_message.set_line( 'ARP_CMERGE_MASTER.unpartiton_merge_data()+' );
1653:
1654: v_set_size := 1001;
1655:
1656: OPEN partition;

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

1700:
1701: last_set := v_last_set;
1702:
1703:
1704: arp_message.set_line( 'ARP_CMERGE_MASTER.partiton_merge_data()-' );
1705:
1706: EXCEPTION
1707:
1708: WHEN OTHERS THEN

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

1705:
1706: EXCEPTION
1707:
1708: WHEN OTHERS THEN
1709: arp_message.set_error( 'ARP_CMERGE_MASTER.partition_merge_date' );
1710: RAISE;
1711:
1712: END unpartiton_merge_data;
1713: /*===========================================================================+

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

1748: ) IS
1749:
1750: BEGIN
1751:
1752: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()+' );
1753:
1754: --delete customer alternative names
1755: arp_cmerge_master.delete_customer_alt_names ( req_id , set_num ) ;
1756:

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

1803:
1804: --Added for debug purpose, should be always commented out.
1805: --read_temporary_table;
1806:
1807: arp_message.set_line( 'ARP_CMERGE_MASTER.done_merge_rows()-' );
1808:
1809: EXCEPTION
1810:
1811: WHEN OTHERS THEN

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

1808:
1809: EXCEPTION
1810:
1811: WHEN OTHERS THEN
1812: arp_message.set_error( 'ARP_CMERGE_MASTER.done_merge_rows' );
1813: RAISE;
1814:
1815: END done_merge_rows;
1816:

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

1855: ) IS
1856:
1857: BEGIN
1858:
1859: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()+' );
1860:
1861: --If its database problem, set back status to 'SAVED'
1862: --Bug fix 2669389
1863: if (p_process_flag = 'SAVED') then

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

1861: --If its database problem, set back status to 'SAVED'
1862: --Bug fix 2669389
1863: if (p_process_flag = 'SAVED') then
1864:
1865: arp_message.set_line('in resetmerge flag is saved');
1866: UPDATE ra_customer_merges
1867: SET
1868: -- set_number = null,
1869: -- request_id = null,

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

1966: AND m.set_number = set_num );
1967:
1968: end if;
1969:
1970: --arp_message.set_line( 'ARP_CMERGE_MASTER.reset_merge_rows()-' );
1971:
1972: EXCEPTION
1973:
1974: WHEN OTHERS THEN

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

1971:
1972: EXCEPTION
1973:
1974: WHEN OTHERS THEN
1975: --arp_message.set_error( 'ARP_CMERGE_MASTER.reset_merge_rows' );
1976: RAISE;
1977:
1978: END reset_merge_rows;
1979:

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

2013: ) IS
2014:
2015: BEGIN
2016:
2017: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()+' );
2018:
2019: --Bug 1518688: should not reset request_id to NULL.
2020: --Set process_flag = 'FAILED' indicate this is a failed merge, we need
2021: --to pick it up next time.

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

2064: WHERE mh.request_id = req_id
2065: AND mh.process_flag = 'FAILED' )
2066: AND process_flag in ('ERROR 1', 'ERROR 2');
2067:
2068: --arp_message.set_line( 'ARP_CMERGE_MASTER.clear_error_merge_rows()-' );
2069:
2070: EXCEPTION
2071:
2072: WHEN OTHERS THEN

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

2069:
2070: EXCEPTION
2071:
2072: WHEN OTHERS THEN
2073: --arp_message.set_error( 'ARP_CMERGE_MASTER.clear_error_merge_rows' );
2074: RAISE;
2075:
2076: END clear_error_merge_rows;
2077:

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

2105: ) IS
2106:
2107: BEGIN
2108:
2109: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()+' );
2110:
2111: DELETE FROM ar_conc_process_requests
2112: WHERE request_id = req_id;
2113:

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

2110:
2111: DELETE FROM ar_conc_process_requests
2112: WHERE request_id = req_id;
2113:
2114: --arp_message.set_line( 'ARP_CMERGE_MASTER.remove_request()-' );
2115:
2116: EXCEPTION
2117:
2118: WHEN OTHERS THEN

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

2115:
2116: EXCEPTION
2117:
2118: WHEN OTHERS THEN
2119: --arp_message.set_error( 'ARP_CMERGE_MASTER.remove_request' );
2120: RAISE;
2121:
2122: END remove_request;
2123:

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

2165: ORDER BY duplicate_id ;
2166:
2167: BEGIN
2168:
2169: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()+' );
2170:
2171: -- Bug 2092530: Removed condition that checked the now-obsolete
2172: -- 'AR_ALT_NAME_SEARCH' profile option before executing the delete.
2173:

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

2204:
2205: END LOOP;
2206: CLOSE alt_names_deletion;
2207:
2208: arp_message.set_line( 'ARP_CMERGE_MASTER.alt_name_deletion()-' );
2209:
2210: EXCEPTION
2211:
2212: WHEN OTHERS THEN

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

2209:
2210: EXCEPTION
2211:
2212: WHEN OTHERS THEN
2213: arp_message.set_error( 'ARP_CMERGE_MASTER.delete_customer_alt_names' );
2214: RAISE;
2215:
2216: END delete_customer_alt_names;
2217:

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

2245: l_sql VARCHAR2(1000);
2246:
2247: BEGIN
2248:
2249: arp_message.set_line('read temporary table');
2250:
2251: l_sql :=
2252: 'DECLARE ' ||
2253: 'CURSOR c IS ' ||

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

2256: 'l_old_id NUMBER; ' ||
2257: 'l_new_id NUMBER; ' ||
2258: 'l_type VARCHAR2(30); ' ||
2259: 'BEGIN ' ||
2260: 'arp_message.set_line( ''ORG CONTACT MAPPING : '' );' ||
2261: 'OPEN c; ' ||
2262: 'LOOP ' ||
2263: 'FETCH c INTO l_type, l_old_id, l_new_id; ' ||
2264: 'EXIT WHEN c%NOTFOUND; ' ||

Line 2265: 'arp_message.set_line( ' ||

2261: 'OPEN c; ' ||
2262: 'LOOP ' ||
2263: 'FETCH c INTO l_type, l_old_id, l_new_id; ' ||
2264: 'EXIT WHEN c%NOTFOUND; ' ||
2265: 'arp_message.set_line( ' ||
2266: '''type = '' || l_type || '', '' || ' ||
2267: '''old = '' || to_char(l_old_id) || '', '' || ' ||
2268: '''new = '' || to_char(l_new_id) );' ||
2269: 'END LOOP;' ||

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

2306: part_delete VARCHAR2 DEFAULT 'N') IS
2307:
2308: BEGIN
2309:
2310: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2311:
2312: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2313: UPDATE ra_customer_merges m
2314: SET delete_duplicate_flag = 'N'

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

2356: )
2357: AND status = 'D'
2358: AND part_delete = 'N'; --5747129
2359:
2360: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2361:
2362:
2363: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake

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

2381: )
2382: AND addr.status = 'D'
2383: AND part_delete = 'N'; --5747129
2384:
2385: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2386:
2387: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2388: UPDATE HZ_CUST_ACCOUNTS acct
2389: set status = decode(part_delete,'N','I','A'),

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

2396: program_update_date = sysdate
2397: where acct.cust_account_id = from_customer_id
2398: and status ='D';
2399:
2400: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCOUNTS');
2401:
2402: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE cust_account_id */
2403: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2404: SET status = 'I',

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

2419: )
2420: AND status ='D'
2421: AND part_delete = 'N'; --5747129
2422:
2423: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCT_RELATE for cust_account_id' );
2424:
2425: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE
2426: --related_cust_account_id*/
2427: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake

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

2443: )
2444: AND status ='D'
2445: AND part_delete = 'N'; --5747129
2446:
2447: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Rows updated in HZ_CUST_ACCT_RELATE for related_cust_account_id' );
2448:
2449: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2450: *--not required at site level as all the site uses get merged for an acct
2451: *--delete is prevented by delete_duplicate_flag='N' */

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

2473: FROM hz_cust_accounts acct
2474: WHERE acct.cust_account_id = yt.customer_id
2475: AND acct.status = 'A' );
2476:
2477: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2478:
2479: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2480: * ---acct and site level */
2481: UPDATE hz_customer_profiles yt

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

2505: AND yt.cust_account_id = from_customer_id
2506: AND site_use_id is NULL ;
2507:
2508:
2509: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');
2510:
2511:
2512: /* ---Profile amts in ar_cpa are not getting Inactivated
2513: ---so delete duplicate flag in merge table can handle that */

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

2522: AND m.process_flag = 'N'
2523: AND m.request_id = req_id
2524: AND m.set_number = set_num);
2525:
2526: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );
2527:
2528: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );
2529:
2530: END veto_delete;

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

2524: AND m.set_number = set_num);
2525:
2526: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );
2527:
2528: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );
2529:
2530: END veto_delete;
2531:
2532: --4230396

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

2539: FROM ra_customer_merge_headers
2540: WHERE request_id = p_req_id
2541: AND process_flag = 'Y';
2542: BEGIN
2543: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() +');
2544:
2545: OPEN merges;
2546: LOOP
2547: FETCH merges into l_header_id;

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

2562: p_parameters => l_list );
2563: l_list.DELETE;
2564: END LOOP;
2565: CLOSE merges;
2566: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() -');
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );
2570: RAISE;

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

2565: CLOSE merges;
2566: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() -');
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: arp_message.set_error( 'ARP_CMERGE_MASTER.raise_events' );
2570: RAISE;
2571: END raise_events;
2572:
2573: END ARP_CMERGE_MASTER;