30: -- Fri Dec 28 2012 APYADAV Bug 14113514 - DESCRIPTIVE FLEXFIELD FOR NET ACCRUAL OFFER DISCOUNT LINES NOT SAVING
31: -- ===============================================================
32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
33: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36: --
37: --======================Discount Line Methods ========================================
38: -- Hint: Primary key needs to be returned.
31: -- ===============================================================
32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
33: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36: --
37: --======================Discount Line Methods ========================================
38: -- Hint: Primary key needs to be returned.
39: -- ==============================================================================
999: -- =========================================================================
1000: -- Validate Environment
1001: -- =========================================================================
1002:
1003: IF FND_GLOBAL.USER_ID IS NULL
1004: THEN
1005: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1076: p_start_date_active => l_ozf_offer_line_rec.start_date_active,
1077: p_end_date_active => l_ozf_offer_line_rec.end_date_active,
1078: p_uom_code => l_ozf_offer_line_rec.uom_code,
1079: p_creation_date => SYSDATE,
1080: p_created_by => FND_GLOBAL.USER_ID,
1081: p_last_update_date => SYSDATE,
1082: p_last_updated_by => FND_GLOBAL.USER_ID,
1083: p_last_update_login => FND_GLOBAL.conc_login_id,
1084: px_object_version_number => l_object_version_number,
1078: p_uom_code => l_ozf_offer_line_rec.uom_code,
1079: p_creation_date => SYSDATE,
1080: p_created_by => FND_GLOBAL.USER_ID,
1081: p_last_update_date => SYSDATE,
1082: p_last_updated_by => FND_GLOBAL.USER_ID,
1083: p_last_update_login => FND_GLOBAL.conc_login_id,
1084: px_object_version_number => l_object_version_number,
1085: p_context => l_ozf_offer_line_rec.context,
1086: p_attribute1 => l_ozf_offer_line_rec.attribute1,
1079: p_creation_date => SYSDATE,
1080: p_created_by => FND_GLOBAL.USER_ID,
1081: p_last_update_date => SYSDATE,
1082: p_last_updated_by => FND_GLOBAL.USER_ID,
1083: p_last_update_login => FND_GLOBAL.conc_login_id,
1084: px_object_version_number => l_object_version_number,
1085: p_context => l_ozf_offer_line_rec.context,
1086: p_attribute1 => l_ozf_offer_line_rec.attribute1,
1087: p_attribute2 => l_ozf_offer_line_rec.attribute2,
1339: p_start_date_active => p_ozf_offer_line_rec.start_date_active,
1340: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1341: p_uom_code => p_ozf_offer_line_rec.uom_code,
1342: p_last_update_date => SYSDATE,
1343: p_last_updated_by => FND_GLOBAL.USER_ID,
1344: p_last_update_login => FND_GLOBAL.conc_login_id,
1345: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1346: p_context => p_ozf_offer_line_rec.context,
1347: p_attribute1 => p_ozf_offer_line_rec.attribute1,
1340: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1341: p_uom_code => p_ozf_offer_line_rec.uom_code,
1342: p_last_update_date => SYSDATE,
1343: p_last_updated_by => FND_GLOBAL.USER_ID,
1344: p_last_update_login => FND_GLOBAL.conc_login_id,
1345: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1346: p_context => p_ozf_offer_line_rec.context,
1347: p_attribute1 => p_ozf_offer_line_rec.attribute1,
1348: p_attribute2 => p_ozf_offer_line_rec.attribute2,
2362: -- =========================================================================
2363: -- Validate Environment
2364: -- =========================================================================
2365:
2366: IF FND_GLOBAL.USER_ID IS NULL
2367: THEN
2368: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2432: p_end_date_active => l_ozf_prod_rec.end_date_active,
2433: p_offer_discount_line_id => l_ozf_prod_rec.offer_discount_line_id,
2434: p_offer_id => l_ozf_prod_rec.offer_id,
2435: p_creation_date => SYSDATE,
2436: p_created_by => FND_GLOBAL.USER_ID,
2437: p_last_update_date => SYSDATE,
2438: p_last_updated_by => FND_GLOBAL.USER_ID,
2439: p_last_update_login => FND_GLOBAL.conc_login_id,
2440: px_object_version_number => l_object_version_number
2434: p_offer_id => l_ozf_prod_rec.offer_id,
2435: p_creation_date => SYSDATE,
2436: p_created_by => FND_GLOBAL.USER_ID,
2437: p_last_update_date => SYSDATE,
2438: p_last_updated_by => FND_GLOBAL.USER_ID,
2439: p_last_update_login => FND_GLOBAL.conc_login_id,
2440: px_object_version_number => l_object_version_number
2441: );
2442:
2435: p_creation_date => SYSDATE,
2436: p_created_by => FND_GLOBAL.USER_ID,
2437: p_last_update_date => SYSDATE,
2438: p_last_updated_by => FND_GLOBAL.USER_ID,
2439: p_last_update_login => FND_GLOBAL.conc_login_id,
2440: px_object_version_number => l_object_version_number
2441: );
2442:
2443: x_off_discount_product_id := l_off_discount_product_id;
2672: p_end_date_active => p_ozf_prod_rec.end_date_active,
2673: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2674: p_offer_id => p_ozf_prod_rec.offer_id,
2675: p_last_update_date => SYSDATE,
2676: p_last_updated_by => FND_GLOBAL.USER_ID,
2677: p_last_update_login => FND_GLOBAL.conc_login_id,
2678: p_object_version_number => p_ozf_prod_rec.object_version_number
2679: );
2680: --
2673: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2674: p_offer_id => p_ozf_prod_rec.offer_id,
2675: p_last_update_date => SYSDATE,
2676: p_last_updated_by => FND_GLOBAL.USER_ID,
2677: p_last_update_login => FND_GLOBAL.conc_login_id,
2678: p_object_version_number => p_ozf_prod_rec.object_version_number
2679: );
2680: --
2681: -- End of API body.
3665: -- =========================================================================
3666: -- Validate Environment
3667: -- =========================================================================
3668:
3669: IF FND_GLOBAL.USER_ID IS NULL
3670: THEN
3671: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3672: RAISE FND_API.G_EXC_ERROR;
3673: END IF;
3724: px_discount_product_reln_id => l_discount_product_reln_id,
3725: p_offer_discount_line_id => l_prod_reln_rec.offer_discount_line_id,
3726: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3727: p_creation_date => SYSDATE,
3728: p_created_by => FND_GLOBAL.USER_ID,
3729: p_last_update_date => SYSDATE,
3730: p_last_updated_by => FND_GLOBAL.USER_ID,
3731: p_last_update_login => FND_GLOBAL.conc_login_id,
3732: px_object_version_number => l_object_version_number
3726: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3727: p_creation_date => SYSDATE,
3728: p_created_by => FND_GLOBAL.USER_ID,
3729: p_last_update_date => SYSDATE,
3730: p_last_updated_by => FND_GLOBAL.USER_ID,
3731: p_last_update_login => FND_GLOBAL.conc_login_id,
3732: px_object_version_number => l_object_version_number
3733: );
3734:
3727: p_creation_date => SYSDATE,
3728: p_created_by => FND_GLOBAL.USER_ID,
3729: p_last_update_date => SYSDATE,
3730: p_last_updated_by => FND_GLOBAL.USER_ID,
3731: p_last_update_login => FND_GLOBAL.conc_login_id,
3732: px_object_version_number => l_object_version_number
3733: );
3734:
3735: x_discount_product_reln_id := l_discount_product_reln_id;
3957: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,
3958: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3959: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3960: p_last_update_date => SYSDATE,
3961: p_last_updated_by => FND_GLOBAL.USER_ID,
3962: p_last_update_login => FND_GLOBAL.conc_login_id,
3963: p_object_version_number => p_prod_reln_rec.object_version_number
3964: );
3965: --
3958: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3959: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3960: p_last_update_date => SYSDATE,
3961: p_last_updated_by => FND_GLOBAL.USER_ID,
3962: p_last_update_login => FND_GLOBAL.conc_login_id,
3963: p_object_version_number => p_prod_reln_rec.object_version_number
3964: );
3965: --
3966: -- End of API body.