DBA Data[Home] [Help]

APPS.PN_REC_EXP_LINE_PKG dependencies on PNP_DEBUG_PKG

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

26: IS
27: l_desc VARCHAR2(100) := 'pn_rec_exp_line_pkg.insert_row';
28: BEGIN
29:
30: pnp_debug_pkg.debug(l_desc ||' (+)');
31:
32: INSERT INTO pn_rec_exp_line_all /*sdm14jul*/
33: (
34: org_id,

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

61: x_created_by,
62: x_last_update_login
63: ) RETURNING expense_line_id, expense_extract_code INTO x_expense_line_id, x_expense_extract_code;
64:
65: pnp_debug_pkg.debug(l_desc ||' (-)');
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

94: IS
95: l_desc VARCHAR2(100) := 'pn_rec_exp_line_pkg.update_row';
96: BEGIN
97:
98: pnp_debug_pkg.debug(l_desc ||' (+)');
99:
100: UPDATE pn_rec_exp_line_all /*sdm_14jul*/
101: SET
102: expense_extract_code = x_expense_extract_code,

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

112: created_by = x_created_by,
113: last_update_login = x_last_update_login
114: WHERE expense_line_id = x_expense_line_id;
115:
116: pnp_debug_pkg.debug(l_desc ||' (-)');
117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

132: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE) IS
133: l_desc VARCHAR2(100) := 'pn_rec_exp_line_pkg.delete_row';
134: BEGIN
135:
136: pnp_debug_pkg.debug(l_desc ||' (+)');
137:
138: DELETE pn_rec_exp_line_all /*sdm14jul*/
139: WHERE expense_line_id = x_expense_line_id;
140:

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

137:
138: DELETE pn_rec_exp_line_all /*sdm14jul*/
139: WHERE expense_line_id = x_expense_line_id;
140:
141: pnp_debug_pkg.debug(l_desc ||' (-)');
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));