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 1222: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1218: , x_return_status => l_return_status
1219: ) ;
1220: END IF;
1221: --Bug 9088260 changes end
1222: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1223: THEN
1224: l_other_message := 'BOM_OP_WRITES_UNEXP_SKIP';
1225: l_other_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
1226: l_other_token_tbl(1).token_value :=

Line 1232: ECO_Error_Handler.Log_Error

1228: RAISE EXC_UNEXP_SKIP_OBJECT ;
1229: ELSIF l_return_status ='S' AND
1230: l_mesg_token_tbl .COUNT <>0
1231: THEN
1232: ECO_Error_Handler.Log_Error
1233: ( p_rev_operation_tbl => l_rev_operation_tbl
1234: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1235: , p_rev_sub_resource_tbl=> l_rev_sub_resource_tbl
1236: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1238: , p_error_level => Error_Handler.G_OP_LEVEL

1234: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1235: , p_rev_sub_resource_tbl=> l_rev_sub_resource_tbl
1236: , p_mesg_token_tbl => l_mesg_token_tbl
1237: , p_error_status => 'W'
1238: , p_error_level => Error_Handler.G_OP_LEVEL
1239: , p_entity_index => I
1240: , x_ECO_rec => l_ECO_rec
1241: , x_eco_revision_tbl => l_eco_revision_tbl
1242: , x_revised_item_tbl => l_revised_item_tbl

Line 1263: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1259: );
1260:
1261: --dbms_output.put_line('return_status: ' || l_return_status);
1262:
1263: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1264: THEN
1265: RAISE EXC_UNEXP_SKIP_OBJECT;
1266: ELSIF l_return_status ='S' AND
1267: l_Mesg_Token_Tbl.COUNT <>0

Line 1269: Eco_Error_Handler.Log_Error

1265: RAISE EXC_UNEXP_SKIP_OBJECT;
1266: ELSIF l_return_status ='S' AND
1267: l_Mesg_Token_Tbl.COUNT <>0
1268: THEN
1269: Eco_Error_Handler.Log_Error
1270: ( p_rev_operation_tbl => l_rev_operation_tbl
1271: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1272: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1273: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1275: , p_error_level => Error_Handler.G_OP_LEVEL

1271: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1272: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1273: , p_mesg_token_tbl => l_mesg_token_tbl
1274: , p_error_status => 'W'
1275: , p_error_level => Error_Handler.G_OP_LEVEL
1276: , p_entity_index => I
1277: , x_eco_rec => l_eco_rec
1278: , x_eco_revision_tbl => l_eco_revision_tbl
1279: , x_revised_item_tbl => l_revised_item_tbl

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

1291:
1292:
1293: IF BOM_Globals.get_debug = 'Y'
1294: THEN
1295: error_handler.write_debug( 'after checck entity ');
1296: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:

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

1292:
1293: IF BOM_Globals.get_debug = 'Y'
1294: THEN
1295: error_handler.write_debug( 'after checck entity ');
1296: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );

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

1293: IF BOM_Globals.get_debug = 'Y'
1294: THEN
1295: error_handler.write_debug( 'after checck entity ');
1296: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );

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

1294: THEN
1295: error_handler.write_debug( 'after checck entity ');
1296: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );

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

1296: error_handler.write_debug( l_rev_operation_tbl(1).operation_sequence_number);
1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );

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

1297: error_handler.write_debug( l_rev_operation_tbl(1).count_point_type);
1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );

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

1298: error_handler.write_debug( l_rev_operation_tbl(1).backflush_flag);
1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );

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

1299:
1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );

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

1300: error_handler.write_debug( 'then all others:' );
1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );

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

1301: error_handler.write_debug( l_rev_operation_tbl(1).eco_name );
1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);

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

1302: error_handler.write_debug( l_rev_operation_tbl(1).organization_code );
1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );

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

1303: error_handler.write_debug( l_rev_operation_tbl(1).revised_item_name );
1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );

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

1304: error_handler.write_debug( l_rev_operation_tbl(1).new_revised_item_revision );
1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );

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

1305: error_handler.write_debug( l_rev_operation_tbl(1).ACD_Type );
1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );

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

1306: error_handler.write_debug( l_rev_operation_tbl(1).Alternate_Routing_Code );
1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );

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

1307: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Type );
1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);

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

1308: error_handler.write_debug( l_rev_operation_tbl(1).Start_Effective_Date );
1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );

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

1309: error_handler.write_debug( l_rev_operation_tbl(1).new_operation_sequence_number);
1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );

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

1310: error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Number );
1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );

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

1311: error_handler.write_debug( l_rev_operation_tbl(1).Old_Start_Effective_Date );
1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );

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

1312: error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Code );
1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );

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

1313: error_handler.write_debug( l_rev_operation_tbl(1).Department_Code );
1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );

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

1314: error_handler.write_debug( l_rev_operation_tbl(1).Op_Lead_Time_Percent );
1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );

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

1315: error_handler.write_debug( l_rev_operation_tbl(1).Minimum_Transfer_Quantity);
1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);

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

1316: error_handler.write_debug( l_rev_operation_tbl(1).Operation_Description );
1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');

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

1317: error_handler.write_debug( l_rev_operation_tbl(1).Disable_Date );
1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );

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

1318: error_handler.write_debug( l_rev_operation_tbl(1).Option_Dependent_Flag );
1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );

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

1319: error_handler.write_debug( l_rev_operation_tbl(1).Reference_Flag );
1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );

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

1320: error_handler.write_debug( l_rev_operation_tbl(1).Yield );
1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );

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

1321: error_handler.write_debug( l_rev_operation_tbl(1).Cumulative_Yield );
1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );

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

1322: error_handler.write_debug( l_rev_operation_tbl(1).Cancel_Comments );
1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );

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

1323: error_handler.write_debug( l_rev_operation_tbl(1).Attribute_category);
1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );

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

1324: error_handler.write_debug( 'After attribute_category');
1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );

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

1325: error_handler.write_debug( l_rev_operation_tbl(1).Original_System_Reference );
1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );

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

1326: error_handler.write_debug( l_rev_operation_tbl(1).Transaction_Type );
1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );

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

1327: error_handler.write_debug( l_rev_operation_tbl(1).Return_Status );
1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );

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

1328: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Sequence_Id );
1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:

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

1329: -- error_handler.write_debug( l_rev_operation_tbl(1).Operation_Sequence_Id );
1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:
1337: error_handler.write_debug('End of Rev_Op, the return status is');

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

1330: -- error_handler.write_debug( l_rev_operation_tbl(1).Old_Operation_Sequence_Id );
1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:
1337: error_handler.write_debug('End of Rev_Op, the return status is');
1338: error_handler.write_debug( l_Return_Status);

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

1331: -- error_handler.write_debug( l_rev_operation_tbl(1).Routing_Sequence_Id );
1332: -- error_handler.write_debug( l_rev_operation_tbl(1).Revised_Item_Id );
1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:
1337: error_handler.write_debug('End of Rev_Op, the return status is');
1338: error_handler.write_debug( l_Return_Status);
1339: END IF;

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

1333: -- error_handler.write_debug( l_rev_operation_tbl(1).Organization_Id );
1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:
1337: error_handler.write_debug('End of Rev_Op, the return status is');
1338: error_handler.write_debug( l_Return_Status);
1339: END IF;
1340:
1341: EXCEPTION

Line 1338: error_handler.write_debug( l_Return_Status);

1334: -- error_handler.write_debug( l_rev_operation_tbl(1).Standard_Operation_Id );
1335: -- error_handler.write_debug( l_rev_operation_tbl(1).Department_Id );
1336:
1337: error_handler.write_debug('End of Rev_Op, the return status is');
1338: error_handler.write_debug( l_Return_Status);
1339: END IF;
1340:
1341: EXCEPTION
1342:

Line 1347: Eco_Error_Handler.Log_Error

1343: WHEN EXC_SEV_QUIT_RECORD THEN
1344:
1345: --dbms_output.put_line('Expected error generated');
1346: l_rev_operation_tbl(I) := l_rev_operation_rec;
1347: Eco_Error_Handler.Log_Error
1348: ( p_rev_operation_tbl => l_rev_operation_tbl
1349: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1350: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1351: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1353: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1349: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1350: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1351: , p_mesg_token_tbl => l_mesg_token_tbl
1352: , p_error_status => FND_API.G_RET_STS_ERROR
1353: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1354: , p_error_level => Error_Handler.G_OP_LEVEL
1355: , p_entity_index => I
1356: , x_eco_rec => l_eco_rec
1357: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1354: , p_error_level => Error_Handler.G_OP_LEVEL

1350: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1351: , p_mesg_token_tbl => l_mesg_token_tbl
1352: , p_error_status => FND_API.G_RET_STS_ERROR
1353: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1354: , p_error_level => Error_Handler.G_OP_LEVEL
1355: , p_entity_index => I
1356: , x_eco_rec => l_eco_rec
1357: , x_eco_revision_tbl => l_eco_revision_tbl
1358: , x_revised_item_tbl => l_revised_item_tbl

Line 1385: Eco_Error_Handler.Log_Error

1381:
1382: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1383:
1384: --dbms_output.put_line('Unexpected error generated');
1385: Eco_Error_Handler.Log_Error
1386: ( p_rev_operation_tbl => l_rev_operation_tbl
1387: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1388: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1389: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1390: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1386: ( p_rev_operation_tbl => l_rev_operation_tbl
1387: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1388: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1389: , p_mesg_token_tbl => l_mesg_token_tbl
1390: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1391: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1392: , p_other_message => l_other_message
1393: , p_other_token_tbl => l_other_token_tbl
1394: , p_error_level => Error_Handler.G_OP_LEVEL

Line 1391: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1387: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1388: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1389: , p_mesg_token_tbl => l_mesg_token_tbl
1390: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1391: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1392: , p_other_message => l_other_message
1393: , p_other_token_tbl => l_other_token_tbl
1394: , p_error_level => Error_Handler.G_OP_LEVEL
1395: , p_entity_index => I

Line 1394: , p_error_level => Error_Handler.G_OP_LEVEL

1390: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1391: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1392: , p_other_message => l_other_message
1393: , p_other_token_tbl => l_other_token_tbl
1394: , p_error_level => Error_Handler.G_OP_LEVEL
1395: , p_entity_index => I
1396: , x_ECO_rec => l_ECO_rec
1397: , x_eco_revision_tbl => l_eco_revision_tbl
1398: , x_revised_item_tbl => l_revised_item_tbl

Line 1465: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1461: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1462: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1463: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1464: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1465: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1466: , x_return_status IN OUT NOCOPY VARCHAR2
1467: )
1468: IS
1469:

Line 1470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1466: , x_return_status IN OUT NOCOPY VARCHAR2
1467: )
1468: IS
1469:
1470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1471: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1472: l_other_message VARCHAR2(50);
1473: l_err_text VARCHAR2(2000);
1474: l_valid BOOLEAN := TRUE;

Line 1471: l_other_token_tbl Error_Handler.Token_Tbl_Type;

1467: )
1468: IS
1469:
1470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1471: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1472: l_other_message VARCHAR2(50);
1473: l_err_text VARCHAR2(2000);
1474: l_valid BOOLEAN := TRUE;
1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1491: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1487: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1488: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1489: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1490: l_return_value NUMBER;
1491: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1492:
1493: EXC_SEV_QUIT_RECORD EXCEPTION;
1494: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1495:

Line 1530: IF l_return_status = Error_Handler.G_STATUS_ERROR

1526: );
1527:
1528: --dbms_output.put_line('return_status: ' || l_return_status);
1529:
1530: IF l_return_status = Error_Handler.G_STATUS_ERROR
1531: THEN
1532: RAISE EXC_SEV_QUIT_RECORD;
1533: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1534: THEN

Line 1533: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1529:
1530: IF l_return_status = Error_Handler.G_STATUS_ERROR
1531: THEN
1532: RAISE EXC_SEV_QUIT_RECORD;
1533: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1534: THEN
1535: RAISE EXC_UNEXP_SKIP_OBJECT;
1536: END IF;
1537: END IF;

Line 1572: IF l_return_status = Error_Handler.G_STATUS_ERROR

1568: END IF;
1569:
1570: --dbms_output.put_line('return_status: ' || l_return_status);
1571:
1572: IF l_return_status = Error_Handler.G_STATUS_ERROR
1573: THEN
1574: RAISE EXC_SEV_QUIT_RECORD;
1575: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1576: THEN

Line 1575: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1571:
1572: IF l_return_status = Error_Handler.G_STATUS_ERROR
1573: THEN
1574: RAISE EXC_SEV_QUIT_RECORD;
1575: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1576: THEN
1577: RAISE EXC_UNEXP_SKIP_OBJECT;
1578: ELSIF l_return_status ='S' AND
1579: l_Mesg_Token_Tbl.COUNT <>0

Line 1581: Eco_Error_Handler.Log_Error

1577: RAISE EXC_UNEXP_SKIP_OBJECT;
1578: ELSIF l_return_status ='S' AND
1579: l_Mesg_Token_Tbl.COUNT <>0
1580: THEN
1581: Eco_Error_Handler.Log_Error
1582: ( p_ref_designator_tbl => l_ref_designator_tbl
1583: , p_sub_component_tbl => l_sub_component_tbl
1584: , p_mesg_token_tbl => l_mesg_token_tbl
1585: , p_error_status => 'W'

Line 1618: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1614: );
1615:
1616: --dbms_output.put_line('return_status: ' || l_return_status);
1617:
1618: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1619: THEN
1620: RAISE EXC_UNEXP_SKIP_OBJECT;
1621: ELSIF l_return_status ='S' AND
1622: l_Mesg_Token_Tbl.COUNT <>0

Line 1624: Eco_Error_Handler.Log_Error

1620: RAISE EXC_UNEXP_SKIP_OBJECT;
1621: ELSIF l_return_status ='S' AND
1622: l_Mesg_Token_Tbl.COUNT <>0
1623: THEN
1624: Eco_Error_Handler.Log_Error
1625: ( p_ref_designator_tbl => l_ref_designator_tbl
1626: , p_sub_component_tbl => l_sub_component_tbl
1627: , p_mesg_token_tbl => l_mesg_token_tbl
1628: , p_error_status => 'W'

Line 1652: Eco_Error_Handler.Log_Error

1648: WHEN EXC_SEV_QUIT_RECORD THEN
1649:
1650: --dbms_output.put_line('Expected error generated');
1651: l_sub_component_tbl(I) := l_sub_component_rec;
1652: Eco_Error_Handler.Log_Error
1653: ( p_ref_designator_tbl => l_ref_designator_tbl
1654: , p_sub_component_tbl => l_sub_component_tbl
1655: , p_mesg_token_tbl => l_mesg_token_tbl
1656: , p_error_status => FND_API.G_RET_STS_ERROR

Line 1657: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1653: ( p_ref_designator_tbl => l_ref_designator_tbl
1654: , p_sub_component_tbl => l_sub_component_tbl
1655: , p_mesg_token_tbl => l_mesg_token_tbl
1656: , p_error_status => FND_API.G_RET_STS_ERROR
1657: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1658: , p_error_level => 6
1659: , p_entity_index => I
1660: , x_eco_rec => l_eco_rec
1661: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1689: Eco_Error_Handler.Log_Error

1685:
1686: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1687:
1688: --dbms_output.put_line('Unexpected error generated');
1689: Eco_Error_Handler.Log_Error
1690: ( p_sub_component_tbl => l_sub_component_tbl
1691: , p_mesg_token_tbl => l_mesg_token_tbl
1692: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1693: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 1692: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1688: --dbms_output.put_line('Unexpected error generated');
1689: Eco_Error_Handler.Log_Error
1690: ( p_sub_component_tbl => l_sub_component_tbl
1691: , p_mesg_token_tbl => l_mesg_token_tbl
1692: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1693: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1694: , p_other_message => l_other_message
1695: , p_other_token_tbl => l_other_token_tbl
1696: , p_error_level => 6

Line 1693: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1689: Eco_Error_Handler.Log_Error
1690: ( p_sub_component_tbl => l_sub_component_tbl
1691: , p_mesg_token_tbl => l_mesg_token_tbl
1692: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1693: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1694: , p_other_message => l_other_message
1695: , p_other_token_tbl => l_other_token_tbl
1696: , p_error_level => 6
1697: , p_entity_index => I

Line 1765: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1761: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1762: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1763: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1764: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1765: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1766: , x_return_status IN OUT NOCOPY VARCHAR2
1767: )
1768: IS
1769:

Line 1770: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1766: , x_return_status IN OUT NOCOPY VARCHAR2
1767: )
1768: IS
1769:
1770: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1771: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1772: l_other_message VARCHAR2(50);
1773: l_err_text VARCHAR2(2000);
1774: l_valid BOOLEAN := TRUE;

Line 1771: l_other_token_tbl Error_Handler.Token_Tbl_Type;

1767: )
1768: IS
1769:
1770: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1771: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1772: l_other_message VARCHAR2(50);
1773: l_err_text VARCHAR2(2000);
1774: l_valid BOOLEAN := TRUE;
1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1791: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1787: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1788: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1789: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1790: l_return_value NUMBER;
1791: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1792:
1793: EXC_SEV_QUIT_RECORD EXCEPTION;
1794: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1795:

Line 1830: IF l_return_status = Error_Handler.G_STATUS_ERROR

1826: );
1827:
1828: --dbms_output.put_line('return_status: ' || l_return_status);
1829:
1830: IF l_return_status = Error_Handler.G_STATUS_ERROR
1831: THEN
1832: RAISE EXC_SEV_QUIT_RECORD;
1833: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1834: THEN

Line 1833: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1829:
1830: IF l_return_status = Error_Handler.G_STATUS_ERROR
1831: THEN
1832: RAISE EXC_SEV_QUIT_RECORD;
1833: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1834: THEN
1835: RAISE EXC_UNEXP_SKIP_OBJECT;
1836: END IF;
1837: END IF;

Line 1865: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

1861: );
1862:
1863: --dbms_output.put_line('return_status: ' || l_return_status);
1864:
1865: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
1866: THEN
1867: RAISE EXC_UNEXP_SKIP_OBJECT;
1868: ELSIF l_return_status ='S' AND
1869: l_Mesg_Token_Tbl.COUNT <>0

Line 1871: Eco_Error_Handler.Log_Error

1867: RAISE EXC_UNEXP_SKIP_OBJECT;
1868: ELSIF l_return_status ='S' AND
1869: l_Mesg_Token_Tbl.COUNT <>0
1870: THEN
1871: Eco_Error_Handler.Log_Error
1872: ( p_ref_designator_tbl => l_ref_designator_tbl
1873: , p_sub_component_tbl => l_sub_component_tbl
1874: , p_mesg_token_tbl => l_mesg_token_tbl
1875: , p_error_status => 'W'

Line 1899: Eco_Error_Handler.Log_Error

1895: WHEN EXC_SEV_QUIT_RECORD THEN
1896:
1897: --dbms_output.put_line('Expected error generated');
1898: l_ref_designator_tbl(I) := l_ref_designator_rec;
1899: Eco_Error_Handler.Log_Error
1900: ( p_ref_designator_tbl => l_ref_designator_tbl
1901: , p_sub_component_tbl => l_sub_component_tbl
1902: , p_mesg_token_tbl => l_mesg_token_tbl
1903: , p_error_status => FND_API.G_RET_STS_ERROR

Line 1904: , p_error_scope => Error_Handler.G_SCOPE_RECORD

1900: ( p_ref_designator_tbl => l_ref_designator_tbl
1901: , p_sub_component_tbl => l_sub_component_tbl
1902: , p_mesg_token_tbl => l_mesg_token_tbl
1903: , p_error_status => FND_API.G_RET_STS_ERROR
1904: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1905: , p_error_level => 5
1906: , p_entity_index => I
1907: , x_eco_rec => l_eco_rec
1908: , x_eco_revision_tbl => l_eco_revision_tbl

Line 1936: Eco_Error_Handler.Log_Error

1932:
1933: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1934:
1935: --dbms_output.put_line('Unexpected error generated');
1936: Eco_Error_Handler.Log_Error
1937: ( p_sub_component_tbl => l_sub_component_tbl
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1940: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

Line 1939: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1935: --dbms_output.put_line('Unexpected error generated');
1936: Eco_Error_Handler.Log_Error
1937: ( p_sub_component_tbl => l_sub_component_tbl
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1940: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1941: , p_other_message => l_other_message
1942: , p_other_token_tbl => l_other_token_tbl
1943: , p_error_level => 5

Line 1940: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1936: Eco_Error_Handler.Log_Error
1937: ( p_sub_component_tbl => l_sub_component_tbl
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1940: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1941: , p_other_message => l_other_message
1942: , p_other_token_tbl => l_other_token_tbl
1943: , p_error_level => 5
1944: , p_entity_index => I

Line 2019: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2015: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2016: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2017: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2018: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2019: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2020: , x_return_status IN OUT NOCOPY VARCHAR2
2021: )
2022: IS
2023:

Line 2024: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2020: , x_return_status IN OUT NOCOPY VARCHAR2
2021: )
2022: IS
2023:
2024: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2025: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2026: l_other_message VARCHAR2(50);
2027: l_err_text VARCHAR2(2000);
2028: l_valid BOOLEAN := TRUE;

Line 2025: l_other_token_tbl Error_Handler.Token_Tbl_Type;

2021: )
2022: IS
2023:
2024: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2025: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2026: l_other_message VARCHAR2(50);
2027: l_err_text VARCHAR2(2000);
2028: l_valid BOOLEAN := TRUE;
2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2041: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2042: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2043: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2044: l_return_value NUMBER;
2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2046: l_query_op_seq_num NUMBER := NULL;
2047: l_query_effective_date DATE := NULL;
2048: l_query_from_unit_number VARCHAR2(30) := NULL;
2049:

Line 2088: IF l_return_status = Error_Handler.G_STATUS_ERROR

2084:
2085:
2086: --dbms_output.put_line('return_status: ' || l_return_status);
2087:
2088: IF l_return_status = Error_Handler.G_STATUS_ERROR
2089: THEN
2090: RAISE EXC_SEV_QUIT_RECORD;
2091: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2092: THEN

Line 2091: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2087:
2088: IF l_return_status = Error_Handler.G_STATUS_ERROR
2089: THEN
2090: RAISE EXC_SEV_QUIT_RECORD;
2091: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2092: THEN
2093: RAISE EXC_UNEXP_SKIP_OBJECT;
2094: END IF;
2095: END IF;

Line 2124: IF l_return_status = Error_Handler.G_STATUS_ERROR

2120: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_component_rec.item_sequence_number));
2121:
2122: --dbms_output.put_line('return_status: ' || l_return_status);
2123:
2124: IF l_return_status = Error_Handler.G_STATUS_ERROR
2125: THEN
2126: RAISE EXC_SEV_QUIT_RECORD;
2127: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2128: THEN

Line 2127: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2123:
2124: IF l_return_status = Error_Handler.G_STATUS_ERROR
2125: THEN
2126: RAISE EXC_SEV_QUIT_RECORD;
2127: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2128: THEN
2129: RAISE EXC_UNEXP_SKIP_OBJECT;
2130: ELSIF l_return_status ='S' AND
2131: l_Mesg_Token_Tbl.COUNT <>0

Line 2133: Eco_Error_Handler.Log_Error

2129: RAISE EXC_UNEXP_SKIP_OBJECT;
2130: ELSIF l_return_status ='S' AND
2131: l_Mesg_Token_Tbl.COUNT <>0
2132: THEN
2133: Eco_Error_Handler.Log_Error
2134: ( p_rev_component_tbl => l_rev_component_tbl
2135: , p_ref_designator_tbl => l_ref_designator_tbl
2136: , p_sub_component_tbl => l_sub_component_tbl
2137: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2194: l_return_status := Error_Handler.G_STATUS_ERROR ;

2190:
2191: IF l_return_status = 'N'
2192: THEN
2193: -- Added for Bug1609574
2194: l_return_status := Error_Handler.G_STATUS_ERROR ;
2195: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
2196: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;
2197:
2198: Error_Handler.Add_Error_Token

Line 2198: Error_Handler.Add_Error_Token

2194: l_return_status := Error_Handler.G_STATUS_ERROR ;
2195: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
2196: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;
2197:
2198: Error_Handler.Add_Error_Token
2199: ( p_message_name => 'BOM_CMP_CREATE_REC_NOT_FOUND'
2200: , p_mesg_token_tbl => l_Mesg_Token_Tbl
2201: , p_token_tbl => l_Token_Tbl
2202: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2206: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2202: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2203: );
2204:
2205: RAISE EXC_SEV_QUIT_RECORD;
2206: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2207: THEN
2208: RAISE EXC_UNEXP_SKIP_OBJECT;
2209: ELSIF l_return_status ='S' AND
2210: l_Mesg_Token_Tbl.COUNT <>0

Line 2212: Eco_Error_Handler.Log_Error

2208: RAISE EXC_UNEXP_SKIP_OBJECT;
2209: ELSIF l_return_status ='S' AND
2210: l_Mesg_Token_Tbl.COUNT <>0
2211: THEN
2212: Eco_Error_Handler.Log_Error
2213: ( p_rev_component_tbl => l_rev_component_tbl
2214: , p_ref_designator_tbl => l_ref_designator_tbl
2215: , p_sub_component_tbl => l_sub_component_tbl
2216: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2257: IF l_return_status = Error_Handler.G_STATUS_ERROR

2253: --dbms_output.put_line('pvt item num: ' || to_char(l_rev_component_rec.item_sequence_number));
2254:
2255: --dbms_output.put_line('return_status: ' || l_return_status);
2256:
2257: IF l_return_status = Error_Handler.G_STATUS_ERROR
2258: THEN
2259: RAISE EXC_SEV_QUIT_RECORD;
2260: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2261: THEN

Line 2260: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2256:
2257: IF l_return_status = Error_Handler.G_STATUS_ERROR
2258: THEN
2259: RAISE EXC_SEV_QUIT_RECORD;
2260: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2261: THEN
2262: RAISE EXC_UNEXP_SKIP_OBJECT;
2263: ELSIF l_return_status ='S' AND
2264: l_Mesg_Token_Tbl.COUNT <>0

Line 2266: Eco_Error_Handler.Log_Error

2262: RAISE EXC_UNEXP_SKIP_OBJECT;
2263: ELSIF l_return_status ='S' AND
2264: l_Mesg_Token_Tbl.COUNT <>0
2265: THEN
2266: Eco_Error_Handler.Log_Error
2267: ( p_rev_component_tbl => l_rev_component_tbl
2268: , p_ref_designator_tbl => l_ref_designator_tbl
2269: , p_sub_component_tbl => l_sub_component_tbl
2270: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2315: IF l_return_status = Error_Handler.G_STATUS_ERROR

2311: END IF;
2312:
2313: --dbms_output.put_line('return_status: ' || l_return_status);
2314:
2315: IF l_return_status = Error_Handler.G_STATUS_ERROR
2316: THEN
2317: RAISE EXC_SEV_QUIT_RECORD;
2318: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2319: THEN

Line 2318: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2314:
2315: IF l_return_status = Error_Handler.G_STATUS_ERROR
2316: THEN
2317: RAISE EXC_SEV_QUIT_RECORD;
2318: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2319: THEN
2320: RAISE EXC_UNEXP_SKIP_OBJECT;
2321: ELSIF l_return_status ='S' AND
2322: l_Mesg_Token_Tbl.COUNT <>0

Line 2325: Eco_Error_Handler.Log_Error

2321: ELSIF l_return_status ='S' AND
2322: l_Mesg_Token_Tbl.COUNT <>0
2323: THEN
2324: --dbms_output.put_line('logging warnings');
2325: Eco_Error_Handler.Log_Error
2326: ( p_rev_component_tbl => l_rev_component_tbl
2327: , p_ref_designator_tbl => l_ref_designator_tbl
2328: , p_sub_component_tbl => l_sub_component_tbl
2329: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2364: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2360: );
2361:
2362: --dbms_output.put_line('return_status: ' || l_return_status);
2363:
2364: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2365: THEN
2366: RAISE EXC_UNEXP_SKIP_OBJECT;
2367: ELSIF l_return_status ='S' AND
2368: l_Mesg_Token_Tbl.COUNT <>0

Line 2370: Eco_Error_Handler.Log_Error

2366: RAISE EXC_UNEXP_SKIP_OBJECT;
2367: ELSIF l_return_status ='S' AND
2368: l_Mesg_Token_Tbl.COUNT <>0
2369: THEN
2370: Eco_Error_Handler.Log_Error
2371: ( p_rev_component_tbl => l_rev_component_tbl
2372: , p_ref_designator_tbl => l_ref_designator_tbl
2373: , p_sub_component_tbl => l_sub_component_tbl
2374: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2399: Eco_Error_Handler.Log_Error

2395: WHEN EXC_SEV_QUIT_RECORD THEN
2396:
2397: --dbms_output.put_line('Expected error generated');
2398: l_rev_component_tbl(I) := l_rev_component_rec;
2399: Eco_Error_Handler.Log_Error
2400: ( p_rev_component_tbl => l_rev_component_tbl
2401: , p_ref_designator_tbl => l_ref_designator_tbl
2402: , p_sub_component_tbl => l_sub_component_tbl
2403: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2405: , p_error_scope => Error_Handler.G_SCOPE_RECORD

2401: , p_ref_designator_tbl => l_ref_designator_tbl
2402: , p_sub_component_tbl => l_sub_component_tbl
2403: , p_mesg_token_tbl => l_mesg_token_tbl
2404: , p_error_status => FND_API.G_RET_STS_ERROR
2405: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2406: , p_error_level => 4
2407: , p_entity_index => I
2408: , x_eco_rec => l_eco_rec
2409: , x_eco_revision_tbl => l_eco_revision_tbl

Line 2438: Eco_Error_Handler.Log_Error

2434:
2435: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2436:
2437: --dbms_output.put_line('Unexpected error generated');
2438: Eco_Error_Handler.Log_Error
2439: ( p_rev_component_tbl => l_rev_component_tbl
2440: , p_ref_designator_tbl => l_ref_designator_tbl
2441: , p_sub_component_tbl => l_sub_component_tbl
2442: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2443: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

2439: ( p_rev_component_tbl => l_rev_component_tbl
2440: , p_ref_designator_tbl => l_ref_designator_tbl
2441: , p_sub_component_tbl => l_sub_component_tbl
2442: , p_mesg_token_tbl => l_mesg_token_tbl
2443: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2444: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2445: , p_other_message => l_other_message
2446: , p_other_token_tbl => l_other_token_tbl
2447: , p_error_level => 4

Line 2444: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

2440: , p_ref_designator_tbl => l_ref_designator_tbl
2441: , p_sub_component_tbl => l_sub_component_tbl
2442: , p_mesg_token_tbl => l_mesg_token_tbl
2443: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2444: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2445: , p_other_message => l_other_message
2446: , p_other_token_tbl => l_other_token_tbl
2447: , p_error_level => 4
2448: , p_entity_index => I

Line 2522: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2518: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2519: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2520: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2521: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2522: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2523: , x_return_status IN OUT NOCOPY VARCHAR2
2524: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2525: )
2526: IS

Line 2528: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2524: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2525: )
2526: IS
2527:
2528: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2529: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2530: l_other_message VARCHAR2(50);
2531: l_err_text VARCHAR2(2000);
2532: l_valid BOOLEAN := TRUE;

Line 2529: l_other_token_tbl Error_Handler.Token_Tbl_Type;

2525: )
2526: IS
2527:
2528: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2529: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2530: l_other_message VARCHAR2(50);
2531: l_err_text VARCHAR2(2000);
2532: l_valid BOOLEAN := TRUE;
2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2549: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2545: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2546: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2547: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2548: l_return_value NUMBER;
2549: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2550:
2551: EXC_SEV_QUIT_RECORD EXCEPTION;
2552: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
2553:

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

2555:
2556:
2557: IF BOM_Globals.get_debug = 'Y'
2558: Then
2559: error_handler.write_debug('at the beginning of rev_item procedure');
2560: error_handler.write_debug('revised item count is');
2561: error_handler.write_debug(l_revised_item_tbl.COUNT);
2562:
2563: END IF;

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

2556:
2557: IF BOM_Globals.get_debug = 'Y'
2558: Then
2559: error_handler.write_debug('at the beginning of rev_item procedure');
2560: error_handler.write_debug('revised item count is');
2561: error_handler.write_debug(l_revised_item_tbl.COUNT);
2562:
2563: END IF;
2564:

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

2557: IF BOM_Globals.get_debug = 'Y'
2558: Then
2559: error_handler.write_debug('at the beginning of rev_item procedure');
2560: error_handler.write_debug('revised item count is');
2561: error_handler.write_debug(l_revised_item_tbl.COUNT);
2562:
2563: END IF;
2564:
2565: -- Begin block that processes revised items. This block holds the exception handlers

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

2592: , x_disable_revision => x_disable_revision --Bug no:3034642
2593: );
2594: IF BOM_Globals.get_debug = 'Y'
2595: Then
2596: error_handler.write_debug('After check existence');
2597: error_handler.write_debug( l_Return_Status);
2598: END IF;
2599: --dbms_output.put_line('return_status: ' || l_return_status);
2600:

Line 2597: error_handler.write_debug( l_Return_Status);

2593: );
2594: IF BOM_Globals.get_debug = 'Y'
2595: Then
2596: error_handler.write_debug('After check existence');
2597: error_handler.write_debug( l_Return_Status);
2598: END IF;
2599: --dbms_output.put_line('return_status: ' || l_return_status);
2600:
2601: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2601: IF l_return_status = Error_Handler.G_STATUS_ERROR

2597: error_handler.write_debug( l_Return_Status);
2598: END IF;
2599: --dbms_output.put_line('return_status: ' || l_return_status);
2600:
2601: IF l_return_status = Error_Handler.G_STATUS_ERROR
2602: THEN
2603: RAISE EXC_SEV_QUIT_RECORD;
2604: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2605: THEN

Line 2604: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2600:
2601: IF l_return_status = Error_Handler.G_STATUS_ERROR
2602: THEN
2603: RAISE EXC_SEV_QUIT_RECORD;
2604: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2605: THEN
2606: RAISE EXC_UNEXP_SKIP_OBJECT;
2607: END IF;
2608: END IF;

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

2622: , x_return_status => l_Return_Status
2623: );
2624: IF BOM_Globals.get_debug = 'Y'
2625: Then
2626: error_handler.write_debug('After attribute defaulting, the return status is');
2627: error_handler.write_debug( l_Return_Status);
2628: END IF;
2629: --dbms_output.put_line('return_status: ' || l_return_status);
2630:

Line 2627: error_handler.write_debug( l_Return_Status);

2623: );
2624: IF BOM_Globals.get_debug = 'Y'
2625: Then
2626: error_handler.write_debug('After attribute defaulting, the return status is');
2627: error_handler.write_debug( l_Return_Status);
2628: END IF;
2629: --dbms_output.put_line('return_status: ' || l_return_status);
2630:
2631: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2631: IF l_return_status = Error_Handler.G_STATUS_ERROR

2627: error_handler.write_debug( l_Return_Status);
2628: END IF;
2629: --dbms_output.put_line('return_status: ' || l_return_status);
2630:
2631: IF l_return_status = Error_Handler.G_STATUS_ERROR
2632: THEN
2633: RAISE EXC_SEV_QUIT_RECORD;
2634: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2635: THEN

Line 2634: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2630:
2631: IF l_return_status = Error_Handler.G_STATUS_ERROR
2632: THEN
2633: RAISE EXC_SEV_QUIT_RECORD;
2634: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2635: THEN
2636: RAISE EXC_UNEXP_SKIP_OBJECT;
2637: ELSIF l_return_status ='S' AND
2638: l_Mesg_Token_Tbl.COUNT <>0

Line 2640: Eco_Error_Handler.Log_Error

2636: RAISE EXC_UNEXP_SKIP_OBJECT;
2637: ELSIF l_return_status ='S' AND
2638: l_Mesg_Token_Tbl.COUNT <>0
2639: THEN
2640: Eco_Error_Handler.Log_Error
2641: ( p_revised_item_tbl => l_revised_item_tbl
2642: , p_rev_component_tbl => l_rev_component_tbl
2643: , p_ref_designator_tbl => l_ref_designator_tbl
2644: , p_sub_component_tbl => l_sub_component_tbl

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

2682: );
2683:
2684: IF BOM_Globals.get_debug = 'Y'
2685: Then
2686: error_handler.write_debug('After query row, the return status is');
2687: error_handler.write_debug( l_Return_Status);
2688: END IF;
2689:
2690: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2687: error_handler.write_debug( l_Return_Status);

2683:
2684: IF BOM_Globals.get_debug = 'Y'
2685: Then
2686: error_handler.write_debug('After query row, the return status is');
2687: error_handler.write_debug( l_Return_Status);
2688: END IF;
2689:
2690: --dbms_output.put_line('return_status: ' || l_return_status);
2691:

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

2717: );
2718:
2719: IF BOM_Globals.get_debug = 'Y'
2720: Then
2721: error_handler.write_debug('After eitity default, the return status is');
2722: error_handler.write_debug( l_Return_Status);
2723: END IF;
2724: --dbms_output.put_line('return_status: ' || l_return_status);
2725:

Line 2722: error_handler.write_debug( l_Return_Status);

2718:
2719: IF BOM_Globals.get_debug = 'Y'
2720: Then
2721: error_handler.write_debug('After eitity default, the return status is');
2722: error_handler.write_debug( l_Return_Status);
2723: END IF;
2724: --dbms_output.put_line('return_status: ' || l_return_status);
2725:
2726: IF l_return_status = Error_Handler.G_STATUS_ERROR

Line 2726: IF l_return_status = Error_Handler.G_STATUS_ERROR

2722: error_handler.write_debug( l_Return_Status);
2723: END IF;
2724: --dbms_output.put_line('return_status: ' || l_return_status);
2725:
2726: IF l_return_status = Error_Handler.G_STATUS_ERROR
2727: THEN
2728: RAISE EXC_SEV_QUIT_RECORD;
2729: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2730: THEN

Line 2729: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2725:
2726: IF l_return_status = Error_Handler.G_STATUS_ERROR
2727: THEN
2728: RAISE EXC_SEV_QUIT_RECORD;
2729: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2730: THEN
2731: RAISE EXC_UNEXP_SKIP_OBJECT;
2732: ELSIF l_return_status ='S' AND
2733: l_Mesg_Token_Tbl.COUNT <>0

Line 2735: Eco_Error_Handler.Log_Error

2731: RAISE EXC_UNEXP_SKIP_OBJECT;
2732: ELSIF l_return_status ='S' AND
2733: l_Mesg_Token_Tbl.COUNT <>0
2734: THEN
2735: Eco_Error_Handler.Log_Error
2736: ( p_ECO_rec => l_ECO_rec
2737: , p_eco_revision_tbl => l_eco_revision_tbl
2738: , p_revised_item_tbl => l_revised_item_tbl
2739: , p_rev_component_tbl => l_rev_component_tbl

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

2785: END IF;
2786:
2787: IF BOM_Globals.get_debug = 'Y'
2788: Then
2789: error_handler.write_debug('After entity validation.');
2790: error_handler.write_debug( l_Return_Status);
2791: END IF;
2792:
2793: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2790: error_handler.write_debug( l_Return_Status);

2786:
2787: IF BOM_Globals.get_debug = 'Y'
2788: Then
2789: error_handler.write_debug('After entity validation.');
2790: error_handler.write_debug( l_Return_Status);
2791: END IF;
2792:
2793: --dbms_output.put_line('return_status: ' || l_return_status);
2794:

Line 2795: IF l_return_status = Error_Handler.G_STATUS_ERROR

2791: END IF;
2792:
2793: --dbms_output.put_line('return_status: ' || l_return_status);
2794:
2795: IF l_return_status = Error_Handler.G_STATUS_ERROR
2796: THEN
2797: RAISE EXC_SEV_QUIT_RECORD;
2798: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2799: THEN

Line 2798: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2794:
2795: IF l_return_status = Error_Handler.G_STATUS_ERROR
2796: THEN
2797: RAISE EXC_SEV_QUIT_RECORD;
2798: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2799: THEN
2800: RAISE EXC_UNEXP_SKIP_OBJECT;
2801: ELSIF l_return_status ='S' AND
2802: l_Mesg_Token_Tbl.COUNT <>0

Line 2804: Eco_Error_Handler.Log_Error

2800: RAISE EXC_UNEXP_SKIP_OBJECT;
2801: ELSIF l_return_status ='S' AND
2802: l_Mesg_Token_Tbl.COUNT <>0
2803: THEN
2804: Eco_Error_Handler.Log_Error
2805: ( p_ECO_rec => l_ECO_rec
2806: , p_eco_revision_tbl => l_eco_revision_tbl
2807: , p_revised_item_tbl => l_revised_item_tbl
2808: , p_rev_component_tbl => l_rev_component_tbl

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

2845: );
2846:
2847: IF BOM_Globals.get_debug = 'Y'
2848: Then
2849: error_handler.write_debug('After write to db, the return status is');
2850: error_handler.write_debug( l_Return_Status);
2851: END IF;
2852:
2853: --dbms_output.put_line('return_status: ' || l_return_status);

Line 2850: error_handler.write_debug( l_Return_Status);

2846:
2847: IF BOM_Globals.get_debug = 'Y'
2848: Then
2849: error_handler.write_debug('After write to db, the return status is');
2850: error_handler.write_debug( l_Return_Status);
2851: END IF;
2852:
2853: --dbms_output.put_line('return_status: ' || l_return_status);
2854:

Line 2855: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

2851: END IF;
2852:
2853: --dbms_output.put_line('return_status: ' || l_return_status);
2854:
2855: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
2856: THEN
2857: RAISE EXC_UNEXP_SKIP_OBJECT;
2858: ELSIF l_return_status ='S' AND
2859: l_Mesg_Token_Tbl.COUNT <>0

Line 2861: Eco_Error_Handler.Log_Error

2857: RAISE EXC_UNEXP_SKIP_OBJECT;
2858: ELSIF l_return_status ='S' AND
2859: l_Mesg_Token_Tbl.COUNT <>0
2860: THEN
2861: Eco_Error_Handler.Log_Error
2862: ( p_ECO_rec => l_ECO_rec
2863: , p_eco_revision_tbl => l_eco_revision_tbl
2864: , p_revised_item_tbl => l_revised_item_tbl
2865: , p_rev_component_tbl => l_rev_component_tbl

Line 2895: Eco_Error_Handler.Log_Error

2891:
2892: WHEN EXC_SEV_QUIT_RECORD THEN
2893:
2894: --dbms_output.put_line('Expected error generated');
2895: Eco_Error_Handler.Log_Error
2896: ( p_revised_item_tbl => l_revised_item_tbl
2897: , p_rev_component_tbl => l_rev_component_tbl
2898: , p_ref_designator_tbl => l_ref_designator_tbl
2899: , p_sub_component_tbl => l_sub_component_tbl

Line 2905: , p_error_scope => Error_Handler.G_SCOPE_RECORD

2901: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2902: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2903: , p_mesg_token_tbl => l_mesg_token_tbl
2904: , p_error_status => FND_API.G_RET_STS_ERROR
2905: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2906: , p_error_level => 3
2907: , p_entity_index => I
2908: , x_ECO_rec => l_ECO_rec
2909: , x_eco_revision_tbl => l_eco_revision_tbl

Line 2937: Eco_Error_Handler.Log_Error

2933:
2934: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2935:
2936: --dbms_output.put_line('Unexpected error generated');
2937: Eco_Error_Handler.Log_Error
2938: ( p_revised_item_tbl => l_revised_item_tbl
2939: , p_rev_component_tbl => l_rev_component_tbl
2940: , p_ref_designator_tbl => l_ref_designator_tbl
2941: , p_sub_component_tbl => l_sub_component_tbl

Line 2946: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

2942: , p_rev_operation_tbl => l_rev_operation_tbl --add
2943: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2944: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2945: , p_mesg_token_tbl => l_mesg_token_tbl
2946: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2947: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2948: , p_other_message => l_other_message
2949: , p_other_token_tbl => l_other_token_tbl
2950: , p_error_level => 3

Line 2947: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

2943: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2944: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2945: , p_mesg_token_tbl => l_mesg_token_tbl
2946: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2947: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2948: , p_other_message => l_other_message
2949: , p_other_token_tbl => l_other_token_tbl
2950: , p_error_level => 3
2951: , x_ECO_rec => l_ECO_rec

Line 3028: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3024: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3025: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3026: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3027: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3028: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3029: , x_return_status IN OUT NOCOPY VARCHAR2
3030: )
3031: IS
3032:

Line 3033: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3029: , x_return_status IN OUT NOCOPY VARCHAR2
3030: )
3031: IS
3032:
3033: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3034: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3035: l_other_message VARCHAR2(50);
3036: l_err_text VARCHAR2(2000);
3037: l_valid BOOLEAN := TRUE;

Line 3034: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3030: )
3031: IS
3032:
3033: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3034: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3035: l_other_message VARCHAR2(50);
3036: l_err_text VARCHAR2(2000);
3037: l_valid BOOLEAN := TRUE;
3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3052: l_Token_Tbl Error_Handler.Token_Tbl_Type;

3048: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3049: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3050: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3051: l_return_value NUMBER;
3052: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3053:
3054: EXC_SEV_QUIT_RECORD EXCEPTION;
3055: EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3056:

Line 3091: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3087: );
3088:
3089: --dbms_output.put_line('return_status: ' || l_return_status);
3090:
3091: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3092: THEN
3093: RAISE EXC_UNEXP_SKIP_OBJECT;
3094: ELSIF l_return_status ='S' AND
3095: l_Mesg_Token_Tbl.COUNT <>0

Line 3097: Eco_Error_Handler.Log_Error

3093: RAISE EXC_UNEXP_SKIP_OBJECT;
3094: ELSIF l_return_status ='S' AND
3095: l_Mesg_Token_Tbl.COUNT <>0
3096: THEN
3097: Eco_Error_Handler.Log_Error
3098: ( p_ECO_rec => l_ECO_rec
3099: , p_eco_revision_tbl => l_eco_revision_tbl
3100: , p_revised_item_tbl => l_revised_item_tbl
3101: , p_rev_component_tbl => l_rev_component_tbl

Line 3142: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3138: );
3139:
3140: --dbms_output.put_line('return_status: ' || l_return_status);
3141:
3142: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3143: THEN
3144: RAISE EXC_UNEXP_SKIP_OBJECT;
3145: ELSIF l_return_status ='S' AND
3146: l_Mesg_Token_Tbl.COUNT <>0

Line 3148: Eco_Error_Handler.Log_Error

3144: RAISE EXC_UNEXP_SKIP_OBJECT;
3145: ELSIF l_return_status ='S' AND
3146: l_Mesg_Token_Tbl.COUNT <>0
3147: THEN
3148: Eco_Error_Handler.Log_Error
3149: ( p_ECO_rec => l_ECO_rec
3150: , p_eco_revision_tbl => l_eco_revision_tbl
3151: , p_revised_item_tbl => l_revised_item_tbl
3152: , p_rev_component_tbl => l_rev_component_tbl

Line 3184: Eco_Error_Handler.Log_Error

3180: EXCEPTION
3181:
3182: WHEN EXC_SEV_QUIT_RECORD THEN
3183:
3184: Eco_Error_Handler.Log_Error
3185: ( p_eco_revision_tbl => l_eco_revision_tbl
3186: , p_revised_item_tbl => l_revised_item_tbl
3187: , p_rev_component_tbl => l_rev_component_tbl
3188: , p_ref_designator_tbl => l_ref_designator_tbl

Line 3195: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3191: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3192: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3193: , p_mesg_token_tbl => l_mesg_token_tbl
3194: , p_error_status => FND_API.G_RET_STS_ERROR
3195: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3196: , p_error_level => 2
3197: , p_entity_index => I
3198: , x_eco_rec => l_eco_rec
3199: , x_eco_revision_tbl => l_eco_revision_tbl

Line 3227: Eco_Error_Handler.Log_Error

3223:
3224: WHEN EXC_UNEXP_SKIP_OBJECT THEN
3225:
3226: --dbms_output.put_line('Unexpected error generated');
3227: Eco_Error_Handler.Log_Error
3228: ( p_eco_revision_tbl => l_eco_revision_tbl
3229: , p_revised_item_tbl => l_revised_item_tbl
3230: , p_rev_component_tbl => l_rev_component_tbl
3231: , p_ref_designator_tbl => l_ref_designator_tbl

Line 3238: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3234: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3235: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3236: , p_mesg_token_tbl => l_mesg_token_tbl
3237: , p_error_status => FND_API.G_RET_STS_ERROR
3238: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3239: , p_error_level => 2
3240: , p_entity_index => I
3241: , x_eco_rec => l_eco_rec
3242: , x_eco_revision_tbl => l_eco_revision_tbl

Line 3315: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3313: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3314: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3315: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3316: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3317: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3318: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3319: , x_return_status IN OUT NOCOPY VARCHAR2

Line 3323: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3319: , x_return_status IN OUT NOCOPY VARCHAR2
3320: )
3321: IS
3322:
3323: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3324: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3325: l_other_message VARCHAR2(50);
3326: l_err_text VARCHAR2(2000);
3327: l_valid BOOLEAN := TRUE;

Line 3324: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3320: )
3321: IS
3322:
3323: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3324: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3325: l_other_message VARCHAR2(50);
3326: l_err_text VARCHAR2(2000);
3327: l_valid BOOLEAN := TRUE;
3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;

3339: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3340: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3341: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3342: l_return_value NUMBER;
3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3344:
3345: --10dec
3346: l_ECO_Rec_1 Eng_Eco_Pub.ECO_Rec_Type := p_ECO_rec;
3347: l_eco_unexp_Rec_1 Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;

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

3358: BEGIN
3359:
3360: IF BOM_Globals.get_debug = 'Y'
3361: Then
3362: error_handler.write_debug('start of eco_header.');
3363: END IF;
3364:
3365:
3366:

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

3377: THEN
3378: /*
3379: IF BOM_Globals.get_debug = 'Y'
3380: Then
3381: error_handler.write_debug('organization id is');
3382: error_handler.write_debug(' l_eco_unexp_rec.organization_idorganization id is');
3383: END IF;
3384: */
3385:

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

3378: /*
3379: IF BOM_Globals.get_debug = 'Y'
3380: Then
3381: error_handler.write_debug('organization id is');
3382: error_handler.write_debug(' l_eco_unexp_rec.organization_idorganization id is');
3383: END IF;
3384: */
3385:
3386: --dbms_output.put_line('Checking Existence');

Line 3401: IF l_return_status = Error_Handler.G_STATUS_ERROR

3397: );
3398:
3399: --dbms_output.put_line('return_status: ' || l_return_status);
3400:
3401: IF l_return_status = Error_Handler.G_STATUS_ERROR
3402: THEN
3403: RAISE EXC_SEV_QUIT_RECORD;
3404: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3405: THEN

Line 3404: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3400:
3401: IF l_return_status = Error_Handler.G_STATUS_ERROR
3402: THEN
3403: RAISE EXC_SEV_QUIT_RECORD;
3404: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3405: THEN
3406: RAISE EXC_UNEXP_SKIP_OBJECT;
3407: END IF;
3408: END IF;

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

3408: END IF;
3409:
3410: IF BOM_Globals.get_debug = 'Y'
3411: Then
3412: error_handler.write_debug('Attribute defaulting.');
3413: END IF;
3414:
3415: IF g_control_rec.attribute_defaulting AND
3416: l_ECO_Rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE

Line 3433: IF l_return_status = Error_Handler.G_STATUS_ERROR

3429: );
3430:
3431: --dbms_output.put_line('return_status: ' || l_return_status);
3432:
3433: IF l_return_status = Error_Handler.G_STATUS_ERROR
3434: THEN
3435: RAISE EXC_SEV_QUIT_RECORD;
3436: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3437: THEN

Line 3436: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3432:
3433: IF l_return_status = Error_Handler.G_STATUS_ERROR
3434: THEN
3435: RAISE EXC_SEV_QUIT_RECORD;
3436: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3437: THEN
3438: RAISE EXC_UNEXP_SKIP_OBJECT;
3439: ELSIF l_return_status ='S' AND
3440: l_Mesg_Token_Tbl.COUNT <>0

Line 3442: Eco_Error_Handler.Log_Error

3438: RAISE EXC_UNEXP_SKIP_OBJECT;
3439: ELSIF l_return_status ='S' AND
3440: l_Mesg_Token_Tbl.COUNT <>0
3441: THEN
3442: Eco_Error_Handler.Log_Error
3443: ( p_ECO_rec => l_ECO_rec
3444: , p_eco_revision_tbl => l_eco_revision_tbl
3445: , p_revised_item_tbl => l_revised_item_tbl
3446: , p_rev_component_tbl => l_rev_component_tbl

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

3466: END IF;
3467:
3468: IF BOM_Globals.get_debug = 'Y'
3469: Then
3470: error_handler.write_debug('end of Attribute defaulting..');
3471: END IF;
3472:
3473:
3474: IF g_control_rec.entity_defaulting OR

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

3492: END IF;*/
3493: END IF;
3494: IF BOM_Globals.get_debug = 'Y'
3495: Then
3496: error_handler.write_debug('end of query row..');
3497: END IF;
3498:
3499:
3500: -- Process Flow step 11 - Entity Level Defaulting

Line 3520: IF l_return_status = Error_Handler.G_STATUS_ERROR

3516: );
3517:
3518: --dbms_output.put_line('return_status: ' || l_return_status);
3519:
3520: IF l_return_status = Error_Handler.G_STATUS_ERROR
3521: THEN
3522: RAISE EXC_SEV_QUIT_RECORD;
3523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3524: THEN RAISE EXC_UNEXP_SKIP_OBJECT;

Line 3523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3519:
3520: IF l_return_status = Error_Handler.G_STATUS_ERROR
3521: THEN
3522: RAISE EXC_SEV_QUIT_RECORD;
3523: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3524: THEN RAISE EXC_UNEXP_SKIP_OBJECT;
3525: ELSIF l_return_status ='S' AND
3526: l_Mesg_Token_Tbl.COUNT <>0
3527: THEN

Line 3528: Eco_Error_Handler.Log_Error

3524: THEN RAISE EXC_UNEXP_SKIP_OBJECT;
3525: ELSIF l_return_status ='S' AND
3526: l_Mesg_Token_Tbl.COUNT <>0
3527: THEN
3528: Eco_Error_Handler.Log_Error
3529: ( p_ECO_rec => l_ECO_rec
3530: , p_eco_revision_tbl => l_eco_revision_tbl
3531: , p_revised_item_tbl => l_revised_item_tbl
3532: , p_rev_component_tbl => l_rev_component_tbl

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

3553:
3554: -- Process Flow step 12 - Entity Level Validation
3555: IF BOM_Globals.get_debug = 'Y'
3556: Then
3557: error_handler.write_debug('After Entity default..');
3558: END IF;
3559:
3560: IF g_control_rec.entity_validation
3561: THEN

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

3571:
3572: ELSE
3573: IF BOM_Globals.get_debug = 'Y'
3574: Then
3575: error_handler.write_debug('Before check entiry..');
3576: END IF;
3577: Eng_Validate_ECO.Check_Entity
3578: ( x_return_status => l_Return_Status
3579: , x_err_text => l_err_text

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

3585: , p_control_rec => g_control_rec
3586: );
3587: IF BOM_Globals.get_debug = 'Y'
3588: Then
3589: error_handler.write_debug('After check entity..');
3590:
3591:
3592: END IF;
3593: END IF;

Line 3597: IF l_return_status = Error_Handler.G_STATUS_ERROR

3593: END IF;
3594:
3595: --dbms_output.put_line('return_status: ' || l_return_status);
3596:
3597: IF l_return_status = Error_Handler.G_STATUS_ERROR
3598: THEN
3599: RAISE EXC_SEV_QUIT_RECORD;
3600: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3601: THEN

Line 3600: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3596:
3597: IF l_return_status = Error_Handler.G_STATUS_ERROR
3598: THEN
3599: RAISE EXC_SEV_QUIT_RECORD;
3600: ELSIF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3601: THEN
3602: RAISE EXC_UNEXP_SKIP_OBJECT;
3603: ELSIF l_return_status ='S' AND
3604: l_Mesg_Token_Tbl.COUNT <>0

Line 3606: Eco_Error_Handler.Log_Error

3602: RAISE EXC_UNEXP_SKIP_OBJECT;
3603: ELSIF l_return_status ='S' AND
3604: l_Mesg_Token_Tbl.COUNT <>0
3605: THEN
3606: Eco_Error_Handler.Log_Error
3607: ( p_ECO_rec => l_ECO_rec
3608: , p_eco_revision_tbl => l_eco_revision_tbl
3609: , p_revised_item_tbl => l_revised_item_tbl
3610: , p_rev_component_tbl => l_rev_component_tbl

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

3629: END IF;
3630: END IF;
3631: IF BOM_Globals.get_debug = 'Y'
3632: Then
3633: error_handler.write_debug('After check entity..');
3634: END IF;
3635:
3636:
3637: -- Process Flow step 13 : Database Writes

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

3636:
3637: -- Process Flow step 13 : Database Writes
3638: IF BOM_Globals.get_debug = 'Y'
3639: Then
3640: error_handler.write_debug('Before write to db..');
3641: END IF;
3642:
3643: IF g_control_rec.write_to_db
3644: THEN

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

3646: eng_globals.set_login_id(p_login_id => g_control_rec.last_update_login);
3647:
3648: IF BOM_Globals.get_debug = 'Y'
3649: Then
3650: error_handler.write_debug('write_to db is true');
3651: END IF;
3652:
3653:
3654: --dbms_output.put_line('Writing to the database');

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

3661: , x_return_status => l_return_status
3662: );
3663: IF BOM_Globals.get_debug = 'Y'
3664: Then
3665: error_handler.write_debug('After write to db..');
3666: END IF;
3667:
3668:
3669: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

Line 3669: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED

3665: error_handler.write_debug('After write to db..');
3666: END IF;
3667:
3668:
3669: IF l_return_status = Error_Handler.G_STATUS_UNEXPECTED
3670: THEN
3671: RAISE EXC_UNEXP_SKIP_OBJECT;
3672: ELSIF l_return_status ='S' AND
3673: l_Mesg_Token_Tbl.COUNT <>0

Line 3675: Eco_Error_Handler.Log_Error

3671: RAISE EXC_UNEXP_SKIP_OBJECT;
3672: ELSIF l_return_status ='S' AND
3673: l_Mesg_Token_Tbl.COUNT <>0
3674: THEN
3675: Eco_Error_Handler.Log_Error
3676: ( p_ECO_rec => l_ECO_rec
3677: , p_eco_revision_tbl => l_eco_revision_tbl
3678: , p_revised_item_tbl => l_revised_item_tbl
3679: , p_rev_component_tbl => l_rev_component_tbl

Line 3705: Eco_Error_Handler.Log_Error

3701: EXCEPTION
3702:
3703: WHEN EXC_SEV_QUIT_RECORD THEN
3704:
3705: Eco_Error_Handler.Log_Error
3706: ( p_ECO_rec => l_ECO_rec
3707: , p_eco_revision_tbl => l_eco_revision_tbl
3708: , p_revised_item_tbl => l_revised_item_tbl
3709: , p_rev_component_tbl => l_rev_component_tbl

Line 3717: , p_error_scope => Error_Handler.G_SCOPE_RECORD

3713: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3714: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3715: , p_mesg_token_tbl => l_mesg_token_tbl
3716: , p_error_status => FND_API.G_RET_STS_ERROR
3717: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3718: , p_error_level => 1
3719: , x_ECO_rec => l_ECO_rec
3720: , x_eco_revision_tbl => l_eco_revision_tbl
3721: , x_revised_item_tbl => l_revised_item_tbl

Line 3746: Eco_Error_Handler.Log_Error

3742:
3743: RETURN;
3744:
3745: WHEN EXC_UNEXP_SKIP_OBJECT THEN
3746: Eco_Error_Handler.Log_Error
3747: ( p_ECO_rec => l_ECO_rec
3748: , p_eco_revision_tbl => l_eco_revision_tbl
3749: , p_revised_item_tbl => l_revised_item_tbl
3750: , p_rev_component_tbl => l_rev_component_tbl

Line 3757: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

3753: , p_rev_operation_tbl => l_rev_operation_tbl --add
3754: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3755: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3756: , p_mesg_token_tbl => l_mesg_token_tbl
3757: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3758: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
3759: , p_other_message => l_other_message
3760: , p_other_token_tbl => l_other_token_tbl
3761: , p_error_level => 1

Line 3758: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

3754: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3755: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3756: , p_mesg_token_tbl => l_mesg_token_tbl
3757: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3758: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
3759: , p_other_message => l_other_message
3760: , p_other_token_tbl => l_other_token_tbl
3761: , p_error_level => 1
3762: , x_ECO_rec => l_ECO_rec

Line 3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

3913: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:
3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3918: l_other_message VARCHAR2(2000);
3919: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3920:
3921: EXC_ERR_PVT_API_MAIN EXCEPTION;

Line 3919: l_other_token_tbl Error_Handler.Token_Tbl_Type;

3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:
3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3918: l_other_message VARCHAR2(2000);
3919: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3920:
3921: EXC_ERR_PVT_API_MAIN EXCEPTION;
3922:
3923: BEGIN

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

3927: -- Standard call to check for call compatibility
3928:
3929: IF BOM_Globals.get_debug = 'Y'
3930: Then
3931: error_handler.write_debug('here, for test purpose, you can write message.');
3932: END IF;
3933:
3934: --dbms_output.put_line('The following objects will be processed as part of the same business object');
3935: --dbms_output.put_line('| ECO : ' || l_ECO_rec.eco_name);

Line 3986: Error_Handler.Open_Debug_Session

3982:
3983: -- Eco
3984:
3985: /* Bom_Globals.Set_Debug('Y');
3986: Error_Handler.Open_Debug_Session
3987: (p_debug_filename => 'form_debug.log'
3988: , p_output_dir => '/sqlcom/log/dom1151'
3989: , x_return_status => l_return_status
3990: , p_mesg_token_tbl => l_mesg_token_tbl

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

3993: */
3994:
3995: IF BOM_Globals.get_debug = 'Y'
3996: Then
3997: error_handler.write_debug('here, for test purpose, you can write message.');
3998: END IF;
3999:
4000: IF g_control_rec.process_entity = ENG_GLOBALS.G_ENTITY_ECO
4001: THEN

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

4046: END IF;
4047:
4048: IF BOM_Globals.get_debug = 'Y'
4049: Then
4050: error_handler.write_debug('end of ECO header in Process_ECO..');
4051: error_handler.write_debug('here, the process entity is:');
4052: error_handler.write_debug( g_control_rec.process_entity);
4053: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4054:

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

4047:
4048: IF BOM_Globals.get_debug = 'Y'
4049: Then
4050: error_handler.write_debug('end of ECO header in Process_ECO..');
4051: error_handler.write_debug('here, the process entity is:');
4052: error_handler.write_debug( g_control_rec.process_entity);
4053: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4054:
4055:

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

4048: IF BOM_Globals.get_debug = 'Y'
4049: Then
4050: error_handler.write_debug('end of ECO header in Process_ECO..');
4051: error_handler.write_debug('here, the process entity is:');
4052: error_handler.write_debug( g_control_rec.process_entity);
4053: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4054:
4055:
4056: END IF;

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

4049: Then
4050: error_handler.write_debug('end of ECO header in Process_ECO..');
4051: error_handler.write_debug('here, the process entity is:');
4052: error_handler.write_debug( g_control_rec.process_entity);
4053: error_handler.write_debug( ENG_GLOBALS.G_ENTITY_ECO);
4054:
4055:
4056: END IF;
4057:

Line 4058: --error_Handler.Close_Debug_Session;

4054:
4055:
4056: END IF;
4057:
4058: --error_Handler.Close_Debug_Session;
4059:
4060:
4061: --dbms_output.put_line('BO error status: ' || l_bo_return_status);
4062:

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

4141: ) ;
4142:
4143: IF BOM_Globals.get_debug = 'Y'
4144: Then
4145: error_handler.write_debug('after rev_items, the return status is');
4146: error_handler.write_debug(l_return_status);
4147: END IF;
4148:
4149: --dbms_output.put_line('rev items return status: ' || l_revised_item_tbl(1).return_status);

Line 4146: error_handler.write_debug(l_return_status);

4142:
4143: IF BOM_Globals.get_debug = 'Y'
4144: Then
4145: error_handler.write_debug('after rev_items, the return status is');
4146: error_handler.write_debug(l_return_status);
4147: END IF;
4148:
4149: --dbms_output.put_line('rev items return status: ' || l_revised_item_tbl(1).return_status);
4150:

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

4460: -- Reset system_information business object flags
4461:
4462: IF BOM_Globals.get_debug = 'Y'
4463: Then
4464: error_handler.write_debug('before set global variables.');
4465: END IF;
4466:
4467: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
4468: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

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

4473: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
4474: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
4475: IF BOM_Globals.get_debug = 'Y'
4476: Then
4477: error_handler.write_debug('end of process_eco');
4478: END IF;
4479:
4480: EXCEPTION
4481:

Line 4484: Eco_Error_Handler.Log_Error

4480: EXCEPTION
4481:
4482: WHEN EXC_ERR_PVT_API_MAIN THEN
4483:
4484: Eco_Error_Handler.Log_Error
4485: ( p_ECO_rec => l_ECO_rec
4486: , p_eco_revision_tbl => l_eco_revision_tbl
4487: , p_revised_item_tbl => l_revised_item_tbl
4488: , p_rev_component_tbl => l_rev_component_tbl

Line 4496: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

4492: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4493: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4494: , p_mesg_token_tbl => l_mesg_token_tbl
4495: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4496: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4497: , p_other_message => l_other_message
4498: , p_other_token_tbl => l_other_token_tbl
4499: , p_error_level => 0
4500: , x_ECO_rec => l_ECO_rec

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

4559:
4560:
4561: IF BOM_Globals.get_debug = 'Y'
4562: Then
4563: error_handler.write_debug('error in process_eco.');
4564: END IF;
4565: Error_Handler.Close_Debug_Session;
4566:
4567: IF g_control_rec.write_to_db

Line 4565: Error_Handler.Close_Debug_Session;

4561: IF BOM_Globals.get_debug = 'Y'
4562: Then
4563: error_handler.write_debug('error in process_eco.');
4564: END IF;
4565: Error_Handler.Close_Debug_Session;
4566:
4567: IF g_control_rec.write_to_db
4568: THEN
4569: RAISE;

Line 4576: Error_Handler.Add_Error_Token

4572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4573: THEN
4574: l_err_text := G_PKG_NAME || ' : Process ECO '
4575: || substrb(SQLERRM,1,200);
4576: Error_Handler.Add_Error_Token
4577: ( p_Message_Text => l_err_text
4578: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4579: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4580: );

Line 4583: Eco_Error_Handler.Log_Error

4579: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4580: );
4581: END IF;
4582:
4583: Eco_Error_Handler.Log_Error
4584: ( p_ECO_rec => l_ECO_rec
4585: , p_eco_revision_tbl => l_eco_revision_tbl
4586: , p_revised_item_tbl => l_revised_item_tbl
4587: , p_rev_component_tbl => l_rev_component_tbl

Line 4595: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

4591: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4592: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4593: , p_mesg_token_tbl => l_mesg_token_tbl
4594: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4595: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4596: , p_other_message => l_other_message
4597: , p_other_token_tbl => l_other_token_tbl
4598: , p_error_level => 0
4599: , x_ECO_rec => l_ECO_rec