240:
241: -- Activate/De-Activate Bldg
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:
241: -- Activate/De-Activate Bldg
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
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
253: WHERE ROWID = actdeact_main.row_id;
254: l_rowcount := l_rowcount + 1;
255: END IF;
256:
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);
254: l_rowcount := l_rowcount + 1;
255: END IF;
256:
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:
255: END IF;
256:
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
256:
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:
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||' (-)');