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 102: OZF_Offer_Adj_Line_PVT.debug_message('Id is :'||p_id );

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

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

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

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

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

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

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

Line 228: -- 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

224: ELSE
225: l_offer_adjustment_id := p_offer_adj_rec.offer_adjustment_id;
226: END IF;
227:
228: -- 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
229:
230: -- =========================================================================
231: -- Validate Environment
232: -- =========================================================================

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1098:
1099: BEGIN
1100: x_return_status := FND_API.g_ret_sts_success;
1101: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1102: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1103: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1104: ' ozf_offer_adjustments_vl ',
1105: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1106: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''

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

1148: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1149: x_return_status := FND_API.g_ret_sts_error;
1150: END IF;
1151:
1152: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1153:
1154: IF l_dup_effective_dt IS NOT NULL THEN
1155: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1156: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');

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

1576: END IF;
1577:
1578:
1579: -- Debug Message
1580: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
1581:
1582:
1583:
1584: -- Initialize API return status to SUCCESS

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

1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586:
1587:
1588: -- Debug Message
1589: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1590:
1591:
1592: -- Standard call to get message count and if count is 1, get message info.
1593: FND_MSG_PUB.Count_And_Get

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

1662: -- THEN
1663: -- x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Debug Message
1666: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1667: -- Standard call to get message count and if count is 1, get message info.
1668: FND_MSG_PUB.Count_And_Get
1669: (p_count => x_msg_count,
1670: p_data => x_msg_data