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.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_UTILITY_PVT

Line 36: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

32:
33: UPDATE ozf_claims_all
34: SET payment_status = 'PAID'
35: , status_code = 'CLOSED'
36: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
37: 'OZF_CLAIM_STATUS'
38: ,'CLOSED'
39: )
40: WHERE group_claim_id = p_group_claim_id

Line 134: OZF_Utility_PVT.debug_message(l_full_name||': start');

130:
131: BEGIN
132: -------------------- initialize -----------------------
133: IF OZF_DEBUG_HIGH_ON THEN
134: OZF_Utility_PVT.debug_message(l_full_name||': start');
135: END IF;
136: x_return_status := FND_API.g_ret_sts_success;
137:
138: ------------------------ start -------------------------

Line 151: OZF_Utility_PVT.debug_message('p_deduction_type ='||p_deduction_type);

147: RAISE FND_API.g_exc_unexpected_error;
148: END IF;
149:
150: IF OZF_DEBUG_HIGH_ON THEN
151: OZF_Utility_PVT.debug_message('p_deduction_type ='||p_deduction_type);
152: END IF;
153:
154:
155: IF ( p_deduction_type IN ( 'RECEIPT_DED', 'SOURCE_DED') AND

Line 169: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');

165:
166: l_recpt_new_applied_amt := l_recpt_old_applied_amt
167: - (p_amount_applied * -1);
168: IF OZF_DEBUG_HIGH_ON THEN
169: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');
170: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);
171: END IF;
172:
173: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 170: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);

166: l_recpt_new_applied_amt := l_recpt_old_applied_amt
167: - (p_amount_applied * -1);
168: IF OZF_DEBUG_HIGH_ON THEN
169: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');
170: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);
171: END IF;
172:
173: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
174: p_claim_rec => l_payment_claim_rec

Line 192: OZF_Utility_PVT.debug_message('2. Apply open receipt ');

188: -- 2. Apply Open Receipt
189: -- Bug4079177: Apply open receipt before unapplying claim.
190: -- ------------------------------
191: IF OZF_DEBUG_HIGH_ON THEN
192: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
193: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
194: OZF_Utility_PVT.debug_message('Payment Cash Receipt Id = '|| l_payment_claim_rec.receipt_id);
195: OZF_Utility_PVT.debug_message('Claim Receipt Id = '|| p_claim_rec.receipt_id);
196: END IF;

Line 193: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);

189: -- Bug4079177: Apply open receipt before unapplying claim.
190: -- ------------------------------
191: IF OZF_DEBUG_HIGH_ON THEN
192: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
193: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
194: OZF_Utility_PVT.debug_message('Payment Cash Receipt Id = '|| l_payment_claim_rec.receipt_id);
195: OZF_Utility_PVT.debug_message('Claim Receipt Id = '|| p_claim_rec.receipt_id);
196: END IF;
197:

Line 194: OZF_Utility_PVT.debug_message('Payment Cash Receipt Id = '|| l_payment_claim_rec.receipt_id);

190: -- ------------------------------
191: IF OZF_DEBUG_HIGH_ON THEN
192: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
193: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
194: OZF_Utility_PVT.debug_message('Payment Cash Receipt Id = '|| l_payment_claim_rec.receipt_id);
195: OZF_Utility_PVT.debug_message('Claim Receipt Id = '|| p_claim_rec.receipt_id);
196: END IF;
197:
198: --Fix for bug 5325645

Line 195: OZF_Utility_PVT.debug_message('Claim Receipt Id = '|| p_claim_rec.receipt_id);

191: IF OZF_DEBUG_HIGH_ON THEN
192: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
193: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
194: OZF_Utility_PVT.debug_message('Payment Cash Receipt Id = '|| l_payment_claim_rec.receipt_id);
195: OZF_Utility_PVT.debug_message('Claim Receipt Id = '|| p_claim_rec.receipt_id);
196: END IF;
197:
198: --Fix for bug 5325645
199: IF l_payment_claim_rec.receipt_id <> p_claim_rec.receipt_id THEN

Line 266: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');

262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:
265: IF OZF_DEBUG_HIGH_ON THEN
266: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');
267: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);
268: END IF;
269:
270: -- 3. Reapply claim investigation

Line 267: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);

263: END IF;
264:
265: IF OZF_DEBUG_HIGH_ON THEN
266: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');
267: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);
268: END IF;
269:
270: -- 3. Reapply claim investigation
271: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 295: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');

291:
292: l_recpt_new_applied_amt := l_recpt_old_applied_amt + (p_amount_applied * -1);
293:
294: IF OZF_DEBUG_HIGH_ON THEN
295: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');
296: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);
297: END IF;
298:
299:

Line 296: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);

292: l_recpt_new_applied_amt := l_recpt_old_applied_amt + (p_amount_applied * -1);
293:
294: IF OZF_DEBUG_HIGH_ON THEN
295: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');
296: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);
297: END IF;
298:
299:
300: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 358: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');

354:
355: l_recpt_new_applied_amt := l_recpt_old_applied_amt
356: + (p_amount_applied * -1);
357: IF OZF_DEBUG_HIGH_ON THEN
358: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');
359: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);
360: END IF;
361:
362: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 359: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);

355: l_recpt_new_applied_amt := l_recpt_old_applied_amt
356: + (p_amount_applied * -1);
357: IF OZF_DEBUG_HIGH_ON THEN
358: OZF_Utility_PVT.debug_message('1. Unapply overpayment claim investigation');
359: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_recpt_old_applied_amt);
360: END IF;
361:
362: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
363: p_claim_rec => p_claim_rec

Line 380: OZF_Utility_PVT.debug_message('2. Apply open receipt ');

376: -- ------------------------------
377: -- 2. Apply Open Receipt
378: -- ------------------------------
379: IF OZF_DEBUG_HIGH_ON THEN
380: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
381: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
382: END IF;
383:
384: --Fix for bug 5325645

Line 381: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);

377: -- 2. Apply Open Receipt
378: -- ------------------------------
379: IF OZF_DEBUG_HIGH_ON THEN
380: OZF_Utility_PVT.debug_message('2. Apply open receipt ');
381: OZF_Utility_PVT.debug_message('Amount applied = '||p_amount_applied);
382: END IF;
383:
384: --Fix for bug 5325645
385: IF l_payment_claim_rec.receipt_id <> p_claim_rec.receipt_id THEN

Line 453: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');

449: RAISE FND_API.g_exc_unexpected_error;
450: END IF;
451:
452: IF OZF_DEBUG_HIGH_ON THEN
453: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');
454: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);
455: END IF;
456:
457: -- 3. Reapply claim investigation

Line 454: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);

450: END IF;
451:
452: IF OZF_DEBUG_HIGH_ON THEN
453: OZF_Utility_PVT.debug_message('3. Unapply Invoice Deduction');
454: OZF_Utility_PVT.debug_message('original amount applied to invoice = '||l_old_applied_invoice.amount_applied);
455: END IF;
456:
457: -- 3. Reapply claim investigation
458: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 482: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');

478:
479: l_recpt_new_applied_amt := l_recpt_old_applied_amt - (p_amount_applied * -1);
480:
481: IF OZF_DEBUG_HIGH_ON THEN
482: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');
483: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);
484: END IF;
485:
486: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 483: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);

479: l_recpt_new_applied_amt := l_recpt_old_applied_amt - (p_amount_applied * -1);
480:
481: IF OZF_DEBUG_HIGH_ON THEN
482: OZF_Utility_PVT.debug_message('3. Unapply Non Invoice Deduction');
483: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_recpt_old_applied_amt);
484: END IF;
485:
486: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
487: p_claim_rec => l_payment_claim_rec

Line 531: OZF_Utility_PVT.debug_message(l_full_name||': end');

527: END IF;
528:
529:
530: IF OZF_DEBUG_HIGH_ON THEN
531: OZF_Utility_PVT.debug_message(l_full_name||': end');
532: END IF;
533: EXCEPTION
534: WHEN FND_API.g_exc_error THEN
535: x_return_status := FND_API.g_ret_sts_error;

Line 630: OZF_Utility_PVT.debug_message(l_full_name||': start');

626:
627: BEGIN
628: -------------------- initialize -----------------------
629: IF OZF_DEBUG_HIGH_ON THEN
630: OZF_Utility_PVT.debug_message(l_full_name||': start');
631: END IF;
632: x_return_status := FND_API.g_ret_sts_success;
633:
634: ------------------------ start -------------------------

Line 659: OZF_Utility_PVT.debug_message('No payment reference specified (No open credit memo specified) -> AutoInvoice.');

655: /*------------------------------------------------------------*
656: | No payment reference specified (No open credit memo specified) -> AutoInvoice
657: *------------------------------------------------------------*/
658: IF OZF_DEBUG_HIGH_ON THEN
659: OZF_Utility_PVT.debug_message('No payment reference specified (No open credit memo specified) -> AutoInvoice.');
660: END IF;
661: -- 1. AutoInvoice
662: OZF_AR_INTERFACE_PVT.Interface_Claim(
663: p_api_version => l_api_version

Line 723: OZF_Utility_PVT.debug_message('Invoice Deduction -> 1. Update amount in dispute');

719: FETCH csr_old_applied_invoice INTO l_old_applied_invoice;
720: CLOSE csr_old_applied_invoice;
721:
722: IF OZF_DEBUG_HIGH_ON THEN
723: OZF_Utility_PVT.debug_message('Invoice Deduction -> 1. Update amount in dispute');
724: END IF;
725: -- 1. Update amount in dispute
726: OZF_AR_Payment_PVT.Update_dispute_amount(
727: p_claim_rec => p_claim_rec

Line 741: OZF_Utility_PVT.debug_message('Invoice Deduction -> 2. Apply creit memo on receipt');

737: END IF;
738:
739: IF l_cm_applied_on_rec_amt IS NULL THEN
740: IF OZF_DEBUG_HIGH_ON THEN
741: OZF_Utility_PVT.debug_message('Invoice Deduction -> 2. Apply creit memo on receipt');
742: END IF;
743: -- 2. Apply creit memo on receipt
744: OZF_AR_Payment_PVT.Apply_on_Receipt(
745: p_cash_receipt_id => p_claim_rec.receipt_id

Line 762: OZF_Utility_PVT.debug_message('Invoice Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');

758: RAISE FND_API.g_exc_unexpected_error;
759: END IF;
760: ELSE
761: IF OZF_DEBUG_HIGH_ON THEN
762: OZF_Utility_PVT.debug_message('Invoice Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');
763: OZF_Utility_PVT.debug_message('Invoice Deduction -> 2. Reapply creit memo on receipt');
764: END IF;
765:
766: l_settlement_amount := (p_credit_memo_amount * -1);--Bug4308188

Line 763: OZF_Utility_PVT.debug_message('Invoice Deduction -> 2. Reapply creit memo on receipt');

759: END IF;
760: ELSE
761: IF OZF_DEBUG_HIGH_ON THEN
762: OZF_Utility_PVT.debug_message('Invoice Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');
763: OZF_Utility_PVT.debug_message('Invoice Deduction -> 2. Reapply creit memo on receipt');
764: END IF;
765:
766: l_settlement_amount := (p_credit_memo_amount * -1);--Bug4308188
767: -- 2. Reapply credit memo on receipt

Line 784: OZF_Utility_PVT.debug_message('Invoice Deduction -> 3. Unapply claim investigation');

780: END IF;
781: END IF;
782:
783: IF OZF_DEBUG_HIGH_ON THEN
784: OZF_Utility_PVT.debug_message('Invoice Deduction -> 3. Unapply claim investigation');
785: OZF_Utility_PVT.debug_message('original invoice deduction amount = '||l_old_applied_invoice.amount_applied);
786: OZF_Utility_PVT.debug_message('reapply invoice deduction amount = '||(l_old_applied_invoice.amount_applied + p_credit_memo_amount));
787: END IF;
788: -- 3. Reapply claim investigation

Line 785: OZF_Utility_PVT.debug_message('original invoice deduction amount = '||l_old_applied_invoice.amount_applied);

781: END IF;
782:
783: IF OZF_DEBUG_HIGH_ON THEN
784: OZF_Utility_PVT.debug_message('Invoice Deduction -> 3. Unapply claim investigation');
785: OZF_Utility_PVT.debug_message('original invoice deduction amount = '||l_old_applied_invoice.amount_applied);
786: OZF_Utility_PVT.debug_message('reapply invoice deduction amount = '||(l_old_applied_invoice.amount_applied + p_credit_memo_amount));
787: END IF;
788: -- 3. Reapply claim investigation
789: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(

Line 786: OZF_Utility_PVT.debug_message('reapply invoice deduction amount = '||(l_old_applied_invoice.amount_applied + p_credit_memo_amount));

782:
783: IF OZF_DEBUG_HIGH_ON THEN
784: OZF_Utility_PVT.debug_message('Invoice Deduction -> 3. Unapply claim investigation');
785: OZF_Utility_PVT.debug_message('original invoice deduction amount = '||l_old_applied_invoice.amount_applied);
786: OZF_Utility_PVT.debug_message('reapply invoice deduction amount = '||(l_old_applied_invoice.amount_applied + p_credit_memo_amount));
787: END IF;
788: -- 3. Reapply claim investigation
789: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
790: p_claim_rec => p_claim_rec

Line 815: OZF_Utility_PVT.debug_message('Receipt Deduction -> 1. Apply creit memo on receipt');

811: | 1. Apply credit memo with increased amount on receipt
812: | 2. Unapply claim investigation
813: *------------------------------------------------------------*/
814: IF OZF_DEBUG_HIGH_ON THEN
815: OZF_Utility_PVT.debug_message('Receipt Deduction -> 1. Apply creit memo on receipt');
816: END IF;
817: -- 1. Apply creit memo on receipt
818: OZF_AR_Payment_PVT.Apply_on_Receipt(
819: p_cash_receipt_id => p_claim_rec.receipt_id

Line 835: OZF_Utility_PVT.debug_message('Receipt Deduction -> 2. Unapply claim investigation');

831: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
832: RAISE FND_API.g_exc_unexpected_error;
833: END IF;
834: IF OZF_DEBUG_HIGH_ON THEN
835: OZF_Utility_PVT.debug_message('Receipt Deduction -> 2. Unapply claim investigation');
836: END IF;
837: ELSE
838: /*------------------------------------------------------------*
839: | Receipt Deduction

Line 842: OZF_Utility_PVT.debug_message('Receipt Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');

838: /*------------------------------------------------------------*
839: | Receipt Deduction
840: *------------------------------------------------------------*/
841: IF OZF_DEBUG_HIGH_ON THEN
842: OZF_Utility_PVT.debug_message('Receipt Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');
843: OZF_Utility_PVT.debug_message('Receipt Deduction -> 1. Reapply credit memo with increased amount on receipt');
844: END IF;
845:
846: l_settlement_amount := (p_credit_memo_amount * -1); --Bug4308188

Line 843: OZF_Utility_PVT.debug_message('Receipt Deduction -> 1. Reapply credit memo with increased amount on receipt');

839: | Receipt Deduction
840: *------------------------------------------------------------*/
841: IF OZF_DEBUG_HIGH_ON THEN
842: OZF_Utility_PVT.debug_message('Receipt Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');
843: OZF_Utility_PVT.debug_message('Receipt Deduction -> 1. Reapply credit memo with increased amount on receipt');
844: END IF;
845:
846: l_settlement_amount := (p_credit_memo_amount * -1); --Bug4308188
847: -- 2. Reapply credit memo on receipt

Line 869: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_orig_dispute_amount);

865: FETCH csr_claim_investigation_amount INTO l_orig_dispute_amount;
866: CLOSE csr_claim_investigation_amount;
867:
868: IF OZF_DEBUG_HIGH_ON THEN
869: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_orig_dispute_amount);
870: OZF_Utility_PVT.debug_message('reapply claim investigation amount = '||(l_orig_dispute_amount + p_credit_memo_amount));
871: END IF;
872: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
873: p_claim_rec => p_claim_rec

Line 870: OZF_Utility_PVT.debug_message('reapply claim investigation amount = '||(l_orig_dispute_amount + p_credit_memo_amount));

866: CLOSE csr_claim_investigation_amount;
867:
868: IF OZF_DEBUG_HIGH_ON THEN
869: OZF_Utility_PVT.debug_message('original claim investigation amount = '||l_orig_dispute_amount);
870: OZF_Utility_PVT.debug_message('reapply claim investigation amount = '||(l_orig_dispute_amount + p_credit_memo_amount));
871: END IF;
872: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
873: p_claim_rec => p_claim_rec
874: ,p_reapply_amount => l_orig_dispute_amount + p_credit_memo_amount --(l_orig_reapply_amount - p_credit_memo_amount) * -1

Line 921: OZF_Utility_PVT.debug_message(l_full_name||': end');

917:
918: END IF;
919:
920: IF OZF_DEBUG_HIGH_ON THEN
921: OZF_Utility_PVT.debug_message(l_full_name||': end');
922: END IF;
923: EXCEPTION
924: WHEN FND_API.g_exc_error THEN
925: x_return_status := FND_API.g_ret_sts_error;

Line 1003: OZF_Utility_PVT.debug_message(l_full_name||': start');

999:
1000: BEGIN
1001: -------------------- initialize -----------------------
1002: IF OZF_DEBUG_HIGH_ON THEN
1003: OZF_Utility_PVT.debug_message(l_full_name||': start');
1004: END IF;
1005:
1006: x_return_status := FND_API.g_ret_sts_success;
1007:

Line 1063: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation');

1059: OPEN csr_dm_exist_on_rec(p_claim_rec.receipt_id, p_payment_reference_id);
1060: FETCH csr_dm_exist_on_rec INTO l_dm_applied_on_rec_amt, l_apply_date; -- Fix for Bug 3091401. TM passes old apply date
1061: CLOSE csr_dm_exist_on_rec;
1062:
1063: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation');
1064: -- 1. Unapply claim investigation
1065: OPEN csr_claim_investigation_amount(p_claim_rec.root_claim_id);
1066: FETCH csr_claim_investigation_amount INTO l_orig_dispute_amount;
1067: CLOSE csr_claim_investigation_amount;

Line 1069: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_orig_dispute_amount);

1065: OPEN csr_claim_investigation_amount(p_claim_rec.root_claim_id);
1066: FETCH csr_claim_investigation_amount INTO l_orig_dispute_amount;
1067: CLOSE csr_claim_investigation_amount;
1068:
1069: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_orig_dispute_amount);
1070: OZF_Utility_PVT.debug_message('reapply overpayment amount = '||(l_orig_dispute_amount + p_debit_memo_amount));
1071:
1072: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
1073: p_claim_rec => p_claim_rec

Line 1070: OZF_Utility_PVT.debug_message('reapply overpayment amount = '||(l_orig_dispute_amount + p_debit_memo_amount));

1066: FETCH csr_claim_investigation_amount INTO l_orig_dispute_amount;
1067: CLOSE csr_claim_investigation_amount;
1068:
1069: OZF_Utility_PVT.debug_message('original overpayment amount = '||l_orig_dispute_amount);
1070: OZF_Utility_PVT.debug_message('reapply overpayment amount = '||(l_orig_dispute_amount + p_debit_memo_amount));
1071:
1072: OZF_AR_Payment_PVT.Unapply_Claim_Investigation(
1073: p_claim_rec => p_claim_rec
1074: ,p_reapply_amount => (l_orig_dispute_amount + p_debit_memo_amount)

Line 1087: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply debit memo on receipt');

1083: END IF;
1084:
1085:
1086: IF l_dm_applied_on_rec_amt IS NULL THEN
1087: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply debit memo on receipt');
1088: -- 2. Apply debit memo on receipt
1089: OZF_AR_Payment_PVT.Apply_on_Receipt(
1090: p_cash_receipt_id => p_claim_rec.receipt_id
1091: ,p_customer_trx_id => p_payment_reference_id

Line 1106: OZF_Utility_PVT.debug_message('Overpayment: Pay by Previous Open Debit Memo which already exists on the receipt');

1102: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: END IF;
1105: ELSE
1106: OZF_Utility_PVT.debug_message('Overpayment: Pay by Previous Open Debit Memo which already exists on the receipt');
1107: OZF_Utility_PVT.debug_message('Overpayment -> 1.5. Unapply debit memo on receipt');
1108: -- 1.5. Unapply creit memo on receipt
1109: OZF_AR_Payment_PVT.Unapply_from_Receipt(
1110: p_cash_receipt_id => p_claim_rec.receipt_id

Line 1107: OZF_Utility_PVT.debug_message('Overpayment -> 1.5. Unapply debit memo on receipt');

1103: RAISE FND_API.g_exc_unexpected_error;
1104: END IF;
1105: ELSE
1106: OZF_Utility_PVT.debug_message('Overpayment: Pay by Previous Open Debit Memo which already exists on the receipt');
1107: OZF_Utility_PVT.debug_message('Overpayment -> 1.5. Unapply debit memo on receipt');
1108: -- 1.5. Unapply creit memo on receipt
1109: OZF_AR_Payment_PVT.Unapply_from_Receipt(
1110: p_cash_receipt_id => p_claim_rec.receipt_id
1111: ,p_customer_trx_id => p_payment_reference_id

Line 1122: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply debit memo with increased amount on receipt');

1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:
1122: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply debit memo with increased amount on receipt');
1123: l_settlement_amount := (p_debit_memo_amount * -1); --Bug4308188
1124: -- 2. Apply creit memo on receipt
1125: OZF_AR_Payment_PVT.Apply_on_Receipt(
1126: p_cash_receipt_id => p_claim_rec.receipt_id

Line 1184: OZF_Utility_PVT.debug_message(l_full_name||': end');

1180: END IF;
1181: END IF;
1182:
1183: IF OZF_DEBUG_HIGH_ON THEN
1184: OZF_Utility_PVT.debug_message(l_full_name||': end');
1185: END IF;
1186: EXCEPTION
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;

Line 1234: OZF_Utility_PVT.debug_message(l_full_name||': start');

1230:
1231: BEGIN
1232: -------------------- initialize -----------------------
1233: IF OZF_DEBUG_HIGH_ON THEN
1234: OZF_Utility_PVT.debug_message(l_full_name||': start');
1235: END IF;
1236:
1237: x_return_status := FND_API.g_ret_sts_success;
1238:

Line 1279: OZF_Utility_PVT.debug_message('x_cb_customer_trx_id = '||l_cb_customer_trx_id);

1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277:
1278: IF OZF_DEBUG_HIGH_ON THEN
1279: OZF_Utility_PVT.debug_message('x_cb_customer_trx_id = '||l_cb_customer_trx_id);
1280: END IF;
1281:
1282: /*------------------------------------------------------------*
1283: | Update Deduction payment detail

Line 1320: OZF_Utility_PVT.debug_message(l_full_name||': end');

1316: END IF;
1317:
1318:
1319: IF OZF_DEBUG_HIGH_ON THEN
1320: OZF_Utility_PVT.debug_message(l_full_name||': end');
1321: END IF;
1322: EXCEPTION
1323: WHEN FND_API.g_exc_error THEN
1324: x_return_status := FND_API.g_ret_sts_error;

Line 1370: OZF_Utility_PVT.debug_message(l_full_name||': start');

1366:
1367: BEGIN
1368: -------------------- initialize -----------------------
1369: IF OZF_DEBUG_HIGH_ON THEN
1370: OZF_Utility_PVT.debug_message(l_full_name||': start');
1371: END IF;
1372:
1373: x_return_status := FND_API.g_ret_sts_success;
1374:

Line 1397: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

1393: BEGIN
1394: UPDATE ozf_claims_all
1395: SET payment_status = 'PENDING'
1396: , status_code = 'PENDING_CLOSE'
1397: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
1398: 'OZF_CLAIM_STATUS'
1399: ,'PENDING_CLOSE'
1400: )
1401: WHERE claim_id = p_claim_rec.claim_id;

Line 1455: OZF_Utility_PVT.debug_message(l_full_name||': end');

1451: END IF;
1452: END IF;
1453:
1454: IF OZF_DEBUG_HIGH_ON THEN
1455: OZF_Utility_PVT.debug_message(l_full_name||': end');
1456: END IF;
1457: EXCEPTION
1458: WHEN FND_API.g_exc_error THEN
1459: x_return_status := FND_API.g_ret_sts_error;

Line 1515: OZF_Utility_PVT.debug_message(l_full_name||': start');

1511:
1512: BEGIN
1513: -------------------- initialize -----------------------
1514: IF OZF_DEBUG_HIGH_ON THEN
1515: OZF_Utility_PVT.debug_message(l_full_name||': start');
1516: END IF;
1517:
1518: x_return_status := FND_API.g_ret_sts_success;
1519:

Line 1544: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation.');

1540: | Overpayment -> 1. Unapply claim investigation
1541: | 2. Apply On Account Credit
1542: *------------------------------------------------------------*/
1543: IF OZF_DEBUG_HIGH_ON THEN
1544: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation.');
1545: END IF;
1546: -- 1. Unapply claim investigation
1547: OPEN csr_old_claim_investigation(p_claim_rec.receipt_id, p_claim_rec.root_claim_id);
1548: FETCH csr_old_claim_investigation INTO l_old_applied_claim_amount;

Line 1567: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply On Account Credit.');

1563: RAISE FND_API.g_exc_unexpected_error;
1564: END IF;
1565:
1566: IF OZF_DEBUG_HIGH_ON THEN
1567: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply On Account Credit.');
1568: END IF;
1569: --2. Apply On Account Credit
1570: OZF_AR_PAYMENT_PVT.Apply_On_Account_Credit(
1571: p_claim_rec => p_claim_rec

Line 1588: OZF_Utility_PVT.debug_message('cash_receipt_id = '||p_claim_rec.receipt_id);

1584: | Update Deduction payment detail
1585: *------------------------------------------------------------*/
1586: -- Update Deduction payment detail
1587: IF OZF_DEBUG_HIGH_ON THEN
1588: OZF_Utility_PVT.debug_message('cash_receipt_id = '||p_claim_rec.receipt_id);
1589: END IF;
1590: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1591: p_api_version => l_api_version
1592: ,p_init_msg_list => FND_API.g_false

Line 1622: OZF_Utility_PVT.debug_message(l_full_name||': end');

1618: RAISE FND_API.g_exc_error;
1619: END IF;
1620:
1621: IF OZF_DEBUG_HIGH_ON THEN
1622: OZF_Utility_PVT.debug_message(l_full_name||': end');
1623: END IF;
1624: EXCEPTION
1625: WHEN FND_API.g_exc_error THEN
1626: x_return_status := FND_API.g_ret_sts_error;

Line 1726: OZF_Utility_PVT.debug_message(l_full_name||': start');

1722: -------------------- initialize -----------------------
1723: SAVEPOINT Break_Mass_Settlement;
1724:
1725: IF OZF_DEBUG_HIGH_ON THEN
1726: OZF_Utility_PVT.debug_message(l_full_name||': start');
1727: END IF;
1728:
1729: x_return_status := FND_API.G_RET_STS_SUCCESS;
1730:

Line 1733: OZF_Utility_PVT.debug_message('Settlement Type = '||p_settlement_type);

1729: x_return_status := FND_API.G_RET_STS_SUCCESS;
1730:
1731: ------------------------ start -------------------------
1732: IF OZF_DEBUG_HIGH_ON THEN
1733: OZF_Utility_PVT.debug_message('Settlement Type = '||p_settlement_type);
1734: END IF;
1735:
1736: IF p_settlement_type <> 'NETTING' THEN
1737: l_idx := 1;

Line 1884: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||

1880:
1881: l_claim_netting_tbl(l_idx_netting_claim).amount_remaining := 0;
1882:
1883: IF OZF_DEBUG_HIGH_ON THEN
1884: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1885: l_group_claim_line_tbl(i).payment_reference_number||
1886: ' ... '||
1887: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1888: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_reference_number||

Line 1912: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||

1908:
1909: l_amount_settled := 0;
1910:
1911: IF OZF_DEBUG_HIGH_ON THEN
1912: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1913: l_group_claim_line_tbl(i).payment_reference_number||
1914: ' ... '||
1915: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1916: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_reference_number||

Line 1958: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||

1954:
1955: l_settle_doc_group_tbl(l_idx_settle_doc_group).settlement_amount := 0;
1956:
1957: IF OZF_DEBUG_HIGH_ON THEN
1958: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1959: l_group_claim_line_tbl(i).payment_reference_number||
1960: ' ... '||
1961: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1962: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_method||

Line 1982: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||

1978:
1979: l_amount_settled := 0;
1980:
1981: IF OZF_DEBUG_HIGH_ON THEN
1982: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1983: l_group_claim_line_tbl(i).payment_reference_number||
1984: ' ... '||
1985: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1986: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_method||

Line 2036: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');

2032:
2033: IF OZF_DEBUG_HIGH_ON THEN
2034: i := l_group_claim_line_tbl.FIRST;
2035: IF i IS NOT NULL THEN
2036: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2037: LOOP
2038: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2039: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2040: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);

Line 2038: OZF_Utility_PVT.debug_message('--- '||i||' ---');

2034: i := l_group_claim_line_tbl.FIRST;
2035: IF i IS NOT NULL THEN
2036: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2037: LOOP
2038: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2039: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2040: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2041: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2042: i := l_group_claim_line_tbl.NEXT(i);

Line 2039: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);

2035: IF i IS NOT NULL THEN
2036: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2037: LOOP
2038: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2039: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2040: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2041: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2042: i := l_group_claim_line_tbl.NEXT(i);
2043: END LOOP;

Line 2040: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);

2036: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2037: LOOP
2038: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2039: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2040: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2041: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2042: i := l_group_claim_line_tbl.NEXT(i);
2043: END LOOP;
2044: END IF;

Line 2075: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');

2071:
2072: IF OZF_DEBUG_HIGH_ON THEN
2073: i := l_settle_doc_tbl.FIRST;
2074: IF i IS NOT NULL THEN
2075: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2076: LOOP
2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);

Line 2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');

2073: i := l_settle_doc_tbl.FIRST;
2074: IF i IS NOT NULL THEN
2075: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2076: LOOP
2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);

Line 2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);

2074: IF i IS NOT NULL THEN
2075: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2076: LOOP
2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);

Line 2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);

2075: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2076: LOOP
2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);

Line 2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);

2076: LOOP
2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);

Line 2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);

2077: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2085: EXIT WHEN i = l_settle_doc_tbl.LAST;

Line 2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);

2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2085: EXIT WHEN i = l_settle_doc_tbl.LAST;
2086: i := l_settle_doc_tbl.NEXT(i);

Line 2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);

2079: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2085: EXIT WHEN i = l_settle_doc_tbl.LAST;
2086: i := l_settle_doc_tbl.NEXT(i);
2087: END LOOP;

Line 2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);

2080: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2081: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2082: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2083: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2084: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2085: EXIT WHEN i = l_settle_doc_tbl.LAST;
2086: i := l_settle_doc_tbl.NEXT(i);
2087: END LOOP;
2088: END IF;

Line 2091: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');

2087: END LOOP;
2088: END IF;
2089: i := l_settle_doc_tbl2.FIRST;
2090: IF i IS NOT NULL THEN
2091: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2092: LOOP
2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);

Line 2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');

2089: i := l_settle_doc_tbl2.FIRST;
2090: IF i IS NOT NULL THEN
2091: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2092: LOOP
2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);

Line 2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);

2090: IF i IS NOT NULL THEN
2091: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2092: LOOP
2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);

Line 2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);

2091: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2092: LOOP
2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);

Line 2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);

2092: LOOP
2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);

Line 2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);

2093: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2101: EXIT WHEN i = l_settle_doc_tbl2.LAST;

Line 2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);

2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2101: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2102: i := l_settle_doc_tbl2.NEXT(i);

Line 2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);

2095: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2101: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2102: i := l_settle_doc_tbl2.NEXT(i);
2103: END LOOP;

Line 2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);

2096: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2097: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2098: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2099: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2100: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2101: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2102: i := l_settle_doc_tbl2.NEXT(i);
2103: END LOOP;
2104: END IF;

Line 2151: OZF_Utility_PVT.debug_message(l_full_name||': end');

2147: END IF;
2148: END IF;
2149:
2150: IF OZF_DEBUG_HIGH_ON THEN
2151: OZF_Utility_PVT.debug_message(l_full_name||': end');
2152: END IF;
2153:
2154: EXCEPTION
2155: WHEN FND_API.g_exc_error THEN

Line 2235: OZF_Utility_PVT.debug_message(l_full_name||': start');

2231: -------------------- initialize -----------------------
2232: SAVEPOINT Complete_Mass_Settlement;
2233:
2234: IF OZF_DEBUG_HIGH_ON THEN
2235: OZF_Utility_PVT.debug_message(l_full_name||': start');
2236: END IF;
2237:
2238: x_return_status := FND_API.G_RET_STS_SUCCESS;
2239:

Line 2259: x_claim_tbl(i).user_status_id := OZF_UTILITY_PVT.get_default_user_status(

2255: END IF;
2256:
2257: x_claim_tbl(i).payment_method := 'MASS_SETTLEMENT';
2258: x_claim_tbl(i).status_code := 'COMPLETE';
2259: x_claim_tbl(i).user_status_id := OZF_UTILITY_PVT.get_default_user_status(
2260: 'OZF_CLAIM_STATUS'
2261: ,'COMPLETE'
2262: );
2263: i := i + 1;

Line 2303: OZF_Utility_PVT.debug_message(l_full_name||': end');

2299: END LOOP;
2300: END IF;
2301:
2302: IF OZF_DEBUG_HIGH_ON THEN
2303: OZF_Utility_PVT.debug_message(l_full_name||': end');
2304: END IF;
2305:
2306: EXCEPTION
2307: WHEN FND_API.g_exc_error THEN

Line 2408: OZF_Utility_PVT.debug_message(l_full_name||': start');

2404: -------------------- initialize -----------------------
2405: SAVEPOINT Approve_Mass_Settlement;
2406:
2407: IF OZF_DEBUG_HIGH_ON THEN
2408: OZF_Utility_PVT.debug_message(l_full_name||': start');
2409: END IF;
2410:
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412:

Line 2427: l_claim_pvt_rec.user_status_id := OZF_UTILITY_PVT.get_default_user_status(

2423: OPEN csr_claim_obj_ver(p_complete_claim_group_tbl(i).claim_id);
2424: FETCH csr_claim_obj_ver INTO l_claim_pvt_rec.object_version_number;
2425: CLOSE csr_claim_obj_ver;
2426:
2427: l_claim_pvt_rec.user_status_id := OZF_UTILITY_PVT.get_default_user_status(
2428: 'OZF_CLAIM_STATUS'
2429: ,'PENDING_APPROVAL'
2430: );
2431: l_claim_pvt_rec.status_code := 'PENDING_APPROVAL';

Line 2464: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(

2460: OPEN csr_claim_obj_ver(p_group_claim_id);
2461: FETCH csr_claim_obj_ver INTO l_group_claim_obj_ver;
2462: CLOSE csr_claim_obj_ver;
2463:
2464: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(
2465: 'OZF_CLAIM_STATUS'
2466: ,'OPEN'
2467: );
2468:

Line 2469: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(

2465: 'OZF_CLAIM_STATUS'
2466: ,'OPEN'
2467: );
2468:
2469: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(
2470: 'OZF_CLAIM_STATUS'
2471: ,'CLOSED'
2472: );
2473:

Line 2474: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(

2470: 'OZF_CLAIM_STATUS'
2471: ,'CLOSED'
2472: );
2473:
2474: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(
2475: 'OZF_CLAIM_STATUS'
2476: ,'REJECTED'
2477: );
2478:

Line 2479: l_owner_id := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

2475: 'OZF_CLAIM_STATUS'
2476: ,'REJECTED'
2477: );
2478:
2479: l_owner_id := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2480:
2481: --//Added by BKUNJAN Bug#5686706
2482: UPDATE ozf_claims_all
2483: SET payment_status = 'PENDING'

Line 2485: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

2481: --//Added by BKUNJAN Bug#5686706
2482: UPDATE ozf_claims_all
2483: SET payment_status = 'PENDING'
2484: , status_code = 'PENDING_APPROVAL'
2485: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2486: 'OZF_CLAIM_STATUS'
2487: ,'PENDING_APPROVAL'
2488: )
2489: WHERE claim_id = p_group_claim_id;

Line 2516: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

2512: /*
2513: UPDATE ozf_claims_all
2514: SET payment_status = 'PENDING'
2515: , status_code = 'PENDING_APPROVAL'
2516: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2517: 'OZF_CLAIM_STATUS'
2518: ,'PENDING_APPROVAL'
2519: )
2520: WHERE claim_id = p_group_claim_id;

Line 2527: OZF_Utility_PVT.debug_message(l_full_name||': end');

2523:
2524: END IF;
2525:
2526: IF OZF_DEBUG_HIGH_ON THEN
2527: OZF_Utility_PVT.debug_message(l_full_name||': end');
2528: END IF;
2529:
2530:
2531: EXCEPTION

Line 2596: OZF_Utility_PVT.debug_message(l_full_name||': start');

2592: AND system_status_code = cv_status_code;
2593:
2594: BEGIN
2595: IF OZF_DEBUG_HIGH_ON THEN
2596: OZF_Utility_PVT.debug_message(l_full_name||': start');
2597: END IF;
2598:
2599: OPEN csr_user_status_id('REJECTED');
2600: FETCH csr_user_status_id INTO l_rejected_user_status_id;

Line 2647: OZF_Utility_PVT.debug_message(l_full_name||': end');

2643: RAISE FND_API.g_exc_unexpected_error;
2644: END;
2645:
2646: IF OZF_DEBUG_HIGH_ON THEN
2647: OZF_Utility_PVT.debug_message(l_full_name||': end');
2648: END IF;
2649:
2650: EXCEPTION
2651: WHEN FND_API.g_exc_error THEN

Line 2764: OZF_Utility_PVT.debug_message(l_full_name||': start');

2760: -------------------- initialize -----------------------
2761: SAVEPOINT Start_Mass_Payment;
2762:
2763: IF OZF_DEBUG_HIGH_ON THEN
2764: OZF_Utility_PVT.debug_message(l_full_name||': start');
2765: END IF;
2766:
2767: x_return_status := FND_API.G_RET_STS_SUCCESS;
2768:

Line 2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');

2884: j := l_settlement_doc_tbl.FIRST;
2885: IF j IS NOT NULL THEN
2886: LOOP
2887: IF OZF_DEBUG_HIGH_ON THEN
2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);

Line 2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);

2885: IF j IS NOT NULL THEN
2886: LOOP
2887: IF OZF_DEBUG_HIGH_ON THEN
2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);

Line 2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);

2886: LOOP
2887: IF OZF_DEBUG_HIGH_ON THEN
2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);

Line 2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);

2887: IF OZF_DEBUG_HIGH_ON THEN
2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);

Line 2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);

2888: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2896: END IF;

Line 2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);

2889: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2896: END IF;
2897:

Line 2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);

2890: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2896: END IF;
2897:
2898: BEGIN

Line 2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);

2891: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2892: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2893: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2894: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2896: END IF;
2897:
2898: BEGIN
2899: UPDATE ozf_settlement_docs_all

Line 3039: l_claim_rec_hist.user_status_id :=OZF_UTILITY_PVT.get_default_user_status('OZF_CLAIM_STATUS','CLOSED');

3035: --//Update Claim History
3036: IF l_status_code <>'CLOSED' THEN
3037: l_claim_rec_hist.claim_id :=l_settlement_doc_tbl(j).payment_reference_id;
3038: l_claim_rec_hist.status_code :='CLOSED';
3039: l_claim_rec_hist.user_status_id :=OZF_UTILITY_PVT.get_default_user_status('OZF_CLAIM_STATUS','CLOSED');
3040:
3041: OZF_claims_history_PVT.Check_Create_History(
3042: p_claim => l_claim_rec_hist,
3043: p_event => 'UPDATE',

Line 3113: OZF_Utility_PVT.debug_message(l_full_name||': end');

3109: RAISE FND_API.g_exc_unexpected_error;
3110: END;
3111:
3112: IF OZF_DEBUG_HIGH_ON THEN
3113: OZF_Utility_PVT.debug_message(l_full_name||': end');
3114: END IF;
3115:
3116: EXCEPTION
3117: WHEN FND_API.g_exc_error THEN

Line 3300: OZF_Utility_PVT.debug_message(l_full_name||': start');

3296: -------------------- initialize -----------------------
3297: SAVEPOINT Settle_Mass_Settlement;
3298:
3299: IF OZF_DEBUG_HIGH_ON THEN
3300: OZF_Utility_PVT.debug_message(l_full_name||': start');
3301: END IF;
3302:
3303: -- Standard call to check for call compatibility.
3304: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 3324: OZF_Utility_PVT.debug_message('1. Validation');

3320: -------------------
3321: -- 1. Validation --
3322: -------------------
3323: IF OZF_DEBUG_HIGH_ON THEN
3324: OZF_Utility_PVT.debug_message('1. Validation');
3325: END IF;
3326:
3327: i := p_open_claim_tbl.FIRST;
3328: IF i IS NOT NULL THEN

Line 3333: OZF_Utility_PVT.debug_message('open_claim_amt('||i||') = '||p_open_claim_tbl(i).amount_settled);

3329: LOOP
3330: l_open_claim_amt := l_open_claim_amt + p_open_claim_tbl(i).amount_settled;
3331:
3332: IF OZF_DEBUG_HIGH_ON THEN
3333: OZF_Utility_PVT.debug_message('open_claim_amt('||i||') = '||p_open_claim_tbl(i).amount_settled);
3334: END IF;
3335: IF p_open_claim_tbl(i).claim_class = l_settlement_type THEN
3336: l_overpay_amt := l_overpay_amt + l_open_claim_tbl(i).amount_settled * -1 ;
3337: END IF;

Line 3391: OZF_Utility_PVT.debug_message('open_trx_amt('||i||') = '||p_open_transaction_tbl(i).amount_settled);

3387:
3388: l_open_trx_amt := l_open_trx_amt + p_open_transaction_tbl(i).amount_settled;
3389: EXIT WHEN i = p_open_transaction_tbl.LAST;
3390: IF OZF_DEBUG_HIGH_ON THEN
3391: OZF_Utility_PVT.debug_message('open_trx_amt('||i||') = '||p_open_transaction_tbl(i).amount_settled);
3392: END IF;
3393: i := p_open_transaction_tbl.NEXT(i);
3394: END LOOP;
3395: END IF;

Line 3427: OZF_Utility_PVT.debug_message('pay_method_amt('||i||') = '||p_payment_method_tbl(i).amount_settled);

3423:
3424: l_pay_method_amt := l_pay_method_amt + (p_payment_method_tbl(i).amount_settled * -1);
3425: EXIT WHEN i = p_payment_method_tbl.LAST;
3426: IF OZF_DEBUG_HIGH_ON THEN
3427: OZF_Utility_PVT.debug_message('pay_method_amt('||i||') = '||p_payment_method_tbl(i).amount_settled);
3428: END IF;
3429: /*
3430: l_gl_date := p_payment_method_tbl(i).gl_date;
3431: l_wo_rec_trx_id := p_payment_method_tbl(i).wo_rec_trx_id;

Line 3505: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);

3501: END LOOP;
3502: END IF;
3503:
3504: IF OZF_DEBUG_HIGH_ON THEN
3505: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3506: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3507: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3508: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3509: END IF;

Line 3506: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);

3502: END IF;
3503:
3504: IF OZF_DEBUG_HIGH_ON THEN
3505: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3506: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3507: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3508: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3509: END IF;
3510:

Line 3507: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);

3503:
3504: IF OZF_DEBUG_HIGH_ON THEN
3505: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3506: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3507: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3508: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3509: END IF;
3510:
3511:

Line 3508: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);

3504: IF OZF_DEBUG_HIGH_ON THEN
3505: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3506: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3507: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3508: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3509: END IF;
3510:
3511:
3512: ----------------------------

Line 3516: OZF_Utility_PVT.debug_message('2. Create Master Claim');

3512: ----------------------------
3513: -- 2. Create Master Claim --
3514: ----------------------------
3515: IF OZF_DEBUG_HIGH_ON THEN
3516: OZF_Utility_PVT.debug_message('2. Create Master Claim');
3517: END IF;
3518:
3519: -- Get Claim Type/Reason from Claim Defaulting Rule
3520: l_group_claim_rec.claim_class := 'GROUP';

Line 3533: OZF_Utility_PVT.debug_message('group claim amount = '||l_group_claim_rec.amount);

3529:
3530: l_group_claim_rec.comments := p_group_claim_rec.comments; --hbandi added for the BUG #9961068
3531:
3532: IF OZF_DEBUG_HIGH_ON THEN
3533: OZF_Utility_PVT.debug_message('group claim amount = '||l_group_claim_rec.amount);
3534: END IF;
3535:
3536: l_group_claim_rec.claim_date := SYSDATE;
3537: OPEN csr_get_set_of_books;

Line 3555: OZF_Utility_PVT.debug_message('group claim id = '||l_group_claim_id);

3551: ,p_claim => l_group_claim_rec
3552: ,x_claim_id => l_group_claim_id
3553: );
3554: IF OZF_DEBUG_HIGH_ON THEN
3555: OZF_Utility_PVT.debug_message('group claim id = '||l_group_claim_id);
3556: END IF;
3557:
3558: IF l_return_status = FND_API.g_ret_sts_error THEN
3559: RAISE FND_API.g_exc_error;

Line 3569: OZF_Utility_PVT.debug_message('3. Group Claims');

3565: ---------------------
3566: -- 3. Group Claims --
3567: ---------------------
3568: IF OZF_DEBUG_HIGH_ON THEN
3569: OZF_Utility_PVT.debug_message('3. Group Claims');
3570: END IF;
3571:
3572: i := l_open_claim_tbl.FIRST;
3573: IF i IS NOT NULL THEN

Line 3576: OZF_Utility_PVT.debug_message('Update Claim Id:'||l_open_claim_tbl(i).claim_id);

3572: i := l_open_claim_tbl.FIRST;
3573: IF i IS NOT NULL THEN
3574: LOOP
3575: IF OZF_DEBUG_HIGH_ON THEN
3576: OZF_Utility_PVT.debug_message('Update Claim Id:'||l_open_claim_tbl(i).claim_id);
3577: END IF;
3578:
3579: BEGIN
3580: UPDATE ozf_claims_all

Line 3610: --ozf_utility_pvt.debug_message(l_open_claim_tbl(i).amount_settled||'amount settled');

3606:
3607: -- -------------
3608: -- Split Claims
3609: -- -------------
3610: --ozf_utility_pvt.debug_message(l_open_claim_tbl(i).amount_settled||'amount settled');
3611: IF ABS(l_open_claim_tbl(i).amount_settled) < ABS(l_claim_amount_rem) THEN
3612: --l_split_claim_tbl(1).claim_type_id := p_claim_rec.claim_type_id;
3613: --l_split_claim_tbl(1).reason_code_id := p_claim_rec.reason_code_id;
3614: l_split_claim_tbl(1).amount := l_claim_amount_rem

Line 3621: OZF_Utility_PVT.debug_message('Split Claim '||l_open_claim_tbl(i).claim_number||' for '||l_split_claim_tbl(1).amount);

3617: l_split_claim_tbl(1).parent_claim_id := l_open_claim_tbl(i).claim_id;
3618: l_split_claim_tbl(1).parent_object_ver_num := l_obj_ver_num;
3619: l_split_claim_tbl(1).line_table := NULL;
3620:
3621: OZF_Utility_PVT.debug_message('Split Claim '||l_open_claim_tbl(i).claim_number||' for '||l_split_claim_tbl(1).amount);
3622:
3623: l_group_rem_amt := l_group_rem_amt + l_split_claim_tbl(1).amount;
3624:
3625: OZF_SPLIT_CLAIM_PVT.create_child_claim_tbl (

Line 3657: OZF_Utility_PVT.debug_message('4. Group Settlement Docs');

3653: ------------------------------
3654: -- 4. Group Settlement Docs --
3655: ------------------------------
3656: IF OZF_DEBUG_HIGH_ON THEN
3657: OZF_Utility_PVT.debug_message('4. Group Settlement Docs');
3658: END IF;
3659:
3660: i := p_open_transaction_tbl.FIRST;
3661: IF i IS NOT NULL THEN

Line 3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');

3727: IF OZF_DEBUG_HIGH_ON THEN
3728: i := l_group_settle_doc_tbl.FIRST;
3729: IF i IS NOT NULL THEN
3730: LOOP
3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);

Line 3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);

3728: i := l_group_settle_doc_tbl.FIRST;
3729: IF i IS NOT NULL THEN
3730: LOOP
3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);

Line 3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);

3729: IF i IS NOT NULL THEN
3730: LOOP
3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);

Line 3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);

3730: LOOP
3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3738: EXIT WHEN i = l_group_settle_doc_tbl.LAST;

Line 3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);

3731: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3738: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3739: i := l_group_settle_doc_tbl.NEXT(i);

Line 3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);

3732: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3738: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3739: i := l_group_settle_doc_tbl.NEXT(i);
3740: END LOOP;

Line 3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);

3733: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3734: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3735: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3736: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3737: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3738: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3739: i := l_group_settle_doc_tbl.NEXT(i);
3740: END LOOP;
3741: END IF;

Line 3748: OZF_Utility_PVT.debug_message('5. Create Settlement Docs of Mass Claim');

3744: ---------------------------------------------
3745: -- 5. Create Settlement Docs of Mass Claim --
3746: ---------------------------------------------
3747: IF OZF_DEBUG_HIGH_ON THEN
3748: OZF_Utility_PVT.debug_message('5. Create Settlement Docs of Mass Claim');
3749: END IF;
3750:
3751: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
3752: p_api_version_number => l_api_version,

Line 3772: OZF_Utility_PVT.debug_message('6. Break Mass Settlement');

3768: ------------------------------
3769: -- 6. Break Mass Settlement --
3770: ------------------------------
3771: IF OZF_DEBUG_HIGH_ON THEN
3772: OZF_Utility_PVT.debug_message('6. Break Mass Settlement');
3773: END IF;
3774:
3775: Break_Mass_Settlement(
3776: p_group_claim_id => l_group_claim_id,

Line 3793: OZF_Utility_PVT.debug_message('7. Complete Mass Settlement');

3789: ---------------------------------
3790: -- 7. Complete Mass Settlement --
3791: ---------------------------------
3792: IF OZF_DEBUG_HIGH_ON THEN
3793: OZF_Utility_PVT.debug_message('7. Complete Mass Settlement');
3794: END IF;
3795:
3796: Complete_Mass_Settlement(
3797: p_group_claim_id => l_group_claim_id,

Line 3870: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');

3866: /* --------------------------------
3867: -- 8. Approve Mass Settlement --
3868: --------------------------------
3869: IF OZF_DEBUG_HIGH_ON THEN
3870: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');
3871: END IF;
3872:
3873: Approve_Mass_Settlement(
3874: p_group_claim_id => l_group_claim_id,

Line 3896: OZF_Utility_PVT.debug_message('9. Start Mass Payment');

3892: ---------------------------
3893: -- 9. Start Mass Payment --
3894: ---------------------------
3895: IF OZF_DEBUG_HIGH_ON THEN
3896: OZF_Utility_PVT.debug_message('9. Start Mass Payment');
3897: END IF;
3898:
3899: Start_Mass_Payment(
3900: p_group_claim_id => l_group_claim_id,

Line 3912: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');

3908: RAISE FND_API.g_exc_unexpected_error;
3909: END IF;
3910: ELSE
3911: IF OZF_DEBUG_HIGH_ON THEN
3912: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');
3913: END IF;
3914:
3915: Approve_Mass_Settlement(
3916: p_group_claim_id => l_group_claim_id,

Line 3931: OZF_Utility_PVT.debug_message(l_full_name||': end');

3927: END IF;
3928: END IF;
3929:
3930: IF OZF_DEBUG_HIGH_ON THEN
3931: OZF_Utility_PVT.debug_message(l_full_name||': end');
3932: END IF;
3933:
3934:
3935: ------------------------ finish ------------------------