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_CLAIM_SETTLEMENT_PVT dependencies on FND_MSG_PUB

Line 12: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

8: G_OVERPAYMENT_CLASS_NAME CONSTANT VARCHAR2(30) := 'OVERPAYMENT';
9: G_CHARGE_CLASS_NAME CONSTANT VARCHAR2(30) := 'CHARGE';
10: G_APPROVAL_TYPE CONSTANT VARCHAR2(30) := 'CLAIM';
11:
12: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
13: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
14:
15: /*=======================================================================*
16: | PROCEDURE

Line 13: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

9: G_CHARGE_CLASS_NAME CONSTANT VARCHAR2(30) := 'CHARGE';
10: G_APPROVAL_TYPE CONSTANT VARCHAR2(30) := 'CLAIM';
11:
12: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
13: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
14:
15: /*=======================================================================*
16: | PROCEDURE
17: | Process_Settlement_WF

Line 57: FND_MSG_PUB.Add;

53: EXCEPTION
54: WHEN OTHERS THEN
55: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
56: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
57: FND_MSG_PUB.Add;
58: RAISE FND_API.g_exc_unexpected_error;
59: END;
60:
61: IF OZF_DEBUG_HIGH_ON THEN

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

66: x_return_status := FND_API.g_ret_sts_unexp_error ;
67:
68: WHEN OTHERS THEN
69: x_return_status := FND_API.g_ret_sts_unexp_error ;
70: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
71: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
72: END IF;
73:
74: END Process_Settlement_WF;

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

67:
68: WHEN OTHERS THEN
69: x_return_status := FND_API.g_ret_sts_unexp_error ;
70: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
71: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
72: END IF;
73:
74: END Process_Settlement_WF;
75:

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

108: FETCH csr_invoice_balance INTO l_invoice_balance_due,l_trx_number;
109: CLOSE csr_invoice_balance;
110:
111: IF p_claim_amount > l_invoice_balance_due THEN
112: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
113: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INVOICE_BAL_ERR');
114: FND_MESSAGE.set_token('TRX_NUMBER', l_trx_number);
115: FND_MSG_PUB.add;
116: END IF;

Line 115: FND_MSG_PUB.add;

111: IF p_claim_amount > l_invoice_balance_due THEN
112: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
113: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INVOICE_BAL_ERR');
114: FND_MESSAGE.set_token('TRX_NUMBER', l_trx_number);
115: FND_MSG_PUB.add;
116: END IF;
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;
119:

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

120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: x_return_status := FND_API.g_ret_sts_error;
123: WHEN OTHERS THEN
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
125: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CHK_TRANS_BAL_UERR');
126: FND_MSG_PUB.add;
127: END IF;
128: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 126: FND_MSG_PUB.add;

122: x_return_status := FND_API.g_ret_sts_error;
123: WHEN OTHERS THEN
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
125: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CHK_TRANS_BAL_UERR');
126: FND_MSG_PUB.add;
127: END IF;
128: x_return_status := FND_API.g_ret_sts_unexp_error;
129: END Check_Transaction_Balance;
130:

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

197: x_return_status := FND_API.G_RET_STS_ERROR;
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: WHEN OTHERS THEN
201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
203: END IF;
204: x_return_status := FND_API.g_ret_sts_unexp_error;
205:

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

198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: WHEN OTHERS THEN
201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
203: END IF;
204: x_return_status := FND_API.g_ret_sts_unexp_error;
205:
206: END Reopen_Claim_for_Completion;

Line 344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: WHEN OTHERS THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347:
348: END Check_Create_Trd_Prfl;

Line 345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: WHEN OTHERS THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347:
348: END Check_Create_Trd_Prfl;
349:

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

438: x_return_status := FND_API.G_RET_STS_ERROR;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: WHEN OTHERS THEN
442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
444: END IF;
445: x_return_status := FND_API.g_ret_sts_unexp_error;
446:

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

439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: WHEN OTHERS THEN
442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
444: END IF;
445: x_return_status := FND_API.g_ret_sts_unexp_error;
446:
447: END Remove_Utilization;

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

498: x_return_status := FND_API.G_RET_STS_ERROR;
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: WHEN OTHERS THEN
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
503: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
504: END IF;
505: x_return_status := FND_API.g_ret_sts_unexp_error;
506:

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

499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: WHEN OTHERS THEN
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
503: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
504: END IF;
505: x_return_status := FND_API.g_ret_sts_unexp_error;
506:
507: END Duplicate_Claim_for_Completion;

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

558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: WHEN OTHERS THEN
562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
563: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
564: END IF;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566:

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

559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: WHEN OTHERS THEN
562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
563: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
564: END IF;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566:
567: END Cancel_Claim_for_Completion;

Line 626: FND_MSG_PUB.Add;

622: EXCEPTION
623: WHEN OTHERS THEN
624: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
625: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.g_exc_unexpected_error;
628: END;
629: END IF;
630: */

Line 643: FND_MSG_PUB.Add;

639: WHEN OTHERS THEN
640: IF OZF_DEBUG_LOW_ON THEN
641: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
642: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
643: FND_MSG_PUB.Add;
644: END IF;
645: x_return_status := FND_API.g_ret_sts_unexp_error;
646:
647: END Cancel_Claim_for_Settlement;

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

715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: WHEN OTHERS THEN
718: x_return_status := FND_API.g_ret_sts_unexp_error;
719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
720: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
721: END IF;
722:
723: END Reject_Claim_for_Completion;

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

716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: WHEN OTHERS THEN
718: x_return_status := FND_API.g_ret_sts_unexp_error;
719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
720: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
721: END IF;
722:
723: END Reject_Claim_for_Completion;
724:

Line 782: FND_MSG_PUB.Add;

778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
781: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
782: FND_MSG_PUB.Add;
783: RAISE FND_API.g_exc_unexpected_error;
784: END;
785: END IF;
786: */

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

792: x_return_status := FND_API.G_RET_STS_ERROR;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: WHEN OTHERS THEN
796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: x_return_status := FND_API.g_ret_sts_unexp_error;
800:

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

793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: WHEN OTHERS THEN
796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: x_return_status := FND_API.g_ret_sts_unexp_error;
800:
801: END Reject_Claim_for_Settlement;

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

863: x_return_status := FND_API.G_RET_STS_ERROR;
864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: WHEN OTHERS THEN
867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
868: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
869: END IF;
870: x_return_status := FND_API.g_ret_sts_unexp_error;
871:

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

864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: WHEN OTHERS THEN
867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
868: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
869: END IF;
870: x_return_status := FND_API.g_ret_sts_unexp_error;
871:
872: END Complete_Claim_for_Completion;

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

923: x_return_status := FND_API.G_RET_STS_ERROR;
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: WHEN OTHERS THEN
927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
928: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
929: END IF;
930: x_return_status := FND_API.g_ret_sts_unexp_error;
931:

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

924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: WHEN OTHERS THEN
927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
928: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
929: END IF;
930: x_return_status := FND_API.g_ret_sts_unexp_error;
931:
932: END Complete_Claim_for_Settlement;

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

997: CLOSE csr_claim_perf_appr_req;
998:
999: IF p_claim_rec.approved_flag = 'N' AND
1000: l_perf_appr_req = 'N' THEN
1001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1002: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_PERF_APPR_REQ');
1003: FND_MSG_PUB.add;
1004: END IF;
1005: RAISE FND_API.g_exc_error;

Line 1003: FND_MSG_PUB.add;

999: IF p_claim_rec.approved_flag = 'N' AND
1000: l_perf_appr_req = 'N' THEN
1001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1002: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_PERF_APPR_REQ');
1003: FND_MSG_PUB.add;
1004: END IF;
1005: RAISE FND_API.g_exc_error;
1006: END IF;
1007:

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

1065: /*
1066: -- ABS(l_claim_amount_remaining) should be >= 0 now
1067:
1068: IF ABS(l_claim_amount_remaining) THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AMT_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: RAISE FND_API.g_exc_error;

Line 1071: FND_MSG_PUB.add;

1067:
1068: IF ABS(l_claim_amount_remaining) THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AMT_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: RAISE FND_API.g_exc_error;
1074: END IF;
1075: */

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

1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: WHEN OTHERS THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1091: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1092: END IF;
1093: x_return_status := FND_API.g_ret_sts_unexp_error;
1094:

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

1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: WHEN OTHERS THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1091: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1092: END IF;
1093: x_return_status := FND_API.g_ret_sts_unexp_error;
1094:
1095: END Approve_Claim_for_Completion;

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

1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: WHEN OTHERS THEN
1213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1214: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1215: END IF;
1216: x_return_status := FND_API.g_ret_sts_unexp_error;
1217:

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

1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: WHEN OTHERS THEN
1213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1214: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1215: END IF;
1216: x_return_status := FND_API.g_ret_sts_unexp_error;
1217:
1218: END Approve_Claim_for_Settlement;

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

1382: l_claim_amount_remaining := l_claim_amount_remaining * -1;
1383: END IF;
1384:
1385: IF (l_claim_amount_remaining < 0) THEN
1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1387: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AMT_ERR');
1388: FND_MSG_PUB.add;
1389: END IF;
1390: RAISE FND_API.g_exc_error;

Line 1388: FND_MSG_PUB.add;

1384:
1385: IF (l_claim_amount_remaining < 0) THEN
1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1387: FND_MESSAGE.set_name('OZF', 'OZF_SETL_AMT_ERR');
1388: FND_MSG_PUB.add;
1389: END IF;
1390: RAISE FND_API.g_exc_error;
1391: END IF;
1392: */

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

1517: | 5. Previouse Open Credit Memo/Debit Memo: balance checking
1518: *---------------------------------------------------------*/
1519: IF p_claim_rec.payment_method IN ('PREV_CREDIT_MEMO', 'PREV_DEBIT_MEMO') THEN
1520: IF p_claim_rec.payment_reference_id IS NULL THEN
1521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1522: FND_MESSAGE.set_name('OZF', 'OZF_PAY_REFERENCE_REQD');
1523: FND_MSG_PUB.add;
1524: END IF;
1525: RAISE FND_API.G_EXC_ERROR;

Line 1523: FND_MSG_PUB.add;

1519: IF p_claim_rec.payment_method IN ('PREV_CREDIT_MEMO', 'PREV_DEBIT_MEMO') THEN
1520: IF p_claim_rec.payment_reference_id IS NULL THEN
1521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1522: FND_MESSAGE.set_name('OZF', 'OZF_PAY_REFERENCE_REQD');
1523: FND_MSG_PUB.add;
1524: END IF;
1525: RAISE FND_API.G_EXC_ERROR;
1526: ELSE
1527: OPEN csr_trx_balance(p_claim_rec.payment_reference_id);

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

1529: CLOSE csr_trx_balance;
1530:
1531: IF x_claim_rec.currency_code = l_trx_currency AND
1532: ABS(p_claim_rec.amount_remaining) > ABS(l_trx_balance) THEN
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1534: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CM_DM_OP_BAL_ERR');
1535: FND_MSG_PUB.add;
1536: END IF;
1537: RAISE FND_API.G_EXC_ERROR;

Line 1535: FND_MSG_PUB.add;

1531: IF x_claim_rec.currency_code = l_trx_currency AND
1532: ABS(p_claim_rec.amount_remaining) > ABS(l_trx_balance) THEN
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1534: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CM_DM_OP_BAL_ERR');
1535: FND_MSG_PUB.add;
1536: END IF;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;
1539: END IF;

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

1567: *---------------------------------------------------------*/
1568: x_claim_rec.payment_status := 'PENDING';
1569:
1570: ELSE
1571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1572: FND_MESSAGE.set_name('OZF', 'OZF_SETL_ADJ_OVER_UTIZ_ERR');
1573: FND_MSG_PUB.add;
1574: END IF;
1575: IF OZF_DEBUG_LOW_ON THEN

Line 1573: FND_MSG_PUB.add;

