15: | |
16: | SCOPE - PUBLIC |
17: | |
18: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
19: | arp_util.debug |
20: | arp_maintain_ps.maintain_payment_schedules |
21: | |
22: | ARGUMENTS : IN: |
23: | OUT: |
154: l_ps_rev_cash_id NUMBER;
155: l_ct_rev_cash_id NUMBER;
156: begin
157:
158: arp_util.print_fcn_label( 'arp_process_header.post_commit()+ ');
159:
160: /*-----------------------------------------------------------------+
161: | check form version to determine if it is compatible with the |
162: | entity handler. |
227: ct.cust_trx_type_id,
228: ps.reversed_cash_receipt_id,
229: ct.reversed_cash_receipt_id;
230:
231: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
232: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
233: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
234:
235: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
228: ps.reversed_cash_receipt_id,
229: ct.reversed_cash_receipt_id;
230:
231: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
232: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
233: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
234:
235: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
236: if p_form_name <> 'ARPBFBIB' then
229: ct.reversed_cash_receipt_id;
230:
231: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
232: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
233: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
234:
235: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
236: if p_form_name <> 'ARPBFBIB' then
237:
345: l_activity_flag
346: ) = 0 -- FALSE
347: )
348: THEN
349: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
350: arp_util.debug(l_error_message);
351: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
352:
353: APP_EXCEPTION.raise_exception;
346: ) = 0 -- FALSE
347: )
348: THEN
349: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
350: arp_util.debug(l_error_message);
351: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
352:
353: APP_EXCEPTION.raise_exception;
354: END IF;
352:
353: APP_EXCEPTION.raise_exception;
354: END IF;
355: ELSE
356: arp_util.debug('call to arp_rounding bypassed due to trx_type');
357: END IF; -- end CB
358:
359: /* Bug 2164863 - The tax and accounting validations were postponed
360: until after the rounding routines were called. This was due to
745: ct.cust_trx_type_id,
746: ctt.post_to_gl;
747:
748:
749: arp_util.debug('Recreate Paysched Flag = ' || l_recreate_ps_flag );
750:
751: /* if the l_recreate_ps_flag is set to Y then we want to see if there
752: the transaction has any activity. To do this, we need to get some
753: information about the transaction and then get the activity flag.
895: -- THEN do nothing
896: -- END IF;
897: -----------------------------------------------------------------------
898:
899: arp_util.print_fcn_label( 'arp_process_header.post_commit()- ');
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
899: arp_util.print_fcn_label( 'arp_process_header.post_commit()- ');
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
904:
905: arp_util.debug('');
906: arp_util.debug('---------- parameters for post_commit() ---------');
907:
901: EXCEPTION
902: WHEN OTHERS THEN
903: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
904:
905: arp_util.debug('');
906: arp_util.debug('---------- parameters for post_commit() ---------');
907:
908: arp_util.debug('p_form_name = ' ||
909: p_form_name);
902: WHEN OTHERS THEN
903: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
904:
905: arp_util.debug('');
906: arp_util.debug('---------- parameters for post_commit() ---------');
907:
908: arp_util.debug('p_form_name = ' ||
909: p_form_name);
910: arp_util.debug('p_form_version = ' ||
904:
905: arp_util.debug('');
906: arp_util.debug('---------- parameters for post_commit() ---------');
907:
908: arp_util.debug('p_form_name = ' ||
909: p_form_name);
910: arp_util.debug('p_form_version = ' ||
911: p_form_version);
912: arp_util.debug('p_customer_trx_id = ' ||
906: arp_util.debug('---------- parameters for post_commit() ---------');
907:
908: arp_util.debug('p_form_name = ' ||
909: p_form_name);
910: arp_util.debug('p_form_version = ' ||
911: p_form_version);
912: arp_util.debug('p_customer_trx_id = ' ||
913: p_customer_trx_id);
914: arp_util.debug('p_previous_customer_trx_id = ' ||
908: arp_util.debug('p_form_name = ' ||
909: p_form_name);
910: arp_util.debug('p_form_version = ' ||
911: p_form_version);
912: arp_util.debug('p_customer_trx_id = ' ||
913: p_customer_trx_id);
914: arp_util.debug('p_previous_customer_trx_id = ' ||
915: p_previous_customer_trx_id);
916: arp_util.debug('p_complete_flag = ' ||
910: arp_util.debug('p_form_version = ' ||
911: p_form_version);
912: arp_util.debug('p_customer_trx_id = ' ||
913: p_customer_trx_id);
914: arp_util.debug('p_previous_customer_trx_id = ' ||
915: p_previous_customer_trx_id);
916: arp_util.debug('p_complete_flag = ' ||
917: p_complete_flag);
918: arp_util.debug('p_trx_open_receivables_flag = ' ||
912: arp_util.debug('p_customer_trx_id = ' ||
913: p_customer_trx_id);
914: arp_util.debug('p_previous_customer_trx_id = ' ||
915: p_previous_customer_trx_id);
916: arp_util.debug('p_complete_flag = ' ||
917: p_complete_flag);
918: arp_util.debug('p_trx_open_receivables_flag = ' ||
919: p_trx_open_receivables_flag);
920: arp_util.debug('p_prev_open_receivables_flag = ' ||
914: arp_util.debug('p_previous_customer_trx_id = ' ||
915: p_previous_customer_trx_id);
916: arp_util.debug('p_complete_flag = ' ||
917: p_complete_flag);
918: arp_util.debug('p_trx_open_receivables_flag = ' ||
919: p_trx_open_receivables_flag);
920: arp_util.debug('p_prev_open_receivables_flag = ' ||
921: p_prev_open_receivables_flag);
922: arp_util.debug('p_creation_sign = ' ||
916: arp_util.debug('p_complete_flag = ' ||
917: p_complete_flag);
918: arp_util.debug('p_trx_open_receivables_flag = ' ||
919: p_trx_open_receivables_flag);
920: arp_util.debug('p_prev_open_receivables_flag = ' ||
921: p_prev_open_receivables_flag);
922: arp_util.debug('p_creation_sign = ' ||
923: p_creation_sign);
924: arp_util.debug('p_allow_overapplication_flag = ' ||
918: arp_util.debug('p_trx_open_receivables_flag = ' ||
919: p_trx_open_receivables_flag);
920: arp_util.debug('p_prev_open_receivables_flag = ' ||
921: p_prev_open_receivables_flag);
922: arp_util.debug('p_creation_sign = ' ||
923: p_creation_sign);
924: arp_util.debug('p_allow_overapplication_flag = ' ||
925: p_allow_overapplication_flag);
926: arp_util.debug('p_natural_application_flag = ' ||
920: arp_util.debug('p_prev_open_receivables_flag = ' ||
921: p_prev_open_receivables_flag);
922: arp_util.debug('p_creation_sign = ' ||
923: p_creation_sign);
924: arp_util.debug('p_allow_overapplication_flag = ' ||
925: p_allow_overapplication_flag);
926: arp_util.debug('p_natural_application_flag = ' ||
927: p_natural_application_flag);
928:
922: arp_util.debug('p_creation_sign = ' ||
923: p_creation_sign);
924: arp_util.debug('p_allow_overapplication_flag = ' ||
925: p_allow_overapplication_flag);
926: arp_util.debug('p_natural_application_flag = ' ||
927: p_natural_application_flag);
928:
929: RAISE;
930: