eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on FND_API

Line 77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

73:
74: PROCEDURE Get_unavailable_items
75: (
76: p_api_version IN NUMBER := 1.0,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 := FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 := NULL,

Line 78: p_commit IN VARCHAR2 := FND_API.G_FALSE,

74: PROCEDURE Get_unavailable_items
75: (
76: p_api_version IN NUMBER := 1.0,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 := FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 := NULL,
82: p_Mrshl_search_rec IN Mrshl_search_rec_type,

Line 79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

75: (
76: p_api_version IN NUMBER := 1.0,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 := FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 := NULL,
82: p_Mrshl_search_rec IN Mrshl_search_rec_type,
83: x_Unavailable_items_tbl OUT NOCOPY Unavailable_items_Tbl_Type,

Line 80: p_default IN VARCHAR2 := FND_API.G_FALSE,

76: p_api_version IN NUMBER := 1.0,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 := FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 := NULL,
82: p_Mrshl_search_rec IN Mrshl_search_rec_type,
83: x_Unavailable_items_tbl OUT NOCOPY Unavailable_items_Tbl_Type,
84: x_return_status OUT NOCOPY VARCHAR2,

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: --AND msn.current_subinventory_code <> p_subinventory_code;
302:
303:
304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: --Standard call to check for call compatibility.
308: IF NOT FND_API.compatible_api_call(
309: l_api_version,

Line 308: IF NOT FND_API.compatible_api_call(

304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: --Standard call to check for call compatibility.
308: IF NOT FND_API.compatible_api_call(
309: l_api_version,
310: p_api_version,
311: l_api_name,
312: G_PKG_NAME)

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: p_api_version,
311: l_api_name,
312: G_PKG_NAME)
313: THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: OPEN visit_info_csr(p_Mrshl_search_rec.Visit_id);
318: FETCH visit_info_csr INTO l_locator_id, l_subinventory,l_locator_segments;

Line 476: WHEN FND_API.G_EXC_ERROR THEN

472:
473: x_unavailable_items_tbl := l_unavailable_items_tbl;
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,

Line 477: x_return_status := FND_API.G_RET_STS_ERROR ;

473: x_unavailable_items_tbl := l_unavailable_items_tbl;
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);

Line 479: p_encoded => FND_API.G_FALSE,

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:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
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,

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

480: p_count => x_msg_count,
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);

Line 486: p_encoded => FND_API.G_FALSE,

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:
490: WHEN OTHERS THEN

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

487: p_count => x_msg_count,
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,

Line 500: p_encoded => FND_API.G_FALSE,

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;
504:

Line 508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

504:
505: PROCEDURE Get_available_items
506: (
507: p_api_version IN NUMBER := 1.0,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_commit IN VARCHAR2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_default IN VARCHAR2 := FND_API.G_FALSE,
512: p_module_type IN VARCHAR2 := NULL,

Line 509: p_commit IN VARCHAR2 := FND_API.G_FALSE,

505: PROCEDURE Get_available_items
506: (
507: p_api_version IN NUMBER := 1.0,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_commit IN VARCHAR2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_default IN VARCHAR2 := FND_API.G_FALSE,
512: p_module_type IN VARCHAR2 := NULL,
513: p_Mrshl_search_rec IN Mrshl_search_rec_type,

Line 510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

506: (
507: p_api_version IN NUMBER := 1.0,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_commit IN VARCHAR2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_default IN VARCHAR2 := FND_API.G_FALSE,
512: p_module_type IN VARCHAR2 := NULL,
513: p_Mrshl_search_rec IN Mrshl_search_rec_type,
514: x_available_items_tbl OUT NOCOPY Available_items_Tbl_Type,

Line 511: p_default IN VARCHAR2 := FND_API.G_FALSE,

507: p_api_version IN NUMBER := 1.0,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_commit IN VARCHAR2 := FND_API.G_FALSE,
510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: p_default IN VARCHAR2 := FND_API.G_FALSE,
512: p_module_type IN VARCHAR2 := NULL,
513: p_Mrshl_search_rec IN Mrshl_search_rec_type,
514: x_available_items_tbl OUT NOCOPY Available_items_Tbl_Type,
515: x_return_status OUT NOCOPY VARCHAR2,

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS;

713:
714:
715:
716: BEGIN
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: --Standard call to check for call compatibility.
720: IF NOT FND_API.compatible_api_call(
721: l_api_version,

Line 720: IF NOT FND_API.compatible_api_call(

716: BEGIN
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: --Standard call to check for call compatibility.
720: IF NOT FND_API.compatible_api_call(
721: l_api_version,
722: p_api_version,
723: l_api_name,
724: G_PKG_NAME)

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: p_api_version,
723: l_api_name,
724: G_PKG_NAME)
725: THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: OPEN visit_info_csr(p_Mrshl_search_rec.Visit_id);
730: FETCH visit_info_csr INTO l_locator_id, l_subinventory,l_locator_segments;

Line 868: WHEN FND_API.G_EXC_ERROR THEN

864: ' Count : ' || to_char(j -1));
865: END IF;
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,

Line 869: x_return_status := FND_API.G_RET_STS_ERROR ;

865: END IF;
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);

Line 871: p_encoded => FND_API.G_FALSE,

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:
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

871: p_encoded => FND_API.G_FALSE,
872: p_count => x_msg_count,
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,

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

872: p_count => x_msg_count,
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);

Line 878: p_encoded => FND_API.G_FALSE,

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:
882: WHEN OTHERS THEN

Line 883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

879: p_count => x_msg_count,
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,

Line 892: p_encoded => FND_API.G_FALSE,

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;
896: /*

Line 1484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1480:
1481: PROCEDURE Get_mrshl_details
1482: (
1483: p_api_version IN NUMBER := 1.0,
1484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1485: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1487: p_default IN VARCHAR2 := FND_API.G_FALSE,
1488: p_module_type IN VARCHAR2 := NULL,

Line 1485: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1481: PROCEDURE Get_mrshl_details
1482: (
1483: p_api_version IN NUMBER := 1.0,
1484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1485: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1487: p_default IN VARCHAR2 := FND_API.G_FALSE,
1488: p_module_type IN VARCHAR2 := NULL,
1489: p_unit_header_id IN NUMBER,

Line 1486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1482: (
1483: p_api_version IN NUMBER := 1.0,
1484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1485: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1487: p_default IN VARCHAR2 := FND_API.G_FALSE,
1488: p_module_type IN VARCHAR2 := NULL,
1489: p_unit_header_id IN NUMBER,
1490: p_item_instance_id IN NUMBER,

Line 1487: p_default IN VARCHAR2 := FND_API.G_FALSE,

1483: p_api_version IN NUMBER := 1.0,
1484: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1485: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1487: p_default IN VARCHAR2 := FND_API.G_FALSE,
1488: p_module_type IN VARCHAR2 := NULL,
1489: p_unit_header_id IN NUMBER,
1490: p_item_instance_id IN NUMBER,
1491: p_visit_id IN NUMBER,

Line 1506: x_return_status := FND_API.G_RET_STS_SUCCESS;

1502: l_count NUMBER;
1503:
1504: BEGIN
1505: --Initialize API return status to success
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: --Standard call to check for call compatibility.
1509: IF NOT FND_API.compatible_api_call(
1510: l_api_version,

Line 1509: IF NOT FND_API.compatible_api_call(

1505: --Initialize API return status to success
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: --Standard call to check for call compatibility.
1509: IF NOT FND_API.compatible_api_call(
1510: l_api_version,
1511: p_api_version,
1512: l_api_name,
1513: G_PKG_NAME)

Line 1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1511: p_api_version,
1512: l_api_name,
1513: G_PKG_NAME)
1514: THEN
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;

Line 1518: IF FND_API.to_boolean( p_init_msg_list ) THEN

1514: THEN
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

Line 1598: IF(p_commit = FND_API.G_TRUE) THEN

1594: );
1595: END LOOP;
1596: END IF;
1597:
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;

Line 1604: RAISE FND_API.G_EXC_ERROR;

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)
1607: FND_MSG_PUB.count_and_get(
1608: p_encoded => FND_API.G_FALSE,

Line 1608: p_encoded => FND_API.G_FALSE,

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:
1612: EXCEPTION

Line 1613: WHEN FND_API.G_EXC_ERROR THEN

1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
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,

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR ;

1610: p_data => x_msg_data);
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);

Line 1616: p_encoded => FND_API.G_FALSE,

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:
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
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,

Line 1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1617: p_count => x_msg_count,
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);

Line 1623: p_encoded => FND_API.G_FALSE,

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:
1627: WHEN OTHERS THEN

Line 1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1624: p_count => x_msg_count,
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,

Line 1637: p_encoded => FND_API.G_FALSE,

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;
1641:

Line 1715: p_init_msg_list => FND_API.G_TRUE,

1711: CLOSE uc_header_information;
1712:
1713: AHL_UC_TREE_PVT.get_whole_uc_tree(
1714: p_api_version => 1.0,
1715: p_init_msg_list => FND_API.G_TRUE,
1716: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1717: x_return_status => l_return_status,
1718: x_msg_count => l_msg_count,
1719: x_msg_data => l_msg_data,

Line 1716: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1712:
1713: AHL_UC_TREE_PVT.get_whole_uc_tree(
1714: p_api_version => 1.0,
1715: p_init_msg_list => FND_API.G_TRUE,
1716: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1717: x_return_status => l_return_status,
1718: x_msg_count => l_msg_count,
1719: x_msg_data => l_msg_data,
1720: p_uc_header_id => p_unit_header_id,

Line 1722: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1718: x_msg_count => l_msg_count,
1719: x_msg_data => l_msg_data,
1720: p_uc_header_id => p_unit_header_id,
1721: x_uc_descendant_tbl => l_uc_descendant_tbl);
1722: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725:
1726: j := 1;

Line 1723: RAISE FND_API.G_EXC_ERROR;

1719: x_msg_data => l_msg_data,
1720: p_uc_header_id => p_unit_header_id,
1721: x_uc_descendant_tbl => l_uc_descendant_tbl);
1722: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725:
1726: j := 1;
1727: IF l_uc_descendant_tbl.FIRST IS NOT NULL THEN