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.28.12010000.4 2008/11/26 11:31:26 jkjain 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: -- Hard coded string used in this proc

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

285: -- order id and Operation seq number
286: -- ?????????
287:
288: IF G_DEBUG='Y' THEN
289: AHL_DEBUG_PUB.debug('Convert_Name_To_Id');
290: END IF;
291:
292: IF ( (p_x_ahl_mtltxn_rec.Workorder_Id IS NULL
293: OR p_x_ahl_mtltxn_rec.Workorder_Id = FND_API.G_MISS_NUM)) THEN

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

370:
371: IF (p_x_ahl_mtltxn_rec.Wip_Entity_Id IS NULL
372: OR p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
373: IF G_DEBUG='Y' THEN
374: AHL_DEBUG_PUB.debug('Getting WipEntity for['||p_x_ahl_mtltxn_rec.Workorder_Id||']');
375: END IF;
376: OPEN WIP_JOB_ID_CUR(p_x_ahl_mtltxn_rec.Workorder_Id);
377: FETCH WIP_JOB_ID_CUR INTO p_x_ahl_mtltxn_rec.Wip_Entity_Id,p_x_ahl_mtltxn_rec.Organization_Id ;
378: IF(WIP_JOB_ID_CUR%NOTFOUND) THEN

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

386:
387:
388:
389: IF G_DEBUG='Y' THEN
390: AHL_DEBUG_PUB.debug('after the Wip entity select['||p_x_ahl_mtltxn_rec.Wip_Entity_Id||','||p_x_ahl_mtltxn_rec.Organization_Id||']');
391:
392: END IF;
393:
394:

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

394:
395: IF (p_x_ahl_mtltxn_rec.Workorder_Operation_Id IS NULL
396: OR p_x_ahl_mtltxn_rec.Workorder_Operation_Id = FND_API.G_MISS_NUM) THEN
397: IF G_DEBUG='Y' THEN
398: AHL_DEBUG_PUB.debug('selecting woopid for['||p_x_ahl_mtltxn_rec.Workorder_Id||','||p_x_ahl_mtltxn_rec.Operation_Seq_num||']');
399:
400: END IF;
401: OPEN WO_OP_CUR(p_x_ahl_mtltxn_rec.Workorder_Id,
402: p_x_ahl_mtltxn_rec.Operation_Seq_num);

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

410: END IF;
411: CLOSE WO_OP_CUR;
412: END IF;
413: IF G_DEBUG='Y' THEN
414: AHL_DEBUG_PUB.debug('after the woop id select');
415: END IF;
416:
417: --Convert Transaction Type Name into Transaction Type Id
418: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id IS NULL

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

417: --Convert Transaction Type Name into Transaction Type Id
418: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id IS NULL
419: OR p_x_ahl_mtltxn_rec.Transaction_Type_Id = FND_API.G_MISS_NUM) THEN
420: IF G_DEBUG='Y' THEN
421: AHL_DEBUG_PUB.debug('Converting Txn type name['||p_x_ahl_mtltxn_rec.Transaction_Type_Name||']');
422: END IF;
423: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Name IS NULL
424: OR p_x_ahl_mtltxn_rec.Transaction_Type_Name = FND_API.G_MISS_CHAR) THEN
425: FND_MESSAGE.Set_Name('AHL','AHL_PRD_NULL_TXN_TYPE');

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

437: CLOSE Transaction_Type_Cur;
438: END IF;
439: END IF;
440: IF G_DEBUG='Y' THEN
441: AHL_DEBUG_PUB.debug('after the txn type select');
442: END IF;
443:
444: -- Convert item segments into item id
445: 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 447: AHL_DEBUG_PUB.debug('Converting item for['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Inventory_Item_Segments||']');

443:
444: -- Convert item segments into item id
445: 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
446: IF G_DEBUG='Y' THEN
447: AHL_DEBUG_PUB.debug('Converting item for['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Inventory_Item_Segments||']');
448: END IF;
449:
450: IF (p_x_ahl_mtltxn_rec.Inventory_Item_Segments IS NULL
451: OR p_x_ahl_mtltxn_rec.Inventory_Item_Segments = FND_API.G_MISS_CHAR) THEN

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

467:
468: END IF;
469: IF G_DEBUG='Y'
470: THEN
471: AHL_DEBUG_PUB.debug('after the item id select:'||to_char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||'.');
472: END IF;
473:
474: -- Convert Locator segments into locator id when item is locator controlled.
475: IF (p_x_ahl_mtltxn_rec.Locator_Id IS NULL

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

476: OR p_x_ahl_mtltxn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
477: IF (p_x_ahl_mtltxn_rec.Locator_Segments IS NOT NULL
478: AND p_x_ahl_mtltxn_rec.Locator_Segments <> FND_API.G_MISS_CHAR) THEN
479: IF G_DEBUG='Y' THEN
480: AHL_DEBUG_PUB.debug('Converting locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');
481: END IF;
482: OPEN Location_Cur(p_x_ahl_mtltxn_rec.Organization_Id,
483: p_x_ahl_mtltxn_rec.Locator_Segments);
484: FETCH Location_Cur INTO p_x_ahl_mtltxn_rec.Locator_Id,l_locator_segments ;--Fix for bug number 5903275

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

494: */
495: IF (Location_Cur%FOUND) THEN
496: p_x_ahl_mtltxn_rec.Locator_Segments := l_locator_segments;--Fix for bug number 5903275
497: IF G_DEBUG='Y' THEN
498: AHL_DEBUG_PUB.debug('Converted locator['||to_char(p_x_ahl_mtltxn_rec.Organization_Id)||','||p_x_ahl_mtltxn_rec.Locator_Segments||']');
499: END IF;
500: END IF;
501: CLOSE Location_Cur;
502: END IF;

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

502: END IF;
503:
504: END IF;
505: IF G_DEBUG='Y' THEN
506: AHL_DEBUG_PUB.debug('after the locator select');
507: END IF;
508:
509: -- convert reason name into reason id.
510: IF (p_x_ahl_mtltxn_rec.Reason_Id IS NULL OR p_x_ahl_mtltxn_rec.Reason_Id = FND_API.G_MISS_NUM)

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

512: IF (p_x_ahl_mtltxn_rec.Reason_Name IS NOT NULL
513: AND p_x_ahl_mtltxn_rec.Reason_Name <> FND_API.G_MISS_CHAR)
514: THEN
515: IF G_DEBUG='Y' THEN
516: AHL_DEBUG_PUB.debug('Converting reason name'||p_x_ahl_mtltxn_rec.Reason_Name||']');
517: END IF;
518: OPEN Reason_Cur(p_x_ahl_mtltxn_rec.Reason_Name);
519: FETCH Reason_Cur INTO p_x_ahl_mtltxn_rec.Reason_Id ;
520: IF(Reason_Cur%NOTFOUND) THEN

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

528:
529: END IF;
530:
531: IF G_DEBUG='Y' THEN
532: AHL_DEBUG_PUB.debug('after the reason name select');
533: END IF;
534:
535:
536: --Convert Problem_code_Meaning to Problem_code incase of returns

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

540: OR p_x_ahl_mtltxn_rec.Problem_Code = FND_API.G_MISS_CHAR) THEN
541: IF (p_x_ahl_mtltxn_rec.Problem_Code_Meaning IS NOT NULL
542: AND p_x_ahl_mtltxn_rec.Problem_Code_Meaning <> FND_API.G_MISS_CHAR) THEN
543: IF G_DEBUG='Y' THEN
544: AHL_DEBUG_PUB.debug('Converting Problem code['||p_x_ahl_mtltxn_rec.Problem_Code_Meaning||']');
545:
546: END IF;
547: OPEN Fnd_Lookups_Cur(p_x_ahl_mtltxn_rec.Problem_Code_Meaning);
548: FETCH Fnd_Lookups_Cur INTO p_x_ahl_mtltxn_rec.Problem_Code ;

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

555: CLOSE Fnd_Lookups_Cur;
556: END IF;
557: END IF;
558: IF G_DEBUG='Y' THEN
559: AHL_DEBUG_PUB.debug('after problem code select');
560: END IF;
561: IF (p_x_ahl_mtltxn_rec.Condition_Desc IS NOT NULL
562: AND p_x_ahl_mtltxn_rec.Condition_Desc <> FND_API.G_MISS_CHAR)
563: THEN

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

561: IF (p_x_ahl_mtltxn_rec.Condition_Desc IS NOT NULL
562: AND p_x_ahl_mtltxn_rec.Condition_Desc <> FND_API.G_MISS_CHAR)
563: THEN
564: IF G_DEBUG='Y' THEN
565: AHL_DEBUG_PUB.debug('Getting Condition for['||p_x_ahl_mtltxn_rec.Condition_Desc||']');
566: END IF;
567: OPEN CONDITION_CUR(p_x_ahl_mtltxn_rec.Condition_Desc);
568: FETCH CONDITION_CUR INTO p_x_ahl_mtltxn_rec.Condition;
569:

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

578: END IF;
579:
580:
581: IF G_DEBUG='Y' THEN
582: AHL_DEBUG_PUB.debug('after the CONDITION select['||p_x_ahl_mtltxn_rec.CONDITION||']');
583: END IF;
584:
585: END IF;
586:

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

685: --Convert UOM DESC into UOM
686: IF (p_x_ahl_mtltxn_rec.Uom IS NULL
687: OR p_x_ahl_mtltxn_rec.Uom = FND_API.G_MISS_CHAR) THEN
688: IF G_DEBUG='Y' THEN
689: AHL_DEBUG_PUB.debug('Converting UOM['||p_x_ahl_mtltxn_rec.Uom_Desc||']');
690:
691: END IF;
692: IF (p_x_ahl_mtltxn_rec.Uom_Desc IS NULL
693: OR p_x_ahl_mtltxn_rec.Uom_Desc = FND_API.G_MISS_CHAR) THEN

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

707: END IF;
708:
709: END IF;
710: IF G_DEBUG='Y' THEN
711: AHL_DEBUG_PUB.debug('after UOM select');
712:
713: END IF;
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN

Line 884: AHL_DEBUG_PUB.enable_debug;

880: dumpInput(p_x_ahl_mtltxn_tbl);
881:
882:
883: IF G_DEBUG='Y' THEN
884: AHL_DEBUG_PUB.enable_debug;
885: AHL_DEBUG_PUB.debug('Entered ahl mtl api');
886: END IF;
887:
888: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN

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

881:
882:
883: IF G_DEBUG='Y' THEN
884: AHL_DEBUG_PUB.enable_debug;
885: AHL_DEBUG_PUB.debug('Entered ahl mtl api');
886: END IF;
887:
888: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
889:

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

914: l_error := true;
915: ELSE
916: */
917: IF G_DEBUG='Y' THEN
918: AHL_DEBUG_PUB.debug('calling Convert_Name_To_Id for i=['||i||']');
919: END IF;
920:
921: -- This procedure will convert name parameters into IDs in the input
922: Convert_Name_To_Id(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),

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

934: END IF;
935:
936:
937: IF G_DEBUG='Y' THEN
938: AHL_DEBUG_PUB.debug('calling Validate_Txn_rec for i=['||i||']');
939: END IF;
940:
941: --Call Validate_Txn(Ahl_Mtltxn_rec) to validate the material txn record.
942: Validate_Txn_rec(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),

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

946: x_msg_count => x_msg_Count,
947: x_eam_item_type_id => l_eam_item_type_id );
948:
949: IF G_DEBUG='Y' THEN
950: AHL_DEBUG_PUB.debug('After calling Validate_Txn_rec');
951: END IF;
952:
953: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
954: l_error := true;

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

953: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
954: l_error := true;
955:
956: IF G_DEBUG='Y' THEN
957: AHL_DEBUG_PUB.debug('Error in Validation');
958: END IF;
959: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961:

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

959: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961:
962: IF G_DEBUG='Y' THEN
963: AHL_DEBUG_PUB.debug('Unexpected error in Validate_Txn_rec');
964: END IF;
965: ELSE
966: l_instance_id_tbl(i) := l_item_instance_id;
967: l_eam_item_type_id_tbl(i) := l_eam_item_type_id;

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

1018: x_ahl_sch_mtl_id => l_sch_Mtl_Id);
1019:
1020:
1021: IF G_DEBUG='Y' THEN
1022: AHL_DEBUG_PUB.debug('after Sch_Mtl insert api');
1023: END IF;
1024:
1025: IF (x_return_status = FND_API.G_RET_STS_ERROR
1026: OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1038: --call Insert_Interface_Temp API to insert data into transaction
1039: --temp tables. F
1040:
1041: IF G_DEBUG='Y' THEN
1042: AHL_DEBUG_PUB.debug('Calling Insert_Txn_Intf...');
1043: END IF;
1044:
1045: -- Added l_eam_item_type_id_tbl(i) for FP ER# 6310766.
1046: Insert_Mtl_Txn_Intf(p_x_ahl_mtl_txn_rec => p_x_ahl_mtltxn_tbl(i),

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

1052: );
1053:
1054: l_txn_Id_Tbl(i) := l_Txn_tmp_Id;
1055: IF G_DEBUG='Y' THEN
1056: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');
1057: AHL_DEBUG_PUB.debug('Ahl_mtltxn_id'||p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id);
1058: END IF;
1059:
1060:

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

1053:
1054: l_txn_Id_Tbl(i) := l_Txn_tmp_Id;
1055: IF G_DEBUG='Y' THEN
1056: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');
1057: AHL_DEBUG_PUB.debug('Ahl_mtltxn_id'||p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id);
1058: END IF;
1059:
1060:
1061: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: -- Now process the interface records
1074: IF G_DEBUG='Y' THEN
1075: AHL_DEBUG_PUB.debug('Before calling wip_mtlInterfaceProc_pub.processInterface....');
1076: END IF;
1077:
1078: wip_mtlInterfaceProc_pub.processInterface(
1079: p_txnHdrId => l_Txn_Header_Id,

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

1084: mo_global.init('AHL');
1085:
1086: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1087: IF G_DEBUG='Y' THEN
1088: AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1089: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1090: END IF;
1091: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;

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

1085:
1086: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1087: IF G_DEBUG='Y' THEN
1088: AHL_DEBUG_PUB.debug('wip_mtlInterfaceProc_pub.processInterface....errored');
1089: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
1090: END IF;
1091: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:

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

1107: IF(Txn_Error_cur%FOUND AND (l_error_code IS NOT NULL
1108: OR trim(l_error_code) = '')) THEN
1109:
1110: IF G_DEBUG='Y' THEN
1111: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
1112: END IF;
1113:
1114: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
1115: FND_MESSAGE.Set_Token('MSG',l_error_msg);

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

1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSE
1183:
1184: IF G_DEBUG='Y' THEN
1185: AHL_DEBUG_PUB.debug('l_completed_quantity=['||l_completed_quantity||']');
1186: END IF;
1187:
1188: -- Tamal: Bug #4095376: Begin
1189: -- Retrieving quantity, then converting to primary uom, etc have been moved out of this ELSE loop

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

1232: IF (p_x_ahl_mtltxn_tbl(i).locator_segments IS NOT NULL AND
1233: p_x_ahl_mtltxn_tbl(i).locator_id IS NULL) THEN
1234:
1235: IF G_DEBUG='Y' THEN
1236: AHL_DEBUG_PUB.DEBUG('Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
1237: END IF;
1238:
1239: l_valid_flag := fnd_flex_keyval.validate_segs(
1240: operation => 'FIND_COMBINATION'

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

1255: IF(p_x_ahl_mtltxn_tbl(i).condition = FND_API.G_MISS_NUM) THEN
1256: p_x_ahl_mtltxn_tbl(i).condition := NULL;
1257: END IF;
1258: IF G_DEBUG='Y' THEN
1259: AHL_DEBUG_PUB.debug('RECEPIENT_ID'||p_x_ahl_mtltxn_tbl(i).RECEPIENT_ID);
1260: END IF;
1261:
1262: Insert_Mtl_Txn_Row(p_x_ahl_mtltxn_rec => p_x_ahl_mtltxn_tbl(i),
1263: p_material_Transaction_Id => NULL,

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

1269: x_ahl_mtl_txn_id => l_x_Mtl_Txn_Id);
1270:
1271:
1272: IF G_DEBUG='Y' THEN
1273: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1274: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1275: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1276: END IF;
1277:

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

1270:
1271:
1272: IF G_DEBUG='Y' THEN
1273: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1274: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1275: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1276: END IF;
1277:
1278:

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

1271:
1272: IF G_DEBUG='Y' THEN
1273: AHL_DEBUG_PUB.debug('after mtl_Txn insert api');
1274: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call ret status=['||x_return_status||']');
1275: AHL_DEBUG_PUB.debug('after mtl_Txn insert api call msg=['||x_msg_data||']');
1276: END IF;
1277:
1278:
1279: IF (x_return_status = FND_API.G_RET_STS_ERROR

Line 1301: AHL_DEBUG_PUB.debug('after PartsChange Update api');

1297: x_return_status => x_return_status
1298: );
1299:
1300: IF G_DEBUG='Y' THEN
1301: AHL_DEBUG_PUB.debug('after PartsChange Update api');
1302: AHL_DEBUG_PUB.debug('after PartsChange Update api call ret status=['||x_return_status||']');
1303: END IF;
1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1298: );
1299:
1300: IF G_DEBUG='Y' THEN
1301: AHL_DEBUG_PUB.debug('after PartsChange Update api');
1302: AHL_DEBUG_PUB.debug('after PartsChange Update api call ret status=['||x_return_status||']');
1303: END IF;
1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;

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

1315:
1316: -- END of if which checks the count of transactions created
1317:
1318: IF (G_DEBUG='Y') THEN
1319: AHL_DEBUG_PUB.debug('Unservicable profile value:' || G_AHL_UNSERVICEABLE_CONDITION);
1320: AHL_DEBUG_PUB.debug('MRB profile value:' || G_AHL_MRB_CONDITION);
1321: END IF;
1322:
1323: IF (l_txn_Id_Tbl.COUNT > 0) THEN

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

1316: -- END of if which checks the count of transactions created
1317:
1318: IF (G_DEBUG='Y') THEN
1319: AHL_DEBUG_PUB.debug('Unservicable profile value:' || G_AHL_UNSERVICEABLE_CONDITION);
1320: AHL_DEBUG_PUB.debug('MRB profile value:' || G_AHL_MRB_CONDITION);
1321: END IF;
1322:
1323: IF (l_txn_Id_Tbl.COUNT > 0) THEN
1324: -- THis loop is for creating service request. Since

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

1328: --j:=1;
1329: j := l_txn_Id_Tbl.FIRST;
1330: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1331: IF G_DEBUG='Y' THEN
1332: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1333: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1334: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1335: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1336: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);

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

1329: j := l_txn_Id_Tbl.FIRST;
1330: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1331: IF G_DEBUG='Y' THEN
1332: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1333: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1334: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1335: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1336: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1337:

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

1330: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1331: IF G_DEBUG='Y' THEN
1332: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1333: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1334: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1335: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1336: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1337:
1338: END IF;

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

1331: IF G_DEBUG='Y' THEN
1332: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1333: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1334: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1335: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1336: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1337:
1338: END IF;
1339:

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

1332: AHL_DEBUG_PUB.debug('Processing SR for item:' || p_x_ahl_mtltxn_tbl(i).inventory_item_id);
1333: AHL_DEBUG_PUB.debug('Condition is:' || p_x_ahl_mtltxn_tbl(i).Condition);
1334: AHL_DEBUG_PUB.debug('Disposition ID is:' || p_x_ahl_mtltxn_tbl(i).disposition_id);
1335: AHL_DEBUG_PUB.debug('Instance ID is:' || l_instance_id_tbl(i));
1336: AHL_DEBUG_PUB.debug('Create WO Option is:' || p_x_ahl_mtltxn_tbl(i).create_wo_option);
1337:
1338: END IF;
1339:
1340: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then

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

1362:
1363: END LOOP;
1364: -- added for FP bug# 5903318.
1365: IF G_DEBUG='Y' THEN
1366: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1367: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1368: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1369: END IF;
1370:

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

1363: END LOOP;
1364: -- added for FP bug# 5903318.
1365: IF G_DEBUG='Y' THEN
1366: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1367: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1368: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1369: END IF;
1370:
1371:

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

1364: -- added for FP bug# 5903318.
1365: IF G_DEBUG='Y' THEN
1366: AHL_DEBUG_PUB.debug('Will call service request API if there are srvc request to be created');
1367: AHL_DEBUG_PUB.debug('srvc req rec count=['||to_Char(l_x_sr_rec_tbl.COUNT)||']');
1368: AHL_DEBUG_PUB.debug('mr tbl count=['||to_Char(l_mr_asso_tbl.COUNT)||']');
1369: END IF;
1370:
1371:
1372: IF(l_x_sr_rec_tbl.COUNT > 0) THEN

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

1380: p_x_sr_task_tbl =>l_x_sr_rec_tbl,
1381: --Parameter added for bug# 6086419.
1382: p_x_mr_asso_tbl => l_mr_asso_tbl);
1383: IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1385: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1386: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1387: END IF;
1388:

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

1381: --Parameter added for bug# 6086419.
1382: p_x_mr_asso_tbl => l_mr_asso_tbl);
1383: IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1385: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1386: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1387: END IF;
1388:
1389: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1382: p_x_mr_asso_tbl => l_mr_asso_tbl);
1383: IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.debug('after the srvc req api call ret status=['||x_return_status||']');
1385: AHL_DEBUG_PUB.debug('after the srvc req api call x_msg_count=['||x_msg_count||']');
1386: AHL_DEBUG_PUB.debug('after the srvc req api call msg=['||x_msg_data||']');
1387: END IF;
1388:
1389: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1390: RAISE FND_API.G_EXC_ERROR;

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

1394:
1395: -- ANd now update the nonroutine workorder id in the workorder_mtl_Txns table
1396: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1399: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1400: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1401: END IF;
1402:

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

1395: -- ANd now update the nonroutine workorder id in the workorder_mtl_Txns table
1396: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1399: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1400: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1401: END IF;
1402:
1403: -- update non-routine workorder id.

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

1396: FOR j IN l_x_sr_rec_tbl.FIRST..l_x_sr_rec_tbl.LAST LOOP
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Incident_id[' || j || ']=['||l_x_sr_rec_tbl(j).Incident_id||']');
1399: AHL_DEBUG_PUB.debug('l_x_sr_rec_tbl.Visit_task_id[' || j || ']=['||l_x_sr_rec_tbl(j).Visit_task_id||']');
1400: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1401: END IF;
1402:
1403: -- update non-routine workorder id.
1404: UPDATE AHL_WORKORDER_MTL_TXNS

Line 1521: AHL_DEBUG_PUB.enable_debug;

1517: l_quantity NUMBER;
1518: BEGIN
1519:
1520: IF G_DEBUG='Y' THEN
1521: AHL_DEBUG_PUB.enable_debug;
1522: 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);
1523: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1524: END IF;
1525: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(

Line 1522: 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);

1518: BEGIN
1519:
1520: IF G_DEBUG='Y' THEN
1521: AHL_DEBUG_PUB.enable_debug;
1522: 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);
1523: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1524: END IF;
1525: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(
1526: X_ROWID => l_x_row_id,

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

1519:
1520: IF G_DEBUG='Y' THEN
1521: AHL_DEBUG_PUB.enable_debug;
1522: 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);
1523: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1524: END IF;
1525: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(
1526: X_ROWID => l_x_row_id,
1527: X_WORKORDER_MTL_TXN_ID => x_ahl_mtl_txn_id,

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

1570: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1571: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1572:
1573: IF G_DEBUG='Y' THEN
1574: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);
1575: END IF;
1576:
1577: /*
1578:

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

1580: WHEN OTHERS THEN
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: IF G_DEBUG='Y'
1583: THEN
1584: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn' || SQLCODE);
1585: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1586: END IF;
1587:
1588: */

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

1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: IF G_DEBUG='Y'
1583: THEN
1584: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn' || SQLCODE);
1585: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1586: END IF;
1587:
1588: */
1589: END Insert_Mtl_Txn_Row;

Line 1937: AHL_DEBUG_PUB.enable_debug;

1933:
1934: x_return_status := FND_API.G_RET_STS_SUCCESS;
1935:
1936: IF G_DEBUG='Y' THEN
1937: AHL_DEBUG_PUB.enable_debug;
1938: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
1939: END IF;
1940:
1941: -- Validate transaction type id(should be one of wip conponent issue or return

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

1934: x_return_status := FND_API.G_RET_STS_SUCCESS;
1935:
1936: IF G_DEBUG='Y' THEN
1937: AHL_DEBUG_PUB.enable_debug;
1938: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
1939: END IF;
1940:
1941: -- Validate transaction type id(should be one of wip conponent issue or return
1942: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND

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

1947: END IF;
1948: -- transaction quantity should be +ve always. Negative quantities are not
1949: -- supported currently.
1950: IF G_DEBUG='Y' THEN
1951: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtltxn_rec.Quantity)||']');
1952: END IF;
1953:
1954: IF(nvl(p_x_ahl_mtltxn_rec.Quantity,0) <= 0) THEN
1955: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

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

1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: END IF;
1960:
1961: IF G_DEBUG='Y' THEN
1962: AHL_DEBUG_PUB.debug('Validating Wip_Entity_id['
1963: ||to_char(p_x_ahl_mtltxn_rec.Organization_ID)||','
1964: ||to_Char(p_x_ahl_mtltxn_rec.Workorder_ID)
1965: ||','||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
1966:

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

1972: FETCH AHL_WIPJOB_CUR INTO l_job_status, l_visit_id, l_inv_locator_id,
1973: l_project_id, l_project_task_id, l_subinventory_code;
1974: IF(AHL_WIPJOB_CUR%NOTFOUND) THEN
1975: IF G_DEBUG='Y' THEN
1976: AHL_DEBUG_PUB.debug('JOB validation failed');
1977: END IF;
1978: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_WIP_ENTITY');
1979: if(p_x_ahl_mtltxn_rec.Wip_Entity_Id = FND_API.G_MISS_NUM) THEN
1980: p_x_ahl_mtltxn_rec.Wip_Entity_Id := NULL;

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

1993: END IF;
1994: --
1995:
1996: IF G_DEBUG='Y' THEN
1997: AHL_DEBUG_PUB.debug('JOB validation success['||l_job_status||']');
1998: END IF;
1999: IF(l_job_status <> C_JOB_RELEASED
2000: AND l_job_status <> C_JOB_PENDING_QA
2001: AND l_job_status <> C_JOB_COMPLETE

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

2008: END IF;
2009: CLOSE AHL_WIPJOB_CUR;
2010:
2011: IF G_DEBUG='Y' THEN
2012: AHL_DEBUG_PUB.debug('Validating Workorder operation Id ['||to_Char(p_x_ahl_mtltxn_rec.Workorder_ID)||','
2013: ||to_Char(p_x_ahl_mtltxn_rec.Operation_Seq_Num)||','||to_Char(p_x_ahl_mtltxn_rec.Workorder_Operation_Id)||']');
2014: END IF;
2015:
2016:

Line 2033: 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)||']');

2029: END IF;
2030: CLOSE AHL_WORKORDER_OPER_CUR;
2031:
2032: IF G_DEBUG='Y' THEN
2033: 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)||']');
2034: END IF;
2035:
2036: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE
2037: and p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id is null

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

2092: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
2093: AND (p_x_ahl_mtltxn_rec.move_to_project_flag = 'Y') THEN
2094: IF (l_inv_locator_id IS NOT NULL) THEN
2095: IF G_DEBUG='Y' THEN
2096: AHL_DEBUG_PUB.debug('Defaulting from Visit Locator['||l_inv_locator_id||','|| l_project_id ||',' || l_project_task_id || ']');
2097: END IF;
2098: PJM_PROJECT_LOCATOR.Get_DefaultProjectLocator(
2099: p_organization_id => p_x_ahl_mtltxn_rec.organization_id,
2100: p_locator_id => l_inv_locator_id,

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

2121:
2122: -- Added Post 11.5.10: Default subinventory.
2123: --
2124: IF G_DEBUG='Y' THEN
2125: AHL_DEBUG_PUB.debug('Defaulting SubInv/Locator['||p_x_ahl_mtltxn_rec.Subinventory_Name||',' ||
2126: p_x_ahl_mtltxn_rec.Locator_id || ']');
2127: END IF;
2128: OPEN wip_params_cur(p_x_ahl_mtltxn_rec.Organization_ID);
2129: FETCH wip_params_cur INTO l_def_supply_subinv, l_def_supply_locator_id;

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

2149: CLOSE wip_params_cur;
2150:
2151:
2152: IF G_DEBUG='Y' THEN
2153: AHL_DEBUG_PUB.debug('Validating serial num(control, srl_num)['||to_Char(l_serial_Control)||','||p_x_ahl_mtltxn_rec.Serial_Number||']');
2154: END IF;
2155:
2156: -- If the item is of serial controlled check if the serial numebr is null
2157: IF((p_x_ahl_mtltxn_rec.Serial_Number IS NULL

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

2175: END IF;
2176:
2177: -- Added for FP bug# 5903318.
2178: IF G_DEBUG='Y' THEN
2179: AHL_DEBUG_PUB.debug('Validating Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2180: END IF;
2181:
2182: -- Validate Create WO Option lookup code.
2183: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

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

2203: CLOSE create_wo_cur;
2204: END IF;
2205:
2206: IF G_DEBUG='Y' THEN
2207: AHL_DEBUG_PUB.debug('After Defaulting Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2208: END IF;
2209:
2210: -- Check if create_wo_option is valid based on l_serial_Control.
2211: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL ) THEN

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

2221: END IF;
2222: -- End changes for FP bug# 5903318.
2223:
2224: IF G_DEBUG='Y' THEN
2225: AHL_DEBUG_PUB.debug('Validating lot num(control, srl_num)['||to_Char(l_lot_Control)||','||p_x_ahl_mtltxn_rec.serial_Number||']');
2226: END IF;
2227:
2228: -- If the item is of lot controlled check if the lot number is null
2229: IF((p_x_ahl_mtltxn_rec.Lot_Number IS NULL

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

2268: /****************************************************************
2269: This vlaidation happens in the MTL API, so we do not need it here
2270:
2271: IF G_DEBUG='Y' THEN
2272: AHL_DEBUG_PUB.debug('Validating locator(control, srl_num)['||to_Char(l_location_Control)||','||to_Char(p_x_ahl_mtltxn_rec.Locator_Id)||']');
2273:
2274: END IF;
2275:
2276: IF(p_x_ahl_mtltxn_rec.Locator_Id IS NULL

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

2304: CLOSE AHL_LOCATOR_CUR;
2305: END IF;
2306:
2307: IF G_DEBUG='Y' THEN
2308: AHL_DEBUG_PUB.debug('Validating revision['||p_x_ahl_mtltxn_rec.Revision||']');
2309: END IF;
2310:
2311: -- Tamal: Bug #4091154: Begin
2312: -- If item is revision-controlled, then verify revision is NOT NULL and is valid

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

2379: END IF;
2380: CLOSE Condition_Cur;
2381:
2382: IF G_DEBUG='Y' THEN
2383: AHL_DEBUG_PUB.debug('Validating Condition/Subinv['||p_x_ahl_mtltxn_rec.Condition||','||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2384: END IF;
2385:
2386: -- Check if the Condition matches the Sub inventory status
2387: -- in case of unserviceable and MRB

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

2394: END IF;
2395:
2396: ELSE
2397: IF G_DEBUG='Y' THEN
2398: AHL_DEBUG_PUB.debug('Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2399: END IF;
2400:
2401: -- Sub inventory validation
2402: AHL_PRD_UTIL_PKG.Validate_Material_Status(p_x_ahl_mtltxn_rec.Organization_Id,

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

2403: p_x_ahl_mtltxn_rec.Subinventory_Name,
2404: NULL,
2405: l_return_Status);
2406: IF G_DEBUG='Y' THEN
2407: AHL_DEBUG_PUB.debug('After Validating Subinv['||p_x_ahl_mtltxn_rec.Subinventory_Name||','||x_return_Status || ']');
2408: END IF;
2409:
2410: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2411: x_return_status := FND_API.G_RET_STS_ERROR;

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

2422: IF (Is_Item_Trackable(p_x_ahl_mtltxn_rec.Organization_Id,
2423: p_x_ahl_mtltxn_rec.Inventory_Item_Id)) THEN
2424:
2425: IF G_DEBUG='Y' THEN
2426: AHL_DEBUG_PUB.debug('selecting wip location id..');
2427: END IF;
2428: -- R12: Fix for bug# 5221513
2429: -- IB team have asked us to remove the location validation to fix the issue.
2430: /*

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

2436: x_return_status := FND_API.G_RET_STS_ERROR;
2437: END IF;
2438: CLOSE CSI_LOCATION_CUR;
2439: IF G_DEBUG='Y' THEN
2440: AHL_DEBUG_PUB.debug('wip location id['||to_char(l_wip_location)||']');
2441: END IF;
2442: */
2443:
2444: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NULL

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

2481: END IF;
2482:
2483: BEGIN
2484: IF G_DEBUG='Y' THEN
2485: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/subinv['
2486: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2487: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2488:
2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');

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

2485: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/subinv['
2486: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2487: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2488:
2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2490: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2491: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2492: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2493: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');

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

2486: ||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2487: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2488:
2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2490: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2491: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2492: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2493: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2494: END IF;

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

2487: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||']');
2488:
2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2490: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2491: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2492: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2493: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2494: END IF;
2495: -- R12: Fix for bug# 5221513

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

2488:
2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2490: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2491: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2492: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2493: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2494: END IF;
2495: -- R12: Fix for bug# 5221513
2496: -- remove WIP location validation.

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

2489: AHL_DEBUG_PUB.debug('['||p_x_ahl_mtltxn_rec.Subinventory_Name||']');
2490: AHL_DEBUG_PUB.debug('[Length of sql string:'||length(l_sql)||']');
2491: AHL_DEBUG_PUB.debug('[1:'||substr(l_sql,1,240)||']');
2492: AHL_DEBUG_PUB.debug('[2:'||substr(l_sql,241,240)||']');
2493: AHL_DEBUG_PUB.debug('[3:'||substr(l_sql,481,240)||']');
2494: END IF;
2495: -- R12: Fix for bug# 5221513
2496: -- remove WIP location validation.
2497: IF (l_revision_flag = TRUE) AND (l_lot_flag = TRUE)

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

2539: ELSE
2540: -- Serialized item...
2541:
2542: IF G_DEBUG='Y' THEN
2543: AHL_DEBUG_PUB.debug('Validating instance:item/wipjob/srl['||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||','
2544: ||to_Char(p_x_ahl_mtltxn_rec.Wip_Entity_Id)||','
2545: ||p_x_ahl_mtltxn_rec.Serial_Number||']');
2546: END IF;
2547:

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

2627: IF(p_x_ahl_mtltxn_rec.Problem_Code IS NOT NULL
2628: AND p_x_ahl_mtltxn_rec.Problem_Code <> FND_API.G_MISS_CHAR) THEN
2629:
2630: IF G_DEBUG='Y' THEN
2631: AHL_DEBUG_PUB.debug('Validating problem code['||p_x_ahl_mtltxn_rec.Problem_Code||']');
2632: END IF;
2633:
2634: OPEN PROBLEM_CODE_LKUP_CUR(p_x_ahl_mtltxn_rec.Problem_Code) ;
2635: FETCH PROBLEM_CODE_LKUP_CUR INTO l_count;

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

2665: --If the serial number is not null and the quantity is <>1 return the
2666: --Error AHL_INVALID_SRL_QTY
2667:
2668: IF G_DEBUG='Y' THEN
2669: AHL_DEBUG_PUB.debug('Validating serial num/qty['||p_x_ahl_mtltxn_rec.quantity||']');
2670: END IF;
2671:
2672: IF ((p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
2673: (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND

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

2703: END IF; -- uom code.
2704: END IF; -- serial num.
2705:
2706: IF G_DEBUG='Y' THEN
2707: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtltxn_rec.Serial_Number||']');
2708: END IF;
2709:
2710: -- For issue txn with serial number, validate if subinventory and locator match
2711: -- that from mtl_serial_numbers.

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

2719: FETCH mtl_srl_num_csr INTO l_curr_subinventory_code, l_curr_locator_id;
2720: IF (mtl_srl_num_csr%FOUND) THEN
2721:
2722: IF G_DEBUG='Y' THEN
2723: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');
2724: END IF;
2725:
2726: IF (p_x_ahl_mtltxn_rec.subinventory_Name IS NOT NULL AND
2727: p_x_ahl_mtltxn_rec.subinventory_Name <> FND_API.G_MISS_CHAR AND

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

2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: END IF;
2736:
2737: IF G_DEBUG='Y' THEN
2738: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtltxn_rec.subinventory_Name||']');
2739: END IF;
2740:
2741: IF (p_x_ahl_mtltxn_rec.locator_id IS NOT NULL AND
2742: p_x_ahl_mtltxn_rec.locator_id <> FND_API.G_MISS_NUM AND

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

2761: CLOSE mtl_srl_num_csr;
2762: END IF;
2763:
2764: IF G_DEBUG='Y' THEN
2765: AHL_DEBUG_PUB.debug('Validating transaction date['||p_x_ahl_mtltxn_rec.transaction_date||']');
2766: END IF;
2767:
2768: -- Validate transaction date.
2769: IF (p_x_ahl_mtltxn_rec.transaction_date IS NULL OR

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

2779: ELSE
2780: IF (p_x_ahl_mtltxn_rec.transaction_date > SYSDATE) THEN
2781:
2782: IF G_DEBUG='Y' THEN
2783: AHL_DEBUG_PUB.debug('Error in txn date');
2784: END IF;
2785: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_DATE');
2786: FND_MESSAGE.Set_Token('DATE',p_x_ahl_mtltxn_rec.transaction_date);
2787: FND_MSG_PUB.ADD;

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

2803: FND_MSG_PUB.ADD;
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: ELSE
2806: IF G_DEBUG='Y' THEN
2807: AHL_DEBUG_PUB.debug('transaction date['||to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-mon-yyyy hh24:mi:ss') ||']');
2808: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
2809: END IF;
2810: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
2811: IF G_DEBUG='Y' THEN

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

2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: ELSE
2806: IF G_DEBUG='Y' THEN
2807: AHL_DEBUG_PUB.debug('transaction date['||to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-mon-yyyy hh24:mi:ss') ||']');
2808: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
2809: END IF;
2810: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
2811: IF G_DEBUG='Y' THEN
2812: AHL_DEBUG_PUB.debug('release date is greater than transaction date');

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

2808: AHL_DEBUG_PUB.debug('workorder release date['||to_char(l_workorder_released_date,'dd-mon-yyyy hh24:mi:ss') ||']');
2809: END IF;
2810: IF(l_workorder_released_date > p_x_ahl_mtltxn_rec.transaction_date)THEN
2811: IF G_DEBUG='Y' THEN
2812: AHL_DEBUG_PUB.debug('release date is greater than transaction date');
2813: END IF;
2814: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXN_REL_DT');
2815: FND_MESSAGE.Set_Token('TXNS_DATE',to_char(p_x_ahl_mtltxn_rec.transaction_date,'dd-MON-yyyy hh24:mi:ss'));
2816: FND_MESSAGE.Set_Token('REL_DATE',to_char(l_workorder_released_date,'dd-MON-yyyy hh24:mi:ss'));

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

2861: );
2862: END IF;
2863:
2864: IF G_DEBUG='Y' THEN
2865: AHL_DEBUG_PUB.debug('after validations api ret_status['||x_return_status||']');
2866:
2867: END IF;
2868:
2869:

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

2930: OPEN ACCT_PERIOD_CUR(p_x_ahl_mtltxn_rec.Organization_Id);
2931: FETCH ACCT_PERIOD_CUR INTO l_mmtt_rec.ACCT_PERIOD_ID;
2932: IF(ACCT_PERIOD_CUR%NOTFOUND) THEN
2933: IF G_DEBUG='Y' THEN
2934: AHL_DEBUG_PUB.debug('Did not find the account period for org('||p_x_ahl_mtltxn_rec.Organization_Id||')');
2935:
2936: END IF;
2937: CLOSE ACCT_PERIOD_CUR;
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2942: OPEN TRX_ACTION_CUR(p_x_ahl_mtltxn_rec.Transaction_Type_Id);
2943: FETCH TRX_ACTION_CUR INTO l_txn_action, l_txn_source_type;
2944: IF(TRX_ACTION_CUR%NOTFOUND) THEN
2945: IF G_DEBUG='Y' THEN
2946: AHL_DEBUG_PUB.debug('Did not find the Txn Type');
2947:
2948: END IF;
2949: CLOSE TRX_ACTION_CUR;
2950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3076: END IF;
3077: END IF;
3078:
3079: IF G_DEBUG='Y' THEN
3080: AHL_DEBUG_PUB.debug('inserting the mmtt..');
3081: END IF;
3082:
3083: inv_util.insert_mmtt(p_api_version => 1,
3084: p_mmtt_rec =>l_mmtt_rec,

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

3088: x_msg_count =>x_msg_count,
3089: x_msg_data => x_msg_data);
3090:
3091: IF G_DEBUG='Y' THEN
3092: AHL_DEBUG_PUB.debug('inserted in mmtt..ret_status['||x_return_status||']');
3093: END IF;
3094: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3095: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3096: FND_MESSAGE.Set_Token('MSG',x_msg_data);

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

3136: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3137: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3138:
3139: IF G_DEBUG='Y' THEN
3140: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3141: END IF;
3142:
3143: inv_util.insert_mtlt(p_api_version => 1,
3144: p_mtlt_rec =>l_mtlt_rec,

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

3145: x_return_status => x_return_status,
3146: x_msg_count =>x_msg_count,
3147: x_msg_data => x_msg_data);
3148: IF G_DEBUG='Y' THEN
3149: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3150: END IF;
3151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3152: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3153: FND_MESSAGE.Set_Token('MSG',x_msg_data);

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

3154: FND_MSG_PUB.ADD;
3155: RAISE FND_API.G_EXC_ERROR;
3156: END IF;
3157: IF G_DEBUG='Y' THEN
3158: AHL_DEBUG_PUB.debug('inserting in msnt..');
3159:
3160: END IF;
3161: inv_util.insert_msnt(p_api_version => 1,
3162: p_msnt_rec =>l_msnt_rec,

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

3164: x_msg_count =>x_msg_count,
3165: x_msg_data => x_msg_data);
3166:
3167: IF G_DEBUG='Y' THEN
3168: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');
3169:
3170: END IF;
3171:
3172: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

3190: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3191: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3192:
3193: IF G_DEBUG='Y' THEN
3194: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3195:
3196: END IF;
3197: inv_util.insert_mtlt(p_api_version => 1,
3198: p_mtlt_rec =>l_mtlt_rec,

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

3199: x_return_status => x_return_status,
3200: x_msg_count =>x_msg_count,
3201: x_msg_data => x_msg_data);
3202: IF G_DEBUG='Y' THEN
3203: AHL_DEBUG_PUB.debug('inserted in mtlt..ret_status['||x_return_status||']');
3204:
3205: END IF;
3206: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3207: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

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

3222: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3223: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3224:
3225: IF G_DEBUG='Y' THEN
3226: AHL_DEBUG_PUB.debug('inserting in msnt..');
3227:
3228: END IF;
3229:
3230: inv_util.insert_msnt(p_api_version => 1,

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

3232: x_return_status => x_return_status,
3233: x_msg_count =>x_msg_count,
3234: x_msg_data => x_msg_data);
3235: IF G_DEBUG='Y' THEN
3236: AHL_DEBUG_PUB.debug('inserted in msnt..ret_status['||x_return_status||']');
3237:
3238: END IF;
3239:
3240: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

3319:
3320: BEGIN
3321:
3322: IF G_DEBUG='Y' THEN
3323: AHL_DEBUG_PUB.debug('Entered Insert_Sch_Mtl_Row');
3324:
3325: END IF;
3326: OPEN Workop_Det_Cur( p_mtl_txn_Rec.Workorder_Id);
3327: FETCH Workop_Det_Cur INTO l_Visit_Id,l_visit_task_Id,l_project_id,l_project_Task_id;

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

3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334: CLOSE Workop_Det_Cur;
3335: IF G_DEBUG='Y' THEN
3336: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');

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

3333: END IF;
3334: CLOSE Workop_Det_Cur;
3335: IF G_DEBUG='Y' THEN
3336: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3341: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');

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

3334: CLOSE Workop_Det_Cur;
3335: IF G_DEBUG='Y' THEN
3336: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3341: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3342:

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

3335: IF G_DEBUG='Y' THEN
3336: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3341: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3342:
3343: END IF;

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

3336: AHL_DEBUG_PUB.debug('Selected the work order paramters');
3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3341: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3342:
3343: END IF;
3344:

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

3337: AHL_DEBUG_PUB.debug('l_Visit_Id['||l_Visit_Id||']');
3338: AHL_DEBUG_PUB.debug('l_visit_task_Id['||l_visit_task_Id||']');
3339: AHL_DEBUG_PUB.debug('l_project_id['||l_project_id||']');
3340: AHL_DEBUG_PUB.debug('l_project_Task_id['||l_project_Task_id||']');
3341: AHL_DEBUG_PUB.debug('p_mtl_txn_Rec.Workorder_Operation_Id['||p_mtl_txn_Rec.Workorder_Operation_Id||']');
3342:
3343: END IF;
3344:
3345: OPEN Item_Desc_Cur( p_mtl_txn_Rec.Organization_id, p_mtl_txn_Rec.Inventory_Item_Id);

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

3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;
3354: CLOSE Item_Desc_Cur;
3355: IF G_DEBUG='Y' THEN
3356: AHL_DEBUG_PUB.debug('Selected the Item description');
3357:
3358: END IF;
3359:
3360: -- Get Primary UOM for the item.

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

3405: --Material_Tbl(0).Req_Material_Rec_Type :=
3406:
3407:
3408: IF G_DEBUG='Y' THEN
3409: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3410:
3411: END IF;
3412: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3413: p_x_req_material_tbl => Material_Tbl,

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

3417: x_return_status => x_return_status,
3418: x_msg_count => x_msg_count,
3419: x_msg_data => x_msg_data);
3420: IF G_DEBUG='Y' THEN
3421: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3422:
3423: END IF;
3424: IF G_DEBUG='Y' THEN
3425: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');

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

3421: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3422:
3423: END IF;
3424: IF G_DEBUG='Y' THEN
3425: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');
3426: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');
3427:
3428: END IF;
3429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

3422:
3423: END IF;
3424: IF G_DEBUG='Y' THEN
3425: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');
3426: AHL_DEBUG_PUB.debug('x_msg_data['||x_msg_data||']');
3427:
3428: END IF;
3429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3430: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SCHMTLAPI_ERROR');

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

3485: p_srvc_rec.instance_quantity := p_x_ahl_mtltxn_rec.quantity;
3486:
3487:
3488: IF G_DEBUG='Y' THEN
3489: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');

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

3486:
3487:
3488: IF G_DEBUG='Y' THEN
3489: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');

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

3487:
3488: IF G_DEBUG='Y' THEN
3489: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');

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

3488: IF G_DEBUG='Y' THEN
3489: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');

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

3489: AHL_DEBUG_PUB.debug('p_srvc_rec.SUMMARY['||p_srvc_rec.SUMMARY||']');
3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
3497: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');

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

3490: AHL_DEBUG_PUB.debug('PROBLEM_CODE['||p_srvc_rec.PROBLEM_CODE||']');
3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
3497: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
3498:

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

3491: AHL_DEBUG_PUB.debug('p_srvc_rec.VISIT_ID['||p_srvc_rec.VISIT_ID||']');
3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
3497: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
3498:
3499: END IF;

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

3492: AHL_DEBUG_PUB.debug('p_srvc_rec.INSTANCE_ID['||p_srvc_rec.INSTANCE_ID||']');
3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
3497: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
3498:
3499: END IF;
3500:

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

3493: AHL_DEBUG_PUB.debug('p_srvc_rec.ORIGINATING_WO_ID['||p_srvc_rec.ORIGINATING_WO_ID||']');
3494: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Create_flag['||p_srvc_rec.WO_Create_flag||']');
3495: AHL_DEBUG_PUB.debug('p_srvc_rec.WO_Release_flag['||p_srvc_rec.WO_Release_flag||']');
3496: AHL_DEBUG_PUB.debug('p_srvc_rec.instance_quantity['||p_srvc_rec.instance_quantity||']');
3497: AHL_DEBUG_PUB.debug('p_srvc_rec.move_qty_to_nr_workorder['||p_srvc_rec.move_qty_to_nr_workorder||']');
3498:
3499: END IF;
3500:
3501:

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

3554: OPEN TRX_ACTION_CUR(p_x_ahl_mtl_txn_rec.Transaction_Type_Id);
3555: FETCH TRX_ACTION_CUR INTO l_txn_action, l_txn_source_type;
3556: IF(TRX_ACTION_CUR%NOTFOUND) THEN
3557: IF G_DEBUG='Y' THEN
3558: AHL_DEBUG_PUB.debug('Did not find the Txn Type');
3559: END IF;
3560: CLOSE TRX_ACTION_CUR;
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;

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

3567: SELECT Mtl_Material_Transactions_S.nextval
3568: INTO p_x_txn_hdr_id
3569: FROM DUAL;
3570: IF G_DEBUG='Y' THEN
3571: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
3572: END IF;
3573: END IF;
3574:
3575: l_loop_count := 0;

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

3580: INTO p_x_txn_intf_id
3581: FROM DUAL;
3582:
3583: IF G_DEBUG='Y' THEN
3584: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
3585: END IF;
3586:
3587: if(p_x_ahl_mtl_txn_rec.Revision = FND_API.G_MISS_CHAR) THEN
3588: p_x_ahl_mtl_txn_rec.Revision := NULL;

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

3607: l_loop_count := p_x_ahl_mtl_txn_rec.Quantity + 1;
3608: END IF;
3609: END IF;
3610: IF G_DEBUG='Y' THEN
3611: AHL_DEBUG_PUB.debug('Loop Count is..['||l_loop_count||']');
3612: AHL_DEBUG_PUB.debug('l_qty is..['||l_qty||']');
3613: END IF;
3614:
3615: IF( p_x_ahl_mtl_txn_rec.Reason_Id = FND_API.G_MISS_NUM) THEN

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

3608: END IF;
3609: END IF;
3610: IF G_DEBUG='Y' THEN
3611: AHL_DEBUG_PUB.debug('Loop Count is..['||l_loop_count||']');
3612: AHL_DEBUG_PUB.debug('l_qty is..['||l_qty||']');
3613: END IF;
3614:
3615: IF( p_x_ahl_mtl_txn_rec.Reason_Id = FND_API.G_MISS_NUM) THEN
3616: p_x_ahl_mtl_txn_rec.Reason_Id := NULL;

Line 3678: 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);

3674: p_x_ahl_mtl_txn_rec.transaction_reference := NULL;
3675: END IF;
3676:
3677: IF G_DEBUG='Y' THEN
3678: 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);
3679: END IF;
3680:
3681: -- Added for FP ER 6447935
3682: -- support dynamic locator creation if allowed.

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

3715: l_txn_tmp_id := p_x_txn_intf_id;
3716: END IF;
3717:
3718: IF G_DEBUG='Y' THEN
3719: AHL_DEBUG_PUB.debug('insertng the lot record,interface id,tempid['
3720: ||to_char(p_x_txn_intf_id)||','
3721: ||to_char(l_txn_tmp_id)||']');
3722: END IF;
3723: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE

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

3758: l_txn_tmp_id := p_x_txn_intf_id;
3759: END IF;
3760:
3761: IF G_DEBUG='Y' THEN
3762: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['
3763: ||to_char(l_txn_tmp_id)||']');
3764: END IF;
3765: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
3766: TRANSACTION_INTERFACE_ID, SOURCE_CODE, SOURCE_LINE_ID,

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

3782:
3783:
3784:
3785: IF G_DEBUG='Y' THEN
3786: AHL_DEBUG_PUB.debug('insertng the txn record,header id,interface id['
3787: ||to_char(p_x_txn_hdr_id)||','
3788: ||to_char(p_x_txn_intf_id)||']');
3789: END IF;
3790:

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

3864: END LOOP; -- WHILE (l_loop_count
3865:
3866:
3867: IF G_DEBUG='Y' THEN
3868: AHL_DEBUG_PUB.debug('Transaction_source type['||l_txn_source_type||']');
3869: AHL_DEBUG_PUB.debug('Transaction_source Id['||p_x_ahl_mtl_txn_rec.Wip_Entity_id||']');
3870: END IF;
3871:
3872: EXCEPTION

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

3865:
3866:
3867: IF G_DEBUG='Y' THEN
3868: AHL_DEBUG_PUB.debug('Transaction_source type['||l_txn_source_type||']');
3869: AHL_DEBUG_PUB.debug('Transaction_source Id['||p_x_ahl_mtl_txn_rec.Wip_Entity_id||']');
3870: END IF;
3871:
3872: EXCEPTION
3873: WHEN OTHERS THEN

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

3872: EXCEPTION
3873: WHEN OTHERS THEN
3874: x_return_status := FND_API.G_RET_STS_ERROR;
3875: IF G_DEBUG='Y' THEN
3876: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
3877: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
3878:
3879: END IF;
3880: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');

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

3873: WHEN OTHERS THEN
3874: x_return_status := FND_API.G_RET_STS_ERROR;
3875: IF G_DEBUG='Y' THEN
3876: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
3877: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
3878:
3879: END IF;
3880: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTLTXN_ERROR');
3881: FND_MESSAGE.Set_Token('MSG',SQLERRM);

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

4060: procedure dumpInput(p_x_ahl_mtltxn_tbl IN AHL_MTLTXN_TBL_TYPE) IS
4061: BEGIN
4062:
4063: IF G_DEBUG='Y' THEN
4064: AHL_DEBUG_PUB.DEBUG('INPUTS TO THE PROC ARE ...');
4065:
4066: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4067: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4068:

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

4065:
4066: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4067: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4068:
4069: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);

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

4066: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
4067: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4068:
4069: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);

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

4067: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
4068:
4069: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);

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

4068:
4069: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);

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

4069: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Ahl_mtltxn_Id:'||p_x_ahl_mtltxn_tbl(i).Ahl_mtltxn_Id);
4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);

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

4070: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_Id);
4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);

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

4071: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Id:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id);
4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);

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

4072: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Inventory_Item_Segments:'||p_x_ahl_mtltxn_tbl(i).Inventory_Item_Segments);
4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);

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

4073: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Revision:'||p_x_ahl_mtltxn_tbl(i).Revision);
4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);

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

4074: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Organization_Id:'||p_x_ahl_mtltxn_tbl(i).Organization_Id);
4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);

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

4075: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition:'||p_x_ahl_mtltxn_tbl(i).Condition);
4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);

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

4076: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Condition_desc:'||p_x_ahl_mtltxn_tbl(i).Condition_desc);
4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);

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

4077: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Subinventory_Name:'||p_x_ahl_mtltxn_tbl(i).Subinventory_Name);
4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);

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

4078: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Id:'||p_x_ahl_mtltxn_tbl(i).Locator_Id);
4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);

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

4079: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Locator_Segments:'||p_x_ahl_mtltxn_tbl(i).Locator_Segments);
4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);

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

4080: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Quantity:'||p_x_ahl_mtltxn_tbl(i).Quantity);
4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);

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

4081: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom:'||p_x_ahl_mtltxn_tbl(i).Uom);
4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);

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

4082: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Uom_Desc:'||p_x_ahl_mtltxn_tbl(i).Uom_Desc);
4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);

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

4083: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Id:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id);
4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);

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

4084: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Type_Name:'||p_x_ahl_mtltxn_tbl(i).Transaction_Type_Name);
4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);

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

4085: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Transaction_Reference:'||p_x_ahl_mtltxn_tbl(i).Transaction_Reference);
4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);

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

4086: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Wip_Entity_Id:'||p_x_ahl_mtltxn_tbl(i).Wip_Entity_Id);
4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:

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

4087: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Operation_Seq_Num:'||p_x_ahl_mtltxn_tbl(i).Operation_Seq_Num);
4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:
4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);

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

4088: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Serial_Number:'||p_x_ahl_mtltxn_tbl(i).Serial_Number);
4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:
4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4096:

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

4089: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Lot_Number:'||p_x_ahl_mtltxn_tbl(i).Lot_Number);
4090: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Id:'||p_x_ahl_mtltxn_tbl(i).Reason_Id);
4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:
4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4096:
4097: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);

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

4091: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Reason_Name:'||p_x_ahl_mtltxn_tbl(i).Reason_Name);
4092: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code:'||p_x_ahl_mtltxn_tbl(i).Problem_Code);
4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:
4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4096:
4097: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4098:
4099: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);

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

4093: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Problem_Code_Meaning:'||p_x_ahl_mtltxn_tbl(i).Problem_Code_Meaning);
4094:
4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4096:
4097: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4098:
4099: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4100:
4101: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);

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

4095: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Target_Visit_Id:'||p_x_ahl_mtltxn_tbl(i).Target_Visit_Id);
4096:
4097: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4098:
4099: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4100:
4101: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4102:
4103: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);

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

4097: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Sr_Summary:'||p_x_ahl_mtltxn_tbl(i).Sr_Summary);
4098:
4099: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4100:
4101: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4102:
4103: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4104:
4105: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);

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

4099: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Qa_Collection_Id:'||p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id);
4100:
4101: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4102:
4103: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4104:
4105: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4106:
4107: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);

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

4101: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').Workorder_operation_Id:'||p_x_ahl_mtltxn_tbl(i).Workorder_operation_Id);
4102:
4103: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4104:
4105: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4106:
4107: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4108:
4109: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);

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

4103: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE_CATEGORY:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE_CATEGORY);
4104:
4105: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4106:
4107: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4108:
4109: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4110:
4111: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);

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

4105: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE1:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE1);
4106:
4107: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4108:
4109: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4110:
4111: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4112:
4113: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);

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

4107: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE2:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE2);
4108:
4109: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4110:
4111: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4112:
4113: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4114:
4115: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);

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

4109: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE3:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE3);
4110:
4111: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4112:
4113: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4114:
4115: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4116:
4117: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);

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

4111: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE4:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE4);
4112:
4113: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4114:
4115: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4116:
4117: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4118:
4119: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);

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

4113: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE5:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE5);
4114:
4115: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4116:
4117: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4118:
4119: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4120:
4121: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);

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

4115: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE6:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE6);
4116:
4117: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4118:
4119: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4120:
4121: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4122:
4123: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);

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

4117: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE7:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE7);
4118:
4119: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4120:
4121: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4122:
4123: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4124:
4125: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);

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

4119: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE8:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE8);
4120:
4121: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4122:
4123: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4124:
4125: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4126:
4127: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);

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

4121: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE9:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE9);
4122:
4123: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4124:
4125: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4126:
4127: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4128:
4129: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);

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

4123: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE10:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE10);
4124:
4125: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4126:
4127: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4128:
4129: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4130:
4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);

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

4125: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE11:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE11);
4126:
4127: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4128:
4129: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4130:
4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);

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

4127: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE12:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE12);
4128:
4129: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4130:
4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);

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

4129: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE13:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE13);
4130:
4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);

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

4130:
4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);

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

4131: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE14:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE14);
4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4139: 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 4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);

4132:
4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4139: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4140: END LOOP;

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

4133: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').ATTRIBUTE15:'||p_x_ahl_mtltxn_tbl(i).ATTRIBUTE15);
4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4139: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4140: END LOOP;
4141: END IF; -- p_x_ahl_mtltxn_tbl.COUNT

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

4134: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').transaction_date:'||p_x_ahl_mtltxn_tbl(i).transaction_date);
4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4139: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4140: END LOOP;
4141: END IF; -- p_x_ahl_mtltxn_tbl.COUNT
4142: END IF;

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

4135: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_id:'||p_x_ahl_mtltxn_tbl(i).recepient_id);
4136: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').recepient_name:'||p_x_ahl_mtltxn_tbl(i).recepient_name);
4137: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_id:'||p_x_ahl_mtltxn_tbl(i).disposition_id);
4138: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').disposition_name:'||p_x_ahl_mtltxn_tbl(i).disposition_name);
4139: AHL_DEBUG_PUB.debug('p_x_ahl_mtltxn_tbl('||i||').move_to_project_flag:'||p_x_ahl_mtltxn_tbl(i).move_to_project_flag);
4140: END LOOP;
4141: END IF; -- p_x_ahl_mtltxn_tbl.COUNT
4142: END IF;
4143: END dumpInput;

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

5808:
5809: BEGIN
5810:
5811: IF G_DEBUG='Y' THEN
5812: AHL_DEBUG_PUB.DEBUG('Start Procedure:Splitting locator concatenated segments:' || p_concat_segs, 'Get_MTL_LocatorSegs');
5813: END IF;
5814:
5815: -- initialize status to success.
5816: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5834: -- find segment delimiter
5835: l_delim := l_ffstru.segment_separator;
5836:
5837: IF G_DEBUG='Y' THEN
5838: AHL_DEBUG_PUB.DEBUG('Before Loc Seg validate:Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
5839: END IF;
5840:
5841: -- validate locator segments.
5842: l_valid_flag := fnd_flex_keyval.validate_segs(

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

5867: -- validate if enabled segments equal to input locator segments.
5868: -- if not, raise error and return.
5869: IF (l_loc_nseg <> l_flex_nseg) THEN
5870: IF G_DEBUG='Y' THEN
5871: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);
5872: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
5873: END IF;
5874:
5875: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');

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

5868: -- if not, raise error and return.
5869: IF (l_loc_nseg <> l_flex_nseg) THEN
5870: IF G_DEBUG='Y' THEN
5871: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_flex_nseg);
5872: AHL_DEBUG_PUB.DEBUG('FND Enabled Segments:' || l_loc_nseg);
5873: END IF;
5874:
5875: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
5876: FND_MESSAGE.Set_Token('LOC_NUM',l_flex_nseg);

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

5901:
5902: IF G_DEBUG='Y' THEN
5903: FOR i IN 1..20 LOOP
5904: --dbms_output.put_line('Segs final(' || i || ') : ' || l_mti_seglist(i));
5905: AHL_DEBUG_PUB.DEBUG('Segs final(' || i || ') : ' || p_x_mti_seglist(i), 'Get_MTL_LocatorSegs');
5906: END LOOP;
5907: AHL_DEBUG_PUB.DEBUG('End of procedure', 'Get_MTL_LocatorSegs');
5908: END IF;
5909:

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

5903: FOR i IN 1..20 LOOP
5904: --dbms_output.put_line('Segs final(' || i || ') : ' || l_mti_seglist(i));
5905: AHL_DEBUG_PUB.DEBUG('Segs final(' || i || ') : ' || p_x_mti_seglist(i), 'Get_MTL_LocatorSegs');
5906: END LOOP;
5907: AHL_DEBUG_PUB.DEBUG('End of procedure', 'Get_MTL_LocatorSegs');
5908: END IF;
5909:
5910: END Get_MTL_LocatorSegs;
5911: