1804: -- =========================================================================
1805: -- Validate Environment
1806: -- =========================================================================
1807:
1808: IF FND_GLOBAL.USER_ID IS NULL
1809: THEN
1810: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1811: RAISE FND_API.G_EXC_ERROR;
1812: END IF;
2048: -- =========================================================================
2049: -- Validate Environment
2050: -- =========================================================================
2051:
2052: IF FND_GLOBAL.USER_ID IS NULL
2053: THEN
2054: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2055: RAISE FND_API.G_EXC_ERROR;
2056: END IF;
2143: p_start_date_active => l_vo_discount_rec.start_date_active,
2144: p_end_date_active => l_vo_discount_rec.end_date_active,
2145: p_uom_code => l_vo_discount_rec.uom_code,
2146: p_creation_date => SYSDATE,
2147: p_created_by => FND_GLOBAL.USER_ID,
2148: p_last_update_date => SYSDATE,
2149: p_last_updated_by => FND_GLOBAL.USER_ID,
2150: p_last_update_login => FND_GLOBAL.conc_login_id,
2151: px_object_version_number => l_object_version_number,
2145: p_uom_code => l_vo_discount_rec.uom_code,
2146: p_creation_date => SYSDATE,
2147: p_created_by => FND_GLOBAL.USER_ID,
2148: p_last_update_date => SYSDATE,
2149: p_last_updated_by => FND_GLOBAL.USER_ID,
2150: p_last_update_login => FND_GLOBAL.conc_login_id,
2151: px_object_version_number => l_object_version_number,
2152: p_offer_id => l_vo_discount_rec.offer_id,
2153: p_context => l_vo_discount_rec.context,
2146: p_creation_date => SYSDATE,
2147: p_created_by => FND_GLOBAL.USER_ID,
2148: p_last_update_date => SYSDATE,
2149: p_last_updated_by => FND_GLOBAL.USER_ID,
2150: p_last_update_login => FND_GLOBAL.conc_login_id,
2151: px_object_version_number => l_object_version_number,
2152: p_offer_id => l_vo_discount_rec.offer_id,
2153: p_context => l_vo_discount_rec.context,
2154: p_attribute1 => l_vo_discount_rec.attribute1,
2177: OZF_VO_DISC_STRUCT_NAME_PKG.Insert_Row(
2178: px_offr_disc_struct_name_id => l_offr_disc_struct_name_id
2179: , p_offer_discount_line_id => x_vo_discount_line_id
2180: , p_creation_date => SYSDATE
2181: , p_created_by => FND_GLOBAL.USER_ID
2182: , p_last_updated_by => FND_GLOBAL.USER_ID
2183: , p_last_update_date => SYSDATE
2184: , p_last_update_login => FND_GLOBAL.conc_login_id
2185: , p_name => l_vo_discount_rec.name
2178: px_offr_disc_struct_name_id => l_offr_disc_struct_name_id
2179: , p_offer_discount_line_id => x_vo_discount_line_id
2180: , p_creation_date => SYSDATE
2181: , p_created_by => FND_GLOBAL.USER_ID
2182: , p_last_updated_by => FND_GLOBAL.USER_ID
2183: , p_last_update_date => SYSDATE
2184: , p_last_update_login => FND_GLOBAL.conc_login_id
2185: , p_name => l_vo_discount_rec.name
2186: , p_description => l_vo_discount_rec.description
2180: , p_creation_date => SYSDATE
2181: , p_created_by => FND_GLOBAL.USER_ID
2182: , p_last_updated_by => FND_GLOBAL.USER_ID
2183: , p_last_update_date => SYSDATE
2184: , p_last_update_login => FND_GLOBAL.conc_login_id
2185: , p_name => l_vo_discount_rec.name
2186: , p_description => l_vo_discount_rec.description
2187: , px_object_version_number => l_struct_object_version
2188: );
2400: p_start_date_active => l_tar_vo_disc_line_rec.start_date_active,
2401: p_end_date_active => l_tar_vo_disc_line_rec.end_date_active,
2402: p_uom_code => l_tar_vo_disc_line_rec.uom_code,
2403: p_last_update_date => SYSDATE,
2404: p_last_updated_by => FND_GLOBAL.USER_ID,
2405: p_last_update_login => FND_GLOBAL.conc_login_id,
2406: p_object_version_number => l_tar_vo_disc_line_rec.object_version_number,
2407: p_context => l_tar_vo_disc_line_rec.context,
2408: p_attribute1 => l_tar_vo_disc_line_rec.attribute1,
2401: p_end_date_active => l_tar_vo_disc_line_rec.end_date_active,
2402: p_uom_code => l_tar_vo_disc_line_rec.uom_code,
2403: p_last_update_date => SYSDATE,
2404: p_last_updated_by => FND_GLOBAL.USER_ID,
2405: p_last_update_login => FND_GLOBAL.conc_login_id,
2406: p_object_version_number => l_tar_vo_disc_line_rec.object_version_number,
2407: p_context => l_tar_vo_disc_line_rec.context,
2408: p_attribute1 => l_tar_vo_disc_line_rec.attribute1,
2409: p_attribute2 => l_tar_vo_disc_line_rec.attribute2,
2434:
2435: OZF_VO_DISC_STRUCT_NAME_PKG.Update_Row(
2436: p_offr_disc_struct_name_id => l_offr_disc_struct_name_id
2437: , p_offer_discount_line_id => p_vo_disc_rec.offer_discount_line_id
2438: , p_last_updated_by => FND_GLOBAL.USER_ID
2439: , p_last_update_date => SYSDATE
2440: , p_last_update_login => FND_GLOBAL.conc_login_id
2441: , p_name => p_vo_disc_rec.name
2442: , p_description => p_vo_disc_rec.description
2436: p_offr_disc_struct_name_id => l_offr_disc_struct_name_id
2437: , p_offer_discount_line_id => p_vo_disc_rec.offer_discount_line_id
2438: , p_last_updated_by => FND_GLOBAL.USER_ID
2439: , p_last_update_date => SYSDATE
2440: , p_last_update_login => FND_GLOBAL.conc_login_id
2441: , p_name => p_vo_disc_rec.name
2442: , p_description => p_vo_disc_rec.description
2443: , px_object_version_number => l_struct_object_version
2444: );
3395: -- =========================================================================
3396: -- Validate Environment
3397: -- =========================================================================
3398:
3399: IF FND_GLOBAL.USER_ID IS NULL
3400: THEN
3401: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3402: RAISE FND_API.G_EXC_ERROR;
3403: END IF;
3455: p_end_date_active => l_vo_prod_rec.end_date_active,
3456: p_offer_discount_line_id => l_vo_prod_rec.offer_discount_line_id,
3457: p_offer_id => l_vo_prod_rec.offer_id,
3458: p_creation_date => SYSDATE,
3459: p_created_by => FND_GLOBAL.USER_ID,
3460: p_last_update_date => SYSDATE,
3461: p_last_updated_by => FND_GLOBAL.USER_ID,
3462: p_last_update_login => FND_GLOBAL.conc_login_id,
3463: p_product_context => l_vo_prod_rec.product_context,
3457: p_offer_id => l_vo_prod_rec.offer_id,
3458: p_creation_date => SYSDATE,
3459: p_created_by => FND_GLOBAL.USER_ID,
3460: p_last_update_date => SYSDATE,
3461: p_last_updated_by => FND_GLOBAL.USER_ID,
3462: p_last_update_login => FND_GLOBAL.conc_login_id,
3463: p_product_context => l_vo_prod_rec.product_context,
3464: p_product_attribute => l_vo_prod_rec.product_attribute,
3465: p_product_attr_value => l_vo_prod_rec.product_attr_value,
3458: p_creation_date => SYSDATE,
3459: p_created_by => FND_GLOBAL.USER_ID,
3460: p_last_update_date => SYSDATE,
3461: p_last_updated_by => FND_GLOBAL.USER_ID,
3462: p_last_update_login => FND_GLOBAL.conc_login_id,
3463: p_product_context => l_vo_prod_rec.product_context,
3464: p_product_attribute => l_vo_prod_rec.product_attribute,
3465: p_product_attr_value => l_vo_prod_rec.product_attr_value,
3466: p_apply_discount_flag => l_vo_prod_rec.apply_discount_flag,
3651: p_end_date_active => p_vo_prod_rec.end_date_active,
3652: p_offer_discount_line_id => p_vo_prod_rec.offer_discount_line_id,
3653: p_offer_id => p_vo_prod_rec.offer_id,
3654: p_last_update_date => SYSDATE,
3655: p_last_updated_by => FND_GLOBAL.USER_ID,
3656: p_last_update_login => FND_GLOBAL.conc_login_id,
3657: p_product_context => p_vo_prod_rec.product_context,
3658: p_product_attribute => p_vo_prod_rec.product_attribute,
3659: p_product_attr_value => p_vo_prod_rec.product_attr_value,
3652: p_offer_discount_line_id => p_vo_prod_rec.offer_discount_line_id,
3653: p_offer_id => p_vo_prod_rec.offer_id,
3654: p_last_update_date => SYSDATE,
3655: p_last_updated_by => FND_GLOBAL.USER_ID,
3656: p_last_update_login => FND_GLOBAL.conc_login_id,
3657: p_product_context => p_vo_prod_rec.product_context,
3658: p_product_attribute => p_vo_prod_rec.product_attribute,
3659: p_product_attr_value => p_vo_prod_rec.product_attr_value,
3660: p_apply_discount_flag => p_vo_prod_rec.apply_discount_flag,