APPS.AHL_PRD_MRSHL_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: --AND msn.current_subinventory_code <> p_subinventory_code;
263:
264:
265: BEGIN
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: --Standard call to check for call compatibility.
269: IF NOT FND_API.compatible_api_call(
270: l_api_version,

Line 269: IF NOT FND_API.compatible_api_call(

265: BEGIN
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: --Standard call to check for call compatibility.
269: IF NOT FND_API.compatible_api_call(
270: l_api_version,
271: p_api_version,
272: l_api_name,
273: G_PKG_NAME)

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: p_api_version,
272: l_api_name,
273: G_PKG_NAME)
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
279: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: END IF;
480: x_unavailable_items_tbl := l_unavailable_items_tbl;
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,

Line 484: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 486: p_encoded => FND_API.G_FALSE,

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

Line 490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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 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);

Line 493: p_encoded => FND_API.G_FALSE,

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

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 507: p_encoded => FND_API.G_FALSE,

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

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

511:
512: PROCEDURE Get_available_items
513: (
514: p_api_version IN NUMBER := 1.0,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: p_default IN VARCHAR2 := FND_API.G_FALSE,
519: p_module_type IN VARCHAR2 := NULL,

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

512: PROCEDURE Get_available_items
513: (
514: p_api_version IN NUMBER := 1.0,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: p_default IN VARCHAR2 := FND_API.G_FALSE,
519: p_module_type IN VARCHAR2 := NULL,
520: p_Mrshl_search_rec IN Mrshl_search_rec_type,

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

513: (
514: p_api_version IN NUMBER := 1.0,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: p_default IN VARCHAR2 := FND_API.G_FALSE,
519: p_module_type IN VARCHAR2 := NULL,
520: p_Mrshl_search_rec IN Mrshl_search_rec_type,
521: x_available_items_tbl OUT NOCOPY Available_items_Tbl_Type,

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

514: p_api_version IN NUMBER := 1.0,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: p_default IN VARCHAR2 := FND_API.G_FALSE,
519: p_module_type IN VARCHAR2 := NULL,
520: p_Mrshl_search_rec IN Mrshl_search_rec_type,
521: x_available_items_tbl OUT NOCOPY Available_items_Tbl_Type,
522: x_return_status OUT NOCOPY VARCHAR2,

Line 687: x_return_status := FND_API.G_RET_STS_SUCCESS;

683:
684:
685:
686: BEGIN
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: --Standard call to check for call compatibility.
690: IF NOT FND_API.compatible_api_call(
691: l_api_version,

Line 690: IF NOT FND_API.compatible_api_call(

686: BEGIN
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: --Standard call to check for call compatibility.
690: IF NOT FND_API.compatible_api_call(
691: l_api_version,
692: p_api_version,
693: l_api_name,
694: G_PKG_NAME)

Line 696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

692: p_api_version,
693: l_api_name,
694: G_PKG_NAME)
695: THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698:
699: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 862: WHEN FND_API.G_EXC_ERROR THEN

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

Line 863: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 865: p_encoded => FND_API.G_FALSE,

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

Line 869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 872: p_encoded => FND_API.G_FALSE,

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

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 886: p_encoded => FND_API.G_FALSE,

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

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

1432:
1433: PROCEDURE Get_mrshl_details
1434: (
1435: p_api_version IN NUMBER := 1.0,
1436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1439: p_default IN VARCHAR2 := FND_API.G_FALSE,
1440: p_module_type IN VARCHAR2 := NULL,

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

1433: PROCEDURE Get_mrshl_details
1434: (
1435: p_api_version IN NUMBER := 1.0,
1436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1439: p_default IN VARCHAR2 := FND_API.G_FALSE,
1440: p_module_type IN VARCHAR2 := NULL,
1441: p_unit_header_id IN NUMBER,

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

1434: (
1435: p_api_version IN NUMBER := 1.0,
1436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1439: p_default IN VARCHAR2 := FND_API.G_FALSE,
1440: p_module_type IN VARCHAR2 := NULL,
1441: p_unit_header_id IN NUMBER,
1442: p_item_instance_id IN NUMBER,

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

1435: p_api_version IN NUMBER := 1.0,
1436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1439: p_default IN VARCHAR2 := FND_API.G_FALSE,
1440: p_module_type IN VARCHAR2 := NULL,
1441: p_unit_header_id IN NUMBER,
1442: p_item_instance_id IN NUMBER,
1443: p_visit_id IN NUMBER,

Line 1458: x_return_status := FND_API.G_RET_STS_SUCCESS;

1454: l_count NUMBER;
1455:
1456: BEGIN
1457: --Initialize API return status to success
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459:
1460: --Standard call to check for call compatibility.
1461: IF NOT FND_API.compatible_api_call(
1462: l_api_version,

Line 1461: IF NOT FND_API.compatible_api_call(

1457: --Initialize API return status to success
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459:
1460: --Standard call to check for call compatibility.
1461: IF NOT FND_API.compatible_api_call(
1462: l_api_version,
1463: p_api_version,
1464: l_api_name,
1465: G_PKG_NAME)

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: p_api_version,
1464: l_api_name,
1465: G_PKG_NAME)
1466: THEN
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;

Line 1470: IF FND_API.to_boolean( p_init_msg_list ) THEN

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

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

1552: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
1553: 'At the end of the procedure');
1554: END IF;
1555:
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;

Line 1562: RAISE FND_API.G_EXC_ERROR;

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

Line 1566: p_encoded => FND_API.G_FALSE,

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

Line 1571: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1572: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1574: p_encoded => FND_API.G_FALSE,

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

Line 1578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1581: p_encoded => FND_API.G_FALSE,

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

Line 1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1595: p_encoded => FND_API.G_FALSE,

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

Line 1673: p_init_msg_list => FND_API.G_TRUE,

1669: CLOSE uc_header_information;
1670:
1671: AHL_UC_TREE_PVT.get_whole_uc_tree(
1672: p_api_version => 1.0,
1673: p_init_msg_list => FND_API.G_TRUE,
1674: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1675: x_return_status => l_return_status,
1676: x_msg_count => l_msg_count,
1677: x_msg_data => l_msg_data,

Line 1674: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1670:
1671: AHL_UC_TREE_PVT.get_whole_uc_tree(
1672: p_api_version => 1.0,
1673: p_init_msg_list => FND_API.G_TRUE,
1674: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1675: x_return_status => l_return_status,
1676: x_msg_count => l_msg_count,
1677: x_msg_data => l_msg_data,
1678: p_uc_header_id => p_unit_header_id,

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

1676: x_msg_count => l_msg_count,
1677: x_msg_data => l_msg_data,
1678: p_uc_header_id => p_unit_header_id,
1679: x_uc_descendant_tbl => l_uc_descendant_tbl);
1680: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1681: RAISE FND_API.G_EXC_ERROR;
1682: END IF;
1683:
1684: j := 1;

Line 1681: RAISE FND_API.G_EXC_ERROR;

1677: x_msg_data => l_msg_data,
1678: p_uc_header_id => p_unit_header_id,
1679: x_uc_descendant_tbl => l_uc_descendant_tbl);
1680: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1681: RAISE FND_API.G_EXC_ERROR;
1682: END IF;
1683:
1684: j := 1;
1685: IF l_uc_descendant_tbl.FIRST IS NOT NULL THEN