APPS.PNT_COMP_SITE_PKG dependencies on PNP_DEBUG_PKG

Line 26: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.check_unique_company_role (+)');

22: dummy VARCHAR2(30);
23:
24: BEGIN
25:
26: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.check_unique_company_role (+)');
27:
28: SELECT count(1)
29: INTO dummy
30: FROM pn_company_sites_all cs

Line 43: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.check_unique_company_role (-)');

39: APP_EXCEPTION.raise_exception;
40:
41: END IF;
42:
43: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.check_unique_company_role (-)');
44:
45: END check_unique_company_role;
46:
47: -------------------------------------------------------------------------------

Line 176: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (+)');

172: l_org_id NUMBER;
173:
174: BEGIN
175:
176: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (+)');
177:
178: IF x_org_id IS NULL THEN
179: FOR rec IN org_cur LOOP
180: l_org_id := rec.org_id;

Line 322: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (-)');

318: RAISE NO_DATA_FOUND;
319: END IF;
320: CLOSE C;
321:
322: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (-)');
323:
324: END insert_row;
325:
326: -------------------------------------------------------------------------------

Line 395: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (+)');

391: x_addr_attribute15 VARCHAR2
392: ) IS
393: BEGIN
394:
395: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (+)');
396:
397: UPDATE pn_company_sites_all
398: SET
399: last_update_date = x_last_update_date,

Line 482: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (-)');

478: x_addr_attribute14,
479: x_addr_attribute15
480: );
481:
482: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (-)');
483:
484: END update_row;
485:
486: -------------------------------------------------------------------------------

Line 558: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.lock_row (+)');

554:
555:
556: BEGIN
557:
558: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.lock_row (+)');
559:
560: OPEN C;
561: FETCH C INTO Recinfo;
562: IF (C%NOTFOUND) THEN

Line 709: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.lock_row (-)');

705: x_addr_attribute14,
706: x_addr_attribute15
707: );
708:
709: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.lock_row (-)');
710:
711: END lock_row;
712:
713: END PNT_COMP_SITE_PKG;