eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;

55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;
60:
61: EAM_MAT_REQ_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_mat_req_rec.wip_entity_id
63: , p_organization_id => p_eam_mat_req_rec.organization_id

Line 70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;

66: , x_eam_mat_req_rec => x_old_eam_mat_req_rec
67: , x_Return_status => l_return_status
68: );
69:
70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
71:
72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
73: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN

Line 72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND

68: );
69:
70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
71:
72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
73: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN
75: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
76: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;

Line 73: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

69:
70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
71:
72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
73: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN
75: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
76: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
77:

Line 89: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND

85: l_mesg_token_tbl := l_out_mesg_token_tbl;
86:
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
90: p_eam_mat_req_rec.transaction_type IN
91: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
92: THEN
93: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';

Line 91: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
90: p_eam_mat_req_rec.transaction_type IN
91: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
92: THEN
93: l_token_tbl(1).token_name := 'INVENTORY_ITEM_ID';
94: l_token_tbl(1).token_value := p_eam_mat_req_rec.inventory_item_id;
95:

Line 120: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN

116: l_mesg_token_tbl := l_out_mesg_token_tbl;
117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: ELSE /* Assign the relevant transaction type for SYNC operations */
120: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
122: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

Line 121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: ELSE /* Assign the relevant transaction type for SYNC operations */
120: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
122: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;

Line 122: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

118:
119: ELSE /* Assign the relevant transaction type for SYNC operations */
120: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
122: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;
126: END IF;

Line 124: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

120: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
122: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;
126: END IF;
127: l_return_status := FND_API.G_RET_STS_SUCCESS;
128:

Line 169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;

165: BEGIN
166:
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;
170:
171:
172: -- operation_seq_num
173:

Line 174: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;

170:
171:
172: -- operation_seq_num
173:
174: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
175:
176: begin
177:
178: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 178: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

174: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
175:
176: begin
177:
178: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
179:
180: begin
181: select 1
182: into g_dummy

Line 225: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating inventory_item_id . . . '); END IF;

221: end;
222:
223:
224: -- inventory_item_id
225: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating inventory_item_id . . . '); END IF;
226:
227: declare
228: l_stockable_flag VARCHAR2(2);
229: NOT_PURCHASABLE EXCEPTION;

Line 233: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

229: NOT_PURCHASABLE EXCEPTION;
230: l_count NUMBER;
231: begin
232:
233: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
234:
235: -- Fix for bug# 3602041 - Removed check for bom_enabled flag in the where clause of the query
236: select 1
237: into g_dummy

Line 310: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;

306: end;
307:
308:
309: -- quantity_per_assembly
310: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
311:
312: begin
313:
314: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 314: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

310: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
311:
312: begin
313:
314: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
315:
316: if p_eam_mat_req_rec.quantity_per_assembly < 0 then
317: raise fnd_api.g_exc_unexpected_error;
318: end if;

Line 347: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;

343: end;
344:
345:
346: -- supply_subinventory
347: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;
348:
349: begin
350:
351: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 351: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

347: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;
348:
349: begin
350:
351: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
352:
353: if p_eam_mat_req_rec.supply_subinventory is not null then
354: select 1 into g_dummy
355: from mtl_secondary_inventories msinv

Line 389: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;

385:
386:
387:
388: -- supply_locator_id
389: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;
390:
391: begin
392:
393: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 393: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

389: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;
390:
391: begin
392:
393: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
394:
395: if p_eam_mat_req_rec.supply_locator_id is not null then
396: select 1 into g_dummy
397: from mtl_item_locations_kfv

Line 433: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;

429:
430:
431:
432: -- department_id
433: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
434:
435: begin
436:
437: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 437: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

433: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
434:
435: begin
436:
437: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
438:
439: if p_eam_mat_req_rec.department_id is null then
440:
441: if p_eam_mat_req_rec.operation_seq_num <> 1 then

Line 495: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;

491: end;
492:
493:
494: -- wip_supply_type
495: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
496:
497: begin
498:
499: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 499: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

495: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
496:
497: begin
498:
499: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
500:
501:
502: if(p_eam_mat_req_rec.wip_supply_type is not null and p_eam_mat_req_rec.wip_supply_type not in (wip_constants.push, wip_constants.bulk, wip_constants.based_on_bom)) then
503: --not a valid supply type

Line 536: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;

532: end;
533:
534:
535: -- mrp_net_flag
536: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
537:
538: begin
539:
540: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 540: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

536: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
537:
538: begin
539:
540: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
541:
542: if p_eam_mat_req_rec.mrp_net_flag not in (wip_constants.yes, wip_constants.no) then
543: raise fnd_api.g_exc_unexpected_error;
544: end if;

Line 577: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN

573: FROM MTL_SYSTEM_ITEMS_KFV
574: WHERE inventory_item_id = p_eam_mat_req_rec.inventory_item_id
575: AND organization_id = p_eam_mat_req_rec.organization_id;
576:
577: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN
578: l_allocated := EAM_MATERIAL_ALLOCQTY_PKG.allocated_quantity(
579: p_eam_mat_req_rec.wip_entity_id,
580: p_eam_mat_req_rec.operation_seq_num,
581: p_eam_mat_req_rec.organization_id,

Line 587: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;

583: END IF;
584:
585: IF(l_stockable_flag='Y') THEN
586: -- delete material_requirement
587: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
588:
589: declare
590: l_count_mmt NUMBER :=0;
591: l_count_mmtt NUMBER :=0;

Line 595: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

591: l_count_mmtt NUMBER :=0;
592: l_issued_qty NUMBER :=0;
593: begin
594:
595: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
596:
597: select count(*)
598: into l_count_mmtt
599: from mtl_material_transactions_temp

Line 661: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;

657:
658:
659:
660: -- Required Quantity
661: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
662: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
663: and p_eam_mat_req_rec.required_quantity < p_old_eam_mat_req_rec.required_quantity) then
664: begin
665:

Line 662: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

658:
659:
660: -- Required Quantity
661: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
662: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
663: and p_eam_mat_req_rec.required_quantity < p_old_eam_mat_req_rec.required_quantity) then
664: begin
665:
666: select material_issue_by_mo

Line 701: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN

697: ELSE
698: g_dummy:=0;
699: l_ordered_quantity:=0;
700:
701: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN
702: --Bug#3691325 If Po Quantity or Req Quantity is greater than zero,we cannot delete the direct item
703: --Bug#4862404 (appsperf) - Brought the eam_work_order_direct_items_v view query inline and removed all
704: -- unnecessary columns/tables.
705: SELECT greatest(nvl(ewodi.po_quantity_ordered,0), nvl(ewodi.rql_quantity_ordered,0))

Line 767: IF(p_eam_mat_req_rec.transaction_type =EAM_PROCESS_WO_PVT.G_OPR_DELETE) AND

763: AND ewodi.item_id=p_eam_mat_req_rec.inventory_item_id;
764:
765:
766:
767: IF(p_eam_mat_req_rec.transaction_type =EAM_PROCESS_WO_PVT.G_OPR_DELETE) AND
768: (l_ordered_quantity > 0) THEN
769: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
770: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
771:

Line 780: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;

776: , p_mesg_token_tbl => l_mesg_token_tbl
777: , x_mesg_token_tbl => l_out_mesg_token_tbl
778: );
779: l_mesg_token_tbl := l_out_mesg_token_tbl;
780: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
781:
782: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
783: x_mesg_token_tbl := l_mesg_token_tbl ;
784: return;