DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_MESSAGE

Line 149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');

145: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
146: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
147: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
148:
149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
150: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
151: fnd_message.set_token('SQLCODE', l_ora_err_code);
152: fnd_message.set_token('SQLERRM', l_ora_err_msg);
153: FND_MSG_PUB.ADD;

Line 150: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);

146: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
147: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
148:
149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
150: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
151: fnd_message.set_token('SQLCODE', l_ora_err_code);
152: fnd_message.set_token('SQLERRM', l_ora_err_msg);
153: FND_MSG_PUB.ADD;
154:

Line 151: fnd_message.set_token('SQLCODE', l_ora_err_code);

147: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
148:
149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
150: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
151: fnd_message.set_token('SQLCODE', l_ora_err_code);
152: fnd_message.set_token('SQLERRM', l_ora_err_msg);
153: FND_MSG_PUB.ADD;
154:
155: END IF;

Line 152: fnd_message.set_token('SQLERRM', l_ora_err_msg);

148:
149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
150: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
151: fnd_message.set_token('SQLCODE', l_ora_err_code);
152: fnd_message.set_token('SQLERRM', l_ora_err_msg);
153: FND_MSG_PUB.ADD;
154:
155: END IF;
156:

Line 207: FND_MESSAGE.SET_NAME('IBY',l_err_code);

203: IF (l_ibycode_end < 1) THEN
204: l_ibycode_end := l_msg_len;
205: END IF;
206: l_err_code := SUBSTR(p_err_msg,l_ibycode_start,l_ibycode_end-l_ibycode_start+1);
207: FND_MESSAGE.SET_NAME('IBY',l_err_code);
208:
209: -- +1 to go the position of the token concatenator; +1 again to
210: -- to go past it to the beginning of the token name
211: --

Line 242: FND_MESSAGE.SET_TOKEN(l_token_name,l_token_val);

238: END IF;
239:
240: l_token_name := SUBSTR(p_err_msg,l_index,(l_val_concat-1)-l_index+1);
241: l_token_val := SUBSTR(p_err_msg,l_val_concat+1,(l_tok_concat-1)-(l_val_concat+1)+1);
242: FND_MESSAGE.SET_TOKEN(l_token_name,l_token_val);
243: --
244: -- go +1 character past the token concatenator
245: --
246: l_index := l_tok_concat + 1;

Line 254: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');

250: -- no IBY message found; simply put the exact text of
251: -- the exception into the FND_MSG stack
252: --
253: ELSE
254: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
255: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT',p_err_msg);
256: FND_MSG_PUB.ADD;
257: END IF;
258: END handleException;

Line 255: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT',p_err_msg);

251: -- the exception into the FND_MSG stack
252: --
253: ELSE
254: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
255: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT',p_err_msg);
256: FND_MSG_PUB.ADD;
257: END IF;
258: END handleException;
259: