DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_MESSAGE

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

134: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
135: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
136: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
137:
138: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
139: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
140: fnd_message.set_token('SQLCODE', l_ora_err_code);
141: fnd_message.set_token('SQLERRM', l_ora_err_msg);
142: FND_MSG_PUB.ADD;

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

135: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
136: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
137:
138: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
139: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
140: fnd_message.set_token('SQLCODE', l_ora_err_code);
141: fnd_message.set_token('SQLERRM', l_ora_err_msg);
142: FND_MSG_PUB.ADD;
143:

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

136: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
137:
138: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
139: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
140: fnd_message.set_token('SQLCODE', l_ora_err_code);
141: fnd_message.set_token('SQLERRM', l_ora_err_msg);
142: FND_MSG_PUB.ADD;
143:
144: END IF;

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

137:
138: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');
139: fnd_message.set_token('API', p_pkg_name || '.' || p_api_name);
140: fnd_message.set_token('SQLCODE', l_ora_err_code);
141: fnd_message.set_token('SQLERRM', l_ora_err_msg);
142: FND_MSG_PUB.ADD;
143:
144: END IF;
145:

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

192: IF (l_ibycode_end < 1) THEN
193: l_ibycode_end := l_msg_len;
194: END IF;
195: l_err_code := SUBSTR(p_err_msg,l_ibycode_start,l_ibycode_end-l_ibycode_start+1);
196: FND_MESSAGE.SET_NAME('IBY',l_err_code);
197:
198: -- +1 to go the position of the token concatenator; +1 again to
199: -- to go past it to the beginning of the token name
200: --

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

227: END IF;
228:
229: l_token_name := SUBSTR(p_err_msg,l_index,(l_val_concat-1)-l_index+1);
230: l_token_val := SUBSTR(p_err_msg,l_val_concat+1,(l_tok_concat-1)-(l_val_concat+1)+1);
231: FND_MESSAGE.SET_TOKEN(l_token_name,l_token_val);
232: --
233: -- go +1 character past the token concatenator
234: --
235: l_index := l_tok_concat + 1;

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

239: -- no IBY message found; simply put the exact text of
240: -- the exception into the FND_MSG stack
241: --
242: ELSE
243: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
244: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT',p_err_msg);
245: FND_MSG_PUB.ADD;
246: END IF;
247: END handleException;

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

240: -- the exception into the FND_MSG stack
241: --
242: ELSE
243: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
244: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT',p_err_msg);
245: FND_MSG_PUB.ADD;
246: END IF;
247: END handleException;
248: