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_ADJUSTMENT_PVT dependencies on OZF_OFFER_ADJ_LINE_PVT

Line 103: OZF_Offer_Adj_Line_PVT.debug_message('Id is :'||p_id );

99: BEGIN
100: l_item_key := p_id ||'_'|| TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
101: l_parameter_list := WF_PARAMETER_LIST_T();
102:
103: OZF_Offer_Adj_Line_PVT.debug_message('Id is :'||p_id );
104: wf_event.AddParameterToList(p_name => 'P_ID',
105: p_value => p_id,
106: p_parameterlist => l_parameter_list);
107: OZF_Offer_Adj_Line_PVT.debug_message('Item Key is :'||l_item_key);

Line 107: OZF_Offer_Adj_Line_PVT.debug_message('Item Key is :'||l_item_key);

103: OZF_Offer_Adj_Line_PVT.debug_message('Id is :'||p_id );
104: wf_event.AddParameterToList(p_name => 'P_ID',
105: p_value => p_id,
106: p_parameterlist => l_parameter_list);
107: OZF_Offer_Adj_Line_PVT.debug_message('Item Key is :'||l_item_key);
108: wf_event.raise( p_event_name => 'oracle.apps.ozf.offer.OfferAdjApproval',
109: p_event_key => l_item_key,
110: p_parameters => l_parameter_list);
111: EXCEPTION

Line 114: OZF_Offer_Adj_Line_PVT.debug_message('Exception in raising business event');

110: p_parameters => l_parameter_list);
111: EXCEPTION
112: WHEN OTHERS THEN
113: RAISE Fnd_Api.g_exc_error;
114: OZF_Offer_Adj_Line_PVT.debug_message('Exception in raising business event');
115: END;
116:
117: -- Hint: Primary key needs to be returned.
118: -- ==============================================================================

Line 204: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

200:
201:
202:
203: -- Debug Message
204: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
205:
206:
207:
208: -- Initialize API return status to SUCCESS

Line 229: -- OZF_Offer_Adj_Line_PVT.debug_message('Private API: offer_adjustment_id: ' || p_offer_adj_rec.offer_adjustment_id || '::l_offer_adjustment_id: '||l_offer_adjustment_id); -- sangara

225: ELSE
226: l_offer_adjustment_id := p_offer_adj_rec.offer_adjustment_id;
227: END IF;
228:
229: -- OZF_Offer_Adj_Line_PVT.debug_message('Private API: offer_adjustment_id: ' || p_offer_adj_rec.offer_adjustment_id || '::l_offer_adjustment_id: '||l_offer_adjustment_id); -- sangara
230:
231: -- =========================================================================
232: -- Validate Environment
233: -- =========================================================================

Line 246: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');

242:
243: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
244: THEN
245: -- Debug message
246: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');
247:
248: -- Invoke validation procedures
249: Validate_offer_adjustment(
250: p_api_version_number => 1.0,

Line 266: OZF_Offer_Adj_Line_PVT.debug_message( 'Private API: Calling create table handler ');

262: END IF;
263:
264:
265: -- Debug Message
266: OZF_Offer_Adj_Line_PVT.debug_message( 'Private API: Calling create table handler ');
267:
268: -- Invoke table handler(OZF_Offer_Adjustment_Pkg.Insert_Row)
269: OZF_Offer_Adjustment_Pkg.Insert_Row(
270: px_offer_adjustment_id => l_offer_adjustment_id,

Line 314: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');

310:
311: -- Standard check for p_commit
312: IF FND_API.to_Boolean( p_commit )
313: THEN
314: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');
315: -- RAISE FND_API.G_EXC_ERROR;
316: COMMIT WORK;
317: END IF;
318:

Line 321: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

317: END IF;
318:
319:
320: -- Debug Message
321: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
322:
323:
324: -- Standard call to get message count and if count is 1, get message info.
325: FND_MSG_PUB.Count_And_Get

Line 520: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

516:
517:
518:
519: -- Debug Message
520: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
521:
522:
523: -- Initialize Object_Version_Number
524: l_object_version_number := p_offer_adj_rec.object_version_number ;

Line 530: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Open Cursor to Select');

526: -- Initialize API return status to SUCCESS
527: x_return_status := FND_API.G_RET_STS_SUCCESS;
528:
529: -- Debug Message
530: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Open Cursor to Select');
531:
532: OPEN c_get_Offer_Adjustment( l_tar_offer_adj_rec.offer_adjustment_id);
533:
534: FETCH c_get_Offer_Adjustment INTO l_ref_offer_adj_rec ;

Line 544: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Close Cursor');

540: RAISE FND_API.G_EXC_ERROR;
541: END IF;
542:
543: -- Debug Message
544: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Close Cursor');
545: CLOSE c_get_Offer_Adjustment;
546:
547:
548: If (l_tar_offer_adj_rec.object_version_number is NULL or

Line 570: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');

566:
567: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
568: THEN
569: -- Debug message
570: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');
571:
572: -- Invoke validation procedures
573: Validate_offer_adjustment(
574: p_api_version_number => 1.0,

Line 636: OZF_Offer_Adj_Line_PVT.debug_message(' l_attr_available_flag ' || l_attr_available_flag);

632: FETCH c_attr_available_flag INTO l_attr_available_flag;
633: CLOSE c_attr_available_flag;
634:
635: raise_event(p_id => p_offer_adj_rec.offer_adjustment_id );
636: OZF_Offer_Adj_Line_PVT.debug_message(' l_attr_available_flag ' || l_attr_available_flag);
637: -- mthumu approve date fix
638: l_new_status_code := 'ACTIVE';
639: l_approve_date := sysdate;
640:

Line 702: OZF_Offer_Adj_Line_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');

698: END IF;
699: END IF;
700: -- end of code mthumu
701: -- Debug Message
702: OZF_Offer_Adj_Line_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
703: -- Invoke table handler(OZF_Offer_Adjustment_Pkg.Update_Row)
704: OZF_Offer_Adjustment_Pkg.Update_Row(
705: p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id,
706: p_effective_date => p_offer_adj_rec.effective_date,

Line 745: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

741: THEN
742: COMMIT WORK;
743: END IF;
744: -- Debug Message
745: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: EXCEPTION
747: WHEN OZF_Utility_PVT.resource_locked THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

Line 859: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

855:
856:
857:
858: -- Debug Message
859: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
860:
861:
862:
863: -- Initialize API return status to SUCCESS

Line 870: OZF_Offer_Adj_Line_PVT.debug_message( 'Private API: Calling delete table handler');

866: --
867: -- Api body
868: --
869: -- Debug Message
870: OZF_Offer_Adj_Line_PVT.debug_message( 'Private API: Calling delete table handler');
871:
872: -- Invoke table handler(OZF_Offer_Adjustment_Pkg.Delete_Row)
873: OZF_Offer_Adjustment_Pkg.Delete_Row(
874: p_offer_adjustment_id => p_offer_adjustment_id,

Line 888: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

884: END IF;
885:
886:
887: -- Debug Message
888: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
889:
890:
891: -- Standard call to get message count and if count is 1, get message info.
892: FND_MSG_PUB.Count_And_Get

Line 994: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

990:
991: BEGIN
992:
993: -- Debug Message
994: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
995:
996:
997: -- Initialize message list if p_init_msg_list is set to TRUE.
998: IF FND_API.to_Boolean( p_init_msg_list )

Line 1029: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');

1025: FND_MSG_PUB.count_and_get(
1026: p_encoded => FND_API.g_false,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data);
1029: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');
1030: EXCEPTION
1031:
1032: WHEN OZF_Utility_PVT.resource_locked THEN
1033: x_return_status := FND_API.g_ret_sts_error;

Line 1117: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');

1113:
1114: BEGIN
1115: x_return_status := FND_API.g_ret_sts_success;
1116: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1117: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1118: --nepanda : fix for bug 9149865
1119: /*l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1120: ' ozf_offer_adjustments_vl ',
1121: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||

Line 1178: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );

1174: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1179:
1180: IF l_dup_effective_dt IS NOT NULL THEN
1181: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1182: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');

Line 1606: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

1602: END IF;
1603:
1604:
1605: -- Debug Message
1606: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
1607:
1608:
1609:
1610: -- Initialize API return status to SUCCESS

Line 1615: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613:
1614: -- Debug Message
1615: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1616:
1617:
1618: -- Standard call to get message count and if count is 1, get message info.
1619: FND_MSG_PUB.Count_And_Get

Line 1692: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');

1688: -- THEN
1689: -- x_return_status := FND_API.G_RET_STS_ERROR;
1690:
1691: -- Debug Message
1692: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1693: -- Standard call to get message count and if count is 1, get message info.
1694: FND_MSG_PUB.Count_And_Get
1695: (p_count => x_msg_count,
1696: p_data => x_msg_data