257: EXCEPTION
258:
259: WHEN NO_DATA_FOUND THEN
260: RETCODE := 2;
261: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INVALID_INSTANCE_ID');
262: FND_MESSAGE.SET_TOKEN('INSTANCE_ID', p_INSTANCE_ID);
263: ERRBUF:= FND_MESSAGE.GET;
264: RETURN;
265: WHEN OTHERS THEN
258:
259: WHEN NO_DATA_FOUND THEN
260: RETCODE := 2;
261: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INVALID_INSTANCE_ID');
262: FND_MESSAGE.SET_TOKEN('INSTANCE_ID', p_INSTANCE_ID);
263: ERRBUF:= FND_MESSAGE.GET;
264: RETURN;
265: WHEN OTHERS THEN
266: RETCODE := 2;
259: WHEN NO_DATA_FOUND THEN
260: RETCODE := 2;
261: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INVALID_INSTANCE_ID');
262: FND_MESSAGE.SET_TOKEN('INSTANCE_ID', p_INSTANCE_ID);
263: ERRBUF:= FND_MESSAGE.GET;
264: RETURN;
265: WHEN OTHERS THEN
266: RETCODE := 2;
267: ERRBUF := SQLERRM;
708: p_token3 varchar2,
709: p_token3_value varchar2) return varchar2 is
710: begin
711:
712: fnd_message.set_name(appcode, string);
713:
714: /* set message tokens */
715: if p_token1 is not null then
716: fnd_message.set_token(p_token1, p_token1_value);
712: fnd_message.set_name(appcode, string);
713:
714: /* set message tokens */
715: if p_token1 is not null then
716: fnd_message.set_token(p_token1, p_token1_value);
717: end if;
718: if p_token2 is not null then
719: fnd_message.set_token(p_token2, p_token2_value);
720: end if;
715: if p_token1 is not null then
716: fnd_message.set_token(p_token1, p_token1_value);
717: end if;
718: if p_token2 is not null then
719: fnd_message.set_token(p_token2, p_token2_value);
720: end if;
721: if p_token3 is not null then
722: fnd_message.set_token(p_token3, p_token3_value);
723: end if;
718: if p_token2 is not null then
719: fnd_message.set_token(p_token2, p_token2_value);
720: end if;
721: if p_token3 is not null then
722: fnd_message.set_token(p_token3, p_token3_value);
723: end if;
724:
725: return fnd_message.get;
726:
721: if p_token3 is not null then
722: fnd_message.set_token(p_token3, p_token3_value);
723: end if;
724:
725: return fnd_message.get;
726:
727: exception
728: when others then
729: return string;