APPS.PN_LEASES_PKG dependencies on PNP_DEBUG_PKG

Line 78: pnp_debug_pkg.debug ('PN_LEASES_PKG.Insert_Row (+)');

74: l_leaseDetailId NUMBER := NULL;
75: l_leaseChangeNumber NUMBER := NULL;
76:
77: BEGIN
78: pnp_debug_pkg.debug ('PN_LEASES_PKG.Insert_Row (+)');
79:
80: -- Check IF lease NUMBER IS unique
81: l_return_status := NULL;
82: pn_leases_pkg.check_unique_lease_number(l_return_status,

Line 229: pnp_debug_pkg.debug ('PN_LEASES_PKG.Insert_Row (-)');

225: ,x_ATTRIBUTE15 => x_ATTRIBUTE15
226: ,x_org_id => x_org_id
227: );
228:
229: pnp_debug_pkg.debug ('PN_LEASES_PKG.Insert_Row (-)');
230:
231: END Insert_Row;
232:
233:

Line 297: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (+)');

293:
294: tlinfo c1%ROWTYPE;
295:
296: BEGIN
297: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (+)');
298: OPEN c1;
299: FETCH c1 INTO tlinfo;
300: IF (c1%NOTFOUND) THEN
301: CLOSE c1;

Line 407: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (-)');

403: );
404:
405: -- NOTE: We will not check for the lease PN_LEASE_CHANGES table
406:
407: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (-)');
408:
409: END Lock_Row;
410:
411:

Line 487: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (+)');

483:
484: l_org_id NUMBER;
485:
486: BEGIN
487: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (+)');
488:
489: /* Check IF lease NUMBER IS unique */
490: FOR rec IN org_cur LOOP
491: l_org_id := rec.org_id;

Line 567: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (-)');

563: customer_id = x_customer_id,
564: cal_start = x_calendar_year_start_date
565: WHERE LEASE_ID = X_LEASE_ID;
566:
567: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (-)');
568:
569: END Update_Row;
570:
571:

Line 593: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (+)');

589: l_leaseDetailId NUMBER := NULL;
590: l_leaseTransactionId NUMBER := NULL;
591: l_leaseChangeId NUMBER := NULL;
592: BEGIN
593: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (+)');
594:
595: SELECT pd.lease_detail_id,
596: pt.lease_transaction_id,
597: pc.lease_change_id

Line 625: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (-)');

621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;
623: END IF;
624:
625: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (-)');
626:
627: END Delete_Row;
628:
629: -------------------------------------------------------------------------------

Line 644: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');

640: )
641: IS
642: l_dummy NUMBER;
643: BEGIN
644: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
645:
646: SELECT 1
647: INTO l_dummy
648: FROM DUAL

Line 655: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');

651: WHERE pnl.lease_num = x_lease_number
652: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
653: );
654:
655: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');
656:
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: fnd_message.set_name ('PN','PN_DUP_LEASE_NUMBER');

Line 684: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');

680: )
681: IS
682: l_dummy NUMBER;
683: BEGIN
684: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
685:
686: SELECT 1
687: INTO l_dummy
688: FROM DUAL

Line 696: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');

692: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
693: AND org_id = x_org_id
694: );
695:
696: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');
697:
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN
700: fnd_message.set_name ('PN','PN_DUP_LEASE_NUMBER');