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_DIRECT_ITEMS_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 Direct Item'); 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 Direct Item'); END IF;
60:
61: EAM_DIRECT_ITEMS_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_direct_items_rec.wip_entity_id
63: , p_organization_id => p_eam_direct_items_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_direct_items_rec => x_old_eam_direct_items_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_direct_items_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_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN
75: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
76: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;

Line 73: p_eam_direct_items_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_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN
75: l_token_tbl(1).token_name := 'DIRECT_ITEM_SEQUENCE_ID';
76: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_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_direct_items_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 := 'DIRECT_ITEM_SEQUENCE_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_direct_items_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 := 'DIRECT_ITEM_SEQUENCE_ID';
94: l_token_tbl(1).token_value := p_eam_direct_items_rec.direct_item_sequence_id;
95:

Line 120: IF p_eam_direct_items_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_direct_items_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_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_direct_items_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_direct_items_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_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;

Line 122: x_old_eam_direct_items_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_direct_items_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_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;
126: END IF;

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

120: IF p_eam_direct_items_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_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
123: ELSE
124: x_old_eam_direct_items_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 165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;

161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;
166:
167:
168: -- department_id
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;

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

165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;
166:
167:
168: -- department_id
169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
170:
171: begin
172:
173: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 173: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

169: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating department_id . . . '); END IF;
170:
171: begin
172:
173: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
174:
175: if (p_eam_direct_items_rec.operation_seq_num = 1 and
176: p_eam_direct_items_rec.department_id is not null) OR
177: (p_eam_direct_items_rec.operation_seq_num <> 1 and

Line 226: IF(p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN

222: --start of fix for 3352406
223: g_dummy:=0;
224: l_ordered_quantity:=0;
225:
226: IF(p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN
227: --Bug#3691325 If Po Quantity or Req Quantity is greater than zero,we cannot delete the direct item
228: --Bug#4862404 - (appsperf). Brought the ewodi view query inline and removed all unnecessary tables/columns.
229:
230: SELECT greatest(nvl(ewodi.po_quantity_ordered,0), nvl(ewodi.rql_quantity_ordered,0))

Line 306: IF(p_eam_direct_items_rec.transaction_type =EAM_PROCESS_WO_PVT.G_OPR_DELETE) AND

302:
303:
304:
305:
306: IF(p_eam_direct_items_rec.transaction_type =EAM_PROCESS_WO_PVT.G_OPR_DELETE) AND
307: (l_ordered_quantity > 0) THEN
308: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
309: l_token_tbl(1).token_value := p_eam_direct_items_rec.wip_entity_id;
310:

Line 319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete direct item . . . '); END IF;

315: , p_mesg_token_tbl => l_mesg_token_tbl
316: , x_mesg_token_tbl => l_out_mesg_token_tbl
317: );
318: l_mesg_token_tbl := l_out_mesg_token_tbl;
319: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Cannot delete direct item . . . '); END IF;
320:
321: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
322: x_mesg_token_tbl := l_mesg_token_tbl ;
323: return;

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

327: /*
328:
329: -- operation_seq_num
330:
331: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
332:
333: begin
334:
335: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 335: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

331: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
332:
333: begin
334:
335: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
336:
337: if p_eam_direct_items_rec.operation_seq_num = 1 then
338: select 1
339: into g_dummy

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

377: end;
378:
379:
380: -- direct_item_sequence_id
381: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating direct_item_sequence_id . . . '); END IF;
382:
383: begin
384:
385: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 385: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

381: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating direct_item_sequence_id . . . '); END IF;
382:
383: begin
384:
385: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
386:
387: -- Fix for bug# 3602041 - Removed check for bom_enabled flag in the where clause of the query
388: select 1
389: into g_dummy

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

421:
422: end;
423:
424: -- quantity_per_assembly
425: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
426:
427: begin
428:
429: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 429: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

425: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating quantity_per_assembly . . . '); END IF;
426:
427: begin
428:
429: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
430:
431: if p_eam_direct_items_rec.quantity_per_assembly < 0 then
432: raise fnd_api.g_exc_unexpected_error;
433: end if;

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

458: end;
459:
460:
461: -- wip_supply_type
462: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
463:
464: begin
465:
466: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 466: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

462: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating wip_supply_type . . . '); END IF;
463:
464: begin
465:
466: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
467:
468:
469: if(p_eam_direct_items_rec.wip_supply_type is not null and p_eam_direct_items_rec.wip_supply_type not in (wip_constants.push, wip_constants.bulk, wip_constants.based_on_bom)) then
470: --not a valid supply type

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

499: end;
500:
501:
502: -- mrp_net_flag
503: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
504:
505: begin
506:
507: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 507: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

503: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating mrp_net_flag . . . '); END IF;
504:
505: begin
506:
507: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
508:
509: if p_eam_direct_items_rec.mrp_net_flag not in (wip_constants.yes, wip_constants.no) then
510: raise fnd_api.g_exc_unexpected_error;
511: end if;

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

537:
538:
539:
540: -- delete material_requirement
541: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating material_requirement . . . '); END IF;
542:
543: declare
544: l_count_mmt NUMBER :=0;
545: l_count_mmtt NUMBER :=0;

Line 549: if (p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

545: l_count_mmtt NUMBER :=0;
546: l_issued_qty NUMBER :=0;
547: begin
548:
549: if (p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
550:
551: select count(*)
552: into l_count_mmtt
553: from mtl_material_transactions_temp

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

611:
612:
613:
614: -- Required Quantity
615: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
616:
617: begin
618: if p_eam_direct_items_rec.required_quantity < p_eam_direct_items_rec.quantity_issued then
619: raise fnd_api.g_exc_unexpected_error;