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);
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);
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:
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.
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
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:
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
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
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||' (-)');
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
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- (-)');
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:
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