APPS.ARW_SEARCH_CUSTOMERS dependencies on STANDARD

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

289: l_search_string := l_search_string || ' @@'; -- identifies final token --
290: l_search_string := replace(l_search_string,'*','%'); -- translate wildcard symbols --
291:
292: IF (PG_DEBUG = 'Y') THEN
293: arp_standard.debug('l_search_string : '||l_search_string);
294: END IF;
295: -----------------------------
296: -- Parse the search string --
297: -----------------------------

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

335:
336: END LOOP;
337:
338: IF (PG_DEBUG = 'Y') THEN
339: arp_standard.debug('l_new_search_string: '||l_new_search_string);
340: END IF;
341:
342: RETURN ltrim(l_new_search_string,' ');
343:

Line 609: arp_standard.debug(l_debug_info);

605: l_debug_info := 'Delete all entries from the table for the current session';
606: --------------------------------------------------------------------------
607:
608: IF (PG_DEBUG = 'Y') THEN
609: arp_standard.debug(l_debug_info);
610: END IF;
611:
612: -- Delete all entries from the table for the current session
613: delete from ar_cust_search_gt;

Line 623: arp_standard.debug(l_debug_info);

619: --------------------------------------------------------------------------
620: l_debug_info := 'Call to the search customer by name and number function';
621: --------------------------------------------------------------------------
622: IF (PG_DEBUG = 'Y') THEN
623: arp_standard.debug(l_debug_info);
624: END IF;
625:
626: if i_name_num = 'YES' then
627:

Line 637: arp_standard.debug(l_debug_info);

633: --------------------------------------------------------------------------
634: l_debug_info := 'Call the search customer function';
635: --------------------------------------------------------------------------
636: IF (PG_DEBUG = 'Y') THEN
637: arp_standard.debug(l_debug_info);
638: END IF;
639: -- Call the search customer function
640: -- Use search_customers_by_trx if search string prefaced by '#'
641: /* */

Line 674: arp_standard.debug(l_debug_info);

670: --------------------------------------------------------------------------
671: l_debug_info := 'Insert returned rows into the global temporary table';
672: --------------------------------------------------------------------------
673: IF (PG_DEBUG = 'Y') THEN
674: arp_standard.debug(l_debug_info);
675: END IF;
676:
677: l_tab_idx := l_search_result_table.FIRST;
678:

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

720: BEGIN
721: x_msg_data := SQLERRM;
722: x_msg_count := x_msg_count + 1;
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
725: arp_standard.debug('- Search Key: '||i_keyword );
726: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
727: arp_standard.debug(SQLERRM);
728: END IF;

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

721: x_msg_data := SQLERRM;
722: x_msg_count := x_msg_count + 1;
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
725: arp_standard.debug('- Search Key: '||i_keyword );
726: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
727: arp_standard.debug(SQLERRM);
728: END IF;
729: END;

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

722: x_msg_count := x_msg_count + 1;
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
725: arp_standard.debug('- Search Key: '||i_keyword );
726: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
727: arp_standard.debug(SQLERRM);
728: END IF;
729: END;
730:

Line 727: arp_standard.debug(SQLERRM);

723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ari_search: Loop and Insert');
725: arp_standard.debug('- Search Key: '||i_keyword );
726: arp_standard.debug('- Current Index: '||to_char(l_tab_idx));
727: arp_standard.debug(SQLERRM);
728: END IF;
729: END;
730:
731: END;

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

757: x_msg_count := x_msg_count + 1;
758: END IF;
759:
760: IF (PG_DEBUG = 'Y') THEN
761: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
762: arp_standard.debug('- Search Key: '||i_keyword );
763: arp_standard.debug(SQLERRM);
764: END IF;
765:

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

758: END IF;
759:
760: IF (PG_DEBUG = 'Y') THEN
761: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
762: arp_standard.debug('- Search Key: '||i_keyword );
763: arp_standard.debug(SQLERRM);
764: END IF;
765:
766: END ari_search;

Line 763: arp_standard.debug(SQLERRM);

759:
760: IF (PG_DEBUG = 'Y') THEN
761: arp_standard.debug('Unexpected Exception in ARI_SEARCH');
762: arp_standard.debug('- Search Key: '||i_keyword );
763: arp_standard.debug(SQLERRM);
764: END IF;
765:
766: END ari_search;
767: