APPS.OZF_AR_PAYMENT_PVT dependencies on FND_MSG_PUB

Line 7: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_AR_PAYMENT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(15) := 'ozfvcarpb.pls';
6:
7: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8:
9: /*=======================================================================*
10: | PROCEDURE
11: | Query_Claim

Line 282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

278: WHERE claim_id = p_claim_id ;
279: x_return_status := FND_API.g_ret_sts_success;
280: EXCEPTION
281: WHEN OTHERS THEN
282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
283: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
284: FND_MSG_PUB.add;
285: END IF;
286: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 284: FND_MSG_PUB.add;

280: EXCEPTION
281: WHEN OTHERS THEN
282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
283: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
284: FND_MSG_PUB.add;
285: END IF;
286: x_return_status := FND_API.g_ret_sts_unexp_error;
287: END Query_Claim;
288:

Line 352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

348: x_return_status := FND_API.g_ret_sts_unexp_error ;
349:
350: WHEN OTHERS THEN
351: x_return_status := FND_API.g_ret_sts_unexp_error ;
352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
354: END IF;
355:
356: END Close_Claim;

Line 353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

349:
350: WHEN OTHERS THEN
351: x_return_status := FND_API.g_ret_sts_unexp_error ;
352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
354: END IF;
355:
356: END Close_Claim;
357:

Line 407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

403: x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data
405: );
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
408: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_SPLIT_REAPP_ERR');
409: FND_MSG_PUB.add;
410: END IF;
411: RAISE FND_API.g_exc_error;

Line 409: FND_MSG_PUB.add;

405: );
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
408: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_SPLIT_REAPP_ERR');
409: FND_MSG_PUB.add;
410: END IF;
411: RAISE FND_API.g_exc_error;
412: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

409: FND_MSG_PUB.add;
410: END IF;
411: RAISE FND_API.g_exc_error;
412: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
414: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_SPLIT_REAPP_UERR');
415: FND_MSG_PUB.add;
416: END IF;
417: RAISE FND_API.g_exc_unexpected_error;

Line 415: FND_MSG_PUB.add;

411: RAISE FND_API.g_exc_error;
412: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
414: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_SPLIT_REAPP_UERR');
415: FND_MSG_PUB.add;
416: END IF;
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;
419:

Line 432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

428: x_return_status := FND_API.g_ret_sts_unexp_error ;
429:
430: WHEN OTHERS THEN
431: x_return_status := FND_API.g_ret_sts_unexp_error ;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
434: END IF;
435:
436: END Unapply_Claim_Investigation;

Line 433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

429:
430: WHEN OTHERS THEN
431: x_return_status := FND_API.g_ret_sts_unexp_error ;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
434: END IF;
435:
436: END Unapply_Claim_Investigation;
437:

Line 531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

527: p_secondary_application_ref_id => l_secondary_appl_ref_id,
528: p_customer_reference => l_customer_reference --11.5.10 enhancements. TM should pass.
529: );
530: IF l_return_status = FND_API.g_ret_sts_error THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
532: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_REC_APPACC_ERR');
533: FND_MSG_PUB.add;
534: END IF;
535: RAISE FND_API.g_exc_error;

Line 533: FND_MSG_PUB.add;

529: );
530: IF l_return_status = FND_API.g_ret_sts_error THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
532: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_REC_APPACC_ERR');
533: FND_MSG_PUB.add;
534: END IF;
535: RAISE FND_API.g_exc_error;
536: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

533: FND_MSG_PUB.add;
534: END IF;
535: RAISE FND_API.g_exc_error;
536: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
538: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_REC_APPACC_UERR');
539: FND_MSG_PUB.add;
540: END IF;
541: RAISE FND_API.g_exc_unexpected_error;

Line 539: FND_MSG_PUB.add;

535: RAISE FND_API.g_exc_error;
536: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
538: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_REC_APPACC_UERR');
539: FND_MSG_PUB.add;
540: END IF;
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:

Line 556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

552: x_return_status := FND_API.g_ret_sts_unexp_error ;
553:
554: WHEN OTHERS THEN
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
557: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
558: END IF;
559:
560: END Apply_On_Account_Credit;

Line 557: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

553:
554: WHEN OTHERS THEN
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
557: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
558: END IF;
559:
560: END Apply_On_Account_Credit;
561:

Line 628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

624: p_called_from => NULL,
625: p_cancel_claim_flag => 'N'
626: );
627: IF l_return_status = FND_API.g_ret_sts_error THEN
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
629: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_UNAPP_ERR');
630: FND_MSG_PUB.add;
631: END IF;
632: RAISE FND_API.g_exc_error;

Line 630: FND_MSG_PUB.add;

626: );
627: IF l_return_status = FND_API.g_ret_sts_error THEN
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
629: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_UNAPP_ERR');
630: FND_MSG_PUB.add;
631: END IF;
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

630: FND_MSG_PUB.add;
631: END IF;
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_UNAPP_UERR');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_unexpected_error;

Line 636: FND_MSG_PUB.add;

632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_UNAPP_UERR');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_unexpected_error;
639: END IF;
640:

Line 653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

649: x_return_status := FND_API.g_ret_sts_unexp_error ;
650:
651: WHEN OTHERS THEN
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
655: END IF;
656:
657: END Unapply_from_Receipt;

Line 654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

650:
651: WHEN OTHERS THEN
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
655: END IF;
656:
657: END Unapply_from_Receipt;
658:

Line 723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

719: FETCH csr_trx_balance INTO l_balance_amount;
720: CLOSE csr_trx_balance;
721:
722: IF ABS(p_new_applied_amount) > l_balance_amount THEN
723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
724: FND_MESSAGE.set_name('OZF', 'OZF_SETL_TRX_BAL_ERR');
725: FND_MESSAGE.set_token('APPLY_AMT', p_new_applied_amount);
726: FND_MSG_PUB.add;
727: END IF;

Line 726: FND_MSG_PUB.add;

722: IF ABS(p_new_applied_amount) > l_balance_amount THEN
723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
724: FND_MESSAGE.set_name('OZF', 'OZF_SETL_TRX_BAL_ERR');
725: FND_MESSAGE.set_token('APPLY_AMT', p_new_applied_amount);
726: FND_MSG_PUB.add;
727: END IF;
728: RAISE FND_API.G_EXC_ERROR;
729: END IF;
730:

Line 793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

789: p_customer_reference => p_customer_reference,
790: p_called_from => NULL
791: );
792: IF l_return_status = FND_API.g_ret_sts_error THEN
793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
794: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_APP_ERR');
795: FND_MSG_PUB.add;
796: END IF;
797: RAISE FND_API.g_exc_error;

Line 795: FND_MSG_PUB.add;

791: );
792: IF l_return_status = FND_API.g_ret_sts_error THEN
793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
794: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_APP_ERR');
795: FND_MSG_PUB.add;
796: END IF;
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

795: FND_MSG_PUB.add;
796: END IF;
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_APP_UERR');
801: FND_MSG_PUB.add;
802: END IF;
803: RAISE FND_API.g_exc_unexpected_error;

Line 801: FND_MSG_PUB.add;

797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_REC_APP_UERR');
801: FND_MSG_PUB.add;
802: END IF;
803: RAISE FND_API.g_exc_unexpected_error;
804: END IF;
805:

Line 818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

814: x_return_status := FND_API.g_ret_sts_unexp_error ;
815:
816: WHEN OTHERS THEN
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
819: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
820: END IF;
821:
822: END Apply_on_Receipt;

Line 819: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

815:
816: WHEN OTHERS THEN
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
819: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
820: END IF;
821:
822: END Apply_on_Receipt;
823:

Line 881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

877: x_msg_count => x_msg_count,
878: x_msg_data => x_msg_data
879: );
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
882: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_UPD_DISPUTE_ERR');
883: FND_MSG_PUB.add;
884: END IF;
885: RAISE FND_API.g_exc_error;

Line 883: FND_MSG_PUB.add;

879: );
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
882: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_UPD_DISPUTE_ERR');
883: FND_MSG_PUB.add;
884: END IF;
885: RAISE FND_API.g_exc_error;
886: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

883: FND_MSG_PUB.add;
884: END IF;
885: RAISE FND_API.g_exc_error;
886: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
888: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_UPD_DISPUTE_UERR');
889: FND_MSG_PUB.add;
890: END IF;
891: RAISE FND_API.g_exc_unexpected_error;

Line 889: FND_MSG_PUB.add;

885: RAISE FND_API.g_exc_error;
886: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
888: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_UPD_DISPUTE_UERR');
889: FND_MSG_PUB.add;
890: END IF;
891: RAISE FND_API.g_exc_unexpected_error;
892: END IF;
893:

Line 906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

902: x_return_status := FND_API.g_ret_sts_unexp_error ;
903:
904: WHEN OTHERS THEN
905: x_return_status := FND_API.g_ret_sts_unexp_error ;
906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
908: END IF;
909:
910: END Update_Dispute_Amount;

Line 907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

903:
904: WHEN OTHERS THEN
905: x_return_status := FND_API.g_ret_sts_unexp_error ;
906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
908: END IF;
909:
910: END Update_Dispute_Amount;
911:

Line 1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1112: p_batch_source_name => l_batch_source_name,
1113: x_request_id => l_request_id
1114: );
1115: IF l_return_status = FND_API.g_ret_sts_error THEN
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1117: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CM_REQ_ERR');
1118: FND_MSG_PUB.add;
1119: END IF;
1120: RAISE FND_API.g_exc_error;

Line 1118: FND_MSG_PUB.add;

1114: );
1115: IF l_return_status = FND_API.g_ret_sts_error THEN
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1117: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CM_REQ_ERR');
1118: FND_MSG_PUB.add;
1119: END IF;
1120: RAISE FND_API.g_exc_error;
1121: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1118: FND_MSG_PUB.add;
1119: END IF;
1120: RAISE FND_API.g_exc_error;
1121: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1123: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CM_REQ_UERR');
1124: FND_MSG_PUB.add;
1125: END IF;
1126: RAISE FND_API.g_exc_unexpected_error;

Line 1124: FND_MSG_PUB.add;

1120: RAISE FND_API.g_exc_error;
1121: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1123: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CM_REQ_UERR');
1124: FND_MSG_PUB.add;
1125: END IF;
1126: RAISE FND_API.g_exc_unexpected_error;
1127: END IF;
1128:

Line 1164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1160: RAISE FND_API.g_exc_unexpected_error;
1161: END IF;
1162:
1163: IF x_cm_customer_trx_id IS NULL THEN
1164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1165: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CRE_ARCM_ERR');
1166: FND_MSG_PUB.add;
1167: END IF;
1168: RAISE FND_API.g_exc_error;

Line 1166: FND_MSG_PUB.add;

1162:
1163: IF x_cm_customer_trx_id IS NULL THEN
1164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1165: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CRE_ARCM_ERR');
1166: FND_MSG_PUB.add;
1167: END IF;
1168: RAISE FND_API.g_exc_error;
1169: -- [04/29/2002]: due to the rollback problem on ar credit memo api, instead of
1170: -- raising error to rollback, calling settlement workflow to proceed.

Line 1182: FND_MSG_PUB.Add;

1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1181: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1182: FND_MSG_PUB.Add;
1183: RAISE FND_API.g_exc_unexpected_error;
1184: END;
1185: END IF;
1186:

Line 1225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1221: x_return_status := FND_API.g_ret_sts_unexp_error ;
1222:
1223: WHEN OTHERS THEN
1224: x_return_status := FND_API.g_ret_sts_unexp_error ;
1225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1227: END IF;
1228:
1229: END Create_AR_Credit_Memo;

Line 1226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1222:
1223: WHEN OTHERS THEN
1224: x_return_status := FND_API.g_ret_sts_unexp_error ;
1225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1227: END IF;
1228:
1229: END Create_AR_Credit_Memo;
1230:

Line 1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1339: CLOSE csr_sysparam_trx;
1340: END IF;
1341:
1342: IF l_cb_trx_type_id IS NULL THEN
1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1344: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CB_TRX_ID_REQ');
1345: FND_MSG_PUB.add;
1346: END IF;
1347: ELSE

Line 1345: FND_MSG_PUB.add;

1341:
1342: IF l_cb_trx_type_id IS NULL THEN
1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1344: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CB_TRX_ID_REQ');
1345: FND_MSG_PUB.add;
1346: END IF;
1347: ELSE
1348: l_chargeback_rec.cust_trx_type_id := l_cb_trx_type_id;
1349: END IF;

Line 1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1475: x_msg_count => x_msg_count,
1476: x_msg_data => x_msg_data
1477: );
1478: IF l_return_status = FND_API.g_ret_sts_error THEN
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1480: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CRE_CB_ERR');
1481: FND_MSG_PUB.add;
1482: END IF;
1483: RAISE FND_API.g_exc_error;

Line 1481: FND_MSG_PUB.add;

1477: );
1478: IF l_return_status = FND_API.g_ret_sts_error THEN
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1480: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CRE_CB_ERR');
1481: FND_MSG_PUB.add;
1482: END IF;
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1481: FND_MSG_PUB.add;
1482: END IF;
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1486: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CRE_CB_UERR');
1487: FND_MSG_PUB.add;
1488: END IF;
1489: RAISE FND_API.g_exc_unexpected_error;

Line 1487: FND_MSG_PUB.add;

1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1486: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AR_CRE_CB_UERR');
1487: FND_MSG_PUB.add;
1488: END IF;
1489: RAISE FND_API.g_exc_unexpected_error;
1490: END IF;
1491:

Line 1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1500: x_return_status := FND_API.g_ret_sts_unexp_error ;
1501:
1502: WHEN OTHERS THEN
1503: x_return_status := FND_API.g_ret_sts_unexp_error ;
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1505: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1506: END IF;
1507:
1508: END Create_AR_Chargeback;

Line 1505: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1501:
1502: WHEN OTHERS THEN
1503: x_return_status := FND_API.g_ret_sts_unexp_error ;
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1505: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1506: END IF;
1507:
1508: END Create_AR_Chargeback;
1509:

Line 1800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1796: p_called_from => 'CLAIMS',
1797: p_old_adjust_id => NULL
1798: );
1799: IF l_return_status = FND_API.g_ret_sts_error THEN
1800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1801: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_ADJ_ERR');
1802: FND_MSG_PUB.add;
1803: END IF;
1804: RAISE FND_API.g_exc_error;

Line 1802: FND_MSG_PUB.add;

1798: );
1799: IF l_return_status = FND_API.g_ret_sts_error THEN
1800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1801: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_ADJ_ERR');
1802: FND_MSG_PUB.add;
1803: END IF;
1804: RAISE FND_API.g_exc_error;
1805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1802: FND_MSG_PUB.add;
1803: END IF;
1804: RAISE FND_API.g_exc_error;
1805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1807: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_ADJ_UERR');
1808: FND_MSG_PUB.add;
1809: END IF;
1810: RAISE FND_API.g_exc_unexpected_error;

Line 1808: FND_MSG_PUB.add;

1804: RAISE FND_API.g_exc_error;
1805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1807: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_ADJ_UERR');
1808: FND_MSG_PUB.add;
1809: END IF;
1810: RAISE FND_API.g_exc_unexpected_error;
1811: END IF;
1812:

Line 1862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1858: x_msg_count => x_msg_count,
1859: x_msg_data => x_msg_data
1860: );
1861: IF l_return_status = FND_API.g_ret_sts_error THEN
1862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1863: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_UPD_DISPUTE_ERR');
1864: FND_MSG_PUB.add;
1865: END IF;
1866: RAISE FND_API.g_exc_error;

Line 1864: FND_MSG_PUB.add;

1860: );
1861: IF l_return_status = FND_API.g_ret_sts_error THEN
1862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1863: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_UPD_DISPUTE_ERR');
1864: FND_MSG_PUB.add;
1865: END IF;
1866: RAISE FND_API.g_exc_error;
1867: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1864: FND_MSG_PUB.add;
1865: END IF;
1866: RAISE FND_API.g_exc_error;
1867: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1869: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_UPD_DISPUTE_UERR');
1870: FND_MSG_PUB.add;
1871: END IF;
1872: RAISE FND_API.g_exc_unexpected_error;

Line 1870: FND_MSG_PUB.add;

1866: RAISE FND_API.g_exc_error;
1867: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1869: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_UPD_DISPUTE_UERR');
1870: FND_MSG_PUB.add;
1871: END IF;
1872: RAISE FND_API.g_exc_unexpected_error;
1873: END IF;
1874:

Line 1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1919: x_msg_count => x_msg_count,
1920: x_msg_data => x_msg_data
1921: );
1922: IF l_return_status = FND_API.g_ret_sts_error THEN
1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1924: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_REC_WO_ERR');
1925: FND_MSG_PUB.add;
1926: END IF;
1927: RAISE FND_API.g_exc_error;

Line 1925: FND_MSG_PUB.add;

1921: );
1922: IF l_return_status = FND_API.g_ret_sts_error THEN
1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1924: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_REC_WO_ERR');
1925: FND_MSG_PUB.add;
1926: END IF;
1927: RAISE FND_API.g_exc_error;
1928: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1925: FND_MSG_PUB.add;
1926: END IF;
1927: RAISE FND_API.g_exc_error;
1928: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1930: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_REC_WO_UERR');
1931: FND_MSG_PUB.add;
1932: END IF;
1933: RAISE FND_API.g_exc_unexpected_error;

Line 1931: FND_MSG_PUB.add;

1927: RAISE FND_API.g_exc_error;
1928: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1930: FND_MESSAGE.set_name('AMS', 'AMS_SETL_AR_CRE_REC_WO_UERR');
1931: FND_MSG_PUB.add;
1932: END IF;
1933: RAISE FND_API.g_exc_unexpected_error;
1934: END IF;
1935:

Line 1971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1967: AND wo_rec_trx_id IS NULL;
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1972: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_GRP_UPD_DEDU_ERR');
1973: FND_MSG_PUB.add;
1974: END IF;
1975:

Line 1973: FND_MSG_PUB.add;

1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1972: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_GRP_UPD_DEDU_ERR');
1973: FND_MSG_PUB.add;
1974: END IF;
1975:
1976: IF g_debug THEN
1977: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1979: FND_MSG_PUB.Add;

1975:
1976: IF g_debug THEN
1977: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1978: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1979: FND_MSG_PUB.Add;
1980: END IF;
1981: RAISE FND_API.g_exc_unexpected_error;
1982: END;
1983: END IF;

Line 1996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1992: x_return_status := FND_API.g_ret_sts_unexp_error ;
1993:
1994: WHEN OTHERS THEN
1995: x_return_status := FND_API.g_ret_sts_unexp_error ;
1996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1997: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1998: END IF;
1999:
2000: END Create_AR_Write_Off;

Line 1997: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1993:
1994: WHEN OTHERS THEN
1995: x_return_status := FND_API.g_ret_sts_unexp_error ;
1996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1997: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1998: END IF;
1999:
2000: END Create_AR_Write_Off;
2001:

Line 2048: FND_MSG_PUB.Add;

2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2047: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2048: FND_MSG_PUB.Add;
2049: RAISE FND_API.g_exc_unexpected_error;
2050: END;
2051:
2052: IF g_debug THEN

Line 2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2057: x_return_status := FND_API.g_ret_sts_unexp_error ;
2058:
2059: WHEN OTHERS THEN
2060: x_return_status := FND_API.g_ret_sts_unexp_error ;
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2062: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2063: END IF;
2064:
2065: END Process_Settlement_WF;

Line 2062: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2058:
2059: WHEN OTHERS THEN
2060: x_return_status := FND_API.g_ret_sts_unexp_error ;
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2062: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2063: END IF;
2064:
2065: END Process_Settlement_WF;
2066:

Line 2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2169:
2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2174: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2175: END IF;
2176: x_return_status := FND_API.g_ret_sts_unexp_error;
2177: END Get_Inv_Credit_Details;

Line 2174: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2174: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2175: END IF;
2176: x_return_status := FND_API.g_ret_sts_unexp_error;
2177: END Get_Inv_Credit_Details;
2178:

Line 2795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2791: x_return_status := FND_API.g_ret_sts_unexp_error ;
2792:
2793: WHEN OTHERS THEN
2794: x_return_status := FND_API.g_ret_sts_unexp_error ;
2795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2796: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2797: END IF;
2798:
2799: END Pay_by_Single_Invoice_Credit;

Line 2796: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2792:
2793: WHEN OTHERS THEN
2794: x_return_status := FND_API.g_ret_sts_unexp_error ;
2795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2796: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2797: END IF;
2798:
2799: END Pay_by_Single_Invoice_Credit;
2800:

Line 3031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3027: END LOOP;
3028: CLOSE csr_claim_lines;
3029: END IF;
3030: ELSE --p_deduction_type NOT IN ('SOURCE_DED', 'RECEIPT_DED', 'CLAIM')
3031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3032: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3033: FND_MESSAGE.set_token('CLAIM_NUMBER', p_claim_rec.claim_number);
3034: FND_MSG_PUB.add;
3035: END IF;

Line 3034: FND_MSG_PUB.add;

3030: ELSE --p_deduction_type NOT IN ('SOURCE_DED', 'RECEIPT_DED', 'CLAIM')
3031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3032: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3033: FND_MESSAGE.set_token('CLAIM_NUMBER', p_claim_rec.claim_number);
3034: FND_MSG_PUB.add;
3035: END IF;
3036: RAISE FND_API.g_exc_error;
3037: END IF;
3038: EXCEPTION

Line 3050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3046:
3047: WHEN OTHERS THEN
3048: x_return_status := FND_API.g_ret_sts_unexp_error ;
3049: ROLLBACK TO Pay_by_Invoice_Credit;
3050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3051: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3052: END IF;
3053:
3054: END Pay_By_Invoice_credit;

Line 3051: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3047: WHEN OTHERS THEN
3048: x_return_status := FND_API.g_ret_sts_unexp_error ;
3049: ROLLBACK TO Pay_by_Invoice_Credit;
3050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3051: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3052: END IF;
3053:
3054: END Pay_By_Invoice_credit;
3055:

Line 3521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3517: x_return_status := FND_API.g_ret_sts_unexp_error ;
3518:
3519: WHEN OTHERS THEN
3520: x_return_status := FND_API.g_ret_sts_unexp_error ;
3521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3523: END IF;
3524:
3525: END Pay_by_Credit_Memo;

Line 3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3518:
3519: WHEN OTHERS THEN
3520: x_return_status := FND_API.g_ret_sts_unexp_error ;
3521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3523: END IF;
3524:
3525: END Pay_by_Credit_Memo;
3526:

Line 3660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3656: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3657: RAISE FND_API.g_exc_unexpected_error;
3658: END IF;
3659: ELSE
3660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3661: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3662: FND_MSG_PUB.add;
3663: END IF;
3664: RAISE FND_API.g_exc_error;

Line 3662: FND_MSG_PUB.add;

3658: END IF;
3659: ELSE
3660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3661: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3662: FND_MSG_PUB.add;
3663: END IF;
3664: RAISE FND_API.g_exc_error;
3665: END IF;
3666:

Line 3679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3675: x_return_status := FND_API.g_ret_sts_unexp_error ;
3676:
3677: WHEN OTHERS THEN
3678: x_return_status := FND_API.g_ret_sts_unexp_error ;
3679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3680: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3681: END IF;
3682:
3683: END Pay_by_On_Account_Credit;

Line 3680: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3676:
3677: WHEN OTHERS THEN
3678: x_return_status := FND_API.g_ret_sts_unexp_error ;
3679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3680: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3681: END IF;
3682:
3683: END Pay_by_On_Account_Credit;
3684:

Line 3785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3781: END IF;
3782: END IF;
3783:
3784: ELSE
3785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3786: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3787: FND_MSG_PUB.add;
3788: END IF;
3789: END IF;

Line 3787: FND_MSG_PUB.add;

3783:
3784: ELSE
3785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3786: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
3787: FND_MSG_PUB.add;
3788: END IF;
3789: END IF;
3790:
3791:

Line 3804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3800: x_return_status := FND_API.g_ret_sts_unexp_error ;
3801:
3802: WHEN OTHERS THEN
3803: x_return_status := FND_API.g_ret_sts_unexp_error ;
3804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3806: END IF;
3807:
3808: END Pay_by_Chargeback;

Line 3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3801:
3802: WHEN OTHERS THEN
3803: x_return_status := FND_API.g_ret_sts_unexp_error ;
3804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3806: END IF;
3807:
3808: END Pay_by_Chargeback;
3809:

Line 3906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3902: x_return_status := FND_API.g_ret_sts_unexp_error ;
3903:
3904: WHEN OTHERS THEN
3905: x_return_status := FND_API.g_ret_sts_unexp_error ;
3906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3908: END IF;
3909:
3910: END Pay_by_Write_Off;

Line 3907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3903:
3904: WHEN OTHERS THEN
3905: x_return_status := FND_API.g_ret_sts_unexp_error ;
3906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3908: END IF;
3909:
3910: END Pay_by_Write_Off;
3911:

Line 4179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4175: l_online_upd_ded_status := TRUE;
4176: END IF;
4177: END IF;
4178: ELSE
4179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4180: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
4181: FND_MSG_PUB.add;
4182: END IF;
4183: RAISE FND_API.g_exc_error;

Line 4181: FND_MSG_PUB.add;

4177: END IF;
4178: ELSE
4179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4180: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
4181: FND_MSG_PUB.add;
4182: END IF;
4183: RAISE FND_API.g_exc_error;
4184: END IF;
4185:

Line 4227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4223: x_return_status := FND_API.g_ret_sts_unexp_error ;
4224:
4225: WHEN OTHERS THEN
4226: x_return_status := FND_API.g_ret_sts_unexp_error ;
4227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4229: END IF;
4230:
4231: END Pay_by_Debit_Memo;

Line 4228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4224:
4225: WHEN OTHERS THEN
4226: x_return_status := FND_API.g_ret_sts_unexp_error ;
4227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4229: END IF;
4230:
4231: END Pay_by_Debit_Memo;
4232:

Line 4280: FND_MSG_PUB.Add;

4276: EXCEPTION
4277: WHEN OTHERS THEN
4278: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4279: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4280: FND_MSG_PUB.Add;
4281: RAISE FND_API.g_exc_unexpected_error;
4282: END;
4283: ELSE
4284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 4284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4280: FND_MSG_PUB.Add;
4281: RAISE FND_API.g_exc_unexpected_error;
4282: END;
4283: ELSE
4284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4285: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
4286: FND_MSG_PUB.add;
4287: END IF;
4288: END IF;

Line 4286: FND_MSG_PUB.add;

4282: END;
4283: ELSE
4284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4285: FND_MESSAGE.set_name('OZF', 'OZF_AR_PAYMENT_NOTMATCH');
4286: FND_MSG_PUB.add;
4287: END IF;
4288: END IF;
4289:
4290: IF g_debug THEN

Line 4302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4298: x_return_status := FND_API.g_ret_sts_unexp_error ;
4299:
4300: WHEN OTHERS THEN
4301: x_return_status := FND_API.g_ret_sts_unexp_error ;
4302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4303: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4304: END IF;
4305:
4306: END Pay_by_Contra_Charge;

Line 4303: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4299:
4300: WHEN OTHERS THEN
4301: x_return_status := FND_API.g_ret_sts_unexp_error ;
4302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4303: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4304: END IF;
4305:
4306: END Pay_by_Contra_Charge;
4307:

Line 4348: FND_MSG_PUB.initialize;

4344: OZF_Utility_PVT.debug_message(l_full_name||': start');
4345: END IF;
4346:
4347: IF FND_API.to_boolean(p_init_msg_list) THEN
4348: FND_MSG_PUB.initialize;
4349: END IF;
4350:
4351: IF NOT FND_API.compatible_api_call(
4352: l_api_version,

Line 4399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4395: l_deduction_type := 'CLAIM';
4396: ELSIF l_claim_rec.claim_class = 'CHARGE' THEN
4397: l_deduction_type := 'CHARGE';
4398: ELSE
4399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4400: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DED_TYPE_ERR');
4401: FND_MSG_PUB.add;
4402: END IF;
4403: END IF;

Line 4401: FND_MSG_PUB.add;

4397: l_deduction_type := 'CHARGE';
4398: ELSE
4399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4400: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DED_TYPE_ERR');
4401: FND_MSG_PUB.add;
4402: END IF;
4403: END IF;
4404:
4405: --R12.1 Enhancement start :Close the claim contains the payment method as ACCOUNTING_ONLY

Line 4571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4567: END IF;
4568:
4569: ELSE
4570: OZF_Utility_PVT.debug_message('KP1 Test: end');
4571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4572: FND_MESSAGE.set_name('OZF', 'OZF_DED_PAYMETHOD_ERR');
4573: FND_MESSAGE.set_token('PAYMENT_METHOD', l_claim_rec.payment_method);
4574: FND_MSG_PUB.add;
4575: END IF;

Line 4574: FND_MSG_PUB.add;

4570: OZF_Utility_PVT.debug_message('KP1 Test: end');
4571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4572: FND_MESSAGE.set_name('OZF', 'OZF_DED_PAYMETHOD_ERR');
4573: FND_MESSAGE.set_token('PAYMENT_METHOD', l_claim_rec.payment_method);
4574: FND_MSG_PUB.add;
4575: END IF;
4576: RAISE FND_API.g_exc_error;
4577: END IF;
4578:

Line 4582: FND_MSG_PUB.count_and_get(

4578:
4579: END IF;
4580:
4581: ------------------------ finish ------------------------
4582: FND_MSG_PUB.count_and_get(
4583: p_encoded => FND_API.g_false,
4584: p_count => x_msg_count,
4585: p_data => x_msg_data
4586: );

Line 4596: FND_MSG_PUB.count_and_get (

4592: EXCEPTION
4593: WHEN FND_API.g_exc_error THEN
4594: ROLLBACK TO Create_AR_Payment;
4595: x_return_status := FND_API.g_ret_sts_error;
4596: FND_MSG_PUB.count_and_get (
4597: p_encoded => FND_API.g_false
4598: ,p_count => x_msg_count
4599: ,p_data => x_msg_data
4600: );

Line 4605: FND_MSG_PUB.count_and_get (

4601:
4602: WHEN FND_API.g_exc_unexpected_error THEN
4603: ROLLBACK TO Create_AR_Payment;
4604: x_return_status := FND_API.g_ret_sts_unexp_error ;
4605: FND_MSG_PUB.count_and_get (
4606: p_encoded => FND_API.g_false
4607: ,p_count => x_msg_count
4608: ,p_data => x_msg_data
4609: );

Line 4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4610:
4611: WHEN OTHERS THEN
4612: ROLLBACK TO Create_AR_Payment;
4613: x_return_status := FND_API.g_ret_sts_unexp_error ;
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4616: END IF;
4617: FND_MSG_PUB.count_and_get(
4618: p_encoded => FND_API.g_false

Line 4615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4611: WHEN OTHERS THEN
4612: ROLLBACK TO Create_AR_Payment;
4613: x_return_status := FND_API.g_ret_sts_unexp_error ;
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4616: END IF;
4617: FND_MSG_PUB.count_and_get(
4618: p_encoded => FND_API.g_false
4619: ,p_count => x_msg_count

Line 4617: FND_MSG_PUB.count_and_get(

4613: x_return_status := FND_API.g_ret_sts_unexp_error ;
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4616: END IF;
4617: FND_MSG_PUB.count_and_get(
4618: p_encoded => FND_API.g_false
4619: ,p_count => x_msg_count
4620: ,p_data => x_msg_data
4621: );

Line 4699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4695: x_return_status := FND_API.g_ret_sts_unexp_error ;
4696:
4697: WHEN OTHERS THEN
4698: x_return_status := FND_API.g_ret_sts_unexp_error ;
4699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4700: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4701: END IF;
4702:
4703: END Pay_by_RMA_Inv_CM;

Line 4700: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4696:
4697: WHEN OTHERS THEN
4698: x_return_status := FND_API.g_ret_sts_unexp_error ;
4699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4700: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4701: END IF;
4702:
4703: END Pay_by_RMA_Inv_CM;
4704: