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

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

273: G_PKG_NAME)
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
279: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
280: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
281: );

Line 278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
279: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
280: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
281: );
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
279: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
280: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
281: );
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
283: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
284: ' :p_Mrshl_search_rec.item_instance_id : ' || p_Mrshl_search_rec.item_instance_id
285: );
286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
283: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
284: ' :p_Mrshl_search_rec.item_instance_id : ' || p_Mrshl_search_rec.item_instance_id
285: );
286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
287: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
288: ' :p_Mrshl_search_rec.Workorder_name : ' || p_Mrshl_search_rec.Workorder_name
289: );
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
287: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
288: ' :p_Mrshl_search_rec.Workorder_name : ' || p_Mrshl_search_rec.Workorder_name
289: );
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
291: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
292: ' :p_Mrshl_search_rec.Item_name : ' || p_Mrshl_search_rec.Item_name
293: );
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
291: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
292: ' :p_Mrshl_search_rec.Item_name : ' || p_Mrshl_search_rec.Item_name
293: );
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
295: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
296: ' :p_Mrshl_search_rec.Item_Desc : ' || p_Mrshl_search_rec.Item_Desc
297: );
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
295: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
296: ' :p_Mrshl_search_rec.Item_Desc : ' || p_Mrshl_search_rec.Item_Desc
297: );
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
299: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
300: ' :p_Mrshl_search_rec.Search_mode : ' || p_Mrshl_search_rec.Search_mode
301: );
302: END IF;

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

315: l_root_instance_id := p_Mrshl_search_rec.item_instance_id;
316: END IF;
317: j := 1;
318:
319: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
321: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
322: ' :l_root_instance_id : ' || l_root_instance_id
323: );

Line 320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

316: END IF;
317: j := 1;
318:
319: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
321: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
322: ' :l_root_instance_id : ' || l_root_instance_id
323: );
324: END IF;

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

359: l_unavailable_items_tbl(j).quantity := unavail_item_csr.not_available_quantity;
360: l_unavailable_items_tbl(j).onhand_quantity := unavail_item_csr.not_available_quantity;
361: l_unavailable_items_tbl(j).exception_date := unavail_item_csr.exception_date;
362: l_unavailable_items_tbl(j).reserved_quantity := unavail_item_csr.reserved_quantity;
363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
366: ' :unavail_item_csr.not_available_quantity : ' || unavail_item_csr.not_available_quantity
367: );

Line 364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

360: l_unavailable_items_tbl(j).onhand_quantity := unavail_item_csr.not_available_quantity;
361: l_unavailable_items_tbl(j).exception_date := unavail_item_csr.exception_date;
362: l_unavailable_items_tbl(j).reserved_quantity := unavail_item_csr.reserved_quantity;
363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
366: ' :unavail_item_csr.not_available_quantity : ' || unavail_item_csr.not_available_quantity
367: );
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
365: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
366: ' :unavail_item_csr.not_available_quantity : ' || unavail_item_csr.not_available_quantity
367: );
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
369: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
370: ' :unavail_item_csr.REQUIRED_QUANTITY : ' || unavail_item_csr.REQUIRED_QUANTITY
371: );
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
369: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
370: ' :unavail_item_csr.REQUIRED_QUANTITY : ' || unavail_item_csr.REQUIRED_QUANTITY
371: );
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
374: ' :unavail_item_csr.Issued_Quantity : ' || unavail_item_csr.Issued_Quantity
375: );
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
373: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
374: ' :unavail_item_csr.Issued_Quantity : ' || unavail_item_csr.Issued_Quantity
375: );
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
377: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
378: ' :unavail_item_csr.available_quantity : ' || unavail_item_csr.available_quantity
379: );
380: END IF;

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

471:
472: j:= j+1;
473: END LOOP;
474: END IF;
475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
477: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
478: ' :j : ' || j);
479: END IF;

Line 476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

472: j:= j+1;
473: END LOOP;
474: END IF;
475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
477: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
478: ' :j : ' || j);
479: END IF;
480: x_unavailable_items_tbl := l_unavailable_items_tbl;

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

695: THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698:
699: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
701: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
702: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
703: );

Line 700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698:
699: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
701: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
702: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
703: );
704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
701: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
702: ' :p_Mrshl_search_rec.Visit_id : ' || p_Mrshl_search_rec.Visit_id
703: );
704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
705: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
706: ' :p_Mrshl_search_rec.item_instance_id : ' || p_Mrshl_search_rec.item_instance_id
707: );
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
705: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
706: ' :p_Mrshl_search_rec.item_instance_id : ' || p_Mrshl_search_rec.item_instance_id
707: );
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
709: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
710: ' :p_Mrshl_search_rec.Workorder_name : ' || p_Mrshl_search_rec.Workorder_name
711: );
712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
709: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
710: ' :p_Mrshl_search_rec.Workorder_name : ' || p_Mrshl_search_rec.Workorder_name
711: );
712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
713: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
714: ' :p_Mrshl_search_rec.Item_name : ' || p_Mrshl_search_rec.Item_name
715: );
716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
713: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
714: ' :p_Mrshl_search_rec.Item_name : ' || p_Mrshl_search_rec.Item_name
715: );
716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
717: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
718: ' :p_Mrshl_search_rec.Item_Desc : ' || p_Mrshl_search_rec.Item_Desc
719: );
720: END IF;

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

733: CLOSE get_root_items_instance_csr;*/
734: l_root_instance_id := p_Mrshl_search_rec.item_instance_id;
735: END IF;
736:
737: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
740: ' :l_root_instance_id : ' || l_root_instance_id
741: );

Line 738: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

734: l_root_instance_id := p_Mrshl_search_rec.item_instance_id;
735: END IF;
736:
737: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
740: ' :l_root_instance_id : ' || l_root_instance_id
741: );
742: END IF;

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

851: END IF;
852: j:= j+1;
853: END LOOP;
854: END IF;
855: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
857: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
858: ' Count : ' || to_char(j -1));
859: END IF;

Line 856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

852: j:= j+1;
853: END LOOP;
854: END IF;
855: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
857: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
858: ' Count : ' || to_char(j -1));
859: END IF;
860: x_available_items_tbl := l_available_items_tbl;

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

1546: END LOOP;
1547: END IF;
1548:
1549:
1550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1552: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
1553: 'At the end of the procedure');
1554: END IF;

Line 1551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1547: END IF;
1548:
1549:
1550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1552: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution',
1553: 'At the end of the procedure');
1554: END IF;
1555:

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

1657: j NUMBER;
1658: l_allowed_quantity NUMBER;
1659:
1660: BEGIN
1661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1663: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1664: 'At the start of the procedure');
1665: END IF;

Line 1662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1658: l_allowed_quantity NUMBER;
1659:
1660: BEGIN
1661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1663: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1664: 'At the start of the procedure');
1665: END IF;
1666:

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

1692: l_Uc_mrshl_details_tbl(j).parent_rel_id := l_uc_descendant_tbl(i).parent_rel_id;
1693: l_Uc_mrshl_details_tbl(j).POSITION := l_uc_descendant_tbl(i).position_reference;
1694:
1695: l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID := l_uc_descendant_tbl(i).INSTANCE_ID;
1696: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1697: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1698: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1699: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1700: END IF;

Line 1697: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1693: l_Uc_mrshl_details_tbl(j).POSITION := l_uc_descendant_tbl(i).position_reference;
1694:
1695: l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID := l_uc_descendant_tbl(i).INSTANCE_ID;
1696: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1697: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1698: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1699: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1700: END IF;
1701: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;

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

1698: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1699: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1700: END IF;
1701: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;
1702: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1704: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1705: 'l_uc_descendant_tbl(i).parent_instance_id :: ' || l_uc_descendant_tbl(i).parent_instance_id);
1706: END IF;

Line 1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1699: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1700: END IF;
1701: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;
1702: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1704: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1705: 'l_uc_descendant_tbl(i).parent_instance_id :: ' || l_uc_descendant_tbl(i).parent_instance_id);
1706: END IF;
1707: IF l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID IS NOT NULL THEN

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

1732: AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
1733: p_relationship_id => l_Uc_mrshl_details_tbl(j).relationship_id,
1734: p_path_position_id => NULL
1735: );
1736: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1738: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1739: 'l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1740: END IF;

Line 1737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1733: p_relationship_id => l_Uc_mrshl_details_tbl(j).relationship_id,
1734: p_path_position_id => NULL
1735: );
1736: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1738: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1739: 'l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1740: END IF;
1741: IF(l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD = 'Y')THEN

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

1850: p_visit_id => p_visit_id,
1851: p_item_instance_id => NVL(l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID,-1),
1852: p_mode => 'TOC'
1853: );
1854: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1856: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1857: 'l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT);
1858: END IF;

Line 1855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1851: p_item_instance_id => NVL(l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID,-1),
1852: p_mode => 'TOC'
1853: );
1854: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1856: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1857: 'l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT);
1858: END IF;
1859:

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

1856: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1857: 'l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT);
1858: END IF;
1859:
1860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1862: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1863: 'l_Uc_mrshl_details_tbl(j) :: ' || i);
1864: END IF;

Line 1861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1857: 'l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_Uc_mrshl_details_tbl(j).TOTAL_WO_COUNT);
1858: END IF;
1859:
1860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1862: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1863: 'l_Uc_mrshl_details_tbl(j) :: ' || i);
1864: END IF;
1865: j := j+1;

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

1865: j := j+1;
1866: END LOOP;
1867: END IF;
1868:
1869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1871: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1872: 'Done fetching details');
1873: END IF;

Line 1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1866: END LOOP;
1867: END IF;
1868:
1869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1871: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1872: 'Done fetching details');
1873: END IF;
1874:

Line 1876: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1872: 'Done fetching details');
1873: END IF;
1874:
1875: x_Uc_mrshl_details_tbl := l_Uc_mrshl_details_tbl;
1876: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1878: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1879: 'final fetch');
1880: END IF;

Line 1877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1873: END IF;
1874:
1875: x_Uc_mrshl_details_tbl := l_Uc_mrshl_details_tbl;
1876: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1878: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1879: 'final fetch');
1880: END IF;
1881: FOR get_all_details_rec IN get_all_details(p_unit_header_id) LOOP

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

1946:
1947:
1948:
1949: BEGIN
1950: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1952: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1953: 'At the start of the procedure');
1954: END IF;

Line 1951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1947:
1948:
1949: BEGIN
1950: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1952: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1953: 'At the start of the procedure');
1954: END IF;
1955:

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

1976: l_inst_mrshl_details_tbl(j).POSITION := l_inst_mrshl_details_tbl(j).POSITION || '(' ||
1977: l_inst_mrshl_details_tbl(j).CURR_SERIAL_NUMBER || ')';
1978: END IF;
1979:
1980: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1982: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1983: 'l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1984: END IF;

Line 1981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1977: l_inst_mrshl_details_tbl(j).CURR_SERIAL_NUMBER || ')';
1978: END IF;
1979:
1980: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1982: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1983: 'l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1984: END IF;
1985: IF(l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD = 'Y')THEN

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

2067: p_visit_id => p_visit_id,
2068: p_item_instance_id => NVL(l_inst_mrshl_details_tbl(j).CURR_INSTANCE_ID,-1),
2069: p_mode => 'TOC'
2070: );
2071: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2073: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2074: 'l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT);
2075: END IF;

Line 2072: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2068: p_item_instance_id => NVL(l_inst_mrshl_details_tbl(j).CURR_INSTANCE_ID,-1),
2069: p_mode => 'TOC'
2070: );
2071: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2073: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2074: 'l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT);
2075: END IF;
2076:

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

2073: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2074: 'l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT);
2075: END IF;
2076:
2077: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2079: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2080: 'l_inst_mrshl_details_tbl(j) :: ' || j);
2081: END IF;

Line 2078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2074: 'l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT :: ' || l_inst_mrshl_details_tbl(j).TOTAL_WO_COUNT);
2075: END IF;
2076:
2077: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2079: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2080: 'l_inst_mrshl_details_tbl(j) :: ' || j);
2081: END IF;
2082: j := j+1;

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

2082: j := j+1;
2083: END LOOP;
2084: END IF;
2085:
2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2088: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2089: 'Done fetching details');
2090: END IF;

Line 2087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2083: END LOOP;
2084: END IF;
2085:
2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2088: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2089: 'Done fetching details');
2090: END IF;
2091: