APPS.AHL_PRD_MRSHL_PVT dependencies on FND_MSG_PUB

Line 485: FND_MSG_PUB.count_and_get(

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.count_and_get(
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:

Line 492: FND_MSG_PUB.count_and_get(

488: p_data => x_msg_data);
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492: FND_MSG_PUB.count_and_get(
493: p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => x_msg_data);
496:

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

495: p_data => x_msg_data);
496:
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.add_exc_msg(
502: p_pkg_name => G_PKG_NAME,
503: p_procedure_name => l_api_name,

Line 501: FND_MSG_PUB.add_exc_msg(

497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.add_exc_msg(
502: p_pkg_name => G_PKG_NAME,
503: p_procedure_name => l_api_name,
504: p_error_text => SUBSTRB(SQLERRM,1,240));
505: END IF;

Line 506: FND_MSG_PUB.count_and_get(

502: p_pkg_name => G_PKG_NAME,
503: p_procedure_name => l_api_name,
504: p_error_text => SUBSTRB(SQLERRM,1,240));
505: END IF;
506: FND_MSG_PUB.count_and_get(
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data);
510: END Get_unavailable_items;

Line 864: FND_MSG_PUB.count_and_get(

860: x_available_items_tbl := l_available_items_tbl;
861: EXCEPTION
862: WHEN FND_API.G_EXC_ERROR THEN
863: x_return_status := FND_API.G_RET_STS_ERROR ;
864: FND_MSG_PUB.count_and_get(
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data);
868:

Line 871: FND_MSG_PUB.count_and_get(

867: p_data => x_msg_data);
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: FND_MSG_PUB.count_and_get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_msg_count,
874: p_data => x_msg_data);
875:

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

874: p_data => x_msg_data);
875:
876: WHEN OTHERS THEN
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: FND_MSG_PUB.add_exc_msg(
881: p_pkg_name => G_PKG_NAME,
882: p_procedure_name => l_api_name,

Line 880: FND_MSG_PUB.add_exc_msg(

876: WHEN OTHERS THEN
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: FND_MSG_PUB.add_exc_msg(
881: p_pkg_name => G_PKG_NAME,
882: p_procedure_name => l_api_name,
883: p_error_text => SUBSTRB(SQLERRM,1,240));
884: END IF;

Line 885: FND_MSG_PUB.count_and_get(

881: p_pkg_name => G_PKG_NAME,
882: p_procedure_name => l_api_name,
883: p_error_text => SUBSTRB(SQLERRM,1,240));
884: END IF;
885: FND_MSG_PUB.count_and_get(
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data);
889: END Get_available_items;

Line 1471: FND_MSG_PUB.initialize;

1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469: --Initialize message list if p_init_msg_list is set to TRUE.
1470: IF FND_API.to_boolean( p_init_msg_list ) THEN
1471: FND_MSG_PUB.initialize;
1472: END IF;
1473:
1474: IF(p_unit_header_id IS NOT NULL)THEN
1475: get_uc_mrshl_details(

Line 1560: x_msg_count := FND_MSG_PUB.count_msg;

1556: IF(p_commit = FND_API.G_TRUE) THEN
1557: COMMIT WORK;
1558: END IF;
1559: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1560: x_msg_count := FND_MSG_PUB.count_msg;
1561: IF x_msg_count > 0 THEN
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564: -- Count and Get messages (optional)

Line 1565: FND_MSG_PUB.count_and_get(

1561: IF x_msg_count > 0 THEN
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564: -- Count and Get messages (optional)
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.G_FALSE,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data);
1569:

Line 1573: FND_MSG_PUB.count_and_get(

1569:
1570: EXCEPTION
1571: WHEN FND_API.G_EXC_ERROR THEN
1572: x_return_status := FND_API.G_RET_STS_ERROR ;
1573: FND_MSG_PUB.count_and_get(
1574: p_encoded => FND_API.G_FALSE,
1575: p_count => x_msg_count,
1576: p_data => x_msg_data);
1577:

Line 1580: FND_MSG_PUB.count_and_get(

1576: p_data => x_msg_data);
1577:
1578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1580: FND_MSG_PUB.count_and_get(
1581: p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584:

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

1583: p_data => x_msg_data);
1584:
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1588: THEN
1589: FND_MSG_PUB.add_exc_msg(
1590: p_pkg_name => G_PKG_NAME,
1591: p_procedure_name => l_api_name,

Line 1589: FND_MSG_PUB.add_exc_msg(

1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1588: THEN
1589: FND_MSG_PUB.add_exc_msg(
1590: p_pkg_name => G_PKG_NAME,
1591: p_procedure_name => l_api_name,
1592: p_error_text => SUBSTRB(SQLERRM,1,240));
1593: END IF;

Line 1594: FND_MSG_PUB.count_and_get(

1590: p_pkg_name => G_PKG_NAME,
1591: p_procedure_name => l_api_name,
1592: p_error_text => SUBSTRB(SQLERRM,1,240));
1593: END IF;
1594: FND_MSG_PUB.count_and_get(
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data);
1598: END Get_mrshl_details;