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_TRX_COMPLETE_CHK dependencies on ARP_UTIL

Line 49: | arp_util.debug |

45: | arp_non_db_pkg.check_natural_application |
46: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
47: | arp_trx_util.get_summary_trx_balances |
48: | arp_trx_validate.validate_trx_date |
49: | arp_util.debug |
50: | arp_util.validate_and_default_gl_date |
51: | |
52: | ARGUMENTS : IN: |
53: | p_customer_trx_id |

Line 50: | arp_util.validate_and_default_gl_date |

46: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
47: | arp_trx_util.get_summary_trx_balances |
48: | arp_trx_validate.validate_trx_date |
49: | arp_util.debug |
50: | arp_util.validate_and_default_gl_date |
51: | |
52: | ARGUMENTS : IN: |
53: | p_customer_trx_id |
54: | p_so_source_code |

Line 239: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');

235:
236: BEGIN
237:
238: IF PG_DEBUG in ('Y', 'C') THEN
239: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');
240: END IF;
241:
242:
243: /*-----------------------------------------------------------------------+

Line 262: arp_util.debug('check_tax_and_accounting: ' || 'check account assignments and account sets');

258: +-----------------------------------------------------------------------*/
259:
260:
261: IF PG_DEBUG in ('Y', 'C') THEN
262: arp_util.debug('check_tax_and_accounting: ' || 'check account assignments and account sets');
263: END IF;
264:
265: -- Bug 540962: need to compare the 'HANDLER' and 'STANDARD'
266: -- to make sure error is raised when procedure is

Line 292: arp_util.debug('check_tax_and_accounting: ' || 'ERROR: The accounts for line ' ||

288: BEGIN
289: FOR l_error_rec IN dist_check LOOP
290:
291: IF PG_DEBUG in ('Y', 'C') THEN
292: arp_util.debug('check_tax_and_accounting: ' || 'ERROR: The accounts for line ' ||
293: TO_CHAR(l_error_rec.line_number) || '-' ||
294: TO_CHAR(l_error_rec.other_line_number) ||
295: ' is invalid');
296: arp_util.debug('check_tax_and_accounting: ' || 'line amt: ' ||

Line 296: arp_util.debug('check_tax_and_accounting: ' || 'line amt: ' ||

292: arp_util.debug('check_tax_and_accounting: ' || 'ERROR: The accounts for line ' ||
293: TO_CHAR(l_error_rec.line_number) || '-' ||
294: TO_CHAR(l_error_rec.other_line_number) ||
295: ' is invalid');
296: arp_util.debug('check_tax_and_accounting: ' || 'line amt: ' ||
297: TO_CHAR(l_error_rec.line_amount) ||
298: ' dist amt: ' ||
299: TO_CHAR(l_error_rec.dist_amount) ||
300: ' class: ' || l_error_rec.account_class);

Line 359: arp_util.debug(' num of etax validation errors = ' || l_error_count);

355:
356: p_error_count := p_error_count + l_error_count;
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_util.debug(' num of etax validation errors = ' || l_error_count);
360: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
361: END IF;
362:
363: RETURN(TRUE);

Line 360: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');

356: p_error_count := p_error_count + l_error_count;
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_util.debug(' num of etax validation errors = ' || l_error_count);
360: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
361: END IF;
362:
363: RETURN(TRUE);
364:

Line 368: arp_util.debug('check_tax_and_accounting: ' ||

364:
365: EXCEPTION
366: WHEN OTHERS THEN
367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_util.debug('check_tax_and_accounting: ' ||
369: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
370: END IF;
371: RAISE;
372:

Line 407: | arp_util.debug |

403: | arp_non_db_pkg.check_natural_application |
404: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
405: | arp_trx_util.get_summary_trx_balances |
406: | arp_trx_validate.validate_trx_date |
407: | arp_util.debug |
408: | arp_util.validate_and_default_gl_date |
409: | |
410: | ARGUMENTS : IN: |
411: | p_customer_trx_id |

Line 408: | arp_util.validate_and_default_gl_date |

404: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
405: | arp_trx_util.get_summary_trx_balances |
406: | arp_trx_validate.validate_trx_date |
407: | arp_util.debug |
408: | arp_util.validate_and_default_gl_date |
409: | |
410: | ARGUMENTS : IN: |
411: | p_customer_trx_id |
412: | p_so_source_code |

Line 452: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');

448:
449: BEGIN
450:
451: IF PG_DEBUG in ('Y', 'C') THEN
452: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');
453: END IF;
454:
455: -- Bug 540962: error count variable needs to be initialized
456:

Line 474: arp_util.debug('check_tax_and_accounting: ' || 'sql statement: ');

470: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
471: AND ct.customer_trx_id IN (' || p_query_string || ')';
472:
473: IF PG_DEBUG in ('Y', 'C') THEN
474: arp_util.debug('check_tax_and_accounting: ' || 'sql statement: ');
475: arp_util.debug('check_tax_and_accounting: ' || l_sql_statement );
476: END IF;
477:
478: dbms_sql.parse(l_cursor,

Line 475: arp_util.debug('check_tax_and_accounting: ' || l_sql_statement );

471: AND ct.customer_trx_id IN (' || p_query_string || ')';
472:
473: IF PG_DEBUG in ('Y', 'C') THEN
474: arp_util.debug('check_tax_and_accounting: ' || 'sql statement: ');
475: arp_util.debug('check_tax_and_accounting: ' || l_sql_statement );
476: END IF;
477:
478: dbms_sql.parse(l_cursor,
479: l_sql_statement,

Line 503: arp_util.debug('check_tax_and_accounting: ' || '');

499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('check_tax_and_accounting: ' || '');
504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');
505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||
506: TO_CHAR(l_customer_trx_id));
507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||

Line 504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');

500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('check_tax_and_accounting: ' || '');
504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');
505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||
506: TO_CHAR(l_customer_trx_id));
507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||
508: TO_CHAR(l_previous_customer_trx_id));

Line 505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||

501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('check_tax_and_accounting: ' || '');
504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');
505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||
506: TO_CHAR(l_customer_trx_id));
507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||
508: TO_CHAR(l_previous_customer_trx_id));
509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||

Line 507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||

503: arp_util.debug('check_tax_and_accounting: ' || '');
504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');
505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||
506: TO_CHAR(l_customer_trx_id));
507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||
508: TO_CHAR(l_previous_customer_trx_id));
509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||
510: l_trx_number);
511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||

