DBA Data[Home] [Help]

APPS.BOM_DEFAULT_SUB_COMPONENT dependencies on ERROR_HANDLER

Line 45: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

41: * Substitute_Item_Quantity
42: *******************************************************************/
43: FUNCTION Get_Substitute_Item_Quantity
44: ( x_return_status IN OUT NOCOPY VARCHAR2
45: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
46: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
47: )
48: RETURN NUMBER
49: IS

Line 51: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

47: )
48: RETURN NUMBER
49: IS
50: l_sub_item_quantity NUMBER;
51: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
52: BEGIN
53: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
54: -- Get Substitute Item quantity from the parent component
55: -- using the component sequence id.

Line 67: Error_Handler.Add_Error_Token

63: RETURN (l_sub_item_quantity);
64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: Error_Handler.Add_Error_Token
68: ( x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
69: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
70: , p_message_name => NULL
71: , p_message_text =>

Line 197: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

193: Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
194: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
195: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
196: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
197: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
198: , x_return_status IN OUT NOCOPY VARCHAR2
199: )
200: IS
201: stmt_num NUMBER := 0;

Line 204: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

200: IS
201: stmt_num NUMBER := 0;
202: l_err_text VARCHAR2(255);
203: l_return_status VARCHAR2(10);
204: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
205: BEGIN
206:
207: -- Initialize g_sub_component_rec
208:

Line 212: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp Seq in attrib Defaulting ' || p_Sub_Comp_Unexp_Rec.component_sequence_id); END IF;

208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211:
212: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp Seq in attrib Defaulting ' || p_Sub_Comp_Unexp_Rec.component_sequence_id); END IF;
213:
214: stmt_num := 1;
215: g_sub_component_rec := p_sub_component_rec;
216:

Line 237: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quantity Defaulted to : ' || to_char(g_sub_component_rec.substitute_item_quantity)); END IF;

233: ( x_return_status => l_return_status
234: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
235: , p_Sub_Comp_Unexp_Rec => p_Sub_Comp_Unexp_Rec
236: );
237: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quantity Defaulted to : ' || to_char(g_sub_component_rec.substitute_item_quantity)); END IF;
238:
239:
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: g_sub_component_rec.substitute_item_quantity := 0;

Line 292: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Sub Comps Attrib Defaulting Done . . .'); END IF;

288: -- Done defaulting attributes
289:
290: x_sub_component_rec := g_sub_component_rec;
291:
292: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Sub Comps Attrib Defaulting Done . . .'); END IF;
293:
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN

Line 478: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

474: Bom_Bo_Pub.G_MISS_Bom_SUB_COMPONENT_REC
475: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
476: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
477: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
478: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
479: , x_return_status IN OUT NOCOPY VARCHAR2
480: )
481: IS
482: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 489: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Comp Seq before conversion ' || p_bom_sub_comp_unexp_rec.component_sequence_id); END IF;

485: --
486: -- Convert the BOM record to ECO
487: --
488:
489: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Comp Seq before conversion ' || p_bom_sub_comp_unexp_rec.component_sequence_id); END IF;
490:
491: Bom_Bo_Pub.Convert_BomSComp_to_EcoSComp
492: ( p_bom_sub_component_rec => p_bom_sub_component_rec
493: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec

Line 517: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Qty after conversion: ' || l_sub_component_rec.substitute_item_quantity); END IF;

513: , p_sub_comp_unexp_rec => l_sub_comp_unexp_rec
514: , x_bom_sub_component_rec => x_bom_sub_component_rec
515: , x_bom_sub_comp_unexp_rec => x_bom_sub_comp_unexp_rec
516: );
517: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Qty after conversion: ' || l_sub_component_rec.substitute_item_quantity); END IF;
518:
519: END Attribute_Defaulting;
520:
521: PROCEDURE Populate_Null_Columns