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 293: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

289:
290: PROCEDURE Insert_Row
291: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
292: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
293: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
294: , x_Return_Status IN OUT NOCOPY VARCHAR2
295: )
296: IS
297: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 297: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

293: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
294: , x_Return_Status IN OUT NOCOPY VARCHAR2
295: )
296: IS
297: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
298: l_src_comp_seq_id NUMBER := NULL; --bug 7713832
299: BEGIN
300:
301: --Bug 7712832 changes start

Line 394: Error_Handler.Add_Error_Token

390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: RAISE;
392: END IF;
393:
394: Error_Handler.Add_Error_Token
395: ( p_Message_Name => NULL
396: , p_Message_Text => 'ERROR in Insert Row (Ref Desgs)' ||
397: substr(SQLERRM, 1, 100) || ' ' ||
398: to_char(SQLCODE)

Line 403: 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;

399: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
400: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
401: );
402:
403: 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;
404:
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: END Insert_Row;

Line 425: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

421: PROCEDURE Delete_Row
422: ( p_ref_designator IN VARCHAR2
423: , p_component_sequence_id IN NUMBER
424: , p_acd_type IN NUMBER
425: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
426: , x_Return_Status IN OUT NOCOPY VARCHAR2
427: )
428: IS
429: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 429: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

425: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
426: , x_Return_Status IN OUT NOCOPY VARCHAR2
427: )
428: IS
429: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
430: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
431:
432: BEGIN
433:

Line 459: Error_Handler.Add_Error_Token

455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: RAISE;
457: END IF;
458:
459: Error_Handler.Add_Error_Token
460: ( p_Message_Name => NULL
461: , p_Message_Text => 'ERROR in Delete Row (Ref Desgs)' ||
462: substr(SQLERRM, 1, 100) || ' ' ||
463: to_char(SQLCODE)

Line 571: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

567: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
568: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
569: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
570: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
571: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
572: , x_return_status IN OUT NOCOPY VARCHAR2
573: )
574: IS
575: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 575: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

571: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
572: , x_return_status IN OUT NOCOPY VARCHAR2
573: )
574: IS
575: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
576: l_return_status VARCHAR2(1);
577: BEGIN
578: l_return_status := FND_API.G_RET_STS_SUCCESS;
579:

Line 697: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

693:
694: PROCEDURE Perform_Writes
695: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_rec_Type
696: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
697: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
698: , x_return_status IN OUT NOCOPY VARCHAR2
699: )
700: IS
701: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;