55: where UMX.reg_service_code = p_regSrv
56: and UMX.reg_function_id = f.function_id(+);
57: begin
58: if p_regSrv is null then
59: raise_application_error(-20001, FND_MESSAGE.get_string('FND', 'UMX_GENURL_REGSRV_PARAM_NULL'));
60: end if;
61:
62: for i in isRegSrvValid loop
63: if (i.reg_service_type <> 'SELF_SERVICE') then
60: end if;
61:
62: for i in isRegSrvValid loop
63: if (i.reg_service_type <> 'SELF_SERVICE') then
64: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_INVALID_TYPE'));
65: elsif (i.reg_function_id is null) then
66: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_NULL1'));
67: elsif (nvl(i.end_date, sysdate) < sysdate) then
68: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_ENDDATED'));
62: for i in isRegSrvValid loop
63: if (i.reg_service_type <> 'SELF_SERVICE') then
64: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_INVALID_TYPE'));
65: elsif (i.reg_function_id is null) then
66: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_NULL1'));
67: elsif (nvl(i.end_date, sysdate) < sysdate) then
68: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_ENDDATED'));
69: elsif (i.function_id is null) then
70: /*FND_MESSAGE.SET_NAME('FND', 'UMX_GENURL_REGFUNC_INVALID');
64: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_INVALID_TYPE'));
65: elsif (i.reg_function_id is null) then
66: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_NULL1'));
67: elsif (nvl(i.end_date, sysdate) < sysdate) then
68: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_ENDDATED'));
69: elsif (i.function_id is null) then
70: /*FND_MESSAGE.SET_NAME('FND', 'UMX_GENURL_REGFUNC_INVALID');
71: FND_MESSAGE.SET_TOKEN('REG_SRV_CODE', p_regSrv, FALSE);
72: FND_MSG_PUB.ADD;
66: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_NULL1'));
67: elsif (nvl(i.end_date, sysdate) < sysdate) then
68: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_ENDDATED'));
69: elsif (i.function_id is null) then
70: /*FND_MESSAGE.SET_NAME('FND', 'UMX_GENURL_REGFUNC_INVALID');
71: FND_MESSAGE.SET_TOKEN('REG_SRV_CODE', p_regSrv, FALSE);
72: FND_MSG_PUB.ADD;
73: */
74: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_INVALID'));
67: elsif (nvl(i.end_date, sysdate) < sysdate) then
68: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGSRV_ENDDATED'));
69: elsif (i.function_id is null) then
70: /*FND_MESSAGE.SET_NAME('FND', 'UMX_GENURL_REGFUNC_INVALID');
71: FND_MESSAGE.SET_TOKEN('REG_SRV_CODE', p_regSrv, FALSE);
72: FND_MSG_PUB.ADD;
73: */
74: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_INVALID'));
75: end if;
70: /*FND_MESSAGE.SET_NAME('FND', 'UMX_GENURL_REGFUNC_INVALID');
71: FND_MESSAGE.SET_TOKEN('REG_SRV_CODE', p_regSrv, FALSE);
72: FND_MSG_PUB.ADD;
73: */
74: raise_application_error(-20001, fnd_message.get_string('FND','UMX_GENURL_REGFUNC_INVALID'));
75: end if;
76: end loop;
77: return true;
78: end;
234: --l_parameters varchar2(4000);
235: begin
236: /* if p_regSrv is null then
237: -- raise exception
238: FND_MESSAGE.SET_NAME('FND', 'UMX_REQUIRED_FIELD');
239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'UMX_REG_FLOW_PVT.generateRegistrationURL', FALSE);
240: FND_MESSAGE.SET_TOKEN('FIELD', 'Registration Service', FALSE);
241: FND_MSG_PUB.ADD;
242: app_exception.raise_exception;
235: begin
236: /* if p_regSrv is null then
237: -- raise exception
238: FND_MESSAGE.SET_NAME('FND', 'UMX_REQUIRED_FIELD');
239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'UMX_REG_FLOW_PVT.generateRegistrationURL', FALSE);
240: FND_MESSAGE.SET_TOKEN('FIELD', 'Registration Service', FALSE);
241: FND_MSG_PUB.ADD;
242: app_exception.raise_exception;
243: end if;
236: /* if p_regSrv is null then
237: -- raise exception
238: FND_MESSAGE.SET_NAME('FND', 'UMX_REQUIRED_FIELD');
239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'UMX_REG_FLOW_PVT.generateRegistrationURL', FALSE);
240: FND_MESSAGE.SET_TOKEN('FIELD', 'Registration Service', FALSE);
241: FND_MSG_PUB.ADD;
242: app_exception.raise_exception;
243: end if;
244: */