DBA Data[Home] [Help]

APPS.AHL_MATERIALS_GRP dependencies on FND_MSG_PUB

Line 99: FND_MSG_PUB.Initialize;

95:
96: -- Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.To_Boolean(p_init_msg_list)
98: THEN
99: FND_MSG_PUB.Initialize;
100: END IF;
101:
102: l_prev_err_count := NVL(FND_MSG_PUB.count_msg, 0);
103:

Line 102: l_prev_err_count := NVL(FND_MSG_PUB.count_msg, 0);

98: THEN
99: FND_MSG_PUB.Initialize;
100: END IF;
101:
102: l_prev_err_count := NVL(FND_MSG_PUB.count_msg, 0);
103:
104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:

Line 176: x_msg_count := FND_MSG_PUB.count_msg;

172: END IF; --Visit Task Id is not null
173: CLOSE get_visit_task_id_csr;
174:
175: -- Check Error Message stack.
176: x_msg_count := FND_MSG_PUB.count_msg;
177:
178: IF x_msg_count - l_prev_err_count > 0 THEN
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;

Line 183: FND_MSG_PUB.Count_And_Get

179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182: -- Standard call to get message count and if count is 1, get message info
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data,
186: p_encoded => fnd_api.g_false
187: );

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

192:
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => fnd_api.g_false);
199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);

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

201: END IF;
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
206: p_data => x_msg_data,
207: p_encoded => fnd_api.g_false);
208:
209: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

211: END IF;
212:
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
216: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
217: p_procedure_name => l_api_name,
218: p_error_text => SUBSTR(SQLERRM,1,500));
219: END IF;

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

212:
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
216: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
217: p_procedure_name => l_api_name,
218: p_error_text => SUBSTR(SQLERRM,1,500));
219: END IF;
220: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

216: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
217: p_procedure_name => l_api_name,
218: p_error_text => SUBSTR(SQLERRM,1,500));
219: END IF;
220: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
221: p_data => x_msg_data,
222: p_encoded => fnd_api.g_false);
223:
224: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 332: FND_MSG_PUB.Initialize;

328:
329: -- Initialize message list if p_init_msg_list is set to TRUE
330: IF FND_API.To_Boolean(p_init_msg_list)
331: THEN
332: FND_MSG_PUB.Initialize;
333: END IF;
334:
335: l_prev_err_count := NVL(FND_MSG_PUB.count_msg,0);
336:

Line 335: l_prev_err_count := NVL(FND_MSG_PUB.count_msg,0);

331: THEN
332: FND_MSG_PUB.Initialize;
333: END IF;
334:
335: l_prev_err_count := NVL(FND_MSG_PUB.count_msg,0);
336:
337: -- Initialize API return status to success
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:

Line 349: Fnd_Msg_Pub.ADD;

345: -- If the schedule start date corresponding the input wip entity id fetched above is null
346: -- then the wip entity id passed to this procedure is invalid
347: IF l_requested_date IS NULL THEN
348: Fnd_Message.SET_NAME('AHL','AHL_LTP_WIP_ENTITY_ID_INVLD');
349: Fnd_Msg_Pub.ADD;
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: IF (p_alt_item_tbl IS NULL OR p_alt_item_tbl.COUNT = 0) THEN

Line 460: x_msg_count := FND_MSG_PUB.count_msg;

456: END LOOP;
457: END IF;
458:
459: -- Check Error Message stack.
460: x_msg_count := FND_MSG_PUB.count_msg;
461:
462: IF x_msg_count - l_prev_err_count > 0 THEN
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;

Line 472: FND_MSG_PUB.Count_And_Get

468: COMMIT WORK;
469: END IF;
470:
471: -- Standard call to get message count and if count is 1, get message info
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => fnd_api.g_false
476: );

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

482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: Rollback to update_wo_materials_pvt;
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);

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

492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: Rollback to update_wo_materials_pvt;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
497: p_data => x_msg_data,
498: p_encoded => fnd_api.g_false);
499: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

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

502:
503: WHEN OTHERS THEN
504: Rollback to update_wo_materials_pvt;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
507: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
508: p_procedure_name => l_api_name,
509: p_error_text => SUBSTR(SQLERRM,1,500));
510: END IF;

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

503: WHEN OTHERS THEN
504: Rollback to update_wo_materials_pvt;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
507: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
508: p_procedure_name => l_api_name,
509: p_error_text => SUBSTR(SQLERRM,1,500));
510: END IF;
511: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

507: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
508: p_procedure_name => l_api_name,
509: p_error_text => SUBSTR(SQLERRM,1,500));
510: END IF;
511: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => fnd_api.g_false);
514: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Other Exception: ' || x_msg_data);