APPS.PN_VAR_BKPTS_DET_PKG dependencies on PNP_DEBUG_PKG

Line 63: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (+)');

59: l_return_status VARCHAR2(30) := NULL;
60:
61: BEGIN
62:
63: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (+)');
64:
65: -------------------------------------------------------
66: -- We need to generate the breakpoints details number
67: -------------------------------------------------------

Line 193: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (-)');

189: FROM pn_var_bkpts_head_all
190: WHERE bkpt_header_id = x_bkpt_header_id);
191: END IF;
192:
193: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (-)');
194:
195: END INSERT_ROW;
196:
197: -------------------------------------------------------------------------------

Line 248: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (+)');

244: tlinfo c1%rowtype;
245:
246: BEGIN
247:
248: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (+)');
249:
250: OPEN c1;
251: FETCH c1 into tlinfo;
252: IF (c1%notfound) then

Line 437: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (-)');

433: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
434: end if;
435: --03-NOV-2003 End
436:
437: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (-)');
438:
439: END LOCK_ROW;
440:
441: -------------------------------------------------------------------------------

Line 489: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');

485: l_return_status VARCHAR2(30) := NULL;
486:
487: BEGIN
488:
489: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
490:
491: -- Check for breakpoint volume ranges
492: l_return_status := NULL;
493: /*PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START

Line 550: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');

546: WHERE line_item_id IN (SELECT line_item_id
547: FROM pn_var_bkpts_head_all
548: WHERE bkpt_header_id = x_bkpt_header_id);
549:
550: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
551:
552: END UPDATE_ROW;
553:
554: -------------------------------------------------------------------------------

Line 573: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (+)');

569: WHERE bkpt_detail_id = x_bkpt_detail_id);
570:
571: BEGIN
572:
573: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (+)');
574:
575: FOR rec IN line_item_cur LOOP
576: UPDATE pn_var_lines_all
577: SET bkpt_update_flag = 'Y'

Line 588: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (-)');

584: IF (SQL%NOTFOUND) THEN
585: RAISE NO_DATA_FOUND;
586: END IF;
587:
588: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (-)');
589:
590: END DELETE_ROW;
591:
592: -------------------------------------------------------------------------------

Line 609: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_VOL_START (+)');

605: )
606: IS
607: l_dummy NUMBER;
608: BEGIN
609: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_VOL_START (+)');
610:
611: SELECT 1
612: INTO l_dummy
613: FROM dual

Line 624: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_VOL_START (-)');

620: (bkd.bkpt_detail_id <> x_bkpt_detail_id))
621: AND bkd.bkpt_header_id = x_bkpt_header_id
622: );
623:
624: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.CHECK_VOL_START (-)');
625:
626: EXCEPTION
627: when NO_DATA_FOUND then
628: fnd_message.set_name ('PN','PN_VAR_WRONG_RANGE');