DBA Data[Home] [Help]

APPS.PN_REC_EXP_LINE_DTL_PKG dependencies on PNP_DEBUG_PKG

Line 65: pnp_debug_pkg.debug(l_desc ||' (+)');

61:
62:
63: BEGIN
64:
65: pnp_debug_pkg.debug(l_desc ||' (+)');
66:
67: IF x_org_id IS NULL THEN
68: FOR rec IN org_cur LOOP
69: l_org_id := rec.org_id;

Line 157: pnp_debug_pkg.debug(l_desc ||' (-)');

153: x_attribute14,
154: x_attribute15
155: ) RETURNING expense_line_dtl_id INTO x_expense_line_dtl_id;
156:
157: pnp_debug_pkg.debug(l_desc ||' (-)');
158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: app_exception.raise_exception;

Line 213: pnp_debug_pkg.debug(l_desc ||' (+)');

209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';
211: BEGIN
212:
213: pnp_debug_pkg.debug(l_desc ||' (+)');
214:
215: UPDATE pn_rec_exp_line_dtl_all
216: SET parent_expense_line_id = x_parent_expense_line_id,
217: location_id = x_location_id,

Line 254: pnp_debug_pkg.debug(l_desc ||' (-)');

250: attribute14 = x_attribute14,
251: attribute15 = x_attribute15
252: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
253:
254: pnp_debug_pkg.debug(l_desc ||' (-)');
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

Line 275: pnp_debug_pkg.debug(l_desc ||' (+)');

271: PROCEDURE delete_row(x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE) IS
272: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.delete_row';
273: BEGIN
274:
275: pnp_debug_pkg.debug(l_desc ||' (+)');
276:
277: DELETE pn_rec_exp_line_dtl_all
278: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
279:

Line 280: pnp_debug_pkg.debug(l_desc ||' (-)');

276:
277: DELETE pn_rec_exp_line_dtl_all
278: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
279:
280: pnp_debug_pkg.debug(l_desc ||' (-)');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));