APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PNP_DEBUG_PKG

Line 57: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (+)');

53: WHERE BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID;
54:
55: BEGIN
56:
57: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (+)');
58:
59: -------------------------------------------------------
60: -- We need to generate the line number
61: -------------------------------------------------------

Line 135: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');

131: UPDATE pn_var_bkhd_defaults_all
132: SET bkpt_update_flag = 'Y'
133: WHERE bkhd_default_id = x_bkhd_default_id;
134:
135: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');
136:
137: EXCEPTION
138:
139: WHEN OTHERS THEN

Line 140: pnp_debug_pkg.debug(sqlerrm);

136:
137: EXCEPTION
138:
139: WHEN OTHERS THEN
140: pnp_debug_pkg.debug(sqlerrm);
141: RAISE;
142: END INSERT_ROW;
143:
144: -------------------------------------------------------------------------------

Line 189: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (+)');

185: where BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID
186: for update of BKDT_DEFAULT_ID nowait;
187: begin
188:
189: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (+)');
190:
191: for tlinfo in c1 loop
192: /*
193: if ( (tlinfo.BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID)

Line 296: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (-)');

292:
293: end loop;
294: return;
295:
296: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (-)');
297:
298: end LOCK_ROW;
299:
300: -------------------------------------------------------------------------------

Line 344: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');

340: ) IS
341:
342: BEGIN
343:
344: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');
345:
346: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
347: BKDT_DETAIL_NUM = X_BKDT_DETAIL_NUM,
348: BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID,

Line 389: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');

385: UPDATE pn_var_bkhd_defaults_all
386: SET bkpt_update_flag = 'Y'
387: WHERE bkhd_default_id = x_bkhd_default_id;
388:
389: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');
390:
391: END UPDATE_ROW;
392:
393: -----------------------------------------------------------------------

Line 404: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');

400: FROM pn_var_bkdt_defaults_all
401: WHERE bkdt_default_id = x_bkdt_default_id;
402: BEGIN
403:
404: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');
405:
406: FOR rec IN bkhd_default LOOP
407: UPDATE pn_var_bkhd_defaults_all
408: SET bkpt_update_flag = 'Y'

Line 419: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (-)');

415: IF (SQL%NOTFOUND) THEN
416: RAISE NO_DATA_FOUND;
417: END IF;
418:
419: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (-)');
420: END DELETE_ROW;
421:
422:
423: -------------------------------------------------------------------------------

Line 473: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');

469: WHERE bkdt_default_id = x_bkdt_default_id;
470:
471: BEGIN
472:
473: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');
474:
475: FOR rec IN bkdt_defaults_cur LOOP
476: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
477: BKDT_DETAIL_NUM = NVL( x_bkdt_detail_num, rec.bkdt_detail_num),

Line 521: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (-)');

517: WHERE bkhd_default_id = x_bkhd_default_id;
518:
519: END LOOP;
520:
521: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (-)');
522:
523: END MODIFY_ROW;
524:
525: end PN_VAR_BKDT_DEFAULTS_PKG;