APPS.ENG_FORM_ECO_PVT dependencies on ERROR_HANDLER

Line 47: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

43: l_eco_for_production NUMBER ;
44: l_cfm_routing_flag NUMBER ;
45:
46: l_err_text VARCHAR2(2000);
47: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
48: l_return_status VARCHAR2(1);
49: BEGIN
50:
51: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 119: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

115: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
116: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type
117: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
118: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
119: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
120: , x_return_status IN OUT NOCOPY VARCHAR2
121: )
122: IS
123:

Line 124: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

120: , x_return_status IN OUT NOCOPY VARCHAR2
121: )
122: IS
123:
124: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
125: l_other_token_tbl Error_Handler.Token_Tbl_Type;
126: l_other_message VARCHAR2(50);
127: l_err_text VARCHAR2(2000);
128: l_valid BOOLEAN := TRUE;

Line 125: l_other_token_tbl Error_Handler.Token_Tbl_Type;

121: )
122: IS
123:
124: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
125: l_other_token_tbl Error_Handler.Token_Tbl_Type;
126: l_other_message VARCHAR2(50);
127: l_err_text VARCHAR2(2000);
128: l_valid BOOLEAN := TRUE;
129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 145: l_Token_Tbl Error_Handler.Token_Tbl_Type;

141: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
142: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
143: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
144: l_return_value NUMBER;
145: l_Token_Tbl Error_Handler.Token_Tbl_Type;
146:
147: EXC_SEV_QUIT_RECORD EXCEPTION;
148: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
149:

Line 184: IF l_return_status = Error_Handler.G_STATUS_ERROR

180: );
181:
182: --dbms_output.put_line('return_status: ' || l_return_status);
183:
184: IF l_return_status = Error_Handler.G_STATUS_ERROR
185: THEN
186: RAISE EXC_SEV_QUIT_RECORD;
187: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
188: THEN

Line 187: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

183:
184: IF l_return_status = Error_Handler.G_STATUS_ERROR
185: THEN
186: RAISE EXC_SEV_QUIT_RECORD;
187: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
188: THEN
189: RAISE EXC_UNEXP_SKIP_OBJECT;
190: END IF;
191: END IF;

Line 232: IF l_return_status = Error_Handler.G_STATUS_ERROR

228: END IF;
229:
230: --dbms_output.put_line('return_status: ' || l_return_status);
231:
232: IF l_return_status = Error_Handler.G_STATUS_ERROR
233: THEN
234: RAISE EXC_SEV_QUIT_RECORD;
235: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
236: THEN

Line 235: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

231:
232: IF l_return_status = Error_Handler.G_STATUS_ERROR
233: THEN
234: RAISE EXC_SEV_QUIT_RECORD;
235: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
236: THEN
237: RAISE EXC_UNEXP_SKIP_OBJECT;
238: ELSIF l_return_status ='S' AND
239: l_Mesg_Token_Tbl.COUNT <>0

Line 241: Eco_Error_Handler.Log_Error

237: RAISE EXC_UNEXP_SKIP_OBJECT;
238: ELSIF l_return_status ='S' AND
239: l_Mesg_Token_Tbl.COUNT <>0
240: THEN
241: Eco_Error_Handler.Log_Error
242: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
243: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
244: , p_mesg_token_tbl => l_mesg_token_tbl
245: , p_error_status => 'W'

Line 246: , p_error_level => Error_Handler.G_SR_LEVEL

242: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
243: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
244: , p_mesg_token_tbl => l_mesg_token_tbl
245: , p_error_status => 'W'
246: , p_error_level => Error_Handler.G_SR_LEVEL
247: , p_entity_index => I
248: , x_eco_rec => l_eco_rec
249: , x_eco_revision_tbl => l_eco_revision_tbl
250: , x_revised_item_tbl => l_revised_item_tbl

Line 281: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

277: );
278:
279: --dbms_output.put_line('return_status: ' || l_return_status);
280:
281: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
282: THEN
283: RAISE EXC_UNEXP_SKIP_OBJECT;
284: ELSIF l_return_status ='S' AND
285: l_Mesg_Token_Tbl.COUNT <>0

Line 287: Eco_Error_Handler.Log_Error

283: RAISE EXC_UNEXP_SKIP_OBJECT;
284: ELSIF l_return_status ='S' AND
285: l_Mesg_Token_Tbl.COUNT <>0
286: THEN
287: Eco_Error_Handler.Log_Error
288: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
289: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
290: , p_mesg_token_tbl => l_mesg_token_tbl
291: , p_error_status => 'W'

Line 292: , p_error_level => Error_Handler.G_SR_LEVEL

288: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
289: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
290: , p_mesg_token_tbl => l_mesg_token_tbl
291: , p_error_status => 'W'
292: , p_error_level => Error_Handler.G_SR_LEVEL
293: , p_entity_index => I
294: , x_eco_rec => l_eco_rec
295: , x_eco_revision_tbl => l_eco_revision_tbl
296: , x_revised_item_tbl => l_revised_item_tbl

Line 315: Eco_Error_Handler.Log_Error

311: WHEN EXC_SEV_QUIT_RECORD THEN
312:
313: --dbms_output.put_line('Expected error generated');
314: l_rev_sub_resource_tbl(I) := l_rev_sub_resource_rec;
315: Eco_Error_Handler.Log_Error
316: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
317: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
318: , p_mesg_token_tbl => l_mesg_token_tbl
319: , p_error_status => FND_API.G_RET_STS_ERROR

Line 320: , p_error_scope => Error_Handler.G_SCOPE_RECORD

316: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
317: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
318: , p_mesg_token_tbl => l_mesg_token_tbl
319: , p_error_status => FND_API.G_RET_STS_ERROR
320: , p_error_scope => Error_Handler.G_SCOPE_RECORD
321: , p_error_level => Error_Handler.G_SR_LEVEL
322: , p_entity_index => I
323: , x_eco_rec => l_eco_rec
324: , x_eco_revision_tbl => l_eco_revision_tbl

Line 321: , p_error_level => Error_Handler.G_SR_LEVEL

317: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
318: , p_mesg_token_tbl => l_mesg_token_tbl
319: , p_error_status => FND_API.G_RET_STS_ERROR
320: , p_error_scope => Error_Handler.G_SCOPE_RECORD
321: , p_error_level => Error_Handler.G_SR_LEVEL
322: , p_entity_index => I
323: , x_eco_rec => l_eco_rec
324: , x_eco_revision_tbl => l_eco_revision_tbl
325: , x_revised_item_tbl => l_revised_item_tbl

Line 352: Eco_Error_Handler.Log_Error

348:
349: WHEN EXC_UNEXP_SKIP_OBJECT THEN
350:
351: --dbms_output.put_line('Unexpected error generated');
352: Eco_Error_Handler.Log_Error
353: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
354: , p_mesg_token_tbl => l_mesg_token_tbl
355: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
356: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 355: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

351: --dbms_output.put_line('Unexpected error generated');
352: Eco_Error_Handler.Log_Error
353: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
354: , p_mesg_token_tbl => l_mesg_token_tbl
355: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
356: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
357: , p_other_message => l_other_message
358: , p_other_token_tbl => l_other_token_tbl
359: , p_error_level => Error_Handler.G_SR_LEVEL

Line 356: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

352: Eco_Error_Handler.Log_Error
353: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
354: , p_mesg_token_tbl => l_mesg_token_tbl
355: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
356: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
357: , p_other_message => l_other_message
358: , p_other_token_tbl => l_other_token_tbl
359: , p_error_level => Error_Handler.G_SR_LEVEL
360: , p_entity_index => I

Line 359: , p_error_level => Error_Handler.G_SR_LEVEL

355: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
356: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
357: , p_other_message => l_other_message
358: , p_other_token_tbl => l_other_token_tbl
359: , p_error_level => Error_Handler.G_SR_LEVEL
360: , p_entity_index => I
361: , x_ECO_rec => l_ECO_rec
362: , x_eco_revision_tbl => l_eco_revision_tbl
363: , x_revised_item_tbl => l_revised_item_tbl

Line 429: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

425: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
426: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type
427: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
428: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
429: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
430: , x_return_status IN OUT NOCOPY VARCHAR2
431: )
432: IS
433:

Line 434: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

430: , x_return_status IN OUT NOCOPY VARCHAR2
431: )
432: IS
433:
434: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
435: l_other_token_tbl Error_Handler.Token_Tbl_Type;
436: l_other_message VARCHAR2(50);
437: l_err_text VARCHAR2(2000);
438: l_valid BOOLEAN := TRUE;

Line 435: l_other_token_tbl Error_Handler.Token_Tbl_Type;

431: )
432: IS
433:
434: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
435: l_other_token_tbl Error_Handler.Token_Tbl_Type;
436: l_other_message VARCHAR2(50);
437: l_err_text VARCHAR2(2000);
438: l_valid BOOLEAN := TRUE;
439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 455: l_Token_Tbl Error_Handler.Token_Tbl_Type;

451: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
452: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
453: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
454: l_return_value NUMBER;
455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
456:
457: EXC_SEV_QUIT_RECORD EXCEPTION;
458: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
459:

Line 494: IF l_return_status = Error_Handler.G_STATUS_ERROR

490: );
491:
492: --dbms_output.put_line('return_status: ' || l_return_status);
493:
494: IF l_return_status = Error_Handler.G_STATUS_ERROR
495: THEN
496: RAISE EXC_SEV_QUIT_RECORD;
497: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
498: THEN

Line 497: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

493:
494: IF l_return_status = Error_Handler.G_STATUS_ERROR
495: THEN
496: RAISE EXC_SEV_QUIT_RECORD;
497: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
498: THEN
499: RAISE EXC_UNEXP_SKIP_OBJECT;
500: END IF;
501: END IF;

Line 540: IF l_return_status = Error_Handler.G_STATUS_ERROR

536: END IF;
537:
538: --dbms_output.put_line('return_status: ' || l_return_status);
539:
540: IF l_return_status = Error_Handler.G_STATUS_ERROR
541: THEN
542: RAISE EXC_SEV_QUIT_RECORD;
543: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
544: THEN

Line 543: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

539:
540: IF l_return_status = Error_Handler.G_STATUS_ERROR
541: THEN
542: RAISE EXC_SEV_QUIT_RECORD;
543: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
544: THEN
545: RAISE EXC_UNEXP_SKIP_OBJECT;
546: ELSIF l_return_status ='S' AND
547: l_Mesg_Token_Tbl.COUNT <>0

Line 549: Eco_Error_Handler.Log_Error

545: RAISE EXC_UNEXP_SKIP_OBJECT;
546: ELSIF l_return_status ='S' AND
547: l_Mesg_Token_Tbl.COUNT <>0
548: THEN
549: Eco_Error_Handler.Log_Error
550: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
551: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
552: , p_mesg_token_tbl => l_mesg_token_tbl
553: , p_error_status => 'W'

Line 554: , p_error_level => Error_Handler.G_RES_LEVEL

550: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
551: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
552: , p_mesg_token_tbl => l_mesg_token_tbl
553: , p_error_status => 'W'
554: , p_error_level => Error_Handler.G_RES_LEVEL
555: , p_entity_index => I
556: , x_eco_rec => l_eco_rec
557: , x_eco_revision_tbl => l_eco_revision_tbl
558: , x_revised_item_tbl => l_revised_item_tbl

Line 589: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

585: );
586:
587: --dbms_output.put_line('return_status: ' || l_return_status);
588:
589: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
590: THEN
591: RAISE EXC_UNEXP_SKIP_OBJECT;
592: ELSIF l_return_status ='S' AND
593: l_Mesg_Token_Tbl.COUNT <>0

Line 595: Eco_Error_Handler.Log_Error

591: RAISE EXC_UNEXP_SKIP_OBJECT;
592: ELSIF l_return_status ='S' AND
593: l_Mesg_Token_Tbl.COUNT <>0
594: THEN
595: Eco_Error_Handler.Log_Error
596: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
597: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
598: , p_mesg_token_tbl => l_mesg_token_tbl
599: , p_error_status => 'W'

Line 600: , p_error_level => Error_Handler.G_RES_LEVEL

596: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
597: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
598: , p_mesg_token_tbl => l_mesg_token_tbl
599: , p_error_status => 'W'
600: , p_error_level => Error_Handler.G_RES_LEVEL
601: , p_entity_index => I
602: , x_eco_rec => l_eco_rec
603: , x_eco_revision_tbl => l_eco_revision_tbl
604: , x_revised_item_tbl => l_revised_item_tbl

Line 623: Eco_Error_Handler.Log_Error

619: WHEN EXC_SEV_QUIT_RECORD THEN
620:
621: --dbms_output.put_line('Expected error generated');
622: l_rev_op_resource_tbl(I) := l_rev_op_resource_rec;
623: Eco_Error_Handler.Log_Error
624: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
625: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
626: , p_mesg_token_tbl => l_mesg_token_tbl
627: , p_error_status => FND_API.G_RET_STS_ERROR

Line 628: , p_error_scope => Error_Handler.G_SCOPE_RECORD

624: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
625: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
626: , p_mesg_token_tbl => l_mesg_token_tbl
627: , p_error_status => FND_API.G_RET_STS_ERROR
628: , p_error_scope => Error_Handler.G_SCOPE_RECORD
629: , p_error_level => Error_Handler.G_RES_LEVEL
630: , p_entity_index => I
631: , x_eco_rec => l_eco_rec
632: , x_eco_revision_tbl => l_eco_revision_tbl

Line 629: , p_error_level => Error_Handler.G_RES_LEVEL

625: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
626: , p_mesg_token_tbl => l_mesg_token_tbl
627: , p_error_status => FND_API.G_RET_STS_ERROR
628: , p_error_scope => Error_Handler.G_SCOPE_RECORD
629: , p_error_level => Error_Handler.G_RES_LEVEL
630: , p_entity_index => I
631: , x_eco_rec => l_eco_rec
632: , x_eco_revision_tbl => l_eco_revision_tbl
633: , x_revised_item_tbl => l_revised_item_tbl

Line 660: Eco_Error_Handler.Log_Error

656:
657: WHEN EXC_UNEXP_SKIP_OBJECT THEN
658:
659: --dbms_output.put_line('Unexpected error generated');
660: Eco_Error_Handler.Log_Error
661: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
662: , p_mesg_token_tbl => l_mesg_token_tbl
663: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
664: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 663: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

659: --dbms_output.put_line('Unexpected error generated');
660: Eco_Error_Handler.Log_Error
661: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
662: , p_mesg_token_tbl => l_mesg_token_tbl
663: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
664: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
665: , p_other_message => l_other_message
666: , p_other_token_tbl => l_other_token_tbl
667: , p_error_level => Error_Handler.G_RES_LEVEL

Line 664: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

660: Eco_Error_Handler.Log_Error
661: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
662: , p_mesg_token_tbl => l_mesg_token_tbl
663: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
664: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
665: , p_other_message => l_other_message
666: , p_other_token_tbl => l_other_token_tbl
667: , p_error_level => Error_Handler.G_RES_LEVEL
668: , p_entity_index => I

Line 667: , p_error_level => Error_Handler.G_RES_LEVEL

663: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
664: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
665: , p_other_message => l_other_message
666: , p_other_token_tbl => l_other_token_tbl
667: , p_error_level => Error_Handler.G_RES_LEVEL
668: , p_entity_index => I
669: , x_ECO_rec => l_ECO_rec
670: , x_eco_revision_tbl => l_eco_revision_tbl
671: , x_revised_item_tbl => l_revised_item_tbl

Line 738: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

734: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
735: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type
736: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
737: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
738: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
739: , x_return_status IN OUT NOCOPY VARCHAR2
740: )
741: IS
742:

Line 743: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

739: , x_return_status IN OUT NOCOPY VARCHAR2
740: )
741: IS
742:
743: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
744: l_other_token_tbl Error_Handler.Token_Tbl_Type;
745: l_other_message VARCHAR2(50);
746: l_err_text VARCHAR2(2000);
747: l_valid BOOLEAN := TRUE;

Line 744: l_other_token_tbl Error_Handler.Token_Tbl_Type;

740: )
741: IS
742:
743: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
744: l_other_token_tbl Error_Handler.Token_Tbl_Type;
745: l_other_message VARCHAR2(50);
746: l_err_text VARCHAR2(2000);
747: l_valid BOOLEAN := TRUE;
748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 764: l_Token_Tbl Error_Handler.Token_Tbl_Type;

760: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
761: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
762: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
763: l_return_value NUMBER;
764: l_Token_Tbl Error_Handler.Token_Tbl_Type;
765: l_query_op_seq_num NUMBER := NULL;
766: -- Bug no:2770096
767: l_routing_sequence_id NUMBER := NULL;
768: l_query_effective_date DATE := NULL;

Line 780: error_handler.write_debug('At the beginning of Rev_Op, the rec count is');

776: -- for header errors.
777:
778: IF BOM_Globals.get_debug = 'Y'
779: THEN
780: error_handler.write_debug('At the beginning of Rev_Op, the rec count is');
781: error_handler.write_debug( l_rev_operation_tbl.COUNT);
782: END IF;
783: FOR I IN 1..l_rev_operation_tbl.COUNT LOOP
784: BEGIN

Line 781: error_handler.write_debug( l_rev_operation_tbl.COUNT);

777:
778: IF BOM_Globals.get_debug = 'Y'
779: THEN
780: error_handler.write_debug('At the beginning of Rev_Op, the rec count is');
781: error_handler.write_debug( l_rev_operation_tbl.COUNT);
782: END IF;
783: FOR I IN 1..l_rev_operation_tbl.COUNT LOOP
784: BEGIN
785: -- Load local records.

Line 799: error_handler.write_debug('At the beginning of check existence');

795: -- Process Flow step 3: Verify Revised Operation's existence
796: --
797: IF BOM_Globals.get_debug = 'Y'
798: THEN
799: error_handler.write_debug('At the beginning of check existence');
800: END IF;
801: IF g_control_rec.check_existence
802: THEN
803: --dbms_output.put_line('Checking Existence');

Line 815: error_handler.write_debug('After check existence, the return status is');

811: );
812:
813: IF BOM_Globals.get_debug = 'Y'
814: THEN
815: error_handler.write_debug('After check existence, the return status is');
816: error_handler.write_debug( l_Return_Status);
817: END IF;
818:
819:

Line 816: error_handler.write_debug( l_Return_Status);

812:
813: IF BOM_Globals.get_debug = 'Y'
814: THEN
815: error_handler.write_debug('After check existence, the return status is');
816: error_handler.write_debug( l_Return_Status);
817: END IF;
818:
819:
820: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 820: IF l_return_status = Error_Handler.G_STATUS_ERROR

816: error_handler.write_debug( l_Return_Status);
817: END IF;
818:
819:
820: IF l_return_status = Error_Handler.G_STATUS_ERROR
821: THEN
822: RAISE EXC_SEV_QUIT_RECORD;
823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
824: THEN

Line 823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

819:
820: IF l_return_status = Error_Handler.G_STATUS_ERROR
821: THEN
822: RAISE EXC_SEV_QUIT_RECORD;
823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
824: THEN
825: RAISE EXC_UNEXP_SKIP_OBJECT;
826: END IF;
827: END IF;

Line 843: error_handler.write_debug('before op_seq attribute , the return status is');

839:
840: -- Process Flow step 9: Default missing values for Operation CREATE
841: IF BOM_Globals.get_debug = 'Y'
842: THEN
843: error_handler.write_debug('before op_seq attribute , the return status is');
844: error_handler.write_debug( l_Return_Status);
845: END IF;
846: Bom_Default_Op_Seq.Attribute_Defaulting
847: ( p_rev_operation_rec => l_rev_operation_rec

Line 844: error_handler.write_debug( l_Return_Status);

840: -- Process Flow step 9: Default missing values for Operation CREATE
841: IF BOM_Globals.get_debug = 'Y'
842: THEN
843: error_handler.write_debug('before op_seq attribute , the return status is');
844: error_handler.write_debug( l_Return_Status);
845: END IF;
846: Bom_Default_Op_Seq.Attribute_Defaulting
847: ( p_rev_operation_rec => l_rev_operation_rec
848: , p_rev_op_unexp_rec => l_rev_op_unexp_rec

Line 860: IF l_return_status = Error_Handler.G_STATUS_ERROR

856: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_operation_rec.item_sequence_number));
857:
858: --dbms_output.put_line('return_status: ' || l_return_status);
859:
860: IF l_return_status = Error_Handler.G_STATUS_ERROR
861: THEN
862: RAISE EXC_SEV_QUIT_RECORD;
863: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
864: THEN

Line 863: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

859:
860: IF l_return_status = Error_Handler.G_STATUS_ERROR
861: THEN
862: RAISE EXC_SEV_QUIT_RECORD;
863: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
864: THEN
865: RAISE EXC_UNEXP_SKIP_OBJECT;
866: ELSIF l_return_status ='S' AND l_Mesg_Token_Tbl.COUNT <>0
867: THEN

Line 868: Eco_Error_Handler.Log_Error

864: THEN
865: RAISE EXC_UNEXP_SKIP_OBJECT;
866: ELSIF l_return_status ='S' AND l_Mesg_Token_Tbl.COUNT <>0
867: THEN
868: Eco_Error_Handler.Log_Error
869: ( p_rev_operation_tbl => l_rev_operation_tbl
870: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
871: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
872: , p_mesg_token_tbl => l_mesg_token_tbl

Line 874: , p_error_level => Error_Handler.G_OP_LEVEL

870: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
871: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
872: , p_mesg_token_tbl => l_mesg_token_tbl
873: , p_error_status => 'W'
874: , p_error_level => Error_Handler.G_OP_LEVEL
875: , p_entity_index => I
876: , x_eco_rec => l_eco_rec
877: , x_eco_revision_tbl => l_eco_revision_tbl
878: , x_revised_item_tbl => l_revised_item_tbl

Line 942: error_handler.write_debug('before query_row, the return status is');

938: --dbms_output.put_line('querying row');
939:
940: IF BOM_Globals.get_debug = 'Y'
941: THEN
942: error_handler.write_debug('before query_row, the return status is');
943: error_handler.write_debug( l_Return_Status);
944: END IF;
945:
946: --Bug 2827097

Line 943: error_handler.write_debug( l_Return_Status);

939:
940: IF BOM_Globals.get_debug = 'Y'
941: THEN
942: error_handler.write_debug('before query_row, the return status is');
943: error_handler.write_debug( l_Return_Status);
944: END IF;
945:
946: --Bug 2827097
947:

Line 974: l_return_status := Error_Handler.G_STATUS_ERROR ;

970:
971: IF l_return_status = 'N'
972: THEN
973: -- Added for Bug1609574
974: l_return_status := Error_Handler.G_STATUS_ERROR ;
975: l_Token_Tbl(1).token_name := 'OP_SEQ_NUMBER';
976: l_Token_Tbl(1).token_value :=
977: l_rev_operation_rec.operation_sequence_number ;
978:

Line 979: Error_Handler.Add_Error_Token

975: l_Token_Tbl(1).token_name := 'OP_SEQ_NUMBER';
976: l_Token_Tbl(1).token_value :=
977: l_rev_operation_rec.operation_sequence_number ;
978:
979: Error_Handler.Add_Error_Token
980: ( p_message_name => 'BOM_OP_CREATE_REC_NOT_FOUND'
981: , p_mesg_token_tbl => l_Mesg_Token_Tbl
982: , p_token_tbl => l_Token_Tbl
983: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 987: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

983: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
984: );
985:
986: RAISE EXC_SEV_QUIT_RECORD;
987: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
988: THEN
989: RAISE EXC_UNEXP_SKIP_OBJECT;
990: ELSIF l_return_status ='S' AND
991: l_Mesg_Token_Tbl.COUNT <>0

Line 993: Eco_Error_Handler.Log_Error

989: RAISE EXC_UNEXP_SKIP_OBJECT;
990: ELSIF l_return_status ='S' AND
991: l_Mesg_Token_Tbl.COUNT <>0
992: THEN
993: Eco_Error_Handler.Log_Error
994: ( p_rev_operation_tbl => l_rev_operation_tbl
995: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
996: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
997: , p_mesg_token_tbl => l_mesg_token_tbl

Line 999: , p_error_level => Error_Handler.G_OP_LEVEL

995: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
996: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
997: , p_mesg_token_tbl => l_mesg_token_tbl
998: , p_error_status => 'W'
999: , p_error_level => Error_Handler.G_OP_LEVEL
1000: , p_entity_index => I
1001: , x_eco_rec => l_eco_rec
1002: , x_eco_revision_tbl => l_eco_revision_tbl
1003: , x_revised_item_tbl => l_revised_item_tbl

Line 1030: error_handler.write_debug('before entity_defaulting , the return status is');

1026: THEN
1027: --dbms_output.put_line('Entity Defaulting');
1028: IF BOM_Globals.get_debug = 'Y'
1029: THEN
1030: error_handler.write_debug('before entity_defaulting , the return status is');
1031: error_handler.write_debug( l_Return_Status);
1032: END IF;
1033:
1034: Bom_Default_Op_Seq.Entity_Defaulting

Line 1031: error_handler.write_debug( l_Return_Status);

1027: --dbms_output.put_line('Entity Defaulting');
1028: IF BOM_Globals.get_debug = 'Y'
1029: THEN
1030: error_handler.write_debug('before entity_defaulting , the return status is');
1031: error_handler.write_debug( l_Return_Status);
1032: END IF;
1033:
1034: Bom_Default_Op_Seq.Entity_Defaulting
1035: ( p_rev_operation_rec => l_rev_operation_rec

Line 1048: IF l_return_status = Error_Handler.G_STATUS_ERROR

1044: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_operation_rec.item_sequence_number));
1045:
1046: --dbms_output.put_line('return_status: ' || l_return_status);
1047:
1048: IF l_return_status = Error_Handler.G_STATUS_ERROR
1049: THEN
1050: RAISE EXC_SEV_QUIT_RECORD;
1051: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1052: THEN

Line 1051: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1047:
1048: IF l_return_status = Error_Handler.G_STATUS_ERROR
1049: THEN
1050: RAISE EXC_SEV_QUIT_RECORD;
1051: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1052: THEN
1053: RAISE EXC_UNEXP_SKIP_OBJECT;
1054: ELSIF l_return_status ='S' AND
1055: l_Mesg_Token_Tbl.COUNT <>0

Line 1057: Eco_Error_Handler.Log_Error

1053: RAISE EXC_UNEXP_SKIP_OBJECT;
1054: ELSIF l_return_status ='S' AND
1055: l_Mesg_Token_Tbl.COUNT <>0
1056: THEN
1057: Eco_Error_Handler.Log_Error
1058: ( p_rev_operation_tbl => l_rev_operation_tbl
1059: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1060: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1061: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1063: , p_error_level => Error_Handler.G_OP_LEVEL

1059: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1060: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1061: , p_mesg_token_tbl => l_mesg_token_tbl
1062: , p_error_status => 'W'
1063: , p_error_level => Error_Handler.G_OP_LEVEL
1064: , p_entity_index => I
1065: , x_eco_rec => l_eco_rec
1066: , x_eco_revision_tbl => l_eco_revision_tbl
1067: , x_revised_item_tbl => l_revised_item_tbl

Line 1084: error_handler.write_debug('before entity validation , the return status is');

1080: THEN
1081:
1082: IF BOM_Globals.get_debug = 'Y'
1083: THEN
1084: error_handler.write_debug('before entity validation , the return status is');
1085: error_handler.write_debug( l_Return_Status);
1086: END IF;
1087:
1088: --dbms_output.put_line('Entity validation');

Line 1085: error_handler.write_debug( l_Return_Status);

1081:
1082: IF BOM_Globals.get_debug = 'Y'
1083: THEN
1084: error_handler.write_debug('before entity validation , the return status is');
1085: error_handler.write_debug( l_Return_Status);
1086: END IF;
1087:
1088: --dbms_output.put_line('Entity validation');
1089: IF l_rev_operation_rec.transaction_type = 'DELETE'

Line 1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');

1097: );*/
1098: ELSE
1099: IF BOM_Globals.get_debug = 'Y'
1100: THEN
1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');
1102: error_handler.write_debug( l_Return_Status);
1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);

Line 1102: error_handler.write_debug( l_Return_Status);

1098: ELSE
1099: IF BOM_Globals.get_debug = 'Y'
1100: THEN
1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');
1102: error_handler.write_debug( l_Return_Status);
1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:

Line 1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);

1099: IF BOM_Globals.get_debug = 'Y'
1100: THEN
1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');
1102: error_handler.write_debug( l_Return_Status);
1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );

Line 1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);

1100: THEN
1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');
1102: error_handler.write_debug( l_Return_Status);
1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );

Line 1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);

1101: error_handler.write_debug('before calling Bom_Validate_Op_Seq.Check_Entity,the return status is');
1102: error_handler.write_debug( l_Return_Status);
1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );

Line 1107: error_handler.write_debug( 'then all others:' );

1103: error_handler.write_debug( l_rev_operation_rec.operation_sequence_number);
1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );

Line 1108: error_handler.write_debug( l_rev_operation_rec.eco_name );

1104: error_handler.write_debug( l_rev_operation_rec.count_point_type);
1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );

Line 1109: error_handler.write_debug( l_rev_operation_rec.organization_code );

1105: error_handler.write_debug( l_rev_operation_rec.backflush_flag);
1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );

Line 1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );

1106:
1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );

Line 1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );

1107: error_handler.write_debug( 'then all others:' );
1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );

Line 1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );

1108: error_handler.write_debug( l_rev_operation_rec.eco_name );
1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);

Line 1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );

1109: error_handler.write_debug( l_rev_operation_rec.organization_code );
1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );

Line 1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );

1110: error_handler.write_debug( l_rev_operation_rec.revised_item_name );
1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );

Line 1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );

1111: error_handler.write_debug( l_rev_operation_rec.new_revised_item_revision );
1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );

Line 1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);

1112: error_handler.write_debug( l_rev_operation_rec.ACD_Type );
1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );

Line 1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );

1113: error_handler.write_debug( l_rev_operation_rec.Alternate_Routing_Code );
1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );

Line 1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );

1114: error_handler.write_debug( l_rev_operation_rec.Operation_Type );
1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);

Line 1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );

1115: error_handler.write_debug( l_rev_operation_rec.Start_Effective_Date );
1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );

Line 1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );

1116: error_handler.write_debug( l_rev_operation_rec.new_operation_sequence_number);
1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );

Line 1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );

1117: error_handler.write_debug( l_rev_operation_rec.Old_Operation_Sequence_Number );
1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );

Line 1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);

1118: error_handler.write_debug( l_rev_operation_rec.Old_Start_Effective_Date );
1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );

Line 1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );

1119: error_handler.write_debug( l_rev_operation_rec.Standard_Operation_Code );
1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );

Line 1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );

1120: error_handler.write_debug( l_rev_operation_rec.Department_Code );
1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );

Line 1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );

1121: error_handler.write_debug( l_rev_operation_rec.Op_Lead_Time_Percent );
1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );

Line 1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );

1122: error_handler.write_debug( l_rev_operation_rec.Minimum_Transfer_Quantity);
1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);

Line 1127: error_handler.write_debug( l_rev_operation_rec.Yield );

1123: error_handler.write_debug( l_rev_operation_rec.Operation_Description );
1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');

Line 1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );

1124: error_handler.write_debug( l_rev_operation_rec.Disable_Date );
1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );

Line 1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );

1125: error_handler.write_debug( l_rev_operation_rec.Option_Dependent_Flag );
1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );

Line 1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);

1126: error_handler.write_debug( l_rev_operation_rec.Reference_Flag );
1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );
1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );

Line 1131: error_handler.write_debug( 'After attribute_category');

1127: error_handler.write_debug( l_rev_operation_rec.Yield );
1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );
1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );
1135: END IF;

Line 1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );

1128: error_handler.write_debug( l_rev_operation_rec.Cumulative_Yield );
1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );
1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );
1135: END IF;
1136:

Line 1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );

1129: error_handler.write_debug( l_rev_operation_rec.Cancel_Comments );
1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );
1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );
1135: END IF;
1136:
1137:

Line 1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );

1130: error_handler.write_debug( l_rev_operation_rec.Attribute_category);
1131: error_handler.write_debug( 'After attribute_category');
1132: error_handler.write_debug( l_rev_operation_rec.Original_System_Reference );
1133: error_handler.write_debug( l_rev_operation_rec.Transaction_Type );
1134: error_handler.write_debug( l_rev_operation_rec.Return_Status );
1135: END IF;
1136:
1137:
1138:

Line 1156: IF l_return_status = Error_Handler.G_STATUS_ERROR

1152: END IF;
1153:
1154: --dbms_output.put_line('return_status: ' || l_return_status);
1155:
1156: IF l_return_status = Error_Handler.G_STATUS_ERROR
1157: THEN
1158: RAISE EXC_SEV_QUIT_RECORD;
1159: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1160: THEN

Line 1159: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1155:
1156: IF l_return_status = Error_Handler.G_STATUS_ERROR
1157: THEN
1158: RAISE EXC_SEV_QUIT_RECORD;
1159: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1160: THEN
1161: RAISE EXC_UNEXP_SKIP_OBJECT;
1162: ELSIF l_return_status ='S' AND
1163: l_Mesg_Token_Tbl.COUNT <>0

Line 1166: Eco_Error_Handler.Log_Error

1162: ELSIF l_return_status ='S' AND
1163: l_Mesg_Token_Tbl.COUNT <>0
1164: THEN
1165: --dbms_output.put_line('logging warnings');
1166: Eco_Error_Handler.Log_Error
1167: ( p_rev_operation_tbl => l_rev_operation_tbl
1168: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1169: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1170: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1172: , p_error_level => Error_Handler.G_OP_LEVEL

1168: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1169: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1170: , p_mesg_token_tbl => l_mesg_token_tbl
1171: , p_error_status => 'W'
1172: , p_error_level => Error_Handler.G_OP_LEVEL
1173: , p_entity_index => I
1174: , x_eco_rec => l_eco_rec
1175: , x_eco_revision_tbl => l_eco_revision_tbl
1176: , x_revised_item_tbl => l_revised_item_tbl

Line 1195: error_handler.write_debug('Before write_to_db, the return status is');

1191: THEN
1192:
1193: IF BOM_Globals.get_debug = 'Y'
1194: THEN
1195: error_handler.write_debug('Before write_to_db, the return status is');
1196: error_handler.write_debug( l_Return_Status);
1197: error_handler.write_debug( l_rev_op_unexp_rec.operation_sequence_id);
1198: END IF;
1199: bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line 1196: error_handler.write_debug( l_Return_Status);

1192:
1193: IF BOM_Globals.get_debug = 'Y'
1194: THEN
1195: error_handler.write_debug('Before write_to_db, the return status is');
1196: error_handler.write_debug( l_Return_Status);
1197: error_handler.write_debug( l_rev_op_unexp_rec.operation_sequence_id);
1198: END IF;
1199: bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);
1200: bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line 1197: error_handler.write_debug( l_rev_op_unexp_rec.operation_sequence_id);

1193: IF BOM_Globals.get_debug = 'Y'
1194: THEN
1195: error_handler.write_debug('Before write_to_db, the return status is');
1196: error_handler.write_debug( l_Return_Status);
1197: error_handler.write_debug( l_rev_op_unexp_rec.operation_sequence_id);
1198: END IF;
1199: bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);
1200: bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);
1201: bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line 1212: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1208: , x_mesg_token_tbl => l_mesg_token_tbl
1209: , x_return_status => l_return_status
1210: ) ;
1211:
1212: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1213: THEN
1214: l_other_message := 'BOM_OP_WRITES_UNEXP_SKIP';
1215: l_other_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
1216: l_other_token_tbl(1).token_value :=

Line 1222: ECO_Error_Handler.Log_Error

1218: RAISE EXC_UNEXP_SKIP_OBJECT ;
1219: ELSIF l_return_status ='S' AND
1220: l_mesg_token_tbl .COUNT <>0
1221: THEN
1222: ECO_Error_Handler.Log_Error
1223: ( p_rev_operation_tbl => l_rev_operation_tbl
1224: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1225: , p_rev_sub_resource_tbl=> l_rev_sub_resource_tbl
1226: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1228: , p_error_level => Error_Handler.G_OP_LEVEL

1224: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1225: , p_rev_sub_resource_tbl=> l_rev_sub_resource_tbl
1226: , p_mesg_token_tbl => l_mesg_token_tbl
1227: , p_error_status => 'W'
1228: , p_error_level => Error_Handler.G_OP_LEVEL
1229: , p_entity_index => I
1230: , x_ECO_rec => l_ECO_rec
1231: , x_eco_revision_tbl => l_eco_revision_tbl
1232: , x_revised_item_tbl => l_revised_item_tbl

Line 1253: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1249: );
1250:
1251: --dbms_output.put_line('return_status: ' || l_return_status);
1252:
1253: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1254: THEN
1255: RAISE EXC_UNEXP_SKIP_OBJECT;
1256: ELSIF l_return_status ='S' AND
1257: l_Mesg_Token_Tbl.COUNT <>0

Line 1259: Eco_Error_Handler.Log_Error

1255: RAISE EXC_UNEXP_SKIP_OBJECT;
1256: ELSIF l_return_status ='S' AND
1257: l_Mesg_Token_Tbl.COUNT <>0
1258: THEN
1259: Eco_Error_Handler.Log_Error
1260: ( p_rev_operation_tbl => l_rev_operation_tbl
1261: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1262: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1263: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1265: , p_error_level => Error_Handler.G_OP_LEVEL

1261: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1262: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1263: , p_mesg_token_tbl => l_mesg_token_tbl
1264: , p_error_status => 'W'
1265: , p_error_level => Error_Handler.G_OP_LEVEL
1266: , p_entity_index => I
1267: , x_eco_rec => l_eco_rec
1268: , x_eco_revision_tbl => l_eco_revision_tbl
1269: , x_revised_item_tbl => l_revised_item_tbl

Line 1285: error_handler.write_debug( 'after checck entity ');

1281:
1282:
1283: IF BOM_Globals.get_debug = 'Y'
1284: THEN
1285: error_handler.write_debug( 'after checck entity ');
1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:

Line 1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);

1282:
1283: IF BOM_Globals.get_debug = 'Y'
1284: THEN
1285: error_handler.write_debug( 'after checck entity ');
1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );

Line 1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);

1283: IF BOM_Globals.get_debug = 'Y'
1284: THEN
1285: error_handler.write_debug( 'after checck entity ');
1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );

Line 1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);

1284: THEN
1285: error_handler.write_debug( 'after checck entity ');
1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );

Line 1290: error_handler.write_debug( 'then all others:' );

1286: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );

Line 1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );

1287: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );

Line 1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );

1288: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );

Line 1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );

1289:
1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );

Line 1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );

1290: error_handler.write_debug( 'then all others:' );
1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );

Line 1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );

1291: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);

Line 1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );

1292: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );

Line 1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );

1293: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );

Line 1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );

1294: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );

Line 1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);

1295: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );

Line 1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );

1296: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );

Line 1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );

1297: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);

Line 1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );

1298: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );

Line 1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );

1299: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );

Line 1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );

1300: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );

Line 1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);

1301: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );

Line 1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );

1302: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );

Line 1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );

1303: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );

Line 1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );

1304: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );

Line 1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );

1305: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);

Line 1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );

1306: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');

Line 1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );

1307: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );

Line 1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );

1308: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );

Line 1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);

1309: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );

Line 1314: error_handler.write_debug( 'After attribute_category');

1310: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );

Line 1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );

1311: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );

Line 1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );

1312: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );

Line 1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );

1313: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );

Line 1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );

1314: error_handler.write_debug( 'After attribute_category');
1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );

Line 1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );

1315: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );

Line 1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );

1316: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );

Line 1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );

1317: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );

Line 1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );

1318: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:

Line 1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );

1319: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:
1327: error_handler.write_debug('End of Rev_Op, the return status is');

Line 1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );

1320: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:
1327: error_handler.write_debug('End of Rev_Op, the return status is');
1328: error_handler.write_debug( l_Return_Status);

Line 1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );

1321: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1322: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:
1327: error_handler.write_debug('End of Rev_Op, the return status is');
1328: error_handler.write_debug( l_Return_Status);
1329: END IF;

Line 1327: error_handler.write_debug('End of Rev_Op, the return status is');

1323: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:
1327: error_handler.write_debug('End of Rev_Op, the return status is');
1328: error_handler.write_debug( l_Return_Status);
1329: END IF;
1330:
1331: EXCEPTION

Line 1328: error_handler.write_debug( l_Return_Status);

1324: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1325: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1326:
1327: error_handler.write_debug('End of Rev_Op, the return status is');
1328: error_handler.write_debug( l_Return_Status);
1329: END IF;
1330:
1331: EXCEPTION
1332:

Line 1337: Eco_Error_Handler.Log_Error

1333: WHEN EXC_SEV_QUIT_RECORD THEN
1334:
1335: --dbms_output.put_line('Expected error generated');
1336: l_rev_operation_tbl(I) := l_rev_operation_rec;
1337: Eco_Error_Handler.Log_Error
1338: ( p_rev_operation_tbl => l_rev_operation_tbl
1339: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1340: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1341: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1343: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1339: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1340: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1341: , p_mesg_token_tbl => l_mesg_token_tbl
1342: , p_error_status => FND_API.G_RET_STS_ERROR
1343: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1344: , p_error_level => Error_Handler.G_OP_LEVEL
1345: , p_entity_index => I
1346: , x_eco_rec => l_eco_rec
1347: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1344: , p_error_level => Error_Handler.G_OP_LEVEL

1340: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1341: , p_mesg_token_tbl => l_mesg_token_tbl
1342: , p_error_status => FND_API.G_RET_STS_ERROR
1343: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1344: , p_error_level => Error_Handler.G_OP_LEVEL
1345: , p_entity_index => I
1346: , x_eco_rec => l_eco_rec
1347: , x_eco_revision_tbl => l_eco_revision_tbl
1348: , x_revised_item_tbl => l_revised_item_tbl

Line 1375: Eco_Error_Handler.Log_Error

1371:
1372: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1373:
1374: --dbms_output.put_line('Unexpected error generated');
1375: Eco_Error_Handler.Log_Error
1376: ( p_rev_operation_tbl => l_rev_operation_tbl
1377: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1378: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1379: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1380: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1376: ( p_rev_operation_tbl => l_rev_operation_tbl
1377: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1378: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1379: , p_mesg_token_tbl => l_mesg_token_tbl
1380: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1381: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1382: , p_other_message => l_other_message
1383: , p_other_token_tbl => l_other_token_tbl
1384: , p_error_level => Error_Handler.G_OP_LEVEL

Line 1381: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1377: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1378: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1379: , p_mesg_token_tbl => l_mesg_token_tbl
1380: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1381: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1382: , p_other_message => l_other_message
1383: , p_other_token_tbl => l_other_token_tbl
1384: , p_error_level => Error_Handler.G_OP_LEVEL
1385: , p_entity_index => I

Line 1384: , p_error_level => Error_Handler.G_OP_LEVEL

1380: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1381: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1382: , p_other_message => l_other_message
1383: , p_other_token_tbl => l_other_token_tbl
1384: , p_error_level => Error_Handler.G_OP_LEVEL
1385: , p_entity_index => I
1386: , x_ECO_rec => l_ECO_rec
1387: , x_eco_revision_tbl => l_eco_revision_tbl
1388: , x_revised_item_tbl => l_revised_item_tbl

Line 1455: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1454: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1455: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1456: , x_return_status IN OUT NOCOPY VARCHAR2
1457: )
1458: IS
1459:

Line 1460: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1456: , x_return_status IN OUT NOCOPY VARCHAR2
1457: )
1458: IS
1459:
1460: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1461: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1462: l_other_message VARCHAR2(50);
1463: l_err_text VARCHAR2(2000);
1464: l_valid BOOLEAN := TRUE;

Line 1461: l_other_token_tbl Error_Handler.Token_Tbl_Type;

1457: )
1458: IS
1459:
1460: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1461: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1462: l_other_message VARCHAR2(50);
1463: l_err_text VARCHAR2(2000);
1464: l_valid BOOLEAN := TRUE;
1465: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1481: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1480: l_return_value NUMBER;
1481: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1482:
1483: EXC_SEV_QUIT_RECORD EXCEPTION;
1484: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1485:

Line 1520: IF l_return_status = Error_Handler.G_STATUS_ERROR

1516: );
1517:
1518: --dbms_output.put_line('return_status: ' || l_return_status);
1519:
1520: IF l_return_status = Error_Handler.G_STATUS_ERROR
1521: THEN
1522: RAISE EXC_SEV_QUIT_RECORD;
1523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1524: THEN

Line 1523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1519:
1520: IF l_return_status = Error_Handler.G_STATUS_ERROR
1521: THEN
1522: RAISE EXC_SEV_QUIT_RECORD;
1523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1524: THEN
1525: RAISE EXC_UNEXP_SKIP_OBJECT;
1526: END IF;
1527: END IF;

Line 1562: IF l_return_status = Error_Handler.G_STATUS_ERROR

1558: END IF;
1559:
1560: --dbms_output.put_line('return_status: ' || l_return_status);
1561:
1562: IF l_return_status = Error_Handler.G_STATUS_ERROR
1563: THEN
1564: RAISE EXC_SEV_QUIT_RECORD;
1565: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1566: THEN

Line 1565: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1561:
1562: IF l_return_status = Error_Handler.G_STATUS_ERROR
1563: THEN
1564: RAISE EXC_SEV_QUIT_RECORD;
1565: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1566: THEN
1567: RAISE EXC_UNEXP_SKIP_OBJECT;
1568: ELSIF l_return_status ='S' AND
1569: l_Mesg_Token_Tbl.COUNT <>0

Line 1571: Eco_Error_Handler.Log_Error

1567: RAISE EXC_UNEXP_SKIP_OBJECT;
1568: ELSIF l_return_status ='S' AND
1569: l_Mesg_Token_Tbl.COUNT <>0
1570: THEN
1571: Eco_Error_Handler.Log_Error
1572: ( p_ref_designator_tbl => l_ref_designator_tbl
1573: , p_sub_component_tbl => l_sub_component_tbl
1574: , p_mesg_token_tbl => l_mesg_token_tbl
1575: , p_error_status => 'W'

Line 1608: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1604: );
1605:
1606: --dbms_output.put_line('return_status: ' || l_return_status);
1607:
1608: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1609: THEN
1610: RAISE EXC_UNEXP_SKIP_OBJECT;
1611: ELSIF l_return_status ='S' AND
1612: l_Mesg_Token_Tbl.COUNT <>0

Line 1614: Eco_Error_Handler.Log_Error

1610: RAISE EXC_UNEXP_SKIP_OBJECT;
1611: ELSIF l_return_status ='S' AND
1612: l_Mesg_Token_Tbl.COUNT <>0
1613: THEN
1614: Eco_Error_Handler.Log_Error
1615: ( p_ref_designator_tbl => l_ref_designator_tbl
1616: , p_sub_component_tbl => l_sub_component_tbl
1617: , p_mesg_token_tbl => l_mesg_token_tbl
1618: , p_error_status => 'W'

Line 1642: Eco_Error_Handler.Log_Error

1638: WHEN EXC_SEV_QUIT_RECORD THEN
1639:
1640: --dbms_output.put_line('Expected error generated');
1641: l_sub_component_tbl(I) := l_sub_component_rec;
1642: Eco_Error_Handler.Log_Error
1643: ( p_ref_designator_tbl => l_ref_designator_tbl
1644: , p_sub_component_tbl => l_sub_component_tbl
1645: , p_mesg_token_tbl => l_mesg_token_tbl
1646: , p_error_status => FND_API.G_RET_STS_ERROR

Line 1647: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1643: ( p_ref_designator_tbl => l_ref_designator_tbl
1644: , p_sub_component_tbl => l_sub_component_tbl
1645: , p_mesg_token_tbl => l_mesg_token_tbl
1646: , p_error_status => FND_API.G_RET_STS_ERROR
1647: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1648: , p_error_level => 6
1649: , p_entity_index => I
1650: , x_eco_rec => l_eco_rec
1651: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1679: Eco_Error_Handler.Log_Error

1675:
1676: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1677:
1678: --dbms_output.put_line('Unexpected error generated');
1679: Eco_Error_Handler.Log_Error
1680: ( p_sub_component_tbl => l_sub_component_tbl
1681: , p_mesg_token_tbl => l_mesg_token_tbl
1682: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1683: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 1682: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1678: --dbms_output.put_line('Unexpected error generated');
1679: Eco_Error_Handler.Log_Error
1680: ( p_sub_component_tbl => l_sub_component_tbl
1681: , p_mesg_token_tbl => l_mesg_token_tbl
1682: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1683: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1684: , p_other_message => l_other_message
1685: , p_other_token_tbl => l_other_token_tbl
1686: , p_error_level => 6

Line 1683: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1679: Eco_Error_Handler.Log_Error
1680: ( p_sub_component_tbl => l_sub_component_tbl
1681: , p_mesg_token_tbl => l_mesg_token_tbl
1682: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1683: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1684: , p_other_message => l_other_message
1685: , p_other_token_tbl => l_other_token_tbl
1686: , p_error_level => 6
1687: , p_entity_index => I

Line 1755: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1754: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1755: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1756: , x_return_status IN OUT NOCOPY VARCHAR2
1757: )
1758: IS
1759:

Line 1760: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1756: , x_return_status IN OUT NOCOPY VARCHAR2
1757: )
1758: IS
1759:
1760: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1761: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1762: l_other_message VARCHAR2(50);
1763: l_err_text VARCHAR2(2000);
1764: l_valid BOOLEAN := TRUE;

Line 1761: l_other_token_tbl Error_Handler.Token_Tbl_Type;

1757: )
1758: IS
1759:
1760: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1761: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1762: l_other_message VARCHAR2(50);
1763: l_err_text VARCHAR2(2000);
1764: l_valid BOOLEAN := TRUE;
1765: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1781: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1780: l_return_value NUMBER;
1781: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1782:
1783: EXC_SEV_QUIT_RECORD EXCEPTION;
1784: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1785:

Line 1820: IF l_return_status = Error_Handler.G_STATUS_ERROR

1816: );
1817:
1818: --dbms_output.put_line('return_status: ' || l_return_status);
1819:
1820: IF l_return_status = Error_Handler.G_STATUS_ERROR
1821: THEN
1822: RAISE EXC_SEV_QUIT_RECORD;
1823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1824: THEN

Line 1823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1819:
1820: IF l_return_status = Error_Handler.G_STATUS_ERROR
1821: THEN
1822: RAISE EXC_SEV_QUIT_RECORD;
1823: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1824: THEN
1825: RAISE EXC_UNEXP_SKIP_OBJECT;
1826: END IF;
1827: END IF;

Line 1855: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1851: );
1852:
1853: --dbms_output.put_line('return_status: ' || l_return_status);
1854:
1855: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1856: THEN
1857: RAISE EXC_UNEXP_SKIP_OBJECT;
1858: ELSIF l_return_status ='S' AND
1859: l_Mesg_Token_Tbl.COUNT <>0

Line 1861: Eco_Error_Handler.Log_Error

1857: RAISE EXC_UNEXP_SKIP_OBJECT;
1858: ELSIF l_return_status ='S' AND
1859: l_Mesg_Token_Tbl.COUNT <>0
1860: THEN
1861: Eco_Error_Handler.Log_Error
1862: ( p_ref_designator_tbl => l_ref_designator_tbl
1863: , p_sub_component_tbl => l_sub_component_tbl
1864: , p_mesg_token_tbl => l_mesg_token_tbl
1865: , p_error_status => 'W'

Line 1889: Eco_Error_Handler.Log_Error

1885: WHEN EXC_SEV_QUIT_RECORD THEN
1886:
1887: --dbms_output.put_line('Expected error generated');
1888: l_ref_designator_tbl(I) := l_ref_designator_rec;
1889: Eco_Error_Handler.Log_Error
1890: ( p_ref_designator_tbl => l_ref_designator_tbl
1891: , p_sub_component_tbl => l_sub_component_tbl
1892: , p_mesg_token_tbl => l_mesg_token_tbl
1893: , p_error_status => FND_API.G_RET_STS_ERROR

Line 1894: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1890: ( p_ref_designator_tbl => l_ref_designator_tbl
1891: , p_sub_component_tbl => l_sub_component_tbl
1892: , p_mesg_token_tbl => l_mesg_token_tbl
1893: , p_error_status => FND_API.G_RET_STS_ERROR
1894: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1895: , p_error_level => 5
1896: , p_entity_index => I
1897: , x_eco_rec => l_eco_rec
1898: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1926: Eco_Error_Handler.Log_Error

1922:
1923: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1924:
1925: --dbms_output.put_line('Unexpected error generated');
1926: Eco_Error_Handler.Log_Error
1927: ( p_sub_component_tbl => l_sub_component_tbl
1928: , p_mesg_token_tbl => l_mesg_token_tbl
1929: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1930: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 1929: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1925: --dbms_output.put_line('Unexpected error generated');
1926: Eco_Error_Handler.Log_Error
1927: ( p_sub_component_tbl => l_sub_component_tbl
1928: , p_mesg_token_tbl => l_mesg_token_tbl
1929: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1930: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1931: , p_other_message => l_other_message
1932: , p_other_token_tbl => l_other_token_tbl
1933: , p_error_level => 5

Line 1930: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1926: Eco_Error_Handler.Log_Error
1927: ( p_sub_component_tbl => l_sub_component_tbl
1928: , p_mesg_token_tbl => l_mesg_token_tbl
1929: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1930: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1931: , p_other_message => l_other_message
1932: , p_other_token_tbl => l_other_token_tbl
1933: , p_error_level => 5
1934: , p_entity_index => I

Line 2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2008: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: , x_return_status IN OUT NOCOPY VARCHAR2
2011: )
2012: IS
2013:

Line 2014: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2010: , x_return_status IN OUT NOCOPY VARCHAR2
2011: )
2012: IS
2013:
2014: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2015: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2016: l_other_message VARCHAR2(50);
2017: l_err_text VARCHAR2(2000);
2018: l_valid BOOLEAN := TRUE;

Line 2015: l_other_token_tbl Error_Handler.Token_Tbl_Type;

2011: )
2012: IS
2013:
2014: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2015: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2016: l_other_message VARCHAR2(50);
2017: l_err_text VARCHAR2(2000);
2018: l_valid BOOLEAN := TRUE;
2019: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2035: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2034: l_return_value NUMBER;
2035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2036: l_query_op_seq_num NUMBER := NULL;
2037: l_query_effective_date DATE := NULL;
2038: l_query_from_unit_number VARCHAR2(30) := NULL;
2039:

Line 2078: IF l_return_status = Error_Handler.G_STATUS_ERROR

2074:
2075:
2076: --dbms_output.put_line('return_status: ' || l_return_status);
2077:
2078: IF l_return_status = Error_Handler.G_STATUS_ERROR
2079: THEN
2080: RAISE EXC_SEV_QUIT_RECORD;
2081: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2082: THEN

Line 2081: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2077:
2078: IF l_return_status = Error_Handler.G_STATUS_ERROR
2079: THEN
2080: RAISE EXC_SEV_QUIT_RECORD;
2081: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2082: THEN
2083: RAISE EXC_UNEXP_SKIP_OBJECT;
2084: END IF;
2085: END IF;

Line 2114: IF l_return_status = Error_Handler.G_STATUS_ERROR

2110: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_component_rec.item_sequence_number));
2111:
2112: --dbms_output.put_line('return_status: ' || l_return_status);
2113:
2114: IF l_return_status = Error_Handler.G_STATUS_ERROR
2115: THEN
2116: RAISE EXC_SEV_QUIT_RECORD;
2117: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2118: THEN

Line 2117: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2113:
2114: IF l_return_status = Error_Handler.G_STATUS_ERROR
2115: THEN
2116: RAISE EXC_SEV_QUIT_RECORD;
2117: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2118: THEN
2119: RAISE EXC_UNEXP_SKIP_OBJECT;
2120: ELSIF l_return_status ='S' AND
2121: l_Mesg_Token_Tbl.COUNT <>0

Line 2123: Eco_Error_Handler.Log_Error

2119: RAISE EXC_UNEXP_SKIP_OBJECT;
2120: ELSIF l_return_status ='S' AND
2121: l_Mesg_Token_Tbl.COUNT <>0
2122: THEN
2123: Eco_Error_Handler.Log_Error
2124: ( p_rev_component_tbl => l_rev_component_tbl
2125: , p_ref_designator_tbl => l_ref_designator_tbl
2126: , p_sub_component_tbl => l_sub_component_tbl
2127: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2184: l_return_status := Error_Handler.G_STATUS_ERROR ;

2180:
2181: IF l_return_status = 'N'
2182: THEN
2183: -- Added for Bug1609574
2184: l_return_status := Error_Handler.G_STATUS_ERROR ;
2185: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
2186: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;
2187:
2188: Error_Handler.Add_Error_Token

Line 2188: Error_Handler.Add_Error_Token

2184: l_return_status := Error_Handler.G_STATUS_ERROR ;
2185: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
2186: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;
2187:
2188: Error_Handler.Add_Error_Token
2189: ( p_message_name => 'BOM_CMP_CREATE_REC_NOT_FOUND'
2190: , p_mesg_token_tbl => l_Mesg_Token_Tbl
2191: , p_token_tbl => l_Token_Tbl
2192: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2196: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2192: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2193: );
2194:
2195: RAISE EXC_SEV_QUIT_RECORD;
2196: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2197: THEN
2198: RAISE EXC_UNEXP_SKIP_OBJECT;
2199: ELSIF l_return_status ='S' AND
2200: l_Mesg_Token_Tbl.COUNT <>0

Line 2202: Eco_Error_Handler.Log_Error

2198: RAISE EXC_UNEXP_SKIP_OBJECT;
2199: ELSIF l_return_status ='S' AND
2200: l_Mesg_Token_Tbl.COUNT <>0
2201: THEN
2202: Eco_Error_Handler.Log_Error
2203: ( p_rev_component_tbl => l_rev_component_tbl
2204: , p_ref_designator_tbl => l_ref_designator_tbl
2205: , p_sub_component_tbl => l_sub_component_tbl
2206: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2247: IF l_return_status = Error_Handler.G_STATUS_ERROR

2243: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_component_rec.item_sequence_number));
2244:
2245: --dbms_output.put_line('return_status: ' || l_return_status);
2246:
2247: IF l_return_status = Error_Handler.G_STATUS_ERROR
2248: THEN
2249: RAISE EXC_SEV_QUIT_RECORD;
2250: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2251: THEN

Line 2250: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2246:
2247: IF l_return_status = Error_Handler.G_STATUS_ERROR
2248: THEN
2249: RAISE EXC_SEV_QUIT_RECORD;
2250: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2251: THEN
2252: RAISE EXC_UNEXP_SKIP_OBJECT;
2253: ELSIF l_return_status ='S' AND
2254: l_Mesg_Token_Tbl.COUNT <>0

Line 2256: Eco_Error_Handler.Log_Error

2252: RAISE EXC_UNEXP_SKIP_OBJECT;
2253: ELSIF l_return_status ='S' AND
2254: l_Mesg_Token_Tbl.COUNT <>0
2255: THEN
2256: Eco_Error_Handler.Log_Error
2257: ( p_rev_component_tbl => l_rev_component_tbl
2258: , p_ref_designator_tbl => l_ref_designator_tbl
2259: , p_sub_component_tbl => l_sub_component_tbl
2260: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2305: IF l_return_status = Error_Handler.G_STATUS_ERROR

2301: END IF;
2302:
2303: --dbms_output.put_line('return_status: ' || l_return_status);
2304:
2305: IF l_return_status = Error_Handler.G_STATUS_ERROR
2306: THEN
2307: RAISE EXC_SEV_QUIT_RECORD;
2308: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2309: THEN

Line 2308: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2304:
2305: IF l_return_status = Error_Handler.G_STATUS_ERROR
2306: THEN
2307: RAISE EXC_SEV_QUIT_RECORD;
2308: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2309: THEN
2310: RAISE EXC_UNEXP_SKIP_OBJECT;
2311: ELSIF l_return_status ='S' AND
2312: l_Mesg_Token_Tbl.COUNT <>0

Line 2315: Eco_Error_Handler.Log_Error

2311: ELSIF l_return_status ='S' AND
2312: l_Mesg_Token_Tbl.COUNT <>0
2313: THEN
2314: --dbms_output.put_line('logging warnings');
2315: Eco_Error_Handler.Log_Error
2316: ( p_rev_component_tbl => l_rev_component_tbl
2317: , p_ref_designator_tbl => l_ref_designator_tbl
2318: , p_sub_component_tbl => l_sub_component_tbl
2319: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2354: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2350: );
2351:
2352: --dbms_output.put_line('return_status: ' || l_return_status);
2353:
2354: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2355: THEN
2356: RAISE EXC_UNEXP_SKIP_OBJECT;
2357: ELSIF l_return_status ='S' AND
2358: l_Mesg_Token_Tbl.COUNT <>0

Line 2360: Eco_Error_Handler.Log_Error

2356: RAISE EXC_UNEXP_SKIP_OBJECT;
2357: ELSIF l_return_status ='S' AND
2358: l_Mesg_Token_Tbl.COUNT <>0
2359: THEN
2360: Eco_Error_Handler.Log_Error
2361: ( p_rev_component_tbl => l_rev_component_tbl
2362: , p_ref_designator_tbl => l_ref_designator_tbl
2363: , p_sub_component_tbl => l_sub_component_tbl
2364: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2389: Eco_Error_Handler.Log_Error

2385: WHEN EXC_SEV_QUIT_RECORD THEN
2386:
2387: --dbms_output.put_line('Expected error generated');
2388: l_rev_component_tbl(I) := l_rev_component_rec;
2389: Eco_Error_Handler.Log_Error
2390: ( p_rev_component_tbl => l_rev_component_tbl
2391: , p_ref_designator_tbl => l_ref_designator_tbl
2392: , p_sub_component_tbl => l_sub_component_tbl
2393: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2395: , p_error_scope => Error_Handler.G_SCOPE_RECORD

2391: , p_ref_designator_tbl => l_ref_designator_tbl
2392: , p_sub_component_tbl => l_sub_component_tbl
2393: , p_mesg_token_tbl => l_mesg_token_tbl
2394: , p_error_status => FND_API.G_RET_STS_ERROR
2395: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2396: , p_error_level => 4
2397: , p_entity_index => I
2398: , x_eco_rec => l_eco_rec
2399: , x_eco_revision_tbl => l_eco_revision_tbl

Line 2428: Eco_Error_Handler.Log_Error

2424:
2425: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2426:
2427: --dbms_output.put_line('Unexpected error generated');
2428: Eco_Error_Handler.Log_Error
2429: ( p_rev_component_tbl => l_rev_component_tbl
2430: , p_ref_designator_tbl => l_ref_designator_tbl
2431: , p_sub_component_tbl => l_sub_component_tbl
2432: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2433: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

2429: ( p_rev_component_tbl => l_rev_component_tbl
2430: , p_ref_designator_tbl => l_ref_designator_tbl
2431: , p_sub_component_tbl => l_sub_component_tbl
2432: , p_mesg_token_tbl => l_mesg_token_tbl
2433: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2434: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2435: , p_other_message => l_other_message
2436: , p_other_token_tbl => l_other_token_tbl
2437: , p_error_level => 4

Line 2434: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

2430: , p_ref_designator_tbl => l_ref_designator_tbl
2431: , p_sub_component_tbl => l_sub_component_tbl
2432: , p_mesg_token_tbl => l_mesg_token_tbl
2433: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2434: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2435: , p_other_message => l_other_message
2436: , p_other_token_tbl => l_other_token_tbl
2437: , p_error_level => 4
2438: , p_entity_index => I

Line 2512: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2511: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2512: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2513: , x_return_status IN OUT NOCOPY VARCHAR2
2514: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2515: )
2516: IS

Line 2518: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2514: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2515: )
2516: IS
2517:
2518: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2519: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2520: l_other_message VARCHAR2(50);
2521: l_err_text VARCHAR2(2000);
2522: l_valid BOOLEAN := TRUE;

Line 2519: l_other_token_tbl Error_Handler.Token_Tbl_Type;

2515: )
2516: IS
2517:
2518: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2519: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2520: l_other_message VARCHAR2(50);
2521: l_err_text VARCHAR2(2000);
2522: l_valid BOOLEAN := TRUE;
2523: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2539: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2537: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2538: l_return_value NUMBER;
2539: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2540:
2541: EXC_SEV_QUIT_RECORD EXCEPTION;
2542: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
2543:

Line 2549: error_handler.write_debug('at the beginning of rev_item procedure');

2545:
2546:
2547: IF BOM_Globals.get_debug = 'Y'
2548: Then
2549: error_handler.write_debug('at the beginning of rev_item procedure');
2550: error_handler.write_debug('revised item count is');
2551: error_handler.write_debug(l_revised_item_tbl.COUNT);
2552:
2553: END IF;

Line 2550: error_handler.write_debug('revised item count is');

2546:
2547: IF BOM_Globals.get_debug = 'Y'
2548: Then
2549: error_handler.write_debug('at the beginning of rev_item procedure');
2550: error_handler.write_debug('revised item count is');
2551: error_handler.write_debug(l_revised_item_tbl.COUNT);
2552:
2553: END IF;
2554:

Line 2551: error_handler.write_debug(l_revised_item_tbl.COUNT);

2547: IF BOM_Globals.get_debug = 'Y'
2548: Then
2549: error_handler.write_debug('at the beginning of rev_item procedure');
2550: error_handler.write_debug('revised item count is');
2551: error_handler.write_debug(l_revised_item_tbl.COUNT);
2552:
2553: END IF;
2554:
2555: -- Begin block that processes revised items. This block holds the exception handlers

Line 2586: error_handler.write_debug('After check existence');

2582: , x_disable_revision => x_disable_revision --Bug no:3034642
2583: );
2584: IF BOM_Globals.get_debug = 'Y'
2585: Then
2586: error_handler.write_debug('After check existence');
2587: error_handler.write_debug( l_Return_Status);
2588: END IF;
2589: --dbms_output.put_line('return_status: ' || l_return_status);
2590:

Line 2587: error_handler.write_debug( l_Return_Status);

2583: );
2584: IF BOM_Globals.get_debug = 'Y'
2585: Then
2586: error_handler.write_debug('After check existence');
2587: error_handler.write_debug( l_Return_Status);
2588: END IF;
2589: --dbms_output.put_line('return_status: ' || l_return_status);
2590:
2591: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2591: IF l_return_status = Error_Handler.G_STATUS_ERROR

2587: error_handler.write_debug( l_Return_Status);
2588: END IF;
2589: --dbms_output.put_line('return_status: ' || l_return_status);
2590:
2591: IF l_return_status = Error_Handler.G_STATUS_ERROR
2592: THEN
2593: RAISE EXC_SEV_QUIT_RECORD;
2594: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2595: THEN

Line 2594: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2590:
2591: IF l_return_status = Error_Handler.G_STATUS_ERROR
2592: THEN
2593: RAISE EXC_SEV_QUIT_RECORD;
2594: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2595: THEN
2596: RAISE EXC_UNEXP_SKIP_OBJECT;
2597: END IF;
2598: END IF;

Line 2616: error_handler.write_debug('After attribute defaulting, the return status is');

2612: , x_return_status => l_Return_Status
2613: );
2614: IF BOM_Globals.get_debug = 'Y'
2615: Then
2616: error_handler.write_debug('After attribute defaulting, the return status is');
2617: error_handler.write_debug( l_Return_Status);
2618: END IF;
2619: --dbms_output.put_line('return_status: ' || l_return_status);
2620:

Line 2617: error_handler.write_debug( l_Return_Status);

2613: );
2614: IF BOM_Globals.get_debug = 'Y'
2615: Then
2616: error_handler.write_debug('After attribute defaulting, the return status is');
2617: error_handler.write_debug( l_Return_Status);
2618: END IF;
2619: --dbms_output.put_line('return_status: ' || l_return_status);
2620:
2621: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2621: IF l_return_status = Error_Handler.G_STATUS_ERROR

2617: error_handler.write_debug( l_Return_Status);
2618: END IF;
2619: --dbms_output.put_line('return_status: ' || l_return_status);
2620:
2621: IF l_return_status = Error_Handler.G_STATUS_ERROR
2622: THEN
2623: RAISE EXC_SEV_QUIT_RECORD;
2624: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2625: THEN

Line 2624: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2620:
2621: IF l_return_status = Error_Handler.G_STATUS_ERROR
2622: THEN
2623: RAISE EXC_SEV_QUIT_RECORD;
2624: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2625: THEN
2626: RAISE EXC_UNEXP_SKIP_OBJECT;
2627: ELSIF l_return_status ='S' AND
2628: l_Mesg_Token_Tbl.COUNT <>0

Line 2630: Eco_Error_Handler.Log_Error

2626: RAISE EXC_UNEXP_SKIP_OBJECT;
2627: ELSIF l_return_status ='S' AND
2628: l_Mesg_Token_Tbl.COUNT <>0
2629: THEN
2630: Eco_Error_Handler.Log_Error
2631: ( p_revised_item_tbl => l_revised_item_tbl
2632: , p_rev_component_tbl => l_rev_component_tbl
2633: , p_ref_designator_tbl => l_ref_designator_tbl
2634: , p_sub_component_tbl => l_sub_component_tbl

Line 2676: error_handler.write_debug('After query row, the return status is');

2672: );
2673:
2674: IF BOM_Globals.get_debug = 'Y'
2675: Then
2676: error_handler.write_debug('After query row, the return status is');
2677: error_handler.write_debug( l_Return_Status);
2678: END IF;
2679:
2680: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2677: error_handler.write_debug( l_Return_Status);

2673:
2674: IF BOM_Globals.get_debug = 'Y'
2675: Then
2676: error_handler.write_debug('After query row, the return status is');
2677: error_handler.write_debug( l_Return_Status);
2678: END IF;
2679:
2680: --dbms_output.put_line('return_status: ' || l_return_status);
2681:

Line 2711: error_handler.write_debug('After eitity default, the return status is');

2707: );
2708:
2709: IF BOM_Globals.get_debug = 'Y'
2710: Then
2711: error_handler.write_debug('After eitity default, the return status is');
2712: error_handler.write_debug( l_Return_Status);
2713: END IF;
2714: --dbms_output.put_line('return_status: ' || l_return_status);
2715:

Line 2712: error_handler.write_debug( l_Return_Status);

2708:
2709: IF BOM_Globals.get_debug = 'Y'
2710: Then
2711: error_handler.write_debug('After eitity default, the return status is');
2712: error_handler.write_debug( l_Return_Status);
2713: END IF;
2714: --dbms_output.put_line('return_status: ' || l_return_status);
2715:
2716: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2716: IF l_return_status = Error_Handler.G_STATUS_ERROR

2712: error_handler.write_debug( l_Return_Status);
2713: END IF;
2714: --dbms_output.put_line('return_status: ' || l_return_status);
2715:
2716: IF l_return_status = Error_Handler.G_STATUS_ERROR
2717: THEN
2718: RAISE EXC_SEV_QUIT_RECORD;
2719: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2720: THEN

Line 2719: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2715:
2716: IF l_return_status = Error_Handler.G_STATUS_ERROR
2717: THEN
2718: RAISE EXC_SEV_QUIT_RECORD;
2719: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2720: THEN
2721: RAISE EXC_UNEXP_SKIP_OBJECT;
2722: ELSIF l_return_status ='S' AND
2723: l_Mesg_Token_Tbl.COUNT <>0

Line 2725: Eco_Error_Handler.Log_Error

2721: RAISE EXC_UNEXP_SKIP_OBJECT;
2722: ELSIF l_return_status ='S' AND
2723: l_Mesg_Token_Tbl.COUNT <>0
2724: THEN
2725: Eco_Error_Handler.Log_Error
2726: ( p_ECO_rec => l_ECO_rec
2727: , p_eco_revision_tbl => l_eco_revision_tbl
2728: , p_revised_item_tbl => l_revised_item_tbl
2729: , p_rev_component_tbl => l_rev_component_tbl

Line 2779: error_handler.write_debug('After entity validation.');

2775: END IF;
2776:
2777: IF BOM_Globals.get_debug = 'Y'
2778: Then
2779: error_handler.write_debug('After entity validation.');
2780: error_handler.write_debug( l_Return_Status);
2781: END IF;
2782:
2783: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2780: error_handler.write_debug( l_Return_Status);

2776:
2777: IF BOM_Globals.get_debug = 'Y'
2778: Then
2779: error_handler.write_debug('After entity validation.');
2780: error_handler.write_debug( l_Return_Status);
2781: END IF;
2782:
2783: --dbms_output.put_line('return_status: ' || l_return_status);
2784:

Line 2785: IF l_return_status = Error_Handler.G_STATUS_ERROR

2781: END IF;
2782:
2783: --dbms_output.put_line('return_status: ' || l_return_status);
2784:
2785: IF l_return_status = Error_Handler.G_STATUS_ERROR
2786: THEN
2787: RAISE EXC_SEV_QUIT_RECORD;
2788: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2789: THEN

Line 2788: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2784:
2785: IF l_return_status = Error_Handler.G_STATUS_ERROR
2786: THEN
2787: RAISE EXC_SEV_QUIT_RECORD;
2788: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2789: THEN
2790: RAISE EXC_UNEXP_SKIP_OBJECT;
2791: ELSIF l_return_status ='S' AND
2792: l_Mesg_Token_Tbl.COUNT <>0

Line 2794: Eco_Error_Handler.Log_Error

2790: RAISE EXC_UNEXP_SKIP_OBJECT;
2791: ELSIF l_return_status ='S' AND
2792: l_Mesg_Token_Tbl.COUNT <>0
2793: THEN
2794: Eco_Error_Handler.Log_Error
2795: ( p_ECO_rec => l_ECO_rec
2796: , p_eco_revision_tbl => l_eco_revision_tbl
2797: , p_revised_item_tbl => l_revised_item_tbl
2798: , p_rev_component_tbl => l_rev_component_tbl

Line 2839: error_handler.write_debug('After write to db, the return status is');

2835: );
2836:
2837: IF BOM_Globals.get_debug = 'Y'
2838: Then
2839: error_handler.write_debug('After write to db, the return status is');
2840: error_handler.write_debug( l_Return_Status);
2841: END IF;
2842:
2843: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2840: error_handler.write_debug( l_Return_Status);

2836:
2837: IF BOM_Globals.get_debug = 'Y'
2838: Then
2839: error_handler.write_debug('After write to db, the return status is');
2840: error_handler.write_debug( l_Return_Status);
2841: END IF;
2842:
2843: --dbms_output.put_line('return_status: ' || l_return_status);
2844:

Line 2845: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2841: END IF;
2842:
2843: --dbms_output.put_line('return_status: ' || l_return_status);
2844:
2845: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2846: THEN
2847: RAISE EXC_UNEXP_SKIP_OBJECT;
2848: ELSIF l_return_status ='S' AND
2849: l_Mesg_Token_Tbl.COUNT <>0

Line 2851: Eco_Error_Handler.Log_Error

2847: RAISE EXC_UNEXP_SKIP_OBJECT;
2848: ELSIF l_return_status ='S' AND
2849: l_Mesg_Token_Tbl.COUNT <>0
2850: THEN
2851: Eco_Error_Handler.Log_Error
2852: ( p_ECO_rec => l_ECO_rec
2853: , p_eco_revision_tbl => l_eco_revision_tbl
2854: , p_revised_item_tbl => l_revised_item_tbl
2855: , p_rev_component_tbl => l_rev_component_tbl

Line 2885: Eco_Error_Handler.Log_Error

2881:
2882: WHEN EXC_SEV_QUIT_RECORD THEN
2883:
2884: --dbms_output.put_line('Expected error generated');
2885: Eco_Error_Handler.Log_Error
2886: ( p_revised_item_tbl => l_revised_item_tbl
2887: , p_rev_component_tbl => l_rev_component_tbl
2888: , p_ref_designator_tbl => l_ref_designator_tbl
2889: , p_sub_component_tbl => l_sub_component_tbl

Line 2895: , p_error_scope => Error_Handler.G_SCOPE_RECORD

2891: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2892: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2893: , p_mesg_token_tbl => l_mesg_token_tbl
2894: , p_error_status => FND_API.G_RET_STS_ERROR
2895: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2896: , p_error_level => 3
2897: , p_entity_index => I
2898: , x_ECO_rec => l_ECO_rec
2899: , x_eco_revision_tbl => l_eco_revision_tbl

Line 2927: Eco_Error_Handler.Log_Error

2923:
2924: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2925:
2926: --dbms_output.put_line('Unexpected error generated');
2927: Eco_Error_Handler.Log_Error
2928: ( p_revised_item_tbl => l_revised_item_tbl
2929: , p_rev_component_tbl => l_rev_component_tbl
2930: , p_ref_designator_tbl => l_ref_designator_tbl
2931: , p_sub_component_tbl => l_sub_component_tbl

Line 2936: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

2932: , p_rev_operation_tbl => l_rev_operation_tbl --add
2933: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2934: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2935: , p_mesg_token_tbl => l_mesg_token_tbl
2936: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2937: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2938: , p_other_message => l_other_message
2939: , p_other_token_tbl => l_other_token_tbl
2940: , p_error_level => 3

Line 2937: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

2933: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2934: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2935: , p_mesg_token_tbl => l_mesg_token_tbl
2936: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2937: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2938: , p_other_message => l_other_message
2939: , p_other_token_tbl => l_other_token_tbl
2940: , p_error_level => 3
2941: , x_ECO_rec => l_ECO_rec

Line 3018: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3019: , x_return_status IN OUT NOCOPY VARCHAR2
3020: )
3021: IS
3022:

Line 3023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3019: , x_return_status IN OUT NOCOPY VARCHAR2
3020: )
3021: IS
3022:
3023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3024: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3025: l_other_message VARCHAR2(50);
3026: l_err_text VARCHAR2(2000);
3027: l_valid BOOLEAN := TRUE;

Line 3024: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3020: )
3021: IS
3022:
3023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3024: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3025: l_other_message VARCHAR2(50);
3026: l_err_text VARCHAR2(2000);
3027: l_valid BOOLEAN := TRUE;
3028: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3042: l_Token_Tbl Error_Handler.Token_Tbl_Type;

3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3040: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3041: l_return_value NUMBER;
3042: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3043:
3044: EXC_SEV_QUIT_RECORD EXCEPTION;
3045: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3046:

Line 3081: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3077: );
3078:
3079: --dbms_output.put_line('return_status: ' || l_return_status);
3080:
3081: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3082: THEN
3083: RAISE EXC_UNEXP_SKIP_OBJECT;
3084: ELSIF l_return_status ='S' AND
3085: l_Mesg_Token_Tbl.COUNT <>0

Line 3087: Eco_Error_Handler.Log_Error

3083: RAISE EXC_UNEXP_SKIP_OBJECT;
3084: ELSIF l_return_status ='S' AND
3085: l_Mesg_Token_Tbl.COUNT <>0
3086: THEN
3087: Eco_Error_Handler.Log_Error
3088: ( p_ECO_rec => l_ECO_rec
3089: , p_eco_revision_tbl => l_eco_revision_tbl
3090: , p_revised_item_tbl => l_revised_item_tbl
3091: , p_rev_component_tbl => l_rev_component_tbl

Line 3132: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3128: );
3129:
3130: --dbms_output.put_line('return_status: ' || l_return_status);
3131:
3132: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3133: THEN
3134: RAISE EXC_UNEXP_SKIP_OBJECT;
3135: ELSIF l_return_status ='S' AND
3136: l_Mesg_Token_Tbl.COUNT <>0

Line 3138: Eco_Error_Handler.Log_Error

3134: RAISE EXC_UNEXP_SKIP_OBJECT;
3135: ELSIF l_return_status ='S' AND
3136: l_Mesg_Token_Tbl.COUNT <>0
3137: THEN
3138: Eco_Error_Handler.Log_Error
3139: ( p_ECO_rec => l_ECO_rec
3140: , p_eco_revision_tbl => l_eco_revision_tbl
3141: , p_revised_item_tbl => l_revised_item_tbl
3142: , p_rev_component_tbl => l_rev_component_tbl

Line 3174: Eco_Error_Handler.Log_Error

3170: EXCEPTION
3171:
3172: WHEN EXC_SEV_QUIT_RECORD THEN
3173:
3174: Eco_Error_Handler.Log_Error
3175: ( p_eco_revision_tbl => l_eco_revision_tbl
3176: , p_revised_item_tbl => l_revised_item_tbl
3177: , p_rev_component_tbl => l_rev_component_tbl
3178: , p_ref_designator_tbl => l_ref_designator_tbl

Line 3185: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3181: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3182: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3183: , p_mesg_token_tbl => l_mesg_token_tbl
3184: , p_error_status => FND_API.G_RET_STS_ERROR
3185: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3186: , p_error_level => 2
3187: , p_entity_index => I
3188: , x_eco_rec => l_eco_rec
3189: , x_eco_revision_tbl => l_eco_revision_tbl

Line 3217: Eco_Error_Handler.Log_Error

3213:
3214: WHEN EXC_UNEXP_SKIP_OBJECT THEN
3215:
3216: --dbms_output.put_line('Unexpected error generated');
3217: Eco_Error_Handler.Log_Error
3218: ( p_eco_revision_tbl => l_eco_revision_tbl
3219: , p_revised_item_tbl => l_revised_item_tbl
3220: , p_rev_component_tbl => l_rev_component_tbl
3221: , p_ref_designator_tbl => l_ref_designator_tbl

Line 3228: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3224: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3225: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3226: , p_mesg_token_tbl => l_mesg_token_tbl
3227: , p_error_status => FND_API.G_RET_STS_ERROR
3228: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3229: , p_error_level => 2
3230: , p_entity_index => I
3231: , x_eco_rec => l_eco_rec
3232: , x_eco_revision_tbl => l_eco_revision_tbl

Line 3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3301: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3308: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3309: , x_return_status IN OUT NOCOPY VARCHAR2

Line 3313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3309: , x_return_status IN OUT NOCOPY VARCHAR2
3310: )
3311: IS
3312:
3313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3314: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3315: l_other_message VARCHAR2(50);
3316: l_err_text VARCHAR2(2000);
3317: l_valid BOOLEAN := TRUE;

Line 3314: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3310: )
3311: IS
3312:
3313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3314: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3315: l_other_message VARCHAR2(50);
3316: l_err_text VARCHAR2(2000);
3317: l_valid BOOLEAN := TRUE;
3318: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3333: l_Token_Tbl Error_Handler.Token_Tbl_Type;

3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3332: l_return_value NUMBER;
3333: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3334:
3335: --10dec
3336: l_ECO_Rec_1 Eng_Eco_Pub.ECO_Rec_Type := p_ECO_rec;
3337: l_eco_unexp_Rec_1 Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;

Line 3352: error_handler.write_debug('start of eco_header.');

3348: BEGIN
3349:
3350: IF BOM_Globals.get_debug = 'Y'
3351: Then
3352: error_handler.write_debug('start of eco_header.');
3353: END IF;
3354:
3355:
3356:

Line 3371: error_handler.write_debug('organization id is');

3367: THEN
3368: /*
3369: IF BOM_Globals.get_debug = 'Y'
3370: Then
3371: error_handler.write_debug('organization id is');
3372: error_handler.write_debug(' l_eco_unexp_rec.organization_idorganization id is');
3373: END IF;
3374: */
3375:

Line 3372: error_handler.write_debug(' l_eco_unexp_rec.organization_idorganization id is');

3368: /*
3369: IF BOM_Globals.get_debug = 'Y'
3370: Then
3371: error_handler.write_debug('organization id is');
3372: error_handler.write_debug(' l_eco_unexp_rec.organization_idorganization id is');
3373: END IF;
3374: */
3375:
3376: --dbms_output.put_line('Checking Existence');

Line 3391: IF l_return_status = Error_Handler.G_STATUS_ERROR

3387: );
3388:
3389: --dbms_output.put_line('return_status: ' || l_return_status);
3390:
3391: IF l_return_status = Error_Handler.G_STATUS_ERROR
3392: THEN
3393: RAISE EXC_SEV_QUIT_RECORD;
3394: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3395: THEN

Line 3394: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3390:
3391: IF l_return_status = Error_Handler.G_STATUS_ERROR
3392: THEN
3393: RAISE EXC_SEV_QUIT_RECORD;
3394: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3395: THEN
3396: RAISE EXC_UNEXP_SKIP_OBJECT;
3397: END IF;
3398: END IF;

Line 3402: error_handler.write_debug('Attribute defaulting.');

3398: END IF;
3399:
3400: IF BOM_Globals.get_debug = 'Y'
3401: Then
3402: error_handler.write_debug('Attribute defaulting.');
3403: END IF;
3404:
3405: IF g_control_rec.attribute_defaulting AND
3406: l_ECO_Rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE

Line 3423: IF l_return_status = Error_Handler.G_STATUS_ERROR

3419: );
3420:
3421: --dbms_output.put_line('return_status: ' || l_return_status);
3422:
3423: IF l_return_status = Error_Handler.G_STATUS_ERROR
3424: THEN
3425: RAISE EXC_SEV_QUIT_RECORD;
3426: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3427: THEN

Line 3426: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3422:
3423: IF l_return_status = Error_Handler.G_STATUS_ERROR
3424: THEN
3425: RAISE EXC_SEV_QUIT_RECORD;
3426: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3427: THEN
3428: RAISE EXC_UNEXP_SKIP_OBJECT;
3429: ELSIF l_return_status ='S' AND
3430: l_Mesg_Token_Tbl.COUNT <>0

Line 3432: Eco_Error_Handler.Log_Error

3428: RAISE EXC_UNEXP_SKIP_OBJECT;
3429: ELSIF l_return_status ='S' AND
3430: l_Mesg_Token_Tbl.COUNT <>0
3431: THEN
3432: Eco_Error_Handler.Log_Error
3433: ( p_ECO_rec => l_ECO_rec
3434: , p_eco_revision_tbl => l_eco_revision_tbl
3435: , p_revised_item_tbl => l_revised_item_tbl
3436: , p_rev_component_tbl => l_rev_component_tbl

Line 3460: error_handler.write_debug('end of Attribute defaulting..');

3456: END IF;
3457:
3458: IF BOM_Globals.get_debug = 'Y'
3459: Then
3460: error_handler.write_debug('end of Attribute defaulting..');
3461: END IF;
3462:
3463:
3464: IF g_control_rec.entity_defaulting OR

Line 3486: error_handler.write_debug('end of query row..');

3482: END IF;*/
3483: END IF;
3484: IF BOM_Globals.get_debug = 'Y'
3485: Then
3486: error_handler.write_debug('end of query row..');
3487: END IF;
3488:
3489:
3490: -- Process Flow step 11 - Entity Level Defaulting

Line 3510: IF l_return_status = Error_Handler.G_STATUS_ERROR

3506: );
3507:
3508: --dbms_output.put_line('return_status: ' || l_return_status);
3509:
3510: IF l_return_status = Error_Handler.G_STATUS_ERROR
3511: THEN
3512: RAISE EXC_SEV_QUIT_RECORD;
3513: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3514: THEN RAISE EXC_UNEXP_SKIP_OBJECT;

Line 3513: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3509:
3510: IF l_return_status = Error_Handler.G_STATUS_ERROR
3511: THEN
3512: RAISE EXC_SEV_QUIT_RECORD;
3513: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3514: THEN RAISE EXC_UNEXP_SKIP_OBJECT;
3515: ELSIF l_return_status ='S' AND
3516: l_Mesg_Token_Tbl.COUNT <>0
3517: THEN

Line 3518: Eco_Error_Handler.Log_Error

3514: THEN RAISE EXC_UNEXP_SKIP_OBJECT;
3515: ELSIF l_return_status ='S' AND
3516: l_Mesg_Token_Tbl.COUNT <>0
3517: THEN
3518: Eco_Error_Handler.Log_Error
3519: ( p_ECO_rec => l_ECO_rec
3520: , p_eco_revision_tbl => l_eco_revision_tbl
3521: , p_revised_item_tbl => l_revised_item_tbl
3522: , p_rev_component_tbl => l_rev_component_tbl

Line 3547: error_handler.write_debug('After Entity default..');

3543:
3544: -- Process Flow step 12 - Entity Level Validation
3545: IF BOM_Globals.get_debug = 'Y'
3546: Then
3547: error_handler.write_debug('After Entity default..');
3548: END IF;
3549:
3550: IF g_control_rec.entity_validation
3551: THEN

Line 3565: error_handler.write_debug('Before check entiry..');

3561:
3562: ELSE
3563: IF BOM_Globals.get_debug = 'Y'
3564: Then
3565: error_handler.write_debug('Before check entiry..');
3566: END IF;
3567: Eng_Validate_ECO.Check_Entity
3568: ( x_return_status => l_Return_Status
3569: , x_err_text => l_err_text

Line 3579: error_handler.write_debug('After check entity..');

3575: , p_control_rec => g_control_rec
3576: );
3577: IF BOM_Globals.get_debug = 'Y'
3578: Then
3579: error_handler.write_debug('After check entity..');
3580:
3581:
3582: END IF;
3583: END IF;

Line 3587: IF l_return_status = Error_Handler.G_STATUS_ERROR

3583: END IF;
3584:
3585: --dbms_output.put_line('return_status: ' || l_return_status);
3586:
3587: IF l_return_status = Error_Handler.G_STATUS_ERROR
3588: THEN
3589: RAISE EXC_SEV_QUIT_RECORD;
3590: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3591: THEN

Line 3590: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3586:
3587: IF l_return_status = Error_Handler.G_STATUS_ERROR
3588: THEN
3589: RAISE EXC_SEV_QUIT_RECORD;
3590: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3591: THEN
3592: RAISE EXC_UNEXP_SKIP_OBJECT;
3593: ELSIF l_return_status ='S' AND
3594: l_Mesg_Token_Tbl.COUNT <>0

Line 3596: Eco_Error_Handler.Log_Error

3592: RAISE EXC_UNEXP_SKIP_OBJECT;
3593: ELSIF l_return_status ='S' AND
3594: l_Mesg_Token_Tbl.COUNT <>0
3595: THEN
3596: Eco_Error_Handler.Log_Error
3597: ( p_ECO_rec => l_ECO_rec
3598: , p_eco_revision_tbl => l_eco_revision_tbl
3599: , p_revised_item_tbl => l_revised_item_tbl
3600: , p_rev_component_tbl => l_rev_component_tbl

Line 3623: error_handler.write_debug('After check entity..');

3619: END IF;
3620: END IF;
3621: IF BOM_Globals.get_debug = 'Y'
3622: Then
3623: error_handler.write_debug('After check entity..');
3624: END IF;
3625:
3626:
3627: -- Process Flow step 13 : Database Writes

Line 3630: error_handler.write_debug('Before write to db..');

3626:
3627: -- Process Flow step 13 : Database Writes
3628: IF BOM_Globals.get_debug = 'Y'
3629: Then
3630: error_handler.write_debug('Before write to db..');
3631: END IF;
3632:
3633: IF g_control_rec.write_to_db
3634: THEN

Line 3640: error_handler.write_debug('write_to db is true');

3636: eng_globals.set_login_id(p_login_id => g_control_rec.last_update_login);
3637:
3638: IF BOM_Globals.get_debug = 'Y'
3639: Then
3640: error_handler.write_debug('write_to db is true');
3641: END IF;
3642:
3643:
3644: --dbms_output.put_line('Writing to the database');

Line 3655: error_handler.write_debug('After write to db..');

3651: , x_return_status => l_return_status
3652: );
3653: IF BOM_Globals.get_debug = 'Y'
3654: Then
3655: error_handler.write_debug('After write to db..');
3656: END IF;
3657:
3658:
3659: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

Line 3659: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3655: error_handler.write_debug('After write to db..');
3656: END IF;
3657:
3658:
3659: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3660: THEN
3661: RAISE EXC_UNEXP_SKIP_OBJECT;
3662: ELSIF l_return_status ='S' AND
3663: l_Mesg_Token_Tbl.COUNT <>0

Line 3665: Eco_Error_Handler.Log_Error

3661: RAISE EXC_UNEXP_SKIP_OBJECT;
3662: ELSIF l_return_status ='S' AND
3663: l_Mesg_Token_Tbl.COUNT <>0
3664: THEN
3665: Eco_Error_Handler.Log_Error
3666: ( p_ECO_rec => l_ECO_rec
3667: , p_eco_revision_tbl => l_eco_revision_tbl
3668: , p_revised_item_tbl => l_revised_item_tbl
3669: , p_rev_component_tbl => l_rev_component_tbl

Line 3695: Eco_Error_Handler.Log_Error

3691: EXCEPTION
3692:
3693: WHEN EXC_SEV_QUIT_RECORD THEN
3694:
3695: Eco_Error_Handler.Log_Error
3696: ( p_ECO_rec => l_ECO_rec
3697: , p_eco_revision_tbl => l_eco_revision_tbl
3698: , p_revised_item_tbl => l_revised_item_tbl
3699: , p_rev_component_tbl => l_rev_component_tbl

Line 3707: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3703: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3704: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3705: , p_mesg_token_tbl => l_mesg_token_tbl
3706: , p_error_status => FND_API.G_RET_STS_ERROR
3707: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3708: , p_error_level => 1
3709: , x_ECO_rec => l_ECO_rec
3710: , x_eco_revision_tbl => l_eco_revision_tbl
3711: , x_revised_item_tbl => l_revised_item_tbl

Line 3736: Eco_Error_Handler.Log_Error

3732:
3733: RETURN;
3734:
3735: WHEN EXC_UNEXP_SKIP_OBJECT THEN
3736: Eco_Error_Handler.Log_Error
3737: ( p_ECO_rec => l_ECO_rec
3738: , p_eco_revision_tbl => l_eco_revision_tbl
3739: , p_revised_item_tbl => l_revised_item_tbl
3740: , p_rev_component_tbl => l_rev_component_tbl

Line 3747: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

3743: , p_rev_operation_tbl => l_rev_operation_tbl --add
3744: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3745: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3746: , p_mesg_token_tbl => l_mesg_token_tbl
3747: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3748: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
3749: , p_other_message => l_other_message
3750: , p_other_token_tbl => l_other_token_tbl
3751: , p_error_level => 1

Line 3748: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

3744: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3745: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3746: , p_mesg_token_tbl => l_mesg_token_tbl
3747: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3748: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
3749: , p_other_message => l_other_message
3750: , p_other_token_tbl => l_other_token_tbl
3751: , p_error_level => 1
3752: , x_ECO_rec => l_ECO_rec

Line 3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:
3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3908: l_other_message VARCHAR2(2000);
3909: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3910:
3911: EXC_ERR_PVT_API_MAIN EXCEPTION;

Line 3909: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:
3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3908: l_other_message VARCHAR2(2000);
3909: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3910:
3911: EXC_ERR_PVT_API_MAIN EXCEPTION;
3912:
3913: BEGIN

Line 3921: error_handler.write_debug('here, for test purpose, you can write message.');

3917: -- Standard call to check for call compatibility
3918:
3919: IF BOM_Globals.get_debug = 'Y'
3920: Then
3921: error_handler.write_debug('here, for test purpose, you can write message.');
3922: END IF;
3923:
3924: --dbms_output.put_line('The following objects will be processed as part of the same business object');
3925: --dbms_output.put_line('| ECO : ' || l_ECO_rec.eco_name);

Line 3976: Error_Handler.Open_Debug_Session

3972:
3973: -- Eco
3974:
3975: /* Bom_Globals.Set_Debug('Y');
3976: Error_Handler.Open_Debug_Session
3977: (p_debug_filename => 'form_debug.log'
3978: , p_output_dir => '/sqlcom/log/dom1151'
3979: , x_return_status => l_return_status
3980: , p_mesg_token_tbl => l_mesg_token_tbl

Line 3987: error_handler.write_debug('here, for test purpose, you can write message.');

3983: */
3984:
3985: IF BOM_Globals.get_debug = 'Y'
3986: Then
3987: error_handler.write_debug('here, for test purpose, you can write message.');
3988: END IF;
3989:
3990: IF g_control_rec.process_entity = ENG_GLOBALS.G_ENTITY_ECO
3991: THEN

Line 4040: error_handler.write_debug('end of ECO header in Process_ECO..');

4036: END IF;
4037:
4038: IF BOM_Globals.get_debug = 'Y'
4039: Then
4040: error_handler.write_debug('end of ECO header in Process_ECO..');
4041: error_handler.write_debug('here, the process entity is:');
4042: error_handler.write_debug( g_control_rec.process_entity);
4043: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4044:

Line 4041: error_handler.write_debug('here, the process entity is:');

4037:
4038: IF BOM_Globals.get_debug = 'Y'
4039: Then
4040: error_handler.write_debug('end of ECO header in Process_ECO..');
4041: error_handler.write_debug('here, the process entity is:');
4042: error_handler.write_debug( g_control_rec.process_entity);
4043: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4044:
4045:

Line 4042: error_handler.write_debug( g_control_rec.process_entity);

4038: IF BOM_Globals.get_debug = 'Y'
4039: Then
4040: error_handler.write_debug('end of ECO header in Process_ECO..');
4041: error_handler.write_debug('here, the process entity is:');
4042: error_handler.write_debug( g_control_rec.process_entity);
4043: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4044:
4045:
4046: END IF;

Line 4043: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);

4039: Then
4040: error_handler.write_debug('end of ECO header in Process_ECO..');
4041: error_handler.write_debug('here, the process entity is:');
4042: error_handler.write_debug( g_control_rec.process_entity);
4043: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4044:
4045:
4046: END IF;
4047:

Line 4048: --error_Handler.Close_Debug_Session;

4044:
4045:
4046: END IF;
4047:
4048: --error_Handler.Close_Debug_Session;
4049:
4050:
4051: --dbms_output.put_line('BO error status: ' || l_bo_return_status);
4052:

Line 4135: error_handler.write_debug('after rev_items, the return status is');

4131: ) ;
4132:
4133: IF BOM_Globals.get_debug = 'Y'
4134: Then
4135: error_handler.write_debug('after rev_items, the return status is');
4136: error_handler.write_debug(l_return_status);
4137: END IF;
4138:
4139: --dbms_output.put_line('rev items return status: ' || l_revised_item_tbl(1).return_status);

Line 4136: error_handler.write_debug(l_return_status);

4132:
4133: IF BOM_Globals.get_debug = 'Y'
4134: Then
4135: error_handler.write_debug('after rev_items, the return status is');
4136: error_handler.write_debug(l_return_status);
4137: END IF;
4138:
4139: --dbms_output.put_line('rev items return status: ' || l_revised_item_tbl(1).return_status);
4140:

Line 4454: error_handler.write_debug('before set global variables.');

4450: -- Reset system_information business object flags
4451:
4452: IF BOM_Globals.get_debug = 'Y'
4453: Then
4454: error_handler.write_debug('before set global variables.');
4455: END IF;
4456:
4457: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
4458: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

Line 4467: error_handler.write_debug('end of process_eco');

4463: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
4464: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
4465: IF BOM_Globals.get_debug = 'Y'
4466: Then
4467: error_handler.write_debug('end of process_eco');
4468: END IF;
4469:
4470: EXCEPTION
4471:

Line 4474: Eco_Error_Handler.Log_Error

4470: EXCEPTION
4471:
4472: WHEN EXC_ERR_PVT_API_MAIN THEN
4473:
4474: Eco_Error_Handler.Log_Error
4475: ( p_ECO_rec => l_ECO_rec
4476: , p_eco_revision_tbl => l_eco_revision_tbl
4477: , p_revised_item_tbl => l_revised_item_tbl
4478: , p_rev_component_tbl => l_rev_component_tbl

Line 4486: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

4482: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4483: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4484: , p_mesg_token_tbl => l_mesg_token_tbl
4485: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4486: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4487: , p_other_message => l_other_message
4488: , p_other_token_tbl => l_other_token_tbl
4489: , p_error_level => 0
4490: , x_ECO_rec => l_ECO_rec

Line 4553: error_handler.write_debug('error in process_eco.');

4549:
4550:
4551: IF BOM_Globals.get_debug = 'Y'
4552: Then
4553: error_handler.write_debug('error in process_eco.');
4554: END IF;
4555: Error_Handler.Close_Debug_Session;
4556:
4557: IF g_control_rec.write_to_db

Line 4555: Error_Handler.Close_Debug_Session;

4551: IF BOM_Globals.get_debug = 'Y'
4552: Then
4553: error_handler.write_debug('error in process_eco.');
4554: END IF;
4555: Error_Handler.Close_Debug_Session;
4556:
4557: IF g_control_rec.write_to_db
4558: THEN
4559: RAISE;

Line 4566: Error_Handler.Add_Error_Token

4562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4563: THEN
4564: l_err_text := G_PKG_NAME || ' : Process ECO '
4565: || substrb(SQLERRM,1,200);
4566: Error_Handler.Add_Error_Token
4567: ( p_Message_Text => l_err_text
4568: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4569: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4570: );

Line 4573: Eco_Error_Handler.Log_Error

4569: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4570: );
4571: END IF;
4572:
4573: Eco_Error_Handler.Log_Error
4574: ( p_ECO_rec => l_ECO_rec
4575: , p_eco_revision_tbl => l_eco_revision_tbl
4576: , p_revised_item_tbl => l_revised_item_tbl
4577: , p_rev_component_tbl => l_rev_component_tbl

Line 4585: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

4581: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4582: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4583: , p_mesg_token_tbl => l_mesg_token_tbl
4584: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4585: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4586: , p_other_message => l_other_message
4587: , p_other_token_tbl => l_other_token_tbl
4588: , p_error_level => 0
4589: , x_ECO_rec => l_ECO_rec