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_QUAL_MARKET_OPTION_PVT dependencies on OZF_UTILITY_PVT

Line 28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);

24: IS
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27:
28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
29: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
30: IF p_qual_mo_rec.offer_market_option_id IS NULL OR p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
31: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
32: x_return_status := FND_API.g_ret_sts_error;

Line 31: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');

27:
28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
29: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
30: IF p_qual_mo_rec.offer_market_option_id IS NULL OR p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
31: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
32: x_return_status := FND_API.g_ret_sts_error;
33: END IF;
34:
35: IF p_qual_mo_rec.qp_qualifier_id IS NULL OR p_qual_mo_rec.qp_qualifier_id = FND_API.G_MISS_NUM THEN

Line 36: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qp_qualifier_id');

32: x_return_status := FND_API.g_ret_sts_error;
33: END IF;
34:
35: IF p_qual_mo_rec.qp_qualifier_id IS NULL OR p_qual_mo_rec.qp_qualifier_id = FND_API.G_MISS_NUM THEN
36: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qp_qualifier_id');
37: x_return_status := FND_API.g_ret_sts_error;
38: END IF;
39:
40: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qualifier_market_option_id');

39:
40: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
41:
42: IF p_qual_mo_rec.qualifier_market_option_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qualifier_market_option_id');
44: x_return_status := FND_API.g_ret_sts_error;
45: END IF;
46:
47: IF p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN

Line 48: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');

44: x_return_status := FND_API.g_ret_sts_error;
45: END IF;
46:
47: IF p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
48: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
49: x_return_status := FND_API.g_ret_sts_error;
50: END IF;
51:
52: IF p_qual_mo_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 53: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');

49: x_return_status := FND_API.g_ret_sts_error;
50: END IF;
51:
52: IF p_qual_mo_rec.object_version_number = FND_API.G_MISS_NUM THEN
53: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
54: x_return_status := FND_API.g_ret_sts_error;
55: END IF;
56:
57: IF p_qual_mo_rec.qp_qualifier_id = FND_API.G_MISS_NUM THEN

Line 58: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qp_qualifier_id');

54: x_return_status := FND_API.g_ret_sts_error;
55: END IF;
56:
57: IF p_qual_mo_rec.qp_qualifier_id = FND_API.G_MISS_NUM THEN
58: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qp_qualifier_id');
59: x_return_status := FND_API.g_ret_sts_error;
60: END IF;
61: END IF;
62:

Line 77: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_qual_mo_rec.offer_market_option_id)) = FND_API.g_false

73: BEGIN
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: IF p_qual_mo_rec.offer_market_option_id IS NOT NULL AND p_qual_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
76: IF p_qual_mo_rec.offer_market_option_id <> -1 THEN
77: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_qual_mo_rec.offer_market_option_id)) = FND_API.g_false
78: THEN
79: OZF_Utility_PVT.Error_Message('OZF_OFFR_MOID_INV');
80: x_return_status := FND_API.g_ret_sts_error;
81: END IF;

Line 79: OZF_Utility_PVT.Error_Message('OZF_OFFR_MOID_INV');

75: IF p_qual_mo_rec.offer_market_option_id IS NOT NULL AND p_qual_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
76: IF p_qual_mo_rec.offer_market_option_id <> -1 THEN
77: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_qual_mo_rec.offer_market_option_id)) = FND_API.g_false
78: THEN
79: OZF_Utility_PVT.Error_Message('OZF_OFFR_MOID_INV');
80: x_return_status := FND_API.g_ret_sts_error;
81: END IF;
82: END IF;
83: END IF;

Line 86: IF ozf_utility_pvt.check_fk_exists('qp_qualifiers','qualifier_id',to_char(p_qual_mo_rec.qp_qualifier_id)) = FND_API.g_false

82: END IF;
83: END IF;
84:
85: IF p_qual_mo_rec.qp_qualifier_id IS NOT NULL AND p_qual_mo_rec.qp_qualifier_id <> FND_API.G_MISS_NUM THEN
86: IF ozf_utility_pvt.check_fk_exists('qp_qualifiers','qualifier_id',to_char(p_qual_mo_rec.qp_qualifier_id)) = FND_API.g_false
87: THEN
88: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_QP_QUAL');
89: x_return_status := FND_API.g_ret_sts_error;
90: END IF;

Line 88: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_QP_QUAL');

84:
85: IF p_qual_mo_rec.qp_qualifier_id IS NOT NULL AND p_qual_mo_rec.qp_qualifier_id <> FND_API.G_MISS_NUM THEN
86: IF ozf_utility_pvt.check_fk_exists('qp_qualifiers','qualifier_id',to_char(p_qual_mo_rec.qp_qualifier_id)) = FND_API.g_false
87: THEN
88: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_QP_QUAL');
89: x_return_status := FND_API.g_ret_sts_error;
90: END IF;
91: END IF;
92:

Line 262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: -- Debug Message
262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
263:
264: -- Initialize API return status to SUCCESS
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: -- check

Line 301: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);

297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300: END IF;
301: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
302:
303: -- Debug Message
304: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
305:

Line 304: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

300: END IF;
301: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
302:
303: -- Debug Message
304: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
305:
306: -- collect message
307:
308: -- Standard call to get message count and if count is 1, get message info.

Line 317: WHEN OZF_Utility_PVT.resource_locked THEN

313: -- exception
314:
315: EXCEPTION
316:
317: WHEN OZF_Utility_PVT.resource_locked THEN
318: x_return_status := FND_API.g_ret_sts_error;
319: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
320:
321: WHEN FND_API.G_EXC_ERROR THEN

Line 319: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

315: EXCEPTION
316:
317: WHEN OZF_Utility_PVT.resource_locked THEN
318: x_return_status := FND_API.g_ret_sts_error;
319: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
320:
321: WHEN FND_API.G_EXC_ERROR THEN
322: ROLLBACK TO validate_qual_mkt_options_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;

Line 437: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: -- Debug Message
437: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
438:
439: -- Initialize API return status to SUCCESS
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:

Line 448: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

444: -- =========================================================================
445:
446: IF FND_GLOBAL.USER_ID IS NULL
447: THEN
448: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:
452: l_qual_mo_rec := p_qual_mo_rec;

Line 511: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);

507: THEN
508: COMMIT WORK;
509: END IF;
510: -- Debug Message
511: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
512: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: -- Standard call to get message count and if count is 1, get message info.
514:
515: FND_MSG_PUB.Count_And_Get

Line 512: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

508: COMMIT WORK;
509: END IF;
510: -- Debug Message
511: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
512: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: -- Standard call to get message count and if count is 1, get message info.
514:
515: FND_MSG_PUB.Count_And_Get
516: (p_count => x_msg_count,

Line 604: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

600: THEN
601: FND_MSG_PUB.initialize;
602: END IF;
603: -- Debug Message
604: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
605:
606: -- Initialize API return status to SUCCESS
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608:

Line 612: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'

608:
609: OPEN c_get_qual_mo( l_tar_qual_mo_rec.qualifier_market_option_id,l_tar_qual_mo_rec.object_version_number);
610: FETCH c_get_qual_mo INTO l_ref_qual_mo_rec ;
611: If ( c_get_qual_mo%NOTFOUND) THEN
612: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
613: , p_token_name => 'INFO'
614: , p_token_value => 'OZF_QUAL_MARKET_OPTIONS') ;
615: RAISE FND_API.G_EXC_ERROR;
616: END IF;

Line 621: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'

617: CLOSE c_get_qual_mo;
618:
619: If (l_tar_qual_mo_rec.object_version_number is NULL or
620: l_tar_qual_mo_rec.object_version_number = FND_API.G_MISS_NUM ) Then
621: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
622: , p_token_name => 'COLUMN'
623: , p_token_value => 'Last_Update_Date') ;
624: RAISE FND_API.G_EXC_ERROR;
625: End if;

Line 628: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'

624: RAISE FND_API.G_EXC_ERROR;
625: End if;
626: -- Check Whether record has been changed by someone else
627: If (l_tar_qual_mo_rec.object_version_number <> l_ref_qual_mo_rec.object_version_number) Then
628: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
629: , p_token_name => 'INFO'
630: , p_token_value => 'Ozf_Market_Options') ;
631: RAISE FND_API.G_EXC_ERROR;
632: End if;

Line 670: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);

666: THEN
667: COMMIT WORK;
668: END IF;
669: -- Debug Message
670: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
671: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
672: -- Standard call to get message count and if count is 1, get message info.
673:
674: FND_MSG_PUB.Count_And_Get

Line 671: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

667: COMMIT WORK;
668: END IF;
669: -- Debug Message
670: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
671: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
672: -- Standard call to get message count and if count is 1, get message info.
673:
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count,

Line 776: WHEN OZF_Utility_PVT.resource_locked THEN

772: -- exception
773:
774: EXCEPTION
775:
776: WHEN OZF_Utility_PVT.resource_locked THEN
777: x_return_status := FND_API.g_ret_sts_error;
778: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
779:
780: WHEN FND_API.G_EXC_ERROR THEN

Line 778: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

774: EXCEPTION
775:
776: WHEN OZF_Utility_PVT.resource_locked THEN
777: x_return_status := FND_API.g_ret_sts_error;
778: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO Delete_qual_market_options_PVT;
782: x_return_status := FND_API.G_RET_STS_ERROR;