DBA Data[Home] [Help]

APPS.AHL_UC_POS_NECES_PVT dependencies on FND_MSG_PUB

Line 154: FND_MSG_PUB.Initialize;

150: END IF;
151:
152: -- Initialize message list if p_init_msg_list is set to TRUE
153: IF FND_API.To_Boolean(p_init_msg_list) THEN
154: FND_MSG_PUB.Initialize;
155: END IF;
156:
157: -- Initialize API return status to success
158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 174: FND_MSG_PUB.add;

170: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
171: IF ( get_uc_header_rec_csr%NOTFOUND ) THEN
172: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
173: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
174: FND_MSG_PUB.add;
175: CLOSE get_uc_header_rec_csr;
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: CLOSE get_uc_header_rec_csr;

Line 239: x_msg_count := FND_MSG_PUB.count_msg;

235: END LOOP;
236: CLOSE get_extra_nodes_csr;
237:
238: -- Check Error Message stack.
239: x_msg_count := FND_MSG_PUB.count_msg;
240: IF x_msg_count > 0 THEN
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:

Line 245: FND_MSG_PUB.Count_And_Get

241: RAISE FND_API.G_EXC_ERROR;
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 254: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

250:
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
255: p_data => x_msg_data,
256: p_encoded => fnd_api.g_false);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

255: p_data => x_msg_data,
256: p_encoded => fnd_api.g_false);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
260: p_data => x_msg_data,
261: p_encoded => fnd_api.g_false);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 264: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

260: p_data => x_msg_data,
261: p_encoded => fnd_api.g_false);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
265: p_procedure_name => l_api_name,
266: p_error_text => SQLERRM);
267:
268: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

264: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
265: p_procedure_name => l_api_name,
266: p_error_text => SQLERRM);
267:
268: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
269: p_data => x_msg_data,
270: p_encoded => fnd_api.g_false);
271:
272: END List_Extra_Nodes;

Line 356: FND_MSG_PUB.Initialize;

352: END IF;
353:
354: -- Initialize message list if p_init_msg_list is set to TRUE
355: IF FND_API.To_Boolean(p_init_msg_list) THEN
356: FND_MSG_PUB.Initialize;
357: END IF;
358:
359: -- Initialize API return status to success
360: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 369: FND_MSG_PUB.add;

365: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
366: IF ( get_uc_header_rec_csr%NOTFOUND ) THEN
367: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
368: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
369: FND_MSG_PUB.add;
370: CLOSE get_uc_header_rec_csr;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373: CLOSE get_uc_header_rec_csr;

Line 387: x_msg_count := FND_MSG_PUB.count_msg;

383: CLOSE get_extra_nodes_csr;
384: --Completed Processing
385:
386: -- Check Error Message stack.
387: x_msg_count := FND_MSG_PUB.count_msg;
388: IF x_msg_count > 0 THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:

Line 393: FND_MSG_PUB.Count_And_Get

389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
392: -- Standard call to get message count and if count is 1, get message info
393: FND_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false
397: );

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

397: );
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
402: p_data => x_msg_data,
403: p_encoded => fnd_api.g_false);
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

402: p_data => x_msg_data,
403: p_encoded => fnd_api.g_false);
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
407: p_data => x_msg_data,
408: p_encoded => fnd_api.g_false);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 411: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

407: p_data => x_msg_data,
408: p_encoded => fnd_api.g_false);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
412: p_procedure_name => l_api_name,
413: p_error_text => SQLERRM);
414:
415: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

411: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
412: p_procedure_name => l_api_name,
413: p_error_text => SQLERRM);
414:
415: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
416: p_data => x_msg_data,
417: p_encoded => fnd_api.g_false);
418: END Check_Extra_Nodes;
419:

Line 546: FND_MSG_PUB.Initialize;

542: END IF;
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE
545: IF FND_API.To_Boolean(p_init_msg_list) THEN
546: FND_MSG_PUB.Initialize;
547: END IF;
548:
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 560: FND_MSG_PUB.add;

556: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
557: IF ( get_uc_header_rec_csr%NOTFOUND ) THEN
558: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
559: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
560: FND_MSG_PUB.add;
561: CLOSE get_uc_header_rec_csr;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: CLOSE get_uc_header_rec_csr;

Line 601: x_msg_count := FND_MSG_PUB.count_msg;

597:
598: --Completed Processing
599:
600: -- Check Error Message stack.
601: x_msg_count := FND_MSG_PUB.count_msg;
602: IF x_msg_count > 0 THEN
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:

Line 607: FND_MSG_PUB.Count_And_Get

603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:
606: -- Standard call to get message count and if count is 1, get message info
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,
609: p_data => x_msg_data,
610: p_encoded => fnd_api.g_false
611: );

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

613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
618: p_data => x_msg_data,
619: p_encoded => fnd_api.g_false);
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

619: p_encoded => fnd_api.g_false);
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => fnd_api.g_false);
626:
627: WHEN OTHERS THEN

Line 629: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

625: p_encoded => fnd_api.g_false);
626:
627: WHEN OTHERS THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
630: p_procedure_name => l_api_name,
631: p_error_text => SQLERRM);
632:
633: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

629: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
630: p_procedure_name => l_api_name,
631: p_error_text => SQLERRM);
632:
633: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => fnd_api.g_false);
636:
637: END Check_Missing_Positions;

Line 777: FND_MSG_PUB.Initialize;

773: END IF;
774:
775: -- Initialize message list if p_init_msg_list is set to TRUE
776: IF FND_API.To_Boolean(p_init_msg_list) THEN
777: FND_MSG_PUB.Initialize;
778: END IF;
779:
780: -- Initialize API return status to success
781: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 796: FND_MSG_PUB.add;

792: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
793: IF ( get_uc_header_rec_csr%NOTFOUND ) THEN
794: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
795: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
796: FND_MSG_PUB.add;
797: CLOSE get_uc_header_rec_csr;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800: CLOSE get_uc_header_rec_csr;

Line 884: x_msg_count := FND_MSG_PUB.count_msg;

880:
881: --Completed Processing
882:
883: -- Check Error Message stack.
884: x_msg_count := FND_MSG_PUB.count_msg;
885: IF x_msg_count > 0 THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:

Line 890: FND_MSG_PUB.Count_And_Get

886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: -- Standard call to get message count and if count is 1, get message info
890: FND_MSG_PUB.Count_And_Get
891: ( p_count => x_msg_count,
892: p_data => x_msg_data,
893: p_encoded => fnd_api.g_false
894: );

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

896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
901: p_data => x_msg_data,
902: p_encoded => fnd_api.g_false);
903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

901: p_data => x_msg_data,
902: p_encoded => fnd_api.g_false);
903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 910: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
911: p_procedure_name => l_api_name,
912: p_error_text => SQLERRM);
913:
914: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

910: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
911: p_procedure_name => l_api_name,
912: p_error_text => SQLERRM);
913:
914: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => fnd_api.g_false);
917: END List_Missing_Positions;
918:

Line 1249: FND_MSG_PUB.Initialize;

1245: END IF;
1246:
1247: -- Initialize message list if p_init_msg_list is set to TRUE
1248: IF FND_API.To_Boolean(p_init_msg_list) THEN
1249: FND_MSG_PUB.Initialize;
1250: END IF;
1251:
1252: -- Initialize API return status to success
1253: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1267: FND_MSG_PUB.add;

1263: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
1264: IF (get_uc_header_rec_csr%NOTFOUND) THEN
1265: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1266: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
1267: FND_MSG_PUB.add;
1268: CLOSE get_uc_header_rec_csr;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271: CLOSE get_uc_header_rec_csr;

Line 1379: x_msg_count := FND_MSG_PUB.count_msg;

1375:
1376: -- Completed Processing
1377:
1378: -- Check Error Message stack.
1379: x_msg_count := FND_MSG_PUB.count_msg;
1380: IF x_msg_count > 0 THEN
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383:

Line 1391: FND_MSG_PUB.Count_And_Get

1387: ', p_x_error_table.COUNT = ' || p_x_error_table.COUNT);
1388: END IF;
1389:
1390: -- Standard call to get message count and if count is 1, get message info
1391: FND_MSG_PUB.Count_And_Get
1392: ( p_count => x_msg_count,
1393: p_data => x_msg_data,
1394: p_encoded => fnd_api.g_false
1395: );

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

1396:
1397: EXCEPTION
1398: WHEN FND_API.G_EXC_ERROR THEN
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1401: p_data => x_msg_data,
1402: p_encoded => fnd_api.g_false);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1401: p_data => x_msg_data,
1402: p_encoded => fnd_api.g_false);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1406: p_data => x_msg_data,
1407: p_encoded => fnd_api.g_false);
1408: WHEN OTHERS THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1410: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

1406: p_data => x_msg_data,
1407: p_encoded => fnd_api.g_false);
1408: WHEN OTHERS THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1411: p_procedure_name => l_api_name,
1412: p_error_text => SQLERRM);
1413:
1414: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1410: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1411: p_procedure_name => l_api_name,
1412: p_error_text => SQLERRM);
1413:
1414: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1415: p_data => x_msg_data,
1416: p_encoded => fnd_api.g_false);
1417: END Validate_Position_Quantities;
1418:

Line 1582: FND_MSG_PUB.Initialize;

1578: END IF;
1579:
1580: -- Initialize message list if p_init_msg_list is set to TRUE
1581: IF FND_API.To_Boolean(p_init_msg_list) THEN
1582: FND_MSG_PUB.Initialize;
1583: END IF;
1584:
1585: -- Initialize API return status to success
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1597: FND_MSG_PUB.add;

1593: FETCH get_uc_header_rec_csr INTO l_top_instance_id;
1594: IF (get_uc_header_rec_csr%NOTFOUND) THEN
1595: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1596: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
1597: FND_MSG_PUB.add;
1598: CLOSE get_uc_header_rec_csr;
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601: CLOSE get_uc_header_rec_csr;

Line 1699: x_msg_count := FND_MSG_PUB.count_msg;

1695:
1696: -- Completed Processing
1697:
1698: -- Check Error Message stack.
1699: x_msg_count := FND_MSG_PUB.count_msg;
1700: IF x_msg_count > 0 THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:

Line 1710: FND_MSG_PUB.Count_And_Get

1706: 'At the end of the procedure, About to return x_evaluation_status as ' || x_evaluation_status);
1707: END IF;
1708:
1709: -- Standard call to get message count and if count is 1, get message info
1710: FND_MSG_PUB.Count_And_Get
1711: ( p_count => x_msg_count,
1712: p_data => x_msg_data,
1713: p_encoded => fnd_api.g_false
1714: );

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

1715:
1716: EXCEPTION
1717: WHEN FND_API.G_EXC_ERROR THEN
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1719: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1725: p_data => x_msg_data,
1726: p_encoded => fnd_api.g_false);
1727: WHEN OTHERS THEN
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1729: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1725: p_data => x_msg_data,
1726: p_encoded => fnd_api.g_false);
1727: WHEN OTHERS THEN
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1730: p_procedure_name => l_api_name,
1731: p_error_text => SQLERRM);
1732:
1733: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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

1729: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1730: p_procedure_name => l_api_name,
1731: p_error_text => SQLERRM);
1732:
1733: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1734: p_data => x_msg_data,
1735: p_encoded => fnd_api.g_false);
1736: END Check_Position_Quantities;
1737: