APPS.AHL_CMP_PVT dependencies on FND_LOG

Line 19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

15:
16: ------------------------------------------------------------------------------------
17: -- Common variables
18: ------------------------------------------------------------------------------------
19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;

Line 20: l_log_statement NUMBER := FND_LOG.level_statement;

16: ------------------------------------------------------------------------------------
17: -- Common variables
18: ------------------------------------------------------------------------------------
19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;
24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

Line 21: l_log_procedure NUMBER := FND_LOG.level_procedure;

17: -- Common variables
18: ------------------------------------------------------------------------------------
19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;
24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
25: ------------------------------------------------------------------------------------

Line 22: l_log_error NUMBER := FND_LOG.level_error;

18: ------------------------------------------------------------------------------------
19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;
24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
25: ------------------------------------------------------------------------------------
26:

Line 23: l_log_exception NUMBER := FND_LOG.level_exception;

19: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;
24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
25: ------------------------------------------------------------------------------------
26:
27: ------------------------------------------------------------------------------------

Line 24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

20: l_log_statement NUMBER := FND_LOG.level_statement;
21: l_log_procedure NUMBER := FND_LOG.level_procedure;
22: l_log_error NUMBER := FND_LOG.level_error;
23: l_log_exception NUMBER := FND_LOG.level_exception;
24: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
25: ------------------------------------------------------------------------------------
26:
27: ------------------------------------------------------------------------------------
28: -- Private APIs

Line 1423: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1419: --
1420:
1421: BEGIN
1422: IF (l_log_procedure >= l_log_current_level) THEN
1423: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1424: END IF;
1425:
1426: -- Standard start of API savepoint
1427: SAVEPOINT Process_Repair_Item_Pvt;

Line 1444: FND_LOG.string(l_log_statement, l_full_name,

1440: -- Initialize Procedure return status to success
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: IF (l_log_statement >= l_log_current_level) THEN
1444: FND_LOG.string(l_log_statement, l_full_name,
1445: ' p_inv_item_id = '||p_inv_item_id||
1446: ', p_item_mstr_org_id = '||p_item_mstr_org_id||
1447: ', p_item_inv_org_id = '||p_item_inv_org_id||
1448: ', p_instance_id = '||p_instance_id||

Line 1470: FND_LOG.string(l_log_statement, l_full_name, 'item and instance are invalid');

1466: FETCH get_item_inst_det_csr INTO l_item_inst_det_csr;
1467: IF (get_item_inst_det_csr%NOTFOUND) THEN
1468: -- item and instance are invalid
1469: IF (l_log_statement >= l_log_current_level) THEN
1470: FND_LOG.string(l_log_statement, l_full_name, 'item and instance are invalid');
1471: END IF;
1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);

Line 1495: FND_LOG.string(l_log_statement, l_full_name, 'operation flag is invalid');

1491: -- 2) Validate the operation flag
1492: IF (NVL(p_opr_flag, '-') <> G_OP_CREATE AND NVL(p_opr_flag, '-') <> G_OP_UPDATE) THEN
1493: -- operation flag is invalid
1494: IF (l_log_statement >= l_log_current_level) THEN
1495: FND_LOG.string(l_log_statement, l_full_name, 'operation flag is invalid');
1496: END IF;
1497: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1498: FND_MESSAGE.Set_Token('NAME', 'p_opr_flag');
1499: FND_MESSAGE.Set_Token('VALUE', p_opr_flag);

Line 1509: FND_LOG.string(l_log_statement, l_full_name, 'source sub-inventory locator is invalid');

1505: FETCH chk_locator_csr INTO l_dummy;
1506: IF (chk_locator_csr%NOTFOUND) THEN
1507: -- source sub-inventory locator is invalid
1508: IF (l_log_statement >= l_log_current_level) THEN
1509: FND_LOG.string(l_log_statement, l_full_name, 'source sub-inventory locator is invalid');
1510: END IF;
1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);

Line 1529: FND_LOG.string(l_log_statement, l_full_name, 'source repair batch name is invalid');

1525: FETCH chk_rpr_batch_csr INTO l_dummy;
1526: IF (chk_rpr_batch_csr%NOTFOUND) THEN
1527: -- source repair batch name is invalid
1528: IF (l_log_statement >= l_log_current_level) THEN
1529: FND_LOG.string(l_log_statement, l_full_name, 'source repair batch name is invalid');
1530: END IF;
1531: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1532: FND_MESSAGE.Set_Token('NAME', 'p_src_rpr_batch_name');
1533: FND_MESSAGE.Set_Token('VALUE', p_src_rpr_batch_name);

Line 1542: FND_LOG.string(l_log_statement, l_full_name, 'input parameters are invalid');

1538:
1539: -- If any errors occured, then raise them
1540: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN
1541: IF (l_log_statement >= l_log_current_level) THEN
1542: FND_LOG.string(l_log_statement, l_full_name, 'input parameters are invalid');
1543: END IF;
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546: -- ************************** Ist Validation 1::End ************************** --

Line 1555: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity is NULL or greater than instance quantity');

1551: -- 1) Validate the repair quantity
1552: IF (p_repair_qty IS NULL OR p_repair_qty = 0 OR p_repair_qty > l_item_inst_det_csr.quantity) THEN
1553: -- repair quantity is NULL or greater than instance quantity
1554: IF (l_log_statement >= l_log_current_level) THEN
1555: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity is NULL or greater than instance quantity');
1556: END IF;
1557: -- Please enter a positive number for the repair quantity, less than or equal to the instance quantity.
1558: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_QTY_INVLD');
1559: FND_MSG_PUB.ADD;

Line 1570: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity cant be complete');

1566: l_dummy := AHL_CMP_UTIL_PKG.Are_All_Workorders_Complete(NULL, p_instance_id, p_item_inv_org_id);
1567: IF (l_dummy = 'N') THEN
1568: -- repair quantity can't be complete
1569: IF (l_log_statement >= l_log_current_level) THEN
1570: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity cant be complete');
1571: END IF;
1572: -- Please complete the open workorders for the instance before moving complete quantity.
1573: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_QTY_INVLD');
1574: FND_MSG_PUB.ADD;

Line 1591: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch name is invalid');

1587: IF (chk_rpr_batch_csr%NOTFOUND) THEN
1588: -- destination repair batch name is invalid
1589: CLOSE chk_rpr_batch_csr;
1590: IF (l_log_statement >= l_log_current_level) THEN
1591: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch name is invalid');
1592: END IF;
1593: -- The repair batch REPAIR_BATCH is invalid for the item ITEM.
1594: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_BATCH_INVLD');
1595: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

Line 1605: FND_LOG.string(l_log_statement, l_full_name, 'repair batch update not allowed for lot controlled items');

1601:
1602: IF (l_item_inst_det_csr.lot_number IS NOT NULL) THEN
1603: -- repair batch update not allowed for lot controlled items
1604: IF (l_log_statement >= l_log_current_level) THEN
1605: FND_LOG.string(l_log_statement, l_full_name, 'repair batch update not allowed for lot controlled items');
1606: END IF;
1607: -- The repair batch REPAIR_BATCH can contain only one lot-controlled item instance.
1608: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_LOT_UPDATE_INVLD');
1609: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

Line 1620: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch belongs to a past dated visit.');

1616: IF (Check_Past_Dated_Visit%FOUND) THEN
1617: -- destination repair batch belongs to a past dated visit.
1618: CLOSE Check_Past_Dated_Visit;
1619: IF (l_log_statement >= l_log_current_level) THEN
1620: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch belongs to a past dated visit.');
1621: END IF;
1622: -- Cannot add instances to the repair batch REPAIR_BATCH as it belongs to a past dated visit.
1623: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_CANNOT_ADD_INSTANCES');
1624: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

Line 1643: FND_LOG.string(l_log_statement, l_full_name, 'no component visit exists for the org');

1639: l_visit_id := AHL_CMP_UTIL_PKG.Get_Comp_Visit_For_Org (p_item_inv_org_id);
1640: IF (l_visit_id IS NULL) THEN
1641: -- no component visit exists for the org
1642: IF (l_log_statement >= l_log_current_level) THEN
1643: FND_LOG.string(l_log_statement, l_full_name, 'no component visit exists for the org');
1644: END IF;
1645: OPEN get_org_name_csr (p_item_inv_org_id);
1646: FETCH get_org_name_csr INTO l_org_name;
1647: CLOSE get_org_name_csr;

Line 1667: FND_LOG.string(l_log_statement, l_full_name, 'calling AHL_VWP_TASKS_PVT.Create_Task'||

1663: l_task_rec.repair_batch_name := 'Dummy Repair Batch';
1664:
1665: -- call the VWP API, and let the defaults for input parameters kick in
1666: IF (l_log_statement >= l_log_current_level) THEN
1667: FND_LOG.string(l_log_statement, l_full_name, 'calling AHL_VWP_TASKS_PVT.Create_Task'||
1668: ' l_visit_id = '||l_visit_id);
1669: END IF;
1670: AHL_VWP_TASKS_PVT.Create_Task (
1671: p_api_version => 1.0,

Line 1679: FND_LOG.string(l_log_statement, l_full_name, 'called AHL_VWP_TASKS_PVT.Create_Task'||

1675: x_msg_count => x_msg_count,
1676: x_msg_data => x_msg_data
1677: );
1678: IF (l_log_statement >= l_log_current_level) THEN
1679: FND_LOG.string(l_log_statement, l_full_name, 'called AHL_VWP_TASKS_PVT.Create_Task'||
1680: ' l_task_rec.visit_task_id = '||l_task_rec.visit_task_id);
1681: END IF;
1682:
1683: -- if the call resulted in error, then raise it

Line 1686: FND_LOG.string(l_log_statement, l_full_name, 'call to AHL_VWP_TASKS_PVT.Create_Task errored out');

1682:
1683: -- if the call resulted in error, then raise it
1684: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1685: IF (l_log_statement >= l_log_current_level) THEN
1686: FND_LOG.string(l_log_statement, l_full_name, 'call to AHL_VWP_TASKS_PVT.Create_Task errored out');
1687: END IF;
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690:

Line 1720: FND_LOG.string(l_log_statement, l_full_name,' planning l_dst_locator_segments = '||l_dst_locator_segments);

1716: OPEN get_locator_segments_csr (l_visit_task_det_csr.comp_planning_loc_id);
1717: FETCH get_locator_segments_csr INTO l_dst_locator_segments, l_dst_subinv_name;
1718: CLOSE get_locator_segments_csr;
1719: IF (l_log_statement >= l_log_current_level) THEN
1720: FND_LOG.string(l_log_statement, l_full_name,' planning l_dst_locator_segments = '||l_dst_locator_segments);
1721: END IF;
1722:
1723: -- get the separator defined for the locator flexfield
1724: FND_PROFILE.put('MFG_ORGANIZATION_ID', p_item_inv_org_id); -- set mfg_organization_id profile - bug# 6010795

Line 1730: FND_LOG.string(l_log_statement, l_full_name,' l_sprtr = '||l_sprtr);

1726: l_fftype := FND_FLEX_KEY_API.find_flexfield('INV', 'MTLL'); -- get flexfield type
1727: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
1728: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
1729: IF (l_log_statement >= l_log_current_level) THEN
1730: FND_LOG.string(l_log_statement, l_full_name,' l_sprtr = '||l_sprtr);
1731: END IF;
1732:
1733: -- form the logical locator segments for the newly created task
1734: l_dst_locator_segments := SUBSTR(l_dst_locator_segments, 1, (LENGTH(l_dst_locator_segments)-1));

Line 1736: FND_LOG.string(l_log_statement, l_full_name,' substring l_dst_locator_segments = '||l_dst_locator_segments);

1732:
1733: -- form the logical locator segments for the newly created task
1734: l_dst_locator_segments := SUBSTR(l_dst_locator_segments, 1, (LENGTH(l_dst_locator_segments)-1));
1735: IF (l_log_statement >= l_log_current_level) THEN
1736: FND_LOG.string(l_log_statement, l_full_name,' substring l_dst_locator_segments = '||l_dst_locator_segments);
1737: END IF;
1738: l_dst_locator_segments := l_dst_locator_segments||
1739: l_visit_task_det_csr.project_number||l_sprtr||
1740: l_visit_task_det_csr.project_task_number;

Line 1742: FND_LOG.string(l_log_statement, l_full_name,' logical l_dst_locator_segments = '||l_dst_locator_segments);

1738: l_dst_locator_segments := l_dst_locator_segments||
1739: l_visit_task_det_csr.project_number||l_sprtr||
1740: l_visit_task_det_csr.project_task_number;
1741: IF (l_log_statement >= l_log_current_level) THEN
1742: FND_LOG.string(l_log_statement, l_full_name,' logical l_dst_locator_segments = '||l_dst_locator_segments);
1743: END IF;
1744: ELSE
1745: -- 1) Get the locator id for the destination repair batch
1746: -- - if it is non-serialized item and in-repair locator exists for the repair batch, then the destination locator

Line 1790: FND_LOG.string(l_log_statement, l_full_name, 'calling Perform_Mtl_Xfr');

1786: END IF;
1787:
1788: -- call the material transfer API, and let the defaults for input parameters kick in
1789: IF (l_log_statement >= l_log_current_level) THEN
1790: FND_LOG.string(l_log_statement, l_full_name, 'calling Perform_Mtl_Xfr');
1791: END IF;
1792: Perform_Mtl_Xfr (
1793: p_x_ahl_mtlxfr_tbl => l_ahl_mtlxfr_tbl,
1794: x_return_status => x_return_status,

Line 1799: FND_LOG.string(l_log_statement, l_full_name, 'called Perform_Mtl_Xfr');

1795: x_msg_count => x_msg_count,
1796: x_msg_data => x_msg_data
1797: );
1798: IF (l_log_statement >= l_log_current_level) THEN
1799: FND_LOG.string(l_log_statement, l_full_name, 'called Perform_Mtl_Xfr');
1800: END IF;
1801:
1802: IF (p_opr_flag = G_OP_CREATE) THEN
1803: -- get the locator id for the created repair batch

Line 1810: FND_LOG.string(l_log_statement, l_full_name, 'locator created = '||l_dst_locator_id);

1806: CLOSE get_locator_id_csr;
1807: l_dst_locator_id := l_locator_id_csr.planning_loc_id;
1808: l_dst_subinv_name := l_locator_id_csr.plannning_subinv;
1809: IF (l_log_statement >= l_log_current_level) THEN
1810: FND_LOG.string(l_log_statement, l_full_name, 'locator created = '||l_dst_locator_id);
1811: END IF;
1812: END IF;
1813:
1814: -- if the call resulted in error, then raise it

Line 1817: FND_LOG.string(l_log_statement, l_full_name, 'call to Perform_Mtl_Xfr errored out');

1813:
1814: -- if the call resulted in error, then raise it
1815: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1816: IF (l_log_statement >= l_log_current_level) THEN
1817: FND_LOG.string(l_log_statement, l_full_name, 'call to Perform_Mtl_Xfr errored out');
1818: END IF;
1819: RAISE FND_API.G_EXC_ERROR;
1820: END IF;
1821: -- ************************** IVth Material Transfer::End ************************** --

Line 1855: FND_LOG.string(l_log_statement, l_full_name,' l_task_id_tbl.COUNT = '||l_task_id_tbl.COUNT);

1851: OPEN get_applcbl_tasks_csr (p_x_dst_rpr_batch_name);
1852: FETCH get_applcbl_tasks_csr BULK COLLECT INTO l_task_id_tbl;
1853: CLOSE get_applcbl_tasks_csr;
1854: IF (l_log_statement >= l_log_current_level) THEN
1855: FND_LOG.string(l_log_statement, l_full_name,' l_task_id_tbl.COUNT = '||l_task_id_tbl.COUNT);
1856: END IF;
1857:
1858: -- update the tasks
1859: IF (l_task_id_tbl.COUNT > 0) THEN

Line 1882: FND_LOG.string(l_log_statement, l_full_name,' l_task_id_tbl.COUNT = '||l_task_id_tbl.COUNT);

1878: OPEN get_applcbl_tasks_csr (p_src_rpr_batch_name);
1879: FETCH get_applcbl_tasks_csr BULK COLLECT INTO l_task_id_tbl;
1880: CLOSE get_applcbl_tasks_csr;
1881: IF (l_log_statement >= l_log_current_level) THEN
1882: FND_LOG.string(l_log_statement, l_full_name,' l_task_id_tbl.COUNT = '||l_task_id_tbl.COUNT);
1883: END IF;
1884:
1885: -- update the tasks
1886: IF (l_task_id_tbl.COUNT > 0) THEN

Line 1898: FND_LOG.string(l_log_statement, l_full_name,

1894: END IF;
1895: -- ************************** Vth Repair Batch And Scope Update::End ************************** --
1896:
1897: IF (l_log_statement >= l_log_current_level) THEN
1898: FND_LOG.string(l_log_statement, l_full_name,
1899: ' p_x_dst_rpr_batch_name = '||p_x_dst_rpr_batch_name);
1900: END IF;
1901:
1902: -- Standard check of p_commit

Line 1908: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1904: COMMIT WORK;
1905: END IF;
1906:
1907: IF (l_log_procedure >= l_log_current_level) THEN
1908: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN

Line 1919: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

1915: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1916: p_data => x_msg_data,
1917: p_encoded => FND_API.G_FALSE);
1918: IF (l_log_exception >= l_log_current_level) THEN
1919: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
1920: END IF;
1921:
1922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1923: ROLLBACK TO Process_Repair_Item_Pvt;

Line 1929: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

1925: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1926: p_data => x_msg_data,
1927: p_encoded => FND_API.G_FALSE);
1928: IF (l_log_unexpected >= l_log_current_level) THEN
1929: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
1930: END IF;
1931:
1932: WHEN OTHERS THEN
1933: ROLLBACK TO Process_Repair_Item_Pvt;

Line 1944: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

1940: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1941: p_data => x_msg_data,
1942: p_encoded => fnd_api.G_FALSE);
1943: IF (l_log_unexpected >= l_log_current_level) THEN
1944: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
1945: END IF;
1946:
1947: END Process_Repair_Item;
1948: ------------------------------------------------------------------------------------

Line 2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2096: l_cost_price_rec.visit_task_id := p_repair_batch_id;
2097: l_cost_price_rec.cost_session_id := p_x_cost_session_id;
2098: l_cost_price_rec.mr_session_id := p_x_mr_session_id;
2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);

Line 2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);

2097: l_cost_price_rec.cost_session_id := p_x_cost_session_id;
2098: l_cost_price_rec.mr_session_id := p_x_mr_session_id;
2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');

Line 2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);

2098: l_cost_price_rec.mr_session_id := p_x_mr_session_id;
2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');
2106: END IF;

Line 2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);

2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');
2106: END IF;
2107:

Line 2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);

2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');
2106: END IF;
2107:
2108: AHL_VWP_COST_PVT.Calculate_WO_Cost(

Line 2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');

2101: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost visit ID:' || l_cost_price_rec.VISIT_ID);
2102: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost task ID:' || l_cost_price_rec.visit_task_id);
2103: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2104: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Calculate_WO_Cost');
2106: END IF;
2107:
2108: AHL_VWP_COST_PVT.Calculate_WO_Cost(
2109: p_api_version => p_api_version,

Line 2116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2112: p_validation_level => p_validation_level,
2113: p_x_cost_price_rec => l_cost_price_rec,
2114: x_return_status => l_return_status);
2115:
2116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2117: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Calculate_WO_Cost : l_return_status - '||l_return_status);
2118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2119: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2120: END IF;

Line 2117: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Calculate_WO_Cost : l_return_status - '||l_return_status);

2113: p_x_cost_price_rec => l_cost_price_rec,
2114: x_return_status => l_return_status);
2115:
2116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2117: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Calculate_WO_Cost : l_return_status - '||l_return_status);
2118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2119: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2120: END IF;
2121:

Line 2118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);

2114: x_return_status => l_return_status);
2115:
2116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2117: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Calculate_WO_Cost : l_return_status - '||l_return_status);
2118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2119: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2120: END IF;
2121:
2122: -- Check Error Message stack.

Line 2119: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);

2115:
2116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2117: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Calculate_WO_Cost : l_return_status - '||l_return_status);
2118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Session ID: ' || l_cost_price_rec.COST_SESSION_ID);
2119: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || l_cost_price_rec.MR_SESSION_ID);
2120: END IF;
2121:
2122: -- Check Error Message stack.
2123: l_msg_count := FND_MSG_PUB.count_msg;

Line 2139: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2135: FETCH get_wip_entity INTO l_wip_entity_rec;
2136: EXIT WHEN get_wip_entity%NOTFOUND;
2137:
2138:
2139: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2140: fnd_log.string(fnd_log.level_statement,L_DEBUG,'wip_entity_id - '||l_wip_entity_rec.wip_entity_id||' - '||'Visit task Id - '||l_wip_entity_rec.visit_task_id);
2141: END IF;
2142:
2143: IF l_wip_entity_rec.wip_entity_id IS NOT NULL THEN

Line 2140: fnd_log.string(fnd_log.level_statement,L_DEBUG,'wip_entity_id - '||l_wip_entity_rec.wip_entity_id||' - '||'Visit task Id - '||l_wip_entity_rec.visit_task_id);

2136: EXIT WHEN get_wip_entity%NOTFOUND;
2137:
2138:
2139: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2140: fnd_log.string(fnd_log.level_statement,L_DEBUG,'wip_entity_id - '||l_wip_entity_rec.wip_entity_id||' - '||'Visit task Id - '||l_wip_entity_rec.visit_task_id);
2141: END IF;
2142:
2143: IF l_wip_entity_rec.wip_entity_id IS NOT NULL THEN
2144:

Line 2145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2141: END IF;
2142:
2143: IF l_wip_entity_rec.wip_entity_id IS NOT NULL THEN
2144:
2145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Get_WO_Cost for all workorers');
2147: END IF;
2148:
2149: AHL_VWP_COST_PVT.Get_WO_Cost(

Line 2146: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Get_WO_Cost for all workorers');

2142:
2143: IF l_wip_entity_rec.wip_entity_id IS NOT NULL THEN
2144:
2145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before Calling AHL_VWP_COST_PVT.Get_WO_Cost for all workorers');
2147: END IF;
2148:
2149: AHL_VWP_COST_PVT.Get_WO_Cost(
2150: p_Session_Id => l_cost_price_rec.mr_session_id,

Line 2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2153: x_actual_cost => l_actual_cost,
2154: x_estimated_cost => l_estimated_cost,
2155: x_return_status => l_return_status);
2156:
2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Get_WO_Cost : l_return_status - '||l_return_status);
2159: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
2160: END IF;
2161:

Line 2158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Get_WO_Cost : l_return_status - '||l_return_status);

2154: x_estimated_cost => l_estimated_cost,
2155: x_return_status => l_return_status);
2156:
2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Get_WO_Cost : l_return_status - '||l_return_status);
2159: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
2160: END IF;
2161:
2162: -- Update with actual cost

Line 2159: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);

2155: x_return_status => l_return_status);
2156:
2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After Calling AHL_VWP_COST_PVT.Get_WO_Cost : l_return_status - '||l_return_status);
2159: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
2160: END IF;
2161:
2162: -- Update with actual cost
2163: UPDATE ahl_visit_tasks_b

Line 2477: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Instance already in In-Repair Locator');

2473: CLOSE is_in_repair_locator_csr;
2474:
2475: IF l_is_in_repair_csr = 'Y' THEN
2476: IF (l_log_statement >= l_log_current_level) THEN
2477: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Instance already in In-Repair Locator');
2478: END IF;
2479: RETURN;
2480: END IF;
2481:

Line 2494: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Create_Instance_in_WIP');

2490:
2491: IF l_item_inst_det_csr.serial_number IS NULL THEN
2492: -- 1) Create a dummy instance and issue it to the workorder
2493: IF (l_log_statement >= l_log_current_level) THEN
2494: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Create_Instance_in_WIP');
2495: END IF;
2496: AHL_CMP_PVT.Create_Instance_in_WIP(
2497: p_api_version => l_api_version,
2498: p_init_msg_list => Fnd_Api.g_false,

Line 2510: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Create_Instance_in_WIP errored out');

2506: x_msg_data => x_msg_data);
2507:
2508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2509: IF (l_log_statement >= l_log_current_level) THEN
2510: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Create_Instance_in_WIP errored out');
2511: END IF;
2512: RAISE FND_API.G_EXC_ERROR;
2513: END IF;
2514: /********************End of Dummy Instance Creation *********************************************/

Line 2517: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Updating tasks in repair batch to new instance');

2513: END IF;
2514: /********************End of Dummy Instance Creation *********************************************/
2515:
2516: IF (l_log_statement >= l_log_current_level) THEN
2517: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Updating tasks in repair batch to new instance');
2518: END IF;
2519: IF (l_log_statement >= l_log_current_level) THEN
2520: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before updating WOs');
2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task

Line 2520: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before updating WOs');

2516: IF (l_log_statement >= l_log_current_level) THEN
2517: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Updating tasks in repair batch to new instance');
2518: END IF;
2519: IF (l_log_statement >= l_log_current_level) THEN
2520: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before updating WOs');
2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2522: WHERE
2523: task.visit_task_id = wo.visit_task_id
2524: and task.instance_id = p_instance_id;

Line 2525: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2522: WHERE
2523: task.visit_task_id = wo.visit_task_id
2524: and task.instance_id = p_instance_id;
2525: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);
2526: END IF;
2527:
2528: -- get the list of wip entity ids
2529: OPEN get_wip_entity_ids_csr (p_instance_id, p_repair_batch_name);

Line 2540: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After updating WOs');

2536: WHERE repair_batch_name = p_repair_batch_name)
2537: AND instance_id = p_instance_id;
2538:
2539: IF (l_log_statement >= l_log_current_level) THEN
2540: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After updating WOs');
2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2542: WHERE
2543: task.visit_task_id = wo.visit_task_id
2544: and task.instance_id = p_instance_id;

Line 2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2542: WHERE
2543: task.visit_task_id = wo.visit_task_id
2544: and task.instance_id = p_instance_id;
2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);
2546: END IF;
2547: IF (l_log_statement >= l_log_current_level) THEN
2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'
2549: || 'process_wo');

Line 2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'

2544: and task.instance_id = p_instance_id;
2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);
2546: END IF;
2547: IF (l_log_statement >= l_log_current_level) THEN
2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'
2549: || 'process_wo');
2550: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2551: where maintenance_object_id = p_instance_id;
2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'

Line 2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'

2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'
2549: || 'process_wo');
2550: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2551: where maintenance_object_id = p_instance_id;
2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'
2553: || l_wipEntityIds);
2554: END IF;
2555: IF (l_log_statement >= l_log_current_level) THEN
2556: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Update_EAM_Workorders');

Line 2556: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Update_EAM_Workorders');

2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'
2553: || l_wipEntityIds);
2554: END IF;
2555: IF (l_log_statement >= l_log_current_level) THEN
2556: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Update_EAM_Workorders');
2557: END IF;
2558:
2559: FOR i IN l_wip_entity_tbl.FIRST .. l_wip_entity_tbl.LAST
2560: LOOP

Line 2577: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Update_EAM_Workorders errored out');

2573:
2574: /********************End of Update of EAM Workorders**************************************/
2575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576: IF (l_log_statement >= l_log_current_level) THEN
2577: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Update_EAM_Workorders errored out');
2578: END IF;
2579: RAISE FND_API.G_EXC_ERROR;
2580: END IF;
2581: END IF;

Line 2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'

2579: RAISE FND_API.G_EXC_ERROR;
2580: END IF;
2581: END IF;
2582: IF (l_log_statement >= l_log_current_level) THEN
2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
2584: || 'process_wo');
2585: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2586: where maintenance_object_id = p_instance_id;
2587: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount after exec'

Line 2587: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount after exec'

2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
2584: || 'process_wo');
2585: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2586: where maintenance_object_id = p_instance_id;
2587: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount after exec'
2588: || l_wipEntityIds);
2589: END IF;
2590: OPEN get_visit_task_det_csr (p_repair_batch_name);
2591: FETCH get_visit_task_det_csr INTO l_visit_task_det_csr;

Line 2609: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' physical l_dst_locator_segments = '||l_dst_locator_segments);

2605: FETCH get_locator_segments_csr INTO l_dst_locator_segments, l_dst_subinv_name;
2606: CLOSE get_locator_segments_csr;
2607:
2608: IF (l_log_statement >= l_log_current_level) THEN
2609: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' physical l_dst_locator_segments = '||l_dst_locator_segments);
2610: END IF;
2611:
2612: -- get the separator defined for the locator flexfield
2613: FND_PROFILE.put('MFG_ORGANIZATION_ID', l_item_inst_det_csr.inv_organization_id); -- set mfg_organization_id profile - bug# 6010795

Line 2620: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' l_sprtr = '||l_sprtr);

2616: l_ffstrctr := FND_FLEX_KEY_API.find_structure(l_fftype, 101); -- get flexfield structure type
2617: l_sprtr := l_ffstrctr.segment_separator; -- get flexfield segment separator
2618:
2619: IF (l_log_statement >= l_log_current_level) THEN
2620: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' l_sprtr = '||l_sprtr);
2621: END IF;
2622:
2623: -- form the logical locator segments for the newly created task
2624: l_dst_locator_segments := SUBSTR(l_dst_locator_segments, 1, (LENGTH(l_dst_locator_segments)-1));

Line 2627: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' substring l_dst_locator_segments = '||l_dst_locator_segments);

2623: -- form the logical locator segments for the newly created task
2624: l_dst_locator_segments := SUBSTR(l_dst_locator_segments, 1, (LENGTH(l_dst_locator_segments)-1));
2625:
2626: IF (l_log_statement >= l_log_current_level) THEN
2627: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' substring l_dst_locator_segments = '||l_dst_locator_segments);
2628: END IF;
2629:
2630: l_dst_locator_segments := l_dst_locator_segments||
2631: l_visit_task_det_csr.project_number||l_sprtr||

Line 2635: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' logical l_dst_locator_segments = '||l_dst_locator_segments);

2631: l_visit_task_det_csr.project_number||l_sprtr||
2632: l_visit_task_det_csr.project_task_number;
2633:
2634: IF (l_log_statement >= l_log_current_level) THEN
2635: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' logical l_dst_locator_segments = '||l_dst_locator_segments);
2636: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_locator_id = '|| l_src_locator_id);
2637: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_subinv_name = '|| l_src_subinv_name);
2638: END IF;
2639:

Line 2636: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_locator_id = '|| l_src_locator_id);

2632: l_visit_task_det_csr.project_task_number;
2633:
2634: IF (l_log_statement >= l_log_current_level) THEN
2635: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' logical l_dst_locator_segments = '||l_dst_locator_segments);
2636: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_locator_id = '|| l_src_locator_id);
2637: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_subinv_name = '|| l_src_subinv_name);
2638: END IF;
2639:
2640: -- 2) Populate the material transfer record and call the API

Line 2637: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_subinv_name = '|| l_src_subinv_name);

2633:
2634: IF (l_log_statement >= l_log_current_level) THEN
2635: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' logical l_dst_locator_segments = '||l_dst_locator_segments);
2636: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_locator_id = '|| l_src_locator_id);
2637: FND_LOG.string(l_log_statement, L_DEBUG_KEY,' src_subinv_name = '|| l_src_subinv_name);
2638: END IF;
2639:
2640: -- 2) Populate the material transfer record and call the API
2641: l_ahl_mtlxfr_tbl(0).inventory_item_id := l_item_inst_det_csr.inventory_item_id;

Line 2656: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'calling Perform_Mtl_Xfr');

2652: l_ahl_mtlxfr_tbl(0).dst_locator_segments := l_dst_locator_segments;
2653:
2654: -- call the material transfer API, and let the defaults for input parameters kick in
2655: IF (l_log_statement >= l_log_current_level) THEN
2656: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'calling Perform_Mtl_Xfr');
2657: END IF;
2658: Perform_Mtl_Xfr (
2659: p_x_ahl_mtlxfr_tbl => l_ahl_mtlxfr_tbl,
2660: x_return_status => x_return_status,

Line 2665: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'called Perform_Mtl_Xfr');

2661: x_msg_count => x_msg_count,
2662: x_msg_data => x_msg_data
2663: );
2664: IF (l_log_statement >= l_log_current_level) THEN
2665: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'called Perform_Mtl_Xfr');
2666: END IF;
2667:
2668: -- if the call resulted in error, then raise it
2669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2671: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Perform_Mtl_Xfr errored out');

2667:
2668: -- if the call resulted in error, then raise it
2669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2670: IF (l_log_statement >= l_log_current_level) THEN
2671: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Perform_Mtl_Xfr errored out');
2672: END IF;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;
2675: /********************End of Material Transfer ***************************************************/

Line 2682: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Update tasks with the instance');

2678:
2679: IF l_item_inst_det_csr.serial_number IS NULL THEN
2680:
2681: IF (l_log_statement >= l_log_current_level) THEN
2682: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Update tasks with the instance');
2683: END IF;
2684:
2685: -- get the in-repair locator id
2686: OPEN get_inrepair_locator_id_csr (p_repair_batch_name);

Line 2696: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Instance ID from inrepair locator:'

2692: FETCH get_in_repair_instance_csr INTO l_locator_inst_id;
2693: CLOSE get_in_repair_instance_csr;
2694:
2695: IF (l_log_statement >= l_log_current_level) THEN
2696: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Instance ID from inrepair locator:'
2697: || l_locator_inst_id);
2698: END IF;
2699:
2700: -- Update all the tasks in the repair batch with the new locator instance id

Line 2707: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Update_EAM_Workorders');

2703: WHERE repair_batch_name = p_repair_batch_name)
2704: AND instance_id = l_new_instance_id;
2705:
2706: IF (l_log_statement >= l_log_current_level) THEN
2707: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Calling AHL_CMP_PVT.Update_EAM_Workorders');
2708: END IF;
2709: -- Update EAM workorders with the new locator instance ID
2710: FOR i IN l_wip_entity_tbl.FIRST .. l_wip_entity_tbl.LAST
2711: LOOP

Line 2727: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Update_EAM_Workorders errored out');

2723:
2724: /********************End of Update of EAM Workorders**************************************/
2725: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2726: IF (l_log_statement >= l_log_current_level) THEN
2727: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'call to Update_EAM_Workorders errored out');
2728: END IF;
2729: RAISE FND_API.G_EXC_ERROR;
2730: END IF;
2731:

Line 2763: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'calling expire_item_instance');

2759:
2760: l_csi_instance_rec.object_version_number := l_dummy;
2761:
2762: IF (l_log_statement >= l_log_current_level) THEN
2763: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'calling expire_item_instance');
2764: END IF;
2765:
2766: CSI_ITEM_INSTANCE_PUB.expire_item_instance(
2767: p_api_version => 1.0,

Line 2778: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Error in CSI_ITEM_INSTANCE_PUB.expire_item_instance');

2774: x_msg_data => x_msg_data);
2775:
2776: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2777: IF (l_log_statement >= l_log_current_level) THEN
2778: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Error in CSI_ITEM_INSTANCE_PUB.expire_item_instance');
2779: END IF;
2780: RAISE FND_API.G_EXC_ERROR;
2781: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2782: IF (l_log_statement >= l_log_current_level) THEN

Line 2783: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Error in CSI_ITEM_INSTANCE_PUB.expire_item_instance');

2779: END IF;
2780: RAISE FND_API.G_EXC_ERROR;
2781: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2782: IF (l_log_statement >= l_log_current_level) THEN
2783: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'Error in CSI_ITEM_INSTANCE_PUB.expire_item_instance');
2784: END IF;
2785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2786: END IF;
2787:

Line 2789: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'called expire_item_instance');

2785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2786: END IF;
2787:
2788: IF (l_log_statement >= l_log_current_level) THEN
2789: FND_LOG.string(l_log_statement, L_DEBUG_KEY, 'called expire_item_instance');
2790: END IF;
2791:
2792: END IF;
2793:

Line 3004: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling CSI_ITEM_INSTANCE_PUB.'

3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002:
3003: IF (l_log_statement >= l_log_current_level) THEN
3004: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling CSI_ITEM_INSTANCE_PUB.'
3005: || 'create_item_instance');
3006: END IF;
3007:
3008: l_csi_transaction_rec.source_transaction_date := SYSDATE;

Line 3026: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling CSI_ITEM_INSTANCE_PUB.'

3022: x_msg_count => x_msg_count,
3023: x_msg_data => x_msg_data);
3024:
3025: IF (l_log_statement >= l_log_current_level) THEN
3026: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling CSI_ITEM_INSTANCE_PUB.'
3027: || 'create_item_instance');
3028: END IF;
3029:
3030: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3037: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'New Instance ID: ' || x_new_instance_id);

3033:
3034: x_new_instance_id := l_csi_instance_rec.instance_id;
3035:
3036: IF (l_log_statement >= l_log_current_level) THEN
3037: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'New Instance ID: ' || x_new_instance_id);
3038: END IF;
3039:
3040: -- Standard check of p_commit
3041: IF FND_API.To_Boolean(p_commit) THEN

Line 3226: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'

3222: );
3223:
3224:
3225: IF (l_log_statement >= l_log_current_level) THEN
3226: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
3227: || 'process_wo');
3228: END IF;
3229:
3230: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3232: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Error occured during setting instance '

3228: END IF;
3229:
3230: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3231: IF (l_log_statement >= l_log_current_level) THEN
3232: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Error occured during setting instance '
3233: || 'for EAM workorders');
3234: END IF;
3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3236: END IF;

Line 3519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3515: -- Initialize API return status to success
3516: x_return_status := FND_API.G_RET_STS_SUCCESS;
3517:
3518:
3519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3520: fnd_log.string(l_log_statement,l_debug,'Entering Perform Return Txn API');
3521: END IF;
3522:
3523:

Line 3520: fnd_log.string(l_log_statement,l_debug,'Entering Perform Return Txn API');

3516: x_return_status := FND_API.G_RET_STS_SUCCESS;
3517:
3518:
3519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3520: fnd_log.string(l_log_statement,l_debug,'Entering Perform Return Txn API');
3521: END IF;
3522:
3523:
3524: IF (p_x_ahl_mtlrtn_tbl.COUNT > 0) THEN

Line 3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3524: IF (p_x_ahl_mtlrtn_tbl.COUNT > 0) THEN
3525:
3526: FOR i IN p_x_ahl_mtlrtn_tbl.FIRST..p_x_ahl_mtlrtn_tbl.LAST LOOP
3527:
3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);

Line 3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');

3525:
3526: FOR i IN p_x_ahl_mtlrtn_tbl.FIRST..p_x_ahl_mtlrtn_tbl.LAST LOOP
3527:
3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);

Line 3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);

3526: FOR i IN p_x_ahl_mtlrtn_tbl.FIRST..p_x_ahl_mtlrtn_tbl.LAST LOOP
3527:
3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);

Line 3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);

3527:
3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);

Line 3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);

3528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);

Line 3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);

3529: fnd_log.string(l_log_statement,l_debug,'Inputs to this API:: For Rec[' || i || ']');
3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);

Line 3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);

3530: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Id - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id);
3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);

Line 3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);

3531: fnd_log.string(l_log_statement,l_debug,'Repair_Batch_Name - ' || p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Name);
3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);

Line 3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);

3532: fnd_log.string(l_log_statement,l_debug,'Inventory_Item_Id - ' || p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id);
3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);

Line 3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);

3533: fnd_log.string(l_log_statement,l_debug,'Revision - ' || p_x_ahl_mtlrtn_tbl(i).Revision);
3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);

Line 3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);

3534: fnd_log.string(l_log_statement,l_debug,'Organization_Id - ' || p_x_ahl_mtlrtn_tbl(i).Organization_Id);
3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);

Line 3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);

3535: fnd_log.string(l_log_statement,l_debug,'Src_Subinv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Src_Subinv_Name);
3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);

Line 3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);

3536: fnd_log.string(l_log_statement,l_debug,'Src_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Src_Locator_Id);
3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);

Line 3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);

3537: fnd_log.string(l_log_statement,l_debug,'Dst_SubInv_Name - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name);
3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);

Line 3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);

3538: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Id - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Id);
3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);
3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);

Line 3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);

3539: fnd_log.string(l_log_statement,l_debug,'Dst_Locator_Segments - ' || p_x_ahl_mtlrtn_tbl(i).Dst_Locator_Segments);
3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);
3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);
3547: END IF;

Line 3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);

3540: fnd_log.string(l_log_statement,l_debug,'Instance_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Qty);
3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);
3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);
3547: END IF;
3548:

Line 3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);

3541: fnd_log.string(l_log_statement,l_debug,'Return_Qty - ' || p_x_ahl_mtlrtn_tbl(i).Return_Qty);
3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);
3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);
3547: END IF;
3548:
3549:

Line 3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);

3542: fnd_log.string(l_log_statement,l_debug,'Uom - ' || p_x_ahl_mtlrtn_tbl(i).Uom);
3543: fnd_log.string(l_log_statement,l_debug,'Serial_Number - ' || p_x_ahl_mtlrtn_tbl(i).Serial_Number);
3544: fnd_log.string(l_log_statement,l_debug,'Lot_Number - ' || p_x_ahl_mtlrtn_tbl(i).Lot_Number);
3545: fnd_log.string(l_log_statement,l_debug,'Instance_Id - ' || p_x_ahl_mtlrtn_tbl(i).Instance_Id);
3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);
3547: END IF;
3548:
3549:
3550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 3550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3546: fnd_log.string(l_log_statement,l_debug,'Return_Condition - ' || p_x_ahl_mtlrtn_tbl(i).Return_Condition);
3547: END IF;
3548:
3549:
3550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3551: fnd_log.string(l_log_statement,l_debug,'calling Validate_Rtn_Rec for i=['||i||']');
3552: END IF;
3553:
3554: --Call Validate_Rtn_Rec to validate the material return record.

Line 3551: fnd_log.string(l_log_statement,l_debug,'calling Validate_Rtn_Rec for i=['||i||']');

3547: END IF;
3548:
3549:
3550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3551: fnd_log.string(l_log_statement,l_debug,'calling Validate_Rtn_Rec for i=['||i||']');
3552: END IF;
3553:
3554: --Call Validate_Rtn_Rec to validate the material return record.
3555: Validate_Rtn_Rec

Line 3563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3559: x_msg_count => x_msg_count,
3560: x_msg_data => x_msg_data
3561: );
3562:
3563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3564: fnd_log.string(l_log_statement,l_debug,'After calling Validate_Rtn_Rec');
3565: END IF;
3566:
3567:

Line 3564: fnd_log.string(l_log_statement,l_debug,'After calling Validate_Rtn_Rec');

3560: x_msg_data => x_msg_data
3561: );
3562:
3563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3564: fnd_log.string(l_log_statement,l_debug,'After calling Validate_Rtn_Rec');
3565: END IF;
3566:
3567:
3568: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 3571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3567:
3568: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3569: l_error := true;
3570:
3571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3572: fnd_log.string(l_log_statement,l_debug,'Error in Validate_Rtn_Rec');
3573: END IF;
3574: END IF;
3575: END LOOP;

Line 3572: fnd_log.string(l_log_statement,l_debug,'Error in Validate_Rtn_Rec');

3568: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3569: l_error := true;
3570:
3571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3572: fnd_log.string(l_log_statement,l_debug,'Error in Validate_Rtn_Rec');
3573: END IF;
3574: END IF;
3575: END LOOP;
3576:

Line 3600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3596: l_ahl_mtlxfr_tbl(0).Transaction_Reference := 'AHL - ' || p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name ;
3597: l_ahl_mtlxfr_tbl(0).Serial_Number := p_x_ahl_mtlrtn_tbl(i).Serial_Number;
3598: l_ahl_mtlxfr_tbl(0).Lot_Number := p_x_ahl_mtlrtn_tbl(i).Lot_Number;
3599:
3600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3601: fnd_log.string(l_log_statement,l_debug,'Calling Perform_Mtl_Xfr API...');
3602: END IF;
3603:
3604: Perform_Mtl_Xfr

Line 3601: fnd_log.string(l_log_statement,l_debug,'Calling Perform_Mtl_Xfr API...');

3597: l_ahl_mtlxfr_tbl(0).Serial_Number := p_x_ahl_mtlrtn_tbl(i).Serial_Number;
3598: l_ahl_mtlxfr_tbl(0).Lot_Number := p_x_ahl_mtlrtn_tbl(i).Lot_Number;
3599:
3600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3601: fnd_log.string(l_log_statement,l_debug,'Calling Perform_Mtl_Xfr API...');
3602: END IF;
3603:
3604: Perform_Mtl_Xfr
3605: (

Line 3613: FND_LOG.string(l_log_statement, l_debug, 'After calling Perform_Mtl_Xfr API...ret_status['||x_return_status||']');

3609: x_msg_data => x_msg_data
3610: );
3611:
3612: IF (l_log_statement >= l_log_current_level) THEN
3613: FND_LOG.string(l_log_statement, l_debug, 'After calling Perform_Mtl_Xfr API...ret_status['||x_return_status||']');
3614: END IF;
3615:
3616: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3617: RAISE FND_API.G_EXC_ERROR;

Line 3637: FND_LOG.string(l_log_statement, l_debug, 'Workorder - ' || l_workorder_name || ' is updated with Quantity ::' || l_remaining_qty );

3633: SET quantity = l_remaining_qty
3634: WHERE visit_task_id = l_visit_task_id ;
3635:
3636: IF (l_log_statement >= l_log_current_level) THEN
3637: FND_LOG.string(l_log_statement, l_debug, 'Workorder - ' || l_workorder_name || ' is updated with Quantity ::' || l_remaining_qty );
3638: END IF;
3639: END LOOP;
3640: END IF;
3641:

Line 3669: FND_LOG.string(l_log_statement, l_debug, 'after PartsChange Part-Condition-Update api:ret status=['||x_return_status||']');

3665: x_msg_count => x_msg_count
3666: );
3667:
3668: IF (l_log_statement >= l_log_current_level) THEN
3669: FND_LOG.string(l_log_statement, l_debug, 'after PartsChange Part-Condition-Update api:ret status=['||x_return_status||']');
3670: END IF;
3671:
3672: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3673: RAISE FND_API.G_EXC_ERROR;

Line 3694: FND_LOG.string(l_log_statement, l_debug, 'RTS Workorder Details - ' || 'Workorder Name: ' || l_rts_wo_dtls_rec.workorder_name || ' Wip Entity ID: ' || l_rts_wo_dtls_rec.wip_entity_id );

3690: FETCH Get_RTS_WO_Details INTO l_rts_wo_dtls_rec;
3691: CLOSE Get_RTS_WO_Details;
3692:
3693: IF (l_log_statement >= l_log_current_level) THEN
3694: FND_LOG.string(l_log_statement, l_debug, 'RTS Workorder Details - ' || 'Workorder Name: ' || l_rts_wo_dtls_rec.workorder_name || ' Wip Entity ID: ' || l_rts_wo_dtls_rec.wip_entity_id );
3695: END IF;
3696:
3697: IF ( p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id = l_rts_wo_dtls_rec.REBUILD_ITEM_ID AND p_x_ahl_mtlrtn_tbl(i).Instance_Id = l_rts_wo_dtls_rec.MAINTENANCE_OBJECT_ID ) THEN
3698:

Line 3700: FND_LOG.string(l_log_statement, l_debug, 'Return Item is same as Workorder Header Item');

3696:
3697: IF ( p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id = l_rts_wo_dtls_rec.REBUILD_ITEM_ID AND p_x_ahl_mtlrtn_tbl(i).Instance_Id = l_rts_wo_dtls_rec.MAINTENANCE_OBJECT_ID ) THEN
3698:
3699: IF (l_log_statement >= l_log_current_level) THEN
3700: FND_LOG.string(l_log_statement, l_debug, 'Return Item is same as Workorder Header Item');
3701: END IF;
3702:
3703: OPEN Check_WO_WO_Resv_Exists(l_rts_wo_dtls_rec.wip_entity_id);
3704: FETCH Check_WO_WO_Resv_Exists into l_resv_rec;

Line 3707: FND_LOG.string(l_log_statement, l_debug, 'WO-WO Resv Exists,Resv ID = ' || l_resv_rec.reservation_id || ' ,SupplySource = ' || l_resv_rec.SUPPLY_SOURCE_HEADER_ID || ' ,DemandSource = ' || l_resv_rec.DEMAND_SOURCE_HEADER_ID);

3703: OPEN Check_WO_WO_Resv_Exists(l_rts_wo_dtls_rec.wip_entity_id);
3704: FETCH Check_WO_WO_Resv_Exists into l_resv_rec;
3705: IF Check_WO_WO_Resv_Exists%FOUND THEN
3706: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
3707: FND_LOG.string(l_log_statement, l_debug, 'WO-WO Resv Exists,Resv ID = ' || l_resv_rec.reservation_id || ' ,SupplySource = ' || l_resv_rec.SUPPLY_SOURCE_HEADER_ID || ' ,DemandSource = ' || l_resv_rec.DEMAND_SOURCE_HEADER_ID);
3708: END IF;
3709: l_wo_wo_resv_flag := true;
3710: END IF;
3711: Close Check_WO_WO_Resv_Exists;

Line 3716: FND_LOG.string(l_log_statement, l_debug, 'Return Condition is Unserviceable');

3712:
3713: IF (L_WO_WO_RESV_FLAG = TRUE) THEN
3714: IF (p_x_ahl_mtlrtn_tbl(i).Return_Condition = G_AHL_UNSERVICEABLE_CONDITION) THEN
3715: IF (l_log_statement >= l_log_current_level) THEN
3716: FND_LOG.string(l_log_statement, l_debug, 'Return Condition is Unserviceable');
3717: END IF;
3718: l_del_flag := true;
3719:
3720: ELSE

Line 3730: FND_LOG.string(l_log_statement, l_debug, 'Destination SubInventory is not Reservable');

3726: AND SECONDARY_INVENTORY_NAME = p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name ;
3727:
3728: IF (l_reservable <> 1) THEN
3729: IF (l_log_statement >= l_log_current_level) THEN
3730: FND_LOG.string(l_log_statement, l_debug, 'Destination SubInventory is not Reservable');
3731: END IF;
3732: l_del_flag := true;
3733: ELSE
3734: l_del_flag := true;

Line 3744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3740:
3741: IF (l_del_flag = true) THEN
3742: mo_global.init('AHL');
3743:
3744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3745: fnd_log.string(l_log_statement, l_debug,'Calling Delete_Reservation API...');
3746: END IF;
3747: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION
3748: (

Line 3745: fnd_log.string(l_log_statement, l_debug,'Calling Delete_Reservation API...');

3741: IF (l_del_flag = true) THEN
3742: mo_global.init('AHL');
3743:
3744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3745: fnd_log.string(l_log_statement, l_debug,'Calling Delete_Reservation API...');
3746: END IF;
3747: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION
3748: (
3749: p_api_version => 1.0,

Line 3761: FND_LOG.string(l_log_statement, l_debug, 'After Delete_Reservation API...ret_status['||x_return_status||']');

3757: p_reservation_id => l_resv_rec.reservation_id
3758: );
3759:
3760: IF (l_log_statement >= l_log_current_level) THEN
3761: FND_LOG.string(l_log_statement, l_debug, 'After Delete_Reservation API...ret_status['||x_return_status||']');
3762: END IF;
3763:
3764: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3765: RAISE FND_API.G_EXC_ERROR;

Line 3785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3781:
3782: l_serial_number_tbl(1).inventory_item_id := p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id ;
3783: l_serial_number_tbl(1).serial_number := p_x_ahl_mtlrtn_tbl(i).Serial_Number;
3784:
3785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3786: fnd_log.string(l_log_statement, l_debug,'Calling Process_Reservation API...');
3787: END IF;
3788:
3789: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION

Line 3786: fnd_log.string(l_log_statement, l_debug,'Calling Process_Reservation API...');

3782: l_serial_number_tbl(1).inventory_item_id := p_x_ahl_mtlrtn_tbl(i).Inventory_Item_Id ;
3783: l_serial_number_tbl(1).serial_number := p_x_ahl_mtlrtn_tbl(i).Serial_Number;
3784:
3785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3786: fnd_log.string(l_log_statement, l_debug,'Calling Process_Reservation API...');
3787: END IF;
3788:
3789: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION
3790: (

Line 3805: FND_LOG.string(l_log_statement, l_debug, 'After Process_Reservation API...ret_status['||x_return_status||']');

3801: x_reservation_id_tbl => l_x_serial_number_tbl
3802: );
3803:
3804: IF (l_log_statement >= l_log_current_level) THEN
3805: FND_LOG.string(l_log_statement, l_debug, 'After Process_Reservation API...ret_status['||x_return_status||']');
3806: END IF;
3807:
3808: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3809: RAISE FND_API.G_EXC_ERROR;

Line 3831: FND_LOG.string(l_log_statement, l_debug, 'Calling AHL_VWP_TASKS_PVT.Delete_Task - ' || 'Summary Task ID: ' || l_visit_task_id );

3827: FETCH Get_Child_Summary_Tasks INTO l_visit_task_id;
3828: EXIT WHEN Get_Child_Summary_Tasks%NOTFOUND;
3829:
3830: IF (l_log_statement >= l_log_current_level) THEN
3831: FND_LOG.string(l_log_statement, l_debug, 'Calling AHL_VWP_TASKS_PVT.Delete_Task - ' || 'Summary Task ID: ' || l_visit_task_id );
3832: END IF;
3833:
3834: AHL_VWP_TASKS_PVT.Delete_Task
3835: (

Line 3848: FND_LOG.string(l_log_statement, l_debug, 'After Delete_Task API...ret_status['||x_return_status||']');

3844: x_msg_data => x_msg_data
3845: );
3846:
3847: IF (l_log_statement >= l_log_current_level) THEN
3848: FND_LOG.string(l_log_statement, l_debug, 'After Delete_Task API...ret_status['||x_return_status||']');
3849: END IF;
3850:
3851: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3852: RAISE FND_API.G_EXC_ERROR;

Line 3865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3861:
3862: END LOOP;
3863: END IF;
3864:
3865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3866: fnd_log.string(l_log_statement, l_debug,'End of Perform Return Txn API');
3867: END IF;
3868:
3869: -- Standard check of p_commit

Line 3866: fnd_log.string(l_log_statement, l_debug,'End of Perform Return Txn API');

3862: END LOOP;
3863: END IF;
3864:
3865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3866: fnd_log.string(l_log_statement, l_debug,'End of Perform Return Txn API');
3867: END IF;
3868:
3869: -- Standard check of p_commit
3870: IF FND_API.To_Boolean(p_commit) THEN