APPS.BOM_COMP_OPERATION_UTIL dependencies on FND_API

Line 55: l_return_status := FND_API.G_RET_STS_SUCCESS;

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;
56:
57: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
58: UPDATE BOM_COMPONENT_OPERATIONS
59: SET OPERATION_SEQ_NUM

Line 63: FND_API.G_MISS_NUM,

59: SET OPERATION_SEQ_NUM
60: = decode( p_bom_comp_ops_rec.new_additional_op_seq_num,
61: NULL,
62: p_bom_comp_ops_rec.additional_operation_seq_num,
63: FND_API.G_MISS_NUM,
64: p_bom_comp_ops_rec.additional_operation_seq_num,
65: p_bom_comp_ops_rec.new_additional_op_seq_num
66: )
67: , OPERATION_SEQUENCE_ID

Line 71: FND_API.G_MISS_NUM,

67: , OPERATION_SEQUENCE_ID
68: = decode(p_bom_comp_ops_unexp_rec.new_additional_op_seq_id,
69: NULL,
70: p_bom_comp_ops_unexp_rec.additional_operation_seq_id,
71: FND_API.G_MISS_NUM,
72: p_bom_comp_ops_unexp_rec.additional_operation_seq_id,
73: p_bom_comp_ops_unexp_rec.new_additional_op_seq_id
74: )
75: , ATTRIBUTE_CATEGORY = p_bom_comp_ops_rec.attribute_category

Line 113: l_return_status := FND_API.G_RET_STS_ERROR;

109: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
110: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
111: );
112:
113: l_return_status := FND_API.G_RET_STS_ERROR;
114: ELSE
115: BOMPCMBM.Update_Related_Comp_Ops(p_component_sequence_id => l_comp_seq_id
116: , p_old_operation_seq_num => p_bom_comp_ops_rec.additional_operation_seq_num
117: , p_new_operation_seq_num => nvl(p_bom_comp_ops_rec.new_additional_op_seq_num,

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
145: );
146: END IF;
147: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149:
150: END Update_Row;
151:
152:

Line 276: --x_return_status := FND_API.G_RET_STS_SUCCESS;

272: , SYSDATE
273: , l_src_comp_seq_id --bug 7713832
274: );
275:
276: --x_return_status := FND_API.G_RET_STS_SUCCESS;
277: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN --Bug 7713832
278: BOMPCMBM.Insert_Related_Comp_Ops(p_component_sequence_id => p_bom_comp_ops_unexp_rec.component_sequence_id
279: , p_operation_seq_num => p_bom_comp_ops_rec.additional_operation_seq_num
280: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
298: );
299: END IF;
300: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302:
303: END Insert_Row;
304:
305:

Line 328: l_return_status := FND_API.G_RET_STS_SUCCESS;

324: l_comp_seq_id NUMBER;
325: l_op_seq_num NUMBER;
326: BEGIN
327:
328: l_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: SELECT component_sequence_id, operation_seq_num
331: INTO l_comp_seq_id, l_op_seq_num
332: FROM BOM_COMPONENT_OPERATIONS

Line 346: l_return_status := FND_API.G_RET_STS_ERROR;

342: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
343: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
344: );
345:
346: l_return_status := FND_API.G_RET_STS_ERROR;
347:
348: ELSE
349: BOMPCMBM.Delete_Related_Comp_Ops(p_src_comp_seq_id => l_comp_seq_id,
350: p_operation_seq_num => l_op_seq_num,

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
372: );
373: END IF;
374: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376:
377: END Delete_Row;
378:
379: /********************************************************************