eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_REF_DESIGNATOR_UTIL dependencies on FND_API

Line 13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM

9:
10: -- Procedure Clear_Dependent_Attr
11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM
14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

Line 53: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN

49: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
50: p_ref_designator_rec;
51: BEGIN
52:
53: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN
54: l_ref_designator_rec.Reference_Designator_Name := NULL;
55: END IF;
56:
57: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 57: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN

53: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN
54: l_ref_designator_rec.Reference_Designator_Name := NULL;
55: END IF;
56:
57: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
58: l_ref_designator_rec.attribute_category := NULL;
59: END IF;
60:
61: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 61: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN

57: IF l_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
58: l_ref_designator_rec.attribute_category := NULL;
59: END IF;
60:
61: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
62: l_ref_designator_rec.attribute1 := NULL;
63: END IF;
64:
65: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 65: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN

61: IF l_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
62: l_ref_designator_rec.attribute1 := NULL;
63: END IF;
64:
65: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
66: l_ref_designator_rec.attribute2 := NULL;
67: END IF;
68:
69: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 69: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN

65: IF l_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
66: l_ref_designator_rec.attribute2 := NULL;
67: END IF;
68:
69: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
70: l_ref_designator_rec.attribute3 := NULL;
71: END IF;
72:
73: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 73: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN

69: IF l_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
70: l_ref_designator_rec.attribute3 := NULL;
71: END IF;
72:
73: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
74: l_ref_designator_rec.attribute4 := NULL;
75: END IF;
76:
77: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 77: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN

73: IF l_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
74: l_ref_designator_rec.attribute4 := NULL;
75: END IF;
76:
77: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
78: l_ref_designator_rec.attribute5 := NULL;
79: END IF;
80:
81: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 81: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN

77: IF l_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
78: l_ref_designator_rec.attribute5 := NULL;
79: END IF;
80:
81: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
82: l_ref_designator_rec.attribute6 := NULL;
83: END IF;
84:
85: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 85: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN

81: IF l_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
82: l_ref_designator_rec.attribute6 := NULL;
83: END IF;
84:
85: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
86: l_ref_designator_rec.attribute7 := NULL;
87: END IF;
88:
89: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 89: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN

85: IF l_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
86: l_ref_designator_rec.attribute7 := NULL;
87: END IF;
88:
89: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
90: l_ref_designator_rec.attribute8 := NULL;
91: END IF;
92:
93: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 93: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN

89: IF l_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
90: l_ref_designator_rec.attribute8 := NULL;
91: END IF;
92:
93: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
94: l_ref_designator_rec.attribute9 := NULL;
95: END IF;
96:
97: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 97: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN

93: IF l_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
94: l_ref_designator_rec.attribute9 := NULL;
95: END IF;
96:
97: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
98: l_ref_designator_rec.attribute10 := NULL;
99: END IF;
100:
101: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 101: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN

97: IF l_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
98: l_ref_designator_rec.attribute10 := NULL;
99: END IF;
100:
101: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
102: l_ref_designator_rec.attribute11 := NULL;
103: END IF;
104:
105: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 105: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN

101: IF l_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
102: l_ref_designator_rec.attribute11 := NULL;
103: END IF;
104:
105: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
106: l_ref_designator_rec.attribute12 := NULL;
107: END IF;
108:
109: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 109: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN

105: IF l_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
106: l_ref_designator_rec.attribute12 := NULL;
107: END IF;
108:
109: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
110: l_ref_designator_rec.attribute13 := NULL;
111: END IF;
112:
113: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 113: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN

109: IF l_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
110: l_ref_designator_rec.attribute13 := NULL;
111: END IF;
112:
113: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
114: l_ref_designator_rec.attribute14 := NULL;
115: END IF;
116:
117: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 117: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN

113: IF l_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
114: l_ref_designator_rec.attribute14 := NULL;
115: END IF;
116:
117: IF l_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN
118: l_ref_designator_rec.attribute15 := NULL;
119: END IF;
120:
121: RETURN l_ref_designator_rec;

Line 182: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

178: p_Ref_Desg_Unexp_Rec.component_sequence_id
179: AND ACD_TYPE = p_Ref_Designator_Rec.acd_type
180: ;
181:
182: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: Error_Handler.Add_Error_Token

Line 194: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

190: to_char(SQLCODE)
191: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
192: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl);
193:
194: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
195:
196: END Update_Row;
197:
198: /********************************************************************

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: , p_ref_designator_rec.attribute15
285: , p_ref_designator_rec.Original_System_Reference
286: );
287:
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: EXCEPTION
290:
291: WHEN OTHERS THEN
292: Error_Handler.Add_Error_Token

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: -- substr(SQLERRM, 1, 100) || ' ' ||
303: -- to_char(SQLCODE)
304: -- );
305:
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307:
308: END Insert_Row;
309:
310: /********************************************************************

Line 340: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

336: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
337: AND ACD_TYPE = p_acd_type
338: ;
339:
340: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: Error_Handler.Add_Error_Token

Line 352: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

348: to_char(SQLCODE)
349: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
350: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
351: );
352: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
353:
354: END Delete_Row;
355:
356: /********************************************************************

Line 444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

440: WHEN NO_DATA_FOUND THEN
441: x_Return_Status := Bom_Globals.G_RECORD_NOT_FOUND;
442:
443: WHEN OTHERS THEN
444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: END Query_Row;
447:
448: PROCEDURE Perform_Writes

Line 458: l_return_status := FND_API.G_RET_STS_SUCCESS;

454: IS
455: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
456: l_return_status VARCHAR2(1);
457: BEGIN
458: l_return_status := FND_API.G_RET_STS_SUCCESS;
459:
460: IF p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_CREATE
461: THEN
462: Insert_Row( p_ref_designator_rec =>