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_OFFER_MARKET_OPTIONS_PVT dependencies on OZF_VOLUME_OFFER_DISC_PVT

Line 92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);

88: AND group_number = p_group_number); --p_mo_rec.group_number);
89:
90: BEGIN
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);
93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN

Line 95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');

91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);
93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN
97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');
98: x_return_status := FND_API.g_ret_sts_error;
99: END IF;

Line 102: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is : '|| p_validation_mode);

98: x_return_status := FND_API.g_ret_sts_error;
99: END IF;
100: END IF;
101: END IF;
102: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is : '|| p_validation_mode);
103: /*
104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
105: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is1 : '|| p_validation_mode);
106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);

Line 105: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is1 : '|| p_validation_mode);

101: END IF;
102: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is : '|| p_validation_mode);
103: /*
104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
105: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is1 : '|| p_validation_mode);
106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);
107: IF (p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM)
108: AND (p_mo_rec.group_number IS NOT NULL AND p_mo_rec.group_number <> FND_API.G_MISS_NUM)
109: THEN

Line 106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);

102: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is : '|| p_validation_mode);
103: /*
104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
105: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is1 : '|| p_validation_mode);
106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);
107: IF (p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM)
108: AND (p_mo_rec.group_number IS NOT NULL AND p_mo_rec.group_number <> FND_API.G_MISS_NUM)
109: THEN
110: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);

Line 110: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);

106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);
107: IF (p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM)
108: AND (p_mo_rec.group_number IS NOT NULL AND p_mo_rec.group_number <> FND_API.G_MISS_NUM)
109: THEN
110: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);
111: OPEN c_mo_uk(p_mo_rec.offer_id,p_mo_rec.group_number);
112: FETCH c_mo_uk INTO l_dummy;
113: IF ( c_mo_uk%NOTFOUND) THEN
114: NULL;

Line 139: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

135: )
136: IS
137: l_api_name CONSTANT VARCHAR2(30) := 'check_mo_req_items';
138: BEGIN
139: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:

Line 140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);

136: IS
137: l_api_name CONSTANT VARCHAR2(30) := 'check_mo_req_items';
138: BEGIN
139: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:
144: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 479: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

475: FND_MSG_PUB.initialize;
476: END IF;
477:
478: -- Debug Message
479: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
480:
481: -- Initialize API return status to SUCCESS
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:

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

517: END IF;
518: END IF;
519:
520: -- exception
521: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
522:
523: -- Debug Message
524: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
525:

Line 524: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');

520: -- exception
521: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
522:
523: -- Debug Message
524: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get

Line 654: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Debug Message
654: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
655:
656: -- Initialize API return status to SUCCESS
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:

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

736: THEN
737: COMMIT WORK;
738: END IF;
739: -- Debug Message
740: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
741: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
742: -- Standard call to get message count and if count is 1, get message info.
743:
744: FND_MSG_PUB.Count_And_Get

Line 741: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');

737: COMMIT WORK;
738: END IF;
739: -- Debug Message
740: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
741: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
742: -- Standard call to get message count and if count is 1, get message info.
743:
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count,

Line 865: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

861: THEN
862: FND_MSG_PUB.initialize;
863: END IF;
864: -- Debug Message
865: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
866:
867: -- Initialize API return status to SUCCESS
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:

Line 939: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');

935: THEN
936: COMMIT WORK;
937: END IF;
938: -- Debug Message
939: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
940: -- Standard call to get message count and if count is 1, get message info.
941: FND_MSG_PUB.Count_And_Get
942: (p_count => x_msg_count,
943: p_data => x_msg_data