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 1160: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1156: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');
1157: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);
1158: FND_MSG_PUB.ADD;
1159: CLOSE csi_item_instance_csr;
1160: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: CLOSE csi_item_instance_csr;
1164:

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

1270: -- Pre-reqs :
1271: --
1272: -- Standard IN Parameters :
1273: -- p_api_version IN NUMBER Required
1274: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1275: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1276: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1277: -- Standard OUT Parameters :
1278: -- x_return_status OUT VARCHAR2 Required

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

1271: --
1272: -- Standard IN Parameters :
1273: -- p_api_version IN NUMBER Required
1274: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1275: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1276: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1277: -- Standard OUT Parameters :
1278: -- x_return_status OUT VARCHAR2 Required
1279: -- x_msg_count OUT NUMBER Required

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

1272: -- Standard IN Parameters :
1273: -- p_api_version IN NUMBER Required
1274: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1275: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1276: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1277: -- Standard OUT Parameters :
1278: -- x_return_status OUT VARCHAR2 Required
1279: -- x_msg_count OUT NUMBER Required
1280: -- x_msg_data OUT VARCHAR2 Required

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

1293: --------------------------------------------------------------------------------------------
1294:
1295: PROCEDURE Invalidate_Instance(
1296: p_api_version IN NUMBER,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,

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

1294:
1295: PROCEDURE Invalidate_Instance(
1296: p_api_version IN NUMBER,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1302: x_msg_data OUT NOCOPY VARCHAR2,

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

1295: PROCEDURE Invalidate_Instance(
1296: p_api_version IN NUMBER,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1302: x_msg_data OUT NOCOPY VARCHAR2,
1303: p_instance_tbl IN Instance_Tbl_Type

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

1389: -- Standard start of API savepoint
1390: SAVEPOINT Invalidate_Instance;
1391:
1392: -- Standard call to check for call compatibility
1393: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1394: G_PKG_NAME) THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:

Line 1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1391:
1392: -- Standard call to check for call compatibility
1393: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1394: G_PKG_NAME) THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE
1399: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1399: IF FND_API.To_Boolean(p_init_msg_list) THEN

1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE
1399: IF FND_API.To_Boolean(p_init_msg_list) THEN
1400: FND_MSG_PUB.Initialize;
1401: END IF;
1402:
1403: -- Initialize API return status to success

Line 1404: x_return_status := FND_API.G_RET_STS_SUCCESS;

1400: FND_MSG_PUB.Initialize;
1401: END IF;
1402:
1403: -- Initialize API return status to success
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:
1406: -- Begin Processing
1407:
1408: -- Validating the instance table

Line 1447: RAISE FND_API.G_EXC_ERROR;

1443: x_msg_count => x_msg_count,
1444: x_msg_data => x_msg_data,
1445: p_subject_id=>l_chk_top_node_csr.csi_item_instance_id);
1446: IF x_msg_count > 0 THEN
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449: END IF; --parent_uc_header_id is not null
1450:
1451: END IF;

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464: x_msg_count => x_msg_count,
1465: x_msg_data => x_msg_data,
1466: p_subject_id=>item_instance_rec.csi_item_instance_id);
1467: IF x_msg_count > 0 THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470:
1471: OPEN get_uc_header_info_csr(item_instance_rec.csi_item_instance_id );
1472: FETCH get_uc_header_info_csr into l_unit_config_header_id, l_unit_config_status_code;

Line 1506: RAISE FND_API.G_EXC_ERROR;

1502:
1503: -- Check Error Message stack.
1504: x_msg_count := FND_MSG_PUB.count_msg;
1505: IF x_msg_count > 0 THEN
1506: RAISE FND_API.G_EXC_ERROR;
1507: END IF;
1508:
1509:
1510: -- Standard call to get message count and if count is 1, get message info

Line 1514: p_encoded => fnd_api.g_false

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

Line 1518: IF FND_API.TO_BOOLEAN(p_commit) THEN

1514: p_encoded => fnd_api.g_false
1515: );
1516:
1517: --commit the updates
1518: IF FND_API.TO_BOOLEAN(p_commit) THEN
1519: COMMIT;
1520: END IF;
1521:
1522:

Line 1524: WHEN FND_API.G_EXC_ERROR THEN

1520: END IF;
1521:
1522:
1523: EXCEPTION
1524: WHEN FND_API.G_EXC_ERROR THEN
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: Rollback to Invalidate_Instance;
1527: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1528: p_data => x_msg_data,

Line 1525: x_return_status := FND_API.G_RET_STS_ERROR;

1521:
1522:
1523: EXCEPTION
1524: WHEN FND_API.G_EXC_ERROR THEN
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: Rollback to Invalidate_Instance;
1527: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1528: p_data => x_msg_data,
1529: p_encoded => fnd_api.g_false);

Line 1529: p_encoded => fnd_api.g_false);

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

Line 1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1535: p_encoded => fnd_api.g_false);

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

Line 1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1533: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1534: p_data => x_msg_data,
1535: p_encoded => fnd_api.g_false);
1536: WHEN OTHERS THEN
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: Rollback to Invalidate_Instance;
1539: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1540: p_procedure_name => 'Invalidate_Instance',
1541: p_error_text => SQLERRM);

Line 1545: p_encoded => fnd_api.g_false);

1541: p_error_text => SQLERRM);
1542:
1543: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1544: p_data => x_msg_data,
1545: p_encoded => fnd_api.g_false);
1546: END Invalidate_Instance;
1547:
1548:
1549:

Line 1575: x_return_status := FND_API.G_RET_STS_SUCCESS;

1571: l_transaction_type_id number;
1572: l_csi_record_csr get_csi_record_csr%ROWTYPE;
1573:
1574: BEGIN
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: --Define the l_csi_transaction_rec
1578: l_csi_transaction_rec.source_transaction_date := sysdate;
1579:

Line 1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1579:
1580: AHL_Util_UC_Pkg.GetCSI_Transaction_ID('UC_UPDATE',l_transaction_type_id,
1581: l_return_val);
1582: IF NOT(l_return_val) THEN
1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;
1585:
1586: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
1587:

Line 1604: p_init_msg_list => FND_API.G_TRUE,

1600:
1601: --Updating the csi_ii_relationships table
1602: CSI_II_Relationships_PUB.Update_Relationship(
1603: p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_TRUE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: p_relationship_tbl => l_csi_relationship_tbl,
1608: p_txn_rec => l_csi_transaction_rec,

Line 1605: p_commit => FND_API.G_FALSE,

1601: --Updating the csi_ii_relationships table
1602: CSI_II_Relationships_PUB.Update_Relationship(
1603: p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_TRUE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: p_relationship_tbl => l_csi_relationship_tbl,
1608: p_txn_rec => l_csi_transaction_rec,
1609: x_return_status => x_return_status,

Line 1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1602: CSI_II_Relationships_PUB.Update_Relationship(
1603: p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_TRUE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: p_relationship_tbl => l_csi_relationship_tbl,
1608: p_txn_rec => l_csi_transaction_rec,
1609: x_return_status => x_return_status,
1610: x_msg_count => x_msg_count,

Line 1993: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1999: -- Insert into the exactly same record into ahl_unit_config_headers_h
2000: OPEN get_uc_header;
2001: FETCH get_uc_header INTO l_uc_header_rec;
2002: IF get_uc_header%NOTFOUND THEN
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: ELSE
2005: INSERT INTO ahl_uc_headers_h(
2006: unit_config_header_id,
2007: version_no,

Line 2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2071: END IF;
2072: CLOSE get_uc_header;
2073: EXCEPTION
2074: WHEN OTHERS THEN
2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: END;
2077:
2078: PROCEDURE get_root_uc_attr(
2079: p_uc_header_id IN NUMBER,

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

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

Line 2560: RETURN FND_API.G_FALSE;

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

Line 2566: RETURN FND_API.G_TRUE;

2562: -- else derive uc status code
2563: l_uc_status_code := GET_UC_STATUS_CODE(l_uc_header_id);
2564: -- if uc status code in quarantine / deactivate quarantine then return true
2565: IF l_uc_status_code in (G_STATUS_QUARANTINE,G_STATUS_D_QUARANTINE) THEN
2566: RETURN FND_API.G_TRUE;
2567: ELSE
2568: -- else return false
2569: RETURN FND_API.G_FALSE;
2570: END IF;

Line 2569: RETURN FND_API.G_FALSE;

2565: IF l_uc_status_code in (G_STATUS_QUARANTINE,G_STATUS_D_QUARANTINE) THEN
2566: RETURN FND_API.G_TRUE;
2567: ELSE
2568: -- else return false
2569: RETURN FND_API.G_FALSE;
2570: END IF;
2571: END IF;
2572:
2573: END IS_UNIT_QUARANTINED;

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

2582: -- Pre-reqs :
2583: --
2584: -- Standard IN Parameters :
2585: -- p_api_version IN NUMBER Required
2586: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2587: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2588: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2589: -- Standard OUT Parameters :
2590: -- x_return_status OUT VARCHAR2 Required

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

2583: --
2584: -- Standard IN Parameters :
2585: -- p_api_version IN NUMBER Required
2586: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2587: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2588: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2589: -- Standard OUT Parameters :
2590: -- x_return_status OUT VARCHAR2 Required
2591: -- x_msg_count OUT NUMBER Required

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

2584: -- Standard IN Parameters :
2585: -- p_api_version IN NUMBER Required
2586: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
2587: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2588: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2589: -- Standard OUT Parameters :
2590: -- x_return_status OUT VARCHAR2 Required
2591: -- x_msg_count OUT NUMBER Required
2592: -- x_msg_data OUT VARCHAR2 Required

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

2607:
2608: PROCEDURE Check_Invalidate_Instance
2609: (
2610: p_api_version IN NUMBER,
2611: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2614: p_instance_tbl IN Instance_Tbl_Type2,
2615: p_operator IN VARCHAR2,

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

2608: PROCEDURE Check_Invalidate_Instance
2609: (
2610: p_api_version IN NUMBER,
2611: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2614: p_instance_tbl IN Instance_Tbl_Type2,
2615: p_operator IN VARCHAR2,
2616: x_return_status OUT NOCOPY VARCHAR2,

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

2609: (
2610: p_api_version IN NUMBER,
2611: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2614: p_instance_tbl IN Instance_Tbl_Type2,
2615: p_operator IN VARCHAR2,
2616: x_return_status OUT NOCOPY VARCHAR2,
2617: x_msg_count OUT NOCOPY NUMBER,

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

2713: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2714: END IF;
2715:
2716: -- Standard call to check for call compatibility
2717: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
2718: l_api_name, G_PKG_NAME) THEN
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721:

Line 2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2715:
2716: -- Standard call to check for call compatibility
2717: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
2718: l_api_name, G_PKG_NAME) THEN
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721:
2722: -- Initialize message list if p_init_msg_list is set to TRUE
2723: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2723: IF FND_API.To_Boolean(p_init_msg_list) THEN

2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721:
2722: -- Initialize message list if p_init_msg_list is set to TRUE
2723: IF FND_API.To_Boolean(p_init_msg_list) THEN
2724: FND_MSG_PUB.Initialize;
2725: END IF;
2726:
2727: -- Initialize API return status to success

Line 2728: x_return_status := FND_API.G_RET_STS_SUCCESS;

2724: FND_MSG_PUB.Initialize;
2725: END IF;
2726:
2727: -- Initialize API return status to success
2728: x_return_status := FND_API.G_RET_STS_SUCCESS;
2729:
2730: -- Validating the instance table
2731: IF (l_instance_tbl.COUNT >0) THEN
2732: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2815: x_return_status := FND_API.G_RET_STS_ERROR;

2811: END IF;
2812:
2813: IF (l_valid_UC_lst IS NOT NULL) THEN
2814: -- setting the return status to error
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816:
2817: -- reducing the UCLIST token to appropriate length
2818: IF (length(l_valid_UC_lst) > 1750) THEN
2819: l_valid_UC_lst := substr(l_valid_UC_lst, 1, 1747);

Line 2847: WHEN FND_API.G_EXC_ERROR THEN

2843: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2844: END IF;
2845:
2846: EXCEPTION
2847: WHEN FND_API.G_EXC_ERROR THEN
2848: x_return_status := FND_API.G_RET_STS_ERROR;
2849: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2850: p_data => x_msg_data,
2851: p_encoded => fnd_api.g_false);

Line 2848: x_return_status := FND_API.G_RET_STS_ERROR;

2844: END IF;
2845:
2846: EXCEPTION
2847: WHEN FND_API.G_EXC_ERROR THEN
2848: x_return_status := FND_API.G_RET_STS_ERROR;
2849: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2850: p_data => x_msg_data,
2851: p_encoded => fnd_api.g_false);
2852:

Line 2851: p_encoded => fnd_api.g_false);

2847: WHEN FND_API.G_EXC_ERROR THEN
2848: x_return_status := FND_API.G_RET_STS_ERROR;
2849: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2850: p_data => x_msg_data,
2851: p_encoded => fnd_api.g_false);
2852:
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2857: p_encoded => fnd_api.g_false);

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

Line 2860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2856: p_data => x_msg_data,
2857: p_encoded => fnd_api.g_false);
2858:
2859: WHEN OTHERS THEN
2860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2861: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
2862: p_procedure_name => 'Check_Invalidate_Instance',
2863: p_error_text => SQLERRM);
2864:

