DBA Data[Home] [Help]

APPS.BOM_COMP_OPERATION_UTIL dependencies on ERROR_HANDLER

Line 43: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

39:
40: PROCEDURE Update_Row
41: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
42: , p_bom_comp_ops_unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
43: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44: , x_return_status IN OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type :=

Line 51: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

47: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type :=
48: p_bom_comp_ops_rec;
49: l_return_status VARCHAR2(200);
50: l_err_text VARCHAR2(255);
51: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
52: l_comp_seq_id NUMBER;
53: BEGIN
54:
55: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 107: Error_Handler.Add_Error_Token

103: WHERE COMP_OPERATION_SEQ_ID = p_bom_comp_ops_unexp_rec.comp_operation_seq_id ;
104:
105: IF SQL%NOTFOUND THEN
106:
107: Error_Handler.Add_Error_Token
108: ( p_Message_name => 'BOM_NOT_UPDATE_ROW'
109: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
110: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
111: );

Line 140: Error_Handler.Add_Error_Token

136: l_err_text := G_PKG_NAME ||
137: 'Utility (Component Operations Update)' ||
138: SUBSTR(SQLERRM, 1, 100);
139:
140: Error_Handler.Add_Error_Token
141: ( p_Message_Name => NULL
142: , p_Message_Text => l_err_text
143: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
144: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 193: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

189: ********************************************************************/
190: PROCEDURE Insert_Row
191: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
192: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
193: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
194: , x_return_status IN OUT NOCOPY VARCHAR2
195: )
196: IS
197: l_err_text VARCHAR2(255);

Line 199: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

195: )
196: IS
197: l_err_text VARCHAR2(255);
198: l_return_status VARCHAR2(200);
199: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
200: l_src_comp_seq_id NUMBER := NULL; --bug 7713832
201: BEGIN
202: --Bug 7712832 changes start
203: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN

Line 293: Error_Handler.Add_Error_Token

289: THEN
290: l_err_text := G_PKG_NAME ||
291: 'Utility (Component Operations Insert)' ||
292: SUBSTR(SQLERRM, 1, 100);
293: Error_Handler.Add_Error_Token
294: ( p_Message_Name => NULL
295: , p_Message_text => l_err_text
296: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
297: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 317: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

313: * primary unique key.
314: ********************************************************************/
315: PROCEDURE Delete_Row
316: ( p_comp_operation_seq_id IN NUMBER
317: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
318: , x_return_status IN OUT NOCOPY VARCHAR2
319: )
320: IS
321: l_return_status VARCHAR2(200);

Line 323: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

319: )
320: IS
321: l_return_status VARCHAR2(200);
322: l_err_text VARCHAR2(255);
323: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
324: l_comp_seq_id NUMBER;
325: l_op_seq_num NUMBER;
326: BEGIN
327:

Line 340: Error_Handler.Add_Error_Token

336: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
337:
338: IF SQL%NOTFOUND THEN
339:
340: Error_Handler.Add_Error_Token
341: ( p_Message_name => 'BOM_NOT_DELETE_ROW'
342: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
343: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
344: );

Line 367: Error_Handler.Add_Error_Token

363: l_err_text := G_PKG_NAME ||
364: 'Utility (Component Operations Delete_Row)' ||
365: SUBSTR(SQLERRM, 1, 100);
366:
367: Error_Handler.Add_Error_Token
368: ( p_Message_Name => NULL
369: , p_Message_Text => l_err_text
370: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
371: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 471: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

467:
468: PROCEDURE Perform_Writes
469: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
470: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
471: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
472: , x_Return_Status IN OUT NOCOPY VARCHAR2
473: )
474: IS
475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

471: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
472: , x_Return_Status IN OUT NOCOPY VARCHAR2
473: )
474: IS
475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
476: l_return_status VARCHAR2(1);
477: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
478: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
479: BEGIN