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_DEBUG_PUB

Line 4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;

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

Line 300: AHL_DEBUG_PUB.debug('Convert_Name_To_Id');

296: -- order id and Operation seq number
297: -- ?????????
298:
299: IF G_DEBUG='Y' THEN
300: AHL_DEBUG_PUB.debug('Convert_Name_To_Id');
301: END IF;
302:
303: IF ( (p_x_ahl_mtltxn_rec.Workorder_Id IS NULL
304: OR p_x_ahl_mtltxn_rec.Workorder_Id = FND_API.G_MISS_NUM)) THEN

Line 388: AHL_DEBUG_PUB.debug('Getting WipEntity for['||p_x_ahl_mtltxn_rec.Workorder_Id||']');

384:
385: IF (p_x_ahl_mtltxn_rec.Wip_Entity_Id IS NULL
386: OR p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
387: IF G_DEBUG='Y' THEN
388: AHL_DEBUG_PUB.debug('Getting WipEntity for['||p_x_ahl_mtltxn_rec.Workorder_Id||']');
389: END IF;
390: OPEN WIP_JOB_ID_CUR(p_x_ahl_mtltxn_rec.Workorder_Id);
391: FETCH WIP_JOB_ID_CUR INTO p_x_ahl_mtltxn_rec.Wip_Entity_Id,p_x_ahl_mtltxn_rec.Organization_Id ;
392: IF(WIP_JOB_ID_CUR%NOTFOUND) THEN

Line 404: AHL_DEBUG_PUB.debug('after the Wip entity select['||p_x_ahl_mtltxn_rec.Wip_Entity_Id||','||p_x_ahl_mtltxn_rec.Organization_Id||']');

400:
401:
402:
403: IF G_DEBUG='Y' THEN
404: AHL_DEBUG_PUB.debug('after the Wip entity select['||p_x_ahl_mtltxn_rec.Wip_Entity_Id||','||p_x_ahl_mtltxn_rec.Organization_Id||']');
405:
406: END IF;
407:
408:

Line 412: AHL_DEBUG_PUB.debug('selecting woopid for['||p_x_ahl_mtltxn_rec.Workorder_Id||','||p_x_ahl_mtltxn_rec.Operation_Seq_num||']');

408:
409: IF (p_x_ahl_mtltxn_rec.Workorder_Operation_Id IS NULL
410: OR p_x_ahl_mtltxn_rec.Workorder_Operation_Id = FND_API.G_MISS_NUM) THEN
411: IF G_DEBUG='Y' THEN
412: AHL_DEBUG_PUB.debug('selecting woopid for['||p_x_ahl_mtltxn_rec.Workorder_Id||','||p_x_ahl_mtltxn_rec.Operation_Seq_num||']');
413:
414: END IF;
415: OPEN WO_OP_CUR(p_x_ahl_mtltxn_rec.Workorder_Id,
416: p_x_ahl_mtltxn_rec.Operation_Seq_num);

Line 428: AHL_DEBUG_PUB.debug('after the woop id select');

424: END IF;
425: CLOSE WO_OP_CUR;
426: END IF;
427: IF G_DEBUG='Y' THEN
428: AHL_DEBUG_PUB.debug('after the woop id select');
429: END IF;
430:
431: --Convert Transaction Type Name into Transaction Type Id
432: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id IS NULL

Line 435: AHL_DEBUG_PUB.debug('Converting Txn type name['||p_x_ahl_mtltxn_rec.Transaction_Type_Name||']');

431: --Convert Transaction Type Name into Transaction Type Id
432: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id IS NULL
433: OR p_x_ahl_mtltxn_rec.Transaction_Type_Id = FND_API.G_MISS_NUM) THEN
434: IF G_DEBUG='Y' THEN
435: AHL_DEBUG_PUB.debug('Converting Txn type name['||p_x_ahl_mtltxn_rec.Transaction_Type_Name||']');
436: END IF;
437: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Name IS NULL
438: OR p_x_ahl_mtltxn_rec.Transaction_Type_Name = FND_API.G_MISS_CHAR) THEN
439: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_TXN_TYPE');

Line 455: AHL_DEBUG_PUB.debug('after the txn type select');

451: CLOSE Transaction_Type_Cur;
452: END IF;
453: END IF;
454: IF G_DEBUG='Y' THEN
455: AHL_DEBUG_PUB.debug('after the txn type select');
456: END IF;
457:
458: -- Convert item segments into item id
459: IF (p_x_ahl_mtltxn_rec.Inventory_Item_Id IS NULL OR p_x_ahl_mtltxn_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) THEN

Line 461: AHL_DEBUG_PUB.debug('Converting item for['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Inventory_Item_Segments||']');

457:
458: -- Convert item segments into item id
459: IF (p_x_ahl_mtltxn_rec.Inventory_Item_Id IS NULL OR p_x_ahl_mtltxn_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) THEN
460: IF G_DEBUG='Y' THEN
461: AHL_DEBUG_PUB.debug('Converting item for['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Inventory_Item_Segments||']');
462: END IF;
463:
464: IF (p_x_ahl_mtltxn_rec.Inventory_Item_Segments IS NULL
465: OR p_x_ahl_mtltxn_rec.Inventory_Item_Segments = FND_API.G_MISS_CHAR) THEN

Line 485: AHL_DEBUG_PUB.debug('after the item id select:'||to_char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||'.');

481:
482: END IF;
483: IF G_DEBUG='Y'
484: THEN
485: AHL_DEBUG_PUB.debug('after the item id select:'||to_char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||'.');
486: END IF;
487:
488: -- Convert Locator segments into locator id when item is locator controlled.
489: IF (p_x_ahl_mtltxn_rec.Locator_Id IS NULL

Line 494: AHL_DEBUG_PUB.debug('Converting locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');

490: OR p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
491: IF (p_x_ahl_mtltxn_rec.Locator_Segments IS NOT NULL
492: AND p_x_ahl_mtltxn_rec.Locator_Segments <> FND_API.G_MISS_CHAR) THEN
493: IF G_DEBUG='Y' THEN
494: AHL_DEBUG_PUB.debug('Converting locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');
495: END IF;
496: OPEN Location_Cur(p_x_ahl_mtltxn_rec.Organization_Id,
497: p_x_ahl_mtltxn_rec.Locator_Segments);
498: FETCH Location_Cur INTO p_x_ahl_mtltxn_rec.Locator_Id,l_locator_segments ;--Fix for bug number 5903275

Line 512: AHL_DEBUG_PUB.debug('Converted locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');

508: */
509: IF (Location_Cur%FOUND) THEN
510: p_x_ahl_mtltxn_rec.Locator_Segments := l_locator_segments;--Fix for bug number 5903275
511: IF G_DEBUG='Y' THEN
512: AHL_DEBUG_PUB.debug('Converted locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');
513: END IF;
514: END IF;
515: CLOSE Location_Cur;
516: END IF;

Line 520: AHL_DEBUG_PUB.debug('after the locator select');

516: END IF;
517:
518: END IF;
519: IF G_DEBUG='Y' THEN
520: AHL_DEBUG_PUB.debug('after the locator select');
521: END IF;
522:
523: -- convert reason name into reason id.
524: IF (p_x_ahl_mtltxn_rec.Reason_Id IS NULL OR p_x_ahl_mtltxn_rec.Reason_Id = FND_API.G_MISS_NUM)

Line 530: AHL_DEBUG_PUB.debug('Converting reason name'||p_x_ahl_mtltxn_rec.Reason_Name||']');

526: IF (p_x_ahl_mtltxn_rec.Reason_Name IS NOT NULL
527: AND p_x_ahl_mtltxn_rec.Reason_Name <> FND_API.G_MISS_CHAR)
528: THEN
529: IF G_DEBUG='Y' THEN
530: AHL_DEBUG_PUB.debug('Converting reason name'||p_x_ahl_mtltxn_rec.Reason_Name||']');
531: END IF;
532: OPEN Reason_Cur(p_x_ahl_mtltxn_rec.Reason_Name);
533: FETCH Reason_Cur INTO p_x_ahl_mtltxn_rec.Reason_Id ;
534: IF(Reason_Cur%NOTFOUND) THEN

Line 546: AHL_DEBUG_PUB.debug('after the reason name select');

542:
543: END IF;
544:
545: IF G_DEBUG='Y' THEN
546: AHL_DEBUG_PUB.debug('after the reason name select');
547: END IF;
548:
549:
550: --Convert Problem_code_Meaning to Problem_code incase of returns

Line 558: AHL_DEBUG_PUB.debug('Converting Problem code['||p_x_ahl_mtltxn_rec.Problem_Code_Meaning||']');

554: OR p_x_ahl_mtltxn_rec.Problem_Code = FND_API.G_MISS_CHAR) THEN
555: IF (p_x_ahl_mtltxn_rec.Problem_Code_Meaning IS NOT NULL
556: AND p_x_ahl_mtltxn_rec.Problem_Code_Meaning <> FND_API.G_MISS_CHAR) THEN
557: IF G_DEBUG='Y' THEN
558: AHL_DEBUG_PUB.debug('Converting Problem code['||p_x_ahl_mtltxn_rec.Problem_Code_Meaning||']');
559:
560: END IF;
561: OPEN Fnd_Lookups_Cur(p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
562: FETCH Fnd_Lookups_Cur INTO p_x_ahl_mtltxn_rec.Problem_Code ;

Line 573: AHL_DEBUG_PUB.debug('after problem code select');

569: CLOSE Fnd_Lookups_Cur;
570: END IF;
571: END IF;
572: IF G_DEBUG='Y' THEN
573: AHL_DEBUG_PUB.debug('after problem code select');
574: END IF;
575: IF (p_x_ahl_mtltxn_rec.Condition_Desc IS NOT NULL
576: AND p_x_ahl_mtltxn_rec.Condition_Desc <> FND_API.G_MISS_CHAR)
577: THEN

Line 579: AHL_DEBUG_PUB.debug('Getting Condition for['||p_x_ahl_mtltxn_rec.Condition_Desc||']');

575: IF (p_x_ahl_mtltxn_rec.Condition_Desc IS NOT NULL
576: AND p_x_ahl_mtltxn_rec.Condition_Desc <> FND_API.G_MISS_CHAR)
577: THEN
578: IF G_DEBUG='Y' THEN
579: AHL_DEBUG_PUB.debug('Getting Condition for['||p_x_ahl_mtltxn_rec.Condition_Desc||']');
580: END IF;
581: OPEN CONDITION_CUR(p_x_ahl_mtltxn_rec.Condition_Desc);
582: FETCH CONDITION_CUR INTO p_x_ahl_mtltxn_rec.Condition;
583:

Line 596: AHL_DEBUG_PUB.debug('after the CONDITION select['||p_x_ahl_mtltxn_rec.CONDITION||']');

592: END IF;
593:
594:
595: IF G_DEBUG='Y' THEN
596: AHL_DEBUG_PUB.debug('after the CONDITION select['||p_x_ahl_mtltxn_rec.CONDITION||']');
597: END IF;
598:
599: END IF;
600:

Line 703: AHL_DEBUG_PUB.debug('Converting UOM['||p_x_ahl_mtltxn_rec.Uom_Desc||']');

699: --Convert UOM DESC into UOM
700: IF (p_x_ahl_mtltxn_rec.Uom IS NULL
701: OR p_x_ahl_mtltxn_rec.Uom = FND_API.G_MISS_CHAR) THEN
702: IF G_DEBUG='Y' THEN
703: AHL_DEBUG_PUB.debug('Converting UOM['||p_x_ahl_mtltxn_rec.Uom_Desc||']');
704:
705: END IF;
706: IF (p_x_ahl_mtltxn_rec.Uom_Desc IS NULL
707: OR p_x_ahl_mtltxn_rec.Uom_Desc = FND_API.G_MISS_CHAR) THEN

Line 725: AHL_DEBUG_PUB.debug('after UOM select');

721: END IF;
722:
723: END IF;
724: IF G_DEBUG='Y' THEN
725: AHL_DEBUG_PUB.debug('after UOM select');
726:
727: END IF;
728: EXCEPTION
729: WHEN FND_API.G_EXC_ERROR THEN

Line 968: AHL_DEBUG_PUB.enable_debug;

964: dumpInput(p_x_ahl_mtltxn_tbl);
965:
966:
967: IF G_DEBUG='Y' THEN
968: AHL_DEBUG_PUB.enable_debug;
969: AHL_DEBUG_PUB.debug('Entered ahl mtl api');
970: END IF;
971:
972: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN

Line 969: AHL_DEBUG_PUB.debug('Entered ahl mtl api');

965:
966:
967: IF G_DEBUG='Y' THEN
968: AHL_DEBUG_PUB.enable_debug;
969: AHL_DEBUG_PUB.debug('Entered ahl mtl api');
970: END IF;
971:
972: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
973:

Line 1008: AHL_DEBUG_PUB.debug('calling Convert_Name_To_Id for i=['||i||']');

1004: l_error := true;
1005: ELSE
1006: */
1007: IF G_DEBUG='Y' THEN
1008: AHL_DEBUG_PUB.debug('calling Convert_Name_To_Id for i=['||i||']');
1009: END IF;
1010:
1011: -- This procedure will convert name parameters into IDs in the input
1012: Convert_Name_To_Id(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),

Line 1028: AHL_DEBUG_PUB.debug('calling Validate_Txn_rec for i=['||i||']');

1024: END IF;
1025:
1026:
1027: IF G_DEBUG='Y' THEN
1028: AHL_DEBUG_PUB.debug('calling Validate_Txn_rec for i=['||i||']');
1029: END IF;
1030:
1031: --Call Validate_Txn(Ahl_Mtltxn_rec) to validate the material txn record.
1032: Validate_Txn_rec(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),

Line 1040: AHL_DEBUG_PUB.debug('After calling Validate_Txn_rec');

1036: x_msg_count => x_msg_Count,
1037: x_eam_item_type_id => l_eam_item_type_id );
1038:
1039: IF G_DEBUG='Y' THEN
1040: AHL_DEBUG_PUB.debug('After calling Validate_Txn_rec');
1041: END IF;
1042:
1043: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1044: l_error := true;

Line 1047: AHL_DEBUG_PUB.debug('Error in Validation');

1043: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1044: l_error := true;
1045:
1046: IF G_DEBUG='Y' THEN
1047: AHL_DEBUG_PUB.debug('Error in Validation');
1048: END IF;
1049: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051:

Line 1053: AHL_DEBUG_PUB.debug('Unexpected error in Validate_Txn_rec');

1049: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051:
1052: IF G_DEBUG='Y' THEN
1053: AHL_DEBUG_PUB.debug('Unexpected error in Validate_Txn_rec');
1054: END IF;
1055: ELSE
1056: l_instance_id_tbl(i) := l_item_instance_id;
1057: l_eam_item_type_id_tbl(i) := l_eam_item_type_id;

Line 1112: AHL_DEBUG_PUB.debug('after Sch_Mtl insert api');

1108: x_ahl_sch_mtl_id => l_sch_Mtl_Id);
1109:
1110:
1111: IF G_DEBUG='Y' THEN
1112: AHL_DEBUG_PUB.debug('after Sch_Mtl insert api');
1113: END IF;
1114:
1115: IF (x_return_status = FND_API.G_RET_STS_ERROR
1116: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1132: AHL_DEBUG_PUB.debug('Calling Insert_Txn_Intf...');

1128: --call Insert_Interface_Temp API to insert data into transaction
1129: --temp tables. F
1130:
1131: IF G_DEBUG='Y' THEN
1132: AHL_DEBUG_PUB.debug('Calling Insert_Txn_Intf...');
1133: END IF;
1134:
1135: -- Added l_eam_item_type_id_tbl(i) for FP ER# 6310766.
1136: Insert_Mtl_Txn_Intf(p_x_ahl_mtl_txn_rec => p_x_ahl_mtltxn_tbl(i),

Line 1146: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');

1142: );
1143:
1144: l_txn_Id_Tbl(i) := l_Txn_tmp_Id;
1145: IF G_DEBUG='Y' THEN
1146: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');
1147: AHL_DEBUG_PUB.debug('Ahl_mtltxn_id'||p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id);
1148: END IF;
1149:
1150:

Line 1147: AHL_DEBUG_PUB.debug('Ahl_mtltxn_id'||p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id);

1143:
1144: l_txn_Id_Tbl(i) := l_Txn_tmp_Id;
1145: IF G_DEBUG='Y' THEN
1146: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');
1147: AHL_DEBUG_PUB.debug('Ahl_mtltxn_id'||p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id);
1148: END IF;
1149:
1150:
1151: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1165: AHL_DEBUG_PUB.debug('Before calling wip_mtlInterfaceProc_pub.processInterface....');

1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: -- Now process the interface records
1164: IF G_DEBUG='Y' THEN
1165: AHL_DEBUG_PUB.debug('Before calling wip_mtlInterfaceProc_pub.processInterface....');
1166: END IF;
1167:
1168: wip_mtlInterfaceProc_pub.processInterface(
1169: p_txnHdrId => l_Txn_Header_Id,

Line 1181: -- AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');

1177: -- modified to print return status (bug# 13689288)
1178: --IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR FND_API.G_RET_STS_ERROR ) THEN
1179: --IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1180: IF G_DEBUG='Y' THEN
1181: -- AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1182: -- AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1183: AHL_DEBUG_PUB.debug('After call to wip_mtlInterfaceProc_pub.processInterface...x_return_status[' || x_return_status ||']');
1184: AHL_DEBUG_PUB.debug('count of msgs: ' || FND_MSG_PUB.COUNT_MSG);
1185: END IF;

Line 1182: -- AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);

1178: --IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR FND_API.G_RET_STS_ERROR ) THEN
1179: --IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1180: IF G_DEBUG='Y' THEN
1181: -- AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1182: -- AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1183: AHL_DEBUG_PUB.debug('After call to wip_mtlInterfaceProc_pub.processInterface...x_return_status[' || x_return_status ||']');
1184: AHL_DEBUG_PUB.debug('count of msgs: ' || FND_MSG_PUB.COUNT_MSG);
1185: END IF;
1186: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1183: AHL_DEBUG_PUB.debug('After call to wip_mtlInterfaceProc_pub.processInterface...x_return_status[' || x_return_status ||']');

1179: --IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1180: IF G_DEBUG='Y' THEN
1181: -- AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1182: -- AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1183: AHL_DEBUG_PUB.debug('After call to wip_mtlInterfaceProc_pub.processInterface...x_return_status[' || x_return_status ||']');
1184: AHL_DEBUG_PUB.debug('count of msgs: ' || FND_MSG_PUB.COUNT_MSG);
1185: END IF;
1186: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: --END IF;

Line 1184: AHL_DEBUG_PUB.debug('count of msgs: ' || FND_MSG_PUB.COUNT_MSG);

1180: IF G_DEBUG='Y' THEN
1181: -- AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1182: -- AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1183: AHL_DEBUG_PUB.debug('After call to wip_mtlInterfaceProc_pub.processInterface...x_return_status[' || x_return_status ||']');
1184: AHL_DEBUG_PUB.debug('count of msgs: ' || FND_MSG_PUB.COUNT_MSG);
1185: END IF;
1186: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: --END IF;
1188:

Line 1209: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');

1205: IF(m_Txn_Error_cur%FOUND AND (l_error_code IS NOT NULL
1206: OR trim(l_error_code) = '')) THEN
1207:
1208: IF G_DEBUG='Y' THEN
1209: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1210: END IF;
1211:
1212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1213: FND_MESSAGE.Set_Token('MSG',l_error_msg);

Line 1231: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');

1227: IF(Txn_Error_cur%FOUND AND (l_error_code IS NOT NULL
1228: OR trim(l_error_code) = '')) THEN
1229:
1230: IF G_DEBUG='Y' THEN
1231: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1232: END IF;
1233:
1234: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1235: FND_MESSAGE.Set_Token('MSG',l_error_msg);

Line 1248: AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');

1244:
1245:
1246: --IF(l_error ) THEN
1247: IF(l_error) OR (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1248: AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1249: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:

Line 1249: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);

1245:
1246: --IF(l_error ) THEN
1247: IF(l_error) OR (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1248: AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1249: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:
1253: -- No errors returned by WIP API.Initialize message list to

Line 1310: AHL_DEBUG_PUB.debug('l_completed_quantity=['||l_completed_quantity||']');

1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSE
1308:
1309: IF G_DEBUG='Y' THEN
1310: AHL_DEBUG_PUB.debug('l_completed_quantity=['||l_completed_quantity||']');
1311: END IF;
1312:
1313: -- Tamal: Bug #4095376: Begin
1314: -- Retrieving quantity, then converting to primary uom, etc have been moved out of this ELSE loop

Line 1361: AHL_DEBUG_PUB.DEBUG('Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );

1357: IF (p_x_ahl_mtltxn_tbl(i).locator_segments IS NOT NULL AND
1358: p_x_ahl_mtltxn_tbl(i).locator_id IS NULL) THEN
1359:
1360: IF G_DEBUG='Y' THEN
1361: AHL_DEBUG_PUB.DEBUG('Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
1362: END IF;
1363:
1364: l_valid_flag := fnd_flex_keyval.validate_segs(
1365: operation => 'FIND_COMBINATION'

Line 1384: AHL_DEBUG_PUB.debug('RECEPIENT_ID'||p_x_ahl_mtltxn_tbl(i).RECEPIENT_ID);

1380: IF(p_x_ahl_mtltxn_tbl(i).condition = FND_API.G_MISS_NUM) THEN
1381: p_x_ahl_mtltxn_tbl(i).condition := NULL;
1382: END IF;
1383: IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('RECEPIENT_ID'||p_x_ahl_mtltxn_tbl(i).RECEPIENT_ID);
1385: END IF;
1386:
1387: Insert_Mtl_Txn_Row(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),
1388: p_material_Transaction_Id => NULL,

Line 1398: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');

1394: x_ahl_mtl_txn_id => l_x_Mtl_Txn_Id);
1395:
1396:
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1399: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1400: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1401: END IF;
1402:

Line 1399: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');

1395:
1396:
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1399: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1400: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1401: END IF;
1402:
1403:

Line 1400: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');

1396:
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1399: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1400: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1401: END IF;
1402:
1403:
1404: IF (x_return_status = FND_API.G_RET_STS_ERROR

Line 1427: AHL_DEBUG_PUB.debug('after PartsChange Update Material Return api:ret status=['||x_return_status||']');

1423: x_return_status => x_return_status
1424: );
1425:
1426: IF G_DEBUG='Y' THEN
1427: AHL_DEBUG_PUB.debug('after PartsChange Update Material Return api:ret status=['||x_return_status||']');
1428: END IF;
1429:
1430: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1431: RAISE FND_API.G_EXC_ERROR;

Line 1450: AHL_DEBUG_PUB.debug('after PartsChange Update_Part_Condition api:ret status=['||x_return_status||']');

1446: x_msg_count => x_msg_count
1447: );
1448:
1449: IF G_DEBUG='Y' THEN
1450: AHL_DEBUG_PUB.debug('after PartsChange Update_Part_Condition api:ret status=['||x_return_status||']');
1451: END IF;
1452:
1453: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: RAISE FND_API.G_EXC_ERROR;

Line 1608: AHL_DEBUG_PUB.debug('Unservicable profile value:' || G_AHL_UNSERVICEABLE_CONDITION);

1604:
1605: -- END of if which checks the count of transactions created
1606:
1607: IF (G_DEBUG='Y') THEN
1608: AHL_DEBUG_PUB.debug('Unservicable profile value:' || G_AHL_UNSERVICEABLE_CONDITION);
1609: AHL_DEBUG_PUB.debug('MRB profile value:' || G_AHL_MRB_CONDITION);
1610: END IF;
1611:
1612: IF (l_txn_Id_Tbl.COUNT > 0) THEN

Line 1609: AHL_DEBUG_PUB.debug('MRB profile value:' || G_AHL_MRB_CONDITION);

1605: -- END of if which checks the count of transactions created
1606:
1607: IF (G_DEBUG='Y') THEN
1608: AHL_DEBUG_PUB.debug('Unservicable profile value:' || G_AHL_UNSERVICEABLE_CONDITION);
1609: AHL_DEBUG_PUB.debug('MRB profile value:' || G_AHL_MRB_CONDITION);
1610: END IF;
1611:
1612: IF (l_txn_Id_Tbl.COUNT > 0) THEN
1613: -- THis loop is for creating service request. Since

Line 1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);

1617: --j:=1;
1618: j := l_txn_Id_Tbl.FIRST;
1619: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1620: IF G_DEBUG='Y' THEN
1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);

Line 1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);

1618: j := l_txn_Id_Tbl.FIRST;
1619: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1620: IF G_DEBUG='Y' THEN
1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1626:

Line 1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);

1619: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1620: IF G_DEBUG='Y' THEN
1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1626:
1627: END IF;

Line 1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));

1620: IF G_DEBUG='Y' THEN
1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1626:
1627: END IF;
1628:

Line 1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);

1621: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1622: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1623: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1624: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1625: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1626:
1627: END IF;
1628:
1629: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then

Line 1655: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');

1651:
1652: END LOOP;
1653: -- added for FP bug# 5903318.
1654: IF G_DEBUG='Y' THEN
1655: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1656: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1657: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1658: END IF;
1659:

Line 1656: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');

1652: END LOOP;
1653: -- added for FP bug# 5903318.
1654: IF G_DEBUG='Y' THEN
1655: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1656: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1657: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1658: END IF;
1659:
1660:

Line 1657: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');

1653: -- added for FP bug# 5903318.
1654: IF G_DEBUG='Y' THEN
1655: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1656: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1657: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1658: END IF;
1659:
1660:
1661: IF(l_x_sr_rec_tbl.COUNT > 0) THEN

Line 1673: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');

1669: p_x_sr_task_tbl =>l_x_sr_rec_tbl,
1670: --Parameter added for bug# 6086419.
1671: p_x_mr_asso_tbl => l_mr_asso_tbl);
1672: IF G_DEBUG='Y' THEN
1673: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1674: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1675: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1676: END IF;
1677:

Line 1674: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');

1670: --Parameter added for bug# 6086419.
1671: p_x_mr_asso_tbl => l_mr_asso_tbl);
1672: IF G_DEBUG='Y' THEN
1673: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1674: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1675: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1676: END IF;
1677:
1678: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1675: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');

1671: p_x_mr_asso_tbl => l_mr_asso_tbl);
1672: IF G_DEBUG='Y' THEN
1673: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1674: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1675: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1676: END IF;
1677:
1678: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1679: RAISE FND_API.G_EXC_ERROR;

Line 1687: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');

1683:
1684: -- ANd now update the nonroutine workorder id in the workorder_mtl_Txns table
1685: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1686: IF G_DEBUG='Y' THEN
1687: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1688: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1689: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1690: END IF;
1691:

Line 1688: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');

1684: -- ANd now update the nonroutine workorder id in the workorder_mtl_Txns table
1685: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1686: IF G_DEBUG='Y' THEN
1687: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1688: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1689: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1690: END IF;
1691:
1692: -- update non-routine workorder id.

Line 1689: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');

1685: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1686: IF G_DEBUG='Y' THEN
1687: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1688: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1689: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1690: END IF;
1691:
1692: -- update non-routine workorder id.
1693: UPDATE AHL_WORKORDER_MTL_TXNS

Line 1810: AHL_DEBUG_PUB.enable_debug;

1806: l_quantity NUMBER;
1807: BEGIN
1808:
1809: IF G_DEBUG='Y' THEN
1810: AHL_DEBUG_PUB.enable_debug;
1811: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Inventory_Item_Id='|| p_x_ahl_mtltxn_rec.Inventory_Item_Id);
1812: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1813: END IF;
1814: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(

Line 1811: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Inventory_Item_Id='|| p_x_ahl_mtltxn_rec.Inventory_Item_Id);

1807: BEGIN
1808:
1809: IF G_DEBUG='Y' THEN
1810: AHL_DEBUG_PUB.enable_debug;
1811: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Inventory_Item_Id='|| p_x_ahl_mtltxn_rec.Inventory_Item_Id);
1812: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1813: END IF;
1814: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(
1815: X_ROWID => l_x_row_id,

Line 1812: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);

1808:
1809: IF G_DEBUG='Y' THEN
1810: AHL_DEBUG_PUB.enable_debug;
1811: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Inventory_Item_Id='|| p_x_ahl_mtltxn_rec.Inventory_Item_Id);
1812: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1813: END IF;
1814: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(
1815: X_ROWID => l_x_row_id,
1816: X_WORKORDER_MTL_TXN_ID => x_ahl_mtl_txn_id,

Line 1863: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);

1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1860: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1861:
1862: IF G_DEBUG='Y' THEN
1863: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);
1864: END IF;
1865:
1866: /*
1867:

Line 1873: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn' || SQLCODE);

1869: WHEN OTHERS THEN
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: IF G_DEBUG='Y'
1872: THEN
1873: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn' || SQLCODE);
1874: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1875: END IF;
1876:
1877: */

Line 1874: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);

1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: IF G_DEBUG='Y'
1872: THEN
1873: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn' || SQLCODE);
1874: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1875: END IF;
1876:
1877: */
1878: END Insert_Mtl_Txn_Row;

Line 2293: AHL_DEBUG_PUB.enable_debug;

2289:
2290: x_return_status := FND_API.G_RET_STS_SUCCESS;
2291:
2292: IF G_DEBUG='Y' THEN
2293: AHL_DEBUG_PUB.enable_debug;
2294: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
2295: END IF;
2296:
2297: -- Validate transaction type id(should be one of wip conponent issue or return

Line 2294: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');

2290: x_return_status := FND_API.G_RET_STS_SUCCESS;
2291:
2292: IF G_DEBUG='Y' THEN
2293: AHL_DEBUG_PUB.enable_debug;
2294: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
2295: END IF;
2296:
2297: -- Validate transaction type id(should be one of wip conponent issue or return
2298: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND

Line 2307: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtltxn_rec.Quantity)||']');

2303: END IF;
2304: -- transaction quantity should be +ve always. Negative quantities are not
2305: -- supported currently.
2306: IF G_DEBUG='Y' THEN
2307: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtltxn_rec.Quantity)||']');
2308: END IF;
2309:
2310: IF(nvl(p_x_ahl_mtltxn_rec.Quantity,0) <= 0) THEN
2311: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

Line 2318: AHL_DEBUG_PUB.debug('Validating Wip_Entity_id['

2314: x_return_status := FND_API.G_RET_STS_ERROR;
2315: END IF;
2316:
2317: IF G_DEBUG='Y' THEN
2318: AHL_DEBUG_PUB.debug('Validating Wip_Entity_id['
2319: ||to_char(p_x_ahl_mtltxn_rec.Organization_ID)||','
2320: ||to_Char(p_x_ahl_mtltxn_rec.Workorder_ID)
2321: ||','||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2322:

Line 2332: AHL_DEBUG_PUB.debug('JOB validation failed');

2328: FETCH AHL_WIPJOB_CUR INTO l_job_status, l_visit_id, l_inv_locator_id,
2329: l_project_id, l_project_task_id, l_subinventory_code;
2330: IF(AHL_WIPJOB_CUR%NOTFOUND) THEN
2331: IF G_DEBUG='Y' THEN
2332: AHL_DEBUG_PUB.debug('JOB validation failed');
2333: END IF;
2334: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
2335: if(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
2336: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;

Line 2353: AHL_DEBUG_PUB.debug('JOB validation success['||l_job_status||']');

2349: END IF;
2350: --
2351:
2352: IF G_DEBUG='Y' THEN
2353: AHL_DEBUG_PUB.debug('JOB validation success['||l_job_status||']');
2354: END IF;
2355: -- fix for re-open case in bug# 6773241
2356: IF (p_x_ahl_mtltxn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2357: IF(l_job_status <> C_JOB_RELEASED

Line 2386: AHL_DEBUG_PUB.debug('Validating Workorder operation Id ['||to_Char(p_x_ahl_mtltxn_rec.Workorder_ID)||','

2382: END IF;
2383: CLOSE AHL_WIPJOB_CUR;
2384:
2385: IF G_DEBUG='Y' THEN
2386: AHL_DEBUG_PUB.debug('Validating Workorder operation Id ['||to_Char(p_x_ahl_mtltxn_rec.Workorder_ID)||','
2387: ||to_Char(p_x_ahl_mtltxn_rec.Operation_Seq_Num)||','||to_Char(p_x_ahl_mtltxn_rec.Workorder_Operation_Id)||']');
2388: END IF;
2389:
2390:

Line 2407: AHL_DEBUG_PUB.debug('Validating item_id['||to_Char(p_x_ahl_mtltxn_rec.Organization_ID)||','||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||']');

2403: END IF;
2404: CLOSE AHL_WORKORDER_OPER_CUR;
2405:
2406: IF G_DEBUG='Y' THEN
2407: AHL_DEBUG_PUB.debug('Validating item_id['||to_Char(p_x_ahl_mtltxn_rec.Organization_ID)||','||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||']');
2408: END IF;
2409:
2410: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE
2411: and p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id is null

Line 2470: AHL_DEBUG_PUB.debug('Defaulting from Visit Locator['||l_inv_locator_id||','|| l_project_id ||',' || l_project_task_id || ']');

2466: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
2467: AND (p_x_ahl_mtltxn_rec.move_to_project_flag = 'Y') THEN
2468: IF (l_inv_locator_id IS NOT NULL) THEN
2469: IF G_DEBUG='Y' THEN
2470: AHL_DEBUG_PUB.debug('Defaulting from Visit Locator['||l_inv_locator_id||','|| l_project_id ||',' || l_project_task_id || ']');
2471: END IF;
2472: PJM_PROJECT_LOCATOR.Get_DefaultProjectLocator(
2473: p_organization_id => p_x_ahl_mtltxn_rec.organization_id,
2474: p_locator_id => l_inv_locator_id,

Line 2499: AHL_DEBUG_PUB.debug('Defaulting SubInv/Locator['||p_x_ahl_mtltxn_rec.Subinventory_Name||',' ||

2495:
2496: -- Added Post 11.5.10: Default subinventory.
2497: --
2498: IF G_DEBUG='Y' THEN
2499: AHL_DEBUG_PUB.debug('Defaulting SubInv/Locator['||p_x_ahl_mtltxn_rec.Subinventory_Name||',' ||
2500: p_x_ahl_mtltxn_rec.Locator_id || ']');
2501: END IF;
2502: OPEN wip_params_cur(p_x_ahl_mtltxn_rec.Organization_ID);
2503: FETCH wip_params_cur INTO l_def_supply_subinv, l_def_supply_locator_id;

Line 2527: AHL_DEBUG_PUB.debug('Validating serial num(control, srl_num)['||to_Char(l_serial_Control)||','||p_x_ahl_mtltxn_rec.Serial_Number||']');

2523: CLOSE wip_params_cur;
2524:
2525:
2526: IF G_DEBUG='Y' THEN
2527: AHL_DEBUG_PUB.debug('Validating serial num(control, srl_num)['||to_Char(l_serial_Control)||','||p_x_ahl_mtltxn_rec.Serial_Number||']');
2528: END IF;
2529:
2530: -- If the item is of serial controlled check if the serial numebr is null
2531: IF((p_x_ahl_mtltxn_rec.Serial_Number IS NULL

Line 2553: AHL_DEBUG_PUB.debug('Validating Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');

2549: END IF;
2550:
2551: -- Added for FP bug# 5903318.
2552: IF G_DEBUG='Y' THEN
2553: AHL_DEBUG_PUB.debug('Validating Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2554: END IF;
2555:
2556: -- Validate Create WO Option lookup code.
2557: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

Line 2581: AHL_DEBUG_PUB.debug('After Defaulting Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');

2577: CLOSE create_wo_cur;
2578: END IF;
2579:
2580: IF G_DEBUG='Y' THEN
2581: AHL_DEBUG_PUB.debug('After Defaulting Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2582: END IF;
2583:
2584: -- Check if create_wo_option is valid based on l_serial_Control.
2585: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL ) THEN

Line 2612: AHL_DEBUG_PUB.debug('Validating lot num(control, srl_num)['||to_Char(l_lot_Control)||','||p_x_ahl_mtltxn_rec.serial_Number||']');

2608: p_x_ahl_mtltxn_rec.service_type_code := NULL;
2609: END IF;
2610:
2611: IF G_DEBUG='Y' THEN
2612: AHL_DEBUG_PUB.debug('Validating lot num(control, srl_num)['||to_Char(l_lot_Control)||','||p_x_ahl_mtltxn_rec.serial_Number||']');
2613: END IF;
2614:
2615: -- If the item is of lot controlled check if the lot number is null
2616: IF((p_x_ahl_mtltxn_rec.Lot_Number IS NULL

Line 2659: AHL_DEBUG_PUB.debug('Validating locator(control, srl_num)['||to_Char(l_location_Control)||','||to_Char(p_x_ahl_mtltxn_rec.Locator_Id)||']');

2655: /****************************************************************
2656: This vlaidation happens in the MTL API, so we do not need it here
2657:
2658: IF G_DEBUG='Y' THEN
2659: AHL_DEBUG_PUB.debug('Validating locator(control, srl_num)['||to_Char(l_location_Control)||','||to_Char(p_x_ahl_mtltxn_rec.Locator_Id)||']');
2660:
2661: END IF;
2662:
2663: IF(p_x_ahl_mtltxn_rec.Locator_Id IS NULL

Line 2695: AHL_DEBUG_PUB.debug('Validating revision['||p_x_ahl_mtltxn_rec.Revision||']');

2691: CLOSE AHL_LOCATOR_CUR;
2692: END IF;
2693:
2694: IF G_DEBUG='Y' THEN
2695: AHL_DEBUG_PUB.debug('Validating revision['||p_x_ahl_mtltxn_rec.Revision||']');
2696: END IF;
2697:
2698: -- Tamal: Bug #4091154: Begin
2699: -- If item is revision-controlled, then verify revision is NOT NULL and is valid

Line 2770: AHL_DEBUG_PUB.debug('Validating Condition/Subinv['||p_x_ahl_mtltxn_rec.Condition||','||p_x_ahl_mtltxn_rec.Subinventory_Name||']');

2766: END IF;
2767: CLOSE Condition_Cur;
2768:
2769: IF G_DEBUG='Y' THEN
2770: AHL_DEBUG_PUB.debug('Validating Condition/Subinv['||p_x_ahl_mtltxn_rec.Condition||','||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2771: END IF;
2772:
2773: -- Check if the Condition matches the Sub inventory status
2774: -- in case of unserviceable and MRB

Line 2785: AHL_DEBUG_PUB.debug('Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');

2781: END IF;
2782:
2783: ELSE
2784: IF G_DEBUG='Y' THEN
2785: AHL_DEBUG_PUB.debug('Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2786: END IF;
2787:
2788: -- Sub inventory validation
2789: AHL_PRD_UTIL_PKG.Validate_Material_Status(p_x_ahl_mtltxn_rec.Organization_Id,

Line 2794: AHL_DEBUG_PUB.debug('After Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||','||x_return_Status || ']');

2790: p_x_ahl_mtltxn_rec.Subinventory_Name,
2791: NULL,
2792: l_return_Status);
2793: IF G_DEBUG='Y' THEN
2794: AHL_DEBUG_PUB.debug('After Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||','||x_return_Status || ']');
2795: END IF;
2796:
2797: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2798: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2813: AHL_DEBUG_PUB.debug('selecting wip location id..');

2809: IF (Is_Item_Trackable(p_x_ahl_mtltxn_rec.Organization_Id,
2810: p_x_ahl_mtltxn_rec.Inventory_Item_Id)) THEN
2811:
2812: IF G_DEBUG='Y' THEN
2813: AHL_DEBUG_PUB.debug('selecting wip location id..');
2814: END IF;
2815: -- R12: Fix for bug# 5221513
2816: -- IB team have asked us to remove the location validation to fix the issue.
2817: /*

Line 2827: AHL_DEBUG_PUB.debug('wip location id['||to_char(l_wip_location)||']');

2823: x_return_status := FND_API.G_RET_STS_ERROR;
2824: END IF;
2825: CLOSE CSI_LOCATION_CUR;
2826: IF G_DEBUG='Y' THEN
2827: AHL_DEBUG_PUB.debug('wip location id['||to_char(l_wip_location)||']');
2828: END IF;
2829: */
2830:
2831: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NULL

Line 2872: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/subinv['

2868: END IF;
2869:
2870: BEGIN
2871: IF G_DEBUG='Y' THEN
2872: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/subinv['
2873: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2874: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2875:
2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');

Line 2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');

2872: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/subinv['
2873: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2874: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2875:
2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');

Line 2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');

2873: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2874: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2875:
2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2881: END IF;

Line 2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');

2874: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2875:
2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2881: END IF;
2882: -- R12: Fix for bug# 5221513

Line 2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');

2875:
2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2881: END IF;
2882: -- R12: Fix for bug# 5221513
2883: -- remove WIP location validation.

Line 2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');

2876: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2877: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2878: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2879: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2880: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2881: END IF;
2882: -- R12: Fix for bug# 5221513
2883: -- remove WIP location validation.
2884: IF (l_revision_flag = TRUE) AND (l_lot_flag = TRUE)

Line 2930: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/srl['||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','

2926: ELSE
2927: -- Serialized item...
2928:
2929: IF G_DEBUG='Y' THEN
2930: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/srl['||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2931: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||','
2932: ||p_x_ahl_mtltxn_rec.Serial_Number||']');
2933: END IF;
2934:

Line 3025: AHL_DEBUG_PUB.debug('Validating problem code['||p_x_ahl_mtltxn_rec.Problem_Code||']');

3021: IF(p_x_ahl_mtltxn_rec.Problem_Code IS NOT NULL
3022: AND p_x_ahl_mtltxn_rec.Problem_Code <> FND_API.G_MISS_CHAR) THEN
3023:
3024: IF G_DEBUG='Y' THEN
3025: AHL_DEBUG_PUB.debug('Validating problem code['||p_x_ahl_mtltxn_rec.Problem_Code||']');
3026: END IF;
3027:
3028: OPEN PROBLEM_CODE_LKUP_CUR(p_x_ahl_mtltxn_rec.Problem_Code) ;
3029: FETCH PROBLEM_CODE_LKUP_CUR INTO l_count;

Line 3041: AHL_DEBUG_PUB.debug('Validate Instance qty..Instance:Qty:[' || x_Item_Instance_Id || ':' || l_instance_qty || ']');

3037: END IF;
3038:
3039: -- validate txn quantity with instance qty along with pending txns.
3040: IF G_DEBUG='Y' THEN
3041: AHL_DEBUG_PUB.debug('Validate Instance qty..Instance:Qty:[' || x_Item_Instance_Id || ':' || l_instance_qty || ']');
3042: END IF;
3043:
3044: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL
3045: AND p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) THEN

Line 3066: AHL_DEBUG_PUB.debug('Checking pending txns: nonserial and lot controlled case');

3062: CLOSE mtl_serial_csr;
3063: ELSIF (p_x_ahl_mtltxn_rec.Lot_Number IS NOT NULL
3064: AND p_x_ahl_mtltxn_rec.Lot_Number <> FND_API.G_MISS_CHAR) THEN
3065: IF G_DEBUG='Y' THEN
3066: AHL_DEBUG_PUB.debug('Checking pending txns: nonserial and lot controlled case');
3067: END IF;
3068: OPEN csi_pending_lot_txn(p_x_ahl_mtltxn_rec.Wip_Entity_Id,
3069: p_x_ahl_mtltxn_rec.inventory_item_id,
3070: WIP_CONSTANTS.RETCOMP_TYPE,

Line 3097: AHL_DEBUG_PUB.debug('Updated pending qty: nonserial and lot controlled case:k:' || l_pend_qty || ':' || k);

3093: -- add previous txn qty to pending qty.
3094: l_pend_qty := nvl(l_pend_qty,0) + G_nonserial_ii_tbl(m).quantity;
3095: k := m;
3096: IF G_DEBUG='Y' THEN
3097: AHL_DEBUG_PUB.debug('Updated pending qty: nonserial and lot controlled case:k:' || l_pend_qty || ':' || k);
3098: END IF;
3099: EXIT;
3100: END IF;
3101: END LOOP;

Line 3114: AHL_DEBUG_PUB.debug('Added to G_nonserial_ii_tbl:Count:' || G_nonserial_ii_tbl.count);

3110: IF (k = -1) THEN
3111: G_nonserial_ii_tbl(G_nonserial_ii_tbl.count+1).instance_id := p_x_ahl_mtltxn_rec.item_instance_id;
3112: G_nonserial_ii_tbl(G_nonserial_ii_tbl.count).quantity := nvl(p_x_ahl_mtltxn_rec.quantity,0);
3113: IF G_DEBUG='Y' THEN
3114: AHL_DEBUG_PUB.debug('Added to G_nonserial_ii_tbl:Count:' || G_nonserial_ii_tbl.count);
3115: END IF;
3116: ELSE
3117: G_nonserial_ii_tbl(k).quantity := G_nonserial_ii_tbl(k).quantity + nvl(p_x_ahl_mtltxn_rec.quantity,0);
3118: IF G_DEBUG='Y' THEN

Line 3119: AHL_DEBUG_PUB.debug('Updated pending qty for instance:qty:k:' || G_nonserial_ii_tbl(k).instance_id || ':' || l_pend_qty || ':' || k);

3115: END IF;
3116: ELSE
3117: G_nonserial_ii_tbl(k).quantity := G_nonserial_ii_tbl(k).quantity + nvl(p_x_ahl_mtltxn_rec.quantity,0);
3118: IF G_DEBUG='Y' THEN
3119: AHL_DEBUG_PUB.debug('Updated pending qty for instance:qty:k:' || G_nonserial_ii_tbl(k).instance_id || ':' || l_pend_qty || ':' || k);
3120: END IF;
3121: END IF;
3122:
3123: ELSE

Line 3125: AHL_DEBUG_PUB.debug('Checking pending txns: nonserial and not lot controlled case');

3121: END IF;
3122:
3123: ELSE
3124: IF G_DEBUG='Y' THEN
3125: AHL_DEBUG_PUB.debug('Checking pending txns: nonserial and not lot controlled case');
3126: END IF;
3127: -- nonserial and not lot controlled
3128: OPEN csi_pending_txns_csr(p_x_ahl_mtltxn_rec.Wip_Entity_Id,
3129: p_x_ahl_mtltxn_rec.inventory_item_id,

Line 3156: AHL_DEBUG_PUB.debug('Updated pending qty: nonserial and non lot controlled case:k:' || l_pend_qty || ':' || k);

3152: -- add previous txn qty to pending qty.
3153: l_pend_qty := l_pend_qty + G_nonserial_ii_tbl(m).quantity;
3154: k := m;
3155: IF G_DEBUG='Y' THEN
3156: AHL_DEBUG_PUB.debug('Updated pending qty: nonserial and non lot controlled case:k:' || l_pend_qty || ':' || k);
3157: END IF;
3158: EXIT;
3159: END IF;
3160: END LOOP;

Line 3182: AHL_DEBUG_PUB.debug('Added to G_nonserial_ii_tbl:Count:' || G_nonserial_ii_tbl.count);

3178: IF (k = -1) THEN
3179: G_nonserial_ii_tbl(G_nonserial_ii_tbl.count+1).instance_id := p_x_ahl_mtltxn_rec.item_instance_id;
3180: G_nonserial_ii_tbl(G_nonserial_ii_tbl.count).quantity := nvl(p_x_ahl_mtltxn_rec.quantity,0);
3181: IF G_DEBUG='Y' THEN
3182: AHL_DEBUG_PUB.debug('Added to G_nonserial_ii_tbl:Count:' || G_nonserial_ii_tbl.count);
3183: END IF;
3184: ELSE
3185: G_nonserial_ii_tbl(k).quantity := G_nonserial_ii_tbl(k).quantity + nvl(p_x_ahl_mtltxn_rec.quantity,0);
3186: IF G_DEBUG='Y' THEN

Line 3187: AHL_DEBUG_PUB.debug('Updated pending qty for instance:qty:k:' || G_nonserial_ii_tbl(k).instance_id || ':' || l_pend_qty || ':' || k);

3183: END IF;
3184: ELSE
3185: G_nonserial_ii_tbl(k).quantity := G_nonserial_ii_tbl(k).quantity + nvl(p_x_ahl_mtltxn_rec.quantity,0);
3186: IF G_DEBUG='Y' THEN
3187: AHL_DEBUG_PUB.debug('Updated pending qty for instance:qty:k:' || G_nonserial_ii_tbl(k).instance_id || ':' || l_pend_qty || ':' || k);
3188: END IF;
3189: END IF;
3190: if (G_nonserial_ii_tbl.count > 0) THEN
3191: IF G_DEBUG='Y' THEN

Line 3193: AHL_DEBUG_PUB.debug('instance_id:' || G_nonserial_ii_tbl(z).instance_id);

3189: END IF;
3190: if (G_nonserial_ii_tbl.count > 0) THEN
3191: IF G_DEBUG='Y' THEN
3192: for z in G_nonserial_ii_tbl.first..G_nonserial_ii_tbl.last loop
3193: AHL_DEBUG_PUB.debug('instance_id:' || G_nonserial_ii_tbl(z).instance_id);
3194: AHL_DEBUG_PUB.debug('qty:' || G_nonserial_ii_tbl(z).quantity);
3195: end loop;
3196: end if;
3197: end if;

Line 3194: AHL_DEBUG_PUB.debug('qty:' || G_nonserial_ii_tbl(z).quantity);

3190: if (G_nonserial_ii_tbl.count > 0) THEN
3191: IF G_DEBUG='Y' THEN
3192: for z in G_nonserial_ii_tbl.first..G_nonserial_ii_tbl.last loop
3193: AHL_DEBUG_PUB.debug('instance_id:' || G_nonserial_ii_tbl(z).instance_id);
3194: AHL_DEBUG_PUB.debug('qty:' || G_nonserial_ii_tbl(z).quantity);
3195: end loop;
3196: end if;
3197: end if;
3198:

Line 3224: AHL_DEBUG_PUB.debug('Validating serial num/qty['||p_x_ahl_mtltxn_rec.quantity||']');

3220: --If the serial number is not null and the quantity is <>1 return the
3221: --Error AHL_INVALID_SRL_QTY
3222:
3223: IF G_DEBUG='Y' THEN
3224: AHL_DEBUG_PUB.debug('Validating serial num/qty['||p_x_ahl_mtltxn_rec.quantity||']');
3225: END IF;
3226:
3227: IF ((p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
3228: (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND

Line 3262: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtltxn_rec.Serial_Number||']');

3258: END IF; -- uom code.
3259: END IF; -- serial num.
3260:
3261: IF G_DEBUG='Y' THEN
3262: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtltxn_rec.Serial_Number||']');
3263: END IF;
3264:
3265: -- For issue txn with serial number, validate if subinventory and locator match
3266: -- that from mtl_serial_numbers.

Line 3278: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');

3274: FETCH mtl_srl_num_csr INTO l_curr_subinventory_code, l_curr_locator_id;
3275: IF (mtl_srl_num_csr%FOUND) THEN
3276:
3277: IF G_DEBUG='Y' THEN
3278: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');
3279: END IF;
3280:
3281: IF (p_x_ahl_mtltxn_rec.subinventory_Name IS NOT NULL AND
3282: p_x_ahl_mtltxn_rec.subinventory_Name <> FND_API.G_MISS_CHAR AND

Line 3293: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');

3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: END IF;
3291:
3292: IF G_DEBUG='Y' THEN
3293: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');
3294: END IF;
3295:
3296: IF (p_x_ahl_mtltxn_rec.locator_id IS NOT NULL AND
3297: p_x_ahl_mtltxn_rec.locator_id <> FND_API.G_MISS_NUM AND

Line 3320: AHL_DEBUG_PUB.debug('Validating transaction date['||p_x_ahl_mtltxn_rec.transaction_date||']');

3316: CLOSE mtl_srl_num_csr;
3317: END IF;
3318:
3319: IF G_DEBUG='Y' THEN
3320: AHL_DEBUG_PUB.debug('Validating transaction date['||p_x_ahl_mtltxn_rec.transaction_date||']');
3321: END IF;
3322:
3323: -- Validate transaction date.
3324: IF (p_x_ahl_mtltxn_rec.transaction_date IS NULL OR

Line 3338: AHL_DEBUG_PUB.debug('Error in txn date');

3334: ELSE
3335: IF (p_x_ahl_mtltxn_rec.transaction_date > SYSDATE) THEN
3336:
3337: IF G_DEBUG='Y' THEN
3338: AHL_DEBUG_PUB.debug('Error in txn date');
3339: END IF;
3340: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_DATE');
3341: FND_MESSAGE.Set_Token('DATE',p_x_ahl_mtltxn_rec.transaction_date);
3342: FND_MSG_PUB.ADD;

Line 3362: AHL_DEBUG_PUB.debug('transaction date['||to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-mon-yyyy hh24:mi:ss') ||']');

3358: FND_MSG_PUB.ADD;
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: ELSE
3361: IF G_DEBUG='Y' THEN
3362: AHL_DEBUG_PUB.debug('transaction date['||to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-mon-yyyy hh24:mi:ss') ||']');
3363: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
3364: END IF;
3365: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
3366: IF G_DEBUG='Y' THEN

Line 3363: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');

3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: ELSE
3361: IF G_DEBUG='Y' THEN
3362: AHL_DEBUG_PUB.debug('transaction date['||to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-mon-yyyy hh24:mi:ss') ||']');
3363: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
3364: END IF;
3365: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
3366: IF G_DEBUG='Y' THEN
3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');

Line 3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');

3363: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
3364: END IF;
3365: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
3366: IF G_DEBUG='Y' THEN
3367: AHL_DEBUG_PUB.debug('release date is greater than transaction date');
3368: END IF;
3369: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');
3370: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));
3371: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));

Line 3433: AHL_DEBUG_PUB.debug('after validations api ret_status['||x_return_status||']');

3429: END IF;
3430: END IF; -- -- p_x_ahl_mtltxn_rec.disposition_id
3431:
3432: IF G_DEBUG='Y' THEN
3433: AHL_DEBUG_PUB.debug('after validations api ret_status['||x_return_status||']');
3434: END IF;
3435:
3436:
3437: END VALIDATE_TXN_REC;

Line 3501: AHL_DEBUG_PUB.debug('Did not find the account period for org('||p_x_ahl_mtltxn_rec.Organization_Id||')');

3497: OPEN ACCT_PERIOD_CUR(p_x_ahl_mtltxn_rec.Organization_Id);
3498: FETCH ACCT_PERIOD_CUR INTO l_mmtt_rec.ACCT_PERIOD_ID;
3499: IF(ACCT_PERIOD_CUR%NOTFOUND) THEN
3500: IF G_DEBUG='Y' THEN
3501: AHL_DEBUG_PUB.debug('Did not find the account period for org('||p_x_ahl_mtltxn_rec.Organization_Id||')');
3502:
3503: END IF;
3504: CLOSE ACCT_PERIOD_CUR;
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3513: AHL_DEBUG_PUB.debug('Did not find the Txn Type');

3509: OPEN TRX_ACTION_CUR(p_x_ahl_mtltxn_rec.Transaction_Type_Id);
3510: FETCH TRX_ACTION_CUR INTO l_txn_action, l_txn_source_type;
3511: IF(TRX_ACTION_CUR%NOTFOUND) THEN
3512: IF G_DEBUG='Y' THEN
3513: AHL_DEBUG_PUB.debug('Did not find the Txn Type');
3514:
3515: END IF;
3516: CLOSE TRX_ACTION_CUR;
3517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3647: AHL_DEBUG_PUB.debug('inserting the mmtt..');

3643: END IF;
3644: END IF;
3645:
3646: IF G_DEBUG='Y' THEN
3647: AHL_DEBUG_PUB.debug('inserting the mmtt..');
3648: END IF;
3649:
3650: inv_util.insert_mmtt(p_api_version => 1,
3651: p_mmtt_rec =>l_mmtt_rec,

Line 3659: AHL_DEBUG_PUB.debug('inserted in mmtt..ret_status['||x_return_status||']');

3655: x_msg_count =>x_msg_count,
3656: x_msg_data => x_msg_data);
3657:
3658: IF G_DEBUG='Y' THEN
3659: AHL_DEBUG_PUB.debug('inserted in mmtt..ret_status['||x_return_status||']');
3660: END IF;
3661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3662: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3663: FND_MESSAGE.Set_Token('MSG',x_msg_data);

Line 3707: AHL_DEBUG_PUB.debug('inserting in mtlt..');

3703: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3704: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3705:
3706: IF G_DEBUG='Y' THEN
3707: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3708: END IF;
3709:
3710: inv_util.insert_mtlt(p_api_version => 1,
3711: p_mtlt_rec =>l_mtlt_rec,

Line 3716: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');

3712: x_return_status => x_return_status,
3713: x_msg_count =>x_msg_count,
3714: x_msg_data => x_msg_data);
3715: IF G_DEBUG='Y' THEN
3716: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3717: END IF;
3718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3720: FND_MESSAGE.Set_Token('MSG',x_msg_data);

Line 3725: AHL_DEBUG_PUB.debug('inserting in msnt..');

3721: FND_MSG_PUB.ADD;
3722: RAISE FND_API.G_EXC_ERROR;
3723: END IF;
3724: IF G_DEBUG='Y' THEN
3725: AHL_DEBUG_PUB.debug('inserting in msnt..');
3726:
3727: END IF;
3728: inv_util.insert_msnt(p_api_version => 1,
3729: p_msnt_rec =>l_msnt_rec,

Line 3735: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');

3731: x_msg_count =>x_msg_count,
3732: x_msg_data => x_msg_data);
3733:
3734: IF G_DEBUG='Y' THEN
3735: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');
3736:
3737: END IF;
3738:
3739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3761: AHL_DEBUG_PUB.debug('inserting in mtlt..');

3757: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3758: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3759:
3760: IF G_DEBUG='Y' THEN
3761: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3762:
3763: END IF;
3764: inv_util.insert_mtlt(p_api_version => 1,
3765: p_mtlt_rec =>l_mtlt_rec,

Line 3770: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');

3766: x_return_status => x_return_status,
3767: x_msg_count =>x_msg_count,
3768: x_msg_data => x_msg_data);
3769: IF G_DEBUG='Y' THEN
3770: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3771:
3772: END IF;
3773: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3774: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

Line 3793: AHL_DEBUG_PUB.debug('inserting in msnt..');

3789: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3790: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3791:
3792: IF G_DEBUG='Y' THEN
3793: AHL_DEBUG_PUB.debug('inserting in msnt..');
3794:
3795: END IF;
3796:
3797: inv_util.insert_msnt(p_api_version => 1,

Line 3803: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');

3799: x_return_status => x_return_status,
3800: x_msg_count =>x_msg_count,
3801: x_msg_data => x_msg_data);
3802: IF G_DEBUG='Y' THEN
3803: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');
3804:
3805: END IF;
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3894: AHL_DEBUG_PUB.debug('Entered Insert_Sch_Mtl_Row');

3890: -- Bug # 9373684 (FP for Bug # 9248655) -- end
3891: BEGIN
3892:
3893: IF G_DEBUG='Y' THEN
3894: AHL_DEBUG_PUB.debug('Entered Insert_Sch_Mtl_Row');
3895:
3896: END IF;
3897: OPEN Workop_Det_Cur( p_mtl_txn_Rec.Workorder_Id);
3898: FETCH Workop_Det_Cur INTO l_Visit_Id,l_visit_task_Id,l_project_id,l_project_Task_id;

Line 3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');

3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905: CLOSE Workop_Det_Cur;
3906: IF G_DEBUG='Y' THEN
3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');

Line 3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');

3904: END IF;
3905: CLOSE Workop_Det_Cur;
3906: IF G_DEBUG='Y' THEN
3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');

Line 3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');

3905: CLOSE Workop_Det_Cur;
3906: IF G_DEBUG='Y' THEN
3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3913:

Line 3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');

3906: IF G_DEBUG='Y' THEN
3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3913:
3914: END IF;

Line 3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');

3907: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3913:
3914: END IF;
3915:

Line 3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');

3908: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3909: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3910: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3911: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3912: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3913:
3914: END IF;
3915:
3916: -- Bug # 9373684 (FP for Bug # 9248655) -- start

Line 3929: AHL_DEBUG_PUB.debug('Selected the Item description');

3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;
3927: CLOSE Item_Desc_Cur;
3928: IF G_DEBUG='Y' THEN
3929: AHL_DEBUG_PUB.debug('Selected the Item description');
3930:
3931: END IF;
3932: */
3933: -- Bug # 9373684 (FP for Bug # 9248655) -- end

Line 3986: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');

3982: --Material_Tbl(0).Req_Material_Rec_Type :=
3983:
3984:
3985: IF G_DEBUG='Y' THEN
3986: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3987:
3988: END IF;
3989: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3990: p_x_req_material_tbl => Material_Tbl,

Line 3998: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');

3994: x_return_status => x_return_status,
3995: x_msg_count => x_msg_count,
3996: x_msg_data => x_msg_data);
3997: IF G_DEBUG='Y' THEN
3998: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3999:
4000: END IF;
4001: IF G_DEBUG='Y' THEN
4002: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');

Line 4002: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');

3998: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3999:
4000: END IF;
4001: IF G_DEBUG='Y' THEN
4002: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');
4003: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');
4004:
4005: END IF;
4006: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4003: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');

3999:
4000: END IF;
4001: IF G_DEBUG='Y' THEN
4002: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');
4003: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');
4004:
4005: END IF;
4006: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4007: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');

Line 4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');

4065: p_srvc_rec.SERVICE_TYPE := p_x_ahl_mtltxn_rec.SERVICE_TYPE;
4066: p_srvc_rec.SERVICE_TYPE_CODE := p_x_ahl_mtltxn_rec.SERVICE_TYPE_CODE;
4067:
4068: IF G_DEBUG='Y' THEN
4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');

Line 4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');

4066: p_srvc_rec.SERVICE_TYPE_CODE := p_x_ahl_mtltxn_rec.SERVICE_TYPE_CODE;
4067:
4068: IF G_DEBUG='Y' THEN
4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');

Line 4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');

4067:
4068: IF G_DEBUG='Y' THEN
4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');

Line 4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');

4068: IF G_DEBUG='Y' THEN
4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');

Line 4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');

4069: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');

Line 4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');

4070: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
4078:

Line 4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');

4071: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
4078:
4079: END IF;

Line 4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');

4072: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
4078:
4079: END IF;
4080:

Line 4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');

4073: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
4074: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
4075: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
4076: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
4077: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
4078:
4079: END IF;
4080:
4081:

Line 4180: AHL_DEBUG_PUB.debug('Did not find the Txn Type');

4176: OPEN TRX_ACTION_CUR(p_x_ahl_mtl_txn_rec.Transaction_Type_Id);
4177: FETCH TRX_ACTION_CUR INTO l_txn_action, l_txn_source_type;
4178: IF(TRX_ACTION_CUR%NOTFOUND) THEN
4179: IF G_DEBUG='Y' THEN
4180: AHL_DEBUG_PUB.debug('Did not find the Txn Type');
4181: END IF;
4182: CLOSE TRX_ACTION_CUR;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;

Line 4193: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');

4189: SELECT Mtl_Material_Transactions_S.nextval
4190: INTO p_x_txn_hdr_id
4191: FROM DUAL;
4192: IF G_DEBUG='Y' THEN
4193: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
4194: END IF;
4195: END IF;
4196:
4197: l_loop_count := 0;

Line 4206: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');

4202: INTO p_x_txn_intf_id
4203: FROM DUAL;
4204:
4205: IF G_DEBUG='Y' THEN
4206: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
4207: END IF;
4208:
4209: if(p_x_ahl_mtl_txn_rec.Revision = FND_API.G_MISS_CHAR) THEN
4210: p_x_ahl_mtl_txn_rec.Revision := NULL;

Line 4233: AHL_DEBUG_PUB.debug('Loop Count is..['||l_loop_count||']');

4229: l_loop_count := p_x_ahl_mtl_txn_rec.Quantity + 1;
4230: END IF;
4231: END IF;
4232: IF G_DEBUG='Y' THEN
4233: AHL_DEBUG_PUB.debug('Loop Count is..['||l_loop_count||']');
4234: AHL_DEBUG_PUB.debug('l_qty is..['||l_qty||']');
4235: END IF;
4236:
4237: IF( p_x_ahl_mtl_txn_rec.Reason_Id = FND_API.G_MISS_NUM) THEN

Line 4234: AHL_DEBUG_PUB.debug('l_qty is..['||l_qty||']');

4230: END IF;
4231: END IF;
4232: IF G_DEBUG='Y' THEN
4233: AHL_DEBUG_PUB.debug('Loop Count is..['||l_loop_count||']');
4234: AHL_DEBUG_PUB.debug('l_qty is..['||l_qty||']');
4235: END IF;
4236:
4237: IF( p_x_ahl_mtl_txn_rec.Reason_Id = FND_API.G_MISS_NUM) THEN
4238: p_x_ahl_mtl_txn_rec.Reason_Id := NULL;

Line 4300: AHL_DEBUG_PUB.debug('Before dynamic chk:loc segs:ID' || p_x_ahl_mtl_txn_rec.Locator_Segments || ':' || p_x_ahl_mtl_txn_rec.Locator_Id);

4296: p_x_ahl_mtl_txn_rec.transaction_reference := NULL;
4297: END IF;
4298:
4299: IF G_DEBUG='Y' THEN
4300: AHL_DEBUG_PUB.debug('Before dynamic chk:loc segs:ID' || p_x_ahl_mtl_txn_rec.Locator_Segments || ':' || p_x_ahl_mtl_txn_rec.Locator_Id);
4301: END IF;
4302:
4303: -- Added for FP ER 6447935
4304: -- support dynamic locator creation if allowed.

Line 4348: AHL_DEBUG_PUB.debug('insertng the lot record,interface id,tempid['

4344: l_txn_tmp_id := p_x_txn_intf_id;
4345: END IF;
4346:
4347: IF G_DEBUG='Y' THEN
4348: AHL_DEBUG_PUB.debug('insertng the lot record,interface id,tempid['
4349: ||to_char(p_x_txn_intf_id)||','
4350: ||to_char(l_txn_tmp_id)||']');
4351: END IF;
4352:

Line 4433: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['

4429: l_txn_tmp_id := p_x_txn_intf_id;
4430: END IF;
4431:
4432: IF G_DEBUG='Y' THEN
4433: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['
4434: ||to_char(l_txn_tmp_id)||']');
4435: END IF;
4436:
4437: -- Fix for bug # 8607839(FP for Bug # 8636342) -- start

Line 4502: AHL_DEBUG_PUB.debug('insertng the txn record,header id,interface id['

4498:
4499:
4500:
4501: IF G_DEBUG='Y' THEN
4502: AHL_DEBUG_PUB.debug('insertng the txn record,header id,interface id['
4503: ||to_char(p_x_txn_hdr_id)||','
4504: ||to_char(p_x_txn_intf_id)||']');
4505: END IF;
4506:

Line 4584: AHL_DEBUG_PUB.debug('Transaction_source type['||l_txn_source_type||']');

4580: END LOOP; -- WHILE (l_loop_count
4581:
4582:
4583: IF G_DEBUG='Y' THEN
4584: AHL_DEBUG_PUB.debug('Transaction_source type['||l_txn_source_type||']');
4585: AHL_DEBUG_PUB.debug('Transaction_source Id['||p_x_ahl_mtl_txn_rec.Wip_Entity_id||']');
4586: END IF;
4587:
4588: EXCEPTION

Line 4585: AHL_DEBUG_PUB.debug('Transaction_source Id['||p_x_ahl_mtl_txn_rec.Wip_Entity_id||']');

4581:
4582:
4583: IF G_DEBUG='Y' THEN
4584: AHL_DEBUG_PUB.debug('Transaction_source type['||l_txn_source_type||']');
4585: AHL_DEBUG_PUB.debug('Transaction_source Id['||p_x_ahl_mtl_txn_rec.Wip_Entity_id||']');
4586: END IF;
4587:
4588: EXCEPTION
4589: WHEN OTHERS THEN

Line 4592: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);

4588: EXCEPTION
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_ERROR;
4591: IF G_DEBUG='Y' THEN
4592: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
4593: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
4594:
4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

Line 4593: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);

4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_ERROR;
4591: IF G_DEBUG='Y' THEN
4592: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
4593: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
4594:
4595: END IF;
4596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
4597: FND_MESSAGE.Set_Token('MSG',SQLERRM);

Line 4780: AHL_DEBUG_PUB.DEBUG('INPUTS TO THE PROC ARE ...');

4776: procedure dumpInput(p_x_ahl_mtltxn_tbl IN AHL_MTLTXN_TBL_TYPE) IS
4777: BEGIN
4778:
4779: IF G_DEBUG='Y' THEN
4780: AHL_DEBUG_PUB.DEBUG('INPUTS TO THE PROC ARE ...');
4781:
4782: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4783: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4784:

Line 4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);

4781:
4782: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4783: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4784:
4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);

Line 4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);

4782: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4783: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4784:
4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);

Line 4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);

4783: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4784:
4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);

Line 4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);

4784:
4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);

Line 4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);

4785: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);

Line 4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);

4786: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);

Line 4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);

4787: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);

Line 4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);

4788: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);

Line 4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);

4789: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);

Line 4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);

4790: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);

Line 4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);

4791: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);

Line 4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);

4792: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);

Line 4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);

4793: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);

Line 4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);

4794: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);

Line 4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);

4795: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);

Line 4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);

4796: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);

Line 4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);

4797: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);

Line 4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);

4798: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);

Line 4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);

4799: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);

Line 4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);

4800: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);

Line 4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);

4801: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);

Line 4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);

4802: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:

Line 4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);

4803: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:
4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);

Line 4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);

4804: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:
4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4812:

Line 4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);

4805: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4806: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:
4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4812:
4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);

Line 4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);

4807: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4808: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:
4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4812:
4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4814:
4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);

Line 4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);

4809: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4810:
4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4812:
4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4814:
4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4816:
4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);

Line 4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);

4811: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4812:
4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4814:
4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4816:
4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4818:
4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);

Line 4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);

4813: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4814:
4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4816:
4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4818:
4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4820:
4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);

Line 4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);

4815: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4816:
4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4818:
4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4820:
4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4822:
4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);

Line 4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);

4817: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4818:
4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4820:
4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4822:
4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4824:
4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);

Line 4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);

4819: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4820:
4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4822:
4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4824:
4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4826:
4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);

Line 4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);

4821: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4822:
4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4824:
4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4826:
4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4828:
4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);

Line 4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);

4823: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4824:
4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4826:
4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4828:
4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4830:
4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);

Line 4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);

4825: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4826:
4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4828:
4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4830:
4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4832:
4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);

Line 4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);

4827: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4828:
4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4830:
4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4832:
4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4834:
4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);

Line 4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);

4829: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4830:
4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4832:
4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4834:
4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4836:
4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);

Line 4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);

4831: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4832:
4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4834:
4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4836:
4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4838:
4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);

Line 4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);

4833: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4834:
4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4836:
4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4838:
4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4840:
4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);

Line 4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);

4835: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4836:
4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4838:
4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4840:
4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4842:
4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);

Line 4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);

4837: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4838:
4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4840:
4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4842:
4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4844:
4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);

Line 4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);

4839: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4840:
4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4842:
4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4844:
4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4846:
4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);

Line 4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);

4841: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4842:
4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4844:
4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4846:
4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);

Line 4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);

4843: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4844:
4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4846:
4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);

Line 4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);

4845: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4846:
4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);

Line 4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);

4846:
4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);

Line 4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);

4847: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);

Line 4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);

4848:
4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4856: END LOOP;

Line 4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);

4849: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4856: END LOOP;
4857: END IF; -- p_x_ahl_mtltxn_tbl.COUNT

Line 4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);

4850: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4856: END LOOP;
4857: END IF; -- p_x_ahl_mtltxn_tbl.COUNT
4858: END IF;

Line 4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);

4851: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4852: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4853: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4854: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4855: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4856: END LOOP;
4857: END IF; -- p_x_ahl_mtltxn_tbl.COUNT
4858: END IF;
4859: END dumpInput;

Line 7557: AHL_DEBUG_PUB.DEBUG('Start Procedure:Splitting locator concatenated segments:' || p_concat_segs, 'Get_MTL_LocatorSegs');

7553:
7554: BEGIN
7555:
7556: IF G_DEBUG='Y' THEN
7557: AHL_DEBUG_PUB.DEBUG('Start Procedure:Splitting locator concatenated segments:' || p_concat_segs, 'Get_MTL_LocatorSegs');
7558: END IF;
7559:
7560: -- initialize status to success.
7561: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7583: AHL_DEBUG_PUB.DEBUG('Before Loc Seg validate:Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );

7579: -- find segment delimiter
7580: l_delim := l_ffstru.segment_separator;
7581:
7582: IF G_DEBUG='Y' THEN
7583: AHL_DEBUG_PUB.DEBUG('Before Loc Seg validate:Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
7584: END IF;
7585:
7586: -- validate locator segments.
7587: l_valid_flag := fnd_flex_keyval.validate_segs(

Line 7616: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);

7612: -- validate if enabled segments equal to input locator segments.
7613: -- if not, raise error and return.
7614: IF (l_loc_nseg <> l_flex_nseg) THEN
7615: IF G_DEBUG='Y' THEN
7616: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);
7617: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
7618: END IF;
7619:
7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');

Line 7617: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);

7613: -- if not, raise error and return.
7614: IF (l_loc_nseg <> l_flex_nseg) THEN
7615: IF G_DEBUG='Y' THEN
7616: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);
7617: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
7618: END IF;
7619:
7620: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7621: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);

Line 7650: AHL_DEBUG_PUB.DEBUG('Segs final(' || i || ') : ' || p_x_mti_seglist(i), 'Get_MTL_LocatorSegs');

7646:
7647: IF G_DEBUG='Y' THEN
7648: FOR i IN 1..20 LOOP
7649: --dbms_output.put_line('Segs final(' || i || ') : ' || l_mti_seglist(i));
7650: AHL_DEBUG_PUB.DEBUG('Segs final(' || i || ') : ' || p_x_mti_seglist(i), 'Get_MTL_LocatorSegs');
7651: END LOOP;
7652: AHL_DEBUG_PUB.DEBUG('End of procedure', 'Get_MTL_LocatorSegs');
7653: END IF;
7654:

Line 7652: AHL_DEBUG_PUB.DEBUG('End of procedure', 'Get_MTL_LocatorSegs');

7648: FOR i IN 1..20 LOOP
7649: --dbms_output.put_line('Segs final(' || i || ') : ' || l_mti_seglist(i));
7650: AHL_DEBUG_PUB.DEBUG('Segs final(' || i || ') : ' || p_x_mti_seglist(i), 'Get_MTL_LocatorSegs');
7651: END LOOP;
7652: AHL_DEBUG_PUB.DEBUG('End of procedure', 'Get_MTL_LocatorSegs');
7653: END IF;
7654:
7655: END Get_MTL_LocatorSegs;
7656: