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.ARW_SEARCH_CUSTOMERS dependencies on ARP_STANDARD

Line 402: arp_standard.debug('l_search_string : '||l_search_string);

398: l_search_string := l_search_string || ' @@'; -- identifies final token --
399: l_search_string := replace(l_search_string,'*','%'); -- translate wildcard symbols --
400:
401: IF (PG_DEBUG = 'Y') THEN
402: arp_standard.debug('l_search_string : '||l_search_string);
403: END IF;
404: -----------------------------
405: -- Parse the search string --
406: -----------------------------

Line 448: arp_standard.debug('l_new_search_string: '||l_new_search_string);

444:
445: END LOOP;
446:
447: IF (PG_DEBUG = 'Y') THEN
448: arp_standard.debug('l_new_search_string: '||l_new_search_string);
449: END IF;
450:
451: RETURN ltrim(l_new_search_string,' ');
452:

Line 723: arp_standard.debug(l_debug_info);

719: l_debug_info := 'Delete all entries from the table for the current session';
720: --------------------------------------------------------------------------
721:
722: IF (PG_DEBUG = 'Y') THEN
723: arp_standard.debug(l_debug_info);
724: END IF;
725:
726: -- Delete all entries from the table for the current session
727: delete from ar_cust_search_gt;

Line 742: arp_standard.debug(l_debug_info);

738: --------------------------------------------------------------------------
739: l_debug_info := 'Call to the search customer by name and number function';
740: --------------------------------------------------------------------------
741: IF (PG_DEBUG = 'Y') THEN
742: arp_standard.debug(l_debug_info);
743: END IF;
744:
745: if i_name_num = 'YES' then
746:

Line 757: arp_standard.debug(l_debug_info);

753: --------------------------------------------------------------------------
754: l_debug_info := 'Call the search customer function';
755: --------------------------------------------------------------------------
756: IF (PG_DEBUG = 'Y') THEN
757: arp_standard.debug(l_debug_info);
758: END IF;
759: -- Call the search customer function
760: -- Use search_customers_by_trx if search string prefaced by '#'
761: /* */

Line 780: arp_standard.debug(l_debug_info);

776: --------------------------------------------------------------------------
777: l_debug_info := 'Insert returned rows into the global temporary table';
778: --------------------------------------------------------------------------
779: IF (PG_DEBUG = 'Y') THEN
780: arp_standard.debug(l_debug_info);
781: END IF;
782:
783: if i_exclude_contact <> 'YES' then -- added for bug 10265497
784:

Line 786: arp_standard.debug('Just before For Loop getting Customer Contacts ');

782:
783: if i_exclude_contact <> 'YES' then -- added for bug 10265497
784:
785: IF (PG_DEBUG = 'Y') THEN
786: arp_standard.debug('Just before For Loop getting Customer Contacts ');
787: END IF;
788:
789: --Fetch the Contact and get the contact name and phone and update for each bill to
790: l_tab_idx := l_search_result_table.FIRST;

Line 805: arp_standard.debug('After For Loop getting Customer Contacts ');

801:
802: END LOOP;
803:
804: IF (PG_DEBUG = 'Y') THEN
805: arp_standard.debug('After For Loop getting Customer Contacts ');
806: END IF;
807:
808: end if; -- end if condition added for bug 10265497
809:

Line 859: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');

855: BEGIN
856: x_msg_data := SQLERRM;
857: x_msg_count := x_msg_count + 1;
858: IF (PG_DEBUG = 'Y') THEN
859: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
860: arp_standard.debug('- Search Key: '||i_keyword );
861: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
862: arp_standard.debug(SQLERRM);
863: END IF;

Line 860: arp_standard.debug('- Search Key: '||i_keyword );

856: x_msg_data := SQLERRM;
857: x_msg_count := x_msg_count + 1;
858: IF (PG_DEBUG = 'Y') THEN
859: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
860: arp_standard.debug('- Search Key: '||i_keyword );
861: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
862: arp_standard.debug(SQLERRM);
863: END IF;
864: END;

Line 861: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));

857: x_msg_count := x_msg_count + 1;
858: IF (PG_DEBUG = 'Y') THEN
859: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
860: arp_standard.debug('- Search Key: '||i_keyword );
861: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
862: arp_standard.debug(SQLERRM);
863: END IF;
864: END;
865:

Line 862: arp_standard.debug(SQLERRM);

858: IF (PG_DEBUG = 'Y') THEN
859: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
860: arp_standard.debug('- Search Key: '||i_keyword );
861: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
862: arp_standard.debug(SQLERRM);
863: END IF;
864: END;
865:
866: END;

Line 896: arp_standard.debug('Unexpected Exception in ARI_SEARCH');

892: x_msg_count := x_msg_count + 1;
893: END IF;
894:
895: IF (PG_DEBUG = 'Y') THEN
896: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
897: arp_standard.debug('- Search Key: '||i_keyword );
898: arp_standard.debug(SQLERRM);
899: END IF;
900:

Line 897: arp_standard.debug('- Search Key: '||i_keyword );

893: END IF;
894:
895: IF (PG_DEBUG = 'Y') THEN
896: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
897: arp_standard.debug('- Search Key: '||i_keyword );
898: arp_standard.debug(SQLERRM);
899: END IF;
900:
901: END ari_search;

Line 898: arp_standard.debug(SQLERRM);

894:
895: IF (PG_DEBUG = 'Y') THEN
896: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
897: arp_standard.debug('- Search Key: '||i_keyword );
898: arp_standard.debug(SQLERRM);
899: END IF;
900:
901: END ari_search;
902: