DBA Data[Home] [Help]

APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_MESSAGE

Line 185: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');

181: p_data => x_msg_data);
182:
183: WHEN l_msite_not_exists_excp THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.count_and_get(
188: p_encoded => FND_API.g_false,
189: p_count => x_msg_count,

Line 194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

190: p_data => x_msg_data );
191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;

Line 195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,

Line 197: FND_MESSAGE.Set_Token('REASON', SQLERRM);

193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data);

Line 294: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');

290: p_data => x_msg_data);
291:
292: WHEN l_msite_not_exists_excp THEN
293: x_return_status := FND_API.g_ret_sts_error;
294: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
295: FND_MSG_PUB.ADD;
296: FND_MSG_PUB.count_and_get(
297: p_encoded => FND_API.g_false,
298: p_count => x_msg_count,

Line 303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

299: p_data => x_msg_data );
300:
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;

Line 304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

300:
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,

Line 306: FND_MESSAGE.Set_Token('REASON', SQLERRM);

302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data);

Line 614: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');

610: p_count => x_msg_count,
611: p_data => x_msg_data );
612: WHEN l_msite_not_exists_excp THEN
613: x_return_status := FND_API.g_ret_sts_error;
614: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
615: FND_MSG_PUB.ADD;
616: FND_MSG_PUB.count_and_get(
617: p_encoded => FND_API.g_false,
618: p_count => x_msg_count,

Line 621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

617: p_encoded => FND_API.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;

Line 622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

618: p_count => x_msg_count,
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(

Line 624: FND_MESSAGE.Set_Token('REASON', SQLERRM);

620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,

Line 684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;

Line 685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

681: p_count => x_msg_count,
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(

Line 687: FND_MESSAGE.Set_Token('REASON', SQLERRM);

683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,

Line 967: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');

963: l_tmp_str := ' ';
964: l_first_idx := x_msite_ids.FIRST;
965:
966: IF (x_msite_ids.COUNT <= 0) THEN
967: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:

Line 1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;

Line 1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1208:
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,

Line 1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);