APPS.PN_LEASE_DETAILS_SEND_UPD dependencies on PNP_DEBUG_PKG

Line 72: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.UPDATE_LEASE_SE (+)');

68: AND lease_class_code = NVL(p_lease_class,lease_class_code)
69: AND l.status = 'F'
70: AND d.send_entries = 'Y';
71: BEGIN
72: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.UPDATE_LEASE_SE (+)');
73:
74: -- Get from dirname from db later,
75: -- and use sequence for unique filenames
76: fnd_file.put_names('PNUPLEDB.log', 'PNUPLEDB.out', '/sqlcom/out');

Line 123: pnp_debug_pkg.put_log_msg(fnd_message.get);

119: fnd_message.set_name ('PN','PN_UPLED_LS_DTLS');
120: fnd_message.set_token ('ID',v_lease.lease_id);
121: fnd_message.set_token ('NUM',v_lease.lease_num);
122: fnd_message.set_token ('CLASS',v_lease.lease_class_code);
123: pnp_debug_pkg.put_log_msg(fnd_message.get);
124: pnp_debug_pkg.put_log_msg (' ');
125:
126: s_count := s_count + 1;
127: IF v_counter = v_batch_size THEN

Line 124: pnp_debug_pkg.put_log_msg (' ');

120: fnd_message.set_token ('ID',v_lease.lease_id);
121: fnd_message.set_token ('NUM',v_lease.lease_num);
122: fnd_message.set_token ('CLASS',v_lease.lease_class_code);
123: pnp_debug_pkg.put_log_msg(fnd_message.get);
124: pnp_debug_pkg.put_log_msg (' ');
125:
126: s_count := s_count + 1;
127: IF v_counter = v_batch_size THEN
128: COMMIT;

Line 134: pnp_debug_pkg.put_log_msg('

130: END IF;
131: END LOOP;
132: COMMIT;
133:
134: pnp_debug_pkg.put_log_msg('
135: ================================================================================');
136: fnd_message.set_name ('PN','PN_UPLED_PROC');
137: fnd_message.set_token ('NUM',s_count);
138: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 138: pnp_debug_pkg.put_log_msg(fnd_message.get);

134: pnp_debug_pkg.put_log_msg('
135: ================================================================================');
136: fnd_message.set_name ('PN','PN_UPLED_PROC');
137: fnd_message.set_token ('NUM',s_count);
138: pnp_debug_pkg.put_log_msg(fnd_message.get);
139: pnp_debug_pkg.put_log_msg('
140: ================================================================================');
141: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.update_lease_se (-)');
142: EXCEPTION

Line 139: pnp_debug_pkg.put_log_msg('

135: ================================================================================');
136: fnd_message.set_name ('PN','PN_UPLED_PROC');
137: fnd_message.set_token ('NUM',s_count);
138: pnp_debug_pkg.put_log_msg(fnd_message.get);
139: pnp_debug_pkg.put_log_msg('
140: ================================================================================');
141: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.update_lease_se (-)');
142: EXCEPTION
143: WHEN OTHERS THEN

Line 141: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.update_lease_se (-)');

137: fnd_message.set_token ('NUM',s_count);
138: pnp_debug_pkg.put_log_msg(fnd_message.get);
139: pnp_debug_pkg.put_log_msg('
140: ================================================================================');
141: pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.update_lease_se (-)');
142: EXCEPTION
143: WHEN OTHERS THEN
144: raise_application_error ('-20001','Error ' || TO_CHAR(sqlcode) );
145: Errbuf := SQLERRM;