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 257: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

253: AND supplier_site_id = l_txn_hdr_rec.Vendor_site_ID
254: AND org_id = l_txn_hdr_rec.org_id;
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
258: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
259: fnd_message.set_token('ERRNO', sqlcode);
260: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
261: FND_MSG_PUB.add;

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

254: AND org_id = l_txn_hdr_rec.org_id;
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
258: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
259: fnd_message.set_token('ERRNO', sqlcode);
260: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
261: FND_MSG_PUB.add;
262: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
258: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
259: fnd_message.set_token('ERRNO', sqlcode);
260: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
261: FND_MSG_PUB.add;
262: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
263: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
258: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
259: fnd_message.set_token('ERRNO', sqlcode);
260: fnd_message.set_token('REASON', 'NO CUST ACCOUNT ID RETRIEVED');
261: FND_MSG_PUB.add;
262: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
263: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
264: END IF;

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

263: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
264: END IF;
265: RAISE FND_API.G_EXC_ERROR;
266: WHEN OTHERS THEN
267: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
268: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
269: fnd_message.set_token('ERRNO', sqlcode);
270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;

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

264: END IF;
265: RAISE FND_API.G_EXC_ERROR;
266: WHEN OTHERS THEN
267: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
268: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
269: fnd_message.set_token('ERRNO', sqlcode);
270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;
272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

265: RAISE FND_API.G_EXC_ERROR;
266: WHEN OTHERS THEN
267: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
268: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
269: fnd_message.set_token('ERRNO', sqlcode);
270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;
272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
273: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');

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

266: WHEN OTHERS THEN
267: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
268: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
269: fnd_message.set_token('ERRNO', sqlcode);
270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;
272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
273: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
274: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);

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

269: fnd_message.set_token('ERRNO', sqlcode);
270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;
272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
273: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
274: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);
275: FND_MSG_PUB.add;
276: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
277: END IF;

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

270: fnd_message.set_token('REASON', sqlerrm);
271: FND_MSG_PUB.add;
272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
273: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_TRD_PROFILE');
274: fnd_message.set_token('VENDORID', l_txn_hdr_rec.Vendor_ID);
275: FND_MSG_PUB.add;
276: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
277: END IF;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

352: null
353: );
354: EXCEPTION
355: WHEN OTHERS THEN
356: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
357: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
358: fnd_message.set_token('ERRNO', sqlcode);
359: fnd_message.set_token('REASON', sqlerrm);
360: FND_MSG_PUB.add;

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

353: );
354: EXCEPTION
355: WHEN OTHERS THEN
356: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
357: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
358: fnd_message.set_token('ERRNO', sqlcode);
359: fnd_message.set_token('REASON', sqlerrm);
360: FND_MSG_PUB.add;
361: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

354: EXCEPTION
355: WHEN OTHERS THEN
356: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
357: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
358: fnd_message.set_token('ERRNO', sqlcode);
359: fnd_message.set_token('REASON', sqlerrm);
360: FND_MSG_PUB.add;
361: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

355: WHEN OTHERS THEN
356: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
357: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
358: fnd_message.set_token('ERRNO', sqlcode);
359: fnd_message.set_token('REASON', sqlerrm);
360: FND_MSG_PUB.add;
361: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
363: END IF;

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

374: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');
375: END IF;
376: END LOOP;
377: ELSE
378: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
379: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
380: FND_MSG_PUB.add;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;

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

375: END IF;
376: END LOOP;
377: ELSE
378: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
379: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
380: FND_MSG_PUB.add;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383: --Get the customer name

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

392: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');
393: END IF;
394: END LOOP;
395: ELSE
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Customer Account ID');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;

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

393: END IF;
394: END LOOP;
395: ELSE
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Customer Account ID');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401: END IF;

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

464: WHERE inventory_item_id = l_txn_line_tbl(i).Inventory_Item_Id;
465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: ROLLBACK TO CREATE_CLAIMS_PVT;
468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
470: fnd_message.set_token('ERRNO', sqlcode);
471: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
472: FND_MSG_PUB.add;

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

465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: ROLLBACK TO CREATE_CLAIMS_PVT;
468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
470: fnd_message.set_token('ERRNO', sqlcode);
471: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
472: FND_MSG_PUB.add;
473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

466: WHEN NO_DATA_FOUND THEN
467: ROLLBACK TO CREATE_CLAIMS_PVT;
468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
470: fnd_message.set_token('ERRNO', sqlcode);
471: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
472: FND_MSG_PUB.add;
473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

467: ROLLBACK TO CREATE_CLAIMS_PVT;
468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
470: fnd_message.set_token('ERRNO', sqlcode);
471: fnd_message.set_token('REASON', 'NO ITEM DESC RETRIEVED');
472: FND_MSG_PUB.add;
473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;

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

474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;
476: RAISE FND_API.G_EXC_ERROR;
477: WHEN OTHERS THEN
478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
480: fnd_message.set_token('ERRNO', sqlcode);
481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;

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

475: END IF;
476: RAISE FND_API.G_EXC_ERROR;
477: WHEN OTHERS THEN
478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
480: fnd_message.set_token('ERRNO', sqlcode);
481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;
483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

476: RAISE FND_API.G_EXC_ERROR;
477: WHEN OTHERS THEN
478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
480: fnd_message.set_token('ERRNO', sqlcode);
481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;
483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
484: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

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

477: WHEN OTHERS THEN
478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
480: fnd_message.set_token('ERRNO', sqlcode);
481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;
483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
484: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
485: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

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

480: fnd_message.set_token('ERRNO', sqlcode);
481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;
483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
484: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
485: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
486: FND_MSG_PUB.add;
487: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
488: END IF;

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

481: fnd_message.set_token('REASON', sqlerrm);
482: FND_MSG_PUB.add;
483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
484: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
485: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
486: FND_MSG_PUB.add;
487: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
488: END IF;
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

523: dpp_utility_pvt.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: x_return_status := l_return_status;
527: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
528: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
529: fnd_message.set_token('ERRNO', sqlcode);
530: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
531: FND_MSG_PUB.add;

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

524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: x_return_status := l_return_status;
527: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
528: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
529: fnd_message.set_token('ERRNO', sqlcode);
530: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
531: FND_MSG_PUB.add;
532: --Update the GT table with the reason for failure

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

525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: x_return_status := l_return_status;
527: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
528: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
529: fnd_message.set_token('ERRNO', sqlcode);
530: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
531: FND_MSG_PUB.add;
532: --Update the GT table with the reason for failure
533: UPDATE DPP_CUSTOMER_CLAIMS_GT

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

526: x_return_status := l_return_status;
527: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
528: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
529: fnd_message.set_token('ERRNO', sqlcode);
530: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
531: FND_MSG_PUB.add;
532: --Update the GT table with the reason for failure
533: UPDATE DPP_CUSTOMER_CLAIMS_GT
534: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management');

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

573: to_char(l_txn_hdr_rec.ORG_ID),
574: l_approved_by_supplier);
575: EXCEPTION
576: WHEN OTHERS THEN
577: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
578: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
579: fnd_message.set_token('ERRNO', sqlcode);
580: fnd_message.set_token('REASON', sqlerrm);
581: FND_MSG_PUB.add;

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

574: l_approved_by_supplier);
575: EXCEPTION
576: WHEN OTHERS THEN
577: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
578: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
579: fnd_message.set_token('ERRNO', sqlcode);
580: fnd_message.set_token('REASON', sqlerrm);
581: FND_MSG_PUB.add;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

575: EXCEPTION
576: WHEN OTHERS THEN
577: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
578: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
579: fnd_message.set_token('ERRNO', sqlcode);
580: fnd_message.set_token('REASON', sqlerrm);
581: FND_MSG_PUB.add;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

576: WHEN OTHERS THEN
577: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
578: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
579: fnd_message.set_token('ERRNO', sqlcode);
580: fnd_message.set_token('REASON', sqlerrm);
581: FND_MSG_PUB.add;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
584: END IF;

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

652: FROM ozf_claims
653: WHERE claim_id = l_x_claim_id;
654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN
656: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
657: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
658: fnd_message.set_token('ERRNO', sqlcode);
659: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
660: FND_MSG_PUB.add;

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

653: WHERE claim_id = l_x_claim_id;
654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN
656: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
657: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
658: fnd_message.set_token('ERRNO', sqlcode);
659: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
660: FND_MSG_PUB.add;
661: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN
656: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
657: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
658: fnd_message.set_token('ERRNO', sqlcode);
659: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
660: FND_MSG_PUB.add;
661: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
662: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

655: WHEN NO_DATA_FOUND THEN
656: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
657: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
658: fnd_message.set_token('ERRNO', sqlcode);
659: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
660: FND_MSG_PUB.add;
661: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
662: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
663: END IF;

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

662: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
663: END IF;
664: RAISE FND_API.G_EXC_ERROR;
665: WHEN OTHERS THEN
666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
667: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
668: fnd_message.set_token('ERRNO', sqlcode);
669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;

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

663: END IF;
664: RAISE FND_API.G_EXC_ERROR;
665: WHEN OTHERS THEN
666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
667: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
668: fnd_message.set_token('ERRNO', sqlcode);
669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;
671: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

664: RAISE FND_API.G_EXC_ERROR;
665: WHEN OTHERS THEN
666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
667: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
668: fnd_message.set_token('ERRNO', sqlcode);
669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;
671: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
672: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

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

665: WHEN OTHERS THEN
666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
667: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
668: fnd_message.set_token('ERRNO', sqlcode);
669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;
671: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
672: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
673: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

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

668: fnd_message.set_token('ERRNO', sqlcode);
669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;
671: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
672: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
673: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
674: FND_MSG_PUB.add;
675: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
676: END IF;

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

669: fnd_message.set_token('REASON', sqlerrm);
670: FND_MSG_PUB.add;
671: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
672: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
673: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
674: FND_MSG_PUB.add;
675: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
676: END IF;
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

695:
696: --If the claim updation process failed
697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: x_return_status := l_return_status;
699: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
700: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
701: fnd_message.set_token('ERRNO', sqlcode);
702: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
703: FND_MSG_PUB.add;

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

696: --If the claim updation process failed
697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: x_return_status := l_return_status;
699: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
700: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
701: fnd_message.set_token('ERRNO', sqlcode);
702: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
703: FND_MSG_PUB.add;
704: --Delete the claim numbers from the GT table

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

697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: x_return_status := l_return_status;
699: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
700: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
701: fnd_message.set_token('ERRNO', sqlcode);
702: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
703: FND_MSG_PUB.add;
704: --Delete the claim numbers from the GT table
705: UPDATE DPP_CUSTOMER_CLAIMS_GT

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

698: x_return_status := l_return_status;
699: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
700: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
701: fnd_message.set_token('ERRNO', sqlcode);
702: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
703: FND_MSG_PUB.add;
704: --Delete the claim numbers from the GT table
705: UPDATE DPP_CUSTOMER_CLAIMS_GT
706: SET claim_id = null,

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

761: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));
762:
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: x_return_status := l_return_status;
765: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
766: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
767: fnd_message.set_token('ERRNO', sqlcode);
768: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
769: FND_MSG_PUB.add;

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

762:
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: x_return_status := l_return_status;
765: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
766: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
767: fnd_message.set_token('ERRNO', sqlcode);
768: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
769: FND_MSG_PUB.add;
770: --Update the claim id into the global temp table..

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

763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: x_return_status := l_return_status;
765: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
766: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
767: fnd_message.set_token('ERRNO', sqlcode);
768: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
769: FND_MSG_PUB.add;
770: --Update the claim id into the global temp table..
771: UPDATE DPP_CUSTOMER_CLAIMS_GT

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

764: x_return_status := l_return_status;
765: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
766: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
767: fnd_message.set_token('ERRNO', sqlcode);
768: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
769: FND_MSG_PUB.add;
770: --Update the claim id into the global temp table..
771: UPDATE DPP_CUSTOMER_CLAIMS_GT
772: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')

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

791: FROM ozf_claims
792: WHERE claim_id = l_x_claim_id;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
796: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
797: fnd_message.set_token('ERRNO', sqlcode);
798: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
799: FND_MSG_PUB.add;

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

792: WHERE claim_id = l_x_claim_id;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
796: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
797: fnd_message.set_token('ERRNO', sqlcode);
798: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
799: FND_MSG_PUB.add;
800: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
796: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
797: fnd_message.set_token('ERRNO', sqlcode);
798: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
799: FND_MSG_PUB.add;
800: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
801: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

794: WHEN NO_DATA_FOUND THEN
795: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
796: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
797: fnd_message.set_token('ERRNO', sqlcode);
798: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
799: FND_MSG_PUB.add;
800: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
801: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
802: END IF;

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

801: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
802: END IF;
803: RAISE FND_API.G_EXC_ERROR;
804: WHEN OTHERS THEN
805: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
806: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
807: fnd_message.set_token('ERRNO', sqlcode);
808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;

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

802: END IF;
803: RAISE FND_API.G_EXC_ERROR;
804: WHEN OTHERS THEN
805: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
806: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
807: fnd_message.set_token('ERRNO', sqlcode);
808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;
810: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

803: RAISE FND_API.G_EXC_ERROR;
804: WHEN OTHERS THEN
805: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
806: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
807: fnd_message.set_token('ERRNO', sqlcode);
808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;
810: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

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

804: WHEN OTHERS THEN
805: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
806: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
807: fnd_message.set_token('ERRNO', sqlcode);
808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;
810: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
812: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

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

807: fnd_message.set_token('ERRNO', sqlcode);
808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;
810: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
812: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
813: FND_MSG_PUB.add;
814: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
815: END IF;

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

808: fnd_message.set_token('REASON', sqlerrm);
809: FND_MSG_PUB.add;
810: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
812: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
813: FND_MSG_PUB.add;
814: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
815: END IF;
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

833: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
834:
835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: x_return_status := l_return_status;
837: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
838: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
839: fnd_message.set_token('ERRNO', sqlcode);
840: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
841: FND_MSG_PUB.add;

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

834:
835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: x_return_status := l_return_status;
837: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
838: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
839: fnd_message.set_token('ERRNO', sqlcode);
840: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
841: FND_MSG_PUB.add;
842: ELSE

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

835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: x_return_status := l_return_status;
837: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
838: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
839: fnd_message.set_token('ERRNO', sqlcode);
840: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
841: FND_MSG_PUB.add;
842: ELSE
843: --Get the claim number corresponding to the claim id

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

836: x_return_status := l_return_status;
837: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
838: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
839: fnd_message.set_token('ERRNO', sqlcode);
840: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
841: FND_MSG_PUB.add;
842: ELSE
843: --Get the claim number corresponding to the claim id
844: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP

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

869: to_char(l_txn_hdr_rec.ORG_ID),
870: 'Y');
871: EXCEPTION
872: WHEN OTHERS THEN
873: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
874: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
875: fnd_message.set_token('ERRNO', sqlcode);
876: fnd_message.set_token('REASON', sqlerrm);
877: FND_MSG_PUB.add;

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

870: 'Y');
871: EXCEPTION
872: WHEN OTHERS THEN
873: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
874: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
875: fnd_message.set_token('ERRNO', sqlcode);
876: fnd_message.set_token('REASON', sqlerrm);
877: FND_MSG_PUB.add;
878: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

871: EXCEPTION
872: WHEN OTHERS THEN
873: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
874: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
875: fnd_message.set_token('ERRNO', sqlcode);
876: fnd_message.set_token('REASON', sqlerrm);
877: FND_MSG_PUB.add;
878: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

872: WHEN OTHERS THEN
873: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
874: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
875: fnd_message.set_token('ERRNO', sqlcode);
876: fnd_message.set_token('REASON', sqlerrm);
877: FND_MSG_PUB.add;
878: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;

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

974: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
975:
976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: x_return_status := l_return_status;
978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
979: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
980: fnd_message.set_token('ERRNO', sqlcode);
981: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
982: FND_MSG_PUB.add;

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

975:
976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: x_return_status := l_return_status;
978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
979: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
980: fnd_message.set_token('ERRNO', sqlcode);
981: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
982: FND_MSG_PUB.add;
983: --Insert the claim id into the global temp table..

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

976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: x_return_status := l_return_status;
978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
979: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
980: fnd_message.set_token('ERRNO', sqlcode);
981: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
982: FND_MSG_PUB.add;
983: --Insert the claim id into the global temp table..
984: UPDATE DPP_CUSTOMER_CLAIMS_GT

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

