DBA Data[Home] [Help]

APPS.ENG_ECO_REVISION_UTIL dependencies on ERROR_HANDLER

Line 136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

132: ****************************************************************************/
133: PROCEDURE Update_Row
134: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
135: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: , x_Return_Status OUT NOCOPY VARCHAR2
138: )
139: IS
140: l_Return_Status VARCHAR2(1);

Line 141: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

137: , x_Return_Status OUT NOCOPY VARCHAR2
138: )
139: IS
140: l_Return_Status VARCHAR2(1);
141: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
142: l_err_text VARCHAR2(2000);
143: l_user_id NUMBER;
144: l_login_id NUMBER;
145: l_prog_appid NUMBER;

Line 213: Error_Handler.Add_Error_Token

209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
210: THEN
211: l_err_text := G_PKG_NAME || ' : Utility (ECO Update) '
212: || substrb(SQLERRM,1,200);
213: Error_Handler.Add_Error_Token
214: ( p_Message_Text => l_err_text
215: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
216: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
217: );

Line 237: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

233: ***************************************************************************/
234: PROCEDURE Insert_Row
235: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
236: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
237: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
238: , x_Return_Status OUT NOCOPY VARCHAR2
239: )
240: IS
241: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 241: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

237: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
238: , x_Return_Status OUT NOCOPY VARCHAR2
239: )
240: IS
241: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
242: l_user_id NUMBER;
243: l_login_id NUMBER;
244: l_prog_appid NUMBER;
245: l_prog_id NUMBER;

Line 388: Error_Handler.Add_Error_Token

384: END IF;
385:
386: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: Error_Handler.Add_Error_Token
389: ( p_Message_Name => NULL
390: , p_Message_Text => 'ERROR in Insert Row (ECO Rev) ' ||
391: SUBSTR(SQLERRM, 1, 100) || ' ' ||
392: TO_CHAR(SQLCODE)

Line 412: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

408: ***************************************************************************/
409:
410: PROCEDURE Delete_Row
411: ( p_revision_id IN NUMBER
412: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
413: , x_Return_Status OUT NOCOPY VARCHAR2
414: )
415: IS
416: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 416: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

412: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
413: , x_Return_Status OUT NOCOPY VARCHAR2
414: )
415: IS
416: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
417: BEGIN
418:
419: DELETE FROM ENG_CHANGE_ORDER_REVISIONS
420: WHERE REVISION_ID = p_revision_id;

Line 431: Error_Handler.Add_Error_Token

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: RAISE;
429: END IF;
430:
431: Error_Handler.Add_Error_Token
432: ( p_Message_Name => 'OE_LOCK_ROW_DELETED'
433: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
434: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
435: );

Line 448: Error_Handler.Add_Error_Token

444: END IF;
445:
446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
447: THEN
448: Error_Handler.Add_Error_Token
449: ( p_Message_Name => NULL
450: , p_Message_Text => 'ERROR in Delete Row (ECO Rev) ' ||
451: substr(SQLERRM, 1, 30) || ' ' ||
452: to_char(SQLCODE)

Line 560: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

556: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
557: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
558: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
559: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
560: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
561: , x_return_status OUT NOCOPY VARCHAR2
562: )
563: IS
564: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 564: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

560: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
561: , x_return_status OUT NOCOPY VARCHAR2
562: )
563: IS
564: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
565: l_return_status VARCHAR2(1);
566: BEGIN
567: l_return_status := FND_API.G_RET_STS_SUCCESS;
568: