APPS.BOM_RTG_HEADER_UTIL dependencies on FND_API

Line 48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

44: )
45: IS
46: l_rtg_header_rec Bom_Rtg_Pub.Rtg_header_Rec_Type;
47: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_header_Unexposed_Rec_Type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN
51:
52: SELECT assembly_item_id

Line 119: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR )

115: , l_rtg_header_rec.attribute15
116: FROM bom_operational_routings
117: WHERE assembly_item_id = p_assembly_item_id
118: AND organization_id = p_organization_id
119: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR )
120: = NVL( p_alternate_routing_code, FND_API.G_MISS_CHAR )
121: ;
122:
123:

Line 120: = NVL( p_alternate_routing_code, FND_API.G_MISS_CHAR )

116: FROM bom_operational_routings
117: WHERE assembly_item_id = p_assembly_item_id
118: AND organization_id = p_organization_id
119: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR )
120: = NVL( p_alternate_routing_code, FND_API.G_MISS_CHAR )
121: ;
122:
123:
124: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND;
131: x_rtg_header_rec := l_rtg_header_rec;
132: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
133: WHEN OTHERS THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: x_rtg_header_rec := l_rtg_header_rec;
136: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
137:
138: END Query_Row;

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: END IF;
300:
301: END IF ;
302:
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: Error_Handler.Add_Error_Token

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310: ' :Inserting Record ' ||
311: SQLERRM
312: , x_mesg_token_Tbl => x_mesg_token_tbl
313: );
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315:
316: END Insert_Row;
317:
318: /********************************************************************

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: , program_update_date = SYSDATE
392: WHERE routing_sequence_id =
393: p_rtg_header_unexp_rec.routing_sequence_id
394: ;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: END Update_Row;
398:
399:

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: l_dg_sequence_id NUMBER;
429: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
430:
431: BEGIN
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: FOR DG IN CheckGroup
435: LOOP
436: IF DG.delete_type <> 3 /* Routing */ then

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: l_mesg_token_Tbl
442: , x_mesg_token_tbl =>
443: l_mesg_token_tbl
444: );
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_mesg_token_tbl := l_mesg_token_tbl;
447: RETURN;
448: END IF;
449:

Line 456: IF l_rtg_header_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM

452: l_rtg_header_rec.DG_Description := DG.description;
453:
454: END LOOP;
455:
456: IF l_rtg_header_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
457: THEN
458: l_dg_sequence_id := l_rtg_header_unexp_rec.DG_Sequence_Id;
459: ELSE
460: l_dg_sequence_id := NULL;

Line 521: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

517: , x_return_status IN OUT NOCOPY VARCHAR2
518: )
519: IS
520: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
521: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
522: BEGIN
523: IF p_rtg_header_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
524: THEN
525: Insert_Row