977: x_return_status := l_return_status;
978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
979: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
980: fnd_message.set_token('ERRNO', sqlcode);
981: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
982: FND_MSG_PUB.add;
983: --Insert the claim id into the global temp table..
984: UPDATE DPP_CUSTOMER_CLAIMS_GT
985: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')

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

1005: FROM ozf_claims
1006: WHERE claim_id = l_x_claim_id;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1010: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1011: fnd_message.set_token('ERRNO', sqlcode);
1012: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1013: FND_MSG_PUB.add;

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

1006: WHERE claim_id = l_x_claim_id;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1010: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1011: fnd_message.set_token('ERRNO', sqlcode);
1012: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1013: FND_MSG_PUB.add;
1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1010: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1011: fnd_message.set_token('ERRNO', sqlcode);
1012: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1013: FND_MSG_PUB.add;
1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1015: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

1008: WHEN NO_DATA_FOUND THEN
1009: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1010: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1011: fnd_message.set_token('ERRNO', sqlcode);
1012: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1013: FND_MSG_PUB.add;
1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1015: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1016: END IF;

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

1015: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1016: END IF;
1017: RAISE FND_API.G_EXC_ERROR;
1018: WHEN OTHERS THEN
1019: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1020: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1021: fnd_message.set_token('ERRNO', sqlcode);
1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;

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

1016: END IF;
1017: RAISE FND_API.G_EXC_ERROR;
1018: WHEN OTHERS THEN
1019: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1020: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1021: fnd_message.set_token('ERRNO', sqlcode);
1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;
1024: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1017: RAISE FND_API.G_EXC_ERROR;
1018: WHEN OTHERS THEN
1019: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1020: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1021: fnd_message.set_token('ERRNO', sqlcode);
1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;
1024: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1025: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

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

1018: WHEN OTHERS THEN
1019: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1020: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1021: fnd_message.set_token('ERRNO', sqlcode);
1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;
1024: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1025: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1026: fnd_message.set_token('CLAIM_ID', l_x_claim_id);

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

1021: fnd_message.set_token('ERRNO', sqlcode);
1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;
1024: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1025: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1026: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
1027: FND_MSG_PUB.add;
1028: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1029: END IF;

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

1022: fnd_message.set_token('REASON', sqlerrm);
1023: FND_MSG_PUB.add;
1024: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1025: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1026: fnd_message.set_token('CLAIM_ID', l_x_claim_id);
1027: FND_MSG_PUB.add;
1028: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1029: END IF;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1047: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1048:
1049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: x_return_status := l_return_status;
1051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1052: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1053: fnd_message.set_token('ERRNO', sqlcode);
1054: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1055: FND_MSG_PUB.add;

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

1048:
1049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: x_return_status := l_return_status;
1051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1052: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1053: fnd_message.set_token('ERRNO', sqlcode);
1054: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1055: FND_MSG_PUB.add;
1056: ELSE

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

1049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: x_return_status := l_return_status;
1051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1052: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1053: fnd_message.set_token('ERRNO', sqlcode);
1054: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1055: FND_MSG_PUB.add;
1056: ELSE
1057: --Get the claim number corresponding to the claim id

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

1050: x_return_status := l_return_status;
1051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1052: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1053: fnd_message.set_token('ERRNO', sqlcode);
1054: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
1055: FND_MSG_PUB.add;
1056: ELSE
1057: --Get the claim number corresponding to the claim id
1058: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP

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

1083: to_char(l_txn_hdr_rec.ORG_ID),
1084: 'Y');
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1088: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1089: fnd_message.set_token('ERRNO', sqlcode);
1090: fnd_message.set_token('REASON', sqlerrm);
1091: FND_MSG_PUB.add;

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

1084: 'Y');
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1088: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1089: fnd_message.set_token('ERRNO', sqlcode);
1090: fnd_message.set_token('REASON', sqlerrm);
1091: FND_MSG_PUB.add;
1092: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1088: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1089: fnd_message.set_token('ERRNO', sqlcode);
1090: fnd_message.set_token('REASON', sqlerrm);
1091: FND_MSG_PUB.add;
1092: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1093: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

1086: WHEN OTHERS THEN
1087: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1088: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1089: fnd_message.set_token('ERRNO', sqlcode);
1090: fnd_message.set_token('REASON', sqlerrm);
1091: FND_MSG_PUB.add;
1092: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1093: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1094: END IF;

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

1142: END IF;
1143: END LOOP;
1144: END LOOP;
1145: ELSE
1146: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1147: FND_MESSAGE.set_token('ID', 'Claim Type Flag');
1148: FND_MSG_PUB.add;
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;

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

1143: END LOOP;
1144: END LOOP;
1145: ELSE
1146: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1147: FND_MESSAGE.set_token('ID', 'Claim Type Flag');
1148: FND_MSG_PUB.add;
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151: END LOOP; -- End Loop for DPP Price Increase Enhancement

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

1265: END LOOP;
1266: END IF;
1267: WHEN OTHERS THEN
1268: ROLLBACK TO CREATE_CLAIMS_PVT;
1269: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1270: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1271: fnd_message.set_token('ERRNO', sqlcode);
1272: fnd_message.set_token('REASON', sqlerrm);
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1266: END IF;
1267: WHEN OTHERS THEN
1268: ROLLBACK TO CREATE_CLAIMS_PVT;
1269: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1270: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1271: fnd_message.set_token('ERRNO', sqlcode);
1272: fnd_message.set_token('REASON', sqlerrm);
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1267: WHEN OTHERS THEN
1268: ROLLBACK TO CREATE_CLAIMS_PVT;
1269: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1270: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1271: fnd_message.set_token('ERRNO', sqlcode);
1272: fnd_message.set_token('REASON', sqlerrm);
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1275: THEN

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

1268: ROLLBACK TO CREATE_CLAIMS_PVT;
1269: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1270: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1271: fnd_message.set_token('ERRNO', sqlcode);
1272: fnd_message.set_token('REASON', sqlerrm);
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1275: THEN
1276: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

1367: -- Initialize API return status to sucess
1368: l_return_status := FND_API.G_RET_STS_SUCCESS;
1369:
1370: IF l_txn_hdr_rec.Transaction_number IS NULL THEN
1371: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1372: FND_MESSAGE.set_token('ID', 'Transaction Number');
1373: FND_MSG_PUB.add;
1374: RAISE FND_API.G_EXC_ERROR;
1375: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN

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

1368: l_return_status := FND_API.G_RET_STS_SUCCESS;
1369:
1370: IF l_txn_hdr_rec.Transaction_number IS NULL THEN
1371: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1372: FND_MESSAGE.set_token('ID', 'Transaction Number');
1373: FND_MSG_PUB.add;
1374: RAISE FND_API.G_EXC_ERROR;
1375: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1376: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

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

1372: FND_MESSAGE.set_token('ID', 'Transaction Number');
1373: FND_MSG_PUB.add;
1374: RAISE FND_API.G_EXC_ERROR;
1375: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1376: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1377: FND_MESSAGE.set_token('ID', 'Claim ID');
1378: FND_MSG_PUB.add;
1379: RAISE FND_API.G_EXC_ERROR;
1380: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN

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

1373: FND_MSG_PUB.add;
1374: RAISE FND_API.G_EXC_ERROR;
1375: ELSIF l_txn_hdr_rec.claim_id IS NULL THEN
1376: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1377: FND_MESSAGE.set_token('ID', 'Claim ID');
1378: FND_MSG_PUB.add;
1379: RAISE FND_API.G_EXC_ERROR;
1380: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1381: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

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

1377: FND_MESSAGE.set_token('ID', 'Claim ID');
1378: FND_MSG_PUB.add;
1379: RAISE FND_API.G_EXC_ERROR;
1380: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1381: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1382: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
1383: FND_MSG_PUB.add;
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSE

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

1378: FND_MSG_PUB.add;
1379: RAISE FND_API.G_EXC_ERROR;
1380: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
1381: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1382: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
1383: FND_MSG_PUB.add;
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSE
1386: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';

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

1402: FROM ozf_claims_all
1403: WHERE claim_id = l_txn_hdr_rec.claim_id;
1404: EXCEPTION
1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1407: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1408: fnd_message.set_token('ERRNO', sqlcode);
1409: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1410: FND_MSG_PUB.add;

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

1403: WHERE claim_id = l_txn_hdr_rec.claim_id;
1404: EXCEPTION
1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1407: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1408: fnd_message.set_token('ERRNO', sqlcode);
1409: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1410: FND_MSG_PUB.add;
1411: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1404: EXCEPTION
1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1407: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1408: fnd_message.set_token('ERRNO', sqlcode);
1409: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1410: FND_MSG_PUB.add;
1411: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1412: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1407: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1408: fnd_message.set_token('ERRNO', sqlcode);
1409: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1410: FND_MSG_PUB.add;
1411: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1412: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1413: END IF;

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

1412: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN OTHERS THEN
1416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1417: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1418: fnd_message.set_token('ERRNO', sqlcode);
1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;

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

1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN OTHERS THEN
1416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1417: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1418: fnd_message.set_token('ERRNO', sqlcode);
1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;
1421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN OTHERS THEN
1416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1417: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1418: fnd_message.set_token('ERRNO', sqlcode);
1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;
1421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1422: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

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

1415: WHEN OTHERS THEN
1416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1417: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1418: fnd_message.set_token('ERRNO', sqlcode);
1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;
1421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1422: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1423: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

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

1418: fnd_message.set_token('ERRNO', sqlcode);
1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;
1421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1422: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1423: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1424: FND_MSG_PUB.add;
1425: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1426: END IF;

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

1419: fnd_message.set_token('REASON', sqlerrm);
1420: FND_MSG_PUB.add;
1421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1422: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1423: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1424: FND_MSG_PUB.add;
1425: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1426: END IF;
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1464: AND item_id = l_txn_line_tbl(i).Inventory_Item_Id;
1465:
1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1470: fnd_message.set_token('ERRNO', sqlcode);
1471: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1472: FND_MSG_PUB.add;

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

1465:
1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1470: fnd_message.set_token('ERRNO', sqlcode);
1471: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1472: FND_MSG_PUB.add;
1473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1466: EXCEPTION
1467: WHEN NO_DATA_FOUND THEN
1468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1470: fnd_message.set_token('ERRNO', sqlcode);
1471: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1472: FND_MSG_PUB.add;
1473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

1467: WHEN NO_DATA_FOUND THEN
1468: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1469: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1470: fnd_message.set_token('ERRNO', sqlcode);
1471: fnd_message.set_token('REASON', 'CLAIM LINE DETAILS NOT FOUND');
1472: FND_MSG_PUB.add;
1473: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1475: END IF;

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

1474: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1475: END IF;
1476: RAISE FND_API.G_EXC_ERROR;
1477: WHEN OTHERS THEN
1478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1480: fnd_message.set_token('ERRNO', sqlcode);
1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;

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

1475: END IF;
1476: RAISE FND_API.G_EXC_ERROR;
1477: WHEN OTHERS THEN
1478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1480: fnd_message.set_token('ERRNO', sqlcode);
1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1476: RAISE FND_API.G_EXC_ERROR;
1477: WHEN OTHERS THEN
1478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1480: fnd_message.set_token('ERRNO', sqlcode);
1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1484: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');

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

1477: WHEN OTHERS THEN
1478: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1479: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1480: fnd_message.set_token('ERRNO', sqlcode);
1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1484: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1485: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

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

1480: fnd_message.set_token('ERRNO', sqlcode);
1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1484: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1485: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1486: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1487: FND_MSG_PUB.add;
1488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

1481: fnd_message.set_token('REASON', sqlerrm);
1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1484: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1485: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1486: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1487: FND_MSG_PUB.add;
1488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1489: END IF;

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

1482: FND_MSG_PUB.add;
1483: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1484: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_LINE_DETAILS');
1485: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1486: fnd_message.set_token('ITEM_ID', l_txn_line_tbl(i).Inventory_Item_Id);
1487: FND_MSG_PUB.add;
1488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1489: END IF;
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1550: FROM ozf_claims
1551: WHERE claim_id = l_txn_hdr_rec.claim_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1555: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1556: fnd_message.set_token('ERRNO', sqlcode);
1557: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1558: FND_MSG_PUB.add;

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

1551: WHERE claim_id = l_txn_hdr_rec.claim_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1555: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1556: fnd_message.set_token('ERRNO', sqlcode);
1557: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1558: FND_MSG_PUB.add;
1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1555: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1556: fnd_message.set_token('ERRNO', sqlcode);
1557: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1558: FND_MSG_PUB.add;
1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

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

1553: WHEN NO_DATA_FOUND THEN
1554: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1555: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1556: fnd_message.set_token('ERRNO', sqlcode);
1557: fnd_message.set_token('REASON', 'OBJECT VERSION NUMBER NOT FOUND');
1558: FND_MSG_PUB.add;
1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1561: END IF;

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

1560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1561: END IF;
1562: RAISE FND_API.G_EXC_ERROR;
1563: WHEN OTHERS THEN
1564: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1565: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1566: fnd_message.set_token('ERRNO', sqlcode);
1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;

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

1561: END IF;
1562: RAISE FND_API.G_EXC_ERROR;
1563: WHEN OTHERS THEN
1564: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1565: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1566: fnd_message.set_token('ERRNO', sqlcode);
1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;
1569: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1562: RAISE FND_API.G_EXC_ERROR;
1563: WHEN OTHERS THEN
1564: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1565: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1566: fnd_message.set_token('ERRNO', sqlcode);
1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;
1569: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');

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

1563: WHEN OTHERS THEN
1564: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1565: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1566: fnd_message.set_token('ERRNO', sqlcode);
1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;
1569: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1571: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);

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

1566: fnd_message.set_token('ERRNO', sqlcode);
1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;
1569: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1571: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1572: FND_MSG_PUB.add;
1573: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1574: END IF;

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

1567: fnd_message.set_token('REASON', sqlerrm);
1568: FND_MSG_PUB.add;
1569: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('DPP', 'DPP_CLAIM_INVALID_OBJ_VER_NUM');
1571: fnd_message.set_token('CLAIM_ID', l_txn_hdr_rec.claim_id);
1572: FND_MSG_PUB.add;
1573: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1574: END IF;
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1617: l_api_name
1618: );
1619: x_return_status := l_return_status;
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1622: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1623: fnd_message.set_token('ERRNO', sqlcode);
1624: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1625: FND_MSG_PUB.add;

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

1618: );
1619: x_return_status := l_return_status;
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1622: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1623: fnd_message.set_token('ERRNO', sqlcode);
1624: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1625: FND_MSG_PUB.add;
1626: RAISE FND_API.G_EXC_ERROR;

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

1619: x_return_status := l_return_status;
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1622: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1623: fnd_message.set_token('ERRNO', sqlcode);
1624: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1625: FND_MSG_PUB.add;
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;

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

1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1622: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1623: fnd_message.set_token('ERRNO', sqlcode);
1624: fnd_message.set_token('REASON', 'Error while Updating claim in Trade Management');
1625: FND_MSG_PUB.add;
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;
1628:

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

1684: END LOOP;
1685: END IF;
1686: WHEN OTHERS THEN
1687: ROLLBACK TO UPDATE_CLAIMS_PVT;
1688: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1689: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1690: fnd_message.set_token('ERRNO', sqlcode);
1691: fnd_message.set_token('REASON', sqlerrm);
1692: FND_MSG_PUB.add;

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

1685: END IF;
1686: WHEN OTHERS THEN
1687: ROLLBACK TO UPDATE_CLAIMS_PVT;
1688: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1689: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1690: fnd_message.set_token('ERRNO', sqlcode);
1691: fnd_message.set_token('REASON', sqlerrm);
1692: FND_MSG_PUB.add;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1686: WHEN OTHERS THEN
1687: ROLLBACK TO UPDATE_CLAIMS_PVT;
1688: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1689: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1690: fnd_message.set_token('ERRNO', sqlcode);
1691: fnd_message.set_token('REASON', sqlerrm);
1692: FND_MSG_PUB.add;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1687: ROLLBACK TO UPDATE_CLAIMS_PVT;
1688: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1689: fnd_message.set_token('ROUTINE', 'DPP_CLAIMS_PVT');
1690: fnd_message.set_token('ERRNO', sqlcode);
1691: fnd_message.set_token('REASON', sqlerrm);
1692: FND_MSG_PUB.add;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1695: THEN