DBA Data[Home] [Help]

APPS.PN_REC_EXPCL_DTLACC_PKG dependencies on PNP_DEBUG_PKG

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

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

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

99: x_created_by,
100: x_last_update_login
101: ) RETURNING expense_class_line_dtl_id INTO x_expense_class_line_dtl_id;
102:
103: pnp_debug_pkg.debug(l_desc ||' (-)');
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

137: IS
138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';
139: BEGIN
140:
141: pnp_debug_pkg.debug(l_desc ||' (+)');
142:
143: UPDATE pn_rec_expcl_dtlacc_all
144: SET
145: expense_line_dtl_id = x_expense_line_dtl_id,

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

159: created_by = x_created_by,
160: last_update_login = x_last_update_login
161: WHERE expense_class_line_dtl_id = x_expense_class_line_dtl_id;
162:
163: pnp_debug_pkg.debug(l_desc ||' (-)');
164:
165: EXCEPTION
166: WHEN OTHERS THEN
167: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));

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

180: IS
181: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.delete_row';
182: BEGIN
183:
184: pnp_debug_pkg.debug(l_desc ||' (+)');
185:
186: DELETE pn_rec_expcl_dtlacc_all
187: WHERE expense_class_line_dtl_id = x_expense_class_line_dtl_id;
188:

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

185:
186: DELETE pn_rec_expcl_dtlacc_all
187: WHERE expense_class_line_dtl_id = x_expense_class_line_dtl_id;
188:
189: pnp_debug_pkg.debug(l_desc ||' (-)');
190:
191: EXCEPTION
192: WHEN OTHERS THEN
193: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));