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 AHL_PRD_MTLTXN_PVT

Line 1: PACKAGE BODY AHL_PRD_MTLTXN_PVT AS

1: PACKAGE BODY AHL_PRD_MTLTXN_PVT AS
2: /* $Header: AHLVMTXB.pls 120.42.12020000.3 2012/12/07 00:49:22 sareepar ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_MTLTXN_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_MTLTXN_PVT';

1: PACKAGE BODY AHL_PRD_MTLTXN_PVT AS
2: /* $Header: AHLVMTXB.pls 120.42.12020000.3 2012/12/07 00:49:22 sareepar ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
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;

Line 2939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
2941: );
2942: fnd_log.string
2943: (

Line 2945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
2947: );
2948: fnd_log.string
2949: (

Line 2951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
2953: );
2954: /*
2955: fnd_log.string

Line 2958: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
2960: );*/
2961: END IF;
2962:

Line 3053: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.validate_txn_rec',

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
3055: );
3056: END IF;
3057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOT_INV');

Line 3083: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
3085: );
3086: END IF;
3087:

Line 3142: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
3144: );
3145: END IF;
3146:

Line 3165: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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
3167: );
3168: END IF;
3169: END IF;

Line 3383: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

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'
3385: );
3386: END IF;
3387:

Line 4744: -- 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY',

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
4746: -- );
4747: -- END IF;
4748:

Line 5025: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(D.WORKORDER_ID,D.INVENTORY_ITEM_ID,V.ORGANIZATION_ID) Wo_Net_Total_Qty,

5021: --SYSDATE,
5022: D.QUANTITY, --GOES TO THE ISSUE QTY UI
5023: D.NET_QUANTITY, --GOES TO THE RETURN QTY
5024: -- JKJAIN FP ER # 6436303 - start
5025: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(D.WORKORDER_ID,D.INVENTORY_ITEM_ID,V.ORGANIZATION_ID) Wo_Net_Total_Qty,
5026: -- JKJAIN FP ER # 6436303 - end
5027: W.wip_entity_id,
5028: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5029: FROM

Line 5232: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.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'
5234: );
5235: END IF;
5236:

Line 5269: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(D.WORKORDER_ID,D.INVENTORY_ITEM_ID,V.ORGANIZATION_ID) Wo_Net_Total_Qty,

5265: L.CONCATENATED_SEGMENTS,
5266: --SYSDATE,
5267: D.QUANTITY, --GOES TO THE ISSUE QTY UI
5268: D.NET_QUANTITY, --GOES TO THE RETURN QTY
5269: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(D.WORKORDER_ID,D.INVENTORY_ITEM_ID,V.ORGANIZATION_ID) Wo_Net_Total_Qty,
5270: W.WIP_ENTITY_ID,
5271: V.INV_LOCATOR_ID,
5272: D.PATH_POSITION_ID
5273: FROM

Line 5365: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5367: );
5368: END IF;
5369:

Line 5392: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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 ||
5394: ':' || l_disp_rec.Serial_Number || ':' || l_disp_rec.lot_number || ':' || l_disp_rec.ITEM_Revision ||
5395: ':' || l_disp_rec.wip_entity_id || ':' || l_disp_rec.workorder_id || ':' || l_disp_rec.workorder_name
5396: );

Line 5451: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5453: );
5454: END IF;
5455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5462: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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 ||
5464: ':' || l_inv_serial || ':' || l_inv_lot_no || ':' || l_inv_rev ||
5465: ':' || l_wo_id || ':' || l_disp_rec.workorder_id || ':' || l_disp_rec.workorder_name ||
5466: ':' || l_cnt_disposition

Line 5487: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5489: );
5490: END IF;
5491: l_valid_flag := FALSE;

Line 5499: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5501: );
5502: END IF;
5503:

Line 5512: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5514: );
5515: END IF;
5516:

Line 5524: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5526: );
5527: END IF;
5528:

Line 5538: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5540: );
5541: END IF;
5542: END IF;

Line 5549: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5551: );
5552: END IF;
5553: OPEN csi_pending_lot_txn(l_disp_rec.wip_entity_id, l_disp_rec.INVENTORY_ITEM_ID,

Line 5567: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5569: );
5570: END IF;
5571: l_ii_quantity := l_ii_quantity - l_pend_count;

Line 5582: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5584: );
5585: END IF;
5586: OPEN csi_pending_txn(l_disp_rec.wip_entity_id, l_disp_rec.INVENTORY_ITEM_ID,

Line 5599: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5601: );
5602: END IF;
5603: l_ii_quantity := l_ii_quantity - l_pend_count;

Line 5612: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5614: );
5615: END IF;
5616: END IF;

Line 5625: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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'
5627: );
5628: END IF;
5629:

Line 5646: p_x_ahl_prd_mtl_txn_tbl(l_index).Quantity:= AHL_PRD_MTLTXN_PVT.GET_WORKORD_LEVEL_QTY(l_disp_rec.workorder_id,

5642: --p_x_ahl_prd_mtl_txn_tbl(l_index).disposition_id:=l_disp_rec.disposition_id;
5643: --p_x_ahl_prd_mtl_txn_tbl(l_index).Condition:=l_disp_rec.CONDITION_ID;
5644: --p_x_ahl_prd_mtl_txn_tbl(l_index).Condition_desc:=l_disp_rec.CONDITION_CODE;
5645: p_x_ahl_prd_mtl_txn_tbl(l_index).Serial_Number:=l_disp_rec.Serial_Number;
5646: p_x_ahl_prd_mtl_txn_tbl(l_index).Quantity:= AHL_PRD_MTLTXN_PVT.GET_WORKORD_LEVEL_QTY(l_disp_rec.workorder_id,
5647: l_disp_rec.INVENTORY_ITEM_ID, l_disp_rec.Organization_Id,
5648: l_disp_rec.lot_number, l_disp_rec.ITEM_Revision,
5649: l_disp_rec.Serial_Number); -- issue qty
5650: IF (l_cnt_disposition > l_ii_quantity) THEN

Line 5659: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5661: );
5662: END IF;
5663: ELSIF (l_cnt_disposition < l_ii_quantity) THEN

Line 5671: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5673: );
5674: END IF;
5675: END IF;

Line 5761: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5763: || ':' || l_disp_rec.workorder_name
5764: );
5765: END IF;

Line 5813: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5815: );
5816: fnd_log.string
5817: (

Line 5819: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5821: );
5822: fnd_log.string
5823: (

Line 5825: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5827: );
5828: fnd_log.string
5829: (

Line 5831: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5833: );
5834: fnd_log.string
5835: (

Line 5837: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5839: );
5840: fnd_log.string
5841: (

Line 5843: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5845: );
5846: fnd_log.string
5847: (

Line 5849: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5851: );
5852:
5853: fnd_log.string

Line 5856: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5858: );
5859: fnd_log.string
5860: (

Line 5862: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

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
5864: );
5865:
5866: END IF; -- G_LEVEL_STATEMENT

Line 5877: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.end',

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'
5879: );
5880: END IF;
5881: END getDispositionReturn;

Line 6005: AHL_PRD_MTLTXN_PVT.GET_ISSUED_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) ISSUEQTY,

6001: MTL.CONCATENATED_SEGMENTS,
6002: TXNS.INVENTORY_ITEM_ID,
6003: MTL.DESCRIPTION,
6004: TXNS.SERIAL_NUMBER ,
6005: AHL_PRD_MTLTXN_PVT.GET_ISSUED_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) ISSUEQTY,
6006: -- JKJAIN FP ER # 6436303 - start
6007: AHL_PP_MATERIALS_PVT.GET_NET_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) Net_Total_Qty,
6008: -- JKJAIN FP ER # 6436303 - end
6009: TXNS.UOM,

Line 6089: AHL_PRD_MTLTXN_PVT.GET_WORKORD_LEVEL_QTY(c_wid, c_itemid, c_ORG_ID, c_lotNumber, c_rev, c_SNO) issWoQty,

6085: B.CONCATENATED_SEGMENTS ,
6086: A.INVENTORY_ITEM_ID,
6087: B.DESCRIPTION,
6088: A.SERIAL_NUMBER ,
6089: AHL_PRD_MTLTXN_PVT.GET_WORKORD_LEVEL_QTY(c_wid, c_itemid, c_ORG_ID, c_lotNumber, c_rev, c_SNO) issWoQty,
6090: -- JKJAIN FP ER # 6436303 - start
6091: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(c_wid,c_itemid,c_ORG_ID) Wo_Net_Total_Qty,
6092: -- JKJAIN FP ER # 6436303 - end
6093: A.UOM ,

Line 6091: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(c_wid,c_itemid,c_ORG_ID) Wo_Net_Total_Qty,

6087: B.DESCRIPTION,
6088: A.SERIAL_NUMBER ,
6089: AHL_PRD_MTLTXN_PVT.GET_WORKORD_LEVEL_QTY(c_wid, c_itemid, c_ORG_ID, c_lotNumber, c_rev, c_SNO) issWoQty,
6090: -- JKJAIN FP ER # 6436303 - start
6091: AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(c_wid,c_itemid,c_ORG_ID) Wo_Net_Total_Qty,
6092: -- JKJAIN FP ER # 6436303 - end
6093: A.UOM ,
6094: UOM.unit_of_measure,
6095: WO_STS.MEANING JOB_STATUS_MEANING,

Line 6200: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.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'
6202: );
6203: END IF;
6204:

Line 6311: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6313: );
6314: END IF;
6315:

Line 6346: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6348: );
6349: END IF;
6350: ELSE

Line 6356: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6358: );
6359: END IF;
6360: END IF;

Line 6494: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6496: );
6497: fnd_log.string
6498: (

Line 6500: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6502: );
6503: fnd_log.string
6504: (

Line 6506: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6508: );
6509: fnd_log.string
6510: (

Line 6512: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6514: );
6515: fnd_log.string
6516: (

Line 6518: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

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
6520: );
6521: fnd_log.string
6522: (

Line 6524: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.l_mtlWoRtns_rec',

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
6526: );
6527:
6528: END IF; -- debug messages.

Line 6541: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.end',

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'
6543: );
6544: END IF;
6545:

Line 6719: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl.Begin',

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'
6721: );
6722: END IF;
6723:

Line 6862: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6864: );
6865: END IF;
6866:

Line 6902: p_x_ahl_prd_mtl_txn_tbl(l_index).Net_Total_Qty := AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(l_mtl_txn_rec.workorder_id,l_mtl_txn_rec.INVENTORY_ITEM_ID,l_mtl_txn_rec.Organization_Id);

6898: p_x_ahl_prd_mtl_txn_tbl(l_index).Serial_Number :=l_mtl_txn_rec.Serial_Number;
6899: p_x_ahl_prd_mtl_txn_tbl(l_index).Quantity :=0;
6900: p_x_ahl_prd_mtl_txn_tbl(l_index).Net_Quantity :=l_mtl_txn_rec.Quantity;
6901: -- JKJAIN FP ER # 6436303- start
6902: p_x_ahl_prd_mtl_txn_tbl(l_index).Net_Total_Qty := AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY(l_mtl_txn_rec.workorder_id,l_mtl_txn_rec.INVENTORY_ITEM_ID,l_mtl_txn_rec.Organization_Id);
6903: -- JKJAIN FP ER # 6436303- end
6904: p_x_ahl_prd_mtl_txn_tbl(l_index).Uom :=l_mtl_txn_rec.Uom;
6905: p_x_ahl_prd_mtl_txn_tbl(l_index).Uom_Desc :=l_mtl_txn_rec.UNIT_OF_MEASURE;
6906: p_x_ahl_prd_mtl_txn_tbl(l_index).Item_Instance_Number :=l_mtl_txn_rec.INSTANCE_NUMBER;

Line 6933: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6935: );
6936: fnd_log.string
6937: (

Line 6939: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6941: );
6942: fnd_log.string
6943: (

Line 6945: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6947: );
6948: fnd_log.string
6949: (

Line 6951: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6953: );
6954: fnd_log.string
6955: (

Line 6957: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6959: );
6960: fnd_log.string
6961: (

Line 6963: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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 '
6965: );
6966: fnd_log.string
6967: (

Line 6969: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6971: );
6972:
6973: fnd_log.string

Line 6976: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6978: );
6979:
6980: fnd_log.string

Line 6983: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl',

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
6985: );
6986: END IF; -- debug messages.
6987:

Line 6998: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getTrackedWOMtl.end',

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'
7000: );
7001: END IF;
7002:

Line 7029: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.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'
7031: );
7032: END IF;
7033: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)THEN

Line 7037: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7039: );
7040: fnd_log.string
7041: (

Line 7043: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7045: );
7046: fnd_log.string
7047: (

Line 7049: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7051: );
7052: fnd_log.string
7053: (

Line 7055: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7057: );
7058: fnd_log.string
7059: (

Line 7061: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7063: );
7064: fnd_log.string
7065: (

Line 7067: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7069: );
7070: fnd_log.string
7071: (

Line 7073: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7075: );
7076: fnd_log.string
7077: (

Line 7079: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7081: );
7082:
7083: END IF;

Line 7110: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getMtlTxnsReturns x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

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: );
7112: END IF;
7113:
7114: getDispositionReturn

Line 7124: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

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: );
7126: END IF;
7127:
7128: -- Fix for Bug # 9274691 -- start

Line 7147: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

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
7149: );
7150: END IF;
7151: -- Fix for Bug # 9274691 -- end

Line 7164: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

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: );
7166: END IF;
7167: END IF;
7168:

Line 7175: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.end',

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'
7177: );
7178: END IF;
7179:

Line 7695: END AHL_PRD_MTLTXN_PVT ;

7691: RETURN l_result;
7692: END Check_Rts_Workorder_Exists;
7693: -- pdoki added for Marshalling Enhancement, End.
7694:
7695: END AHL_PRD_MTLTXN_PVT ;