APPS.PN_LEASES_PKG dependencies on PNP_DEBUG_PKG

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

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

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

222: ,x_ATTRIBUTE15 => x_ATTRIBUTE15
223: ,x_org_id => x_org_id
224: );
225:
226: pnp_debug_pkg.debug ('PN_LEASES_PKG.Insert_Row (-)');
227:
228: END Insert_Row;
229:
230:

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

289:
290: tlinfo c1%ROWTYPE;
291:
292: BEGIN
293: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (+)');
294: OPEN c1;
295: FETCH c1 INTO tlinfo;
296: IF (c1%NOTFOUND) THEN
297: CLOSE c1;

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

394: );
395:
396: -- NOTE: We will not check for the lease PN_LEASE_CHANGES table
397:
398: pnp_debug_pkg.debug ('PN_LEASES_PKG.Lock_Row (-)');
399:
400: END Lock_Row;
401:
402:

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

473:
474: l_org_id NUMBER;
475:
476: BEGIN
477: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (+)');
478:
479: /* Check IF lease NUMBER IS unique */
480: FOR rec IN org_cur LOOP
481: l_org_id := rec.org_id;

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

552: location_id = x_location_id,
553: customer_id = x_customer_id
554: WHERE LEASE_ID = X_LEASE_ID;
555:
556: pnp_debug_pkg.debug ('PN_LEASES_PKG.Update_Row (-)');
557:
558: END Update_Row;
559:
560:

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

578: l_leaseDetailId NUMBER := NULL;
579: l_leaseTransactionId NUMBER := NULL;
580: l_leaseChangeId NUMBER := NULL;
581: BEGIN
582: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (+)');
583:
584: SELECT pd.lease_detail_id,
585: pt.lease_transaction_id,
586: pc.lease_change_id

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

610: IF (SQL%NOTFOUND) THEN
611: RAISE NO_DATA_FOUND;
612: END IF;
613:
614: pnp_debug_pkg.debug ('PN_LEASES_PKG.Delete_Row (-)');
615:
616: END Delete_Row;
617:
618: -------------------------------------------------------------------------------

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

629: )
630: IS
631: l_dummy NUMBER;
632: BEGIN
633: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
634:
635: SELECT 1
636: INTO l_dummy
637: FROM DUAL

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

640: WHERE pnl.lease_num = x_lease_number
641: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
642: );
643:
644: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');
645:
646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN
648: fnd_message.set_name ('PN','PN_DUP_LEASE_NUMBER');

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

669: )
670: IS
671: l_dummy NUMBER;
672: BEGIN
673: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
674:
675: SELECT 1
676: INTO l_dummy
677: FROM DUAL

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

681: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
682: AND org_id = x_org_id
683: );
684:
685: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (-)');
686:
687: EXCEPTION
688: WHEN NO_DATA_FOUND THEN
689: fnd_message.set_name ('PN','PN_DUP_LEASE_NUMBER');