APPS.PN_VAR_TEMPLATE_PKG dependencies on PNP_DEBUG_PKG

Line 67: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (+)');

63: l_return_status VARCHAR2(30) := NULL;
64:
65: BEGIN
66:
67: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (+)');
68:
69: IF ( X_AGREEMENT_TEMPLATE_ID IS NULL) THEN
70: Select PN_VAR_TEMPLATES_S.nextval
71: into X_AGREEMENT_TEMPLATE_ID

Line 180: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (-)');

176: raise no_data_found;
177: end if;
178: close c;
179:
180: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (-)');
181:
182: end INSERT_ROW;
183:
184:

Line 241: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (+)');

237:
238: tlinfo c1%rowtype;
239:
240: BEGIN
241: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (+)');
242:
243: open c1;
244: fetch c1 into tlinfo;
245: if (c1%notfound) then

Line 538: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (-)');

534: else
535: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
536: end if;
537:
538: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (-)');
539:
540: end LOCK_ROW;
541:
542:

Line 598: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');

594: l_return_status VARCHAR2(30) := NULL;
595:
596: BEGIN
597:
598: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');
599:
600: update PN_VAR_TEMPLATES_ALL set
601: AGREEMENT_TEMPLATE = X_AGREEMENT_TEMPLATE,
602: PURPOSE_CODE = X_PURPOSE_CODE,

Line 649: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');

645: if (sql%notfound) then
646: raise no_data_found;
647: end if;
648:
649: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');
650:
651: end UPDATE_ROW;
652:
653: -----------------------------------------------------------------------

Line 663: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (+)');

659: ) is
660:
661: BEGIN
662:
663: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (+)');
664:
665: delete from PN_VAR_TEMPLATES_ALL
666: where AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID;
667:

Line 672: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (-)');

668: if (sql%notfound) then
669: raise no_data_found;
670: end if;
671:
672: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (-)');
673:
674: END DELETE_ROW;
675:
676: PROCEDURE check_unq_vr_template (