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

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_MTLTXN_PVT';
6: G_AHL_PRD_RECEPIENT VARCHAR2(30) := FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT');
7:
8: -- pdoki added for Bug 9164678
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12:
13: -- Hard coded string used in this proc

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_AHL_PRD_RECEPIENT VARCHAR2(30) := FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT');
7:
8: -- pdoki added for Bug 9164678
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12:
13: -- Hard coded string used in this proc
14: -- These are the profile names used to populate service request record default values

Line 11: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7:
8: -- pdoki added for Bug 9164678
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12:
13: -- Hard coded string used in this proc
14: -- These are the profile names used to populate service request record default values
15:

Line 1473: FND_LOG.string(G_LEVEL_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 );

1469: FETCH Get_Rts_Workorder_Dtls INTO l_rts_wo_dtls_rec;
1470: CLOSE Get_Rts_Workorder_Dtls;
1471:
1472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1473: FND_LOG.string(G_LEVEL_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 );
1474: END IF;
1475:
1476: IF ( p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id = l_rts_wo_dtls_rec.REBUILD_ITEM_ID AND l_instance_id_tbl(i) = l_rts_wo_dtls_rec.MAINTENANCE_OBJECT_ID ) THEN
1477:

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

1475:
1476: IF ( p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id = l_rts_wo_dtls_rec.REBUILD_ITEM_ID AND l_instance_id_tbl(i) = l_rts_wo_dtls_rec.MAINTENANCE_OBJECT_ID ) THEN
1477:
1478: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Return Item is same as Workorder Header Item');
1480: END IF;
1481:
1482: OPEN Check_WO_WO_Resv_Exists(l_rts_wo_dtls_rec.wip_entity_id);
1483: FETCH Check_WO_WO_Resv_Exists into l_resv_rec;

Line 1486: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Resv ID = ' || l_resv_rec.reservation_id || ' ,SupplySource = ' || l_resv_rec.SUPPLY_SOURCE_HEADER_ID || ' ,DemandSource = ' || l_resv_rec.DEMAND_SOURCE_HEADER_ID);

1482: OPEN Check_WO_WO_Resv_Exists(l_rts_wo_dtls_rec.wip_entity_id);
1483: FETCH Check_WO_WO_Resv_Exists into l_resv_rec;
1484: IF Check_WO_WO_Resv_Exists%FOUND THEN
1485: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Resv ID = ' || l_resv_rec.reservation_id || ' ,SupplySource = ' || l_resv_rec.SUPPLY_SOURCE_HEADER_ID || ' ,DemandSource = ' || l_resv_rec.DEMAND_SOURCE_HEADER_ID);
1487: END IF;
1488: l_wo_wo_resv_flag := true;
1489: END IF;
1490: Close Check_WO_WO_Resv_Exists;

Line 1495: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Return Condition is Unserviceable');

1491:
1492: IF (l_wo_wo_resv_flag = TRUE) THEN
1493: IF (p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_UNSERVICEABLE_CONDITION) THEN
1494: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Return Condition is Unserviceable');
1496: END IF;
1497: l_del_flag := true;
1498:
1499: ELSE

Line 1509: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Return SubInventory is not Reservable');

1505: AND SECONDARY_INVENTORY_NAME = p_x_ahl_mtltxn_tbl(i).Subinventory_Name;
1506:
1507: IF (l_reservable <> 1) THEN
1508: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1509: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'Return SubInventory is not Reservable');
1510: END IF;
1511: l_del_flag := true;
1512: ELSE
1513: l_del_flag := true;

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

1519:
1520: IF (l_del_flag = true) THEN
1521: mo_global.init('AHL');
1522:
1523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1524: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Delete_Reservation API...');
1525: END IF;
1526: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION
1527: (

Line 1524: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Delete_Reservation API...');

1520: IF (l_del_flag = true) THEN
1521: mo_global.init('AHL');
1522:
1523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1524: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Delete_Reservation API...');
1525: END IF;
1526: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION
1527: (
1528: p_api_version => 1.0,

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

1536: p_reservation_id => l_resv_rec.reservation_id
1537: );
1538:
1539: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1540: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'After Delete_Reservation API...ret_status['||x_return_status||']');
1541: END IF;
1542:
1543: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1544: RAISE FND_API.G_EXC_ERROR;

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

1560:
1561: l_serial_number_tbl(1).inventory_item_id := p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id ;
1562: l_serial_number_tbl(1).serial_number := p_x_ahl_mtltxn_tbl(i).Serial_Number;
1563:
1564: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1565: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Process_Reservation API...');
1566: END IF;
1567:
1568: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION

Line 1565: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Process_Reservation API...');

1561: l_serial_number_tbl(1).inventory_item_id := p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id ;
1562: l_serial_number_tbl(1).serial_number := p_x_ahl_mtltxn_tbl(i).Serial_Number;
1563:
1564: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1565: fnd_log.string(G_LEVEL_STATEMENT,l_debug,'Calling Process_Reservation API...');
1566: END IF;
1567:
1568: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION
1569: (

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

1580: x_reservation_id_tbl => l_x_serial_number_tbl
1581: );
1582:
1583: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1584: FND_LOG.string(G_LEVEL_STATEMENT, l_debug, 'After Process_Reservation API...ret_status['||x_return_status||']');
1585: END IF;
1586:
1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1588: RAISE FND_API.G_EXC_ERROR;

Line 2936: fnd_log.string

2932: ||p_x_ahl_mtltxn_rec.Serial_Number||']');
2933: END IF;
2934:
2935: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
2936: fnd_log.string
2937: (
2938: G_LEVEL_STATEMENT,
2939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2940: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id

Line 2942: fnd_log.string

2938: G_LEVEL_STATEMENT,
2939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2940: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id
2941: );
2942: fnd_log.string
2943: (
2944: G_LEVEL_STATEMENT,
2945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2946: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id

Line 2948: fnd_log.string

2944: G_LEVEL_STATEMENT,
2945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2946: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id
2947: );
2948: fnd_log.string
2949: (
2950: G_LEVEL_STATEMENT,
2951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2952: 'p_x_ahl_mtltxn_rec.Serial_Number : ' || p_x_ahl_mtltxn_rec.Serial_Number

Line 2955: fnd_log.string

2951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2952: 'p_x_ahl_mtltxn_rec.Serial_Number : ' || p_x_ahl_mtltxn_rec.Serial_Number
2953: );
2954: /*
2955: fnd_log.string
2956: (
2957: G_LEVEL_STATEMENT,
2958: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2959: 'l_wip_location : ' || l_wip_location

Line 3050: fnd_log.string

3046: OPEN mtl_serial_csr(p_x_ahl_mtltxn_rec.INVENTORY_ITEM_ID, p_x_ahl_mtltxn_rec.Serial_Number);
3047: FETCH mtl_serial_csr INTO l_junk;
3048: IF (mtl_serial_csr%NOTFOUND) THEN
3049: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3050: fnd_log.string
3051: (
3052: G_LEVEL_STATEMENT,
3053: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.validate_txn_rec',
3054: 'Serial Number resides in inventory:' || p_x_ahl_mtltxn_rec.Serial_Number

Line 3080: fnd_log.string

3076: l_pend_qty := 0;
3077: END IF;
3078:
3079: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
3080: fnd_log.string
3081: (
3082: G_LEVEL_STATEMENT,
3083: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
3084: 'Lot Pending txns quantity:' || l_pend_qty

Line 3139: fnd_log.string

3135: l_pend_qty := 0;
3136: END IF;
3137:
3138: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
3139: fnd_log.string
3140: (
3141: G_LEVEL_STATEMENT,
3142: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
3143: 'Pending txns quantity:' || l_pend_qty

Line 3162: fnd_log.string

3158: EXIT;
3159: END IF;
3160: END LOOP;
3161: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
3162: fnd_log.string
3163: (
3164: G_LEVEL_STATEMENT,
3165: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
3166: 'Updated Pending txns quantity nonserial and not lot case:' || l_pend_qty

Line 3380: fnd_log.string

3376: CLOSE workorder_released_date_csr;
3377:
3378: -- validate disposition ID.
3379: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3380: fnd_log.string
3381: (
3382: G_LEVEL_STATEMENT,
3383: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
3384: 'Validating disposition ID'

Line 4741: -- fnd_log.string

4737: l_net_qty := l_issue_qty - l_rtn_qty;
4738:
4739: -- JKJAIN BUG # 7587902
4740: -- IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
4741: -- fnd_log.string
4742: -- (
4743: -- G_LEVEL_STATEMENT,
4744: -- 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY',
4745: -- 'l_net_qty -> ' || l_net_qty

Line 5229: fnd_log.string

5225: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);
5226:
5227: BEGIN
5228: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
5229: fnd_log.string
5230: (
5231: G_LEVEL_PROCEDURE,
5232: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',
5233: 'At the start of PLSQL procedure'

Line 5362: fnd_log.string

5358: -- added order by clause as part of fix for bug# 9268076
5359: l_mtl_txn_dtls := l_mtl_txn_dtls || l_mtl_txn_dtls_where || ' ORDER BY D.WORKORDER_ID, D.INVENTORY_ITEM_ID, D.SERIAL_NUMBER, D.ITEM_REVISION, D.LOT_NUMBER ' ;
5360:
5361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5362: fnd_log.string
5363: (
5364: G_LEVEL_STATEMENT,
5365: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5366: 'SQL Query String: ' || l_mtl_txn_dtls

Line 5389: fnd_log.string

5385:
5386: l_track_flag := Is_Item_Trackable(l_disp_rec.organization_id, l_disp_rec.INVENTORY_ITEM_ID);
5387:
5388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5389: fnd_log.string
5390: (
5391: G_LEVEL_STATEMENT,
5392: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5393: 'Inv Item:DispId:Srl:Lot:Rev:WIP:WOID:WONAME:' || l_disp_rec.INVENTORY_ITEM_ID || ':' || l_disp_rec.disposition_id ||

Line 5448: fnd_log.string

5444:
5445: EXCEPTION
5446: WHEN OTHERS THEN
5447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5448: fnd_log.string
5449: (
5450: G_LEVEL_STATEMENT,
5451: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5452: 'Error query ahl_mtl_ret_dispositions_v'

Line 5459: fnd_log.string

5455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5456: END;
5457:
5458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5459: fnd_log.string
5460: (
5461: G_LEVEL_STATEMENT,
5462: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5463: 'Inv Item:DispId:Srl:Lot:Rev:WIP:WOID:WONAME:CntDISP:' || l_inv_item_id || ':' || l_disp_rec.disposition_id ||

Line 5484: fnd_log.string

5480: l_disp_rec.Serial_Number);
5481: FETCH chk_inst_relationship_csr INTO l_ii_quantity, l_reln_exists;
5482: IF (chk_inst_relationship_csr%NOTFOUND) THEN
5483: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5484: fnd_log.string
5485: (
5486: G_LEVEL_STATEMENT,
5487: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5488: 'tracked:instance not found'

Line 5496: fnd_log.string

5492: ELSIF l_reln_exists = 'X' THEN
5493: l_valid_flag := FALSE;
5494:
5495: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5496: fnd_log.string
5497: (
5498: G_LEVEL_STATEMENT,
5499: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5500: 'Found relationship: Invalid Disposition'

Line 5509: fnd_log.string

5505: CLOSE chk_inst_relationship_csr;
5506: END IF; -- valid_flag
5507:
5508: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5509: fnd_log.string
5510: (
5511: G_LEVEL_STATEMENT,
5512: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5513: 'after relationship:ii_qty:' || l_ii_quantity

Line 5521: fnd_log.string

5517: IF (l_valid_flag) THEN
5518: -- check for any pending transactions.
5519: IF (l_inv_serial IS NOT NULL) THEN
5520: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5521: fnd_log.string
5522: (
5523: G_LEVEL_STATEMENT,
5524: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5525: ' serial not null - pending'

Line 5535: fnd_log.string

5531: FETCH mtl_serial_csr INTO l_junk;
5532: IF (mtl_serial_csr%NOTFOUND) THEN
5533: l_valid_flag := FALSE;
5534: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5535: fnd_log.string
5536: (
5537: G_LEVEL_STATEMENT,
5538: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5539: 'Not valid Serial: Invalid Disposition'

Line 5546: fnd_log.string

5542: END IF;
5543: CLOSE mtl_serial_csr;
5544: ELSIF (l_inv_lot_no IS NOT NULL) THEN
5545: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5546: fnd_log.string
5547: (
5548: G_LEVEL_STATEMENT,
5549: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5550: 'lot num not null: pending'

Line 5564: fnd_log.string

5560:
5561: --IF (csi_pending_lot_txn%FOUND) THEN
5562: IF (l_pend_count > 0) THEN
5563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5564: fnd_log.string
5565: (
5566: G_LEVEL_STATEMENT,
5567: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5568: 'Found pending txns:qty:ii_qty:' || l_pend_count || ':' || l_ii_quantity

Line 5579: fnd_log.string

5575: l_valid_flag := FALSE;
5576: END IF;
5577: ELSE
5578: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5579: fnd_log.string
5580: (
5581: G_LEVEL_STATEMENT,
5582: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5583: 'else - pending'

Line 5596: fnd_log.string

5592:
5593: --IF (csi_pending_txn%FOUND) THEN
5594: IF (l_pend_count > 0) THEN
5595: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5596: fnd_log.string
5597: (
5598: G_LEVEL_STATEMENT,
5599: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5600: 'Found pending txns:qty:ii_qty:' || l_pend_count || ':' || l_ii_quantity

Line 5609: fnd_log.string

5605: CLOSE csi_pending_txn;
5606: IF (l_ii_quantity <= 0) THEN
5607: l_valid_flag := FALSE;
5608: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5609: fnd_log.string
5610: (
5611: G_LEVEL_STATEMENT,
5612: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5613: 'II Qty less or equal to 0:' || l_ii_quantity

Line 5622: fnd_log.string

5618: END IF; -- l_inv_serial
5619: END IF; -- valid_flag
5620:
5621: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5622: fnd_log.string
5623: (
5624: G_LEVEL_STATEMENT,
5625: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5626: 'after all validations'

Line 5656: fnd_log.string

5652: --reset l_valid_flag
5653: l_valid_flag := FALSE;
5654:
5655: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5656: fnd_log.string
5657: (
5658: G_LEVEL_STATEMENT,
5659: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5660: 'Disp Qty > ii Qty. Adding row with NO disposition :' || l_cnt_disposition || '>' || l_ii_quantity

Line 5668: fnd_log.string

5664: p_x_ahl_prd_mtl_txn_tbl(l_index).Net_Quantity:= l_ii_quantity - l_cnt_disposition;
5665: p_x_ahl_prd_mtl_txn_tbl(l_index).disposition_id:= -1; -- to disable disposition LOV in UI.
5666:
5667: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5668: fnd_log.string
5669: (
5670: G_LEVEL_STATEMENT,
5671: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5672: 'Disp Qty < ii Qty. Adding row with DIFF QTY :' || l_cnt_disposition || '<' || l_ii_quantity

Line 5758: fnd_log.string

5754: END IF; -- Is_Item_Trackable
5755: */
5756: IF (l_valid_flag) THEN
5757: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5758: fnd_log.string
5759: (
5760: G_LEVEL_STATEMENT,
5761: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5762: 'Adding row with disposition:InvId:WONAME:' || l_disp_rec.disposition_id || ':' || l_disp_rec.INVENTORY_ITEM_ID

Line 5810: fnd_log.string

5806:
5807: l_index:=l_index+1;
5808:
5809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
5810: fnd_log.string
5811: (
5812: G_LEVEL_STATEMENT,
5813: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5814: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name

Line 5816: fnd_log.string

5812: G_LEVEL_STATEMENT,
5813: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5814: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name
5815: );
5816: fnd_log.string
5817: (
5818: G_LEVEL_STATEMENT,
5819: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5820: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id

Line 5822: fnd_log.string

5818: G_LEVEL_STATEMENT,
5819: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5820: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id
5821: );
5822: fnd_log.string
5823: (
5824: G_LEVEL_STATEMENT,
5825: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5826: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id

Line 5828: fnd_log.string

5824: G_LEVEL_STATEMENT,
5825: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5826: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id
5827: );
5828: fnd_log.string
5829: (
5830: G_LEVEL_STATEMENT,
5831: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5832: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER

Line 5834: fnd_log.string

5830: G_LEVEL_STATEMENT,
5831: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5832: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER
5833: );
5834: fnd_log.string
5835: (
5836: G_LEVEL_STATEMENT,
5837: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5838: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number

Line 5840: fnd_log.string

5836: G_LEVEL_STATEMENT,
5837: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5838: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number
5839: );
5840: fnd_log.string
5841: (
5842: G_LEVEL_STATEMENT,
5843: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5844: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity

Line 5846: fnd_log.string

5842: G_LEVEL_STATEMENT,
5843: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5844: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity
5845: );
5846: fnd_log.string
5847: (
5848: G_LEVEL_STATEMENT,
5849: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5850: 'Net Qty: ' || l_disp_rec.Net_Quantity

Line 5853: fnd_log.string

5849: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5850: 'Net Qty: ' || l_disp_rec.Net_Quantity
5851: );
5852:
5853: fnd_log.string
5854: (
5855: G_LEVEL_STATEMENT,
5856: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5857: 'l_disp_rec.Instance Id: ' || l_disp_rec.instance_id

Line 5859: fnd_log.string

5855: G_LEVEL_STATEMENT,
5856: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5857: 'l_disp_rec.Instance Id: ' || l_disp_rec.instance_id
5858: );
5859: fnd_log.string
5860: (
5861: G_LEVEL_STATEMENT,
5862: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
5863: 'l_disp_rec.Instance Number: ' || l_instance_number

Line 5874: fnd_log.string

5870: END LOOP;
5871: CLOSE l_mtl_txns_returns_cur;
5872:
5873: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
5874: fnd_log.string
5875: (
5876: G_LEVEL_PROCEDURE,
5877: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.end',
5878: 'At the start of PLSQL procedure'

Line 6197: fnd_log.string

6193: l_mtlTxn_rec l_mtlTxn_rec_type;
6194:
6195: BEGIN
6196: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
6197: fnd_log.string
6198: (
6199: G_LEVEL_PROCEDURE,
6200: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.begin',
6201: 'At the start of PLSQL procedure'

Line 6308: fnd_log.string

6304:
6305: l_mtl_txn_dtls := l_mtl_txn_dtls || l_mtl_txn_dtls_where ;
6306:
6307: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6308: fnd_log.string
6309: (
6310: G_LEVEL_STATEMENT,
6311: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6312: 'SQL Query String: ' || l_mtl_txn_dtls

Line 6343: fnd_log.string

6339: IF CHECK_DISPITEM_CUR%FOUND THEN
6340: l_opseq_flag :='T';
6341:
6342: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6343: fnd_log.string
6344: (
6345: G_LEVEL_STATEMENT,
6346: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6347: 'l_opseq_flag: ' || l_opseq_flag

Line 6353: fnd_log.string

6349: END IF;
6350: ELSE
6351: l_opseq_flag :='F';
6352: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6353: fnd_log.string
6354: (
6355: G_LEVEL_STATEMENT,
6356: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6357: 'l_opseq_flag: ' || l_opseq_flag

Line 6491: fnd_log.string

6487:
6488: END IF; -- l_qty > 0
6489:
6490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6491: fnd_log.string
6492: (
6493: G_LEVEL_STATEMENT,
6494: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6495: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id

Line 6497: fnd_log.string

6493: G_LEVEL_STATEMENT,
6494: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6495: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id
6496: );
6497: fnd_log.string
6498: (
6499: G_LEVEL_STATEMENT,
6500: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6501: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number

Line 6503: fnd_log.string

6499: G_LEVEL_STATEMENT,
6500: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6501: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number
6502: );
6503: fnd_log.string
6504: (
6505: G_LEVEL_STATEMENT,
6506: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6507: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS

Line 6509: fnd_log.string

6505: G_LEVEL_STATEMENT,
6506: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6507: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS
6508: );
6509: fnd_log.string
6510: (
6511: G_LEVEL_STATEMENT,
6512: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6513: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number

Line 6515: fnd_log.string

6511: G_LEVEL_STATEMENT,
6512: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6513: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number
6514: );
6515: fnd_log.string
6516: (
6517: G_LEVEL_STATEMENT,
6518: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6519: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty

Line 6521: fnd_log.string

6517: G_LEVEL_STATEMENT,
6518: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
6519: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty
6520: );
6521: fnd_log.string
6522: (
6523: G_LEVEL_STATEMENT,
6524: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.l_mtlWoRtns_rec',
6525: 'l_mtlWoRtns_rec.Net_Quantity: ' || l_qty

Line 6538: fnd_log.string

6534: CLOSE l_mtl_txns_returns_cur;
6535:
6536:
6537: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
6538: fnd_log.string
6539: (
6540: G_LEVEL_PROCEDURE,
6541: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.end',
6542: 'At the end of PLSQL procedure'

Line 6716: fnd_log.string

6712:
6713: BEGIN
6714:
6715: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
6716: fnd_log.string
6717: (
6718: G_LEVEL_PROCEDURE,
6719: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl.Begin',
6720: 'At the Start of PLSQL procedure'

Line 6859: fnd_log.string

6855:
6856: l_mtl_txn_dtls := l_mtl_txn_dtls || l_mtl_txn_dtls_where ;
6857:
6858: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6859: fnd_log.string
6860: (
6861: G_LEVEL_STATEMENT,
6862: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6863: 'SQL Query String: ' || l_mtl_txn_dtls

Line 6930: fnd_log.string

6926:
6927: l_index:=l_index+1;
6928:
6929: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
6930: fnd_log.string
6931: (
6932: G_LEVEL_STATEMENT,
6933: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6934: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id

Line 6936: fnd_log.string

6932: G_LEVEL_STATEMENT,
6933: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6934: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id
6935: );
6936: fnd_log.string
6937: (
6938: G_LEVEL_STATEMENT,
6939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6940: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number

Line 6942: fnd_log.string

6938: G_LEVEL_STATEMENT,
6939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6940: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number
6941: );
6942: fnd_log.string
6943: (
6944: G_LEVEL_STATEMENT,
6945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6946: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS

Line 6948: fnd_log.string

6944: G_LEVEL_STATEMENT,
6945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6946: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS
6947: );
6948: fnd_log.string
6949: (
6950: G_LEVEL_STATEMENT,
6951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6952: 'l_mtl_txn_rec.JOB_STATUS_MEANING: ' || l_mtl_txn_rec.JOB_STATUS_MEANING

Line 6954: fnd_log.string

6950: G_LEVEL_STATEMENT,
6951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6952: 'l_mtl_txn_rec.JOB_STATUS_MEANING: ' || l_mtl_txn_rec.JOB_STATUS_MEANING
6953: );
6954: fnd_log.string
6955: (
6956: G_LEVEL_STATEMENT,
6957: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6958: 'l_mtl_txn_rec.INSTANCE_NUMBER: ' || l_mtl_txn_rec.INSTANCE_NUMBER

Line 6960: fnd_log.string

6956: G_LEVEL_STATEMENT,
6957: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6958: 'l_mtl_txn_rec.INSTANCE_NUMBER: ' || l_mtl_txn_rec.INSTANCE_NUMBER
6959: );
6960: fnd_log.string
6961: (
6962: G_LEVEL_STATEMENT,
6963: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6964: 'l_mtl_txn_rec.ISSUEQTY is zero '

Line 6966: fnd_log.string

6962: G_LEVEL_STATEMENT,
6963: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6964: 'l_mtl_txn_rec.ISSUEQTY is zero '
6965: );
6966: fnd_log.string
6967: (
6968: G_LEVEL_STATEMENT,
6969: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6970: 'l_mtl_txn_rec.Net Qty: ' || l_mtl_txn_rec.Quantity

Line 6973: fnd_log.string

6969: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6970: 'l_mtl_txn_rec.Net Qty: ' || l_mtl_txn_rec.Quantity
6971: );
6972:
6973: fnd_log.string
6974: (
6975: G_LEVEL_STATEMENT,
6976: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6977: 'l_mtl_txn_rec.Instance Id: ' || l_mtl_txn_rec.instance_id

Line 6980: fnd_log.string

6976: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6977: 'l_mtl_txn_rec.Instance Id: ' || l_mtl_txn_rec.instance_id
6978: );
6979:
6980: fnd_log.string
6981: (
6982: G_LEVEL_STATEMENT,
6983: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',
6984: 'l_mtl_txn_rec.Instance Number: ' || l_mtl_txn_rec.instance_number

Line 6995: fnd_log.string

6991: END LOOP;
6992: CLOSE l_mtl_txns_returns_cur;
6993:
6994: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
6995: fnd_log.string
6996: (
6997: G_LEVEL_PROCEDURE,
6998: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl.end',
6999: 'At the end of PLSQL procedure'

Line 7026: fnd_log.string

7022: l_ahl_prd_mtl_txn_tbl Ahl_Mtltxn_Tbl_Type;
7023:
7024: BEGIN
7025: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
7026: fnd_log.string
7027: (
7028: G_LEVEL_PROCEDURE,
7029: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.begin',
7030: 'At the start of PLSQL procedure'

Line 7034: fnd_log.string

7030: 'At the start of PLSQL procedure'
7031: );
7032: END IF;
7033: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
7034: fnd_log.string
7035: (
7036: G_LEVEL_STATEMENT,
7037: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7038: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER

Line 7040: fnd_log.string

7036: G_LEVEL_STATEMENT,
7037: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7038: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER
7039: );
7040: fnd_log.string
7041: (
7042: G_LEVEL_STATEMENT,
7043: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7044: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME

Line 7046: fnd_log.string

7042: G_LEVEL_STATEMENT,
7043: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7044: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME
7045: );
7046: fnd_log.string
7047: (
7048: G_LEVEL_STATEMENT,
7049: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7050: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY

Line 7052: fnd_log.string

7048: G_LEVEL_STATEMENT,
7049: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7050: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY
7051: );
7052: fnd_log.string
7053: (
7054: G_LEVEL_STATEMENT,
7055: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7056: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER

Line 7058: fnd_log.string

7054: G_LEVEL_STATEMENT,
7055: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7056: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER
7057: );
7058: fnd_log.string
7059: (
7060: G_LEVEL_STATEMENT,
7061: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7062: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME

Line 7064: fnd_log.string

7060: G_LEVEL_STATEMENT,
7061: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7062: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME
7063: );
7064: fnd_log.string
7065: (
7066: G_LEVEL_STATEMENT,
7067: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7068: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS

Line 7070: fnd_log.string

7066: G_LEVEL_STATEMENT,
7067: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7068: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS
7069: );
7070: fnd_log.string
7071: (
7072: G_LEVEL_STATEMENT,
7073: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7074: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME

Line 7076: fnd_log.string

7072: G_LEVEL_STATEMENT,
7073: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7074: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME
7075: );
7076: fnd_log.string
7077: (
7078: G_LEVEL_STATEMENT,
7079: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7080: 'P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER

Line 7107: fnd_log.string

7103: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
7104: );
7105:
7106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
7107: fnd_log.string
7108: (
7109: G_LEVEL_STATEMENT,
7110: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getMtlTxnsReturns x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
7111: );

Line 7121: fnd_log.string

7117: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
7118: );
7119:
7120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
7121: fnd_log.string
7122: (
7123: G_LEVEL_STATEMENT,
7124: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
7125: );

Line 7144: fnd_log.string

7140: p_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
7141: );
7142:
7143: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
7144: fnd_log.string
7145: (
7146: G_LEVEL_STATEMENT,
7147: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
7148: 'After getTrackedWOMtl:x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

Line 7161: fnd_log.string

7157: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
7158: );
7159:
7160: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN
7161: fnd_log.string
7162: (
7163: G_LEVEL_STATEMENT,
7164: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
7165: );

Line 7172: fnd_log.string

7168:
7169:
7170:
7171: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
7172: fnd_log.string
7173: (
7174: G_LEVEL_PROCEDURE,
7175: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.end',
7176: 'At the end of PLSQL procedure'