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_DEDUCTION dependencies on ARP_STANDARD

Line 59: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM');

55:
56: WHEN OTHERS THEN
57:
58: IF PG_DEBUG in ('Y','C') THEN
59: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM');
60: END IF;
61: RETURN FALSE;
62:
63: END CHECK_TM;

Line 113: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM_DEFAULT_SETUP');

109:
110: WHEN OTHERS THEN
111:
112: IF PG_DEBUG in ('Y','C') THEN
113: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM_DEFAULT_SETUP');
114: END IF;
115: RETURN FALSE;
116:
117: END CHECK_TM_DEFAULT_SETUP;

Line 524: arp_standard.debug('ARP_DEDUCTION.claim_creation()+');

520:
521: BEGIN
522:
523: IF PG_DEBUG in ('Y','C') THEN
524: arp_standard.debug('ARP_DEDUCTION.claim_creation()+');
525: END IF;
526:
527: IF (p_request_id IS NULL) THEN
528:

Line 536: arp_standard.debug('Invalid Argument - Request ID is Null');

532: ,'NULL'
533: );
534:
535: IF PG_DEBUG in ('Y','C') THEN
536: arp_standard.debug('Invalid Argument - Request ID is Null');
537: END IF;
538: RAISE invalid_param;
539:
540: END IF;

Line 554: arp_standard.debug('Open Cursor - get_claim_rec');

550: -- Begin Non TRX related claims processing
551: -- 1. Create Claim Investigation
552: ------------------------------------------
553: IF PG_DEBUG in ('Y','C') THEN
554: arp_standard.debug('Open Cursor - get_claim_rec');
555: END IF;
556:
557: OPEN get_claim_rec;
558: LOOP -- Loop thru get_claim_rec

Line 597: arp_standard.debug('get_claim_rec cursor RowCount = '||to_char(get_claim_rec%rowcount));

593: ,claim_tbl.apply_date
594: LIMIT l_bulk_fetch_rows;
595:
596: IF PG_DEBUG in ('Y','C') THEN
597: arp_standard.debug('get_claim_rec cursor RowCount = '||to_char(get_claim_rec%rowcount));
598: END IF;
599:
600: IF get_claim_rec%NOTFOUND THEN
601: l_last_fetch := TRUE;

Line 607: arp_standard.debug('Claim_Tbl.Rowid.Count = 0 and Last Fetch is TRUE');

603:
604: IF (claim_tbl.l_rowid.COUNT = 0) AND (l_last_fetch) THEN
605:
606: IF PG_DEBUG in ('Y','C') THEN
607: arp_standard.debug('Claim_Tbl.Rowid.Count = 0 and Last Fetch is TRUE');
608: END IF;
609: EXIT;
610:
611: END IF;

Line 640: arp_standard.debug('Open get_receipt_info');

636: ---------------------------------------------
637: -- Fetch Receipt Info for Claim Investigation
638: ---------------------------------------------
639: IF PG_DEBUG in ('Y','C') THEN
640: arp_standard.debug('Open get_receipt_info');
641: END IF;
642: OPEN get_receipt_info(claim_tbl.payment_schedule_id(i));
643: FETCH get_receipt_info INTO
644: l_cash_receipt_id

Line 657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));

653: ,l_legal_entity_id;
654: CLOSE get_receipt_info;
655:
656: IF PG_DEBUG in ('Y','C') THEN
657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));
658: arp_standard.debug('p_currency_code => '||l_currency_Code);
659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));
660: arp_standard.debug('p_trx_number => '||l_trx_number);
661: arp_standard.debug('p_receipt_number => '||l_receipt_number);

Line 658: arp_standard.debug('p_currency_code => '||l_currency_Code);

654: CLOSE get_receipt_info;
655:
656: IF PG_DEBUG in ('Y','C') THEN
657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));
658: arp_standard.debug('p_currency_code => '||l_currency_Code);
659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));
660: arp_standard.debug('p_trx_number => '||l_trx_number);
661: arp_standard.debug('p_receipt_number => '||l_receipt_number);
662: END IF;

Line 659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));

655:
656: IF PG_DEBUG in ('Y','C') THEN
657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));
658: arp_standard.debug('p_currency_code => '||l_currency_Code);
659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));
660: arp_standard.debug('p_trx_number => '||l_trx_number);
661: arp_standard.debug('p_receipt_number => '||l_receipt_number);
662: END IF;
663:

Line 660: arp_standard.debug('p_trx_number => '||l_trx_number);

656: IF PG_DEBUG in ('Y','C') THEN
657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));
658: arp_standard.debug('p_currency_code => '||l_currency_Code);
659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));
660: arp_standard.debug('p_trx_number => '||l_trx_number);
661: arp_standard.debug('p_receipt_number => '||l_receipt_number);
662: END IF;
663:
664: ----------------------------------------------

Line 661: arp_standard.debug('p_receipt_number => '||l_receipt_number);

657: arp_standard.debug('p_amount => '||to_char(claim_tbl.amount_applied(i)));
658: arp_standard.debug('p_currency_code => '||l_currency_Code);
659: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_tbl.payment_schedule_id(i)));
660: arp_standard.debug('p_trx_number => '||l_trx_number);
661: arp_standard.debug('p_receipt_number => '||l_receipt_number);
662: END IF;
663:
664: ----------------------------------------------
665: -- Call create_claim for Non Trx related claim

Line 715: arp_standard.debug('Short Pay DED # => '||claim_tbl.application_ref_num(i));

711: ,x_claim_reason_name => claim_tbl.claim_reason_name(i)
712: ,p_legal_entity_id => l_legal_entity_id
713: );
714: IF PG_DEBUG in ('Y','C') THEN
715: arp_standard.debug('Short Pay DED # => '||claim_tbl.application_ref_num(i));
716: END IF;
717:
718: ---------------------------------------------------------------------------
719: -- Check TM API Call return status. If E or U then initiate Failure recover

Line 742: arp_standard.debug('arp_deduction.claim_creation: Fetch amount_aplied from '

738: -- Amount applied from initial UNAPP record for the receipt
739: -- Used in the determination of full or partial recovery
740: ------------------------------------------------------------------
741: IF PG_DEBUG in ('Y','C') THEN
742: arp_standard.debug('arp_deduction.claim_creation: Fetch amount_aplied from '
743: ||'first UNAPP record for the receipt - Fail Recover');
744: END IF;
745: OPEN unapp_amt_rec(l_cash_receipt_id);
746: FETCH unapp_amt_rec into l_unapp_amt_appl;

Line 754: arp_standard.debug('arp_deduction.claim_creation: Fetch Sum amount_aplied '

750: -- SUM(Amount applied) from the Paired UNAPP records for the receipt
751: -- Used in the determination of full or partial recovery
752: ------------------------------------------------------------------
753: IF PG_DEBUG in ('Y','C') THEN
754: arp_standard.debug('arp_deduction.claim_creation: Fetch Sum amount_aplied '
755: ||'from the paired UNAPP records for the receipt - Fail Recover');
756: END IF;
757: OPEN pair_unapp_amt_rec(l_cash_receipt_id);
758: FETCH pair_unapp_amt_rec into l_sum_pair_unapp_amt_appl;

Line 773: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in Partial');

769: -------------------------------------------------------------
770: -- Claim creation in TM failed. Initiate Partial recovery process
771: -------------------------------------------------------------
772: IF PG_DEBUG in ('Y','C') THEN
773: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in Partial');
774: END IF;
775: arp_deduction.claim_create_fail_recover
776: (p_rapp_id => claim_tbl.receivable_application_id(i)
777: ,p_cr_id => l_cash_receipt_id

Line 783: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in FULL');

779:
780: ELSE -- Full Reversal
781:
782: IF PG_DEBUG in ('Y','C') THEN
783: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in FULL');
784: END IF;
785: FOR l_fail_rec in fail_rec_rapp_id(l_cash_receipt_id)
786: LOOP
787:

Line 813: arp_standard.debug('Error from jg_ar_receivable_applications.delete_interst_adjustment');

809: x_return_status => jg_return_status);
810:
811: IF jg_return_status <> FND_API.G_RET_STS_SUCCESS then
812: /* print an error message */
813: arp_standard.debug('Error from jg_ar_receivable_applications.delete_interst_adjustment');
814: END IF;
815:
816: END IF; -- IF l_unapp_amt_appl > l_sum_pair_unapp_amt_appl THEN
817:

Line 848: arp_standard.debug('Bulk Update RA with DED No, ID and translated oracle reason');

844: -----------------------------------------------------------------------
845: -- Update Receivable Application with claim number and claim id from TM
846: -----------------------------------------------------------------------
847: IF PG_DEBUG in ('Y','C') THEN
848: arp_standard.debug('Bulk Update RA with DED No, ID and translated oracle reason');
849: END IF;
850: FORALL i IN claim_tbl.l_rowid.FIRST .. claim_tbl.l_rowid.LAST
851: UPDATE ar_receivable_applications
852: SET secondary_application_ref_id = claim_tbl.secondary_application_ref_id(i)

Line 859: arp_standard.debug('Exit Loop for Processing Non Trx Related claims. Last Fetch');

855:
856: IF l_last_fetch THEN
857:
858: IF PG_DEBUG in ('Y','C') THEN
859: arp_standard.debug('Exit Loop for Processing Non Trx Related claims. Last Fetch');
860: END IF;
861: EXIT;
862:
863: END IF; --IF l_last_fetch

Line 876: arp_standard.debug('Determine to process Trx Related Claims');

872: -- Note: Subsequent receipt application for Over Pay, is for amount zero
873: -- which results in claim cancel. No Over Pay claim creation
874: ------------------------------------------------------------------------
875: IF PG_DEBUG in ('Y','C') THEN
876: arp_standard.debug('Determine to process Trx Related Claims');
877: END IF;
878:
879: IF p_matched_claim_creation_flag = 'Y' THEN
880:

Line 887: arp_standard.debug('Bulk fetch cursor get_ra_rec into ra_tbl');

883: OPEN get_ra_rec;
884: LOOP -- Loop thru cursor get_ra_rec
885:
886: IF PG_DEBUG in ('Y','C') THEN
887: arp_standard.debug('Bulk fetch cursor get_ra_rec into ra_tbl');
888: END IF;
889:
890: FETCH get_ra_rec BULK COLLECT INTO
891: ra_tbl.applied_payment_schedule_id

Line 897: arp_standard.debug('LAST Bulk fetch. Set l_last_fetch=TRUE');

893:
894: IF get_ra_rec%NOTFOUND THEN
895:
896: IF PG_DEBUG in ('Y','C') THEN
897: arp_standard.debug('LAST Bulk fetch. Set l_last_fetch=TRUE');
898: END IF;
899:
900: l_last_fetch := TRUE;
901:

Line 907: arp_standard.debug('Get_RA_Rec: Count = 0 and Last Bulk Fetch');

903:
904: IF (ra_tbl.applied_payment_schedule_id.COUNT = 0) AND (l_last_fetch) THEN
905:
906: IF PG_DEBUG in ('Y','C') THEN
907: arp_standard.debug('Get_RA_Rec: Count = 0 and Last Bulk Fetch');
908: END IF;
909: EXIT;
910:
911: END IF; --IF (ra_tbl.applied_payment_schedule_id.COUNT = 0) AND (l_last_fetch)

Line 921: arp_standard.debug('Processing Trx Related Claim Record = '||to_char(i)||'. Initialize');

917: ----------------------------
918: --Initialize Local Variables
919: ----------------------------
920: IF PG_DEBUG in ('Y','C') THEN
921: arp_standard.debug('Processing Trx Related Claim Record = '||to_char(i)||'. Initialize');
922: END IF;
923: l_customer_trx_id := NULL;
924: l_trx_number := NULL;
925: l_cust_trx_type_id := NULL;

Line 961: arp_standard.debug('Open cursor get_ps_rtx_info and fetch');

957: --Fetch PS and Trx info required to determine a short pay/over pay
958: --Continue claims processing only if the payment schedule CLASS<>PMT
959: --------------------------------------------------------------------
960: IF PG_DEBUG in ('Y','C') THEN
961: arp_standard.debug('Open cursor get_ps_rtx_info and fetch');
962: END IF;
963:
964: OPEN get_ps_trx_info(ra_tbl.applied_payment_schedule_id(i));
965: FETCH get_ps_trx_info INTO

Line 993: arp_standard.debug('Amount_due_remaining = '||to_char(l_amount_due_remaining));

989:
990: CLOSE get_ps_trx_info;
991:
992: IF PG_DEBUG in ('Y','C') THEN
993: arp_standard.debug('Amount_due_remaining = '||to_char(l_amount_due_remaining));
994: arp_standard.debug('Amount_due_original = '||to_char(l_amount_due_original));
995: arp_standard.debug('Class = '||l_class);
996: arp_standard.debug('Matched_claim_excl_cm = '||p_matched_claim_excl_cm_flag);
997: END IF;

Line 994: arp_standard.debug('Amount_due_original = '||to_char(l_amount_due_original));

990: CLOSE get_ps_trx_info;
991:
992: IF PG_DEBUG in ('Y','C') THEN
993: arp_standard.debug('Amount_due_remaining = '||to_char(l_amount_due_remaining));
994: arp_standard.debug('Amount_due_original = '||to_char(l_amount_due_original));
995: arp_standard.debug('Class = '||l_class);
996: arp_standard.debug('Matched_claim_excl_cm = '||p_matched_claim_excl_cm_flag);
997: END IF;
998:

Line 995: arp_standard.debug('Class = '||l_class);

991:
992: IF PG_DEBUG in ('Y','C') THEN
993: arp_standard.debug('Amount_due_remaining = '||to_char(l_amount_due_remaining));
994: arp_standard.debug('Amount_due_original = '||to_char(l_amount_due_original));
995: arp_standard.debug('Class = '||l_class);
996: arp_standard.debug('Matched_claim_excl_cm = '||p_matched_claim_excl_cm_flag);
997: END IF;
998:
999: ---------------------------------------------------------------

Line 996: arp_standard.debug('Matched_claim_excl_cm = '||p_matched_claim_excl_cm_flag);

992: IF PG_DEBUG in ('Y','C') THEN
993: arp_standard.debug('Amount_due_remaining = '||to_char(l_amount_due_remaining));
994: arp_standard.debug('Amount_due_original = '||to_char(l_amount_due_original));
995: arp_standard.debug('Class = '||l_class);
996: arp_standard.debug('Matched_claim_excl_cm = '||p_matched_claim_excl_cm_flag);
997: END IF;
998:
999: ---------------------------------------------------------------
1000: --Determine if amount due remaining for the payment schedule id

Line 1017: arp_standard.debug('Open cursor Get_Ra_info for '

1013: --------------------------------------------------------
1014: --Get RA Info Required for Trx Related Claims processing
1015: --------------------------------------------------------
1016: IF PG_DEBUG in ('Y','C') THEN
1017: arp_standard.debug('Open cursor Get_Ra_info for '
1018: ||'PS ID = '||to_char(claim_rec.payment_schedule_id));
1019: END IF;
1020: OPEN get_ra_info(ra_tbl.applied_payment_schedule_id(i));
1021: FETCH get_ra_info INTO

Line 1059: arp_standard.debug('Open cursor Get_receipt_num and fetch'

1055: ---------------------------------------------
1056: --Fetch Receipt Info - On TRX Related Claim.
1057: ---------------------------------------------
1058: IF PG_DEBUG in ('Y','C') THEN
1059: arp_standard.debug('Open cursor Get_receipt_num and fetch'
1060: ||'PS ID = '||to_char(claim_rec.payment_schedule_id));
1061: END IF;
1062: OPEN get_receipt_num(claim_rec.payment_schedule_id);
1063: FETCH get_receipt_num INTO

Line 1068: arp_standard.debug('Close cursor Get_receipt_num and fetch');

1064: l_cash_receipt_id
1065: ,l_receipt_number;
1066: CLOSE get_receipt_num;
1067: IF PG_DEBUG in ('Y','C') THEN
1068: arp_standard.debug('Close cursor Get_receipt_num and fetch');
1069: END IF;
1070:
1071: --------------------------------------------------------
1072: -- Claim Amount passed to TM is the amount_due_remaining

Line 1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));

1073: --------------------------------------------------------
1074: l_claim_amount := l_amount_due_remaining;
1075:
1076: IF PG_DEBUG in ('Y','C') THEN
1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));
1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);

Line 1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));

1074: l_claim_amount := l_amount_due_remaining;
1075:
1076: IF PG_DEBUG in ('Y','C') THEN
1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));
1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));

Line 1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));

1075:
1076: IF PG_DEBUG in ('Y','C') THEN
1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));
1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);

Line 1080: arp_standard.debug('p_trx_number => '||l_trx_number);

1076: IF PG_DEBUG in ('Y','C') THEN
1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));
1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);
1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);

Line 1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);

1077: arp_standard.debug('Claim Amount => '||to_char(l_claim_amount));
1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);
1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);
1085: END IF;

Line 1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));

1078: arp_standard.debug('p_customer_trx_id => '||to_char(l_customer_trx_id));
1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);
1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);
1085: END IF;
1086:

Line 1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);

1079: arp_standard.debug('p_invoice_ps_id => '||to_char(claim_rec.payment_schedule_id));
1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);
1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);
1085: END IF;
1086:
1087: ------------------------------------------------------------

Line 1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);

1080: arp_standard.debug('p_trx_number => '||l_trx_number);
1081: arp_standard.debug('p_customer_ref_number => '||claim_rec.customer_reference);
1082: arp_standard.debug('p_cash_receipt_id => '||to_char(l_cash_receipt_id));
1083: arp_standard.debug('p_receipt_number => '||l_receipt_number);
1084: arp_standard.debug('p_reason_id => '||claim_rec.application_ref_reason);
1085: END IF;
1086:
1087: ------------------------------------------------------------
1088: -- Retreive application info - Amount_Applied, Applied_Date

Line 1091: arp_standard.debug('Fetch application info for subsequent receipt application');

1087: ------------------------------------------------------------
1088: -- Retreive application info - Amount_Applied, Applied_Date
1089: ------------------------------------------------------------
1090: IF PG_DEBUG in ('Y','C') THEN
1091: arp_standard.debug('Fetch application info for subsequent receipt application');
1092: END IF;
1093: OPEN get_trx_app_info(ra_tbl.applied_payment_schedule_id(i));
1094: FETCH get_trx_app_info INTO l_amount_applied, l_applied_date;
1095: CLOSE get_trx_app_info;

Line 1106: arp_standard.debug('Call subsequent receipt API. Open claim exist in TM');

1102: IF (ozf_claim_grp.check_open_claims(l_customer_trx_id,l_cash_receipt_id)) THEN
1103:
1104: l_trx_claim_exist := 'Y'; -- OPEN Claim Exist in TM. Subsequent Receipt App in TM
1105: IF PG_DEBUG in ('Y','C') THEN
1106: arp_standard.debug('Call subsequent receipt API. Open claim exist in TM');
1107: END IF;
1108:
1109: ELSE -- Create TRX based Claim
1110: l_trx_claim_exist := 'N'; -- Claim Does Not Exist in TM. Claim Creation in TM

Line 1112: arp_standard.debug('Initiate Create Claim API. Open claim Does Not exist in TM');

1108:
1109: ELSE -- Create TRX based Claim
1110: l_trx_claim_exist := 'N'; -- Claim Does Not Exist in TM. Claim Creation in TM
1111: IF PG_DEBUG in ('Y','C') THEN
1112: arp_standard.debug('Initiate Create Claim API. Open claim Does Not exist in TM');
1113: END IF;
1114:
1115: END IF; --IF (ozf_claim_grp.check_open_claims(l_customer_trx_id,l_cash_receipt_id))
1116:

Line 1151: arp_standard.debug('Call Subsequent Receipt API. Open Claim exist in TM');

1147: -- 2. Insert TRX Notes in AR
1148: -- 3. Update amount_in_dispute in AR
1149: ---------------------------------------------------------
1150: IF PG_DEBUG in ('Y','C') THEN
1151: arp_standard.debug('Call Subsequent Receipt API. Open Claim exist in TM');
1152: END IF;
1153: arp_deduction.update_claim
1154: (p_claim_id => claim_rec.secondary_application_ref_id
1155: ,p_claim_number => claim_rec.application_ref_num

Line 1207: arp_standard.debug('Object Version Number => '||to_char(l_object_version_number));

1203: ,x_claim_number => claim_rec.application_ref_num
1204: );
1205:
1206: IF PG_DEBUG in ('Y','C') THEN
1207: arp_standard.debug('Object Version Number => '||to_char(l_object_version_number));
1208: END IF;
1209:
1210: ELSE -- Open Claim does not exist in TM
1211:

Line 1223: arp_standard.debug('Call Create Claim API - Short Pay. No Open Claim exist');

1219: -- 2. Insert into AR TRX Notes
1220: -- 3. Update amount_in_dispute in AR
1221: ---------------------------------------------
1222: IF PG_DEBUG in ('Y','C') THEN
1223: arp_standard.debug('Call Create Claim API - Short Pay. No Open Claim exist');
1224: END IF;
1225: arp_process_application.create_claim
1226: (p_amount => l_claim_amount
1227: ,p_amount_applied => l_amount_applied

Line 1274: arp_standard.debug('Short Pay DED # => '||claim_rec.application_ref_num);

1270: ,p_legal_entity_id => l_legal_entity_id
1271: );
1272:
1273: IF PG_DEBUG in ('Y','C') THEN
1274: arp_standard.debug('Short Pay DED # => '||claim_rec.application_ref_num);
1275: END IF;
1276:
1277: ELSE -- Over Pay Claim
1278: IF PG_DEBUG in ('Y','C') THEN

Line 1279: arp_standard.debug('Over Pay condition - Claim will not be created.');

1275: END IF;
1276:
1277: ELSE -- Over Pay Claim
1278: IF PG_DEBUG in ('Y','C') THEN
1279: arp_standard.debug('Over Pay condition - Claim will not be created.');
1280: END IF;
1281: RAISE skip_overpay_create;
1282:
1283: END IF; --IF l_trx_claim_type = 'S' THEN

Line 1303: arp_standard.debug('Update PS with active_claim_flag = C');

1299: OR ((l_trx_claim_exist = 'Y') AND (l_claim_amount = 0))
1300: ) THEN
1301:
1302: IF PG_DEBUG in ('Y','C') THEN
1303: arp_standard.debug('Update PS with active_claim_flag = C');
1304: END IF;
1305: arp_deduction.update_claim_create_status
1306: (p_ps_id => claim_rec.applied_payment_schedule_id
1307: ,p_claim_status => l_claim_status

Line 1321: arp_standard.debug('Update RA with Ded No,Ded ID,Type,receivables_trx_id');

1317: OR (l_trx_claim_exist = 'Y')
1318: ) THEN
1319:
1320: IF PG_DEBUG in ('Y','C') THEN
1321: arp_standard.debug('Update RA with Ded No,Ded ID,Type,receivables_trx_id');
1322: END IF;
1323: UPDATE ar_receivable_applications
1324: SET secondary_application_ref_id = claim_rec.secondary_application_ref_id
1325: ,application_ref_num = claim_rec.application_ref_num

Line 1348: arp_standard.debug('EXCEPTION - TM API : OZF_Claim_GRP ');

1344: END IF;
1345:
1346: l_claim_status := 'N';
1347: IF PG_DEBUG in ('Y','C') THEN
1348: arp_standard.debug('EXCEPTION - TM API : OZF_Claim_GRP ');
1349: END IF;
1350:
1351: --------------------------------------------------
1352: -- Write Failure Message to Concurrent Request Log

Line 1395: arp_standard.debug('EXCEPTION - Skip_overpay_create : Trx Related - '||

1391: EXCEPTION
1392: WHEN skip_overpay_create THEN
1393:
1394: IF PG_DEBUG in ('Y', 'C') THEN
1395: arp_standard.debug('EXCEPTION - Skip_overpay_create : Trx Related - '||
1396: 'Over Pay claim doesnot exist in TM.');
1397: END IF;
1398:
1399: WHEN skip_pmt_record THEN

Line 1402: arp_standard.debug('EXCEPTION - Skip_PMT_Record : Non Trx Related - '||

1398:
1399: WHEN skip_pmt_record THEN
1400:
1401: IF PG_DEBUG in ('Y', 'C') THEN
1402: arp_standard.debug('EXCEPTION - Skip_PMT_Record : Non Trx Related - '||
1403: 'Payment Schedule CLASS=PMT. Skip processing this record.');
1404: END IF;
1405:
1406: END;

Line 1413: arp_standard.debug('l_last_fetch=TRUE. Exit Loop for processing Non Trx claims');

1409: --If Recent Fetch is Last then exit loop
1410: IF l_last_fetch THEN
1411:
1412: IF PG_DEBUG in ('Y', 'C') THEN
1413: arp_standard.debug('l_last_fetch=TRUE. Exit Loop for processing Non Trx claims');
1414: END IF;
1415: EXIT;
1416:
1417: END IF; --IF l_last_fetch

Line 1425: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');

1421:
1422: END IF; --IF p_matched_claim_creation_flag = 'Y' THEN
1423:
1424: IF PG_DEBUG in ('Y','C') THEN
1425: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');
1426: END IF;
1427:
1428: EXCEPTION
1429: WHEN invalid_param THEN

Line 1432: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');

1428: EXCEPTION
1429: WHEN invalid_param THEN
1430:
1431: IF PG_DEBUG in ('Y', 'C') THEN
1432: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');
1433: END IF;
1434: RAISE;
1435:
1436: WHEN OTHERS THEN

Line 1439: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');

1435:
1436: WHEN OTHERS THEN
1437:
1438: IF PG_DEBUG in ('Y', 'C') THEN
1439: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');
1440: END IF;
1441: RAISE;
1442:
1443: END claim_creation;

Line 1532: arp_standard.debug('update_action: ' || 'arp_deduction.update_claim()+' );

1528:
1529: BEGIN
1530:
1531: IF PG_DEBUG in ('Y', 'C') THEN
1532: arp_standard.debug('update_action: ' || 'arp_deduction.update_claim()+' );
1533: END IF;
1534:
1535: x_return_status := 'S';
1536: l_claim_rec.claim_id := p_claim_id;

Line 1610: arp_standard.debug('insert_trx_notes: arp_deduction.update_claim');

1606: --------------------
1607: -- Insert Trx Notes
1608: --------------------
1609: IF PG_DEBUG in ('Y', 'C') THEN
1610: arp_standard.debug('insert_trx_notes: arp_deduction.update_claim');
1611: END IF;
1612:
1613: l_text := 'RECEIPT_NUM : '||p_receipt_number||' CLAIM_NUM : '
1614: ||p_claim_number||' TRX_NUM : '||p_trx_number;

Line 1616: l_user_id := arp_standard.profile.user_id;

1612:
1613: l_text := 'RECEIPT_NUM : '||p_receipt_number||' CLAIM_NUM : '
1614: ||p_claim_number||' TRX_NUM : '||p_trx_number;
1615:
1616: l_user_id := arp_standard.profile.user_id;
1617: l_last_update_login := arp_standard.profile.last_update_login;
1618: l_sysdate := SYSDATE;
1619:
1620: arp_notes_pkg.insert_cover(

Line 1617: l_last_update_login := arp_standard.profile.last_update_login;

1613: l_text := 'RECEIPT_NUM : '||p_receipt_number||' CLAIM_NUM : '
1614: ||p_claim_number||' TRX_NUM : '||p_trx_number;
1615:
1616: l_user_id := arp_standard.profile.user_id;
1617: l_last_update_login := arp_standard.profile.last_update_login;
1618: l_sysdate := SYSDATE;
1619:
1620: arp_notes_pkg.insert_cover(
1621: p_note_type => 'MAINTAIN',

Line 1635: arp_standard.debug('insert_trx_notes: Note ID = '||to_char(l_note_id));

1631: p_created_by => l_user_id,
1632: p_creation_date => l_sysdate);
1633:
1634: IF PG_DEBUG in ('Y', 'C') THEN
1635: arp_standard.debug('insert_trx_notes: Note ID = '||to_char(l_note_id));
1636: END IF;
1637:
1638: --
1639: -- Update TRX Amount in Dispute

Line 1642: arp_standard.debug('put_trx_in_dispute: arp_deduction.update_claim');

1638: --
1639: -- Update TRX Amount in Dispute
1640: --
1641: IF PG_DEBUG in ('Y', 'C') THEN
1642: arp_standard.debug('put_trx_in_dispute: arp_deduction.update_claim');
1643: END IF;
1644: arp_process_application.update_dispute_on_trx
1645: (p_invoice_ps_id
1646: ,'Y' --p_active_claim

Line 1661: arp_standard.debug('update_action: arp_deduction.update_claim()-');

1657:
1658: END IF; --IF l_return_status = FND_API.G_RET_STS_SUCCESS
1659:
1660: IF PG_DEBUG in ('Y', 'C') THEN
1661: arp_standard.debug('update_action: arp_deduction.update_claim()-');
1662: END IF;
1663:
1664: EXCEPTION
1665: WHEN OTHERS THEN

Line 1667: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');

1663:
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: IF PG_DEBUG in ('Y', 'C') THEN
1667: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');
1668: END IF;
1669: RAISE;
1670:
1671: END update_claim;

Line 1769: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );

1765:
1766: BEGIN
1767:
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );
1770: END IF;
1771: x_return_status := FND_API.G_RET_STS_SUCCESS;
1772:
1773: IF PG_DEBUG in ('Y', 'C') THEN

Line 1774: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));

1770: END IF;
1771: x_return_status := FND_API.G_RET_STS_SUCCESS;
1772:
1773: IF PG_DEBUG in ('Y', 'C') THEN
1774: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
1775: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );
1776: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );
1777: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );
1778: END IF;

Line 1775: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );

1771: x_return_status := FND_API.G_RET_STS_SUCCESS;
1772:
1773: IF PG_DEBUG in ('Y', 'C') THEN
1774: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
1775: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );
1776: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );
1777: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );
1778: END IF;
1779:

Line 1776: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );

1772:
1773: IF PG_DEBUG in ('Y', 'C') THEN
1774: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
1775: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );
1776: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );
1777: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );
1778: END IF;
1779:
1780: -- ---------------------------------------------------------------------

Line 1777: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );

1773: IF PG_DEBUG in ('Y', 'C') THEN
1774: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
1775: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );
1776: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );
1777: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );
1778: END IF;
1779:
1780: -- ---------------------------------------------------------------------
1781: -- Prepare for 'ACC' and 'OTHER ACC' record insertion with +ve amount applied

Line 1855: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');

1851: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
1852:
1853: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
1854:
1855: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');
1856:
1857: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
1858: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
1859:

Line 1865: arp_standard.debug('Processessed following RA row :receivable_application_id : '|| l_ra_rec.receivable_application_id);

1861: l_xla_ev_rec.xla_call := 'B';
1862: l_xla_ev_rec.xla_doc_table := 'APP';
1863: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1864:
1865: arp_standard.debug('Processessed following RA row :receivable_application_id : '|| l_ra_rec.receivable_application_id);
1866:
1867: END IF;
1868:
1869: ------------------------------------------------------------------------

Line 1919: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');

1915: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
1916:
1917: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
1918:
1919: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');
1920:
1921: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
1922: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
1923:

Line 1929: arp_standard.debug('Processessed following RA row :receivable_application_id : '|| l_ra_rec.receivable_application_id);

1925: l_xla_ev_rec.xla_call := 'B';
1926: l_xla_ev_rec.xla_doc_table := 'APP';
1927: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1928:
1929: arp_standard.debug('Processessed following RA row :receivable_application_id : '|| l_ra_rec.receivable_application_id);
1930:
1931: END IF;
1932:
1933: ------------------------------------------------------------------------

Line 1950: arp_standard.debug('arp_deduction.create_claims_rapp_dist()-' );

1946: l_ae_doc_rec.other_flag := 'PAIR';
1947: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1948:
1949: IF PG_DEBUG in ('Y', 'C') THEN
1950: arp_standard.debug('arp_deduction.create_claims_rapp_dist()-' );
1951: END IF;
1952:
1953: EXCEPTION
1954: WHEN OTHERS THEN

Line 1957: arp_standard.debug('EXCEPTION: arp_deduction.create_claims_rapp_dist()-');

1953: EXCEPTION
1954: WHEN OTHERS THEN
1955:
1956: IF PG_DEBUG in ('Y', 'C') THEN
1957: arp_standard.debug('EXCEPTION: arp_deduction.create_claims_rapp_dist()-');
1958: END IF;
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: arp_deduction.conc_req_log_msg

Line 2046: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );

2042:
2043: BEGIN
2044:
2045: IF PG_DEBUG in ('Y', 'C') THEN
2046: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );
2047: END IF;
2048:
2049: IF PG_DEBUG in ('Y', 'C') THEN
2050: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));

Line 2050: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));

2046: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );
2047: END IF;
2048:
2049: IF PG_DEBUG in ('Y', 'C') THEN
2050: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));
2051: arp_standard.debug('p_receipt_id = '||TO_CHAR(p_cr_id));
2052: END IF;
2053:
2054: ------------------------------------------------------------------

Line 2051: arp_standard.debug('p_receipt_id = '||TO_CHAR(p_cr_id));

2047: END IF;
2048:
2049: IF PG_DEBUG in ('Y', 'C') THEN
2050: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));
2051: arp_standard.debug('p_receipt_id = '||TO_CHAR(p_cr_id));
2052: END IF;
2053:
2054: ------------------------------------------------------------------
2055: -- Loop through the RA ('APP' OR 'OTHER ACC') and UNAPP For Delete

Line 2116: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );

2112: p_mode => 'SINGLE',
2113: p_key_value => ln_ra_id);
2114:
2115: IF PG_DEBUG in ('Y', 'C') THEN
2116: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );
2117: END IF;
2118:
2119: EXCEPTION
2120:

Line 2123: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );

2119: EXCEPTION
2120:
2121: WHEN OTHERS THEN
2122: IF PG_DEBUG IN ('Y', 'C') THEN
2123: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );
2124: END IF;
2125: RAISE;
2126:
2127: END claim_create_fail_recover;

Line 2176: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');

2172: EXCEPTION
2173: WHEN OTHERS THEN
2174:
2175: IF PG_DEBUG in ('Y', 'C') THEN
2176: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');
2177: END IF;
2178: RETURN NULL;
2179:
2180: END GET_FUNCTIONAL_CURRENCY;

Line 2217: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );

2213:
2214: BEGIN
2215:
2216: IF PG_DEBUG in ('Y', 'C') THEN
2217: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );
2218: END IF;
2219:
2220: SELECT rt.receivables_trx_id
2221: INTO l_receivables_trx_id

Line 2231: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()-' );

2227: AND cr.cash_receipt_id = p_cash_receipt_id
2228: AND rma.primary_flag = 'Y' );
2229:
2230: IF PG_DEBUG in ('Y', 'C') THEN
2231: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()-' );
2232: END IF;
2233:
2234: RETURN l_receivables_trx_id;
2235:

