APPS.PN_OPTIONS_PKG dependencies on PNP_DEBUG_PKG

Line 67: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (+)');

63: l_org_id NUMBER;
64:
65: BEGIN
66:
67: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (+)');
68:
69: -------------------------------------------------------
70: -- We need to generate the lease change number
71: -------------------------------------------------------

Line 190: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (-)');

186: RAISE NO_DATA_FOUND;
187: END IF;
188: CLOSE c;
189:
190: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (-)');
191:
192: END Insert_Row;
193:
194: -------------------------------------------------------------------------------

Line 248: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (+)');

244: tlinfo c1%ROWTYPE;
245:
246: BEGIN
247:
248: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (+)');
249:
250: OPEN c1;
251: FETCH c1 INTO tlinfo;
252: IF (c1%NOTFOUND) THEN

Line 423: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (-)');

419: OR ((tlinfo.OPTION_COMMENTS IS NULL) AND (X_OPTION_COMMENTS IS NULL))) THEN
420: pn_var_rent_pkg.lock_row_exception('OPTION_COMMENTS',tlinfo.OPTION_COMMENTS);
421: END IF;
422:
423: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (-)');
424:
425: END Lock_Row;
426:
427: -------------------------------------------------------------------------------

Line 485: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (+)');

481: l_optionHistoryId NUMBER := NULL;
482: l_leaseStatus VARCHAR2(30) := NULL;
483:
484: BEGIN
485: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (+)');
486:
487: ----------------------------------------------------
488: -- get the lease status
489: ----------------------------------------------------

Line 646: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (-)');

642: IF (SQL%NOTFOUND) THEN
643: RAISE NO_DATA_FOUND;
644: END IF;
645:
646: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (-)');
647:
648: END Update_Row;
649:
650: -------------------------------------------------------------------------------

Line 664: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (+)');

660: )
661: IS
662: BEGIN
663:
664: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (+)');
665:
666: DELETE FROM pn_options_all
667: WHERE option_id = x_option_id;
668:

Line 673: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (-)');

669: IF (SQL%NOTFOUND) THEN
670: RAISE NO_DATA_FOUND;
671: END IF;
672:
673: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (-)');
674:
675: END Delete_Row;
676:
677: END pn_options_pkg;