DBA Data[Home] [Help]

APPS.BOM_REF_DESIGNATOR_UTIL dependencies on ERROR_HANDLER

Line 158: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

154:
155: PROCEDURE Update_Row
156: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
157: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
158: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159: , x_Return_Status IN OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_return_status varchar2(80);

Line 163: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

159: , x_Return_Status IN OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_return_status varchar2(80);
163: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
164: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
165: l_Token_Tbl Error_Handler.Token_Tbl_Type;
166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
167: BEGIN

Line 165: l_Token_Tbl Error_Handler.Token_Tbl_Type;

161: IS
162: l_return_status varchar2(80);
163: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
164: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
165: l_Token_Tbl Error_Handler.Token_Tbl_Type;
166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
167: BEGIN
168: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
169: UPDATE BOM_REFERENCE_DESIGNATORS

Line 240: Error_Handler.Add_Error_Token

236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: RAISE;
238: END IF;
239:
240: Error_Handler.Add_Error_Token
241: ( p_Message_Name => NULL
242: , p_Message_Text => 'ERROR in Update Row (Ref Desgs)' ||
243: substr(SQLERRM, 1, 100) || ' ' ||
244: to_char(SQLCODE)

Line 268: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

264:
265: PROCEDURE Insert_Row
266: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
267: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
268: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
269: , x_Return_Status IN OUT NOCOPY VARCHAR2
270: )
271: IS
272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

268: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
269: , x_Return_Status IN OUT NOCOPY VARCHAR2
270: )
271: IS
272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
273: BEGIN
274:
275: INSERT INTO BOM_REFERENCE_DESIGNATORS
276: ( COMPONENT_REFERENCE_DESIGNATOR

Line 358: Error_Handler.Add_Error_Token

354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: RAISE;
356: END IF;
357:
358: Error_Handler.Add_Error_Token
359: ( p_Message_Name => NULL
360: , p_Message_Text => 'ERROR in Insert Row (Ref Desgs)' ||
361: substr(SQLERRM, 1, 100) || ' ' ||
362: to_char(SQLCODE)

Line 367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;

363: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
364: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
365: );
366:
367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('ERROR in Insert Row (Ref Desgs)' || substr(SQLERRM, 1, 100) || ' ' || to_char(SQLCODE)); END IF;
368:
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370:
371: END Insert_Row;

Line 389: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

385: PROCEDURE Delete_Row
386: ( p_ref_designator IN VARCHAR2
387: , p_component_sequence_id IN NUMBER
388: , p_acd_type IN NUMBER
389: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
390: , x_Return_Status IN OUT NOCOPY VARCHAR2
391: )
392: IS
393: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 393: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

389: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
390: , x_Return_Status IN OUT NOCOPY VARCHAR2
391: )
392: IS
393: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
394: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
395:
396: BEGIN
397:

Line 423: Error_Handler.Add_Error_Token

419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: RAISE;
421: END IF;
422:
423: Error_Handler.Add_Error_Token
424: ( p_Message_Name => NULL
425: , p_Message_Text => 'ERROR in Delete Row (Ref Desgs)' ||
426: substr(SQLERRM, 1, 100) || ' ' ||
427: to_char(SQLCODE)

Line 535: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

531: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
532: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
533: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
534: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
535: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
536: , x_return_status IN OUT NOCOPY VARCHAR2
537: )
538: IS
539: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 539: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

535: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
536: , x_return_status IN OUT NOCOPY VARCHAR2
537: )
538: IS
539: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
540: l_return_status VARCHAR2(1);
541: BEGIN
542: l_return_status := FND_API.G_RET_STS_SUCCESS;
543:

Line 661: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

657:
658: PROCEDURE Perform_Writes
659: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_rec_Type
660: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
661: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
662: , x_return_status IN OUT NOCOPY VARCHAR2
663: )
664: IS
665: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;