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

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

87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
92:
93:
94: -- Initialize API return status to SUCCESS
95: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

117: -- =========================================================================
118:
119: IF FND_GLOBAL.User_Id IS NULL
120: THEN
121: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124:
125: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 128: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Backdate');

124:
125: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
126: THEN
127: -- Debug message
128: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Backdate');
129:
130: -- Invoke validation procedures
131: Validate_offer_backdate(
132: p_api_version_number => 1.0,

Line 148: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

144: END IF;
145:
146:
147: -- Debug Message
148: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
149:
150: -- Invoke table handler(ozf_OFFER_ADJUSTMENTS_PKG.Insert_Row)
151: ozf_OFFER_ADJUSTMENTS_PKG.Insert_Row(
152: px_offer_adjustment_id => l_offer_adjustment_id,

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

181: END IF;
182:
183:
184: -- Debug Message
185: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
186:
187: -- Standard call to get message count and if count is 1, get message info.
188: FND_MSG_PUB.Count_And_Get
189: (p_count => x_msg_count,

Line 194: WHEN OZF_Utility_PVT.resource_locked THEN

190: p_data => x_msg_data
191: );
192: EXCEPTION
193:
194: WHEN OZF_Utility_PVT.resource_locked THEN
195: x_return_status := FND_API.g_ret_sts_error;
196: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
197:
198: WHEN FND_API.G_EXC_ERROR THEN

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

192: EXCEPTION
193:
194: WHEN OZF_Utility_PVT.resource_locked THEN
195: x_return_status := FND_API.g_ret_sts_error;
196: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
197:
198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO CREATE_Offer_Backdate_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;

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

288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: -- Debug Message
292: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
293:
294:
295: -- Initialize API return status to SUCCESS
296: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 299: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

295: -- Initialize API return status to SUCCESS
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
298: -- Debug Message
299: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
300:
301: /*
302: OPEN c_get_Offer_Backdate( l_tar_offer_backdate_rec.offer_adjustment_id);
303:

Line 307: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

303:
304: FETCH c_get_Offer_Backdate INTO l_ref_offer_backdate_rec ;
305:
306: If ( c_get_Offer_Backdate%NOTFOUND) THEN
307: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
308: p_token_name => 'INFO',
309: p_token_value => 'Offer_Backdate') ;
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;

Line 313: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

309: p_token_value => 'Offer_Backdate') ;
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312: -- Debug Message
313: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
314: CLOSE c_get_Offer_Backdate;
315: */
316:
317:

Line 320: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

316:
317:
318: If (l_tar_offer_backdate_rec.object_version_number is NULL or
319: l_tar_offer_backdate_rec.object_version_number = FND_API.G_MISS_NUM ) Then
320: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
321: p_token_name => 'COLUMN',
322: p_token_value => 'Last_Update_Date') ;
323: raise FND_API.G_EXC_ERROR;
324: End if;

Line 327: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

323: raise FND_API.G_EXC_ERROR;
324: End if;
325: -- Check Whether record has been changed by someone else
326: If (l_tar_offer_backdate_rec.object_version_number <> l_ref_offer_backdate_rec.object_version_number) Then
327: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
328: p_token_name => 'INFO',
329: p_token_value => 'Offer_Backdate') ;
330: raise FND_API.G_EXC_ERROR;
331: End if;

Line 335: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Backdate');

331: End if;
332: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
333: THEN
334: -- Debug message
335: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Backdate');
336:
337: -- Invoke validation procedures
338: Validate_offer_backdate(
339: p_api_version_number => 1.0,

Line 376: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

372: ,p_object_version_number =>p_offer_backdate_rec.object_version_number
373: ,p_orig_stat_id => 0
374: ,p_new_stat_id => 0
375: ,p_reject_stat_id => 0
376: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
377: ,p_notes_from_requester => p_offer_backdate_rec.comments
378: ,p_workflowprocess => 'OZFGAPP'
379: ,p_item_type => 'OZFGAPP');
380:

Line 390: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

386:
387:
388:
389: -- Debug Message
390: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
391:
392: -- Invoke table handler(ozf_OFFER_ADJUSTMENTS_PKG.Update_Row)
393: ozf_OFFER_ADJUSTMENTS_PKG.Update_Row(
394: p_offer_adjustment_id => p_offer_backdate_rec.offer_adjustment_id,

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

419: END IF;
420:
421:
422: -- Debug Message
423: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
424:
425: -- Standard call to get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count,

Line 432: WHEN OZF_Utility_PVT.resource_locked THEN

428: p_data => x_msg_data
429: );
430: EXCEPTION
431:
432: WHEN OZF_Utility_PVT.resource_locked THEN
433: x_return_status := FND_API.g_ret_sts_error;
434: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
435:
436: WHEN FND_API.G_EXC_ERROR THEN

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

430: EXCEPTION
431:
432: WHEN OZF_Utility_PVT.resource_locked THEN
433: x_return_status := FND_API.g_ret_sts_error;
434: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
435:
436: WHEN FND_API.G_EXC_ERROR THEN
437: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
438: x_return_status := FND_API.G_RET_STS_ERROR;

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

505: FND_MSG_PUB.initialize;
506: END IF;
507:
508: -- Debug Message
509: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
510:
511:
512: -- Initialize API return status to SUCCESS
513: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 519: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

515: --
516: -- Api body
517: --
518: -- Debug Message
519: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
520:
521: -- Invoke table handler(ozf_OFFER_ADJUSTMENTS_PKG.Delete_Row)
522: ozf_OFFER_ADJUSTMENTS_PKG.Delete_Row(
523: p_OFFER_ADJUSTMENT_ID => p_OFFER_ADJUSTMENT_ID);

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

532: END IF;
533:
534:
535: -- Debug Message
536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
537:
538: -- Standard call to get message count and if count is 1, get message info.
539: FND_MSG_PUB.Count_And_Get
540: (p_count => x_msg_count,

Line 545: WHEN OZF_Utility_PVT.resource_locked THEN

541: p_data => x_msg_data
542: );
543: EXCEPTION
544:
545: WHEN OZF_Utility_PVT.resource_locked THEN
546: x_return_status := FND_API.g_ret_sts_error;
547: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
548:
549: WHEN FND_API.G_EXC_ERROR THEN

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

543: EXCEPTION
544:
545: WHEN OZF_Utility_PVT.resource_locked THEN
546: x_return_status := FND_API.g_ret_sts_error;
547: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
548:
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO DELETE_Offer_Backdate_PVT;
551: x_return_status := FND_API.G_RET_STS_ERROR;

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

611:
612: BEGIN
613:
614: -- Debug Message
615: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list )
619: THEN

Line 639: OZF_Utility_PVT.debug_message(l_full_name||': start');

635:
636:
637: ------------------------ lock -------------------------
638:
639: OZF_Utility_PVT.debug_message(l_full_name||': start');
640: OPEN c_Offer_Backdate;
641:
642: FETCH c_Offer_Backdate INTO l_OFFER_ADJUSTMENT_ID;
643:

Line 660: OZF_Utility_PVT.debug_message(l_full_name ||': end');

656: FND_MSG_PUB.count_and_get(
657: p_encoded => FND_API.g_false,
658: p_count => x_msg_count,
659: p_data => x_msg_data);
660: OZF_Utility_PVT.debug_message(l_full_name ||': end');
661: EXCEPTION
662:
663: WHEN OZF_Utility_PVT.resource_locked THEN
664: x_return_status := FND_API.g_ret_sts_error;

Line 663: WHEN OZF_Utility_PVT.resource_locked THEN

659: p_data => x_msg_data);
660: OZF_Utility_PVT.debug_message(l_full_name ||': end');
661: EXCEPTION
662:
663: WHEN OZF_Utility_PVT.resource_locked THEN
664: x_return_status := FND_API.g_ret_sts_error;
665: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
666:
667: WHEN FND_API.G_EXC_ERROR THEN

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

661: EXCEPTION
662:
663: WHEN OZF_Utility_PVT.resource_locked THEN
664: x_return_status := FND_API.g_ret_sts_error;
665: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
666:
667: WHEN FND_API.G_EXC_ERROR THEN
668: ROLLBACK TO LOCK_Offer_Backdate_PVT;
669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 713: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

709:
710: BEGIN
711: x_return_status := FND_API.g_ret_sts_success;
712: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
713: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
714: 'OZF_OFFER_ADJUSTMENTS_B',
715: 'OFFER_ADJUSTMENT_ID = ''' || p_offer_backdate_rec.OFFER_ADJUSTMENT_ID ||''''
716: );
717: ELSE

Line 718: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

714: 'OZF_OFFER_ADJUSTMENTS_B',
715: 'OFFER_ADJUSTMENT_ID = ''' || p_offer_backdate_rec.OFFER_ADJUSTMENT_ID ||''''
716: );
717: ELSE
718: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
719: 'OZF_OFFER_ADJUSTMENTS_B',
720: 'OFFER_ADJUSTMENT_ID = ''' || p_offer_backdate_rec.OFFER_ADJUSTMENT_ID ||
721: ''' AND OFFER_ADJUSTMENT_ID <> ' || p_offer_backdate_rec.OFFER_ADJUSTMENT_ID
722: );

Line 726: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_ID_DUPLICATE');

722: );
723: END IF;
724:
725: IF l_valid_flag = FND_API.g_false THEN
726: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_ID_DUPLICATE');
727: x_return_status := FND_API.g_ret_sts_error;
728: RETURN;
729: END IF;
730:

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

1036: END IF;
1037:
1038:
1039: -- Debug Message
1040: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1041:
1042:
1043: -- Initialize API return status to SUCCESS
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046:
1047: -- Debug Message
1048: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1049:
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: (p_count => x_msg_count,

Line 1057: WHEN OZF_Utility_PVT.resource_locked THEN

1053: p_data => x_msg_data
1054: );
1055: EXCEPTION
1056:
1057: WHEN OZF_Utility_PVT.resource_locked THEN
1058: x_return_status := FND_API.g_ret_sts_error;
1059: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1060:
1061: WHEN FND_API.G_EXC_ERROR THEN

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

1055: EXCEPTION
1056:
1057: WHEN OZF_Utility_PVT.resource_locked THEN
1058: x_return_status := FND_API.g_ret_sts_error;
1059: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1060:
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: ROLLBACK TO VALIDATE_Offer_Backdate_;
1063: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1122: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1118: -- THEN
1119: -- x_return_status := FND_API.G_RET_STS_ERROR;
1120:
1121: -- Debug Message
1122: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get
1125: (p_count => x_msg_count,
1126: p_data => x_msg_data

Line 1373: ozf_utility_pvt.debug_message('inside process new adjustments');

1369: l_dummy NUMBER;
1370: -- julou end
1371: BEGIN
1372:
1373: ozf_utility_pvt.debug_message('inside process new adjustments');
1374: IF Fnd_Api.to_boolean(p_init_msg_list)
1375: THEN
1376:
1377: Fnd_Msg_Pub.initialize;

Line 1407: ozf_utility_pvt.debug_message('offer_type is '||l_offer_type);

1403:
1404: OPEN c_effectiveDate(p_offer_adjustment_id);
1405: FETCH c_effectiveDate INTO l_effectiveDate;
1406: CLOSE c_effectiveDate;
1407: ozf_utility_pvt.debug_message('offer_type is '||l_offer_type);
1408: IF l_offer_type IN ('OID', 'ACCRUAL', 'OFF_INVOICE', 'ORDER', 'DEAL','VOLUME_OFFER') THEN
1409: FOR l_adj_line IN c_adj_lines LOOP
1410: -- initialize
1411: l_qp_line_detail := NULL;

Line 1672: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');

1668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1669: END IF;
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
1673: -- create new discont products
1674: DECLARE
1675: CURSOR C_ADJ_PROD(p_adjustment_id NUMBER) IS
1676: SELECT decode(apply_discount_flag,'N',decode(include_volume_flag,'N','Y','N'),'N') excluder_flag

Line 1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);

1695: l_vo_prod_rec.product_attribute := l_adj_prod.product_attribute;
1696: l_vo_prod_rec.product_attr_value := l_adj_prod.product_attr_value;
1697: l_vo_prod_rec.apply_discount_flag := l_adj_prod.apply_discount_flag;
1698: l_vo_prod_rec.include_volume_flag := l_adj_prod.include_volume_flag;
1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);
1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);

Line 1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);

1696: l_vo_prod_rec.product_attr_value := l_adj_prod.product_attr_value;
1697: l_vo_prod_rec.apply_discount_flag := l_adj_prod.apply_discount_flag;
1698: l_vo_prod_rec.include_volume_flag := l_adj_prod.include_volume_flag;
1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);
1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);

Line 1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);

1697: l_vo_prod_rec.apply_discount_flag := l_adj_prod.apply_discount_flag;
1698: l_vo_prod_rec.include_volume_flag := l_adj_prod.include_volume_flag;
1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);
1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);

Line 1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);

1698: l_vo_prod_rec.include_volume_flag := l_adj_prod.include_volume_flag;
1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);
1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);
1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);

Line 1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);

1699: ozf_utility_pvt.debug_message('Excluder Flag :'||l_vo_prod_rec.excluder_flag);
1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);
1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);
1707: OZF_Volume_Offer_disc_PVT.Create_vo_product(

Line 1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);

1700: ozf_utility_pvt.debug_message('Offer Discount Line Id :'||l_vo_prod_rec.offer_discount_line_id);
1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);
1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);
1707: OZF_Volume_Offer_disc_PVT.Create_vo_product(
1708: p_api_version_number => 1.0

Line 1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);

1701: ozf_utility_pvt.debug_message('Offer Id :'||l_vo_prod_rec.offer_id);
1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);
1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);
1707: OZF_Volume_Offer_disc_PVT.Create_vo_product(
1708: p_api_version_number => 1.0
1709: , p_init_msg_list => FND_API.G_FALSE

Line 1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);

1702: ozf_utility_pvt.debug_message('Product Context :'||l_vo_prod_rec.product_context);
1703: ozf_utility_pvt.debug_message('product_attribute :'||l_vo_prod_rec.product_attribute);
1704: ozf_utility_pvt.debug_message('Product Attr val :'||l_vo_prod_rec.product_attr_value);
1705: ozf_utility_pvt.debug_message('Apply discount Flag :'||l_vo_prod_rec.apply_discount_flag);
1706: ozf_utility_pvt.debug_message('Include Volume :'||l_vo_prod_rec.include_volume_flag);
1707: OZF_Volume_Offer_disc_PVT.Create_vo_product(
1708: p_api_version_number => 1.0
1709: , p_init_msg_list => FND_API.G_FALSE
1710: , p_commit => FND_API.G_FALSE

Line 1735: ozf_utility_pvt.debug_message('Return status 1 is '||x_return_status);

1731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734:
1735: ozf_utility_pvt.debug_message('Return status 1 is '||x_return_status);
1736: -- loop thru new products and create new list lines and pricing attributes
1737: declare
1738: CURSOR c_adj_prod_disc(p_adjustment_id NUMBER)
1739: IS

Line 1786: ozf_utility_pvt.debug_message('i:'||i);

1782: BEGIN
1783: for l_adj_prod_disc IN c_adj_prod_disc(p_offer_adjustment_id) LOOP
1784: i := k;
1785: i := i + 1;
1786: ozf_utility_pvt.debug_message('i:'||i);
1787: l_pricing_attr_tbl(i).product_attribute_context := l_adj_prod_disc.product_context;
1788: l_pricing_attr_tbl(i).product_attribute := l_adj_prod_disc.product_attribute;
1789: l_pricing_attr_tbl(i).product_attr_value := l_adj_prod_disc.product_attr_value;
1790: l_pricing_attr_tbl(i).product_uom_code := l_adj_prod_disc.uom_code;

Line 1831: ozf_utility_pvt.debug_message('Apply discount = n3-range');

1827: l_modifiers_tbl(i).price_break_type_code := 'RANGE';--l_products.volume_break_type;
1828: l_modifiers_tbl(i).start_date_active := l_adj_prod_disc.effective_date;
1829:
1830: IF l_adj_prod_disc.apply_discount_flag = 'N' AND l_adj_prod_disc.include_volume_flag = 'Y' THEN
1831: ozf_utility_pvt.debug_message('Apply discount = n3-range');
1832: l_pricing_attr_tbl(i).pricing_attr_value_from := 1;
1833: l_pricing_attr_tbl(i).pricing_attr_value_to := 999999999;
1834: l_modifiers_tbl(i).list_line_type_code := 'DIS';
1835: l_modifiers_tbl(i).price_break_type_code := 'POINT'; -- RANGE GIVES ERROR

Line 1843: ozf_utility_pvt.debug_message('l_adj_prod_disc.offer_discount_line_id:'||l_adj_prod_disc.offer_discount_line_id);

1839: ELSE
1840: l_modifiers_tbl(i).list_line_type_code := 'PBH';
1841:
1842: -- l_modifiers_tbl(i).start_date_active := l_adj_prod_disc.effective_date;
1843: ozf_utility_pvt.debug_message('l_adj_prod_disc.offer_discount_line_id:'||l_adj_prod_disc.offer_discount_line_id);
1844: k := i;
1845: FOR l_adj_prod_dis IN c_adj_prod_dis(l_adj_prod_disc.offer_discount_line_id) LOOP
1846: k := k + 1;
1847: ozf_utility_pvt.debug_message('k:'||k);

Line 1847: ozf_utility_pvt.debug_message('k:'||k);

1843: ozf_utility_pvt.debug_message('l_adj_prod_disc.offer_discount_line_id:'||l_adj_prod_disc.offer_discount_line_id);
1844: k := i;
1845: FOR l_adj_prod_dis IN c_adj_prod_dis(l_adj_prod_disc.offer_discount_line_id) LOOP
1846: k := k + 1;
1847: ozf_utility_pvt.debug_message('k:'||k);
1848: l_modifiers_tbl(k).operation := 'CREATE';
1849: l_modifiers_tbl(k).list_header_id := l_adj_prod_disc.list_header_id;
1850: IF l_adj_prod_disc.volume_offer_type = 'ACCRUAL' THEN
1851: l_modifiers_tbl(k).accrual_flag := 'Y';

Line 1877: ozf_utility_pvt.debug_message('l_adj_prod_dis.discount_type:'||l_adj_prod_disc.discount_type);

1873:
1874: l_modifiers_tbl(k).modifier_level_code := l_adj_prod_disc.modifier_level_code;
1875: l_modifiers_tbl(k).automatic_flag := 'Y';
1876: l_modifiers_tbl(k).price_break_type_code := 'POINT';
1877: ozf_utility_pvt.debug_message('l_adj_prod_dis.discount_type:'||l_adj_prod_disc.discount_type);
1878: l_modifiers_tbl(k).arithmetic_operator := l_adj_prod_disc.discount_type;
1879: l_modifiers_tbl(k).operand := l_adj_prod_dis.discount;
1880: -- l_modifiers_tbl(k).generate_using_formula_id := l_disc_struct_dis.formula_id;
1881: -- l_modifiers_tbl(k).modifiers_index := k;

Line 1885: ozf_utility_pvt.debug_message('Parent index is :'|| i || ' for : '||k);

1881: -- l_modifiers_tbl(k).modifiers_index := k;
1882: l_modifiers_tbl(k).rltd_modifier_grp_type := 'PRICE BREAK';
1883: l_modifiers_tbl(k).rltd_modifier_grp_no := 1;
1884: l_modifiers_tbl(k).modifier_parent_index := i;
1885: ozf_utility_pvt.debug_message('Parent index is :'|| i || ' for : '||k);
1886:
1887: -- process products for discounts
1888: l_pricing_attr_tbl(k) := l_pricing_attr_tbl(i);
1889: l_pricing_attr_tbl(k).pricing_attr_value_from := l_adj_prod_dis.volume_from;

Line 1896: ozf_utility_pvt.debug_message('l_pricing_attr_tbl'||l_pricing_attr_tbl.COUNT);

1892: END LOOP;
1893: END IF;
1894: END LOOP;
1895:
1896: ozf_utility_pvt.debug_message('l_pricing_attr_tbl'||l_pricing_attr_tbl.COUNT);
1897: QP_Modifiers_PUB.process_modifiers(
1898: p_api_version_number => 1.0,
1899: p_init_msg_list => FND_API.G_FALSE,
1900: p_return_values => FND_API.G_FALSE,

Line 1915: ozf_utility_pvt.debug_message('Return status 2 is '||x_return_status);

1911: x_qualifiers_val_tbl => v_qualifiers_val_tbl,
1912: x_pricing_attr_tbl => v_pricing_attr_tbl,
1913: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1914: );
1915: ozf_utility_pvt.debug_message('Return status 2 is '||x_return_status);
1916: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1917: RAISE FND_API.G_EXC_ERROR;
1918: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1921: ozf_utility_pvt.debug_message('Return status 3 is '||x_return_status);

1917: RAISE FND_API.G_EXC_ERROR;
1918: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1920: END IF;
1921: ozf_utility_pvt.debug_message('Return status 3 is '||x_return_status);
1922: END;
1923:
1924: -- loop thru new products and create new discount and product relations
1925:

Line 1965: ozf_utility_pvt.debug_message('apply Discounts = Y');

1961: AND to_number(nvl(d.pricing_attr_value_to,0)) = nvl(c.volume_to,0)
1962: AND a.apply_discount_flag = 'Y';
1963:
1964: BEGIN
1965: ozf_utility_pvt.debug_message('apply Discounts = Y');
1966: FOR l_create_reln IN c_create_reln(p_offer_adjustment_id ) LOOP
1967: l_reln_rec.pricing_attribute_id := l_create_reln.pricing_attribute_id;
1968: l_reln_rec.qp_list_line_id := l_create_reln.list_line_id;
1969: l_reln_rec.offer_discount_line_id := l_create_reln.offer_discount_line_id;

Line 1971: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);

1967: l_reln_rec.pricing_attribute_id := l_create_reln.pricing_attribute_id;
1968: l_reln_rec.qp_list_line_id := l_create_reln.list_line_id;
1969: l_reln_rec.offer_discount_line_id := l_create_reln.offer_discount_line_id;
1970: l_reln_rec.off_discount_product_id := l_create_reln.off_discount_product_id;
1971: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
1972: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
1973: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
1974: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
1975: -- mgudivak Bug 5400931

Line 1972: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);

1968: l_reln_rec.qp_list_line_id := l_create_reln.list_line_id;
1969: l_reln_rec.offer_discount_line_id := l_create_reln.offer_discount_line_id;
1970: l_reln_rec.off_discount_product_id := l_create_reln.off_discount_product_id;
1971: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
1972: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
1973: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
1974: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
1975: -- mgudivak Bug 5400931
1976: -- Commenting the call since the following procedure has been

Line 1973: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);

1969: l_reln_rec.offer_discount_line_id := l_create_reln.offer_discount_line_id;
1970: l_reln_rec.off_discount_product_id := l_create_reln.off_discount_product_id;
1971: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
1972: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
1973: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
1974: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
1975: -- mgudivak Bug 5400931
1976: -- Commenting the call since the following procedure has been
1977: -- obsoleted in ozfvofrs.pls 120.12

Line 1974: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);

1970: l_reln_rec.off_discount_product_id := l_create_reln.off_discount_product_id;
1971: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
1972: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
1973: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
1974: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
1975: -- mgudivak Bug 5400931
1976: -- Commenting the call since the following procedure has been
1977: -- obsoleted in ozfvofrs.pls 120.12
1978: /*

Line 2020: ozf_utility_pvt.debug_message('apply Discounts = n');

2016:
2017: l_prod_rec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
2018:
2019: BEGIN
2020: ozf_utility_pvt.debug_message('apply Discounts = n');
2021: FOR l_dis_products in c_dis_products(p_offer_adjustment_id) LOOP
2022: l_reln_rec := null;
2023: l_reln_rec.pricing_attribute_id := l_dis_products.pricing_attribute_id;
2024: l_reln_rec.off_discount_product_id := l_dis_products.off_discount_product_id;

Line 2025: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);

2021: FOR l_dis_products in c_dis_products(p_offer_adjustment_id) LOOP
2022: l_reln_rec := null;
2023: l_reln_rec.pricing_attribute_id := l_dis_products.pricing_attribute_id;
2024: l_reln_rec.off_discount_product_id := l_dis_products.off_discount_product_id;
2025: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
2026: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
2027: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
2028: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
2029: -- mgudivak - Bug 5400931

Line 2026: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);

2022: l_reln_rec := null;
2023: l_reln_rec.pricing_attribute_id := l_dis_products.pricing_attribute_id;
2024: l_reln_rec.off_discount_product_id := l_dis_products.off_discount_product_id;
2025: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
2026: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
2027: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
2028: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
2029: -- mgudivak - Bug 5400931
2030: -- Commenting the call since the following procedure has been

Line 2027: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);

2023: l_reln_rec.pricing_attribute_id := l_dis_products.pricing_attribute_id;
2024: l_reln_rec.off_discount_product_id := l_dis_products.off_discount_product_id;
2025: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
2026: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
2027: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
2028: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
2029: -- mgudivak - Bug 5400931
2030: -- Commenting the call since the following procedure has been
2031: -- obsoleted in ozfvofrs.pls 120.12

Line 2028: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);

2024: l_reln_rec.off_discount_product_id := l_dis_products.off_discount_product_id;
2025: ozf_utility_pvt.debug_message('Prc attr : '||l_reln_rec.pricing_attribute_id);
2026: ozf_utility_pvt.debug_message('ListLIneId :'||l_reln_rec.qp_list_line_id);
2027: ozf_utility_pvt.debug_message('Discount line id :'||l_reln_rec.offer_discount_line_id);
2028: ozf_utility_pvt.debug_message('Prod id :'||l_reln_rec.off_discount_product_id);
2029: -- mgudivak - Bug 5400931
2030: -- Commenting the call since the following procedure has been
2031: -- obsoleted in ozfvofrs.pls 120.12
2032: /*

Line 2056: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');

2052: end;
2053:
2054: --exception
2055: null;
2056: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2057:
2058: EXCEPTION
2059: WHEN FND_API.G_EXC_ERROR THEN
2060: rollback to process_vo_adj_products;

Line 2147: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');

2143: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2144: FND_MSG_PUB.INITIALIZE;
2145: END IF;*/
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2148: -- inactivate existing qp_list_lines
2149: DECLARE
2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)
2151: IS

Line 2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);

2168: l_modifier_line_tbl(i).operand := l_qp_list_lines.modified_discount;
2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';
2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);
2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);
2174:
2175: END LOOP;
2176: OZF_OFFER_PVT.process_modifiers

Line 2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);

2169: l_modifier_line_tbl(i).arithmetic_operator := l_qp_list_lines.arithmetic_operator;
2170:
2171: l_modifier_line_tbl(i).operation := 'UPDATE';
2172: ozf_utility_pvt.debug_message('List Line Id is :'||l_qp_list_lines.list_line_id || ' : '||l_qp_list_lines.list_header_id || ' : '||l_qp_list_lines.modified_discount);
2173: ozf_utility_pvt.debug_message('List Line Id is1 :'||l_modifier_line_tbl(i).list_line_id || ' : '||l_modifier_line_tbl(i).list_header_id || ' : '||l_modifier_line_tbl(i).operand);
2174:
2175: END LOOP;
2176: OZF_OFFER_PVT.process_modifiers
2177: (

Line 2339: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' End');

2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337: end;
2338: */
2339: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' End');
2340:
2341: IF FND_API.to_boolean(p_commit) THEN
2342: COMMIT WORK;
2343: END IF;

Line 2412: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');

2408: FND_MSG_PUB.INITIALIZE;
2409: END IF;
2410:
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' Start');
2413: process_vo_adj_tiers
2414: (
2415: p_init_msg_list => FND_API.g_false
2416: ,p_api_version => 1.0

Line 2444: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' End');

2440: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END IF;
2443:
2444: ozf_utility_pvt.debug_message('Private API:'|| l_api_name || ' End');
2445: EXCEPTION
2446: WHEN FND_API.G_EXC_ERROR THEN
2447: ROLLBACK TO process_vo_adjustments;
2448: x_return_status := FND_API.G_RET_STS_ERROR;