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 2548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2544: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||','
2545: ||p_x_ahl_mtltxn_rec.Serial_Number||']');
2546: END IF;
2547:
2548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2549: fnd_log.string
2550: (
2551: fnd_log.level_statement,
2552: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

Line 2549: fnd_log.string

2545: ||p_x_ahl_mtltxn_rec.Serial_Number||']');
2546: END IF;
2547:
2548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2549: fnd_log.string
2550: (
2551: fnd_log.level_statement,
2552: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2553: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id

Line 2551: fnd_log.level_statement,

2547:
2548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2549: fnd_log.string
2550: (
2551: fnd_log.level_statement,
2552: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2553: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id
2554: );
2555: fnd_log.string

Line 2555: fnd_log.string

2551: fnd_log.level_statement,
2552: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2553: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id
2554: );
2555: fnd_log.string
2556: (
2557: fnd_log.level_statement,
2558: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2559: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id

Line 2557: fnd_log.level_statement,

2553: 'p_x_ahl_mtltxn_rec.Inventory_Item_Id : ' || p_x_ahl_mtltxn_rec.Inventory_Item_Id
2554: );
2555: fnd_log.string
2556: (
2557: fnd_log.level_statement,
2558: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2559: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id
2560: );
2561: fnd_log.string

Line 2561: fnd_log.string

2557: fnd_log.level_statement,
2558: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2559: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id
2560: );
2561: fnd_log.string
2562: (
2563: fnd_log.level_statement,
2564: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2565: 'p_x_ahl_mtltxn_rec.Serial_Number : ' || p_x_ahl_mtltxn_rec.Serial_Number

Line 2563: fnd_log.level_statement,

2559: 'p_x_ahl_mtltxn_rec.Wip_Entity_Id : ' || p_x_ahl_mtltxn_rec.Wip_Entity_Id
2560: );
2561: fnd_log.string
2562: (
2563: fnd_log.level_statement,
2564: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2565: 'p_x_ahl_mtltxn_rec.Serial_Number : ' || p_x_ahl_mtltxn_rec.Serial_Number
2566: );
2567: /*

Line 2568: fnd_log.string

2564: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2565: 'p_x_ahl_mtltxn_rec.Serial_Number : ' || p_x_ahl_mtltxn_rec.Serial_Number
2566: );
2567: /*
2568: fnd_log.string
2569: (
2570: fnd_log.level_statement,
2571: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2572: 'l_wip_location : ' || l_wip_location

Line 2570: fnd_log.level_statement,

2566: );
2567: /*
2568: fnd_log.string
2569: (
2570: fnd_log.level_statement,
2571: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2572: 'l_wip_location : ' || l_wip_location
2573: );*/
2574: END IF;

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

2820: END IF;
2821: CLOSE workorder_released_date_csr;
2822:
2823: -- validate disposition ID.
2824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2825: fnd_log.string
2826: (
2827: fnd_log.level_statement,
2828: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

Line 2825: fnd_log.string

2821: CLOSE workorder_released_date_csr;
2822:
2823: -- validate disposition ID.
2824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2825: fnd_log.string
2826: (
2827: fnd_log.level_statement,
2828: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2829: 'Validating disposition ID'

Line 2827: fnd_log.level_statement,

2823: -- validate disposition ID.
2824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2825: fnd_log.string
2826: (
2827: fnd_log.level_statement,
2828: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2829: 'Validating disposition ID'
2830: );
2831: END IF;

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

2851: END IF;
2852: CLOSE disposition_cur;
2853: END IF; -- -- p_x_ahl_mtltxn_rec.disposition_id
2854:
2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2856: fnd_log.string
2857: (
2858: fnd_log.level_statement,
2859: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',

Line 2856: fnd_log.string

2852: CLOSE disposition_cur;
2853: END IF; -- -- p_x_ahl_mtltxn_rec.disposition_id
2854:
2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2856: fnd_log.string
2857: (
2858: fnd_log.level_statement,
2859: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2860: 'Disposition ID:' || p_x_ahl_mtltxn_rec.disposition_id

Line 2858: fnd_log.level_statement,

2854:
2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2856: fnd_log.string
2857: (
2858: fnd_log.level_statement,
2859: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.Validate_Txn_Rec',
2860: 'Disposition ID:' || p_x_ahl_mtltxn_rec.disposition_id
2861: );
2862: END IF;

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

4020:
4021: l_net_qty := l_issue_qty - l_rtn_qty;
4022:
4023: -- JKJAIN BUG # 7587902
4024: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4025: -- fnd_log.string
4026: -- (
4027: -- fnd_log.level_statement,
4028: -- 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY',

Line 4025: -- fnd_log.string

4021: l_net_qty := l_issue_qty - l_rtn_qty;
4022:
4023: -- JKJAIN BUG # 7587902
4024: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4025: -- fnd_log.string
4026: -- (
4027: -- fnd_log.level_statement,
4028: -- 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY',
4029: -- 'l_net_qty -> ' || l_net_qty

Line 4027: -- fnd_log.level_statement,

4023: -- JKJAIN BUG # 7587902
4024: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4025: -- fnd_log.string
4026: -- (
4027: -- fnd_log.level_statement,
4028: -- 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_WORKORD_NET_QTY',
4029: -- 'l_net_qty -> ' || l_net_qty
4030: -- );
4031: -- END IF;

Line 4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4377: -- sracha: added for bug fix 6328554.
4378: l_index_start NUMBER;
4379:
4380: BEGIN
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',

Line 4382: fnd_log.string

4378: l_index_start NUMBER;
4379:
4380: BEGIN
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',
4386: 'At the start of PLSQL procedure'

Line 4384: fnd_log.level_procedure,

4380: BEGIN
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',
4386: 'At the start of PLSQL procedure'
4387: );
4388: END IF;

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

4469: END IF;
4470:
4471: l_index:=l_index+1;
4472:
4473: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4474: fnd_log.string
4475: (
4476: fnd_log.level_statement,
4477: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',

Line 4474: fnd_log.string

4470:
4471: l_index:=l_index+1;
4472:
4473: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4474: fnd_log.string
4475: (
4476: fnd_log.level_statement,
4477: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4478: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name

Line 4476: fnd_log.level_statement,

4472:
4473: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4474: fnd_log.string
4475: (
4476: fnd_log.level_statement,
4477: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4478: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name
4479: );
4480: fnd_log.string

Line 4480: fnd_log.string

4476: fnd_log.level_statement,
4477: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4478: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name
4479: );
4480: fnd_log.string
4481: (
4482: fnd_log.level_statement,
4483: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4484: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id

Line 4482: fnd_log.level_statement,

4478: 'l_disp_rec.workorder_name: ' || l_disp_rec.workorder_name
4479: );
4480: fnd_log.string
4481: (
4482: fnd_log.level_statement,
4483: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4484: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id
4485: );
4486: fnd_log.string

Line 4486: fnd_log.string

4482: fnd_log.level_statement,
4483: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4484: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id
4485: );
4486: fnd_log.string
4487: (
4488: fnd_log.level_statement,
4489: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4490: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id

Line 4488: fnd_log.level_statement,

4484: 'l_disp_rec.workorder_id: ' || l_disp_rec.workorder_id
4485: );
4486: fnd_log.string
4487: (
4488: fnd_log.level_statement,
4489: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4490: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id
4491: );
4492: fnd_log.string

Line 4492: fnd_log.string

4488: fnd_log.level_statement,
4489: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4490: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id
4491: );
4492: fnd_log.string
4493: (
4494: fnd_log.level_statement,
4495: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4496: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER

Line 4494: fnd_log.level_statement,

4490: 'l_disp_rec.disposition_id: ' || l_disp_rec.disposition_id
4491: );
4492: fnd_log.string
4493: (
4494: fnd_log.level_statement,
4495: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4496: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER
4497: );
4498: fnd_log.string

Line 4498: fnd_log.string

4494: fnd_log.level_statement,
4495: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4496: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER
4497: );
4498: fnd_log.string
4499: (
4500: fnd_log.level_statement,
4501: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4502: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number

Line 4500: fnd_log.level_statement,

4496: 'l_disp_rec.ITEM_NUMBER: ' || l_disp_rec.ITEM_NUMBER
4497: );
4498: fnd_log.string
4499: (
4500: fnd_log.level_statement,
4501: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4502: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number
4503: );
4504: fnd_log.string

Line 4504: fnd_log.string

4500: fnd_log.level_statement,
4501: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4502: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number
4503: );
4504: fnd_log.string
4505: (
4506: fnd_log.level_statement,
4507: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4508: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity

Line 4506: fnd_log.level_statement,

4502: 'l_disp_rec.serial_number: ' || l_disp_rec.serial_number
4503: );
4504: fnd_log.string
4505: (
4506: fnd_log.level_statement,
4507: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4508: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity
4509: );
4510: fnd_log.string

Line 4510: fnd_log.string

4506: fnd_log.level_statement,
4507: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4508: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity
4509: );
4510: fnd_log.string
4511: (
4512: fnd_log.level_statement,
4513: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4514: 'Net Qty: ' || l_disp_rec.Net_Quantity

Line 4512: fnd_log.level_statement,

4508: 'l_disp_rec.ISSUEQTY: ' || l_disp_rec.quantity
4509: );
4510: fnd_log.string
4511: (
4512: fnd_log.level_statement,
4513: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4514: 'Net Qty: ' || l_disp_rec.Net_Quantity
4515: );
4516: END IF; -- fnd_log.level_statement

Line 4516: END IF; -- fnd_log.level_statement

4512: fnd_log.level_statement,
4513: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn',
4514: 'Net Qty: ' || l_disp_rec.Net_Quantity
4515: );
4516: END IF; -- fnd_log.level_statement
4517:
4518: END IF;
4519:
4520: END LOOP;

Line 4522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4518: END IF;
4519:
4520: END LOOP;
4521:
4522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4523: fnd_log.string
4524: (
4525: fnd_log.level_procedure,
4526: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',

Line 4523: fnd_log.string

4519:
4520: END LOOP;
4521:
4522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4523: fnd_log.string
4524: (
4525: fnd_log.level_procedure,
4526: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',
4527: 'At the start of PLSQL procedure'

Line 4525: fnd_log.level_procedure,

4521:
4522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4523: fnd_log.string
4524: (
4525: fnd_log.level_procedure,
4526: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getDispositionReturn.begin',
4527: 'At the start of PLSQL procedure'
4528: );
4529: END IF;

Line 4814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4810: l_junk varchar2(1);
4811: l_valid_flag BOOLEAN;
4812:
4813: BEGIN
4814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4815: fnd_log.string
4816: (
4817: fnd_log.level_procedure,
4818: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.begin',

Line 4815: fnd_log.string

4811: l_valid_flag BOOLEAN;
4812:
4813: BEGIN
4814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4815: fnd_log.string
4816: (
4817: fnd_log.level_procedure,
4818: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.begin',
4819: 'At the start of PLSQL procedure'

Line 4817: fnd_log.level_procedure,

4813: BEGIN
4814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4815: fnd_log.string
4816: (
4817: fnd_log.level_procedure,
4818: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.begin',
4819: 'At the start of PLSQL procedure'
4820: );
4821: END IF;

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

4979: END IF;
4980:
4981: l_index:=l_index+1;
4982:
4983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4984: fnd_log.string
4985: (
4986: fnd_log.level_statement,
4987: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',

Line 4984: fnd_log.string

4980:
4981: l_index:=l_index+1;
4982:
4983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4984: fnd_log.string
4985: (
4986: fnd_log.level_statement,
4987: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4988: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id

Line 4986: fnd_log.level_statement,

4982:
4983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4984: fnd_log.string
4985: (
4986: fnd_log.level_statement,
4987: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4988: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id
4989: );
4990: fnd_log.string

Line 4990: fnd_log.string

4986: fnd_log.level_statement,
4987: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4988: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id
4989: );
4990: fnd_log.string
4991: (
4992: fnd_log.level_statement,
4993: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4994: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number

Line 4992: fnd_log.level_statement,

4988: 'l_mtlWoRtns_rec.workorder_id: ' || l_mtlWoRtns_rec.workorder_id
4989: );
4990: fnd_log.string
4991: (
4992: fnd_log.level_statement,
4993: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4994: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number
4995: );
4996: fnd_log.string

Line 4996: fnd_log.string

4992: fnd_log.level_statement,
4993: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
4994: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number
4995: );
4996: fnd_log.string
4997: (
4998: fnd_log.level_statement,
4999: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5000: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS

Line 4998: fnd_log.level_statement,

4994: 'l_mtlWoRtns_rec.job_number: ' || l_mtlWoRtns_rec.job_number
4995: );
4996: fnd_log.string
4997: (
4998: fnd_log.level_statement,
4999: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5000: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS
5001: );
5002: fnd_log.string

Line 5002: fnd_log.string

4998: fnd_log.level_statement,
4999: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5000: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS
5001: );
5002: fnd_log.string
5003: (
5004: fnd_log.level_statement,
5005: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5006: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number

Line 5004: fnd_log.level_statement,

5000: 'l_mtlWoRtns_rec.CONCATENATED_SEGMENTS: ' || l_mtlWoRtns_rec.CONCATENATED_SEGMENTS
5001: );
5002: fnd_log.string
5003: (
5004: fnd_log.level_statement,
5005: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5006: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number
5007: );
5008: fnd_log.string

Line 5008: fnd_log.string

5004: fnd_log.level_statement,
5005: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5006: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number
5007: );
5008: fnd_log.string
5009: (
5010: fnd_log.level_statement,
5011: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5012: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty

Line 5010: fnd_log.level_statement,

5006: 'l_mtlWoRtns_rec.serial_number: ' || l_mtlWoRtns_rec.serial_number
5007: );
5008: fnd_log.string
5009: (
5010: fnd_log.level_statement,
5011: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5012: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty
5013: );
5014: fnd_log.string

Line 5014: fnd_log.string

5010: fnd_log.level_statement,
5011: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns',
5012: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty
5013: );
5014: fnd_log.string
5015: (
5016: fnd_log.level_statement,
5017: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.l_mtlWoRtns_rec',
5018: 'l_mtlWoRtns_rec.Net_Quantity: ' || l_qty

Line 5016: fnd_log.level_statement,

5012: 'l_mtlWoRtns_rec.issWoQty: ' || l_mtlWoRtns_rec.issWoQty
5013: );
5014: fnd_log.string
5015: (
5016: fnd_log.level_statement,
5017: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.l_mtlWoRtns_rec',
5018: 'l_mtlWoRtns_rec.Net_Quantity: ' || l_qty
5019: );
5020:

Line 5029: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5025: END IF;
5026: END IF; -- l_valid_flag
5027: END LOOP;
5028:
5029: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5030: fnd_log.string
5031: (
5032: fnd_log.level_procedure,
5033: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.end',

Line 5030: fnd_log.string

5026: END IF; -- l_valid_flag
5027: END LOOP;
5028:
5029: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5030: fnd_log.string
5031: (
5032: fnd_log.level_procedure,
5033: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.end',
5034: 'At the end of PLSQL procedure'

Line 5032: fnd_log.level_procedure,

5028:
5029: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5030: fnd_log.string
5031: (
5032: fnd_log.level_procedure,
5033: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlTxnsReturns.end',
5034: 'At the end of PLSQL procedure'
5035: );
5036: END IF;

Line 5164: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5160: l_junk varchar2(1);
5161:
5162: BEGIN
5163:
5164: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5165: fnd_log.string
5166: (
5167: fnd_log.level_procedure,
5168: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.Begin',

Line 5165: fnd_log.string

5161:
5162: BEGIN
5163:
5164: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5165: fnd_log.string
5166: (
5167: fnd_log.level_procedure,
5168: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.Begin',
5169: 'At the Start of PLSQL procedure'

Line 5167: fnd_log.level_procedure,

5163:
5164: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5165: fnd_log.string
5166: (
5167: fnd_log.level_procedure,
5168: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.Begin',
5169: 'At the Start of PLSQL procedure'
5170: );
5171: END IF;

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

5214: END IF;
5215:
5216: l_index:=l_index+1;
5217:
5218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5219: fnd_log.string
5220: (
5221: fnd_log.level_statement,
5222: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',

Line 5219: fnd_log.string

5215:
5216: l_index:=l_index+1;
5217:
5218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5219: fnd_log.string
5220: (
5221: fnd_log.level_statement,
5222: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5223: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id

Line 5221: fnd_log.level_statement,

5217:
5218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5219: fnd_log.string
5220: (
5221: fnd_log.level_statement,
5222: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5223: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id
5224: );
5225: fnd_log.string

Line 5225: fnd_log.string

5221: fnd_log.level_statement,
5222: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5223: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id
5224: );
5225: fnd_log.string
5226: (
5227: fnd_log.level_statement,
5228: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5229: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number

Line 5227: fnd_log.level_statement,

5223: 'l_mtl_txn_rec.workorder_id: ' || l_mtl_txn_rec.workorder_id
5224: );
5225: fnd_log.string
5226: (
5227: fnd_log.level_statement,
5228: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5229: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number
5230: );
5231: fnd_log.string

Line 5231: fnd_log.string

5227: fnd_log.level_statement,
5228: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5229: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number
5230: );
5231: fnd_log.string
5232: (
5233: fnd_log.level_statement,
5234: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5235: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS

Line 5233: fnd_log.level_statement,

5229: 'l_mtl_txn_rec.job_number: ' || l_mtl_txn_rec.job_number
5230: );
5231: fnd_log.string
5232: (
5233: fnd_log.level_statement,
5234: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5235: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS
5236: );
5237: fnd_log.string

Line 5237: fnd_log.string

5233: fnd_log.level_statement,
5234: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5235: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS
5236: );
5237: fnd_log.string
5238: (
5239: fnd_log.level_statement,
5240: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5241: 'l_mtl_txn_rec.ISSUEQTY is zero '

Line 5239: fnd_log.level_statement,

5235: 'l_mtl_txn_rec.CONCATENATED_SEGMENTS: ' || l_mtl_txn_rec.CONCATENATED_SEGMENTS
5236: );
5237: fnd_log.string
5238: (
5239: fnd_log.level_statement,
5240: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5241: 'l_mtl_txn_rec.ISSUEQTY is zero '
5242: );
5243: fnd_log.string

Line 5243: fnd_log.string

5239: fnd_log.level_statement,
5240: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5241: 'l_mtl_txn_rec.ISSUEQTY is zero '
5242: );
5243: fnd_log.string
5244: (
5245: fnd_log.level_statement,
5246: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5247: 'l_mtl_txn_rec.Net Qty: ' || l_mtl_txn_rec.Quantity

Line 5245: fnd_log.level_statement,

5241: 'l_mtl_txn_rec.ISSUEQTY is zero '
5242: );
5243: fnd_log.string
5244: (
5245: fnd_log.level_statement,
5246: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued',
5247: 'l_mtl_txn_rec.Net Qty: ' || l_mtl_txn_rec.Quantity
5248: );
5249: END IF; -- debug messages.

Line 5256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5252: CLOSE ahl_disp_csr;
5253:
5254: END LOOP;
5255:
5256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5257: fnd_log.string
5258: (
5259: fnd_log.level_procedure,
5260: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.end',

Line 5257: fnd_log.string

5253:
5254: END LOOP;
5255:
5256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5257: fnd_log.string
5258: (
5259: fnd_log.level_procedure,
5260: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.end',
5261: 'At the end of PLSQL procedure'

Line 5259: fnd_log.level_procedure,

5255:
5256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5257: fnd_log.string
5258: (
5259: fnd_log.level_procedure,
5260: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.getMtlNotIssued.end',
5261: 'At the end of PLSQL procedure'
5262: );
5263: END IF;

Line 5287: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5283: l_api_version CONSTANT NUMBER := 1.0;
5284: l_ahl_prd_mtl_txn_tbl Ahl_Mtltxn_Tbl_Type;
5285:
5286: BEGIN
5287: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5288: fnd_log.string
5289: (
5290: fnd_log.level_procedure,
5291: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.begin',

Line 5288: fnd_log.string

5284: l_ahl_prd_mtl_txn_tbl Ahl_Mtltxn_Tbl_Type;
5285:
5286: BEGIN
5287: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5288: fnd_log.string
5289: (
5290: fnd_log.level_procedure,
5291: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.begin',
5292: 'At the start of PLSQL procedure'

Line 5290: fnd_log.level_procedure,

5286: BEGIN
5287: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5288: fnd_log.string
5289: (
5290: fnd_log.level_procedure,
5291: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.begin',
5292: 'At the start of PLSQL procedure'
5293: );
5294: END IF;

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

5291: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.begin',
5292: 'At the start of PLSQL procedure'
5293: );
5294: END IF;
5295: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5296: fnd_log.string
5297: (
5298: fnd_log.level_statement,
5299: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

Line 5296: fnd_log.string

5292: 'At the start of PLSQL procedure'
5293: );
5294: END IF;
5295: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5296: fnd_log.string
5297: (
5298: fnd_log.level_statement,
5299: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5300: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER

Line 5298: fnd_log.level_statement,

5294: END IF;
5295: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5296: fnd_log.string
5297: (
5298: fnd_log.level_statement,
5299: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5300: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER
5301: );
5302: fnd_log.string

Line 5302: fnd_log.string

5298: fnd_log.level_statement,
5299: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5300: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER
5301: );
5302: fnd_log.string
5303: (
5304: fnd_log.level_statement,
5305: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5306: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME

Line 5304: fnd_log.level_statement,

5300: 'P_prd_Mtltxn_criteria_rec.JOB_NUMBER : ' || P_prd_Mtltxn_criteria_rec.JOB_NUMBER
5301: );
5302: fnd_log.string
5303: (
5304: fnd_log.level_statement,
5305: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5306: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME
5307: );
5308: fnd_log.string

Line 5308: fnd_log.string

5304: fnd_log.level_statement,
5305: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5306: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME
5307: );
5308: fnd_log.string
5309: (
5310: fnd_log.level_statement,
5311: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5312: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY

Line 5310: fnd_log.level_statement,

5306: 'P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME : ' || P_prd_Mtltxn_criteria_rec.ORGANIZATION_NAME
5307: );
5308: fnd_log.string
5309: (
5310: fnd_log.level_statement,
5311: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5312: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY
5313: );
5314: fnd_log.string

Line 5314: fnd_log.string

5310: fnd_log.level_statement,
5311: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5312: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY
5313: );
5314: fnd_log.string
5315: (
5316: fnd_log.level_statement,
5317: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5318: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER

Line 5316: fnd_log.level_statement,

5312: 'P_prd_Mtltxn_criteria_rec.PRIORITY : ' || P_prd_Mtltxn_criteria_rec.PRIORITY
5313: );
5314: fnd_log.string
5315: (
5316: fnd_log.level_statement,
5317: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5318: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER
5319: );
5320: fnd_log.string

Line 5320: fnd_log.string

5316: fnd_log.level_statement,
5317: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5318: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER
5319: );
5320: fnd_log.string
5321: (
5322: fnd_log.level_statement,
5323: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5324: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME

Line 5322: fnd_log.level_statement,

5318: 'P_prd_Mtltxn_criteria_rec.VISIT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.VISIT_NUMBER
5319: );
5320: fnd_log.string
5321: (
5322: fnd_log.level_statement,
5323: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5324: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME
5325: );
5326: fnd_log.string

Line 5326: fnd_log.string

5322: fnd_log.level_statement,
5323: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5324: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME
5325: );
5326: fnd_log.string
5327: (
5328: fnd_log.level_statement,
5329: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5330: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS

Line 5328: fnd_log.level_statement,

5324: 'P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME : ' || P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME
5325: );
5326: fnd_log.string
5327: (
5328: fnd_log.level_statement,
5329: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5330: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS
5331: );
5332: fnd_log.string

Line 5332: fnd_log.string

5328: fnd_log.level_statement,
5329: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5330: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS
5331: );
5332: fnd_log.string
5333: (
5334: fnd_log.level_statement,
5335: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5336: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME

Line 5334: fnd_log.level_statement,

5330: 'P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS : ' || P_prd_Mtltxn_criteria_rec.CONCATENATED_SEGMENTS
5331: );
5332: fnd_log.string
5333: (
5334: fnd_log.level_statement,
5335: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5336: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME
5337: );
5338: fnd_log.string

Line 5338: fnd_log.string

5334: fnd_log.level_statement,
5335: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5336: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME
5337: );
5338: fnd_log.string
5339: (
5340: fnd_log.level_statement,
5341: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5342: 'P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER

Line 5340: fnd_log.level_statement,

5336: 'P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME : ' || P_prd_Mtltxn_criteria_rec.DISPOSITION_NAME
5337: );
5338: fnd_log.string
5339: (
5340: fnd_log.level_statement,
5341: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5342: 'P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER : ' || P_prd_Mtltxn_criteria_rec.INCIDENT_NUMBER
5343: );
5344:

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

5364: p_x_ahl_prd_mtl_txn_tbl => x_ahl_mtltxn_tbl,
5365: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5366: );
5367:
5368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5369: fnd_log.string
5370: (
5371: fnd_log.level_statement,
5372: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getMtlTxnsReturns x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

Line 5369: fnd_log.string

5365: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5366: );
5367:
5368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5369: fnd_log.string
5370: (
5371: fnd_log.level_statement,
5372: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getMtlTxnsReturns x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5373: );

Line 5371: fnd_log.level_statement,

5367:
5368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5369: fnd_log.string
5370: (
5371: fnd_log.level_statement,
5372: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getMtlTxnsReturns x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5373: );
5374: END IF;
5375:

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

5378: p_x_ahl_prd_mtl_txn_tbl => x_ahl_mtltxn_tbl,
5379: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5380: );
5381:
5382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5383: fnd_log.string
5384: (
5385: fnd_log.level_statement,
5386: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

Line 5383: fnd_log.string

5379: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5380: );
5381:
5382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5383: fnd_log.string
5384: (
5385: fnd_log.level_statement,
5386: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5387: );

Line 5385: fnd_log.level_statement,

5381:
5382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5383: fnd_log.string
5384: (
5385: fnd_log.level_statement,
5386: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5387: );
5388: END IF;
5389:

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

5393: p_x_ahl_prd_mtl_txn_tbl => x_ahl_mtltxn_tbl,
5394: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5395: );
5396:
5397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5398: fnd_log.string
5399: (
5400: fnd_log.level_statement,
5401: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

Line 5398: fnd_log.string

5394: P_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5395: );
5396:
5397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5398: fnd_log.string
5399: (
5400: fnd_log.level_statement,
5401: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5402: );

Line 5400: fnd_log.level_statement,

5396:
5397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5398: fnd_log.string
5399: (
5400: fnd_log.level_statement,
5401: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS', 'After getDispositionReturn x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5402: );
5403: END IF;
5404: END IF;

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

5413: p_x_ahl_prd_mtl_txn_tbl => x_ahl_mtltxn_tbl,
5414: p_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5415: );
5416:
5417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5418: fnd_log.string
5419: (
5420: fnd_log.level_statement,
5421: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',

Line 5418: fnd_log.string

5414: p_prd_Mtltxn_criteria_rec => p_Prd_Mtltxn_criteria_rec
5415: );
5416:
5417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5418: fnd_log.string
5419: (
5420: fnd_log.level_statement,
5421: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5422: 'After getMtlNotIssued x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count

Line 5420: fnd_log.level_statement,

5416:
5417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5418: fnd_log.string
5419: (
5420: fnd_log.level_statement,
5421: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURNS',
5422: 'After getMtlNotIssued x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5423: );
5424: END IF;

Line 5426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5422: 'After getMtlNotIssued x_ahl_mtltxn_tbl.count : ' || x_ahl_mtltxn_tbl.count
5423: );
5424: END IF;
5425:
5426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5427: fnd_log.string
5428: (
5429: fnd_log.level_procedure,
5430: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.end',

Line 5427: fnd_log.string

5423: );
5424: END IF;
5425:
5426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5427: fnd_log.string
5428: (
5429: fnd_log.level_procedure,
5430: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.end',
5431: 'At the end of PLSQL procedure'

Line 5429: fnd_log.level_procedure,

5425:
5426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5427: fnd_log.string
5428: (
5429: fnd_log.level_procedure,
5430: 'ahl.plsql.AHL_PRD_MTLTXN_PVT.GET_MTL_TRANS_RETURN.end',
5431: 'At the end of PLSQL procedure'
5432: );
5433: END IF;