eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_LOC_STATUS_CHANGE_PKG dependencies on PNP_DEBUG_PKG

Line 189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');

185: l_rowcount NUMBER;
186:
187: BEGIN
188:
189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);

Line 190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');

186:
187: BEGIN
188:
189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);
194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);

Line 191: pnp_debug_pkg.log('Action : '||p_action);

187: BEGIN
188:
189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);
194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);
195:

Line 192: pnp_debug_pkg.log('Location Type : '||p_loc_type);

188:
189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);
194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);
195:
196: -- Check Valid P_ACTION.

Line 193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);

189: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);
194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);
195:
196: -- Check Valid P_ACTION.
197: IF p_action IN ('ACTIVATE', 'DEACTIVATE') THEN

Line 194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);

190: pnp_debug_pkg.log('Activate_DeAct_Location : -Start- (+)');
191: pnp_debug_pkg.log('Action : '||p_action);
192: pnp_debug_pkg.log('Location Type : '||p_loc_type);
193: pnp_debug_pkg.log('Location Code Low : '||p_loc_code_low);
194: pnp_debug_pkg.log('Location Code High : '||p_loc_code_high);
195:
196: -- Check Valid P_ACTION.
197: IF p_action IN ('ACTIVATE', 'DEACTIVATE') THEN
198:

Line 214: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (+)');

210:
211: l_rowcount := 0;
212: l_loc_active_status := 'N';
213: l_loc := actdeact_main.location_code||' ('||actdeact_main.location_type_Lookup_code||')';
214: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (+)');
215:
216: -- Check Main Loc has Active assignments.
217: IF p_action = 'DEACTIVATE' AND
218: (pnp_util_func.get_space_assigned_status(actdeact_main.location_id, actdeact_main.active_start_date)) THEN

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

242: IF l_loc_active_status = 'Y' THEN
243:
244: fnd_message.set_name ('PN','PN_LOCST_MAIN');
245: fnd_message.set_token ('LOC_CODE', l_loc);
246: pnp_debug_pkg.put_log_msg(fnd_message.get);
247:
248:
249: ELSE
250: IF actdeact_main.status <> l_loc_status THEN

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

257: fnd_message.set_name ('PN','PN_LOCST_PROC_ROWS ');
258: fnd_message.set_token ('ACTION', p_action);
259: fnd_message.set_token ('NUM', l_rowcount);
260: fnd_message.set_token ('LOC_CODE', l_loc);
261: pnp_debug_pkg.put_log_msg(fnd_message.get);
262:
263: END IF; -- End Activate/De-Activate Bldg
264:
265: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (-)');

Line 265: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (-)');

261: pnp_debug_pkg.put_log_msg(fnd_message.get);
262:
263: END IF; -- End Activate/De-Activate Bldg
264:
265: pnp_debug_pkg.log(p_action||' Main Location: '||l_loc||' (-)');
266:
267: END LOOP; -- End Main Loc Loop
268:
269: ELSE

Line 270: pnp_debug_pkg.log('Error, Invalid Action passed: '||p_action);

266:
267: END LOOP; -- End Main Loc Loop
268:
269: ELSE
270: pnp_debug_pkg.log('Error, Invalid Action passed: '||p_action);
271:
272: END IF; -- End Check Valid P_ACTION.
273:
274: pnp_debug_pkg.log('Activate_DeAct_Location : -End- (-)');

Line 274: pnp_debug_pkg.log('Activate_DeAct_Location : -End- (-)');

270: pnp_debug_pkg.log('Error, Invalid Action passed: '||p_action);
271:
272: END IF; -- End Check Valid P_ACTION.
273:
274: pnp_debug_pkg.log('Activate_DeAct_Location : -End- (-)');
275: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
276:
277: EXCEPTION
278:

Line 275: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');

271:
272: END IF; -- End Check Valid P_ACTION.
273:
274: pnp_debug_pkg.log('Activate_DeAct_Location : -End- (-)');
275: pnp_debug_pkg.put_log_msg('+---------------------------------------------------------------------------+');
276:
277: EXCEPTION
278:
279: WHEN OTHERS THEN