[Home] [Help]
122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
123: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_STATUS_CODE');
124: FND_MSG_PUB.add;
125: END IF;
126: -- Standard call to get message count and if count=1, get the message
127: FND_MSG_PUB.Count_And_Get (
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data
3408: l_default_action_id number;
3409:
3410: BEGIN
3411:
3412: -- Standard begin of API savepoint
3413: SAVEPOINT Create_Claim_PVT;
3414: -- Standard call to check for call compatibility.
3415: IF NOT FND_API.Compatible_API_Call (
3416: l_api_version,
3410: BEGIN
3411:
3412: -- Standard begin of API savepoint
3413: SAVEPOINT Create_Claim_PVT;
3414: -- Standard call to check for call compatibility.
3415: IF NOT FND_API.Compatible_API_Call (
3416: l_api_version,
3417: p_api_version,
3418: l_api_name,
4281: RAISE FND_API.g_exc_unexpected_error;
4282: END IF;
4283:
4284:
4285: --Standard check of commit
4286: IF FND_API.To_Boolean ( p_commit ) THEN
4287: COMMIT WORK;
4288: END IF;
4289: -- Debug Message
4292: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4293: FND_MSG_PUB.Add;
4294: END IF;
4295:
4296: --Standard call to get message count AND if count=1, get the message
4297: FND_MSG_PUB.Count_And_Get (
4298: p_encoded => FND_API.G_FALSE,
4299: p_count => x_msg_count,
4300: p_data => x_msg_data
4302: EXCEPTION
4303: WHEN FND_API.G_EXC_ERROR THEN
4304: ROLLBACK TO Create_Claim_PVT;
4305: x_return_status := FND_API.G_RET_STS_ERROR;
4306: -- Standard call to get message count AND if count=1, get the message
4307: FND_MSG_PUB.Count_And_Get (
4308: p_encoded => FND_API.G_FALSE,
4309: p_count => x_msg_count,
4310: p_data => x_msg_data
4311: );
4312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4313: ROLLBACK TO Create_Claim_PVT;
4314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4315: -- Standard call to get message count AND if count=1, get the message
4316: FND_MSG_PUB.Count_And_Get (
4317: p_encoded => FND_API.G_FALSE,
4318: p_count => x_msg_count,
4319: p_data => x_msg_data
4323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4326: END IF;
4327: -- Standard call to get message count AND if count=1, get the message
4328: FND_MSG_PUB.Count_And_Get (
4329: p_encoded => FND_API.G_FALSE,
4330: p_count => x_msg_count,
4331: p_data => x_msg_data
4430:
4431: l_index number := 1;
4432: l_rec_num number;
4433: BEGIN
4434: -- Standard begin of API savepoint
4435: SAVEPOINT Val_Delete_Claim_PVT;
4436: -- Standard call to check for call compatibility.
4437: IF NOT FND_API.Compatible_API_Call (
4438: l_api_version,
4432: l_rec_num number;
4433: BEGIN
4434: -- Standard begin of API savepoint
4435: SAVEPOINT Val_Delete_Claim_PVT;
4436: -- Standard call to check for call compatibility.
4437: IF NOT FND_API.Compatible_API_Call (
4438: l_api_version,
4439: p_api_version_number,
4440: l_api_name,
4530: END IF;
4531: RAISE FND_API.g_exc_error;
4532: END IF;
4533:
4534: --Standard check of commit
4535: IF FND_API.To_Boolean ( p_commit ) THEN
4536: COMMIT WORK;
4537: END IF;
4538: -- Debug Message
4541: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4542: FND_MSG_PUB.Add;
4543: END IF;
4544:
4545: --Standard call to get message count AND if count=1, get the message
4546: FND_MSG_PUB.Count_And_Get (
4547: p_encoded => FND_API.G_FALSE,
4548: p_count => x_msg_count,
4549: p_data => x_msg_data
4551: EXCEPTION
4552: WHEN FND_API.G_EXC_ERROR THEN
4553: ROLLBACK TO Val_Delete_Claim_PVT;
4554: x_return_status := FND_API.G_RET_STS_ERROR;
4555: -- Standard call to get message count AND if count=1, get the message
4556: FND_MSG_PUB.Count_And_Get (
4557: p_encoded => FND_API.G_FALSE,
4558: p_count => x_msg_count,
4559: p_data => x_msg_data
4560: );
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: ROLLBACK TO Val_Delete_Claim_PVT;
4563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564: -- Standard call to get message count AND if count=1, get the message
4565: FND_MSG_PUB.Count_And_Get (
4566: p_encoded => FND_API.G_FALSE,
4567: p_count => x_msg_count,
4568: p_data => x_msg_data
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4575: END IF;
4576: -- Standard call to get message count AND if count=1, get the message
4577: FND_MSG_PUB.Count_And_Get (
4578: p_encoded => FND_API.G_FALSE,
4579: p_count => x_msg_count,
4580: p_data => x_msg_data
4669:
4670: l_rec_num number;
4671: --
4672: BEGIN
4673: -- Standard begin of API savepoint
4674: SAVEPOINT Delete_Claim_PVT;
4675: -- Standard call to check for call compatibility.
4676: IF NOT FND_API.Compatible_API_Call (
4677: l_api_version,
4671: --
4672: BEGIN
4673: -- Standard begin of API savepoint
4674: SAVEPOINT Delete_Claim_PVT;
4675: -- Standard call to check for call compatibility.
4676: IF NOT FND_API.Compatible_API_Call (
4677: l_api_version,
4678: p_api_version_number,
4679: l_api_name,
4827: END IF;
4828: RAISE FND_API.g_exc_error;
4829: END IF;
4830:
4831: --Standard check of commit
4832: IF FND_API.To_Boolean ( p_commit ) THEN
4833: COMMIT WORK;
4834: END IF;
4835:
4839: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4840: FND_MSG_PUB.Add;
4841: END IF;
4842:
4843: --Standard call to get message count and if count=1, get the message
4844: FND_MSG_PUB.Count_And_Get (
4845: p_encoded => FND_API.G_FALSE,
4846: p_count => x_msg_count,
4847: p_data => x_msg_data
4849: EXCEPTION
4850: WHEN FND_API.G_EXC_ERROR THEN
4851: ROLLBACK TO Delete_Claim_PVT;
4852: x_return_status := FND_API.G_RET_STS_ERROR;
4853: -- Standard call to get message count and if count=1, get the message
4854: FND_MSG_PUB.Count_And_Get (
4855: p_encoded => FND_API.G_FALSE,
4856: p_count => x_msg_count,
4857: p_data => x_msg_data
4858: );
4859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4860: ROLLBACK TO Delete_Claim_PVT;
4861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4862: -- Standard call to get message count and if count=1, get the message
4863: FND_MSG_PUB.Count_And_Get (
4864: p_encoded => FND_API.G_FALSE,
4865: p_count => x_msg_count,
4866: p_data => x_msg_data
4870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4871: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4872: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4873: END IF;
4874: -- Standard call to get message count and if count=1, get the message
4875: FND_MSG_PUB.Count_And_Get (
4876: p_encoded => FND_API.G_FALSE,
4877: p_count => x_msg_count,
4878: p_data => x_msg_data
5014: where claim_id = p_id;
5015:
5016: l_user_status_id number;
5017: BEGIN
5018: -- Standard begin of API savepoint
5019: SAVEPOINT Create_Claim_Hist_PVT;
5020:
5021: -- Standard call to check for call compatibility.
5022: IF NOT FND_API.Compatible_API_Call (
5017: BEGIN
5018: -- Standard begin of API savepoint
5019: SAVEPOINT Create_Claim_Hist_PVT;
5020:
5021: -- Standard call to check for call compatibility.
5022: IF NOT FND_API.Compatible_API_Call (
5023: l_api_version,
5024: p_api_version,
5025: l_api_name,
5093: END IF;
5094: --END IF; (uday)
5095: x_need_to_create := l_needed_to_create;
5096: x_claim_history_id := l_claim_history_id;
5097: --Standard check of commit
5098: IF FND_API.To_Boolean ( p_commit ) THEN
5099: COMMIT WORK;
5100: END IF;
5101: -- Debug Message
5103: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5104: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
5105: FND_MSG_PUB.Add;
5106: END IF;
5107: --Standard call to get message count and if count=1, get the message
5108: FND_MSG_PUB.Count_And_Get (
5109: p_encoded => FND_API.G_FALSE,
5110: p_count => x_msg_count,
5111: p_data => x_msg_data
5113: EXCEPTION
5114: WHEN FND_API.G_EXC_ERROR THEN
5115: ROLLBACK TO Create_Claim_Hist_PVT;
5116: x_return_status := FND_API.G_RET_STS_ERROR;
5117: -- Standard call to get message count and if count=1, get the message
5118: FND_MSG_PUB.Count_And_Get (
5119: p_encoded => FND_API.G_FALSE,
5120: p_count => x_msg_count,
5121: p_data => x_msg_data
5122: );
5123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5124: ROLLBACK TO Create_Claim_Hist_PVT;
5125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5126: -- Standard call to get message count and if count=1, get the message
5127: FND_MSG_PUB.Count_And_Get (
5128: p_encoded => FND_API.G_FALSE,
5129: p_count => x_msg_count,
5130: p_data => x_msg_data
5135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5136: THEN
5137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5138: END IF;
5139: -- Standard call to get message count and if count=1, get the message
5140: FND_MSG_PUB.Count_And_Get (
5141: p_encoded => FND_API.G_FALSE,
5142: p_count => x_msg_count,
5143: p_data => x_msg_data
5378: FROM ozf_claims_all
5379: WHERE claim_id = p_claim_id;
5380: --
5381: BEGIN
5382: -- Standard begin of API savepoint
5383: -- IF ( NOT G_UPDATE_CALLED ) THEN
5384: SAVEPOINT Update_Claim_PVT;
5385: -- G_UPDATE_CALLED := true;
5386: -- END IF;
5383: -- IF ( NOT G_UPDATE_CALLED ) THEN
5384: SAVEPOINT Update_Claim_PVT;
5385: -- G_UPDATE_CALLED := true;
5386: -- END IF;
5387: -- Standard call to check for call compatibility.
5388: IF NOT FND_API.Compatible_API_Call (
5389: l_api_version,
5390: p_api_version,
5391: l_api_name,
6629:
6630: -- pass the new version number
6631: x_object_version_number := l_object_version_number;
6632:
6633: --Standard check of commit
6634: IF FND_API.To_Boolean ( p_commit ) THEN
6635: COMMIT WORK;
6636: END IF;
6637: -- Debug Message
6639: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6640: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6641: FND_MSG_PUB.Add;
6642: END IF;
6643: --Standard call to get message count and if count=1, get the message
6644: FND_MSG_PUB.Count_And_Get (
6645: p_encoded => FND_API.G_FALSE,
6646: p_count => x_msg_count,
6647: p_data => x_msg_data
6651: -- IF ( NOT G_UPDATE_CALLED ) THEN
6652: ROLLBACK TO Update_Claim_PVT;
6653: -- END IF;
6654: x_return_status := FND_API.G_RET_STS_ERROR;
6655: -- Standard call to get message count and if count=1, get the message
6656: FND_MSG_PUB.Count_And_Get (
6657: p_encoded => FND_API.G_FALSE,
6658: p_count => x_msg_count,
6659: p_data => x_msg_data
6662: -- IF ( NOT G_UPDATE_CALLED ) THEN
6663: ROLLBACK TO Update_Claim_PVT;
6664: -- END IF;
6665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6666: -- Standard call to get message count and if count=1, get the message
6667: FND_MSG_PUB.Count_And_Get (
6668: p_encoded => FND_API.G_FALSE,
6669: p_count => x_msg_count,
6670: p_data => x_msg_data
6677: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6678: THEN
6679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6680: END IF;
6681: -- Standard call to get message count and if count=1, get the message
6682: FND_MSG_PUB.Count_And_Get (
6683: p_encoded => FND_API.G_FALSE,
6684: p_count => x_msg_count,
6685: p_data => x_msg_data
6815: WHERE cust_account_id = p_cust_id
6816: AND related_cust_account_id = p_rel_cust_id;
6817:
6818: BEGIN
6819: -- Standard begin of API savepoint
6820: SAVEPOINT Validate_Claim_PVT;
6821: -- Standard call to check for call compatibility.
6822: IF NOT FND_API.Compatible_API_Call (
6823: l_api_version,
6817:
6818: BEGIN
6819: -- Standard begin of API savepoint
6820: SAVEPOINT Validate_Claim_PVT;
6821: -- Standard call to check for call compatibility.
6822: IF NOT FND_API.Compatible_API_Call (
6823: l_api_version,
6824: p_api_version,
6825: l_api_name,
7169: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7170: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7171: FND_MSG_PUB.Add;
7172: END IF;
7173: --Standard call to get message count and if count=1, get the message
7174: FND_MSG_PUB.Count_And_Get (
7175: p_encoded => FND_API.G_FALSE,
7176: p_count => x_msg_count,
7177: p_data => x_msg_data
7179: EXCEPTION
7180: WHEN FND_API.G_EXC_ERROR THEN
7181: ROLLBACK TO Validate_Claim_PVT;
7182: x_return_status := FND_API.G_RET_STS_ERROR;
7183: -- Standard call to get message count and if count=1, get the message
7184: FND_MSG_PUB.Count_And_Get (
7185: p_encoded => FND_API.G_FALSE,
7186: p_count => x_msg_count,
7187: p_data => x_msg_data
7188: );
7189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7190: ROLLBACK TO Validate_Claim_PVT;
7191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7192: -- Standard call to get message count and if count=1, get the message
7193: FND_MSG_PUB.Count_And_Get (
7194: p_encoded => FND_API.G_FALSE,
7195: p_count => x_msg_count,
7196: p_data => x_msg_data
7201: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7202: THEN
7203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7204: END IF;
7205: -- Standard call to get message count and if count=1, get the message
7206: FND_MSG_PUB.Count_And_Get (
7207: p_encoded => FND_API.G_FALSE,
7208: p_count => x_msg_count,
7209: p_data => x_msg_data
7283:
7284: l_number_of_cust number;
7285:
7286: BEGIN
7287: -- Standard begin of API savepoint
7288: SAVEPOINT Check_Clm_Cmn_Element_PVT;
7289: -- Standard call to check for call compatibility.
7290: IF NOT FND_API.Compatible_API_Call (
7291: l_api_version,
7285:
7286: BEGIN
7287: -- Standard begin of API savepoint
7288: SAVEPOINT Check_Clm_Cmn_Element_PVT;
7289: -- Standard call to check for call compatibility.
7290: IF NOT FND_API.Compatible_API_Call (
7291: l_api_version,
7292: p_api_version,
7293: l_api_name,
7427: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7428: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7429: FND_MSG_PUB.Add;
7430: END IF;
7431: --Standard call to get message count and if count=1, get the message
7432: FND_MSG_PUB.Count_And_Get (
7433: p_encoded => FND_API.G_FALSE,
7434: p_count => x_msg_count,
7435: p_data => x_msg_data
7437: EXCEPTION
7438: WHEN FND_API.G_EXC_ERROR THEN
7439: ROLLBACK TO Check_Clm_Cmn_Element_PVT;
7440: x_return_status := FND_API.G_RET_STS_ERROR;
7441: -- Standard call to get message count and if count=1, get the message
7442: FND_MSG_PUB.Count_And_Get (
7443: p_encoded => FND_API.G_FALSE,
7444: p_count => x_msg_count,
7445: p_data => x_msg_data
7446: );
7447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7448: ROLLBACK TO Check_Clm_Cmn_Element_PVT;
7449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7450: -- Standard call to get message count and if count=1, get the message
7451: FND_MSG_PUB.Count_And_Get (
7452: p_encoded => FND_API.G_FALSE,
7453: p_count => x_msg_count,
7454: p_data => x_msg_data
7459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7460: THEN
7461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7462: END IF;
7463: -- Standard call to get message count and if count=1, get the message
7464: FND_MSG_PUB.Count_And_Get (
7465: p_encoded => FND_API.G_FALSE,
7466: p_count => x_msg_count,
7467: p_data => x_msg_data
7511: l_default_curr_code varchar2(30):= fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
7512: l_claim_id number;
7513: l_err_row number:=0;
7514: BEGIN
7515: -- Standard begin of API savepoint
7516: SAVEPOINT Create_Claim_Tbl_PVT;
7517: -- Standard call to check for call compatibility.
7518: IF NOT FND_API.Compatible_API_Call (
7519: l_api_version,
7513: l_err_row number:=0;
7514: BEGIN
7515: -- Standard begin of API savepoint
7516: SAVEPOINT Create_Claim_Tbl_PVT;
7517: -- Standard call to check for call compatibility.
7518: IF NOT FND_API.Compatible_API_Call (
7519: l_api_version,
7520: p_api_version,
7521: l_api_name,
7607: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7608: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7609: FND_MSG_PUB.Add;
7610: END IF;
7611: --Standard call to get message count and if count=1, get the message
7612: FND_MSG_PUB.Count_And_Get (
7613: p_encoded => FND_API.G_FALSE,
7614: p_count => x_msg_count,
7615: p_data => x_msg_data
7623: FND_MESSAGE.Set_Token('ROW',l_err_row);
7624: FND_MSG_PUB.Add;
7625: END IF;
7626: */
7627: -- Standard call to get message count and if count=1, get the message
7628: FND_MSG_PUB.Count_And_Get (
7629: p_encoded => FND_API.G_FALSE,
7630: p_count => x_msg_count,
7631: p_data => x_msg_data
7638: FND_MESSAGE.Set_Token('ROW',l_err_row);
7639: FND_MSG_PUB.Add;
7640: END IF;
7641: */
7642: -- Standard call to get message count and if count=1, get the message
7643: FND_MSG_PUB.Count_And_Get (
7644: p_encoded => FND_API.G_FALSE,
7645: p_count => x_msg_count,
7646: p_data => x_msg_data
7653: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_TBL_ERR');
7654: FND_MESSAGE.Set_Token('ROW',l_err_row);
7655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7656: END IF;
7657: */ -- Standard call to get message count and if count=1, get the message
7658: FND_MSG_PUB.Count_And_Get (
7659: p_encoded => FND_API.G_FALSE,
7660: p_count => x_msg_count,
7661: p_data => x_msg_data
7712: l_default_curr_code varchar2(30):= fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
7713: l_claim_id number;
7714: l_err_row number:=0;
7715: BEGIN
7716: -- Standard begin of API savepoint
7717: SAVEPOINT Update_Claim_Tbl_PVT;
7718: -- Standard call to check for call compatibility.
7719: IF NOT FND_API.Compatible_API_Call (
7720: l_api_version,
7714: l_err_row number:=0;
7715: BEGIN
7716: -- Standard begin of API savepoint
7717: SAVEPOINT Update_Claim_Tbl_PVT;
7718: -- Standard call to check for call compatibility.
7719: IF NOT FND_API.Compatible_API_Call (
7720: l_api_version,
7721: p_api_version,
7722: l_api_name,
7788: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7789: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7790: FND_MSG_PUB.Add;
7791: END IF;
7792: --Standard call to get message count and if count=1, get the message
7793: FND_MSG_PUB.Count_And_Get (
7794: p_encoded => FND_API.G_FALSE,
7795: p_count => x_msg_count,
7796: p_data => x_msg_data
7803: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_TBL_ERR');
7804: FND_MESSAGE.Set_Token('ROW',l_err_row);
7805: FND_MSG_PUB.Add;
7806: END IF;
7807: -- Standard call to get message count and if count=1, get the message
7808: FND_MSG_PUB.Count_And_Get (
7809: p_encoded => FND_API.G_FALSE,
7810: p_count => x_msg_count,
7811: p_data => x_msg_data
7817: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_TBL_ERR');
7818: FND_MESSAGE.Set_Token('ROW',l_err_row);
7819: FND_MSG_PUB.Add;
7820: END IF;
7821: -- Standard call to get message count and if count=1, get the message
7822: FND_MSG_PUB.Count_And_Get (
7823: p_encoded => FND_API.G_FALSE,
7824: p_count => x_msg_count,
7825: p_data => x_msg_data
7831: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_TBL_ERR');
7832: FND_MESSAGE.Set_Token('ROW',l_err_row);
7833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7834: END IF;
7835: -- Standard call to get message count and if count=1, get the message
7836: FND_MSG_PUB.Count_And_Get (
7837: p_encoded => FND_API.G_FALSE,
7838: p_count => x_msg_count,
7839: p_data => x_msg_data