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.DPP_CLAIMS_PVT dependencies on FND_MESSAGE

Line 246: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

242: AND supplier_site_id = l_txn_hdr_rec.Vendor_site_ID
243: AND org_id = l_txn_hdr_rec.org_id;
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
247: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
248: fnd_message.set_token('ERRNO', sqlcode);
249: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
250: FND_MSG_PUB.add;

Line 247: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

243: AND org_id = l_txn_hdr_rec.org_id;
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
247: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
248: fnd_message.set_token('ERRNO', sqlcode);
249: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
250: FND_MSG_PUB.add;
251: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 248: fnd_message.set_token('ERRNO', sqlcode);

244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
247: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
248: fnd_message.set_token('ERRNO', sqlcode);
249: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
250: FND_MSG_PUB.add;
251: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
252: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 249: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');

245: WHEN NO_DATA_FOUND THEN
246: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
247: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
248: fnd_message.set_token('ERRNO', sqlcode);
249: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
250: FND_MSG_PUB.add;
251: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
252: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
253: END IF;

Line 256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

252: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
253: END IF;
254: RAISE FND_API.G_EXC_ERROR;
255: WHEN OTHERS THEN
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
258: fnd_message.set_token('ERRNO', sqlcode);
259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;

Line 257: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

253: END IF;
254: RAISE FND_API.G_EXC_ERROR;
255: WHEN OTHERS THEN
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
258: fnd_message.set_token('ERRNO', sqlcode);
259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 258: fnd_message.set_token('ERRNO', sqlcode);

254: RAISE FND_API.G_EXC_ERROR;
255: WHEN OTHERS THEN
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
258: fnd_message.set_token('ERRNO', sqlcode);
259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
262: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');

Line 259: fnd_message.set_token('REASON', sqlerrm);

255: WHEN OTHERS THEN
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
258: fnd_message.set_token('ERRNO', sqlcode);
259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
262: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
263: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);

Line 262: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');

258: fnd_message.set_token('ERRNO', sqlcode);
259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
262: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
263: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);
264: FND_MSG_PUB.add;
265: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
266: END IF;

Line 263: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);

259: fnd_message.set_token('REASON', sqlerrm);
260: FND_MSG_PUB.add;
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
262: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
263: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);
264: FND_MSG_PUB.add;
265: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
266: END IF;
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 346: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

342: null
343: );
344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
347: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
348: fnd_message.set_token('ERRNO', sqlcode);
349: fnd_message.set_token('REASON', sqlerrm);
350: FND_MSG_PUB.add;

Line 347: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

343: );
344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
347: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
348: fnd_message.set_token('ERRNO', sqlcode);
349: fnd_message.set_token('REASON', sqlerrm);
350: FND_MSG_PUB.add;
351: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 348: fnd_message.set_token('ERRNO', sqlcode);

344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
347: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
348: fnd_message.set_token('ERRNO', sqlcode);
349: fnd_message.set_token('REASON', sqlerrm);
350: FND_MSG_PUB.add;
351: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 349: fnd_message.set_token('REASON', sqlerrm);

345: WHEN OTHERS THEN
346: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
347: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
348: fnd_message.set_token('ERRNO', sqlcode);
349: fnd_message.set_token('REASON', sqlerrm);
350: FND_MSG_PUB.add;
351: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
353: END IF;

Line 368: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

364: DPP_UTILITY_PVT.debug_message('Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');
365: END IF;
366: END LOOP;
367: ELSE
368: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
369: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
370: FND_MSG_PUB.add;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;

Line 369: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

365: END IF;
366: END LOOP;
367: ELSE
368: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
369: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
370: FND_MSG_PUB.add;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373: --Get the customer name

Line 386: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

382: DPP_UTILITY_PVT.debug_message('Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');
383: END IF;
384: END LOOP;
385: ELSE
386: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
387: FND_MESSAGE.set_token('ID', 'Customer Account ID');
388: FND_MSG_PUB.add;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

Line 387: FND_MESSAGE.set_token('ID', 'Customer Account ID');

383: END IF;
384: END LOOP;
385: ELSE
386: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
387: FND_MESSAGE.set_token('ID', 'Customer Account ID');
388: FND_MSG_PUB.add;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391: END IF;

Line 457: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

453: WHERE inventory_item_id = l_txn_line_tbl(i).Inventory_Item_Id;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: ROLLBACK TO CREATE_CLAIMS_PVT;
457: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
458: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
459: fnd_message.set_token('ERRNO', sqlcode);
460: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
461: FND_MSG_PUB.add;

Line 458: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: ROLLBACK TO CREATE_CLAIMS_PVT;
457: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
458: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
459: fnd_message.set_token('ERRNO', sqlcode);
460: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
461: FND_MSG_PUB.add;
462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 459: fnd_message.set_token('ERRNO', sqlcode);

455: WHEN NO_DATA_FOUND THEN
456: ROLLBACK TO CREATE_CLAIMS_PVT;
457: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
458: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
459: fnd_message.set_token('ERRNO', sqlcode);
460: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
461: FND_MSG_PUB.add;
462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
463: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 460: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');

456: ROLLBACK TO CREATE_CLAIMS_PVT;
457: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
458: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
459: fnd_message.set_token('ERRNO', sqlcode);
460: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
461: FND_MSG_PUB.add;
462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
463: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
464: END IF;

Line 467: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

463: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
464: END IF;
465: RAISE FND_API.G_EXC_ERROR;
466: WHEN OTHERS THEN
467: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
468: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
469: fnd_message.set_token('ERRNO', sqlcode);
470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;

Line 468: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

464: END IF;
465: RAISE FND_API.G_EXC_ERROR;
466: WHEN OTHERS THEN
467: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
468: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
469: fnd_message.set_token('ERRNO', sqlcode);
470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;
472: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 469: fnd_message.set_token('ERRNO', sqlcode);

465: RAISE FND_API.G_EXC_ERROR;
466: WHEN OTHERS THEN
467: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
468: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
469: fnd_message.set_token('ERRNO', sqlcode);
470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;
472: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
473: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 470: fnd_message.set_token('REASON', sqlerrm);

466: WHEN OTHERS THEN
467: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
468: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
469: fnd_message.set_token('ERRNO', sqlcode);
470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;
472: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
473: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
474: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

Line 473: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

469: fnd_message.set_token('ERRNO', sqlcode);
470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;
472: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
473: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
474: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
475: FND_MSG_PUB.add;
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;

Line 474: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

470: fnd_message.set_token('REASON', sqlerrm);
471: FND_MSG_PUB.add;
472: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
473: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
474: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
475: FND_MSG_PUB.add;
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

514: dpp_utility_pvt.debug_message (substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
515: END IF;
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
519: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
520: fnd_message.set_token('ERRNO', sqlcode);
521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
522: FND_MSG_PUB.add;

Line 519: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

515: END IF;
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
519: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
520: fnd_message.set_token('ERRNO', sqlcode);
521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
522: FND_MSG_PUB.add;
523: --Update the GT table with the reason for failure

Line 520: fnd_message.set_token('ERRNO', sqlcode);

516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
519: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
520: fnd_message.set_token('ERRNO', sqlcode);
521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
522: FND_MSG_PUB.add;
523: --Update the GT table with the reason for failure
524: UPDATE DPP_CUSTOMER_CLAIMS_GT

Line 521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');

517: x_return_status := l_return_status;
518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
519: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
520: fnd_message.set_token('ERRNO', sqlcode);
521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
522: FND_MSG_PUB.add;
523: --Update the GT table with the reason for failure
524: UPDATE DPP_CUSTOMER_CLAIMS_GT
525: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management');

Line 568: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

564: to_char(l_txn_hdr_rec.ORG_ID),
565: l_approved_by_supplier);
566: EXCEPTION
567: WHEN OTHERS THEN
568: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
569: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
570: fnd_message.set_token('ERRNO', sqlcode);
571: fnd_message.set_token('REASON', sqlerrm);
572: FND_MSG_PUB.add;

Line 569: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

565: l_approved_by_supplier);
566: EXCEPTION
567: WHEN OTHERS THEN
568: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
569: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
570: fnd_message.set_token('ERRNO', sqlcode);
571: fnd_message.set_token('REASON', sqlerrm);
572: FND_MSG_PUB.add;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 570: fnd_message.set_token('ERRNO', sqlcode);

566: EXCEPTION
567: WHEN OTHERS THEN
568: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
569: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
570: fnd_message.set_token('ERRNO', sqlcode);
571: fnd_message.set_token('REASON', sqlerrm);
572: FND_MSG_PUB.add;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 571: fnd_message.set_token('REASON', sqlerrm);

567: WHEN OTHERS THEN
568: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
569: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
570: fnd_message.set_token('ERRNO', sqlcode);
571: fnd_message.set_token('REASON', sqlerrm);
572: FND_MSG_PUB.add;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
575: END IF;

Line 643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

639: FROM ozf_claims
640: WHERE claim_id = l_x_claim_id;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
644: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
645: fnd_message.set_token('ERRNO', sqlcode);
646: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
647: FND_MSG_PUB.add;

Line 644: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

640: WHERE claim_id = l_x_claim_id;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
644: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
645: fnd_message.set_token('ERRNO', sqlcode);
646: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
647: FND_MSG_PUB.add;
648: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 645: fnd_message.set_token('ERRNO', sqlcode);

641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
644: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
645: fnd_message.set_token('ERRNO', sqlcode);
646: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
647: FND_MSG_PUB.add;
648: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
649: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 646: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');

642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
644: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
645: fnd_message.set_token('ERRNO', sqlcode);
646: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
647: FND_MSG_PUB.add;
648: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
649: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
650: END IF;

Line 653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

649: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
650: END IF;
651: RAISE FND_API.G_EXC_ERROR;
652: WHEN OTHERS THEN
653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
654: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;

Line 654: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

650: END IF;
651: RAISE FND_API.G_EXC_ERROR;
652: WHEN OTHERS THEN
653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
654: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 655: fnd_message.set_token('ERRNO', sqlcode);

651: RAISE FND_API.G_EXC_ERROR;
652: WHEN OTHERS THEN
653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
654: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

Line 656: fnd_message.set_token('REASON', sqlerrm);

652: WHEN OTHERS THEN
653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
654: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
660: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

Line 659: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
660: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
661: FND_MSG_PUB.add;
662: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
663: END IF;

Line 660: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

656: fnd_message.set_token('REASON', sqlerrm);
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
660: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
661: FND_MSG_PUB.add;
662: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
663: END IF;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 686: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

682: END IF;
683: --If the claim updation process failed
684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: x_return_status := l_return_status;
686: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
687: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
688: fnd_message.set_token('ERRNO', sqlcode);
689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
690: FND_MSG_PUB.add;

Line 687: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

683: --If the claim updation process failed
684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: x_return_status := l_return_status;
686: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
687: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
688: fnd_message.set_token('ERRNO', sqlcode);
689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
690: FND_MSG_PUB.add;
691: --Delete the claim numbers from the GT table

Line 688: fnd_message.set_token('ERRNO', sqlcode);

684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: x_return_status := l_return_status;
686: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
687: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
688: fnd_message.set_token('ERRNO', sqlcode);
689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
690: FND_MSG_PUB.add;
691: --Delete the claim numbers from the GT table
692: UPDATE DPP_CUSTOMER_CLAIMS_GT

Line 689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');

685: x_return_status := l_return_status;
686: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
687: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
688: fnd_message.set_token('ERRNO', sqlcode);
689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
690: FND_MSG_PUB.add;
691: --Delete the claim numbers from the GT table
692: UPDATE DPP_CUSTOMER_CLAIMS_GT
693: SET claim_id = null,

Line 753: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

749: END IF;
750:
751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
752: x_return_status := l_return_status;
753: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
754: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
755: fnd_message.set_token('ERRNO', sqlcode);
756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
757: FND_MSG_PUB.add;

Line 754: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

750:
751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
752: x_return_status := l_return_status;
753: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
754: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
755: fnd_message.set_token('ERRNO', sqlcode);
756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
757: FND_MSG_PUB.add;
758: --Update the claim id into the global temp table..

Line 755: fnd_message.set_token('ERRNO', sqlcode);

751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
752: x_return_status := l_return_status;
753: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
754: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
755: fnd_message.set_token('ERRNO', sqlcode);
756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
757: FND_MSG_PUB.add;
758: --Update the claim id into the global temp table..
759: UPDATE DPP_CUSTOMER_CLAIMS_GT

Line 756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');

752: x_return_status := l_return_status;
753: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
754: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
755: fnd_message.set_token('ERRNO', sqlcode);
756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
757: FND_MSG_PUB.add;
758: --Update the claim id into the global temp table..
759: UPDATE DPP_CUSTOMER_CLAIMS_GT
760: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')

Line 781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

777: FROM ozf_claims
778: WHERE claim_id = l_x_claim_id;
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
782: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
783: fnd_message.set_token('ERRNO', sqlcode);
784: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
785: FND_MSG_PUB.add;

Line 782: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

778: WHERE claim_id = l_x_claim_id;
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
782: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
783: fnd_message.set_token('ERRNO', sqlcode);
784: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
785: FND_MSG_PUB.add;
786: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 783: fnd_message.set_token('ERRNO', sqlcode);

779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
782: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
783: fnd_message.set_token('ERRNO', sqlcode);
784: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
785: FND_MSG_PUB.add;
786: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
787: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 784: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');

780: WHEN NO_DATA_FOUND THEN
781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
782: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
783: fnd_message.set_token('ERRNO', sqlcode);
784: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
785: FND_MSG_PUB.add;
786: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
787: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
788: END IF;

Line 791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

787: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
788: END IF;
789: RAISE FND_API.G_EXC_ERROR;
790: WHEN OTHERS THEN
791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
792: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
793: fnd_message.set_token('ERRNO', sqlcode);
794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;

Line 792: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

788: END IF;
789: RAISE FND_API.G_EXC_ERROR;
790: WHEN OTHERS THEN
791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
792: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
793: fnd_message.set_token('ERRNO', sqlcode);
794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;
796: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 793: fnd_message.set_token('ERRNO', sqlcode);

789: RAISE FND_API.G_EXC_ERROR;
790: WHEN OTHERS THEN
791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
792: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
793: fnd_message.set_token('ERRNO', sqlcode);
794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;
796: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

Line 794: fnd_message.set_token('REASON', sqlerrm);

790: WHEN OTHERS THEN
791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
792: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
793: fnd_message.set_token('ERRNO', sqlcode);
794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;
796: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
798: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

Line 797: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

793: fnd_message.set_token('ERRNO', sqlcode);
794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;
796: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
798: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
799: FND_MSG_PUB.add;
800: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
801: END IF;

Line 798: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

794: fnd_message.set_token('REASON', sqlerrm);
795: FND_MSG_PUB.add;
796: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
797: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
798: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
799: FND_MSG_PUB.add;
800: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
801: END IF;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

819: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
820: END IF;
821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: x_return_status := l_return_status;
823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
824: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
825: fnd_message.set_token('ERRNO', sqlcode);
826: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
827: FND_MSG_PUB.add;

Line 824: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

820: END IF;
821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: x_return_status := l_return_status;
823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
824: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
825: fnd_message.set_token('ERRNO', sqlcode);
826: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
827: FND_MSG_PUB.add;
828: ELSE

Line 825: fnd_message.set_token('ERRNO', sqlcode);

821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: x_return_status := l_return_status;
823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
824: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
825: fnd_message.set_token('ERRNO', sqlcode);
826: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
827: FND_MSG_PUB.add;
828: ELSE
829: --Get the claim number corresponding to the claim id

Line 826: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');

822: x_return_status := l_return_status;
823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
824: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
825: fnd_message.set_token('ERRNO', sqlcode);
826: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
827: FND_MSG_PUB.add;
828: ELSE
829: --Get the claim number corresponding to the claim id
830: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP

Line 859: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

855: to_char(l_txn_hdr_rec.ORG_ID),
856: 'Y');
857: EXCEPTION
858: WHEN OTHERS THEN
859: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
860: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
861: fnd_message.set_token('ERRNO', sqlcode);
862: fnd_message.set_token('REASON', sqlerrm);
863: FND_MSG_PUB.add;

Line 860: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

856: 'Y');
857: EXCEPTION
858: WHEN OTHERS THEN
859: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
860: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
861: fnd_message.set_token('ERRNO', sqlcode);
862: fnd_message.set_token('REASON', sqlerrm);
863: FND_MSG_PUB.add;
864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 861: fnd_message.set_token('ERRNO', sqlcode);

857: EXCEPTION
858: WHEN OTHERS THEN
859: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
860: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
861: fnd_message.set_token('ERRNO', sqlcode);
862: fnd_message.set_token('REASON', sqlerrm);
863: FND_MSG_PUB.add;
864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 862: fnd_message.set_token('REASON', sqlerrm);

858: WHEN OTHERS THEN
859: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
860: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
861: fnd_message.set_token('ERRNO', sqlcode);
862: fnd_message.set_token('REASON', sqlerrm);
863: FND_MSG_PUB.add;
864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;

Line 964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

960: dpp_utility_pvt.debug_message(substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
961: END IF;
962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: x_return_status := l_return_status;
964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
965: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
966: fnd_message.set_token('ERRNO', sqlcode);
967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
968: FND_MSG_PUB.add;

Line 965: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

961: END IF;
962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: x_return_status := l_return_status;
964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
965: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
966: fnd_message.set_token('ERRNO', sqlcode);
967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
968: FND_MSG_PUB.add;
969: --Insert the claim id into the global temp table..

Line 966: fnd_message.set_token('ERRNO', sqlcode);

962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: x_return_status := l_return_status;
964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
965: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
966: fnd_message.set_token('ERRNO', sqlcode);
967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
968: FND_MSG_PUB.add;
969: --Insert the claim id into the global temp table..
970: UPDATE DPP_CUSTOMER_CLAIMS_GT

Line 967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');

963: x_return_status := l_return_status;
964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
965: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
966: fnd_message.set_token('ERRNO', sqlcode);
967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
968: FND_MSG_PUB.add;
969: --Insert the claim id into the global temp table..
970: UPDATE DPP_CUSTOMER_CLAIMS_GT
971: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')

Line 993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

989: FROM ozf_claims
990: WHERE claim_id = l_x_claim_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
994: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
995: fnd_message.set_token('ERRNO', sqlcode);
996: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
997: FND_MSG_PUB.add;

Line 994: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

990: WHERE claim_id = l_x_claim_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
994: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
995: fnd_message.set_token('ERRNO', sqlcode);
996: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
997: FND_MSG_PUB.add;
998: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 995: fnd_message.set_token('ERRNO', sqlcode);

991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
994: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
995: fnd_message.set_token('ERRNO', sqlcode);
996: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
997: FND_MSG_PUB.add;
998: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
999: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 996: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');

992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
994: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
995: fnd_message.set_token('ERRNO', sqlcode);
996: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
997: FND_MSG_PUB.add;
998: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
999: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1000: END IF;

Line 1003: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

999: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1000: END IF;
1001: RAISE FND_API.G_EXC_ERROR;
1002: WHEN OTHERS THEN
1003: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1004: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1005: fnd_message.set_token('ERRNO', sqlcode);
1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;

Line 1004: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1000: END IF;
1001: RAISE FND_API.G_EXC_ERROR;
1002: WHEN OTHERS THEN
1003: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1004: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1005: fnd_message.set_token('ERRNO', sqlcode);
1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;
1008: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1005: fnd_message.set_token('ERRNO', sqlcode);

1001: RAISE FND_API.G_EXC_ERROR;
1002: WHEN OTHERS THEN
1003: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1004: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1005: fnd_message.set_token('ERRNO', sqlcode);
1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;
1008: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1009: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

Line 1006: fnd_message.set_token('REASON', sqlerrm);

1002: WHEN OTHERS THEN
1003: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1004: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1005: fnd_message.set_token('ERRNO', sqlcode);
1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;
1008: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1009: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1010: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

Line 1009: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

1005: fnd_message.set_token('ERRNO', sqlcode);
1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;
1008: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1009: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1010: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
1011: FND_MSG_PUB.add;
1012: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1013: END IF;

Line 1010: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

1006: fnd_message.set_token('REASON', sqlerrm);
1007: FND_MSG_PUB.add;
1008: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1009: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1010: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
1011: FND_MSG_PUB.add;
1012: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1013: END IF;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1031: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1032: END IF;
1033: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: x_return_status := l_return_status;
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1037: fnd_message.set_token('ERRNO', sqlcode);
1038: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1039: FND_MSG_PUB.add;

Line 1036: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1032: END IF;
1033: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: x_return_status := l_return_status;
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1037: fnd_message.set_token('ERRNO', sqlcode);
1038: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1039: FND_MSG_PUB.add;
1040: ELSE

Line 1037: fnd_message.set_token('ERRNO', sqlcode);

1033: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: x_return_status := l_return_status;
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1037: fnd_message.set_token('ERRNO', sqlcode);
1038: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1039: FND_MSG_PUB.add;
1040: ELSE
1041: --Get the claim number corresponding to the claim id

Line 1038: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');

1034: x_return_status := l_return_status;
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1037: fnd_message.set_token('ERRNO', sqlcode);
1038: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1039: FND_MSG_PUB.add;
1040: ELSE
1041: --Get the claim number corresponding to the claim id
1042: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP

Line 1071: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1067: to_char(l_txn_hdr_rec.ORG_ID),
1068: 'Y');
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1072: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1073: fnd_message.set_token('ERRNO', sqlcode);
1074: fnd_message.set_token('REASON', sqlerrm);
1075: FND_MSG_PUB.add;

Line 1072: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1068: 'Y');
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1072: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1073: fnd_message.set_token('ERRNO', sqlcode);
1074: fnd_message.set_token('REASON', sqlerrm);
1075: FND_MSG_PUB.add;
1076: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1073: fnd_message.set_token('ERRNO', sqlcode);

1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1072: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1073: fnd_message.set_token('ERRNO', sqlcode);
1074: fnd_message.set_token('REASON', sqlerrm);
1075: FND_MSG_PUB.add;
1076: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1074: fnd_message.set_token('REASON', sqlerrm);

1070: WHEN OTHERS THEN
1071: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1072: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1073: fnd_message.set_token('ERRNO', sqlcode);
1074: fnd_message.set_token('REASON', sqlerrm);
1075: FND_MSG_PUB.add;
1076: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1078: END IF;

Line 1130: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

1126: END IF;
1127: END LOOP;
1128: END LOOP;
1129: ELSE
1130: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1131: FND_MESSAGE.set_token('ID', 'Claim Type Flag');
1132: FND_MSG_PUB.add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;

Line 1131: FND_MESSAGE.set_token('ID', 'Claim Type Flag');

1127: END LOOP;
1128: END LOOP;
1129: ELSE
1130: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1131: FND_MESSAGE.set_token('ID', 'Claim Type Flag');
1132: FND_MSG_PUB.add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: END LOOP; -- End Loop for DPP Price Increase Enhancement

Line 1254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1250: END LOOP;
1251: END IF;
1252: WHEN OTHERS THEN
1253: ROLLBACK TO CREATE_CLAIMS_PVT;
1254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1255: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1256: fnd_message.set_token('ERRNO', sqlcode);
1257: fnd_message.set_token('REASON', sqlerrm);
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1255: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1251: END IF;
1252: WHEN OTHERS THEN
1253: ROLLBACK TO CREATE_CLAIMS_PVT;
1254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1255: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1256: fnd_message.set_token('ERRNO', sqlcode);
1257: fnd_message.set_token('REASON', sqlerrm);
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1256: fnd_message.set_token('ERRNO', sqlcode);

1252: WHEN OTHERS THEN
1253: ROLLBACK TO CREATE_CLAIMS_PVT;
1254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1255: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1256: fnd_message.set_token('ERRNO', sqlcode);
1257: fnd_message.set_token('REASON', sqlerrm);
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1260: THEN

Line 1257: fnd_message.set_token('REASON', sqlerrm);

1253: ROLLBACK TO CREATE_CLAIMS_PVT;
1254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1255: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1256: fnd_message.set_token('ERRNO', sqlcode);
1257: fnd_message.set_token('REASON', sqlerrm);
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1260: THEN
1261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1356: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

1352: -- Initialize API return status to sucess
1353: l_return_status := FND_API.G_RET_STS_SUCCESS;
1354:
1355: IF l_txn_hdr_rec.Transaction_number IS NULL THEN
1356: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1357: FND_MESSAGE.set_token('ID', 'Transaction Number');
1358: FND_MSG_PUB.add;
1359: RAISE FND_API.G_EXC_ERROR;
1360: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN

Line 1357: FND_MESSAGE.set_token('ID', 'Transaction Number');

1353: l_return_status := FND_API.G_RET_STS_SUCCESS;
1354:
1355: IF l_txn_hdr_rec.Transaction_number IS NULL THEN
1356: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1357: FND_MESSAGE.set_token('ID', 'Transaction Number');
1358: FND_MSG_PUB.add;
1359: RAISE FND_API.G_EXC_ERROR;
1360: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1361: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 1361: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

1357: FND_MESSAGE.set_token('ID', 'Transaction Number');
1358: FND_MSG_PUB.add;
1359: RAISE FND_API.G_EXC_ERROR;
1360: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1361: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1362: FND_MESSAGE.set_token('ID', 'Claim ID');
1363: FND_MSG_PUB.add;
1364: RAISE FND_API.G_EXC_ERROR;
1365: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN

Line 1362: FND_MESSAGE.set_token('ID', 'Claim ID');

1358: FND_MSG_PUB.add;
1359: RAISE FND_API.G_EXC_ERROR;
1360: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1361: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1362: FND_MESSAGE.set_token('ID', 'Claim ID');
1363: FND_MSG_PUB.add;
1364: RAISE FND_API.G_EXC_ERROR;
1365: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1366: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 1366: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

1362: FND_MESSAGE.set_token('ID', 'Claim ID');
1363: FND_MSG_PUB.add;
1364: RAISE FND_API.G_EXC_ERROR;
1365: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1366: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1367: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
1368: FND_MSG_PUB.add;
1369: RAISE FND_API.G_EXC_ERROR;
1370: ELSE

Line 1367: FND_MESSAGE.set_token('ID', 'Transaction Header ID');

1363: FND_MSG_PUB.add;
1364: RAISE FND_API.G_EXC_ERROR;
1365: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1366: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1367: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
1368: FND_MSG_PUB.add;
1369: RAISE FND_API.G_EXC_ERROR;
1370: ELSE
1371: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';

Line 1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1387: FROM ozf_claims_all
1388: WHERE claim_id = l_txn_hdr_rec.claim_id;
1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1392: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1393: fnd_message.set_token('ERRNO', sqlcode);
1394: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1395: FND_MSG_PUB.add;

Line 1392: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1388: WHERE claim_id = l_txn_hdr_rec.claim_id;
1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1392: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1393: fnd_message.set_token('ERRNO', sqlcode);
1394: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1395: FND_MSG_PUB.add;
1396: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1393: fnd_message.set_token('ERRNO', sqlcode);

1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1392: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1393: fnd_message.set_token('ERRNO', sqlcode);
1394: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1395: FND_MSG_PUB.add;
1396: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1397: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1394: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');

1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1392: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1393: fnd_message.set_token('ERRNO', sqlcode);
1394: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1395: FND_MSG_PUB.add;
1396: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1397: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1398: END IF;

Line 1401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1397: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1398: END IF;
1399: RAISE FND_API.G_EXC_ERROR;
1400: WHEN OTHERS THEN
1401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1402: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1403: fnd_message.set_token('ERRNO', sqlcode);
1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;

Line 1402: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1398: END IF;
1399: RAISE FND_API.G_EXC_ERROR;
1400: WHEN OTHERS THEN
1401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1402: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1403: fnd_message.set_token('ERRNO', sqlcode);
1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;
1406: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1403: fnd_message.set_token('ERRNO', sqlcode);

1399: RAISE FND_API.G_EXC_ERROR;
1400: WHEN OTHERS THEN
1401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1402: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1403: fnd_message.set_token('ERRNO', sqlcode);
1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;
1406: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1407: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

Line 1404: fnd_message.set_token('REASON', sqlerrm);

1400: WHEN OTHERS THEN
1401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1402: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1403: fnd_message.set_token('ERRNO', sqlcode);
1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;
1406: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1407: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1408: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

Line 1407: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

1403: fnd_message.set_token('ERRNO', sqlcode);
1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;
1406: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1407: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1408: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1409: FND_MSG_PUB.add;
1410: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1411: END IF;

Line 1408: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

1404: fnd_message.set_token('REASON', sqlerrm);
1405: FND_MSG_PUB.add;
1406: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1407: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1408: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1409: FND_MSG_PUB.add;
1410: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1411: END IF;
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1453: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1449: AND item_id = l_txn_line_tbl(i).Inventory_Item_Id;
1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1454: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1455: fnd_message.set_token('ERRNO', sqlcode);
1456: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1457: FND_MSG_PUB.add;

Line 1454: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1454: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1455: fnd_message.set_token('ERRNO', sqlcode);
1456: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1457: FND_MSG_PUB.add;
1458: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1455: fnd_message.set_token('ERRNO', sqlcode);

1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1454: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1455: fnd_message.set_token('ERRNO', sqlcode);
1456: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1457: FND_MSG_PUB.add;
1458: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1459: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1456: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');

1452: WHEN NO_DATA_FOUND THEN
1453: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1454: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1455: fnd_message.set_token('ERRNO', sqlcode);
1456: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1457: FND_MSG_PUB.add;
1458: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1459: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1460: END IF;

Line 1463: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1459: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;
1462: WHEN OTHERS THEN
1463: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1464: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1465: fnd_message.set_token('ERRNO', sqlcode);
1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;

Line 1464: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;
1462: WHEN OTHERS THEN
1463: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1464: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1465: fnd_message.set_token('ERRNO', sqlcode);
1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1465: fnd_message.set_token('ERRNO', sqlcode);

1461: RAISE FND_API.G_EXC_ERROR;
1462: WHEN OTHERS THEN
1463: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1464: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1465: fnd_message.set_token('ERRNO', sqlcode);
1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');

Line 1466: fnd_message.set_token('REASON', sqlerrm);

1462: WHEN OTHERS THEN
1463: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1464: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1465: fnd_message.set_token('ERRNO', sqlcode);
1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1470: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

Line 1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');

1465: fnd_message.set_token('ERRNO', sqlcode);
1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1470: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1471: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1472: FND_MSG_PUB.add;
1473: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1470: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

1466: fnd_message.set_token('REASON', sqlerrm);
1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1470: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1471: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1472: FND_MSG_PUB.add;
1473: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1474: END IF;

Line 1471: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);

1467: FND_MSG_PUB.add;
1468: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1469: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1470: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1471: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1472: FND_MSG_PUB.add;
1473: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1474: END IF;
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1537: FROM ozf_claims
1538: WHERE claim_id = l_txn_hdr_rec.claim_id;
1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1542: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1543: fnd_message.set_token('ERRNO', sqlcode);
1544: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1545: FND_MSG_PUB.add;

Line 1542: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1538: WHERE claim_id = l_txn_hdr_rec.claim_id;
1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1542: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1543: fnd_message.set_token('ERRNO', sqlcode);
1544: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1545: FND_MSG_PUB.add;
1546: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1543: fnd_message.set_token('ERRNO', sqlcode);

1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1542: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1543: fnd_message.set_token('ERRNO', sqlcode);
1544: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1545: FND_MSG_PUB.add;
1546: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1547: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1544: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');

1540: WHEN NO_DATA_FOUND THEN
1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1542: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1543: fnd_message.set_token('ERRNO', sqlcode);
1544: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1545: FND_MSG_PUB.add;
1546: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1547: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1548: END IF;

Line 1551: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1547: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1548: END IF;
1549: RAISE FND_API.G_EXC_ERROR;
1550: WHEN OTHERS THEN
1551: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1552: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1553: fnd_message.set_token('ERRNO', sqlcode);
1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;

Line 1552: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1548: END IF;
1549: RAISE FND_API.G_EXC_ERROR;
1550: WHEN OTHERS THEN
1551: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1552: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1553: fnd_message.set_token('ERRNO', sqlcode);
1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;
1556: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1553: fnd_message.set_token('ERRNO', sqlcode);

1549: RAISE FND_API.G_EXC_ERROR;
1550: WHEN OTHERS THEN
1551: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1552: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1553: fnd_message.set_token('ERRNO', sqlcode);
1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;
1556: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1557: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

Line 1554: fnd_message.set_token('REASON', sqlerrm);

1550: WHEN OTHERS THEN
1551: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1552: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1553: fnd_message.set_token('ERRNO', sqlcode);
1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;
1556: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1557: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1558: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

Line 1557: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

1553: fnd_message.set_token('ERRNO', sqlcode);
1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;
1556: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1557: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1558: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1559: FND_MSG_PUB.add;
1560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1561: END IF;

Line 1558: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

1554: fnd_message.set_token('REASON', sqlerrm);
1555: FND_MSG_PUB.add;
1556: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1557: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1558: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1559: FND_MSG_PUB.add;
1560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1561: END IF;
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1604: l_api_name
1605: );
1606: x_return_status := l_return_status;
1607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1610: fnd_message.set_token('ERRNO', sqlcode);
1611: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1612: FND_MSG_PUB.add;

Line 1609: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1605: );
1606: x_return_status := l_return_status;
1607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1610: fnd_message.set_token('ERRNO', sqlcode);
1611: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1612: FND_MSG_PUB.add;
1613: RAISE FND_API.G_EXC_ERROR;

Line 1610: fnd_message.set_token('ERRNO', sqlcode);

1606: x_return_status := l_return_status;
1607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1610: fnd_message.set_token('ERRNO', sqlcode);
1611: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1612: FND_MSG_PUB.add;
1613: RAISE FND_API.G_EXC_ERROR;
1614: END IF;

Line 1611: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');

1607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1610: fnd_message.set_token('ERRNO', sqlcode);
1611: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1612: FND_MSG_PUB.add;
1613: RAISE FND_API.G_EXC_ERROR;
1614: END IF;
1615:

Line 1676: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1672: END LOOP;
1673: END IF;
1674: WHEN OTHERS THEN
1675: ROLLBACK TO UPDATE_CLAIMS_PVT;
1676: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1677: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1678: fnd_message.set_token('ERRNO', sqlcode);
1679: fnd_message.set_token('REASON', sqlerrm);
1680: FND_MSG_PUB.add;

Line 1677: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');

1673: END IF;
1674: WHEN OTHERS THEN
1675: ROLLBACK TO UPDATE_CLAIMS_PVT;
1676: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1677: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1678: fnd_message.set_token('ERRNO', sqlcode);
1679: fnd_message.set_token('REASON', sqlerrm);
1680: FND_MSG_PUB.add;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1678: fnd_message.set_token('ERRNO', sqlcode);

1674: WHEN OTHERS THEN
1675: ROLLBACK TO UPDATE_CLAIMS_PVT;
1676: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1677: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1678: fnd_message.set_token('ERRNO', sqlcode);
1679: fnd_message.set_token('REASON', sqlerrm);
1680: FND_MSG_PUB.add;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1679: fnd_message.set_token('REASON', sqlerrm);

1675: ROLLBACK TO UPDATE_CLAIMS_PVT;
1676: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1677: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1678: fnd_message.set_token('ERRNO', sqlcode);
1679: fnd_message.set_token('REASON', sqlerrm);
1680: FND_MSG_PUB.add;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1683: THEN