DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on FND_MESSAGE

Line 135: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CURRENCY_MISS');

131: OPEN csr_cust_name(l_cust_account_id);
132: FETCH csr_cust_name INTO l_cust_name_num;
133: CLOSE csr_cust_name;
134:
135: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CURRENCY_MISS');
136: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
137: FND_MSG_PUB.ADD;
138: END IF;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

132: FETCH csr_cust_name INTO l_cust_name_num;
133: CLOSE csr_cust_name;
134:
135: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CURRENCY_MISS');
136: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
137: FND_MSG_PUB.ADD;
138: END IF;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: END IF;

Line 148: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PYMTHD_MISS');

144: OPEN csr_cust_name(l_cust_account_id);
145: FETCH csr_cust_name INTO l_cust_name_num;
146: CLOSE csr_cust_name;
147:
148: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PYMTHD_MISS');
149: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
150: FND_MSG_PUB.ADD;
151: END IF;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 149: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

145: FETCH csr_cust_name INTO l_cust_name_num;
146: CLOSE csr_cust_name;
147:
148: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PYMTHD_MISS');
149: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
150: FND_MSG_PUB.ADD;
151: END IF;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: END IF;

Line 163: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_VENDOR_MISS');

159: OPEN csr_cust_name(l_cust_account_id);
160: FETCH csr_cust_name INTO l_cust_name_num;
161: CLOSE csr_cust_name;
162:
163: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_VENDOR_MISS');
164: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
165: FND_MSG_PUB.ADD;
166: END IF;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 164: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

160: FETCH csr_cust_name INTO l_cust_name_num;
161: CLOSE csr_cust_name;
162:
163: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_VENDOR_MISS');
164: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
165: FND_MSG_PUB.ADD;
166: END IF;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: --Added for Bug 16301629

Line 178: FND_MESSAGE.Set_Name('OZF', 'OZF_TRADE_VENDOR_INACTIVE');

174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: OPEN csr_cust_name(l_cust_account_id);
176: FETCH csr_cust_name INTO l_cust_name_num;
177: CLOSE csr_cust_name;
178: FND_MESSAGE.Set_Name('OZF', 'OZF_TRADE_VENDOR_INACTIVE');
179: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
180: FND_MSG_PUB.ADD;
181: END IF;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 179: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

175: OPEN csr_cust_name(l_cust_account_id);
176: FETCH csr_cust_name INTO l_cust_name_num;
177: CLOSE csr_cust_name;
178: FND_MESSAGE.Set_Name('OZF', 'OZF_TRADE_VENDOR_INACTIVE');
179: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
180: FND_MSG_PUB.ADD;
181: END IF;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: END IF;

Line 194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_SITEID_MISS');

190: OPEN csr_cust_name(l_cust_account_id);
191: FETCH csr_cust_name INTO l_cust_name_num;
192: CLOSE csr_cust_name;
193:
194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_SITEID_MISS');
195: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
196: FND_MSG_PUB.ADD;
197: END IF;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 195: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

191: FETCH csr_cust_name INTO l_cust_name_num;
192: CLOSE csr_cust_name;
193:
194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_SITEID_MISS');
195: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
196: FND_MSG_PUB.ADD;
197: END IF;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: END IF;*/

Line 209: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_ORG_ID_MISS');

205: OPEN csr_cust_name(l_cust_account_id);
206: FETCH csr_cust_name INTO l_cust_name_num;
207: CLOSE csr_cust_name;
208:
209: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_ORG_ID_MISS');
210: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
211: FND_MSG_PUB.add;
212: END IF;FND_MSG_PUB.ADD;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 210: FND_MESSAGE.Set_Token('ID',l_cust_name_num);

206: FETCH csr_cust_name INTO l_cust_name_num;
207: CLOSE csr_cust_name;
208:
209: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_ORG_ID_MISS');
210: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
211: FND_MSG_PUB.add;
212: END IF;FND_MSG_PUB.ADD;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: END IF;

Line 221: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');

217: EXCEPTION
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');
222: FND_MSG_PUB.add;
223: END IF;
224: END validate_customer_info;
225:

Line 270: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_AUPD_MISS');

266: ELSIF p_type = G_ANNUAL THEN
267: l_return_date := add_months(p_last_date, p_period*12);
268: ELSE
269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
270: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_AUPD_MISS');
271: FND_MSG_PUB.add;
272: END IF;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;

Line 404: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PERIOD_MISS');

400: OPEN csr_cust_name(p_customer_info.cust_account_id);
401: FETCH csr_cust_name INTO l_cust_name_num;
402: CLOSE csr_cust_name;
403:
404: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PERIOD_MISS');
405: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
406: FND_MSG_PUB.ADD;
407: END IF;
408: RAISE FND_API.g_exc_unexpected_error;

Line 405: FND_MESSAGE.Set_Token('ID', l_cust_name_num);

401: FETCH csr_cust_name INTO l_cust_name_num;
402: CLOSE csr_cust_name;
403:
404: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PERIOD_MISS');
405: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
406: FND_MSG_PUB.ADD;
407: END IF;
408: RAISE FND_API.g_exc_unexpected_error;
409: --goto end_loop;

Line 434: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PAY_DATE_MISS');

430: OPEN csr_cust_name(p_customer_info.cust_account_id);
431: FETCH csr_cust_name INTO l_cust_name_num;
432: CLOSE csr_cust_name;
433:
434: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PAY_DATE_MISS');
435: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
436: FND_MSG_PUB.ADD;
437: END IF;
438: RAISE FND_API.g_exc_unexpected_error;

Line 435: FND_MESSAGE.Set_Token('ID', l_cust_name_num);

431: FETCH csr_cust_name INTO l_cust_name_num;
432: CLOSE csr_cust_name;
433:
434: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PAY_DATE_MISS');
435: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
436: FND_MSG_PUB.ADD;
437: END IF;
438: RAISE FND_API.g_exc_unexpected_error;
439: END IF;

Line 564: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CUST_INELIG');

560: OPEN csr_cust_name(p_customer_info.cust_account_id);
561: FETCH csr_cust_name INTO l_cust_name_num;
562: CLOSE csr_cust_name;
563:
564: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CUST_INELIG');
565: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
566: FND_MSG_PUB.ADD;
567: END IF;
568: RAISE FND_API.g_exc_unexpected_error;

Line 565: FND_MESSAGE.Set_Token('ID', l_cust_name_num);

561: FETCH csr_cust_name INTO l_cust_name_num;
562: CLOSE csr_cust_name;
563:
564: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CUST_INELIG');
565: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
566: FND_MSG_PUB.ADD;
567: END IF;
568: RAISE FND_API.g_exc_unexpected_error;
569: END IF;

Line 576: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_AMT_SMALL');

572: OPEN csr_cust_name(p_customer_info.cust_account_id);
573: FETCH csr_cust_name INTO l_cust_name_num;
574: CLOSE csr_cust_name;
575:
576: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_AMT_SMALL');
577: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
578: FND_MSG_PUB.ADD;
579: END IF;
580: RAISE FND_API.g_exc_unexpected_error;

Line 577: FND_MESSAGE.Set_Token('ID', l_cust_name_num);

573: FETCH csr_cust_name INTO l_cust_name_num;
574: CLOSE csr_cust_name;
575:
576: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_AMT_SMALL');
577: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
578: FND_MSG_PUB.ADD;
579: END IF;
580: RAISE FND_API.g_exc_unexpected_error;
581: END IF;

Line 668: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

664: SAVEPOINT BDOffer;
665:
666: -- Debug Message
667: IF OZF_DEBUG_LOW_ON THEN
668: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
669: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
670: FND_MSG_PUB.Add;
671: END IF;
672:

Line 669: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

665:
666: -- Debug Message
667: IF OZF_DEBUG_LOW_ON THEN
668: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
669: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
670: FND_MSG_PUB.Add;
671: END IF;
672:
673: -- get autopay_flag, reason_code_id

Line 685: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');

681:
682: -- check reason_code and claim_type from sys_parameters.
683: IF l_auto_reason_code_id is NULL THEN
684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
685: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
686: FND_MSG_PUB.add;
687: END IF;
688: RAISE FND_API.g_exc_unexpected_error;
689: END IF;

Line 693: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');

689: END IF;
690:
691: IF l_auto_claim_type_id is NULL THEN
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
694: FND_MSG_PUB.add;
695: END IF;
696: RAISE FND_API.g_exc_unexpected_error;
697: END IF;

Line 749: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

745: END LOOP;
746:
747: -- Debug Message
748: IF OZF_DEBUG_LOW_ON THEN
749: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
750: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
751: FND_MSG_PUB.Add;
752: END IF;
753:

Line 750: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

746:
747: -- Debug Message
748: IF OZF_DEBUG_LOW_ON THEN
749: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
750: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
751: FND_MSG_PUB.Add;
752: END IF;
753:
754: EXCEPTION

Line 979: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
976:
977: -- Debug Message
978: IF OZF_DEBUG_LOW_ON THEN
979: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
980: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
981: FND_MSG_PUB.Add;
982: END IF;
983:

Line 980: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

976:
977: -- Debug Message
978: IF OZF_DEBUG_LOW_ON THEN
979: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
980: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
981: FND_MSG_PUB.Add;
982: END IF;
983:
984: --Multiorg Changes

Line 1124: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');

1120:
1121: -- check reason_code and claim_type from sys_parameters.
1122: IF l_auto_reason_code_id is NULL THEN
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1124: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
1125: FND_MSG_PUB.add;
1126: END IF;
1127: RAISE FND_API.g_exc_unexpected_error;
1128: END IF;

Line 1132: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');

1128: END IF;
1129:
1130: IF l_auto_claim_type_id is NULL THEN
1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1132: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
1133: FND_MSG_PUB.add;
1134: END IF;
1135: RAISE FND_API.g_exc_unexpected_error;
1136: END IF;

Line 1486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1482: WHEN OTHERS THEN
1483: ROLLBACK TO AUTOPAY_CUST;
1484: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1485: IF OZF_DEBUG_LOW_ON THEN
1486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1487: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1488: FND_MSG_PUB.Add;
1489: END IF;
1490: OZF_UTILITY_PVT.write_conc_log;

Line 1487: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1483: ROLLBACK TO AUTOPAY_CUST;
1484: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1485: IF OZF_DEBUG_LOW_ON THEN
1486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1487: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1488: FND_MSG_PUB.Add;
1489: END IF;
1490: OZF_UTILITY_PVT.write_conc_log;
1491: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');

Line 1514: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1510:
1511:
1512: -- Debug Message
1513: IF OZF_DEBUG_LOW_ON THEN
1514: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1515: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1516: FND_MSG_PUB.Add;
1517: END IF;
1518:

Line 1515: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

1511:
1512: -- Debug Message
1513: IF OZF_DEBUG_LOW_ON THEN
1514: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1515: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1516: FND_MSG_PUB.Add;
1517: END IF;
1518:
1519: -- Write all messages to a log