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.

APPS.AHL_UTIL_UC_PKG dependencies on FND_API

Line 1165: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1161: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');
1162: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);
1163: FND_MSG_PUB.ADD;
1164: CLOSE csi_item_instance_csr;
1165: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:
1168: CLOSE csi_item_instance_csr;
1169:

Line 1279: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

1275: -- Pre-reqs :
1276: --
1277: -- Standard IN Parameters :
1278: -- p_api_version IN NUMBER Required
1279: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1280: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1281: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1282: -- Standard OUT Parameters :
1283: -- x_return_status OUT VARCHAR2 Required

Line 1280: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1276: --
1277: -- Standard IN Parameters :
1278: -- p_api_version IN NUMBER Required
1279: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1280: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1281: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1282: -- Standard OUT Parameters :
1283: -- x_return_status OUT VARCHAR2 Required
1284: -- x_msg_count OUT NUMBER Required

Line 1281: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1277: -- Standard IN Parameters :
1278: -- p_api_version IN NUMBER Required
1279: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1280: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1281: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1282: -- Standard OUT Parameters :
1283: -- x_return_status OUT VARCHAR2 Required
1284: -- x_msg_count OUT NUMBER Required
1285: -- x_msg_data OUT VARCHAR2 Required

Line 1302: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1298: --------------------------------------------------------------------------------------------
1299:
1300: PROCEDURE Invalidate_Instance(
1301: p_api_version IN NUMBER,
1302: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1305: x_return_status OUT NOCOPY VARCHAR2,
1306: x_msg_count OUT NOCOPY NUMBER,

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

1299:
1300: PROCEDURE Invalidate_Instance(
1301: p_api_version IN NUMBER,
1302: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1305: x_return_status OUT NOCOPY VARCHAR2,
1306: x_msg_count OUT NOCOPY NUMBER,
1307: x_msg_data OUT NOCOPY VARCHAR2,

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

1300: PROCEDURE Invalidate_Instance(
1301: p_api_version IN NUMBER,
1302: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1305: x_return_status OUT NOCOPY VARCHAR2,
1306: x_msg_count OUT NOCOPY NUMBER,
1307: x_msg_data OUT NOCOPY VARCHAR2,
1308: p_instance_tbl IN Instance_Tbl_Type

Line 1398: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1394: -- Standard start of API savepoint
1395: SAVEPOINT Invalidate_Instance;
1396:
1397: -- Standard call to check for call compatibility
1398: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1399: G_PKG_NAME) THEN
1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END IF;
1402:

Line 1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1396:
1397: -- Standard call to check for call compatibility
1398: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1399: G_PKG_NAME) THEN
1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END IF;
1402:
1403: -- Initialize message list if p_init_msg_list is set to TRUE
1404: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1404: IF FND_API.To_Boolean(p_init_msg_list) THEN

1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END IF;
1402:
1403: -- Initialize message list if p_init_msg_list is set to TRUE
1404: IF FND_API.To_Boolean(p_init_msg_list) THEN
1405: FND_MSG_PUB.Initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success

Line 1409: x_return_status := FND_API.G_RET_STS_SUCCESS;

1405: FND_MSG_PUB.Initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success
1409: x_return_status := FND_API.G_RET_STS_SUCCESS;
1410:
1411: -- Begin Processing
1412:
1413: -- Validating the instance table

Line 1452: RAISE FND_API.G_EXC_ERROR;

1448: x_msg_count => x_msg_count,
1449: x_msg_data => x_msg_data,
1450: p_subject_id=>l_chk_top_node_csr.csi_item_instance_id);
1451: IF x_msg_count > 0 THEN
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454: END IF; --parent_uc_header_id is not null
1455:
1456: END IF;

Line 1473: RAISE FND_API.G_EXC_ERROR;

1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data,
1471: p_subject_id=>item_instance_rec.csi_item_instance_id);
1472: IF x_msg_count > 0 THEN
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475:
1476: OPEN get_uc_header_info_csr(item_instance_rec.csi_item_instance_id );
1477: FETCH get_uc_header_info_csr into l_unit_config_header_id, l_unit_config_status_code;

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507:
1508: -- Check Error Message stack.
1509: x_msg_count := FND_MSG_PUB.count_msg;
1510: IF x_msg_count > 0 THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info

Line 1519: p_encoded => fnd_api.g_false

1515: -- Standard call to get message count and if count is 1, get message info
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => fnd_api.g_false
1520: );
1521:
1522: --commit the updates
1523: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1523: IF FND_API.TO_BOOLEAN(p_commit) THEN

1519: p_encoded => fnd_api.g_false
1520: );
1521:
1522: --commit the updates
1523: IF FND_API.TO_BOOLEAN(p_commit) THEN
1524: COMMIT;
1525: END IF;
1526:
1527:

Line 1529: WHEN FND_API.G_EXC_ERROR THEN

1525: END IF;
1526:
1527:
1528: EXCEPTION
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531: Rollback to Invalidate_Instance;
1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,

Line 1530: x_return_status := FND_API.G_RET_STS_ERROR;

1526:
1527:
1528: EXCEPTION
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531: Rollback to Invalidate_Instance;
1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => fnd_api.g_false);

Line 1534: p_encoded => fnd_api.g_false);

1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531: Rollback to Invalidate_Instance;
1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => fnd_api.g_false);
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: Rollback to Invalidate_Instance;
1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1531: Rollback to Invalidate_Instance;
1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => fnd_api.g_false);
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: Rollback to Invalidate_Instance;
1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1539: p_data => x_msg_data,

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => fnd_api.g_false);
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: Rollback to Invalidate_Instance;
1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => fnd_api.g_false);

Line 1540: p_encoded => fnd_api.g_false);

1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: Rollback to Invalidate_Instance;
1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => fnd_api.g_false);
1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: Rollback to Invalidate_Instance;
1544: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => fnd_api.g_false);
1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: Rollback to Invalidate_Instance;
1544: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1545: p_procedure_name => 'Invalidate_Instance',
1546: p_error_text => SQLERRM);

Line 1550: p_encoded => fnd_api.g_false);

1546: p_error_text => SQLERRM);
1547:
1548: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1549: p_data => x_msg_data,
1550: p_encoded => fnd_api.g_false);
1551: END Invalidate_Instance;
1552:
1553:
1554:

Line 1580: x_return_status := FND_API.G_RET_STS_SUCCESS;

1576: l_transaction_type_id number;
1577: l_csi_record_csr get_csi_record_csr%ROWTYPE;
1578:
1579: BEGIN
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581:
1582: --Define the l_csi_transaction_rec
1583: l_csi_transaction_rec.source_transaction_date := sysdate;
1584:

Line 1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1584:
1585: AHL_Util_UC_Pkg.GetCSI_Transaction_ID('UC_UPDATE',l_transaction_type_id,
1586: l_return_val);
1587: IF NOT(l_return_val) THEN
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
1590:
1591: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
1592:

Line 1609: p_init_msg_list => FND_API.G_TRUE,

1605:
1606: --Updating the csi_ii_relationships table
1607: CSI_II_Relationships_PUB.Update_Relationship(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: p_relationship_tbl => l_csi_relationship_tbl,
1613: p_txn_rec => l_csi_transaction_rec,

Line 1610: p_commit => FND_API.G_FALSE,

1606: --Updating the csi_ii_relationships table
1607: CSI_II_Relationships_PUB.Update_Relationship(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: p_relationship_tbl => l_csi_relationship_tbl,
1613: p_txn_rec => l_csi_transaction_rec,
1614: x_return_status => x_return_status,

Line 1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1607: CSI_II_Relationships_PUB.Update_Relationship(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: p_relationship_tbl => l_csi_relationship_tbl,
1613: p_txn_rec => l_csi_transaction_rec,
1614: x_return_status => x_return_status,
1615: x_msg_count => x_msg_count,

Line 1998: x_return_status := FND_API.G_RET_STS_SUCCESS;

1994: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1995: --For expiration operation, when copying to history, the record has already been expired.
1996: l_uc_header_rec get_uc_header%ROWTYPE;
1997: BEGIN
1998: x_return_status := FND_API.G_RET_STS_SUCCESS;
1999: --Get the maximum version number of the particualr UC from history table
2000: SELECT nvl(max(version_no), 0) INTO l_version_no
2001: FROM ahl_uc_headers_h
2002: WHERE unit_config_header_id = p_uc_header_id;

Line 2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2004: -- Insert into the exactly same record into ahl_unit_config_headers_h
2005: OPEN get_uc_header;
2006: FETCH get_uc_header INTO l_uc_header_rec;
2007: IF get_uc_header%NOTFOUND THEN
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2009: ELSE
2010: INSERT INTO ahl_uc_headers_h(
2011: unit_config_header_id,
2012: version_no,

Line 2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2076: END IF;
2077: CLOSE get_uc_header;
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: END;
2082:
2083: PROCEDURE get_root_uc_attr(
2084: p_uc_header_id IN NUMBER,

Line 2540: -- Function: This API will return FND_API.G_TRUE if a UC is in Quarantine or Deactivate

2536: END IF;
2537: RETURN l_uc_header_id;
2538: END;
2539:
2540: -- Function: This API will return FND_API.G_TRUE if a UC is in Quarantine or Deactivate
2541: -- Quarantine Status
2542: -- ACL :: Added for R12 changes.
2543: FUNCTION IS_UNIT_QUARANTINED(p_unit_header_id IN NUMBER,
2544: p_instance_id IN NUMBER) RETURN VARCHAR2 IS

Line 2565: RETURN FND_API.G_FALSE;

2561: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2562: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2563: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2564: END IF;
2565: RETURN FND_API.G_FALSE;
2566: ELSE
2567: -- else derive uc status code
2568: l_uc_status_code := GET_UC_STATUS_CODE(l_uc_header_id);
2569: -- if uc status code in quarantine / deactivate quarantine then return true

Line 2571: RETURN FND_API.G_TRUE;

2567: -- else derive uc status code
2568: l_uc_status_code := GET_UC_STATUS_CODE(l_uc_header_id);
2569: -- if uc status code in quarantine / deactivate quarantine then return true
2570: IF l_uc_status_code in (G_STATUS_QUARANTINE,G_STATUS_D_QUARANTINE) THEN
2571: RETURN FND_API.G_TRUE;
2572: ELSE
2573: -- else return false
2574: RETURN FND_API.G_FALSE;
2575: END IF;

Line 2574: RETURN FND_API.G_FALSE;

2570: IF l_uc_status_code in (G_STATUS_QUARANTINE,G_STATUS_D_QUARANTINE) THEN
2571: RETURN FND_API.G_TRUE;
2572: ELSE
2573: -- else return false
2574: RETURN FND_API.G_FALSE;
2575: END IF;
2576: END IF;
2577:
2578: END IS_UNIT_QUARANTINED;

Line 2591: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

2587: -- Pre-reqs :
2588: --
2589: -- Standard IN Parameters :
2590: -- p_api_version IN NUMBER Required
2591: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2592: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2593: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2594: -- Standard OUT Parameters :
2595: -- x_return_status OUT VARCHAR2 Required

Line 2592: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2588: --
2589: -- Standard IN Parameters :
2590: -- p_api_version IN NUMBER Required
2591: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2592: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2593: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2594: -- Standard OUT Parameters :
2595: -- x_return_status OUT VARCHAR2 Required
2596: -- x_msg_count OUT NUMBER Required

Line 2593: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2589: -- Standard IN Parameters :
2590: -- p_api_version IN NUMBER Required
2591: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2592: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2593: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2594: -- Standard OUT Parameters :
2595: -- x_return_status OUT VARCHAR2 Required
2596: -- x_msg_count OUT NUMBER Required
2597: -- x_msg_data OUT VARCHAR2 Required

Line 2616: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2612:
2613: PROCEDURE Check_Invalidate_Instance
2614: (
2615: p_api_version IN NUMBER,
2616: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2617: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2619: p_instance_tbl IN Instance_Tbl_Type2,
2620: p_operator IN VARCHAR2,

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

2613: PROCEDURE Check_Invalidate_Instance
2614: (
2615: p_api_version IN NUMBER,
2616: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2617: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2619: p_instance_tbl IN Instance_Tbl_Type2,
2620: p_operator IN VARCHAR2,
2621: x_return_status OUT NOCOPY VARCHAR2,

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

2614: (
2615: p_api_version IN NUMBER,
2616: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2617: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2619: p_instance_tbl IN Instance_Tbl_Type2,
2620: p_operator IN VARCHAR2,
2621: x_return_status OUT NOCOPY VARCHAR2,
2622: x_msg_count OUT NOCOPY NUMBER,

Line 2722: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

2718: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2719: END IF;
2720:
2721: -- Standard call to check for call compatibility
2722: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
2723: l_api_name, G_PKG_NAME) THEN
2724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: END IF;
2726:

Line 2724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2720:
2721: -- Standard call to check for call compatibility
2722: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
2723: l_api_name, G_PKG_NAME) THEN
2724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: END IF;
2726:
2727: -- Initialize message list if p_init_msg_list is set to TRUE
2728: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2728: IF FND_API.To_Boolean(p_init_msg_list) THEN

2724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: END IF;
2726:
2727: -- Initialize message list if p_init_msg_list is set to TRUE
2728: IF FND_API.To_Boolean(p_init_msg_list) THEN
2729: FND_MSG_PUB.Initialize;
2730: END IF;
2731:
2732: -- Initialize API return status to success

Line 2733: x_return_status := FND_API.G_RET_STS_SUCCESS;

2729: FND_MSG_PUB.Initialize;
2730: END IF;
2731:
2732: -- Initialize API return status to success
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: -- Validating the instance table
2736: IF (l_instance_tbl.COUNT >0) THEN
2737: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2820: x_return_status := FND_API.G_RET_STS_ERROR;

2816: END IF;
2817:
2818: IF (l_valid_UC_lst IS NOT NULL) THEN
2819: -- setting the return status to error
2820: x_return_status := FND_API.G_RET_STS_ERROR;
2821:
2822: -- reducing the UCLIST token to appropriate length
2823: IF (length(l_valid_UC_lst) > 1750) THEN
2824: l_valid_UC_lst := substr(l_valid_UC_lst, 1, 1747);

Line 2852: WHEN FND_API.G_EXC_ERROR THEN

2848: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2849: END IF;
2850:
2851: EXCEPTION
2852: WHEN FND_API.G_EXC_ERROR THEN
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);

Line 2853: x_return_status := FND_API.G_RET_STS_ERROR;

2849: END IF;
2850:
2851: EXCEPTION
2852: WHEN FND_API.G_EXC_ERROR THEN
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);
2857:

Line 2856: p_encoded => fnd_api.g_false);

2852: WHEN FND_API.G_EXC_ERROR THEN
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);
2857:
2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);
2857:
2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => fnd_api.g_false);

Line 2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);
2857:
2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => fnd_api.g_false);
2863:

Line 2862: p_encoded => fnd_api.g_false);

2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => fnd_api.g_false);
2863:
2864: WHEN OTHERS THEN
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2861: p_data => x_msg_data,
2862: p_encoded => fnd_api.g_false);
2863:
2864: WHEN OTHERS THEN
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
2867: p_procedure_name => 'Check_Invalidate_Instance',
2868: p_error_text => SQLERRM);
2869:

Line 2872: p_encoded => fnd_api.g_false);

2868: p_error_text => SQLERRM);
2869:
2870: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2871: p_data => x_msg_data,
2872: p_encoded => fnd_api.g_false);
2873:
2874: END Check_Invalidate_Instance;
2875:
2876: --------------------------------------------------------------------------------------------

Line 2881: -- The return value x_matches_flag will be FND_API.G_TRUE or FND_API.G_FALSE.

2877: -- Added by jaramana on March 10, 2008 for fixing the Bug 6723950 (FP of 6720010)
2878: -- This API will validate if the instance can become the new item through part change.
2879: -- p_instance_id can be currently in an IB Tree or UC or it may be a stand alone instance.
2880: -- It may also be the root node of a unit.
2881: -- The return value x_matches_flag will be FND_API.G_TRUE or FND_API.G_FALSE.
2882: PROCEDURE Item_Matches_Instance_Pos(p_inventory_item_id IN NUMBER,
2883: p_item_revision IN VARCHAR2 default NULL,
2884: p_instance_id IN NUMBER,
2885: x_matches_flag OUT NOCOPY VARCHAR2) IS

Line 2939: x_matches_flag := FND_API.G_TRUE;

2935: 'At the start of the procedure. p_inventory_item_id = ' || p_inventory_item_id ||
2936: ', p_item_revision = ' || p_item_revision ||
2937: ', p_instance_id = ' || p_instance_id);
2938: END IF;
2939: x_matches_flag := FND_API.G_TRUE;
2940: IF (p_instance_id IS NOT NULL AND p_inventory_item_id IS NOT NULL) THEN
2941: -- Check if the instance is a unit configuration
2942: OPEN get_uc_header_id_csr;
2943: FETCH get_uc_header_id_csr INTO l_uc_header_id, l_master_config_id;

Line 2963: x_matches_flag := FND_API.G_TRUE;

2959: CLOSE get_pos_reference_csr;
2960: IF (l_pos_reference IS NULL) THEN
2961: -- Instance is either not installed or does not belong to a UC
2962: -- Cannot validate item against item group - just return TRUE
2963: x_matches_flag := FND_API.G_TRUE;
2964: ELSE
2965: -- Get Item group of position reference
2966: OPEN get_mc_ig_csr(l_pos_reference);
2967: FETCH get_mc_ig_csr INTO l_node_ig_id;

Line 2984: x_matches_flag := FND_API.G_TRUE;

2980: -- Check if the Item Group has the passed in item/revision
2981: OPEN item_group_has_item_csr(l_node_ig_id);
2982: FETCH item_group_has_item_csr INTO l_temp_num;
2983: IF(item_group_has_item_csr%FOUND) THEN
2984: x_matches_flag := FND_API.G_TRUE;
2985: ELSE
2986: x_matches_flag := FND_API.G_FALSE;
2987: END IF;
2988: CLOSE item_group_has_item_csr;

Line 2986: x_matches_flag := FND_API.G_FALSE;

2982: FETCH item_group_has_item_csr INTO l_temp_num;
2983: IF(item_group_has_item_csr%FOUND) THEN
2984: x_matches_flag := FND_API.G_TRUE;
2985: ELSE
2986: x_matches_flag := FND_API.G_FALSE;
2987: END IF;
2988: CLOSE item_group_has_item_csr;
2989: END IF;
2990: