DBA Data[Home] [Help]

APPS.OZF_RESALE_PUB dependencies on OZF_UTILITY_PVT

Line 74: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

70: END IF;
71:
72: -- Debug Message
73: IF OZF_DEBUG_LOW_ON THEN
74: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
75: END IF;
76:
77: -- Initialize API return status to sucess
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');

108: END IF;
109:
110: -- Debug Message
111: IF OZF_DEBUG_LOW_ON THEN
112: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
113: END IF;
114:
115: --Standard call to get message count and if count=1, get the message
116: FND_MSG_PUB.Count_And_Get (

Line 210: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

206: END IF;
207:
208: -- Debug Message
209: IF OZF_DEBUG_LOW_ON THEN
210: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
211: END IF;
212:
213: -- Initialize API return status to sucess
214: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 249: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');

245:
246:
247: -- Debug Message
248: IF OZF_DEBUG_LOW_ON THEN
249: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
250: END IF;
251:
252: --Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (

Line 339: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');

335: END IF;
336:
337: -- Debug Message
338: IF OZF_DEBUG_LOW_ON THEN
339: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': start');
340: END IF;
341:
342: -- Initialize API return status to sucess
343: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 367: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

363: END IF;
364:
365: -- Debug Message
366: IF OZF_DEBUG_LOW_ON THEN
367: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
368: END IF;
369: --Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,

Line 452: ozf_utility_pvt.error_message('OZF_RESALE_IS_TM_OFFER');

448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452: ozf_utility_pvt.error_message('OZF_RESALE_IS_TM_OFFER');
453: END Chk_accrual_exists;
454:
455: ---------------------------------------------------------------------
456: -- PROCEDURE

Line 624: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' start');

620: END IF;
621:
622: -- Debug Message
623: IF OZF_DEBUG_HIGH_ON THEN
624: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' start');
625: END IF;
626:
627: -- Initialize API return status to SUCCESS
628: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 634: OZF_UTILITY_PVT.debug_message('Validation Starts...');

630: --//API Body
631: --=====================================================================================================================
632: --//Validations
633: IF OZF_DEBUG_HIGH_ON THEN
634: OZF_UTILITY_PVT.debug_message('Validation Starts...');
635: END IF;
636:
637: --//1.resale_batch_id
638: IF l_resale_util_rec.resale_batch_id IS NULL OR l_resale_util_rec.resale_batch_id = FND_API.g_miss_num THEN

Line 676: --OZF_UTILITY_PVT.debug_message('INSIDE '||l_resale_line_rec.resale_line_id);

672: OPEN c_get_resale_lines(l_resale_util_rec.resale_batch_id,l_resale_util_rec.resale_line_id);
673: FETCH c_get_resale_lines INTO l_resale_line_rec;
674:
675: IF c_get_resale_lines%NOTFOUND THEN
676: --OZF_UTILITY_PVT.debug_message('INSIDE '||l_resale_line_rec.resale_line_id);
677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
678: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RESALE_LINE_ID');
679: --//Resale Line Identifier provided is invalid.Please provide a valid Resale Line Identifier.
680: FND_MSG_PUB.add;

Line 888: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_line_rec.last_updated_by);

884: END IF;
885:
886: --//11.requester_id
887: IF l_resale_util_rec.requester_id IS NULL OR l_resale_util_rec.requester_id = FND_API.g_miss_num THEN
888: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_line_rec.last_updated_by);
889: IF l_requester_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
892: --//User is not a valid resource.

Line 913: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_util_rec.requester_id);

909: x_return_status := fnd_api.g_ret_sts_error;
910: RETURN;
911: END IF;
912:
913: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_util_rec.requester_id);
914: IF l_requester_id IS NULL THEN
915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
917: --//User is not a valid resource.

Line 971: OZF_UTILITY_PVT.debug_message('Validation Completed...');

967: END IF;
968: END IF;
969:
970: IF OZF_DEBUG_HIGH_ON THEN
971: OZF_UTILITY_PVT.debug_message('Validation Completed...');
972: OZF_UTILITY_PVT.debug_message('Populate Records');
973: END IF;
974:
975: --// Populate l_adjustment_rec

Line 972: OZF_UTILITY_PVT.debug_message('Populate Records');

968: END IF;
969:
970: IF OZF_DEBUG_HIGH_ON THEN
971: OZF_UTILITY_PVT.debug_message('Validation Completed...');
972: OZF_UTILITY_PVT.debug_message('Populate Records');
973: END IF;
974:
975: --// Populate l_adjustment_rec
976: l_adjustment_rec.resale_batch_id := l_resale_util_rec.resale_batch_id;

Line 1069: OZF_UTILITY_PVT.debug_message('OZF: Supplier Ship and Debit on Indirect Sales :' || l_ssd_on_idsm);

1065:
1066: l_ssd_on_idsm := FND_PROFILE.value('OZF_SSD_ON_IDSM');
1067:
1068: IF OZF_DEBUG_LOW_ON THEN
1069: OZF_UTILITY_PVT.debug_message('OZF: Supplier Ship and Debit on Indirect Sales :' || l_ssd_on_idsm);
1070: END IF;
1071:
1072: IF l_ssd_on_idsm = 'Y' THEN
1073: IF (l_resale_line_rec.supplier_item_cost = -1 AND (l_resale_util_rec.discount_type = '%' OR l_resale_util_rec.discount_type ='UNIT_PRICE')) THEN

Line 1115: ozf_utility_pvt.debug_message ('l_offer_id: ' || l_offer_id);

1111: --//populate beneficary for volume offer
1112: IF l_offer_type = 'VOLUME_OFFER' AND l_act_util_rec.object_type = 'TP_ORDER' AND l_act_budgets_rec.arc_act_budget_used_by = 'OFFR' THEN
1113: l_beneficiary_account_id := OZF_VOLUME_CALCULATION_PUB.get_beneficiary(l_offer_id,l_act_util_rec.object_id);
1114: IF OZF_DEBUG_LOW_ON THEN
1115: ozf_utility_pvt.debug_message ('l_offer_id: ' || l_offer_id);
1116: ozf_utility_pvt.debug_message ('l_beneficiary_account_id: ' || l_beneficiary_account_id);
1117: END IF;
1118:
1119: IF l_beneficiary_account_id = 0 THEN

Line 1116: ozf_utility_pvt.debug_message ('l_beneficiary_account_id: ' || l_beneficiary_account_id);

1112: IF l_offer_type = 'VOLUME_OFFER' AND l_act_util_rec.object_type = 'TP_ORDER' AND l_act_budgets_rec.arc_act_budget_used_by = 'OFFR' THEN
1113: l_beneficiary_account_id := OZF_VOLUME_CALCULATION_PUB.get_beneficiary(l_offer_id,l_act_util_rec.object_id);
1114: IF OZF_DEBUG_LOW_ON THEN
1115: ozf_utility_pvt.debug_message ('l_offer_id: ' || l_offer_id);
1116: ozf_utility_pvt.debug_message ('l_beneficiary_account_id: ' || l_beneficiary_account_id);
1117: END IF;
1118:
1119: IF l_beneficiary_account_id = 0 THEN
1120: l_act_util_rec.cust_account_id := l_act_util_rec.billto_cust_account_id;

Line 1135: OZF_UTILITY_PVT.debug_message('Before Call Create_Adj_and_Utilization');

1131:
1132: l_act_util_rec.price_adjustment_id := l_adjustment_rec.resale_adjustment_id;
1133:
1134: IF OZF_DEBUG_HIGH_ON THEN
1135: OZF_UTILITY_PVT.debug_message('Before Call Create_Adj_and_Utilization');
1136: OZF_UTILITY_PVT.debug_message('l_adjustment_rec.resale_adjustment_id :'|| l_adjustment_rec.resale_adjustment_id);
1137: END IF;
1138:
1139:

Line 1136: OZF_UTILITY_PVT.debug_message('l_adjustment_rec.resale_adjustment_id :'|| l_adjustment_rec.resale_adjustment_id);

1132: l_act_util_rec.price_adjustment_id := l_adjustment_rec.resale_adjustment_id;
1133:
1134: IF OZF_DEBUG_HIGH_ON THEN
1135: OZF_UTILITY_PVT.debug_message('Before Call Create_Adj_and_Utilization');
1136: OZF_UTILITY_PVT.debug_message('l_adjustment_rec.resale_adjustment_id :'|| l_adjustment_rec.resale_adjustment_id);
1137: END IF;
1138:
1139:
1140: --//Invoke private API to create Adjustments and Utilizations

Line 1157: OZF_UTILITY_PVT.debug_message('After Call Create_Adj_and_Utilization ');

1153: ,x_utilization_id => l_utilization_id
1154: );
1155:
1156: IF OZF_DEBUG_HIGH_ON THEN
1157: OZF_UTILITY_PVT.debug_message('After Call Create_Adj_and_Utilization ');
1158: OZF_UTILITY_PVT.debug_message('l_utilization_id :'|| l_utilization_id);
1159: OZF_UTILITY_PVT.debug_message('l_return_status :'|| l_return_status);
1160: END IF;
1161:

Line 1158: OZF_UTILITY_PVT.debug_message('l_utilization_id :'|| l_utilization_id);

1154: );
1155:
1156: IF OZF_DEBUG_HIGH_ON THEN
1157: OZF_UTILITY_PVT.debug_message('After Call Create_Adj_and_Utilization ');
1158: OZF_UTILITY_PVT.debug_message('l_utilization_id :'|| l_utilization_id);
1159: OZF_UTILITY_PVT.debug_message('l_return_status :'|| l_return_status);
1160: END IF;
1161:
1162: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1159: OZF_UTILITY_PVT.debug_message('l_return_status :'|| l_return_status);

1155:
1156: IF OZF_DEBUG_HIGH_ON THEN
1157: OZF_UTILITY_PVT.debug_message('After Call Create_Adj_and_Utilization ');
1158: OZF_UTILITY_PVT.debug_message('l_utilization_id :'|| l_utilization_id);
1159: OZF_UTILITY_PVT.debug_message('l_return_status :'|| l_return_status);
1160: END IF;
1161:
1162: IF l_return_status = fnd_api.g_ret_sts_error THEN
1163: RAISE fnd_api.g_exc_error;

Line 1218: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');

1214:
1215: --================================================================================================================
1216: --// Commit the process
1217: IF OZF_DEBUG_HIGH_ON THEN
1218: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');
1219: END IF;
1220: IF FND_API.to_Boolean( p_commit )
1221: THEN
1222: COMMIT WORK;