DBA Data[Home] [Help]

APPS.PN_VAR_RENT_INV_PKG dependencies on PNP_DEBUG_PKG

Line 83: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.INSERT_ROW (+)');

79:
80: BEGIN
81:
82:
83: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.INSERT_ROW (+)');
84:
85: -------------------------------------------------------
86: -- We need to generate the var_rent_INv_id
87: -------------------------------------------------------

Line 210: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.INSERT_ROW (-)');

206: RAISE NO_DATA_FOUND;
207: END IF;
208: CLOSE c;
209:
210: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.INSERT_ROW (-)');
211:
212: END INSERT_ROW;
213:
214: -----------------------------------------------------------------------

Line 222: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW_EXCEPTION (+)');

218: procedure lock_row_exception (p_column_name IN varchar2,
219: p_new_value IN varchar2)
220: IS
221: BEGIN
222: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW_EXCEPTION (+)');
223:
224: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
225: fnd_message.set_token ('COLUMN_NAME',p_column_name);
226: fnd_message.set_token ('NEW_VALUE',p_new_value);

Line 229: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW_EXCEPTION (-)');

225: fnd_message.set_token ('COLUMN_NAME',p_column_name);
226: fnd_message.set_token ('NEW_VALUE',p_new_value);
227: app_exception.RAISE_exception;
228:
229: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW_EXCEPTION (-)');
230: END lock_row_exception;
231:
232:
233: -------------------------------------------------------------------------------

Line 292: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW (+)');

288:
289: tlINfo c1%ROWTYPE;
290:
291: BEGIN
292: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW (+)');
293:
294: OPEN c1;
295: FETCH c1 INTO tlINfo;
296: IF (c1%NOTFOUND) THEN

Line 571: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW (-)');

567: END IF;
568:
569:
570:
571: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.LOCK_ROW (-)');
572:
573: END LOCK_ROW;
574:
575:

Line 633: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (+)');

629: l_precision NUMBER;
630:
631: BEGIN
632:
633: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (+)');
634:
635: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(),4);
636:
637: UPDATE PN_VAR_RENT_INV_ALL SET

Line 683: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (-)');

679: IF (SQL%NOTFOUND) THEN
680: RAISE NO_DATA_FOUND;
681: END IF;
682:
683: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (-)');
684:
685: END UPDATE_ROW;
686:
687:

Line 700: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.DELETE_ROW (+)');

696: X_VAR_RENT_INV_ID IN NUMBER
697: ) IS
698: BEGIN
699:
700: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.DELETE_ROW (+)');
701:
702: DELETE FROM PN_VAR_RENT_INV_ALL
703: WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID;
704:

Line 709: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.DELETE_ROW (-)');

705: IF (SQL%NOTFOUND) THEN
706: RAISE NO_DATA_FOUND;
707: END IF;
708:
709: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.DELETE_ROW (-)');
710:
711:
712: END DELETE_ROW;
713: