eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_LINE_PVT dependencies on JTF_PLSQL_API

Line 182: -- 1. p_mode should be JTF_PLSQL_API.g_create/update, or g_delete

178: -- PROCEDURE
179: -- Check_Create_Line_Hist
180: --
181: -- NOTES
182: -- 1. p_mode should be JTF_PLSQL_API.g_create/update, or g_delete
183: -- 2. x_create_hist_flag will be set to 'Y' or 'N'
184: -- 3. p_object_attribute could be 'LINE' or 'LNDT'.
185: --
186: -- HISTORY

Line 279: IF p_mode = JTF_PLSQL_API.g_create THEN

275: x_return_status := FND_API.g_ret_sts_success;
276:
277: ------------------------ start -------------------------
278: -- fetch out old claim line record
279: IF p_mode = JTF_PLSQL_API.g_create THEN
280: l_old_line_rec := null;
281: ELSE
282: IF p_claim_line_rec.claim_line_id <> FND_API.g_miss_num
283: AND p_claim_line_rec.claim_line_id IS NOT NULL THEN

Line 313: IF p_mode = JTF_PLSQL_API.g_create

309: CLOSE c_claim_old_line;
310: END IF;
311: END IF;
312: ------------------------ comparison -------------------------
313: IF p_mode = JTF_PLSQL_API.g_create
314: THEN
315: x_create_hist_flag := 'Y';
316:
317: --In create mode always create a history record.

Line 346: ELSIF p_mode = JTF_PLSQL_API.g_update THEN

342: x_create_hist_flag := 'N';
343: ELSE
344: x_create_hist_flag := 'Y';
345: END IF;
346: ELSIF p_mode = JTF_PLSQL_API.g_update THEN
347: l_compare_result := Compare_Line_Items(
348: p_old_rec => l_old_line_rec
349: ,p_new_rec => l_new_line_rec
350: ,p_object_attribute => p_object_attribute

Line 3621: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3617: END IF;
3618:
3619:
3620: -- item level validation
3621: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3622: Check_Claim_Line_Items(
3623: p_claim_line_rec => l_claim_line_rec,
3624: p_validation_mode => JTF_PLSQL_API.g_update,
3625: x_return_status => l_return_status

Line 3624: p_validation_mode => JTF_PLSQL_API.g_update,

3620: -- item level validation
3621: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3622: Check_Claim_Line_Items(
3623: p_claim_line_rec => l_claim_line_rec,
3624: p_validation_mode => JTF_PLSQL_API.g_update,
3625: x_return_status => l_return_status
3626: );
3627:
3628: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 3673: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

3669: END IF;
3670:
3671: -- record level validation
3672: IF l_claim_line_rec.update_from_tbl_flag = FND_API.g_false THEN
3673: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
3674: Check_Claim_Line_Record(
3675: p_claim_line_rec => p_claim_line_rec,
3676: p_complete_rec => l_claim_line_rec,
3677: x_return_status => l_return_status

Line 4217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

4213: IF OZF_DEBUG_HIGH_ON THEN
4214: OZF_Utility_PVT.debug_message(l_full_name||': check items');
4215: END IF;
4216:
4217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
4218: Check_Claim_Line_Items(
4219: p_claim_line_rec => p_claim_line_rec,
4220: p_validation_mode => JTF_PLSQL_API.g_create,
4221: x_return_status => l_return_status

Line 4220: p_validation_mode => JTF_PLSQL_API.g_create,

4216:
4217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
4218: Check_Claim_Line_Items(
4219: p_claim_line_rec => p_claim_line_rec,
4220: p_validation_mode => JTF_PLSQL_API.g_create,
4221: x_return_status => l_return_status
4222: );
4223:
4224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4235: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

4231: IF OZF_DEBUG_HIGH_ON THEN
4232: OZF_Utility_PVT.debug_message(l_full_name||': check record');
4233: END IF;
4234:
4235: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
4236: Check_Claim_Line_Record(
4237: p_claim_line_rec => p_claim_line_rec,
4238: p_complete_rec => NULL,
4239: x_return_status => l_return_status

Line 4354: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

4350: -- 07/11/2000 mchang Create.
4351: ---------------------------------------------------------------------
4352: PROCEDURE Check_Claim_Line_Uk_Items(
4353: p_claim_line_rec IN claim_line_rec_type
4354: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4355: ,x_return_status OUT NOCOPY VARCHAR2
4356: )
4357: IS
4358: l_valid_flag VARCHAR2(1);

Line 4365: IF p_validation_mode = JTF_PLSQL_API.g_create AND

4361: x_return_status := FND_API.g_ret_sts_success;
4362:
4363: -- For Create_Claim_Line, when claim_line_id is passed in, we need to
4364: -- check if this claim_line_id is unique.
4365: IF p_validation_mode = JTF_PLSQL_API.g_create AND
4366: p_claim_line_rec.claim_line_id IS NOT NULL THEN
4367: IF OZF_Utility_PVT.check_uniqueness(
4368: 'ozf_claim_lines',
4369: 'claim_line_id = ' || p_claim_line_rec.claim_line_id

Line 4531: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

4527: -- 07/11/2000 mchang Create.
4528: ---------------------------------------------------------------------
4529: PROCEDURE Check_Claim_Line_Items(
4530: p_claim_line_rec IN claim_line_rec_type
4531: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4532: ,x_return_status OUT NOCOPY VARCHAR2
4533: )
4534: IS
4535: BEGIN