118: PROCEDURE sql_error(p_routine IN VARCHAR2,
119: p_errcode IN NUMBER,
120: p_errmsg IN VARCHAR2) IS
121: BEGIN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', p_routine);
124: fnd_message.set_token('ERRNO', p_errcode);
125: fnd_message.set_token('REASON', p_errmsg);
126: app_exception.raise_exception;
119: p_errcode IN NUMBER,
120: p_errmsg IN VARCHAR2) IS
121: BEGIN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', p_routine);
124: fnd_message.set_token('ERRNO', p_errcode);
125: fnd_message.set_token('REASON', p_errmsg);
126: app_exception.raise_exception;
127: EXCEPTION
120: p_errmsg IN VARCHAR2) IS
121: BEGIN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', p_routine);
124: fnd_message.set_token('ERRNO', p_errcode);
125: fnd_message.set_token('REASON', p_errmsg);
126: app_exception.raise_exception;
127: EXCEPTION
128: WHEN OTHERS THEN RAISE;
121: BEGIN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', p_routine);
124: fnd_message.set_token('ERRNO', p_errcode);
125: fnd_message.set_token('REASON', p_errmsg);
126: app_exception.raise_exception;
127: EXCEPTION
128: WHEN OTHERS THEN RAISE;
129: END;
187: AND (ce_ba.currency_code = p_currency
188: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
189: AND ce_bau.org_id = p_org_id;
190: ELSE
191: FND_MESSAGE.Set_Name('CE', 'CE_INVALID_ORG_TYPE');
192: APP_EXCEPTION.Raise_Exception;
193: END IF;
194:
195: EXCEPTION