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

Line 138: OZF_Offer_Adj_Line_PVT.debug_message('OfferType is :'||l_offerType);

134: THEN
135: null;
136: END IF;
137: l_offerType := get_offer_type(p_adj_prod.offer_adjustment_id);
138: OZF_Offer_Adj_Line_PVT.debug_message('OfferType is :'||l_offerType);
139: IF l_offerType = 'VOLUME_OFFER' THEN
140: OPEN c_offerId(p_adj_prod.offer_adjustment_id);
141: FETCH c_offerId INTO l_offerId;
142: CLOSE c_offerId;

Line 177: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountLineid is: '||p_adj_prod.offer_discount_line_id);

173: x_return_status := FND_API.g_ret_sts_error;
174: return;
175: END IF;
176: END IF;
177: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountLineid is: '||p_adj_prod.offer_discount_line_id);
178: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN
180: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_DISC_LINE');
181: x_return_status := FND_API.g_ret_sts_error;

Line 185: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountProductId is : '||p_adj_prod.off_discount_product_id);

181: x_return_status := FND_API.g_ret_sts_error;
182: return;
183: END IF;
184: END IF;
185: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountProductId is : '||p_adj_prod.off_discount_product_id);
186: IF p_adj_prod.off_discount_product_id IS NOT NULL AND p_adj_prod.off_discount_product_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.CHECK_FK_EXISTS('ozf_offer_discount_products','off_discount_product_id',to_char(p_adj_prod.off_discount_product_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_INV_PROD_LINE');
189: x_return_status := FND_API.g_ret_sts_error;

Line 193: OZF_Offer_Adj_Line_PVT.debug_message('Calling Product Ctx validation');

189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;
192: END IF;
193: OZF_Offer_Adj_Line_PVT.debug_message('Calling Product Ctx validation');
194:
195: IF
196: (p_adj_prod.product_context IS NOT NULL AND p_adj_prod.product_context <> FND_API.G_MISS_CHAR )
197: AND

Line 205: OZF_Offer_Adj_Line_PVT.debug_message('Calling Product Ctx validation');

201: THEN
202: l_vo_prod_rec.product_context := p_adj_prod.product_context;
203: l_vo_prod_rec.product_attribute := p_adj_prod.product_attribute;
204: l_vo_prod_rec.product_attr_value := p_adj_prod.product_attr_value;
205: OZF_Offer_Adj_Line_PVT.debug_message('Calling Product Ctx validation');
206: OZF_Volume_Offer_disc_PVT.Check_vo_product_attr(
207: p_vo_prod_rec => l_vo_prod_rec
208: , x_return_status => x_return_status
209: );

Line 396: OZF_Offer_Adj_Line_PVT.debug_message('Checking backdated');

392: IF c_effectiveDate%NOTFOUND THEN
393: l_effectiveDate := sysdate + 1;
394: END IF;
395: CLOSE c_effectiveDate;
396: OZF_Offer_Adj_Line_PVT.debug_message('Checking backdated');
397: IF l_effectiveDate > SYSDATE THEN
398: OZF_Offer_Adj_Line_PVT.debug_message('Not backdated');
399: null;
400: ELSE

Line 398: OZF_Offer_Adj_Line_PVT.debug_message('Not backdated');

394: END IF;
395: CLOSE c_effectiveDate;
396: OZF_Offer_Adj_Line_PVT.debug_message('Checking backdated');
397: IF l_effectiveDate > SYSDATE THEN
398: OZF_Offer_Adj_Line_PVT.debug_message('Not backdated');
399: null;
400: ELSE
401: OZF_Offer_Adj_Line_PVT.debug_message('backdated');
402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_ADJ_BACKDATE_NO_PROD');

Line 401: OZF_Offer_Adj_Line_PVT.debug_message('backdated');

397: IF l_effectiveDate > SYSDATE THEN
398: OZF_Offer_Adj_Line_PVT.debug_message('Not backdated');
399: null;
400: ELSE
401: OZF_Offer_Adj_Line_PVT.debug_message('backdated');
402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_ADJ_BACKDATE_NO_PROD');
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: return;
405: END IF;

Line 513: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');

509: IS
510: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ADJ_PRODUCTS';
511: BEGIN
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');
514: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
515: check_adj_products(
516: p_adj_prod => p_adj_prod
517: , p_validation_mode => p_validation_mode

Line 526: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' End');

522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' End');
527:
528: END VALIDATE_ADJ_PRODUCTS;
529:
530: PROCEDURE CREATE_OFFER_ADJ_PRODUCT

Line 580: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');

576: IF fnd_api.to_boolean(p_init_msg_list) THEN
577: FND_MSG_PUB.INITIALIZE;
578: END IF;
579:
580: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583:
584: IF FND_GLOBAL.USER_ID IS NULL

Line 655: OZF_Offer_Adj_Line_PVT.debug_message('Private API '|| l_api_name || ' End');

651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: OZF_Offer_Adj_Line_PVT.debug_message('Private API '|| l_api_name || ' End');
656:
657: IF FND_API.to_boolean(p_commit) THEN
658: COMMIT WORK;
659: END IF;

Line 742: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');

738: END IF;
739:
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');
743: OPEN c_get_adj_prod(l_tar_rec.offer_adjustment_product_id , l_tar_rec.object_version_number);
744: FETCH c_get_adj_prod INTO l_ref_rec;
745: IF (c_get_adj_prod%NOTFOUND) THEN
746: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'

Line 787: OZF_Offer_Adj_Line_PVT.debug_message('eXCLUDER FLAG IS :'||l_excluder_flag||':123');

783: END IF;
784: IF l_tar_rec.apply_discount_flag = 'N' AND l_tar_rec.include_volume_flag = 'N' THEN
785: l_excluder_flag :='Y';
786: END IF;
787: OZF_Offer_Adj_Line_PVT.debug_message('eXCLUDER FLAG IS :'||l_excluder_flag||':123');
788: OZF_OFFER_ADJ_PRODUCTS_PKG.UPDATE_ROW
789: (
790: p_offer_adjustment_product_id => l_tar_rec.offer_adjustment_product_id
791: , p_offer_adjustment_id => l_tar_rec.offer_adjustment_id

Line 810: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' End');

806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' End');
811: IF FND_API.TO_BOOLEAN(p_commit) THEN
812: COMMIT WORK;
813: END IF;
814:

Line 882: OZF_Offer_Adj_Line_PVT.debug_message('Private API:'|| l_api_name ||' Start');

878: FND_msg_pub.INITIALIZE;
879: END IF;
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: OZF_Offer_Adj_Line_PVT.debug_message('Private API:'|| l_api_name ||' Start');
883:
884: OZF_OFFER_ADJ_PRODUCTS_PKG.DELETE_ROW
885: (
886: p_offer_adjustment_product_id => p_offer_adjustment_product_id

Line 889: OZF_Offer_Adj_Line_PVT.debug_message('Private API:'|| l_api_name || ' End');

885: (
886: p_offer_adjustment_product_id => p_offer_adjustment_product_id
887: , p_object_version_number => p_object_version_number
888: );
889: OZF_Offer_Adj_Line_PVT.debug_message('Private API:'|| l_api_name || ' End');
890: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
891: COMMIT WORK;
892: END IF;
893: