APPS.PN_VAR_CONSTRAINTS_PKG dependencies on PNP_DEBUG_PKG

Line 60: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (+)');

56: l_return_status VARCHAR2(30) := NULL;
57:
58: BEGIN
59:
60: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (+)');
61:
62: -------------------------------------------------------
63: -- We need to generate the constraints number
64: -------------------------------------------------------

Line 179: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (-)');

175: RAISE NO_DATA_FOUND;
176: END IF;
177: CLOSE c;
178:
179: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (-)');
180:
181: END INSERT_ROW;
182:
183: -------------------------------------------------------------------------------

Line 231: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (+)');

227:
228: tlinfo c1%rowtype;
229:
230: BEGIN
231: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (+)');
232:
233: OPEN c1;
234: FETCH c1 INTO tlinfo;
235: IF (c1%notfound) THEN

Line 433: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (-)');

429: else
430: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CONSTR_END_DATE',tlinfo.CONSTR_END_DATE);
431: end if;
432:
433: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (-)');
434:
435: END LOCK_ROW;
436:
437:

Line 485: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

481: l_return_status VARCHAR2(30) := NULL;
482:
483: BEGIN
484:
485: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');
486:
487: -- Check for constraint range
488: l_return_status := NULL;
489:

Line 540: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

536: IF (sql%notfound) THEN
537: RAISE NO_DATA_FOUND;
538: END IF;
539:
540: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');
541:
542: END UPDATE_ROW;
543:
544:

Line 559: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (+)');

555: )
556: IS
557: BEGIN
558:
559: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (+)');
560:
561: DELETE FROM PN_VAR_CONSTRAINTS_ALL
562: WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;
563:

Line 568: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (-)');

564: IF (sql%notfound) THEN
565: RAISE NO_DATA_FOUND;
566: END IF;
567:
568: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (-)');
569:
570: END DELETE_ROW;
571:
572: -------------------------------------------------------------------------------

Line 592: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_MAX_CONSTR (+)');

588: )
589: IS
590: l_dummy NUMBER;
591: BEGIN
592: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_MAX_CONSTR (+)');
593:
594: IF x_type_code = 'MIN' THEN
595:
596: SELECT 1

Line 613: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_MAX_CONSTR (-)');

609: );
610:
611: END IF;
612:
613: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_MAX_CONSTR (-)');
614:
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN
617: fnd_message.set_name ('PN','PN_VAR_WRONG_RANGE');