DBA Data[Home] [Help]

APPS.JTF_MSITE_RESP_MGR_PVT dependencies on FND_MESSAGE

Line 131: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');

127: x_msg_data => x_msg_data
128: );
129:
130: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
135: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');

Line 135: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');

131: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
135: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
136: FND_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:

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

171: p_encoded => 'F');
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;

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

172:
173: WHEN OTHERS THEN
174: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

173: WHEN OTHERS THEN
174: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181:

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

174: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 263: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');

259: x_msg_data => x_msg_data
260: );
261:
262: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
263: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
267: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');

Line 267: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');

263: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
267: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:

Line 295: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');

291: x_msg_data => x_msg_data
292: );
293:
294: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
295: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');

Line 299: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');

295: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:

Line 549: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_QUERY_CRIT_NULL');

545: -- Based on the query criteria
546: --
547: IF (p_query_criteria IS NULL) THEN
548:
549: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_QUERY_CRIT_NULL');
550: FND_MSG_PUB.Add;
551: RAISE FND_API.G_EXC_ERROR;
552:
553: ELSIF (p_query_criteria = 'NAME') THEN

Line 570: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_QUERY_CRIT');

566: UPPER(l_criteria_value_str) || '''';
567:
568: ELSE
569: -- none of the query criteria specified
570: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_QUERY_CRIT');
571: FND_MESSAGE.Set_Token('QUERY_CRITERIA', p_query_criteria);
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;

Line 571: FND_MESSAGE.Set_Token('QUERY_CRITERIA', p_query_criteria);

567:
568: ELSE
569: -- none of the query criteria specified
570: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_QUERY_CRIT');
571: FND_MESSAGE.Set_Token('QUERY_CRITERIA', p_query_criteria);
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:

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

605: p_data => x_msg_data,
606: p_encoded => 'F');
607:
608: WHEN OTHERS THEN
609: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
610: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
611: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;

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

606: p_encoded => 'F');
607:
608: WHEN OTHERS THEN
609: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
610: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
611: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

607:
608: WHEN OTHERS THEN
609: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
610: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
611: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:

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

608: WHEN OTHERS THEN
609: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
610: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
611: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 675: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_RESPS_SPECIFIED');

671: --
672: -- If there are no responsibilities in the input, then return error
673: --
674: IF (p_responsibility_ids.COUNT <= 0) THEN
675: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_RESPS_SPECIFIED');
676: FND_MSG_PUB.Add;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679:

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

739: p_data => x_msg_data,
740: p_encoded => 'F');
741:
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
744: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
745: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;

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

740: p_encoded => 'F');
741:
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
744: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
745: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

741:
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
744: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
745: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:

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

742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
744: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
745: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)