DBA Data[Home] [Help]

APPS.PN_VAREN_PVT dependencies on PN_VAR_RENTS_PKG

Line 8648: ('PN_VAREN_PVT: Call_Varen_Insert_Row: Calling Variable Rent Insert Procedure pn_var_rents_pkg.insert_row'

8644: l_uom_code VARCHAR2 (3) DEFAULT 'SFT';
8645: BEGIN
8646: x_return_status := fnd_api.g_ret_sts_success;
8647: pn_varen_util.pvt_debug
8648: ('PN_VAREN_PVT: Call_Varen_Insert_Row: Calling Variable Rent Insert Procedure pn_var_rents_pkg.insert_row'
8649: , 3
8650: );
8651: -- pn_varen_util.pvt_debug ('PN_VAREN_PVT: Call_Varen_Insert_Row: START OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE');
8652: pn_var_rents_pkg.insert_row (x_rowid => g_rowid

Line 8651: -- pn_varen_util.pvt_debug ('PN_VAREN_PVT: Call_Varen_Insert_Row: START OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE');

8647: pn_varen_util.pvt_debug
8648: ('PN_VAREN_PVT: Call_Varen_Insert_Row: Calling Variable Rent Insert Procedure pn_var_rents_pkg.insert_row'
8649: , 3
8650: );
8651: -- pn_varen_util.pvt_debug ('PN_VAREN_PVT: Call_Varen_Insert_Row: START OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE');
8652: pn_var_rents_pkg.insert_row (x_rowid => g_rowid
8653: , x_var_rent_id => p_var_rent_id --l_var_rent_id
8654: , x_rent_num => p_var_rent_rec.rent_num
8655: , x_lease_id => p_var_rent_rec.lease_id

Line 8652: pn_var_rents_pkg.insert_row (x_rowid => g_rowid

8648: ('PN_VAREN_PVT: Call_Varen_Insert_Row: Calling Variable Rent Insert Procedure pn_var_rents_pkg.insert_row'
8649: , 3
8650: );
8651: -- pn_varen_util.pvt_debug ('PN_VAREN_PVT: Call_Varen_Insert_Row: START OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE');
8652: pn_var_rents_pkg.insert_row (x_rowid => g_rowid
8653: , x_var_rent_id => p_var_rent_id --l_var_rent_id
8654: , x_rent_num => p_var_rent_rec.rent_num
8655: , x_lease_id => p_var_rent_rec.lease_id
8656: , x_location_id => p_var_rent_rec.location_id

Line 8698: ('PN_VAREN_PVT: Call_Varen_Insert_Row: End OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'

8694: , x_chg_cal_var_rent_id => NULL
8695: --p_var_rent_rec.chg_cal_var_rent_id, Initial value
8696: );
8697: pn_varen_util.pvt_debug
8698: ('PN_VAREN_PVT: Call_Varen_Insert_Row: End OF CALLING PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
8699: , 3
8700: );
8701: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: p_var_rent_id : '
8702: || p_var_rent_id

Line 8730: ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: Exception Result of PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'

8726: EXCEPTION
8727: WHEN OTHERS
8728: THEN
8729: pn_varen_util.pvt_debug
8730: ( 'PN_VAREN_PVT: Call_Varen_Insert_Row: Exception Result of PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
8731: || SQLERRM
8732: , 3
8733: );
8734: x_return_status := fnd_api.g_ret_sts_error;

Line 8760: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: Start of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'

8756: l_accrual VARCHAR2 (1) DEFAULT 'Y';
8757: l_uom_code VARCHAR2 (3) DEFAULT 'SFT';
8758: l_null VARCHAR2 (1) DEFAULT NULL;
8759: BEGIN
8760: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: Start of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
8761: , 3
8762: );
8763: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.VAR_RENT_ID :'
8764: || p_upd_var_rent_rec_type.var_rent_id

Line 8834: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'

8830: || p_upd_var_rent_rec_type.proration_rule_code
8831: , 3
8832: );
8833: --pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID :'||p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID , 3 );
8834: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
8835: , 3
8836: );
8837: pn_var_rents_pkg.update_row (x_var_rent_id => p_upd_var_rent_rec_type.var_rent_id
8838: , x_rent_num => p_upd_var_rent_rec_type.rent_num

Line 8837: pn_var_rents_pkg.update_row (x_var_rent_id => p_upd_var_rent_rec_type.var_rent_id

8833: --pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID :'||p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID , 3 );
8834: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End of Calling PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
8835: , 3
8836: );
8837: pn_var_rents_pkg.update_row (x_var_rent_id => p_upd_var_rent_rec_type.var_rent_id
8838: , x_rent_num => p_upd_var_rent_rec_type.rent_num
8839: , x_lease_id => p_upd_var_rent_rec_type.lease_id
8840: , x_location_id => p_upd_var_rent_rec_type.location_id
8841: , x_proration_days => p_upd_var_rent_rec_type.proration_days

Line 8883: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End OF CALLING PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'

8879: , x_proration_rule => p_upd_var_rent_rec_type.proration_rule_code
8880: , x_chg_cal_var_rent_id => l_null
8881: --p_upd_var_rent_rec_type.CHG_CAL_VAR_RENT_ID
8882: );
8883: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Update_Varent: End OF CALLING PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
8884: , 3
8885: );
8886: EXCEPTION
8887: WHEN OTHERS

Line 8890: ( 'PN_VAREN_PVT: Update_Varent: Exception Result of PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'

8886: EXCEPTION
8887: WHEN OTHERS
8888: THEN
8889: pn_varen_util.pvt_debug
8890: ( 'PN_VAREN_PVT: Update_Varent: Exception Result of PN_VAR_RENTS_PKG.UPDATE_ROW PACKAGE'
8891: || SQLERRM
8892: , 3
8893: );
8894: END update_varent;

Line 9466: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Before PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'

9462: --fnd_msg_pub.ADD;
9463: RAISE fnd_api.g_exc_error;
9464: END IF;
9465:
9466: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Before PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
9467: , 3
9468: );
9469: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Create_Var_Rent: Row Id : '
9470: || g_rowid