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 DPP_CLAIMS_PVT

Line 1: PACKAGE BODY DPP_CLAIMS_PVT AS

1: PACKAGE BODY DPP_CLAIMS_PVT AS
2: /* $Header: dppvclab.pls 120.42 2011/09/13 09:10:13 rvkondur ship $ */
3:
4: -- Package name : DPP_CLAIMS_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_CLAIMS_PVT

1: PACKAGE BODY DPP_CLAIMS_PVT AS
2: /* $Header: dppvclab.pls 120.42 2011/09/13 09:10:13 rvkondur ship $ */
3:
4: -- Package name : DPP_CLAIMS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_CLAIMS_PVT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_CLAIMS_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvclab.pls';
13: ---------------------------------------------------------------------
14: -- PROCEDURE

Line 89: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CLAIMS_PVT.CREATE_CLAIMS';

85: IS
86: l_api_name CONSTANT VARCHAR2(30) := 'Create_Claims';
87: l_api_version CONSTANT NUMBER := 1.0;
88: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
89: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CLAIMS_PVT.CREATE_CLAIMS';
90:
91: l_return_status VARCHAR2(30);
92: l_msg_count NUMBER;
93: l_msg_data VARCHAR2(4000);

Line 95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;

91: l_return_status VARCHAR2(30);
92: l_msg_count NUMBER;
93: l_msg_data VARCHAR2(4000);
94:
95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;

Line 96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;

92: l_msg_count NUMBER;
93: l_msg_data VARCHAR2(4000);
94:
95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
100:

Line 97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;

93: l_msg_data VARCHAR2(4000);
94:
95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
100:
101: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;

Line 98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;

94:
95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
100:
101: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
102: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;

Line 99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;

95: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
96: l_txn_line_mtbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
97: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
98: l_txn_line_pi_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
99: l_txn_line_pd_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type;
100:
101: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
102: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;
103: l_claim_line_pub_tbl_updt OZF_Claim_PUB.claim_line_tbl_type;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1320: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CLAIMS_PVT.UPDATE_CLAIMS';

1316: IS
1317: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claims';
1318: l_api_version CONSTANT NUMBER := 1.0;
1319: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1320: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CLAIMS_PVT.UPDATE_CLAIMS';
1321:
1322: l_return_status VARCHAR2(30);
1323: l_msg_count NUMBER;
1324: l_msg_data VARCHAR2(4000);

Line 1326: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;

1322: l_return_status VARCHAR2(30);
1323: l_msg_count NUMBER;
1324: l_msg_data VARCHAR2(4000);
1325:
1326: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
1327: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
1328:
1329: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
1330: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;

Line 1327: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;

1323: l_msg_count NUMBER;
1324: l_msg_data VARCHAR2(4000);
1325:
1326: l_txn_hdr_rec DPP_CLAIMS_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
1327: l_txn_line_tbl DPP_CLAIMS_PVT.dpp_txn_line_tbl_type := p_txn_line_tbl;
1328:
1329: l_claim_pub_rec OZF_Claim_PUB.claim_rec_type;
1330: l_claim_line_pub_tbl OZF_Claim_PUB.claim_line_tbl_type;
1331:

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 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 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 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 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 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 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 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 1711: END DPP_CLAIMS_PVT;

1707: END LOOP;
1708: END IF;
1709:
1710: END Update_Claims;
1711: END DPP_CLAIMS_PVT;