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 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: /*Bug 8584950: OZF procedure verifies l_applied_receipt_id value*/
1072: l_applied_receipt_id := l_cash_receipt_id ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1425:
1426: END IF; --IF p_matched_claim_creation_flag = 'Y' THEN
1427:
1428: IF PG_DEBUG in ('Y','C') THEN
1429: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');
1430: END IF;
1431:
1432: EXCEPTION
1433: WHEN invalid_param THEN

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

1432: EXCEPTION
1433: WHEN invalid_param THEN
1434:
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');
1437: END IF;
1438: RAISE;
1439:
1440: WHEN OTHERS THEN

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

1439:
1440: WHEN OTHERS THEN
1441:
1442: IF PG_DEBUG in ('Y', 'C') THEN
1443: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');
1444: END IF;
1445: RAISE;
1446:
1447: END claim_creation;

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

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

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

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

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

1616:
1617: l_text := 'RECEIPT_NUM : '||p_receipt_number||' CLAIM_NUM : '
1618: ||p_claim_number||' TRX_NUM : '||p_trx_number;
1619:
1620: l_user_id := arp_standard.profile.user_id;
1621: l_last_update_login := arp_standard.profile.last_update_login;
1622: l_sysdate := SYSDATE;
1623:
1624: arp_notes_pkg.insert_cover(

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

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

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

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

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

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

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

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

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

1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: IF PG_DEBUG in ('Y', 'C') THEN
1671: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');
1672: END IF;
1673: RAISE;
1674:
1675: END update_claim;

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

1769:
1770: BEGIN
1771:
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN

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

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

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

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

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

1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_standard.debug('p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
1779: arp_standard.debug('p_amount_applied = '||TO_CHAR( p_amount_applied ) );
1780: --arp_standard.debug('p_gl_date = '|| TO_CHAR( p_gl_date ) );
1781: --arp_standard.debug('p_apply_date = '|| TO_CHAR( p_apply_date ) );
1782: END IF;
1783:
1784: -- ---------------------------------------------------------------------

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

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

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

1855: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
1856:
1857: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
1858:
1859: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');
1860:
1861: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
1862: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
1863:

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

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

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

1919: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
1920:
1921: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
1922:
1923: arp_standard.debug('Before calling ARP_XLA_EVENTS.create_events....');
1924:
1925: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
1926: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
1927:

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

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

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

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

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

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

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

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

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

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

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

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

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

2116: p_mode => 'SINGLE',
2117: p_key_value => ln_ra_id);
2118:
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );
2121: END IF;
2122:
2123: EXCEPTION
2124:

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

2123: EXCEPTION
2124:
2125: WHEN OTHERS THEN
2126: IF PG_DEBUG IN ('Y', 'C') THEN
2127: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );
2128: END IF;
2129: RAISE;
2130:
2131: END claim_create_fail_recover;

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

2176: EXCEPTION
2177: WHEN OTHERS THEN
2178:
2179: IF PG_DEBUG in ('Y', 'C') THEN
2180: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');
2181: END IF;
2182: RETURN NULL;
2183:
2184: END GET_FUNCTIONAL_CURRENCY;

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

2217:
2218: BEGIN
2219:
2220: IF PG_DEBUG in ('Y', 'C') THEN
2221: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );
2222: END IF;
2223:
2224: SELECT rt.receivables_trx_id
2225: INTO l_receivables_trx_id

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

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

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

2239:
2240: EXCEPTION
2241: WHEN OTHERS THEN
2242: IF PG_DEBUG in ('Y', 'C') THEN
2243: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');
2244: END IF;
2245: RETURN NULL;
2246:
2247: END GET_RECEIVABLES_TRX_ID;

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

2290:
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: IF PG_DEBUG in ('Y', 'C') THEN
2294: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');
2295: END IF;
2296: RAISE;
2297:
2298: END UPDATE_CLAIM_CREATE_STATUS;

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

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

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

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

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

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

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

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

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

2482:
2483: WHEN OTHERS THEN
2484:
2485: IF PG_DEBUG in ('Y', 'C') THEN
2486: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2487: END IF;
2488: RETURN(l_return);
2489:
2490: END CHECK_APP_VIOLATE;

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

2548: EXCEPTION
2549: WHEN OTHERS THEN
2550:
2551: IF PG_DEBUG in ('Y', 'C') THEN
2552: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');
2553: END IF;
2554: RETURN NULL;
2555:
2556: END GET_TM_ORACLE_REASON;

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

2770:
2771: BEGIN
2772:
2773: IF PG_DEBUG in ('Y', 'C') THEN
2774: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');
2775: END IF;
2776:
2777: ---------------------------------------------------------------
2778: -- Fetch open_cash_receipt_id using applied_payment_schedule_id

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

2782: FETCH get_open_cr_id into l_open_cash_receipt_id ,l_open_receipt_number;
2783:
2784: IF get_open_cr_id%NOTFOUND THEN
2785: IF PG_DEBUG IN ('Y','C') THEN
2786: arp_standard.debug('No Data Found : Invalid p_applied_payment_schedule_id');
2787: END IF;
2788: CLOSE get_open_cr_id;
2789: RAISE invalid_param;
2790:

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

2802: ,'NULL'
2803: );
2804:
2805: IF PG_DEBUG IN ('Y','C') THEN
2806: arp_standard.debug('Invalid Argument - Applied Payment Schedule ID IS NULL');
2807: END IF;
2808: RAISE invalid_param;
2809:
2810: END IF; --IF (p_applied_payment_schedule_id IS NOT NULL)

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

2946:
2947: END IF; --IF l_process = 'Y' THEN
2948:
2949: IF PG_DEBUG in ('Y','C') THEN
2950: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');
2951: END IF;
2952:
2953: EXCEPTION
2954: WHEN invalid_param THEN

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

2955:
2956: x_return_status := FND_API.G_RET_STS_ERROR;
2957:
2958: IF PG_DEBUG in ('Y','C') THEN
2959: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');
2960: END IF;
2961:
2962: RAISE;
2963:

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

3018: EXCEPTION
3019: WHEN OTHERS THEN
3020:
3021: IF PG_DEBUG in ('Y', 'C') THEN
3022: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');
3023: END IF;
3024: RETURN NULL;
3025:
3026: END GET_ACTIVE_CLAIM_FLAG;

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

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

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

3064:
3065: WHEN OTHERS THEN
3066:
3067: IF PG_DEBUG in ('Y', 'C') THEN
3068: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3069: END IF;
3070: RAISE;
3071:
3072: END ARP_DEDUCTION;