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_UC_INSTANCE_PVT dependencies on FND_LOG

Line 440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

436: IF FND_API.to_boolean( p_init_msg_list ) THEN
437: FND_MSG_PUB.initialize;
438: END IF;
439:
440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
442: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
443: 'At the start of the procedure');
444: END IF;

Line 441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

437: FND_MSG_PUB.initialize;
438: END IF;
439:
440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
442: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
443: 'At the start of the procedure');
444: END IF;
445:

Line 637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

633: END IF;
634: END IF;
635: END IF; --For production user, no need to change any one of the status.
636:
637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
639: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
640: 'At the end of the procedure');
641: END IF;

Line 638: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

634: END IF;
635: END IF; --For production user, no need to change any one of the status.
636:
637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
639: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
640: 'At the end of the procedure');
641: END IF;
642: --Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

883: IF FND_API.to_boolean( p_init_msg_list ) THEN
884: FND_MSG_PUB.initialize;
885: END IF;
886:
887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
889: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
890: 'At the start of the procedure');
891: END IF;

Line 888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

884: FND_MSG_PUB.initialize;
885: END IF;
886:
887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
889: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
890: 'At the start of the procedure');
891: END IF;
892:

Line 1220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1216: END IF;
1217: END IF;
1218: END IF;
1219:
1220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1222: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
1223: 'At the end of the procedure');
1224: END IF;

Line 1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1217: END IF;
1218: END IF;
1219:
1220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1222: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
1223: 'At the end of the procedure');
1224: END IF;
1225:

Line 1408: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1404: IF FND_API.to_boolean( p_init_msg_list ) THEN
1405: FND_MSG_PUB.initialize;
1406: END IF;
1407:
1408: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1410: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1411: 'At the start of the procedure');
1412: END IF;

Line 1409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1405: FND_MSG_PUB.initialize;
1406: END IF;
1407:
1408: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1410: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1411: 'At the start of the procedure');
1412: END IF;
1413:

Line 1434: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1430: CLOSE check_uc_header;
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: ELSE
1433:
1434: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1436: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
1437: ' p_uc_header_id = '||p_uc_header_id||
1438: ' IS_UNIT_QUARANTINED ='||ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null));

Line 1435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: ELSE
1433:
1434: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1436: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
1437: ' p_uc_header_id = '||p_uc_header_id||
1438: ' IS_UNIT_QUARANTINED ='||ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null));
1439: END IF;

Line 1540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1536: --mpothuku End
1537: l_uc_instance_rec := p_uc_instance_rec;
1538:
1539: /*
1540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1541: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','The input rec is as following:');
1542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1543: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_id = '||l_uc_instance_rec.instance_id);
1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1538:
1539: /*
1540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1541: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','The input rec is as following:');
1542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1543: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_id = '||l_uc_instance_rec.instance_id);
1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1545: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','obj_ver_num = '||l_uc_instance_rec.object_version_number);
1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1541: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','The input rec is as following:');
1542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1543: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_id = '||l_uc_instance_rec.instance_id);
1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1545: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','obj_ver_num = '||l_uc_instance_rec.object_version_number);
1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1547: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_num = '||l_uc_instance_rec.instance_number);
1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1543: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_id = '||l_uc_instance_rec.instance_id);
1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1545: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','obj_ver_num = '||l_uc_instance_rec.object_version_number);
1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1547: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_num = '||l_uc_instance_rec.instance_number);
1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','inv_item_id = '||l_uc_instance_rec.inventory_item_id);
1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1545: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','obj_ver_num = '||l_uc_instance_rec.object_version_number);
1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1547: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_num = '||l_uc_instance_rec.instance_number);
1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','inv_item_id = '||l_uc_instance_rec.inventory_item_id);
1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1551: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','org_id = '||l_uc_instance_rec.inventory_org_id);
1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1547: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','instance_num = '||l_uc_instance_rec.instance_number);
1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','inv_item_id = '||l_uc_instance_rec.inventory_item_id);
1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1551: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','org_id = '||l_uc_instance_rec.inventory_org_id);
1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1553: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','serial_no = '||l_uc_instance_rec.serial_number);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','inv_item_id = '||l_uc_instance_rec.inventory_item_id);
1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1551: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','org_id = '||l_uc_instance_rec.inventory_org_id);
1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1553: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','serial_no = '||l_uc_instance_rec.serial_number);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1555: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','lot_no = '||l_uc_instance_rec.lot_number);
1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1551: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','org_id = '||l_uc_instance_rec.inventory_org_id);
1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1553: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','serial_no = '||l_uc_instance_rec.serial_number);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1555: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','lot_no = '||l_uc_instance_rec.lot_number);
1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1557: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','quantity = '||l_uc_instance_rec.quantity);
1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1553: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','serial_no = '||l_uc_instance_rec.serial_number);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1555: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','lot_no = '||l_uc_instance_rec.lot_number);
1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1557: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','quantity = '||l_uc_instance_rec.quantity);
1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1559: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','uom_code = '||l_uc_instance_rec.uom_code);
1560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1555: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','lot_no = '||l_uc_instance_rec.lot_number);
1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1557: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','quantity = '||l_uc_instance_rec.quantity);
1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1559: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','uom_code = '||l_uc_instance_rec.uom_code);
1560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1561: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','install_date = '||l_uc_instance_rec.install_date);
1562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1557: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','quantity = '||l_uc_instance_rec.quantity);
1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1559: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','uom_code = '||l_uc_instance_rec.uom_code);
1560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1561: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','install_date = '||l_uc_instance_rec.install_date);
1562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1563: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','revision = '||l_uc_instance_rec.revision);
1564: */

Line 1562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1559: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','uom_code = '||l_uc_instance_rec.uom_code);
1560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1561: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','install_date = '||l_uc_instance_rec.install_date);
1562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1563: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API','revision = '||l_uc_instance_rec.revision);
1564: */
1565:
1566: --Convert serial_number_tag_meaning to its code

Line 1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1774: IF (l_uc_instance_rec.attribute30 = FND_API.G_MISS_CHAR) THEN
1775: l_uc_instance_rec.attribute30 := NULL;
1776: END IF;
1777:
1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1780: ' l_old_uc_instance_rec.instance_id => '||l_old_uc_instance_rec.instance_id||
1781: ' l_old_uc_instance_rec.sn_tag_code => '||l_old_uc_instance_rec.sn_tag_code ||
1782: ' l_uc_instance_rec.sn_tag_code =>' || l_uc_instance_rec.sn_tag_code);

Line 1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

1775: l_uc_instance_rec.attribute30 := NULL;
1776: END IF;
1777:
1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1780: ' l_old_uc_instance_rec.instance_id => '||l_old_uc_instance_rec.instance_id||
1781: ' l_old_uc_instance_rec.sn_tag_code => '||l_old_uc_instance_rec.sn_tag_code ||
1782: ' l_uc_instance_rec.sn_tag_code =>' || l_uc_instance_rec.sn_tag_code);
1783: END IF;

Line 2051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2047: even when the return status is S when the serial number is changed.
2048: **/
2049: --Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2050: l_msg_count := FND_MSG_PUB.count_msg;
2051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2053: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2054: 'l_msg_count='||l_msg_count||' x_return_status='||x_return_status);
2055: END IF;

Line 2052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2048: **/
2049: --Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2050: l_msg_count := FND_MSG_PUB.count_msg;
2051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2053: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2054: 'l_msg_count='||l_msg_count||' x_return_status='||x_return_status);
2055: END IF;
2056: IF l_msg_count > 0 THEN

Line 2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155: END IF;
2156: END IF; --For production user, no need to change any one of the status.
2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2159: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2160: 'At the end of the procedure');
2161: END IF;

Line 2158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2154: END IF;
2155: END IF;
2156: END IF; --For production user, no need to change any one of the status.
2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2159: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2160: 'At the end of the procedure');
2161: END IF;
2162:

Line 2170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2166: returns a Confirmation/Warning Message even when the status is S
2167: while changing the serial number.
2168: --Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2169: l_msg_count := FND_MSG_PUB.count_msg;
2170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2172: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2173: 'l_msg_count='||l_msg_count||' x_return_status='||x_return_status);
2174: END IF;

Line 2171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2167: while changing the serial number.
2168: --Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2169: l_msg_count := FND_MSG_PUB.count_msg;
2170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2172: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
2173: 'l_msg_count='||l_msg_count||' x_return_status='||x_return_status);
2174: END IF;
2175:

Line 2447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2443: IF FND_API.to_boolean( p_init_msg_list ) THEN
2444: FND_MSG_PUB.initialize;
2445: END IF;
2446:
2447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2449: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
2450: 'At the start of the procedure');
2451: END IF;

Line 2448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2444: FND_MSG_PUB.initialize;
2445: END IF;
2446:
2447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2449: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
2450: 'At the start of the procedure');
2451: END IF;
2452:

Line 2989: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2985: l_new_csi_instance_ovn := l_csi_instance_rec.object_version_number;
2986: p_x_uc_instance_rec.instance_id := l_new_instance_id;
2987: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
2988:
2989: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2991: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
2992: ' After calling create_item_instance and instance_id = '||l_csi_instance_rec.instance_id||
2993: ' l_return_status ='||l_return_status||

Line 2990: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2986: p_x_uc_instance_rec.instance_id := l_new_instance_id;
2987: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
2988:
2989: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2991: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
2992: ' After calling create_item_instance and instance_id = '||l_csi_instance_rec.instance_id||
2993: ' l_return_status ='||l_return_status||
2994: ' p_x_uc_instance_rec.instance_id='||p_x_uc_instance_rec.instance_id);

Line 3061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3057: --The parameter p_uc_header_id is not necessarily the parent uc_header_id of the newly
3058: --installed instance.
3059:
3060: --dbms_output.put_line('Before calling create uc_header API:...');
3061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3063: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3064: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3065: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||

Line 3062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3058: --installed instance.
3059:
3060: --dbms_output.put_line('Before calling create uc_header API:...');
3061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3063: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3064: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3065: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||
3066: ' p_x_sub_uc_rec.mc_name='||p_x_sub_uc_rec.mc_name||

Line 3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3078: x_msg_count => l_msg_count,
3079: x_msg_data => l_msg_data,
3080: p_x_uc_header_rec => p_x_sub_uc_rec);
3081:
3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3084: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3085: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3086: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||

Line 3083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3079: x_msg_data => l_msg_data,
3080: p_x_uc_header_rec => p_x_sub_uc_rec);
3081:
3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3084: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3085: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3086: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||
3087: ' p_x_sub_uc_rec.mc_name='||p_x_sub_uc_rec.mc_name||

Line 3206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3202: FND_MSG_PUB.add;
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: END IF;
3205: ELSIF (l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT')) THEN
3206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
3209: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
3210: 'l_root_uc_ovn='||l_root_uc_ovn);

Line 3207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: END IF;
3205: ELSIF (l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT')) THEN
3206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
3209: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
3210: 'l_root_uc_ovn='||l_root_uc_ovn);
3211: END IF;

Line 3246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: END IF;
3244: END IF;
3245:
3246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3248: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
3249: 'At the end of the procedure');
3250: END IF;

Line 3247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3243: END IF;
3244: END IF;
3245:
3246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3248: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
3249: 'At the end of the procedure');
3250: END IF;
3251:

Line 3647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3643: IF FND_API.to_boolean( p_init_msg_list ) THEN
3644: FND_MSG_PUB.initialize;
3645: END IF;
3646:
3647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3649: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3650: 'At the start of the procedure');
3651: END IF;

Line 3648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3644: FND_MSG_PUB.initialize;
3645: END IF;
3646:
3647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3649: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3650: 'At the start of the procedure');
3651: END IF;
3652:

Line 4041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4037: --need to create a new csi_ii_relationship record
4038: OPEN check_extra_node(p_parent_instance_id, p_instance_id);
4039: FETCH check_extra_node INTO l_csi_relationship_id, l_object_version_number;
4040: IF check_extra_node%FOUND THEN
4041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4043: ' sibling extra node found'||
4044: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4045: END IF;

Line 4042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

4038: OPEN check_extra_node(p_parent_instance_id, p_instance_id);
4039: FETCH check_extra_node INTO l_csi_relationship_id, l_object_version_number;
4040: IF check_extra_node%FOUND THEN
4041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4043: ' sibling extra node found'||
4044: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4045: END IF;
4046:

Line 4082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4078: OPEN check_unasgnd_extra_node_csr(p_parent_instance_id, p_instance_id);
4079: FETCH check_unasgnd_extra_node_csr INTO l_csi_relationship_id, l_object_version_number;
4080:
4081: IF check_unasgnd_extra_node_csr%FOUND THEN
4082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4084: ' extra node attached to any of the parents uptill root found'||
4085: ' p_parent_instance_id => '||p_parent_instance_id||
4086: ' p_instance_id => '||p_instance_id||

Line 4083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

4079: FETCH check_unasgnd_extra_node_csr INTO l_csi_relationship_id, l_object_version_number;
4080:
4081: IF check_unasgnd_extra_node_csr%FOUND THEN
4082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4084: ' extra node attached to any of the parents uptill root found'||
4085: ' p_parent_instance_id => '||p_parent_instance_id||
4086: ' p_instance_id => '||p_instance_id||
4087: ' p_csi_ii_ovn => '||p_csi_ii_ovn);

Line 4125: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4121: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: END IF;
4124:
4125: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4127: ' unassigned extra node relationship expired');
4128: END IF;
4129:

Line 4126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: END IF;
4124:
4125: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4127: ' unassigned extra node relationship expired');
4128: END IF;
4129:
4130: -- create new relationship

Line 4151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4147: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: END IF;
4150:
4151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4153: ' unassigned extra node new relationship created');
4154: END IF;
4155: ELSE

Line 4152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: END IF;
4150:
4151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4153: ' unassigned extra node new relationship created');
4154: END IF;
4155: ELSE
4156: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4156: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4153: ' unassigned extra node new relationship created');
4154: END IF;
4155: ELSE
4156: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4158: ' free standing instance found'||
4159: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4160: END IF;

Line 4157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

4153: ' unassigned extra node new relationship created');
4154: END IF;
4155: ELSE
4156: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4158: ' free standing instance found'||
4159: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4160: END IF;
4161:

Line 4345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4341: FND_MSG_PUB.add;
4342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4343: END IF;
4344: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
4345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4347: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
4348: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
4349: 'l_root_uc_ovn='||l_root_uc_ovn);

Line 4346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4343: END IF;
4344: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
4345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4347: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
4348: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
4349: 'l_root_uc_ovn='||l_root_uc_ovn);
4350: END IF;

Line 4385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END IF;
4383: END IF;
4384:
4385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4386: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4387: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
4388: 'At the end of the procedure');
4389: END IF;

Line 4386: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4382: END IF;
4383: END IF;
4384:
4385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4386: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4387: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
4388: 'At the end of the procedure');
4389: END IF;
4390:

Line 4494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4490: IF FND_API.to_boolean(p_init_msg_list) THEN
4491: FND_MSG_PUB.initialize;
4492: END IF;
4493:
4494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4496: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
4497: 'At the start of the procedure');
4498: END IF;

Line 4495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4491: FND_MSG_PUB.initialize;
4492: END IF;
4493:
4494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4496: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
4497: 'At the start of the procedure');
4498: END IF;
4499:

Line 4519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4515: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4517: END IF;
4518:
4519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4521: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling remove_instance API',
4522: 'At the middle of the procedure');
4523: END IF;

Line 4520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4517: END IF;
4518:
4519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4521: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling remove_instance API',
4522: 'At the middle of the procedure');
4523: END IF;
4524:

Line 4558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4554: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: END IF;
4557:
4558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4560: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling install_existing_instance API and comes to normal execution',
4561: 'At the end of the procedure');
4562: END IF;

Line 4559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: END IF;
4557:
4558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4560: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling install_existing_instance API and comes to normal execution',
4561: 'At the end of the procedure');
4562: END IF;
4563:

Line 5129: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5125: IF FND_API.to_boolean( p_init_msg_list ) THEN
5126: FND_MSG_PUB.initialize;
5127: END IF;
5128:
5129: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5131: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5132: 'At the start of the procedure');
5133: END IF;

Line 5130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5126: FND_MSG_PUB.initialize;
5127: END IF;
5128:
5129: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5131: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5132: 'At the start of the procedure');
5133: END IF;
5134:

Line 5136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5132: 'At the start of the procedure');
5133: END IF;
5134:
5135:
5136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5139: 'Logging API inputs');
5140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5133: END IF;
5134:
5135:
5136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5139: 'Logging API inputs');
5140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5141: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5139: 'Logging API inputs');
5140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5141: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5142: '******************');
5143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5139: 'Logging API inputs');
5140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5141: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5142: '******************');
5143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5145: 'p_relationship_id->'||p_relationship_id);
5146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5147: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5142: '******************');
5143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5145: 'p_relationship_id->'||p_relationship_id);
5146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5147: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5148: 'p_item_number->'||p_item_number);
5149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5150: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5145: 'p_relationship_id->'||p_relationship_id);
5146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5147: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5148: 'p_item_number->'||p_item_number);
5149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5150: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5151: 'p_serial_number->'||p_serial_number);
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5148: 'p_item_number->'||p_item_number);
5149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5150: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5151: 'p_serial_number->'||p_serial_number);
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5154: 'p_instance_number->'||p_instance_number);
5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5151: 'p_serial_number->'||p_serial_number);
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5154: 'p_instance_number->'||p_instance_number);
5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5157: 'p_workorder_id->'||p_workorder_id);
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5159: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5154: 'p_instance_number->'||p_instance_number);
5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5157: 'p_workorder_id->'||p_workorder_id);
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5159: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5160: 'p_start_row_index->'||p_start_row_index);
5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5162: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5157: 'p_workorder_id->'||p_workorder_id);
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5159: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5160: 'p_start_row_index->'||p_start_row_index);
5161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5162: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5163: 'p_max_rows->'||p_max_rows);
5164: END IF;
5165:

Line 5189: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5185: FND_MSG_PUB.add;
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END IF;
5188:
5189: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5190: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5191: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5192: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5190: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END IF;
5188:
5189: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5190: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5191: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5192: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5189: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5190: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5191: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5192: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5195: 'project_id derived ->'||l_visit_details_rec.project_id);
5196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5197: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5192: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5195: 'project_id derived ->'||l_visit_details_rec.project_id);
5196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5197: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5198: 'inv_locator_id setup at visit level->'||l_visit_details_rec.inv_locator_id);
5199: END IF;
5200:

Line 5246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5242: --Added by mpothuku on 17-May-2007 to fix the OGMA Issue 105.
5243: p_ignore_quant_vald => 'Y');
5244: END IF;
5245:
5246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5248: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5249: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
5250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5243: p_ignore_quant_vald => 'Y');
5244: END IF;
5245:
5246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5248: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5249: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
5250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5248: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5249: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
5250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5252: 'fnd_msg_pub.count_msg->'||fnd_msg_pub.count_msg);
5253: END IF;
5254:

