140: close csr_fnd_install_processes;
141: --
142: if l_flag_stop_process and l_flag_install_process then
143: if NOT l_flag_offline then
144: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'OFFLINE');
145: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'OFFLINE');
146: l_flag_offline := true;
147: l_flag_online := false;
148: end if;
141: --
142: if l_flag_stop_process and l_flag_install_process then
143: if NOT l_flag_offline then
144: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'OFFLINE');
145: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'OFFLINE');
146: l_flag_offline := true;
147: l_flag_online := false;
148: end if;
149: else
147: l_flag_online := false;
148: end if;
149: else
150: if NOT l_flag_online then
151: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'NONE');
152: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'NONE');
153: l_flag_online := true;
154: l_flag_offline := false;
155: end if;
148: end if;
149: else
150: if NOT l_flag_online then
151: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'NONE');
152: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'NONE');
153: l_flag_online := true;
154: l_flag_offline := false;
155: end if;
156: end if;
173: --
174:
175: EXCEPTION
176: WHEN NO_SUCH_TABLE OR INVALID_SYNONYM_INVALID THEN
177: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'NONE');
178: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'NONE');
179: commit;
180: WHEN OTHERS THEN
181: ERRBUF := sqlerrm;
174:
175: EXCEPTION
176: WHEN NO_SUCH_TABLE OR INVALID_SYNONYM_INVALID THEN
177: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PER_%', 'NONE');
178: FND_FORM_FUNCTIONS_PKG.SET_FUNCTION_MODE('PAY_%', 'NONE');
179: commit;
180: WHEN OTHERS THEN
181: ERRBUF := sqlerrm;
182: RETCODE := sqlcode;