DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on FND_MSG_PUB

Line 478: FND_MSG_PUB.count_and_get(

474:
475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.count_and_get(
479: p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data);
482:

Line 485: FND_MSG_PUB.count_and_get(

481: p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_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: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

488: p_data => x_msg_data);
489:
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.add_exc_msg(
495: p_pkg_name => G_PKG_NAME,
496: p_procedure_name => l_api_name,

Line 494: FND_MSG_PUB.add_exc_msg(

490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.add_exc_msg(
495: p_pkg_name => G_PKG_NAME,
496: p_procedure_name => l_api_name,
497: p_error_text => SUBSTRB(SQLERRM,1,240));
498: END IF;

Line 499: FND_MSG_PUB.count_and_get(

495: p_pkg_name => G_PKG_NAME,
496: p_procedure_name => l_api_name,
497: p_error_text => SUBSTRB(SQLERRM,1,240));
498: END IF;
499: FND_MSG_PUB.count_and_get(
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503: END Get_unavailable_items;

Line 870: FND_MSG_PUB.count_and_get(

866: x_available_items_tbl := l_available_items_tbl;
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: x_return_status := FND_API.G_RET_STS_ERROR ;
870: FND_MSG_PUB.count_and_get(
871: p_encoded => FND_API.G_FALSE,
872: p_count => x_msg_count,
873: p_data => x_msg_data);
874:

Line 877: FND_MSG_PUB.count_and_get(

873: p_data => x_msg_data);
874:
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877: FND_MSG_PUB.count_and_get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:

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

880: p_data => x_msg_data);
881:
882: WHEN OTHERS THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: FND_MSG_PUB.add_exc_msg(
887: p_pkg_name => G_PKG_NAME,
888: p_procedure_name => l_api_name,

Line 886: FND_MSG_PUB.add_exc_msg(

882: WHEN OTHERS THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: FND_MSG_PUB.add_exc_msg(
887: p_pkg_name => G_PKG_NAME,
888: p_procedure_name => l_api_name,
889: p_error_text => SUBSTRB(SQLERRM,1,240));
890: END IF;

Line 891: FND_MSG_PUB.count_and_get(

887: p_pkg_name => G_PKG_NAME,
888: p_procedure_name => l_api_name,
889: p_error_text => SUBSTRB(SQLERRM,1,240));
890: END IF;
891: FND_MSG_PUB.count_and_get(
892: p_encoded => FND_API.G_FALSE,
893: p_count => x_msg_count,
894: p_data => x_msg_data);
895: END Get_available_items;

Line 1519: FND_MSG_PUB.initialize;

1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: END IF;
1517: --Initialize message list if p_init_msg_list is set to TRUE.
1518: IF FND_API.to_boolean( p_init_msg_list ) THEN
1519: FND_MSG_PUB.initialize;
1520: END IF;
1521:
1522: IF(p_unit_header_id IS NOT NULL)THEN
1523: get_uc_mrshl_details(

Line 1602: x_msg_count := FND_MSG_PUB.count_msg;

1598: IF(p_commit = FND_API.G_TRUE) THEN
1599: COMMIT WORK;
1600: END IF;
1601: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1602: x_msg_count := FND_MSG_PUB.count_msg;
1603: IF x_msg_count > 0 THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: -- Count and Get messages (optional)

Line 1607: FND_MSG_PUB.count_and_get(

1603: IF x_msg_count > 0 THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: -- Count and Get messages (optional)
1607: FND_MSG_PUB.count_and_get(
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
1611:

Line 1615: FND_MSG_PUB.count_and_get(

1611:
1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR ;
1615: FND_MSG_PUB.count_and_get(
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data);
1619:

Line 1622: FND_MSG_PUB.count_and_get(

1618: p_data => x_msg_data);
1619:
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1622: FND_MSG_PUB.count_and_get(
1623: p_encoded => FND_API.G_FALSE,
1624: p_count => x_msg_count,
1625: p_data => x_msg_data);
1626:

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

1625: p_data => x_msg_data);
1626:
1627: WHEN OTHERS THEN
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1630: THEN
1631: FND_MSG_PUB.add_exc_msg(
1632: p_pkg_name => G_PKG_NAME,
1633: p_procedure_name => l_api_name,

Line 1631: FND_MSG_PUB.add_exc_msg(

1627: WHEN OTHERS THEN
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1630: THEN
1631: FND_MSG_PUB.add_exc_msg(
1632: p_pkg_name => G_PKG_NAME,
1633: p_procedure_name => l_api_name,
1634: p_error_text => SUBSTRB(SQLERRM,1,240));
1635: END IF;

Line 1636: FND_MSG_PUB.count_and_get(

1632: p_pkg_name => G_PKG_NAME,
1633: p_procedure_name => l_api_name,
1634: p_error_text => SUBSTRB(SQLERRM,1,240));
1635: END IF;
1636: FND_MSG_PUB.count_and_get(
1637: p_encoded => FND_API.G_FALSE,
1638: p_count => x_msg_count,
1639: p_data => x_msg_data);
1640: END Get_mrshl_details;