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 1301: arp_util.debug( 'ERROR: The transaction''s GL date is before '||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1507: l_result_flag := arp_util.validate_and_default_gl_date(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1927: arp_util.debug(

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

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

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

Line 1962: arp_util.debug(

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

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

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

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

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

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

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

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

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

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

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

Line 2115: arp_util.debug(

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

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

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

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

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

Line 2149: arp_util.debug(

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