DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on ARP_UTIL

Line 469: arp_util.debug('CALLING group_and_validate_receipts ()+');

465:
466:
467: IF G_ERROR = 'N' THEN
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_util.debug('CALLING group_and_validate_receipts ()+');
470: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
471: END IF;
472:
473:

Line 481: arp_util.debug('END group_and_validate_receipts ()+');

477: );
478:
479:
480: IF PG_DEBUG in ('Y', 'C') THEN
481: arp_util.debug('END group_and_validate_receipts ()+');
482: END IF;
483:
484: END IF;
485: /* CALL TO APPLY API FROM MAIN START */

Line 487: arp_util.debug('value of G_ERROR ' || G_ERROR );

483:
484: END IF;
485: /* CALL TO APPLY API FROM MAIN START */
486:
487: arp_util.debug('value of G_ERROR ' || G_ERROR );
488: arp_util.debug('value of receipt_method_id ' || l_receipt_method_id );
489:
490:
491: BEGIN

Line 488: arp_util.debug('value of receipt_method_id ' || l_receipt_method_id );

484: END IF;
485: /* CALL TO APPLY API FROM MAIN START */
486:
487: arp_util.debug('value of G_ERROR ' || G_ERROR );
488: arp_util.debug('value of receipt_method_id ' || l_receipt_method_id );
489:
490:
491: BEGIN
492:

Line 504: arp_util.debug('ERROR before apply ' || SQLERRM );

500:
501:
502:
503: EXCEPTION WHEN OTHERS Then
504: arp_util.debug('ERROR before apply ' || SQLERRM );
505: G_ERROR := 'Y';
506: END;
507:
508:

Line 515: arp_util.debug('Calling APPLY API ()+');

511: BEGIN
512:
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_standard.debug('l_called_from'|| l_called_from);
515: arp_util.debug('Calling APPLY API ()+');
516: END IF;
517:
518: FOR PS IN c2 LOOP
519:

Line 551: arp_util.debug('x_return_status: '||al_return_status);

547: p_amount_applied =>PS.amt,
548: p_called_from => l_called_from
549: );
550:
551: arp_util.debug('x_return_status: '||al_return_status);
552:
553: IF al_return_status <> 'S' THEN
554:
555: l_apply_fail := 'Y' ;

Line 559: arp_util.debug('al_msg_data '||al_msg_data);

555: l_apply_fail := 'Y' ;
556:
557: IF al_msg_count = 1 Then
558:
559: arp_util.debug('al_msg_data '||al_msg_data);
560:
561: insert_exceptions(
562: p_batch_id =>o_batch_id,
563: p_request_id =>l_request_id,

Line 659: arp_util.debug('Calling process payment ()+');

655: BEGIN
656:
657: IF PG_DEBUG in ('Y', 'C') THEN
658: arp_standard.debug('l_called_from'|| l_called_from);
659: arp_util.debug('Calling process payment ()+');
660: END IF;
661:
662:
663: l_last_updated_by := arp_standard.profile.last_update_login ;

Line 692: arp_util.debug('Process_payment return status: ' || pl_return_status);

688: x_return_status => pl_return_status,
689: p_payment_trxn_extension_id => CREC.pmt_trxn_id);
690:
691: IF PG_DEBUG in ('Y', 'C') THEN
692: arp_util.debug('Process_payment return status: ' || pl_return_status);
693: END IF;
694:
695: /*------------------------------------------------------+
696: | Check the return status from Process_Payment |

Line 704: arp_util.debug('pl_msg_data '||pl_msg_data);

700: l_pay_process_fail := 'Y';
701:
702: IF pl_msg_count = 1 Then
703:
704: arp_util.debug('pl_msg_data '||pl_msg_data);
705:
706:
707: insert_exceptions(
708: p_batch_id =>o_batch_id,

Line 805: arp_util.debug('updating the receipts created ()+');

801:
802: BEGIN
803:
804: IF PG_DEBUG in ('Y', 'C') THEN
805: arp_util.debug('updating the receipts created ()+');
806: END IF;
807:
808:
809: l_created_by := arp_standard.profile.user_id ;

Line 924: arp_util.debug('calling the report- batch_id format ' || o_batch_id);

920: END IF;
921:
922: /* START FORMATTING */
923: IF l_format_flag = 'Y' THEN
924: arp_util.debug('calling the report- batch_id format ' || o_batch_id);
925: submit_format ( p_batch_id =>o_batch_id);
926: END IF;
927:
928: /* END FORMATTING */

Line 935: arp_util.debug('Finished updating AND COMITTING complete receipts' );

931: COMMIT;
932:
933:
934: IF PG_DEBUG in ('Y', 'C') THEN
935: arp_util.debug('Finished updating AND COMITTING complete receipts' );
936: END IF;
937:
938:
939:

Line 943: arp_util.debug('Exception : updating complete receipts '|| SQLERRM);

939:
940: EXCEPTION
941: WHEN others THEN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_util.debug('Exception : updating complete receipts '|| SQLERRM);
944: END IF;
945:
946: END ;
947:

Line 963: arp_util.debug('Exception : autorecapi() '|| SQLERRM);

959:
960: EXCEPTION
961: WHEN others THEN
962: IF PG_DEBUG in ('Y', 'C') THEN
963: arp_util.debug('Exception : autorecapi() '|| SQLERRM);
964: END IF;
965: raise;
966:
967: END get_parameters;

Line 4316: arp_util.debug('Submit Report ...OTHERS');

4312: from ar_batches_all
4313: where batch_id = p_batch_id;
4314: EXCEPTION
4315: when others then
4316: arp_util.debug('Submit Report ...OTHERS');
4317: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
4318: END;
4319: end if;
4320:

Line 4572: arp_util.debug('Calling UNAPP ()+');

4568: BEGIN
4569:
4570: IF PG_DEBUG in ('Y', 'C') THEN
4571: arp_standard.debug('l_called_from'|| l_called_from);
4572: arp_util.debug('Calling UNAPP ()+');
4573: END IF;
4574:
4575:
4576:

Line 4606: arp_util.debug('x_return_status: '||ul_return_status);

4602: p_applied_payment_schedule_id =>PS.ps_id,
4603: p_called_from => l_called_from
4604: );
4605:
4606: arp_util.debug('x_return_status: '||ul_return_status);
4607:
4608:
4609: IF ul_return_status <> 'S' THEN
4610:

Line 4613: arp_util.debug('ul_msg_data '||ul_msg_data);

4609: IF ul_return_status <> 'S' THEN
4610:
4611: IF ul_msg_count = 1 Then
4612:
4613: arp_util.debug('ul_msg_data '||ul_msg_data);
4614:
4615: ELSIF ul_msg_count > 1 Then
4616:
4617: LOOP

Line 4641: arp_util.debug('Exception :In the UNAPPLY routine '|| SQLERRM);

4637:
4638: EXCEPTION
4639: WHEN others THEN
4640: IF PG_DEBUG in ('Y', 'C') THEN
4641: arp_util.debug('Exception :In the UNAPPLY routine '|| SQLERRM);
4642: END IF;
4643:
4644: END ;
4645:

Line 4866: arp_util.debug('Submit Format ...OTHERS');

4862: from ar_batches_all
4863: where batch_id = p_batch_id;
4864: EXCEPTION
4865: when others then
4866: arp_util.debug('Submit Format ...OTHERS');
4867: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
4868: END;
4869: end if;
4870:

Line 4891: arp_util.debug('Format Program has a phase '||dev_phase);

4887: dev_status =>dev_status,
4888: message =>message);
4889:
4890: IF dev_phase <> 'COMPLETE' THEN
4891: arp_util.debug('Format Program has a phase '||dev_phase);
4892: update ar_batches SET
4893: batch_applied_status = 'COMPLETED_APPROVAL'
4894: where batch_id = p_batch_id;
4895: ELSIF dev_phase = 'COMPLETE'

Line 4897: arp_util.debug('Format Program completed with status '||dev_status);

4893: batch_applied_status = 'COMPLETED_APPROVAL'
4894: where batch_id = p_batch_id;
4895: ELSIF dev_phase = 'COMPLETE'
4896: AND dev_status <> 'NORMAL' THEN
4897: arp_util.debug('Format Program completed with status '||dev_status);
4898: update ar_batches SET
4899: batch_applied_status = 'COMPLETED_APPROVAL'
4900: where batch_id = p_batch_id;
4901: ELSE

Line 4902: arp_util.debug('Format Program completed successfully');

4898: update ar_batches SET
4899: batch_applied_status = 'COMPLETED_APPROVAL'
4900: where batch_id = p_batch_id;
4901: ELSE
4902: arp_util.debug('Format Program completed successfully');
4903: update ar_batches SET
4904: batch_applied_status = 'COMPLETED_FORMAT'
4905: where batch_id = p_batch_id;
4906: END IF;