DBA Data[Home] [Help]

APPS.ARP_STANDARD dependencies on ARP_UTIL

Line 399: | arp_standard.debug('arp_util_pkg.get_value()+', --> msg text

395: | FND_LOG routines to record the messages in the FND_LOG_MESSAGES table.
396: |
397: | The current version of the debug procedure works like this:
398: |
399: | arp_standard.debug('arp_util_pkg.get_value()+', --> msg text
400: | 'plsql', --> prefix (source)
401: | 'arp_util_pkg.get_value.begin', --> package name
402: | FND_LOG_LEVEL.PROCEDURE); --> FND constant
403: |

Line 401: | 'arp_util_pkg.get_value.begin', --> package name

397: | The current version of the debug procedure works like this:
398: |
399: | arp_standard.debug('arp_util_pkg.get_value()+', --> msg text
400: | 'plsql', --> prefix (source)
401: | 'arp_util_pkg.get_value.begin', --> package name
402: | FND_LOG_LEVEL.PROCEDURE); --> FND constant
403: |
404: | Now, in reality, only the first parameter is required and the others
405: | will be defaulted or determined based on content of the message.

Line 407: | arp_standard.debug('arp_util_pkg.get_value()+');

403: |
404: | Now, in reality, only the first parameter is required and the others
405: | will be defaulted or determined based on content of the message.
406: |
407: | arp_standard.debug('arp_util_pkg.get_value()+');
408: |
409: | Both of the above examples will log the following message:
410: |
411: | module := ar.plsql.arp_util_pkg.get_value.begin

Line 411: | module := ar.plsql.arp_util_pkg.get_value.begin

407: | arp_standard.debug('arp_util_pkg.get_value()+');
408: |
409: | Both of the above examples will log the following message:
410: |
411: | module := ar.plsql.arp_util_pkg.get_value.begin
412: | level := 2 (this equates to FND_LOG.LEVEL_PROCEDURE)
413: | text := 'arp_util_pkg.get_value()+'
414: |
415: | Several rules you should keep in mind...

Line 413: | text := 'arp_util_pkg.get_value()+'

409: | Both of the above examples will log the following message:
410: |
411: | module := ar.plsql.arp_util_pkg.get_value.begin
412: | level := 2 (this equates to FND_LOG.LEVEL_PROCEDURE)
413: | text := 'arp_util_pkg.get_value()+'
414: |
415: | Several rules you should keep in mind...
416: | (1) I never manipulate the message text (looks just like it did before)
417: | (2) I default the source as 'plsql' in most cases.

Line 441: | 'arp_util.get_gl_date');

437: |
438: | Detail messages in plsql:
439: | arp_standard.debug('request_id = ' || l_request_id,
440: | 'plsql',
441: | 'arp_util.get_gl_date');
442: |
443: | Specific exception/error logging:
444: | arp_standard.debug('ERROR: Processed has failed',
445: | 'plsql',

Line 2005: arp_util.debug('Candidate GL DATE = '||to_char(candidate_gl_date,'dd/mm/yyyy'));

2001: and adjustment_period_flag = 'N'
2002: and closing_status = 'O'
2003: and start_date < l_trx_date;
2004:
2005: arp_util.debug('Candidate GL DATE = '||to_char(candidate_gl_date,'dd/mm/yyyy'));
2006: if ( candidate_gl_date is not null )
2007: then
2008: if is_gl_date_valid(candidate_gl_date,
2009: l_trx_date,

Line 2023: arp_util.debug('NOT VALID');

2019: 'LAST DATE OF THE PREVIOUS OPEN PERIOD';
2020: return(TRUE);
2021: else
2022:
2023: arp_util.debug('NOT VALID');
2024: end if;
2025: end if;
2026:
2027: /* Try first Open period after trx_date */

Line 2099: arp_util.debug('Candidate gl_date = '|| to_char(candidate_gl_date,'dd-mon-yyyy'));

2095: and set_of_books_id = h_set_of_books_id
2096: and adjustment_period_flag = 'N'
2097: and closing_status = 'O'
2098: and start_date < sysdate;
2099: arp_util.debug('Candidate gl_date = '|| to_char(candidate_gl_date,'dd-mon-yyyy'));
2100: arp_util.debug('l_ gl_date = '|| to_char(l_gl_date,'dd-mon-yyyy'));
2101:
2102: if ( candidate_gl_date is not null )
2103: then

Line 2100: arp_util.debug('l_ gl_date = '|| to_char(l_gl_date,'dd-mon-yyyy'));

2096: and adjustment_period_flag = 'N'
2097: and closing_status = 'O'
2098: and start_date < sysdate;
2099: arp_util.debug('Candidate gl_date = '|| to_char(candidate_gl_date,'dd-mon-yyyy'));
2100: arp_util.debug('l_ gl_date = '|| to_char(l_gl_date,'dd-mon-yyyy'));
2101:
2102: if ( candidate_gl_date is not null )
2103: then
2104: if is_gl_date_valid(candidate_gl_date,

Line 2298: IF (arp_util.validate_and_default_gl_date(

2294: l_default_gl_date DATE;
2295: l_defaulting_rule_used VARCHAR2(50);
2296: l_error_message VARCHAR2(100);
2297: BEGIN
2298: IF (arp_util.validate_and_default_gl_date(
2299: sysdate,
2300: NULL,
2301: NULL,
2302: NULL,

Line 2512: arp_util.debug( 'arp_process_tax.find_previous_trx_line_id()+' );

2508: l_dummy VARCHAR2(16);
2509:
2510: BEGIN
2511: IF PG_DEBUG in ('Y', 'C') THEN
2512: arp_util.debug( 'arp_process_tax.find_previous_trx_line_id()+' );
2513: END IF;
2514: OPEN c_find_prev_trx_line_id( p_customer_trx_line_id, p_tax_line_number, p_vat_tax_id );
2515: FETCH c_find_prev_trx_line_id into l_tax_customer_trx_line_id, l_tax_customer_trx_id;
2516:

Line 2554: arp_util.debug( 'arp_standard.find_previous_trx_line_id( ' ||

2550: END IF;
2551: CLOSE c_find_prev_trx_line_id;
2552:
2553: IF PG_DEBUG in ('Y', 'C') THEN
2554: arp_util.debug( 'arp_standard.find_previous_trx_line_id( ' ||
2555: to_char(l_tax_customer_trx_id ) || ', ' || to_char( l_tax_customer_trx_line_id ) || ' )-' );
2556: END IF;
2557:
2558: p_tax_customer_trx_line_id := l_tax_customer_trx_line_id ;

Line 2567: arp_util.debug( 'EXCEPTION: arp_standard.find_previous_trx_line_id( ' ||

2563: EXCEPTION
2564: WHEN OTHERS
2565: THEN
2566: IF PG_DEBUG in ('Y', 'C') THEN
2567: arp_util.debug( 'EXCEPTION: arp_standard.find_previous_trx_line_id( ' ||
2568: to_char( p_customer_trx_line_id ) || ' )' );
2569: END IF;
2570:
2571: IF c_find_prev_trx_line_id%ISOPEN