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_VALIDATE_ECO_REVISION dependencies on FND_API

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

22: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
23: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
24: )
25: IS
26: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: l_dummy VARCHAR2(80);
28: l_processed BOOLEAN;
29: l_token_tbl Error_Handler.Token_Tbl_Type;
30: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 55: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

51: x_err_text => l_err_text
52: );
53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
56: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: END;
58:
59: END IF;

Line 56: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

52: );
53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
56: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: END;
58:
59: END IF;
60:

Line 101: l_return_status := FND_API.G_RET_STS_ERROR;

97: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
98: , p_message_name => 'ENG_ECO_REVISION_NOT_UNIQUE'
99: , p_token_tbl => l_token_tbl
100: );
101: l_return_status := FND_API.G_RET_STS_ERROR;
102: END;
103: END IF;
104: x_return_status := l_return_status;
105: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
106:
107: EXCEPTION
108:
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

107: EXCEPTION
108:
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: END Check_Entity;
122:
123: -- Procedure Attributes

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: )
130: IS
131: BEGIN
132:
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: -- AT THE REVISIONS LEVEL THERE ARE NO COLUMNS APART FROM THE DESCRIPTIVE
136: -- FLEX WHICH CAN BE ATTRIBUTE VALIDATED.
137: -- VALIDITY OF ORGANIZATION_ID AND CHANGE_NOTICE WILL HAPPEN IN THE

Line 146: WHEN FND_API.G_EXC_ERROR THEN

142: --dbms_output.put_line('Performing ECO Revisions Attribute Validation . . .');
143:
144: EXCEPTION
145:
146: WHEN FND_API.G_EXC_ERROR THEN
147:
148: x_return_status := FND_API.G_RET_STS_ERROR;
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: EXCEPTION
145:
146: WHEN FND_API.G_EXC_ERROR THEN
147:
148: x_return_status := FND_API.G_RET_STS_ERROR;
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: WHEN FND_API.G_EXC_ERROR THEN
147:
148: x_return_status := FND_API.G_RET_STS_ERROR;
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: WHEN OTHERS THEN

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

148: x_return_status := FND_API.G_RET_STS_ERROR;
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: WHEN OTHERS THEN
155:
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153:
154: WHEN OTHERS THEN
155:
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157:
158: END Check_Attributes;
159:
160: -- Procedure Entity_Delete

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

165: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
166: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
167: )
168: IS
169: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
170: BEGIN
171:
172: -- Validation of whether the ECO is implemented or canceled will
173: -- happen in earlier steps

Line 232: l_return_status := FND_API.G_RET_STS_ERROR;

228: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
229: , p_message_name => 'ENG_ECO_REV_ALREADY_EXISTS'
230: , p_token_tbl => l_token_tbl
231: );
232: l_return_status := FND_API.G_RET_STS_ERROR;
233: ELSIF l_return_status = Eng_Globals.G_RECORD_NOT_FOUND AND
234: p_eco_revision_rec.transaction_type IN
235: (Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)
236: THEN

Line 243: l_return_status := FND_API.G_RET_STS_ERROR;

239: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
240: , p_message_name => 'ENG_ECO_REV_DOESNOT_EXIST'
241: , p_token_tbl => l_token_tbl
242: );
243: l_return_status := FND_API.G_RET_STS_ERROR;
244: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
245: THEN
246: Error_Handler.Add_Error_Token
247: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 244: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

240: , p_message_name => 'ENG_ECO_REV_DOESNOT_EXIST'
241: , p_token_tbl => l_token_tbl
242: );
243: l_return_status := FND_API.G_RET_STS_ERROR;
244: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
245: THEN
246: Error_Handler.Add_Error_Token
247: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
248: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 253: l_return_status := FND_API.G_RET_STS_SUCCESS;

249: , p_message_name => 'ENG_REV_EXS_UNEXP_SKIP'
250: , p_token_tbl => l_token_tbl
251: );
252: ELSE
253: l_return_status := FND_API.G_RET_STS_SUCCESS;
254: END IF;
255:
256: x_return_status := l_return_status;
257: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

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

275: )
276: IS
277: l_token_tbl Error_Handler.Token_Tbl_Type;
278: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
279: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
280: BEGIN
281: --
282: -- Use the ECO Check Access procedure to verify if the user has
283: -- access to the current ECO.

Line 303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

299: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
300: , x_Return_Status => l_return_status
301: );
302:
303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
304: THEN
305: Error_Handler.Add_Error_Token
306: ( p_Message_Name => 'ENG_REV_ACCESS_FAT_FATAL'
307: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 336: p_eco_revision_rec.revision = FND_API.G_MISS_CHAR

332: l_mesg_token_tbl Error_Handler.Mesg_token_Tbl_Type;
333:
334: BEGIN
335: IF p_eco_revision_rec.revision IS NULL OR
336: p_eco_revision_rec.revision = FND_API.G_MISS_CHAR
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: Error_Handler.Add_Error_Token
340: ( x_mesg_token_tbl => x_mesg_token_tbl

Line 338: x_return_status := FND_API.G_RET_STS_ERROR;

334: BEGIN
335: IF p_eco_revision_rec.revision IS NULL OR
336: p_eco_revision_rec.revision = FND_API.G_MISS_CHAR
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: Error_Handler.Add_Error_Token
340: ( x_mesg_token_tbl => x_mesg_token_tbl
341: , p_mesg_token_tbl => l_mesg_token_tbl
342: , p_message_name => 'ENG_REVISION_KEYCOL_NULL'

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: , p_mesg_token_tbl => l_mesg_token_tbl
342: , p_message_name => 'ENG_REVISION_KEYCOL_NULL'
343: );
344: ELSE
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: END IF;
347:
348: END CHECK_REQUIRED;
349: