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 761: OZF_Utility_PVT.debug_message('Invoice Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1057: OPEN csr_dm_exist_on_rec(p_claim_rec.receipt_id, p_payment_reference_id);
1058: 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
1059: CLOSE csr_dm_exist_on_rec;
1060:
1061: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation');
1062: -- 1. Unapply claim investigation
1063: OPEN csr_claim_investigation_amount(p_claim_rec.root_claim_id);
1064: FETCH csr_claim_investigation_amount INTO l_orig_dispute_amount;
1065: CLOSE csr_claim_investigation_amount;

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

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

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

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

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

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

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

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

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

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

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

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

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

1176: END IF;
1177: END IF;
1178:
1179: IF OZF_DEBUG_HIGH_ON THEN
1180: OZF_Utility_PVT.debug_message(l_full_name||': end');
1181: END IF;
1182: EXCEPTION
1183: WHEN FND_API.g_exc_error THEN
1184: x_return_status := FND_API.g_ret_sts_error;

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

1226:
1227: BEGIN
1228: -------------------- initialize -----------------------
1229: IF OZF_DEBUG_HIGH_ON THEN
1230: OZF_Utility_PVT.debug_message(l_full_name||': start');
1231: END IF;
1232:
1233: x_return_status := FND_API.g_ret_sts_success;
1234:

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

1271: RAISE FND_API.g_exc_unexpected_error;
1272: END IF;
1273:
1274: IF OZF_DEBUG_HIGH_ON THEN
1275: OZF_Utility_PVT.debug_message('x_cb_customer_trx_id = '||l_cb_customer_trx_id);
1276: END IF;
1277:
1278: /*------------------------------------------------------------*
1279: | Update Deduction payment detail

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

1312: END IF;
1313:
1314:
1315: IF OZF_DEBUG_HIGH_ON THEN
1316: OZF_Utility_PVT.debug_message(l_full_name||': end');
1317: END IF;
1318: EXCEPTION
1319: WHEN FND_API.g_exc_error THEN
1320: x_return_status := FND_API.g_ret_sts_error;

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

1362:
1363: BEGIN
1364: -------------------- initialize -----------------------
1365: IF OZF_DEBUG_HIGH_ON THEN
1366: OZF_Utility_PVT.debug_message(l_full_name||': start');
1367: END IF;
1368:
1369: x_return_status := FND_API.g_ret_sts_success;
1370:

Line 1393: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

1389: BEGIN
1390: UPDATE ozf_claims_all
1391: SET payment_status = 'PENDING'
1392: , status_code = 'PENDING_CLOSE'
1393: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
1394: 'OZF_CLAIM_STATUS'
1395: ,'PENDING_CLOSE'
1396: )
1397: WHERE claim_id = p_claim_rec.claim_id;

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

1445: END IF;
1446: END IF;
1447:
1448: IF OZF_DEBUG_HIGH_ON THEN
1449: OZF_Utility_PVT.debug_message(l_full_name||': end');
1450: END IF;
1451: EXCEPTION
1452: WHEN FND_API.g_exc_error THEN
1453: x_return_status := FND_API.g_ret_sts_error;

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

1505:
1506: BEGIN
1507: -------------------- initialize -----------------------
1508: IF OZF_DEBUG_HIGH_ON THEN
1509: OZF_Utility_PVT.debug_message(l_full_name||': start');
1510: END IF;
1511:
1512: x_return_status := FND_API.g_ret_sts_success;
1513:

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

1534: | Overpayment -> 1. Unapply claim investigation
1535: | 2. Apply On Account Credit
1536: *------------------------------------------------------------*/
1537: IF OZF_DEBUG_HIGH_ON THEN
1538: OZF_Utility_PVT.debug_message('Overpayment -> 1. Unapply claim investigation.');
1539: END IF;
1540: -- 1. Unapply claim investigation
1541: OPEN csr_old_claim_investigation(p_claim_rec.receipt_id, p_claim_rec.root_claim_id);
1542: FETCH csr_old_claim_investigation INTO l_old_applied_claim_amount;

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

1557: RAISE FND_API.g_exc_unexpected_error;
1558: END IF;
1559:
1560: IF OZF_DEBUG_HIGH_ON THEN
1561: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply On Account Credit.');
1562: END IF;
1563: --2. Apply On Account Credit
1564: OZF_AR_PAYMENT_PVT.Apply_On_Account_Credit(
1565: p_claim_rec => p_claim_rec

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

1578: | Update Deduction payment detail
1579: *------------------------------------------------------------*/
1580: -- Update Deduction payment detail
1581: IF OZF_DEBUG_HIGH_ON THEN
1582: OZF_Utility_PVT.debug_message('cash_receipt_id = '||p_claim_rec.receipt_id);
1583: END IF;
1584: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1585: p_api_version => l_api_version
1586: ,p_init_msg_list => FND_API.g_false

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

1612: RAISE FND_API.g_exc_error;
1613: END IF;
1614:
1615: IF OZF_DEBUG_HIGH_ON THEN
1616: OZF_Utility_PVT.debug_message(l_full_name||': end');
1617: END IF;
1618: EXCEPTION
1619: WHEN FND_API.g_exc_error THEN
1620: x_return_status := FND_API.g_ret_sts_error;

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

1716: -------------------- initialize -----------------------
1717: SAVEPOINT Break_Mass_Settlement;
1718:
1719: IF OZF_DEBUG_HIGH_ON THEN
1720: OZF_Utility_PVT.debug_message(l_full_name||': start');
1721: END IF;
1722:
1723: x_return_status := FND_API.G_RET_STS_SUCCESS;
1724:

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

1723: x_return_status := FND_API.G_RET_STS_SUCCESS;
1724:
1725: ------------------------ start -------------------------
1726: IF OZF_DEBUG_HIGH_ON THEN
1727: OZF_Utility_PVT.debug_message('Settlement Type = '||p_settlement_type);
1728: END IF;
1729:
1730: IF p_settlement_type <> 'NETTING' THEN
1731: l_idx := 1;

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

1874:
1875: l_claim_netting_tbl(l_idx_netting_claim).amount_remaining := 0;
1876:
1877: IF OZF_DEBUG_HIGH_ON THEN
1878: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1879: l_group_claim_line_tbl(i).payment_reference_number||
1880: ' ... '||
1881: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1882: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_reference_number||

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

1902:
1903: l_amount_settled := 0;
1904:
1905: IF OZF_DEBUG_HIGH_ON THEN
1906: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1907: l_group_claim_line_tbl(i).payment_reference_number||
1908: ' ... '||
1909: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1910: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_reference_number||

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

1948:
1949: l_settle_doc_group_tbl(l_idx_settle_doc_group).settlement_amount := 0;
1950:
1951: IF OZF_DEBUG_HIGH_ON THEN
1952: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1953: l_group_claim_line_tbl(i).payment_reference_number||
1954: ' ... '||
1955: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1956: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_method||

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

1972:
1973: l_amount_settled := 0;
1974:
1975: IF OZF_DEBUG_HIGH_ON THEN
1976: OZF_Utility_PVT.debug_message('('||l_idx_setl_doc||')'||
1977: l_group_claim_line_tbl(i).payment_reference_number||
1978: ' ... '||
1979: l_settle_doc_tbl(l_idx_setl_doc).settlement_amount||
1980: ' >>> '||l_settle_doc_tbl(l_idx_setl_doc).payment_method||

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

2026:
2027: IF OZF_DEBUG_HIGH_ON THEN
2028: i := l_group_claim_line_tbl.FIRST;
2029: IF i IS NOT NULL THEN
2030: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2031: LOOP
2032: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2033: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2034: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);

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

2028: i := l_group_claim_line_tbl.FIRST;
2029: IF i IS NOT NULL THEN
2030: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2031: LOOP
2032: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2033: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2034: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2035: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2036: i := l_group_claim_line_tbl.NEXT(i);

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

2029: IF i IS NOT NULL THEN
2030: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2031: LOOP
2032: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2033: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2034: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2035: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2036: i := l_group_claim_line_tbl.NEXT(i);
2037: END LOOP;

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

2030: OZF_Utility_PVT.debug_message('--- Mass Settlement Claims ---');
2031: LOOP
2032: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2033: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').claim_currency_amount = '||l_group_claim_line_tbl(i).claim_currency_amount);
2034: OZF_Utility_PVT.debug_message('l_group_claim_line_tbl('||i||').payment_reference_number = '||l_group_claim_line_tbl(i).payment_reference_number);
2035: EXIT WHEN i = l_group_claim_line_tbl.LAST;
2036: i := l_group_claim_line_tbl.NEXT(i);
2037: END LOOP;
2038: END IF;

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

2065:
2066: IF OZF_DEBUG_HIGH_ON THEN
2067: i := l_settle_doc_tbl.FIRST;
2068: IF i IS NOT NULL THEN
2069: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2070: LOOP
2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);

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

2067: i := l_settle_doc_tbl.FIRST;
2068: IF i IS NOT NULL THEN
2069: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2070: LOOP
2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);

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

2068: IF i IS NOT NULL THEN
2069: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2070: LOOP
2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);

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

2069: OZF_Utility_PVT.debug_message('--- Mass Settlement Payment Details ---');
2070: LOOP
2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);

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

2070: LOOP
2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);

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

2071: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2079: EXIT WHEN i = l_settle_doc_tbl.LAST;

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

2072: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').claim_id = '||l_settle_doc_tbl(i).claim_id);
2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2079: EXIT WHEN i = l_settle_doc_tbl.LAST;
2080: i := l_settle_doc_tbl.NEXT(i);

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

2073: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_id = '||l_settle_doc_tbl(i).settlement_id);
2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2079: EXIT WHEN i = l_settle_doc_tbl.LAST;
2080: i := l_settle_doc_tbl.NEXT(i);
2081: END LOOP;

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

2074: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_number = '||l_settle_doc_tbl(i).settlement_number);
2075: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').settlement_amount = '||l_settle_doc_tbl(i).settlement_amount);
2076: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_method = '||l_settle_doc_tbl(i).payment_method);
2077: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_id = '||l_settle_doc_tbl(i).payment_reference_id);
2078: OZF_Utility_PVT.debug_message('l_settle_doc_tbl('||i||').payment_reference_number = '||l_settle_doc_tbl(i).payment_reference_number);
2079: EXIT WHEN i = l_settle_doc_tbl.LAST;
2080: i := l_settle_doc_tbl.NEXT(i);
2081: END LOOP;
2082: END IF;

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

2081: END LOOP;
2082: END IF;
2083: i := l_settle_doc_tbl2.FIRST;
2084: IF i IS NOT NULL THEN
2085: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2086: LOOP
2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);

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

2083: i := l_settle_doc_tbl2.FIRST;
2084: IF i IS NOT NULL THEN
2085: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2086: LOOP
2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);

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

2084: IF i IS NOT NULL THEN
2085: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2086: LOOP
2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);

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

2085: OZF_Utility_PVT.debug_message('--- Mass Settlement Group Payment Details ---');
2086: LOOP
2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);

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

2086: LOOP
2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);

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

2087: OZF_Utility_PVT.debug_message('--- '||i||' ---');
2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2095: EXIT WHEN i = l_settle_doc_tbl2.LAST;

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

2088: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').claim_id = '||l_settle_doc_tbl2(i).claim_id);
2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2095: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2096: i := l_settle_doc_tbl2.NEXT(i);

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

2089: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_id = '||l_settle_doc_tbl2(i).settlement_id);
2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2095: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2096: i := l_settle_doc_tbl2.NEXT(i);
2097: END LOOP;

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

2090: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_number = '||l_settle_doc_tbl2(i).settlement_number);
2091: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').settlement_amount = '||l_settle_doc_tbl2(i).settlement_amount);
2092: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_method = '||l_settle_doc_tbl2(i).payment_method);
2093: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_id = '||l_settle_doc_tbl2(i).payment_reference_id);
2094: OZF_Utility_PVT.debug_message('l_settle_doc_tbl2('||i||').payment_reference_number = '||l_settle_doc_tbl2(i).payment_reference_number);
2095: EXIT WHEN i = l_settle_doc_tbl2.LAST;
2096: i := l_settle_doc_tbl2.NEXT(i);
2097: END LOOP;
2098: END IF;

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

2141: END IF;
2142: END IF;
2143:
2144: IF OZF_DEBUG_HIGH_ON THEN
2145: OZF_Utility_PVT.debug_message(l_full_name||': end');
2146: END IF;
2147:
2148: EXCEPTION
2149: WHEN FND_API.g_exc_error THEN

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

2225: -------------------- initialize -----------------------
2226: SAVEPOINT Complete_Mass_Settlement;
2227:
2228: IF OZF_DEBUG_HIGH_ON THEN
2229: OZF_Utility_PVT.debug_message(l_full_name||': start');
2230: END IF;
2231:
2232: x_return_status := FND_API.G_RET_STS_SUCCESS;
2233:

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

2249: END IF;
2250:
2251: x_claim_tbl(i).payment_method := 'MASS_SETTLEMENT';
2252: x_claim_tbl(i).status_code := 'COMPLETE';
2253: x_claim_tbl(i).user_status_id := OZF_UTILITY_PVT.get_default_user_status(
2254: 'OZF_CLAIM_STATUS'
2255: ,'COMPLETE'
2256: );
2257: i := i + 1;

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

2293: END LOOP;
2294: END IF;
2295:
2296: IF OZF_DEBUG_HIGH_ON THEN
2297: OZF_Utility_PVT.debug_message(l_full_name||': end');
2298: END IF;
2299:
2300: EXCEPTION
2301: WHEN FND_API.g_exc_error THEN

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

2383: -------------------- initialize -----------------------
2384: SAVEPOINT Approve_Mass_Settlement;
2385:
2386: IF OZF_DEBUG_HIGH_ON THEN
2387: OZF_Utility_PVT.debug_message(l_full_name||': start');
2388: END IF;
2389:
2390: x_return_status := FND_API.G_RET_STS_SUCCESS;
2391:

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

2402: OPEN csr_claim_obj_ver(p_complete_claim_group_tbl(i).claim_id);
2403: FETCH csr_claim_obj_ver INTO l_claim_pvt_rec.object_version_number;
2404: CLOSE csr_claim_obj_ver;
2405:
2406: l_claim_pvt_rec.user_status_id := OZF_UTILITY_PVT.get_default_user_status(
2407: 'OZF_CLAIM_STATUS'
2408: ,'PENDING_APPROVAL'
2409: );
2410: l_claim_pvt_rec.status_code := 'PENDING_APPROVAL';

Line 2443: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(

2439: OPEN csr_claim_obj_ver(p_group_claim_id);
2440: FETCH csr_claim_obj_ver INTO l_group_claim_obj_ver;
2441: CLOSE csr_claim_obj_ver;
2442:
2443: l_orig_status_id := OZF_UTILITY_PVT.get_default_user_status(
2444: 'OZF_CLAIM_STATUS'
2445: ,'OPEN'
2446: );
2447:

Line 2448: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(

2444: 'OZF_CLAIM_STATUS'
2445: ,'OPEN'
2446: );
2447:
2448: l_new_status_id := OZF_UTILITY_PVT.get_default_user_status(
2449: 'OZF_CLAIM_STATUS'
2450: ,'CLOSED'
2451: );
2452:

Line 2453: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(

2449: 'OZF_CLAIM_STATUS'
2450: ,'CLOSED'
2451: );
2452:
2453: l_reject_status_id := OZF_UTILITY_PVT.get_default_user_status(
2454: 'OZF_CLAIM_STATUS'
2455: ,'REJECTED'
2456: );
2457:

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

2454: 'OZF_CLAIM_STATUS'
2455: ,'REJECTED'
2456: );
2457:
2458: l_owner_id := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2459:
2460: --//Added by BKUNJAN Bug#5686706
2461: UPDATE ozf_claims_all
2462: SET payment_status = 'PENDING'

Line 2464: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

2460: --//Added by BKUNJAN Bug#5686706
2461: UPDATE ozf_claims_all
2462: SET payment_status = 'PENDING'
2463: , status_code = 'PENDING_APPROVAL'
2464: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2465: 'OZF_CLAIM_STATUS'
2466: ,'PENDING_APPROVAL'
2467: )
2468: WHERE claim_id = p_group_claim_id;

Line 2495: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(

2491: /*
2492: UPDATE ozf_claims_all
2493: SET payment_status = 'PENDING'
2494: , status_code = 'PENDING_APPROVAL'
2495: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2496: 'OZF_CLAIM_STATUS'
2497: ,'PENDING_APPROVAL'
2498: )
2499: WHERE claim_id = p_group_claim_id;

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

2502:
2503: END IF;
2504:
2505: IF OZF_DEBUG_HIGH_ON THEN
2506: OZF_Utility_PVT.debug_message(l_full_name||': end');
2507: END IF;
2508:
2509:
2510: EXCEPTION

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

2571: AND system_status_code = cv_status_code;
2572:
2573: BEGIN
2574: IF OZF_DEBUG_HIGH_ON THEN
2575: OZF_Utility_PVT.debug_message(l_full_name||': start');
2576: END IF;
2577:
2578: OPEN csr_user_status_id('REJECTED');
2579: FETCH csr_user_status_id INTO l_rejected_user_status_id;

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

2622: RAISE FND_API.g_exc_unexpected_error;
2623: END;
2624:
2625: IF OZF_DEBUG_HIGH_ON THEN
2626: OZF_Utility_PVT.debug_message(l_full_name||': end');
2627: END IF;
2628:
2629: EXCEPTION
2630: WHEN FND_API.g_exc_error THEN

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

2724: -------------------- initialize -----------------------
2725: SAVEPOINT Start_Mass_Payment;
2726:
2727: IF OZF_DEBUG_HIGH_ON THEN
2728: OZF_Utility_PVT.debug_message(l_full_name||': start');
2729: END IF;
2730:
2731: x_return_status := FND_API.G_RET_STS_SUCCESS;
2732:

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

2804: j := l_settlement_doc_tbl.FIRST;
2805: IF j IS NOT NULL THEN
2806: LOOP
2807: IF OZF_DEBUG_HIGH_ON THEN
2808: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);

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

2805: IF j IS NOT NULL THEN
2806: LOOP
2807: IF OZF_DEBUG_HIGH_ON THEN
2808: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);

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

2806: LOOP
2807: IF OZF_DEBUG_HIGH_ON THEN
2808: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);

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

2807: IF OZF_DEBUG_HIGH_ON THEN
2808: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);

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

2808: OZF_Utility_PVT.debug_message('Payment -- ('||j||')');
2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2816: END IF;

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

2809: OZF_Utility_PVT.debug_message('Payment -- payment_method = '||l_settlement_doc_tbl(j).payment_method);
2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2816: END IF;
2817:

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

2810: OZF_Utility_PVT.debug_message('Payment -- settlement_doc_id = '||l_settlement_doc_tbl(j).settlement_doc_id);
2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2816: END IF;
2817:
2818: BEGIN

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

2811: OZF_Utility_PVT.debug_message('Payment -- settlement_id = '||l_settlement_doc_tbl(j).settlement_id);
2812: OZF_Utility_PVT.debug_message('Payment -- settlement_number = '||l_settlement_doc_tbl(j).settlement_number);
2813: OZF_Utility_PVT.debug_message('Payment -- settlement_amount = '||l_settlement_doc_tbl(j).settlement_amount);
2814: OZF_Utility_PVT.debug_message('Payment -- payment_reference_id = '||l_settlement_doc_tbl(j).payment_reference_id);
2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2816: END IF;
2817:
2818: BEGIN
2819: UPDATE ozf_settlement_docs_all

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

2986: RAISE FND_API.g_exc_unexpected_error;
2987: END;
2988:
2989: IF OZF_DEBUG_HIGH_ON THEN
2990: OZF_Utility_PVT.debug_message(l_full_name||': end');
2991: END IF;
2992:
2993: EXCEPTION
2994: WHEN FND_API.g_exc_error THEN

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

3150: -------------------- initialize -----------------------
3151: SAVEPOINT Settle_Mass_Settlement;
3152:
3153: IF OZF_DEBUG_HIGH_ON THEN
3154: OZF_Utility_PVT.debug_message(l_full_name||': start');
3155: END IF;
3156:
3157: -- Standard call to check for call compatibility.
3158: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

3174: -------------------
3175: -- 1. Validation --
3176: -------------------
3177: IF OZF_DEBUG_HIGH_ON THEN
3178: OZF_Utility_PVT.debug_message('1. Validation');
3179: END IF;
3180:
3181: i := p_open_claim_tbl.FIRST;
3182: IF i IS NOT NULL THEN

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

3183: LOOP
3184: l_open_claim_amt := l_open_claim_amt + p_open_claim_tbl(i).amount_settled;
3185:
3186: IF OZF_DEBUG_HIGH_ON THEN
3187: OZF_Utility_PVT.debug_message('open_claim_amt('||i||') = '||p_open_claim_tbl(i).amount_settled);
3188: END IF;
3189: IF p_open_claim_tbl(i).claim_class = l_settlement_type THEN
3190: l_overpay_amt := l_overpay_amt + l_open_claim_tbl(i).amount_settled * -1 ;
3191: END IF;

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

3240:
3241: l_open_trx_amt := l_open_trx_amt + p_open_transaction_tbl(i).amount_settled;
3242: EXIT WHEN i = p_open_transaction_tbl.LAST;
3243: IF OZF_DEBUG_HIGH_ON THEN
3244: OZF_Utility_PVT.debug_message('open_trx_amt('||i||') = '||p_open_transaction_tbl(i).amount_settled);
3245: END IF;
3246: i := p_open_transaction_tbl.NEXT(i);
3247: END LOOP;
3248: END IF;

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

3276:
3277: l_pay_method_amt := l_pay_method_amt + (p_payment_method_tbl(i).amount_settled * -1);
3278: EXIT WHEN i = p_payment_method_tbl.LAST;
3279: IF OZF_DEBUG_HIGH_ON THEN
3280: OZF_Utility_PVT.debug_message('pay_method_amt('||i||') = '||p_payment_method_tbl(i).amount_settled);
3281: END IF;
3282: /*
3283: l_gl_date := p_payment_method_tbl(i).gl_date;
3284: l_wo_rec_trx_id := p_payment_method_tbl(i).wo_rec_trx_id;

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

3348: END LOOP;
3349: END IF;
3350:
3351: IF OZF_DEBUG_HIGH_ON THEN
3352: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3353: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3354: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3355: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3356: END IF;

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

3349: END IF;
3350:
3351: IF OZF_DEBUG_HIGH_ON THEN
3352: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3353: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3354: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3355: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3356: END IF;
3357:

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

3350:
3351: IF OZF_DEBUG_HIGH_ON THEN
3352: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3353: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3354: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3355: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3356: END IF;
3357:
3358:

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

3351: IF OZF_DEBUG_HIGH_ON THEN
3352: OZF_Utility_PVT.debug_message('total open_claim_amt = '||l_open_claim_amt);
3353: OZF_Utility_PVT.debug_message('total open_trx_amt = '||l_open_trx_amt);
3354: OZF_Utility_PVT.debug_message('total pay_method_amt = '||l_pay_method_amt);
3355: OZF_Utility_PVT.debug_message('total claim_pay_amt = '||l_overpay_amt);
3356: END IF;
3357:
3358:
3359: ----------------------------

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

3359: ----------------------------
3360: -- 2. Create Master Claim --
3361: ----------------------------
3362: IF OZF_DEBUG_HIGH_ON THEN
3363: OZF_Utility_PVT.debug_message('2. Create Master Claim');
3364: END IF;
3365:
3366: -- Get Claim Type/Reason from Claim Defaulting Rule
3367: l_group_claim_rec.claim_class := 'GROUP';

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

3374: l_group_claim_rec.org_id := p_group_claim_rec.org_id;
3375: l_group_claim_rec.user_status_id := 2006;
3376:
3377: IF OZF_DEBUG_HIGH_ON THEN
3378: OZF_Utility_PVT.debug_message('group claim amount = '||l_group_claim_rec.amount);
3379: END IF;
3380:
3381: l_group_claim_rec.claim_date := SYSDATE;
3382: OPEN csr_get_set_of_books;

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

3396: ,p_claim => l_group_claim_rec
3397: ,x_claim_id => l_group_claim_id
3398: );
3399: IF OZF_DEBUG_HIGH_ON THEN
3400: OZF_Utility_PVT.debug_message('group claim id = '||l_group_claim_id);
3401: END IF;
3402:
3403: IF l_return_status = FND_API.g_ret_sts_error THEN
3404: RAISE FND_API.g_exc_error;

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

3410: ---------------------
3411: -- 3. Group Claims --
3412: ---------------------
3413: IF OZF_DEBUG_HIGH_ON THEN
3414: OZF_Utility_PVT.debug_message('3. Group Claims');
3415: END IF;
3416:
3417: i := l_open_claim_tbl.FIRST;
3418: IF i IS NOT NULL THEN

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

3417: i := l_open_claim_tbl.FIRST;
3418: IF i IS NOT NULL THEN
3419: LOOP
3420: IF OZF_DEBUG_HIGH_ON THEN
3421: OZF_Utility_PVT.debug_message('Update Claim Id:'||l_open_claim_tbl(i).claim_id);
3422: END IF;
3423:
3424: BEGIN
3425: UPDATE ozf_claims_all

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

3450:
3451: -- -------------
3452: -- Split Claims
3453: -- -------------
3454: --ozf_utility_pvt.debug_message(l_open_claim_tbl(i).amount_settled||'amount settled');
3455: IF ABS(l_open_claim_tbl(i).amount_settled) < ABS(l_claim_amount_rem) THEN
3456: --l_split_claim_tbl(1).claim_type_id := p_claim_rec.claim_type_id;
3457: --l_split_claim_tbl(1).reason_code_id := p_claim_rec.reason_code_id;
3458: l_split_claim_tbl(1).amount := l_claim_amount_rem

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

3461: l_split_claim_tbl(1).parent_claim_id := l_open_claim_tbl(i).claim_id;
3462: l_split_claim_tbl(1).parent_object_ver_num := l_obj_ver_num;
3463: l_split_claim_tbl(1).line_table := NULL;
3464:
3465: OZF_Utility_PVT.debug_message('Split Claim '||l_open_claim_tbl(i).claim_number||' for '||l_split_claim_tbl(1).amount);
3466:
3467: l_group_rem_amt := l_group_rem_amt + l_split_claim_tbl(1).amount;
3468:
3469: OZF_SPLIT_CLAIM_PVT.create_child_claim_tbl (

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

3497: ------------------------------
3498: -- 4. Group Settlement Docs --
3499: ------------------------------
3500: IF OZF_DEBUG_HIGH_ON THEN
3501: OZF_Utility_PVT.debug_message('4. Group Settlement Docs');
3502: END IF;
3503:
3504: i := p_open_transaction_tbl.FIRST;
3505: IF i IS NOT NULL THEN

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

3571: IF OZF_DEBUG_HIGH_ON THEN
3572: i := l_group_settle_doc_tbl.FIRST;
3573: IF i IS NOT NULL THEN
3574: LOOP
3575: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);

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

3572: i := l_group_settle_doc_tbl.FIRST;
3573: IF i IS NOT NULL THEN
3574: LOOP
3575: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);

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

3573: IF i IS NOT NULL THEN
3574: LOOP
3575: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3581: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);

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

3574: LOOP
3575: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3581: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3582: EXIT WHEN i = l_group_settle_doc_tbl.LAST;

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

3575: OZF_Utility_PVT.debug_message('--- '||i||' ---');
3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3581: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3582: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3583: i := l_group_settle_doc_tbl.NEXT(i);

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

3576: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').claim_id (group) = '||l_group_settle_doc_tbl(i).claim_id);
3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3581: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3582: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3583: i := l_group_settle_doc_tbl.NEXT(i);
3584: END LOOP;

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

3577: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_id = '||l_group_settle_doc_tbl(i).settlement_id);
3578: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_number = '||l_group_settle_doc_tbl(i).settlement_number);
3579: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').settlement_amount = '||l_group_settle_doc_tbl(i).settlement_amount);
3580: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_method = '||l_group_settle_doc_tbl(i).payment_method);
3581: OZF_Utility_PVT.debug_message('l_group_settle_doc_tbl('||i||').payment_status = '||l_group_settle_doc_tbl(i).payment_status);
3582: EXIT WHEN i = l_group_settle_doc_tbl.LAST;
3583: i := l_group_settle_doc_tbl.NEXT(i);
3584: END LOOP;
3585: END IF;

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

3588: ---------------------------------------------
3589: -- 5. Create Settlement Docs of Mass Claim --
3590: ---------------------------------------------
3591: IF OZF_DEBUG_HIGH_ON THEN
3592: OZF_Utility_PVT.debug_message('5. Create Settlement Docs of Mass Claim');
3593: END IF;
3594:
3595: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
3596: p_api_version_number => l_api_version,

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

3612: ------------------------------
3613: -- 6. Break Mass Settlement --
3614: ------------------------------
3615: IF OZF_DEBUG_HIGH_ON THEN
3616: OZF_Utility_PVT.debug_message('6. Break Mass Settlement');
3617: END IF;
3618:
3619: Break_Mass_Settlement(
3620: p_group_claim_id => l_group_claim_id,

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

3633: ---------------------------------
3634: -- 7. Complete Mass Settlement --
3635: ---------------------------------
3636: IF OZF_DEBUG_HIGH_ON THEN
3637: OZF_Utility_PVT.debug_message('7. Complete Mass Settlement');
3638: END IF;
3639:
3640: Complete_Mass_Settlement(
3641: p_group_claim_id => l_group_claim_id,

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

3704: /* --------------------------------
3705: -- 8. Approve Mass Settlement --
3706: --------------------------------
3707: IF OZF_DEBUG_HIGH_ON THEN
3708: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');
3709: END IF;
3710:
3711: Approve_Mass_Settlement(
3712: p_group_claim_id => l_group_claim_id,

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

3730: ---------------------------
3731: -- 9. Start Mass Payment --
3732: ---------------------------
3733: IF OZF_DEBUG_HIGH_ON THEN
3734: OZF_Utility_PVT.debug_message('9. Start Mass Payment');
3735: END IF;
3736:
3737: Start_Mass_Payment(
3738: p_group_claim_id => l_group_claim_id,

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

3746: RAISE FND_API.g_exc_unexpected_error;
3747: END IF;
3748: ELSE
3749: IF OZF_DEBUG_HIGH_ON THEN
3750: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');
3751: END IF;
3752:
3753: Approve_Mass_Settlement(
3754: p_group_claim_id => l_group_claim_id,

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

3765: END IF;
3766: END IF;
3767:
3768: IF OZF_DEBUG_HIGH_ON THEN
3769: OZF_Utility_PVT.debug_message(l_full_name||': end');
3770: END IF;
3771:
3772:
3773: ------------------------ finish ------------------------