APPS.PN_VAR_ABATEMENTS_PKG dependencies on PNP_DEBUG_PKG

Line 44: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (+)');

40:
41:
42: BEGIN
43:
44: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (+)');
45:
46: -------------------------------------------------------
47: -- SELECT the nextval fOR var abatement id
48: -------------------------------------------------------

Line 103: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (-)');

99: RAISE no_data_found;
100: END IF;
101: CLOSE var_abatements;
102:
103: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (-)');
104:
105: END INSERT_ROW;
106:
107: -------------------------------------------------------------------------------

Line 132: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (+)');

128: tlINfo c1%ROWTYPE;
129:
130: BEGIN
131:
132: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (+)');
133:
134: OPEN c1;
135: FETCH c1 INTO tlINfo;
136: IF (c1%NOTFOUND) THEN

Line 160: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (-)');

156: ELSE
157: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PAYMENT_TERM_ID',tlINfo.PAYMENT_TERM_ID);
158: END IF;
159:
160: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (-)');
161:
162: END LOCK_ROW;
163:
164: -----------------------------------------------------------------------

Line 182: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (+)');

178: ) IS
179:
180: BEGIN
181:
182: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (+)');
183:
184: UPDATE PN_VAR_ABATEMENTS_ALL SET
185: VAR_RENT_ID = X_VAR_RENT_ID,
186: VAR_RENT_INV_ID = X_VAR_RENT_INV_ID,

Line 202: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (-)');

198: IF (SQL%NOTFOUND) THEN
199: RAISE NO_DATA_FOUND;
200: END IF;
201:
202: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (-)');
203:
204: END UPDATE_ROW;
205:
206: -------------------------------------------------------------------------------

Line 222: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (+)');

218: ) IS
219:
220: BEGIN
221:
222: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (+)');
223:
224: DELETE FROM PN_VAR_ABATEMENTS_ALL
225: WHERE VAR_RENT_ID = X_VAR_RENT_ID
226: AND VAR_RENT_INV_ID = X_VAR_RENT_INV_ID

Line 234: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (-)');

230: RAISE NO_DATA_FOUND;
231: END IF;
232:
233:
234: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (-)');
235:
236: END DELETE_ROW;
237:
238: --------------------------------------------------------------------

Line 277: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.CHECK_CALC_INV_EXISTS :'||' (+)');

273: l_inv_date DATE := NULL;
274: l_dummy VARCHAR2(1) :=NULL;
275:
276: BEGIN
277: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.CHECK_CALC_INV_EXISTS :'||' (+)');
278:
279: FOR get_inv_date_rec IN get_inv_date(p_var_rent_inv_id) LOOP
280: l_inv_date := get_inv_date_rec.invoice_date;
281: END LOOP;

Line 286: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.CHECK_CALC_INV_EXISTS :'||' (-)');

282: FOR calc_inv_exists_rec IN calc_inv_exists(l_inv_date,p_var_rent_id)LOOP
283: l_dummy := calc_inv_exists_rec.calc_inv;
284: END LOOP;
285: RETURN l_dummy;
286: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.CHECK_CALC_INV_EXISTS :'||' (-)');
287: END check_calc_inv_exists;
288:
289: --------------------------------------------------------------------
290: --

Line 323: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ABTMT_EXISTS :'||' (+)');

319:
320: l_abtmt_exists VARCHAR2(1):=NULL;
321:
322: BEGIN
323: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ABTMT_EXISTS :'||' (+)');
324:
325: OPEN abtmt_exists_cur(p_var_rentId ,p_var_rent_inv_id ,p_pmt_term_id );
326: FETCH abtmt_exists_cur INTO l_abtmt_exists;
327: CLOSE abtmt_exists_cur;

Line 331: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ABTMT_EXISTS :'||' (-)');

327: CLOSE abtmt_exists_cur;
328:
329: RETURN l_abtmt_exists;
330:
331: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ABTMT_EXISTS :'||' (-)');
332: END abtmt_exists;
333: --------------------------------------------------------------------
334: --
335: -- NAME : RESET_UPDATE_FLAG()

Line 585: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_ON_UPD :'||' (-)');

581: END IF;
582:
583: END LOOP;
584:
585: PNP_DEBUG_PKG.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_ON_UPD :'||' (-)');
586:
587: END ROLL_FWD_ON_UPD;
588: --------------------------------------------------------------------
589: --

Line 775: pnp_debug_pkg.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_FST_ON_UPD :'||' (+)');

771:
772: l_org_id NUMBER;
773:
774: BEGIN
775: pnp_debug_pkg.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_FST_ON_UPD :'||' (+)');
776: FOR rec IN org_cur(p_var_rentId) LOOP
777: l_org_id := rec.org_id;
778: END LOOP;
779:

Line 870: pnp_debug_pkg.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_FST_ON_UPD :'||' (-)');

866:
867: END IF;
868:
869: END LOOP;
870: pnp_debug_pkg.debug ('PNXVRENT_ABATEMENTS_CPG.ROLL_FWD_FST_ON_UPD :'||' (-)');
871:
872: END ROLL_FWD_FST_ON_UPD;
873:
874: FUNCTION CHECK_TRUE_UP_INVOICE(p_var_rent_inv_id IN NUMBER)