Line 2239: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');

2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: IF PG_DEBUG in ('Y', 'C') THEN
2239: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');
2240: END IF;
2241: RETURN NULL;
2242:
2243: END GET_RECEIVABLES_TRX_ID;

Line 2290: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');

2286:
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: IF PG_DEBUG in ('Y', 'C') THEN
2290: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');
2291: END IF;
2292: RAISE;
2293:
2294: END UPDATE_CLAIM_CREATE_STATUS;

Line 2415: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()+' );

2411:
2412: BEGIN
2413:
2414: IF PG_DEBUG in ('Y', 'C') THEN
2415: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()+' );
2416: END IF;
2417:
2418: IF (p_rapp_id IS NOT NULL) AND (p_cr_id IS NOT NULL) THEN --'On Account'
2419:

Line 2442: arp_standard.debug('Invalid Argument - p_rapp_id is Null');

2438: ,'NULL'
2439: );
2440:
2441: IF PG_DEBUG in ('Y','C') THEN
2442: arp_standard.debug('Invalid Argument - p_rapp_id is Null');
2443: END IF;
2444:
2445: l_return := NULL;
2446: RAISE invalid_param;

Line 2466: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()-' );

2462:
2463: END IF; -- IF ( SIGN(ln_amount_applied * -1) = SIGN(p_amount) )
2464:
2465: IF PG_DEBUG in ('Y', 'C') THEN
2466: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()-' );
2467: END IF;
2468:
2469: RETURN (l_return);
2470:

Line 2475: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CHECK_APP_VIOLATE');

2471: EXCEPTION
2472: WHEN invalid_param THEN
2473:
2474: IF PG_DEBUG in ('Y', 'C') THEN
2475: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2476: END IF;
2477: RETURN(l_return);
2478:
2479: WHEN OTHERS THEN

Line 2482: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_APP_VIOLATE');

2478:
2479: WHEN OTHERS THEN
2480:
2481: IF PG_DEBUG in ('Y', 'C') THEN
2482: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2483: END IF;
2484: RETURN(l_return);
2485:
2486: END CHECK_APP_VIOLATE;

Line 2547: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');

2543: EXCEPTION
2544: WHEN OTHERS THEN
2545:
2546: IF PG_DEBUG in ('Y', 'C') THEN
2547: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');
2548: END IF;
2549: RETURN NULL;
2550:
2551: END GET_TM_ORACLE_REASON;

Line 2769: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');

2765:
2766: BEGIN
2767:
2768: IF PG_DEBUG in ('Y', 'C') THEN
2769: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');
2770: END IF;
2771:
2772: ---------------------------------------------------------------
2773: -- Fetch open_cash_receipt_id using applied_payment_schedule_id

Line 2781: arp_standard.debug('No Data Found : Invalid p_applied_payment_schedule_id');

2777: FETCH get_open_cr_id into l_open_cash_receipt_id ,l_open_receipt_number;
2778:
2779: IF get_open_cr_id%NOTFOUND THEN
2780: IF PG_DEBUG IN ('Y','C') THEN
2781: arp_standard.debug('No Data Found : Invalid p_applied_payment_schedule_id');
2782: END IF;
2783: CLOSE get_open_cr_id;
2784: RAISE invalid_param;
2785:

Line 2801: arp_standard.debug('Invalid Argument - Applied Payment Schedule ID IS NULL');

2797: ,'NULL'
2798: );
2799:
2800: IF PG_DEBUG IN ('Y','C') THEN
2801: arp_standard.debug('Invalid Argument - Applied Payment Schedule ID IS NULL');
2802: END IF;
2803: RAISE invalid_param;
2804:
2805: END IF; --IF (p_applied_payment_schedule_id IS NOT NULL)

Line 2945: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');

2941:
2942: END IF; --IF l_process = 'Y' THEN
2943:
2944: IF PG_DEBUG in ('Y','C') THEN
2945: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');
2946: END IF;
2947:
2948: EXCEPTION
2949: WHEN invalid_param THEN

Line 2954: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');

2950:
2951: x_return_status := FND_API.G_RET_STS_ERROR;
2952:
2953: IF PG_DEBUG in ('Y','C') THEN
2954: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');
2955: END IF;
2956:
2957: RAISE;
2958:

Line 3017: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');

3013: EXCEPTION
3014: WHEN OTHERS THEN
3015:
3016: IF PG_DEBUG in ('Y', 'C') THEN
3017: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');
3018: END IF;
3019: RETURN NULL;
3020:
3021: END GET_ACTIVE_CLAIM_FLAG;

Line 3056: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');

3052: EXCEPTION
3053: WHEN NO_DATA_FOUND THEN
3054:
3055: IF PG_DEBUG in ('Y', 'C') THEN
3056: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3057: END IF;
3058: RAISE;
3059:
3060: WHEN OTHERS THEN

Line 3063: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');

3059:
3060: WHEN OTHERS THEN
3061:
3062: IF PG_DEBUG in ('Y', 'C') THEN
3063: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3064: END IF;
3065: RAISE;
3066:
3067: END ARP_DEDUCTION;