[Home] [Help]
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: |
155: l_ct_rev_cash_id NUMBER;
156: l_tax_validation_status VARCHAR2(1);
157: begin
158:
159: arp_util.print_fcn_label( 'arp_process_header.post_commit()+ ');
160:
161: /*-----------------------------------------------------------------+
162: | check form version to determine if it is compatible with the |
163: | entity handler. |
228: ct.cust_trx_type_id,
229: ps.reversed_cash_receipt_id,
230: ct.reversed_cash_receipt_id;
231:
232: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
233: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
234: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
235: arp_util.debug('Complete Flag Before Update = ' || ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag); /* manishri, 08-Jun-2010. Bug 9693686*/
236:
229: ps.reversed_cash_receipt_id,
230: ct.reversed_cash_receipt_id;
231:
232: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
233: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
234: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
235: arp_util.debug('Complete Flag Before Update = ' || ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag); /* manishri, 08-Jun-2010. Bug 9693686*/
236:
237: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
230: ct.reversed_cash_receipt_id;
231:
232: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
233: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
234: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
235: arp_util.debug('Complete Flag Before Update = ' || ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag); /* manishri, 08-Jun-2010. Bug 9693686*/
236:
237: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
238: if p_form_name <> 'ARPBFBIB' then
231:
232: arp_util.debug('Open Receivables Flag = ' || l_open_receivables_flag);
233: arp_util.debug('Complete Flag Old Value = ' || l_old_complete_flag);
234: arp_util.debug('Complete Flag New Value = ' || p_complete_flag);
235: arp_util.debug('Complete Flag Before Update = ' || ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag); /* manishri, 08-Jun-2010. Bug 9693686*/
236:
237: -- code enclosed in IF clause is NOT necessary when calling program is ARPBFBIB
238: if p_form_name <> 'ARPBFBIB' then
239:
347: l_activity_flag
348: ) = 0 -- FALSE
349: )
350: THEN
351: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
352: arp_util.debug(l_error_message);
353: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
354:
355: APP_EXCEPTION.raise_exception;
348: ) = 0 -- FALSE
349: )
350: THEN
351: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
352: arp_util.debug(l_error_message);
353: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
354:
355: APP_EXCEPTION.raise_exception;
356: END IF;
354:
355: APP_EXCEPTION.raise_exception;
356: END IF;
357: ELSE
358: arp_util.debug('call to arp_rounding bypassed due to trx_type');
359: END IF; -- end CB
360:
361: /* Bug 2164863 - The tax and accounting validations were postponed
362: until after the rounding routines were called. This was due to
747: ct.cust_trx_type_id,
748: ctt.post_to_gl;
749:
750:
751: arp_util.debug('Recreate Paysched Flag = ' || l_recreate_ps_flag );
752:
753: /* if the l_recreate_ps_flag is set to Y then we want to see if there
754: the transaction has any activity. To do this, we need to get some
755: information about the transaction and then get the activity flag.
894:
895:
896: /* 9661501 - call validate_for_tax at the very end if the
897: complete_flag = Y and l_true_open_receivables = N */
898: arp_util.debug('p_complete_flag = ' || p_complete_flag);
899: arp_util.debug('l_true_open_receivables = ' || l_true_open_receivables_flag);
900:
901: IF p_complete_flag = 'Y' and
902: l_true_open_receivables_flag = 'N'
895:
896: /* 9661501 - call validate_for_tax at the very end if the
897: complete_flag = Y and l_true_open_receivables = N */
898: arp_util.debug('p_complete_flag = ' || p_complete_flag);
899: arp_util.debug('l_true_open_receivables = ' || l_true_open_receivables_flag);
900:
901: IF p_complete_flag = 'Y' and
902: l_true_open_receivables_flag = 'N'
903: THEN
900:
901: IF p_complete_flag = 'Y' and
902: l_true_open_receivables_flag = 'N'
903: THEN
904: arp_util.debug('calling validate_for_tax for open_rec=N trx');
905:
906: arp_etax_services_pkg.validate_for_tax(
907: p_customer_trx_id => p_customer_trx_id,
908: p_error_mode => 'STANDARD',
908: p_error_mode => 'STANDARD',
909: p_valid_for_tax => l_tax_validation_status,
910: p_number_of_errors=> l_error_count);
911:
912: arp_util.debug('num of etax validation errors = '||l_error_count);
913:
914: IF (l_error_count > 0)
915: THEN
916: app_exception.raise_exception;
917: END IF;
918: END IF;
919:
920: /* manishri, 08-Jun-2010. Bug 9693686 */
921: arp_util.debug('Resetting g_old_complete_flag of ARP_PROCESS_HEADER_UPDTE_COVER package to NULL');
922: ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag := NULL;
923: arp_util.debug('Old complete flag after reset = ' || NVL(ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag, 'NULL'));
924: /* End of change - manishri, 08-Jun-2010. Bug 9693686*/
925:
919:
920: /* manishri, 08-Jun-2010. Bug 9693686 */
921: arp_util.debug('Resetting g_old_complete_flag of ARP_PROCESS_HEADER_UPDTE_COVER package to NULL');
922: ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag := NULL;
923: arp_util.debug('Old complete flag after reset = ' || NVL(ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag, 'NULL'));
924: /* End of change - manishri, 08-Jun-2010. Bug 9693686*/
925:
926: arp_util.print_fcn_label( 'arp_process_header.post_commit()- ');
927:
922: ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag := NULL;
923: arp_util.debug('Old complete flag after reset = ' || NVL(ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag, 'NULL'));
924: /* End of change - manishri, 08-Jun-2010. Bug 9693686*/
925:
926: arp_util.print_fcn_label( 'arp_process_header.post_commit()- ');
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
926: arp_util.print_fcn_label( 'arp_process_header.post_commit()- ');
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
931:
932: arp_util.debug('');
933: arp_util.debug('---------- parameters for post_commit() ---------');
934:
928: EXCEPTION
929: WHEN OTHERS THEN
930: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
931:
932: arp_util.debug('');
933: arp_util.debug('---------- parameters for post_commit() ---------');
934:
935: arp_util.debug('p_form_name = ' ||
936: p_form_name);
929: WHEN OTHERS THEN
930: arp_util.debug('EXCEPTION: arp_process_header.post_commit()');
931:
932: arp_util.debug('');
933: arp_util.debug('---------- parameters for post_commit() ---------');
934:
935: arp_util.debug('p_form_name = ' ||
936: p_form_name);
937: arp_util.debug('p_form_version = ' ||
931:
932: arp_util.debug('');
933: arp_util.debug('---------- parameters for post_commit() ---------');
934:
935: arp_util.debug('p_form_name = ' ||
936: p_form_name);
937: arp_util.debug('p_form_version = ' ||
938: p_form_version);
939: arp_util.debug('p_customer_trx_id = ' ||
933: arp_util.debug('---------- parameters for post_commit() ---------');
934:
935: arp_util.debug('p_form_name = ' ||
936: p_form_name);
937: arp_util.debug('p_form_version = ' ||
938: p_form_version);
939: arp_util.debug('p_customer_trx_id = ' ||
940: p_customer_trx_id);
941: arp_util.debug('p_previous_customer_trx_id = ' ||
935: arp_util.debug('p_form_name = ' ||
936: p_form_name);
937: arp_util.debug('p_form_version = ' ||
938: p_form_version);
939: arp_util.debug('p_customer_trx_id = ' ||
940: p_customer_trx_id);
941: arp_util.debug('p_previous_customer_trx_id = ' ||
942: p_previous_customer_trx_id);
943: arp_util.debug('p_complete_flag = ' ||
937: arp_util.debug('p_form_version = ' ||
938: p_form_version);
939: arp_util.debug('p_customer_trx_id = ' ||
940: p_customer_trx_id);
941: arp_util.debug('p_previous_customer_trx_id = ' ||
942: p_previous_customer_trx_id);
943: arp_util.debug('p_complete_flag = ' ||
944: p_complete_flag);
945: arp_util.debug('p_trx_open_receivables_flag = ' ||
939: arp_util.debug('p_customer_trx_id = ' ||
940: p_customer_trx_id);
941: arp_util.debug('p_previous_customer_trx_id = ' ||
942: p_previous_customer_trx_id);
943: arp_util.debug('p_complete_flag = ' ||
944: p_complete_flag);
945: arp_util.debug('p_trx_open_receivables_flag = ' ||
946: p_trx_open_receivables_flag);
947: arp_util.debug('p_prev_open_receivables_flag = ' ||
941: arp_util.debug('p_previous_customer_trx_id = ' ||
942: p_previous_customer_trx_id);
943: arp_util.debug('p_complete_flag = ' ||
944: p_complete_flag);
945: arp_util.debug('p_trx_open_receivables_flag = ' ||
946: p_trx_open_receivables_flag);
947: arp_util.debug('p_prev_open_receivables_flag = ' ||
948: p_prev_open_receivables_flag);
949: arp_util.debug('p_creation_sign = ' ||
943: arp_util.debug('p_complete_flag = ' ||
944: p_complete_flag);
945: arp_util.debug('p_trx_open_receivables_flag = ' ||
946: p_trx_open_receivables_flag);
947: arp_util.debug('p_prev_open_receivables_flag = ' ||
948: p_prev_open_receivables_flag);
949: arp_util.debug('p_creation_sign = ' ||
950: p_creation_sign);
951: arp_util.debug('p_allow_overapplication_flag = ' ||
945: arp_util.debug('p_trx_open_receivables_flag = ' ||
946: p_trx_open_receivables_flag);
947: arp_util.debug('p_prev_open_receivables_flag = ' ||
948: p_prev_open_receivables_flag);
949: arp_util.debug('p_creation_sign = ' ||
950: p_creation_sign);
951: arp_util.debug('p_allow_overapplication_flag = ' ||
952: p_allow_overapplication_flag);
953: arp_util.debug('p_natural_application_flag = ' ||
947: arp_util.debug('p_prev_open_receivables_flag = ' ||
948: p_prev_open_receivables_flag);
949: arp_util.debug('p_creation_sign = ' ||
950: p_creation_sign);
951: arp_util.debug('p_allow_overapplication_flag = ' ||
952: p_allow_overapplication_flag);
953: arp_util.debug('p_natural_application_flag = ' ||
954: p_natural_application_flag);
955:
949: arp_util.debug('p_creation_sign = ' ||
950: p_creation_sign);
951: arp_util.debug('p_allow_overapplication_flag = ' ||
952: p_allow_overapplication_flag);
953: arp_util.debug('p_natural_application_flag = ' ||
954: p_natural_application_flag);
955:
956: RAISE;
957: