29: -- Thu Apr 06 2006:4/41 PM RSSHARMA Fixed bug # 5142859. Added Null Currency validation. DOnt allow amount discount if currency is null
30: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
33: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
34: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
35: --
36: --======================Discount Line Methods ========================================
37: -- Hint: Primary key needs to be returned.
30: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
33: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
34: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
35: --
36: --======================Discount Line Methods ========================================
37: -- Hint: Primary key needs to be returned.
38: -- ==============================================================================
998: -- =========================================================================
999: -- Validate Environment
1000: -- =========================================================================
1001:
1002: IF FND_GLOBAL.USER_ID IS NULL
1003: THEN
1004: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;
1075: p_start_date_active => l_ozf_offer_line_rec.start_date_active,
1076: p_end_date_active => l_ozf_offer_line_rec.end_date_active,
1077: p_uom_code => l_ozf_offer_line_rec.uom_code,
1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,
1077: p_uom_code => l_ozf_offer_line_rec.uom_code,
1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,
1084: p_context => l_ozf_offer_line_rec.context,
1085: p_attribute1 => l_ozf_offer_line_rec.attribute1,
1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,
1084: p_context => l_ozf_offer_line_rec.context,
1085: p_attribute1 => l_ozf_offer_line_rec.attribute1,
1086: p_attribute2 => l_ozf_offer_line_rec.attribute2,
1338: p_start_date_active => p_ozf_offer_line_rec.start_date_active,
1339: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1340: p_uom_code => p_ozf_offer_line_rec.uom_code,
1341: p_last_update_date => SYSDATE,
1342: p_last_updated_by => FND_GLOBAL.USER_ID,
1343: p_last_update_login => FND_GLOBAL.conc_login_id,
1344: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1345: p_context => p_ozf_offer_line_rec.context,
1346: p_attribute1 => p_ozf_offer_line_rec.attribute1,
1339: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1340: p_uom_code => p_ozf_offer_line_rec.uom_code,
1341: p_last_update_date => SYSDATE,
1342: p_last_updated_by => FND_GLOBAL.USER_ID,
1343: p_last_update_login => FND_GLOBAL.conc_login_id,
1344: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1345: p_context => p_ozf_offer_line_rec.context,
1346: p_attribute1 => p_ozf_offer_line_rec.attribute1,
1347: p_attribute2 => p_ozf_offer_line_rec.attribute2,
2361: -- =========================================================================
2362: -- Validate Environment
2363: -- =========================================================================
2364:
2365: IF FND_GLOBAL.USER_ID IS NULL
2366: THEN
2367: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2431: p_end_date_active => l_ozf_prod_rec.end_date_active,
2432: p_offer_discount_line_id => l_ozf_prod_rec.offer_discount_line_id,
2433: p_offer_id => l_ozf_prod_rec.offer_id,
2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number
2433: p_offer_id => l_ozf_prod_rec.offer_id,
2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number
2440: );
2441:
2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number
2440: );
2441:
2442: x_off_discount_product_id := l_off_discount_product_id;
2671: p_end_date_active => p_ozf_prod_rec.end_date_active,
2672: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2673: p_offer_id => p_ozf_prod_rec.offer_id,
2674: p_last_update_date => SYSDATE,
2675: p_last_updated_by => FND_GLOBAL.USER_ID,
2676: p_last_update_login => FND_GLOBAL.conc_login_id,
2677: p_object_version_number => p_ozf_prod_rec.object_version_number
2678: );
2679: --
2672: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2673: p_offer_id => p_ozf_prod_rec.offer_id,
2674: p_last_update_date => SYSDATE,
2675: p_last_updated_by => FND_GLOBAL.USER_ID,
2676: p_last_update_login => FND_GLOBAL.conc_login_id,
2677: p_object_version_number => p_ozf_prod_rec.object_version_number
2678: );
2679: --
2680: -- End of API body.
3664: -- =========================================================================
3665: -- Validate Environment
3666: -- =========================================================================
3667:
3668: IF FND_GLOBAL.USER_ID IS NULL
3669: THEN
3670: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;
3723: px_discount_product_reln_id => l_discount_product_reln_id,
3724: p_offer_discount_line_id => l_prod_reln_rec.offer_discount_line_id,
3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number
3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number
3732: );
3733:
3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number
3732: );
3733:
3734: x_discount_product_reln_id := l_discount_product_reln_id;
3956: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,
3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3959: p_last_update_date => SYSDATE,
3960: p_last_updated_by => FND_GLOBAL.USER_ID,
3961: p_last_update_login => FND_GLOBAL.conc_login_id,
3962: p_object_version_number => p_prod_reln_rec.object_version_number
3963: );
3964: --
3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3959: p_last_update_date => SYSDATE,
3960: p_last_updated_by => FND_GLOBAL.USER_ID,
3961: p_last_update_login => FND_GLOBAL.conc_login_id,
3962: p_object_version_number => p_prod_reln_rec.object_version_number
3963: );
3964: --
3965: -- End of API body.