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

163: ********************************************************************/
164: PROCEDURE Insert_Row
165: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
166: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
167: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
168: , x_return_status IN OUT NOCOPY VARCHAR2
169: )
170: IS
171: l_err_text VARCHAR2(255);

Line 173: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

169: )
170: IS
171: l_err_text VARCHAR2(255);
172: l_return_status VARCHAR2(200);
173: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
174: BEGIN
175:
176:
177: INSERT INTO BOM_COMPONENT_OPERATIONS

Line 257: Error_Handler.Add_Error_Token

253: THEN
254: l_err_text := G_PKG_NAME ||
255: 'Utility (Component Operations Insert)' ||
256: SUBSTR(SQLERRM, 1, 100);
257: Error_Handler.Add_Error_Token
258: ( p_Message_Name => NULL
259: , p_Message_text => l_err_text
260: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
261: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 281: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

277: * primary unique key.
278: ********************************************************************/
279: PROCEDURE Delete_Row
280: ( p_comp_operation_seq_id IN NUMBER
281: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
282: , x_return_status IN OUT NOCOPY VARCHAR2
283: )
284: IS
285: l_return_status VARCHAR2(200);

Line 287: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

283: )
284: IS
285: l_return_status VARCHAR2(200);
286: l_err_text VARCHAR2(255);
287: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
288: l_comp_seq_id NUMBER;
289: l_op_seq_num NUMBER;
290: BEGIN
291:

Line 304: Error_Handler.Add_Error_Token

300: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
301:
302: IF SQL%NOTFOUND THEN
303:
304: Error_Handler.Add_Error_Token
305: ( p_Message_name => 'BOM_NOT_DELETE_ROW'
306: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
307: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
308: );

Line 331: Error_Handler.Add_Error_Token

327: l_err_text := G_PKG_NAME ||
328: 'Utility (Component Operations Delete_Row)' ||
329: SUBSTR(SQLERRM, 1, 100);
330:
331: Error_Handler.Add_Error_Token
332: ( p_Message_Name => NULL
333: , p_Message_Text => l_err_text
334: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
335: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 435: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

431:
432: PROCEDURE Perform_Writes
433: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
434: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
435: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
436: , x_Return_Status IN OUT NOCOPY VARCHAR2
437: )
438: IS
439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

435: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
436: , x_Return_Status IN OUT NOCOPY VARCHAR2
437: )
438: IS
439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
440: l_return_status VARCHAR2(1);
441: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
442: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
443: BEGIN