DBA Data[Home] [Help]

APPS.PN_REC_EXPCL_DTLLN_PKG dependencies on PNP_DEBUG_PKG

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

45:
46:
47: BEGIN
48:
49: pnp_debug_pkg.debug(l_desc ||' (+)');
50:
51: IF x_org_id IS NULL THEN
52: FOR rec IN org_cur LOOP
53: l_org_id := rec.org_id;

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

106: x_created_by,
107: x_last_update_login
108: ) RETURNING expense_class_line_id INTO x_expense_class_line_id;
109:
110: pnp_debug_pkg.debug(l_desc ||' (-)');
111:
112: EXCEPTION
113: WHEN OTHERS THEN
114: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

147: IS
148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';
149: BEGIN
150:
151: pnp_debug_pkg.debug(l_desc ||' (+)');
152:
153: UPDATE pn_rec_expcl_dtlln_all
154: SET
155: expense_class_line_id = x_expense_class_line_id,

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

174: created_by = x_created_by,
175: last_update_login = x_last_update_login
176: WHERE expense_class_line_id = x_expense_class_line_id;
177:
178: pnp_debug_pkg.debug(l_desc ||' (-)');
179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

194: IS
195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';
196: BEGIN
197:
198: pnp_debug_pkg.debug(l_desc ||' (+)');
199:
200: DELETE pn_rec_expcl_dtlln_all /*sdm14jul*/
201: WHERE expense_class_line_id = x_expense_class_line_id;
202:

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

199:
200: DELETE pn_rec_expcl_dtlln_all /*sdm14jul*/
201: WHERE expense_class_line_id = x_expense_class_line_id;
202:
203: pnp_debug_pkg.debug(l_desc ||' (-)');
204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));