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 FND_API

Line 30: x_return_status := FND_API.g_ret_sts_success;

26: ,p_claim_id IN NUMBER
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: BEGIN
30: x_return_status := FND_API.g_ret_sts_success;
31:
32:
33: UPDATE ozf_claims_all
34: SET payment_status = 'PAID'

Line 53: x_return_status := FND_API.g_ret_sts_unexp_error;

49: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
50: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
51: FND_MSG_PUB.Add;
52: END IF;
53: x_return_status := FND_API.g_ret_sts_unexp_error;
54: END;
55:
56:
57:

Line 136: x_return_status := FND_API.g_ret_sts_success;

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 -------------------------
139: OZF_AR_Payment_PVT.Query_Claim(
140: p_claim_id => p_payment_claim_id

Line 144: IF l_return_status = FND_API.g_ret_sts_error THEN

140: p_claim_id => p_payment_claim_id
141: ,x_claim_rec => l_payment_claim_rec
142: ,x_return_status => l_return_status
143: );
144: IF l_return_status = FND_API.g_ret_sts_error THEN
145: RAISE FND_API.g_exc_error;
146: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
147: RAISE FND_API.g_exc_unexpected_error;
148: END IF;

Line 145: RAISE FND_API.g_exc_error;

141: ,x_claim_rec => l_payment_claim_rec
142: ,x_return_status => l_return_status
143: );
144: IF l_return_status = FND_API.g_ret_sts_error THEN
145: RAISE FND_API.g_exc_error;
146: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
147: RAISE FND_API.g_exc_unexpected_error;
148: END IF;
149:

Line 146: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

142: ,x_return_status => l_return_status
143: );
144: IF l_return_status = FND_API.g_ret_sts_error THEN
145: RAISE FND_API.g_exc_error;
146: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
147: RAISE FND_API.g_exc_unexpected_error;
148: END IF;
149:
150: IF OZF_DEBUG_HIGH_ON THEN

Line 147: RAISE FND_API.g_exc_unexpected_error;

143: );
144: IF l_return_status = FND_API.g_ret_sts_error THEN
145: RAISE FND_API.g_exc_error;
146: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
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);

Line 180: IF l_return_status = FND_API.g_ret_sts_error THEN

176: ,x_return_status => l_return_status
177: ,x_msg_data => x_msg_data
178: ,x_msg_count => x_msg_count
179: );
180: IF l_return_status = FND_API.g_ret_sts_error THEN
181: RAISE FND_API.g_exc_error;
182: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;

Line 181: RAISE FND_API.g_exc_error;

177: ,x_msg_data => x_msg_data
178: ,x_msg_count => x_msg_count
179: );
180: IF l_return_status = FND_API.g_ret_sts_error THEN
181: RAISE FND_API.g_exc_error;
182: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
185:

Line 182: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

178: ,x_msg_count => x_msg_count
179: );
180: IF l_return_status = FND_API.g_ret_sts_error THEN
181: RAISE FND_API.g_exc_error;
182: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
185:
186:

Line 183: RAISE FND_API.g_exc_unexpected_error;

179: );
180: IF l_return_status = FND_API.g_ret_sts_error THEN
181: RAISE FND_API.g_exc_error;
182: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
185:
186:
187: -- ------------------------------

Line 203: p_init_msg_list => FND_API.G_FALSE,

199: IF l_payment_claim_rec.receipt_id <> p_claim_rec.receipt_id THEN
200: AR_RECEIPT_API_COVER.Apply_Open_Receipt(
201: -- Standard API parameters.
202: p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: x_return_status => l_return_status,
207: x_msg_count => x_msg_count,

Line 204: p_commit => FND_API.G_FALSE,

200: AR_RECEIPT_API_COVER.Apply_Open_Receipt(
201: -- Standard API parameters.
202: p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: x_return_status => l_return_status,
207: x_msg_count => x_msg_count,
208: x_msg_data => x_msg_data,

Line 205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

201: -- Standard API parameters.
202: p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: x_return_status => l_return_status,
207: x_msg_count => x_msg_count,
208: x_msg_data => x_msg_data,
209: -- Receipt application parameters.

Line 231: IF l_return_status = FND_API.g_ret_sts_error THEN

227: x_application_ref_num => l_application_ref_num,
228: x_receivable_application_id => l_receivable_application_id,
229: x_applied_rec_app_id => l_applied_rec_app_id
230: );
231: IF l_return_status = FND_API.g_ret_sts_error THEN
232: RAISE FND_API.g_exc_error;
233: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
234: RAISE FND_API.g_exc_unexpected_error;
235: END IF;

Line 232: RAISE FND_API.g_exc_error;

228: x_receivable_application_id => l_receivable_application_id,
229: x_applied_rec_app_id => l_applied_rec_app_id
230: );
231: IF l_return_status = FND_API.g_ret_sts_error THEN
232: RAISE FND_API.g_exc_error;
233: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
234: RAISE FND_API.g_exc_unexpected_error;
235: END IF;
236: END IF;

Line 233: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

229: x_applied_rec_app_id => l_applied_rec_app_id
230: );
231: IF l_return_status = FND_API.g_ret_sts_error THEN
232: RAISE FND_API.g_exc_error;
233: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
234: RAISE FND_API.g_exc_unexpected_error;
235: END IF;
236: END IF;
237:

Line 234: RAISE FND_API.g_exc_unexpected_error;

230: );
231: IF l_return_status = FND_API.g_ret_sts_error THEN
232: RAISE FND_API.g_exc_error;
233: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
234: RAISE FND_API.g_exc_unexpected_error;
235: END IF;
236: END IF;
237:
238:

Line 259: IF l_return_status = FND_API.g_ret_sts_error THEN

255: ,x_return_status => l_return_status
256: ,x_msg_data => x_msg_data
257: ,x_msg_count => x_msg_count
258: );
259: IF l_return_status = FND_API.g_ret_sts_error THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;

Line 260: RAISE FND_API.g_exc_error;

256: ,x_msg_data => x_msg_data
257: ,x_msg_count => x_msg_count
258: );
259: IF l_return_status = FND_API.g_ret_sts_error THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:

Line 261: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

257: ,x_msg_count => x_msg_count
258: );
259: IF l_return_status = FND_API.g_ret_sts_error THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:
265: IF OZF_DEBUG_HIGH_ON THEN

Line 262: RAISE FND_API.g_exc_unexpected_error;

258: );
259: IF l_return_status = FND_API.g_ret_sts_error THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
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');

Line 278: IF l_return_status = FND_API.g_ret_sts_error THEN

274: ,x_return_status => l_return_status
275: ,x_msg_data => x_msg_data
276: ,x_msg_count => x_msg_count
277: );
278: IF l_return_status = FND_API.g_ret_sts_error THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;

Line 279: RAISE FND_API.g_exc_error;

275: ,x_msg_data => x_msg_data
276: ,x_msg_count => x_msg_count
277: );
278: IF l_return_status = FND_API.g_ret_sts_error THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:

Line 280: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

276: ,x_msg_count => x_msg_count
277: );
278: IF l_return_status = FND_API.g_ret_sts_error THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284:

Line 281: RAISE FND_API.g_exc_unexpected_error;

277: );
278: IF l_return_status = FND_API.g_ret_sts_error THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284:
285: ELSIF p_deduction_type = 'RECEIPT_DED' THEN

Line 307: IF l_return_status = FND_API.g_ret_sts_error THEN

303: ,x_return_status => l_return_status
304: ,x_msg_data => x_msg_data
305: ,x_msg_count => x_msg_count
306: );
307: IF l_return_status = FND_API.g_ret_sts_error THEN
308: RAISE FND_API.g_exc_error;
309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
310: RAISE FND_API.g_exc_unexpected_error;
311: END IF;

Line 308: RAISE FND_API.g_exc_error;

304: ,x_msg_data => x_msg_data
305: ,x_msg_count => x_msg_count
306: );
307: IF l_return_status = FND_API.g_ret_sts_error THEN
308: RAISE FND_API.g_exc_error;
309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
310: RAISE FND_API.g_exc_unexpected_error;
311: END IF;
312: END IF; -- end if p_deduction_type

Line 309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

305: ,x_msg_count => x_msg_count
306: );
307: IF l_return_status = FND_API.g_ret_sts_error THEN
308: RAISE FND_API.g_exc_error;
309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
310: RAISE FND_API.g_exc_unexpected_error;
311: END IF;
312: END IF; -- end if p_deduction_type
313:

Line 310: RAISE FND_API.g_exc_unexpected_error;

306: );
307: IF l_return_status = FND_API.g_ret_sts_error THEN
308: RAISE FND_API.g_exc_error;
309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
310: RAISE FND_API.g_exc_unexpected_error;
311: END IF;
312: END IF; -- end if p_deduction_type
313:
314: -- ----------------------------------------------------------

Line 319: ,p_init_msg_list => FND_API.g_false

315: -- 4. Update Payment Detail
316: -- ----------------------------------------------------------
317: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
318: p_api_version => l_api_version
319: ,p_init_msg_list => FND_API.g_false
320: ,p_commit => FND_API.g_false
321: ,p_validation_level => FND_API.g_valid_level_full
322: ,x_return_status => l_return_status
323: ,x_msg_data => x_msg_data

Line 320: ,p_commit => FND_API.g_false

316: -- ----------------------------------------------------------
317: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
318: p_api_version => l_api_version
319: ,p_init_msg_list => FND_API.g_false
320: ,p_commit => FND_API.g_false
321: ,p_validation_level => FND_API.g_valid_level_full
322: ,x_return_status => l_return_status
323: ,x_msg_data => x_msg_data
324: ,x_msg_count => x_msg_count

Line 321: ,p_validation_level => FND_API.g_valid_level_full

317: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
318: p_api_version => l_api_version
319: ,p_init_msg_list => FND_API.g_false
320: ,p_commit => FND_API.g_false
321: ,p_validation_level => FND_API.g_valid_level_full
322: ,x_return_status => l_return_status
323: ,x_msg_data => x_msg_data
324: ,x_msg_count => x_msg_count
325: ,p_claim_id => p_claim_rec.claim_id

Line 334: IF l_return_status = FND_API.g_ret_sts_error THEN

330: ,p_adjust_id => NULL
331: ,p_settlement_doc_id => NULL
332: ,p_settlement_mode => 'MASS_SETTLEMENT'
333: );
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;

Line 335: RAISE FND_API.g_exc_error;

331: ,p_settlement_doc_id => NULL
332: ,p_settlement_mode => 'MASS_SETTLEMENT'
333: );
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339:

Line 336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

332: ,p_settlement_mode => 'MASS_SETTLEMENT'
333: );
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339:
340:

Line 337: RAISE FND_API.g_exc_unexpected_error;

333: );
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339:
340:
341: /* Bug4079177: Receipt Application error when netting */

Line 369: IF l_return_status = FND_API.g_ret_sts_error THEN

365: ,x_return_status => l_return_status
366: ,x_msg_data => x_msg_data
367: ,x_msg_count => x_msg_count
368: );
369: IF l_return_status = FND_API.g_ret_sts_error THEN
370: RAISE FND_API.g_exc_error;
371: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;

Line 370: RAISE FND_API.g_exc_error;

366: ,x_msg_data => x_msg_data
367: ,x_msg_count => x_msg_count
368: );
369: IF l_return_status = FND_API.g_ret_sts_error THEN
370: RAISE FND_API.g_exc_error;
371: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;
374:

Line 371: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

367: ,x_msg_count => x_msg_count
368: );
369: IF l_return_status = FND_API.g_ret_sts_error THEN
370: RAISE FND_API.g_exc_error;
371: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;
374:
375:

Line 372: RAISE FND_API.g_exc_unexpected_error;

368: );
369: IF l_return_status = FND_API.g_ret_sts_error THEN
370: RAISE FND_API.g_exc_error;
371: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;
374:
375:
376: -- ------------------------------

Line 389: p_init_msg_list => FND_API.G_FALSE,

385: IF l_payment_claim_rec.receipt_id <> p_claim_rec.receipt_id THEN
386: AR_RECEIPT_API_COVER.Apply_Open_Receipt(
387: -- Standard API parameters.
388: p_api_version => l_api_version,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_commit => FND_API.G_FALSE,
391: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
392: x_return_status => l_return_status,
393: x_msg_count => x_msg_count,

Line 390: p_commit => FND_API.G_FALSE,

386: AR_RECEIPT_API_COVER.Apply_Open_Receipt(
387: -- Standard API parameters.
388: p_api_version => l_api_version,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_commit => FND_API.G_FALSE,
391: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
392: x_return_status => l_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,

Line 391: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

387: -- Standard API parameters.
388: p_api_version => l_api_version,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_commit => FND_API.G_FALSE,
391: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
392: x_return_status => l_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,
395: -- Receipt application parameters.

Line 417: IF l_return_status = FND_API.g_ret_sts_error THEN

413: x_application_ref_num => l_application_ref_num,
414: x_receivable_application_id => l_receivable_application_id,
415: x_applied_rec_app_id => l_applied_rec_app_id
416: );
417: IF l_return_status = FND_API.g_ret_sts_error THEN
418: RAISE FND_API.g_exc_error;
419: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;

Line 418: RAISE FND_API.g_exc_error;

414: x_receivable_application_id => l_receivable_application_id,
415: x_applied_rec_app_id => l_applied_rec_app_id
416: );
417: IF l_return_status = FND_API.g_ret_sts_error THEN
418: RAISE FND_API.g_exc_error;
419: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: END IF;

Line 419: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

415: x_applied_rec_app_id => l_applied_rec_app_id
416: );
417: IF l_return_status = FND_API.g_ret_sts_error THEN
418: RAISE FND_API.g_exc_error;
419: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: END IF;
423:

Line 420: RAISE FND_API.g_exc_unexpected_error;

416: );
417: IF l_return_status = FND_API.g_ret_sts_error THEN
418: RAISE FND_API.g_exc_error;
419: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: END IF;
423:
424:

Line 446: IF l_return_status = FND_API.g_ret_sts_error THEN

442: ,x_return_status => l_return_status
443: ,x_msg_data => x_msg_data
444: ,x_msg_count => x_msg_count
445: );
446: IF l_return_status = FND_API.g_ret_sts_error THEN
447: RAISE FND_API.g_exc_error;
448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
449: RAISE FND_API.g_exc_unexpected_error;
450: END IF;

Line 447: RAISE FND_API.g_exc_error;

443: ,x_msg_data => x_msg_data
444: ,x_msg_count => x_msg_count
445: );
446: IF l_return_status = FND_API.g_ret_sts_error THEN
447: RAISE FND_API.g_exc_error;
448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
449: RAISE FND_API.g_exc_unexpected_error;
450: END IF;
451:

Line 448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

444: ,x_msg_count => x_msg_count
445: );
446: IF l_return_status = FND_API.g_ret_sts_error THEN
447: RAISE FND_API.g_exc_error;
448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
449: RAISE FND_API.g_exc_unexpected_error;
450: END IF;
451:
452: IF OZF_DEBUG_HIGH_ON THEN

Line 449: RAISE FND_API.g_exc_unexpected_error;

445: );
446: IF l_return_status = FND_API.g_ret_sts_error THEN
447: RAISE FND_API.g_exc_error;
448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
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');

Line 465: IF l_return_status = FND_API.g_ret_sts_error THEN

461: ,x_return_status => l_return_status
462: ,x_msg_data => x_msg_data
463: ,x_msg_count => x_msg_count
464: );
465: IF l_return_status = FND_API.g_ret_sts_error THEN
466: RAISE FND_API.g_exc_error;
467: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
468: RAISE FND_API.g_exc_unexpected_error;
469: END IF;

Line 466: RAISE FND_API.g_exc_error;

462: ,x_msg_data => x_msg_data
463: ,x_msg_count => x_msg_count
464: );
465: IF l_return_status = FND_API.g_ret_sts_error THEN
466: RAISE FND_API.g_exc_error;
467: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
468: RAISE FND_API.g_exc_unexpected_error;
469: END IF;
470:

Line 467: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

463: ,x_msg_count => x_msg_count
464: );
465: IF l_return_status = FND_API.g_ret_sts_error THEN
466: RAISE FND_API.g_exc_error;
467: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
468: RAISE FND_API.g_exc_unexpected_error;
469: END IF;
470:
471:

Line 468: RAISE FND_API.g_exc_unexpected_error;

464: );
465: IF l_return_status = FND_API.g_ret_sts_error THEN
466: RAISE FND_API.g_exc_error;
467: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
468: RAISE FND_API.g_exc_unexpected_error;
469: END IF;
470:
471:
472: ELSIF l_payment_claim_rec.source_object_id IS NULL THEN

Line 493: IF l_return_status = FND_API.g_ret_sts_error THEN

489: ,x_return_status => l_return_status
490: ,x_msg_data => x_msg_data
491: ,x_msg_count => x_msg_count
492: );
493: IF l_return_status = FND_API.g_ret_sts_error THEN
494: RAISE FND_API.g_exc_error;
495: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
496: RAISE FND_API.g_exc_unexpected_error;
497: END IF;

Line 494: RAISE FND_API.g_exc_error;

490: ,x_msg_data => x_msg_data
491: ,x_msg_count => x_msg_count
492: );
493: IF l_return_status = FND_API.g_ret_sts_error THEN
494: RAISE FND_API.g_exc_error;
495: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
496: RAISE FND_API.g_exc_unexpected_error;
497: END IF;
498: END IF; -- end if l_payment_claim_rec.claim_class

Line 495: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

491: ,x_msg_count => x_msg_count
492: );
493: IF l_return_status = FND_API.g_ret_sts_error THEN
494: RAISE FND_API.g_exc_error;
495: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
496: RAISE FND_API.g_exc_unexpected_error;
497: END IF;
498: END IF; -- end if l_payment_claim_rec.claim_class
499:

Line 496: RAISE FND_API.g_exc_unexpected_error;

492: );
493: IF l_return_status = FND_API.g_ret_sts_error THEN
494: RAISE FND_API.g_exc_error;
495: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
496: RAISE FND_API.g_exc_unexpected_error;
497: END IF;
498: END IF; -- end if l_payment_claim_rec.claim_class
499:
500:

Line 506: ,p_init_msg_list => FND_API.g_false

502: -- 4. Update Payment Detail
503: -- ----------------------------------------------------------
504: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
505: p_api_version => l_api_version
506: ,p_init_msg_list => FND_API.g_false
507: ,p_commit => FND_API.g_false
508: ,p_validation_level => FND_API.g_valid_level_full
509: ,x_return_status => l_return_status
510: ,x_msg_data => x_msg_data

Line 507: ,p_commit => FND_API.g_false

503: -- ----------------------------------------------------------
504: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
505: p_api_version => l_api_version
506: ,p_init_msg_list => FND_API.g_false
507: ,p_commit => FND_API.g_false
508: ,p_validation_level => FND_API.g_valid_level_full
509: ,x_return_status => l_return_status
510: ,x_msg_data => x_msg_data
511: ,x_msg_count => x_msg_count

Line 508: ,p_validation_level => FND_API.g_valid_level_full

504: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
505: p_api_version => l_api_version
506: ,p_init_msg_list => FND_API.g_false
507: ,p_commit => FND_API.g_false
508: ,p_validation_level => FND_API.g_valid_level_full
509: ,x_return_status => l_return_status
510: ,x_msg_data => x_msg_data
511: ,x_msg_count => x_msg_count
512: ,p_claim_id => p_claim_rec.claim_id

Line 521: IF l_return_status = FND_API.g_ret_sts_error THEN

517: ,p_adjust_id => NULL
518: ,p_settlement_doc_id => NULL
519: ,p_settlement_mode => 'MASS_SETTLEMENT'
520: );
521: IF l_return_status = FND_API.g_ret_sts_error THEN
522: RAISE FND_API.g_exc_error;
523: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
524: RAISE FND_API.g_exc_unexpected_error;
525: END IF;

Line 522: RAISE FND_API.g_exc_error;

518: ,p_settlement_doc_id => NULL
519: ,p_settlement_mode => 'MASS_SETTLEMENT'
520: );
521: IF l_return_status = FND_API.g_ret_sts_error THEN
522: RAISE FND_API.g_exc_error;
523: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
524: RAISE FND_API.g_exc_unexpected_error;
525: END IF;
526:

Line 523: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

519: ,p_settlement_mode => 'MASS_SETTLEMENT'
520: );
521: IF l_return_status = FND_API.g_ret_sts_error THEN
522: RAISE FND_API.g_exc_error;
523: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
524: RAISE FND_API.g_exc_unexpected_error;
525: END IF;
526:
527: END IF;

Line 524: RAISE FND_API.g_exc_unexpected_error;

520: );
521: IF l_return_status = FND_API.g_ret_sts_error THEN
522: RAISE FND_API.g_exc_error;
523: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
524: RAISE FND_API.g_exc_unexpected_error;
525: END IF;
526:
527: END IF;
528:

Line 534: WHEN FND_API.g_exc_error THEN

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;
536:
537: WHEN FND_API.g_exc_unexpected_error THEN
538: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 535: x_return_status := FND_API.g_ret_sts_error;

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;
536:
537: WHEN FND_API.g_exc_unexpected_error THEN
538: x_return_status := FND_API.g_ret_sts_unexp_error ;
539:

Line 537: WHEN FND_API.g_exc_unexpected_error THEN

533: EXCEPTION
534: WHEN FND_API.g_exc_error THEN
535: x_return_status := FND_API.g_ret_sts_error;
536:
537: WHEN FND_API.g_exc_unexpected_error THEN
538: x_return_status := FND_API.g_ret_sts_unexp_error ;
539:
540: WHEN OTHERS THEN
541: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 538: x_return_status := FND_API.g_ret_sts_unexp_error ;

534: WHEN FND_API.g_exc_error THEN
535: x_return_status := FND_API.g_ret_sts_error;
536:
537: WHEN FND_API.g_exc_unexpected_error THEN
538: x_return_status := FND_API.g_ret_sts_unexp_error ;
539:
540: WHEN OTHERS THEN
541: x_return_status := FND_API.g_ret_sts_unexp_error ;
542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 541: x_return_status := FND_API.g_ret_sts_unexp_error ;

537: WHEN FND_API.g_exc_unexpected_error THEN
538: x_return_status := FND_API.g_ret_sts_unexp_error ;
539:
540: WHEN OTHERS THEN
541: x_return_status := FND_API.g_ret_sts_unexp_error ;
542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
543: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
544: END IF;
545:

Line 632: x_return_status := FND_API.g_ret_sts_success;

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 -------------------------
635: IF p_deduction_type = 'RECEIPT_OPM' THEN
636: /*------------------------------------------------------------*

Line 647: IF l_return_status = FND_API.g_ret_sts_error THEN

643: ,x_msg_data => x_msg_data
644: ,x_msg_count => x_msg_count
645: );
646: */
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;

Line 648: RAISE FND_API.g_exc_error;

644: ,x_msg_count => x_msg_count
645: );
646: */
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: ELSE

Line 649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

645: );
646: */
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: ELSE
653: IF p_payment_reference_id IS NULL OR

Line 650: RAISE FND_API.g_exc_unexpected_error;

646: */
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: ELSE
653: IF p_payment_reference_id IS NULL OR
654: p_payment_reference_id = FND_API.g_miss_num THEN

Line 654: p_payment_reference_id = FND_API.g_miss_num THEN

650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: ELSE
653: IF p_payment_reference_id IS NULL OR
654: p_payment_reference_id = FND_API.g_miss_num THEN
655: /*------------------------------------------------------------*
656: | No payment reference specified (No open credit memo specified) -> AutoInvoice
657: *------------------------------------------------------------*/
658: IF OZF_DEBUG_HIGH_ON THEN

Line 664: ,p_init_msg_list => FND_API.g_false

660: END IF;
661: -- 1. AutoInvoice
662: OZF_AR_INTERFACE_PVT.Interface_Claim(
663: p_api_version => l_api_version
664: ,p_init_msg_list => FND_API.g_false
665: ,p_commit => FND_API.g_false
666: ,p_validation_level => FND_API.g_valid_level_full
667: ,x_return_status => l_return_status
668: ,x_msg_data => x_msg_data

Line 665: ,p_commit => FND_API.g_false

661: -- 1. AutoInvoice
662: OZF_AR_INTERFACE_PVT.Interface_Claim(
663: p_api_version => l_api_version
664: ,p_init_msg_list => FND_API.g_false
665: ,p_commit => FND_API.g_false
666: ,p_validation_level => FND_API.g_valid_level_full
667: ,x_return_status => l_return_status
668: ,x_msg_data => x_msg_data
669: ,x_msg_count => x_msg_count

Line 666: ,p_validation_level => FND_API.g_valid_level_full

662: OZF_AR_INTERFACE_PVT.Interface_Claim(
663: p_api_version => l_api_version
664: ,p_init_msg_list => FND_API.g_false
665: ,p_commit => FND_API.g_false
666: ,p_validation_level => FND_API.g_valid_level_full
667: ,x_return_status => l_return_status
668: ,x_msg_data => x_msg_data
669: ,x_msg_count => x_msg_count
670: ,p_claim_id => p_claim_rec.claim_id

Line 672: IF l_return_status = FND_API.g_ret_sts_error THEN

668: ,x_msg_data => x_msg_data
669: ,x_msg_count => x_msg_count
670: ,p_claim_id => p_claim_rec.claim_id
671: );
672: IF l_return_status = FND_API.g_ret_sts_error THEN
673: RAISE FND_API.g_exc_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
675: RAISE FND_API.g_exc_unexpected_error;
676: END IF;

Line 673: RAISE FND_API.g_exc_error;

669: ,x_msg_count => x_msg_count
670: ,p_claim_id => p_claim_rec.claim_id
671: );
672: IF l_return_status = FND_API.g_ret_sts_error THEN
673: RAISE FND_API.g_exc_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
675: RAISE FND_API.g_exc_unexpected_error;
676: END IF;
677:

Line 674: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

670: ,p_claim_id => p_claim_rec.claim_id
671: );
672: IF l_return_status = FND_API.g_ret_sts_error THEN
673: RAISE FND_API.g_exc_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
675: RAISE FND_API.g_exc_unexpected_error;
676: END IF;
677:
678: --2. Update Deduction payment detail -- : Fetcher program

Line 675: RAISE FND_API.g_exc_unexpected_error;

671: );
672: IF l_return_status = FND_API.g_ret_sts_error THEN
673: RAISE FND_API.g_exc_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
675: RAISE FND_API.g_exc_unexpected_error;
676: END IF;
677:
678: --2. Update Deduction payment detail -- : Fetcher program
679: l_online_upd_ded_status := FALSE;

Line 692: IF l_return_status = FND_API.g_ret_sts_error THEN

688: ,x_return_status => l_return_status
689: ,x_msg_data => x_msg_data
690: ,x_msg_count => x_msg_count
691: );
692: IF l_return_status = FND_API.g_ret_sts_error THEN
693: RAISE FND_API.g_exc_error;
694: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
695: RAISE FND_API.g_exc_unexpected_error;
696: END IF;

Line 693: RAISE FND_API.g_exc_error;

689: ,x_msg_data => x_msg_data
690: ,x_msg_count => x_msg_count
691: );
692: IF l_return_status = FND_API.g_ret_sts_error THEN
693: RAISE FND_API.g_exc_error;
694: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
695: RAISE FND_API.g_exc_unexpected_error;
696: END IF;
697: */

Line 694: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

690: ,x_msg_count => x_msg_count
691: );
692: IF l_return_status = FND_API.g_ret_sts_error THEN
693: RAISE FND_API.g_exc_error;
694: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
695: RAISE FND_API.g_exc_unexpected_error;
696: END IF;
697: */
698:

Line 695: RAISE FND_API.g_exc_unexpected_error;

691: );
692: IF l_return_status = FND_API.g_ret_sts_error THEN
693: RAISE FND_API.g_exc_error;
694: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
695: RAISE FND_API.g_exc_unexpected_error;
696: END IF;
697: */
698:
699: OPEN csr_cm_exist_on_rec(p_claim_rec.receipt_id, p_payment_reference_id);

Line 733: IF l_return_status = FND_API.g_ret_sts_error THEN

729: ,x_return_status => l_return_status
730: ,x_msg_data => x_msg_data
731: ,x_msg_count => x_msg_count
732: );
733: IF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: END IF;

Line 734: RAISE FND_API.g_exc_error;

730: ,x_msg_data => x_msg_data
731: ,x_msg_count => x_msg_count
732: );
733: IF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: END IF;
738:

Line 735: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

731: ,x_msg_count => x_msg_count
732: );
733: IF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: END IF;
738:
739: IF l_cm_applied_on_rec_amt IS NULL THEN

Line 736: RAISE FND_API.g_exc_unexpected_error;

732: );
733: IF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: END IF;
738:
739: IF l_cm_applied_on_rec_amt IS NULL THEN
740: IF OZF_DEBUG_HIGH_ON THEN

Line 755: IF l_return_status = FND_API.g_ret_sts_error THEN

751: ,x_return_status => l_return_status
752: ,x_msg_data => x_msg_data
753: ,x_msg_count => x_msg_count
754: );
755: IF l_return_status = FND_API.g_ret_sts_error THEN
756: RAISE FND_API.g_exc_error;
757: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
758: RAISE FND_API.g_exc_unexpected_error;
759: END IF;

Line 756: RAISE FND_API.g_exc_error;

752: ,x_msg_data => x_msg_data
753: ,x_msg_count => x_msg_count
754: );
755: IF l_return_status = FND_API.g_ret_sts_error THEN
756: RAISE FND_API.g_exc_error;
757: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
758: RAISE FND_API.g_exc_unexpected_error;
759: END IF;
760: ELSE

Line 757: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

753: ,x_msg_count => x_msg_count
754: );
755: IF l_return_status = FND_API.g_ret_sts_error THEN
756: RAISE FND_API.g_exc_error;
757: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
758: RAISE FND_API.g_exc_unexpected_error;
759: END IF;
760: ELSE
761: IF OZF_DEBUG_HIGH_ON THEN

Line 758: RAISE FND_API.g_exc_unexpected_error;

754: );
755: IF l_return_status = FND_API.g_ret_sts_error THEN
756: RAISE FND_API.g_exc_error;
757: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
758: RAISE FND_API.g_exc_unexpected_error;
759: END IF;
760: ELSE
761: IF OZF_DEBUG_HIGH_ON THEN
762: OZF_Utility_PVT.debug_message('Invoice Deduction: Pay by Previous Open Credit Memo which already exists on the receipt');

Line 772: p_init_msg_list => FND_API.g_false,

768: arp_deduction_cover2.reapply_credit_memo(
769: p_customer_trx_id => p_payment_reference_id ,
770: p_cash_receipt_id => p_claim_rec.receipt_id,
771: p_amount_applied => l_cm_applied_on_rec_amt + (p_credit_memo_amount * -1),
772: p_init_msg_list => FND_API.g_false,
773: x_return_status => l_return_status,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 776: IF l_return_status = FND_API.g_ret_sts_error THEN

772: p_init_msg_list => FND_API.g_false,
773: x_return_status => l_return_status,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776: IF l_return_status = FND_API.g_ret_sts_error THEN
777: RAISE FND_API.g_exc_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
779: RAISE FND_API.g_exc_unexpected_error;
780: END IF;

Line 777: RAISE FND_API.g_exc_error;

773: x_return_status => l_return_status,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776: IF l_return_status = FND_API.g_ret_sts_error THEN
777: RAISE FND_API.g_exc_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
779: RAISE FND_API.g_exc_unexpected_error;
780: END IF;
781: END IF;

Line 778: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776: IF l_return_status = FND_API.g_ret_sts_error THEN
777: RAISE FND_API.g_exc_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
779: RAISE FND_API.g_exc_unexpected_error;
780: END IF;
781: END IF;
782:

Line 779: RAISE FND_API.g_exc_unexpected_error;

775: x_msg_data => x_msg_data);
776: IF l_return_status = FND_API.g_ret_sts_error THEN
777: RAISE FND_API.g_exc_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
779: RAISE FND_API.g_exc_unexpected_error;
780: END IF;
781: END IF;
782:
783: IF OZF_DEBUG_HIGH_ON THEN

Line 796: IF l_return_status = FND_API.g_ret_sts_error THEN

792: ,x_return_status => l_return_status
793: ,x_msg_data => x_msg_data
794: ,x_msg_count => x_msg_count
795: );
796: IF l_return_status = FND_API.g_ret_sts_error THEN
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: RAISE FND_API.g_exc_unexpected_error;
800: END IF;

Line 797: RAISE FND_API.g_exc_error;

793: ,x_msg_data => x_msg_data
794: ,x_msg_count => x_msg_count
795: );
796: IF l_return_status = FND_API.g_ret_sts_error THEN
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: RAISE FND_API.g_exc_unexpected_error;
800: END IF;
801:

Line 798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

794: ,x_msg_count => x_msg_count
795: );
796: IF l_return_status = FND_API.g_ret_sts_error THEN
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: RAISE FND_API.g_exc_unexpected_error;
800: END IF;
801:
802: l_online_upd_ded_status := TRUE;

Line 799: RAISE FND_API.g_exc_unexpected_error;

795: );
796: IF l_return_status = FND_API.g_ret_sts_error THEN
797: RAISE FND_API.g_exc_error;
798: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
799: RAISE FND_API.g_exc_unexpected_error;
800: END IF;
801:
802: l_online_upd_ded_status := TRUE;
803:

Line 829: IF l_return_status = FND_API.g_ret_sts_error THEN

825: ,x_return_status => l_return_status
826: ,x_msg_data => x_msg_data
827: ,x_msg_count => x_msg_count
828: );
829: IF l_return_status = FND_API.g_ret_sts_error THEN
830: RAISE FND_API.g_exc_error;
831: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
832: RAISE FND_API.g_exc_unexpected_error;
833: END IF;

Line 830: RAISE FND_API.g_exc_error;

826: ,x_msg_data => x_msg_data
827: ,x_msg_count => x_msg_count
828: );
829: IF l_return_status = FND_API.g_ret_sts_error THEN
830: RAISE FND_API.g_exc_error;
831: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
832: RAISE FND_API.g_exc_unexpected_error;
833: END IF;
834: IF OZF_DEBUG_HIGH_ON THEN

Line 831: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

827: ,x_msg_count => x_msg_count
828: );
829: IF l_return_status = FND_API.g_ret_sts_error THEN
830: RAISE FND_API.g_exc_error;
831: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
832: RAISE FND_API.g_exc_unexpected_error;
833: END IF;
834: IF OZF_DEBUG_HIGH_ON THEN
835: OZF_Utility_PVT.debug_message('Receipt Deduction -> 2. Unapply claim investigation');

Line 832: RAISE FND_API.g_exc_unexpected_error;

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

Line 852: p_init_msg_list => FND_API.g_false,

848: arp_deduction_cover2.reapply_credit_memo(
849: p_customer_trx_id => p_payment_reference_id ,
850: p_cash_receipt_id => p_claim_rec.receipt_id,
851: p_amount_applied => l_cm_applied_on_rec_amt + (p_credit_memo_amount * -1),
852: p_init_msg_list => FND_API.g_false,
853: x_return_status => l_return_status,
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 856: IF l_return_status = FND_API.g_ret_sts_error THEN

852: p_init_msg_list => FND_API.g_false,
853: x_return_status => l_return_status,
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856: IF l_return_status = FND_API.g_ret_sts_error THEN
857: RAISE FND_API.g_exc_error;
858: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;

Line 857: RAISE FND_API.g_exc_error;

853: x_return_status => l_return_status,
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856: IF l_return_status = FND_API.g_ret_sts_error THEN
857: RAISE FND_API.g_exc_error;
858: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;
861: END IF;

Line 858: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856: IF l_return_status = FND_API.g_ret_sts_error THEN
857: RAISE FND_API.g_exc_error;
858: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;
861: END IF;
862:

Line 859: RAISE FND_API.g_exc_unexpected_error;

855: x_msg_data => x_msg_data);
856: IF l_return_status = FND_API.g_ret_sts_error THEN
857: RAISE FND_API.g_exc_error;
858: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
859: RAISE FND_API.g_exc_unexpected_error;
860: END IF;
861: END IF;
862:
863: -- 2. Unapply claim investigation

Line 879: IF l_return_status = FND_API.g_ret_sts_error THEN

875: ,x_return_status => l_return_status
876: ,x_msg_data => x_msg_data
877: ,x_msg_count => x_msg_count
878: );
879: IF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
882: RAISE FND_API.g_exc_unexpected_error;
883: END IF;

Line 880: RAISE FND_API.g_exc_error;

876: ,x_msg_data => x_msg_data
877: ,x_msg_count => x_msg_count
878: );
879: IF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
882: RAISE FND_API.g_exc_unexpected_error;
883: END IF;
884: l_online_upd_ded_status := TRUE;

Line 881: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

877: ,x_msg_count => x_msg_count
878: );
879: IF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
882: RAISE FND_API.g_exc_unexpected_error;
883: END IF;
884: l_online_upd_ded_status := TRUE;
885: END IF; -- end if p_deduction_type = 'SOURCE_DED', elsif p_deduction_type = 'DEDUCTION_DED'

Line 882: RAISE FND_API.g_exc_unexpected_error;

878: );
879: IF l_return_status = FND_API.g_ret_sts_error THEN
880: RAISE FND_API.g_exc_error;
881: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
882: RAISE FND_API.g_exc_unexpected_error;
883: END IF;
884: l_online_upd_ded_status := TRUE;
885: END IF; -- end if p_deduction_type = 'SOURCE_DED', elsif p_deduction_type = 'DEDUCTION_DED'
886: END IF; -- end if payment_reference_id is null

Line 895: ,p_init_msg_list => FND_API.g_false

891: IF l_online_upd_ded_status THEN
892: -- Update Deduction payment detail
893: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
894: p_api_version => l_api_version
895: ,p_init_msg_list => FND_API.g_false
896: ,p_commit => FND_API.g_false
897: ,p_validation_level => FND_API.g_valid_level_full
898: ,x_return_status => l_return_status
899: ,x_msg_data => x_msg_data

Line 896: ,p_commit => FND_API.g_false

892: -- Update Deduction payment detail
893: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
894: p_api_version => l_api_version
895: ,p_init_msg_list => FND_API.g_false
896: ,p_commit => FND_API.g_false
897: ,p_validation_level => FND_API.g_valid_level_full
898: ,x_return_status => l_return_status
899: ,x_msg_data => x_msg_data
900: ,x_msg_count => x_msg_count

Line 897: ,p_validation_level => FND_API.g_valid_level_full

893: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
894: p_api_version => l_api_version
895: ,p_init_msg_list => FND_API.g_false
896: ,p_commit => FND_API.g_false
897: ,p_validation_level => FND_API.g_valid_level_full
898: ,x_return_status => l_return_status
899: ,x_msg_data => x_msg_data
900: ,x_msg_count => x_msg_count
901: ,p_claim_id => p_claim_rec.claim_id

Line 911: IF l_return_status = FND_API.g_ret_sts_error THEN

907: ,p_settlement_doc_id => p_settlement_doc_id
908: ,p_settlement_mode => 'MASS_SETTLEMENT'
909: ,p_settlement_amount => l_settlement_amount --Bug4308188
910: );
911: IF l_return_status = FND_API.g_ret_sts_error THEN
912: RAISE FND_API.g_exc_error;
913: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
914: RAISE FND_API.g_exc_unexpected_error;
915: END IF;

Line 912: RAISE FND_API.g_exc_error;

908: ,p_settlement_mode => 'MASS_SETTLEMENT'
909: ,p_settlement_amount => l_settlement_amount --Bug4308188
910: );
911: IF l_return_status = FND_API.g_ret_sts_error THEN
912: RAISE FND_API.g_exc_error;
913: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
914: RAISE FND_API.g_exc_unexpected_error;
915: END IF;
916: END IF;

Line 913: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

909: ,p_settlement_amount => l_settlement_amount --Bug4308188
910: );
911: IF l_return_status = FND_API.g_ret_sts_error THEN
912: RAISE FND_API.g_exc_error;
913: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
914: RAISE FND_API.g_exc_unexpected_error;
915: END IF;
916: END IF;
917:

Line 914: RAISE FND_API.g_exc_unexpected_error;

910: );
911: IF l_return_status = FND_API.g_ret_sts_error THEN
912: RAISE FND_API.g_exc_error;
913: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
914: RAISE FND_API.g_exc_unexpected_error;
915: END IF;
916: END IF;
917:
918: END IF;

Line 924: WHEN FND_API.g_exc_error THEN