Line 5261: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5257: IF (i >= p_start_row_index AND i < p_start_row_index + p_max_rows) THEN
5258: OPEN ahl_instance_details(l_subinv_inst_rec.instance_id);
5259: FETCH ahl_instance_details INTO l_instance_details_rec;
5260:
5261: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5263: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5264: 'l_instance_details_rec.csi_item_instance_id->'||l_instance_details_rec.csi_item_instance_id);
5265: END IF;

Line 5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5258: OPEN ahl_instance_details(l_subinv_inst_rec.instance_id);
5259: FETCH ahl_instance_details INTO l_instance_details_rec;
5260:
5261: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5263: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5264: 'l_instance_details_rec.csi_item_instance_id->'||l_instance_details_rec.csi_item_instance_id);
5265: END IF;
5266:

Line 5357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5353: END IF;
5354: fnd_msg_pub.initialize;
5355: END LOOP;
5356:
5357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5359: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5360: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5361: END IF;

Line 5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5354: fnd_msg_pub.initialize;
5355: END LOOP;
5356:
5357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5359: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5360: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5361: END IF;
5362:

Line 5363: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5359: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5360: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5361: END IF;
5362:
5363: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
5366: 'After normal execution');
5367: END IF;

Line 5364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5360: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5361: END IF;
5362:
5363: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
5366: 'After normal execution');
5367: END IF;
5368:

Line 5899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5895: IF FND_API.to_boolean( p_init_msg_list ) THEN
5896: FND_MSG_PUB.initialize;
5897: END IF;
5898:
5899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5901: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5902: 'At the start of the procedure');
5903: END IF;

Line 5900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5896: FND_MSG_PUB.initialize;
5897: END IF;
5898:
5899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5901: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5902: 'At the start of the procedure');
5903: END IF;
5904:

Line 5995: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5991: l_wip_entity_id,
5992: p_parent_instance_id,
5993: l_top_uc_status);
5994:
5995: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5997: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5998: ' ;p_relationship_id = '||p_relationship_id||' ;l_item_number = '||l_item_number||
5999: ' ;l_instance_number = '||l_instance_number||' ;l_serial_number = '||l_serial_number||

Line 5996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5992: p_parent_instance_id,
5993: l_top_uc_status);
5994:
5995: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5997: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5998: ' ;p_relationship_id = '||p_relationship_id||' ;l_item_number = '||l_item_number||
5999: ' ;l_instance_number = '||l_instance_number||' ;l_serial_number = '||l_serial_number||
6000: ' ;l_wip_entity_id = '||l_wip_entity_id||' ;p_parent_instance_id = '||p_parent_instance_id||

Line 6007: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6003:
6004: i := 0;
6005: j := 0;
6006: -- row count.
6007: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6009: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
6010: 'part_number='||l_item_number||'instance_number='||l_instance_number||
6011: 'serial_number='||l_serial_number||'wip_entity_id='||l_wip_entity_id||

Line 6008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6004: i := 0;
6005: j := 0;
6006: -- row count.
6007: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6008: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6009: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
6010: 'part_number='||l_item_number||'instance_number='||l_instance_number||
6011: 'serial_number='||l_serial_number||'wip_entity_id='||l_wip_entity_id||
6012: 'p_parent_instance_id='||p_parent_instance_id);

Line 6048: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6044: p_ignore_quant_vald => l_ignore_quant_vald,
6045: x_item_assoc_id => l_item_assoc_id);
6046: END IF;
6047:
6048: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6050: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
6051: 'After position validation');
6052: END IF;

Line 6049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6045: x_item_assoc_id => l_item_assoc_id);
6046: END IF;
6047:
6048: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6050: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
6051: 'After position validation');
6052: END IF;
6053:

Line 6146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6142: IF (get_instance2%ISOPEN) THEN
6143: CLOSE get_instance2;
6144: END IF;
6145:
6146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6148: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
6149: 'After normal execution');
6150: END IF;

Line 6147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6143: CLOSE get_instance2;
6144: END IF;
6145:
6146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6148: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
6149: 'After normal execution');
6150: END IF;
6151:

Line 6281: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6278: --
6279:
6280: BEGIN
6281: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6282: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
6283: END IF;
6284:
6285: -- Standard start of API savepoint

Line 6282: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');

6278: --
6279:
6280: BEGIN
6281: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6282: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
6283: END IF;
6284:
6285: -- Standard start of API savepoint
6286: SAVEPOINT create_unassigned_instance;

Line 6357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6353: FND_MSG_PUB.add;
6354: RAISE FND_API.G_EXC_ERROR;
6355: END IF;
6356:
6357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6359: ' l_root_instance_ou => '||l_root_instance_ou||
6360: ' l_parent_instance_id => '||l_parent_instance_id);
6361: END IF;

Line 6358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6354: RAISE FND_API.G_EXC_ERROR;
6355: END IF;
6356:
6357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6358: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6359: ' l_root_instance_ou => '||l_root_instance_ou||
6360: ' l_parent_instance_id => '||l_parent_instance_id);
6361: END IF;
6362:

Line 6412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6408: END IF;
6409:
6410: CLOSE csi_item_instance_csr;
6411:
6412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6414: ' l_uc_owner_loc_rec.location_id => '||l_uc_owner_loc_rec.location_id||
6415: ' l_uc_owner_loc_rec.location_type_code => '||l_uc_owner_loc_rec.location_type_code||
6416: ' l_uc_owner_loc_rec.party_id => '||l_uc_owner_loc_rec.party_id||

Line 6413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6409:
6410: CLOSE csi_item_instance_csr;
6411:
6412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6414: ' l_uc_owner_loc_rec.location_id => '||l_uc_owner_loc_rec.location_id||
6415: ' l_uc_owner_loc_rec.location_type_code => '||l_uc_owner_loc_rec.location_type_code||
6416: ' l_uc_owner_loc_rec.party_id => '||l_uc_owner_loc_rec.party_id||
6417: ' l_uc_owner_loc_rec.party_source_table => '||l_uc_owner_loc_rec.party_source_table||

Line 6491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6487:
6488: -- Build CSI accounts table
6489: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6490: LOOP
6491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6493: ' i => '||i||
6494: ' party_ip_acct.party_account_id => '||party_ip_acct.party_account_id);
6495: END IF;

Line 6492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6488: -- Build CSI accounts table
6489: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6490: LOOP
6491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6493: ' i => '||i||
6494: ' party_ip_acct.party_account_id => '||party_ip_acct.party_account_id);
6495: END IF;
6496:

Line 6520: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6516: IF (l_msg_count > l_msg_count_bef) THEN
6517: RAISE FND_API.G_EXC_ERROR;
6518: END IF;
6519:
6520: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6521: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6522: ' About to call CSI_ITEM_INSTANCE_PUB.create_item_instance');
6523: END IF;
6524:

Line 6521: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6517: RAISE FND_API.G_EXC_ERROR;
6518: END IF;
6519:
6520: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6521: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6522: ' About to call CSI_ITEM_INSTANCE_PUB.create_item_instance');
6523: END IF;
6524:
6525: --Call CSI API to create instance

Line 6545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6541: l_new_csi_instance_ovn := l_csi_instance_rec.object_version_number;
6542: p_x_uc_instance_rec.instance_id := l_new_instance_id;
6543: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
6544:
6545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6547: ' After call to CSI_ITEM_INSTANCE_PUB.create_item_instance'||
6548: ' instance_id => '||l_csi_instance_rec.instance_id||
6549: ' l_return_status => '||l_return_status||

Line 6546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6542: p_x_uc_instance_rec.instance_id := l_new_instance_id;
6543: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
6544:
6545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6547: ' After call to CSI_ITEM_INSTANCE_PUB.create_item_instance'||
6548: ' instance_id => '||l_csi_instance_rec.instance_id||
6549: ' l_return_status => '||l_return_status||
6550: ' p_x_uc_instance_rec.instance_id='||p_x_uc_instance_rec.instance_id);

Line 6588: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6584: l_csi_relationship_rec.position_reference := NULL;
6585: l_csi_relationship_rec.subject_id := l_new_instance_id;
6586: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
6587:
6588: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6590: ' About to call CSI_II_RELATIONSHIPS_PUB.create_relationship');
6591: END IF;
6592:

Line 6589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6585: l_csi_relationship_rec.subject_id := l_new_instance_id;
6586: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
6587:
6588: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6590: ' About to call CSI_II_RELATIONSHIPS_PUB.create_relationship');
6591: END IF;
6592:
6593: CSI_II_RELATIONSHIPS_PUB.create_relationship(

Line 6601: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6597: x_return_status => l_return_status,
6598: x_msg_count => l_msg_count,
6599: x_msg_data => l_msg_data);
6600:
6601: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6603: ' After call to CSI_II_RELATIONSHIPS_PUB.create_relationship'||
6604: ' l_return_status => '||l_return_status);
6605: END IF;

Line 6602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

6598: x_msg_count => l_msg_count,
6599: x_msg_data => l_msg_data);
6600:
6601: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6603: ' After call to CSI_II_RELATIONSHIPS_PUB.create_relationship'||
6604: ' l_return_status => '||l_return_status);
6605: END IF;
6606:

Line 6625: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

6621: p_data => x_msg_data,
6622: p_encoded => FND_API.G_FALSE
6623: );
6624:
6625: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6626: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
6627: END IF;
6628:
6629: EXCEPTION

Line 6626: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');

6622: p_encoded => FND_API.G_FALSE
6623: );
6624:
6625: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6626: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
6627: END IF;
6628:
6629: EXCEPTION
6630: WHEN FND_API.G_EXC_ERROR THEN

Line 6905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6901: IF FND_API.to_boolean(p_init_msg_list) THEN
6902: FND_MSG_PUB.initialize;
6903: END IF;
6904:
6905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6907: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
6908: 'At the start of the procedure. p_schedule_material_id = ' || p_schedule_material_id || ', p_inventory_item_id = ' || p_inventory_item_id);
6909: END IF;

Line 6906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6902: FND_MSG_PUB.initialize;
6903: END IF;
6904:
6905: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6906: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6907: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
6908: 'At the start of the procedure. p_schedule_material_id = ' || p_schedule_material_id || ', p_inventory_item_id = ' || p_inventory_item_id);
6909: END IF;
6910:

Line 6961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6957: x_return_status => l_return_status,
6958: x_msg_count => l_msg_count,
6959: x_msg_data => l_msg_data);
6960:
6961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6963: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6964: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
6965: END IF;

Line 6962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6958: x_msg_count => l_msg_count,
6959: x_msg_data => l_msg_data);
6960:
6961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6963: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6964: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
6965: END IF;
6966: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 6973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6970: END IF;
6971:
6972: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
6973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6975: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6976: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
6977: END IF;

Line 6974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6970: END IF;
6971:
6972: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
6973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6975: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6976: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
6977: END IF;
6978: -- Copy into an associative array for quick lookup

Line 6997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6993: FETCH get_instance INTO l_instance_id, l_instance_number, l_inventory_item_id, l_inv_master_org_id,
6994: l_quantity, l_inventory_revision, l_uom_code, l_uc_header_id, l_wip_job_id;
6995: EXIT WHEN get_instance%NOTFOUND;
6996:
6997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6998: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6999: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7000: 'Record retrieved by get_instance: l_instance_id = ' || l_instance_id);
7001: END IF;

Line 6998: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6994: l_quantity, l_inventory_revision, l_uom_code, l_uc_header_id, l_wip_job_id;
6995: EXIT WHEN get_instance%NOTFOUND;
6996:
6997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6998: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6999: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7000: 'Record retrieved by get_instance: l_instance_id = ' || l_instance_id);
7001: END IF;
7002: -- Check if this item is valid as per SB rules

Line 7020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7016: p_ignore_quant_vald => l_ignore_quant_vald,
7017: x_item_assoc_id => l_item_assoc_id);
7018: END IF;
7019:
7020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7022: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7023: 'After position validation. x_item_assoc_id = ' || l_item_assoc_id);
7024: END IF;

Line 7021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7017: x_item_assoc_id => l_item_assoc_id);
7018: END IF;
7019:
7020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7022: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7023: 'After position validation. x_item_assoc_id = ' || l_item_assoc_id);
7024: END IF;
7025:

Line 7032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7028: VALUES (l_instance_id, l_asm_details_rec.relationship_id);
7029: END IF; -- Message Count is zero
7030: fnd_msg_pub.initialize;
7031: ELSE
7032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7034: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7035: 'Item ' || l_inventory_item_id || ' is not a valid item.');
7036: END IF;

Line 7033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7029: END IF; -- Message Count is zero
7030: fnd_msg_pub.initialize;
7031: ELSE
7032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7034: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7035: 'Item ' || l_inventory_item_id || ' is not a valid item.');
7036: END IF;
7037: END IF;

Line 7044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7040: IF (get_instance%ISOPEN) THEN
7041: CLOSE get_instance;
7042: END IF;
7043:
7044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7045: select count(*) into iIndex from AHL_APPLICABLE_INSTANCES;
7046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7047: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);

Line 7046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7042: END IF;
7043:
7044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7045: select count(*) into iIndex from AHL_APPLICABLE_INSTANCES;
7046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7047: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);
7049: END IF;
7050:

Line 7051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7047: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);
7049: END IF;
7050:
7051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7053: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
7054: 'After normal execution.');
7055: END IF;

Line 7052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);
7049: END IF;
7050:
7051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7053: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
7054: 'After normal execution.');
7055: END IF;
7056:

Line 7217: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7213: iIndex NUMBER;
7214:
7215: BEGIN
7216:
7217: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7219: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
7220: 'At the start of the function. p_instance_id = ' || p_instance_id ||
7221: ', p_relationship_id = ' || p_relationship_id ||

Line 7218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

7214:
7215: BEGIN
7216:
7217: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7219: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
7220: 'At the start of the function. p_instance_id = ' || p_instance_id ||
7221: ', p_relationship_id = ' || p_relationship_id ||
7222: ', p_schedule_material_id = ' || p_schedule_material_id);

Line 7226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7222: ', p_schedule_material_id = ' || p_schedule_material_id);
7223: END IF;
7224:
7225: IF(p_instance_id IS NULL OR p_relationship_id IS NULL) THEN
7226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7227: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7228: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7229: 'Mandatory parameters are missing. Returning False.');
7230: END IF;

Line 7227: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7223: END IF;
7224:
7225: IF(p_instance_id IS NULL OR p_relationship_id IS NULL) THEN
7226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7227: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7228: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7229: 'Mandatory parameters are missing. Returning False.');
7230: END IF;
7231: RETURN l_ret_val;

Line 7239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7235: OPEN check_relationship_id(p_relationship_id);
7236: FETCH check_relationship_id INTO l_relationship_id, l_mc_header_id;
7237: IF check_relationship_id%NOTFOUND THEN
7238: CLOSE check_relationship_id;
7239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7241: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7242: 'p_relationship_id is invalid. Returning False.');
7243: END IF;

Line 7240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7236: FETCH check_relationship_id INTO l_relationship_id, l_mc_header_id;
7237: IF check_relationship_id%NOTFOUND THEN
7238: CLOSE check_relationship_id;
7239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7241: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7242: 'p_relationship_id is invalid. Returning False.');
7243: END IF;
7244: RETURN l_ret_val;

Line 7267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7263: x_return_status => l_return_status,
7264: x_msg_count => l_msg_count,
7265: x_msg_data => l_msg_data);
7266:
7267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7269: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7270: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
7271: END IF;

Line 7268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7264: x_msg_count => l_msg_count,
7265: x_msg_data => l_msg_data);
7266:
7267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7269: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7270: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
7271: END IF;
7272: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 7275: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7271: END IF;
7272: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7273: -- Process the returned rows since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned success
7274: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
7275: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7278: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
7279: END IF;

Line 7276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7272: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7273: -- Process the returned rows since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned success
7274: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
7275: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7278: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
7279: END IF;
7280: -- Check in the result table if the instance's item is present

Line 7286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7282: LOOP
7283: IF (l_alt_items_tbl(iIndex) = l_inventory_item_id) THEN
7284: -- Item is valid based on SB Rules
7285: l_ret_val := FND_API.G_TRUE;
7286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7288: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7289: 'Item matched against SB Rules. Returning True.');
7290: END IF;

Line 7287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7283: IF (l_alt_items_tbl(iIndex) = l_inventory_item_id) THEN
7284: -- Item is valid based on SB Rules
7285: l_ret_val := FND_API.G_TRUE;
7286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7288: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7289: 'Item matched against SB Rules. Returning True.');
7290: END IF;
7291: END IF; -- Item Matches

Line 7296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7292: EXIT WHEN ((iIndex = l_alt_items_tbl.LAST) OR (l_ret_val = FND_API.G_TRUE));
7293: iIndex := l_alt_items_tbl.NEXT(iIndex);
7294: END LOOP;
7295: ELSE
7296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7298: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7299: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items is null or zero. Returning False.');
7300: END IF;

Line 7297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7293: iIndex := l_alt_items_tbl.NEXT(iIndex);
7294: END LOOP;
7295: ELSE
7296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7298: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7299: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items is null or zero. Returning False.');
7300: END IF;
7301: END IF; -- l_alt_items_tbl.COUNT > 0

Line 7304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7300: END IF;
7301: END IF; -- l_alt_items_tbl.COUNT > 0
7302: ELSE
7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status
7304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7305: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7307: 'Since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error, returning False.');
7308: END IF;

Line 7305: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7301: END IF; -- l_alt_items_tbl.COUNT > 0
7302: ELSE
7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status
7304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7305: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7307: 'Since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error, returning False.');
7308: END IF;
7309: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS or not

Line 7313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7309: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS or not
7310: ELSE
7311: -- p_schedule_material_id is not passed: No need to validate against SB Rules: Return True
7312: l_ret_val := FND_API.G_TRUE;
7313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7315: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7316: 'Instance Item validated. Returning True.');
7317: END IF;

Line 7314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7310: ELSE
7311: -- p_schedule_material_id is not passed: No need to validate against SB Rules: Return True
7312: l_ret_val := FND_API.G_TRUE;
7313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7315: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7316: 'Instance Item validated. Returning True.');
7317: END IF;
7318: END IF; -- p_schedule_material_id is not null

Line 7322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7318: END IF; -- p_schedule_material_id is not null
7319: ELSE
7320: -- Instance did not match
7321: CLOSE is_instance_valid;
7322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7324: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7325: 'Instance did not match. Returning False.');
7326: END IF;

Line 7323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

7319: ELSE
7320: -- Instance did not match
7321: CLOSE is_instance_valid;
7322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7324: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7325: 'Instance did not match. Returning False.');
7326: END IF;
7327: END IF;

Line 7329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7325: 'Instance did not match. Returning False.');
7326: END IF;
7327: END IF;
7328:
7329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7331: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
7332: 'At the end of the function. About to return ' || l_ret_val);
7333: END IF;

Line 7330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

7326: END IF;
7327: END IF;
7328:
7329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7331: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
7332: 'At the end of the function. About to return ' || l_ret_val);
7333: END IF;
7334: RETURN l_ret_val;