DBA Data[Home] [Help]

APPS.ARP_DATES dependencies on ARP_DATES

Line 1: PACKAGE BODY ARP_DATES AS

1: PACKAGE BODY ARP_DATES AS
2: /* $Header: ARTUDATB.pls 120.6.12000000.3 2007/09/01 09:05:28 naneja ship $ */
3:
4:
5: pg_ai_pds_exist_cursor integer;

Line 75: arp_util.print_fcn_label('arp_dates.prepare_val_gl_pds_sql_stmt()+ ');

71: l_overlapping_pds_cursor integer;
72:
73: BEGIN
74:
75: arp_util.print_fcn_label('arp_dates.prepare_val_gl_pds_sql_stmt()+ ');
76:
77: arp_util.debug('p_ai_flag = ' ||
78: arp_trx_util.boolean_to_varchar2(p_ai_flag) ,
79: arp_global.MSG_LEVEL_DEBUG);

Line 100: arp_util.print_fcn_label('arp_dates.construct_val_gl_pds_sql_stmt()- ');

96: )
97: THEN
98: arp_util.debug('No SQL statement constuction or parse is required',
99: arp_global.MSG_LEVEL_DEBUG);
100: arp_util.print_fcn_label('arp_dates.construct_val_gl_pds_sql_stmt()- ');
101: RETURN;
102:
103: END IF;
104:

Line 375: arp_util.print_fcn_label('arp_dates.prepare_val_gl_pds_sql_stmt()- ');

371: pg_form_pds_exist_cursor := l_all_pds_exist_cursor;
372: pg_form_overlapping_pds_cursor := l_overlapping_pds_cursor;
373: END IF;
374:
375: arp_util.print_fcn_label('arp_dates.prepare_val_gl_pds_sql_stmt()- ');
376:
377:
378: EXCEPTION
379: WHEN OTHERS THEN

Line 386: 'EXCEPTION: arp_dates.prepare_val_gl_pds_sql_stmt()');

382: | Display parameters and raise the exception |
383: +---------------------------------------------*/
384:
385: arp_util.debug(
386: 'EXCEPTION: arp_dates.prepare_val_gl_pds_sql_stmt()');
387:
388: arp_util.debug('');
389: arp_util.debug('---- parameters for prepare_val_gl_pds_sql_stmt() -----');
390: arp_util.debug('p_ai_flag = ' ||

Line 450: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()+ ');

446: l_result integer;
447:
448: BEGIN
449:
450: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()+ ');
451:
452: /*---------------------------------------------+
453: | Do nothing if the line does not use rules |
454: +---------------------------------------------*/

Line 458: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');

454: +---------------------------------------------*/
455:
456: IF ( p_acc_rule_id IS NULL )
457: THEN arp_util.debug('accounting_rule_id is null - no action taken');
458: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');
459: RETURN;
460: END IF;
461:
462: /*-----------------------------------------------------------------+

Line 602: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');

598:
599:
600: END IF;
601:
602: arp_util.print_fcn_label('arp_dates.val_gl_periods_for_rules()- ');
603:
604:
605: EXCEPTION
606: WHEN OTHERS THEN

Line 612: arp_util.debug('EXCEPTION: arp_dates.val_gl_periods_for_rules()');

608: /*---------------------------------------------+
609: | Display parameters and raise the exception |
610: +---------------------------------------------*/
611:
612: arp_util.debug('EXCEPTION: arp_dates.val_gl_periods_for_rules()');
613:
614: arp_util.debug('');
615: arp_util.debug('------- parameters for val_gl_periods_for_rules() -------');
616:

Line 677: arp_util.print_fcn_label('arp_dates.get_date_based_on_rev_sched()+ ');

673: actual_num_fiscal_year gl_periods.period_year%TYPE;
674:
675: BEGIN
676:
677: arp_util.print_fcn_label('arp_dates.get_date_based_on_rev_sched()+ ');
678:
679:
680: IF (p_invoicing_rule_id = IN_ADVANCE )
681: THEN

Line 792: arp_util.print_fcn_label('arp_dates.get_date_based_on_rev_sched()- ');

788: ctl.rule_end_Date;
789:
790: END IF;
791:
792: arp_util.print_fcn_label('arp_dates.get_date_based_on_rev_sched()- ');
793:
794:
795: EXCEPTION
796: WHEN OTHERS THEN

Line 802: arp_util.debug('EXCEPTION: arp_dates.get_date_based_on_rev_sched()');

798: /*---------------------------------------------+
799: | Display parameters and raise the exception |
800: +---------------------------------------------*/
801:
802: arp_util.debug('EXCEPTION: arp_dates.get_date_based_on_rev_sched()');
803:
804: arp_util.debug('');
805: arp_util.debug('---- parameters for get_date_based_on_rev_sched() ----');
806:

Line 901: arp_util.print_fcn_label('arp_dates.derive_gl_trx_dates_from_rules()+ ');

897:
898:
899: BEGIN
900:
901: arp_util.print_fcn_label('arp_dates.derive_gl_trx_dates_from_rules()+ ');
902:
903:
904: /*---------------------------+
905: | Validate the parameters |

Line 1138: arp_util.print_fcn_label('arp_dates.derive_gl_trx_dates_from_rules()- ');

1134: p_trx_date := nvl(l_trx_date, p_trx_date);
1135: p_gl_date := nvl(l_gl_date, p_gl_date);
1136:
1137:
1138: arp_util.print_fcn_label('arp_dates.derive_gl_trx_dates_from_rules()- ');
1139:
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142:

Line 1147: arp_util.debug('EXCEPTION: arp_dates.derive_gl_trx_dates_from_rules()');

1143: /*---------------------------------------------+
1144: | Display parameters and raise the exception |
1145: +---------------------------------------------*/
1146:
1147: arp_util.debug('EXCEPTION: arp_dates.derive_gl_trx_dates_from_rules()');
1148:
1149: arp_util.debug('');
1150: arp_util.debug('---- parameters for derive_gl_trx_dates_from_rules() ----');
1151:

Line 1168: arp_util.debug('EXCEPTION: arp_dates');

1164: -- arp_trx_global.profile_info.application_id;
1165:
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: arp_util.debug('EXCEPTION: arp_dates');
1169: RAISE;
1170:
1171: END ARP_DATES;

Line 1171: END ARP_DATES;

1167: WHEN OTHERS THEN
1168: arp_util.debug('EXCEPTION: arp_dates');
1169: RAISE;
1170:
1171: END ARP_DATES;