DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT dependencies on FND_MESSAGE

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

215:
216: WHEN OTHERS THEN
217:
218:
219: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
220: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

216: WHEN OTHERS THEN
217:
218:
219: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
220: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Add;

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

217:
218:
219: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
220: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Add;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 350: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_EXISTS');

346: IBE_UTIL.debug('Inside find_organization - x_org_num : '||p_org_num);
347: IBE_UTIL.debug('Inside find_organization - x_org_name : '||p_org_name);
348: END IF;
349:
350: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_EXISTS');
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: end if;
354: else

Line 408: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_NOT_FOUND');

404: IBE_UTIL.debug('Inside NOT find_organization - x_org_num :'||p_org_num);
405: IBE_UTIL.debug('Inside NOT find_organization - x_org_name : '||p_org_name);
406: END IF;
407: /* If organization does not exist then raise error */
408: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_NOT_FOUND');
409: FND_MSG_PUB.ADD;
410: RAISE FND_API.G_EXC_ERROR;
411: end if;
412:

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

556:
557: WHEN OTHERS THEN
558:
559:
560: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
561: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

557: WHEN OTHERS THEN
558:
559:
560: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
561: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Add;

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

558:
559:
560: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
561: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Add;
566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

826:
827: WHEN OTHERS THEN
828:
829:
830: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

827: WHEN OTHERS THEN
828:
829:
830: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: FND_MSG_PUB.Add;

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

828:
829:
830: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: FND_MSG_PUB.Add;
836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1065:
1066: WHEN OTHERS THEN
1067:
1068:
1069: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1070: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1066: WHEN OTHERS THEN
1067:
1068:
1069: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1070: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Add;

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

1067:
1068:
1069: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1070: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Add;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1367:
1368: WHEN OTHERS THEN
1369:
1370:
1371: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1368: WHEN OTHERS THEN
1369:
1370:
1371: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Add;

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

1369:
1370:
1371: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Add;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1615:
1616: WHEN OTHERS THEN
1617:
1618:
1619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1620: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1616: WHEN OTHERS THEN
1617:
1618:
1619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1620: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: FND_MSG_PUB.Add;

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

1617:
1618:
1619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1620: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: FND_MSG_PUB.Add;
1625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2184:
2185: WHEN OTHERS THEN
2186:
2187:
2188: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2189: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2185: WHEN OTHERS THEN
2186:
2187:
2188: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2189: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Add;

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

2186:
2187:
2188: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2189: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Add;
2194: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2547: WHEN OTHERS THEN
2548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2549: IBE_UTIL.debug('Other Exception');
2550: END IF;
2551: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2552: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2549: IBE_UTIL.debug('Other Exception');
2550: END IF;
2551: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2552: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Add;

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

2549: IBE_UTIL.debug('Other Exception');
2550: END IF;
2551: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2552: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Add;
2557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

3687:
3688: WHEN OTHERS THEN
3689:
3690:
3691: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3692: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3688: WHEN OTHERS THEN
3689:
3690:
3691: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3692: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696: FND_MSG_PUB.Add;

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

3689:
3690:
3691: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3692: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696: FND_MSG_PUB.Add;
3697: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,