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 60: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Material Requirement'); END IF;

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

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

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

Line 73: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND

69: );
70:
71: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
72:
73: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
74: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
75: THEN
76: --Start bug# 11672256
77: SELECT segment1 INTO l_inventory_item_name FROM mtl_system_items WHERE inventory_item_id=p_eam_mat_req_rec.inventory_item_id AND organization_id=p_eam_mat_req_rec.organization_id;

Line 74: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

70:
71: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
72:
73: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
74: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
75: THEN
76: --Start bug# 11672256
77: SELECT segment1 INTO l_inventory_item_name FROM mtl_system_items WHERE inventory_item_id=p_eam_mat_req_rec.inventory_item_id AND organization_id=p_eam_mat_req_rec.organization_id;
78: l_token_tbl(1).token_name := 'INVENTORY_ITEM_NAME';

Line 93: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND

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

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

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

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

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

Line 125: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

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

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

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

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

124: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
125: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
126: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
127: ELSE
128: x_old_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
129: END IF;
130: END IF;
131: l_return_status := FND_API.G_RET_STS_SUCCESS;
132:

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

169: BEGIN
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Material Requirement Check Attributes . . . '); END IF;
174:
175:
176: -- operation_seq_num
177:

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

174:
175:
176: -- operation_seq_num
177:
178: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
179:
180: begin
181:
182: 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 182: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

225: end;
226:
227:
228: -- inventory_item_id
229: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating inventory_item_id . . . '); END IF;
230:
231: declare
232: l_stockable_flag VARCHAR2(2);
233: NOT_PURCHASABLE EXCEPTION;

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

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

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

310: end;
311:
312:
313: -- quantity_per_assembly
314: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
315:
316: begin
317:
318: 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 318: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

347: end;
348:
349:
350: -- supply_subinventory
351: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_subinventory . . . '); END IF;
352:
353: begin
354:
355: 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 355: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

389:
390:
391:
392: -- supply_locator_id
393: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating supply_locator_id . . . '); END IF;
394:
395: begin
396:
397: 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 397: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

433:
434:
435:
436: -- department_id
437: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
438:
439: begin
440:
441: 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 441: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

495: end;
496:
497:
498: -- wip_supply_type
499: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
500:
501: begin
502:
503: 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 503: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

499: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
500:
501: begin
502:
503: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
504:
505:
506: 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
507: --not a valid supply type

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

536: end;
537:
538:
539: -- mrp_net_flag
540: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
541:
542: begin
543:
544: 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 544: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

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

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

577: FROM MTL_SYSTEM_ITEMS_KFV
578: WHERE inventory_item_id = p_eam_mat_req_rec.inventory_item_id
579: AND organization_id = p_eam_mat_req_rec.organization_id;
580:
581: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN
582: l_allocated := EAM_MATERIAL_ALLOCQTY_PKG.allocated_quantity(
583: p_eam_mat_req_rec.wip_entity_id,
584: p_eam_mat_req_rec.operation_seq_num,
585: p_eam_mat_req_rec.organization_id,

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

587: END IF;
588:
589: IF(l_stockable_flag='Y') THEN
590: -- delete material_requirement
591: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
592:
593: declare
594: l_count_mmt NUMBER :=0;
595: l_count_mmtt NUMBER :=0;

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

595: l_count_mmtt NUMBER :=0;
596: l_issued_qty NUMBER :=0;
597: begin
598:
599: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
600:
601: select count(*)
602: into l_count_mmtt
603: from mtl_material_transactions_temp

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

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

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

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

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

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

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

769: AND ewodi.item_id=p_eam_mat_req_rec.inventory_item_id;
770:
771:
772:
773: IF(p_eam_mat_req_rec.transaction_type =EAM_PROCESS_WO_PVT.G_OPR_DELETE) AND
774: (l_ordered_quantity > 0) THEN
775: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
776: l_token_tbl(1).token_value := p_eam_mat_req_rec.wip_entity_id;
777:

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

782: , p_mesg_token_tbl => l_mesg_token_tbl
783: , x_mesg_token_tbl => l_out_mesg_token_tbl
784: );
785: l_mesg_token_tbl := l_out_mesg_token_tbl;
786: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete non-stockable inventory item . . . '); END IF;
787:
788: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
789: x_mesg_token_tbl := l_mesg_token_tbl ;
790: return;