[Home] [Help]
22: p_additional_info varchar2 default null)
23: as
24: begin
25:
26: fnd_adg_exception.raise_error(fnd_adg_exception.C_MGRERR_RPC_EXEC_ERROR,
27: 'O='||p_rpcDescriptor.owner ||
28: ' P='||p_rpcDescriptor.package_name ||
29: ' RP='||p_rpcDescriptor.rpc_package_name ||
30: ' RS='||p_rpcDescriptor.rpc_synonym_name ||
200: if ( G_SESS_STANDY_TO_PROD_VALID )
201: then
202: return;
203: else
204: p_err := fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK;
205: p_msg := fnd_adg_exception.get_error_msg
206: (fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK);
207: return;
208: end if;
201: then
202: return;
203: else
204: p_err := fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK;
205: p_msg := fnd_adg_exception.get_error_msg
206: (fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK);
207: return;
208: end if;
209: end if;
202: return;
203: else
204: p_err := fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK;
205: p_msg := fnd_adg_exception.get_error_msg
206: (fnd_adg_exception.C_MGRERR_FAILED_PREV_SES_CHK);
207: return;
208: end if;
209: end if;
210: end if;
210: end if;
211:
212: if ( not fnd_adg_support.is_standby )
213: then
214: p_err := fnd_adg_exception.C_MGRERR_NOT_STANDBY;
215: p_msg := fnd_adg_exception.get_error_msg(fnd_adg_exception.C_MGRERR_NOT_STANDBY);
216: G_SESS_STANDY_TO_PROD_VALID := false;
217: return;
218: end if;
211:
212: if ( not fnd_adg_support.is_standby )
213: then
214: p_err := fnd_adg_exception.C_MGRERR_NOT_STANDBY;
215: p_msg := fnd_adg_exception.get_error_msg(fnd_adg_exception.C_MGRERR_NOT_STANDBY);
216: G_SESS_STANDY_TO_PROD_VALID := false;
217: return;
218: end if;
219:
256: if ( l_valid <> 0 )
257: then
258: case l_valid
259: when 1 then
260: p_err := fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY;
261: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
257: then
258: case l_valid
259: when 1 then
260: p_err := fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY;
261: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
258: case l_valid
259: when 1 then
260: p_err := fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY;
261: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
260: p_err := fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY;
261: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
261: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
262: (fnd_adg_exception.C_MGRERR_REMOTE_NOT_PRIMARY);
263: when 2 then
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
264: p_err := fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
265: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
266: (fnd_adg_exception.C_MGRERR_REMOTE_DOESNT_MATCH);
267: when 3 then
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
268: p_err := fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
269: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
277: p_msg := fnd_adg_exception.get_error_msg
270: (fnd_adg_exception.C_MGRERR_REMOTE_IS_LOOPBACK);
271: when -1 then
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
277: p_msg := fnd_adg_exception.get_error_msg
278: (fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR);
272: p_err := fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
277: p_msg := fnd_adg_exception.get_error_msg
278: (fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR);
279: end case;
280: G_SESS_STANDY_TO_PROD_VALID := false;
273: p_msg := fnd_adg_exception.get_error_msg
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
277: p_msg := fnd_adg_exception.get_error_msg
278: (fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR);
279: end case;
280: G_SESS_STANDY_TO_PROD_VALID := false;
281: return;
274: (fnd_adg_exception.C_MGRERR_REMOTE_RESOLVE);
275: else
276: p_err := fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR;
277: p_msg := fnd_adg_exception.get_error_msg
278: (fnd_adg_exception.C_MGRERR_UNKNOWN_REMOTE_ERROR);
279: end case;
280: G_SESS_STANDY_TO_PROD_VALID := false;
281: return;
282: end if;