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 2441: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2437: IF FND_API.to_boolean( p_init_msg_list ) THEN
2438: FND_MSG_PUB.initialize;
2439: END IF;
2440:
2441: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2443: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
2444: 'At the start of the procedure');
2445: END IF;

Line 2442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2438: FND_MSG_PUB.initialize;
2439: END IF;
2440:
2441: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2443: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
2444: 'At the start of the procedure');
2445: END IF;
2446:

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

2979: l_new_csi_instance_ovn := l_csi_instance_rec.object_version_number;
2980: p_x_uc_instance_rec.instance_id := l_new_instance_id;
2981: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
2982:
2983: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2984: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2985: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
2986: ' After calling create_item_instance and instance_id = '||l_csi_instance_rec.instance_id||
2987: ' l_return_status ='||l_return_status||

Line 2984: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2980: p_x_uc_instance_rec.instance_id := l_new_instance_id;
2981: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
2982:
2983: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2984: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2985: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
2986: ' After calling create_item_instance and instance_id = '||l_csi_instance_rec.instance_id||
2987: ' l_return_status ='||l_return_status||
2988: ' p_x_uc_instance_rec.instance_id='||p_x_uc_instance_rec.instance_id);

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

3051: --The parameter p_uc_header_id is not necessarily the parent uc_header_id of the newly
3052: --installed instance.
3053:
3054: --dbms_output.put_line('Before calling create uc_header API:...');
3055: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3056: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3057: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3058: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3059: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||

Line 3056: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3052: --installed instance.
3053:
3054: --dbms_output.put_line('Before calling create uc_header API:...');
3055: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3056: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3057: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3058: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3059: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||
3060: ' p_x_sub_uc_rec.mc_name='||p_x_sub_uc_rec.mc_name||

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

3072: x_msg_count => l_msg_count,
3073: x_msg_data => l_msg_data,
3074: p_x_uc_header_rec => p_x_sub_uc_rec);
3075:
3076: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3078: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3079: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3080: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||

Line 3077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3073: x_msg_data => l_msg_data,
3074: p_x_uc_header_rec => p_x_sub_uc_rec);
3075:
3076: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3078: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
3079: ' p_x_sub_uc_rec.uc_header_id='||p_x_sub_uc_rec.uc_header_id||
3080: ' p_x_sub_uc_rec.mc_header_id='||p_x_sub_uc_rec.mc_header_id||
3081: ' p_x_sub_uc_rec.mc_name='||p_x_sub_uc_rec.mc_name||

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

3194: FND_MSG_PUB.add;
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: END IF;
3197: ELSIF (l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT')) THEN
3198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3200: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
3201: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
3202: 'l_root_uc_ovn='||l_root_uc_ovn);

Line 3199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: END IF;
3197: ELSIF (l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT')) THEN
3198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3200: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
3201: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
3202: 'l_root_uc_ovn='||l_root_uc_ovn);
3203: END IF;

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

3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: END IF;
3236: END IF;
3237:
3238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3240: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
3241: 'At the end of the procedure');
3242: END IF;

Line 3239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3235: END IF;
3236: END IF;
3237:
3238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3240: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
3241: 'At the end of the procedure');
3242: END IF;
3243:

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

3627: IF FND_API.to_boolean( p_init_msg_list ) THEN
3628: FND_MSG_PUB.initialize;
3629: END IF;
3630:
3631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3633: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3634: 'At the start of the procedure');
3635: END IF;

Line 3632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3628: FND_MSG_PUB.initialize;
3629: END IF;
3630:
3631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3633: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3634: 'At the start of the procedure');
3635: END IF;
3636:

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

4021: --need to create a new csi_ii_relationship record
4022: OPEN check_extra_node(p_parent_instance_id, p_instance_id);
4023: FETCH check_extra_node INTO l_csi_relationship_id, l_object_version_number;
4024: IF check_extra_node%FOUND THEN
4025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4026: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4027: ' sibling extra node found'||
4028: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4029: END IF;

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

4022: OPEN check_extra_node(p_parent_instance_id, p_instance_id);
4023: FETCH check_extra_node INTO l_csi_relationship_id, l_object_version_number;
4024: IF check_extra_node%FOUND THEN
4025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4026: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4027: ' sibling extra node found'||
4028: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4029: END IF;
4030:

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

4062: OPEN check_unasgnd_extra_node_csr(p_parent_instance_id, p_instance_id);
4063: FETCH check_unasgnd_extra_node_csr INTO l_csi_relationship_id, l_object_version_number;
4064:
4065: IF check_unasgnd_extra_node_csr%FOUND THEN
4066: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4068: ' extra node attached to any of the parents uptill root found'||
4069: ' p_parent_instance_id => '||p_parent_instance_id||
4070: ' p_instance_id => '||p_instance_id||

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

4063: FETCH check_unasgnd_extra_node_csr INTO l_csi_relationship_id, l_object_version_number;
4064:
4065: IF check_unasgnd_extra_node_csr%FOUND THEN
4066: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4068: ' extra node attached to any of the parents uptill root found'||
4069: ' p_parent_instance_id => '||p_parent_instance_id||
4070: ' p_instance_id => '||p_instance_id||
4071: ' p_csi_ii_ovn => '||p_csi_ii_ovn);

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

4105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4107: END IF;
4108:
4109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4111: ' unassigned extra node relationship expired');
4112: END IF;
4113:

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

4106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4107: END IF;
4108:
4109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4111: ' unassigned extra node relationship expired');
4112: END IF;
4113:
4114: -- create new relationship

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

4131: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: END IF;
4134:
4135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4137: ' unassigned extra node new relationship created');
4138: END IF;
4139: ELSE

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

4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: END IF;
4134:
4135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4137: ' unassigned extra node new relationship created');
4138: END IF;
4139: ELSE
4140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4137: ' unassigned extra node new relationship created');
4138: END IF;
4139: ELSE
4140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4142: ' free standing instance found'||
4143: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4144: END IF;

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

4137: ' unassigned extra node new relationship created');
4138: END IF;
4139: ELSE
4140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4142: ' free standing instance found'||
4143: ' p_csi_ii_ovn => '||p_csi_ii_ovn);
4144: END IF;
4145:

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

4319: FND_MSG_PUB.add;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;
4322: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
4323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4325: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
4326: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
4327: 'l_root_uc_ovn='||l_root_uc_ovn);

Line 4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;
4322: ELSIF l_root_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE', 'DRAFT') THEN
4323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4325: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Before calling completeness check',
4326: 'p_uc_header_id='||p_uc_header_id||'l_root_uc_header_id='||l_root_uc_header_id||
4327: 'l_root_uc_ovn='||l_root_uc_ovn);
4328: END IF;

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

4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END IF;
4361: END IF;
4362:
4363: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
4366: 'At the end of the procedure');
4367: END IF;

Line 4364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4360: END IF;
4361: END IF;
4362:
4363: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
4366: 'At the end of the procedure');
4367: END IF;
4368:

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

4468: IF FND_API.to_boolean(p_init_msg_list) THEN
4469: FND_MSG_PUB.initialize;
4470: END IF;
4471:
4472: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4473: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4474: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
4475: 'At the start of the procedure');
4476: END IF;

Line 4473: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4469: FND_MSG_PUB.initialize;
4470: END IF;
4471:
4472: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4473: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4474: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
4475: 'At the start of the procedure');
4476: END IF;
4477:

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

4493: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4498: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4499: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling remove_instance API',
4500: 'At the middle of the procedure');
4501: END IF;

Line 4498: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4498: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4499: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling remove_instance API',
4500: 'At the middle of the procedure');
4501: END IF;
4502:

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

4532: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: END IF;
4535:
4536: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4537: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4538: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling install_existing_instance API and comes to normal execution',
4539: 'At the end of the procedure');
4540: END IF;

Line 4537: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: END IF;
4535:
4536: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4537: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4538: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After calling install_existing_instance API and comes to normal execution',
4539: 'At the end of the procedure');
4540: END IF;
4541:

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

5030: IF FND_API.to_boolean( p_init_msg_list ) THEN
5031: FND_MSG_PUB.initialize;
5032: END IF;
5033:
5034: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5036: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5037: 'At the start of the procedure');
5038: END IF;

Line 5035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5031: FND_MSG_PUB.initialize;
5032: END IF;
5033:
5034: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5036: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5037: 'At the start of the procedure');
5038: END IF;
5039:

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

5037: 'At the start of the procedure');
5038: END IF;
5039:
5040:
5041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5043: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5044: 'Logging API inputs');
5045: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5038: END IF;
5039:
5040:
5041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5043: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5044: 'Logging API inputs');
5045: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5046: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5045: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5043: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5044: 'Logging API inputs');
5045: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5046: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5047: '******************');
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5049: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5044: 'Logging API inputs');
5045: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5046: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5047: '******************');
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5049: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5050: 'p_relationship_id->'||p_relationship_id);
5051: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5052: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5051: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5047: '******************');
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5049: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5050: 'p_relationship_id->'||p_relationship_id);
5051: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5052: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5053: 'p_item_number->'||p_item_number);
5054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5055: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5050: 'p_relationship_id->'||p_relationship_id);
5051: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5052: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5053: 'p_item_number->'||p_item_number);
5054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5055: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5056: 'p_serial_number->'||p_serial_number);
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5058: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5053: 'p_item_number->'||p_item_number);
5054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5055: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5056: 'p_serial_number->'||p_serial_number);
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5058: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5059: 'p_instance_number->'||p_instance_number);
5060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5056: 'p_serial_number->'||p_serial_number);
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5058: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5059: 'p_instance_number->'||p_instance_number);
5060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5062: 'p_workorder_id->'||p_workorder_id);
5063: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5064: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5063: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5059: 'p_instance_number->'||p_instance_number);
5060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5062: 'p_workorder_id->'||p_workorder_id);
5063: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5064: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5065: 'p_start_row_index->'||p_start_row_index);
5066: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5067: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5066: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5062: 'p_workorder_id->'||p_workorder_id);
5063: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5064: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5065: 'p_start_row_index->'||p_start_row_index);
5066: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5067: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5068: 'p_max_rows->'||p_max_rows);
5069: END IF;
5070:

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

5090: FND_MSG_PUB.add;
5091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5092: END IF;
5093:
5094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5097: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5092: END IF;
5093:
5094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5097: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5099: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5097: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5099: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5100: 'project_id derived ->'||l_visit_details_rec.project_id);
5101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5102: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',

Line 5101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5097: 'Visit Id derived->'||l_visit_details_rec.visit_id);
5098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5099: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5100: 'project_id derived ->'||l_visit_details_rec.project_id);
5101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5102: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5103: 'inv_locator_id setup at visit level->'||l_visit_details_rec.inv_locator_id);
5104: END IF;
5105:

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

5147: --Added by mpothuku on 17-May-2007 to fix the OGMA Issue 105.
5148: p_ignore_quant_vald => 'Y');
5149: END IF;
5150:
5151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5154: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5148: p_ignore_quant_vald => 'Y');
5149: END IF;
5150:
5151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5154: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
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: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5153: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5154: 'After position validation for l_subinv_inst_rec.instance_id->'||l_subinv_inst_rec.instance_id);
5155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5157: 'fnd_msg_pub.count_msg->'||fnd_msg_pub.count_msg);
5158: END IF;
5159:

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

5162: IF (i >= p_start_row_index AND i < p_start_row_index + p_max_rows) THEN
5163: OPEN ahl_instance_details(l_subinv_inst_rec.instance_id);
5164: FETCH ahl_instance_details INTO l_instance_details_rec;
5165:
5166: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5168: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5169: 'l_instance_details_rec.csi_item_instance_id->'||l_instance_details_rec.csi_item_instance_id);
5170: END IF;

Line 5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5163: OPEN ahl_instance_details(l_subinv_inst_rec.instance_id);
5164: FETCH ahl_instance_details INTO l_instance_details_rec;
5165:
5166: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5168: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5169: 'l_instance_details_rec.csi_item_instance_id->'||l_instance_details_rec.csi_item_instance_id);
5170: END IF;
5171:

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

5248: END IF;
5249: fnd_msg_pub.initialize;
5250: END LOOP;
5251:
5252: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5254: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5255: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5256: END IF;

Line 5253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5249: fnd_msg_pub.initialize;
5250: END LOOP;
5251:
5252: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5254: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5255: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5256: END IF;
5257:

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

5254: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5255: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5256: END IF;
5257:
5258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5260: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
5261: 'After normal execution');
5262: END IF;

Line 5259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5255: 'x_avail_subinv_instance_tbl count->'||x_avail_subinv_instance_tbl.COUNT);
5256: END IF;
5257:
5258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5260: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
5261: 'After normal execution');
5262: END IF;
5263:

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

5788: IF FND_API.to_boolean( p_init_msg_list ) THEN
5789: FND_MSG_PUB.initialize;
5790: END IF;
5791:
5792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5794: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5795: 'At the start of the procedure');
5796: END IF;

Line 5793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5789: FND_MSG_PUB.initialize;
5790: END IF;
5791:
5792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5794: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
5795: 'At the start of the procedure');
5796: END IF;
5797:

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

5884: l_wip_entity_id,
5885: p_parent_instance_id,
5886: l_top_uc_status);
5887:
5888: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5890: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5891: ' ;p_relationship_id = '||p_relationship_id||' ;l_item_number = '||l_item_number||
5892: ' ;l_instance_number = '||l_instance_number||' ;l_serial_number = '||l_serial_number||

Line 5889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5885: p_parent_instance_id,
5886: l_top_uc_status);
5887:
5888: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5890: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5891: ' ;p_relationship_id = '||p_relationship_id||' ;l_item_number = '||l_item_number||
5892: ' ;l_instance_number = '||l_instance_number||' ;l_serial_number = '||l_serial_number||
5893: ' ;l_wip_entity_id = '||l_wip_entity_id||' ;p_parent_instance_id = '||p_parent_instance_id||

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

5896:
5897: i := 0;
5898: j := 0;
5899: -- row count.
5900: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5902: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5903: 'part_number='||l_item_number||'instance_number='||l_instance_number||
5904: 'serial_number='||l_serial_number||'wip_entity_id='||l_wip_entity_id||

Line 5901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5897: i := 0;
5898: j := 0;
5899: -- row count.
5900: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5901: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5902: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5903: 'part_number='||l_item_number||'instance_number='||l_instance_number||
5904: 'serial_number='||l_serial_number||'wip_entity_id='||l_wip_entity_id||
5905: 'p_parent_instance_id='||p_parent_instance_id);

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

5937: p_ignore_quant_vald => l_ignore_quant_vald,
5938: x_item_assoc_id => l_item_assoc_id);
5939: END IF;
5940:
5941: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5943: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5944: 'After position validation');
5945: END IF;

Line 5942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5938: x_item_assoc_id => l_item_assoc_id);
5939: END IF;
5940:
5941: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5943: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Within API',
5944: 'After position validation');
5945: END IF;
5946:

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

6035: IF (get_instance2%ISOPEN) THEN
6036: CLOSE get_instance2;
6037: END IF;
6038:
6039: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6040: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6041: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
6042: 'After normal execution');
6043: END IF;

Line 6040: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6036: CLOSE get_instance2;
6037: END IF;
6038:
6039: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6040: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6041: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': End API',
6042: 'After normal execution');
6043: END IF;
6044:

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

6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6171: --
6172:
6173: BEGIN
6174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6175: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
6176: END IF;
6177:
6178: -- Standard start of API savepoint

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

6171: --
6172:
6173: BEGIN
6174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6175: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
6176: END IF;
6177:
6178: -- Standard start of API savepoint
6179: SAVEPOINT create_unassigned_instance;

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

6246: FND_MSG_PUB.add;
6247: RAISE FND_API.G_EXC_ERROR;
6248: END IF;
6249:
6250: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6251: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6252: ' l_root_instance_ou => '||l_root_instance_ou||
6253: ' l_parent_instance_id => '||l_parent_instance_id);
6254: END IF;

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

6247: RAISE FND_API.G_EXC_ERROR;
6248: END IF;
6249:
6250: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6251: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6252: ' l_root_instance_ou => '||l_root_instance_ou||
6253: ' l_parent_instance_id => '||l_parent_instance_id);
6254: END IF;
6255:

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

6301: END IF;
6302:
6303: CLOSE csi_item_instance_csr;
6304:
6305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6307: ' l_uc_owner_loc_rec.location_id => '||l_uc_owner_loc_rec.location_id||
6308: ' l_uc_owner_loc_rec.location_type_code => '||l_uc_owner_loc_rec.location_type_code||
6309: ' l_uc_owner_loc_rec.party_id => '||l_uc_owner_loc_rec.party_id||

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

6302:
6303: CLOSE csi_item_instance_csr;
6304:
6305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6307: ' l_uc_owner_loc_rec.location_id => '||l_uc_owner_loc_rec.location_id||
6308: ' l_uc_owner_loc_rec.location_type_code => '||l_uc_owner_loc_rec.location_type_code||
6309: ' l_uc_owner_loc_rec.party_id => '||l_uc_owner_loc_rec.party_id||
6310: ' l_uc_owner_loc_rec.party_source_table => '||l_uc_owner_loc_rec.party_source_table||

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

6380:
6381: -- Build CSI accounts table
6382: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6383: LOOP
6384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6386: ' i => '||i||
6387: ' party_ip_acct.party_account_id => '||party_ip_acct.party_account_id);
6388: END IF;

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

6381: -- Build CSI accounts table
6382: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6383: LOOP
6384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6386: ' i => '||i||
6387: ' party_ip_acct.party_account_id => '||party_ip_acct.party_account_id);
6388: END IF;
6389:

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

6409: IF (l_msg_count > l_msg_count_bef) THEN
6410: RAISE FND_API.G_EXC_ERROR;
6411: END IF;
6412:
6413: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6415: ' About to call CSI_ITEM_INSTANCE_PUB.create_item_instance');
6416: END IF;
6417:

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

6410: RAISE FND_API.G_EXC_ERROR;
6411: END IF;
6412:
6413: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6415: ' About to call CSI_ITEM_INSTANCE_PUB.create_item_instance');
6416: END IF;
6417:
6418: --Call CSI API to create instance

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

6434: l_new_csi_instance_ovn := l_csi_instance_rec.object_version_number;
6435: p_x_uc_instance_rec.instance_id := l_new_instance_id;
6436: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
6437:
6438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6440: ' After call to CSI_ITEM_INSTANCE_PUB.create_item_instance'||
6441: ' instance_id => '||l_csi_instance_rec.instance_id||
6442: ' l_return_status => '||l_return_status||

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

6435: p_x_uc_instance_rec.instance_id := l_new_instance_id;
6436: p_x_uc_instance_rec.object_version_number := l_new_csi_instance_ovn;
6437:
6438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6440: ' After call to CSI_ITEM_INSTANCE_PUB.create_item_instance'||
6441: ' instance_id => '||l_csi_instance_rec.instance_id||
6442: ' l_return_status => '||l_return_status||
6443: ' p_x_uc_instance_rec.instance_id='||p_x_uc_instance_rec.instance_id);

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

6477: l_csi_relationship_rec.position_reference := NULL;
6478: l_csi_relationship_rec.subject_id := l_new_instance_id;
6479: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
6480:
6481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6483: ' About to call CSI_II_RELATIONSHIPS_PUB.create_relationship');
6484: END IF;
6485:

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

6478: l_csi_relationship_rec.subject_id := l_new_instance_id;
6479: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
6480:
6481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6483: ' About to call CSI_II_RELATIONSHIPS_PUB.create_relationship');
6484: END IF;
6485:
6486: CSI_II_RELATIONSHIPS_PUB.create_relationship(

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

6490: x_return_status => l_return_status,
6491: x_msg_count => l_msg_count,
6492: x_msg_data => l_msg_data);
6493:
6494: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6496: ' After call to CSI_II_RELATIONSHIPS_PUB.create_relationship'||
6497: ' l_return_status => '||l_return_status);
6498: END IF;

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

6491: x_msg_count => l_msg_count,
6492: x_msg_data => l_msg_data);
6493:
6494: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6496: ' After call to CSI_II_RELATIONSHIPS_PUB.create_relationship'||
6497: ' l_return_status => '||l_return_status);
6498: END IF;
6499:

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

6514: p_data => x_msg_data,
6515: p_encoded => FND_API.G_FALSE
6516: );
6517:
6518: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6519: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
6520: END IF;
6521:
6522: EXCEPTION

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

6515: p_encoded => FND_API.G_FALSE
6516: );
6517:
6518: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6519: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
6520: END IF;
6521:
6522: EXCEPTION
6523: WHEN FND_API.G_EXC_ERROR THEN