APPS.PNT_PROPERTIES_PKG dependencies on PNP_DEBUG_PKG

Line 37: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.check_unique_property_code (+)');

33: AND org_ID = x_org_id;
34:
35: BEGIN
36:
37: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.check_unique_property_code (+)');
38:
39: /* check for duplication */
40: IF x_property_id IS NULL THEN
41: FOR i IN dup_prop_code1 LOOP

Line 50: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.check_unique_property_code (-)');

46: RAISE DUP_PROP_CODE;
47: END LOOP;
48: END IF;
49:
50: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.check_unique_property_code (-)');
51:
52: EXCEPTION
53: WHEN DUP_PROP_CODE THEN
54: fnd_message.set_name ('PN','PN_DUP_PROPERTY_CODE');

Line 120: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.INSERT_ROW (+)');

116: l_return_status VARCHAR2(20) := NULL;
117:
118: BEGIN
119:
120: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.INSERT_ROW (+)');
121:
122: /* Call CHECK_UNIQUE_LOCATION_CODE to check if the property code is unique. */
123: l_return_status := NULL;
124: check_unique_property_code (

Line 230: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.INSERT_ROW(-)');

226: CLOSE properties;
227:
228: END IF;
229:
230: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.INSERT_ROW(-)');
231:
232: END INSERT_ROW;
233:
234: -------------------------------------------------------------------------------

Line 285: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.LOCK_ROW (+)');

281: tlinfo c%ROWTYPE;
282:
283: BEGIN
284:
285: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.LOCK_ROW (+)');
286:
287: OPEN c;
288: FETCH c INTO tlinfo;
289: IF (c%notfound) THEN

Line 439: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.LOCK_ROW (-)');

435: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', tlinfo.attribute15);
436: END IF;
437:
438:
439: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.LOCK_ROW (-)');
440:
441: END LOCK_ROW;
442:
443:

Line 490: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.UPDATE_ROW (+)');

486: IS
487:
488: BEGIN
489:
490: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.UPDATE_ROW (+)');
491:
492: UPDATE PN_PROPERTIES_ALL
493: SET
494: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 532: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.UPDATE_ROW (-)');

528: IF (SQL%NOTFOUND) THEN
529: RAISE NO_DATA_FOUND;
530: END IF;
531:
532: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.UPDATE_ROW (-)');
533:
534: END UPDATE_ROW;
535:
536: END PNT_PROPERTIES_PKG;