Line 2867: p_encoded => fnd_api.g_false);

2863: p_error_text => SQLERRM);
2864:
2865: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2866: p_data => x_msg_data,
2867: p_encoded => fnd_api.g_false);
2868:
2869: END Check_Invalidate_Instance;
2870:
2871: --------------------------------------------------------------------------------------------

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

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

Line 2934: x_matches_flag := FND_API.G_TRUE;

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

Line 2958: x_matches_flag := FND_API.G_TRUE;

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

Line 2979: x_matches_flag := FND_API.G_TRUE;

2975: -- Check if the Item Group has the passed in item/revision
2976: OPEN item_group_has_item_csr(l_node_ig_id);
2977: FETCH item_group_has_item_csr INTO l_temp_num;
2978: IF(item_group_has_item_csr%FOUND) THEN
2979: x_matches_flag := FND_API.G_TRUE;
2980: ELSE
2981: x_matches_flag := FND_API.G_FALSE;
2982: END IF;
2983: CLOSE item_group_has_item_csr;

Line 2981: x_matches_flag := FND_API.G_FALSE;

2977: FETCH item_group_has_item_csr INTO l_temp_num;
2978: IF(item_group_has_item_csr%FOUND) THEN
2979: x_matches_flag := FND_API.G_TRUE;
2980: ELSE
2981: x_matches_flag := FND_API.G_FALSE;
2982: END IF;
2983: CLOSE item_group_has_item_csr;
2984: END IF;
2985: