DBA Data[Home] [Help]

APPS.AHL_PC_ASSOCIATION_PUB dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.ADD;

41: FETCH get_id_for_name INTO l_unit_id;
42: IF (get_id_for_name%NOTFOUND)
43: THEN
44: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
45: FND_MSG_PUB.ADD;
46: RAISE FND_API.G_EXC_ERROR;
47: ELSE
48: p_x_assos_rec.unit_item_id := l_unit_id;
49: END IF;

Line 77: FND_MSG_PUB.ADD;

73: FETCH get_id_for_name INTO l_part_id;
74: IF (get_id_for_name%NOTFOUND)
75: THEN
76: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
77: FND_MSG_PUB.ADD;
78: RAISE FND_API.G_EXC_ERROR;
79: ELSE
80: p_x_assos_rec.unit_item_id := l_part_id;
81: END IF;

Line 119: FND_MSG_PUB.Initialize;

115:
116: -- Initialize message list if p_init_msg_list is set to TRUE
117: IF FND_API.To_Boolean(p_init_msg_list)
118: THEN
119: FND_MSG_PUB.Initialize;
120: END IF;
121:
122: -- Initialize API return status to success
123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 244: x_msg_count := FND_MSG_PUB.count_msg;

240: END LOOP;
241: END IF;
242:
243: -- Check Error Message stack.
244: x_msg_count := FND_MSG_PUB.count_msg;
245: IF x_msg_count > 0 THEN
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:

Line 256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

252: COMMIT WORK;
253: END IF;
254:
255: -- Standard call to get message count and if count is 1, get message info
256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
257: p_data => x_msg_data,
258: p_encoded => fnd_api.g_false );
259:
260: EXCEPTION

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

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

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

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

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

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

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

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

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

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

Line 320: FND_MSG_PUB.Initialize;

316:
317: -- Initialize message list if p_init_msg_list is set to TRUE
318: IF FND_API.To_Boolean(p_init_msg_list)
319: THEN
320: FND_MSG_PUB.Initialize;
321: END IF;
322:
323: -- Initialize API return status to success
324: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 344: x_msg_count := FND_MSG_PUB.count_msg;

340: x_msg_data => x_msg_data
341: );
342:
343: -- Check Error Message stack.
344: x_msg_count := FND_MSG_PUB.count_msg;
345: IF x_msg_count > 0 THEN
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:

Line 356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

352: COMMIT WORK;
353: END IF;
354:
355: -- Standard call to get message count and if count is 1, get message info
356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
357: p_data => x_msg_data,
358: p_encoded => fnd_api.g_false );
359:
360: EXCEPTION

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

360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: Rollback to PROCESS_DOCUMENT_PUB;
364: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
365: p_data => x_msg_data,
366: p_encoded => fnd_api.g_false );
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: Rollback to PROCESS_DOCUMENT_PUB;
371: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
372: p_data => x_msg_data,
373: p_encoded => fnd_api.g_false );
374:
375: WHEN OTHERS THEN

Line 378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

374:
375: WHEN OTHERS THEN
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: Rollback to PROCESS_DOCUMENT_PUB;
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
381: p_procedure_name => 'PROCESS_DOCUMENT',
382: p_error_text => SUBSTR(SQLERRM, 1, 240));

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

376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: Rollback to PROCESS_DOCUMENT_PUB;
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
381: p_procedure_name => 'PROCESS_DOCUMENT',
382: p_error_text => SUBSTR(SQLERRM, 1, 240));
383: END IF;
384: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

380: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
381: p_procedure_name => 'PROCESS_DOCUMENT',
382: p_error_text => SUBSTR(SQLERRM, 1, 240));
383: END IF;
384: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
385: p_data => x_msg_data,
386: p_encoded => fnd_api.g_false );
387:
388: END PROCESS_DOCUMENT;