1569:
1570: ELSE
1571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1572: FND_MESSAGE.set_name('OZF', 'OZF_SETL_ADJ_OVER_UTIZ_ERR');
1573: FND_MSG_PUB.add;
1574: END IF;
1575: IF OZF_DEBUG_LOW_ON THEN
1576: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1577: FND_MESSAGE.Set_Token('TEXT', 'Status return from OZF_CLAIM_LINE_PVT.Adjust_Fund_Utilization = '||l_adj_util_result_status);

Line 1578: FND_MSG_PUB.Add;

1574: END IF;
1575: IF OZF_DEBUG_LOW_ON THEN
1576: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1577: FND_MESSAGE.Set_Token('TEXT', 'Status return from OZF_CLAIM_LINE_PVT.Adjust_Fund_Utilization = '||l_adj_util_result_status);
1578: FND_MSG_PUB.Add;
1579: END IF;
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: END IF; -- end of if l_adj_util_result_status
1582: END IF; -- enf of if referral claim approval

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

1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598:
1599: WHEN OTHERS THEN
1600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1601: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1602: END IF;
1603: x_return_status := FND_API.g_ret_sts_unexp_error;
1604:

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

1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598:
1599: WHEN OTHERS THEN
1600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1601: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1602: END IF;
1603: x_return_status := FND_API.g_ret_sts_unexp_error;
1604:
1605: END Create_Payment_for_Completion;

Line 1759: FND_MSG_PUB.Add;

1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1758: FND_MESSAGE.Set_Token('TEXT','Promo Err: ' || sqlerrm);
1759: FND_MSG_PUB.Add;
1760: RAISE FND_API.g_exc_unexpected_error;
1761: END;
1762: ELSE -- non promotional claims
1763: /*---------------------------------------------------------*

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

2008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: WHEN OTHERS THEN
2012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2014: END IF;
2015: x_return_status := FND_API.g_ret_sts_unexp_error;
2016:

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

2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: WHEN OTHERS THEN
2012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2014: END IF;
2015: x_return_status := FND_API.g_ret_sts_unexp_error;
2016:
2017: END Create_Payment_for_Settlement;

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

2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2106: WHEN OTHERS THEN
2107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2108: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2109: END IF;
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111:

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

2104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2106: WHEN OTHERS THEN
2107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2108: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2109: END IF;
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111:
2112: END Update_Claim_Remaining_Amount;

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

2138: WHERE lookup_type = 'OZF_CLAIM_STATUS'
2139: AND lookup_code = c_status_code;
2140:
2141: BEGIN
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2143: OPEN csr_status_meaning(p_prev_status);
2144: FETCH csr_status_meaning INTO l_prev_status_meaning;
2145: IF csr_status_meaning%NOTFOUND THEN
2146: CLOSE csr_status_meaning;

Line 2164: FND_MSG_PUB.add;

2160:
2161: FND_MESSAGE.set_name('OZF', 'OZF_SETL_STATUS_RULE_ERR');
2162: FND_MESSAGE.set_token('PREV_STATUS', l_prev_status_meaning);
2163: FND_MESSAGE.set_token('CURR_STATUS', l_curr_status_meaning);
2164: FND_MSG_PUB.add;
2165: END IF;
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: IF csr_status_meaning%ISOPEN THEN

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

2247:
2248: x_approval_require := l_approval_require;
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2252: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CHK_APPR_UNEXPERR');
2253: FND_MSG_PUB.add;
2254: END IF;
2255: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2253: FND_MSG_PUB.add;

2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2252: FND_MESSAGE.set_name('OZF', 'OZF_SETL_CHK_APPR_UNEXPERR');
2253: FND_MSG_PUB.add;
2254: END IF;
2255: x_return_status := FND_API.g_ret_sts_unexp_error;
2256: END Claim_Approval_Required;
2257:

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

2472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474:
2475: WHEN OTHERS THEN
2476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2478: END IF;
2479: x_return_status := FND_API.g_ret_sts_unexp_error;
2480: END Recalculate_FXGL;

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

2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474:
2475: WHEN OTHERS THEN
2476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2478: END IF;
2479: x_return_status := FND_API.g_ret_sts_unexp_error;
2480: END Recalculate_FXGL;
2481:

Line 2543: FND_MSG_PUB.initialize;

2539: OZF_Utility_PVT.debug_message(l_full_name||' : start');
2540: END IF;
2541:
2542: IF FND_API.to_boolean(p_init_msg_list) THEN
2543: FND_MSG_PUB.initialize;
2544: END IF;
2545:
2546: IF NOT FND_API.compatible_api_call(
2547: l_api_version,

Line 3040: FND_MSG_PUB.count_and_get(

3036: COMMIT;
3037: END IF;
3038: */
3039:
3040: FND_MSG_PUB.count_and_get(
3041: p_encoded => FND_API.g_false,
3042: p_count => x_msg_count,
3043: p_data => x_msg_data
3044: );

Line 3054: FND_MSG_PUB.count_and_get (

3050: EXCEPTION
3051: WHEN FND_API.g_exc_error THEN
3052: ROLLBACK TO Complete_Settlement;
3053: x_return_status := FND_API.g_ret_sts_error;
3054: FND_MSG_PUB.count_and_get (
3055: p_encoded => FND_API.g_false,
3056: p_count => x_msg_count,
3057: p_data => x_msg_data
3058: );

Line 3062: FND_MSG_PUB.count_and_get (

3058: );
3059: WHEN FND_API.g_exc_unexpected_error THEN
3060: ROLLBACK TO Complete_Settlement;
3061: x_return_status := FND_API.g_ret_sts_unexp_error ;
3062: FND_MSG_PUB.count_and_get (
3063: p_encoded => FND_API.g_false,
3064: p_count => x_msg_count,
3065: p_data => x_msg_data
3066: );

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

3066: );
3067: WHEN OTHERS THEN
3068: ROLLBACK TO Complete_Settlement;
3069: x_return_status := FND_API.g_ret_sts_unexp_error ;
3070: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3071: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3072: END IF;
3073: FND_MSG_PUB.count_and_get (
3074: p_encoded => FND_API.g_false,

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

3067: WHEN OTHERS THEN
3068: ROLLBACK TO Complete_Settlement;
3069: x_return_status := FND_API.g_ret_sts_unexp_error ;
3070: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3071: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3072: END IF;
3073: FND_MSG_PUB.count_and_get (
3074: p_encoded => FND_API.g_false,
3075: p_count => x_msg_count,

Line 3073: FND_MSG_PUB.count_and_get (

3069: x_return_status := FND_API.g_ret_sts_unexp_error ;
3070: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3071: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3072: END IF;
3073: FND_MSG_PUB.count_and_get (
3074: p_encoded => FND_API.g_false,
3075: p_count => x_msg_count,
3076: p_data => x_msg_data
3077: );

Line 3148: FND_MSG_PUB.initialize;

3144: OZF_Utility_PVT.debug_message(l_full_name||' : start');
3145: END IF;
3146:
3147: IF FND_API.to_boolean(p_init_msg_list) THEN
3148: FND_MSG_PUB.initialize;
3149: END IF;
3150:
3151: IF NOT FND_API.compatible_api_call(
3152: l_api_version,

Line 3395: FND_MSG_PUB.count_and_get(

3391: COMMIT;
3392: END IF;
3393: */
3394:
3395: FND_MSG_PUB.count_and_get(
3396: p_encoded => FND_API.g_false,
3397: p_count => x_msg_count,
3398: p_data => x_msg_data
3399: );

Line 3409: FND_MSG_PUB.count_and_get (

3405: EXCEPTION
3406: WHEN FND_API.g_exc_error THEN
3407: ROLLBACK TO Settle_Claim;
3408: x_return_status := FND_API.g_ret_sts_error;
3409: FND_MSG_PUB.count_and_get (
3410: p_encoded => FND_API.g_false,
3411: p_count => x_msg_count,
3412: p_data => x_msg_data
3413: );

Line 3417: FND_MSG_PUB.count_and_get (

3413: );
3414: WHEN FND_API.g_exc_unexpected_error THEN
3415: ROLLBACK TO Settle_Claim;
3416: x_return_status := FND_API.g_ret_sts_unexp_error ;
3417: FND_MSG_PUB.count_and_get (
3418: p_encoded => FND_API.g_false,
3419: p_count => x_msg_count,
3420: p_data => x_msg_data
3421: );

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

3421: );
3422: WHEN OTHERS THEN
3423: ROLLBACK TO Settle_Claim;
3424: x_return_status := FND_API.g_ret_sts_unexp_error ;
3425: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3426: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3427: END IF;
3428: FND_MSG_PUB.count_and_get (
3429: p_encoded => FND_API.g_false,

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

3422: WHEN OTHERS THEN
3423: ROLLBACK TO Settle_Claim;
3424: x_return_status := FND_API.g_ret_sts_unexp_error ;
3425: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3426: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3427: END IF;
3428: FND_MSG_PUB.count_and_get (
3429: p_encoded => FND_API.g_false,
3430: p_count => x_msg_count,

Line 3428: FND_MSG_PUB.count_and_get (

3424: x_return_status := FND_API.g_ret_sts_unexp_error ;
3425: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3426: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3427: END IF;
3428: FND_MSG_PUB.count_and_get (
3429: p_encoded => FND_API.g_false,
3430: p_count => x_msg_count,
3431: p_data => x_msg_data
3432: );

Line 3489: FND_MSG_PUB.initialize;

3485: OZF_Utility_PVT.debug_message(l_full_name||' : event = '||p_event_name);
3486: END IF;
3487:
3488: IF FND_API.to_boolean(p_init_msg_list) THEN
3489: FND_MSG_PUB.initialize;
3490: END IF;
3491:
3492: IF NOT FND_API.compatible_api_call(
3493: l_api_version,

Line 3541: FND_MSG_PUB.count_and_get(

3537: IF FND_API.to_boolean(p_commit) THEN
3538: COMMIT;
3539: END IF;
3540:
3541: FND_MSG_PUB.count_and_get(
3542: p_encoded => FND_API.g_false,
3543: p_count => x_msg_count,
3544: p_data => x_msg_data
3545: );

Line 3555: FND_MSG_PUB.count_and_get (

3551: EXCEPTION
3552: WHEN FND_API.g_exc_error THEN
3553: ROLLBACK TO Raise_Business_Event;
3554: x_return_status := FND_API.g_ret_sts_error;
3555: FND_MSG_PUB.count_and_get (
3556: p_encoded => FND_API.g_false,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data
3559: );

Line 3563: FND_MSG_PUB.count_and_get (

3559: );
3560: WHEN FND_API.g_exc_unexpected_error THEN
3561: ROLLBACK TO Raise_Business_Event;
3562: x_return_status := FND_API.g_ret_sts_unexp_error ;
3563: FND_MSG_PUB.count_and_get (
3564: p_encoded => FND_API.g_false,
3565: p_count => x_msg_count,
3566: p_data => x_msg_data
3567: );

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

3567: );
3568: WHEN OTHERS THEN
3569: ROLLBACK TO Raise_Business_Event;
3570: x_return_status := FND_API.g_ret_sts_unexp_error ;
3571: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3572: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3573: END IF;
3574: FND_MSG_PUB.count_and_get (
3575: p_encoded => FND_API.g_false,

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

3568: WHEN OTHERS THEN
3569: ROLLBACK TO Raise_Business_Event;
3570: x_return_status := FND_API.g_ret_sts_unexp_error ;
3571: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3572: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3573: END IF;
3574: FND_MSG_PUB.count_and_get (
3575: p_encoded => FND_API.g_false,
3576: p_count => x_msg_count,

Line 3574: FND_MSG_PUB.count_and_get (

3570: x_return_status := FND_API.g_ret_sts_unexp_error ;
3571: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3572: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3573: END IF;
3574: FND_MSG_PUB.count_and_get (
3575: p_encoded => FND_API.g_false,
3576: p_count => x_msg_count,
3577: p_data => x_msg_data
3578: );