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

Line 29: | arp_util.debug |

25: | |
26: | SCOPE - PRIVATE |
27: | |
28: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
29: | arp_util.debug |
30: | |
31: | ARGUMENTS : IN: |
32: | p_mode |
33: | p_customer_trx_id |

Line 87: arp_util.debug('arp_trx_validate.add_to_error_list()+');

83:
84: BEGIN
85:
86: IF PG_DEBUG in ('Y', 'C') THEN
87: arp_util.debug('arp_trx_validate.add_to_error_list()+');
88: END IF;
89:
90: p_error_count := nvl(p_error_count,0) + 1;
91:

Line 97: arp_util.debug('p_mode = ' || p_mode);

93: | Write error information to the debug pipe |
94: +---------------------------------------------*/
95:
96: IF PG_DEBUG in ('Y', 'C') THEN
97: arp_util.debug('p_mode = ' || p_mode);
98: arp_util.debug('adding: ctid: ' || p_customer_trx_id ||
99: ' trx_number: ' || p_trx_number ||
100: ' line: ' || TO_CHAR(p_line_number) || ',' ||
101: TO_CHAR(p_other_line_number) );

Line 98: arp_util.debug('adding: ctid: ' || p_customer_trx_id ||

94: +---------------------------------------------*/
95:
96: IF PG_DEBUG in ('Y', 'C') THEN
97: arp_util.debug('p_mode = ' || p_mode);
98: arp_util.debug('adding: ctid: ' || p_customer_trx_id ||
99: ' trx_number: ' || p_trx_number ||
100: ' line: ' || TO_CHAR(p_line_number) || ',' ||
101: TO_CHAR(p_other_line_number) );
102: arp_util.debug(' msg: ' || p_message_name || ' token 1 ' || p_token_1 ||

Line 102: arp_util.debug(' msg: ' || p_message_name || ' token 1 ' || p_token_1 ||

98: arp_util.debug('adding: ctid: ' || p_customer_trx_id ||
99: ' trx_number: ' || p_trx_number ||
100: ' line: ' || TO_CHAR(p_line_number) || ',' ||
101: TO_CHAR(p_other_line_number) );
102: arp_util.debug(' msg: ' || p_message_name || ' token 1 ' || p_token_1 ||
103: ' token 2 ' || p_token_2);
104: arp_util.debug('error location: ' || p_error_location );
105: END IF;
106:

Line 104: arp_util.debug('error location: ' || p_error_location );

100: ' line: ' || TO_CHAR(p_line_number) || ',' ||
101: TO_CHAR(p_other_line_number) );
102: arp_util.debug(' msg: ' || p_message_name || ' token 1 ' || p_token_1 ||
103: ' token 2 ' || p_token_2);
104: arp_util.debug('error location: ' || p_error_location );
105: END IF;
106:
107: /*---------------------+
108: | Process the error |

Line 197: arp_util.debug('arp_trx_validate.add_to_error_list()-');

193: END IF;
194:
195:
196: IF PG_DEBUG in ('Y', 'C') THEN
197: arp_util.debug('arp_trx_validate.add_to_error_list()-');
198: END IF;
199:
200: EXCEPTION
201: WHEN OTHERS THEN

Line 203: arp_util.debug('add_to_error_list: ' ||

199:
200: EXCEPTION
201: WHEN OTHERS THEN
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug('add_to_error_list: ' ||
204: 'EXCEPTION: arp_trx_validate.add_to_error_list()');
205: END IF;
206: RAISE;
207:

Line 220: | arp_util.debug |

216: | |
217: | SCOPE - PRIVATE |
218: | |
219: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
220: | arp_util.debug |
221: | |
222: | ARGUMENTS : IN: |
223: | p_form_name |
224: | p_form_version |

Line 244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');

240:
241:
242: BEGIN
243:
244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');
245:
246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION

Line 246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');

242: BEGIN
243:
244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');
245:
246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');

Line 250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');

246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');
251: RAISE;
252:
253: END;
254:

Line 264: | arp_util.debug |

260: | |
261: | SCOPE - PUBLIC |
262: | |
263: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
264: | arp_util.debug |
265: | |
266: | ARGUMENTS : IN: |
267: | p_batch_source_id |
268: | p_trx_number |

Line 326: arp_util.debug('arp_trx_validate.validate_trx_number()+');

322: ra_batch_sources_all.allow_duplicate_trx_num_flag%TYPE;
323:
324: BEGIN
325:
326: arp_util.debug('arp_trx_validate.validate_trx_number()+');
327:
328: /* Bug 2681166 Re-introduced the code commented out for bug 2493165 */
329:
330: /* Bug 2493165 Removed the following Document Sequencing changes

Line 366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');

362:
363: END IF;
364:
365: END IF;
366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');

Line 370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');

366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');
371: RAISE;
372:
373: END validate_trx_number;
374:

Line 384: | arp_util.debug |

380: | |
381: | SCOPE - PUBLIC |
382: | |
383: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
384: | arp_util.debug |
385: | |
386: | ARGUMENTS : IN: |
387: | p_cust_trx_type_id |
388: | p_doc_sequence_value |

Line 412: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()+');

408: l_temp varchar2(1);
409:
410: BEGIN
411:
412: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()+');
413:
414: BEGIN
415:
416: IF (

Line 452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');

448: THEN NULL;
449: WHEN OTHERS THEN RAISE;
450: END;
451:
452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');

Line 456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');

452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');
457: RAISE;
458:
459: END;
460:

Line 472: | arp_util.debug |

468: | |
469: | SCOPE - PUBLIC |
470: | |
471: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
472: | arp_util.debug |
473: | |
474: | ARGUMENTS : IN: |
475: | p_line_number |
476: | p_customer_trx_id |

Line 501: arp_util.debug('arp_trx_validate.check_dup_line_number()+');

497: l_count number;
498:
499: BEGIN
500:
501: arp_util.debug('arp_trx_validate.check_dup_line_number()+');
502:
503: SELECT count(*)
504: INTO l_count
505: FROM ra_customer_trx_lines

Line 517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');

513: fnd_message.set_name('AR', 'AR_TW_DUP_LINE_NUM');
514: app_exception.raise_exception;
515: END IF;
516:
517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');

Line 521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');

517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');
522:
523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:

Line 523: arp_util.debug('');

519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');
522:
523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:
526: arp_util.debug('p_line_number = ' || p_line_number);
527: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

Line 524: arp_util.debug('----- parameters for check_dup_line_number() -------');

520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');
522:
523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:
526: arp_util.debug('p_line_number = ' || p_line_number);
527: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
528:

Line 526: arp_util.debug('p_line_number = ' || p_line_number);

522:
523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:
526: arp_util.debug('p_line_number = ' || p_line_number);
527: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
528:
529: RAISE;
530:

Line 527: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:
526: arp_util.debug('p_line_number = ' || p_line_number);
527: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
528:
529: RAISE;
530:
531: END;

Line 544: | arp_util.debug |

540: | |
541: | SCOPE - PUBLIC |
542: | |
543: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
544: | arp_util.debug |
545: | |
546: | ARGUMENTS : IN: |
547: | p_customer_trx_id |
548: | p_display_message |

Line 570: arp_util.debug('arp_trx_validate.check_has_one_line()+');

566: l_count number;
567:
568: BEGIN
569:
570: arp_util.debug('arp_trx_validate.check_has_one_line()+');
571:
572: SELECT count(*)
573: INTO l_count
574: FROM ra_customer_trx_lines

Line 588: arp_util.debug('arp_trx_validate.check_has_one_line()-');

584:
585: app_exception.raise_exception;
586: END IF;
587:
588: arp_util.debug('arp_trx_validate.check_has_one_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');

Line 592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');

588: arp_util.debug('arp_trx_validate.check_has_one_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:

Line 594: arp_util.debug('');

590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:
597: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
598: arp_util.debug('p_display_message = ' || p_display_message );

Line 595: arp_util.debug('----- parameters for check_has_one_line() -------');

591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:
597: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
598: arp_util.debug('p_display_message = ' || p_display_message );
599:

Line 597: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

593:
594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:
597: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
598: arp_util.debug('p_display_message = ' || p_display_message );
599:
600: RAISE;
601:

Line 598: arp_util.debug('p_display_message = ' || p_display_message );

594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:
597: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
598: arp_util.debug('p_display_message = ' || p_display_message );
599:
600: RAISE;
601:
602: END;

Line 615: | arp_util.debug |

611: | |
612: | SCOPE - PUBLIC |
613: | |
614: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
615: | arp_util.debug |
616: | |
617: | ARGUMENTS : IN: |
618: | p_customer_trx_id |
619: | p_previous_customer_trx_id |

Line 651: arp_util.debug('arp_trx_validate.check_sign_and_overapp()+');

647:
648: BEGIN
649:
650: IF PG_DEBUG in ('Y', 'C') THEN
651: arp_util.debug('arp_trx_validate.check_sign_and_overapp()+');
652: END IF;
653:
654: check_sign_and_overapp(
655: p_customer_trx_id => p_customer_trx_id,

Line 667: arp_util.debug('arp_trx_validate.check_sign_and_overapp()-');

663: p_error_count => l_error_count
664: );
665:
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('arp_trx_validate.check_sign_and_overapp()-');
668: END IF;
669:
670:
671: END check_sign_and_overapp;

Line 684: | arp_util.debug |

680: | |
681: | SCOPE - PUBLIC |
682: | |
683: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
684: | arp_util.debug |
685: | |
686: | ARGUMENTS : IN: |
687: | p_customer_trx_id |
688: | p_previous_customer_trx_id |

Line 764: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');

760:
761: BEGIN
762:
763: IF PG_DEBUG in ('Y', 'C') THEN
764: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');
765: END IF;
766:
767:
768: /*-------------------------------------------------------------------+

Line 1019: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');

1015: END IF;
1016:
1017: p_error_count := l_error_count;
1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');
1020: END IF;
1021:
1022:
1023: EXCEPTION

Line 1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');

1021:
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');
1026: p_error_count := l_error_count;
1027: arp_util.debug('');
1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:

Line 1027: arp_util.debug('');

1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');
1026: p_error_count := l_error_count;
1027: arp_util.debug('');
1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:
1030: arp_util.debug( 'p_customer_trx_id: = ' ||
1031: p_customer_trx_id );

Line 1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');

1024: WHEN OTHERS THEN
1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');
1026: p_error_count := l_error_count;
1027: arp_util.debug('');
1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:
1030: arp_util.debug( 'p_customer_trx_id: = ' ||
1031: p_customer_trx_id );
1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||

Line 1030: arp_util.debug( 'p_customer_trx_id: = ' ||

1026: p_error_count := l_error_count;
1027: arp_util.debug('');
1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:
1030: arp_util.debug( 'p_customer_trx_id: = ' ||
1031: p_customer_trx_id );
1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||
1033: p_previous_customer_trx_id );
1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||

Line 1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||

1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:
1030: arp_util.debug( 'p_customer_trx_id: = ' ||
1031: p_customer_trx_id );
1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||
1033: p_previous_customer_trx_id );
1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||
1035: p_trx_open_receivables_flag );
1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||

Line 1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||

1030: arp_util.debug( 'p_customer_trx_id: = ' ||
1031: p_customer_trx_id );
1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||
1033: p_previous_customer_trx_id );
1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||
1035: p_trx_open_receivables_flag );
1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||
1037: p_prev_open_receivables_flag );
1038: arp_util.debug( 'p_creation_sign: = ' ||

Line 1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||

1032: arp_util.debug( 'p_previous_customer_trx_id: = ' ||
1033: p_previous_customer_trx_id );
1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||
1035: p_trx_open_receivables_flag );
1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||
1037: p_prev_open_receivables_flag );
1038: arp_util.debug( 'p_creation_sign: = ' ||
1039: p_creation_sign );
1040: arp_util.debug( 'p_allow_overapplication_flag: = ' ||

Line 1038: arp_util.debug( 'p_creation_sign: = ' ||

1034: arp_util.debug( 'p_trx_open_receivables_flag: = ' ||
1035: p_trx_open_receivables_flag );
1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||
1037: p_prev_open_receivables_flag );
1038: arp_util.debug( 'p_creation_sign: = ' ||
1039: p_creation_sign );
1040: arp_util.debug( 'p_allow_overapplication_flag: = ' ||
1041: p_allow_overapplication_flag );
1042: arp_util.debug( 'p_natural_application_flag: = ' ||

Line 1040: arp_util.debug( 'p_allow_overapplication_flag: = ' ||

1036: arp_util.debug( 'p_prev_open_receivables_flag: = ' ||
1037: p_prev_open_receivables_flag );
1038: arp_util.debug( 'p_creation_sign: = ' ||
1039: p_creation_sign );
1040: arp_util.debug( 'p_allow_overapplication_flag: = ' ||
1041: p_allow_overapplication_flag );
1042: arp_util.debug( 'p_natural_application_flag: = ' ||
1043: p_natural_application_flag );
1044:

Line 1042: arp_util.debug( 'p_natural_application_flag: = ' ||

1038: arp_util.debug( 'p_creation_sign: = ' ||
1039: p_creation_sign );
1040: arp_util.debug( 'p_allow_overapplication_flag: = ' ||
1041: p_allow_overapplication_flag );
1042: arp_util.debug( 'p_natural_application_flag: = ' ||
1043: p_natural_application_flag );
1044:
1045: RAISE;
1046:

Line 1058: | arp_util.debug |

1054: | |
1055: | SCOPE - PUBLIC |
1056: | |
1057: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1058: | arp_util.debug |
1059: | |
1060: | ARGUMENTS : IN: |
1061: | p_paying_customer_id |
1062: | p_trx_date |

Line 1096: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()+');

1092: l_paying_customer_is_valid varchar2(1);
1093:
1094: BEGIN
1095:
1096: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()+');
1097:
1098: BEGIN
1099:
1100: --ajay bug 1081390

Line 1176: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');

1172: EXCEPTION
1173: WHEN OTHERS THEN RAISE;
1174: END;
1175:
1176: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1177:
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');

Line 1180: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');

1176: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1177:
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');
1181: RAISE;
1182:
1183: END;
1184:

Line 1196: | arp_util.debug |

1192: | |
1193: | SCOPE - PUBLIC |
1194: | |
1195: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1196: | arp_util.debug |
1197: | |
1198: | ARGUMENTS : IN: |
1199: | p_trx_date |
1200: | p_prev_trx_date |

Line 1333: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()+');

1329: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;
1330:
1331: BEGIN
1332:
1333: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()+');
1334:
1335: p_result_flag := TRUE;
1336:
1337: /*------------------------------------------------------------------+

Line 1341: arp_util.debug('Validate that CM Date is >= the credited transaction''s '||

1337: /*------------------------------------------------------------------+
1338: | Validate that CM Date is >= the credited transaction's trx_date |
1339: +------------------------------------------------------------------*/
1340:
1341: arp_util.debug('Validate that CM Date is >= the credited transaction''s '||
1342: 'trx_date');
1343:
1344: IF ( p_trx_date < p_prev_trx_date )
1345: THEN

Line 1370: arp_util.debug(

1366: /*---------------------------------------------------------------+
1367: | Validate that the Child Date is >= the commitment's trx_date |
1368: +----------------------------------------------------------------*/
1369:
1370: arp_util.debug(
1371: 'Validate that the Child Date is >= the commitment''s trx_date');
1372:
1373: IF ( p_trx_date < p_commitment_trx_date )
1374: THEN

Line 1401: arp_util.debug('Validate Commitment');

1397: /*-----------------------+
1398: | Validate Commitment |
1399: +-----------------------*/
1400:
1401: arp_util.debug('Validate Commitment');
1402:
1403: /* Bug 2340543 - Do not test commitment balance or date for
1404: credit memos */
1405: IF ( p_initial_customer_trx_id IS NOT NULL AND

Line 1493: arp_util.debug('Validate Agreement');

1489: /*----------------------+
1490: | Validate Agreement |
1491: +----------------------*/
1492:
1493: arp_util.debug('Validate Agreement');
1494:
1495: IF (p_agreement_id IS NOT NULL)
1496: THEN
1497: BEGIN

Line 1535: arp_util.debug('Validate Batch Source');

1531: /*-------------------------+
1532: | Validate Batch Source |
1533: +-------------------------*/
1534:
1535: arp_util.debug('Validate Batch Source');
1536:
1537: IF (p_batch_source_id IS NOT NULL)
1538: THEN
1539: BEGIN

Line 1577: arp_util.debug('Validate Type');

1573: /*-----------------+
1574: | Validate Type |
1575: +-----------------*/
1576:
1577: arp_util.debug('Validate Type');
1578:
1579: IF ( p_cust_trx_type_id IS NOT NULL )
1580: THEN
1581: BEGIN

Line 1620: arp_util.debug('Validate Terms');

1616: /*------------------+
1617: | Validate Terms |
1618: +------------------*/
1619:
1620: arp_util.debug('Validate Terms');
1621:
1622: IF ( p_term_id IS NOT NULL )
1623: THEN
1624: BEGIN

Line 1663: arp_util.debug('Validate ship via');

1659: /*---------------------+
1660: | Validate ship via |
1661: +---------------------*/
1662:
1663: arp_util.debug('Validate ship via');
1664:
1665: IF ( p_ship_method_code IS NOT NULL )
1666: THEN
1667:

Line 1707: arp_util.debug('Validate CM Reason');

1703: /*---------------------+
1704: | Validate CM Reason |
1705: +---------------------*/
1706:
1707: arp_util.debug('Validate CM Reason');
1708:
1709: IF ( p_previous_customer_trx_id IS NOT NULL
1710: AND
1711: p_reason_code IS NOT NULL

Line 1756: arp_util.debug('Validate Status');

1752: /*-------------------+
1753: | Validate Status |
1754: +-------------------*/
1755:
1756: arp_util.debug('Validate Status');
1757:
1758: IF ( p_status_trx IS NOT NULL )
1759: THEN
1760: BEGIN

Line 1812: arp_util.debug('Validate Primary Salesrep');

1808: /*-----------------------------+
1809: | Validate Primary Salesrep |
1810: +-----------------------------*/
1811:
1812: arp_util.debug('Validate Primary Salesrep');
1813:
1814: IF ( p_primary_salesrep_id IS NOT NULL )
1815: THEN
1816: BEGIN

Line 1859: arp_util.debug('Validate Currency');

1855: /*---------------------+
1856: | Validate Currency |
1857: +---------------------*/
1858:
1859: arp_util.debug('Validate Currency');
1860:
1861: IF ( p_invoice_currency_code IS NOT NULL )
1862: THEN
1863: BEGIN

Line 1902: arp_util.debug('Validate Receipt Method');

1898: /*---------------------------+
1899: | Validate Receipt Method |
1900: +---------------------------*/
1901:
1902: arp_util.debug('Validate Receipt Method');
1903:
1904: --Modified the IF condition to fix Bug 2162888, added the check for customer_trx_id
1905: IF ( p_receipt_method_id IS NOT NULL ) AND ( p_customer_trx_id IS NOT NULL )
1906: THEN

Line 2063: arp_util.debug('Validate Customer Bank'|| 'not reqd any more');

2059: /*--------------------------+
2060: | Validate Customer Bank |
2061: +--------------------------*/
2062:
2063: arp_util.debug('Validate Customer Bank'|| 'not reqd any more');
2064: /* payment uptake removed validation for customer bank bug4646161 */
2065:
2066:
2067:

Line 2072: arp_util.debug('Validate Salesreps');

2068: /*----------------------+
2069: | Validate Salesreps |
2070: +----------------------*/
2071:
2072: arp_util.debug('Validate Salesreps');
2073:
2074: IF ( p_customer_trx_id IS NOT NULL )
2075: THEN
2076: BEGIN

Line 2161: arp_util.debug('Validate Memo Line');

2157: /*----------------------+
2158: | Validate Memo Line |
2159: +----------------------*/
2160:
2161: arp_util.debug('Validate Memo Line');
2162:
2163: IF ( p_customer_trx_id IS NOT NULL )
2164: THEN
2165: BEGIN

Line 2219: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()-');

2215:
2216: p_due_date := arpt_sql_func_util.Get_First_Due_Date( p_term_id,
2217: p_trx_date );
2218:
2219: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()-');
2220:
2221:
2222: EXCEPTION
2223: WHEN OTHERS THEN

Line 2224: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');

2220:
2221:
2222: EXCEPTION
2223: WHEN OTHERS THEN
2224: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');
2225: RAISE;
2226:
2227: END;
2228:

Line 2334: | arp_util.debug |

2330: | |
2331: | SCOPE - PUBLIC |
2332: | |
2333: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2334: | arp_util.debug |
2335: | |
2336: | ARGUMENTS : IN: p_customer_trx_line_id |
2337: | OUT: |
2338: | p_result |

Line 2414: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()+');

2410:
2411: BEGIN
2412:
2413: IF PG_DEBUG in ('Y', 'C') THEN
2414: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()+');
2415: END IF;
2416:
2417: OPEN val_gl_dist_amounts;
2418:

Line 2453: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()-');

2449:
2450: END IF;
2451:
2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()-');
2454: END IF;
2455:
2456: EXCEPTION
2457: WHEN OTHERS

Line 2460: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');

2456: EXCEPTION
2457: WHEN OTHERS
2458: THEN
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');
2461: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||
2462: p_customer_trx_line_id );
2463: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );
2464: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );

Line 2461: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||

2457: WHEN OTHERS
2458: THEN
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');
2461: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||
2462: p_customer_trx_line_id );
2463: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );
2464: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );
2465: END IF;

Line 2463: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );

2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');
2461: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||
2462: p_customer_trx_line_id );
2463: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );
2464: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );
2465: END IF;
2466: RAISE;
2467:

Line 2464: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );

2460: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');
2461: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||
2462: p_customer_trx_line_id );
2463: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );
2464: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );
2465: END IF;
2466: RAISE;
2467:
2468: END val_gl_dist_amounts;

Line 2482: | arp_util.debug |

2478: | |
2479: | SCOPE - PUBLIC |
2480: | |
2481: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2482: | arp_util.debug |
2483: | arp_process_credit_util.check_payment_method |
2484: | arp_process_credit_util.check_bank_account |
2485: | |
2486: | ARGUMENTS : IN: |

Line 2546: arp_util.debug('arp_trx_validate.val_and_dflt_pay_mthd_and_bank()+');

2542:
2543: BEGIN
2544:
2545: IF PG_DEBUG in ('Y', 'C') THEN
2546: arp_util.debug('arp_trx_validate.val_and_dflt_pay_mthd_and_bank()+');
2547: END IF;
2548:
2549: IF ( arp_process_credit_util.check_payment_method
2550: (

Line 2617: arp_util.debug('arp_trx_validater.val_and_dflt_pay_mthd_and_bank()-');

2613: END IF;
2614: END IF;
2615:
2616: IF PG_DEBUG in ('Y', 'C') THEN
2617: arp_util.debug('arp_trx_validater.val_and_dflt_pay_mthd_and_bank()-');
2618: END IF;
2619:
2620: EXCEPTION
2621: WHEN NO_DATA_FOUND THEN NULL;

Line 2624: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||

2620: EXCEPTION
2621: WHEN NO_DATA_FOUND THEN NULL;
2622: WHEN OTHERS THEN
2623: IF PG_DEBUG in ('Y', 'C') THEN
2624: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2625: 'EXCEPTION: arp_process_header.val_and_dflt_pay_mthd_and_bank()');
2626: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2627: '------- parameters for val_and_dflt_pay_mthd_and_bank ----');
2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||

Line 2626: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||

2622: WHEN OTHERS THEN
2623: IF PG_DEBUG in ('Y', 'C') THEN
2624: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2625: 'EXCEPTION: arp_process_header.val_and_dflt_pay_mthd_and_bank()');
2626: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2627: '------- parameters for val_and_dflt_pay_mthd_and_bank ----');
2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||
2629: TO_CHAR(p_trx_date) );
2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||

Line 2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||

2624: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2625: 'EXCEPTION: arp_process_header.val_and_dflt_pay_mthd_and_bank()');
2626: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2627: '------- parameters for val_and_dflt_pay_mthd_and_bank ----');
2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||
2629: TO_CHAR(p_trx_date) );
2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||
2631: p_currency_code );
2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||

Line 2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||

2626: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' ||
2627: '------- parameters for val_and_dflt_pay_mthd_and_bank ----');
2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||
2629: TO_CHAR(p_trx_date) );
2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||
2631: p_currency_code );
2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||
2633: p_paying_customer_id );
2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||

Line 2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||

2628: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_trx_date = ' ||
2629: TO_CHAR(p_trx_date) );
2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||
2631: p_currency_code );
2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||
2633: p_paying_customer_id );
2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||
2635: p_paying_site_use_id );
2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||

Line 2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||

2630: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_currency_code = ' ||
2631: p_currency_code );
2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||
2633: p_paying_customer_id );
2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||
2635: p_paying_site_use_id );
2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||
2637: p_bill_to_customer_id );
2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||

Line 2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||

2632: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_customer_id = ' ||
2633: p_paying_customer_id );
2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||
2635: p_paying_site_use_id );
2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||
2637: p_bill_to_customer_id );
2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||
2639: p_bill_to_site_use_id );
2640: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||

Line 2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||

2634: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_paying_site_use_id = ' ||
2635: p_paying_site_use_id );
2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||
2637: p_bill_to_customer_id );
2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||
2639: p_bill_to_site_use_id );
2640: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||
2641: p_in_receipt_method_id );
2642: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_customer_bank_account_id = ' ||

Line 2640: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||

2636: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_customer_id = ' ||
2637: p_bill_to_customer_id );
2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||
2639: p_bill_to_site_use_id );
2640: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||
2641: p_in_receipt_method_id );
2642: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_customer_bank_account_id = ' ||
2643: p_in_customer_bank_account_id );
2644: END IF;

Line 2642: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_customer_bank_account_id = ' ||

2638: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||
2639: p_bill_to_site_use_id );
2640: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||
2641: p_in_receipt_method_id );
2642: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_customer_bank_account_id = ' ||
2643: p_in_customer_bank_account_id );
2644: END IF;
2645:
2646: RAISE;

Line 2704: | arp_util.debug |

2700: | arp_non_db_pkg.check_natural_application |
2701: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
2702: | arp_trx_util.get_summary_trx_balances |
2703: | arp_trx_validate.validate_trx_date |
2704: | arp_util.debug |
2705: | arp_util.validate_and_default_gl_date |
2706: | |
2707: | ARGUMENTS : IN: |
2708: | p_customer_trx_id |

Line 2705: | arp_util.validate_and_default_gl_date |

2701: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
2702: | arp_trx_util.get_summary_trx_balances |
2703: | arp_trx_validate.validate_trx_date |
2704: | arp_util.debug |
2705: | arp_util.validate_and_default_gl_date |
2706: | |
2707: | ARGUMENTS : IN: |
2708: | p_customer_trx_id |
2709: | p_so_source_code |