Line 509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||

505: arp_util.debug('check_tax_and_accounting: ' || 'customer_trx_id = ' ||
506: TO_CHAR(l_customer_trx_id));
507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||
508: TO_CHAR(l_previous_customer_trx_id));
509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||
510: l_trx_number);
511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||
512: TO_CHAR(l_invoicing_rule_id));
513: arp_util.debug('check_tax_and_accounting: ' || 'class = ' ||

Line 511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||

507: arp_util.debug('check_tax_and_accounting: ' || 'previous_customer_trx_id = ' ||
508: TO_CHAR(l_previous_customer_trx_id));
509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||
510: l_trx_number);
511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||
512: TO_CHAR(l_invoicing_rule_id));
513: arp_util.debug('check_tax_and_accounting: ' || 'class = ' ||
514: l_class);
515: arp_util.debug('check_tax_and_accounting: ' || 'tax_calculation_flag = ' ||

Line 513: arp_util.debug('check_tax_and_accounting: ' || 'class = ' ||

509: arp_util.debug('check_tax_and_accounting: ' || 'trx_number = ' ||
510: l_trx_number);
511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||
512: TO_CHAR(l_invoicing_rule_id));
513: arp_util.debug('check_tax_and_accounting: ' || 'class = ' ||
514: l_class);
515: arp_util.debug('check_tax_and_accounting: ' || 'tax_calculation_flag = ' ||
516: l_tax_calculation_flag);
517: END IF;

Line 515: arp_util.debug('check_tax_and_accounting: ' || 'tax_calculation_flag = ' ||

511: arp_util.debug('check_tax_and_accounting: ' || 'invoicing_rule_id = ' ||
512: TO_CHAR(l_invoicing_rule_id));
513: arp_util.debug('check_tax_and_accounting: ' || 'class = ' ||
514: l_class);
515: arp_util.debug('check_tax_and_accounting: ' || 'tax_calculation_flag = ' ||
516: l_tax_calculation_flag);
517: END IF;
518:
519: IF ( check_tax_and_accounting(

Line 537: arp_util.debug('check_tax_and_accounting: ' || 'Setting error out NOCOPY parameters to: ');

533: p_error_line_number := l_error_line_number;
534: p_error_other_line_number := l_error_other_line_number;
535:
536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_util.debug('check_tax_and_accounting: ' || 'Setting error out NOCOPY parameters to: ');
538: arp_util.debug('check_tax_and_accounting: ' || 'p_error_trx_number = ' ||
539: l_trx_number);
540: arp_util.debug('check_tax_and_accounting: ' || 'p_error_line_number = ' ||
541: l_error_line_number);

Line 538: arp_util.debug('check_tax_and_accounting: ' || 'p_error_trx_number = ' ||

534: p_error_other_line_number := l_error_other_line_number;
535:
536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_util.debug('check_tax_and_accounting: ' || 'Setting error out NOCOPY parameters to: ');
538: arp_util.debug('check_tax_and_accounting: ' || 'p_error_trx_number = ' ||
539: l_trx_number);
540: arp_util.debug('check_tax_and_accounting: ' || 'p_error_line_number = ' ||
541: l_error_line_number);
542: arp_util.debug('check_tax_and_accounting: ' || 'p_error_other_line_number = ' ||

Line 540: arp_util.debug('check_tax_and_accounting: ' || 'p_error_line_number = ' ||

536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_util.debug('check_tax_and_accounting: ' || 'Setting error out NOCOPY parameters to: ');
538: arp_util.debug('check_tax_and_accounting: ' || 'p_error_trx_number = ' ||
539: l_trx_number);
540: arp_util.debug('check_tax_and_accounting: ' || 'p_error_line_number = ' ||
541: l_error_line_number);
542: arp_util.debug('check_tax_and_accounting: ' || 'p_error_other_line_number = ' ||
543: l_error_other_line_number);
544: END IF;

Line 542: arp_util.debug('check_tax_and_accounting: ' || 'p_error_other_line_number = ' ||

538: arp_util.debug('check_tax_and_accounting: ' || 'p_error_trx_number = ' ||
539: l_trx_number);
540: arp_util.debug('check_tax_and_accounting: ' || 'p_error_line_number = ' ||
541: l_error_line_number);
542: arp_util.debug('check_tax_and_accounting: ' || 'p_error_other_line_number = ' ||
543: l_error_other_line_number);
544: END IF;
545:
546: dbms_sql.close_cursor(l_cursor);

Line 549: arp_util.debug('check_tax_and_accounting: ' || 'returning FALSE');

545:
546: dbms_sql.close_cursor(l_cursor);
547:
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_util.debug('check_tax_and_accounting: ' || 'returning FALSE');
550: arp_util.debug('check_tax_and_accounting: ' ||
551: 'arp_trx_validate.check_tax_and_accounting()-');
552: END IF;
553:

Line 550: arp_util.debug('check_tax_and_accounting: ' ||

546: dbms_sql.close_cursor(l_cursor);
547:
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_util.debug('check_tax_and_accounting: ' || 'returning FALSE');
550: arp_util.debug('check_tax_and_accounting: ' ||
551: 'arp_trx_validate.check_tax_and_accounting()-');
552: END IF;
553:
554: RETURN(FALSE);

Line 565: arp_util.debug('check_tax_and_accounting: ' || 'returning TRUE');

561:
562: dbms_sql.close_cursor(l_cursor);
563:
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_util.debug('check_tax_and_accounting: ' || 'returning TRUE');
566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
567: END IF;
568:
569: RETURN(TRUE);

Line 566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');

562: dbms_sql.close_cursor(l_cursor);
563:
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_util.debug('check_tax_and_accounting: ' || 'returning TRUE');
566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
567: END IF;
568:
569: RETURN(TRUE);
570:

Line 574: arp_util.debug('check_tax_and_accounting: ' ||

570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: IF PG_DEBUG in ('Y', 'C') THEN
574: arp_util.debug('check_tax_and_accounting: ' ||
575: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||
577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );

Line 576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||

572: WHEN OTHERS THEN
573: IF PG_DEBUG in ('Y', 'C') THEN
574: arp_util.debug('check_tax_and_accounting: ' ||
575: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||
577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );
579: END IF;
580: IF (dbms_sql.is_open(l_cursor))

Line 578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );

574: arp_util.debug('check_tax_and_accounting: ' ||
575: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||
577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );
579: END IF;
580: IF (dbms_sql.is_open(l_cursor))
581: THEN dbms_sql.close_cursor(l_cursor);
582: END IF;

Line 641: | arp_util.debug |

637: | arp_non_db_pkg.check_natural_application |
638: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
639: | arp_trx_util.get_summary_trx_balances |
640: | arp_trx_validate.validate_trx_date |
641: | arp_util.debug |
642: | arp_util.validate_and_default_gl_date |
643: | |
644: | ARGUMENTS : IN: |
645: | p_customer_trx_id |

Line 642: | arp_util.validate_and_default_gl_date |

638: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
639: | arp_trx_util.get_summary_trx_balances |
640: | arp_trx_validate.validate_trx_date |
641: | arp_util.debug |
642: | arp_util.validate_and_default_gl_date |
643: | |
644: | ARGUMENTS : IN: |
645: | p_customer_trx_id |
646: | p_so_source_code |

Line 829: arp_util.debug('arp_trx_completion_chk.do_completion_checking()+');

825: l_status VARCHAR2(1);
826: BEGIN
827:
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_util.debug('arp_trx_completion_chk.do_completion_checking()+');
830: arp_util.debug(' p_check_tax_acct = ' || p_check_tax_acct);
831: END IF;
832: -- Bug 540962: l_error_count variable needs to be initialized.
833:

Line 830: arp_util.debug(' p_check_tax_acct = ' || p_check_tax_acct);

826: BEGIN
827:
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_util.debug('arp_trx_completion_chk.do_completion_checking()+');
830: arp_util.debug(' p_check_tax_acct = ' || p_check_tax_acct);
831: END IF;
832: -- Bug 540962: l_error_count variable needs to be initialized.
833:
834: p_error_count := 0;

Line 842: arp_util.debug('Get information about the transaction');

838: | Get information about the current transaction |
839: +-------------------------------------------------*/
840:
841: IF PG_DEBUG in ('Y', 'C') THEN
842: arp_util.debug('Get information about the transaction');
843: END IF;
844:
845: arp_ct_pkg.fetch_p(l_trx_rec,
846: p_customer_trx_id);

Line 910: arp_util.debug('Get information about the commitment');

906: IF ( l_trx_rec.initial_customer_trx_id IS NOT NULL )
907: THEN
908:
909: IF PG_DEBUG in ('Y', 'C') THEN
910: arp_util.debug('Get information about the commitment');
911: END IF;
912:
913: arp_ct_pkg.fetch_p(l_commit_trx_rec,
914: l_trx_rec.initial_customer_trx_id);

Line 932: arp_util.debug('Insure that the transaction number is unique.');

928: | validate that the transaction number is unique |
929: *------------------------------------------------*/
930:
931: IF PG_DEBUG in ('Y', 'C') THEN
932: arp_util.debug('Insure that the transaction number is unique.');
933: END IF;
934:
935: BEGIN
936: arp_trx_validate.validate_trx_number( l_trx_rec.batch_source_id,

Line 943: arp_util.debug('ERROR: transaction number uniqueness check failed');

939:
940: EXCEPTION
941: WHEN OTHERS THEN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_util.debug('ERROR: transaction number uniqueness check failed');
944: END IF;
945:
946: arp_trx_validate.add_to_error_list(
947: p_error_mode,

Line 968: arp_util.debug('Insure that the document number is unique.');

964: | validate that the document number is unique |
965: *---------------------------------------------*/
966:
967: IF PG_DEBUG in ('Y', 'C') THEN
968: arp_util.debug('Insure that the document number is unique.');
969: END IF;
970:
971: /* 4537055 - Corrected this validation to use validate_doc_number.
972: it was using validate_trx_number (typo) before. Also exception

Line 983: arp_util.debug('ERROR: document number uniqueness check failed');

979:
980: EXCEPTION
981: WHEN OTHERS THEN
982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug('ERROR: document number uniqueness check failed');
984: END IF;
985:
986: arp_trx_validate.add_to_error_list(
987: p_error_mode,

Line 1008: arp_util.debug('Insure that at least one line or freight line exists.');

1004: | Insure that at least one line or freight line exists. |
1005: +---------------------------------------------------------*/
1006:
1007: IF PG_DEBUG in ('Y', 'C') THEN
1008: arp_util.debug('Insure that at least one line or freight line exists.');
1009: END IF;
1010:
1011: SELECT COUNT(*)
1012: INTO l_result

Line 1019: arp_util.debug('ERROR: line existance validation failed');

1015:
1016: IF (l_result < 1)
1017: THEN
1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_util.debug('ERROR: line existance validation failed');
1020: END IF;
1021:
1022: arp_trx_validate.add_to_error_list(
1023: p_error_mode,

Line 1047: arp_util.debug('Insure that Payment term and Tax code do not conflict');

1043: | Payment term should be such that the discount is |
1044: | calculated based on Invoice Line amounts only. |
1045: +--------------------------------------------------------*/
1046: IF PG_DEBUG in ('Y', 'C') THEN
1047: arp_util.debug('Insure that Payment term and Tax code do not conflict');
1048: END IF;
1049:
1050: SELECT count(*)
1051: INTO l_result

Line 1071: arp_util.debug('ERROR: Tax and payment term conflict exist');

1067:
1068: IF (l_result > 0)
1069: THEN
1070: IF PG_DEBUG in ('Y', 'C') THEN
1071: arp_util.debug('ERROR: Tax and payment term conflict exist');
1072: END IF;
1073: arp_trx_validate.add_to_error_list(
1074: p_error_mode,
1075: l_error_count,

Line 1096: arp_util.debug('Check date ranges');

1092: | are valid for the specified trx date. |
1093: +--------------------------------------------------------*/
1094:
1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_util.debug('Check date ranges');
1097: END IF;
1098:
1099: arp_trx_validate.validate_trx_date(
1100: p_error_mode,

Line 1146: arp_util.debug( 'ERROR: date range validation failed');

1142: IF (l_result_flag = FALSE)
1143: THEN
1144:
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_util.debug( 'ERROR: date range validation failed');
1147: END IF;
1148: app_exception.raise_exception;
1149:
1150: END IF;

Line 1159: arp_util.debug('Insure that the exchange rate fields are filled in');

1155: | transaction is in a foreign currency. |
1156: +--------------------------------------------------------------*/
1157:
1158: IF PG_DEBUG in ('Y', 'C') THEN
1159: arp_util.debug('Insure that the exchange rate fields are filled in');
1160: END IF;
1161:
1162: IF ( l_trx_rec.invoice_currency_code <> arp_global.functional_currency )
1163: THEN

Line 1168: arp_util.debug( 'ERROR: exchange rate is null');

1164: IF ( l_trx_rec.exchange_rate IS NULL )
1165: THEN
1166:
1167: IF PG_DEBUG in ('Y', 'C') THEN
1168: arp_util.debug( 'ERROR: exchange rate is null');
1169: END IF;
1170:
1171: arp_trx_validate.add_to_error_list(
1172: p_error_mode,

Line 1192: arp_util.debug( 'ERROR: exchange rate type is null');

1188: IF ( l_trx_rec.exchange_rate_type IS NULL )
1189: THEN
1190:
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_util.debug( 'ERROR: exchange rate type is null');
1193: END IF;
1194:
1195: arp_trx_validate.add_to_error_list(
1196: p_error_mode,

Line 1216: arp_util.debug( 'ERROR: exchange rate date is null');

1212: IF ( l_trx_rec.exchange_date IS NULL )
1213: THEN
1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_util.debug( 'ERROR: exchange rate date is null');
1217: END IF;
1218:
1219: arp_trx_validate.add_to_error_list(
1220: p_error_mode,

Line 1250: arp_util.debug( 'Check the dates of the transaction''s commitment');

1246: | start / end date range. |
1247: +----------------------------------------------------------*/
1248:
1249: IF PG_DEBUG in ('Y', 'C') THEN
1250: arp_util.debug( 'Check the dates of the transaction''s commitment');
1251: END IF;
1252:
1253: IF ( l_trx_rec.initial_customer_trx_id IS NOT NULL )
1254: THEN

Line 1267: arp_util.debug(

1263: l_trx_rec.trx_date)
1264: )
1265: THEN
1266: IF PG_DEBUG in ('Y', 'C') THEN
1267: arp_util.debug(
1268: 'ERROR: commitment dates do not include the trx_date');
1269: END IF;
1270:
1271: arp_trx_validate.add_to_error_list(

Line 1302: arp_util.debug( 'ERROR: The transaction''s GL date is before '||

1298: )
1299: THEN
1300:
1301: IF PG_DEBUG in ('Y', 'C') THEN
1302: arp_util.debug( 'ERROR: The transaction''s GL date is before '||
1303: 'the commitment''s GL date');
1304: END IF;
1305:
1306: arp_trx_validate.add_to_error_list(

Line 1336: arp_util.debug( 'Check salescredits');

1332: | a line or they sum to 100%. |
1333: +---------------------------------------------------------------------*/
1334:
1335: IF PG_DEBUG in ('Y', 'C') THEN
1336: arp_util.debug( 'Check salescredits');
1337: END IF;
1338:
1339: BEGIN
1340: FOR l_error_rec IN salesrep_check LOOP

Line 1343: arp_util.debug( 'ERROR: salescredits for line ' ||

1339: BEGIN
1340: FOR l_error_rec IN salesrep_check LOOP
1341:
1342: IF PG_DEBUG in ('Y', 'C') THEN
1343: arp_util.debug( 'ERROR: salescredits for line ' ||
1344: TO_CHAR(l_error_rec.line_number) ||
1345: ' are invalid');
1346: END IF;
1347:

Line 1398: arp_util.debug( 'check that all lines have rule information if rules are '||

1394: | verify that all lines have accounting rules and rule start dates. |
1395: +---------------------------------------------------------------------*/
1396:
1397: IF PG_DEBUG in ('Y', 'C') THEN
1398: arp_util.debug( 'check that all lines have rule information if rules are '||
1399: 'being used');
1400: END IF;
1401:
1402: IF ( l_trx_rec.invoicing_rule_id IS NOT NULL )

Line 1425: arp_util.debug( 'ERROR: the rule information is invalid ' ||

1421: BEGIN
1422: FOR l_error_rec IN rule_check LOOP
1423:
1424: IF PG_DEBUG in ('Y', 'C') THEN
1425: arp_util.debug( 'ERROR: the rule information is invalid ' ||
1426: ' for line ' ||
1427: TO_CHAR(l_error_rec.line_number));
1428: END IF;
1429:

Line 1461: arp_util.debug( 'check creation sign');

1457: | Check the creation sign of the transaction |
1458: +----------------------------------------------*/
1459:
1460: IF PG_DEBUG in ('Y', 'C') THEN
1461: arp_util.debug( 'check creation sign');
1462: END IF;
1463:
1464: arp_non_db_pkg.check_creation_sign(
1465: l_creation_sign,

Line 1474: arp_util.debug( 'ERROR: the transaction violate the creation sign');

1470: IF ( l_error_message IS NOT NULL )
1471: THEN
1472:
1473: IF PG_DEBUG in ('Y', 'C') THEN
1474: arp_util.debug( 'ERROR: the transaction violate the creation sign');
1475: END IF;
1476:
1477: arp_trx_validate.add_to_error_list(
1478: p_error_mode,

Line 1501: arp_util.debug( 'check the GL date');

1497: | Check the GL Date |
1498: +---------------------*/
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN
1501: arp_util.debug( 'check the GL date');
1502: END IF;
1503:
1504: /*------------------------------------------------------+
1505: | Verify that the GL Date is in an Opened, Future or |

Line 1509: l_result_flag := arp_util.validate_and_default_gl_date(

1505: | Verify that the GL Date is in an Opened, Future or |
1506: | Never Opened (Arrears only) Period. |
1507: +------------------------------------------------------*/
1508:
1509: l_result_flag := arp_util.validate_and_default_gl_date(
1510: l_trx_gl_date,
1511: NULL,
1512: NULL,
1513: NULL,

Line 1529: arp_util.debug( 'ERROR: the GL date is invalid');

1525:
1526: IF ( l_trx_gl_date <> l_default_gl_date )
1527: THEN
1528: IF PG_DEBUG in ('Y', 'C') THEN
1529: arp_util.debug( 'ERROR: the GL date is invalid');
1530: END IF;
1531:
1532: arp_trx_validate.add_to_error_list(
1533: p_error_mode,

Line 1559: arp_util.debug( 'check credit memos against specific transactions');

1555: IF ( l_trx_rec.previous_customer_trx_id IS NOT NULL )
1556: THEN
1557:
1558: IF PG_DEBUG in ('Y', 'C') THEN
1559: arp_util.debug( 'check credit memos against specific transactions');
1560: arp_util.debug( 'get credit memo information');
1561: END IF;
1562:
1563: arp_ct_pkg.fetch_p(l_prev_trx_rec,

Line 1560: arp_util.debug( 'get credit memo information');

1556: THEN
1557:
1558: IF PG_DEBUG in ('Y', 'C') THEN
1559: arp_util.debug( 'check credit memos against specific transactions');
1560: arp_util.debug( 'get credit memo information');
1561: END IF;
1562:
1563: arp_ct_pkg.fetch_p(l_prev_trx_rec,
1564: l_trx_rec.previous_customer_trx_id);

Line 1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);

1626: l_prev_total_original,
1627: l_prev_total_remaining);
1628:
1629: IF PG_DEBUG in ('Y', 'C') THEN
1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);
1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);

Line 1631: arp_util.debug( 'l_line_amount : '||l_line_amount);

1627: l_prev_total_remaining);
1628:
1629: IF PG_DEBUG in ('Y', 'C') THEN
1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);
1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);

Line 1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);

1628:
1629: IF PG_DEBUG in ('Y', 'C') THEN
1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);
1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);

Line 1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);

1629: IF PG_DEBUG in ('Y', 'C') THEN
1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);
1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);

Line 1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);

1630: arp_util.debug( 'previous_customer_trx_id : '||l_trx_rec.previous_customer_trx_id);
1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);

Line 1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);

1631: arp_util.debug( 'l_line_amount : '||l_line_amount);
1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);

Line 1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);

1632: arp_util.debug( 'l_tax_amount : '||l_tax_amount);
1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);

Line 1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);

1633: arp_util.debug( 'l_freight_amount : '||l_freight_amount);
1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);

Line 1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);

1634: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);

Line 1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);

1635: arp_util.debug( 'l_prev_line_original : '||l_prev_line_original);
1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);
1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);

Line 1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);

1636: arp_util.debug( 'l_prev_line_remaining : '||l_prev_line_remaining);
1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);
1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1644: END IF;

Line 1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);

1637: arp_util.debug( 'l_prev_tax_original : '||l_prev_tax_original);
1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);
1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1644: END IF;
1645:

Line 1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);

1638: arp_util.debug( 'l_prev_tax_remaining : '||l_prev_tax_remaining);
1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);
1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1644: END IF;
1645:
1646: /* Bug 882789: Get commitment adjustment amount for the credited

Line 1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);

1639: arp_util.debug( 'l_prev_freight_original : '||l_prev_freight_original);
1640: arp_util.debug( 'l_prev_freight_remaining : '||l_prev_freight_remaining);
1641: arp_util.debug( 'l_prev_total_original : '||l_prev_total_original);
1642: arp_util.debug( 'l_prev_total_remaining : '||l_prev_total_remaining);
1643: arp_util.debug( 'l_open_receivables_flag : '||l_open_receivables_flag);
1644: END IF;
1645:
1646: /* Bug 882789: Get commitment adjustment amount for the credited
1647: transaction. This amount should be added to l_prev_total_remaining

Line 1665: arp_util.debug( 'l_commit_adj_amount : ' || to_char(l_commit_adj_amount));

1661: where customer_trx_id = l_trx_rec.previous_customer_trx_id
1662: and receivables_trx_id = -1;
1663:
1664: IF PG_DEBUG in ('Y', 'C') THEN
1665: arp_util.debug( 'l_commit_adj_amount : ' || to_char(l_commit_adj_amount));
1666: END IF;
1667:
1668: /*----------------------------------------------------+
1669: | For credit memos against specific transactions, |

Line 1678: arp_util.debug( 'check for total overapplication');

1674: | Check the transaction's total amount |
1675: +----------------------------------------*/
1676:
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_util.debug( 'check for total overapplication');
1679: END IF;
1680:
1681: /* Bug 882789: minus l_commit_adj_amount from l_prev_total_remaining */
1682: arp_non_db_pkg.check_natural_application(

Line 1701: arp_util.debug( 'ERROR: overapplication of the total amount');

1697: IF ( l_error_message IS NOT NULL )
1698: THEN
1699:
1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug( 'ERROR: overapplication of the total amount');
1702: END IF;
1703:
1704: arp_trx_validate.add_to_error_list(
1705: p_error_mode,

Line 1727: arp_util.debug( 'check for line overapplication');

1723: | Check the transaction's line amount |
1724: +---------------------------------------*/
1725:
1726: IF PG_DEBUG in ('Y', 'C') THEN
1727: arp_util.debug( 'check for line overapplication');
1728: END IF;
1729:
1730: /* Bug 882789: minus l_commit_adj_amount from l_prev_line_remaining */
1731: arp_non_db_pkg.check_natural_application(

Line 1750: arp_util.debug( 'ERROR: overapplication of the line amount');

1746: IF ( l_error_message IS NOT NULL )
1747: THEN
1748:
1749: IF PG_DEBUG in ('Y', 'C') THEN
1750: arp_util.debug( 'ERROR: overapplication of the line amount');
1751: END IF;
1752:
1753: arp_trx_validate.add_to_error_list(
1754: p_error_mode,

Line 1775: arp_util.debug( 'check for tax overapplication');

1771: | Check the transaction's tax amount |
1772: +--------------------------------------*/
1773:
1774: IF PG_DEBUG in ('Y', 'C') THEN
1775: arp_util.debug( 'check for tax overapplication');
1776: END IF;
1777:
1778: arp_non_db_pkg.check_natural_application(
1779: l_creation_sign,

Line 1797: arp_util.debug( 'ERROR: overapplication of the tax amount');

1793: IF ( l_error_message IS NOT NULL )
1794: THEN
1795:
1796: IF PG_DEBUG in ('Y', 'C') THEN
1797: arp_util.debug( 'ERROR: overapplication of the tax amount');
1798: END IF;
1799:
1800: arp_trx_validate.add_to_error_list(
1801: p_error_mode,

Line 1822: arp_util.debug( 'check for freight overapplication');

1818: | Check the transaction's freight amount |
1819: +------------------------------------------*/
1820:
1821: IF PG_DEBUG in ('Y', 'C') THEN
1822: arp_util.debug( 'check for freight overapplication');
1823: END IF;
1824:
1825: arp_non_db_pkg.check_natural_application(
1826: l_creation_sign,

Line 1844: arp_util.debug( 'ERROR: overapplication of the freight amount');

1840: IF ( l_error_message IS NOT NULL )
1841: THEN
1842:
1843: IF PG_DEBUG in ('Y', 'C') THEN
1844: arp_util.debug( 'ERROR: overapplication of the freight amount');
1845: END IF;
1846:
1847: arp_trx_validate.add_to_error_list(
1848: p_error_mode,

Line 1870: arp_util.debug( 'check for commitment balance overapplication');

1866: | that it is crediting. |
1867: +---------------------------------------------------------------*/
1868:
1869: IF PG_DEBUG in ('Y', 'C') THEN
1870: arp_util.debug( 'check for commitment balance overapplication');
1871: END IF;
1872:
1873: IF ( l_credited_class = 'DEP' )
1874: THEN

Line 1929: arp_util.debug(

1925: p_so_installed_flag,
1926: l_commitment_balance) )
1927: THEN
1928: IF PG_DEBUG in ('Y', 'C') THEN
1929: arp_util.debug(
1930: 'ERROR: overapplication of the commitment balance');
1931: END IF;
1932:
1933: arp_trx_validate.add_to_error_list(

Line 1957: arp_util.debug( 'check the GL date against the credited transaction''s');

1953: | GL Date. |
1954: +-------------------------------------------------------*/
1955:
1956: IF PG_DEBUG in ('Y', 'C') THEN
1957: arp_util.debug( 'check the GL date against the credited transaction''s');
1958: END IF;
1959:
1960: IF ( l_trx_gl_date < l_prev_gl_date )
1961: THEN

Line 1964: arp_util.debug(

1960: IF ( l_trx_gl_date < l_prev_gl_date )
1961: THEN
1962:
1963: IF PG_DEBUG in ('Y', 'C') THEN
1964: arp_util.debug(
1965: 'ERROR: GL date is before the credited transaction''s');
1966: END IF;
1967:
1968: arp_trx_validate.add_to_error_list(

Line 1999: arp_util.debug( 'check for later credit memos');

1995: | credit memo must be redone before the CM can be made complete. |
1996: +-------------------------------------------------------------------------*/
1997:
1998: IF PG_DEBUG in ('Y', 'C') THEN
1999: arp_util.debug( 'check for later credit memos');
2000: END IF;
2001: SELECT MAX( other_ct.customer_trx_id )
2002: INTO l_result
2003: FROM ra_customer_trx other_ct,

Line 2017: arp_util.debug( 'ERROR: later credit memos exist');

2013: IF ( l_result IS NOT NULL )
2014: THEN
2015:
2016: IF PG_DEBUG in ('Y', 'C') THEN
2017: arp_util.debug( 'ERROR: later credit memos exist');
2018: END IF;
2019:
2020: arp_trx_validate.add_to_error_list(
2021: p_error_mode,

Line 2066: arp_util.debug( 'Check for invalid GL Accounts');

2062: | Check whether the GL Accounts of the current transaction are either|
2063: |invalid or end dated. |
2064: +-------------------------------------------------------------------------*/
2065: IF PG_DEBUG in ('Y', 'C') THEN
2066: arp_util.debug( 'Check for invalid GL Accounts');
2067: END IF;
2068: /* Bug fix 4398445
2069: Check if the transaction is revenue recognized */
2070:

Line 2079: arp_util.debug('do_completion_checking: ' || 'Revenue Recognition Complete Flag : '||l_revrec_complete);

2075: and account_class = 'REC'
2076: and latest_rec_flag = 'Y';
2077:
2078: IF PG_DEBUG in ('Y', 'C') THEN
2079: arp_util.debug('do_completion_checking: ' || 'Revenue Recognition Complete Flag : '||l_revrec_complete);
2080: END IF;
2081: /*End bug5444418*/
2082:
2083: OPEN gl_account_ccid_cur;

Line 2095: arp_util.debug('do_completion_checking: '||'Checking CCID '||l_gl_account_ccid);

2091: l_account_class in ('REV','UNEARN','UNBILL') AND
2092: l_account_set_flag = 'N' AND
2093: l_revrec_complete = 'N') THEN
2094: IF PG_DEBUG in ('Y', 'C') THEN
2095: arp_util.debug('do_completion_checking: '||'Checking CCID '||l_gl_account_ccid);
2096: END IF;
2097: IF (
2098: -- If the GL Account is excluded using a Security Rule
2099: -- 3567612 : pass ARP_GLOBAL.chart_of_accounts_id instead of 101

Line 2118: arp_util.debug(

2114: )
2115: THEN
2116:
2117: IF PG_DEBUG in ('Y', 'C') THEN
2118: arp_util.debug(
2119: 'Error: Atleast one of the GL Accounts is either invalid or end dated');
2120: END IF;
2121: arp_trx_validate.add_to_error_list(
2122: p_error_mode,

Line 2145: arp_util.debug( 'completion error count: ' || to_char(l_error_count));

2141:
2142: p_error_count := l_error_count;
2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug( 'completion error count: ' || to_char(l_error_count));
2146: arp_util.debug('arp_trx_completion_chk.do_completion_checking()-');
2147: END IF;
2148:
2149: EXCEPTION

Line 2146: arp_util.debug('arp_trx_completion_chk.do_completion_checking()-');

2142: p_error_count := l_error_count;
2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug( 'completion error count: ' || to_char(l_error_count));
2146: arp_util.debug('arp_trx_completion_chk.do_completion_checking()-');
2147: END IF;
2148:
2149: EXCEPTION
2150: WHEN OTHERS THEN

Line 2152: arp_util.debug(

2148:
2149: EXCEPTION
2150: WHEN OTHERS THEN
2151: IF PG_DEBUG in ('Y', 'C') THEN
2152: arp_util.debug(
2153: 'EXCEPTION: arp_trx_completion_chk.do_completion_checking()');
2154: END IF;
2155: RAISE;
2156: