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.BOM_VALIDATE_RTG_REVISION dependencies on FND_API

Line 105: l_return_status := FND_API.G_RET_STS_ERROR;

101: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
102: , p_message_name => 'BOM_RTG_REV_ALREADY_EXISTS'
103: , p_token_tbl => l_token_tbl
104: );
105: l_return_status := FND_API.G_RET_STS_ERROR;
106: ELSIF l_return_status = BOM_Rtg_Globals.G_RECORD_NOT_FOUND AND
107: p_rtg_revision_rec.transaction_type IN
108: (BOM_RTG_Globals.G_OPR_UPDATE, BOM_Rtg_Globals.G_OPR_DELETE)
109: THEN

Line 120: l_return_status := FND_API.G_RET_STS_ERROR;

116: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
117: , p_message_name => 'BOM_RTG_REV_DOESNOT_EXISTS'
118: , p_token_tbl => l_token_tbl
119: );
120: l_return_status := FND_API.G_RET_STS_ERROR;
121: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
122: THEN
123: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
124: l_token_tbl(1).token_value :=

Line 121: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

117: , p_message_name => 'BOM_RTG_REV_DOESNOT_EXISTS'
118: , p_token_tbl => l_token_tbl
119: );
120: l_return_status := FND_API.G_RET_STS_ERROR;
121: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
122: THEN
123: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
124: l_token_tbl(1).token_value :=
125: p_rtg_revision_rec.assembly_item_name;

Line 139: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135: 'Assembly item revision'||
136: p_rtg_revision_rec.assembly_item_name
137: , p_token_tbl => l_token_tbl
138: );
139: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
141: THEN
142: l_return_status := FND_API.G_RET_STS_SUCCESS;
143: END IF;

Line 140: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS

136: p_rtg_revision_rec.assembly_item_name
137: , p_token_tbl => l_token_tbl
138: );
139: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
141: THEN
142: l_return_status := FND_API.G_RET_STS_SUCCESS;
143: END IF;
144:

Line 142: l_return_status := FND_API.G_RET_STS_SUCCESS;

138: );
139: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
141: THEN
142: l_return_status := FND_API.G_RET_STS_SUCCESS;
143: END IF;
144:
145: x_return_status := l_return_status;
146: x_mesg_token_tbl := l_mesg_token_tbl;

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: AND process_revision = p_rtg_revision_rec.revision;
180:
181: BEGIN
182:
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
186: Error_Handler.Write_Debug(
187: 'Within Rtg Revision Check Attributes . . . ');

Line 199: IF l_eco IS NOT NULL AND l_eco <> FND_API.G_MISS_CHAR THEN

195: THEN
196: open c_created_by_eco;
197: fetch c_created_by_eco into l_eco;
198: close c_created_by_eco;
199: IF l_eco IS NOT NULL AND l_eco <> FND_API.G_MISS_CHAR THEN
200: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
201: Error_Handler.Write_Debug(
202: 'Within Rtg Revision Check Attributes 1. . . ');
203: END IF;

Line 207: FND_API.G_MISS_DATE THEN

203: END IF;
204:
205: IF p_rtg_revision_rec.start_effective_date IS NOT NULL
206: AND p_rtg_revision_rec.start_effective_date <>
207: FND_API.G_MISS_DATE THEN
208: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
209: Error_Handler.Write_Debug
210: ('Within Rtg Revision Check Attributes 2. . . ');
211: END IF;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: , p_token_tbl => l_token_tbl
226: , p_mesg_token_tbl => l_mesg_token_tbl
227: , x_mesg_token_tbl => l_mesg_token_tbl
228: );
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: END IF;
231: END IF;-- if eco is NOT NULL
232: END IF;
233: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: -- Revision name is not allowed to use 'Quote'.
292: --
293:
294: IF INSTR(p_rtg_revision_Rec.revision, '''') <> 0 THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:
297: Error_Handler.Add_Error_Token
298: ( p_mesg_token_tbl => l_mesg_token_tbl
299: ,x_mesg_token_tbl => l_mesg_token_tbl

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: , p_mesg_token_tbl => l_mesg_token_tbl
322: , x_mesg_token_tbl => l_mesg_token_tbl
323: , p_token_tbl => l_token_tbl
324: );
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: l_token_tbl.delete(3);
327: END IF;
328: END IF;
329:

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: AND nvl(alternate_routing_designator,'A') =
342: nvl(p_rtg_revision_rec.alternate_routing_code,'A');
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: l_token_tbl.delete(2) ;
347:
348: Error_Handler.Add_Error_Token
349: ( p_mesg_token_tbl => l_mesg_token_tbl

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: );
374:
375: EXCEPTION
376: WHEN NO_DATA_FOUND then
377: x_return_status := FND_API.G_RET_STS_ERROR;
378:
379: Error_Handler.Add_Error_Token
380: ( p_mesg_token_tbl => l_mesg_token_tbl
381: ,x_mesg_token_tbl => l_mesg_token_tbl

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: TRUNC(NVL(p_rtg_revision_rec.start_effective_date,SYSDATE))
402: < TRUNC(SYSDATE)
403: )
404: THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: l_token_tbl(3).token_name := 'START_EFFECTIVE_DATE';
407: l_token_tbl(3).token_value :=
408: to_char(p_rtg_revision_rec.start_effective_date);
409: Error_Handler.Add_Error_Token

Line 446: x_return_status := FND_API.G_RET_STS_ERROR;

442: AND process_revision > p_rtg_revision_rec.Revision
443: );
444: EXCEPTION
445: WHEN NO_DATA_FOUND THEN
446: x_return_status := FND_API.G_RET_STS_ERROR;
447: l_token_tbl(3).token_name := 'START_EFFECTIVE_DATE';
448: l_token_tbl(3).token_value :=
449: to_char(p_rtg_revision_rec.start_effective_date);
450:

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466: AND organization_id = p_rtg_rev_Unexp_Rec.Organization_Id
467: AND process_revision = p_rtg_revision_rec.Revision;
468: IF trunc( l_effectivity_date) <= trunc(SYSDATE)
469: THEN
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: Error_Handler.Add_Error_Token
472: ( p_message_name => 'BOM_RTG_REV_CANNOT_DELETE'
473: , p_mesg_token_tbl => l_mesg_token_tbl
474: , x_mesg_token_tbl => l_mesg_token_tbl