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 1179: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');

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

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

1179: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');
1184: RAISE;
1185:
1186: END;
1187:

Line 1199: | arp_util.debug |

1195: | |
1196: | SCOPE - PUBLIC |
1197: | |
1198: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1199: | arp_util.debug |
1200: | |
1201: | ARGUMENTS : IN: |
1202: | p_trx_date |
1203: | p_prev_trx_date |

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

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

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

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

Line 1373: arp_util.debug(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2223:
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');
2228: RAISE;
2229:
2230: END;
2231:

Line 2337: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2485: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2641: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_bill_to_site_use_id = ' ||
2642: p_bill_to_site_use_id );
2643: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_receipt_method_id = ' ||
2644: p_in_receipt_method_id );
2645: arp_util.debug('val_and_dflt_pay_mthd_and_bank: ' || 'p_in_customer_bank_account_id = ' ||
2646: p_in_customer_bank_account_id );
2647: END IF;
2648:
2649: RAISE;

Line 2707: | arp_util.debug |

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

Line 2708: | arp_util.validate_and_default_gl_date |

2704: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
2705: | arp_trx_util.get_summary_trx_balances |
2706: | arp_trx_validate.validate_trx_date |
2707: | arp_util.debug |
2708: | arp_util.validate_and_default_gl_date |
2709: | |
2710: | ARGUMENTS : IN: |
2711: | p_customer_trx_id |
2712: | p_so_source_code |