920: IF OZF_DEBUG_HIGH_ON THEN
921: OZF_Utility_PVT.debug_message(l_full_name||': end');
922: END IF;
923: EXCEPTION
924: WHEN FND_API.g_exc_error THEN
925: x_return_status := FND_API.g_ret_sts_error;
926:
927: WHEN FND_API.g_exc_unexpected_error THEN
928: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 925: x_return_status := FND_API.g_ret_sts_error;

921: OZF_Utility_PVT.debug_message(l_full_name||': end');
922: END IF;
923: EXCEPTION
924: WHEN FND_API.g_exc_error THEN
925: x_return_status := FND_API.g_ret_sts_error;
926:
927: WHEN FND_API.g_exc_unexpected_error THEN
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929:

Line 927: WHEN FND_API.g_exc_unexpected_error THEN

923: EXCEPTION
924: WHEN FND_API.g_exc_error THEN
925: x_return_status := FND_API.g_ret_sts_error;
926:
927: WHEN FND_API.g_exc_unexpected_error THEN
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929:
930: WHEN OTHERS THEN
931: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 928: x_return_status := FND_API.g_ret_sts_unexp_error ;

924: WHEN FND_API.g_exc_error THEN
925: x_return_status := FND_API.g_ret_sts_error;
926:
927: WHEN FND_API.g_exc_unexpected_error THEN
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929:
930: WHEN OTHERS THEN
931: x_return_status := FND_API.g_ret_sts_unexp_error ;
932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 931: x_return_status := FND_API.g_ret_sts_unexp_error ;

927: WHEN FND_API.g_exc_unexpected_error THEN
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929:
930: WHEN OTHERS THEN
931: x_return_status := FND_API.g_ret_sts_unexp_error ;
932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
934: END IF;
935:

Line 1006: x_return_status := FND_API.g_ret_sts_success;

1002: IF OZF_DEBUG_HIGH_ON THEN
1003: OZF_Utility_PVT.debug_message(l_full_name||': start');
1004: END IF;
1005:
1006: x_return_status := FND_API.g_ret_sts_success;
1007:
1008: ------------------------ start -------------------------
1009: IF p_deduction_type = 'RECEIPT_OPM' THEN
1010: IF p_payment_reference_id IS NULL THEN

Line 1017: ,p_init_msg_list => FND_API.g_false

1013: *------------------------------------------------------------*/
1014: -- 1. AutoInvoice
1015: OZF_AR_INTERFACE_PVT.Interface_Claim(
1016: p_api_version => l_api_version
1017: ,p_init_msg_list => FND_API.g_false
1018: ,p_commit => FND_API.g_false
1019: ,p_validation_level => FND_API.g_valid_level_full
1020: ,x_return_status => l_return_status
1021: ,x_msg_data => x_msg_data

Line 1018: ,p_commit => FND_API.g_false

1014: -- 1. AutoInvoice
1015: OZF_AR_INTERFACE_PVT.Interface_Claim(
1016: p_api_version => l_api_version
1017: ,p_init_msg_list => FND_API.g_false
1018: ,p_commit => FND_API.g_false
1019: ,p_validation_level => FND_API.g_valid_level_full
1020: ,x_return_status => l_return_status
1021: ,x_msg_data => x_msg_data
1022: ,x_msg_count => x_msg_count

Line 1019: ,p_validation_level => FND_API.g_valid_level_full

1015: OZF_AR_INTERFACE_PVT.Interface_Claim(
1016: p_api_version => l_api_version
1017: ,p_init_msg_list => FND_API.g_false
1018: ,p_commit => FND_API.g_false
1019: ,p_validation_level => FND_API.g_valid_level_full
1020: ,x_return_status => l_return_status
1021: ,x_msg_data => x_msg_data
1022: ,x_msg_count => x_msg_count
1023: ,p_claim_id => p_claim_rec.claim_id

Line 1025: IF l_return_status = FND_API.g_ret_sts_error THEN

1021: ,x_msg_data => x_msg_data
1022: ,x_msg_count => x_msg_count
1023: ,p_claim_id => p_claim_rec.claim_id
1024: );
1025: IF l_return_status = FND_API.g_ret_sts_error THEN
1026: RAISE FND_API.g_exc_error;
1027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1028: RAISE FND_API.g_exc_unexpected_error;
1029: END IF;

Line 1026: RAISE FND_API.g_exc_error;

1022: ,x_msg_count => x_msg_count
1023: ,p_claim_id => p_claim_rec.claim_id
1024: );
1025: IF l_return_status = FND_API.g_ret_sts_error THEN
1026: RAISE FND_API.g_exc_error;
1027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1028: RAISE FND_API.g_exc_unexpected_error;
1029: END IF;
1030:

Line 1027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1023: ,p_claim_id => p_claim_rec.claim_id
1024: );
1025: IF l_return_status = FND_API.g_ret_sts_error THEN
1026: RAISE FND_API.g_exc_error;
1027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1028: RAISE FND_API.g_exc_unexpected_error;
1029: END IF;
1030:
1031: --2. Update Deduction payment detail -- : Fetcher program

Line 1028: RAISE FND_API.g_exc_unexpected_error;

1024: );
1025: IF l_return_status = FND_API.g_ret_sts_error THEN
1026: RAISE FND_API.g_exc_error;
1027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1028: RAISE FND_API.g_exc_unexpected_error;
1029: END IF;
1030:
1031: --2. Update Deduction payment detail -- : Fetcher program
1032: l_online_upd_ded_status := FALSE;

Line 1044: IF l_return_status = FND_API.g_ret_sts_error THEN

1040: ,x_return_status => l_return_status
1041: ,x_msg_data => x_msg_data
1042: ,x_msg_count => x_msg_count
1043: );
1044: IF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1047: RAISE FND_API.g_exc_unexpected_error;
1048: END IF;

Line 1045: RAISE FND_API.g_exc_error;

1041: ,x_msg_data => x_msg_data
1042: ,x_msg_count => x_msg_count
1043: );
1044: IF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1047: RAISE FND_API.g_exc_unexpected_error;
1048: END IF;
1049: */

Line 1046: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1042: ,x_msg_count => x_msg_count
1043: );
1044: IF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1047: RAISE FND_API.g_exc_unexpected_error;
1048: END IF;
1049: */
1050:

Line 1047: RAISE FND_API.g_exc_unexpected_error;

1043: );
1044: IF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1047: RAISE FND_API.g_exc_unexpected_error;
1048: END IF;
1049: */
1050:
1051: /*------------------------------------------------------------*

Line 1079: IF l_return_status = FND_API.g_ret_sts_error THEN

1075: ,x_return_status => l_return_status
1076: ,x_msg_data => x_msg_data
1077: ,x_msg_count => x_msg_count
1078: );
1079: IF l_return_status = FND_API.g_ret_sts_error THEN
1080: RAISE FND_API.g_exc_error;
1081: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: END IF;

Line 1080: RAISE FND_API.g_exc_error;

1076: ,x_msg_data => x_msg_data
1077: ,x_msg_count => x_msg_count
1078: );
1079: IF l_return_status = FND_API.g_ret_sts_error THEN
1080: RAISE FND_API.g_exc_error;
1081: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: END IF;
1084:

Line 1081: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1077: ,x_msg_count => x_msg_count
1078: );
1079: IF l_return_status = FND_API.g_ret_sts_error THEN
1080: RAISE FND_API.g_exc_error;
1081: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: END IF;
1084:
1085:

Line 1082: RAISE FND_API.g_exc_unexpected_error;

1078: );
1079: IF l_return_status = FND_API.g_ret_sts_error THEN
1080: RAISE FND_API.g_exc_error;
1081: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1082: RAISE FND_API.g_exc_unexpected_error;
1083: END IF;
1084:
1085:
1086: IF l_dm_applied_on_rec_amt IS NULL THEN

Line 1100: IF l_return_status = FND_API.g_ret_sts_error THEN

1096: ,x_return_status => l_return_status
1097: ,x_msg_data => x_msg_data
1098: ,x_msg_count => x_msg_count
1099: );
1100: IF l_return_status = FND_API.g_ret_sts_error THEN
1101: RAISE FND_API.g_exc_error;
1102: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: END IF;

Line 1101: RAISE FND_API.g_exc_error;

1097: ,x_msg_data => x_msg_data
1098: ,x_msg_count => x_msg_count
1099: );
1100: IF l_return_status = FND_API.g_ret_sts_error THEN
1101: RAISE FND_API.g_exc_error;
1102: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: END IF;
1105: ELSE

Line 1102: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1098: ,x_msg_count => x_msg_count
1099: );
1100: IF l_return_status = FND_API.g_ret_sts_error THEN
1101: RAISE FND_API.g_exc_error;
1102: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1103: RAISE FND_API.g_exc_unexpected_error;
1104: END IF;
1105: ELSE
1106: OZF_Utility_PVT.debug_message('Overpayment: Pay by Previous Open Debit Memo which already exists on the receipt');

Line 1103: RAISE FND_API.g_exc_unexpected_error;

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

Line 1116: IF l_return_status = FND_API.g_ret_sts_error THEN

1112: ,x_return_status => l_return_status
1113: ,x_msg_data => x_msg_data
1114: ,x_msg_count => x_msg_count
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;

Line 1117: RAISE FND_API.g_exc_error;

1113: ,x_msg_data => x_msg_data
1114: ,x_msg_count => x_msg_count
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:

Line 1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1114: ,x_msg_count => x_msg_count
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:
1122: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply debit memo with increased amount on receipt');

Line 1119: RAISE FND_API.g_exc_unexpected_error;

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

Line 1136: IF l_return_status = FND_API.g_ret_sts_error THEN

1132: ,x_return_status => l_return_status
1133: ,x_msg_data => x_msg_data
1134: ,x_msg_count => x_msg_count
1135: );
1136: IF l_return_status = FND_API.g_ret_sts_error THEN
1137: RAISE FND_API.g_exc_error;
1138: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;

Line 1137: RAISE FND_API.g_exc_error;

1133: ,x_msg_data => x_msg_data
1134: ,x_msg_count => x_msg_count
1135: );
1136: IF l_return_status = FND_API.g_ret_sts_error THEN
1137: RAISE FND_API.g_exc_error;
1138: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141: END IF;

Line 1138: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1134: ,x_msg_count => x_msg_count
1135: );
1136: IF l_return_status = FND_API.g_ret_sts_error THEN
1137: RAISE FND_API.g_exc_error;
1138: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141: END IF;
1142:

Line 1139: RAISE FND_API.g_exc_unexpected_error;

1135: );
1136: IF l_return_status = FND_API.g_ret_sts_error THEN
1137: RAISE FND_API.g_exc_error;
1138: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141: END IF;
1142:
1143: l_online_upd_ded_status := TRUE;

Line 1160: ,p_init_msg_list => FND_API.g_false

1156: IF l_online_upd_ded_status THEN
1157: -- Update Deduction payment detail
1158: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1159: p_api_version => l_api_version
1160: ,p_init_msg_list => FND_API.g_false
1161: ,p_commit => FND_API.g_false
1162: ,p_validation_level => FND_API.g_valid_level_full
1163: ,x_return_status => l_return_status
1164: ,x_msg_data => x_msg_data

Line 1161: ,p_commit => FND_API.g_false

1157: -- Update Deduction payment detail
1158: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1159: p_api_version => l_api_version
1160: ,p_init_msg_list => FND_API.g_false
1161: ,p_commit => FND_API.g_false
1162: ,p_validation_level => FND_API.g_valid_level_full
1163: ,x_return_status => l_return_status
1164: ,x_msg_data => x_msg_data
1165: ,x_msg_count => x_msg_count

Line 1162: ,p_validation_level => FND_API.g_valid_level_full

1158: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1159: p_api_version => l_api_version
1160: ,p_init_msg_list => FND_API.g_false
1161: ,p_commit => FND_API.g_false
1162: ,p_validation_level => FND_API.g_valid_level_full
1163: ,x_return_status => l_return_status
1164: ,x_msg_data => x_msg_data
1165: ,x_msg_count => x_msg_count
1166: ,p_claim_id => p_claim_rec.claim_id

Line 1176: IF l_return_status = FND_API.g_ret_sts_error THEN

1172: ,p_settlement_doc_id => p_settlement_doc_id
1173: ,p_settlement_mode => 'MASS_SETTLEMENT'
1174: ,p_settlement_amount => l_settlement_amount --Bug4308188
1175: );
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: RAISE FND_API.g_exc_error;
1178: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1179: RAISE FND_API.g_exc_unexpected_error;
1180: END IF;

Line 1177: RAISE FND_API.g_exc_error;

1173: ,p_settlement_mode => 'MASS_SETTLEMENT'
1174: ,p_settlement_amount => l_settlement_amount --Bug4308188
1175: );
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: RAISE FND_API.g_exc_error;
1178: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1179: RAISE FND_API.g_exc_unexpected_error;
1180: END IF;
1181: END IF;

Line 1178: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1174: ,p_settlement_amount => l_settlement_amount --Bug4308188
1175: );
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: RAISE FND_API.g_exc_error;
1178: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1179: RAISE FND_API.g_exc_unexpected_error;
1180: END IF;
1181: END IF;
1182:

Line 1179: RAISE FND_API.g_exc_unexpected_error;

1175: );
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: RAISE FND_API.g_exc_error;
1178: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1179: RAISE FND_API.g_exc_unexpected_error;
1180: END IF;
1181: END IF;
1182:
1183: IF OZF_DEBUG_HIGH_ON THEN

Line 1187: WHEN FND_API.g_exc_error THEN

1183: IF OZF_DEBUG_HIGH_ON THEN
1184: OZF_Utility_PVT.debug_message(l_full_name||': end');
1185: END IF;
1186: EXCEPTION
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189:
1190: WHEN FND_API.g_exc_unexpected_error THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1188: x_return_status := FND_API.g_ret_sts_error;

1184: OZF_Utility_PVT.debug_message(l_full_name||': end');
1185: END IF;
1186: EXCEPTION
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189:
1190: WHEN FND_API.g_exc_unexpected_error THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192:

Line 1190: WHEN FND_API.g_exc_unexpected_error THEN

1186: EXCEPTION
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189:
1190: WHEN FND_API.g_exc_unexpected_error THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1191: x_return_status := FND_API.g_ret_sts_unexp_error ;

1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189:
1190: WHEN FND_API.g_exc_unexpected_error THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.g_ret_sts_unexp_error ;
1195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1194: x_return_status := FND_API.g_ret_sts_unexp_error ;

1190: WHEN FND_API.g_exc_unexpected_error THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.g_ret_sts_unexp_error ;
1195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1196: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1197: END IF;
1198:

Line 1237: x_return_status := FND_API.g_ret_sts_success;

1233: IF OZF_DEBUG_HIGH_ON THEN
1234: OZF_Utility_PVT.debug_message(l_full_name||': start');
1235: END IF;
1236:
1237: x_return_status := FND_API.g_ret_sts_success;
1238:
1239: ------------------------ start -------------------------
1240: /*------------------------------------------------------------*
1241: | Update Claim Status to CLOSED.

Line 1250: IF l_return_status = FND_API.g_ret_sts_error THEN

1246: ,x_return_status => l_return_status
1247: ,x_msg_data => x_msg_data
1248: ,x_msg_count => x_msg_count
1249: );
1250: IF l_return_status = FND_API.g_ret_sts_error THEN
1251: RAISE FND_API.g_exc_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1253: RAISE FND_API.g_exc_unexpected_error;
1254: END IF;

Line 1251: RAISE FND_API.g_exc_error;

1247: ,x_msg_data => x_msg_data
1248: ,x_msg_count => x_msg_count
1249: );
1250: IF l_return_status = FND_API.g_ret_sts_error THEN
1251: RAISE FND_API.g_exc_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1253: RAISE FND_API.g_exc_unexpected_error;
1254: END IF;
1255: */

Line 1252: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1248: ,x_msg_count => x_msg_count
1249: );
1250: IF l_return_status = FND_API.g_ret_sts_error THEN
1251: RAISE FND_API.g_exc_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1253: RAISE FND_API.g_exc_unexpected_error;
1254: END IF;
1255: */
1256: IF p_deduction_type IN ('SOURCE_DED', 'RECEIPT_DED') THEN

Line 1253: RAISE FND_API.g_exc_unexpected_error;

1249: );
1250: IF l_return_status = FND_API.g_ret_sts_error THEN
1251: RAISE FND_API.g_exc_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1253: RAISE FND_API.g_exc_unexpected_error;
1254: END IF;
1255: */
1256: IF p_deduction_type IN ('SOURCE_DED', 'RECEIPT_DED') THEN
1257: IF p_deduction_type = 'SOURCE_DED'THEN

Line 1272: IF l_return_status = FND_API.g_ret_sts_error THEN

1268: ,x_return_status => l_return_status
1269: ,x_msg_data => x_msg_data
1270: ,x_msg_count => x_msg_count
1271: );
1272: IF l_return_status = FND_API.g_ret_sts_error THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;

Line 1273: RAISE FND_API.g_exc_error;

1269: ,x_msg_data => x_msg_data
1270: ,x_msg_count => x_msg_count
1271: );
1272: IF l_return_status = FND_API.g_ret_sts_error THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277:

Line 1274: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1270: ,x_msg_count => x_msg_count
1271: );
1272: IF l_return_status = FND_API.g_ret_sts_error THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277:
1278: IF OZF_DEBUG_HIGH_ON THEN

Line 1275: RAISE FND_API.g_exc_unexpected_error;

1271: );
1272: IF l_return_status = FND_API.g_ret_sts_error THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277:
1278: IF OZF_DEBUG_HIGH_ON THEN
1279: OZF_Utility_PVT.debug_message('x_cb_customer_trx_id = '||l_cb_customer_trx_id);

Line 1289: ,p_init_msg_list => FND_API.g_false

1285: IF l_cb_customer_trx_id IS NOT NULL THEN
1286: -- Update Deduction payment detail
1287: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1288: p_api_version => l_api_version
1289: ,p_init_msg_list => FND_API.g_false
1290: ,p_commit => FND_API.g_false
1291: ,p_validation_level => FND_API.g_valid_level_full
1292: ,x_return_status => l_return_status
1293: ,x_msg_data => x_msg_data

Line 1290: ,p_commit => FND_API.g_false

1286: -- Update Deduction payment detail
1287: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1288: p_api_version => l_api_version
1289: ,p_init_msg_list => FND_API.g_false
1290: ,p_commit => FND_API.g_false
1291: ,p_validation_level => FND_API.g_valid_level_full
1292: ,x_return_status => l_return_status
1293: ,x_msg_data => x_msg_data
1294: ,x_msg_count => x_msg_count

Line 1291: ,p_validation_level => FND_API.g_valid_level_full

1287: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1288: p_api_version => l_api_version
1289: ,p_init_msg_list => FND_API.g_false
1290: ,p_commit => FND_API.g_false
1291: ,p_validation_level => FND_API.g_valid_level_full
1292: ,x_return_status => l_return_status
1293: ,x_msg_data => x_msg_data
1294: ,x_msg_count => x_msg_count
1295: ,p_claim_id => p_claim_rec.claim_id

Line 1304: IF l_return_status = FND_API.g_ret_sts_error THEN

1300: ,p_adjust_id => NULL
1301: ,p_settlement_doc_id => p_settlement_doc_id
1302: ,p_settlement_mode => 'MASS_SETTLEMENT'
1303: );
1304: IF l_return_status = FND_API.g_ret_sts_error THEN
1305: RAISE FND_API.g_exc_error;
1306: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1307: RAISE FND_API.g_exc_unexpected_error;
1308: END IF;

Line 1305: RAISE FND_API.g_exc_error;

1301: ,p_settlement_doc_id => p_settlement_doc_id
1302: ,p_settlement_mode => 'MASS_SETTLEMENT'
1303: );
1304: IF l_return_status = FND_API.g_ret_sts_error THEN
1305: RAISE FND_API.g_exc_error;
1306: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1307: RAISE FND_API.g_exc_unexpected_error;
1308: END IF;
1309: END IF;

Line 1306: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1302: ,p_settlement_mode => 'MASS_SETTLEMENT'
1303: );
1304: IF l_return_status = FND_API.g_ret_sts_error THEN
1305: RAISE FND_API.g_exc_error;
1306: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1307: RAISE FND_API.g_exc_unexpected_error;
1308: END IF;
1309: END IF;
1310:

Line 1307: RAISE FND_API.g_exc_unexpected_error;

1303: );
1304: IF l_return_status = FND_API.g_ret_sts_error THEN
1305: RAISE FND_API.g_exc_error;
1306: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1307: RAISE FND_API.g_exc_unexpected_error;
1308: END IF;
1309: END IF;
1310:
1311: ELSE

Line 1323: WHEN FND_API.g_exc_error THEN

1319: IF OZF_DEBUG_HIGH_ON THEN
1320: OZF_Utility_PVT.debug_message(l_full_name||': end');
1321: END IF;
1322: EXCEPTION
1323: WHEN FND_API.g_exc_error THEN
1324: x_return_status := FND_API.g_ret_sts_error;
1325:
1326: WHEN FND_API.g_exc_unexpected_error THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1324: x_return_status := FND_API.g_ret_sts_error;

1320: OZF_Utility_PVT.debug_message(l_full_name||': end');
1321: END IF;
1322: EXCEPTION
1323: WHEN FND_API.g_exc_error THEN
1324: x_return_status := FND_API.g_ret_sts_error;
1325:
1326: WHEN FND_API.g_exc_unexpected_error THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error ;
1328:

Line 1326: WHEN FND_API.g_exc_unexpected_error THEN

1322: EXCEPTION
1323: WHEN FND_API.g_exc_error THEN
1324: x_return_status := FND_API.g_ret_sts_error;
1325:
1326: WHEN FND_API.g_exc_unexpected_error THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error ;
1328:
1329: WHEN OTHERS THEN
1330: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1327: x_return_status := FND_API.g_ret_sts_unexp_error ;

1323: WHEN FND_API.g_exc_error THEN
1324: x_return_status := FND_API.g_ret_sts_error;
1325:
1326: WHEN FND_API.g_exc_unexpected_error THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error ;
1328:
1329: WHEN OTHERS THEN
1330: x_return_status := FND_API.g_ret_sts_unexp_error ;
1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1330: x_return_status := FND_API.g_ret_sts_unexp_error ;

1326: WHEN FND_API.g_exc_unexpected_error THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error ;
1328:
1329: WHEN OTHERS THEN
1330: x_return_status := FND_API.g_ret_sts_unexp_error ;
1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1333: END IF;
1334:

Line 1373: x_return_status := FND_API.g_ret_sts_success;

1369: IF OZF_DEBUG_HIGH_ON THEN
1370: OZF_Utility_PVT.debug_message(l_full_name||': start');
1371: END IF;
1372:
1373: x_return_status := FND_API.g_ret_sts_success;
1374:
1375: ------------------------ start -------------------------
1376: IF p_deduction_type = 'RECEIPT_DED' AND
1377: NOT ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed THEN

Line 1387: IF l_return_status = FND_API.g_ret_sts_error THEN

1383: ,x_return_status => l_return_status
1384: ,x_msg_data => x_msg_data
1385: ,x_msg_count => x_msg_count
1386: );
1387: IF l_return_status = FND_API.g_ret_sts_error THEN
1388: RAISE FND_API.g_exc_error;
1389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1390: RAISE FND_API.g_exc_unexpected_error;
1391: END IF;

Line 1388: RAISE FND_API.g_exc_error;

1384: ,x_msg_data => x_msg_data
1385: ,x_msg_count => x_msg_count
1386: );
1387: IF l_return_status = FND_API.g_ret_sts_error THEN
1388: RAISE FND_API.g_exc_error;
1389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1390: RAISE FND_API.g_exc_unexpected_error;
1391: END IF;
1392:

Line 1389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1385: ,x_msg_count => x_msg_count
1386: );
1387: IF l_return_status = FND_API.g_ret_sts_error THEN
1388: RAISE FND_API.g_exc_error;
1389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1390: RAISE FND_API.g_exc_unexpected_error;
1391: END IF;
1392:
1393: BEGIN

Line 1390: RAISE FND_API.g_exc_unexpected_error;

1386: );
1387: IF l_return_status = FND_API.g_ret_sts_error THEN
1388: RAISE FND_API.g_exc_error;
1389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1390: RAISE FND_API.g_exc_unexpected_error;
1391: END IF;
1392:
1393: BEGIN
1394: UPDATE ozf_claims_all

Line 1413: RAISE FND_API.g_exc_unexpected_error;

1409: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1410: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1411: FND_MSG_PUB.Add;
1412: END IF;
1413: RAISE FND_API.g_exc_unexpected_error;
1414: END;
1415:
1416: -- Added For ER#14109799
1417: ELSIF p_deduction_type IN ('SOURCE_DED', 'RECEIPT_DED', 'RECEIPT_OPM','SOURCE_OPM') THEN

Line 1428: IF l_return_status = FND_API.g_ret_sts_error THEN

1424: ,x_return_status => l_return_status
1425: ,x_msg_data => x_msg_data
1426: ,x_msg_count => x_msg_count
1427: );
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;

Line 1429: RAISE FND_API.g_exc_error;

1425: ,x_msg_data => x_msg_data
1426: ,x_msg_count => x_msg_count
1427: );
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433: */

Line 1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1426: ,x_msg_count => x_msg_count
1427: );
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433: */
1434:

Line 1431: RAISE FND_API.g_exc_unexpected_error;

1427: );
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433: */
1434:
1435: OZF_AR_Payment_PVT.Create_AR_Write_Off(

Line 1447: IF l_return_status = FND_API.g_ret_sts_error THEN

1443: ,x_return_status => l_return_status
1444: ,x_msg_data => x_msg_data
1445: ,x_msg_count => x_msg_count
1446: );
1447: IF l_return_status = FND_API.g_ret_sts_error THEN
1448: RAISE FND_API.g_exc_error;
1449: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1450: RAISE FND_API.g_exc_unexpected_error;
1451: END IF;

Line 1448: RAISE FND_API.g_exc_error;

1444: ,x_msg_data => x_msg_data
1445: ,x_msg_count => x_msg_count
1446: );
1447: IF l_return_status = FND_API.g_ret_sts_error THEN
1448: RAISE FND_API.g_exc_error;
1449: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1450: RAISE FND_API.g_exc_unexpected_error;
1451: END IF;
1452: END IF;

Line 1449: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1445: ,x_msg_count => x_msg_count
1446: );
1447: IF l_return_status = FND_API.g_ret_sts_error THEN
1448: RAISE FND_API.g_exc_error;
1449: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1450: RAISE FND_API.g_exc_unexpected_error;
1451: END IF;
1452: END IF;
1453:

Line 1450: RAISE FND_API.g_exc_unexpected_error;

1446: );
1447: IF l_return_status = FND_API.g_ret_sts_error THEN
1448: RAISE FND_API.g_exc_error;
1449: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1450: RAISE FND_API.g_exc_unexpected_error;
1451: END IF;
1452: END IF;
1453:
1454: IF OZF_DEBUG_HIGH_ON THEN

Line 1458: WHEN FND_API.g_exc_error THEN

1454: IF OZF_DEBUG_HIGH_ON THEN
1455: OZF_Utility_PVT.debug_message(l_full_name||': end');
1456: END IF;
1457: EXCEPTION
1458: WHEN FND_API.g_exc_error THEN
1459: x_return_status := FND_API.g_ret_sts_error;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1459: x_return_status := FND_API.g_ret_sts_error;

1455: OZF_Utility_PVT.debug_message(l_full_name||': end');
1456: END IF;
1457: EXCEPTION
1458: WHEN FND_API.g_exc_error THEN
1459: x_return_status := FND_API.g_ret_sts_error;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: x_return_status := FND_API.g_ret_sts_unexp_error ;
1463:

Line 1461: WHEN FND_API.g_exc_unexpected_error THEN

1457: EXCEPTION
1458: WHEN FND_API.g_exc_error THEN
1459: x_return_status := FND_API.g_ret_sts_error;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: x_return_status := FND_API.g_ret_sts_unexp_error ;
1463:
1464: WHEN OTHERS THEN
1465: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1462: x_return_status := FND_API.g_ret_sts_unexp_error ;

1458: WHEN FND_API.g_exc_error THEN
1459: x_return_status := FND_API.g_ret_sts_error;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: x_return_status := FND_API.g_ret_sts_unexp_error ;
1463:
1464: WHEN OTHERS THEN
1465: x_return_status := FND_API.g_ret_sts_unexp_error ;
1466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1465: x_return_status := FND_API.g_ret_sts_unexp_error ;

1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: x_return_status := FND_API.g_ret_sts_unexp_error ;
1463:
1464: WHEN OTHERS THEN
1465: x_return_status := FND_API.g_ret_sts_unexp_error ;
1466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1468: END IF;
1469:

Line 1518: x_return_status := FND_API.g_ret_sts_success;

1514: IF OZF_DEBUG_HIGH_ON THEN
1515: OZF_Utility_PVT.debug_message(l_full_name||': start');
1516: END IF;
1517:
1518: x_return_status := FND_API.g_ret_sts_success;
1519:
1520: ------------------------ start -------------------------
1521: /*------------------------------------------------------------*
1522: | Update Claim Status to CLOSED.

Line 1531: IF l_return_status = FND_API.g_ret_sts_error THEN

1527: ,x_return_status => l_return_status
1528: ,x_msg_data => x_msg_data
1529: ,x_msg_count => x_msg_count
1530: );
1531: IF l_return_status = FND_API.g_ret_sts_error THEN
1532: RAISE FND_API.g_exc_error;
1533: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1534: RAISE FND_API.g_exc_unexpected_error;
1535: END IF;

Line 1532: RAISE FND_API.g_exc_error;

1528: ,x_msg_data => x_msg_data
1529: ,x_msg_count => x_msg_count
1530: );
1531: IF l_return_status = FND_API.g_ret_sts_error THEN
1532: RAISE FND_API.g_exc_error;
1533: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1534: RAISE FND_API.g_exc_unexpected_error;
1535: END IF;
1536: */

Line 1533: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1529: ,x_msg_count => x_msg_count
1530: );
1531: IF l_return_status = FND_API.g_ret_sts_error THEN
1532: RAISE FND_API.g_exc_error;
1533: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1534: RAISE FND_API.g_exc_unexpected_error;
1535: END IF;
1536: */
1537:

Line 1534: RAISE FND_API.g_exc_unexpected_error;

1530: );
1531: IF l_return_status = FND_API.g_ret_sts_error THEN
1532: RAISE FND_API.g_exc_error;
1533: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1534: RAISE FND_API.g_exc_unexpected_error;
1535: END IF;
1536: */
1537:
1538: IF p_deduction_type = 'RECEIPT_OPM' THEN

Line 1560: IF l_return_status = FND_API.g_ret_sts_error THEN

1556: ,x_return_status => l_return_status
1557: ,x_msg_data => x_msg_data
1558: ,x_msg_count => x_msg_count
1559: );
1560: IF l_return_status = FND_API.g_ret_sts_error THEN
1561: RAISE FND_API.g_exc_error;
1562: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1563: RAISE FND_API.g_exc_unexpected_error;
1564: END IF;

Line 1561: RAISE FND_API.g_exc_error;

1557: ,x_msg_data => x_msg_data
1558: ,x_msg_count => x_msg_count
1559: );
1560: IF l_return_status = FND_API.g_ret_sts_error THEN
1561: RAISE FND_API.g_exc_error;
1562: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1563: RAISE FND_API.g_exc_unexpected_error;
1564: END IF;
1565:

Line 1562: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1558: ,x_msg_count => x_msg_count
1559: );
1560: IF l_return_status = FND_API.g_ret_sts_error THEN
1561: RAISE FND_API.g_exc_error;
1562: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1563: RAISE FND_API.g_exc_unexpected_error;
1564: END IF;
1565:
1566: IF OZF_DEBUG_HIGH_ON THEN

Line 1563: RAISE FND_API.g_exc_unexpected_error;

1559: );
1560: IF l_return_status = FND_API.g_ret_sts_error THEN
1561: RAISE FND_API.g_exc_error;
1562: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1563: RAISE FND_API.g_exc_unexpected_error;
1564: END IF;
1565:
1566: IF OZF_DEBUG_HIGH_ON THEN
1567: OZF_Utility_PVT.debug_message('Overpayment -> 2. Apply On Account Credit.');

Line 1577: IF l_return_status = FND_API.g_ret_sts_error THEN

1573: ,x_return_status => l_return_status
1574: ,x_msg_data => x_msg_data
1575: ,x_msg_count => x_msg_count
1576: );
1577: IF l_return_status = FND_API.g_ret_sts_error THEN
1578: RAISE FND_API.g_exc_error;
1579: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1580: RAISE FND_API.g_exc_unexpected_error;
1581: END IF;

Line 1578: RAISE FND_API.g_exc_error;

1574: ,x_msg_data => x_msg_data
1575: ,x_msg_count => x_msg_count
1576: );
1577: IF l_return_status = FND_API.g_ret_sts_error THEN
1578: RAISE FND_API.g_exc_error;
1579: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1580: RAISE FND_API.g_exc_unexpected_error;
1581: END IF;
1582:

Line 1579: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1575: ,x_msg_count => x_msg_count
1576: );
1577: IF l_return_status = FND_API.g_ret_sts_error THEN
1578: RAISE FND_API.g_exc_error;
1579: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1580: RAISE FND_API.g_exc_unexpected_error;
1581: END IF;
1582:
1583: /*------------------------------------------------------------*

Line 1580: RAISE FND_API.g_exc_unexpected_error;

1576: );
1577: IF l_return_status = FND_API.g_ret_sts_error THEN
1578: RAISE FND_API.g_exc_error;
1579: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1580: RAISE FND_API.g_exc_unexpected_error;
1581: END IF;
1582:
1583: /*------------------------------------------------------------*
1584: | Update Deduction payment detail

Line 1592: ,p_init_msg_list => FND_API.g_false

1588: OZF_Utility_PVT.debug_message('cash_receipt_id = '||p_claim_rec.receipt_id);
1589: END IF;
1590: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1591: p_api_version => l_api_version
1592: ,p_init_msg_list => FND_API.g_false
1593: ,p_commit => FND_API.g_false
1594: ,p_validation_level => FND_API.g_valid_level_full
1595: ,x_return_status => l_return_status
1596: ,x_msg_data => x_msg_data

Line 1593: ,p_commit => FND_API.g_false

1589: END IF;
1590: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1591: p_api_version => l_api_version
1592: ,p_init_msg_list => FND_API.g_false
1593: ,p_commit => FND_API.g_false
1594: ,p_validation_level => FND_API.g_valid_level_full
1595: ,x_return_status => l_return_status
1596: ,x_msg_data => x_msg_data
1597: ,x_msg_count => x_msg_count

Line 1594: ,p_validation_level => FND_API.g_valid_level_full

1590: OZF_SETTLEMENT_DOC_PVT.Update_Payment_Detail(
1591: p_api_version => l_api_version
1592: ,p_init_msg_list => FND_API.g_false
1593: ,p_commit => FND_API.g_false
1594: ,p_validation_level => FND_API.g_valid_level_full
1595: ,x_return_status => l_return_status
1596: ,x_msg_data => x_msg_data
1597: ,x_msg_count => x_msg_count
1598: ,p_claim_id => p_claim_rec.claim_id

Line 1607: IF l_return_status = FND_API.g_ret_sts_error THEN

1603: ,p_adjust_id => NULL
1604: ,p_settlement_doc_id => p_settlement_doc_id
1605: ,p_settlement_mode => 'MASS_SETTLEMENT'
1606: );
1607: IF l_return_status = FND_API.g_ret_sts_error THEN
1608: RAISE FND_API.g_exc_error;
1609: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1610: RAISE FND_API.g_exc_unexpected_error;
1611: END IF;

Line 1608: RAISE FND_API.g_exc_error;

1604: ,p_settlement_doc_id => p_settlement_doc_id
1605: ,p_settlement_mode => 'MASS_SETTLEMENT'
1606: );
1607: IF l_return_status = FND_API.g_ret_sts_error THEN
1608: RAISE FND_API.g_exc_error;
1609: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1610: RAISE FND_API.g_exc_unexpected_error;
1611: END IF;
1612:

Line 1609: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1605: ,p_settlement_mode => 'MASS_SETTLEMENT'
1606: );
1607: IF l_return_status = FND_API.g_ret_sts_error THEN
1608: RAISE FND_API.g_exc_error;
1609: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1610: RAISE FND_API.g_exc_unexpected_error;
1611: END IF;
1612:
1613: ELSE

Line 1610: RAISE FND_API.g_exc_unexpected_error;

1606: );
1607: IF l_return_status = FND_API.g_ret_sts_error THEN
1608: RAISE FND_API.g_exc_error;
1609: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1610: RAISE FND_API.g_exc_unexpected_error;
1611: END IF;
1612:
1613: ELSE
1614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1618: RAISE FND_API.g_exc_error;

1614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1615: FND_MESSAGE.set_name('AMS', 'AMS_AR_PAYMENT_NOTMATCH');
1616: FND_MSG_PUB.add;
1617: END IF;
1618: RAISE FND_API.g_exc_error;
1619: END IF;
1620:
1621: IF OZF_DEBUG_HIGH_ON THEN
1622: OZF_Utility_PVT.debug_message(l_full_name||': end');

Line 1625: WHEN FND_API.g_exc_error THEN

1621: IF OZF_DEBUG_HIGH_ON THEN
1622: OZF_Utility_PVT.debug_message(l_full_name||': end');
1623: END IF;
1624: EXCEPTION
1625: WHEN FND_API.g_exc_error THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627:
1628: WHEN FND_API.g_exc_unexpected_error THEN
1629: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1626: x_return_status := FND_API.g_ret_sts_error;

1622: OZF_Utility_PVT.debug_message(l_full_name||': end');
1623: END IF;
1624: EXCEPTION
1625: WHEN FND_API.g_exc_error THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627:
1628: WHEN FND_API.g_exc_unexpected_error THEN
1629: x_return_status := FND_API.g_ret_sts_unexp_error ;
1630:

Line 1628: WHEN FND_API.g_exc_unexpected_error THEN

1624: EXCEPTION
1625: WHEN FND_API.g_exc_error THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627:
1628: WHEN FND_API.g_exc_unexpected_error THEN
1629: x_return_status := FND_API.g_ret_sts_unexp_error ;
1630:
1631: WHEN OTHERS THEN
1632: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1629: x_return_status := FND_API.g_ret_sts_unexp_error ;

1625: WHEN FND_API.g_exc_error THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627:
1628: WHEN FND_API.g_exc_unexpected_error THEN
1629: x_return_status := FND_API.g_ret_sts_unexp_error ;
1630:
1631: WHEN OTHERS THEN
1632: x_return_status := FND_API.g_ret_sts_unexp_error ;
1633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1632: x_return_status := FND_API.g_ret_sts_unexp_error ;

1628: WHEN FND_API.g_exc_unexpected_error THEN
1629: x_return_status := FND_API.g_ret_sts_unexp_error ;
1630:
1631: WHEN OTHERS THEN
1632: x_return_status := FND_API.g_ret_sts_unexp_error ;
1633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1634: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1635: END IF;
1636:

Line 1729: x_return_status := FND_API.G_RET_STS_SUCCESS;

1725: IF OZF_DEBUG_HIGH_ON THEN
1726: OZF_Utility_PVT.debug_message(l_full_name||': start');
1727: END IF;
1728:
1729: x_return_status := FND_API.G_RET_STS_SUCCESS;
1730:
1731: ------------------------ start -------------------------
1732: IF OZF_DEBUG_HIGH_ON THEN
1733: OZF_Utility_PVT.debug_message('Settlement Type = '||p_settlement_type);

Line 2054: ,p_init_msg_list => FND_API.g_false

2050: IF l_group_claim_line_tbl.COUNT IS NOT NULL AND
2051: l_group_claim_line_tbl.COUNT > 0 THEN
2052: OZF_Claim_Line_PVT.Create_Claim_Line_Tbl(
2053: p_api_version => l_api_version
2054: ,p_init_msg_list => FND_API.g_false
2055: ,p_commit => FND_API.g_false
2056: ,p_validation_level => FND_API.g_valid_level_full
2057: ,x_return_status => l_return_status
2058: ,x_msg_data => x_msg_data

Line 2055: ,p_commit => FND_API.g_false

2051: l_group_claim_line_tbl.COUNT > 0 THEN
2052: OZF_Claim_Line_PVT.Create_Claim_Line_Tbl(
2053: p_api_version => l_api_version
2054: ,p_init_msg_list => FND_API.g_false
2055: ,p_commit => FND_API.g_false
2056: ,p_validation_level => FND_API.g_valid_level_full
2057: ,x_return_status => l_return_status
2058: ,x_msg_data => x_msg_data
2059: ,x_msg_count => x_msg_count

Line 2056: ,p_validation_level => FND_API.g_valid_level_full

2052: OZF_Claim_Line_PVT.Create_Claim_Line_Tbl(
2053: p_api_version => l_api_version
2054: ,p_init_msg_list => FND_API.g_false
2055: ,p_commit => FND_API.g_false
2056: ,p_validation_level => FND_API.g_valid_level_full
2057: ,x_return_status => l_return_status
2058: ,x_msg_data => x_msg_data
2059: ,x_msg_count => x_msg_count
2060: ,p_claim_line_tbl => l_group_claim_line_tbl

Line 2064: IF l_return_status = FND_API.g_ret_sts_error THEN

2060: ,p_claim_line_tbl => l_group_claim_line_tbl
2061: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2062: ,x_error_index => l_err_idx
2063: );
2064: IF l_return_status = FND_API.g_ret_sts_error THEN
2065: RAISE FND_API.g_exc_error;
2066: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2067: RAISE FND_API.g_exc_unexpected_error;
2068: END IF;

Line 2065: RAISE FND_API.g_exc_error;

2061: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2062: ,x_error_index => l_err_idx
2063: );
2064: IF l_return_status = FND_API.g_ret_sts_error THEN
2065: RAISE FND_API.g_exc_error;
2066: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2067: RAISE FND_API.g_exc_unexpected_error;
2068: END IF;
2069: END IF;

Line 2066: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2062: ,x_error_index => l_err_idx
2063: );
2064: IF l_return_status = FND_API.g_ret_sts_error THEN
2065: RAISE FND_API.g_exc_error;
2066: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2067: RAISE FND_API.g_exc_unexpected_error;
2068: END IF;
2069: END IF;
2070:

Line 2067: RAISE FND_API.g_exc_unexpected_error;

2063: );
2064: IF l_return_status = FND_API.g_ret_sts_error THEN
2065: RAISE FND_API.g_exc_error;
2066: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2067: RAISE FND_API.g_exc_unexpected_error;
2068: END IF;
2069: END IF;
2070:
2071:

Line 2114: p_init_msg_list => FND_API.G_FALSE,

2110: IF l_settle_doc_tbl.COUNT IS NOT NULL AND
2111: l_settle_doc_tbl.COUNT > 0 THEN
2112: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2113: p_api_version_number => l_api_version,
2114: p_init_msg_list => FND_API.G_FALSE,
2115: p_commit => FND_API.G_FALSE,
2116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status => l_return_status,
2118: x_msg_count => x_msg_count,

Line 2115: p_commit => FND_API.G_FALSE,

2111: l_settle_doc_tbl.COUNT > 0 THEN
2112: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2113: p_api_version_number => l_api_version,
2114: p_init_msg_list => FND_API.G_FALSE,
2115: p_commit => FND_API.G_FALSE,
2116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status => l_return_status,
2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data,

Line 2116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2112: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2113: p_api_version_number => l_api_version,
2114: p_init_msg_list => FND_API.G_FALSE,
2115: p_commit => FND_API.G_FALSE,
2116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status => l_return_status,
2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data,
2120: p_settlement_doc_tbl => l_settle_doc_tbl,

Line 2123: IF l_return_status = FND_API.g_ret_sts_error THEN

2119: x_msg_data => x_msg_data,
2120: p_settlement_doc_tbl => l_settle_doc_tbl,
2121: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2122: );
2123: IF l_return_status = FND_API.g_ret_sts_error THEN
2124: RAISE FND_API.g_exc_error;
2125: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;

Line 2124: RAISE FND_API.g_exc_error;

2120: p_settlement_doc_tbl => l_settle_doc_tbl,
2121: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2122: );
2123: IF l_return_status = FND_API.g_ret_sts_error THEN
2124: RAISE FND_API.g_exc_error;
2125: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;

Line 2125: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2121: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2122: );
2123: IF l_return_status = FND_API.g_ret_sts_error THEN
2124: RAISE FND_API.g_exc_error;
2125: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;
2129:

Line 2126: RAISE FND_API.g_exc_unexpected_error;

2122: );
2123: IF l_return_status = FND_API.g_ret_sts_error THEN
2124: RAISE FND_API.g_exc_error;
2125: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;
2129:
2130: IF l_settle_doc_tbl2.COUNT IS NOT NULL AND

Line 2134: p_init_msg_list => FND_API.G_FALSE,

2130: IF l_settle_doc_tbl2.COUNT IS NOT NULL AND
2131: l_settle_doc_tbl2.COUNT > 0 THEN
2132: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2133: p_api_version_number => l_api_version,
2134: p_init_msg_list => FND_API.G_FALSE,
2135: p_commit => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: x_return_status => l_return_status,
2138: x_msg_count => x_msg_count,

Line 2135: p_commit => FND_API.G_FALSE,

2131: l_settle_doc_tbl2.COUNT > 0 THEN
2132: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2133: p_api_version_number => l_api_version,
2134: p_init_msg_list => FND_API.G_FALSE,
2135: p_commit => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: x_return_status => l_return_status,
2138: x_msg_count => x_msg_count,
2139: x_msg_data => x_msg_data,

Line 2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2132: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
2133: p_api_version_number => l_api_version,
2134: p_init_msg_list => FND_API.G_FALSE,
2135: p_commit => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: x_return_status => l_return_status,
2138: x_msg_count => x_msg_count,
2139: x_msg_data => x_msg_data,
2140: p_settlement_doc_tbl => l_settle_doc_tbl2,

Line 2143: IF l_return_status = FND_API.g_ret_sts_error THEN

2139: x_msg_data => x_msg_data,
2140: p_settlement_doc_tbl => l_settle_doc_tbl2,
2141: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2142: );
2143: IF l_return_status = FND_API.g_ret_sts_error THEN
2144: RAISE FND_API.g_exc_error;
2145: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2146: RAISE FND_API.g_exc_unexpected_error;
2147: END IF;

Line 2144: RAISE FND_API.g_exc_error;

2140: p_settlement_doc_tbl => l_settle_doc_tbl2,
2141: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2142: );
2143: IF l_return_status = FND_API.g_ret_sts_error THEN
2144: RAISE FND_API.g_exc_error;
2145: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2146: RAISE FND_API.g_exc_unexpected_error;
2147: END IF;
2148: END IF;

Line 2145: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2141: x_settlement_doc_id_tbl => l_settle_doc_id_tbl
2142: );
2143: IF l_return_status = FND_API.g_ret_sts_error THEN
2144: RAISE FND_API.g_exc_error;
2145: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2146: RAISE FND_API.g_exc_unexpected_error;
2147: END IF;
2148: END IF;
2149:

Line 2146: RAISE FND_API.g_exc_unexpected_error;

2142: );
2143: IF l_return_status = FND_API.g_ret_sts_error THEN
2144: RAISE FND_API.g_exc_error;
2145: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2146: RAISE FND_API.g_exc_unexpected_error;
2147: END IF;
2148: END IF;
2149:
2150: IF OZF_DEBUG_HIGH_ON THEN

Line 2155: WHEN FND_API.g_exc_error THEN

2151: OZF_Utility_PVT.debug_message(l_full_name||': end');
2152: END IF;
2153:
2154: EXCEPTION
2155: WHEN FND_API.g_exc_error THEN
2156: ROLLBACK TO Break_Mass_Settlement;
2157: x_return_status := FND_API.g_ret_sts_error;
2158: FND_MSG_PUB.count_and_get (
2159: p_encoded => FND_API.g_false

Line 2157: x_return_status := FND_API.g_ret_sts_error;

2153:
2154: EXCEPTION
2155: WHEN FND_API.g_exc_error THEN
2156: ROLLBACK TO Break_Mass_Settlement;
2157: x_return_status := FND_API.g_ret_sts_error;
2158: FND_MSG_PUB.count_and_get (
2159: p_encoded => FND_API.g_false
2160: ,p_count => x_msg_count
2161: ,p_data => x_msg_data

Line 2159: p_encoded => FND_API.g_false

2155: WHEN FND_API.g_exc_error THEN
2156: ROLLBACK TO Break_Mass_Settlement;
2157: x_return_status := FND_API.g_ret_sts_error;
2158: FND_MSG_PUB.count_and_get (
2159: p_encoded => FND_API.g_false
2160: ,p_count => x_msg_count
2161: ,p_data => x_msg_data
2162: );
2163:

Line 2164: WHEN FND_API.g_exc_unexpected_error THEN

2160: ,p_count => x_msg_count
2161: ,p_data => x_msg_data
2162: );
2163:
2164: WHEN FND_API.g_exc_unexpected_error THEN
2165: ROLLBACK TO Break_Mass_Settlement;
2166: x_return_status := FND_API.g_ret_sts_unexp_error ;
2167: FND_MSG_PUB.count_and_get (
2168: p_encoded => FND_API.g_false

Line 2166: x_return_status := FND_API.g_ret_sts_unexp_error ;

2162: );
2163:
2164: WHEN FND_API.g_exc_unexpected_error THEN
2165: ROLLBACK TO Break_Mass_Settlement;
2166: x_return_status := FND_API.g_ret_sts_unexp_error ;
2167: FND_MSG_PUB.count_and_get (
2168: p_encoded => FND_API.g_false
2169: ,p_count => x_msg_count
2170: ,p_data => x_msg_data

Line 2168: p_encoded => FND_API.g_false

2164: WHEN FND_API.g_exc_unexpected_error THEN
2165: ROLLBACK TO Break_Mass_Settlement;
2166: x_return_status := FND_API.g_ret_sts_unexp_error ;
2167: FND_MSG_PUB.count_and_get (
2168: p_encoded => FND_API.g_false
2169: ,p_count => x_msg_count
2170: ,p_data => x_msg_data
2171: );
2172:

Line 2175: x_return_status := FND_API.g_ret_sts_unexp_error ;

2171: );
2172:
2173: WHEN OTHERS THEN
2174: ROLLBACK TO Break_Mass_Settlement;
2175: x_return_status := FND_API.g_ret_sts_unexp_error ;
2176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2177: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2178: END IF;
2179: FND_MSG_PUB.count_and_get(

Line 2180: p_encoded => FND_API.g_false

2176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2177: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2178: END IF;
2179: FND_MSG_PUB.count_and_get(
2180: p_encoded => FND_API.g_false
2181: ,p_count => x_msg_count
2182: ,p_data => x_msg_data
2183: );
2184:

Line 2238: x_return_status := FND_API.G_RET_STS_SUCCESS;

2234: IF OZF_DEBUG_HIGH_ON THEN
2235: OZF_Utility_PVT.debug_message(l_full_name||': start');
2236: END IF;
2237:
2238: x_return_status := FND_API.G_RET_STS_SUCCESS;
2239:
2240: ------------------------ start -------------------------
2241:
2242: OPEN csr_sysparam_defaults;

Line 2280: ,p_init_msg_list => FND_API.G_FALSE

2276: END IF;
2277:
2278: OZF_Claim_PVT.Update_Claim (
2279: p_api_version => l_api_version
2280: ,p_init_msg_list => FND_API.G_FALSE
2281: ,p_commit => FND_API.G_FALSE
2282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2283: ,x_return_status => l_return_status
2284: ,x_msg_data => x_msg_data

Line 2281: ,p_commit => FND_API.G_FALSE

2277:
2278: OZF_Claim_PVT.Update_Claim (
2279: p_api_version => l_api_version
2280: ,p_init_msg_list => FND_API.G_FALSE
2281: ,p_commit => FND_API.G_FALSE
2282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2283: ,x_return_status => l_return_status
2284: ,x_msg_data => x_msg_data
2285: ,x_msg_count => x_msg_count

Line 2282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2278: OZF_Claim_PVT.Update_Claim (
2279: p_api_version => l_api_version
2280: ,p_init_msg_list => FND_API.G_FALSE
2281: ,p_commit => FND_API.G_FALSE
2282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2283: ,x_return_status => l_return_status
2284: ,x_msg_data => x_msg_data
2285: ,x_msg_count => x_msg_count
2286: ,p_claim => x_claim_tbl(i)

Line 2291: IF l_return_status = FND_API.g_ret_sts_error THEN

2287: ,p_event => 'UPDATE'
2288: ,p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE
2289: ,x_object_version_number => l_claim_obj_ver_num
2290: );
2291: IF l_return_status = FND_API.g_ret_sts_error THEN
2292: RAISE FND_API.g_exc_error;
2293: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2294: RAISE FND_API.g_exc_unexpected_error;
2295: END IF;

Line 2292: RAISE FND_API.g_exc_error;

2288: ,p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE
2289: ,x_object_version_number => l_claim_obj_ver_num
2290: );
2291: IF l_return_status = FND_API.g_ret_sts_error THEN
2292: RAISE FND_API.g_exc_error;
2293: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2294: RAISE FND_API.g_exc_unexpected_error;
2295: END IF;
2296: x_claim_tbl(i).object_version_number := l_claim_obj_ver_num;

Line 2293: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2289: ,x_object_version_number => l_claim_obj_ver_num
2290: );
2291: IF l_return_status = FND_API.g_ret_sts_error THEN
2292: RAISE FND_API.g_exc_error;
2293: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2294: RAISE FND_API.g_exc_unexpected_error;
2295: END IF;
2296: x_claim_tbl(i).object_version_number := l_claim_obj_ver_num;
2297: EXIT WHEN i = x_claim_tbl.LAST;

Line 2294: RAISE FND_API.g_exc_unexpected_error;

2290: );
2291: IF l_return_status = FND_API.g_ret_sts_error THEN
2292: RAISE FND_API.g_exc_error;
2293: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2294: RAISE FND_API.g_exc_unexpected_error;
2295: END IF;
2296: x_claim_tbl(i).object_version_number := l_claim_obj_ver_num;
2297: EXIT WHEN i = x_claim_tbl.LAST;
2298: i := x_claim_tbl.NEXT(i);

Line 2307: WHEN FND_API.g_exc_error THEN

2303: OZF_Utility_PVT.debug_message(l_full_name||': end');
2304: END IF;
2305:
2306: EXCEPTION
2307: WHEN FND_API.g_exc_error THEN
2308: ROLLBACK TO Complete_Mass_Settlement;
2309: x_return_status := FND_API.g_ret_sts_error;
2310: FND_MSG_PUB.count_and_get (
2311: p_encoded => FND_API.g_false

Line 2309: x_return_status := FND_API.g_ret_sts_error;

2305:
2306: EXCEPTION
2307: WHEN FND_API.g_exc_error THEN
2308: ROLLBACK TO Complete_Mass_Settlement;
2309: x_return_status := FND_API.g_ret_sts_error;
2310: FND_MSG_PUB.count_and_get (
2311: p_encoded => FND_API.g_false
2312: ,p_count => x_msg_count
2313: ,p_data => x_msg_data

Line 2311: p_encoded => FND_API.g_false

2307: WHEN FND_API.g_exc_error THEN
2308: ROLLBACK TO Complete_Mass_Settlement;
2309: x_return_status := FND_API.g_ret_sts_error;
2310: FND_MSG_PUB.count_and_get (
2311: p_encoded => FND_API.g_false
2312: ,p_count => x_msg_count
2313: ,p_data => x_msg_data
2314: );
2315:

Line 2316: WHEN FND_API.g_exc_unexpected_error THEN

2312: ,p_count => x_msg_count
2313: ,p_data => x_msg_data
2314: );
2315:
2316: WHEN FND_API.g_exc_unexpected_error THEN
2317: ROLLBACK TO Complete_Mass_Settlement;
2318: x_return_status := FND_API.g_ret_sts_unexp_error ;
2319: FND_MSG_PUB.count_and_get (
2320: p_encoded => FND_API.g_false

Line 2318: x_return_status := FND_API.g_ret_sts_unexp_error ;

2314: );
2315:
2316: WHEN FND_API.g_exc_unexpected_error THEN
2317: ROLLBACK TO Complete_Mass_Settlement;
2318: x_return_status := FND_API.g_ret_sts_unexp_error ;
2319: FND_MSG_PUB.count_and_get (
2320: p_encoded => FND_API.g_false
2321: ,p_count => x_msg_count
2322: ,p_data => x_msg_data

Line 2320: p_encoded => FND_API.g_false

2316: WHEN FND_API.g_exc_unexpected_error THEN
2317: ROLLBACK TO Complete_Mass_Settlement;
2318: x_return_status := FND_API.g_ret_sts_unexp_error ;
2319: FND_MSG_PUB.count_and_get (
2320: p_encoded => FND_API.g_false
2321: ,p_count => x_msg_count
2322: ,p_data => x_msg_data
2323: );
2324:

Line 2327: x_return_status := FND_API.g_ret_sts_unexp_error ;

2323: );
2324:
2325: WHEN OTHERS THEN
2326: ROLLBACK TO Complete_Mass_Settlement;
2327: x_return_status := FND_API.g_ret_sts_unexp_error ;
2328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2330: END IF;
2331: FND_MSG_PUB.count_and_get(

Line 2332: p_encoded => FND_API.g_false

2328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2330: END IF;
2331: FND_MSG_PUB.count_and_get(
2332: p_encoded => FND_API.g_false
2333: ,p_count => x_msg_count
2334: ,p_data => x_msg_data
2335: );
2336:

Line 2411: x_return_status := FND_API.G_RET_STS_SUCCESS;

2407: IF OZF_DEBUG_HIGH_ON THEN
2408: OZF_Utility_PVT.debug_message(l_full_name||': start');
2409: END IF;
2410:
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412:
2413: ------------------------ start -------------------------
2414:
2415: OPEN csr_mass_setl_appr_req;

Line 2435: ,p_init_msg_list => FND_API.G_FALSE

2431: l_claim_pvt_rec.status_code := 'PENDING_APPROVAL';
2432:
2433: OZF_Claim_PVT.Update_Claim (
2434: p_api_version => l_api_version
2435: ,p_init_msg_list => FND_API.G_FALSE
2436: ,p_commit => FND_API.G_FALSE
2437: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2438: ,x_return_status => l_return_status
2439: ,x_msg_data => x_msg_data

Line 2436: ,p_commit => FND_API.G_FALSE

2432:
2433: OZF_Claim_PVT.Update_Claim (
2434: p_api_version => l_api_version
2435: ,p_init_msg_list => FND_API.G_FALSE
2436: ,p_commit => FND_API.G_FALSE
2437: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2438: ,x_return_status => l_return_status
2439: ,x_msg_data => x_msg_data
2440: ,x_msg_count => x_msg_count

Line 2437: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2433: OZF_Claim_PVT.Update_Claim (
2434: p_api_version => l_api_version
2435: ,p_init_msg_list => FND_API.G_FALSE
2436: ,p_commit => FND_API.G_FALSE
2437: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2438: ,x_return_status => l_return_status
2439: ,x_msg_data => x_msg_data
2440: ,x_msg_count => x_msg_count
2441: ,p_claim => l_claim_pvt_rec --l_complete_claim_group_tbl(i)

Line 2446: IF l_return_status = FND_API.g_ret_sts_error THEN

2442: ,p_event => 'UPDATE'
2443: ,p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE
2444: ,x_object_version_number => l_claim_obj_ver_num
2445: );
2446: IF l_return_status = FND_API.g_ret_sts_error THEN
2447: RAISE FND_API.g_exc_error;
2448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2449: RAISE FND_API.g_exc_unexpected_error;
2450: END IF;

Line 2447: RAISE FND_API.g_exc_error;

2443: ,p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE
2444: ,x_object_version_number => l_claim_obj_ver_num
2445: );
2446: IF l_return_status = FND_API.g_ret_sts_error THEN
2447: RAISE FND_API.g_exc_error;
2448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2449: RAISE FND_API.g_exc_unexpected_error;
2450: END IF;
2451: EXIT WHEN i = p_complete_claim_group_tbl.LAST;

Line 2448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2444: ,x_object_version_number => l_claim_obj_ver_num
2445: );
2446: IF l_return_status = FND_API.g_ret_sts_error THEN
2447: RAISE FND_API.g_exc_error;
2448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2449: RAISE FND_API.g_exc_unexpected_error;
2450: END IF;
2451: EXIT WHEN i = p_complete_claim_group_tbl.LAST;
2452: i := p_complete_claim_group_tbl.NEXT(i);

Line 2449: RAISE FND_API.g_exc_unexpected_error;

2445: );
2446: IF l_return_status = FND_API.g_ret_sts_error THEN
2447: RAISE FND_API.g_exc_error;
2448: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2449: RAISE FND_API.g_exc_unexpected_error;
2450: END IF;
2451: EXIT WHEN i = p_complete_claim_group_tbl.LAST;
2452: i := p_complete_claim_group_tbl.NEXT(i);
2453: END LOOP;

Line 2505: IF l_return_status = FND_API.g_ret_sts_error THEN

2501: ,p_notes_from_requester => null
2502: ,p_workflowprocess => 'AMSGAPP'
2503: ,p_item_type => 'AMSGAPP'
2504: );
2505: IF l_return_status = FND_API.g_ret_sts_error THEN
2506: RAISE FND_API.g_exc_error;
2507: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2508: RAISE FND_API.g_exc_unexpected_error;
2509: END IF;

Line 2506: RAISE FND_API.g_exc_error;

2502: ,p_workflowprocess => 'AMSGAPP'
2503: ,p_item_type => 'AMSGAPP'
2504: );
2505: IF l_return_status = FND_API.g_ret_sts_error THEN
2506: RAISE FND_API.g_exc_error;
2507: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2508: RAISE FND_API.g_exc_unexpected_error;
2509: END IF;
2510:

Line 2507: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2503: ,p_item_type => 'AMSGAPP'
2504: );
2505: IF l_return_status = FND_API.g_ret_sts_error THEN
2506: RAISE FND_API.g_exc_error;
2507: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2508: RAISE FND_API.g_exc_unexpected_error;
2509: END IF;
2510:
2511: --//Commented by BKUNJAN Bug#5686706

Line 2508: RAISE FND_API.g_exc_unexpected_error;

2504: );
2505: IF l_return_status = FND_API.g_ret_sts_error THEN
2506: RAISE FND_API.g_exc_error;
2507: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2508: RAISE FND_API.g_exc_unexpected_error;
2509: END IF;
2510:
2511: --//Commented by BKUNJAN Bug#5686706
2512: /*

Line 2532: WHEN FND_API.g_exc_error THEN

2528: END IF;
2529:
2530:
2531: EXCEPTION
2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO Approve_Mass_Settlement;
2534: x_return_status := FND_API.g_ret_sts_error;
2535: FND_MSG_PUB.count_and_get (
2536: p_encoded => FND_API.g_false

Line 2534: x_return_status := FND_API.g_ret_sts_error;

2530:
2531: EXCEPTION
2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO Approve_Mass_Settlement;
2534: x_return_status := FND_API.g_ret_sts_error;
2535: FND_MSG_PUB.count_and_get (
2536: p_encoded => FND_API.g_false
2537: ,p_count => x_msg_count
2538: ,p_data => x_msg_data

Line 2536: p_encoded => FND_API.g_false

2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO Approve_Mass_Settlement;
2534: x_return_status := FND_API.g_ret_sts_error;
2535: FND_MSG_PUB.count_and_get (
2536: p_encoded => FND_API.g_false
2537: ,p_count => x_msg_count
2538: ,p_data => x_msg_data
2539: );
2540:

Line 2541: WHEN FND_API.g_exc_unexpected_error THEN

2537: ,p_count => x_msg_count
2538: ,p_data => x_msg_data
2539: );
2540:
2541: WHEN FND_API.g_exc_unexpected_error THEN
2542: ROLLBACK TO Approve_Mass_Settlement;
2543: x_return_status := FND_API.g_ret_sts_unexp_error ;
2544: FND_MSG_PUB.count_and_get (
2545: p_encoded => FND_API.g_false

Line 2543: x_return_status := FND_API.g_ret_sts_unexp_error ;

2539: );
2540:
2541: WHEN FND_API.g_exc_unexpected_error THEN
2542: ROLLBACK TO Approve_Mass_Settlement;
2543: x_return_status := FND_API.g_ret_sts_unexp_error ;
2544: FND_MSG_PUB.count_and_get (
2545: p_encoded => FND_API.g_false
2546: ,p_count => x_msg_count
2547: ,p_data => x_msg_data

Line 2545: p_encoded => FND_API.g_false

2541: WHEN FND_API.g_exc_unexpected_error THEN
2542: ROLLBACK TO Approve_Mass_Settlement;
2543: x_return_status := FND_API.g_ret_sts_unexp_error ;
2544: FND_MSG_PUB.count_and_get (
2545: p_encoded => FND_API.g_false
2546: ,p_count => x_msg_count
2547: ,p_data => x_msg_data
2548: );
2549:

Line 2552: x_return_status := FND_API.g_ret_sts_unexp_error ;

2548: );
2549:
2550: WHEN OTHERS THEN
2551: ROLLBACK TO Approve_Mass_Settlement;
2552: x_return_status := FND_API.g_ret_sts_unexp_error ;
2553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2554: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2555: END IF;
2556: FND_MSG_PUB.count_and_get(

Line 2557: p_encoded => FND_API.g_false

2553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2554: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2555: END IF;
2556: FND_MSG_PUB.count_and_get(
2557: p_encoded => FND_API.g_false
2558: ,p_count => x_msg_count
2559: ,p_data => x_msg_data
2560: );
2561:

Line 2643: RAISE FND_API.g_exc_unexpected_error;

2639: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2640: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2641: FND_MSG_PUB.Add;
2642: END IF;
2643: RAISE FND_API.g_exc_unexpected_error;
2644: END;
2645:
2646: IF OZF_DEBUG_HIGH_ON THEN
2647: OZF_Utility_PVT.debug_message(l_full_name||': end');

Line 2651: WHEN FND_API.g_exc_error THEN

2647: OZF_Utility_PVT.debug_message(l_full_name||': end');
2648: END IF;
2649:
2650: EXCEPTION
2651: WHEN FND_API.g_exc_error THEN
2652: x_return_status := FND_API.g_ret_sts_error;
2653: FND_MSG_PUB.count_and_get (
2654: p_encoded => FND_API.g_false
2655: ,p_count => x_msg_count

Line 2652: x_return_status := FND_API.g_ret_sts_error;

2648: END IF;
2649:
2650: EXCEPTION
2651: WHEN FND_API.g_exc_error THEN
2652: x_return_status := FND_API.g_ret_sts_error;
2653: FND_MSG_PUB.count_and_get (
2654: p_encoded => FND_API.g_false
2655: ,p_count => x_msg_count
2656: ,p_data => x_msg_data

Line 2654: p_encoded => FND_API.g_false

2650: EXCEPTION
2651: WHEN FND_API.g_exc_error THEN
2652: x_return_status := FND_API.g_ret_sts_error;
2653: FND_MSG_PUB.count_and_get (
2654: p_encoded => FND_API.g_false
2655: ,p_count => x_msg_count
2656: ,p_data => x_msg_data
2657: );
2658:

Line 2659: WHEN FND_API.g_exc_unexpected_error THEN

2655: ,p_count => x_msg_count
2656: ,p_data => x_msg_data
2657: );
2658:
2659: WHEN FND_API.g_exc_unexpected_error THEN
2660: x_return_status := FND_API.g_ret_sts_unexp_error ;
2661: FND_MSG_PUB.count_and_get (
2662: p_encoded => FND_API.g_false
2663: ,p_count => x_msg_count

Line 2660: x_return_status := FND_API.g_ret_sts_unexp_error ;

2656: ,p_data => x_msg_data
2657: );
2658:
2659: WHEN FND_API.g_exc_unexpected_error THEN
2660: x_return_status := FND_API.g_ret_sts_unexp_error ;
2661: FND_MSG_PUB.count_and_get (
2662: p_encoded => FND_API.g_false
2663: ,p_count => x_msg_count
2664: ,p_data => x_msg_data

Line 2662: p_encoded => FND_API.g_false

2658:
2659: WHEN FND_API.g_exc_unexpected_error THEN
2660: x_return_status := FND_API.g_ret_sts_unexp_error ;
2661: FND_MSG_PUB.count_and_get (
2662: p_encoded => FND_API.g_false
2663: ,p_count => x_msg_count
2664: ,p_data => x_msg_data
2665: );
2666:

Line 2668: x_return_status := FND_API.g_ret_sts_unexp_error ;

2664: ,p_data => x_msg_data
2665: );
2666:
2667: WHEN OTHERS THEN
2668: x_return_status := FND_API.g_ret_sts_unexp_error ;
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2670: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2671: END IF;
2672: FND_MSG_PUB.count_and_get(

Line 2673: p_encoded => FND_API.g_false

2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2670: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2671: END IF;
2672: FND_MSG_PUB.count_and_get(
2673: p_encoded => FND_API.g_false
2674: ,p_count => x_msg_count
2675: ,p_data => x_msg_data
2676: );
2677:

Line 2767: x_return_status := FND_API.G_RET_STS_SUCCESS;

2763: IF OZF_DEBUG_HIGH_ON THEN
2764: OZF_Utility_PVT.debug_message(l_full_name||': start');
2765: END IF;
2766:
2767: x_return_status := FND_API.G_RET_STS_SUCCESS;
2768:
2769: ------------------------ start -------------------------
2770: OPEN csr_master_claim_lines(p_group_claim_id);
2771: LOOP

Line 2786: IF l_return_status = FND_API.g_ret_sts_error THEN

2782: p_claim_id => l_claim_id_tbl(i)
2783: ,x_claim_rec => l_claim_rec
2784: ,x_return_status => l_return_status
2785: );
2786: IF l_return_status = FND_API.g_ret_sts_error THEN
2787: RAISE FND_API.g_exc_error;
2788: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2789: RAISE FND_API.g_exc_unexpected_error;
2790: END IF;

Line 2787: RAISE FND_API.g_exc_error;

2783: ,x_claim_rec => l_claim_rec
2784: ,x_return_status => l_return_status
2785: );
2786: IF l_return_status = FND_API.g_ret_sts_error THEN
2787: RAISE FND_API.g_exc_error;
2788: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2789: RAISE FND_API.g_exc_unexpected_error;
2790: END IF;
2791:

Line 2788: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2784: ,x_return_status => l_return_status
2785: );
2786: IF l_return_status = FND_API.g_ret_sts_error THEN
2787: RAISE FND_API.g_exc_error;
2788: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2789: RAISE FND_API.g_exc_unexpected_error;
2790: END IF;
2791:
2792: -- Bug435194: Close claim before making payment

Line 2789: RAISE FND_API.g_exc_unexpected_error;

2785: );
2786: IF l_return_status = FND_API.g_ret_sts_error THEN
2787: RAISE FND_API.g_exc_error;
2788: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2789: RAISE FND_API.g_exc_unexpected_error;
2790: END IF;
2791:
2792: -- Bug435194: Close claim before making payment
2793: Close_Claim(

Line 2798: IF l_return_status = FND_API.g_ret_sts_error THEN

2794: p_group_claim_id => p_group_claim_id
2795: ,p_claim_id => l_claim_id_tbl(i)
2796: ,x_return_status => l_return_status
2797: );
2798: IF l_return_status = FND_API.g_ret_sts_error THEN
2799: RAISE FND_API.g_exc_error;
2800: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2801: RAISE FND_API.g_exc_unexpected_error;
2802: END IF;

Line 2799: RAISE FND_API.g_exc_error;

2795: ,p_claim_id => l_claim_id_tbl(i)
2796: ,x_return_status => l_return_status
2797: );
2798: IF l_return_status = FND_API.g_ret_sts_error THEN
2799: RAISE FND_API.g_exc_error;
2800: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2801: RAISE FND_API.g_exc_unexpected_error;
2802: END IF;
2803: --//Bugfix :8202109

Line 2800: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2796: ,x_return_status => l_return_status
2797: );
2798: IF l_return_status = FND_API.g_ret_sts_error THEN
2799: RAISE FND_API.g_exc_error;
2800: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2801: RAISE FND_API.g_exc_unexpected_error;
2802: END IF;
2803: --//Bugfix :8202109
2804: --//Populate History tables after Closing the Claim

Line 2801: RAISE FND_API.g_exc_unexpected_error;

2797: );
2798: IF l_return_status = FND_API.g_ret_sts_error THEN
2799: RAISE FND_API.g_exc_error;
2800: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2801: RAISE FND_API.g_exc_unexpected_error;
2802: END IF;
2803: --//Bugfix :8202109
2804: --//Populate History tables after Closing the Claim
2805: --===================

Line 2824: IF l_return_status = FND_API.g_ret_sts_error THEN

2820: x_needed_to_create => l_needed_to_create,
2821: x_return_status => l_return_status
2822: );
2823:
2824: IF l_return_status = FND_API.g_ret_sts_error THEN
2825: RAISE FND_API.g_exc_error;
2826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2827: RAISE FND_API.g_exc_unexpected_error;
2828: END IF;

Line 2825: RAISE FND_API.g_exc_error;

2821: x_return_status => l_return_status
2822: );
2823:
2824: IF l_return_status = FND_API.g_ret_sts_error THEN
2825: RAISE FND_API.g_exc_error;
2826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2827: RAISE FND_API.g_exc_unexpected_error;
2828: END IF;
2829:

Line 2826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2822: );
2823:
2824: IF l_return_status = FND_API.g_ret_sts_error THEN
2825: RAISE FND_API.g_exc_error;
2826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2827: RAISE FND_API.g_exc_unexpected_error;
2828: END IF;
2829:
2830: IF (l_needed_to_create = 'Y') THEN

Line 2827: RAISE FND_API.g_exc_unexpected_error;

2823:
2824: IF l_return_status = FND_API.g_ret_sts_error THEN
2825: RAISE FND_API.g_exc_error;
2826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2827: RAISE FND_API.g_exc_unexpected_error;
2828: END IF;
2829:
2830: IF (l_needed_to_create = 'Y') THEN
2831: -- CREATE history

Line 2839: IF l_return_status = FND_API.g_ret_sts_error THEN

2835: p_history_event_description => l_history_event_description,
2836: x_claim_history_id => l_claim_history_id,
2837: x_return_status => l_return_status
2838: );
2839: IF l_return_status = FND_API.g_ret_sts_error THEN
2840: RAISE FND_API.g_exc_error;
2841: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2842: RAISE FND_API.g_exc_unexpected_error;
2843: END IF;

Line 2840: RAISE FND_API.g_exc_error;

2836: x_claim_history_id => l_claim_history_id,
2837: x_return_status => l_return_status
2838: );
2839: IF l_return_status = FND_API.g_ret_sts_error THEN
2840: RAISE FND_API.g_exc_error;
2841: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2842: RAISE FND_API.g_exc_unexpected_error;
2843: END IF;
2844: END IF;

Line 2841: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2837: x_return_status => l_return_status
2838: );
2839: IF l_return_status = FND_API.g_ret_sts_error THEN
2840: RAISE FND_API.g_exc_error;
2841: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2842: RAISE FND_API.g_exc_unexpected_error;
2843: END IF;
2844: END IF;
2845: END IF;

Line 2842: RAISE FND_API.g_exc_unexpected_error;

2838: );
2839: IF l_return_status = FND_API.g_ret_sts_error THEN
2840: RAISE FND_API.g_exc_error;
2841: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2842: RAISE FND_API.g_exc_unexpected_error;
2843: END IF;
2844: END IF;
2845: END IF;
2846: --//End

Line 2913: RAISE FND_API.g_exc_unexpected_error;

2909: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2910: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2911: FND_MSG_PUB.Add;
2912: END IF;
2913: RAISE FND_API.g_exc_unexpected_error;
2914: END;
2915:
2916: IF l_settlement_doc_tbl(j).payment_method = 'CREDIT_MEMO' THEN
2917: Pay_by_Credit_Memo(

Line 2927: IF l_return_status = FND_API.g_ret_sts_error THEN

2923: ,x_return_status => l_return_status
2924: ,x_msg_data => x_msg_data
2925: ,x_msg_count => x_msg_count
2926: );
2927: IF l_return_status = FND_API.g_ret_sts_error THEN
2928: RAISE FND_API.g_exc_error;
2929: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2930: RAISE FND_API.g_exc_unexpected_error;
2931: END IF;

Line 2928: RAISE FND_API.g_exc_error;

2924: ,x_msg_data => x_msg_data
2925: ,x_msg_count => x_msg_count
2926: );
2927: IF l_return_status = FND_API.g_ret_sts_error THEN
2928: RAISE FND_API.g_exc_error;
2929: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2930: RAISE FND_API.g_exc_unexpected_error;
2931: END IF;
2932:

Line 2929: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2925: ,x_msg_count => x_msg_count
2926: );
2927: IF l_return_status = FND_API.g_ret_sts_error THEN
2928: RAISE FND_API.g_exc_error;
2929: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2930: RAISE FND_API.g_exc_unexpected_error;
2931: END IF;
2932:
2933: ELSIF l_settlement_doc_tbl(j).payment_method = 'DEBIT_MEMO' THEN

Line 2930: RAISE FND_API.g_exc_unexpected_error;

2926: );
2927: IF l_return_status = FND_API.g_ret_sts_error THEN
2928: RAISE FND_API.g_exc_error;
2929: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2930: RAISE FND_API.g_exc_unexpected_error;
2931: END IF;
2932:
2933: ELSIF l_settlement_doc_tbl(j).payment_method = 'DEBIT_MEMO' THEN
2934: Pay_by_Debit_Memo(

Line 2944: IF l_return_status = FND_API.g_ret_sts_error THEN

2940: ,x_return_status => l_return_status
2941: ,x_msg_data => x_msg_data
2942: ,x_msg_count => x_msg_count
2943: );
2944: IF l_return_status = FND_API.g_ret_sts_error THEN
2945: RAISE FND_API.g_exc_error;
2946: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2947: RAISE FND_API.g_exc_unexpected_error;
2948: END IF;

Line 2945: RAISE FND_API.g_exc_error;

2941: ,x_msg_data => x_msg_data
2942: ,x_msg_count => x_msg_count
2943: );
2944: IF l_return_status = FND_API.g_ret_sts_error THEN
2945: RAISE FND_API.g_exc_error;
2946: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2947: RAISE FND_API.g_exc_unexpected_error;
2948: END IF;
2949:

Line 2946: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2942: ,x_msg_count => x_msg_count
2943: );
2944: IF l_return_status = FND_API.g_ret_sts_error THEN
2945: RAISE FND_API.g_exc_error;
2946: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2947: RAISE FND_API.g_exc_unexpected_error;
2948: END IF;
2949:
2950: ELSIF l_settlement_doc_tbl(j).payment_method = 'CHARGEBACK' THEN

Line 2947: RAISE FND_API.g_exc_unexpected_error;

2943: );
2944: IF l_return_status = FND_API.g_ret_sts_error THEN
2945: RAISE FND_API.g_exc_error;
2946: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2947: RAISE FND_API.g_exc_unexpected_error;
2948: END IF;
2949:
2950: ELSIF l_settlement_doc_tbl(j).payment_method = 'CHARGEBACK' THEN
2951: Pay_by_Chargeback(

Line 2961: IF l_return_status = FND_API.g_ret_sts_error THEN

2957: ,x_return_status => l_return_status
2958: ,x_msg_data => x_msg_data
2959: ,x_msg_count => x_msg_count
2960: );
2961: IF l_return_status = FND_API.g_ret_sts_error THEN
2962: RAISE FND_API.g_exc_error;
2963: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2964: RAISE FND_API.g_exc_unexpected_error;
2965: END IF;

Line 2962: RAISE FND_API.g_exc_error;

2958: ,x_msg_data => x_msg_data
2959: ,x_msg_count => x_msg_count
2960: );
2961: IF l_return_status = FND_API.g_ret_sts_error THEN
2962: RAISE FND_API.g_exc_error;
2963: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2964: RAISE FND_API.g_exc_unexpected_error;
2965: END IF;
2966:

Line 2963: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2959: ,x_msg_count => x_msg_count
2960: );
2961: IF l_return_status = FND_API.g_ret_sts_error THEN
2962: RAISE FND_API.g_exc_error;
2963: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2964: RAISE FND_API.g_exc_unexpected_error;
2965: END IF;
2966:
2967: ELSIF l_settlement_doc_tbl(j).payment_method = 'WRITE_OFF' THEN

Line 2964: RAISE FND_API.g_exc_unexpected_error;

2960: );
2961: IF l_return_status = FND_API.g_ret_sts_error THEN
2962: RAISE FND_API.g_exc_error;
2963: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2964: RAISE FND_API.g_exc_unexpected_error;
2965: END IF;
2966:
2967: ELSIF l_settlement_doc_tbl(j).payment_method = 'WRITE_OFF' THEN
2968: Pay_by_Write_Off(

Line 2979: IF l_return_status = FND_API.g_ret_sts_error THEN

2975: ,x_return_status => l_return_status
2976: ,x_msg_data => x_msg_data
2977: ,x_msg_count => x_msg_count
2978: );
2979: IF l_return_status = FND_API.g_ret_sts_error THEN
2980: RAISE FND_API.g_exc_error;
2981: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2982: RAISE FND_API.g_exc_unexpected_error;
2983: END IF;

Line 2980: RAISE FND_API.g_exc_error;

2976: ,x_msg_data => x_msg_data
2977: ,x_msg_count => x_msg_count
2978: );
2979: IF l_return_status = FND_API.g_ret_sts_error THEN
2980: RAISE FND_API.g_exc_error;
2981: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2982: RAISE FND_API.g_exc_unexpected_error;
2983: END IF;
2984:

Line 2981: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2977: ,x_msg_count => x_msg_count
2978: );
2979: IF l_return_status = FND_API.g_ret_sts_error THEN
2980: RAISE FND_API.g_exc_error;
2981: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2982: RAISE FND_API.g_exc_unexpected_error;
2983: END IF;
2984:
2985: ELSIF l_settlement_doc_tbl(j).payment_method = 'ON_ACCT_CREDIT' THEN

Line 2982: RAISE FND_API.g_exc_unexpected_error;

2978: );
2979: IF l_return_status = FND_API.g_ret_sts_error THEN
2980: RAISE FND_API.g_exc_error;
2981: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2982: RAISE FND_API.g_exc_unexpected_error;
2983: END IF;
2984:
2985: ELSIF l_settlement_doc_tbl(j).payment_method = 'ON_ACCT_CREDIT' THEN
2986: Pay_by_On_Account_Credit(

Line 2995: IF l_return_status = FND_API.g_ret_sts_error THEN

2991: ,x_return_status => l_return_status
2992: ,x_msg_data => x_msg_data
2993: ,x_msg_count => x_msg_count
2994: );
2995: IF l_return_status = FND_API.g_ret_sts_error THEN
2996: RAISE FND_API.g_exc_error;
2997: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF;

Line 2996: RAISE FND_API.g_exc_error;

2992: ,x_msg_data => x_msg_data
2993: ,x_msg_count => x_msg_count
2994: );
2995: IF l_return_status = FND_API.g_ret_sts_error THEN
2996: RAISE FND_API.g_exc_error;
2997: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF;
3000:

Line 2997: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2993: ,x_msg_count => x_msg_count
2994: );
2995: IF l_return_status = FND_API.g_ret_sts_error THEN
2996: RAISE FND_API.g_exc_error;
2997: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF;
3000:
3001: ELSIF l_settlement_doc_tbl(j).payment_method IN ('DEDUCTION', 'OVERPAYMENT') THEN

Line 2998: RAISE FND_API.g_exc_unexpected_error;

2994: );
2995: IF l_return_status = FND_API.g_ret_sts_error THEN
2996: RAISE FND_API.g_exc_error;
2997: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF;
3000:
3001: ELSIF l_settlement_doc_tbl(j).payment_method IN ('DEDUCTION', 'OVERPAYMENT') THEN
3002: Pay_by_Open_Receipt(

Line 3013: IF l_return_status = FND_API.g_ret_sts_error THEN

3009: ,x_return_status => l_return_status
3010: ,x_msg_data => x_msg_data
3011: ,x_msg_count => x_msg_count
3012: );
3013: IF l_return_status = FND_API.g_ret_sts_error THEN
3014: RAISE FND_API.g_exc_error;
3015: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3016: RAISE FND_API.g_exc_unexpected_error;
3017: END IF;

Line 3014: RAISE FND_API.g_exc_error;

3010: ,x_msg_data => x_msg_data
3011: ,x_msg_count => x_msg_count
3012: );
3013: IF l_return_status = FND_API.g_ret_sts_error THEN
3014: RAISE FND_API.g_exc_error;
3015: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3016: RAISE FND_API.g_exc_unexpected_error;
3017: END IF;
3018: --//Bugfix: 8202109

Line 3015: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3011: ,x_msg_count => x_msg_count
3012: );
3013: IF l_return_status = FND_API.g_ret_sts_error THEN
3014: RAISE FND_API.g_exc_error;
3015: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3016: RAISE FND_API.g_exc_unexpected_error;
3017: END IF;
3018: --//Bugfix: 8202109
3019: OPEN cur_current_status(l_settlement_doc_tbl(j).payment_reference_id);

Line 3016: RAISE FND_API.g_exc_unexpected_error;

3012: );
3013: IF l_return_status = FND_API.g_ret_sts_error THEN
3014: RAISE FND_API.g_exc_error;
3015: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3016: RAISE FND_API.g_exc_unexpected_error;
3017: END IF;
3018: --//Bugfix: 8202109
3019: OPEN cur_current_status(l_settlement_doc_tbl(j).payment_reference_id);
3020: FETCH cur_current_status INTO l_status_code,l_user_status_id;

Line 3029: IF l_return_status = FND_API.g_ret_sts_error THEN

3025: p_group_claim_id => p_group_claim_id
3026: ,p_claim_id => l_settlement_doc_tbl(j).payment_reference_id
3027: ,x_return_status => l_return_status
3028: );
3029: IF l_return_status = FND_API.g_ret_sts_error THEN
3030: RAISE FND_API.g_exc_error;
3031: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3032: RAISE FND_API.g_exc_unexpected_error;
3033: END IF;

Line 3030: RAISE FND_API.g_exc_error;

3026: ,p_claim_id => l_settlement_doc_tbl(j).payment_reference_id
3027: ,x_return_status => l_return_status
3028: );
3029: IF l_return_status = FND_API.g_ret_sts_error THEN
3030: RAISE FND_API.g_exc_error;
3031: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3032: RAISE FND_API.g_exc_unexpected_error;
3033: END IF;
3034:

Line 3031: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3027: ,x_return_status => l_return_status
3028: );
3029: IF l_return_status = FND_API.g_ret_sts_error THEN
3030: RAISE FND_API.g_exc_error;
3031: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3032: RAISE FND_API.g_exc_unexpected_error;
3033: END IF;
3034:
3035: --//Update Claim History

Line 3032: RAISE FND_API.g_exc_unexpected_error;

3028: );
3029: IF l_return_status = FND_API.g_ret_sts_error THEN
3030: RAISE FND_API.g_exc_error;
3031: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3032: RAISE FND_API.g_exc_unexpected_error;
3033: END IF;
3034:
3035: --//Update Claim History
3036: IF l_status_code <>'CLOSED' THEN

Line 3050: IF l_return_status = FND_API.g_ret_sts_error THEN

3046: x_needed_to_create => l_needed_to_create,
3047: x_return_status => l_return_status
3048: );
3049:
3050: IF l_return_status = FND_API.g_ret_sts_error THEN
3051: RAISE FND_API.g_exc_error;
3052: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3053: RAISE FND_API.g_exc_unexpected_error;
3054: END IF;

Line 3051: RAISE FND_API.g_exc_error;

3047: x_return_status => l_return_status
3048: );
3049:
3050: IF l_return_status = FND_API.g_ret_sts_error THEN
3051: RAISE FND_API.g_exc_error;
3052: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3053: RAISE FND_API.g_exc_unexpected_error;
3054: END IF;
3055:

Line 3052: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3048: );
3049:
3050: IF l_return_status = FND_API.g_ret_sts_error THEN
3051: RAISE FND_API.g_exc_error;
3052: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3053: RAISE FND_API.g_exc_unexpected_error;
3054: END IF;
3055:
3056: IF (l_needed_to_create = 'Y') THEN

Line 3053: RAISE FND_API.g_exc_unexpected_error;

3049:
3050: IF l_return_status = FND_API.g_ret_sts_error THEN
3051: RAISE FND_API.g_exc_error;
3052: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3053: RAISE FND_API.g_exc_unexpected_error;
3054: END IF;
3055:
3056: IF (l_needed_to_create = 'Y') THEN
3057: -- CREATE history

Line 3065: IF l_return_status = FND_API.g_ret_sts_error THEN

3061: p_history_event_description => l_history_event_description,
3062: x_claim_history_id => l_claim_history_id,
3063: x_return_status => l_return_status
3064: );
3065: IF l_return_status = FND_API.g_ret_sts_error THEN
3066: RAISE FND_API.g_exc_error;
3067: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3068: RAISE FND_API.g_exc_unexpected_error;
3069: END IF;

Line 3066: RAISE FND_API.g_exc_error;

3062: x_claim_history_id => l_claim_history_id,
3063: x_return_status => l_return_status
3064: );
3065: IF l_return_status = FND_API.g_ret_sts_error THEN
3066: RAISE FND_API.g_exc_error;
3067: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3068: RAISE FND_API.g_exc_unexpected_error;
3069: END IF;
3070: END IF;

Line 3067: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3063: x_return_status => l_return_status
3064: );
3065: IF l_return_status = FND_API.g_ret_sts_error THEN
3066: RAISE FND_API.g_exc_error;
3067: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3068: RAISE FND_API.g_exc_unexpected_error;
3069: END IF;
3070: END IF;
3071: END IF;

Line 3068: RAISE FND_API.g_exc_unexpected_error;

3064: );
3065: IF l_return_status = FND_API.g_ret_sts_error THEN
3066: RAISE FND_API.g_exc_error;
3067: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3068: RAISE FND_API.g_exc_unexpected_error;
3069: END IF;
3070: END IF;
3071: END IF;
3072: --//End

Line 3109: RAISE FND_API.g_exc_unexpected_error;

3105: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3106: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3107: FND_MSG_PUB.Add;
3108: END IF;
3109: RAISE FND_API.g_exc_unexpected_error;
3110: END;
3111:
3112: IF OZF_DEBUG_HIGH_ON THEN
3113: OZF_Utility_PVT.debug_message(l_full_name||': end');

Line 3117: WHEN FND_API.g_exc_error THEN

3113: OZF_Utility_PVT.debug_message(l_full_name||': end');
3114: END IF;
3115:
3116: EXCEPTION
3117: WHEN FND_API.g_exc_error THEN
3118: ROLLBACK TO Start_Mass_Payment;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: FND_MSG_PUB.count_and_get (
3121: p_encoded => FND_API.g_false

Line 3119: x_return_status := FND_API.g_ret_sts_error;

3115:
3116: EXCEPTION
3117: WHEN FND_API.g_exc_error THEN
3118: ROLLBACK TO Start_Mass_Payment;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: FND_MSG_PUB.count_and_get (
3121: p_encoded => FND_API.g_false
3122: ,p_count => x_msg_count
3123: ,p_data => x_msg_data

Line 3121: p_encoded => FND_API.g_false

3117: WHEN FND_API.g_exc_error THEN
3118: ROLLBACK TO Start_Mass_Payment;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: FND_MSG_PUB.count_and_get (
3121: p_encoded => FND_API.g_false
3122: ,p_count => x_msg_count
3123: ,p_data => x_msg_data
3124: );
3125:

Line 3126: WHEN FND_API.g_exc_unexpected_error THEN

3122: ,p_count => x_msg_count
3123: ,p_data => x_msg_data
3124: );
3125:
3126: WHEN FND_API.g_exc_unexpected_error THEN
3127: ROLLBACK TO Start_Mass_Payment;
3128: x_return_status := FND_API.g_ret_sts_unexp_error ;
3129: FND_MSG_PUB.count_and_get (
3130: p_encoded => FND_API.g_false

Line 3128: x_return_status := FND_API.g_ret_sts_unexp_error ;

3124: );
3125:
3126: WHEN FND_API.g_exc_unexpected_error THEN
3127: ROLLBACK TO Start_Mass_Payment;
3128: x_return_status := FND_API.g_ret_sts_unexp_error ;
3129: FND_MSG_PUB.count_and_get (
3130: p_encoded => FND_API.g_false
3131: ,p_count => x_msg_count
3132: ,p_data => x_msg_data

Line 3130: p_encoded => FND_API.g_false

3126: WHEN FND_API.g_exc_unexpected_error THEN
3127: ROLLBACK TO Start_Mass_Payment;
3128: x_return_status := FND_API.g_ret_sts_unexp_error ;
3129: FND_MSG_PUB.count_and_get (
3130: p_encoded => FND_API.g_false
3131: ,p_count => x_msg_count
3132: ,p_data => x_msg_data
3133: );
3134:

Line 3137: x_return_status := FND_API.g_ret_sts_unexp_error ;

3133: );
3134:
3135: WHEN OTHERS THEN
3136: ROLLBACK TO Start_Mass_Payment;
3137: x_return_status := FND_API.g_ret_sts_unexp_error ;
3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3140: END IF;
3141: FND_MSG_PUB.count_and_get(

Line 3142: p_encoded => FND_API.g_false

3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3140: END IF;
3141: FND_MSG_PUB.count_and_get(
3142: p_encoded => FND_API.g_false
3143: ,p_count => x_msg_count
3144: ,p_data => x_msg_data
3145: );
3146:

Line 3304: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3300: OZF_Utility_PVT.debug_message(l_full_name||': start');
3301: END IF;
3302:
3303: -- Standard call to check for call compatibility.
3304: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3305: p_api_version,
3306: l_api_name,
3307: G_PKG_NAME ) THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3304: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3305: p_api_version,
3306: l_api_name,
3307: G_PKG_NAME ) THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: END IF;
3310:
3311: -- Initialize message list if p_init_msg_list is set to TRUE.
3312: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3312: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: END IF;
3310:
3311: -- Initialize message list if p_init_msg_list is set to TRUE.
3312: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3313: FND_MSG_PUB.initialize;
3314: END IF;
3315:
3316: -- Initialize API return status to SUCCESS

Line 3317: x_return_status := FND_API.G_RET_STS_SUCCESS;

3313: FND_MSG_PUB.initialize;
3314: END IF;
3315:
3316: -- Initialize API return status to SUCCESS
3317: x_return_status := FND_API.G_RET_STS_SUCCESS;
3318:
3319: ------------------------ start -------------------------
3320: -------------------
3321: -- 1. Validation --

Line 3358: RAISE FND_API.g_exc_error;

3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3355: FND_MESSAGE.Set_Name('OZF','OZF_SETL_MUL_CLA_NS');
3356: FND_MSG_PUB.Add;
3357: END IF;
3358: RAISE FND_API.g_exc_error;
3359: END IF;
3360:
3361: IF SIGN(l_open_claim_amt) = 1 THEN
3362: l_settlement_type := 'DEDUCTION';

Line 3378: RAISE FND_API.g_exc_error;

3374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3375: FND_MESSAGE.Set_Name('OZF','OZF_SETL_DED_POCM');
3376: FND_MSG_PUB.Add;
3377: END IF;
3378: RAISE FND_API.g_exc_error;
3379: ELSIF l_settlement_type = 'OVERPAYMENT' AND
3380: p_open_transaction_tbl(i).trx_class NOT IN ('INVOICE', 'INV', 'DM', 'CB') THEN
3381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3382: FND_MESSAGE.Set_Name('OZF','OZF_SETL_OPM_PODM');

Line 3385: RAISE FND_API.g_exc_error;

3381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3382: FND_MESSAGE.Set_Name('OZF','OZF_SETL_OPM_PODM');
3383: FND_MSG_PUB.Add;
3384: END IF;
3385: RAISE FND_API.g_exc_error;
3386: END IF;
3387:
3388: l_open_trx_amt := l_open_trx_amt + p_open_transaction_tbl(i).amount_settled;
3389: EXIT WHEN i = p_open_transaction_tbl.LAST;

Line 3402: RAISE FND_API.g_exc_error;

3398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3399: FND_MESSAGE.Set_Name('OZF','OZF_SETL_TRX_AMT_ERR');
3400: FND_MSG_PUB.Add;
3401: END IF;
3402: RAISE FND_API.g_exc_error;
3403: END IF;
3404:
3405: i := p_payment_method_tbl.FIRST;
3406: IF i IS NOT NULL THEN

Line 3414: RAISE FND_API.g_exc_error;

3410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3411: FND_MESSAGE.Set_Name('OZF','OZF_SETL_DED_ERR');
3412: FND_MSG_PUB.Add;
3413: END IF;
3414: RAISE FND_API.g_exc_error;
3415: ELSIF l_settlement_type = 'OVERPAYMENT' AND
3416: p_payment_method_tbl(i).payment_method NOT IN ('WRITE_OFF', 'ON_ACCT_CREDIT') THEN
3417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3418: FND_MESSAGE.Set_Name('OZF','OZF_SETL_OPM_ERR');

Line 3421: RAISE FND_API.g_exc_error;

3417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3418: FND_MESSAGE.Set_Name('OZF','OZF_SETL_OPM_ERR');
3419: FND_MSG_PUB.Add;
3420: END IF;
3421: RAISE FND_API.g_exc_error;
3422: END IF;
3423:
3424: l_pay_method_amt := l_pay_method_amt + (p_payment_method_tbl(i).amount_settled * -1);
3425: EXIT WHEN i = p_payment_method_tbl.LAST;

Line 3444: RAISE FND_API.g_exc_error;

3440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3441: FND_MESSAGE.Set_Name('OZF','OZF_SETL_OPN_CLA_AMT_ERR');
3442: FND_MSG_PUB.Add;
3443: END IF;
3444: RAISE FND_API.g_exc_error;
3445: END IF;
3446:
3447: --bug4768031
3448: IF (ABS(l_open_trx_amt) = 0 AND ABS(l_pay_method_amt) = 0 AND

Line 3455: RAISE FND_API.g_exc_error;

3451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3452: FND_MESSAGE.Set_Name('OZF','OZF_SETL_DED_OPM_ERR');
3453: FND_MSG_PUB.Add;
3454: END IF;
3455: RAISE FND_API.g_exc_error;
3456: END IF;
3457:
3458: /* Bug4079177: Claims should be split if the settlement amount is less then
3459: the settlement amount on the group. If the group is a deduction group,

Line 3545: ,p_init_msg_list => FND_API.G_FALSE

3541: l_group_claim_rec.payment_method := 'MASS_SETTLEMENT';
3542:
3543: OZF_Claim_PVT.Create_Claim (
3544: p_api_version => l_api_version
3545: ,p_init_msg_list => FND_API.G_FALSE
3546: ,p_commit => FND_API.G_FALSE
3547: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3548: ,x_return_status => l_return_status
3549: ,x_msg_data => x_msg_data

Line 3546: ,p_commit => FND_API.G_FALSE

3542:
3543: OZF_Claim_PVT.Create_Claim (
3544: p_api_version => l_api_version
3545: ,p_init_msg_list => FND_API.G_FALSE
3546: ,p_commit => FND_API.G_FALSE
3547: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3548: ,x_return_status => l_return_status
3549: ,x_msg_data => x_msg_data
3550: ,x_msg_count => x_msg_count

Line 3547: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3543: OZF_Claim_PVT.Create_Claim (
3544: p_api_version => l_api_version
3545: ,p_init_msg_list => FND_API.G_FALSE
3546: ,p_commit => FND_API.G_FALSE
3547: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3548: ,x_return_status => l_return_status
3549: ,x_msg_data => x_msg_data
3550: ,x_msg_count => x_msg_count
3551: ,p_claim => l_group_claim_rec

Line 3558: IF l_return_status = FND_API.g_ret_sts_error THEN

3554: IF OZF_DEBUG_HIGH_ON THEN
3555: OZF_Utility_PVT.debug_message('group claim id = '||l_group_claim_id);
3556: END IF;
3557:
3558: IF l_return_status = FND_API.g_ret_sts_error THEN
3559: RAISE FND_API.g_exc_error;
3560: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3561: RAISE FND_API.g_exc_unexpected_error;
3562: END IF;

Line 3559: RAISE FND_API.g_exc_error;

3555: OZF_Utility_PVT.debug_message('group claim id = '||l_group_claim_id);
3556: END IF;
3557:
3558: IF l_return_status = FND_API.g_ret_sts_error THEN
3559: RAISE FND_API.g_exc_error;
3560: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3561: RAISE FND_API.g_exc_unexpected_error;
3562: END IF;
3563:

Line 3560: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3556: END IF;
3557:
3558: IF l_return_status = FND_API.g_ret_sts_error THEN
3559: RAISE FND_API.g_exc_error;
3560: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3561: RAISE FND_API.g_exc_unexpected_error;
3562: END IF;
3563:
3564:

Line 3561: RAISE FND_API.g_exc_unexpected_error;

3557:
3558: IF l_return_status = FND_API.g_ret_sts_error THEN
3559: RAISE FND_API.g_exc_error;
3560: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3561: RAISE FND_API.g_exc_unexpected_error;
3562: END IF;
3563:
3564:
3565: ---------------------

Line 3597: RAISE FND_API.g_exc_unexpected_error;

3593: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3594: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3595: FND_MSG_PUB.Add;
3596: END IF;
3597: RAISE FND_API.g_exc_unexpected_error;
3598: END;
3599:
3600: OPEN csr_claim_amount_rem(l_open_claim_tbl(i).claim_id);
3601: FETCH csr_claim_amount_rem INTO l_claim_amount_rem

Line 3627: ,p_init_msg_list => FND_API.g_false

3623: l_group_rem_amt := l_group_rem_amt + l_split_claim_tbl(1).amount;
3624:
3625: OZF_SPLIT_CLAIM_PVT.create_child_claim_tbl (
3626: p_api_version => l_api_version
3627: ,p_init_msg_list => FND_API.g_false
3628: ,p_commit => FND_API.g_false
3629: ,p_validation_level => FND_API.g_valid_level_full
3630: ,x_return_status => l_return_status
3631: ,x_msg_data => x_msg_data

Line 3628: ,p_commit => FND_API.g_false

3624:
3625: OZF_SPLIT_CLAIM_PVT.create_child_claim_tbl (
3626: p_api_version => l_api_version
3627: ,p_init_msg_list => FND_API.g_false
3628: ,p_commit => FND_API.g_false
3629: ,p_validation_level => FND_API.g_valid_level_full
3630: ,x_return_status => l_return_status
3631: ,x_msg_data => x_msg_data
3632: ,x_msg_count => x_msg_count

Line 3629: ,p_validation_level => FND_API.g_valid_level_full

3625: OZF_SPLIT_CLAIM_PVT.create_child_claim_tbl (
3626: p_api_version => l_api_version
3627: ,p_init_msg_list => FND_API.g_false
3628: ,p_commit => FND_API.g_false
3629: ,p_validation_level => FND_API.g_valid_level_full
3630: ,x_return_status => l_return_status
3631: ,x_msg_data => x_msg_data
3632: ,x_msg_count => x_msg_count
3633: ,px_child_claim_tbl => l_split_claim_tbl --12985686

Line 3636: IF l_return_status = FND_API.g_ret_sts_error THEN

3632: ,x_msg_count => x_msg_count
3633: ,px_child_claim_tbl => l_split_claim_tbl --12985686
3634: ,p_mode => 'AUTO'
3635: );
3636: IF l_return_status = FND_API.g_ret_sts_error THEN
3637: RAISE FND_API.g_exc_error;
3638: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3639: RAISE FND_API.g_exc_unexpected_error;
3640: END IF;

Line 3637: RAISE FND_API.g_exc_error;

3633: ,px_child_claim_tbl => l_split_claim_tbl --12985686
3634: ,p_mode => 'AUTO'
3635: );
3636: IF l_return_status = FND_API.g_ret_sts_error THEN
3637: RAISE FND_API.g_exc_error;
3638: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3639: RAISE FND_API.g_exc_unexpected_error;
3640: END IF;
3641: ELSIF ABS(l_open_claim_tbl(i).amount_settled) > ABS(l_claim_amount_rem) THEN

Line 3638: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3634: ,p_mode => 'AUTO'
3635: );
3636: IF l_return_status = FND_API.g_ret_sts_error THEN
3637: RAISE FND_API.g_exc_error;
3638: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3639: RAISE FND_API.g_exc_unexpected_error;
3640: END IF;
3641: ELSIF ABS(l_open_claim_tbl(i).amount_settled) > ABS(l_claim_amount_rem) THEN
3642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3639: RAISE FND_API.g_exc_unexpected_error;

3635: );
3636: IF l_return_status = FND_API.g_ret_sts_error THEN
3637: RAISE FND_API.g_exc_error;
3638: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3639: RAISE FND_API.g_exc_unexpected_error;
3640: END IF;
3641: ELSIF ABS(l_open_claim_tbl(i).amount_settled) > ABS(l_claim_amount_rem) THEN
3642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3643: FND_MESSAGE.Set_Name('OZF','OZF_SETL_CLA_AMT_ERR');

Line 3646: RAISE FND_API.g_exc_error;

3642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3643: FND_MESSAGE.Set_Name('OZF','OZF_SETL_CLA_AMT_ERR');
3644: FND_MSG_PUB.Add;
3645: END IF;
3646: RAISE FND_API.g_exc_error;
3647: END IF;
3648: EXIT WHEN i = l_open_claim_tbl.LAST;
3649: i := l_open_claim_tbl.NEXT(i);
3650: END LOOP;

Line 3717: RAISE FND_API.g_exc_error;

3713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3714: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_NO_GL_DATE');
3715: FND_MSG_PUB.Add;
3716: END IF;
3717: RAISE FND_API.g_exc_error;
3718: END IF;
3719: END IF;
3720:
3721: l_idx_setl_doc := l_idx_setl_doc + 1;

Line 3753: p_init_msg_list => FND_API.G_FALSE,

3749: END IF;
3750:
3751: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
3752: p_api_version_number => l_api_version,
3753: p_init_msg_list => FND_API.G_FALSE,
3754: p_commit => FND_API.G_FALSE,
3755: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3756: x_return_status => l_return_status,
3757: x_msg_count => x_msg_count,

Line 3754: p_commit => FND_API.G_FALSE,

3750:
3751: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
3752: p_api_version_number => l_api_version,
3753: p_init_msg_list => FND_API.G_FALSE,
3754: p_commit => FND_API.G_FALSE,
3755: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3756: x_return_status => l_return_status,
3757: x_msg_count => x_msg_count,
3758: x_msg_data => x_msg_data,

Line 3755: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3751: OZF_Settlement_Doc_PVT.Create_Settlement_Doc_Tbl(
3752: p_api_version_number => l_api_version,
3753: p_init_msg_list => FND_API.G_FALSE,
3754: p_commit => FND_API.G_FALSE,
3755: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3756: x_return_status => l_return_status,
3757: x_msg_count => x_msg_count,
3758: x_msg_data => x_msg_data,
3759: p_settlement_doc_tbl => l_group_settle_doc_tbl,

Line 3762: IF l_return_status = FND_API.g_ret_sts_error THEN

3758: x_msg_data => x_msg_data,
3759: p_settlement_doc_tbl => l_group_settle_doc_tbl,
3760: x_settlement_doc_id_tbl => l_group_settle_doc_id_tbl
3761: );
3762: IF l_return_status = FND_API.g_ret_sts_error THEN
3763: RAISE FND_API.g_exc_error;
3764: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3765: RAISE FND_API.g_exc_unexpected_error;
3766: END IF;

Line 3763: RAISE FND_API.g_exc_error;

3759: p_settlement_doc_tbl => l_group_settle_doc_tbl,
3760: x_settlement_doc_id_tbl => l_group_settle_doc_id_tbl
3761: );
3762: IF l_return_status = FND_API.g_ret_sts_error THEN
3763: RAISE FND_API.g_exc_error;
3764: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3765: RAISE FND_API.g_exc_unexpected_error;
3766: END IF;
3767:

Line 3764: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3760: x_settlement_doc_id_tbl => l_group_settle_doc_id_tbl
3761: );
3762: IF l_return_status = FND_API.g_ret_sts_error THEN
3763: RAISE FND_API.g_exc_error;
3764: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3765: RAISE FND_API.g_exc_unexpected_error;
3766: END IF;
3767:
3768: ------------------------------

Line 3765: RAISE FND_API.g_exc_unexpected_error;

3761: );
3762: IF l_return_status = FND_API.g_ret_sts_error THEN
3763: RAISE FND_API.g_exc_error;
3764: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3765: RAISE FND_API.g_exc_unexpected_error;
3766: END IF;
3767:
3768: ------------------------------
3769: -- 6. Break Mass Settlement --

Line 3782: IF l_return_status = FND_API.g_ret_sts_error THEN

3778: x_return_status => l_return_status,
3779: x_msg_data => x_msg_data,
3780: x_msg_count => x_msg_count
3781: );
3782: IF l_return_status = FND_API.g_ret_sts_error THEN
3783: RAISE FND_API.g_exc_error;
3784: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3785: RAISE FND_API.g_exc_unexpected_error;
3786: END IF;

Line 3783: RAISE FND_API.g_exc_error;

3779: x_msg_data => x_msg_data,
3780: x_msg_count => x_msg_count
3781: );
3782: IF l_return_status = FND_API.g_ret_sts_error THEN
3783: RAISE FND_API.g_exc_error;
3784: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3785: RAISE FND_API.g_exc_unexpected_error;
3786: END IF;
3787:

Line 3784: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3780: x_msg_count => x_msg_count
3781: );
3782: IF l_return_status = FND_API.g_ret_sts_error THEN
3783: RAISE FND_API.g_exc_error;
3784: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3785: RAISE FND_API.g_exc_unexpected_error;
3786: END IF;
3787:
3788:

Line 3785: RAISE FND_API.g_exc_unexpected_error;

3781: );
3782: IF l_return_status = FND_API.g_ret_sts_error THEN
3783: RAISE FND_API.g_exc_error;
3784: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3785: RAISE FND_API.g_exc_unexpected_error;
3786: END IF;
3787:
3788:
3789: ---------------------------------

Line 3803: IF l_return_status = FND_API.g_ret_sts_error THEN

3799: x_return_status => l_return_status,
3800: x_msg_data => x_msg_data,
3801: x_msg_count => x_msg_count
3802: );
3803: IF l_return_status = FND_API.g_ret_sts_error THEN
3804: RAISE FND_API.g_exc_error;
3805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3806: RAISE FND_API.g_exc_unexpected_error;
3807: END IF;

Line 3804: RAISE FND_API.g_exc_error;

3800: x_msg_data => x_msg_data,
3801: x_msg_count => x_msg_count
3802: );
3803: IF l_return_status = FND_API.g_ret_sts_error THEN
3804: RAISE FND_API.g_exc_error;
3805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3806: RAISE FND_API.g_exc_unexpected_error;
3807: END IF;
3808:

Line 3805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3801: x_msg_count => x_msg_count
3802: );
3803: IF l_return_status = FND_API.g_ret_sts_error THEN
3804: RAISE FND_API.g_exc_error;
3805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3806: RAISE FND_API.g_exc_unexpected_error;
3807: END IF;
3808:
3809: BEGIN

Line 3806: RAISE FND_API.g_exc_unexpected_error;

3802: );
3803: IF l_return_status = FND_API.g_ret_sts_error THEN
3804: RAISE FND_API.g_exc_error;
3805: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3806: RAISE FND_API.g_exc_unexpected_error;
3807: END IF;
3808:
3809: BEGIN
3810: UPDATE ozf_claims_all

Line 3843: RAISE FND_API.g_exc_unexpected_error;

3839: WHERE claim_id =p_open_claim_tbl(i).claim_id;
3840:
3841: EXCEPTION
3842: WHEN Others THEN
3843: RAISE FND_API.g_exc_unexpected_error;
3844: END;
3845: EXIT WHEN i = p_open_claim_tbl.LAST;
3846: i := p_open_claim_tbl.NEXT(i);
3847: END LOOP;

Line 3862: RAISE FND_API.g_exc_unexpected_error;

3858: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3859: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3860: FND_MSG_PUB.Add;
3861: END IF;
3862: RAISE FND_API.g_exc_unexpected_error;
3863: END;
3864:
3865:
3866: /* --------------------------------

Line 3880: IF l_return_status = FND_API.g_ret_sts_error THEN

3876: x_return_status => l_return_status,
3877: x_msg_data => x_msg_data,
3878: x_msg_count => x_msg_count
3879: );
3880: IF l_return_status = FND_API.g_ret_sts_error THEN
3881: RAISE FND_API.g_exc_error;
3882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;*/

Line 3881: RAISE FND_API.g_exc_error;

3877: x_msg_data => x_msg_data,
3878: x_msg_count => x_msg_count
3879: );
3880: IF l_return_status = FND_API.g_ret_sts_error THEN
3881: RAISE FND_API.g_exc_error;
3882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;*/
3885:

Line 3882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3878: x_msg_count => x_msg_count
3879: );
3880: IF l_return_status = FND_API.g_ret_sts_error THEN
3881: RAISE FND_API.g_exc_error;
3882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;*/
3885:
3886: OPEN csr_mass_setl_appr_req;

Line 3883: RAISE FND_API.g_exc_unexpected_error;

3879: );
3880: IF l_return_status = FND_API.g_ret_sts_error THEN
3881: RAISE FND_API.g_exc_error;
3882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3883: RAISE FND_API.g_exc_unexpected_error;
3884: END IF;*/
3885:
3886: OPEN csr_mass_setl_appr_req;
3887: FETCH csr_mass_setl_appr_req INTO l_appr_req;

Line 3905: IF l_return_status = FND_API.g_ret_sts_error THEN

3901: x_return_status => l_return_status,
3902: x_msg_data => x_msg_data,
3903: x_msg_count => x_msg_count
3904: );
3905: IF l_return_status = FND_API.g_ret_sts_error THEN
3906: RAISE FND_API.g_exc_error;
3907: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3908: RAISE FND_API.g_exc_unexpected_error;
3909: END IF;

Line 3906: RAISE FND_API.g_exc_error;

3902: x_msg_data => x_msg_data,
3903: x_msg_count => x_msg_count
3904: );
3905: IF l_return_status = FND_API.g_ret_sts_error THEN
3906: RAISE FND_API.g_exc_error;
3907: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3908: RAISE FND_API.g_exc_unexpected_error;
3909: END IF;
3910: ELSE

Line 3907: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3903: x_msg_count => x_msg_count
3904: );
3905: IF l_return_status = FND_API.g_ret_sts_error THEN
3906: RAISE FND_API.g_exc_error;
3907: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3908: RAISE FND_API.g_exc_unexpected_error;
3909: END IF;
3910: ELSE
3911: IF OZF_DEBUG_HIGH_ON THEN

Line 3908: RAISE FND_API.g_exc_unexpected_error;

3904: );
3905: IF l_return_status = FND_API.g_ret_sts_error THEN
3906: RAISE FND_API.g_exc_error;
3907: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3908: RAISE FND_API.g_exc_unexpected_error;
3909: END IF;
3910: ELSE
3911: IF OZF_DEBUG_HIGH_ON THEN
3912: OZF_Utility_PVT.debug_message('8. Approve Mass Settlement');

Line 3923: IF l_return_status = FND_API.g_ret_sts_error THEN

3919: x_msg_data => x_msg_data,
3920: x_msg_count => x_msg_count
3921: );
3922:
3923: IF l_return_status = FND_API.g_ret_sts_error THEN
3924: RAISE FND_API.g_exc_error;
3925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;

Line 3924: RAISE FND_API.g_exc_error;

3920: x_msg_count => x_msg_count
3921: );
3922:
3923: IF l_return_status = FND_API.g_ret_sts_error THEN
3924: RAISE FND_API.g_exc_error;
3925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;
3928: END IF;

Line 3925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3921: );
3922:
3923: IF l_return_status = FND_API.g_ret_sts_error THEN
3924: RAISE FND_API.g_exc_error;
3925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;
3928: END IF;
3929:

Line 3926: RAISE FND_API.g_exc_unexpected_error;

3922:
3923: IF l_return_status = FND_API.g_ret_sts_error THEN
3924: RAISE FND_API.g_exc_error;
3925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;
3928: END IF;
3929:
3930: IF OZF_DEBUG_HIGH_ON THEN

Line 3936: x_return_status := FND_API.G_RET_STS_SUCCESS;

3932: END IF;
3933:
3934:
3935: ------------------------ finish ------------------------
3936: x_return_status := FND_API.G_RET_STS_SUCCESS;
3937:
3938: -- Standard check for p_commit
3939: IF FND_API.to_Boolean(p_commit) THEN
3940: COMMIT WORK;

Line 3939: IF FND_API.to_Boolean(p_commit) THEN

3935: ------------------------ finish ------------------------
3936: x_return_status := FND_API.G_RET_STS_SUCCESS;
3937:
3938: -- Standard check for p_commit
3939: IF FND_API.to_Boolean(p_commit) THEN
3940: COMMIT WORK;
3941: END IF;
3942:
3943: FND_MSG_PUB.count_and_get(

Line 3944: p_encoded => FND_API.g_false,

3940: COMMIT WORK;
3941: END IF;
3942:
3943: FND_MSG_PUB.count_and_get(
3944: p_encoded => FND_API.g_false,
3945: p_count => x_msg_count,
3946: p_data => x_msg_data
3947: );
3948:

Line 3952: WHEN FND_API.g_exc_error THEN

3948:
3949:
3950:
3951: EXCEPTION
3952: WHEN FND_API.g_exc_error THEN
3953: ROLLBACK TO Settle_Mass_Settlement;
3954: x_return_status := FND_API.g_ret_sts_error;
3955: FND_MSG_PUB.count_and_get (
3956: p_encoded => FND_API.g_false

Line 3954: x_return_status := FND_API.g_ret_sts_error;

3950:
3951: EXCEPTION
3952: WHEN FND_API.g_exc_error THEN
3953: ROLLBACK TO Settle_Mass_Settlement;
3954: x_return_status := FND_API.g_ret_sts_error;
3955: FND_MSG_PUB.count_and_get (
3956: p_encoded => FND_API.g_false
3957: ,p_count => x_msg_count
3958: ,p_data => x_msg_data

Line 3956: p_encoded => FND_API.g_false

3952: WHEN FND_API.g_exc_error THEN
3953: ROLLBACK TO Settle_Mass_Settlement;
3954: x_return_status := FND_API.g_ret_sts_error;
3955: FND_MSG_PUB.count_and_get (
3956: p_encoded => FND_API.g_false
3957: ,p_count => x_msg_count
3958: ,p_data => x_msg_data
3959: );
3960:

Line 3961: WHEN FND_API.g_exc_unexpected_error THEN

3957: ,p_count => x_msg_count
3958: ,p_data => x_msg_data
3959: );
3960:
3961: WHEN FND_API.g_exc_unexpected_error THEN
3962: ROLLBACK TO Settle_Mass_Settlement;
3963: x_return_status := FND_API.g_ret_sts_unexp_error ;
3964: FND_MSG_PUB.count_and_get (
3965: p_encoded => FND_API.g_false

Line 3963: x_return_status := FND_API.g_ret_sts_unexp_error ;

3959: );
3960:
3961: WHEN FND_API.g_exc_unexpected_error THEN
3962: ROLLBACK TO Settle_Mass_Settlement;
3963: x_return_status := FND_API.g_ret_sts_unexp_error ;
3964: FND_MSG_PUB.count_and_get (
3965: p_encoded => FND_API.g_false
3966: ,p_count => x_msg_count
3967: ,p_data => x_msg_data

Line 3965: p_encoded => FND_API.g_false

3961: WHEN FND_API.g_exc_unexpected_error THEN
3962: ROLLBACK TO Settle_Mass_Settlement;
3963: x_return_status := FND_API.g_ret_sts_unexp_error ;
3964: FND_MSG_PUB.count_and_get (
3965: p_encoded => FND_API.g_false
3966: ,p_count => x_msg_count
3967: ,p_data => x_msg_data
3968: );
3969:

Line 3972: x_return_status := FND_API.g_ret_sts_unexp_error ;

3968: );
3969:
3970: WHEN OTHERS THEN
3971: ROLLBACK TO Settle_Mass_Settlement;
3972: x_return_status := FND_API.g_ret_sts_unexp_error ;
3973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3974: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3975: END IF;
3976: FND_MSG_PUB.count_and_get(

Line 3977: p_encoded => FND_API.g_false

3973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3974: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3975: END IF;
3976: FND_MSG_PUB.count_and_get(
3977: p_encoded => FND_API.g_false
3978: ,p_count => x_msg_count
3979: ,p_data => x_msg_data
3980: );
3981: