DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PUB dependencies on FND_MSG_PUB

Line 67: FND_MSG_PUB.Initialize;

63: SAVEPOINT Workorder_Login_Pub;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE
66: IF FND_API.To_Boolean(p_init_msg_list) THEN
67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: -- Initialize Procedure return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: FND_MSG_PUB.Count_And_Get

102: COMMIT WORK;
103: END IF;
104:
105: -- Standard call to get message count and if count is 1, get message info
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,
108: p_data => x_msg_data,
109: p_encoded => fnd_api.g_false
110: );

Line 124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: Rollback to Workorder_Login_Pub;
124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
125: p_data => x_msg_data,
126: p_encoded => fnd_api.g_false);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 131: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: Rollback to Workorder_Login_Pub;
131: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
132: p_data => x_msg_data,
133: p_encoded => fnd_api.g_false);
134:
135: WHEN OTHERS THEN

Line 139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: Rollback to Workorder_Login_Pub;
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
140: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
141: p_procedure_name => 'Workorder_Login',
142: p_error_text => SUBSTR(SQLERRM,1,240));
143: END IF;

Line 140: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: Rollback to Workorder_Login_Pub;
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
140: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
141: p_procedure_name => 'Workorder_Login',
142: p_error_text => SUBSTR(SQLERRM,1,240));
143: END IF;
144: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 144: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

140: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
141: p_procedure_name => 'Workorder_Login',
142: p_error_text => SUBSTR(SQLERRM,1,240));
143: END IF;
144: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
145: p_data => x_msg_data,
146: p_encoded => fnd_api.g_false);
147:
148:

Line 207: FND_MSG_PUB.Initialize;

203: SAVEPOINT Workorder_Logout_Pub;
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE
206: IF FND_API.To_Boolean(p_init_msg_list) THEN
207: FND_MSG_PUB.Initialize;
208: END IF;
209:
210: -- Initialize Procedure return status to success
211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 245: FND_MSG_PUB.Count_And_Get

241: COMMIT WORK;
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count,
247: p_data => x_msg_data,
248: p_encoded => fnd_api.g_false
249: );

Line 262: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: Rollback to Workorder_Logout_Pub;
262: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => fnd_api.g_false);
265:
266:

Line 270: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: Rollback to Workorder_Logout_Pub;
270: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => fnd_api.g_false);
273:
274: WHEN OTHERS THEN

Line 278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

274: WHEN OTHERS THEN
275:
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: Rollback to Workorder_Logout_Pub;
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
279: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
280: p_procedure_name => 'Workorder_Logout',
281: p_error_text => SUBSTR(SQLERRM,1,240));
282: END IF;

Line 279: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

275:
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: Rollback to Workorder_Logout_Pub;
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
279: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
280: p_procedure_name => 'Workorder_Logout',
281: p_error_text => SUBSTR(SQLERRM,1,240));
282: END IF;
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

279: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
280: p_procedure_name => 'Workorder_Logout',
281: p_error_text => SUBSTR(SQLERRM,1,240));
282: END IF;
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
284: p_data => x_msg_data,
285: p_encoded => fnd_api.g_false);
286:
287: