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 480: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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