The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_constraints (
p_constraints_rec_type IN OUT NOCOPY constraints_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_null VARCHAR2 (10) := NULL;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Start of Insert_Constraints Procedure'
, 3
);
('PN_VAREN_PVT: Insert_Constraints: Input parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_default_id : '
|| p_constraints_rec_type.constr_default_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_default_num : '
|| p_constraints_rec_type.constr_default_num
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.var_rent_id : '
|| p_constraints_rec_type.var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.agreement_template_id : '
|| p_constraints_rec_type.agreement_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_template_id : '
|| p_constraints_rec_type.constr_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_start_date : '
|| p_constraints_rec_type.constr_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_end_date : '
|| p_constraints_rec_type.constr_end_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_cat_code : '
|| p_constraints_rec_type.constr_cat_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_type_code : '
|| p_constraints_rec_type.constr_type_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_amount : '
|| p_constraints_rec_type.constr_amount
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.g_org_id : '
|| g_org_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.attribute_category : '
|| p_constraints_rec_type.attribute_category
, 3
);
pn_var_constr_defaults_pkg.insert_row (x_rowid => g_rowid
, x_constr_default_id => p_constraints_rec_type.constr_default_id
, x_constr_default_num => p_constraints_rec_type.constr_default_num
, x_var_rent_id => p_constraints_rec_type.var_rent_id
, x_agreement_template_id => p_constraints_rec_type.agreement_template_id
, x_constr_template_id => p_constraints_rec_type.constr_template_id
, x_constr_start_date => p_constraints_rec_type.constr_start_date
, x_constr_end_date => p_constraints_rec_type.constr_end_date
, x_constr_cat_code => NVL
(p_constraints_rec_type.constr_cat_code
, 'VARENT'
)
, x_type_code => p_constraints_rec_type.constr_type_code
, x_amount => p_constraints_rec_type.constr_amount
, x_creation_date => NVL (p_constraints_rec_type.creation_date
, g_sysdate
)
, x_created_by => NVL (p_constraints_rec_type.created_by
, g_user_id
)
, x_last_update_date => NVL
(p_constraints_rec_type.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL
(p_constraints_rec_type.last_updated_by
, g_user_id
)
, x_last_update_login => NVL
(p_constraints_rec_type.last_update_login
, g_user_id
)
, x_org_id => g_org_id
, x_attribute_category => p_constraints_rec_type.attribute_category
, x_attribute1 => p_constraints_rec_type.attribute1
, x_attribute2 => p_constraints_rec_type.attribute2
, x_attribute3 => p_constraints_rec_type.attribute3
, x_attribute4 => p_constraints_rec_type.attribute4
, x_attribute5 => p_constraints_rec_type.attribute5
, x_attribute6 => p_constraints_rec_type.attribute6
, x_attribute7 => p_constraints_rec_type.attribute7
, x_attribute8 => p_constraints_rec_type.attribute8
, x_attribute9 => p_constraints_rec_type.attribute9
, x_attribute10 => p_constraints_rec_type.attribute10
, x_attribute11 => p_constraints_rec_type.attribute11
, x_attribute12 => p_constraints_rec_type.attribute12
, x_attribute13 => p_constraints_rec_type.attribute13
, x_attribute14 => p_constraints_rec_type.attribute14
, x_attribute15 => p_constraints_rec_type.attribute15
);
('PN_VAREN_PVT: Insert_Constraints: End of parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'
, 3
);
( 'PN_VAREN_PVT: Insert_Constraints: Exception Result of Pn_Var_Constr_Defaults_Pkg.Insert_Row procedure : '
|| SQLERRM
, 3
);
END insert_constraints;
PROCEDURE update_constraints (
p_constraints_rec_type IN OUT NOCOPY constraints_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_null VARCHAR2 (10) := NULL;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Start of Update_Constraints Procedure'
, 3
);
('PN_VAREN_PVT: Update_Constraints: Start of Input parameters to pn_var_constr_defaults_pkg.update_row package'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_default_id : '
|| p_constraints_rec_type.constr_default_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_default_num : '
|| p_constraints_rec_type.constr_default_num
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.var_rent_id : '
|| p_constraints_rec_type.var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.agreement_template_id : '
|| p_constraints_rec_type.agreement_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_template_id : '
|| p_constraints_rec_type.constr_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_start_date : '
|| p_constraints_rec_type.constr_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_end_date : '
|| p_constraints_rec_type.constr_end_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_cat_code : '
|| p_constraints_rec_type.constr_cat_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_type_code : '
|| p_constraints_rec_type.constr_type_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_amount : '
|| p_constraints_rec_type.constr_amount
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.g_org_id : '
|| g_org_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.attribute_category : '
|| p_constraints_rec_type.attribute_category
, 3
);
('PN_VAREN_PVT: Update_Constraints: End of Input parameters to pn_var_constr_defaults_pkg.update_row package'
, 3
);
pn_var_constr_defaults_pkg.update_row
(x_constr_default_id => p_constraints_rec_type.constr_default_id
, x_constr_default_num => p_constraints_rec_type.constr_default_num
, x_var_rent_id => p_constraints_rec_type.var_rent_id
, x_agreement_template_id => p_constraints_rec_type.agreement_template_id
, x_constr_template_id => p_constraints_rec_type.constr_template_id
, x_constr_start_date => p_constraints_rec_type.constr_start_date
, x_constr_end_date => p_constraints_rec_type.constr_end_date
, x_constr_cat_code => NVL
(p_constraints_rec_type.constr_cat_code
, 'VARENT'
) -- IMP -- check the value in the updated record
, x_type_code => p_constraints_rec_type.constr_type_code
, x_amount => p_constraints_rec_type.constr_amount
, x_last_update_date => g_sysdate --p_constraints_rec_type.last_update_date
, x_last_updated_by => g_user_id --p_constraints_rec_type.last_updated_by
, x_last_update_login => g_user_id --p_constraints_rec_type.last_update_login
, x_attribute_category => p_constraints_rec_type.attribute_category
, x_attribute1 => p_constraints_rec_type.attribute1
, x_attribute2 => p_constraints_rec_type.attribute2
, x_attribute3 => p_constraints_rec_type.attribute3
, x_attribute4 => p_constraints_rec_type.attribute4
, x_attribute5 => p_constraints_rec_type.attribute5
, x_attribute6 => p_constraints_rec_type.attribute6
, x_attribute7 => p_constraints_rec_type.attribute7
, x_attribute8 => p_constraints_rec_type.attribute8
, x_attribute9 => p_constraints_rec_type.attribute9
, x_attribute10 => p_constraints_rec_type.attribute10
, x_attribute11 => p_constraints_rec_type.attribute11
, x_attribute12 => p_constraints_rec_type.attribute12
, x_attribute13 => p_constraints_rec_type.attribute13
, x_attribute14 => p_constraints_rec_type.attribute14
, x_attribute15 => p_constraints_rec_type.attribute15
);
('PN_VAREN_PVT: Update_Constraints: End of parameters to pn_var_constr_defaults_pkg.update_Row package'
, 3
);
( 'PN_VAREN_PVT: Update_Constraints: Exception Result of Update_Constraints procedure : '
|| SQLERRM
, 3
);
END update_constraints;
SELECT COUNT (*)
, constr_default_id
FROM pn_var_constr_defaults_all
WHERE var_rent_id = p_var_rent_id
GROUP BY constr_default_id;
DELETE FROM pn_var_constraints_all
WHERE constr_default_id IN (SELECT constr_default_id
FROM pn_var_constr_defaults_all
WHERE var_rent_id = p_var_rent_id);
SELECT COUNT (*)
-- ,bkdt_default_id
FROM pn_var_bkdt_defaults_all pvbd
WHERE pvbd.var_rent_id = p_var_rent_id;
SELECT line_default_id
FROM pn_var_line_defaults_all
WHERE var_rent_id = p_var_rent_id;
SELECT bkhd_default_id
FROM pn_var_bkhd_defaults_all
WHERE line_default_id = l_line_def_id;
SELECT 'x'
FROM DUAL
WHERE EXISTS (SELECT bkhd_default_id
FROM pn_var_bkhd_defaults_all
WHERE var_rent_id = p_var_rent_id);
pn_var_defaults_pkg.delete_default_lines (p_var_rent_id
, exists_hd_def_rec.bkhd_default_id
, l_bkpt_header_id
);
pn_var_defaults_pkg.delete_transactions (p_var_rent_id
, exists_hd_def_rec.bkhd_default_id
, l_bkpt_header_id
);
PROCEDURE insert_allow_abat (
p_allow_abat_rec_type IN OUT NOCOPY allow_abat_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_rowid VARCHAR2 (18);
('PN_VAREN_PVT: Insert_Allow_Abat: Start of Input parameters for pn_var_abat_defaults_pkg.insert_row package'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.abatement_Id : '
|| p_allow_abat_rec_type.abatement_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.abat_START_DATE : '
|| p_allow_abat_rec_type.abat_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.abat_END_DATE : '
|| p_allow_abat_rec_type.abat_end_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.abat_TYPE_CODE : '
|| p_allow_abat_rec_type.abat_type_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.abat_AMOUNT : '
|| p_allow_abat_rec_type.abat_amount
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.COMMENTS : '
|| p_allow_abat_rec_type.comments
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.DESCRIPTION : '
|| p_allow_abat_rec_type.description
, 3
);
( 'PN_VAREN_PVT: Insert_Allow_Abat: substr(p_allow_abat_rec_type.description , 1, 29) : '
|| SUBSTR (p_allow_abat_rec_type.description
, 1
, 29
)
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Allow_Abat: p_allow_abat_rec_type.VAR_RENT_ID : '
|| p_allow_abat_rec_type.var_rent_id
, 3
);
('PN_VAREN_PVT: Insert_Allow_Abat: End of Input parameters for pn_var_abat_defaults_pkg.insert_row package'
, 3
);
pn_var_abat_defaults_pkg.insert_row (x_rowid => l_rowid
, x_abatement_id => p_allow_abat_rec_type.abatement_id
, x_var_rent_id => TO_NUMBER (p_allow_abat_rec_type.var_rent_id)
, x_start_date => p_allow_abat_rec_type.abat_start_date
, x_end_date => p_allow_abat_rec_type.abat_end_date
, x_type_code => p_allow_abat_rec_type.abat_type_code
, x_amount => TO_NUMBER (p_allow_abat_rec_type.abat_amount)
, x_description => p_allow_abat_rec_type.description
--substr (p_allow_abat_rec_type.description,1, 30)
, x_creation_date => NVL (p_allow_abat_rec_type.creation_date
, g_sysdate
)
, x_created_by => NVL (p_allow_abat_rec_type.created_by
, g_user_id
)
, x_last_update_date => NVL (p_allow_abat_rec_type.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL (p_allow_abat_rec_type.last_updated_by
, g_user_id
)
, x_last_update_login => NVL
(p_allow_abat_rec_type.last_update_login
, g_user_id
)
, x_comments => p_allow_abat_rec_type.comments
, x_attribute_category => p_allow_abat_rec_type.attribute_category
, x_attribute1 => p_allow_abat_rec_type.attribute1
, x_attribute2 => p_allow_abat_rec_type.attribute2
, x_attribute3 => p_allow_abat_rec_type.attribute3
, x_attribute4 => p_allow_abat_rec_type.attribute4
, x_attribute5 => p_allow_abat_rec_type.attribute5
, x_attribute6 => p_allow_abat_rec_type.attribute6
, x_attribute7 => p_allow_abat_rec_type.attribute7
, x_attribute8 => p_allow_abat_rec_type.attribute8
, x_attribute9 => p_allow_abat_rec_type.attribute9
, x_attribute10 => p_allow_abat_rec_type.attribute10
, x_attribute11 => p_allow_abat_rec_type.attribute11
, x_attribute12 => p_allow_abat_rec_type.attribute12
, x_attribute13 => p_allow_abat_rec_type.attribute13
, x_attribute14 => p_allow_abat_rec_type.attribute14
, x_attribute15 => p_allow_abat_rec_type.attribute15
, x_org_id => g_org_id --l_org_id
);
('PN_VAREN_PVT: Insert_Allow_Abat: Success Result of pn_var_abat_defaults_pkg.insert_row package'
, 3
);
( 'PN_VAREN_PVT: Insert_Allow_Abat: Exception Result of insert_allow_and_abat procedure : '
|| SQLERRM
, 3
);
END insert_allow_abat;
PROCEDURE update_allow_abat (
p_allow_abat_rec_type IN OUT NOCOPY allow_abat_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_rowid VARCHAR2 (18);
('PN_VAREN_PVT: Update_Allow_Abat: Start of Input parameters for pn_var_abat_defaults_pkg.update_row package'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.abatement_Id : '
|| p_allow_abat_rec_type.abatement_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.abat_START_DATE : '
|| p_allow_abat_rec_type.abat_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.abat_END_DATE : '
|| p_allow_abat_rec_type.abat_end_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.abat_TYPE_CODE : '
|| p_allow_abat_rec_type.abat_type_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.abat_AMOUNT : '
|| p_allow_abat_rec_type.abat_amount
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.COMMENTS : '
|| p_allow_abat_rec_type.comments
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.DESCRIPTION : '
|| p_allow_abat_rec_type.description
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Allow_Abat: p_allow_abat_rec_type.VAR_RENT_ID : '
|| p_allow_abat_rec_type.var_rent_id
, 3
);
('PN_VAREN_PVT: Update_Allow_Abat: End of Input parameters for pn_var_abat_defaults_pkg.update_row package'
, 3
);
( 'PN_VAREN_PVT: Update_Allow_Abat: Values ofp_allow_abat_rec_type.abatement_id and p_allow_abat_rec_type.abat_type_code'
|| p_allow_abat_rec_type.abatement_id
|| '-'
|| p_allow_abat_rec_type.abat_type_code
, 3
);
pn_var_abat_defaults_pkg.update_row (x_abatement_id => p_allow_abat_rec_type.abatement_id
, x_var_rent_id => p_allow_abat_rec_type.var_rent_id
, x_start_date => p_allow_abat_rec_type.abat_start_date
, x_end_date => p_allow_abat_rec_type.abat_end_date
, x_type_code => p_allow_abat_rec_type.abat_type_code
, x_amount => p_allow_abat_rec_type.abat_amount
, x_description => p_allow_abat_rec_type.description
, x_last_update_date => g_sysdate
--p_allow_abat_rec_type.last_update_date
, x_last_updated_by => g_user_id
--p_allow_abat_rec_type.last_updated_by
, x_creation_date => p_allow_abat_rec_type.creation_date
, x_created_by => p_allow_abat_rec_type.created_by
, x_last_update_login => g_user_id
--p_allow_abat_rec_type.last_update_login
, x_comments => p_allow_abat_rec_type.comments
, x_attribute_category => p_allow_abat_rec_type.attribute_category
, x_attribute1 => p_allow_abat_rec_type.attribute1
, x_attribute2 => p_allow_abat_rec_type.attribute2
, x_attribute3 => p_allow_abat_rec_type.attribute3
, x_attribute4 => p_allow_abat_rec_type.attribute4
, x_attribute5 => p_allow_abat_rec_type.attribute5
, x_attribute6 => p_allow_abat_rec_type.attribute6
, x_attribute7 => p_allow_abat_rec_type.attribute7
, x_attribute8 => p_allow_abat_rec_type.attribute8
, x_attribute9 => p_allow_abat_rec_type.attribute9
, x_attribute10 => p_allow_abat_rec_type.attribute10
, x_attribute11 => p_allow_abat_rec_type.attribute11
, x_attribute12 => p_allow_abat_rec_type.attribute12
, x_attribute13 => p_allow_abat_rec_type.attribute13
, x_attribute14 => p_allow_abat_rec_type.attribute14
, x_attribute15 => p_allow_abat_rec_type.attribute15
, x_org_id => p_allow_abat_rec_type.org_id
);
('PN_VAREN_PVT: Update_Allow_Abat: Success Result of pn_var_abat_defaults_pkg.update_row package'
, 3
);
( 'PN_VAREN_PVT: Update_Allow_Abat: Exception Result of Update_allow_abat procedure : '
|| SQLERRM
, 3
);
END update_allow_abat;
PROCEDURE insert_breakpoint_details (
p_breakpoint_details_rec_type IN OUT NOCOPY breakpoint_details_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_rowid VARCHAR2 (18);
('PN_VAREN_PVT: Insert_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DEFAULT_ID : '
|| p_breakpoint_details_rec_type.bkdt_default_id
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DETAIL_NUM : '
|| p_breakpoint_details_rec_type.bkdt_detail_num
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKHD_DEFAULT_ID : '
|| p_breakpoint_details_rec_type.bkhd_default_id
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_START_DATE : '
|| p_breakpoint_details_rec_type.bkdt_start_date
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_END_DATE : '
|| p_breakpoint_details_rec_type.bkdt_end_date
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.PERIOD_BKPT_VOL_START : '
|| p_breakpoint_details_rec_type.period_bkpt_vol_start
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.PERIOD_BKPT_VOL_END : '
|| p_breakpoint_details_rec_type.period_bkpt_vol_end
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.GROUP_BKPT_VOL_START : '
|| p_breakpoint_details_rec_type.group_bkpt_vol_start
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.GROUP_BKPT_VOL_END : '
|| p_breakpoint_details_rec_type.group_bkpt_vol_end
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.VAR_RENT_ID : '
|| p_breakpoint_details_rec_type.var_rent_id
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.ANNUAL_BASIS_AMOUNT : '
|| p_breakpoint_details_rec_type.annual_basis_amount
, 3
);
('PN_VAREN_PVT: Insert_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'
, 3
);
pn_varen_util.pvt_debug ( ' Value of bkdt_detail_num , before pn_var_bkdt_defaults_pkg.insert_row : '
|| p_breakpoint_details_rec_type.bkdt_detail_num
, 3
);
pn_varen_util.pvt_debug ( ' Value of bkpt_rate , before pn_var_bkdt_defaults_pkg.insert_row : '
|| p_breakpoint_details_rec_type.bkpt_rate
, 3
);
pn_var_bkdt_defaults_pkg.insert_row
(x_rowid => l_rowid
, x_bkdt_default_id => p_breakpoint_details_rec_type.bkdt_default_id
, x_bkdt_detail_num => p_breakpoint_details_rec_type.bkdt_detail_num
, x_bkhd_default_id => p_breakpoint_details_rec_type.bkhd_default_id
, x_bkdt_start_date => p_breakpoint_details_rec_type.bkdt_start_date
, x_bkdt_end_date => p_breakpoint_details_rec_type.bkdt_end_date
, x_period_bkpt_vol_start => p_breakpoint_details_rec_type.period_bkpt_vol_start
, x_period_bkpt_vol_end => p_breakpoint_details_rec_type.period_bkpt_vol_end
, x_group_bkpt_vol_start => p_breakpoint_details_rec_type.group_bkpt_vol_start
, x_group_bkpt_vol_end => p_breakpoint_details_rec_type.group_bkpt_vol_end
, x_bkpt_rate => p_breakpoint_details_rec_type.bkpt_rate
, x_processed_flag => l_null
, x_var_rent_id => p_breakpoint_details_rec_type.var_rent_id
, x_creation_date => NVL
(p_breakpoint_details_rec_type.creation_date
, g_sysdate
)
, x_created_by => NVL (p_breakpoint_details_rec_type.created_by
, g_user_id
)
, x_last_update_date => NVL
(p_breakpoint_details_rec_type.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL
(p_breakpoint_details_rec_type.last_updated_by
, g_user_id
)
, x_last_update_login => NVL
(p_breakpoint_details_rec_type.last_update_login
, g_user_id
)
, x_org_id => g_org_id --l_org_id
, x_annual_basis_amount => p_breakpoint_details_rec_type.annual_basis_amount
, x_attribute_category => p_breakpoint_details_rec_type.attribute_category
, x_attribute1 => p_breakpoint_details_rec_type.attribute1
, x_attribute2 => p_breakpoint_details_rec_type.attribute2
, x_attribute3 => p_breakpoint_details_rec_type.attribute3
, x_attribute4 => p_breakpoint_details_rec_type.attribute4
, x_attribute5 => p_breakpoint_details_rec_type.attribute5
, x_attribute6 => p_breakpoint_details_rec_type.attribute6
, x_attribute7 => p_breakpoint_details_rec_type.attribute7
, x_attribute8 => p_breakpoint_details_rec_type.attribute8
, x_attribute9 => p_breakpoint_details_rec_type.attribute9
, x_attribute10 => p_breakpoint_details_rec_type.attribute10
, x_attribute11 => p_breakpoint_details_rec_type.attribute11
, x_attribute12 => p_breakpoint_details_rec_type.attribute12
, x_attribute13 => p_breakpoint_details_rec_type.attribute13
, x_attribute14 => p_breakpoint_details_rec_type.attribute14
, x_attribute15 => p_breakpoint_details_rec_type.attribute15
);
('PN_VAREN_PVT: Insert_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.insert_row package'
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Details: Exception Result of insert_breakpoint_Details procedure : '
|| SQLERRM
, 3
);
END insert_breakpoint_details;
PROCEDURE update_breakpoint_details (
p_breakpoint_details_rec_type IN OUT NOCOPY breakpoint_details_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_not_used VARCHAR2 (20) := NULL;
('PN_VAREN_PVT: Update_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DEFAULT_ID : '
|| p_breakpoint_details_rec_type.bkdt_default_id
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DETAIL_NUM : '
|| p_breakpoint_details_rec_type.bkdt_detail_num
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKHD_DEFAULT_ID : '
|| p_breakpoint_details_rec_type.bkhd_default_id
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_START_DATE : '
|| p_breakpoint_details_rec_type.bkdt_start_date
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_END_DATE : '
|| p_breakpoint_details_rec_type.bkdt_end_date
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.PERIOD_BKPT_VOL_START : '
|| p_breakpoint_details_rec_type.period_bkpt_vol_start
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.PERIOD_BKPT_VOL_END : '
|| p_breakpoint_details_rec_type.period_bkpt_vol_end
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.GROUP_BKPT_VOL_START : '
|| p_breakpoint_details_rec_type.group_bkpt_vol_start
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.GROUP_BKPT_VOL_END : '
|| p_breakpoint_details_rec_type.group_bkpt_vol_end
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.VAR_RENT_ID : '
|| p_breakpoint_details_rec_type.var_rent_id
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.ANNUAL_BASIS_AMOUNT : '
|| p_breakpoint_details_rec_type.annual_basis_amount
, 3
);
('PN_VAREN_PVT: Update_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'
, 3
);
pn_var_bkdt_defaults_pkg.update_row
(x_bkdt_default_id => p_breakpoint_details_rec_type.bkdt_default_id
, x_bkdt_detail_num => p_breakpoint_details_rec_type.bkdt_detail_num
, x_bkhd_default_id => p_breakpoint_details_rec_type.bkhd_default_id
, x_bkdt_start_date => p_breakpoint_details_rec_type.bkdt_start_date
, x_bkdt_end_date => p_breakpoint_details_rec_type.bkdt_end_date
, x_period_bkpt_vol_start => p_breakpoint_details_rec_type.period_bkpt_vol_start
, x_period_bkpt_vol_end => p_breakpoint_details_rec_type.period_bkpt_vol_end
, x_group_bkpt_vol_start => p_breakpoint_details_rec_type.group_bkpt_vol_start
, x_group_bkpt_vol_end => p_breakpoint_details_rec_type.group_bkpt_vol_end
, x_bkpt_rate => p_breakpoint_details_rec_type.bkpt_rate
, x_processed_flag => l_not_used
-- IMP p_breakpoint_details_rec_type.PROCESSED_FLAG
, x_var_rent_id => p_breakpoint_details_rec_type.var_rent_id
, x_last_update_date => g_sysdate
--p_breakpoint_details_rec_type.last_update_date
, x_last_updated_by => g_user_id
--p_breakpoint_details_rec_type.last_updated_by
, x_last_update_login => g_user_id
--p_breakpoint_details_rec_type.last_update_login
, x_annual_basis_amount => l_not_used
, x_attribute_category => p_breakpoint_details_rec_type.attribute_category
, x_attribute1 => p_breakpoint_details_rec_type.attribute1
, x_attribute2 => p_breakpoint_details_rec_type.attribute2
, x_attribute3 => p_breakpoint_details_rec_type.attribute3
, x_attribute4 => p_breakpoint_details_rec_type.attribute4
, x_attribute5 => p_breakpoint_details_rec_type.attribute5
, x_attribute6 => p_breakpoint_details_rec_type.attribute6
, x_attribute7 => p_breakpoint_details_rec_type.attribute7
, x_attribute8 => p_breakpoint_details_rec_type.attribute8
, x_attribute9 => p_breakpoint_details_rec_type.attribute9
, x_attribute10 => p_breakpoint_details_rec_type.attribute10
, x_attribute11 => p_breakpoint_details_rec_type.attribute11
, x_attribute12 => p_breakpoint_details_rec_type.attribute12
, x_attribute13 => p_breakpoint_details_rec_type.attribute13
, x_attribute14 => p_breakpoint_details_rec_type.attribute14
, x_attribute15 => p_breakpoint_details_rec_type.attribute15
);
('PN_VAREN_PVT: Update_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.update_row package'
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Details: Exception Result of update_breakpoint_details procedure : '
|| SQLERRM
, 3
);
END update_breakpoint_details;
PROCEDURE insert_breakpoint_headers (
p_breakpoint_header_rec_type IN OUT NOCOPY breakpoint_header_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_not_used VARCHAR2 (20) := NULL;
('PN_VAREN_PVT: Insert_Breakpoint_Headers: Start of Input parameters for pn_var_bkhd_defaults_pkg.insert_row package'
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_default_id : '
|| p_breakpoint_header_rec_type.bkhd_default_id
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_detail_num : '
|| p_breakpoint_header_rec_type.bkhd_detail_num
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.line_default_id : '
|| p_breakpoint_header_rec_type.line_default_id
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_start_date : '
|| p_breakpoint_header_rec_type.bkhd_start_date
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_end_date : '
|| p_breakpoint_header_rec_type.bkhd_end_date
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.break_type_code : '
|| p_breakpoint_header_rec_type.break_type_code
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.natural_break_rate : '
|| p_breakpoint_header_rec_type.natural_break_rate
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: p_breakpoint_header_rec_type.var_rent_id : '
|| p_breakpoint_header_rec_type.var_rent_id
, 3
);
('PN_VAREN_PVT: Insert_Breakpoint_Headers: End of Input parameters for pn_var_bkhd_defaults_pkg.insert_row package'
, 3
);
('PN_VAREN_PVT: Insert_Breakpoint_Headers: Before the Package pn_var_bkhd_defaults_pkg.insert_row'
, 3
);
pn_var_bkhd_defaults_pkg.insert_row
(x_rowid => g_rowid
, x_bkhd_default_id => p_breakpoint_header_rec_type.bkhd_default_id
, x_bkhd_detail_num => p_breakpoint_header_rec_type.bkhd_detail_num
, x_line_default_id => p_breakpoint_header_rec_type.line_default_id
, x_bkpt_head_template_id => l_not_used
, x_agreement_template_id => l_not_used
, x_bkhd_start_date => p_breakpoint_header_rec_type.bkhd_start_date
, x_bkhd_end_date => p_breakpoint_header_rec_type.bkhd_end_date
, x_break_type => p_breakpoint_header_rec_type.break_type_code
, x_base_rent_type => l_base_rent_type
, x_natural_break_rate => p_breakpoint_header_rec_type.natural_break_rate
, x_base_rent => l_not_used
, x_breakpoint_type => p_breakpoint_header_rec_type.breakpoint_type_code
, x_breakpoint_level => l_not_used
, x_processed_flag => l_not_used
, x_var_rent_id => p_breakpoint_header_rec_type.var_rent_id
, x_creation_date => NVL
(p_breakpoint_header_rec_type.creation_date
, g_sysdate
)
, x_created_by => NVL
(p_breakpoint_header_rec_type.created_by
, g_user_id
)
, x_last_update_date => NVL
(p_breakpoint_header_rec_type.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL
(p_breakpoint_header_rec_type.last_updated_by
, g_user_id
)
, x_last_update_login => NVL
(p_breakpoint_header_rec_type.last_update_login
, g_user_id
)
, x_org_id => g_org_id --l_org_id
, x_attribute_category => p_breakpoint_header_rec_type.attribute_category
, x_attribute1 => p_breakpoint_header_rec_type.attribute1
, x_attribute2 => p_breakpoint_header_rec_type.attribute2
, x_attribute3 => p_breakpoint_header_rec_type.attribute3
, x_attribute4 => p_breakpoint_header_rec_type.attribute4
, x_attribute5 => p_breakpoint_header_rec_type.attribute5
, x_attribute6 => p_breakpoint_header_rec_type.attribute6
, x_attribute7 => p_breakpoint_header_rec_type.attribute7
, x_attribute8 => p_breakpoint_header_rec_type.attribute8
, x_attribute9 => p_breakpoint_header_rec_type.attribute9
, x_attribute10 => p_breakpoint_header_rec_type.attribute10
, x_attribute11 => p_breakpoint_header_rec_type.attribute11
, x_attribute12 => p_breakpoint_header_rec_type.attribute12
, x_attribute13 => p_breakpoint_header_rec_type.attribute13
, x_attribute14 => p_breakpoint_header_rec_type.attribute14
, x_attribute15 => p_breakpoint_header_rec_type.attribute15
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: Exception Result of pn_var_bkhd_defaults_pkg.insert_row package : '
|| SQLERRM
, 3
);
('PN_VAREN_PVT: Insert_Breakpoint_Headers: Success Result of pn_var_bkhd_defaults_pkg.insert_row package'
, 3
);
( 'PN_VAREN_PVT: Insert_Breakpoint_Headers: Exception Result of insert_breakpoint_headers procedure : '
|| SQLERRM
, 3
);
END insert_breakpoint_headers;
PROCEDURE update_breakpoint_headers (
p_breakpoint_header_rec_type IN OUT NOCOPY breakpoint_header_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_not_used VARCHAR2 (20) := NULL;
('PN_VAREN_PVT: Update_Breakpoint_Headers: Start of Input parameters for pn_var_bkhd_defaults_pkg.update_row package'
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_default_id : '
|| p_breakpoint_header_rec_type.bkhd_default_id
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_detail_num : '
|| p_breakpoint_header_rec_type.bkhd_detail_num
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.line_default_id : '
|| p_breakpoint_header_rec_type.line_default_id
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_start_date : '
|| p_breakpoint_header_rec_type.bkhd_start_date
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.bkhd_end_date : '
|| p_breakpoint_header_rec_type.bkhd_end_date
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.break_type_code : '
|| p_breakpoint_header_rec_type.break_type_code
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.natural_break_rate : '
|| p_breakpoint_header_rec_type.natural_break_rate
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: p_breakpoint_header_rec_type.var_rent_id : '
|| p_breakpoint_header_rec_type.var_rent_id
, 3
);
('PN_VAREN_PVT: Update_Breakpoint_Headers: End of Input parameters for pn_var_bkhd_defaults_pkg.update_row package'
, 3
);
pn_var_bkhd_defaults_pkg.update_row (x_bkhd_default_id => p_breakpoint_header_rec_type.bkhd_default_id
, x_bkhd_detail_num => p_breakpoint_header_rec_type.bkhd_detail_num
, x_line_default_id => p_breakpoint_header_rec_type.line_default_id
, x_bkpt_head_template_id => l_not_used
-- p_breakpoint_header_rec_type.BKPT_HEAD_TEMPLATE_ID
, x_agreement_template_id => l_not_used
--IMP modify the table type--p_breakpoint_header_rec_type.AGREEMENT_TEMPLATE_ID
, x_bkhd_start_date => p_breakpoint_header_rec_type.bkhd_start_date
, x_bkhd_end_date => p_breakpoint_header_rec_type.bkhd_end_date
, x_break_type => p_breakpoint_header_rec_type.break_type_code
, x_base_rent_type => l_base_rent_type
--IMP --'ROLLING'either for break_type_code ARTIFICAL OR NATURAL --p_breakpoint_header_rec_type.BASE_RENT_TYPE
, x_natural_break_rate => p_breakpoint_header_rec_type.natural_break_rate
, x_base_rent => l_not_used
--p_breakpoint_header_rec_type.BASE_RENT
, x_breakpoint_type => p_breakpoint_header_rec_type.breakpoint_type_code
, x_breakpoint_level => l_not_used
--p_breakpoint_header_rec_type.BREAKPOINT_LEVEL
, x_processed_flag => l_not_used
--p_breakpoint_header_rec_type.PROCESSED_FLAG
, x_var_rent_id => p_breakpoint_header_rec_type.var_rent_id
, x_last_update_date => g_sysdate
--p_breakpoint_header_rec_type.last_update_date
, x_last_updated_by => g_user_id
--p_breakpoint_header_rec_type.last_updated_by
, x_last_update_login => g_user_id
--p_breakpoint_header_rec_type.last_update_login
, x_attribute_category => p_breakpoint_header_rec_type.attribute_category
, x_attribute1 => p_breakpoint_header_rec_type.attribute1
, x_attribute2 => p_breakpoint_header_rec_type.attribute2
, x_attribute3 => p_breakpoint_header_rec_type.attribute3
, x_attribute4 => p_breakpoint_header_rec_type.attribute4
, x_attribute5 => p_breakpoint_header_rec_type.attribute5
, x_attribute6 => p_breakpoint_header_rec_type.attribute6
, x_attribute7 => p_breakpoint_header_rec_type.attribute7
, x_attribute8 => p_breakpoint_header_rec_type.attribute8
, x_attribute9 => p_breakpoint_header_rec_type.attribute9
, x_attribute10 => p_breakpoint_header_rec_type.attribute10
, x_attribute11 => p_breakpoint_header_rec_type.attribute11
, x_attribute12 => p_breakpoint_header_rec_type.attribute12
, x_attribute13 => p_breakpoint_header_rec_type.attribute13
, x_attribute14 => p_breakpoint_header_rec_type.attribute14
, x_attribute15 => p_breakpoint_header_rec_type.attribute15
);
('PN_VAREN_PVT: Update_Breakpoint_Headers: Success Result of pn_var_bkhd_defaults_pkg.update_row package'
, 3
);
( 'PN_VAREN_PVT: Update_Breakpoint_Headers: Exception Result of update_breakpoint_headers procedure : '
|| SQLERRM
, 3
);
END update_breakpoint_headers;
PROCEDURE insert_variable_rent_lines (
p_variable_rent_lines_rec_type IN OUT NOCOPY variable_rent_lines_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_line_default_id pn_var_line_defaults_all.line_default_id%TYPE := NULL;
('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW Package'
, 3
);
('PN_VAREN_PVT: Insert_Variable_Rent_Lines: START OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.var_rent_id : '
|| p_variable_rent_lines_rec_type.var_rent_id
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.var_rent_num: '
|| p_variable_rent_lines_rec_type.var_rent_num
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: G_ORG_ID : '
|| g_org_id
, 3
);
SELECT commencement_date
, termination_date
, agreement_template_id
, var_rent_id
INTO l_line_start_date
, l_line_end_date
, l_agreement_template_id
, l_var_rent_id
FROM pn_var_rents_all
WHERE ( var_rent_id = p_variable_rent_lines_rec_type.var_rent_id
OR rent_num = p_variable_rent_lines_rec_type.var_rent_num
)
AND org_id = g_org_id
GROUP BY commencement_date
, termination_date
, agreement_template_id
, var_rent_id;
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: Var_rent_id does not exist, please check the var_rent_id : '
|| SQLERRM
, 3
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling Insert Row package'
, 3
);
('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.line_default_id : '
|| p_variable_rent_lines_rec_type.line_default_id
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.line_num : '
|| p_variable_rent_lines_rec_type.line_num
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.var_rent_id : '
|| p_variable_rent_lines_rec_type.var_rent_id
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.sales_channel_code : '
|| p_variable_rent_lines_rec_type.sales_channel_code
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.item_category_code : '
|| p_variable_rent_lines_rec_type.item_category_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: l_agreement_template_id : '
|| l_agreement_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: l_line_start_date : '
|| l_line_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: g_org_id : '
|| g_org_id
, 3
);
('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'
, 3
);
pn_var_line_defaults_pkg.insert_row
(x_rowid => g_rowid
, x_line_default_id => p_variable_rent_lines_rec_type.line_default_id
, x_line_num => p_variable_rent_lines_rec_type.line_num
, x_var_rent_id => p_variable_rent_lines_rec_type.var_rent_id
, x_sales_type_code => p_variable_rent_lines_rec_type.sales_channel_code
, x_item_category_code => p_variable_rent_lines_rec_type.item_category_code
, x_line_template_id => NULL
-- not used in pn_var_line_defaults_all
, x_agreement_template_id => l_agreement_template_id
, x_line_start_date => l_line_start_date
, x_line_end_date => l_line_end_date
, x_processed_flag => l_processed_flag
, x_creation_date => NVL
(p_variable_rent_lines_rec_type.creation_date
, g_sysdate
)
, x_created_by => NVL
(p_variable_rent_lines_rec_type.created_by
, g_user_id
)
, x_last_update_date => NVL
(p_variable_rent_lines_rec_type.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL
(p_variable_rent_lines_rec_type.last_updated_by
, g_user_id
)
, x_last_update_login => NVL
(p_variable_rent_lines_rec_type.last_update_login
, g_user_id
)
, x_org_id => g_org_id
, x_attribute_category => p_variable_rent_lines_rec_type.attribute_category
, x_attribute1 => p_variable_rent_lines_rec_type.attribute1
, x_attribute2 => p_variable_rent_lines_rec_type.attribute2
, x_attribute3 => p_variable_rent_lines_rec_type.attribute3
, x_attribute4 => p_variable_rent_lines_rec_type.attribute4
, x_attribute5 => p_variable_rent_lines_rec_type.attribute5
, x_attribute6 => p_variable_rent_lines_rec_type.attribute6
, x_attribute7 => p_variable_rent_lines_rec_type.attribute7
, x_attribute8 => p_variable_rent_lines_rec_type.attribute8
, x_attribute9 => p_variable_rent_lines_rec_type.attribute9
, x_attribute10 => p_variable_rent_lines_rec_type.attribute10
, x_attribute11 => p_variable_rent_lines_rec_type.attribute11
, x_attribute12 => p_variable_rent_lines_rec_type.attribute12
, x_attribute13 => p_variable_rent_lines_rec_type.attribute13
, x_attribute14 => p_variable_rent_lines_rec_type.attribute14
, x_attribute15 => p_variable_rent_lines_rec_type.attribute15
);
('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
, 3
);
( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
|| SQLERRM
, 3
);
END insert_variable_rent_lines;
PROCEDURE update_variable_rent_lines (
p_variable_rent_lines_rec_type IN OUT NOCOPY variable_rent_lines_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_not_used NUMBER DEFAULT NULL;
('PN_VAREN_PVT: Update_Variable_Rent_Lines: Start of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LINE_DEFAULT_ID : '
|| p_variable_rent_lines_rec_type.line_default_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LINE_NUM : '
|| p_variable_rent_lines_rec_type.line_num
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : VAR_RENT_ID : '
|| p_variable_rent_lines_rec_type.var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : SALES_CHANNEL_CODE : '
|| p_variable_rent_lines_rec_type.sales_channel_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : ITEM_CATEGORY_CODE : '
|| p_variable_rent_lines_rec_type.item_category_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : AGREEMENT_TEMPLATE_ID : '
|| p_variable_rent_lines_rec_type.agreement_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LINE_START_DATE : '
|| p_variable_rent_lines_rec_type.line_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LINE_END_DATE : '
|| p_variable_rent_lines_rec_type.line_end_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : PROCESSED_FLAG : '
|| p_variable_rent_lines_rec_type.processed_flag
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LAST_UPDATE_DATE : '
|| p_variable_rent_lines_rec_type.last_update_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LAST_UPDATED_BY : '
|| p_variable_rent_lines_rec_type.last_updated_by
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LAST_UPDATE_LOGIN : '
|| p_variable_rent_lines_rec_type.last_update_login
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : ATTRIBUTE_CATEGORY : '
|| p_variable_rent_lines_rec_type.attribute_category
, 3
);
('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'
, 3
);
pn_var_line_defaults_pkg.update_row
(x_line_default_id => p_variable_rent_lines_rec_type.line_default_id
, x_line_num => p_variable_rent_lines_rec_type.line_num
, x_var_rent_id => p_variable_rent_lines_rec_type.var_rent_id
, x_sales_type_code => p_variable_rent_lines_rec_type.sales_channel_code
, x_item_category_code => p_variable_rent_lines_rec_type.item_category_code
, x_line_template_id => l_not_used
--p_variable_rent_lines_rec_type.LINE_TEMPLATE_ID
, x_agreement_template_id => p_variable_rent_lines_rec_type.agreement_template_id
, x_line_start_date => p_variable_rent_lines_rec_type.line_start_date
, x_line_end_date => p_variable_rent_lines_rec_type.line_end_date
, x_processed_flag => p_variable_rent_lines_rec_type.processed_flag
, x_last_update_date => g_sysdate
--p_variable_rent_lines_rec_type.last_update_date
, x_last_updated_by => g_user_id
--p_variable_rent_lines_rec_type.last_updated_by
, x_last_update_login => g_user_id
--p_variable_rent_lines_rec_type.last_update_login
, x_attribute_category => p_variable_rent_lines_rec_type.attribute_category
, x_attribute1 => p_variable_rent_lines_rec_type.attribute1
, x_attribute2 => p_variable_rent_lines_rec_type.attribute2
, x_attribute3 => p_variable_rent_lines_rec_type.attribute3
, x_attribute4 => p_variable_rent_lines_rec_type.attribute4
, x_attribute5 => p_variable_rent_lines_rec_type.attribute5
, x_attribute6 => p_variable_rent_lines_rec_type.attribute6
, x_attribute7 => p_variable_rent_lines_rec_type.attribute7
, x_attribute8 => p_variable_rent_lines_rec_type.attribute8
, x_attribute9 => p_variable_rent_lines_rec_type.attribute9
, x_attribute10 => p_variable_rent_lines_rec_type.attribute10
, x_attribute11 => p_variable_rent_lines_rec_type.attribute11
, x_attribute12 => p_variable_rent_lines_rec_type.attribute12
, x_attribute13 => p_variable_rent_lines_rec_type.attribute13
, x_attribute14 => p_variable_rent_lines_rec_type.attribute14
, x_attribute15 => p_variable_rent_lines_rec_type.attribute15
);
('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of calling PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'
, 3
);
( 'PN_VAREN_PVT: Update_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'
|| SQLERRM
, 3
);
END update_variable_rent_lines;
IF p_allow_abat_tbl_type (b).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_allow_abat_tbl_type (b).last_update_date := NULL;
IF p_allow_abat_tbl_type (b).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_allow_abat_tbl_type (b).last_updated_by := NULL;
IF p_allow_abat_tbl_type (b).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_allow_abat_tbl_type (b).last_update_login := NULL;
SELECT COUNT (1)
, var_rent_id
, commencement_date
, termination_date
INTO l_variable_rent_exists
, l_var_rent_id
, l_var_commencement_date
, l_var_termination_date
FROM pn_var_rents_all
WHERE ( rent_num = p_allow_abat_tbl_type (b).var_rent_num
OR var_rent_id = p_allow_abat_tbl_type (b).var_rent_id
)
AND org_id = g_org_id --l_org_id
GROUP BY var_rent_id
, commencement_date
, termination_date;
fnd_message.set_token ('ERR_MSG', 'Var Rent : Val_Ins_Allow_Abat: Variable Rent Number or Variable Rent Id doesnot exists While selecting the count');
SELECT 'x'
INTO l_exist
FROM dual
WHERE EXISTS (SELECT inv_end_date
FROM pn_var_grp_dates_all
WHERE var_rent_id = l_var_rent_id
AND inv_end_date = p_allow_abat_tbl_type (b).abat_end_date
);
( 'PN_VAR_RENT_PVT: Val_Ins_Allow_Abat: Before Calling insert_Allowance and Abatements procedure : '
|| l_allow_abat_val
, 3
);*/
insert_allow_abat (p_allow_abat_rec_type => p_allow_abat_tbl_type (b)
, x_return_status => x_return_status
);
fnd_message.set_token ('ERR_MSG', 'Var Rent:INSERT_ALLOW_ABAT:Exception');
fnd_message.set_token ('ERR_MSG', 'Var Rent : INSERT_ALLOW_ABAT:Unexpected Exception');
IF p_constraints_tbl_type (c).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_constraints_tbl_type (c).last_update_date := NULL;
IF p_constraints_tbl_type (c).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_constraints_tbl_type (c).last_updated_by := NULL;
IF p_constraints_tbl_type (c).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_constraints_tbl_type (c).last_update_login := NULL;
SELECT COUNT (1)
, var_rent_id
INTO l_variable_rent_exists
, l_var_rent_id
FROM pn_var_rents_all
WHERE ( rent_num = p_constraints_tbl_type (c).var_rent_num
OR var_rent_id = p_constraints_tbl_type (c).var_rent_id
)
AND org_id = g_org_id --l_org_id
GROUP BY var_rent_id;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Val_Ins_Constraints: Calling Insert Constraint Procedure'
, 3
);
( 'PN_VAREN_PVT: Val_Ins_Constraints: Before Calling insert_constraints procedure : '
|| l_const_val
, 3
);
( 'PN_VAREN_PVT: Val_Ins_Constraints: start of insert_constraints procedure and p_constraints_tbl_type (c).constr_type_code : '
|| p_constraints_tbl_type (c).constr_type_code
, 3
);*/
insert_constraints (p_constraints_rec_type => p_constraints_tbl_type (c)
, x_return_status => x_return_status
);
fnd_message.set_token ('ERR_MSG', 'VAR RENT Contraints : INSERT_CONSTRAINTS Error');
fnd_message.set_token ('ERR_MSG', 'VAR RENT Contraints : INSERT_CONSTRAINTS Unexpected Error');
SELECT bkhd_default_id
, bkhd_start_date
, bkhd_end_date
, natural_break_rate
, break_type
, breakpoint_type
INTO l_bkhd_default_id
, l_bkhd_start_date
, l_bkhd_end_date
, l_natural_break_rate
, l_break_type
, l_breakpoint_type
FROM pn_var_bkhd_defaults_all
WHERE var_rent_id = p_breakpoint_details_rec_type.var_rent_id
AND bkhd_default_id = p_breakpoint_details_rec_type.bkhd_default_id
AND org_id = g_org_id; --l_org_id;
SELECT period_id
INTO l_period_id
FROM pn_var_periods_all
WHERE var_rent_id = p_breakpoint_details_rec_type.var_rent_id
AND start_date <= p_breakpoint_details_rec_type.bkdt_start_date
AND end_date >= p_breakpoint_details_rec_type.bkdt_start_date;
('PN_VAREN_PVT: Validate_Breakpoint_Details: Start of calling Breakpoint Details Insert Procedure '
, 3
);
insert_breakpoint_details (p_breakpoint_details_rec_type => p_breakpoint_details_rec_type
, x_return_status => x_return_status
);
('PN_VAREN_PVT: Validate_Breakpoint_Details: End of calling Breakpoint Details Insert Procedure Return Status'||x_return_status
, 3
);
fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Break Point Details not inserted properly');
fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Break Point Details not inserted properly:Unexpected Exception');
insert_breakpoint_details (p_breakpoint_details_rec_type => p_breakpoint_details_rec_type
, x_return_status => x_return_status
);
('PN_VAREN_PVT: Validate_Breakpoint_Details Natural: End of calling Breakpoint Details Insert Procedure Return Status'||x_return_status
, 3
);
fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Natural::Break Point Details not inserted properly');
fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details:Natural:: Break Point Details not inserted properly:Unexpected Exception');
SELECT commencement_date
, termination_date
INTO l_bkhd_comm_date
, l_bkhd_term_date
FROM pn_var_rents_all
WHERE var_rent_id = p_breakpoint_header_rec_type.var_rent_id
AND org_id = g_org_id;
('PN_VAREN_PVT: Validate_Breakpoint_Header: Calling Breakpoint Headers Insert Procedure '
, 3
);
insert_breakpoint_headers (p_breakpoint_header_rec_type => p_breakpoint_header_rec_type
, x_return_status => l_return_status
);
pn_varen_util.pvt_debug('PN_VAREN_PVT: Validate_Breakpoint_Header: End of Calling Breakpoint Headers Insert Procedure :'|| l_return_status, 3);
fnd_message.set_token ('ERR_MSG', 'INSERT_BREAKPOINT_HEADERS:Error');
fnd_message.set_token ('ERR_MSG', 'INSERT_BREAKPOINT_HEADERS:Unexpected Error');
IF p_variable_rent_lines_tbl (i).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_variable_rent_lines_tbl (i).last_update_date := NULL;
IF p_variable_rent_lines_tbl (i).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_variable_rent_lines_tbl (i).last_updated_by := NULL;
IF p_variable_rent_lines_tbl (i).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_variable_rent_lines_tbl (i).last_update_login := NULL;
SELECT COUNT (1)
,var_rent_id
INTO l_variable_rent_exists
,l_var_rent_id
FROM pn_var_rents_all
WHERE (rent_num = p_variable_rent_lines_tbl (i).var_rent_num
OR var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
)
AND org_id = g_org_id
GROUP BY var_rent_id;
insert_variable_rent_lines (p_variable_rent_lines_rec_type => p_variable_rent_lines_tbl(i)
, x_return_status => l_return_status
);
pn_varen_util.pvt_debug('PN_VAREN_PVT: Var_Rent_Line_Bkhd: End of Calling Variable Rent Lines Insert Procedure :'||l_return_status,3);
fnd_message.set_token('ERR_MSG', 'Error while inserting the VRA lines.');
fnd_message.set_token('ERR_MSG', 'Unexpected Error while inserting the VRA lines.');
IF p_breakpoint_header_tbl (j).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_breakpoint_header_tbl (j).last_update_date := NULL;
IF p_breakpoint_header_tbl (j).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_breakpoint_header_tbl (j).last_updated_by := NULL;
IF p_breakpoint_header_tbl (j).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_breakpoint_header_tbl (j).last_update_login := NULL;
SELECT COUNT(1)
INTO l_date_range_count
FROM pn_var_bkhd_defaults_all
WHERE var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
AND line_default_id = p_variable_rent_lines_tbl (i).line_default_id
AND (bkhd_start_date <= p_breakpoint_header_tbl (j).bkhd_end_date AND bkhd_end_date >= p_breakpoint_header_tbl (j).bkhd_start_date);
IF p_breakpoint_details_tbl (k).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_breakpoint_details_tbl (k).last_update_date :=
NULL;
IF p_breakpoint_details_tbl (k).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_breakpoint_details_tbl (k).last_updated_by :=
NULL;
IF p_breakpoint_details_tbl (k).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_breakpoint_details_tbl (k).last_update_login :=
NULL;
SELECT COUNT(1)
INTO l_date_range_bkdt_count
FROM pn_var_bkdt_defaults_all
WHERE var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
AND bkhd_default_id = p_breakpoint_header_tbl (j).bkhd_default_id
AND (bkdt_start_date <= p_breakpoint_details_tbl (k).bkdt_end_date AND bkdt_end_date >= p_breakpoint_details_tbl (k).bkdt_start_date);
UPDATE pn_var_line_defaults_all
SET line_start_date = (SELECT MIN(bkhd_start_date)
FROM pn_var_bkhd_defaults_all
WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
AND org_id = g_org_id
)
,line_end_date = (SELECT MAX(bkhd_end_date)
FROM pn_var_bkhd_defaults_all
WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
AND org_id = g_org_id
)
WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
AND org_id = g_org_id;
( 'PN_VAREN_PVT: Var_Rent_Line_Bkhd: Error encountered, While calling Variable Rent Lines Insert Procedure and Return status is :'
|| l_return_status
, 3
);
IF p_var_rent_rec.last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_var_rent_rec.last_update_date := NULL;
IF p_var_rent_rec.last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_rec.last_updated_by := NULL;
IF p_var_rent_rec.last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_rec.last_update_login := NULL;
SELECT auto_var_rent_num_gen
INTO l_auto_var_rent_num
FROM pn_system_setup_options
WHERE org_id = g_org_id;
( 'PN_VAREN_PVT: Upd_Val_Varent: Start of Update validate variable rent details procedure'
|| SQLERRM
, 3
);
( 'PN_VAREN_PVT: Upd_Val_Varent: Exception Result of Update validate variable rent details procedure'
|| SQLERRM
, 3
);
IF p_var_rent_rec.last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_var_rent_rec.last_update_date := NULL;
IF p_var_rent_rec.last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_rec.last_updated_by := NULL;
IF p_var_rent_rec.last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_rec.last_update_login := NULL;
END IF; -- End of attributes valitions in update var rent dates*/
( 'PN_VAREN_PVT: Upd_Validate_Rent_Dates: Exception Result of Update Validate Rent dates PACKAGE'
|| SQLERRM
, 3
);
PROCEDURE call_varen_insert_row (
p_var_rent_id IN OUT NOCOPY NUMBER
, p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_accrual VARCHAR2 (1) DEFAULT 'Y';
('PN_VAREN_PVT: Call_Varen_Insert_Row: Calling Variable Rent Insert Procedure pn_var_rents_pkg.insert_row'
, 3
);
pn_var_rents_pkg.insert_row (x_rowid => g_rowid
, x_var_rent_id => p_var_rent_id --l_var_rent_id
, x_rent_num => p_var_rent_rec.rent_num
, x_lease_id => p_var_rent_rec.lease_id
, x_location_id => p_var_rent_rec.location_id
, x_proration_days => p_var_rent_rec.proration_days
, x_purpose_code => p_var_rent_rec.purpose_code
, x_type_code => p_var_rent_rec.type_code
, x_commencement_date => p_var_rent_rec.commencement_date
, x_termination_date => p_var_rent_rec.termination_date
, x_abstracted_by_user => p_var_rent_rec.abstracted_by_user_id
,x_cumulative_vol => p_var_rent_rec.cumulative_vol_code
, x_accrual => l_accrual
, x_uom_code => l_uom_code
, x_invoice_on => p_var_rent_rec.invoice_on_code
, x_negative_rent => p_var_rent_rec.negative_rent_code
, x_term_template_id => p_var_rent_rec.term_template_id
, x_attribute_category => p_var_rent_rec.attribute_category
, x_attribute1 => p_var_rent_rec.attribute1
, x_attribute2 => p_var_rent_rec.attribute2
, x_attribute3 => p_var_rent_rec.attribute3
, x_attribute4 => p_var_rent_rec.attribute4
, x_attribute5 => p_var_rent_rec.attribute5
, x_attribute6 => p_var_rent_rec.attribute6
, x_attribute7 => p_var_rent_rec.attribute7
, x_attribute8 => p_var_rent_rec.attribute8
, x_attribute9 => p_var_rent_rec.attribute9
, x_attribute10 => p_var_rent_rec.attribute10
, x_attribute11 => p_var_rent_rec.attribute11
, x_attribute12 => p_var_rent_rec.attribute12
, x_attribute13 => p_var_rent_rec.attribute13
, x_attribute14 => p_var_rent_rec.attribute14
, x_attribute15 => p_var_rent_rec.attribute15
, x_creation_date => NVL (p_var_rent_rec.creation_date,g_sysdate)
, x_created_by => NVL (p_var_rent_rec.created_by,g_user_id)
, x_last_update_date => NVL (p_var_rent_rec.last_update_date,g_sysdate)
, x_last_updated_by => NVL (p_var_rent_rec.last_updated_by, g_user_id)
, x_last_update_login => NVL (p_var_rent_rec.last_update_login,g_user_id)
, x_currency_code => p_var_rent_rec.currency_code
, x_org_id => g_org_id
, x_agreement_template_id => p_var_rent_rec.agreement_template_id
, x_proration_rule => p_var_rent_rec.proration_rule_code
, x_chg_cal_var_rent_id => NULL
--p_var_rent_rec.chg_cal_var_rent_id, Initial value
);
('PN_VAREN_PVT: Call_Varen_Insert_Row: End OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: p_var_rent_id : '
|| p_var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: Before - Value of p_var_rent_id is '
|| p_var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: Before - Value of g_var_rent_id is '
|| g_var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: g_var_rent_id : '
|| g_var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: After - Value of p_var_rent_id is '
|| p_var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: After - Value of g_var_rent_id is '
|| g_var_rent_id
, 3
);
( 'PN_VAREN_PVT: Call_Varen_Insert_Row: Exception Result of PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
|| SQLERRM
, 3
);
END call_varen_insert_row;
PROCEDURE update_varent (
--p_var_rent_id IN OUT NOCOPY NUMBER
p_upd_var_rent_rec_type IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_accrual VARCHAR2 (1) DEFAULT 'Y';
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: Start of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.VAR_RENT_ID :'
|| p_upd_var_rent_rec_type.var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.RENT_NUM :'
|| p_upd_var_rent_rec_type.rent_num
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.LEASE_ID :'
|| p_upd_var_rent_rec_type.lease_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.LOCATION_ID :'
|| p_upd_var_rent_rec_type.location_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.PRORATION_DAYS :'
|| p_upd_var_rent_rec_type.proration_days
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.PURPOSE_CODE :'
|| p_upd_var_rent_rec_type.purpose_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.TYPE_CODE :'
|| p_upd_var_rent_rec_type.type_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.COMMENCEMENT_DATE :'
|| p_upd_var_rent_rec_type.commencement_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.TERMINATION_DATE :'
|| p_upd_var_rent_rec_type.termination_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.ABSTRACTED_BY_USER_ID :'
|| p_upd_var_rent_rec_type.abstracted_by_user_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.CUMULATIVE_VOL_CODE :'
|| p_upd_var_rent_rec_type.cumulative_vol_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.INVOICE_ON_CODE :'
|| p_upd_var_rent_rec_type.invoice_on_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.NEGATIVE_RENT_CODE :'
|| p_upd_var_rent_rec_type.negative_rent_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.TERM_TEMPLATE_ID :'
|| p_upd_var_rent_rec_type.term_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.CURRENCY_CODE :'
|| p_upd_var_rent_rec_type.currency_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.AGREEMENT_TEMPLATE_ID :'
|| p_upd_var_rent_rec_type.agreement_template_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.PRORATION_RULE_CODE :'
|| p_upd_var_rent_rec_type.proration_rule_code
, 3
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
, 3
);
pn_var_rents_pkg.update_row (x_var_rent_id => p_upd_var_rent_rec_type.var_rent_id
, x_rent_num => p_upd_var_rent_rec_type.rent_num
, x_lease_id => p_upd_var_rent_rec_type.lease_id
, x_location_id => p_upd_var_rent_rec_type.location_id
, x_proration_days => p_upd_var_rent_rec_type.proration_days
, x_purpose_code => p_upd_var_rent_rec_type.purpose_code
, x_type_code => p_upd_var_rent_rec_type.type_code
, x_commencement_date => p_upd_var_rent_rec_type.commencement_date
, x_termination_date => p_upd_var_rent_rec_type.termination_date
, x_abstracted_by_user => p_upd_var_rent_rec_type.abstracted_by_user_id
, x_cumulative_vol => p_upd_var_rent_rec_type.cumulative_vol_code
, x_accrual => l_accrual
-- IMP -- check p_upd_var_rent_rec_type.ACCRUAL_CODE
, x_uom_code => l_uom_code
-- IMP -- check p_upd_var_rent_rec_type.UOM_CODE
--X_ROUNDING => p_upd_var_rent_rec_type.X_ROUNDING
, x_invoice_on => p_upd_var_rent_rec_type.invoice_on_code
, x_negative_rent => p_upd_var_rent_rec_type.negative_rent_code
, x_term_template_id => p_upd_var_rent_rec_type.term_template_id
-- codev X_ABATEMENT_AMOUNT => p_upd_var_rent_rec_type.X_ABATEMENT_AMOUNT
, x_attribute_category => p_upd_var_rent_rec_type.attribute_category
, x_attribute1 => p_upd_var_rent_rec_type.attribute1
, x_attribute2 => p_upd_var_rent_rec_type.attribute2
, x_attribute3 => p_upd_var_rent_rec_type.attribute3
, x_attribute4 => p_upd_var_rent_rec_type.attribute4
, x_attribute5 => p_upd_var_rent_rec_type.attribute5
, x_attribute6 => p_upd_var_rent_rec_type.attribute6
, x_attribute7 => p_upd_var_rent_rec_type.attribute7
, x_attribute8 => p_upd_var_rent_rec_type.attribute8
, x_attribute9 => p_upd_var_rent_rec_type.attribute9
, x_attribute10 => p_upd_var_rent_rec_type.attribute10
, x_attribute11 => p_upd_var_rent_rec_type.attribute11
, x_attribute12 => p_upd_var_rent_rec_type.attribute12
, x_attribute13 => p_upd_var_rent_rec_type.attribute13
, x_attribute14 => p_upd_var_rent_rec_type.attribute14
, x_attribute15 => p_upd_var_rent_rec_type.attribute15
, x_last_update_date => g_sysdate --p_upd_var_rent_rec_type.last_update_date
, x_last_updated_by => g_user_id --p_upd_var_rent_rec_type.last_updated_by
, x_last_update_login => g_user_id
--p_upd_var_rent_rec_type.last_update_login
, x_currency_code => p_upd_var_rent_rec_type.currency_code
, x_agreement_template_id => p_upd_var_rent_rec_type.agreement_template_id
, x_proration_rule => p_upd_var_rent_rec_type.proration_rule_code
, x_chg_cal_var_rent_id => l_null
--p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End OF CALLING PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
, 3
);
( 'PN_VAREN_PVT: Update_Varent: Exception Result of PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
|| SQLERRM
, 3
);
END update_varent;
PROCEDURE call_varen_dates_insert_row (
p_var_rent_id IN NUMBER
, p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_period_freq_code VARCHAR2 (2) DEFAULT 'YR';
('PN_VAREN_PVT: call_varen_dates_insert_row: Calling PN_VAR_RENT_DATES_PKG.INSERT_ROW Package'
, 3
);
('PN_VAREN_PVT: call_varen_dates_insert_row: START OF CALLING PN_VAR_RENT_DATES_PKG.INSERT_ROW PACKAGE'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: call_varen_dates_insert_row: Var Rent Date ID: '
|| l_var_rent_date_id
, 3
);
pn_var_rent_dates_pkg.insert_row (x_rowid => g_rowid
, x_var_rent_date_id => l_var_rent_date_id
, x_var_rent_id => l_var_rent_id
, x_gl_period_set_name => p_var_rent_rec.gl_period_set_name
, x_period_freq_code => l_period_freq_code -- 'YR'
, x_reptg_freq_code => p_var_rent_rec.reptg_freq_code
, x_reptg_day_of_month => p_var_rent_rec.reptg_day_of_month
, x_reptg_days_after => p_var_rent_rec.reptg_days_after
, x_invg_freq_code => p_var_rent_rec.invg_freq_code
, x_invg_day_of_month => p_var_rent_rec.invg_day_of_month
, x_invg_days_after => p_var_rent_rec.invg_days_after
, x_invg_spread_code => l_invg_spread_code -- 'OT'
, x_invg_term => NULL
, x_audit_freq_code => l_audit_freq_code --'MON'
, x_audit_day_of_month => NULL
, x_audit_days_after => NULL
, x_recon_freq_code => l_recon_freq_code -- 'YR'
, x_recon_day_of_month => NULL
, x_recon_days_after => NULL
, x_attribute_category => p_var_rent_rec.dates_attribute_category
, x_attribute1 => p_var_rent_rec.dates_attribute1
, x_attribute2 => p_var_rent_rec.dates_attribute2
, x_attribute3 => p_var_rent_rec.dates_attribute3
, x_attribute4 => p_var_rent_rec.dates_attribute4
, x_attribute5 => p_var_rent_rec.dates_attribute5
, x_attribute6 => p_var_rent_rec.dates_attribute6
, x_attribute7 => p_var_rent_rec.dates_attribute7
, x_attribute8 => p_var_rent_rec.dates_attribute8
, x_attribute9 => p_var_rent_rec.dates_attribute9
, x_attribute10 => p_var_rent_rec.dates_attribute10
, x_attribute11 => p_var_rent_rec.dates_attribute11
, x_attribute12 => p_var_rent_rec.dates_attribute12
, x_attribute13 => p_var_rent_rec.dates_attribute13
, x_attribute14 => p_var_rent_rec.dates_attribute14
, x_attribute15 => p_var_rent_rec.dates_attribute15
, x_creation_date => NVL (p_var_rent_rec.creation_date
, g_sysdate
)
, x_created_by => NVL (p_var_rent_rec.created_by
, g_user_id
)
, x_last_update_date => NVL (p_var_rent_rec.last_update_date
, g_sysdate
)
, x_last_updated_by => NVL (p_var_rent_rec.last_updated_by
, g_user_id
)
, x_last_update_login => NVL (p_var_rent_rec.last_update_login
, g_user_id
)
, x_org_id => g_org_id
, x_use_gl_calendar => NVL (p_var_rent_rec.use_gl_calendar
, 'N'
)
, x_period_type => p_var_rent_rec.period_type
, x_year_start_date => NVL (p_var_rent_rec.year_start_date
, l_var_year_start_date
)
, x_comments => p_var_rent_rec.comments
, x_vrg_reptg_freq_code => p_var_rent_rec.vrg_reptg_freq_code
);
('PN_VAREN_PVT: call_varen_dates_insert_row: End OF CALLING PN_VAR_RENT_DATES_PKG.INSERT_ROW PACKAGE'||l_var_rent_date_id
, 3
);
('PN_VAREN_PVT: call_varen_dates_insert_row: Exception Result of PN_VAR_RENT_DATES_PKG.INSERT_ROW PACKAGE'
, 3
);
END call_varen_dates_insert_row;
PROCEDURE update_varen_dates (
--p_var_rent_id IN NUMBER
--,
p_upd_var_rent_rec_type IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_period_freq_code VARCHAR2 (2) DEFAULT 'YR';
('PN_VAREN_PVT: Call_Varen_Insert_Row: Start of calling PN_VAR_RENT_DATES_PKG.UPDATE_ROW PACKAGE'
, 3
);
('PN_VAREN_PVT: Call_Varen_Insert_Row: Start of Input parameters PN_VAR_RENT_DATES_PKG.UPDATE_ROW PACKAGE'
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.VAR_RENT_DATE_ID :'
|| p_upd_var_rent_rec_type.var_rent_date_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.VAR_RENT_ID :'
|| p_upd_var_rent_rec_type.var_rent_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.GL_PERIOD_SET_NAME :'
|| p_upd_var_rent_rec_type.gl_period_set_name
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.REPTG_FREQ_CODE :'
|| p_upd_var_rent_rec_type.reptg_freq_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.REPTG_DAY_OF_MONTH :'
|| p_upd_var_rent_rec_type.reptg_day_of_month
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.REPTG_DAYS_AFTER :'
|| p_upd_var_rent_rec_type.reptg_days_after
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.INVG_FREQ_CODE :'
|| p_upd_var_rent_rec_type.invg_freq_code
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.INVG_DAY_OF_MONTH :'
|| p_upd_var_rent_rec_type.invg_day_of_month
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.INVG_DAYS_AFTER :'
|| p_upd_var_rent_rec_type.invg_days_after
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.AUDIT_DAY_OF_MONTH :'
|| p_upd_var_rent_rec_type.audit_day_of_month
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.AUDIT_DAYS_AFTER :'
|| p_upd_var_rent_rec_type.audit_days_after
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.RECON_DAY_OF_MONTH :'
|| p_upd_var_rent_rec_type.recon_day_of_month
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.RECON_DAYS_AFTER :'
|| p_upd_var_rent_rec_type.recon_days_after
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.ATTRIBUTE_CATEGORY :'
|| p_upd_var_rent_rec_type.attribute_category
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.USE_GL_CALENDAR :'
|| p_upd_var_rent_rec_type.use_gl_calendar
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.PERIOD_TYPE :'
|| p_upd_var_rent_rec_type.period_type
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.YEAR_START_DATE :'
|| p_upd_var_rent_rec_type.year_start_date
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.COMMENTS :'
|| p_upd_var_rent_rec_type.comments
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varen_Dates : p_upd_var_rent_rec_type.VRG_REPTG_FREQ_CODE :'
|| p_upd_var_rent_rec_type.vrg_reptg_freq_code
, 3
);
('PN_VAREN_PVT: Call_Varen_Insert_Row: End of Input parameters PN_VAR_RENT_DATES_PKG.UPDATE_ROW PACKAGE'
, 3
);
pn_var_rent_dates_pkg.update_row (x_var_rent_date_id => p_upd_var_rent_rec_type.var_rent_date_id
, x_var_rent_id => p_upd_var_rent_rec_type.var_rent_id
, x_gl_period_set_name => p_upd_var_rent_rec_type.gl_period_set_name
, x_period_freq_code => l_period_freq_code
--p_upd_var_rent_rec_type.PERIOD_FREQ_CODE
, x_reptg_freq_code => p_upd_var_rent_rec_type.reptg_freq_code
, x_reptg_day_of_month => p_upd_var_rent_rec_type.reptg_day_of_month
, x_reptg_days_after => p_upd_var_rent_rec_type.reptg_days_after
, x_invg_freq_code => p_upd_var_rent_rec_type.invg_freq_code
, x_invg_day_of_month => p_upd_var_rent_rec_type.invg_day_of_month
, x_invg_days_after => p_upd_var_rent_rec_type.invg_days_after
, x_invg_spread_code => l_invg_spread_code
--p_upd_var_rent_rec_type.INVG_SPREAD_CODE
, x_invg_term => l_invg_term
-- IMP -- verify the pld --p_upd_var_rent_rec_type.INVG_TERM
, x_audit_freq_code => l_audit_freq_code
--p_upd_var_rent_rec_type.AUDIT_FREQ_CODE
, x_audit_day_of_month => p_upd_var_rent_rec_type.audit_day_of_month
, x_audit_days_after => p_upd_var_rent_rec_type.audit_days_after
, x_recon_freq_code => l_null
-- p_upd_var_rent_rec_type.RECON_FREQ_CODE
, x_recon_day_of_month => p_upd_var_rent_rec_type.recon_day_of_month
, x_recon_days_after => p_upd_var_rent_rec_type.recon_days_after
, x_attribute_category => p_upd_var_rent_rec_type.attribute_category
, x_attribute1 => p_upd_var_rent_rec_type.dates_attribute1
, x_attribute2 => p_upd_var_rent_rec_type.dates_attribute2
, x_attribute3 => p_upd_var_rent_rec_type.dates_attribute3
, x_attribute4 => p_upd_var_rent_rec_type.dates_attribute4
, x_attribute5 => p_upd_var_rent_rec_type.dates_attribute5
, x_attribute6 => p_upd_var_rent_rec_type.dates_attribute6
, x_attribute7 => p_upd_var_rent_rec_type.dates_attribute7
, x_attribute8 => p_upd_var_rent_rec_type.dates_attribute8
, x_attribute9 => p_upd_var_rent_rec_type.dates_attribute9
, x_attribute10 => p_upd_var_rent_rec_type.dates_attribute10
, x_attribute11 => p_upd_var_rent_rec_type.dates_attribute11
, x_attribute12 => p_upd_var_rent_rec_type.dates_attribute12
, x_attribute13 => p_upd_var_rent_rec_type.dates_attribute13
, x_attribute14 => p_upd_var_rent_rec_type.dates_attribute14
, x_attribute15 => p_upd_var_rent_rec_type.dates_attribute15
, x_last_update_date => g_sysdate
--p_upd_var_rent_rec_type.last_update_date
, x_last_updated_by => g_user_id
--p_upd_var_rent_rec_type.last_updated_by
, x_last_update_login => g_user_id
--p_upd_var_rent_rec_type.last_update_login
, x_use_gl_calendar => p_upd_var_rent_rec_type.use_gl_calendar
, x_period_type => p_upd_var_rent_rec_type.period_type
, x_year_start_date => p_upd_var_rent_rec_type.year_start_date
, x_comments => p_upd_var_rent_rec_type.comments
, x_vrg_reptg_freq_code => p_upd_var_rent_rec_type.vrg_reptg_freq_code
);
('PN_VAREN_PVT: Update_Varen_Dates: Exception Result of PN_VAR_RENT_DATES_PKG.UPDATE_ROW PACKAGE'
, 3
);
END update_varen_dates;
l_lastupdatedate DATE := NULL;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Before PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
, 3
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Start of CALL_VAREN_INSERT_ROW Procedure'
, 3
);
call_varen_insert_row (p_var_rent_id => l_var_rent_id
, p_var_rent_rec => p_var_rent_rec
, x_return_status => x_return_status
);
fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : VAR RENT INSERTION Error');
fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : VAR RENT INSERTION Unexpected Error');
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Create_Var_Rent: End of CALL_VAREN_INSERT_ROW Procedure status : '
|| x_return_status
, 3
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Before PN_VAR_RENT_DATES_PKG.INSERT_ROW PACKAGE'
, 3
);
('PN_VAREN_PVT: Create_Var_Rent: Start of calling CALL_VAREN_DATES_INSERT_ROW Procedure '
, 3
);
call_varen_dates_insert_row (p_var_rent_id => l_var_rent_id
, p_var_rent_rec => p_var_rent_rec
, x_return_status => x_return_status
);
( 'PN_VAREN_PVT: Create_Var_Rent: End of calling CALL_VAREN_DATES_INSERT_ROW Procedure status : '
|| x_return_status
, 3
);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Call_Varen_Dates_Insert_Row Failed'
, 3
);
SELECT COUNT (*)
FROM pn_var_rents_all
WHERE ( var_rent_id = p_var_rent_id
OR UPPER (rent_num) = UPPER (p_var_rent_num))
AND org_id = p_org_id;
SELECT COUNT (*)
FROM pn_var_constr_defaults_all
WHERE var_rent_id = p_var_rent_id;
SELECT COUNT (*)
FROM pn_var_bkhd_defaults_all
WHERE line_default_id IN (SELECT line_default_id
FROM pn_var_line_defaults_all
WHERE var_rent_id = p_var_rent_id);
SELECT COUNT (*)
FROM pn_var_vol_hist_all
WHERE period_id IN (SELECT period_id
FROM pn_var_periods_all
WHERE var_rent_id = l_chg_cal_var_rent_id);
SELECT COUNT (a.grp_date_id)
FROM pn_var_grp_dates_all a
, pn_var_grp_dates_all b
WHERE a.var_rent_id = l_chg_cal_var_rent_id
-- This sould be changed_var_rent_id
AND b.var_rent_id = p_var_rent_id
AND a.grp_start_date = b.grp_start_date
AND a.grp_end_date = b.grp_end_date;
SELECT COUNT (*)
FROM pn_var_rent_dates_all
WHERE var_rent_id = p_var_rent_id;
SELECT pvrd.use_gl_calendar
, pvrd.year_start_date
, pvra.var_rent_id
, pvra.cumulative_vol
, pvra.chg_cal_var_rent_id
FROM pn_var_rents_all pvra
, pn_var_rent_dates_all pvrd
WHERE pvra.var_rent_id = pvrd.var_rent_id
AND pvra.var_rent_id = p_var_rent_id;
SELECT COUNT (*)
FROM pn_var_rents_all
WHERE ( var_rent_id = p_var_rent_id
OR UPPER (rent_num) = UPPER (p_var_rent_num))
AND org_id = p_org_id;
SELECT COUNT (*)
FROM pn_var_rents_all
WHERE ( UPPER (rent_num) = UPPER (p_var_rent_num)
)
AND org_id = p_org_id;
SELECT COUNT (*)
FROM pn_var_rent_dates_all
WHERE var_rent_id = p_var_rent_id;
SELECT pvra.var_rent_id
, pvra.chg_cal_var_rent_id
FROM pn_var_rents_all pvra
, pn_var_rent_dates_all pvrd
WHERE pvra.var_rent_id = pvrd.var_rent_id
AND pvra.var_rent_id = p_var_rent_id;
DELETE FROM pn_var_vol_hist_all
WHERE period_id IN (SELECT period_id
FROM pn_var_periods_all
WHERE var_rent_id = l_varentid);
DELETE FROM pn_var_constraints_all
WHERE period_id IN (SELECT period_id
FROM pn_var_periods_all
WHERE var_rent_id = l_varentid);
DELETE FROM pn_var_bkpts_det_all
WHERE var_rent_id = l_varentid;
DELETE pn_var_bkpts_head_all
WHERE var_rent_id = l_varentid;
DELETE pn_var_lines_all
WHERE var_rent_id = l_varentid;
DELETE FROM pn_var_abatements_all abat
WHERE abat.var_rent_id = l_varentid;
pn_var_rent_pkg.delete_var_rent_periods (l_varentid);
pn_var_trx_pkg.delete_transactions (p_var_rent_id => l_varentid
, p_period_id => NULL
, p_line_item_id => NULL
);
pn_var_defaults_pkg.delete_default_lines (l_varentid);
DELETE FROM pn_var_abat_defaults_all
WHERE var_rent_id = l_varentid;
DELETE FROM pn_var_bkdt_defaults_all
WHERE var_rent_id = l_varentid;
DELETE pn_var_bkhd_defaults_all
WHERE var_rent_id = l_varentid;
DELETE pn_var_line_defaults_all
WHERE var_rent_id = l_varentid;
DELETE pn_var_constr_defaults_all
WHERE var_rent_id = l_varentid;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Undo_Periods: All the periods were deleted : '
, 3
);
( 'PN_VAREN_PVT: Create_Bkpt_Const_Allow_Abat: Return_Status Before calling variable rent lines insert procedure : '
|| l_return_status
, 3
);
PROCEDURE update_var_rent (
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
, p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
, p_validate_flag IN VARCHAR2 DEFAULT 'Y'
, p_upd_var_rent_rec IN OUT NOCOPY upd_var_rent_rec_type
, p_var_rent_lines_tbl IN OUT NOCOPY variable_rent_lines_tbl_type
, p_breakpoint_header_tbl IN OUT NOCOPY breakpoint_header_tbl_type
, p_breakpoint_details_tbl IN OUT NOCOPY breakpoint_details_tbl_type
, p_constraints_tbl IN OUT NOCOPY constraints_tbl_type
, p_allow_abat_tbl IN OUT NOCOPY allow_abat_tbl_type
, p_undo_periods IN VARCHAR2 DEFAULT 'N'
, p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'
, p_undo_constraints IN VARCHAR2 DEFAULT 'N'
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_VAR_RENT';
SELECT var_rent_id
, rent_num
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, lease_id
, location_id
, proration_days
, purpose_code
, type_code
, commencement_date
, termination_date
, abstracted_by_user
, cumulative_vol
--, accrual
, uom_code
--, rounding
, invoice_on
, negative_rent
, term_template_id
--, abatement_amount
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
--, org_id
, currency_code
, proration_rule
, agreement_template_id
, chg_cal_var_rent_id
--, order_of_appl_code
--, excess_abat_code
FROM pn_var_rents_all
WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
SELECT var_rent_date_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, var_rent_id
, gl_period_set_name
, period_freq_code
, reptg_freq_code
, reptg_day_of_month
, reptg_days_after
, invg_freq_code
, invg_day_of_month
, invg_days_after
, invg_spread_code
, invg_term
, audit_freq_code
, audit_day_of_month
, audit_days_after
--, recon_freq_code
, recon_day_of_month
, recon_days_after
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
--, org_id
, use_gl_calendar
, period_type
, year_start_date
, comments
, effective_date
, vrg_reptg_freq_code
FROM pn_var_rent_dates_all
WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
SELECT line_default_id
, line_num
, var_rent_id
, sales_type_code
, item_category_code
, line_template_id
, agreement_template_id
, line_start_date
, line_end_date
, processed_flag
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, org_id
FROM pn_var_line_defaults_all
-- WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id; -- Commented by Vivek on 09-DEC-2010
SELECT bkhd_default_id
, bkhd_detail_num
, line_default_id
, bkhd_start_date
, bkhd_end_date
, break_type
, base_rent_type
, natural_break_rate
, base_rent
, breakpoint_type
, breakpoint_level
, line_template_id
, bkpt_head_template_id
, agreement_template_id
, processed_flag
, var_rent_id
, bkpt_update_flag
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, org_id
FROM pn_var_bkhd_defaults_all
-- Commented by Vivek on 09-DEC-2010
--WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
SELECT bkdt_default_id
, bkdt_detail_num
, bkhd_default_id
, bkdt_start_date
, bkdt_end_date
, period_bkpt_vol_start
, period_bkpt_vol_end
, group_bkpt_vol_start
, group_bkpt_vol_end
, bkpt_rate
, bkpt_det_template_id
, processed_flag
, var_rent_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, annual_basis_amount
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, org_id
FROM pn_var_bkdt_defaults_all
WHERE bkdt_default_id = p_bkdt_default_id
AND var_rent_id = p_var_rent_id;
SELECT constr_default_id
, constr_default_num
, var_rent_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, agreement_template_id
, constr_template_id
, constr_start_date
, constr_end_date
, constr_cat_code
, type_code
, amount
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, org_id
FROM pn_var_constr_defaults_all
--WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
SELECT abatement_id
, var_rent_id
, start_date
, end_date
, type_code
, amount
, allowance_applied
, description
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, comments
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, org_id
FROM pn_var_abat_defaults_all
--WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
l_allow_abat_update VARCHAR2 (1) := 'N';
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Start of Update_Var_Rent package', 3);
SAVEPOINT update_var_rent;
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Before opening cursor c_pn_var_rents'
, 3);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Cursor c_pn_var_rents not found', 3);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Cursor c_pn_var_rents found', 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.rent_num : '
|| l_pn_var_rents_rec.rent_num
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.rent_num : '
|| p_upd_var_rent_rec.rent_num
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.lease_id : '
|| l_pn_var_rents_rec.lease_id
, 3
);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.lease_id : '
|| p_upd_var_rent_rec.lease_id
, 3
);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.abstracted_by_user : '
|| l_pn_var_rents_rec.abstracted_by_user
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.abstracted_by_user : '
|| p_upd_var_rent_rec.abstracted_by_user
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.abstracted_by_user : '
|| l_pn_var_rents_rec.abstracted_by_user
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.abstracted_by_user : '
|| p_upd_var_rent_rec.abstracted_by_user
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.commencement_date : '
|| l_pn_var_rents_rec.commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.commencement_date : '
|| p_upd_var_rent_rec.commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.termination_date : '
|| l_pn_var_rents_rec.termination_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.termination_date : '
|| p_upd_var_rent_rec.termination_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_upd_var_rent_rec.term_template_id : '
|| p_upd_var_rent_rec.term_template_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_upd_var_rent_rec.term_template_name : '
|| p_upd_var_rent_rec.term_template_name
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.term_template_id : '
|| l_pn_var_rents_rec.term_template_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.term_template_id : '
|| p_upd_var_rent_rec.term_template_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.currency_code : '
|| l_pn_var_rents_rec.currency_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.currency_code : '
|| p_upd_var_rent_rec.currency_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.currency_code : '
|| l_pn_var_rents_rec.currency_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.currency_code : '
|| p_upd_var_rent_rec.currency_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.proration_days : '
|| l_pn_var_rents_rec.proration_days
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.proration_days : '
|| p_upd_var_rent_rec.proration_days
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.agreement_template_id : '
|| l_pn_var_rents_rec.agreement_template_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.agreement_template_id : '
|| p_upd_var_rent_rec.agreement_template_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.cumulative_vol : '
|| l_pn_var_rents_rec.cumulative_vol
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.cumulative_vol_code : '
|| p_upd_var_rent_rec.cumulative_vol_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.proration_rule : '
|| l_pn_var_rents_rec.proration_rule
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.proration_rule_code : '
|| p_upd_var_rent_rec.proration_rule_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.invoice_on : '
|| l_pn_var_rents_rec.invoice_on
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invoice_on_code : '
|| p_upd_var_rent_rec.invoice_on_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.negative_rent : '
|| l_pn_var_rents_rec.negative_rent
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.negative_rent_code : '
|| p_upd_var_rent_rec.negative_rent_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.type_code : '
|| l_pn_var_rents_rec.type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.type_code : '
|| p_upd_var_rent_rec.type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.purpose_code : '
|| l_pn_var_rents_rec.purpose_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.purpose_code : '
|| p_upd_var_rent_rec.purpose_code
, 3);
IF ( p_upd_var_rent_rec.last_update_date IS NULL
OR p_upd_var_rent_rec.last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_upd_var_rent_rec.last_update_date := g_sysdate;
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.last_update_date : '
|| l_pn_var_rents_rec.last_update_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.last_update_date : '
|| p_upd_var_rent_rec.last_update_date
, 3);
IF ( p_upd_var_rent_rec.last_updated_by IS NULL
OR p_upd_var_rent_rec.last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_upd_var_rent_rec.last_updated_by := g_user_id;
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.last_updated_by : '
|| l_pn_var_rents_rec.last_updated_by
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.last_updated_by : '
|| p_upd_var_rent_rec.last_updated_by
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.creation_date : '
|| l_pn_var_rents_rec.creation_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.creation_date : '
|| p_upd_var_rent_rec.creation_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.created_by : '
|| l_pn_var_rents_rec.created_by
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.created_by : '
|| p_upd_var_rent_rec.created_by
, 3);
IF ( p_upd_var_rent_rec.last_update_login IS NULL
OR p_upd_var_rent_rec.last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_upd_var_rent_rec.last_update_login := l_pn_var_rents_rec.last_update_login;
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.last_update_login : '
|| l_pn_var_rents_rec.last_update_login
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.last_update_login : '
|| p_upd_var_rent_rec.last_update_login
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute_category : '
|| l_pn_var_rents_rec.attribute_category
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute_category : '
|| p_upd_var_rent_rec.attribute_category
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute1 : '
|| l_pn_var_rents_rec.attribute1
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute1 : '
|| p_upd_var_rent_rec.attribute1
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute2 : '
|| l_pn_var_rents_rec.attribute2
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute2 : '
|| p_upd_var_rent_rec.attribute2
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute3 : '
|| l_pn_var_rents_rec.attribute3
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute3 : '
|| p_upd_var_rent_rec.attribute3
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute4 : '
|| l_pn_var_rents_rec.attribute4
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute4 : '
|| p_upd_var_rent_rec.attribute4
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute5 : '
|| l_pn_var_rents_rec.attribute5
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute5 : '
|| p_upd_var_rent_rec.attribute5
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute6 : '
|| l_pn_var_rents_rec.attribute6
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute6 : '
|| p_upd_var_rent_rec.attribute6
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute7 : '
|| l_pn_var_rents_rec.attribute7
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute7 : '
|| p_upd_var_rent_rec.attribute7
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute8 : '
|| l_pn_var_rents_rec.attribute8
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute8 : '
|| p_upd_var_rent_rec.attribute8
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute9 : '
|| l_pn_var_rents_rec.attribute9
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute9 : '
|| p_upd_var_rent_rec.attribute9
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute10 : '
|| l_pn_var_rents_rec.attribute10
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute10 : '
|| p_upd_var_rent_rec.attribute10
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute11 : '
|| l_pn_var_rents_rec.attribute11
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute11 : '
|| p_upd_var_rent_rec.attribute11
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute12 : '
|| l_pn_var_rents_rec.attribute12
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute12 : '
|| p_upd_var_rent_rec.attribute12
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute13 : '
|| l_pn_var_rents_rec.attribute13
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute13 : '
|| p_upd_var_rent_rec.attribute13
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute14 : '
|| l_pn_var_rents_rec.attribute14
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute14 : '
|| p_upd_var_rent_rec.attribute14
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rents_rec.attribute15 : '
|| l_pn_var_rents_rec.attribute15
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.attribute15 : '
|| p_upd_var_rent_rec.attribute15
, 3);
('PN_VAREN_PVT: Update_Var_Rent : Before calling validate_var_rent procedure'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: End of upd_val_varent Procedure status : '
|| x_return_status
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent : Value of Validate Flag : '
|| p_validate_flag
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPD_VAL_VARENT returned error');
('PN_VAREN_PVT: Update_Var_Rent: Start of update_varent Procedure'
, 3);
update_varent (p_upd_var_rent_rec_type => p_upd_var_rent_rec
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: End of update_varent Procedure status : '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_VARENT returned error');
('PN_VAREN_PVT: Update_Var_Rent: Before opening cursor c_pn_var_rent_dates'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Cursor c_pn_var_rent_dates not found'
, 3);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Cursor c_pn_var_rent_dates found'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.var_rent_date_id is : '
|| p_upd_var_rent_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.var_rent_date_id : '
|| l_pn_var_rent_dates_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.use_gl_calendar is '
|| p_upd_var_rent_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.use_gl_calendar is '
|| l_pn_var_rent_dates_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.use_gl_calendar is : '
|| p_upd_var_rent_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.use_gl_calendar : '
|| l_pn_var_rent_dates_rec.use_gl_calendar
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.year_start_date : '
|| l_pn_var_rent_dates_rec.year_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.year_start_date : '
|| p_upd_var_rent_rec.year_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.year_start_date is not null: '
|| p_upd_var_rent_rec.year_start_date
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Period Set Name and Period Type Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Period Set Name and Period Type status:'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.gl_period_set_name :'
|| p_upd_var_rent_rec.gl_period_set_name
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.period_type :'
|| p_upd_var_rent_rec.period_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Period Set Name and Period Type Expected Error :'
|| p_upd_var_rent_rec.gl_period_set_name
|| ' , '
|| p_upd_var_rent_rec.period_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Period Set Name and Period Type Un-Expected Error :'
|| p_upd_var_rent_rec.gl_period_set_name
|| ' , '
|| p_upd_var_rent_rec.period_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Period Set Name and Period Type Success :'
|| p_upd_var_rent_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.gl_period_set_name : '
|| l_pn_var_rent_dates_rec.gl_period_set_name
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.gl_period_set_name : '
|| p_upd_var_rent_rec.gl_period_set_name
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.period_type : '
|| l_pn_var_rent_dates_rec.period_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.period_type : '
|| p_upd_var_rent_rec.period_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.vrg_reptg_freq_code is '
|| p_upd_var_rent_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.vrg_reptg_freq_code is '
|| l_pn_var_rent_dates_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.vrg_reptg_freq_meaning is '
|| p_upd_var_rent_rec.vrg_reptg_freq_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Reporting Frequency Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Output Code :'
|| p_upd_var_rent_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.vrg_reptg_freq_code : '
|| l_pn_var_rent_dates_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.vrg_reptg_freq_code : '
|| p_upd_var_rent_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.vrg_reptg_freq_meaning : '
|| p_upd_var_rent_rec.vrg_reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Meaning Expected Error :'
|| p_upd_var_rent_rec.vrg_reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Meaning Un-Expected Error :'
|| p_upd_var_rent_rec.vrg_reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Code Success :'
|| p_upd_var_rent_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.vrg_reptg_freq_code : '
|| l_pn_var_rent_dates_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.vrg_reptg_freq_code : '
|| p_upd_var_rent_rec.vrg_reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.reptg_freq_code is '
|| p_upd_var_rent_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.reptg_freq_code is '
|| l_pn_var_rent_dates_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.reptg_freq_meaning is '
|| p_upd_var_rent_rec.reptg_freq_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Calculation Frequency Validation'
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency status:'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.reptg_freq_code :'
|| p_upd_var_rent_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.reptg_freq_meaning :'
|| p_upd_var_rent_rec.reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Meaning Expected Error :'
|| p_upd_var_rent_rec.reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Meaning Un-Expected Error :'
|| p_upd_var_rent_rec.reptg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Code Success :'
|| p_upd_var_rent_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.reptg_freq_code : '
|| l_pn_var_rent_dates_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.reptg_freq_code : '
|| p_upd_var_rent_rec.reptg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.reptg_day_of_month : '
|| l_pn_var_rent_dates_rec.reptg_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.reptg_day_of_month : '
|| p_upd_var_rent_rec.reptg_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.reptg_days_after : '
|| l_pn_var_rent_dates_rec.reptg_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.reptg_days_after : '
|| p_upd_var_rent_rec.reptg_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.invg_day_of_month : '
|| l_pn_var_rent_dates_rec.invg_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invg_day_of_month : '
|| p_upd_var_rent_rec.invg_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.invg_days_after : '
|| l_pn_var_rent_dates_rec.invg_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invg_days_after : '
|| p_upd_var_rent_rec.invg_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.comments : '
|| l_pn_var_rent_dates_rec.comments
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.comments : '
|| p_upd_var_rent_rec.comments
, 3);
('PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.comments IS NOT NULL'
, 2);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.comments : '
|| l_pn_var_rent_dates_rec.comments
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.comments : '
|| p_upd_var_rent_rec.comments
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.var_rent_date_id is : '
|| p_upd_var_rent_rec.var_rent_date_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.invg_freq_code is '
|| p_upd_var_rent_rec.invg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_rent_dates_rec.invg_freq_code is '
|| l_pn_var_rent_dates_rec.invg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.invg_freq_meaning is '
|| p_upd_var_rent_rec.invg_freq_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Invoicing Frequency Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Output Code :'
|| p_upd_var_rent_rec.invg_freq_code
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency status :'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invg_freq_code :'
|| p_upd_var_rent_rec.invg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invg_freq_meaning :'
|| p_upd_var_rent_rec.invg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Meaning Expected Error :'
|| p_upd_var_rent_rec.invg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Meaning Un-Expected Error :'
|| p_upd_var_rent_rec.invg_freq_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Code Success :'
|| p_upd_var_rent_rec.invg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.invg_freq_code : '
|| l_pn_var_rent_dates_rec.invg_freq_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.invg_freq_code : '
|| p_upd_var_rent_rec.invg_freq_code
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_undo_periods is '
|| l_undo_periods
, 3);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Start of undo_periods Procedure'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of undo_periods Procedure is '
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Error count of undo_periods Procedure is '
|| x_msg_count
, 3);
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : Undo Periods returned error');
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : Undo Periods returned error');
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.audit_day_of_month : '
|| l_pn_var_rent_dates_rec.audit_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.audit_day_of_month : '
|| p_upd_var_rent_rec.audit_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.audit_days_after : '
|| l_pn_var_rent_dates_rec.audit_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.audit_days_after : '
|| p_upd_var_rent_rec.audit_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.recon_day_of_month : '
|| l_pn_var_rent_dates_rec.recon_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.recon_day_of_month : '
|| p_upd_var_rent_rec.recon_day_of_month
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.recon_days_after : '
|| l_pn_var_rent_dates_rec.recon_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.recon_days_after : '
|| p_upd_var_rent_rec.recon_days_after
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute_category : '
|| l_pn_var_rent_dates_rec.attribute_category
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute_category : '
|| p_upd_var_rent_rec.dates_attribute_category
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute1 : '
|| l_pn_var_rent_dates_rec.attribute1
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute1 : '
|| p_upd_var_rent_rec.dates_attribute1
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute2 : '
|| l_pn_var_rent_dates_rec.attribute2
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute2 : '
|| p_upd_var_rent_rec.dates_attribute2
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute3 : '
|| l_pn_var_rent_dates_rec.attribute3
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute3 : '
|| p_upd_var_rent_rec.dates_attribute3
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute4 : '
|| l_pn_var_rent_dates_rec.attribute4
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute4 : '
|| p_upd_var_rent_rec.dates_attribute4
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute5 : '
|| l_pn_var_rent_dates_rec.attribute5
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute5 : '
|| p_upd_var_rent_rec.dates_attribute5
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute6 : '
|| l_pn_var_rent_dates_rec.attribute6
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute6 : '
|| p_upd_var_rent_rec.dates_attribute6
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute7 : '
|| l_pn_var_rent_dates_rec.attribute7
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute7 : '
|| p_upd_var_rent_rec.dates_attribute7
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute8 : '
|| l_pn_var_rent_dates_rec.attribute8
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute8 : '
|| p_upd_var_rent_rec.dates_attribute8
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute9 : '
|| l_pn_var_rent_dates_rec.attribute9
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute9 : '
|| p_upd_var_rent_rec.dates_attribute9
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute10 : '
|| l_pn_var_rent_dates_rec.attribute10
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute10 : '
|| p_upd_var_rent_rec.dates_attribute10
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute11 : '
|| l_pn_var_rent_dates_rec.attribute11
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute11 : '
|| p_upd_var_rent_rec.dates_attribute11
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute12 : '
|| l_pn_var_rent_dates_rec.attribute12
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute12 : '
|| p_upd_var_rent_rec.dates_attribute12
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute13 : '
|| l_pn_var_rent_dates_rec.attribute13
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute13 : '
|| p_upd_var_rent_rec.dates_attribute13
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute14 : '
|| l_pn_var_rent_dates_rec.attribute14
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute14 : '
|| p_upd_var_rent_rec.dates_attribute14
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_rent_dates_rec.attribute15 : '
|| l_pn_var_rent_dates_rec.attribute15
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_upd_var_rent_rec.dates_attribute15 : '
|| p_upd_var_rent_rec.dates_attribute15
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling of Upd_Validate_Rent_Dates Procedure'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of Upd_Validate_Rent_Dates Procedure is '
|| x_return_status
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_validate_flag is '
|| p_validate_flag
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UPD_VALIDATE_RENT_DATES returned error');
('PN_VAREN_PVT: Update_Var_Rent: Start of update_varen_dates Procedure'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.year_start_date before update_varen_dates procedure is : '
|| p_upd_var_rent_rec.year_start_date
, 3);
update_varen_dates (p_upd_var_rent_rec_type => p_upd_var_rent_rec
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_varen_dates Procedure '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: update_varen_dates: Error');
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: update_varen_dates: Error');
('PN_VAREN_PVT: Update_Var_Rent: Cursor c_pn_var_line_defaults found'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Starting of Variable Rent Lines Loop'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_undo_breakpoints is '
|| p_undo_breakpoints
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_bkpt_exist is '
|| l_bkpt_exist
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: status of undo_breakpoints procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UNDO_BREAKPOINTS returned error');
('PN_VAREN_PVT: Update_Var_Rent: Calling SALES_CHANNEL (Type 1) Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_var_rent_lines_tbl (ul).sales_channel_meaning :'
|| p_var_rent_lines_tbl (ul).sales_channel_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_var_rent_lines_tbl (ul).sales_channel_code:'
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Output Code :'
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Meaning Expected Error :'
|| p_var_rent_lines_tbl (ul).sales_channel_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Sales Channel Lookup Validation Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Meaning Un-Expected Error :'
|| p_var_rent_lines_tbl (ul).sales_channel_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Sales Channel Lookup Validation Unexpected Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Code Success :'
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Sales Channel Lookup Validation Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_line_defaults.sales_type_code is :'
|| l_pn_var_line_defaults.sales_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).sales_channel_code:'
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling ITEM_CATEGORY(Type 2) Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_var_rent_lines_tbl (ul).item_category_meaning :'
|| p_var_rent_lines_tbl (ul).item_category_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_var_rent_lines_tbl (ul).item_category_code:'
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Output Code :'
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Item Category Lookup Validation Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Meaning Expected Error :'
|| p_var_rent_lines_tbl (ul).item_category_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Item Category Lookup Validation Unexpected Error :'
|| p_var_rent_lines_tbl (ul).item_category_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Meaning Un-Expected Error :'
|| p_var_rent_lines_tbl (ul).item_category_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Item Category Lookup Validation Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Code Success :'
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_pn_var_line_defaults.item_category_meaning is :'
|| l_pn_var_line_defaults.item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).item_category_code:'
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
IF ( p_var_rent_lines_tbl (ul).last_update_date IS NULL
OR p_var_rent_lines_tbl (ul).last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_var_rent_lines_tbl (ul).last_update_date := SYSDATE;
IF ( p_var_rent_lines_tbl (ul).last_updated_by IS NULL
OR p_var_rent_lines_tbl (ul).last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_var_rent_lines_tbl (ul).last_updated_by := g_user_id;
IF ( p_var_rent_lines_tbl (ul).last_update_login IS NULL
OR p_var_rent_lines_tbl (ul).last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_var_rent_lines_tbl (ul).last_update_login := g_user_id;
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_RENTS Descriptive Fields Error '||l_return_msg);
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
('PN_VAREN_PVT: Update_Var_Rent: After all validations of Variable rent lines'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).var_rent_id is '
|| p_var_rent_lines_tbl (ul).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).line_default_id is '
|| p_var_rent_lines_tbl (ul).line_default_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).line_num is '
|| p_var_rent_lines_tbl (ul).line_num
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).sales_channel_code is '
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).item_category_code is '
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).line_start_date is '
|| p_var_rent_lines_tbl (ul).line_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before - Value of p_var_rent_lines_tbl (ul).line_end_date is '
|| p_var_rent_lines_tbl (ul).line_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_bkpt_exist after breakpoint_ext procedure is'
|| l_bkpt_exist
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Before calling update_variable_rent_lines procedure '
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).var_rent_id is '
|| p_var_rent_lines_tbl (ul).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_default_id is '
|| p_var_rent_lines_tbl (ul).line_default_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_num is '
|| p_var_rent_lines_tbl (ul).line_num
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).sales_channel_code is '
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).item_category_code is '
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_start_date is '
|| p_var_rent_lines_tbl (ul).line_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_end_date is '
|| p_var_rent_lines_tbl (ul).line_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_default_id is null'
|| p_var_rent_lines_tbl (ul).line_default_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).sales_channel_code is '
|| p_var_rent_lines_tbl (ul).sales_channel_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).item_category_code is '
|| p_var_rent_lines_tbl (ul).item_category_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_start_date is '
|| p_var_rent_lines_tbl (ul).line_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_end_date is '
|| p_var_rent_lines_tbl (ul).line_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_num is '
|| p_var_rent_lines_tbl (ul).line_num
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of insert_variable_rent_lines procedure '
, 3);
IF p_var_rent_lines_tbl (ul).last_update_date = pn_varen_util.g_pn_miss_date
THEN
p_var_rent_lines_tbl (ul).last_update_date := NULL;
IF p_var_rent_lines_tbl (ul).last_updated_by = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_lines_tbl (ul).last_updated_by := NULL;
IF p_var_rent_lines_tbl (ul).last_update_login = pn_varen_util.g_pn_miss_num
THEN
p_var_rent_lines_tbl (ul).last_update_login := NULL;
insert_variable_rent_lines
(p_variable_rent_lines_rec_type => p_var_rent_lines_tbl (ul)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: After Insertion of VRA Line, line_default_id is '
|| p_var_rent_lines_tbl (ul).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of insert_variable_rent_lines procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: INSERT_VARIABLE_RENT_LINES procedure returned error');
('PN_VAREN_PVT: Update_Var_Rent: Value of p_var_rent_lines_tbl (ul).line_default_id is not null'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of update_variable_rent_lines procedure '
, 3);
update_variable_rent_lines
(p_variable_rent_lines_rec_type => p_var_rent_lines_tbl (ul)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_variable_rent_lines procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UPDATE_VARIABLE_RENT_LINES procedure returned error');
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Inside Breakpoint Headers Loop'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling BREAK_TYPE Validation Lookup - Inside the Loop'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling BREAK_TYPE Validation'
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Meaning :'
|| p_breakpoint_header_tbl (ubk).break_type_meaning
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Code :'
|| p_breakpoint_header_tbl (ubk).break_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE validation status :'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Meaning Expected Error :'
|| p_breakpoint_header_tbl (ubk).break_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Lookup Validation Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Meaning Un-Expected Error :'
|| p_breakpoint_header_tbl (ubk).break_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Lookup Validation Unexpected Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Code Success :'
|| p_breakpoint_header_tbl (ubk).break_type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Lookup Validation Success'
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Code :'
|| p_breakpoint_header_tbl (ubk).break_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_bkhd_defaults.break_type :'
|| l_pn_var_bkhd_defaults.break_type
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling BREAKPOINT_TYPE Validation Lookup - Inside the Loop'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling BREAKPOINT_TYPE Validation'
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Meaning :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_meaning
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Code :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE validation status :'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Meaning Expected Error :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Lookup Validation Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Meaning Un-Expected Error :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Lookup Validation Unexpected Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: pn_varen_pvt-BREAKPOINT_TYPE Code Success :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Lookup Validation Success'
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Code :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: l_pn_var_bkhd_defaults.breakpoint_type :'
|| l_pn_var_bkhd_defaults.breakpoint_type
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Provide a correct combination of BREAKPOINT_TYPE_code and Break Type code - Validation Error :'
|| p_breakpoint_header_tbl (ubk).breakpoint_type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Combination of BREAKPOINT_TYPE_code and Break Type code Validation success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE_code IS NATURAL '
|| p_breakpoint_header_tbl (ubk).break_type_code
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE_code is '
|| p_breakpoint_header_tbl (ubk).break_type_code
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Natural break rate is '
|| p_breakpoint_header_tbl (ubk).natural_break_rate
, 3);
IF ( p_breakpoint_header_tbl (ubk).last_update_date IS NULL
OR p_breakpoint_header_tbl (ubk).last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_breakpoint_header_tbl (ubk).last_update_date := g_sysdate;
IF ( p_breakpoint_header_tbl (ubk).last_updated_by IS NULL
OR p_breakpoint_header_tbl (ubk).last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_breakpoint_header_tbl (ubk).last_updated_by := g_user_id;
IF ( p_breakpoint_header_tbl (ubk).last_update_login IS NULL
OR p_breakpoint_header_tbl (ubk).last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_breakpoint_header_tbl (ubk).last_update_login :=
l_pn_var_bkhd_defaults.last_update_login;
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_BKPTS_HEAD Descriptive Fields Error '||l_return_msg);
fnd_message.set_token ('ERR_MSG','UPDATE_VAR_RENT : PN_VAR_BKPTS_HEAD Descriptive Fields Error '|| l_return_msg);
( 'PN_VAREN_PVT: Update_Var_Rent: Breakpoint header validations status is '
|| x_return_status
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Generate Breakpoint existence procedure '
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_bkpt_exist from breakpoint_ext procedure is'
|| l_bkpt_exist
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of breakpoint_ext procedure '
|| x_return_status
, 3);
SELECT COUNT(1)
INTO l_date_range_count
FROM pn_var_bkhd_defaults_all
WHERE var_rent_id = p_breakpoint_header_tbl (ubk).var_rent_id
AND bkhd_default_id<> p_breakpoint_header_tbl (ubk).bkhd_default_id
AND line_default_id = p_breakpoint_header_tbl (ubk).line_default_id
AND (bkhd_start_date <= p_breakpoint_header_tbl (ubk).bkhd_end_date AND bkhd_end_date >= p_breakpoint_header_tbl (ubk).bkhd_start_date);
insert_breakpoint_headers
(p_breakpoint_header_rec_type => p_breakpoint_header_tbl (ubk)
, x_return_status => x_return_status);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:INSERT_BREAKPOINT_HEADERS procedure returned error');
('PN_VAREN_PVT: Update_Var_Rent: Calling update_breakpoint_headers procedure'
, 3);
update_breakpoint_headers
(p_breakpoint_header_rec_type => p_breakpoint_header_tbl (ubk)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_breakpoint_headers procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_BREAKPOINT_HEADERS procedure returned error');
( 'PN_VAREN_PVT: Update_Var_Rent: After the cursor C_pn_var_bkdt_defaults is open, value of p_upd_var_rent_rec.var_rent_id is '
|| p_upd_var_rent_rec.var_rent_id
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Inside Breakpoint Details procedure loop'
, 3);
IF ( p_breakpoint_details_tbl (ubd).last_update_date IS NULL
OR p_breakpoint_details_tbl (ubd).last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_breakpoint_details_tbl (ubd).last_update_date := g_sysdate;
IF ( p_breakpoint_details_tbl (ubd).last_updated_by IS NULL
OR p_breakpoint_details_tbl (ubd).last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_breakpoint_details_tbl (ubd).last_updated_by := g_user_id;
IF ( p_breakpoint_details_tbl (ubd).last_update_login IS NULL
OR p_breakpoint_details_tbl (ubd).last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_breakpoint_details_tbl (ubd).last_update_login := g_user_id;
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_BKPTS_DETAIL Descriptive Fields Error '||l_return_msg);
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT: PN_VAR_BKPTS_DETAIL Descriptive Fields Error '||l_return_msg);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of Breakpoint Details validations is '
|| x_return_status
, 3);
SELECT COUNT(1)
INTO l_date_range_bkdt_count
FROM pn_var_bkdt_defaults_all
WHERE var_rent_id = p_breakpoint_details_tbl (ubd).var_rent_id
AND bkdt_default_id<>p_breakpoint_details_tbl (ubd).bkdt_default_id
AND bkhd_default_id =p_breakpoint_details_tbl (ubd).bkhd_default_id
AND (bkdt_start_date <=p_breakpoint_details_tbl (ubd).bkdt_end_date AND bkdt_end_date >= p_breakpoint_details_tbl (ubd).bkdt_start_date);
('PN_VAREN_PVT: Update_Var_Rent: Before calling update_breakpoint_details prcoedure '
, 3);
update_breakpoint_details
(p_breakpoint_details_rec_type => p_breakpoint_details_tbl (ubd)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_breakpoint_details prcoedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_BREAKPOINT_DETAILS procedure returned error');
insert_breakpoint_details
(p_breakpoint_details_rec_type => p_breakpoint_details_tbl (ubd)
, x_return_status => x_return_status);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:INSERT_BREAKPOINT_DETAILS procedure returned error');
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_constraints_tbl(uc).var_rent_id :'
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_var_commencement_date :'
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_constraints_tbl(uc).var_rent_id :'
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before l_var_commencement_date :'
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before l_var_termination_date :'
|| l_var_termination_date
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Before x_return_status :'
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Variable Rent Id '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of var_rent_details procedure is '
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Variable Rent Id exists : '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent commencement date : '
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent termination date : '
|| l_var_termination_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Variable Rent Id doesnot exists : '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After p_constraints_tbl(uc).var_rent_id :'
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After l_var_commencement_date :'
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After l_var_termination_date :'
|| l_var_termination_date
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: After x_return_status :'
|| x_return_status
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Verifying whether constraints are generated or not.'
, 3);
SELECT COUNT (1)
INTO ln_const_count
FROM pn_var_constraints_all
WHERE constr_default_id IN (SELECT constr_default_id
FROM pn_var_constr_defaults_all
WHERE var_rent_id = p_constraints_tbl (uc).var_rent_id);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of ln_const_count is '
|| ln_const_count
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraints are already generated for the Variable Rent Id : '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraints are already generated for the Variable Rent Id : '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before calling undo_constraints procedure, value of p_undo_constraints is '
|| p_undo_constraints
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before undo_constraints procedure, value of constraints var_rent_id is '
|| p_constraints_tbl (uc).var_rent_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of undo_constraints procedure is '
|| x_return_status
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Error occured while verifying whether constraints are generated or not.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date is not null : '
|| p_constraints_tbl (uc).constr_start_date
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint End Date : '
|| p_constraints_tbl (uc).constr_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Commencement Date : '
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Termination Date: '
|| l_var_termination_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Success :'
|| p_constraints_tbl (uc).constr_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Success :'
|| p_constraints_tbl (uc).constr_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error :'
|| p_constraints_tbl (uc).constr_start_date
|| 'Please enter a constraint start date that is the same as or after the commencement date of the variable rent agreement.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error : '
|| p_constraints_tbl (uc).constr_start_date
|| 'Please enter a constraint start date that is the same as or after the commencement date of the variable rent agreement.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error :'
|| p_constraints_tbl (uc).constr_start_date
|| 'Please ensure that constraint dates you enter coincide with invoice period dates'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error : '
|| p_constraints_tbl (uc).constr_start_date
|| 'Please ensure that constraint dates you enter coincide with invoice period dates'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date is null then value is Defaulted Variable Rent Commencement Date : '
|| l_var_commencement_date
|| ' Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date is null then value is Defaulted Variable Rent Commencement Date : '
|| l_var_commencement_date
|| ' Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: , p_constraints_tbl (uc).constr_start_date :'
|| p_constraints_tbl (uc).constr_start_date
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: , l_var_commencement_date :'
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint end Date is not null : '
|| p_constraints_tbl (uc).constr_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Termination Date: '
|| l_var_termination_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint end Date Validation Success :'
|| p_constraints_tbl (uc).constr_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint end Date Validation Success :'
|| p_constraints_tbl (uc).constr_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constratint end Date Validation Error :'
|| p_constraints_tbl (uc).constr_end_date
|| 'Please enter a constraint end date that is the same as or before the termination date of the variable rent agreement.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error : '
|| p_constraints_tbl (uc).constr_end_date
|| 'Please enter a constraint end date that is the same as or before the termination date of the variable rent agreement.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error :'
|| p_constraints_tbl (uc).constr_end_date
|| 'Please enter an end date that is greater than or equal to the start date.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error : '
|| p_constraints_tbl (uc).constr_end_date
|| 'Please enter an end date that is greater than or equal to the start date.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date is null then value is defaulted Variable Rent Termination Date : '
|| l_var_termination_date
|| ' Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date is null then value is defaulted Termination Date : '
|| l_var_termination_date
|| ' Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_constraints_tbl (uc).constr_end_date :'
|| p_constraints_tbl (uc).constr_end_date
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Please ensure that constraint dates you enter coincide with invoice period dates'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Please ensure that constraint dates you enter coincide with invoice period dates'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: p_constraints_tbl (uc).constr_cat_code :'
|| p_constraints_tbl (uc).constr_cat_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_constraints_tbl (uc).constr_type_meaning :'
|| p_constraints_tbl (uc).constr_type_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_constraints_tbl (uc).constr_type_code :'
|| p_constraints_tbl (uc).constr_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before l_pn_var_constraints.type_code :'
|| l_pn_var_constraints.type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Validation Lookup - Inside the Loop'
, 3);
pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Output Code :'
|| p_constraints_tbl (uc).constr_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Meaning Expected Error :'
|| p_constraints_tbl (uc).constr_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Lookup Validation Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Meaning Un-Expected Error :'
|| p_constraints_tbl (uc).constr_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Lookup Validation Unexpected Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Code Success :'
|| p_constraints_tbl (uc).constr_type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Lookup Validation Success'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After p_constraints_tbl (uc).constr_type_meaning :'
|| p_constraints_tbl (uc).constr_type_meaning
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After p_constraints_tbl (uc).constr_type_code :'
|| p_constraints_tbl (uc).constr_type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After l_pn_var_constraints.type_code :'
|| l_pn_var_constraints.type_code
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before p_constraints_tbl (uc).constr_amount :'
|| p_constraints_tbl (uc).constr_amount
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Before l_pn_var_constraints.amount :'
|| l_pn_var_constraints.amount
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After p_constraints_tbl (uc).constr_amount :'
|| p_constraints_tbl (uc).constr_amount
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: After l_pn_var_constraints.amount :'
|| l_pn_var_constraints.amount
, 3);
IF ( p_constraints_tbl (uc).last_update_date IS NULL
OR p_constraints_tbl (uc).last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_constraints_tbl (uc).last_update_date := g_sysdate;
IF ( p_constraints_tbl (uc).last_updated_by IS NULL
OR p_constraints_tbl (uc).last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_constraints_tbl (uc).last_updated_by := g_user_id;
IF ( p_constraints_tbl (uc).last_update_login IS NULL
OR p_constraints_tbl (uc).last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_constraints_tbl (uc).last_update_login := g_user_id;
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT: PN_VAR_CONSTRAINTS Descriptive Fields Error '||l_return_msg);
fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_CONSTRAINTS Descriptive Fields Error '||l_return_msg);
('PN_VAREN_PVT: Update_Var_Rent: Start of update_varen_dates Procedure'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.year_start_date before update_varen_dates procedure is : '
|| p_constraints_tbl (uc).constr_default_id
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.year_start_date before update_varen_dates procedure is : '
|| p_constraints_tbl (uc).constr_default_num
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_upd_var_rent_rec.year_start_date before update_varen_dates procedure is : '
|| p_constraints_tbl (uc).var_rent_id
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling constr_ext procedure for no of constraint records. '
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of constr_ext procedure is '
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: No of Constratint records for the Variable Rent is '
|| l_constr_count
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of val_ins_constraints procedure '
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of val_ins_constraints procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:VAL_INS_CONSTRAINTS procedure returned error');
('PN_VAREN_PVT: Update_Var_Rent: Only two constraints records can exists with constraint type as MAX and MIN.'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of ln_const_count is '
|| ln_const_count
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of update_constraints Procedure '
, 3);
update_constraints (p_constraints_rec_type => p_constraints_tbl (uc)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_varen_dates Procedure :'
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_CONSTRAINTS procedure returned error');
( 'PN_VAREN_PVT: Update_Var_Rent: Value of p_undo_constratints should be ''Y'' then only record could be updated.'
|| x_return_status
, 3);
SELECT commencement_date
, termination_date
INTO l_var_commencement_date
, l_var_termination_date
FROM pn_var_rents_all
WHERE ( var_rent_id = p_allow_abat_tbl (ua).var_rent_id
OR rent_num = p_allow_abat_tbl (ua).var_rent_num)
AND org_id = g_org_id --l_org_id
GROUP BY var_rent_id
, commencement_date
, termination_date;
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Number or Variable Rent Id doesnot exists :'
|| SQLERRM
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Allowance and Abatements Validation Lookup - Inside the Loop'
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Calling Allowance and Abatements Validation'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatements Output Code :'
|| p_allow_abat_tbl (ua).abat_type_code
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Please provide correct Allowance and Abatements Type Code Expected Error :'
|| p_allow_abat_tbl (ua).abat_type_meaning
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatements Lookup Validation Error'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatements Meaning Un-Expected Error :'
|| p_allow_abat_tbl (ua).abat_type_meaning
, 3);
('PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatements Lookup Validation Unexpected Error'
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatements Code Success :'
|| p_allow_abat_tbl (ua).abat_type_code
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatements Lookup Validation Success'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date is less than Allowance and Abatement end date: '
|| p_allow_abat_tbl (ua).abat_start_date
|| ' and '
|| p_allow_abat_tbl (ua).abat_end_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowances and abatements must start on the same date as the invoice period.Please change the allowance or abatement start date. '
|| p_allow_abat_tbl (ua).abat_start_date
|| ' and '
|| p_allow_abat_tbl (ua).abat_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatement Start date is not null : '
|| p_allow_abat_tbl (ua).abat_start_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatement end date : '
|| p_allow_abat_tbl (ua).abat_end_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Commencement Date : '
|| l_var_commencement_date
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Variable Rent Termination Date: '
|| l_var_termination_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Success :'
|| p_allow_abat_tbl (ua).abat_start_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Success :'
|| p_allow_abat_tbl (ua).abat_start_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Error : '
|| p_allow_abat_tbl (ua).abat_start_date
|| 'Please ensure that the start date for a rolling allowance or fixed abatement is within the variable rent agreement dates.'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Error : '
|| p_allow_abat_tbl (ua).abat_start_date
|| ' and '
|| p_allow_abat_tbl (ua).abat_end_date
|| 'Please ensure that the start date for a rolling allowance or fixed abatement is less than the end date.'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date is null then value is Defaulted Variable Rent Commencement Date : '
|| l_var_commencement_date
|| ' Success'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date is null then value is Defaulted Variable Rent Commencement Date : '
|| l_var_commencement_date
|| ' Success'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement end date is not null : '
|| p_allow_abat_tbl (ua).abat_end_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Variable Rent Termination Date: '
|| l_var_termination_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement end date Validation Success :'
|| p_allow_abat_tbl (ua).abat_end_date
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement end Date Validation Error : '
|| p_allow_abat_tbl (ua).abat_end_date
|| 'Please ensure that the end date for a roslling allowance or fixed abatement is within the variable rent agreement dates.'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement end Date Validation Error : '
|| p_allow_abat_tbl (ua).abat_end_date
|| 'Please ensure that the start date for a rolling allowance or fixed abatement is less than the end date.'
, 3);
( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement end Date is null then value is defaulted Termination Date : '
|| l_var_termination_date
|| ' Success'
, 3);
IF ( p_allow_abat_tbl (ua).last_update_date IS NULL
OR p_allow_abat_tbl (ua).last_update_date = pn_varen_util.g_pn_miss_date)
THEN
p_allow_abat_tbl (ua).last_update_date := g_sysdate;
IF ( p_allow_abat_tbl (ua).last_updated_by IS NULL
OR p_allow_abat_tbl (ua).last_updated_by = pn_varen_util.g_pn_miss_num)
THEN
p_allow_abat_tbl (ua).last_updated_by := g_user_id;
IF ( p_allow_abat_tbl (ua).last_update_login IS NULL
OR p_allow_abat_tbl (ua).last_update_login = pn_varen_util.g_pn_miss_num)
THEN
p_allow_abat_tbl (ua).last_update_login := g_user_id;
END IF; -- End of attributes valitions in update var Allow and Abate
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: x_return_status : '
|| x_return_status
, 3);
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: l_upd_allow_abat_val : '
|| l_upd_allow_abat_val
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of val_ins_allow_abat procedure '
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:VAL_INS_ALLOW_ABAT procedure returned error');
l_allow_abat_update := 'Y';
( 'PN_VAREN_PVT: Update_Var_Rent: Status of val_ins_allow_abat procedure is '
|| x_return_status
, 3);
( 'PN_VAREN_PVT: Update_Var_Rent: Value of l_allow_abat_update is :'
|| l_allow_abat_update
, 3);
('PN_VAREN_PVT: Update_Var_Rent: Start of update_allow_abat procedure '
, 3);
update_allow_abat (p_allow_abat_rec_type => p_allow_abat_tbl (ua)
, x_return_status => x_return_status);
( 'PN_VAREN_PVT: Update_Var_Rent: Status of update_allow_abat procedure is '
|| x_return_status
, 3);
fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_ALLOW_ABAT procedure returned error');
pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Var_Rent: Exception Result of Update_Var_Rent :'
|| SQLERRM
, 3
);*/
( 'PN_VAREN_PVT: Update_Var_Rent: Exception Result of Update_Var_Rent :'
|| '-'
|| SQLERRM
, 5);
( 'PN_VAREN_PVT: Update_Var_Rent: Exception Result of Update_Var_Rent :'
|| '-'
|| SQLERRM
, 5);
END update_var_rent;
SELECT COUNT (1)
INTO l_count
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name = UPPER (TRIM (p_desc_name))
AND enabled_flag = 'Y'
AND display_flag = 'Y';