598: errcode in number,
599: errmsg in varchar2) is
600: l_msg varchar2(2000);
601: begin
602: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
603: fnd_message.set_token('ROUTINE', routine);
604: fnd_message.set_token('ERRNO', errcode);
605: fnd_message.set_token('REASON', errmsg);
606: fnd_message.raise_error;
599: errmsg in varchar2) is
600: l_msg varchar2(2000);
601: begin
602: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
603: fnd_message.set_token('ROUTINE', routine);
604: fnd_message.set_token('ERRNO', errcode);
605: fnd_message.set_token('REASON', errmsg);
606: fnd_message.raise_error;
607: end;
600: l_msg varchar2(2000);
601: begin
602: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
603: fnd_message.set_token('ROUTINE', routine);
604: fnd_message.set_token('ERRNO', errcode);
605: fnd_message.set_token('REASON', errmsg);
606: fnd_message.raise_error;
607: end;
608:
601: begin
602: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
603: fnd_message.set_token('ROUTINE', routine);
604: fnd_message.set_token('ERRNO', errcode);
605: fnd_message.set_token('REASON', errmsg);
606: fnd_message.raise_error;
607: end;
608:
609: -- Purpose
602: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
603: fnd_message.set_token('ROUTINE', routine);
604: fnd_message.set_token('ERRNO', errcode);
605: fnd_message.set_token('REASON', errmsg);
606: fnd_message.raise_error;
607: end;
608:
609: -- Purpose
610: --
653: Close C_Sel1;
654: --
655: -- The topic key is invalid therefore we must error
656: --
657: fnd_message.set_name('PER', 'PER_449104_EXT_APP_TPCI_INVL');
658: fnd_message.set_token('TOPIC', p_topic);
659: displayError(fnd_message.get());
660: return;
661: End If;
654: --
655: -- The topic key is invalid therefore we must error
656: --
657: fnd_message.set_name('PER', 'PER_449104_EXT_APP_TPCI_INVL');
658: fnd_message.set_token('TOPIC', p_topic);
659: displayError(fnd_message.get());
660: return;
661: End If;
662: Close C_Sel1;
655: -- The topic key is invalid therefore we must error
656: --
657: fnd_message.set_name('PER', 'PER_449104_EXT_APP_TPCI_INVL');
658: fnd_message.set_token('TOPIC', p_topic);
659: displayError(fnd_message.get());
660: return;
661: End If;
662: Close C_Sel1;
663:
667: Close C_Sel2;
668: --
669: -- The provider_key is invalid therefore we must error
670: --
671: fnd_message.set_token('PROVIDER', p_provider);
672: fnd_message.set_name('PER', 'PER_449105_EXT_APP_PRV_INVL');
673: displayError(fnd_message.get());
674: return;
675: End If;
668: --
669: -- The provider_key is invalid therefore we must error
670: --
671: fnd_message.set_token('PROVIDER', p_provider);
672: fnd_message.set_name('PER', 'PER_449105_EXT_APP_PRV_INVL');
673: displayError(fnd_message.get());
674: return;
675: End If;
676: Close C_Sel2;
669: -- The provider_key is invalid therefore we must error
670: --
671: fnd_message.set_token('PROVIDER', p_provider);
672: fnd_message.set_name('PER', 'PER_449105_EXT_APP_PRV_INVL');
673: displayError(fnd_message.get());
674: return;
675: End If;
676: Close C_Sel2;
677: